{"name":"Kontrola dzienników - Przykład 2","dbtable":"eq5_kontrolaDZ2","width":"800","height":"700","pages":[{"properties":[{"name":"postprocessing","type":"multitext","value":""}],"dragons":[{"id":"datetime1","type":"datetime","properties":[{"name":"id","type":"text","value":"datetime1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":410},{"name":"top","type":"text","value":35},{"name":"width","type":"text","value":120},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":0,"readwrite":{"fieldtype":0,"fieldlength":19,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"datetimeformat","type":"select","value":{"value":{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},"fields":[{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},{"key":"yyyy-MM-dd","value":"date"}]}}]},{"id":"label2","type":"label","properties":[{"name":"id","type":"text","value":"label2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":35},{"name":"width","type":"text","value":385},{"name":"height","type":"text","value":25},{"name":"text","type":"text","value":"Podaj datę od jakiego okreu wipsy mają być oceniane"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"left","value":"left"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]},{"id":"label1","type":"label","properties":[{"name":"id","type":"text","value":"label1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":5},{"name":"width","type":"text","value":790},{"name":"height","type":"text","value":20},{"name":"text","type":"text","value":"KONTROLA DZIENNIKÓW"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"center","value":"center"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]}]},{"properties":[{"name":"postprocessing","type":"multitext","value":""}],"dragons":[{"id":"text3","type":"input","properties":[{"name":"id","type":"text","value":"text3"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":310},{"name":"top","type":"text","value":455},{"name":"width","type":"text","value":120},{"name":"text","type":"text","value":""},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":0,"readwrite":{"fieldtype":0,"fieldlength":32,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"tak"}]},{"id":"text2","type":"input","properties":[{"name":"id","type":"text","value":"text2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":130},{"name":"top","type":"text","value":455},{"name":"width","type":"text","value":175},{"name":"text","type":"text","value":""},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":0,"readwrite":{"fieldtype":0,"fieldlength":32,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"tak"}]},{"id":"datetime3","type":"datetime","properties":[{"name":"id","type":"text","value":"datetime3"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":310},{"name":"top","type":"text","value":425},{"name":"width","type":"text","value":120},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"uuid":"ada15662-1823-4c08-9336-a9d6d0a65bd5","type":"2","readwrite":{"fieldtype":"0","fieldlength":"19","fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"select date_format(now(), '%Y-%m-%d');","fielddest":"text3"}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"datetimeformat","type":"select","value":{"value":{"key":"yyyy-MM-dd","value":"date"},"fields":[{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},{"key":"yyyy-MM-dd","value":"date"}]}}]},{"id":"text1","type":"input","properties":[{"name":"id","type":"text","value":"text1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":130},{"name":"top","type":"text","value":425},{"name":"width","type":"text","value":175},{"name":"text","type":"text","value":""},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"uuid":"898e72d9-9ff5-4c3c-df38-7adeb7de46da","type":"2","readwrite":{"fieldtype":"0","fieldlength":"32","fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"select concat(fname,' ',lname) from users where id = [$USER_ID]","fielddest":"text2"}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"nie"}]},{"id":"label5","type":"label","properties":[{"name":"id","type":"text","value":"label5"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":425},{"name":"width","type":"text","value":120},{"name":"height","type":"text","value":30},{"name":"text","type":"text","value":"Weryfikujący"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"left","value":"left"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]},{"id":"multitext1","type":"textarea","properties":[{"name":"id","type":"text","value":"multitext1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":350},{"name":"width","type":"text","value":780},{"name":"text","type":"multitext","value":""},{"name":"placeholder","type":"text","value":"W przypadku braku pełnej akceptacji proszę wpisać uwagi"},{"name":"height","type":"text","value":70},{"name":"db","type":"database","value":{"type":0,"readwrite":{"fieldtype":0,"fieldlength":512,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"nie"}]},{"id":"combo1","type":"combobox","properties":[{"name":"id","type":"text","value":"combo1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":315},{"name":"width","type":"text","value":235},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":0,"readwrite":{"fieldtype":0,"fieldlength":64,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"","fielddest":""}}},{"name":"source","type":"list","value":{"list":["Zatwierdzam bez uwag","Zatwierdzam z uwagami","Nie akceptuję"]}},{"name":"require","type":"boolean","value":"tak"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""}]},{"id":"grid1","type":"grid","properties":[{"name":"id","type":"text","value":"grid1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":80},{"name":"width","type":"text","value":785},{"name":"height","type":"text","value":230},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"grid","type":"grid","value":{"bindgrid":"","sourcesql":"select combo1 as typ, datetime1 as data_wpisu, text1 as tytul, multitext1 as opis, datetime2 as data_wyk, text2 as wykonujacy from eq5_dziennik where datetime1 > (select datetime1 from eq5_kontrolaDZ where eq5_id = [$CURRENT_DFC]);\n","sourcecolumns":[{"name":"typ","type":"0","fieldwidth":"32","title":"Obszar","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"data_wpisu","type":"0","fieldwidth":"32","title":"Data wpisu","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"tytul","type":"0","fieldwidth":"255","title":"Tytuł zdarzenia","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"opis","type":"0","fieldwidth":"512","title":"Opis zdarzenia","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"data_wyk","type":"0","fieldwidth":"32","title":"Data wykonania","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"wykonujacy","type":"0","fieldwidth":"32","title":"Wykonujący","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""}],"selectsql":"","selectcolumns":[]}}]},{"id":"datetime2","type":"datetime","properties":[{"name":"id","type":"text","value":"datetime2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":410},{"name":"top","type":"text","value":35},{"name":"width","type":"text","value":120},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":1,"readwrite":{"fieldtype":0,"fieldlength":19,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"datetime1"},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"tak"},{"name":"tooltip","type":"multitext","value":""},{"name":"datetimeformat","type":"select","value":{"value":{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},"fields":[{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},{"key":"yyyy-MM-dd","value":"date"}]}}]},{"id":"label4","type":"label","properties":[{"name":"id","type":"text","value":"label4"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":35},{"name":"width","type":"text","value":385},{"name":"height","type":"text","value":25},{"name":"text","type":"text","value":"Data od jakiego okreu wipsy są oceniane"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"left","value":"left"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]},{"id":"label3","type":"label","properties":[{"name":"id","type":"text","value":"label3"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":5},{"name":"width","type":"text","value":790},{"name":"height","type":"text","value":20},{"name":"text","type":"text","value":"KONTROLA DZIENNIKÓW"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"center","value":"center"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]}]},{"properties":[{"name":"postprocessing","type":"multitext","value":""}],"dragons":[{"id":"datetime4","type":"datetime","properties":[{"name":"id","type":"text","value":"datetime4"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":410},{"name":"top","type":"text","value":35},{"name":"width","type":"text","value":120},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":1,"readwrite":{"fieldtype":0,"fieldlength":19,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"datetime1"},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"tak"},{"name":"tooltip","type":"multitext","value":""},{"name":"datetimeformat","type":"select","value":{"value":{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},"fields":[{"key":"yyyy-MM-dd hh:mm:ss","value":"date time"},{"key":"yyyy-MM-dd","value":"date"}]}}]},{"id":"text5","type":"input","properties":[{"name":"id","type":"text","value":"text5"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":310},{"name":"top","type":"text","value":425},{"name":"width","type":"text","value":120},{"name":"text","type":"text","value":""},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":1,"readwrite":{"fieldtype":0,"fieldlength":32,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"text3"},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"tak"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"nie"}]},{"id":"text4","type":"input","properties":[{"name":"id","type":"text","value":"text4"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":130},{"name":"top","type":"text","value":425},{"name":"width","type":"text","value":175},{"name":"text","type":"text","value":""},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":1,"readwrite":{"fieldtype":0,"fieldlength":32,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"text2"},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"tak"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"nie"}]},{"id":"label8","type":"label","properties":[{"name":"id","type":"text","value":"label8"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":425},{"name":"width","type":"text","value":120},{"name":"height","type":"text","value":30},{"name":"text","type":"text","value":"Weryfikujący"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"left","value":"left"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]},{"id":"multitext2","type":"textarea","properties":[{"name":"id","type":"text","value":"multitext2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":350},{"name":"width","type":"text","value":780},{"name":"text","type":"multitext","value":""},{"name":"placeholder","type":"text","value":"W przypadku braku pełnej akceptacji proszę wpisać uwagi"},{"name":"height","type":"text","value":70},{"name":"db","type":"database","value":{"type":1,"readwrite":{"fieldtype":0,"fieldlength":512,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"multitext1"},"sql":{"fieldtext":"","fielddest":""}}},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"tak"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"nie"}]},{"id":"combo2","type":"combobox","properties":[{"name":"id","type":"text","value":"combo2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":315},{"name":"width","type":"text","value":235},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"type":1,"readwrite":{"fieldtype":0,"fieldlength":64,"fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"combo1"},"sql":{"fieldtext":"","fielddest":""}}},{"name":"source","type":"list","value":{"list":["Zatwierdzam bez uwag","Zatwierdzam z uwagami","Nie akceptuję"]}},{"name":"require","type":"boolean","value":"tak"},{"name":"readonly","type":"boolean","value":"tak"},{"name":"tooltip","type":"multitext","value":""}]},{"id":"grid2","type":"grid","properties":[{"name":"id","type":"text","value":"grid2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":80},{"name":"width","type":"text","value":785},{"name":"height","type":"text","value":230},{"name":"require","type":"boolean","value":"nie"},{"name":"readonly","type":"boolean","value":"nie"},{"name":"tooltip","type":"multitext","value":""},{"name":"grid","type":"grid","value":{"bindgrid":"grid1","sourcesql":"","sourcecolumns":[{"name":"typ","type":"0","fieldwidth":"32","title":"Obszar","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"data_wpisu","type":"0","fieldwidth":"32","title":"Data wpisu","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"tytul","type":"0","fieldwidth":"255","title":"Tytuł zdarzenia","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"opis","type":"0","fieldwidth":"512","title":"Opis zdarzenia","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"data_wyk","type":"0","fieldwidth":"32","title":"Data wykonania","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""},{"name":"wykonujacy","type":"0","fieldwidth":"32","title":"Wykonujący","viewwidth":"64","require":false,"edit":false,"identity":false,"selectsql":""}],"selectsql":"","selectcolumns":[]}}]},{"id":"label7","type":"label","properties":[{"name":"id","type":"text","value":"label7"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":35},{"name":"width","type":"text","value":385},{"name":"height","type":"text","value":25},{"name":"text","type":"text","value":"Data od jakiego okreu wipsy są oceniane"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"left","value":"left"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]},{"id":"label6","type":"label","properties":[{"name":"id","type":"text","value":"label6"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":5},{"name":"top","type":"text","value":5},{"name":"width","type":"text","value":790},{"name":"height","type":"text","value":20},{"name":"text","type":"text","value":"KONTROLA DZIENNIKÓW"},{"name":"tooltip","type":"multitext","value":""},{"name":"textalign","type":"select","value":{"value":{"key":"center","value":"center"},"fields":[{"key":"left","value":"left"},{"key":"right","value":"right"},{"key":"center","value":"center"}]}}]}]}]}