/** * 个人佣金详细 * @author zhengqian@dajiayao.cc */ public function commissionDetail() { //所有佣金 $sellerCommissions = SellerCommission::where('seller_id', $this->sellerId)->get(); $commisionTotal = 0; foreach ($sellerCommissions as $rowCommission) { $commisionTotal += $rowCommission->amount; } //已经提取的佣金 $drawedCommissions = WithDrawCommission::where('seller_id', $this->sellerId)->where('status', WithDrawCommission::STATUS_DRAWED)->get(); $drawedCommissionTotal = 0; foreach ($drawedCommissions as $drawedCommission) { $drawedCommissionTotal += $drawedCommission->amount; } //可以提取的佣金 $avaliableCommission = $commisionTotal - $drawedCommissionTotal; }
public function applyList() { $input = $this->inputData; if (!array_key_exists('status', $input)) { $drawCommissionList = WithDrawCommission::paginate(20); } else { $drawCommissionList = WithDrawCommission::where('status', $input['status'])->paginate(20); } $cacheArr = array(); foreach ($drawCommissionList as $k => $rawDrawCommission) { if (!array_key_exists($rawDrawCommission->seller_id, $cacheArr)) { $sellerId = $rawDrawCommission->seller_id; //所有佣金 $sellerCommissions = SellerCommission::where('seller_id', $sellerId)->get(); $commisionTotal = 0; foreach ($sellerCommissions as $rowCommission) { $commisionTotal += $rowCommission->amount; } //已经确认的佣金 $sellerConfirmedCommissions = SellerCommission::where('seller_id', $sellerId)->where('status', SellerCommission::STATUS_CONFIRMED)->get(); $commisionConfirmTotal = 0; foreach ($sellerConfirmedCommissions as $rowCommission) { $commisionConfirmTotal += $rowCommission->amount; } //已经提取的佣金 $drawedCommissions = WithDrawCommission::where('seller_id', $sellerId)->where('status', WithDrawCommission::STATUS_DRAWED)->get(); $drawedCommissionTotal = 0; foreach ($drawedCommissions as $drawedCommission) { $drawedCommissionTotal += $drawedCommission->amount; } //可以提取的佣金 $rawDrawCommission->availableCommission = $commisionConfirmTotal - $drawedCommissionTotal; $rawDrawCommission->commissionTotal = $commisionTotal; $cacheArr[$rawDrawCommission->seller_id] = $rawDrawCommission; } else { $drawCommissionList[$k] = $cacheArr[$rawDrawCommission->seller_id]; } } return view('admin.commission.apply_list')->with('draw_lists', $drawCommissionList)->with('input', $input); }
function getSellerCommissionByOrder($sellerId, $orderId) { $query = SellerCommission::where('order_id', $orderId)->where('seller_id', $sellerId); return $query->first(); }