StoreCheckingReceiveService.php 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <?php
  2. namespace App\Services;
  3. use App\Services\common\QueryService;
  4. use App\StoreCheckingReceive;
  5. use Illuminate\Database\Eloquent\Builder;
  6. use App\Traits\ServiceAppAop;
  7. class StoreCheckingReceiveService
  8. {
  9. use ServiceAppAop;
  10. protected $modelClass=StoreCheckingReceive::class;
  11. /**
  12. * @param Builder $query
  13. * @param array $params
  14. * @return Builder
  15. */
  16. private function conditionQuery(Builder $query,array $params){
  17. $columnQueryRules=[
  18. 'created_at_start' => ['alias' => 'created_at' , 'startDate' => ' 00:00:00'],
  19. 'created_at_end' => ['alias' => 'created_at' , 'endDate' => ' 23:59:59'],
  20. 'owner_id' => ['multi' => ','],
  21. 'id' => ['multi' => ','],
  22. 'asn' => ['batch' => ',']
  23. ];
  24. return app(QueryService::class)->query($params,$query,$columnQueryRules);
  25. }
  26. public function paginate(array $params){
  27. $query = StoreCheckingReceive::query()->orderByDesc('id');
  28. $query->with('owner');
  29. $query = $this->conditionQuery($query, $params);
  30. return $query->paginate($params['paginate'] ?? 50);
  31. }
  32. public function create(array $params){
  33. return StoreCheckingReceive::query()->create($params);
  34. }
  35. public function find($id, array $withs = []){
  36. $query = StoreCheckingReceive::query();
  37. if ($withs) $query -> with($withs);
  38. return $query->find($id);
  39. }
  40. public function updateFind(StoreCheckingReceive $storeCheckingReceive, array $params){
  41. $storeCheckingReceive->update($params);
  42. return $storeCheckingReceive;
  43. }
  44. }