TestController.php 52 KB

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