Dispatch and Employee Records

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)


* 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


* 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 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.

Skills: Electronic Forms, Joomla, PHP, SQL

See more: joomla dispatch, image identifying amp date, records employees joomla, would hire activity, background checks show, radio hire company online, suspect description form, sign things online, service management group, security officer, security notification service, scene contacts, roster management system, radio hire, radio equipment hire, property id, police hire, police dispatcher, police dispatch, php mysql pdf, photo edit hire, past code online, party equipment hire, online report generation, online php courses

About the Employer:
( 0 reviews ) Mesa, United States

Project ID: #541217

33 freelancers are bidding on average $1381 for this job


Hi, please check PMB to know more about our technical expertise and capabilities. Regards

$3840 USD in 60 days
(14 Reviews)

Hi, Ready to start the job. Pls check PM to see our recent work. Thanks, Indisoftware

$1250 USD in 35 days
(8 Reviews)

The Work will be done according to your requirements. Please check our PM. Thanks.

$2500 USD in 30 days
(14 Reviews)

Please refer our portfolio mentioned in PMB

$900 USD in 20 days
(8 Reviews)

i can do it in a mentioned time

$945 USD in 15 days
(8 Reviews)

hi, I have just sent you a pmb, pls check and happy new year, Best regards, TG Shakthi

$1045 USD in 33 days
(6 Reviews)

Hello, Please check PMB for details. Regards, Vedang Software. We already developed loads of website on Joomla please have a look:,, (user-paul, paswd-123456)

$750 USD in 25 days
(2 Reviews)

Hello, we are ready to take your project. Please check PM box for more details. Thanks and regards

$1500 USD in 120 days
(3 Reviews)

Hi, We are team of eight people. We worked in Java,.Net, PHP and other technologies. We will do this with good quality.

$750 USD in 25 days
(2 Reviews)

Renu Tec, works towards achieving customer satisfaction. Our ability to deliver what we promise takes us closer to that milestone. Our project management experience helps us achieve a thorough understanding of the proj More

$1100 USD in 50 days
(0 Reviews)

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$750 USD in 2 days
(0 Reviews)

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$750 USD in 2 days
(0 Reviews)

Hi, Sent you a PM! Thanks!

$1500 USD in 15 days
(0 Reviews)

Hi, we are group of programmers and designers and have more then 3 years of experience to build joomla sites. we are believe to give quality work in proper time line.

$1000 USD in 20 days
(0 Reviews)

Sir, Why you want to pay more from xyz, first let us know or have a chance to prove. We can do customize the work you are looking for, our aim is simple first work satisfaction and then payment. Let me know More

$1000 USD in 50 days
(0 Reviews)

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$750 USD in 2 days
(0 Reviews)

Ican do this work.

$750 USD in 35 days
(0 Reviews)

Hello, It would be a pleasure to work on your project. Regards, John

$1400 USD in 45 days
(0 Reviews)

Hello, my dynamic team of Graphic Designers, Website Developers, Programmers and Server Administrators will ensure that your project is completed to your satisfaction. Deciding on the right company for the job can be d More

$1500 USD in 20 days
(0 Reviews)

Wow, it seems like a more then interesting project. I am an Australian developer, and although there is alot of distance, i think i could use aspects of the Australian Police force to improve your system. Thanks alot, More

$2500 USD in 90 days
(0 Reviews)