From ea7f15f02fff15a10549a35a68083d2180fc7b96 Mon Sep 17 00:00:00 2001
From: Kilian Saffran <ksaffran@dks.lu>
Date: Mon, 18 Mar 2019 21:53:53 +0100
Subject: [PATCH] paywindow products and groups

---
 js/database.js               |  3 ++
 modules/paywindow/index.html | 71 ++++++++++++++++++++++++++----------
 modules/paywindow/index.js   | 32 +++++++++++++++-
 3 files changed, 84 insertions(+), 22 deletions(-)

diff --git a/js/database.js b/js/database.js
index c94a3c9..54a0a59 100644
--- a/js/database.js
+++ b/js/database.js
@@ -1,6 +1,9 @@
 var appdb = {
 		//dbfile: null,
 		url: null,
+		secvalue: function(text){
+			return text.replace(/'/g,"''");
+		},
 		dbquery: function(sQuery){
 			var type='querysorted';
 			var result= {sqldata:[]};
diff --git a/modules/paywindow/index.html b/modules/paywindow/index.html
index 100a375..cf9ef2e 100644
--- a/modules/paywindow/index.html
+++ b/modules/paywindow/index.html
@@ -27,26 +27,67 @@
   </div>
 </nav>
 <div class="cotainer-fluid bg-white" style="margin-top: 52px;">
-  <div class="row">
+  <div class="row" style="margin: 0px;">
     <div class="col-sm-3">
-      <table class="table table-bordered table-striped" data-table="toggle" style="width: 100%;">
+      <table class="table table-bordered table-striped" id="checkout" style="width: 100%;min-height: 75vh;">
         <thead class="thead-dark">
           <tr>
-            <th>Anz.</th>
-            <th>Einkauf</th>
-            <th></th>
+            <th style="vertical-align: middle;width: 45px;">Anz.</th>
+            <th style="vertical-align: middle;">Einkauf</th>
+            <th style="padding: 0px;width: 45px;"><button class="btn btn-danger"><i class="fas fa-broom"></i><br/>Neu</button></th>
           </tr>
         </thead>
         <tbody>
         </tbody>
       </table>
+      <div class="row"  style="margin: 0px;">
+        <div class="col-sm-6">
+          <button class="btn btn-primary btn-block"><i class="fas fa-money-bill-alt"></i><br>Bargeld-Buchung</button>
+        </div>
+        <div class="col-sm-6">
+          <button class="btn btn-primary btn-block"><i class="fas fa-credit-card"></i><br>Karten-Buchung</button>
+          </div>
+      </div>
     </div>
-    <div class="col-sm-7">
-      <div class="row">
+    <div class="col-sm-3">
+      <table class="table table-bordered table-striped" data-table="toggle" id="producttable1" style="width: 100%;">
+        <thead class="thead-dark">
+          <tr>
+            <th  style="padding: 0px;"></th><select id="grouplist1" class="form-control" placeholder="group"  onchange="load_productgroup('1');"></select></th>
+          </tr>
+        </thead>
+        <tbody>
+        </tbody>
+      </table>
+    </div>
+    <div class="col-sm-3">
+      <table class="table table-bordered table-striped" data-table="toggle"  id="producttable2" style="width: 100%;">
+        <thead class="thead-dark">
+          <tr>
+            <th style="padding: 0px;"></th><select id="grouplist2" class="form-control" placeholder="group"  onchange="load_productgroup('2');"></select></th>
+          </tr>
+        </thead>
+        <tbody>
+        </tbody>
+      </table>
+    </div>
+    <div class="col-sm-3">
+      <table class="table table-bordered table-striped" data-table="toggle"  id="producttable3" style="width: 100%;"  >
+        <thead class="thead-dark">
+          <tr>
+            <th style="padding: 0px;"><select id="grouplist3"  class="form-control" placeholder="group" onchange="load_productgroup('3');"></select></th>
+          </tr>
+        </thead>
+        <tbody>
+        </tbody>
+      </table>
+    </div>
+    
+      <!--<div class="row">
         <div class="col-sm-12">
           <nav class="navbar navbar-dark bg-dark">
             <div class="mr-auto">
-              <div class="btn-group" role="group" aria-label="Groups">
+              <div class="btn-group" role="group" aria-label="Groups" id="groupbuttons">
                 <button class="btn btn-primary" onclick="loadgroup();"><i class="fas fa-folder-open"></i><br/>Gruppe 1</button>
                 <button class="btn btn-primary" onclick="loadgroup();"><i class="fas fa-folder-open"></i><br/>Gruppe 2</button>
                 <button class="btn btn-primary" onclick="loadgroup();"><i class="fas fa-folder-open"></i><br/>Gruppe 3</button>
@@ -81,18 +122,8 @@
           <button class="btn btn-secondary" onclick="addproduct();">Produkt 5</button>  
         </div>
       </div>
-    </div>
-    <div class="col-sm-2">
-        <table class="table table-bordered table-striped" style="width: 100%;">
-          <thead class="thead-dark">
-            <tr>
-              <th>Tisch/Kunde</th>
-            </tr>
-          </thead>
-          <tbody>
-          </tbody>
-        </table>
-    </div>
+    </div>-->
+    
   </div>
   
 </div>
diff --git a/modules/paywindow/index.js b/modules/paywindow/index.js
index ef22d6b..515c742 100644
--- a/modules/paywindow/index.js
+++ b/modules/paywindow/index.js
@@ -1,13 +1,41 @@
 var winh = Math.max(document.documentElement.clientHeight, window.innerHeight || 0);
 
 function initpage(){
-  
+  load_group_selects();
 }
 
 function loadadmin(){
   parent.browserapp.loadmodule('overview');
 }
 
-function load_group_buttons(){
+function load_group_selects(){
+  var sql = "select productgroup from products group by productgroup;";
+  var opts = "";
+  var data = appdb.dbquery(sql);
+  for (var i in data.sqldata){
+    opts += '<option value="'+data.sqldata[i].productgroup+'">'+data.sqldata[i].productgroup+'</option>';
+  }
+  $("#grouplist1").append(opts);
+  $("#grouplist2").append(opts);
+  $("#grouplist3").append(opts);
+}
+
+function load_productgroup(listnum){
+  var listval = $("#grouplist" + listnum + " :selected").val();
+  console.log(listval);
+  $('#producttable' + listnum + " > tbody").html("");
+  var sql ="select id,name,specification,replace(printf(\"%.2f\",grossamount),'.',',') as grossamount from products where productgroup='"+appdb.secvalue(listval)+"';";
+  var products = appdb.dbquery(sql);
+  
+  for (var i in products.sqldata){
+    var trow = '<tr>';
+    trow += '<td class="font-weight-bold"><div onclick="addproduct(\''+ products.sqldata[i].id +'\')">' + products.sqldata[i].name+'<br/><span class="font-weight-normal">'+ products.sqldata[i].specification +'</span><span class="badge badge-secondary float-right">'+products.sqldata[i].grossamount+'€</span><div></td>';
+    trow += '</tr>';
+    $('#producttable' + listnum + " > tbody").append(trow.replace(/null/g,''));
+  }
+}
+
+function addproduct(idproduct){
+  console.log(idproduct);
   
 }
-- 
2.39.5