actions_card_service.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2010-2018 Regis Houssin  <regis.houssin@inodbox.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/>.
 */
 
include_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
 
 
class ActionsCardService
{
  public $targetmodule;
  public $canvas;
  public $card;
 
  public $tpl = array();
 
  // List of fiels for action=list
  public $field_list = array();
  public $list_datas = array();
 
  public $id;
  public $ref;
  public $description;
  public $note;
  public $price;
  public $price_min;
 
 
  public function __construct($db, $targetmodule, $canvas, $card)
  {
    $this->db = $db;
    $this->targetmodule = $targetmodule;
    $this->canvas           = $canvas;
    $this->card             = $card;
 
    $this->module = "service";
    $this->name = "service";
    $this->definition = "Services canvas";
    $this->fieldListName = "product_service";
    $this->next_prev_filter = "canvas='service'";
  }
 
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function assign_values(&$action, $id = 0, $ref = '')
  {
    // phpcs:enable
    global $limit, $offset, $sortfield, $sortorder;
    global $conf, $langs, $user, $mysoc, $canvas;
    global $form, $formproduct;
 
    $tmpobject = new Product($this->db);
    if (!empty($id) || !empty($ref)) {
      $tmpobject->fetch($id, $ref);
    }
    $this->object = $tmpobject;
 
    //parent::assign_values($action);
 
    foreach ($this->object as $key => $value) {
      $this->tpl[$key] = $value;
    }
 
    $this->tpl['error'] = get_htmloutput_errors($this->object->error, $this->object->errors);
 
    // canvas
    $this->tpl['canvas'] = $this->canvas;
 
    // id
    $this->tpl['id'] = $this->id;
 
    // Ref
    $this->tpl['ref'] = $this->ref;
 
    // Label
    $this->tpl['label'] = $this->label;
 
    // Description
    $this->tpl['description'] = nl2br($this->description);
 
    // Statut
    $this->tpl['status'] = $this->object->getLibStatut(2);
 
    // Note
    $this->tpl['note'] = nl2br($this->note);
 
    if ($action == 'create') {
      // Price
      $this->tpl['price'] = $this->price;
      $this->tpl['price_min'] = $this->price_min;
      $this->tpl['price_base_type'] = $form->selectPriceBaseType($this->price_base_type, "price_base_type");
 
      // VAT
      $this->tpl['tva_tx'] = $form->load_tva("tva_tx", -1, $mysoc, '');
    }
 
    if ($action == 'view') {
      $head = product_prepare_head($this->object);
 
      $this->tpl['showrefnav'] = $form->showrefnav($this->object, 'ref', '', 1, 'ref');
 
      $titre = $langs->trans("CardProduct".$this->object->type);
      $picto = ($this->object->type == Product::TYPE_SERVICE ? 'service' : 'product');
      $this->tpl['showhead'] = dol_get_fiche_head($head, 'card', $titre, 0, $picto);
      $this->tpl['showend'] = dol_get_fiche_end();
 
      // Accountancy buy code
      $this->tpl['accountancyBuyCodeKey'] = $form->editfieldkey("ProductAccountancyBuyCode", 'productaccountancycodesell', $this->accountancy_code_sell, $this, $user->rights->produit->creer);
      $this->tpl['accountancyBuyCodeVal'] = $form->editfieldval("ProductAccountancyBuyCode", 'productaccountancycodesell', $this->accountancy_code_sell, $this, $user->rights->produit->creer);
 
      // Accountancy sell code
      $this->tpl['accountancySellCodeKey'] = $form->editfieldkey("ProductAccountancySellCode", 'productaccountancycodebuy', $this->accountancy_code_buy, $this, $user->rights->produit->creer);
      $this->tpl['accountancySellCodeVal'] = $form->editfieldval("ProductAccountancySellCode", 'productaccountancycodebuy', $this->accountancy_code_buy, $this, $user->rights->produit->creer);
    }
 
    $this->tpl['finished'] = $this->object->finished;
    $this->tpl['ref'] = $this->object->ref;
    $this->tpl['label'] = $this->object->label;
    $this->tpl['id'] = $this->object->id;
    $this->tpl['type'] = $this->object->type;
    $this->tpl['note'] = $this->object->note;
    $this->tpl['seuil_stock_alerte'] = $this->object->seuil_stock_alerte;
 
    // Duration
    $this->tpl['duration_value'] = $this->object->duration_value;
 
    if ($action == 'create') {
      // Title
      $this->tpl['title'] = $langs->trans("NewService");
    }
 
    if ($action == 'edit') {
      $this->tpl['title'] = $langs->trans('Modify').' '.$langs->trans('Service').' : '.$this->object->ref;
    }
 
    if ($action == 'create' || $action == 'edit') {
      // Status
      $statutarray = array('1' => $langs->trans("OnSell"), '0' => $langs->trans("NotOnSell"));
      $this->tpl['status'] = $form->selectarray('statut', $statutarray, $this->object->status);
 
      $statutarray = array('1' => $langs->trans("ProductStatusOnBuy"), '0' => $langs->trans("ProductStatusNotOnBuy"));
      $this->tpl['status_buy'] = $form->selectarray('statut_buy', $statutarray, $this->object->status_buy);
 
      $this->tpl['description'] = $this->description;
      $this->tpl['note'] = $this->note;
 
      // Duration unit
      // TODO creer fonction
      $duration_unit = '<input name="duration_unit" type="radio" value="h"'.($this->object->duration_unit == 'h' ? ' checked' : '').'>'.$langs->trans("Hour");
      $duration_unit .= '&nbsp; ';
      $duration_unit .= '<input name="duration_unit" type="radio" value="d"'.($this->object->duration_unit == 'd' ? ' checked' : '').'>'.$langs->trans("Day");
      $duration_unit .= '&nbsp; ';
      $duration_unit .= '<input name="duration_unit" type="radio" value="w"'.($this->object->duration_unit == 'w' ? ' checked' : '').'>'.$langs->trans("Week");
      $duration_unit .= '&nbsp; ';
      $duration_unit .= '<input name="duration_unit" type="radio" value="m"'.($this->object->duration_unit == 'm' ? ' checked' : '').'>'.$langs->trans("Month");
      $duration_unit .= '&nbsp; ';
      $duration_unit .= '<input name="duration_unit" type="radio" value="y"'.($this->object->duration_unit == 'y' ? ' checked' : '').'>'.$langs->trans("Year");
      $this->tpl['duration_unit'] = $duration_unit;
    }
 
    if ($action == 'view') {
      // Photo
      $this->tpl['nblines'] = 4;
      if ($this->object->is_photo_available($conf->service->multidir_output[$this->object->entity])) {
        $this->tpl['photos'] = $this->object->show_photos('product', $conf->service->multidir_output[$this->object->entity], 1, 1, 0, 0, 0, 80);
      }
 
      // Duration
      $dur = array();
      if ($this->object->duration_value > 1) {
        $dur = array("h"=>$langs->trans("Hours"), "d"=>$langs->trans("Days"), "w"=>$langs->trans("Weeks"), "m"=>$langs->trans("Months"), "y"=>$langs->trans("Years"));
      } elseif ($this->object->duration_value > 0) {
        $dur = array("h"=>$langs->trans("Hour"), "d"=>$langs->trans("Day"), "w"=>$langs->trans("Week"), "m"=>$langs->trans("Month"), "y"=>$langs->trans("Year"));
      }
      $this->tpl['duration_unit'] = $langs->trans($dur[$this->object->duration_unit]);
 
      $this->tpl['fiche_end'] = dol_get_fiche_end();
    }
 
    if ($action == 'list') {
      $this->LoadListDatas($limit, $offset, $sortfield, $sortorder);
    }
  }
 
 
  private function getFieldListCanvas()
  {
    global $conf, $langs;
 
    $this->field_list = array();
 
    $sql = "SELECT rowid, name, alias, title, align, sort, search, visible, enabled, rang";
    $sql .= " FROM ".MAIN_DB_PREFIX."c_field_list";
    $sql .= " WHERE element = '".$this->db->escape($this->fieldListName)."'";
    $sql .= " AND entity = ".$conf->entity;
    $sql .= " ORDER BY rang ASC";
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
 
      $i = 0;
      while ($i < $num) {
        $fieldlist = array();
 
        $obj = $this->db->fetch_object($resql);
 
        $fieldlist["id"] = $obj->rowid;
        $fieldlist["name"] = $obj->name;
        $fieldlist["alias"]   = $obj->alias;
        $fieldlist["title"]   = $langs->trans($obj->title);
        $fieldlist["align"]   = $obj->align;
        $fieldlist["sort"] = $obj->sort;
        $fieldlist["search"]  = $obj->search;
        $fieldlist["visible"] = $obj->visible;
        $fieldlist["enabled"] = verifCond($obj->enabled);
        $fieldlist["order"]   = $obj->rang;
 
        array_push($this->field_list, $fieldlist);
 
        $i++;
      }
      $this->db->free($resql);
    } else {
      dol_print_error($this->db, $sql);
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function LoadListDatas($limit, $offset, $sortfield, $sortorder)
  {
    // phpcs:enable
    global $conf;
    global $search_categ, $sall, $sref, $search_barcode, $snom, $catid;
 
    $this->getFieldListCanvas();
 
    $sql = 'SELECT DISTINCT p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type,';
    $sql .= ' p.fk_product_type, p.tms as datem,';
    $sql .= ' p.duration, p.tosell as statut, p.seuil_stock_alerte';
    $sql .= ' FROM '.MAIN_DB_PREFIX.'product as p';
    // We'll need this table joined to the select in order to filter by categ
    if ($search_categ) {
      $sql .= ", ".MAIN_DB_PREFIX."categorie_product as cp";
    }
    $fourn_id = 0;
    if (GETPOST("fourn_id", 'int') > 0) {
      $fourn_id = GETPOST("fourn_id", 'int');
      $sql .= ", ".MAIN_DB_PREFIX."product_fournisseur_price as pfp";
    }
    $sql .= " WHERE p.entity IN (".getEntity('product').")";
    if ($search_categ) {
      $sql .= " AND p.rowid = cp.fk_product"; // Join for the needed table to filter by categ
    }
    if ($sall) {
      $sql .= " AND (p.ref LIKE '%".$this->db->escape($sall)."%' OR p.label LIKE '%".$this->db->escape($sall)."%' OR p.description LIKE '%".$this->db->escape($sall)."%' OR p.note LIKE '%".$this->db->escape($sall)."%')";
    }
    if ($sref) {
      $sql .= " AND p.ref LIKE '%".$this->db->escape($sref)."%'";
    }
    if ($search_barcode) {
      $sql .= " AND p.barcode LIKE '%".$this->db->escape($search_barcode)."%'";
    }
    if ($snom) {
      $sql .= " AND p.label LIKE '%".$this->db->escape($snom)."%'";
    }
    if (GETPOSTISSET("tosell")) {
      $sql .= " AND p.tosell = ".((int) GETPOST("tosell", 'int'));
    }
    if (GETPOSTISSET("canvas")) {
      $sql .= " AND p.canvas = '".$this->db->escape(GETPOST("canvas"))."'";
    }
    if ($catid) {
      $sql .= " AND cp.fk_categorie = ".((int) $catid);
    }
    if ($fourn_id > 0) {
      $sql .= " AND p.rowid = pfp.fk_product AND pfp.fk_soc = ".((int) $fourn_id);
    }
    // Insert categ filter
    if ($search_categ) {
      $sql .= " AND cp.fk_categorie = ".((int) $search_categ);
    }
    $sql .= $this->db->order($sortfield, $sortorder);
    $sql .= $this->db->plimit($limit + 1, $offset);
 
    $this->list_datas = array();
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
 
      $i = 0;
      while ($i < min($num, $limit)) {
        $datas = array();
        $obj = $this->db->fetch_object($resql);
 
        $datas["id"]        = $obj->rowid;
        $datas["ref"]       = $obj->ref;
        $datas["label"]     = $obj->label;
        $datas["barcode"]   = $obj->barcode;
        $datas["statut"]    = $obj->statut;
 
        array_push($this->list_datas, $datas);
 
        $i++;
      }
      $this->db->free($resql);
    } else {
      print $sql;
    }
  }
}