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.
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.


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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Recently I spent hours debugging an issue in a Rails project where ActiveRecord was causing MySQL errors trying to create a User object of a class at the top level of a Single Table Inheritance model structure.  It turns out `.create` behaves differ…
Read about how to approach blogging and about ways to do it right. Stand out from the crowd and let your knowledge be consumed by a large audience. This article aims to explain how your blog should look like,  the most important things to do while b…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

763 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