40require
'../main.inc.php';
41require_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
42require_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
43require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_expression.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/core/class/extrafields.class.php';
59 require_once DOL_DOCUMENT_ROOT.
'/product/class/productcustomerprice.class.php';
65$langs->loadLangs(array(
'products',
'bills',
'companies',
'other'));
72$action =
GETPOST(
'action',
'aZ09');
73$cancel =
GETPOST(
'cancel',
'alpha');
76$search_soc =
GETPOST(
'search_soc');
79$fieldvalue = (!empty($id) ?
$id : (!empty($ref) ? $ref :
''));
80$fieldtype = (!empty($ref) ?
'ref' :
'rowid');
82 $socid = $user->socid;
86if ($id > 0 || !empty($ref)) {
94 $conf->global->PRODUIT_MULTIPRICES_LIMIT = 5;
98$hookmanager->initHooks(array(
'productpricecard',
'globalcard'));
101 if (
$object->type == $object::TYPE_PRODUCT) {
104 if (
$object->type == $object::TYPE_SERVICE) {
108 restrictedArea($user,
'produit|service', $fieldvalue,
'product&product',
'',
'', $fieldtype);
111$maxpricesupplier = 0;
114 $permissiontoadd =
$object->getRights()->creer;
116 $permissiontoadd = ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'));
128$parameters = array(
'id' => $id,
'ref' => $ref);
129$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
134if (empty($reshook)) {
135 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
139 if ($action ==
'setlabelsellingprice' && $user->admin) {
140 require_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
141 $keyforlabel =
'PRODUIT_MULTIPRICES_LABEL'.GETPOST(
'pricelevel');
146 if (($action ==
'update_vat') && !$cancel && $permissiontoadd) {
147 $tva_tx_txt =
GETPOST(
'tva_tx',
'alpha');
149 $price_label =
GETPOST(
'price_label',
'alpha');
152 $tva_tx = $tva_tx_txt;
155 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
156 $vatratecode = $reg[1];
157 $tva_tx = preg_replace(
'/\s*\(.*\)/',
'', $tva_tx_txt);
160 $tva_tx =
price2num(preg_replace(
'/\*/',
'', $tva_tx));
161 $npr = preg_match(
'/\*/', $tva_tx_txt) ? 1 : 0;
164 $localtax1_type =
'0';
165 $localtax2_type =
'0';
168 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
170 $vatratecode = $reg[1];
172 $sql =
"SELECT t.rowid, t.type_vat, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
173 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
174 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
175 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
176 $sql .=
" AND t.code = '".$db->escape($vatratecode).
"'";
177 $sql .=
" AND t.type_vat IN (0, 1)";
178 $sql .=
" AND t.entity IN (".getEntity(
'c_tva').
")";
179 $resql = $db->query($sql);
181 $obj = $db->fetch_object($resql);
183 $npr = $obj->recuperableonly;
184 $localtax1 = $obj->localtax1;
185 $localtax2 = $obj->localtax2;
186 $localtax1_type = $obj->localtax1_type;
187 $localtax2_type = $obj->localtax2_type;
192 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
193 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
194 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
195 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
196 $sql .=
" AND t.code = ''";
197 $sql .=
" AND t.entity IN (".getEntity(
'c_tva').
")";
198 $resql = $db->query($sql);
200 $obj = $db->fetch_object($resql);
202 $npr = $obj->recuperableonly;
203 $localtax1 = $obj->localtax1;
204 $localtax2 = $obj->localtax2;
205 $localtax1_type = $obj->localtax1_type;
206 $localtax2_type = $obj->localtax2_type;
211 $object->default_vat_code = $vatratecode;
214 $object->localtax1_tx = $localtax1;
215 $object->localtax2_tx = $localtax2;
216 $object->localtax1_type = $localtax1_type;
217 $object->localtax2_type = $localtax2_type;
218 $object->price_label = $price_label;
230 $produit_multiprices_limit =
getDolGlobalInt(
'PRODUIT_MULTIPRICES_LIMIT');
231 for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
233 if (
$object->multiprices_base_type[$i] ==
'HT') {
234 $oldprice =
$object->multiprices[$i];
235 $oldminprice =
$object->multiprices_min[$i];
237 $oldprice =
$object->multiprices_ttc[$i];
238 $oldminprice =
$object->multiprices_min_ttc[$i];
240 $oldpricebasetype =
$object->multiprices_base_type[$i];
241 $oldnpr =
$object->multiprices_recuperableonly[$i];
244 $localtaxarray = array();
246 $ret =
$object->updatePrice($oldprice, $oldpricebasetype, $user, (
float) $tva_tx, $oldminprice, $level, $oldnpr, 0, 0, $localtaxarray, $vatratecode, $price_label);
255 if (
$object->price_base_type ==
'HT') {
257 $oldminprice =
$object->price_min;
259 $oldprice =
$object->price_ttc;
260 $oldminprice =
$object->price_min_ttc;
262 $oldpricebasetype =
$object->price_base_type;
266 $localtaxarray = array();
268 $ret =
$object->updatePrice($oldprice, $oldpricebasetype, $user, (
float) $tva_tx, $oldminprice, $level, $oldnpr, 0, 0, $localtaxarray, $vatratecode, $price_label);
286 $maxpricesupplier = 0;
288 if (($action ==
'update_price' || $action ==
'update_level_price') && !$cancel && $permissiontoadd) {
290 $pricestoupdate = array();
295 $maxpricesupplier =
$object->min_recommended_price();
300 if (isModEnabled(
'dynamicprices')) {
301 $object->fk_price_expression = empty($eid) ? 0 : $eid;
303 if (
$object->fk_price_expression != 0) {
305 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
308 if ($priceparser->parseProduct($object) < 0) {
317 || ($action ==
'update_level_price' &&
getDolGlobalString(
'PRODUIT_CUSTOMER_PRICES_AND_MULTIPRICES')))) {
318 $newprice =
GETPOST(
'price',
'array');
319 $newprice_min =
GETPOST(
'price_min',
'array');
320 $newpricebase =
GETPOST(
'multiprices_base_type',
'array');
321 $newvattx =
GETPOST(
'tva_tx',
'array');
322 $newvatnpr =
GETPOST(
'tva_npr',
'array');
323 $newlocaltax1_tx =
GETPOST(
'localtax1_tx',
'array');
324 $newlocaltax1_type =
GETPOST(
'localtax1_type',
'array');
325 $newlocaltax2_tx =
GETPOST(
'localtax2_tx',
'array');
326 $newlocaltax2_type =
GETPOST(
'localtax2_type',
'array');
329 $object->price_autogen = (int) (
GETPOST(
'usePriceRules') ==
'on');
331 $produit_multiprices_limit =
getDolGlobalInt(
'PRODUIT_MULTIPRICES_LIMIT');
332 for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
333 if (!isset($newprice[$i])) {
337 $tva_tx_txt = $newvattx[$i];
339 $tva_tx = $tva_tx_txt;
342 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
343 $vat_src_code = $reg[1];
344 $tva_tx = preg_replace(
'/\s*\(.*\)/',
'', $tva_tx_txt);
346 $tva_tx =
price2num(preg_replace(
'/\*/',
'', $tva_tx));
348 $npr = preg_match(
'/\*/', $tva_tx_txt) ? 1 : 0;
349 $localtax1 = $newlocaltax1_tx[$i];
350 $localtax1_type = $newlocaltax1_type[$i];
351 $localtax2 = $newlocaltax2_tx[$i];
352 $localtax2_type = $newlocaltax2_type[$i];
353 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
355 $vatratecode = $reg[1];
357 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
358 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
359 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
360 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
361 $sql .=
" AND t.code ='".$db->escape($vatratecode).
"'";
362 $sql .=
" AND t.entity IN (".getEntity(
'c_tva').
")";
363 $resql = $db->query($sql);
365 $obj = $db->fetch_object($resql);
367 $npr = $obj->recuperableonly;
368 $localtax1 = $obj->localtax1;
369 $localtax2 = $obj->localtax2;
370 $localtax1_type = $obj->localtax1_type;
371 $localtax2_type = $obj->localtax2_type;
375 if (in_array($mysoc->country_code, array(
'ES'))) {
382 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
383 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
384 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
385 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
386 $sql .=
" AND t.code = ''";
387 $resql = $db->query($sql);
389 $obj = $db->fetch_object($resql);
391 $npr = $obj->recuperableonly;
392 $localtax1 = $obj->localtax1;
393 $localtax2 = $obj->localtax2;
394 $localtax1_type = $obj->localtax1_type;
395 $localtax2_type = $obj->localtax2_type;
400 $pricestoupdate[$i] = array(
401 'price' =>
price2num($newprice[$i],
'', 2),
402 'price_min' =>
price2num($newprice_min[$i],
'', 2),
403 'price_base_type' => $newpricebase[$i],
404 'default_vat_code' => $vatratecode,
407 'localtaxes_array' => array(
'0' => $localtax1_type,
'1' => $localtax1,
'2' => $localtax2_type,
'3' => $localtax2)
418 $newpricebase =
GETPOST(
'price_base_type',
'alpha');
419 $tva_tx_txt =
GETPOST(
'tva_tx',
'alpha');
420 $price_label =
GETPOST(
'price_label',
'alpha');
422 $tva_tx = $tva_tx_txt;
425 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
426 $vat_src_code = $reg[1];
427 $tva_tx = preg_replace(
'/\s*\(.*\)/',
'', $tva_tx_txt);
429 $tva_tx =
price2num(preg_replace(
'/\*/',
'', $tva_tx));
431 $npr = preg_match(
'/\*/', $tva_tx_txt) ? 1 : 0;
434 $localtax1_type =
'0';
435 $localtax2_type =
'0';
437 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
439 $vatratecode = $reg[1];
441 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
442 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
443 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
444 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
445 $sql .=
" AND t.code ='".$db->escape($vatratecode).
"'";
446 $sql .=
" AND t.entity IN (".getEntity(
'c_tva').
")";
447 $resql = $db->query($sql);
449 $obj = $db->fetch_object($resql);
451 $npr = $obj->recuperableonly;
452 $localtax1 = $obj->localtax1;
453 $localtax2 = $obj->localtax2;
454 $localtax1_type = $obj->localtax1_type;
455 $localtax2_type = $obj->localtax2_type;
459 if (in_array($mysoc->country_code, array(
'ES'))) {
466 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
467 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
468 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
469 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
470 $sql .=
" AND t.code = ''";
471 $resql = $db->query($sql);
473 $obj = $db->fetch_object($resql);
475 $npr = $obj->recuperableonly;
476 $localtax1 = $obj->localtax1;
477 $localtax2 = $obj->localtax2;
478 $localtax1_type = $obj->localtax1_type;
479 $localtax2_type = $obj->localtax2_type;
484 $pricestoupdate[0] = array(
485 'price' => $newprice,
486 'price_label' => $price_label,
487 'price_min' => $newprice_min,
488 'price_base_type' => $newpricebase,
489 'default_vat_code' => $vatratecode,
492 'localtaxes_array' => array(
'0' => $localtax1_type,
'1' => $localtax1,
'2' => $localtax2_type,
'3' => $localtax2)
501 $object->packaging = (float) $packaging;
504 foreach ($pricestoupdate as $key => $val) {
505 $newprice = $val[
'price'];
507 if ($val[
'price'] < $val[
'price_min'] && !empty(
$object->fk_price_expression)) {
508 $newprice = $val[
'price_min'];
512 $newprice_min =
price2num($val[
'price_min'],
'MU');
515 if (
getDolGlobalString(
'PRODUCT_MINIMUM_RECOMMENDED_PRICE') && $newprice_min < $maxpricesupplier) {
516 setEventMessages($langs->trans(
"MinimumPriceLimit",
price($maxpricesupplier, 0,
'', 1, - 1, - 1,
'auto')),
null,
'errors');
521 if (!array_key_exists($key,
$object->multiprices) ||
$object->multiprices[$key] != $newprice ||
$object->multiprices_min[$key] != $newprice_min ||
$object->multiprices_base_type[$key] != $val[
'price_base_type'] ||
$object->multiprices_tva_tx[$key] != $newvattx) {
522 $res =
$object->updatePrice((
float) $newprice, $val[
'price_base_type'], $user, (
float) $val[
'vat_tx'], (
float) $newprice_min, $key, $val[
'npr'], $psq, 0, $val[
'localtaxes_array'], $val[
'default_vat_code'], $val[
'price_label']);
534 $price_extralabels = $extrafields->fetch_name_optionals_label(
"product_price");
536 $sql =
"SELECT rowid";
537 $sql .=
" FROM ".$object->db->prefix().
"product_price";
538 $sql .=
" WHERE entity IN (".getEntity(
'productprice').
")";
539 $sql .=
" AND price_level=".((int) $key);
540 $sql .=
" AND fk_product = ".((int)
$object->id);
541 $sql .=
" ORDER BY date_price DESC, rowid DESC";
543 $resql =
$object->db->query($sql);
545 $lineid =
$object->db->fetch_object($resql);
548 if (!empty($lineid->rowid)) {
549 foreach ($price_extralabels as $code => $label) {
550 $code_array =
GETPOST($code,
'array');
551 $object->array_options[
'options_'.$code] = $code_array[$key];
555 $object->table_element =
'product_price';
556 $result =
$object->insertExtraFields();
559 $object->table_element =
'product';
578 $action =
'edit_price';
584 if ($action ==
'delete' && $user->hasRight(
'produit',
'supprimer')) {
592 if ($action ==
'activate_price_by_qty' && $permissiontoadd) {
604 if ($action ==
'disable_price_by_qty' && $permissiontoadd) {
616 if ($action ==
'edit_price_by_qty') {
621 if ($action ==
'update_price_by_qty' && $permissiontoadd) {
631 if (empty($quantity)) {
633 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"Qty")),
null,
'errors');
635 if (empty($newprice)) {
637 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"Price")),
null,
'errors');
641 if (
$object->price_base_type ==
'TTC') {
646 $unitPrice =
price2num((
float) $price / (
float) $quantity,
'MU');
650 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"product_price_by_qty SET";
651 $sql .=
" price=".((float) $price).
",";
652 $sql .=
" unitprice=".((float) $unitPrice).
",";
653 $sql .=
" quantity=".((float) $quantity).
",";
654 $sql .=
" remise_percent=".((float) $remise_percent).
",";
655 $sql .=
" remise=".((float) $remise);
656 $sql .=
" WHERE rowid = ".((int) $rowid);
658 $result = $db->query($sql);
663 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"product_price_by_qty (fk_product_price,price,unitprice,quantity,remise_percent,remise) values (";
664 $sql .= ((int) $priceid).
','.((float) $price).
','.((float) $unitPrice).
','.((float) $quantity).
','.((float) $remise_percent).
','.((float) $remise).
')';
666 $result = $db->query($sql);
668 if ($db->lasterrno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
678 if ($action ==
'delete_price_by_qty' && $permissiontoadd) {
680 if (!empty($rowid)) {
681 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_price_by_qty";
682 $sql .=
" WHERE rowid = ".((int) $rowid);
684 $result = $db->query($sql);
686 setEventMessages((
'delete_price_by_qty'.$langs->transnoentities(
'MissingIds')),
null,
'errors');
690 if ($action ==
'delete_all_price_by_qty' && $permissiontoadd) {
692 if (!empty($rowid)) {
693 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_price_by_qty";
694 $sql .=
" WHERE fk_product_price = ".((int) $priceid);
696 $result = $db->query($sql);
698 setEventMessages((
'delete_price_by_qty'.$langs->transnoentities(
'MissingIds')),
null,
'errors');
707 if ($action ==
'add_customer_price_confirm' && !$cancel && $prodcustprice !==
null && ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
708 $maxpricesupplier =
$object->min_recommended_price();
710 $update_child_soc =
GETPOSTINT(
'updatechildprice');
714 $prodcustprice->ref_customer =
GETPOST(
'ref_customer',
'alpha');
715 $prodcustprice->fk_product =
$object->id;
718 $prodcustprice->price_base_type =
GETPOST(
"price_base_type",
'alpha');
719 $prodcustprice->price_label =
GETPOST(
"price_label",
'alpha');
724 $extralabels = $extrafields->fetch_name_optionals_label(
"product_customer_price");
725 $extrafield_values = $extrafields->getOptionalsFromPost(
"product_customer_price");
727 $tva_tx_txt =
GETPOST(
"tva_tx",
'alpha');
729 $tva_tx = $tva_tx_txt;
731 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
732 $vat_src_code = $reg[1];
733 $tva_tx = preg_replace(
'/\s*\(.*\)/',
'', $tva_tx_txt);
735 $tva_tx =
price2num(preg_replace(
'/\*/',
'', $tva_tx));
737 $npr = preg_match(
'/\*/', $tva_tx_txt) ? 1 : 0;
740 $localtax1_type =
'0';
741 $localtax2_type =
'0';
743 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
745 $vatratecode = $reg[1];
747 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
748 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
749 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
750 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
751 $sql .=
" AND t.code ='".$db->escape($vatratecode).
"'";
752 $sql .=
" AND t.entity IN (".getEntity(
'c_tva').
")";
753 $resql = $db->query($sql);
755 $obj = $db->fetch_object($resql);
757 $npr = $obj->recuperableonly;
758 $localtax1 = $obj->localtax1;
759 $localtax2 = $obj->localtax2;
760 $localtax1_type = $obj->localtax1_type;
761 $localtax2_type = $obj->localtax2_type;
765 if (in_array($mysoc->country_code, array(
'ES'))) {
772 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
773 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
774 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
775 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
776 $sql .=
" AND t.code = ''";
777 $resql = $db->query($sql);
779 $obj = $db->fetch_object($resql);
781 $npr = $obj->recuperableonly;
782 $localtax1 = $obj->localtax1;
783 $localtax2 = $obj->localtax2;
784 $localtax1_type = $obj->localtax1_type;
785 $localtax2_type = $obj->localtax2_type;
790 $prodcustprice->default_vat_code = $vatratecode;
791 $prodcustprice->tva_tx = $tva_tx;
792 $prodcustprice->recuperableonly = $npr;
793 $prodcustprice->localtax1_tx = $localtax1;
794 $prodcustprice->localtax2_tx = $localtax2;
795 $prodcustprice->localtax1_type = $localtax1_type;
796 $prodcustprice->localtax2_type = $localtax2_type;
798 if (!($prodcustprice->fk_soc > 0)) {
799 $langs->load(
"errors");
800 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"ThirdParty")),
null,
'errors');
802 $action =
'add_customer_price';
804 if (
getDolGlobalString(
'PRODUCT_MINIMUM_RECOMMENDED_PRICE') && $prodcustprice->price_min < (
float) $maxpricesupplier) {
805 $langs->load(
"errors");
806 setEventMessages($langs->trans(
"MinimumPriceLimit",
price((
float) $maxpricesupplier, 0,
'', 1, -1, -1,
'auto')),
null,
'errors');
808 $action =
'add_customer_price';
812 $result = $prodcustprice->create($user, 0, $update_child_soc);
814 if (!empty($extrafield_values) && is_array($extrafield_values)) {
816 $res = $productcustomerprice->fetch($prodcustprice->id);
818 foreach ($extrafield_values as $key => $value) {
819 $productcustomerprice->array_options[$key] = $value;
821 $result2 = $productcustomerprice->insertExtraFields();
823 $prodcustprice->error = $productcustomerprice->error;
824 $prodcustprice->errors = $productcustomerprice->errors;
833 $action =
'add_customer_price';
841 if ($action ==
'confirm_remove_customer_price' && $prodcustprice !==
null && ($user->hasRight(
'produit',
'supprimer') || $user->hasRight(
'service',
'supprimer'))) {
843 $update_child_soc =
GETPOSTINT(
'updatechildprice');
846 $result = $prodcustprice->delete($user, 0, $update_child_soc);
849 $db->query(
"DELETE FROM ".MAIN_DB_PREFIX.
"product_customer_price_extrafields WHERE fk_object = ".((
int) $prodcustprice->id));
864 if ($action ==
'update_customer_price_confirm' && !$cancel && $prodcustprice !==
null && ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
865 $maxpricesupplier =
$object->min_recommended_price();
867 $update_child_soc =
GETPOSTINT(
'updatechildprice');
872 $prodcustprice->ref_customer =
GETPOST(
'ref_customer',
'alpha');
875 $prodcustprice->price_base_type =
GETPOST(
"price_base_type",
'alpha');
876 $prodcustprice->price_label =
GETPOST(
"price_label",
'alpha');
881 $extralabels = $extrafields->fetch_name_optionals_label(
"product_customer_price");
882 $extrafield_values = $extrafields->getOptionalsFromPost(
"product_customer_price");
884 $tva_tx_txt =
GETPOST(
"tva_tx");
886 $tva_tx = $tva_tx_txt;
888 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
889 $vat_src_code = $reg[1];
890 $tva_tx = preg_replace(
'/\s*\(.*\)/',
'', $tva_tx_txt);
892 $tva_tx =
price2num(preg_replace(
'/\*/',
'', $tva_tx));
894 $npr = preg_match(
'/\*/', $tva_tx_txt) ? 1 : 0;
897 $localtax1_type =
'0';
898 $localtax2_type =
'0';
900 if (preg_match(
'/\((.*)\)/', $tva_tx_txt, $reg)) {
902 $vatratecode = $reg[1];
904 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
905 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
906 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
907 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
908 $sql .=
" AND t.code ='".$db->escape($vatratecode).
"'";
909 $sql .=
" AND t.entity IN (".getEntity(
'c_tva').
")";
910 $resql = $db->query($sql);
912 $obj = $db->fetch_object($resql);
914 $npr = $obj->recuperableonly;
915 $localtax1 = $obj->localtax1;
916 $localtax2 = $obj->localtax2;
917 $localtax1_type = $obj->localtax1_type;
918 $localtax2_type = $obj->localtax2_type;
922 if (in_array($mysoc->country_code, array(
'ES'))) {
929 $sql =
"SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
930 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c";
931 $sql .=
" WHERE t.fk_pays = c.rowid AND c.code = '".$db->escape($mysoc->country_code).
"'";
932 $sql .=
" AND t.taux = ".((float) $tva_tx).
" AND t.active = 1";
933 $sql .=
" AND t.code = ''";
934 $resql = $db->query($sql);
936 $obj = $db->fetch_object($resql);
938 $npr = $obj->recuperableonly;
939 $localtax1 = $obj->localtax1;
940 $localtax2 = $obj->localtax2;
941 $localtax1_type = $obj->localtax1_type;
942 $localtax2_type = $obj->localtax2_type;
947 $prodcustprice->default_vat_code = $vatratecode;
948 $prodcustprice->tva_tx = $tva_tx;
949 $prodcustprice->recuperableonly = $npr;
950 $prodcustprice->localtax1_tx = $localtax1;
951 $prodcustprice->localtax2_tx = $localtax2;
952 $prodcustprice->localtax1_type = $localtax1_type;
953 $prodcustprice->localtax2_type = $localtax2_type;
955 if ($prodcustprice->price_min < $maxpricesupplier &&
getDolGlobalString(
'PRODUCT_MINIMUM_RECOMMENDED_PRICE')) {
956 setEventMessages($langs->trans(
"MinimumPriceLimit",
price($maxpricesupplier, 0,
'', 1, -1, -1,
'auto')),
null,
'errors');
958 $action =
'update_customer_price';
962 $result = $prodcustprice->update($user, 0, $update_child_soc);
964 if (!empty($extrafield_values) && is_array($extrafield_values)) {
966 $res = $productcustomerprice->fetch($prodcustprice->id);
968 foreach ($extrafield_values as $key => $value) {
969 $productcustomerprice->array_options[$key] = $value;
971 $result2 = $productcustomerprice->insertExtraFields();
973 $prodcustprice->error = $productcustomerprice->error;
974 $prodcustprice->errors = $productcustomerprice->errors;
983 $action =
'update_customer_price';
997$form =
new Form($db);
999if (!empty($id) || !empty($ref)) {
1004$title = $langs->trans(
'ProductServiceCard');
1008 $title = $langs->trans(
'Product').
" ".$shortlabel.
" - ".$langs->trans(
'SellingPrices');
1009 $helpurl =
'EN:Module_Products|FR:Module_Produits|ES:Módulo_Productos';
1012 $title = $langs->trans(
'Service').
" ".$shortlabel.
" - ".$langs->trans(
'SellingPrices');
1013 $helpurl =
'EN:Module_Services_En|FR:Module_Services|ES:Módulo_Servicios';
1016llxHeader(
'', $title, $helpurl,
'', 0, 0,
'',
'',
'',
'classforhorizontalscrolloftabs mod-product page-price');
1018if ($action ==
'ask_remove_customer_price' && ($user->hasRight(
'produit',
'supprimer') || $user->hasRight(
'service',
'supprimer'))) {
1019 $formquestion = array(
1020 array(
'type' =>
'checkbox',
'name' =>
'updatechildprice',
'label' => $langs->trans(
'ForceDeleteChildPriceSoc'),
'value' => 0),
1022 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&lineid='.
GETPOSTINT(
'lineid'), $langs->trans(
'DeleteCustomerPrice'), $langs->trans(
'ConfirmDeleteCustomerPrice'),
'confirm_remove_customer_price', $formquestion, 0, 1);
1027$titre = $langs->trans(
"CardProduct".
$object->type);
1032$linkback =
'<a href="'.DOL_URL_ROOT.
'/product/list.php?restore_lastsearch_values=1&type='.
$object->type.
'">'.$langs->trans(
"BackToList").
'</a>';
1033$object->next_prev_filter =
"(te.fk_product_type:=:".((int)
$object->type).
")";
1036if ($user->socid && !in_array(
'product', explode(
',',
getDolGlobalString(
'MAIN_MODULES_FOR_EXTERNAL')))) {
1040dol_banner_tab($object,
'ref', $linkback, $shownav,
'ref');
1043print
'<div class="fichecenter">';
1045print
'<div class="underbanner clearboth"></div>';
1046print
'<table class="border tableforfield centpercent">';
1053 if (!empty($socid)) {
1056 $soc->fetch($socid);
1059 if (isModEnabled(
"product") && isModEnabled(
"service")) {
1060 $typeformat =
'select;0:'.$langs->trans(
"Product").
',1:'.$langs->trans(
"Service");
1061 print
'<tr><td class="">';
1062 print (!
getDolGlobalString(
'PRODUCT_DENY_CHANGE_PRODUCT_TYPE')) ? $form->editfieldkey(
"Type",
'fk_product_type', (
string)
$object->type, $object, 0, $typeformat) : $langs->trans(
'Type');
1064 print $form->editfieldval(
"Type",
'fk_product_type',
$object->type, $object, 0, $typeformat);
1069 print
'<tr><td class="titlefieldcreate">';
1070 print $langs->trans(
"SellingPrice");
1072 print
'<td colspan="2">';
1073 if (
$object->multiprices_base_type[$soc->price_level] ==
'TTC') {
1074 print
'<span class="amount">'.price(
$object->multiprices_ttc[$soc->price_level]).
'</span>';
1076 print
'<span class="amount">'.price(
$object->multiprices[$soc->price_level]).
'</span>';
1078 if (
$object->multiprices_base_type[$soc->price_level]) {
1079 print
' '.$langs->trans(
$object->multiprices_base_type[$soc->price_level]);
1081 print
' '.$langs->trans(
$object->price_base_type);
1086 print
'<tr><td>'.$langs->trans(
"MinPrice").
'</td><td colspan="2">';
1087 if (
$object->multiprices_base_type[$soc->price_level] ==
'TTC') {
1088 print
price(
$object->multiprices_min_ttc[$soc->price_level]).
' '.$langs->trans(
$object->multiprices_base_type[$soc->price_level]);
1090 print
price(
$object->multiprices_min[$soc->price_level]).
' '.$langs->trans(empty(
$object->multiprices_base_type[$soc->price_level]) ?
'HT' :
$object->multiprices_base_type[$soc->price_level]);
1096 print
'<tr><td>'.$langs->trans(
"DefaultTaxRate").
'</td><td colspan="2">';
1098 $positiverates =
'';
1100 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->multiprices_tva_tx[$soc->price_level]);
1103 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->multiprices_localtax1_tx[$soc->price_level]);
1106 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->multiprices_localtax2_tx[$soc->price_level]);
1108 if (empty($positiverates)) {
1109 $positiverates =
'0';
1111 echo
vatrate($positiverates.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), true,
$object->tva_npr);
1116 print
'<tr><td>'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
1118 $positiverates =
'';
1123 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->localtax1_tx);
1126 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->localtax2_tx);
1128 if (empty($positiverates)) {
1129 $positiverates =
'0';
1131 echo
vatrate($positiverates.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), true,
$object->tva_npr);
1143 if (isModEnabled(
"product") && isModEnabled(
"service")) {
1144 $typeformat =
'select;0:'.$langs->trans(
"Product").
',1:'.$langs->trans(
"Service");
1145 print
'<tr><td class="">';
1146 print (!
getDolGlobalString(
'PRODUCT_DENY_CHANGE_PRODUCT_TYPE')) ? $form->editfieldkey(
"Type",
'fk_product_type', (
string)
$object->type, $object, 0, $typeformat) : $langs->trans(
'Type');
1148 print $form->editfieldval(
"Type",
'fk_product_type',
$object->type, $object, 0, $typeformat);
1153 print
'<tr><td class="titlefieldcreate">'.$langs->trans(
"DefaultTaxRate").
'</td>';
1154 print
'<td colspan="2">'.vatrate(
$object->multiprices_tva_tx[1],
true).
'</td>';
1158 if (isModEnabled(
"product") && isModEnabled(
"service")) {
1159 $typeformat =
'select;0:'.$langs->trans(
"Product").
',1:'.$langs->trans(
"Service");
1160 print
'<tr><td class="">';
1161 print (!
getDolGlobalString(
'PRODUCT_DENY_CHANGE_PRODUCT_TYPE')) ? $form->editfieldkey(
"Type",
'fk_product_type', (
string)
$object->type, $object, 0, $typeformat) : $langs->trans(
'Type');
1163 print $form->editfieldval(
"Type",
'fk_product_type',
$object->type, $object, 0, $typeformat);
1168 print
'<!-- Default VAT Rate -->';
1169 print
'<tr><td class="titlefieldcreate">'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
1172 $positiverates =
'';
1174 $positiverates .= ($positiverates ?
'<span class="opacitymedium">/</span>' :
'').
price2num(
$object->tva_tx);
1177 $positiverates .= ($positiverates ?
'<span class="opacitymedium">/</span>' :
'').
price2num(
$object->localtax1_tx);
1180 $positiverates .= ($positiverates ?
'<span class="opacitymedium">/</span>' :
'').
price2num(
$object->localtax2_tx);
1182 if (empty($positiverates)) {
1183 $positiverates =
'0';
1186 print
vatrate($positiverates.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), true,
$object->tva_npr, 1);
1199 print
'<table class="liste centpercent">';
1200 print
'<tr class="liste_titre"><td>';
1201 print $langs->trans(
"PriceLevel");
1203 print
' <a class="editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?action=editlabelsellingprice&token='.
newToken().
'&pricelevel='.$i.
'&id='.
$object->id.
'">'.
img_edit($langs->trans(
'EditSellingPriceLabel'), 0).
'</a>';
1206 print
'<td style="text-align: right">'.$langs->trans(
"SellingPrice").
'</td>';
1207 print
'<td style="text-align: right">'.$langs->trans(
"MinPrice").
'</td>';
1209 $extrafields->fetch_name_optionals_label(
"product_price");
1210 if ($extrafields->attributes[
"product_price"] && array_key_exists(
'label', $extrafields->attributes[
"product_price"])) {
1211 $extralabels = $extrafields->attributes[
"product_price"][
'label'];
1212 if (!empty($extralabels)) {
1213 foreach ($extralabels as $key => $value) {
1215 if (!empty($extrafields->attributes[
"product_price"][
'list'][$key]) && $extrafields->attributes[
"product_price"][
'list'][$key] != 3) {
1216 if (!empty($extrafields->attributes[
"product_price"][
'langfile'][$key])) {
1217 $langs->load($extrafields->attributes[
"product_price"][
'langfile'][$key]);
1219 if (!empty($extrafields->attributes[
"product_price"][
'help'][$key])) {
1220 $extratitle = $form->textwithpicto($langs->trans($value), $langs->trans($extrafields->attributes[
"product_price"][
'help'][$key]));
1222 $extratitle = $langs->trans($value);
1224 $field =
'ef.' . $key;
1225 print
'<td style="text-align: right">'.$extratitle.
'</td>';
1232 $produit_multiprices_limit =
getDolGlobalInt(
'PRODUIT_MULTIPRICES_LIMIT');
1233 for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
1234 print
'<tr class="oddeven">';
1238 $keyforlabel =
'PRODUIT_MULTIPRICES_LABEL'.$i;
1239 if (preg_match(
'/editlabelsellingprice/', $action)) {
1240 print
'<form method="post" action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'">';
1241 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1242 print
'<input type="hidden" name="action" value="setlabelsellingprice">';
1243 print
'<input type="hidden" name="pricelevel" value="'.$i.
'">';
1244 print $langs->trans(
"SellingPrice").
' '.$i.
' - ';
1245 print
'<input class="maxwidthonsmartphone" type="text" name="labelsellingprice" value="' .
getDolGlobalString($keyforlabel).
'">';
1246 print
' <input type="submit" class="button smallpaddingimp" value="'.$langs->trans(
"Modify").
'">';
1249 print $langs->trans(
"SellingPrice").
' '.$i;
1256 if (
$object->multiprices_base_type [$i] ==
'TTC') {
1257 print
'<td class="right"><span class="amount">'.price(
$object->multiprices_ttc[$i]);
1259 print
'<td class="right"><span class="amount">'.price(
$object->multiprices[$i]);
1262 if (
$object->multiprices_base_type[$i]) {
1263 print
' '.$langs->trans(
$object->multiprices_base_type [$i]).
'</span></td>';
1265 print
' '.$langs->trans(
$object->price_base_type).
'</span></td>';
1269 print
'<td style="text-align: right">';
1270 if (empty(
$object->multiprices_base_type[$i])) {
1271 $object->multiprices_base_type[$i] =
"HT";
1273 if (
$object->multiprices_base_type[$i] ==
'TTC') {
1274 print
price(
$object->multiprices_min_ttc[$i]).
' '.$langs->trans(
$object->multiprices_base_type[$i]);
1276 print
price(
$object->multiprices_min[$i]).
' '.$langs->trans(
$object->multiprices_base_type[$i]);
1279 if (!empty($extralabels)) {
1280 $sql1 =
"SELECT rowid";
1281 $sql1 .=
" FROM ".$object->db->prefix().
"product_price";
1282 $sql1 .=
" WHERE entity IN (".getEntity(
'productprice').
")";
1283 $sql1 .=
" AND price_level=".((int) $i);
1284 $sql1 .=
" AND fk_product = ".((int)
$object->id);
1285 $sql1 .=
" ORDER BY date_price DESC, rowid DESC";
1286 $sql1 .=
" LIMIT 1";
1287 $resql1 =
$object->db->query($sql1);
1289 $lineid =
$object->db->fetch_object($resql1);
1292 $sql2 .=
" fk_object";
1293 foreach ($extralabels as $key => $value) {
1294 $sql2 .=
", ".$db->sanitize($key);
1296 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"product_price_extrafields";
1297 $sql2 .=
" WHERE fk_object = ".((int) $lineid->rowid);
1298 $resql2 = $db->query($sql2);
1300 if ($db->num_rows($resql2) != 1) {
1301 foreach ($extralabels as $key => $value) {
1302 if (!empty($extrafields->attributes[
"product_price"][
'list'][$key]) && $extrafields->attributes[
"product_price"][
'list'][$key] != 3) {
1303 print
'<td align="right"></td>';
1307 $obj = $db->fetch_object($resql2);
1308 foreach ($extralabels as $key => $value) {
1309 if (!empty($extrafields->attributes[
"product_price"][
'list'][$key]) && $extrafields->attributes[
"product_price"][
'list'][$key] != 3) {
1310 print
'<td align="right">'.$extrafields->showOutputField($key, $obj->{$key},
'',
'product_price').
"</td>";
1322 print
'<tr><td>'.$langs->trans(
"PriceByQuantity").
' '.$i;
1326 print
'</td><td colspan="2">';
1328 if (
$object->prices_by_qty[$i] == 1) {
1329 print
'<table width="50%" class="border" summary="List of quantities">';
1331 print
'<tr class="liste_titre">';
1332 print
'<td>'.$langs->trans(
"PriceByQuantityRange").
' '.$i.
'</td>';
1333 print
'<td class="right">'.$langs->trans(
"HT").
'</td>';
1334 print
'<td class="right">'.$langs->trans(
"UnitPrice").
'</td>';
1335 print
'<td class="right">'.$langs->trans(
"Discount").
'</td>';
1336 print
'<td> </td>';
1339 foreach (
$object->prices_by_qty_list[$i] as $ii => $prices) {
1340 if ($action ==
'edit_price_by_qty' && $rowid == $prices[
'rowid'] && ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
1341 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1342 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1343 print
'<input type="hidden" name="action" value="update_price_by_qty">';
1344 print
'<input type="hidden" name="priceid" value="'.$object->prices_by_qty_id[$i].
'">';
1345 print
'<input type="hidden" value="'.$prices[
'rowid'].
'" name="rowid">';
1346 print
'<tr class="'.($ii % 2 == 0 ?
'pair' :
'impair').
'">';
1347 print
'<td><input size="5" type="text" value="'.$prices[
'quantity'].
'" name="quantity"></td>';
1348 print
'<td class="right" colspan="2"><input size="10" type="text" value="'.price2num($prices[
'price'],
'MU').
'" name="price"> '.
$object->price_base_type.
'</td>';
1349 print
'<td class="right nowraponall"><input size="5" type="text" value="'.$prices[
'remise_percent'].
'" name="remise_percent"> %</td>';
1350 print
'<td class="center"><input type="submit" value="'.$langs->trans(
"Modify").
'" class="button"></td>';
1354 print
'<tr class="'.($ii % 2 == 0 ?
'pair' :
'impair').
'">';
1355 print
'<td>'.$prices[
'quantity'].
'</td>';
1356 print
'<td class="right">'.price($prices[
'price']).
'</td>';
1357 print
'<td class="right">'.price($prices[
'unitprice']).
'</td>';
1358 print
'<td class="right">'.price($prices[
'remise_percent']).
' %</td>';
1359 print
'<td class="center">';
1360 if (($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
1361 print
'<a class="editfielda marginleftonly marginrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=edit_price_by_qty&token='.
newToken().
'&rowid='.$prices[
"rowid"].
'">';
1363 print
'<a class="marginleftonly marginrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=delete_price_by_qty&token='.
newToken().
'&rowid='.$prices[
"rowid"].
'">';
1372 if ($action !=
'edit_price_by_qty' && ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
1373 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1374 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1375 print
'<input type="hidden" name="action" value="update_price_by_qty">';
1376 print
'<input type="hidden" name="priceid" value="'.$object->prices_by_qty_id[$i].
'">';
1377 print
'<input type="hidden" value="0" name="rowid">';
1378 print
'<tr class="'.($ii % 2 == 0 ?
'pair' :
'impair').
'">';
1379 print
'<td><input size="5" type="text" value="1" name="quantity"></td>';
1380 print
'<td class="right" class="nowrap"><input size="10" type="text" value="0" name="price"> '.$object->price_base_type.
'</td>';
1381 print
'<td class="right"> </td>';
1382 print
'<td class="right" class="nowraponall"><input size="5" type="text" value="0" name="remise_percent"> %</td>';
1383 print
'<td class="center"><input type="submit" value="'.$langs->trans(
"Add").
'" class="button"></td>';
1389 print
'<a class="editfielda marginleftonly marginrightonly" href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=disable_price_by_qty&level='.$i.
'&token='.
newToken().
'">('.$langs->trans(
"DisablePriceByQty").
')</a>';
1391 print $langs->trans(
"No");
1392 print
' <a class="marginleftonly marginrightonly" href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=activate_price_by_qty&level='.$i.
'&token='.
newToken().
'">('.$langs->trans(
"Activate").
')</a>';
1400 print
'<tr><td class="titlefield">'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
1402 $positiverates =
'';
1407 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->localtax1_tx);
1410 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->localtax2_tx);
1412 if (empty($positiverates)) {
1413 $positiverates =
'0';
1415 echo
vatrate($positiverates.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), true,
$object->tva_npr, 0, 1);
1425 print
'<tr class="field_selling_price"><td>'.$langs->trans(
"SellingPrice").
'</td><td>';
1426 if (
$object->price_base_type ==
'TTC') {
1431 print
'<i class="opacitymedium"> - ' .
price(
$object->price_ttc).
' '.$langs->trans(
'TTC') .
'</i>';
1438 print
'<tr class="field_min_price"><td>'.$langs->trans(
"MinPrice").
'</td><td>';
1439 if (
$object->price_base_type ==
'TTC') {
1444 print
'<i class="opacitymedium"> - ' .
price(
$object->price_min_ttc).
' '.$langs->trans(
'TTC') .
'</i>';
1451 print
'<tr class="field_price_label"><td>'.$form->textwithpicto($langs->trans(
"PackagingForThisProduct"), $langs->trans(
"PackagingForThisProductSellDesc")).
'</td><td>';
1457 print
'<tr class="field_price_label"><td>'.$langs->trans(
"PriceLabel").
'</td><td>';
1464 print
'<tr><td>'.$langs->trans(
"PriceByQuantity");
1465 if (
$object->prices_by_qty[0] == 0) {
1466 print
' <a href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=activate_price_by_qty&level=1&token='.
newToken().
'">('.$langs->trans(
"Activate").
')';
1468 print
' <a href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=disable_price_by_qty&level=1&token='.
newToken().
'">('.$langs->trans(
"DisablePriceByQty").
')';
1472 if (
$object->prices_by_qty[0] == 1) {
1473 print
'<table width="50%" class="border" summary="List of quantities">';
1474 print
'<tr class="liste_titre">';
1476 print
'<td>'.$langs->trans(
"Quantity").
'</td>';
1477 print
'<td class="right">'.$langs->trans(
"Price").
'</td>';
1478 print
'<td class="right"></td>';
1479 print
'<td class="right">'.$langs->trans(
"UnitPrice").
'</td>';
1480 print
'<td class="right">'.$langs->trans(
"Discount").
'</td>';
1481 print
'<td> </td>';
1483 if ($action !=
'edit_price_by_qty') {
1484 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1485 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1486 print
'<input type="hidden" name="action" value="update_price_by_qty">';
1487 print
'<input type="hidden" name="priceid" value="'.$object->prices_by_qty_id[0].
'">';
1488 print
'<input type="hidden" value="0" name="rowid">';
1490 print
'<tr class="'.(($ii % 2) == 0 ?
'pair' :
'impair').
'">';
1491 print
'<td><input size="5" type="text" value="1" name="quantity"></td>';
1492 print
'<td class="right"><input class="width50 right" type="text" value="0" name="price"></td>';
1496 print
'<td class="right"> </td>';
1497 print
'<td class="right nowraponall"><input type="text" class="width50 right" value="0" name="remise_percent"> %</td>';
1498 print
'<td class="center"><input type="submit" value="'.$langs->trans(
"Add").
'" class="button"></td>';
1503 foreach (
$object->prices_by_qty_list[0] as $ii => $prices) {
1504 if ($action ==
'edit_price_by_qty' && $rowid == $prices[
'rowid'] && ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
1505 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1506 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1507 print
'<input type="hidden" name="action" value="update_price_by_qty">';
1508 print
'<input type="hidden" name="priceid" value="'.$object->prices_by_qty_id[0].
'">';
1509 print
'<input type="hidden" value="'.$prices[
'rowid'].
'" name="rowid">';
1510 print
'<tr class="'.($ii % 2 == 0 ?
'pair' :
'impair').
'">';
1511 print
'<td><input size="5" type="text" value="'.$prices[
'quantity'].
'" name="quantity"></td>';
1512 print
'<td class="right"><input class="width50 right" type="text" value="'.price2num($prices[
'price'],
'MU').
'" name="price"></td>';
1513 print
'<td class="right">';
1515 print $prices[
'price_base_type'];
1517 print
'<td class="right"> </td>';
1518 print
'<td class="right nowraponall"><input class="width50 right" type="text" value="'.$prices[
'remise_percent'].
'" name="remise_percent"> %</td>';
1519 print
'<td class="center"><input type="submit" value="'.$langs->trans(
"Modify").
'" class="button"></td>';
1523 print
'<tr class="'.($ii % 2 == 0 ?
'pair' :
'impair').
'">';
1524 print
'<td>'.$prices[
'quantity'].
'</td>';
1525 print
'<td class="right">'.price($prices[
'price']).
'</td>';
1526 print
'<td class="right">';
1528 print $prices[
'price_base_type'];
1530 print
'<td class="right">'.price($prices[
'unitprice']).
'</td>';
1531 print
'<td class="right">'.price($prices[
'remise_percent']).
' %</td>';
1532 print
'<td class="center">';
1533 if (($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
1534 print
'<a class="editfielda marginleftonly marginrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=edit_price_by_qty&token='.
newToken().
'&rowid='.$prices[
"rowid"].
'">';
1536 print
'<a class="marginleftonly marginrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=delete_price_by_qty&token='.
newToken().
'&rowid='.$prices[
"rowid"].
'">';
1547 print $langs->trans(
"No");
1556print
'<div class="clearboth"></div>';
1568if (!$action || $action ==
'delete' || $action ==
'showlog_customer_price' || $action ==
'showlog_default_price' || $action ==
'add_customer_price'
1569 || $action ==
'activate_price_by_qty' || $action ==
'disable_price_by_qty') {
1570 print
"\n".
'<div class="tabsAction">'.
"\n";
1573 $parameters = array();
1574 $reshook = $hookmanager->executeHooks(
'addMoreActionsButtons', $parameters, $object, $action);
1575 if (empty($reshook)) {
1577 if ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer')) {
1578 print
'<div class="inline-block divButAction"><a class="butActionRefused classfortooltip" href="#" title="' .
dol_escape_htmltag($langs->trans(
"NoEditVariants")) .
'">' . $langs->trans(
"UpdateDefaultPrice") .
'</a></div>';
1582 if ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer')) {
1583 print
'<div class="inline-block divButAction"><a class="butAction" href="' . $_SERVER[
'PHP_SELF'] .
'?action=edit_price&token='.newToken().
'&id=' .
$object->id .
'">' . $langs->trans(
"UpdateDefaultPrice") .
'</a></div>';
1585 print
'<div class="inline-block divButAction"><span class="butActionRefused" title="'.dol_escape_htmltag($langs->trans(
"NotEnoughPermissions")).
'">' . $langs->trans(
"UpdateDefaultPrice") .
'</span></div>';
1590 if ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer')) {
1591 print
'<div class="inline-block divButAction"><a class="butAction" href="' . $_SERVER[
"PHP_SELF"] .
'?action=add_customer_price&token='.newToken().
'&id=' .
$object->id .
'">' . $langs->trans(
"AddCustomerPrice") .
'</a></div>';
1593 print
'<div class="inline-block divButAction"><span class="butActionRefused" title="'.dol_escape_htmltag($langs->trans(
"NotEnoughPermissions")).
'">' . $langs->trans(
"AddCustomerPrice") .
'</span></div>';
1598 if ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer')) {
1599 print
'<div class="inline-block divButAction"><a class="butAction" href="' . $_SERVER[
'PHP_SELF'] .
'?action=edit_vat&token='.newToken().
'&id=' .
$object->id .
'">' . $langs->trans(
"UpdateVAT") .
'</a></div>';
1601 print
'<div class="inline-block divButAction"><span class="butActionRefused" title="'.dol_escape_htmltag($langs->trans(
"NotEnoughPermissions")).
'">' . $langs->trans(
"UpdateVAT") .
'</span></div>';
1604 if ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer')) {
1605 print
'<div class="inline-block divButAction"><a class="butAction" href="' . $_SERVER[
'PHP_SELF'] .
'?action=edit_level_price&token='.newToken().
'&id=' .
$object->id .
'">' . $langs->trans(
"UpdateLevelPrices") .
'</a></div>';
1607 print
'<div class="inline-block divButAction"><span class="butActionRefused" title="'.dol_escape_htmltag($langs->trans(
"NotEnoughPermissions")).
'">' . $langs->trans(
"UpdateLevelPrices") .
'</span></div>';
1622if ($action ==
'edit_vat' && ($user->hasRight(
'produit',
'creer') || $user->hasRight(
'service',
'creer'))) {
1625 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1626 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1627 print
'<input type="hidden" name="action" value="update_vat">';
1628 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
1632 print
'<table class="border centpercent">';
1635 print
'<tr><td>'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
1645 print $form->buttonsSaveCancel();
1647 print
'<br></form><br>';
1650if (($action ==
'edit_price' || $action ==
'edit_level_price') &&
$object->getRights()->creer) {
1655 print
'<!-- Edit price -->'.
"\n";
1656 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1657 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1658 print
'<input type="hidden" name="action" value="update_price">';
1659 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
1663 print
'<div class="div-table-responsive-no-min">';
1664 print
'<table class="border centpercent">';
1667 print
'<tr><td class="titlefield">'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
1673 print $langs->trans(
'PriceBase');
1676 print $form->selectPriceBaseType(
$object->price_base_type,
"price_base_type");
1681 if (isModEnabled(
'dynamicprices')) {
1683 print
'<!-- Show price mode of dynamicprices editor -->'.
"\n";
1684 print
'<tr><td>'.$langs->trans(
"PriceMode").
'</td><td>';
1685 print
img_picto(
'',
'dynamicprice',
'class="pictofixedwidth"');
1687 $price_expression_list = array(0 => $langs->trans(
"Numeric").
' <span class="opacitymedium">('.$langs->trans(
"NoDynamicPrice").
')</span>');
1688 foreach ($price_expression->list_price_expression() as $entry) {
1689 $price_expression_list[$entry->id] = $entry->title;
1691 $price_expression_preselection =
GETPOST(
'eid') ?
GETPOST(
'eid') : (
$object->fk_price_expression ?
$object->fk_price_expression :
'0');
1692 print $form->selectarray(
'eid', $price_expression_list, $price_expression_preselection);
1693 print
' <a id="expression_editor" class="classlink">'.$langs->trans(
"PriceExpressionEditor").
'</a>';
1699 <script
type=
"text/javascript">
1700 jQuery(document).ready(
function() {
1701 jQuery(
"#expression_editor").click(
function() {
1702 window.location =
"<?php echo DOL_URL_ROOT ?>/product/dynamic_price/editor.php?id=<?php echo $id ?>&tab=price&eid=" + $(
"#eid").val();
1704 jQuery(
"#eid").change(on_change);
1707 function on_change() {
1708 if ($(
"#eid").val() == 0) {
1709 jQuery(
"#price_numeric").show();
1711 jQuery(
"#price_numeric").hide();
1720 $product->fetch($id, $ref,
'',
'1');
1721 print
'<tr id="price_numeric"><td>';
1722 $text = $langs->trans(
'SellingPrice');
1723 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
1725 if (
$object->price_base_type ==
'TTC') {
1726 print
'<input name="price" size="10" value="'.price($product->price_ttc).
'">';
1728 print
'<input name="price" size="10" value="'.price($product->price).
'">';
1734 $text = $langs->trans(
'MinPrice');
1735 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
1737 if (
$object->price_base_type ==
'TTC') {
1738 print
'<input name="price_min" size="10" value="'.price(
$object->price_min_ttc).
'">';
1740 print
'<input name="price_min" size="10" value="'.price(
$object->price_min).
'">';
1743 print
' '.$langs->trans(
"MinimumRecommendedPrice",
price((
float) $maxpricesupplier, 0,
'', 1, -1, -1,
'auto')).
' '.
img_warning().
'</td>';
1751 print $form->textwithpicto($langs->trans(
"PackagingForThisProduct"), $langs->trans(
"PackagingForThisProductSellDesc"));
1753 $packaging =
$object->packaging;
1754 print
'<input class="flat" name="packaging" size="5" value="' .
price($packaging, 0,
'', 1, -1, 2).
'">';
1761 print $langs->trans(
'PriceLabel');
1763 print
'<input name="price_label" maxlength="255" class="minwidth300 maxwidth400onsmartphone" value="'.$object->price_label.
'">';
1767 $parameters = array();
1768 $reshook = $hookmanager->executeHooks(
'formObjectOptions', $parameters, $object, $action);
1775 print $form->buttonsSaveCancel();
1778 } elseif ($action ==
'edit_level_price' &&
$object->getRights()->creer) {
1779 print
'<!-- Edit price per level -->'.
"\n"; ?>
1782 var showHidePriceRules =
function () {
1783 var otherPrices = $(
'div.fiche form table tbody tr:not(:first)');
1784 var minPrice1 = $(
'div.fiche form input[name="price_min[1]"]');
1786 if (jQuery(
'input#usePriceRules').prop(
'checked')) {
1795 jQuery(document).ready(
function () {
1796 showHidePriceRules();
1798 jQuery(
'input#usePriceRules').click(showHidePriceRules);
1803 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
1804 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1805 print
'<input type="hidden" name="action" value="update_level_price">';
1806 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
1811 print $langs->trans(
'UseMultipriceRules').
' <input type="checkbox" id="usePriceRules" name="usePriceRules" '.(
$object->price_autogen ?
'checked' :
'').
'><br><br>';
1814 print
'<div class="div-table-responsive-no-min">';
1815 print
'<table class="noborder">';
1816 print
'<thead><tr class="liste_titre">';
1818 print
'<td>'.$langs->trans(
"PriceLevel").
'</td>';
1821 print
'<td style="text-align: center">'.$langs->trans(
"DefaultTaxRate").
'</td>';
1826 print
'<td class="center">'.$langs->trans(
"SellingPrice").
'</td>';
1828 print
'<td class="center">'.$langs->trans(
"MinPrice").
'</td>';
1835 $extrafields->fetch_name_optionals_label(
"product_price");
1836 if ($extrafields->attributes[
"product_price"] && array_key_exists(
'label', $extrafields->attributes[
"product_price"])) {
1837 $extralabels = $extrafields->attributes[
"product_price"][
'label'];
1838 if (!empty($extralabels)) {
1839 foreach ($extralabels as $key => $value) {
1841 if (!empty($extrafields->attributes[
"product_price"][
'list'][$key]) && $extrafields->attributes[
"product_price"][
'list'][$key] != 3) {
1842 if (!empty($extrafields->attributes[
"product_price"][
'langfile'][$key])) {
1843 $langs->load($extrafields->attributes[
"product_price"][
'langfile'][$key]);
1845 if (!empty($extrafields->attributes[
"product_price"][
'help'][$key])) {
1846 $extratitle = $form->textwithpicto($langs->trans($value), $langs->trans($extrafields->attributes[
"product_price"][
'help'][$key]));
1848 $extratitle = $langs->trans($value);
1850 print
'<td style="text-align: right">'.$extratitle.
'</td>';
1855 print
'</tr></thead>';
1859 $produit_multiprices_limit =
getDolGlobalInt(
'PRODUIT_MULTIPRICES_LIMIT');
1860 for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
1861 print
'<tr class="oddeven">';
1863 $keyforlabel =
'PRODUIT_MULTIPRICES_LABEL'.$i;
1865 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
1871 print
'<input type="hidden" name="tva_tx['.$i.
']" value="'.(
$object->default_vat_code ?
$object->tva_tx.
' ('.
$object->default_vat_code.
')' :
$object->tva_tx).
'">';
1872 print
'<input type="hidden" name="tva_npr['.$i.
']" value="'.
$object->tva_npr.
'">';
1873 print
'<input type="hidden" name="localtax1_tx['.$i.
']" value="'.
$object->localtax1_tx.
'">';
1874 print
'<input type="hidden" name="localtax1_type['.$i.
']" value="'.
$object->localtax1_type.
'">';
1875 print
'<input type="hidden" name="localtax2_tx['.$i.
']" value="'.
$object->localtax2_tx.
'">';
1876 print
'<input type="hidden" name="localtax2_type['.$i.
']" value="'.
$object->localtax2_type.
'">';
1880 print
'<td style="text-align: center">';
1881 print $form->load_tva(
"tva_tx[".$i.
']',
$object->multiprices_tva_tx[$i], $mysoc,
null,
$object->id, 0,
$object->type,
false, 1, 1);
1886 print
'<td style="text-align: center">';
1887 if (
$object->multiprices_base_type [$i] ==
'TTC') {
1888 print
'<input name="price['.$i.
']" size="10" value="'.
price(
$object->multiprices_ttc [$i]).
'">';
1890 print
'<input name="price['.$i.
']" size="10" value="'.
price(
$object->multiprices [$i]).
'">';
1892 print
' '.$form->selectPriceBaseType(
$object->multiprices_base_type [$i],
"multiprices_base_type[".$i.
"]");
1896 print
'<td style="text-align: center">';
1897 if (
$object->multiprices_base_type [$i] ==
'TTC') {
1898 print
'<input name="price_min['.$i.
']" size="10" value="'.
price(
$object->multiprices_min_ttc [$i]).
'">';
1900 print
'<input name="price_min['.$i.
']" size="10" value="'.
price(
$object->multiprices_min [$i]).
'">';
1903 print
'<td class="left">'.$langs->trans(
"MinimumRecommendedPrice",
price((
float) $maxpricesupplier, 0,
'', 1, -1, -1,
'auto')).
' '.
img_warning().
'</td>';
1907 if (!empty($extralabels)) {
1908 $sql1 =
"SELECT rowid";
1909 $sql1 .=
" FROM ".$object->db->prefix().
"product_price";
1910 $sql1 .=
" WHERE entity IN (".getEntity(
'productprice').
")";
1911 $sql1 .=
" AND price_level=".((int) $i);
1912 $sql1 .=
" AND fk_product = ".((int)
$object->id);
1913 $sql1 .=
" ORDER BY date_price DESC, rowid DESC";
1914 $sql1 .=
" LIMIT 1";
1915 $resql1 =
$object->db->query($sql1);
1917 $lineid =
$object->db->fetch_object($resql1);
1919 if (empty($lineid->rowid)) {
1920 foreach ($extralabels as $key => $value) {
1921 if (!empty($extrafields->attributes[
"product_price"][
'list'][$key]) && ($extrafields->attributes[
"product_price"][
'list'][$key] == 1 || $extrafields->attributes[
"product_price"][
'list'][$key] == 3 || ($action ==
"edit_level_price" && $extrafields->attributes[
"product_price"][
'list'][$key] == 4))) {
1922 if (!empty($extrafields->attributes[
"product_price"][
'langfile'][$key])) {
1923 $langs->load($extrafields->attributes[
"product_price"][
'langfile'][$key]);
1926 $extravalue = GETPOSTISSET(
'options_'.$key) ? $extrafield_values[
'options_'.$key] : $obj->{$key};
1927 print
'<td align="center"><input name="'.$key.
'['.$i.
']" size="10" value="'.$extravalue.
'"></td>';
1932 $sql .=
" fk_object";
1933 foreach ($extralabels as $key => $value) {
1934 $sql .=
", ".$db->sanitize($key);
1936 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_price_extrafields";
1937 $sql .=
" WHERE fk_object = ".((int) $lineid->rowid);
1938 $resql = $db->query($sql);
1940 $obj = $db->fetch_object($resql);
1941 foreach ($extralabels as $key => $value) {
1942 if (!empty($extrafields->attributes[
"product_price"][
'list'][$key]) && ($extrafields->attributes[
"product_price"][
'list'][$key] == 1 || $extrafields->attributes[
"product_price"][
'list'][$key] == 3 || ($action ==
"edit_level_price" && $extrafields->attributes[
"product_price"][
'list'][$key] == 4))) {
1943 if (!empty($extrafields->attributes[
"product_price"][
'langfile'][$key])) {
1944 $langs->load($extrafields->attributes[
"product_price"][
'langfile'][$key]);
1947 $extravalue = (GETPOSTISSET(
'options_'.$key) ? $extrafield_values[
'options_'.$key] : $obj->{$key} ??
'');
1948 print
'<td align="center"><input name="'.$key.
'['.$i.
']" size="10" value="'.$extravalue.
'"></td>';
1965 print $form->buttonsSaveCancel();
1976 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
1977 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
1979 if (empty($page) || $page == -1) {
1982 $offset = $limit * $page;
1983 $pageprev = $page - 1;
1984 $pagenext = $page + 1;
1986 $sortorder =
"ASC,ASC";
1989 $sortfield =
"soc.nom,t.date_begin";
1993 $filter = array(
't.fk_product' => (
string)
$object->id);
1995 if (!empty($search_soc)) {
1996 $filter[
'soc.nom'] = (string) $search_soc;
1999 if ($action ==
'add_customer_price') {
2001 $maxpricesupplier =
$object->min_recommended_price();
2003 print
'<!-- add_customer_price -->';
2006 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
2007 print
'<input type="hidden" name="token" value="'.newToken().
'">';
2008 print
'<input type="hidden" name="action" value="add_customer_price_confirm">';
2009 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
2011 print
'<div class="tabBar tabBarWithBottom">';
2013 print
'<table class="border centpercent">';
2015 print
'<td class="fieldrequired">'.$langs->trans(
'ThirdParty').
'</td>';
2017 $filter =
'(s.client:IN:1,2,3)';
2018 print
img_picto(
'',
'company').$form->select_company(
GETPOSTINT(
'socid'),
'socid', $filter,
'SelectThirdParty', 0, 0, array(), 0,
'minwidth300');
2023 print
'<tr><td>' . $langs->trans(
'RefCustomer') .
'</td>';
2024 print
'<td><input name="ref_customer" size="12"></td></tr>';
2028 print
'<tr><td>'.$langs->trans(
"AppliedPricesFrom").
'</td><td>';
2029 print $form->selectDate(!empty($date_begin) ? $date_begin :
dol_now(),
"date_begin", 0, 0, 1,
"date_begin");
2034 print
'<tr><td>'.$langs->trans(
"AppliedPricesTo").
'</td><td>';
2035 print $form->selectDate($date_end,
"date_end", 0, 0, 1,
"date_end");
2039 print
'<tr><td class="fieldrequired">'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
2044 print
'<tr><td class="fieldrequired">';
2045 print $langs->trans(
'PriceBase');
2048 print $form->selectPriceBaseType(
$object->price_base_type,
"price_base_type");
2053 print
'<tr><td class="fieldrequired">';
2054 $text = $langs->trans(
'SellingPrice');
2055 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
2057 if (
$object->price_base_type ==
'TTC') {
2058 print
'<input name="price" size="10" value="'.price(
$object->price_ttc).
'">';
2060 print
'<input name="price" size="10" value="'.price(
$object->price).
'">';
2066 $text = $langs->trans(
'MinPrice');
2067 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
2068 if (
$object->price_base_type ==
'TTC') {
2069 print
'<td><input name="price_min" size="10" value="'.price(
$object->price_min_ttc).
'">';
2071 print
'<td><input name="price_min" size="10" value="'.price(
$object->price_min).
'">';
2074 print
'<td class="left">'.$langs->trans(
"MinimumRecommendedPrice",
price($maxpricesupplier, 0,
'', 1, -1, -1,
'auto')).
' '.
img_warning().
'</td>';
2080 print $langs->trans(
'PriceLabel');
2082 print
'<input name="price_label" maxlength="255" class="minwidth300 maxwidth400onsmartphone" value="'.$object->price_label.
'">';
2088 print
'<tr><td>'.$langs->trans(
"Discount").
'</td><td>';
2089 print
'<input name="discount_percent" size="10" value="'.price($discount_percent).
'">';
2093 $extrafields->fetch_name_optionals_label(
"product_customer_price");
2094 $extralabels = !empty($extrafields->attributes[
"product_customer_price"][
'label']) ? $extrafields->attributes[
"product_customer_price"][
'label'] :
'';
2095 $extrafield_values = $extrafields->getOptionalsFromPost(
"product_customer_price");
2096 if (!empty($extralabels)) {
2097 if (empty($prodcustprice->id)) {
2098 foreach ($extralabels as $key => $value) {
2099 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && ($extrafields->attributes[
"product_customer_price"][
'list'][$key] == 1 || $extrafields->attributes[
"product_customer_price"][
'list'][$key] == 3 || ($action ==
"add_customer_price" && $extrafields->attributes[
"product_customer_price"][
'list'][$key] == 4))) {
2100 if (!empty($extrafields->attributes[
"product_customer_price"][
'langfile'][$key])) {
2101 $langs->load($extrafields->attributes[
"product_customer_price"][
'langfile'][$key]);
2104 print
'<tr><td'.($extrafields->attributes[
"product_customer_price"][
'required'][$key] ?
' class="fieldrequired"' :
'').
'>';
2105 if (!empty($extrafields->attributes[
"product_customer_price"][
'help'][$key])) {
2106 print $form->textwithpicto($langs->trans($value), $langs->trans($extrafields->attributes[
"product_customer_price"][
'help'][$key]));
2108 print $langs->trans($value);
2110 print
'</td><td>'.$extrafields->showInputField($key, GETPOSTISSET(
'options_'.$key) ? $extrafield_values[
'options_'.$key] :
'',
'',
'',
'',
'', 0,
'product_customer_price').
'</td></tr>';
2121 print
'<div class="center">';
2124 print
'<div class="marginbottomonly">';
2125 print
'<input type="checkbox" name="updatechildprice" id="updatechildprice" value="1"> ';
2126 print
'<label for="updatechildprice">'.$langs->trans(
'ForceUpdateChildPriceSoc').
'</label>';
2129 print $form->buttonsSaveCancel();
2132 } elseif ($action ==
'edit_customer_price') {
2134 $maxpricesupplier =
$object->min_recommended_price();
2136 print
'<!-- edit_customer_price -->';
2139 $result = $prodcustprice->fetch(
GETPOSTINT(
'lineid'));
2144 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
2145 print
'<input type="hidden" name="token" value="'.newToken().
'">';
2146 print
'<input type="hidden" name="action" value="update_customer_price_confirm">';
2147 print
'<input type="hidden" name="lineid" value="'.$prodcustprice->id.
'">';
2149 print
'<table class="liste centpercent">';
2151 print
'<td class="titlefield fieldrequired">'.$langs->trans(
'ThirdParty').
'</td>';
2152 $staticsoc =
new Societe($db);
2153 $staticsoc->fetch($prodcustprice->fk_soc);
2154 print
"<td>".$staticsoc->getNomUrl(1).
"</td>";
2158 print
'<tr><td>' . $langs->trans(
'RefCustomer') .
'</td>';
2159 print
'<td><input name="ref_customer" size="12" value="' .
dol_escape_htmltag($prodcustprice->ref_customer) .
'"></td></tr>';
2162 print
'<tr><td>'.$langs->trans(
"AppliedPricesFrom").
'</td><td>';
2163 print $form->selectDate($prodcustprice->date_begin,
"date_begin", 0, 0, 1,
"date_begin");
2167 print
'<tr><td>'.$langs->trans(
"AppliedPricesTo").
'</td><td>';
2168 print $form->selectDate($prodcustprice->date_end,
"date_end", 0, 0, 1,
"date_end");
2172 print
'<tr><td class="fieldrequired">'.$langs->trans(
"DefaultTaxRate").
'</td><td>';
2173 print $form->load_tva(
"tva_tx", $prodcustprice->default_vat_code ? $prodcustprice->tva_tx.
' ('.$prodcustprice->default_vat_code.
')' : $prodcustprice->tva_tx, $mysoc, null,
$object->id, $prodcustprice->recuperableonly,
$object->
type, false, 1, 1);
2177 print
'<tr><td class="fieldrequired">';
2178 print $langs->trans(
'PriceBase');
2181 print $form->selectPriceBaseType($prodcustprice->price_base_type,
"price_base_type");
2186 print
'<tr><td class="fieldrequired">';
2187 $text = $langs->trans(
'SellingPrice');
2188 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
2190 if ($prodcustprice->price_base_type ==
'TTC') {
2191 print
'<input name="price" size="10" value="'.price($prodcustprice->price_ttc).
'">';
2193 print
'<input name="price" size="10" value="'.price($prodcustprice->price).
'">';
2199 $text = $langs->trans(
'MinPrice');
2200 print $form->textwithpicto($text, $langs->trans(
"PrecisionUnitIsLimitedToXDecimals",
getDolGlobalString(
'MAIN_MAX_DECIMALS_UNIT')), 1,
'help');
2202 if ($prodcustprice->price_base_type ==
'TTC') {
2203 print
'<input name="price_min" size="10" value="'.price($prodcustprice->price_min_ttc).
'">';
2205 print
'<input name="price_min" size="10" value="'.price($prodcustprice->price_min).
'">';
2209 print
'<td class="left">'.$langs->trans(
"MinimumRecommendedPrice",
price($maxpricesupplier, 0,
'', 1, -1, -1,
'auto')).
' '.
img_warning().
'</td>';
2215 print $langs->trans(
'PriceLabel');
2217 print
'<input name="price_label" maxlength="255" class="minwidth300 maxwidth400onsmartphone" value="'.$prodcustprice->price_label.
'">';
2222 print
'<tr><td>'.$langs->trans(
"Discount").
'</td><td>';
2223 print
'<input name="discount_percent" size="10" value="'.price($prodcustprice->discount_percent).
'">';
2227 $extrafields->fetch_name_optionals_label(
"product_customer_price");
2228 $extralabels = !empty($extrafields->attributes[
"product_customer_price"][
'label']) ? $extrafields->attributes[
"product_customer_price"][
'label'] :
'';
2229 $extrafield_values = $extrafields->getOptionalsFromPost(
"product_customer_price");
2230 if (!empty($extralabels)) {
2232 foreach ($extralabels as $key => $value) {
2233 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && ($extrafields->attributes[
"product_customer_price"][
'list'][$key] == 1 || $extrafields->attributes[
"product_customer_price"][
'list'][$key] == 3 || ($action ==
"edit_customer_price" && $extrafields->attributes[
"product_customer_price"][
'list'][$key] == 4))) {
2234 if (!empty($extrafields->attributes[
"product_customer_price"][
'langfile'][$key])) {
2235 $langs->load($extrafields->attributes[
"product_customer_price"][
'langfile'][$key]);
2238 print
'<tr><td'.($extrafields->attributes[
"product_customer_price"][
'required'][$key] ?
' class="fieldrequired"' :
'').
'>';
2239 if (!empty($extrafields->attributes[
"product_customer_price"][
'help'][$key])) {
2240 print $form->textwithpicto($langs->trans($value), $langs->trans($extrafields->attributes[
"product_customer_price"][
'help'][$key]));
2242 print $langs->trans($value);
2244 print
'</td><td>'.$extrafields->showInputField($key, GETPOSTISSET(
'options_'.$key) ? $extrafield_values[
'options_'.$key] :
'',
'',
'',
'',
'', 0,
'product_customer_price').
'</td></tr>';
2249 $sql .=
" fk_object";
2250 foreach ($extralabels as $key => $value) {
2251 $sql .=
", ".$db->sanitize($key);
2253 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_customer_price_extrafields";
2254 $sql .=
" WHERE fk_object = ".((int) $prodcustprice->id);
2255 $resql = $db->query($sql);
2257 $obj = $db->fetch_object($resql);
2258 foreach ($extralabels as $key => $value) {
2259 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && ($extrafields->attributes[
"product_customer_price"][
'list'][$key] == 1 || $extrafields->attributes[
"product_customer_price"][
'list'][$key] == 3 || ($action ==
"edit_customer_price" && $extrafields->attributes[
"product_customer_price"][
'list'][$key] == 4))) {
2260 if (!empty($extrafields->attributes[
"product_customer_price"][
'langfile'][$key])) {
2261 $langs->load($extrafields->attributes[
"product_customer_price"][
'langfile'][$key]);
2264 print
'<tr><td'.($extrafields->attributes[
"product_customer_price"][
'required'][$key] ?
' class="fieldrequired"' :
'').
'>';
2265 if (!empty($extrafields->attributes[
"product_customer_price"][
'help'][$key])) {
2266 print $form->textwithpicto($langs->trans($value), $langs->trans($extrafields->attributes[
"product_customer_price"][
'help'][$key]));
2268 print $langs->trans($value);
2270 print
'</td><td>'.$extrafields->showInputField($key, GETPOSTISSET(
'options_'.$key) ? $extrafield_values[
'options_'.$key] : $obj->{$key},
'',
'',
'',
'', 0,
'product_customer_price');
2282 print
'<div class="center">';
2283 print
'<div class="marginbottomonly">';
2284 print
'<input type="checkbox" name="updatechildprice" id="updatechildprice" value="1"> ';
2285 print
'<label for="updatechildprice">'.$langs->trans(
'ForceUpdateChildPriceSoc').
'</label>';
2288 print $form->buttonsSaveCancel();
2290 print
'<br></form>';
2291 } elseif ($action ==
'showlog_customer_price') {
2293 print
'<!-- list of all log of prices per customer -->'.
"\n";
2295 $sortfield =
't.datec';
2296 $filter = array(
't.fk_product' => (
string)
$object->id,
't.fk_soc' => (
string)
GETPOSTINT(
'socid'));
2299 $nbtotalofrecords =
'';
2301 $nbtotalofrecords = $prodcustprice->fetchAllLog($sortorder, $sortfield,
$conf->liste_limit, $offset, $filter);
2304 $result = $prodcustprice->fetchAllLog($sortorder, $sortfield,
$conf->liste_limit, $offset, $filter);
2309 $option =
'&socid='.GETPOSTINT(
'socid').
'&id='.
$object->id;
2311 $staticsoc =
new Societe($db);
2314 $title = $langs->trans(
'PriceByCustomerLog');
2315 $title .=
' - '.$staticsoc->getNomUrl(1);
2317 $backbutton =
'<a class="justalink" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'">'.$langs->trans(
"Back").
'</a>';
2320 print_barre_liste($title, $page, $_SERVER[
'PHP_SELF'], $option, $sortfield, $sortorder, $backbutton, count($prodcustprice->lines), $nbtotalofrecords,
'title_accountancy.png');
2322 if (count($prodcustprice->lines) > 0) {
2323 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
2324 print
'<input type="hidden" name="token" value="'.newToken().
'">';
2325 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
2327 print
'<div class="div-table-responsive-no-min">';
2328 print
'<table class="liste centpercent">';
2330 print
'<tr class="liste_titre">';
2331 print
'<td>'.$langs->trans(
"ThirdParty").
'</td>';
2332 print
'<td>'.$langs->trans(
'RefCustomer').
'</td>';
2333 print
'<td>'.$langs->trans(
"AppliedPricesFrom").
'</td>';
2334 print
'<td>'.$langs->trans(
"AppliedPricesTo").
'</td>';
2335 print
'<td class="center">'.$langs->trans(
"PriceBase").
'</td>';
2336 print
'<td class="right">'.$langs->trans(
"DefaultTaxRate").
'</td>';
2337 print
'<td class="right">'.$langs->trans(
"HT").
'</td>';
2338 print
'<td class="right">'.$langs->trans(
"TTC").
'</td>';
2339 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2340 print
'<td class="right">'.$langs->trans(
"INCT").
'</td>';
2342 print
'<td class="right">'.$langs->trans(
"MinPrice").
' '.$langs->trans(
"HT").
'</td>';
2343 print
'<td class="right">'.$langs->trans(
"MinPrice").
' '.$langs->trans(
"TTC").
'</td>';
2344 print
'<td class="right">'.$langs->trans(
"PriceLabel").
'</td>';
2345 print
'<td class="right">'.$langs->trans(
"Discount").
'</td>';
2346 print
'<td class="right">'.$langs->trans(
"ChangedBy").
'</td>';
2347 print
'<td>'.$langs->trans(
"DateCreation").
'</td>';
2350 foreach ($prodcustprice->lines as $line) {
2352 $staticsoc =
new Societe($db);
2353 $staticsoc->fetch($line->fk_soc);
2355 $tva_tx = $line->default_vat_code ? $line->tva_tx.
' ('.$line->default_vat_code.
')' : $line->tva_tx;
2358 if ($line->price_base_type ==
'HT') {
2361 $pu = $line->price_ttc;
2365 $localtaxarray =
getLocalTaxesFromRate($line->tva_tx.($line->default_vat_code ?
' ('.$line->default_vat_code.
')' :
''), 0, $staticsoc, $mysoc);
2367 $resultarray =
calcul_price_total(1, $pu, 0, (
float) $line->tva_tx, 1, 1, 0, $line->price_base_type, $line->recuperableonly,
$object->type, $mysoc, $localtaxarray);
2369 $total_ht = $resultarray[0];
2370 $total_vat = $resultarray[1];
2371 $total_localtax1 = $resultarray[9];
2372 $total_localtax2 = $resultarray[10];
2373 $total_ttc = $resultarray[2];
2375 print
'<tr class="oddeven">';
2377 print
'<td class="tdoverflowmax125">'.$staticsoc->getNomUrl(1).
"</td>";
2378 print
'<td>'.$line->ref_customer.
'</td>';
2379 print
"<td>".dol_print_date($line->date_begin,
"day",
'tzuserrel').
"</td>";
2380 print
"<td>".dol_print_date($line->date_end,
"day",
'tzuserrel').
"</td>";
2381 print
'<td class="center">'.$langs->trans($line->price_base_type).
"</td>";
2382 print
'<td class="right">';
2384 $positiverates =
'';
2386 $positiverates .= ($positiverates ?
'/' :
'').
price2num($line->tva_tx);
2389 $positiverates .= ($positiverates ?
'/' :
'').
price2num($line->localtax1_tx);
2392 $positiverates .= ($positiverates ?
'/' :
'').
price2num($line->localtax2_tx);
2394 if (empty($positiverates)) {
2395 $positiverates =
'0';
2398 echo
vatrate($positiverates.($line->default_vat_code ?
' ('.$line->default_vat_code.
')' :
''), true, ($line->tva_npr ? $line->tva_npr : $line->recuperableonly));
2402 print
'<td class="right"><span class="amount">'.price($line->price).
"</span></td>";
2404 print
'<td class="right"><span class="amount">'.price($line->price_ttc).
"</span></td>";
2405 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2406 print
'<td class="right">'.price($resultarray[2]).
'</td>';
2409 print
'<td class="right">'.price($line->price_min).
'</td>';
2410 print
'<td class="right">'.price($line->price_min_ttc).
'</td>';
2411 print
'<td class="right">'.$line->price_label.
'</td>';
2412 print
'<td class="right">'.price($line->discount_percent).
'</td>';
2415 $userstatic =
new User($db);
2416 $userstatic->fetch($line->fk_user);
2417 print
'<td class="right">';
2418 print $userstatic->getNomUrl(1,
'', 0, 0, 24, 0,
'login');
2421 print
"<td>".dol_print_date($line->datec,
"dayhour",
'tzuserrel').
"</td>";
2427 print $langs->trans(
'None');
2429 } elseif ($action !=
'showlog_default_price' && $action !=
'edit_price' && $action !=
'edit_level_price') {
2431 print
'<!-- list of all prices per customer -->'.
"\n";
2434 $nbtotalofrecords =
'';
2436 $nbtotalofrecords = $prodcustprice->fetchAll($sortorder, $sortfield, 0, 0, $filter);
2439 $result = $prodcustprice->fetchAll($sortorder, $sortfield,
$conf->liste_limit, $offset, $filter);
2444 $option =
'&search_soc='.$search_soc.
'&id='.
$object->id;
2447 print_barre_liste($langs->trans(
'PriceByCustomer'), $page, $_SERVER [
'PHP_SELF'], $option, $sortfield, $sortorder,
'', count($prodcustprice->lines), $nbtotalofrecords,
'title_accountancy.png');
2449 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'" method="POST">';
2450 print
'<input type="hidden" name="token" value="'.newToken().
'">';
2451 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
2453 print
'<!-- List of prices per customer -->'.
"\n";
2454 print
'<div class="div-table-responsive-no-min">'.
"\n";
2455 print
'<table class="liste centpercent">'.
"\n";
2457 if (count($prodcustprice->lines) > 0 || $search_soc) {
2458 $extrafields->fetch_name_optionals_label(
"product_customer_price");
2459 $custom_price_extralabels = !empty($extrafields->attributes[
"product_customer_price"][
'label']) ? $extrafields->attributes[
"product_customer_price"][
'label'] :
'';
2465 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2468 if (!empty($custom_price_extralabels) && is_array($custom_price_extralabels)) {
2469 $colspan += count($custom_price_extralabels);
2472 print
'<tr class="liste_titre">';
2473 print
'<td class="liste_titre"><input type="text" class="flat maxwidth125" name="search_soc" value="'.$search_soc.
'"></td>';
2474 print
'<td class="liste_titre" colspan="'.$colspan.
'"> </td>';
2476 print
'<td class="liste_titre maxwidthsearch">';
2477 $searchpicto = $form->showFilterAndCheckAddButtons(0);
2483 print
'<tr class="liste_titre">';
2484 print
'<td>'.$langs->trans(
"ThirdParty").
'</td>';
2485 print
'<td>'.$langs->trans(
'RefCustomer').
'</td>';
2486 print
'<td>'.$langs->trans(
"AppliedPricesFrom").
'</td>';
2487 print
'<td>'.$langs->trans(
"AppliedPricesTo").
'</td>';
2488 print
'<td class="center">'.$langs->trans(
"PriceBase").
'</td>';
2489 print
'<td class="right">'.$langs->trans(
"DefaultTaxRate").
'</td>';
2490 print
'<td class="right">'.$langs->trans(
"HT").
'</td>';
2491 print
'<td class="right">'.$langs->trans(
"TTC").
'</td>';
2492 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2493 print
'<td class="right">'.$langs->trans(
"INCT").
'</td>';
2495 print
'<td class="right">'.$langs->trans(
"MinPrice").
' '.$langs->trans(
"HT").
'</td>';
2496 print
'<td class="right">'.$langs->trans(
"MinPrice").
' '.$langs->trans(
"TTC").
'</td>';
2497 print
'<td class="right">'.$langs->trans(
"PriceLabel").
'</td>';
2498 print
'<td class="right">'.$langs->trans(
"Discount").
'</td>';
2500 $extrafields->fetch_name_optionals_label(
"product_customer_price");
2501 if ($extrafields->attributes[
"product_customer_price"] && array_key_exists(
'label', $extrafields->attributes[
"product_customer_price"])) {
2502 $extralabels = $extrafields->attributes[
"product_customer_price"][
'label'];
2503 if (!empty($extralabels)) {
2504 foreach ($extralabels as $key => $value) {
2506 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && $extrafields->attributes[
"product_customer_price"][
'list'][$key] != 3) {
2507 if (!empty($extrafields->attributes[
"product_customer_price"][
'langfile'][$key])) {
2508 $langs->load($extrafields->attributes[
"product_customer_price"][
'langfile'][$key]);
2510 if (!empty($extrafields->attributes[
"product_customer_price"][
'help'][$key])) {
2511 $extratitle = $form->textwithpicto($langs->trans($value), $langs->trans($extrafields->attributes[
"product_customer_price"][
'help'][$key]));
2513 $extratitle = $langs->trans($value);
2515 print
'<td style="text-align: right">'.$extratitle.
'</td>';
2520 print
'<td>'.$langs->trans(
"ChangedBy").
'</td>';
2525 if (
$object->price_base_type ==
'HT') {
2532 $localtaxarray =
getLocalTaxesFromRate(
$object->tva_tx.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), 0, $mysoc, $mysoc);
2534 $resultarray =
calcul_price_total(1, $pu, 0,
$object->tva_tx, 1, 1, 0,
$object->price_base_type, 0,
$object->type, $mysoc, $localtaxarray);
2536 $total_ht = $resultarray[0];
2537 $total_vat = $resultarray[1];
2538 $total_localtax1 = $resultarray[9];
2539 $total_localtax2 = $resultarray[10];
2540 $total_ttc = $resultarray[2];
2543 print
'<!-- PRODUIT_CUSTOMER_PRICES_AND_MULTIPRICES -->'.
"\n";
2544 print
'<tr class="oddeven">';
2545 print
'<td colspan="4">' . $langs->trans(
'Default') .
'</td>';
2547 print
'<td class="center">'.$langs->trans(
$object->price_base_type).
"</td>";
2550 print
'<td class="right">';
2552 $positiverates =
'';
2557 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->localtax1_tx);
2560 $positiverates .= ($positiverates ?
'/' :
'').
price2num(
$object->localtax2_tx);
2562 if (empty($positiverates)) {
2563 $positiverates =
'0';
2565 echo
vatrate($positiverates.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), true,
$object->tva_npr);
2571 print
'<td class="right"><span class="amount">'.price(
$object->price).
"</span></td>";
2573 print
'<td class="right"><span class="amount">'.price(
$object->price_ttc).
"</span></td>";
2574 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2576 print
'<td class="right"><span class="amount">'.price($resultarray[2]).
'</span></td>';
2579 print
'<td class="right">'.price(
$object->price_min).
'</td>';
2580 print
'<td class="right">'.price(
$object->price_min_ttc).
'</td>';
2581 print
'<td class="right">'.$object->price_label.
'</td>';
2582 print
'<td class="right"></td>';
2583 print
'<td class="right"></td>';
2584 if (!empty($extralabels)) {
2585 foreach ($extralabels as $key) {
2587 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && $extrafields->attributes[
"product_customer_price"][
'list'][$key] != 3) {
2588 print
'<td class="right"></td>';
2592 if ($user->hasRight(
'produit',
'supprimer') || $user->hasRight(
'service',
'supprimer')) {
2593 print
'<td class="nowraponall">';
2594 print
'<a class="marginleftonly marginrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?action=showlog_default_price&token='.
newToken().
'&id='.
$object->id.
'">';
2595 print
img_info($langs->trans(
'PriceByCustomerLog'));
2598 print
'<a class="marginleftonly marginrightonly editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?action=edit_price&token='.
newToken().
'&id='.
$object->id.
'">';
2599 print
img_edit(
'default', 0,
'style="vertical-align: middle;"');
2606 if (count($prodcustprice->lines) > 0) {
2607 foreach ($prodcustprice->lines as $line) {
2609 $staticsoc =
new Societe($db);
2610 $staticsoc->fetch($line->fk_soc);
2612 $tva_tx = $line->default_vat_code ? $line->tva_tx.
' ('.$line->default_vat_code.
')' : $line->tva_tx;
2615 if ($line->price_base_type ==
'HT') {
2618 $pu = $line->price_ttc;
2622 $localtaxarray =
getLocalTaxesFromRate($line->tva_tx.($line->default_vat_code ?
' ('.$line->default_vat_code.
')' :
''), 0, $staticsoc, $mysoc);
2624 $resultarray =
calcul_price_total(1, $pu, 0, (
float) $line->tva_tx, 1, 1, 0, $line->price_base_type, $line->recuperableonly,
$object->type, $mysoc, $localtaxarray);
2626 $total_ht = $resultarray[0];
2627 $total_vat = $resultarray[1];
2628 $total_localtax1 = $resultarray[9];
2629 $total_localtax2 = $resultarray[10];
2630 $total_ttc = $resultarray[2];
2632 print
'<tr class="oddeven">';
2634 print
'<td class="tdoverflowmax125">'.$staticsoc->getNomUrl(1).
"</td>";
2635 print
'<td>'.dol_escape_htmltag($line->ref_customer).
'</td>';
2636 print
"<td>".dol_print_date($line->date_begin,
"day",
'tzuserrel').
"</td>";
2637 print
"<td>".dol_print_date($line->date_end,
"day",
'tzuserrel').
"</td>";
2638 print
'<td class="center">'.$langs->trans($line->price_base_type).
"</td>";
2640 print
'<td class="right">';
2642 $positiverates =
'';
2644 $positiverates .= ($positiverates ?
'/' :
'').
price2num($line->tva_tx);
2647 $positiverates .= ($positiverates ?
'/' :
'').
price2num($line->localtax1_tx);
2650 $positiverates .= ($positiverates ?
'/' :
'').
price2num($line->localtax2_tx);
2652 if (empty($positiverates)) {
2653 $positiverates =
'0';
2656 echo
vatrate($positiverates.($line->default_vat_code ?
' ('.$line->default_vat_code.
')' :
''), true, (!empty($line->tva_npr) ? $line->tva_npr : $line->recuperableonly));
2660 print
'<td class="right"><span class="amount">'.price($line->price).
"</span></td>";
2662 print
'<td class="right"><span class="amount">'.price($line->price_ttc).
"</span></td>";
2663 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2665 print
'<td class="right"><span class="amount">'.price($resultarray[2]).
'</span></td>';
2668 print
'<td class="right">'.price($line->price_min).
'</td>';
2669 print
'<td class="right">'.price($line->price_min_ttc).
'</td>';
2670 print
'<td class="right">'.$line->price_label.
'</td>';
2671 print
'<td class="right">'.price($line->discount_percent).
'</td>';
2674 $extrafields->fetch_name_optionals_label(
"product_customer_price");
2675 $extralabels = $extrafields->attributes[
"product_customer_price"][
'label'] ?? array();
2676 if (!empty($extralabels)) {
2678 $sql .=
" fk_object";
2679 foreach ($extralabels as $key => $value) {
2680 $sql .=
", ".$db->sanitize($key);
2682 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_customer_price_extrafields";
2683 $sql .=
" WHERE fk_object = ".((int) $line->id);
2684 $resql = $db->query($sql);
2686 if ($db->num_rows($resql) != 1) {
2687 foreach ($extralabels as $key => $value) {
2688 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && $extrafields->attributes[
"product_customer_price"][
'list'][$key] != 3) {
2693 $obj = $db->fetch_object($resql);
2694 foreach ($extralabels as $key => $value) {
2695 if (!empty($extrafields->attributes[
"product_customer_price"][
'list'][$key]) && $extrafields->attributes[
"product_customer_price"][
'list'][$key] != 3) {
2696 print
'<td align="right">'.$extrafields->showOutputField($key, $obj->{$key},
'',
'product_customer_price').
"</td>";
2705 $userstatic =
new User($db);
2706 $userstatic->fetch($line->fk_user);
2709 print $userstatic->getNomUrl(-1,
'', 0, 0, 24, 0,
'login');
2714 if ($user->hasRight(
'produit',
'supprimer') || $user->hasRight(
'service',
'supprimer')) {
2715 print
'<td class="right nowraponall">';
2716 print
'<a href="'.$_SERVER[
"PHP_SELF"].
'?action=showlog_customer_price&token='.
newToken().
'&id='.
$object->id.
'&socid='.$line->fk_soc.
'">';
2717 print
img_info($langs->trans(
'PriceByCustomerLog'));
2720 print
'<a class="marginleftonly editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?action=edit_customer_price&token='.
newToken().
'&id='.
$object->id.
'&lineid='.$line->id.
'">';
2721 print
img_edit(
'default', 0,
'style="vertical-align: middle;"');
2724 print
'<a class="marginleftonly" href="'.$_SERVER[
"PHP_SELF"].
'?action=ask_remove_customer_price&token='.
newToken().
'&id='.
$object->id.
'&lineid='.$line->id.
'">';
2725 print
img_delete(
'default',
'style="vertical-align: middle;"');
2743if ((!
getDolGlobalString(
'PRODUIT_CUSTOMER_PRICES') || $action ==
'showlog_default_price') && !in_array($action, array(
'edit_price',
'edit_level_price',
'edit_vat'))) {
2744 $sql =
"SELECT p.rowid, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.default_vat_code, p.recuperableonly, p.localtax1_tx, p.localtax1_type, p.localtax2_tx, p.localtax2_type,";
2745 $sql .=
" p.price_level, p.price_min, p.price_min_ttc,p.price_by_qty,";
2746 $sql .=
" p.date_price as dp, p.fk_price_expression, u.rowid as user_id, u.login";
2747 $sql .=
" ,p.price_label";
2748 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_price as p,";
2749 $sql .=
" ".MAIN_DB_PREFIX.
"user as u";
2750 $sql .=
" WHERE fk_product = ".((int)
$object->id);
2751 $sql .=
" AND p.entity IN (".getEntity(
'productprice').
")";
2752 $sql .=
" AND p.fk_user_author = u.rowid";
2754 $sql .=
" AND p.price_level = ".((int) $soc->price_level);
2756 $sql .=
" ORDER BY p.date_price DESC, p.rowid DESC, p.price_level ASC";
2760 $result = $db->query($sql);
2762 print
'<div class="divlogofpreviouscustomerprice">';
2764 $num = $db->num_rows($result);
2773 $ret =
$object->updatePrice((
$object->multiprices_base_type[1] ==
'TTC' ?
$object->multiprices_ttc[1] :
$object->multiprices[1]),
$object->multiprices_base_type[1], $user, (empty(
$object->multiprices_tva_tx[1]) ? 0 :
$object->multiprices_tva_tx[1]), (
$object->multiprices_base_type[1] ==
'TTC' ?
$object->multiprices_min_ttc[1] :
$object->multiprices_min[1]), 1);
2781 $result = $db->query($sql);
2782 $num = $db->num_rows($result);
2789 $backbutton =
'<a class="justalink" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'">'.$langs->trans(
"Back").
'</a>';
2793 print_barre_liste($langs->trans(
"DefaultPriceLog"), 0, $_SERVER[
"PHP_SELF"],
'',
'',
'', $backbutton, 0, $num,
'title_accountancy.png');
2796 print_barre_liste($langs->trans(
"PriceByCustomerLog"), 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', 0, $num,
'title_accountancy.png');
2799 print
'<!-- List of log prices -->'.
"\n";
2800 print
'<div class="div-table-responsive">'.
"\n";
2801 print
'<table class="liste centpercent noborder">'.
"\n";
2803 print
'<tr class="liste_titre">';
2804 print
'<th>'.$langs->trans(
"AppliedPricesFrom").
'</tg>';
2807 print
'<th class="center">'.$langs->trans(
"PriceLevel").
'</th>';
2810 print
'<th class="center">'.$langs->trans(
"Type").
'</th>';
2813 print
'<th class="center">'.$langs->trans(
"PriceBase").
'</th>';
2815 print
'<th class="right">'.$langs->trans(
"DefaultTaxRate").
'</th>';
2817 print
'<th class="right">'.$langs->trans(
"HT").
'</th>';
2818 print
'<th class="right">'.$langs->trans(
"TTC").
'</th>';
2819 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2820 print
'<th class="right">'.$langs->trans(
"INCT").
'</th>';
2822 if (isModEnabled(
'dynamicprices')) {
2823 print
'<th class="right">'.$langs->trans(
"PriceExpressionSelected").
'</th>';
2825 print
'<th class="right">'.$langs->trans(
"MinPrice").
' '.$langs->trans(
"HT").
'</th>';
2826 print
'<th class="right">'.$langs->trans(
"MinPrice").
' '.$langs->trans(
"TTC").
'</th>';
2827 print
'<th class="right">'.$langs->trans(
"Label").
'</th>';
2828 print
'<th>'.$langs->trans(
"ChangedBy").
'</th>';
2829 if ($user->hasRight(
'produit',
'supprimer')) {
2830 print
'<th class="right"> </th>';
2834 $notfirstlineforlevel = array();
2838 $objp = $db->fetch_object($result);
2840 print
'<tr class="oddeven">';
2842 print
"<td>".dol_print_date($db->jdate($objp->dp),
"dayhour",
'tzuserrel').
"</td>";
2846 print
'<td class="center">'.$objp->price_level.
"</td>";
2850 $type = ($objp->price_by_qty == 1) ?
'PriceByQuantity' :
'Standard';
2851 print
'<td class="center">'.$langs->trans($type).
"</td>";
2854 print
'<td class="center">';
2855 if (empty($objp->price_by_qty)) {
2856 print $langs->trans($objp->price_base_type);
2861 print
'<td class="right">';
2863 if (empty($objp->price_by_qty)) {
2864 $positiverates =
'';
2866 $positiverates .= ($positiverates ?
'/' :
'').
price2num($objp->tva_tx);
2869 $positiverates .= ($positiverates ?
'/' :
'').
price2num($objp->localtax1_tx);
2872 $positiverates .= ($positiverates ?
'/' :
'').
price2num($objp->localtax2_tx);
2874 if (empty($positiverates)) {
2875 $positiverates =
'0';
2877 echo
vatrate($positiverates.($objp->default_vat_code ?
' ('.$objp->default_vat_code.
')' :
''), true, !empty($objp->tva_npr) ? $objp->tva_npr : 0);
2890 if ($objp->price_base_type ==
'HT') {
2893 $pu = $objp->price_ttc;
2897 $localtaxarray =
getLocalTaxesFromRate($objp->tva_tx.($object->default_vat_code ?
' ('.$object->default_vat_code.
')' :
''), 0, $mysoc, $mysoc);
2899 $resultarray =
calcul_price_total(1, $pu, 0, $objp->tva_tx, 1, 1, 0, $objp->price_base_type, $objp->recuperableonly,
$object->type, $mysoc, $localtaxarray);
2901 $total_ht = $resultarray[0];
2902 $total_vat = $resultarray[1];
2903 $total_localtax1 = $resultarray[9];
2904 $total_localtax2 = $resultarray[10];
2905 $total_ttc = $resultarray[2];
2908 if (!empty($objp->fk_price_expression) && !empty(
$conf->dynamicprices->enabled)) {
2910 $res = $price_expression->fetch($objp->fk_price_expression);
2911 $title = $price_expression->title;
2912 print
'<td class="right"></td>';
2913 print
'<td class="right"></td>';
2914 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2915 print
'<td class="right"></td>';
2917 print
'<td class="right">'.$title.
"</td>";
2920 print
'<td class="right">';
2921 if (empty($objp->price_by_qty)) {
2922 print
'<span class="amount">'.price($objp->price).
'</span>';
2926 print
'<td class="right">';
2927 if (empty($objp->price_by_qty)) {
2928 $price_ttc = $objp->price_ttc;
2929 print
'<span class="amount">'.price($price_ttc).
'<span>';
2932 if ($mysoc->localtax1_assuj ==
"1" || $mysoc->localtax2_assuj ==
"1") {
2933 print
'<td class="right">';
2934 print $resultarray[2];
2937 if (isModEnabled(
'dynamicprices')) {
2938 print
'<td class="right"></td>';
2943 print
'<td class="right">';
2944 if (empty($objp->price_by_qty)) {
2945 print
price($objp->price_min);
2950 print
'<td class="right">';
2951 if (empty($objp->price_by_qty)) {
2952 $price_min_ttc = $objp->price_min_ttc;
2953 print
price($price_min_ttc);
2958 print
'<td class="right">';
2959 print $objp->price_label;
2964 if ($objp->user_id > 0) {
2965 $userstatic =
new User($db);
2966 $userstatic->fetch($objp->user_id);
2967 print $userstatic->getNomUrl(-1,
'', 0, 0, 24, 0,
'login');
2973 if ($user->hasRight(
'produit',
'supprimer')) {
2976 if (empty($notfirstlineforlevel[$objp->price_level])) {
2977 $notfirstlineforlevel[$objp->price_level] = 1;
2985 print
'<td class="right">';
2986 if ($candelete || ($db->jdate($objp->dp) >=
dol_now())) {
2987 print
'<a href="'.$_SERVER[
"PHP_SELF"].
'?action=delete&token='.
newToken().
'&id='.
$object->id.
'&lineid='.$objp->rowid.
'">';
$id
Support class for third parties, contacts, members, users or resources.
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
dolibarr_set_const($db, $name, $value, $type='chaine', $visible=0, $note='', $entity=1)
Insert a parameter (key,value) into database (delete old key then insert it again).
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Class for accessing price expression table.
Class to parse product price expressions.
File of class to manage predefined price products or services by customer.
Class to manage products or services.
const TYPE_PRODUCT
Regular product.
const TYPE_SERVICE
Service.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
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...
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
vatrate($rate, $addpercent=false, $info_bits=0, $usestarfornpr=0, $html=0)
Return a string with VAT rate label formatted for view output Used into pdf and HTML pages.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
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)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
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.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_clone($object, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
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.
img_edit($titlealt='default', $float=0, $other='')
Show logo edit/modify fiche.
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular vat, when selling a product with vat $vatrate,...
img_info($titlealt='default')
Show info logo.
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...
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
product_prepare_head($object)
Prepare array with list of tabs.
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.