www.x-motion.cn/Application/Admin/Model/MessageBoardModel.class.php

<?php
namespace Admin\Model;

use Common\Model\MessageBoardModel as MessageBoard;

/**
 * 留言板
 * @author: linch
 * Class MessageBoardModel
 * @package Admin\Model
 */
class MessageBoardModel extends MessageBoard
{
    /**
     * 状态列表
     * @author: linch
     * @return array
     */
    public function get_status_list() {
        return array(
            self::status_wait      => '待处理',
            self::status_processed => '已联系',
        );
    }


    /**
     * 获取来源
     * @author: linch
     * @return array
     */
    public function get_source_list() {
        return array(
            self::source_official_web => '官网',
            self::source_official_wap => 'wap端',
        );
    }


    /**
     * 申请列表
     * @author: linch
     * @param array $search 筛选条件
     * @param int $page_num 页码
     * @param int $page_size 页行数
     * @return array
     */
    public function get_list($search, $page_num, $page_size) {
        $where = array(
            'flag' => self::flag_on,
        );
        $s_time = strtotime($search['s_time']);
        $e_time = strtotime($search['e_time']);
        if (!empty($s_time)) {
            $where['c_time'][] = array('egt', date('Y-m-d H:i:s', $s_time));
        }
        if (!empty($e_time)) {
            $where['c_time'][] = array('elt', date('Y-m-d H:i:s', $e_time));
        }
        $order = 'id desc';
        $limit = ($page_num - 1) * $page_size . ' ,' . $page_size;
        $field = '*';
        $list = $this->where($where)->order($order)->field($field)->limit($limit)->select();
        $count = $this->where($where)->count();
        $page = $this->x_show($count, $page_size, array());
        $ad_message_id_arr = array();
        foreach ($list as $k => $v) {
            $ad_message_id_arr[] = $v['ad_message_id'];
        }
        //广告数据
        $ad_message_id_arr = array_unique($ad_message_id_arr);
        $ad_message_data = array();
        if (!empty($ad_message_id_arr)) {
            $ad_message_model = new \Common\Model\AdMessageModel();
            $ad_message_temp = $ad_message_model->field('id,name')->where(array('id' => array('in', $ad_message_id_arr)))->select();
            foreach ($ad_message_temp as $k => $v) {
                $ad_message_data[$v['id']] = $v;
            }
        }
        //整合数据
        foreach ($list as $k => $v) {
            if (empty($ad_message_data[$v['ad_message_id']])) {
                $list[$k]['ad_source'] = '';
            } else {
                $list[$k]['ad_source'] = $ad_message_data[$v['ad_message_id']]['name'];
            }
        }
        $data = array(
            'list'  => $list,
            'pager' => $page,
        );
        return $data;
    }


    /**
     * 设置已联系状态
     * @author: linch
     * @param $id
     * @return bool
     */
    public function data_set_finish($id) {
        $result = $this->where(array('id' => $id))->setField(array('status' => self::status_processed));
        return $result;
    }


    /**
     * 设置删除
     * @author: linch
     * @param $id
     * @return bool
     */
    public function data_del($id) {
        $result = $this->where(array('id' => $id))->setField(array('flag' => self::flag_off));
        return $result;
    }
}