MiniSeeder.php 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. <?php
  2. use Illuminate\Database\Seeder;
  3. class MiniSeeder extends Seeder
  4. {
  5. /**
  6. * Run the database seeds.
  7. *
  8. * @return void
  9. */
  10. public function run()
  11. {
  12. // 创建角色、用户
  13. $total = 20;
  14. \App\Models\Role::truncate();
  15. \App\Models\User::truncate();
  16. for($i = 1; $i < $total; ++$i) {
  17. $role = \App\Models\Role::create([
  18. 'name' => '用户角色' . $i,
  19. 'sort' => $i,
  20. 'key' => 'role-' . $i
  21. ]);
  22. \App\Models\User::create([
  23. 'role_id' => $role->id,
  24. 'name' => '用户' . $i,
  25. 'password' => bcrypt(123456),
  26. 'phone' => $i < 10 ? '1234567890' . $i : '123456789' . $i
  27. ]);
  28. }
  29. // 创建项目角色
  30. $this->call([
  31. ProjectRoleSeeder::class
  32. ]);
  33. // 创建项目,为项目分配用户和项目角色
  34. \App\Models\Project::truncate();
  35. \App\Models\ProjectUser::truncate();
  36. $users = \App\Models\User::limit(7)->get();
  37. $project_roles = \App\Models\ProjectRole::limit(7)->get();
  38. for($i = 1; $i < $total; ++$i) {
  39. $project = \App\Models\Project::create([
  40. 'name' => '项目' . ($i + 2)
  41. ]);
  42. for($j = 0; $j < count($users); ++$j) {
  43. \App\Models\ProjectUser::create([
  44. 'project_id' => $project->id,
  45. 'user_id' => $users[$j]->id,
  46. 'project_role_id' => $project_roles[$j]->id
  47. ]);
  48. }
  49. }
  50. \App\Models\Device::truncate();
  51. // 创建设备类型
  52. $device_types = ['隧道掘进机', '钻机', '起重机械', '隧道牵引机械', '混泥土泵送机械', '土石方机械', '运输机械', '其他'];
  53. foreach($device_types as $key => $value) {
  54. \App\Models\Device::create([
  55. 'name' => $value,
  56. 'sort' => $key + 1
  57. ]);
  58. }
  59. // 创建需求工点
  60. \App\Models\WorkPoint::truncate();
  61. for($i = 1; $i < $total; ++$i) {
  62. \App\Models\WorkPoint::create([
  63. 'name' => '工点' . $i
  64. ]);
  65. }
  66. // 创建订单状态
  67. $this->call([
  68. OptionSeeder::class
  69. ]);
  70. // 创建订单
  71. \App\Models\Order::truncate();
  72. \App\Models\OrderDevice::truncate();
  73. $project = \App\Models\Project::first();
  74. $work_points = \App\Models\WorkPoint::all();
  75. $user = \App\Models\User::first();
  76. $devices = \App\Models\Device::all();
  77. // 草稿
  78. for($i = 1; $i < $total; ++$i) {
  79. $order = \App\Models\Order::create([
  80. 'work_point_id' => $work_points->random()->id,
  81. 'is_draft' => 1,
  82. 'status' => \App\Models\Option::get('orders', 'status', 'checking'),
  83. 'order_number' => \App\Models\Order::createOrderNumber(),
  84. 'project_id' => $project->id,
  85. 'user_id' => $user->id,
  86. 'project_role_id' => $project_roles->first()->id,
  87. 'type' => 1
  88. ]);
  89. $this->createOrderDevice($order, $devices);
  90. }
  91. // 待审核,checking
  92. for($i = 1; $i < $total; ++$i) {
  93. $order = \App\Models\Order::create([
  94. 'work_point_id' => $work_points->random()->id,
  95. 'is_draft' => 2,
  96. 'status' => \App\Models\Option::get('orders', 'status', 'checking'),
  97. 'order_number' => \App\Models\Order::createOrderNumber(),
  98. 'project_id' => $project->id,
  99. 'user_id' => $user->id,
  100. 'project_role_id' => $project_roles->first()->id,
  101. 'type' => 1
  102. ]);
  103. $this->createOrderDevice($order, $devices);
  104. }
  105. // 已审核,checked
  106. for($i = 1; $i < $total; ++$i) {
  107. $last_project_role = $project_roles->whereIn('key', ['machine', 'assist', 'manager'])->random();
  108. $project_role = $project_roles->where('key', 'work')->first();
  109. if($last_project_role->key != 'manager') {
  110. $project_role = $project_roles->where('need_check', 1)->where('level', '>', $last_project_role->level)->first();
  111. }
  112. $order = \App\Models\Order::create([
  113. 'work_point_id' => $work_points->random()->id,
  114. 'is_draft' => 2,
  115. 'status' => \App\Models\Option::get('orders', 'status', 'checked'),
  116. 'order_number' => \App\Models\Order::createOrderNumber(),
  117. 'project_id' => $project->id,
  118. 'user_id' => $user->id,
  119. 'project_role_id' => $project_role->id,
  120. 'last_project_role_id' => $last_project_role->id,
  121. 'type' => 1
  122. ]);
  123. $this->createOrderDevice($order, $devices);
  124. }
  125. // 已完成,pass
  126. for($i = 1; $i < $total; ++$i) {
  127. $last_project_role = $project_roles->where('key', 'manager')->first();
  128. $project_role = $project_roles->where('key', 'work')->first();
  129. $order = \App\Models\Order::create([
  130. 'work_point_id' => $work_points->random()->id,
  131. 'is_draft' => 2,
  132. 'status' => \App\Models\Option::get('orders', 'status', 'pass'),
  133. 'order_number' => \App\Models\Order::createOrderNumber(),
  134. 'project_id' => $project->id,
  135. 'user_id' => $user->id,
  136. 'project_role_id' => $project_role->id,
  137. 'last_project_role_id' => $last_project_role->id,
  138. 'type' => 1
  139. ]);
  140. $this->createOrderDevice($order, $devices);
  141. }
  142. // 已驳回,pass
  143. for($i = 1; $i < $total; ++$i) {
  144. $last_project_role = $project_roles->whereIn('key', ['machine', 'assist', 'manager'])->random();
  145. $project_role = $project_roles->where('key', 'work')->first();
  146. $order = \App\Models\Order::create([
  147. 'work_point_id' => $work_points->random()->id,
  148. 'is_draft' => 2,
  149. 'status' => \App\Models\Option::get('orders', 'status', 'reject'),
  150. 'order_number' => \App\Models\Order::createOrderNumber(),
  151. 'project_id' => $project->id,
  152. 'user_id' => $user->id,
  153. 'project_role_id' => $project_role->id,
  154. 'last_project_role_id' => $last_project_role->id,
  155. 'type' => 1
  156. ]);
  157. $this->createOrderDevice($order, $devices);
  158. }
  159. $this->call([
  160. InnerOrderSeeder::class
  161. ]);
  162. }
  163. public function createOrderDevice(\App\Models\Order $order, \Illuminate\Support\Collection $devices)
  164. {
  165. $money = 0;
  166. for($j = 1; $j < 3; ++$j) {
  167. $start_date = \Carbon\Carbon::now()->addDay(mt_rand(1, 4))->toDateString();
  168. $end_date = \Carbon\Carbon::now()->addDay(mt_rand(5, 10))->toDateString();
  169. $quantity = mt_rand(1, 5);
  170. $price = mt_rand(1, 10) * 1000;
  171. $money = $money + $quantity * $price;
  172. \App\Models\OrderDevice::create([
  173. 'name' => '设备' . $j,
  174. 'order_id' => $order['id'],
  175. 'device_id' => $devices->random()->id,
  176. 'quantity' => $quantity,
  177. 'price' => $price,
  178. 'start_date' => $start_date,
  179. 'end_date' => $end_date
  180. ]);
  181. }
  182. $order->update(['money' => $money]);
  183. }
  184. }