public function ajaxProcessDeletePostImage() { $response = true; $SimpleBlogPostImage = new SimpleBlogPostImage((int) Tools::getValue('id_simpleblog_post_image')); $response &= $SimpleBlogPostImage->delete(); if ($response) { die(Tools::jsonEncode(array('status' => 'ok', 'id' => $SimpleBlogPostImage->id_simpleblog_post_image, 'confirmations' => array($this->_conf[7])))); } else { $this->jsonError(Tools::displayError('An error occurred while attempting to delete the product image.')); } }
public static function getPosts($id_lang, $limit = 10, $id_simpleblog_category = null, $page = null, $active = true, $orderby = false, $orderway = false, $exclude = null, $featured = false, $author = false, $id_shop = null, $filter = false, $selected = array(), $check_access = true) { $context = Context::getContext(); $start = $limit * ($page == 0 ? 0 : $page - 1); $sql = new DbQuery(); $sql->select('*'); $sql->from('simpleblog_post', 'sbp'); if ($id_lang) { $sql->innerJoin('simpleblog_post_lang', 'l', 'sbp.id_simpleblog_post = l.id_simpleblog_post AND l.id_lang = ' . (int) $id_lang); } if (!$id_shop) { $id_shop = $context->shop->id; } $sql->innerJoin('simpleblog_post_shop', 'sbps', 'sbp.id_simpleblog_post = sbps.id_simpleblog_post AND sbps.id_shop = ' . (int) $id_shop); if ($active) { $sql->where('sbp.active = 1'); } if (isset($id_simpleblog_category) && (int) $id_simpleblog_category > 0) { $childrens = SimpleBlogCategory::getChildrens((int) $id_simpleblog_category); if ($childrens && sizeof($childrens)) { $child_categories = array((int) $id_simpleblog_category); foreach ($childrens as $child) { $child_categories[] = $child['id_simpleblog_category']; } $sql->where('sbp.id_simpleblog_category IN (' . join(',', $child_categories) . ')'); } else { $sql->where('sbp.id_simpleblog_category = ' . (int) $id_simpleblog_category); } } if ($exclude) { $sql->where('sbp.id_simpleblog_post != ' . (int) $exclude); } if ($featured) { $sql->where('sbp.is_featured = 1'); } if ($author && Configuration::get('PH_BLOG_POST_BY_AUTHOR')) { $sql->where('sbp.author = \'' . pSQL($author) . '\''); } if ($filter) { $sql->where('sbp.id_simpleblog_post ' . $filter . ' (' . join(',', $selected) . ')'); } $sql->where('sbp.date_add <= \'' . SimpleBlogHelper::now(Configuration::get('PH_BLOG_TIMEZONE')) . '\''); if (!$orderby) { $orderby = 'sbp.date_add'; } if (!$orderway) { $orderway = 'DESC'; } $sql->orderBy($orderby . ' ' . $orderway); $sql->limit($limit, $start); $result = Db::getInstance()->executeS($sql); if (sizeof($result) && $check_access == true) { $result = self::checkAccess($result); } if (sizeof($result)) { foreach ($result as &$row) { $category_rewrite = SimpleBlogCategory::getRewriteByCategory($row['id_simpleblog_category'], $id_lang); $category_obj = new SimpleBlogCategory($row['id_simpleblog_category'], $id_lang); $category_url = SimpleBlogCategory::getLink($category_obj->link_rewrite, $id_lang); if (file_exists(_PS_MODULE_DIR_ . 'ph_simpleblog/covers/' . $row['id_simpleblog_post'] . '.' . $row['cover'])) { $row['banner'] = _MODULE_DIR_ . 'ph_simpleblog/covers/' . $row['id_simpleblog_post'] . '.' . $row['cover']; $row['banner_thumb'] = _MODULE_DIR_ . 'ph_simpleblog/covers/' . $row['id_simpleblog_post'] . '-thumb.' . $row['cover']; $row['banner_wide'] = _MODULE_DIR_ . 'ph_simpleblog/covers/' . $row['id_simpleblog_post'] . '-wide.' . $row['cover']; } if (file_exists(_PS_MODULE_DIR_ . 'ph_simpleblog/featured/' . $row['id_simpleblog_post'] . '.' . $row['featured'])) { $row['featured'] = _MODULE_DIR_ . 'ph_simpleblog/featured/' . $row['id_simpleblog_post'] . '.' . $row['featured']; } $row['url'] = self::getLink($row['link_rewrite'], $category_obj->link_rewrite, $id_lang); $row['category'] = $category_obj->name; $row['category_rewrite'] = $category_obj->link_rewrite; $row['category_url'] = $category_url; $tags = SimpleBlogTag::getPostTags($row['id_simpleblog_post']); $row['tags'] = isset($tags[$id_lang]) && sizeof($tags[$id_lang] > 0) ? $tags[$id_lang] : false; $row['post_type'] = SimpleBlogPostType::getSlugById($row['id_simpleblog_post_type']); if ($row['post_type'] == 'gallery') { $row['gallery'] = SimpleBlogPostImage::getAllById($row['id_simpleblog_post']); } } } else { return; } return $result; }