xyzshop/data/model/mb_special.model.php

<?php
/**
 * 手机专题模型
 *
 *
 *
 *
 */

defined('InShopNC') or exit('Access Invalid!');

class mb_specialModel extends Model
{
    //专题项目不可用状态
    const SPECIAL_ITEM_UNUSABLE = 0;
    //专题项目可用状态
    const SPECIAL_ITEM_USABLE = 1;
    //首页特殊专题编号
    const INDEX_SPECIAL_ID = 0;

    public function __construct()
    {
        parent::__construct('mb_special');
    }

    /**
     * 读取专题列表
     * @param array $condition
     *
     */
    public function getMbSpecialList($condition, $page = '', $order = 'special_id desc', $field = '*')
    {
        $list = $this->table('mb_special')->field($field)->where($condition)->page($page)->order($order)->select();
        return $list;
    }

    /*
     * 增加专题
     * @param array $param
     * @return bool
     *
     */
    public function addMbSpecial($param)
    {
        return $this->table('mb_special')->insert($param);
    }

    /*
     * 更新专题
     * @param array $update
     * @param array $condition
     * @return bool
     *
     */
    public function editMbSpecial($update, $special_id)
    {
        $special_id = intval($special_id);
        if ($special_id <= 0) {
            return false;
        }

        $condition = array();
        $condition['special_id'] = $special_id;
        $result = $this->table('mb_special')->where($condition)->update($update);
        if ($result) {
            //删除缓存
            $this->_delMbSpecialCache($special_id);
            return $special_id;
        } else {
            return false;
        }
    }

    /*
     * 删除专题
     * @param int $special_id
     * @return bool
     *
     */
    public function delMbSpecialByID($special_id)
    {
        $special_id = intval($special_id);
        if ($special_id <= 0) {
            return false;
        }

        $condition = array();
        $condition['special_id'] = $special_id;

        $this->delMbSpecialItem($condition, $special_id);

        return $this->table('mb_special')->where($condition)->delete();
    }

    /**
     * 专题项目列表（用于后台编辑显示所有项目）
     * @param int $special_id
     *
     */
    public function getMbSpecialItemListByID($special_id)
    {
        $condition = array();
        $condition['special_id'] = $special_id;

        return $this->_getMbSpecialItemList($condition);
    }

    /**
     * 专题可用项目列表（用于前台显示仅显示可用项目）
     * @param int $special_id
     *
     */
    public function getMbSpecialItemUsableListByIDEx($special_id)
    {
        $prefix = 'mb_specialex';
        $item_list = rcache($special_id, $prefix);
        //缓存有效
        if (!empty($item_list)) {
            return unserialize($item_list['special']);
        }

        //缓存无效查库并缓存
        $condition = array();
        $condition['special_id'] = $special_id;
        $condition['item_usable'] = self::SPECIAL_ITEM_USABLE;
        $item_list = $this->_getMbSpecialItemList($condition);
        if (!empty($item_list)) {
            $pages = array();
            foreach ($item_list as $value) {
                //处理图片
                $items = array();
                $items['item_id'] = $value['item_id'];
                $items['special_id'] = $value['item_id'];
                $items['item_type'] = $value['item_type'];
                $items['item_sort'] = $value['item_sort'];
                $item_data = $this->_formatMbSpecialData($value['item_data'], $value['item_type']);

                // add goods_price
                if ($value['item_type'] === 'goods') {
                    foreach ($item_data['item'] as &$item) {
                        $model_goods = Model('goods');
                        $goods_detail = $model_goods->getGoodsInfo(array('goods_id' => $item['goods_id']),
                            'goods_price,goods_storage,goods_storage_alarm,goods_jingle,goods_marketprice');
                        if (!empty($goods_detail)) {
                            $item['goods_price'] = $goods_detail['goods_price'];
                            $item['goods_storage'] = $goods_detail['goods_storage'];
                            $item['goods_storage_alarm'] = $goods_detail['goods_storage_alarm'];
                            $item['goods_jingle'] = $goods_detail['goods_jingle'];
                            $item['goods_marketprice'] = $goods_detail['goods_marketprice'];
                        } else {
                            $item['goods_price'] = 0.0;
                            $item['goods_storage'] = '0';
                            $item['goods_storage_alarm'] = '0';
                            $item['goods_jingle'] = '';
                            $item['goods_marketprice'] = '0.00';
                        }
                    }
                }

                $items['item_data'] = $item_data;
                array_push($pages, $items);
            }
            $item_list = $pages;
        }
        $cache = array('special' => serialize($item_list));
        wcache($special_id, $cache, $prefix);
        return $item_list;
    }

    public function getMbSpecialItemUsableListByID($special_id)
    {
        $prefix = 'mb_special';
        $item_list = rcache($special_id, $prefix);
        //缓存有效
        if (!empty($item_list)) {
            return unserialize($item_list['special']);
        }

        //缓存无效查库并缓存
        $condition = array();
        $condition['special_id'] = $special_id;
        $condition['item_usable'] = self::SPECIAL_ITEM_USABLE;
        $item_list = $this->_getMbSpecialItemList($condition);

        $blocks = [];
        foreach ($item_list as $value)
        {
            $block = [];
            $block['item_type'] = $value['item_type'];
            $block['bg_image']  = $value['bg_image'];
            $block['bg_type']   = $value['bg_type'];
            $block['bg_data']   = $value['bg_data'];
            $has_margin = intval($value['has_margin']);
            $block['has_margin']= $has_margin === 0 ? false : true;

            $item_type = $value['item_type'];

            if($item_type == 'divider') {
                $blocks[] = $block;
                continue;
            }

            $item_data = $value['item_data'];
            if($item_type == 'home1') {
                $block['title']   = empty($item_data['home1_title']) ? '' : $item_data['home1_title'];
            }
            else {
                $block['title']   = empty($item_data['title']) ? '' : $item_data['title'];
            }

            $items = $this->_formatMbSpecialData($item_data, $value['item_type']);
            if($item_type == 'home1' || $item_type == 'home2' || $item_type == 'home4') {
                $block['items'] = $items;
            }
            else {
                $block['items'] = $items['item'];
            }

            if(empty($block['items'])) {
                continue;
            }

            $blocks[] = $block;
        }

        $cache = array('blocks' => $blocks);
        wcache($special_id, array('special' => serialize($cache)), $prefix);
        return $cache;
    }

    /**
     * 首页专题
     */
//    public function getMbSpecialIndex()
//    {
//        return $this->getMbSpecialItemUsableListByID(self::INDEX_SPECIAL_ID);
//    }
    /**
     * 处理专题数据，拼接图片URL
     */
    private function _formatMbSpecialData($item_data, $item_type)
    {
        switch ($item_type) {
            case 'home1':
                $item_data['image'] = getMbSpecialImageUrl($item_data['image']);
                if($item_data['show_type'] == 'image') {
                    $item_data['show_data'] = getMbSpecialImageUrl($item_data['show_data']);
                }
                break;
            case 'home2':
            case 'home4':
                $item_data['square_image'] = getMbSpecialImageUrl($item_data['square_image']);
                if($item_data['square_show_type'] == 'image') {
                    $item_data['square_show_data'] = getMbSpecialImageUrl($item_data['square_show_data']);
                }
                $item_data['rectangle1_image'] = getMbSpecialImageUrl($item_data['rectangle1_image']);
                if($item_data['rectangle1_show_type'] == 'image') {
                    $item_data['rectangle1_show_data'] = getMbSpecialImageUrl($item_data['rectangle1_show_data']);
                }
                $item_data['rectangle2_image'] = getMbSpecialImageUrl($item_data['rectangle2_image']);
                if($item_data['rectangle2_show_type'] == 'image') {
                    $item_data['rectangle2_show_data'] = getMbSpecialImageUrl($item_data['rectangle2_show_data']);
                }
                break;
            default:
                $new_item = array();
                foreach ((array)$item_data['item'] as $key => $value) {
                    $value['image'] = getMbSpecialImageUrl($value['image']);
                    if($value['show_type'] == 'image') {
                        $value['show_data'] = getMbSpecialImageUrl($value['show_data']);
                    }
                    $new_item[] = $value;
                }
                $item_data['item'] = $new_item;
        }
        return $item_data;
    }

    /**
     * 查询专题项目列表
     */
    private function _getMbSpecialItemList($condition, $order = 'item_sort asc')
    {
        $item_list = $this->table('mb_special_item')->where($condition)->order($order)->select();
        foreach ($item_list as $key => $value) {
            $item_list[$key]['item_data'] = $this->_initMbSpecialItemData($value['item_data'], $value['item_type']);
            if ($value['item_usable'] == self::SPECIAL_ITEM_USABLE) {
                $item_list[$key]['usable_class'] = 'usable';
                $item_list[$key]['usable_text'] = '禁用';
            } else {
                $item_list[$key]['usable_class'] = 'unusable';
                $item_list[$key]['usable_text'] = '启用';
            }
        }
        return $item_list;
    }

    /**
     * 检查专题项目是否存在
     * @param array $condition
     *
     */
    public function isMbSpecialItemExist($condition)
    {
        $item_list = $this->table('mb_special_item')->where($condition)->select();
        if ($item_list) {
            return true;
        } else {
            return false;
        }
    }

    /**
     * 获取项目详细信息
     * @param int $item_id
     *
     */
    public function getMbSpecialItemInfoByID($item_id)
    {
        $item_id = intval($item_id);
        if ($item_id <= 0) {
            return false;
        }

        $condition = array();
        $condition['item_id'] = $item_id;
        $item_info = $this->table('mb_special_item')->where($condition)->find();
        $item_info['item_data'] = $this->_initMbSpecialItemData($item_info['item_data'], $item_info['item_type']);

        return $item_info;
    }

    /**
     * 整理项目内容
     *
     */
    private function _initMbSpecialItemData($item_data, $item_type)
    {
        if (!empty($item_data)) {
            $item_data = unserialize($item_data);
        } else {
            $item_data = $this->_initMbSpecialItemNullData($item_type);
        }
        return $item_data;

    }

    /**
     * 初始化空项目内容
     */
    private function _initMbSpecialItemNullData($item_type)
    {
        $item_data = array();
        switch ($item_type) {
            case 'home1':
                $item_data = array(
                    'title' => '',
                    'image' => '',
                    'type' => '',
                    'data' => '',
                );
                break;
            case 'home2':
            case 'home4':
                $item_data = array(
                    'title' => '',
                    'square_image' => '',
                    'square_type' => '',
                    'square_data' => '',
                    'rectangle1_image' => '',
                    'rectangle1_type' => '',
                    'rectangle1_data' => '',
                    'rectangle2_image' => '',
                    'rectangle2_type' => '',
                    'rectangle2_data' => '',
                );
                break;
            default:
        }
        return $item_data;
    }

    /*
     * 增加专题项目
     * @param array $param
     * @return array $item_info
     *
     */
    public function addMbSpecialItem($param)
    {
        $param['item_usable'] = self::SPECIAL_ITEM_UNUSABLE;
        $param['item_sort'] = 255;
        $result = $this->table('mb_special_item')->insert($param);
        //删除缓存
        if ($result) {
            //删除缓存
            $this->_delMbSpecialCache($param['special_id']);
            $param['item_id'] = $result;
            return $param;
        } else {
            return false;
        }
    }

    /**
     * 编辑专题项目
     * @param array $update
     * @param int $item_id
     * @param int $special_id
     * @return bool
     *
     */
    public function editMbSpecialItemByID($update, $item_id, $special_id)
    {
        if (isset($update['item_data'])) {
            $update['item_data'] = serialize($update['item_data']);
        }

        $condition = array();
        $condition['item_id'] = $item_id;

        //删除缓存
        $this->_delMbSpecialCache($special_id);

        return $this->table('mb_special_item')->where($condition)->update($update);
    }

    /**
     * 编辑专题项目启用状态
     * @param string usable-启用/unsable-不启用
     * @param int $item_id
     * @param int $special_id
     *
     */
    public function editMbSpecialItemUsableByID($usable, $item_id, $special_id)
    {
        $update = array();
        if ($usable == 'usable') {
            $update['item_usable'] = self::SPECIAL_ITEM_USABLE;
        } else {
            $update['item_usable'] = self::SPECIAL_ITEM_UNUSABLE;
        }
        return $this->editMbSpecialItemByID($update, $item_id, $special_id);
    }

    /*
     * 删除
     * @param array $condition
     * @return bool
     *
     */
    public function delMbSpecialItem($condition, $special_id)
    {
        //删除缓存
        $this->_delMbSpecialCache($special_id);

        return $this->table('mb_special_item')->where($condition)->delete();
    }

    /**
     * 获取专题URL地址
     * @param int $special_id
     *
     */
    public function getMbSpecialHtmlUrl($special_id)
    {
        return UPLOAD_SITE_URL . DS . ATTACH_MOBILE . DS . 'special_html' . DS . md5('special' . $special_id) . '.html';
    }

    /**
     * 获取专题静态文件路径
     * @param int $special_id
     *
     */
    public function getMbSpecialHtmlPath($special_id)
    {
        return BASE_UPLOAD_PATH . DS . ATTACH_MOBILE . DS . 'special_html' . DS . md5('special' . $special_id) . '.html';
    }

    /**
     * 获取专题模块类型列表
     * @return array
     *
     */
    public function getMbSpecialModuleList()
    {
        $module_list = array();
        $module_list['adv_list'] = array('name' => 'adv_list', 'desc' => '广告条版块');
        $module_list['home1'] = array('name' => 'home1', 'desc' => '模型版块布局A');
        $module_list['home2'] = array('name' => 'home2', 'desc' => '模型版块布局B');
        $module_list['home3'] = array('name' => 'home3', 'desc' => '模型版块布局C');
        $module_list['home4'] = array('name' => 'home4', 'desc' => '模型版块布局D');
        $module_list['home5'] = array('name' => 'home5', 'desc' => '模型版块布局E');
        $module_list['goods'] = array('name' => 'goods', 'desc' => '商品版块');
        $module_list['home6'] = array('name' => 'home6', 'desc' => '模型版块布局G');
        $module_list['home7'] = array('name' => 'home7', 'desc' => '模型版块布局F');
        $module_list['divider']  = array('name' => 'divider', 'desc' => '分割线');
        return $module_list;
    }

    /**
     * 清理缓存
     */
    private function _delMbSpecialCache($special_id)
    {
        //清理缓存
        dcache($special_id, 'mb_special');

        //删除静态文件
        $html_path = $this->getMbSpecialHtmlPath($special_id);
        if (is_file($html_path)) {
            @unlink($html_path);
        }
    }
}