Purch.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace app\admin\controller;
  3. use think\App;
  4. use think\facade\Db;
  5. class Purch extends \app\BaseController
  6. {
  7. public $post="";
  8. public function __construct(App $app)
  9. {
  10. parent::__construct($app);
  11. $this->post=$this->request->post();
  12. }
  13. public function list(){
  14. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  15. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']):"10";
  16. $where =['is_del'=>0];
  17. $bkcode = isset($this->post['bk_code']) && $this->post['bk_code']!="" ? trim($this->post['bk_code']):"";
  18. if($bkcode!=""){
  19. $where['bk_code'] = $bkcode;
  20. }
  21. $good_code = isset($this->post['good_code']) && $this->post['good_code']!="" ? trim($this->post['good_code']):"";
  22. if($good_code!=""){
  23. $where['good_code'] = $good_code;
  24. }
  25. $good_type_code = isset($this->post['good_type_code']) && $this->post['good_type_code']!="" ? trim($this->post['good_type_code']):"";
  26. if($good_type_code!=""){
  27. $where['good_type_code'] = $good_type_code;
  28. }
  29. $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  30. if($wsm_code!=""){
  31. $where['wsm_code'] = $wsm_code;
  32. }
  33. $good_name = isset($this->post['good_name']) && $this->post['good_name']!="" ? trim($this->post['good_name']):"";
  34. if($good_name!=""){
  35. $where['good_name'] = Db::raw(" like %{$good_name}%");
  36. }
  37. $count=Db::name("purchease")->where($where)->count();
  38. $total = ceil($count/$size);
  39. $page = $page >= $total ? $total : $page;
  40. $list = Db::name("purchease")->where($where)->page($page,$size)->select();
  41. return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
  42. }
  43. }