dolibarr  19.0.0-dev
combinations.php
1 <?php
2 /* Copyright (C) 2016 Marcos García <marcosgdf@gmail.com>
3  * Copyright (C) 2017 Laurent Destailleur <eldy@users.sourceforge.net>
4  * Copyright (C) 2018-2019 Frédéric France <frederic.france@netlogic.fr>
5  * Copyright (C) 2022 Open-Dsi <support@open-dsi.fr>
6  *
7  * This program is free software; you can redistribute it and/or modify
8  * it under the terms of the GNU General Public License as published by
9  * the Free Software Foundation; either version 3 of the License, or
10  * (at your option) any later version.
11  *
12  * This program is distributed in the hope that it will be useful,
13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15  * GNU General Public License for more details.
16  *
17  * You should have received a copy of the GNU General Public License
18  * along with this program. If not, see <https://www.gnu.org/licenses/>.
19  */
20 
21 // Load Dolibarr environment
22 require '../main.inc.php';
23 require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
24 require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
25 require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductAttribute.class.php';
26 require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductAttributeValue.class.php';
27 require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductCombination.class.php';
28 require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductCombination2ValuePair.class.php';
29 
30 $langs->loadLangs(array("products", "other"));
31 
32 $id = GETPOST('id', 'int');
33 $valueid = GETPOST('valueid', 'int');
34 $ref = GETPOST('ref', 'alpha');
35 $weight_impact = price2num(GETPOST('weight_impact', 'alpha'), 2);
36 $price_impact_percent = (bool) GETPOST('price_impact_percent');
37 if ($price_impact_percent) {
38  $price_impact = price2num(GETPOST('price_impact', 'alpha'), 2);
39 } else {
40  $price_impact = price2num(GETPOST('price_impact', 'alpha'), 'MU');
41 }
42 $level_price_impact = GETPOST('level_price_impact', 'array');
43 $level_price_impact_percent = GETPOST('level_price_impact_percent', 'array');
44 
45 $reference = GETPOST('reference', 'alpha');
46 $form = new Form($db);
47 
48 $action = GETPOST('action', 'aZ09');
49 $massaction = GETPOST('massaction', 'alpha');
50 $show_files = GETPOST('show_files', 'int');
51 $confirm = GETPOST('confirm', 'alpha');
52 $toselect = GETPOST('toselect', 'array');
53 $cancel = GETPOST('cancel', 'alpha');
54 $delete_product = GETPOST('delete_product', 'alpha');
55 $subaction = GETPOST('subaction', 'aZ09');
56 $backtopage = GETPOST('backtopage', 'alpha');
57 $sortfield = GETPOST('sortfield', 'aZ09comma');
58 $sortorder = GETPOST('sortorder', 'aZ09comma');
59 
60 // Security check
61 $fieldvalue = (!empty($id) ? $id : $ref);
62 $fieldtype = (!empty($ref) ? 'ref' : 'rowid');
63 
64 $prodstatic = new Product($db);
65 $prodattr = new ProductAttribute($db);
66 $prodattr_val = new ProductAttributeValue($db);
67 
68 $object = new Product($db);
69 if ($id > 0 || $ref) {
70  $object->fetch($id, $ref);
71 }
72 
73 $selectedvariant = !empty($_SESSION['addvariant_'.$object->id]) ? $_SESSION['addvariant_'.$object->id] : array();
74 $selected = "";
75 // Security check
76 if (!isModEnabled('variants')) {
77  accessforbidden('Module not enabled');
78 }
79 if ($user->socid > 0) { // Protection if external user
81 }
82 
83 if ($object->id > 0) {
84  if ($object->type == $object::TYPE_PRODUCT) {
85  restrictedArea($user, 'produit', $object->id, 'product&product', '', '');
86  }
87  if ($object->type == $object::TYPE_SERVICE) {
88  restrictedArea($user, 'service', $object->id, 'product&product', '', '');
89  }
90 } else {
91  restrictedArea($user, 'produit|service', $fieldvalue, 'product&product', '', '', $fieldtype);
92 }
93 $usercanread = (($object->type == Product::TYPE_PRODUCT && $user->rights->produit->lire) || ($object->type == Product::TYPE_SERVICE && $user->hasRight('service', 'lire')));
94 $usercancreate = (($object->type == Product::TYPE_PRODUCT && $user->rights->produit->creer) || ($object->type == Product::TYPE_SERVICE && $user->hasRight('service', 'creer')));
95 $usercandelete = (($object->type == Product::TYPE_PRODUCT && $user->rights->produit->supprimer) || ($object->type == Product::TYPE_SERVICE && $user->rights->service->supprimer));
96 
97 
98 /*
99  * Actions
100  */
101 
102 if ($cancel) {
103  $action = '';
104  $massaction = '';
105  unset($_SESSION['addvariant_'.$object->id]);
106 }
107 
108 if (!$object->isProduct() && !$object->isService()) {
109  header('Location: '.dol_buildpath('/product/card.php?id='.$object->id, 2));
110  exit();
111 }
112 if ($action == 'add') {
113  unset($selectedvariant);
114  unset($_SESSION['addvariant_'.$object->id]);
115 }
116 if ($action == 'create' && GETPOST('selectvariant', 'alpha')) { // We click on select combination
117  $action = 'add';
118  $attribute_id = GETPOST('attribute', 'int');
119  $attribute_value_id = GETPOST('value', 'int');
120  if ($attribute_id> 0 && $attribute_value_id > 0) {
121  $feature = $attribute_id . '-' . $attribute_value_id;
122  $selectedvariant[$feature] = $feature;
123  $_SESSION['addvariant_'.$object->id] = $selectedvariant;
124  }
125 }
126 if ($action == 'create' && $subaction == 'delete') { // We click on select combination
127  $action = 'add';
128  $feature = GETPOST('feature', 'intcomma');
129  if (isset($selectedvariant[$feature])) {
130  unset($selectedvariant[$feature]);
131  $_SESSION['addvariant_'.$object->id] = $selectedvariant;
132  }
133 }
134 
135 
136 $prodcomb = new ProductCombination($db);
137 $prodcomb2val = new ProductCombination2ValuePair($db);
138 
139 $productCombination2ValuePairs1 = array();
140 
141 if (($action == 'add' || $action == 'create') && empty($massaction) && !GETPOST('selectvariant', 'alpha') && empty($subaction)) { // We click on Create all defined combinations
142  //$features = GETPOST('features', 'array');
143  $features = !empty($_SESSION['addvariant_'.$object->id]) ? $_SESSION['addvariant_'.$object->id] : array();
144 
145  if (!$features) {
146  if ($action == 'create') {
147  setEventMessages($langs->trans('ErrorFieldsRequired'), null, 'errors');
148  }
149  } else {
150  $reference = trim($reference);
151  if (empty($reference)) {
152  $reference = false;
153  }
154  $weight_impact = price2num($weight_impact);
155  $price_impact = price2num($price_impact);
156 
157  // for conf PRODUIT_MULTIPRICES
158  if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
159  $level_price_impact = array_map('price2num', $level_price_impact);
160  } else {
161  $level_price_impact = array(1 => $price_impact);
162  $level_price_impact_percent = array(1 => $price_impact_percent);
163  }
164 
165  $sanit_features = array();
166 
167  //First, sanitize
168  foreach ($features as $feature) {
169  $explode = explode('-', $feature);
170  if ($prodattr->fetch($explode[0]) <= 0 || $prodattr_val->fetch($explode[1]) <= 0) {
171  continue;
172  }
173 
174  // Valuepair
175  $sanit_features[$explode[0]] = $explode[1];
176 
177  $tmp = new ProductCombination2ValuePair($db);
178  $tmp->fk_prod_attr = $explode[0];
179  $tmp->fk_prod_attr_val = $explode[1];
180 
181  $productCombination2ValuePairs1[] = $tmp;
182  }
183 
184  $db->begin();
185 
186  // sanit_feature is an array with 1 (and only 1) value per attribute.
187  // For example: Color->blue, Size->Small, Option->2
188  //var_dump($sanit_features);
189  if (!$prodcomb->fetchByProductCombination2ValuePairs($id, $sanit_features)) {
190  $result = $prodcomb->createProductCombination($user, $object, $sanit_features, array(), $level_price_impact_percent, $level_price_impact, $weight_impact, $reference);
191  if ($result > 0) {
192  setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
193  unset($_SESSION['addvariant_'.$object->id]);
194 
195  $db->commit();
196  header('Location: '.dol_buildpath('/variants/combinations.php?id='.$id, 2));
197  exit();
198  } else {
199  $langs->load("errors");
200  setEventMessages($prodcomb->error, $prodcomb->errors, 'errors');
201  }
202  } else {
203  setEventMessages($langs->trans('ErrorRecordAlreadyExists'), null, 'errors');
204  }
205 
206  $db->rollback();
207  }
208 } elseif (!empty($massaction)) {
209  $bulkaction = $massaction;
210  $error = 0;
211 
212  $db->begin();
213 
214  foreach ($toselect as $prodid) {
215  // need create new of Product to prevent rename dir behavior
216  $prodstatic = new Product($db);
217  if ($prodstatic->fetch($prodid) < 0) {
218  continue;
219  }
220 
221  if ($bulkaction == 'on_sell') {
222  $prodstatic->status = 1;
223  $res = $prodstatic->update($prodstatic->id, $user);
224  if ($res <= 0) {
225  setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
226  $error++;
227  break;
228  }
229  } elseif ($bulkaction == 'on_buy') {
230  $prodstatic->status_buy = 1;
231  $res = $prodstatic->update($prodstatic->id, $user);
232  if ($res <= 0) {
233  setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
234  $error++;
235  break;
236  }
237  } elseif ($bulkaction == 'not_sell') {
238  $prodstatic->status = 0;
239  $res = $prodstatic->update($prodstatic->id, $user);
240  if ($res <= 0) {
241  setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
242  $error++;
243  break;
244  }
245  } elseif ($bulkaction == 'not_buy') {
246  $prodstatic->status_buy = 0;
247  $res = $prodstatic->update($prodstatic->id, $user);
248  if ($res <= 0) {
249  setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
250  $error++;
251  break;
252  }
253  } elseif ($bulkaction == 'delete') {
254  $res = $prodstatic->delete($user, $prodstatic->id);
255  if ($res <= 0) {
256  setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
257  $error++;
258  break;
259  }
260  } else {
261  break;
262  }
263  }
264 
265  if ($error) {
266  $db->rollback();
267  if (empty($prodstatic->error)) {
268  setEventMessages($langs->trans('CoreErrorMessage'), null, 'errors');
269  }
270  } else {
271  $db->commit();
272  setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
273  }
274 } elseif ($action === 'update' && $valueid > 0) {
275  if ($prodcomb->fetch($valueid) < 0) {
276  dol_print_error($db, $langs->trans('ErrorRecordNotFound'));
277  exit();
278  }
279 
280  $prodcomb->variation_weight = price2num($weight_impact);
281 
282  // for conf PRODUIT_MULTIPRICES
283  if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
284  $level_price_impact = array_map('price2num', $level_price_impact);
285 
286  $prodcomb->variation_price = $level_price_impact[1];
287  $prodcomb->variation_price_percentage = (bool) $level_price_impact_percent[1];
288  } else {
289  $level_price_impact = array(1 => $price_impact);
290  $level_price_impact_percent = array(1 => $price_impact_percent);
291 
292  $prodcomb->variation_price = $price_impact;
293  $prodcomb->variation_price_percentage = $price_impact_percent;
294  }
295 
296  if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
297  $prodcomb->combination_price_levels = array();
298  for ($i = 1; $i <= $conf->global->PRODUIT_MULTIPRICES_LIMIT; $i++) {
299  $productCombinationLevel = new ProductCombinationLevel($db);
300  $productCombinationLevel->fk_product_attribute_combination = $prodcomb->id;
301  $productCombinationLevel->fk_price_level = $i;
302  $productCombinationLevel->variation_price = $level_price_impact[$i];
303  $productCombinationLevel->variation_price_percentage = (bool) $level_price_impact_percent[$i];
304  $prodcomb->combination_price_levels[$i] = $productCombinationLevel;
305  }
306  }
307 
308  $error = 0;
309  $db->begin();
310 
311  // Update product variant ref
312  $product_child = new Product($db);
313  $product_child->fetch($prodcomb->fk_product_child);
314  $product_child->oldcopy = clone $product_child;
315  $product_child->ref = $reference;
316 
317  $result = $product_child->update($product_child->id, $user);
318  if ($result < 0) {
319  setEventMessages($product_child->error, $product_child->errors, 'errors');
320  $error++;
321  }
322 
323  if (!$error) {
324  // Update product variant infos
325  $result = $prodcomb->update($user);
326  if ($result < 0) {
327  setEventMessages($prodcomb->error, $prodcomb->errors, 'errors');
328  $error++;
329  }
330  }
331 
332  if (!$error) {
333  $db->commit();
334  setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
335  header('Location: ' . dol_buildpath('/variants/combinations.php?id=' . $id, 2));
336  exit();
337  } else {
338  $db->rollback();
339  }
340 }
341 
342 
343 // Reload variants
344 $productCombinations = $prodcomb->fetchAllByFkProductParent($object->id);
345 
346 if ($action === 'confirm_deletecombination') {
347  if ($prodcomb->fetch($valueid) > 0) {
348  $db->begin();
349 
350  if ($prodcomb->delete($user) > 0 && (empty($delete_product) || ($delete_product == 'on' && $prodstatic->fetch($prodcomb->fk_product_child) > 0 && $prodstatic->delete($user) > 0))) {
351  $db->commit();
352  setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
353  header('Location: '.dol_buildpath('/variants/combinations.php?id='.$object->id, 2));
354  exit();
355  }
356 
357  $db->rollback();
358  setEventMessages($langs->trans('ProductCombinationAlreadyUsed'), null, 'errors');
359  $action = '';
360  }
361 } elseif ($action === 'edit') {
362  if ($prodcomb->fetch($valueid) < 0) {
363  dol_print_error($db, $langs->trans('ErrorRecordNotFound'));
364  exit();
365  }
366 
367  $product_child = new Product($db);
368  $product_child->fetch($prodcomb->fk_product_child);
369  $reference = $product_child->ref;
370  $weight_impact = $prodcomb->variation_weight;
371  $price_impact = $prodcomb->variation_price;
372  $price_impact_percent = $prodcomb->variation_price_percentage;
373 
374  $productCombination2ValuePairs1 = $prodcomb2val->fetchByFkCombination($valueid);
375 } elseif ($action === 'confirm_copycombination') {
376  //Check destination product
377  $dest_product = GETPOST('dest_product');
378 
379  if ($prodstatic->fetch('', $dest_product) > 0) {
380  //To prevent from copying to the same product
381  if ($prodstatic->ref != $object->ref) {
382  if ($prodcomb->copyAll($user, $object->id, $prodstatic) > 0) {
383  header('Location: '.dol_buildpath('/variants/combinations.php?id='.$prodstatic->id, 2));
384  exit();
385  } else {
386  setEventMessages($langs->trans('ErrorCopyProductCombinations'), null, 'errors');
387  }
388  }
389  } else {
390  setEventMessages($langs->trans('ErrorDestinationProductNotFound'), null, 'errors');
391  }
392 }
393 
394 
395 
396 /*
397  * View
398  */
399 
400 $form = new Form($db);
401 
402 $title = $langs->trans("Variant");
403 
404 llxHeader("", $title);
405 
406 
407 if (!empty($id) || !empty($ref)) {
408  $showbarcode = isModEnabled('barcode');
409  if (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && empty($user->rights->barcode->lire_advance)) {
410  $showbarcode = 0;
411  }
412 
413  $head = product_prepare_head($object);
414  $titre = $langs->trans("CardProduct".$object->type);
415  $picto = ($object->type == Product::TYPE_SERVICE ? 'service' : 'product');
416 
417  print dol_get_fiche_head($head, 'combinations', $titre, -1, $picto);
418 
419  $linkback = '<a href="'.DOL_URL_ROOT.'/product/list.php?type='.$object->type.'">'.$langs->trans("BackToList").'</a>';
420  $object->next_prev_filter = " fk_product_type = ".$object->type;
421 
422  dol_banner_tab($object, 'ref', $linkback, ($user->socid ? 0 : 1), 'ref', '', '', '', 0, '', '');
423 
424  print '<div class="fichecenter">';
425 
426  print '<div class="underbanner clearboth"></div>';
427  print '<table class="border centpercent tableforfield">';
428 
429  // Type
430  if (isModEnabled("product") && isModEnabled("service")) {
431  $typeformat = 'select;0:'.$langs->trans("Product").',1:'.$langs->trans("Service");
432  print '<tr><td class="titlefieldcreate">';
433  print (empty($conf->global->PRODUCT_DENY_CHANGE_PRODUCT_TYPE)) ? $form->editfieldkey("Type", 'fk_product_type', $object->type, $object, $usercancreate, $typeformat) : $langs->trans('Type');
434  print '</td><td>';
435  print $form->editfieldval("Type", 'fk_product_type', $object->type, $object, $usercancreate, $typeformat);
436  print '</td></tr>';
437  }
438 
439  // TVA
440  print '<tr><td class="titlefieldcreate">'.$langs->trans("DefaultTaxRate").'</td><td>';
441 
442  $positiverates = '';
443  if (price2num($object->tva_tx)) {
444  $positiverates .= ($positiverates ? '/' : '').price2num($object->tva_tx);
445  }
446  if (price2num($object->localtax1_type)) {
447  $positiverates .= ($positiverates ? '/' : '').price2num($object->localtax1_tx);
448  }
449  if (price2num($object->localtax2_type)) {
450  $positiverates .= ($positiverates ? '/' : '').price2num($object->localtax2_tx);
451  }
452  if (empty($positiverates)) {
453  $positiverates = '0';
454  }
455  echo vatrate($positiverates.($object->default_vat_code ? ' ('.$object->default_vat_code.')' : ''), '%', $object->tva_npr);
456  /*
457  if ($object->default_vat_code)
458  {
459  print vatrate($object->tva_tx, true) . ' ('.$object->default_vat_code.')';
460  }
461  else print vatrate($object->tva_tx, true, $object->tva_npr, true);*/
462  print '</td></tr>';
463 
464  // Price
465  print '<tr><td>'.$langs->trans("SellingPrice").'</td><td>';
466  if ($object->price_base_type == 'TTC') {
467  print price($object->price_ttc).' '.$langs->trans($object->price_base_type);
468  } else {
469  print price($object->price).' '.$langs->trans($object->price_base_type);
470  }
471  print '</td></tr>';
472 
473  // Price minimum
474  print '<tr><td>'.$langs->trans("MinPrice").'</td><td>';
475  if ($object->price_base_type == 'TTC') {
476  print price($object->price_min_ttc).' '.$langs->trans($object->price_base_type);
477  } else {
478  print price($object->price_min).' '.$langs->trans($object->price_base_type);
479  }
480  print '</td></tr>';
481 
482  // Weight
483  print '<tr><td>'.$langs->trans("Weight").'</td><td>';
484  if ($object->weight != '') {
485  print $object->weight." ".measuringUnitString(0, "weight", $object->weight_units);
486  } else {
487  print '&nbsp;';
488  }
489  print "</td></tr>\n";
490 
491  print "</table>\n";
492 
493  print '</div>';
494  print '<div class="clearboth"></div>';
495 
496  print dol_get_fiche_end();
497 
498  $listofvariantselected = '';
499 
500  // Create or edit a varian
501  if ($action == 'add' || ($action == 'edit')) {
502  if ($action == 'add') {
503  $title = $langs->trans('NewProductCombination');
504  // print dol_get_fiche_head();
505  $features = !empty($_SESSION['addvariant_'.$object->id]) ? $_SESSION['addvariant_'.$object->id] : array();
506  //First, sanitize
507  $listofvariantselected = '<div id="parttoaddvariant">';
508  if (!empty($features)) {
509  $toprint = array();
510  foreach ($features as $feature) {
511  $explode = explode('-', $feature);
512  if ($prodattr->fetch($explode[0]) <= 0 || $prodattr_val->fetch($explode[1]) <= 0) {
513  continue;
514  }
515  $toprint[] = '<li class="select2-search-choice-dolibarr noborderoncategories" style="background: #ddd;">' . $prodattr->label.' : '.$prodattr_val->value .
516  ' <a class="reposition" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=create&subaction=delete&feature='.urlencode($feature).'">' . img_delete() . '</a></li>';
517  }
518  $listofvariantselected .= '<div class="select2-container-multi-dolibarr" style="width: 90%;"><ul class="select2-choices-dolibarr">' . implode(' ', $toprint) . '</ul></div>';
519  }
520  $listofvariantselected .= '</div>';
521  //print dol_get_fiche_end();
522  } else {
523  $title = $langs->trans('EditProductCombination');
524  }
525 
526  if ($action == 'add') {
527  $prodattr_all = $prodattr->fetchAll();
528 
529  if (!$selected) {
530  $selected = $prodattr_all[key($prodattr_all)]->id;
531  }
532 
533  $prodattr_alljson = array();
534 
535  foreach ($prodattr_all as $each) {
536  $prodattr_alljson[$each->id] = $each;
537  }
538  ?>
539 
540  <script type="text/javascript">
541 
542  variants_available = <?php echo json_encode($prodattr_alljson, JSON_PARTIAL_OUTPUT_ON_ERROR); ?>;
543  variants_selected = {
544  index: [],
545  info: []
546  };
547 
548  <?php
549  foreach ($productCombination2ValuePairs1 as $pc2v) {
550  $prodattr_val->fetch($pc2v->fk_prod_attr_val);
551  ?>
552  variants_selected.index.push(<?php echo $pc2v->fk_prod_attr ?>);
553  variants_selected.info[<?php echo $pc2v->fk_prod_attr ?>] = {
554  attribute: variants_available[<?php echo $pc2v->fk_prod_attr ?>],
555  value: {
556  id: <?php echo $pc2v->fk_prod_attr_val ?>,
557  label: '<?php echo $prodattr_val->value ?>'
558  }
559  };
560  <?php
561  }
562  ?>
563 
564  restoreAttributes = function() {
565  jQuery("select[name=attribute]").empty().append('<option value="-1">&nbsp;</option>');
566 
567  jQuery.each(variants_available, function (key, val) {
568  if (jQuery.inArray(val.id, variants_selected.index) == -1) {
569  jQuery("select[name=attribute]").append('<option value="' + val.id + '">' + val.label + '</option>');
570  }
571  });
572  };
573 
574 
575  jQuery(document).ready(function() {
576  jQuery("select#attribute").change(function () {
577  console.log("Change of field variant attribute");
578  var select = jQuery("select#value");
579 
580  if (!jQuery(this).val().length || jQuery(this).val() == '-1') {
581  select.empty();
582  select.append('<option value="-1">&nbsp;</option>');
583  return;
584  }
585 
586  select.empty().append('<option value="">Loading...</option>');
587 
588  jQuery.getJSON("ajax/get_attribute_values.php", {
589  id: jQuery(this).val()
590  }, function(data) {
591  if (data.error) {
592  select.empty();
593  select.append('<option value="-1">&nbsp;</option>');
594  return alert(data.error);
595  }
596 
597  select.empty();
598  select.append('<option value="-1">&nbsp;</option>');
599 
600  jQuery(data).each(function (key, val) {
601  keyforoption = val.id
602  valforoption = val.value
603  select.append('<option value="' + keyforoption + '">' + valforoption + '</option>');
604  });
605  });
606  });
607  });
608  </script>
609 
610  <?php
611  }
612 
613  print '<br>';
614 
615  print load_fiche_titre($title);
616 
617  print '<form method="post" id="combinationform" action="'.$_SERVER["PHP_SELF"] .'?id='.$object->id.'">'."\n";
618  print '<input type="hidden" name="token" value="'.newToken().'">';
619  print '<input type="hidden" name="action" value="'.(($valueid > 0) ? "update" : "create").'">'."\n";
620  if ($valueid > 0) {
621  print '<input type="hidden" name="valueid" value="'.$valueid.'">'."\n";
622  }
623 
624  print dol_get_fiche_head();
625 
626 
627  if ($action == 'add') {
628  print '<table class="border" style="width: 100%">';
629  print "<!-- Variant -->\n";
630  print '<tr>';
631  print '<td class="titlefieldcreate fieldrequired"><label for="attribute">'.$langs->trans('ProductAttribute').'</label></td>';
632  print '<td>';
633  if (is_array($prodattr_all)) {
634  print '<select class="flat minwidth100" id="attribute" name="attribute">';
635  print '<option value="-1">&nbsp;</option>';
636  foreach ($prodattr_all as $attr) {
637  //print '<option value="'.$attr->id.'"'.($attr->id == GETPOST('attribute', 'int') ? ' selected="selected"' : '').'>'.$attr->label.'</option>';
638  print '<option value="'.$attr->id.'">'.$attr->label.'</option>';
639  }
640  print '</select>';
641  }
642 
643  $htmltext = $langs->trans("GoOnMenuToCreateVairants", $langs->transnoentities("Product"), $langs->transnoentities("VariantAttributes"));
644  print $form->textwithpicto('', $htmltext);
645  /*print ' &nbsp; &nbsp; <a href="'.DOL_URL_ROOT.'/variants/create.php?action=create&backtopage='.urlencode($_SERVER["PHP_SELF"].'?action=add&token='.newToken().'&id='.$object->id).'">';
646  print $langs->trans("Create");
647  print '</a>';*/
648 
649  print '</td>';
650  print '</tr>';
651  ?>
652  <!-- Value -->
653  <tr>
654  <td class="fieldrequired"><label for="value"><?php echo $langs->trans('Value') ?></label></td>
655  <td>
656  <select class="flat minwidth100" id="value" name="value">
657  <option value="-1">&nbsp;</option>
658  </select>
659  <?php
660  $htmltext = $langs->trans("GoOnMenuToCreateVairants", $langs->transnoentities("Product"), $langs->transnoentities("VariantAttributes"));
661  print $form->textwithpicto('', $htmltext);
662  /*
663  print ' &nbsp; &nbsp; <a href="'.DOL_URL_ROOT.'/variants/create.php?action=create&backtopage='.urlencode($_SERVER["PHP_SELF"].'?action=add&token='.newToken().'&id='.$object->id).'">';
664  print $langs->trans("Create");
665  print '</a>';
666  */
667  ?>
668  </td>
669  </tr>
670  <tr>
671  <td></td><td>
672  <input type="submit" class="button" name="selectvariant" id="selectvariant" value="<?php echo dol_escape_htmltag($langs->trans("SelectCombination")); ?>">
673  </td>
674  </tr>
675  <?php
676  print '<tr><td></td><td>';
677  print $listofvariantselected;
678  print '</td>';
679  print '</tr>';
680 
681  print '</table>';
682  print '<hr>';
683  }
684 
685  if (is_array($productCombination2ValuePairs1)) {
686  print '<table class="border" style="width: 100%">';
687 
688  // When in edit mode
689  if (is_array($productCombination2ValuePairs1) && count($productCombination2ValuePairs1)) {
690  ?>
691  <tr>
692  <td class="titlefieldcreate tdtop"><label for="features"><?php echo $langs->trans('Combination') ?></label></td>
693  <td class="tdtop">
694  <div class="inline-block valignmiddle quatrevingtpercent">
695  <?php
696  foreach ($productCombination2ValuePairs1 as $key => $val) {
697  $result1 = $prodattr->fetch($val->fk_prod_attr);
698  $result2 = $prodattr_val->fetch($val->fk_prod_attr_val);
699  //print 'rr'.$result1.' '.$result2;
700  if ($result1 > 0 && $result2 > 0) {
701  print $prodattr->label.' - '.$prodattr_val->value.'<br>';
702  // TODO Add delete link
703  }
704  }
705  ?>
706  </div>
707  <!-- <div class="inline-block valignmiddle">
708  <a href="#" class="inline-block valignmiddle button" id="delfeature"><?php echo img_edit_remove() ?></a>
709  </div>-->
710  </td>
711  <td>
712  </td>
713  </tr>
714  <?php
715  }
716  ?>
717  <tr>
718  <td><label for="reference"><?php echo $langs->trans('Reference') ?></label></td>
719  <td><input type="text" id="reference" name="reference" value="<?php echo trim($reference) ?>"></td>
720  </tr>
721  <?php
722  if (empty($conf->global->PRODUIT_MULTIPRICES)) {
723  ?>
724  <tr>
725  <td><label for="price_impact"><?php echo $langs->trans('PriceImpact') ?></label></td>
726  <td><input type="text" id="price_impact" name="price_impact" value="<?php echo price($price_impact) ?>">
727  <input type="checkbox" id="price_impact_percent" name="price_impact_percent" <?php echo $price_impact_percent ? ' checked' : '' ?>> <label for="price_impact_percent"><?php echo $langs->trans('PercentageVariation') ?></label>
728  </td>
729  </tr>
730  <?php
731  } else {
732  $prodcomb->fetchCombinationPriceLevels();
733 
734  for ($i = 1; $i <= $conf->global->PRODUIT_MULTIPRICES_LIMIT; $i++) {
735  print '<tr>';
736  print '<td><label for="level_price_impact_'.$i.'">'.$langs->trans('ImpactOnPriceLevel', $i).'</label>';
737  if ($i === 1) {
738  print ' <a id="apply-price-impact-to-all-level" class="classfortooltip" href="#" title="'.$langs->trans('ApplyToAllPriceImpactLevelHelp').'">('.$langs->trans('ApplyToAllPriceImpactLevel').')</a>';
739  }
740  print '</td>';
741  print '<td><input type="text" class="level_price_impact" id="level_price_impact_'.$i.'" name="level_price_impact['.$i.']" value="'.price($prodcomb->combination_price_levels[$i]->variation_price).'">';
742  print '<input type="checkbox" class="level_price_impact_percent" id="level_price_impact_percent_'.$i.'" name="level_price_impact_percent['.$i.']" '.(!empty($prodcomb->combination_price_levels[$i]->variation_price_percentage) ? ' checked' : '').'> <label for="level_price_impact_percent_'.$i.'">'.$langs->trans('PercentageVariation').'</label>';
743 
744  print '</td>';
745  print '</tr>';
746  }
747  }
748 
749  if ($object->isProduct()) {
750  print '<tr>';
751  print '<td><label for="weight_impact">'.$langs->trans('WeightImpact').'</label></td>';
752  print '<td><input type="text" id="weight_impact" name="weight_impact" value="'.price($weight_impact).'"></td>';
753  print '</tr>';
754  }
755 
756  print '</table>';
757  }
758 
759  if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
760  ?>
761  <script>
762  $(document).ready(function() {
763  // Apply level 1 impact to all prices impact levels
764  $('body').on('click', '#apply-price-impact-to-all-level', function(e) {
765  e.preventDefault();
766  let priceImpact = $( "#level_price_impact_1" ).val();
767  let priceImpactPrecent = $( "#level_price_impact_percent_1" ).prop("checked");
768 
769  var multipricelimit = <?php print intval($conf->global->PRODUIT_MULTIPRICES_LIMIT); ?>
770 
771  for (let i = 2; i <= multipricelimit; i++) {
772  $( "#level_price_impact_" + i ).val(priceImpact);
773  $( "#level_price_impact_percent_" + i ).prop("checked", priceImpactPrecent);
774  }
775  });
776  });
777  </script>
778  <?php
779  }
780 
781  print dol_get_fiche_end();
782  ?>
783 
784  <div style="text-align: center">
785  <input type="submit" name="create" <?php if (!is_array($productCombination2ValuePairs1)) {
786  print ' disabled="disabled"';
787  } ?> value="<?php echo $action == 'add' ? $langs->trans('Create') : $langs->trans("Save") ?>" class="button button-save">
788  &nbsp;
789  <input type="submit" name="cancel" value="<?php echo $langs->trans("Cancel"); ?>" class="button button-cancel">
790  </div>
791 
792  <?php
793 
794  print '</form>';
795  } else {
796  if ($action === 'delete') {
797  if ($prodcomb->fetch($valueid) > 0) {
798  $prodstatic->fetch($prodcomb->fk_product_child);
799 
800  print $form->formconfirm(
801  "combinations.php?id=".urlencode($id)."&valueid=".urlencode($valueid),
802  $langs->trans('Delete'),
803  $langs->trans('ProductCombinationDeleteDialog', $prodstatic->ref),
804  "confirm_deletecombination",
805  array(array('label'=> $langs->trans('DeleteLinkedProduct'), 'type'=> 'checkbox', 'name' => 'delete_product', 'value' => false)),
806  0,
807  1
808  );
809  }
810  } elseif ($action === 'copy') {
811  print $form->formconfirm('combinations.php?id='.$id, $langs->trans('ToClone'), $langs->trans('ConfirmCloneProductCombinations'), 'confirm_copycombination', array(array('type' => 'text', 'label' => $langs->trans('CloneDestinationReference'), 'name' => 'dest_product')), 0, 1);
812  }
813 
814  $comb2val = new ProductCombination2ValuePair($db);
815 
816  if ($productCombinations) {
817  ?>
818 
819  <script type="text/javascript">
820  jQuery(document).ready(function() {
821 
822  jQuery('input[name="select_all"]').click(function() {
823 
824  if (jQuery(this).prop('checked')) {
825  var checked = true;
826  } else {
827  var checked = false;
828  }
829 
830  jQuery('table.liste input[type="checkbox"]').prop('checked', checked);
831  });
832 
833  jQuery('input[name^="select["]').click(function() {
834  jQuery('input[name="select_all"]').prop('checked', false);
835  });
836 
837  });
838  </script>
839 
840  <?php
841  }
842 
843  // Buttons
844  print '<div class="tabsAction">';
845 
846  print ' <div class="inline-block divButAction">';
847 
848  print '<a href="combinations.php?id='.$object->id.'&action=add&token='.newToken().'" class="butAction">'.$langs->trans('NewProductCombination').'</a>'; // NewVariant
849 
850  if ($productCombinations) {
851  print '<a href="combinations.php?id='.$object->id.'&action=copy&token='.newToken().'" class="butAction">'.$langs->trans('PropagateVariant').'</a>';
852  }
853 
854  print ' </div>';
855 
856  print '</div>';
857 
858 
859 
860  $arrayofselected = is_array($toselect) ? $toselect : array();
861 
862 
863  // List of variants
864  print '<form method="POST" action="'.$_SERVER["PHP_SELF"] .'?id='.$object->id.'">';
865  print '<input type="hidden" name="token" value="'.newToken().'">';
866  print '<input type="hidden" name="action" value="massaction">';
867  print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
868 
869  // List of mass actions available
870  /*
871  $arrayofmassactions = array(
872  'presend'=>$langs->trans("SendByMail"),
873  'builddoc'=>$langs->trans("PDFMerge"),
874  );
875  if ($user->rights->product->supprimer) $arrayofmassactions['predelete']='<span class="fa fa-trash paddingrightonly"></span>'.$langs->trans("Delete");
876  if (in_array($massaction, array('presend','predelete'))) $arrayofmassactions=array();
877  $massactionbutton=$form->selectMassAction('', $arrayofmassactions);
878  */
879 
880  $aaa = '';
881  if (count($productCombinations)) {
882  $aaa = '<select id="bulk_action" name="massaction" class="flat">';
883  $aaa .= ' <option value="nothing">&nbsp;</option>';
884  $aaa .= ' <option value="not_buy" data-html="'.dol_escape_htmltag(img_picto($langs->trans("SetToStatus"), 'stop-circle', 'class="pictofixedwidth"').$langs->trans('SetToStatus', $langs->transnoentitiesnoconv('ProductStatusNotOnBuy'))).'">'.$langs->trans('ProductStatusNotOnBuy').'</option>';
885  $aaa .= ' <option value="not_sell" data-html="'.dol_escape_htmltag(img_picto($langs->trans("SetToStatus"), 'stop-circle', 'class="pictofixedwidth"').$langs->trans('SetToStatus', $langs->transnoentitiesnoconv('ProductStatusNotOnSell'))).'">'.$langs->trans('ProductStatusNotOnSell').'</option>';
886  $aaa .= ' <option value="on_buy" data-html="'.dol_escape_htmltag(img_picto($langs->trans("SetToStatus"), 'stop-circle', 'class="pictofixedwidth"').$langs->trans('SetToStatus', $langs->transnoentitiesnoconv('ProductStatusOnBuy'))).'">'.$langs->trans('ProductStatusOnBuy').'</option>';
887  $aaa .= ' <option value="on_sell" data-html="'.dol_escape_htmltag(img_picto($langs->trans("SetToStatus"), 'stop-circle', 'class="pictofixedwidth"').$langs->trans('SetToStatus', $langs->transnoentitiesnoconv('ProductStatusOnSell'))).'">'.$langs->trans('ProductStatusOnSell').'</option>';
888  $aaa .= ' <option value="delete" data-html="'.dol_escape_htmltag(img_picto($langs->trans("Delete"), 'delete', 'class="pictofixedwidth"').$langs->trans('Delete')).'">'.$langs->trans('Delete').'</option>';
889  $aaa .= '</select>';
890  $aaa .= ajax_combobox("bulk_action");
891  $aaa .= '<input type="submit" value="'.dol_escape_htmltag($langs->trans("Apply")).'" class="button small">';
892  }
893  $massactionbutton = $aaa;
894 
895  $title = $langs->trans("ProductCombinations");
896 
897  print_barre_liste($title, 0, $_SERVER["PHP_SELF"], '', $sortfield, $sortorder, $aaa, 0);
898 
899  print '<div class="div-table-responsive">';
900  ?>
901  <table class="liste">
902  <tr class="liste_titre">
903  <?php
904  // Action column
905  if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
906  print '<td class="liste_titre center">';
907  $searchpicto = $form->showCheckAddButtons('checkforselect', 1);
908  print $searchpicto;
909  print '</td>';
910  }
911  ?>
912  <td class="liste_titre"><?php echo $langs->trans('Product') ?></td>
913  <td class="liste_titre"><?php echo $langs->trans('Combination') ?></td>
914  <td class="liste_titre right"><?php echo $langs->trans('PriceImpact') ?></td>
915  <?php if ($object->isProduct()) {
916  print'<td class="liste_titre right">'.$langs->trans('WeightImpact').'</td>';
917  } ?>
918  <td class="liste_titre center"><?php echo $langs->trans('OnSell') ?></td>
919  <td class="liste_titre center"><?php echo $langs->trans('OnBuy') ?></td>
920  <td class="liste_titre"></td>
921  <?php
922  // Action column
923  if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
924  print '<td class="liste_titre center">';
925  $searchpicto = $form->showCheckAddButtons('checkforselect', 1);
926  print $searchpicto;
927  print '</td>';
928  }
929  ?>
930  </tr>
931  <?php
932 
933  if (count($productCombinations)) {
934  foreach ($productCombinations as $currcomb) {
935  $prodstatic->fetch($currcomb->fk_product_child);
936  print '<tr class="oddeven">';
937 
938  // Action column
939  if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
940  print '<td class="nowrap center">';
941  if (!empty($productCombinations) || $massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
942  $selected = 0;
943  if (in_array($prodstatic->id, $arrayofselected)) {
944  $selected = 1;
945  }
946  print '<input id="cb'.$prodstatic->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$prodstatic->id.'"'.($selected ? ' checked="checked"' : '').'>';
947  }
948  print '</td>';
949  }
950 
951  print '<td>'.$prodstatic->getNomUrl(1).'</td>';
952  print '<td>';
953  $productCombination2ValuePairs = $comb2val->fetchByFkCombination($currcomb->id);
954  $iMax = count($productCombination2ValuePairs);
955 
956  for ($i = 0; $i < $iMax; $i++) {
957  echo dol_htmlentities($productCombination2ValuePairs[$i]);
958  if ($i !== ($iMax - 1)) {
959  echo ', ';
960  }
961  }
962  print '</td>';
963  print '<td class="right">'.($currcomb->variation_price >= 0 ? '+' : '').price($currcomb->variation_price).($currcomb->variation_price_percentage ? ' %' : '').'</td>';
964  if ($object->isProduct()) {
965  print '<td class="right">'.($currcomb->variation_weight >= 0 ? '+' : '').price($currcomb->variation_weight).' '.measuringUnitString(0, 'weight', $prodstatic->weight_units).'</td>';
966  }
967  print '<td class="center">'.$prodstatic->getLibStatut(2, 0).'</td>';
968  print '<td class="center">'.$prodstatic->getLibStatut(2, 1).'</td>';
969 
970  print '<td class="right">';
971  print '<a class="paddingleft paddingright editfielda" href="'.$_SERVER["PHP_SELF"].'?id='.$id.'&action=edit&token='.newToken().'&valueid='.$currcomb->id.'">'.img_edit().'</a>';
972  print '<a class="paddingleft paddingright" href="'.$_SERVER["PHP_SELF"].'?id='.$id.'&action=delete&token='.newToken().'&valueid='.$currcomb->id.'">'.img_delete().'</a>';
973  print '</td>';
974 
975  // Action column
976  if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
977  print '<td class="nowrap center">';
978  if (!empty($productCombinations) || $massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
979  $selected = 0;
980  if (in_array($prodstatic->id, $arrayofselected)) {
981  $selected = 1;
982  }
983  print '<input id="cb'.$prodstatic->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$prodstatic->id.'"'.($selected ? ' checked="checked"' : '').'>';
984  }
985  print '</td>';
986  }
987 
988  print '</tr>';
989  }
990  } else {
991  print '<tr><td colspan="8"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
992  }
993  print '</table>';
994  print '</div>';
995  print '</form>';
996  }
997 }
998 
999 // End of page
1000 llxFooter();
1001 $db->close();
ajax_combobox($htmlname, $events=array(), $minLengthToAutocomplete=0, $forcefocus=0, $widthTypeOfAutocomplete='resolve', $idforemptyvalue='-1', $morecss='')
Convert a html select field into an ajax combobox.
Definition: ajax.lib.php:449
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.
Definition: wrapper.php:56
llxFooter()
Empty footer.
Definition: wrapper.php:70
Class to manage generation of HTML components Only common components must be here.
Class ProductAttribute Used to represent a product attribute.
Class ProductAttributeValue Used to represent a product attribute value.
Class ProductCombination2ValuePair Used to represent the relation between a product combination,...
Class ProductCombination Used to represent a product combination.
Class ProductCombinationLevel Used to represent a product combination Level.
Class to manage products or services.
const TYPE_PRODUCT
Regular product.
const TYPE_SERVICE
Service.
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:143
dol_banner_tab($object, $paramid, $morehtml='', $shownav=1, $fieldid='rowid', $fieldref='ref', $morehtmlref='', $moreparam='', $nodbprefix=0, $morehtmlleft='', $morehtmlstatus='', $onlybanner=0, $morehtmlright='')
Show tab footer of a card.
vatrate($rate, $addpercent=false, $info_bits=0, $usestarfornpr=0, $html=0)
Return a string with VAT rate label formated for view output Used into pdf and HTML pages.
load_fiche_titre($titre, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0)
Show tabs of a record.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
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.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
newToken()
Return the value of token currently saved into session with name 'newtoken'.
dol_htmlentities($string, $flags=ENT_QUOTES|ENT_SUBSTITUTE, $encoding='UTF-8', $double_encode=false)
Replace htmlentities functions.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
print_barre_liste($titre, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
img_edit($titlealt='default', $float=0, $other='')
Show logo editer/modifier fiche.
img_edit_remove($titlealt='default', $other='')
Show logo -.
product_prepare_head($object)
Prepare array with list of tabs.
Definition: product.lib.php:36
measuringUnitString($unit, $measuring_style='', $scale='', $use_short_label=0, $outputlangs=null)
Return translation label of a unit key.
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition: repair.php:120
$conf db name
Only used if Module[ID]Name translation string is not found.
Definition: repair.php:123
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.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.