42require_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
43require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/product/class/productbatch.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/productlot.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/entrepot.class.php';
57 const SELL_OR_EAT_BY_MANDATORY_ID_SELL_BY = 1;
58 const SELL_OR_EAT_BY_MANDATORY_ID_EAT_BY = 2;
59 const SELL_OR_EAT_BY_MANDATORY_ID_SELL_AND_EAT = 3;
65 public $TRIGGER_PREFIX =
'PRODUCT';
70 public $element =
'product';
75 public $table_element =
'product';
80 public $fk_element =
'fk_product';
85 protected $childtables = array(
86 'supplier_proposaldet' => array(
'name' =>
'SupplierProposal',
'parent' =>
'supplier_proposal',
'parentkey' =>
'fk_supplier_proposal'),
87 'propaldet' => array(
'name' =>
'Proposal',
'parent' =>
'propal',
'parentkey' =>
'fk_propal'),
88 'commandedet' => array(
'name' =>
'Order',
'parent' =>
'commande',
'parentkey' =>
'fk_commande'),
89 'facturedet' => array(
'name' =>
'Invoice',
'parent' =>
'facture',
'parentkey' =>
'fk_facture'),
90 'contratdet' => array(
'name' =>
'Contract',
'parent' =>
'contrat',
'parentkey' =>
'fk_contrat'),
91 'facture_fourn_det' => array(
'name' =>
'SupplierInvoice',
'parent' =>
'facture_fourn',
'parentkey' =>
'fk_facture_fourn'),
92 'commande_fournisseurdet' => array(
'name' =>
'SupplierOrder',
'parent' =>
'commande_fournisseur',
'parentkey' =>
'fk_commande'),
93 'mrp_production' => array(
'name' =>
'Mo',
'parent' =>
'mrp_mo',
'parentkey' =>
'fk_mo',
'enabled' =>
'isModEnabled("mrp")'),
94 'bom_bom' => array(
'name' =>
'BOM',
'enabled' =>
'isModEnabled("bom")'),
95 'bom_bomline' => array(
'name' =>
'BOMLine',
'parent' =>
'bom_bom',
'parentkey' =>
'fk_bom',
'enabled' =>
'isModEnabled("bom")'),
103 public $picto =
'product';
114 public $regeximgext =
'\.gif|\.jpg|\.jpeg|\.png|\.bmp|\.webp|\.xpm|\.xbm|\.avif';
168 public $price_formated;
180 public $price_ttc_formated;
194 public $price_min_ttc;
200 public $price_base_type;
210 public $multiprices = array();
214 public $multiprices_ttc = array();
218 public $multiprices_base_type = array();
222 public $multiprices_default_vat_code = array();
226 public $multiprices_min = array();
230 public $multiprices_min_ttc = array();
234 public $multiprices_tva_tx = array();
238 public $multiprices_recuperableonly = array();
244 public $price_by_qty;
248 public $prices_by_qty = array();
252 public $prices_by_qty_id = array();
256 public $prices_by_qty_list = array();
266 public $multilangs = array();
271 public $default_vat_code;
286 public $remise_percent;
291 public $localtax1_tx;
295 public $localtax2_tx;
299 public $localtax1_type;
303 public $localtax2_type;
310 public $desc_supplier;
314 public $vatrate_supplier;
318 public $default_vat_code_supplier;
323 public $fourn_multicurrency_price;
328 public $fourn_multicurrency_unitprice;
332 public $fourn_multicurrency_tx;
336 public $fourn_multicurrency_id;
340 public $fourn_multicurrency_code;
362 public $qc_frequency;
369 public $stock_reel = 0;
376 public $stock_theorique;
397 public $seuil_stock_alerte = 0;
402 public $desiredstock = 0;
407 public $duration_value;
411 public $duration_unit;
420 public $fk_default_workstation;
442 public $status_buy = 0;
464 public $fk_default_bom;
471 public $product_fourn_price_id;
493 public $status_batch = 0;
500 public $sell_or_eat_by_mandatory = 0;
507 public $batch_mask =
'';
532 public $weight_units;
540 public $length_units;
556 public $height_units;
564 public $surface_units;
572 public $volume_units;
581 public $net_measure_units;
586 public $accountancy_code_sell;
590 public $accountancy_code_sell_intra;
594 public $accountancy_code_sell_export;
598 public $accountancy_code_buy;
602 public $accountancy_code_buy_intra;
606 public $accountancy_code_buy_export;
616 public $barcode_type;
621 public $barcode_type_code;
626 public $stats_propale = array();
631 public $stats_commande = array();
636 public $stats_contrat = array();
641 public $stats_facture = array();
646 public $stats_proposal_supplier = array();
651 public $stats_commande_fournisseur = array();
656 public $stats_expedition = array();
661 public $stats_reception = array();
666 public $stats_mo = array();
671 public $stats_bom = array();
676 public $stats_mrptoconsume = array();
681 public $stats_mrptoproduce = array();
686 public $stats_facturerec = array();
691 public $stats_facture_fournisseur = array();
696 public $stats_facturefournrec = array();
711 public $product_fourn_id;
717 public $product_id_already_linked;
728 public $stock_warehouse = array();
733 public $fk_default_warehouse;
738 public $fk_price_expression;
756 public $fourn_price_base_type;
773 public $ref_supplier;
787 public $price_autogen = 0;
794 public $sousprods = array();
807 public $is_object_used;
818 public $is_sousproduit_qty;
830 public $is_sousproduit_incdec;
835 public $mandatory_period;
842 public $stockable_product = 1;
872 public $fields = array(
873 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'index' => 1,
'position' => 1,
'comment' =>
'Id'),
874 'ref' => array(
'type' =>
'varchar(128)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'showoncombobox' => 1,
'index' => 1,
'position' => 10,
'searchall' => 1,
'comment' =>
'Reference of object'),
875 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'enabled' => 1,
'visible' => 0,
'default' =>
'1',
'notnull' => 1,
'index' => 1,
'position' => 5),
876 'label' => array(
'type' =>
'varchar(255)',
'label' =>
'Label',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'showoncombobox' => 2,
'position' => 15,
'csslist' =>
'tdoverflowmax250'),
877 'barcode' => array(
'type' =>
'varchar(255)',
'label' =>
'Barcode',
'enabled' =>
'isModEnabled("barcode")',
'position' => 20,
'visible' => -1,
'showoncombobox' => 3,
'cssview' =>
'tdwordbreak',
'csslist' =>
'tdoverflowmax125'),
878 'fk_barcode_type' => array(
'type' =>
'integer',
'label' =>
'BarcodeType',
'enabled' => 1,
'position' => 21,
'notnull' => 0,
'visible' => -1,),
879 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 61),
880 'note' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 62),
881 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 500),
882 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 501),
884 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 510,
'foreignkey' =>
'llx_user.rowid'),
885 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 511),
887 'localtax1_tx' => array(
'type' =>
'double(6,3)',
'label' =>
'Localtax1tx',
'enabled' => 1,
'position' => 150,
'notnull' => 0,
'visible' => -1,),
888 'localtax1_type' => array(
'type' =>
'varchar(10)',
'label' =>
'Localtax1type',
'enabled' => 1,
'position' => 155,
'notnull' => 1,
'visible' => -1,),
889 'localtax2_tx' => array(
'type' =>
'double(6,3)',
'label' =>
'Localtax2tx',
'enabled' => 1,
'position' => 160,
'notnull' => 0,
'visible' => -1,),
890 'localtax2_type' => array(
'type' =>
'varchar(10)',
'label' =>
'Localtax2type',
'enabled' => 1,
'position' => 165,
'notnull' => 1,
'visible' => -1,),
891 'last_main_doc' => array(
'type' =>
'varchar(255)',
'label' =>
'LastMainDoc',
'enabled' => 1,
'visible' => -1,
'position' => 170),
892 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'index' => 0,
'position' => 1000),
895 'mandatory_period' => array(
'type' =>
'integer',
'label' =>
'mandatoryperiod',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'default' =>
'0',
'index' => 1,
'position' => 1000),
896 'stockable_product' => array(
'type' =>
'integer',
'label' =>
'stockable_product',
'enabled' => 1,
'visible' => 1,
'default' =>
'1',
'notnull' => 1,
'index' => 1,
'position' => 502),
912 const ENABLED_STOCK = 1;
923 $this->ismultientitymanaged = 1;
924 $this->isextrafieldmanaged = 1;
937 $this->
ref = trim($this->
ref);
965 public function create($user, $notrigger = 0)
967 global
$conf, $langs;
973 $this->
ref = trim($this->
ref);
977 $this->label = trim($this->label);
978 $this->price_ttc = (float)
price2num($this->price_ttc);
980 $this->price_min_ttc = (float)
price2num($this->price_min_ttc);
981 $this->price_min = (float)
price2num($this->price_min);
982 $this->price_label = trim($this->price_label);
983 if (empty($this->tva_tx)) {
986 if (empty($this->tva_npr)) {
990 if (empty($this->localtax1_tx)) {
991 $this->localtax1_tx = 0;
993 if (empty($this->localtax2_tx)) {
994 $this->localtax2_tx = 0;
996 if (empty($this->localtax1_type)) {
997 $this->localtax1_type =
'0';
999 if (empty($this->localtax2_type)) {
1000 $this->localtax2_type =
'0';
1003 if (empty($this->price_base_type) &&
getDolGlobalString(
'PRODUCT_PRICE_BASE_TYPE')) {
1006 if (empty($this->
price)) {
1009 if (empty($this->price_min)) {
1010 $this->price_min = 0;
1013 if (empty($this->price_by_qty)) {
1014 $this->price_by_qty = 0;
1017 if (empty($this->
status)) {
1020 if (empty($this->status_buy)) {
1021 $this->status_buy = 0;
1023 if (empty($this->stockable_product)) {
1024 $this->stockable_product = 0;
1033 if ($this->price_base_type ==
'TTC' && $this->price_ttc > 0) {
1034 $price_ttc =
price2num($this->price_ttc,
'MU');
1035 $price_ht =
price2num($this->price_ttc / (1 + ($this->tva_tx / 100)),
'MU');
1039 if ($this->price_base_type !=
'TTC' && $this->
price > 0) {
1041 $price_ttc =
price2num($this->
price * (1 + ($this->tva_tx / 100)),
'MU');
1045 if (($this->price_min_ttc > 0) && ($this->price_base_type ==
'TTC')) {
1046 $price_min_ttc =
price2num($this->price_min_ttc,
'MU');
1047 $price_min_ht =
price2num($this->price_min_ttc / (1 + ($this->tva_tx / 100)),
'MU');
1051 if (($this->price_min > 0) && ($this->price_base_type !=
'TTC')) {
1052 $price_min_ht =
price2num($this->price_min,
'MU');
1053 $price_min_ttc =
price2num($this->price_min * (1 + ($this->tva_tx / 100)),
'MU');
1056 $this->accountancy_code_buy = trim((
string) $this->accountancy_code_buy);
1057 $this->accountancy_code_buy_intra = trim((
string) $this->accountancy_code_buy_intra);
1058 $this->accountancy_code_buy_export = trim((
string) $this->accountancy_code_buy_export);
1059 $this->accountancy_code_sell = trim((
string) $this->accountancy_code_sell);
1060 $this->accountancy_code_sell_intra = trim((
string) $this->accountancy_code_sell_intra);
1061 $this->accountancy_code_sell_export = trim((
string) $this->accountancy_code_sell_export);
1067 require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
1068 $this->accountancy_code_buy =
clean_account($this->accountancy_code_buy);
1069 $this->accountancy_code_buy_intra =
clean_account($this->accountancy_code_buy_intra);
1070 $this->accountancy_code_buy_export =
clean_account($this->accountancy_code_buy_export);
1071 $this->accountancy_code_sell =
clean_account($this->accountancy_code_sell);
1072 $this->accountancy_code_sell_intra =
clean_account($this->accountancy_code_sell_intra);
1073 $this->accountancy_code_sell_export =
clean_account($this->accountancy_code_sell_export);
1077 $this->barcode = trim($this->barcode);
1078 $this->mandatory_period = empty($this->mandatory_period) ? 0 : $this->mandatory_period;
1080 if (empty($this->label)) {
1081 $langs->load(
'errors');
1082 $this->errors[] = $langs->trans(
'ErrorMandatoryParametersNotProvided');
1086 if (empty($this->
ref) || $this->
ref ==
'auto') {
1088 $module =
getDolGlobalString(
'PRODUCT_CODEPRODUCT_ADDON',
'mod_codeproduct_leopard');
1089 if ($module !=
'mod_codeproduct_leopard') {
1090 if (substr($module, 0, 16) ==
'mod_codeproduct_' && substr($module, -3) ==
'php') {
1091 $module = substr($module, 0,
dol_strlen($module) - 4);
1094 $modCodeProduct =
new $module();
1095 '@phan-var-force ModeleProductCode $modCodeProduct';
1096 if (!empty($modCodeProduct->code_auto)) {
1097 $this->
ref = $modCodeProduct->getNextValue($this, $this->
type);
1099 unset($modCodeProduct);
1102 if (empty($this->
ref)) {
1103 $this->error =
'ProductModuleNotSetupForAutoRef';
1108 dol_syslog(get_class($this).
"::create ref=".$this->
ref.
" price=".$this->price.
" price_ttc=".$this->price_ttc.
" tva_tx=".$this->tva_tx.
" price_base_type=".$this->price_base_type, LOG_DEBUG);
1112 if (empty($this->date_creation)) {
1113 $this->date_creation = $now;
1119 if ($this->barcode ==
'-1' || $this->barcode ==
'auto') {
1120 $this->barcode = $this->
get_barcode($this, $this->barcode_type_code);
1125 $result = $this->
verify();
1128 $sql =
"SELECT count(*) as nb";
1129 $sql .=
" FROM ".$this->db->prefix().
"product";
1130 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
1131 $sql .=
" AND ref = '".$this->db->escape($this->
ref).
"'";
1133 $result = $this->db->query($sql);
1135 $obj = $this->db->fetch_object($result);
1136 if ($obj->nb == 0) {
1138 $sql =
"INSERT INTO ".$this->db->prefix().
"product (";
1142 $sql .=
", ref_ext";
1143 $sql .=
", price_min";
1144 $sql .=
", price_min_ttc";
1146 $sql .=
", fk_user_author";
1147 $sql .=
", fk_product_type";
1149 $sql .=
", price_ttc";
1150 $sql .=
", price_base_type";
1151 $sql .=
", price_label";
1155 $sql .=
", accountancy_code_buy";
1156 $sql .=
", accountancy_code_buy_intra";
1157 $sql .=
", accountancy_code_buy_export";
1158 $sql .=
", accountancy_code_sell";
1159 $sql .=
", accountancy_code_sell_intra";
1160 $sql .=
", accountancy_code_sell_export";
1163 $sql .=
", finished";
1164 $sql .=
", tobatch";
1165 $sql .=
", sell_or_eat_by_mandatory";
1166 $sql .=
", batch_mask";
1167 $sql .=
", fk_unit";
1168 $sql .=
", mandatory_period";
1169 $sql .=
", stockable_product";
1170 if (!empty($this->default_vat_code)) {
1171 $sql .=
", default_vat_code";
1173 $sql .=
") VALUES (";
1174 $sql .=
"'".$this->db->idate($this->date_creation).
"'";
1175 $sql .=
", ".(!empty($this->entity) ? (int) $this->entity : (int)
$conf->entity);
1176 $sql .=
", '".$this->db->escape($this->
ref).
"'";
1177 $sql .=
", ".(!empty($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null");
1178 $sql .=
", ".price2num($price_min_ht);
1179 $sql .=
", ".price2num($price_min_ttc);
1180 $sql .=
", ".(!empty($this->label) ?
"'".$this->db->escape($this->label).
"'" :
"null");
1181 $sql .=
", ".((int) $user->id);
1182 $sql .=
", ".((int) $this->
type);
1183 $sql .=
", ".price2num($price_ht,
'MT');
1184 $sql .=
", ".price2num($price_ttc,
'MT');
1185 $sql .=
", '".$this->db->escape($this->price_base_type).
"'";
1186 $sql .=
", ".(!empty($this->price_label) ?
"'".$this->db->escape($this->price_label).
"'" :
"null");
1187 $sql .=
", ".((int) $this->
status);
1188 $sql .=
", ".((int) $this->status_buy);
1190 $sql .=
", '".$this->db->escape($this->accountancy_code_buy).
"'";
1191 $sql .=
", '".$this->db->escape($this->accountancy_code_buy_intra).
"'";
1192 $sql .=
", '".$this->db->escape($this->accountancy_code_buy_export).
"'";
1193 $sql .=
", '".$this->db->escape($this->accountancy_code_sell).
"'";
1194 $sql .=
", '".$this->db->escape($this->accountancy_code_sell_intra).
"'";
1195 $sql .=
", '".$this->db->escape($this->accountancy_code_sell_export).
"'";
1197 $sql .=
", '".$this->db->escape($this->canvas).
"'";
1198 $sql .=
", ".((!isset($this->finished) || $this->finished < 0 || $this->finished ==
'') ?
'NULL' : (int) $this->finished);
1199 $sql .=
", ".((empty($this->status_batch) || $this->status_batch < 0) ?
'0' : ((int) $this->status_batch));
1200 $sql .=
", ".((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : ((int) $this->sell_or_eat_by_mandatory));
1201 $sql .=
", '".$this->db->escape($this->batch_mask).
"'";
1202 $sql .=
", ".($this->fk_unit > 0 ? ((int) $this->fk_unit) :
'NULL');
1203 $sql .=
", '".$this->db->escape((
string) $this->mandatory_period).
"'";
1204 $sql .=
", ".((int) $this->stockable_product);
1205 if (!empty($this->default_vat_code)) {
1206 $sql .=
", '".$this->db->escape($this->default_vat_code).
"'";
1209 dol_syslog(get_class($this).
"::Create", LOG_DEBUG);
1211 $result = $this->db->query($sql);
1213 $id = $this->db->last_insert_id($this->db->prefix().
"product");
1217 $this->
price = $price_ht;
1218 $this->price_ttc = $price_ttc;
1219 $this->price_min = $price_min_ht;
1220 $this->price_min_ttc = $price_min_ttc;
1224 if ($this->
update($id, $user, 1,
'add') <= 0) {
1229 $this->error = $this->db->lasterror();
1234 $this->db->query(
"DELETE FROM " . $this->db->prefix() .
"product_perentity WHERE fk_product = " .((int) $this->id) .
" AND entity = " . ((
int)
$conf->entity));
1236 $sql =
"INSERT INTO " . $this->db->prefix() .
"product_perentity (";
1237 $sql .=
" fk_product";
1239 $sql .=
", accountancy_code_buy";
1240 $sql .=
", accountancy_code_buy_intra";
1241 $sql .=
", accountancy_code_buy_export";
1242 $sql .=
", accountancy_code_sell";
1243 $sql .=
", accountancy_code_sell_intra";
1244 $sql .=
", accountancy_code_sell_export";
1245 $sql .=
") VALUES (";
1246 $sql .= ((int) $this->
id);
1247 $sql .=
", " . ((int)
$conf->entity);
1248 $sql .=
", '" . $this->db->escape($this->accountancy_code_buy) .
"'";
1249 $sql .=
", '" . $this->db->escape($this->accountancy_code_buy_intra) .
"'";
1250 $sql .=
", '" . $this->db->escape($this->accountancy_code_buy_export) .
"'";
1251 $sql .=
", '" . $this->db->escape($this->accountancy_code_sell) .
"'";
1252 $sql .=
", '" . $this->db->escape($this->accountancy_code_sell_intra) .
"'";
1253 $sql .=
", '" . $this->db->escape($this->accountancy_code_sell_export) .
"'";
1255 $result = $this->db->query($sql);
1258 $this->error =
'ErrorFailedToInsertAccountancyForEntity';
1263 $this->error =
'ErrorFailedToGetInsertedId';
1267 $this->error = $this->db->lasterror();
1271 $langs->load(
"products");
1273 $this->error =
"ErrorProductAlreadyExists";
1274 dol_syslog(get_class($this).
"::Create fails, ref ".$this->
ref.
" already exists");
1278 $this->error = $this->db->lasterror();
1281 if (!$error && !$notrigger) {
1283 $result = $this->call_trigger(
'PRODUCT_CREATE', $user);
1291 $this->db->commit();
1294 $this->db->rollback();
1298 $this->db->rollback();
1299 dol_syslog(get_class($this).
"::Create fails verify ".implode(
',', $this->errors), LOG_WARNING);
1315 $this->errors = array();
1318 $this->
ref = trim($this->
ref);
1321 $this->errors[] =
'ErrorBadRef';
1325 $arrayofnonnegativevalue = array(
'weight' =>
'Weight',
'width' =>
'Width',
'height' =>
'Height',
'length' =>
'Length',
'surface' =>
'Surface',
'volume' =>
'Volume');
1326 foreach ($arrayofnonnegativevalue as $key => $value) {
1327 if (property_exists($this, $key) && !empty($this->$key) && ($this->$key < 0)) {
1328 $langs->loadLangs(array(
"main",
"other"));
1329 $this->error = $langs->trans(
"FieldCannotBeNegative", $langs->transnoentitiesnoconv($value));
1330 $this->errors[] = $this->error;
1335 $rescode = $this->check_barcode($this->barcode, $this->barcode_type_code);
1337 if ($rescode == -1) {
1338 $this->errors[] =
'ErrorBadBarCodeSyntax';
1339 } elseif ($rescode == -2) {
1340 $this->errors[] =
'ErrorBarCodeRequired';
1341 } elseif ($rescode == -3) {
1343 $this->errors[] =
'ErrorBarCodeAlreadyUsed';
1363 public function check_barcode($valuetotest, $typefortest)
1371 $dirsociete = array_merge(array(
'/core/modules/barcode/'),
$conf->modules_parts[
'barcode']);
1372 foreach ($dirsociete as $dirroot) {
1379 $mod =
new $module();
1380 '@phan-var-force ModeleNumRefBarCode $mod';
1383 dol_syslog(get_class($this).
"::check_barcode value=".$valuetotest.
" type=".$typefortest.
" module=".$module);
1384 $result = $mod->verif($this->db, $valuetotest, $this, 0, $typefortest);
1402 public function update($id, $user, $notrigger = 0, $action =
'update', $updatetype =
false)
1404 global $langs,
$conf, $hookmanager;
1409 if (!$this->label) {
1410 $this->label =
'MISSING LABEL';
1415 $this->
ref = trim($this->
ref);
1419 $this->label = trim($this->label);
1421 $this->note_private = (isset($this->note_private) ? trim($this->note_private) :
null);
1422 $this->note_public = (isset($this->note_public) ? trim($this->note_public) :
null);
1423 $this->net_measure =
price2num($this->net_measure);
1424 $this->net_measure_units = (!is_numeric($this->net_measure_units) ? null : (int) $this->net_measure_units);
1425 $this->weight =
price2num($this->weight);
1426 $this->weight_units = (!is_numeric($this->weight_units) ? null : (int) $this->weight_units);
1427 $this->length =
price2num($this->length);
1428 $this->length_units = (!is_numeric($this->length_units) ? null : (int) $this->length_units);
1430 $this->width_units = (!is_numeric($this->width_units) ? null : (int) $this->width_units);
1431 $this->height =
price2num($this->height);
1432 $this->height_units = (!is_numeric($this->height_units) ? null : (int) $this->height_units);
1433 $this->surface =
price2num($this->surface);
1434 $this->surface_units = (!is_numeric($this->surface_units) ? null : (int) $this->surface_units);
1435 $this->volume =
price2num($this->volume);
1436 $this->volume_units = (!is_numeric($this->volume_units) ? null : (int) $this->volume_units);
1439 if (is_numeric($this->length_units)) {
1440 $this->width_units = $this->length_units;
1442 if (is_numeric($this->length_units)) {
1443 $this->height_units = $this->length_units;
1447 if (empty($this->surface) && !empty($this->length) && !empty($this->width) && $this->length_units == $this->width_units) {
1448 $this->surface = (float) $this->length * (
float) $this->width;
1451 if (empty($this->volume) && !empty($this->surface) && !empty($this->height) && $this->length_units == $this->height_units) {
1452 $this->volume = $this->surface * (float) $this->height;
1456 if (empty($this->tva_tx)) {
1459 if (empty($this->tva_npr)) {
1462 if (empty($this->localtax1_tx)) {
1463 $this->localtax1_tx = 0;
1465 if (empty($this->localtax2_tx)) {
1466 $this->localtax2_tx = 0;
1468 if (empty($this->localtax1_type)) {
1469 $this->localtax1_type =
'0';
1471 if (empty($this->localtax2_type)) {
1472 $this->localtax2_type =
'0';
1474 if (empty($this->
status)) {
1477 if (empty($this->status_buy)) {
1478 $this->status_buy = 0;
1481 if (empty($this->country_id)) {
1482 $this->country_id = 0;
1484 if (empty($this->country_id) && !empty($this->country_code)) {
1485 $country_id =
getCountry($this->country_code,
'3');
1486 $this->country_id = is_int($country_id) ? $country_id : 0;
1489 if (empty($this->state_id)) {
1490 $this->state_id = 0;
1493 if (empty($this->stockable_product)) {
1494 $this->stockable_product = 0;
1498 if ($this->barcode ==
'-1' || $this->barcode ==
'auto') {
1499 $this->barcode = $this->
get_barcode($this, $this->barcode_type_code);
1503 $this->barcode = (empty($this->barcode) ?
'' : trim($this->barcode));
1505 $this->accountancy_code_buy = trim($this->accountancy_code_buy);
1506 $this->accountancy_code_buy_intra = (!empty($this->accountancy_code_buy_intra) ? trim($this->accountancy_code_buy_intra) :
'');
1507 $this->accountancy_code_buy_export = trim($this->accountancy_code_buy_export);
1508 $this->accountancy_code_sell = trim($this->accountancy_code_sell);
1509 $this->accountancy_code_sell_intra = trim($this->accountancy_code_sell_intra);
1510 $this->accountancy_code_sell_export = trim($this->accountancy_code_sell_export);
1516 require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
1517 $this->accountancy_code_buy =
clean_account($this->accountancy_code_buy);
1518 $this->accountancy_code_buy_intra =
clean_account($this->accountancy_code_buy_intra);
1519 $this->accountancy_code_buy_export =
clean_account($this->accountancy_code_buy_export);
1520 $this->accountancy_code_sell =
clean_account($this->accountancy_code_sell);
1521 $this->accountancy_code_sell_intra =
clean_account($this->accountancy_code_sell_intra);
1522 $this->accountancy_code_sell_export =
clean_account($this->accountancy_code_sell_export);
1529 if ($action !=
'add') {
1530 $result = $this->
verify();
1542 if (is_null($this->oldcopy) || (is_object($this->oldcopy) && empty($this->oldcopy->id)) || !($this->oldcopy instanceof
Product)) {
1547 if ($this->
hasbatch() && !$this->oldcopy->hasbatch()) {
1549 $valueforundefinedlot =
'000000';
1554 dol_syslog(
"Flag batch of product id=".$this->
id.
" is set to ON, so we will create missing records into product_batch");
1557 foreach ($this->stock_warehouse as $idW => $ObjW) {
1559 foreach ($ObjW->detail_batch as $detail) {
1560 if ($detail->batch == $valueforundefinedlot || $detail->batch ==
'Undefined') {
1562 $sqlclean =
"DELETE FROM ".$this->db->prefix().
"product_batch WHERE batch in('Undefined', '".$this->db->escape($valueforundefinedlot).
"') AND fk_product_stock = ".((int) $ObjW->id);
1563 $result = $this->db->query($sqlclean);
1571 $qty_batch += $detail->qty;
1575 if ($ObjW->real != $qty_batch) {
1577 $ObjBatch->batch = $valueforundefinedlot;
1578 $ObjBatch->qty = ($ObjW->real - $qty_batch);
1579 $ObjBatch->fk_product_stock = (int) $ObjW->id;
1581 if ($ObjBatch->create($user, 1) < 0) {
1583 $this->errors = $ObjBatch->errors;
1588 if ($ObjLot->fetch(0, $this->id, $valueforundefinedlot) == 0) {
1589 $ObjLot->fk_product = $this->id;
1590 $ObjLot->entity = (int) $this->entity;
1591 $ObjLot->fk_user_creat = $user->id;
1592 $ObjLot->batch = $valueforundefinedlot;
1593 if ($ObjLot->create($user, 1) < 0) {
1595 $this->errors = $ObjLot->errors;
1603 $sql =
"UPDATE ".$this->db->prefix().
"product";
1604 $sql .=
" SET label = '".$this->db->escape($this->label).
"'";
1607 $sql .=
", fk_product_type = ".((int) $this->
type);
1610 $sql .=
", ref = '".$this->db->escape($this->
ref).
"'";
1611 $sql .=
", ref_ext = ".(!empty($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null");
1612 $sql .=
", default_vat_code = ".($this->default_vat_code ?
"'".$this->db->escape($this->default_vat_code).
"'" :
"null");
1613 $sql .=
", tva_tx = ".((float) $this->tva_tx);
1614 $sql .=
", recuperableonly = ".((int) $this->tva_npr);
1615 $sql .=
", localtax1_tx = ".((float) $this->localtax1_tx);
1616 $sql .=
", localtax2_tx = ".((float) $this->localtax2_tx);
1617 $sql .=
", localtax1_type = ".($this->localtax1_type !=
'' ?
"'".$this->db->escape($this->localtax1_type).
"'" :
"'0'");
1618 $sql .=
", localtax2_type = ".($this->localtax2_type !=
'' ?
"'".$this->db->escape($this->localtax2_type).
"'" :
"'0'");
1620 $sql .=
", barcode = ".(empty($this->barcode) ?
"null" :
"'".$this->db->escape($this->barcode).
"'");
1621 $sql .=
", fk_barcode_type = ".(empty($this->barcode_type) ?
"null" : ((int) $this->barcode_type));
1623 $sql .=
", tosell = ".(int) $this->
status;
1624 $sql .=
", tobuy = ".(int) $this->status_buy;
1625 $sql .=
", tobatch = ".((empty($this->status_batch) || $this->status_batch < 0) ?
'0' : (int) $this->status_batch);
1626 $sql .=
", sell_or_eat_by_mandatory = ".((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : (int) $this->sell_or_eat_by_mandatory);
1627 $sql .=
", batch_mask = '".$this->db->escape($this->batch_mask).
"'";
1629 $sql .=
", finished = ".((!isset($this->finished) || $this->finished < 0 || $this->finished ===
'') ?
"null" : (int) $this->finished);
1630 $sql .=
", fk_default_bom = ".((!isset($this->fk_default_bom) || $this->fk_default_bom < 0 || $this->fk_default_bom ==
'') ?
"null" : (int) $this->fk_default_bom);
1631 $sql .=
", net_measure = ".($this->net_measure !=
'' ?
"'".$this->db->escape($this->net_measure).
"'" :
'null');
1632 $sql .=
", net_measure_units = ".((string) $this->net_measure_units !=
'' ? ((
int) $this->net_measure_units) :
'null');
1633 $sql .=
", weight = ".($this->weight !=
'' ?
"'".$this->db->escape($this->weight).
"'" :
'null');
1634 $sql .=
", weight_units = ".((string) $this->weight_units !=
'' ? ((
int) $this->weight_units) :
'null');
1635 $sql .=
", length = ".($this->length !=
'' ?
"'".$this->db->escape($this->length).
"'" :
'null');
1636 $sql .=
", length_units = ".((string) $this->length_units !=
'' ? ((
int) $this->length_units) :
'null');
1637 $sql .=
", width= ".($this->width !=
'' ?
"'".$this->db->escape($this->width).
"'" :
'null');
1638 $sql .=
", width_units = ".((string) $this->width_units !=
'' ? ((
int) $this->width_units) :
'null');
1639 $sql .=
", height = ".($this->height !=
'' ?
"'".$this->db->escape($this->height).
"'" :
'null');
1640 $sql .=
", height_units = ".((string) $this->height_units !=
'' ? ((
int) $this->height_units) :
'null');
1641 $sql .=
", surface = ".($this->surface !=
'' ?
"'".$this->db->escape($this->surface).
"'" :
'null');
1642 $sql .=
", surface_units = ".((string) $this->surface_units !=
'' ? ((
int) $this->surface_units) :
'null');
1643 $sql .=
", volume = ".($this->volume !=
'' ?
"'".$this->db->escape($this->volume).
"'" :
'null');
1644 $sql .=
", volume_units = ".((string) $this->volume_units !=
'' ? ((
int) $this->volume_units) :
'null');
1645 $sql .=
", fk_default_warehouse = ".($this->fk_default_warehouse > 0 ? ((int) $this->fk_default_warehouse) :
'null');
1646 $sql .=
", fk_default_workstation = ".($this->fk_default_workstation > 0 ? ((int) $this->fk_default_workstation) :
'null');
1647 $sql .=
", seuil_stock_alerte = ".((isset($this->seuil_stock_alerte) && is_numeric($this->seuil_stock_alerte)) ? (
float) $this->seuil_stock_alerte :
'null');
1648 $sql .=
", description = '".$this->db->escape($this->
description).
"'";
1649 $sql .=
", url = ".($this->url ?
"'".$this->db->escape($this->url).
"'" :
'null');
1650 $sql .=
", customcode = '".$this->db->escape($this->customcode).
"'";
1651 $sql .=
", fk_country = ".($this->country_id > 0 ? (int) $this->country_id :
'null');
1652 $sql .=
", fk_state = ".($this->state_id > 0 ? (int) $this->state_id :
'null');
1653 $sql .=
", lifetime = ".($this->lifetime > 0 ? (int) $this->lifetime :
'null');
1654 $sql .=
", qc_frequency = ".($this->qc_frequency > 0 ? (int) $this->qc_frequency :
'null');
1655 $sql .=
", note = ".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
'null');
1656 $sql .=
", note_public = ".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
'null');
1657 $sql .=
", duration = '".$this->db->escape($this->duration_value.$this->duration_unit).
"'";
1659 $sql .=
", accountancy_code_buy = '" . $this->db->escape($this->accountancy_code_buy) .
"'";
1660 $sql .=
", accountancy_code_buy_intra = '" . $this->db->escape($this->accountancy_code_buy_intra) .
"'";
1661 $sql .=
", accountancy_code_buy_export = '" . $this->db->escape($this->accountancy_code_buy_export) .
"'";
1662 $sql .=
", accountancy_code_sell= '" . $this->db->escape($this->accountancy_code_sell) .
"'";
1663 $sql .=
", accountancy_code_sell_intra= '" . $this->db->escape($this->accountancy_code_sell_intra) .
"'";
1664 $sql .=
", accountancy_code_sell_export= '" . $this->db->escape($this->accountancy_code_sell_export) .
"'";
1666 $sql .=
", desiredstock = ".((isset($this->desiredstock) && is_numeric($this->desiredstock)) ? (
float) $this->desiredstock :
"null");
1667 $sql .=
", cost_price = ".($this->cost_price !=
'' ? ((float) $this->cost_price) :
'null');
1668 $sql .=
", fk_unit= ".(!$this->fk_unit ?
'NULL' : (int) $this->fk_unit);
1669 $sql .=
", price_autogen = ".(!$this->price_autogen ? 0 : 1);
1670 $sql .=
", fk_price_expression = ".($this->fk_price_expression != 0 ? (int) $this->fk_price_expression :
'NULL');
1671 $sql .=
", fk_user_modif = ".($user->id > 0 ? (int) $user->id :
'NULL');
1672 $sql .=
", mandatory_period = ".((int) $this->mandatory_period);
1673 $sql .=
", stockable_product = ".(int) $this->stockable_product;
1675 $sql .=
", packaging = ".(float) $this->packaging;
1679 $sql .=
" WHERE rowid = ".((int) $id);
1681 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1683 $resql = $this->db->query($sql);
1690 $this->db->rollback();
1699 $this->db->query(
"DELETE FROM " . $this->db->prefix() .
"product_perentity WHERE fk_product = " . ((
int) $this->id) .
" AND entity = " . ((
int)
$conf->entity));
1701 $sql =
"INSERT INTO " . $this->db->prefix() .
"product_perentity (";
1702 $sql .=
" fk_product";
1704 $sql .=
", accountancy_code_buy";
1705 $sql .=
", accountancy_code_buy_intra";
1706 $sql .=
", accountancy_code_buy_export";
1707 $sql .=
", accountancy_code_sell";
1708 $sql .=
", accountancy_code_sell_intra";
1709 $sql .=
", accountancy_code_sell_export";
1710 $sql .=
") VALUES (";
1711 $sql .= ((int) $this->
id);
1712 $sql .=
", " . ((int)
$conf->entity);
1713 $sql .=
", '" . $this->db->escape($this->accountancy_code_buy) .
"'";
1714 $sql .=
", '" . $this->db->escape($this->accountancy_code_buy_intra) .
"'";
1715 $sql .=
", '" . $this->db->escape($this->accountancy_code_buy_export) .
"'";
1716 $sql .=
", '" . $this->db->escape($this->accountancy_code_sell) .
"'";
1717 $sql .=
", '" . $this->db->escape($this->accountancy_code_sell_intra) .
"'";
1718 $sql .=
", '" . $this->db->escape($this->accountancy_code_sell_export) .
"'";
1720 $result = $this->db->query($sql);
1723 $this->error =
'ErrorFailedToUpdateAccountancyForEntity';
1727 if (!$this->
hasbatch() && $this->oldcopy->hasbatch()) {
1729 $sql =
'SELECT pb.qty, ps.fk_entrepot, pb.batch FROM '.MAIN_DB_PREFIX.
'product_batch as pb';
1730 $sql .=
' INNER JOIN '.MAIN_DB_PREFIX.
'product_stock as ps ON (ps.rowid = pb.fk_product_stock)';
1731 $sql .=
' WHERE ps.fk_product = '.(int) $this->
id;
1733 $resql = $this->db->query($sql);
1737 while ($obj = $this->db->fetch_object($resql)) {
1739 $fk_entrepot = $obj->fk_entrepot;
1743 $batch = $obj->batch;
1746 $addOremove = $value > 0 ? 1 : 0;
1747 $label = $langs->trans(
'BatchStockMouvementAddInGlobal');
1748 $res = $this->
correct_stock_batch($user, $fk_entrepot, abs($value), $addOremove, $label, $price, $dlc, $dluo, $batch, $inventorycode,
'',
null, 0,
null,
true);
1751 $label = $langs->trans(
'BatchStockMouvementAddInGlobal');
1752 $res = $this->
correct_stock($user, $fk_entrepot, abs($value), (
int) empty($addOremove), $label, $price, $inventorycode,
'',
null, 0);
1771 if (!$error && !$notrigger) {
1773 $result = $this->call_trigger(
'PRODUCT_MODIFY', $user);
1780 if (!$error && (is_object($this->oldcopy) && $this->oldcopy->ref !== $this->ref)) {
1782 if (
$conf->product->dir_output) {
1785 if (file_exists($olddir)) {
1789 $res = @rename($olddir, $newdir);
1791 $langs->load(
"errors");
1792 $this->error = $langs->trans(
'ErrorFailToRenameDir', $olddir, $newdir);
1796 require_once DOL_DOCUMENT_ROOT .
'/ecm/class/ecmfiles.class.php';
1797 $ecmfiles =
new EcmFiles($this->db);
1798 $ecmfiles->updateAfterRename(
"produit/".
dol_sanitizeFileName($this->oldcopy->ref),
"produit/".dol_sanitizeFileName($this->ref));
1806 include_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination.class.php';
1810 foreach ($comb->fetchAllByFkProductParent($this->id) as $currcomb) {
1811 $currcomb->updateProperties($this, $user);
1815 $this->db->commit();
1818 $this->db->rollback();
1822 if ($this->db->errno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
1823 $langs->load(
"errors");
1824 if (empty(
$conf->barcode->enabled) || empty($this->barcode)) {
1825 $this->error = $langs->trans(
"Error").
" : ".$langs->trans(
"ErrorProductAlreadyExists", $this->
ref);
1827 $this->error = $langs->trans(
"Error").
" : ".$langs->trans(
"ErrorProductBarCodeAlreadyExists", $this->barcode);
1829 $this->errors[] = $this->error;
1830 $this->db->rollback();
1833 $this->error = $langs->trans(
"Error").
" : ".$this->db->error().
" - ".$sql;
1834 $this->errors[] = $this->error;
1835 $this->db->rollback();
1840 $this->db->rollback();
1841 dol_syslog(get_class($this).
"::Update fails verify ".implode(
',', $this->errors), LOG_WARNING);
1853 public function delete(
User $user, $notrigger = 0)
1856 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1861 if (empty($this->
id)) {
1862 $this->error =
"Object must be fetched before calling delete";
1865 if (($this->
isProduct() && !$user->
hasRight(
'produit',
'supprimer')) || ($this->isService() && !$user->hasRight(
'service',
'supprimer'))) {
1866 $this->error =
"ErrorForbidden";
1871 if (empty($objectisused)) {
1874 if (empty($notrigger)) {
1876 $result = $this->call_trigger(
'PRODUCT_DELETE', $user);
1885 $sql =
"DELETE FROM ".$this->db->prefix().
'product_batch';
1886 $sql .=
" WHERE fk_product_stock IN (";
1887 $sql .=
"SELECT rowid FROM ".$this->db->prefix().
'product_stock';
1888 $sql .=
" WHERE fk_product = ".((int) $this->
id).
")";
1890 $result = $this->db->query($sql);
1893 $this->errors[] = $this->db->lasterror();
1899 $sql =
"DELETE FROM " . $this->db->prefix() .
"product_fournisseur_price_log";
1900 $sql .=
" WHERE fk_product_fournisseur IN (";
1901 $sql .=
" SELECT rowid FROM " . $this->db->prefix() .
"product_fournisseur_price";
1902 $sql .=
" WHERE fk_product = " . ((int) $this->
id);
1905 $resql = $this->db->query($sql);
1908 $this->errors[] = $this->db->lasterror();
1914 $elements = array(
'product_fournisseur_price',
'product_price',
'product_lang',
'categorie_product',
'product_stock',
'product_customer_price',
'product_lot');
1915 foreach ($elements as $table) {
1917 $sql =
"DELETE FROM ".$this->db->prefix().$table;
1918 $sql .=
" WHERE fk_product = ".(int) $this->
id;
1920 $result = $this->db->query($sql);
1923 $this->errors[] = $this->db->lasterror();
1930 include_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination.class.php';
1931 include_once DOL_DOCUMENT_ROOT.
'/variants/class/ProductCombination2ValuePair.class.php';
1936 if ($prodcomb->deleteByFkProductParent($user, $this->id) < 0) {
1938 $this->errors[] =
'Error deleting combinations';
1942 if (!$error && ($prodcomb->fetchByFkProductChild($this->id) > 0) && ($prodcomb->delete($user) < 0)) {
1944 $this->errors[] =
'Error deleting child combination';
1950 $sql =
"DELETE FROM ".$this->db->prefix().
"product_association";
1951 $sql .=
" WHERE fk_product_pere = ".(int) $this->
id.
" OR fk_product_fils = ".(
int) $this->id;
1953 $result = $this->db->query($sql);
1956 $this->errors[] = $this->db->lasterror();
1965 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
1971 $sqlz =
"DELETE FROM ".$this->db->prefix().
"product";
1972 $sqlz .=
" WHERE rowid = ".(int) $this->
id;
1974 $resultz = $this->db->query($sqlz);
1977 $this->errors[] = $this->db->lasterror();
1993 if ($conf->product->dir_output) {
1994 $dir =
$conf->product->dir_output.
"/".$ref;
1995 if (file_exists($dir)) {
1998 $this->errors[] =
'ErrorFailToDeleteDir';
2006 $this->db->commit();
2009 foreach ($this->errors as $errmsg) {
2010 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
2011 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2013 $this->db->rollback();
2017 $this->error =
"ErrorRecordIsUsedCantDelete";
2031 $sellByLabel = $langs->trans(
'SellByDate');
2032 $eatByLabel = $langs->trans(
'EatByDate');
2034 self::SELL_OR_EAT_BY_MANDATORY_ID_NONE => $langs->trans(
'BatchSellOrEatByMandatoryNone'),
2035 self::SELL_OR_EAT_BY_MANDATORY_ID_SELL_BY => $sellByLabel,
2036 self::SELL_OR_EAT_BY_MANDATORY_ID_EAT_BY => $eatByLabel,
2037 self::SELL_OR_EAT_BY_MANDATORY_ID_SELL_AND_EAT => $langs->trans(
'BatchSellOrEatByMandatoryAll', $sellByLabel, $eatByLabel),
2048 $sellOrEatByMandatoryLabel =
'';
2051 if (isset($sellOrEatByMandatoryList[$this->sell_or_eat_by_mandatory])) {
2052 $sellOrEatByMandatoryLabel = $sellOrEatByMandatoryList[$this->sell_or_eat_by_mandatory];
2055 return $sellOrEatByMandatoryLabel;
2069 $langs_available = $langs->get_available_languages(DOL_DOCUMENT_ROOT, 0, 2);
2070 $current_lang = $langs->getDefaultLang();
2072 foreach ($langs_available as $key => $value) {
2073 if ($key == $current_lang) {
2074 $sql =
"SELECT rowid";
2075 $sql .=
" FROM ".$this->db->prefix().
"product_lang";
2076 $sql .=
" WHERE fk_product = ".((int) $this->
id);
2077 $sql .=
" AND lang = '".$this->db->escape($key).
"'";
2079 $result = $this->db->query($sql);
2081 if ($this->db->num_rows($result)) {
2082 $sql2 =
"UPDATE ".$this->db->prefix().
"product_lang";
2084 $sql2 .=
" label='".$this->db->escape($this->label).
"',";
2085 $sql2 .=
" description='".$this->db->escape($this->
description).
"'";
2087 $sql2 .=
", note='".$this->db->escape($this->other).
"'";
2089 $sql2 .=
" WHERE fk_product = ".((int) $this->
id).
" AND lang = '".$this->db->escape($key).
"'";
2091 $sql2 =
"INSERT INTO ".$this->db->prefix().
"product_lang (fk_product, lang, label, description";
2096 $sql2 .=
" VALUES(".((int) $this->
id).
",'".$this->db->escape($key).
"','".$this->db->escape($this->label).
"',";
2097 $sql2 .=
" '".$this->db->escape($this->
description).
"'";
2099 $sql2 .=
", '".$this->db->escape($this->other).
"'";
2103 dol_syslog(get_class($this).
'::setMultiLangs key = current_lang = '.$key);
2104 if (!$this->db->query($sql2)) {
2105 $this->error = $this->db->lasterror();
2108 } elseif (isset($this->multilangs[$key])) {
2109 if (empty($this->multilangs[$key][
"label"])) {
2110 $this->errors[] = $key .
' : ' . $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Label"));
2114 $sql =
"SELECT rowid";
2115 $sql .=
" FROM ".$this->db->prefix().
"product_lang";
2116 $sql .=
" WHERE fk_product = ".((int) $this->
id);
2117 $sql .=
" AND lang = '".$this->db->escape($key).
"'";
2119 $result = $this->db->query($sql);
2121 if ($this->db->num_rows($result)) {
2122 $sql2 =
"UPDATE ".$this->db->prefix().
"product_lang";
2124 $sql2 .=
" label = '".$this->db->escape($this->multilangs[
"$key"][
"label"]).
"',";
2125 $sql2 .=
" description = '".$this->db->escape($this->multilangs[
"$key"][
"description"]).
"'";
2128 $sql2 .=
", note = '".$this->db->escape($this->multilangs[
"$key"][
"other"]).
"'";
2130 $sql2 .=
" WHERE fk_product = ".((int) $this->
id).
" AND lang = '".$this->db->escape($key).
"'";
2132 $sql2 =
"INSERT INTO ".$this->db->prefix().
"product_lang (fk_product, lang, label, description";
2137 $sql2 .=
" VALUES(".((int) $this->
id).
",'".$this->db->escape($key).
"','".$this->db->escape($this->multilangs[
"$key"][
"label"]).
"',";
2138 $sql2 .=
" '".$this->db->escape($this->multilangs[
"$key"][
"description"]).
"'";
2141 $sql2 .=
", '".$this->db->escape($this->multilangs[
"$key"][
"other"]).
"'";
2147 if ($this->multilangs[
"$key"][
"label"] || $this->multilangs[
"$key"][
"description"]) {
2148 if (!$this->db->query($sql2)) {
2149 $this->error = $this->db->lasterror();
2158 if (empty($notrigger)) {
2160 $result = $this->call_trigger(
'PRODUCT_SET_MULTILANGS', $user);
2162 $this->error = $this->db->lasterror();
2182 $sql =
"DELETE FROM ".$this->db->prefix().
"product_lang";
2183 $sql .=
" WHERE fk_product = ".((int) $this->
id).
" AND lang = '".$this->db->escape($langtodelete).
"'";
2185 dol_syslog(get_class($this).
'::delMultiLangs', LOG_DEBUG);
2186 $result = $this->db->query($sql);
2188 if (empty($notrigger)) {
2190 $result = $this->call_trigger(
'PRODUCT_DEL_MULTILANGS', $user);
2192 $this->error = $this->db->lasterror();
2193 dol_syslog(get_class($this).
'::delMultiLangs error='.$this->error, LOG_ERR);
2198 unset($this->multilangs[$langtodelete]);
2201 $this->error = $this->db->lasterror();
2202 dol_syslog(get_class($this).
'::delMultiLangs error='.$this->error, LOG_ERR);
2223 if ($type ==
'buy') {
2224 $field =
'accountancy_code_buy';
2225 } elseif ($type ==
'buy_intra') {
2226 $field =
'accountancy_code_buy_intra';
2227 } elseif ($type ==
'buy_export') {
2228 $field =
'accountancy_code_buy_export';
2229 } elseif ($type ==
'sell') {
2230 $field =
'accountancy_code_sell';
2231 } elseif ($type ==
'sell_intra') {
2232 $field =
'accountancy_code_sell_intra';
2233 } elseif ($type ==
'sell_export') {
2234 $field =
'accountancy_code_sell_export';
2239 $sql =
"UPDATE ".$this->db->prefix().$this->table_element.
" SET ";
2240 $sql .=
"$field = '".$this->db->escape($value).
"'";
2241 $sql .=
" WHERE rowid = ".((int) $this->
id);
2244 $resql = $this->db->query($sql);
2248 $result = $this->call_trigger(
'PRODUCT_MODIFY', $user);
2255 $this->db->rollback();
2259 $this->$field = $value;
2261 $this->db->commit();
2264 $this->error = $this->db->lasterror();
2265 $this->db->rollback();
2281 $current_lang = $langs->getDefaultLang();
2284 $sql =
"SELECT lang, label, description, note as other";
2285 $sql .=
" FROM ".$this->db->prefix().
"product_lang";
2286 $sql .=
" WHERE fk_product = ".((int) $this->
id);
2288 $result = $this->db->query($sql);
2290 while ($obj = $this->db->fetch_object($result)) {
2292 if ($obj->lang == $current_lang) {
2293 $this->label = $obj->label;
2295 $this->other = $obj->other;
2297 $this->multilangs[(
string) $obj->lang][
"label"] = $obj->label;
2298 $this->multilangs[(
string) $obj->lang][
"description"] = $obj->description;
2299 $this->multilangs[(
string) $obj->lang][
"other"] = $obj->other;
2303 $this->error =
"Error: ".$this->db->lasterror().
" - ".$sql;
2316 $testExit = array(
'multiprices',
'multiprices_ttc',
'multiprices_base_type',
'multiprices_min',
'multiprices_min_ttc',
'multiprices_tva_tx',
'multiprices_recuperableonly');
2318 foreach ($testExit as $field) {
2319 if (!isset($this->$field)) {
2322 $tmparray = $this->$field;
2323 if (!isset($tmparray[$level])) {
2329 'level' => $level ? $level : 1,
2330 'multiprices' => (float) $this->multiprices[$level],
2331 'multiprices_ttc' => (
float) $this->multiprices_ttc[$level],
2332 'multiprices_base_type' => $this->multiprices_base_type[$level],
2333 'multiprices_min' => (float) $this->multiprices_min[$level],
2334 'multiprices_min_ttc' => (
float) $this->multiprices_min_ttc[$level],
2335 'multiprices_tva_tx' => (float) $this->multiprices_tva_tx[$level],
2336 'multiprices_recuperableonly' => (
float) $this->multiprices_recuperableonly[$level],
2359 if (empty($this->price_by_qty)) {
2360 $this->price_by_qty = 0;
2364 $sql =
"INSERT INTO ".$this->db->prefix().
"product_price(price_level,date_price, fk_product, fk_user_author, price_label, price, price_ttc, price_base_type,tosell, tva_tx, default_vat_code, recuperableonly,";
2365 $sql .=
" localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, price_min,price_min_ttc,price_by_qty,entity,fk_price_expression) ";
2366 $sql .=
" VALUES(".($level ? ((int) $level) : 1).
", '".$this->db->idate($now).
"', ".((int) $this->
id).
", ".((int) $user->id).
", ".(empty($this->price_label) ?
"null" :
"'".$this->db->escape($this->price_label).
"'").
", ".((float)
price2num($this->
price)).
", ".((
float)
price2num($this->price_ttc)).
",'".$this->db->escape($this->price_base_type).
"',".((int) $this->
status).
", ".((float)
price2num($this->tva_tx)).
", ".($this->default_vat_code ? (
"'".$this->db->escape($this->default_vat_code).
"'") :
"null").
", ".((
int) $this->tva_npr).
",";
2367 $sql .=
" ".price2num($this->localtax1_tx).
", ".
price2num($this->localtax2_tx).
", '".$this->db->escape($this->localtax1_type).
"', '".$this->db->escape($this->localtax2_type).
"', ".
price2num($this->price_min).
", ".
price2num($this->price_min_ttc).
", ".
price2num($this->price_by_qty).
", ".((int)
$conf->entity).
",".($this->fk_price_expression > 0 ? ((int) $this->fk_price_expression) :
'null');
2370 dol_syslog(get_class($this).
"::_log_price", LOG_DEBUG);
2371 $resql = $this->db->query($sql);
2373 $this->error = $this->db->lasterror();
2393 $sql =
"DELETE FROM ".$this->db->prefix().
"product_price_by_qty";
2394 $sql .=
" WHERE fk_product_price = ".((int) $rowid);
2395 $sql .=
" AND fk_product_price IN (SELECT pp.rowid FROM ".$this->db->prefix().
"product_price as pp WHERE pp.fk_product = ".((int) $this->
id).
")";
2396 $resql = $this->db->query($sql);
2398 $sql =
"DELETE FROM ".$this->db->prefix().
"product_price_extrafields";
2399 $sql .=
" WHERE fk_object = ".((int) $rowid);
2400 $resql = $this->db->query($sql);
2402 $sql =
"DELETE FROM ".$this->db->prefix().
"product_price";
2403 $sql .=
" WHERE rowid = ".((int) $rowid);
2404 $sql .=
" AND fk_product = ".((int) $this->
id);
2405 $resql = $this->db->query($sql);
2409 $this->error = $this->db->lasterror();
2429 $sql .=
" pl.rowid as log_rowid,";
2430 $sql .=
" pl.datec,";
2431 $sql .=
" pl.price,";
2432 $sql .=
" pl.quantity,";
2433 $sql .=
" pl.fk_user,";
2434 $sql .=
" pl.multicurrency_code,";
2435 $sql .=
" pl.multicurrency_price,";
2437 $sql .=
" pp.fk_soc as supplier_id,";
2438 $sql .=
" pp.ref_fourn as supplier_ref,";
2439 $sql .=
" pp.entity as entity";
2441 $sql .=
" FROM " . $this->db->prefix() .
"product_fournisseur_price_log as pl";
2442 $sql .=
" INNER JOIN " . $this->db->prefix() .
"product_fournisseur_price as pp ON pl.fk_product_fournisseur = pp.rowid";
2444 $sql .=
" WHERE pp.fk_product = " . ((int) $id);
2445 $sql .=
" AND pp.entity IN (" .
getEntity(
'product') .
")";
2446 $sql .=
" ORDER BY pl.datec DESC";
2448 $resql = $this->db->query($sql);
2450 while ($obj = $this->db->fetch_object($resql)) {
2451 if (is_string($obj->datec)) {
2452 $obj->datec = strtotime($obj->datec);
2456 $this->db->free($resql);
2458 $this->error = $this->db->lasterror();
2473 public function getSellPrice($thirdparty_seller, $thirdparty_buyer, $pqp = 0)
2475 global $hookmanager, $action;
2478 if (is_object($hookmanager)) {
2479 $parameters = array(
'thirdparty_seller' => $thirdparty_seller,
'thirdparty_buyer' => $thirdparty_buyer,
'pqp' => $pqp);
2481 $reshook = $hookmanager->executeHooks(
'getSellPrice', $parameters, $this, $action);
2483 return $hookmanager->resArray;
2488 $tva_tx =
get_default_tva($thirdparty_seller, $thirdparty_buyer, $this->
id);
2489 $tva_npr =
get_default_npr($thirdparty_seller, $thirdparty_buyer, $this->
id);
2490 if (empty($tva_tx)) {
2494 $pu_ht = $this->price;
2495 $pu_ttc = $this->price_ttc;
2496 $price_min = $this->price_min;
2497 $price_min_ttc = $this->price_min_ttc;
2498 $price_base_type = (empty($this->price_base_type) ?
'HT' : $this->price_base_type);
2502 require_once DOL_DOCUMENT_ROOT.
'/product/class/productcustomerprice.class.php';
2506 $filter = array(
't.fk_product' => (
string) $this->
id,
't.fk_soc' => (
string) $thirdparty_buyer->id);
2509 $pricebycustomerexist =
false;
2510 $result = $prodcustprice->fetchAll(
'',
'', 0, 0, $filter);
2512 if (count($prodcustprice->lines) > 0) {
2513 $date_now = (int) floor(
dol_now() / 86400) * 86400;
2514 foreach ($prodcustprice->lines as $k => $custprice_line) {
2515 if ($custprice_line->date_begin <= $date_now && (empty($custprice_line->date_end) || $date_now <= $custprice_line->date_end)) {
2516 $pricebycustomerexist =
true;
2517 $pu_ht =
price($custprice_line->price);
2518 $price_min =
price($custprice_line->price_min);
2519 $price_min_ttc =
price($custprice_line->price_min_ttc);
2520 $pu_ttc =
price($custprice_line->price_ttc);
2521 $price_base_type = $custprice_line->price_base_type;
2522 $tva_tx = $custprice_line->tva_tx;
2523 if ($custprice_line->default_vat_code && !preg_match(
'/\(.*\)/', $tva_tx)) {
2524 $tva_tx .=
' (' . $custprice_line->default_vat_code .
')';
2526 $tva_npr = $custprice_line->recuperableonly;
2527 if (empty($tva_tx)) {
2536 if (!$pricebycustomerexist && !empty($thirdparty_buyer->price_level)) {
2537 $pu_ht = isset($this->multiprices[$thirdparty_buyer->price_level]) ? $this->multiprices[$thirdparty_buyer->price_level] : 0;
2538 $pu_ttc = isset($this->multiprices_ttc[$thirdparty_buyer->price_level]) ? $this->multiprices_ttc[$thirdparty_buyer->price_level] : 0;
2539 $price_min = isset($this->multiprices_min[$thirdparty_buyer->price_level]) ? $this->multiprices_min[$thirdparty_buyer->price_level] : 0;
2540 $price_min_ttc = isset($this->multiprices_min_ttc[$thirdparty_buyer->price_level]) ? $this->multiprices_min_ttc[$thirdparty_buyer->price_level] : 0;
2541 $price_base_type = isset($this->multiprices_base_type[$thirdparty_buyer->price_level]) ? $this->multiprices_base_type[$thirdparty_buyer->price_level] :
'HT';
2544 if (isset($this->multiprices_tva_tx[$thirdparty_buyer->price_level])) {
2545 $tva_tx = $this->multiprices_tva_tx[$thirdparty_buyer->price_level];
2547 if (isset($this->multiprices_recuperableonly[$thirdparty_buyer->price_level])) {
2548 $tva_npr = $this->multiprices_recuperableonly[$thirdparty_buyer->price_level];
2550 if (empty($tva_tx)) {
2555 } elseif (
getDolGlobalString(
'PRODUIT_MULTIPRICES') && !empty($thirdparty_buyer->price_level)) {
2556 $pu_ht = isset($this->multiprices[$thirdparty_buyer->price_level]) ? $this->multiprices[$thirdparty_buyer->price_level] : 0;
2557 $pu_ttc = isset($this->multiprices_ttc[$thirdparty_buyer->price_level]) ? $this->multiprices_ttc[$thirdparty_buyer->price_level] : 0;
2558 $price_min = isset($this->multiprices_min[$thirdparty_buyer->price_level]) ? $this->multiprices_min[$thirdparty_buyer->price_level] : 0;
2559 $price_min_ttc = isset($this->multiprices_min_ttc[$thirdparty_buyer->price_level]) ? $this->multiprices_min_ttc[$thirdparty_buyer->price_level] : 0;
2560 $price_base_type = isset($this->multiprices_base_type[$thirdparty_buyer->price_level]) ? $this->multiprices_base_type[$thirdparty_buyer->price_level] :
'HT';
2563 if (isset($this->multiprices_tva_tx[$thirdparty_buyer->price_level])) {
2564 $tva_tx = $this->multiprices_tva_tx[$thirdparty_buyer->price_level];
2566 if (isset($this->multiprices_recuperableonly[$thirdparty_buyer->price_level])) {
2567 $tva_npr = $this->multiprices_recuperableonly[$thirdparty_buyer->price_level];
2569 if (empty($tva_tx)) {
2575 require_once DOL_DOCUMENT_ROOT.
'/product/class/productcustomerprice.class.php';
2579 $filter = array(
't.fk_product' => (
string) $this->
id,
't.fk_soc' => (
string) $thirdparty_buyer->id);
2581 $result = $prodcustprice->fetchAll(
'',
'', 0, 0, $filter);
2583 if (count($prodcustprice->lines) > 0) {
2584 $date_now = (int) floor(
dol_now() / 86400) * 86400;
2585 foreach ($prodcustprice->lines as $k => $custprice_line) {
2586 if ($custprice_line->date_begin <= $date_now && (empty($custprice_line->date_end) || $date_now <= $custprice_line->date_end)) {
2587 $pu_ht =
price($custprice_line->price);
2588 $price_min =
price($custprice_line->price_min);
2589 $price_min_ttc =
price($custprice_line->price_min_ttc);
2590 $pu_ttc =
price($custprice_line->price_ttc);
2591 $price_base_type = $custprice_line->price_base_type;
2592 $tva_tx = $custprice_line->tva_tx;
2593 if ($custprice_line->default_vat_code && !preg_match(
'/\(.*\)/', $tva_tx)) {
2594 $tva_tx .=
' (' . $custprice_line->default_vat_code .
')';
2596 $tva_npr = $custprice_line->recuperableonly;
2597 if (empty($tva_tx)) {
2607 if (!empty($this->prices_by_qty[0])) {
2610 foreach ($this->prices_by_qty_list[0] as $priceforthequantityarray) {
2611 if ($priceforthequantityarray[
'rowid'] != $pqp) {
2615 if ($priceforthequantityarray[
'price_base_type'] ==
'HT') {
2616 $pu_ht = $priceforthequantityarray[
'unitprice'];
2618 $pu_ttc = $priceforthequantityarray[
'unitprice'];
2625 if (!empty($thirdparty_buyer->price_level)) {
2627 $pu_ht = isset($this->multiprices[$thirdparty_buyer->price_level]) ? $this->multiprices[$thirdparty_buyer->price_level] : 0;
2628 $pu_ttc = isset($this->multiprices_ttc[$thirdparty_buyer->price_level]) ? $this->multiprices_ttc[$thirdparty_buyer->price_level] : 0;
2629 $price_min = isset($this->multiprices_min[$thirdparty_buyer->price_level]) ? $this->multiprices_min[$thirdparty_buyer->price_level] : 0;
2630 $price_min_ttc = isset($this->multiprices_min_ttc[$thirdparty_buyer->price_level]) ? $this->multiprices_min_ttc[$thirdparty_buyer->price_level] : 0;
2631 $price_base_type = empty($this->multiprices_base_type[$thirdparty_buyer->price_level]) ?
'HT' : $this->multiprices_base_type[$thirdparty_buyer->price_level];
2634 if (isset($this->multiprices_tva_tx[$thirdparty_buyer->price_level])) {
2635 $tva_tx = $this->multiprices_tva_tx[$thirdparty_buyer->price_level];
2637 if (isset($this->multiprices_recuperableonly[$thirdparty_buyer->price_level])) {
2638 $tva_npr = $this->multiprices_recuperableonly[$thirdparty_buyer->price_level];
2640 if (empty($tva_tx)) {
2645 if (!empty($thirdparty_buyer->price_level) && !empty($this->prices_by_qty[$thirdparty_buyer->price_level])) {
2648 foreach ($this->prices_by_qty_list[$thirdparty_buyer->price_level] as $priceforthequantityarray) {
2649 if ($priceforthequantityarray[
'rowid'] != $pqp) {
2653 if ($priceforthequantityarray[
'price_base_type'] ==
'HT') {
2654 $pu_ht = $priceforthequantityarray[
'unitprice'];
2656 $pu_ttc = $priceforthequantityarray[
'unitprice'];
2663 $localtax1 =
get_localtax((
string) $tva_tx, 1, $thirdparty_buyer, $thirdparty_seller, $tva_npr);
2664 $localtax2 =
get_localtax((
string) $tva_tx, 2, $thirdparty_buyer, $thirdparty_seller, $tva_npr);
2666 return array(
'pu_ht' => $pu_ht,
'pu_ttc' => $pu_ttc,
'price_min' => $price_min,
'price_min_ttc' => $price_min_ttc,
'price_base_type' => $price_base_type,
'tva_tx' => $tva_tx,
'tva_npr' => $tva_npr,
'localtax1' => $localtax1,
'localtax2' => $localtax2);
2683 public function get_buyprice($prodfournprice, $qty, $product_id = 0, $fourn_ref =
'', $fk_soc = 0)
2686 global $action, $hookmanager;
2689 if (is_object($hookmanager)) {
2690 $parameters = array(
2691 'prodfournprice' => $prodfournprice,
2693 'product_id' => $product_id,
2694 'fourn_ref' => $fourn_ref,
2695 'fk_soc' => $fk_soc,
2698 $reshook = $hookmanager->executeHooks(
'getBuyPrice', $parameters, $this, $action);
2700 return $hookmanager->resArray;
2707 $sql =
"SELECT pfp.rowid, pfp.price as price, pfp.quantity as quantity, pfp.remise_percent, pfp.fk_soc,";
2708 $sql .=
" pfp.fk_product, pfp.ref_fourn as ref_supplier, pfp.desc_fourn as desc_supplier, pfp.tva_tx, pfp.default_vat_code, pfp.fk_supplier_price_expression,";
2709 $sql .=
" pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code,";
2710 $sql .=
" pfp.packaging";
2711 $sql .=
" FROM ".$this->db->prefix().
"product_fournisseur_price as pfp";
2712 $sql .=
" WHERE pfp.rowid = ".((int) $prodfournprice);
2714 $sql .=
" AND pfp.quantity <= ".((float) $qty);
2716 $sql .=
" ORDER BY pfp.quantity DESC";
2718 dol_syslog(get_class($this).
"::get_buyprice first search by prodfournprice/qty", LOG_DEBUG);
2719 $resql = $this->db->query($sql);
2721 $obj = $this->db->fetch_object($resql);
2722 if ($obj && $obj->quantity > 0) {
2723 if (
isModEnabled(
'dynamicprices') && !empty($obj->fk_supplier_price_expression)) {
2725 $prod_supplier->product_fourn_price_id = $obj->rowid;
2726 $prod_supplier->id = $obj->fk_product;
2727 $prod_supplier->fourn_qty = $obj->quantity;
2728 $prod_supplier->fourn_tva_tx = $obj->tva_tx;
2729 $prod_supplier->fk_supplier_price_expression = $obj->fk_supplier_price_expression;
2731 include_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
2733 $price_result = $priceparser->parseProductSupplier($prod_supplier);
2734 if ($price_result >= 0) {
2735 $obj->price = $price_result;
2738 $this->product_fourn_price_id = $obj->rowid;
2739 $this->buyprice = $obj->price;
2740 $this->fourn_pu = $obj->price / $obj->quantity;
2741 $this->fourn_price_base_type =
'HT';
2742 $this->fourn_socid = $obj->fk_soc;
2743 $this->ref_fourn = $obj->ref_supplier;
2744 $this->ref_supplier = $obj->ref_supplier;
2745 $this->desc_supplier = $obj->desc_supplier;
2746 $this->remise_percent = $obj->remise_percent;
2747 $this->vatrate_supplier = $obj->tva_tx;
2748 $this->default_vat_code_supplier = $obj->default_vat_code;
2749 $this->fourn_multicurrency_price = $obj->multicurrency_price;
2750 $this->fourn_multicurrency_unitprice = $obj->multicurrency_unitprice;
2751 $this->fourn_multicurrency_tx = $obj->multicurrency_tx;
2752 $this->fourn_multicurrency_id = $obj->fk_multicurrency;
2753 $this->fourn_multicurrency_code = $obj->multicurrency_code;
2755 $this->packaging = (float) $obj->packaging;
2761 $this->fourn_qty = $obj->quantity;
2762 $result = $obj->fk_product;
2766 $sql =
"SELECT pfp.rowid, pfp.price as price, pfp.quantity as quantity, pfp.remise_percent, pfp.fk_soc,";
2767 $sql .=
" pfp.fk_product, pfp.ref_fourn as ref_supplier, pfp.desc_fourn as desc_supplier, pfp.tva_tx, pfp.default_vat_code, pfp.fk_supplier_price_expression,";
2768 $sql .=
" pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code,";
2769 $sql .=
" pfp.packaging";
2770 $sql .=
" FROM ".$this->db->prefix().
"product_fournisseur_price as pfp";
2771 $sql .=
" WHERE 1 = 1";
2772 if ($product_id > 0) {
2773 $sql .=
" AND pfp.fk_product = ".((int) $product_id);
2775 if ($fourn_ref !=
'none') {
2776 $sql .=
" AND pfp.ref_fourn = '".$this->db->escape($fourn_ref).
"'";
2779 $sql .=
" AND pfp.fk_soc = ".((int) $fk_soc);
2782 $sql .=
" AND pfp.quantity <= ".((float) $qty);
2784 $sql .=
" ORDER BY pfp.quantity DESC";
2787 dol_syslog(get_class($this).
"::get_buyprice second search from qty/ref/product_id", LOG_DEBUG);
2788 $resql = $this->db->query($sql);
2790 $obj = $this->db->fetch_object($resql);
2791 if ($obj && $obj->quantity > 0) {
2792 if (
isModEnabled(
'dynamicprices') && !empty($obj->fk_supplier_price_expression)) {
2794 $prod_supplier->product_fourn_price_id = $obj->rowid;
2795 $prod_supplier->id = $obj->fk_product;
2796 $prod_supplier->fourn_qty = $obj->quantity;
2797 $prod_supplier->fourn_tva_tx = $obj->tva_tx;
2798 $prod_supplier->fk_supplier_price_expression = $obj->fk_supplier_price_expression;
2800 include_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
2802 $price_result = $priceparser->parseProductSupplier($prod_supplier);
2803 if ($price_result >= 0) {
2804 $obj->price = $price_result;
2807 $this->product_fourn_price_id = $obj->rowid;
2808 $this->buyprice = $obj->price;
2809 $this->fourn_qty = $obj->quantity;
2810 $this->fourn_pu = $obj->price / $obj->quantity;
2811 $this->fourn_price_base_type =
'HT';
2812 $this->fourn_socid = $obj->fk_soc;
2813 $this->ref_fourn = $obj->ref_supplier;
2814 $this->ref_supplier = $obj->ref_supplier;
2815 $this->desc_supplier = $obj->desc_supplier;
2816 $this->remise_percent = $obj->remise_percent;
2817 $this->vatrate_supplier = $obj->tva_tx;
2818 $this->default_vat_code_supplier = $obj->default_vat_code;
2819 $this->fourn_multicurrency_price = $obj->multicurrency_price;
2820 $this->fourn_multicurrency_unitprice = $obj->multicurrency_unitprice;
2821 $this->fourn_multicurrency_tx = $obj->multicurrency_tx;
2822 $this->fourn_multicurrency_id = $obj->fk_multicurrency;
2823 $this->fourn_multicurrency_code = $obj->multicurrency_code;
2825 $this->packaging = (float) $obj->packaging;
2829 $this->fourn_qty = $obj->quantity;
2830 $result = $obj->fk_product;
2836 $this->error = $this->db->lasterror();
2841 $this->error = $this->db->lasterror();
2865 public function updatePrice($newprice, $newpricebase, $user, $newvat =
null, $newminprice = 0, $level = 0, $newnpr = 0, $newpbq = 0, $ignore_autogen = 0, $localtaxes_array = array(), $newdefaultvatcode =
'', $price_label =
'', $notrigger = 0)
2871 dol_syslog(get_class($this).
"::update_price id=".$id.
" newprice=".$newprice.
" newpricebase=".$newpricebase.
" newminprice=".$newminprice.
" level=".$level.
" npr=".$newnpr.
" newdefaultvatcode=".$newdefaultvatcode);
2874 if (empty($this->tva_tx)) {
2875 $this->tva_tx = 0.0;
2877 if (empty($newnpr)) {
2880 if (empty($newminprice)) {
2885 if ($newvat ===
null || $newvat ==
'') {
2886 $newvat = (float) $this->tva_tx;
2889 $localtaxtype1 =
'';
2890 $localtaxtype2 =
'';
2895 return $this->
generateMultiprices($user, $newprice, $newpricebase, $newvat, $newnpr, $newpbq);
2898 if (!empty($newminprice) && ($newminprice > $newprice)) {
2899 $this->error =
'ErrorPriceCantBeLowerThanMinPrice';
2903 if ($newprice === 0 || $newprice !==
'') {
2904 if ($newpricebase ==
'TTC') {
2905 $price_ttc = (float)
price2num($newprice,
'MU');
2906 $price = (float)
price2num($newprice) / (1 + ((float) $newvat / 100));
2907 $price = (float)
price2num($price,
'MU');
2909 if ((
string) $newminprice !=
'0') {
2910 $price_min_ttc = (float)
price2num($newminprice,
'MU');
2911 $price_min = (float)
price2num($newminprice) / (1 + ($newvat / 100));
2912 $price_min = (float)
price2num($price_min,
'MU');
2915 $price_min_ttc = 0.0;
2918 $price = (float)
price2num($newprice,
'MU');
2919 $price_ttc = ($newnpr != 1) ? (
float)
price2num($newprice) * (1 + ($newvat / 100)) : $price;
2920 $price_ttc = (float)
price2num($price_ttc,
'MU');
2922 if ((
string) $newminprice !=
'0') {
2923 $price_min = (float)
price2num($newminprice,
'MU');
2924 $price_min_ttc = (float)
price2num($newminprice) * (1 + ($newvat / 100));
2925 $price_min_ttc = (float)
price2num($price_min_ttc,
'MU');
2929 $price_min_ttc = 0.0;
2933 if (count($localtaxes_array) > 0) {
2934 $localtaxtype1 = $localtaxes_array[
'0'];
2935 $localtax1 = $localtaxes_array[
'1'];
2936 $localtaxtype2 = $localtaxes_array[
'2'];
2937 $localtax2 = $localtaxes_array[
'3'];
2940 if (!empty($newdefaultvatcode)) {
2943 $sql =
"SELECT t.rowid, t.code, t.recuperableonly as tva_npr, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
2944 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
2945 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$this->db->escape(
$mysoc->country_code).
"'";
2946 $sql .=
" AND t.taux = ".((float) $newdefaultvatcode).
" AND t.active = 1";
2947 $sql .=
" AND t.code = '".$this->db->escape($newdefaultvatcode).
"'";
2948 $resql = $this->db->query($sql);
2950 $obj = $this->db->fetch_object($resql);
2952 $npr = $obj->tva_npr;
2953 $localtax1 = $obj->localtax1;
2954 $localtax2 = $obj->localtax2;
2955 $localtaxtype1 = $obj->localtax1_type;
2956 $localtaxtype2 = $obj->localtax2_type;
2961 $localtaxtype1 =
'0';
2963 $localtaxtype2 =
'0';
2967 if (empty($localtax1)) {
2970 if (empty($localtax2)) {
2979 $updatedefaultprice = (empty($level) || $level == 1);
2983 $sql =
"UPDATE ".$this->db->prefix().
"product SET";
2984 if ($updatedefaultprice) {
2985 $sql .=
" price_base_type = '".$this->db->escape($newpricebase).
"',";
2986 $sql .=
" price = ".(float) $price.
",";
2987 $sql .=
" price_ttc = ".(float) $price_ttc.
",";
2988 $sql .=
" price_min = ".(float) $price_min.
",";
2989 $sql .=
" price_min_ttc = ".(float) $price_min_ttc.
",";
2990 $sql .=
" price_label = ".(!empty($price_label) ?
"'".$this->db->escape($price_label).
"'" :
"null").
",";
2992 $sql .=
" localtax1_tx = ".($localtax1 >= 0 ? (float) $localtax1 :
'NULL').
",";
2993 $sql .=
" localtax2_tx = ".($localtax2 >= 0 ? (float) $localtax2 :
'NULL').
",";
2994 $sql .=
" localtax1_type = ".($localtaxtype1 !=
'' ?
"'".$this->db->escape($localtaxtype1).
"'" :
"'0'").
",";
2995 $sql .=
" localtax2_type = ".($localtaxtype2 !=
'' ?
"'".$this->db->escape($localtaxtype2).
"'" :
"'0'").
",";
2996 $sql .=
" default_vat_code = ".($newdefaultvatcode ?
"'".$this->db->escape($newdefaultvatcode).
"'" :
"null").
",";
2997 $sql .=
" tva_tx = ".(float)
price2num($newvat).
",";
2998 $sql .=
" recuperableonly = '".$this->db->escape((
string) $newnpr).
"'";
2999 $sql .=
" WHERE rowid = ".((int) $id);
3001 dol_syslog(get_class($this).
"::update_price", LOG_DEBUG);
3002 $resql = $this->db->query($sql);
3004 $this->multiprices[$level] = $price;
3005 $this->multiprices_ttc[$level] = $price_ttc;
3006 $this->multiprices_min[$level] = $price_min;
3007 $this->multiprices_min_ttc[$level] = $price_min_ttc;
3008 $this->multiprices_base_type[$level] = $newpricebase;
3009 $this->multiprices_default_vat_code[$level] = $newdefaultvatcode;
3010 $this->multiprices_tva_tx[$level] = $newvat;
3011 $this->multiprices_recuperableonly[$level] = $newnpr;
3015 $savdefaultprice = array($this->
price, $this->price_label, $this->price_ttc, $this->price_min, $this->price_min_ttc, $this->price_base_type);
3017 $this->
price = $price;
3018 $this->price_label = $price_label;
3019 $this->price_ttc = $price_ttc;
3020 $this->price_min = $price_min;
3021 $this->price_min_ttc = $price_min_ttc;
3022 $this->price_base_type = $newpricebase;
3023 $this->default_vat_code = $newdefaultvatcode;
3024 $this->tva_tx = $newvat;
3025 $this->tva_npr = $newnpr;
3028 $this->localtax1_tx = $localtax1;
3029 $this->localtax2_tx = $localtax2;
3030 $this->localtax1_type = $localtaxtype1;
3031 $this->localtax2_type = $localtaxtype2;
3034 $this->price_by_qty = $newpbq;
3038 if (!empty(array_diff_assoc($newPriceData, $lastPriceData)) || (!
getDolGlobalString(
'PRODUIT_MULTIPRICES') && !
getDolGlobalString(
'PRODUIT_CUSTOMER_PRICES_AND_MULTIPRICES'))) {
3042 if (!$updatedefaultprice) {
3044 list($this->
price, $this->price_label, $this->price_ttc, $this->price_min, $this->price_min_ttc, $this->price_base_type) = $savdefaultprice;
3047 $this->level = $level;
3051 $result = $this->call_trigger(
'PRODUCT_PRICE_MODIFY', $user);
3053 $this->db->rollback();
3059 $this->db->commit();
3061 $this->db->rollback();
3062 $this->error = $this->db->lasterror();
3081 $this->fk_price_expression = $expression_id;
3083 return $this->
update($this->
id, $user);
3098 public function fetch($id = 0, $ref =
'', $ref_ext =
'', $barcode =
'', $ignore_expression = 0, $ignore_price_load = 0, $ignore_lang_load = 0)
3100 include_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
3104 dol_syslog(get_class($this).
"::fetch id=".$id.
" ref=".$ref.
" ref_ext=".$ref_ext);
3107 if (!$id && !$ref && !$ref_ext && !$barcode) {
3108 $this->error =
'ErrorWrongParameters';
3109 dol_syslog(get_class($this).
"::fetch ".$this->error, LOG_ERR);
3113 $sql =
"SELECT p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note as note_private, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc,";
3114 $sql .=
" p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly as tva_npr, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell,";
3115 $sql .=
" p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units,";
3116 $sql .=
" p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.last_main_doc,";
3117 $sql .=
" p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period, p.packaging,";
3119 $sql .=
" p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export,";
3121 $sql .=
" ppe.accountancy_code_buy, ppe.accountancy_code_buy_intra, ppe.accountancy_code_buy_export, ppe.accountancy_code_sell, ppe.accountancy_code_sell_intra, ppe.accountancy_code_sell_export,";
3126 $separatedEntityPMP =
false;
3127 $separatedStock =
false;
3128 $visibleWarehousesEntities =
$conf->entity;
3131 $checkPMPPerEntity = $this->db->query(
"SELECT pmp FROM " . $this->db->prefix() .
"product_perentity WHERE fk_product = ".((int) $id).
" AND entity = ".(
int)
$conf->entity);
3132 if ($this->db->num_rows($checkPMPPerEntity) > 0) {
3133 $separatedEntityPMP =
true;
3137 $separatedStock =
true;
3138 if (isset($mc->sharings[
'stock']) && !empty($mc->sharings[
'stock'])) {
3139 $visibleWarehousesEntities .=
"," . implode(
",", $mc->sharings[
'stock']);
3142 if ($separatedEntityPMP) {
3143 $sql .=
" ppe.pmp,";
3147 $sql .=
" p.datec, GREATEST(p.tms, COALESCE(pef.tms, p.tms)) AS tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit,";
3148 $sql .=
" p.fk_price_expression, p.price_autogen, p.stockable_product, p.model_pdf,";
3149 $sql .=
" p.price_label,";
3150 if ($separatedStock) {
3151 $sql .=
" SUM(sp.reel) as stock";
3155 $sql .=
" FROM ".$this->db->prefix().
"product as p";
3156 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_extrafields as pef ON pef.fk_object=p.rowid";
3158 $sql .=
" LEFT JOIN " . $this->db->prefix() .
"product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int)
$conf->entity);
3160 if ($separatedStock) {
3161 $sql .=
" LEFT JOIN " . $this->db->prefix() .
"product_stock as sp ON sp.fk_product = p.rowid AND sp.fk_entrepot IN (SELECT rowid FROM ".$this->db->prefix().
"entrepot WHERE entity IN (".$this->db->sanitize($visibleWarehousesEntities).
"))";
3165 $sql .=
" WHERE p.rowid = ".((int) $id);
3167 $sql .=
" WHERE p.entity IN (".getEntity($this->element).
")";
3169 $sql .=
" AND p.ref = '".$this->db->escape($ref).
"'";
3170 } elseif ($ref_ext) {
3171 $sql .=
" AND p.ref_ext = '".$this->db->escape($ref_ext).
"'";
3172 } elseif ($barcode) {
3173 $sql .=
" AND p.barcode = '".$this->db->escape($barcode).
"'";
3176 if ($separatedStock) {
3177 $sql .=
" GROUP BY p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc,";
3178 $sql .=
" p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell,";
3179 $sql .=
" p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units,";
3180 $sql .=
" p.length, p.length_units, p.width, p.width_units, p.height, p.height_units,";
3181 $sql .=
" p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period, p.packaging,";
3183 $sql .=
" p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export,";
3185 $sql .=
" ppe.accountancy_code_buy, ppe.accountancy_code_buy_intra, ppe.accountancy_code_buy_export, ppe.accountancy_code_sell, ppe.accountancy_code_sell_intra, ppe.accountancy_code_sell_export,";
3187 if ($separatedEntityPMP) {
3188 $sql .=
" ppe.pmp,";
3192 $sql .=
" p.datec, p.tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit,";
3193 $sql .=
" p.fk_price_expression, p.price_autogen, p.stockable_product, p.model_pdf,";
3194 $sql .=
" p.price_label";
3201 $resql = $this->db->query($sql);
3203 unset($this->oldcopy);
3205 if ($this->db->num_rows($resql) > 0) {
3206 $obj = $this->db->fetch_object($resql);
3208 $this->
id = $obj->rowid;
3209 $this->
ref = $obj->ref;
3210 $this->ref_ext = $obj->ref_ext;
3211 $this->label = $obj->label;
3213 $this->url = $obj->url;
3214 $this->note_public = $obj->note_public;
3215 $this->note_private = $obj->note_private;
3216 $this->note = $obj->note_private;
3218 $this->
type = $obj->fk_product_type;
3219 $this->price_label = $obj->price_label;
3220 $this->
status = $obj->tosell;
3221 $this->status_buy = $obj->tobuy;
3222 $this->status_batch = $obj->tobatch;
3223 $this->sell_or_eat_by_mandatory = $obj->sell_or_eat_by_mandatory;
3224 $this->batch_mask = $obj->batch_mask;
3226 $this->customcode = $obj->customcode;
3227 $this->country_id = $obj->fk_country;
3228 $this->country_code =
getCountry($this->country_id,
'2', $this->db);
3229 $this->state_id = $obj->fk_state;
3230 $this->lifetime = $obj->lifetime;
3231 $this->qc_frequency = $obj->qc_frequency;
3232 $this->
price = $obj->price;
3233 $this->price_ttc = $obj->price_ttc;
3234 $this->price_min = $obj->price_min;
3235 $this->price_min_ttc = $obj->price_min_ttc;
3236 $this->price_base_type = (empty($obj->price_base_type) ?
'HT' : $obj->price_base_type);
3237 $this->cost_price = isset($obj->cost_price) ? (float) $obj->cost_price :
null;
3238 $this->default_vat_code = $obj->default_vat_code;
3239 $this->tva_tx = $obj->tva_tx;
3241 $this->tva_npr = $obj->tva_npr;
3243 $this->localtax1_tx = $obj->localtax1_tx;
3244 $this->localtax2_tx = $obj->localtax2_tx;
3245 $this->localtax1_type = $obj->localtax1_type;
3246 $this->localtax2_type = $obj->localtax2_type;
3248 $this->finished = $obj->finished;
3249 $this->fk_default_bom = $obj->fk_default_bom;
3251 $this->duration = $obj->duration;
3253 preg_match(
'/([\d.]+)(\w+)/', $obj->duration, $matches);
3254 $this->duration_value = !empty($matches[1]) ? (float) $matches[1] : 0;
3255 $this->duration_unit = !empty($matches[2]) ? (
string) $matches[2] :
null;
3256 $this->canvas = $obj->canvas;
3257 $this->net_measure = $obj->net_measure;
3258 $this->net_measure_units = $obj->net_measure_units;
3259 $this->weight = $obj->weight;
3260 $this->weight_units = (is_null($obj->weight_units) ? 0 : $obj->weight_units);
3261 $this->length = $obj->length;
3262 $this->length_units = (is_null($obj->length_units) ? 0 : $obj->length_units);
3263 $this->width = $obj->width;
3264 $this->width_units = (is_null($obj->width_units) ? 0 : $obj->width_units);
3265 $this->height = $obj->height;
3266 $this->height_units = (is_null($obj->height_units) ? 0 : $obj->height_units);
3268 $this->surface = $obj->surface;
3269 $this->surface_units = (is_null($obj->surface_units) ? 0 : $obj->surface_units);
3270 $this->volume = $obj->volume;
3271 $this->volume_units = (is_null($obj->volume_units) ? 0 : $obj->volume_units);
3272 $this->barcode = $obj->barcode;
3273 $this->barcode_type = $obj->fk_barcode_type;
3275 $this->accountancy_code_buy = $obj->accountancy_code_buy;
3276 $this->accountancy_code_buy_intra = $obj->accountancy_code_buy_intra;
3277 $this->accountancy_code_buy_export = $obj->accountancy_code_buy_export;
3278 $this->accountancy_code_sell = $obj->accountancy_code_sell;
3279 $this->accountancy_code_sell_intra = $obj->accountancy_code_sell_intra;
3280 $this->accountancy_code_sell_export = $obj->accountancy_code_sell_export;
3282 $this->fk_default_warehouse = $obj->fk_default_warehouse;
3283 $this->fk_default_workstation = $obj->fk_default_workstation;
3284 $this->seuil_stock_alerte = $obj->seuil_stock_alerte;
3285 $this->desiredstock = $obj->desiredstock;
3286 $this->stock_reel = $obj->stock;
3287 $this->stockable_product = $obj->stockable_product;
3288 $this->pmp = $obj->pmp;
3290 $this->date_creation = $this->db->jdate($obj->datec);
3291 $this->date_modification = $this->db->jdate($obj->tms);
3293 $this->import_key = $obj->import_key;
3294 $this->entity = $obj->entity;
3296 $this->ref_ext = $obj->ref_ext;
3297 $this->fk_price_expression = $obj->fk_price_expression;
3298 $this->fk_unit = $obj->fk_unit;
3299 $this->price_autogen = $obj->price_autogen;
3300 $this->model_pdf = $obj->model_pdf;
3301 $this->last_main_doc = $obj->last_main_doc;
3303 $this->mandatory_period = $obj->mandatory_period;
3306 $this->packaging = (float) $obj->packaging;
3309 $this->db->free($resql);
3321 $produit_multiprices_limit =
getDolGlobalInt(
'PRODUIT_MULTIPRICES_LIMIT');
3322 for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
3323 $sql =
"SELECT price, price_ttc, price_min, price_min_ttc,";
3324 $sql .=
" price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly";
3325 $sql .=
" ,price_label";
3326 $sql .=
" FROM ".$this->db->prefix().
"product_price";
3327 $sql .=
" WHERE entity IN (".getEntity(
'productprice').
")";
3328 $sql .=
" AND price_level=".((int) $i);
3329 $sql .=
" AND fk_product = ".((int) $this->
id);
3330 $sql .=
" ORDER BY date_price DESC, rowid DESC";
3332 $resql = $this->db->query($sql);
3334 $result = $this->db->fetch_array($resql);
3336 $this->multiprices[$i] = $result ? $result[
"price"] :
null;
3337 $this->multiprices_ttc[$i] = $result ? $result[
"price_ttc"] :
null;
3338 $this->multiprices_min[$i] = $result ? $result[
"price_min"] :
null;
3339 $this->multiprices_min_ttc[$i] = $result ? $result[
"price_min_ttc"] :
null;
3340 $this->multiprices_base_type[$i] = $result ? $result[
"price_base_type"] :
null;
3342 $this->multiprices_tva_tx[$i] = $result ? $result[
"tva_tx"].(!empty($result[
'default_vat_code']) ?
' ('.$result[
'default_vat_code'].
')' :
'') :
null;
3343 $this->multiprices_recuperableonly[$i] = $result ? $result[
"recuperableonly"] :
null;
3382 $this->error = $this->db->lasterror;
3388 } elseif (
getDolGlobalString(
'PRODUIT_CUSTOMER_PRICES_BY_QTY') && empty($ignore_price_load)) {
3389 $sql =
"SELECT price, price_ttc, price_min, price_min_ttc,";
3390 $sql .=
" price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid";
3391 $sql .=
" FROM ".$this->db->prefix().
"product_price";
3392 $sql .=
" WHERE fk_product = ".((int) $this->
id);
3393 $sql .=
" ORDER BY date_price DESC, rowid DESC";
3396 $resql = $this->db->query($sql);
3398 $result = $this->db->fetch_array($resql);
3402 $this->prices_by_qty[0] = $result[
"price_by_qty"];
3403 $this->prices_by_qty_id[0] = $result[
"rowid"];
3405 if ($this->prices_by_qty[0] == 1) {
3406 $sql =
"SELECT rowid,price, unitprice, quantity, remise_percent, remise, remise, price_base_type";
3407 $sql .=
" FROM ".$this->db->prefix().
"product_price_by_qty";
3408 $sql .=
" WHERE fk_product_price = ".((int) $this->prices_by_qty_id[0]);
3409 $sql .=
" ORDER BY quantity ASC";
3411 $resql = $this->db->query($sql);
3413 $resultat = array();
3415 while ($result = $this->db->fetch_array($resql)) {
3416 $resultat[$ii] = array();
3417 $resultat[$ii][
"rowid"] = $result[
"rowid"];
3418 $resultat[$ii][
"price"] = $result[
"price"];
3419 $resultat[$ii][
"unitprice"] = $result[
"unitprice"];
3420 $resultat[$ii][
"quantity"] = $result[
"quantity"];
3421 $resultat[$ii][
"remise_percent"] = $result[
"remise_percent"];
3423 $resultat[$ii][
"price_base_type"] = $result[
"price_base_type"];
3426 $this->prices_by_qty_list[0] = $resultat;
3428 $this->error = $this->db->lasterror;
3434 $this->error = $this->db->lasterror;
3437 } elseif (
getDolGlobalString(
'PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES') && empty($ignore_price_load)) {
3438 $produit_multiprices_limit =
getDolGlobalInt(
'PRODUIT_MULTIPRICES_LIMIT');
3439 for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
3440 $sql =
"SELECT price, price_ttc, price_min, price_min_ttc,";
3441 $sql .=
" price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly";
3442 $sql .=
" FROM ".$this->db->prefix().
"product_price";
3443 $sql .=
" WHERE entity IN (".getEntity(
'productprice').
")";
3444 $sql .=
" AND price_level=".((int) $i);
3445 $sql .=
" AND fk_product = ".((int) $this->
id);
3446 $sql .=
" ORDER BY date_price DESC, rowid DESC";
3448 $resql = $this->db->query($sql);
3450 $this->error = $this->db->lasterror;
3453 $result = $this->db->fetch_array($resql);
3454 $this->multiprices[$i] = (!empty($result[
"price"]) ? $result[
"price"] : 0);
3455 $this->multiprices_ttc[$i] = (!empty($result[
"price_ttc"]) ? $result[
"price_ttc"] : 0);
3456 $this->multiprices_min[$i] = (!empty($result[
"price_min"]) ? $result[
"price_min"] : 0);
3457 $this->multiprices_min_ttc[$i] = (!empty($result[
"price_min_ttc"]) ? $result[
"price_min_ttc"] : 0);
3458 $this->multiprices_base_type[$i] = (!empty($result[
"price_base_type"]) ? $result[
"price_base_type"] :
'');
3460 $this->multiprices_tva_tx[$i] = (!empty($result[
"tva_tx"]) ? $result[
"tva_tx"] : 0);
3461 $this->multiprices_recuperableonly[$i] = (!empty($result[
"recuperableonly"]) ? $result[
"recuperableonly"] : 0);
3464 $this->prices_by_qty[$i] = (!empty($result[
"price_by_qty"]) ? $result[
"price_by_qty"] : 0);
3465 $this->prices_by_qty_id[$i] = (!empty($result[
"rowid"]) ? $result[
"rowid"] : 0);
3467 if ($this->prices_by_qty[$i] == 1) {
3468 $sql =
"SELECT rowid, price, unitprice, quantity, remise_percent, remise, price_base_type";
3469 $sql .=
" FROM ".$this->db->prefix().
"product_price_by_qty";
3470 $sql .=
" WHERE fk_product_price = ".((int) $this->prices_by_qty_id[$i]);
3471 $sql .=
" ORDER BY quantity ASC";
3473 $resql = $this->db->query($sql);
3475 $resultat = array();
3477 while ($result = $this->db->fetch_array($resql)) {
3478 $resultat[$ii] = array();
3479 $resultat[$ii][
"rowid"] = $result[
"rowid"];
3480 $resultat[$ii][
"price"] = $result[
"price"];
3481 $resultat[$ii][
"unitprice"] = $result[
"unitprice"];
3482 $resultat[$ii][
"quantity"] = $result[
"quantity"];
3483 $resultat[$ii][
"remise_percent"] = $result[
"remise_percent"];
3484 $resultat[$ii][
"remise"] = $result[
"remise"];
3485 $resultat[$ii][
"price_base_type"] = $result[
"price_base_type"];
3488 $this->prices_by_qty_list[$i] = $resultat;
3490 $this->error = $this->db->lasterror;
3498 if (
isModEnabled(
'dynamicprices') && !empty($this->fk_price_expression) && empty($ignore_expression)) {
3499 include_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
3501 $price_result = $priceparser->parseProduct($this);
3502 if ($price_result >= 0) {
3503 $this->
price = $price_result;
3505 $this->price_ttc = (float)
price2num($this->
price) * (1 + ($this->tva_tx / 100));
3506 $this->price_ttc = (float)
price2num($this->price_ttc,
'MU');
3512 $this->stock_warehouse = array();
3519 $this->error = $this->db->lasterror();
3534 global $user, $hookmanager, $action;
3538 foreach (array(
'toconsume',
'consumed',
'toproduce',
'produced') as $role) {
3539 $this->stats_mo[
'customers_'.$role] = 0;
3540 $this->stats_mo[
'nb_'.$role] = 0;
3541 $this->stats_mo[
'qty_'.$role] = 0;
3543 $sql =
"SELECT COUNT(DISTINCT c.fk_soc) as nb_customers, COUNT(DISTINCT c.rowid) as nb,";
3544 $sql .=
" SUM(mp.qty) as qty";
3545 $sql .=
" FROM ".$this->db->prefix().
"mrp_mo as c";
3546 $sql .=
" INNER JOIN ".$this->db->prefix().
"mrp_production as mp ON mp.fk_mo=c.rowid";
3547 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
3548 $sql .=
" INNER JOIN ".$this->db->prefix().
"societe_commerciaux as sc ON sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id);
3551 $sql .=
" c.entity IN (".getEntity(
'mo').
")";
3553 $sql .=
" AND mp.fk_product = ".((int) $this->
id);
3554 $sql .=
" AND mp.role ='".$this->db->escape($role).
"'";
3556 $sql .=
" AND c.fk_soc = ".((int) $socid);
3559 $result = $this->db->query($sql);
3561 $obj = $this->db->fetch_object($result);
3562 $this->stats_mo[
'customers_'.$role] = $obj->nb_customers ? $obj->nb_customers : 0;
3563 $this->stats_mo[
'nb_'.$role] = $obj->nb ? $obj->nb : 0;
3564 $this->stats_mo[
'qty_'.$role] = $obj->qty ?
price2num($obj->qty,
'MS') : 0;
3566 $this->error = $this->db->error();
3571 if (!empty($error)) {
3575 $parameters = array(
'socid' => $socid);
3576 $reshook = $hookmanager->executeHooks(
'loadStatsCustomerMO', $parameters, $this, $action);
3578 $this->stats_mo = $hookmanager->resArray[
'stats_mo'];
3594 global $hookmanager, $action;
3598 $this->stats_bom[
'nb_toproduce'] = 0;
3599 $this->stats_bom[
'nb_toconsume'] = 0;
3600 $this->stats_bom[
'qty_toproduce'] = 0;
3601 $this->stats_bom[
'qty_toconsume'] = 0;
3603 $sql =
"SELECT COUNT(DISTINCT b.rowid) as nb_toproduce,";
3604 $sql .=
" SUM(b.qty) as qty_toproduce";
3605 $sql .=
" FROM ".$this->db->prefix().
"bom_bom as b";
3606 $sql .=
" INNER JOIN ".$this->db->prefix().
"bom_bomline as bl ON bl.fk_bom = b.rowid";
3608 $sql .=
" b.entity IN (".getEntity(
'bom').
")";
3609 $sql .=
" AND b.fk_product =".((int) $this->
id);
3610 $sql .=
" GROUP BY b.rowid";
3612 $result = $this->db->query($sql);
3614 $obj = $this->db->fetch_object($result);
3615 $this->stats_bom[
'nb_toproduce'] = !empty($obj->nb_toproduce) ? $obj->nb_toproduce : 0;
3616 $this->stats_bom[
'qty_toproduce'] = !empty($obj->qty_toproduce) ?
price2num($obj->qty_toproduce) : 0;
3618 $this->error = $this->db->error();
3622 $sql =
"SELECT COUNT(DISTINCT bl.rowid) as nb_toconsume,";
3623 $sql .=
" SUM(bl.qty) as qty_toconsume";
3624 $sql .=
" FROM ".$this->db->prefix().
"bom_bom as b";
3625 $sql .=
" INNER JOIN ".$this->db->prefix().
"bom_bomline as bl ON bl.fk_bom=b.rowid";
3627 $sql .=
" b.entity IN (".getEntity(
'bom').
")";
3628 $sql .=
" AND bl.fk_product =".((int) $this->
id);
3630 $result = $this->db->query($sql);
3632 $obj = $this->db->fetch_object($result);
3633 $this->stats_bom[
'nb_toconsume'] = !empty($obj->nb_toconsume) ? $obj->nb_toconsume : 0;
3634 $this->stats_bom[
'qty_toconsume'] = !empty($obj->qty_toconsume) ?
price2num($obj->qty_toconsume) : 0;
3636 $this->error = $this->db->error();
3640 if (!empty($error)) {
3644 $parameters = array(
'socid' => $socid);
3645 $reshook = $hookmanager->executeHooks(
'loadStatsCustomerMO', $parameters, $this, $action);
3647 $this->stats_bom = $hookmanager->resArray[
'stats_bom'];
3663 global $user, $hookmanager, $action;
3665 $sql =
"SELECT COUNT(DISTINCT p.fk_soc) as nb_customers, COUNT(DISTINCT p.rowid) as nb,";
3666 $sql .=
" COUNT(pd.rowid) as nb_rows, SUM(pd.qty) as qty";
3667 $sql .=
" FROM ".$this->db->prefix().
"propaldet as pd";
3668 $sql .=
", ".$this->db->prefix().
"propal as p";
3669 $sql .=
", ".$this->db->prefix().
"societe as s";
3670 $sql .=
" WHERE p.rowid = pd.fk_propal";
3671 $sql .=
" AND p.fk_soc = s.rowid";
3672 $sql .=
" AND p.entity IN (".getEntity(
'propal').
")";
3673 $sql .=
" AND pd.fk_product = ".((int) $this->
id);
3674 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
3675 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
3679 $sql .=
" AND p.fk_soc = ".((int) $socid);
3682 $parameters = array(
'socid' => $socid,
'type_element' =>
'propal');
3683 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
3684 $sql .= $hookmanager->resPrint;
3685 $result = $this->db->query($sql);
3687 $obj = $this->db->fetch_object($result);
3688 $this->stats_propale[
'customers'] = (int) $obj->nb_customers;
3689 $this->stats_propale[
'nb'] = (int) $obj->nb;
3690 $this->stats_propale[
'rows'] = (int) $obj->nb_rows;
3691 $this->stats_propale[
'qty'] = $obj->qty ? (float) $obj->qty : 0;
3696 if (is_array($TFather) && !empty($TFather)) {
3697 foreach ($TFather as &$fatherData) {
3698 $pFather =
new Product($this->db);
3699 $pFather->id = (int) $fatherData[
'id'];
3700 $qtyCoef = $fatherData[
'qty'];
3702 if ($fatherData[
'incdec']) {
3703 $pFather->load_stats_propale($socid);
3705 if (!empty($pFather->stats_propale)) {
3706 $this->stats_propale[
'customers'] += $pFather->stats_propale[
'customers'];
3707 $this->stats_propale[
'nb'] += $pFather->stats_propale[
'nb'];
3708 $this->stats_propale[
'rows'] += $pFather->stats_propale[
'rows'];
3709 $this->stats_propale[
'qty'] += $pFather->stats_propale[
'qty'] * $qtyCoef;
3716 $parameters = array(
'socid' => $socid);
3717 $reshook = $hookmanager->executeHooks(
'loadStatsCustomerProposal', $parameters, $this, $action);
3719 $this->stats_propale = $hookmanager->resArray[
'stats_propale'];
3724 $this->error = $this->db->error();
3740 global $user, $hookmanager, $action;
3742 $sql =
"SELECT COUNT(DISTINCT p.fk_soc) as nb_suppliers, COUNT(DISTINCT p.rowid) as nb,";
3743 $sql .=
" COUNT(pd.rowid) as nb_rows, SUM(pd.qty) as qty";
3744 $sql .=
" FROM ".$this->db->prefix().
"supplier_proposaldet as pd";
3745 $sql .=
", ".$this->db->prefix().
"supplier_proposal as p";
3746 $sql .=
", ".$this->db->prefix().
"societe as s";
3747 $sql .=
" WHERE p.rowid = pd.fk_supplier_proposal";
3748 $sql .=
" AND p.fk_soc = s.rowid";
3749 $sql .=
" AND p.entity IN (".getEntity(
'supplier_proposal').
")";
3750 $sql .=
" AND pd.fk_product = ".((int) $this->
id);
3751 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
3752 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
3756 $sql .=
" AND p.fk_soc = ".((int) $socid);
3759 $result = $this->db->query($sql);
3761 $obj = $this->db->fetch_object($result);
3762 $this->stats_proposal_supplier[
'suppliers'] = $obj->nb_suppliers;
3763 $this->stats_proposal_supplier[
'nb'] = $obj->nb;
3764 $this->stats_proposal_supplier[
'rows'] = $obj->nb_rows;
3765 $this->stats_proposal_supplier[
'qty'] = $obj->qty ? $obj->qty : 0;
3767 $parameters = array(
'socid' => $socid);
3768 $reshook = $hookmanager->executeHooks(
'loadStatsSupplierProposal', $parameters, $this, $action);
3770 $this->stats_proposal_supplier = $hookmanager->resArray[
'stats_proposal_supplier'];
3775 $this->error = $this->db->error();
3793 global $user, $hookmanager, $action;
3796 $sql =
"SELECT COUNT(DISTINCT c.fk_soc) as nb_customers, COUNT(DISTINCT c.rowid) as nb,";
3797 $sql .=
" COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty";
3798 $sql .=
" FROM ".$this->db->prefix().
"commandedet as cd";
3799 $sql .=
", ".$this->db->prefix().
"commande as c";
3800 $sql .=
", ".$this->db->prefix().
"societe as s";
3801 $sql .=
" WHERE c.rowid = cd.fk_commande";
3802 $sql .=
" AND c.fk_soc = s.rowid";
3803 $sql .=
" AND c.entity IN (".getEntity($forVirtualStock &&
getDolGlobalString(
'STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ?
'stock' :
'commande').
")";
3804 $sql .=
" AND cd.fk_product = ".((int) $this->
id);
3805 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir') && !$forVirtualStock) {
3806 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
3809 $sql .=
" AND c.fk_soc = ".((int) $socid);
3811 if ($filtrestatut !=
'') {
3812 $sql .=
" AND c.fk_statut IN (".$this->db->sanitize($filtrestatut).
")";
3815 $parameters = array(
'socid' => $socid,
'type_element' =>
'order');
3816 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
3817 $sql .= $hookmanager->resPrint;
3818 $result = $this->db->query($sql);
3820 $obj = $this->db->fetch_object($result);
3821 $this->stats_commande[
'customers'] = (int) $obj->nb_customers;
3822 $this->stats_commande[
'nb'] = (int) $obj->nb;
3823 $this->stats_commande[
'rows'] = (int) $obj->nb_rows;
3824 $this->stats_commande[
'qty'] = $obj->qty ? (float) $obj->qty : 0;
3829 if (is_array($TFather) && !empty($TFather)) {
3830 foreach ($TFather as &$fatherData) {
3831 $pFather =
new Product($this->db);
3832 $pFather->id = $fatherData[
'id'];
3833 $qtyCoef = $fatherData[
'qty'];
3835 if ($fatherData[
'incdec']) {
3836 $pFather->load_stats_commande($socid, $filtrestatut);
3838 $this->stats_commande[
'customers'] += $pFather->stats_commande[
'customers'];
3839 $this->stats_commande[
'nb'] += $pFather->stats_commande[
'nb'];
3840 $this->stats_commande[
'rows'] += $pFather->stats_commande[
'rows'];
3841 $this->stats_commande[
'qty'] += $pFather->stats_commande[
'qty'] * $qtyCoef;
3854 $sql =
"SELECT SUM(".$this->db->ifsql(
'f.type=2',
'-1',
'1').
" * fd.qty) as count FROM ".$this->db->prefix().
"facturedet as fd ";
3855 $sql .=
" JOIN ".$this->db->prefix().
"facture as f ON fd.fk_facture = f.rowid";
3857 $sql .=
" JOIN ".$this->db->prefix().
"element_element as el ON el.fk_target = f.rowid AND el.targettype = 'facture' AND sourcetype = 'commande' ";
3858 $sql .=
" JOIN ".$this->db->prefix().
"commande as c ON el.fk_source = c.rowid";
3859 $sql .=
" WHERE c.fk_statut IN (".$this->db->sanitize($filtrestatut).
") AND c.facture = 0 AND fd.fk_product = ".((int) $this->
id);
3860 $sql .=
" AND EXISTS (SELECT cd.fk_product FROM ".$this->db->prefix().
"commandedet as cd WHERE cd.fk_product = fd.fk_product AND cd.fk_commande = c.rowid)";
3864 $sql .=
"SELECT SUM(".$this->db->ifsql(
'f.type=2',
'-1',
'1').
" * fd.qty) as count FROM ".$this->db->prefix().
"facturedet as fd ";
3865 $sql .=
" JOIN ".$this->db->prefix().
"facture as f ON fd.fk_facture = f.rowid";
3866 $sql .=
" JOIN ".$this->db->prefix().
"element_element as el ON el.fk_source = f.rowid AND el.targettype = 'commande' AND sourcetype = 'facture' ";
3867 $sql .=
" JOIN ".$this->db->prefix().
"commande as c ON el.fk_target = c.rowid";
3868 $sql .=
" WHERE c.fk_statut IN (".$this->db->sanitize($filtrestatut).
") AND c.facture = 0 AND fd.fk_product = ".((int) $this->
id);
3869 $sql .=
" AND EXISTS (SELECT cd.fk_product FROM ".$this->db->prefix().
"commandedet as cd WHERE cd.fk_product = fd.fk_product AND cd.fk_commande = c.rowid)";
3871 $parameters = array(
'socid' => $socid,
'type_element' =>
'order');
3872 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
3873 $sql .= $hookmanager->resPrint;
3874 $resql = $this->db->query($sql);
3876 while ($obj = $this->db->fetch_object($resql)) {
3877 $adeduire += (float) $obj->count;
3881 $this->stats_commande[
'qty'] -= $adeduire;
3884 include_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
3888 $sql =
"SELECT sum(".$this->db->ifsql(
'f.type=2',
'-1',
'1').
" * fd.qty) as count FROM ".$this->db->prefix().
"facturedet as fd ";
3889 $sql .=
" JOIN ".$this->db->prefix().
"facture as f ON fd.fk_facture = f.rowid";
3891 $sql .=
" JOIN ".$this->db->prefix().
"element_element as el ON el.fk_target = f.rowid AND el.targettype = 'facture' AND sourcetype = 'commande' ";
3892 $sql .=
" JOIN ".$this->db->prefix().
"commande as c ON el.fk_source = c.rowid";
3893 $sql .=
" WHERE c.fk_statut IN (".$this->db->sanitize($filtrestatut).
") AND f.fk_statut > ".
Facture::STATUS_DRAFT.
" AND fd.fk_product = ".((int) $this->
id);
3894 $sql .=
" AND EXISTS (SELECT cd.fk_product FROM ".$this->db->prefix().
"commandedet as cd WHERE cd.fk_product = fd.fk_product AND cd.fk_commande = c.rowid)";
3896 $sql .=
" UNION ALL ";
3898 $sql .=
"SELECT sum(".$this->db->ifsql(
'f.type=2',
'-1',
'1').
" * fd.qty) as count FROM ".$this->db->prefix().
"facturedet as fd ";
3899 $sql .=
" JOIN ".$this->db->prefix().
"facture as f ON fd.fk_facture = f.rowid";
3900 $sql .=
" JOIN ".$this->db->prefix().
"element_element as el ON el.fk_source = f.rowid AND el.targettype = 'commande' AND sourcetype = 'facture' ";
3901 $sql .=
" JOIN ".$this->db->prefix().
"commande as c ON el.fk_target = c.rowid";
3902 $sql .=
" WHERE c.fk_statut IN (".$this->db->sanitize($filtrestatut).
") AND f.fk_statut > ".
Facture::STATUS_DRAFT.
" AND fd.fk_product = ".((int) $this->
id);
3903 $sql .=
" AND EXISTS (SELECT cd.fk_product FROM ".$this->db->prefix().
"commandedet as cd WHERE cd.fk_product = fd.fk_product AND cd.fk_commande = c.rowid)";
3905 dol_syslog(__METHOD__.
":: sql $sql", LOG_NOTICE);
3907 $parameters = array(
'socid' => $socid,
'type_element' =>
'order');
3908 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
3909 $sql .= $hookmanager->resPrint;
3910 $resql = $this->db->query($sql);
3912 while ($obj = $this->db->fetch_object($resql)) {
3913 $adeduire += (float) $obj->count;
3916 $this->error = $this->db->error();
3920 $this->stats_commande[
'qty'] -= $adeduire;
3924 $parameters = array(
'socid' => $socid,
'filtrestatut' => $filtrestatut,
'forVirtualStock' => $forVirtualStock);
3925 $reshook = $hookmanager->executeHooks(
'loadStatsCustomerOrder', $parameters, $this, $action);
3927 $this->stats_commande = $hookmanager->resArray[
'stats_commande'];
3931 $this->error = $this->db->error();
3949 global $user, $hookmanager, $action;
3951 $sql =
"SELECT COUNT(DISTINCT c.fk_soc) as nb_suppliers, COUNT(DISTINCT c.rowid) as nb,";
3952 $sql .=
" COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty";
3953 $sql .=
" FROM ".$this->db->prefix().
"commande_fournisseurdet as cd";
3954 $sql .=
", ".$this->db->prefix().
"commande_fournisseur as c";
3955 $sql .=
", ".$this->db->prefix().
"societe as s";
3956 $sql .=
" WHERE c.rowid = cd.fk_commande";
3957 $sql .=
" AND c.fk_soc = s.rowid";
3958 $sql .=
" AND c.entity IN (".getEntity($forVirtualStock &&
getDolGlobalString(
'STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ?
'stock' :
'supplier_order').
")";
3959 $sql .=
" AND cd.fk_product = ".((int) $this->
id);
3960 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir') && !$forVirtualStock) {
3961 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
3964 $sql .=
" AND c.fk_soc = ".((int) $socid);
3966 if ($filtrestatut !=
'') {
3967 $sql .=
" AND c.fk_statut in (".$this->db->sanitize($filtrestatut).
")";
3969 if (!empty($dateofvirtualstock)) {
3970 $sql .=
" AND c.date_livraison <= '".$this->db->idate($dateofvirtualstock).
"'";
3973 $result = $this->db->query($sql);
3975 $obj = $this->db->fetch_object($result);
3976 $this->stats_commande_fournisseur[
'suppliers'] = $obj->nb_suppliers;
3977 $this->stats_commande_fournisseur[
'nb'] = $obj->nb;
3978 $this->stats_commande_fournisseur[
'rows'] = $obj->nb_rows;
3979 $this->stats_commande_fournisseur[
'qty'] = $obj->qty ? $obj->qty : 0;
3981 $parameters = array(
'socid' => $socid,
'filtrestatut' => $filtrestatut,
'forVirtualStock' => $forVirtualStock);
3982 $reshook = $hookmanager->executeHooks(
'loadStatsSupplierOrder', $parameters, $this, $action);
3984 $this->stats_commande_fournisseur = $hookmanager->resArray[
'stats_commande_fournisseur'];
3989 $this->error = $this->db->error().
' sql='.$sql;
4004 public function load_stats_sending($socid = 0, $filtrestatut =
'', $forVirtualStock = 0, $filterShipmentStatus =
'')
4007 global $user, $hookmanager, $action;
4009 $sql =
"SELECT COUNT(DISTINCT e.fk_soc) as nb_customers, COUNT(DISTINCT e.rowid) as nb,";
4010 $sql .=
" COUNT(ed.rowid) as nb_rows, SUM(ed.qty) as qty";
4011 $sql .=
" FROM ".$this->db->prefix().
"expeditiondet as ed";
4012 $sql .=
", ".$this->db->prefix().
"commandedet as cd";
4013 $sql .=
", ".$this->db->prefix().
"commande as c";
4014 $sql .=
", ".$this->db->prefix().
"expedition as e";
4015 $sql .=
", ".$this->db->prefix().
"societe as s";
4016 $sql .=
" WHERE e.rowid = ed.fk_expedition";
4017 $sql .=
" AND c.rowid = cd.fk_commande";
4018 $sql .=
" AND e.fk_soc = s.rowid";
4019 $sql .=
" AND e.entity IN (".getEntity($forVirtualStock &&
getDolGlobalString(
'STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ?
'stock' :
'expedition').
")";
4020 $sql .=
" AND ed.fk_elementdet = cd.rowid";
4021 $sql .=
" AND cd.fk_product = ".((int) $this->
id);
4022 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir') && !$forVirtualStock) {
4023 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = e.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4026 $sql .=
" AND e.fk_soc = ".((int) $socid);
4028 if ($filtrestatut !=
'') {
4029 $sql .=
" AND c.fk_statut IN (".$this->db->sanitize($filtrestatut).
")";
4031 if (!empty($filterShipmentStatus)) {
4032 $sql .=
" AND e.fk_statut IN (".$this->db->sanitize($filterShipmentStatus).
")";
4035 $result = $this->db->query($sql);
4037 $obj = $this->db->fetch_object($result);
4038 $this->stats_expedition[
'customers'] = (int) $obj->nb_customers;
4039 $this->stats_expedition[
'nb'] = (int) $obj->nb;
4040 $this->stats_expedition[
'rows'] = (int) $obj->nb_rows;
4041 $this->stats_expedition[
'qty'] = $obj->qty ? (float) $obj->qty : 0;
4046 if (is_array($TFather) && !empty($TFather)) {
4047 foreach ($TFather as &$fatherData) {
4048 $pFather =
new Product($this->db);
4049 $pFather->id = $fatherData[
'id'];
4050 $qtyCoef = $fatherData[
'qty'];
4052 if ($fatherData[
'incdec']) {
4053 $pFather->load_stats_sending($socid, $filtrestatut, $forVirtualStock);
4055 if (!empty($pFather->stats_expedition)) {
4056 $this->stats_expedition[
'customers'] += $pFather->stats_expedition[
'customers'];
4057 $this->stats_expedition[
'nb'] += $pFather->stats_expedition[
'nb'];
4058 $this->stats_expedition[
'rows'] += $pFather->stats_expedition[
'rows'];
4059 $this->stats_expedition[
'qty'] += $pFather->stats_expedition[
'qty'] * $qtyCoef;
4066 $parameters = array(
'socid' => $socid,
'filtrestatut' => $filtrestatut,
'forVirtualStock' => $forVirtualStock,
'filterShipmentStatus' => $filterShipmentStatus);
4067 $reshook = $hookmanager->executeHooks(
'loadStatsSending', $parameters, $this, $action);
4069 $this->stats_expedition = $hookmanager->resArray[
'stats_expedition'];
4074 $this->error = $this->db->error();
4089 public function load_stats_reception($socid = 0, $filtrestatut =
'', $forVirtualStock = 0, $dateofvirtualstock =
null)
4092 global $user, $hookmanager, $action;
4094 $sql =
"SELECT COUNT(DISTINCT cf.fk_soc) as nb_suppliers, COUNT(DISTINCT cf.rowid) as nb,";
4095 $sql .=
" COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
4096 $sql .=
" FROM ".$this->db->prefix().
"receptiondet_batch as fd";
4097 $sql .=
", ".$this->db->prefix().
"commande_fournisseur as cf";
4098 $sql .=
", ".$this->db->prefix().
"societe as s";
4099 $sql .=
" WHERE cf.rowid = fd.fk_element";
4100 $sql .=
" AND cf.fk_soc = s.rowid";
4101 $sql .=
" AND cf.entity IN (".getEntity($forVirtualStock &&
getDolGlobalString(
'STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ?
'stock' :
'supplier_order').
")";
4102 $sql .=
" AND fd.fk_product = ".((int) $this->
id);
4103 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir') && !$forVirtualStock) {
4104 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = cf.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4107 $sql .=
" AND cf.fk_soc = ".((int) $socid);
4109 if ($filtrestatut !=
'') {
4110 $sql .=
" AND cf.fk_statut IN (".$this->db->sanitize($filtrestatut).
")";
4112 if (!empty($dateofvirtualstock)) {
4113 $sql .=
" AND fd.datec <= '".$this->db->idate($dateofvirtualstock).
"'";
4116 $result = $this->db->query($sql);
4118 $obj = $this->db->fetch_object($result);
4119 $this->stats_reception[
'suppliers'] = $obj->nb_suppliers;
4120 $this->stats_reception[
'nb'] = $obj->nb;
4121 $this->stats_reception[
'rows'] = $obj->nb_rows;
4122 $this->stats_reception[
'qty'] = $obj->qty ? $obj->qty : 0;
4124 $parameters = array(
'socid' => $socid,
'filtrestatut' => $filtrestatut,
'forVirtualStock' => $forVirtualStock);
4125 $reshook = $hookmanager->executeHooks(
'loadStatsReception', $parameters, $this, $action);
4127 $this->stats_reception = $hookmanager->resArray[
'stats_reception'];
4132 $this->error = $this->db->error();
4148 public function load_stats_inproduction($socid = 0, $filtrestatut =
'', $forVirtualStock = 0, $dateofvirtualstock =
null, $warehouseid = 0)
4151 global $user, $hookmanager, $action;
4155 $sql =
"SELECT COUNT(DISTINCT m.fk_soc) as nb_customers, COUNT(DISTINCT m.rowid) as nb,";
4156 $sql .=
" COUNT(mp.rowid) as nb_rows, SUM(mp.qty) as qty, role";
4157 $sql .=
" FROM ".$this->db->prefix().
"mrp_production as mp";
4158 $sql .=
", ".$this->db->prefix().
"mrp_mo as m";
4159 $sql .=
" LEFT JOIN ".$this->db->prefix().
"societe as s ON s.rowid = m.fk_soc";
4160 $sql .=
" WHERE m.rowid = mp.fk_mo";
4161 $sql .=
" AND m.entity IN (".getEntity(($forVirtualStock &&
getDolGlobalString(
'STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE')) ?
'stock' :
'mrp').
")";
4162 $sql .=
" AND mp.fk_product = ".((int) $this->
id);
4163 $sql .=
" AND (mp.disable_stock_change IN (0) OR mp.disable_stock_change IS NULL)";
4164 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir') && !$forVirtualStock) {
4165 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = m.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4168 $sql .=
" AND m.fk_soc = ".((int) $socid);
4170 if ($filtrestatut !=
'') {
4171 $sql .=
" AND m.status IN (".$this->db->sanitize($filtrestatut).
")";
4173 if (!empty($dateofvirtualstock)) {
4174 $sql .=
" AND m.date_valid <= '".$this->db->idate($dateofvirtualstock).
"'";
4176 if (!$serviceStockIsEnabled) {
4177 $sql .=
"AND EXISTS (SELECT p.rowid FROM ".$this->db->prefix().
"product AS p WHERE p.rowid = ".((int) $this->
id).
" AND p.fk_product_type IN (0))";
4179 if (!empty($warehouseid)) {
4180 $sql .=
" AND m.fk_warehouse = ".((int) $warehouseid);
4182 $sql .=
" GROUP BY role";
4185 $this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'] = 0;
4187 $this->stats_mrptoconsume[
'customers'] = 0;
4188 $this->stats_mrptoconsume[
'nb'] = 0;
4189 $this->stats_mrptoconsume[
'rows'] = 0;
4190 $this->stats_mrptoconsume[
'qty'] = 0.0;
4191 $this->stats_mrptoproduce[
'customers'] = 0;
4192 $this->stats_mrptoproduce[
'nb'] = 0;
4193 $this->stats_mrptoproduce[
'rows'] = 0;
4194 $this->stats_mrptoproduce[
'qty'] = 0.0;
4197 $result = $this->db->query($sql);
4199 while ($obj = $this->db->fetch_object($result)) {
4200 if ($obj->role ==
'toconsume' && empty($warehouseid)) {
4201 $this->stats_mrptoconsume[
'customers'] += (int) $obj->nb_customers;
4202 $this->stats_mrptoconsume[
'nb'] += (int) $obj->nb;
4203 $this->stats_mrptoconsume[
'rows'] += (int) $obj->nb_rows;
4204 $this->stats_mrptoconsume[
'qty'] += ($obj->qty ? (float) $obj->qty : 0.0);
4206 if ($obj->role ==
'consumed' && empty($warehouseid)) {
4210 $this->stats_mrptoconsume[
'qty'] -= ($obj->qty ? (float) $obj->qty : 0.0);
4212 if ($obj->role ==
'toproduce') {
4214 $this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'] += ($obj->qty ? (float) $obj->qty : 0.0);
4216 $this->stats_mrptoproduce[
'customers'] += (int) $obj->nb_customers;
4217 $this->stats_mrptoproduce[
'nb'] += (int) $obj->nb;
4218 $this->stats_mrptoproduce[
'rows'] += (int) $obj->nb_rows;
4219 $this->stats_mrptoproduce[
'qty'] += ($obj->qty ? (float) $obj->qty : 0.0);
4222 if ($obj->role ==
'produced') {
4227 $this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'] -= ($obj->qty ? $obj->qty : 0);
4229 $this->stats_mrptoproduce[
'qty'] -= ($obj->qty ? $obj->qty : 0);
4236 if ($this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'] < 0) {
4237 $this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'] = 0;
4240 if ($this->stats_mrptoconsume[
'qty'] < 0) {
4241 $this->stats_mrptoconsume[
'qty'] = 0;
4243 if ($this->stats_mrptoproduce[
'qty'] < 0) {
4244 $this->stats_mrptoproduce[
'qty'] = 0;
4248 $parameters = array(
'socid' => $socid,
'filtrestatut' => $filtrestatut,
'forVirtualStock' => $forVirtualStock);
4249 $reshook = $hookmanager->executeHooks(
'loadStatsInProduction', $parameters, $this, $action);
4251 $this->stats_mrptoproduce = $hookmanager->resArray[
'stats_mrptoproduce'];
4256 $this->error = $this->db->error();
4271 global $user, $hookmanager, $action;
4273 $sql =
"SELECT COUNT(DISTINCT c.fk_soc) as nb_customers, COUNT(DISTINCT c.rowid) as nb,";
4274 $sql .=
" COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty";
4275 $sql .=
" FROM ".$this->db->prefix().
"contratdet as cd";
4276 $sql .=
", ".$this->db->prefix().
"contrat as c";
4277 $sql .=
", ".$this->db->prefix().
"societe as s";
4278 $sql .=
" WHERE c.rowid = cd.fk_contrat";
4279 $sql .=
" AND c.fk_soc = s.rowid";
4280 $sql .=
" AND c.entity IN (".getEntity(
'contract').
")";
4281 $sql .=
" AND cd.fk_product = ".((int) $this->
id);
4282 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
4283 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4287 $sql .=
" AND c.fk_soc = ".((int) $socid);
4290 $result = $this->db->query($sql);
4292 $obj = $this->db->fetch_object($result);
4293 $this->stats_contrat[
'customers'] = (int) $obj->nb_customers;
4294 $this->stats_contrat[
'nb'] = (int) $obj->nb;
4295 $this->stats_contrat[
'rows'] = (int) $obj->nb_rows;
4296 $this->stats_contrat[
'qty'] = $obj->qty ? (float) $obj->qty : 0;
4301 if (is_array($TFather) && !empty($TFather)) {
4302 foreach ($TFather as &$fatherData) {
4303 $pFather =
new Product($this->db);
4304 $pFather->id = $fatherData[
'id'];
4305 $qtyCoef = $fatherData[
'qty'];
4307 if ($fatherData[
'incdec']) {
4308 $pFather->load_stats_contrat($socid);
4310 if (!empty($pFather->stats_contrat)) {
4311 $this->stats_contrat[
'customers'] += $pFather->stats_contrat[
'customers'];
4312 $this->stats_contrat[
'nb'] += $pFather->stats_contrat[
'nb'];
4313 $this->stats_contrat[
'rows'] += $pFather->stats_contrat[
'rows'];
4314 $this->stats_contrat[
'qty'] += $pFather->stats_contrat[
'qty'] * $qtyCoef;
4321 $parameters = array(
'socid' => $socid);
4322 $reshook = $hookmanager->executeHooks(
'loadStatsContract', $parameters, $this, $action);
4324 $this->stats_contrat = $hookmanager->resArray[
'stats_contrat'];
4329 $this->error = $this->db->error().
' sql='.$sql;
4344 global $user, $hookmanager, $action;
4346 $sql =
"SELECT COUNT(DISTINCT f.fk_soc) as nb_customers, COUNT(DISTINCT f.rowid) as nb,";
4347 $sql .=
" COUNT(fd.rowid) as nb_rows, SUM(".$this->db->ifsql(
'f.type != 2',
'fd.qty',
'fd.qty * -1').
") as qty";
4348 $sql .=
" FROM ".$this->db->prefix().
"facturedet as fd";
4349 $sql .=
", ".$this->db->prefix().
"facture as f";
4350 $sql .=
", ".$this->db->prefix().
"societe as s";
4351 $sql .=
" WHERE f.rowid = fd.fk_facture";
4352 $sql .=
" AND f.fk_soc = s.rowid";
4353 $sql .=
" AND f.entity IN (".getEntity(
'invoice').
")";
4354 $sql .=
" AND fd.fk_product = ".((int) $this->
id);
4355 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
4356 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4360 $sql .=
" AND f.fk_soc = ".((int) $socid);
4363 $result = $this->db->query($sql);
4365 $obj = $this->db->fetch_object($result);
4366 $this->stats_facture[
'customers'] = (int) $obj->nb_customers;
4367 $this->stats_facture[
'nb'] = (int) $obj->nb;
4368 $this->stats_facture[
'rows'] = (int) $obj->nb_rows;
4369 $this->stats_facture[
'qty'] = $obj->qty ? (float) $obj->qty : 0;
4374 if (is_array($TFather) && !empty($TFather)) {
4375 foreach ($TFather as &$fatherData) {
4376 $pFather =
new Product($this->db);
4377 $pFather->id = $fatherData[
'id'];
4378 $qtyCoef = $fatherData[
'qty'];
4380 if ($fatherData[
'incdec']) {
4381 $pFather->load_stats_facture($socid);
4383 if (!empty($pFather->stats_facture)) {
4384 $this->stats_facture[
'customers'] += $pFather->stats_facture[
'customers'];
4385 $this->stats_facture[
'nb'] += $pFather->stats_facture[
'nb'];
4386 $this->stats_facture[
'rows'] += $pFather->stats_facture[
'rows'];
4387 $this->stats_facture[
'qty'] += $pFather->stats_facture[
'qty'] * $qtyCoef;
4394 $parameters = array(
'socid' => $socid);
4395 $reshook = $hookmanager->executeHooks(
'loadStatsCustomerInvoice', $parameters, $this, $action);
4397 $this->stats_facture = $hookmanager->resArray[
'stats_facture'];
4402 $this->error = $this->db->error();
4418 global $user, $hookmanager, $action;
4420 $sql =
"SELECT COUNT(DISTINCT f.fk_soc) as nb_customers, COUNT(DISTINCT f.rowid) as nb,";
4421 $sql .=
" COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
4422 $sql .=
" FROM ".MAIN_DB_PREFIX.
"facturedet_rec as fd";
4423 $sql .=
", ".MAIN_DB_PREFIX.
"facture_rec as f";
4424 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
4425 $sql .=
" WHERE f.rowid = fd.fk_facture";
4426 $sql .=
" AND f.fk_soc = s.rowid";
4427 $sql .=
" AND f.entity IN (".getEntity(
'invoice').
")";
4428 $sql .=
" AND fd.fk_product = ".((int) $this->
id);
4429 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
4430 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4434 $sql .=
" AND f.fk_soc = ".((int) $socid);
4437 $result = $this->db->query($sql);
4439 $obj = $this->db->fetch_object($result);
4440 $this->stats_facturerec[
'customers'] = (int) $obj->nb_customers;
4441 $this->stats_facturerec[
'nb'] = (int) $obj->nb;
4442 $this->stats_facturerec[
'rows'] = (int) $obj->nb_rows;
4443 $this->stats_facturerec[
'qty'] = $obj->qty ? (float) $obj->qty : 0.0;
4448 if (is_array($TFather) && !empty($TFather)) {
4449 foreach ($TFather as &$fatherData) {
4450 $pFather =
new Product($this->db);
4451 $pFather->id = $fatherData[
'id'];
4452 $qtyCoef = $fatherData[
'qty'];
4454 if ($fatherData[
'incdec']) {
4455 $pFather->load_stats_facture($socid);
4457 $this->stats_facturerec[
'customers'] += $pFather->stats_facturerec[
'customers'];
4458 $this->stats_facturerec[
'nb'] += $pFather->stats_facturerec[
'nb'];
4459 $this->stats_facturerec[
'rows'] += $pFather->stats_facturerec[
'rows'];
4460 $this->stats_facturerec[
'qty'] += $pFather->stats_facturerec[
'qty'] * $qtyCoef;
4466 $parameters = array(
'socid' => $socid);
4467 $reshook = $hookmanager->executeHooks(
'loadStatsCustomerInvoiceRec', $parameters, $this, $action);
4469 $this->stats_facturerec = $hookmanager->resArray[
'stats_facturerec'];
4474 $this->error = $this->db->error();
4489 global $user, $hookmanager, $action;
4491 $sql =
"SELECT COUNT(DISTINCT f.fk_soc) as nb_suppliers, COUNT(DISTINCT f.rowid) as nb,";
4492 $sql .=
" COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
4493 $sql .=
" FROM ".$this->db->prefix().
"facture_fourn_det as fd";
4494 $sql .=
", ".$this->db->prefix().
"facture_fourn as f";
4495 $sql .=
", ".$this->db->prefix().
"societe as s";
4496 $sql .=
" WHERE f.rowid = fd.fk_facture_fourn";
4497 $sql .=
" AND f.fk_soc = s.rowid";
4498 $sql .=
" AND f.entity IN (".getEntity(
'facture_fourn').
")";
4499 $sql .=
" AND fd.fk_product = ".((int) $this->
id);
4500 if (empty($user->fk_soc) && !$user->hasRight(
'societe',
'client',
'voir')) {
4501 $sql .=
" AND EXISTS (SELECT 1 FROM ".$this->db->prefix().
"societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
4505 $sql .=
" AND f.fk_soc = ".((int) $socid);
4508 $result = $this->db->query($sql);
4510 $obj = $this->db->fetch_object($result);
4511 $this->stats_facture_fournisseur[
'suppliers'] = (int) $obj->nb_suppliers;
4512 $this->stats_facture_fournisseur[
'nb'] = (int) $obj->nb;
4513 $this->stats_facture_fournisseur[
'rows'] = (int) $obj->nb_rows;
4514 $this->stats_facture_fournisseur[
'qty'] = $obj->qty ? (float) $obj->qty : 0.0;
4516 $parameters = array(
'socid' => $socid);
4517 $reshook = $hookmanager->executeHooks(
'loadStatsSupplierInvoice', $parameters, $this, $action);
4519 $this->stats_facture_fournisseur = $hookmanager->resArray[
'stats_facture_fournisseur'];
4524 $this->error = $this->db->error();
4539 global $user, $hookmanager, $action;
4541 $sql =
"SELECT COUNT(DISTINCT f.fk_soc) as nb_suppliers, COUNT(DISTINCT f.rowid) as nb,";
4542 $sql .=
" COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
4543 $sql .=
" FROM ".MAIN_DB_PREFIX.
"facture_fourn_det_rec as fd";
4544 $sql .=
", ".MAIN_DB_PREFIX.
"facture_fourn_rec as f";
4545 $sql .=
", ".MAIN_DB_PREFIX.
"societe as s";
4546 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4547 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
4549 $sql .=
" WHERE f.rowid = fd.fk_facture";
4550 $sql .=
" AND f.fk_soc = s.rowid";
4551 $sql .=
" AND f.entity IN (".getEntity(
'invoice').
")";
4552 $sql .=
" AND fd.fk_product = ".((int) $this->
id);
4553 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4554 $sql .=
" AND f.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4558 $sql .=
" AND f.fk_soc = ".((int) $socid);
4561 $result = $this->db->query($sql);
4563 $obj = $this->db->fetch_object($result);
4564 $this->stats_facturefournrec[
'suppliers'] = (int) $obj->nb_suppliers;
4565 $this->stats_facturefournrec[
'nb'] = (int) $obj->nb;
4566 $this->stats_facturefournrec[
'rows'] = (int) $obj->nb_rows;
4567 $this->stats_facturefournrec[
'qty'] = $obj->qty ? (float) $obj->qty : 0.0;
4569 $parameters = array(
'socid' => $socid);
4570 $reshook = $hookmanager->executeHooks(
'loadStatsSupplierInvoiceRec', $parameters, $this, $action);
4572 $this->stats_facturefournrec = $hookmanager->resArray[
'stats_facturefournrec'];
4577 $this->error = $this->db->error();
4596 $resql = $this->db->query($sql);
4598 $num = $this->db->num_rows($resql);
4601 $arr = $this->db->fetch_array($resql);
4602 if (is_array($arr)) {
4603 $keyfortab = (
string) $arr[1];
4605 $keyfortab = substr($keyfortab, -2);
4608 if ($mode ==
'byunit') {
4609 $tab[$keyfortab] = (empty($tab[$keyfortab]) ? 0 : $tab[$keyfortab]) + $arr[0];
4610 } elseif ($mode ==
'bynumber') {
4611 $tab[$keyfortab] = (empty($tab[$keyfortab]) ? 0 : $tab[$keyfortab]) + $arr[2];
4612 } elseif ($mode ==
'byamount') {
4613 $tab[$keyfortab] = (empty($tab[$keyfortab]) ? 0 : $tab[$keyfortab]) + $arr[2];
4622 $this->error = $this->db->error().
' sql='.$sql;
4629 } elseif ($year == -1) {
4638 for ($j = 0; $j < 12; $j++) {
4640 $idx = ucfirst(
dol_trunc(
dol_print_date(
dol_mktime(12, 0, 0, $month, 1, 1970),
"%b"), 1,
'right',
'UTF-8', 1));
4643 $result[$j] = array($idx, isset($tab[$year.$month]) ? $tab[$year.$month] : 0);
4646 $month =
"0".($month - 1);
4648 $month = substr($month, 1);
4658 return array_reverse($result);
4673 public function get_nb_vente($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter =
'')
4678 $sql =
"SELECT sum(d.qty) as qty, date_format(f.datef, '%Y%m')";
4679 if ($mode ==
'bynumber') {
4680 $sql .=
", count(DISTINCT f.rowid)";
4682 $sql .=
", sum(d.total_ht) as total_ht";
4683 $sql .=
" FROM ".$this->db->prefix().
"facturedet as d, ".$this->db->prefix().
"facture as f, ".$this->db->prefix().
"societe as s";
4684 if ($filteronproducttype >= 0) {
4685 $sql .=
", ".$this->db->prefix().
"product as p";
4687 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4688 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
4690 $sql .=
" WHERE f.rowid = d.fk_facture";
4691 if ($this->
id > 0) {
4692 $sql .=
" AND d.fk_product = ".((int) $this->
id);
4694 $sql .=
" AND d.fk_product > 0";
4696 if ($filteronproducttype >= 0) {
4697 $sql .=
" AND p.rowid = d.fk_product AND p.fk_product_type = ".((int) $filteronproducttype);
4699 $sql .=
" AND f.fk_soc = s.rowid";
4700 $sql .=
" AND f.entity IN (".getEntity(
'invoice').
")";
4701 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4702 $sql .=
" AND f.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4705 $sql .=
" AND f.fk_soc = ".((int) $socid);
4707 $sql .= $morefilter;
4708 $sql .=
" GROUP BY date_format(f.datef,'%Y%m')";
4709 $sql .=
" ORDER BY date_format(f.datef,'%Y%m') DESC";
4711 return $this->
_get_stats($sql, $mode, $year);
4726 public function get_nb_achat($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter =
'')
4731 $sql =
"SELECT sum(d.qty) as qty, date_format(f.datef, '%Y%m')";
4732 if ($mode ==
'bynumber') {
4733 $sql .=
", count(DISTINCT f.rowid)";
4735 $sql .=
", sum(d.total_ht) as total_ht";
4736 $sql .=
" FROM ".$this->db->prefix().
"facture_fourn_det as d, ".$this->db->prefix().
"facture_fourn as f, ".$this->db->prefix().
"societe as s";
4737 if ($filteronproducttype >= 0) {
4738 $sql .=
", ".$this->db->prefix().
"product as p";
4740 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4741 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
4743 $sql .=
" WHERE f.rowid = d.fk_facture_fourn";
4744 if ($this->
id > 0) {
4745 $sql .=
" AND d.fk_product = ".((int) $this->
id);
4747 $sql .=
" AND d.fk_product > 0";
4749 if ($filteronproducttype >= 0) {
4750 $sql .=
" AND p.rowid = d.fk_product AND p.fk_product_type = ".((int) $filteronproducttype);
4752 $sql .=
" AND f.fk_soc = s.rowid";
4753 $sql .=
" AND f.entity IN (".getEntity(
'facture_fourn').
")";
4754 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4755 $sql .=
" AND f.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4758 $sql .=
" AND f.fk_soc = ".((int) $socid);
4760 $sql .= $morefilter;
4761 $sql .=
" GROUP BY date_format(f.datef,'%Y%m')";
4762 $sql .=
" ORDER BY date_format(f.datef,'%Y%m') DESC";
4764 return $this->
_get_stats($sql, $mode, $year);
4778 public function get_nb_propal($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter =
'')
4781 global $user, $hookmanager;
4783 $sql =
"SELECT sum(d.qty) as qty, date_format(p.datep, '%Y%m')";
4784 if ($mode ==
'bynumber') {
4785 $sql .=
", count(DISTINCT p.rowid)";
4787 $sql .=
", sum(d.total_ht) as total_ht";
4788 $sql .=
" FROM ".$this->db->prefix().
"propaldet as d, ".$this->db->prefix().
"propal as p, ".$this->db->prefix().
"societe as s";
4789 if ($filteronproducttype >= 0) {
4790 $sql .=
", ".$this->db->prefix().
"product as prod";
4792 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4793 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
4795 $sql .=
" WHERE p.rowid = d.fk_propal";
4796 if ($this->
id > 0) {
4797 $sql .=
" AND d.fk_product = ".((int) $this->
id);
4799 $sql .=
" AND d.fk_product > 0";
4801 if ($filteronproducttype >= 0) {
4802 $sql .=
" AND prod.rowid = d.fk_product AND prod.fk_product_type = ".((int) $filteronproducttype);
4804 $sql .=
" AND p.fk_soc = s.rowid";
4805 $sql .=
" AND p.entity IN (".getEntity(
'propal').
")";
4806 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4807 $sql .=
" AND p.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4810 $sql .=
" AND p.fk_soc = ".((int) $socid);
4812 $sql .= $morefilter;
4813 $parameters = array(
'socid' => $user->socid);
4814 $hookmanager->executeHooks(
'productGetNbPropal', $parameters, $this);
4815 $sql .= $hookmanager->resPrint;
4816 $sql .=
" GROUP BY date_format(p.datep,'%Y%m')";
4817 $sql .=
" ORDER BY date_format(p.datep,'%Y%m') DESC";
4818 return $this->
_get_stats($sql, $mode, $year);
4837 $sql =
"SELECT sum(d.qty) as qty, date_format(p.date_valid, '%Y%m')";
4838 if ($mode ==
'bynumber') {
4839 $sql .=
", count(DISTINCT p.rowid)";
4841 $sql .=
", sum(d.total_ht) as total_ht";
4842 $sql .=
" FROM ".$this->db->prefix().
"supplier_proposaldet as d, ".$this->db->prefix().
"supplier_proposal as p, ".$this->db->prefix().
"societe as s";
4843 if ($filteronproducttype >= 0) {
4844 $sql .=
", ".$this->db->prefix().
"product as prod";
4846 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4847 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
4849 $sql .=
" WHERE p.rowid = d.fk_supplier_proposal";
4850 if ($this->
id > 0) {
4851 $sql .=
" AND d.fk_product = ".((int) $this->
id);
4853 $sql .=
" AND d.fk_product > 0";
4855 if ($filteronproducttype >= 0) {
4856 $sql .=
" AND prod.rowid = d.fk_product AND prod.fk_product_type = ".((int) $filteronproducttype);
4858 $sql .=
" AND p.fk_soc = s.rowid";
4859 $sql .=
" AND p.entity IN (".getEntity(
'supplier_proposal').
")";
4860 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4861 $sql .=
" AND p.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4864 $sql .=
" AND p.fk_soc = ".((int) $socid);
4866 $sql .= $morefilter;
4867 $sql .=
" GROUP BY date_format(p.date_valid,'%Y%m')";
4868 $sql .=
" ORDER BY date_format(p.date_valid,'%Y%m') DESC";
4870 return $this->
_get_stats($sql, $mode, $year);
4884 public function get_nb_order($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter =
'')
4887 global $user, $hookmanager;
4889 $sql =
"SELECT sum(d.qty) as qty, date_format(c.date_commande, '%Y%m')";
4890 if ($mode ==
'bynumber') {
4891 $sql .=
", count(DISTINCT c.rowid)";
4893 $sql .=
", sum(d.total_ht) as total_ht";
4894 $sql .=
" FROM ".$this->db->prefix().
"commandedet as d, ".$this->db->prefix().
"commande as c, ".$this->db->prefix().
"societe as s";
4895 if ($filteronproducttype >= 0) {
4896 $sql .=
", ".$this->db->prefix().
"product as p";
4898 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4899 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
4901 $sql .=
" WHERE c.rowid = d.fk_commande";
4902 if ($this->
id > 0) {
4903 $sql .=
" AND d.fk_product = ".((int) $this->
id);
4905 $sql .=
" AND d.fk_product > 0";
4907 if ($filteronproducttype >= 0) {
4908 $sql .=
" AND p.rowid = d.fk_product AND p.fk_product_type = ".((int) $filteronproducttype);
4910 $sql .=
" AND c.fk_soc = s.rowid";
4911 $sql .=
" AND c.entity IN (".getEntity(
'commande').
")";
4912 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4913 $sql .=
" AND c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4916 $sql .=
" AND c.fk_soc = ".((int) $socid);
4918 $sql .= $morefilter;
4919 $parameters = array(
'socid' => $user->socid);
4920 $hookmanager->executeHooks(
'productGetNbOrder', $parameters, $this);
4921 $sql .= $hookmanager->resPrint;
4922 $sql .=
" GROUP BY date_format(c.date_commande,'%Y%m')";
4923 $sql .=
" ORDER BY date_format(c.date_commande,'%Y%m') DESC";
4925 return $this->
_get_stats($sql, $mode, $year);
4944 $sql =
"SELECT sum(d.qty) as qty, date_format(c.date_commande, '%Y%m')";
4945 if ($mode ==
'bynumber') {
4946 $sql .=
", count(DISTINCT c.rowid)";
4948 $sql .=
", sum(d.total_ht) as total_ht";
4949 $sql .=
" FROM ".$this->db->prefix().
"commande_fournisseurdet as d, ".$this->db->prefix().
"commande_fournisseur as c, ".$this->db->prefix().
"societe as s";
4950 if ($filteronproducttype >= 0) {
4951 $sql .=
", ".$this->db->prefix().
"product as p";
4953 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4954 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
4956 $sql .=
" WHERE c.rowid = d.fk_commande";
4957 if ($this->
id > 0) {
4958 $sql .=
" AND d.fk_product = ".((int) $this->
id);
4960 $sql .=
" AND d.fk_product > 0";
4962 if ($filteronproducttype >= 0) {
4963 $sql .=
" AND p.rowid = d.fk_product AND p.fk_product_type = ".((int) $filteronproducttype);
4965 $sql .=
" AND c.fk_soc = s.rowid";
4966 $sql .=
" AND c.entity IN (".getEntity(
'supplier_order').
")";
4967 if (!$user->hasRight(
'societe',
'client',
'voir')) {
4968 $sql .=
" AND c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
4971 $sql .=
" AND c.fk_soc = ".((int) $socid);
4973 $sql .= $morefilter;
4974 $sql .=
" GROUP BY date_format(c.date_commande,'%Y%m')";
4975 $sql .=
" ORDER BY date_format(c.date_commande,'%Y%m') DESC";
4977 return $this->
_get_stats($sql, $mode, $year);
4991 public function get_nb_contract($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter =
'')
4996 $sql =
"SELECT sum(d.qty) as qty, date_format(c.date_contrat, '%Y%m')";
4997 if ($mode ==
'bynumber') {
4998 $sql .=
", count(DISTINCT c.rowid)";
5000 $sql .=
", sum(d.total_ht) as total_ht";
5001 $sql .=
" FROM ".$this->db->prefix().
"contratdet as d, ".$this->db->prefix().
"contrat as c, ".$this->db->prefix().
"societe as s";
5002 if ($filteronproducttype >= 0) {
5003 $sql .=
", ".$this->db->prefix().
"product as p";
5005 if (!$user->hasRight(
'societe',
'client',
'voir')) {
5006 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
5008 $sql .=
" WHERE c.entity IN (".getEntity(
'contract').
")";
5009 $sql .=
" AND c.rowid = d.fk_contrat";
5011 if ($this->
id > 0) {
5012 $sql .=
" AND d.fk_product = ".((int) $this->
id);
5014 $sql .=
" AND d.fk_product > 0";
5016 if ($filteronproducttype >= 0) {
5017 $sql .=
" AND p.rowid = d.fk_product AND p.fk_product_type = ".((int) $filteronproducttype);
5019 $sql .=
" AND c.fk_soc = s.rowid";
5021 if (!$user->hasRight(
'societe',
'client',
'voir')) {
5022 $sql .=
" AND c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
5025 $sql .=
" AND c.fk_soc = ".((int) $socid);
5027 $sql .= $morefilter;
5028 $sql .=
" GROUP BY date_format(c.date_contrat,'%Y%m')";
5029 $sql .=
" ORDER BY date_format(c.date_contrat,'%Y%m') DESC";
5031 return $this->
_get_stats($sql, $mode, $year);
5045 public function get_nb_mos($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter =
'')
5050 $sql =
"SELECT sum(d.qty), date_format(d.date_valid, '%Y%m')";
5051 if ($mode ==
'bynumber') {
5052 $sql .=
", count(DISTINCT d.rowid)";
5054 $sql .=
" FROM ".$this->db->prefix().
"mrp_mo as d LEFT JOIN ".$this->db->prefix().
"societe as s ON d.fk_soc = s.rowid";
5055 if ($filteronproducttype >= 0) {
5056 $sql .=
", ".$this->db->prefix().
"product as p";
5058 if (!$user->hasRight(
'societe',
'client',
'voir')) {
5059 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
5062 $sql .=
" WHERE d.entity IN (".getEntity(
'mo').
")";
5063 $sql .=
" AND d.status > 0";
5065 if ($this->
id > 0) {
5066 $sql .=
" AND d.fk_product = ".((int) $this->
id);
5068 $sql .=
" AND d.fk_product > 0";
5070 if ($filteronproducttype >= 0) {
5071 $sql .=
" AND p.rowid = d.fk_product AND p.fk_product_type = ".((int) $filteronproducttype);
5074 if (!$user->hasRight(
'societe',
'client',
'voir')) {
5075 $sql .=
" AND d.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
5078 $sql .=
" AND d.fk_soc = ".((int) $socid);
5080 $sql .= $morefilter;
5081 $sql .=
" GROUP BY date_format(d.date_valid,'%Y%m')";
5082 $sql .=
" ORDER BY date_format(d.date_valid,'%Y%m') DESC";
5084 return $this->
_get_stats($sql, $mode, $year);
5104 if (!is_numeric($id_pere)) {
5107 if (!is_numeric($id_fils)) {
5110 if (!is_numeric($incdec)) {
5120 $sql =
"SELECT fk_product_pere from ".$this->db->prefix().
"product_association";
5121 $sql .=
" WHERE fk_product_pere = ".((int) $id_fils).
" AND fk_product_fils = ".((int) $id_pere);
5122 if (!$this->db->query($sql)) {
5127 $sql =
"SELECT MAX(rang) as max_rank FROM ".$this->db->prefix().
"product_association";
5128 $sql .=
" WHERE fk_product_pere = ".((int) $id_pere);
5129 $resql = $this->db->query($sql);
5131 $obj = $this->db->fetch_object($resql);
5132 $rank = $obj->max_rank + 1;
5134 $sql =
"INSERT INTO ".$this->db->prefix().
"product_association(fk_product_pere,fk_product_fils,qty,incdec,rang)";
5135 $sql .=
" VALUES (".((int) $id_pere).
", ".((int) $id_fils).
", ".
price2num($qty,
'MS').
", ".((int) $incdec).
", ".((int) $rank).
")";
5136 if (! $this->db->query($sql)) {
5142 $result = $this->call_trigger(
'PRODUCT_SUBPRODUCT_ADD', $user);
5144 $this->error = $this->db->lasterror();
5145 dol_syslog(get_class($this).
'::addSubproduct error='.$this->error, LOG_ERR);
5177 if (!is_numeric($id_pere)) {
5180 if (!is_numeric($id_fils)) {
5183 if (!is_numeric($incdec)) {
5186 if (!is_numeric($qty)) {
5190 $sql =
'UPDATE '.$this->db->prefix().
'product_association SET ';
5191 $sql .=
'qty = '.price2num($qty,
'MS');
5192 $sql .=
',incdec = '.((int) $incdec);
5193 $sql .=
' WHERE fk_product_pere = '.((int) $id_pere).
' AND fk_product_fils = '.((int) $id_fils);
5195 if (!$this->db->query($sql)) {
5201 $result = $this->call_trigger(
'PRODUCT_SUBPRODUCT_UPDATE', $user);
5203 $this->error = $this->db->lasterror();
5204 dol_syslog(get_class($this).
'::updateSubproduct error='.$this->error, LOG_ERR);
5228 if (!is_numeric($fk_parent)) {
5231 if (!is_numeric($fk_child)) {
5235 $sql =
"DELETE FROM ".$this->db->prefix().
"product_association";
5236 $sql .=
" WHERE fk_product_pere = ".((int) $fk_parent);
5237 $sql .=
" AND fk_product_fils = ".((int) $fk_child);
5239 dol_syslog(get_class($this).
'::del_sousproduit', LOG_DEBUG);
5240 if (!$this->db->query($sql)) {
5246 $sqlrank =
"SELECT rowid, rang FROM ".$this->db->prefix().
"product_association";
5247 $sqlrank .=
" WHERE fk_product_pere = ".((int) $fk_parent);
5248 $sqlrank .=
" ORDER BY rang";
5249 $resqlrank = $this->db->query($sqlrank);
5252 while ($objrank = $this->db->fetch_object($resqlrank)) {
5254 $sql =
"UPDATE ".$this->db->prefix().
"product_association";
5255 $sql .=
" SET rang = ".((int) $cpt);
5256 $sql .=
" WHERE rowid = ".((int) $objrank->rowid);
5257 if (! $this->db->query($sql)) {
5266 $result = $this->call_trigger(
'PRODUCT_SUBPRODUCT_DELETE', $user);
5268 $this->error = $this->db->lasterror();
5269 dol_syslog(get_class($this).
'::delSubproduct error='.$this->error, LOG_ERR);
5289 $sql =
"SELECT fk_product_pere, qty, incdec";
5290 $sql .=
" FROM ".$this->db->prefix().
"product_association";
5291 $sql .=
" WHERE fk_product_pere = ".((int) $fk_parent);
5292 $sql .=
" AND fk_product_fils = ".((int) $fk_child);
5294 $result = $this->db->query($sql);
5296 $num = $this->db->num_rows($result);
5299 $obj = $this->db->fetch_object($result);
5301 $this->is_sousproduit_qty = $obj->qty;
5302 $this->is_sousproduit_incdec = $obj->incdec;
5333 dol_syslog(get_class($this).
"::add_fournisseur id_fourn = ".$id_fourn.
" ref_fourn=".$ref_fourn.
" quantity=".$quantity, LOG_DEBUG);
5340 $sql =
"SELECT rowid, fk_product";
5341 $sql .=
" FROM ".$this->db->prefix().
"product_fournisseur_price";
5342 $sql .=
" WHERE fk_soc = ".((int) $id_fourn);
5343 $sql .=
" AND ref_fourn = '".$this->db->escape($ref_fourn).
"'";
5344 $sql .=
" AND fk_product <> ".((int) $this->
id);
5345 $sql .=
" AND entity IN (".getEntity(
'productsupplierprice').
")";
5347 $resql = $this->db->query($sql);
5349 $obj = $this->db->fetch_object($resql);
5352 $this->product_id_already_linked = $obj->fk_product;
5355 $this->db->free($resql);
5359 $sql =
"SELECT rowid";
5360 $sql .=
" FROM ".$this->db->prefix().
"product_fournisseur_price";
5361 $sql .=
" WHERE fk_soc = ".((int) $id_fourn);
5363 $sql .=
" AND ref_fourn = '".$this->db->escape($ref_fourn).
"'";
5365 $sql .=
" AND (ref_fourn = '' OR ref_fourn IS NULL)";
5367 $sql .=
" AND quantity = ".((float) $quantity);
5368 $sql .=
" AND fk_product = ".((int) $this->
id);
5369 $sql .=
" AND entity IN (".getEntity(
'productsupplierprice').
")";
5371 $resql = $this->db->query($sql);
5373 $obj = $this->db->fetch_object($resql);
5377 $sql =
"INSERT INTO ".$this->db->prefix().
"product_fournisseur_price(";
5380 $sql .=
", fk_product";
5382 $sql .=
", ref_fourn";
5383 $sql .=
", quantity";
5384 $sql .=
", fk_user";
5386 $sql .=
") VALUES (";
5387 $sql .=
"'".$this->db->idate($now).
"'";
5388 $sql .=
", ".((int)
$conf->entity);
5389 $sql .=
", ".((int) $this->
id);
5390 $sql .=
", ".((int) $id_fourn);
5391 $sql .=
", '".$this->db->escape($ref_fourn).
"'";
5392 $sql .=
", ".((float) $quantity);
5393 $sql .=
", ".((int) $user->id);
5397 if ($this->db->query($sql)) {
5398 $this->product_fourn_price_id = $this->db->last_insert_id($this->db->prefix().
"product_fournisseur_price");
5401 $this->error = $this->db->lasterror();
5406 $this->product_fourn_price_id = $obj->rowid;
5410 $this->error = $this->db->lasterror();
5429 $sql =
"SELECT DISTINCT p.fk_soc";
5430 $sql .=
" FROM ".$this->db->prefix().
"product_fournisseur_price as p";
5431 $sql .=
" WHERE p.fk_product = ".((int) $this->
id);
5432 $sql .=
" AND p.entity = ".((int)
$conf->entity);
5434 $result = $this->db->query($sql);
5436 $num = $this->db->num_rows($result);
5439 $obj = $this->db->fetch_object($result);
5440 $list[$i] = $obj->fk_soc;
5466 $sql =
"INSERT INTO ".$this->db->prefix().
"product_price (";
5468 $sql .=
", fk_product";
5469 $sql .=
", date_price";
5470 $sql .=
", price_level";
5472 $sql .=
", price_ttc";
5473 $sql .=
", price_min";
5474 $sql .=
", price_min_ttc";
5475 $sql .=
", price_base_type";
5476 $sql .=
", price_label";
5477 $sql .=
", default_vat_code";
5479 $sql .=
", recuperableonly";
5480 $sql .=
", localtax1_tx";
5481 $sql .=
", localtax1_type";
5482 $sql .=
", localtax2_tx";
5483 $sql .=
", localtax2_type";
5484 $sql .=
", fk_user_author";
5486 $sql .=
", price_by_qty";
5487 $sql .=
", fk_price_expression";
5488 $sql .=
", fk_multicurrency";
5489 $sql .=
", multicurrency_code";
5490 $sql .=
", multicurrency_tx";
5491 $sql .=
", multicurrency_price";
5492 $sql .=
", multicurrency_price_ttc";
5496 $sql .=
", ".((int) $toId);
5497 $sql .=
", '".$this->db->idate($now).
"'";
5498 $sql .=
", price_level";
5500 $sql .=
", price_ttc";
5501 $sql .=
", price_min";
5502 $sql .=
", price_min_ttc";
5503 $sql .=
", price_base_type";
5504 $sql .=
", price_label";
5505 $sql .=
", default_vat_code";
5507 $sql .=
", recuperableonly";
5508 $sql .=
", localtax1_tx";
5509 $sql .=
", localtax1_type";
5510 $sql .=
", localtax2_tx";
5511 $sql .=
", localtax2_type";
5512 $sql .=
", ".((int) $user->id);
5514 $sql .=
", price_by_qty";
5515 $sql .=
", fk_price_expression";
5516 $sql .=
", fk_multicurrency";
5517 $sql .=
", multicurrency_code";
5518 $sql .=
", multicurrency_tx";
5519 $sql .=
", multicurrency_price";
5520 $sql .=
", multicurrency_price_ttc";
5521 $sql .=
" FROM ".$this->db->prefix().
"product_price ps";
5522 $sql .=
" WHERE fk_product = ".((int) $fromId);
5523 $sql .=
" AND date_price IN (SELECT MAX(pd.date_price) FROM ".$this->db->prefix().
"product_price pd WHERE pd.fk_product = ".((int) $fromId).
" AND pd.price_level = ps.price_level)";
5524 $sql .=
" ORDER BY date_price DESC";
5527 $resql = $this->db->query($sql);
5529 $this->db->rollback();
5533 $this->db->commit();
5550 $sql =
'INSERT INTO '.$this->db->prefix().
'product_association (fk_product_pere, fk_product_fils, qty, incdec)';
5551 $sql .=
" SELECT ".((int) $toId).
", fk_product_fils, qty, incdec FROM ".$this->db->prefix().
"product_association";
5552 $sql .=
" WHERE fk_product_pere = ".((int) $fromId);
5554 dol_syslog(get_class($this).
'::clone_association', LOG_DEBUG);
5555 if (!$this->db->query($sql)) {
5556 $this->db->rollback();
5560 $this->db->commit();
5593 $sql =
"INSERT ".$this->db->prefix().
"product_fournisseur_price (";
5594 $sql .=
" datec, fk_product, fk_soc, price, quantity, fk_user, tva_tx)";
5595 $sql .=
" SELECT '".$this->db->idate($now).
"', ".((int) $toId).
", fk_soc, price, quantity, fk_user, tva_tx";
5596 $sql .=
" FROM ".$this->db->prefix().
"product_fournisseur_price";
5597 $sql .=
" WHERE fk_product = ".((int) $fromId);
5599 dol_syslog(get_class($this).
'::clone_fournisseurs', LOG_DEBUG);
5600 $resql = $this->db->query($sql);
5602 $this->db->rollback();
5605 $this->db->commit();
5623 public function fetch_prod_arbo(
$prod, $compl_path =
'', $multiply = 1, $level = 1, $id_parent = 0, $ignore_stock_load = 0)
5628 if ($multiply < 1) {
5629 dol_syslog(get_class($this).
'::'.__FUNCTION__.
' Product quantity rounded up to 1 from '.$multiply.
'. May result in unexpected end quantity for product children of '.$id_parent, LOG_WARNING);
5634 foreach (
$prod as $id_product => $desc_pere) {
5635 if (is_array($desc_pere)) {
5636 $id = (!empty($desc_pere[0]) ? $desc_pere[0] :
'');
5637 $nb = (!empty($desc_pere[1]) ? $desc_pere[1] :
'');
5638 $type = (!empty($desc_pere[2]) ? $desc_pere[2] :
'');
5639 $label = (!empty($desc_pere[3]) ? $desc_pere[3] :
'');
5640 $incdec = (!empty($desc_pere[4]) ? $desc_pere[4] : 0);
5643 if (is_null($tmpproduct)) {
5644 $tmpproduct =
new Product($this->db);
5646 $tmpproduct->fetch($id);
5648 if (empty($ignore_stock_load) && ($tmpproduct->isProduct() ||
getDolGlobalString(
'STOCK_SUPPORTS_SERVICES'))) {
5649 $tmpproduct->load_stock(
'nobatch,novirtual');
5652 $this->res[] = array(
5654 'id_parent' => $id_parent,
5655 'ref' => $tmpproduct->ref,
5657 'nb_total' => $nb * $multiply,
5658 'stock' => $tmpproduct->stock_reel,
5659 'stock_alert' => $tmpproduct->seuil_stock_alerte,
5661 'fullpath' => $compl_path.$label,
5663 'desiredstock' => $tmpproduct->desiredstock,
5665 'incdec' => $incdec,
5666 'entity' => $tmpproduct->entity
5670 if (isset($desc_pere[
'childs']) && is_array($desc_pere[
'childs'])) {
5671 if (!is_int($desc_pere[1] * $multiply)) {
5672 dol_syslog(get_class($this).
'::'.__FUNCTION__.
' Source product quantity and multiplier may result in unexpected end quantity for '.$label.
'/'.$multiply.
' Child product:'.json_encode($desc_pere), LOG_WARNING);
5676 $this->
fetch_prod_arbo($desc_pere[
'childs'], $compl_path.$desc_pere[3].
" -> ", (
int) ceil($desc_pere[1] * $multiply), $level + 1, $id, $ignore_stock_load);
5694 $this->res = array();
5695 if (isset($this->sousprods) && is_array($this->sousprods)) {
5696 foreach ($this->sousprods as $prod_name => $desc_product) {
5697 if (is_array($desc_product)) {
5698 $this->
fetch_prod_arbo($desc_product,
"", $multiply, 1, $this->
id, $ignore_stock_load);
5717 $sql =
"SELECT COUNT(pa.rowid) as nb";
5718 $sql .=
" FROM ".$this->db->prefix().
"product_association as pa";
5720 $sql .=
" WHERE pa.fk_product_fils = ".((int) $this->
id).
" OR pa.fk_product_pere = ".((int) $this->
id);
5721 } elseif ($mode == -1) {
5722 $sql .=
" WHERE pa.fk_product_fils = ".((int) $this->
id);
5723 } elseif ($mode == 1) {
5724 $sql .=
" WHERE pa.fk_product_pere = ".((int) $this->
id);
5727 $resql = $this->db->query($sql);
5729 $obj = $this->db->fetch_object($resql);
5731 $nb = (int) $obj->nb;
5751 $sql =
"SELECT count(rowid) as nb FROM ".$this->db->prefix().
"product_attribute_combination WHERE fk_product_parent = ".((int) $this->
id);
5752 $sql .=
" AND entity IN (".getEntity(
'product').
")";
5754 $resql = $this->db->query($sql);
5756 $obj = $this->db->fetch_object($resql);
5758 $nb = (int) $obj->nb;
5774 $sql =
"SELECT rowid FROM ".$this->db->prefix().
"product_attribute_combination WHERE fk_product_child = ".((int) $this->
id).
" AND entity IN (".
getEntity(
'product').
")";
5776 $query = $this->db->query($sql);
5779 if (!$this->db->num_rows($query)) {
5800 $sql =
"SELECT p.rowid, p.label as label, p.ref as ref, pa.fk_product_pere as id, p.fk_product_type, pa.qty, pa.incdec, p.entity";
5801 $sql .=
", p.tosell as status, p.tobuy as status_buy";
5802 $sql .=
" FROM ".$this->db->prefix().
"product_association as pa,";
5803 $sql .=
" ".$this->db->prefix().
"product as p";
5804 $sql .=
" WHERE p.rowid = pa.fk_product_pere";
5805 $sql .=
" AND pa.fk_product_fils = ".((int) $this->
id);
5807 $res = $this->db->query($sql);
5810 while ($record = $this->db->fetch_array($res)) {
5812 $prods[$record[
'id']] = array();
5813 $prods[$record[
'id']][
'id'] = $record[
'rowid'];
5814 $prods[$record[
'id']][
'ref'] = $record[
'ref'];
5815 $prods[$record[
'id']][
'label'] = $record[
'label'];
5816 $prods[$record[
'id']][
'qty'] = $record[
'qty'];
5817 $prods[$record[
'id']][
'incdec'] = $record[
'incdec'];
5818 $prods[$record[
'id']][
'fk_product_type'] = $record[
'fk_product_type'];
5819 $prods[$record[
'id']][
'entity'] = $record[
'entity'];
5820 $prods[$record[
'id']][
'status'] = $record[
'status'];
5821 $prods[$record[
'id']][
'status_buy'] = $record[
'status_buy'];
5840 public function getChildsArbo($id, $firstlevelonly = 0, $level = 1, $parents = array())
5846 $sql =
"SELECT p.rowid, p.ref, p.label as label, p.fk_product_type,";
5847 $sql .=
" pa.qty as qty, pa.fk_product_fils as id, pa.incdec,";
5848 $sql .=
" pa.rowid as fk_association, pa.rang";
5849 $sql .=
" FROM ".$this->db->prefix().
"product as p,";
5850 $sql .=
" ".$this->db->prefix().
"product_association as pa";
5851 $sql .=
" WHERE p.rowid = pa.fk_product_fils";
5852 $sql .=
" AND pa.fk_product_pere = ".((int) $id);
5853 $sql .=
" AND pa.fk_product_fils <> ".((int) $id);
5854 $sql .=
" ORDER BY pa.rang";
5856 dol_syslog(get_class($this).
'::getChildsArbo id='.$id.
' level='.$level.
' parents='.(is_array($parents) ? implode(
',', $parents) : $parents), LOG_DEBUG);
5863 $res = $this->db->query($sql);
5866 if ($this->db->num_rows($res) > 0) {
5870 while ($rec = $this->db->fetch_array($res)) {
5871 if (in_array($rec[
'id'], $parents)) {
5872 dol_syslog(get_class($this).
'::getChildsArbo the product id='.$rec[
'rowid'].
' was already found at a higher level in tree. We discard to avoid infinite loop', LOG_WARNING);
5876 $prods[$rec[
'rowid']] = array(
5879 2 => $rec[
'fk_product_type'],
5880 3 => $this->db->escape($rec[
'label']),
5881 4 => $rec[
'incdec'],
5883 6 => $rec[
'fk_association'],
5888 if (empty($firstlevelonly)) {
5889 $listofchilds = $this->
getChildsArbo($rec[
'rowid'], 0, $level + 1, $parents);
5890 foreach ($listofchilds as $keyChild => $valueChild) {
5891 $prods[$rec[
'rowid']][
'childs'][$keyChild] = $valueChild;
5915 foreach ($this->
getChildsArbo($this->
id) as $keyChild => $valueChild) {
5916 $parent[$this->label][$keyChild] = $valueChild;
5918 foreach ($parent as $key => $value) {
5919 $this->sousprods[$key] = $value;
5932 global
$conf, $langs, $user;
5934 $langs->loadLangs(array(
'products',
'other'));
5937 $nofetch = !empty($params[
'nofetch']);
5940 return [
'optimize' => $langs->trans(
"ShowProduct")];
5944 $permissiontoreadproduct = 0;
5945 if ($this->
type == self::TYPE_PRODUCT && $user->hasRight(
'product',
'read')) {
5946 $permissiontoreadproduct = 1;
5948 if ($this->
type == self::TYPE_SERVICE && $user->hasRight(
'service',
'read')) {
5949 $permissiontoreadproduct = 1;
5952 if (!empty($this->entity) && $permissiontoreadproduct) {
5953 $tmpphoto = $this->
show_photos(
'product', $conf->product->multidir_output[$this->entity], 1, 1, 0, 0, 0, 80, 0, 0, 0, 0,
'1');
5954 if ($this->nbphoto > 0) {
5955 $datas[
'photo'] =
'<div class="photointooltip floatright">'.
"\n" . $tmpphoto .
'</div>';
5960 $datas[
'picto'] =
img_picto(
'',
'product').
' <u class="paddingrightonly">'.$langs->trans(
"Product").
'</u>';
5962 $datas[
'picto'] =
img_picto(
'',
'service').
' <u class="paddingrightonly">'.$langs->trans(
"Service").
'</u>';
5964 if (isset($this->
status) && isset($this->status_buy)) {
5965 $datas[
'status'] =
' '.$this->getLibStatut(5, 0) .
' '.$this->getLibStatut(5, 1);
5968 if (!empty($this->
ref)) {
5969 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'ProductRef').
':</b> '.$this->ref;
5971 if (!empty($this->label)) {
5972 $datas[
'label'] =
'<br><b>'.$langs->trans(
'ProductLabel').
':</b> '.$this->label.
'<br>';
5975 if ($permissiontoreadproduct) {
5980 $datas[
'stockmanaged'] =
"<br><b>".$langs->trans(
"StockableProduct").
'</b>: '.
yn($this->
isStockManaged());
5984 $langs->load(
"productbatch");
5985 $datas[
'batchstatus'] =
"<br><b>".$langs->trans(
"ManageLotSerial").
'</b>: '.$this->
getLibStatut(0, 2);
5986 if ($this->status_batch) {
5987 $datas[
'batchdlc'] =
"<br><b>".$langs->trans(
"BatchSellOrEatByMandatoryList", $langs->transnoentitiesnoconv(
"SellByDate"), $langs->transnoentitiesnoconv(
"EatByDate")).
'</b>: '.$this->
getSellOrEatByMandatoryLabel();
5992 $datas[
'barcode'] =
'<br><b>'.$langs->trans(
'BarCode').
':</b> '.$this->barcode;
5996 if ($this->weight) {
5997 $datas[
'weight'] =
"<br><b>".$langs->trans(
"Weight").
'</b>: '.$this->weight.
' '.
measuringUnitString(0,
"weight", $this->weight_units);
6000 if ($this->length) {
6001 $labelsize .=
"<b>".$langs->trans(
"Length").
'</b>: '.$this->length.
' '.
measuringUnitString(0,
'size', $this->length_units);
6004 $labelsize .= ($labelsize ?
" - " :
"").
"<b>".$langs->trans(
"Width").
'</b>: '.$this->width.
' '.
measuringUnitString(0,
'size', $this->width_units);
6006 if ($this->height) {
6007 $labelsize .= ($labelsize ?
" - " :
"").
"<b>".$langs->trans(
"Height").
'</b>: '.$this->height.
' '.
measuringUnitString(0,
'size', $this->height_units);
6010 $datas[
'size'] =
"<br>".$labelsize;
6013 $labelsurfacevolume =
"";
6014 if ($this->surface) {
6015 $labelsurfacevolume .=
"<b>".$langs->trans(
"Surface").
'</b>: '.$this->surface.
' '.
measuringUnitString(0,
'surface', $this->surface_units);
6017 if ($this->volume) {
6018 $labelsurfacevolume .= ($labelsurfacevolume ?
" - " :
"").
"<b>".$langs->trans(
"Volume").
'</b>: '.$this->volume.
' '.
measuringUnitString(0,
'volume', $this->volume_units);
6020 if ($labelsurfacevolume) {
6021 $datas[
'surface'] =
"<br>" . $labelsurfacevolume;
6024 if ($this->
isService() && !empty($this->duration_value)) {
6026 $datas[
'duration'] =
'<br><b>'.$langs->trans(
"Duration").
':</b> '.$this->duration_value;
6027 if ($this->duration_value > 1) {
6028 $dur = array(
"i" => $langs->trans(
"Minutes"),
"h" => $langs->trans(
"Hours"),
"d" => $langs->trans(
"Days"),
"w" => $langs->trans(
"Weeks"),
"m" => $langs->trans(
"Months"),
"y" => $langs->trans(
"Years"));
6029 } elseif ($this->duration_value > 0) {
6030 $dur = array(
"i" => $langs->trans(
"Minute"),
"h" => $langs->trans(
"Hour"),
"d" => $langs->trans(
"Day"),
"w" => $langs->trans(
"Week"),
"m" => $langs->trans(
"Month"),
"y" => $langs->trans(
"Year"));
6032 $datas[
'duration'] .= (!empty($this->duration_unit) && isset($dur[$this->duration_unit]) ?
" ".$langs->trans($dur[$this->duration_unit]) :
'');
6034 if (empty($user->socid)) {
6035 if ($this->
isStockManaged() && isset($this->pmp) && $this->pmp) {
6036 $datas[
'pmp'] =
"<br><b>".$langs->trans(
"PMPValue").
'</b>: '.
price($this->pmp, 0,
'', 1, -1, -1,
$conf->currency);
6040 if ($this->
status && isset($this->accountancy_code_sell)) {
6041 include_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
6042 $selllabel =
'<br>';
6043 $selllabel .=
'<br><b>'.$langs->trans(
'ProductAccountancySellCode').
':</b> '.
length_accountg($this->accountancy_code_sell);
6044 $selllabel .=
'<br><b>'.$langs->trans(
'ProductAccountancySellIntraCode').
':</b> '.
length_accountg($this->accountancy_code_sell_intra);
6045 $selllabel .=
'<br><b>'.$langs->trans(
'ProductAccountancySellExportCode').
':</b> '.
length_accountg($this->accountancy_code_sell_export);
6046 $datas[
'accountancysell'] = $selllabel;
6048 if ($this->status_buy && isset($this->accountancy_code_buy)) {
6049 include_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
6051 if (empty($this->
status)) {
6052 $buylabel .=
'<br>';
6054 $buylabel .=
'<br><b>'.$langs->trans(
'ProductAccountancyBuyCode').
':</b> '.
length_accountg($this->accountancy_code_buy);
6055 $buylabel .=
'<br><b>'.$langs->trans(
'ProductAccountancyBuyIntraCode').
':</b> '.
length_accountg($this->accountancy_code_buy_intra);
6056 $buylabel .=
'<br><b>'.$langs->trans(
'ProductAccountancyBuyExportCode').
':</b> '.
length_accountg($this->accountancy_code_buy_export);
6057 $datas[
'accountancybuy'] = $buylabel;
6063 require_once DOL_DOCUMENT_ROOT .
'/categories/class/categorie.class.php';
6064 $form =
new Form($this->db);
6065 $datas[
'categories'] =
'<br>' . $form->showCategories($this->
id, Categorie::TYPE_PRODUCT, 1);
6085 public function getNomUrl($withpicto = 0, $option =
'', $maxlength = 0, $save_lastsearch_value = -1, $notooltip = 0, $morecss =
'', $add_label = 0, $sep =
' - ')
6087 global $langs, $hookmanager;
6089 include_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
6095 $newref =
dol_trunc($newref, $maxlength,
'middle');
6099 'objecttype' => ($this->
type == 1 ?
'service' :
'product'),
6100 'option' => $option,
6103 $classfortooltip =
'classfortooltip';
6106 $classfortooltip =
'classforajaxtooltip';
6107 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
6114 if (empty($notooltip)) {
6116 $label = $langs->trans(
"ShowProduct");
6117 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1, 1).
'"';
6119 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1, 1).
'"' :
' title="tocomplete"');
6120 $linkclose .= $dataparams.
' class="nowraponall '.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
6122 $linkclose =
' class="nowraponall'.($morecss ?
' '.$morecss :
'').
'"';
6125 if ($option ==
'supplier' || $option ==
'category') {
6126 $url = DOL_URL_ROOT.
'/product/price_suppliers.php?id='.$this->id;
6127 } elseif ($option ==
'stock') {
6128 $url = DOL_URL_ROOT.
'/product/stock/product.php?id='.$this->id;
6129 } elseif ($option ==
'composition') {
6130 $url = DOL_URL_ROOT.
'/product/composition/card.php?id='.$this->id;
6132 $url = DOL_URL_ROOT.
'/product/card.php?id='.$this->id;
6135 if ($option !==
'nolink') {
6137 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
6138 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
6139 $add_save_lastsearch_values = 1;
6141 if ($add_save_lastsearch_values) {
6142 $url .=
'&save_lastsearch_values=1';
6146 $linkstart =
'<a href="'.$url.
'"';
6147 $linkstart .= $linkclose.
'>';
6150 $result .= $linkstart;
6153 $result .= (
img_object(($notooltip ?
'' : $label),
'product',
'class="paddingright"', 0, 0, $notooltip ? 0 : 1));
6156 $result .= (
img_object(($notooltip ?
'' : $label),
'service',
'class="paddingright"', 0, 0, $notooltip ? 0 : 1));
6159 $result .=
'<span class="aaa">'.dol_escape_htmltag($newref).
'</span>';
6160 $result .= $linkend;
6161 if ($withpicto != 2) {
6162 $result .= (($add_label && $this->label) ? $sep.dol_trunc($this->label, ($add_label > 1 ? $add_label : 0)) :
'');
6166 $hookmanager->initHooks(array(
'productdao'));
6167 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result,
'label' => &$label);
6168 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
6170 $result = $hookmanager->resPrint;
6172 $result .= $hookmanager->resPrint;
6189 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
6193 $langs->load(
"products");
6194 $outputlangs->load(
"products");
6199 if (!empty($this->model_pdf)) {
6200 $modele = $this->model_pdf;
6206 if (empty($modele)) {
6209 $modelpath =
"core/modules/product/doc/";
6210 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref);
6227 return $this->
LibStatut($this->status_buy, $mode, $type);
6229 return $this->
LibStatut($this->status_batch, $mode, $type);
6232 return $this->
LibStatut($this->status_buy, $mode, $type);
6250 $labelStatus = $labelStatusShort =
'';
6252 $langs->load(
'products');
6254 $langs->load(
"productbatch");
6260 $label = ($status == 0 ? $langs->transnoentitiesnoconv(
'ProductStatusNotOnBatch') : ($status == 1 ? $langs->transnoentitiesnoconv(
'ProductStatusOnBatch') : $langs->transnoentitiesnoconv(
'ProductStatusOnSerial')));
6263 $label = ($status == 0 ? $langs->transnoentitiesnoconv(
'ProductStatusNotOnBatchShort') : ($status == 1 ? $langs->transnoentitiesnoconv(
'ProductStatusOnBatchShort') : $langs->transnoentitiesnoconv(
'ProductStatusOnSerialShort')));
6268 return dolGetStatus($langs->transnoentitiesnoconv(
'ProductStatusNotOnBatch'),
'',
'', empty($status) ?
'status5' :
'status4', 3,
'dot');
6274 return dolGetStatus($langs->transnoentitiesnoconv(
'Unknown'));
6278 $statuttrans = empty($status) ?
'status5' :
'status4';
6283 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusNotOnSellShort');
6284 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusNotOnSell');
6285 } elseif ($type == 1) {
6286 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusNotOnBuyShort');
6287 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusNotOnBuy');
6288 } elseif ($type == 2) {
6289 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusNotOnBatch');
6290 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusNotOnBatchShort');
6292 } elseif ($status == 1) {
6295 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusOnSellShort');
6296 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusOnSell');
6297 } elseif ($type == 1) {
6298 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusOnBuyShort');
6299 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusOnBuy');
6300 } elseif ($type == 2) {
6301 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusOnBatch');
6302 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusOnBatchShort');
6304 } elseif ($type == 2 && $status == 2) {
6305 $labelStatus = $langs->transnoentitiesnoconv(
'ProductStatusOnSerial');
6306 $labelStatusShort = $langs->transnoentitiesnoconv(
'ProductStatusOnSerialShort');
6310 return dolGetStatus($langs->transnoentitiesnoconv(
'Unknown'),
'',
'',
'status0', 0);
6312 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statuttrans, $mode);
6326 $langs->load(
'products');
6329 if (isset($this->finished) && $this->finished >= 0) {
6330 $sql =
"SELECT label, code FROM ".$this->db->prefix().
"c_product_nature where code = ".((int) $this->finished).
" AND active=1";
6331 $resql = $this->db->query($sql);
6333 $this->error = $this->db->error().
' sql='.$sql;
6334 dol_syslog(__METHOD__.
' Error '.$this->error, LOG_ERR);
6336 } elseif ($this->db->num_rows($resql) > 0 && $res = $this->db->fetch_array($resql)) {
6337 $label = $langs->trans($res[
'label']);
6339 $this->db->free($resql);
6363 public function correct_stock($user, $id_entrepot, $nbpiece, $movement, $label =
'', $price = 0, $inventorycode =
'', $origin_element =
'', $origin_id =
null, $disablestockchangeforsubproduct = 0, $extrafields =
null)
6369 include_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
6372 $nbpiece = (float) $nbpiece;
6377 $nbpiece = abs($nbpiece);
6384 $movementstock->setOrigin($origin_element, (
int) $origin_id);
6385 $result = $movementstock->_create($user, $this->
id, $id_entrepot, $op[$movement], $movement, $price, $label, $inventorycode,
'',
'',
'',
'',
false, 0, $disablestockchangeforsubproduct);
6389 $array_options = $extrafields->getOptionalsFromPost(
'stock_mouvement');
6390 $movementstock->array_options = $array_options;
6391 $movementstock->insertExtraFields();
6393 $this->db->commit();
6398 $this->db->rollback();
6427 public function correct_stock_batch($user, $id_entrepot, $nbpiece, $movement, $label =
'', $price = 0, $dlc =
'', $dluo =
'', $lot =
'', $inventorycode =
'', $origin_element =
'', $origin_id =
null, $disablestockchangeforsubproduct = 0, $extrafields =
null, $force_update_batch =
false)
6433 include_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
6436 $nbpiece = (float) $nbpiece;
6441 $nbpiece = abs($nbpiece);
6449 $movementstock->setOrigin($origin_element, (
int) $origin_id);
6450 $result = $movementstock->_create($user, $this->
id, $id_entrepot, $op[$movement], $movement, $price, $label, $inventorycode,
'', $dlc, $dluo, $lot,
false, 0, $disablestockchangeforsubproduct, 0, $force_update_batch);
6454 $array_options = $extrafields->getOptionalsFromPost(
'stock_mouvement');
6455 $movementstock->array_options = $array_options;
6456 $movementstock->insertExtraFields();
6458 $this->db->commit();
6461 $this->error = $movementstock->error;
6462 $this->errors = $movementstock->errors;
6464 $this->db->rollback();
6484 public function load_stock($option =
'', $includedraftpoforvirtual =
null, $dateofvirtualstock =
null)
6487 $this->stock_reel = 0;
6488 $this->stock_warehouse = array();
6489 $this->stock_theorique = 0;
6492 $warehouseStatus = array();
6493 if (preg_match(
'/warehouseclosed/', $option)) {
6496 if (preg_match(
'/warehouseopen/', $option)) {
6499 if (preg_match(
'/warehouseinternal/', $option)) {
6507 $sql =
"SELECT ps.rowid, ps.reel, ps.fk_entrepot";
6508 $sql .=
" FROM ".$this->db->prefix().
"product_stock as ps";
6509 $sql .=
", ".$this->db->prefix().
"entrepot as w";
6510 $sql .=
" WHERE w.entity IN (".getEntity(
'stock').
")";
6511 $sql .=
" AND w.rowid = ps.fk_entrepot";
6512 $sql .=
" AND ps.fk_product = ".((int) $this->
id);
6513 if (count($warehouseStatus)) {
6514 $sql .=
" AND w.statut IN (".$this->db->sanitize(implode(
',', $warehouseStatus)).
")";
6517 $sql .=
" ORDER BY ps.reel ".(getDolGlobalString(
'DO_NOT_TRY_TO_DEFRAGMENT_STOCKS_WAREHOUSE') ?
'DESC' :
'ASC');
6519 dol_syslog(get_class($this).
"::load_stock", LOG_DEBUG);
6520 $result = $this->db->query($sql);
6522 $num = $this->db->num_rows($result);
6526 $row = $this->db->fetch_object($result);
6527 $this->stock_warehouse[$row->fk_entrepot] =
new stdClass();
6528 $this->stock_warehouse[$row->fk_entrepot]->real = $row->reel;
6529 $this->stock_warehouse[$row->fk_entrepot]->id = $row->rowid;
6530 if ((!preg_match(
'/nobatch/', $option)) && $this->
hasbatch()) {
6531 $this->stock_warehouse[$row->fk_entrepot]->detail_batch =
Productbatch::findAll($this->db, $row->rowid, 1, $this->id);
6533 $this->stock_reel += $row->reel;
6536 $this->stock_reel = (float)
price2num($this->stock_reel,
'MS');
6538 $this->db->free($result);
6540 if (!preg_match(
'/novirtual/', $option)) {
6546 $this->error = $this->db->lasterror();
6565 global $hookmanager, $action;
6567 $stock_commande_client = 0;
6568 $stock_commande_fournisseur = 0;
6569 $stock_sending_client = 0;
6570 $stock_reception_fournisseur = 0;
6571 $stock_inproduction = 0;
6580 $stock_commande_client = $this->stats_commande[
'qty'];
6583 require_once DOL_DOCUMENT_ROOT.
'/expedition/class/expedition.class.php';
6584 $filterShipmentStatus =
'';
6594 $stock_sending_client = $this->stats_expedition[
'qty'];
6598 $filterStatus =
getDolGlobalString(
'SUPPLIER_ORDER_STATUS_FOR_VIRTUAL_STOCK',
'3,4');
6599 if (isset($includedraftpoforvirtual)) {
6600 $filterStatus =
'0,1,2,'.$filterStatus;
6606 $stock_commande_fournisseur = $this->stats_commande_fournisseur[
'qty'];
6611 if (isset($includedraftpoforvirtual)) {
6612 $filterStatus =
'0,'.$filterStatus;
6618 $stock_reception_fournisseur = $this->stats_reception[
'qty'];
6626 $stock_inproduction = $this->stats_mrptoproduce[
'qty'] - $this->stats_mrptoconsume[
'qty'];
6629 $this->stock_theorique = $this->stock_reel + $stock_inproduction;
6633 $weBillOrderOrShipmentReception =
getDolGlobalString(
'STOCK_DO_WE_BILL_ORDER_OR_SHIPMENTECEPTION_FOR_VIRTUALSTOCK',
'order');
6637 $this->stock_theorique -= ($stock_commande_client - $stock_sending_client);
6641 $result = $tmpnewprod->load_stats_commande(0,
'0', 1);
6642 $this->stock_theorique += $tmpnewprod->stats_commande[
'qty'];
6644 } elseif (
getDolGlobalString(
'STOCK_CALCULATE_ON_BILL') && $weBillOrderOrShipmentReception ==
'order') {
6645 $this->stock_theorique -= $stock_commande_client;
6646 } elseif (
getDolGlobalString(
'STOCK_CALCULATE_ON_BILL') && $weBillOrderOrShipmentReception ==
'shipmentreception') {
6647 $this->stock_theorique -= ($stock_commande_client - $stock_sending_client);
6652 $this->stock_theorique += ($stock_commande_fournisseur - $stock_reception_fournisseur);
6654 $this->stock_theorique += ($stock_commande_fournisseur - $stock_reception_fournisseur);
6656 if (
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_VALIDATE_ORDER_INCLUDE_DRAFT')) {
6658 $result = $tmpnewprod->load_stats_commande_fournisseur(0,
'0', 1);
6659 $this->stock_theorique += $this->stats_commande_fournisseur[
'qty'];
6661 $this->stock_theorique -= $stock_reception_fournisseur;
6662 } elseif (
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_BILL') && $weBillOrderOrShipmentReception ==
'order') {
6663 $this->stock_theorique += $stock_commande_fournisseur;
6664 } elseif (
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_BILL') && $weBillOrderOrShipmentReception ==
'shipmentreception') {
6665 $this->stock_theorique += ($stock_commande_fournisseur - $stock_reception_fournisseur);
6668 $parameters = array(
'id' => $this->
id,
'includedraftpoforvirtual' => $includedraftpoforvirtual);
6670 $reshook = $hookmanager->executeHooks(
'loadvirtualstock', $parameters, $this, $action);
6672 $this->stock_theorique = $hookmanager->resArray[
'stock_theorique'];
6673 } elseif ($reshook == 0 && isset($hookmanager->resArray[
'stock_stats_hook'])) {
6674 $this->stock_theorique += $hookmanager->resArray[
'stock_stats_hook'];
6678 if (!empty($this->stock_warehouse) &&
getDolGlobalString(
'STOCK_ALLOW_VIRTUAL_STOCK_PER_WAREHOUSE')) {
6679 foreach ($this->stock_warehouse as $warehouseid => $stockwarehouse) {
6687 if ($this->fk_default_warehouse == $warehouseid) {
6688 $this->stock_warehouse[$warehouseid]->virtual = $this->stock_warehouse[$warehouseid]->real + $this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'] + $this->stats_commande_fournisseur[
'qty'] - ($this->stats_commande[
'qty'] + $this->stats_mrptoconsume[
'qty']);
6690 $this->stock_warehouse[$warehouseid]->virtual = $this->stock_warehouse[$warehouseid]->real + $this->stock_warehouse[$warehouseid]->stats_mrptoproduce[
'qty'];
6707 $this->stock_warehouse = array();
6712 if (count($prods_arbo) > 0) {
6713 $productCachedList = array();
6714 $stockByComponentList = array();
6716 foreach ($prods_arbo as $componentArr) {
6717 $componentId = $componentArr[
'id'];
6719 if ($componentArr[
'incdec'] == 1) {
6720 if (!isset($productCachedList[$componentId])) {
6721 $componentStatic =
new self($this->db);
6722 $componentStatic->fetch($componentId);
6724 $childrenNb = $componentStatic->hasFatherOrChild(1);
6725 if ($childrenNb == 0) {
6726 $componentStatic->load_stock(
'nobatch,novirtual');
6727 if (!isset($stockByComponentList[$componentId])) {
6728 $stockByComponentList[$componentId] = array(
6732 $stockByComponentList[$componentId][
'qty_need'] += $componentArr[
'nb_total'];
6734 $productCachedList[$componentId] = $componentStatic;
6739 if (!empty($stockByComponentList)) {
6740 foreach ($stockByComponentList as $componentId => $stockByComponentArr) {
6741 if (!isset($productCachedList[$componentId])) {
6742 $componentStatic =
new self($this->db);
6743 $componentStatic->fetch($componentId);
6744 $componentStatic->load_stock(
'nobatch,novirtual');
6745 $productCachedList[$componentId] = $componentStatic;
6747 $component = $productCachedList[$componentId];
6750 if ($component->stock_reel < $stockByComponentArr[
'qty_need']) {
6753 $this->error =
'Not enough component [id='.$componentId.
'] in stock, real='.$component->stock_reel.
' and need='.$stockByComponentArr[
'qty_need'];
6754 $this->errors[] = $this->error;
6755 dol_syslog(__METHOD__.
' : '.$this->error, LOG_ERR);
6757 if (!empty($component->stock_warehouse)) {
6758 foreach ($component->stock_warehouse as $warehouseId => $warehouseObj) {
6759 $kitWarehouseAvailable =
new stdClass();
6760 $kitWarehouseAvailable->id = $warehouseObj->id;
6761 $kitWarehouseAvailable->real = $qtyWish;
6762 $this->stock_warehouse[$warehouseId] = $kitWarehouseAvailable;
6771 } elseif (
getDolGlobalInt(
'PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE') && empty($productCachedList)) {
6796 $sql =
"SELECT pb.batch, pl.eatby, pl.sellby, SUM(pb.qty) AS qty FROM ".$this->db->prefix().
"product_batch as pb";
6797 $sql .=
" INNER JOIN ".$this->db->prefix().
"product_stock as ps ON pb.fk_product_stock = ps.rowid";
6798 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_lot as pl ON pl.fk_product = ps.fk_product AND pl.batch = pb.batch";
6799 $sql .=
" WHERE ps.fk_product = ".((int) $this->
id).
" AND pb.batch = '".$this->db->escape($batch).
"'";
6800 $sql .=
" GROUP BY pb.batch, pl.eatby, pl.sellby";
6801 dol_syslog(get_class($this).
"::loadBatchInfo load first entry found for lot/serial = ".$batch, LOG_DEBUG);
6802 $resql = $this->db->query($sql);
6804 $num = $this->db->num_rows($resql);
6807 $obj = $this->db->fetch_object($resql);
6808 $result[] = array(
'batch' => $batch,
'eatby' => $this->db->jdate($obj->eatby),
'sellby' => $this->db->jdate($obj->sellby),
'qty' => $obj->qty);
6814 $this->db->rollback();
6831 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
6837 $dir .=
'/'.get_exdir($this->
id, 2, 0, 0, $this,
'product').$this->id.
"/photos";
6839 $dir .=
'/'.get_exdir(0, 0, 0, 0, $this,
'product').dol_sanitizeFileName($this->
ref);
6844 $dir_osencoded = $dir;
6846 if (is_dir($dir_osencoded)) {
6847 $originImage = $dir.
'/'.$file[
'name'];
6858 if (is_numeric($result) && $result > 0) {
6875 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
6876 include_once DOL_DOCUMENT_ROOT.
'/core/lib/images.lib.php';
6880 $dir .=
'/'.get_exdir($this->
id, 2, 0, 0, $this,
'product').$this->id.
"/photos/";
6882 $dir .=
'/'.get_exdir(0, 0, 0, 0, $this,
'product');
6886 if (file_exists($dir_osencoded)) {
6887 $handle = opendir($dir_osencoded);
6888 if (is_resource($handle)) {
6889 while (($file = readdir($handle)) !==
false) {
6891 $file = mb_convert_encoding($file,
'UTF-8',
'ISO-8859-1');
6914 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
6915 include_once DOL_DOCUMENT_ROOT.
'/core/lib/images.lib.php';
6921 $handle = @opendir($dir_osencoded);
6922 if (is_resource($handle)) {
6923 while (($file = readdir($handle)) !==
false) {
6925 $file = mb_convert_encoding($file,
'UTF-8',
'ISO-8859-1');
6932 $photo_vignette =
'';
6934 if (preg_match(
'/('.$this->regeximgext.
')$/i', $photo, $regs)) {
6935 $photo_vignette = preg_replace(
'/'.$regs[0].
'/i',
'', $photo).
'_small'.$regs[0];
6938 $dirthumb = $dir.
'thumbs/';
6942 $obj[
'photo'] = $photo;
6943 if ($photo_vignette &&
dol_is_file($dirthumb.$photo_vignette)) {
6944 $obj[
'photo_vignette'] =
'thumbs/'.$photo_vignette;
6946 $obj[
'photo_vignette'] =
"";
6949 $tabobj[$nbphoto - 1] = $obj;
6952 if ($nbmax && $nbphoto >= $nbmax) {
6974 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
6975 include_once DOL_DOCUMENT_ROOT.
'/core/lib/images.lib.php';
6977 $dir = dirname($file).
'/';
6978 $dirthumb = $dir.
'/thumbs/';
6979 $filename = preg_replace(
'/'.preg_quote($dir,
'/').
'/i',
'', $file);
6985 if (preg_match(
'/('.$this->regeximgext.
')$/i', $filename, $regs)) {
6986 $photo_vignette = preg_replace(
'/'.$regs[0].
'/i',
'', $filename).
'_small'.$regs[0];
6987 if (file_exists(
dol_osencode($dirthumb.$photo_vignette))) {
6991 $photo_vignette = preg_replace(
'/'.$regs[0].
'/i',
'', $filename).
'_mini'.$regs[0];
6992 if (file_exists(
dol_osencode($dirthumb.$photo_vignette))) {
7009 $infoImg = getimagesize($file_osencoded);
7010 $this->imgWidth = $infoImg[0];
7011 $this->imgHeight = $infoImg[1];
7021 global $hookmanager;
7023 $this->nb = array();
7025 $sql =
"SELECT count(p.rowid) as nb, fk_product_type";
7026 $sql .=
" FROM ".$this->db->prefix().
"product as p";
7027 $sql .=
' WHERE p.entity IN ('.getEntity($this->element, 1).
')';
7029 if (is_object($hookmanager)) {
7030 $parameters = array();
7031 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $this);
7032 $sql .= $hookmanager->resPrint;
7034 $sql .=
' GROUP BY fk_product_type';
7036 $resql = $this->db->query($sql);
7038 while ($obj = $this->db->fetch_object($resql)) {
7039 if ($obj->fk_product_type == 1) {
7040 $this->nb[
"services"] = $obj->nb;
7042 $this->nb[
"products"] = $obj->nb;
7045 $this->db->free($resql);
7049 $this->error = $this->db->error();
7091 return $this->mandatory_period == 1;
7101 return $this->status_batch > 0;
7121 $dirsociete = array_merge(array(
'/core/modules/barcode/'),
$conf->modules_parts[
'barcode']);
7122 foreach ($dirsociete as $dirroot) {
7130 '@phan-var-force ModeleNumRefBarCode $mod';
7132 $result = $mod->getNextValue(
$object, $type);
7134 dol_syslog(get_class($this).
"::get_barcode barcode=".$result.
" module=".$var);
7151 $this->specimen = 1;
7153 $this->
ref =
'PRODUCT_SPEC';
7154 $this->label =
'PRODUCT SPECIMEN';
7155 $this->
description =
'This is description of this product specimen that was created the '.dol_print_date($now,
'dayhourlog').
'.';
7156 $this->specimen = 1;
7157 $this->country_id = 1;
7159 $this->status_buy = 1;
7161 $this->sell_or_eat_by_mandatory = 0;
7162 $this->note_private =
'This is a comment (private)';
7163 $this->note_public =
'This is a comment (public)';
7164 $this->date_creation = $now;
7165 $this->date_modification = $now;
7168 $this->weight_units = 3;
7171 $this->length_units = 1;
7173 $this->width_units = 0;
7174 $this->height =
null;
7175 $this->height_units =
null;
7177 $this->surface = 30;
7178 $this->surface_units = 0;
7179 $this->volume = 300;
7180 $this->volume_units = 0;
7182 $this->barcode = -1;
7200 if (empty($this->fk_unit)) {
7203 if (empty($outputlangs)) {
7204 $outputlangs = $langs;
7207 $outputlangs->load(
'products');
7210 $sql =
"SELECT code, label, short_label FROM ".$this->db->prefix().
"c_units where rowid = ".((int) $this->fk_unit);
7212 $resql = $this->db->query($sql);
7214 $this->error = $this->db->error();
7215 dol_syslog(get_class($this).
"::getLabelOfUnit Error ".$this->error, LOG_ERR);
7217 } elseif ($this->db->num_rows($resql) > 0 && $res = $this->db->fetch_array($resql)) {
7218 if ($type ==
'short') {
7220 $label = $outputlangs->transnoentitiesnoconv($res[
'short_label']);
7222 $label = $outputlangs->trans($res[
'short_label']);
7224 } elseif ($type ==
'code') {
7225 $label = $res[
'code'];
7227 if ($outputlangs->trans(
'unit'.$res[
'code']) ==
'unit'.$res[
'code']) {
7229 $label = $res[
'label'];
7233 $label = $outputlangs->transnoentitiesnoconv(
'unit'.$res[
'code']);
7235 $label = $outputlangs->trans(
'unit'.$res[
'code']);
7240 $this->db->free($resql);
7254 $maxpricesupplier = 0;
7257 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
7259 $product_fourn_list = $product_fourn->list_product_fournisseur_price($this->
id,
'',
'');
7261 if (is_array($product_fourn_list) && count($product_fourn_list) > 0) {
7262 foreach ($product_fourn_list as $productfourn) {
7263 if ($productfourn->fourn_unitprice > $maxpricesupplier) {
7264 $maxpricesupplier = $productfourn->fourn_unitprice;
7272 return $maxpricesupplier;
7288 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
7289 return parent::setCategoriesCommon($categories, Categorie::TYPE_PRODUCT);
7303 $sql =
" DELETE FROM ".$dbs->prefix().
"product_customer_price";
7304 $sql .=
" WHERE fk_soc = ".(int) $origin_id;
7305 $sql .=
" AND fk_product IN (SELECT fk_product FROM (SELECT fk_product FROM ".$dbs->prefix().
"product_customer_price WHERE fk_soc = ".(int) $dest_id.
") AS tmp)";
7308 if (!$dbs->
query($sql)) {
7313 'product_customer_price',
7314 'product_customer_price_log'
7333 $sql =
"SELECT rowid, level, fk_level, var_percent, var_min_percent FROM ".$this->db->prefix().
"product_pricerules";
7334 $query = $this->db->query($sql);
7338 while ($result = $this->db->fetch_object($query)) {
7339 $rules[$result->level] = $result;
7348 for ($i = 1; $i <= $nbofproducts; $i++) {
7349 $price = $baseprice;
7350 $price_min = $baseprice;
7354 if ($i > 1 && isset($rules[$i]->var_percent) && $rules[$i]->var_percent) {
7355 $price = $prices[$rules[$i]->fk_level] * (1 + ($rules[$i]->var_percent / 100));
7358 $prices[$i] = $price;
7361 if (isset($rules[$i]->var_min_percent) && $rules[$i]->var_min_percent) {
7362 $price_min = $price * (1 - ($rules[$i]->var_min_percent / 100));
7366 $check_amount = (($price == $this->multiprices[$i]) && ($price_min == $this->multiprices_min[$i]));
7367 $check_type = ($baseprice == $this->multiprices_base_type[$i]);
7369 if ($check_amount && $check_type) {
7373 if ($this->
updatePrice($price, $price_type, $user, $price_vat, $price_min, $i, $npr, $psq, 1) < 0) {
7391 return $user->rights->produit;
7393 return $user->rights->service;
7405 $sql =
"SELECT p.rowid, p.ref, p.datec as date_creation, GREATEST(p.tms, COALESCE(pef.tms, p.tms)) as date_modification,";
7406 $sql .=
" p.fk_user_author, p.fk_user_modif";
7407 $sql .=
" FROM ".$this->db->prefix().$this->table_element.
" as p";
7408 $sql .=
" LEFT JOIN ".$this->db->prefix().$this->table_element.
"_extrafields as pef ON pef.fk_object=p.rowid";
7409 $sql .=
" WHERE p.rowid = ".((int) $id);
7411 $result = $this->db->query($sql);
7413 if ($this->db->num_rows($result)) {
7414 $obj = $this->db->fetch_object($result);
7416 $this->
id = $obj->rowid;
7417 $this->
ref = $obj->ref;
7419 $this->user_creation_id = $obj->fk_user_author;
7420 $this->user_modification_id = $obj->fk_user_modif;
7422 $this->date_creation = $this->db->jdate($obj->date_creation);
7423 $this->date_modification = $this->db->jdate($obj->date_modification);
7426 $this->db->free($result);
7440 if (empty($this->duration_value)) {
7441 $this->errors[] =
'ErrorDurationForServiceNotDefinedCantCalculateHourlyPrice';
7444 if ($this->duration_unit ==
's') {
7445 $prodDurationHours = 1. / 3600;
7446 } elseif ($this->duration_unit ==
'i' || $this->duration_unit ==
'mn' || $this->duration_unit ==
'min') {
7447 $prodDurationHours = 1. / 60;
7448 } elseif ($this->duration_unit ==
'h') {
7449 $prodDurationHours = 1.;
7450 } elseif ($this->duration_unit ==
'd') {
7451 $prodDurationHours = 24.;
7452 } elseif ($this->duration_unit ==
'w') {
7453 $prodDurationHours = 24. * 7;
7454 } elseif ($this->duration_unit ==
'm') {
7455 $prodDurationHours = 24. * 30;
7456 } elseif ($this->duration_unit ==
'y') {
7457 $prodDurationHours = 24. * 365;
7461 $this->errors[] =
'ErrorDurationForServiceNotDefinedCantCalculateHourlyPrice';
7464 $prodDurationHours *= $this->duration_value;
7466 return $prodDurationHours;
7479 global $langs,
$conf;
7481 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
7483 $return =
'<div class="box-flex-item box-flex-grow-zero">';
7484 $return .=
'<div class="info-box info-box-sm">';
7485 $return .=
'<div class="info-box-img">';
7487 if ($this->entity !==
null && $this->
is_photo_available($conf->product->multidir_output[$this->entity])) {
7488 $label .= $this->
show_photos(
'product', $conf->product->multidir_output[$this->entity], 1, 1, 0, 0, 0, 120, 160, 0, 0, 0,
'',
'photoref photokanban');
7498 $return .=
'</div>';
7499 $return .=
'<div class="info-box-content">';
7500 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . $this->
getNomUrl() .
'</span>';
7501 if ($selected >= 0) {
7502 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
7504 $return .=
'<br><span class="info-box-label opacitymedium inline-block tdoverflowmax150 valignmiddle" title="'.dol_escape_htmltag($this->label).
'">'.
dol_escape_htmltag($this->label).
'</span>';
7505 if ($this->price_base_type ==
'TTC') {
7506 $return .=
'<br><span class="info-box-status amount">'.price($this->price_ttc).
' '.$langs->trans(
"TTC").
'</span>';
7509 $return .=
'<br><span class="info-box-status amount">'.price($this->
price).
' '.$langs->trans(
"HT").
'</span>';
7514 $return .=
'<br><div class="info-box-status opacitymedium inline-block valignmiddle">'.img_picto($langs->trans(
'PhysicalStock'),
'stock').
'</div><div class="inline-block valignmiddle paddingleft" title="'.$langs->trans(
'PhysicalStock').
'">'.$this->stock_reel.
'</div>';
7519 $return .=
'<div class="info-box-status inline-block valignmiddle">'.$this->getLibStatut(3, 1).
' '.$this->
getLibStatut(3, 0).
'</div>';
7521 $return .=
'<div class="info-box-status inline-block valignmiddle marginleftonly paddingleft">'.$this->getLibStatut(3, 1).
' '.$this->
getLibStatut(3, 0).
'</div>';
7523 $return .=
'</div>';
7524 $return .=
'</div>';
7525 $return .=
'</div>';
7536 public $picto =
'service';
if(! $sortfield) if(! $sortorder) $object
length_accountg($account)
Return General accounting account with defined length (used for product and miscellaneous)
clean_account($account)
Return accounting account without zero on the right.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
deleteEcmFiles($mode=0)
Delete related files of object in database.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
setErrorsFromObject($object)
setErrorsFromObject
isObjectUsed($id=0, $entity=0)
Function to check if an object is used by others (by children).
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
show_photos($modulepart, $sdir, $size=0, $nbmax=0, $nbbyrow=5, $showfilename=0, $showaction=0, $maxHeight=120, $maxWidth=160, $nolink=0, $overwritetitle=0, $usesharelink=0, $cache='', $addphotorefcss='photoref')
Show photos of an object (nbmax maximum), into several columns.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
addThumbs($file, $quality=50)
Build thumb.
Class to manage Dolibarr database access.
Class to manage ECM files.
const STATUS_OPEN_INTERNAL
Warehouse open and only operations for stock transfers/corrections allowed (not for customer shipping...
const STATUS_OPEN_ALL
Warehouse open and any operations are allowed (customer shipping, supplier dispatch,...
const STATUS_CLOSED
Warehouse closed, inactive.
const STATUS_CLOSED
Closed status -> parcel was received by customer / end of process prev status : validated or shipment...
const STATUS_VALIDATED
Validated status -> parcel is ready to be sent prev status : draft next status : closed or shipment_i...
const STATUS_DRAFT
Draft status.
Class to manage stock movements.
Class to parse product price expressions.
Class ProductCombination Used to represent the relation between a product and one of its variants.
File of class to manage predefined price products or services by customer.
Class to manage predefined suppliers products.
Class to manage products or services.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
get_nb_achat($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units or supplier invoices in which product is included.
getSellPrice($thirdparty_seller, $thirdparty_buyer, $pqp=0)
Return price of sell of a product for a seller/buyer/product.
__construct($db)
Constructor.
is_sousproduit($fk_parent, $fk_child)
Check if it is a sub-product into a kit.
const DISABLED_STOCK
Stockable product.
const SELL_OR_EAT_BY_MANDATORY_ID_NONE
Const sell or eat by mandatory id.
isStockManaged()
Return if the object is managed in stock.
setPriceExpression($expression_id)
Sets the supplier price expression.
getArrayForPriceCompare($level=0)
used to check if price have really change to avoid log pollution
get_arbo_each_prod($multiply=1, $ignore_stock_load=0)
Build the tree of subproducts and return it.
list_suppliers()
Return list of suppliers providing the product or service.
load_stats_mo($socid=0)
Charge tableau des stats OF pour le produit/service.
isVariant()
Return if loaded product is a variant.
updatePrice($newprice, $newpricebase, $user, $newvat=null, $newminprice=0, $level=0, $newnpr=0, $newpbq=0, $ignore_autogen=0, $localtaxes_array=array(), $newdefaultvatcode='', $price_label='', $notrigger=0)
Modify customer price of a product/Service for a given level.
hasVariants()
Return if a product has variants or not.
load_stats_proposal_supplier($socid=0)
Charge tableau des stats propale pour le produit/service.
getLibFinished()
Retour label of nature of product.
add_sousproduit($id_pere, $id_fils, $qty, $incdec=1, $notrigger=0)
Link a product/service to a parent product/service.
add_fournisseur($user, $id_fourn, $ref_fourn, $quantity)
Add a supplier price for the product.
setMultiLangs($user, $notrigger=0)
Update or add a translation for a product.
hasFatherOrChild($mode=0)
Count all parent and children products for current product (first level only)
load_stats_facturerec($socid=0)
Load array of statistics for recurring invoice for product/service.
get_nb_propalsupplier($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units in proposals in which product is included.
load_stats_facturefournrec($socid=0)
Load array of statistics for recurring supplier invoice for product/service.
get_nb_contract($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units in orders in which product is included.
load_stats_facture_fournisseur($socid=0)
Load array of statistics for vendor invoice for product/service.
get_nb_ordersupplier($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units in orders in which product is included.
getMultiLangs()
Load array this->multilangs.
get_nb_mos($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units in orders in which product is included.
clone_associations($fromId, $toId)
Clone links between products.
create($user, $notrigger=0)
Insert product into database.
load_stats_contrat($socid=0)
Charge tableau des stats contrat pour le produit/service.
isService()
Return if the object is a service.
getRights()
Returns the rights used for this class.
loadBatchInfo($batch)
Load existing information about a serial.
load_stock($option='', $includedraftpoforvirtual=null, $dateofvirtualstock=null)
Load information about stock of a product into ->stock_reel, ->stock_warehouse[] (including stock_war...
getProductDurationHours()
Return the duration of a service in hours (for a service based on duration fields)
get_buyprice($prodfournprice, $qty, $product_id=0, $fourn_ref='', $fk_soc=0)
Read price used by a provider.
clone_fournisseurs($fromId, $toId)
Copies the suppliers and supplier pricing of a product/service onto another one.
const TYPE_PRODUCT
Regular product.
fetchAllPriceLogs($id)
Get all price change logs for a product, enriched with supplier info.
add_photo($sdir, $file)
Move an uploaded file described into $file array into target directory $sdir.
log_price_delete($user, $rowid)
Delete a price line of this product.
info($id)
Load information for tab info.
correct_stock($user, $id_entrepot, $nbpiece, $movement, $label='', $price=0, $inventorycode='', $origin_element='', $origin_id=null, $disablestockchangeforsubproduct=0, $extrafields=null)
Adjust stock in a warehouse for product.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
Create a document onto disk according to template module.
static getSellOrEatByMandatoryList()
Get the array of labels of Sell by or Eat by all mandatory flags for each status.
getChildsArbo($id, $firstlevelonly=0, $level=1, $parents=array())
Return children of product $id.
load_virtual_stock($includedraftpoforvirtual=null, $dateofvirtualstock=null)
Load value ->stock_theorique of a product.
load_stats_propale($socid=0)
Charge tableau des stats propale pour le produit/service.
get_barcode($object, $type='')
Get a barcode from the module to generate barcode values.
setAccountancyCode($type, $value)
Sets an accountancy code for a product.
load_stats_facture($socid=0)
Charge tableau des stats facture pour le produit/service.
setCategories($categories)
Sets object to supplied categories.
load_stats_reception($socid=0, $filtrestatut='', $forVirtualStock=0, $dateofvirtualstock=null)
Loads supplier reception statistics table for given product or service.
get_nb_propal($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units in proposals in which product is included.
update($id, $user, $notrigger=0, $action='update', $updatetype=false)
Update a record into database.
correct_stock_batch($user, $id_entrepot, $nbpiece, $movement, $label='', $price=0, $dlc='', $dluo='', $lot='', $inventorycode='', $origin_element='', $origin_id=null, $disablestockchangeforsubproduct=0, $extrafields=null, $force_update_batch=false)
Adjust stock in a warehouse for product with batch number.
load_stats_bom($socid=0)
Charge tableau des stats OF pour le produit/service.
hasbatch()
Return if the object has a batch management.
del_sousproduit($fk_parent, $fk_child, $notrigger=0)
Remove a link between a subproduct and a parent product/service.
fetch($id=0, $ref='', $ref_ext='', $barcode='', $ignore_expression=0, $ignore_price_load=0, $ignore_lang_load=0)
Load a product in memory from database.
update_sousproduit($id_pere, $id_fils, $qty, $incdec=1, $notrigger=0)
Modify composed product.
load_stats_commande($socid=0, $filtrestatut='', $forVirtualStock=0)
Charge tableau des stats commande client pour le produit/service.
delete_photo($file)
Delete a photo and its thumbs.
fetch_prod_arbo($prod, $compl_path='', $multiply=1, $level=1, $id_parent=0, $ignore_stock_load=0)
Function recursive, used only by get_arbo_each_prod(), to build tree of subproducts into ->res Define...
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
getLibStatut($mode=0, $type=0)
Return label of status of object.
load_stats_sending($socid=0, $filtrestatut='', $forVirtualStock=0, $filterShipmentStatus='')
Charge tableau des stats expedition client pour le produit/service.
clone_price($fromId, $toId)
Recopie les prix d'un produit/service sur un autre.
load_stats_inproduction($socid=0, $filtrestatut='', $forVirtualStock=0, $dateofvirtualstock=null, $warehouseid=0)
Charge tableau des stats production pour le produit/service.
delMultiLangs($langtodelete, $user, $notrigger=0)
Delete a language for this product.
check()
Check that ref and label are ok.
initAsSpecimen()
Initialise an instance with random values.
liste_photos($dir, $nbmax=0)
Return an array with all photos of product found on disk.
loadStateBoard()
Load indicators this->nb for the dashboard.
getFather()
Return all parent products for current product (first level only)
getNomUrl($withpicto=0, $option='', $maxlength=0, $save_lastsearch_value=-1, $notooltip=0, $morecss='', $add_label=0, $sep=' - ')
Return clickable link of object (with eventually picto)
getSellOrEatByMandatoryLabel()
Get the label for sell by or eat by mandatory flag of the current product.
verify()
Check properties of product are ok (like name, barcode, ...).
get_nb_order($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units in orders in which product is included.
loadStockForVirtualProduct($option='', $qtyWish=1)
Load stock for components of virtual product (first level only)
min_recommended_price()
Return minimum product recommended price.
_log_price($user, $level=0)
Insert a track that we changed a customer price.
getLabelOfUnit($type='long', $outputlangs=null, $noentities=0)
Reads the units dictionary to return the translation code of a unit (if type='code'),...
_get_stats($sql, $mode, $year=0)
Return an array formatted for showing graphs.
load_stats_commande_fournisseur($socid=0, $filtrestatut='', $forVirtualStock=0, $dateofvirtualstock=null)
Charge tableau des stats commande fournisseur pour le produit/service.
isMandatoryPeriod()
Return if the object has a constraint on mandatory_period.
isProduct()
Return if the object is a product.
generateMultiprices(User $user, $baseprice, $price_type, $price_vat, $npr, $psq)
Generates prices for a product based on product multiprice generation rules.
LibStatut($status, $mode=0, $type=0)
Return label of a given status.
const TYPE_SERVICE
Service.
is_photo_available($sdir)
Return if at least one photo is available.
get_image_size($file)
Load size of image file.
get_nb_vente($socid, $mode, $filteronproducttype=-1, $year=0, $morefilter='')
Return nb of units or customers invoices in which product is included.
getTooltipContentArray($params)
getTooltipContentArray
Class to manage products or services.
Manage record for batch number management.
static findAll($dbs, $fk_product_stock, $with_qty=0, $fk_product=0)
Return all batch detail records for a given product and warehouse.
Class with list of lots and properties.
Class to manage translations.
Class to manage Dolibarr users.
hasRight($module, $permlevel1, $permlevel2='')
Return if a user has a permission.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0, $level=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_is_file($pathoffile)
Return if path is a file.
dol_move_uploaded_file($src_file, $dest_file, $allowoverwrite, $disablevirusscan=0, $uploaderrorcode=0, $nohook=0, $keyforsourcefile='addedfile', $upload_dir='', $mode=0)
Check validity of a file upload from an GUI page, and move it to its final destination.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dol_osencode($str)
Return a string encoded into OS filesystem encoding.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_string_nospecial($str, $newstr='_', $badcharstoreplace='', $badcharstoremove='', $keepspaces=0)
Clean a string from all punctuation characters to use it as a ref or login.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
if(!function_exists( 'dol_getprefix')) dol_include_once($relpath, $classname='')
Make an include_once using default root and alternate root if it fails.
get_default_npr(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that returns whether VAT must be recoverable collected VAT (e.g.: VAT NPR in France)
yn($yesno, $format=1, $color=0)
Return yes or no in current language.
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
dol_clone($srcobject, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '...' if string larger than length.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
utf8_check($str)
Check if a string is in UTF8.
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
image_format_supported($file, $acceptsvg=0)
Return if a filename is file name of a supported image format.
query($query, $usesavepoint=0, $type='auto', $result_mode=0)
Execute a SQL request and return the resultset.
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
buildzip.php
measuring_units_squared($unitscale)
Transform a given unit scale into the square of that unit, if known.
measuringUnitString($unitid, $measuring_style='', $unitscale=null, $use_short_label=0, $outputlangs=null)
Return translation label of a unit key.
measuring_units_cubed($unit)
Transform a given unit scale into the cube of that unit, if known.
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...