StoreCheckingReceiveService.php 1.4 KB

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