GX-Entwicklung

   categories_view.php 2019-06-26

   Copyright (c) 2019 Gambio GmbH

defined('_VALID_XTC') or die('Direct Access to this location is not allowed.');

$t_page_token = $_SESSION['coo_page_token']->generate_token();

// get sorting option and switch accordingly

if ($_GET['sorting']) {

            break;

            $prodsort   = 'p.products_name ASC';

            $prodsort   = 'p.products_name DESC';

        case 'startpage'       :

            $catsort    = 'c.sort_order ASC'; //default

            $prodsort   = 'p.products_startpage ASC';

            break;

        case 'startpage-desc'  :

            $catsort    = 'c.sort_order DESC'; //default

            $prodsort   = 'p.products_startpage DESC';

            break;

            $prodsort   = 'p.products_name ASC';

} else {

    $catsort    = 'c.sort_order, cd.categories_name ASC';

    $prodsort   = 'p.products_sort, p.products_name ASC';

}

    'productOverviewDropdownBtn');

    'categoryOverviewDropdownBtn');

    'multiCategoryOverviewDropdownBtn');

    $caretInformation = array();

    $caretInformation['activeCaret'] = 'false';

    $caretInformation['sortingDirection'] = 'asc';

    // By default the table is sorted by the sort column

    if($elementName === 'sort' && !isset($_GET['sorting']))

    {

        $caretInformation['activeCaret'] = 'true';

    }

    else if($_GET['sorting'] === $elementName . '-desc')

    {

        $caretInformation['sortingDirection'] = 'desc';

        $caretInformation['activeCaret'] = 'true';

    }

    else if($_GET['sorting'] === $elementName)

    {

        $caretInformation['activeCaret'] = 'true';

    }

    return $caretInformation;

    gm_set_conf('NUMBER_OF_PRODUCTS_PER_PAGE', $_POST['number_of_products_per_page']);

<!-- categories_view HTML part begin -->

<style type="text/css">

	.lightbox_package{

		position: absolute;

		width: 100%;

		height: 100%;

	}

	.lightbox_shadow{

		position: absolute;

		width: 100%;

		height: 100%;

	}

	.lightbox_package .lightbox_border_top,

	.lightbox_package .lightbox_border_bottom{

		display: none;

	}

	.lightbox_package .google_category_save{

		height: 32px;

	}

</style>

	<tr>

		<td>

			<div class="pageHeading" style="float:left; background-image:url(html/assets/images/legacy/gm_icons/artkatalog.png)">

                <?php

                echo HEADING_TITLE;

                if(isset($_GET['cPath']))

                {

                    /** @var CategoryReadService $categoryReadService */

                    $categoryReadService = StaticGXCoreLoader::getService('CategoryRead');

                    $categoryIds         = explode('_', $_GET['cPath']);

                    $categoryNames       = array();

                    foreach($categoryIds as $categoryId)

                    {

                        try

                        {

                            $category        = $categoryReadService->getCategoryById(new IdType((int)$categoryId));

                            $categoryNames[] = $category->getName(new LanguageCode(new NonEmptyStringType($_SESSION['language_code'])));

                        }

                        catch(Exception $e)

                        {

                            // ignore

                        }

                    }

                    if(count($categoryNames))

                    {

                        echo ': ' . implode(' > ', $categoryNames);

                    }

                }

                ?>

			</div>

			<div class="gx-container create-new-wrapper">

				<div class="create-new-container pull-right">

					<div

						data-use-button_dropdown="true"

						data-custom_caret_btn_class="btn-success"

					>

						<button data-gx-extension="link" data-link-url="<?php echo xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_product') ?>" class="btn btn-success"><i class="fa fa-plus btn-icon"></i>

                            <?php echo $GLOBALS['languageTextManager']->get_text('create', 'buttons'); ?>

						</button>

						<ul>

							<li><span data-gx-extension="link" data-link-url="<?php echo xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_product') ?>"><?php echo HEADING_NAME; ?></span></li>

							<li><span data-gx-extension="link" data-link-url="<?php echo xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_category') ?>"><?php echo HEADING_CATEGORY; ?></span></li>

						</ul>

					</div>

				</div>

			</div>

		</td>

	</tr>

	<tr>

		<td>

			<table data-gx-widget="table_sorting" border="0" width="100%" cellspacing="0" cellpadding="0">

				<tr>

					<!-- categories & products column STARTS -->

					<td valign="top">

						<!-- categories and products table -->

						<table border="0"

						       width="100%"

						       cellspacing="0"

						       cellpadding="0"

						       class="gx-compatibility-table gx-categories-table"

						       data-gx-compatibility="categories/categories_table_controller row_selection"

						       data-gx-extension="toolbar_icons visibility_switcher"

						       data-toolbar_icons-large="true"

						       data-toolbar_icons-fixedwidth="true"

						       data-visibility_switcher-selections="div.action-list">

							<tr class="dataTableHeadingRow">

								<td class="dataTableHeadingContent" align="center" style="width: 13px">

									<input type="checkbox" id="gm_check" />

								</td>

                                <?php

                                $sortCaret = _getCaret('sort');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="sort"

								    data-direction="<?php echo $sortCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $sortCaret['activeCaret']; ?>"

								    align="center" style="width: 125px">

                                    <?php

                                    echo TABLE_HEADING_SORT;

                                    ?>

								</td>

                                <?php

                                $nameCaret = _getCaret('name');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="name"

								    data-direction="<?php echo $nameCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $nameCaret['activeCaret']; ?>"

								    align="center"

								    style="width: 300px">

                                    <?php

                                    echo TABLE_HEADING_CATEGORIES_PRODUCTS;

                                    ?>

								</td>

                                <?php

                                $modelCaret = _getCaret('model');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="model"

								    data-direction="<?php echo $modelCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $modelCaret['activeCaret']; ?>"

								    align="center"

								    style="width: 150px">

                                    <?php

                                    echo TABLE_HEADING_PRODUCTS_MODEL;

                                    ?>

								</td>

                                <?php

                                $stockCaret = _getCaret('stock');

                                // check Produkt and attributes stock

                                if (STOCK_CHECK == 'true') {

                                    echo '<td class="dataTableHeadingContent cursor-pointer"

                                }

                                ?>

                                <?php

                                $statusCaret = _getCaret('status');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="status"

								    data-direction="<?php echo $statusCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $statusCaret['activeCaret']; ?>"

								    align="center"

								    style="width: 60px">

                                    <?php

                                    echo TABLE_HEADING_STATUS;

                                    ?>

								</td>

                                <?php

                                $startPageCaret = _getCaret('startpage');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="startpage"

								    data-direction="<?php echo $startPageCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $startPageCaret['activeCaret']; ?>"

								    align="center"

								    style="width: 75px">

                                    <?php echo

                                    TABLE_HEADING_STARTPAGE;

                                    ?>

								</td>

                                <?php

                                $priceCaret = _getCaret('price');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="price"

								    data-direction="<?php echo $priceCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $priceCaret['activeCaret']; ?>"

								    align="center"

								    style="width: 120px">

                                    <?php

                                    echo TABLE_HEADING_PRICE;

                                    ?>

								</td>

                                <?php

                                $discountCaret = _getCaret('discount');

                                ?>

								<td class="dataTableHeadingContent cursor-pointer"

								    data-use-table_sorting="true"

								    data-section="categories"

								    data-column="discount"

								    data-direction="<?php echo $discountCaret['sortingDirection']; ?>"

								    data-active-caret="<?php echo $discountCaret['activeCaret']; ?>"

								    align="center"

								    style="width: 65px">

                                    <?php

                                    echo TABLE_HEADING_MAX;

                                    ?>

								</td>

								<td class="dataTableHeadingContent" align="center" style="min-width: 215px">

									 

								</td>

							</tr>

							<tr class="dataTableHeadingRow_sortbar">

								<td class="dataTableHeadingContent_sortbar" width="5%" align="center">

									<input type="checkbox" onClick="javascript:CheckAll(this.checked);">

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="7%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'sort'); ?>

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="25%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'name'); ?>

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="10%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'model'); ?>

								</td>

                                <?php

                                // check Produkt and attributes stock

                                if (STOCK_CHECK == 'true') {

                                    echo '<td class="dataTableHeadingContent_sortbar" align="center" width="15%">' . xtc_sorting(FILENAME_CATEGORIES,'stock') . '</td>';

                                }

                                ?>

								<td class="dataTableHeadingContent_sortbar" align="center" width="7%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'status'); ?>

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="7%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'startpage'); ?>

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="10%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'price'); ?>

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="7%">

                                    <?php echo xtc_sorting(FILENAME_CATEGORIES,'discount'); ?>

								</td>

								<td class="dataTableHeadingContent_sortbar" align="center" width="13%"></td>

							</tr>

                            <?php

                            //multi-actions form STARTS

                            if (xtc_not_null($_POST['multi_categories']) || xtc_not_null($_POST['multi_products'])) {

                                $action = "action=multi_action_confirm&" . xtc_get_all_get_params(array('cPath', 'action')) . 'cPath=' . $cPath;

                            } else {

                                $action = "action=multi_action&" . xtc_get_all_get_params(array('cPath', 'action')) . 'cPath=' . $cPath;

                            }

                            // echo xtc_draw_form('multi_action_form', FILENAME_CATEGORIES, $action, 'post', 'onsubmit="javascript:return CheckMultiForm()"');

                            //add current category id in $_POST

                            echo '<input type="hidden" id="cPath" name="cPath" value="' . $cPath . '">';

                            // ----------------------------------------------------------------------------------------------------- //

                            // WHILE loop to display categories STARTS

                            // ----------------------------------------------------------------------------------------------------- //

                            $categories_count = 0;

                            $rows = 0;

                            if ($_GET['search']) {

                                $keyword = trim(str_replace('*', '%', $_GET['search']));

                                $categories_query = xtc_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' and cd.categories_name like '" . xtc_db_input($keyword) . "' order by " . $catsort);

                                // check of num rows = 0, if so, then start another search with: cd.categories_name like '%" . xtc_db_input($keyword) . "%'

                                if(xtc_db_num_rows($categories_query) === 0)

                                {

                                    $categories_query = xtc_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' and cd.categories_name like '%" . xtc_db_input($keyword) . "%' order by " . $catsort);

                                }

                            } else {

                                $categories_query = xtc_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by " . $catsort);

                            }

                            $tmp_c_path = false;

                            while ($categories = xtc_db_fetch_array($categories_query)) {

                                $categories_count++;

                                $rows++;

                                if ($_GET['search'])

                                {

                                    $cPath = xtc_get_category_path($categories['parent_id']);

                                    if($tmp_c_path === false)

                                    {

                                        $tmp_c_path = $cPath;

                                    }

                                }

                                if ( ((!$_GET['cID']) && (!$_GET['pID']) || (@$_GET['cID'] == $categories['categories_id'])) && (!$cInfo) && (substr($_GET['action'], 0, 4) != 'new_') ) {

                                    $cInfo = new objectInfo($categories);

                                }

                                ?>

								<tr class="dataTableRow visibility_switcher row_selection"

								    data-id="<?php echo $categories['categories_id'] ?>"

								    data-cpath="<?php echo $cPath ?>"

								    data-is-product="false"

								>

									<td class="categories_view_data"><input type="checkbox" class="checkbox" name="multi_categories[]" value="<?php echo $categories['categories_id'] . '" '; if (is_array($_POST['multi_categories'])) { if (in_array($categories['categories_id'], $_POST['multi_categories'])) { echo 'checked="checked"'; } } ?>></td>

									<td class="categories_view_data" style="text-align: left; padding-left: 8px;">

                                        <?php

                                        // BOF GM_MOD:

                                        $categoryHref = xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID', 'search')) . xtc_get_path($categories['categories_id']));

                                        echo '<a class="btn-folder" href="' . $categoryHref . '"></a>

                                        ?>

									</td>

									<td class="categories_view_data"></td>

                                    <?php

                                    // check product and attributes stock

                                    if (STOCK_CHECK == 'true') {

                                        echo '<td class="categories_view_data"></td>';

                                    }

                                    ?>

									<td class="categories_view_data">

                                        <?php

                                        //show status icon

                                        echo '<div data-gx-widget="checkbox"

                                                                                      . 'action=setcflag&flag=0&cID=' . $categories['categories_id']

                                                                                      . '&cPath=' . $cPath

                                                                                      . '&page_token=' . $t_page_token) . '"></div>';

                                        ?>

									</td>

									<td class="categories_view_data"></td>

									<td class="categories_view_data"></td>

									<td class="categories_view_data"></td>

									<td class="categories_view_data">

										<div class="action-list pull-right">

											<!-- ROW ACTIONS - BUTTON DROPDOWN WIDGET -->

											<a class="action-icon"

											   title="<?php echo BUTTON_OPEN ?>"

											   href="<?php echo xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array(

                                                       'cPath',

                                                       'action',

                                                       'pID',

                                                       'cID',

                                                       'search'

                                                   ))

                                                                                                   . xtc_get_path($categories['categories_id'])); ?>">

												<i class="fa fa-folder-open-o"></i>

											</a>

											<a class="action-icon" href="#" title="<?php echo BUTTON_DELETE ?>">

												<i class="fa fa-trash-o"></i>

											</a>

											<div class="category-dropdown-button"

											     data-use-button_dropdown="true"

											     data-config_key="categoryOverviewDropdownBtn"

											     data-config_value="<?php echo $categoryOverviewDropdownBtn; ?>"

											>

												<button></button>

												<ul></ul>

											</div>

										</div>

									</td>

								</tr>

                                <?php

                                // ----------------------------------------------------------------------------------------------------- //

                            } // WHILE loop to display categories ENDS

                            // ----------------------------------------------------------------------------------------------------- //

                            $products_temp_sql = <<<SQL

CREATE TEMPORARY TABLE %s

 SELECT

        p.products_startpage_sort

FROM  %s p

inner join %s pd

on p.products_id = pd.products_id

and pd.language_id = '%s'

WHERE pd.products_name like '%s' OR p.products_model LIKE '%s'

SQL;

                            // Set query string

                            $products_count = 0;

                            if ($_GET['search']) {

                                $keyword = trim(str_replace('*', '%', $_GET['search']));

                                $products_temp_query_raw = sprintf(

                                    $products_temp_sql,

                                    'tempProducts',

                                    TABLE_PRODUCTS,

                                    TABLE_PRODUCTS_DESCRIPTION,

                                    $_SESSION['languages_id'],

                                    xtc_db_input($keyword),

                                    xtc_db_input($keyword)

                                );

                                $products_temp_query = xtc_db_query($products_temp_query_raw);

                                $products_query_raw = " select p.*, p2c.categories_id from tempProducts p , products_to_categories p2c where p.products_id = p2c.products_id  ORDER BY ".$prodsort;

                            } else {

                                $products_query_raw = "

        p.products_name,

        p.products_startpage_sort

        FROM (select p.products_tax_class_id,

                     p.products_sort,

                     p.products_id,

                     p.products_model,

                     pd.products_name,

                     p.products_quantity,

                     p.products_image,

                     p.products_price,

                     p.products_discount_allowed,

                     p.products_date_added,

                     p.products_last_modified,

                     p.products_date_available,

                     p.products_status,

                     p.products_startpage,

                     p.products_startpage_sort

                     from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c

                     WHERE p.products_id = pd.products_id

                     AND pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

                     AND p.products_id = p2c.products_id

                     AND p2c.categories_id = '" . $current_category_id . "'

        ) p ORDER BY " . $prodsort;

                            }

                            // Do the DB query

                            $products_query = xtc_db_query($products_query_raw);

                            // check if for search num rows = 0, if so, then start another search

                            if(isset($_GET['search']) && xtc_db_num_rows($products_query) === 0)

                            {

                                $products_temp_query_raw = sprintf(

                                    $products_temp_sql,

                                    'tempProducts2',

                                    TABLE_PRODUCTS,

                                    TABLE_PRODUCTS_DESCRIPTION,

                                    $_SESSION['languages_id'],

                                    '%'.xtc_db_input($keyword).'%',

                                    '%'.xtc_db_input($keyword).'%'

                                );

                                $products_temp_query = xtc_db_query($products_temp_query_raw);

                                $products_query_raw = "select p.*, p2c.categories_id from tempProducts2 p , products_to_categories p2c where p.products_id = p2c.products_id  ORDER BY ".$prodsort;

                            }

                            // Splitting fetched products result into pages

                            $products_split = new splitPageResults($_GET['page'], gm_get_conf('NUMBER_OF_PRODUCTS_PER_PAGE', 'ASSOC', true), $products_query_raw, $products_query_numrows);

                            // Do the DB query

                            $products_query = xtc_db_query($products_query_raw);

                            $productattributesInstalled = (boolean)gm_get_conf('MODULE_CENTER_PRODUCTATTRIBUTES_INSTALLED') ? 'true' : 'false';

                            // ----------------------------------------------------------------------------------------------------- //

                            // WHILE loop to display products STARTS

                            // ----------------------------------------------------------------------------------------------------- //

                            while ($products = xtc_db_fetch_array($products_query)) {

                                $products_count++;

                                $rows++;

                                // Get categories_id for product if search

                                if ($_GET['search'])

                                {

                                    $cPath = xtc_get_category_path($products['categories_id']);

                                    if($tmp_c_path === false)

                                    {

                                        $tmp_c_path = $cPath;

                                    }

                                }

                                if ( ((!$_GET['pID']) && (!$_GET['cID']) || (@$_GET['pID'] == $products['products_id'])) && (!$pInfo) && (!$cInfo) && (substr($_GET['action'], 0, 4) != 'new_') ) {

                                    // find out the rating average from customer reviews

                                    $reviews_query = xtc_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . $products['products_id'] . "'");

                                    $reviews = xtc_db_fetch_array($reviews_query);

                                    $pInfo_array = xtc_array_merge($products, $reviews);

                                    $pInfo = new objectInfo($pInfo_array);

                                }

                                // check if there is a special offer for the product

                                $query = 'SELECT specials_id FROM specials WHERE products_id = ' . (int)$products['products_id'];

                                $result = xtc_db_query($query);

                                $specialId = null;

                                if(xtc_db_num_rows($result))

                                {

                                    $row = xtc_db_fetch_array($result);

                                    $specialId = (int)$row['specials_id'];

                                }

                                ?>

                                <?php

                                //checkbox again after submit and before final submit

                                unset($is_checked);

                                if (is_array($_POST['multi_products'])) {

                                    if (in_array($products['categories_id'] . '_' . $products['products_id'], $_POST['multi_products'])) {

                                        $is_checked = ' checked="checked"';

                                    }

                                }

                                ?>

								<tr class="dataTableRow visibility_switcher row_selection"

								    data-gx-compatibility="row_selection"

								    data-id="<?php echo $products['products_id']; ?>"

								    data-cpath="<?php echo $cPath ?>"

								    data-is-product="true"

                                    <?php echo isset($specialId) ? 'data-special-id="' . $specialId  . '"' : ''; ?>

								>

									<td class="categories_view_data">

										<input type="checkbox" class="checkbox" name="multi_products[]" value="<?php echo $products['categories_id'] . '_' . $products['products_id']; ?>" <?php echo $is_checked; ?>>

									</td>

									<td class="categories_view_data">

                                        <?php

                                        if ($current_category_id == 0){

                                            echo $products['products_startpage_sort'];

                                        } else {

                                            echo $products['products_sort'];

                                        }

                                        ?>

									</td>

									<td

										class="categories_view_data"

										style="text-align: left; padding-left: 8px;"

										data-gx-controller="product/product_tooltip"

										data-product_tooltip-image-url="<?php echo DIR_WS_CATALOG_THUMBNAIL_IMAGES . $products['products_image']; ?>"

										data-product_tooltip-description="<?php echo TEXT_DATE_ADDED.' '.xtc_date_short($products['products_date_added']).'<br />' .

                                                                                     TEXT_LAST_MODIFIED.' '.xtc_date_short($products['products_last_modified']).'<br /><br />'.

                                                                                     TEXT_PRODUCT_LINKED_TO . '<br />' . htmlspecialchars_wrapper(xtc_output_generated_category_path($products['products_id'], 'product')); ?>"

									>

										<a data-tooltip-trigger href="<?php echo xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '&action=new_product'; ?>">

                                            <?php echo $products['products_name']; ?>

										</a>

									</td>

									<td class="categories_view_data">

                                        <?php

                                        echo $products['products_model'];

                                        ?>

									</td>

                                    <?php

                                    // check product and attributes stock

                                    if (STOCK_CHECK == 'true') { ?>

										<td class="categories_view_data">

                                            <?php echo check_stock($products['products_id']); ?>

										</td>

                                    <?php } ?>

									<td class="categories_view_data">

                                        <?php

                                        echo '<div data-gx-widget="checkbox"

                                                                                      . 'action=setpflag&flag=0&pID=' . $products['products_id']

                                                                                      . '&cPath=' . $cPath

                                                                                      . '&page_token=' . $t_page_token) . '"></div>';

                                        ?>

									</td>

									<td class="categories_view_data">

                                        <?php

                                        echo '<div data-gx-widget="checkbox"

                                                                                      . 'action=setsflag&flag=0&pID=' . $products['products_id']

                                                                                      . '&cPath=' . $cPath

                                                                                      . '&page_token=' . $t_page_token) . '"></div>';

                                        ?>

									</td>

									<td class="categories_view_data text-right">

                                        <?php

                                        //show price

                                        $price = xtc_round($products['products_price'],PRICE_PRECISION);

                                        $price_string = $currencies->format($price);

                                        if (PRICE_IS_BRUTTO=='true'){

                                            $price_netto = xtc_round($price,PRICE_PRECISION);

                                            // BOF GM_MOD:

                                            $price = ($price*(xtc_get_tax_rate($products['products_tax_class_id'])+100)/100);

                                            $price_string = '&nbsp;' . $currencies->format($price) . '<br />' . TEXT_NETTO . $currencies->format($price_netto);

                                        }

                                        echo $price_string;

                                        ?>

									</td>

									<td class="categories_view_data text-right">

                                        <?php

                                        // Show Max Allowed discount

                                        echo $products['products_discount_allowed'] . '%';

                                        ?>

									</td>

									<td class="categories_view_data">

										<div class="action-list">

											<a class="action-icon"

											   href="<?php echo xtc_href_link('categories.php?pID=' . $products['products_id'] . '&action=new_product'); ?>">

												<i class="fa fa-pencil"></i>

											</a>

											<a class="action-icon" href="#">

												<i class="fa fa-trash-o"></i>

											</a>