From 659272a0004d3ec2099dcc664218b3000c10ddf0 Mon Sep 17 00:00:00 2001 From: "kilian (ksmachome)" Date: Thu, 5 Dec 2019 17:44:05 +0100 Subject: [PATCH] v20191205 workplans --- backoffice/tmp/sql.log | 351 ++++++++++++++++++ backoffice/tmpl/module/companies/index.tt | 20 +- backoffice/tmpl/module/plantemplates/index.js | 3 - backoffice/tmpl/module/plantemplates/index.tt | 0 backoffice/tmpl/module/staff/index.js | 10 + backoffice/tmpl/module/staff/index.tt | 6 + backoffice/tmpl/module/workplans/index.js | 104 ++++++ backoffice/tmpl/module/workplans/index.tt | 56 +++ 8 files changed, 530 insertions(+), 20 deletions(-) delete mode 100644 backoffice/tmpl/module/plantemplates/index.js delete mode 100644 backoffice/tmpl/module/plantemplates/index.tt create mode 100644 backoffice/tmpl/module/workplans/index.js create mode 100644 backoffice/tmpl/module/workplans/index.tt diff --git a/backoffice/tmp/sql.log b/backoffice/tmp/sql.log index c9589aa6..30bcaa14 100644 --- a/backoffice/tmp/sql.log +++ b/backoffice/tmp/sql.log @@ -4483,3 +4483,354 @@ $VAR1 = { 'userschemata' => 'portanova', 'idsession' => 'WnrLWKX6zKwkv8fAp1RpnKPeXePpV6TIjbk6M72b' }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu', + 'id' => '1', + 'userschemata' => 'portanova' + }; +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'id' => '1', + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'userschemata' => 'portanova', + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'id' => '1', + 'usergroups' => 'superadmin', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'userschemata' => 'portanova', + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'userschemata' => 'portanova', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'userschemata' => 'portanova', + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'username' => 'ksaffran@dks.lu', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'id' => '1', + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin' + }; +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu', + 'id' => '1', + 'userschemata' => 'portanova' + }; +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'username' => 'ksaffran@dks.lu', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'id' => '1', + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'id' => '1', + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin' + }; +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'username' => 'ksaffran@dks.lu', + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'id' => '1', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova' + }; +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu', + 'id' => '1', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin', + 'id' => '1', + 'username' => 'ksaffran@dks.lu', + 'userschemata' => 'portanova' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'username' => 'ksaffran@dks.lu' + }; +Seesion GOT! +$VAR1 = { + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'id' => '1', + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'id' => '1', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin' + }; +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'username' => 'ksaffran@dks.lu', + 'usergroups' => 'superadmin', + 'id' => '1' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'usergroups' => 'superadmin', + 'id' => '1', + 'userschemata' => 'portanova' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'id' => '1', + 'usergroups' => 'superadmin', + 'userschemata' => 'portanova', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'username' => 'ksaffran@dks.lu' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'id' => '1', + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'usergroups' => 'superadmin', + 'username' => 'ksaffran@dks.lu', + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'id' => '1', + 'userschemata' => 'portanova' + }; +parameter session = 9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU +Seesion GOT! +$VAR1 = { + 'idsession' => '9UisAitYaoxdqtBaWUI37R04CiBlFxcp0STuCOZRU', + 'userschemata' => 'portanova', + 'usergroups' => 'superadmin', + 'id' => '1', + 'username' => 'ksaffran@dks.lu' + }; diff --git a/backoffice/tmpl/module/companies/index.tt b/backoffice/tmpl/module/companies/index.tt index e990d4ae..b03a5082 100644 --- a/backoffice/tmpl/module/companies/index.tt +++ b/backoffice/tmpl/module/companies/index.tt @@ -12,7 +12,7 @@ -
+
[% END %] @@ -34,21 +34,7 @@ [% fieldeditbox('city','companies','Ville','w3-half','','','') %] [% fieldeditbox('country','companies','Pays','w3-quarter','','','Luxembourg') %]
- - - [% formsavebutton('companies','sauvegarder') %] @@ -56,7 +42,7 @@ -
+
\ No newline at end of file diff --git a/backoffice/tmpl/module/plantemplates/index.js b/backoffice/tmpl/module/plantemplates/index.js deleted file mode 100644 index 12e871f9..00000000 --- a/backoffice/tmpl/module/plantemplates/index.js +++ /dev/null @@ -1,3 +0,0 @@ -function initpage(){ - -} \ No newline at end of file diff --git a/backoffice/tmpl/module/plantemplates/index.tt b/backoffice/tmpl/module/plantemplates/index.tt deleted file mode 100644 index e69de29b..00000000 diff --git a/backoffice/tmpl/module/staff/index.js b/backoffice/tmpl/module/staff/index.js index ded1a21f..551b4c70 100644 --- a/backoffice/tmpl/module/staff/index.js +++ b/backoffice/tmpl/module/staff/index.js @@ -161,4 +161,14 @@ function viewtable() { gettbldata_staff(); document.getElementById("pnl_table").style.display = 'block'; document.getElementById("pnl_data").style.display = 'none'; +} + +function edit_staffperiodbase(){ + +} +function add_staffperiodbase(){ + +} +function remove_staffperiodbase(){ + } \ No newline at end of file diff --git a/backoffice/tmpl/module/staff/index.tt b/backoffice/tmpl/module/staff/index.tt index fe55e578..45bb6572 100644 --- a/backoffice/tmpl/module/staff/index.tt +++ b/backoffice/tmpl/module/staff/index.tt @@ -38,6 +38,12 @@
+
+ + + + +
diff --git a/backoffice/tmpl/module/workplans/index.js b/backoffice/tmpl/module/workplans/index.js new file mode 100644 index 00000000..c49cd1d5 --- /dev/null +++ b/backoffice/tmpl/module/workplans/index.js @@ -0,0 +1,104 @@ +var schemata = null; +var tbl_workplan = null; + + +function initpage(){ + schemata = parent.admin.getcurrentSchemata(); + console.log("Current Schema:" + schemata); + inittable_workplan(); + + flatpickr(".timefield",{altInput: true, + altFormat: "H:i", + dateFormat: "H:i", + allowInput: true, + enableTime: true, + noCalendar: true, + time_24hr: true, + "locale": "fr", + }); + +} + +function inittable_workplan(){ + tbl_workplan = new Tabulator("#tbl_workplan", { + headerFilterPlaceholder: "filter...", + height: "94vh", + layout: "fitDataFill", + selectable: 1, + rowContext:function(e, row){ + //e - the click event object + //row - row component + //var contextMenu = CtxMenu(); + //contextMenu.addItem("Editer", edit()); + // Add our custom function to the menu + //contextMenu.addItem("Hello World", ContextMenuExampleFunction); + + // Add a seperator + //contextMenu.addSeperator(); + e.preventDefault(); // prevent the browsers default context menu form appearing. + }, + columns: [{title: "Nom", field: "workplan",headerFilter: "input"}, + { title: "Lundi",field: "dspmontimes",formatter: "html" }, + { title: "Mardi",field: "dsptuetimes",formatter: "html" }, + { title: "Mercredi",field: "dspwedtimes",formatter: "html" }, + { title: "Jeudi",field: "dspmontimes",formatter: "html" }, + { title: "Vendredi",field: "dspmontimes",formatter: "html" }, + { title: "Samedi",field: "dspmontimes",formatter: "html" }, + { title: "Dimanche",field: "dspmontimes",formatter: "html" } + ] +}); +gettbldata_workplan(); +} + + + +function gettbldata_workplan() { + req.reqdata("POST", "db.cgi", { + "get": "workplans","schemata":schemata + }, loadtbldata_workplan); + +} + +function loadtbldata_workplan(data) { + + if (data && data.sqldata) { + tbl_workplan.setData(data.sqldata); + } +} + +function edit() { + var udata = tbl_workplan.getSelectedData(); + if (udata[0]) { + var uid = udata[0].id; + //getstaffdata(uid); + document.getElementById("pnl_table").style.display = 'none'; + document.getElementById("pnl_data").style.display = 'block'; + } + +} + +function add() { + cleanform('staff'); + viewtable(); +} + +function remove() { + var udata = tbl_workplan.getSelectedData(); + if (udata[0]) { + if (confirm("Êtes vous sûre de supprimer l'employé(e) selectionné?")) { + req.reqdata("POST", "db.cgi", { + "del": "1", + "schemata": schemata, + "ident_workplan_id": udata[0].id + }, gettbldata_workplan); + } + } + +} + +function viewtable() { + gettbldata_workplan(); + document.getElementById("pnl_table").style.display = 'block'; + document.getElementById("pnl_data").style.display = 'none'; +} + diff --git a/backoffice/tmpl/module/workplans/index.tt b/backoffice/tmpl/module/workplans/index.tt new file mode 100644 index 00000000..cd3dc8da --- /dev/null +++ b/backoffice/tmpl/module/workplans/index.tt @@ -0,0 +1,56 @@ +[% PROCESS macro/fields.tt %] +[% wd = [ + {'wd' => 'mon' ,'day' => 'Lundi'}, {'wd' => 'tue','day' => 'Mardi'}, {'wd' => 'wed','day' => 'Mercredi'}, {'wd' => 'thu','day' => 'Jeudi'}, {'wd' => 'fri','day' => 'Vendredi'}, {'wd' => 'sat' ,'day' => 'Samedi'}, {'wd' => 'sun','day' =>'Dimanche'} +] +%] +
+
+
+ + + + + + +
+
+
+
+
+ + +
-- 2.39.5