public function delete()
{
if ($this->id == 1) {
return false;
}
$this->clearCache();
// Get children categories
$to_delete = array((int) $this->id);
$this->recursiveDelete($to_delete, (int) $this->id);
$to_delete = array_unique($to_delete);
// Delete CMS Category and its child from database
$list = count($to_delete) > 1 ? implode(',', $to_delete) : (int) $this->id;
//delete blog
//get all blog from category ID
//$where = '`id_leoblogcat` IN (' . $list . ')';
$result_blog = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('SELECT `id_leoblog_blog` as id FROM `' . _DB_PREFIX_ . 'leoblog_blog` WHERE `id_leoblogcat` IN (' . $list . ')');
foreach ($result_blog as $value) {
$blog = new LeoBlogBlog($value['id']);
$blog->delete();
}
Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'leoblogcat` WHERE `id_leoblogcat` IN (' . $list . ')');
Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'leoblogcat_shop` WHERE `id_leoblogcat` IN (' . $list . ')');
Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'leoblogcat_lang` WHERE `id_leoblogcat` IN (' . $list . ')');
leoblogcat::cleanPositions($this->id_parent);
return true;
}
