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.
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!


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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to set up query to pull Magento customer information 6 64
PHP Code ignitor 4 66
Error can not open stream in laravel 13 111
Wordpress: understanding links 4 88
In this article, we will look at our content management system as a whole, to get an idea of how we will start to manage these content items.
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
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…

734 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