WarehouseService.php 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. namespace App\Services;
  3. use App\Owner;
  4. use App\Warehouse;
  5. use Carbon\Carbon;
  6. Class WarehouseService
  7. {
  8. public function firstOrCreate(array $params, array $values = null)
  9. {
  10. if ($values) return Warehouse::query()->firstOrCreate($params, $values);
  11. return Warehouse::query()->firstOrCreate($params);
  12. }
  13. public function getByWms($asnHerders)
  14. {
  15. $warehouseids = array_unique(data_get($asnHerders, '*.warehouseid'));
  16. $warehouseids = array_diff($warehouseids, [null, '', '*']);
  17. $warehouses = Warehouse::query()->whereIn('code', $warehouseids)->get();
  18. if ($warehouses->count() < count($warehouseids)) {
  19. $warehouseids = array_diff($warehouseids, data_get($warehouses, '*.code'));
  20. $warehouse_list = $this->createWarehouseByWms($warehouseids);
  21. $warehouses=$warehouses->concat($warehouse_list);
  22. }
  23. return $warehouses;
  24. }
  25. public function createWarehouseByWms($codes)
  26. {
  27. if(!$codes) {return [];}
  28. $insert_params = [];
  29. $created_at = Carbon::now()->format('Y-m-d H:i:s');
  30. foreach ($codes as $item) {
  31. $insert_params[] = [
  32. 'code' => $item,
  33. 'name' => $item,
  34. 'created_at' => $created_at,
  35. ];
  36. }
  37. try {
  38. if (count($insert_params) > 0) {
  39. $this->insert($insert_params);
  40. LogService::log(__METHOD__, __FUNCTION__, '批量创建 warehouse success' . count($insert_params) . json_encode($insert_params) );
  41. }
  42. } catch (\Exception $e) {
  43. LogService::log(__METHOD__, __FUNCTION__, '批量创建 warehouse error' . json_encode($insert_params) . '||' . $e->getMessage() . '||' . $e->getTraceAsString());
  44. } finally {
  45. return Warehouse::query()->whereIn('code', $codes)->get();
  46. }
  47. }
  48. public function insert($fillables){
  49. return Warehouse::query()->insert($fillables);
  50. }
  51. }