request->isAjax()) { $params = $this->request->param(); // halt($params); $data = \addons\qingdong\model\Contract::with(['business','customer'])->where(function($query)use($params){ if(!empty($params['main_fabhjb'])){ $query->whereLike('main_fabhjb',"%{$params['main_fabhjb']}%"); }else{ $query->whereLike('main_fabhjb',''); } //项目名称不是合同名称 if(!empty($params['name'])){ $ids = \addons\qingdong\model\Business::whereLike('name',"%{$params['name']}%")->column('id'); $query->whereIn('business_id',$ids); }else{ $query->where('business_id',''); } if(!empty($params['num'])){ $query->whereLike('num',"%{$params['num']}%"); }else{ $query->whereLike('num',''); } })->find(); // halt($data); // $data = ['12','344']; if(empty($data)){ $this->error('暂无数据',''); } $data = $data->toArray(); $business = \addons\qingdong\model\Business::where('id',$data['business']['id'])->find(); if($business){ $business = $business->toArray(); $business['technical_id'] = \addons\qingdong\model\Staff::where('id',$business['technical_id'])->value('name'); } $data['business']['technical_id'] = $business['technical_id']; // halt($data['business']); $this->success('查询成功','',$data); } return $this->view->fetch(); } public function getGoodsSales() { $id = 98; $ids = Db::name('tmrxyo')->where('status','2')->where('contract_id',$id??0)->column('id'); // halt($ids); $sales_ids = Db::name('amodel_goods')->whereIn('tmrxyo_id',$ids)->column('sales_id'); $list = Db::name('kuerp_goods_sales')->whereIn('id',$sales_ids)->order('createtime desc')->paginate()->each(function($item){ $item['createtime'] = date('Y-m-d',$item['createtime']); return $item; }); $result = array("total" => $list->total(), "rows" => $list->items()); return json($result); } public function getHk() { $model = new \addons\antis\model\Receivables(); $where = []; $list = $model->where($where)->with(['customer', 'contract','ownerStaff'])->order('createtime desc')->paginate(); $result = array("total" => $list->total(), "rows" => $list->items()); return json($result); } }