screen/application/common/model/OrderGoods.php

<?php

namespace app\common\model;



use app\admin\model\Orders;
use think\Db;
use think\db\Query;
use think\Model;

/**
 * @method Query|static filterAdmin($admin_id)
 */
class OrderGoods extends Model
{
    public static function unique(OrderInfo $orderInfo){
        self::insert([
            'goods_id'=>$orderInfo['goods_id'],
            'order_id'=>$orderInfo['order_id'],
        ],true);
    }
    public function scopeFilterAdmin(Query $query,$admin_id){
        $table=$this->getTable();
        $query->whereExists(
            Orders::whereRaw("orders.id={$table}.order_id and orders.admin_id=$admin_id")->buildSql()
        );
    }
    public function scopeFilterDate(Query $query, $date, $column = 'create_time', $dateType = 'timestamp')
    {
        $query->whereExists(
            Orders::where('id',Db::raw('order_goods.order_id'))->filterDate($date,$column,$dateType)->buildSql()
        );
    }
}