StoreOrder.php 102 KB

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