Charity Job Management System

Business Needs

UK based client came up with a concept for senior citizens in the UK to make their day to day life easy with the association of charity concept. He was looking for a solution where he can provide an environment for old age people who can call and ask for handyman service or pickup service. The solution was derived using Yii Framework, MySQL, and JQuery. The solution was targeting specific client’s need such as inquiry management, driver & handyman database, worksheet management and custom reports. The system was created in a robust way which can handle live inquiries from customers and can fetch the data upfront for any existing customers who have already stapled inquiries. Time management was the crucial task for the system in a way appointment should be taken care by the system for handyman which must not conflict with any other job, and the driver/handyman can serve the need in the best possible way with a single inquiry at any point of time. Associated people with this service such as drivers & handyman were only covering the expense of their transport and not targeting the profit which made this solution charity friendly. Senior citizens could benefit from this service for any urgent assistance needed by just one call away.

Technology Skill Set

  • JQuery
  • MySQL
  • Yii Framework
  • Bootstrap

PSSPL Solution

  1. Login 
    • Enquiry:
    • Create and Edit Enquiry
      • Assign client
      • Auto-populate client detail based on client family name
      • Add or Edit client based on contact number
      • Auto-suggest the available driver/handyman based on requested enquiry time
      • Assign driver/handyman from available list or from all driver/handyman
      • Get details of already assigned inquiry to a particular driver/handyman
      • Add new location or select existing location
      • Allow saving unfulfilled enquiry (without assigning any resource)
      • Allow creation of multiple enquiries back to back – default time slot 3 hours
      • Manage call log
    • Display Enquiry
      • Display status-wise enquiry
      • Unfulfilled Enquiry – Driver/Handyman not assigned
      • Outstanding Enquiry – Resourced (Driver/Handyman assigned)
      • Outstanding Enquiry – Resourced, Client
      • Enquiry Fulfilled – Enquiry completed by driver/handyman but waiting for donation and expense claim
      • Enquiry Fulfilled – Awaiting donation
      • Enquiry Fulfilled – Awaiting expenses claim
      • Totally Complete Enquiries
        • Assign resources to unfulfilled enquiries
        • Filter enquiry based on date range
        • Export to CSV
        • Sort and Search feature
    • Change Enquiry Status
      • Cancel Enquiry by entering reason
  2. Donation and Mileage Claim
    • Change status of Enquiry based on donation/mileage entered or change automatically
    • Insert data of donation received and material cost for handyman 
    • Insert data of mileage claim and donation received by driver
  3. Send email notification to the client regarding assigned driver/handyman. Also get the notification about the cancellation.
  4. Send email notification to driver/handyman for the assigned/ canceled job.
  5. Manage Client (Add, Update, Delete, View) – Contact Management
  6. Manage driver and handyman (Add, Update, Delete, View)
  7. Insert time slot details for drivers and handyman – Time sheet given by client at the end of week/month
  8. Reports with data range and CSV export
    • Client report 
    • Car transport report 
    • Handyman report 
    • Gift aided donation 
    • Non-gift aided donation 
    • Total donation received 
    • Total expense claims 
    • Banking report 
  9. Settings
    • Manage DO (Add, Update, Delete) and give system rights 
    • Change password 
    • Location Management 
    • Mileage rate setting to calculate expense 
    • Change service type (default transport and handyman) 


  1. One stop solution for senior citizens, they almost get all services on Charity portal
  2. Helpers get real-time message notification
  3. Users traffic is very well managed

Copyright © Prakash Software Solutions Pvt. Ltd. All Rights Reserved.