Freelancer

Description

I own a security company in Arizona and we are trying to develop a dispatch console for our officers in the field that is quite similar to a police departments computer aided dispatching system, but just not as elaborate. We would like it tied into an employee management database, and client management database all accessible from our joomla! website. We have PHP5 and MySQL, and have a very poorly done MS Access database that was slapped together to get things rolling, but we do not have the knowledge to get it totally functional. The features we are looking for are:

Database Wide Features:

* Ability to Attach Photos
* Ability to Attach Documents (PDF, Word - - Maybe Have Them Viewable?? - - Not Important, As Long As They Can Be Attached)
* Automated Backup or ability to manually back up
* Date Reminders and Alerts (For Things About to Expire, Time and Welfare Checks on officers in the field Alerts)
* Welfare Check Reminders For Units On Scene (i.e. A Countdown Timer For An Alert When A Unit Is Assigned A Call)
* Edit Log (Who Did What at What Time and When and If Possible, From Where - - IP Logging?)
* Editable Phone Directory
* Online Form Fillable Reports (Officer In Field Able To Go Online and Fill Out A Report to be Attached to a Specific Call Record)
* Cross Referencing of Information (Property History Report, Employees Assigned to Which Call, etc.)
* Single Log In, Access Granted By User
* Multiple Simultaneous Access (i.e., Officers In Field Can View Pending Calls For Service, and Updates to Calls as Dispatcher Makes Notes ect.)


Access Levels:

* Administrator - All Access (Add, Edit, Delete)
* Supervisor - Access to Contact and Training Records of Employees, and All Access to Call For Service Information (Add, Edit)
* Dispatcher - Access to Employee, Customer and Call For Service Information (View Only on Employee & Customer, Add, Edit Call For Service)
* Officer - Access To Call For Service (View and Upload Photos and Documents to Existing Call Records)



Sections Available

Company Information:

* Contact Information
* License Information (Advance Alert For Expiration Notification)
* Corporation Documents Information
* Insurance Information (Advance Alert For Expiration Notification)


Employees:

* Contact Info
* Training Courses with certification number, expiration and alert when expiration is soon due, where course was taken
* Tax Information
* Equipment Issue With Sizes, Types, Serial Numbers, Quantity and Price Value of Each Item
* Employee Photo
* Employee Rank
* Employee Number (Radio Call Sign i.e. 311) - primary key?
* DTG (Date and Time Group) Stamped Notes Section
* Hire & Termination Date


Customers:

* Contact Info
* Emergency
* Billing, Invoicing, Payment History (Alert for Billing i.e. invoice due, late payment ect)
* Daily Activity Report By Property Location (From CFS, Which Is Also Reportable By Date)
* Contract Information (Document Attached and Alert for Contract Expiration)
* Record of Each Contact With The Client (Communication Log)
* DTG Stamped Notes Section


Call For Service (Dispatch):

* Ability To Enter The Following Information Received From a Citizen Via Telephone, and Updated By Communication From Responding Officers (CFS Notes on each record) (Single Screen):
o Auto Generation of DTG Upon Recipt of Call (primary key, YYYYMMDDHHMMSS)
o RP (Reporting Party) Name
o RP Contact Number
o RP Want Contact, if yes, location of the RP?
o Property Incident Is Occuring (Auto Populated with Address Upon Selection Of Property Name From a List of the clients)
o Type Of Call (Burglary, Trespasser, Unknown Trouble, ect.)
o Weapons Involved? (Y/N)
o Ability to Assign a Priority Level ( i.e. 1, 2, 3)
o Ability to Assign a Responding Officer, and Additional Officers as Needed
o DTG Stamp of When Call Was Dispatched to the Responding Officer(s)
o DTG Stamp of Officer Arrivals
o DTG Stamp of Notes Section as Officer Contacts the Dispatcher with Updates
o Ability to Attach Photos and Documents with DTG Stamp
o Specific Box to Input Police/Fire/EMS Report Numbers and Police Officer Names
o Suspect Information - Allows for Multiple Entries (Also Auto Populates This Information into an Additional Section for Contact History - Ability to Specify if One Particular Suspect is Trespassed, and if so, Auto Populates This Information into an Additional Trespass Section for Trespass History)
+ Name, DOB, SSN, DL or ID Card Number, Address, Phone, Identifying Marks, Height, Weight, Eye Color, Hair Color, Clothing Description, Photo of Suspect
o Victim Information - Allows for Multiple Entries (Also Auto Populates This Information into an Addtional Section for Contact History)
+ Name, DOB, SSN, DL or ID Card Number, Address, Phone, Identifying Marks, Height, Weight, Eye Color, Hair Color, Clothing Description, Photo of Victim
o DTG Stamped Disposition Code From Officer
o DTG Stamped Officer Note Information (Not Generated on a Report Given to Clients)

* Trespasser Database (Some Information Can Be Auto Populated From The Originiating CFS Record)
o Suspect Information (Auto Populated From CFS Record with the Additional Information Below)
o DTG Stamped Notes Section for Brief Description of Events
o Police Report Number (DR and or IR) and Officer Name - Allows for Multiple Entries
o Image of Trespass Card from the Police (Scanned In - ? Auto Populated from CFS Record ?)
o Property and Address of Location of Trespass (Auto Populated from CFS Record)
o Responding Officers Names & ID Numbers (From Our Company, and Allows for Multiple Entries - Aut Populated From CFS Record)

* Ability to Pull CFS Records
* Ability to Link Multiple CFS Records (to show pattern of behavior by property, person, officer)

Reports (Can be Searched For By Date/Time, Any Name or Report Number, Property or by The Individual Who Entered The Data, i.e. Dispatcher)

* Calls For Service Records (By Property, Officer, Date, Call Type, Specific Suspect/Victim, Police DR Number)
* Employee Records (Contact Roster, Training Records, Expiration Dates, Terminations, Hire Date)
* Client Records (Contact Roster, Emergency Contact Roster)
* Billing (Monthly Totals, Invoices Sent by Total, Payments Received by Client, Past Due Accounts)
* Trespasser Records (List Trespassers by Property)
* Victim Records (List Trespassers by Property and or Call)
* Suspect Records (List Suspects by Property and or Call)


And much more - maybe.... Time is not very important, would like to have it displayed for working at night, such as a black background with white lettering, or something to that effect.

We would like to have someone that has specific knowledge about joomla! and MySql as that is what we've got to work with from godaddy.com. The project will be considered a confidential one, and this would be proprietary work on your end. If you would like to maybe sell this as a product, we can work a deal and I can get you pointed in the right direction.

We would present half of the payment up front, half when completed. Payment will be in the form of PayPal unless you take credit cards over the phone!

We would like to see progress reports, but its not vital. As stated before, time is not THAT important, but we would like to see a 6-8 month or less return on this.