{"name":"Przykład - automatyczna data","dbtable":"eq5_dataczas","width":"800","height":"450","pages":[{"properties":[{"name":"postprocessing","type":"multitext","value":""}],"dragons":[{"id":"label1","type":"label","properties":[{"name":"id","type":"text","value":"label1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":360},{"name":"width","type":"text","value":775},{"name":"height","type":"text","value":80},{"name":"text","type":"text","value":"Aby umieścić nasz datę jako widoczną na kolejnych etapach - korzystając jednocześnie z przycisku na klawiaturze <ctrl> oraz lewego przycisku myszki zaznaczmy etykietę oraz to pole tekstowe - pole daty pomijamy i kiedy mamy już zaznaczone właściwe wybieramy z menu funkcję kopiuj. Po przejściu na drugą stronę formularza korzystamy z funkcji KOPIUJ JAKO LINKI"},{"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":"label2","type":"label","properties":[{"name":"id","type":"text","value":"label2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":270},{"name":"top","type":"text","value":305},{"name":"width","type":"text","value":520},{"name":"height","type":"text","value":50},{"name":"text","type":"text","value":"Pole tekstowe natomiast w zakresie opcji DB pozostawiamy bez zmian, natomiast w zakresie widoczności ustawiamy jego wartość na TAK (opcja: HIDDEN)"},{"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":270},{"name":"top","type":"text","value":190},{"name":"width","type":"text","value":520},{"name":"height","type":"text","value":65},{"name":"text","type":"text","value":"Następnie w polu daty w zakresie opcji DB zmieniamy wartość na SQL oraz wprowadzamy zapis jak w niniejszym przykładzie oraz w polu źródła wpisujemy id naszego pola, które daną wartość ma przechowywać"},{"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":"label4","type":"label","properties":[{"name":"id","type":"text","value":"label4"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":270},{"name":"top","type":"text","value":140},{"name":"width","type":"text","value":520},{"name":"height","type":"text","value":50},{"name":"text","type":"text","value":"Następnie aby uniknąć później pomyłek oba pola oznaczamy jako TYLKO DO ODCZYTU czyli opcję w Inspektorze Obiektu \"Readonly\" zmieniamy na TAK"},{"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":"label5","type":"label","properties":[{"name":"id","type":"text","value":"label5"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":270},{"name":"top","type":"text","value":95},{"name":"width","type":"text","value":520},{"name":"height","type":"text","value":40},{"name":"text","type":"text","value":"Aby przygotować elementy do identyfikacji daty wystarczy położyć na formularzu jedno pole etykiety, jedno pole daty oraz jedno pole tekstowe."},{"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":15},{"name":"top","type":"text","value":105},{"name":"width","type":"text","value":240},{"name":"height","type":"text","value":20},{"name":"text","type":"text","value":"Data wypełnienia"},{"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":"label7","type":"label","properties":[{"name":"id","type":"text","value":"label7"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":15},{"name":"width","type":"text","value":775},{"name":"height","type":"text","value":65},{"name":"text","type":"text","value":"Innym z ważnych elementów potrzebnych w elektronicznych obiegach jest możliwość identyfikacji daty i czasu, w którym dany formularz wypełniono i to także w jednoznaczny sposób. Poniższy przykład przedstawia jak za pomocą prostych funkcji spowodować automatyczne wstawienie daty działań z jednoczesnym brakiem możliwości zmiany zawartości komórki."},{"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":"datetime1","type":"datetime","properties":[{"name":"id","type":"text","value":"datetime1"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":125},{"name":"width","type":"text","value":120},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"uuid":"b52df00f-fd1e-4e2b-d4a9-44418282ae80","type":"2","readwrite":{"fieldtype":"0","fieldlength":"19","fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":""},"sql":{"fieldtext":"select date_format(now(), '%Y-%m-%d');","fielddest":"text1"}}},{"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","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":15},{"name":"top","type":"text","value":155},{"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":"tak"},{"name":"tooltip","type":"multitext","value":""},{"name":"hidden","type":"boolean","value":"tak"}]},{"id":"label11","type":"label","properties":[{"name":"id","type":"text","value":"label11"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":270},{"name":"top","type":"text","value":260},{"name":"width","type":"text","value":520},{"name":"height","type":"text","value":40},{"name":"text","type":"text","value":"Dla pola Data ustawiamy ponadto wartość właściwości DATETIME na datę prostą lub na datę i czas - w tym przykładzie wykorzystana jest prosta data."},{"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"}]}}]}]},{"properties":[{"name":"postprocessing","type":"multitext","value":""}],"dragons":[{"id":"label8","type":"label","properties":[{"name":"id","type":"text","value":"label8"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":105},{"name":"width","type":"text","value":240},{"name":"height","type":"text","value":20},{"name":"text","type":"text","value":"Data wypełnienia"},{"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":"text2","type":"input","properties":[{"name":"id","type":"text","value":"text2"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":130},{"name":"width","type":"text","value":120},{"name":"text","type":"text","value":""},{"name":"placeholder","type":"text","value":"brak wartości"},{"name":"db","type":"database","value":{"uuid":"3465fd47-6e29-4278-f1c6-41ba1c339ecc","type":"1","readwrite":{"fieldtype":"0","fieldlength":"32","fieldprecision":""},"read":{"fieldtable":"","fieldcolumn":"text1"},"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":"label9","type":"label","properties":[{"name":"id","type":"text","value":"label9"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":15},{"name":"width","type":"text","value":775},{"name":"height","type":"text","value":65},{"name":"text","type":"text","value":"Innym z ważnych elementów potrzebnych w elektronicznych obiegach jest możliwość identyfikacji daty i czasu, w którym dany formularz wypełniono i to także w jednoznaczny sposób. Poniższy przykład przedstawia jak za pomocą prostych funkcji spowodować automatyczne wstawienie daty działań z jednoczesnym brakiem możliwości zmiany zawartości komórki."},{"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":"label10","type":"label","properties":[{"name":"id","type":"text","value":"label10"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":270},{"name":"top","type":"text","value":105},{"name":"width","type":"text","value":520},{"name":"height","type":"text","value":45},{"name":"text","type":"text","value":"Po wykonaniu operacji wklejania jako linki zmieniamy wartość HIDDEN naszego pola tekstowego z TAK na NIE"},{"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":"label12","type":"label","properties":[{"name":"id","type":"text","value":"label12"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":180},{"name":"width","type":"text","value":775},{"name":"height","type":"text","value":65},{"name":"text","type":"text","value":"I tu podobnie - zamiast układać kolejno wszystkie pola w swoim projekcie formularza możemy po prostu otworzyć ten przykład i zaznaczyć z na pierwszej stronie trzy pola - etykieta, data oraz tekst, skorzystać z górnego menu - opcja kopiuj, a następnie już w swoim projekcie wykonać prostą funkcję WKLEJ."},{"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":"label13","type":"label","properties":[{"name":"id","type":"text","value":"label13"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":15},{"name":"top","type":"text","value":260},{"name":"width","type":"text","value":775},{"name":"height","type":"text","value":40},{"name":"text","type":"text","value":"UWAGA - jeżeli chcemy skorzystać z pełnej opcji pola Data, czyli użyć zarówno daty jak i czasu opcja DATETIME musi być ustawiona date time oraz wprowadzane do właściwości DB zapytanie SQL musi mieć kształt:"},{"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":"label14","type":"label","properties":[{"name":"id","type":"text","value":"label14"},{"name":"name","type":"text","value":""},{"name":"left","type":"text","value":200},{"name":"top","type":"text","value":300},{"name":"width","type":"text","value":375},{"name":"height","type":"text","value":20},{"name":"text","type":"text","value":"select date_format(now(), '%Y-%m-%d %H:%i:%s');"},{"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"}]}}]}]}]}