baoshi-was/app/Services/WorkOrderService.php

<?php

namespace App\Services;

use App\Order;
use App\OrderIssue;
use App\OrderIssueType;
use App\Traits\ServiceAppAop;
use App\WorkOrder;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\Auth;

class WorkOrderService
{
    use ServiceAppAop;

    protected $modelClass = WorkOrder::class;

    // 创建工单
    public function createWordOrder($params): array
    {
        $params['status'] = 1;
        $params['creator_id'] = Auth::user()['id'];
        $params['grad'] ?? $params['grad'] = 1;
        $workOrder = WorkOrder::query()->create($params);
        return ['success' => false, 'data' => $workOrder];
    }

    // 审核工单
    public function reviewWordOrder($wordOrder): array
    {
        $wordOrder->update([
            'reviewer_id' => Auth::user()['id'],
            'review_at' => Carbon::now(),
            'status' => 2,
        ]);
        $wordOrder = WorkOrder::query()->with('type', 'childType', 'creator', 'order.packages', 'reviewer')->find($wordOrder['id']);
        return ['success' => true, 'data' => $wordOrder];
    }

    /**
     * 根据 订单拦截工单 生成问题件
     * @param $work_orders
     * @return array|bool[]
     */
    public function orderIssueByWorkOrder($work_orders): array
    {
        $order_ids = $work_orders->map(function ($item) {
            return $item->outer_table_id;
        });

        $order_issues = OrderIssue::query()->with('order')->whereIn('order_id', $order_ids)->get();

        $codes = $order_issues->map(function ($item) {
            return $item->order->code;
        });

        if (count($codes) > 0)
            return ['success' => false, 'message' => '对应【' . join(',', $codes) . '】订单已用问题件'];

        $orders = Order::query()->select('code')->whereIn('id', $order_ids)->get();

        $orderHeaders = app(OracleDOCOrderHeaderService::class)->getQuery()->whereIn('orderNo', $orders)->get();

        $order_issue_type = OrderIssueType::query()->where('name', '拦截')->first();       // 订单类型

        $result = app("OrderIssueService")->createOrderIssueByWmsOrder($orderHeaders, $order_issue_type->id, '拦截工单');

        if (!$result) return ['success' => false, 'message' => '生成对应问题件失败'];
        $work_orders = WorkOrder::query()->with(['type', 'childType', 'creator', 'order' => function ($query) {
            /** @var $query Builder */
            $query->with('packages', 'issue');
        }, 'order.issue', 'reviewer'])
            ->where('outer_table_name','orders')
            ->whereIn('outer_table_id', $order_ids)->get();
        return ['success' => true, 'data' => $work_orders];
    }
}