InquiryService.php

<?php

namespace App\Http\Services;

use App\Models\InquiryModel;
use App\Models\InquiryItemsModel;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;

class InquiryService
{
    public static function addInquiry($data, $user)
    {
        return DB::transaction(function () use ($data, $user) {
            $items = \Arr::get($data, 'items', []);
            $items = json_decode($items, true);
            $remark = $data['remark'];
            $inquiry = [
                'inquiry_sn' => self::generateSn(),
                'user_id' => $user->id,
                'sales_id' => $user->sale_id,
                'priority' => InquiryModel::PRIORITY_HIGH,
                'user_types' => $user->account_properties,
                'remark' => $remark,
                'create_time' => time(),
            ];
            $inquiryId = InquiryModel::addInquiry($inquiry);
            $inquiryItems = [];
            foreach ($items as $item) {
                $inquiryItems[] = [
                    'inquiry_id' => $inquiryId,
                    'goods_name' => $item['goods_name'],
                    'brand_name' => $item['brand_name'],
                    'inquiry_number' => $item['inquiry_number'],
                    'remark' => $remark,
                ];
            }
            return InquiryItemsModel::addInquiryItems($inquiryItems);
        });
    }

    public static function getInquiryDetail($inquiryId)
    {
        $inquiry = InquiryModel::select([
            'inquiry_id',
            'inquiry_sn',
            'status',
            'remark',
        ])->where('inquiry_id', $inquiryId)->first()->toArray();
        $inquiryItems = InquiryItemsModel::select([
            'goods_name',
            'brand_name',
            'inquiry_number',
        ])->where('inquiry_id', $inquiryId)->get()->toArray();
        $inquiry['items'] = $inquiryItems;
        return $inquiry;
    }

    public static function getInquiryList($userId, $searchKeyWord, $status, $limit)
    {
        $query = InquiryModel::with('inquiry_items')->select([
            'inquiry_id',
            'inquiry_sn',
            'create_time',
            'remark',
            'status'
        ])->where('user_id', $userId)->orderBy('inquiry_id', 'desc');
        if (!empty($searchKeyWord)) {
            $query->whereHas('inquiry_items', function ($q) use ($searchKeyWord) {
                $q->where('goods_name', 'like', "%$searchKeyWord%");
            })->orWhere('inquiry_sn', 'like', "%$searchKeyWord%");
        }
        if (!empty($status) || ($status === '0')) {
            $query->where('status', $status);
        }
        $result = $query->paginate($limit)->toArray();
        foreach ($result['data'] as &$item) {
            $item['create_time'] = date('Y-m-d H:i:s', $item['create_time']);
            $item['status_name'] = \Arr::get(config('field.inquiry_status'), $item['status']);
            $item['goods_name'] = \Arr::get(\Arr::get($item['inquiry_items'], 0), 'goods_name', '');
            unset($item['inquiry_items']);
        }
        unset($item);
        return $result;
    }

    public static function generateSn()
    {
        $maxInquiryId = InquiryModel::orderBy('inquiry_id', 'desc')->value('inquiry_id');
        $id = str_pad(($maxInquiryId + 1), 6, 0, STR_PAD_LEFT);
        $time = Carbon::now()->addMonths(-9)->addDays(-10)->timestamp;
        return 'XJ' . date('Ymd', $time) . $id;
    }

    public static function getStatusCount($userId)
    {
        $pending = InquiryModel::getInquiryCountByStatus($userId, InquiryModel::STATUS_PENDING);
        $processed = InquiryModel::getInquiryCountByStatus($userId, InquiryModel::STATUS_PROCESSED);
        $all = InquiryModel::getInquiryCountByStatus($userId);
        return compact('pending', 'processed', 'all');
    }

}