Drupal for private lessons management
Hi folks,
I have been using Drupal (6.x) for a few months now. I am very pleased to have found this CMS, since I believe it is awesome. Until now, everything that I have been looking for, I have found it. Currently I am migrating my company's website and I have created two customers' websites with Drupal. I have been using many different modules, starting with CCK and Views.
I need to create a new website and I do not know if Drupal is the correct answer. I believe that it is, but I do not envision how to do it. Let me explain what I need.
My customer is a company that wants to sell private lessons to students that need extra help. Besides the typical web that shows my customer's company and services, I need to create a private part for the teacher to communicate with the students/parents. I have seen the gradebook module, but I do not feel that it is well suited for me.
The teacher will write regular reports about the students. This is quite easy with CCK: different fields and a userreference. However, I want that, obviously, each student only sees its own reports. I can use Views for that, but, what if a student sends a URL with his report to a friend? I want to block the friend from viewing the report, even if he is a student too. How can I do that? In other words, I want that each node of type "report" can only be viewed by the student that has received the report. I have seen Content Access module for this, but I have never used it. The company wants to keep track of the evolution of the students, so the teacher will write another (longer) report that should only be viewed by the company staff.
Each lesson will have its own identifier or coupon. Every student/parent will be given a list of coupons, so as to show that they have already paid for the lesson. This coupon must be included in the report. Is there any module to create coupons for this? Ubercart seems to have a functionality for this, but I will not use Ubercart. Moreover, I want to check that the coupon is valid.
Altogether, there will be four roles: student, teacher, staff and admin. Only the admin and staff will be allowed to create new users. Is there any module that extends the user profile to include name, address and the like?
Finally, I would like to assign each student to a teacher. Is there any module that creates relations between users?
To sum up:
- Any suggestions on how to restrict the access on a per-node basis?
- Any coupon module or will I have to make my own module?
- Which modules would you use to extend a user profile?
- How to make relations between users?
Thank you very much for your help,
Pedro

_
1) I believe you should be able to handle this with content_access or nodeaccess.
2) The only one's i know of are associated with ubercart or ecommerce.
3) There's the core profile module for simple user profiles or the content_profile module which turns user profiles into full fledged nodes which can then make use of cck and views (also may make #4 easier since you can then use nodereferences to make the relationships).
4) these modules are a bit up in the air, but i believe the http://drupal.org/project/user_relationships is emerging as the one to use (it even has a node access component that might help with #1).
I would definitely do this with drupal!
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.
Thanks
Hi WorldFallz,
Thank you very much for your answer. It is incredible how the community works. Much better than a commercial company. I really appreciate your help. I will give Drupla a try for this too.
Pedro
_
glad you found it useful.. good luck. And be sure to post back to the showcase forum when you finish your site.
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.