Help with architecture of Drupal 7 Sports Management site.

Posted on 2013-01-29
Last Modified: 2013-02-08
Hello Experts,

So I need some help/ideas as to how to start development on a site that would be new to me in regards to architecture.

The site is a Sports Management System with one side managing the Finances while the the other manages the actual teams.

There are two types of user:  Finance Users & Sport(Team) Users

The users will login as the type of user they are and go to that side (Finance or Sports).

The Finance Side has 3 Groups that get money from one pot of money.  Each group then can transfer money to the sport they manage financially.

The Sports side has 3 Groups.  Each group can get money from their respected Financial group and they can disperse the money to any of their own subgroups.

So...any ideas as how to actually lay this out in Drupal 7?
Question by:Modifier1000
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
LVL 17

Expert Comment

ID: 38835808
For starters, I would say you need two types of content, finance and sport, and the two kinds of users have permission to view their own content, finance user gets to view finance content. Or do the three groups of finance users need to only be able to view pages that are related to their group?
And is money being transferred on the website? And if so,  how is it getting there?

Author Comment

ID: 38836138
First, thanks for responding...this is a very important project and I'm stuck on the architecture as you can tell.

More info:
2 roles for the Finance side:  Manager and Analyst
3 roles for the Sports side:  Manager, Analyst, and Authenticated Read-Only

The Finance side can view each others data except the Money Pot which can only be viewed by the Finance mgr, the Sports side can only view their own group info.  Each Sports subgroup can only view their subgroup.

Money is being added by a Finance Manager.  To add money to a Money Pot, he/she will disperse a portion of the Pot into each Finance Main Group (OG Football, OG Baseball, and OG Volleyball).

Each Finance Analyst (OG admins) of the main Finance OG groups will push money to their OG subgroups.  Each Analyst (OG subgroup admin) of the OG subgroup will then push the money to each Sports OG Group related to their group.  

The Sports OG Group can then push a portion of their money to their subgroups.  Subgroups can only view money for their group only, no others.
LVL 17

Accepted Solution

nanharbison earned 500 total points
ID: 38849009
I didn't notice in the beginning that you are using organic groups. You want a content type for each kind of group you have, including the subgroups if it matters that they cannot see each others content.
Great tutorials on setting this up:
I am not sure how you are dealing with the money part of the website, how the money will be transferred based on what happens on the website.
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users


Author Comment

ID: 38860340
Thanks for the link!

To answer your question on the money part, I am not completely sure yet.  I could use some tips.  That's obviously the most sensitive part of this application.

So far I plan on using the Computed Fields module, I guess, to help calculate the money.
LVL 17

Expert Comment

ID: 38860399
But is the site going to actually MAKE the money transfers, or just theoretically and someone then gets an email about it and that person has to transfer money to the correct account?
Does each group have a separate money account?
LVL 17

Expert Comment

ID: 38860450
I personally think access to money through a website is extremely risky unless you are a web security expert or you could afford to pay thousands of dollars to have it developed really securely.

Author Comment

ID: 38860715
I agree on the 'risky' part, but it will be setup on a internal box with access to the site having to be secure too.

The 'secure' thing is not really as big a deal to me as a publicly available site.  Money is not an issue, plus quite a bit of money was dumped into IT for security all I have to do is get this application to work.

I may be a bit unclear on your question as to the money handling, but basically this program will get an amount in the pot and the admin/certifying officials will place money to the departments.

Money in the subgroups is tracked for auditing purposes.  Auditing is key here too.
LVL 17

Expert Comment

ID: 38861101
My question about the handling the money is probably a moot point. You might want to ask another question about handling money in bank accounts via a website. I have no idea how to do that.

Author Closing Comment

ID: 38868063
Thank you, this site for OG's should help guide me on the OG architecture.

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi,      I've been learning Spring and Jersey for the past few months and to say in simple, i am pretty much impressed with these frameworks. Many developers feel it awkward to implement a RESTful Web Services with such a popular Web Application Fr…
In this blog, I will share you some basic tips for content marketing and to rank your website on Google.
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question