I need a plain text website and back-end database. The citation management system shall allow:
1. Officer access - query existing database if vehicle has had previous citations, if yes, provide a tow alert message.. Store date/time of query. Ask later for more details about their query on a data-entry screen. Store all data for future inquiries by officers and supervisors. Send automated emails for vehicles that may or have been towed, based on officer's input. License plate queries should include close matches from the database (70% or better).
2. Supervisor access - shall define data sets for drop down boxes, be able to search a license plate for tickets without generating a future data entry as the officers would, export all or some data in CSV format, add/remove Officer accounts, add/remove additional Supervisors. This level of account can also edit any type of data.
Prior to inquiring and adding a license plate to the database, license plate must go through a verification process. Most license plates will be in the following formats: 1ABC123 or 12345A1 or 1A12345. If not, the user shall be questioned if this is a "VIN Number" (must enter 6 numbers), "Personalized" (any combination of letters and numbers), "Other" (any combination of letters and numbers), or "Out of State" license plate (any combination of letters and numbers). If out of state, they shall specify a state (49 state drop down list, excluding California, which is the default for all other entries).
Upon entering the "Data Entry" screen, all citations should be preceeded by any TOW ALERTS. If a prior TOW ALERT message was previously provided, the officer shall be asked - was this tow successful? If yes, he is to enter additional data as above with citations. Once submitted, an successful tow email shall be generated to the same email as above. This email shall include the towing data, plus the previously related citations. The next confirmation screen shall also provide a (supervisor defined) phone number to call and notify the Sheriff. Upon completion of the phone call, the officer shall enter a "person notified" and "badge/ID number". The date and time of the submission of this data shall be prefilled. The important data shall be stored with the TOW ALERT. A successful TOW ALERT shall "flag" the prior citations that qualified this as a TOW ALERT (2 prior citations in the past 365 days). This flag of a successful ("yes") tow shall no longer apply when querying the vehicle again in the future. Their tow "count" is basically "re-set" once they are towed. Now they have to get 2 more citations before the can get another TOW ALERT.
If the officer selects NO, the tow was not successful, the officer shall be directed to the usual citation data entry screen. Except the first field shall ask "Why was this vehicle not towed?" This will also generate an email. This data shall also be saved.
Once system is fully tested and running smoothly, we require you to import the previous 1,384 citations we have written in the last year. It is available in an Excel spreadsheet with the above listed data (citation number, date, time, address, license plate, vehicle make, vehicle model, vehicle color)
Would gladly work on your project. Will use php/mysql. Have done a lot of similar projects before. If needed I can do site with ajax or without one - however you want.
$187 USD in 3 days
5.0 (12 reviews)
4.4
4.4
13 freelancers are bidding on average $301 USD for this job
I will make plain text website and back-end database. I read all your requirement and i can easily do it.
i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level
Hello,
I have 12 years of web development experience and I can develop your Citation Management System
in PHP and Mysql for the quote given. I will also import the previous records that are in excel file with you.
Looking forward to hearing from you.
Regards,
Abid
Hi, i can build this system for you, and also import the previous citations in to it. I will build a smooth and very user friendly and fast interface for searching and administrating the citations/cars/