CheckInSeeder.php 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. <?php
  2. namespace Database\Seeders;
  3. use Illuminate\Database\Console\Seeds\WithoutModelEvents;
  4. use Illuminate\Database\Seeder;
  5. use App\Models\CheckIn;
  6. use Illuminate\Support\Facades\File;
  7. class CheckInSeeder extends Seeder
  8. {
  9. /**
  10. * Run the database seeds.
  11. *
  12. * @return void
  13. */
  14. public function run()
  15. {
  16. CheckIn::truncate();
  17. $json = File::get("database/MAA.json");
  18. $child_json = File::get("database/child_count.json");
  19. $maas = json_decode($json);
  20. $child = json_decode($child_json);
  21. foreach ($maas as $key => $value) {
  22. if ($value->department_id != 'xxx') {
  23. switch ($value->department_id) {
  24. case 'B00':
  25. $region = '南區';
  26. break;
  27. case 'B10':
  28. $region = '中區';
  29. break;
  30. default:
  31. $region = '北區';
  32. }
  33. $children_count = isset($child->{$value->user_id}) ? ($child->{$value->user_id}->children_count) : 0;
  34. CheckIn::create([
  35. 'user_id' => $value->user_id,
  36. 'name' => $value->name,
  37. 'department_id' => $value->department_id,
  38. 'region' => $region,
  39. 'is_checked_in' => true,
  40. 'children_count' => $children_count,
  41. 'is_awarded' => false,
  42. 'activity_id' => 2,
  43. 'created_at' => now(),
  44. 'updated_at' => now(),
  45. ]);
  46. }
  47. }
  48. }
  49. }