Dispatch and Employee Records

Closed Posted Nov 2, 2009 Paid on delivery
Closed Paid on delivery

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.

Electronic Forms Joomla PHP SQL

Project ID: #541217

About the project

32 proposals Remote project Active Jan 31, 2010

32 freelancers are bidding on average $1396 for this job

agstech123

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

$3840 USD in 60 days
(14 Reviews)
6.1
indisoftware

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

$1250 USD in 35 days
(9 Reviews)
4.9
mdshahidjmi

i can do it in a mentioned time

$945 USD in 15 days
(9 Reviews)
4.3
iSketch

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

$2500 USD in 30 days
(14 Reviews)
4.5
bhuvantrivedi

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

$1400 USD in 45 days
(1 Review)
4.6
tgshakthi

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

$1045 USD in 33 days
(11 Reviews)
4.1
SkipperRi

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)
2.3
PeopleWorld

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)
0.8
dawoodsangam

Hi, I can execute this project. Thanks

$1500 USD in 60 days
(0 Reviews)
0.0
myn01

This is not a copy/paste bid. I have carefully read your requirements. Please see PM for more details.

$2500 USD in 60 days
(0 Reviews)
0.0
anandbanik

Interested to do this project

$950 USD in 25 days
(0 Reviews)
0.0
kimidabest

hi, as per your requirement your project looks a bit complicated as it is totally related to security purpose. so developing and testing this project will definetely take time. but i can assure you a quality in my outp More

$1315 USD in 180 days
(0 Reviews)
0.0
congruent

Kindly consider us...............pls check PMB

$2000 USD in 90 days
(2 Reviews)
5.5
firephpbd07

dear sir i have seen all of your requirement i can do it perfectly. and i have seen all of your requirement and i want to start this project i will be able to do this project in my server . after completing it will r More

$1500 USD in 40 days
(0 Reviews)
0.0
thumb099

This looks like a very interesting project! I have experience in PHP, MySQL, Joomla! and GoDaddy. I am a US based developer that has been programming databases for the web since 1999 and would really enjoy this project More

$1250 USD in 90 days
(0 Reviews)
0.0
compropc

I can Build this for you in a complete and secure state i have a demo for you please pm me for the link and login info i have dispatch and officer login ready for you

$1500 USD in 90 days
(0 Reviews)
0.0
kdivyesh

Hi, Kindly Check Your PM. Thanks, Kdivyesh.

$2500 USD in 60 days
(0 Reviews)
0.0
khalidhussain

GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJEOOOOOOOOOOOOOOOPPWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW More

$780 USD in 20 days
(0 Reviews)
0.0
angus930

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)
0.0
gxisolutions

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)
0.0