InnerOrderSeeder.php 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179
  1. <?php
  2. use Illuminate\Database\Seeder;
  3. class InnerOrderSeeder extends Seeder
  4. {
  5. /**
  6. * Run the database seeds.
  7. *
  8. * @return void
  9. */
  10. public function run()
  11. {
  12. $total = 20;
  13. for($i = 0; $i < $total; ++$i) {
  14. \App\Models\Spec::create([
  15. 'name' => '规格' . ($i + 1),
  16. 'sort' => ($i + 1)
  17. ]);
  18. }
  19. $this->call([
  20. InnerDeviceStatusSeeder::class
  21. ]);
  22. $statuses = \App\Models\Option::get('inner_devices', 'status');
  23. $specs = \App\Models\Spec::limit(3)->get();
  24. $device_types = \App\Models\Device::limit(3)->get();
  25. \App\Models\InnerDevice::truncate();
  26. for($i = 0; $i < $total * 10; ++$i) {
  27. \App\Models\InnerDevice::create([
  28. 'name' => '内部设备' . ($i + 1),
  29. 'device_id' => $device_types->random()->id,
  30. 'spec_id' => $specs->random()->id,
  31. 'status' => $statuses->whereIn('key', ['free', 'error'])->first()->id,
  32. 'number' => time(),
  33. 'produce_date' => '2020-01-01',
  34. 'shape' => '180cm*180cm',
  35. 'buy_origin' => '100',
  36. 'manufacturer' => '机械制造厂'
  37. ]);
  38. \App\Models\InnerDevice::create([
  39. 'name' => '内部设备' . ($i + 1),
  40. 'device_id' => $device_types->random()->id,
  41. 'spec_id' => $specs->random()->id,
  42. 'status' => $statuses->where('key', 'free')->first()->id,
  43. 'number' => time(),
  44. 'produce_date' => '2020-01-01',
  45. 'shape' => '180cm*180cm',
  46. 'buy_origin' => '100',
  47. 'manufacturer' => '机械制造厂'
  48. ]);
  49. }
  50. $project = \App\Models\Project::first();
  51. $work_points = \App\Models\WorkPoint::all();
  52. $user = \App\Models\User::first();
  53. $project_roles = \App\Models\ProjectRole::limit(7)->get();
  54. $project_role = $project_roles->where('key', 'machine')->first();
  55. // 草稿
  56. for($i = 1; $i < $total; ++$i) {
  57. $order = \App\Models\Order::create([
  58. 'work_point_id' => $work_points->random()->id,
  59. 'is_draft' => 1,
  60. 'status' => \App\Models\Option::get('orders', 'status', 'checking'),
  61. 'order_number' => \App\Models\Order::createOrderNumber(),
  62. 'project_id' => $project->id,
  63. 'user_id' => $user->id,
  64. 'project_role_id' => $project_role->id,
  65. 'type' => 2
  66. ]);
  67. $this->createOrderDevice($order);
  68. }
  69. // 待审核,checking
  70. for($i = 1; $i < $total; ++$i) {
  71. $order = \App\Models\Order::create([
  72. 'work_point_id' => $work_points->random()->id,
  73. 'is_draft' => 2,
  74. 'status' => \App\Models\Option::get('orders', 'status', 'checking'),
  75. 'order_number' => \App\Models\Order::createOrderNumber(),
  76. 'project_id' => $project->id,
  77. 'user_id' => $user->id,
  78. 'project_role_id' => $project_roles->first()->id,
  79. 'type' => 2
  80. ]);
  81. $this->createOrderDevice($order);
  82. }
  83. // 已审核,checked
  84. for($i = 1; $i < $total; ++$i) {
  85. $last_project_role = $project_roles->whereIn('key', ['assist', 'manager', 'admin'])->random();
  86. $project_role = $project_roles->where('key', 'machine')->first();
  87. if($last_project_role->key != 'admin') {
  88. $project_role = $project_roles->where('need_check_inner', 1)->where('level', '>', $last_project_role->level)->first();
  89. }
  90. $order = \App\Models\Order::create([
  91. 'work_point_id' => $work_points->random()->id,
  92. 'is_draft' => 2,
  93. 'status' => \App\Models\Option::get('orders', 'status', 'checked'),
  94. 'order_number' => \App\Models\Order::createOrderNumber(),
  95. 'project_id' => $project->id,
  96. 'user_id' => $user->id,
  97. 'project_role_id' => $project_role->id,
  98. 'last_project_role_id' => $last_project_role->id,
  99. 'type' => 2
  100. ]);
  101. $this->createOrderDevice($order);
  102. }
  103. // 已完成,pass
  104. for($i = 1; $i < $total; ++$i) {
  105. $last_project_role = $project_roles->where('key', 'admin')->first();
  106. $project_role = $project_roles->where('key', 'machine')->first();
  107. $order = \App\Models\Order::create([
  108. 'work_point_id' => $work_points->random()->id,
  109. 'is_draft' => 2,
  110. 'status' => \App\Models\Option::get('orders', 'status', 'pass'),
  111. 'order_number' => \App\Models\Order::createOrderNumber(),
  112. 'project_id' => $project->id,
  113. 'user_id' => $user->id,
  114. 'project_role_id' => $project_role->id,
  115. 'last_project_role_id' => $last_project_role->id,
  116. 'type' => 2
  117. ]);
  118. $this->createOrderDevice($order);
  119. }
  120. // 已驳回,pass
  121. for($i = 1; $i < $total; ++$i) {
  122. $last_project_role = $project_roles->whereIn('key', ['assist', 'manager', 'admin'])->random();
  123. $project_role = $project_roles->where('key', 'machine')->first();
  124. $order = \App\Models\Order::create([
  125. 'work_point_id' => $work_points->random()->id,
  126. 'is_draft' => 2,
  127. 'status' => \App\Models\Option::get('orders', 'status', 'reject'),
  128. 'order_number' => \App\Models\Order::createOrderNumber(),
  129. 'project_id' => $project->id,
  130. 'user_id' => $user->id,
  131. 'project_role_id' => $project_role->id,
  132. 'last_project_role_id' => $last_project_role->id,
  133. 'type' => 2
  134. ]);
  135. $this->createOrderDevice($order);
  136. }
  137. }
  138. public function createOrderDevice(\App\Models\Order $order)
  139. {
  140. $free_id = \App\Models\Option::get('inner_devices', 'status', 'free');
  141. $using_id = \App\Models\Option::get('inner_devices', 'status', 'using');
  142. for($j = 1; $j < 3; ++$j) {
  143. $start_date = \Carbon\Carbon::now()->addDay(mt_rand(1, 4))->toDateString();
  144. $end_date = \Carbon\Carbon::now()->addDay(mt_rand(5, 10))->toDateString();
  145. $device = \App\Models\InnerDevice::where('status', $free_id)->where('id', '>', 10)->first();
  146. \App\Models\OrderDevice::create([
  147. 'order_id' => $order['id'],
  148. 'device_id' => $device->id,
  149. 'start_date' => $start_date,
  150. 'end_date' => $end_date
  151. ]);
  152. // \Illuminate\Support\Facades\Log::info($order['work_point_id']);
  153. $device->update([
  154. 'status' => $using_id,
  155. 'start_date' => $start_date,
  156. 'end_date' => $end_date,
  157. 'work_point_id' => $order['work_point_id']
  158. ]);
  159. }
  160. }
  161. }