Device.php 1.1 KB

123456789101112131415161718192021222324252627282930
  1. <?php
  2. namespace App\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. use Illuminate\Database\Eloquent\SoftDeletes;
  5. class Device extends BaseModel
  6. {
  7. // 设备类型
  8. use SoftDeletes;
  9. public function getDeviceOptions()
  10. {
  11. $items = Device::select('name as text', 'id as value')->get();
  12. $items = $items->prepend($this->transObject(['text' => '设备类型', 'value' => '']));
  13. foreach ($items as $item) {
  14. $names = DeviceName::where('device_id', $item->value)->select('name as text', 'id as value')->get();
  15. $item->names = $names->prepend($this->transObject(['text' => '设备名称', 'value' => '']));
  16. foreach($item->names as $name) {
  17. $specs = Spec::where('device_name_id', $name->value)->select('name as text', 'id as value')->get();
  18. $name->specs = $specs->prepend($this->transObject(['text' => '规格型号', 'value' => '']));
  19. }
  20. }
  21. return $items;
  22. }
  23. public function transObject($items)
  24. {
  25. return json_decode(json_encode($items));
  26. }
  27. }