* Copyright (C) 2012 Cedric Salvador * * 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 . */ /** * \file htdocs/core/class/commonobjectline.class.php * \ingroup core * \brief File of the superclass of classes of lines of business objects (invoice, contract, proposal, orders, etc. ...) */ /** * Parent class for class inheritance lines of business objects * This class is useless for the moment so no inherit are done on it * * TODO For the moment we use the extends on CommonObject until PHP min is 5.4 so we can use Traits. */ abstract class CommonObjectLine extends CommonObject { /** * Id of the line * @var int */ public $id; /** * Id of the line * @var int * @deprecated Try to use id property as possible (even if field into database is still rowid) * @see $id */ public $rowid; /** * @var string String with name of icon for myobject. Must be the part after the 'object_' into object_myobject.png */ public $picto = 'line'; /** * Product/service unit code ('km', 'm', 'p', ...) * @var string */ public $fk_unit; public $date_debut_prevue; public $date_debut_reel; public $date_fin_prevue; public $date_fin_reel; /** * Constructor * * @param DoliDB $db Database handler */ public function __construct($db) { $this->db = $db; } /** * Returns the label, short_label or code found in units dictionary from ->fk_unit. * A langs->trans() must be called on result to get translated value. * * @param string $type Label type ('long', 'short' or 'code'). This can be a translation key. * @return string|int <0 if KO, label if OK (Example: 'long', 'short' or 'unitCODE') */ 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; } } /** * Empty function to prevent errors on call of this function must be overload if usefull * * @param string $sortorder Sort Order * @param string $sortfield Sort field * @param int $limit offset limit * @param int $offset offset limit * @param array $filter filter array * @param string $filtermode filter mode (AND or OR) * @return int <0 if KO, >0 if OK */ public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, array $filter = array(), $filtermode = 'AND') { return 0; } }