OrdersController.php 87 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052
  1. <?php
  2. namespace App\Http\Controllers\Wap\Pay;
  3. use App\Admin\Models\User;
  4. use App\Modules\Book\Services\BookGiftsService;
  5. use App\Modules\Book\Services\ChapterService;
  6. use App\Modules\OfficialAccount\Services\OfficialAccountService;
  7. use App\Modules\Subscribe\Services\OrderParamService;
  8. use App\Modules\Subscribe\Services\OrderParamWsoService;
  9. use App\Modules\Subscribe\Services\SubstituteOrderService;
  10. use App\Modules\User\Services\ReadRecordService;
  11. use App\Modules\User\Services\UserBindPhoneService;
  12. use App\Modules\User\Services\UserDivisionCpcPropertyService;
  13. use App\Modules\User\Services\UserGiftService;
  14. use Illuminate\Routing\Controller;
  15. use App\Libs\Pay\WechatPay;
  16. use Illuminate\Http\Request;
  17. use App\Modules\Subscribe\Services\YearOrderService;
  18. use App\Modules\Subscribe\Services\BookOrderService;
  19. use App\Modules\Subscribe\Services\OrderService;
  20. use App\Modules\Product\Services\ProductService;
  21. use App\Modules\Book\Services\BookConfigService;
  22. use App\Modules\User\Services\UserService;
  23. use App\Modules\Channel\Services\ChannelService;
  24. use Log;
  25. use DB;
  26. use Cookie;
  27. use Redis;
  28. use Hashids;
  29. use EasyWeChat\Foundation\Application;
  30. use EasyWeChat\Support\XML;
  31. use App\Modules\OfficialAccount\Services\ForceSubscribeService;
  32. use App\Jobs\SendTexts;
  33. use App\Jobs\SendStatisticsList;
  34. use App\Libs\AliSMS;
  35. use App\Modules\Activity\Services\ActivityService;
  36. use App\Modules\SendOrder\Services\SendOrderService;
  37. use GuzzleHttp\Client;
  38. class OrdersController extends Controller
  39. {
  40. /**
  41. * @apiDefine pay 支付
  42. */
  43. /**
  44. * 支付唤起入口
  45. * 功能:授权、请求支付参数、并跳转微信支付
  46. * TODO 暂时不创建订单
  47. * tail -f /var/www/ydy_wap_backend/storage/logs/laravel-2017-12-01.log
  48. * zwap/goToPay?distribution_channel_id=3&price=1&uid=3
  49. * @apiVersion 1.0.0
  50. * @apiDescription 支付
  51. * @api {get} http://pay.aizhuishu.com/goToPay 支付
  52. * @apiGroup pay
  53. * @apiName wxindex
  54. * @apiParam {Int} product_id product_id
  55. * @apiParam {Int} uid uid
  56. * @apiParam {Int} distribution_channel_id distribution_channel_id
  57. * @apiParam {String} pay_redirect_url pay_redirect_url
  58. * @apiSuccess {int} code 状态码
  59. * @apiSuccessExample {json} Success-Response:
  60. * HTTP/1.1 200 OK
  61. * {
  62. * code: 0,
  63. * msg: "",
  64. * data: {
  65. * }
  66. */
  67. function wxindex(Request $request)
  68. {
  69. $product_id = $request->has('product_id') ? $request->get('product_id') : '';
  70. $uid = $request->has('uid') ? $request->get('uid') : '';
  71. $distribution_channel_id = $request->has('distribution_channel_id') ? $request->get('distribution_channel_id') : '';
  72. $p_channel_id = $request->has('p_channel_id') ? $request->get('p_channel_id') : 0;
  73. $pay_redirect_url = $request->has('pay_redirect_url') ? $request->get('pay_redirect_url') : '';
  74. $send_order_id = $request->has('send_order_id') ? $request->get('send_order_id') : 0;
  75. $activity_id = $request->has('activity_id') ? $request->get('activity_id') : 0;
  76. $ip = $request->has('ip') ? $request->get('ip') : '';
  77. $n = $request->has('n') ? $request->get('n') : 0;
  78. $crm = $request->has('crm') ? $request->get('crm') : 0;
  79. if ($send_order_id && strlen($send_order_id) > 50) {
  80. try {
  81. $send_order_id = decrypt($send_order_id);
  82. } catch (\Exception $e) {
  83. $send_order_id = 0;
  84. }
  85. }
  86. if ($send_order_id && strlen($send_order_id) > 50) {
  87. $send_order_id = 0;
  88. }
  89. //活动判断
  90. if ($activity_id) {
  91. $limit = $request->get('limit', 0);
  92. if ($limit && $limit == 1) {
  93. $order = OrderService::userIsParticipateActivity($uid, $activity_id);
  94. if ($order) {
  95. $activity = ActivityService::getById($activity_id);
  96. if ($activity) {
  97. $url = env('PROTOCOL', 'https') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST', 'leyuee') . '.com' . $activity->activity_page;
  98. return redirect()->to($url);
  99. }
  100. return '';
  101. }
  102. }
  103. }
  104. $suid = $request->get('suid', 0);
  105. if ($suid) {
  106. $user_info = UserService::getById($uid);
  107. $distribution_channel_id = $user_info->distribution_channel_id;
  108. $pay_redirect_url = 1;
  109. }
  110. if (empty($product_id) || empty($uid) || empty($distribution_channel_id) || empty($pay_redirect_url)) {
  111. return response()->error('WAP_PARAM_ERROR');
  112. }
  113. if ($suid && $suid == $uid) {
  114. return back();
  115. }
  116. $openid = $request->has('openid') ? $request->get('openid') : '';
  117. $bid = $request->has('bid') ? $request->get('bid') : 0;
  118. $hash_bid = $bid;
  119. $fromtype = $request->has('fromtype') ? $request->get('fromtype') : $request->get('from');
  120. if ($fromtype && strlen($fromtype) > 50) {
  121. try {
  122. $fromtype = decrypt($fromtype);
  123. } catch (\Exception $e) {
  124. $fromtype = 'main';
  125. }
  126. }
  127. if ($fromtype && strlen($fromtype) > 50) {
  128. $fromtype = 'main';
  129. }
  130. if (!$openid && !$p_channel_id && !$suid) {
  131. $transfer_channel_id = $this->transfer($distribution_channel_id);
  132. if ($transfer_channel_id) {
  133. $p_channel_id = $distribution_channel_id;
  134. $distribution_channel_id = $transfer_channel_id;
  135. }
  136. }
  137. //根据分校id获取支付配置id
  138. Log::info($request->all());
  139. $channel = ChannelService::getById($distribution_channel_id);
  140. if (!$channel || !$channel->pay_merchant_id) {
  141. return response()->error('WAP_PARAM_ERROR');
  142. }
  143. //获取支付类型
  144. $pay_merchant = DB::table('pay_merchants')->select('id', 'appid', 'source', 'config_info')->where('id', $channel->pay_merchant_id)->where('is_enabled', 1)->first();
  145. if (!$pay_merchant || !$pay_merchant->appid || !$pay_merchant->source) return response()->error('WAP_PARAM_ERROR');
  146. if ($pay_merchant->source == 'PALMPAYV2') {
  147. return redirect()->to($this->paympay($request, $pay_merchant));
  148. }
  149. //重定向 获取用户信息的次数
  150. $n++;
  151. if ($n >= 5) {
  152. //重定向次数过多,则授权公众号出问题
  153. $this->payAlert($channel->pay_merchant_id, '', '', $n);
  154. $back_url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com' . '/pay';
  155. return redirect()->to($back_url);
  156. }
  157. if (empty($openid)) {
  158. $trade_no = date("YmdHis") . str_shuffle(hexdec(uniqid()));
  159. if (isset($_SERVER['HTTP_X_FORWARDED_FOR']) && $_SERVER['HTTP_X_FORWARDED_FOR']) {
  160. $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
  161. } else {
  162. $ip = get_client_ip();
  163. }
  164. $params = compact('uid', 'product_id', 'distribution_channel_id', 'send_order_id', 'bid', 'trade_no', 'pay_redirect_url', 'fromtype', 'activity_id', 'n', 'suid', 'ip', 'p_channel_id','crm');
  165. $redirect_url = env('CREATE_PAY_URL') . '?' . http_build_query($params);
  166. //$redirect_url = env('CREATE_PAY_URL').'?uid='.$uid.'&product_id='.$product_id.'&distribution_channel_id='
  167. // .$distribution_channel_id.'&send_order_id='.$send_order_id.'&bid='.$bid.'&pay_redirect_url='.urlencode($pay_redirect_url)
  168. $auth_url = env('AUTH_URL') . '?gzh_app_id=' . $pay_merchant->appid . '&redirect_url=' . urlencode($redirect_url);
  169. Log::info('redirect_auth_url:' . $auth_url);
  170. header("Location:" . $auth_url);
  171. exit();
  172. }
  173. $trade_no = $request->input('trade_no');
  174. $order_info = OrderService::getByTradeNo($trade_no);
  175. if ($order_info) return response()->error('WAP_SYS_ERROR');
  176. $cid = $request->has('cid') ? $request->get('cid') : '';
  177. $product_info = ProductService::getProductSingle($product_id, false);
  178. //新用户只能冲一次
  179. //Log::info('新用户只能冲一次:' .$product_info->type);
  180. if ($this->isNewUserSecondCharge($product_info->type, $product_id, $uid)) {
  181. $url = env('PROTOCOL', 'https') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST', 'leyuee') . '.com/pay';
  182. return redirect()->to($url);
  183. }
  184. $price = $product_info->price * 100;
  185. if ($uid < 32) {
  186. $price = 1;
  187. }
  188. try {
  189. $send_order_id = (int)Redis::hget('book_read:' . $uid, 'send_order_id');
  190. } catch (\Exception $e) {
  191. }
  192. $this->updateUserSendOrderId($uid, $send_order_id);
  193. if (in_array($uid, explode(',', env('TEST_UID')))) {
  194. $price = 1;
  195. }
  196. if ($bid) {
  197. try {
  198. $bid = Hashids::decode($bid)[0];
  199. } catch (\Exception $e) {
  200. $bid = 0;
  201. }
  202. }
  203. try {
  204. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id:' . $distribution_channel_id;
  205. Redis::hset($key, $uid, time());
  206. $date = date('Y-m-d');
  207. Redis::hincrby('order_stat:' . $distribution_channel_id, 'order_num_' . $date, 1);
  208. if ($send_order_id) {
  209. Redis::hincrby('order_promotion_stat:' . $send_order_id, 'order_num_' . $date, 1);
  210. Redis::hincrby('order_promotion_stat:' . $send_order_id, 'total', 1);
  211. }
  212. } catch (\Exception $e) {
  213. }
  214. $data = [];
  215. $data['price'] = $price;
  216. $data['create_ip'] = $ip;
  217. $data['openid'] = $openid;//
  218. $data['body'] = 'novel read';
  219. $official_name = $this->getSubscribeOfficialName($uid, $distribution_channel_id);
  220. if ($official_name) {
  221. $data['body'] = '搜索公众号' . $official_name . ',请继续阅读';
  222. }
  223. $data['detail'] = 'novel read';
  224. $data['trade_no'] = $trade_no;
  225. $data['remark'] = json_encode(
  226. [
  227. 'uid' => $uid,
  228. 'dcd' => $distribution_channel_id,
  229. 'bid' => $bid,
  230. 'cp' => $ip,
  231. 'pms' => $pay_merchant->source,
  232. 'pmi' => $channel->pay_merchant_id,
  233. 'pd' => $product_id,
  234. 'soi' => $send_order_id,
  235. ]
  236. );
  237. if ($product_info->type == 'YEAR_ORDER') {
  238. $order_type = 'YEAR';
  239. } elseif ($product_info->type == 'BOOK_ORDER') {
  240. $order_type = 'BOOK';
  241. } elseif ($product_info->type == 'TICKET_RECHARGE') {
  242. $order_type = 'RECHARGE';
  243. } elseif ($product_info->type == 'NEW_USER') {
  244. $order_type = 'RECHARGE';
  245. } else {
  246. $order_type = 'UNKNOWN';
  247. }
  248. /*
  249. $this->createOrderTotal([
  250. 'distribution_channel_id'=>$distribution_channel_id,
  251. 'uid'=>$uid,
  252. 'product_id'=>$product_id,
  253. 'price'=>$price/100,
  254. 'pay_type'=>1,
  255. 'trade_no'=>$data['trade_no'],
  256. 'pay_merchant_source'=>$pay_merchant->source,
  257. 'pay_merchant_id'=>$channel->pay_merchant_id,
  258. 'create_ip'=>$request->getClientIp(),
  259. 'send_order_id'=>$send_order_id,
  260. 'order_type'=>$order_type,
  261. 'from_bid'=>$bid
  262. ]);*/
  263. $send_order_name = '';
  264. if ($send_order_id) {
  265. $send_order_info = SendOrderService::getById($send_order_id);
  266. if ($send_order_info && isset($send_order_info->name) && !empty($send_order_info->name)) {
  267. $send_order_name = $send_order_info->name;
  268. }
  269. if(redisEnv('MIWAN_TRANSFER_TO_CHANNEL_ID', 0) == $distribution_channel_id){
  270. $send_order_id = -$send_order_id;
  271. }
  272. }
  273. if ($suid) {
  274. $user_info = UserService::getById($uid);
  275. $distribution_channel_id = $user_info->distribution_channel_id;
  276. }
  277. $from_bid = ReadRecordService::getSimpleFirstReadRecord($uid);
  278. $inner_send_order_id = ReadRecordService::getInnerSendOrderId($uid);
  279. $init_order = [
  280. 'distribution_channel_id' => $distribution_channel_id,
  281. 'uid' => $uid,
  282. 'product_id' => $product_id,
  283. 'price' => $price / 100,
  284. 'pay_type' => 1,
  285. 'trade_no' => $data['trade_no'],
  286. 'pay_merchant_source' => $pay_merchant->source,
  287. 'pay_merchant_id' => $channel->pay_merchant_id,
  288. 'create_ip' => $ip,
  289. 'send_order_id' => $send_order_id,
  290. 'send_order_name' => $send_order_name,
  291. 'order_type' => $order_type,
  292. 'from_bid' => $from_bid,
  293. 'from_type' => $fromtype,
  294. 'activity_id' => $activity_id,
  295. 'inner_send_order_id' => $inner_send_order_id
  296. ];
  297. $result = $this->createUnPayOrder($init_order);
  298. //订单创建成功后增加统计
  299. if ($result) {
  300. $this->orderCreated($init_order);
  301. $this->recordOtherParam($result->id, $uid);
  302. if($p_channel_id){
  303. //miwa 转换
  304. OrderParamService::createByParam([
  305. 'order_id'=>$result->id,'gxhp'=>'mw_transfer','appid'=>'','bid'=>$bid,'data_hour_key'=>'','times'=>'','distribution_channel_id'=>$p_channel_id
  306. ]);
  307. }
  308. if($crm){
  309. OrderParamService::createByParam([
  310. 'order_id'=>$result->id,'gxhp'=>'crm','appid'=>'','bid'=>$bid,'data_hour_key'=>$crm,'times'=>'','distribution_channel_id'=>$distribution_channel_id
  311. ]);
  312. }
  313. $this->orderParamWso($uid,$result->id);
  314. }
  315. if ($request->get('suid')) {
  316. $this->createSubstituteOrder($result->id, $uid, $request->get('suid'));
  317. }
  318. Log::info($data);
  319. $config = [];
  320. if ($pay_merchant->config_info) {
  321. $config = json_decode($pay_merchant->config_info, true);
  322. }
  323. $wechatPay = WechatPay::instance($pay_merchant->source, $config);
  324. if (!$wechatPay) return response()->error('WAP_PARAM_ERROR');
  325. $pay_info = $wechatPay->send($data);
  326. if (!$pay_info) {
  327. $pay_info = $wechatPay->send($data);
  328. }
  329. if (!isset($pay_info['appId']) || !isset($pay_info['package'])) {
  330. //支付异常
  331. myLog('order')->info('pay error start---------------------------------');
  332. myLog('order')->info($pay_info);
  333. myLog('order')->info($request->all());
  334. myLog('order')->info('order info is');
  335. myLog('order')->info($init_order);
  336. myLog('order')->info('pay error end-----------------------------------');
  337. $this->payAlert($channel->pay_merchant_id, $trade_no, $pay_info);
  338. }
  339. $pay_info['pay_redirect_url'] = urldecode($pay_redirect_url);
  340. if ($request->has('cid')) {
  341. $pay_info['pay_redirect_url'] = $pay_info['pay_redirect_url'] . '&cid=' . $request->input('cid');
  342. }
  343. // if ($hash_bid) {
  344. // $pay_info['pay_redirect_url'] = $pay_info['pay_redirect_url'] . '&bid=' . $hash_bid;
  345. // }
  346. if ($suid) {
  347. $prize_fee = (int)(($product_info->price * 100) * 0.1);
  348. $help_pay_page_channel_id = env('HELP_PAY_PAGE_CHANNEL_ID', 123);
  349. $help_pay_page_channel_id = $distribution_channel_id;
  350. $url_format = '%s://site%s.%s.com/helppay?back=%s&su=%s';
  351. $pay_info['pay_redirect_url'] = $pay_redirect_url = sprintf(
  352. $url_format,
  353. env('PROTOCOL'),
  354. encodeDistributionChannelId($help_pay_page_channel_id),
  355. env('CUSTOM_HOST'),
  356. $prize_fee,
  357. $uid
  358. );
  359. }
  360. $pay_url_info = parse_url($pay_redirect_url);
  361. $pay_info['pay_wait_url'] = $pay_url_info['scheme'] . '://' . $pay_url_info['host'] . '/pay/wait?order=' . $data['trade_no'] . '&redirect=' . urlencode($pay_info['pay_redirect_url']);
  362. //$h5_scheme = env('H5_SCHEME','https');
  363. //$jsSdkSign = $this->jsSdkSign($pay_info,str_replace('http',$h5_scheme,url()->current()));
  364. Log::info('$pay_info is');
  365. $jsSdkSign = 0;
  366. Log::info($pay_info);
  367. Log::info('jsSdkSign---- :' . $jsSdkSign);
  368. $pay_order = $trade_no;
  369. // 注册动作-》创建订单
  370. $action_type = 'CreateOrder';
  371. $param = [
  372. 'openid' => isset($openid) ? $openid : '0',
  373. 'uid' => isset($uid) ? $uid : '0',
  374. 'order_sn' => isset($trade_no) ? $trade_no : '0',
  375. 'amount' => isset($price) ? $price : '0',
  376. ];
  377. UserService::PushUserActionToQueue($action_type, $distribution_channel_id, $param);
  378. return view('pay.order.index', compact('pay_info', 'referer', 'jsSdkSign', 'pay_order'));
  379. }
  380. private function paympay(Request $request, $pay_merchant)
  381. {
  382. $product_id = $request->get('product_id');
  383. $uid = $request->get('uid');
  384. $distribution_channel_id = $request->get('distribution_channel_id');
  385. $pay_redirect_url = $request->get('pay_redirect_url');
  386. $send_order_id = $request->get('send_order_id', 0);
  387. $activity_id = $request->get('activity_id', 0);
  388. $suid = $request->get('suid', 0);
  389. $bid = $request->has('bid') ? $request->get('bid') : 0;
  390. $crm = $request->has('crm') ? $request->get('crm') : '';
  391. $hash_bid = $bid;
  392. $fromtype = $request->has('fromtype') ? $request->get('fromtype') : $request->get('from', 'main');
  393. //根据分校id获取支付配置id
  394. Log::info($request->all());
  395. $trade_no = $trade_no = date("YmdHis") . str_shuffle(hexdec(uniqid()));
  396. $order_info = OrderService::getByTradeNo($trade_no);
  397. if ($order_info) return response()->error('WAP_SYS_ERROR');
  398. $cid = $request->has('cid') ? $request->get('cid') : '';
  399. $product_info = ProductService::getProductSingle($product_id, false);
  400. //新用户只能冲一次
  401. //Log::info('新用户只能冲一次:' .$product_info->type);
  402. if ($this->isNewUserSecondCharge($product_info->type, $product_id, $uid)) {
  403. $url = env('PROTOCOL', 'https') . '://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . env('CUSTOM_HOST', 'leyuee') . '.com/pay';
  404. return redirect()->to($url);
  405. }
  406. $price = $product_info->price * 100;
  407. if ($uid < 32) {
  408. $price = 1;
  409. }
  410. if (!$send_order_id) {
  411. try {
  412. $send_order_id = (int)Redis::hget('book_read:' . $uid, 'send_order_id');
  413. } catch (\Exception $e) {
  414. }
  415. }
  416. $this->updateUserSendOrderId($uid, $send_order_id);
  417. if (in_array($uid, explode(',', env('TEST_UID')))) {
  418. $price = 1;
  419. }
  420. try {
  421. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id:' . $distribution_channel_id;
  422. Redis::hset($key, $uid, time());
  423. $date = date('Y-m-d');
  424. Redis::hincrby('order_stat:' . $distribution_channel_id, 'order_num_' . $date, 1);
  425. if ($send_order_id) {
  426. Redis::hincrby('order_promotion_stat:' . $send_order_id, 'order_num_' . $date, 1);
  427. Redis::hincrby('order_promotion_stat:' . $send_order_id, 'total', 1);
  428. }
  429. } catch (\Exception $e) {
  430. }
  431. if (isset($_SERVER['HTTP_X_FORWARDED_FOR']) && $_SERVER['HTTP_X_FORWARDED_FOR']) {
  432. $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
  433. } else {
  434. $ip = get_client_ip();
  435. }
  436. $data = [];
  437. $data['price'] = $price;
  438. $data['create_ip'] = $ip;
  439. $data['body'] = 'novel read';
  440. $official_name = $this->getSubscribeOfficialName($uid, $distribution_channel_id);
  441. if ($official_name) {
  442. $data['body'] = '搜索公众号' . $official_name . ',请继续阅读';
  443. }
  444. $data['detail'] = 'novel read';
  445. $data['trade_no'] = $trade_no;
  446. if ($product_info->type == 'YEAR_ORDER') {
  447. $order_type = 'YEAR';
  448. } elseif ($product_info->type == 'BOOK_ORDER') {
  449. $order_type = 'BOOK';
  450. } elseif ($product_info->type == 'TICKET_RECHARGE') {
  451. $order_type = 'RECHARGE';
  452. } elseif ($product_info->type == 'NEW_USER') {
  453. $order_type = 'RECHARGE';
  454. } else {
  455. $order_type = 'UNKNOWN';
  456. }
  457. $send_order_name = '';
  458. if ($send_order_id) {
  459. $send_order_info = SendOrderService::getById($send_order_id);
  460. if ($send_order_info && isset($send_order_info->name) && !empty($send_order_info->name)) {
  461. $send_order_name = $send_order_info->name;
  462. }
  463. }
  464. if ($suid) {
  465. $user_info = UserService::getById($uid);
  466. $distribution_channel_id = $user_info->distribution_channel_id;
  467. }
  468. $from_bid = ReadRecordService::getSimpleFirstReadRecord($uid);
  469. $inner_send_order_id = ReadRecordService::getInnerSendOrderId($uid);
  470. $init_order = [
  471. 'distribution_channel_id' => $distribution_channel_id,
  472. 'uid' => $uid,
  473. 'product_id' => $product_id,
  474. 'price' => $price / 100,
  475. 'pay_type' => 1,
  476. 'trade_no' => $data['trade_no'],
  477. 'pay_merchant_source' => 'PALMPAY',
  478. 'pay_merchant_id' => $pay_merchant->id,
  479. 'create_ip' => $ip,
  480. 'send_order_id' => $send_order_id,
  481. 'send_order_name' => $send_order_name,
  482. 'order_type' => $order_type,
  483. 'from_bid' => $from_bid,
  484. 'from_type' => $fromtype,
  485. 'activity_id' => $activity_id,
  486. 'inner_send_order_id' => $inner_send_order_id
  487. ];
  488. $result = $this->createUnPayOrder($init_order);
  489. //订单创建成功后增加统计
  490. if ($result) {
  491. $this->orderCreated($init_order);
  492. $this->recordOtherParam($result->id, $uid);
  493. if($crm){
  494. OrderParamService::createByParam([
  495. 'order_id'=>$result->id,'gxhp'=>'crm','appid'=>'','bid'=>$bid,'data_hour_key'=>$crm,'times'=>'','distribution_channel_id'=>$distribution_channel_id
  496. ]);
  497. }
  498. $this->orderParamWso($uid,$result->id);
  499. }
  500. if ($suid) {
  501. $this->createSubstituteOrder($result->id, $uid, $suid);
  502. }
  503. if ($suid) {
  504. $prize_fee = (int)(($product_info->price * 100) * 0.1);
  505. //$help_pay_page_channel_id = env('HELP_PAY_PAGE_CHANNEL_ID', 123);
  506. $help_pay_page_channel_id = $distribution_channel_id;
  507. $url_format = '%s://site%s.%s.com/helppay?back=%s&su=%s';
  508. $pay_redirect_url = sprintf(
  509. $url_format,
  510. env('PROTOCOL'),
  511. encodeDistributionChannelId($help_pay_page_channel_id),
  512. env('CUSTOM_HOST'),
  513. $prize_fee,
  514. $uid
  515. );
  516. }
  517. $de_pay_redirect_url = urldecode($pay_redirect_url);
  518. /*if ($request->has('cid')) {
  519. $de_pay_redirect_url = $de_pay_redirect_url . '&cid=' . $request->get('cid');
  520. }*/
  521. $pay_url_info = parse_url($de_pay_redirect_url);
  522. $data['pay_wait_url'] = $pay_url_info['scheme'] . '://' . $pay_url_info['host'] . '/pay/waitv2?order=' . $data['trade_no'] . '&redirect=' . urlencode($de_pay_redirect_url);
  523. Log::info($data);
  524. $config = [];
  525. if ($pay_merchant->config_info) {
  526. $config = json_decode($pay_merchant->config_info, true);
  527. }
  528. $wechatPay = WechatPay::instance($pay_merchant->source, $config);
  529. \Log::info('$wechatPay is');
  530. //\Log::info($wechatPay);
  531. if (!$wechatPay) return response()->error('WAP_PARAM_ERROR');
  532. \Log::info('$wechatPay ok-------------------');
  533. $pay_info = $wechatPay->send($data);
  534. \Log::info('send ok-------------------');
  535. // 注册动作-》创建订单
  536. $action_type = 'CreateOrder';
  537. $param = [
  538. 'openid' => isset($openid) ? $openid : '0',
  539. 'uid' => isset($uid) ? $uid : '0',
  540. 'order_sn' => isset($trade_no) ? $trade_no : '0',
  541. 'amount' => isset($price) ? $price : '0',
  542. ];
  543. \Log::info('FUCK_PALMPAYV2');
  544. UserService::PushUserActionToQueue($action_type, $distribution_channel_id, $param);
  545. return $pay_info;
  546. }
  547. public function waitPageV2(Request $request)
  548. {
  549. $order = $request->get('order');
  550. $order = (string)$order;
  551. $url = urldecode($request->get('redirect'));
  552. if (substr_count($url, '?') > 1) {
  553. $url = str_replace_last('?', '&', $url);
  554. }
  555. $from = 'pay';
  556. $order_info = OrderService::getByTradeNo($order);
  557. $uid = $order_info->uid;
  558. //$bind_info = UserBindPhoneService::bindInfo($uid);
  559. $bind_info = true;
  560. $page = 'pay.order.wait';
  561. if(!$bind_info){
  562. //$page = 'pay.order.bindPhone';
  563. }
  564. $url_info = parse_url($url);
  565. if (isset($url_info['query']) && !empty($url_info['query'])) {
  566. parse_str($url_info['query'], $path);
  567. if (isset($path['success']) && $path['success'] == 0) {
  568. if (isset($url_info['path']) && str_contains($url_info['path'], 'reader') && isset($path['cid']) && !empty($path['cid'])) {
  569. $chapter_info = ChapterService::getChapterNameByIdNoCheck($path['cid']);
  570. $path['cid'] = $chapter_info->prev_cid;
  571. $url = sprintf('%s://%s/reader?%s', $url_info['scheme'], $url_info['host'], http_build_query($path));
  572. }
  573. if(!$bind_info){
  574. return view('pay.order.bindPhone', compact('order', 'url','from'));
  575. }else{
  576. return redirect($url);
  577. }
  578. }
  579. }
  580. if (isset($url_info['path']) && str_contains($url_info['path'], 'pay')) {
  581. $url = sprintf('%s://%s/recent', $url_info['scheme'], $url_info['host']);
  582. //return redirect($url);
  583. if(!$bind_info){
  584. return view('pay.order.bindPhone', compact('order', 'url','from'));
  585. }else{
  586. return redirect($url);
  587. }
  588. }
  589. return view($page, compact('order', 'url','from'));
  590. }
  591. private function isNewUserSecondCharge($charge_type, $product_id, $uid)
  592. {
  593. //Log::info('新用户只能冲一次:' .$charge_type);
  594. if ($charge_type == 'NEW_USER') {
  595. $result = OrderService::getUserOrderByProductId($uid, $product_id);
  596. //Log::info('isNewUserSecondCharge-------------------------');
  597. //Log::info($result);
  598. if ($result) {
  599. return true;
  600. }
  601. }
  602. return false;
  603. }
  604. //订单创建后统计
  605. private function orderCreated($init_order)
  606. {
  607. try {
  608. if (isset($init_order['pay_merchant_id'])) {
  609. $key = 'pay_merchant:' . $init_order['pay_merchant_id'];
  610. Redis::hincrby($key, 'unpaid_num', 1);
  611. Redis::hset($key, 'last_create_time', time());
  612. }
  613. } catch (\Exception $e) {
  614. }
  615. }
  616. //订单回调后统计
  617. private function orderPaid($init_order)
  618. {
  619. try {
  620. if (isset($init_order['pay_merchant_id'])) {
  621. $key = 'pay_merchant:' . $init_order['pay_merchant_id'];
  622. Redis::hset($key, 'unpaid_num', 0);
  623. }
  624. } catch (\Exception $e) {
  625. }
  626. }
  627. public function reportError(Request $request)
  628. {
  629. $data = $request->post('data');
  630. DB::table('pay_page_error')->insert([
  631. 'msg' => $data,
  632. 'created_at' => date('Y-m-d H:i:s'),
  633. 'updated_at' => date('Y-m-d H:i:s')
  634. ]);
  635. return response()->success();
  636. }
  637. private function jsSdkSign($pay_info, $url)
  638. {
  639. if (!isset($pay_info['appId']) || !isset($pay_info['package'])) {
  640. return 0;
  641. }
  642. $appid = $pay_info['appId'];
  643. $jsapi_ticket = Redis::hget($appid, 'jsapi_ticket');
  644. //如果能获取到jsapi_ticket 则直接签名
  645. if ($jsapi_ticket) {
  646. $sign_arr = [
  647. 'noncestr' => $pay_info['nonceStr'],
  648. 'jsapi_ticket' => $jsapi_ticket,
  649. 'timestamp' => $pay_info['timeStamp'],
  650. 'url' => $url
  651. ];
  652. return sha1($this->arr_to_url($sign_arr));
  653. }
  654. //获取不到jsapi_ticket
  655. $app_secret_info = DB::table('official_setting')->select('secret')->first();
  656. if ($app_secret_info && !empty($app_secret_info->secret)) {
  657. $client = new Client(['timeout' => 5]);
  658. try {
  659. //获取access_token
  660. $url = 'https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=' . $appid . '&secret=' . $app_secret_info->secret;
  661. $res = $client->request('get', $url)->getBody()->getContents();
  662. if (!$res) {
  663. return 0;
  664. }
  665. $res = json_decode($res, 1);
  666. if (!isset($res['access_token']) || empty($res['access_token'])) {
  667. return 0;
  668. }
  669. Redis::hset($appid, 'access_token', $res['access_token']);
  670. //获取jsapi_ticket
  671. $res = null;
  672. $url = 'https://api.weixin.qq.com/cgi-bin/ticket/getticket?access_token=' . $res['access_token'] . '&type=jsapi';
  673. $res = $client->request('get', $url)->getBody()->getContents();
  674. if (!$res) {
  675. return 0;
  676. }
  677. $res = json_decode($res, 1);
  678. if (!isset($res['ticket']) || empty($res['ticket'])) {
  679. return 0;
  680. }
  681. Redis::hset($appid, 'jsapi_ticket', $res['ticket']);
  682. Redis::EXPIRE($appid, 7000);
  683. $sign_arr = [
  684. 'noncestr' => $pay_info['nonceStr'],
  685. 'jsapi_ticket' => $res['ticket'],
  686. 'timestamp' => $pay_info['timeStamp'],
  687. 'url' => $url
  688. ];
  689. return sha1($this->arr_to_url($sign_arr));
  690. } catch (\Exception $e) {
  691. return 0;
  692. }
  693. }
  694. return 0;
  695. }
  696. public function waitPage(Request $request)
  697. {
  698. $order = $request->input('order');
  699. $from = 'pay';
  700. //$order = "201712081711401585932843356442";
  701. $order = (string)$order;
  702. $order_info = OrderService::getByTradeNo($order);
  703. $uid = $order_info->uid;
  704. $bind_info = UserBindPhoneService::bindInfo($uid);
  705. //$bind_info = false;
  706. $page = 'pay.order.wait';
  707. if(!$bind_info){
  708. $page = 'pay.order.bindPhone';
  709. }
  710. $url = urldecode($request->input('redirect'));
  711. return view($page, compact('order', 'url','from'));
  712. //return view('pay.order.wait');
  713. }
  714. /**
  715. * 官方微信回调
  716. * @param Request $request
  717. * @return \Symfony\Component\HttpFoundation\Response
  718. */
  719. function wcback_official(Request $request)
  720. {
  721. libxml_disable_entity_loader(true);
  722. $xml = XML::parse(strval($request->getContent()));
  723. Log::info('xml is');
  724. Log::info($xml);
  725. if (!$xml || !is_array($xml)) return 'fail';
  726. $remarks = json_decode($xml['attach'], true);
  727. $pay_merchant_id = $remarks['pmi'];
  728. $pay_merchant = DB::table('pay_merchants')->select('appid', 'source', 'config_info')->where('id', $pay_merchant_id)->where('is_enabled', 1)->first();
  729. $application = WechatPay::instance('OFFICIALPAY', json_decode($pay_merchant->config_info, true));
  730. //$app = new Application($options);
  731. $app = $application->app;
  732. $response = $app->payment->handleNotify(function ($notify, $successful) {
  733. if (!$successful) return 'fail';
  734. $trade_no = $notify->out_trade_no;
  735. $order = OrderService::getByTradeNo($trade_no);
  736. if (isset($order->status) && $order->status == 'PAID') {
  737. Log::info('has_pay:' . $trade_no);
  738. return true;
  739. }
  740. DB::beginTransaction();
  741. try {
  742. $transaction_id = $notify->transaction_id;
  743. $remarks = json_decode($notify->attach, true);
  744. $uid = $remarks['uid'];
  745. $distribution_channel_id = $remarks['dcd'];
  746. $product_id = $remarks['pd'];
  747. $product = ProductService::getProductSingle($product_id);
  748. $pay_merchant_source = $remarks['pms'];
  749. $pay_merchant_id = $remarks['pmi'];
  750. $send_order_id = $remarks['soi'];
  751. $create_ip = $remarks['cp'];
  752. $price = $product->price;
  753. $bid = $remarks['bid'];
  754. //$this->updateOrderTotal($trade_no,$transaction_id);
  755. $prize_fee = (int)(($product->price * 100) * 0.1);
  756. $this->substituteOrderPrice($order->id, $prize_fee);
  757. $this->smartPushTestBookPaidUv($order->from_bid, $order->uid, $order->price);
  758. //获取用户充值次数
  759. $order->pay_type = $this->getChargeTimes($order->uid);
  760. // 更新其他定制Order表
  761. if ($product->type == 'YEAR_ORDER') {
  762. Log::info('YEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDER');
  763. $order_type = 'YEAR';
  764. $this->yearOrder($uid, $distribution_channel_id, $price, $send_order_id);
  765. $order->order_type = $order_type;
  766. $order->status = 'PAID';
  767. $order->pay_end_at = date('Y-m-d H:i:s');
  768. $order->transaction_id = $transaction_id;
  769. $order->save();
  770. //$price = $price/100;
  771. /*
  772. $this->createOrder(
  773. compact(
  774. 'uid','distribution_channel_id','product_id','price','trade_no','send_order_id','order_type','pay_merchant_source',
  775. 'pay_merchant_id','create_ip','bid','transaction_id'
  776. )
  777. );*/
  778. } elseif ($product->type == 'BOOK_ORDER') {
  779. Log::info('BOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDER');
  780. $order_type = 'BOOK';
  781. $this->bookOrder($product_id, $uid, $send_order_id, $price, $distribution_channel_id);
  782. $order->order_type = $order_type;
  783. $order->status = 'PAID';
  784. $order->pay_end_at = date('Y-m-d H:i:s');
  785. $order->transaction_id = $transaction_id;
  786. $order->save();
  787. //$price = $price/100;
  788. /*
  789. $this->createOrder(
  790. compact(
  791. 'uid','distribution_channel_id','product_id','price','trade_no','send_order_id','order_type','pay_merchant_source',
  792. 'pay_merchant_id','create_ip','bid','transaction_id'
  793. )
  794. );*/
  795. } elseif ($product->type == 'TICKET_RECHARGE') {
  796. Log::info('TICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGE');
  797. $order_type = 'RECHARGE';
  798. $this->userCharge($product, $uid);
  799. $order->order_type = $order_type;
  800. $order->status = 'PAID';
  801. $order->pay_end_at = date('Y-m-d H:i:s');
  802. $order->transaction_id = $transaction_id;
  803. $order->save();
  804. //$price = $price/100;
  805. /*
  806. $this->createOrder(
  807. compact(
  808. 'uid','distribution_channel_id','product_id','price','trade_no','send_order_id','order_type','pay_merchant_source',
  809. 'pay_merchant_id','create_ip','bid','transaction_id'
  810. ));*/
  811. } elseif ($product->type == 'FOREVER') {
  812. Log::info('FOREVER------------------------FOREVER');
  813. $order_type = 'FOREVER';
  814. $this->foreverFreeOrder($uid, $distribution_channel_id, $price, $send_order_id);
  815. $order->order_type = $order_type;
  816. $order->status = 'PAID';
  817. $order->pay_end_at = date('Y-m-d H:i:s');
  818. $order->transaction_id = $transaction_id;
  819. $order->save();
  820. } else {
  821. DB::rollback();
  822. return 'Order not exist.';
  823. }
  824. $this->successPayPushMsg($uid, $product, $order->id);
  825. $this->orderStatistical($order);
  826. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id:' . $distribution_channel_id;
  827. Redis::hdel($key, $uid);
  828. DB::commit();
  829. $this->huaweiActivity($order->activity_id,$uid,$product_id);
  830. // 注册动作-》回调订单
  831. $action_type = 'CallBackOrder';
  832. $param = [
  833. 'order_sn' => isset($trade_no) ? $trade_no : '0',
  834. 'openid' => isset($uid) ? $uid : '0',// 没有openid,用uid写log
  835. ];
  836. UserService::PushUserActionToQueue($action_type, $distribution_channel_id, $param);
  837. //用户属性
  838. $this->userProperty($uid,$price,$product->type,$order->activity_id);
  839. //交换订单时间
  840. $this->exchangeUpdateAndCreated($order->id);
  841. return true;
  842. } catch (\Exception $e) {
  843. DB::rollback();
  844. return 'fail';
  845. }
  846. });
  847. return $response;
  848. }
  849. /**
  850. * 通联支付回调
  851. * @param Request $request
  852. */
  853. function wcback_allinpay(Request $request)
  854. {
  855. Log::info('wcback_allinpay_request');
  856. try {
  857. $data = $request->all();
  858. Log::info($request->all());
  859. if (!$data['trxreserved']) return 'fail';
  860. $pay_merchant_id = json_decode($data['trxreserved'], true)['pmi'];
  861. $pay_merchant = DB::table('pay_merchants')->select('appid', 'source', 'config_info')->where('id', $pay_merchant_id)->where('is_enabled', 1)->first();
  862. unset($data['_url']);
  863. if (!$pay_merchant->config_info) return 'fail';
  864. $wechatPay = WechatPay::instance('ALLINPAY', json_decode($pay_merchant->config_info, true));
  865. if ($wechatPay->NotifyValidSign($data, $wechatPay->appkey)) {
  866. Log::info('allinpay_notify_sign_success');
  867. /**
  868. * 只有0000表示交易成功或下单成功,其他为失败
  869. * 0000:交易成功
  870. * 3045,3088:交易超时
  871. * 3008:余额不足
  872. * 3999:交易失败
  873. * 2008:交易处理中
  874. * 3050:交易已撤销
  875. */
  876. if ($data['trxstatus'] == '0000') {
  877. // 修改表比较多,开启事务
  878. DB::beginTransaction();
  879. $trade_no = $data['cusorderid'];
  880. $transaction_id = $data['chnltrxid'];
  881. //$openid = $data['acct'];
  882. $remarks = $data['trxreserved'];
  883. // $remarks = '{"openid":"oEteU1VNvYozhXuu8TXhByPBtSl4","distribution_channel_id":2,"product_id":1,"uid":1,"price":"1","trade_no":"201711301937151585490779316114","create_ip":"::1","servicer":"AllinPay"}';
  884. $remarks = json_decode($remarks, true);
  885. Log::info('$remarks');
  886. Log::info($remarks);
  887. // 更新Order
  888. $order = OrderService::getByTradeNo($trade_no);
  889. // 防止重复推送
  890. if (isset($order->status) && $order->status == 'PAID') {
  891. Log::info('has_pay:' . $trade_no);
  892. echo 'success';
  893. exit();
  894. }
  895. $uid = $remarks['uid'];
  896. $distribution_channel_id = $remarks['dcd'];
  897. $product_id = $remarks['pd'];
  898. $product = ProductService::getProductSingle($product_id);
  899. $pay_merchant_source = $remarks['pms'];
  900. $pay_merchant_id = $remarks['pmi'];
  901. $send_order_id = $remarks['soi'];
  902. $create_ip = $remarks['cp'];
  903. $price = $product->price;
  904. $bid = $remarks['bid'];
  905. Log::info('save_order_end');
  906. //$this->updateOrderTotal($trade_no,$transaction_id);
  907. Log::info($product);
  908. Log::info('product_type:' . $product->type);
  909. $prize_fee = (int)(($product->price * 100) * 0.1);
  910. $this->substituteOrderPrice($order->id, $prize_fee);
  911. $this->smartPushTestBookPaidUv($order->from_bid, $order->uid, $order->price);
  912. //获取用户充值次数
  913. $order->pay_type = $this->getChargeTimes($order->uid);
  914. // 更新其他定制Order表
  915. if ($product->type == 'YEAR_ORDER') {
  916. Log::info('YEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDER');
  917. $order_type = 'YEAR';
  918. $this->yearOrder($uid, $distribution_channel_id, $price, $send_order_id);
  919. $order->order_type = $order_type;
  920. $order->status = 'PAID';
  921. $order->pay_end_at = date('Y-m-d H:i:s');
  922. $order->transaction_id = $transaction_id;
  923. $order->save();
  924. //$price = $price/100;
  925. /*
  926. $this->createOrder(
  927. compact(
  928. 'uid','distribution_channel_id','product_id','price','trade_no','send_order_id','order_type','pay_merchant_source',
  929. 'pay_merchant_id','create_ip','bid','transaction_id'
  930. )
  931. );*/
  932. } elseif ($product->type == 'BOOK_ORDER') {
  933. Log::info('BOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDER');
  934. $order_type = 'BOOK';
  935. $this->bookOrder($product_id, $uid, $send_order_id, $price, $distribution_channel_id);
  936. $order->order_type = $order_type;
  937. $order->status = 'PAID';
  938. $order->pay_end_at = date('Y-m-d H:i:s');
  939. $order->transaction_id = $transaction_id;
  940. $order->save();
  941. //$price = $price/100;
  942. /*
  943. $this->createOrder(
  944. compact(
  945. 'uid','distribution_channel_id','product_id','price','trade_no','send_order_id','order_type','pay_merchant_source',
  946. 'pay_merchant_id','create_ip','bid','transaction_id'
  947. )
  948. );*/
  949. } elseif ($product->type == 'TICKET_RECHARGE' || $product->type == 'NEW_USER') {
  950. Log::info('TICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGE');
  951. $order_type = 'RECHARGE';
  952. $this->userCharge($product, $uid);
  953. $order->order_type = $order_type;
  954. $order->status = 'PAID';
  955. $order->pay_end_at = date('Y-m-d H:i:s');
  956. $order->transaction_id = $transaction_id;
  957. $order->save();
  958. //$price = $price/100;
  959. /*
  960. $this->createOrder(
  961. compact(
  962. 'uid','distribution_channel_id','product_id','price','trade_no','send_order_id','order_type','pay_merchant_source',
  963. 'pay_merchant_id','create_ip','bid','transaction_id'
  964. ));*/
  965. } elseif ($product->type == 'FOREVER') {
  966. Log::info('FOREVER------------------------FOREVER');
  967. $order_type = 'FOREVER';
  968. $this->foreverFreeOrder($uid, $distribution_channel_id, $price, $send_order_id);
  969. $order->order_type = $order_type;
  970. $order->status = 'PAID';
  971. $order->pay_end_at = date('Y-m-d H:i:s');
  972. $order->transaction_id = $transaction_id;
  973. $order->save();
  974. }
  975. $this->successPayPushMsg($uid, $product, $order->id);
  976. $this->orderStatistical($order);
  977. DB::commit();
  978. $this->userProperty($uid,$price,$product->type,$order->activity_id);
  979. $this->huaweiActivity($order->activity_id,$uid,$product_id);
  980. //交换订单时间
  981. $this->exchangeUpdateAndCreated($order->id);
  982. //redis 删除未支付的uid
  983. try {
  984. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id:' . $distribution_channel_id;
  985. Redis::hdel($key, $uid);
  986. //Redis::srem($key,$uid);
  987. } catch (\Exception $e) {
  988. Log::info('redis remote error-----------------------');
  989. Log::info($e);
  990. }
  991. }
  992. } else {
  993. Log::info('allinpay_notify_sign_fail');
  994. }
  995. } catch (\Exception $e) {
  996. DB::rollBack();
  997. Log::info('receive_allinpay_ept:' . $e->getMessage());
  998. Log::info('pay_callback_end fail');
  999. echo 'fail';
  1000. return;
  1001. }
  1002. Log::info('pay_callback_end');
  1003. echo "success";
  1004. }
  1005. public function wcback_lianlianpay(Request $request)
  1006. {
  1007. $data = $request->getContent();
  1008. Log::info('wcback_lianlianpay call back enter');
  1009. Log::info($request->getContent());
  1010. $data = json_decode($data, true);
  1011. if ($data['result_pay'] == 'SUCCESS') {
  1012. $trade_no = $data['no_order'];
  1013. $order = OrderService::getByTradeNo($trade_no);
  1014. if (!$order) return response()->json(['ret_code' => '-1']);
  1015. $pay_merchant_id = $order->pay_merchant_id;
  1016. $pay_merchant = DB::table('pay_merchants')->select('appid', 'source', 'config_info')->where('id', $pay_merchant_id)->where('is_enabled', 1)->first();
  1017. unset($data['_url']);
  1018. if (!$pay_merchant->config_info) response()->json(['ret_code' => '-1']);
  1019. $wechatPay = WechatPay::instance('LIANLIANPAY', json_decode($pay_merchant->config_info, true));
  1020. $uid = $order->uid;
  1021. $distribution_channel_id = $order->distribution_channel_id;
  1022. $price = $order->price;
  1023. $send_order_id = $order->send_order_id;
  1024. $product_id = $order->product_id;
  1025. if (!$wechatPay->rsaCheck($data)) {
  1026. Log::info('sign check error');
  1027. //return response()->json(['ret_code'=>'-1']);
  1028. }
  1029. // 防止重复推送
  1030. if (isset($order->status) && $order->status == 'PAID') {
  1031. Log::info('has_pay:' . $trade_no);
  1032. return response()->json(['ret_code' => '0000', 'ret_msg' => '交易成功']);
  1033. }
  1034. DB::beginTransaction();
  1035. try {
  1036. $product = ProductService::getProductSingle($order->product_id);
  1037. $transaction_id = $data['oid_paybill'];
  1038. $prize_fee = (int)(($product->price * 100));
  1039. $this->substituteOrderPrice($order->id, $prize_fee);
  1040. $this->smartPushTestBookPaidUv($order->from_bid, $order->uid, $order->price);
  1041. //获取用户充值次数
  1042. $order->pay_type = $this->getChargeTimes($order->uid);
  1043. // 更新其他定制Order表
  1044. if ($product->type == 'YEAR_ORDER') {
  1045. Log::info('YEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDER');
  1046. $order_type = 'YEAR';
  1047. $this->yearOrder($uid, $distribution_channel_id, $price, $send_order_id);
  1048. $order->order_type = $order_type;
  1049. $order->status = 'PAID';
  1050. $order->pay_end_at = date('Y-m-d H:i:s');
  1051. $order->transaction_id = $transaction_id;
  1052. $order->save();
  1053. } elseif ($product->type == 'BOOK_ORDER') {
  1054. Log::info('BOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDER');
  1055. $order_type = 'BOOK';
  1056. $this->bookOrder($product_id, $uid, $send_order_id, $price, $distribution_channel_id);
  1057. $order->order_type = $order_type;
  1058. $order->status = 'PAID';
  1059. $order->pay_end_at = date('Y-m-d H:i:s');
  1060. $order->transaction_id = $transaction_id;
  1061. $order->save();
  1062. } elseif ($product->type == 'TICKET_RECHARGE' || $product->type == 'NEW_USER') {
  1063. Log::info('TICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGE');
  1064. $order_type = 'RECHARGE';
  1065. $this->userCharge($product, $uid);
  1066. $order->order_type = $order_type;
  1067. $order->status = 'PAID';
  1068. $order->pay_end_at = date('Y-m-d H:i:s');
  1069. $order->transaction_id = $transaction_id;
  1070. $order->save();
  1071. } elseif ($product->type == 'FOREVER') {
  1072. Log::info('FOREVER------------------------FOREVER');
  1073. $order_type = 'FOREVER';
  1074. $this->foreverFreeOrder($uid, $distribution_channel_id, $price, $send_order_id);
  1075. $order->order_type = $order_type;
  1076. $order->status = 'PAID';
  1077. $order->pay_end_at = date('Y-m-d H:i:s');
  1078. $order->transaction_id = $transaction_id;
  1079. $order->save();
  1080. }
  1081. $this->successPayPushMsg($uid, $product, $order->id);
  1082. $this->orderStatistical($order);
  1083. DB::commit();
  1084. $this->userProperty($uid,$price,$product->type,$order->activity_id);
  1085. $this->huaweiActivity($order->activity_id,$uid,$product_id);
  1086. //redis 删除未支付的uid
  1087. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id' . $distribution_channel_id;
  1088. Redis::hdel($key, $uid);
  1089. //交换订单时间
  1090. $this->exchangeUpdateAndCreated($order->id);
  1091. return response()->json(['ret_code' => '0000', 'ret_msg' => '交易成功']);
  1092. } catch (\Exception $e) {
  1093. DB::rollBack();
  1094. Log::info('lianlian:' . $e->getMessage());
  1095. echo 'fail';
  1096. return;
  1097. }
  1098. }
  1099. echo 'success';
  1100. }
  1101. /**
  1102. * 微众支付回调
  1103. * @param Request $request
  1104. */
  1105. function wcback_palmpay(Request $request)
  1106. {
  1107. Log::info('wcback_palmpay_request');
  1108. try {
  1109. $data = $request->except('_url');
  1110. Log::info($request->all());
  1111. //订单
  1112. $trade_no = $data['outTradeNo'];
  1113. $order = OrderService::getByTradeNo($trade_no);
  1114. if (!$order) die('failed');
  1115. // 防止重复推送
  1116. if (isset($order->status) && $order->status == 'PAID') {
  1117. if($data['chorderid'] != $order->transaction_id){
  1118. Log::info('palmpay order repeat');
  1119. $this->palmpaySpecial($data['chorderid'],$trade_no);
  1120. }
  1121. Log::info('has_pay:' . $trade_no);
  1122. echo 'success';
  1123. exit();
  1124. }
  1125. $pay_merchant = DB::table('pay_merchants')->select('appid', 'source', 'config_info')->where('id', $order->pay_merchant_id)->where('is_enabled', 1)->first();
  1126. //校验签名
  1127. $sign = _sign($data, json_decode($pay_merchant->config_info, 1)['appKey']);
  1128. if ($sign != $data['sign']) die('failed');
  1129. $transaction_id = $data['chorderid'];
  1130. if ($data['status'] == 'success') {
  1131. Log::info('wcback_palmpay_notify_sign_success');
  1132. if ($data['status'] == 'success') {
  1133. // 修改表比较多,开启事务
  1134. DB::beginTransaction();
  1135. // 更新Order
  1136. $order = OrderService::getByTradeNo($trade_no);
  1137. $uid = $order->uid;
  1138. $distribution_channel_id = $order->distribution_channel_id;
  1139. $product_id = $order->product_id;
  1140. $product = ProductService::getProductSingle($product_id);
  1141. $send_order_id = $order->send_order_id;
  1142. $price = $product->price;
  1143. Log::info('save_order_end');
  1144. Log::info($product);
  1145. Log::info('product_type:' . $product->type);
  1146. $prize_fee = (int)(($product->price * 100) * 0.1);
  1147. $this->substituteOrderPrice($order->id, $prize_fee);
  1148. $this->smartPushTestBookPaidUv($order->from_bid, $order->uid, $order->price);
  1149. //获取用户充值次数
  1150. $order->pay_type = $this->getChargeTimes($order->uid);
  1151. // 更新其他定制Order表
  1152. if ($product->type == 'YEAR_ORDER') {
  1153. Log::info('YEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDER');
  1154. $order_type = 'YEAR';
  1155. $this->yearOrder($uid, $distribution_channel_id, $price, $send_order_id);
  1156. $order->order_type = $order_type;
  1157. $order->status = 'PAID';
  1158. $order->pay_end_at = date('Y-m-d H:i:s');
  1159. $order->transaction_id = $transaction_id;
  1160. $order->save();
  1161. } elseif ($product->type == 'BOOK_ORDER') {
  1162. Log::info('BOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDER');
  1163. $order_type = 'BOOK';
  1164. $this->bookOrder($product_id, $uid, $send_order_id, $price, $distribution_channel_id);
  1165. $order->order_type = $order_type;
  1166. $order->status = 'PAID';
  1167. $order->pay_end_at = date('Y-m-d H:i:s');
  1168. $order->transaction_id = $transaction_id;
  1169. $order->save();
  1170. } elseif ($product->type == 'TICKET_RECHARGE' || $product->type == 'NEW_USER') {
  1171. Log::info('TICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGE');
  1172. $order_type = 'RECHARGE';
  1173. $this->userCharge($product, $uid);
  1174. $order->order_type = $order_type;
  1175. $order->status = 'PAID';
  1176. $order->pay_end_at = date('Y-m-d H:i:s');
  1177. $order->transaction_id = $transaction_id;
  1178. $order->save();
  1179. } elseif ($product->type == 'FOREVER') {
  1180. Log::info('FOREVER------------------------FOREVER');
  1181. $order_type = 'FOREVER';
  1182. $this->foreverFreeOrder($uid, $distribution_channel_id, $price, $send_order_id);
  1183. $order->order_type = $order_type;
  1184. $order->status = 'PAID';
  1185. $order->pay_end_at = date('Y-m-d H:i:s');
  1186. $order->transaction_id = $transaction_id;
  1187. $order->save();
  1188. }
  1189. $this->successPayPushMsg($uid, $product, $order->id);
  1190. $this->orderStatistical($order);
  1191. DB::commit();
  1192. //redis 删除未支付的uid
  1193. try {
  1194. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id:' . $distribution_channel_id;
  1195. Redis::hdel($key, $uid);
  1196. } catch (\Exception $e) {
  1197. Log::info('redis remote error-----------------------');
  1198. Log::info($e);
  1199. }
  1200. // 注册动作-》回调订单
  1201. $action_type = 'CallBackOrder';
  1202. $param = [
  1203. 'order_sn' => isset($trade_no) ? $trade_no : '0',
  1204. 'openid' => isset($uid) ? $uid : '0',// 没有openid,用uid写log
  1205. ];
  1206. UserService::PushUserActionToQueue($action_type, $distribution_channel_id, $param);
  1207. $this->userProperty($uid,$price,$product->type,$order->activity_id);
  1208. $this->huaweiActivity($order->activity_id,$uid,$product_id);
  1209. //交换订单时间
  1210. $this->exchangeUpdateAndCreated($order->id);
  1211. }
  1212. } else {
  1213. Log::info('wcback_palmpay_notify_sign_fail');
  1214. }
  1215. } catch (\Exception $e) {
  1216. var_dump($e->getMessage());
  1217. DB::rollBack();
  1218. Log::info('receive_wcback_palmpay_ept:' . $e->getMessage());
  1219. echo 'fail';
  1220. Log::info('pay_callback_end error');
  1221. return;
  1222. }
  1223. Log::info('pay_callback_end');
  1224. echo "success";
  1225. }
  1226. //平安银行支付回调
  1227. function wcback_originbank(Request $request)
  1228. {
  1229. Log::info($request->all());
  1230. Log::info('wcback_palmpay_request');
  1231. try {
  1232. $data = $request->except('_url');
  1233. unset($data['sign']);
  1234. //订单
  1235. $trade_no = $data['out_no'];
  1236. $order = OrderService::getByTradeNo($trade_no);
  1237. if (!$order) die('failed');
  1238. $pay_merchant = DB::table('pay_merchants')->select('appid', 'source', 'config_info')->where('id', $order->pay_merchant_id)->first();
  1239. // 防止重复推送
  1240. if (isset($order->status) && $order->status == 'PAID') {
  1241. Log::info('has_pay:' . $trade_no);
  1242. echo 'success';
  1243. exit();
  1244. }
  1245. //校验签名
  1246. // $sign = _sign($data, json_decode($pay_merchant->config_info, 1)['appKey']);
  1247. // if ($sign != $data['sign']) die('failed');
  1248. $trade_result = json_decode($data['trade_result'],true);
  1249. $transaction_id = $trade_result['transaction_id'];
  1250. if ($trade_result['return_code'] == 'SUCCESS') {
  1251. Log::info('wcback_palmpay_notify_sign_success');
  1252. // 修改表比较多,开启事务
  1253. DB::beginTransaction();
  1254. $uid = $order->uid;
  1255. $distribution_channel_id = $order->distribution_channel_id;
  1256. $product_id = $order->product_id;
  1257. $product = ProductService::getProductSingle($product_id);
  1258. $send_order_id = $order->send_order_id;
  1259. $price = $product->price;
  1260. Log::info('save_order_end');
  1261. Log::info($product);
  1262. Log::info('product_type:' . $product->type);
  1263. $prize_fee = (int)(($product->price * 100) * 0.1);
  1264. $this->substituteOrderPrice($order->id, $prize_fee);
  1265. $this->smartPushTestBookPaidUv($order->from_bid, $order->uid, $order->price);
  1266. //获取用户充值次数
  1267. $order->pay_type = $this->getChargeTimes($order->uid);
  1268. // 更新其他定制Order表
  1269. if ($product->type == 'YEAR_ORDER') {
  1270. Log::info('YEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDERYEAR_ORDER');
  1271. $order_type = 'YEAR';
  1272. $this->yearOrder($uid, $distribution_channel_id, $price, $send_order_id);
  1273. $order->order_type = $order_type;
  1274. $order->status = 'PAID';
  1275. $order->pay_end_at = date('Y-m-d H:i:s');
  1276. $order->transaction_id = $transaction_id;
  1277. $order->save();
  1278. } elseif ($product->type == 'BOOK_ORDER') {
  1279. Log::info('BOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDERBOOK_ORDER');
  1280. $order_type = 'BOOK';
  1281. $this->bookOrder($product_id, $uid, $send_order_id, $price, $distribution_channel_id);
  1282. $order->order_type = $order_type;
  1283. $order->status = 'PAID';
  1284. $order->pay_end_at = date('Y-m-d H:i:s');
  1285. $order->transaction_id = $transaction_id;
  1286. $order->save();
  1287. } elseif ($product->type == 'TICKET_RECHARGE' || $product->type == 'NEW_USER') {
  1288. Log::info('TICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGETICKET_RECHARGE');
  1289. $order_type = 'RECHARGE';
  1290. $this->userCharge($product, $uid);
  1291. $order->order_type = $order_type;
  1292. $order->status = 'PAID';
  1293. $order->pay_end_at = date('Y-m-d H:i:s');
  1294. $order->transaction_id = $transaction_id;
  1295. $order->save();
  1296. } elseif ($product->type == 'FOREVER') {
  1297. Log::info('FOREVER------------------------FOREVER');
  1298. $order_type = 'FOREVER';
  1299. $this->foreverFreeOrder($uid, $distribution_channel_id, $price, $send_order_id);
  1300. $order->order_type = $order_type;
  1301. $order->status = 'PAID';
  1302. $order->pay_end_at = date('Y-m-d H:i:s');
  1303. $order->transaction_id = $transaction_id;
  1304. $order->save();
  1305. }
  1306. $this->successPayPushMsg($uid, $product, $order->id);
  1307. $this->orderStatistical($order);
  1308. DB::commit();
  1309. //redis 删除未支付的uid
  1310. try {
  1311. $key = 'leyuee:to_send_not_pay_uid:distribution_channel_id:' . $distribution_channel_id;
  1312. Redis::hdel($key, $uid);
  1313. } catch (\Exception $e) {
  1314. Log::info('redis remote error-----------------------');
  1315. Log::info($e);
  1316. }
  1317. // 注册动作-》回调订单
  1318. $action_type = 'CallBackOrder';
  1319. $param = [
  1320. 'order_sn' => isset($trade_no) ? $trade_no : '0',
  1321. 'openid' => isset($uid) ? $uid : '0',// 没有openid,用uid写log
  1322. ];
  1323. UserService::PushUserActionToQueue($action_type, $distribution_channel_id, $param);
  1324. $this->userProperty($uid,$price,$product->type,$order->activity_id);
  1325. $this->huaweiActivity($order->activity_id,$uid,$product_id);
  1326. //交换订单时间
  1327. $this->exchangeUpdateAndCreated($order->id);
  1328. }else {
  1329. Log::info('wcback_palmpay_notify_sign_fail');
  1330. }
  1331. } catch (\Exception $e) {
  1332. var_dump($e->getMessage());
  1333. DB::rollBack();
  1334. Log::info('receive_wcback_palmpay_ept:' . $e->getMessage());
  1335. echo 'fail';
  1336. Log::info('pay_callback_end error');
  1337. return;
  1338. }
  1339. Log::info('pay_callback_end');
  1340. echo "success";
  1341. }
  1342. /**
  1343. * 公众号签名@华灯初上
  1344. * @param $params
  1345. * @return string
  1346. */
  1347. protected function getSign($params, $key)
  1348. {
  1349. $url = $this->arr_to_url($params, false);
  1350. $url = $url . '&key=' . $key;
  1351. $sign = md5($url);
  1352. return $sign;
  1353. }
  1354. /**
  1355. * 公众号签名@华灯初上
  1356. * @param $array
  1357. * @param bool $has_sign
  1358. * @return string
  1359. */
  1360. protected function arr_to_url($array, $has_sign = false)
  1361. {
  1362. ksort($array);
  1363. reset($array);
  1364. $arg = "";
  1365. while (list ($name, $val) = each($array)) {
  1366. if ($name == 'sign' && !$has_sign) continue;
  1367. if (strpos($name, "_") === 0)
  1368. continue;
  1369. if (is_array($val))
  1370. $val = join(',', $val);
  1371. if ($val === "")
  1372. continue;
  1373. $arg .= $name . "=" . $val . "&";
  1374. }
  1375. $arg = substr($arg, 0, count($arg) - 2);
  1376. return $arg;
  1377. }
  1378. /**
  1379. * 单本充值会掉
  1380. * @param $product_id
  1381. * @param $uid
  1382. * @param $send_order_id
  1383. * @param $fee
  1384. */
  1385. protected function bookOrder($product_id, $uid, $send_order_id, $fee, $distribution_channel_id)
  1386. {
  1387. $book_conf = BookConfigService::getBookByProduct($product_id);
  1388. $insert_data['bid'] = isset($book_conf->bid) ? $book_conf->bid : '';
  1389. $insert_data['book_name'] = isset($book_conf->book_name) ? $book_conf->book_name : '';
  1390. $insert_data['uid'] = $uid;
  1391. $insert_data['distribution_channel_id'] = $distribution_channel_id;
  1392. $insert_data['fee'] = $fee;
  1393. $insert_data['send_order_id'] = $send_order_id;
  1394. $insert_data['charge_balance'] = 0;
  1395. $insert_data['reward_balance'] = 0;
  1396. Log::info('start_save_book_order');
  1397. Log::info($insert_data);
  1398. return BookOrderService::save_book_order($insert_data);
  1399. }
  1400. /**
  1401. * 包年
  1402. * @param $uid
  1403. * @param $distribution_channel_id
  1404. * @param $fee
  1405. * @param $send_order_id
  1406. * @return mixed
  1407. */
  1408. protected function yearOrder($uid, $distribution_channel_id, $fee, $send_order_id)
  1409. {
  1410. Log::info('start_save_year_order');
  1411. $insert_data['uid'] = $uid;
  1412. $insert_data['distribution_channel_id'] = $distribution_channel_id;
  1413. $insert_data['fee'] = $fee;
  1414. $insert_data['send_order_id'] = $send_order_id;
  1415. Log::info($insert_data);
  1416. return YearOrderService::save_year_order($insert_data);
  1417. }
  1418. private function foreverFreeOrder($uid, $distribution_channel_id, $fee, $send_order_id)
  1419. {
  1420. Log::info('start_save_year_order');
  1421. ('start_forever_Free_Order');
  1422. $insert_data['uid'] = $uid;
  1423. $insert_data['distribution_channel_id'] = $distribution_channel_id;
  1424. $insert_data['fee'] = $fee;
  1425. $insert_data['send_order_id'] = $send_order_id;
  1426. Log::info($insert_data);
  1427. return YearOrderService::foreverFree($insert_data);
  1428. }
  1429. /**
  1430. * 用户充值
  1431. * @param $product
  1432. * @param $uid\
  1433. */
  1434. protected function userCharge($product, $uid)
  1435. {
  1436. $total = $product->price * 100 + $product->given;
  1437. UserService::addBalance($uid, $total, $product->price * 100, $product->given);
  1438. Log::info('update_user_balance_end:' . $uid . ' balance_add:' . $total);
  1439. }
  1440. /**
  1441. * 添加订单
  1442. * @param array $data
  1443. * @return mixed
  1444. */
  1445. protected function createOrder(array $data)
  1446. {
  1447. $insert_data = array();
  1448. $insert_data['uid'] = $data['uid'];
  1449. $insert_data['distribution_channel_id'] = $data['distribution_channel_id'];
  1450. $insert_data['product_id'] = $data['product_id'];
  1451. $insert_data['price'] = $data['price'];
  1452. $insert_data['status'] = 'PAID';
  1453. $insert_data['pay_type'] = 1;
  1454. $insert_data['trade_no'] = $data['trade_no'];
  1455. $insert_data['send_order_id'] = $data['send_order_id'];
  1456. $insert_data['order_type'] = $data['order_type'];
  1457. $insert_data['pay_merchant_source'] = $data['pay_merchant_source'];
  1458. $insert_data['pay_merchant_id'] = $data['pay_merchant_id'];
  1459. $insert_data['transaction_id'] = $data['transaction_id'];
  1460. $insert_data['pay_end_at'] = date('Y-m-d H:i:s');
  1461. $insert_data['create_ip'] = $data['create_ip'];
  1462. $insert_data['from_bid'] = $data['bid'];
  1463. Log::info('createOrder');
  1464. Log::info($insert_data);
  1465. return OrderService::save_order($insert_data);
  1466. }
  1467. /**
  1468. * 添加位置付订单
  1469. * @param $data
  1470. * @return mixed
  1471. */
  1472. protected function createUnPayOrder($data)
  1473. {
  1474. $data['status'] = 'UNPAID';
  1475. $data['transaction_id'] = '';
  1476. $data['pay_end_at'] = '0000-00-00 00:00:00';
  1477. return OrderService::save_order($data);
  1478. }
  1479. /**
  1480. * order total
  1481. * @param $data
  1482. *
  1483. */
  1484. protected function createOrderTotal($data)
  1485. {
  1486. $data['status'] = 'UNPAID';
  1487. $data['created_at'] = date('Y-m-d H:i:s');
  1488. $data['updated_at'] = date('Y-m-d H:i:s');
  1489. DB::table('orders_total')->insert($data);
  1490. }
  1491. protected function updateOrderTotal($trade_no, $transaction_id)
  1492. {
  1493. $data['status'] = 'PAID';
  1494. $data['transaction_id'] = $transaction_id;
  1495. $data['pay_end_at'] = date('Y-m-d H:i:s');
  1496. //DB::table('orders_total')->where('trade_no',$trade_no)->update($data);
  1497. }
  1498. protected function successPayPushMsg($uid, $product_info, $order_id)
  1499. {
  1500. try {
  1501. $force_sub_info = $this->getSubscribeV2($uid);
  1502. $data = UserService::getById($uid);
  1503. if (!in_array($data->distribution_channel_id, [5, 123])) {
  1504. //return false;
  1505. }
  1506. if ($force_sub_info) {
  1507. //$content_format = "您好,你已经成功充值\r\n\r\n会员:%s\r\n会员ID:%s\r\n充值金额:%s\r\n充值状态:充值成功\r\n如有疑问,请点击用户中心-联系客服\r\n\r\n><a href='%s'>点击继续阅读上次阅读</a>";
  1508. if (SubstituteOrderService::getByOrderId($order_id)) {
  1509. $content_format = "代充值客服消息:\r\n\r\n你好,您的好友为你代付成功\r\n会员:%s\r\n会员ID:%s\r\n代付金额:%s\r\n充值状态:充值成功\r\n赠送的礼物道具在阅读页-送礼物\r\n\r\n><a href='%s'>点击继续上次阅读</a>";
  1510. } else {
  1511. $content_format = "您好,你已经成功充值\r\n\r\n会员:%s\r\n会员ID:%s\r\n充值金额:%s\r\n充值状态:充值成功\r\n赠送的礼物道具在阅读页-送礼物\r\n\r\n><a href='%s'>点击继续上次阅读</a>";
  1512. }
  1513. if ($product_info->type == 'YEAR_ORDER') {
  1514. $money_text = $product_info->price . '元(尊贵的年费VIP会员)';
  1515. } elseif ($product_info->type == 'TICKET_RECHARGE') {
  1516. if ($product_info->given) {
  1517. $money_text = $product_info->price . '元(' . ($product_info->price * 100) . '书币+赠送' . $product_info->given . '书币)';
  1518. } else {
  1519. $money_text = $product_info->price . '元(' . ($product_info->price * 100) . '书币)';
  1520. }
  1521. } else {
  1522. $money_text = '未知';
  1523. }
  1524. $delay = 0;
  1525. $url = env('PROTOCOL') . '://site' . encodeDistributionChannelId($data->distribution_channel_id) . '.' . env('CUSTOM_HOST') . '.com/continue';;
  1526. $content = sprintf($content_format, $data->nickname ? $data->nickname : '匿名', $uid, $money_text, $url);
  1527. foreach ($force_sub_info as $item) {
  1528. $appid = $item->appid;
  1529. $gzh = OfficialAccountService::officialAccountByAppid(compact('appid'));
  1530. $top_url = OfficialAccountService::getTopUrl($gzh->service_type_info);
  1531. if($gzh->service_type_info == 1)
  1532. {
  1533. $top_content = "\r\n\r\n为方便阅读,请<a href='{$top_url}'>设为星标</a>";
  1534. }else{
  1535. $top_content = "\r\n\r\n为方便阅读,请<a href='{$top_url}'>置顶公众号</a>";
  1536. }
  1537. $content .= $top_content.$top_content.$top_content;
  1538. $res['openid'] = $item->openid;
  1539. $res['appid'] = $item->appid;
  1540. $res['content'] = $content;
  1541. $res['type'] = 'one_task';
  1542. $res['send_time'] = date("Y-m-d H:i:s");
  1543. $res['task_id'] = md5('pay_success_push');
  1544. $send_data = array(
  1545. 'send_time' => date("Y-m-d H:i:s"),
  1546. 'data' => $res
  1547. );
  1548. dispatch((new SendTexts($send_data))->onConnection('rabbitmq')->delay($delay)->onQueue('send_texts_list'));
  1549. }
  1550. }
  1551. } catch (\Exception $e) {
  1552. Log::info('pay_success_push error');
  1553. Log::info($e);
  1554. }
  1555. return true;
  1556. }
  1557. private function orderStatistical($order)
  1558. {
  1559. try {
  1560. $send_data = array(
  1561. 'type' => 'order_info',
  1562. 'data' => $order->toArray()
  1563. );
  1564. $send = new SendStatisticsList($send_data);
  1565. $job = ($send)->onConnection('rabbitmq')->delay(0)->onQueue('send_statistics_list');
  1566. dispatch($job);
  1567. } catch (\Exception $e) {
  1568. Log::info($e);
  1569. }
  1570. //灵界的推送统计\App\Modules\Statistic\Services\WapVisitStatService::customerAllStats
  1571. try {
  1572. if ($order->from_type) {
  1573. $pv = Redis::hget('push:distribution_channel_id:allpv', $order->from_type);
  1574. if ($pv) {
  1575. Redis::sadd('push:all:paidnum:from:' . $order->from_type, $order->uid);
  1576. $old = Redis::hget('push:all:paidamount', $order->from_type);
  1577. if ($old) {
  1578. Redis::hset('push:all:paidamount', $order->from_type, $old + $order->price);
  1579. } else {
  1580. Redis::hset('push:all:paidamount', $order->from_type, $order->price);
  1581. }
  1582. }
  1583. }
  1584. if (isset($order->pay_merchant_id) && $order->pay_merchant_id)//临时统计队列清0 用于报警
  1585. {
  1586. $key = 'pay_merchant:' . $order->pay_merchant_id;
  1587. Redis::hset($key, 'unpaid_num', 0);
  1588. }
  1589. } catch (\Exception $e) {
  1590. }
  1591. }
  1592. private function getSubscribe($uid)
  1593. {
  1594. return ForceSubscribeService::forceSubscribeUsersByUid(['uid' => $uid]);
  1595. }
  1596. private function getSubscribeV2($uid)
  1597. {
  1598. return DB::table('force_subscribe_users')->where('uid', $uid)->where('is_subscribed', 1)->get();
  1599. }
  1600. public function getSubscribeOfficialName($uid, $distribution_channel_id)
  1601. {
  1602. $subscribe = $this->getSubscribe($uid);
  1603. if ($subscribe && isset($subscribe->appid)) {
  1604. $official = DB::table('official_accounts')->where('appid', $subscribe->appid)->select('nickname')->first();
  1605. if ($official && isset($official->nickname)) {
  1606. return $official->nickname;
  1607. }
  1608. }
  1609. $res = OfficialAccountService::canUseOfficialAccountByChannelId(compact('distribution_channel_id'));
  1610. if (isset($res->nickname) && !empty($res->nickname)) {
  1611. return $res->nickname;
  1612. }
  1613. try {
  1614. $official = DB::table('official_accounts')
  1615. ->where('distribution_channel_id', $distribution_channel_id)
  1616. ->where('is_auth', 1)
  1617. ->orderBy('id', 'desc')
  1618. ->select('nickname')->first();
  1619. if ($official && isset($official->nickname)) {
  1620. return $official->nickname;
  1621. }
  1622. } catch (\Exception $e) {
  1623. }
  1624. return '';
  1625. }
  1626. private function payAlert($pay_merchant_id, $trade_no = '', $pay_info = '', $n = 0)
  1627. {
  1628. $change_pay_id = 40;
  1629. if ($pay_merchant_id == 40) {
  1630. $change_pay_id = 9;
  1631. }
  1632. try {
  1633. $time = (int)date('G');
  1634. $change = false;
  1635. if ($time <= 8 || $time >= 23) {
  1636. if (!$pay_info && $pay_merchant_id != $change_pay_id) {
  1637. DB::table('distribution_channels')->where('pay_merchant_id', $pay_merchant_id)->update(['pay_merchant_id' => $change_pay_id]);
  1638. $change = true;
  1639. }
  1640. }
  1641. //$number,$template_type,$param=array()
  1642. $phone_arr = ['15868100210', '15088790066', '13858057394', '18668029091', '18668420256'];
  1643. //$phone_arr = ['18668029091'];
  1644. $param = ['pay_id' => $pay_merchant_id];
  1645. if ($n) {
  1646. $template_type = 'pay_channel_remind';
  1647. //$content = '支付通道:' . $pay_merchant_id . ',获取授权信息失败';
  1648. } else {
  1649. $template_type = 'pay_channel_remind';
  1650. //$content = '支付通道:' . $pay_merchant_id . ',订单号为' . $trade_no . '支付异常,异常信息:' . json_encode($pay_info);
  1651. }
  1652. if ($change) {
  1653. $template_type = 'pay_channel_change';
  1654. $param = ['pay_id' => $pay_merchant_id, 'new_pay_id' => $change_pay_id];
  1655. }
  1656. $last_alert_time = Redis::hget('autopayalert',$pay_merchant_id);
  1657. if($last_alert_time && (time() -$last_alert_time) <= 3600 ){
  1658. return ;
  1659. }
  1660. Redis::hset('autopayalert',$pay_merchant_id,time());
  1661. foreach ($phone_arr as $phone) {
  1662. AliSMS::send($phone, $template_type, $param);
  1663. }
  1664. } catch (\Exception $e) {
  1665. }
  1666. }
  1667. private function createSubstituteOrder($order_id, $uid, $pay_uid)
  1668. {
  1669. SubstituteOrderService::createOrder($order_id, $uid, $pay_uid);
  1670. }
  1671. private function recordOtherParam($order_id, $uid)
  1672. {
  1673. $gxhp = ReadRecordService::getByField($uid, 'gxhp');
  1674. if ($gxhp) {
  1675. OrderParamService::create($order_id, $gxhp);
  1676. }
  1677. }
  1678. private function substituteOrderPrice($order_id, $prize_fee = 500)
  1679. {
  1680. SubstituteOrderService::SubstituteOrderPrize($order_id, $prize_fee);
  1681. }
  1682. private function updateUserSendOrderId(int $uid, $send_order_id)
  1683. {
  1684. if ($send_order_id && $uid) {
  1685. $user = UserService::getById($uid);
  1686. if ($user && !$user->send_order_id) {
  1687. UserService::updateInfo($uid, compact('send_order_id'));
  1688. }
  1689. }
  1690. }
  1691. /**
  1692. * 测书智能推送统计 付费用户数、充值金额
  1693. * @param $bid
  1694. * @param $uid
  1695. * @param $price
  1696. */
  1697. private function smartPushTestBookPaidUv($bid, $uid, $price)
  1698. {
  1699. $smart_bid = ReadRecordService::getSmartPush($uid);
  1700. if ($smart_bid && in_array($bid, $smart_bid)) {
  1701. try {
  1702. //$key = 'smartPushTestBookPaidUv:bid:%s';
  1703. //Redis::sadd(sprintf($key, $bid), $uid);
  1704. $now_amount = Redis::hget('smartPushTestBookPaidAmount', $bid);
  1705. if (!$now_amount) {
  1706. $now_amount = 0;
  1707. }
  1708. Redis::hset('smartPushTestBookPaidAmount', $bid, $now_amount + $price);
  1709. } catch (\Exception $e) {
  1710. }
  1711. }
  1712. }
  1713. /**
  1714. * 获取用户第几次充值
  1715. * @param $uid
  1716. * @return int
  1717. */
  1718. private function getChargeTimes($uid)
  1719. {
  1720. $count = OrderService::getUserChargeTimes($uid);
  1721. return $count + 1;
  1722. }
  1723. //米玩 订单转移
  1724. private function transfer($distribution_channel_id)
  1725. {
  1726. if (in_array($distribution_channel_id, explode(',', redisEnv('MIWAN_TRANSFER_CHANNEL_ID', 1)))) {
  1727. $random = random_int(1, 100);
  1728. $miwan_transfer_probability = redisEnv('MIWAN_TRANSFER_PROBABILITY', 0);
  1729. $miwan_transfer_to_channel_id = redisEnv('MIWAN_TRANSFER_TO_CHANNEL_ID', 0);
  1730. if ($miwan_transfer_to_channel_id && $random <= $miwan_transfer_probability) {
  1731. return $miwan_transfer_to_channel_id;
  1732. }
  1733. }
  1734. return 0;
  1735. }
  1736. private function userProperty($uid,$price,$charge_type,$activity_id){
  1737. try{
  1738. $old_property = UserDivisionCpcPropertyService::getUserProperty($uid);
  1739. if(!$activity_id){
  1740. $this->chargeGiveGift($uid,$old_property,$price,$charge_type);
  1741. }
  1742. $userproperty = UserDivisionCpcPropertyService::getUserSubscribeAndChargeInfoByUid($uid);
  1743. if(!$userproperty) {
  1744. return ;
  1745. }
  1746. UserDivisionCpcPropertyService::createorUpdate($userproperty);
  1747. }catch (\Exception $e){}
  1748. }
  1749. private function huaweiActivity($activity_id,$uid,$product_id){
  1750. return ;
  1751. /*$huawei_activity_id = redisEnv('HUAWEI_ACTIVITY_ID');
  1752. if($huawei_activity_id && $activity_id && $activity_id == $huawei_activity_id){
  1753. $product_id_relate_lottery_count = ['6117'=>1,'6118'=>2,'6119'=>4,'6120'=>8];
  1754. if(isset($product_id_relate_lottery_count[$product_id])){
  1755. $info = DB::table('huaweilottery_user_counts')->where('uid',$uid)->select('count')->first();
  1756. if($info){
  1757. DB::table('huaweilottery_user_counts')->where('uid',$uid)->update([
  1758. 'uid'=>$uid,
  1759. 'count'=>$info->count+$product_id_relate_lottery_count[$product_id],
  1760. 'updated_at'=>date('Y-m-d H:i:s')
  1761. ]);
  1762. }else{
  1763. DB::table('huaweilottery_user_counts')->insert([
  1764. 'uid'=>$uid,
  1765. 'count'=>$product_id_relate_lottery_count[$product_id],
  1766. 'updated_at'=>date('Y-m-d H:i:s'),
  1767. 'created_at'=>date('Y-m-d H:i:s')
  1768. ]);
  1769. }
  1770. }
  1771. }*/
  1772. }
  1773. private function palmpaySpecial($transaction_id,$trade_no)
  1774. {
  1775. try{
  1776. $order = OrderService::getByTradeNo($trade_no);
  1777. $product_id = $order->product_id;
  1778. $product = ProductService::getProductSingle($product_id);
  1779. $init_order = [
  1780. 'distribution_channel_id' => $order->distribution_channel_id,
  1781. 'uid' => $order->uid,
  1782. 'product_id' => $product_id,
  1783. 'price' => $order->price,
  1784. 'pay_type' => 1,
  1785. 'trade_no' => $order->uid.'-'.$order->id,
  1786. 'pay_merchant_source' => $order->pay_merchant_source,
  1787. 'pay_merchant_id' => $order->pay_merchant_id,
  1788. 'create_ip' => $order->create_ip,
  1789. 'send_order_id' => $order->send_order_id,
  1790. 'send_order_name' => $order->send_order_name,
  1791. 'order_type' => $order->order_type,
  1792. 'from_bid' => $order->from_bid,
  1793. 'from_type' => $order->from_type,
  1794. 'activity_id' => $order->activity_id,
  1795. 'inner_send_order_id' => $order->inner_send_order_id,
  1796. 'status'=>'PAID',
  1797. 'transaction_id'=>$transaction_id,
  1798. 'pay_end_at'=>date('Y-m-d H:i:s')
  1799. ];
  1800. OrderService::save_order($init_order);
  1801. if ($product->type == 'YEAR_ORDER') {
  1802. Log::info('palmpaySpecial YEAR_ORDER');
  1803. $this->yearOrder($order->uid, $order->distribution_channel_id, $order->price, $order->send_order_id);
  1804. } elseif ($product->type == 'BOOK_ORDER') {
  1805. Log::info('palmpaySpecial BOOK_ORDER');
  1806. $this->bookOrder($product_id, $order->ui, $order->send_order_id, $order->price, $order->distribution_channel_id);
  1807. } elseif ($product->type == 'TICKET_RECHARGE' || $product->type == 'NEW_USER') {
  1808. Log::info('palmpaySpecial TICKET_RECHARGE');
  1809. $this->userCharge($product, $order->uid);
  1810. } elseif ($product->type == 'FOREVER') {
  1811. Log::info('palmpaySpecial-------FOREVER');
  1812. $this->foreverFreeOrder($order->uid, $order->distribution_channel_id, $order->price, $order->send_order_id);
  1813. }
  1814. }catch (\Exception $e){
  1815. Log::info($e);
  1816. }
  1817. }
  1818. private function chargeGiveGift($uid,$property,$price,$charge_type){
  1819. $gift = BookGiftsService::chargeGiveGift($property,$price,$charge_type);
  1820. if($gift){
  1821. UserGiftService::addGift($uid,$gift);
  1822. }
  1823. return ;
  1824. }
  1825. private function orderParamWso($uid,$order_id){
  1826. list($new_outer,$new_inner,$new_total) = ReadRecordService::getByMultiField($uid,'new_outer','new_inner','new_total');
  1827. if(!$new_outer && !$new_inner && !$new_total){
  1828. return ;
  1829. }
  1830. if(!$new_total) return ;
  1831. $new_outer = $new_outer?$new_outer:0;
  1832. $new_inner = $new_inner?$new_inner:0;
  1833. $total_type = '';
  1834. $total_param_id = 0;
  1835. if(is_numeric($new_total)){
  1836. $send_order_info = SendOrderService::getById($new_total);
  1837. $total_param_id = $new_total;
  1838. $total_type = 'none';
  1839. if($send_order_info && isset($send_order_info->promotion_type)){
  1840. if($send_order_info->promotion_type == 'EXTERNAL'){
  1841. $total_type = 'OUTER';
  1842. }
  1843. if($send_order_info->promotion_type == 'INTERNAL'){
  1844. $total_type = 'INNER';
  1845. }
  1846. }
  1847. }
  1848. if(str_contains($new_total,'custom')){
  1849. $total_type = 'CUSTOM';
  1850. $temp = explode('_',$new_total);
  1851. if(isset($temp[1]) && is_numeric($temp[1])){
  1852. $total_param_id = $temp[1];
  1853. }
  1854. }
  1855. if(str_contains($new_total,'template')){
  1856. $total_type = 'TEMPLATE';
  1857. $temp = explode('_',$new_total);
  1858. if(isset($temp[1]) && is_numeric($temp[1])){
  1859. $total_param_id = $temp[1];
  1860. }
  1861. }
  1862. if($total_type){
  1863. OrderParamWsoService::createOrder($order_id,
  1864. $new_inner,
  1865. $new_outer,
  1866. $total_param_id,
  1867. $new_total,
  1868. $total_type);
  1869. }
  1870. }
  1871. private function exchangeUpdateAndCreated($order_id){
  1872. /*try{
  1873. $info = DB::table('orders')->where('id',$order_id)->select('created_at','updated_at')->first();
  1874. DB::table('orders')->where('id',$order_id)
  1875. ->update([
  1876. 'created_at'=>$info->updated_at,
  1877. 'updated_at'=>$info->created_at
  1878. ]);
  1879. }catch (\Exception $e){}*/
  1880. }
  1881. }