/**
* 个人佣金详细
* @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);
}
/**
* 生成订单
* @return string
* @author zhengqian@dajiayao.cc
*/
public function create()
{
// $inputData = $this->inputData->all();
$buyerId = $this->buyerId;
$wxUser = Buyer::find($buyerId)->wxUser;
if (!$wxUser) {
return RestHelp::encodeResult(24000, "user illegality");
}
$inputData = json_decode(file_get_contents("php://input"), true);
$validator = Validator::make($inputData, ['shopShortId' => 'required', 'items' => 'required', 'deliverAddressId' => 'required', 'paymentType' => 'required', "shopType" => '', 'orderNumber' => '', "isAnonymous" => 'required|Boolean']);
if ($validator->fails()) {
return RestHelp::parametersIllegal($validator->messages()->first());
}
if (!isset($inputData['items']) or !is_array($inputData['items'])) {
return RestHelp::encodeResult(23003, 'item must be array');
}
$objShop = Shop::getShopByShort($inputData['shopShortId']);
if (!$objShop) {
return RestHelp::encodeResult(21000, sprintf("shop short id %s not found in db", $inputData['shopShortId']));
}
$deliver = BuyerAddress::find($inputData['deliverAddressId']);
if (!$deliver) {
return RestHelp::encodeResult(23001, sprintf("deliver address id: %s not found in db", $inputData['deliverAddressId']));
}
if (!isset($inputData['orderNumber'])) {
$orderNumber = OrderHelper::getOrderSerialNumber();
} else {
$orderNumber = $inputData['orderNumber'];
}
$deliverAddressId = $inputData['deliverAddressId'];
$shopId = $objShop->id;
$itemTotal = 0;
$postageFlag = 0;
$shelfItems = $objShop->getItemsOnShelf();
//检查商品合法性、库存等等
foreach ($inputData['items'] as $item) {
if (!array_key_exists('id', $item) or !array_key_exists('count', $item)) {
return RestHelp::encodeResult(23005, "items not correct");
}
$objItem = Item::find($item['id']);
$itemTotal += $objItem->price * $item['count'];
if ($objItem->postage_type == Item::POSTAGE_TYPE_BUYER) {
$postageFlag++;
}
if ($objItem->sale_status == Item::SALE_STATUS_NO) {
return RestHelp::encodeResult(23006, sprintf("%s已停售", $objItem->title));
}
if ($objItem->shelf_status == Item::SHELF_STATUS_NO or !array_key_exists($objItem->id, $shelfItems)) {
return RestHelp::encodeResult(23006, sprintf("%s已下架", $objItem->title));
}
//库存
if ($objItem->stock < $item['count']) {
return RestHelp::encodeResult(23006, sprintf("%s库存不足", $objItem->title));
}
}
$postage = $postageFlag ? $this->settingService->getSettingByKey(Setting::KEY_ORDER_POSTAGE)->value : 0;
$grandTotal = $itemTotal + $postage;
$sessionTotal = WxUserKv::getValue(Buyer::find($this->buyerId)->wxUser->id, WxUserKv::BUYER_CHECK_PRICE);
if ((string) $sessionTotal != (string) $grandTotal) {
return RestHelp::encodeResult(22002, "illegal operation");
}
$discount = 0;
$orderType = Order::PAYMENT_TYPE_WX;
//如果传入了订单号
if (isset($inputData['orderNumber'])) {
//update
$objOrder = Order::where('order_number', $inputData['orderNumber'])->first();
if (!$objOrder) {
return RestHelp::encodeResult(22001, "the order not found");
}
//new
try {
$orderId = $this->orderService->update($objOrder, $itemTotal, $grandTotal, $discount, $grandTotal - $discount, $inputData['isAnonymous'] ? 1 : 0, $postage, $orderType, $deliverAddressId);
} catch (\Exception $e) {
return RestHelp::encodeResult(23004, $e->getMessage());
}
} else {
//new
try {
$orderId = $this->orderService->create($orderNumber, $shopId, $this->buyerId, $itemTotal, $grandTotal, $discount, $grandTotal - $discount, $postage, $orderType, $deliverAddressId, $inputData['isAnonymous'] ? 1 : 0, null, null);
} catch (\Exception $e) {
return RestHelp::encodeResult(23004, $e->getMessage());
}
//减少库存
$commissonTotal = 0;
foreach ($inputData['items'] as $item) {
$objItem = Item::find($item['id']);
$objItem->stock -= $item['count'];
$objItem->save();
//计算挨个佣金
$commissonTotal += $objItem->commission * $item['count'];
}
//生成佣金表数据
$commisson = OrderCommission::firstOrNew(['order_id' => $orderId]);
$commisson->amount = $objShop->is_direct_sale == 'Y' ? 0 : $commissonTotal;
$commisson->status = OrderCommission::STATUS_UNCONFIRMED;
$commisson->save();
//生成seller commisson
$sellerCommission = SellerCommission::firstOrNew(['order_id' => $orderId, 'seller_id' => $objShop->seller_id]);
$sellerCommission->amount = $objShop->is_direct_sale == 'Y' ? 0 : $commissonTotal;
$sellerCommission->status = SellerCommission::STATUS_UNCONFIRMED;
$sellerCommission->save();
}
$subject = '';
//32
$body = '';
//128
$itemIdList = \DB::table('order_items')->where('order_id', $orderId)->lists('item_id');
foreach ($inputData['items'] as $item) {
if (isset($inputData['orderNumber'])) {
$orderItem = OrderItem::where('order_id', $orderId)->where('item_id', $item['id'])->first();
$quantity = $orderItem ? $orderItem->quantity : 0;
$count = $item['count'];
$balance = $count - $quantity;
$objItem = Item::find($item['id']);
$objItem->stock -= $balance;
$objItem->save();
OrderItem::where('order_id', $orderId)->where('item_id', $item['id'])->forceDelete();
//如果支付失败，返回修改删除了某个商品，则恢复库存 Step 1 @author zhengqian
foreach ($itemIdList as $k => $itid) {
if ($item['id'] == $itid) {
unset($itemIdList[$k]);
}
}
}
$orderItem = new OrderItem();
$orderItem->order_id = $orderId;
$orderItem->item_id = $item['id'];
$objItem = Item::find($item['id']);
$orderItem->name = $objItem->name;
$subject .= $objItem->title . "*" . $objItem->spec . "*" . $objItem->{$item}['count'] . ",";
$body .= $objItem->title . $objItem->spec . $objItem->{$item}['count'];
$orderItem->title = $objItem->title;
$orderItem->code = $objItem->code;
$orderItem->barcode = $objItem->barcode;
$orderItem->type = ItemType::find($objItem->type_id)->name;
$orderItem->quantity = $item['count'];
$orderItem->price = $objItem->price;
$orderItem->item_total = $objItem->price * $item['count'];
$commissionsRate = $this->settingService->getSettingByKey(Setting::KEY_COMMISSIONS_RATE);
if (!$commissionsRate) {
$commissionsRate = Setting::DEFAULT_KEY_COMMISSIONS_RATE;
} else {
$commissionsRate = $commissionsRate->value;
}
$orderItem->commission = $orderItem->item_total * $commissionsRate;
$orderItem->save();
}
//如果支付失败，返回修改删除了某个商品，则恢复库存 Step 2 @author zhengqian
if (isset($inputData['orderNumber'])) {
foreach ($itemIdList as $itid) {
$orderItem = OrderItem::where('order_id', $orderId)->where('item_id', $itid)->first();
$quantity = $orderItem->quantity;
$objItem = Item::find($itid);
$objItem->stock += $quantity;
$objItem->save();
OrderItem::where('order_id', $orderId)->where('item_id', $itid)->forceDelete();
}
}
$payment = new Payment();
$payment->serial_number = OrderHelper::getPaymentSerialNumber(1);
$payment->payment_number = '';
$payment->order_id = $orderId;
$payment->order_number = Order::find($orderId)->order_number;
$payment->buyer_id = $this->buyerId;
$payment->amount = $itemTotal;
$payment->channel = Payment::PAYMENT_CHANNEL_PXX;
$payment->type = Payment::PAYMENT_TYPE_WX;
$payment->status = Order::PAY_STATUS_NO;
$payment->save();
try {
\Pingpp\Pingpp::setApiKey('sk_live_3dKEivmziedjzitFhaHL7gYF');
$ch = \Pingpp\Charge::create(array('order_no' => $payment->serial_number, 'app' => array('id' => 'app_XTOW5SXTWLGCGKef'), 'channel' => 'wx_pub', 'amount' => $sessionTotal * 100, 'client_ip' => $this->inputData->ip(), 'currency' => 'cny', 'subject' => mb_substr($subject, 0, 32), 'body' => mb_substr($body, 0, 128), 'extra' => array('open_id' => $wxUser->openid)));
} catch (\Exception $e) {
return RestHelp::encodeResult(22003, $e->getMessage(), ['orderNum' => $orderNumber]);
}
//写入paytmentLOg
$paymentLog = new PaymentLog();
$paymentLog->payment_id = $payment->id;
$paymentLog->channel = Payment::PAYMENT_CHANNEL_PXX;
$paymentLog->request_data = $ch;
$paymentLog->respond_data = '';
$paymentLog->save();
//保存支付流水号
$payment->payment_number = json_decode($ch)->id;
$payment->save();
return RestHelp::success(['orderNumber' => $orderNumber, 'paymentNumber' => $payment->serial_number, 'charge' => json_decode($ch, true)]);
}
function getSellerCommissionByOrder($sellerId, $orderId)
{
$query = SellerCommission::where('order_id', $orderId)->where('seller_id', $sellerId);
return $query->first();
}
/**
* 用于接收 p++ 支付结果的回调地址
* @author zhengqian@dajiayao.cc
*/
public function payCallBack()
{
$input = file_get_contents("php://input");
\Log::info(sprintf("input: %s", $input));
$objPayResult = json_decode($input);
$payment = Payment::where('payment_number', $objPayResult->id)->first();
if (!$payment) {
\Log::info(sprintf("the payment_number : %s not found in db", $objPayResult->id));
return;
}
//写入支付日志
$paymentLog = PaymentLog::where('payment_id', $payment->id)->first();
if (!$paymentLog) {
return;
}
$order = $payment->order;
$paymentLog->respond_data = $input;
$paymentLog->save();
if ($objPayResult->paid == true) {
//修改订单状态
$order->payment_serial_number = $payment->serial_number;
$order->payment_id = $payment->id;
$order->payment_status = Order::PAY_STATUS_YES;
$order->status = Order::STATUS_TO_DELIVER;
$order->save();
//支付状态
$payment->status = Payment::PAYMENT_STATUS_SUCCESS;
$payment->save();
//佣金状态
$commission = OrderCommission::where('order_id', $order->id)->first();
if (!$commission) {
return;
}
$commission->status = OrderCommission::STATUS_CONFIRMED;
$commission->save();
//seller commission
$sellerCommission = SellerCommission::firstOrNew(['order_id' => $order->id, 'seller_id' => $order->shop->seller_id, 'amount' => $commission->amount]);
$sellerCommission->status = SellerCommission::STATUS_CONFIRMED;
$sellerCommission->save();
//将销售额存入redis
$orderItems = $order->orderItems;
foreach ($orderItems as $orderItem) {
$quantity = $orderItem->quantity;
$this->redis->incrby("dajiayao:mall:item:sellcount:" . $orderItem->item_id, $quantity);
$wxUser = $orderItem->order->buyer->wxUser;
$header = $wxUser->headimgurl;
if ($order->is_anonymous == 1 or !$header) {
continue;
}
$this->redis->sadd("dajiayao:mall:item:buyers:" . $orderItem->item_id, json_encode(['name' => $wxUser->nickname, 'avatar' => $header]));
}
//微信消息推送
$this->buyerService->sendNewOrderMsg($order);
$this->sellerService->sendPaidMsg($order);
} elseif ($objPayResult->paid == false) {
//支付状态
$payment->status = Payment::PAYMENT_STATUS_FAIL;
$payment->save();
} else {
return;
}
return "success";
}