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
Create and Edit Enquiry
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 status-wise enquiry
Unfulfilled Enquiry – Driver/Handyman not assigned