title='维修订单列表'; $name=input('title'); $order_no = input('order_no'); //1:未接单 2:已有报价 3:已合作 $status = [ 1=>'未接单', 2=>'已接单', 3=>'已匹配', ]; $this->status = $status; $where = []; $data = input(); if(isset($data['status']) && $data['status'] != ""){ $where['status'] = $data['status']; } if($name != ""){ $where[] = ['u.nickname','like','%'.$name.'%']; } $result = DataUserRepair::mQuery() ->alias('r') ->leftjoin('data_user u','u.id = r.uuid') ->where('is_del',1) ->whereLike('order_no',"%$order_no%") ->dateBetween('create_at') ->where($where) ->with(['user']) ->order('r.id','desc'); // ->layTable(); $this->amount = $result->db()->sum('success_price'); $result->page(); } protected function _index_page_filter(&$data) { // dump($data);die; } public function offer(){ $this->title='接单记录'; $name=input('title'); $order_no = input('order_no'); $data = input(); $where = []; // if(isset($data['repair_id'])){ $where['repair_id'] = $data['repair_id']; } $result = DataUserRepairOffer::mQuery() ->when($name,function (Query $query) use ($name) { $query->hasWhere('user',function (Query $query) use ($name) { $query->whereLike('nickname',"%{$name}%"); }); }) ->when($order_no,function (Query $query) use ($order_no) { $query->hasWhere('repair',function (Query $query) use ($order_no) { $query->whereLike('order_no',"%{$order_no}%"); }); }) ->dateBetween('create_at') ->with(['user','repair']) ->where($where) ->order('id','desc'); // ->layTable(); // $this->amount = $result->db()->sum('success_price'); $result->page(); } public function acceptance(){ $this->title='接单记录'; $name=input('title'); $data = input(); $where = []; // if(isset($data['name']) && $data['name'] != ''){ $where[] = ['name','like','%'.$data['name'].'%'] ; } if(isset($data['company_name'])&& $data['company_name'] != ''){ $where[] = ['company_name','like','%'.$data['company_name'].'%'] ; } if(isset($data['create_at'])&& $data['create_at'] != ''){ $where['create_at'] = $data['create_at']; } $result = DataUserAcceptance::mQuery() ->when($name,function (Query $query) use ($name) { $query->hasWhere('user',function (Query $query) use ($name) { $query->whereLike('nickname',"%{$name}%"); }); }) ->dateBetween('create_at') ->with(['user']) ->where($where) ->order('id','desc'); // ->layTable(); // $this->amount = $result->db()->sum('success_price'); $result->page(); } protected function _offer_page_filter(&$data) { $this->title='接单列表'; //dump($data);die; } /** * 招聘信息查看 * @auth true * @menu true */ public function audit($id){ $this->title='招聘信息查看'; $row=DataUserRepair::mk() ->with(['user']) ->findOrFail($id); if($this->request->isGet()){ $this->assign('row',$row); $this->fetch(); }else{ if($row['audit']>1){ $this->error('该记录已审核'); } $data=$this->_vali([ 'audit.require'=>'结果必须', 'audit.in:2,3'=>'结果有误', 'why.requireIf:audit,3'=>'原因必须', 'why.max:200'=>'原因有误', ]); $row['audit']=$data['audit']; $row['why']=$data['why']??''; $row['audit_at']=Carbon::now(); $row->save(); if ($data['audit']==2){ DataUser::mk()->where('id',$row['uuid'])->update(['is_maintenance'=>1]); } $this->success('审核成功'); } } }