123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247 |
- <?php
- namespace app\models\store;
- use app\admin\model\system\ShippingTemplatesFree;
- use app\admin\model\system\ShippingTemplatesRegion;
- use crmeb\basic\BaseModel;
- use think\db\exception\DataNotFoundException;
- use think\db\exception\DbException;
- use think\db\exception\ModelNotFoundException;
- use think\facade\Cache;
- use crmeb\traits\ModelTrait;
- use think\facade\Log;
- use app\models\system\SystemStore;
- use app\models\routine\RoutineTemplate;
- use app\models\user\{Out, ProxyAddress, User, UserAddress, UserBill, UserLevel, UserPartake, UserSpread, WechatUser};
- use crmeb\services\{
- SystemConfigService, WechatTemplateService, workerman\ChannelService
- };
- use crmeb\repositories\{
- GoodsRepository, PaymentRepositories, OrderRepository, ShortLetterRepositories, UserRepository
- };
- use app\admin\model\system\ShippingTemplates;
- class StoreOrder extends BaseModel
- {
-
- protected $pk = 'id';
-
- protected $name = 'store_order';
- use ModelTrait;
- protected $insert = ['add_time'];
- protected static $payType = ['weixin' => '微信支付', 'yue' => '余额支付', 'offline' => '线下支付', 'ali' => '支付宝支付'];
- protected static $deliveryType = ['send' => '商家配送', 'express' => '快递配送'];
- protected function setAddTimeAttr()
- {
- return time();
- }
- protected function setCartIdAttr($value)
- {
- return is_array($value) ? json_encode($value) : $value;
- }
- protected function getCartIdAttr($value)
- {
- return json_decode($value, true);
- }
-
- public static function getOrderPriceGroup($cartInfo, $addr)
- {
- $storeFreePostage = floatval(sys_config('store_free_postage')) ?: 0;
- $totalPrice = self::getOrderSumPrice($cartInfo, 'truePrice');
- $totalIntegral = self::getOrderSumPrice($cartInfo, 'integral');
- $costPrice = self::getOrderSumPrice($cartInfo, 'costPrice');
- $vipPrice = self::getOrderSumPrice($cartInfo, 'vip_truePrice');
-
- if (!$storeFreePostage) {
- $storePostage = 0;
- } else {
- if ($addr) {
-
- $temp_num = [];
- foreach ($cartInfo as $cart) {
- $temp = ShippingTemplates::get($cart['productInfo']['temp_id']);
- if (!$temp) $temp = ShippingTemplates::get(1);
- if ($temp->getData('type') == 1) {
- $num = $cart['cart_num'];
- } elseif ($temp->getData('type') == 2) {
- $num = $cart['cart_num'] * $cart['productInfo']['attrInfo']['weight'];
- } else {
- $num = $cart['cart_num'] * $cart['productInfo']['attrInfo']['volume'];
- }
- $region = ShippingTemplatesRegion::where('temp_id', $cart['productInfo']['temp_id'])->where('city_id', $addr['city_id'])->find();
- if (!$region) $region = ShippingTemplatesRegion::where('temp_id', $cart['productInfo']['temp_id'])->where('city_id', 0)->find();
- if (!$region) $region = ShippingTemplatesRegion::where('temp_id', 1)->where('city_id', 0)->find();
- if (!$region) {
- return self::setErrorInfo('运费模板不存在');
- }
- if (!isset($temp_num[$cart['productInfo']['temp_id']])) {
- $temp_num[$cart['productInfo']['temp_id']]['number'] = $num;
- $temp_num[$cart['productInfo']['temp_id']]['price'] = bcmul($cart['cart_num'], $cart['truePrice'], 2);
- $temp_num[$cart['productInfo']['temp_id']]['first'] = $region['first'];
- $temp_num[$cart['productInfo']['temp_id']]['first_price'] = $region['first_price'];
- $temp_num[$cart['productInfo']['temp_id']]['continue'] = $region['continue'];
- $temp_num[$cart['productInfo']['temp_id']]['continue_price'] = $region['continue_price'];
- $temp_num[$cart['productInfo']['temp_id']]['temp_id'] = $cart['productInfo']['temp_id'];
- $temp_num[$cart['productInfo']['temp_id']]['city_id'] = $addr['city_id'];
- } else {
- $temp_num[$cart['productInfo']['temp_id']]['number'] += $num;
- $temp_num[$cart['productInfo']['temp_id']]['price'] += bcmul($cart['cart_num'], $cart['truePrice'], 2);
- }
- }
- array_multisort(array_column($temp_num, 'first_price'), SORT_DESC, $temp_num);
- $type = $storePostage = 0;
- foreach ($temp_num as $k => $v) {
- if (ShippingTemplatesFree::where('temp_id', $v['temp_id'])->where('city_id', $v['city_id'])->where('number', '<=', $v['number'])->where('price', '<=', $v['price'])->find()) {
- unset($temp_num[$k]);
- }
- }
- foreach ($temp_num as $v) {
- if ($type == 0) {
- if ($v['number'] <= $v['first']) {
- $storePostage = bcadd($storePostage, $v['first_price'], 2);
- } else {
- if ($v['continue'] <= 0) {
- $storePostage = $storePostage;
- } else {
- $storePostage = bcadd(bcadd($storePostage, $v['first_price'], 2), bcmul(ceil(bcdiv(bcsub($v['number'], $v['first']), $v['continue'] ?? 0, 2)), $v['continue_price']), 2);
- }
- }
- $type = 1;
- } else {
- if ($v['continue'] <= 0) {
- $storePostage = $storePostage;
- } else {
- $storePostage = bcadd($storePostage, bcmul(ceil(bcdiv($v['number'], $v['continue'] ?? 0, 2)), $v['continue_price']), 2);
- }
- }
- }
- } else {
- $storePostage = 0;
- }
- if ($storeFreePostage <= $totalPrice) $storePostage = 0;
- }
- return compact('storePostage', 'storeFreePostage', 'totalPrice', 'costPrice', 'vipPrice', 'totalIntegral');
- }
-
- public static function getOrderSumPrice($cartInfo, $key = 'truePrice')
- {
- $SumPrice = 0;
- foreach ($cartInfo as $cart) {
- $SumPrice = bcadd($SumPrice, bcmul($cart['cart_num'], $cart[$key], 2), 2);
- }
- return $SumPrice;
- }
-
- public static function getCombinationOrderPriceGroup($cartInfo)
- {
- $storePostage = floatval(sys_config('store_postage')) ?: 0;
- $storeFreePostage = floatval(sys_config('store_free_postage')) ?: 0;
- $totalPrice = self::getCombinationOrderTotalPrice($cartInfo);
- $costPrice = self::getCombinationOrderTotalPrice($cartInfo);
- if (!$storeFreePostage) {
- $storePostage = 0;
- } else {
- foreach ($cartInfo as $cart) {
- if (!StoreCombination::where('id', $cart['combination_id'])->value('is_postage'))
- $storePostage = bcadd($storePostage, StoreCombination::where('id', $cart['combination_id'])->value('postage'), 2);
- }
- if ($storeFreePostage <= $totalPrice) $storePostage = 0;
- }
- return compact('storePostage', 'storeFreePostage', 'totalPrice', 'costPrice');
- }
-
- public static function getCombinationOrderTotalPrice($cartInfo)
- {
- $totalPrice = 0;
- foreach ($cartInfo as $cart) {
- if ($cart['combination_id']) {
- $totalPrice = bcadd($totalPrice, bcmul($cart['cart_num'], StoreCombination::where('id', $cart['combination_id'])->value('price'), 2), 2);
- }
- }
- return (float)$totalPrice;
- }
-
- public static function cacheOrderInfo($uid, $cartInfo, $priceGroup, $other = [], $cacheTime = 600)
- {
- do {
- $key = md5(time() . rand(100000, 999999));
- } while (Cache::has('user_order_' . $uid . $key));
- Cache::set('user_order_' . $uid . $key, compact('cartInfo', 'priceGroup', 'other'), $cacheTime);
- return $key;
- }
-
- public static function getCacheOrderInfo($uid, $key)
- {
- $cacheName = 'user_order_' . $uid . $key;
- if (!Cache::has($cacheName)) return null;
- return Cache::get($cacheName);
- }
-
- public static function clearCacheOrderInfo($uid, $key)
- {
- Cache::delete('user_order_' . $uid . $key);
- }
-
- public static function cacheKeyCreateOrder($uid, $key, $addressId, $payType, $useIntegral = false, $couponId = 0, $mark = '', $combinationId = 0, $pinkId = 0, $seckill_id = 0, $bargain_id = 0, $test = false, $isChannel = 0, $shipping_type = 1, $real_name = '', $phone = '', $storeId = 0)
- {
- self::beginTrans();
- try {
- $shipping_type = (int)$shipping_type;
- $offlinePayStatus = (int)sys_config('offline_pay_status') ?? (int)2;
- if ($offlinePayStatus == 2) unset(self::$payType['offline']);
- if (!array_key_exists($payType, self::$payType)) return self::setErrorInfo('选择支付方式有误!', true);
- if (self::be(['unique' => $key, 'uid' => $uid])) return self::setErrorInfo('请勿重复提交订单', true);
- $userInfo = User::getUserInfo($uid);
- if (!$userInfo) return self::setErrorInfo('用户不存在!', true);
- $cartGroup = self::getCacheOrderInfo($uid, $key);
- if (!$cartGroup) return self::setErrorInfo('订单已过期,请刷新当前页面!', true);
- $cartInfo = $cartGroup['cartInfo'];
- $priceGroup = $cartGroup['priceGroup'];
- $other = $cartGroup['other'];
- $payPrice = (float)$priceGroup['totalPrice'];
- $payIntegral = (float)$priceGroup['totalIntegral'];
- $addr = UserAddress::where('uid', $uid)->where('id', $addressId)->find();
- if ($payType == 'offline' && sys_config('offline_postage') == 1) {
- $payPostage = 0;
- } else {
- $payPostage = self::getOrderPriceGroup($cartInfo, $addr)['storePostage'];
- }
- if ($shipping_type === 1) {
- if (!$test && !$addressId) return self::setErrorInfo('请选择收货地址!', true);
- if (!$test && (!UserAddress::be(['uid' => $uid, 'id' => $addressId, 'is_del' => 0]) || !($addressInfo = UserAddress::find($addressId))))
- return self::setErrorInfo('地址选择有误!', true);
- } else {
- if ((!$real_name || !$phone) && !$test) return self::setErrorInfo('请填写姓名和电话', true);
- $addressInfo['real_name'] = $real_name;
- $addressInfo['phone'] = $phone;
- $addressInfo['province'] = '';
- $addressInfo['city'] = '';
- $addressInfo['district'] = '';
- $addressInfo['detail'] = '';
- }
- $cartIds = [];
- $totalNum = 0;
- $gainIntegral = 0;
- foreach ($cartInfo as $cart) {
- $cartIds[] = $cart['id'];
- $totalNum += $cart['cart_num'];
- if (!$seckill_id) $seckill_id = $cart['seckill_id'];
- if (!$bargain_id) $bargain_id = $cart['bargain_id'];
- if (!$combinationId) $combinationId = $cart['combination_id'];
- $cartInfoGainIntegral = isset($cart['productInfo']['give_integral']) ? bcmul($cart['cart_num'], $cart['productInfo']['give_integral'], 2) : 0;
- $gainIntegral = bcadd($gainIntegral, $cartInfoGainIntegral, 2);
- }
- $deduction = $seckill_id || $bargain_id || $combinationId;
- if ($deduction) {
- $couponId = 0;
- $useIntegral = false;
- if (!$test) {
- unset(self::$payType['offline']);
- if (!array_key_exists($payType, self::$payType)) return self::setErrorInfo('营销产品不能使用线下支付!', true);
- }
- }
-
- $res1 = true;
- if ($couponId) {
- $couponInfo = StoreCouponUser::validAddressWhere()->where('id', $couponId)->where('uid', $uid)->find();
- if (!$couponInfo) return self::setErrorInfo('选择的优惠劵无效!', true);
- $coupons = StoreCouponUser::getUsableCouponList($uid, ['valid' => $cartInfo], $payPrice);
- $flag = false;
- foreach ($coupons as $coupon) {
- if ($coupon['id'] == $couponId) {
- $flag = true;
- continue;
- }
- }
- if (!$flag)
- return self::setErrorInfo('不满足优惠劵的使用条件!', true);
- $payPrice = (float)bcsub($payPrice, $couponInfo['coupon_price'], 2);
- $res1 = StoreCouponUser::useCoupon($couponId);
- $couponPrice = $couponInfo['coupon_price'];
- } else {
- $couponId = 0;
- $couponPrice = 0;
- }
- if (!$res1) return self::setErrorInfo('使用优惠劵失败!', true);
-
- $store_self_mention = sys_config('store_self_mention') ?? 0;
- if (!$store_self_mention) $shipping_type = 1;
- if ($shipping_type === 1) {
-
- if ((isset($other['offlinePostage']) && $other['offlinePostage'] && $payType == 'offline')) $payPostage = 0;
- $payPrice = (float)bcadd($payPrice, $payPostage, 2);
- } else if ($shipping_type === 2) {
-
- $priceGroup['storePostage'] = 0;
- $payPostage = 0;
- if (!$storeId && !$test) {
- return self::setErrorInfo('请选择门店', true);
- }
- }
-
- $res2 = true;
- $SurplusIntegral = $userInfo['integral'];
- if ($payIntegral > 0) {
- if ($userInfo['integral'] < $payIntegral) {
- return self::setErrorInfo('积分不足', true);
- } else {
- $res2 = false !== User::bcDec($userInfo['uid'], 'integral', $payIntegral, 'uid');
- }
- $SurplusIntegral = bcsub($userInfo['integral'], $payIntegral, 2);
- $res2 = $res2 && false != UserBill::expend('积分商品', $uid, 'integral', 'integral_product', $payIntegral, $key, $SurplusIntegral, '购买积分商品使用' . $payIntegral . '积分');
- }
-
- if ($useIntegral && $SurplusIntegral > 0) {
- $deductionPrice = (float)bcmul($SurplusIntegral, $other['integralRatio'], 2);
- if ($deductionPrice < $payPrice) {
- $payPrice = bcsub($payPrice, $deductionPrice, 2);
- $usedIntegral = $SurplusIntegral;
- $SurplusIntegral = 0;
- $res2 = false !== User::edit(['integral' => 0], $userInfo['uid'], 'uid');
- } else {
- $deductionPrice = $payPrice;
- $usedIntegral = (float)bcdiv($payPrice, $other['integralRatio'], 2);
- $SurplusIntegral = bcsub($SurplusIntegral, $usedIntegral, 2);
- $res2 = false !== User::bcDec($userInfo['uid'], 'integral', $usedIntegral, 'uid');
- $payPrice = 0;
- }
- $res2 = $res2 && false != UserBill::expend('积分抵扣', $uid, 'integral', 'deduction', $usedIntegral, $key, $SurplusIntegral, '购买商品使用' . floatval($usedIntegral) . '积分抵扣' . floatval($deductionPrice) . '元');
- } else {
- $deductionPrice = 0;
- $usedIntegral = 0;
- }
- if (!$res2) return self::setErrorInfo('使用积分抵扣失败!', true);
- if ($payPrice <= 0) $payPrice = 0;
- if ($test) {
- self::rollbackTrans();
- return [
- 'total_price' => $priceGroup['totalPrice'],
- 'pay_price' => $payPrice,
- 'pay_postage' => $payPostage,
- 'coupon_price' => $couponPrice,
- 'deduction_price' => $deductionPrice,
- 'totalIntegral' => $payIntegral,
- 'SurplusIntegral' => $SurplusIntegral,
- ];
- }
- $orderInfo = [
- 'uid' => $uid,
- 'order_id' => $test ? 0 : self::getNewOrderId(),
- 'real_name' => $addressInfo['real_name'],
- 'user_phone' => $addressInfo['phone'],
- 'user_address' => $addressInfo['province'] . ' ' . $addressInfo['city'] . ' ' . $addressInfo['district'] . ' ' . $addressInfo['detail'],
- 'cart_id' => $cartIds,
- 'total_num' => $totalNum,
- 'total_price' => $priceGroup['totalPrice'],
- 'total_postage' => $priceGroup['storePostage'],
- 'coupon_id' => $couponId,
- 'coupon_price' => $couponPrice,
- 'pay_price' => $payPrice,
- 'pay_postage' => $payPostage,
- 'deduction_price' => $deductionPrice,
- 'paid' => 0,
- 'pay_type' => $payType,
- 'use_integral' => $usedIntegral + $payIntegral,
- 'gain_integral' => $gainIntegral,
- 'mark' => htmlspecialchars($mark),
- 'combination_id' => $combinationId,
- 'pink_id' => $pinkId,
- 'seckill_id' => $seckill_id,
- 'bargain_id' => $bargain_id,
- 'cost' => $priceGroup['costPrice'],
- 'is_channel' => $isChannel,
- 'add_time' => time(),
- 'unique' => $key,
- 'shipping_type' => $shipping_type,
- ];
- if ($shipping_type === 2) {
- $orderInfo['verify_code'] = self::getStoreCode();
- $orderInfo['store_id'] = SystemStore::getStoreDispose($storeId, 'id');
- if (!$orderInfo['store_id']) return self::setErrorInfo('暂无门店无法选择门店自提!', true);
- }
- $order = self::create($orderInfo);
- if (!$order) return self::setErrorInfo('订单生成失败!', true);
- $res5 = true;
- foreach ($cartInfo as $cart) {
-
- if ($combinationId) $res5 = $res5 && StoreCombination::decCombinationStock($cart['cart_num'], $combinationId, isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
- else if ($seckill_id) $res5 = $res5 && StoreSeckill::decSeckillStock($cart['cart_num'], $seckill_id, isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
- else if ($bargain_id) $res5 = $res5 && StoreBargain::decBargainStock($cart['cart_num'], $bargain_id, isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
- else $res5 = $res5 && StoreProduct::decProductStock($cart['cart_num'], $cart['productInfo']['id'], isset($cart['productInfo']['attrInfo']) ? $cart['productInfo']['attrInfo']['unique'] : '');
- }
-
- $res4 = false !== StoreOrderCartInfo::setCartInfo($order['id'], $cartInfo);
-
- $res6 = false !== StoreCart::where('id', 'IN', $cartIds)->update(['is_pay' => 1]);
- if (!$res4 || !$res5 || !$res6) return self::setErrorInfo('订单生成失败!', true);
-
- UserRepository::storeProductOrderCreateEbApi($order, compact('cartInfo', 'addressId'));
- self::clearCacheOrderInfo($uid, $key);
- self::commitTrans();
- StoreOrderStatus::status($order['id'], 'cache_key_create_order', '订单生成');
- return $order;
- } catch (\PDOException $e) {
- self::rollbackTrans();
- return self::setErrorInfo('生成订单时SQL执行错误错误原因:' . $e->getMessage());
- } catch (\Exception $e) {
- self::rollbackTrans();
- return self::setErrorInfo('生成订单时系统错误错误原因:' . $e->getMessage());
- }
- }
-
- public static function RegressionIntegral($order)
- {
- if ($order['paid'] || $order['status'] == -2 || $order['is_del']) return true;
- if ($order['use_integral'] <= 0) return true;
- if ((int)$order['status'] != -2 && (int)$order['refund_status'] != 2 && $order['back_integral'] >= $order['use_integral']) return true;
- $res = User::bcInc($order['uid'], 'integral', $order['use_integral']);
- if (!$res) return self::setErrorInfo('回退积分增加失败');
- UserBill::income('积分回退', $order['uid'], 'integral', 'deduction', $order['use_integral'], $order['unique'], User::where('uid', $order['uid'])->value('integral'), '购买商品失败,回退积分' . floatval($order['use_integral']));
- return false !== self::where('order_id', $order['order_id'])->update(['back_integral' => $order['use_integral']]);
- }
-
- public static function RegressionStock($order)
- {
- if ($order['paid'] || $order['status'] == -2 || $order['is_del']) return true;
- $combinationId = $order['combination_id'];
- $seckill_id = $order['seckill_id'];
- $bargain_id = $order['bargain_id'];
- $res5 = true;
- $cartInfo = StoreOrderCartInfo::where('cart_id', 'in', $order['cart_id'])->select();
- foreach ($cartInfo as $cart) {
-
- if ($combinationId) $res5 = $res5 && StoreCombination::incCombinationStock($cart['cart_info']['cart_num'], $combinationId);
- else if ($seckill_id) $res5 = $res5 && StoreSeckill::incSeckillStock($cart['cart_info']['cart_num'], $seckill_id);
- else if ($bargain_id) $res5 = $res5 && StoreBargain::incBargainStock($cart['cart_info']['cart_num'], $bargain_id);
- 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'] : '');
- }
- return $res5;
- }
-
- public static function RegressionCoupon($order)
- {
- if ($order['paid'] || $order['status'] == -2 || $order['is_del']) return true;
- $res = true;
- if ($order['coupon_id'] && StoreCouponUser::be(['id' => $order['coupon_id'], 'uid' => $order['uid'], 'status' => 1])) {
- $res = $res && false !== StoreCouponUser::where('id', $order['coupon_id'])->where('uid', $order['uid'])->update(['status' => 0, 'use_time' => 0]);
- }
- return $res;
- }
-
- public static function cancelOrder($order_id, $uid)
- {
- $order = self::where('order_id', $order_id)->where('uid', $uid)->find();
- if (!$order) return self::setErrorInfo('没有查到此订单');
- self::beginTrans();
- try {
- $res = self::RegressionIntegral($order) && self::RegressionStock($order) && self::RegressionCoupon($order);
- $order->is_del = 1;
- if ($res && $order->save()) {
- self::commitTrans();
- return true;
- } else
- return false;
- } catch (\Exception $e) {
- self::rollbackTrans();
- return self::setErrorInfo(['line' => $e->getLine(), 'message' => $e->getMessage()]);
- }
- }
-
- public static function getNewOrderId()
- {
- do {
- list($msec, $sec) = explode(' ', microtime());
- $msectime = number_format((floatval($msec) + floatval($sec)) * 1000, 0, '', '');
- $orderId = 'wx' . $msectime . mt_rand(10000, 99999);
- } while (self::be(['order_id' => $orderId]));
- return $orderId;
- }
-
- public static function changeOrderId($orderId)
- {
- $ymd = substr($orderId, 2, 8);
- $key = substr($orderId, 16);
- return 'wx' . $ymd . date('His') . $key;
- }
-
- public static function getProductTitle($cartId)
- {
- $title = '';
- try {
- $orderCart = StoreOrderCartInfo::where('cart_id', 'in', $cartId)->field('cart_info')->select();
- foreach ($orderCart as $item) {
- if (isset($item['cart_info']['productInfo']['store_name'])) {
- $title .= $item['cart_info']['productInfo']['store_name'] . '|';
- }
- }
- unset($item);
- if (!$title) {
- $productIds = StoreCart::where('id', 'in', $cartId)->column('product_id');
- $productlist = ($productlist = StoreProduct::getProductField($productIds, 'store_name')) ? $productlist->toArray() : [];
- foreach ($productlist as $item) {
- if (isset($item['store_name'])) $title .= $item['store_name'] . '|';
- }
- }
- if ($title) $title = substr($title, 0, strlen($title) - 1);
- unset($item);
- } catch (\Exception $e) {
- }
- return $title;
- }
-
- public static function getStoreCode()
- {
- list($msec, $sec) = explode(' ', microtime());
- $num = bcadd(time(), mt_rand(10, 999999), 0) . '' . substr($msec, 2, 3);
- if (strlen($num) < 12)
- $num = str_pad((string)$num, 12, 0, STR_PAD_RIGHT);
- else
- $num = substr($num, 0, 12);
- if (self::be(['verify_code' => $num])) return self::getStoreCode();
- return $num;
- }
-
- public static function yuePay($order_id, $uid, $formId = '')
- {
- $orderInfo = self::where('uid', $uid)->where('order_id', $order_id)->where('is_del', 0)->find();
- if (!$orderInfo) return self::setErrorInfo('订单不存在!');
- if ($orderInfo['paid']) return self::setErrorInfo('该订单已支付!');
- $userInfo = User::getUserInfo($uid);
- if ($userInfo['now_money'] < $orderInfo['pay_price'])
- return self::setErrorInfo(['status' => 'pay_deficiency', 'msg' => '余额不足' . floatval($orderInfo['pay_price'])]);
- self::beginTrans();
- $res1 = false !== User::bcDec($uid, 'now_money', $orderInfo['pay_price'], 'uid');
- $res2 = UserBill::expend('购买商品', $uid, 'now_money', 'pay_product', $orderInfo['pay_price'], $orderInfo['id'], $userInfo['now_money'], '余额支付' . floatval($orderInfo['pay_price']) . '元购买商品');
- $res3 = self::paySuccess($order_id, 'yue', $formId);
- try {
- PaymentRepositories::yuePayProduct($userInfo, $orderInfo);
- } catch (\Exception $e) {
- self::rollbackTrans();
- return self::setErrorInfo($e->getMessage());
- }
- $res = $res1 && $res2 && $res3;
- self::checkTrans($res);
- return $res;
- }
-
- public static function jsPayPrice($order_id, $uid, $formId = '')
- {
- $orderInfo = self::where('uid', $uid)->where('order_id', $order_id)->where('is_del', 0)->find();
- if (!$orderInfo) return self::setErrorInfo('订单不存在!');
- if ($orderInfo['paid']) return self::setErrorInfo('该订单已支付!');
- $userInfo = User::getUserInfo($uid);
- self::beginTrans();
- $res1 = UserBill::expend('购买商品', $uid, 'now_money', 'pay_product', $orderInfo['pay_price'], $orderInfo['id'], $userInfo['now_money'], '微信支付' . floatval($orderInfo['pay_price']) . '元购买商品');
- $res2 = self::paySuccess($order_id, 'weixin', $formId);
- $res = $res1 && $res2;
- self::checkTrans($res);
- return $res;
- }
-
- public static function orderApplyRefund($uni, $uid, $refundReasonWap = '', $refundReasonWapExplain = '', $refundReasonWapImg = [])
- {
- $order = self::getUserOrderDetail($uid, $uni);
- if (!$order) return self::setErrorInfo('支付订单不存在!');
- if ($order['refund_status'] == 2) return self::setErrorInfo('订单已退款!');
- if ($order['refund_status'] == 1) return self::setErrorInfo('正在申请退款中!');
- if ($order['status'] == 1) return self::setErrorInfo('订单当前无法退款!');
- self::beginTrans();
- $res1 = false !== StoreOrderStatus::status($order['id'], 'apply_refund', '用户申请退款,原因:' . $refundReasonWap);
- $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');
- $res = $res1 && $res2;
- self::checkTrans($res);
- if (!$res)
- return self::setErrorInfo('申请退款失败!');
- else {
- try {
- if (in_array($order['is_channel'], [0, 2])) {
-
- WechatTemplateService::sendAdminNoticeTemplate([
- 'first' => "亲,有个订单申请退款 \n订单号:{$order['order_id']}",
- 'keyword1' => '退款申请',
- 'keyword2' => '已支付',
- 'keyword3' => date('Y/m/d H:i', time()),
- 'remark' => '请及时处理'
- ]);
- }
- if (in_array($order['is_channel'], [1, 2])) {
-
- RoutineTemplate::sendOrderRefundStatus($order, $refundReasonWap);
- }
-
- ChannelService::instance()->send('NEW_REFUND_ORDER', ['order_id' => $order['order_id']]);
- } catch (\Exception $e) {
- }
-
- event('ShortMssageSend', [$order['order_id'], 'AdminRefund']);
- return true;
- }
- }
-
- public static function paySuccess($orderId, $paytype = 'weixin', $formId = '')
- {
- $order = self::where('order_id', $orderId)->find();
- $resPink = true;
- $res1 = self::where('order_id', $orderId)->update(['paid' => 1, 'pay_type' => $paytype, 'pay_time' => time(), 'is_del' => 0, 'is_system_del' => 0]);
- if ($order->combination_id && $res1 && !$order->refund_status) $resPink = StorePink::createPink($order);
- $oid = self::where('order_id', $orderId)->value('id');
- StoreOrderStatus::status($oid, 'pay_success', '用户付款成功');
- $now_money = User::where('uid', $order['uid'])->value('now_money');
- UserBill::expend('购买商品', $order['uid'], 'now_money', 'pay_money', $order['pay_price'], $order['id'], $now_money, '支付' . floatval($order['pay_price']) . '元购买商品');
-
- event('OrderPaySuccess', [$order, $formId]);
- self::push($order);
- $res = $res1 && $resPink && UserSpread::setSpreadSure($order['uid']) && User::backOrderBrokerage($order);
- return false !== $res;
- }
-
- public static function push($order)
- {
- $user = User::where('uid', $order['uid'])->find();
- if ($user['spread_uid']){
- $spread = User::where('uid', $user['spread_uid'])->where('level', 2)->find();
- if ($spread){
-
- $group_purchase = sys_config('group_purchase');
- $jl = round($order['pay_price'] * ($group_purchase/100), 2);
- UserBill::income('佣金', $spread['uid'], 'now_money', 'brokerage', $jl, '', $spread['brokerage_price']+$jl, '直推佣金奖励');
- User::where('uid', $spread['uid'])->inc('brokerage_price', $jl)->update();
- }
- }
- }
-
- public static function createOrderTemplate($order)
- {
-
- }
-
- public static function getUserOrderDetail($uid, $key)
- {
- return self::where('order_id|unique', $key)->where('uid', $uid)->where('is_del', 0)->find();
- }
-
- public static function orderPostageAfter($postageData, $oid)
- {
- $order = self::where('id', $oid)->find();
- if ($postageData['delivery_type'] == 'send') {
- RoutineTemplate::sendOrderPostage($order);
- } else if ($postageData['delivery_type'] == 'express') {
- RoutineTemplate::sendOrderPostage($order, 1);
- }
- }
-
- public static function orderTakeAfter($order)
- {
- $title = self::getProductTitle($order['cart_id']);
- if ($order['is_channel'] == 1) {
- RoutineTemplate::sendOrderTakeOver($order, $title);
- } else {
- $openid = WechatUser::where('uid', $order['uid'])->value('openid');
- \crmeb\services\WechatTemplateService::sendTemplate($openid, \crmeb\services\WechatTemplateService::ORDER_TAKE_SUCCESS, [
- 'first' => '亲,您的订单已收货',
- 'keyword1' => $order['order_id'],
- 'keyword2' => '已收货',
- 'keyword3' => date('Y-m-d H:i:s', time()),
- 'keyword4' => $title,
- 'remark' => '感谢您的光临!'
- ]);
- }
- }
-
- public static function removeOrder($uni, $uid)
- {
- $order = self::getUserOrderDetail($uid, $uni);
- if (!$order) return self::setErrorInfo('订单不存在!');
- $order = self::tidyOrder($order);
- if ($order['_status']['_type'] != 0 && $order['_status']['_type'] != -2 && $order['_status']['_type'] != 4)
- return self::setErrorInfo('该订单无法删除!');
- if (false !== self::edit(['is_del' => 1], $order['id'], 'id') && false !== StoreOrderStatus::status($order['id'], 'remove_order', '删除订单')) {
-
- if ($order['_status']['_type'] == 0 || $order['_status']['_type'] == -2) {
- event('StoreOrderRegressionAllAfter', [$order]);
- }
- event('UserOrderRemoved', $uni);
- return true;
- } else
- return self::setErrorInfo('订单删除失败!');
- }
-
- public static function takeOrder($uni, $uid)
- {
- $order = self::getUserOrderDetail($uid, $uni);
- if (!$order) return self::setErrorInfo('订单不存在!');
- $order = self::tidyOrder($order);
- if ($order['_status']['_type'] != 2) return self::setErrorInfo('订单状态错误!');
- self::beginTrans();
- if (false !== self::edit(['status' => 2], $order['id'], 'id') &&
- false !== StoreOrderStatus::status($order['id'], 'user_take_delivery', '用户已收货')) {
- try {
- OrderRepository::storeProductOrderUserTakeDelivery($order, $uid);
- UserBill::where('uid', $order['uid'])->where('link_id', $order['id'])->where('type', 'pay_money')->update(['take' => 1]);
- } catch (\Exception $e) {
- self::rollbackTrans();
- return self::setErrorInfo($e->getMessage());
- }
- self::cumulative($order);
- self::team($order);
- self::proxy($order);
- self::commitTrans();
- UserLevel::setLevelComplete($uid);
- event('UserLevelAfter', [User::get($uni)]);
- event('UserOrderTake', $uni);
-
- event('ShortMssageSend', [$order['order_id'], ['Receiving', 'AdminConfirmTakeOver']]);
- return true;
- } else {
- self::rollbackTrans();
- return false;
- }
- }
-
- public static function cumulative($order)
- {
- User::where('uid', $order['uid'])->inc('pay_price', $order['pay_price'])->update();
- $user = User::where('uid', $order['uid'])->find();
- $partake = UserPartake::where('uid', $order['uid'])->where('status', 0)->find();
- if ($partake){
- $out = Out::where('id', $partake['out_id'])->find();
- if ($user['pay_price'] >= $out['number']){
- $user['pay_price'] -= $out['number'];
- $user['use_price'] += $out['number'];
- $user->save();
- $partake['status'] = 1;
- $partake['money'] = $out['number'];
- $partake->save();
- }
- }
- }
-
- public static function team($order)
- {
- $user = User::where('uid', $order['uid'])->find();
- $uids = getParents($user['spread_uid'],User::select());
- if ($uids){
- $v1 = 0;
- $v2 = 0;
- $city = sys_config('city')/100;
- $lianchuang = sys_config('lianchuang')/100;
- foreach ($uids as $item)
- {
- $spread = User::where('uid', $item)->find();
- if ($spread['level'] == 3){
- if ($v1 == 0){
- $jl = $order['pay_price'] * $city;
- UserBill::income('佣金', $spread['uid'], 'now_money', 'brokerage', $jl, '', $spread['brokerage_price']+$jl, '下级消费'.$order['pay_price'].'城市合伙人团队佣金');
- User::where('uid', $spread['uid'])->inc('brokerage_price', $jl)->update();
- $v1++;
- }
- }
- if ($spread['level'] == 4){
- if ($v2 == 0){
- $jl = $order['pay_price'] * $lianchuang;
- UserBill::income('佣金', $spread['uid'], 'now_money', 'brokerage', $jl, '', $spread['brokerage_price']+$jl, '下级消费'.$order['pay_price'].'联创团队佣金');
- User::where('uid', $spread['uid'])->inc('brokerage_price', $jl)->update();
- $v2++;
- }
- }
- }
- }
- }
-
- public static function proxy($order)
- {
- $address = explode(' ', $order['user_address']);
- $proxy = ProxyAddress::where(['province' => $address[0], 'city' => $address[1], 'district' => $address[2]])->select()->toArray();
- foreach ($proxy as $item)
- {
- $user = User::where('uid', $item['uid'])->find();
- if ($user['level'] == 3){
- $to_ground = sys_config('to_ground');
- $jl = $order['pay_price'] * ($to_ground/100);
- UserBill::income('佣金', $user['uid'], 'now_money', 'brokerage', $jl, '', $user['brokerage_price']+$jl, '落地奖励佣金');
- User::where('uid', $user['uid'])->inc('brokerage_price', $jl)->update();
- }
- }
- }
-
- public static function tidyOrder($order, $detail = false, $isPic = false)
- {
- if ($detail == true && isset($order['id'])) {
- $cartInfo = StoreOrderCartInfo::where('oid', $order['id'])->column('cart_info', 'unique') ?: [];
- $info = [];
- foreach ($cartInfo as $k => $cart) {
- $cart = json_decode($cart, true);
- $cart['unique'] = $k;
-
- $cart['is_reply'] = StoreProductReply::where('unique', $k)->count();
- array_push($info, $cart);
- unset($cart);
- }
- $order['cartInfo'] = $info;
- }
- $status = [];
- if (!$order['paid'] && $order['pay_type'] == 'offline' && !$order['status'] >= 2) {
- $status['_type'] = 9;
- $status['_title'] = '线下付款';
- $status['_msg'] = '商家处理中,请耐心等待';
- $status['_class'] = 'nobuy';
- } else if (!$order['paid']) {
- $status['_type'] = 0;
- $status['_title'] = '未支付';
-
- $keyValue = ['order_cancel_time', 'order_activity_time', 'order_bargain_time', 'order_seckill_time', 'order_pink_time'];
-
- $systemValue = SystemConfigService::more($keyValue);
-
- $systemValue = self::setValeTime($keyValue, is_array($systemValue) ? $systemValue : []);
- if ($order['pink_id'] || $order['combination_id']) {
- $order_pink_time = $systemValue['order_pink_time'] ? $systemValue['order_pink_time'] : $systemValue['order_activity_time'];
- $time = bcadd($order['add_time'], $order_pink_time * 3600, 0);
- $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
- } else if ($order['seckill_id']) {
- $order_seckill_time = $systemValue['order_seckill_time'] ? $systemValue['order_seckill_time'] : $systemValue['order_activity_time'];
- $time = bcadd($order['add_time'], $order_seckill_time * 3600, 0);
- $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
- } else if ($order['bargain_id']) {
- $order_bargain_time = $systemValue['order_bargain_time'] ? $systemValue['order_bargain_time'] : $systemValue['order_activity_time'];
- $time = bcadd($order['add_time'], $order_bargain_time * 3600, 0);
- $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
- } else {
- $time = bcadd($order['add_time'], $systemValue['order_cancel_time'] * 3600, 0);
- $status['_msg'] = '请在' . date('m-d H:i:s', $time) . '前完成支付!';
- }
- $status['_class'] = 'nobuy';
- } else if ($order['refund_status'] == 1) {
- $status['_type'] = -1;
- $status['_title'] = '申请退款中';
- $status['_msg'] = '商家审核中,请耐心等待';
- $status['_class'] = 'state-sqtk';
- } else if ($order['refund_status'] == 2) {
- $status['_type'] = -2;
- $status['_title'] = '已退款';
- $status['_msg'] = '已为您退款,感谢您的支持';
- $status['_class'] = 'state-sqtk';
- } else if (!$order['status']) {
- if ($order['pink_id']) {
- if (StorePink::where('id', $order['pink_id'])->where('status', 1)->count()) {
- $status['_type'] = 1;
- $status['_title'] = '拼团中';
- $status['_msg'] = '等待其他人参加拼团';
- $status['_class'] = 'state-nfh';
- } else {
- $status['_type'] = 1;
- $status['_title'] = '未发货';
- $status['_msg'] = '商家未发货,请耐心等待';
- $status['_class'] = 'state-nfh';
- }
- } else {
- if ($order['shipping_type'] === 1) {
- $status['_type'] = 1;
- $status['_title'] = '未发货';
- $status['_msg'] = '商家未发货,请耐心等待';
- $status['_class'] = 'state-nfh';
- } else {
- $status['_type'] = 1;
- $status['_title'] = '待核销';
- $status['_msg'] = '待核销,请到核销点进行核销';
- $status['_class'] = 'state-nfh';
- }
- }
- } else if ($order['status'] == 1) {
- if ($order['delivery_type'] == 'send') {
- $status['_type'] = 2;
- $status['_title'] = '待收货';
- $status['_msg'] = date('m月d日H时i分', StoreOrderStatus::getTime($order['id'], 'delivery')) . '服务商已送货';
- $status['_class'] = 'state-ysh';
- } else {
- $status['_type'] = 2;
- $status['_title'] = '待收货';
- if ($order['delivery_type'] == 'fictitious')
- $_time = StoreOrderStatus::getTime($order['id'], 'delivery_fictitious');
- else
- $_time = StoreOrderStatus::getTime($order['id'], 'delivery_goods');
- $status['_msg'] = date('m月d日H时i分', $_time) . '服务商已发货';
- $status['_class'] = 'state-ysh';
- }
- } else if ($order['status'] == 2) {
- $status['_type'] = 3;
- $status['_title'] = '待评价';
- $status['_msg'] = '已收货,快去评价一下吧';
- $status['_class'] = 'state-ypj';
- } else if ($order['status'] == 3) {
- $status['_type'] = 4;
- $status['_title'] = '交易完成';
- $status['_msg'] = '交易完成,感谢您的支持';
- $status['_class'] = 'state-ytk';
- }
- if (isset($order['pay_type']))
- $status['_payType'] = isset(self::$payType[$order['pay_type']]) ? self::$payType[$order['pay_type']] : '其他方式';
- if (isset($order['delivery_type']))
- $status['_deliveryType'] = isset(self::$deliveryType[$order['delivery_type']]) ? self::$deliveryType[$order['delivery_type']] : '其他方式';
- $order['_status'] = $status;
- $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']);
- $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']) : '';
- $order['status_pic'] = '';
-
- if ($isPic) {
- $order_details_images = sys_data('order_details_images') ?: [];
- foreach ($order_details_images as $image) {
- if (isset($image['order_status']) && $image['order_status'] == $order['_status']['_type']) {
- $order['status_pic'] = $image['pic'];
- break;
- }
- }
- }
- $order['offlinePayStatus'] = (int)sys_config('offline_pay_status') ?? (int)2;
- return $order;
- }
-
- public static function statusByWhere($status, $uid = 0, $model = null)
- {
- if ($model == null) $model = new self;
- if ('' === $status)
- return $model;
- else if ($status == 0)
- return $model->where('paid', 0)->where('status', 0)->where('refund_status', 0);
- else if ($status == 1)
- return $model->where('paid', 1)->where('status', 0)->where('refund_status', 0);
- else if ($status == 2)
- return $model->where('paid', 1)->where('status', 1)->where('refund_status', 0);
- else if ($status == 3)
- return $model->where('paid', 1)->where('status', 2)->where('refund_status', 0);
- else if ($status == 4)
- return $model->where('paid', 1)->where('status', 3)->where('refund_status', 0);
- else if ($status == -1)
- return $model->where('paid', 1)->where('refund_status', 1);
- else if ($status == -2)
- return $model->where('paid', 1)->where('refund_status', 2);
- else if ($status == -3)
- return $model->where('paid', 1)->where('refund_status', 'IN', '1,2');
- else
- return $model;
- }
-
- public static function getUserOrderList($uid, $status = '', $page = 0, $limit = 8)
- {
- if ($page) $list = self::statusByWhere($status, $uid)->where('is_del', 0)->where('uid', $uid)
- ->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')
- ->order('add_time DESC')->page((int)$page, (int)$limit)->select()->toArray();
- else $list = self::statusByWhere($status, $uid)->where('is_del', 0)->where('uid', $uid)
- ->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')
- ->order('add_time DESC')->page((int)$page, (int)$limit)->select()->toArray();
- foreach ($list as $k => $order) {
- $list[$k] = self::tidyOrder($order, true);
- }
- return $list;
- }
-
- public static function getUserOrderCount($uid = '', $status = '')
- {
- $res = self::statusByWhere($status, $uid)->where('uid', 'IN', $uid)->column('pay_price');
- return $res;
- }
-
- public static function searchUserOrder($uid, $order_id)
- {
- $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')
- ->order('add_time DESC')->find();
- if (!$order)
- return false;
- else
- return self::tidyOrder($order->toArray(), true);
- }
-
- public static function orderOver($oid)
- {
- $res = self::edit(['status' => '3'], $oid, 'id');
- if (!$res) exception('评价后置操作失败!');
- return StoreOrderStatus::status($oid, 'check_order_over', '用户评价');
- }
-
- public static function checkOrderOver($oid)
- {
- $uniqueList = StoreOrderCartInfo::where('oid', $oid)->column('unique', 'unique');
-
- if (StoreProductReply::where('unique', 'IN', $uniqueList)->where('oid', $oid)->count() == count($uniqueList)) {
- event('StoreProductOrderOver', [$oid]);
- return self::orderOver($oid);
- }
- }
- public static function getOrderStatusNum($uid)
- {
- $noBuy = (int)self::where('uid', $uid)->where('paid', 0)->where('is_del', 0)->where('pay_type', '<>', 'offline')->count();
- $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();
- $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();
- $noPostage = (int)bcadd($noPostageNoPink, $noPostageYesPink, 0);
- $noTake = (int)self::where('uid', $uid)->where('paid', 1)->where('is_del', 0)->where('status', 1)->where('pay_type', '<>', 'offline')->count();
- $noReply = (int)self::where('uid', $uid)->where('paid', 1)->where('is_del', 0)->where('status', 2)->count();
- $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();
- $noRefund = (int)self::where('uid', $uid)->where('paid', 1)->where('is_del', 0)->where('refund_status', 'IN', '1,2')->count();
- return compact('noBuy', 'noPostage', 'noTake', 'noReply', 'noPink', 'noRefund');
- }
-
- public static function gainUserIntegral($order)
- {
- if ($order['gain_integral'] > 0) {
- $userInfo = User::getUserInfo($order['uid']);
- BaseModel::beginTrans();
- $res1 = false != User::where('uid', $userInfo['uid'])->update(['integral' => bcadd($userInfo['integral'], $order['gain_integral'], 2)]);
- $res2 = false != UserBill::income('购买商品赠送积分', $order['uid'], 'integral', 'gain', $order['gain_integral'], $order['id'], $userInfo['integral'], '购买商品赠送' . floatval($order['gain_integral']) . '积分');
- $res = $res1 && $res2;
- BaseModel::checkTrans($res);
- return $res;
- }
- return true;
- }
-
- public static function getIsOrderPink($pid = 0, $uid = 0)
- {
- return self::where('uid', $uid)->where('pink_id', $pid)->where('refund_status', 0)->where('is_del', 0)->count();
- }
-
- public static function getStoreIdPink($pid = 0, $uid = 0)
- {
- return self::where('uid', $uid)->where('pink_id', $pid)->where('is_del', 0)->value('order_id');
- }
-
- public static function delCombination()
- {
- self::where('combination', '>', 0)->where('paid', 0)->where('uid', User::getActiveUid())->delete();
- }
- public static function getUserPrice($uid = 0)
- {
- if (!$uid) return 0;
- $price = self::where('paid', 1)->where('uid', $uid)->where('status', 2)->where('refund_status', 0)->column('pay_price', 'id');
- $count = 0;
- if ($price) {
- foreach ($price as $v) {
- $count = bcadd($count, $v, 2);
- }
- }
- return $count;
- }
-
- public static function getUserOrderSearchList($uid, $type, $page, $limit, $search)
- {
- if ($search) {
- $order = self::searchUserOrder($uid, $search) ?: [];
- $list = $order == false ? [] : [$order];
- } else {
- $list = self::getUserOrderList($uid, $type, $page, $limit);
- }
- foreach ($list as $k => $order) {
- $list[$k] = self::tidyOrder($order, true);
- if ($list[$k]['_status']['_type'] == 3) {
- foreach ($order['cartInfo'] ?: [] as $key => $product) {
- $list[$k]['cartInfo'][$key]['is_reply'] = StoreProductReply::isReply($product['unique'], 'product');
- $list[$k]['cartInfo'][$key]['add_time'] = isset($product['add_time']) ? date('Y-m-d H:i', $product['add_time']) : '时间错误';
- }
- }
- }
- return $list;
- }
-
- public static function getSubordinateOrderlist($xUid, $uid, $type, $first, $limit)
- {
- $list = [];
- if (!$xUid) {
- $arr = User::getOneSpreadUid($uid);
- foreach ($arr as $v) $list = StoreOrder::getUserOrderList($v, $type, $first, $limit);
- } else $list = self::getUserOrderList($xUid, $type, $first, $limit);
- foreach ($list as $k => $order) {
- $list[$k] = self::tidyOrder($order, true);
- if ($list[$k]['_status']['_type'] == 3) {
- foreach ($order['cartInfo'] ?: [] as $key => $product) {
- $list[$k]['cartInfo'][$key]['is_reply'] = StoreProductReply::isReply($product['unique'], 'product');
- }
- }
- }
- return $list;
- }
-
- public static function getOrderTimeData()
- {
- $to_day = strtotime(date('Y-m-d'));
- $pre_day = strtotime(date('Y-m-d', strtotime('-1 day')));
- $now_month = strtotime(date('Y-m'));
-
- $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;
-
- $data['todayCount'] = self::where('is_del', 0)->where('pay_time', '>=', $to_day)->where('paid', 1)->where('refund_status', 0)->count();
-
- $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;
-
- $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();
-
- $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;
-
- $data['monthCount'] = self::where('is_del', 0)->where('pay_time', '>=', $now_month)->where('paid', 1)->where('refund_status', 0)->count();
- return $data;
- }
-
- public static function getOrderData($uid)
- {
-
- $data['order_count'] = self::where('is_del', 0)->where('paid', 1)->where('uid', $uid)->where('refund_status', 0)->count();
-
- $data['sum_price'] = self::where('is_del', 0)->where('paid', 1)->where('uid', $uid)->where('refund_status', 0)->sum('pay_price');
-
- $data['unpaid_count'] = self::statusByWhere(0, $uid)->where('is_del', 0)->where('uid', $uid)->count();
-
- $data['unshipped_count'] = self::statusByWhere(1, $uid)->where('is_del', 0)->where('uid', $uid)->count();
-
- $data['received_count'] = self::statusByWhere(2, $uid)->where('is_del', 0)->where('uid', $uid)->count();
-
- $data['evaluated_count'] = self::statusByWhere(3, $uid)->where('is_del', 0)->where('uid', $uid)->count();
-
- $data['complete_count'] = self::statusByWhere(4, $uid)->where('is_del', 0)->where('uid', $uid)->count();
-
- $data['refund_count'] = self::statusByWhere(-1, $uid)->where('is_del', 0)->where('uid', $uid)->count();
- return $data;
- }
-
- public static function getOrderDataAdmin()
- {
-
- $data['order_count'] = self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->count();
-
- $data['sum_price'] = self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->sum('pay_price');
-
- $data['unpaid_count'] = self::statusByWhere(0, 0)->where('is_del', 0)->count();
-
- $data['unshipped_count'] = self::statusByWhere(1, 0)->where('is_del', 0)->count();
-
- $data['received_count'] = self::statusByWhere(2, 0)->where('is_del', 0)->count();
-
- $data['evaluated_count'] = self::statusByWhere(3, 0)->where('is_del', 0)->count();
-
- $data['complete_count'] = self::statusByWhere(4, 0)->where('is_del', 0)->count();
-
- $data['refund_count'] = self::statusByWhere(-3, 0)->where('is_del', 0)->count();
- return $data;
- }
-
- public static function getOrderStatusSum($uid)
- {
- return self::where('uid', $uid)->where('is_del', 0)->where('paid', 1)->sum('pay_price');
- }
- public static function getPinkOrderId($id)
- {
- return self::where('id', $id)->value('order_id');
- }
-
- public static function orderUnpaidCancel()
- {
-
- $keyValue = ['order_cancel_time', 'order_activity_time', 'order_bargain_time', 'order_seckill_time', 'order_pink_time'];
-
- $systemValue = SystemConfigService::more($keyValue);
-
- $systemValue = self::setValeTime($keyValue, is_array($systemValue) ? $systemValue : []);
-
- $unPidCount = self::where('paid', 0)->where('pay_type', '<>', 'offline')->where('is_del', 0)->where('status', 0)->where('refund_status', 0)->count();
- if (!$unPidCount) return null;
- try {
- $res = true;
-
- $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();
- foreach ($orderList as $order) {
- if ($order['seckill_id']) {
-
- $order_seckill_time = $systemValue['order_seckill_time'] ? $systemValue['order_seckill_time'] : $systemValue['order_activity_time'];
- $res = $res && self::RegressionAll($order_seckill_time, $order);
- unset($order_seckill_time);
- } else if ($order['bargain_id']) {
- $order_bargain_time = $systemValue['order_bargain_time'] ? $systemValue['order_bargain_time'] : $systemValue['order_activity_time'];
- $res = $res && self::RegressionAll($order_bargain_time, $order);
- unset($order_bargain_time);
- } else if ($order['pink_id'] || $order['combination_id']) {
- $order_pink_time = $systemValue['order_pink_time'] ? $systemValue['order_pink_time'] : $systemValue['order_activity_time'];
- $res = $res && self::RegressionAll($order_pink_time, $order);
- unset($order_pink_time);
- } else {
- $res = $res && self::RegressionAll($systemValue['order_cancel_time'], $order);
- }
- }
- if (!$res) throw new \Exception('更新错误');
- unset($orderList, $res, $pages);
- return null;
- } catch (PDOException $e) {
- Log::error('未支付自动取消时发生数据库查询错误,错误原因为:' . $e->getMessage());
- throw new \Exception($e->getMessage());
- } catch (\think\Exception $e) {
- Log::error('未支付自动取消时发生系统错误,错误原因为:' . $e->getMessage());
- throw new \Exception($e->getMessage());
- }
- }
-
- protected static function RegressionAll($time, $order)
- {
- if ($time == 0) return true;
- if (($order['add_time'] + bcmul($time, 3600, 0)) < time()) {
- $res1 = self::RegressionStock($order);
- $res2 = self::RegressionIntegral($order);
- $res3 = self::RegressionCoupon($order);
- $res = $res1 && $res2 && $res3;
- if ($res) $res = false !== self::where('order_id', $order['order_id'])->update(['is_del' => 1, 'mark' => '订单未支付已超过系统预设时间']);
- unset($res1, $res2, $res3);
- return $res;
- } else
- return true;
- }
-
- protected static function setValeTime(array $array, $value, $default = 0)
- {
- foreach ($array as $item) {
- if (!isset($value[$item]))
- $value[$item] = $default;
- else if (is_string($value[$item]))
- $value[$item] = (float)$value[$item];
- }
- return $value;
- }
- public static function getOrderTotalPrice($cartInfo)
- {
- $totalPrice = 0;
- foreach ($cartInfo as $cart) {
- $totalPrice = bcadd($totalPrice, bcmul($cart['cart_num'], $cart['truePrice'], 2), 2);
- }
- return $totalPrice;
- }
- public static function getOrderCostPrice($cartInfo)
- {
- $costPrice = 0;
- foreach ($cartInfo as $cart) {
- $costPrice = bcadd($costPrice, bcmul($cart['cart_num'], $cart['costPrice'], 2), 2);
- }
- return $costPrice;
- }
- public static function getCombinationOrderCostPrice($cartInfo)
- {
- $costPrice = 0;
- foreach ($cartInfo as $cart) {
- if ($cart['combination_id']) {
- $costPrice = bcadd($costPrice, bcmul($cart['cart_num'], StoreCombination::where('id', $cart['combination_id'])->value('price'), 2), 2);
- }
- }
- return (float)$costPrice;
- }
- public static function yueRefundAfter($order)
- {
- }
-
- public static function getOrderStatusYueSum($uid)
- {
- return self::where('uid', $uid)->where('is_del', 0)->where('is_del', 0)->where('pay_type', 'yue')->where('paid', 1)->sum('pay_price');
- }
-
- public static function getBargainPayCount($bargain)
- {
- return self::where('bargain_id', $bargain)->where(['paid' => 1, 'refund_status' => 0])->count();
- }
-
- public static function startTakeOrder()
- {
-
- $systemDeliveryTime = SystemConfigService::get('system_delivery_time') ?? 0;
-
- if ($systemDeliveryTime == 0) return true;
- $sevenDay = strtotime(date('Y-m-d H:i:s', strtotime('-' . $systemDeliveryTime . ' day')));
- $model = new self;
- $model = $model->alias('o');
- $model = $model->join('StoreOrderStatus s', 's.oid=o.id');
- $model = $model->where('o.paid', 1);
- $model = $model->where('s.change_type', 'delivery_goods');
- $model = $model->where('s.change_time', '<', $sevenDay);
- $model = $model->where('o.status', 1);
- $model = $model->where('o.refund_status', 0);
- $model = $model->where('o.is_del', 0);
- $orderInfo = $model->column('id', 'id');
- if (!count($orderInfo)) return true;
- $res = true;
- foreach ($orderInfo as $key => &$item) {
- $order = self::get($item);
- if ($order['status'] == 2) continue;
- if ($order['paid'] == 1 && $order['status'] == 1) $data['status'] = 2;
- else if ($order['pay_type'] == 'offline') $data['status'] = 2;
- else continue;
- if (!self::edit($data, $item, 'id')) continue;
- try {
- OrderRepository::storeProductOrderTakeDeliveryAdmin($order, $item);
- $res = $res && true;
- } catch (\Exception $e) {
- $res = $res && false;
- }
- $res = $res && StoreOrderStatus::status($item, 'take_delivery', '已收货[自动收货]');
- }
- if (!$res) {
- throw new \Exception('');
- }
- }
-
- public static function getOrderInfo($id, $field = 'order_id')
- {
- return self::where('id', $id)->field($field)->find();
- }
-
- public static function getOrderDataPriceCount($page, $limit, $start, $stop)
- {
- if (!$limit) return [];
- $model = new self;
- if ($start != '' && $stop != '') $model = $model->where('pay_time', '>', $start)->where('pay_time', '<=', $stop);
- $model = $model->field('sum(pay_price) as price,count(id) as count,FROM_UNIXTIME(pay_time, \'%m-%d\') as time');
- $model = $model->where('is_del', 0);
- $model = $model->where('paid', 1);
- $model = $model->where('refund_status', 0);
- $model = $model->group("FROM_UNIXTIME(pay_time, '%Y-%m-%d')");
- $model = $model->order('pay_time DESC');
- if ($page) $model = $model->page($page, $limit);
- return $model->select();
- }
-
- public static function orderList($where)
- {
- $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');
- if ($where['order'] != '') {
- $model = $model->order(self::setOrder($where['order']));
- } else {
- $model = $model->order('a.id desc');
- }
- $data = ($data = $model->page((int)$where['page'], (int)$where['limit'])->select()) && count($data) ? $data->toArray() : [];
- return self::tidyAdminOrder($data);
- }
-
- public static function tidyAdminOrder($data, $status = false)
- {
- foreach ($data as &$item) {
- $_info = StoreOrderCartInfo::where('oid', $item['id'])->field('cart_info')->select()->toArray();
- foreach ($_info as $k => $v) {
- if (!is_array($v['cart_info']))
- $_info[$k]['cart_info'] = json_decode($v['cart_info'], true);
- }
- foreach ($_info as $k => $v) {
- 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']);
- $_info[$k]['cart_info']['productInfo']['suk'] = '';
- if (isset($v['cart_info']['productInfo']['attrInfo'])) {
- $_info[$k]['cart_info']['productInfo']['image'] = $_info[$k]['cart_info']['productInfo']['attrInfo']['image'];
- $_info[$k]['cart_info']['productInfo']['price'] = $_info[$k]['cart_info']['productInfo']['attrInfo']['price'];
- $_info[$k]['cart_info']['productInfo']['suk'] = $_info[$k]['cart_info']['productInfo']['attrInfo']['suk'];
- unset($_info[$k]['cart_info']['productInfo']['attrInfo']);
- }
- if (!isset($v['cart_info']['productInfo']['ot_price'])) {
- $_info[$k]['cart_info']['productInfo']['ot_price'] = $v['cart_info']['productInfo']['price'];
- }
- }
- $item['_info'] = $_info;
- $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
- if ($status) {
- $status = [];
- if (!$item['paid'] && $item['pay_type'] == 'offline' && !$item['status'] >= 2) {
- $status['_type'] = 9;
- $status['_title'] = '线下付款';
- $status['_msg'] = '商家处理中,请耐心等待';
- $status['_class'] = 'nobuy';
- } else if (!$item['paid']) {
- $status['_type'] = 0;
- $status['_title'] = '未支付';
-
- $keyValue = ['order_cancel_time', 'order_activity_time', 'order_bargain_time', 'order_seckill_time', 'order_pink_time'];
-
- $systemValue = SystemConfigService::more($keyValue);
-
- $systemValue = self::setValeTime($keyValue, is_array($systemValue) ? $systemValue : []);
- if ($item['pink_id'] || $item['combination_id']) {
- $order_pink_time = $systemValue['order_pink_time'] ? $systemValue['order_pink_time'] : $systemValue['order_activity_time'];
- $time = bcadd($item['add_time'], $order_pink_time * 3600, 0);
- $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
- } else if ($item['seckill_id']) {
- $order_seckill_time = $systemValue['order_seckill_time'] ? $systemValue['order_seckill_time'] : $systemValue['order_activity_time'];
- $time = bcadd($item['add_time'], $order_seckill_time * 3600, 0);
- $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
- } else if ($item['bargain_id']) {
- $order_bargain_time = $systemValue['order_bargain_time'] ? $systemValue['order_bargain_time'] : $systemValue['order_activity_time'];
- $time = bcadd($item['add_time'], $order_bargain_time * 3600, 0);
- $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
- } else {
- $time = bcadd($item['add_time'], $systemValue['order_cancel_time'] * 3600, 0);
- $status['_msg'] = '请在' . date('Y-m-d H:i:s', $time) . '前完成支付!';
- }
- $status['_class'] = 'nobuy';
- } else if ($item['refund_status'] == 1) {
- $status['_type'] = -1;
- $status['_title'] = '申请退款中';
- $status['_msg'] = '商家审核中,请耐心等待';
- $status['_class'] = 'state-sqtk';
- } else if ($item['refund_status'] == 2) {
- $status['_type'] = -2;
- $status['_title'] = '已退款';
- $status['_msg'] = '已为您退款,感谢您的支持';
- $status['_class'] = 'state-sqtk';
- } else if (!$item['status']) {
- if ($item['pink_id']) {
- if (StorePink::where('id', $item['pink_id'])->where('status', 1)->count()) {
- $status['_type'] = 11;
- $status['_title'] = '拼团中';
- $status['_msg'] = '等待其他人参加拼团';
- $status['_class'] = 'state-nfh';
- } else {
- $status['_type'] = 1;
- $status['_title'] = '未发货';
- $status['_msg'] = '商家未发货,请耐心等待';
- $status['_class'] = 'state-nfh';
- }
- } else {
- $status['_type'] = 1;
- $status['_title'] = '未发货';
- $status['_msg'] = '商家未发货,请耐心等待';
- $status['_class'] = 'state-nfh';
- }
- } else if ($item['status'] == 1) {
- if ($item['delivery_type'] == 'send') {
- $status['_type'] = 2;
- $status['_title'] = '待收货';
- $status['_msg'] = date('m月d日H时i分', StoreOrderStatus::getTime($item['id'], 'delivery')) . '服务商已送货';
- $status['_class'] = 'state-ysh';
- } else {
- $status['_type'] = 2;
- $status['_title'] = '待收货';
- $status['_msg'] = date('m月d日H时i分', StoreOrderStatus::getTime($item['id'], 'delivery_goods')) . '服务商已发货';
- $status['_class'] = 'state-ysh';
- }
- } else if ($item['status'] == 2) {
- $status['_type'] = 3;
- $status['_title'] = '待评价';
- $status['_msg'] = '已收货,快去评价一下吧';
- $status['_class'] = 'state-ypj';
- } else if ($item['status'] == 3) {
- $status['_type'] = 4;
- $status['_title'] = '交易完成';
- $status['_msg'] = '交易完成,感谢您的支持';
- $status['_class'] = 'state-ytk';
- }
- if (isset($item['pay_type']))
- $status['_payType'] = isset(self::$payType[$item['pay_type']]) ? self::$payType[$item['pay_type']] : '其他方式';
- if (isset($item['delivery_type']))
- $status['_deliveryType'] = isset(self::$deliveryType[$item['delivery_type']]) ? self::$deliveryType[$item['delivery_type']] : '其他方式';
- $item['_status'] = $status;
- } else {
- if ($item['paid'] == 0 && $item['status'] == 0) {
- $item['status_name'] = '未支付';
- } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0) {
- $item['status_name'] = '未发货';
- } else if ($item['paid'] == 1 && $item['status'] == 1 && $item['refund_status'] == 0) {
- $item['status_name'] = '待收货';
- } else if ($item['paid'] == 1 && $item['status'] == 2 && $item['refund_status'] == 0) {
- $item['status_name'] = '待评价';
- } else if ($item['paid'] == 1 && $item['status'] == 3 && $item['refund_status'] == 0) {
- $item['status_name'] = '已完成';
- }
- }
- }
- return $data;
- }
-
- public static function getOrderWhere($where, $model, $aler = '', $join = '')
- {
- if (isset($where['status']) && $where['status'] != '') $model = self::statusWhere($where['status'], $model, $aler);
- if (isset($where['is_del']) && $where['is_del'] != '' && $where['is_del'] != -1) $model = $model->where($aler . 'is_del', $where['is_del']);
- if (isset($where['combination_id'])) {
- if ($where['combination_id'] == '普通订单') {
- $model = $model->where($aler . 'combination_id', 0)->where($aler . 'seckill_id', 0)->where($aler . 'bargain_id', 0);
- }
- if ($where['combination_id'] == '拼团订单') {
- $model = $model->where($aler . 'combination_id', ">", 0)->where($aler . 'pink_id', ">", 0);
- }
- if ($where['combination_id'] == '秒杀订单') {
- $model = $model->where($aler . 'seckill_id', ">", 0);
- }
- if ($where['combination_id'] == '砍价订单') {
- $model = $model->where($aler . 'bargain_id', ">", 0);
- }
- }
- if (isset($where['type'])) {
- switch ($where['type']) {
- case 1:
- $model = $model->where($aler . 'combination_id', 0)->where($aler . 'seckill_id', 0)->where($aler . 'bargain_id', 0);
- break;
- case 2:
- $model = $model->where($aler . 'combination_id', ">", 0);
- break;
- case 3:
- $model = $model->where($aler . 'seckill_id', ">", 0);
- break;
- case 4:
- $model = $model->where($aler . 'bargain_id', ">", 0);
- break;
- }
- }
- if (isset($where['real_name']) && $where['real_name'] != '')
- $model = $model->where($aler . 'order_id|' . $aler . 'real_name|' . $aler . 'user_phone' . ($join ? '|' . $join . '.nickname|' . $join . '.uid' : ''), 'LIKE', "%$where[real_name]%");
- if (isset($where['data']) && $where['data'] !== '')
- $model = self::getModelTime($where, $model, $aler . 'add_time');
- return $model;
- }
-
- public static function statusWhere($status, $model = null, $alert = '')
- {
- if ($model == null) $model = new self;
- if ('' === $status)
- return $model;
- else if ($status == 0)
- return $model->where($alert . 'paid', 0)->where($alert . 'status', 0)->where($alert . 'refund_status', 0);
- else if ($status == 1)
- return $model->where($alert . 'paid', 1)->where($alert . 'status', 0)->where($alert . 'refund_status', 0);
- else if ($status == 2)
- return $model->where($alert . 'paid', 1)->where($alert . 'status', 1)->where($alert . 'refund_status', 0);
- else if ($status == 3)
- return $model->where($alert . 'paid', 1)->where($alert . 'status', 2)->where($alert . 'refund_status', 0);
- else if ($status == 4)
- return $model->where($alert . 'paid', 1)->where($alert . 'status', 3)->where($alert . 'refund_status', 0);
- else if ($status == -1)
- return $model->where($alert . 'paid', 1)->where($alert . 'refund_status', 1);
- else if ($status == -2)
- return $model->where($alert . 'paid', 1)->where($alert . 'refund_status', 2);
- else if ($status == -3)
- return $model->where($alert . 'paid', 1)->where($alert . 'refund_status', 'in', '1,2');
- else
- return $model;
- }
-
- public static function getAdminOrderDetail($orderId, $field = '*')
- {
- return self::where('order_id', $orderId)->field($field)->find();
- }
-
- public static function getOrderTimeBusinessVolumePrice($start, $stop)
- {
- return self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->where('add_time', '>=', $start)->where('add_time', '<', $stop)->sum('pay_price');
- }
-
- public static function getOrderTimeBusinessVolumeNumber($start, $stop)
- {
- return self::where('is_del', 0)->where('paid', 1)->where('refund_status', 0)->where('add_time', '>=', $start)->where('add_time', '<', $stop)->count();
- }
-
- public static function chartTimePrice($start, $stop)
- {
- $model = new self;
- $model = $model->field('sum(pay_price) as num,FROM_UNIXTIME(add_time, \'%Y-%m-%d\') as time');
- $model = $model->where('is_del', 0);
- $model = $model->where('paid', 1);
- $model = $model->where('refund_status', 0);
- $model = $model->where('add_time', '>=', $start);
- $model = $model->where('add_time', '<', $stop);
- $model = $model->group("FROM_UNIXTIME(add_time, '%Y-%m-%d')");
- $model = $model->order('add_time ASC');
- return $model->select();
- }
-
- public static function chartTimeNumber($start, $stop)
- {
- $model = new self;
- $model = $model->field('count(id) as num,FROM_UNIXTIME(add_time, \'%Y-%m-%d\') as time');
- $model = $model->where('is_del', 0);
- $model = $model->where('paid', 1);
- $model = $model->where('refund_status', 0);
- $model = $model->where('add_time', '>=', $start);
- $model = $model->where('add_time', '<', $stop);
- $model = $model->group("FROM_UNIXTIME(add_time, '%Y-%m-%d')");
- $model = $model->order('add_time ASC');
- return $model->select();
- }
-
- public static function setOrderTypePayOffline($orderId)
- {
- return self::edit(['pay_type' => 'offline'], $orderId, 'order_id');
- }
-
- public static function updateOffline($id)
- {
- $count = self::where('id', $id)->count();
- if (!$count) return self::setErrorInfo('订单不存在');
- $count = self::where('id', $id)->where('paid', 0)->count();
- if (!$count) return self::setErrorInfo('订单已支付');
- $res = self::where('id', $id)->update(['paid' => 1, 'pay_time' => time()]);
- return $res;
- }
-
- public static function sendTen()
- {
- $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');
- foreach ($list as $phone) {
- ShortLetterRepositories::send(true, $phone, [], 'ORDER_PAY_FALSE');
- }
- }
- public function productInfo()
- {
- return $this->hasMany(StoreProductReply::class, 'oid', 'id');
- }
- public static function setOrderProductReplyWhere($where)
- {
- $model = self::where('status', 3)->order('add_time desc')->whereIn('id', function ($query) {
- $query->name('store_order')->alias('o')->join('store_product_reply a', 'a.oid = o.id')->group('o.id')->field('o.id')->select();
- })->with('productInfo', function ($query) use ($where) {
- $alias = '';
- if (isset($where['title']) && $where['title'] != '')
- $query->where("{$alias}comment", 'LIKE', "%$where[title]%");
- if (isset($where['is_reply']) && $where['is_reply'] != '') {
- if ($where['is_reply'] >= 0) {
- $query->where("{$alias}is_reply", $where['is_reply']);
- } else {
- $query->where("{$alias}is_reply", '>', 0);
- }
- }
- if (isset($where['producr_id']) && $where['producr_id'] != 0)
- $query->where($alias . 'product_id', $where['producr_id']);
- $query->where("{$alias}is_del", 0);
- });
- return $model;
- }
- public static function getOrderProductReplyList($where)
- {
- $list = self::setOrderProductReplyWhere($where)->page((int)$where['message_page'], (int)$where['limit'])->select();
- $list = count($list) ? $list->toArray() : [];
- foreach ($list as $key => $item) {
- if (isset($item['productInfo']) && is_array($item['productInfo']) && count($item['productInfo'])) {
- foreach ($item['productInfo'] as $k => $v) {
- if (!$v['nickname'] && $v['uid']) {
- $v['nickname'] = User::where('uid', $v['uid'])->value('nickname');
- $v['avatar'] = User::where('uid', $v['uid'])->value('avatar');
- }
- $v['image'] = '';
- $v['store_name'] = '';
- if ($v['product_id']) {
- $product = StoreProduct::where('id', $v['product_id'])->field(['image', 'store_name'])->find();
- if ($product) {
- $v['image'] = $product['image'];
- $v['store_name'] = $product['store_name'];
- }
- }
- $list[$key]['productInfo'][$k] = $v;
- }
- }
- }
- $count = self::setOrderProductReplyWhere($where)->count();
- return compact('list', 'count');
- }
- }
|