post=$this->request->post(); } 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]; $bkcode = isset($this->post['bk_code']) && $this->post['bk_code']!="" ? trim($this->post['bk_code']):""; if($bkcode!=""){ $where['bkcode'] = $bkcode; } $wsm_in_code = isset($this->post['wsm_in_code']) && $this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :""; if($wsm_in_code!=""){ $where['wsm_in_code'] = $wsm_in_code; } $apply_name = isset($this->post['apply_name']) && $this->post['apply_name']!="" ? trim($this->post['apply_name']):""; if($apply_name!=""){ $where['apply_name'] =Db::Raw("like '%{$apply_name}%'"); } $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code']!="" ? trim($this->post['wsm_code']):""; if($wsm_code!=""){ $where['wsm_code'] = $wsm_code; } $good_name = isset($this->post['status']) && $this->post['status']!="" ? trim($this->post['status']):""; if($good_name!=""){ $where['good_name'] = Db::raw(" like %{$good_name}%"); } $count=Db::name("purchease")->where($where)->count(); $total = ceil($count/$size); $page = $page >= $total ? $total : $page; $list = Db::name("purchease")->where($where)->page($page,$size)->select(); return app_show(0,"获取成功",["list"=>$list,"count"=>$count]); } }