Petrf: Založena nová stránka: '''Requests (DB tables)''' == DB tables == * select * from workfl_master; * select * from workfl_faze; * select * from workfl_stavy; * select * from workfl_hl; * s…

2014-11-19T14:51:25Z

Založena nová stránka: '''Requests (DB tables)''' == DB tables == <small> * select * from workfl_master; * select * from workfl_faze; * select * from workfl_stavy; * select * from workfl_hl; * s…

Nová stránka

'''Requests (DB tables)'''

== DB tables ==
<small>
* 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;
</small>

== Examples ==
{|border="1" cellpadding="3" cellspacing="0"
|+ '''''workfl_master'''''
|-
|'''id'''
|'''typ'''
|'''nazev'''
|'''...'''
|-
|2||dovol||žádost o dovolenou||...
|-
|5||sluz||žádost o služ. cestu||...
|}

{|border="1" cellpadding="3" cellspacing="0"
|+ '''''workfl_stavy'''''
|-
|'''id_master'''
|'''faze'''
|'''stav'''
|'''syst_stav'''
|'''...'''
|-
|2||1||novy||n||...
|-
|2||2||schvaleny||o||...
|-
|2||2||zamitnuty||s||...
|}

{|border="1" cellpadding="3" cellspacing="0"
|+ '''''workfl_hl'''''
|-
|'''id_poz'''
|'''os_cislo'''
|'''typ'''
|'''id_master'''
|'''...'''
|-
|80||11||dovol||2||...
|-
|86||7||sluzc||5||...
|}

{|border="1" cellpadding="3" cellspacing="0"
|+ '''''workfl_body'''''
|-
|'''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||...
|}

{|border="1" cellpadding="3" cellspacing="0"
|+ '''''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''. <br>
The bond is ''workfl_body.id vazba = workfl_sluz_cesty.ev_cislo''. <br>
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.

{|border="1" cellpadding="3" cellspacing="0"
|+ '''''workfl_proc'''''
|-
|'''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.

<div style="text-align:center">[[Portal-Workflow settings|Back]]</div>

Requests (DB tables) - Historie editací

Petrf: Založena nová stránka: '''Requests (DB tables)''' == DB tables == * select * from workfl_master; * select * from workfl_faze; * select * from workfl_stavy; * select * from workfl_hl; * s…