ship-expert/app/data/model/ShopPurchase.php

<?php

namespace app\data\model;

use app\data\model\helpers\PurchaseShow;
use Carbon\Carbon;
use think\admin\Model;
use think\db\Query;
use think\facade\Db;
use think\helper\Arr;

class ShopPurchase extends Model
{
    use PurchaseShow;
    protected $append=[
        'tab',
    ];
    protected $type=[
        'images'=>'array',
    ];
    public static $status=[
        0=>'已取消',
        1=>'未报价',
        2=>'已报价',
        3=>'已匹配',
    ];

    /**
     * @return string[]
     */
    public static function getStatus(): array
    {
        return self::$status;
    }
    public function merchant(){
        return $this->belongsTo(DataMerchants::class,'admin_id','admin_id');
    }
    public function items(){
        return $this->hasMany(ShopPurchaseItem::class,'purchase_id');
    }
    public function favourite(){
        return $this->morphMany(ShopFavourite::class,'target',$this->getTable());
    }
    public function msgs(){
        return $this->morphMany(ShopPurchaseMsg::class,'target',$this->getTable());
    }

    /**
     * @return static
     */
    public static function getQuery($tab){
        $arr=[
            1=>new ShopPurchase,
            2=>new ShopProduction,
            3=>new ShopCoordination,
            4=>new ShopOcean,
        ];
        return Arr::get($arr, $tab)->newQuery()->show();
    }
    /**
     * @return static
     */
    public static function getOffer($tab){
        $arr=[
            1=>new ShopPurchaseOffer,
            2=>new ShopProductionOffer,
            3=>new ShopCoordinationOffer,
            4=>new ShopOceanOffer,
        ];
        return Arr::get($arr,$tab)->newQuery();
    }
    /**
     * @return static
     */
    public static function getItem($tab,$admin_id=null){
        $arr=[
            1=>new ShopPurchaseItem,
            2=>new ShopProduction,
            3=>new ShopCoordination,
            4=>new ShopOcean,
        ];
        $query=Arr::get($arr,$tab)->newQuery();
        if(!is_null($admin_id)){
            if($tab==1){
                $query->whereExists(
                    ShopPurchase::where('admin_id',$admin_id)
                        ->where('id',Db::raw("{$query->getTable()}.purchase_id"))
                        ->buildSql()
                );
            }else{
                $query->where('admin_id',$admin_id);
            }
        }
        return $query;
    }
    public static function getOfferKey($tab){
        $arr=[
            1=>'order_id',
            2=>'production_id',
            3=>'corrdination_id',
            4=>'ocea_id',
        ];
        return Arr::get($arr,$tab);
    }
    public static function is_fav($model,$user){
        $model['is_fav']=(bool)$model->favourite()->where('user_id',$user['id'])->value('id');
    }
    public function getTabAttr(){
        return 1;
    }
    public static function onBeforeInsert(self $model)
    {
        $model['order_no']=sprintf('%s%s','Cbz',str_replace(['-',' ','.',':'],'',Carbon::now()->toDateTimeString('microsecond')));
    }

}