xianglian_test_admin/application/store/controller/CollectInfo.php

<?php
namespace app\store\controller;
use app\common\library\PHPExcelService;
use library\Controller;
use think\Db;
use function Symfony\Component\String\s;

/**
 * 收藏明细
 * Class CollectInfo
 * @package app\store\controller
 */
class CollectInfo extends Controller
{

    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'StoreOrderInfo';

    /**
     * 收藏明细
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->title = '收藏明细';
        $goods_id = input('goods_id');
        $phone  = input('phone');
        $hash = input('hash');
        $tag = input('tag');
        $sel_where = [];
        $sel_where[] = ['i.c_id','=',$goods_id];
        $sel_where[] = ['i.status','<>',2];
        $sel_where[] = ['i.resale_status','in','1,2'];
        $sel_where[] = ['i.is_destruction','=',1];
        if($phone) $sel_where[]= ['u.phone','=',$phone];
        if($hash) $sel_where[]= ['i.collectors_hash','=',$hash];
        if($tag) $sel_where[]= ['i.tag','=',$tag];
        $query = $this->_query($this->table)
            ->alias('i')
            ->field('i.id,i.tag,i.order_id,i.status,i.collectors_hash,i.type,i.from,i.to_mid,i.order_no,i.mid,i.c_id,i.name,i.cover,i.create_at,u.phone,u.name user_name,u.headimg')
            ->join('store_member u','u.id = i.mid','left')
            ->where($sel_where);
        $query->order('i.id desc')->page();

    }

    /**
     * 数据列表处理
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _index_page_filter(&$data)
    {
        foreach ($data as &$v) {
            $v['from_desc'] = '--';
        }
    }

    /**
     * 数据列表处理
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function course()
    {
        $id  = input('id');
        $info  =Db::name('store_order_info')->where('id',$id)->find();
        $tag  =$info['tag'];
        $list  = Db::name('store_order_info')->alias('i')
            ->field('i.id,i.tag,i.order_id,i.resale_status,i.status,i.collectors_hash,i.type,i.is_destruction,i.from,i.to_mid,i.order_no,i.mid,i.c_id,i.name,i.cover,i.create_at,u.phone,u.name user_name,u.headimg')
            ->join('store_member u','u.id = i.mid','left')
            ->where('tag',$tag)
            ->where('c_id',$info['c_id'])
            ->order('id desc')
            ->select();
        foreach ($list as &$v) {
            $v['coll_state'] = 1;
            if($v['resale_status'] == 3 || $v['is_destruction'] == 0 || in_array($v['status'],[2])) $v['coll_state'] = 0;
        }
        $this->assign('list',$list);
        $this->fetch('course');
    }




    /**
     * 导出EXCL
     * @remark 根据WHERE条件导出EXCL
     * @param array $post 查询条件所需值
     * @return array
     */
    public function get_excl()
    {
        set_time_limit(0);
        $goods_id = input('goods_id');
        $phone  = input('phone');
        $hash = input('hash');
        $tag = input('tag');
        $sel_where = [];
        $sel_where[] = ['i.c_id','=',$goods_id];
        $sel_where[] = ['i.resale_status','in','1,2'];
        $sel_where[] = ['i.is_destruction','=',1];
        $sel_where[] = ['i.status','<>',2];
        if($phone) $sel_where[]= ['u.phone','=',$phone];
        if($hash) $sel_where[]= ['i.collectors_hash','=',$hash];
        if($tag) $sel_where[]= ['i.tag','=',$tag];
        $list = Db::name('store_order_info')
            ->alias('i')
            ->field('i.id,i.tag,i.order_id,i.status,i.collectors_hash,i.type,i.from,i.to_mid,i.order_no,i.mid,i.c_id,i.name,i.cover,i.create_at,u.phone,u.name user_name,u.headimg')
            ->join('store_member u','u.id = i.mid','left')
            ->where($sel_where)->order('i.id desc')->select();
        $export = [];
        foreach ($list as $value){
            $export[] = [
                $value['name'],
                $value['user_name'],
                $value['phone'],
                $value['order_no'],
                $value['collectors_hash'],
                $value['tag'],
                $value['create_at']
            ];
        }
        PHPExcelService::setExcelHeader(['藏品名称','会员名称','电话','订单编号','收藏者hash','编号','时间'])
            ->setExcelTile('收藏明细导出' . date('YmdHis', time()), '收藏'. time(), ' 生成时间：' . date('Y-m-d H:i:s', time()))
            ->setExcelContent($export)
            ->ExcelSave();

    }


    public function export_excl()
    {
        set_time_limit(0);
        $goods_id = input('goods_id');;
        $sel_where = [];
        $sel_where[] = ['i.c_id','=',$goods_id];
        $sel_where[] = ['i.resale_status','in','1,2'];
        $sel_where[] = ['i.is_destruction','=',1];
        $sel_where[] = ['i.status','<>',2];
        $goods_name = Db::name('store_collection')->where('id',$goods_id)->value('name');
        $list = Db::name('store_order_info')
            ->alias('i')
            ->field('count(i.id) num,i.mid,u.phone,u.name user_name')
            ->join('store_member u','u.id = i.mid','left')
            ->group('i.mid')
            ->order('num desc')->where($sel_where)->select();
        $export = [];
        foreach ($list as $value){
            $value['name'] = $goods_name;
            $export[] = [
                $value['name'],
                $value['user_name'],
                $value['phone'],
                $value['num'],
            ];
        }
        PHPExcelService::setExcelHeader(['藏品名称','会员名称','电话','数量'])
            ->setExcelTile('收藏统计导出' . date('YmdHis', time()), '收藏'. time(), ' 生成时间：' . date('Y-m-d H:i:s', time()))
            ->setExcelContent($export)
            ->ExcelSave();
    }


}