public function render_categories_grid()
{
$this->load->helper('aggrid_tree_helper');
$Grid = new Aggrid_tree_Helper('catalogue_categories_grid');
$Grid->db->select("A.`" . self::ID_CAT . "` AS ID, A.`id_parent`, A.`level`, A.`sort` AS sort, A.`active`, A.`show`, A.`create_date`, A.`update_date`, B.`name`, \n\t\t\t\t\t\t\t(SELECT COUNT(*) FROM `" . self::CAT . "` WHERE `id_parent` = A.`" . self::ID_CAT . "`) AS PARENT_COUNT")->from("`" . self::CAT . "` AS A")->join("`" . self::CAT_DESC . "` AS B", "B.`" . self::ID_CAT . "` = A.`" . self::ID_CAT . "` && B.`" . self::ID_LANGS . "` = " . $this->id_langs, "left")->where("A.`" . self::ID_USERS . "`", $this->id_users)->order_by('sort');
$this->load->helper('categories');
$Grid = categories_grid_build($Grid);
$Grid->createDataArray();
$Grid->updateGridValues('active', array('0' => 'Нет', '1' => 'Да'))->updateGridValues('show', array('0' => 'Нет', '1' => 'Да'))->setGridValues("sort", "<a class='arrow_down' href='\$1' title='Смена позиции: Опустить'></a><a class='arrow_up' href='\$1' title='Смена позиции: Поднять'></a>", array('$1' => 'ID'));
$Grid->renderGrid();
}
public function select_category()
{
$this->load->helper('aggrid_tree_helper');
$Grid = new Aggrid_tree_Helper('products_types_set_categories_grid');
$Grid->db->select("A.`" . self::ID_CAT . "` AS ID, A.`id_parent`, A.`level`, A.`sort` AS sort, A.`active`, A.`create_date`, A.`update_date`, B.`name`,\n\t\t\t\t\t\t\t(SELECT COUNT(*) FROM `" . self::CAT . "` WHERE `id_parent` = A.`" . self::ID_CAT . "`) AS PARENT_COUNT")->from("`" . self::CAT . "` AS A")->join("`" . self::CAT_DESC . "` AS B", "B.`" . self::ID_CAT . "` = A.`" . self::ID_CAT . "` && B.`" . self::ID_LANGS . "` = " . $this->id_langs, "LEFT")->where("A.`" . self::ID_USERS . "`", $this->id_users)->order_by('sort');
$this->load->helper('products_types_set');
$Grid = categories_grid_build($Grid);
$Grid->createDataArray();
$Grid->updateGridValues('active', array('0' => 'Нет', '1' => 'Да'));
$Grid->renderGrid();
}
