gonghuixiangqin/application/store/controller/Member.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\store\controller;

use library\Controller;
use think\Db;
use think\Exception;

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

    /**
     * 会员信息管理
     * @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 = '会员信息管理';
        $input = input();

        $where = [];
        if(isset($input['city_id'])) {
            if ($input['city_id'] != 0) {
                $where[] = ['city_id', '=', $input['city_id']];
            }
        }
        if(isset($input['area_id'])) {
            if ($input['area_id'] != 0) {
                $where[] = ['area_id', '=', $input['area_id']];
            }
        }
        if(isset($input['sex'])) {
            if ($input['sex'] != 0) {
                $where[] = ['sex', '=', $input['sex']];
            }
        }
        if(isset($input['education'])) {
            if ($input['education'] != '不限') {
                $where[] = ['education', '=', $input['education']];
            }
        }
        if(isset($input['nature'])) {
            if ($input['nature'] != 0) {
                $where[] = ['nature', '=', $input['nature']];
            }
        }
        if(isset($input['status'])) {
            if ($input['status'] != 0) {
                $where[] = ['status', '=', $input['status']];
            }
        }
        if(isset($input['vip_level'])) {
            if ($input['vip_level'] != '') {
                $where[] = ['vip_level', '=', $input['vip_level']];
            }
        }

        $query = $this->_query($this->table)->like('nickname,phone,age')->where($where);

        if(!empty($input['type']) && $input['type'] == 2 && (!empty($input['sex']) || !empty($input['nature']) || !empty($input['city_id']) || !empty($input['area_id']) || !empty($input['age']))){
                if(isset($input['sex']) && !empty($input['sex']))$condition['sex'] = $input['sex'];
                if(isset($input['nature']) && !empty($input['nature']))$condition['nature'] = $input['nature'];
                if(isset($input['city_id']) && !empty($input['city_id']))$condition['city_id'] = $input['city_id'];
                if(isset($input['area_id']) && !empty($input['area_id']))$condition['area_id'] = $input['area_id'];
                if(isset($input['age']) && !empty($input['age']))$condition['age'] = $input['age'];
            $result = [];

            $data = Db::name('StoreMember')
                    ->where($condition)
//                    ->where('id','<',20)
//                    ->field('id,username,sex,age,height,phone,education,province_id,city_id,area_id,position,nature')
                    ->field('id,username,sex,age,height,phone,education,position,nature')
                    ->cursor();
                foreach ($data as $value){
//                                print_r($value);

                    if($value['sex'] == 1){
                        $value['sex'] = '男';
                    }else{
                        $value['sex'] = '女';
                    }
//                    $value['province_id'] = Db::name('store_area')->where('id',$value['province_id'])->value('name');
//                    $value['city_id'] = Db::name('store_area')->where('id',$value['city_id'])->value('name');
//                    $value['area_id'] = Db::name('store_area')->where('id',$value['area_id'])->value('name');
//                    $fname=array("序号","姓名","性别","年龄","身高","手机号","学历","省","市","区","工作职业","工作性质");
                    $fname=array("序号","姓名","性别","年龄","身高","手机号","学历","工作职业","工作性质");
                    $value = array_combine($fname,$value);
                    array_push($result,$value);
                }

            $field =[
                'A'=>['序号'],
                'B'=>['姓名'],
                'C'=>['性别'],
                'D'=>['年龄'],
                'E'=>['身高'],
                'F'=>['手机号'],
                'G'=>['学历'],
//                'H'=>['省'],
//                'I'=>['市'],
//                'J'=>['区'],
                'K'=>['工作职业'],
                'L'=>['工作性质']
            ];
            phpExcelListNew($field,$result);
        }
        $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)
    {
        $nature = Db::name('store_work_nature')->where('is_deleted', 0)->column('name', 'id');

        $province = ['' => '全部'] + db('store_area')->where('level',1)->column('name', 'id');

        $category_one = db('store_area')->where('id', 1479)->select();
        $category_two = db('store_area')->where('pid', 1479)->select();


        $this->fetch('index',['province'=>$province,'list'=>$data,
            'pro' => $category_one,
            'xian' => $category_two,
            'nature'=>$nature]);

    }
    public function detail(){
        $id = input('id');
        $info =Db::name('store_member')->where('id',$id)->find();
        $one = Db::name('store_member_image')->where(array('type' => 1, 'mid' => $id))->field('show_image')->select();
        $two = Db::name('store_member_image')->where(array('type' => 2, 'mid' => $id))->field('show_image')->select();
        $info['one'] = $one;
        $info['two'] = $two;
        $info['danwei']=Db::name('store_company')->where('id',$info['working'])->value('name');
        $info['xingzhi']=Db::name('store_work_nature')->where('id',$info['nature'])->value('name');
//        print_r($info);die;
        $this->assign('info',$info);
        $this->fetch();

    }
    function getpor()
    {
        $id=input('id');//一级菜单的id
        $list=$this->get_address($id);
        return json_encode($list);
    }

    function get_address($id){
        $add = Db::name('store_area')->where('pid', $id)->select();
        return $add;
    }
    public function examine(){
        $id=input('id');
        Db::name('store_member')->where('id',$id)->update(['vip_level'=>1]);
        $this->success('已认证会员');
    }
    public function member_log(){
        $info =Db::name('store_member')->where('vip_level',3)->select();
        $this->assign('list',$info);
        $this->fetch();
    }
    public function member_delete()
    {
        $id = input('id');
        Db::startTrans();
        try {
            Db::name('store_member')->where('id',$id)->delete();
            Db::name('store_member_basic')->where('mid',$id)->delete();
            Db::name('store_examine')->where('mid',$id)->delete();
            Db::name('store_member_interested')->where('i_id',$id)->delete();
            Db::name('store_member_follow')->where('fid',$id)->delete();
            Db::commit();
            $this->success('会员删除成功');
        }catch (Exception $e){
            Db::rollback();
            $this->error('会员删除出问题了');
        }
    }
    /**
     * 编辑会员
     * @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
     */
    function edit()
    {
        $this->_form($this->table, 'form');

    }
    /**
     * 表单数据处理
     * @auth true
     * @menu true
     * @param array $data
     */
    protected function _form_filter(&$data)
    {
        if ($this->request->isPost()) {
            if(empty(input('province_id')) || empty(input('city_id')) || empty(input('area_id')))$this->error(input('area_id'));
        } else {
            $province_id =  db('store_area')->where('level',1)->select();
            $city_id = db('store_area')->where('level',2)->where('pid',$data['province_id'])->select();
            $area_id = db('store_area')->where('level',3)->where('pid',$data['city_id'])->select();


            $this->assign('province_id',$province_id);
            $this->assign('city_id',$city_id);
            $this->assign('area_id',$area_id);
        }
    }



}