floors.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2018 Andreu Bisquerra  <jove@bisquerra.com>
 * Copyright (C) 2024   MDW             <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024       Frédéric France         <frederic.france@free.fr>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
//if (! defined('NOREQUIREUSER')) define('NOREQUIREUSER','1');  // Not disabled cause need to load personalized language
//if (! defined('NOREQUIREDB'))   define('NOREQUIREDB','1');    // Not disabled cause need to load personalized language
//if (! defined('NOREQUIRESOC'))  define('NOREQUIRESOC','1');
//if (! defined('NOREQUIRETRAN')) define('NOREQUIRETRAN','1');
if (!defined('NOREQUIREMENU')) {
  define('NOREQUIREMENU', '1');
}
if (!defined('NOREQUIREHTML')) {
  define('NOREQUIREHTML', '1');
}
if (!defined('NOREQUIREAJAX')) {
  define('NOREQUIREAJAX', '1');
}
 
// Load Dolibarr environment
require '../main.inc.php'; // Load $user and permissions
require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
$langs->loadLangs(array("bills", "orders", "commercial", "cashdesk"));
 
$floor = GETPOSTINT('floor');
if ($floor == "") {
  $floor = 1;
}
$id = GETPOSTINT('id');
$action = GETPOST('action', 'aZ09');
$left = GETPOST('left', 'alpha');
$top = GETPOST('top', 'alpha');
 
$place = (GETPOST('place', 'aZ09') ? GETPOST('place', 'aZ09') : 0); // $place is id of table for Bar or Restaurant
 
$newname = GETPOST('newname', 'alpha');
$mode = GETPOST('mode', 'alpha');
 
if (!$user->hasRight('takepos', 'run')) {
  accessforbidden();
}
 
 
/*
 * Actions
 */
 
if ($action == "getTables" && $user->hasRight('takepos', 'run')) {
  $rows = array();
 
  $sql = "SELECT rowid, entity, label, leftpos, toppos, floor";
  $sql .= " FROM ".MAIN_DB_PREFIX."takepos_floor_tables";
  $sql .= " WHERE floor = ".((int) $floor)." AND entity IN (".getEntity('takepos').")";
 
  $resql = $db->query($sql);
  while ($row = $db->fetch_array($resql)) {
    $tmpplace = (int) $row['rowid'];
 
    $invoice = new Facture($db);
    $result = $invoice->fetch('', '(PROV-POS'.$_SESSION['takeposterminal'].'-'.$tmpplace.')');
    if ($result > 0) {
      $row['occupied'] = "red";
    }
 
    $rows[] = $row;
  }
 
  top_httphead('application/json');
  echo json_encode($rows);
  exit;
}
 
if ($action == "update" && $user->hasRight('takepos', 'run')) {
  if ($left > 95) {
    $left = 95;
  }
  if ($top > 95) {
    $top = 95;
  }
  if ($left > 3 or $top > 4) {
    $db->query("UPDATE ".MAIN_DB_PREFIX."takepos_floor_tables SET leftpos = ".((int) $left).", toppos = ".((int) $top)." WHERE rowid = ".((int) $place));
  } else {
    $db->query("DELETE from ".MAIN_DB_PREFIX."takepos_floor_tables WHERE rowid = ".((int) $place));
  }
}
 
if ($action == "updatename" && $user->hasRight('takepos', 'run')) {
  $newname = preg_replace("/[^a-zA-Z0-9\s]/", "", $newname); // Only English chars
  if (strlen($newname) > 3) {
    $newname = substr($newname, 0, 3); // Only 3 chars
  }
  $resql = $db->query("UPDATE ".MAIN_DB_PREFIX."takepos_floor_tables SET label='".$db->escape($newname)."' WHERE rowid = ".((int) $place));
}
 
if ($action == "add" && $user->hasRight('takepos', 'run')) {
  $sql = "INSERT INTO ".MAIN_DB_PREFIX."takepos_floor_tables(entity, label, leftpos, toppos, floor) VALUES (".$conf->entity.", '', '45', '45', ".((int) $floor).")";
  $asdf = $db->query($sql);
  $db->query("UPDATE ".MAIN_DB_PREFIX."takepos_floor_tables SET label = rowid WHERE label = ''"); // No empty table names
}
 
 
/*
 * View
 */
 
// Title
$head = '';
$title = 'TakePOS - Dolibarr '.DOL_VERSION;
if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
  $title = 'TakePOS - ' . getDolGlobalString('MAIN_APPLICATION_TITLE');
}
$arrayofcss = array('/takepos/css/pos.css.php?a=xxx');
 
top_htmlhead($head, $title, 0, 0, array(), $arrayofcss);
 
?>
<body style="overflow: hidden">
 
<style type="text/css">
div.tablediv{
  background-image:url(img/table.gif);
  -moz-background-size:100% 100%;
  -webkit-background-size:100% 100%;
  background-size:100% 100%;
  height:10%;
  width:10%;
  text-align: center;
  font-size:300%;
  color:white;
}
 
/* Color when a table has a pending order/invoice */
div.red{
  color:red;
}
</style>
 
<script>
var DragDrop='<?php echo $langs->trans("DragDrop"); ?>';
 
function updateplace(idplace, left, top) {
  console.log("updateplace idplace="+idplace+" left="+left+" top="+top);
  $.ajax({
    type: "POST",
    url: "<?php echo DOL_URL_ROOT.'/takepos/floors.php'; ?>",
    data: { action: "update", left: left, top: top, place: idplace, token: '<?php echo currentToken(); ?>' }
  }).done(function( msg ) {
    window.location.href='floors.php?mode=edit&floor=<?php echo urlencode((string) ($floor)); ?>';
  });
}
 
function updatename(rowid) {
  var after=$("#tablename"+rowid).text();
  console.log("updatename rowid="+rowid+" after="+after);
  $.ajax({
    type: "POST",
    url: "<?php echo DOL_URL_ROOT.'/takepos/floors.php'; ?>",
    data: { action: "updatename", place: rowid, newname: after, token: '<?php echo currentToken(); ?>' }
  }).done(function( msg ) {
    window.location.href='floors.php?mode=edit&floor=<?php echo urlencode((string) ($floor)); ?>';
  });
}
 
function LoadPlace(place){
  parent.location.href='index.php?place='+place;
}
 
 
$( document ).ready(function() {
  $.getJSON('./floors.php?action=getTables&token=<?php echo newToken();?>&floor=<?php echo $floor; ?>', function(data) {
    $.each(data, function(key, val) {
      <?php if ($mode == "edit") {?>
      $('body').append('<div class="tablediv" contenteditable onblur="updatename('+val.rowid+');" style="position: absolute; left: '+val.leftpos+'%; top: '+val.toppos+'%;" id="tablename'+val.rowid+'">'+val.label+'</div>');
      $( "#tablename"+val.rowid ).draggable(
        {
          start: function() {
          $("#add").html("<?php echo $langs->trans("Delete"); ?>");
          },
          stop: function() {
          var left=$(this).offset().left*100/$(window).width();
          var top=$(this).offset().top*100/$(window).height();
          updateplace($(this).attr('id').substr(9), left, top);
          }
        }
      );
      //simultaneous draggable and contenteditable
      $('#'+val.label).draggable().bind('click', function(){
        $(this).focus();
      })
      <?php } else {?>
      $('body').append('<div class="tablediv '+val.occupied+'" onclick="LoadPlace('+val.rowid+');" style="position: absolute; left: '+val.leftpos+'%; top: '+val.toppos+'%;" id="tablename'+val.rowid+'">'+val.label+'</div>');
      <?php } ?>
    });
  });
});
 
</script>
 
<?php if ($user->admin) {?>
<div style="position: absolute; left: 0.1%; top: 0.8%; width:8%; height:11%;">
  <?php if ($mode == "edit") {?>
<a id="add" onclick="window.location.href='floors.php?mode=edit&action=add&token=<?php echo newToken() ?>&floor=<?php echo $floor; ?>';"><?php echo $langs->trans("AddTable"); ?></a>
  <?php } else { ?>
<a onclick="window.location.href='floors.php?mode=edit&token=<?php echo newToken() ?>&floor=<?php echo $floor; ?>';"><?php echo $langs->trans("Edit"); ?></a>
  <?php } ?>
</div>
<?php }
?>
 
<div style="position: absolute; left: 25%; bottom: 8%; width:50%; height:3%;">
  <center>
  <h1>
  <?php if ($floor > 1) { ?>
  <img class="valignmiddle" src="./img/arrow-prev.png" width="5%" onclick="location.href='floors.php?floor=<?php if ($floor > 1) {
    $floor--;
    echo $floor;
    $floor++;
                                                       } else {
                                                         echo "1";
                                                       } ?>';">
  <?php } ?>
  <span class="valignmiddle"><?php echo $langs->trans("Floor")." ".$floor; ?></span>
  <img src="./img/arrow-next.png" class="valignmiddle" width="5%" onclick="location.href='floors.php?floor=<?php $floor++;
  echo $floor; ?>';">
  </h1>
  </center>
</div>
 
</body>
</html>