hlm_pl_mall/app/home/controller/SellerInstantMessage.php

<?php

namespace app\home\controller;

use think\facade\View;
use think\facade\Lang;
use think\facade\Db;
/**
 * ============================================================================
 * DSO2O多用户商城
 * ============================================================================
 * 版权所有 2014-2028 浙江惠利玛产业互联网有限公司，并保留所有权利。
 * 网站地址: https://www.valimart.net/
 * ----------------------------------------------------------------------------
 * 
 * ============================================================================
 * 控制器
 */
class SellerInstantMessage extends BaseSeller {

    public function initialize() {
        parent::initialize();
        Lang::load(base_path() . 'home/lang/' . config('lang.default_lang') . '/seller_instant_message.lang.php');
    }

    public function index() {
        $instant_message_model = model('instant_message');
        $f_name = trim(input('param.f_name'));
        $t_name = trim(input('param.t_name'));
        $time_add_from = input('param.add_time_from')?strtotime(input('param.add_time_from')):'';
        $time_add_to = input('param.add_time_to')?strtotime(input('param.add_time_to')):'';
        /**
         * 查询条件
         */
        $condition = array();
        if($f_name){
            $condition[]=array('instant_message_from_name','like','%'.$f_name.'%');
        }
        if($t_name){
            $condition[]=array('instant_message_to_name','like','%'.$t_name.'%');
        }
        if($time_add_from){
            $condition[]=array('instant_message_add_time','>=',$time_add_from);
        }
        if($time_add_to){
            $condition[]=array('instant_message_add_time','>=',$time_add_to);
        }
        $instant_message_open = input('param.instant_message_open');
        if (in_array($instant_message_open, array('0', '1', '2'))) {
            $condition[]=array('instant_message_open','=',$instant_message_open);
        }
        $member_id=$this->store_info['member_id'];
        $result = Db::name('InstantMessage')->where(function($query) use($member_id){
            $query->where(function($query) use($member_id){
                $query->where(array(array('instant_message_from_id','=',$member_id),array('instant_message_from_type','=',0)));
            })->whereOr(function($query) use($member_id){
                 $query->where(array(array('instant_message_to_id','=',$member_id),array('instant_message_to_type','=',0)));
            });
            })->where($condition)->order('instant_message_id desc')->paginate(['list_rows'=>10,'query' => request()->param()],false);
        $instant_message_list=$result->items();
        foreach($instant_message_list as $key => $val){
            $instant_message_list[$key]=$instant_message_model->formatInstantMessage($val);
        }
        View::assign('instant_message_list', $instant_message_list);
        View::assign('show_page', $result->render());



        View::assign('search', $condition);

        /* 设置卖家当前菜单 */
        $this->setSellerCurMenu('seller_instant_message');
        /* 设置卖家当前栏目 */
        $this->setSellerCurItem('instant_message_list');
        return View::fetch($this->template_dir . 'index');
    }


    /**
     *    栏目菜单
     */
    function getSellerItemList() {
        $menu_array[] = array(
            'name' => 'instant_message_list',
            'text' => lang('chat_query'),
            'url' => url('seller_instant_message/index'),
        );

        return $menu_array;
    }

}