name = 'sortcategories';
$this->tab = 'Tools';
$this->version = '0.4';
parent::__construct();
/* The parent construct is required for translations */
$this->page = basename(__FILE__, '.php');
$this->displayName = $this->l('Sort Categories ');
$this->description = $this->l('Allows you to sort the categories manually. ');
$this->confirmUninstall = $this->l('remove this module?');
}
function install()
{
if (!parent::install()){
return false;
}else{
return true;
}
}
public function getContent()
{
global $cookie;
$output = '
'.$this->displayName.'
';
if (Tools::isSubmit('submitNewOrder'))
{
$new_order = $_POST['new_order'];
foreach($new_order as $new_position){
//print_r($id);
$id_cat = $new_position['id_category'];
$position = $new_position['position'];
$nom = addslashes(html_entity_decode($new_position['nom']));
$nouveau_nom = $position.'.'.$nom;
$table = _DB_PREFIX_.'category_lang';
$type = 'UPDATE';
$values['name'] = $nouveau_nom;
$where = ' id_category = '.$id_cat;
$where .= ' AND id_lang = '.$cookie->id_lang;
if(Db::getInstance()->autoExecute($table, $values, $type, $where)){
$result = $this->l('Categories have been sorted successfully !');
}else{
$errors[] .= $this->l('An error occured while inserting the new order for : ').$nouveau_nom;
}
}
if($result){
echo '
'.$result.'
';
}
if($errors){
foreach ($errors AS $error){
echo '
'. $error .'
';
}
}
}
return $output.$this->displayForm();
}
function ischildren($id_parent)
{
global $cookie;
$categories = Category::getChildren($id_parent,intval($cookie->id_lang),true);
$nb_children = count($categories);
if($nb_children>1){
return $nb_children;
}else{
return false;
}
}
function getCategories($params)
{
global $smarty, $cookie, $currentIndex;
$base_link = $currentIndex.'&configure=sortcategories&token='.$_GET['token'];
$modules_dir = _MODULE_DIR_;
$parent = $_GET['id_parent'];
if(!$parent){ $parent = 1; }
if (!$result = Db::getInstance()->ExecuteS('SELECT * FROM `'._DB_PREFIX_.'category` ,`'._DB_PREFIX_.'category_lang`
WHERE `'._DB_PREFIX_.'category`.`id_category` = `'._DB_PREFIX_.'category_lang`.`id_category`
AND `'._DB_PREFIX_.'category`.`active` = 1
AND `'._DB_PREFIX_.'category_lang`.`id_lang` = '.$cookie->id_lang.'
AND `'._DB_PREFIX_.'category`.`id_parent` = '.$parent.'
ORDER BY `'._DB_PREFIX_.'category_lang`.`name`
') )
return;
//print_r($result);
$i=0;
foreach ($result as $row)
{
$nom_tmp = explode('.', $result[$i]['name'], 2);
if($nom_tmp[1] && is_numeric($nom_tmp[0])){
$elements[$i]['position'] = $nom_tmp[0];
$elements[$i]['nom'] = htmlentities(utf8_decode($nom_tmp[1]));
}else{
$elements[$i]['position'] = '000';
$elements[$i]['nom'] = htmlentities(utf8_decode($result[$i]['name']));
}
$elements[$i]['id_category'] = $result[$i]['id_category'];
$elements[$i]['level_depth'] = $result[$i]['level_depth'];
$elements[$i]['id_parent'] = $result[$i]['id_parent'];
if ($this->ischildren($result[$i]['id_category'])){
$elements[$i]['link'] = $base_link.'&id_parent='.$result[$i]['id_category'];
}else{
$elements[$i]['link'] = '';
}
$i++;
}
$smarty->assign('elements', $elements);
$smarty->assign('base_link', $base_link);
$smarty->assign('modules_dir', $modules_dir);
return $this->display(__FILE__, 'sortcategories.tpl');
}
public function displayForm()
{
global $currentIndex;
$base_link = $currentIndex.'&configure=sortcategories&token='.$_GET['token'];
$html_output = '';
$style = '';
$html_output .= '
'.$style.'
';
$html_output .= '
';
return $html_output;
}
}
?>