XoopsModules25x / oledrion

admin/actions/products.php

<?php
/*
 You may not change or alter any portion of this comment or credits
 of supporting developers from this source code or any supporting source code
 which is considered copyrighted (c) material of the original comment or credit authors.

 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.
*/

/**
 * oledrion
 *
 * @copyright   {@link https://xoops.org/ XOOPS Project}
 * @license     {@link http://www.fsf.org/copyleft/gpl.html GNU public license}
 * @author      Hervé Thouzard (http://www.herve-thouzard.com/)
 */

use XoopsModules\Oledrion;

/**
 * Gestion des produits (dans l'administration)
 */
if (!defined('OLEDRION_ADMIN')) {
    exit();
}

switch ($action) {
    // ****************************************************************************************************************
    case 'default': // Gestion des produits

        // ****************************************************************************************************************
        xoops_cp_header();
        $adminObject = \Xmf\Module\Admin::getInstance();
        $adminObject->displayNavigation('index.php?op=products');

        $products = $categories = $vats = [];

        // Récupération des données uniques
        $categories = $categoryHandler->getAllCategories(new Oledrion\Parameters([
                                                                                     'start'   => 0,
                                                                                     'limit'   => 0,
                                                                                     'sort'    => 'cat_title',
                                                                                     'order'   => 'ASC',
                                                                                     'idaskey' => true,
                                                                                 ]));

        $form = "<form method='post' action='$baseurl' name='frmadddproduct' id='frmadddproduct'><input type='hidden' name='op' id='op' value='products'><input type='hidden' name='action' id='action' value='add'><input type='submit' name='btngo' id='btngo' value='"
                . _AM_OLEDRION_ADD_ITEM
                . "'></form>";
        echo $form;
        echo "<br><form method='get' action='$baseurl' name='frmaddeditproduct' id='frmaddeditproduct'>"
             . _OLEDRION_PRODUCT_ID
             . " <input type='text' name='id' id='id' value='' size='4'> <input type='hidden' name='op' id='op' value='products'><input type='radio' name='action' id='action' value='edit'>"
             . _OLEDRION_EDIT
             . " <input type='radio' name='action' id='action' value='confdelete'>"
             . _OLEDRION_DELETE
             . " <input type='submit' name='btngo' id='btngo' value='"
             . _GO
             . "'></form>";

        $vats = $vatHandler->getAllVats(new Oledrion\Parameters());

        $start = \Xmf\Request::getInt('start', 0, 'GET');

        $filter_product_id = $filter_product_cid = $filter_product_recommended = $filter_product_price = $filter_product_online = 0;
        // B.R. New
        // TODO: Code Reviewers Are these filters neccessary? Not sure what they do.
        $filter_skip_packing = $filter_skip_location = $filter_skip_delivery = 0;
        // B.R. End
        $filter_product_title = $filter_product_sku = '';

        $newFilter = false;
        $criteria  = new \CriteriaCompo();
        $criteria->add(new \Criteria('product_id', 0, '<>'));

        if (\Xmf\Request::hasVar('filter_product_id', 'POST')) {
            if (0 != \Xmf\Request::getInt('filter_product_id', 0, 'POST')) {
                $criteria->add(new \Criteria('product_id', \Xmf\Request::getInt('filter_product_id', 0, 'POST')), '=');
            }
            $filter_product_id = \Xmf\Request::getInt('filter_product_id', 0, 'POST');
            $newFilter         = true;
        }
        if (\Xmf\Request::hasVar('filter_product_cid', 'POST') && 0 != \Xmf\Request::getInt('filter_product_cid', 0, 'POST')) {
            $criteria->add(new \Criteria('product_cid', \Xmf\Request::getInt('filter_product_cid', 0, 'POST')), '=');
            $filter_product_cid = \Xmf\Request::getInt('filter_product_cid', 0, 'POST');
            $newFilter          = true;
        }
        if (\Xmf\Request::hasVar('filter_product_recommended', 'POST') && 0 != \Xmf\Request::getInt('filter_product_recommended', 0, 'POST')) {
            if (1 == \Xmf\Request::getInt('filter_product_recommended', 0, 'POST')) {
                $criteria->add(new \Criteria('product_recommended', '0000-00-00', '<>'));
            } else {
                $criteria->add(new \Criteria('product_recommended', '0000-00-00', '='));
            }
            $filter_product_recommended = \Xmf\Request::getInt('filter_product_recommended', 0, 'POST');
            $newFilter                  = true;
        }
        if (\Xmf\Request::hasVar('filter_product_title', 'POST') && '' !== xoops_trim($_POST['filter_product_title'])) {
            $criteria->add(new \Criteria('product_title', '%' . $_POST['filter_product_title'] . '%', 'LIKE'));
            $filter_product_title = $_POST['filter_product_title'];
            $newFilter            = true;
        }
        if (\Xmf\Request::hasVar('filter_product_sku', 'POST') && '' !== xoops_trim($_POST['filter_product_sku'])) {
            $criteria->add(new \Criteria('product_sku', '%' . $_POST['filter_product_sku'] . '%', 'LIKE'));
            $filter_product_sku = $_POST['filter_product_sku'];
            $newFilter          = true;
        }
        if (\Xmf\Request::hasVar('filter_product_online', 'POST') && 0 != \Xmf\Request::getInt('filter_product_online', 0, 'POST')) {
            $criteria->add(new \Criteria('product_online', \Xmf\Request::getInt('filter_product_online', 0, 'POST') - 1, '='));
            $filter_product_online = \Xmf\Request::getInt('filter_product_online', 0, 'POST');
            $newFilter             = true;
        }
        if (\Xmf\Request::hasVar('filter_product_price', 'POST') && 0 != \Xmf\Request::getInt('filter_product_price', 0, 'POST')) {
            $criteria->add(new \Criteria('product_price', \Xmf\Request::getInt('filter_product_price', 0, 'POST')), '>=');
            $filter_product_price = \Xmf\Request::getInt('filter_product_price', 0, 'POST');
            $newFilter            = true;
        }
        // B.R. Added: $filter_skip_packing $filter_skip_location $filter_skip_delivery
        if (0 == $filter_product_id && 0 == $filter_product_cid && 0 == $filter_product_recommended && 0 == $filter_product_price && 0 == $filter_product_online && '' === $filter_product_title && '' === $filter_product_sku && 0 == $filter_skip_packing && 0 == $filter_skip_location
            && 0 == $filter_skip_delivery) {
            $newFilter = true;
        }

        if (!$newFilter && isset($_SESSION['oledrion_filter'])) {
            $criteria                   = unserialize($_SESSION['oledrion_filter']);
            $filter_product_id          = $_SESSION['filter_product_id'];
            $filter_product_cid         = $_SESSION['filter_product_cid'];
            $filter_product_recommended = $_SESSION['filter_product_recommended'];
            $filter_product_title       = $_SESSION['filter_product_title'];
            $filter_product_sku         = $_SESSION['filter_product_sku'];
            $filter_product_online      = $_SESSION['filter_product_online'];
            $filter_product_price       = $_SESSION['filter_product_price'];
            // B.R. New
            $filter_skip_packing  = $_SESSION['filter_skip_packing'];
            $filter_skip_location = $_SESSION['filter_skip_location'];
            $filter_skip_delivery = $_SESSION['filter_skip_delivery'];
            // B.R. End
        }

        $_SESSION['oledrion_filter']            = serialize($criteria);
        $_SESSION['filter_product_id']          = $filter_product_id;
        $_SESSION['filter_product_cid']         = $filter_product_cid;
        $_SESSION['filter_product_recommended'] = $filter_product_recommended;
        $_SESSION['filter_product_title']       = $filter_product_title;
        $_SESSION['filter_product_sku']         = $filter_product_sku;
        $_SESSION['filter_product_online']      = $filter_product_online;
        $_SESSION['filter_product_price']       = $filter_product_price;
        // B.R. New
        $_SESSION['filter_skip_packing']  = $filter_skip_packing;
        $_SESSION['filter_skip_location'] = $filter_skip_location;
        $_SESSION['filter_skip_delivery'] = $filter_skip_delivery;
        // B.R. End

        $itemsCount = $productsHandler->getCount($criteria); // Recherche du nombre total de produits répondants aux critères
        Oledrion\Utility::htitle(_MI_OLEDRION_ADMENU4 . ' (' . $itemsCount . ')', 4);

        if ($itemsCount > $limit) {
            require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
            $pagenav = new \XoopsPageNav($itemsCount, $limit, $start, 'start', 'op=products');
        }
        $mytree = new Oledrion\XoopsObjectTree($categories, 'cat_cid', 'cat_pid');

        $selectCateg0 = $mytree->makeSelectElement('filter_product_cid', 'cat_title', '-', $filter_product_cid, true, 0, '', '');
        $selectCateg  = $selectCateg0->render();

        $onlineSelect = Oledrion\Utility::htmlSelect('filter_product_online', [2 => _YES, 1 => _NO], $filter_product_online);
        // B.R. New
        $skipPackingSelect  = Oledrion\Utility::htmlSelect('filter_skip_packing', [2 => _YES, 1 => _NO], $filter_skip_packing);
        $skipLocationSelect = Oledrion\Utility::htmlSelect('filter_skip_location', [2 => _YES, 1 => _NO], $filter_skip_location);
        $skipDeliverySelect = Oledrion\Utility::htmlSelect('filter_skip_delivery', [2 => _YES, 1 => _NO], $filter_skip_delivery);
        // B.R. End
        $recommendedSelect = Oledrion\Utility::htmlSelect('filter_product_recommended', [1 => _YES, 2 => _NO], $filter_product_recommended);

        $criteria->setLimit($limit);
        $criteria->setStart($start);
        $criteria->setSort('product_id');

        $products = $productsHandler->getObjects($criteria);
        $class    = '';
        $span     = 8;
        if (isset($pagenav) && is_object($pagenav)) {
            echo "<div align='left'>" . $pagenav->renderNav() . '</div>';
        }
        echo "<table width='100%' cellspacing='1' cellpadding='3' border='0' class='outer'>";
        echo "<tr><th align='center'>"
             . _AM_OLEDRION_ID
             . "</th><th align='center'>"
             . _OLEDRION_TITLE
             . "</th><th align='center'>"
             . _OLEDRION_CATEGORY
             . "</th><th align='center'>"
             . _OLEDRION_NUMBER
             . '<br>'
             . _OLEDRION_EXTRA_ID
             . "</th><th align='center'>"
             . _OLEDRION_ONLINE
             . "</th><th align='center'>"
             . _AM_OLEDRION_RECOMMENDED
             . "</th><th align='center'>"
             . _OLEDRION_DATE
             . '</th>';
        if (Oledrion\Utility::getModuleOption('use_price')) {
            echo "<th align='center'>" . _OLEDRION_PRICE . '</th>';
            $span = 9;
        }
        echo "<th align='center'>" . _AM_OLEDRION_ACTION . '</th></tr>';

        echo "<tr><form method='post' action='$baseurl'><th align='center'><input type='text' size='3' name='filter_product_id' id='filter_product_id' value='$filter_product_id'></th>\n";
        echo "<th align='center'><input type='text' size='25' name='filter_product_title' id='filter_product_title' value='$filter_product_title'></th>\n";
        echo "<th align='center'>" . $selectCateg . "</th>\n";
        echo "<th align='center'><input type='text' size='25' name='filter_product_sku' id='filter_product_sku' value='$filter_product_sku'></th>\n";
        echo "<th align='center'>" . $onlineSelect . "</th>\n";
        // B.R. Start
        echo "<th align='center'>" . $skipPackingSelect . "</th>\n";
        echo "<th align='center'>" . $skipLocationSelect . "</th>\n";
        echo "<th align='center'>" . $skipDeliverySelect . "</th>\n";
        // B.R. End
        echo "<th align='center'>" . $recommendedSelect . "</th>\n";
        echo "<th align='center'>&nbsp;</th>\n";
        echo "<th align='center'><input type='text' size='5' name='filter_product_price' id='filter_product_price' value='$filter_product_price'></th>\n";
        echo "<th align='center'><input type='hidden' name='op' id='op' value='products'><input type='submit' name='btngo' id='btngo' value='" . _GO . "'></th></form></tr>\n";
        foreach ($products as $item) {
            $class       = ('even' === $class) ? 'odd' : 'even';
            $id          = $item->getVar('product_id');
            $recommended = '';
            if ($item->isRecommended()) {
                // If the product is recommended, the link is displayed to stop recommending it
                $recommended = "<a href='" . $baseurl . '?op=products&action=unrecommend&product_id=' . $id . "' title='" . _AM_OLEDRION_DONOTRECOMMEND_IT . "'><img alt='" . _AM_OLEDRION_DONOTRECOMMEND_IT . "' src='" . OLEDRION_IMAGES_URL . "heart_delete.png' alt=''></a>";
            } else {
                // Otherwise we will display the link that allows us to recommend it
                $recommended = "<a href='" . $baseurl . '?op=products&action=recommend&product_id=' . $id . "' title='" . _AM_OLEDRION_RECOMMEND_IT . "'><img alt='" . _AM_OLEDRION_RECOMMEND_IT . "' src='" . OLEDRION_IMAGES_URL . "heart_add.png' alt=''></a>";
            }

            $actions = [];

            $actions[] = "<a href='$baseurl?op=products&action=related&id=" . $id . "' title='" . _OLEDRION_RELATED_PRODUCTS . "'>" . $icons['details'] . '</a>';

            $actions[] = "<a href='$baseurl?op=products&action=edit&id=" . $id . "' title='" . _OLEDRION_EDIT . "'>" . $icons['edit'] . '</a>';
            $actions[] = "<a href='$baseurl?op=products&action=copy&id=" . $id . "' title='" . _OLEDRION_DUPLICATE_PRODUCT . "'>" . $icons['copy'] . '</a>';
            $actions[] = "<a href='$baseurl?op=products&action=confdelete&id=" . $id . "' title='" . _OLEDRION_DELETE . "'>" . $icons['delete'] . '</a>';
            $online    = 1 == $item->getVar('product_online') ? _YES : _NO;
            // B.R. New
            $skipPacking  = 1 == $item->getVar('skip_packing') ? _YES : _NO;
            $skipLocation = 1 == $item->getVar('skip_location') ? _YES : _NO;
            $skipDelivery = 1 == $item->getVar('skip_delivery') ? _YES : _NO;
            // B.R. End
            echo "<tr class='" . $class . "'>\n";
            if (isset($categories[$item->getVar('product_cid')])) {
                $productCategory = $categories[$item->getVar('product_cid')]->getVar('cat_title');
                $categoryUrl     = $categories[$item->getVar('product_cid')]->getLink();
            } else {
                $productCategory = '';
                $categoryUrl     = '#';
            }
            $productLink = "<a href='" . $item->getLink() . "' target='blank'>" . $item->getVar('product_title') . '</a>';
            if ((float)$item->getVar('product_discount_price') > 0) {
                $priceLine = '<s>' . $oledrionCurrency->amountForDisplay($item->getVar('product_price')) . '</s>  ' . $oledrionCurrency->amountForDisplay($item->getVar('product_discount_price'));
            } else {
                $priceLine = $oledrionCurrency->amountForDisplay($item->getVar('product_price'));
            }

            echo "<td align='center'>"
                 . $id
                 . "</td><td align ='left'>"
                 . $productLink
                 . "</td><td align='left'><a href='"
                 . $categoryUrl
                 . "' target='blank'>"
                 . $productCategory
                 . "</a></td><td align='center'>"
                 . $item->getVar('product_sku')
                 . ' / '
                 . $item->getVar('product_extraid')
                 . "</td><td align='center'>"
                 . $online
                 . "</td><td align='center'>"
                 . $recommended
                 . "</td><td align='center'>"
                 . $item->getVar('product_date')
                 . '</td>';
            if (Oledrion\Utility::getModuleOption('use_price')) {
                echo "<td align='right'>" . $priceLine . '</td>';
            }
            echo "<td align='center'>" . implode(' ', $actions) . "</td>\n";
            echo "<tr>\n";
        }
        $class = ('even' === $class) ? 'odd' : 'even';
        echo "<tr class='" . $class . "'>\n";
        echo "<td colspan='$span' align='center'>" . $form . "</td>\n";
        echo "</tr>\n";
        echo '</table>';
        if (isset($pagenav) && is_object($pagenav)) {
            echo "<div align='right'>" . $pagenav->renderNav() . '</div>';
        }
        //require_once OLEDRION_ADMIN_PATH . 'admin_footer.php';

        break;
    // ****************************************************************************************************************
    case 'unrecommend': // Arrêter de recommander un produit

        // ****************************************************************************************************************
        $opRedirect = '?op=products';
        if (\Xmf\Request::hasVar('product_id', 'GET')) {
            $product_id = \Xmf\Request::getInt('product_id', 0, 'GET');
            $product    = null;
            $product    = $productsHandler->get($product_id);
            if (is_object($product)) {
                $product->unsetRecommended();
                if ($productsHandler->insert($product, true)) {
                    Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_OK, $baseurl . $opRedirect, 1);
                } else {
                    Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_PB, $baseurl . $opRedirect, 4);
                }
            } else {
                Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl . $opRedirect, 4);
            }
        } else {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl . $opRedirect, 4);
        }

        break;
    // ****************************************************************************************************************
    case 'recommend': // Recommander un produit

        // ****************************************************************************************************************
        $opRedirect = '?op=products';
        if (\Xmf\Request::hasVar('product_id', 'GET')) {
            $product_id = \Xmf\Request::getInt('product_id', 0, 'GET');
            $product    = null;
            $product    = $productsHandler->get($product_id);
            if (is_object($product)) {
                $product->setRecommended();
                if ($productsHandler->insert($product, true)) {
                    Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_OK, $baseurl . $opRedirect, 1);
                } else {
                    Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_PB, $baseurl . $opRedirect, 4);
                }
            } else {
                Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl . $opRedirect, 4);
            }
        } else {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl . $opRedirect, 4);
        }

        break;
    // ****************************************************************************************************************
    case 'add': // Ajout d'un produit

    case 'edit': // Edition d'un produit

        // ****************************************************************************************************************
        xoops_cp_header();
        global $xoopsUser;

        if ('edit' === $action) {
            $title = _AM_OLEDRION_EDIT_PRODUCT;
            $id    = \Xmf\Request::getInt('id', 0, 'GET');
            if (empty($id)) {
                Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl, 5);
            }
            // Item exits ?
            $item = null;
            $item = $productsHandler->get($id);
            if (!is_object($item)) {
                Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl, 5);
            }
            $edit         = true;
            $label_submit = _AM_OLEDRION_MODIFY;
        } else {
            $title = _AM_OLEDRION_ADD_PRODUCT;
            $item  = $productsHandler->create(true);
            $item->setVar('product_online', 1);
            // B.R. Start
            $item->setVar('skip_packing', 0);
            $item->setVar('skip_location', 0);
            $item->setVar('skip_delivery', 0);
            // B.R. End
            if (OLEDRION_AUTO_FILL_MANUAL_DATE) {
                $item->setVar('product_date', formatTimestamp(time(), 's'));
            }
            $label_submit = _AM_OLEDRION_ADD;
            $edit         = false;
        }

        $categories = $categoryHandler->getAllCategories(new Oledrion\Parameters());
        if (0 === count($categories)) {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_8, $baseurl, 5);
        }
        // TVA
        $vats = $vatsForDisplay = [];
        $vats = $vatHandler->getAllVats(new Oledrion\Parameters());
        if (0 == count($vats) && Oledrion\Utility::getModuleOption('use_price')) {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_9, $baseurl, 5);
        }
        foreach ($vats as $onevat) {
            $vatsForDisplay[$onevat->getVar('vat_id')] = $onevat->getVar('vat_rate');
        }

        $mytree = new Oledrion\XoopsObjectTree($categories, 'cat_cid', 'cat_pid');

        $sform = new \XoopsThemeForm($title, 'frmproduct', $baseurl);
        $sform->setExtra('enctype="multipart/form-data"');
        $sform->addElement(new \XoopsFormHidden('op', 'products'));
        $sform->addElement(new \XoopsFormHidden('action', 'saveedit'));
        $sform->addElement(new \XoopsFormHidden('product_id', $item->getVar('product_id')));
        $sform->addElement(new \XoopsFormHidden('product_submitter', $xoopsUser->getVar('uid')));

        $sform->addElement(new \XoopsFormText(_OLEDRION_TITLE, 'product_title', 50, 255, $item->getVar('product_title', 'e')), true);

        // Vendeurs *************************************************************
        $vendors = $vendorsForDisplay = [];
        $vendors = $vendorsHandler->getAllVendors(new Oledrion\Parameters());
        foreach ($vendors as $oneVendor) {
            $vendorsForDisplay[$oneVendor->getVar('vendor_id')] = $oneVendor->getVar('vendor_name');
        }
        $vendorsSelect = new \XoopsFormSelect(_OLEDRION_VENDOR, 'product_vendor_id', $item->getVar('product_vendor_id'));
        $vendorsSelect->addOptionArray($vendorsForDisplay);
        $sform->addElement($vendorsSelect, true);

        $select_categ = $mytree->makeSelectElement('product_cid', 'cat_title', '-', $item->getVar('product_cid'), true, 0, '', _AM_OLEDRION_CATEG_HLP);
        $sform->addElement($select_categ);

        // B.R. New
        $sform->addElement(new \XoopsFormRadioYN(_OLEDRION_SKIP_PACKING, 'skip_packing', $item->getVar('skip_packing')), true);
        $sform->addElement(new \XoopsFormRadioYN(_OLEDRION_SKIP_LOCATION, 'skip_location', $item->getVar('skip_location')), true);
        $sform->addElement(new \XoopsFormRadioYN(_OLEDRION_SKIP_DELIVERY, 'skip_delivery', $item->getVar('skip_delivery')), true);
        // End New

        $deliveryTime = new \XoopsFormText(_OLEDRION_DELIVERY_TIME, 'product_delivery_time', 5, 5, $item->getVar('product_delivery_time', 'e'));
        $deliveryTime->setDescription(_OLEDRION_IN_DAYS);
        $sform->addElement($deliveryTime, false);

        $sform->addElement(new \XoopsFormText(_OLEDRION_NUMBER, 'product_sku', 10, 60, $item->getVar('product_sku', 'e')), false);
        $sform->addElement(new \XoopsFormText(_OLEDRION_EXTRA_ID, 'product_extraid', 10, 50, $item->getVar('product_extraid', 'e')), false);
        $sform->addElement(new \XoopsFormText(_OLEDRION_LENGTH, 'product_length', 10, 50, $item->getVar('product_length', 'e')), false);
        $sform->addElement(new \XoopsFormText(_OLEDRION_WIDTH, 'product_width', 10, 50, $item->getVar('product_width', 'e')), false);

        $sform->addElement(new \XoopsFormText(_OLEDRION_MEASURE1, 'product_unitmeasure1', 10, 20, $item->getVar('product_unitmeasure1', 'e')), false);
        $sform->addElement(new \XoopsFormText(_OLEDRION_WEIGHT, 'product_weight', 10, 20, $item->getVar('product_weight', 'e')), false);
        $sform->addElement(new \XoopsFormText(_OLEDRION_MEASURE2, 'product_unitmeasure2', 10, 20, $item->getVar('product_unitmeasure2', 'e')), false);

        $downloadUrl = new \XoopsFormText(_OLEDRION_DOWNLOAD_URL, 'product_download_url', 50, 255, $item->getVar('product_download_url', 'e'));
        $downloadUrl->setDescription(_AM_OLEDRION_DOWNLOAD_EXAMPLE . ' ' . XOOPS_UPLOAD_PATH . '/' . 'image.png');
        $sform->addElement($downloadUrl, false);

        $sform->addElement(new \XoopsFormText(_AM_OLEDRION_URL_HLP1, 'product_url', 50, 255, $item->getVar('product_url', 'e')), false);
        $sform->addElement(new \XoopsFormText(_AM_OLEDRION_URL_HLP2, 'product_url2', 50, 255, $item->getVar('product_url2', 'e')), false);
        $sform->addElement(new \XoopsFormText(_AM_OLEDRION_URL_HLP3, 'product_url3', 50, 255, $item->getVar('product_url3', 'e')), false);

        // Images *************************************************************
        if ('edit' === $action && $item->pictureExists()) {
            $pictureTray = new \XoopsFormElementTray(_AM_OLEDRION_IMAGE1_HELP, '<br>');
            $pictureTray->addElement(new \XoopsFormLabel('', "<img src='" . $item->getPictureUrl() . "' alt='' border='0'>"));
            $deleteCheckbox = new \XoopsFormCheckBox('', 'delpicture1');
            $deleteCheckbox->addOption(1, _DELETE);
            $pictureTray->addElement($deleteCheckbox);
            $sform->addElement($pictureTray);
            unset($pictureTray, $deleteCheckbox);
        }
        $sform->addElement(new \XoopsFormFile(_AM_OLEDRION_IMAGE1_CHANGE, 'attachedfile1', Oledrion\Utility::getModuleOption('maxuploadsize')), false);

        if (!Oledrion\Utility::getModuleOption('create_thumbs')) {
            // The user is responsible for creating the thumbnail itself
            if ('edit' === $action && $item->thumbExists()) {
                $pictureTray = new \XoopsFormElementTray(_AM_OLEDRION_IMAGE2_HELP, '<br>');
                $pictureTray->addElement(new \XoopsFormLabel('', "<img src='" . $item->getThumbUrl() . "' alt='' border='0'>"));
                $deleteCheckbox = new \XoopsFormCheckBox('', 'delpicture2');
                $deleteCheckbox->addOption(1, _DELETE);
                $pictureTray->addElement($deleteCheckbox);
                $sform->addElement($pictureTray);
                unset($pictureTray, $deleteCheckbox);
            }
            $sform->addElement(new \XoopsFormFile(_AM_OLEDRION_IMAGE2_CHANGE, 'attachedfile2', Oledrion\Utility::getModuleOption('maxuploadsize')), false);
        }

        // En ligne ? *********************************************************
        $sform->addElement(new \XoopsFormRadioYN(_OLEDRION_ONLINE_HLP, 'product_online', $item->getVar('product_online')), true);
        $sform->addElement(new \XoopsFormText(_OLEDRION_DATE, 'product_date', 50, 255, $item->getVar('product_date', 'e')), false);

        $date_submit = new \XoopsFormTextDateSelect(_OLEDRION_DATE_SUBMIT, 'product_submitted', 15, $item->getVar('product_submitted', 'e'));
        $date_submit->setDescription(_AM_OLEDRION_SUBDATE_HELP);
        $sform->addElement($date_submit, false);

        $sform->addElement(new \XoopsFormHidden('product_hits', $item->getVar('product_hits')));
        $sform->addElement(new \XoopsFormHidden('product_rating', $item->getVar('product_rating')));
        $sform->addElement(new \XoopsFormHidden('product_votes', $item->getVar('product_votes')));
        $sform->addElement(new \XoopsFormHidden('product_comments', $item->getVar('product_comments')));

        // manufacturers ************************************************************
        $manufacturers = $productsManufacturers = $manufacturers_d = $productsManufacturers_d = [];
        // Recherche de tous les fabricants
        $criteria = new \Criteria('manu_id', 0, '<>');
        $criteria->setSort('manu_name');
        $manufacturers = $manufacturerHandler->getObjects($criteria);
        foreach ($manufacturers as $oneitem) {
            $manufacturers_d[$oneitem->getVar('manu_id')] = xoops_trim($oneitem->getVar('manu_name')) . ' ' . xoops_trim($oneitem->getVar('manu_commercialname'));
        }
        // Recherche des fabricants de ce produit
        if ($edit) {
            $criteria = new \CriteriaCompo();
            $criteria->add(new \Criteria('pm_product_id', $item->getVar('product_id'), '='));
            $productsManufacturers = $productsmanuHandler->getObjects($criteria);
            foreach ($productsManufacturers as $oneproduct) {
                $productsManufacturers_d[] = $oneproduct->getVar('pm_manu_id');
            }
        }
        $manufacturersSelect = new \XoopsFormSelect(_OLEDRION_MANUFACTURER, 'manufacturers', $productsManufacturers_d, 5, true);
        $manufacturersSelect->addOptionArray($manufacturers_d);
        $manufacturersSelect->setDescription(_AM_OLEDRION_SELECT_HLP);
        $sform->addElement($manufacturersSelect, true);

        // Produits relatifs ****************************************************
        $relatedProducts = $productRelated = $relatedProducts_d = $productRelated_d = [];
        // Recherche de tous les produits sauf celui-là
        $criteria = new \Criteria('product_id', $item->getVar('product_id'), '<>');
        $criteria->setSort('product_title');
        $relatedProducts = $productsHandler->getObjects($criteria);
        foreach ($relatedProducts as $oneitem) {
            $relatedProducts_d[$oneitem->getVar('product_id')] = xoops_trim($oneitem->getVar('product_title'));
        }
        // Recherche des produits relatifs à ce produit
        if ($edit) {
            $criteria = new \CriteriaCompo();
            $criteria->add(new \Criteria('related_product_id', $item->getVar('product_id'), '='));
            $productRelated = $relatedHandler->getObjects($criteria);
            foreach ($productRelated as $oneproduct) {
                $productRelated_d[] = $oneproduct->getVar('related_product_related');
            }
        }
        $productsSelect = $productsHandler->productSelector(new Oledrion\Parameters([
                                                                                        'caption'  => _OLEDRION_RELATED_PRODUCTS,
                                                                                        'name'     => 'relatedproducts',
                                                                                        'value'    => $productRelated_d,
                                                                                        'size'     => 5,
                                                                                        'multiple' => true,
                                                                                        'values'   => $productRelated_d,
                                                                                        'showAll'  => true,
                                                                                        'sort'     => 'product_title',
                                                                                        'order'    => 'ASC',
                                                                                        'formName' => 'frmproduct',
                                                                                    ]));
        $sform->addElement($productsSelect);
        // ********************************************************************

        if (Oledrion\Utility::getModuleOption('use_price')) {
            // TVA ****************************************************************
            $vatSelect = new \XoopsFormSelect(_OLEDRION_VAT, 'product_vat_id', $item->getVar('product_vat_id'));
            $vatSelect->addOptionArray($vatsForDisplay);
            $sform->addElement($vatSelect, true);

            $sform->addElement(new \XoopsFormText(_OLEDRION_PRICE, 'product_price', 20, 20, $item->getVar('product_price', 'e')), true);
            $sform->addElement(new \XoopsFormText(_AM_OLEDRION_DISCOUNT_HLP, 'product_discount_price', 20, 20, $item->getVar('product_discount_price', 'e')), false);

            $sform->addElement(new \XoopsFormText(_OLEDRION_SHIPPING_PRICE, 'product_shipping_price', 20, 20, $item->getVar('product_shipping_price', 'e')), false);
            $sform->addElement(new \XoopsFormText(_OLEDRION_ECOTAXE, 'product_ecotaxe', 10, 10, $item->getVar('product_ecotaxe', 'e')), false);
        }
        $sform->addElement(new \XoopsFormText(_OLEDRION_STOCK_QUANTITY, 'product_stock', 10, 10, $item->getVar('product_stock', 'e')), false);

        $alertStock = new \XoopsFormText(_OLEDRION_STOCK_ALERT, 'product_alert_stock', 10, 10, $item->getVar('product_alert_stock', 'e'));
        $alertStock->setDescription(_AM_OLEDRION_STOCK_HLP);
        $sform->addElement($alertStock, false);

        $editor2 = Oledrion\Utility::getWysiwygForm(_OLEDRION_SUMMARY, 'product_summary', $item->getVar('product_summary', 'e'), 15, 60, 'summary_hidden');
        if ($editor2) {

$editor2 is of type XoopsFormEditor, thus it always evaluated to true.

            $sform->addElement($editor2, false);
        }

        $editor = Oledrion\Utility::getWysiwygForm(_OLEDRION_DESCRIPTION, 'product_description', $item->getVar('product_description', 'e'), 15, 60, 'description_hidden');
        if ($editor) {

$editor is of type XoopsFormEditor, thus it always evaluated to true.

            $sform->addElement($editor, false);
        }

        // Tags
        if (Oledrion\Utility::getModuleOption('use_tags')) {
            require_once XOOPS_ROOT_PATH . '/modules/tag/include/formtag.php';
            $sform->addElement(new \XoopsModules\Tag\FormTag('item_tag', 60, 255, $item->getVar('product_id'), 0));
        }

        // META Data
        if ($manual_meta) {
            $sform->addElement(new \XoopsFormText(_AM_OLEDRION_META_KEYWORDS, 'product_metakeywords', 50, 255, $item->getVar('product_metakeywords', 'e')), false);
            $sform->addElement(new \XoopsFormText(_AM_OLEDRION_META_DESCRIPTION, 'product_metadescription', 50, 255, $item->getVar('product_metadescription', 'e')), false);
            $sform->addElement(new \XoopsFormText(_AM_OLEDRION_META_PAGETITLE, 'product_metatitle', 50, 255, $item->getVar('product_metatitle', 'e')), false);
        }
        // Fichier attaché
        if ('edit' === $action && '' !== trim($item->getVar('product_attachment')) && file_exists(XOOPS_UPLOAD_PATH . '/' . trim($item->getVar('product_attachment')))) {
            $pictureTray = new \XoopsFormElementTray(_OLEDRION_ATTACHED_FILE, '<br>');
            $pictureTray->addElement(new \XoopsFormLabel('', "<a href='" . XOOPS_UPLOAD_URL . '/' . $item->getVar('product_attachment') . "' target='_blank'>" . XOOPS_UPLOAD_URL . '/' . $item->getVar('product_attachment') . '</a>'));
            $deleteCheckbox = new \XoopsFormCheckBox('', 'delpicture3');
            $deleteCheckbox->addOption(1, _DELETE);
            $pictureTray->addElement($deleteCheckbox);
            $sform->addElement($pictureTray);
            unset($pictureTray, $deleteCheckbox);
        }
        $downloadFile = new \XoopsFormFile(_OLEDRION_ATTACHED_FILE, 'attachedfile3', Oledrion\Utility::getModuleOption('maxuploadsize'));
        $downloadFile->setDescription(_AM_OLEDRION_ATTACHED_HLP);
        $sform->addElement($downloadFile, false);

        if (Oledrion\Utility::getModuleOption('product_property1')) {
            $property1select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property1_title'), 'product_property1', $item->getVar('product_property1'));
            $property1Array  = explode('|', Oledrion\Utility::getModuleOption('product_property1'));
            foreach ($property1Array as $property1) {
                $property1select->addOption($property1);
            }
            $sform->addElement($property1select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property2')) {
            $property2select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property2_title'), 'product_property2', $item->getVar('product_property2'));
            $property2Array  = explode('|', Oledrion\Utility::getModuleOption('product_property2'));
            foreach ($property2Array as $property2) {
                $property2select->addOption($property2);
            }
            $sform->addElement($property2select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property3')) {
            $property3select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property3_title'), 'product_property3', $item->getVar('product_property3'));
            $property3Array  = explode('|', Oledrion\Utility::getModuleOption('product_property3'));
            foreach ($property3Array as $property3) {
                $property3select->addOption($property3);
            }
            $sform->addElement($property3select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property4')) {
            $property4select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property4_title'), 'product_property4', $item->getVar('product_property4'));
            $property4Array  = explode('|', Oledrion\Utility::getModuleOption('product_property4'));
            foreach ($property4Array as $property4) {
                $property4select->addOption($property4);
            }
            $sform->addElement($property4select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property5')) {
            $property5select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property5_title'), 'product_property5', $item->getVar('product_property5'));
            $property5Array  = explode('|', Oledrion\Utility::getModuleOption('product_property5'));
            foreach ($property5Array as $property5) {
                $property5select->addOption($property5);
            }
            $sform->addElement($property5select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property6')) {
            $property6select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property6_title'), 'product_property6', $item->getVar('product_property6'));
            $property6Array  = explode('|', Oledrion\Utility::getModuleOption('product_property6'));
            foreach ($property6Array as $property6) {
                $property6select->addOption($property6);
            }
            $sform->addElement($property6select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property7')) {
            $property7select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property7_title'), 'product_property7', $item->getVar('product_property7'));
            $property7Array  = explode('|', Oledrion\Utility::getModuleOption('product_property7'));
            foreach ($property7Array as $property7) {
                $property7select->addOption($property7);
            }
            $sform->addElement($property7select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property8')) {
            $property8select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property8_title'), 'product_property8', $item->getVar('product_property8'));
            $property8Array  = explode('|', Oledrion\Utility::getModuleOption('product_property8'));
            foreach ($property8Array as $property8) {
                $property8select->addOption($property8);
            }
            $sform->addElement($property8select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property9')) {
            $property9select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property9_title'), 'product_property9', $item->getVar('product_property9'));
            $property9Array  = explode('|', Oledrion\Utility::getModuleOption('product_property9'));
            foreach ($property9Array as $property9) {
                $property9select->addOption($property9);
            }
            $sform->addElement($property9select, false);
        }

        if (Oledrion\Utility::getModuleOption('product_property10')) {
            $property10select = new \XoopsFormSelect(Oledrion\Utility::getModuleOption('product_property10_title'), 'product_property10', $item->getVar('product_property10'));
            $property10Array  = explode('|', Oledrion\Utility::getModuleOption('product_property10'));
            foreach ($property10Array as $property10) {
                $property10select->addOption($property10);
            }
            $sform->addElement($property10select, false);
        }

        $buttonTray = new \XoopsFormElementTray('', '');
        $submit_btn = new \XoopsFormButton('', 'post', $label_submit, 'submit');
        $buttonTray->addElement($submit_btn);
        $sform->addElement($buttonTray);

        $sform = Oledrion\Utility::formMarkRequiredFields($sform);
        $sform->display();
        require_once OLEDRION_ADMIN_PATH . 'admin_footer.php';

        break;
    // ****************************************************************************************************************
    case 'saveedit': // Sauvegarde des informations d'un produit

        // ****************************************************************************************************************
        xoops_cp_header();
        $id = \Xmf\Request::getInt('product_id', 0, 'POST');
        if ($id > 0) {
            $edit = true;
            $item = $productsHandler->get($id);
            if (!is_object($item)) {
                Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl, 5);
            }
            $item->unsetNew();
            $add = false;
        } else {
            $item = $productsHandler->create(true);
            $edit = false;
            $add  = true;
        }
        $opRedirect = 'products';
        $item->setVars($_POST);
        $item->setVar('product_submitted', strtotime($_POST['product_submitted']));

        // Suppression de l'image principale
        if (\Xmf\Request::hasVar('delpicture1', 'POST') && 1 == \Xmf\Request::getInt('delpicture1', 0, 'POST')) {
            $item->deletePicture();
        }

        // Suppression de la vignette
        if (\Xmf\Request::hasVar('delpicture2', 'POST') && 1 == \Xmf\Request::getInt('delpicture2', 0, 'POST')) {
            $item->deleteThumb();
        }
        if (\Xmf\Request::hasVar('delpicture3', 'POST') && 1 == \Xmf\Request::getInt('delpicture3', 0, 'POST')) {
            $item->deleteAttachment();
        }

        // Upload de la grande image
        $destname    = '';
        $mainPicture = '';
        $res1        = Oledrion\Utility::uploadFile(0, OLEDRION_PICTURES_PATH);
        if (true === $res1) {
            $mainPicture = $destname;
            if (Oledrion\Utility::getModuleOption('resize_main')) {
                // On redimensionne l'image principale
                Oledrion\Utility::resizePicture(OLEDRION_PICTURES_PATH . '/' . $destname, OLEDRION_PICTURES_PATH . '/' . $destname, Oledrion\Utility::getModuleOption('images_width'), Oledrion\Utility::getModuleOption('images_height'), true);
            }
            $item->setVar('product_image_url', basename($destname));
        } else {
            if (false !== $res1) {
                echo $res1;
            }
        }

        $indiceAttached = 2;
        // Upload de la vignette
        if (!Oledrion\Utility::getModuleOption('create_thumbs')) {
            // L'utilisateur se charge de créer la vignette lui-même
            $destname = '';
            $res2     = Oledrion\Utility::uploadFile(1, OLEDRION_PICTURES_PATH);
            if (true === $res2) {
                $item->setVar('product_thumb_url', basename($destname));
            } else {
                if (false !== $res2) {
                    echo $res2;
                }
            }
        } else {
            // Il faut créer la vignette pour l'utilisateur
            $indiceAttached = 1;
            if ('' !== xoops_trim($mainPicture)) {
                $thumbName = OLEDRION_THUMBS_PREFIX . $mainPicture;
                Oledrion\Utility::resizePicture(OLEDRION_PICTURES_PATH . '/' . $mainPicture, OLEDRION_PICTURES_PATH . '/' . $thumbName, Oledrion\Utility::getModuleOption('thumbs_width'), Oledrion\Utility::getModuleOption('thumbs_height'), true);
                $item->setVar('product_thumb_url', $thumbName);
            }
        }

        // Téléchargement du fichier attaché
        $destname = '';
        $res3     = Oledrion\Utility::uploadFile($indiceAttached, OLEDRION_ATTACHED_FILES_PATH);
        if (true === $res3) {
            $item->setVar('product_attachment', basename($destname));
        } else {
            if (false !== $res3) {
                echo $res3;
            }
        }

        $res = $productsHandler->insert($item);
        if ($res) {
            if (Oledrion\Utility::getModuleOption('use_tags')) {
                $tagHandler = \XoopsModules\Tag\Helper::getInstance()->getHandler('Tag'); // xoops_getModuleHandler('tag', 'tag');
                $tagHandler->updateByItem($_POST['item_tag'], $item->getVar('product_id'), $xoopsModule->getVar('dirname'), 0);

The method updateByItem() does not exist on XoopsObjectHandler. It seems like you code against a sub-type of XoopsObjectHandler such as XoopsPersistableObjectHandler.

            }

            $id = $item->getVar('product_id');
            // Notifications ******************************************************
            if (true === $add) {
                //$plugins = Plugin::getInstance();
                //$plugins->fireAction(Plugin::EVENT_ON_PRODUCT_CREATE, new Oledrion\Parameters(array('product' => $item)));
            }
            // Gestion des fabricants ************************************************
            if ($edit) {
                // Suppression préalable
                $criteria = new \CriteriaCompo();
                $criteria->add(new \Criteria('pm_product_id', $id, '='));
                $productsmanuHandler->deleteAll($criteria);
            }
            // Puis sauvegarde des données
            if (\Xmf\Request::hasVar('manufacturers', 'POST')) {
                foreach ($_POST['manufacturers'] as $id2) {
                    $item2 = $productsmanuHandler->create(true);
                    $item2->setVar('pm_product_id', $id);
                    $item2->setVar('pm_manu_id', (int)$id2);
                    $res = $productsmanuHandler->insert($item2);
                }
            }

            // Gestion des produits relatifs ****************************************
            if ($edit) {
                // Suppression préalable
                $criteria = new \CriteriaCompo();
                $criteria->add(new \Criteria('related_product_id', $id, '='));
                $relatedHandler->deleteAll($criteria);
            }
            // Puis sauvegarde des données
            if (\Xmf\Request::hasVar('relatedproducts', 'POST')) {
                foreach ($_POST['relatedproducts'] as $id2) {
                    $item2 = $relatedHandler->create(true);
                    $item2->setVar('related_product_id', $id);
                    $item2->setVar('related_product_related', (int)$id2);
                    $res = $relatedHandler->insert($item2);
                }
            }
            Oledrion\Utility::updateCache();
            Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_OK, $baseurl . '?op=' . $opRedirect, 2);
        } else {
            Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_PB, $baseurl . '?op=' . $opRedirect, 5);
        }

        break;
    // ****************************************************************************************************************
    case 'copy': // Copier un produit

        // ****************************************************************************************************************
        xoops_cp_header();
        $id = \Xmf\Request::getInt('id', 0, 'GET');
        if (empty($id)) {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl, 5);
        }
        $opRedirect = 'products';
        $product    = null;
        $product    = $productsHandler->get($id);
        if (is_object($product)) {
            $newProduct   = $productsHandler->cloneProduct($product);
            $newProductId = $newProduct->product_id;
            if (false !== $newProduct) {
                Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_OK, $baseurl . '?op=' . $opRedirect . '&action=edit&id=' . $newProductId, 2);
            } else {
                Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_PB, $baseurl . '?op=' . $opRedirect, 5);
            }
        }

        break;
    // ****************************************************************************************************************
    case 'confdelete': // Confirmation de la suppression d'un produit

        // ****************************************************************************************************************
        xoops_cp_header();

        $id = \Xmf\Request::getInt('id', 0, 'GET');
        if (0 == $id) {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl, 5);
        }
        $item = $productsHandler->get($id);
        if (!is_object($item)) {
            Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl, 5);
        }
        xoops_confirm(['op' => 'products', 'action' => 'delete', 'id' => $id], 'index.php', _AM_OLEDRION_CONF_DELITEM . '<br>' . $item->getVar('product_title'));

        break;
    // ****************************************************************************************************************
    case 'delete': // Suppression d'un produit

        // ****************************************************************************************************************
        xoops_cp_header();
        $id = \Xmf\Request::getInt('id', 0, 'POST');
        if (0 == $id) {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl, 5);
        }
        $opRedirect = 'products';
        $tblTmp     = [];
        $tblTmp     = $caddyHandler->getCommandIdFromProduct($id);
        if (0 === count($tblTmp)) {
            $item = null;
            $item = $productsHandler->get($id);
            if (is_object($item)) {
                $res = $shelf->deleteProduct($item, true);
                if ($res) {
                    Oledrion\Utility::updateCache();
                    xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'new_product', $id);
                    Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_OK, $baseurl . '?op=' . $opRedirect, 2);
                } else {
                    Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_PB, $baseurl . '?op=' . $opRedirect, 5);
                }
            } else {
                Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl . '?op=' . $opRedirect, 5);
            }
        } else {
            Oledrion\Utility::htitle(_AM_OLEDRION_SORRY_NOREMOVE, 4);
            $tblTmp2 = [];
            $tblTmp2 = $commandsHandler->getObjects(new \Criteria('cmd_id', '(' . implode(',', $tblTmp) . ')', 'IN'), true);
            echo "<table width='100%' cellspacing='1' cellpadding='3' border='0' class='outer'>";
            $class = '';
            echo "<tr><th align='center'>" . _AM_OLEDRION_ID . "</th><th align='center'>" . _AM_OLEDRION_DATE . "</th><th align='center'>" . _AM_OLEDRION_CLIENT . "</th><th align='center'>" . _AM_OLEDRION_TOTAL_SHIPP . '</th></tr>';
            foreach ($tblTmp2 as $item) {
                $class = ('even' === $class) ? 'odd' : 'even';
                $date  = formatTimestamp(strtotime($item->getVar('cmd_date')), 's');
                echo "<tr class='" . $class . "'>\n";
                echo "<td align='right'>"
                     . $item->getVar('cmd_id')
                     . "</td><td align='center'>"
                     . $date
                     . "</td><td align='center'>"
                     . $item->getVar('cmd_lastname')
                     . ' '
                     . $item->getVar('cmd_firstname')
                     . "</td><td align='center'>"
                     . $item->getVar('cmd_total')
                     . ' '
                     . Oledrion\Utility::getModuleOption('money_short')
                     . ' / '
                     . $item->getVar('cmd_shipping')
                     . ' '
                     . Oledrion\Utility::getModuleOption('money_short')
                     . "</td>\n";
                echo "<tr>\n";
            }
            echo '</table>';
            require_once OLEDRION_ADMIN_PATH . 'admin_footer.php';
        }

        break;
    // **********************************************************************************************
    case 'related':
        // ******************************************************************************************

        xoops_cp_header();
        global $xoopsUser;

        $id = \Xmf\Request::getInt('id', 0, 'GET');
        if (empty($id)) {
            Oledrion\Utility::redirect(_AM_OLEDRION_ERROR_1, $baseurl, 5);
        }
        // Item exits ?
        $item = null;
        $item = $productsHandler->get($id);
        if (!is_object($item)) {
            Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl, 5);
        }

        //        $criteria = new \Criteria(/*'product_id', $item->getVar('product_id'), '<>'*/);
        $criteria = new \Criteria('product_id', $item->getVar('product_id'), '<>');
        $criteria->setSort('product_title');
        $relatedProducts = $productsHandler->getObjects($criteria);
        foreach ($relatedProducts as $oneitem) {
            $relatedProducts_d[$oneitem->getVar('product_id')] = xoops_trim($oneitem->getVar('product_title'));
        }

        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('related_product_id', $item->getVar('product_id'), '='));
        $productRelated = $relatedHandler->getObjects($criteria);
        foreach ($productRelated as $oneproduct) {
            $productRelated_d[$oneproduct->getVar('related_product_related')]['id']      = $oneproduct->getVar('related_product_related');
            $productRelated_d[$oneproduct->getVar('related_product_related')]['title']   = $relatedProducts_d[$oneproduct->getVar('related_product_related')];
            $productRelated_d[$oneproduct->getVar('related_product_related')]['percent'] = $oneproduct->getVar('related_product_percent');
        }

        $sform = new \XoopsThemeForm('related', 'frmproduct', $baseurl);
        $sform->setExtra('enctype="multipart/form-data"');
        $sform->addElement(new \XoopsFormHidden('op', 'products'));
        $sform->addElement(new \XoopsFormHidden('action', 'relatedsave'));
        $sform->addElement(new \XoopsFormHidden('product_id', $item->getVar('product_id')));

        foreach ($productRelated_d as $value) {
            $sform->addElement(new \XoopsFormText($value['title'], $value['id'], 5, 5, $value['percent']), false);
        }

        $buttonTray = new \XoopsFormElementTray('', '');
        $submit_btn = new \XoopsFormButton('', 'post', _SUBMIT, 'submit');
        $buttonTray->addElement($submit_btn);
        $sform->addElement($buttonTray);
        $sform = Oledrion\Utility::formMarkRequiredFields($sform);
        $sform->display();

        require_once OLEDRION_ADMIN_PATH . 'admin_footer.php';

        break;
    // **********************************************************************************************
    case 'relatedsave':
        // ******************************************************************************************

        xoops_cp_header();
        $id   = \Xmf\Request::getInt('product_id', 0, 'POST');
        $item = $productsHandler->get($id);
        if (!is_object($item)) {
            Oledrion\Utility::redirect(_AM_OLEDRION_NOT_FOUND, $baseurl, 5);
        }

        foreach ($_POST as $related => $percent) {
            if (is_numeric($related)) {
                $relatedHandler->updatePercent($id, $related, $percent);
            }
        }

        $opRedirect = 'products';
        Oledrion\Utility::redirect(_AM_OLEDRION_SAVE_OK, $baseurl . '?op=' . $opRedirect, 5);

        break;
}