MiniSeeder.php 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  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. \App\Models\DeviceName::truncate();
  52. \App\Models\Spec::truncate();
  53. // 创建设备类型
  54. $device_types = ['起重机械', '隧道掘进机'];
  55. $cnt = 0;
  56. foreach($device_types as $key => $value) {
  57. $cnt = $cnt + 1;
  58. $device = \App\Models\Device::create([
  59. 'name' => $value,
  60. 'sort' => $cnt
  61. ]);
  62. for($i = 1; $i < 3; ++$i) {
  63. $cnt = $cnt + 1;
  64. $device_name = \App\Models\DeviceName::create([
  65. 'device_id' => $device->id,
  66. 'name' => $value . $cnt,
  67. 'sort' => $cnt
  68. ]);
  69. for($j = 1; $j < 3; ++$j) {
  70. $cnt = $cnt + 1;
  71. \App\Models\Spec::create([
  72. 'device_id' => $device->id,
  73. 'device_name_id' => $device_name->id,
  74. 'name' => '规格' . $cnt,
  75. 'sort' => $cnt,
  76. ]);
  77. }
  78. }
  79. }
  80. \App\Models\RentType::truncate();
  81. $rent_names = ['按小时', '按天'];
  82. foreach($rent_names as $key => $rent_name) {
  83. \App\Models\RentType::create([
  84. 'name' => $rent_name,
  85. 'sort' => ($key + 1)
  86. ]);
  87. }
  88. // 创建需求工点
  89. \App\Models\WorkPoint::truncate();
  90. for($i = 1; $i < $total; ++$i) {
  91. \App\Models\WorkPoint::create([
  92. 'name' => '工点' . $i
  93. ]);
  94. }
  95. // 创建订单状态
  96. $this->call([
  97. OptionSeeder::class
  98. ]);
  99. // 创建订单
  100. \App\Models\Order::truncate();
  101. \App\Models\OrderDevice::truncate();
  102. $project = \App\Models\Project::first();
  103. $work_points = \App\Models\WorkPoint::all();
  104. $user = \App\Models\User::first();
  105. $devices = \App\Models\Device::all();
  106. // 草稿
  107. for($i = 1; $i < $total; ++$i) {
  108. $order = \App\Models\Order::create([
  109. 'work_point_id' => $work_points->random()->id,
  110. 'is_draft' => 1,
  111. 'status' => \App\Models\Option::get('orders', 'status', 'checking'),
  112. 'order_number' => \App\Models\Order::createOrderNumber(),
  113. 'project_id' => $project->id,
  114. 'user_id' => $user->id,
  115. 'project_role_id' => $project_roles->first()->id,
  116. 'type' => 1
  117. ]);
  118. $this->createOrderDevice($order, $devices);
  119. }
  120. // 待审核,checking
  121. for($i = 1; $i < $total; ++$i) {
  122. $order = \App\Models\Order::create([
  123. 'work_point_id' => $work_points->random()->id,
  124. 'is_draft' => 2,
  125. 'status' => \App\Models\Option::get('orders', 'status', 'checking'),
  126. 'order_number' => \App\Models\Order::createOrderNumber(),
  127. 'project_id' => $project->id,
  128. 'user_id' => $user->id,
  129. 'project_role_id' => $project_roles->first()->id,
  130. 'type' => 1
  131. ]);
  132. $this->createOrderDevice($order, $devices);
  133. }
  134. // 已审核,checked
  135. for($i = 1; $i < $total; ++$i) {
  136. $last_project_role = $project_roles->whereIn('key', ['machine', 'assist', 'manager'])->random();
  137. $project_role = $project_roles->where('key', 'work')->first();
  138. if($last_project_role->key != 'manager') {
  139. $project_role = $project_roles->where('need_check', 1)->where('level', '>', $last_project_role->level)->first();
  140. }
  141. $order = \App\Models\Order::create([
  142. 'work_point_id' => $work_points->random()->id,
  143. 'is_draft' => 2,
  144. 'status' => \App\Models\Option::get('orders', 'status', 'checked'),
  145. 'order_number' => \App\Models\Order::createOrderNumber(),
  146. 'project_id' => $project->id,
  147. 'user_id' => $user->id,
  148. 'project_role_id' => $project_role->id,
  149. 'last_project_role_id' => $last_project_role->id,
  150. 'type' => 1
  151. ]);
  152. $this->createOrderDevice($order, $devices);
  153. }
  154. // 已完成,pass
  155. for($i = 1; $i < $total; ++$i) {
  156. $last_project_role = $project_roles->where('key', 'manager')->first();
  157. $project_role = $project_roles->where('key', 'work')->first();
  158. $order = \App\Models\Order::create([
  159. 'work_point_id' => $work_points->random()->id,
  160. 'is_draft' => 2,
  161. 'status' => \App\Models\Option::get('orders', 'status', 'pass'),
  162. 'order_number' => \App\Models\Order::createOrderNumber(),
  163. 'project_id' => $project->id,
  164. 'user_id' => $user->id,
  165. 'project_role_id' => $project_role->id,
  166. 'last_project_role_id' => $last_project_role->id,
  167. 'type' => 1
  168. ]);
  169. $this->createOrderDevice($order, $devices);
  170. }
  171. // 已驳回,pass
  172. for($i = 1; $i < $total; ++$i) {
  173. $last_project_role = $project_roles->whereIn('key', ['machine', 'assist', 'manager'])->random();
  174. $project_role = $project_roles->where('key', 'work')->first();
  175. $order = \App\Models\Order::create([
  176. 'work_point_id' => $work_points->random()->id,
  177. 'is_draft' => 2,
  178. 'status' => \App\Models\Option::get('orders', 'status', 'reject'),
  179. 'order_number' => \App\Models\Order::createOrderNumber(),
  180. 'project_id' => $project->id,
  181. 'user_id' => $user->id,
  182. 'project_role_id' => $project_role->id,
  183. 'last_project_role_id' => $last_project_role->id,
  184. 'type' => 1
  185. ]);
  186. $this->createOrderDevice($order, $devices);
  187. }
  188. $this->call([
  189. InnerOrderSeeder::class
  190. ]);
  191. }
  192. public function createOrderDevice(\App\Models\Order $order, \Illuminate\Support\Collection $devices)
  193. {
  194. $money = 0;
  195. $specs = \App\Models\Spec::all();
  196. $rent_types = \App\Models\RentType::all();
  197. for($j = 1; $j < 3; ++$j) {
  198. $start_date = \Carbon\Carbon::now()->addDay(mt_rand(1, 4))->toDateString();
  199. $end_date = \Carbon\Carbon::now()->addDay(mt_rand(5, 10))->toDateString();
  200. $quantity = mt_rand(1, 5);
  201. $price = mt_rand(1, 10) * 1000;
  202. $money = $money + $quantity * $price;
  203. $spec = $specs->random();
  204. $rent_type = $rent_types->random();
  205. \App\Models\OrderDevice::create([
  206. 'name' => '设备' . $j,
  207. 'order_id' => $order['id'],
  208. 'project_id' => $order['project_id'],
  209. 'device_id' => $spec->device_id,
  210. 'device_name_id' => $spec->device_name_id,
  211. 'spec_id' => $spec->id,
  212. 'rent_type_id' => $rent_type->id,
  213. 'quantity' => $quantity,
  214. 'price' => $price,
  215. 'start_date' => $start_date,
  216. 'end_date' => $end_date
  217. ]);
  218. }
  219. $order->update(['money' => $money]);
  220. }
  221. }