TestController.php 54 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220
  1. <?php
  2. namespace ghs\controllers;
  3. use biz\ghs\classes\GhsClass;
  4. use biz\shop\classes\ShopClass;
  5. use biz\sj\services\MerchantService;
  6. use biz\wx\classes\WxMessageClass;
  7. use bizGhs\custom\classes\CustomClass;
  8. use bizGhs\custom\classes\CustomDebtChangeClass;
  9. use bizGhs\express\services\DadaExpressServices;
  10. use bizGhs\order\classes\OrderClass;
  11. use bizGhs\order\classes\OrderItemClass;
  12. use bizGhs\order\classes\RefundOrderClass;
  13. use bizHd\message\classes\InformAdminClass;
  14. use bizHd\order\services\OrderService;
  15. use bizHd\purchase\classes\PurchaseClass;
  16. use bizHd\purchase\classes\PurchaseClearClass;
  17. use bizHd\wx\classes\WxOpenClass;
  18. use bizGhs\express\services\MiniExpressService;
  19. use common\components\arrayUtil;
  20. use common\components\dateUtil;
  21. use common\components\dict;
  22. use common\components\lakala\Lakala;
  23. use common\components\miniUtil;
  24. use common\components\noticeUtil;
  25. use common\components\orderSn;
  26. use common\components\wxUtil;
  27. use common\components\payUtil;
  28. use Yii;
  29. use common\components\util;
  30. use wkhtmltox\Image\Converter;
  31. class TestController extends BaseController
  32. {
  33. public $guestAccess = ['fx','on', 'in', 'clear-query', 'ip', 'html', 'debt', 'apply', 'clear', 'ls-trade-query', 'refund-query', 'inform', 'notice', 'order-query', 'add-order', 'index', 'get', 'trade-query', 'query', 'balance-query', 'refund'];
  34. public function actionFx(){
  35. $ghsShopId = 7855;
  36. $ghsShop = ShopClass::getById($ghsShopId, true);
  37. if (empty($ghsShop)) {
  38. util::fail('没有找到供货商的门店');
  39. }
  40. $refundFee = bcmul(64, 100);
  41. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  42. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  43. $params = [
  44. 'appid' => 'OP00002119',
  45. 'serial_no' => '018b08cfddbd',
  46. 'merchant_no' => $ghsShop->lklSjNo,
  47. 'term_no' => $ghsShop->lklScanTermNo,
  48. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  49. 'lklCertificatePath' => $lklCertificatePath,
  50. ];
  51. $laResource = new Lakala($params);
  52. $refundReason = '';
  53. $aliParams = [
  54. 'refundSn' => 'RD_CS001',
  55. 'orderSn' => 'CG27325720',
  56. 'refundAmount' => $refundFee,
  57. 'refundReason' => $refundReason,
  58. 'thirdNo' => '20240723110113130266217435048128',
  59. ];
  60. $response = $laResource->refund($aliParams);
  61. echo '<pre>';
  62. print_r($response);
  63. }
  64. public function actionOn()
  65. {
  66. echo "<pre>";
  67. $cacheKey = 'test';
  68. Yii::$app->redis->executeCommand('HSET', [$cacheKey, 'shish', 1]);
  69. echo Yii::$app->redis->executeCommand('HGET', [$cacheKey, 'shish']);
  70. $return = Yii::$app->redis->executeCommand('HEXISTS', [$cacheKey, 'shish']);
  71. var_dump($return);
  72. Yii::$app->redis->executeCommand('HSET', [$cacheKey, 'sofashi', 2]);
  73. Yii::$app->redis->executeCommand('HSET', [$cacheKey, 'lgl', 3]);
  74. $arr = Yii::$app->redis->executeCommand('HKEYS', [$cacheKey]);
  75. print_r($arr);
  76. Yii::$app->redis->executeCommand('HDEL', [$cacheKey, 'lgl']);
  77. $arr = Yii::$app->redis->executeCommand('HKEYS', [$cacheKey]);
  78. print_r($arr);
  79. }
  80. public function actionIn()
  81. {
  82. $searchTime = 'custom';
  83. $startTime = '2024-05-04';
  84. $endTime = '2024-05-04';
  85. $mainId = 23390;
  86. $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
  87. $start = $period['startTime'];
  88. $end = $period['endTime'];
  89. $where['time'] = ['between', [$start, $end]];
  90. $currentStartDate = date('Y-m-d', strtotime($start));
  91. $currentEndDate = date('Y-m-d', strtotime($end));
  92. $currentStartTime = $currentStartDate . ' 00:00:00';
  93. $currentEndTime = $currentEndDate . ' 23:59:59';
  94. $totalAmount = 0;
  95. $itemTotalAmount = 0;
  96. $where = ['mainId' => $mainId, 'status' => ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]]];
  97. $where['payTime'] = ['between', [$currentStartTime, $currentEndTime]];
  98. $ghsOrderList = OrderClass::getAllByCondition($where, null, '*');
  99. if (!empty($ghsOrderList)) {
  100. foreach ($ghsOrderList as $ghsKey => $ghsOrder) {
  101. $book = $ghsOrder['book'] ?? 0;
  102. $status = $ghsOrder['status'] ?? 0;
  103. $orderSn = $ghsOrder['orderSn'] ?? '';
  104. $actPrice = $ghsOrder['actPrice'] ?? 0;
  105. $discountAmount = $ghsOrder['discountAmount'] ?? 0;
  106. $labourCost = $ghsOrder['labourCost'] ?? 0;
  107. $tkPrice = $ghsOrder['tkPrice'] ?? 0;
  108. if ($book == 1 && $status == 2) {
  109. //预订单待发货的不算收入
  110. continue;
  111. }
  112. if ($status == 0 || $status == 5) {
  113. continue;
  114. }
  115. $totalAmount = bcadd($totalAmount, $actPrice, 2);
  116. $orderItemList = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*', null, true);
  117. $currentAmount = 0;
  118. if (!empty($orderItemList)) {
  119. foreach ($orderItemList as $orderItem) {
  120. $refundNum = $orderItem->refundNum ?? 0;
  121. $name = $orderItem->name ?? '';
  122. $productId = $orderItem->productId ?? 0;
  123. $num = $orderItem->xhNum ?? 0;
  124. $xhUnitPrice = $orderItem->xhUnitPrice ?? 0;
  125. $remainNum = bcsub($num, $refundNum);
  126. $classId = $orderItem->classId ?? 0;
  127. $className = $classList[$classId]['name'] ?? '已删除';
  128. $amount = bcmul($remainNum, $xhUnitPrice, 2);
  129. $currentAmount = bcadd($currentAmount, $amount, 2);
  130. $arr[$classId]['className'] = $className;
  131. $arr[$classId]['classId'] = $classId;
  132. if (isset($arr[$classId]['income'])) {
  133. $arr[$classId]['income'] = bcadd($amount, $arr[$classId]['income'], 2);
  134. } else {
  135. $arr[$classId]['expend'] = 0;
  136. $arr[$classId]['income'] = $amount;
  137. }
  138. }
  139. if (floatval($currentAmount) != floatval($actPrice) && $discountAmount <= 0 && $labourCost <= 0 && $tkPrice <= 0) {
  140. echo $orderSn . ' ' . $currentAmount . ' ' . $actPrice . ' ' . $discountAmount . ' ' . $labourCost . ' ' . $tkPrice;
  141. die;
  142. }
  143. if (floatval($actPrice) != floatval($currentAmount)) {
  144. echo $actPrice . ' ' . $currentAmount . ' ' . $orderSn . ' ====' . abs(bcsub($actPrice, $currentAmount, 2)) . "\n";
  145. } else {
  146. echo $actPrice . ' ' . $currentAmount . ' ' . $orderSn . "\n";
  147. }
  148. $itemTotalAmount = bcadd($itemTotalAmount, $currentAmount, 2);
  149. if ($tkPrice > 0) {
  150. $refundList = RefundOrderClass::getAllByCondition(['relateOrderSn' => $orderSn], null, '*', null, true);
  151. if (!empty($refundList)) {
  152. foreach ($refundList as $refund) {
  153. if ($refund->refundType == 1) {
  154. //退货退款前面已经考虑,这里不再处理 OK
  155. } else {
  156. //$refund->refundPrice
  157. }
  158. }
  159. }
  160. }
  161. }
  162. }
  163. }
  164. echo $totalAmount . ' ' . $itemTotalAmount;
  165. die;
  166. }
  167. public function actionIp()
  168. {
  169. $ip = $_SERVER['SERVER_ADDR'] ?? '';
  170. echo $ip;
  171. }
  172. public function actionHtml()
  173. {
  174. $c = new Converter(null, [
  175. "fmt" => "png",
  176. "in" => "/tmp/a.html",
  177. "out" => "/tmp/test.png"
  178. ]);
  179. $c->convert();
  180. }
  181. //欠款的查询与跟踪 ssh 20240103
  182. public function actionDebt()
  183. {
  184. $customId = 17081;
  185. $custom = CustomClass::getById($customId, true);
  186. if (empty($custom)) {
  187. echo '没有找到客户';
  188. die;
  189. }
  190. $flag = [];
  191. $changeList = CustomDebtChangeClass::getAllByCondition(['customId' => $customId], null, '*');
  192. if (!empty($changeList)) {
  193. foreach ($changeList as $change) {
  194. $event = $change['evnet'] ?? '';
  195. $relateId = $change['relateId'] ?? 0;
  196. $amount = $change['amount'] ?? 0;
  197. if (strpos($event, '购买花材') >= 0) {
  198. $flag['40-' . $relateId] = $amount;
  199. }
  200. if (strpos($event, '退款') >= 0) {
  201. $flag['33-' . $relateId] = $amount;
  202. }
  203. if (strpos($event, '结账') >= 0) {
  204. $flag['20-' . $relateId] = $amount;
  205. }
  206. }
  207. }
  208. print_r($flag);
  209. $orderList = OrderClass::getAllByCondition(['customId' => $customId, 'debtPrice>' => 0], null, 'id,actPrice,payTime', null);
  210. $arr = [];
  211. if (!empty($orderList)) {
  212. foreach ($orderList as $order) {
  213. $payTime = $order['payTime'] ?? '';
  214. $id = $order['id'] ?? 0;
  215. $arr[$payTime] = $order;
  216. if (isset($flag['40-' . $id]) == false) {
  217. echo '40-' . $id . "订单有问题\n";
  218. }
  219. }
  220. }
  221. //20
  222. $clearList = PurchaseClearClass::getAllByCondition(['customId' => $customId, 'status' => 2], null, 'id,actPrice,payTime', null);
  223. if (!empty($clearList)) {
  224. foreach ($clearList as $clear) {
  225. $payTime = $clear['payTime'] ?? '';
  226. $id = $clear['id'] ?? 0;
  227. $arr[$payTime] = $clear;
  228. if (isset($flag['20-' . $id]) == false) {
  229. echo '20-' . $id . "结账有问题\n";
  230. }
  231. }
  232. }
  233. //33
  234. $refundList = RefundOrderClass::getAllByCondition(['customId' => $customId], null, 'id,refundPrice,updateTime', null);
  235. if (!empty($refundList)) {
  236. foreach ($refundList as $refund) {
  237. $id = $refund['id'] ?? 0;
  238. $updateTime = $refund['updateTime'] ?? '';
  239. $arr[$updateTime] = $refund;
  240. if (isset($flag['33-' . $id]) == false) {
  241. echo '33-' . $id . "退款单有问题\n";
  242. }
  243. }
  244. }
  245. echo "<pre>";
  246. ksort($arr);
  247. print_r($arr);
  248. die;
  249. }
  250. //退款操作 ssh 20231029
  251. public function actionRefund()
  252. {
  253. $shopId = 36524;
  254. $shop = ShopClass::getById($shopId, true);
  255. if (empty($shop)) {
  256. util::fail('没有找到门店');
  257. }
  258. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  259. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  260. $params = [
  261. 'appid' => 'OP00002119',
  262. 'serial_no' => '018b08cfddbd',
  263. 'merchant_no' => $shop->lklSjNo,
  264. 'term_no' => $shop->lklB2BTermNo,
  265. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  266. 'lklCertificatePath' => $lklCertificatePath,
  267. ];
  268. $laResource = new Lakala($params);
  269. $refundReason = '暂无';
  270. $refundOrderSn = orderSn::getCgRefundSn();
  271. $refundPrice = 0.01;
  272. $refundFee = bcmul($refundPrice, 100);
  273. $orderSn = 'KD_CS61235203';
  274. $originTradeNo = '20231030110113230266215266468756';
  275. //$originLogNo = '66215266025626';
  276. $aliParams = [
  277. 'refundSn' => $refundOrderSn,
  278. 'orderSn' => $orderSn,
  279. 'refundAmount' => $refundFee,
  280. 'refundReason' => $refundReason,
  281. 'originTradeNo' => $originTradeNo,
  282. //'originLogNo' => $originLogNo,
  283. ];
  284. $response = $laResource->refund($aliParams);
  285. echo '<pre>';
  286. print_r($response);
  287. }
  288. public function actionApply()
  289. {
  290. $id = 2888;
  291. $shopId = 36524;
  292. $cg = PurchaseClass::getById($id, true);
  293. $shop = ShopClass::getById($shopId, true);
  294. WxMessageClass::hdNewCgOrderInform($shop, $cg);
  295. }
  296. public function actionGet()
  297. {
  298. ini_set('memory_limit', '2045M');
  299. set_time_limit(0);
  300. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  301. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  302. $arr = [
  303. //['name' => '国兰花尚OK', 'merchantNo' => '82239305992006L', 'wx' => [600913569, 600907053], 'zfb' => '2088820709029782'],
  304. //['name' => '花掌柜OK', 'merchantNo' => '82240505992000P', 'wx' => [600466131, 600465187], 'zfb' => '2088820656569304'],
  305. //['name' => '纯彩花艺OK', 'merchantNo' => '82239305992006M', 'wx' => [600922790, 600915407], 'zfb' => '2088820710146836'],
  306. //['name' => '集美天天鲜花OK', 'merchantNo' => '82239305992006P', 'wx' => [601036538, 601036322], 'zfb' => '2088820726763339'],
  307. //['name' => '丰行花行OK', 'merchantNo' => '82260205992007P', 'wx' => [601053759, 601052157], 'zfb' => '2088820725885465'],
  308. //['name' => '独家花行OK', 'merchantNo' => '82239305992006Q', 'wx' => [601049483, 601048223], 'zfb' => '2088820725546555'],
  309. //['name' => '好多花海沧OK', 'merchantNo' => '82239305992006R', 'wx' => [601052177, 601053735], 'zfb' => '2088820725549695'],
  310. //['name' => '美天鲜花OK', 'merchantNo' => '82259505992003F', 'wx' => [601062064, 601138175], 'zfb' => '2088820729400990'],
  311. //['name' => '天天陈江店OK', 'merchantNo' => '82259505992003E', 'wx' => [601060616, 601059382], 'zfb' => '2088820725555368'],
  312. //['name' => '叶上花OK', 'merchantNo' => '82231805992002G', 'wx' => [601062892, 601062589], 'zfb' => '2088820728763546'],
  313. //['name' => '好又多(小明)OK', 'merchantNo' => '82239305992006S', 'wx' => [601135715, 601067347], 'zfb' => '2088820729698012'],
  314. //['name' => '我卖花OK', 'merchantNo' => '82227505992000R', 'wx' => [601177139, 601148755], 'zfb' => '2088820746424032'],
  315. //['name' => '问境OK', 'merchantNo' => '8226900599200KX', 'wx' => [601299388, 601299453], 'zfb' => '2088820787661843'],
  316. //['name' => '昱成OK', 'merchantNo' => '8226900599200KY', 'wx' => [601312993, 601325844], 'zfb' => '2088820788900240'],
  317. //['name' => '杭州斗南', 'merchantNo' => '杭州斗南', 'wx' => [601405963, 601405929], 'zfb' => '2088820793601705'],
  318. //['name' => '杭州斗南(没用)', 'merchantNo' => '8223310599200AD', 'wx' => [601254682, 601250805], 'zfb' => '2088820782666872'],
  319. //['name' => '珑松花卉长安店', 'merchantNo' => '82260205992007U', 'wx' => [602499045, 602497558], 'zfb' => '2088820959620797'],
  320. //['name' => '福州花福(个人)', 'merchantNo' => '82239105992007P', 'wx' => [603301197, 603302321], 'zfb' => '2088920058098261'],
  321. //['name' => '福州花福', 'merchantNo' => '82239105992007N', 'wx' => [602796807, 602774796], 'zfb' => '2088820996010582'],
  322. //['name' => '昆明新宏源', 'merchantNo' => '82239305992007H', 'wx' => [606098318, 606100317], 'zfb' => '2088920878302843'],
  323. //['name' => '昆明纯彩', 'merchantNo' => '82239905992003L', 'wx' => [604923629, 604922175], 'zfb' => '2088920533160795'],
  324. //['name' => '花优田(军兴旺)', 'merchantNo' => '8227310599200GX', 'wx' => [605191281, 605190492], 'zfb' => '2088920588715249'],
  325. //['name' => '肇庆兄弟鲜花', 'merchantNo' => '82259305992001V', 'wx' => [628299301, 628297384], 'zfb' => '2088930936937722'],
  326. //['name' => '郑州唯一鲜花', 'merchantNo' => '8224910599200NB', 'wx' => [624877731, 624877902], 'zfb' => '2088830970964611'],
  327. //['name' => '昆明期待鲜花', 'merchantNo' => '8227310599200J6', 'wx' => [615582300, 615582180], 'zfb' => '2088530113958388'],
  328. //['name' => '厦门遇见你', 'merchantNo' => '82239305992008D', 'wx' => [614782373, 614783346], 'zfb' => '2088430828233036'],
  329. //['name' => '淄博花超鲜花批发', 'merchantNo' => '82245305992001R', 'wx' => [614685779, 614682986], 'zfb' => '2088430805221810'],
  330. //['name' => '广州国恋', 'merchantNo' => '8225810599200Q7', 'wx' => [612321716, 612320978], 'zfb' => '2088330479975012'],
  331. //['name' => '欣研鲜花', 'merchantNo' => '82260305992001Y', 'wx' => [612181234, 612181615], 'zfb' => '2088330365608286'],
  332. //['name' => '村长冷链', 'merchantNo' => '82260205992008G', 'wx' => [612168406, 612168000], 'zfb' => '2088330360870932'],
  333. //['name' => '惠州惠雅鲜花批发', 'merchantNo' => '82259505992003S', 'wx' => [611676975, 611677314], 'zfb' => '2088330136601427'],
  334. //['name' => '杭州斗南鲜花', 'merchantNo' => '8223310599200AR', 'wx' => [608955814, 608955082], 'zfb' => '2088130449323603'],
  335. //['name' => '营口简约花卉', 'merchantNo' => '8227310599200HJ', 'wx' => [608439898, 608440994], 'zfb' => '2088130112725929'],
  336. //['name' => '惠雅鲜花惠州店', 'merchantNo' => '82260205992007Z', 'wx' => [608406948, 608403207], 'zfb' => '2088130098167302'],
  337. //['name' => '云南珑松花卉珠海店', 'merchantNo' => '82258505992002U', 'wx' => [608062727, 608056474], 'zfb' => '2088030873238576'],
  338. //['name' => '昆明鹏诚花卉', 'merchantNo' => '8227310599200JK', 'wx' => [630710385, 630711403], 'zfb' => '2088040532857091'],
  339. //['name' => '云南昆明鲜花导航', 'merchantNo' => '8227310599200K7', 'wx' => [644628542, 644625621], 'zfb' => '2088440522565852'],
  340. //['name' => '兄弟花业', 'merchantNo' => '82260205992009C', 'wx' => [644547729, 644547591], 'zfb' => '2088440499878526'],
  341. //['name' => '花小苪', 'merchantNo' => '8227310599200K5', 'wx' => [644457809, 644457051], 'zfb' => '2088440462746403'],
  342. //['name' => '昆明君花阁', 'merchantNo' => '82239905992004Z', 'wx' => [644889761, 644889492], 'zfb' => '2088440579676361'],
  343. //['name' => '天雨花卉', 'merchantNo' => '82270705992000V', 'wx' => [644883152, 644883508], 'zfb' => '2088440575173671'],
  344. //['name' => '惠雅物流广州线', 'merchantNo' => '82259505992004N', 'wx' => [646083092, 646078226], 'zfb' => '2088440854131130'],
  345. //['name' => '小向花卉', 'merchantNo' => '8227310599200K8', 'wx' => [644771350, 644769766], 'zfb' => '2088440549798194'],
  346. //['name' => '小蔡鲜花批发', 'merchantNo' => '8223050599200BF', 'wx' => [644014296, 643948823], 'zfb' => '2088440255505707'],
  347. //['name' => '花千禧鲜花批发', 'merchantNo' => '8224510599200B2', 'wx' => [651543674, 651544159], 'zfb' => '2088640601421088'],
  348. //['name' => '九江云朵鲜花', 'merchantNo' => '82242405992001G', 'wx' => [653862657, 653862178], 'zfb' => '2088740712634499'],
  349. //['name' => '阿魏鲜花批发', 'merchantNo' => '82237405992001D', 'wx' => [655133268, 655133420], 'zfb' => '2088840200937795'],
  350. //['name' => '木合生花卉', 'merchantNo' => '8227310599200KP', 'wx' => [656152589, 656153824], 'zfb' => '2088840636484902'],
  351. //['name' => '珑松花卉广州店', 'merchantNo' => '8225810599200T4', 'wx' => [656366815, 656367359], 'zfb' => '2088840687638415'],
  352. //['name' => '珑松花卉老香洲店', 'merchantNo' => '82258505992003E', 'wx' => [658185273, 658185986], 'zfb' => '2088940386892391'],
  353. //['name' => '花瀚鲜花供应链', 'merchantNo' => '8227310539905FA', 'wx' => [662010955, 662011741], 'zfb' => '2088150197406980'],
  354. //['name' => '惠州润涵冷链', 'merchantNo' => '8225950539903PR', 'wx' => [662169374, 662170009], 'zfb' => '2088150247119691'],
  355. //['name' => '晋江大自然', 'merchantNo' => '82239705399059B', 'wx' => [667550571, 667550712], 'zfb' => '2088350427115891'],
  356. //['name' => '漳州世纪花都', 'merchantNo' => '82239905399029K', 'wx' => [667664263, 667664414], 'zfb' => '2088350452589810'],
  357. //['name' => '勇记花卉', 'merchantNo' => '822581053990C8L', 'wx' => [669207179, 669206707], 'zfb' => '2088450081165255'],
  358. ['name' => '昆明云花卉', 'merchantNo' => '8227310539905MX', 'wx' => [669707865, 669707085], 'zfb' => '2088450254255811'],
  359. //['name' => '昆明徐记花卉', 'merchantNo' => '8227310539905G1', 'wx' => [663329224, 663329205], 'zfb' => '2088150735316911'],
  360. //['name' => '昆明云中花花卉', 'merchantNo' => '8227310539905JB', 'wx' => [665786989, 665787567], 'zfb' => '2088250764618395'],
  361. //['name' => '石狮花好鲜', 'merchantNo' => '82239705399058M', 'wx' => [667184997, 667185665], 'zfb' => '2088350227756195'],
  362. //['name' => '遵义镜中花卉', 'merchantNo' => '82270305399014K', 'wx' => [663285723, 663285152], 'zfb' => '2088150699238043'],
  363. //['name' => '悠悠鲜花直营', 'merchantNo' => '82246605399018S', 'wx' => [662942118, 662941578], 'zfb' => '2088150532490953'],
  364. //['name' => '扬州花儿很仙', 'merchantNo' => '82231205992001R', 'wx' => [641935836, 641934793], 'zfb' => '2088340698052621'],
  365. //['name' => '福清花好鲜', 'merchantNo' => '82239105992008S', 'wx' => [639783869, 639783652], 'zfb' => '2088340156624896'],
  366. //['name' => '北京花篮子', 'merchantNo' => '8221000599200QM', 'wx' => [639324663, 639322821], 'zfb' => '2088240926611870'],
  367. //['name' => '云南云漫梦金鹏', 'merchantNo' => '8227310599200K0', 'wx' => [638438213, 638437418], 'zfb' => '2088240671151089'],
  368. //['name' => '心悦花艺馆', 'merchantNo' => '82247305992002L', 'wx' => [632850138, 632849309], 'zfb' => '2088140048248384'],
  369. //['name' => '买手很忙', 'merchantNo' => '8227310599200GJ', 'wx' => [601597167, 601595526], 'zfb' => '2088820818930267'],
  370. //['name' => '七彩花都', 'merchantNo' => '8227310599200GF', 'wx' => [601176481, 601148503], 'zfb' => '2088820748594478'],
  371. //['name' => '十年', 'merchantNo' => '82252305992001U', 'wx' => [601285154, 601261795], 'zfb' => '2088820782171763'],
  372. //['name' => '都市花季OK', 'merchantNo' => '82239305992006U', 'wx' => [601174342, 601147649], 'zfb' => '2088820748507346'],
  373. //['name' => '花样年华OK', 'merchantNo' => '82260205992007Q', 'wx' => [601134352, 601091710], 'zfb' => '2088820735043444'],
  374. //['name' => '精茂城OK', 'merchantNo' => '8225840599200TF', 'wx' => [601173752, 601143352], 'zfb' => '2088820746800005'],
  375. //['name' => '莱漫OK', 'merchantNo' => '82239305992007A', 'wx' => [601288494, 601288166], 'zfb' => '2088820783686611'],
  376. //['name' => '莱漫(没用)', 'merchantNo' => '82239305992006T', 'wx' => [601134065, 601125595], 'zfb' => '2088820743859918'],
  377. //['name' => '福州我要花OK', 'merchantNo' => '82239105992007J', 'wx' => [601134030, 601128111], 'zfb' => '2088820745276973'],
  378. //['name' => '泉城OK', 'merchantNo' => '82239705992004F', 'wx' => [601273270, 601272854], 'zfb' => '2088820784658561'],
  379. //['name' => '泉城(没用)', 'merchantNo' => '82239705992004E', 'wx' => [601133056, 601133821], 'zfb' => '2088820746111323'],
  380. //['name' => '美丽花行OK', 'merchantNo' => '82239305992006V', 'wx' => [601155249, 601149712], 'zfb' => '2088820747673312'],
  381. //['name' => '三叶OK', 'merchantNo' => '82236805992001Y', 'wx' => [601152233, 601151024], 'zfb' => '2088820747556725'],
  382. //['name' => '花大苪OK', 'merchantNo' => '8227310599200GG', 'wx' => [601174221, 601165136], 'zfb' => '2088820751181377'],
  383. //['name' => '十堰天天鲜花OK', 'merchantNo' => '82252305992001S', 'wx' => [601171131, 601170642], 'zfb' => '2088820750844626'],
  384. //['name' => '珑松花卉OK', 'merchantNo' => '82260205992007S', 'wx' => [601176093, 601174262], 'zfb' => '2088820754742492'],
  385. //['name' => '惠雅鲜花OK', 'merchantNo' => '82260205992007R', 'wx' => [601173390, 601174002], 'zfb' => '2088820753174540'],
  386. //['name' => '锦绣花卉OK', 'merchantNo' => '82252305992001T', 'wx' => [601176719, 601176660], 'zfb' => '2088820754751663'],
  387. //['name' => '祥瑞鲜花同安店OK', 'merchantNo' => '82239305992006W', 'wx' => [601178350, 601177795], 'zfb' => '2088820755715024'],
  388. //['name' => '祥瑞鲜花翔安店OK', 'merchantNo' => '82239305992006X', 'wx' => [601178260, 601178199], 'zfb' => '2088820754481553'],
  389. //['name' => '初见花季OK', 'merchantNo' => '82239305992006Y', 'wx' => [601178998, 601179605], 'zfb' => '2088820757223312'],
  390. //['name' => '荣发鲜花OK', 'merchantNo' => '82242705992000D', 'wx' => [601179681, 601179180], 'zfb' => '2088820756926593'],
  391. //['name' => '花千朵(多多)OK', 'merchantNo' => '82239305992006Z', 'wx' => [601223474, 601208096], 'zfb' => '2088820766783276'],
  392. //['name' => '花悠星OK', 'merchantNo' => '8225810599200NH', 'wx' => [601228194, 601227691], 'zfb' => '2088820774587446'],
  393. //['name' => '花悠星(没用)', 'merchantNo' => '8225810599200NG', 'wx' => [601223630, 601210952], 'zfb' => '2088820767072874'],
  394. //['name' => '源花汇OK', 'merchantNo' => '82222105992004A', 'wx' => [601221944, 601214269], 'zfb' => '2088820770594246'],
  395. //['name' => '源花汇2(没用)', 'merchantNo' => '8227310599200GD', 'wx' => [601136305, 601067016], 'zfb' => '2088820729832744'],
  396. ];
  397. $new = [];
  398. foreach ($arr as $item) {
  399. $wx = $item['wx'];
  400. $zfb = $item['zfb'];
  401. $merchantNo = $item['merchantNo'];
  402. $name = $item['name'] . ' ' . $merchantNo;
  403. $group = [];
  404. foreach ($wx as $oneWx) {
  405. $params = [
  406. 'appid' => 'OP00002119',
  407. 'serial_no' => '018b08cfddbd',
  408. 'merchant_no' => $merchantNo,
  409. 'term_no' => 'C6337694',
  410. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  411. 'lklCertificatePath' => $lklCertificatePath,
  412. ];
  413. $data = [
  414. 'subMerchantId' => $oneWx,
  415. 'tradeMode' => 'WECHAT',
  416. ];
  417. $laResource = new Lakala($params);
  418. $response = $laResource->openStateQuery($data);
  419. $statusName = '出错了';
  420. if ($response['retCode'] == '000000') {
  421. $checkResult = $response['respData']['checkResult'] ?? '';
  422. $statusName = '未认证';
  423. if ($checkResult == 'AUTHORIZE_STATE_AUTHORIZED') {
  424. $statusName = '已认证';
  425. }
  426. }
  427. $group[] = '微信 ' . $oneWx . ' ' . $statusName;
  428. }
  429. $params = [
  430. 'appid' => 'OP00002119',
  431. 'serial_no' => '018b08cfddbd',
  432. 'merchant_no' => $merchantNo,
  433. 'term_no' => 'C6337694',
  434. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  435. 'lklCertificatePath' => $lklCertificatePath,
  436. ];
  437. $data = [
  438. 'subMerchantId' => $zfb,
  439. 'tradeMode' => 'ALIPAY',
  440. ];
  441. $laResource = new Lakala($params);
  442. $response = $laResource->openStateQuery($data);
  443. $statusName = '出错了';
  444. if ($response['retCode'] == '000000') {
  445. $checkResult = $response['respData']['checkResult'] ?? '';
  446. $statusName = '未认证';
  447. if ($checkResult == 'AUTHORIZED') {
  448. $statusName = '已认证';
  449. }
  450. }
  451. $group[] = '支付宝 ' . $zfb . ' ' . $statusName;
  452. $new[] = ['name' => $name, 'status' => $group];
  453. }
  454. if (!empty($new)) {
  455. foreach ($new as $info) {
  456. echo "<table style='font-size:40px;margin-bottom:10px;border-top: 2px solid black;padding-top:12px;padding-bottom: 12px;'>";
  457. echo "<tr><td>{$info['name']}</td></tr>";
  458. if (!empty($info['status'])) {
  459. foreach ($info['status'] as $item) {
  460. echo "<tr><td>{$item}</td></tr>";
  461. }
  462. }
  463. echo "</table>";
  464. }
  465. }
  466. }
  467. public function actionRefundQuery()
  468. {
  469. $shopId = 520;
  470. $shop = ShopClass::getById($shopId, true);
  471. if (empty($shop)) {
  472. util::stop('没有找到门店');
  473. }
  474. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  475. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  476. $params = [
  477. 'appid' => 'OP00002119',
  478. 'serial_no' => '018b08cfddbd',
  479. 'merchant_no' => $shop->lklSjNo,
  480. 'term_no' => $shop->lklScanTermNo,
  481. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  482. 'lklCertificatePath' => $lklCertificatePath,
  483. ];
  484. $laResource = new Lakala($params);
  485. $orderSn = '20231201110113131266165492618754';
  486. $data = [
  487. 'orderSn' => $orderSn,
  488. ];
  489. $response = $laResource->refundQuery($data);
  490. echo "<pre>";
  491. print_r($response);
  492. }
  493. public function actionBalanceQuery()
  494. {
  495. $shopId = 1212;
  496. $shop = ShopClass::getById($shopId, true);
  497. if (empty($shop)) {
  498. util::stop('没有找到门店');
  499. }
  500. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  501. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  502. $params = [
  503. 'appid' => 'OP00002119',
  504. 'serial_no' => '018b08cfddbd',
  505. 'merchant_no' => $shop->lklSjNo,
  506. 'term_no' => $shop->lklScanTermNo,
  507. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  508. 'lklCertificatePath' => $lklCertificatePath,
  509. ];
  510. $laResource = new Lakala($params);
  511. $response = $laResource->accountBalanceQuery();
  512. echo "<pre>";
  513. print_r($response);
  514. }
  515. //测试环境查线上数据 ssh 20231230
  516. public function actionCsQuery()
  517. {
  518. // $shopId = 1527;
  519. // $shop = ShopClass::getById($shopId, true);
  520. // if (empty($shop)) {
  521. // util::stop('没有找到门店');
  522. // }
  523. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  524. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  525. $params = [
  526. 'appid' => 'OP00002119',
  527. 'serial_no' => '018b08cfddbd',
  528. //'merchant_no' => $shop->lklSjNo,
  529. 'merchant_no' => '82222105992004A',
  530. //'term_no' => $shop->lklScanTermNo,
  531. 'term_no' => 'H3656802',
  532. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  533. 'lklCertificatePath' => $lklCertificatePath,
  534. ];
  535. $laResource = new Lakala($params);
  536. $queryParams = [
  537. //'orderSn' => 'KD26452235',
  538. 'tradeNo' => '20231230110113130266215700775011',
  539. ];
  540. $response = $laResource->query($queryParams, 1);
  541. echo "<pre>";
  542. print_r($response);
  543. }
  544. public function actionQuery()
  545. {
  546. $shopId = 726;
  547. $shop = ShopClass::getById($shopId, true);
  548. if (empty($shop)) {
  549. util::stop('没有找到门店');
  550. }
  551. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  552. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  553. $params = [
  554. 'appid' => 'OP00002119',
  555. 'serial_no' => '018b08cfddbd',
  556. 'merchant_no' => $shop->lklSjNo,
  557. 'term_no' => $shop->lklScanTermNo,
  558. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  559. 'lklCertificatePath' => $lklCertificatePath,
  560. ];
  561. $laResource = new Lakala($params);
  562. $queryParams = [
  563. 'orderSn' => 'KD26481486',
  564. //'tradeNo' => '20231230110113130266215700775011',
  565. ];
  566. $response = $laResource->query($queryParams, 0);
  567. echo "<pre>";
  568. print_r($response);
  569. }
  570. public function actionClearQuery()
  571. {
  572. $shopId = 7687;
  573. $shop = ShopClass::getById($shopId, true);
  574. if (empty($shop)) {
  575. util::stop('没有找到门店');
  576. }
  577. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  578. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  579. $params = [
  580. 'appid' => 'OP00002119',
  581. 'serial_no' => '018b08cfddbd',
  582. 'merchant_no' => $shop->lklSjNo,
  583. 'term_no' => $shop->lklScanTermNo,
  584. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  585. 'lklCertificatePath' => $lklCertificatePath,
  586. ];
  587. $laResource = new Lakala($params);
  588. $queryParams = [
  589. 'orderSn' => 'CL28765384',
  590. //'tradeNo' => '66215417437878',
  591. ];
  592. $response = $laResource->query($queryParams, 1);
  593. echo "<pre>";
  594. print_r($response);
  595. }
  596. //零售订单查询 ssh 20231031
  597. public function actionLsTradeQuery()
  598. {
  599. $shopId = 3969;
  600. $shop = ShopClass::getById($shopId, true);
  601. if (empty($shop)) {
  602. util::stop('没有找到门店');
  603. }
  604. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  605. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  606. $params = [
  607. 'appid' => 'OP00002119',
  608. 'serial_no' => '018b08cfddbd',
  609. 'merchant_no' => $shop->lklSjNo,
  610. 'term_no' => $shop->lklScanTermNo,
  611. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  612. 'lklCertificatePath' => $lklCertificatePath,
  613. ];
  614. $laResource = new Lakala($params);
  615. $queryParams = [
  616. 'orderSn' => 'KD26499746',
  617. //'tradeNo' => '20231029110113130266215259252887',
  618. ];
  619. $response = $laResource->query($queryParams, 0);
  620. print_r($response);
  621. util::stop();
  622. if (isset($response['code']) && $response['code'] == 'BBS00000') {
  623. $connection = Yii::$app->db;
  624. $transaction = $connection->beginTransaction();
  625. try {
  626. $postData = $response['resp_data'] ?? [];
  627. $orderSn = $postData['out_trade_no'] ?? '';
  628. $total_amount = $postData['total_amount'] ?? 0;
  629. $account_type = $postData['account_type'] ?? '';
  630. if (empty($account_type)) {
  631. noticeUtil::push('支付回调失败了,没有找到钱包类型,请注意,orderSn:' . $orderSn, '15280215347');
  632. util::end();
  633. }
  634. $totalFee = $total_amount / 100;
  635. $transactionId = $postData['trade_no'] ?? 0;
  636. $capitalType = dict::getDict('capitalType', 'xhOrder', 'id');
  637. $currentPayWay = null;
  638. if ($account_type == 'WECHAT') {
  639. $currentPayWay = dict::getDict('payWay', 'wxPay');
  640. } elseif ($account_type == 'ALIPAY') {
  641. $currentPayWay = dict::getDict('payWay', 'alipay');
  642. } else {
  643. noticeUtil::push('支付回调失败了,没有找到支付类型,orderSn:' . $orderSn, '15280215347');
  644. util::end();
  645. }
  646. $attach = '';
  647. payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
  648. $transaction->commit();
  649. echo 'OK';
  650. } catch (\Exception $e) {
  651. $transaction->rollBack();
  652. Yii::error("失败原因:" . $e->getMessage());
  653. }
  654. }
  655. }
  656. //零售订单查询 ssh 20231031
  657. public function actionClear()
  658. {
  659. $shopId = 10649;
  660. $shop = ShopClass::getById($shopId, true);
  661. if (empty($shop)) {
  662. util::stop('没有找到门店');
  663. }
  664. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  665. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  666. $params = [
  667. 'appid' => 'OP00002119',
  668. 'serial_no' => '018b08cfddbd',
  669. 'merchant_no' => $shop->lklSjNo,
  670. 'term_no' => $shop->lklScanTermNo,
  671. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  672. 'lklCertificatePath' => $lklCertificatePath,
  673. ];
  674. $laResource = new Lakala($params);
  675. $queryParams = [
  676. //'orderSn' => 'KD26461864',
  677. 'tradeNo' => '20231230110113130266215700775011',
  678. ];
  679. $response = $laResource->query($queryParams, 1);
  680. print_r($response);
  681. util::stop();
  682. if (isset($response['code']) && $response['code'] == 'BBS00000') {
  683. $connection = Yii::$app->db;
  684. $transaction = $connection->beginTransaction();
  685. try {
  686. $postData = $response['resp_data'] ?? [];
  687. $orderSn = $postData['out_trade_no'] ?? '';
  688. $total_amount = $postData['total_amount'] ?? 0;
  689. $account_type = $postData['account_type'] ?? '';
  690. if (empty($account_type)) {
  691. noticeUtil::push('支付回调失败了,没有找到钱包类型,请注意,orderSn:' . $orderSn, '15280215347');
  692. util::end();
  693. }
  694. $totalFee = $total_amount / 100;
  695. $transactionId = $postData['trade_no'] ?? 0;
  696. $capitalType = dict::getDict('capitalType', 'hdPurchaseClear', 'id');
  697. $currentPayWay = null;
  698. if ($account_type == 'WECHAT') {
  699. $currentPayWay = dict::getDict('payWay', 'wxPay');
  700. } elseif ($account_type == 'ALIPAY') {
  701. $currentPayWay = dict::getDict('payWay', 'alipay');
  702. } else {
  703. noticeUtil::push('支付回调失败了,没有找到支付类型,orderSn:' . $orderSn, '15280215347');
  704. util::end();
  705. }
  706. $attach = '';
  707. payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
  708. $transaction->commit();
  709. echo 'OK';
  710. } catch (\Exception $e) {
  711. $transaction->rollBack();
  712. Yii::error("失败原因:" . $e->getMessage());
  713. }
  714. }
  715. }
  716. //交易查询 ssh 20231021
  717. public function actionTradeQuery()
  718. {
  719. $shopId = 7855;
  720. $shop = ShopClass::getById($shopId, true);
  721. if (empty($shop)) {
  722. util::stop('没有找到门店');
  723. }
  724. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  725. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  726. $params = [
  727. 'appid' => 'OP00002119',
  728. 'serial_no' => '018b08cfddbd',
  729. 'merchant_no' => $shop->lklSjNo,
  730. 'term_no' => $shop->lklScanTermNo,
  731. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  732. 'lklCertificatePath' => $lklCertificatePath,
  733. ];
  734. $laResource = new Lakala($params);
  735. $queryParams = [
  736. 'orderSn' => 'CG27325720',
  737. //'tradeNo' => '66215960152739',
  738. ];
  739. $response = $laResource->query($queryParams, 0);
  740. print_r($response);
  741. util::stop();
  742. if (isset($response['code']) && $response['code'] == 'BBS00000') {
  743. $capitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
  744. $connection = Yii::$app->db;
  745. $transaction = $connection->beginTransaction();
  746. try {
  747. $account_type = $response['resp_data']['account_type'] ?? 0;
  748. if (empty($account_type)) {
  749. noticeUtil::push('支付回调失败了,没有找到钱包类型,请注意', '15280215347');
  750. util::end();
  751. }
  752. $currentPayWay = null;
  753. if ($account_type == 'WECHAT') {
  754. $currentPayWay = dict::getDict('payWay', 'wxPay');
  755. } elseif ($account_type == 'ALIPAY') {
  756. $currentPayWay = dict::getDict('payWay', 'alipay');
  757. } else {
  758. noticeUtil::push('支付回调失败了,没有找到支付类型', '15280215347');
  759. util::end();
  760. }
  761. $attach = '';
  762. $total_amount = $response['resp_data']['total_amount'] ?? 0;
  763. $orderSn = $response['resp_data']['out_trade_no'] ?? 0;
  764. $totalFee = $total_amount / 100;
  765. $transactionId = $response['resp_data']['trade_no'] ?? 0;
  766. payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
  767. $transaction->commit();
  768. echo 'OK';
  769. } catch (\Exception $e) {
  770. $transaction->rollBack();
  771. Yii::error("失败原因:" . $e->getMessage());
  772. }
  773. }
  774. }
  775. public function actionAliRun2()
  776. {
  777. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  778. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  779. $params = [
  780. 'appid' => 'OP00002119',
  781. 'serial_no' => '018b08cfddbd',
  782. 'merchant_no' => '82240505992000N',
  783. 'term_no' => 'C6337694',
  784. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  785. 'lklCertificatePath' => $lklCertificatePath,
  786. ];
  787. $outTradeNo = orderSn::getPurchaseSn();
  788. $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback";
  789. $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
  790. $aliParams = [
  791. 'orderSn' => $outTradeNo,
  792. 'amount' => 0.16,
  793. 'capitalType' => $currentCapitalType,
  794. 'notifyUrl' => $notifyUrl,
  795. ];
  796. $laResource = new Lakala($params);
  797. $response = $laResource->driveAliPay($aliParams);
  798. if ($response && isset($response['cmdRetCode']) && $response['cmdRetCode'] == 'GLOBAL_SUCCESS') {
  799. echo '<pre>';
  800. echo "下单成功<br/>";
  801. print_r($response);
  802. } else {
  803. echo '<pre>';
  804. echo "下单失败<br/>";
  805. print_r($response);
  806. }
  807. }
  808. public function actionAliRun3()
  809. {
  810. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  811. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  812. $params = [
  813. 'appid' => 'OP00002119',
  814. 'serial_no' => '018b08cfddbd',
  815. 'merchant_no' => '82240505992000N',
  816. 'term_no' => 'C6337694',
  817. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  818. 'lklCertificatePath' => $lklCertificatePath,
  819. ];
  820. $laResource = new Lakala($params);
  821. $outTradeNo = orderSn::getPurchaseSn();
  822. $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback";
  823. $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
  824. $wxParams = [
  825. 'orderSn' => $outTradeNo,
  826. 'amount' => 0.16,
  827. 'capitalType' => $currentCapitalType,
  828. 'notifyUrl' => $notifyUrl,
  829. ];
  830. $response = $laResource->driveWxPay($wxParams);
  831. if ($response && isset($response['cmdRetCode']) && $response['cmdRetCode'] == 'GLOBAL_SUCCESS') {
  832. echo '<pre>';
  833. echo "下单成功<br/>";
  834. print_r($response);
  835. } else {
  836. echo '<pre>';
  837. echo "下单失败<br/>";
  838. print_r($response);
  839. }
  840. }
  841. //dada 城市code
  842. public function actionDadaCityCode()
  843. {
  844. $res = dada::getCityCode(0);
  845. util::success($res);
  846. }
  847. //理由
  848. public function actionDadaReasons()
  849. {
  850. $res = dada::getCancelReason(0);
  851. util::success($res);
  852. }
  853. //达达 :下单
  854. public function actionDadaAddOrder()
  855. {
  856. $orderSn = 'XSD_CS26316851';
  857. $orderInfo = OrderClass::getByOrderSn($orderSn);
  858. $res = DadaExpressServices::addOrder($orderInfo);
  859. util::success($res);
  860. }
  861. //重发快递
  862. public function actionDadaReAdd()
  863. {
  864. $orderSn = 'XSD_CS26316851';
  865. $orderInfo = OrderClass::getByOrderSn($orderSn);
  866. $res = DadaExpressServices::reAddOrder($orderInfo);
  867. util::success($res);
  868. }
  869. //达达状态查询
  870. public function actionDadaOrderStatus()
  871. {
  872. $orderSn = 'XSD_CS26316851';
  873. $res = DadaExpressServices::statusOrder($orderSn);
  874. util::success($res);
  875. }
  876. //达达取消下单
  877. public function actionDadaCancelOrder()
  878. {
  879. $orderSn = 'XSD_CS26316851';
  880. $res = DadaExpressServices::cancelOrder($orderSn, 1);
  881. util::success($res);
  882. }
  883. //获取已支持的配送公司列表接口
  884. public function actionGetAllDelivery()
  885. {
  886. $data = MiniExpressService::getAllImmeDelivery();
  887. util::success($data);
  888. }
  889. //即时配送
  890. /*
  891. * Array
  892. (
  893. [resultcode] => 0
  894. [resultmsg] => OK
  895. [shop_list] => Array
  896. (
  897. [0] => Array
  898. (
  899. [shopid] => 1588714266
  900. [delivery_id] => SFTC
  901. [audit_result] => 0
  902. [create_time] => 1612172838
  903. [remark] =>
  904. [delivery_name] => 顺丰同城急送
  905. )
  906. )
  907. )
  908. */
  909. public function actionGetBindAccount()
  910. {
  911. $merchant = WxOpenClass::getGhsWxInfo();
  912. $isOpen = 2;
  913. $r = miniUtil::getBindAccount($merchant, $isOpen);
  914. dd($r);
  915. }
  916. //下单 (沙箱)
  917. /**
  918. * Array
  919. * (
  920. * [resultcode] => 0
  921. * [resultmsg] => ok
  922. * [fee] => 10
  923. * [waybill_id] => test_shop_id1612365974_waybillid
  924. * [order_status] => 101
  925. * [dispatch_duration] => 300
  926. * )
  927. */
  928. public function actionCreateWaybill()
  929. {
  930. $merchant = WxOpenClass::getGhsWxInfo();
  931. $isOpen = 2;
  932. $shopId = 'test_shop_id';
  933. $shopOrderId = 'test_shop_id' . time();
  934. $appSecret = 'test_app_secrect';
  935. $data = [
  936. 'shopid' => $shopId,
  937. 'shop_order_id' => $shopOrderId,
  938. 'shop_no' => '1',
  939. 'delivery_sign' => miniUtil::getDeliverySign($shopId, $shopOrderId, $appSecret), //,则delivery_sign=SHA1(shopid + shop_order_id + AppSecret)
  940. 'delivery_id' => "TEST",
  941. 'openid' => 'oGKMp45YLxewOTWEbpMFzWoVqdW0',
  942. 'sender' => [
  943. 'name' => 'test',
  944. 'city' => '厦门市',
  945. 'address' => '思明区',
  946. 'address_detail' => '软件园二期',
  947. 'phone' => '19959271111',
  948. 'lng' => 118.134343,
  949. 'lat' => 24.483566,
  950. 'coordinate_type' => 0,
  951. ],
  952. 'receiver' => [
  953. 'name' => 'test',
  954. 'city' => '厦门市',
  955. 'address' => '思明区',
  956. 'address_detail' => '软件园二期',
  957. 'phone' => '19959271111',
  958. 'lng' => 118.134343,
  959. 'lat' => 24.493566,
  960. 'coordinate_type' => 0,
  961. ],
  962. 'cargo' => [
  963. 'goods_value' => 1,
  964. 'goods_weight' => 0.1,
  965. 'cargo_first_class' => '鲜花',
  966. 'cargo_second_class' => '鲜花',
  967. ],
  968. 'order_info' => [
  969. 'order_type' => 0,
  970. ],
  971. 'shop' => [
  972. 'wxa_path' => '/shop',
  973. 'img_url' => 'http://www.baidu.com/test.png',
  974. 'goods_name' => 'test',
  975. 'goods_count' => 1,
  976. ],
  977. ];
  978. $r = miniUtil::addOrder($data, $merchant, $isOpen);
  979. dd($r);
  980. }
  981. //获取运单数据
  982. /**
  983. * Array
  984. * (
  985. * [resultcode] => 0
  986. * [resultmsg] => ok
  987. * [order_status] => 101
  988. * [agent_info] => Array
  989. * (
  990. * )
  991. *
  992. * [waybill_id] => test_shop_id1612365974_waybillid
  993. * [rider_name] =>
  994. * [rider_phone] =>
  995. * [order_token] => NsXweKCKhSyAEIhAdnX3TYZsVDES0-t-tymHDONG0MpRsF31dQvVxiP_JJvLFaKS-kwXuOG3D0hzKkl7o-gzew
  996. * )
  997. */
  998. public function actionGetOrder()
  999. {
  1000. $shopId = 'test_shop_id';
  1001. $shopOrderId = 'test_shop_id1612365974';
  1002. $appSecret = 'test_app_secrect';
  1003. $merchant = WxOpenClass::getGhsWxInfo();
  1004. $isOpen = 2;
  1005. $data = [
  1006. 'shopid' => $shopId,
  1007. 'shop_order_id' => $shopOrderId,
  1008. 'shop_no' => '1',
  1009. 'delivery_sign' => MiniExpressService::getDeliverySign($shopId, $shopOrderId, $appSecret),
  1010. ];
  1011. $r = miniUtil::getOrder($data, $merchant, $isOpen);
  1012. dd($r);
  1013. }
  1014. //沙盒 更新快递状态
  1015. public function actionMockUpdateOrder()
  1016. {
  1017. $merchant = WxOpenClass::getGhsWxInfo();
  1018. $isOpen = 2;
  1019. /**
  1020. * {
  1021. * "shopid": "test_shop_id",
  1022. * "shop_order_id": "xxxxxxxxxxx",
  1023. * "waybill_id": "xxxxxxxxxxxxx",
  1024. * "action_time": 12345678,
  1025. * "order_status": 101,
  1026. * "action_msg": "",
  1027. * }
  1028. */
  1029. $shopId = 'test_shop_id';
  1030. $shopOrderId = 'test_shop_id1612365974';
  1031. $data = [
  1032. 'shop_order_id' => $shopOrderId,
  1033. "shopid" => $shopId,
  1034. "action_time" => time(),
  1035. "order_status" => 302,
  1036. 'action_msg' => '状态变更',
  1037. ];
  1038. $r = miniUtil::mockUpdateOrder($data, $merchant, $isOpen);
  1039. dd($r);
  1040. }
  1041. public function actionTest()
  1042. {
  1043. }
  1044. //新增订单
  1045. public function actionAddOrder()
  1046. {
  1047. $dada = Yii::getAlias("@vendor/dada/");
  1048. require_once $dada . 'api/addOrderApi.php';
  1049. require_once $dada . 'client/dadaRequestClient.php';
  1050. require_once $dada . 'client/dadaResponse.php';
  1051. require_once $dada . 'config/config.php';
  1052. require_once $dada . 'model/orderModel.php';
  1053. // isOnline 判断是否是测试环境,会有不同的域名等
  1054. $isOnline = false;
  1055. $sourceId = 1000000;
  1056. // 初始化一个config
  1057. $config = new \Config($sourceId, $isOnline);
  1058. $orderModel = new \OrderModel();
  1059. $orderModel->setShopNo('11047059');
  1060. $orderModel->setOriginId('2018091100000002');
  1061. $orderModel->setCityCode('021');
  1062. $orderModel->setCargoPrice(10);
  1063. $orderModel->setIsPrepay(0);
  1064. $orderModel->setReceiverName('测试达达');
  1065. $orderModel->setReceiverAddress('上海市崇明岛');
  1066. $orderModel->setReceiverLat(31.63);
  1067. $orderModel->setReceiverLng(121.41);
  1068. $orderModel->setReceiverPhone('18588888888');
  1069. $orderModel->setCallback('http://api.b.huaml.com/data/request');
  1070. // api主要有2个参数,一个是url, 一个是业务参数
  1071. $addOrderApi = new \AddOrderApi(json_encode($orderModel));
  1072. $dada_client = new \DadaRequestClient($config, $addOrderApi);
  1073. $resp = $dada_client->makeRequest();
  1074. echo json_encode($resp);
  1075. }
  1076. //订单详情查询
  1077. public function actionOrderQuery()
  1078. {
  1079. $dada = Yii::getAlias("@vendor/dada/");
  1080. require_once $dada . 'api/OrderQueryApi.php';
  1081. require_once $dada . 'client/dadaRequestClient.php';
  1082. require_once $dada . 'client/dadaResponse.php';
  1083. require_once $dada . 'config/config.php';
  1084. require_once $dada . 'model/orderModel.php';
  1085. // isOnline 判断是否是测试环境,会有不同的域名等
  1086. $isOnline = false;
  1087. $sourceId = 1000000;
  1088. // 初始化一个config
  1089. $config = new \Config($sourceId, $isOnline);
  1090. $orderModel = new \OrderModel();
  1091. $orderModel->setOrderId('2018091100000002');
  1092. // api主要有2个参数,一个是url, 一个是业务参数
  1093. $addOrderApi = new \OrderQueryApi(json_encode($orderModel));
  1094. $dada_client = new \DadaRequestClient($config, $addOrderApi);
  1095. $resp = $dada_client->makeRequest();
  1096. echo json_encode($resp);
  1097. }
  1098. public function actionFocus()
  1099. {
  1100. $name = '花卉宝';
  1101. if (getenv('YII_ENV') == 'dev') {
  1102. $name = '花美灵';
  1103. }
  1104. $merchant = MerchantService::getByCondition(['name' => $name]);
  1105. $list = wxUtil::getSubscribeUserList($merchant);
  1106. dd($list);
  1107. }
  1108. //宝贝售出提醒 ssh 2020.1.30
  1109. public function actionInform()
  1110. {
  1111. $merchant = MerchantService::getMerchantById(12362);
  1112. $order = OrderService::getById(214810);
  1113. InformAdminClass::sendComplete($order);
  1114. }
  1115. public function actionNotice()
  1116. {
  1117. $data = ['messageType' => 'inform', 'informWay' => 'wx', 'userType' => 'admin', 'id' => 6, 'mobile' => '15280215347'];
  1118. $producer = Yii::$app->rabbitmq->getProducer('informProducer');
  1119. echo '<pre>';
  1120. print_r($data);
  1121. $msg = serialize($data);
  1122. $r = $producer->publish($msg, 'informExchange', 'informRoute');
  1123. }
  1124. }