<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/3/26
 * Time: 8:11
 */

namespace api\wxapp\controller;


use cmf\controller\RestBaseController;
use think\Db;
use think\Validate;
/**
 * @title 产品模块
 * @description 产品管理模块
 */
class ProductController extends RestBaseController
{
    /**
     * @title 获取产品列表（筛选）
     * @description 产品
     * @url /wxapp/product/getList
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:abc other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:user_id type:string require:1 other: desc:业务员id
     * @param name:company type:string require:0 other: desc:公司信息（这是公司名称下拉列表吗。不懂）
     * @param name:policy type:string require:0 other: desc:保单信息1有0无
     * @param name:car type:string require:0 other: desc:车辆信息1全款车0无3分期车
     * @param name:page type:string require:0 other: desc:页码
     * @param name:per_page type:string require:0 other: desc:每页数据量
     *
     * @return total:总数据量
     * @return per_page:每页数据量
     * @return current_page:当前页
     * @return last_page:尾页
     * @return data:对象信息@!
     * @data id:产品id name:产品名称 logo:产品logo upper_limit:额度范围上限 lower_limit:额度范围下限 rate:月费率 loan_time:放款时间 loan_period:贷款期限 company:公司名称
     */
    public function getList() {
        $validate = new Validate([
            'user_id'           => 'require',
            'policy'           => 'in:0,1',
            'car'           => 'in:0,3',
        ]);

        $validate->message([
            'user_id.require'           => '参数user_id必须!',
            'policy.in'           => '参数policy只能为0,1!',
            'car.in'           => '缺少参数car只能为0,3!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        $per_page = $data['per_page'] ? : config('per_page');
        $condition['p.type'] = 1;//上架产品
        $condition['c.user_id'] = $data['user_id'];
        if ($data['company']) {
            $condition['p.job'] = $data['company'];
        }
        if ($data['policy']) {
            $condition['p.policy'] = $data['policy'];
        }
        if ($data['car']) {
            $condition['p.car'] = $data['car'];
        }
        $result = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where($condition)
            ->field('p.id,p.name,p.logo,p.upper_limit,p.lower_limit,p.rate,p.loan_time,p.loan_period,c.company')
            ->order('p.create_time desc')
            ->paginate($per_page);
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'获取失败']);
        }
        $this->success('获取成功',$result);
    }

    /**
     * @title 获取产品详情
     * @description 产品
     * @url /wxapp/product/getDetails
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:abc other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:id type:string require:1 other: desc:产品id
     *
     * @return id:产品id
     * @return name:产品名称
     * @return logo:产品logo
     * @return upper_limit:额度范围上限
     * @return lower_limit:额度范围下限
     * @return rate:月费率
     * @return loan_time:放款时间
     * @return loan_period:贷款期限
     * @return loan_flow:贷款流程
     * @return fee_explain:费用说明
     * @return refund_explain:还款说明
     * @return company:公司名称
     * @return job:工作信息 1上班 2做生意
     * @return policy:保单信息 1有 0无
     * @return house:房产信息 1全款房 2分期房 0无
     * @return car:车辆信息 1全款车 0无 3分期车
     * @return remark:备注
     * @return is_apply:是否申请该产品贷款（1已申请0未申请）
     */
    public function getDetails() {
        $validate = new Validate([
            'id'           => 'require',
        ]);

        $validate->message([
            'id.require'           => '参数id必须!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        $result = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where(['p.id' => $data['id']])
            ->field('p.id,p.name,p.logo,p.upper_limit,p.lower_limit,p.rate,p.loan_time,p.loan_period,p.loan_flow,p.fee_explain,p.refund_explain,c.company,p.job,p.policy,p.house,p.car,p.remark')
            ->find();
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'获取失败']);
        }
        if (!empty($result)) {
            $check = Db::name('loans_apply')->where(['product_id' => $result['id'],'user_id' => $this->userId])->find();
            if ($check) {
                $result['is_apply'] = 1;
            } else {
                $result['is_apply'] = 0;
            }
        }
        $this->success('获取成功',$result);
    }

    /**
     * @title 添加产品
     * @description 产品
     * @url /wxapp/product/addProduct
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:name type:int require:1 other: desc:产品名称
     * @param name:logo type:int require:1 other: desc:产品logo
     * @param name:upper_limit type:int require:1 other: desc:额度范围上限
     * @param name:lower_limit type:int require:1 other: desc:额度范围下限
     * @param name:rate type:int require:1 other: desc:月费率
     * @param name:loan_period type:int require:1 other: desc:贷款期限
     * @param name:job type:int require:1 other: desc:工作信息1上班2做生意
     * @param name:policy type:int require:1 other: desc:保单信息1有0无
     * @param name:house type:int require:1 other: desc:房产信息1全款房2分期房0无
     * @param name:information type:int require:1 other: desc:个人信息
     * @param name:car type:int require:1 other: desc:车辆信息1全款车0无3分期车
     * @param name:loan_flow type:int require:1 other: desc:贷款流程
     * @param name:fee_explain type:int require:0 other: desc:费用说明
     * @param name:refund_explain type:int require:0 other: desc:还款说明
     * @param name:remark type:int require:0 other: desc:备注
     *
     */
    public function addProduct() {
        $validate = new Validate([
            'name'           => 'require',
            'logo'           => 'require',
            'upper_limit'           => 'require',
            'lower_limit'           => 'require',
            'rate'           => 'require',
            'loan_period'           => 'require',
            //'loan_time'           => 'require',
            'job'           => 'require',
            'policy'           => 'require',
            'house'           => 'require',
            'information'           => 'require',
            'car'           => 'require',
            'loan_flow'           => 'require',
            //'fee_explain'           => 'require',
            //'refund_explain'           => 'require',
        ]);

        $validate->message([
            'name.require'           => '缺少参数name!',
            'logo.require'           => '缺少参数logo!',
            'upper_limit.require'           => '缺少参数upper_limit!',
            'lower_limit.require'           => '缺少参数lower_limit!',
            'rate.require'           => '缺少参数rate!',
            'loan_period.require'           => '缺少参数loan_period!',
           // 'loan_time.require'           => '缺少参数loan_time!',
            'job.require'           => '缺少参数job!',
            'policy.require'           => '缺少参数policy!',
            'house.require'           => '缺少参数house!',
            'information.require'           => '缺少参数information!',
            'car.require'           => '缺少参数car!',
            'loan_flow.require'           => '缺少参数loan_flow!',
            //'fee_explain.require'           => '缺少参数fee_explain!',
            //'refund_explain.require'           => '缺少参数refund_explain!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }

        $arr = [
            'name' => $data['name'],
            'logo' => $data['logo'],
            'upper_limit' => $data['upper_limit'],
            'lower_limit' => $data['lower_limit'],
            'rate' => $data['rate'],
            'loan_period' => $data['loan_period'],
            //'loan_time' => $data['loan_time'],
            'job' => $data['job'],
            'policy' => $data['policy'],
            'house' => $data['house'],
            'information' => $data['information'],
            'car' => $data['car'],
            'loan_flow' => $data['loan_flow'],
            'fee_explain' => $data['fee_explain'],
            'refund_explain' => $data['refund_explain'],
            'user_id' => $this->userId,
            'remark' => isset($data['remark']) ? $data['remark'] : ''
        ];
        $result = Db::name('product')->insert($arr);
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'操作失败']);
        }
        $this->success('操作成功');
    }

    /**
     * @title 编辑产品
     * @description 产品
     * @url /wxapp/product/editProduct
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:id type:int require:1 other: desc:产品id
     * @param name:name type:int require:1 other: desc:产品名称
     * @param name:logo type:int require:1 other: desc:产品logo
     * @param name:upper_limit type:int require:1 other: desc:额度范围上限
     * @param name:lower_limit type:int require:1 other: desc:额度范围下限
     * @param name:rate type:int require:1 other: desc:月费率
     * @param name:loan_period type:int require:1 other: desc:贷款期限
     * @param name:job type:int require:1 other: desc:工作信息1上班2做生意
     * @param name:policy type:int require:1 other: desc:保单信息1有0无
     * @param name:house type:int require:1 other: desc:房产信息1全款房2分期房0无
     * @param name:information type:int require:1 other: desc:个人信息
     * @param name:car type:int require:1 other: desc:车辆信息1全款车0无3分期车
     * @param name:loan_flow type:int require:1 other: desc:贷款流程
     * @param name:fee_explain type:int require:0 other: desc:费用说明
     * @param name:refund_explain type:int require:0 other: desc:还款说明
     * @param name:remark type:int require:0 other: desc:备注
     *
     */
    public function editProduct() {
        $validate = new Validate([
            'id'           => 'require',
            'name'           => 'require',
            'logo'           => 'require',
            'upper_limit'           => 'require',
            'lower_limit'           => 'require',
            'rate'           => 'require',
            'loan_period'           => 'require',
            //'loan_time'           => 'require',
            'job'           => 'require',
            'policy'           => 'require',
            'house'           => 'require',
            'information'           => 'require',
            'car'           => 'require',
            'loan_flow'           => 'require',
            //'fee_explain'           => 'require',
            //'refund_explain'           => 'require',
        ]);

        $validate->message([
            'id.require'           => '缺少参数id!',
            'name.require'           => '缺少参数name!',
            'logo.require'           => '缺少参数logo!',
            'upper_limit.require'           => '缺少参数upper_limit!',
            'lower_limit.require'           => '缺少参数lower_limit!',
            'rate.require'           => '缺少参数rate!',
            'loan_period.require'           => '缺少参数loan_period!',
            //'loan_time.require'           => '缺少参数loan_time!',
            'job.require'           => '缺少参数job!',
            'policy.require'           => '缺少参数policy!',
            'house.require'           => '缺少参数house!',
            'information.require'           => '缺少参数information!',
            'car.require'           => '缺少参数car!',
            'loan_flow.require'           => '缺少参数loan_flow!',
            //'fee_explain.require'           => '缺少参数fee_explain!',
            //'refund_explain.require'           => '缺少参数refund_explain!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }

        $arr= [
            'id' => $data['id'],
            'name' => $data['name'],
            'logo' => $data['logo'],
            'upper_limit' => $data['upper_limit'],
            'lower_limit' => $data['lower_limit'],
            'rate' => $data['rate'],
            'loan_period' => $data['loan_period'],
            //'loan_time' => $data['loan_time'],
            'job' => $data['job'],
            'policy' => $data['policy'],
            'house' => $data['house'],
            'information' => $data['information'],
            'car' => $data['car'],
            'loan_flow' => $data['loan_flow'],
            'fee_explain' => $data['fee_explain'],
            'refund_explain' => $data['refund_explain'],
            'user_id' => $this->userId,
            'remark' => isset($data['remark']) ? $data['remark'] : ''
        ];
        $result = Db::name('product')->update($arr);
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'操作失败']);
        }
        $this->success('操作成功');
    }
    /**
     * @title 删除产品
     * @description 产品
     * @url /wxapp/product/delProduct
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:ids type:int require:1 other: desc:产品id（以英文,相隔的产品id字符串）
     *
     */
    public function delProduct() {
        $validate = new Validate([
            'ids'           => 'require',
        ]);

        $validate->message([
            'ids.require'           => '缺少参数ids!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        $result = Db::name('product')
            ->where('user_id','=',$this->userId)
            ->where('id','in',$data['ids'])
            ->delete();
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'操作失败']);
        }
        $this->success('操作成功');
    }

    /**
     * @title 通过业务员id获取产品列表
     * @description 产品
     * @url /wxapp/product/getListByUserID
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:user_id type:int require:1 other: desc:业务员id
     * @param name:company type:int require:0 other: desc:工作信息1上班2做生意0无 3不限
     * @param name:policy type:int require:0 other: desc:保单信息1有0无2不限
     * @param name:car type:int require:0 other: desc:车辆信息1全款车0无2不限3分期车
     * @param name:page type:int require:0 other: desc:页码
     * @param name:per_page type:int require:0 other: desc:每页数据量
     *
     * @return total:总数据量
     * @return total_page:总页数
     * @return data:对象信息@!
     * @data id:产品id id name:产品名称 logo:产品logo upper_limit:额度范围上限 lower_limit:额度范围下限 rate:月费率 loan_time:放款时间 loan_period:贷款期限 company:公司 is_apply:是否申请该产品贷款（1已申请0未申请）
     */
    public function getListByUserID() {
        $validate = new Validate([
            'user_id'           => 'require',
        ]);
        $validate->message([
            'user_id.require'           => '缺少参数user_id!',
        ]);
        $data = $this->request->param();

        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        $condition['p.type'] = 1;//上架产品
        $condition['p.user_id'] = $data['user_id'];
//        if (!empty($data['company'])) {
//            $condition['p.job'] = $data['company'];
//        }
//        && $data['company'] !=null
        if (isset($data['company']) && $data['company'] !=3) {
            $condition['p.job'] = $data['company'];
        }
//        && $data['policy'] !=null
        if (isset($data['policy']) && $data['policy'] !=2) {
            $condition['p.policy'] = $data['policy'];
        }
//        && $data['car'] !=null
        if (isset($data['car'])   && $data['car'] !=2) {
            $condition['p.car'] = $data['car'];
        }
        $list = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where($condition)
            ->field('p.id,p.name,p.logo,p.upper_limit,p.lower_limit,p.rate,p.loan_time,p.loan_period,c.company')
            ->order('p.create_time desc')
            ->select()->toArray();
        if ($list === false) {
            $this->error(['code'=>'40000','msg'=>'获取失败']);
        }
        if (!empty($list)) {
            foreach ($list as $k => $v) {
                $check = Db::name('loans_apply')->where(['product_id' => $v['id'],'user_id' => $this->userId])->find();
                if ($check) {
                    $list[$k]['is_apply'] = 1;
                } else {
                    $list[$k]['is_apply'] = 0;
                }
            }
        }
        $arrResult = [];
        foreach ($list as $v) {
            $arrResult[] = $v;
        }
        $perPage = !empty($data['per_page']) ? $data['per_page'] : config('per_page');
        $page = !empty($data['page']) ? $data['page'] : 1;
        $resultWithPage = array_slice($arrResult, ($page - 1) * $perPage, $perPage);
        $qinCount = count($arrResult);
        $totalPage = ceil($qinCount / $perPage);
        if ($arrResult) {
            $return['data'] = $resultWithPage;
            $return['total_page'] = $totalPage;
            $return['total'] = $qinCount;
        } else {
            $return['data'] = $resultWithPage;
            $return['total_page'] = 0;
            $return['total'] = 0;
        }
        $this->success('获取成功',$return);
    }

    /**
     * @title 申请贷款
     * @description 产品
     * @url /wxapp/product/applyLoans
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:id type:int require:1 other: desc:产品id
     *
     */
    public function applyLoans() {
        $validate = new Validate([
            'id'           => 'require',
        ]);

        $validate->message([
            'id.require'           => '缺少参数id!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        //校验 是否已申请
        $check = Db::name('loans_apply')->where(['product_id' => $data['id'],'user_id'=>$this->userId])->field('id')->find();
        if ($check) {
            $this->error(['code'=>'40006','msg'=>'该产品您已申请']);
        }
        $cardID = Db::name('product')
            ->alias('p')
            ->join('card c','p.user_id =c.user_id')
            ->where(['p.id' =>$data['id']])
            ->value('c.id');
        if (!$cardID) {
            $this->error(['code'=>'40011','msg'=>'该产品不存在']);
        }
        //排除业务员自己 不能申请自己产品
        if ($this->userType == 3) {
            $card_id = Db::name('card')->where(['user_id' => $this->userId])->value('id');
            if ($cardID == $card_id) {
                $this->error(['code'=>'40014','msg'=>'不能申请自己的产品']);
            }
        }
        //添加该名片的被浏览记录 产品 入口
        $is_exist = Db::name('browse_log')
            ->where(['topic_id' => $data['id'],'user_id' => $this->userId,'type' =>2])
            ->field('id')
            ->find();
        if (!$is_exist) {
            Db::name('browse_log')->insert(['topic_id' => $cardID,'user_id' => $this->userId,'type'=>2]);
        }
        //插入申请表
        $result = Db::name('loans_apply')->insert(['product_id' => $data['id'],'user_id'=>$this->userId]);
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'操作失败']);
        }
        $this->success('操作成功');
    }

    /**
     * @title 匹配产品（普通用户）
     * @description 产品
     * @url /wxapp/product/matchingCard
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:mobile type:int require:1 other: desc:电话
     * @param name:age type:int require:1 other: desc:年龄
     * @param name:job type:int require:1 other: desc:工作信息1上班2做生意3不限
     * @param name:house type:int require:1 other: desc:房产信息1全款房2分期房0无
     * @param name:policy type:int require:1 other: desc:保单信息1有0无2不限
     * @param name:car type:int require:1 other: desc:车辆信息1全款车0无2不限3分期车
     * @param name:page type:string require:0 other: desc:页码
     * @param name:per_page type:string require:0 other: desc:每页数据量
     *
     * @return lower_total:总额度（最低）
     * @return upper_total:总额度（最高）
     * @return product_list:对象信息@!
     * @product_list id:名片id name:名片名称 avatar:头像 position:职称 company:公司 tel:电话 email:邮箱 upper_limit:额度范围上限 lower_limit:额度范围下限
     */
    public function matchingCard() {
        $validate = new Validate([
            'mobile'           => 'require',
            'age'           => 'require',
            'job'           => 'require|in:0,1,2,3',
            'house'           => 'require|in:0,1,2',
            'policy'           => 'require|in:0,1,2',
            'car'           => 'require|in:0,1,2,3',
        ]);

        $validate->message([
            'mobile.require'           => '缺少参数mobile!',
            'age.require'           => '缺少参数age!',
            'job.require'           => '缺少参数job!',
            'job.in'           => '参数job范围0-3!',
            'house.require'           => '缺少参数house!',
            'house.in'           => '参数house范围0-2!',
            'policy.require'           => '缺少参数policy!',
            'policy.in'           => '参数policy范围0-2!',
            'car.require'           => '缺少参数car!',
            'car.in'           => '参数car范围0-3!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        //保存用户数据到用户表
        $arr = [
            'mobile' => $data['mobile'],
            'age' => $data['age'],
            'job' => $data['job'],
            'house' => $data['house'],
            'policy' => $data['policy'],
            'car' => $data['car']
        ];
        Db::name('user')->where(['id' => $this->userId])->update($arr);

        $per_page = $data['per_page'] ? : config('per_page');
        if (isset($data['job']) && $data['job'] !=null && $data['job'] != 3) {
            $condition['p.job'] = $data['job'];
        }
        if (isset($data['policy']) && $data['policy'] !=null && $data['policy'] != 2) {
            $condition['p.policy'] = $data['policy'];
        }
        if (isset($data['car']) && $data['car'] !=null && $data['car'] != 2) {
            $condition['p.car'] = $data['car'];
        }
        //加分享过的名片
        $ids = Db::name('card_log')->where(['user_id' => $this->userId])->column('card_id');
        $condition['c.id'] = ['in',$ids];//加分享过的名片
        $condition['p.type'] = 1;//上架产品
        $condition['p.house'] = $data['house'];
        $list = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where($condition)
            ->group('c.id')
            ->field('c.id,c.name,u.avatar,c.company,c.position,c.tel,c.email')
            ->order('p.create_time desc')
            ->paginate($per_page);
        if ($list === false) {
            $this->error(['code'=>'40000','msg'=>'获取失败']);
        }
        $result =[];
        $result['product_list'] = $list;
        //获取满足条件的 总额度
        $result['lower_total'] = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where($condition)
            ->sum('lower_limit');
        $result['upper_total'] = Db::name('product')
            ->alias('p')
            ->where($condition)
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->sum('upper_limit');
        $this->success('获取成功',$result);
    }

    /**
     * @title 匹配产品（信贷员）
     * @description 产品
     * @url /wxapp/product/matchingProduct
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:def other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:mobile type:int require:1 other: desc:电话
     * @param name:age type:int require:1 other: desc:年龄
     * @param name:job type:int require:1 other: desc:工作信息1上班2做生意3不限
     * @param name:house type:int require:1 other: desc:房产信息1全款房2分期房0无
     * @param name:policy type:int require:1 other: desc:保单信息1有0无2不限
     * @param name:car type:int require:1 other: desc:车辆信息1全款车0无2不限3分期车
     * @param name:page type:string require:0 other: desc:页码
     * @param name:per_page type:string require:0 other: desc:每页数据量
     *
     * @return lower_total:总额度（最低）
     * @return upper_total:总额度（最高）
     * @return product_list:对象信息@!
     * @product_list id:产品id name:产品名称 logo:产品logo upper_limit:额度范围上限 lower_limit:额度范围下限 rate:月费率 loan_time:放款时间 is_apply:是否申请该产品贷款（1已申请0未申请）
     */
    public function matchingProduct() {
        $validate = new Validate([
            'mobile'           => 'require',
            'age'           => 'require',
            'job'           => 'require|in:0,1,2,3',
            'house'           => 'require|in:0,1,2',
            'policy'           => 'require|in:0,1,2',
            'car'           => 'require|in:0,1,2,3',
        ]);

        $validate->message([
            'mobile.require'           => '缺少参数mobile!',
            'age.require'           => '缺少参数age!',
            'job.require'           => '缺少参数job!',
            'job.in'           => '参数job范围0-3!',
            'house.require'           => '缺少参数house!',
            'house.in'           => '参数house范围0-2!',
            'policy.require'           => '缺少参数policy!',
            'policy.in'           => '参数policy范围0-2!',
            'car.require'           => '缺少参数car!',
            'car.in'           => '参数car范围0-3!',
        ]);

        $data = $this->request->param();
        if (!$validate->check($data)) {
            $this->error(['code'=>'40003','msg'=>$validate->getError()]);
        }
        //保存用户数据到用户表
        $arr = [
            'mobile' => $data['mobile'],
            'age' => $data['age'],
            'job' => $data['job'],
            'house' => $data['house'],
            'policy' => $data['policy'],
            'car' => $data['car']
        ];
        Db::name('user')->where(['id' => $this->userId])->update($arr);

        $per_page = $data['per_page'] ? : config('per_page');
        //todo 个人信息 条件接收名片
        //todo 个人信息 条件接收名片 新增全部
        if (isset($data['job']) && $data['job'] !=null && $data['job'] != 3) {
            $condition['p.job'] = $data['job'];
        }
        if (isset($data['policy']) && $data['policy'] !=null && $data['policy'] != 2) {
            $condition['p.policy'] = $data['policy'];
        }
        if (isset($data['car']) && $data['car'] !=null && $data['car'] != 2) {
            $condition['p.car'] = $data['car'];
        }
        $condition['p.type'] = 1;//上架产品
        $condition['p.house'] = $data['house'];
        $list = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where($condition)
            ->field('p.id,p.name,p.logo,p.upper_limit,p.lower_limit,p.rate,p.loan_time,p.loan_period,c.company')
            ->order('p.create_time desc')
            ->paginate($per_page)->toArray();
        if ($list === false) {
            $this->error(['code'=>'40000','msg'=>'获取失败']);
        }
        if (count($list) > 0) {
            foreach ($list['data'] as $k => $v) {
                $check = Db::name('loans_apply')->where(['product_id' => $v['id'],'user_id' => $this->userId])->find();
                if ($check) {
                    $list['data'][$k]['is_apply'] = 1;
                } else {
                    $list['data'][$k]['is_apply'] = 0;
                }
            }
        }
        $result =[];
        $result['product_list'] = $list;
        //获取满足条件的 总额度
        $result['lower_total'] = Db::name('product')->alias('p')->where($condition)->sum('lower_limit');
        $result['upper_total'] = Db::name('product')->alias('p')->where($condition)->sum('upper_limit');
        $this->success('获取成功',$result);
    }
    /**
     * @title 获取公司列表信息（通过业务员id）
     *
     * @description 名片/产品列表公司信息下拉数据
     * @url /wxapp/product/getCompanyByUserID
     * @method POST
     *
     * @header name:XX-Token type:string require:1 default:abc other: desc:登录标识
     * @header name:XX-Device-Type type:string require:0 default:wxapp other: desc:设备类型
     *
     * @param name:user_id type:string require:0 other: desc:业务员id
     *
     * @return data:对象信息@!
     * @data id:名片id id avatar:头像 name:姓名 position:职称 tel:电话 home_tel:座机 email:邮箱 company:公司
     */
    public function getCompanyByUserID() {
        $validate = new Validate([
            'user_id'           => 'require',
        ]);
        $validate->message([
            'user_id.require'           => '缺少参数user_id!',
        ]);
        $data = $this->request->param();
        $condition['p.user_id'] = $data['user_id'];
        $result = Db::name('product')
            ->alias('p')
            ->join('user u','p.user_id=u.id','left')
            ->join('card c','p.user_id=c.user_id','left')
            ->where($condition)
            ->group('p.user_id')
            ->field('c.id,c.company')
            ->order('p.create_time desc')
            ->select();
        if ($result === false) {
            $this->error(['code'=>'40000','msg'=>'获取失败']);
        }
        $this->success('获取成功',$result);
    }
}