UsersImport.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. <?php
  2. namespace App\Imports;
  3. use App\Http\Models\Tenant;
  4. use Illuminate\Validation\Rule;
  5. use Maatwebsite\Excel\Concerns\ToArray;
  6. use Maatwebsite\Excel\Concerns\ToModel;
  7. use Maatwebsite\Excel\Concerns\WithValidation;
  8. use Maatwebsite\Excel\Concerns\WithMappedCells;
  9. use Maatwebsite\Excel\Concerns\WithHeadings;
  10. use Maatwebsite\Excel\Concerns\WithHeadingRow;
  11. class UsersImport implements ToArray
  12. {
  13. public function array(array $array)
  14. {
  15. dump($array);
  16. }
  17. /**
  18. * @param array $row
  19. *
  20. * @return \Illuminate\Database\Eloquent\Model|null
  21. */
  22. public function model(array $row)
  23. {
  24. dump($row);
  25. }
  26. public function map($row): array
  27. {
  28. return [
  29. 'name' => $row[0],
  30. 'title' => $row[1],
  31. ];
  32. }
  33. public function mapping(): array
  34. {
  35. return [
  36. 'name' => 'B1',
  37. ];
  38. }
  39. public function rules(): array
  40. {
  41. return [
  42. // 'name' => Rule::in(['patrick@maatwebsite.nl']),
  43. ];
  44. }
  45. public function customValidationMessages()
  46. {
  47. return [
  48. '1.in' => '自定义',
  49. ];
  50. }
  51. }