gonghuixiangqin/application/store/controller/Examine.php

<?php

namespace app\store\controller;

use library\Controller;
use think\Db;

/**
 * 会员认证审核
 * Class Auth
 * @package app\store\controller
 */
class Examine extends Controller
{
    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'store_examine';

    /**
     * 会员认证审核管理
     * @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 = '会员认证审核';
        $query = $this->_query($this->table)->alias('e')->join('store_member m','m.id=e.mid')->like('m.username#name')->equal('e.status#status');
        $query->dateBetween('e.create_at')->where('e.is_deleted',0)->field('e.*,m.username')->order('e.id desc')->page();
    }
    protected function _index_page_filter(&$data)
    {
        foreach ($data as &$v){
            $v['n_id']=Db::name('store_work_nature')->where('id',$v['n_id'])->value('name');
        }

    }
    /**
     * 添加快递公司
     * @auth false
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function add()
    {
        $this->_form($this->table, 'form');
    }

    /**
     * 编辑快递公司
     * @auth false
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function edit()
    {
        $this->_form($this->table, 'form');
    }

    /**
     * 表单数据处理
     * @param array $data
     * @auth true
     */
    protected function _form_filter(&$data)
    {

        if ($this->request->isPost()) {
            if(!isset($data['status'])){
                $this->error('请审核后提交');
            }
            if($data['status']==2){
                $info = Db::name('store_examine')->where('id',$data['id'])->find();
                $member = [
//                    'username'=>$info['name'],
//                    'phone'=>$info['phone'],
                    'working'=>$info['c_id'],
                    'vip_level'=>1,
                    'nature'=>$info['n_id'],
                    'constellation'=>$info['constellation'],
                    'hobby'=>$info['hobby'],
                    'status'=>$info['hunshi'],
                    'is_zinv'=>$info['is_zinv'],
                    'zinv_sex'=>$info['zinv_sex'],
                    'is_du'=>$info['is_du'],
                    'children'=>$info['children'],
                    'home'=>$info['home'],
                    'is_car'=>$info['is_car'],
                    'car_model'=>$info['car_model'],
                    'fa_work'=>$info['fa_work'],
                    'ma_work'=>$info['ma_work'],
                    'graduation_school'=>$info['graduation_school'],
                    'position'=>$info['position'],
                    'income'=>$info['income'],
                ];
                Db::name('store_member')->where('id',$info['mid'])->update($member);
            }
            $data['update_at']=date('Y-m-d H:i:s');
        }
        else{
            $data['describes_arr'] = explode(',',$data['m_images']);

        }
    }

}