commonobjectline.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2006-2008 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2012      Cedric Salvador      <csalvador@gpcsolutions.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/>.
 */
 
abstract class CommonObjectLine extends CommonObject
{
  public $id;
 
  public $rowid;
 
  public $picto = 'line';
 
  public $fk_unit;
 
  public $date_debut_prevue;
  public $date_debut_reel;
  public $date_fin_prevue;
  public $date_fin_reel;
 
  public $weight;
  public $weight_units;
  public $width;
  public $width_units;
  public $height;
  public $height_units;
  public $length;
  public $length_units;
  public $surface;
  public $surface_units;
  public $volume;
  public $volume_units;
 
  public $multilangs;
 
  public $product_type;   // type in line
  public $fk_product;     // product id in line (when line is linked to a product)
 
  public $desc;
 
  public $description;
 
  public $product;      // To store full product object after a fetch_product() on a line
  public $product_ref;    // ref in product table
  public $product_label;    // label in product table
  public $product_barcode;  // barcode in product table
  public $product_desc;   // desc in product table
  public $fk_product_type;  // type in product table
 
  public $qty;
  public $duree;
  public $remise_percent;
  public $info_bits;
  public $special_code;
  public $subprice;
  public $tva_tx;
 
 
 
  public function __construct($db)
  {
    $this->db = $db;
  }
 
  public function getLabelOfUnit($type = 'long')
  {
    global $langs;
 
    if (empty($this->fk_unit)) {
      return '';
    }
 
    $langs->load('products');
 
    $label_type = 'label';
 
    $label_type = 'label';
    if ($type == 'short') {
      $label_type = 'short_label';
    } elseif ($type == 'code') {
      $label_type = 'code';
    }
 
    $sql = "SELECT ".$label_type.", code from ".$this->db->prefix()."c_units where rowid = ".((int) $this->fk_unit);
 
    $resql = $this->db->query($sql);
    if ($resql && $this->db->num_rows($resql) > 0) {
      $res = $this->db->fetch_array($resql);
      if ($label_type == 'code') {
        $label = 'unit'.$res['code'];
      } else {
        $label = $res[$label_type];
      }
      $this->db->free($resql);
      return $label;
    } else {
      $this->error = $this->db->lasterror();
      dol_syslog(get_class($this)."::getLabelOfUnit Error ".$this->error, LOG_ERR);
      return -1;
    }
  }
 
  public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, array $filter = array(), $filtermode = 'AND')
  {
    return 0;
  }
}