combinations.php

<?php
/* Copyright (C) 2016      Marcos García       <marcosgdf@gmail.com>
 * Copyright (C) 2017      Laurent Destailleur <eldy@users.sourceforge.net>
 * Copyright (C) 2018-2019 Frédéric France     <frederic.france@netlogic.fr>
 * Copyright (C) 2022   Open-Dsi    <support@open-dsi.fr>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */

require '../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductAttribute.class.php';
require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductAttributeValue.class.php';
require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductCombination.class.php';
require_once DOL_DOCUMENT_ROOT.'/variants/class/ProductCombination2ValuePair.class.php';

$langs->loadLangs(array("products", "other"));

$id = GETPOST('id', 'int');
$valueid = GETPOST('valueid', 'int');
$ref = GETPOST('ref', 'alpha');
$weight_impact = price2num(GETPOST('weight_impact', 'alpha'), 2);
$price_impact_percent = (bool) GETPOST('price_impact_percent');
if ($price_impact_percent) {
  $price_impact = price2num(GETPOST('price_impact', 'alpha'), 2);
} else {
  $price_impact = price2num(GETPOST('price_impact', 'alpha'), 'MU');
}
$level_price_impact = GETPOST('level_price_impact', 'array');
$level_price_impact_percent = GETPOST('level_price_impact_percent', 'array');

$reference = GETPOST('reference', 'alpha');
$form = new Form($db);

$action = GETPOST('action', 'aZ09');
$massaction = GETPOST('massaction', 'alpha');
$show_files = GETPOST('show_files', 'int');
$confirm = GETPOST('confirm', 'alpha');
$toselect = GETPOST('toselect', 'array');
$cancel = GETPOST('cancel', 'alpha');
$delete_product = GETPOST('delete_product', 'alpha');
$subaction = GETPOST('subaction', 'aZ09');
$backtopage = GETPOST('backtopage', 'alpha');
$sortfield = GETPOST('sortfield', 'aZ09comma');
$sortorder = GETPOST('sortorder', 'aZ09comma');

// Security check
$fieldvalue = (!empty($id) ? $id : $ref);
$fieldtype = (!empty($ref) ? 'ref' : 'rowid');

$prodstatic = new Product($db);
$prodattr = new ProductAttribute($db);
$prodattr_val = new ProductAttributeValue($db);

$object = new Product($db);
if ($id > 0 || $ref) {
  $object->fetch($id, $ref);
}

$selectedvariant = !empty($_SESSION['addvariant_'.$object->id]) ? $_SESSION['addvariant_'.$object->id] : array();

// Security check
if (empty($conf->variants->enabled)) {
  accessforbidden('Module not enabled');
}
if ($user->socid > 0) { // Protection if external user
  accessforbidden();
}

if ($object->id > 0) {
  if ($object->type == $object::TYPE_PRODUCT) {
    restrictedArea($user, 'produit', $object->id, 'product&product', '', '');
  }
  if ($object->type == $object::TYPE_SERVICE) {
    restrictedArea($user, 'service', $object->id, 'product&product', '', '');
  }
} else {
  restrictedArea($user, 'produit|service', $fieldvalue, 'product&product', '', '', $fieldtype);
}
$usercanread = (($object->type == Product::TYPE_PRODUCT && $user->rights->produit->lire) || ($object->type == Product::TYPE_SERVICE && $user->rights->service->lire));
$usercancreate = (($object->type == Product::TYPE_PRODUCT && $user->rights->produit->creer) || ($object->type == Product::TYPE_SERVICE && $user->rights->service->creer));
$usercandelete = (($object->type == Product::TYPE_PRODUCT && $user->rights->produit->supprimer) || ($object->type == Product::TYPE_SERVICE && $user->rights->service->supprimer));


/*
 * Actions
 */

if ($cancel) {
  $action = '';
  $massaction = '';
  unset($_SESSION['addvariant_'.$object->id]);
}

if (!$object->isProduct() && !$object->isService()) {
  header('Location: '.dol_buildpath('/product/card.php?id='.$object->id, 2));
  exit();
}
if ($action == 'add') {
  unset($selectedvariant);
  unset($_SESSION['addvariant_'.$object->id]);
}
if ($action == 'create' && GETPOST('selectvariant', 'alpha')) { // We click on select combination
  $action = 'add';
  $attribute_id = GETPOST('attribute', 'int');
  $attribute_value_id = GETPOST('value', 'int');
  if ($attribute_id> 0 && $attribute_value_id > 0) {
    $feature = $attribute_id . '-' . $attribute_value_id;
    $selectedvariant[$feature] = $feature;
    $_SESSION['addvariant_'.$object->id] = $selectedvariant;
  }
}
if ($action == 'create' && $subaction == 'delete') {  // We click on select combination
  $action = 'add';
  $feature = GETPOST('feature', 'intcomma');
  if (isset($selectedvariant[$feature])) {
    unset($selectedvariant[$feature]);
    $_SESSION['addvariant_'.$object->id] = $selectedvariant;
  }
}


$prodcomb = new ProductCombination($db);
$prodcomb2val = new ProductCombination2ValuePair($db);

$productCombination2ValuePairs1 = array();

if (($action == 'add' || $action == 'create') && empty($massaction) && !GETPOST('selectvariant', 'alpha') && empty($subaction)) { // We click on Create all defined combinations
  //$features = GETPOST('features', 'array');
  $features = $_SESSION['addvariant_'.$object->id];

  if (!$features) {
    if ($action == 'create') {
      setEventMessages($langs->trans('ErrorFieldsRequired'), null, 'errors');
    }
  } else {
    $reference = trim($reference);
    if (empty($reference)) {
      $reference = false;
    }
    $weight_impact = price2num($weight_impact);
    $price_impact = price2num($price_impact);

    // for conf PRODUIT_MULTIPRICES
    if ($conf->global->PRODUIT_MULTIPRICES) {
      $level_price_impact = array_map('price2num', $level_price_impact);
    } else {
      $level_price_impact = array(1 => $price_impact);
      $level_price_impact_percent = array(1 => $price_impact_percent);
    }

    $sanit_features = array();

    //First, sanitize
    foreach ($features as $feature) {
      $explode = explode('-', $feature);
      if ($prodattr->fetch($explode[0]) <= 0 || $prodattr_val->fetch($explode[1]) <= 0) {
        continue;
      }

      // Valuepair
      $sanit_features[$explode[0]] = $explode[1];

      $tmp = new ProductCombination2ValuePair($db);
      $tmp->fk_prod_attr = $explode[0];
      $tmp->fk_prod_attr_val = $explode[1];

      $productCombination2ValuePairs1[] = $tmp;
    }

    $db->begin();

    // sanit_feature is an array with 1 (and only 1) value per attribute.
    // For example:  Color->blue, Size->Small, Option->2
    //var_dump($sanit_features);
    if (!$prodcomb->fetchByProductCombination2ValuePairs($id, $sanit_features)) {
      $result = $prodcomb->createProductCombination($user, $object, $sanit_features, array(), $level_price_impact_percent, $level_price_impact, $weight_impact, $reference);
      if ($result > 0) {
        setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
        unset($_SESSION['addvariant_'.$object->id]);

        $db->commit();
        header('Location: '.dol_buildpath('/variants/combinations.php?id='.$id, 2));
        exit();
      } else {
        $langs->load("errors");
        setEventMessages($prodcomb->error, $prodcomb->errors, 'errors');
      }
    } else {
      setEventMessages($langs->trans('ErrorRecordAlreadyExists'), null, 'errors');
    }

    $db->rollback();
  }
} elseif (!empty($massaction)) {
  $bulkaction = $massaction;
  $error = 0;

  $db->begin();

  foreach ($toselect as $prodid) {
    // need create new of Product to prevent rename dir behavior
    $prodstatic = new Product($db);
    if ($prodstatic->fetch($prodid) < 0) {
      continue;
    }

    if ($bulkaction == 'on_sell') {
      $prodstatic->status = 1;
      $res = $prodstatic->update($prodstatic->id, $user);
      if ($res <= 0) {
        setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
        $error++;
        break;
      }
    } elseif ($bulkaction == 'on_buy') {
      $prodstatic->status_buy = 1;
      $res = $prodstatic->update($prodstatic->id, $user);
      if ($res <= 0) {
        setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
        $error++;
        break;
      }
    } elseif ($bulkaction == 'not_sell') {
      $prodstatic->status = 0;
      $res = $prodstatic->update($prodstatic->id, $user);
      if ($res <= 0) {
        setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
        $error++;
        break;
      }
    } elseif ($bulkaction == 'not_buy') {
      $prodstatic->status_buy = 0;
      $res = $prodstatic->update($prodstatic->id, $user);
      if ($res <= 0) {
        setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
        $error++;
        break;
      }
    } elseif ($bulkaction == 'delete') {
      $res = $prodstatic->delete($user, $prodstatic->id);
      if ($res <= 0) {
        setEventMessages($prodstatic->error, $prodstatic->errors, 'errors');
        $error++;
        break;
      }
    } else {
      break;
    }
  }

  if ($error) {
    $db->rollback();
    if (empty($prodstatic->error)) {
      setEventMessages($langs->trans('CoreErrorMessage'), null, 'errors');
    }
  } else {
    $db->commit();
    setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
  }
} elseif ($action === 'update' && $valueid > 0) {
  if ($prodcomb->fetch($valueid) < 0) {
    dol_print_error($db, $langs->trans('ErrorRecordNotFound'));
    exit();
  }

  $prodcomb->variation_weight = price2num($weight_impact);

  // for conf PRODUIT_MULTIPRICES
  if ($conf->global->PRODUIT_MULTIPRICES) {
    $level_price_impact = array_map('price2num', $level_price_impact);

    $prodcomb->variation_price = $level_price_impact[1];
    $prodcomb->variation_price_percentage = (bool) $level_price_impact_percent[1];
  } else {
    $level_price_impact = array(1 => $price_impact);
    $level_price_impact_percent = array(1 => $price_impact_percent);

    $prodcomb->variation_price = $price_impact;
    $prodcomb->variation_price_percentage = $price_impact_percent;
  }

  if ($conf->global->PRODUIT_MULTIPRICES) {
    $prodcomb->combination_price_levels = array();
    for ($i = 1; $i <= $conf->global->PRODUIT_MULTIPRICES_LIMIT; $i++) {
      $productCombinationLevel = new ProductCombinationLevel($db);
      $productCombinationLevel->fk_product_attribute_combination = $prodcomb->id;
      $productCombinationLevel->fk_price_level = $i;
      $productCombinationLevel->variation_price = $level_price_impact[$i];
      $productCombinationLevel->variation_price_percentage = (bool) $level_price_impact_percent[$i];
      $prodcomb->combination_price_levels[$i] = $productCombinationLevel;
    }
  }

  if ($prodcomb->update($user) > 0) {
    setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
    header('Location: '.dol_buildpath('/variants/combinations.php?id='.$id, 2));
    exit();
  } else {
    setEventMessages($prodcomb->error, $prodcomb->errors, 'errors');
  }
}


// Reload variants
$productCombinations = $prodcomb->fetchAllByFkProductParent($object->id);

if ($action === 'confirm_deletecombination') {
  if ($prodcomb->fetch($valueid) > 0) {
    $db->begin();

    if ($prodcomb->delete($user) > 0 && (empty($delete_product) || ($delete_product == 'on' && $prodstatic->fetch($prodcomb->fk_product_child) > 0 && $prodstatic->delete($user) > 0))) {
      $db->commit();
      setEventMessages($langs->trans('RecordSaved'), null, 'mesgs');
      header('Location: '.dol_buildpath('/variants/combinations.php?id='.$object->id, 2));
      exit();
    }

    $db->rollback();
    setEventMessages($langs->trans('ProductCombinationAlreadyUsed'), null, 'errors');
    $action = '';
  }
} elseif ($action === 'edit') {
  if ($prodcomb->fetch($valueid) < 0) {
    dol_print_error($db, $langs->trans('ErrorRecordNotFound'));
    exit();
  }

  $weight_impact = $prodcomb->variation_weight;
  $price_impact = $prodcomb->variation_price;
  $price_impact_percent = $prodcomb->variation_price_percentage;

  $productCombination2ValuePairs1 = $prodcomb2val->fetchByFkCombination($valueid);
} elseif ($action === 'confirm_copycombination') {
  //Check destination product
  $dest_product = GETPOST('dest_product');

  if ($prodstatic->fetch('', $dest_product) > 0) {
    //To prevent from copying to the same product
    if ($prodstatic->ref != $object->ref) {
      if ($prodcomb->copyAll($user, $object->id, $prodstatic) > 0) {
        header('Location: '.dol_buildpath('/variants/combinations.php?id='.$prodstatic->id, 2));
        exit();
      } else {
        setEventMessages($langs->trans('ErrorCopyProductCombinations'), null, 'errors');
      }
    }
  } else {
    setEventMessages($langs->trans('ErrorDestinationProductNotFound'), null, 'errors');
  }
}



/*
 *  View
 */

$form = new Form($db);

if (!empty($id) || !empty($ref)) {
  llxHeader("", "", $langs->trans("CardProduct".$object->type));

  $showbarcode = empty($conf->barcode->enabled) ? 0 : 1;
  if (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && empty($user->rights->barcode->lire_advance)) {
    $showbarcode = 0;
  }

  $head = product_prepare_head($object);
  $titre = $langs->trans("CardProduct".$object->type);
  $picto = ($object->type == Product::TYPE_SERVICE ? 'service' : 'product');

  print dol_get_fiche_head($head, 'combinations', $titre, -1, $picto);

  $linkback = '<a href="'.DOL_URL_ROOT.'/product/list.php?type='.$object->type.'">'.$langs->trans("BackToList").'</a>';
  $object->next_prev_filter = " fk_product_type = ".$object->type;

  dol_banner_tab($object, 'ref', $linkback, ($user->socid ? 0 : 1), 'ref', '', '', '', 0, '', '');

  print '<div class="fichecenter">';

  print '<div class="underbanner clearboth"></div>';
  print '<table class="border centpercent tableforfield">';

  // Type
  if (!empty($conf->product->enabled) && !empty($conf->service->enabled)) {
    $typeformat = 'select;0:'.$langs->trans("Product").',1:'.$langs->trans("Service");
    print '<tr><td class="titlefieldcreate">';
    print (empty($conf->global->PRODUCT_DENY_CHANGE_PRODUCT_TYPE)) ? $form->editfieldkey("Type", 'fk_product_type', $object->type, $object, $usercancreate, $typeformat) : $langs->trans('Type');
    print '</td><td>';
    print $form->editfieldval("Type", 'fk_product_type', $object->type, $object, $usercancreate, $typeformat);
    print '</td></tr>';
  }

  // TVA
  print '<tr><td class="titlefieldcreate">'.$langs->trans("DefaultTaxRate").'</td><td>';

  $positiverates = '';
  if (price2num($object->tva_tx)) {
    $positiverates .= ($positiverates ? '/' : '').price2num($object->tva_tx);
  }
  if (price2num($object->localtax1_type)) {
    $positiverates .= ($positiverates ? '/' : '').price2num($object->localtax1_tx);
  }
  if (price2num($object->localtax2_type)) {
    $positiverates .= ($positiverates ? '/' : '').price2num($object->localtax2_tx);
  }
  if (empty($positiverates)) {
    $positiverates = '0';
  }
  echo vatrate($positiverates.($object->default_vat_code ? ' ('.$object->default_vat_code.')' : ''), '%', $object->tva_npr);
  /*
  if ($object->default_vat_code)
  {
    print vatrate($object->tva_tx, true) . ' ('.$object->default_vat_code.')';
  }
  else print vatrate($object->tva_tx, true, $object->tva_npr, true);*/
  print '</td></tr>';

  // Price
  print '<tr><td>'.$langs->trans("SellingPrice").'</td><td>';
  if ($object->price_base_type == 'TTC') {
    print price($object->price_ttc).' '.$langs->trans($object->price_base_type);
  } else {
    print price($object->price).' '.$langs->trans($object->price_base_type);
  }
  print '</td></tr>';

  // Price minimum
  print '<tr><td>'.$langs->trans("MinPrice").'</td><td>';
  if ($object->price_base_type == 'TTC') {
    print price($object->price_min_ttc).' '.$langs->trans($object->price_base_type);
  } else {
    print price($object->price_min).' '.$langs->trans($object->price_base_type);
  }
  print '</td></tr>';

  // Weight
  print '<tr><td>'.$langs->trans("Weight").'</td><td>';
  if ($object->weight != '') {
    print $object->weight." ".measuringUnitString(0, "weight", $object->weight_units);
  } else {
    print '&nbsp;';
  }
  print "</td></tr>\n";

  print "</table>\n";

  print '</div>';
  print '<div style="clear:both"></div>';

  print dol_get_fiche_end();

  $listofvariantselected = '';

  // Create or edit a varian
  if ($action == 'add' || ($action == 'edit')) {
    if ($action == 'add') {
      $title = $langs->trans('NewProductCombination');
      // print dol_get_fiche_head();
      $features = $_SESSION['addvariant_'.$object->id];
      //First, sanitize
      $listofvariantselected = '<div id="parttoaddvariant">';
      if (!empty($features)) {
        $toprint = array();
        foreach ($features as $feature) {
          $explode = explode('-', $feature);
          if ($prodattr->fetch($explode[0]) <= 0 || $prodattr_val->fetch($explode[1]) <= 0) {
            continue;
          }
          $toprint[] = '<li class="select2-search-choice-dolibarr noborderoncategories" style="background: #ddd;">' . $prodattr->label.' : '.$prodattr_val->value .
            ' <a class="reposition" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=create&subaction=delete&feature='.urlencode($feature).'">' . img_delete() . '</a></li>';
        }
        $listofvariantselected .= '<div class="select2-container-multi-dolibarr" style="width: 90%;"><ul class="select2-choices-dolibarr">' . implode(' ', $toprint) . '</ul></div>';
      }
      $listofvariantselected .= '</div>';
      //print dol_get_fiche_end();
    } else {
      $title = $langs->trans('EditProductCombination');
    }

    if ($action == 'add') {
      $prodattr_all = $prodattr->fetchAll();

      if (!$selected) {
        $selected = $prodattr_all[key($prodattr_all)]->id;
      }

      $prodattr_alljson = array();

      foreach ($prodattr_all as $each) {
        $prodattr_alljson[$each->id] = $each;
      }

      ?>

    <script type="text/javascript">

      variants_available = <?php echo json_encode($prodattr_alljson); ?>;
      variants_selected = {
        index: [],
        info: []
      };

      <?php
      foreach ($productCombination2ValuePairs1 as $pc2v) {
        $prodattr_val->fetch($pc2v->fk_prod_attr_val);
        ?>
        variants_selected.index.push(<?php echo $pc2v->fk_prod_attr ?>);
        variants_selected.info[<?php echo $pc2v->fk_prod_attr ?>] = {
          attribute: variants_available[<?php echo $pc2v->fk_prod_attr ?>],
          value: {
            id: <?php echo $pc2v->fk_prod_attr_val ?>,
            label: '<?php echo $prodattr_val->value ?>'
          }
        };
        <?php
      }
      ?>

      restoreAttributes = function() {
        jQuery("select[name=attribute]").empty().append('<option value="-1">&nbsp;</option>');

        jQuery.each(variants_available, function (key, val) {
          if (jQuery.inArray(val.id, variants_selected.index) == -1) {
            jQuery("select[name=attribute]").append('<option value="' + val.id + '">' + val.label + '</option>');
          }
        });
      };


      jQuery(document).ready(function() {
        jQuery("select#attribute").change(function () {
          console.log("Change of field variant attribute");
          var select = jQuery("select#value");

          if (!jQuery(this).val().length || jQuery(this).val() == '-1') {
            select.empty();
            select.append('<option value="-1">&nbsp;</option>');
            return;
          }

          select.empty().append('<option value="">Loading...</option>');

          jQuery.getJSON("ajax/get_attribute_values.php", {
            id: jQuery(this).val()
          }, function(data) {
            if (data.error) {
              select.empty();
              select.append('<option value="-1">&nbsp;</option>');
              return alert(data.error);
            }

            select.empty();
            select.append('<option value="-1">&nbsp;</option>');

            jQuery(data).each(function (key, val) {
              keyforoption = val.id
              valforoption = val.value
              select.append('<option value="' + keyforoption + '">' + valforoption + '</option>');
            });
          });
        });
      });
    </script>

      <?php
    }

    print '<br>';

    print load_fiche_titre($title);

    print '<form method="post" id="combinationform" action="'.$_SERVER["PHP_SELF"] .'?id='.$object->id.'">'."\n";
    print '<input type="hidden" name="token" value="'.newToken().'">';
    print '<input type="hidden" name="action" value="'.(($valueid > 0) ? "update" : "create").'">'."\n";
    if ($valueid > 0) {
      print '<input type="hidden" name="valueid" value="'.$valueid.'">'."\n";
    }

    print dol_get_fiche_head();


    if ($action == 'add') {
      print '<table class="border" style="width: 100%">';
      print "<!--  Variant -->\n";
      print '<tr>';
      print '<td class="titlefieldcreate fieldrequired"><label for="attribute">'.$langs->trans('ProductAttribute').'</label></td>';
      print '<td>';
      if (is_array($prodattr_all)) {
        print '<select class="flat minwidth100" id="attribute" name="attribute">';
        print '<option value="-1">&nbsp;</option>';
        foreach ($prodattr_all as $attr) {
          //print '<option value="'.$attr->id.'"'.($attr->id == GETPOST('attribute', 'int') ? ' selected="selected"' : '').'>'.$attr->label.'</option>';
          print '<option value="'.$attr->id.'">'.$attr->label.'</option>';
        }
        print '</select>';
      }

      $htmltext = $langs->trans("GoOnMenuToCreateVairants", $langs->transnoentities("Product"), $langs->transnoentities("VariantAttributes"));
      print $form->textwithpicto('', $htmltext);
      /*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).'">';
      print $langs->trans("Create");
      print '</a>';*/

      print '</td>';
      print '</tr>';
      ?>
      <!-- Value -->
      <tr>
        <td class="fieldrequired"><label for="value"><?php echo $langs->trans('Value') ?></label></td>
        <td>
          <select class="flat minwidth100" id="value" name="value">
            <option value="-1">&nbsp;</option>
          </select>
          <?php
          $htmltext = $langs->trans("GoOnMenuToCreateVairants", $langs->transnoentities("Product"), $langs->transnoentities("VariantAttributes"));
          print $form->textwithpicto('', $htmltext);
          /*
            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).'">';
            print $langs->trans("Create");
            print '</a>';
          */
          ?>
        </td>
      </tr>
      <tr>
        <td></td><td>
          <input type="submit" class="button" name="selectvariant" id="selectvariant" value="<?php echo dol_escape_htmltag($langs->trans("SelectCombination")); ?>">
        </td>
      </tr>
      <?php
      print '<tr><td></td><td>';
      print $listofvariantselected;
      print '</td>';
      print '</tr>';

      print '</table>';
      print '<hr>';
    }

    if (is_array($productCombination2ValuePairs1)) {
      print '<table class="border" style="width: 100%">';

      // When in edit mode
      if (is_array($productCombination2ValuePairs1) && count($productCombination2ValuePairs1)) {
        ?>
        <tr>
          <td class="titlefieldcreate tdtop"><label for="features"><?php echo $langs->trans('Combination') ?></label></td>
          <td class="tdtop">
            <div class="inline-block valignmiddle quatrevingtpercent">
          <?php
          foreach ($productCombination2ValuePairs1 as $key => $val) {
            $result1 = $prodattr->fetch($val->fk_prod_attr);
            $result2 = $prodattr_val->fetch($val->fk_prod_attr_val);
            //print 'rr'.$result1.' '.$result2;
            if ($result1 > 0 && $result2 > 0) {
              print $prodattr->label.' - '.$prodattr_val->value.'<br>';
              // TODO Add delete link
            }
          }
          ?>
            </div>
            <!-- <div class="inline-block valignmiddle">
            <a href="#" class="inline-block valignmiddle button" id="delfeature"><?php echo img_edit_remove() ?></a>
            </div>-->
          </td>
          <td>
          </td>
        </tr>
        <?php
      }
      ?>
      <tr>
        <td><label for="reference"><?php echo $langs->trans('Reference') ?></label></td>
        <td><input type="text" id="reference" name="reference" value="<?php echo trim($reference) ?>"></td>
      </tr>
      <?php
      if (empty($conf->global->PRODUIT_MULTIPRICES)) {
        ?>
      <tr>
        <td><label for="price_impact"><?php echo $langs->trans('PriceImpact') ?></label></td>
        <td><input type="text" id="price_impact" name="price_impact" value="<?php echo price($price_impact) ?>">
        <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>
        </td>
      </tr>
        <?php
      } else {
        $prodcomb->fetchCombinationPriceLevels();

        for ($i = 1; $i <= $conf->global->PRODUIT_MULTIPRICES_LIMIT; $i++) {
          print '<tr>';
          print '<td><label for="level_price_impact_'.$i.'">'.$langs->trans('ImpactOnPriceLevel', $i).'</label>';
          if ($i === 1) {
            print ' <a id="apply-price-impact-to-all-level" class="classfortooltip" href="#" title="'.$langs->trans('ApplyToAllPriceImpactLevelHelp').'">('.$langs->trans('ApplyToAllPriceImpactLevel').')</a>';
          }
          print '</td>';
          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).'">';
          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>';

          print '</td>';
          print '</tr>';
        }
      }

      if ($object->isProduct()) {
        print '<tr>';
        print '<td><label for="weight_impact">'.$langs->trans('WeightImpact').'</label></td>';
        print '<td><input type="text" id="weight_impact" name="weight_impact" value="'.price($weight_impact).'"></td>';
        print '</tr>';
      }

      print '</table>';
    }

    if (!empty($conf->global->PRODUIT_MULTIPRICES)) {
      ?>
      <script>
        $(document).ready(function() {
          // Apply level 1 impact to all prices impact levels
          $('body').on('click', '#apply-price-impact-to-all-level', function(e) {
            e.preventDefault();
            let priceImpact = $( "#level_price_impact_1" ).val();
            let priceImpactPrecent = $( "#level_price_impact_percent_1" ).prop("checked");

            var multipricelimit = <?php print intval($conf->global->PRODUIT_MULTIPRICES_LIMIT); ?>

            for (let i = 2; i <= multipricelimit; i++) {
              $( "#level_price_impact_" + i ).val(priceImpact);
              $( "#level_price_impact_percent_" + i  ).prop("checked", priceImpactPrecent);
            }
          });
        });
      </script>
      <?php
    }

    print dol_get_fiche_end();
    ?>

    <div style="text-align: center">
    <input type="submit" name="create" <?php if (!is_array($productCombination2ValuePairs1)) {
      print ' disabled="disabled"';
                       } ?> value="<?php echo $action == 'add' ? $langs->trans('Create') : $langs->trans("Save") ?>" class="button button-save">
    &nbsp;
    <input type="submit" name="cancel" value="<?php echo $langs->trans("Cancel"); ?>" class="button button-cancel">
    </div>

    <?php

    print '</form>';
  } else {
    if ($action === 'delete') {
      if ($prodcomb->fetch($valueid) > 0) {
        $prodstatic->fetch($prodcomb->fk_product_child);

        print $form->formconfirm(
          "combinations.php?id=".urlencode($id)."&valueid=".urlencode($valueid),
          $langs->trans('Delete'),
          $langs->trans('ProductCombinationDeleteDialog', $prodstatic->ref),
          "confirm_deletecombination",
          array(array('label'=> $langs->trans('DeleteLinkedProduct'), 'type'=> 'checkbox', 'name' => 'delete_product', 'value' => false)),
          0,
          1
        );
      }
    } elseif ($action === 'copy') {
      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);
    }

    $comb2val = new ProductCombination2ValuePair($db);

    if ($productCombinations) {
      ?>

      <script type="text/javascript">
        jQuery(document).ready(function() {

          jQuery('input[name="select_all"]').click(function() {

            if (jQuery(this).prop('checked')) {
              var checked = true;
            } else {
              var checked = false;
            }

            jQuery('table.liste input[type="checkbox"]').prop('checked', checked);
          });

          jQuery('input[name^="select["]').click(function() {
            jQuery('input[name="select_all"]').prop('checked', false);
          });

        });
      </script>

      <?php
    }

    // Buttons
    print '<div class="tabsAction">';

    print ' <div class="inline-block divButAction">';

    print '<a href="combinations.php?id='.$object->id.'&action=add&token='.newToken().'" class="butAction">'.$langs->trans('NewProductCombination').'</a>'; // NewVariant

    if ($productCombinations) {
      print '<a href="combinations.php?id='.$object->id.'&action=copy&token='.newToken().'" class="butAction">'.$langs->trans('PropagateVariant').'</a>';
    }

    print ' </div>';

    print '</div>';



    $arrayofselected = is_array($toselect) ? $toselect : array();


    // List of variants
    print '<form method="POST" action="'.$_SERVER["PHP_SELF"] .'?id='.$object->id.'">';
    print '<input type="hidden" name="token" value="'.newToken().'">';
    print '<input type="hidden" name="action" value="massaction">';
    print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';

    // List of mass actions available
    /*
    $arrayofmassactions =  array(
      'presend'=>$langs->trans("SendByMail"),
      'builddoc'=>$langs->trans("PDFMerge"),
    );
    if ($user->rights->product->supprimer) $arrayofmassactions['predelete']='<span class="fa fa-trash paddingrightonly"></span>'.$langs->trans("Delete");
    if (in_array($massaction, array('presend','predelete'))) $arrayofmassactions=array();
    $massactionbutton=$form->selectMassAction('', $arrayofmassactions);
    */

    $aaa = '';
    if (count($productCombinations)) {
      $aaa = '<label for="massaction">'.$langs->trans('BulkActions').'</label>';
      $aaa .= '<select id="bulk_action" name="massaction" class="flat">';
      $aaa .= ' <option value="nothing">&nbsp;</option>';
      $aaa .= ' <option value="not_buy">'.$langs->trans('ProductStatusNotOnBuy').'</option>';
      $aaa .= ' <option value="not_sell">'.$langs->trans('ProductStatusNotOnSell').'</option>';
      $aaa .= ' <option value="on_buy">'.$langs->trans('ProductStatusOnBuy').'</option>';
      $aaa .= ' <option value="on_sell">'.$langs->trans('ProductStatusOnSell').'</option>';
      $aaa .= ' <option value="delete">'.$langs->trans('Delete').'</option>';
      $aaa .= '</select>';
      $aaa .= '<input type="submit" value="'.dol_escape_htmltag($langs->trans("Apply")).'" class="button small">';
    }
    $massactionbutton = $aaa;

    $title = $langs->trans("ProductCombinations");

    print_barre_liste($title, 0, $_SERVER["PHP_SELF"], '', $sortfield, $sortorder, $aaa, 0);

    print '<div class="div-table-responsive">';
    ?>
    <table class="liste">
      <tr class="liste_titre">
        <td class="liste_titre"><?php echo $langs->trans('Product') ?></td>
        <td class="liste_titre"><?php echo $langs->trans('Combination') ?></td>
        <td class="liste_titre right"><?php echo $langs->trans('PriceImpact') ?></td>
        <?php if ($object->isProduct()) {
          print'<td class="liste_titre right">'.$langs->trans('WeightImpact').'</td>';
        } ?>
        <td class="liste_titre center"><?php echo $langs->trans('OnSell') ?></td>
        <td class="liste_titre center"><?php echo $langs->trans('OnBuy') ?></td>
        <td class="liste_titre"></td>
        <?php
        print '<td class="liste_titre center">';
        $searchpicto = $form->showCheckAddButtons('checkforselect', 1);
        print $searchpicto;
        print '</td>';
        ?>
      </tr>
    <?php

    if (count($productCombinations)) {
      foreach ($productCombinations as $currcomb) {
        $prodstatic->fetch($currcomb->fk_product_child);
        print '<tr class="oddeven">';
        print '<td>'.$prodstatic->getNomUrl(1).'</td>';
        print '<td>';

        $productCombination2ValuePairs = $comb2val->fetchByFkCombination($currcomb->id);
        $iMax = count($productCombination2ValuePairs);

        for ($i = 0; $i < $iMax; $i++) {
          echo dol_htmlentities($productCombination2ValuePairs[$i]);
          if ($i !== ($iMax - 1)) {
            echo ', ';
          }
        }
        print '</td>';
        print '<td class="right">'.($currcomb->variation_price >= 0 ? '+' : '').price($currcomb->variation_price).($currcomb->variation_price_percentage ? ' %' : '').'</td>';
        if ($object->isProduct()) {
          print '<td class="right">'.($currcomb->variation_weight >= 0 ? '+' : '').price($currcomb->variation_weight).' '.measuringUnitString(0, 'weight', $prodstatic->weight_units).'</td>';
        }
        print '<td class="center">'.$prodstatic->getLibStatut(2, 0).'</td>';
        print '<td class="center">'.$prodstatic->getLibStatut(2, 1).'</td>';
        print '<td class="right">';
        print '<a class="paddingleft paddingright editfielda" href="'.$_SERVER["PHP_SELF"].'?id='.$id.'&action=edit&token='.newToken().'&valueid='.$currcomb->id.'">'.img_edit().'</a>';
        print '<a class="paddingleft paddingright" href="'.$_SERVER["PHP_SELF"].'?id='.$id.'&action=delete&token='.newToken().'&valueid='.$currcomb->id.'">'.img_delete().'</a>';
        print '</td>';
        print '<td class="nowrap center">';
        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
          $selected = 0;
          if (in_array($prodstatic->id, $arrayofselected)) {
            $selected = 1;
          }
          print '<input id="cb'.$prodstatic->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$prodstatic->id.'"'.($selected ? ' checked="checked"' : '').'>';
        }
        print '</td>';
        print '</tr>';
      }
    } else {
       print '<tr><td colspan="8"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
    }
    print '</table>';
    print '</div>';
    print '</form>';
  }
} else {
  llxHeader();
  // not found
}

// End of page
llxFooter();
$db->close();