CITIZEN WIZZARD

Cilj ovoga rada bio je napraviti JavaScript/PHP aplikaciju koja korisniku omogućava prijavu komunalnih problema na području grada. Za izradu rada korišten je Visual Studio Code kao uređivač koda, a JavaScript i PHP programski jezici kao tehnologije za izradu aplikacije. Komunalni assistent je aplikacija tipa web stranica koja pruža grafičko korisničko sučelje pomoću HTML opisnog jezika. Komunalni assistent omogućuje korisniku dodavanje i provjeru statusa ticketa. Dodavanjem ticketa otvara se Bootstrap modal koji sadrži polja za popunjavanje: status, slike (opcionalno), datum, adresa i google mapu pomoću koje s jednostrukim klikom na nju dodaje latitudu i longitudu adrese. Nakon popunjenih svih polja korisnik treba jednostrukim kliknuti na gumb “Dodaj ticket” te se zatim taj ticket sprema u bazu podataka i aplikacija korisniku vraća identifikacijski broj njegovog ticketa u obliku modala. S tim identifikacijskim brojem korisnik ima mogućnost provjeravanja statusa svoga ticketa. Status ticketa se provjerava tako da korisnik upiše identifikacijski broj svog ticketa u search bar i pritiskom tipke enter na tipkovnici otvara se modal sa svim informacijama o traženom ticketu. Za bazu podataka korišten je MS SQL server, a za rad nad bazom podataka korišten je Microsoft sql server management studio 18.The aim of this work was to create a JavaScript / PHP application that allows the user to report utility problems in the city area. Visual Studio Code was used to create the work as a code editor, and JavaScript and PHP programming languages were used as technologies for creating the application. A utility assistant is a web-type application that provides a graphical user interface using an HTML descriptive language. The utility assistant allows the user to add and check the status of the ticket. Adding a ticket opens the Bootstrap modal which contains fields to fill in: status, images (optional), date, address and a google map with which you can add the latitude and longitude of the address with a single click on it. After filling in all the fields, the user should single-click on the "Add ticket" button and then the ticket is saved in the database and the application returns to the user the identification number of his ticket in the form of a modal. With this identification number, the user has the opportunity to check the status of his ticket. The status of the ticket is checked by the user entering the identification number of their ticket in the search bar and pressing the enter key on the keyboard opens a module with all the information about the requested ticket. MS SQL server was used for the database and Microsoft sql server management studio 18 was used to work on the database