Decision to any digging project is given by 14 active departments. Seven of them are called Internal departments as they are located inside the Madinah Muncipality. They are Study & Supervision, Operation & Maintenance, Gardening, Valley & flowage, Execution & Development, and Baladiyat Subsidiary. The above six internal departments have been divided on the based of their relation and their dependency on Madinah municipality. The other seven are called External Departments, which require internet to access the Digging System, they are Water, Electricity, Telecom, Traffic, Transport and Civil Defence. Since the internal department are local to Madinah Municipality, an Intranet based application is developed to carry out the process, which is called as Internal System. For external departments an Internet based application is developed called as External System. Both the systems have one common database. If any one of the 14 departments rejects the dig order then order is meant to be rejected. The combined decision from internal departments is stored in a single department file called Amana and is represented in External website. Therefore, the external department will be able to view the decision from internal system as well as from the other external departments on the Digging Information System with internet access. This makes the license issuing authority to view the decisions from all departments and their status at the same time for each and every order. NEW ORDER This is a secured application as users with only valid login identities can access it. Applications hold different privileges for contractors and for users from each department. There are different functionalities which a user is privileged to access like creating new dig order, viewing own orders, viewing other department orders, approving or rejecting an order etc. For every new digging project to be carried out for any utility purpose, a contractor shall supply the details on fields in New-Order form to concerned utility department through the online system. The details of the order are saved in Oracle database and can be accessed by both the external (internet) and internal (intranet) parts of digging application, as they both share the database. A new dig-order contains fields like contractor name, order number, depth, width, date, stage, coordinates of the digging path etc. Coordinates shall be submitted (simply paste in the text area of New-Order form) in a unique format as shown below. X and Y are the projected coordinates on ground and explanation for section is followed. Section and Stages Coordinates which are submitted online has x, y and section Here, change of section represents the change in the continuity of line. Points of the same section number are connected to each other but next point having different section number is considered as new first point and will connect all those points having the same section number. Hence any discontinuity or turning in the digging path can be mapped easily. Another important factor to be considered is that any single digging project can have multiple stages. Each stage could differ with its location of digging path, geometry and start date, which means same order number can have multiple digging stages. So, every new order is created using three primary keys they are order number, date and stage. SUPPORTING FUNCTIONALITIES OF ONLINE SYSTEM: Dig order check by owner department Utility department will then fill the order details from the Online Digging system. Once the order is submitted, it can be viewed in the list of orders called from function 'ViewMyOrders'. But this new order will not be shown to other departments since it will be in test status. Under 'test' status, the order is private to owner department and also represented with a test symbol. Test status is meant for the department to check the validity of order details, whether contractor owes any penalty or examine it on map with function 'ShowOrderOnMap' and get confirmed to send it into the cycle where all other departments will give their decision to approve or reject. The owner department then clicks on function 'Show To All Depts', which then changes its status as well as symbol from Test to Pending. Pending symbol is shown in the column for other departments and in row of that particular order number. This Function plays an important role in decision-making as it involves map. No sooner than a new dig-order is submitted online, other department would be able to view the details of that order in text format and on map as shown in the  Fig. 3 Dig order check by owner department  Fig. 4 Display order on map figure 3 and 4. Co-ordinates of the order are read from the table in order database and using Mapx, a line of red color and thick width is created on temp layer and overlayed on other spatial layers. Symbolic representation for status of the order Test Status- This Symbol for test status or when the order is in dormant stage and this order not yet Approved or send into the cycle system by the Owner Department who is Login. Pending- For every order waiting for decision from other departments are in pending status represented by the above symbol Approved- This Symbols represent for approval from the Concerned Department who gave the decision. Reject- When a Department rejects on order owned by the department, he shall then necessarily specify the reason for rejection. This Symbol is hyperlinked to ASP page, which display or show the specified rejection from oracle database. Approved (Red)- Every new Order in the cycle has a Limited life time of 3 Working days within this duration any department fails to give his decision to order belonging to other Departments, it will be then implicity accepted represented by Red Symbol above. |