I need a web based program that multiple users can log in to, where they enter ticket data each day. The data gets stored in a database. At any time in the future reports need to be generated from data. Reports will be made up of one, some, or all data fields that were originally entered.
Entry fields are: Borough-(Manhattan South,Manhattan North,Queens South,Queens North,Brooklyn South,Brooklyn North,Bronx,Staten Island); Precinct – (1,5,7,9,10,13,MTS,17,MTN,19,more to come); Date; Time-(Drop down menu – 0700-1500, 1500-2300, 2300-0700); Violation -(drop down menu – (Violations To be determined); Sector (drop down menu – a,b,c,d,e,f,g,h,i,j,k,l,m); Location-(locations To be determined)
Report search fields are: Borough-(Manhattan South,Manhattan North,Queens South,Queens North,Brooklyn South,Brooklyn North,Bronx,Staten Island); Precinct
-(1,5,7,9,10,13,MTS,17,MTN,19,more to come); Date from, Date to; Time -(Drop down menu – 0700-1500, 1500-2300, 2300-0700); Sector -(drop down menu – a,b,c,d,e,f,g,h,i,j,k,l,m); Violation (drop down menu – (Violations To be determined); Location -(locations To be determined)
The report generator page must be able to generate a report from the date range required, and a minimum of just one other field being selected. And also give the total number of results found on the screen and on the report. Also list search criteria on report.
Export to excel?, csv?, other suggestions…
Web based, php and MySql?, other suggestions…
Admin login needed and user logins needed… This might be able to be done from cPanel?
I will host on private server.