DocterOrganizationInfo.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <?php
  2. namespace App\Imports\Docter;
  3. use App\Models\Docter;
  4. use App\Models\DocterOrganization;
  5. use App\Models\Organization;
  6. use App\Models\Qualification;
  7. use Maatwebsite\Excel\Concerns\ToModel;
  8. class DocterOrganizationInfo implements ToModel
  9. {
  10. /**
  11. * @param array $row
  12. *
  13. * @return \Illuminate\Database\Eloquent\Model|null
  14. */
  15. public function model(array $row)
  16. {
  17. if (($row[0] == "姓名")) {
  18. return null;
  19. }
  20. $docter_id = null;
  21. if ($row[0]){
  22. $docter_id = Docter::firstOrCreate([
  23. 'name' => $row[0],
  24. ]);
  25. }
  26. $org_id = null;
  27. if ($row[6]){
  28. $org_id = Organization::firstOrCreate([
  29. 'name' => $row[6],
  30. ]);
  31. }
  32. $qualification_id = null;
  33. if ($row[2])
  34. {
  35. $qualification_id = Qualification::firstOrCreate([
  36. 'name' => $row[2]
  37. ],[
  38. 'name' => $row[2],
  39. 'status' =>1
  40. ]);
  41. }
  42. return new DocterOrganization([
  43. //
  44. 'docter_id' => $docter_id['id'],
  45. 'organization_id' => $org_id['id'],
  46. 'qualifications_id' =>$qualification_id['id'],
  47. 'state' => 1
  48. ]);
  49. }
  50. }