public static function getPost($id_post, $id_lang = null)
{
$result = array();
if ($id_lang == null) {
$id_lang = (int) Context::getContext()->language->id;
}
preg_match('/^[\\d]+/', $id_post, $id_post);
$id_post = $id_post[0];
$sql = 'SELECT * FROM ' . _DB_PREFIX_ . 'smart_blog_post p INNER JOIN
' . _DB_PREFIX_ . 'smart_blog_post_lang pl ON p.id_smart_blog_post=pl.id_smart_blog_post INNER JOIN
' . _DB_PREFIX_ . 'smart_blog_post_shop ps ON pl.id_smart_blog_post = ps.id_smart_blog_post
WHERE pl.id_lang=' . $id_lang . '
AND p.active= 1 AND p.id_smart_blog_post = ' . $id_post;
if (!($post = Db::getInstance()->executeS($sql))) {
return false;
}
$result['id_post'] = $post[0]['id_smart_blog_post'];
$result['meta_title'] = $post[0]['meta_title'];
$result['meta_description'] = $post[0]['meta_description'];
$result['short_description'] = $post[0]['short_description'];
$result['meta_keyword'] = $post[0]['meta_keyword'];
if (Module::isEnabled('smartshortcode') == 1 && Module::isInstalled('smartshortcode') == 1) {
require_once _PS_MODULE_DIR_ . 'smartshortcode/smartshortcode.php';
$smartshortcode = new SmartShortCode();
$result['content'] = $smartshortcode->parse($post[0]['content']);
} else {
$result['content'] = $post[0]['content'];
}
$result['active'] = $post[0]['active'];
$result['created'] = $post[0]['created'];
$result['comment_status'] = $post[0]['comment_status'];
$result['viewed'] = $post[0]['viewed'];
$result['is_featured'] = $post[0]['is_featured'];
$result['post_type'] = $post[0]['post_type'];
$result['id_category'] = $post[0]['id_category'];
$employee = new Employee($post[0]['id_author']);
$result['id_author'] = $post[0]['id_author'];
$result['lastname'] = $employee->lastname;
$result['firstname'] = $employee->firstname;
$result['youtube'] = $post[0]['youtube'];
if (file_exists(_PS_MODULE_DIR_ . 'smartblog/images/' . $post[0]['id_smart_blog_post'] . '.jpg')) {
$image = $post[0]['id_smart_blog_post'] . '.jpg';
$result['post_img'] = $image;
} else {
$result['post_img'] = NULL;
}
return $result;
}
public function initContent()
{
$this->context->controller->addJqueryPlugin('cooki-plugin');
$this->context->controller->addJqueryPlugin('cookie-plugin');
$this->context->controller->addjqueryPlugin('fancybox');
$this->context->controller->addCSS(array(_THEME_CSS_DIR_ . 'category.css' => 'all', _THEME_CSS_DIR_ . 'product_list.css' => 'all'));
parent::initContent();
$this->SimpleBlogPost->increaseViewsNb();
/**
Support for SmartShortcode module from CodeCanyon
**/
if (file_exists(_PS_MODULE_DIR_ . 'smartshortcode/smartshortcode.php')) {
require_once _PS_MODULE_DIR_ . 'smartshortcode/smartshortcode.php';
}
if (Module::isEnabled('smartshortcode')) {
$smartshortcode = new SmartShortCode();
$this->SimpleBlogPost->content = $smartshortcode->parse($this->SimpleBlogPost->content);
}
$this->context->smarty->assign('post', $this->SimpleBlogPost);
$this->context->smarty->assign('is_16', version_compare(_PS_VERSION_, '1.6.0', '>=') === true ? true : false);
$this->context->smarty->assign('gallery_dir', _MODULE_DIR_ . 'ph_simpleblog/galleries/');
// Comments
if ($this->SimpleBlogPost->allow_comments == 1) {
$allow_comments = true;
} elseif ($this->SimpleBlogPost->allow_comments == 2) {
$allow_comments = false;
} elseif ($this->SimpleBlogPost->allow_comments == 3) {
$allow_comments = Configuration::get('PH_BLOG_COMMENT_ALLOW');
} else {
$allow_comments = false;
}
$this->context->smarty->assign('allow_comments', $allow_comments);
if ($allow_comments) {
$comments = SimpleBlogComment::getComments($this->SimpleBlogPost->id_simpleblog_post);
$this->context->smarty->assign('comments', $comments);
}
if (Configuration::get('PH_BLOG_DISPLAY_RELATED')) {
$related_products = SimpleBlogPost::getRelatedProducts($this->SimpleBlogPost->id_product);
$this->context->smarty->assign('related_products', $related_products);
}
$this->setTemplate('single.tpl');
}
public static function getPost($id_post, $id_lang = null)
{
$result = array();
if ($id_lang == null) {
$id_lang = (int) Context::getContext()->language->id;
}
$sql = 'SELECT * FROM ' . _DB_PREFIX_ . 'smart_blog_post p INNER JOIN
' . _DB_PREFIX_ . 'smart_blog_post_lang pl ON p.id_smart_blog_post=pl.id_smart_blog_post INNER JOIN
' . _DB_PREFIX_ . 'smart_blog_post_shop ps ON pl.id_smart_blog_post = ps.id_smart_blog_post
WHERE pl.id_lang=' . $id_lang . '
AND p.active= 1 AND p.id_smart_blog_post = ' . $id_post;
if (!($post = Db::getInstance()->executeS($sql))) {
return false;
}
$result['id_post'] = $post[0]['id_smart_blog_post'];
$result['meta_title'] = $post[0]['meta_title'];
$result['meta_description'] = $post[0]['meta_description'];
$result['short_description'] = $post[0]['short_description'];
$result['meta_keyword'] = $post[0]['meta_keyword'];
$result['link_rewrite'] = $post[0]['link_rewrite'];
if (Module::isEnabled('smartshortcode') == 1 && Module::isInstalled('smartshortcode') == 1) {
require_once _PS_MODULE_DIR_ . 'smartshortcode/smartshortcode.php';
$smartshortcode = new SmartShortCode();
$result['content'] = $smartshortcode->parse($post[0]['content']);
} else {
$result['content'] = $post[0]['content'];
}
if (Module::isInstalled('jscomposer') && Module::isEnabled('jscomposer')) {
require_once _PS_MODULE_DIR_ . 'jscomposer/jscomposer.php';
$result['content'] = JsComposer::do_shortcode($result['content']);
}
$result['active'] = $post[0]['active'];
$result['created'] = $post[0]['created'];
$result['comment_status'] = $post[0]['comment_status'];
$result['viewed'] = $post[0]['viewed'];
$result['is_featured'] = $post[0]['is_featured'];
$result['post_type'] = $post[0]['post_type'];
$result['id_category'] = $post[0]['id_category'];
$employee = new Employee($post[0]['id_author']);
$result['lastname'] = $employee->lastname;
$result['firstname'] = $employee->firstname;
if (file_exists(_PS_MODULE_DIR_ . 'smartblog/images/' . $post[0]['id_smart_blog_post'] . '.jpg')) {
$image = $post[0]['id_smart_blog_post'] . '.jpg';
$result['post_img'] = $image;
} else {
$result['post_img'] = NULL;
}
// post format code
$post_format = $post[0]['post_type'];
$result['post_format'] = $post_format;
if (isset(smartblog::$post_meta_fields[$post_format]) && !empty(smartblog::$post_meta_fields[$post_format])) {
$importMetadata = array();
foreach (smartblog::$post_meta_fields[$post_format] as $meta) {
$meta_key = "{$post_format}-{$meta['name']}";
$id_lang = null;
if (isset($meta['lang']) && $meta['lang']) {
$id_lang = Context::getContext()->language->id;
}
$importMetadata[$meta_key] = BlogPostMeta::get((int) $post[0]['id_smart_blog_post'], $meta_key, false, $id_lang);
}
$result['post_format_data'] = $importMetadata;
}
return $result;
}
