Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Help with architecture of Drupal 7 Sports Management site.

Posted on 2013-01-29
9
Medium Priority
?
674 Views
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?
sports-architecture.png
0
Comment
Question by:Modifier1000
[X]
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
9 Comments
 
LVL 17

Expert Comment

by:nanharbison
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?
0
 

Author Comment

by:Modifier1000
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.
0
 
LVL 17

Accepted Solution

by:
nanharbison earned 2000 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:
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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:Modifier1000
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.

http://drupal.org/project/computed_field
0
 
LVL 17

Expert Comment

by:nanharbison
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?
0
 
LVL 17

Expert Comment

by:nanharbison
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.
0
 

Author Comment

by:Modifier1000
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 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
 
LVL 17

Expert Comment

by:nanharbison
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.
0
 

Author Closing Comment

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

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

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 choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

715 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