TestController.php 60 KB

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