Get a Freelance Job

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)

I need a program, where I can enter, edit and display info according to the attached scan.

Here is more detailed information.

Customer name
This is the main information. All other entered information is always related to one customer.

Sales person
The sales person in charge for this customer

CM
The contract manufacturer

Project name
The project name

Demand
The annual qty needed

Sales price
Our sales price per piece

Purchasing price
Our purchasing price

Chance
The chance of getting the business

Turnover
qty * sales price

Profit
(qty * sales price) – (qty * purchasing price)

Production start
The date the production should start

Part
Our part number and description
There can be multiple parts linked to one customer

Comments
All entered comments

I would like to be able to search for all the information individually.

Customers should have a up down arrow next to them so that I can just jump to the next alphabetical customer.

On parts I should have a up down arrow next to them so that I can just jump to the next alphabetical part.

Please write me in which programm you will write this software.
It has to be a standalone software.

At the end of the project the original source code and the compiled version need to be handed over to me before the payment is made.

All the information is supposed to be saved in a file that can be named by a user. If another User has this program he should be able to load any desired database into his program.

Please do not send referecens unless I ask for them.

Let me know if there are any questions.

This program should be original coding, so no open source or existing codes!!!

We are after an access database to store customer details on, job details and the appliances these customers have as well as generate auto-reminders and print cards and letters informing people when regular maintenance is due.

Attached is a rough spec, to give you an idea of what we are after,

Please cost including the Invoicing, but in the PMB tell us how much for the database no invoicing.

It doesn’t have to be over complicated, just look good, hold the data and do exactly what we want with it,

I have posted this before but have been let down, I want good quality work with speed.

Payment via SL at end of project
Full copyright will be ours after project, including all source code, which must be made available to us

Additional Information Missing from PDF

Works Report (i.e Pick a job and get a report of the job, all the details customer details, and all the info from the job record) (Could be selected from the customer screen)
A Property report see all the properties that a landlord owns
See all jobs completed within date ranges

A few Searches to find customers
Find by postcode
Find By Telephone
Find by Surname
find by Appliance (i.e Select Type of appliance then manufacturer then type in model)

Only other bit of information is in the customer details add a field how they found us (and pulled from a table) to find how the customers got our details

i.e
Thompson Local
Yellow Pages
Corgi site
Recommendation (*If this one is selected it would be nice to be able to type who recommended them)
etc.

You must be willing to work with us to make the system work how we want, it’s impossible to write everything down our suggestion is to build the shell and get it working then leave us to test for 48 hours and we will then know what is missing.

Thanks

We are after an access database to store customer details on, job details and the appliances these customers have as well as generate auto-reminders and print cards and letters informing people when regular maitenance is due.

Attached is a rough spec, to give you an idea of what we are after,

Please cost including the Invoiceing, but in the PMB tell us how much for the database no invoicing.

It doesn’t have to be over complicated, just look good, hold the data and do exactly what we want with it,

I have posted this twice before but have been let down, i want good quiality work with speed.

Payment via SL at end of project
Full copyright will be ours after project, including all soruce code, which must be made avaliable to us

Additional Information Missing from PDF

Works Report (I.e Pick a job and get a report of the job, all the details customer details, and all the info from the job record) (Could be selected from the customer screen)
A Property report see all the properties that a landlord owns
See all jobs completed within date ranges

A few Searchs to find customers
Find by postcode
Find By Telephone
Find by Surname
find by Appliance (I.e Select Typoe of appliance then manufacturer then type in model)

Only other bit of information is in the customer details add a field how they found us (and pulled from a table) to find how the customers got our detials

i.e
Thompson Local
Yellow Pages
Corgi site
Recommendation (*If this one is slected it would be nice to be able to type who recommended them)
etc.
Thanks