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 getAllGroup()
{
$langId = Context::getContext()->language->id;
$shopId = Context::getContext()->shop->id;
$items = DB::getInstance()->executeS("Select DISTINCT g.*, s.name as styleName From " . _DB_PREFIX_ . "groupcategory_groups as g Left Join " . _DB_PREFIX_ . "groupcategory_styles as s On s.id = g.style_id Where g.id_shop = " . $shopId . " Order By g.position, g.ordering");
$listGroup = '';
if ($items) {
foreach ($items as $item) {
$itemLang = GroupCategoryLibraries::getGroupLangById($item['id'], $langId, $shopId);
if ($item['status'] == "1") {
$status = '<a title="Enabled" class="list-action-enable action-enabled lik-group-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-group-status" item-id="' . $item['id'] . '" value="' . $item['status'] . '"><i class="icon-check"></i></a>';
}
$listGroup .= '<tr id="gr_' . $item['id'] . '"><td class="center">' . $item['id'] . '</td><td><a class="cat-group" href="javascript:void(0)" item-id="' . $item['id'] . '">' . $itemLang['name'] . '</a></td><td class="center">' . GroupCategoryLibraries::getCategoryLangNameById($item['categoryId'], $langId, $shopId) . '</td><td class="center">' . Hook::getNameById($item['position']) . '</td><td class="center">' . $item['styleName'] . '</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-group-edit"><i class="icon-edit"></i></a> <a href="javascript:void(0)" item-id="' . $item['id'] . '" class="lik-group-delete"><i class="icon-trash" ></i></a></td></tr>';
}
}
return $listGroup;
}
