The Samaneh Dabirkhaneh Komisiyon Made 100 is built to manage cases, follow the review workflow and generate administrative correspondence, replacing manual registers and scattered letters with a single environment. It is implemented with Node and Express on the server, PostgreSQL as the database and React in the user interface. Its distinctive features are the automatic generation of PDF and Word documents from case data, Excel export and full support for the Jalali calendar throughout the system. Cases are linked to their position on the map, and a licence system is provided for on-premise installations.
The problem this system solves
The Article 100 commission secretariat deals with a high volume of cases, correspondence and statutory deadlines; when this information is kept on paper and in scattered files, following the stage of each case is difficult and preparing minutes and letters is time-consuming.
By recording cases in a single database, the system makes the current state of each case and the history of actions taken available, and allows fast search by case number, parties and date range.
Automatic generation of correspondence from the same data avoids retyping text by hand and prevents discrepancies between versions.
Users, roles and the case workflow
Users are defined in separate work roles so that each part of the secretariat reaches only its own duties. The secretariat clerk registers the case and attaches documents, the expert records an opinion in the case, and the commission officer enters the final decision.
The case workflow is tracked from initial registration to the final decision, and each action is recorded with the user who performed it and the time.
- Secretariat clerk, who registers cases, attaches documents and handles correspondence.
- Technical expert, who enters the technical opinion and reviews the case.
- Commission officer, who records the decision and issues the final letter.
- Manager, who views reports and the progress of cases.
Case management and the review cycle
The base unit of data is the case: each case has a unique identifier, parties, subject, attached documents and a current state, and its action history is kept across the review.
The review workflow has defined stages, and the case state at any moment shows which stage it has reached and which action is expected from whom.
Links between cases and with related correspondence are recorded, so referring to the history of a property or applicant is straightforward.
Advanced search and case filters make it easy to find stalled cases or those awaiting action.
PDF and Word documents, Excel export and the Jalali calendar
The system fills correspondence and minutes templates from case data and produces the output as PDF and Word; both a printable copy and an editable copy of each document are therefore available.
Excel export is provided for reporting and for external analysis, so the list of cases and their states can be used in spreadsheet tools.
Jalali calendar support is applied across the system; dates are entered, deadlines computed and dates printed on documents on the basis of the Solar Hijri calendar, matching the secretariat’s administrative practice.
- Ready correspondence and minutes templates driven by case data.
- PDF output for printing and archiving, Word output for editing.
- Excel output for reporting and data processing.
- Entry and computation of all dates on the Jalali calendar.
Spatial data, maps and information integration
Each case can be linked to the location of its property or subject on the map; this link helps the expert inspect the site on the map before review.
Descriptive case data and spatial data are held in the PostgreSQL database and displayed through the React interface.
Integration with other organisational systems is possible through server-side services and the same data layer.
Deployment, the licence system and access control
The system is designed for on-premise installation on the operator’s server, and the licence system allows management of operating permits.
The Node, Express, PostgreSQL and React architecture makes deployment on the internal network and keeping the data under the organisation’s control feasible.
Access control is enforced by user role, and recording the user and time of every action makes changes to a case traceable.
Rollout and delivery
Rollout begins with defining the case structure, the workflow stages and the correspondence templates; user roles and permissions are then defined for the clerks.
In the next step the initial data is entered and, where needed, in-progress cases are migrated into the system.
Once operation starts, new cases are registered in the system and their workflow is followed in the same environment.
Summary
The Samaneh Dabirkhaneh Komisiyon Made 100 gathers the cases and correspondence of the secretariat into one database and makes the review workflow traceable from registration to final decision.
Automatic PDF and Word generation, Excel output and Jalali calendar support lighten the clerks’ daily work and keep it aligned with administrative practice.
Management decisions are easier with reports and the case map, and on-premise deployment alongside the licence system keeps the data under the organisation’s control.