// +---------------------------------------------------------------------- declare (strict_types = 1); namespace app\api\model; use app\api\service\User as UserService; use app\common\enum\goods\GoodsType; use app\common\library\helper; use app\common\model\OrderGoods as OrderGoodsModel; use app\common\model\OrderRefund; use app\common\model\user\CommissionsDetail; use app\api\model\user\CommissionsDetail as CommissionsDetailApi; /** * 订单商品模型 * Class OrderGoods * @package app\api\model */ class OrderGoods extends OrderGoodsModel { const CLEARING_WAIT = 0; const CLEARING_FINISHED = 1; /** * 隐藏字段 * @var array */ protected $hidden = [ 'content', 'store_id', 'create_time', ]; protected $append = ['image_text','buyer']; /** * 获取未评价的商品 * @param int $orderId 订单ID * @return \think\Collection * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public static function getNotCommentGoodsList(int $orderId) { return (new static)->with(['image']) ->where('order_id', '=', $orderId) ->where('is_comment', '=', 0) ->where('goods_type','<>',20) ->select(); } /** * 销售额合计 * @param $orderGoodsIds * @param $from * @param $to * @return float */ public static function sumGiveOutOrder($userId){ $user = User::find($userId); $month= intval(date('m')); $year = intval(date('Y')); $from = mktime(0,0,0,$month,1,$year); $to = time(); //v1.3.92 $wheres = []; if ($user->role == User::SHOP_BOSS || $user->role == User::SHOP_MG){ $wheres[] = ['user_id','=',$userId]; $wheres[] = ['order_create_time','>=',$from]; $wheres[] = ['order_create_time','<=',$to]; $wheres[] = ['clearing_status','<',2]; }elseif($user->role == User::SHOP_SELLER){ $wheres[] = ['user_id','=',$userId]; $wheres[] = ['shop_id','=',$user->shop_id]; $wheres[] = ['order_create_time','>=',$from]; $wheres[] = ['order_create_time','<=',$to]; $wheres[] = ['clearing_status','<',2]; }elseif($user->role == User::COMMISSION_USER){ $wheres[] = ['user_id','=',$userId]; $wheres[] = ['shop_id','=',0]; $wheres[] = ['commission_level','=',1]; $wheres[] = ['order_create_time','>=',$from]; $wheres[] = ['order_create_time','<=',$to]; $wheres[] = ['clearing_status','<',2]; }else{ $wheres[] = ['user_id','=',$userId]; $wheres[] = ['order_create_time','>=',$from]; $wheres[] = ['order_create_time','<=',$to]; $wheres[] = ['clearing_status','<',2]; } return CommissionsDetail::sumOrderSaleVolume($wheres); /* if ($user->role == User::SHOP_BOSS || $user->role == User::SHOP_MG){ //店长和老板查所有的门店的所有订单 $orderGoodsIds = CommissionsDetail::field('order_goods_id')->where('user_id',$userId) ->where('is_shop_commission',0)->whereBetweenTime('create_time',$from,$to) ->where('clearing_status','<',2)->column('order_goods_id'); }elseif($user->role == User::SHOP_SELLER){ $orderGoodsIds = CommissionsDetail::field('order_goods_id')->where('user_id',$userId) ->where('shop_id',$user->shop_id) ->where('is_shop_commission',0)->whereBetweenTime('create_time',$from,$to) ->where('clearing_status','<',2)->column('order_goods_id'); }elseif($user->role == User::COMMISSION_USER){ $orderGoodsIds = CommissionsDetail::field('order_goods_id')->where('user_id',$userId) ->where('is_shop_commission',0) ->where('commission_level',1) ->whereBetweenTime('create_time',$from,$to) ->where('clearing_status','<',2)->column('order_goods_id'); }else{ $orderGoodsIds = CommissionsDetail::field('order_goods_id')->where('user_id',$userId) ->where('is_shop_commission',0)->whereBetweenTime('create_time',$from,$to) ->where('clearing_status','<',2)->column('order_goods_id'); } $orderGoodsIds = array_unique($orderGoodsIds); return helper::bcadd(\app\console\model\OrderGoods::getUserSellerVolume($orderGoodsIds,$from,$to),0,2);*/ } public function getImageTextAttr($value) { return UploadFile::field('file_id,file_type,storage,domain,file_path')->find($this->image_id); } public function getBuyerAttr($value) { return User::with(['avatar'])->field('user_id,nick_name,avatar_id')->find($this->user_id); } public static function countUserOrder($userId,$orderIds){ return OrderGoods::alias('og') ->field('og.goods_price,og.total_num,og.distributor_goods_price,og.has_refund_act,og.order_id') ->leftJoin('order','og.order_id=order.order_id') ->whereIn('og.order_id',$orderIds)->where('order.pay_status',20)//->where('order.pay_type','=',20)todo 211213 ->where('order.receipt_status',20) ->where('og.user_id',$userId)->where('og.has_refund_full',0)->count(); //return self::whereIn('order_id',$orderIds)->where('user_id',$userId)->where('has_refund_full',0)->count(); } public static function sumUserOrder($userId,$orderIds){ $orderGoodses = OrderGoods::alias('og') ->field('og.goods_price,og.total_num,og.distributor_goods_price,og.has_refund_act,og.order_id,og.total_price,og.distributor_total_money') ->leftJoin('order','og.order_id=order.order_id') ->whereIn('og.order_id',$orderIds)->where('order.pay_status',20)//->where('order.pay_type','=',20)todo 211213 ->where('order.receipt_status',20) ->where('og.user_id',$userId) ->where('og.has_refund_full',0)->select(); $sum = 0; foreach ($orderGoodses as $orderGoods){ $refundNum=0; if ($orderGoods->has_refund_act == 1){ ////如果有退款,并且财务已打款 $refund = OrderRefund::where('order_goods_id',$orderGoods->order_goods_id)->where('finance_refund',10)->find(); $refundNum = $refund?$refund->goods_num:0; } //$sum += ($orderGoods->total_num - $refundNum)*($orderGoods->goods_price - $orderGoods->distributor_goods_price); $sum += ($orderGoods->total_num - $refundNum)*($orderGoods->total_price - $orderGoods->distributor_total_money)/$orderGoods->total_num; } return helper::bcsub($sum,0,2); } public function dailySalesTj($shopId,$from,$to){ //统计前一天的数据 $res = $this->where('shop_id',$shopId) ->whereBetweenTime('create_time',$from,$to)//mysql 对int类型的 between and包含左右边界 /* ->where('create_time','>=',$from) ->where('create_time','<=',$to)*/ ->where('goods_type','<>',20) ->field('sum(total_price) as total_goods_price,sum(total_pay_price + rice_card_money) as total_pay_price,sum(coupon_money) as coupon_money,count(distinct order_id) as order_count') ->find(); $res['total_goods_price'] = $res['total_goods_price']?:0; $res['total_pay_price'] = $res['total_pay_price']?:0; $res['coupon_money'] = $res['coupon_money']?:0; //店老板基本分佣 $res['boss_comm_money'] = CommissionsDetailApi::sumUserCommission($shopId,User::SHOP_BOSS,$from,$to); //dd($comBoss); //店长基本分佣 $res['mg_comm_money'] = CommissionsDetailApi::sumUserCommission($shopId,User::SHOP_MG,$from,$to); //店员基本分佣 $res['seller_comm_money'] = CommissionsDetailApi::sumUserCommission($shopId,User::SHOP_SELLER,$from,$to); return $res->toArray(); } /** * 添加商品销量 * @param $from * @param $to * @return OrderGoods|array|\think\Model|null * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author: zjwhust * @Time: 2022/3/30 16:39 */ public function addGoodsSalesRank($from,$to){ $res = $this->whereBetweenTime('create_time',$from,$to)//mysql 对int类型的 between and包含左右边界 ->field('sum(total_pay_price + rice_card_money) as sale_volume,sum(total_num) as sale_nums,goods_id') ->where('goods_type','<>',GoodsType::GIFT) ->group('goods_id') ->select(); // dd(self::getLastSql()); return $res; } }