dolreceiptprinter.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2015-2021  Frédéric France     <frederic.france@netlogic.fr>
 * Copyright (C) 2020       Andreu Bisquerra    <jove@bisquerra.com>
 *
 * 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/>.
 * or see https://www.gnu.org/
 */
 
/*
 * Tags for ticket template
 *
 * {dol_align_left}                                 Left align text
 * {dol_align_center}                               Center text
 * {dol_align_right}                                Right align text
 * {dol_use_font_a}                                 Use font A of printer
 * {dol_use_font_b}                                 Use font B of printer
 * {dol_use_font_c}                                 Use font C of printer
 * {dol_bold}                                       Text Bold
 * {dol_bold_disabled}                              Disable Text Bold
 * {dol_double_height}                              Text double height
 * {dol_double_width}                               Text double width
 * {dol_default_height_width}                       Text default height and width
 * {dol_underline}                                  Underline text
 * {dol_underline_disabled}                         Disable underline text
 * {dol_cut_paper_full}                             Cut ticket completely
 * {dol_cut_paper_partial}                          Cut ticket partially
 * {dol_open_drawer}                                Open cash drawer
 * {dol_beep}                                       Activate buzzer
 * {dol_beep_alternative}             Activate buzzer (alternative mode)
 * {dol_print_barcode}                              Print barcode
 * {dol_print_logo}                                 Print logo stored on printer. Example : <print_logo>32|32
 * {dol_print_logo_old}                             Print logo stored on printer. Must be followed by logo code. For old printers.
 * {dol_print_logo_old_cf}                          Print logo stored on printer. Must be followed by logo code. For old printers. May help for centering image.
 * {dol_print_object_lines}                         Print object lines
 * {dol_print_object_tax}                           Print object total tax
 * {dol_print_object_local_tax}                     Print object local tax
 * {dol_print_object_total}                         Print object total
 * {dol_print_order_lines}                          Print order lines for Printer
 * {dol_print_object_lines_with_notes}              Print object lines with notes
 * {dol_print_payment}                              Print payment method
 * {dol_print_curr_date}              Print the current date/time. Must be followed by format string.
 *
 * Code which can be placed everywhere
 * <dol_value_date>                                 Replaced by date AAAA-MM-DD
 * <dol_value_date_time>                            Replaced by date and time AAAA-MM-DD HH:MM:SS
 * <dol_value_year>                                 Replaced by Year
 * <dol_value_month_letters>                        Replaced by month in letters (example : november)
 * <dol_value_month>                                Replaced by month number
 * <dol_value_day>                                  Replaced by day number
 * <dol_value_day_letters>                          Replaced by day number
 * <dol_value_currentdate>                          Replaced by current date and time
 * <dol_value_currentdate_notime>                   Replaced by current date without time
 * <dol_object_id>                                  Replaced by object id
 * <dol_object_ref>                                 Replaced by object ref
 * <dol_value_customer_firstname>                   Replaced by customer firstname
 * <dol_value_customer_lastname>                    Replaced by customer name
 * <dol_value_customer_mail>                        Replaced by customer mail
 * <dol_value_customer_phone>                       Replaced by customer phone
 * <dol_value_customer_mobile>                      Replaced by customer mobile
 * <dol_value_customer_skype>                       Replaced by customer skype
 * <dol_value_customer_tax_number>                  Replaced by customer VAT number
 * <dol_value_customer_account_balance>             Replaced by customer account balance
 * <dol_value_mysoc_name>                           Replaced by mysoc name
 * <dol_value_mysoc_address>                        Replaced by mysoc address
 * <dol_value_mysoc_zip>                            Replaced by mysoc zip
 * <dol_value_mysoc_town>                           Replaced by mysoc town
 * <dol_value_mysoc_country>                        Replaced by mysoc country
 * <dol_value_mysoc_idprof1>                        Replaced by mysoc idprof1
 * <dol_value_mysoc_idprof2>                        Replaced by mysoc idprof2
 * <dol_value_mysoc_idprof3>                        Replaced by mysoc idprof3
 * <dol_value_mysoc_idprof4>                        Replaced by mysoc idprof4
 * <dol_value_mysoc_idprof5>                        Replaced by mysoc idprof5
 * <dol_value_mysoc_idprof6>                        Replaced by mysoc idprof6
 * <dol_value_vendor_lastname>                      Replaced by vendor name
 * <dol_value_vendor_firstname>                     Replaced by vendor firstname
 * <dol_value_vendor_mail>                          Replaced by vendor mail
 * <dol_value_customer_points>                      Replaced by customer points
 * <dol_value_object_points>                        Replaced by number of points for this object
 *
 * Conditional code at line start (if then Print)
 * <dol_print_if_customer>                          Print the line IF a customer is affected to the object
 * <dol_print_if_vendor>                            Print the line IF a vendor is affected to the object
 * <dol_print_if_happy_hour>                        Print the line IF Happy Hour
 * <dol_print_if_num_object_unique>                 Print the line IF object is validated
 * <dol_print_if_customer_points>                   Print the line IF customer points > 0
 * <dol_print_if_object_points>                     Print the line IF points of the object > 0
 * <dol_print_if_customer_tax_number>               Print the line IF customer has vat number
 * <dol_print_if_customer_account_balance_positive> Print the line IF customer balance > 0
 *
 */
 
require_once DOL_DOCUMENT_ROOT.'/includes/mike42/escpos-php/autoload.php';
use Mike42\Escpos\PrintConnectors\FilePrintConnector;
use Mike42\Escpos\PrintConnectors\NetworkPrintConnector;
use Mike42\Escpos\PrintConnectors\WindowsPrintConnector;
use Mike42\Escpos\PrintConnectors\CupsPrintConnector;
use Mike42\Escpos\PrintConnectors\DummyPrintConnector;
use Mike42\Escpos\CapabilityProfile;
use Mike42\Escpos\Printer;
use Mike42\Escpos\EscposImage;
 
class dolReceiptPrinter extends Printer
{
  const CONNECTOR_DUMMY = 1;
  const CONNECTOR_FILE_PRINT = 2;
  const CONNECTOR_NETWORK_PRINT = 3;
  const CONNECTOR_WINDOWS_PRINT = 4;
  const CONNECTOR_CUPS_PRINT = 5;
 
  public $db;
 
  /*
   * @var string[] array of tags
   */
  public $tags;
  public $printer;
  public $template;
 
  public $orderprinter;
 
  public $listprinters;
 
  public $listprinterstemplates;
 
  public $error = '';
 
  public $errors = array();
 
  public function __construct($db)
  {
    $this->db = $db;
    $this->tags = array(
      'dol_line_feed' => 'DOL_LINE_FEED',
      'dol_line_feed_reverse' => 'DOL_LINE_FEED_REVERSE',
      'dol_align_left' => 'DOL_ALIGN_LEFT',
      'dol_align_center' => 'DOL_ALIGN_CENTER',
      'dol_align_right' => 'DOL_ALIGN_RIGHT',
      'dol_use_font_a' => 'DOL_USE_FONT_A',
      'dol_use_font_b' => 'DOL_USE_FONT_B',
      'dol_use_font_c' => 'DOL_USE_FONT_C',
      'dol_bold' => 'DOL_BOLD',
      'dol_bold_disabled' => 'DOL_BOLD_DISABLED',
      'dol_double_height' => 'DOL_DOUBLE_HEIGHT',
      'dol_double_width' => 'DOL_DOUBLE_WIDTH',
      'dol_default_height_width' => 'DOL_DEFAULT_HEIGHT_WIDTH',
      'dol_underline' => 'DOL_UNDERLINE',
      'dol_underline_disabled' => 'DOL_UNDERLINE_DISABLED',
      'dol_cut_paper_full' => 'DOL_CUT_PAPER_FULL',
      'dol_cut_paper_partial' => 'DOL_CUT_PAPER_PARTIAL',
      'dol_open_drawer' => 'DOL_OPEN_DRAWER',
      'dol_beep' => 'DOL_BEEP',
      'dol_beep_alternative' => 'DOL_BEEP_ALTERNATIVE',
      'dol_print_text' => 'DOL_PRINT_TEXT',
      'dol_print_barcode' => 'DOL_PRINT_BARCODE',
      'dol_value_date' => 'DateInvoice',
      'dol_value_date_time' => 'DateInvoiceWithTime',
      'dol_value_year' => 'YearInvoice',
      'dol_value_month_letters' => 'DOL_VALUE_MONTH_LETTERS',
      'dol_value_month' => 'DOL_VALUE_MONTH',
      'dol_value_day' => 'DOL_VALUE_DAY',
      'dol_value_day_letters' => 'DOL_VALUE_DAY',
      'dol_value_currentdate' => 'DOL_VALUE_CURRENTDATE',
      'dol_value_currentdate_notime' => 'CurrentDateWithTime',
      'dol_value_currentdate_letters' => 'DOL_VALUE_CURRENTDATE_LETTERS',
      'dol_value_currentyear' => 'CurrentYear',
      'dol_value_currentmonth_letters' => 'DOL_VALUE_CURRENT_MONTH_LETTERS',
      'dol_value_currentmonth' => 'DOL_VALUE_CURRENT_MONTH',
      'dol_value_currentday' => 'DOL_VALUE_CURRENT_DAY',
      'dol_value_currentday_letters' => 'DOL_VALUE_CURRENT_DAY',
      'dol_print_payment' => 'DOL_PRINT_PAYMENT',
      'dol_print_curr_date' => 'DOL_PRINT_CURR_DATE',
      'dol_print_logo' => 'DOL_PRINT_LOGO',
      'dol_print_logo_old' => 'DOL_PRINT_LOGO_OLD',
      'dol_print_logo_old_cf' => 'DOL_PRINT_LOGO_OLD_CF',
      'dol_value_object_id' => 'InvoiceID',
      'dol_value_object_ref' => 'InvoiceRef',
      'dol_print_object_lines' => 'DOL_PRINT_OBJECT_LINES',
      'dol_print_object_lines_with_notes' => 'DOL_PRINT_OBJECT_LINES_WITH_NOTES',
      'dol_print_object_tax' => 'TotalVAT',
      'dol_print_object_local_tax1' => 'TotalLT1',
      'dol_print_object_local_tax2' => 'TotalLT2',
      'dol_print_object_total' => 'Total',
      'dol_print_object_number' => 'DOL_PRINT_OBJECT_NUMBER',
      //'dol_value_object_points' => 'DOL_VALUE_OBJECT_POINTS',
      'dol_print_order_lines' => 'DOL_PRINT_ORDER_LINES',
      'dol_value_customer_firstname' => 'DOL_VALUE_CUSTOMER_FIRSTNAME',
      'dol_value_customer_lastname' => 'DOL_VALUE_CUSTOMER_LASTNAME',
      'dol_value_customer_mail' => 'DOL_VALUE_CUSTOMER_MAIL',
      'dol_value_customer_phone' => 'DOL_VALUE_CUSTOMER_PHONE',
      'dol_value_customer_skype' => 'DOL_VALUE_CUSTOMER_SKYPE',
      'dol_value_customer_tax_number' => 'DOL_VALUE_CUSTOMER_TAX_NUMBER',
      //'dol_value_customer_account_balance' => 'DOL_VALUE_CUSTOMER_ACCOUNT_BALANCE',
      //'dol_value_customer_points' => 'DOL_VALUE_CUSTOMER_POINTS',
      'dol_value_mysoc_name' => 'DOL_VALUE_MYSOC_NAME',
      'dol_value_mysoc_address' => 'Address',
      'dol_value_mysoc_zip' => 'Zip',
      'dol_value_mysoc_town' => 'Town',
      'dol_value_mysoc_country' => 'Country',
      'dol_value_mysoc_idprof1' => 'ProfId1',
      'dol_value_mysoc_idprof2' => 'ProfId2',
      'dol_value_mysoc_idprof3' => 'ProfId3',
      'dol_value_mysoc_idprof4' => 'ProfId4',
      'dol_value_mysoc_idprof5' => 'ProfId5',
      'dol_value_mysoc_idprof6' => 'ProfId6',
      'dol_value_mysoc_tva_intra' => 'VATIntra',
      'dol_value_mysoc_capital' => 'Capital',
      'dol_value_mysoc_url' => 'Web',
      'dol_value_vendor_lastname' => 'VendorLastname',
      'dol_value_vendor_firstname' => 'VendorFirstname',
      'dol_value_vendor_mail' => 'VendorEmail',
      'dol_value_place' => 'DOL_VALUE_PLACE',
    );
  }
 
  public function listPrinters()
  {
    global $conf;
 
    $error = 0;
    $line = 0;
    $obj = array();
 
    $sql = "SELECT rowid, name, fk_type, fk_profile, parameter";
    $sql .= " FROM ".$this->db->prefix()."printer_receipt";
    $sql .= " WHERE entity = ".((int) $conf->entity);
 
    $resql = $this->db->query($sql);
 
    if ($resql) {
      $num = $this->db->num_rows($resql);
      while ($line < $num) {
        $row = $this->db->fetch_array($resql);
        switch ($row['fk_type']) {
          case 1:
            $row['fk_type_name'] = 'CONNECTOR_DUMMY';
            break;
          case 2:
            $row['fk_type_name'] = 'CONNECTOR_FILE_PRINT';
            break;
          case 3:
            $row['fk_type_name'] = 'CONNECTOR_NETWORK_PRINT';
            break;
          case 4:
            $row['fk_type_name'] = 'CONNECTOR_WINDOWS_PRINT';
            break;
          case 5:
            $row['fk_type_name'] = 'CONNECTOR_CUPS_PRINT';
            break;
          default:
            $row['fk_type_name'] = 'CONNECTOR_UNKNOWN';
            break;
        }
        switch ($row['fk_profile']) {
          case 0:
            $row['fk_profile_name'] = 'PROFILE_DEFAULT';
            break;
          case 1:
            $row['fk_profile_name'] = 'PROFILE_SIMPLE';
            break;
          case 2:
            $row['fk_profile_name'] = 'PROFILE_EPOSTEP';
            break;
          case 3:
            $row['fk_profile_name'] = 'PROFILE_P822D';
            break;
          default:
            $row['fk_profile_name'] = 'PROFILE_STAR';
            break;
        }
        $obj[] = $row;
        $line++;
      }
    } else {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
 
    $this->listprinters = $obj;
 
    return $error;
  }
 
 
  public function listPrintersTemplates()
  {
    global $conf;
 
    $error = 0;
    $line = 0;
    $obj = array();
 
    $sql = "SELECT rowid, name, template";
    $sql .= " FROM ".$this->db->prefix()."printer_receipt_template";
    $sql .= " WHERE entity = ".$conf->entity;
 
    $resql = $this->db->query($sql);
 
    if ($resql) {
      $num = $this->db->num_rows($resql);
      while ($line < $num) {
        $obj[] = $this->db->fetch_array($resql);
        $line++;
      }
    } else {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
 
    $this->listprinterstemplates = $obj;
 
    return $error;
  }
 
 
  public function selectTypePrinter($selected = '', $htmlname = 'printertypeid')
  {
    global $langs;
 
    $options = array(
      1 => $langs->trans('CONNECTOR_DUMMY'),
      2 => $langs->trans('CONNECTOR_FILE_PRINT'),
      3 => $langs->trans('CONNECTOR_NETWORK_PRINT'),
      4 => $langs->trans('CONNECTOR_WINDOWS_PRINT'),
      5 => $langs->trans('CONNECTOR_CUPS_PRINT'),
    );
 
    $this->resprint = Form::selectarray($htmlname, $options, $selected);
 
    return 0;
  }
 
 
  public function selectProfilePrinter($selected = '', $htmlname = 'printerprofileid')
  {
    global $langs;
 
    $options = array(
      0 => $langs->trans('PROFILE_DEFAULT'),
      1 => $langs->trans('PROFILE_SIMPLE'),
      2 => $langs->trans('PROFILE_EPOSTEP'),
      3 => $langs->trans('PROFILE_P822D'),
      4 => $langs->trans('PROFILE_STAR'),
    );
 
    $this->profileresprint = Form::selectarray($htmlname, $options, $selected);
    return 0;
  }
 
 
  public function addPrinter($name, $type, $profile, $parameter)
  {
    global $conf;
    $error = 0;
    $sql = "INSERT INTO ".$this->db->prefix()."printer_receipt";
    $sql .= " (name, fk_type, fk_profile, parameter, entity)";
    $sql .= " VALUES ('".$this->db->escape($name)."', ".((int) $type).", ".((int) $profile).", '".$this->db->escape($parameter)."', ".((int) $conf->entity).")";
    $resql = $this->db->query($sql);
    if (!$resql) {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    return $error;
  }
 
  public function updatePrinter($name, $type, $profile, $parameter, $printerid)
  {
    global $conf;
    $error = 0;
 
    $sql = "UPDATE ".$this->db->prefix()."printer_receipt";
    $sql .= " SET name='".$this->db->escape($name)."'";
    $sql .= ", fk_type=".((int) $type);
    $sql .= ", fk_profile=".((int) $profile);
    $sql .= ", parameter='".$this->db->escape($parameter)."'";
    $sql .= " WHERE rowid=".((int) $printerid);
 
    $resql = $this->db->query($sql);
    if (!$resql) {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    return $error;
  }
 
  public function deletePrinter($printerid)
  {
    global $conf;
    $error = 0;
    $sql = 'DELETE FROM '.$this->db->prefix().'printer_receipt';
    $sql .= ' WHERE rowid='.((int) $printerid);
    $resql = $this->db->query($sql);
    if (!$resql) {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    return $error;
  }
 
  public function addTemplate($name, $template)
  {
    global $conf;
    $error = 0;
    $sql = "INSERT INTO ".$this->db->prefix()."printer_receipt_template";
    $sql .= " (name, template, entity) VALUES ('".$this->db->escape($name)."'";
    $sql .= ", '".$this->db->escape($template)."', ".$conf->entity.")";
    $resql = $this->db->query($sql);
    if (!$resql) {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    return $error;
  }
 
  public function deleteTemplate($templateid)
  {
    global $conf;
    $error = 0;
    $sql = 'DELETE FROM '.$this->db->prefix().'printer_receipt_template';
    $sql .= " WHERE rowid = ".((int) $templateid);
    $sql .= " AND entity = ".$conf->entity;
    $resql = $this->db->query($sql);
    if (!$resql) {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    return $error;
  }
 
  public function updateTemplate($name, $template, $templateid)
  {
    global $conf;
    $error = 0;
 
    $sql = "UPDATE ".$this->db->prefix()."printer_receipt_template";
    $sql .= " SET name='".$this->db->escape($name)."'";
    $sql .= ", template='".$this->db->escape($template)."'";
    $sql .= " WHERE rowid=".((int) $templateid);
    $resql = $this->db->query($sql);
    if (!$resql) {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    return $error;
  }
 
 
  public function sendTestToPrinter($printerid)
  {
    global $conf;
 
    $error = 0;
    $img = EscposImage::load(DOL_DOCUMENT_ROOT.'/theme/dolibarr_logo_bw.png');
    //$this->profile = CapabilityProfile::load("TM-T88IV");
    $ret = $this->initPrinter($printerid);
    if ($ret > 0) {
      setEventMessages($this->error, $this->errors, 'errors');
    } else {
      try {
        $this->printer->bitImage($img);
        $this->printer->text("Hello World!\n");
        $testStr = "1234567890";
        $this->printer->barcode($testStr);
        //$this->printer->qrcode($testStr, Printer::QR_ECLEVEL_M, 5, Printer::QR_MODEL_1);
        $this->printer->text("Most simple example\n");
        $this->printer->feed();
        $this->printer->cut();
 
        // If is DummyPrintConnector send to log to debugging
        if ($this->printer->connector instanceof DummyPrintConnector) {
          $data = $this->printer->connector->getData();
          dol_syslog($data);
        }
        $this->printer->close();
      } catch (Exception $e) {
        $this->errors[] = $e->getMessage();
        $error++;
      }
    }
    return $error;
  }
 
  public function sendToPrinter($object, $templateid, $printerid)
  {
    global $conf, $mysoc, $langs, $user;
 
    $langs->load('bills');
 
    $error = 0;
    $ret = $this->loadTemplate($templateid);
    $now = dol_now('tzuser');
    // tags a remplacer par leur valeur avant de parser (dol_value_xxx)
    $this->template = str_replace('{dol_value_object_id}', $object->id, $this->template);
    $this->template = str_replace('{dol_value_object_ref}', $object->ref, $this->template);
    //$this->template = str_replace('<dol_value_object_points>', $object->points, $this->template);
    $this->template = str_replace('{dol_value_date}', dol_print_date($object->date, 'day'), $this->template);
    $this->template = str_replace('{dol_value_date_time}', dol_print_date($object->date, 'dayhour'), $this->template);
    $this->template = str_replace('{dol_value_year}', dol_print_date($object->date, '%Y'), $this->template);
    $this->template = str_replace('{dol_value_month_letters}', $langs->trans("Month".dol_print_date($object->date, '%m')), $this->template);
    $this->template = str_replace('{dol_value_month}', dol_print_date($object->date, '%m'), $this->template);
    $this->template = str_replace('{dol_value_day}', dol_print_date($object->date, '%d'), $this->template);
    $this->template = str_replace('{dol_value_day_letters}', $langs->trans("Day".dol_print_date($object->date, '%m')[1]), $this->template);
 
    $this->template = str_replace('{dol_value_currentdate}', dol_print_date($now, 'dayhour'), $this->template);
    $this->template = str_replace('{dol_value_currentdate_notime}', dol_print_date($now, 'day'), $this->template);
    $this->template = str_replace('{dol_value_currentdate_letters}', dol_print_date($now, 'dayhourtext'), $this->template);
    $this->template = str_replace('{dol_value_currentyear}', dol_print_date($now, '%Y'), $this->template);
    $this->template = str_replace('{dol_value_currentmonth_letters}', $langs->trans("Month".dol_print_date($now, '%m')), $this->template);
    $this->template = str_replace('{dol_value_currentmonth}', dol_print_date($now, '%m'), $this->template);
    $this->template = str_replace('{dol_value_currentday}', dol_print_date($now, '%d'), $this->template);
    $this->template = str_replace('{dol_value_currentday_letters}', $langs->trans("Day".dol_print_date($now, '%m')[1]), $this->template);
 
    $this->template = str_replace('{dol_value_customer_firstname}', $object->thirdparty->firstname, $this->template);
    $this->template = str_replace('{dol_value_customer_lastname}', $object->thirdparty->lastname, $this->template);
    $this->template = str_replace('{dol_value_customer_mail}', $object->thirdparty->email, $this->template);
    $this->template = str_replace('{dol_value_customer_phone}', $object->thirdparty->phone, $this->template);
    //$this->template = str_replace('<dol_value_customer_mobile>', $object->thirdparty->mobile, $this->template);
    $this->template = str_replace('{dol_value_customer_tax_number}', $object->thirdparty->tva_intra, $this->template);
    //$this->template = str_replace('<dol_value_customer_account_balance>', $object->customer_account_balance, $this->template);
    //$this->template = str_replace('<dol_value_customer_points>', $object->customer_points, $this->template);
 
    $this->template = str_replace('{dol_value_mysoc_name}', $mysoc->name, $this->template);
    $this->template = str_replace('{dol_value_mysoc_address}', $mysoc->address, $this->template);
    $this->template = str_replace('{dol_value_mysoc_zip}', $mysoc->zip, $this->template);
    $this->template = str_replace('{dol_value_mysoc_town}', $mysoc->town, $this->template);
    $this->template = str_replace('{dol_value_mysoc_country}', $mysoc->country, $this->template);
    $this->template = str_replace('{dol_value_mysoc_idprof1}', $mysoc->idprof1, $this->template);
    $this->template = str_replace('{dol_value_mysoc_idprof2}', $mysoc->idprof2, $this->template);
    $this->template = str_replace('{dol_value_mysoc_idprof3}', $mysoc->idprof3, $this->template);
    $this->template = str_replace('{dol_value_mysoc_idprof4}', $mysoc->idprof4, $this->template);
    $this->template = str_replace('{dol_value_mysoc_idprof5}', $mysoc->idprof5, $this->template);
    $this->template = str_replace('{dol_value_mysoc_idprof6}', $mysoc->idprof6, $this->template);
    $this->template = str_replace('{dol_value_mysoc_tva_intra}', $mysoc->tva_intra, $this->template);
    $this->template = str_replace('{dol_value_mysoc_capital}', $mysoc->capital, $this->template);
    $this->template = str_replace('{dol_value_mysoc_url}', $mysoc->url, $this->template);
 
    $this->template = str_replace('{dol_value_vendor_firstname}', $user->firstname, $this->template);
    $this->template = str_replace('{dol_value_vendor_lastname}', $user->lastname, $this->template);
    $this->template = str_replace('{dol_value_vendor_mail}', $user->email, $this->template);
 
    // parse template
    $this->template = str_replace("{", "<", $this->template);
    $this->template = str_replace("}", ">", $this->template);
    $p = xml_parser_create();
    xml_parse_into_struct($p, $this->template, $vals, $index);
    xml_parser_free($p);
    //print '<pre>'.print_r($index, true).'</pre>';
    //print '<pre>'.print_r($vals, true).'</pre>';
    // print ticket
    $level = 0;
    $nbcharactbyline = (!empty($conf->global->RECEIPT_PRINTER_NB_CHARACT_BY_LINE) ? $conf->global->RECEIPT_PRINTER_NB_CHARACT_BY_LINE : 48);
    $ret = $this->initPrinter($printerid);
    if ($ret > 0) {
      setEventMessages($this->error, $this->errors, 'errors');
    } else {
      $nboflines = count($vals);
      for ($tplline = 0; $tplline < $nboflines; $tplline++) {
        //var_dump($vals[$tplline]['value']);
        switch ($vals[$tplline]['tag']) {
          case 'DOL_PRINT_TEXT':
            $this->printer->text($vals[$tplline]['value']);
            break;
          case 'DOL_PRINT_OBJECT_LINES':
            foreach ($object->lines as $line) {
              if ($line->fk_product) {
                $spacestoadd = $nbcharactbyline - strlen($line->ref) - strlen($line->qty) - strlen($line->subprice) - 10 - 1;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $this->printer->text($line->ref . $spaces . $line->qty . str_pad(price($line->subprice), 10, ' ', STR_PAD_LEFT) . ' ' . str_pad(price($line->total_ttc), 10, ' ', STR_PAD_LEFT) . "\n");
                $this->printer->text(strip_tags(htmlspecialchars_decode($line->product_label))."\n \n");
              } else {
                $spacestoadd = $nbcharactbyline - strlen($line->description) - strlen($line->qty) - strlen($line->subprice) - 10 - 1;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $this->printer->text($line->description.$spaces.$line->qty.' '.str_pad(price($line->subprice), 10, ' ', STR_PAD_LEFT).' '.str_pad(price($line->total_ttc), 10, ' ', STR_PAD_LEFT)."\n");
              }
            }
            break;
          case 'DOL_PRINT_OBJECT_LINES_WITH_NOTES':
            foreach ($object->lines as $line) {
              if ($line->fk_product) {
                $spacestoadd = $nbcharactbyline - strlen($line->ref) - strlen($line->qty) - 10 - 1;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $this->printer->text($line->ref.$spaces.$line->qty.' '.str_pad(price($line->total_ttc), 10, ' ', STR_PAD_LEFT)."\n");
                $this->printer->text(strip_tags(htmlspecialchars_decode($line->product_label))."\n");
                $spacestoadd = $nbcharactbyline - strlen($line->description) - strlen($line->qty) - 10 - 1;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $this->printer->text($line->description."\n");
              } else {
                $spacestoadd = $nbcharactbyline - strlen($line->description) - strlen($line->qty) - 10 - 1;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $this->printer->text($line->description.$spaces.$line->qty.' '.str_pad(price($line->total_ttc), 10, ' ', STR_PAD_LEFT)."\n");
              }
            }
            break;
          case 'DOL_PRINT_OBJECT_TAX':
            //var_dump($object);
            $vatarray = array();
            foreach ($object->lines as $line) {
              $vatarray[$line->tva_tx] += $line->total_tva;
            }
            foreach ($vatarray as $vatkey => $vatvalue) {
              $spacestoadd = $nbcharactbyline - strlen($vatkey) - 12;
              $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
              $this->printer->text($spaces.$vatkey.'% '.str_pad(price($vatvalue), 10, ' ', STR_PAD_LEFT)."\n");
            }
            break;
          case 'DOL_PRINT_OBJECT_TAX1':
            //var_dump($object);
            $total_localtax1 = 0;
            foreach ($object->lines as $line) {
              $total_localtax1 += $line->total_localtax1;
            }
            $this->printer->text(str_pad(price($total_localtax1), 10, ' ', STR_PAD_LEFT)."\n");
            break;
          case 'DOL_PRINT_OBJECT_TAX2':
            //var_dump($object);
            $total_localtax2 = 0;
            foreach ($object->lines as $line) {
              $total_localtax2 += $line->total_localtax2;
            }
            $this->printer->text(str_pad(price($total_localtax2), 10, ' ', STR_PAD_LEFT)."\n");
            break;
          case 'DOL_PRINT_OBJECT_TOTAL':
            $title = $langs->trans('TotalHT');
            $spacestoadd = $nbcharactbyline - strlen($title) - 10;
            $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
            $this->printer->text($title.$spaces.str_pad(price($object->total_ht), 10, ' ', STR_PAD_LEFT)."\n");
            $title = $langs->trans('TotalVAT');
            $spacestoadd = $nbcharactbyline - strlen($title) - 10;
            $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
            $this->printer->text($title.$spaces.str_pad(price($object->total_tva), 10, ' ', STR_PAD_LEFT)."\n");
            $title = $langs->trans('TotalTTC');
            $spacestoadd = $nbcharactbyline - strlen($title) - 10;
            $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
            $this->printer->text($title.$spaces.str_pad(price($object->total_ttc), 10, ' ', STR_PAD_LEFT)."\n");
            break;
          case 'DOL_PRINT_CURR_DATE':
            if (strlen($vals[$tplline]['value'])<2) $this->printer->text(date('d/m/Y H:i:s')."\n");
            else $this->printer->text(date($vals[$tplline]['value'])."\n");
            break;
          case 'DOL_LINE_FEED':
            $this->printer->feed();
            break;
          case 'DOL_LINE_FEED_REVERSE':
            $this->printer->feedReverse();
            break;
          case 'DOL_ALIGN_CENTER':
            $this->printer->setJustification(Printer::JUSTIFY_CENTER);
            break;
          case 'DOL_ALIGN_RIGHT':
            $this->printer->setJustification(Printer::JUSTIFY_RIGHT);
            break;
          case 'DOL_ALIGN_LEFT':
            $this->printer->setJustification(Printer::JUSTIFY_LEFT);
            break;
          case 'DOL_OPEN_DRAWER':
            $this->printer->pulse();
            break;
          case 'DOL_ACTIVATE_BUZZER':
            //$this->printer->buzzer();
            break;
          case 'DOL_PRINT_BARCODE':
            // $vals[$tplline]['value'] -> barcode($content, $type)
            // var_dump($vals[$tplline]['value']);
            try {
              $this->printer->barcode($vals[$tplline]['value']);
            } catch (Exception $e) {
              $this->errors[] = 'Invalid Barcode value: '.$vals[$tplline]['value'];
              $error++;
            }
            break;
          case 'DOL_PRINT_LOGO':
            $img = EscposImage::load(DOL_DATA_ROOT.'/mycompany/logos/'.$mysoc->logo);
            $this->printer->graphics($img);
            break;
          case 'DOL_PRINT_LOGO_OLD':
            $img = EscposImage::load(DOL_DATA_ROOT.'/mycompany/logos/'.$mysoc->logo);
            $this->printer->bitImage($img);
            break;
          case 'DOL_PRINT_LOGO_OLD_CF':
            $img = EscposImage::load(DOL_DATA_ROOT.'/mycompany/logos/'.$mysoc->logo);
            $this->printer->bitImageColumnFormat($img);
            break;
          case 'DOL_PRINT_QRCODE':
            // $vals[$tplline]['value'] -> qrCode($content, $ec, $size, $model)
            $this->printer->qrcode($vals[$tplline]['value']);
            break;
          case 'DOL_CUT_PAPER_FULL':
            $this->printer->cut(Printer::CUT_FULL);
            break;
          case 'DOL_CUT_PAPER_PARTIAL':
            $this->printer->cut(Printer::CUT_PARTIAL);
            break;
          case 'DOL_USE_FONT_A':
            $this->printer->setFont(Printer::FONT_A);
            break;
          case 'DOL_USE_FONT_B':
            $this->printer->setFont(Printer::FONT_B);
            break;
          case 'DOL_USE_FONT_C':
            $this->printer->setFont(Printer::FONT_C);
            break;
          case 'DOL_BOLD':
            $this->printer->setEmphasis(true);
            break;
          case 'DOL_BOLD_DISABLED':
            $this->printer->setEmphasis(false);
            break;
          case 'DOL_DOUBLE_HEIGHT':
            $this->printer->setTextSize(1, 2);
            break;
          case 'DOL_DOUBLE_WIDTH':
            $this->printer->setTextSize(2, 1);
            break;
          case 'DOL_DEFAULT_HEIGHT_WIDTH':
            $this->printer->setTextSize(1, 1);
            break;
          case 'DOL_UNDERLINE':
            $this->printer->setUnderline(true);
            break;
          case 'DOL_UNDERLINE_DISABLED':
            $this->printer->setUnderline(false);
            break;
          case 'DOL_BEEP':
            $this->printer->getPrintConnector() -> write("\x1e");
            break;
          case 'DOL_BEEP_ALTERNATIVE': //if DOL_BEEP not works
            $this->printer->getPrintConnector() -> write(Printer::ESC . "B" . chr(4) . chr(1));
            break;
          case 'DOL_PRINT_ORDER_LINES':
            foreach ($object->lines as $line) {
              if ($line->special_code == $this->orderprinter) {
                $spacestoadd = $nbcharactbyline - strlen($line->ref) - strlen($line->qty) - 10 - 1;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $this->printer->text($line->ref.$spaces.$line->qty.' '.str_pad(price($line->total_ttc), 10, ' ', STR_PAD_LEFT)."\n");
                $this->printer->text(strip_tags(htmlspecialchars_decode($line->desc))."\n");
              }
            }
            break;
          case 'DOL_PRINT_PAYMENT':
            $sql = "SELECT p.pos_change as pos_change, p.datep as date, p.fk_paiement, p.num_paiement as num, pf.amount as amount, pf.multicurrency_amount,";
            $sql .= " cp.code";
            $sql .= " FROM ".$this->db->prefix()."paiement_facture as pf, ".$this->db->prefix()."paiement as p";
            $sql .= " LEFT JOIN ".$this->db->prefix()."c_paiement as cp ON p.fk_paiement = cp.id";
            $sql .= " WHERE pf.fk_paiement = p.rowid AND pf.fk_facture = ".((int) $object->id);
            $sql .= " ORDER BY p.datep";
            $resql = $this->db->query($sql);
            if ($resql) {
              $num = $this->db->num_rows($resql);
              $i = 0;
              while ($i < $num) {
                $row = $this->db->fetch_object($resql);
                $spacestoadd = $nbcharactbyline - strlen($langs->transnoentitiesnoconv("PaymentTypeShort".$row->code)) - 12;
                $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                $amount_payment = (isModEnabled("multicurrency") && $object->multicurrency_tx != 1) ? $row->multicurrency_amount : $row->amount;
                if ($row->code == "LIQ") {
                  $amount_payment = $amount_payment + $row->pos_change; // Show amount with excess received if is cash payment
                }
                $this->printer->text($spaces.$langs->transnoentitiesnoconv("PaymentTypeShort".$row->code).' '.str_pad(price($amount_payment), 10, ' ', STR_PAD_LEFT)."\n");
                if ($row->code == "LIQ" && $row->pos_change > 0) { // Print change only in cash payments
                  $spacestoadd = $nbcharactbyline - strlen($langs->trans("Change")) - 12;
                  $spaces = str_repeat(' ', $spacestoadd > 0 ? $spacestoadd : 0);
                  $this->printer->text($spaces.$langs->trans("Change").' '.str_pad(price($row->pos_change), 10, ' ', STR_PAD_LEFT)."\n");
                }
                $i++;
              }
            }
            break;
          case 'DOL_VALUE_PLACE':
            $sql = "SELECT floor, label FROM ".$this->db->prefix()."takepos_floor_tables where rowid=".((int) str_replace(")", "", str_replace("(PROV-POS".$_SESSION["takeposterminal"]."-", "", $object->ref)));
            $resql = $this->db->query($sql);
            $obj = $this->db->fetch_object($resql);
            if ($obj) {
              $this->printer->text($obj->label);
            }
            break;
          default:
            $this->printer->text($vals[$tplline]['tag']);
            $this->printer->text($vals[$tplline]['value']);
            $this->errors[] = 'UnknowTag: &lt;'.strtolower($vals[$tplline]['tag']).'&gt;';
            $error++;
            break;
        }
      }
      // If is DummyPrintConnector send to log to debugging
      if ($this->printer->connector instanceof DummyPrintConnector || $conf->global->TAKEPOS_PRINT_METHOD == "takeposconnector") {
        $data = $this->printer->connector->getData();
        if ($conf->global->TAKEPOS_PRINT_METHOD == "takeposconnector") {
          echo rtrim(strtr(base64_encode($data), '+/', '-_'), '=');
        }
        dol_syslog($data);
      }
      // Close and print
      $this->printer->close();
    }
    return $error;
  }
 
  public function loadTemplate($templateid)
  {
    global $conf;
    $error = 0;
    $sql = "SELECT template";
    $sql .= " FROM ".$this->db->prefix()."printer_receipt_template";
    $sql .= " WHERE rowid = ".((int) $templateid);
    $sql .= " AND entity = ".$conf->entity;
    $resql = $this->db->query($sql);
    if ($resql) {
      $obj = $this->db->fetch_array($resql);
    } else {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
    if (empty($obj)) {
      $error++;
      $this->errors[] = 'TemplateDontExist';
    } else {
      $this->template = $obj['0'];
    }
 
    return $error;
  }
 
 
  public function initPrinter($printerid)
  {
    global $conf;
    if (getDolGlobalString('TAKEPOS_PRINT_METHOD') == "takeposconnector") {
      $this->connector = new DummyPrintConnector();
      $this->printer = new Printer($this->connector, $this->profile);
      return;
    }
    $error = 0;
    $sql = "SELECT rowid, name, fk_type, fk_profile, parameter";
    $sql .= " FROM ".$this->db->prefix()."printer_receipt";
    $sql .= " WHERE rowid = ".((int) $printerid);
    $sql .= " AND entity = ".((int) $conf->entity);
    $resql = $this->db->query($sql);
    if ($resql) {
      $obj = $this->db->fetch_array($resql);
      if (empty($obj)) {
        $error++;
        $this->errors[] = 'PrinterDontExist';
      }
      if (!$error) {
        $parameter = (isset($obj['parameter']) ? $obj['parameter'] : '');
        try {
          $type = $obj['fk_type'];
          switch ($type) {
            case 1:
              $this->connector = new DummyPrintConnector();
              break;
            case 2:
              $this->connector = new FilePrintConnector($parameter);
              break;
            case 3:
              $parameters = explode(':', $parameter);
              $this->connector = new NetworkPrintConnector($parameters[0], $parameters[1]);
              break;
            case 4: // LPT1, smb://...
              $this->connector = new WindowsPrintConnector(dol_sanitizePathName($parameter));
              break;
            case 5:
              $this->connector = new CupsPrintConnector($parameter);
              break;
            default:
              $this->connector = 'CONNECTOR_UNKNOWN';
              break;
          }
          $this->printer = new Printer($this->connector, $this->profile);
        } catch (Exception $e) {
          $this->errors[] = $e->getMessage();
          $error++;
        }
      }
    } else {
      $error++;
      $this->errors[] = $this->db->lasterror;
    }
 
    return $error;
  }
}