GroupbuyOrderCreate.php 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707
  1. <?php
  2. /**
  3. * Niushop商城系统 - 团队十年电商经验汇集巨献!
  4. * =========================================================
  5. * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
  6. * ----------------------------------------------
  7. * 官方网址: https://www.niushop.com
  8. * =========================================================
  9. */
  10. namespace addon\groupbuy\model;
  11. use addon\store\model\StoreGoodsSku;
  12. use app\model\order\OrderCreate;
  13. use app\model\order\OrderCreateTool;
  14. use app\model\store\Store;
  15. use think\facade\Cache;
  16. use app\model\express\Express;
  17. use app\model\system\Pay;
  18. use app\model\express\Config as ExpressConfig;
  19. use app\model\order\Config;
  20. use app\model\express\Local;
  21. /**
  22. * 订单创建(团购)
  23. *
  24. * @author Administrator
  25. *
  26. */
  27. class GroupbuyOrderCreate extends OrderCreate
  28. {
  29. use OrderCreateTool;
  30. private $goods_money = 0;//商品金额
  31. private $balance_money = 0;//余额
  32. private $delivery_money = 0;//配送费用
  33. private $coupon_money = 0;//优惠券金额
  34. private $adjust_money = 0;//调整金额
  35. private $invoice_money = 0;//发票费用
  36. private $promotion_money = 0;//优惠金额
  37. private $order_money = 0;//订单金额
  38. private $pay_money = 0;//支付总价
  39. private $is_virtual = 0; //是否是虚拟类订单
  40. private $order_name = ''; //订单详情
  41. private $goods_num = 0; //商品种数
  42. private $member_balance_money = 0;//会员账户余额(计算过程中会逐次减少)
  43. private $pay_type = 'ONLINE_PAY';//支付方式
  44. private $invoice_delivery_money = 0;
  45. private $error = 0; //是否有错误
  46. private $error_msg = ''; //错误描述
  47. /**
  48. * 订单创建
  49. * @param unknown $data
  50. */
  51. public function create($data)
  52. {
  53. //查询出会员相关信息
  54. $calculate_data = $this->calculate($data);
  55. if (isset($calculate_data[ 'code' ]) && $calculate_data[ 'code' ] < 0)
  56. return $calculate_data;
  57. if ($this->error > 0) {
  58. return $this->error([ 'error_code' => $this->error ], $this->error_msg);
  59. }
  60. if (!empty($calculate_data[ 'invoice_type' ])) {
  61. if ($calculate_data[ 'invoice_type' ] == 1 && $calculate_data[ 'invoice_full_address' ] == "") {
  62. //物流,同城
  63. if ($calculate_data[ 'shop_goods_list' ][ 'delivery' ][ 'delivery_type' ] == "express" || $calculate_data[ 'shop_goods_list' ][ 'delivery' ][ 'delivery_type' ] == "local") {
  64. $calculate_data[ 'invoice_full_address' ] = $calculate_data[ 'member_address' ][ 'full_address' ] . $calculate_data[ 'member_address' ][ 'address' ];
  65. $calculate_data[ 'shop_goods_list' ][ 'invoice_full_address' ] = $calculate_data[ 'member_address' ][ 'full_address' ] . $calculate_data[ 'member_address' ][ 'address' ];
  66. }
  67. //门店
  68. if ($calculate_data[ 'shop_goods_list' ][ 'delivery' ][ 'delivery_type' ] == "store") {
  69. $delivery_store_info = json_decode($calculate_data[ 'shop_goods_list' ][ 'delivery_store_info' ], true);
  70. $calculate_data[ 'invoice_full_address' ] = $delivery_store_info[ 'full_address' ];
  71. $calculate_data[ 'shop_goods_list' ][ 'invoice_full_address' ] = $delivery_store_info[ 'full_address' ];
  72. }
  73. }
  74. }
  75. $pay = new Pay();
  76. $out_trade_no = $pay->createOutTradeNo($data[ 'member_id' ]);
  77. model('order')->startTrans();
  78. //循环生成多个订单
  79. try {
  80. $pay_money = 0;
  81. $shop_goods_list = $calculate_data[ 'shop_goods_list' ];
  82. $item_delivery = $shop_goods_list[ 'delivery' ] ?? [];
  83. $delivery_type = $item_delivery[ 'delivery_type' ] ?? '';
  84. $site_id = $data[ 'site_id' ];
  85. $express_type_list = ( new \app\model\express\Config() )->getExpressTypeList($site_id);
  86. $delivery_type_name = $express_type_list[ $delivery_type ] ?? '';
  87. //订单主表
  88. $order_type = $this->orderType($shop_goods_list, $calculate_data);
  89. $order_no = $this->createOrderNo($shop_goods_list[ 'site_id' ], $data[ 'member_id' ]);
  90. $data_order = [
  91. 'order_no' => $order_no,
  92. 'site_id' => $shop_goods_list[ 'site_id' ],
  93. 'site_name' => $shop_goods_list[ 'site_name' ],
  94. 'order_from' => $data[ 'order_from' ],
  95. 'order_from_name' => $data[ 'order_from_name' ],
  96. 'order_type' => $order_type[ 'order_type_id' ],
  97. 'order_type_name' => $order_type[ 'order_type_name' ],
  98. 'order_status_name' => $order_type[ 'order_status' ][ 'name' ],
  99. 'order_status_action' => json_encode($order_type[ 'order_status' ], JSON_UNESCAPED_UNICODE),
  100. 'out_trade_no' => $out_trade_no,
  101. 'member_id' => $data[ 'member_id' ],
  102. 'name' => $calculate_data[ 'member_address' ][ 'name' ] ?? '',
  103. 'mobile' => $calculate_data[ 'member_address' ][ 'mobile' ] ?? '',
  104. 'telephone' => $calculate_data[ 'member_address' ][ 'telephone' ] ?? '',
  105. 'province_id' => $calculate_data[ 'member_address' ][ 'province_id' ] ?? '',
  106. 'city_id' => $calculate_data[ 'member_address' ][ 'city_id' ] ?? '',
  107. 'district_id' => $calculate_data[ 'member_address' ][ 'district_id' ] ?? '',
  108. 'community_id' => $calculate_data[ 'member_address' ][ 'community_id' ] ?? '',
  109. 'address' => $calculate_data[ 'member_address' ][ 'address' ] ?? '',
  110. 'full_address' => $calculate_data[ 'member_address' ][ 'full_address' ] ?? '',
  111. 'longitude' => $calculate_data[ 'member_address' ][ 'longitude' ] ?? '',
  112. 'latitude' => $calculate_data[ 'member_address' ][ 'latitude' ] ?? '',
  113. 'buyer_ip' => request()->ip(),
  114. 'goods_money' => $shop_goods_list[ 'goods_money' ],
  115. 'delivery_money' => $shop_goods_list[ 'delivery_money' ],
  116. 'coupon_id' => isset($shop_goods_list[ 'coupon_id' ]) ? $shop_goods_list[ 'coupon_id' ] : 0,
  117. 'coupon_money' => $shop_goods_list[ 'coupon_money' ] ?? 0,
  118. 'adjust_money' => $shop_goods_list[ 'adjust_money' ],
  119. 'invoice_money' => $shop_goods_list[ 'invoice_money' ],
  120. 'promotion_money' => $shop_goods_list[ 'promotion_money' ],
  121. 'order_money' => $shop_goods_list[ 'order_money' ],
  122. 'balance_money' => $shop_goods_list[ 'balance_money' ],
  123. 'pay_money' => $shop_goods_list[ 'pay_money' ],
  124. 'create_time' => time(),
  125. 'is_enable_refund' => 0,
  126. 'order_name' => $shop_goods_list[ "order_name" ],
  127. 'goods_num' => $shop_goods_list[ 'goods_num' ],
  128. 'delivery_type' => $delivery_type,
  129. 'delivery_type_name' => $delivery_type_name,
  130. 'delivery_store_id' => $shop_goods_list[ "delivery_store_id" ] ?? 0,
  131. "delivery_store_name" => $shop_goods_list[ "delivery_store_name" ] ?? '',
  132. "delivery_store_info" => $shop_goods_list[ "delivery_store_info" ] ?? '',
  133. "buyer_message" => $data[ "buyer_message" ],
  134. "promotion_type" => "groupbuy",
  135. "promotion_type_name" => "团购",
  136. "promotion_status_name" => "",
  137. "invoice_delivery_money" => $shop_goods_list[ "invoice_delivery_money" ] ?? 0,
  138. "taxpayer_number" => $shop_goods_list[ "taxpayer_number" ] ?? '',
  139. "invoice_rate" => $shop_goods_list[ "invoice_rate" ] ?? 0,
  140. "invoice_content" => $shop_goods_list[ "invoice_content" ] ?? '',
  141. "invoice_full_address" => $shop_goods_list[ "invoice_full_address" ] ?? '',
  142. "is_invoice" => $shop_goods_list[ "is_invoice" ] ?? 0,
  143. "invoice_type" => $shop_goods_list[ "invoice_type" ] ?? 0,
  144. "invoice_title" => $shop_goods_list[ "invoice_title" ] ?? '',
  145. 'is_tax_invoice' => $shop_goods_list[ "is_tax_invoice" ] ?? '',
  146. 'invoice_email' => $shop_goods_list[ "invoice_email" ] ?? '',
  147. 'invoice_title_type' => $shop_goods_list[ "invoice_title_type" ] ?? 0,
  148. 'buyer_ask_delivery_time' => $shop_goods_list[ 'buyer_ask_delivery_time' ] ?? '',
  149. 'store_id' => $shop_goods_list[ 'store_id' ]
  150. ];
  151. $order_id = model('order')->add($data_order);
  152. $pay_money += $shop_goods_list[ 'pay_money' ];
  153. //订单项目表
  154. foreach ($shop_goods_list[ 'goods_list' ] as $k_order_goods => $order_goods) {
  155. $data_order_goods = array (
  156. 'order_id' => $order_id,
  157. 'site_id' => $shop_goods_list[ 'site_id' ],
  158. 'order_no' => $order_no,
  159. 'member_id' => $data[ 'member_id' ],
  160. 'sku_id' => $order_goods[ 'sku_id' ],
  161. 'sku_name' => $order_goods[ 'sku_name' ],
  162. 'sku_image' => $order_goods[ 'sku_image' ],
  163. 'sku_no' => $order_goods[ 'sku_no' ],
  164. 'is_virtual' => $order_goods[ 'is_virtual' ],
  165. 'goods_class' => $order_goods[ 'goods_class' ],
  166. 'goods_class_name' => $order_goods[ 'goods_class_name' ],
  167. 'price' => $order_goods[ 'price' ],
  168. 'cost_price' => $order_goods[ 'cost_price' ],
  169. 'num' => $order_goods[ 'num' ],
  170. 'goods_money' => $order_goods[ 'goods_money' ],
  171. 'cost_money' => $order_goods[ 'cost_price' ] * $order_goods[ 'num' ],
  172. 'goods_id' => $order_goods[ 'goods_id' ],
  173. 'delivery_status' => 0,
  174. 'delivery_status_name' => "未发货",
  175. "real_goods_money" => $order_goods[ "real_goods_money" ],
  176. 'coupon_money' => $order_goods[ "coupon_money" ] ?? 0,
  177. 'promotion_money' => $order_goods[ "promotion_money" ],
  178. 'goods_name' => $order_goods[ 'goods_name' ],
  179. 'sku_spec_format' => $order_goods[ 'sku_spec_format' ],
  180. 'store_id' => $shop_goods_list[ 'store_id' ]
  181. );
  182. $order_goods_id = model('order_goods')->add($data_order_goods);
  183. $calculate_data[ 'shop_goods_list' ][ 'goods_list' ][ $k_order_goods ][ 'order_goods_id' ] = $order_goods_id;
  184. //库存变化
  185. $stock_result = $this->skuDecStock($order_goods, $shop_goods_list[ 'store_id' ]);
  186. if ($stock_result[ "code" ] != 0) {
  187. model('order')->rollback();
  188. return $stock_result;
  189. }
  190. }
  191. $result_list = event("OrderCreate", [ 'order_id' => $order_id, 'site_id' => $shop_goods_list[ 'site_id' ], 'create_data' => $calculate_data ]);
  192. if (!empty($result_list)) {
  193. foreach ($result_list as $k => $v) {
  194. if (!empty($v) && $v[ "code" ] < 0) {
  195. model('order')->rollback();
  196. return $v;
  197. }
  198. }
  199. }
  200. //扣除余额(统一扣除)
  201. if ($calculate_data[ "balance_money" ] > 0) {
  202. $this->pay_type = "BALANCE";
  203. $calculate_data[ 'order_id' ] = $order_id;
  204. $balance_result = $this->useBalance($calculate_data, $data[ 'site_id' ]);
  205. if ($balance_result[ "code" ] < 0) {
  206. model('order')->rollback();
  207. return $balance_result;
  208. }
  209. }
  210. //生成整体支付单据
  211. $pay->addPay($shop_goods_list[ 'site_id' ], $out_trade_no, $this->pay_type, $this->order_name, $this->order_name, $this->pay_money, '', 'OrderPayNotify', '');
  212. $this->addOrderCronClose($order_id, $shop_goods_list[ 'site_id' ]);//增加关闭订单自动事件
  213. Cache::tag("order_create_groupbuy_" . $data[ 'member_id' ])->clear();
  214. model('order')->commit();
  215. return $this->success($out_trade_no);
  216. } catch (\Exception $e) {
  217. model('order')->rollback();
  218. return $this->error('', $e->getMessage());
  219. }
  220. }
  221. public function verifyAreaOrStock($data)
  222. {
  223. //查询出会员相关信息
  224. $calculate_data = $this->calculate($data);
  225. if (isset($calculate_data[ 'code' ]) && $calculate_data[ 'code' ] < 0)
  226. return $calculate_data;
  227. if ($this->error > 0) {
  228. return $this->error([ 'error_code' => $this->error ], $this->error_msg);
  229. }
  230. if (!empty($calculate_data[ 'delivery' ][ 'delivery_type' ]) && $calculate_data[ 'delivery' ][ 'delivery_type' ] == 'store') {
  231. if (!empty($calculate_data[ 'cart_ids' ])) {
  232. //商品列表信息
  233. $shop_goods_list = $this->getOrderGoodsCalculate($calculate_data);
  234. } else {
  235. //商品列表信息
  236. $shop_goods_list = $this->getOrderGoodsCalculate($calculate_data);
  237. }
  238. $goods_lists = $shop_goods_list[ 'goods_list' ];
  239. if (addon_is_exit('store')) {
  240. $store_goods_sku_model = new StoreGoodsSku();
  241. foreach ($goods_lists as $k => $v) {
  242. $condition = array (
  243. [ 'store_id', '=', $calculate_data[ 'delivery' ][ 'store_id' ] ],
  244. [ 'sku_id', '=', $v[ 'sku_id' ] ]
  245. );
  246. $store_sku_info = model('store_goods_sku')->getInfo($condition, 'id, goods_id, stock');
  247. if (empty($store_sku_info)) {
  248. return $store_goods_sku_model->error([ 'error_code' => 11 ], '当前门店库存不足,请选择其他门店');
  249. }
  250. $store_sku_info[ 'stock' ] = numberFormat($store_sku_info[ 'stock' ]);
  251. if (( $store_sku_info[ 'stock' ] - $v[ 'num' ] ) < 0) {
  252. return $store_goods_sku_model->error([ 'error_code' => 11 ], '当前门店库存不足,请选择其他门店');
  253. }
  254. }
  255. }
  256. }
  257. return $this->success(1);
  258. }
  259. /**
  260. * 订单计算
  261. * @param unknown $data
  262. */
  263. public function calculate($data)
  264. {
  265. $data = $this->initMemberAddress($data);
  266. $data = $this->initMemberAccount($data);//初始化会员账户
  267. //余额付款
  268. if ($data[ 'is_balance' ] > 0) {
  269. $this->member_balance_money = $data[ "member_account" ][ "balance_total" ] ?? 0;
  270. }
  271. //查询团购信息
  272. $groupbuy_model = new Groupbuy();
  273. $groupbuy_id = $data[ "groupbuy_id" ];
  274. $groupbuy_info_result = $groupbuy_model->getGroupbuyInfo(
  275. [
  276. [ 'pg.groupbuy_id', '=', $groupbuy_id ], [ 'pg.site_id', '=', $data[ 'site_id' ] ],
  277. [ 'g.goods_state', '=', 1 ], [ 'g.is_delete', '=', 0 ]
  278. ]
  279. );
  280. $groupbuy_info = $groupbuy_info_result[ "data" ];
  281. if (empty($groupbuy_info)) {
  282. return $this->error('', '该团购不存在');
  283. }
  284. $data[ "groupbuy_info" ] = $groupbuy_info;
  285. //商品列表信息
  286. $shop_goods_list = $this->getOrderGoodsCalculate($data);
  287. //判断活动是否过期或开启
  288. if ($groupbuy_info[ "status" ] != 2) {
  289. $this->error = 1;
  290. $this->error_msg = "当前商品团购活动未开启或已过期!";
  291. }
  292. //判断购买数是否超过限购
  293. if ($groupbuy_info[ "buy_num" ] > $data[ 'num' ]) {
  294. $this->error = 1;
  295. $this->error_msg = "该商品限制购买不能少于" . $groupbuy_info[ "buy_num" ] . "件!";
  296. }
  297. $data[ 'shop_goods_list' ] = $this->shopOrderCalculate($shop_goods_list, $data);
  298. //总结计算
  299. $data[ 'delivery_money' ] = $this->delivery_money;
  300. $data[ 'coupon_money' ] = $this->coupon_money;
  301. $data[ 'adjust_money' ] = $this->adjust_money;
  302. $data[ 'invoice_money' ] = $this->invoice_money;
  303. $data[ 'invoice_delivery_money' ] = $this->invoice_delivery_money;
  304. $data[ 'promotion_money' ] = $this->promotion_money;
  305. $data[ 'order_money' ] = $this->order_money;
  306. $data[ 'balance_money' ] = $this->balance_money;
  307. $data[ 'pay_money' ] = $this->pay_money;
  308. $data[ 'goods_money' ] = $this->goods_money;
  309. $data[ 'goods_num' ] = $this->goods_num;
  310. $data[ 'is_virtual' ] = $this->is_virtual;
  311. return $data;
  312. }
  313. /**
  314. * 待付款订单
  315. * @param unknown $data
  316. */
  317. public function orderPayment($data)
  318. {
  319. $calculate_data = $this->calculate($data);
  320. $shop_goods_list = $calculate_data[ 'shop_goods_list' ];
  321. $calculate_data[ 'shop_goods_list' ][ "coupon_list" ] = [];
  322. $express_type = [];
  323. $store_model = new Store();
  324. if ($this->is_virtual == 0) {
  325. foreach ($calculate_data[ 'shop_goods_list' ][ 'deliver_sort' ] as $type) {
  326. // 物流
  327. if ($type == 'express' && $calculate_data[ 'shop_goods_list' ][ "express_config" ][ "is_use" ] == 1) {
  328. $title = $calculate_data[ 'shop_goods_list' ][ "express_config" ][ 'value' ][ 'express_name' ];
  329. if ($title == "") {
  330. $title = Express::express_type[ "express" ][ "title" ];
  331. }
  332. $express_type[] = [ "title" => $title, "name" => "express" ];
  333. }
  334. // 自提
  335. if ($type == 'store' && $calculate_data[ 'shop_goods_list' ][ "store_config" ][ "is_use" ] == 1) {
  336. //根据坐标查询门店
  337. $store_condition = array (
  338. [ 'site_id', '=', $data[ 'site_id' ] ],
  339. [ 'is_pickup', '=', 1 ],
  340. [ 'status', '=', 1 ],
  341. [ 'is_frozen', '=', 0 ],
  342. );
  343. $latlng = array (
  344. 'lat' => $data[ 'latitude' ],
  345. 'lng' => $data[ 'longitude' ],
  346. );
  347. $store_list_result = $store_model->getLocationStoreList($store_condition, '*', $latlng);
  348. $store_list = $store_list_result[ "data" ];
  349. $title = $calculate_data[ 'shop_goods_list' ][ "store_config" ][ 'value' ][ 'store_name' ];
  350. if ($title == "") {
  351. $title = Express::express_type[ "store" ][ "title" ];
  352. }
  353. $express_type[] = [ "title" => $title, "name" => "store", "store_list" => $store_list ];
  354. }
  355. // 外卖
  356. if ($type == 'local' && $calculate_data[ 'shop_goods_list' ][ "local_config" ][ "is_use" ] == 1) {
  357. //查询本店的通讯地址
  358. $title = $calculate_data[ 'shop_goods_list' ][ "local_config" ][ 'value' ][ 'local_name' ];
  359. if ($title == "") {
  360. $title = '外卖配送';
  361. }
  362. $store_condition = array (
  363. [ 'site_id', '=', $data[ 'site_id' ] ],
  364. );
  365. if (addon_is_exit('store', $data[ 'site_id' ])) {
  366. $store_condition[] = [ 'is_o2o', '=', 1 ];
  367. $store_condition[] = [ 'status', '=', 1 ];
  368. $store_condition[] = [ 'is_frozen', '=', 0 ];
  369. } else {
  370. $store_condition[] = [ 'is_default', '=', 1 ];
  371. }
  372. $latlng = array (
  373. 'lat' => $data[ 'latitude' ],
  374. 'lng' => $data[ 'longitude' ],
  375. );
  376. $store_list_result = $store_model->getLocationStoreList($store_condition, '*', $latlng);
  377. $store_list = $store_list_result[ 'data' ];
  378. $express_type[] = [ "title" => $title, "name" => "local", 'store_list' => $store_list ];
  379. }
  380. }
  381. }
  382. $calculate_data[ 'shop_goods_list' ][ "express_type" ] = $express_type;
  383. $payment_event_data = event('OrderPayment', $calculate_data);
  384. if (!empty($payment_event_data)) {
  385. $calculate_data = array_merge($calculate_data, ...$payment_event_data);
  386. }
  387. return $calculate_data;
  388. }
  389. /**
  390. * 获取商品的计算信息
  391. * @param unknown $data
  392. */
  393. public function getOrderGoodsCalculate($data)
  394. {
  395. $shop_goods_list = [];
  396. // $cache = Cache::get("order_create_groupbuy_".$data['id'].'_'.$data['num'].'_'.$data['member_id']);
  397. // if(!empty($cache))
  398. // {
  399. // return $cache;
  400. // }
  401. $goods_list = $this->getGroupbuyGoodsInfo($data);
  402. $goods_list[ 'promotion_money' ] = 0;
  403. $shop_goods_list = $goods_list;
  404. // Cache::tag("order_create_groupbuy_".$data['member_id'])->set("order_create_groupbuy_".$data['id'].'_'.$data['num'].'_'.$data['member_id'], $shop_goods_list, 600);
  405. return $shop_goods_list;
  406. }
  407. /**
  408. * 获取团购商品列表信息
  409. * @param unknown $bl_id
  410. */
  411. public function getGroupbuyGoodsInfo($data)
  412. {
  413. //组装商品列表
  414. $field = 'ngs.sku_id,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, ngs.goods_state, ngs.is_virtual,
  415. ngs.is_free_shipping, ngs.shipping_template, ngs.goods_class, ngs.goods_class_name,ngs.goods_id, ns.site_name,ngs.sku_spec_format,ngs.goods_name,g.goods_image,ngs.support_trade_type';
  416. $join = [
  417. [
  418. 'site ns',
  419. 'ngs.site_id = ns.site_id',
  420. 'inner'
  421. ],
  422. [ 'goods g', 'ngs.goods_id = g.goods_id', 'inner' ],
  423. ];
  424. $info = model('goods_sku')->getInfo([ [ 'ngs.sku_id', '=', $data[ "sku_id" ] ], [ 'ngs.site_id', '=', $data[ 'site_id' ] ] ], $field, 'ngs', $join);
  425. $shop_goods_list = [];
  426. if (!empty($info)) {
  427. //判断是否是虚拟订单
  428. if ($info[ 'is_virtual' ]) {
  429. $this->is_virtual = 1;
  430. } else {
  431. $this->is_virtual = 0;
  432. }
  433. $info[ "num" ] = $data[ "num" ];
  434. $site_id = $info[ 'site_id' ];
  435. $price = $data[ "groupbuy_info" ][ "groupbuy_price" ];
  436. $goods_money = $price * $info[ 'num' ];
  437. $info[ "price" ] = $price;
  438. $info[ "goods_money" ] = $goods_money;
  439. $info[ 'real_goods_money' ] = $goods_money;//真实商品金额
  440. $info[ 'coupon_money' ] = 0;//优惠券金额
  441. $info[ 'promotion_money' ] = 0;//优惠金额
  442. $info[ 'stock' ] = numberFormat($info[ 'stock' ]);
  443. $shop_goods_list[ 'site_id' ] = $site_id;
  444. $shop_goods_list[ 'site_name' ] = $info[ 'site_name' ];
  445. $shop_goods_list[ 'goods_money' ] = $goods_money;
  446. $shop_goods_list[ 'goods_list_str' ] = $info[ 'sku_id' ] . ':' . $info[ 'num' ];
  447. $shop_goods_list[ 'order_name' ] = string_split("", ",", $info[ 'sku_name' ]);
  448. $shop_goods_list[ 'goods_num' ] = $info[ 'num' ];
  449. $shop_goods_list[ 'goods_list' ][] = $info;
  450. if (isset($data[ 'delivery' ][ 'delivery_type' ]) && !empty($data[ 'delivery' ][ 'delivery_type' ]) && strpos($info[ 'support_trade_type' ], $data[ 'delivery' ][ 'delivery_type' ]) === false) {
  451. $express_type_list = ( new \app\model\express\Config() )->getExpressTypeList($data[ 'site_id' ]);
  452. $delivery_type_name = $express_type_list[ $data[ 'delivery' ][ 'delivery_type' ] ] ?? '';
  453. $this->error = 1;
  454. $this->error_msg = '有商品不支持' . $delivery_type_name;
  455. }
  456. }
  457. return $shop_goods_list;
  458. }
  459. /**
  460. * 获取店铺订单计算
  461. * @param unknown $site_id 店铺id
  462. * @param unknown $goods_money 商品总价
  463. * @param unknown $goods_list 店铺商品列表
  464. * @param unknown $data 传输生成订单数据
  465. */
  466. public function shopOrderCalculate($shop_goods, $data)
  467. {
  468. $site_id = $shop_goods[ 'site_id' ];
  469. //交易配置
  470. $config_model = new Config();
  471. $order_config_result = $config_model->getOrderEventTimeConfig($site_id);
  472. $order_config = $order_config_result[ "data" ];
  473. $shop_goods[ 'order_config' ] = $order_config[ 'value' ] ?? [];
  474. //定义计算金额
  475. $goods_money = $shop_goods[ 'goods_money' ]; //商品金额
  476. $delivery_money = 0; //配送费用
  477. $promotion_money = $shop_goods[ 'promotion_money' ]; //优惠费用(满减)
  478. $coupon_money = 0; //优惠券费用
  479. $adjust_money = 0; //调整金额
  480. $invoice_money = 0; //发票金额
  481. $order_money = 0; //订单金额
  482. $balance_money = 0; //会员余额
  483. $pay_money = 0; //应付金额
  484. $store_id = 0;
  485. //计算邮费
  486. if ($this->is_virtual == 1) {
  487. //虚拟订单 运费为0
  488. $delivery_money = 0;
  489. $shop_goods[ 'delivery' ][ 'delivery_type' ] = '';
  490. } else {
  491. $express_config_model = new ExpressConfig();
  492. $deliver_type = $express_config_model->getDeliverTypeSort($site_id);
  493. $deliver_type = $deliver_type[ "data" ];
  494. $shop_goods[ "deliver_sort" ] = explode(',', $deliver_type[ 'value' ][ 'deliver_type' ]);
  495. //查询店铺是否开启快递配送
  496. $express_config_result = $express_config_model->getExpressConfig($site_id);
  497. $express_config = $express_config_result[ "data" ];
  498. $shop_goods[ "express_config" ] = $express_config;
  499. //查询店铺是否开启门店自提
  500. $store_config_result = $express_config_model->getStoreConfig($site_id);
  501. $store_config = $store_config_result[ "data" ];
  502. $shop_goods[ "store_config" ] = $store_config;
  503. //查询店铺是否开启外卖配送
  504. $local_config_result = $express_config_model->getLocalDeliveryConfig($site_id);
  505. $local_config = $local_config_result[ "data" ];
  506. $shop_goods[ "local_config" ] = $local_config;
  507. //如果本地配送开启, 则查询出本地配送的配置
  508. if ($shop_goods[ "local_config" ][ 'is_use' ] == 1 && isset($data[ 'delivery' ][ 'store_id' ])) {
  509. $local_model = new Local();
  510. $local_info_result = $local_model->getLocalInfo([ [ 'site_id', '=', $site_id ], [ 'store_id', '=', $data[ 'delivery' ][ 'store_id' ] ] ]);
  511. $local_info = $local_info_result[ 'data' ];
  512. $shop_goods[ "local_config" ][ 'info' ] = $local_info;
  513. } else {
  514. $shop_goods[ 'local_config' ][ 'info' ] = [];
  515. }
  516. $delivery_array = $data[ 'delivery' ] ?? [];
  517. $delivery_type = $delivery_array[ "delivery_type" ] ?? 'express';
  518. if ($delivery_type == "store") {
  519. if (isset($data[ 'delivery' ][ "delivery_type" ]) && $data[ 'delivery' ][ "delivery_type" ] == "store") {
  520. //门店自提
  521. $delivery_money = 0;
  522. $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'store';
  523. if ($shop_goods[ "store_config" ][ "is_use" ] == 0) {
  524. $this->error = 1;
  525. $this->error_msg = "门店自提方式未开启!";
  526. }
  527. if (empty($data[ 'delivery' ][ "store_id" ])) {
  528. $this->error = 1;
  529. $this->error_msg = "门店未选择!";
  530. }
  531. $shop_goods[ 'delivery' ][ 'store_id' ] = $data[ 'delivery' ][ "store_id" ];
  532. $shop_goods[ 'buyer_ask_delivery_time' ] = $data[ 'buyer_ask_delivery_time' ];
  533. $shop_goods = $this->storeOrderData($shop_goods, $data);
  534. $store_id = $data[ 'delivery' ][ 'store_id' ] ?? 0;
  535. }
  536. } else {
  537. if (empty($data[ 'member_address' ])) {
  538. $delivery_money = 0;
  539. $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'express';
  540. $this->error = 1;
  541. $this->error_msg = "未配置默认收货地址!";
  542. } else {
  543. if (!isset($data[ 'delivery' ][ "delivery_type" ]) || $data[ 'delivery' ][ "delivery_type" ] == "express") {
  544. if ($shop_goods[ "express_config" ][ "is_use" ] == 1) {
  545. //物流配送
  546. $express = new Express();
  547. $express_fee_result = $express->calculate($shop_goods, $data);
  548. if ($express_fee_result[ "code" ] < 0) {
  549. $this->error = 1;
  550. $this->error_msg = $express_fee_result[ "message" ];
  551. $delivery_fee = 0;
  552. } else {
  553. $delivery_fee = $express_fee_result[ 'data' ][ 'delivery_fee' ];
  554. }
  555. } else {
  556. $this->error = 1;
  557. $this->error_msg = "物流配送方式未开启!";
  558. $delivery_fee = 0;
  559. }
  560. $delivery_money = $delivery_fee;
  561. $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'express';
  562. } else if ($data[ 'delivery' ][ "delivery_type" ] == "local") {
  563. //外卖配送
  564. $delivery_money = 0;
  565. $shop_goods[ 'delivery' ][ 'delivery_type' ] = 'local';
  566. if ($shop_goods[ "local_config" ][ "is_use" ] == 0) {
  567. $this->error = 1;
  568. $this->error_msg = "外卖配送方式未开启!";
  569. } else {
  570. if (empty($data[ 'delivery' ][ "store_id" ])) {
  571. $this->error = 1;
  572. $this->error_msg = "门店未选择!";
  573. }
  574. $local_delivery_time = 0;
  575. if (!empty($data[ 'buyer_ask_delivery_time' ])) {
  576. $local_delivery_time = $data[ 'buyer_ask_delivery_time' ];
  577. }
  578. $shop_goods[ 'buyer_ask_delivery_time' ] = $local_delivery_time;
  579. $local_model = new Local();
  580. $local_result = $local_model->calculate($shop_goods, $data);
  581. $shop_goods[ 'delivery' ][ 'start_money' ] = 0;
  582. if ($local_result[ 'code' ] < 0) {
  583. $this->error = $local_result[ 'data' ][ 'code' ];
  584. $this->error_msg = $local_result[ 'message' ];
  585. $shop_goods[ 'delivery' ][ 'start_money' ] = $local_result[ 'data' ][ 'start_money_array' ][ 0 ] ?? 0;
  586. } else {
  587. $delivery_money = $local_result[ 'data' ][ 'delivery_money' ];
  588. if (!empty($local_result[ 'data' ][ 'error_code' ])) {
  589. $this->error = $local_result[ 'data' ][ 'code' ];
  590. $this->error_msg = $local_result[ 'data' ][ 'error' ];
  591. }
  592. }
  593. $shop_goods[ 'delivery' ][ 'error' ] = $this->error;
  594. $shop_goods[ 'delivery' ][ 'error_msg' ] = $this->error_msg;
  595. $store_id = $data[ 'delivery' ][ 'store_id' ] ?? 0;
  596. }
  597. }
  598. }
  599. }
  600. }
  601. //发票相关
  602. $shop_goods = $this->invoice($shop_goods, $data);
  603. $order_money = $goods_money + $delivery_money - $promotion_money - $coupon_money + $shop_goods[ 'invoice_money' ] + $shop_goods[ 'invoice_delivery_money' ];
  604. if ($order_money < 0) {
  605. $order_money = 0;
  606. }
  607. //余额抵扣(判断是否使用余额)
  608. if ($this->member_balance_money > 0) {
  609. if ($order_money <= $this->member_balance_money) {
  610. $balance_money = $order_money;
  611. } else {
  612. $balance_money = $this->member_balance_money;
  613. }
  614. } else {
  615. $balance_money = 0;
  616. }
  617. $pay_money = $order_money - $balance_money;//计算出实际支付金额
  618. $this->member_balance_money -= $balance_money;//预减少账户余额
  619. $this->balance_money += $balance_money;//累计余额
  620. //总结计算
  621. $shop_goods[ 'store_id' ] = $store_id;
  622. $shop_goods[ 'goods_money' ] = $goods_money;
  623. $shop_goods[ 'delivery_money' ] = $delivery_money;
  624. $shop_goods[ 'coupon_money' ] = $coupon_money;
  625. $shop_goods[ 'adjust_money' ] = $adjust_money;
  626. $shop_goods[ 'promotion_money' ] = $promotion_money;
  627. $shop_goods[ 'order_money' ] = $order_money;
  628. $shop_goods[ 'balance_money' ] = $balance_money;
  629. $shop_goods[ 'pay_money' ] = $pay_money;
  630. $this->goods_money += $goods_money;
  631. $this->delivery_money += $delivery_money;
  632. $this->coupon_money += $coupon_money;
  633. $this->adjust_money += $adjust_money;
  634. $this->invoice_money += $shop_goods[ 'invoice_money' ];
  635. $this->invoice_delivery_money += $shop_goods[ 'invoice_delivery_money' ];
  636. $this->promotion_money += $promotion_money;
  637. $this->order_money += $order_money;
  638. $this->pay_money += $pay_money;
  639. $this->goods_num += $shop_goods[ "goods_num" ];
  640. $this->order_name = string_split($this->order_name, ",", $shop_goods[ "order_name" ]);
  641. return $shop_goods;
  642. }
  643. }