jyblhdl_admin2/application/user/controller/MemberCollection.php

<?php

// +----------------------------------------------------------------------
// | ThinkAdmin
// +----------------------------------------------------------------------
// | 版权所有 2014~2019 广州楚才信息科技有限公司 [ http://www.cuci.cc ]
// +----------------------------------------------------------------------
// | 官方网站: http://demo.thinkadmin.top
// +----------------------------------------------------------------------
// | 开源协议 ( https://mit-license.org )
// +----------------------------------------------------------------------
// | gitee 代码仓库：https://gitee.com/zoujingli/ThinkAdmin
// | github 代码仓库：https://github.com/zoujingli/ThinkAdmin
// +----------------------------------------------------------------------

namespace app\user\controller;

use library\Controller;
use think\Db;
use function GuzzleHttp\Psr7\build_query;

/**
 * 会员信息管理
 * Class Member
 * @package app\user\controller
 */
class MemberCollection extends Controller
{
    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'store_order_info';

    /**
     * 藏品管理
     * @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 = '藏品记录';
        $hash_send=$this->request->get('hash_send');
        $query = $this->_query($this->table)->whereIn('status','1,3');
        if ($hash_send){
            if ($hash_send==1){
                $query->where('collectors_hash','neq','');
            }else if ($hash_send==2){
                $query->where('collectors_hash','eq','');
            }
        }
        $query->dateBetween('create_at')->order('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 $k=>&$v){
            $v['pro_info'] =json_decode($v['pro_info'],true);
            $info = Db::name('store_member')->where('id',$v['mid'])->field('name,phone,wallet_address')->find();
            $v['scz'] = $info['name'].'('.$info['phone'].')';
            $v['wallet_address'] = $info['wallet_address'];

            $pro_info = Db::name('store_collection')->where('id',$v['c_id'])->field('one_given_day,other_given_day')->find();
            $log = Db::name('store_collect_examples_log')
                ->where('order_info_id',$v['id'])
                ->count();
            if (!$log){
                if ($pro_info['one_given_day']!=0){
                    $v['exam_time'] = date('Y-m-d H:i:s',strtotime($v['create_at'])+($pro_info['one_given_day']*24*60*60));
                }else{
                    $v['exam_time'] = $v['create_at'];
                }
            }else{
                if ($pro_info['other_given_day']!=0){
                    $v['exam_time'] = date('Y-m-d H:i:s',strtotime($v['create_at'])+($pro_info['other_given_day']*24*60*60));
                }else{
                    $v['exam_time'] = $v['create_at'];
                }
            }
        }
    }


}