61 lines
3.5 KiB
PHP
61 lines
3.5 KiB
PHP
<?php
|
|
|
|
namespace App\Imports;
|
|
|
|
use App\Exceptions\ImportException;
|
|
use App\Models\Keyword;
|
|
use App\Models\Oldmen as ModelsOldmen;
|
|
use App\Models\Zone;
|
|
use Carbon\Carbon;
|
|
|
|
class Oldmen extends ImportBase
|
|
{
|
|
public function loadRow($row)
|
|
{
|
|
$cardNo = $row->getCellAtIndex(0)?->getValue() ?? throw new ImportException('未填写身份证号码');//身份证号
|
|
$name = $row->getCellAtIndex(1)?->getValue() ?? throw new ImportException('未填写姓名');//姓名
|
|
$sex = $row->getCellAtIndex(2)?->getValue() ?? throw new ImportException('未填写性别');//性别
|
|
$birthDate = $row->getCellAtIndex(3)?->getValue() ?? throw new ImportException('未填写生日');//生日
|
|
$cardCity = $row->getCellAtIndex(4)?->getValue() ?? throw new ImportException('未填写地址省份');//省
|
|
$cardProvince = $row->getCellAtIndex(5)?->getValue() ?? throw new ImportException('未填写地址-市');//市
|
|
$cardArea = $row->getCellAtIndex(6)?->getValue() ?? throw new ImportException('未填写地址-区');//区
|
|
$cardAddress = $row->getCellAtIndex(7)?->getValue() ?? throw new ImportException('未填写详细地址');//详细地址
|
|
$agreementNo = $row->getCellAtIndex(8)?->getValue() ?? '';//协议号码
|
|
$nurseLvName = $row->getCellAtIndex(9)?->getValue() ?? throw new ImportException('未填写护理等级');//护理等级
|
|
$clientName = $row->getCellAtIndex(10)?->getValue() ?? throw new ImportException('未填写监护人姓名');//监护人姓名
|
|
$clientPhone = $row->getCellAtIndex(11)?->getValue() ?? throw new ImportException('未填写监护人手机号码');//监护人手机号
|
|
$clientCity = $row->getCellAtIndex(12)?->getValue() ?? throw new ImportException('未填写监护人地址省份');
|
|
$clientProvince = $row->getCellAtIndex(13)?->getValue() ?? throw new ImportException('未填写监护人地址-市');//市
|
|
$clientArea = $row->getCellAtIndex(14)?->getValue() ?? throw new ImportException('未填写监护人地址-区');//区
|
|
$clientAddress = $row->getCellAtIndex(15)?->getValue() ?? throw new ImportException('未填写监护人详细地址');//详细地址
|
|
|
|
if(ModelsOldmen::where('card_no', $cardNo)->exists()){//如果已存在，则为更新
|
|
$oldman = ModelsOldmen::where('card_no', $cardNo)->first();
|
|
$newLv = Keyword::where(['type_key'=>'nurse_lv', 'name'=>$nurseLvName])->value('value');
|
|
if($oldman->nurse_lv !== $newLv && $oldman->live_in > 0){
|
|
throw new ImportException('当前入住状态无法直接变更护理等级');
|
|
}K;
|
|
}else{
|
|
$oldman = new ModelsOldmen();
|
|
$oldman->card_no = $cardNo;
|
|
$oldman->nurse_lv = Keyword::where(['type_key'=>'nurse_lv', 'name'=>$nurseLvName])->value('value');
|
|
}
|
|
$oldman->name = $name;
|
|
$sexArr = [
|
|
'未知'=>0,
|
|
'男'=>1,
|
|
'女'=>2
|
|
];
|
|
$oldman->sex = $sexArr[$sex];
|
|
$oldman->birthday = Carbon::parse($birthDate);
|
|
$oldman->card_city_code = Zone::where(['name' => $cardArea, 'type'=>'area'])->value('code') ?? '';
|
|
$oldman->card_address = $cardAddress;
|
|
$oldman->agreement_no = $agreementNo;
|
|
$oldman->client_name = $clientName;
|
|
$oldman->client_phone = $clientPhone;
|
|
$oldman->client_city_code = Zone::where(['name' => $clientArea, 'type'=>'area'])->value('code') ?? '';
|
|
$oldman->client_address = $clientAddress;
|
|
$oldman->save();
|
|
}
|
|
}
|