BaoMa/app/Imports/Order/phoneOrder.php

<?php

namespace App\Imports\Order;

use App\Models\Docter;
use App\Models\Order;
use App\Models\OrderPatient;
use App\Models\Organization;
use App\Models\Patient;
use App\User;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;

class phoneOrder implements ToCollection
{
    /**
    * @param Collection $collection
    */
    public function collection(Collection $collection)
    {
        foreach ($collection as $row){
            if ($row[0] == '订单编号') continue;

//        [
//            0 => "MNC20210131110722347"
//    1 => "云南运营主体"
//    2 => "王洛染"
//    3 => "18669008017"
//    4 => "姚正"
//    5 => "昆明儿科联盟"
//    6 => "云南省昆明市昆明市西山区前卫佳湖社区卫生服务站"
//    7 => "全科医学科"
//    8 => "否"
//    9 => "已完成"
//    10 => "已评价"
//    11 => "否"
//    12 => "19.99"
//    13 => "0.00"
//    14 => "19.99"
//    15 => "19.99"
//    16 => "微信支付"
//    17 => "自费"
//    18 => "已付款"
//    19 => "2021-01-31 11:07:23"

//        ];
            //检查是否有该订单
            $isHave = $this->getValue(new Order(), ['order_sn' => $row[0]], 'id');
            if ($isHave) return null;

            $user_id = $this->getValue(new User(), ['phone' => $row[3]], 'id');
            if (empty($user_id)) {
                echo $row[3] . '用户缺失' . PHP_EOL;
                return null;
            }
            //患者信息
            $patientInfo = Patient::where(['name' => $row[2]])->first();
            if (empty($patientInfo)) {
                echo $row[2] . '患者缺失' . PHP_EOL;
                continue;
            }
            $org_name = substr($row[6],18);
            $org_id = $this->getValue(new Organization(), ['name' => $org_name], 'id');
            if (empty($org_id)) {
                echo $row[6] . '机构缺失' . PHP_EOL;
                continue;
            }

            //如果没有用户不导入该订单
            if (empty($user_id)) {
                Log::info('订单没有用户信息,订单编号： ' . $row[0] . PHP_EOL);
                continue;
            }

            //订单状态
            $status = Order::getStatus();
            //订单状态
            $paystatus = Order::getPayStatus();
            $pay_status = array_search($row[18], $paystatus);
            $order_status = array_search($row[9], $status);


            $docter_id = $this->getValue(new Docter(), ['name' => $row[4]], 'id');
            $evaluate = $row[10] == '已评价' ? 1 : 0;
            $pay_types = [1 => '微信支付', 2 => '余额支付', 3 => '服务包支付'];
            //支付方式
            $payType = array_search($row[16], $pay_types) + 1;
            if ($payType == 1) $payType = 2;

            $orderInfo = [
                'order_sn' => $row[0],
                'patient_id' => $patientInfo->id,
                'user_id' => $user_id,
                'docter_id' => $docter_id,
                'order_status' => $order_status,
                'organization_id' => $org_id,
                'is_evaluate' => $evaluate,
                'is_discount' => $row[11],
                'total_amount' => intval($row[12]) * 100,
                'discount_amount' => intval($row[13]) * 100,
                'payment_amount' => intval($row[15]) * 100,
                'payment_type' => $payType,
                'payment_status' => $pay_status,
                'product_type' => 1,
                'created_at' => $row[19],
            ];
            $order = Order::create($orderInfo);
            $orderId = $order['id'];

            $orderPatient = [
                'patient_id' => $patientInfo->id,
                'name' => $row[0],
                'order_id' => $orderId,
                'patient_id' => $patientInfo->id,
                'address' => $patientInfo->address,
                'sex' => $patientInfo->sex,
                'organization_id' => $org_id,
            ];
            OrderPatient::insert($orderPatient);
        }
    }

    public function getValue($model,$where,$field)
    {
        return $model->where($where)->value($field);
    }

}