| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783 |
- <?php
- /**
- * Niushop商城系统 - 团队十年电商经验汇集巨献!
- * =========================================================
- * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
- * ----------------------------------------------
- * 官方网址: https://www.niushop.com
- * =========================================================
- */
- namespace addon\seckill\model;
- use addon\store\model\StoreGoodsSku;
- use app\model\order\Order;
- use app\model\order\OrderCreate;
- use app\model\order\OrderCreateTool;
- use app\model\order\OrderRefund;
- use app\model\store\Store;
- use think\facade\Cache;
- use app\model\express\Express;
- use app\model\system\Pay;
- use app\model\express\Config as ExpressConfig;
- use app\model\order\Config;
- use app\model\express\Local;
- /**
- * 订单创建(秒杀)
- *
- * @author Administrator
- *
- */
- class SeckillOrderCreate extends OrderCreate
- {
- use OrderCreateTool;
- private $goods_money = 0;//商品金额
- private $balance_money = 0;//余额
- private $delivery_money = 0;//配送费用
- private $coupon_money = 0;//优惠券金额
- private $adjust_money = 0;//调整金额
- private $invoice_money = 0;//发票费用
- private $promotion_money = 0;//优惠金额
- private $order_money = 0;//订单金额
- private $pay_money = 0;//支付总价
- private $is_virtual = 0; //是否是虚拟类订单
- private $order_name = ''; //订单详情
- private $goods_num = 0; //商品种数
- private $member_balance_money = 0;//会员账户余额(计算过程中会逐次减少)
- private $pay_type = 'ONLINE_PAY';//支付方式
- private $invoice_delivery_money = 0;
- private $error = 0; //是否有错误
- private $error_msg = ''; //错误描述
- /**
- * 订单创建
- * @param unknown $data
- */
- public function create($data)
- {
- //查询出会员相关信息
- $calculate_data = $this->calculate($data);
- if (isset($calculate_data[ 'code' ]) && $calculate_data[ 'code' ] < 0)
- return $calculate_data;
- if ($this->error > 0) {
- return $this->error([ 'error_code' => $this->error ], $this->error_msg);
- }
- if (!empty($calculate_data[ 'invoice_type' ])) {
- if ($calculate_data[ 'invoice_type' ] == 1 && $calculate_data[ 'invoice_full_address' ] == "") {
- //物流,同城
- if ($calculate_data[ 'shop_goods_list' ][ 'delivery' ][ 'delivery_type' ] == "express" || $calculate_data[ 'shop_goods_list' ][ 'delivery' ][ 'delivery_type' ] == "local") {
- $calculate_data[ 'invoice_full_address' ] = $calculate_data[ 'member_address' ][ 'full_address' ] . $calculate_data[ 'member_address' ][ 'address' ];
- $calculate_data[ 'shop_goods_list' ][ 'invoice_full_address' ] = $calculate_data[ 'member_address' ][ 'full_address' ] . $calculate_data[ 'member_address' ][ 'address' ];
- }
- //门店
- if ($calculate_data[ 'shop_goods_list' ][ 'delivery' ][ 'delivery_type' ] == "store") {
- $delivery_store_info = json_decode($calculate_data[ 'shop_goods_list' ][ 'delivery_store_info' ], true);
- $calculate_data[ 'invoice_full_address' ] = $delivery_store_info[ 'full_address' ];
- $calculate_data[ 'shop_goods_list' ][ 'invoice_full_address' ] = $delivery_store_info[ 'full_address' ];
- }
- }
- }
- $pay = new Pay();
- $out_trade_no = $pay->createOutTradeNo($data[ 'member_id' ]);
- model('order')->startTrans();
- //循环生成多个订单
- try {
- $pay_money = 0;
- $shop_goods_list = $calculate_data[ 'shop_goods_list' ];
- $item_delivery = $shop_goods_list[ 'delivery' ] ?? [];
- $delivery_type = $item_delivery[ 'delivery_type' ] ?? '';
- $site_id = $data[ 'site_id' ];
- $delivery_type = $item_delivery[ 'delivery_type' ] ?? '';
- $express_type_list = ( new \app\model\express\Config() )->getExpressTypeList($site_id);
- // $delivery_type_name = Express::express_type[$delivery_type]['title'] ?? '';
- $delivery_type_name = $express_type_list[ $delivery_type ] ?? '';
- //订单主表
- $order_type = $this->orderType($shop_goods_list, $calculate_data);
- $order_no = $this->createOrderNo($shop_goods_list[ 'site_id' ], $data[ 'member_id' ]);
- $data_order = [
- 'order_no' => $order_no,
- 'site_id' => $shop_goods_list[ 'site_id' ],
- 'site_name' => $shop_goods_list[ 'site_name' ],
- 'order_from' => $data[ 'order_from' ],
- 'order_from_name' => $data[ 'order_from_name' ],
- 'order_type' => $order_type[ 'order_type_id' ],
- 'order_type_name' => $order_type[ 'order_type_name' ],
- 'order_status_name' => $order_type[ 'order_status' ][ 'name' ],
- 'order_status_action' => json_encode($order_type[ 'order_status' ], JSON_UNESCAPED_UNICODE),
- 'out_trade_no' => $out_trade_no,
- 'member_id' => $data[ 'member_id' ],
- 'name' => $calculate_data[ 'member_address' ][ 'name' ] ?? '',
- 'mobile' => $calculate_data[ 'member_address' ][ 'mobile' ] ?? '',
- 'telephone' => $calculate_data[ 'member_address' ][ 'telephone' ] ?? '',
- 'province_id' => $calculate_data[ 'member_address' ][ 'province_id' ] ?? '',
- 'city_id' => $calculate_data[ 'member_address' ][ 'city_id' ] ?? '',
- 'district_id' => $calculate_data[ 'member_address' ][ 'district_id' ] ?? '',
- 'community_id' => $calculate_data[ 'member_address' ][ 'community_id' ] ?? '',
- 'address' => $calculate_data[ 'member_address' ][ 'address' ] ?? '',
- 'full_address' => $calculate_data[ 'member_address' ][ 'full_address' ] ?? '',
- 'longitude' => $calculate_data[ 'member_address' ][ 'longitude' ] ?? '',
- 'latitude' => $calculate_data[ 'member_address' ][ 'latitude' ] ?? '',
- 'buyer_ip' => request()->ip(),
- 'goods_money' => $shop_goods_list[ 'goods_money' ],
- 'delivery_money' => $shop_goods_list[ 'delivery_money' ],
- 'coupon_id' => isset($shop_goods_list[ 'coupon_id' ]) ? $shop_goods_list[ 'coupon_id' ] : 0,
- 'coupon_money' => $shop_goods_list[ 'coupon_money' ] ?? 0,
- 'adjust_money' => $shop_goods_list[ 'adjust_money' ],
- 'invoice_money' => $shop_goods_list[ 'invoice_money' ],
- 'promotion_money' => $shop_goods_list[ 'promotion_money' ],
- 'order_money' => $shop_goods_list[ 'order_money' ],
- 'balance_money' => $shop_goods_list[ 'balance_money' ],
- 'pay_money' => $shop_goods_list[ 'pay_money' ],
- 'create_time' => time(),
- 'is_enable_refund' => 0,
- 'order_name' => $shop_goods_list[ "order_name" ],
- 'goods_num' => $shop_goods_list[ 'goods_num' ],
- 'delivery_type' => $delivery_type,
- 'delivery_type_name' => $delivery_type_name,
- 'delivery_store_id' => $shop_goods_list[ "delivery_store_id" ] ?? 0,
- "delivery_store_name" => $shop_goods_list[ "delivery_store_name" ] ?? '',
- "delivery_store_info" => $shop_goods_list[ "delivery_store_info" ] ?? '',
- "buyer_message" => $data[ "buyer_message" ],
- "promotion_type" => "seckill",
- "promotion_type_name" => "秒杀",
- "promotion_status_name" => "",
- "promotion_id" => $calculate_data[ "seckill_info" ][ "id" ],
- "invoice_delivery_money" => $shop_goods_list[ "invoice_delivery_money" ] ?? 0,
- "taxpayer_number" => $shop_goods_list[ "taxpayer_number" ] ?? '',
- "invoice_rate" => $shop_goods_list[ "invoice_rate" ] ?? 0,
- "invoice_content" => $shop_goods_list[ "invoice_content" ] ?? '',
- "invoice_full_address" => $shop_goods_list[ "invoice_full_address" ] ?? '',
- "is_invoice" => $shop_goods_list[ "is_invoice" ] ?? 0,
- "invoice_type" => $shop_goods_list[ "invoice_type" ] ?? 0,
- "invoice_title" => $shop_goods_list[ "invoice_title" ] ?? '',
- 'is_tax_invoice' => $shop_goods_list[ "is_tax_invoice" ] ?? '',
- 'invoice_email' => $shop_goods_list[ "invoice_email" ] ?? '',
- 'invoice_title_type' => $shop_goods_list[ "invoice_title_type" ] ?? 0,
- 'buyer_ask_delivery_time' => $shop_goods_list[ 'buyer_ask_delivery_time' ] ?? '',
- 'store_id' => $shop_goods_list[ 'store_id' ]
- ];
- $order_id = model('order')->add($data_order);
- $pay_money += $shop_goods_list[ 'pay_money' ];
- //订单项目表
- foreach ($shop_goods_list[ 'goods_list' ] as $k_order_goods => $order_goods) {
- $data_order_goods = array (
- 'order_id' => $order_id,
- 'site_id' => $shop_goods_list[ 'site_id' ],
- 'order_no' => $order_no,
- 'member_id' => $data[ 'member_id' ],
- 'sku_id' => $order_goods[ 'sku_id' ],
- 'sku_name' => $order_goods[ 'sku_name' ],
- 'sku_image' => $order_goods[ 'sku_image' ],
- 'sku_no' => $order_goods[ 'sku_no' ],
- 'is_virtual' => $order_goods[ 'is_virtual' ],
- 'goods_class' => $order_goods[ 'goods_class' ],
- 'goods_class_name' => $order_goods[ 'goods_class_name' ],
- 'price' => $order_goods[ 'price' ],
- 'cost_price' => $order_goods[ 'cost_price' ],
- 'num' => $order_goods[ 'num' ],
- 'goods_money' => $order_goods[ 'goods_money' ],
- 'cost_money' => $order_goods[ 'cost_price' ] * $order_goods[ 'num' ],
- 'goods_id' => $order_goods[ 'goods_id' ],
- 'delivery_status' => 0,
- 'delivery_status_name' => "未发货",
- "real_goods_money" => $order_goods[ "real_goods_money" ],
- 'coupon_money' => $order_goods[ "coupon_money" ] ?? 0,
- 'promotion_money' => $order_goods[ "promotion_money" ],
- 'goods_name' => $order_goods[ 'goods_name' ],
- 'sku_spec_format' => $order_goods[ 'sku_spec_format' ],
- 'store_id' => $shop_goods_list[ 'store_id' ]
- );
- $order_goods_id = model('order_goods')->add($data_order_goods);
- $calculate_data[ 'shop_goods_list' ][ 'goods_list' ][ $k_order_goods ][ 'order_goods_id' ] = $order_goods_id;
- //库存变化
- $stock_result = $this->skuDecStock($order_goods, $shop_goods_list[ 'store_id' ]);
- if ($stock_result[ "code" ] != 0) {
- model('order')->rollback();
- return $stock_result;
- }
- model("promotion_seckill_goods")->setDec([ [ 'sku_id', '=', $order_goods[ 'sku_id' ] ], [ 'seckill_id', '=', $calculate_data[ "seckill_info" ][ "id" ] ] ], "stock", $order_goods[ 'num' ]);
- model("promotion_seckill")->setDec([ [ 'id', '=', $calculate_data[ "seckill_info" ][ "id" ] ] ], "goods_stock", $order_goods[ 'num' ]);
- // 增加销量
- model("promotion_seckill")->setInc([ [ 'id', '=', $calculate_data[ "seckill_info" ][ "id" ] ] ], "sale_num", $order_goods[ 'num' ]);
- }
- $result_list = event("OrderCreate", [ 'order_id' => $order_id, 'site_id' => $shop_goods_list[ 'site_id' ], 'create_data' => $calculate_data ]);
- if (!empty($result_list)) {
- foreach ($result_list as $k => $v) {
- if (!empty($v) && $v[ "code" ] < 0) {
- model('order')->rollback();
- return $v;
- }
- }
- }
- //扣除余额(统一扣除)
- if ($calculate_data[ "balance_money" ] > 0) {
- $this->pay_type = "BALANCE";
- $calculate_data[ 'order_id' ] = $order_id;
- $balance_result = $this->useBalance($calculate_data, $data[ 'site_id' ]);
- if ($balance_result[ "code" ] < 0) {
- model('order')->rollback();
- return $balance_result;
- }
- }
- //生成整体支付单据
- $pay->addPay($shop_goods_list[ 'site_id' ], $out_trade_no, $this->pay_type, $this->order_name, $this->order_name, $this->pay_money, '', 'OrderPayNotify', '');
- $this->addOrderCronClose($order_id, $shop_goods_list[ 'site_id' ]);//增加关闭订单自动事件
- Cache::tag("order_create_seckill_" . $data[ 'member_id' ])->clear();
- model('order')->commit();
- return $this->success($out_trade_no);
- } catch (\Exception $e) {
- model('order')->rollback();
- return $this->error('', $e->getMessage());
- }
- }
- public function verifyAreaOrStock($data)
- {
- //查询出会员相关信息
- $calculate_data = $this->calculate($data);
- if (isset($calculate_data[ 'code' ]) && $calculate_data[ 'code' ] < 0)
- return $calculate_data;
- if ($this->error > 0) {
- return $this->error([ 'error_code' => $this->error ], $this->error_msg);
- }
- if (!empty($data[ 'delivery' ][ 'delivery_type' ]) && $data[ 'delivery' ][ 'delivery_type' ] == 'store') {
- //商品列表信息
- $shop_goods_list = $this->getOrderGoodsCalculate($data);
- $goods_lists = $shop_goods_list[ 'goods_list' ];
- if (addon_is_exit('store')) {
- $store_goods_sku_model = new StoreGoodsSku();
- foreach ($goods_lists as $k => $v) {
- $condition = array (
- [ 'store_id', '=', $data[ 'delivery' ][ 'store_id' ] ],
- [ 'sku_id', '=', $v[ 'sku_id' ] ]
- );
- $store_sku_info = model('store_goods_sku')->getInfo($condition, 'id, goods_id, stock');
- if (empty($store_sku_info)) {
- return $store_goods_sku_model->error([ 'error_code' => 11 ], '当前门店库存不足,请选择其他门店');
- }
- $store_sku_info[ 'stock' ] = numberFormat($store_sku_info[ 'stock' ]);
- if (( $store_sku_info[ 'stock' ] - $v[ 'num' ] ) < 0) {
- return $store_goods_sku_model->error([ 'error_code' => 11 ], '当前门店库存不足,请选择其他门店');
- }
- }
- }
- }
- return $this->success(1);
- }
- /**
- * 订单计算
- * @param unknown $data
- */
- public function calculate($data)
- {
- $data = $this->initMemberAddress($data);
- $data = $this->initMemberAccount($data);//初始化会员账户
- //余额付款
- if ($data[ 'is_balance' ] > 0) {
- $this->member_balance_money = $data[ "member_account" ][ "balance_total" ] ?? 0;
- }
- //商品列表信息
- $shop_goods_list = $this->getOrderGoodsCalculate($data);
- //查询秒杀信息
- $seckill_model = new Seckill();
- $seckill_id = $shop_goods_list[ "goods_list" ][ 0 ][ "seckill_id" ];
- $seckill_info_result = $seckill_model->getSeckillInfo($seckill_id);
- $seckill_info = $seckill_info_result[ "data" ];
- if (empty($seckill_info)) {
- return $this->error([], "找不到可用的秒杀活动");
- }
- $data[ "seckill_info" ] = $seckill_info;
- //判断秒杀时间段是否符合
- $today_time = strtotime(date("Y-m-d"), time());
- $time = time() - $today_time;//当日时间戳
- if ($time < $seckill_info[ "seckill_start_time" ] || $time > $seckill_info[ "seckill_end_time" ]) {
- $this->error = 1;
- $this->error_msg = "当前商品秒杀活动未开启或已过期!";
- }
- //秒杀库存
- if ($shop_goods_list[ "goods_list" ][ 0 ]) {
- $seckill_goods = $seckill_model->getSeckillGoodsInfo([ [ 'psg.seckill_id', '=', $seckill_id ], [ 'psg.sku_id', '=', $shop_goods_list[ "goods_list" ][ 0 ][ 'sku_id' ] ] ], 'psg.stock');
- $seckill_goods_stock = $seckill_goods[ 'data' ][ 'stock' ];
- if ($shop_goods_list[ "goods_list" ][ 0 ][ 'num' ] > $seckill_goods_stock) {
- $this->error = 1;
- $this->error_msg = "该商品库存不足";
- }
- }
- // 秒杀商品限购 按每日某时段限购
- if ($shop_goods_list[ "goods_list" ][ 0 ][ 'limit_num' ] > 0) {
- $purchased_num = $this->getGoodsPurchasedNum($shop_goods_list[ "goods_list" ][ 0 ][ 'sku_id' ], $data[ 'member_id' ], $seckill_info[ 'id' ]);
- if (( $purchased_num + $shop_goods_list[ "goods_list" ][ 0 ][ 'num' ] ) > $shop_goods_list[ "goods_list" ][ 0 ][ 'limit_num' ]) {
- $this->error = 1;
- $this->error_msg = "该商品每人限购{$shop_goods_list[ "goods_list" ][ 0 ]['limit_num']}件,您已购买{$purchased_num}件";
- }
- }
- $data[ 'shop_goods_list' ] = $this->shopOrderCalculate($shop_goods_list, $data);
- //总结计算
- $data[ 'delivery_money' ] = $this->delivery_money;
- $data[ 'coupon_money' ] = $this->coupon_money;
- $data[ 'adjust_money' ] = $this->adjust_money;
- $data[ 'invoice_money' ] = $this->invoice_money;
- $data[ 'invoice_delivery_money' ] = $this->invoice_delivery_money;
- $data[ 'promotion_money' ] = $this->promotion_money;
- $data[ 'order_money' ] = $this->order_money;
- $data[ 'balance_money' ] = $this->balance_money;
- $data[ 'pay_money' ] = $this->pay_money;
- $data[ 'goods_money' ] = $this->goods_money;
- $data[ 'goods_num' ] = $this->goods_num;
- $data[ 'is_virtual' ] = $this->is_virtual;
- return $data;
- }
- /**
- * 待付款订单
- * @param unknown $data
- */
- public function orderPayment($data)
- {
- $calculate_data = $this->calculate($data);
- if (isset($calculate_data[ 'code' ]) && $calculate_data[ 'code' ] < 0)
- return $calculate_data;
- $shop_goods_list = $calculate_data[ 'shop_goods_list' ];
- $calculate_data[ 'shop_goods_list' ][ "coupon_list" ] = [];
- $express_type = [];
- if ($this->is_virtual == 0) {
- foreach ($calculate_data[ 'shop_goods_list' ][ 'deliver_sort' ] as $type) {
- // 物流
- if ($type == 'express' && $calculate_data[ 'shop_goods_list' ][ "express_config" ][ "is_use" ] == 1) {
- $title = $calculate_data[ 'shop_goods_list' ][ "express_config" ][ 'value' ][ 'express_name' ];
- if ($title == "") {
- $title = Express::express_type[ "express" ][ "title" ];
- }
- $express_type[] = [ "title" => $title, "name" => "express" ];
- }
- // 自提
- if ($type == 'store' && $calculate_data[ 'shop_goods_list' ][ "store_config" ][ "is_use" ] == 1) {
- //根据坐标查询门店
- $store_model = new Store();
- $store_condition = array (
- [ 'site_id', '=', $data[ 'site_id' ] ],
- [ 'is_pickup', '=', 1 ],
- [ 'status', '=', 1 ],
- [ 'is_frozen', '=', 0 ],
- );
- $latlng = array (
- 'lat' => $data[ 'latitude' ],
- 'lng' => $data[ 'longitude' ],
- );
- $store_list_result = $store_model->getLocationStoreList($store_condition, '*', $latlng);
- $store_list = $store_list_result[ "data" ];
- $title = $calculate_data[ 'shop_goods_list' ][ "store_config" ][ 'value' ][ 'store_name' ];
- if ($title == "") {
- $title = Express::express_type[ "store" ][ "title" ];
- }
- $express_type[] = [ "title" => $title, "name" => "store", "store_list" => $store_list ];
- }
- // 外卖
- if ($type == 'local' && $calculate_data[ 'shop_goods_list' ][ "local_config" ][ "is_use" ] == 1) {
- //查询本店的通讯地址
- $title = $calculate_data[ 'shop_goods_list' ][ "local_config" ][ 'value' ][ 'local_name' ];
- if ($title == "") {
- $title = '外卖配送';
- }
- $store_model = new Store();
- $store_condition = array (
- [ 'site_id', '=', $data[ 'site_id' ] ],
- );
- if (addon_is_exit('store', $data[ 'site_id' ])) {
- $store_condition[] = [ 'is_o2o', '=', 1 ];
- $store_condition[] = [ 'status', '=', 1 ];
- $store_condition[] = [ 'is_frozen', '=', 0 ];
- } else {
- $store_condition[] = [ 'is_default', '=', 1 ];
- }
- $latlng = array (
- 'lat' => $data[ 'latitude' ],
- 'lng' => $data[ 'longitude' ],
- );
- $store_list_result = $store_model->getLocationStoreList($store_condition, '*', $latlng);
- $store_list = $store_list_result[ 'data' ];
- $express_type[] = [ "title" => $title, "name" => "local", 'store_list' => $store_list ];
- }
- }
- }
- $calculate_data[ 'shop_goods_list' ][ "express_type" ] = $express_type;
- $payment_event_data = event('OrderPayment', $calculate_data);
- if (!empty($payment_event_data)) {
- $calculate_data = array_merge($calculate_data, ...$payment_event_data);
- }
- return $this->success($calculate_data);
- }
- /**
- * 获取商品的计算信息
- * @param unknown $data
- */
- public function getOrderGoodsCalculate($data)
- {
- $goods_list = $this->getSeckillGoodsInfo($data[ "id" ], $data[ 'num' ], $data);
- $goods_list[ 'promotion_money' ] = 0;
- $shop_goods_list = $goods_list;
- return $shop_goods_list;
- }
- /**
- * 获取秒杀商品列表信息
- * @param unknown $bl_id
- */
- public function getSeckillGoodsInfo($id, $num, $data)
- {
- //组装商品列表
- $field = 'npsg.sku_id,npsg.seckill_id,npsg.seckill_price,npsg.max_buy as limit_num,ngs.sku_name, ngs.sku_no,
- ngs.price, ngs.discount_price, ngs.cost_price, ngs.stock, ngs.weight, ngs.volume, ngs.sku_image,
- ngs.site_id, ns.site_name, ngs.goods_state, ngs.is_virtual,
- ngs.is_free_shipping, ngs.shipping_template, ngs.goods_class, ngs.goods_class_name,ngs.goods_id,ngs.sku_spec_format,ngs.goods_name,ngs.support_trade_type';
- $alias = 'npsg';
- $join = [
- [
- 'goods_sku ngs',
- 'npsg.sku_id = ngs.sku_id',
- 'inner'
- ],
- [
- 'site ns',
- 'ngs.site_id = ns.site_id',
- 'inner'
- ]
- ];
- $condition = [
- [ 'npsg.sku_id', '=', $data[ 'sku_id' ] ],
- [ 'npsg.seckill_id', '=', $id ],
- [ 'npsg.site_id', '=', $data[ 'site_id' ] ]
- ];
- $info = model("promotion_seckill_goods")->getInfo($condition, $field, $alias, $join);
- $shop_goods_list = [];
- if (!empty($info)) {
- //判断是否是虚拟订单
- if ($info[ 'is_virtual' ]) {
- $this->is_virtual = 1;
- } else {
- $this->is_virtual = 0;
- }
- $info[ "num" ] = $num;
- $site_id = $info[ 'site_id' ];
- $price = $info[ "seckill_price" ];//订单项商品单价
- $goods_money = $price * $info[ 'num' ];
- $info[ "price" ] = $price;
- $info[ 'goods_money' ] = $goods_money;//订单项商品总价
- $info[ 'real_goods_money' ] = $goods_money;//真实商品金额
- $info[ 'coupon_money' ] = 0;//优惠券金额
- $info[ 'promotion_money' ] = 0;//优惠金额
- $shop_goods_list[ 'site_id' ] = $site_id;
- $shop_goods_list[ 'site_name' ] = $info[ 'site_name' ];
- $shop_goods_list[ 'goods_money' ] = $goods_money;
- $shop_goods_list[ 'goods_list_str' ] = $info[ 'sku_id' ] . ':' . $info[ 'num' ];
- $shop_goods_list[ 'order_name' ] = string_split("", ",", $info[ 'sku_name' ]);
- $shop_goods_list[ 'goods_num' ] = $info[ 'num' ];
- $shop_goods_list[ 'goods_list' ][] = $info;
- if (isset($data[ 'delivery' ][ 'delivery_type' ]) && !empty($data[ 'delivery' ][ 'delivery_type' ]) && strpos($info[ 'support_trade_type' ], $data[ 'delivery' ][ 'delivery_type' ]) === false) {
- $express_type_list = ( new \app\model\express\Config() )->getExpressTypeList($data[ 'site_id' ]);
- $delivery_type_name = $express_type_list[ $data[ 'delivery' ][ 'delivery_type' ] ] ?? '';
- $this->error = 1;
- $this->error_msg = '有商品不支持' . $delivery_type_name;
- }
- }
- return $shop_goods_list;
- }
- /**
- * 获取店铺订单计算
- * @param unknown $site_id 店铺id
- * @param unknown $goods_money 商品总价
- * @param unknown $goods_list 店铺商品列表
- * @param unknown $data 传输生成订单数据
- */
- public function shopOrderCalculate($shop_goods, $data)
- {
- $site_id = $shop_goods[ 'site_id' ];
- //交易配置
- $config_model = new Config();
- $order_config_result = $config_model->getOrderEventTimeConfig($site_id);
- $order_config = $order_config_result[ "data" ];
- $shop_goods[ 'order_config' ] = $order_config[ 'value' ] ?? [];
- //定义计算金额
- $goods_money = $shop_goods[ 'goods_money' ]; //商品金额
- $delivery_money = 0; //配送费用
- $promotion_money = $shop_goods[ 'promotion_money' ]; //优惠费用(满减)
- $coupon_money = 0; //优惠券费用
- $adjust_money = 0; //调整金额
- $invoice_money = 0; //发票金额
- $order_money = 0; //订单金额
- $balance_money = 0; //会员余额
- $pay_money = 0; //应付金额
- $store_id = 0;
- //计算邮费
- if ($this->is_virtual == 1) {
- //虚拟订单 运费为0
- $delivery_money = 0;
- $shop_goods[ 'delivery' ][ 'delivery_type' ] = '';
- } else {
- $express_config_model = new ExpressConfig();
- $deliver_type = $express_config_model->getDeliverTypeSort($site_id);
- $deliver_type = $deliver_type[ "data" ];
- $shop_goods[ "deliver_sort" ] = explode(',', $deliver_type[ 'value' ][ 'deliver_type' ]);
- //查询店铺是否开启快递配送
- $express_config_result = $express_config_model->getExpressConfig($site_id);
- $express_config = $express_config_result[ "data" ];
- $shop_goods[ "express_config" ] = $express_config;
- //查询店铺是否开启门店自提
- $store_config_result = $express_config_model->getStoreConfig($site_id);
- $store_config = $store_config_result[ "data" ];
- $shop_goods[ "store_config" ] = $store_config;
- //查询店铺是否开启外卖配送
- $local_config_result = $express_config_model->getLocalDeliveryConfig($site_id);
- $local_config = $local_config_result[ "data" ];
- $shop_goods[ "local_config" ] = $local_config;
- //如果本地配送开启, 则查询出本地配送的配置
- if ($shop_goods[ "local_config" ][ 'is_use' ] == 1 && isset($data[ 'delivery' ][ 'store_id' ])) {
- $local_model = new Local();
- $local_info_result = $local_model->getLocalInfo([ [ 'site_id', '=', $site_id ], [ 'store_id', '=', $data[ 'delivery' ][ 'store_id' ] ] ]);
- $local_info = $local_info_result[ 'data' ];
- $shop_goods[ "local_config" ][ 'info' ] = $local_info;
- } else {
- $shop_goods[ 'local_config' ][ 'info' ] = [];
- }
- $delivery_array = $data[ 'delivery' ] ?? [];
- $delivery_type = $delivery_array[ "delivery_type" ] ?? 'express';
- if ($delivery_type == "store") {
- if (isset($data[ 'delivery' ][ "delivery_type" ]) && $data[ 'delivery' ][ "delivery_type" ] == "store") {
- //门店自提
- $delivery_money = 0;
- $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'store';
- if ($shop_goods[ "store_config" ][ "is_use" ] == 0) {
- $this->error = 1;
- $this->error_msg = "门店自提方式未开启!";
- }
- if (empty($data[ 'delivery' ][ "store_id" ])) {
- $this->error = 1;
- $this->error_msg = "门店未选择!";
- }
- $shop_goods[ 'delivery' ][ 'store_id' ] = $data[ 'delivery' ][ "store_id" ];
- $shop_goods[ 'buyer_ask_delivery_time' ] = $data[ 'buyer_ask_delivery_time' ];
- $shop_goods = $this->storeOrderData($shop_goods, $data);
- $store_id = $data[ 'delivery' ][ 'store_id' ] ?? 0;
- }
- } else {
- if (empty($data[ 'member_address' ])) {
- $delivery_money = 0;
- $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'express';
- $this->error = 1;
- $this->error_msg = "未配置默认收货地址!";
- } else {
- if (!isset($data[ 'delivery' ][ "delivery_type" ]) || $data[ 'delivery' ][ "delivery_type" ] == "express") {
- if ($shop_goods[ "express_config" ][ "is_use" ] == 1) {
- //物流配送
- $express = new Express();
- $express_fee_result = $express->calculate($shop_goods, $data);
- if ($express_fee_result[ "code" ] < 0) {
- $this->error = 1;
- $this->error_msg = $express_fee_result[ "message" ];
- $delivery_fee = 0;
- } else {
- $delivery_fee = $express_fee_result[ 'data' ][ 'delivery_fee' ];
- }
- } else {
- $this->error = 1;
- $this->error_msg = "物流配送方式未开启!";
- $delivery_fee = 0;
- }
- $delivery_money = $delivery_fee;
- $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'express';
- } else if ($data[ 'delivery' ][ "delivery_type" ] == "local") {
- if (empty($data[ 'delivery' ][ 'store_id' ])) {
- $this->setError(1, '门店未选择!');
- }
- //外卖配送
- $delivery_money = 0;
- $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'local';
- if ($shop_goods[ "local_config" ][ "is_use" ] == 0) {
- $this->error = 1;
- $this->error_msg = "外卖配送方式未开启!";
- } else {
- $local_delivery_time = 0;
- if (!empty($data[ 'buyer_ask_delivery_time' ])) {
- $local_delivery_time = $data[ 'buyer_ask_delivery_time' ];
- }
- $shop_goods[ 'buyer_ask_delivery_time' ] = $local_delivery_time;
- $local_model = new Local();
- $local_result = $local_model->calculate($shop_goods, $data);
- $shop_goods[ 'delivery' ][ 'start_money' ] = 0;
- if ($local_result[ 'code' ] < 0) {
- $this->error = $local_result[ 'data' ][ 'code' ];
- $this->error_msg = $local_result[ 'message' ];
- $shop_goods[ 'delivery' ][ 'start_money' ] = $local_result[ 'data' ][ 'start_money_array' ][ 0 ] ?? 0;
- } else {
- $delivery_money = $local_result[ 'data' ][ 'delivery_money' ];
- if (!empty($local_result[ 'data' ][ 'error_code' ])) {
- $this->error = $local_result[ 'data' ][ 'code' ];
- $this->error_msg = $local_result[ 'data' ][ 'error' ];
- }
- }
- }
- $shop_goods[ 'delivery' ][ 'error' ] = $this->error;
- $shop_goods[ 'delivery' ][ 'error_msg' ] = $this->error_msg;
- $store_id = $data[ 'delivery' ][ 'store_id' ] ?? 0;
- }
- }
- }
- }
- //发票相关
- $shop_goods = $this->invoice($shop_goods, $data);
- $order_money = $goods_money + $delivery_money - $promotion_money - $coupon_money + $shop_goods[ 'invoice_money' ] + $shop_goods[ 'invoice_delivery_money' ];
- if ($order_money < 0) {
- $order_money = 0;
- }
- //余额抵扣(判断是否使用余额)
- if ($this->member_balance_money > 0) {
- if ($order_money <= $this->member_balance_money) {
- $balance_money = $order_money;
- } else {
- $balance_money = $this->member_balance_money;
- }
- } else {
- $balance_money = 0;
- }
- $pay_money = $order_money - $balance_money;//计算出实际支付金额
- $this->member_balance_money -= $balance_money;//预减少账户余额
- $this->balance_money += $balance_money;//累计余额
- //总结计算
- $shop_goods[ 'store_id' ] = $store_id;
- $shop_goods[ 'goods_money' ] = $goods_money;
- $shop_goods[ 'delivery_money' ] = $delivery_money;
- $shop_goods[ 'coupon_money' ] = $coupon_money;
- $shop_goods[ 'adjust_money' ] = $adjust_money;
- $shop_goods[ 'promotion_money' ] = $promotion_money;
- $shop_goods[ 'order_money' ] = $order_money;
- $shop_goods[ 'balance_money' ] = $balance_money;
- $shop_goods[ 'pay_money' ] = $pay_money;
- $this->goods_money += $goods_money;
- $this->delivery_money += $delivery_money;
- $this->coupon_money += $coupon_money;
- $this->adjust_money += $adjust_money;
- $this->invoice_money += $shop_goods[ 'invoice_money' ];
- $this->invoice_delivery_money += $shop_goods[ 'invoice_delivery_money' ];
- $this->promotion_money += $promotion_money;
- $this->order_money += $order_money;
- $this->pay_money += $pay_money;
- $this->goods_num += $shop_goods[ "goods_num" ];
- $this->order_name = string_split($this->order_name, ",", $shop_goods[ "order_name" ]);
- return $shop_goods;
- }
- /**
- * 订单关闭
- * @param $order_id
- */
- public function CronOrderClose($order_id)
- {
- $order_info = model('order')->getInfo([ [ 'order_id', '=', $order_id ], [ 'promotion_type', '=', 'seckill' ], [ 'order_status', '=', -1 ] ], 'promotion_id');
- if (!empty($order_info)) {
- $condition = array (
- [ "order_id", "=", $order_id ]
- );
- $order_goods_list = model('order_goods')->getList($condition, "order_goods_id,sku_id,num,refund_status,use_point");
- foreach ($order_goods_list as $k => $v) {
- // 返还库存
- model("promotion_seckill")->setInc([ [ 'id', '=', $order_info[ "promotion_id" ] ] ], "goods_stock", $v[ "num" ]);
- model("promotion_seckill_goods")->setInc([ [ "sku_id", '=', $v[ "sku_id" ] ], [ "seckill_id", '=', $order_info[ "promotion_id" ] ] ], "stock", $v[ "num" ]);
- // 减少销量
- model("promotion_seckill")->setDec([ [ 'id', '=', $order_info[ "promotion_id" ] ] ], "sale_num", $v[ "num" ]);
- }
- }
- return $this->success();
- }
- /**
- * 获取会员该秒杀时段已购该商品数
- * @param $goods_id
- * @param $member_id
- * @return float
- */
- public function getGoodsPurchasedNum($sku_id, $member_id, $seckill_id)
- {
- $join = [
- [ 'order o', 'o.order_id = og.order_id', 'left' ]
- ];
- $num = model('order_goods')->getSum([
- [ 'og.member_id', '=', $member_id ],
- [ 'og.sku_id', '=', $sku_id ],
- [ 'o.order_status', '<>', Order::ORDER_CLOSE ],
- [ 'o.promotion_type', '=', 'seckill' ],
- [ 'o.promotion_id', '=', $seckill_id ],
- [ 'og.refund_status', '<>', OrderRefund::REFUND_COMPLETE ],
- [ 'o.create_time', 'between', [ date_to_time(date('Y-m-d 00:00:00')), time() ] ]
- ], 'og.num', 'og', $join);
- return $num;
- }
- /**
- * 获取商品已秒杀数
- * @param $goods_id
- * @param $member_id
- * @return float
- */
- public function getGoodsSeckillNum($seckill_id)
- {
- $join = [
- [ 'order o', 'o.order_id = og.order_id', 'left' ]
- ];
- $num = model('order_goods')->getSum([
- [ 'o.order_status', '<>', Order::ORDER_CLOSE ],
- [ 'o.promotion_type', '=', 'seckill' ],
- [ 'o.promotion_id', '=', $seckill_id ],
- [ 'og.refund_status', '<>', OrderRefund::REFUND_COMPLETE ],
- ], 'og.num', 'og', $join);
- return $num;
- }
- }
|