Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 677
  • Last Modified:

Help with architecture of Drupal 7 Sports Management site.

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?
sports-architecture.png
0
Modifier1000
Asked:
Modifier1000
  • 5
  • 4
1 Solution
 
nanharbisonCommented:
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?
0
 
Modifier1000Author Commented:
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.
0
 
nanharbisonCommented:
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:
http://modulesunraveled.com/organic-groups
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.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Modifier1000Author Commented:
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.

http://drupal.org/project/computed_field
0
 
nanharbisonCommented:
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?
0
 
nanharbisonCommented:
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.
0
 
Modifier1000Author Commented:
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 setup...so 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.
0
 
nanharbisonCommented:
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.
0
 
Modifier1000Author Commented:
Thank you, this site for OG's should help guide me on the OG architecture.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now