/**
* 付款成功通知
* @param $order
* @return bool
*/
public function sendPaidMsg($order)
{
$seller = $order->shop->seller;
if (!$seller->wxUser) {
return false;
}
$wxUser = Buyer::find($order->buyer_id)->wxUser;
$this->_newOrderData['touser'] = $seller->wxUser->openId;
$this->_newOrderData['template_id'] = Config::get('weixin.template_id.new_order_to_seller');
$this->_newOrderData['url'] = 'http://www.yayao.mobi';
//TODO
$this->_newOrderData['data']['keyword1']['value'] = '¥' . $order->amount_tendered;
// get order_items
$itemsStr = '';
$orderItems = $order->orderItems;
foreach ($orderItems as $oi) {
$itemsStr .= $oi->name . ' x' . $oi->quantity . ' ';
}
$this->_newOrderData['data']['keyword2']['value'] = $itemsStr;
// 商品名称
$this->_newOrderData['data']['keyword3']['value'] = $order->order_number;
// 订单号
$this->_newOrderData['data']['keyword4']['value'] = $wxUser->nickname;
$commission = 0;
$commissionService = new CommissionService();
$sellerCommission = $commissionService->getSellerCommissionByOrder($seller->id, $order->id);
if ($sellerCommission) {
$commission = $sellerCommission->amount;
}
$this->_newOrderData['data']['remark']['value'] = "佣金：¥" . $commission . '。该张订单完成后，店铺提成可以在我的佣金页申请提现。';
$this->_sendTplMsg($this->_newOrderData);
return true;
}
/**
* @获取用户信息
* @author zhengqian.zhu
*/
public function saveUserInfo()
{
$mq = new MQ();
$accessToken = $mq->getWeixinAccessTokenByName($this->type);
if (!$accessToken) {
throw new \Exception("get buyer access token error");
}
$userJson = WebAuth::getUserInfo($accessToken, $this->openid);
$wxUserId = WxUser::saveWxUser($userJson);
//保存卖家
$buyer = new Buyer();
$buyer->wx_user_id = $wxUserId;
$buyer->save();
Session::put('buyer_id', Buyer::where('wx_user_id', $wxUserId)->first()->id);
\Log::info(sprintf("buyer_id : %s", $buyer));
return $this->redirectRequestUrl();
}
/**
* 重新支付
* @return string
* @author zhengqian@dajiayao.cc
*/
public function rePay()
{
$buyerId = $this->buyerId;
$wxUser = Buyer::find($buyerId)->wxUser;
if (!$wxUser) {
return RestHelp::encodeResult(24000, "user illegality");
}
$inputData = $this->inputData->all();
$validator = Validator::make($inputData, ['orderNumber' => 'required']);
if ($validator->fails()) {
return RestHelp::parametersIllegal($validator->messages()->first());
}
$objOrder = Order::where('order_number', $inputData['orderNumber'])->first();
$objShop = Shop::find($objOrder->shop_id);
if (!$objShop) {
return RestHelp::encodeResult(21000, sprintf("shop short id %s not found in db", $objOrder->shop_id));
}
//查找价格
$itemTotal = $objOrder->item_total;
$grandTotal = $objOrder->grand_total;
$payment = new Payment();
$payment->serial_number = OrderHelper::getPaymentSerialNumber(1);
$payment->payment_number = '';
$payment->order_id = $objOrder->id;
$payment->order_number = $inputData['orderNumber'];
$payment->buyer_id = $buyerId;
$payment->amount = $itemTotal;
$payment->channel = Payment::PAYMENT_CHANNEL_PXX;
$payment->type = Payment::PAYMENT_TYPE_WX;
$payment->status = Order::PAY_STATUS_NO;
$payment->save();
$subject = '';
//32
$body = '';
//128
foreach ($objOrder->orderItems as $orderItem) {
$subject .= $orderItem->items->title . "*" . $orderItem->items->spec . "*" . $orderItem->quantity . ",";
$body .= $orderItem->items->title . $orderItem->items->spec . $orderItem->quantity;
}
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' => $grandTotal * 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' => $inputData['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' => $inputData['orderNumber'], 'paymentNumber' => $payment->serial_number, 'charge' => json_decode($ch, true)]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
// $this->call('UserTableSeeder');
DB::table('users')->truncate();
User::create(['id' => 1, 'username' => 'admin', 'email' => '*****@*****.**', 'password' => \Hash::make('11431143'), 'role' => User::ROLE_ADMIN, 'status' => User::STATUS_NORMAL]);
DB::table('suppliers')->truncate();
Supplier::create(['id' => 1, 'username' => 'nanpufood', 'email' => '*****@*****.**', 'title' => '南浦集团', 'description' => '快速消费品综合代理和营销集团', 'service_phone' => '021-61923399', 'status' => 1]);
//店铺
DB::table('shops')->truncate();
Shop::create(['id' => 1, 'short_id' => "yayao", 'province_id' => 310000, 'city_id' => 310100, 'county_id' => 310110, 'type' => 2, 'name' => '丫摇官方直营店', 'seller_id' => 1, 'thumbnail' => '', 'title' => '丫摇小店', 'subtitle' => '丫摇官方直营店', 'is_direct_sale' => Shop::IS_DIRECT_SALE_YES, 'banner' => '/images/banner_7.jpg', 'thumbnail' => '/images/logo_160.png']);
//卖家
DB::table('sellers')->truncate();
\Dajiayao\Model\Seller::create(['id' => 1, 'wx_user_id' => 1, 'mobile' => '15995420354', 'parent_id' => 0, 'realname' => '丫摇官方店主']);
\Dajiayao\Model\Seller::create(['id' => 2, 'wx_user_id' => 2, 'mobile' => '13800138000', 'parent_id' => 0, 'realname' => '测试店主']);
//微信user
DB::table('wx_users')->truncate();
\Dajiayao\Model\WxUser::create(['id' => 1, 'subscribe' => 1, 'openid' => 'oVtn9t9nmKQodGDQHLHfbHE_CDPI', 'nickname' => '小明', 'sex' => 1, 'city' => '苏州', 'country' => '中国', 'province' => '江苏', 'language' => 'zh_CN', 'role' => 2, 'headimgurl' => 'http://wx.qlogo.cn/mmopen/NWsF4EmJMsG8AeztibfdK5NWzAN6oX6PEwUOzeia9gzTvKW753aV0icuqTetiap4Tgf7q5sEdIaEstoa9hvvdlesuw/0']);
\Dajiayao\Model\WxUser::create(['id' => 2, 'subscribe' => 1, 'openid' => 'oVtn9t9nmKQodGDQHLHfbHE_CDPI', 'nickname' => '小明2', 'sex' => 1, 'city' => '苏州', 'country' => '中国', 'province' => '江苏', 'language' => 'zh_CN', 'role' => 2, 'headimgurl' => 'http://wx.qlogo.cn/mmopen/NWsF4EmJMsG8AeztibfdK5NWzAN6oX6PEwUOzeia9gzTvKW753aV0icuqTetiap4Tgf7q5sEdIaEstoa9hvvdlesuw/0']);
DB::table('items')->truncate();
Item::create(['id' => 1, 'name' => '星巴克 星冰乐咖啡', 'title' => '星巴克 星冰乐咖啡', 'code' => '1234', 'barcode' => '678952135', 'type_id' => 1, 'supplier_id' => 1, 'spec' => '摩卡味 281ml', 'weight' => 281, 'volume' => 281, 'price' => 18, 'market_price' => 28, 'stock' => 10000, 'shelf_status' => 1, 'sale_status' => 1, 'comment' => '真便宜啊', 'postage_type' => 2]);
Item::create(['id' => 2, 'name' => '星巴克 星冰乐咖啡', 'title' => '星巴克 星冰乐 香草味 咖啡饮料 281ml*6美国进口', 'code' => '1235', 'barcode' => '678952185', 'type_id' => 1, 'supplier_id' => 1, 'spec' => '摩卡味 281ml * 6', 'weight' => 1686, 'volume' => 1686, 'price' => 108, 'market_price' => 168, 'stock' => 10000, 'shelf_status' => 1, 'sale_status' => 1, 'comment' => '真的很便宜啊', 'postage_type' => 2]);
Item::create(['id' => 3, 'name' => '星巴克 星冰乐咖啡', 'title' => '星巴克 星冰乐 摩卡 咖啡饮料 281ml*6美国进口', 'code' => '1236', 'barcode' => '678952165', 'type_id' => 1, 'supplier_id' => 1, 'spec' => '摩卡味 281ml * 6', 'weight' => 1686, 'volume' => 1686, 'price' => 108, 'market_price' => 168, 'stock' => 10000, 'shelf_status' => 1, 'sale_status' => 1, 'comment' => '买买买啊', 'postage_type' => 2]);
DB::table('shop_items')->truncate();
\Dajiayao\Model\ShopItem::create(["shop_id" => 1, "item_id" => 1, "stock" => 1000, "sort" => 1, "is_single" => 1]);
\Dajiayao\Model\ShopItem::create(["shop_id" => 1, "item_id" => 2, "stock" => 1000, "sort" => 1, "is_single" => 1]);
\Dajiayao\Model\ShopItem::create(["shop_id" => 1, "item_id" => 3, "stock" => 1000, "sort" => 1, "is_single" => 1]);
DB::table('images')->truncate();
\Dajiayao\Model\Image::create(['url' => '/images/product.jpg', 'name' => '星巴克', 'type' => 1]);
DB::table('item_images')->truncate();
\Dajiayao\Model\ItemImage::create(['item_id' => 1, 'image_id' => 1]);
\Dajiayao\Model\ItemImage::create(['item_id' => 2, 'image_id' => 1]);
\Dajiayao\Model\ItemImage::create(['item_id' => 3, 'image_id' => 1]);
DB::table('item_type')->truncate();
ItemType::create(['id' => 1, 'name' => '饮料', 'sort' => 1]);
ItemType::create(['id' => 2, 'name' => '酒类', 'sort' => 2]);
ItemType::create(['id' => 3, 'name' => '坚果', 'sort' => 3]);
DB::table('expresses')->truncate();
\Dajiayao\Model\Express::create(['name' => '圆通', 'code' => 'yuantong', 'website' => 'http://www.yto.net.cn', 'phone' => '95554']);
\Dajiayao\Model\Express::create(['name' => '申通', 'code' => 'shentong', 'website' => 'http://www.sto.cn', 'phone' => '95543']);
\Dajiayao\Model\Express::create(['name' => '韵达', 'code' => 'yunda', 'website' => 'http://www.yundaex.com', 'phone' => '400-821-6789']);
\Dajiayao\Model\Express::create(['name' => '顺丰', 'code' => 'shunfeng', 'website' => 'http://www.sf-express.com', 'phone' => '95338']);
DB::table('settings')->truncate();
\Dajiayao\Model\Setting::create(['key' => 'commissions:rate', 'name' => '佣金比例', 'value' => '0.1', 'description' => '佣金 ＝ 实际成交价 x 佣金比例', 'parent_id' => 0]);
\Dajiayao\Model\Setting::create(['key' => 'order:payment:duration', 'name' => '订单最晚支付时间', 'value' => '1', 'parent_id' => 0]);
\Dajiayao\Model\Setting::create(['key' => 'order:auto:receive:duration', 'name' => '发货后自动收货时间', 'value' => '36', 'parent_id' => 0]);
\Dajiayao\Model\Setting::create(['key' => 'order:postage', 'name' => '统一邮费', 'value' => '10', 'parent_id' => 0]);
DB::table('buyers')->truncate();
\Dajiayao\Model\Buyer::create(['id' => 2, 'wx_user_id' => 2, 'mobile' => '18600186000', 'subscribe_status' => 1]);
DB::table('buyer_addresses')->truncate();
\Dajiayao\Model\BuyerAddress::create(['buyer_id' => 2, 'address_id' => 320507, 'address' => '相城区元和街道', 'postcode' => 215000, 'receiver' => 'zzq', 'mobile' => 159987548, 'default' => 1]);
}
/**
* 取消订单，通知买家
* @param $order
* @return bool
* TODO
*/
public function sendCancelOrderMsg($order)
{
$wxUser = Buyer::find($order->buyer_id)->wxUser;
$this->_cancelOrderData['touser'] = $wxUser->openid;
$this->_cancelOrderData['template_id'] = Config::get('weixin.template_id.cancel_order');
$this->_cancelOrderData['url'] = 'http://www.yayao.mobi';
//TODO
$this->_cancelOrderData['data']['orderProductPrice'] = $order->amount_tendered;
// 订单金额
// get order_items
$itemsStr = '';
$orderItems = $order->orderItems;
foreach ($orderItems as $oi) {
$itemsStr .= $oi->name . ' x' . $oi->quantity;
}
$this->_cancelOrderData['data']['orderProductName'] = $itemsStr;
// 商品详情
$this->_cancelOrderData['data']['orderAddress'] = $order->receiver_full_address;
// 收货信息
$this->_cancelOrderData['data']['orderName'] = $order->order_number;
// 订单号
$this->_sendTplMsg($this->_cancelOrderData);
return true;
}
/**
* 核实订单,库存
* @return string
* @author zhengqian@dajiayao.cc
*/
public function check()
{
$inputData = $this->inputData->only('items', 'shopShortId');
$items = $inputData['items'];
if (!is_array($items)) {
return RestHelp::encodeResult(22000, 'item must be array');
}
$arrRet = array();
$postageFlag = 0;
$totalPrice = 0;
$objShop = Shop::getShopByShort($inputData['shopShortId']);
if (!$objShop) {
return RestHelp::encodeResult(21000, "shop not found");
}
$shelfItems = $objShop->getItemsOnShelf();
$resultFlag = true;
$warning = '';
foreach ($items as $k => $item) {
$arrRet[$k]['result'] = true;
$arrRet[$k]['id'] = $item['id'];
$objItem = Item::find($item['id']);
if ($objItem->sale_status == Item::SALE_STATUS_NO) {
$arrRet[$k]['result'] = false;
$resultFlag = false;
$warning = sprintf("%s 已停售", $objItem->name);
break;
}
if ($objItem->shelf_status == Item::SHELF_STATUS_NO or !array_key_exists($objItem->id, $shelfItems)) {
$arrRet[$k]['result'] = false;
$resultFlag = false;
$warning = sprintf("%s 已下架", $objItem->name);
break;
}
if ($objItem->stock < $item['count']) {
$arrRet[$k]['result'] = false;
$resultFlag = false;
$warning = sprintf("%s 库存不够", $objItem->name);
break;
}
if ($objItem->postage_type == Item::POSTAGE_TYPE_BUYER) {
$postageFlag++;
}
$totalPrice += $objItem->price * $item['count'];
}
$postage = $postageFlag ? $this->settingService->getSettingByKey(Setting::KEY_ORDER_POSTAGE)->value : 0;
$grandTotal = $totalPrice + $postage;
//检查合法后将价格，总价放入DB,后期用于检查
if ($resultFlag) {
$user = Buyer::find($this->buyerId)->wxUser;
WxUserKv::setValue($user->id, WxUserKv::BUYER_CHECK_PRICE, $grandTotal);
}
return RestHelp::success(['result' => $resultFlag, 'postage' => $postage, 'grandTotal' => $grandTotal, 'warning' => $warning, 'detail' => $arrRet]);
}
/**
* 订单详情
* @author Hanxiang
* @param $number 订单号
* @return view
*/
public function detail($number)
{
$order = Order::where('order_number', $number)->first();
if (count($order) == 0) {
abort(404);
}
// Buyer Info
$buyer = Buyer::find($order->buyer_id);
if (count($buyer) == 0) {
$buyer = new \stdClass();
//TODO
$wxUser = new \stdClass();
//TODO
} else {
$wxUser = $buyer->wxUser;
}
$total = 0;
$quantity = 0;
$orderItems = OrderItem::where('order_id', $order->id)->get();
foreach ($orderItems as $oi) {
$total += $oi->item_total;
$quantity += $oi->quantity;
$supplier = Item::find($oi->item_id)->supplier;
$oi->supplier = $supplier;
}
$order->totalPrice = $total;
$order->totalQuantity = $quantity;
$expresses = Express::where('status', 1)->orderBy('sort')->get();
$express = Express::find($order->express_id);
if (count($express) == 0) {
$express = new \stdClass();
$express->name = '';
}
$order->expressObj = $express;
$commission = $order->commission;
if (!$commission) {
$commission = new \stdClass();
$commission->amount = 0;
$order->commission = $commission;
}
return view('admin.orders.detail')->with('order', $order)->with('buyer', $buyer)->with('wxUser', $wxUser)->with('orderItems', $orderItems)->with('expresses', $expresses);
}