catalog/model/extension/d_blog_module/category.php

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

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

<?php

class ModelExtensionDBlogModuleCategory extends Model {

    public function getCategory($category_id) {
        $query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "bm_category c "
            . "LEFT JOIN " . DB_PREFIX . "bm_category_description cd "
            . "ON (c.category_id = cd.category_id) "
            . "LEFT JOIN " . DB_PREFIX . "bm_category_to_store c2s "
            . "ON (c.category_id = c2s.category_id) WHERE c.category_id = '" . $category_id
            . "' AND cd.language_id = '" . (int) $this->config->get('config_language_id')
            . "' AND c2s.store_id = '" . (int) $this->config->get('config_store_id')
            . "' AND c.status = '1'");

        $result = $query->row;
        if(!empty($result['setting'])){
            $result['setting'] = json_decode($result['setting'], true);
        }

        return $result;
    }

    public function getCategories($parent_id = 0) {
        $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "bm_category c "
            . "LEFT JOIN " . DB_PREFIX . "bm_category_description cd "
            . "ON (c.category_id = cd.category_id) "
            . "LEFT JOIN " . DB_PREFIX . "bm_category_to_store c2s "
            . "ON (c.category_id = c2s.category_id) "
            . "WHERE c.parent_id = '" . (int) $parent_id . "' "
            . "AND cd.language_id = '" . (int) $this->config->get('config_language_id')
            . "' AND c2s.store_id = '" . (int) $this->config->get('config_store_id')
            . "'  AND c.status = '1' GROUP BY c.category_id ORDER BY c.sort_order, LCASE(cd.title)");

        $results = $query->rows;
        foreach($results as $key => $result){
            if(!empty($result['setting'])){
                $results[$key]['setting'] = json_decode($result['setting'], true);
            }
        }
       
        return $results;
    }
    
    public function getAllCategories() {
        $query = $this->db->query("SELECT c.category_id, c.parent_id, "
            . "c.image, c.status, cd.title, cd.short_description, cd.description, cd.meta_title, "
            . "cd.meta_keyword, cd.meta_description "
            . "FROM " . DB_PREFIX . "bm_category c "
            . "LEFT JOIN " . DB_PREFIX . "bm_category_description cd "
            . "ON (c.category_id = cd.category_id) "
            . "LEFT JOIN " . DB_PREFIX . "bm_category_to_store c2s "
            . "ON (c.category_id = c2s.category_id) "
            . "AND cd.language_id = '" . (int) $this->config->get('config_language_id') . "' "
            . "AND c2s.store_id = '" . (int) $this->config->get('config_store_id') . "' "
            . "AND c.status = '1' GROUP BY c.category_id ORDER BY c.sort_order, LCASE(cd.title)");

        return $query->rows;
    }

    public function getCategoryFilters($category_id) {