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:
login.php – login for admins, agents, and users –
when a user logs in, user will be directed to index.php
when an admin or agent logs in, he will be redirected to admin/index.php
signup.php – 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.
index.php – 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.
index.php – 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 update.php
update.php – 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
delete.php – only admin can access – use javascript alert to confirm before deleting work order
admin.php – only admin can access – may create new agents or delete agents
Important: All files MUST have include statements for header.php 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.
