Requests (DB tables)
Requests (DB tables)
DB tables
- select * from workfl_master;
- select * from workfl_faze;
- select * from workfl_stavy;
- select * from workfl_hl;
- select * from workfl_body;
- select * from workfl_proc;
- select * from prtl_porizovak;
- select * from workfl_sluz_cesty;
- select * from projekty_hod;
- select * from projekty_cinn;
Examples
| id | typ | nazev | ... |
| 2 | dovol | žádost o dovolenou | ... |
| 5 | sluz | žádost o služ. cestu | ... |
| id_master | faze | stav | syst_stav | ... |
| 2 | 1 | novy | n | ... |
| 2 | 2 | schvaleny | o | ... |
| 2 | 2 | zamitnuty | s | ... |
| id_poz | os_cislo | typ | id_master | ... |
| 80 | 11 | dovol | 2 | ... |
| 86 | 7 | sluzc | 5 | ... |
| id | id_poz | verze | datum_od | datum_do | id_vazba | tabulka | ... |
| .. | 80 | 1 | 2014-08-27 | 2014-08-28 | ... | ||
| .. | 86 | 1 | 2014-09-25 | 2014-09-25 | 89 | workfl_sluz_cesty | ... |
| ev_cislo | ... |
| 89 | ... |
Saving the application for a business trip means saving tha data into the table: workfl_hl, worfkl_body, workfl_proc a navíc workfl_sluz_cesty.
The bond is workfl_body.id vazba = workfl_sluz_cesty.ev_cislo.
After the approval of the application the data about the application are copied from the table workfl_sluz_cesty into the table sluz_cesty. The user can further work with this table (the following changes of the business trip by the employee etc.) and the value workfl body.tabulka from the value workfl sluz_cesty to the value sluz_cesty is simultaneously changed.
| id | id_poz | poradi | stav | sys_stav | faze | resitel | duvod | adresat | datum | cas | zapsal | ... |
| 123 | 80 | 1 | novy | n | 1 | 1 | ... | |||||
| 127 | 80 | 2 | schvaleny | o | 2 | 1 | ... | |||||
| 135 | 86 | 1 | novy | n | 1 | 1 | ... |
The fields workfl.datum and workfl.cas store the information about day and time of making the change of the state.
The site´s address
The site´s address in the upper bar is the same as the address of the whole list of requirements when displaying the detail. When indicating the reference for the detail of the requirement in the email address, the ?id_poz=xxx is added to the site´s address, where xxx means the reference for the concrete requirement. This requirement was originally given by number workfl_proc.id_poz. Newly, the coded text is generated due to the safety.
