html.formproduct.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2008-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2015-2017 Francis Appels       <francis.appels@yahoo.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/>.
 */
 
require_once DOL_DOCUMENT_ROOT.'/product/stock/class/entrepot.class.php';
 
class FormProduct
{
  public $db;
 
  public $error = '';
 
  // Cache arrays
  public $cache_warehouses = array();
  public $cache_lot = array();
  public $cache_workstations = array();
 
 
  public function __construct($db)
  {
    $this->db = $db;
  }
 
 
  public function loadWarehouses($fk_product = 0, $batch = '', $status = '', $sumStock = true, $exclude = array(), $stockMin = false, $orderBy = 'e.ref')
  {
    global $conf, $langs;
 
    if (empty($fk_product) && count($this->cache_warehouses)) {
      return 0; // Cache already loaded and we do not want a list with information specific to a product
    }
 
    $warehouseStatus = array();
 
    if (preg_match('/warehouseclosed/', $status)) {
      $warehouseStatus[] = Entrepot::STATUS_CLOSED;
    }
    if (preg_match('/warehouseopen/', $status)) {
      $warehouseStatus[] = Entrepot::STATUS_OPEN_ALL;
    }
    if (preg_match('/warehouseinternal/', $status)) {
      $warehouseStatus[] = Entrepot::STATUS_OPEN_INTERNAL;
    }
 
    $sql = "SELECT e.rowid, e.ref as label, e.description, e.fk_parent";
    if (!empty($fk_product) && $fk_product > 0) {
      if (!empty($batch)) {
        $sql .= ", pb.qty as stock";
      } else {
        $sql .= ", ps.reel as stock";
      }
    } elseif ($sumStock) {
      $sql .= ", sum(ps.reel) as stock";
    }
    $sql .= " FROM ".$this->db->prefix()."entrepot as e";
    $sql .= " LEFT JOIN ".$this->db->prefix()."product_stock as ps on ps.fk_entrepot = e.rowid";
    if (!empty($fk_product) && $fk_product > 0) {
      $sql .= " AND ps.fk_product = ".((int) $fk_product);
      if (!empty($batch)) {
        $sql .= " LEFT JOIN ".$this->db->prefix()."product_batch as pb on pb.fk_product_stock = ps.rowid AND pb.batch = '".$this->db->escape($batch)."'";
      }
    }
    $sql .= " WHERE e.entity IN (".getEntity('stock').")";
    if (count($warehouseStatus)) {
      $sql .= " AND e.statut IN (".$this->db->sanitize(implode(',', $warehouseStatus)).")";
    } else {
      $sql .= " AND e.statut = 1";
    }
 
    if (is_array($exclude) && !empty($exclude)) {
      $sql .= ' AND e.rowid NOT IN('.$this->db->sanitize(implode(',', $exclude)).')';
    }
 
    // minimum stock
    if ($stockMin !== false) {
      if (!empty($fk_product) && $fk_product > 0) {
        if (!empty($batch)) {
          $sql .= " AND pb.qty > ".((float) $stockMin);
        } else {
          $sql .= " AND ps.reel > ".((float) $stockMin);
        }
      }
    }
 
    if ($sumStock && empty($fk_product)) {
      $sql .= " GROUP BY e.rowid, e.ref, e.description, e.fk_parent";
 
      // minimum stock
      if ($stockMin !== false) {
        $sql .= " HAVING sum(ps.reel) > ".((float) $stockMin);
      }
    }
    $sql .= " ORDER BY ".$orderBy;
 
    dol_syslog(get_class($this).'::loadWarehouses', LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
      $i = 0;
      while ($i < $num) {
        $obj = $this->db->fetch_object($resql);
        if ($sumStock) {
          $obj->stock = price2num($obj->stock, 5);
        }
        $this->cache_warehouses[$obj->rowid]['id'] = $obj->rowid;
        $this->cache_warehouses[$obj->rowid]['label'] = $obj->label;
        $this->cache_warehouses[$obj->rowid]['parent_id'] = $obj->fk_parent;
        $this->cache_warehouses[$obj->rowid]['description'] = $obj->description;
        $this->cache_warehouses[$obj->rowid]['stock'] = $obj->stock;
        $i++;
      }
 
      // Full label init
      foreach ($this->cache_warehouses as $obj_rowid => $tab) {
        $this->cache_warehouses[$obj_rowid]['full_label'] = $this->get_parent_path($tab);
      }
 
      return $num;
    } else {
      dol_print_error($this->db);
      return -1;
    }
  }
 
  public function loadWorkstations($fk_product = 0, $exclude = array(), $orderBy = 'w.ref')
  {
    global $conf, $langs;
 
    if (empty($fk_product) && count($this->cache_workstations)) {
      return 0; // Cache already loaded and we do not want a list with information specific to a product
    }
 
    $sql = "SELECT w.rowid, w.ref as ref, w.label as label, w.type, w.nb_operators_required,w.thm_operator_estimated,w.thm_machine_estimated";
    $sql .= " FROM ".$this->db->prefix()."workstation_workstation as w";
    $sql .= " WHERE 1 = 1";
    if (!empty($fk_product) && $fk_product > 0) {
      $sql .= " AND w.fk_product = ".((int) $fk_product);
    }
    $sql .= " AND w.entity IN (".getEntity('workstation').")";
 
    if (is_array($exclude) && !empty($exclude)) {
      $sql .= ' AND w.rowid NOT IN('.$this->db->sanitize(implode(',', $exclude)).')';
    }
 
    $sql .= " ORDER BY ".$orderBy;
 
    dol_syslog(get_class($this).'::loadWorkstations', LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
      $i = 0;
      while ($i < $num) {
        $obj = $this->db->fetch_object($resql);
 
        $this->cache_workstations[$obj->rowid]['id'] = $obj->rowid;
        $this->cache_workstations[$obj->rowid]['ref'] = $obj->ref;
        $this->cache_workstations[$obj->rowid]['label'] = $obj->label;
        $this->cache_workstations[$obj->rowid]['type'] = $obj->type;
        $this->cache_workstations[$obj->rowid]['nb_operators_required'] = $obj->nb_operators_required;
        $this->cache_workstations[$obj->rowid]['thm_operator_estimated'] = $obj->thm_operator_estimated;
        $this->cache_workstations[$obj->rowid]['thm_machine_estimated'] = $obj->thm_machine_estimated;
        $i++;
      }
 
      return $num;
    } else {
      dol_print_error($this->db);
      return -1;
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  private function get_parent_path($tab, $final_label = '')
  {
    //phpcs:enable
    if (empty($final_label)) {
      $final_label = $tab['label'];
    }
 
    if (empty($tab['parent_id'])) {
      return $final_label;
    } else {
      if (!empty($this->cache_warehouses[$tab['parent_id']])) {
        $final_label = $this->cache_warehouses[$tab['parent_id']]['label'].' >> '.$final_label;
        return $this->get_parent_path($this->cache_warehouses[$tab['parent_id']], $final_label);
      }
    }
 
    return $final_label;
  }
 
  public function selectWarehouses($selected = '', $htmlname = 'idwarehouse', $filterstatus = '', $empty = 0, $disabled = 0, $fk_product = 0, $empty_label = '', $showstock = 0, $forcecombo = 0, $events = array(), $morecss = 'minwidth200', $exclude = array(), $showfullpath = 1, $stockMin = false, $orderBy = 'e.ref', $multiselect = 0)
  {
    global $conf, $langs, $user, $hookmanager;
 
    dol_syslog(get_class($this)."::selectWarehouses $selected, $htmlname, $filterstatus, $empty, $disabled, $fk_product, $empty_label, $showstock, $forcecombo, $morecss", LOG_DEBUG);
 
    $out = '';
    if (empty($conf->global->ENTREPOT_EXTRA_STATUS)) {
      $filterstatus = '';
    }
    if (!empty($fk_product) && $fk_product > 0) {
      $this->cache_warehouses = array();
    }
 
    $this->loadWarehouses($fk_product, '', $filterstatus, true, $exclude, $stockMin, $orderBy);
    $nbofwarehouses = count($this->cache_warehouses);
 
    if ($conf->use_javascript_ajax && !$forcecombo) {
      include_once DOL_DOCUMENT_ROOT.'/core/lib/ajax.lib.php';
      $comboenhancement = ajax_combobox($htmlname, $events);
      $out .= $comboenhancement;
    }
 
    if (strpos($htmlname, 'search_') !== 0) {
      if (empty($user->fk_warehouse) || $user->fk_warehouse == -1) {
        if (is_scalar($selected) && ($selected == '-2' || $selected == 'ifone') && !empty($conf->global->MAIN_DEFAULT_WAREHOUSE)) {
          $selected = $conf->global->MAIN_DEFAULT_WAREHOUSE;
        }
      } else {
        if (is_scalar($selected) && ($selected == '-2' || $selected == 'ifone') && !empty($conf->global->MAIN_DEFAULT_WAREHOUSE_USER)) {
          $selected = $user->fk_warehouse;
        }
      }
    }
 
    $out .= '<select '.($multiselect ? 'multiple ' : '').'class="flat'.($morecss ? ' '.$morecss : '').'"'.($disabled ? ' disabled' : '');
    $out .= ' id="'.$htmlname.'" name="'.($htmlname.($multiselect?'[]':'').($disabled ? '_disabled' : '')).'"';
    //$out .= ' placeholder="todo"';  // placeholder for select2 must be added by setting the id+placeholder js param when calling select2
    $out .= '>';
    if ($empty) {
      $out .= '<option value="-1">'.($empty_label ? $empty_label : '&nbsp;').'</option>';
    }
    foreach ($this->cache_warehouses as $id => $arraytypes) {
      $label = '';
      if ($showfullpath) {
        $label .= $arraytypes['full_label'];
      } else {
        $label .= $arraytypes['label'];
      }
      if (($fk_product || ($showstock > 0)) && ($arraytypes['stock'] != 0 || ($showstock > 0))) {
        if ($arraytypes['stock'] <= 0) {
          $label .= ' <span class="text-warning">('.$langs->trans("Stock").':'.$arraytypes['stock'].')</span>';
        } else {
          $label .= ' <span class="opacitymedium">('.$langs->trans("Stock").':'.$arraytypes['stock'].')</span>';
        }
      }
 
      $out .= '<option value="'.$id.'"';
      if (is_array($selected)) {
        if (in_array($id, $selected)) {
          $out .= ' selected';
        }
      } else {
        if ($selected == $id || (preg_match('/^ifone/', $selected) && $nbofwarehouses == 1)) {
          $out .= ' selected';
        }
      }
      $out .= ' data-html="'.dol_escape_htmltag($label).'"';
      $out .= '>';
      $out .= $label;
      $out .= '</option>';
    }
    $out .= '</select>';
    if ($disabled) {
      $out .= '<input type="hidden" name="'.$htmlname.'" value="'.(($selected > 0) ? $selected : '').'">';
    }
 
    $parameters = array(
      'selected' => $selected,
      'htmlname' => $htmlname,
      'filterstatus' => $filterstatus,
      'empty' => $empty,
      'disabled ' => $disabled,
      'fk_product' => $fk_product,
      'empty_label' => $empty_label,
      'showstock' => $showstock,
      'forcecombo' => $forcecombo,
      'events' => $events,
      'morecss' => $morecss,
      'exclude' => $exclude,
      'showfullpath' => $showfullpath,
      'stockMin' => $stockMin,
      'orderBy' => $orderBy
    );
 
    $reshook = $hookmanager->executeHooks('selectWarehouses', $parameters, $this);
    if ($reshook > 0) {
      $out = $hookmanager->resPrint;
    } elseif ($reshook == 0) {
      $out .= $hookmanager->resPrint;
    }
 
    return $out;
  }
 
  public function selectWorkstations($selected = '', $htmlname = 'idworkstations', $empty = 0, $disabled = 0, $fk_product = 0, $empty_label = '', $forcecombo = 0, $events = array(), $morecss = 'minwidth200', $exclude = array(), $showfullpath = 1, $orderBy = 'e.ref')
  {
    global $conf, $langs, $user, $hookmanager;
 
    dol_syslog(get_class($this)."::selectWorkstations $selected, $htmlname, $empty, $disabled, $fk_product, $empty_label, $forcecombo, $morecss", LOG_DEBUG);
 
    $filterstatus='';
    $out = '';
    if (!empty($fk_product) && $fk_product > 0) {
      $this->cache_workstations = array();
    }
 
    $this->loadWorkstations($fk_product);
    $nbofworkstations = count($this->cache_workstations);
 
    if ($conf->use_javascript_ajax && !$forcecombo) {
      include_once DOL_DOCUMENT_ROOT.'/core/lib/ajax.lib.php';
      $comboenhancement = ajax_combobox($htmlname, $events);
      $out .= $comboenhancement;
    }
 
    if (strpos($htmlname, 'search_') !== 0) {
      if (empty($user->fk_workstation) || $user->fk_workstation == -1) {
        if (($selected == '-2' || $selected == 'ifone') && !empty($conf->global->MAIN_DEFAULT_WORKSTATION)) {
          $selected = $conf->global->MAIN_DEFAULT_WORKSTATION;
        }
      } else {
        if (($selected == '-2' || $selected == 'ifone') && !empty($conf->global->MAIN_DEFAULT_WORKSTATION)) {
          $selected = $user->fk_workstation;
        }
      }
    }
 
    $out .= '<select class="flat'.($morecss ? ' '.$morecss : '').'"'.($disabled ? ' disabled' : '').' id="'.$htmlname.'" name="'.($htmlname.($disabled ? '_disabled' : '')).'">';
    if ($empty) {
      $out .= '<option value="-1">'.($empty_label ? $empty_label : '&nbsp;').'</option>';
    }
    foreach ($this->cache_workstations as $id => $arraytypes) {
      $label = $arraytypes['label'];
 
      $out .= '<option value="'.$id.'"';
      if ($selected == $id || (preg_match('/^ifone/', $selected) && $nbofworkstations == 1)) {
        $out .= ' selected';
      }
      $out .= ' data-html="'.dol_escape_htmltag($label).'"';
      $out .= '>';
      $out .= $label;
      $out .= '</option>';
    }
    $out .= '</select>';
    if ($disabled) {
      $out .= '<input type="hidden" name="'.$htmlname.'" value="'.(($selected > 0) ? $selected : '').'">';
    }
 
    $parameters = array(
      'selected' => $selected,
      'htmlname' => $htmlname,
      'filterstatus' => $filterstatus,
      'empty' => $empty,
      'disabled ' => $disabled,
      'fk_product' => $fk_product,
      'empty_label' => $empty_label,
      'forcecombo' => $forcecombo,
      'events' => $events,
      'morecss' => $morecss,
      'exclude' => $exclude,
      'showfullpath' => $showfullpath,
      'orderBy' => $orderBy
    );
 
    $reshook = $hookmanager->executeHooks('selectWorkstations', $parameters, $this);
    if ($reshook > 0) {
      $out = $hookmanager->resPrint;
    } elseif ($reshook == 0) {
      $out .= $hookmanager->resPrint;
    }
 
    return $out;
  }
 
  public function formSelectWarehouses($page, $selected = '', $htmlname = 'warehouse_id', $addempty = 0)
  {
    global $langs;
    if ($htmlname != "none") {
      print '<form method="POST" action="'.$page.'">';
      print '<input type="hidden" name="action" value="setwarehouse">';
      print '<input type="hidden" name="token" value="'.newToken().'">';
      print '<table class="nobordernopadding">';
      print '<tr><td>';
      print $this->selectWarehouses($selected, $htmlname, '', $addempty);
      print '</td>';
      print '<td class="left"><input type="submit" class="button smallpaddingimp" value="'.$langs->trans("Modify").'"></td>';
      print '</tr></table></form>';
    } else {
      if ($selected) {
        require_once DOL_DOCUMENT_ROOT.'/product/stock/class/entrepot.class.php';
        $warehousestatic = new Entrepot($this->db);
        $warehousestatic->fetch($selected);
        print $warehousestatic->getNomUrl();
      } else {
        print "&nbsp;";
      }
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function select_measuring_units($name = 'measuring_units', $measuring_style = '', $default = '0', $adddefault = 0, $mode = 0)
  {
    //phpcs:enable
    print $this->selectMeasuringUnits($name, $measuring_style, $default, $adddefault, $mode);
  }
 
  public function selectMeasuringUnits($name = 'measuring_units', $measuring_style = '', $default = '0', $adddefault = 0, $mode = 0, $morecss = 'maxwidth125')
  {
    global $langs, $conf, $mysoc, $db;
 
    $langs->load("other");
 
    $return = '';
 
    // TODO Use a cache
    require_once DOL_DOCUMENT_ROOT.'/core/class/cunits.class.php';
    $measuringUnits = new CUnits($db);
 
    $filter = array();
    $filter['t.active'] = 1;
    if ($measuring_style) {
      $filter['t.unit_type'] = $measuring_style;
    }
 
    $result = $measuringUnits->fetchAll(
      '',
      '',
      0,
      0,
      $filter
    );
    if ($result < 0) {
      dol_print_error($db);
      return -1;
    } else {
      $return .= '<select class="flat'.($morecss ? ' '.$morecss : '').'" name="'.$name.'" id="'.$name.'">';
      if ($adddefault || $adddefault === '') {
        $return .= '<option value="0">'.($adddefault ? $langs->trans("Default") : '').'</option>';
      }
 
      foreach ($measuringUnits->records as $lines) {
        $return .= '<option value="';
        if ($mode == 1) {
          $return .= $lines->short_label;
        } elseif ($mode == 2) {
          $return .= $lines->scale;
        } else {
          $return .= $lines->id;
        }
        $return .= '"';
        if ($mode == 1 && $lines->short_label == $default) {
          $return .= ' selected';
        } elseif ($mode == 2 && $lines->scale == $default) {
          $return .= ' selected';
        } elseif ($mode == 0 && $lines->id == $default) {
          $return .= ' selected';
        }
        $return .= '>';
        if ($measuring_style == 'time') {
          $return .= $langs->trans(ucfirst($lines->label));
        } else {
          $return .= $langs->trans($lines->label);
        }
        $return .= '</option>';
      }
      $return .= '</select>';
    }
 
    $return .= ajax_combobox($name);
 
    return $return;
  }
 
  public function selectProductNature($name = 'finished', $selected = '', $mode = 0, $showempty = 1)
  {
    global $langs, $db;
 
    $langs->load('products');
 
    $return = '';
 
    // TODO Use a cache
    require_once DOL_DOCUMENT_ROOT.'/core/class/cproductnature.class.php';
    $productNature = new CProductNature($db);
 
    $filter = array();
    $filter['t.active'] = 1;
 
    $result = $productNature->fetchAll('', '', 0, 0, $filter);
 
    if ($result < 0) {
      dol_print_error($db);
      return -1;
    } else {
      $return .= '<select class="flat" name="'.$name.'" id="'.$name.'">';
      if ($showempty || ($selected == '' || $selected == '-1')) {
        $return .= '<option value="-1"';
        if ($selected == '' || $selected == '-1') {
          $return .= ' selected';
        }
        $return .= '></option>';
      }
      if (!empty($productNature->records) && is_array($productNature->records)) {
        foreach ($productNature->records as $lines) {
          $return .= '<option value="';
          if ($mode == 1) {
            $return .= $lines->label;
          } else {
            $return .= $lines->code;
          }
 
          $return .= '"';
 
          if ($mode == 1 && $lines->label == $selected) {
            $return .= ' selected';
          } elseif ($lines->code == $selected) {
            $return .= ' selected';
          }
 
          $return .= '>';
          $return .= $langs->trans($lines->label);
          $return .= '</option>';
        }
      }
      $return .= '</select>';
    }
 
    $return .= ajax_combobox($name);
 
    return $return;
  }
 
  public function selectLotStock($selected = '', $htmlname = 'batch_id', $filterstatus = '', $empty = 0, $disabled = 0, $fk_product = 0, $fk_entrepot = 0, $objectLines = array(), $empty_label = '', $forcecombo = 0, $events = array(), $morecss = 'minwidth200')
  {
    global $conf, $langs;
 
    dol_syslog(get_class($this)."::selectLotStock $selected, $htmlname, $filterstatus, $empty, $disabled, $fk_product, $fk_entrepot, $empty_label, $forcecombo, $morecss", LOG_DEBUG);
 
    $out = '';
    $productIdArray = array();
    if (!is_array($objectLines) || !count($objectLines)) {
      if (!empty($fk_product) && $fk_product > 0) {
        $productIdArray[] = (int) $fk_product;
      }
    } else {
      foreach ($objectLines as $line) {
        if ($line->fk_product) {
          $productIdArray[] = $line->fk_product;
        }
      }
    }
 
    $nboflot = $this->loadLotStock($productIdArray);
 
    if ($conf->use_javascript_ajax && !$forcecombo) {
      include_once DOL_DOCUMENT_ROOT.'/core/lib/ajax.lib.php';
      $comboenhancement = ajax_combobox($htmlname, $events);
      $out .= $comboenhancement;
    }
 
    $out .= '<select class="flat'.($morecss ? ' '.$morecss : '').'"'.($disabled ? ' disabled' : '').' id="'.$htmlname.'" name="'.($htmlname.($disabled ? '_disabled' : '')).'">';
    if ($empty) {
      $out .= '<option value="-1">'.($empty_label ? $empty_label : '&nbsp;').'</option>';
    }
    if (!empty($fk_product) && $fk_product > 0) {
      $productIdArray = array((int) $fk_product); // only show lot stock for product
    } else {
      foreach ($this->cache_lot as $key => $value) {
        $productIdArray[] = $key;
      }
    }
 
    foreach ($productIdArray as $productId) {
      foreach ($this->cache_lot[$productId] as $id => $arraytypes) {
        if (empty($fk_entrepot) || $fk_entrepot == $arraytypes['entrepot_id']) {
          $label = $arraytypes['entrepot_label'].' - ';
          $label .= $arraytypes['batch'];
          if ($arraytypes['qty'] <= 0) {
            $label .= ' <span class=\'text-warning\'>('.$langs->trans("Stock").' '.$arraytypes['qty'].')</span>';
          } else {
            $label .= ' <span class=\'opacitymedium\'>('.$langs->trans("Stock").' '.$arraytypes['qty'].')</span>';
          }
 
          $out .= '<option value="'.$id.'"';
 
          if ($selected == $id || ($selected == 'ifone' && $nboflot == 1)) {
            $out .= ' selected';
          }
          $out .= ' data-html="'.dol_escape_htmltag($label).'"';
          $out .= '>';
          $out .= $label;
          $out .= '</option>';
        }
      }
    }
    $out .= '</select>';
    if ($disabled) {
      $out .= '<input type="hidden" name="'.$htmlname.'" value="'.(($selected > 0) ? $selected : '').'">';
    }
 
    return $out;
  }
 
 
 
  public function selectLotDataList($htmlname = 'batch_id', $empty = 0, $fk_product = 0, $fk_entrepot = 0, $objectLines = array())
  {
    global $langs;
 
    dol_syslog(get_class($this)."::selectLotDataList $htmlname, $empty, $fk_product, $fk_entrepot", LOG_DEBUG);
 
    $out = '';
    $productIdArray = array();
    if (!is_array($objectLines) || !count($objectLines)) {
      if (!empty($fk_product) && $fk_product > 0) {
        $productIdArray[] = (int) $fk_product;
      }
    } else {
      foreach ($objectLines as $line) {
        if ($line->fk_product) {
          $productIdArray[] = $line->fk_product;
        }
      }
    }
 
    $nboflot = $this->loadLotStock($productIdArray);
 
    $out .= '<datalist id="'.$htmlname.'" >';
 
    if (!empty($fk_product) && $fk_product > 0) {
      $productIdArray = array((int) $fk_product); // only show lot stock for product
    } else {
      foreach ($this->cache_lot as $key => $value) {
        $productIdArray[] = $key;
      }
    }
 
    foreach ($productIdArray as $productId) {
      if (array_key_exists($productId, $this->cache_lot)) {
        foreach ($this->cache_lot[$productId] as $id => $arraytypes) {
          if (empty($fk_entrepot) || $fk_entrepot == $arraytypes['entrepot_id']) {
            $label = $arraytypes['entrepot_label'] . ' - ';
            $label .= $arraytypes['batch'];
            $out .= '<option data-warehouse="'.dol_escape_htmltag($label).'" value="' . $arraytypes['batch'] . '">(' . $langs->trans('Stock Total') . ': ' . $arraytypes['qty'] . ')</option>';
          }
        }
      }
    }
    $out .= '</datalist>';
 
    return $out;
  }
 
 
  private function loadLotStock($productIdArray = array())
  {
    global $conf, $langs;
 
    $cacheLoaded = false;
    if (empty($productIdArray)) {
      // only Load lot stock for given products
      $this->cache_lot = array();
      return 0;
    }
    if (count($productIdArray) && count($this->cache_lot)) {
      // check cache already loaded for product id's
      foreach ($productIdArray as $productId) {
        $cacheLoaded = !empty($this->cache_lot[$productId]) ? true : false;
      }
    }
    if ($cacheLoaded) {
      return count($this->cache_lot);
    } else {
      // clear cache
      $this->cache_lot = array();
      $productIdList = implode(',', $productIdArray);
 
      $batch_count = 0;
      global $hookmanager;
      if (empty($hookmanager)) {
        include_once DOL_DOCUMENT_ROOT . '/core/class/hookmanager.class.php';
        $hookmanager = new HookManager($this->db);
      }
      $hookmanager->initHooks(array('productdao'));
      $parameters = array('productIdList' => $productIdList);
      $reshook = $hookmanager->executeHooks('loadLotStock', $parameters, $this);
      if ($reshook < 0) {
        $this->error = $hookmanager->error;
        return -1;
      }
      if (!empty($hookmanager->resArray['batch_list']) && is_array($hookmanager->resArray['batch_list'])) {
        $this->cache_lot = $hookmanager->resArray['batch_list'];
        $batch_count = (int) $hookmanager->resArray['batch_count'];
      }
      if ($reshook > 0) {
        return $batch_count;
      }
 
      $sql = "SELECT pb.batch, pb.rowid, ps.fk_entrepot, pb.qty, e.ref as label, ps.fk_product";
      $sql .= " FROM ".$this->db->prefix()."product_batch as pb";
      $sql .= " LEFT JOIN ".$this->db->prefix()."product_stock as ps on ps.rowid = pb.fk_product_stock";
      $sql .= " LEFT JOIN ".$this->db->prefix()."entrepot as e on e.rowid = ps.fk_entrepot AND e.entity IN (".getEntity('stock').")";
      if (!empty($productIdList)) {
        $sql .= " WHERE ps.fk_product IN (".$this->db->sanitize($productIdList).")";
      }
      $sql .= " ORDER BY e.ref, pb.batch";
 
      dol_syslog(get_class($this).'::loadLotStock', LOG_DEBUG);
      $resql = $this->db->query($sql);
      if ($resql) {
        $num = $this->db->num_rows($resql);
        $i = 0;
        while ($i < $num) {
          $obj = $this->db->fetch_object($resql);
          $this->cache_lot[$obj->fk_product][$obj->rowid]['id'] = $obj->rowid;
          $this->cache_lot[$obj->fk_product][$obj->rowid]['batch'] = $obj->batch;
          $this->cache_lot[$obj->fk_product][$obj->rowid]['entrepot_id'] = $obj->fk_entrepot;
          $this->cache_lot[$obj->fk_product][$obj->rowid]['entrepot_label'] = $obj->label;
          $this->cache_lot[$obj->fk_product][$obj->rowid]['qty'] = $obj->qty;
          $i++;
        }
 
        return $batch_count + $num;
      } else {
        dol_print_error($this->db);
        return -1;
      }
    }
  }
}