baoshi-was/app/Services/OrderIssueService.php

<?php

namespace App\Services;

use App\Http\Controllers\Controller;
use App\OracleDOCOrderHeader;
use App\OrderIssue;
use App\OrderIssueProcessLog;
use App\OrderPackage;
use App\Order;
use App\RejectedBill;
use App\RejectedBillItem;
use App\Services\common\QueryService;
use Illuminate\Http\Request;
use Illuminate\Support\Arr;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Validator;

class OrderIssueService
{
    public function __construct()
    {
        app()->bind("orderService", OrderService::class);
        app()->bind("rejectedService", RejectedService::class);
        app()->bind("orderPackageCommoditiesService", OrderPackageCommoditiesService::class);
    }

    public function getQuery(array $arr, array $condition = null)
    {
        if (!isset($condition)) {
            $condition = $arr;
        }

        $user = Auth::user();
        $owner_ids = $user ? $user->getPermittingOwnerIdsAttribute() : [];
        if ($condition['owner_id'] ?? false) {
            $owner_ids = explode(',', $condition['owner_id']);
        }

        $query = OrderIssue::with(['top', 'userWorkGroup', 'issueType', 'logs' => function ($query) {
            $query->with('user')->orderByDesc('created_at');
        }, 'order' => function ($query) {
            $query->with(['shop', 'logistic', 'owner', 'packages.commodities.commodity' ]);
        }, 'rejectedBill' => function ($query) {
            $query->with(['items']);
        }, 'secondOrder' => function ($query) {
            $query->with(['shop', 'logistic', 'owner', 'packages.commodities.commodity' ]);
        }])->whereHas('order.owner', function ($query) use ($owner_ids) {
            $query->whereIn('id', $owner_ids);
        });

        $query->selectRaw('order_issues.* ,order_issue_on_tops.id top_id ,order_issue_on_tops.remark,order_issue_on_tops.updated_at top_update')
            ->leftJoin('order_issue_on_tops', 'order_issue_on_tops.order_issue_id', '=', 'order_issues.id')
            ->whereNull('order_issue_on_tops.deleted_at')
            ->orderBy('order_issue_on_tops.updated_at', 'desc')
            ->orderBy('order_issues.id', 'desc');

        return $query;
    }

    private function getOrderQuery(array $arr, $query)
    {
        $query->whereHas('order', function ($query) use ($arr) {
            $params = [
                'consignee_name' => $arr['consignee_name'] ?? '',
                'consignee_phone' => $arr['consignee_phone'] ?? '',
                'client_code' => $arr['client_code'] ?? '',
            ];

            $columnQueryRules=['consignee_phone' => ['like' => ''], 'consignee_name' => ['like' => ''],];
            $query = app(QueryService::class)->query($params,$query,$columnQueryRules);

            if ($arr['logistic_number'] ?? false) {
                $query->whereHas('packages', function ($query) use ($arr) {
                    $query->where('logistic_number', $arr['logistic_number']);
                });
            }

            if (($arr['good_barcode'] ?? false) || ($arr['good_name'] ?? false)) {
                $query->whereHas('packages.commodities.commodity', function ($query) use ($arr) {
                    $params = ['sku' => $arr['good_barcode'] ?? '', 'name' => $arr['good_name'] ?? '',];
                    $query = app(QueryService::class)->query($params,$query,[]);
                });
            }
        });
        if ($arr['send_client_code'] ?? false) {
            $query->whereHas('secondOrder', function ($query) use ($arr) {
                $query->where('client_code', $arr['send_client_code']);
            });
        }
        return $query;
    }

    public function getRejectedBillQuery(array $arr, $query)
    {
        if($arr['logistic_number_return'] ?? false){
            $query->whereHas('rejectedBill', function ($query) use (&$arr) {
                $query->where('logistic_number_return', 'like', $arr['logistic_number_return']);
            });
        }
        if($arr['id_quality_label'] ?? false){
            $query->whereHas('rejectedBill.items', function ($query) use (&$arr) {
                $query->where('id_quality_label', $arr['id_quality_label']);
            });
        }
        return $query;
    }

    public function getConditionQuery(array $arr, array $condition = null)
    {
        $query = $this->getQuery($arr, $condition);
        $query = $this->getOrderQuery($condition ?? $arr, $query);
        $query = $this->getRejectedBillQuery($condition ?? $arr, $query);
        if (!isset($condition)) {
            $condition = $arr;
        }
        $params =[
            'created_at_start' => $condition['created_at_start'] ??'',
            'final_status' => $condition['final_status'] ??'',
            'order_issue_type_id' => $condition['order_issue_type_id'] ??'',
            'logistic_indemnity_money' => $condition['logistic_indemnity_money'] ??'',
            'baoshi_indemnity_money' => $condition['baoshi_indemnity_money'] ??'',
            'order_issues.id' => $condition['order_issue_ids'] ?? '',
        ];
        $columnQueryRules=[
            'order_issues.id' => ['alias'=>'order_issues.id','multi' => ','],
            'created_at_start' => ['alias' => 'order_issues.created_at' , 'startDate' => ' 00:00:00'],
        ];
        $query = app(QueryService::class)->query($params,$query,$columnQueryRules);

        if (!($condition['is_handle'] ?? false) && !($condition['final_status'] ?? false)) {
            $query->where(function ($query) {
                $query->where('final_status', '<>', '已解决')->orWhereNull('final_status');
            });
        }
        if($condition['created_at_end'] ?? false){
            $query->whereHas('logs',function($query) use ($condition){
                $query->where('created_at',$condition['created_at_end'])->where('type','结束');
            });
        }
        return $query;
    }

    public function paginate(array $arr)
    {
        return $this->getConditionQuery($arr)->paginate($arr['paginate'] ?? 50);
    }

    public function orderIssueTag(array $params)
    {
        $orderNos = $params['orderNos'];
        $meg = ['success' => false];
        if ($this->verifyOrderIssue($orderNos)) {
            $meg['fail_info'] = '传入订单编号中对应的订单问题已有生成';
            return $meg;
        }
        foreach ($orderNos as $orderNo) {
            $orderIssue = $this->createOrFindByOrderNo($orderNo);
            OrderIssue::query()->where('id',$orderIssue['id'])->update(['order_issue_type_id'=>$params['typeId'],'result_explain'=>$params['result_explain']]);
            OrderIssueProcessLog::query()->create(['order_issue_id' => $orderIssue['id'], 'user_id' => Auth::user()['id'], 'content' => '标记创建订单问题件', 'type' => '创建']);
        }
        Controller::logS(__METHOD__,__FUNCTION__,'标记订单问题件'.$orderNos,Auth::user()['id']);
        $meg['success'] = true;
        return $meg;
    }

    public function createOrFindByOrderNo($orderNo)
    {
        $orderHeader = OracleDOCOrderHeader::query()->where('orderNo', $orderNo)->first();
        if (!$orderHeader) {
            return null;
        }
        return $this->createOrFind($orderHeader['soreference1']);
    }

    public function createOrFind($clientCode)
    {
        $orderService = app('orderService');
        $orderHeader = OracleDOCOrderHeader::query()->where('SOREFERENCE1', $clientCode)->first();
        if (!$orderHeader) {
            return null;
        }
        $order = $orderService->findOrCreateByClientCode($clientCode);
        $rejectedBill = RejectedBill::query()->where('order_number', $orderHeader['soreference1'])->first();
        $arr = [
            'order_id' => $order['id'],
            'rejected_bill_id' => $rejectedBill['id'],
        ];
        $orderIssue = OrderIssue::query()->create($arr);
        $this->judgeRejectingStatus($orderIssue);
        $orderIssue->order = $order;
        return $orderIssue;
    }

    public function validatorCreate(Request $request)
    {
        return Validator::make($request->input(), [
            'rejected_bill_id' => ['nullable'],
            'order_id' => ['nullable'],
            'owner_id' => ['required'],
            'second_order_id' => ['nullable'],
            'logistic_id' => ['nullable'],
            'order_issue_type_id' => ['required'],
            'baoshi_indemnity_money' => ['numeric', 'nullable'],
            'logistic_indemnity_money' => ['numeric', 'nullable'],
            'final_status' => ['nullable'],
            'result_explain' => ['nullable']
        ], [
            'required' => ':attribute 为必填项',
            'unique' => ':attribute 已存在',
            'numeric' => ':attribute 为数组',
        ], [
            'owner_id' => '货主',
            'rejected_bill_id' => '退回单号',
            'order_id' => '订单ID',
            'second_order_id' => '退回订单id',
            'logistic_id' => '承运人',
            'order_issue_type_id' => '问题类别',
            'baoshi_indemnity_money' => '宝时赔偿金额',
            'logistic_indemnity_money' => '承运商赔偿金额',
            'final_status' => '最终状态',
            'result_explain' => '处理结果说明',
        ]);
    }

    public function create(array $arr)
    {
        $orderIssue = OrderIssue::create($arr);
        if (!$arr['order_id']) {
            $order = Order::create($arr);
            $orderIssue->order_id = $order['id'];
            $orderIssue->save();
        }
        if (!$arr['rejected_bill_id']) {
            $orderIssue->update(['rejecting_status' => '无']);
        } else {
            $this->judgeRejectingStatus($orderIssue);
        }
        return $orderIssue;
    }

    public function judgeRejectingStatus($orderIssue)
    {
        $orderPackageCommoditiesService = new OrderPackageCommoditiesService();
        $rejectedItems = [];
        $orderItems = [];
        if ($orderIssue->rejected_bill_id) {
            $rejectedBill = RejectedBill::find($orderIssue->rejected_bill_id)->first();
            $rejectedBillItems = RejectedBillItem::where('id_rejected_bill', $rejectedBill->id)->get();
            foreach ($rejectedBillItems as $item) {
                if (!isset($rejectedItems[$item->barcode_goods])) {$rejectedItems[$item->barcode_goods] = 0;}
                $rejectedItems[$item->barcode_goods] = $item->amount + $rejectedItems[$item->barcode_goods] ?? 0;
            }
        } else {
            $orderIssue->update(['rejecting_status' => '无']);
            $orderIssue->save();
            return;
        }
        if ($orderIssue->order_id) {
            $orderPackageCommodities = $orderPackageCommoditiesService->getOrderPackageCommoditiesByOrderId($orderIssue->order_id);
            if ($orderPackageCommodities) {
                foreach ($orderPackageCommodities as $key => $item) {
                    if (!isset($orderItems[$item->commodity->sku])) {
                        Arr::add($orderItems, $item->commodity->sku, 0);
                    }
                    $orderItems[$item->commodity->sku] = $orderItems[$item->commodity->sku] ?? 0 + $item->amount;
                }
            } else {
                $orderIssue->update(['rejecting_status' => '未退回']);
                $orderIssue->save();
                return;
            }
        }

        $rejectedExcess = 0;    // 退回差异
        $rejectedReview = 0;    // 退回复核  $rejectedItems == $orderItems
        foreach ($rejectedItems as $key => $items) {
            if (!isset($orderItems[$key])) {
                $rejectedExcess++;
            } else {
                if ($rejectedItems[$key] == $orderItems[$key]) {
                    $rejectedReview++;
                }
            }
        }
        if ($rejectedExcess > 0) {
            $orderIssue->update(['rejecting_status' => '差异退回']);
            $orderIssue->save();
            return;
        }
        $isExcess = 0; // 超量 $orderItems < $rejectedItems
        $isDiff = 0;   // 部分 $orderItems > $rejectedItems
        $isAccord = 0; // 相同 $orderItems == $rejectedItems
        $isLack = 0;   // 缺少 $orderItems != $rejectedItems
        foreach ($orderItems as $key => $item) {
            if (isset($rejectedItems[$key])) {
                if ($orderItems[$key] > $rejectedItems[$key]) {
                    $isExcess++;
                } else if ($orderItems[$key] < $rejectedItems[$key]) {
                    $isDiff++;
                } else if ($orderItems[$key] == $rejectedItems[$key]) {
                    $isAccord++;
                }
            } else {
                $isLack++;
            }
        }
        if ($isAccord == $rejectedReview) {
            $orderIssue->update(['rejecting_status' => '全部退回']);
            $orderIssue->save();
            return;
        } else if ($isDiff > 0 and $isLack >= 0) {
            $orderIssue->update(['rejecting_status' => '部分退回']);
            $orderIssue->save();
            return;
        } else if ($isExcess > 0 and $isDiff == 0) {
            $orderIssue->update(['rejecting_status' => '超量退回']);
            $orderIssue->save();
            return;
        }
    }

    public function createByLogisticNumber(array $arr)
    {
        $order = Order::create($arr);
        $orderIssue = OrderIssue::create($arr);
        $orderIssue->order_id = $order['id'];
        OrderPackage::create(['order_id' => $order->id, 'logistic_number' => $arr['logistic_number_return']]);
        $orderIssue->update();
        return $orderIssue;
    }

    public function verifyOrderIssue(array $arr)
    {
        $orders = Order::whereIn('code', $arr)->get();
        if (count($orders) == 0) {
            return false;
        }
        $order_ids = [];
        foreach ($orders as $order) {
            $order_ids[] = $order->id;
        }
        $count = OrderIssue::whereIn('order_id', $order_ids)->count();
        return $count != 0;
    }

    public function exportExcel(Request $request)
    {
        $result = null;
        if ($request->getMethod() == 'GET') {
            if ($request->has('checkAllSign')) {
                $result = $this->getConditionQuery($request->all(), null)->get();
            }
        } else if ($request->getMethod() == 'POST') {
            $request['order_issue_ids'] = $request->input('data');
            $result = $this->getConditionQuery($request->all(), null)->get();
        }
        return $result;
    }

    public function updateOrderIssue(OrderIssue $orderIssue, array $arr)
    {
        if ($arr['rejectedBill'] ?? false) {
            if ($arr['rejectedBill']['id'] ?? false) {
                $rejectedBill = RejectedBill::where('id', $arr['rejectedBill']['id'])->first();
                $rejectedBill->fill($arr['rejectedBill']);
                $rejectedBill->update();
                $rejectedBill->syncOrderIssue();
                $request['orderIssues']['rejected_bill_id'] = $rejectedBill['id'];
            } else if ($arr['rejectedBill']['id_logistic_return'] ?? false && $arr['rejectedBill']['logistic_number_return'] ?? false) {
                $rejectedBill = RejectedBill::firstOrCreate([
                        'id_logistic_return' => $arr['rejectedBill']['id_logistic_return'],
                        'id_owner' => $arr['rejectedBill']['id_owner'],
                        'logistic_number_return' => $arr['rejectedBill']['logistic_number_return'],]
                );
                $rejectedBill->save();
                $rejectedBill->syncOrderIssue();
                $request['orderIssues']['rejected_bill_id'] = $rejectedBill['id'];

            }
        }
        if ($arr['order'] ?? false) {
            $order = Order::where('id', $arr['order']['id'])->first();
            $order->fill($arr['order']);
            $order->update();
        }
        $orderIssue->fill($arr['orderIssues']);
        $orderIssue->update();
    }

}