mtb_store_frontend/app/Models/DistInquiry.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class DistInquiry extends Model
{

    protected $table = 'dist_inquiry';

    // 允许批量赋值的字段
    protected $fillable = [
        'order_number',
        'whats_app',
        'company_name',
        'customer_name',
        'email',
        'consulting_products',
        'freight_forwarder',
        'business_model',
        'ip_address',
        'status',
        'allocate_time',
        'content',
        'dist_id',
        'referer_url',
    ];

    /*
     * 关联到分销商
     */
    public function distributor()
    {
        return $this->hasOne(DistAdminDistributor::class,'id', 'dist_id');
    }

    /*
     * 生成订单号
     */
    public static function generateOrderNumber()
    {
        // 获取当前日期，格式为YYYYMMDD
        $date = now()->format('Ymd');

        // 查询当天订单数量
        $todayOrderCount = self::whereDate('created_at', Carbon::today())->count();

        // 订单号：日期 + 当天订单数量 + 1
        $orderNumber = $date . str_pad($todayOrderCount + 1, 4, '0', STR_PAD_LEFT);

        return 'Q'.$orderNumber;
    }
}