Closed

334512 Custom PHP/ MySQL Script

This project was awarded to atozcoders for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
N/A
Total Bids
1
Project Description

OK, here goes. I need a custom PHP/ MySQL "work order" script.
I'm swamped with work, and I need this done ASAP, preferably by Wednesday, at the latest.
You will receive full CPanel access to an empty site on my server to complete the project.
Work and testing MUST be done on my server - no exceptions.
Low bids with verifiable experience will be given preference.
By bidding, you agree that I own all rights to the script, and may use, modify, or sell it,
as I see fit.
I will pay immediately via PayPal upon acceptance of the script,
after testing as admin, agent, and user. No deposits, no escrow, no exceptions.
I will give a feedback rating of 10, if this is done to specifications and on time.

The MySQL database will have 4 tables and about 50 fields, total.
You will have full CPanel access, including Legacy File Manager and phpMyAdmin.
The tables are only suggestions - if you can use fewer tables, that's fine.
Details:

Table 1:
users

Fields:
username
password
(note: users may only view their submitted work orders, updates, images, and docs)

Table 2:
admins

Fields:
username
password
priveleges
(note: admin has full access; agents may view work orders, add updates, images, and docs, but may not delete data)

Table 3:
uploads - admin and agents may upload photos of the work performed for users, as well as other documents. These documents will be written to an images folder and a docs folder. Users may upload images or docs with signup form

Table 4:
user_data - 27 unique fields, including the id field, which will be auto-incremented. actual fields will be provided to the winning bidder - several are date fields

The PHP files:
[url removed, login to view] - login for admins, agents, and users -
when a user logs in, user will be directed to [url removed, login to view]
when an admin or agent logs in, he will be redirected to admin/[url removed, login to view]

[url removed, login to view] - signup form for users - I will provide a mostly-completed form. You will add uploads and change form as needed.
This form will write the 27 fields of user data, including the username and password, plus any uploads to the database and the appropriate folder.

[url removed, login to view] - when logged in, a user will be able to see his work order, updates, and images (with captions) that pertain to his work order.
user will be able to download docs that are attached to the work order
user will never be able to see other users' work orders or information.
If user has multiple work orders, user will be able to select one from the group, via dropdown menu.

admin folder - accessed only by admin and agents.
[url removed, login to view] - admin/ agent will be able to view id number, completion status, username, and address for all work orders. admin/ agent can select a property to update and is taken to [url removed, login to view]

[url removed, login to view] - admin/ agent can view work order, write a text description of work done and upload unlimited "before" and "after" photos with captions, and documents with captions.
Information will be dated with date and time values.
admin/ agent can add more data to the update by accessing this page again -
old data is retained and not overwritten

[url removed, login to view] - only admin can access - use javascript alert to confirm before deleting work order

[url removed, login to view] - only admin can access - may create new agents or delete agents

Important: All files MUST have include statements for [url removed, login to view] and footer.php.
I will place a generic header and footer on the server in the public_html directory.
That's it. Not too hard if you're well-versed in PHP/ MySQL.
I hope to choose a winner this later evening, so bid soon.
P.S. I'm a provider on SL, with excellent feedback. Nothing recent, though, as I've been too busy.
Please only bid if you agree to the terms as stated and can complete this within 3 days.
I'm not interested in an open-source or pre-made script. This must be custom.
If you have any questions, please ask.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online