<?php
// +----------------------------------------------------------------------
// | ThinkCMF [ WE CAN DO IT MORE SIMPLE ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2017 http://www.thinkcmf.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: wuwu <15093565100@163.com>
// +----------------------------------------------------------------------
namespace api\portal\controller;

use api\portal\model\UserNeedModel;
use api\portal\model\PortalPostModel;
use cmf\controller\RestBaseController;
use think\Db;
use think\Request;
use think\Loader;
use think\Config;
use think\captcha\Captcha;
use think\Url;
use SmsDemo;
//use think\Route;
/**
 * @title 用户需求接口
 * @description 接口说明
 * @group 接口分组
 */

class UserneedController extends CommonController
{
    protected $postModel;
    public function __construct(PortalPostModel $postModel)
    {
        parent::__construct();
        $this->postModel = $postModel;
    }

    /**
     * @title  用户发布需求时保证金金额（填完地区，小区调用；每次修改重新调用）(sure)
     * @description 接口说明
     * @author 开发者
     * @url /api/portal/UserNeed/payMoney
     * @method POST
     * @param name:token type:varchar require:1 default: other: desc:token
     * @param name:city type:int require:1 default: other: desc:地区
     * @param name:area type:int require:1 default: other: desc:面积
     */
    public function payMoney(Request $request){
        $data = $request->param();
        if(!$data['city'] || !$data['area'] ){
            $this->apiResponse('0','城市、面积不能为空');
        }
//            保证金
            $city = $data['city'];
            $area = $data['area'];
//        查询地区
            $count_where = 0;
            $where_area['id'] = 1;
            $city_name = Db::name('MoneyRule')->where($where_area)->field('city_name')->find();
            $findcity_arr = explode('、',$city_name['city_name']);
            foreach ($findcity_arr as $fca_k=>$fca_v){
                if(strpos($city,$fca_v) !== false){
                    $count_where = 1;
                    $where_money['city_name'] = array('like',"%".$fca_v.'%');
                }else{
                    $count_where += 0;
                }
            }
            if($count_where == 0){
                $where_money['type'] = 2;
            }else{
                $where_money['type'] = 1;
            }
            $where_money['status'] = 1;
            $where_money['low_area'] = array('lt',$area);
            $where_money['height_area'] = array('egt',$area);
            $money = Db::name('MoneyRule')->where($where_money)->field('money')->find();
            if($money){
                $final['pay_money'] = $money['money'];
                $this->apiResponse('1','成功',$final);
            }else{
                $this->apiResponse('0','保证金获取失败');
            }
    }

    /**
     * @title  用户发布需求验证(sure)
     * @description 接口说明
     * @author 开发者
     * @url /api/portal/UserNeed/judge
     * @method POST
     * @param name:name type:varchar require:1 default: other: desc:联系人姓名
     * @param name:tel type:varchar require:1 default: other: desc:联系人电话
     * @param name:code type:int require:1 default: other: desc:验证码
     * @param name:token type:varchar require:1 default: other: desc:token
     * @return data:''
     */
    public function judge(Request $request){
        $data = $request->param();
        if(empty($data['name'])){
            $this->apiResponse('0','联系人姓名不能为空');
        }
        if(empty($data['tel'])){
            $this->apiResponse('0','联系人电话不能为空');
        }

        if(empty($data['code'])){
            $this->apiResponse('0','验证码不能为空');
        }else{
            $code = $data['code'];
        }
        $where_code['tel'] = $data['tel'];
        $where_code['type'] = 3;
        $where_code['status'] = 1;
        $where_code['create_time'] = array('egt',(time()-300));
        $find_code = Db::name('Code')->where($where_code)->order('create_time')->field('code')->find();
        if(!$find_code){
            $this->apiResponse('0','验证码错误,请重新获取');
        }
        if($code != $find_code['code']){
            $this->apiResponse('0','验证码错误,请重新获取');
        }else{
            $updateCode['status'] = 9;
            Db::name('Code')->where($where_code)->update($updateCode);
            $this->apiResponse('1','成功');
        }
    }

    /**
     * @title  用户发布需求中间层(sure)
     * @description 接口说明
     * @author 开发者
     * @url /api/portal/UserNeed/sendMiddle
     * @method POST
     * @param name:city type:varchar require:1 default: other: desc:地区（省-市-区）
     * @param name:quarters type:varchar require:1 default: other: desc:小区
     * @param name:room type:varchar require:1 default: other: desc:具体房号（1-1-1）
     * @param name:floor type:int require:1 default: other: desc:楼层
     * @param name:house_type type:varchar require:1 default: other: desc:户型
     * @param name:renovation type:varchar require:1 default: other: desc:装修
     * @param name:area type:varchar require:1 default: other: desc:建筑面积
     * @param name:is_first type:tinyint require:1 default: other: desc:是否首套房（1->首套房，2->两套及以上）
     * @param name:loan type:tinyint require:1 default: other: desc:贷款(1->贷款，2->全款)
     * @param name:contract type:tinyint require:1 default: other: desc:是否是包干价（1->是，2->否）
     * @param name:quotation_time type:int require:1 default: other: desc:报价时间
     * @param name:name type:varchar require:1 default: other: desc:联系人姓名
     * @param name:tel type:varchar require:1 default: other: desc:联系人电话
     * @param name:code type:int require:1 default: other: desc:验证码
     * @param name:gener type:int require:1 default: other: desc:类型(1->PC，2->手机)
     * @param name:else type:int require:1 default: other: desc:备注
     * @param name:token type:varchar require:1 default: other: desc:token
     * @return data:''@
     * @data type:'1->包干价，2->问答'
     * @data need_id:'需求id'
     */
    public function sendMiddle(Request $request)
    {
        Db::startTrans();
        if($request->Post('token') && $request->Post('area')){
//                $data = $request->param();
//            判空，处理
            $validate = Loader::validate('UserNeed');
            if(!$validate->check($_POST)){
                $this->apiResponse('0',$validate->getError());
            }
//            加数据库
            $data = $request->Post();
//                省市区不能为空判断
            $num = 0;
            if(empty($data['city'])){
                $this->apiResponse('0','城市不能为空');
            }else{
                $expFirst = explode('-',$data['city']);
                if(count($expFirst) < 3){
                    $this->apiResponse('0','省市区不能为空');
                }else{
                    foreach ($expFirst as $ek=>$ev){
                        if(empty($ev)){
                            $num +=1;
                        }else{
                            $num +=0;
                        }
                    }
                    if($num >0){
                        $this->apiResponse('0','省市区不能为空');
                    }
                }
            }
//                验证码判断
            if(empty($data['gener'])){
                $this->apiResponse('0','请传类型');
            }else{
                if($data['gener'] == 2){
                    if(empty($data['code'])){
                        Db::rollback();
                        $this->apiResponse('0','验证码不能为空');
                    }else{
                        $code = $data['code'];
                    }
                    $where_code['tel'] = $data['tel'];
                    $where_code['type'] = 3;
                    $where_code['status'] = 1;
                    $where_code['create_time'] = array('egt',(time()-300));
                    $find_code = Db::name('Code')->where($where_code)->order('create_time')->field('code')->find();
                    if(!$find_code){
                        Db::rollback();
                        $this->apiResponse('0','验证码错误,请重新获取');
                    }
                    if($code != $find_code['code']){
                        Db::rollback();
                        $this->apiResponse('0','验证码错误,请重新获取');
                    }else{
                        $updateCode['status'] = 9;
                        Db::name('Code')->where($where_code)->update($updateCode);
                    }
                }
            }

//            保证金
            $city = $data['city'];
            $area = $data['area'];
//        查询地区
            $count_where = 0;
            $where_area['id'] = 1;
            $city_name = Db::name('MoneyRule')->where($where_area)->field('city_name')->find();
            $findcity_arr = explode('、',$city_name['city_name']);
            foreach ($findcity_arr as $fca_k=>$fca_v){
                if(strpos($city,$fca_v) !== false){
                    $count_where = 1;
                    $where_money['city_name'] = array('like',"%".$fca_v.'%');
                }else{
                    $count_where += 0;
                }
            }
            if($count_where == 0){
                $where_money['type'] = 2;
            }else{
                $where_money['type'] = 1;
            }
            $where_money['status'] = 1;
            $where_money['low_area'] = array('lt',$area);
            $where_money['height_area'] = array('egt',$area);
            $money = Db::name('MoneyRule')->where($where_money)->field('money')->find();
            if($money){
                $data['pay_money'] = $money['money'];
            }else{
                Db::rollback();
                $this->apiResponse('0','保证金获取失败');
            }
            $where_mem['token'] = $data['token'];
            $mem_id = Db::name('Member')->where($where_mem)->field('id')->find();
            $data['user_id'] = $mem_id['id'];
            $model = new UserNeedModel();
//                    添加
            if($data['gener'] == 2){
                unset($data['code']);
            }
            unset($data['gener']);
            unset($data['connect']);
            unset($data['token']);
            $data['status'] = 15;
            $save = $model->save($data);

            if($save){
                $final['userNeed_id'] = $model->getLastInsID();
                $final['money'] = $data['pay_money'];
                Db::commit();
                $this->apiResponse('1','添加成功',$final);
            }else{
                Db::rollback();
                $this->apiResponse('0','添加失败');
            }
        }else{

//            问答内容
            $where_pro['status'] = 1;
            $list = Db::name('NeedAnswer')->where($where_pro)->order("update_time desc")->field("title,content,id,type")->select()->toArray();
            foreach ($list as $lk=>$lv){
                $list[$lk]['content'] = htmlspecialchars_decode($lv['content']);
            }
            if($list){
                $final['answer'] = $list;
                $this->apiResponse('1','成功',$final);
            }else{
                $this->apiResponse('0','暂无内容');
            }

        }
    }

    /**
     * @title  用户发布需求查询(sure)
     * @description 接口说明
     * @author 开发者
     * @url /api/portal/UserNeed/findSend
     * @method POST
     * @param name:middle_id type:varchar require:1 default: other: desc:需求id
     * @param name:token type:varchar require:1 default: other: desc:token
     * @return data:''
     */
    public function findSend(){
        $data = $this->request->param();
        $where_token['token'] = $data['token'];
        $where_token['status'] = array('neq',9);
        $member = Db::name('Member')->where($where_token)->field('id')->find();
        $where_middle['id'] = $data['middle_id'];
        $where_middle['status'] = 15;
        $where_middle['user_id'] = $member['id'];
        $is_middle = Db::name('UserNeed')->where($where_middle)->find();
        if($is_middle){
            $this->apiResponse('1','成功',$is_middle);
        }else{
            $this->apiResponse('0','需求错误');
        }
    }

    /**
     * @title  用户发布需求(sure)
     * @description 接口说明
     * @author 开发者
     * @url /api/portal/UserNeed/send
     * @method POST
     * @param name:middle_id type:varchar require:1 default: other:确认页面后传，只传此值即可 desc:需求id
     * @param name:city type:varchar require:1 default: other: desc:地区（省-市-区）
     * @param name:quarters type:varchar require:1 default: other: desc:小区
     * @param name:room type:varchar require:1 default: other: desc:具体房号（1-1-1）
     * @param name:floor type:int require:1 default: other: desc:楼层
     * @param name:house_type type:varchar require:1 default: other: desc:户型
     * @param name:renovation type:varchar require:1 default: other: desc:装修
     * @param name:area type:varchar require:1 default: other: desc:建筑面积
     * @param name:is_first type:tinyint require:1 default: other: desc:是否首套房（1->首套房，2->两套及以上）
     * @param name:loan type:tinyint require:1 default: other: desc:贷款(1->贷款，2->全款)
     * @param name:contract type:tinyint require:1 default: other: desc:是否是包干价（1->是，2->否）
     * @param name:quotation_time type:int require:1 default: other: desc:报价时间
     * @param name:name type:varchar require:1 default: other: desc:联系人姓名
     * @param name:tel type:varchar require:1 default: other: desc:联系人电话
     * @param name:code type:int require:1 default: other: desc:验证码
     * @param name:gener type:int require:1 default: other: desc:类型(1->PC，2->手机)
     * @param name:else type:int require:1 default: other: desc:备注
     * @param name:token type:varchar require:1 default: other: desc:token
     * @return data:''@
     * @data type:'1->包干价，2->问答'
     * @data need_id:'需求id'
     */
    public function send(Request $request)
    {
        Db::startTrans();

        $data = $request->Post();
        if((!empty($data['token']) && !empty($data['area'])) || !empty($data['middle_id'])){

            if(empty($data['middle_id'])){
                //            判空，处理
                $validate = Loader::validate('UserNeed');
                if(!$validate->check($_POST)){
                    $this->apiResponse('0',$validate->getError());
                }
//            加数据库

//                省市区不能为空判断
                $num = 0;
                if(empty($data['city'])){
                    $this->apiResponse('0','城市不能为空');
                }else{
                    $expFirst = explode('-',$data['city']);
                    if(count($expFirst) < 3){
                        $this->apiResponse('0','省市区不能为空');
                    }else{
                        foreach ($expFirst as $ek=>$ev){
                            if(empty($ev)){
                                $num +=1;
                            }else{
                                $num +=0;
                            }
                        }
                        if($num >0){
                            $this->apiResponse('0','省市区不能为空');
                        }
                    }
                }
//                验证码判断
                if(empty($data['gener'])){
                    $this->apiResponse('0','请传类型');
                }else{
                    if($data['gener'] == 2){
                        if(empty($data['code'])){
                            Db::rollback();
                            $this->apiResponse('0','验证码不能为空');
                        }else{
                            $code = $data['code'];
                        }
                        $where_code['tel'] = $data['tel'];
                        $where_code['type'] = 3;
                        $where_code['status'] = 1;
                        $where_code['create_time'] = array('egt',(time()-300));
                        $find_code = Db::name('Code')->where($where_code)->order('create_time')->field('code')->find();

                        if(!$find_code){
                            Db::rollback();
                            $this->apiResponse('0','验证码错误,请重新获取');
                        }
                        if($code != $find_code['code']){
                            Db::rollback();
                            $this->apiResponse('0','验证码错误,请重新获取');
                        }else{
                            $updateCode['status'] = 9;
                            Db::name('Code')->where($where_code)->update($updateCode);
                        }
                    }
                }


//            保证金
                $city = $data['city'];
                $area = $data['area'];
//        查询地区
                $count_where = 0;
                $where_area['id'] = 1;
                $city_name = Db::name('MoneyRule')->where($where_area)->field('city_name')->find();
                $findcity_arr = explode('、',$city_name['city_name']);
                foreach ($findcity_arr as $fca_k=>$fca_v){
                    if(strpos($city,$fca_v) !== false){
                        $count_where = 1;
                        $where_money['city_name'] = array('like',"%".$fca_v.'%');
                    }else{
                        $count_where += 0;
                    }
                }
                if($count_where == 0){
                    $where_money['type'] = 2;
                }else{
                    $where_money['type'] = 1;
                }
                $where_money['status'] = 1;
                $where_money['low_area'] = array('lt',$area);
                $where_money['height_area'] = array('egt',$area);
                $money = Db::name('MoneyRule')->where($where_money)->field('money')->find();
                if($money){
                    $data['pay_money'] = $money['money'];
                }else{
                    Db::rollback();
                    $this->apiResponse('0','保证金获取失败');
                }
                $where_mem['token'] = $data['token'];
                $mem_id = Db::name('Member')->where($where_mem)->field('id')->find();
                $data['user_id'] = $mem_id['id'];
                $model = new UserNeedModel();
//                    添加
                if($data['gener'] == 2){
                    unset($data['code']);
                }
                unset($data['gener']);
                unset($data['connect']);
                unset($data['token']);
                $save = $model->save($data);

                if($save){
                    $final['userNeed_id'] = $model->getLastInsID();
                    $final['money'] = $data['pay_money'];
                    Db::commit();
                    $this->apiResponse('1','添加成功',$final);
                }else{
                    Db::rollback();
                    $this->apiResponse('0','添加失败1');
                }
            }else{
                $where_middle['id'] = $data['middle_id'];
                $where_middle['status'] = 15;
                $is_middle = Db::name('UserNeed')->where($where_middle)->find();
                if($is_middle){
                    $update_middle['status'] = 1;
                    $update_middle['update_time'] = time();
                    $update = Db::name('UserNeed')->where($where_middle)->update($update_middle);
                    if($update){
                        Db::commit();
                        $final['userNeed_id'] = $data['middle_id'];
                        $final['money'] = $is_middle['pay_money'];
                        $this->apiResponse('1','添加成功',$final);
                    }else{
                        Db::rollback();
                        $this->apiResponse('0','添加失败2');
                    }
                }else{
                    Db::rollback();
                    $this->apiResponse('0','添加失败3');
                }
            }
        }else{

//            问答内容
            $where_pro['status'] = 1;
            $list = Db::name('NeedAnswer')->where($where_pro)->order("update_time desc")->field("title,content,id,type")->select()->toArray();
            foreach ($list as $lk=>$lv){
                $list[$lk]['content'] = htmlspecialchars_decode($lv['content']);
            }
            if($list){
                $final['answer'] = $list;
                $this->apiResponse('1','成功',$final);
            }else{
                $this->apiResponse('0','暂无内容');
            }


        }
    }
    /**
     * @title  用户修改需求(sure)
     * @description 接口说明
     * @author 开发者
     * @url /api/portal/UserNeed/changesend
     * @method POST
     * @param name:city type:varchar require:1 default: other: desc:地区（省-市-区）
     * @param name:quarters type:varchar require:1 default: other: desc:小区
     * @param name:room type:varchar require:1 default: other: desc:具体房号（1-1-1）
     * @param name:floor type:int require:1 default: other: desc:楼层
     * @param name:house_type type:varchar require:1 default: other: desc:户型
     * @param name:renovation type:varchar require:1 default: other: desc:装修
     * @param name:area type:varchar require:1 default: other: desc:建筑面积
     * @param name:is_first type:tinyint require:1 default: other: desc:是否首套房（1->首套房，2->两套及以上）
     * @param name:loan type:tinyint require:1 default: other: desc:贷款(1->贷款，2->全款)
     * @param name:contract type:tinyint require:1 default: other: desc:是否是包干价（1->是，2->否）
     * @param name:quotation_time type:int require:1 default: other: desc:报价时间
     * @param name:name type:varchar require:1 default: other: desc:联系人姓名
     * @param name:tel type:varchar require:1 default: other: desc:联系人电话
     * @param name:code type:int require:1 default: other: desc:验证码
     * @param name:else type:int require:1 default: other: desc:备注
     * @param name:need_id type:int require:1 default: other:修改需求时传 desc:需求id
     * @param name:token type:varchar require:1 default: other: desc:token
     * @return data:''@
     * @data type:'1->包干价，2->问答'
     * @data need_id:'需求id'
     */
    public function changeSend(Request $request)
    {
        if($request->Post('token') && $request->Post('name')){
//                $data = $request->param();
//            判空，处理
                $validate = Loader::validate('UserNeed');
                if(!$validate->check($_POST)){
                    return json(array('code'=>0,'msg'=>$validate->getError()));
                }
//            加数据库
                $data = $request->Post();
            if(empty($data['code'])){

                $this->apiResponse('0','验证码不能为空');
            }else{
                $code = $data['code'];
            }
            $where_code['tel'] = $data['tel'];
            $where_code['type'] = 3;
            $where_code['status'] = 1;
            $where_code['create_time'] = array('egt',(time()-300));
            $find_code = Db::name('Code')->where($where_code)->order('create_time ')->field('code')->find();
            if(!$find_code){

                $this->apiResponse('0','验证码错误,请重新获取');
            }
            if($code != $find_code['code']){

                $this->apiResponse('0','验证码错误,请重新获取');
            }else{
                $updateCode['status'] = 9;
                Db::name('Code')->where($where_code)->update($updateCode);
            }

//            保证金
                $city = $data['city'];
                $area = $data['area'];
//            查询地区
                $where_area['area_name'] = array('like',"%$city%");
                $city_id = Db::name('Areas')->where($where_area)->field('area_id')->find();
                $where_money['city'] = array('like',"%".$city_id['area_id'].'%');
                $where_money['status'] = 1;
                $where_money['low_area'] = array('lt',$area);
                $where_money['height_area'] = array('egt',$area);
                $money = Db::name('MoneyRule')->where($where_money)->field('money')->find();
                if(!$money){
                    $where_elsemoney['city'] = 0;
                    $where_elsemoney['status'] = 1;
                    $where_elsemoney['low_area'] = array('lt',$area);
                    $where_elsemoney['height_area'] = array('egt',$area);
                    $elsemoney = Db::name('MoneyRule')->where($where_elsemoney)->field('money')->find();
                    if($elsemoney){
                        $data['pay_money'] = $elsemoney['money'];
                    }else{
                        $this->apiResponse('0','保证金获取失败');
                    }
                }else{
                    $data['pay_money'] = $money['money'];
                }
                $where_mem['token'] = $data['token'];
                $mem_id = Db::name('Member')->where($where_mem)->field('id')->find();
                $data['user_id'] = $mem_id['id'];
                $model = new UserNeedModel();

//                    修改
                    $where_need['id'] = $request->param('need_id');
                    $where_need['status'] = array('in','1,2');
                    $need = Db::name('UserNeed')->where($where_need)->find();
                    if(!$need){
                        $this->apiResponse('0','该需求不可修改');
                    }else{
                        unset($data['code']);
                        unset($data['connect']);
                        unset($data['token']);
                        $data['id'] = $data['need_id'];
                        if($need['status'] == 2){
                            unset($data['pay_money']);
                        }
                        $save = $model->isUpdate(true)->allowField(true)->save($data);
                    }
                if($save){
                    $final['need_id'] = $model->id;
                    $this->apiResponse('1','修改成功',$final);
                }else{
                    $this->apiResponse('0','修改失败');
                }


        }else{
            $data = $request->param();
            if(empty($data['need_id'])){
                $this->apiResponse('0','需求id不可為空');
            }
            $where_need['id'] = $request->param('need_id');
            $where_need['status'] = array('in','1,2');;
            $where_mem['token'] = $data['token'];
            $mem_id = Db::name('Member')->where($where_mem)->field('id')->find();
            $where_need['user_id'] = $mem_id['id'];
            $list['need'] = Db::name('UserNeed')->where($where_need)->find();
            if(!$list['need']){
                $this->apiResponse('0','该需求不可修改');
            }
//            问答内容
            $where_pro['status'] = 1;
            $answer = Db::name('NeedAnswer')->where($where_pro)->order("update_time desc")->field("title,content,id,type")->select()->toArray();
            foreach ($answer as $lk=>$lv){
                $answer[$lk]['content'] = htmlspecialchars_decode($lv['content']);
            }
            $list['answer'] = $answer;
            if($list){

                $this->apiResponse('1','成功',$list);
            }else{
                $this->apiResponse('0','暂无内容');
            }
        }
    }










}