BroadbandSaler/app/DataApiNew/Helper/WorkOrderHelper.php

<?php
/*
 * @Description: 工单表
 * @Version: *
 * @Autor: lexuan
 * @Date: 2024-12-16 10:46:51
 * @LastEditors: lexuan
 * @LastEditTime: 2024-12-16 10:46:51
 */

namespace App\DataApiNew\Helper;

use App\DataApiNew\Models\WorkOrder;
use App\Models\Pages;
use App\Models\SpoutExport;
use App\Models\SpoutImport;
use App\DataApiNew\Models\AdminUsers;
use App\DataApiNew\Models\WorkOrderQuestion;
use Illuminate\Http\Request;

class WorkOrderHelper
{
    // 查询条件
    public function whens($query, $request)
    {
        return $query
            ->when($request->filled('id'), fn ($q) => $q->where('id', $request->id))
            ->when($request->filled('status'), fn ($q) => $q->where('status', $request->status))
            ->when($request->filled('type'), fn ($q) => $q->where('type', $request->type))
            ->when($request->filled('order_no'), fn ($q) => $q->where('order_no', $request->order_no))
            ->when($request->filled('question_order_no'), fn ($q) => $q->where('question_order_no', $request->question_order_no));
    }

    // 查询列表
    public function select(Request $request)
    {
        $page = new Pages($request, WorkOrder::query());

        $page->before(function ($query) use ($request) {
            $user_id = $request->user()->id;
            if(!AdminUsers::isAdmin($user_id)){
                $query->where('user_id', $user_id);
            }
            $query->select(WorkOrder::$selectFields);
            return $this->whens($query, $request);
        });

        $result = $page->paginate();

        return $result;
    }

    // 导出
    public function export(Request $request)
    {
        $query = WorkOrder::select(WorkOrder::$selectFields);
        $query = $this->whens($query, $request);
        $query->orderBy('created_at', 'desc');
        $header = [
            '用户id' => 'user_id',
            '工单订单号' => 'order_no',
            '问题订单号' => 'question_order_no',
            '分类 1号卡 2宽带 3设备 4靓号 5权益' => 'type',
            '标题' => 'title',
            '详情' => 'detail',
            '图片JSON' => 'images',
            '状态 1待处理 2已处理 3已完结' => 'status',
            '创建时间' => 'created_at',
            '更新时间' => 'updated_at',
            '删除时间' => 'deleted_at',
        ];
        $getEnValue = $this->getEnValue();

        $excel = new SpoutExport($header);
        $excel->setQuery($query);
        $result = $excel->setEnum($getEnValue)->spoutToExcel('excel_out');

        return $result ? success($result['url']) : error();
    }

    // 导入
    public function import(Request $request)
    {
        $header = [
            '用户id' => 'user_id',
            '工单订单号' => 'order_no',
            '问题订单号' => 'question_order_no',
            '分类 1号卡 2宽带 3设备 4靓号 5权益' => 'type',
            '标题' => 'title',
            '详情' => 'detail',
            '图片JSON' => 'images',
            '状态 1待处理 2已处理 3已完结' => 'status',
            '创建时间' => 'created_at',
            '更新时间' => 'updated_at',
            '删除时间' => 'deleted_at',
        ];
        $SpoutImport = new SpoutImport($header);
        $dataList = $SpoutImport->setRequest($request)->getExcelData();
        return $dataList;
    }

    // 获取枚举值
    public function getEnValue()
    {
        $data = [];
        return $data;
    }

    // 查询一条
    public function find(Request $request)
    {
        $request->validate([
            'id' => 'required|integer',
        ]);
        $result = WorkOrder::with(['work_order_question'])->where(['id' => $request->id])->select(WorkOrder::$selectFields)->first();
        return success($result);
    }

    // 添加
    public function insert(Request $request)
    {
        $request->validate([
            // 'name' => 'required',
        ]);
        $result = WorkOrder::create($request->all());
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 修改
    public function update(Request $request)
    {
        $request->validate([
            'id' => 'required|integer',
        ]);

        $result = WorkOrder::where(['id' => $request->id])->update($request->all());
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 删除
    public function delete(Request $request)
    {
        $request->validate([
            'ids' => 'required',
        ]);
        $id_str = $request->ids;
        $arr = explode(",", $id_str);
        // 查询是否存在子数据
        // $count = Shop::whereIn('tm_id',$arr)->count();
        // if($count > 0){
        //     return ['code'=>0,'msg'=>"存在子数据，禁止删除"];
        // }
        $result = WorkOrder::whereIn('id', $arr)->delete();
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 创建工单
    public function createWorkOrder(Request $request)
    {
        $request->validate([
            'question_order_no' => 'required',
            'type' => 'required',
            'title' => 'required',
            'detail' => 'required',
        ]);

        $user_id = $request->user()->id;
        $exists = WorkOrder::where('user_id', $user_id)->where('status', '!=', WorkOrder::STATUS_YIEJIU)->exists();

        if ($exists) {
            return ['code' => 0, 'msg' => "您已创建工单，请先完结"];
        }

        $result = WorkOrder::create([
            'user_id' => $user_id,
            'order_no' => UtilsHelper::order_id(),
            'question_order_no' => $request->question_order_no,
            'type' => $request->type,
            'title' => $request->title,
            'detail' => $request->detail,
            'images' => $request->input('images', null),
        ]);

        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 完结工单
    public function endWorkOrder(Request $request)
    {
        $request->validate([
            'id' => 'required',
        ]);

        $user_id = $request->user()->id;
        $result = WorkOrder::where(['id' => $request->id, 'user_id' => $user_id])
            ->where('status', '!=', WorkOrder::STATUS_YIEJIU)->update([
                'status' => WorkOrder::STATUS_YIEJIU,
            ]);
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 回复工单
    public function replyWorkOrder(Request $request)
    {
        $request->validate([
            'work_order_id' => 'required',
            'detail' => 'required',
        ]);

        $user_id = $request->user()->id;

        $workOrder = WorkOrder::where('id', $request->work_order_id)->first();
        if (!$workOrder) {
            return ['code' => 0, 'msg' => "工单不存在"];
        }

        if ($user_id == $workOrder->user_id) {
            $type = WorkOrderQuestion::TYPE_USER;
            $workOrderStatus = WorkOrder::STATUS_DANCHU;
        } else {
            $type = WorkOrderQuestion::TYPE_SYSTEM;
            $workOrderStatus = WorkOrder::STATUS_YITI;
        }

        $result = WorkOrderQuestion::create([
            'work_order_id' => $request->work_order_id,
            'op_user_id' => $user_id,
            'type' => $type,
            'detail' => $request->detail,
            'images' => $request->input('images', null),
        ]);

        if ($result && $workOrder->update(['status' => $workOrderStatus])) {
            return success();
        } else {
            return error();
        }
    }
}