<?php namespace App\Modules\Book\Models; use Illuminate\Database\Eloquent\Model; use DB; class BookOrderStatistical extends Model { protected $table = 'book_order_statistical'; public static function getTopSaleBooks($start_time,$end_time,array $on_shelf,$limit=10){ return self::join('book_configs','book_order_statistical.bid','=','book_configs.bid') ->select('book_order_statistical.bid') ->whereIn('book_configs.is_on_shelf',$on_shelf) ->where('book_order_statistical.day','>=',$start_time) ->where('book_order_statistical.day','<=',$end_time) ->groupBy('book_order_statistical.bid') ->orderBy(DB::raw('sum(book_order_statistical.fee)'),'desc') ->limit($limit) ->get(); } }