Dispatch and Employee Records

終了済み 投稿 Nov 2, 2009 着払い
終了済み 着払い

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.

電子フォーム Joomla PHP SQL

プロジェクトID: #541217

プロジェクトについて

32個の提案 リモートプロジェクト アクティブ Jan 31, 2010

32人のフリーランサーが、平均$1396 で、この仕事に入札しています。

agstech123

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

$3840 USD 60日以内
(14件のレビュー)
6.1
indisoftware

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

$1250 USD 35日以内
(9件のレビュー)
4.9
mdshahidjmi

i can do it in a mentioned time

$945 USD 15日以内
(9件のレビュー)
4.3
iSketch

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

$2500 USD 30日以内
(14件のレビュー)
4.5
bhuvantrivedi

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

$1400 USD 45日以内
(レビュー1件)
4.6
tgshakthi

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

$1045 USD 33日以内
(11件のレビュー)
4.1
SkipperRi

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

$1500 USD 120日以内
(3件のレビュー)
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 25日以内
(2件のレビュー)
0.8
dawoodsangam

Hi, I can execute this project. Thanks

$1500 USD 60日以内
(0件のレビュー)
0.0
myn01

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

$2500 USD 60日以内
(0件のレビュー)
0.0
anandbanik

Interested to do this project

$950 USD 25日以内
(0件のレビュー)
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 もっと

$1315 USD 180日以内
(0件のレビュー)
0.0
congruent

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

$2000 USD 90日以内
(2件のレビュー)
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 もっと

$1500 USD 40日以内
(0件のレビュー)
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 もっと

$1250 USD 90日以内
(0件のレビュー)
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 90日以内
(0件のレビュー)
0.0
kdivyesh

Hi, Kindly Check Your PM. Thanks, Kdivyesh.

$2500 USD 60日以内
(0件のレビュー)
0.0
khalidhussain

GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJEOOOOOOOOOOOOOOOPPWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW もっと

$780 USD 20日以内
(0件のレビュー)
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, もっと

$2500 USD 90日以内
(0件のレビュー)
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 もっと

$1500 USD 20日以内
(0件のレビュー)
0.0