catalog/model/extension/d_blog_module/post.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php

class ModelExtensionDBlogModulePost extends Model
{

    public function updateViewed($post_id)
    {
        $this->db->query("UPDATE " . DB_PREFIX . "bm_post SET viewed = (viewed + 1) WHERE post_id = '" . (int)$post_id . "'");
    }

    public function getPosts($data = array())
    {
        $sql = "SELECT p.post_id ";

        if (!empty($data['filter_category_id'])) {
            $sql .= " FROM " . DB_PREFIX . "bm_post_to_category p2c";
            $sql .= " LEFT JOIN " . DB_PREFIX . "bm_post p ON (p2c.post_id = p.post_id)";
        } else {
            $sql .= " FROM " . DB_PREFIX . "bm_post p ";
        }

        $sql .= " LEFT JOIN " . DB_PREFIX . "bm_post_description pd ON (p.post_id = pd.post_id) "
            . "LEFT JOIN " . DB_PREFIX . "bm_post_to_store p2s ON (p.post_id = p2s.post_id) "
            . "Left JOIN " . DB_PREFIX . "bm_review r ON (p.post_id = r.post_id) "
            . "WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' "
            . "AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' "
            . "AND p.date_published < NOW()"
            . "AND p.status = '1' ";
        if (!empty($data['filter_name']) && !empty($data['filter_description'])) {
            $sql .= " AND ( pd.title LIKE '%" . $data['filter_name'] . "%' OR pd.description LIKE '%" . $data['filter_description'] . "%' )";
        } else {

            if (!empty($data['filter_name'])) {
                $sql .= " AND pd.title LIKE '%" . $data['filter_name'] . "%'";
            }

            if (!empty($data['filter_description'])) {
                $sql .= " AND pd.description LIKE '%" . $data['filter_description'] . "%'";
            }
        }

        if (!empty($data['filter_tag'])) {
            $sql .= " AND pd.tag LIKE '%" . $data['filter_tag'] . "%'";
        }

        if (!empty($data['filter_date_published'])) {
            $date = preg_split("/-/", $data['filter_date_published']);

            $sql .= "AND YEAR(p.date_published) = " . $date[1] . " AND MONTH(p.date_published) = " . $date[0];
        }
        if (!empty($data['filter_author_id'])) {
            $sql .= " AND p.user_id = '" . (int)$data['filter_author_id'] . "'";
        }

        if (!empty($data['filter_category_id'])) {
            $sql .= " AND p2c.category_id = '" . (int)$data['filter_category_id'] . "'";
        }

        $sql .= " GROUP BY p.post_id";