Database/ Script
Web Script:PHP/MYSQL
We are after a script to do the following:
For each user that logs in it will keep a separate database of the following
1. Keep a customer database
Including all the usual stuff Plus the following:
a) Appliances they have (each appliance should be able to have an anniversary date set (expressed in days i.e 90 Days since last, the last date will be automatically updated when Anniversary Job Record is created, so it will email us when due, With the Record (appliance details and customer details ) + five additional Aniversary Dates Where (details are customisable)
b) Where they got our details, to contact us
c) All The Jobs They have had done (By Job Number)
d) A Notes Section for their notes
e) An Invoice Section (We will want to upload PDF Invoices here and mark them as either paid and unpaid) (Two Headings of Paid and Unpaid (With totals Section)
2. A Landlord Section As above Except (we record there details and they will have Customers that will then have appliances etc (invoicing should be grouped per landlord but when uploading invoice as well as entering an amount for the invoice and marking as paid and unpaid, we should be able to select which property it is for
3. Form Menu (Must be easy to add or change these forms) Suggestion use Templates (Xhtml/CSS)
We have attached 12 Jpg for forms we commonly use, we need to be able to Web Base fill these forms out (I phone, Laptop, Desktop, Blackberry), it should record their data and Auto-populate Appliance Fields and Name/ Address and Landlord Details based on the customer / Landlords Property Selected, once filled in we need to be able to retrieve them from the forms menu and each individual customer / landlords sub menu and print them to PDF for Web Download and or email them online.
We should be able to do the following:
Reports:
a) Select a Job and get all the details for it a printed report with customer details appliance(s) worked on and all the details
b) A property Report to print a list of properties owned by a landlord/agent
c) See all jobs completed in a Range
d) Search Customer Database Including landlord/ agents by Postcode
e) Search Customer Database Including landlord/ agents by Telephone
f) Search Customer Database Including landlord/ agents by Surname
g) Search Customer Database Including landlord/ agents by appliance(i.e an appliance my make or model)
h)
Full Source Code
Full Copyright no reselling
Debugging and Support]
You must make it look pretty as well as function (skinable would be nice)
You must be prepared to work with us to deliver the script/datbase we require, ask as many questions as you need)
