PickUpDao.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. namespace app\common\dao\store\order;
  3. use app\common\dao\BaseDao;
  4. use app\common\model\store\order\PickUp;
  5. class PickUpDao extends BaseDao
  6. {
  7. protected function getModel(): string
  8. {
  9. return PickUp::class;
  10. }
  11. public function search(array $where)
  12. {
  13. return PickUp::getDB()
  14. ->when(isset($where['name']) && $where['name'] !== '', function ($query) use ($where) {
  15. $query->where('name', 'like', '%' . $where['name'] . '%');
  16. })
  17. ->when(isset($where['address']) && $where['address'] !== '', function ($query) use ($where) {
  18. $query->where('address', 'like', '%' . $where['address'] . '%');
  19. })
  20. ->when(isset($where['user_name']) && $where['user_name'] !== '', function ($query) use ($where) {
  21. $query->where('user_name', 'like', '%' . $where['user_name'] . '%');
  22. })
  23. ->when(isset($where['mobile']) && $where['mobile'] !== '', function ($query) use ($where) {
  24. $query->where('mobile', 'like', '%' . $where['mobile'] . '%');
  25. })
  26. ->when(isset($where['status']) && $where['status'] !== '', function ($query) use ($where) {
  27. $query->where('status', $where['status']);
  28. });
  29. }
  30. }