phpstock/app/admin/controller/Consult.php

<?php

namespace app\admin\controller;

use app\BaseController;
use think\App;
use think\facade\Db;

class Consult extends BaseController
{
    public $post = "";
    public function __construct(App $app)
    {
        parent::__construct($app);
        $this->post=$this->request->post();
        $token = isset($this->post['token']) ? trim($this->post['token']) : "";
        if($token==""){
            return error_show(101,'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if(!empty($effetc) && $effetc['code']!=0) {
            return error_show($effetc['code'], $effetc['message']);
        }
    }
    public function list(){
      $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) :"1";
      $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) :"10";
      $where=[['is_del',"=",0],["cat_id","<>",0]];
      $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
      if ($zxNo !== "") {
          $where[] = ['zxNo','=',$zxNo];
      }
      $sequenceNo = isset($this->post['sequenceNo']) && $this->post['sequenceNo'] !== "" ? trim($this->post['sequenceNo']) : "";
      if ($sequenceNo !== "") {
            $where[] = ['sequenceNo','like',"%$sequenceNo%"];
        }
      $salesman = isset($this->post['salesman']) && $this->post['salesman'] !== "" ? trim($this->post['salesman']) : "";
      if ($salesman !== "") {
          //$where["salesman"] =Db::Raw("like '%$salesman%'");
          $where[]= ["salesman",'like',"%$salesman%"];
        }
        $cpName = isset($this->post['cpName']) && $this->post['cpName'] !== "" ? trim($this->post['cpName']) : "";
        if ($cpName !== "") {
            //$where["cpName"]= Db::Raw("like '%$cpName%'");
            $where[]= ["cpName",'like',"%$cpName%"];
        }
      $khNo = isset($this->post['khNo']) && $this->post['khNo'] !== "" ? trim($this->post['khNo']) : "";
      if ($khNo !== "") {
         // $where['khNo'] = $khNo;
          $where[]= ["khNo",'like',"%$khNo%"];
        }
        $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
        if ($start !="") {
            //$where = ["zxtime"=>Db::raw(">= '{$start}'")];
            $where[]= ["zxtime",'>=',$start];
        }
        $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
        if($end !=""){
            $where[]= ["zxtime",'<=',$end];
        }
      $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
      if ($status !== "") {
          $where[]= ["status",'=',$status];
        }
        $count = Db::name('consult')->where($where)->count();
        $total = ceil($count / $size);
        $page = $page >= $total ? $total : $page;
      $list = Db::name('consult')->where($where)->page($page,$size)
          ->select();
     $data=[];
      foreach ($list as $value){
          $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
          $data[]=$value;
      }
      return app_show(0,"获取成功",['count'=>$count,'list'=>$data]);
    }
    public function info(){
        $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) : "";
        if($id==""){
            return error_show(1002,"咨询单编号不能为空");
        }
        $fo = Db::name('consult')->where(['id'=>$id,'is_del'=>0])->find();
        $in= isset($fo['cat_id']) && $fo['cat_id'] !=0 ? made($fo['cat_id']):[];
        $fo['can']=$in;
        if(empty($fo)){
            return error_show(1002,"未找到咨询单编号");
        }else{
            return app_show(0,"获取成功",$fo);
        }
    }
    public function del(){
        $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) : "";
        $de = Db::name('consult')->where(['id'=>$id,'is_del'=>0])->find();
        if($de==false){
            return error_show(1002,'咨询单编号未找到');
        }
        $dell= Db::name('consult')->update(['id'=>$id,'is_del'=>1,'updatetime'=>date("Y-m-d H:i:s")]);
        if($dell){
            return error_show(0,"删除成功");
        }else
            return error_show(1002,"删除失败");
    }

    public function create(){
        $is_project= isset($this->post['is_project']) && $this->post['is_project'] !=="" ? intval($this->post['is_project']) : "";
        if($is_project===""){
            return error_show(1002,"参数is_project不能为空");
        }

        if($is_project==1){
            $projectNo= isset($this->post['projectNo']) && $this->post['projectNo'] !=="" ? trim($this->post['projectNo']) : "";
            if($projectNo===""){
                return error_show(1002,"参数projectNo不能为空");
            }
        }
        $khNo =  isset($this->post['khNo']) && $this->post['khNo'] !=="" ? trim($this->post['khNo']) : "";
        if($khNo===""){
            return error_show(1002,"参数khNo不能为空");
        }
        $endtime =  isset($this->post['endtime']) && $this->post['endtime'] !=="" ? $this->post['endtime'] : "";
        if($endtime===""){
            return error_show(1002,"参数endtime不能为空");
        }
        $saleid =  isset($this->post['saleid']) && $this->post['saleid'] !=="" ? intval($this->post['saleid']) : "";
        if($saleid===""){
            return error_show(1002,"参数saleid不能为空");
        }
        $depart =  isset($this->post['depart']) && $this->post['depart'] !=="" ? intval($this->post['depart']) : "";
        if($depart===""){
            return error_show(1002,"参数depart不能为空");
        }
        $platform_code =  isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code']) :
            "";
        if($platform_code===""){
            return error_show(1002,"参数platform_code不能为空");
        }
        $zxNo=makeNo("ZX");
        $data=[
            "zxNo"=>$zxNo,
            "createrid"=>0,
            "creater"=>"",
            "is_project"=>$is_project,
            "projectNo"=>isset($projectNo) ? $projectNo:"",
            "khNo"=>$khNo,
            "endtime"=>$endtime,
            "salesman"=>"",
            "platform_code"=>$platform_code,
            "saleid"=>$saleid,
            "depart"=>$depart,
            "status"=>0,
            "is_del"=>0,
            "addtime"=>date("Y-m-d H:i:s"),
            "updatetime"=>date("Y-m-d H:i:s"),
        ];
        $zx = Db::name("consult_order")->insert($data);
        if($zx){
            return  app_show(0,"新建成功",["zxNo"=>$zxNo]);
        }else{
            return error_show(1004,"新建失败");
        }
    }

    public function zxadd(){
        $good_name = isset($this->post['good_name'])&&$this->post['good_name']!==""?trim($this->post['good_name']):"";
        if($good_name===""){
            return error_show(1004,"参数good_name不能为空");
        }
        $zxNo = isset($this->post['zxNo'])&&$this->post['zxNo']!==""?trim($this->post['zxNo']):"";
        if($zxNo===""){
            return error_show(1004,"参数zxNo不能为空");
        }

        $cat_id = isset($this->post['cat_id'])&&$this->post['cat_id']!==""?intval($this->post['cat_id']):"";
        if($cat_id===""){
            return error_show(1004,"参数cat_id不能为空");
        }
        $arrival_time = isset($this->post['arrival_time'])&&$this->post['arrival_time']!==""?$this->post['arrival_time']
            :"";
        if($arrival_time===""){
            return error_show(1004,"参数arrival_time不能为空");
        }
        $good_img = isset($this->post['good_img'])&&$this->post['good_img']!==""?trim($this->post['good_img']):"";
        if($good_img===""){
            return error_show(1004,"参数good_img不能为空");
        }
        $is_custom = isset($this->post['is_custom'])&&$this->post['is_custom']!==""?intval($this->post['is_custom']):"";
        if($is_custom===""){
            return error_show(1004,"参数is_custom不能为空");
        }
        $unit = isset($this->post['unit'])&&$this->post['unit']!==""?trim($this->post['unit']):"";
        if($unit===""){
            return error_show(1004,"参数unit不能为空");
        }
        $brand_id = isset($this->post['brand_id'])&&$this->post['brand_id']!==""?intval($this->post['brand_id']):"";
        if($brand_id===""){
            return error_show(1004,"参数brand_id不能为空");
        }
        $material = isset($this->post['material'])&&$this->post['material']!==""?trim($this->post['material']):"";
        if($material===""){
            return error_show(1004,"参数material不能为空");
        }
        $color = isset($this->post['color'])&&$this->post['color']!==""?trim($this->post['color']):"";
        if($color===""){
            return error_show(1004,"参数color不能为空");
        }
        $cost_desc = isset($this->post['cost_desc'])&&$this->post['cost_desc']!==""?trim($this->post['cost_desc']):"";
        if($cost_desc===""){
            return error_show(1004,"参数cost_desc不能为空");
        }
        $model = isset($this->post['model'])&&$this->post['model']!==""?trim($this->post['model']):"";
        if($model===""){
            return error_show(1004,"参数model不能为空");
        }

        $is_addrs = isset($this->post['is_addrs'])&&$this->post['is_addrs']!==""?intval($this->post['is_addrs']):"";
        if($is_addrs===""){
            return error_show(1004,"参数is_addrs不能为空");
        }

        $metal_id = isset($this->post['metal_id'])&&$this->post['metal_id']!==""?trim($this->post['metal_id']):"";
        if($metal_id===""){
            return error_show(1004,"参数metal_id不能为空");
        }
        if($metal_id==0){
            $config = isset($this->post['config'])&&!empty($this->post['config'])?$this->post['config']:"";
            if($config===""){
                return error_show(1004,"参数config不能为空");
            }
            $other_config = isset($this->post['other_config'])&&$this->post['other_config']!==""?trim($this->post['other_config'])
                :"";
            if($other_config===""){
                return error_show(1004,"参数other_config不能为空");
            }
            $specs_weight = isset($this->post['specs_weight'])&&$this->post['specs_weight']!==""?floatval($this->post['specs_weight']):"";
            if($specs_weight===""){
                return error_show(1004,"参数specs_weight不能为空");
            }
            $gold_price = isset($this->post['gold_price'])&&$this->post['gold_price']!==""?floatval($this->post['gold_price']):"";
            if($gold_price===""){
                return error_show(1004,"参数gold_price不能为空");
            }
            $budget_price = isset($this->post['budget_price'])&&$this->post['budget_price']!==""?floatval($this->post['budget_price']):"";
            if($budget_price===""){
                return error_show(1004,"参数budget_price不能为空");
            }
        }

        $num = isset($this->post['num'])&&$this->post['num']!==""?intval($this->post['num']):"";
        if($num===""){
            return error_show(1004,"参数num不能为空");
        }
        $use_desc = isset($this->post['use_desc'])&&$this->post['use_desc']!==""?trim($this->post['use_desc']):"";
        if($use_desc===""){
            return error_show(1004,"参数use_desc不能为空");
        }
        $remark = isset($this->post['remark'])&&$this->post['remark']!==""?trim($this->post['remark']):"";
        if($remark===""){
            return error_show(1004,"参数remark不能为空");
        }

        Db::startTrans();
        try{
                $infoNo=makeNo("INF");
                $info=[
                    "infoNo"=>$infoNo,
                    "zxNo"=>$zxNo,
                    "spuCode"=>"",
                    "good_name"=>$good_name,
                    "good_img"=>$good_img,
                    "cat_id"=>$cat_id,
                    "unit"=>$unit,
                    "brand_id"=>$brand_id,
                    "arrival_time"=>$arrival_time,
                    "model"=>$model,
                    "color"=>$color,
                    "material"=>$material,
                    "cost_desc"=>$cost_desc,
                    "is_addrs"=>$is_addrs,
                    "is_custom"=>$is_custom,
                    "metal_id"=>$metal_id,
                    "config"=>isset($config)?$config:"",
                    "other_config"=>isset($other_config)?$other_config:"",
                    "specs_weight"=>isset($specs_weight)?$specs_weight:0,
                    "gold_price"=>isset($gold_price)?$gold_price:0,
                    "budget_price"=>$budget_price,
                    "num"=>$num,
                    "use_desc"=>$use_desc,
                    "remark"=>$remark,
                    "status"=>0,
                    "is_del"=>0,
                    "addtime"=>date("Y-m-d H:i:s"),
                    "updatetime"=>date("Y-m-d H:i:s")
                ];
                $up = Db::name("consult_info")->insert($info);
                if($up){
                    Db::commit();
                    return app_show(0,"添加成功",["infoNo"=>$infoNo]);
                }else{
                    Db::rollback();
                    return error_show(1004,'添加失败');
                }
        }catch (\Exception $e){
            Db::rollback();
            return error_show(1004,$e->getMessage());
        }
    }

    public function zxinfo(){
        $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
        if($infoNo==""){
            return error_show(1004,"参数infoNo不能为空");
        }
        $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
        if($zxinfo==false){
            return error_show(1004,"未找到信息数据");
        }
        $zxorder = Db::name("consilt_order")->where(["zxNo"=>$zxinfo['zxNo'],"is_del"=>0])->find();
        if($zxorder==false){
            return error_show(1004,"未找到咨询信息数据");
        }
        $zxorder['khname']="";
        if($zxorder['khNo']!==""){
            $kh=Db::name("customer_info")->where(['companyNo'=>$zxorder['khNo']])->find();
            $zxorder['khname']= isset($kh['companyName'])?$kh['companyName']:"";
        }
        return app_show(0,"获取成功",$zxinfo);
    }
    //** 发布竞标任务 */
    public function  bargain(){
        $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
        if($infoNo==""){
            return error_show(1004,"参数infoNo不能为空");
        }
        $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
        if($zxinfo==false){
            return error_show(1004,"未找到信息数据");
        }
        $status =isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
        if($status===""){
            return error_show(1004,"参数status不能为空");
        }
        if($status==1&&$zxinfo['status']>1){
            $zxinfo['bargain_num']=+1;
        }
        $zxinfo['status']=$status;
        $zxinfo['updatetime']=date("Y-m-d H:i:s");
        $up = Db::name("consult_info")->save($zxinfo);
        if($up){
            return app_show(0,"状态更新成功");
        }else{
            return error_show(1003,"状态更新失败");
        }
    }

    public function feadback(){
        $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
        if($infoNo==""){
            return error_show(1004,"参数infoNo不能为空");
        }
        $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
        if($zxinfo==false){
            return error_show(1004,"未找到信息数据");
        }

        $pname = isset($this->post['pname'])&&$this->post['pname']!=""? trim($this->post['pname']):"";
        if($pname==""){
            return error_show(1004,"参数pname不能为空");
        }
        $brandid = isset($this->post['brandid'])&&$this->post['brandid']!=""? intval($this->post['brandid']):"";
        if($brandid==""){
            return error_show(1004,"参数brandid不能为空");
        }
        $cat_id = isset($this->post['cat_id'])&&$this->post['cat_id']!=""? trim($this->post['cat_id']):"";
        if($cat_id==""){
            return error_show(1004,"参数cat_id不能为空");
        }
        $model = isset($this->post['model'])&&$this->post['model']!=""? trim($this->post['model']):"";
        //$unit = isset($this->post['model'])&&$this->post['model']!=""? trim($this->post['model']):"";
        $material = isset($this->post['material'])&&$this->post['material']!=""? trim($this->post['material']):"";
        $unit_id = isset($this->post['unit_id'])&&$this->post['unit_id']!=""? intval($this->post['unit_id']):"";
        $cost_desc = isset($this->post['cost_desc'])&&$this->post['cost_desc']!=""? trim($this->post['cost_desc']):"";
        $work_day = isset($this->post['work_day'])&&$this->post['work_day']!=""? intval($this->post['work_day']):"";
        $delivery_day = isset($this->post['delivery_day'])&&$this->post['delivery_day']!=""? intval($this->post['delivery_day']):"";
        $good_img = isset($this->post['good_img'])&&$this->post['good_img']!=""? trim($this->post['good_img']):"";
        $expire_day = isset($this->post['expire_day'])&&$this->post['expire_day']!=""? intval($this->post['expire_day'])
            :"";
        $origin_place = isset($this->post['origin_place'])&&$this->post['origin_place']!=""? trim($this->post['origin_place']):"";
        $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!=""? trim($this->post['supplierNo']):"";
        $pay_way = isset($this->post['pay_way'])&&$this->post['pay_way']!=""? intval($this->post['pay_way']):"";
        $tax = isset($this->post['tax'])&&$this->post['tax']!=""? trim($this->post['tax']):"";
        $send_way = isset($this->post['send_way'])&&$this->post['send_way']!=""? intval($this->post['send_way']):"";
        $metal_id = isset($this->post['metal_id'])&&$this->post['metal_id']!=""? intval($this->post['metal_id']):"";
        $is_gold_price = isset($this->post['is_gold_price'])&&$this->post['is_gold_price']!=""? intval($this->post['is_gold_price']):"";
        $config = isset($this->post['config'])&&$this->post['config']!=""? $this->post['config']:"";
        $weight = isset($this->post['weight'])&&$this->post['weight']!=""? floatval($this->post['weight']):"";
        $demo_fee = isset($this->post['demo_fee'])&&$this->post['demo_fee']!=""? floatval($this->post['demo_fee']):"";
        $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!=""? floatval($this->post['delivery_fee']):"";
        $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!=""? floatval($this->post['open_fee']):"";
        $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!=""? floatval($this->post['pakge_fee']):"";
        $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!=""? floatval($this->post['nake_fee']):"";
        $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!=""? floatval($this->post['mark_fee']):"";
        $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!=""? floatval($this->post['cert_fee']):"";
        $cost_fee = isset($this->post['cost_fee'])&&$this->post['cost_fee']!=""? floatval($this->post['cost_fee']):"";
        $total_fee = isset($this->post['total_fee'])&&$this->post['total_fee']!=""? floatval($this->post['total_fee']):"";

        $is_diff = isset($this->post['is_diff'])&&$this->post['is_diff']!==""? intval($this->post['is_diff']):"";
        $supply_area = isset($this->post['supply_area'])&&$this->post['supply_area']!==""? intval($this->post['supply_area']):"";
        $remark = isset($this->post['remark'])&&$this->post['remark']!=""? trim($this->post['remark']):"";
        $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
        if($token==''){
            return error_show(1005,"参数token不能为空");
        }
        $user =GetUserInfo($token);
        if(empty($user)||$user['code']!=0){
            return error_show(1002,"用户数据不存在");
        }
        $createrid= isset($user["data"]['id']) ?  $user["data"]['id'] : "";
        $creater= isset($user["data"]['nickname']) ?  $user["data"]['nickname'] : "";
        $bidNo=makeNo("BD");
        $spucode=makeNo("SPU");
        $data=[
            "bidNo"=>$bidNo,
            "infoNo"=>$infoNo,
            "zxNo"=>$zxinfo['zxNo'],
            "spuCode"=>$spucode,
            "good_name"=>$pname,
            "brand_id"=>$brandid,
            "cat_id"=>$cat_id,
            "model"=>$model,
            "material"=>$material,
            "unit_id"=>$unit_id,
            "cost_desc"=>$cost_desc,
            "work_day"=>$work_day,
            "delivery_day"=>$delivery_day,
            "good_img"=>$good_img,
            "expire_day"=>$expire_day,
            "origin_place"=>$origin_place,
            "supplierNo"=>$supplierNo,
            "pay_way"=>$pay_way,
            "tax"=>$tax,
            "send_way"=>$send_way,
            "metal_id"=>$metal_id,
            "is_gold_price"=>$is_gold_price,
            "config"=>$config,
            "weight"=>$weight,
            "is_diff"=>$is_diff,
            "demo_fee"=>$demo_fee,
            "delivery_fee"=>$delivery_fee,
            "open_fee"=>$open_fee,
            "pakge_fee"=>$pakge_fee,
            "nake_fee"=>$nake_fee,
            "mark_fee"=>$mark_fee,
            "cert_fee"=>$cert_fee,
            "cost_fee"=>$cost_fee,
            "total_fee"=>$total_fee,
            "supply_area"=>$supply_area,
            "remark"=>$remark,
            "sale_price"=>0,
            "createrid"=>$createrid,
            "creater"=>$creater,
            "status"=>0,
            "addtime"=>date("Y-m-d H:i:s"),
            "updatetime"=>date("Y-m-d H:i:s")
        ];
        Db::startTrans();
        try{
            $insert= Db::name("consult_bids")->insert($data);
            if($insert){
                $data=[
                    "spuCode"=>$spucode,
                    "good_name"=>$pname,
                    "brand_id"=>$brandid,
                    "good_unit"=>$unit_id,
                    "good_type"=>0,
                    "moq"=>1,
                    "customized"=>$work_day,
                    "tax"=>$tax,
                    "supplierNo"=>$supplierNo,
                    "is_auth"=>0,
                    "craft_desc"=>$cost_desc,
                    "good_remark"=>$remark,
                    "good_img"=>$good_img,
                    "good_thumb_img"=>"",
                    "good_info_img"=>"",
                    "status"=>0,
                    "is_del"=>0,
                    "createrid"=>$createrid,
                    "creater"=>$creater,
                    "addtime"=>date("Y-m-d H:i:s"),
                    "updatetime"=>date("Y-m-d H:i:s")
                ];
                $good = Db::name("good_zixun")->insert($data);
                if($good){
                    Db::commit();
                    return app_show(0,"反馈成功",["bidNo"=>$bidNo]);
                }else{
                    Db::rollback();
                    return error_show(1004,"反馈失败");
                }
            }else{
                Db::rollback();
                return error_show(1004,"反馈失败");
            }
        }catch (\Exception $e){
            Db::rollback();
            return error_show(1004,$e->getMessage());
        }
    }

    public function feadinfo(){
       $bidNo =isset($this->post['bidNo'])&& $this->post['bidNo']!=""?trim($this->post['bidNo']):"";
       if($bidNo==""){
           return error_show(1004,"参数bidNo不能为空");
       }
       $info =Db::name("good_bids")->where(['bidNo'=>$bidNo,"is_del"=>0])->find();
       if($info==false){
           return error_show(1004,"未找到商品数据");
       }
        $unit =Db::name("unit")->where(["id"=>$info['good_unit']])->find();
        $info['unit'] = isset($unit['unit'])?$unit['unit']:'';
        $info['cat_info'] = made($info['cat_id'],[]);
        $supplier = Db::name("supplier")->where(["code"=>$info['supplierNo']])->find();
        $info['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
        $supplier = Db::name("supplier")->where(["code"=>$info['supplierNo']])->find();
        $info['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
        if($info['brand_id']!=0){
            $brand=Db::name("brand")->where(["id"=>$info['brand_id']])->find();
            $info["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
        }else{
            $info["brand_name"]="";
            $info["brand_id"]="";
        }


    }
}