OrderUtil.php 153 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255
  1. <?php
  2. /**
  3. * 重庆赤晓店信息科技有限公司
  4. * https://www.chixiaodian.com
  5. * Copyright (c) 2023 赤店商城 All rights reserved.
  6. */
  7. namespace app\utils;
  8. use app\models\Cash;
  9. use app\models\FreeQueue;
  10. use app\models\Order;
  11. use app\constants\OptionSetting;
  12. use app\models\AgentGoodsBindGoods;
  13. use app\models\AgentGoodsInstallLog;
  14. use app\models\QueueAccountLog;
  15. use app\models\QueueLog;
  16. use app\models\SaaSLeaguePriceLog;
  17. use app\models\PtActivity;
  18. use app\models\PtActivityOrder;
  19. use app\models\PtActivityOrderDetail;
  20. use app\models\SaasUserPriceLog;
  21. use app\models\AccountLog;
  22. use app\models\Admin;
  23. use app\models\Coupon;
  24. use app\models\DeliveryInfo;
  25. use app\models\Goods;
  26. use app\models\Level;
  27. use app\models\LocalDeliveryCourier;
  28. use app\models\LocalDeliveryLog;
  29. use app\models\Md;
  30. use app\models\MdProfit;
  31. use app\models\MerchantInfo;
  32. use app\models\Option;
  33. use app\models\OrderDetail;
  34. use app\models\OrderRefund;
  35. use app\models\ReOrder;
  36. use app\models\SaasStoreReferral;
  37. use app\models\SaasUser;
  38. use app\models\Salesman;
  39. use app\models\SeckillActivityGoods;
  40. use app\models\SeckillActivityOrderLog;
  41. use app\models\Share;
  42. use app\models\ShareHolder;
  43. use app\models\ShareHolderLevel;
  44. use app\models\ShareLevel;
  45. use app\models\ShareLevelLog;
  46. use app\models\SharingReceiver;
  47. use app\models\Shop;
  48. use app\models\ShopShare;
  49. use app\models\Store;
  50. use app\models\StoreCash;
  51. use app\models\StoreMini;
  52. use app\models\StoreShareMoney;
  53. use app\models\Supplier;
  54. use app\models\User;
  55. use app\models\UserBindLog;
  56. use app\models\UserCoupon;
  57. use app\models\UserGrowthValueLog;
  58. use app\models\UserShareLog;
  59. use app\models\UserShareMoney;
  60. use app\models\MchSetting;
  61. use app\models\VideoGoodsShare;
  62. use app\models\VideoShopOrderExt;
  63. use app\models\WechatConfig;
  64. use app\models\Worker;
  65. use app\models\WorkerLevel;
  66. use app\models\WorkerOrderExt;
  67. use app\modules\admin\models\pt\PtActivityOrderForm;
  68. use app\modules\admin\models\VideoShopForm;
  69. use app\modules\admin\models\VideoShopOrderForm;
  70. use app\plugins\adopt\models\AdoptCostOrder;
  71. use app\plugins\adopt\models\AdoptOrderInfo;
  72. use app\plugins\adopt\models\AdoptSetting;
  73. use app\plugins\food\models\FoodOrder;
  74. use app\utils\Alipay\AlipayProfit;
  75. use app\utils\Alipay\AlipayUnion;
  76. use app\utils\Notice\NoticeSend;
  77. use app\utils\Share\BonusPool;
  78. use app\utils\Wechat\Wechat;
  79. use app\utils\Wechat\WechatMini;
  80. use app\utils\Wechat\WechatShare;
  81. use app\utils\WechatMerchant\Merchant;
  82. use app\utils\yunst\src\OrderYunst;
  83. use Think\Exception;
  84. use yii\base\BaseObject;
  85. use yii\helpers\Json;
  86. use yii\base\Event;
  87. use yii\db\Expression;
  88. use app\utils\Wechat\B2b\B2bPay;
  89. use app\utils\Adapay\Adapay;
  90. // 订单工具类
  91. class OrderUtil
  92. {
  93. // 订单是否已取消
  94. public static function isCancel($order)
  95. {
  96. return $order->trade_status == Order::ORDER_FLOW_CANCEL;
  97. }
  98. // 订单是否已确认收货
  99. public static function isConfirm($order)
  100. {
  101. return $order->trade_status == Order::ORDER_FLOW_CONFIRM;
  102. }
  103. // 订单是否已发货
  104. public static function isSend($order)
  105. {
  106. return $order->trade_status == Order::ORDER_FLOW_SEND;
  107. }
  108. // 订单是否已售后
  109. public static function isAfterSale($order)
  110. {
  111. return $order->is_sale == 1;
  112. }
  113. // 获取系统配置的订单未支付自动取消时间
  114. public static function getAutoCancelTime($store_id)
  115. {
  116. $name = \app\constants\OptionSetting::STORE_OVER_DAY;
  117. $data = \app\models\Option::get($name, $store_id, 'store', 0)['value'];
  118. if ($data > 0) {
  119. return $data * 86400;
  120. }
  121. return 0;
  122. }
  123. //分账 订单分账失败重新分账
  124. public function profitSharing($order, $store_id)
  125. {
  126. $order_id_arr = [];
  127. try {
  128. $SharingReceiver = SharingReceiver::find()->where(['is_pay' => SharingReceiver::PAY_WAIT])->andWhere(['store_id' => $store_id, 'order_no' => $order->order_no])->groupBy('order_no')->asArray()->all();
  129. foreach ($SharingReceiver as $item) {
  130. if ($item['execute_type'] == SharingReceiver::EXECUTE_TYPE_NORMAL) {
  131. // 微信
  132. try {
  133. $order_id_arr = $this->wechatProfitSharing($order);
  134. } catch (\Exception $e) {
  135. \Yii::warning('---- COUPON BEHAVIOR END微信分账失败 ----');
  136. }
  137. }
  138. if ($item['execute_type'] == SharingReceiver::EXECUTE_TYPE_ALIPAY) {
  139. // 支付宝
  140. try {
  141. $this->alipayProfitSharing($order, $order_id_arr);
  142. } catch (\Exception $e) {
  143. \Yii::warning('---- COUPON BEHAVIOR END支付宝分账失败 ----');
  144. }
  145. }
  146. }
  147. } catch (\Exception $e) {
  148. \Yii::warning('---- COUPON BEHAVIOR END ----');
  149. }
  150. return $order_id_arr;
  151. }
  152. /**
  153. * 分账
  154. * @param Order | \app\plugins\scanCodePay\models\Order | ReOrder | FoodOrder $order
  155. * @throws \EasyWeChat\Kernel\Exceptions\InvalidArgumentException
  156. * @throws \EasyWeChat\Kernel\Exceptions\InvalidConfigException
  157. * @throws \GuzzleHttp\Exception\GuzzleException
  158. */
  159. public function wechatProfitSharing($order) {
  160. if (!\Yii::$app->isSaas()) {
  161. return;
  162. }
  163. if (!$order) {
  164. \Yii::error('<=======================> 微信分账订单不存在');
  165. return;
  166. }
  167. if(in_array($order->pay_type, [Order::PAY_TYPE_WX_B2B])){
  168. return $this->b2bProfitSharing($order);
  169. }
  170. if(in_array($order->pay_type, [Order::PAY_TYPE_ADAPAY_WX, Order::PAY_TYPE_ADAPAY_ALIPAY])){
  171. return $this->adapayProfitSharing($order);
  172. }
  173. if(in_array($order->pay_type, [Order::PAY_TYPE_YUNST_WECHAT_PAY, Order::PAY_TYPE_YUNST_ALI_PAY])){
  174. //通联支付分账
  175. return $this->yunstProfitSharing($order);
  176. }
  177. // 此方法目前为多次分账,故分账结束后,剩余金额需要主动完结分账去触发解冻资金
  178. $order_id = $order->order_no;
  179. $receivers_share = SharingReceiver::find()->where(['store_id' => $order->store_id,
  180. 'transaction_id' => $order->transaction_id, 'is_pay' => SharingReceiver::PAY_WAIT, 'execute_type' => SharingReceiver::EXECUTE_TYPE_NORMAL])
  181. ->asArray()->all();
  182. $profitOrderId = 0;
  183. $receivers_share_ok = SharingReceiver::find()->where(['store_id' => $order->store_id,
  184. 'transaction_id' => $order->transaction_id, 'is_pay' => SharingReceiver::PAY_SUCCESS, 'execute_type' => SharingReceiver::EXECUTE_TYPE_NORMAL])
  185. ->orderBy('id DESC')->asArray()->one();
  186. $receivers_share_ok && $profitOrderId = $receivers_share_ok['order_id'];
  187. $cacheKey = 'wechatProfitSharing11:' . $order->transaction_id;
  188. if(\Yii::$app->cache->get($cacheKey)){
  189. \Yii::error('<=======================> 微信分账进程已存在');
  190. return;
  191. }
  192. \Yii::$app->cache->set($cacheKey, 1, 160);
  193. $order_id_arr = [];
  194. foreach($receivers_share as $receivers_share1){
  195. sleep(1);
  196. //检测微信是否收货
  197. //20240816这里应该是不需要了 直接用下面的WechatMini::getWechatConfig获取配置信息
  198. // Wechat::init($order->store_id);
  199. $app = WechatMini::getWechatConfig($order->store_id);
  200. if (!$app) {
  201. array_push($order_id_arr, $order->id);
  202. continue;
  203. }
  204. $form = new \app\modules\admin\models\WechatThirdForm(['store_id' => $order->store_id]);
  205. $order_ = Order::find()->where(['id' => $order->id])->asArray()->one();
  206. $orderNoHead = substr($receivers_share1['order_no'], 0, 2);
  207. $model = Order::find();
  208. $where = [];
  209. switch ($orderNoHead) {
  210. case 'ML':
  211. case 'AL':
  212. //商盟会员购物订单
  213. $model = Order::find();
  214. $where = [
  215. 'order_no' => $receivers_share1['order_no'],
  216. 'is_delete' => 0,
  217. 'trade_status' => Order::ORDER_FLOW_CONFIRM
  218. ];
  219. break;
  220. case 'SC':
  221. //当面付订单
  222. $model = \app\plugins\scanCodePay\models\Order::find();
  223. $where = [
  224. 'order_no' => $receivers_share1['order_no'],
  225. 'is_delete' => 0,
  226. 'is_pay' => 1
  227. ];
  228. break;
  229. }
  230. $order_ = $model->where($where)->asArray()->one();
  231. $is_trade_managed = $form->is_trade_managed($app);
  232. if ($is_trade_managed) {
  233. $res = $form->wxOrderStateIsConfirm($app, $order_);
  234. if(!$res){
  235. array_push($order_id_arr, $order->id);
  236. continue;
  237. }
  238. }
  239. if (!empty($order_id_arr)) {
  240. return $order_id_arr;
  241. }
  242. $open_add_user_price = false;
  243. if (intval($receivers_share1['type']) !== SharingReceiver::RECEIVE_MERCHANT_ID) {
  244. $open_add_user_price = true;
  245. } else {
  246. if ($receivers_share1['user_id']) {
  247. $open_add_user_price = true;
  248. }
  249. }
  250. if ($open_add_user_price) {
  251. if (in_array($receivers_share1['from'], [
  252. SharingReceiver::FROM_BD_AGENT,
  253. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  254. SharingReceiver::FROM_AREA_AGENT_CITY,
  255. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  256. ])) {
  257. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  258. if (intval($receivers_share1['from']) === SharingReceiver::FROM_BD_AGENT) {
  259. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  260. }
  261. $result = StoreShareMoney::saveShareMoney(
  262. $receivers_share1['saas_id'],
  263. $receivers_share1['store_id'],
  264. $receivers_share1['rate'],
  265. $order->pay_price,
  266. $order->id,
  267. StoreShareMoney::STATUS_STORE_ORDER,
  268. $type_agent,
  269. $receivers_share1['amount'],
  270. 0,
  271. "订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元"
  272. );
  273. if (!$result) {
  274. continue;
  275. }
  276. } else {
  277. $this->saasUserPriceLog($order, [$receivers_share1], false, "订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元");
  278. }
  279. }
  280. $profitOrderId || $profitOrderId = $order->order_no;
  281. $res = WechatShare::share($order->transaction_id, $profitOrderId, [$receivers_share1], false, false, $order->store_id, $order->is_platform, $order);
  282. \Yii::error(['wechatProfitSharingwechatProfitSharing11:', $res]);
  283. if ($res['code'] > 0) {
  284. $faildDes = !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] : $res['msg'];
  285. $faildDes && $faildDes = addslashes('(失败:' . $faildDes . ')');
  286. $receivers_share_platform = [[
  287. 'type' => SharingReceiver::RECEIVE_MERCHANT_ID,
  288. 'account' => Option::get('sp_mch_id', 0, 'saas')['value'],
  289. 'amount' => $receivers_share1['amount'],
  290. 'name' => Option::get('sp_name', 0, 'saas')['value'],
  291. ]];
  292. //分到平台
  293. if($receivers_share1['type'] == 2){
  294. SharingReceiver::updateAll([
  295. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,失败金额转到支付商户")'),
  296. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'err_code' => !empty($res['res']['err_code']) ? $res['res']['err_code'] . "-失败金额转到支付商户" : $res['msg'] . "-失败金额转到支付商户",
  297. 'err_code_des' => !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] . "-失败金额转到支付商户" : $res['msg'] . "-失败金额转到支付商户"], ['id' => $receivers_share1['id']]);
  298. continue;
  299. }
  300. sleep(1);
  301. $res = WechatShare::share($order->transaction_id, $profitOrderId, $receivers_share_platform, false, false, $order->store_id, $order->is_platform, $order);
  302. \Yii::error(['分到平台wechatProfitSharingwechatProfitSharing11:', $res]);
  303. if ($res['code'] > 0) {
  304. SharingReceiver::updateAll([
  305. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,转到服务商")'),
  306. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => !empty($res['res']['err_code']) ? $res['res']['err_code'] : $res['msg'],
  307. 'err_code_des' => !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] : $res['msg']], ['id' => $receivers_share1['id']]);
  308. // $this->saasUserPriceLog($order, [$receivers_share1], true, '-分账失败');
  309. }else{
  310. SharingReceiver::updateAll([
  311. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,转到服务商")'),
  312. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'order_id' => $res['res']['order_id']], ['id' => $receivers_share1['id']]);
  313. $profitOrderId = $res['res']['order_id'];
  314. }
  315. } else {
  316. $order_id = $res['res']['order_id'];
  317. SharingReceiver::updateAll(['updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'order_id' => $res['res']['order_id']], ['id' => $receivers_share1['id']]);
  318. // $this->saasUserPriceLog($order, [$receivers_share1]);
  319. if (in_array($receivers_share1['from'], [
  320. SharingReceiver::FROM_BD_AGENT,
  321. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  322. SharingReceiver::FROM_AREA_AGENT_CITY,
  323. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  324. ])) {
  325. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  326. if (intval($receivers_share1['from']) === SharingReceiver::FROM_BD_AGENT) {
  327. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  328. }
  329. $result = StoreShareMoney::saveShareMoney(
  330. $receivers_share1['saas_id'],
  331. $receivers_share1['store_id'],
  332. $receivers_share1['rate'],
  333. $order->pay_price,
  334. $order->id,
  335. StoreShareMoney::STATUS_STORE_PAYOUTS,
  336. $type_agent,
  337. $receivers_share1['amount'],
  338. 0,
  339. "订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元"
  340. );
  341. if (!$result) {
  342. continue;
  343. }
  344. } else {
  345. $this->saasUserPriceLog($order, [$receivers_share1], true, date('Y年m月d日 H:i:s'). ",订单{$order->order_no}自动分账到账");
  346. }
  347. $profitOrderId = $res['res']['order_id'];
  348. }
  349. }
  350. // 单次分账结束后,剩余金额自动解冻返给商户, 无需主动触发分账完结接口,多次分账时需要最终触发分账完结,最终解冻给商户
  351. // 分账完结
  352. $res = WechatShare::complete($order->transaction_id, $order_id, false, '分账完结', $order->store_id, $order->is_platform );
  353. // return $order_id_arr;
  354. \Yii::error(['<=======================> 订单号:' . $order->order_no . '-分账完结结果:', $res]);
  355. }
  356. public function b2bProfitSharing($order) {
  357. \Yii::error('<=======================>订单号:' . $order->order_no . ' b2b分账进程开始');
  358. $receivers_share = SharingReceiver::find()->where(['store_id' => $order->store_id,
  359. 'order_no' => $order->order_no, 'is_pay' => SharingReceiver::PAY_WAIT])
  360. ->asArray()->all();
  361. $cacheKey = 'b2bProfitSharing11:' . $order->order_no;
  362. if(\Yii::$app->cache->get($cacheKey)){
  363. \Yii::error('<=======================> b2b分账进程已存在');
  364. return;
  365. }
  366. \Yii::$app->cache->set($cacheKey, 1, 160);
  367. $saasRec = [];
  368. foreach($receivers_share as $receivers_share1){
  369. sleep(1);
  370. if (in_array($receivers_share1['from'], [
  371. SharingReceiver::FROM_BD_AGENT,
  372. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  373. SharingReceiver::FROM_AREA_AGENT_CITY,
  374. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  375. ])) {
  376. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  377. if (intval($receivers_share1['from']) === SharingReceiver::FROM_BD_AGENT) {
  378. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  379. }
  380. $result = StoreShareMoney::saveShareMoney(
  381. $receivers_share1['saas_id'],
  382. $receivers_share1['store_id'],
  383. $receivers_share1['rate'],
  384. $order->pay_price,
  385. $order->id,
  386. StoreShareMoney::STATUS_STORE_ORDER,
  387. $type_agent,
  388. $receivers_share1['amount'],
  389. 0,
  390. "b2b订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元"
  391. );
  392. if (!$result) {
  393. continue;
  394. }
  395. } else {
  396. $this->saasUserPriceLog($order, [$receivers_share1], false, "b2b订单{$order->order_no}自动分账到账{$receivers_share1['amount']}钱");
  397. }
  398. $isSaas = B2bPay::sharingaccountIsSaas($receivers_share1['account']);
  399. if($isSaas){
  400. $saasRec[] = $receivers_share1;
  401. continue;
  402. }
  403. $res = B2bPay::share($order, $receivers_share1);
  404. \Yii::error(['wechatProfitSharingwechatProfitSharing11:', $res]);
  405. if ($res['code'] > 0) {
  406. $saasRec[] = $receivers_share1;
  407. $faildDes = $res['code'] ? $res['msg'] : '';
  408. $faildDes && $faildDes = addslashes('(失败:' . $faildDes . ')');
  409. SharingReceiver::updateAll([
  410. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-b2b分账失败,转到服务商")'),
  411. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS], ['id' => $receivers_share1['id']]);
  412. } else {
  413. SharingReceiver::updateAll(['updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS], ['id' => $receivers_share1['id']]);
  414. // $this->saasUserPriceLog($order, [$receivers_share1]);
  415. if (in_array($receivers_share1['from'], [
  416. SharingReceiver::FROM_BD_AGENT,
  417. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  418. SharingReceiver::FROM_AREA_AGENT_CITY,
  419. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  420. ])) {
  421. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  422. if (intval($receivers_share1['from']) === SharingReceiver::FROM_BD_AGENT) {
  423. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  424. }
  425. $result = StoreShareMoney::saveShareMoney(
  426. $receivers_share1['saas_id'],
  427. $receivers_share1['store_id'],
  428. $receivers_share1['rate'],
  429. $order->pay_price,
  430. $order->id,
  431. StoreShareMoney::STATUS_STORE_PAYOUTS,
  432. $type_agent,
  433. $receivers_share1['amount'],
  434. 0,
  435. "b2b订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元"
  436. );
  437. if (!$result) {
  438. continue;
  439. }
  440. } else {
  441. $this->saasUserPriceLog($order, [$receivers_share1], true, date('Y年m月d日 H:i:s'). ",b2b订单{$order->order_no}自动分账到账");
  442. }
  443. }
  444. }
  445. // 分账完结后,剩余金额自动解冻返给商户
  446. if($saasRec){
  447. $amount = 0;
  448. foreach($saasRec as $rec){
  449. $amount += $rec['amount'];
  450. }
  451. $sharingaccountSaas = B2bPay::sharingaccountSaas();
  452. $receivers_share_platform = [
  453. 'amount' => $amount,
  454. 'type' => SharingReceiver::RECEIVE_MERCHANT_ID,
  455. 'account' => $sharingaccountSaas['payee_id'],
  456. 'name' => $sharingaccountSaas['payee_name'],
  457. ];
  458. //分到平台
  459. sleep(1);
  460. $res = B2bPay::share($order, $receivers_share_platform);
  461. \Yii::error(['b2b分到平台wechatProfitSharingwechatProfitSharing11:', $res]);
  462. if ($res['code'] > 0) {
  463. $faildDes = $res['code'] ? $res['msg'] : '';
  464. $faildDes && $faildDes = addslashes('(失败:' . $faildDes . ')');
  465. SharingReceiver::updateAll([
  466. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-b2b分账到服务商失败")'),
  467. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => $res['code'],
  468. 'err_code_des' => $res['msg']], ['id' => array_column($saasRec, 'id')]);
  469. // $this->saasUserPriceLog($order, [$receivers_share1], true, '-分账失败');
  470. }
  471. }
  472. // 分账完结
  473. $res = B2bPay::shareFinish($order);
  474. // return $order_id_arr;
  475. \Yii::error(['<=======================> 订单号:' . $order->order_no . '-b2b分账完结结果:', $res]);
  476. }
  477. public function adapayProfitSharing($order) {
  478. $order_id = $order->order_no;
  479. $receivers_share = SharingReceiver::find()->where(['store_id' => $order->store_id,
  480. 'order_no' => $order->order_no, 'is_pay' => SharingReceiver::PAY_WAIT])
  481. ->asArray()->all();
  482. $profitOrderId = 0;
  483. $cacheKey = 'adapayProfitSharing11:' . $order->adapay_payment_id;
  484. if(\Yii::$app->cache->get($cacheKey)){
  485. \Yii::error('<=======================> adapay分账进程已存在');
  486. return;
  487. }
  488. \Yii::$app->cache->set($cacheKey, 1, 160);
  489. foreach($receivers_share as $receivers_share1){
  490. sleep(1);
  491. if (in_array($receivers_share1['from'], [
  492. SharingReceiver::FROM_BD_AGENT,
  493. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  494. SharingReceiver::FROM_AREA_AGENT_CITY,
  495. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  496. ])) {
  497. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  498. if (intval($receivers_share1['from']) === SharingReceiver::FROM_BD_AGENT) {
  499. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  500. }
  501. $result = StoreShareMoney::saveShareMoney(
  502. $receivers_share1['saas_id'],
  503. $receivers_share1['store_id'],
  504. $receivers_share1['rate'],
  505. $order->pay_price,
  506. $order->id,
  507. StoreShareMoney::STATUS_STORE_ORDER,
  508. $type_agent,
  509. $receivers_share1['amount'],
  510. 0,
  511. "订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元"
  512. );
  513. if (!$result) {
  514. continue;
  515. }
  516. } else {
  517. $this->saasUserPriceLog($order, [$receivers_share1], false, "订单{$order->order_no}自动分账到账{$receivers_share1['amount']}钱");
  518. }
  519. $res = Adapay::share($order, $receivers_share1);
  520. \Yii::error(['adapayProfitSharingadapayProfitSharing11:', $res]);
  521. if ($res['code'] > 0) {
  522. $faildDes = $res['msg'];
  523. $faildDes && $faildDes = addslashes('(失败:' . $faildDes . ')');
  524. //分到平台
  525. if($receivers_share1['type'] == 2){
  526. SharingReceiver::updateAll([
  527. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => !empty($res['res']['err_code']) ? $res['res']['err_code'] : $res['msg'],
  528. 'err_code_des' => !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] : $res['msg']], ['id' => $receivers_share1['id']]);
  529. continue;
  530. }
  531. sleep(1);
  532. $res = Adapay::shareToSaas($order, $receivers_share1);
  533. \Yii::error(['分到平台adapayProfitSharingadapayProfitSharing11:', $res]);
  534. if ($res['code'] > 0) {
  535. SharingReceiver::updateAll([
  536. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,转到服务商")'),
  537. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => !empty($res['res']['err_code']) ? $res['res']['err_code'] : $res['msg'],
  538. 'err_code_des' => !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] : $res['msg']], ['id' => $receivers_share1['id']]);
  539. // $this->saasUserPriceLog($order, [$receivers_share1]);
  540. // $this->saasUserPriceLog($order, [$receivers_share1], true, '-分账失败');
  541. }else{
  542. SharingReceiver::updateAll([
  543. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,转到服务商")'),
  544. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'order_id' => $res['res']['order_id']], ['id' => $receivers_share1['id']]);
  545. }
  546. } else {
  547. $order_id = $res['res']['order_id'];
  548. SharingReceiver::updateAll(['updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'order_id' => $res['res']['order_id']], ['id' => $receivers_share1['id']]);
  549. // $this->saasUserPriceLog($order, [$receivers_share1]);
  550. if (in_array($receivers_share1['from'], [
  551. SharingReceiver::FROM_BD_AGENT,
  552. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  553. SharingReceiver::FROM_AREA_AGENT_CITY,
  554. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  555. ])) {
  556. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  557. if (intval($receivers_share1['from']) === SharingReceiver::FROM_BD_AGENT) {
  558. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  559. }
  560. $result = StoreShareMoney::saveShareMoney(
  561. $receivers_share1['saas_id'],
  562. $receivers_share1['store_id'],
  563. $receivers_share1['rate'],
  564. $order->pay_price,
  565. $order->id,
  566. StoreShareMoney::STATUS_STORE_PAYOUTS,
  567. $type_agent,
  568. $receivers_share1['amount'],
  569. 0,
  570. "订单{$order->order_no}自动分账到账{$receivers_share1['amount']}元"
  571. );
  572. if (!$result) {
  573. continue;
  574. }
  575. } else {
  576. $this->saasUserPriceLog($order, [$receivers_share1], true, date('Y年m月d日 H:i:s'). ",订单{$order->order_no}自动分账到账");
  577. }
  578. }
  579. }
  580. try{
  581. $shareToSelf = Adapay::shareToSelf($order);
  582. if($shareToSelf['code'] == 0){
  583. $order->adapay_share_finish = 1;
  584. $order->save();
  585. }
  586. } catch (\Exception $e) {
  587. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  588. }
  589. // 分账完结
  590. \Yii::error(['<=======================> 订单号:' . $order->order_no . '-分账完结结果:']);
  591. }
  592. /**
  593. * 通联分账
  594. * @param $order
  595. * @return void
  596. */
  597. public function yunstProfitSharing($order) {
  598. $order_id = $order->order_no;
  599. /**
  600. * 查询待分账的记录
  601. */
  602. $receivers_share = SharingReceiver::find()->where(['store_id' => $order->store_id,
  603. 'order_no' => $order->order_no])
  604. // ->andWhere(['in','is_pay',[SharingReceiver::PAY_WAIT,SharingReceiver::PAY_FAIL]])
  605. ->andWhere(['is_pay'=>SharingReceiver::PAY_WAIT])
  606. ->asArray()->all();
  607. $profitOrderId = 0;
  608. // $cacheKey = 'yunstProfitSharing:' . $order->adapay_payment_id;
  609. // if(\Yii::$app->cache->get($cacheKey)){
  610. // \Yii::error('<=======================> yunst分账进程已存在');
  611. // return;
  612. // }
  613. //
  614. // \Yii::$app->cache->set($cacheKey, 1, 160);
  615. foreach($receivers_share as $receivers_share1){
  616. sleep(1);
  617. //开始分账
  618. //这里重新方法调用orderYunst来实现分账
  619. $res = OrderYunst::share($order, $receivers_share1);
  620. debug_log(['<=======================> 订单号:' . $order->order_no . '-分账开始:' . json_encode($res, JSON_UNESCAPED_UNICODE)], 'yunst.log');
  621. //通联分账
  622. if ($res['code'] > 0) {
  623. $failedDes = $res['msg'];
  624. $failedDes && $failedDes = addslashes('(失败:' . $failedDes . ')');
  625. //分到平台
  626. if($receivers_share1['type'] == 2){
  627. SharingReceiver::updateAll([
  628. 'updated_at' => time(),
  629. 'yunst_order_no'=>$res['res']['yunst_order_no'],
  630. 'is_pay' => SharingReceiver::PAY_FAIL,
  631. 'err_code' => !empty($res['res']['err_code']) ? $res['res']['err_code'] : $res['msg'],
  632. 'err_code_des' => !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] : $res['msg']], ['id' => $receivers_share1['id']]);
  633. $id = \Yii::$app->cache->get('yunst_receiver_fail_id' . $receivers_share1['id']);
  634. if ($id && !\Yii::$app->queue->isDone($id)) {
  635. \Yii::$app->queue->remove($id);
  636. }
  637. $id = \queue_push(new \app\jobs\YunstSharingReceiverHandleFailJob(['order_no' => $order->order_no]), 3600);
  638. \Yii::$app->cache->set('yunst_receiver_fail_id' . $receivers_share1['id'], $id);
  639. continue;
  640. }
  641. sleep(1);
  642. //如果分账到账户失败再重试
  643. $res = OrderYunst::shareToSaas($order, $receivers_share1);
  644. if ($res['code'] > 0) {
  645. SharingReceiver::updateAll([
  646. 'description' => new Expression('CONCAT(description, "' . $failedDes . '-分账失败,转到服务商")'),
  647. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => !empty($res['res']['err_code']) ? $res['res']['err_code'] : $res['msg'],
  648. 'err_code_des' => !empty($res['res']['err_code_des']) ? $res['res']['err_code_des'] : $res['msg']], ['id' => $receivers_share1['id']]);
  649. // $this->saasUserPriceLog($order, [$receivers_share1]);
  650. // $this->saasUserPriceLog($order, [$receivers_share1], true, '-分账失败');
  651. $id = \Yii::$app->cache->get('yunst_receiver_fail_id' . $receivers_share1['id']);
  652. if ($id && !\Yii::$app->queue->isDone($id)) {
  653. \Yii::$app->queue->remove($id);
  654. }
  655. $id = \queue_push(new \app\jobs\YunstSharingReceiverHandleFailJob(['order_no' => $order->order_no]), 3600);
  656. \Yii::$app->cache->set('yunst_receiver_fail_id' . $receivers_share1['id'], $id);
  657. }else{
  658. SharingReceiver::updateAll([
  659. 'description' => new Expression('CONCAT(description, "' . $failedDes . '-分账失败,转到服务商")'),
  660. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'order_id' => $res['res']['order_id']], ['id' => $receivers_share1['id']]);
  661. // $this->saasUserPriceLog($order, [$receivers_share1]);
  662. //如果是分账成功自动提现
  663. $this->autoCash($order_id);
  664. }
  665. } else {
  666. $order_id = $res['res']['order_id'];
  667. SharingReceiver::updateAll(['updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS, 'order_id' => $res['res']['order_id']], ['id' => $receivers_share1['id']]);
  668. // $this->saasUserPriceLog($order, [$receivers_share1]);
  669. // $this->saasUserPriceLog($order, [$receivers_share1], true);
  670. //如果是分账成功自动提现
  671. $this->autoCash($order_id);
  672. }
  673. }
  674. // 分账完结
  675. debug_log(['<=======================> 订单号:' . $order->order_no . '-分账完结结果:'], 'yunst.log');
  676. }
  677. /**
  678. * 自动提现
  679. * @return void
  680. */
  681. public function autoCash($order_id)
  682. {
  683. $sharing_info = SharingReceiver::find()->where(['order_id' => $order_id, 'is_pay' => SharingReceiver::PAY_SUCCESS])->one();
  684. if ($sharing_info){
  685. $order_info = \app\plugins\scanCodePay\models\Order::find()->where(['id' => $sharing_info->order_id])->one();
  686. if ($order_info){
  687. $store_price = $sharing_info->amount;
  688. $mch_price = ($order_info->pay_price - $sharing_info->amount);
  689. //平台提现
  690. $cash = new StoreCash();
  691. $cash->order_no = \app\utils\OrderNo::getOrderNo(\app\utils\OrderNo::ORDER_CASH);
  692. $cash->is_delete = 0;
  693. $cash->status = 0;
  694. $cash->price = $store_price;
  695. $cash->created_at = time();
  696. $cash->store_id = -1;
  697. $cash->type =6;//通联提现
  698. $cash->name = '平台提现';
  699. $cash->mobile = '';
  700. $cash->pay_time = 0;
  701. $cash->service_charge = 0;
  702. $cash->cash_type = 0;
  703. if ($cash->save()) {
  704. $oldConf = Option::get(OptionSetting::SAAS_YUNST_SETTING, 0, 'saas')['value'];
  705. if ($oldConf) {
  706. $oldConf = json_decode($oldConf, true);
  707. if (!empty($oldConf)) {
  708. $customer_number = $oldConf['customer_number'];
  709. //调用通联自动提现接口
  710. $orderYunst = new OrderYunst();
  711. $res = $orderYunst->queryAcctInfo($customer_number);
  712. debug_log($res);
  713. $amount = 0;
  714. if ($res['subCode'] == 'SUCCESS'){
  715. $amount = $res['data']['amount'];//真的
  716. }
  717. if ($store_price > $amount) {
  718. debug_log('平台提现金额大于通联账户余额');
  719. }
  720. $orderYunst = new OrderYunst();
  721. $data['bizOrderNo'] = $cash->order_no;
  722. $data['bizUserId'] = $customer_number;//代理商号
  723. $data['amount'] = intval($cash->price * 100);
  724. $data['notifyUrl'] = \Yii::$app->request->hostInfo;
  725. $data['remark'] = "";
  726. $data['authWay'] = "3";
  727. $res_cash = $orderYunst->servicerWithdraw($data);
  728. debug_log($res_cash);
  729. if ($res_cash['subCode'] != 'SUCCESS'){
  730. debug_log('平台提现失败');
  731. debug_log($res_cash['subMsg']);
  732. $cash_info2 = StoreCash::findOne($cash->id);
  733. $order_no = \app\utils\OrderNo::getOrderNo(\app\utils\OrderNo::ORDER_CASH);
  734. $cash_info2->order_no = $order_no;
  735. $cash_info2->save();
  736. }else{
  737. $cash_info = StoreCash::findOne($cash->id);
  738. $cash_info->status = 2;
  739. $cash_info->pay_time = time();
  740. $cash_info->save();
  741. debug_log('平台提现成功');
  742. }
  743. }
  744. }
  745. }
  746. //商户提现
  747. $cash_mch = new StoreCash();
  748. $cash_mch->order_no = \app\utils\OrderNo::getOrderNo(\app\utils\OrderNo::ORDER_CASH);
  749. $cash_mch->is_delete = 0;
  750. $cash_mch->status = 0;
  751. $cash_mch->price = $mch_price;
  752. $cash_mch->created_at = time();
  753. $cash_mch->store_id = $sharing_info->store_id;
  754. $cash_mch->type =6;//通联提现
  755. $cash_mch->name = '商户提现';
  756. $cash_mch->mobile = '';
  757. $cash_mch->pay_time = 0;
  758. $cash_mch->service_charge = 0;
  759. $cash_mch->cash_type = 0;
  760. if ($cash_mch->save()) {
  761. //调用通联自动提现接口
  762. $store = \app\models\Store::findOne($sharing_info->store_id);
  763. $orderYunst = new OrderYunst();
  764. $res2 = $orderYunst->queryAcctInfo($store->store_number);
  765. debug_log($res2);
  766. $amount2 = 0;
  767. if ($res2['subCode'] == 'SUCCESS'){
  768. $amount2 = $res2['data']['amount'];//真的
  769. }
  770. if ($mch_price > $amount2) {
  771. debug_log('平台提现金额大于通联账户余额');
  772. }
  773. $orderYunst = new OrderYunst();
  774. $data['bizOrderNo'] = $cash_mch->order_no;
  775. $store = Store::findOne(['id' => $cash_mch->store_id]);
  776. $data['bizUserId'] = $store->store_number;
  777. $data['amount'] = intval($cash_mch->price * 100);
  778. $data['notifyUrl'] = \Yii::$app->request->hostInfo;
  779. $data['remark'] = "";
  780. $data['authWay'] = "3";
  781. $res_cash2 = $orderYunst->servicerWithdraw($data);
  782. debug_log($res_cash2);
  783. if ($res_cash2['subCode'] != 'SUCCESS'){
  784. debug_log('商户提现失败');
  785. debug_log($res_cash2['subMsg']);
  786. $cash_info2 = StoreCash::findOne($cash_mch->id);
  787. $order_no = \app\utils\OrderNo::getOrderNo(\app\utils\OrderNo::ORDER_CASH);
  788. $cash_info2->order_no = $order_no;
  789. $cash_info2->save();
  790. }else{
  791. $cash_info2 = StoreCash::findOne($cash_mch->id);
  792. $cash_info2->status = 2;
  793. $cash_info2->pay_time = time();
  794. $cash_info2->save();
  795. debug_log('商户提现成功');
  796. }
  797. }
  798. }else{
  799. debug_log('订单不存在,提现失败');
  800. }
  801. }else{
  802. debug_log('分账不存在,提现失败');
  803. }
  804. }
  805. /**
  806. * 支付宝分账
  807. * @param Order | \app\plugins\scanCodePay\models\Order | ReOrder | FoodOrder $order
  808. * @throws \EasyWeChat\Kernel\Exceptions\InvalidArgumentException
  809. * @throws \EasyWeChat\Kernel\Exceptions\InvalidConfigException
  810. * @throws \GuzzleHttp\Exception\GuzzleException
  811. */
  812. public function alipayProfitSharing($order, &$order_id_arr = []) {
  813. if (!$order) {
  814. \Yii::error('<=======================> 支付宝分账订单不存在');
  815. return;
  816. }
  817. $receivers_share = SharingReceiver::find()->where(['store_id' => $order->store_id, 'is_pay' => SharingReceiver::PAY_WAIT, 'order_no' => $order->order_no, 'execute_type' => SharingReceiver::EXECUTE_TYPE_ALIPAY])
  818. ->asArray()->all();
  819. debug_log(['receivers_share' => $receivers_share], 'profitSharing.log');
  820. if (empty($receivers_share)) {
  821. \Yii::error('<=======================> 订单号:' . $order->order_no . '分账接收人为空');
  822. return;
  823. }
  824. $cacheKey = 'alipayProfitSharing11:' . $order->order_no;
  825. // if(\Yii::$app->cache->get($cacheKey)){
  826. // \Yii::error('<=======================> 支付宝分账进程已存在');
  827. // return;
  828. // }
  829. \Yii::$app->cache->set($cacheKey, 1, 160);
  830. foreach ($receivers_share as $receiver) {
  831. sleep(1);
  832. $res_arr = [];
  833. $trans_in_type = 'loginName';
  834. if (strpos($receiver['account'], '2088') !== false) {
  835. $trans_in_type = 'userId';
  836. }
  837. $res_arr[] = [
  838. 'royalty_type' => 'transfer',
  839. 'trans_in_type' => $trans_in_type,
  840. 'amount' => $receiver['amount'],
  841. 'trans_in' => $receiver['account'],
  842. 'desc' => $receiver['description']
  843. ];
  844. $storeInfo = Store::find()->where(['id'=>$order->store_id,'is_delete'=>0])->asArray()->one();
  845. // if ($storeInfo['business_model'] != 1) {
  846. // $res = AlipayUnion::settle($order->order_no, $order->alipay_trade_no, $res_arr, $order->store_id,'true');
  847. // } else {
  848. $is_app = false;
  849. if ($order->order_origin === Order::ORDER_SOURCE_APP) {
  850. $is_app = true;
  851. }
  852. debug_log(['order_no' => $order->order_no, 'alipay_trade_no' => $order->alipay_trade_no, 'res_arr' => $res_arr, 'store_id' => $order->store_id], 'profitSharing.log');
  853. $res = AlipayProfit::settle($order->order_no, $order->alipay_trade_no, $res_arr, $order->store_id,'true', $is_app);
  854. // }
  855. if (in_array($receiver['from'], [
  856. SharingReceiver::FROM_BD_AGENT,
  857. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  858. SharingReceiver::FROM_AREA_AGENT_CITY,
  859. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  860. ])) {
  861. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  862. if (intval($receiver['from']) === SharingReceiver::FROM_BD_AGENT) {
  863. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  864. }
  865. $result = StoreShareMoney::saveShareMoney(
  866. $receiver['saas_id'],
  867. $receiver['store_id'],
  868. $receiver['rate'],
  869. $order->pay_price,
  870. $order->id,
  871. StoreShareMoney::STATUS_STORE_ORDER,
  872. $type_agent,
  873. $receiver['amount'],
  874. 0,
  875. "订单{$order->order_no}自动分账到账{$receiver['amount']}元"
  876. );
  877. if (!$result) {
  878. continue;
  879. }
  880. } else {
  881. $this->saasUserPriceLog($order, [$receiver], false, "订单{$order->order_no}自动分账到账{$receiver['amount']}元");
  882. }
  883. \Yii::error(['<=======================> 订单号:' . $order->order_no . ', 分销请求分账结果:', $res]);
  884. if ($res['code'] > 0) {
  885. if (isset($res['res']['sub_code']) && $res['res']['sub_code'] === 'ACQ.TXN_RESULT_ACCOUNT_BALANCE_NOT_ENOUGH') { //账户余额不足
  886. array_push($order_id_arr, $order->id);
  887. break;
  888. }
  889. $faildDes = $res['res']['sub_msg'];
  890. $faildDes && $faildDes = addslashes('(失败:' . $faildDes . ')');
  891. $receivers_share_platform = [];
  892. $amount = $receiver['amount'];
  893. $receivers_share_platform[] = [
  894. 'royalty_type' => 'transfer',
  895. 'trans_in_type' => 'userId',
  896. 'amount' => $amount,
  897. 'trans_in' => Option::get('alipay_user_id', 0, 'saas')['value'],
  898. 'desc' => '分账到平台',
  899. ];
  900. //分到平台
  901. if($receiver['type'] == 2){
  902. SharingReceiver::updateAll([
  903. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => $res['res']['code'],
  904. 'err_code_des' => $res['res']['sub_msg']], ['id' => $receiver['id']]);
  905. continue;
  906. }
  907. sleep(1);
  908. // if ($storeInfo['business_model'] != 1) {
  909. // $res = AlipayUnion::settle($order->order_no, $order->alipay_trade_no, $receivers_share_platform, $order->store_id,'true');
  910. // } else {
  911. $is_app = false;
  912. if ($order->order_origin === Order::ORDER_SOURCE_APP) {
  913. $is_app = true;
  914. }
  915. $res = AlipayProfit::settle($order->order_no, $order->alipay_trade_no, $receivers_share_platform, $order->store_id,'true', $is_app);
  916. // }
  917. \Yii::error(['分到平台wechatProfitSharingwechatProfitSharing11:', $res]);
  918. if ($res['code'] > 0) {
  919. SharingReceiver::updateAll([
  920. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,转到服务商")'),
  921. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_FAIL, 'err_code' => $res['res']['code'],
  922. 'err_code_des' => $res['res']['sub_msg']], ['id' => $receiver['id']]);
  923. // $this->saasUserPriceLog($order, [$receiver]);
  924. // $this->saasUserPriceLog($order, [$receiver], true, '-分账失败');
  925. }else{
  926. SharingReceiver::updateAll([
  927. 'description' => new Expression('CONCAT(description, "' . $faildDes . '-分账失败,转到服务商")'),
  928. 'updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS], ['id' => $receiver['id']]);
  929. }
  930. return;
  931. }
  932. SharingReceiver::updateAll(['updated_at' => time(), 'is_pay' => SharingReceiver::PAY_SUCCESS], ['id' => $receiver['id']]);
  933. // $this->saasUserPriceLog($order, $receivers_share);
  934. if (in_array($receiver['from'], [
  935. SharingReceiver::FROM_BD_AGENT,
  936. SharingReceiver::FROM_AREA_AGENT_PROVIDER,
  937. SharingReceiver::FROM_AREA_AGENT_CITY,
  938. SharingReceiver::FROM_AREA_AGENT_DISTRICT,
  939. ])) {
  940. $type_agent = StoreShareMoney::TYPE_AREA_AGENT;
  941. if (intval($receiver['from']) === SharingReceiver::FROM_BD_AGENT) {
  942. $type_agent = StoreShareMoney::TYPE_BD_AGENT;
  943. }
  944. $result = StoreShareMoney::saveShareMoney(
  945. $receiver['saas_id'],
  946. $receiver['store_id'],
  947. $receiver['rate'],
  948. $order->pay_price,
  949. $order->id,
  950. StoreShareMoney::STATUS_STORE_PAYOUTS,
  951. $type_agent,
  952. $receiver['amount'],
  953. 0,
  954. "订单{$order->order_no}自动分账到账{$receiver['amount']}元"
  955. );
  956. if (!$result) {
  957. continue;
  958. }
  959. } else {
  960. $this->saasUserPriceLog($order, $receivers_share, true, date('Y年m月d日 H:i:s'). ",订单{$order->order_no}自动分账到账");
  961. }
  962. }
  963. }
  964. public function saasUserPriceLog($order, $SharingReceivers = [], $expend = false, $log = '') {
  965. try {
  966. $log_type = SaasUserPriceLog::LOG_TYPE_INCOME;
  967. $remark = '';
  968. if($expend){
  969. $log_type = SaasUserPriceLog::LOG_TYPE_EXPEND;
  970. $remark = '-分账成功';
  971. }
  972. $log && $remark = $log;
  973. foreach ($SharingReceivers as $item) {
  974. \Yii::warning(['---- saasUserPriceLog Err11 ----', $item]);
  975. if(intval($item['type']) === SharingReceiver::RECEIVE_MERCHANT_ID && !intval($item['user_id'])){
  976. continue;
  977. }
  978. $desc = $item['remark'] . $remark;
  979. $saas_id = $item['saas_id'];
  980. if(!$saas_id){
  981. if(!$order->is_platform){
  982. $saas_id = $item['user_id'];
  983. }else{
  984. $userInfo = User::findOne($item['user_id']);
  985. if(!empty($userInfo)){
  986. $saas = SaasUser::findOne(['mobile' => $userInfo->binding]);
  987. $saas_id = $saas->id;
  988. }
  989. }
  990. }
  991. \Yii::warning(['---- saasUserPriceLog Err22 ----', $saas_id, $item['amount'], $item['from'], $log_type, $order->order_no, $desc]);
  992. SaasUserPriceLog::saveLog($saas_id, $item['amount'], $item['from'], $log_type, $order->order_no, $desc);
  993. }
  994. } catch (\Exception $e) {
  995. \Yii::warning('---- saasUserPriceLog Err ----' . __LINE__);
  996. }
  997. }
  998. // 分享员佣金结算
  999. public function video_shop_order_share_money($id)
  1000. {
  1001. $order_id = $id;
  1002. \Yii::warning(['分享员佣金结算:0000', $order_id]);
  1003. $VideoShopOrderExt = VideoShopOrderExt::findOne(['order_id' => $order_id]);
  1004. if (!$VideoShopOrderExt) {
  1005. return;
  1006. }
  1007. $order = Order::findOne($order_id);
  1008. if (!$order) {
  1009. return;
  1010. }
  1011. if ($VideoShopOrderExt->is_price != 0) {
  1012. return;
  1013. }
  1014. $VideoShopOrderExt->is_price = 1;
  1015. $VideoShopOrderExt->save();
  1016. $user_1 = User::findOne($VideoShopOrderExt->old_parent_id);
  1017. if (!$user_1) {
  1018. return;
  1019. }
  1020. $user_1->updateCounters(['total_price' => $VideoShopOrderExt->first_price, 'price' => $VideoShopOrderExt->first_price]);
  1021. UserShareMoney::set($VideoShopOrderExt->first_price, $user_1->id, $order_id, 0, 1, $VideoShopOrderExt->store_id, 0, '分享员获得佣金, 订单号:' . $order->order_no);
  1022. \Yii::warning(['分享员佣金结算:1', $VideoShopOrderExt->store_id, $order_id, $user_1->id, $VideoShopOrderExt->first_price]);
  1023. $order->updateCounters(['share_price' => doubleval($VideoShopOrderExt->first_price)]);
  1024. return;
  1025. }
  1026. // 分销订单佣金结算
  1027. public function share_money($id)
  1028. {
  1029. $order_id = $id;
  1030. if(isset($order_id->id)){
  1031. $order = $order_id;
  1032. }else{
  1033. $order = Order::findOne($order_id);
  1034. }
  1035. if (!$order) {
  1036. return;
  1037. }
  1038. if ($order->is_price != 0) {
  1039. return;
  1040. }
  1041. //排除商盟订单
  1042. if($order->user_id == 0) {
  1043. return;
  1044. }
  1045. $setting = Option::get('share_money_setting', $order->store_id);
  1046. $setting = $setting ? Json::decode($setting['value']) : [];
  1047. if (!$setting) {
  1048. \Yii::warning('订单佣金发送:未开启分销设置1');
  1049. return;
  1050. }
  1051. // if (!is_array($setting['commission_type']) || empty($setting['commission_type'])) {
  1052. // \Yii::warning('订单佣金发送:未开启分销设置2');
  1053. // return;
  1054. // }
  1055. // $commission_type = $setting['commission_type'];
  1056. // // 订单佣金 2
  1057. // if (in_array(2, $commission_type)) {
  1058. // $this->sendOrderProfit($order, $setting['expire_day']);
  1059. //临时关系佣金发放
  1060. try {
  1061. if (!empty($order->limit_id) && !empty($order->limit_price)) {
  1062. \Yii::error("临时绑定关系发放佣金", '临时绑定关系发放佣金');
  1063. //临时绑定关系发放佣金
  1064. $bind_log = UserBindLog::findOne($order->limit_id);
  1065. $user = User::findOne($bind_log->parent_id);
  1066. $user->updateCounters(['total_price' => $order->limit_price, 'price' => $order->limit_price]);
  1067. UserShareMoney::set($order->limit_price, $user->id, $order->id, 0, 6, $order->store_id, 0);
  1068. $order->is_send_limit = 1;
  1069. $order->updateCounters(['share_price' => doubleval($order->limit_price)]);
  1070. $res = $order->save();
  1071. if (!$res) {
  1072. \Yii::error("订单保存失败");
  1073. };
  1074. } else {
  1075. \Yii::error("订单中临时关系佣金为空");
  1076. }
  1077. } catch (\Throwable $e) {
  1078. \Yii::error("订单中临时关系佣金发放失败: " . $e->getMessage());
  1079. }
  1080. // } else {
  1081. // \Yii::warning('订单佣金发送:未开启订单佣金分销');
  1082. // }
  1083. // // 会员佣金
  1084. // if (!in_array(1, $commission_type)) {
  1085. // \Yii::warning('订单佣金发送:未开启会员佣金分销');
  1086. // return;
  1087. // }
  1088. $share_setting = Option::get('share_basic_setting', $order->store_id);
  1089. $share_setting = $share_setting ? Json::decode($share_setting['value']) : [];
  1090. // 分销商自购返利
  1091. $order->share_price = 0;
  1092. $user = User::findOne(['id' => $order->user_id]);
  1093. if ($order->rebate > 0) {
  1094. if ($order->share_send_type == 2) {
  1095. AccountLog::saveLog($order->user_id, $order->rebate, AccountLog::TYPE_INTEGRAL,
  1096. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1097. $order->id, "商城订单自购返利赠送积分, 订单号:{$order->order_no}");
  1098. } else if ($order->share_send_type == 3) {
  1099. AccountLog::saveLog($order->user_id, $order->rebate, AccountLog::TYPE_BALANCE,
  1100. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1101. $order->id, "商城订单自购返利赠送余额, 订单号:{$order->order_no}");
  1102. } else {
  1103. $user->updateCounters(['total_price' => doubleval($order->rebate), 'price' => doubleval($order->rebate)]);
  1104. $order->updateCounters(['share_price' => doubleval($order->rebate)]);
  1105. UserShareMoney::set($order->rebate, $user->id, $order->id, 0, 4, $order->store_id, 0);
  1106. }
  1107. }
  1108. // 一级佣金发放
  1109. if ($share_setting['level']['value'] >= 1) {
  1110. $user_1 = User::findOne($order->old_parent_id);
  1111. if (!$user_1) {
  1112. $order->save();
  1113. return;
  1114. }
  1115. if ($order->share_send_type == 2 && $order->first_price > 0) {
  1116. AccountLog::saveLog($user_1->id, $order->first_price, AccountLog::TYPE_INTEGRAL,
  1117. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1118. $order->id, "商城订单分销赠送积分, 订单号:{$order->order_no}");
  1119. } else if ($order->share_send_type == 3 && $order->first_price > 0) {
  1120. AccountLog::saveLog($user_1->id, $order->first_price, AccountLog::TYPE_BALANCE,
  1121. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1122. $order->id, "商城订单分销赠送余额, 订单号:{$order->order_no}");
  1123. } else {
  1124. $user_1->updateCounters(['total_price' => $order->first_price, 'price' => $order->first_price]);
  1125. UserShareMoney::set($order->first_price, $user_1->id, $order->id, 0, 1, $order->store_id, 0);
  1126. $order->updateCounters(['share_price' => doubleval($order->first_price)]);
  1127. }
  1128. }
  1129. // 二级佣金发放
  1130. if ($share_setting['level']['value'] >= 2) {
  1131. $user_2 = User::findOne($order->old_parent_id_1);
  1132. if ($user_2) {
  1133. if ($order->share_send_type == 2 && $order->second_price > 0) {
  1134. AccountLog::saveLog($user_2->id, $order->second_price, AccountLog::TYPE_INTEGRAL,
  1135. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1136. $order->id, "商城订单分销赠送积分, 订单号:{$order->order_no}");
  1137. } else if ($order->share_send_type == 3 && $order->second_price > 0) {
  1138. AccountLog::saveLog($user_2->id, $order->second_price, AccountLog::TYPE_BALANCE,
  1139. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1140. $order->id, "商城订单分销赠送余额, 订单号:{$order->order_no}");
  1141. } else {
  1142. $user_2->updateCounters(['total_price' => $order->second_price, 'price' => $order->second_price]);
  1143. UserShareMoney::set($order->second_price, $user_2->id, $order->id, 0, 2, $order->store_id, 0);
  1144. $order->updateCounters(['share_price' => doubleval($order->second_price)]);
  1145. }
  1146. }
  1147. }
  1148. // 三级佣金发放
  1149. if ($share_setting['level']['value'] >= 3 && $order->rebate == 0) {
  1150. $user_3 = User::findOne($order->old_parent_id_2);
  1151. if ($user_3) {
  1152. if ($order->share_send_type == 2 && $order->third_price > 0) {
  1153. AccountLog::saveLog($user_3->id, $order->third_price, AccountLog::TYPE_INTEGRAL,
  1154. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1155. $order->id, "商城订单分销赠送积分, 订单号:{$order->order_no}");
  1156. } else if ($order->share_send_type == 3 && $order->third_price > 0) {
  1157. AccountLog::saveLog($user_3->id, $order->third_price, AccountLog::TYPE_BALANCE,
  1158. AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER,
  1159. $order->id, "商城订单分销赠送余额, 订单号({$order->order_no})");
  1160. } else {
  1161. $user_3->updateCounters(['total_price' => $order->third_price, 'price' => $order->third_price]);
  1162. UserShareMoney::set($order->third_price, $user_3->id, $order->id, 0, 3, $order->store_id, 0);
  1163. $order->updateCounters(['share_price' => doubleval($order->third_price)]);
  1164. }
  1165. }
  1166. }
  1167. if (
  1168. (!empty($order->limit_id) && !empty($order->limit_price)) ||
  1169. $order->rebate > 0 ||
  1170. $share_setting['level']['value'] >= 1 ||
  1171. $share_setting['level']['value'] >= 2 ||
  1172. ($share_setting['level']['value'] >= 3 && $order->rebate == 0)
  1173. ) {
  1174. $order->is_price = 1;
  1175. }
  1176. $order->save();
  1177. return;
  1178. }
  1179. // 股东等级分佣结算
  1180. public function share_holder_money($id)
  1181. {
  1182. $order_id = $id;
  1183. if(isset($order_id->id)){
  1184. $order = $order_id;
  1185. }else{
  1186. $order = Order::findOne($order_id);
  1187. }
  1188. if (!$order) {
  1189. return;
  1190. }
  1191. if ($order->holder_is_price != 0) {
  1192. return;
  1193. }
  1194. //商盟订单没有股东分红
  1195. if($order->user_id == 0){
  1196. return;
  1197. }
  1198. // 一级佣金发放
  1199. if ($order->holder_first_price > 0) {
  1200. $user_1 = User::findOne($order->parent_id);
  1201. $user_1->updateCounters(['total_price' => $order->holder_first_price, 'price' => $order->holder_first_price]);
  1202. UserShareMoney::set($order->holder_first_price, $user_1->id, $order->id, 2, 1, $order->store_id, 0);
  1203. $order->holder_is_price = 1;
  1204. $order->updateCounters(['share_price' => doubleval($order->holder_first_price)]);
  1205. }
  1206. // 二级佣金发放
  1207. if ($order->holder_second_price > 0) {
  1208. $user_2 = User::findOne($order->parent_id_1);
  1209. $user_2->updateCounters(['total_price' => $order->holder_second_price, 'price' => $order->holder_second_price]);
  1210. UserShareMoney::set($order->holder_second_price, $user_2->id, $order->id, 2, 2, $order->store_id, 0);
  1211. $order->updateCounters(['share_price' => doubleval($order->holder_second_price)]);
  1212. }
  1213. // 三级佣金发放
  1214. if ($order->holder_third_price > 0) {
  1215. $user_3 = User::findOne($order->parent_id_2);
  1216. $user_3->updateCounters(['total_price' => $order->holder_third_price, 'price' => $order->holder_third_price]);
  1217. UserShareMoney::set($order->holder_third_price, $user_3->id, $order->id, 2, 3, $order->store_id, 0);
  1218. $order->updateCounters(['share_price' => doubleval($order->holder_third_price)]);
  1219. }
  1220. // 旧关系发放
  1221. // 一级佣金发放
  1222. if ($order->old_holder_first_price > 0) {
  1223. $user_1 = User::findOne($order->old_parent_id);
  1224. $user_1->updateCounters(['total_price' => $order->old_holder_first_price, 'price' => $order->old_holder_first_price]);
  1225. UserShareMoney::set($order->old_holder_first_price, $user_1->id, $order->id, 2, 1, $order->store_id, 0);
  1226. $order->updateCounters(['share_price' => doubleval($order->old_holder_first_price)]);
  1227. }
  1228. // 二级佣金发放
  1229. if ($order->old_holder_second_price > 0) {
  1230. $user_2 = User::findOne($order->old_parent_id_1);
  1231. $user_2->updateCounters(['total_price' => $order->old_holder_second_price, 'price' => $order->old_holder_second_price]);
  1232. UserShareMoney::set($order->old_holder_second_price, $user_2->id, $order->id, 2, 2, $order->store_id, 0);
  1233. $order->updateCounters(['share_price' => doubleval($order->old_holder_second_price)]);
  1234. }
  1235. // 三级佣金发放
  1236. if ($order->old_holder_third_price > 0) {
  1237. $user_3 = User::findOne($order->old_parent_id_2);
  1238. $user_3->updateCounters(['total_price' => $order->old_holder_third_price, 'price' => $order->old_holder_third_price]);
  1239. UserShareMoney::set($order->old_holder_third_price, $user_3->id, $order->id, 2, 3, $order->store_id, 0);
  1240. $order->updateCounters(['share_price' => doubleval($order->old_holder_third_price)]);
  1241. }
  1242. $order->save();
  1243. }
  1244. /**
  1245. * 积分发放
  1246. */
  1247. public function give_integral($id)
  1248. {
  1249. $order_id = $id;
  1250. if(isset($order_id->id)){
  1251. $give = $order_id;
  1252. }else{
  1253. $give = Order::findOne($order_id);
  1254. }
  1255. if ($give['give_integral'] != 0) {
  1256. return;
  1257. }
  1258. $integral = OrderDetail::find()
  1259. ->andWhere(['order_id' => $give['id'], 'is_delete' => 0])
  1260. ->select([
  1261. 'sum(integral)',
  1262. ])->scalar();
  1263. if (!$integral) {
  1264. return;
  1265. }
  1266. $giveUser = User::findOne(['id' => $give['user_id']]);
  1267. AccountLog::saveLog($giveUser->id, $integral, AccountLog::TYPE_INTEGRAL, AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER, $give->id, '订单'.$give->order_no.'赠送积分');
  1268. $give->give_integral = 1;
  1269. $give->save();
  1270. }
  1271. // 团长佣金结算
  1272. public function shop_share($id,$type=0)
  1273. {
  1274. if ($id) {
  1275. $shopShare = ShopShare::findOne([
  1276. 'order_id' => $id,
  1277. 'type' => $type
  1278. ]);
  1279. if ($shopShare->shop_id && $shopShare->status == 0) {
  1280. $shop = Shop::findOne($shopShare->shop_id);
  1281. if ($shop && $shop->user_id) {
  1282. $form = User::findOne(['id' => $shop->user_id]);
  1283. $form->updateCounters(['tuan_price' => $shopShare->amount]);
  1284. $shopShare->status = 1;
  1285. $shopShare->save();
  1286. }
  1287. }
  1288. }
  1289. }
  1290. public function league_price($id){
  1291. $order_id = $id;
  1292. if(isset($order_id->id)){
  1293. $order = $order_id;
  1294. }else{
  1295. $order = Order::findOne($order_id);
  1296. }
  1297. $store = Store::findOne($order->store_id);
  1298. $user = User::findOne($order->user_id);
  1299. $saas_user = SaasUser::findOne(['mobile' => $user->binding]);
  1300. if($order->send_price > 0){ // && $store->league_price > 0
  1301. //给用户发放联盟券
  1302. $send_price = $order->send_price;
  1303. if($saas_user){
  1304. // $store->league_price -= $send_price;
  1305. // $store->save();
  1306. $before = $saas_user->league_price;
  1307. $saas_user->updateCounters(['league_price' => floatval($send_price)]);
  1308. SaaSLeaguePriceLog::setLeaguePriceLog(
  1309. $order->store_id,
  1310. $saas_user->id,
  1311. $send_price,
  1312. $before,
  1313. SaaSLeaguePriceLog::TYPE_ORDER_REBATE,
  1314. SaaSLeaguePriceLog::SEND_TYPE,
  1315. SaaSLeaguePriceLog::ROLE_USER,
  1316. $order->id
  1317. );
  1318. }
  1319. $before = $store->league_price;
  1320. $store->updateCounters(['league_price' => -floatval($send_price)]);
  1321. SaaSLeaguePriceLog::setLeaguePriceLog(
  1322. $order->store_id,
  1323. $saas_user->id,
  1324. $send_price,
  1325. $before,
  1326. SaaSLeaguePriceLog::TYPE_ORDER_REBATE,
  1327. SaaSLeaguePriceLog::TAKE_TYPE,
  1328. SaaSLeaguePriceLog::ROLE_STORE,
  1329. $order->id
  1330. );
  1331. }
  1332. if($order->take_price > 0){
  1333. //给商家增加 (用户抵扣钱从赠送给商家)
  1334. $before = $store->league_price;
  1335. //给商家返券
  1336. $store->league_price += floatval($order->take_price);
  1337. $store->save();
  1338. $after = $store->league_price;
  1339. $model = new SaaSLeaguePriceLog();
  1340. $model->saas_user_id = $saas_user->id;
  1341. $model->store_id = $order->store_id;
  1342. $model->league_price = $order->take_price;
  1343. $model->type = 2; //下单返利
  1344. $model->before = $before;
  1345. $model->after = $after;
  1346. $model->order_id = $order->id;
  1347. $model->addtime = time();
  1348. $model->role = SaaSLeaguePriceLog::ROLE_STORE;
  1349. $model->save();
  1350. }
  1351. }
  1352. /**
  1353. * 门店收益计算
  1354. */
  1355. public function handleMdProfit($order_id) {
  1356. $md_profit = MdProfit::findOne(['order_id' => $order_id, 'is_send' => 0]);
  1357. if ($md_profit) {
  1358. $md = Md::findOne($md_profit->md_id);
  1359. $md->updateCounters(['total_profit' => $md_profit->total_profit, 'cash_profit' => $md_profit->total_profit]);
  1360. $md_profit->is_send = 1;
  1361. $md_profit->save();
  1362. }
  1363. }
  1364. /**
  1365. * 抖品发放佣金
  1366. */
  1367. public function sendVideoGoodsProfit($id)
  1368. {
  1369. try {
  1370. $video_share = VideoGoodsShare::find()->where(['order_id' => $id, 'is_pay' => 1, 'is_send' => 0])->all();
  1371. foreach ($video_share as $item) {
  1372. $item->is_send = 1;
  1373. $item->send_time = time();
  1374. if ($item->save()) {
  1375. $user = User::findOne($item->author_user_id);
  1376. $user->total_price = ((float)$user->total_price + (float)$item->proportion);
  1377. $user->price = ((float)$user->price + (float)$item->proportion);
  1378. if ($user->save()) {
  1379. $UserShareMoney = new UserShareMoney();
  1380. $UserShareMoney->store_id = $item->store_id;
  1381. $UserShareMoney->order_id = $item->order_id;
  1382. $UserShareMoney->user_id = $item->author_user_id;
  1383. $UserShareMoney->type = 0;
  1384. $UserShareMoney->source = 1;
  1385. $UserShareMoney->money = $item->proportion;
  1386. $UserShareMoney->created_at = time();
  1387. $UserShareMoney->order_type = 0;
  1388. $UserShareMoney->is_delete = 0;
  1389. $UserShareMoney->version = cyy_version();
  1390. $UserShareMoney->save();
  1391. }
  1392. }
  1393. }
  1394. } catch (\Exception $e) {
  1395. \Yii::error($e->getMessage());
  1396. }
  1397. }
  1398. public function agencyPrice($order_id){
  1399. try {
  1400. if(isset($order_id->id)){
  1401. $order = $order_id;
  1402. }else{
  1403. $order = Order::findOne($order_id);
  1404. }
  1405. if (in_array($order->pay_type, [Order::PAY_TYPE_WECHAT, Order::PAY_TYPE_ALI])) {
  1406. throw new \Exception('订单是微信或支付宝支付,不在这里计算发放佣金');
  1407. }
  1408. $order_id = $order->id;
  1409. $agency_price_config = Option::get('agency_price_config', 0, 'saas')['value'];
  1410. $agency_price_config = json_decode($agency_price_config, true) ?: [];
  1411. $province_percent = $agency_price_config['province_percent'] ?? 0;
  1412. $city_percent = $agency_price_config['city_percent'] ?? 0;
  1413. $district_percent = $agency_price_config['district_percent'] ?? 0;
  1414. $bd_agency_price_config = Option::get('bd_agency_price_config', 0, 'saas')['value'];
  1415. $bd_agency_price_config = json_decode($bd_agency_price_config, true) ?: [];
  1416. $bd_agent_percent = $bd_agency_price_config['bd_agent_percent'] ?? 0;
  1417. //获取代理商ID
  1418. $store = Store::findOne($order->store_id);
  1419. $admin_list = Admin::find()->where(['province_id' => $store->province_id, 'is_delete' => 0, 'type' => 'admin'])->asArray()->all();
  1420. $user = User::findOne($order->user_id);
  1421. $saasUser = SaasUser::findOne(['mobile' => $user->binding]);
  1422. $saas_user_name = '-';
  1423. if ($saasUser) {
  1424. $saas_user_name = $saasUser->name;
  1425. }
  1426. //推广代理
  1427. if($store->salesman_id){
  1428. $salesman = Salesman::findOne($store->salesman_id);
  1429. $bd = Admin::find()->where(['type' => Admin::ADMIN_TYPE_BD_AGENT, 'id' => $salesman['admin_id']])->asArray()->one();
  1430. if($bd){
  1431. $admin_list[] = $bd;
  1432. }
  1433. }
  1434. foreach ($admin_list as $item) {
  1435. $ag_rebate = 0;
  1436. $rate = 0;
  1437. $desc = '';
  1438. $type = StoreShareMoney::TYPE_AREA_AGENT;
  1439. if($item['type'] == Admin::ADMIN_TYPE_BD_AGENT){
  1440. $ag_rebate = $order->ag_rebate * ($bd_agent_percent / 100);
  1441. $ag_rebate = sprintf("%.2f", $ag_rebate);
  1442. $rate = $bd_agent_percent;
  1443. $desc = '用户' . $saas_user_name . '下单,订单' . $order->order_no . ',发放 ' . $ag_rebate . '元推广代佣金';
  1444. $type = StoreShareMoney::TYPE_BD_AGENT;
  1445. }
  1446. //省
  1447. if ((int)$item['area_level'] === 3) {
  1448. $ag_rebate = $order->ag_rebate * ($province_percent / 100);
  1449. $ag_rebate = sprintf("%.2f", $ag_rebate);
  1450. $rate = $province_percent;
  1451. $desc = '用户' . $saas_user_name . '下单,订单' . $order->order_no . ',发放 ' . $ag_rebate . '元省代佣金';
  1452. }
  1453. //市
  1454. if ((int)$item['area_level'] === 2 && (int)$item['city_id'] === (int)$store->city_id) {
  1455. $ag_rebate = $order->ag_rebate * ($city_percent / 100);
  1456. $ag_rebate = sprintf("%.2f", $ag_rebate);
  1457. $rate = $city_percent;
  1458. $desc = '用户' . $saas_user_name . '下单,订单' . $order->order_no . ',发放 ' . $ag_rebate . '元市代佣金';
  1459. }
  1460. //区
  1461. if ((int)$item['area_level'] === 1 && (int)$item['city_id'] === (int)$store->city_id && (int)$item['district_id'] === (int)$store->district_id) {
  1462. $ag_rebate = $order->ag_rebate * ($district_percent / 100);
  1463. $ag_rebate = sprintf("%.2f", $ag_rebate);
  1464. $rate = $district_percent;
  1465. $desc = '用户' . $saas_user_name . '下单,订单' . $order->order_no . ',发放 ' . $ag_rebate . '元区代佣金';
  1466. }
  1467. if ($ag_rebate <= 0) {
  1468. continue;
  1469. }
  1470. $StoreShareMoney = StoreShareMoney::findOne(['user_id' => $item['saas_user_id'], 'store_id' => $store->id, 'order_id' => $order_id, 'type' => $type]);
  1471. if($StoreShareMoney){
  1472. continue;
  1473. }
  1474. //给用户增加佣金
  1475. $SaasUser = SaasUser::findOne($item['saas_user_id']);
  1476. $SaasUser->share_profit = ($SaasUser->share_profit * 1) + ($ag_rebate * 1);
  1477. $res = $SaasUser->save();
  1478. //增加记录
  1479. if ($res) {
  1480. $form = new StoreShareMoney();
  1481. $form->user_id = $SaasUser->id;
  1482. $form->store_id = $store->id;
  1483. $form->profit = $rate;
  1484. $form->total_price = $order->total_price;
  1485. $form->desc = $desc;
  1486. $form->order_id = $order_id;
  1487. $form->created_at = time();
  1488. $form->type = $type;
  1489. $form->status = StoreShareMoney::STATUS_STORE_ORDER;
  1490. $form->commission = $ag_rebate;
  1491. $form->is_send = 1;
  1492. $res = $form->save();
  1493. if (!$res) {
  1494. debug_log($form->errors);
  1495. }
  1496. }
  1497. }
  1498. return [
  1499. 'code' => 0,
  1500. 'msg' => '处理完成'
  1501. ];
  1502. } catch (\Exception $e) {
  1503. return [
  1504. 'code' => 1,
  1505. 'msg' => $e->getMessage(),
  1506. ];
  1507. }
  1508. }
  1509. /**
  1510. * 推广代理二级佣金
  1511. * @param $order_id
  1512. * @return void
  1513. */
  1514. public function agencyPriceTwo($order_id){
  1515. try {
  1516. if(isset($order_id->id)){
  1517. $order = $order_id;
  1518. }else{
  1519. $order = Order::findOne($order_id);
  1520. }
  1521. $order_id = $order->id;
  1522. //获取代理商ID
  1523. $store = Store::findOne($order->store_id);
  1524. $user = User::findOne($order->user_id);//下单用户
  1525. $saasUser = SaasUser::findOne(['mobile' => $user->binding]);//联盟用户
  1526. $saas_user_name = '-';
  1527. if ($saasUser) {
  1528. $saas_user_name = $saasUser->name;
  1529. }
  1530. //推广代理
  1531. if($store->admin_id){
  1532. // $salesman = Salesman::findOne($store->salesman_id);//业务员
  1533. $bd = Admin::find()->where(['type' => Admin::ADMIN_TYPE_BD_AGENT, 'id' => $store->admin_id])->asArray()->one();
  1534. if($bd){
  1535. $admin_list[] = $bd;
  1536. }
  1537. }
  1538. $saas_transfer_profit = $store->transfer_profit;
  1539. $saas_share_money = round($order->pay_price * $saas_transfer_profit / 100, 2);
  1540. $defaultSet = Option::get(OptionSetting::SHARE_STORE_DEFAULT_SETTING, -1, OptionSetting::SHARE_GROUP_NAME, '{}');
  1541. $defaultSet = json_decode($defaultSet['value'], true);
  1542. if(!empty($defaultSet['store_share_two_value'])){
  1543. $store->store_share_value = $defaultSet['store_share_two_value'];
  1544. }
  1545. if(empty($store->store_share_value)){
  1546. return;
  1547. }
  1548. $saas_store_1_money = floor_num($saas_share_money * ($store->store_share_value / 100), 2);
  1549. foreach ($admin_list as $item) {
  1550. $ag_rebate = 0;
  1551. $rate = 0;
  1552. $desc = '';
  1553. $type = StoreShareMoney::TYPE_BD_AGENT;
  1554. if($item['type'] == Admin::ADMIN_TYPE_BD_AGENT){
  1555. $rate = $store->store_share_value;
  1556. $desc = '用户' . $saas_user_name . '下单,订单' . $order->order_no . ',发放 ' . $saas_store_1_money . '元推广代佣金';
  1557. $type = StoreShareMoney::TYPE_BD_AGENT;
  1558. }
  1559. //给用户增加佣金
  1560. $SaasUser = SaasUser::findOne($item['saas_user_id']);
  1561. $SaasUser->share_profit = ($SaasUser->share_profit * 1) + ($saas_store_1_money * 1);
  1562. $res = $SaasUser->save();
  1563. //增加记录
  1564. if ($res) {
  1565. $form = new StoreShareMoney();
  1566. $form->user_id = $SaasUser->id;
  1567. $form->store_id = $store->id;
  1568. $form->profit = $rate;
  1569. $form->total_price = $order->total_price;
  1570. $form->desc = $desc;
  1571. $form->order_id = $order_id;
  1572. $form->created_at = time();
  1573. $form->type = $type;
  1574. $form->status = StoreShareMoney::STATUS_STORE_ORDER;
  1575. $form->commission = $saas_store_1_money;
  1576. $form->is_send = 1;
  1577. $res = $form->save();
  1578. if (!$res) {
  1579. debug_log($form->errors);
  1580. }
  1581. }
  1582. }
  1583. } catch (\Exception $e) {
  1584. \Yii::error($e->getMessage());
  1585. }
  1586. }
  1587. public function sendGoodsAgentMoney($order_id){
  1588. $t = \Yii::$app->db->beginTransaction();
  1589. try {
  1590. if(isset($order_id->id)){
  1591. $order = $order_id;
  1592. }else{
  1593. $order = Order::findOne($order_id);
  1594. }
  1595. $order_id = $order->id;
  1596. $option = Option::get('goods_agent_price_config', 0, 'saas', [])['value'];
  1597. $option = json_decode($option, true);
  1598. $goods_agent_percent = $option['goods_agent_percent'] ?? 0;
  1599. $goods_agent_install_percent = $option['goods_agent_install_percent'] ?? 0;
  1600. //订单中是否包含产品代理绑定的产品
  1601. $order_detail = OrderDetail::find()->alias('od')
  1602. ->leftJoin(['g' => Goods::tableName()], 'od.goods_id = g.id')->where(['od.order_id' => $order->id])
  1603. ->select('od.id, g.cloud_goods_id, od.total_price, g.cloud_supplier_id, g.name, g.is_wholesale')->asArray()->all();
  1604. foreach ($order_detail as $value) {
  1605. //计算产品代理佣金
  1606. $supplier_rate = 0;
  1607. if (!empty($value['cloud_supplier_id'])) {
  1608. $supplier = Supplier::findOne(['cloud_supplier_id' => $value['cloud_supplier_id']]);
  1609. $supplier_rate = $supplier->rate;
  1610. }
  1611. if (!empty($value['cloud_goods_id']) && !intval($value['is_wholesale'])) {
  1612. //抓取云仓佣金
  1613. $cloud_url = "/goods/getGoodsInfo";
  1614. $cloud_data = [];
  1615. $cloud_data['goods_id'] = $value['cloud_goods_id'];
  1616. $domain = (new OptionSetting)->getCloudDomainName();
  1617. $cloud_info = cloud_post($domain . $cloud_url, $cloud_data);
  1618. $cloud_info = json_decode($cloud_info, true);
  1619. if($cloud_info['code'] != 0){
  1620. throw new \Exception($cloud_info['msg']);
  1621. }else{
  1622. $goods = $cloud_info['data']['goods'];
  1623. $agent_profit_default = (int)$goods['agent_profit_default'];
  1624. if (!$agent_profit_default) {
  1625. $goods_agent_percent = $goods['agent_percent'];
  1626. $goods_agent_install_percent = $goods['agent_install_percent'];
  1627. }
  1628. }
  1629. $agent_goods_bind_goods = AgentGoodsBindGoods::find()->where(['cloud_goods_id' => $value['cloud_goods_id'], 'is_delete' => 0, 'status' => 1])
  1630. ->select('goods_agent_admin_id, cloud_supplier_id')->asArray()->all();
  1631. if (!empty($agent_goods_bind_goods)) {
  1632. $goods_agent_admin_id = array_column($agent_goods_bind_goods, 'goods_agent_admin_id');
  1633. $where = [
  1634. 'id' => $goods_agent_admin_id,
  1635. 'province_id' => $order->province_id
  1636. ];
  1637. $admin = Admin::findOne(array_merge($where, [
  1638. 'area_level' => 1,
  1639. 'city_id' => $order->city_id,
  1640. 'district_id' => $order->district_id
  1641. ]));
  1642. if (empty($admin)) {
  1643. $admin = Admin::findOne(array_merge($where, [
  1644. 'area_level' => 2,
  1645. 'city_id' => $order->city_id
  1646. ]));
  1647. if (empty($admin)) {
  1648. $admin = Admin::findOne(array_merge($where, [
  1649. 'area_level' => 3
  1650. ]));
  1651. }
  1652. }
  1653. if (!empty($admin)) {
  1654. $agent_rebate = $value['total_price'] * ($supplier_rate / 100) * ($goods_agent_percent / 100);
  1655. $StoreShareMoney = StoreShareMoney::find()->where(['user_id' => $admin->saas_user_id, 'store_id' => $order->store_id, 'order_id' => $order_id, 'type' => 1])
  1656. ->andWhere(['like', 'desc', '产品代理佣金发放'])->one();
  1657. if(!$StoreShareMoney){
  1658. //给用户增加佣金
  1659. $SaasUser = SaasUser::findOne($admin->saas_user_id);
  1660. $SaasUser->share_profit = ($SaasUser->share_profit * 1) + ($agent_rebate * 1);
  1661. if (!$SaasUser->save()) {
  1662. throw new \Exception(json_encode($SaasUser->errors));
  1663. }
  1664. $StoreShareMoney = new StoreShareMoney();
  1665. $StoreShareMoney->user_id = $SaasUser->id;
  1666. $StoreShareMoney->store_id = $order->store_id;
  1667. $StoreShareMoney->profit = $goods_agent_percent;
  1668. $StoreShareMoney->total_price = $value['total_price'];
  1669. $StoreShareMoney->desc = '产品代理佣金发放,代理商品' . $value['name'];
  1670. $StoreShareMoney->order_id = $order_id;
  1671. $StoreShareMoney->created_at = time();
  1672. $StoreShareMoney->status = StoreShareMoney::STATUS_STORE_ORDER;
  1673. $StoreShareMoney->type = StoreShareMoney::TYPE_GOODS_AGENT;
  1674. $StoreShareMoney->commission = $agent_rebate;
  1675. $StoreShareMoney->is_send = 1;
  1676. if (!$StoreShareMoney->save()) {
  1677. throw new \Exception(json_encode($StoreShareMoney->errors));
  1678. }
  1679. }
  1680. }
  1681. }
  1682. }
  1683. //计算上门安装佣金
  1684. $install_log = AgentGoodsInstallLog::findOne(['order_detail_id' => $value['id'], 'status' => 2, 'is_need_install' => 1, 'order_type' => AgentGoodsInstallLog::ORDER_TYPE_NORMAL]);
  1685. if (!empty($install_log)) {
  1686. $admin = Admin::findOne($install_log->goods_agent_admin_id);
  1687. if (!empty($admin)) {
  1688. $agent_rebate = $value['total_price'] * ($supplier_rate / 100) * ($goods_agent_install_percent / 100);
  1689. $StoreShareMoney = StoreShareMoney::find()->where(['user_id' => $admin->saas_user_id, 'store_id' => $order->store_id, 'order_id' => $order_id, 'type' => 1])
  1690. ->andWhere(['like', 'desc', '上门安装佣金发放'])->one();
  1691. if(!$StoreShareMoney){
  1692. //给用户增加佣金
  1693. $SaasUser = SaasUser::findOne($admin->saas_user_id);
  1694. $SaasUser->share_profit = ($SaasUser->share_profit * 1) + ($agent_rebate * 1);
  1695. if (!$SaasUser->save()) {
  1696. throw new \Exception(json_encode($SaasUser->errors));
  1697. }
  1698. $StoreShareMoney = new StoreShareMoney();
  1699. $StoreShareMoney->user_id = $SaasUser->id;
  1700. $StoreShareMoney->store_id = $order->store_id;
  1701. $StoreShareMoney->profit = $goods_agent_install_percent;
  1702. $StoreShareMoney->total_price = $value['total_price'];
  1703. $StoreShareMoney->desc = '产品代理上门安装佣金发放,安装商品' . $value['name'];
  1704. $StoreShareMoney->order_id = $order_id;
  1705. $StoreShareMoney->created_at = time();
  1706. $StoreShareMoney->status = StoreShareMoney::STATUS_STORE_ORDER;
  1707. $StoreShareMoney->type = StoreShareMoney::TYPE_GOODS_AGENT;
  1708. $StoreShareMoney->commission = $agent_rebate;
  1709. $StoreShareMoney->is_send = 1;
  1710. if (!$StoreShareMoney->save()) {
  1711. throw new \Exception(json_encode($StoreShareMoney->errors));
  1712. }
  1713. }
  1714. }
  1715. }
  1716. }
  1717. $t->commit();
  1718. } catch (\Exception $e) {
  1719. $t->rollBack();
  1720. \Yii::error($e->getMessage());
  1721. }
  1722. }
  1723. public function workerLevel($order_id) {
  1724. try {
  1725. if(isset($order_id->id)){
  1726. $order = $order_id;
  1727. }else{
  1728. $order = Order::findOne($order_id);
  1729. }
  1730. $order_id = $order->id;
  1731. if(!$order || !$order->is_sale){
  1732. return;
  1733. }
  1734. $WorkerOrderExt = WorkerOrderExt::findOne(['order_id' => $order_id]);
  1735. if(!$WorkerOrderExt || !$WorkerOrderExt->worker_id){
  1736. return;
  1737. }
  1738. $item = Worker::findOne($WorkerOrderExt->worker_id);
  1739. if ($item) {
  1740. $order_ext_price_num = WorkerOrderExt::find()->alias('woe')
  1741. ->leftJoin(['o' => Order::tableName()], 'o.id = woe.order_id')
  1742. ->where(['woe.worker_id' => $item['id'], 'woe.status_ext' => 100])
  1743. ->andWhere(['o.is_delete' => 0, 'o.is_sale' => 1])
  1744. ->select('o.total_price, o.order_type_ext')->asArray()->all();
  1745. $order_num = 0;
  1746. $order_price = 0;
  1747. foreach ($order_ext_price_num as $order_item) {
  1748. if (in_array($order_item['order_type_ext'], [0, Order::ORDER_TYPE_EXT_WORKER_FIRST_PAY])) {
  1749. ++$order_num;
  1750. }
  1751. $order_price += $order_item['total_price'];
  1752. }
  1753. $worker_level = WorkerLevel::find()->where(['store_id' => $order->store_id, 'status' => 1, 'is_delete' => 0])
  1754. ->andWhere(['AND', ['<=', 'order_money', $order_price],['<=', 'order_count', $order_price], ['>', 'level', $item['level']]])
  1755. ->orderBy('level DESC')
  1756. ->asArray()->one();
  1757. if ($worker_level) {
  1758. $current_level = $worker_level['level'];
  1759. if ($current_level) {
  1760. $worker = Worker::findOne($item['id']);
  1761. $worker->level = $current_level;
  1762. $worker->save();
  1763. }
  1764. }
  1765. }
  1766. } catch (\Exception $e) {
  1767. debug_log([__METHOD__, __LINE__, $e->getMessage()], 'worker.log');
  1768. }
  1769. }
  1770. /**
  1771. * 自动取消预约订单
  1772. */
  1773. public function orderBook($order_id) {
  1774. try {
  1775. $order = Order::find()->where(['id' => $order_id, 'is_delete' => 0, 'is_pay' => 0])
  1776. ->andWhere(['<>', 'trade_status', Order::ORDER_FLOW_CANCEL])
  1777. ->andWhere(['in', 'order_type', [1, 2]])->one();
  1778. /* @var Order[] $orders */
  1779. if (!empty($order)) {
  1780. $autoCancleTime = static::getAutoCancelTime($order->store_id);
  1781. if ($autoCancleTime > 0 && time() - $order->created_at >= $autoCancleTime) {
  1782. $order->trade_status = Order::ORDER_FLOW_CANCEL;
  1783. $order->updated_at = time();
  1784. $order->save();
  1785. }
  1786. }
  1787. } catch (\Exception $e) {
  1788. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  1789. }
  1790. }
  1791. public function level($order_id) {
  1792. try {
  1793. if(isset($order_id->id)){
  1794. $order = Order::findOne($order_id->id);
  1795. }else{
  1796. $order = Order::findOne($order_id);
  1797. }
  1798. $order_id = $order->id;
  1799. if(!$order || !$order->is_sale || !$order->user_id){
  1800. return;
  1801. }
  1802. $sum = Order::find()->alias('o')
  1803. ->where(['o.user_id' => $order->user_id, 'o.is_sale' => 1, 'o.is_delete' => 0, 'o.trade_status' => 3])
  1804. ->leftJoin(['r' => OrderRefund::find()->where(['is_delete' => 0, 'store_id' => $order->store_id])->select('*')], "r.order_id=o.id")
  1805. ->andWhere([
  1806. 'or',
  1807. 'isnull(r.id)',
  1808. ['r.type' => 2],
  1809. ['in', 'r.status', [2, 3]]
  1810. ])
  1811. ->sum('o.pay_price');
  1812. $user = User::findOne($order->user_id);
  1813. //查会员等级
  1814. $levelList = Level::find()
  1815. ->where(['store_id' => $order->store_id, 'is_delete' => 0, 'status' => 1])
  1816. // 增加开启了累计消费升级的条件
  1817. ->andWhere(['like', 'upgrade_conditions' , Level::UPGRADE_CONDITIONS_MONEY])
  1818. ->orderBy(['money' => SORT_DESC, 'id' => SORT_DESC])
  1819. ->asArray()->all();
  1820. //调整会员等级
  1821. foreach ($levelList as $level) {
  1822. if ($sum >= $level['money']) {
  1823. if ($user['level'] < $level['level']) {
  1824. $user->level = $level['level'];
  1825. if ($user->save()) {
  1826. \Yii::error(['会员自动升级==============>', $user->id]);
  1827. }
  1828. }
  1829. break;
  1830. }
  1831. }
  1832. } catch (\Exception $e) {
  1833. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  1834. }
  1835. }
  1836. /**
  1837. * 处理过期优惠券
  1838. */
  1839. public function couponTimeout($UserCoupon_id) {
  1840. try {
  1841. $coupon_list = UserCoupon::find()->alias('uc')->where([
  1842. 'uc.id' => $UserCoupon_id,
  1843. 'uc.is_use' => 0,
  1844. 'uc.is_delete' => 0,
  1845. 'uc.is_expire' => 0,
  1846. ])->leftJoin(['c' => Coupon::tableName()], 'c.id=uc.coupon_id')->select('uc.id, uc.begin_time, uc.end_time, c.expire_type')->asArray()->all();
  1847. if (empty($coupon_list)) {
  1848. return;
  1849. }
  1850. foreach ($coupon_list as $value) {
  1851. $delay = 0;
  1852. if ($value['expire_type'] == 1 ) {
  1853. if ($value['end_time'] < 1) {
  1854. continue;
  1855. } else {
  1856. if (time() >= $value['end_time']) {
  1857. UserCoupon::updateAll(['is_expire' => 1, 'updated_at' => time()], [
  1858. 'id' => $value['id'],
  1859. ]);
  1860. continue;
  1861. }else{
  1862. $delay = $value['end_time'] - time();
  1863. }
  1864. }
  1865. }
  1866. if ($value['expire_type'] == 2) {
  1867. if (time() >= strtotime(date('Y-m-d 23:59:59', $value['end_time']))) {
  1868. UserCoupon::updateAll(['is_expire' => 1, 'updated_at' => time()], [
  1869. 'id' => $value['id'],
  1870. ]);
  1871. continue;
  1872. }else{
  1873. $delay = strtotime(date('Y-m-d 23:59:59', $value['end_time'])) - time();
  1874. }
  1875. }
  1876. if($delay){
  1877. \queue_push(new \app\jobs\CouponTimeoutJob(['userCoupon_id' => $UserCoupon_id]), $delay);
  1878. }
  1879. }
  1880. } catch (\Exception $e) {
  1881. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  1882. }
  1883. }
  1884. /**
  1885. * 用户自动成为分销商
  1886. * @param $user_id integer 用户id
  1887. */
  1888. public function userAutoBecomeShare($user_id)
  1889. {
  1890. try {
  1891. $item = User::findOne($user_id);
  1892. if(!$item){
  1893. return;
  1894. }
  1895. $store_id = $item->store_id;
  1896. $share_basic_setting = Option::get(OptionSetting::SHARE_BASIC_SETTING, $store_id, OptionSetting::SHARE_GROUP_NAME, '')['value'];
  1897. $share_basic_setting = json_decode($share_basic_setting, true);
  1898. //
  1899. $share_basic_setting['share_condition']['value'] = $share_basic_setting['share_condition']['value'] ?? 2;
  1900. $share_basic_setting['auto_share_val']['value'] = $share_basic_setting['auto_share_val']['value'] ?? 0;
  1901. //判断无需审核且消费0元成为分销商条件
  1902. if (intval($share_basic_setting['share_condition']['value']) === 2 && floatval($share_basic_setting['auto_share_val']['value']) <= 0) {
  1903. //筛出已经成为分销商的用户
  1904. $filter_user_id = Share::find()->where(['user_id' => $user_id, 'is_delete' => 0, 'store_id' => $store_id, 'status' => 1])->select('user_id')->one();
  1905. if($filter_user_id){
  1906. return;
  1907. }
  1908. //筛出已经被删除的分销商
  1909. $filter_delete_user_id = Share::find()->where(['user_id' => $user_id, 'is_delete' => 1, 'store_id' => $store_id, 'status' => 1])->select('user_id')->one();
  1910. if($filter_delete_user_id){
  1911. return;
  1912. }
  1913. $share = Share::findOne(['user_id' => $item->id, 'is_delete' => 0, 'store_id' => $store_id]);
  1914. if (!$share) {
  1915. $share = new Share();
  1916. $share->mobile = '';
  1917. $share->name = '';
  1918. $share->is_delete = 0;
  1919. $share->user_id = $item->id;
  1920. $share->created_at = time();
  1921. }
  1922. $share->status = 1;
  1923. $share->store_id = $store_id;
  1924. if ($share->save()) {
  1925. $item->time = time();
  1926. $item->is_distributor = 1;
  1927. $item->save();
  1928. }
  1929. }
  1930. } catch (\Exception $e) {
  1931. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  1932. }
  1933. }
  1934. /**
  1935. * 认养成熟超时自动设置农场代采
  1936. */
  1937. public function AdoptOrderMature($order) {
  1938. try {
  1939. if(is_numeric($order)){
  1940. $order = AdoptOrderInfo::findOne($order);
  1941. }
  1942. $time = time();
  1943. $AdoptSetting = AdoptSetting::findOne([ 'store_id' => $order->store_id,]);
  1944. $mature_overtime = $AdoptSetting->mature_overtime;
  1945. $mature_time = $time - ($mature_overtime * 86400);
  1946. if($order->pick_method == AdoptOrderInfo::ORDER_FLOW_NO_PICK){
  1947. if($order->mature_time <= $mature_time){
  1948. $order->pick_method = AdoptOrderInfo::ORDER_FLOW_OTHER_PICK;
  1949. $order->pick_time = $order->mature_time + ($mature_overtime * 86400);
  1950. $order->pick_treatment_method = AdoptOrderInfo::ORDER_FLOW_PICK_STORAGE;
  1951. $order->pick_treatment_method_time = time();
  1952. $order->save();
  1953. }else{
  1954. \queue_push(new \app\jobs\order\AdoptOrderMatureJob(['order_id' => $order->id]), $mature_time - $order->mature_time);
  1955. }
  1956. }
  1957. } catch (\Exception $e) {
  1958. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  1959. }
  1960. }
  1961. /**
  1962. * 认养入库超时自动设置保管
  1963. */
  1964. public function AdoptOrderStorage($order) {
  1965. try {
  1966. if(is_numeric($order)){
  1967. $order = AdoptOrderInfo::findOne($order);
  1968. }
  1969. $time = time();
  1970. $AdoptSetting = AdoptSetting::findOne([ 'store_id' => $order->store_id,]);
  1971. $storage_overtime = $AdoptSetting->storage_overtime;
  1972. $storage_time = $time - ($storage_overtime * 86400);
  1973. if($order->is_preserve == AdoptOrderInfo::ORDER_FLOW_WAIT_PRESERVE){
  1974. if($order->storage_time <= $storage_time){
  1975. $order->is_preserve = AdoptOrderInfo::ORDER_FLOW_PRESERVE;
  1976. $order->preserve_time = $order->storage_time + ($storage_overtime * 86400);
  1977. $order->save();
  1978. }else{
  1979. \queue_push(new \app\jobs\order\AdoptOrderStorageJob(['order_id' => $order->id]), $storage_time - $order->storage_time);
  1980. }
  1981. }
  1982. } catch (\Exception $e) {
  1983. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  1984. }
  1985. }
  1986. /**
  1987. * 认养免费保管结束开始计费
  1988. */
  1989. public function AdoptOrderBillingStart($order) {
  1990. try {
  1991. if(is_numeric($order)){
  1992. $order = AdoptOrderInfo::findOne($order);
  1993. }
  1994. $time = time();
  1995. $AdoptSetting = AdoptSetting::findOne(['store_id' => $order->store_id,]);
  1996. $free_preserve_time = $AdoptSetting->free_preserve_time;
  1997. $preserve_time = $time - ($free_preserve_time * 86400);
  1998. if($order->is_preserve == AdoptOrderInfo::ORDER_FLOW_PRESERVE){
  1999. if($order->preserve_time <= $preserve_time){
  2000. $order->billing_start_time = $order->preserve_time + ($free_preserve_time * 86400);
  2001. $order->save();
  2002. }else{
  2003. \queue_push(new \app\jobs\order\AdoptOrderBillingStartJob(['order_id' => $order->id]), $preserve_time - $order->preserve_time);
  2004. }
  2005. }
  2006. } catch (\Exception $e) {
  2007. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2008. }
  2009. }
  2010. /**
  2011. * 认养成熟超时提示信息 (提示成熟超时要自动代采入库)
  2012. */
  2013. public function AdoptOrderMatureTips($order) {
  2014. try {
  2015. if(is_numeric($order)){
  2016. $order = AdoptOrderInfo::findOne($order);
  2017. }
  2018. $time = time();
  2019. $AdoptSetting = AdoptSetting::findOne([ 'store_id' => $order->store_id,]);
  2020. $mature_overtime_tips = $AdoptSetting->mature_overtime_tips;
  2021. $mature_time = $time - ($mature_overtime_tips * 86400);
  2022. $mature_overtime = $AdoptSetting->mature_overtime;
  2023. if($order->is_sms_mature){
  2024. return;
  2025. }
  2026. if($order->pick_method == AdoptOrderInfo::ORDER_FLOW_NO_PICK){
  2027. if($order->mature_time <= $mature_time){
  2028. $order_relevance = Order::findOne(['id'=>$order->order_id]);
  2029. $order->is_sms_mature = 1;
  2030. $order->save();
  2031. //查看已成熟几天。几天后系统自动设置
  2032. $day1 = ceil(time() - $order->mature_time);
  2033. $day2 = $mature_overtime -$day1;
  2034. NoticeSend::Adopt($order_relevance->user_id, $order->mobile, $order_relevance->order_no, $order->name, 1,$day1,$day2);
  2035. }else{
  2036. \queue_push(new \app\jobs\order\AdoptOrderMatureTipsJob(['order_id' => $order->id]), $mature_time - $order->mature_time);
  2037. }
  2038. }
  2039. } catch (\Exception $e) {
  2040. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2041. }
  2042. }
  2043. /**
  2044. * 认养入库超时提示信息 (提示入库过期要自动保管)
  2045. */
  2046. public function AdoptOrderStorageTips($order) {
  2047. try {
  2048. if(is_numeric($order)){
  2049. $order = AdoptOrderInfo::findOne($order);
  2050. }
  2051. $time = time();
  2052. $AdoptSetting = AdoptSetting::findOne([ 'store_id' => $order->store_id,]);
  2053. $storage_overtime_tips = $AdoptSetting->storage_overtime_tips;
  2054. $storage_time = $time - ($storage_overtime_tips * 86400);
  2055. $storage_overtime = $AdoptSetting->mature_overtime;
  2056. if($order->is_sms_storage){
  2057. return;
  2058. }
  2059. if($order->is_preserve == AdoptOrderInfo::ORDER_FLOW_WAIT_PRESERVE){
  2060. if($order->storage_time <= $storage_time){
  2061. $order_relevance = Order::findOne(['id'=>$order->order_id]);
  2062. $order->is_sms_storage = 1;
  2063. $order->save();
  2064. //查看已成熟几天。几天后系统自动设置
  2065. $day1 = ceil(time() - $order->storage_time);
  2066. $day2 = $storage_overtime -$day1;
  2067. NoticeSend::Adopt($order_relevance->user_id, $order->mobile, $order_relevance->order_no, $order->name, 2,$day1,$day2);
  2068. }else{
  2069. \queue_push(new \app\jobs\order\AdoptOrderStorageTipsJob(['order_id' => $order->id]), $storage_time - $order->storage_time);
  2070. }
  2071. }
  2072. } catch (\Exception $e) {
  2073. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2074. }
  2075. }
  2076. /**
  2077. * 认养免费保管提示信息 (提示从开始保管时间算免费保管超时)
  2078. */
  2079. public function AdoptOrderBillingTips($order) {
  2080. try {
  2081. if(is_numeric($order)){
  2082. $order = AdoptOrderInfo::findOne($order);
  2083. }
  2084. $time = time();
  2085. $AdoptSetting = AdoptSetting::findOne([ 'store_id' => $order->store_id,]);
  2086. $preserve_time_tips = $AdoptSetting->free_preserve_time_tips;
  2087. $preserve_time = $time - ($preserve_time_tips * 86400);
  2088. $preserve = $AdoptSetting->free_preserve_time;
  2089. if($order->is_sms_preserve){
  2090. return;
  2091. }
  2092. if($order->is_preserve == AdoptOrderInfo::ORDER_FLOW_PRESERVE){
  2093. if($order->preserve_time <= $preserve_time){
  2094. $order_relevance = Order::findOne(['id'=>$order->order_id]);
  2095. $order->is_sms_preserve = 1;
  2096. $order->save();
  2097. //查看已成熟几天。几天后系统自动设置
  2098. $day1 = ceil(time() - $order->preserve_time);
  2099. $day2 = $preserve -$day1;
  2100. NoticeSend::Adopt($order_relevance->user_id, $order->mobile, $order_relevance->order_no, $order->name, 3,$day1,$day2);
  2101. }else{
  2102. \queue_push(new \app\jobs\order\AdoptOrderBillingTipsJob(['order_id' => $order->id]), $preserve_time - $order->preserve_time);
  2103. }
  2104. }
  2105. } catch (\Exception $e) {
  2106. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2107. }
  2108. }
  2109. /**
  2110. * 自动取消认养配送订单
  2111. */
  2112. public function adoptCostOrderCancel($order) {
  2113. try {
  2114. if(is_numeric($order)){
  2115. $order = AdoptCostOrder::findOne($order);
  2116. }
  2117. $time = time();
  2118. $over_time = Option::get(OptionSetting::STORE_DELIVERY_TIME, $order->store_id)['value'];
  2119. if (!$over_time) {
  2120. $over_time = 1;
  2121. }
  2122. $over_day = $time - ($over_time * 86400);
  2123. if($order->is_pay || $order->trade_status == Order::ORDER_FLOW_CANCEL || $order->pay_type == 2){
  2124. return;
  2125. }
  2126. if($order->created_at <= $over_day){
  2127. $t = \Yii::$app->db->beginTransaction();
  2128. if ($order->order_type == 1) {
  2129. $adopt_order = AdoptOrderInfo::find()->where(['order_id' => $order->order_id, 'is_delete' => 0, 'store_id' => $order->store_id,])->one();
  2130. $adopt_order->updateCounters(['harvest_weight' => $order->weight]);
  2131. }
  2132. $order->trade_status = Order::ORDER_FLOW_CANCEL;
  2133. $order->updated_at = time();
  2134. if (!$order->save()) {
  2135. $t->rollBack();
  2136. return;
  2137. }
  2138. $t->commit();
  2139. }else{
  2140. \queue_push(new \app\jobs\order\AdoptCostOrderCancelJob(['order_id' => $order->id]), $over_day - $order->created_at);
  2141. }
  2142. } catch (\Exception $e) {
  2143. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2144. }
  2145. }
  2146. /**
  2147. * 认养配送订单自动收货
  2148. */
  2149. public function adoptCostOrderConfirm($order) {
  2150. try {
  2151. if(is_numeric($order)){
  2152. $order = AdoptCostOrder::findOne($order);
  2153. }
  2154. $time = time();
  2155. $delivery_time = Option::get(OptionSetting::STORE_DELIVERY_TIME, $order->store_id)['value'];
  2156. $delivery_time = $time - ((int)$delivery_time * 86400);
  2157. if($order->is_delete || $order->trade_status == Order::ORDER_FLOW_CONFIRM){
  2158. return;
  2159. }
  2160. if($order->send_time <= $delivery_time){
  2161. $adopt_order_info = AdoptOrderInfo::find()->alias('aoi')
  2162. ->where([
  2163. 'aoi.order_id' => $order->order_id,
  2164. 'aoi.store_id' => $order->store_id,
  2165. 'aoi.harvest_weight' => 0
  2166. ])->one();
  2167. if ($adopt_order_info->harvest_weight == 0) {
  2168. $adopt_order = Order::find()->alias('o')
  2169. ->where([
  2170. 'o.id' => $order->order_id,
  2171. 'o.store_id' => $order->store_id,
  2172. 'o.order_type' => 5,
  2173. ])->one();
  2174. $adopt_order->trade_status = Order::ORDER_FLOW_CONFIRM;
  2175. $adopt_order->save();
  2176. $goods = Goods::findOne(OrderDetail::findOne(['order_id' => $order->order_id])->goods_id);
  2177. NoticeSend::AdoptOrderStateChange($adopt_order->user_id, $adopt_order_info->mobile, $adopt_order->order_no, $goods->name, 13);
  2178. }
  2179. AdoptCostOrder::updateAll(['trade_status' => Order::ORDER_FLOW_CONFIRM, 'confirm_time' => time()], ['id' => $order->id]);
  2180. if ($order->pay_type == 2) {
  2181. $order->is_pay = 1;
  2182. $order->save();
  2183. }
  2184. }else{
  2185. \queue_push(new \app\jobs\order\AdoptCostOrderConfirmJob(['order_id' => $order->id]), $delivery_time - $order->send_time);
  2186. }
  2187. } catch (\Exception $e) {
  2188. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2189. }
  2190. }
  2191. //处理秒杀逻辑 如果15分钟内没有支付订单,则恢复库存
  2192. public function seckillActivityOrder($order)
  2193. {
  2194. try {
  2195. if(is_numeric($order)){
  2196. $order = SeckillActivityOrderLog::findOne($order);
  2197. }
  2198. $order_relevance = Order::findOne(['id'=>$order->order_id]);
  2199. if($order->is_delete){
  2200. return;
  2201. }
  2202. $timeout = time() - (60 * 15);
  2203. if($order_relevance->trade_status == 1 || $order_relevance->is_pay == 0){
  2204. if($order->created_at <= $timeout){
  2205. $goods = SeckillActivityGoods::findOne(['is_delete' => 0, 'goods_id' => $order->goods_id, 'activity_id' => $order->activity_id]);
  2206. // 只退了销量
  2207. if ($goods) {
  2208. $goods->sale_num -= $order->num;
  2209. if (!$goods->save()) {
  2210. throw new \Exception(json_encode($goods->errors));
  2211. }
  2212. }
  2213. // 退库存
  2214. $order_detail_relevance = OrderDetail::findOne(['id' => $order->order_detail_id]);
  2215. $goods->numAdd(array_column(json_decode($order_detail_relevance->attr,true),'attr_id'), $order_detail_relevance->num);
  2216. $order->is_delete = 1;
  2217. if (!$order->save()) {
  2218. throw new \Exception(json_encode($order->errors));
  2219. }
  2220. }else{
  2221. \queue_push(new \app\jobs\order\SeckillActivityOrderJob(['order_id' => $order->id]), 60*15);
  2222. }
  2223. }
  2224. } catch (\Exception $e) {
  2225. \Yii::error("秒杀逻辑处理" . $e->getMessage());
  2226. // return [
  2227. // 'code' => 1,
  2228. // 'msg' => $e->getMessage()
  2229. // ];
  2230. }
  2231. }
  2232. //处理拼团逻辑 如果15分钟内没有支付订单,则恢复库存,如果对应时间未拼团则退款
  2233. public function PtActivityOrder($order)
  2234. {
  2235. try {
  2236. if(is_numeric($order)){
  2237. $order = PtActivityOrder::findOne($order);
  2238. }
  2239. $PtActivityOrderDetail = PtActivityOrderDetail::findOne(['order_id' => $order->id]);
  2240. if($order->is_pay != 1 || $order->trade_status != 0 || $order->is_pt_finish != 0 || $order->pt_number != 0){
  2241. return;
  2242. }
  2243. $activity = PtActivity::findOne($PtActivityOrderDetail['activity_id']);
  2244. $split_time = ($activity->split_time * 60 * 60);
  2245. $delay = 0;
  2246. if (time() - $split_time < $order['pay_time']) {
  2247. $delay = $order['pay_time'] - (time() - $split_time);
  2248. }
  2249. $delay1 = 0;
  2250. if ($activity->end_time > time()) {
  2251. $delay1 = $activity->end_time - time();
  2252. }
  2253. if($delay || $delay1){
  2254. $delay = $delay < $delay1 ? $delay : $delay1;
  2255. }
  2256. //已经过期,需要失败处理
  2257. if (!$delay) {
  2258. $pt_order_ = PtActivityOrder::find()->where(['is_pay' => 1])
  2259. ->andWhere(['OR', ['id' => $order['id']], ['pt_number' => $order['id']]])
  2260. ->select('id')->asArray()->all();
  2261. foreach ($pt_order_ as $item) {
  2262. $order = PtActivityOrder::findOne($item['id']);
  2263. if ($order->head_integral > 0 && intval($order->head_integral_status) === 1) {
  2264. $res = AccountLog::saveLog($order->user_id, floatval($order->head_integral), AccountLog::TYPE_INTEGRAL, AccountLog::LOG_TYPE_INCOME, 3, $order->id, "商城拼团失败,退还开团支付积分,订单号为:{$order->order_no}。");
  2265. if (!$res) {
  2266. debug_log('开团积分退款失败' . json_encode($res), 'ptOrderLog.log');
  2267. }
  2268. $order->head_integral_status = 2;
  2269. }
  2270. $order->is_pt_finish = 2;
  2271. $order->save();
  2272. }
  2273. $form = new PtActivityOrderForm();
  2274. $result = $form->loserHandle($order['id']);
  2275. if ($result['code'] !== 0) {
  2276. throw new \Exception($result['msg']);
  2277. }
  2278. }else{
  2279. \queue_push(new \app\jobs\order\PtActivityOrderJob(['order_id' => $order->id]), $delay);
  2280. }
  2281. } catch (\Exception $e) {
  2282. \Yii::error("拼团逻辑处理" . $e->getMessage());
  2283. // return [
  2284. // 'code' => 1,
  2285. // 'msg' => $e->getMessage()
  2286. // ];
  2287. }
  2288. }
  2289. /**
  2290. * 同城配送订单处理
  2291. */
  2292. public function LocalDeliveryOrder($DeliveryInfo)
  2293. {
  2294. try{
  2295. if(is_numeric($DeliveryInfo)){
  2296. $DeliveryInfo = DeliveryInfo::findOne($DeliveryInfo);
  2297. }
  2298. if(!$DeliveryInfo || !$DeliveryInfo->is_local || !$DeliveryInfo->local_status || !$DeliveryInfo->rider_id){
  2299. return;
  2300. }
  2301. $order = Order::findOne(['order_no' => $DeliveryInfo->order_no]);
  2302. if(!$order || $order->is_delete || (!$order->is_pay && $order->pay_type != Order::PAY_TYPE_COD)){
  2303. return;
  2304. }
  2305. \Yii::warning(['---- Order Event BEGIN 自动派单发放开始 localDeliveryOrder ----']);
  2306. $time = time();
  2307. $local_type = Option::get(OptionSetting::STORE_LOCAL_TYPE, $DeliveryInfo->store_id, 'store')['value'];
  2308. $local_type = Option::get(OptionSetting::STORE_LOCAL_TYPE, $DeliveryInfo->store_id, 'pay', $local_type)['value'];
  2309. $store_id = 0;
  2310. if (intval($DeliveryInfo->is_store_delivery_type)) {
  2311. $store_id = $DeliveryInfo->store_id;
  2312. }
  2313. $values = Option::find()->where([
  2314. 'store_id' => $store_id,
  2315. 'group' => OptionSetting::LOCAL_DELIVERY_GROUP_NAME, 'name' => OptionSetting::LOCAL_DELIVERY_SETTING
  2316. ])->select('value')->one();
  2317. if ($values) {
  2318. $local_setting = json_decode($values->value, true);
  2319. } else {
  2320. $local_setting = null;
  2321. }
  2322. $open_auth = false;
  2323. if (!empty($local_setting['send_type']['value'])) {//商城没有配送
  2324. if ($local_setting['send_type']['value'] == 'auto') { //开启自动派单
  2325. $open_auth = true;
  2326. }
  2327. }
  2328. if (!$open_auth) {
  2329. return false;
  2330. }
  2331. // if ($local_setting['send_type']['value'] != 'auto') { //未开启自动派单
  2332. // \Yii::warning(['---- Order Event BEGIN 平台未开启自动派单 localDeliveryOrder ----']);
  2333. // return false;
  2334. // }
  2335. $default_time = $local_setting['default_time']['value']; //默认预计送达所消耗的时间,例:30分钟
  2336. $delay = 0;
  2337. if($order->delivery_time > bcadd($time, bcmul($default_time, 60, 0), 0)){
  2338. $delay = $order->delivery_time - bcadd($time, bcmul($default_time, 60, 0), 0);
  2339. }
  2340. if(!$delay){
  2341. $this->autoSendDeliveryOrder($order);
  2342. }else{
  2343. \queue_push(new \app\jobs\order\LocalDeliveryOrderJob(['DeliveryInfo_id' => $DeliveryInfo->id]), $delay);
  2344. }
  2345. } catch (\Exception $e) {
  2346. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2347. }
  2348. }
  2349. /**
  2350. * 模块名:autoSendDeliveryOrder
  2351. * 代码描述:平台自配的同城订单自动派单
  2352. * 作者:WPing丶
  2353. * 请求方式:GET
  2354. * 创建时间:2023/07/04 16:39:37
  2355. * @param object order
  2356. */
  2357. public function autoSendDeliveryOrder($order)
  2358. {
  2359. try{
  2360. \Yii::warning(['---- Order Event BEGIN 平台自动派单开始,order_id='.$order->id.' ----']);
  2361. if ($order->is_delivery != 1) { //非同城订单
  2362. \Yii::warning(['---- Order Event BEGIN 非同城订单,order_id='.$order->id.' ----']);
  2363. return false;
  2364. }
  2365. $values = Option::find()->where([
  2366. 'store_id' => 0,
  2367. 'group' => OptionSetting::LOCAL_DELIVERY_GROUP_NAME, 'name' => OptionSetting::LOCAL_DELIVERY_SETTING
  2368. ])->select('value')->one();
  2369. if ($values) {
  2370. $local_setting = json_decode($values->value, true);
  2371. } else {
  2372. $local_setting = null;
  2373. }
  2374. $default_time = $local_setting['default_time']['value'];
  2375. if ((time() + ($default_time * 60)) < $order->delivery_time) { //期望送达时间提前30分钟分配订单
  2376. \Yii::warning(['---- Order Event BEGIN 当前订单时间小于期望送达时间,order_id='.$order->id.' ----']);
  2377. return false;
  2378. }
  2379. $delivery_info = DeliveryInfo::findOne(['order_no' => $order->order_no]);
  2380. if ($delivery_info->is_local == DeliveryInfo::IS_LOCAL_NO) { //非平台自配
  2381. \Yii::warning(['---- Order Event BEGIN 当前订单非平台自配订单,order_id='.$order->id.' ----']);
  2382. return false;
  2383. }
  2384. if ($delivery_info->is_store_delivery_type == 1) { //商城自配
  2385. \Yii::warning(['---- Order Event BEGIN 当前订单为商城自配订单,order_id='.$order->id.' ----']);
  2386. return false;
  2387. }
  2388. $option = Option::find()->where(['store_id' => 0, 'group' => OptionSetting::LOCAL_DELIVERY_GROUP_NAME, 'name' => OptionSetting::LOCAL_DELIVERY_SETTING])->select('value')->one();
  2389. if ($option) {
  2390. $setting = json_decode($option->value, true);
  2391. } else {
  2392. $setting = null;
  2393. }
  2394. if ($setting['send_type']['value'] != 'auto') { //未开启自动派单
  2395. \Yii::warning(['---- Order Event BEGIN 平台未开启自动派单,order_id='.$order->id.' ----']);
  2396. return false;
  2397. }
  2398. //获取可配送此订单的配送员列表
  2399. $query = LocalDeliveryCourier::find()
  2400. ->where([
  2401. 'is_delete' => 0,
  2402. 'state' => 2,
  2403. 'status' => 1
  2404. ]);
  2405. /* 2023年7月6日20:17:11 */
  2406. //配送员筛选条件:配送订单自动推送给负责本村的配送员
  2407. $province_id = $order->province_id ? $order->province_id : 0;
  2408. $city_id = $order->city_id ? $order->city_id : 0;
  2409. $district_id = $order->district_id ? $order->district_id : 0;
  2410. $town_id = $order->town_id ? $order->town_id : 0;
  2411. $village_id = $order->village_id ? $order->village_id : 0;
  2412. $area = '[{"province_id":"' . $province_id . '","city_id":"' . $city_id . '","district_id":"' . $district_id . '","town_id":"' . $town_id . '","village_id":"' . $village_id . '"}]';
  2413. $query->andWhere(['area' => $area]);
  2414. /* end */
  2415. //删除该配置 默认为店铺模式
  2416. // if ($setting['delivery_type']['value'] == "store") { //店铺模式:开启该模式只有店铺的“专属配送员”或者“平台配送员”才可以配送此订单
  2417. $query->andWhere(['type' => 1]);
  2418. // }
  2419. $courier_list = $query->asArray()->all();
  2420. $courier_list_new = [];
  2421. foreach ($courier_list as $courier) {
  2422. //获取当前配送员正在配送的订单数量
  2423. $now_order_num = DeliveryInfo::find()
  2424. ->alias('di')
  2425. ->leftJoin(['o' => Order::tableName()], 'o.order_no = di.order_no')
  2426. ->where(['di.rider_id' => $courier['id'], 'di.is_local' => 1, 'o.is_pay' => 1])
  2427. ->andWhere([
  2428. 'or',
  2429. ['o.trade_status' => 0],
  2430. ['o.trade_status' => 1]
  2431. ])->count();
  2432. if ($courier['max_num'] == 0 || $now_order_num < $courier['max_num']) { //排除掉订单满载的配送员
  2433. $work_time = json_decode($courier['work_time'],true);
  2434. $begin_time = strtotime(date('Y-m-d ').$work_time[0]['begin_time']);
  2435. $end_time = strtotime(date('Y-m-d ').$work_time[0]['end_time']);
  2436. if (time() >= $begin_time && time() <= $end_time ) {//排除不在上岗时间的配送员
  2437. $courier_list_new[] = $courier;
  2438. }
  2439. }
  2440. }
  2441. if (count($courier_list_new) == 0) { //没有满足条件的配送员
  2442. \Yii::warning(['---- Order Event BEGIN 平台没有满足条件的配送员,order_id='.$order->id.' ----']);
  2443. return false;
  2444. }
  2445. //随机选择一名天选打工人给他分配订单(目前是随机,后期再优化)
  2446. $t = \Yii::$app->db->beginTransaction(); //开始事务
  2447. $randomKey = array_rand($courier_list_new);
  2448. $chosen_worker = $courier_list_new[$randomKey];
  2449. $delivery_info->rider_id = $chosen_worker['id'];
  2450. $delivery_info->rider_name = $chosen_worker['real_name'];
  2451. $delivery_info->rider_mobile = $chosen_worker['mobile'];
  2452. $delivery_info->local_status = DeliveryInfo::LOCAL_STATUS_WAITING;
  2453. $delivery_info->rush_time = time();
  2454. if (!$delivery_info->save()) {
  2455. \Yii::warning(['---- Order Event BEGIN 存delivery_info表失败,order_id='.$order->id.' ----']);
  2456. $t->rollBack(); //事务回滚
  2457. return false;
  2458. }
  2459. $order->send_time = time();
  2460. $order->trade_status = 2;
  2461. if (!$order->save()) {
  2462. \Yii::warning(['---- Order Event BEGIN 存order表失败,order_id='.$order->id.' ----']);
  2463. $t->rollBack(); //事务回滚
  2464. return false;
  2465. }
  2466. \Yii::warning(['---- Order Event END 自动派单成功,order_id='.$order->id.' ----']);
  2467. $t->commit(); //事务执行
  2468. } catch (\Exception $e) {
  2469. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2470. }
  2471. }
  2472. //分销商升级
  2473. public function shareLevel($store_id, $user_id) {
  2474. try {
  2475. // 1 parent_id = u
  2476. // 2 parent_id = a a parent_id = u
  2477. // 3 parent_id = b c parent_id = d d parent_id = u
  2478. $share_level = ShareLevel::find()->where(['store_id' => $store_id, 'is_delete' => ShareLevel::SHARE_NOT_DELETE, 'status' => ShareLevel::STATUS_ON, 'is_auto_upgrade' => ShareLevel::AUTO_UPGRADE])
  2479. ->orderBy('level ASC')->asArray()->all();
  2480. foreach ($share_level as $level) {
  2481. $user_info = Share::find()->where(['store_id' => $store_id, 'user_id' => $user_id, 'status' => Share::SHARE_AUDIT_PASS, 'is_delete' => Share::SHARE_NOT_DELETE])
  2482. ->andWhere(['<', 'level', $level['level']])->select('id, user_id, level')->asArray()->one();
  2483. $level['type'] = intval($level['type']);
  2484. $open = false;
  2485. $type = 0;
  2486. $value = 0;
  2487. //团队人数
  2488. if ($level['type'] === ShareLevel::TYPE_MEMBER) {
  2489. $user_count = User::find()->where(['old_parent_id' => $user_info['user_id'], 'is_delete' => User::USER_NOT_DELETE, 'store_id' => $store_id, 'is_distributor' => 1])
  2490. ->select('id')->count() ?? 0;
  2491. if (intval($level['value']) <= $user_count) {
  2492. $open = true;
  2493. $type = ShareLevel::TYPE_MEMBER;
  2494. $value = $user_count;
  2495. }
  2496. }
  2497. //累计佣金
  2498. if ($level['type'] === ShareLevel::TYPE_COMMISSION) {
  2499. $user_share_money = UserShareMoney::find()->where(['type' => 0, 'is_delete' => 0, 'user_id' => $user_info['user_id'], 'store_id' => $store_id])
  2500. ->select('money')->sum('money') ?? 0;
  2501. if (intval($level['value']) <= $user_share_money) {
  2502. $open = true;
  2503. $type = ShareLevel::TYPE_COMMISSION;
  2504. $value = $user_share_money;
  2505. }
  2506. }
  2507. //累计提现佣金
  2508. if ($level['type'] === ShareLevel::TYPE_SEND_COMMISSION) {
  2509. $cash_table_name = Cash::tableName();
  2510. $sql = "SELECT SUM(`price`) FROM {$cash_table_name} WHERE
  2511. `cash_type` = :is_cash_type_share AND
  2512. `user_id` = {$user_info['user_id']} AND
  2513. (
  2514. `status` = :status_given AND
  2515. (
  2516. (
  2517. `type` = :type_wx AND
  2518. `pay_type` = :pay_type_wx AND
  2519. (
  2520. `wx_cash_type` = :wx_cash_type_old AND
  2521. `wx_cash_status` = :wx_cash_status_success
  2522. ) OR
  2523. (
  2524. `wx_cash_type` = :wx_cash_type_new AND
  2525. `wx_cash_state` = 'SUCCESS'
  2526. )
  2527. ) OR
  2528. `pay_type` <> :pay_type_wx
  2529. ) OR `status` = :status_hand )";
  2530. $user_share_money_ = \Yii::$app->db->createCommand($sql, [
  2531. 'is_cash_type_share' => Cash::IS_CASH_TYPE_SHARE,
  2532. 'status_given' => Cash::STATUS_GIVEN,
  2533. 'type_wx' => Cash::TYPE_WX,
  2534. 'pay_type_wx' => Cash::PAY_TYPE_WX,
  2535. 'wx_cash_type_old' => Cash::WX_CASH_TYPE_OLD,
  2536. 'wx_cash_status_success' => Cash::WX_CASH_STATUS_SUCCESS,
  2537. 'wx_cash_type_new' => Cash::WX_CASH_TYPE_NEW,
  2538. 'status_hand' => Cash::STATUS_HAND
  2539. ])->queryScalar();
  2540. // $user_share_money_ = UserShareMoney::find()->where(['type' => 1, 'is_delete' => 0, 'user_id' => $user_info['user_id'], 'store_id' => $store_id])
  2541. // ->select('money')->sum('money') ?? 0;
  2542. if (intval($level['value']) <= $user_share_money_) {
  2543. $open = true;
  2544. $type = ShareLevel::TYPE_SEND_COMMISSION;
  2545. $value = $user_share_money_;
  2546. }
  2547. }
  2548. //累计消费金额
  2549. if ($level['type'] === ShareLevel::TYPE_AMOUNT) {
  2550. $user_pay_price = Order::find()->where(['is_pay' => 1, 'is_delete' => 0, 'user_id' => $user_info['user_id'], 'store_id' => $store_id])
  2551. ->andWhere(['trade_status' => [Order::ORDER_FLOW_NO_SEND, Order::ORDER_FLOW_SEND, Order::ORDER_FLOW_CONFIRM]])
  2552. ->select('pay_price')->sum('pay_price') ?? 0;
  2553. if (intval($level['value']) <= $user_pay_price) {
  2554. $open = true;
  2555. $type = ShareLevel::TYPE_AMOUNT;
  2556. $value = $user_pay_price;
  2557. }
  2558. }
  2559. if ($open) {
  2560. $share = Share::findOne($user_info['id']);
  2561. $share->level = $level['level'];
  2562. if ($share->save()) {
  2563. $log = new ShareLevelLog();
  2564. $log->level = $level['level'];
  2565. $log->old_level = $user_info['level'];
  2566. $log->type = $type;
  2567. $log->value = $value;
  2568. $log->store_id = $store_id;
  2569. $log->user_id = $user_info['user_id'];
  2570. $log->save();
  2571. }
  2572. }
  2573. }
  2574. return [
  2575. 'code' => 0,
  2576. 'msg' => '处理完成'
  2577. ];
  2578. } catch (\Exception $e) {
  2579. return [
  2580. 'code' => 1,
  2581. 'msg' => $e->getMessage()
  2582. ];
  2583. }
  2584. }
  2585. //更新订单毛利润
  2586. public function OrderGrossProfit($order) {
  2587. try{
  2588. if(is_numeric($order)){
  2589. $order = Order::findOne($order);
  2590. }
  2591. if(!$order || $order->is_gross_profit == 1){
  2592. return;
  2593. }
  2594. $list = [$order->toArray()];
  2595. $form = new \app\modules\admin\models\CostProfitListForm();
  2596. $form->commonData($list);
  2597. foreach ($list as $item) {
  2598. Order::updateAll(['is_gross_profit' => 1, 'gross_profit' => $item['profit']], ['id' => $item['id']]);
  2599. }
  2600. } catch (\Exception $e) {
  2601. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2602. }
  2603. }
  2604. /**
  2605. * 成为股东自动成为分销商
  2606. */
  2607. public function shareHolderAutoBecomeShare($share_holder)
  2608. {
  2609. try{
  2610. $user_id = $share_holder['user_id'];
  2611. $store_id = $share_holder['store_id'];
  2612. $share = Share::findOne(['user_id' => $user_id, 'is_delete' => 0, 'store_id' => $store_id]);
  2613. if ($share && $share->status == 1) {
  2614. return;
  2615. }
  2616. if (!$share || $share->status == 2) {
  2617. $share = new Share();
  2618. $share->user_id = $user_id;
  2619. $share->mobile = '';
  2620. $share->name = '';
  2621. $share->is_delete = 0;
  2622. $share->store_id = $store_id;
  2623. }
  2624. $share->status = 1;
  2625. $share->created_at = time();
  2626. $share->save();
  2627. $user = User::findOne($user_id);
  2628. $user->time = time();
  2629. $user->is_distributor = 1;
  2630. $user->save();
  2631. } catch (\Exception $e) {
  2632. debug_log([__METHOD__, __LINE__, $e->getMessage()], __CLASS__ . '.log');
  2633. }
  2634. }
  2635. // 获取排队序号
  2636. public static function getQueueSort($queue_id, $queue_log_id, $total = false)
  2637. {
  2638. $total_count = 0;
  2639. if ($total) {
  2640. $total_count = QueueLog::find()
  2641. ->where(['queue_id' => $queue_id])
  2642. ->count();
  2643. }
  2644. $current_sort = QueueLog::find()
  2645. ->where(['queue_id' => $queue_id])
  2646. ->andWhere(['<', 'id', $queue_log_id])
  2647. ->count();
  2648. return ['total_count' => $total_count, 'current_sort' => $current_sort + 1];
  2649. }
  2650. // 排队免单
  2651. public function orderQueueSeceiver($order)
  2652. {
  2653. $queue_details = QueueLog::find()->where(['order_id' => $order['id'], 'is_send' => 0])->all();
  2654. if (!$queue_details) {
  2655. return;
  2656. }
  2657. foreach ($queue_details as $queue_detail) {
  2658. $this->orderQueueSelfSeceiver($order, $queue_detail);
  2659. $this->orderQueueShareSeceiver($order, $queue_detail);
  2660. // 首先查是否存在排队
  2661. debug_log([__LINE__, $queue_detail->id], 'queue_receiver.log');
  2662. $t = \Yii::$app->db->beginTransaction();
  2663. try {
  2664. $id = 0;
  2665. while (1) {
  2666. $queue_log = QueueLog::find()
  2667. ->where('id > :id AND `queue_id` = :queue_id AND `is_meet` = 0 AND `status` != 2', [':id' => $id, ':queue_id' => $queue_detail->queue_id])
  2668. ->orderBy('`id` ASC')->one();
  2669. if (!$queue_log) {
  2670. debug_log([__LINE__, $queue_log, $queue_detail->id, '没有排队商品'], 'queue_receiver.log');
  2671. break;
  2672. // throw new \Exception('没有排队商品');
  2673. }
  2674. $id = $queue_log->id;
  2675. debug_log([__LINE__, $queue_log->id, $queue_detail->id], 'queue_receiver.log');
  2676. if(!$queue_detail->cashback_type){
  2677. if ($queue_log->order_id == $order['id']) {
  2678. debug_log('自己购买的订单跳过', 'queue_receiver.log');
  2679. continue;
  2680. // throw new \Exception('自己购买的订单跳过');
  2681. }
  2682. }
  2683. $user = User::findOne($queue_log->user_id);
  2684. if (!$user) {
  2685. debug_log($queue_log->id . '用户不存在' . $queue_log->user_id, 'queue_receiver.log');
  2686. continue;
  2687. // throw new \Exception('用户不存在');
  2688. }
  2689. // 判断当前已返多少
  2690. $queue_detail->is_send = 1;
  2691. $queue_detail->send_time = time();
  2692. if(!$queue_detail->cashback_type){
  2693. $queue_detail->order_money_pool = 0;
  2694. }
  2695. $rate = $queue_detail->rate;
  2696. if ($rate <= 0) {
  2697. debug_log('返现比例为0', 'queue_receiver.log');
  2698. break;
  2699. // throw new \Exception('返现比例为0');
  2700. }
  2701. $icount = 1;
  2702. if($queue_detail->cashback_type){
  2703. $money_queue = QueueLog::find()
  2704. ->where('`queue_id` = :queue_id AND `status` != 2 AND `order_money_pool` > 0 AND `order_id` != :order_id', [':queue_id' => $queue_log->queue_id, ':order_id' => $queue_log->order_id])
  2705. ->andWhere(['order_id' => Order::find()->select('id')->where(['is_sale' => 1])])
  2706. ->orderBy('`id` ASC')->all();
  2707. $money_sum = array_sum(array_column($money_queue, 'order_money_pool'));
  2708. if($money_sum < $queue_detail->cashback_money){
  2709. debug_log($money_sum . '不够返利门槛金额' . $queue_detail->cashback_money, 'queue_receiver.log');
  2710. continue;
  2711. // throw new \Exception($money_sum . '不够返利门槛金额' . $queue_detail->cashback_money);
  2712. }
  2713. $icount = floor($money_sum / $queue_detail->cashback_money);
  2714. }
  2715. debug_log([__LINE__, $queue_log->id, $queue_detail->id, $icount, $money_sum, $queue_detail->cashback_money], 'queue_receiver.log');
  2716. while ($icount >= 1) {
  2717. $icount--;
  2718. if($queue_log->is_meet == 1){
  2719. debug_log($queue_log->id . '返利已完成' . $queue_log->is_meet, 'queue_receiver.log');
  2720. break;
  2721. }
  2722. debug_log([__LINE__, $queue_log->id, $queue_detail->id, $icount], 'queue_receiver.log');
  2723. $from_queue_id = 0;
  2724. $from_queue_list = [];
  2725. $getMoney = 0;
  2726. $t1 = \Yii::$app->db->beginTransaction();
  2727. if($queue_detail->cashback_type){
  2728. try{
  2729. foreach ($money_queue as $mqi => $mqv) {
  2730. if($mqv->order_money_pool <= 0){
  2731. continue;
  2732. }
  2733. $oneMoney = 0;
  2734. $getMoney += $mqv->order_money_pool;
  2735. $mqvMoney = $mqv->order_money_pool;
  2736. if($getMoney >= $queue_detail->cashback_money){
  2737. $oneMoney = 1;
  2738. $mqv->order_money_pool = $getMoney - $queue_detail->cashback_money;
  2739. $mqvMoney = $mqvMoney - $mqv->order_money_pool;
  2740. }else{
  2741. $mqv->order_money_pool = 0;
  2742. $mqv->is_send = 1;
  2743. $mqv->send_time = time();
  2744. }
  2745. if($queue_detail->id == $mqv->id){
  2746. $from_queue_id = $queue_detail->id;
  2747. }
  2748. $mqvMoney > 0 && $from_queue_list[] = ['from_queue_log_id' => $mqv->id, 'order_id' => $mqv->order_id, 'money' => $mqvMoney];
  2749. if(!$mqv->save()){
  2750. throw new \Exception('扣减金额错误' . $mqv->id . array_shift($mqv->getFirstErrors()));
  2751. }
  2752. if($oneMoney){
  2753. break;
  2754. }
  2755. }
  2756. if(!$oneMoney){
  2757. debug_log($getMoney . '贡献金额不足' . $queue_detail->cashback_money, 'queue_receiver.log');
  2758. $t1->rollback();
  2759. break;
  2760. }
  2761. if(!$from_queue_id && $from_queue_list){
  2762. $from_queue_id = $from_queue_list[0]['from_queue_log_id'];
  2763. }
  2764. debug_log([__LINE__, $queue_log->id, $queue_detail->id, $icount, $from_queue_list], 'queue_receiver.log');
  2765. } catch (\Exception $ex) {
  2766. $t1->rollback();
  2767. \Yii::error($ex);
  2768. throw new \Exception($ex->getLine() . $ex->getMessage());
  2769. }
  2770. }
  2771. $queue_money = round(($queue_detail->total_money * $rate / 100), 2);
  2772. if (($queue_money + $queue_log->returned_money) > $queue_log->total_money) {
  2773. $queue_money = $queue_log->total_money - $queue_log->returned_money;
  2774. $queue_log->returned_money = $queue_log->total_money;
  2775. $queue_log->is_meet = 1;
  2776. $queue_log->status = 1;
  2777. $queue_log->over_time = time();
  2778. }
  2779. if (($queue_money + $queue_log->returned_money) == $queue_log->total_money) {
  2780. $queue_log->returned_money = $queue_log->total_money;
  2781. $queue_log->is_meet = 1;
  2782. $queue_log->status = 1;
  2783. $queue_log->over_time = time();
  2784. }
  2785. if (($queue_money + $queue_log->returned_money) < $queue_log->total_money) {
  2786. $queue_log->returned_money += $queue_money;
  2787. $queue_log->status = 3;
  2788. }
  2789. $before_price = 0;
  2790. $after_price = 0;
  2791. if(!$queue_log->cashback_time){
  2792. // 添加记录
  2793. $before_price = $user->free_money;
  2794. $user->updateCounters(['free_money' => $queue_money]);
  2795. $after_price = $user->free_money;
  2796. $user->updateCounters(['total_free_money' => $queue_money]);
  2797. // 增加余额
  2798. AccountLog::saveLog($queue_log->user_id, $queue_money, AccountLog::TYPE_BALANCE, AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER, $order['id'], '订单'.$order['order_no'].'免单返现');
  2799. }
  2800. $queue_account_log = new QueueAccountLog();
  2801. if($queue_log->cashback_time){
  2802. $queue_account_log->is_temp = 1;
  2803. }
  2804. $queue_account_log->store_id = $order['store_id'];
  2805. $queue_account_log->user_id = $queue_log->user_id;
  2806. $queue_account_log->order_id = $queue_log->order_id;
  2807. $queue_account_log->amount = $queue_money;
  2808. $queue_account_log->desc = '免单返现';
  2809. $queue_account_log->before =$before_price;
  2810. $queue_account_log->after =$after_price;
  2811. $queue_account_log->log_type = 1;
  2812. $queue_account_log->type = 0;
  2813. $queue_account_log->created_at = time();
  2814. $queue_account_log->queue_id = $queue_log->id;
  2815. $queue_account_log->from_queue_id = $from_queue_id ? $from_queue_id : $queue_detail->id;
  2816. $queue_account_log->from_queue_list = json_encode($from_queue_list);
  2817. if(!$queue_account_log->save()){
  2818. $t1->rollback();
  2819. throw new \Exception('$queue_account_log $save 0 ' . array_shift($queue_account_log->getFirstErrors()) . json_encode($queue_account_log->attributes));
  2820. }
  2821. $queue_detail->save();
  2822. $queue_log->save();
  2823. //整返
  2824. if($queue_log->is_meet){
  2825. $queue_account_log_list = QueueAccountLog::findAll(['queue_id' => $queue_log->id, 'is_temp' => 1]);
  2826. foreach($queue_account_log_list as $qal){
  2827. $qal->is_temp = 0;
  2828. $qal->before = $user->free_money;
  2829. $qal->after = $user->free_money + $qal->amount;
  2830. $qal->save();
  2831. // 添加记录
  2832. $user->updateCounters(['free_money' => $qal->amount, 'total_free_money' => $qal->amount]);
  2833. $qal_order = Order::findOne($qal->order_id);
  2834. $order_no = (string)$qal_order->order_no;
  2835. // 增加余额
  2836. AccountLog::saveLog($queue_log->user_id, $qal->amount, AccountLog::TYPE_BALANCE, AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER, $qal->order_id, '订单'.$order_no.'免单返现');
  2837. }
  2838. }
  2839. $t1->commit();
  2840. }
  2841. if(!$queue_detail->cashback_type){
  2842. break;
  2843. }
  2844. }
  2845. $t->commit();
  2846. } catch (\Throwable $e) {
  2847. $t->rollBack();
  2848. debug_log([__LINE__, $e->getMessage()], 'queue_receiver.log');
  2849. \Yii::error($e);
  2850. }
  2851. if($queue_detail->cashback_type){
  2852. break;
  2853. }
  2854. }
  2855. }
  2856. // 返自身分账
  2857. public function orderQueueSelfSeceiver($order, $queue_detail)
  2858. {
  2859. // 首先查是否存在排队
  2860. $t = \Yii::$app->db->beginTransaction();
  2861. try {
  2862. // $queue_log = QueueLog::find()
  2863. // ->where('`queue_id` = :queue_id AND `is_meet` = 0 AND `status` != 2 AND `user_id` = :user_id', [':queue_id' => $queue_detail->queue_id, ':user_id' => $queue_detail->user_id])
  2864. // ->orderBy('`id` ASC FOR UPDATE')->one();
  2865. $queue_log = QueueLog::find()
  2866. ->where('`id` = :id AND `is_meet` = 0 AND `status` != 2 AND `user_id` = :user_id', [':id' => $queue_detail->id, ':user_id' => $queue_detail->user_id])
  2867. ->orderBy('`id` ASC FOR UPDATE')->one();
  2868. if (!$queue_log) {
  2869. throw new \Exception('没有排队商品');
  2870. }
  2871. if ($queue_detail->self_bili <= 0) {
  2872. throw new \Exception('比例为0');
  2873. }
  2874. $user = User::findOne($queue_log->user_id);
  2875. if (!$user) {
  2876. throw new \Exception('用户不存在');
  2877. }
  2878. $rate = $queue_detail->self_bili;
  2879. $queue_money = round(($queue_detail->total_money * $rate / 100), 2);
  2880. if (($queue_money + $queue_log->returned_money) > $queue_log->total_money) {
  2881. $queue_money = $queue_log->total_money - $queue_log->returned_money;
  2882. $queue_log->returned_money = $queue_log->total_money;
  2883. $queue_log->is_meet = 1;
  2884. $queue_log->status = 1;
  2885. $queue_log->over_time = time();
  2886. }
  2887. if (($queue_money + $queue_log->returned_money) == $queue_log->total_money) {
  2888. $queue_log->returned_money = $queue_log->total_money;
  2889. $queue_log->is_meet = 1;
  2890. $queue_log->status = 1;
  2891. $queue_log->over_time = time();
  2892. }
  2893. if (($queue_money + $queue_log->returned_money) < $queue_log->total_money) {
  2894. $queue_log->returned_money += $queue_money;
  2895. $queue_log->status = 0; // 自身返利不进入进行中,还在排队中
  2896. }
  2897. // 添加记录
  2898. $before_price = $user->free_money;
  2899. $user->updateCounters(['free_money' => $queue_money]);
  2900. $after_price = $user->free_money;
  2901. $user->updateCounters(['total_free_money' => $queue_money]);
  2902. // 增加余额
  2903. AccountLog::saveLog($queue_log->user_id, $queue_money, AccountLog::TYPE_BALANCE, AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER, $order['id'], '订单'.$order['order_no'].'免单返现');
  2904. $queue_account_log = new QueueAccountLog();
  2905. $queue_account_log->store_id = $order['store_id'];
  2906. $queue_account_log->user_id = $queue_log->user_id;
  2907. $queue_account_log->order_id = $queue_log->order_id;
  2908. $queue_account_log->amount = $queue_money;
  2909. $queue_account_log->desc = '免单返现-自身消费';
  2910. $queue_account_log->before = $before_price;
  2911. $queue_account_log->after = $after_price;
  2912. $queue_account_log->log_type = 1;
  2913. $queue_account_log->type = 0;
  2914. $queue_account_log->created_at = time();
  2915. $queue_account_log->queue_id = $queue_log->id;
  2916. $queue_account_log->from_queue_id = $queue_detail->id;
  2917. $queue_account_log->save();
  2918. $queue_log->save();
  2919. $t->commit();
  2920. } catch (\Throwable $e) {
  2921. $t->rollBack();
  2922. debug_log($e->getMessage(), 'queue_receiver_self.log');
  2923. }
  2924. }
  2925. public function orderQueueShareSeceiver($order, $queue_detail)
  2926. {
  2927. $t = \Yii::$app->db->beginTransaction();
  2928. try {
  2929. // 首先找上级
  2930. $user = User::findOne($order->user_id);
  2931. if (!$user) {
  2932. throw new \Exception('用户不存在');
  2933. }
  2934. if ($user->old_parent_id == 0) {
  2935. throw new \Exception('用户没有上级');
  2936. }
  2937. $parent_user = User::findOne($user->old_parent_id);
  2938. if (!$parent_user) {
  2939. throw new \Exception('上级用户不存在');
  2940. }
  2941. $queue_log = QueueLog::find()
  2942. ->where('`queue_id` = :queue_id AND `is_meet` = 0 AND `status` != 2 AND `user_id` = :user_id', [':queue_id' => $queue_detail->queue_id, ':user_id' => $parent_user->id])
  2943. ->orderBy('`id` ASC FOR UPDATE')->one();
  2944. if (!$queue_log) {
  2945. throw new \Exception('没有排队商品');
  2946. }
  2947. if ($queue_detail->share_bili <= 0) {
  2948. throw new \Exception('比例为0');
  2949. }
  2950. $rate = $queue_detail->share_bili;
  2951. $queue_money = round(($queue_detail->total_money * $rate / 100), 2);
  2952. if (($queue_money + $queue_log->returned_money) > $queue_log->total_money) {
  2953. $queue_money = $queue_log->total_money - $queue_log->returned_money;
  2954. $queue_log->returned_money = $queue_log->total_money;
  2955. $queue_log->is_meet = 1;
  2956. $queue_log->status = 1;
  2957. $queue_log->over_time = time();
  2958. }
  2959. if (($queue_money + $queue_log->returned_money) == $queue_log->total_money) {
  2960. $queue_log->returned_money = $queue_log->total_money;
  2961. $queue_log->is_meet = 1;
  2962. $queue_log->status = 1;
  2963. $queue_log->over_time = time();
  2964. }
  2965. if (($queue_money + $queue_log->returned_money) < $queue_log->total_money) {
  2966. $queue_log->returned_money += $queue_money;
  2967. $queue_log->status = 3;
  2968. }
  2969. // 添加记录
  2970. $before_price = $user->free_money;
  2971. $parent_user->updateCounters(['free_money' => $queue_money]);
  2972. $after_price = $user->free_money;
  2973. $parent_user->updateCounters(['total_free_money' => $queue_money]);
  2974. // 增加余额
  2975. AccountLog::saveLog($queue_log->user_id, $queue_money, AccountLog::TYPE_BALANCE, AccountLog::LOG_TYPE_INCOME, AccountLog::TYPE_PLATFORM_ORDER, $order['id'], '订单'.$order['order_no'].'免单返现');
  2976. $queue_account_log = new QueueAccountLog();
  2977. $queue_account_log->store_id = $order['store_id'];
  2978. $queue_account_log->user_id = $queue_log->user_id;
  2979. $queue_account_log->order_id = $queue_log->order_id;
  2980. $queue_account_log->amount = $queue_money;
  2981. $queue_account_log->desc = '免单返现-推荐返利';
  2982. $queue_account_log->before =$before_price;
  2983. $queue_account_log->after =$after_price;
  2984. $queue_account_log->log_type = 1;
  2985. $queue_account_log->type = 0;
  2986. $queue_account_log->created_at = time();
  2987. $queue_account_log->queue_id = $queue_log->id;
  2988. $queue_account_log->from_queue_id = $queue_detail->id;
  2989. $queue_account_log->save();
  2990. $queue_log->save();
  2991. $t->commit();
  2992. } catch (\Throwable $e) {
  2993. $t->rollBack();
  2994. debug_log($e->getMessage(), 'queue_receiver_share.log');
  2995. }
  2996. }
  2997. public function sendGrowthValue($order){
  2998. $setting = Option::get('growth_setting',$order->store_id,'level','');
  2999. if(!empty($setting)){
  3000. $setting['value'] = json_decode($setting['value'],true);
  3001. }
  3002. // 未设置 或者 设置消费成长值为0 的时候直接返回
  3003. if(empty($setting) || $setting['value']['buy_give'] <= 0){
  3004. return true;
  3005. }
  3006. $amount = floor(bcmul($order->total_price,$setting['value']['buy_give'] / 100,2));
  3007. return UserGrowthValueLog::setLog($order->store_id,$order->user_id,UserGrowthValueLog::LOG_TYPE_ADD,$amount,UserGrowthValueLog::TYPE_BUY,"{$order->order_no}消费获赠{$amount}成长值");
  3008. }
  3009. }