Reception of citizens: on-line document readiness check

Good afternoon friends.

Today I will continue to talk about the developments that we are doing in our Office (UFRS in the Kurgan region, the previous articles are here and here ).

So, imagine a standard situation: you handed over documents, say, for registration of a land plot, received a receipt, and now you are waiting for everything to be done. Typically, the design goes through several stages, and it would be nice if you could follow the process of passing documents. How about an online check ? Yes, it sounds very good. But this possibility is especially relevant if you are suddenly denied registration or it turns out that you need to bring some piece of paper. In the classic version, you will call (when all the deadlines have passed), in the advanced version - they will call you, in ideal - you have visited the site, looked through the form that your design has been suspended, and began to calmly figure out the reason. Convenient for citizens and for those who draw up documents.
')
Focusing on all this, we have developed our own online document readiness check system .



Option One: reference terminal

For training, it was originally decided to put a check on our information and reference terminal, which is in the reception hall. Before that, I had already installed a small Denver-based web server there, through which various background information is displayed.

Thus, the challenge was to make the interface and learn how to upload the necessary information to the mysql of this local server.

The interface was made in JavaScript with an emulation of an on-screen digital keyboard (the pictures are clickable):



Data uploading is carried out from the internal protected Oracle database. To upload, mysql was transferred to listening to the external ip-address (instead of localhost), so now you can connect to it from another server and upload data. By the way, I’ll immediately note for those who want to repeat this trick: before mysql, you need to install a firewall to block unauthorized connections, plus check the hosts / users tables in the database itself.

The system has been working successfully for about 4 months. Judging by the statistics collected, people use it (although it is not very active so far - apparently they are still getting used to it)

Option Two: check on the site

This option was more difficult. The main point: the reluctance to open mysql for external listening, as this is a site database accessible from anywhere in the world (unlike the previous version, when everything was limited to the local grid).

Based on this, it was decided to do the opposite: from the web server to connect to the Oracle database and pull the necessary data. Everything is safe, as it is done through intermediate scripts, i.e. There is no direct connection to the internal database. The development took about five weeks of dancing with a tambourine, googling, smoking mans and other similar things :-). Still - bingo! - all successfully earned.

The form looks simple, but obviously this is only the tip of the iceberg:



results

The most important result: now the visitors who have handed in the documents can easily check at what stage their documents are. You can come to our building and see through the terminal. For those who have internet at home, go to the site and check right there. Convenient, fast, vanity and hassle disappears, our experts do their work, and do not get distracted by trifles.

I think this is a good illustration of how using IT (and, above all, web technologies), you can make life easier for many people using the services of government agencies. In general, such a system could be useful in a variety of organizations, where there are long multi-stage paperwork procedures.