StoreOrder.php 108 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383
  1. <?php
  2. /**
  3. *
  4. * @author: xaboy<365615158@qq.com>
  5. * @day: 2017/12/20
  6. */
  7. namespace app\models\store;
  8. use app\admin\model\system\ShippingTemplatesFree;
  9. use app\admin\model\system\ShippingTemplatesRegion;
  10. use app\admin\model\user\Ach;
  11. use app\admin\model\user\Achievement;
  12. use app\admin\model\user\UserProduct;
  13. use crmeb\basic\BaseModel;
  14. use think\db\exception\DataNotFoundException;
  15. use think\db\exception\DbException;
  16. use think\db\exception\ModelNotFoundException;
  17. use think\facade\Cache;
  18. use crmeb\traits\ModelTrait;
  19. use think\facade\Log;
  20. use app\models\system\SystemStore;
  21. use app\models\routine\RoutineTemplate;
  22. use think\session\Store;
  23. use app\models\user\{User, UserAddress, UserBill, UserSpread, WechatUser};
  24. use crmeb\services\{
  25. SystemConfigService, WechatTemplateService, workerman\ChannelService
  26. };
  27. use crmeb\repositories\{
  28. GoodsRepository, PaymentRepositories, OrderRepository, ShortLetterRepositories, UserRepository
  29. };
  30. use app\admin\model\system\ShippingTemplates;
  31. /**
  32. * TODO 订单Model
  33. * Class StoreOrder
  34. * @package app\models\store
  35. */
  36. class StoreOrder extends BaseModel
  37. {
  38. /**
  39. * 数据表主键
  40. * @var string
  41. */
  42. protected $pk = 'id';
  43. /**
  44. * 模型名称
  45. * @var string
  46. */
  47. protected $name = 'store_order';
  48. use ModelTrait;
  49. protected $insert = ['add_time'];
  50. protected static $payType = ['weixin' => '微信支付', 'yue' => '余额支付', 'offline' => '线下支付'];
  51. protected static $deliveryType = ['send' => '商家配送', 'express' => '快递配送'];
  52. protected function setAddTimeAttr()
  53. {
  54. return time();
  55. }
  56. protected function setCartIdAttr($value)
  57. {
  58. return is_array($value) ? json_encode($value) : $value;
  59. }
  60. protected function getCartIdAttr($value)
  61. {
  62. return json_decode($value, true);
  63. }
  64. /**获取订单组信息
  65. * @param $cartInfo
  66. * @return array
  67. */
  68. public static function getOrderPriceGroup($cartInfo, $addr)
  69. {
  70. $storeFreePostage = floatval(sys_config('store_free_postage')) ?: 0;//满额包邮
  71. $totalPrice = self::getOrderSumPrice($cartInfo, 'truePrice');//获取订单总金额
  72. $totalIntegral = self::getOrderSumPrice($cartInfo, 'integral');//获取订单总积分
  73. $costPrice = self::getOrderSumPrice($cartInfo, 'costPrice');//获取订单成本价
  74. $vipPrice = self::getOrderSumPrice($cartInfo, 'vip_truePrice');//获取订单会员优惠金额
  75. //如果满额包邮等于0
  76. if (!$storeFreePostage) {
  77. $storePostage = 0;
  78. } else {
  79. if ($addr) {
  80. //按照运费模板计算每个运费模板下商品的件数/重量/体积以及总金额 按照首重倒序排列
  81. $temp_num = [];
  82. foreach ($cartInfo as $cart) {
  83. $temp = ShippingTemplates::get($cart['productInfo']['temp_id']);
  84. if (!$temp) $temp = ShippingTemplates::get(1);
  85. if ($temp->getData('type') == 1) {
  86. $num = $cart['cart_num'];
  87. } elseif ($temp->getData('type') == 2) {
  88. $num = $cart['cart_num'] * $cart['productInfo']['attrInfo']['weight'];
  89. } else {
  90. $num = $cart['cart_num'] * $cart['productInfo']['attrInfo']['volume'];
  91. }
  92. $region = ShippingTemplatesRegion::where('temp_id', $cart['productInfo']['temp_id'])->where('city_id', $addr['city_id'])->find();
  93. if (!$region) $region = ShippingTemplatesRegion::where('temp_id', $cart['productInfo']['temp_id'])->where('city_id', 0)->find();
  94. if (!$region) $region = ShippingTemplatesRegion::where('temp_id', 1)->where('city_id', 0)->find();
  95. if (!$region) {
  96. return self::setErrorInfo('运费模板不存在');
  97. }
  98. if (!isset($temp_num[$cart['productInfo']['temp_id']])) {
  99. $temp_num[$cart['productInfo']['temp_id']]['number'] = $num;
  100. $temp_num[$cart['productInfo']['temp_id']]['price'] = bcmul($cart['cart_num'], $cart['truePrice'], 2);
  101. $temp_num[$cart['productInfo']['temp_id']]['first'] = $region['first'];
  102. $temp_num[$cart['productInfo']['temp_id']]['first_price'] = $region['first_price'];
  103. $temp_num[$cart['productInfo']['temp_id']]['continue'] = $region['continue'];
  104. $temp_num[$cart['productInfo']['temp_id']]['continue_price'] = $region['continue_price'];
  105. $temp_num[$cart['productInfo']['temp_id']]['temp_id'] = $cart['productInfo']['temp_id'];
  106. $temp_num[$cart['productInfo']['temp_id']]['city_id'] = $addr['city_id'];
  107. } else {
  108. $temp_num[$cart['productInfo']['temp_id']]['number'] += $num;
  109. $temp_num[$cart['productInfo']['temp_id']]['price'] += bcmul($cart['cart_num'], $cart['truePrice'], 2);
  110. }
  111. }
  112. array_multisort(array_column($temp_num, 'first_price'), SORT_DESC, $temp_num);
  113. $type = $storePostage = 0;
  114. foreach ($temp_num as $k => $v) {
  115. if (ShippingTemplatesFree::where('temp_id', $v['temp_id'])->where('city_id', $v['city_id'])->where('number', '<=', $v['number'])->where('price', '<=', $v['price'])->find()) {
  116. unset($temp_num[$k]);
  117. }
  118. }
  119. foreach ($temp_num as $v) {
  120. if ($type == 0) {
  121. if ($v['number'] <= $v['first']) {
  122. $storePostage = bcadd($storePostage, $v['first_price'], 2);
  123. } else {
  124. if ($v['continue'] <= 0) {
  125. $storePostage = $storePostage;
  126. } else {
  127. $storePostage = bcadd(bcadd($storePostage, $v['first_price'], 2), bcmul(ceil(bcdiv(bcsub($v['number'], $v['first']), $v['continue'] ?? 0, 2)), $v['continue_price']), 2);
  128. }
  129. }
  130. $type = 1;
  131. } else {
  132. if ($v['continue'] <= 0) {
  133. $storePostage = $storePostage;
  134. } else {
  135. $storePostage = bcadd($storePostage, bcmul(ceil(bcdiv($v['number'], $v['continue'] ?? 0, 2)), $v['continue_price']), 2);
  136. }
  137. }
  138. }
  139. } else {
  140. $storePostage = 0;
  141. }
  142. if ($storeFreePostage <= $totalPrice) $storePostage = 0;//如果总价大于等于满额包邮 邮费等于0
  143. }
  144. return compact('storePostage', 'storeFreePostage', 'totalPrice', 'costPrice', 'vipPrice', 'totalIntegral');
  145. }
  146. /**获取某个字段总金额
  147. * @param $cartInfo
  148. * @param $key 键名
  149. * @return int|string
  150. */
  151. public static function getOrderSumPrice($cartInfo, $key = 'truePrice')
  152. {
  153. $SumPrice = 0;
  154. foreach ($cartInfo as $cart) {
  155. $SumPrice = bcadd($SumPrice, bcmul($cart['cart_num'], $cart[$key], 2), 2);
  156. }
  157. return $SumPrice;
  158. }
  159. /**
  160. * 拼团
  161. * @param $cartInfo
  162. * @return array
  163. */
  164. public static function getCombinationOrderPriceGroup($cartInfo)
  165. {
  166. $storePostage = floatval(sys_config('store_postage')) ?: 0;
  167. $storeFreePostage = floatval(sys_config('store_free_postage')) ?: 0;
  168. $totalPrice = self::getCombinationOrderTotalPrice($cartInfo);
  169. $costPrice = self::getCombinationOrderTotalPrice($cartInfo);
  170. if (!$storeFreePostage) {
  171. $storePostage = 0;
  172. } else {
  173. foreach ($cartInfo as $cart) {
  174. if (!StoreCombination::where('id', $cart['combination_id'])->value('is_postage'))
  175. $storePostage = bcadd($storePostage, StoreCombination::where('id', $cart['combination_id'])->value('postage'), 2);
  176. }
  177. if ($storeFreePostage <= $totalPrice) $storePostage = 0;
  178. }
  179. return compact('storePostage', 'storeFreePostage', 'totalPrice', 'costPrice');
  180. }
  181. /**
  182. * 拼团价格
  183. * @param $cartInfo
  184. * @return float
  185. */
  186. public static function getCombinationOrderTotalPrice($cartInfo)
  187. {
  188. $totalPrice = 0;
  189. foreach ($cartInfo as $cart) {
  190. if ($cart['combination_id']) {
  191. $totalPrice = bcadd($totalPrice, bcmul($cart['cart_num'], StoreCombination::where('id', $cart['combination_id'])->value('price'), 2), 2);
  192. }
  193. }
  194. return (float)$totalPrice;
  195. }
  196. /**
  197. * 缓存订单信息
  198. * @param $uid
  199. * @param $cartInfo
  200. * @param $priceGroup
  201. * @param array $other
  202. * @param int $cacheTime
  203. * @return string
  204. * @throws \Psr\SimpleCache\InvalidArgumentException
  205. */
  206. public static function cacheOrderInfo($uid, $cartInfo, $priceGroup, $other = [], $cacheTime = 600)
  207. {
  208. do {
  209. $key = md5(time() . rand(100000, 999999));
  210. } while (Cache::has('user_order_' . $uid . $key));
  211. Cache::set('user_order_' . $uid . $key, compact('cartInfo', 'priceGroup', 'other'), $cacheTime);
  212. return $key;
  213. }
  214. /**
  215. * 获取订单缓存信息
  216. * @param $uid
  217. * @param $key
  218. * @return mixed|null
  219. * @throws \Psr\SimpleCache\InvalidArgumentException
  220. */
  221. public static function getCacheOrderInfo($uid, $key)
  222. {
  223. $cacheName = 'user_order_' . $uid . $key;
  224. if (!Cache::has($cacheName)) return null;
  225. return Cache::get($cacheName);
  226. }
  227. /**
  228. * 删除订单缓存
  229. * @param $uid
  230. * @param $key
  231. */
  232. public static function clearCacheOrderInfo($uid, $key)
  233. {
  234. Cache::delete('user_order_' . $uid . $key);
  235. }
  236. /**
  237. * 生成订单
  238. * @param $uid
  239. * @param $key
  240. * @param $addressId
  241. * @param $payType
  242. * @param bool $useIntegral
  243. * @param int $couponId
  244. * @param string $mark
  245. * @param int $combinationId
  246. * @param int $pinkId
  247. * @param int $seckill_id
  248. * @param int $bargain_id
  249. * @param bool $test
  250. * @param int $isChannel
  251. * @param int $shipping_type
  252. * @param string $real_name
  253. * @param string $phone
  254. * @return StoreOrder|bool|\think\Model
  255. * @throws \think\Exception
  256. * @throws DataNotFoundException
  257. * @throws ModelNotFoundException
  258. * @throws \think\exception\DbException
  259. */
  260. public static function cacheKeyCreateOrder($uid, $key, $addressId, $payType, $useIntegral = false, $couponId = 0, $mark = '', $combinationId = 0, $pinkId = 0, $seckill_id = 0, $bargain_id = 0, $test = false, $isChannel = 0, $shipping_type = 1, $real_name = '', $phone = '', $storeId = 0)
  261. {
  262. self::beginTrans();
  263. try {
  264. $shipping_type = (int)$shipping_type;
  265. $offlinePayStatus = (int)sys_config('offline_pay_status') ?? (int)2;
  266. if ($offlinePayStatus == 2) unset(self::$payType['offline']);
  267. if (!array_key_exists($payType, self::$payType)) return self::setErrorInfo('选择支付方式有误!', true);
  268. if (self::be(['unique' => $key, 'uid' => $uid])) return self::setErrorInfo('请勿重复提交订单', true);
  269. $userInfo = User::getUserInfo($uid);
  270. if (!$userInfo) return self::setErrorInfo('用户不存在!', true);
  271. $cartGroup = self::getCacheOrderInfo($uid, $key);
  272. if (!$cartGroup) return self::setErrorInfo('订单已过期,请刷新当前页面!', true);
  273. $cartInfo = $cartGroup['cartInfo'];
  274. $priceGroup = $cartGroup['priceGroup'];
  275. $other = $cartGroup['other'];
  276. $payPrice = (float)$priceGroup['totalPrice'];
  277. $payIntegral = (float)$priceGroup['totalIntegral'];
  278. $addr = UserAddress::where('uid', $uid)->where('id', $addressId)->find();
  279. if ($payType == 'offline' && sys_config('offline_postage') == 1) {
  280. $payPostage = 0;
  281. } else {
  282. $payPostage = self::getOrderPriceGroup($cartInfo, $addr)['storePostage'];
  283. }
  284. if ($shipping_type === 1) {
  285. if (!$test && !$addressId) return self::setErrorInfo('请选择收货地址!', true);
  286. if (!$test && (!UserAddress::be(['uid' => $uid, 'id' => $addressId, 'is_del' => 0]) || !($addressInfo = UserAddress::find($addressId))))
  287. return self::setErrorInfo('地址选择有误!', true);
  288. } else {
  289. if ((!$real_name || !$phone) && !$test) return self::setErrorInfo('请填写姓名和电话', true);
  290. $addressInfo['real_name'] = $real_name;
  291. $addressInfo['phone'] = $phone;
  292. $addressInfo['province'] = '';
  293. $addressInfo['city'] = '';
  294. $addressInfo['district'] = '';
  295. $addressInfo['detail'] = '';
  296. }
  297. $cartIds = [];
  298. $totalNum = 0;
  299. $gainIntegral = 0;
  300. foreach ($cartInfo as $cart) {
  301. $cartIds[] = $cart['id'];
  302. $totalNum += $cart['cart_num'];
  303. if (!$seckill_id) $seckill_id = $cart['seckill_id'];
  304. if (!$bargain_id) $bargain_id = $cart['bargain_id'];
  305. if (!$combinationId) $combinationId = $cart['combination_id'];
  306. $cartInfoGainIntegral = isset($cart['productInfo']['give_integral']) ? bcmul($cart['cart_num'], $cart['productInfo']['give_integral'], 2) : 0;
  307. $gainIntegral = bcadd($gainIntegral, $cartInfoGainIntegral, 2);
  308. }
  309. $deduction = $seckill_id || $bargain_id || $combinationId;
  310. if ($deduction) {
  311. $couponId = 0;
  312. $useIntegral = false;
  313. if (!$test) {
  314. unset(self::$payType['offline']);
  315. if (!array_key_exists($payType, self::$payType)) return self::setErrorInfo('营销产品不能使用线下支付!', true);
  316. }
  317. }
  318. //使用优惠劵
  319. $res1 = true;
  320. if ($couponId) {
  321. $couponInfo = StoreCouponUser::validAddressWhere()->where('id', $couponId)->where('uid', $uid)->find();
  322. if (!$couponInfo) return self::setErrorInfo('选择的优惠劵无效!', true);
  323. $coupons = StoreCouponUser::getUsableCouponList($uid, ['valid' => $cartInfo], $payPrice);
  324. $flag = false;
  325. foreach ($coupons as $coupon) {
  326. if ($coupon['id'] == $couponId) {
  327. $flag = true;
  328. continue;
  329. }
  330. }
  331. if (!$flag)
  332. return self::setErrorInfo('不满足优惠劵的使用条件!', true);
  333. $payPrice = (float)bcsub($payPrice, $couponInfo['coupon_price'], 2);
  334. $res1 = StoreCouponUser::useCoupon($couponId);
  335. $couponPrice = $couponInfo['coupon_price'];
  336. } else {
  337. $couponId = 0;
  338. $couponPrice = 0;
  339. }
  340. if (!$res1) return self::setErrorInfo('使用优惠劵失败!', true);
  341. //$shipping_type = 1 快递发货 $shipping_type = 2 门店自提
  342. $store_self_mention = sys_config('store_self_mention') ?? 0;
  343. if (!$store_self_mention) $shipping_type = 1;
  344. if ($shipping_type === 1) {
  345. //是否包邮
  346. if ((isset($other['offlinePostage']) && $other['offlinePostage'] && $payType == 'offline')) $payPostage = 0;
  347. $payPrice = (float)bcadd($payPrice, $payPostage, 2);
  348. } else if ($shipping_type === 2) {
  349. //门店自提没有邮费支付
  350. $priceGroup['storePostage'] = 0;
  351. $payPostage = 0;
  352. if (!$storeId && !$test) {
  353. return self::setErrorInfo('请选择门店', true);
  354. }
  355. }
  356. //积分抵扣
  357. $res2 = true;
  358. $SurplusIntegral = $userInfo['integral'];
  359. if ($payIntegral > 0) {
  360. if ($userInfo['integral'] < $payIntegral) {
  361. return self::setErrorInfo('积分不足', true);
  362. } else {
  363. $res2 = false !== User::bcDec($userInfo['uid'], 'integral', $payIntegral, 'uid');
  364. }
  365. $SurplusIntegral = bcsub($userInfo['integral'], $payIntegral, 2);
  366. $res2 = $res2 && false != UserBill::expend('积分商品', $uid, 'integral', 'integral_product', $payIntegral, $key, $SurplusIntegral, '购买积分商品使用' . $payIntegral . '积分');
  367. }
  368. //积分抵扣
  369. if ($useIntegral && $SurplusIntegral > 0) {
  370. $deductionPrice = (float)bcmul($SurplusIntegral, $other['integralRatio'], 2);
  371. if ($deductionPrice < $payPrice) {
  372. $payPrice = bcsub($payPrice, $deductionPrice, 2);
  373. $usedIntegral = $SurplusIntegral;
  374. $SurplusIntegral = 0;
  375. $res2 = false !== User::edit(['integral' => 0], $userInfo['uid'], 'uid');
  376. } else {
  377. $deductionPrice = $payPrice;
  378. $usedIntegral = (float)bcdiv($payPrice, $other['integralRatio'], 2);
  379. $SurplusIntegral = bcsub($SurplusIntegral, $usedIntegral, 2);
  380. $res2 = false !== User::bcDec($userInfo['uid'], 'integral', $usedIntegral, 'uid');
  381. $payPrice = 0;
  382. }
  383. $res2 = $res2 && false != UserBill::expend('积分抵扣', $uid, 'integral', 'deduction', $usedIntegral, $key, $SurplusIntegral, '购买商品使用' . floatval($usedIntegral) . '积分抵扣' . floatval($deductionPrice) . '元');
  384. } else {
  385. $deductionPrice = 0;
  386. $usedIntegral = 0;
  387. }
  388. if (!$res2) return self::setErrorInfo('使用积分抵扣失败!', true);
  389. if ($payPrice <= 0) $payPrice = 0;
  390. if ($test) {
  391. self::rollbackTrans();
  392. return [
  393. 'total_price' => $priceGroup['totalPrice'],
  394. 'pay_price' => $payPrice,
  395. 'pay_postage' => $payPostage,
  396. 'coupon_price' => $couponPrice,
  397. 'deduction_price' => $deductionPrice,
  398. 'totalIntegral' => $payIntegral,
  399. 'SurplusIntegral' => $SurplusIntegral,
  400. ];
  401. }
  402. $orderInfo = [
  403. 'uid' => $uid,
  404. 'order_id' => $test ? 0 : self::getNewOrderId(),
  405. 'real_name' => $addressInfo['real_name'],
  406. 'user_phone' => $addressInfo['phone'],
  407. 'user_address' => $addressInfo['province'] . ' ' . $addressInfo['city'] . ' ' . $addressInfo['district'] . ' ' . $addressInfo['detail'],
  408. 'cart_id' => $cartIds,
  409. 'total_num' => $totalNum,
  410. 'total_price' => $priceGroup['totalPrice'],
  411. 'total_postage' => $priceGroup['storePostage'],
  412. 'coupon_id' => $couponId,
  413. 'coupon_price' => $couponPrice,
  414. 'pay_price' => $payPrice,
  415. 'pay_postage' => $payPostage,
  416. 'deduction_price' => $deductionPrice,
  417. 'paid' => 0,
  418. 'pay_type' => $payType,
  419. 'use_integral' => $usedIntegral + $payIntegral,
  420. 'gain_integral' => $gainIntegral,
  421. 'mark' => htmlspecialchars($mark),
  422. 'combination_id' => $combinationId,
  423. 'pink_id' => $pinkId,
  424. 'seckill_id' => $seckill_id,
  425. 'bargain_id' => $bargain_id,
  426. 'cost' => $priceGroup['costPrice'],
  427. 'is_channel' => $isChannel,
  428. 'add_time' => time(),
  429. 'unique' => $key,
  430. 'shipping_type' => $shipping_type,
  431. ];
  432. if ($shipping_type === 2) {
  433. $orderInfo['verify_code'] = self::getStoreCode();
  434. $orderInfo['store_id'] = SystemStore::getStoreDispose($storeId, 'id');
  435. if (!$orderInfo['store_id']) return self::setErrorInfo('暂无门店无法选择门店自提!', true);
  436. }
  437. $order = self::create($orderInfo);
  438. if (!$order) return self::setErrorInfo('订单生成失败!', true);
  439. $res5 = true;
  440. foreach ($cartInfo as $cart) {
  441. //减库存加销量
  442. if ($combinationId) $res5 = $res5 && StoreCombination::decCombinationStock($cart['cart_num'], $combinationId, isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
  443. else if ($seckill_id) $res5 = $res5 && StoreSeckill::decSeckillStock($cart['cart_num'], $seckill_id, isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
  444. else if ($bargain_id) $res5 = $res5 && StoreBargain::decBargainStock($cart['cart_num'], $bargain_id, isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
  445. else $res5 = $res5 && StoreProduct::decProductStock($cart['cart_num'], $cart['productInfo']['id'], isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
  446. }
  447. //保存购物车商品信息
  448. $res4 = false !== StoreOrderCartInfo::setCartInfo($order['id'], $cartInfo);
  449. //购物车状态修改
  450. $res6 = false !== StoreCart::where('id', 'IN', $cartIds)->update(['is_pay' => 1]);
  451. if (!$res4 || !$res5 || !$res6) return self::setErrorInfo('订单生成失败!', true);
  452. //自动设置默认地址
  453. UserRepository::storeProductOrderCreateEbApi($order, compact('cartInfo', 'addressId'));
  454. self::clearCacheOrderInfo($uid, $key);
  455. self::commitTrans();
  456. StoreOrderStatus::status($order['id'], 'cache_key_create_order', '订单生成');
  457. return $order;
  458. } catch (\PDOException $e) {
  459. self::rollbackTrans();
  460. return self::setErrorInfo('生成订单时SQL执行错误错误原因:' . $e->getMessage());
  461. } catch (\Exception $e) {
  462. self::rollbackTrans();
  463. return self::setErrorInfo('生成订单时系统错误错误原因:' . $e->getMessage());
  464. }
  465. }
  466. /**
  467. * 回退积分
  468. * @param $order 订单信息
  469. * @return bool
  470. */
  471. public static function RegressionIntegral($order)
  472. {
  473. if ($order['paid'] || $order['status'] == -2 || $order['is_del']) return true;
  474. if ($order['use_integral'] <= 0) return true;
  475. if ((int)$order['status'] != -2 && (int)$order['refund_status'] != 2 && $order['back_integral'] >= $order['use_integral']) return true;
  476. $res = User::bcInc($order['uid'], 'integral', $order['use_integral']);
  477. if (!$res) return self::setErrorInfo('回退积分增加失败');
  478. UserBill::income('积分回退', $order['uid'], 'integral', 'deduction', $order['use_integral'], $order['unique'], User::where('uid', $order['uid'])->value('integral'), '购买商品失败,回退积分' . floatval($order['use_integral']));
  479. return false !== self::where('order_id', $order['order_id'])->update(['back_integral' => $order['use_integral']]);
  480. }
  481. /**
  482. * 回退库存和销量
  483. * @param $order 订单信息
  484. * @return bool
  485. * @throws DataNotFoundException
  486. * @throws ModelNotFoundException
  487. * @throws \think\exception\DbException
  488. */
  489. public static function RegressionStock($order)
  490. {
  491. if ($order['paid'] || $order['status'] == -2 || $order['is_del']) return true;
  492. $combinationId = $order['combination_id'];
  493. $seckill_id = $order['seckill_id'];
  494. $bargain_id = $order['bargain_id'];
  495. $res5 = true;
  496. $cartInfo = StoreOrderCartInfo::where('cart_id', 'in', $order['cart_id'])->select();
  497. foreach ($cartInfo as $cart) {
  498. //增库存减销量
  499. if ($combinationId) $res5 = $res5 && StoreCombination::incCombinationStock($cart['cart_info']['cart_num'], $combinationId);
  500. else if ($seckill_id) $res5 = $res5 && StoreSeckill::incSeckillStock($cart['cart_info']['cart_num'], $seckill_id);
  501. else if ($bargain_id) $res5 = $res5 && StoreBargain::incBargainStock($cart['cart_info']['cart_num'], $bargain_id);
  502. else $res5 = $res5 && StoreProduct::incProductStock($cart['cart_info']['cart_num'], $cart['cart_info']['productInfo']['id'], isset($cart['cart_info']['productInfo']['attrInfo']) ? $cart['cart_info']['productInfo']['attrInfo']['unique'] : '');
  503. }
  504. return $res5;
  505. }
  506. /**
  507. * 回退优惠卷
  508. * @param $order 订单信息
  509. * @return bool
  510. */
  511. public static function RegressionCoupon($order)
  512. {
  513. if ($order['paid'] || $order['status'] == -2 || $order['is_del']) return true;
  514. $res = true;
  515. if ($order['coupon_id'] && StoreCouponUser::be(['id' => $order['coupon_id'], 'uid' => $order['uid'], 'status' => 1])) {
  516. $res = $res && false !== StoreCouponUser::where('id', $order['coupon_id'])->where('uid', $order['uid'])->update(['status' => 0, 'use_time' => 0]);
  517. }
  518. return $res;
  519. }
  520. /**
  521. * 取消订单
  522. * @param string order_id 订单id
  523. * @param $uid
  524. * @return bool
  525. * @throws DataNotFoundException
  526. * @throws ModelNotFoundException
  527. * @throws \think\exception\DbException
  528. */
  529. public static function cancelOrder($order_id, $uid)
  530. {
  531. $order = self::where('order_id', $order_id)->where('uid', $uid)->find();
  532. if (!$order) return self::setErrorInfo('没有查到此订单');
  533. self::beginTrans();
  534. try {
  535. $res = self::RegressionIntegral($order) && self::RegressionStock($order) && self::RegressionCoupon($order);
  536. $order->is_del = 1;
  537. if ($res && $order->save()) {
  538. self::commitTrans();
  539. return true;
  540. } else
  541. return false;
  542. } catch (\Exception $e) {
  543. self::rollbackTrans();
  544. return self::setErrorInfo(['line' => $e->getLine(), 'message' => $e->getMessage()]);
  545. }
  546. }
  547. /**
  548. * 生成订单唯一id
  549. * @param $uid 用户uid
  550. * @return string
  551. */
  552. public static function getNewOrderId()
  553. {
  554. do {
  555. list($msec, $sec) = explode(' ', microtime());
  556. $msectime = number_format((floatval($msec) + floatval($sec)) * 1000, 0, '', '');
  557. $orderId = 'wx' . $msectime . mt_rand(10000, 99999);
  558. } while (self::be(['order_id' => $orderId]));// $orderId = 'wx' . $msectime . mt_rand(10000, 99999);
  559. return $orderId;
  560. }
  561. /**
  562. * 修改订单号
  563. * @param $orderId
  564. * @return string
  565. */
  566. public static function changeOrderId($orderId)
  567. {
  568. $ymd = substr($orderId, 2, 8);
  569. $key = substr($orderId, 16);
  570. return 'wx' . $ymd . date('His') . $key;
  571. }
  572. /**
  573. * 查找购物车里的所有产品标题
  574. * @param $cartId 购物车id
  575. * @return bool|string
  576. */
  577. public static function getProductTitle($cartId)
  578. {
  579. $title = '';
  580. try {
  581. $orderCart = StoreOrderCartInfo::where('cart_id', 'in', $cartId)->field('cart_info')->select();
  582. foreach ($orderCart as $item) {
  583. if (isset($item['cart_info']['productInfo']['store_name'])) {
  584. $title .= $item['cart_info']['productInfo']['store_name'] . '|';
  585. }
  586. }
  587. unset($item);
  588. if (!$title) {
  589. $productIds = StoreCart::where('id', 'in', $cartId)->column('product_id');
  590. $productlist = ($productlist = StoreProduct::getProductField($productIds, 'store_name')) ? $productlist->toArray() : [];
  591. foreach ($productlist as $item) {
  592. if (isset($item['store_name'])) $title .= $item['store_name'] . '|';
  593. }
  594. }
  595. if ($title) $title = substr($title, 0, strlen($title) - 1);
  596. unset($item);
  597. } catch (\Exception $e) {
  598. }
  599. return $title;
  600. }
  601. /**
  602. * 获取门店自提唯一核销码
  603. * @return bool|string
  604. */
  605. public static function getStoreCode()
  606. {
  607. list($msec, $sec) = explode(' ', microtime());
  608. $num = bcadd(time(), mt_rand(10, 999999), 0) . '' . substr($msec, 2, 3);//生成随机数
  609. if (strlen($num) < 12)
  610. $num = str_pad((string)$num, 12, 0, STR_PAD_RIGHT);
  611. else
  612. $num = substr($num, 0, 12);
  613. if (self::be(['verify_code' => $num])) return self::getStoreCode();
  614. return $num;
  615. }
  616. /**
  617. * 余额支付
  618. * @param $order_id
  619. * @param $uid
  620. * @param string $formId
  621. * @return bool
  622. * @throws \think\Exception
  623. * @throws DataNotFoundException
  624. * @throws ModelNotFoundException
  625. * @throws \think\exception\DbException
  626. */
  627. public static function yuePay($order_id, $uid, $formId = '')
  628. {
  629. $orderInfo = self::where('uid', $uid)->where('order_id', $order_id)->where('is_del', 0)->find();
  630. if (!$orderInfo) return self::setErrorInfo('订单不存在!');
  631. if ($orderInfo['paid']) return self::setErrorInfo('该订单已支付!');
  632. // if($orderInfo['pay_type'] != 'yue') return self::setErrorInfo('该订单不能使用余额支付!');
  633. $userInfo = User::getUserInfo($uid);
  634. if ($userInfo['now_money'] < $orderInfo['pay_price'])
  635. return self::setErrorInfo(['status' => 'pay_deficiency', 'msg' => '余额不足' . floatval($orderInfo['pay_price'])]);
  636. self::beginTrans();
  637. $res1 = false !== User::bcDec($uid, 'now_money', $orderInfo['pay_price'], 'uid');
  638. $res2 = UserBill::expend('购买商品', $uid, 'now_money', 'pay_product', $orderInfo['pay_price'], $orderInfo['id'], $userInfo['now_money'], '余额支付' . floatval($orderInfo['pay_price']) . '元购买商品');
  639. $res3 = self::paySuccess($order_id, 'yue', $formId);//余额支付成功
  640. try {
  641. PaymentRepositories::yuePayProduct($userInfo, $orderInfo);
  642. } catch (\Exception $e) {
  643. self::rollbackTrans();
  644. return self::setErrorInfo($e->getMessage());
  645. }
  646. $res = $res1 && $res2 && $res3;
  647. self::checkTrans($res);
  648. return $res;
  649. }
  650. /**
  651. * 微信支付 为 0元时
  652. * @param $order_id
  653. * @param $uid
  654. * @param string $formId
  655. * @return bool
  656. * @throws \think\Exception
  657. * @throws DataNotFoundException
  658. * @throws ModelNotFoundException
  659. * @throws \think\exception\DbException
  660. */
  661. public static function jsPayPrice($order_id, $uid, $formId = '')
  662. {
  663. $orderInfo = self::where('uid', $uid)->where('order_id', $order_id)->where('is_del', 0)->find();
  664. if (!$orderInfo) return self::setErrorInfo('订单不存在!');
  665. if ($orderInfo['paid']) return self::setErrorInfo('该订单已支付!');
  666. $userInfo = User::getUserInfo($uid);
  667. self::beginTrans();
  668. $res1 = UserBill::expend('购买商品', $uid, 'now_money', 'pay_product', $orderInfo['pay_price'], $orderInfo['id'], $userInfo['now_money'], '微信支付' . floatval($orderInfo['pay_price']) . '元购买商品');
  669. $res2 = self::paySuccess($order_id, 'weixin', $formId);//微信支付为0时
  670. $res = $res1 && $res2;
  671. self::checkTrans($res);
  672. return $res;
  673. }
  674. /**
  675. * 用户申请退款
  676. * @param $uni
  677. * @param $uid
  678. * @param string $refundReasonWap
  679. * @return bool
  680. */
  681. public static function orderApplyRefund($uni, $uid, $refundReasonWap = '', $refundReasonWapExplain = '', $refundReasonWapImg = [])
  682. {
  683. $order = self::getUserOrderDetail($uid, $uni);
  684. if (!$order) return self::setErrorInfo('支付订单不存在!');
  685. if ($order['refund_status'] == 2) return self::setErrorInfo('订单已退款!');
  686. if ($order['refund_status'] == 1) return self::setErrorInfo('正在申请退款中!');
  687. if ($order['status'] == 1) return self::setErrorInfo('订单当前无法退款!');
  688. self::beginTrans();
  689. $res1 = false !== StoreOrderStatus::status($order['id'], 'apply_refund', '用户申请退款,原因:' . $refundReasonWap);
  690. $res2 = false !== self::edit(['refund_status' => 1, 'refund_reason_time' => time(), 'refund_reason_wap' => $refundReasonWap, 'refund_reason_wap_explain' => $refundReasonWapExplain, 'refund_reason_wap_img' => json_encode($refundReasonWapImg)], $order['id'], 'id');
  691. $res = $res1 && $res2;
  692. self::checkTrans($res);
  693. if (!$res)
  694. return self::setErrorInfo('申请退款失败!');
  695. else {
  696. try {
  697. if (in_array($order['is_channel'], [0, 2])) {
  698. //公众号发送模板消息通知客服
  699. WechatTemplateService::sendAdminNoticeTemplate([
  700. 'first' => "亲,有个订单申请退款 \n订单号:{$order['order_id']}",
  701. 'keyword1' => '退款申请',
  702. 'keyword2' => '已支付',
  703. 'keyword3' => date('Y/m/d H:i', time()),
  704. 'remark' => '请及时处理'
  705. ]);
  706. }
  707. if (in_array($order['is_channel'], [1, 2])) {
  708. //小程序 发送模板消息
  709. RoutineTemplate::sendOrderRefundStatus($order, $refundReasonWap);
  710. }
  711. //通知后台消息提醒
  712. ChannelService::instance()->send('NEW_REFUND_ORDER', ['order_id' => $order['order_id']]);
  713. } catch (\Exception $e) {
  714. }
  715. //发送短信
  716. event('ShortMssageSend', [$order['order_id'], 'AdminRefund']);
  717. return true;
  718. }
  719. }
  720. /**
  721. * //TODO 支付成功后
  722. * @param $orderId
  723. * @param string $paytype
  724. * @param string $formId
  725. * @return bool
  726. * @throws DataNotFoundException
  727. * @throws DbException
  728. * @throws ModelNotFoundException
  729. */
  730. public static function paySuccess($orderId, $paytype = 'weixin', $formId = '')
  731. {
  732. $order = self::where('order_id', $orderId)->find();
  733. $productId = StoreProduct::where('is_upgrade', 1)->column('id');
  734. self::reward($order, 1);
  735. $resPink = true;
  736. $res1 = self::where('order_id', $orderId)->update(['paid' => 1, 'pay_type' => $paytype, 'pay_time' => time(), 'is_del' => 0, 'is_system_del' => 0, 'mark' => '']);//订单改为支付
  737. if ($order->combination_id && $res1 && !$order->refund_status) $resPink = StorePink::createPink($order);//创建拼团
  738. $oid = self::where('order_id', $orderId)->value('id');
  739. StoreOrderStatus::status($oid, 'pay_success', '用户付款成功');
  740. $now_money = User::where('uid', $order['uid'])->value('now_money');
  741. UserBill::expend('购买商品', $order['uid'], 'now_money', 'pay_money', $order['pay_price'], $order['id'], $now_money, '支付' . floatval($order['pay_price']) . '元购买商品');
  742. //支付成功后
  743. event('OrderPaySuccess', [$order, $formId]);
  744. $res = $res1 && $resPink && UserSpread::setSpreadSure($order['uid']) && User::backOrderBrokerage($order);
  745. return false !== $res;
  746. }
  747. public static function reward($order,$type)
  748. {
  749. $list = StoreOrderCartInfo::where('oid', $order['id'])->select();
  750. $user = User::where('uid', $order['uid'])->find();
  751. $user1 = User::where('uid', $user['spread_uid'])->find();
  752. $user2 = User::where('uid', $user1['spread_uid'])->find();
  753. if ($type == 1){
  754. $str = '购买';
  755. foreach ($list as $item){
  756. $product = StoreProduct::where('id', $item['product_id'])->find();
  757. $num = $item['cart_info']['cart_num'];
  758. $price1 = $product['push'] * $num;// 直推奖励
  759. $price3 = $product['Interposition'] * $num;// 间推奖励
  760. if ($user1){
  761. User::where('uid', $user['spread_uid'])->inc('brokerage_price', $price1)->update();
  762. $user1['brokerage_price'] += $price1;
  763. UserBill::income('直推奖励', $user1['uid'], 'now_money', 'push', $price1, $user['uid'], $user1['brokerage_price'], '直推用户'.$user['uid'].','.$str.'商品编号'.$item['product_id'].'数量'.$num.'订单号'.$order['order_id']);
  764. }
  765. if ($user2){
  766. User::where('uid', $user1['spread_uid'])->inc('brokerage_price', $price3)->update();
  767. $user2['brokerage_price'] += $price3;
  768. UserBill::income('间推奖励', $user2['uid'], 'now_money', 'jt_push', $price3, $user['uid'], $user2['brokerage_price'], '间推用户'.$user['uid'].','.$str.'编号'.$item['product_id'].'数量'.$num.'订单号'.$order['order_id']);
  769. }
  770. }
  771. }elseif ($type == 2){
  772. $str = '进货';
  773. foreach ($list as $item){
  774. $product = StoreProduct::where('id', $item['product_id'])->find();
  775. $num = $item['cart_info']['cart_num'];
  776. $price1 = $product['push'] * $num;// 直推奖励
  777. $price3 = $product['Interposition'] * $num;// 间推奖励
  778. if ($user1){
  779. User::where('uid', $user['spread_uid'])->inc('brokerage_price', $price1)->update();
  780. $user1['brokerage_price'] += $price1;
  781. UserBill::income('直推奖励', $user1['uid'], 'now_money', 'push', $price1, $user['uid'], $user1['brokerage_price'], '直推用户'.$user['uid'].','.$str.'商品编号'.$item['product_id'].'数量'.$num.'订单号'.$order['order_id']);
  782. }
  783. if ($user2){
  784. User::where('uid', $user1['spread_uid'])->inc('brokerage_price', $price3)->update();
  785. $user2['brokerage_price'] += $price3;
  786. UserBill::income('间推奖励', $user2['uid'], 'now_money', 'jt_push', $price3, $user['uid'], $user2['brokerage_price'], '间推用户'.$user['uid'].','.$str.'编号'.$item['product_id'].'数量'.$num.'订单号'.$order['order_id']);
  787. }
  788. }
  789. }elseif ($type ==3){
  790. $str = '老师购买';
  791. foreach ($list as $item){
  792. $product = StoreProduct::where('id', $item['product_id'])->find();
  793. $num = $item['cart_info']['cart_num'];
  794. $price2 = $product['push_sale'] * $num;// 直推销售奖励
  795. $price4 = $product['Interposition_sale'] * $num;// 间推销售奖励
  796. if ($user1){
  797. User::where('uid', $user['spread_uid'])->inc('brokerage_price', $price2)->update();
  798. $user1['brokerage_price'] += $price2;
  799. UserBill::income('直推销售提成', $user1['uid'], 'now_money', 'sale', $price2, $user['uid'], $user1['brokerage_price'], '直推用户'.$user['uid'].','.$str.'商品编号'.$item['product_id'].'数量'.$num.'订单号'.$order['order_id']);
  800. }
  801. if ($user2){
  802. User::where('uid', $user1['spread_uid'])->inc('brokerage_price', $price4)->update();
  803. $user2['brokerage_price'] += $price4;
  804. UserBill::income('间推销售提成', $user2['uid'], 'now_money', 'zt_sale', $price4, $user['uid'], $user2['brokerage_price'], '间推用户'.$user['uid'].','.$str.'商品编号'.$item['product_id'].'数量'.$num.'订单号'.$order['order_id']);
  805. }
  806. }
  807. }
  808. if ($type == 2){
  809. $user_product = UserProduct::where('uid', $order['uid'])->where('product_id', $item['product_id'])->find();
  810. if (!$user_product){
  811. UserProduct::create([
  812. 'uid' => $order['uid'],
  813. 'product_id' => $item['product_id'],
  814. 'number' => $num
  815. ]);
  816. }else{
  817. $user_product['number'] += $num;
  818. $user_product->save();
  819. }
  820. }
  821. if ($type == 3){
  822. $user_product = UserProduct::where('uid', $order['consignor'])->where('product_id', $item['product_id'])->find();
  823. $user_product['number'] -= $num;
  824. $user_product->save();
  825. }
  826. return true;
  827. }
  828. /*
  829. * 线下支付消息通知
  830. * 待完善
  831. *
  832. * */
  833. public static function createOrderTemplate($order)
  834. {
  835. //$goodsName = StoreOrderCartInfo::getProductNameList($order['id']);
  836. // RoutineTemplateService::sendTemplate(WechatUser::getOpenId($order['uid']),RoutineTemplateService::ORDER_CREATE, [
  837. // 'first'=>'亲,您购买的商品已支付成功',
  838. // 'keyword1'=>date('Y/m/d H:i',$order['add_time']),
  839. // 'keyword2'=>implode(',',$goodsName),
  840. // 'keyword3'=>$order['order_id'],
  841. // 'remark'=>'点击查看订单详情'
  842. // ],Url::build('/wap/My/order',['uni'=>$order['order_id']],true,true));
  843. // RoutineTemplateService::sendAdminNoticeTemplate([
  844. // 'first'=>"亲,您有一个新订单 \n订单号:{$order['order_id']}",
  845. // 'keyword1'=>'新订单',
  846. // 'keyword2'=>'线下支付',
  847. // 'keyword3'=>date('Y/m/d H:i',time()),
  848. // 'remark'=>'请及时处理'
  849. // ]);
  850. }
  851. /**
  852. * 获取订单详情
  853. * @param $uid
  854. * @param $key
  855. * @return array|\think\Model|null
  856. * @throws DataNotFoundException
  857. * @throws ModelNotFoundException
  858. * @throws \think\exception\DbException
  859. */
  860. public static function getUserOrderDetail($uid, $key)
  861. {
  862. return self::where('order_id|unique', $key)->where('uid', $uid)->where('is_del', 0)->find();
  863. }
  864. /**
  865. * TODO 订单发货
  866. * @param array $postageData 发货信息
  867. * @param string $oid orderID
  868. */
  869. public static function orderPostageAfter($postageData, $oid)
  870. {
  871. $order = self::where('id', $oid)->find();
  872. if ($postageData['delivery_type'] == 'send') {//送货
  873. RoutineTemplate::sendOrderPostage($order);
  874. } else if ($postageData['delivery_type'] == 'express') {//发货
  875. RoutineTemplate::sendOrderPostage($order, 1);
  876. }
  877. }
  878. /** 收货后发送模版消息
  879. * @param $order
  880. */
  881. public static function orderTakeAfter($order)
  882. {
  883. $title = self::getProductTitle($order['cart_id']);
  884. if ($order['is_channel'] == 1) {//小程序
  885. RoutineTemplate::sendOrderTakeOver($order, $title);
  886. } else {
  887. $openid = WechatUser::where('uid', $order['uid'])->value('openid');
  888. \crmeb\services\WechatTemplateService::sendTemplate($openid, \crmeb\services\WechatTemplateService::ORDER_TAKE_SUCCESS, [
  889. 'first' => '亲,您的订单已收货',
  890. 'keyword1' => $order['order_id'],
  891. 'keyword2' => '已收货',
  892. 'keyword3' => date('Y-m-d H:i:s', time()),
  893. 'keyword4' => $title,
  894. 'remark' => '感谢您的光临!'
  895. ]);
  896. }
  897. }
  898. /**
  899. * 删除订单
  900. * @param $uni
  901. * @param $uid
  902. * @return bool
  903. */
  904. public static function removeOrder($uni, $uid)
  905. {
  906. $order = self::getUserOrderDetail($uid, $uni);
  907. if (!$order) return self::setErrorInfo('订单不存在!');
  908. $order = self::tidyOrder($order);
  909. if ($order['_status']['_type'] != 0 && $order['_status']['_type'] != -2 && $order['_status']['_type'] != 4)
  910. return self::setErrorInfo('该订单无法删除!');
  911. if (false !== self::edit(['is_del' => 1], $order['id'], 'id') && false !== StoreOrderStatus::status($order['id'], 'remove_order', '删除订单')) {
  912. //未支付和已退款的状态下才可以退积分退库存退优惠券
  913. if ($order['_status']['_type'] == 0 || $order['_status']['_type'] == -2) {
  914. event('StoreOrderRegressionAllAfter', [$order]);
  915. }
  916. event('UserOrderRemoved', $uni);
  917. return true;
  918. } else
  919. return self::setErrorInfo('订单删除失败!');
  920. }
  921. /**
  922. * //TODO 用户确认收货
  923. * @param $uni
  924. * @param $uid
  925. */
  926. public static function takeOrder($uni, $uid)
  927. {
  928. $order = self::getUserOrderDetail($uid, $uni);
  929. if (!$order) return self::setErrorInfo('订单不存在!');
  930. $order = self::tidyOrder($order);
  931. if ($order['_status']['_type'] != 2) return self::setErrorInfo('订单状态错误!');
  932. self::beginTrans();
  933. if (false !== self::edit(['status' => 2], $order['id'], 'id') &&
  934. false !== StoreOrderStatus::status($order['id'], 'user_take_delivery', '用户已收货')) {
  935. try {
  936. OrderRepository::storeProductOrderUserTakeDelivery($order, $uid);
  937. UserBill::where('uid', $order['uid'])->where('link_id', $order['id'])->where('type', 'pay_money')->update(['take' => 1]);
  938. } catch (\Exception $e) {
  939. self::rollbackTrans();
  940. return self::setErrorInfo($e->getMessage());
  941. }
  942. self::commitTrans();
  943. event('UserLevelAfter', [User::get($uni)]);
  944. event('UserOrderTake', $uni);
  945. //短信通知
  946. event('ShortMssageSend', [$order['order_id'], ['Receiving', 'AdminConfirmTakeOver']]);
  947. return true;
  948. } else {
  949. self::rollbackTrans();
  950. return false;
  951. }
  952. }
  953. /**
  954. * 获取订单状态购物车等信息
  955. * @param $order
  956. * @param bool $detail 是否获取订单购物车详情
  957. * @param bool $isPic 是否获取订单状态图片
  958. * @return mixed
  959. * @throws DataNotFoundException
  960. * @throws ModelNotFoundException
  961. * @throws \think\exception\DbException
  962. */
  963. public static function tidyOrder($order, $detail = false, $isPic = false)
  964. {
  965. if ($detail == true && isset($order['id'])) {
  966. $cartInfo = StoreOrderCartInfo::where('oid', $order['id'])->column('cart_info', 'unique') ?: [];
  967. $info = [];
  968. foreach ($cartInfo as $k => $cart) {
  969. $cart = json_decode($cart, true);
  970. $cart['unique'] = $k;
  971. //新增是否评价字段
  972. $cart['is_reply'] = StoreProductReply::where('unique', $k)->count();
  973. array_push($info, $cart);
  974. unset($cart);
  975. }
  976. $order['cartInfo'] = $info;
  977. }
  978. $status = [];
  979. if (!$order['paid'] && $order['pay_type'] == 'offline' && !$order['status'] >= 2) {
  980. $status['_type'] = 9;
  981. $status['_title'] = '线下付款';
  982. $status['_msg'] = '商家处理中,请耐心等待';
  983. $status['_class'] = 'nobuy';
  984. } else if (!$order['paid']) {
  985. $status['_type'] = 0;
  986. $status['_title'] = '未支付';
  987. //系统预设取消订单时间段
  988. $keyValue = ['order_cancel_time', 'order_activity_time', 'order_bargain_time', 'order_seckill_time', 'order_pink_time'];
  989. //获取配置
  990. $systemValue = SystemConfigService::more($keyValue);
  991. //格式化数据
  992. $systemValue = self::setValeTime($keyValue, is_array($systemValue) ? $systemValue : []);
  993. if ($order['pink_id'] || $order['combination_id']) {
  994. $order_pink_time = $systemValue['order_pink_time'] ? $systemValue['order_pink_time'] : $systemValue['order_activity_time'];
  995. $time = bcadd($order['add_time'], $order_pink_time * 3600, 0);
  996. $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
  997. } else if ($order['seckill_id']) {
  998. $order_seckill_time = $systemValue['order_seckill_time'] ? $systemValue['order_seckill_time'] : $systemValue['order_activity_time'];
  999. $time = bcadd($order['add_time'], $order_seckill_time * 3600, 0);
  1000. $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
  1001. } else if ($order['bargain_id']) {
  1002. $order_bargain_time = $systemValue['order_bargain_time'] ? $systemValue['order_bargain_time'] : $systemValue['order_activity_time'];
  1003. $time = bcadd($order['add_time'], $order_bargain_time * 3600, 0);
  1004. $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
  1005. } else {
  1006. $time = bcadd($order['add_time'], $systemValue['order_cancel_time'] * 3600, 0);
  1007. $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
  1008. }
  1009. $status['_class'] = 'nobuy';
  1010. } else if ($order['refund_status'] == 1) {
  1011. $status['_type'] = -1;
  1012. $status['_title'] = '申请退款中';
  1013. $status['_msg'] = '商家审核中,请耐心等待';
  1014. $status['_class'] = 'state-sqtk';
  1015. } else if ($order['refund_status'] == 2) {
  1016. $status['_type'] = -2;
  1017. $status['_title'] = '已退款';
  1018. $status['_msg'] = '已为您退款,感谢您的支持';
  1019. $status['_class'] = 'state-sqtk';
  1020. } else if (!$order['status']) {
  1021. if ($order['pink_id']) {
  1022. if (StorePink::where('id', $order['pink_id'])->where('status', 1)->count()) {
  1023. $status['_type'] = 1;
  1024. $status['_title'] = '拼团中';
  1025. $status['_msg'] = '等待其他人参加拼团';
  1026. $status['_class'] = 'state-nfh';
  1027. } else {
  1028. $status['_type'] = 1;
  1029. $status['_title'] = '未发货';
  1030. $status['_msg'] = '商家未发货,请耐心等待';
  1031. $status['_class'] = 'state-nfh';
  1032. }
  1033. } else {
  1034. if ($order['shipping_type'] === 1) {
  1035. $status['_type'] = 1;
  1036. $status['_title'] = '未发货';
  1037. $status['_msg'] = '商家未发货,请耐心等待';
  1038. $status['_class'] = 'state-nfh';
  1039. } else {
  1040. $status['_type'] = 1;
  1041. $status['_title'] = '待核销';
  1042. $status['_msg'] = '待核销,请到核销点进行核销';
  1043. $status['_class'] = 'state-nfh';
  1044. }
  1045. }
  1046. } else if ($order['status'] == 1) {
  1047. if ($order['delivery_type'] == 'send') {//TODO 送货
  1048. $status['_type'] = 2;
  1049. $status['_title'] = '待收货';
  1050. $status['_msg'] = date('m月d日H时i分', StoreOrderStatus::getTime($order['id'], 'delivery')) . '服务商已送货';
  1051. $status['_class'] = 'state-ysh';
  1052. } else {//TODO 发货
  1053. $status['_type'] = 2;
  1054. $status['_title'] = '待收货';
  1055. if ($order['delivery_type'] == 'fictitious')
  1056. $_time = StoreOrderStatus::getTime($order['id'], 'delivery_fictitious');
  1057. else
  1058. $_time = StoreOrderStatus::getTime($order['id'], 'delivery_goods');
  1059. $status['_msg'] = date('m月d日H时i分', $_time) . '服务商已发货';
  1060. $status['_class'] = 'state-ysh';
  1061. }
  1062. } else if ($order['status'] == 2) {
  1063. $status['_type'] = 3;
  1064. $status['_title'] = '待评价';
  1065. $status['_msg'] = '已收货,快去评价一下吧';
  1066. $status['_class'] = 'state-ypj';
  1067. } else if ($order['status'] == 3) {
  1068. $status['_type'] = 4;
  1069. $status['_title'] = '交易完成';
  1070. $status['_msg'] = '交易完成,感谢您的支持';
  1071. $status['_class'] = 'state-ytk';
  1072. }
  1073. if (isset($order['pay_type']))
  1074. $status['_payType'] = isset(self::$payType[$order['pay_type']]) ? self::$payType[$order['pay_type']] : '其他方式';
  1075. if (isset($order['delivery_type']))
  1076. $status['_deliveryType'] = isset(self::$deliveryType[$order['delivery_type']]) ? self::$deliveryType[$order['delivery_type']] : '其他方式';
  1077. $order['_status'] = $status;
  1078. $order['_pay_time'] = isset($order['pay_time']) && $order['pay_time'] != null ? date('Y-m-d H:i:s', $order['pay_time']) : date('Y-m-d H:i:s', $order['add_time']);
  1079. $order['_add_time'] = isset($order['add_time']) ? (strstr($order['add_time'], '-') === false ? date('Y-m-d H:i:s', $order['add_time']) : $order['add_time']) : '';
  1080. $order['status_pic'] = '';
  1081. //获取产品状态图片
  1082. if ($isPic) {
  1083. $order_details_images = sys_data('order_details_images') ?: [];
  1084. foreach ($order_details_images as $image) {
  1085. if (isset($image['order_status']) && $image['order_status'] == $order['_status']['_type']) {
  1086. $order['status_pic'] = $image['pic'];
  1087. break;
  1088. }
  1089. }
  1090. }
  1091. $order['offlinePayStatus'] = (int)sys_config('offline_pay_status') ?? (int)2;
  1092. return $order;
  1093. }
  1094. /**
  1095. * 设置订单查询状态
  1096. * @param $status
  1097. * @param int $uid
  1098. * @param null $model
  1099. * @return StoreOrder|null
  1100. */
  1101. public static function statusByWhere($status, $uid = 0, $model = null)
  1102. {
  1103. // $orderId = StorePink::where('uid',$uid)->where('status',1)->column('order_id','id');//获取正在拼团的订单编号
  1104. if ($model == null) $model = new self;
  1105. if ('' === $status)
  1106. return $model;
  1107. else if ($status == 0)//未支付
  1108. return $model->where('paid', 0)->where('status', 0)->where('refund_status', 0);
  1109. else if ($status == 1)//待发货
  1110. return $model->where('paid', 1)->where('status', 0)->where('refund_status', 0);
  1111. else if ($status == 2)//待收货
  1112. return $model->where('paid', 1)->where('status', 1)->where('refund_status', 0);
  1113. else if ($status == 3)//待评价
  1114. return $model->where('paid', 1)->where('status', 2)->where('refund_status', 0);
  1115. else if ($status == 4)//已完成
  1116. return $model->where('paid', 1)->where('status', 3)->where('refund_status', 0);
  1117. else if ($status == -1)//退款中
  1118. return $model->where('paid', 1)->where('refund_status', 1);
  1119. else if ($status == -2)//已退款
  1120. return $model->where('paid', 1)->where('refund_status', 2);
  1121. else if ($status == -3)//退款
  1122. return $model->where('paid', 1)->where('refund_status', 'IN', '1,2');
  1123. // else if($status == 11){
  1124. // return $model->where('order_id','IN',implode(',',$orderId));
  1125. // }
  1126. else
  1127. return $model;
  1128. }
  1129. /**
  1130. * 获取订单并分页
  1131. * @param $uid
  1132. * @param string $status
  1133. * @param int $page
  1134. * @param int $limit
  1135. * @return mixed
  1136. * @throws DataNotFoundException
  1137. * @throws ModelNotFoundException
  1138. * @throws \think\exception\DbException
  1139. */
  1140. public static function getUserOrderList($uid, $status = '', $page = 0, $limit = 8, $purchase = '')
  1141. {
  1142. if ($purchase == 1){
  1143. $where[] = ['purchase', '=', 1];
  1144. }else{
  1145. $where[] = ['purchase', '<>', 1];
  1146. }
  1147. if ($purchase == 2){
  1148. $str = 'consignor';
  1149. }else{
  1150. $str = 'uid';
  1151. }
  1152. if ($page) $list = self::statusByWhere($status, $uid)->where('is_del', 0)->where($str, $uid)
  1153. ->where($where)
  1154. ->field('add_time,seckill_id,bargain_id,combination_id,id,order_id,pay_price,total_num,total_price,pay_postage,total_postage,paid,status,refund_status,pay_type,coupon_price,deduction_price,pink_id,delivery_type,is_del,shipping_type')
  1155. ->order('add_time DESC')->page((int)$page, (int)$limit)->select()->toArray();
  1156. else $list = self::statusByWhere($status, $uid)->where('is_del', 0)->where($str, $uid)
  1157. ->where($where)
  1158. ->field('add_time,seckill_id,bargain_id,combination_id,id,order_id,pay_price,total_num,total_price,pay_postage,total_postage,paid,status,refund_status,pay_type,coupon_price,deduction_price,pink_id,delivery_type,is_del,shipping_type')
  1159. ->order('add_time DESC')->page((int)$page, (int)$limit)->select()->toArray();
  1160. foreach ($list as $k => $order) {
  1161. $list[$k] = self::tidyOrder($order, true);
  1162. }
  1163. return $list;
  1164. }
  1165. /**
  1166. * 获取推广人地下用户的订单金额
  1167. * @param string $uid
  1168. * @param string $status
  1169. * @return array
  1170. */
  1171. public static function getUserOrderCount($uid = '', $status = '')
  1172. {
  1173. $res = self::statusByWhere($status, $uid)->where('uid', 'IN', $uid)->column('pay_price');
  1174. return $res;
  1175. }
  1176. /**
  1177. * 搜索某个订单详细信息
  1178. * @param $uid
  1179. * @param $order_id
  1180. * @return bool|mixed
  1181. * @throws DataNotFoundException
  1182. * @throws ModelNotFoundException
  1183. * @throws \think\exception\DbException
  1184. */
  1185. public static function searchUserOrder($uid, $order_id)
  1186. {
  1187. $order = self::where('uid', $uid)->where('order_id', $order_id)->where('is_del', 0)->field('seckill_id,bargain_id,combination_id,id,order_id,pay_price,total_num,total_price,pay_postage,total_postage,paid,status,refund_status,pay_type,coupon_price,deduction_price,delivery_type,shipping_type')
  1188. ->order('add_time DESC')->find();
  1189. if (!$order)
  1190. return false;
  1191. else
  1192. return self::tidyOrder($order->toArray(), true);
  1193. }
  1194. /**
  1195. * 订单评价信息记录
  1196. * @param $oid
  1197. * @return StoreOrderStatus|\think\Model
  1198. * @throws \Exception
  1199. */
  1200. public static function orderOver($oid)
  1201. {
  1202. $res = self::edit(['status' => '3'], $oid, 'id');
  1203. if (!$res) exception('评价后置操作失败!');
  1204. return StoreOrderStatus::status($oid, 'check_order_over', '用户评价');
  1205. }
  1206. /**
  1207. * 设置订单产品评价完毕事件
  1208. * @param $oid
  1209. * @return StoreOrderStatus|\think\Model
  1210. * @throws \Exception
  1211. */
  1212. public static function checkOrderOver($oid)
  1213. {
  1214. $uniqueList = StoreOrderCartInfo::where('oid', $oid)->column('unique', 'unique');
  1215. //订单产品全部评价完成
  1216. if (StoreProductReply::where('unique', 'IN', $uniqueList)->where('oid', $oid)->count() == count($uniqueList)) {
  1217. event('StoreProductOrderOver', [$oid]);
  1218. return self::orderOver($oid);
  1219. }
  1220. }
  1221. public static function getOrderStatusNum($uid)
  1222. {
  1223. $noBuy = (int)self::where('uid', $uid)->where('paid', 0)->where('is_del', 0)->where('pay_type', '<>', 'offline')->count();
  1224. $noPostageNoPink = (int)self::where('o.uid', $uid)->alias('o')->where('o.paid', 1)->where('o.pink_id', 0)->where('o.is_del', 0)->where('o.status', 0)->where('o.pay_type', '<>', 'offline')->count();
  1225. $noPostageYesPink = (int)self::where('o.uid', $uid)->alias('o')->join('StorePink p', 'o.pink_id = p.id')->where('p.status', 2)->where('o.paid', 1)->where('o.is_del', 0)->where('o.status', 0)->where('o.pay_type', '<>', 'offline')->count();
  1226. $noPostage = (int)bcadd($noPostageNoPink, $noPostageYesPink, 0);
  1227. $noTake = (int)self::where('uid', $uid)->where('paid', 1)->where('is_del', 0)->where('status', 1)->where('pay_type', '<>', 'offline')->count();
  1228. $noReply = (int)self::where('uid', $uid)->where('paid', 1)->where('is_del', 0)->where('status', 2)->count();
  1229. $noPink = (int)self::where('o.uid', $uid)->alias('o')->join('StorePink p', 'o.pink_id = p.id')->where('p.status', 1)->where('o.paid', 1)->where('o.is_del', 0)->where('o.status', 0)->where('o.pay_type', '<>', 'offline')->count();
  1230. $noRefund = (int)self::where('uid', $uid)->where('paid', 1)->where('is_del', 0)->where('refund_status', 'IN', '1,2')->count();
  1231. return compact('noBuy', 'noPostage', 'noTake', 'noReply', 'noPink', 'noRefund');
  1232. }
  1233. /**
  1234. * 购买商品赠送积分
  1235. * @param $order
  1236. * @return bool
  1237. * @throws \think\Exception
  1238. * @throws DataNotFoundException
  1239. * @throws ModelNotFoundException
  1240. * @throws \think\exception\DbException
  1241. */
  1242. public static function gainUserIntegral($order)
  1243. {
  1244. if ($order['gain_integral'] > 0) {
  1245. $userInfo = User::getUserInfo($order['uid']);
  1246. BaseModel::beginTrans();
  1247. $res1 = false != User::where('uid', $userInfo['uid'])->update(['integral' => bcadd($userInfo['integral'], $order['gain_integral'], 2)]);
  1248. $res2 = false != UserBill::income('购买商品赠送积分', $order['uid'], 'integral', 'gain', $order['gain_integral'], $order['id'], $userInfo['integral'], '购买商品赠送' . floatval($order['gain_integral']) . '积分');
  1249. $res = $res1 && $res2;
  1250. BaseModel::checkTrans($res);
  1251. return $res;
  1252. }
  1253. return true;
  1254. }
  1255. /**
  1256. * 获取当前订单中有没有拼团存在
  1257. * @param $pid
  1258. * @return int|string
  1259. */
  1260. public static function getIsOrderPink($pid = 0, $uid = 0)
  1261. {
  1262. return self::where('uid', $uid)->where('pink_id', $pid)->where('refund_status', 0)->where('is_del', 0)->count();
  1263. }
  1264. /**
  1265. * 获取order_id
  1266. * @param $pid
  1267. * @return mixed
  1268. */
  1269. public static function getStoreIdPink($pid = 0, $uid = 0)
  1270. {
  1271. return self::where('uid', $uid)->where('pink_id', $pid)->where('is_del', 0)->value('order_id');
  1272. }
  1273. /**
  1274. * 删除当前用户拼团未支付的订单
  1275. */
  1276. public static function delCombination()
  1277. {
  1278. self::where('combination', '>', 0)->where('paid', 0)->where('uid', User::getActiveUid())->delete();
  1279. }
  1280. public static function getUserPrice($uid = 0)
  1281. {
  1282. if (!$uid) return 0;
  1283. $price = self::where('paid', 1)->where('uid', $uid)->where('status', 2)->where('refund_status', 0)->column('pay_price', 'id');
  1284. $count = 0;
  1285. if ($price) {
  1286. foreach ($price as $v) {
  1287. $count = bcadd($count, $v, 2);
  1288. }
  1289. }
  1290. return $count;
  1291. }
  1292. /**
  1293. * 个人中心获取个人订单列表和订单搜索
  1294. * @param int $uid 用户uid
  1295. * @param int | string 查找订单类型
  1296. * @param int $first 分页
  1297. * @param int 每页显示多少条
  1298. * @param string $search 订单号
  1299. * @return array
  1300. * */
  1301. public static function getUserOrderSearchList($uid, $type, $page, $limit, $search, $purchase = '')
  1302. {
  1303. if ($search) {
  1304. $order = self::searchUserOrder($uid, $search) ?: [];
  1305. $list = $order == false ? [] : [$order];
  1306. } else {
  1307. $list = self::getUserOrderList($uid, $type, $page, $limit, $purchase);
  1308. }
  1309. foreach ($list as $k => $order) {
  1310. $list[$k] = self::tidyOrder($order, true);
  1311. if ($list[$k]['_status']['_type'] == 3) {
  1312. foreach ($order['cartInfo'] ?: [] as $key => $product) {
  1313. $list[$k]['cartInfo'][$key]['is_reply'] = StoreProductReply::isReply($product['unique'], 'product');
  1314. $list[$k]['cartInfo'][$key]['add_time'] = isset($product['add_time']) ? date('Y-m-d H:i', $product['add_time']) : '时间错误';
  1315. }
  1316. }
  1317. }
  1318. return $list;
  1319. }
  1320. /**
  1321. * 获取用户下级的订单
  1322. * @param int $xuid 下级用户用户uid
  1323. * @param int $uid 用户uid
  1324. * @param int $type 订单类型
  1325. * @param int $first 截取行数
  1326. * @param int $limit 展示条数
  1327. * @return array
  1328. * */
  1329. public static function getSubordinateOrderlist($xUid, $uid, $type, $first, $limit)
  1330. {
  1331. $list = [];
  1332. if (!$xUid) {
  1333. $arr = User::getOneSpreadUid($uid);
  1334. foreach ($arr as $v) $list = StoreOrder::getUserOrderList($v, $type, $first, $limit);
  1335. } else $list = self::getUserOrderList($xUid, $type, $first, $limit);
  1336. foreach ($list as $k => $order) {
  1337. $list[$k] = self::tidyOrder($order, true);
  1338. if ($list[$k]['_status']['_type'] == 3) {
  1339. foreach ($order['cartInfo'] ?: [] as $key => $product) {
  1340. $list[$k]['cartInfo'][$key]['is_reply'] = StoreProductReply::isReply($product['unique'], 'product');
  1341. }
  1342. }
  1343. }
  1344. return $list;
  1345. }
  1346. /**
  1347. * 获取 今日 昨日 本月 订单金额
  1348. * @return mixed
  1349. */
  1350. public static function getOrderTimeData()
  1351. {
  1352. $to_day = strtotime(date('Y-m-d'));//今日
  1353. $pre_day = strtotime(date('Y-m-d', strtotime('-1 day')));//昨日
  1354. $now_month = strtotime(date('Y-m'));//本月
  1355. //今日成交额
  1356. // $data['todayPrice'] = (float)number_format(self::where('is_del', 0)->where('pay_time', '>=', $to_day)->where('paid', 1)->where('refund_status', 0)->value('sum(pay_price)'), 2) ?? 0;
  1357. $data['todayPrice'] = number_format(self::where('is_del', 0)->where('pay_time', '>=', $to_day)->where('paid', 1)->where('refund_status', 0)->value('sum(pay_price)'), 2) ?? 0;
  1358. //今日订单数
  1359. $data['todayCount'] = self::where('is_del', 0)->where('pay_time', '>=', $to_day)->where('paid', 1)->where('refund_status', 0)->count();
  1360. //昨日成交额
  1361. $data['proPrice'] = number_format(self::where('is_del', 0)->where('pay_time', '<', $to_day)->where('pay_time', '>=', $pre_day)->where('paid', 1)->where('refund_status', 0)->value('sum(pay_price)'), 2) ?? 0;
  1362. //昨日订单数
  1363. $data['proCount'] = self::where('is_del', 0)->where('pay_time', '<', $to_day)->where('pay_time', '>=', $pre_day)->where('paid', 1)->where('refund_status', 0)->count();
  1364. //本月成交额
  1365. $data['monthPrice'] = number_format(self::where('is_del', 0)->where('pay_time', '>=', $now_month)->where('paid', 1)->where('refund_status', 0)->value('sum(pay_price)'), 2) ?? 0;
  1366. //本月订单数
  1367. $data['monthCount'] = self::where('is_del', 0)->where('pay_time', '>=', $now_month)->where('paid', 1)->where('refund_status', 0)->count();
  1368. return $data;
  1369. }
  1370. /**
  1371. * 获取某个用户的订单统计数据
  1372. * @param $uid
  1373. * @return mixed
  1374. */
  1375. public static function getOrderData($uid, $purchase = '')
  1376. {
  1377. if ($purchase == 1){
  1378. $where[] = ['purchase', '=', 1];
  1379. }else{
  1380. $where[] = ['purchase', '<>', 1];
  1381. }
  1382. //订单支付没有退款 数量
  1383. $data['order_count'] = self::where('is_del', 0)->where('paid', 1)->where($where)->where('uid', $uid)->where('refund_status', 0)->count();
  1384. //订单支付没有退款 支付总金额
  1385. $data['sum_price'] = self::where('is_del', 0)->where('paid', 1)->where($where)->where('uid', $uid)->where('refund_status', 0)->sum('pay_price');
  1386. //订单待支付 数量
  1387. $data['unpaid_count'] = self::statusByWhere(0, $uid)->where('is_del', 0)->where($where)->where('uid', $uid)->count();
  1388. //订单待发货 数量
  1389. $data['unshipped_count'] = self::statusByWhere(1, $uid)->where('is_del', 0)->where($where)->where('uid', $uid)->count();
  1390. //订单待收货 数量
  1391. $data['received_count'] = self::statusByWhere(2, $uid)->where('is_del', 0)->where($where)->where('uid', $uid)->count();
  1392. //订单待评价 数量
  1393. $data['evaluated_count'] = self::statusByWhere(3, $uid)->where('is_del', 0)->where($where)->where('uid', $uid)->count();
  1394. //订单已完成 数量
  1395. $data['complete_count'] = self::statusByWhere(4, $uid)->where('is_del', 0)->where($where)->where('uid', $uid)->count();
  1396. //订单退款
  1397. $data['refund_count'] = self::statusByWhere(-1, $uid)->where('is_del', 0)->where($where)->where('uid', $uid)->count();
  1398. return $data;
  1399. }
  1400. /**
  1401. * 获取订单统计数据
  1402. * @param $uid
  1403. * @return mixed
  1404. */
  1405. public static function getOrderDataAdmin()
  1406. {
  1407. //订单支付没有退款 数量
  1408. $data['order_count'] = self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->count();
  1409. //订单支付没有退款 支付总金额
  1410. $data['sum_price'] = self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->sum('pay_price');
  1411. //订单待支付 数量
  1412. $data['unpaid_count'] = self::statusByWhere(0, 0)->where('is_del', 0)->count();
  1413. //订单待发货 数量
  1414. $data['unshipped_count'] = self::statusByWhere(1, 0)->where('is_del', 0)->count();
  1415. //订单待收货 数量
  1416. $data['received_count'] = self::statusByWhere(2, 0)->where('is_del', 0)->count();
  1417. //订单待评价 数量
  1418. $data['evaluated_count'] = self::statusByWhere(3, 0)->where('is_del', 0)->count();
  1419. //订单已完成 数量
  1420. $data['complete_count'] = self::statusByWhere(4, 0)->where('is_del', 0)->count();
  1421. //订单退款 数量
  1422. $data['refund_count'] = self::statusByWhere(-3, 0)->where('is_del', 0)->count();
  1423. return $data;
  1424. }
  1425. /**
  1426. * 累计消费
  1427. * @param $uid
  1428. * @return float
  1429. */
  1430. public static function getOrderStatusSum($uid)
  1431. {
  1432. return self::where('uid', $uid)->where('is_del', 0)->where('paid', 1)->sum('pay_price');
  1433. }
  1434. public static function getPinkOrderId($id)
  1435. {
  1436. return self::where('id', $id)->value('order_id');
  1437. }
  1438. /**
  1439. * 未支付订单自动取消
  1440. * @param int $limit 分页截取条数
  1441. * @param string $prefid 缓存名称
  1442. * @param int $expire 缓存时间
  1443. * @return string|null
  1444. * @throws \Psr\SimpleCache\InvalidArgumentException
  1445. */
  1446. public static function orderUnpaidCancel()
  1447. {
  1448. //系统预设取消订单时间段
  1449. $keyValue = ['order_cancel_time', 'order_activity_time', 'order_bargain_time', 'order_seckill_time', 'order_pink_time'];
  1450. //获取配置
  1451. $systemValue = SystemConfigService::more($keyValue);
  1452. //格式化数据
  1453. $systemValue = self::setValeTime($keyValue, is_array($systemValue) ? $systemValue : []);
  1454. //检查是否有未支付的订单 未支付查询条件
  1455. $unPidCount = self::where('paid', 0)->where('pay_type', '<>', 'offline')->where('is_del', 0)->where('status', 0)->where('refund_status', 0)->count();
  1456. if (!$unPidCount) return null;
  1457. try {
  1458. $res = true;
  1459. // 未支付查询条件
  1460. $orderList = self::where('paid', 0)->where('pay_type', '<>', 'offline')->where('is_del', 0)->where('status', 0)->where('refund_status', 0)->field('add_time,pink_id,order_id,seckill_id,bargain_id,combination_id,status,cart_id,use_integral,refund_status,uid,unique,back_integral,coupon_id,paid,is_del')->select();
  1461. foreach ($orderList as $order) {
  1462. if ($order['seckill_id']) {
  1463. //优先使用单独配置的过期时间
  1464. $order_seckill_time = $systemValue['order_seckill_time'] ? $systemValue['order_seckill_time'] : $systemValue['order_activity_time'];
  1465. $res = $res && self::RegressionAll($order_seckill_time, $order);
  1466. unset($order_seckill_time);
  1467. } else if ($order['bargain_id']) {
  1468. $order_bargain_time = $systemValue['order_bargain_time'] ? $systemValue['order_bargain_time'] : $systemValue['order_activity_time'];
  1469. $res = $res && self::RegressionAll($order_bargain_time, $order);
  1470. unset($order_bargain_time);
  1471. } else if ($order['pink_id'] || $order['combination_id']) {
  1472. $order_pink_time = $systemValue['order_pink_time'] ? $systemValue['order_pink_time'] : $systemValue['order_activity_time'];
  1473. $res = $res && self::RegressionAll($order_pink_time, $order);
  1474. unset($order_pink_time);
  1475. } else {
  1476. $res = $res && self::RegressionAll($systemValue['order_cancel_time'], $order);
  1477. }
  1478. }
  1479. if (!$res) throw new \Exception('更新错误');
  1480. unset($orderList, $res, $pages);
  1481. return null;
  1482. } catch (PDOException $e) {
  1483. Log::error('未支付自动取消时发生数据库查询错误,错误原因为:' . $e->getMessage());
  1484. throw new \Exception($e->getMessage());
  1485. } catch (\think\Exception $e) {
  1486. Log::error('未支付自动取消时发生系统错误,错误原因为:' . $e->getMessage());
  1487. throw new \Exception($e->getMessage());
  1488. }
  1489. }
  1490. /**
  1491. * 未支付订单超过预设时间回退所有,如果不设置未支付过期时间,将不取消订单
  1492. * @param $time 预设时间
  1493. * @param $order 订单详情
  1494. * @return bool
  1495. * @throws DataNotFoundException
  1496. * @throws ModelNotFoundException
  1497. * @throws \think\exception\DbException
  1498. */
  1499. protected static function RegressionAll($time, $order)
  1500. {
  1501. if ($time == 0) return true;
  1502. if (($order['add_time'] + bcmul($time, 3600, 0)) < time()) {
  1503. $res1 = self::RegressionStock($order);
  1504. $res2 = self::RegressionIntegral($order);
  1505. $res3 = self::RegressionCoupon($order);
  1506. $res = $res1 && $res2 && $res3;
  1507. if ($res) $res = false !== self::where('order_id', $order['order_id'])->update(['is_del' => 1, 'mark' => '订单未支付已超过系统预设时间']);
  1508. unset($res1, $res2, $res3);
  1509. return $res;
  1510. } else
  1511. return true;
  1512. }
  1513. /**
  1514. * 格式化数据
  1515. * @param array $array 原本数据键
  1516. * @param $value 需要格式化的数据
  1517. * @param int $default 默认值
  1518. * @return mixed
  1519. */
  1520. protected static function setValeTime(array $array, $value, $default = 0)
  1521. {
  1522. foreach ($array as $item) {
  1523. if (!isset($value[$item]))
  1524. $value[$item] = $default;
  1525. else if (is_string($value[$item]))
  1526. $value[$item] = (float)$value[$item];
  1527. }
  1528. return $value;
  1529. }
  1530. public static function getOrderTotalPrice($cartInfo)
  1531. {
  1532. $totalPrice = 0;
  1533. foreach ($cartInfo as $cart) {
  1534. $totalPrice = bcadd($totalPrice, bcmul($cart['cart_num'], $cart['truePrice'], 2), 2);
  1535. }
  1536. return $totalPrice;
  1537. }
  1538. public static function getOrderCostPrice($cartInfo)
  1539. {
  1540. $costPrice = 0;
  1541. foreach ($cartInfo as $cart) {
  1542. $costPrice = bcadd($costPrice, bcmul($cart['cart_num'], $cart['costPrice'], 2), 2);
  1543. }
  1544. return $costPrice;
  1545. }
  1546. public static function getCombinationOrderCostPrice($cartInfo)
  1547. {
  1548. $costPrice = 0;
  1549. foreach ($cartInfo as $cart) {
  1550. if ($cart['combination_id']) {
  1551. $costPrice = bcadd($costPrice, bcmul($cart['cart_num'], StoreCombination::where('id', $cart['combination_id'])->value('price'), 2), 2);
  1552. }
  1553. }
  1554. return (float)$costPrice;
  1555. }
  1556. public static function yueRefundAfter($order)
  1557. {
  1558. }
  1559. /**
  1560. * 获取余额支付的金额
  1561. * @param $uid
  1562. * @return float|int
  1563. */
  1564. public static function getOrderStatusYueSum($uid)
  1565. {
  1566. return self::where('uid', $uid)->where('is_del', 0)->where('is_del', 0)->where('pay_type', 'yue')->where('paid', 1)->sum('pay_price');
  1567. }
  1568. /**
  1569. * 砍价支付成功订单数量
  1570. * @param $bargain
  1571. * @return int
  1572. */
  1573. public static function getBargainPayCount($bargain)
  1574. {
  1575. return self::where('bargain_id', $bargain)->where(['paid' => 1, 'refund_status' => 0])->count();
  1576. }
  1577. /**
  1578. * 7天自动收货
  1579. * @return bool
  1580. */
  1581. public static function startTakeOrder()
  1582. {
  1583. //7天前时间戳
  1584. $systemDeliveryTime = SystemConfigService::get('system_delivery_time') ?? 0;
  1585. //0为取消自动收货功能
  1586. if ($systemDeliveryTime == 0) return true;
  1587. $sevenDay = strtotime(date('Y-m-d H:i:s', strtotime('-' . $systemDeliveryTime . ' day')));
  1588. $model = new self;
  1589. $model = $model->alias('o');
  1590. $model = $model->join('StoreOrderStatus s', 's.oid=o.id');
  1591. $model = $model->where('o.paid', 1);
  1592. $model = $model->where('s.change_type', 'delivery_goods');
  1593. $model = $model->where('s.change_time', '<', $sevenDay);
  1594. $model = $model->where('o.status', 1);
  1595. $model = $model->where('o.refund_status', 0);
  1596. $model = $model->where('o.is_del', 0);
  1597. $orderInfo = $model->column('id', 'id');
  1598. if (!count($orderInfo)) return true;
  1599. $res = true;
  1600. foreach ($orderInfo as $key => &$item) {
  1601. $order = self::get($item);
  1602. if ($order['status'] == 2) continue;
  1603. if ($order['paid'] == 1 && $order['status'] == 1) $data['status'] = 2;
  1604. else if ($order['pay_type'] == 'offline') $data['status'] = 2;
  1605. else continue;
  1606. if (!self::edit($data, $item, 'id')) continue;
  1607. try {
  1608. OrderRepository::storeProductOrderTakeDeliveryAdmin($order, $item);
  1609. $res = $res && true;
  1610. } catch (\Exception $e) {
  1611. $res = $res && false;
  1612. }
  1613. $res = $res && StoreOrderStatus::status($item, 'take_delivery', '已收货[自动收货]');
  1614. }
  1615. if (!$res) {
  1616. throw new \Exception('');
  1617. }
  1618. }
  1619. /**
  1620. * 获取订单信息
  1621. * @param $id
  1622. * @param string $field
  1623. * @return array|null|\think\Model
  1624. * @throws DataNotFoundException
  1625. * @throws ModelNotFoundException
  1626. * @throws \think\exception\DbException
  1627. */
  1628. public static function getOrderInfo($id, $field = 'order_id')
  1629. {
  1630. return self::where('id', $id)->field($field)->find();
  1631. }
  1632. /**
  1633. * 订单每月统计数据
  1634. * @param $page
  1635. * @param $limit
  1636. * @return array
  1637. */
  1638. public static function getOrderDataPriceCount($page, $limit, $start, $stop)
  1639. {
  1640. if (!$limit) return [];
  1641. $model = new self;
  1642. if ($start != '' && $stop != '') $model = $model->where('pay_time', '>', $start)->where('pay_time', '<=', $stop);
  1643. $model = $model->field('sum(pay_price) as price,count(id) as count,FROM_UNIXTIME(pay_time, \'%m-%d\') as time');
  1644. $model = $model->where('is_del', 0);
  1645. $model = $model->where('paid', 1);
  1646. $model = $model->where('refund_status', 0);
  1647. $model = $model->group("FROM_UNIXTIME(pay_time, '%Y-%m-%d')");
  1648. $model = $model->order('pay_time DESC');
  1649. if ($page) $model = $model->page($page, $limit);
  1650. return $model->select();
  1651. }
  1652. /**
  1653. * 前台订单管理订单列表获取
  1654. * @param $where
  1655. * @return mixed
  1656. */
  1657. public static function orderList($where)
  1658. {
  1659. $model = self::getOrderWhere($where, self::alias('a')->join('user r', 'r.uid=a.uid', 'LEFT'), 'a.', 'r')->field('a.id,a.order_id,a.add_time,a.status,a.total_num,a.total_price,a.total_postage,a.pay_price,a.pay_postage,a.paid,a.refund_status,a.remark,a.pay_type');
  1660. if ($where['order'] != '') {
  1661. $model = $model->order(self::setOrder($where['order']));
  1662. } else {
  1663. $model = $model->order('a.id desc');
  1664. }
  1665. $data = ($data = $model->page((int)$where['page'], (int)$where['limit'])->select()) && count($data) ? $data->toArray() : [];
  1666. return self::tidyAdminOrder($data);
  1667. }
  1668. /**
  1669. * 前台订单管理 订单信息设置
  1670. * @param $data
  1671. * @param bool $status
  1672. * @return mixed
  1673. * @throws DataNotFoundException
  1674. * @throws ModelNotFoundException
  1675. * @throws \think\exception\DbException
  1676. */
  1677. public static function tidyAdminOrder($data, $status = false)
  1678. {
  1679. foreach ($data as &$item) {
  1680. $_info = StoreOrderCartInfo::where('oid', $item['id'])->field('cart_info')->select()->toArray();
  1681. foreach ($_info as $k => $v) {
  1682. if (!is_array($v['cart_info']))
  1683. $_info[$k]['cart_info'] = json_decode($v['cart_info'], true);
  1684. }
  1685. foreach ($_info as $k => $v) {
  1686. unset($_info[$k]['cart_info']['type'], $_info[$k]['cart_info']['product_id'], $_info[$k]['cart_info']['combination_id'], $_info[$k]['cart_info']['seckill_id'], $_info[$k]['cart_info']['bargain_id'], $_info[$k]['cart_info']['bargain_id'], $_info[$k]['cart_info']['truePrice'], $_info[$k]['cart_info']['vip_truePrice'], $_info[$k]['cart_info']['trueStock'], $_info[$k]['cart_info']['costPrice'], $_info[$k]['cart_info']['productInfo']['id'], $_info[$k]['cart_info']['productInfo']['vip_price'], $_info[$k]['cart_info']['productInfo']['postage'], $_info[$k]['cart_info']['productInfo']['give_integral'], $_info[$k]['cart_info']['productInfo']['sales'], $_info[$k]['cart_info']['productInfo']['stock'], $_info[$k]['cart_info']['productInfo']['unit_name'], $_info[$k]['cart_info']['productInfo']['is_postage'], $_info[$k]['cart_info']['productInfo']['slider_image'], $_info[$k]['cart_info']['productInfo']['cost'], $_info[$k]['cart_info']['productInfo']['mer_id'], $_info[$k]['cart_info']['productInfo']['cate_id'], $_info[$k]['cart_info']['productInfo']['is_show'], $_info[$k]['cart_info']['productInfo']['store_info'], $_info[$k]['cart_info']['productInfo']['is_del'], $_info[$k]['cart_info']['is_pay'], $_info[$k]['cart_info']['is_del'], $_info[$k]['cart_info']['is_new'], $_info[$k]['cart_info']['add_time'], $_info[$k]['cart_info']['id'], $_info[$k]['cart_info']['uid'], $_info[$k]['cart_info']['product_attr_unique']);
  1687. $_info[$k]['cart_info']['productInfo']['suk'] = '';
  1688. if (isset($v['cart_info']['productInfo']['attrInfo'])) {
  1689. $_info[$k]['cart_info']['productInfo']['image'] = $_info[$k]['cart_info']['productInfo']['attrInfo']['image'];
  1690. $_info[$k]['cart_info']['productInfo']['price'] = $_info[$k]['cart_info']['productInfo']['attrInfo']['price'];
  1691. $_info[$k]['cart_info']['productInfo']['suk'] = $_info[$k]['cart_info']['productInfo']['attrInfo']['suk'];
  1692. unset($_info[$k]['cart_info']['productInfo']['attrInfo']);
  1693. }
  1694. if (!isset($v['cart_info']['productInfo']['ot_price'])) {
  1695. $_info[$k]['cart_info']['productInfo']['ot_price'] = $v['cart_info']['productInfo']['price'];
  1696. }
  1697. }
  1698. $item['_info'] = $_info;
  1699. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  1700. // if($item['pink_id'] || $item['combination_id']){
  1701. // $pinkStatus = StorePink::where('order_id_key',$item['id'])->value('status');
  1702. // switch ($pinkStatus){
  1703. // case 1:
  1704. // $item['pink_name'] = '[拼团订单]正在进行中';
  1705. // $item['color'] = '#f00';
  1706. // break;
  1707. // case 2:
  1708. // $item['pink_name'] = '[拼团订单]已完成';
  1709. // $item['color'] = '#00f';
  1710. // break;
  1711. // case 3:
  1712. // $item['pink_name'] = '[拼团订单]未完成';
  1713. // $item['color'] = '#f0f';
  1714. // break;
  1715. // default:
  1716. // $item['pink_name'] = '[拼团订单]历史订单';
  1717. // $item['color'] = '#457856';
  1718. // break;
  1719. // }
  1720. // }elseif ($item['seckill_id']){
  1721. // $item['pink_name'] = '[秒杀订单]';
  1722. // $item['color'] = '#32c5e9';
  1723. // }elseif ($item['bargain_id']){
  1724. // $item['pink_name'] = '[砍价订单]';
  1725. // $item['color'] = '#12c5e9';
  1726. // }else{
  1727. // $item['pink_name'] = '[普通订单]';
  1728. // $item['color'] = '#895612';
  1729. // }
  1730. // if($item['paid']==1){
  1731. // switch ($item['pay_type']){
  1732. // case 'weixin':
  1733. // $item['pay_type_name']='微信支付';
  1734. // break;
  1735. // case 'yue':
  1736. // $item['pay_type_name']='余额支付';
  1737. // break;
  1738. // case 'offline':
  1739. // $item['pay_type_name']='线下支付';
  1740. // break;
  1741. // default:
  1742. // $item['pay_type_name']='其他支付';
  1743. // break;
  1744. // }
  1745. // }else{
  1746. // switch ($item['pay_type']){
  1747. // default:
  1748. // $item['pay_type_name']='未支付';
  1749. // break;
  1750. // case 'offline':
  1751. // $item['pay_type_name']='线下支付';
  1752. // $item['pay_type_info']=1;
  1753. // break;
  1754. // }
  1755. // }
  1756. if ($status) {
  1757. $status = [];
  1758. if (!$item['paid'] && $item['pay_type'] == 'offline' && !$item['status'] >= 2) {
  1759. $status['_type'] = 9;
  1760. $status['_title'] = '线下付款';
  1761. $status['_msg'] = '商家处理中,请耐心等待';
  1762. $status['_class'] = 'nobuy';
  1763. } else if (!$item['paid']) {
  1764. $status['_type'] = 0;
  1765. $status['_title'] = '未支付';
  1766. //系统预设取消订单时间段
  1767. $keyValue = ['order_cancel_time', 'order_activity_time', 'order_bargain_time', 'order_seckill_time', 'order_pink_time'];
  1768. //获取配置
  1769. $systemValue = SystemConfigService::more($keyValue);
  1770. //格式化数据
  1771. $systemValue = self::setValeTime($keyValue, is_array($systemValue) ? $systemValue : []);
  1772. if ($item['pink_id'] || $item['combination_id']) {
  1773. $order_pink_time = $systemValue['order_pink_time'] ? $systemValue['order_pink_time'] : $systemValue['order_activity_time'];
  1774. $time = bcadd($item['add_time'], $order_pink_time * 3600, 0);
  1775. $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
  1776. } else if ($item['seckill_id']) {
  1777. $order_seckill_time = $systemValue['order_seckill_time'] ? $systemValue['order_seckill_time'] : $systemValue['order_activity_time'];
  1778. $time = bcadd($item['add_time'], $order_seckill_time * 3600, 0);
  1779. $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
  1780. } else if ($item['bargain_id']) {
  1781. $order_bargain_time = $systemValue['order_bargain_time'] ? $systemValue['order_bargain_time'] : $systemValue['order_activity_time'];
  1782. $time = bcadd($item['add_time'], $order_bargain_time * 3600, 0);
  1783. $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
  1784. } else {
  1785. $time = bcadd($item['add_time'], $systemValue['order_cancel_time'] * 3600, 0);
  1786. $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
  1787. }
  1788. $status['_class'] = 'nobuy';
  1789. } else if ($item['refund_status'] == 1) {
  1790. $status['_type'] = -1;
  1791. $status['_title'] = '申请退款中';
  1792. $status['_msg'] = '商家审核中,请耐心等待';
  1793. $status['_class'] = 'state-sqtk';
  1794. } else if ($item['refund_status'] == 2) {
  1795. $status['_type'] = -2;
  1796. $status['_title'] = '已退款';
  1797. $status['_msg'] = '已为您退款,感谢您的支持';
  1798. $status['_class'] = 'state-sqtk';
  1799. } else if (!$item['status']) {
  1800. if ($item['pink_id']) {
  1801. if (StorePink::where('id', $item['pink_id'])->where('status', 1)->count()) {
  1802. $status['_type'] = 11;
  1803. $status['_title'] = '拼团中';
  1804. $status['_msg'] = '等待其他人参加拼团';
  1805. $status['_class'] = 'state-nfh';
  1806. } else {
  1807. $status['_type'] = 1;
  1808. $status['_title'] = '未发货';
  1809. $status['_msg'] = '商家未发货,请耐心等待';
  1810. $status['_class'] = 'state-nfh';
  1811. }
  1812. } else {
  1813. $status['_type'] = 1;
  1814. $status['_title'] = '未发货';
  1815. $status['_msg'] = '商家未发货,请耐心等待';
  1816. $status['_class'] = 'state-nfh';
  1817. }
  1818. } else if ($item['status'] == 1) {
  1819. if ($item['delivery_type'] == 'send') {//TODO 送货
  1820. $status['_type'] = 2;
  1821. $status['_title'] = '待收货';
  1822. $status['_msg'] = date('m月d日H时i分', StoreOrderStatus::getTime($item['id'], 'delivery')) . '服务商已送货';
  1823. $status['_class'] = 'state-ysh';
  1824. } else {//TODO 发货
  1825. $status['_type'] = 2;
  1826. $status['_title'] = '待收货';
  1827. $status['_msg'] = date('m月d日H时i分', StoreOrderStatus::getTime($item['id'], 'delivery_goods')) . '服务商已发货';
  1828. $status['_class'] = 'state-ysh';
  1829. }
  1830. } else if ($item['status'] == 2) {
  1831. $status['_type'] = 3;
  1832. $status['_title'] = '待评价';
  1833. $status['_msg'] = '已收货,快去评价一下吧';
  1834. $status['_class'] = 'state-ypj';
  1835. } else if ($item['status'] == 3) {
  1836. $status['_type'] = 4;
  1837. $status['_title'] = '交易完成';
  1838. $status['_msg'] = '交易完成,感谢您的支持';
  1839. $status['_class'] = 'state-ytk';
  1840. }
  1841. if (isset($item['pay_type']))
  1842. $status['_payType'] = isset(self::$payType[$item['pay_type']]) ? self::$payType[$item['pay_type']] : '其他方式';
  1843. if (isset($item['delivery_type']))
  1844. $status['_deliveryType'] = isset(self::$deliveryType[$item['delivery_type']]) ? self::$deliveryType[$item['delivery_type']] : '其他方式';
  1845. $item['_status'] = $status;
  1846. } else {
  1847. if ($item['paid'] == 0 && $item['status'] == 0) {
  1848. $item['status_name'] = '未支付';
  1849. } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0) {
  1850. $item['status_name'] = '未发货';
  1851. } else if ($item['paid'] == 1 && $item['status'] == 1 && $item['refund_status'] == 0) {
  1852. $item['status_name'] = '待收货';
  1853. } else if ($item['paid'] == 1 && $item['status'] == 2 && $item['refund_status'] == 0) {
  1854. $item['status_name'] = '待评价';
  1855. } else if ($item['paid'] == 1 && $item['status'] == 3 && $item['refund_status'] == 0) {
  1856. $item['status_name'] = '已完成';
  1857. }
  1858. }
  1859. // unset($item['refund_status']);
  1860. // else if($item['paid']==1 && $item['refund_status']==1){
  1861. // $item['status_name']=<<<HTML
  1862. //<b style="color:#f124c7">申请退款</b><br/>
  1863. //<span>退款原因:{$item['refund_reason_wap']}</span>
  1864. //HTML;
  1865. // }else if($item['paid']==1 && $item['refund_status']==2){
  1866. // $item['status_name']='已退款';
  1867. // }
  1868. // if($item['paid']==0 && $item['status']==0 && $item['refund_status']==0){
  1869. // $item['_status']=1;
  1870. // }else if($item['paid']==1 && $item['status']==0 && $item['refund_status']==0){
  1871. // $item['_status']=2;
  1872. // }else if($item['paid']==1 && $item['refund_status']==1){
  1873. // $item['_status']=3;
  1874. // }else if($item['paid']==1 && $item['status']==1 && $item['refund_status']==0){
  1875. // $item['_status']=4;
  1876. // }else if($item['paid']==1 && $item['status']==2 && $item['refund_status']==0){
  1877. // $item['_status']=5;
  1878. // }else if($item['paid']==1 && $item['status']==3 && $item['refund_status']==0){
  1879. // $item['_status']=6;
  1880. // }else if($item['paid']==1 && $item['refund_status']==2){
  1881. // $item['_status']=7;
  1882. // }
  1883. }
  1884. return $data;
  1885. }
  1886. /**
  1887. * 处理where条件
  1888. * @param $where
  1889. * @param $model
  1890. * @param string $aler
  1891. * @param string $join
  1892. * @return StoreOrder|null
  1893. */
  1894. public static function getOrderWhere($where, $model, $aler = '', $join = '')
  1895. {
  1896. if (isset($where['status']) && $where['status'] != '') $model = self::statusWhere($where['status'], $model, $aler);
  1897. if (isset($where['is_del']) && $where['is_del'] != '' && $where['is_del'] != -1) $model = $model->where($aler . 'is_del', $where['is_del']);
  1898. if (isset($where['combination_id'])) {
  1899. if ($where['combination_id'] == '普通订单') {
  1900. $model = $model->where($aler . 'combination_id', 0)->where($aler . 'seckill_id', 0)->where($aler . 'bargain_id', 0);
  1901. }
  1902. if ($where['combination_id'] == '拼团订单') {
  1903. $model = $model->where($aler . 'combination_id', ">", 0)->where($aler . 'pink_id', ">", 0);
  1904. }
  1905. if ($where['combination_id'] == '秒杀订单') {
  1906. $model = $model->where($aler . 'seckill_id', ">", 0);
  1907. }
  1908. if ($where['combination_id'] == '砍价订单') {
  1909. $model = $model->where($aler . 'bargain_id', ">", 0);
  1910. }
  1911. }
  1912. if (isset($where['type'])) {
  1913. switch ($where['type']) {
  1914. case 1:
  1915. $model = $model->where($aler . 'combination_id', 0)->where($aler . 'seckill_id', 0)->where($aler . 'bargain_id', 0);
  1916. break;
  1917. case 2:
  1918. $model = $model->where($aler . 'combination_id', ">", 0);
  1919. break;
  1920. case 3:
  1921. $model = $model->where($aler . 'seckill_id', ">", 0);
  1922. break;
  1923. case 4:
  1924. $model = $model->where($aler . 'bargain_id', ">", 0);
  1925. break;
  1926. }
  1927. }
  1928. if (isset($where['real_name']) && $where['real_name'] != '')
  1929. $model = $model->where($aler . 'order_id|' . $aler . 'real_name|' . $aler . 'user_phone' . ($join ? '|' . $join . '.nickname|' . $join . '.uid' : ''), 'LIKE', "%$where[real_name]%");
  1930. if (isset($where['data']) && $where['data'] !== '')
  1931. $model = self::getModelTime($where, $model, $aler . 'add_time');
  1932. return $model;
  1933. }
  1934. /**
  1935. * 设置where条件
  1936. * @param $status
  1937. * @param null $model
  1938. * @param string $alert
  1939. * @return StoreOrder|null
  1940. */
  1941. public static function statusWhere($status, $model = null, $alert = '')
  1942. {
  1943. if ($model == null) $model = new self;
  1944. if ('' === $status)
  1945. return $model;
  1946. else if ($status == 0)//未支付
  1947. return $model->where($alert . 'paid', 0)->where($alert . 'status', 0)->where($alert . 'refund_status', 0);
  1948. else if ($status == 1)//已支付 未发货
  1949. return $model->where($alert . 'paid', 1)->where($alert . 'status', 0)->where($alert . 'refund_status', 0);
  1950. else if ($status == 2)//已支付 待收货
  1951. return $model->where($alert . 'paid', 1)->where($alert . 'status', 1)->where($alert . 'refund_status', 0);
  1952. else if ($status == 3)// 已支付 已收货 待评价
  1953. return $model->where($alert . 'paid', 1)->where($alert . 'status', 2)->where($alert . 'refund_status', 0);
  1954. else if ($status == 4)// 交易完成
  1955. return $model->where($alert . 'paid', 1)->where($alert . 'status', 3)->where($alert . 'refund_status', 0);
  1956. else if ($status == -1)//退款中
  1957. return $model->where($alert . 'paid', 1)->where($alert . 'refund_status', 1);
  1958. else if ($status == -2)//已退款
  1959. return $model->where($alert . 'paid', 1)->where($alert . 'refund_status', 2);
  1960. else if ($status == -3)//退款
  1961. return $model->where($alert . 'paid', 1)->where($alert . 'refund_status', 'in', '1,2');
  1962. else
  1963. return $model;
  1964. }
  1965. /**
  1966. * 订单详情 管理员
  1967. * @param $orderId
  1968. * @param string $field
  1969. * @return array|null|\think\Model
  1970. * @throws DataNotFoundException
  1971. * @throws ModelNotFoundException
  1972. * @throws \think\exception\DbException
  1973. */
  1974. public static function getAdminOrderDetail($orderId, $field = '*')
  1975. {
  1976. return self::where('order_id', $orderId)->field($field)->find();
  1977. }
  1978. /**
  1979. * 获取指定时间区间的支付金额 管理员
  1980. * @param $start
  1981. * @param $stop
  1982. * @return float
  1983. */
  1984. public static function getOrderTimeBusinessVolumePrice($start, $stop)
  1985. {
  1986. return self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->where('add_time', '>=', $start)->where('add_time', '<', $stop)->sum('pay_price');
  1987. }
  1988. /**
  1989. * 获取指定时间区间的支付订单数量 管理员
  1990. * @param $start
  1991. * @param $stop
  1992. * @return float
  1993. */
  1994. public static function getOrderTimeBusinessVolumeNumber($start, $stop)
  1995. {
  1996. return self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->where('add_time', '>=', $start)->where('add_time', '<', $stop)->count();
  1997. }
  1998. /**
  1999. * 获取当前时间到指定时间的支付金额 管理员
  2000. * @param $start 开始时间
  2001. * @param $stop 结束时间
  2002. * @return mixed
  2003. */
  2004. public static function chartTimePrice($start, $stop)
  2005. {
  2006. $model = new self;
  2007. $model = $model->field('sum(pay_price) as num,FROM_UNIXTIME(add_time, \'%Y-%m-%d\') as time');
  2008. $model = $model->where('is_del', 0);
  2009. $model = $model->where('paid', 1);
  2010. $model = $model->where('refund_status', 0);
  2011. $model = $model->where('add_time', '>=', $start);
  2012. $model = $model->where('add_time', '<', $stop);
  2013. $model = $model->group("FROM_UNIXTIME(add_time, '%Y-%m-%d')");
  2014. $model = $model->order('add_time ASC');
  2015. return $model->select();
  2016. }
  2017. /**
  2018. * 获取当前时间到指定时间的支付订单数 管理员
  2019. * @param $start 开始时间
  2020. * @param $stop 结束时间
  2021. * @return mixed
  2022. */
  2023. public static function chartTimeNumber($start, $stop)
  2024. {
  2025. $model = new self;
  2026. $model = $model->field('count(id) as num,FROM_UNIXTIME(add_time, \'%Y-%m-%d\') as time');
  2027. $model = $model->where('is_del', 0);
  2028. $model = $model->where('paid', 1);
  2029. $model = $model->where('refund_status', 0);
  2030. $model = $model->where('add_time', '>=', $start);
  2031. $model = $model->where('add_time', '<', $stop);
  2032. $model = $model->group("FROM_UNIXTIME(add_time, '%Y-%m-%d')");
  2033. $model = $model->order('add_time ASC');
  2034. return $model->select();
  2035. }
  2036. /**
  2037. * 修改支付方式为线下支付
  2038. * @param $orderId
  2039. * @return bool
  2040. */
  2041. public static function setOrderTypePayOffline($orderId)
  2042. {
  2043. return self::edit(['pay_type' => 'offline'], $orderId, 'order_id');
  2044. }
  2045. /**
  2046. * 线下付款
  2047. * @param $id
  2048. * @return $this
  2049. */
  2050. public static function updateOffline($id)
  2051. {
  2052. $count = self::where('id', $id)->count();
  2053. if (!$count) return self::setErrorInfo('订单不存在');
  2054. $count = self::where('id', $id)->where('paid', 0)->count();
  2055. if (!$count) return self::setErrorInfo('订单已支付');
  2056. $res = self::where('id', $id)->update(['paid' => 1, 'pay_time' => time()]);
  2057. return $res;
  2058. }
  2059. /**
  2060. * 向创建订单10分钟未付款的用户发送短信
  2061. */
  2062. public static function sendTen()
  2063. {
  2064. $list = self::where('paid', 0)->where('is_del', 0)->where('is_system_del', 0)->where('add_time', '>', time() - 900)->where('add_time', '<', time() - 600)->column('user_phone');
  2065. foreach ($list as $phone) {
  2066. ShortLetterRepositories::send(true, $phone, [], 'ORDER_PAY_FALSE');
  2067. }
  2068. }
  2069. public function productInfo()
  2070. {
  2071. return $this->hasMany(StoreProductReply::class, 'oid', 'id');
  2072. }
  2073. public static function setOrderProductReplyWhere($where)
  2074. {
  2075. $model = self::where('status', 3)->order('add_time desc')->whereIn('id', function ($query) {
  2076. $query->name('store_order')->alias('o')->join('store_product_reply a', 'a.oid = o.id')->group('o.id')->field('o.id')->select();
  2077. })->with('productInfo', function ($query) use ($where) {
  2078. $alias = '';
  2079. if (isset($where['title']) && $where['title'] != '')
  2080. $query->where("{$alias}comment", 'LIKE', "%$where[title]%");
  2081. if (isset($where['is_reply']) && $where['is_reply'] != '') {
  2082. if ($where['is_reply'] >= 0) {
  2083. $query->where("{$alias}is_reply", $where['is_reply']);
  2084. } else {
  2085. $query->where("{$alias}is_reply", '>', 0);
  2086. }
  2087. }
  2088. if (isset($where['producr_id']) && $where['producr_id'] != 0)
  2089. $query->where($alias . 'product_id', $where['producr_id']);
  2090. $query->where("{$alias}is_del", 0);
  2091. });
  2092. return $model;
  2093. }
  2094. public static function getOrderProductReplyList($where)
  2095. {
  2096. $list = self::setOrderProductReplyWhere($where)->page((int)$where['message_page'], (int)$where['limit'])->select();
  2097. $list = count($list) ? $list->toArray() : [];
  2098. foreach ($list as $key => $item) {
  2099. if (isset($item['productInfo']) && is_array($item['productInfo']) && count($item['productInfo'])) {
  2100. foreach ($item['productInfo'] as $k => $v) {
  2101. if (!$v['nickname'] && $v['uid']) {
  2102. $v['nickname'] = User::where('uid', $v['uid'])->value('nickname');
  2103. $v['avatar'] = User::where('uid', $v['uid'])->value('avatar');
  2104. }
  2105. $v['image'] = '';
  2106. $v['store_name'] = '';
  2107. if ($v['product_id']) {
  2108. $product = StoreProduct::where('id', $v['product_id'])->field(['image', 'store_name'])->find();
  2109. if ($product) {
  2110. $v['image'] = $product['image'];
  2111. $v['store_name'] = $product['store_name'];
  2112. }
  2113. }
  2114. $list[$key]['productInfo'][$k] = $v;
  2115. }
  2116. }
  2117. }
  2118. $count = self::setOrderProductReplyWhere($where)->count();
  2119. return compact('list', 'count');
  2120. }
  2121. /**
  2122. * 分红
  2123. * @return bool
  2124. * @throws DataNotFoundException
  2125. * @throws DbException
  2126. * @throws ModelNotFoundException
  2127. */
  2128. public static function bonus()
  2129. {
  2130. $user_address = User::where('provinces', 1)->where('address', '<>', ' ')->column('address');
  2131. $time = strtotime('-1 month');
  2132. $date1 = mktime(0,0,0,date('m',$time),01,date('Y',$time));
  2133. $date2 = mktime(23,59,59,date('m',$time),date('t',$time),date('Y',$time));
  2134. if (count($user_address) > 0){
  2135. $eve = [];
  2136. foreach ($user_address as $item){
  2137. $order = StoreOrder::where('user_address', 'like', '%'.$item.'%')->where('purchase', '<', 2)->whereBetweenTime('add_time', $date1, $date2)->where('paid', 1)->select();
  2138. $price = 0;
  2139. $ach = [];
  2140. foreach ($order as $value){
  2141. $attr = StoreOrderCartInfo::where('oid', $value['id'])->select();
  2142. $jl = 0;
  2143. foreach ($attr as $v){
  2144. $bonus = StoreProduct::where('id', $v['cart_info']['product_id'])->value('bonus');
  2145. $price += $bonus * $v['cart_info']['cart_num'];
  2146. $jl += $bonus * $v['cart_info']['cart_num'];
  2147. }
  2148. $ach[] = [
  2149. 'order_id' => $value['order_id'],
  2150. 'uid' => $value['uid'],
  2151. 'price' => $jl,
  2152. ];
  2153. }
  2154. if ($price > 0){
  2155. $eve[] = [
  2156. 'province' => $item,
  2157. 'number' => User::where('provinces', 1)->where('address', 'like', '%'.$item.'%')->count(),
  2158. 'price' => $price,
  2159. ];
  2160. $res = Achievement::create([
  2161. 'province' => $item,
  2162. 'number' => User::where('provinces', 1)->where('address', 'like', '%'.$item.'%')->count(),
  2163. 'price' => $price,
  2164. 'type' => 1,
  2165. ]);
  2166. foreach ($ach as $list){
  2167. $list['a_id'] = $res['id'];
  2168. Ach::create($list);
  2169. }
  2170. }
  2171. }
  2172. if ($eve){
  2173. foreach ($eve as $item){
  2174. $users = User::where('provinces', 1)->where('address', 'like', '%'.$item['province'].'%')->select()->toArray();
  2175. foreach ($users as $v)
  2176. {
  2177. $jl = round(($item['price']/2)/$item['number'], 2);
  2178. User::where('uid', $v['uid'])->inc('brokerage_price', $jl)->update();
  2179. UserBill::income('业绩分红',$v['uid'], 'now_money', 'bonus', $jl, 0, $v['brokerage_price']+$jl, $item['province'].'业绩分红');
  2180. }
  2181. }
  2182. }
  2183. }
  2184. return true;
  2185. }
  2186. /**
  2187. * 团队
  2188. * @return bool
  2189. * @throws DataNotFoundException
  2190. * @throws DbException
  2191. * @throws ModelNotFoundException
  2192. */
  2193. public static function team()
  2194. {
  2195. $user= User::select();
  2196. $time = strtotime('-1 month');
  2197. $date1 = mktime(0,0,0,date('m',$time),01,date('Y',$time));
  2198. $date2 = mktime(23,59,59,date('m',$time),date('t',$time),date('Y',$time));
  2199. $now_month_first_date = strtotime(date('Y-m-1'));
  2200. $now_month_last_date = strtotime(date('Y-m-d',strtotime(date('Y-m-1',strtotime('next month')).'-1 day')));
  2201. foreach ($user as $item)
  2202. {
  2203. $order = StoreOrder::where('uid', $item['uid'])->where('purchase', '<', 2)->whereBetweenTime('add_time', $date1, $date2)->where('paid', 1)->select();
  2204. if (count($order) > 0){
  2205. $price = 0;
  2206. $ach = [];
  2207. foreach ($order as $value){
  2208. $attr = StoreOrderCartInfo::where('oid', $value['id'])->select();
  2209. $jl = 0;
  2210. foreach ($attr as $v){
  2211. $team = StoreProduct::where('id', $v['cart_info']['product_id'])->value('team');
  2212. $price += $team * $v['cart_info']['cart_num'];
  2213. $jl += $team * $v['cart_info']['cart_num'];
  2214. }
  2215. $ach[] = [
  2216. 'order_id' => $value['order_id'],
  2217. 'uid' => $value['uid'],
  2218. 'price' => $jl,
  2219. ];
  2220. }
  2221. $uid = getParent($item['spread_uid'], $user->toArray());
  2222. if ($uid){
  2223. $av = Achievement::where('uid', $uid[0])->whereBetweenTime('create_time', $now_month_first_date,$now_month_last_date)->find();
  2224. if ($av){
  2225. $av['price'] += $price;
  2226. foreach ($ach as $list){
  2227. $list['a_id'] = $av['id'];
  2228. Ach::create($list);
  2229. }
  2230. $av->save();
  2231. }else{
  2232. $res = Achievement::create([
  2233. 'uid' => $uid[0],
  2234. 'number' => 1,
  2235. 'price' => $price,
  2236. 'type' => 2,
  2237. ]);
  2238. foreach ($ach as $list){
  2239. $list['a_id'] = $res['id'];
  2240. Ach::create($list);
  2241. }
  2242. }
  2243. $details = User::where('uid', $uid[0])->find();
  2244. User::where('uid', $details['uid'])->inc('brokerage_price', $price)->update();
  2245. UserBill::income('团队奖励',$details['uid'], 'now_money', 'team', $price, 0, $details['brokerage_price']+$price, '团队奖励');
  2246. }
  2247. }
  2248. }
  2249. return true;
  2250. }
  2251. }