Activity Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Activity Management System

Activity Management System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Activity,Users,Timeslots,Attandance,Particiapants. Admin user can manage all the operations of Attandance,Particiapants,Activity,Activity Type,Users and their details. Admin can create different type of reports of Activity,Users,Timeslots,Attandance,Particiapants according to their choise and filters. You can Download PHP and MySQL Project Activity Management System with source code and database from this site. We also provide Project Report of Activity Management System.

Functionalities and their descriptions of Activity Management System are as follows:

  • You can search records on various criterias. Such as Activity, Timeslots, Attandance, Particiapants
  • Create, read, update and delete (CRUD) application has been implemented on Activity,Users,Timeslots,Attandance,Particiapants
  • Keep the track logs of Users, Activity Type, Attandance ect
  • Advance search has been implemented on Users,Activity Type, Attandance
  • You can see all the details of the Activity, Timeslots, Activity Type, Attandance
  • All the modules Activity Type, Attandance, Users,Particiapants, Activity are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Attandance.
  • All the Users,Activity Type, Attandance modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Activity data.

Modules of Activity Management System and their descriptions:

  • Activity Module : Manage all the operations of Activity
  • Users Module : Manage all the operations of Users
  • Activity Type Module : Manage all the operations of Activity Type
  • Timeslots Module : Manage all the operations of Timeslots
  • Attandance Module : Manage all the operations of Attandance
  • Particiapants Module : Manage all the operations of Particiapants

Classes and their methods of Activity Management System:

  • Activity Methods : addActivity(), editActivity(), deleteActivity(), updateActivity(), saveActivity(), searchActivity()
  • Users Methods : addUsers(), editUsers(), deleteUsers(), updateUsers(), saveUsers(), searchUsers()
  • Activity Type Methods : addActivity Type(), editActivity Type(), deleteActivity Type(), updateActivity Type(), saveActivity Type(), searchActivity Type()
  • Timeslots Methods : addTimeslots(), editTimeslots(), deleteTimeslots(), updateTimeslots(), saveTimeslots(), searchTimeslots()
  • Attandance Methods : addAttandance(), editAttandance(), deleteAttandance(), updateAttandance(), saveAttandance(), searchAttandance()
  • Particiapants Methods : addParticiapants(), editParticiapants(), deleteParticiapants(), updateParticiapants(), saveParticiapants(), searchParticiapants()

Database tables and attributes of the Activity Management System:

  • Activity Entity : Attributes of Activity are activity_id, activity_title, activity_type, activity_date, activity_description
  • Users Entity : Attributes of Users are user_id, user_name, user_mobile, user_email, user_username, user_password, user_address
  • Activity Type Entity : Attributes of Activity Type are ac_id, ac_title, ac_description
  • Timeslots Entity : Attributes of Timeslots are time_slot_id, time_slot_name, time_slot_duration, time_slot_type, time_slot_description
  • Attandance Entity : Attributes of Attandance are attandance_id, attandance_user_id, attandance_date, attandance_descriptioa
  • Particiapants Entity : Attributes of Particiapants are particiapants_id, particiapants_name, particiapants_mobile, particiapants_email, particiapants_username, paticipants_password, participants_address

Database definition of Activity Management System:

  • The details of Activity is store into the Activity tables respective with all tables
  • Each entity (Particiapants, Activity Type, Attandance, Users, Activity) contains primary key and unique keys.
  • The entity Activity Type, Attandance has binded with Activity, Users entities with foreign key
  • There is one-to-one and one-to-many relationships available between Attandance, Timeslots, Particiapants, Activity
  • All the entities Activity, Attandance, Activity Type, Particiapants are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Activity Management System tables for fast query execution.

Super admin functionality of Activity Management System:

  • Admin can add, edit, delete and view the records of Activity, Attandance, Activity Type, Particiapants
  • Admin can manage all the details of Users, Activity Type, Timeslots, Attandance
  • Admin can also generate reports of Activity, Users, Activity Type, Timeslots
  • Admin can search the details of Activity, Attandance, Activity Type, Particiapants
  • Admin can apply different level of filters on report of Activity, Activity Type, Particiapants
  • Admin can tracks the detailed information of Attandance, Particiapants, Activity, Users

Report of Activity Management System:

  • Generates the report on Activity Type,Timeslots,Activity,Users,Attandance,Particiapants,
  • Timeslots,Attandance,Particiapants has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Timeslots,Attandance,Particiapants
  • Excel Sheet report has also been integrated for Users,Timeslots,Particiapants
  • You can create the CSV reports for Activity,Attandance,Activity Type

Limitation of Activity Management System

  • Run time report generation is not available in Activity Management System.
  • We have not implemented the dynamic report for Activity,Timeslots,Attandance,Users,Activity Type,Particiapants
  • This project Activity Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Activity, Timeslots, Particiapants cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Activity Management System

  • We have added all the validations for input value on the modules Activity,Users,Activity Type
  • Timeslots,Attandance,Particiapants can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Activity,Activity Type,Particiapants
  • CSRF token has also been implemented on Timeslots,Users,Activity, Attandance,Particiapants
  • All the Activity,Timeslots,Attandance,Users,Activity Type,Particiapants has integrated with captcha for spam protections
  • Access level validation has been implemented on Particiapants,Attandance,Timeslots
  • Number and character validation has also been implemented on Activity Type,Attandance,Activity

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database