<?php

namespace app\admin\controller;

use app\model\Estimate;
use think\Db;

class EstimateSetUp extends Base
{
    public $type = ["1"=>"住宅","2"=>"商业"];
    /**
     * 预估单设置列表
     * @author   cavan
    */
	public function EstimateList()
	{
        $bank_id = $this->request->post('bank_id', '','trim');                //银行
        $page = $this->request->post('page', '','trim');                //页码
        $size = $this->request->post('limit', '','trim');                //单页数量


        $where = array();
        if(!empty($bank_id)){
            $where[]=['bank_id','=',$bank_id];
        }
        if(empty($order)){
            $order=json_encode(array('create_time'=>'desc'));
        }
        if(empty($page)){
            $page=1;
        }
        if(empty($size)){
            $size=10;
        }

        $config = array(
            "list_rows" => $size,
            "page" => $page
        );

	    $Estimate = new Estimate();

        $resultData=$Estimate->where($where)
            ->order(json_decode($order,true))
            ->field('id,bank,product_name,type,create_time,update_time')
            ->paginate($size,false,$config);

        if(!empty($resultData)){
            foreach ($resultData as $k => $v){
                $resultData[$k]['type_name'] = $this->type[$v['type']];
                $resultData[$k]['time'] = !empty($v['update_time'])?date("Y-m-d H:i:s",$v['update_time']):date("Y-m-d H:i:s",$v['create_time']);
            }
        }

        return $this->buildSuccess($resultData);
	}

	/**
     * 预估单设置详情--修改调用接口
     * @author   cavan
     *
	*/
	public function EstimateDetails(){
        $id = $this->request->post('id', '', 'trim');
        if(!$id){
            return $this->buildFailed("缺少参数id");
        }
        $Estimate = new Estimate();
        //主表信息
        $list = $Estimate->where("id",$id)
                         ->field("id,bank,bank_id,product_name,product_id,type,estimate_sheet,estimated_desc")
                         ->find();
        if(!empty($list)){
            $list['type_name'] = $this->type[$list['type']];
        }

        return $this->buildSuccess($list);
    }


    /**
     * 新增预估单设置
     * @author   cavan
     *
     * @parameter     bank_id                   银行id
     * @parameter     product_id                产品名称
     * @parameter     type                      收费对象
     * @parameter     estimate_sheet            收费方式
     * @parameter     estimated_desc                   报告模板id
     */
    public function save(){
        $id = $this->request->post('id', '', 'trim');
        $bank_id = $this->request->post('bank_id', '', 'trim');
        $product_id = $this->request->post('product_id', '', 'trim');
        $type = $this->request->post('type', '', 'trim');
        $estimate_sheet = $this->request->post('estimate_sheet', '', 'trim');
        $estimated_desc = $this->request->post('estimated_desc', '', 'trim');
        if (!$bank_id) {
            return $this->buildFailed("银行为必选项");
        }
        if (!$product_id) {
            return $this->buildFailed("产品为必选项");
        }
        if (!$type) {
            return $this->buildFailed("业务类型为必选项");
        }
        if (!$estimate_sheet) {
            return $this->buildFailed("预估单模板不能为空");
        }
        if (!$estimated_desc) {
            return $this->buildFailed("说明不能为空");
        }

        $Estimate = new Estimate();

        if (!$id){
            $return = $Estimate->where(['bank_id' => $bank_id, 'product_id' => $product_id, 'type' => $type])->value("id");
            if ($return) {
                return $this->buildFailed("该银行下此业务类型预估单模板已存在");
            }
        }else{
            $return = $Estimate->where("id","<>",$id)->where(['bank_id' => $bank_id, 'product_id' => $product_id, 'type' => $type])->value("id");
            if ($return) {
                return $this->buildFailed("该银行下此业务类型预估单模板已存在");
            }
        }

        $bank = Db::name("bank")->where("id",$bank_id)->value("name");
        $product_name = Db::name("product")->where("id",$product_id)->value("product_name");

        $insert_data['bank'] = $bank;
        $insert_data['bank_id'] = $bank_id;
        $insert_data['product_id'] = $product_id;
        $insert_data['product_name'] = $product_name;
        $insert_data['type'] = $type;
        $insert_data['estimate_sheet'] = $estimate_sheet;
        $insert_data['estimated_desc'] = $estimated_desc;
        if($id){
            $insert_data['update_time'] = time();
            $Estimate->where("id",$id)->update($insert_data);
        }else{
            $insert_data['create_time'] = time();
            $Estimate->insertGetId($insert_data);
        }
        return $this->buildSuccess([],"保存成功");
    }


}