public static function loadPageDefault()
{
$langId = Context::getContext()->language->id;
$shopId = Context::getContext()->shop->id;
$groupID = intval($_POST['groupID']);
$type = $_POST['type'];
$itemId = intval($_POST['itemId']);
$page = intval($_POST['page']);
$itemWidth = intval($_POST['itemWidth']);
$itemHeight = round($_POST['itemHeight'], 3);
$css = 'width: ' . $itemWidth . 'px; height:' . $itemHeight . "px;";
$group = DB::getInstance()->getRow("Select * From " . _DB_PREFIX_ . "groupcategory_groups Where id = " . $groupID);
$response = '';
$products = array();
if ($group) {
$module = new GroupCategory();
$itemConfig = json_decode($group['itemConfig']);
if (!$itemConfig->countItem || (int) $itemConfig->countItem <= 0) {
$pageSize = 3;
} else {
$pageSize = $itemConfig->countItem;
}
$offset = $page * $pageSize;
if ($itemId == 0) {
$arrSubCategory = GroupCategoryLibraries::getCategoryIds($group['categoryId']);
$arrSubCategory[] = $group['categoryId'];
if ($type == 'saller') {
$products = GroupCategoryLibraries::getProducts_Sales($langId, $arrSubCategory, null, false, $pageSize, $offset);
} elseif ($type == 'view') {
$products = GroupCategoryLibraries::getProducts_View($langId, $arrSubCategory, null, false, $pageSize, $offset);
} elseif ($type == 'special') {
$products = GroupCategoryLibraries::getProducts_Special($langId, $arrSubCategory, null, false, $pageSize, $offset);
} elseif ($type == 'arrival') {
$products = GroupCategoryLibraries::getProducts_AddDate($langId, $arrSubCategory, null, false, $pageSize, $offset);
} else {
if ($group['type_default'] == 'saller') {
$products = GroupCategoryLibraries::getProducts_Sales($langId, $arrSubCategory, null, false, $pageSize, $offset);
} elseif ($group['type_default'] == 'view') {
$products = GroupCategoryLibraries::getProducts_View($langId, $arrSubCategory, null, false, $pageSize, $offset);
} elseif ($group['type_default'] == 'special') {
$products = GroupCategoryLibraries::getProducts_Special($langId, $arrSubCategory, null, false, $pageSize, $offset);
} else {
$products = GroupCategoryLibraries::getProducts_AddDate($langId, $arrSubCategory, null, false, $pageSize, $offset);
}
}
} else {
$item = DB::getInstance()->getRow("Select * From " . _DB_PREFIX_ . "groupcategory_items Where id = " . $itemId);
if ($item) {
$arrSubCategory = GroupCategoryLibraries::getCategoryIds($item['categoryId']);
$arrSubCategory[] = $item['categoryId'];
$products = GroupCategoryLibraries::getProducts_AddDate($langId, $arrSubCategory, null, false, $pageSize, $offset);
}
}
if ($products) {
$response = $module->generationHtml_default($products, $css);
}
}
die(Tools::jsonEncode($response));
}
public static function loadGroupByLang()
{
$shopId = Context::getContext()->shop->id;
$langId = intval($_POST['langId']);
$itemId = intval($_POST['itemId']);
$item = GroupCategoryLibraries::getGroupLangById($itemId, $langId, $shopId);
// DB::getInstance()->getRow("Select * From "._DB_PREFIX_."flexiblecustom_modules_lang Where module_id = ".$itemId." AND id_lang = ".$langId." AND id_shop = ".$shopId);
$response = new stdClass();
if ($item) {
$response->name = $item['name'];
$response->banner = $item['banner'];
$response->banner_link = $item['banner_link'];
} else {
$response->name = '';
$response->banner = '';
$response->banner_link = '';
}
die(Tools::jsonEncode($response));
}
public static function loadItemsByGroup()
{
$module = new GroupCategory();
$response = new stdClass();
$groupId = intval($_POST['groupId']);
$group = DB::getInstance()->getRow("Select * From " . _DB_PREFIX_ . "groupcategory_groups Where id = " . $groupId);
if ($group) {
$langId = Context::getContext()->language->id;
$shopId = Context::getContext()->shop->id;
$items = DB::getInstance()->executeS("Select * From " . _DB_PREFIX_ . "groupcategory_items Where groupId = {$groupId} Order By ordering");
$response->categoryOptions = $module->getCategoryOptions(0, $group['categoryId']);
$response->status = 1;
$response->msg = '';
$response->content = '';
if ($items) {
foreach ($items as $item) {
if ($item['status'] == "1") {
$status = '<a title="Enabled" class="list-action-enable action-enabled lik-item-status" item-id="' . $item['id'] . '" value="' . $item['status'] . '"><i class="icon-check"></i></a>';
} else {
$status = '<a title="Disabled" class="list-action-enable action-disabled lik-item-status" item-id="' . $item['id'] . '" value="' . $item['status'] . '"><i class="icon-check"></i></a>';
}
$itemLang = GroupCategoryLibraries::getItemLangById($item['id'], $langId, $shopId);
$response->content .= '<tr id="it_' . $item['id'] . '">
<td>' . $item['id'] . '</td>
<td>' . $itemLang['name'] . '</td>
<td class="center">' . GroupCategoryLibraries::getCategoryLangNameById($item['categoryId'], $langId, $shopId) . '</td>
<td class="pointer dragHandle center" ><div class="dragGroup"><div class="positions">' . $item['ordering'] . '</div></div></td>
<td class="center">' . $status . '</td>
<td class="center">
<a href="javascript:void(0)" item-id="' . $item['id'] . '" class="lik-item-edit"><i class="icon-edit"></i></a>
<a href="javascript:void(0)" item-id="' . $item['id'] . '" class="lik-item-delete"><i class="icon-trash" ></i></a>
</td>
</tr>';
}
} else {
$response->msg = "Items empty.";
}
} else {
$response->status = 0;
$response->msg = "Group do not exist";
$response->content = '';
}
die(Tools::jsonEncode($response));
}
public function getCategoryOptions($selected = 0, $parentId = 0)
{
$langId = Context::getContext()->language->id;
$shopId = Context::getContext()->shop->id;
$categoryOptions = '';
if ($parentId <= 0) {
$parentId = Configuration::get('PS_HOME_CATEGORY');
}
$items = GroupCategoryLibraries::getAllCategories($langId, $shopId, $parentId, '- ', null);
if ($items) {
foreach ($items as $item) {
if ($item['id_category'] == $selected) {
$categoryOptions .= '<option selected="selected" value="' . $item['id_category'] . '">' . $item['sp'] . $item['name'] . '</option>';
} else {
$categoryOptions .= '<option value="' . $item['id_category'] . '">' . $item['sp'] . $item['name'] . '</option>';
}
}
}
return $categoryOptions;
}
static function getCategoryIds($parentId = 0, $arr = null)
{
if ($arr == null) {
$arr = array();
}
$items = DB::getInstance()->executeS("Select id_category From " . _DB_PREFIX_ . "category Where id_parent = {$parentId}");
if ($items) {
foreach ($items as $item) {
$arr[] = $item['id_category'];
$arr = GroupCategoryLibraries::getCategoryIds($item['id_category'], $arr);
}
}
return $arr;
}
