TestController.php 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980
  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\RefundOrderClass;
  12. use bizHd\message\classes\InformAdminClass;
  13. use bizHd\order\services\OrderService;
  14. use bizHd\purchase\classes\PurchaseClass;
  15. use bizHd\purchase\classes\PurchaseClearClass;
  16. use bizHd\wx\classes\WxOpenClass;
  17. use bizGhs\express\services\MiniExpressService;
  18. use common\components\arrayUtil;
  19. use common\components\dict;
  20. use common\components\lakala\Lakala;
  21. use common\components\miniUtil;
  22. use common\components\noticeUtil;
  23. use common\components\orderSn;
  24. use common\components\wxUtil;
  25. use common\components\payUtil;
  26. use Yii;
  27. use common\components\util;
  28. class TestController extends BaseController
  29. {
  30. public $guestAccess = ['debt', 'apply', 'clear', 'ls-trade-query', 'refund-query', 'inform', 'notice', 'order-query', 'add-order', 'index', 'get', 'trade-query', 'query', 'balance-query', 'refund'];
  31. //欠款的查询与跟踪 ssh 20240103
  32. public function actionDebt()
  33. {
  34. echo "<pre>";
  35. print_r($_SERVER);
  36. die;
  37. $customId = 17081;
  38. $custom = CustomClass::getById($customId, true);
  39. if (empty($custom)) {
  40. echo '没有找到客户';
  41. die;
  42. }
  43. $flag = [];
  44. $changeList = CustomDebtChangeClass::getAllByCondition(['customId' => $customId], null, '*');
  45. if (!empty($changeList)) {
  46. foreach ($changeList as $change) {
  47. $event = $change['evnet'] ?? '';
  48. $relateId = $change['relateId'] ?? 0;
  49. $amount = $change['amount'] ?? 0;
  50. if (strpos($event, '购买花材') >= 0) {
  51. $flag['40-' . $relateId] = $amount;
  52. }
  53. if (strpos($event, '退款') >= 0) {
  54. $flag['33-' . $relateId] = $amount;
  55. }
  56. if (strpos($event, '结账') >= 0) {
  57. $flag['20-' . $relateId] = $amount;
  58. }
  59. }
  60. }
  61. print_r($flag);
  62. $orderList = OrderClass::getAllByCondition(['customId' => $customId, 'debtPrice>' => 0], null, 'id,actPrice,payTime', null);
  63. $arr = [];
  64. if (!empty($orderList)) {
  65. foreach ($orderList as $order) {
  66. $payTime = $order['payTime'] ?? '';
  67. $id = $order['id'] ?? 0;
  68. $arr[$payTime] = $order;
  69. if (isset($flag['40-' . $id]) == false) {
  70. echo '40-' . $id . "订单有问题\n";
  71. }
  72. }
  73. }
  74. //20
  75. $clearList = PurchaseClearClass::getAllByCondition(['customId' => $customId, 'status' => 2], null, 'id,actPrice,payTime', null);
  76. if (!empty($clearList)) {
  77. foreach ($clearList as $clear) {
  78. $payTime = $clear['payTime'] ?? '';
  79. $id = $clear['id'] ?? 0;
  80. $arr[$payTime] = $clear;
  81. if (isset($flag['20-' . $id]) == false) {
  82. echo '20-' . $id . "结账有问题\n";
  83. }
  84. }
  85. }
  86. //33
  87. $refundList = RefundOrderClass::getAllByCondition(['customId' => $customId], null, 'id,refundPrice,updateTime', null);
  88. if (!empty($refundList)) {
  89. foreach ($refundList as $refund) {
  90. $id = $refund['id'] ?? 0;
  91. $updateTime = $refund['updateTime'] ?? '';
  92. $arr[$updateTime] = $refund;
  93. if (isset($flag['33-' . $id]) == false) {
  94. echo '33-' . $id . "退款单有问题\n";
  95. }
  96. }
  97. }
  98. echo "<pre>";
  99. ksort($arr);
  100. print_r($arr);
  101. die;
  102. }
  103. //退款操作 ssh 20231029
  104. public function actionRefund()
  105. {
  106. $shopId = 36524;
  107. $shop = ShopClass::getById($shopId, true);
  108. if (empty($shop)) {
  109. util::fail('没有找到门店');
  110. }
  111. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  112. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  113. $params = [
  114. 'appid' => 'OP00002119',
  115. 'serial_no' => '018b08cfddbd',
  116. 'merchant_no' => $shop->lklSjNo,
  117. 'term_no' => $shop->lklB2BTermNo,
  118. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  119. 'lklCertificatePath' => $lklCertificatePath,
  120. ];
  121. $laResource = new Lakala($params);
  122. $refundReason = '暂无';
  123. $refundOrderSn = orderSn::getCgRefundSn();
  124. $refundPrice = 0.01;
  125. $refundFee = bcmul($refundPrice, 100);
  126. $orderSn = 'KD_CS61235203';
  127. $originTradeNo = '20231030110113230266215266468756';
  128. //$originLogNo = '66215266025626';
  129. $aliParams = [
  130. 'refundSn' => $refundOrderSn,
  131. 'orderSn' => $orderSn,
  132. 'refundAmount' => $refundFee,
  133. 'refundReason' => $refundReason,
  134. 'originTradeNo' => $originTradeNo,
  135. //'originLogNo' => $originLogNo,
  136. ];
  137. $response = $laResource->refund($aliParams);
  138. echo '<pre>';
  139. print_r($response);
  140. }
  141. public function actionApply()
  142. {
  143. $id = 2888;
  144. $shopId = 36524;
  145. $cg = PurchaseClass::getById($id, true);
  146. $shop = ShopClass::getById($shopId, true);
  147. WxMessageClass::hdNewCgOrderInform($shop, $cg);
  148. }
  149. public function actionGet()
  150. {
  151. ini_set('memory_limit', '2045M');
  152. set_time_limit(0);
  153. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  154. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  155. $arr = [
  156. //['name' => '国兰花尚OK', 'merchantNo' => '82239305992006L', 'wx' => [600913569, 600907053], 'zfb' => '2088820709029782'],
  157. //['name' => '花掌柜OK', 'merchantNo' => '82240505992000P', 'wx' => [600466131, 600465187], 'zfb' => '2088820656569304'],
  158. //['name' => '纯彩花艺OK', 'merchantNo' => '82239305992006M', 'wx' => [600922790, 600915407], 'zfb' => '2088820710146836'],
  159. //['name' => '集美天天鲜花OK', 'merchantNo' => '82239305992006P', 'wx' => [601036538, 601036322], 'zfb' => '2088820726763339'],
  160. //['name' => '丰行花行OK', 'merchantNo' => '82260205992007P', 'wx' => [601053759, 601052157], 'zfb' => '2088820725885465'],
  161. //['name' => '独家花行OK', 'merchantNo' => '82239305992006Q', 'wx' => [601049483, 601048223], 'zfb' => '2088820725546555'],
  162. //['name' => '好多花海沧OK', 'merchantNo' => '82239305992006R', 'wx' => [601052177, 601053735], 'zfb' => '2088820725549695'],
  163. //['name' => '美天鲜花OK', 'merchantNo' => '82259505992003F', 'wx' => [601062064, 601138175], 'zfb' => '2088820729400990'],
  164. //['name' => '天天陈江店OK', 'merchantNo' => '82259505992003E', 'wx' => [601060616, 601059382], 'zfb' => '2088820725555368'],
  165. //['name' => '叶上花OK', 'merchantNo' => '82231805992002G', 'wx' => [601062892, 601062589], 'zfb' => '2088820728763546'],
  166. //['name' => '好又多(小明)OK', 'merchantNo' => '82239305992006S', 'wx' => [601135715, 601067347], 'zfb' => '2088820729698012'],
  167. //['name' => '我卖花OK', 'merchantNo' => '82227505992000R', 'wx' => [601177139, 601148755], 'zfb' => '2088820746424032'],
  168. //['name' => '问境OK', 'merchantNo' => '8226900599200KX', 'wx' => [601299388, 601299453], 'zfb' => '2088820787661843'],
  169. //['name' => '昱成OK', 'merchantNo' => '8226900599200KY', 'wx' => [601312993, 601325844], 'zfb' => '2088820788900240'],
  170. //['name' => '杭州斗南', 'merchantNo' => '杭州斗南', 'wx' => [601405963, 601405929], 'zfb' => '2088820793601705'],
  171. //['name' => '杭州斗南(没用)', 'merchantNo' => '8223310599200AD', 'wx' => [601254682, 601250805], 'zfb' => '2088820782666872'],
  172. //['name' => '珑松花卉长安店', 'merchantNo' => '82260205992007U', 'wx' => [602499045, 602497558], 'zfb' => '2088820959620797'],
  173. //['name' => '福州花福(个人)', 'merchantNo' => '82239105992007P', 'wx' => [603301197, 603302321], 'zfb' => '2088920058098261'],
  174. //['name' => '福州花福', 'merchantNo' => '82239105992007N', 'wx' => [602796807, 602774796], 'zfb' => '2088820996010582'],
  175. //['name' => '昆明新宏源', 'merchantNo' => '82239305992007H', 'wx' => [606098318, 606100317], 'zfb' => '2088920878302843'],
  176. //['name' => '昆明纯彩', 'merchantNo' => '82239905992003L', 'wx' => [604923629, 604922175], 'zfb' => '2088920533160795'],
  177. //['name' => '花优田(军兴旺)', 'merchantNo' => '8227310599200GX', 'wx' => [605191281, 605190492], 'zfb' => '2088920588715249'],
  178. ['name' => '厦门遇见你', 'merchantNo' => '82239305992008D', 'wx' => [614782373, 614783346], 'zfb' => '2088430828233036'],
  179. //['name' => '淄博花超鲜花批发', 'merchantNo' => '82245305992001R', 'wx' => [614685779, 614682986], 'zfb' => '2088430805221810'],
  180. //['name' => '广州国恋', 'merchantNo' => '8225810599200Q7', 'wx' => [612321716, 612320978], 'zfb' => '2088330479975012'],
  181. //['name' => '欣研鲜花', 'merchantNo' => '82260305992001Y', 'wx' => [612181234, 612181615], 'zfb' => '2088330365608286'],
  182. //['name' => '村长冷链', 'merchantNo' => '82260205992008G', 'wx' => [612168406, 612168000], 'zfb' => '2088330360870932'],
  183. //['name' => '惠州惠雅鲜花批发', 'merchantNo' => '82259505992003S', 'wx' => [611676975, 611677314], 'zfb' => '2088330136601427'],
  184. //['name' => '杭州斗南鲜花', 'merchantNo' => '8223310599200AR', 'wx' => [608955814, 608955082], 'zfb' => '2088130449323603'],
  185. //['name' => '营口简约花卉', 'merchantNo' => '8227310599200HJ', 'wx' => [608439898, 608440994], 'zfb' => '2088130112725929'],
  186. //['name' => '惠雅鲜花惠州店', 'merchantNo' => '82260205992007Z', 'wx' => [608406948, 608403207], 'zfb' => '2088130098167302'],
  187. //['name' => '云南珑松花卉珠海店', 'merchantNo' => '82258505992002U', 'wx' => [608062727, 608056474], 'zfb' => '2088030873238576'],
  188. //['name' => '买手很忙', 'merchantNo' => '8227310599200GJ', 'wx' => [601597167, 601595526], 'zfb' => '2088820818930267'],
  189. //['name' => '七彩花都', 'merchantNo' => '8227310599200GF', 'wx' => [601176481, 601148503], 'zfb' => '2088820748594478'],
  190. //['name' => '十年', 'merchantNo' => '82252305992001U', 'wx' => [601285154, 601261795], 'zfb' => '2088820782171763'],
  191. //['name' => '都市花季OK', 'merchantNo' => '82239305992006U', 'wx' => [601174342, 601147649], 'zfb' => '2088820748507346'],
  192. //['name' => '花样年华OK', 'merchantNo' => '82260205992007Q', 'wx' => [601134352, 601091710], 'zfb' => '2088820735043444'],
  193. //['name' => '精茂城OK', 'merchantNo' => '8225840599200TF', 'wx' => [601173752, 601143352], 'zfb' => '2088820746800005'],
  194. //['name' => '莱漫OK', 'merchantNo' => '82239305992007A', 'wx' => [601288494, 601288166], 'zfb' => '2088820783686611'],
  195. //['name' => '莱漫(没用)', 'merchantNo' => '82239305992006T', 'wx' => [601134065, 601125595], 'zfb' => '2088820743859918'],
  196. //['name' => '福州我要花OK', 'merchantNo' => '82239105992007J', 'wx' => [601134030, 601128111], 'zfb' => '2088820745276973'],
  197. //['name' => '泉城OK', 'merchantNo' => '82239705992004F', 'wx' => [601273270, 601272854], 'zfb' => '2088820784658561'],
  198. //['name' => '泉城(没用)', 'merchantNo' => '82239705992004E', 'wx' => [601133056, 601133821], 'zfb' => '2088820746111323'],
  199. //['name' => '美丽花行OK', 'merchantNo' => '82239305992006V', 'wx' => [601155249, 601149712], 'zfb' => '2088820747673312'],
  200. //['name' => '三叶OK', 'merchantNo' => '82236805992001Y', 'wx' => [601152233, 601151024], 'zfb' => '2088820747556725'],
  201. //['name' => '花大苪OK', 'merchantNo' => '8227310599200GG', 'wx' => [601174221, 601165136], 'zfb' => '2088820751181377'],
  202. //['name' => '十堰天天鲜花OK', 'merchantNo' => '82252305992001S', 'wx' => [601171131, 601170642], 'zfb' => '2088820750844626'],
  203. //['name' => '珑松花卉OK', 'merchantNo' => '82260205992007S', 'wx' => [601176093, 601174262], 'zfb' => '2088820754742492'],
  204. //['name' => '惠雅鲜花OK', 'merchantNo' => '82260205992007R', 'wx' => [601173390, 601174002], 'zfb' => '2088820753174540'],
  205. //['name' => '锦绣花卉OK', 'merchantNo' => '82252305992001T', 'wx' => [601176719, 601176660], 'zfb' => '2088820754751663'],
  206. //['name' => '祥瑞鲜花同安店OK', 'merchantNo' => '82239305992006W', 'wx' => [601178350, 601177795], 'zfb' => '2088820755715024'],
  207. //['name' => '祥瑞鲜花翔安店OK', 'merchantNo' => '82239305992006X', 'wx' => [601178260, 601178199], 'zfb' => '2088820754481553'],
  208. //['name' => '初见花季OK', 'merchantNo' => '82239305992006Y', 'wx' => [601178998, 601179605], 'zfb' => '2088820757223312'],
  209. //['name' => '荣发鲜花OK', 'merchantNo' => '82242705992000D', 'wx' => [601179681, 601179180], 'zfb' => '2088820756926593'],
  210. //['name' => '花千朵(多多)OK', 'merchantNo' => '82239305992006Z', 'wx' => [601223474, 601208096], 'zfb' => '2088820766783276'],
  211. //['name' => '花悠星OK', 'merchantNo' => '8225810599200NH', 'wx' => [601228194, 601227691], 'zfb' => '2088820774587446'],
  212. //['name' => '花悠星(没用)', 'merchantNo' => '8225810599200NG', 'wx' => [601223630, 601210952], 'zfb' => '2088820767072874'],
  213. //['name' => '源花汇OK', 'merchantNo' => '82222105992004A', 'wx' => [601221944, 601214269], 'zfb' => '2088820770594246'],
  214. //['name' => '源花汇2(没用)', 'merchantNo' => '8227310599200GD', 'wx' => [601136305, 601067016], 'zfb' => '2088820729832744'],
  215. ];
  216. $new = [];
  217. foreach ($arr as $item) {
  218. $wx = $item['wx'];
  219. $zfb = $item['zfb'];
  220. $merchantNo = $item['merchantNo'];
  221. $name = $item['name'] . ' ' . $merchantNo;
  222. $group = [];
  223. foreach ($wx as $oneWx) {
  224. $params = [
  225. 'appid' => 'OP00002119',
  226. 'serial_no' => '018b08cfddbd',
  227. 'merchant_no' => $merchantNo,
  228. 'term_no' => 'C6337694',
  229. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  230. 'lklCertificatePath' => $lklCertificatePath,
  231. ];
  232. $data = [
  233. 'subMerchantId' => $oneWx,
  234. 'tradeMode' => 'WECHAT',
  235. ];
  236. $laResource = new Lakala($params);
  237. $response = $laResource->openStateQuery($data);
  238. $statusName = '出错了';
  239. if ($response['retCode'] == '000000') {
  240. $checkResult = $response['respData']['checkResult'] ?? '';
  241. $statusName = '未认证';
  242. if ($checkResult == 'AUTHORIZE_STATE_AUTHORIZED') {
  243. $statusName = '已认证';
  244. }
  245. }
  246. $group[] = '微信 ' . $oneWx . ' ' . $statusName;
  247. }
  248. $params = [
  249. 'appid' => 'OP00002119',
  250. 'serial_no' => '018b08cfddbd',
  251. 'merchant_no' => $merchantNo,
  252. 'term_no' => 'C6337694',
  253. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  254. 'lklCertificatePath' => $lklCertificatePath,
  255. ];
  256. $data = [
  257. 'subMerchantId' => $zfb,
  258. 'tradeMode' => 'ALIPAY',
  259. ];
  260. $laResource = new Lakala($params);
  261. $response = $laResource->openStateQuery($data);
  262. $statusName = '出错了';
  263. if ($response['retCode'] == '000000') {
  264. $checkResult = $response['respData']['checkResult'] ?? '';
  265. $statusName = '未认证';
  266. if ($checkResult == 'AUTHORIZED') {
  267. $statusName = '已认证';
  268. }
  269. }
  270. $group[] = '支付宝 ' . $zfb . ' ' . $statusName;
  271. $new[] = ['name' => $name, 'status' => $group];
  272. }
  273. echo '<pre>';
  274. print_r($new);
  275. die;
  276. }
  277. public function actionRefundQuery()
  278. {
  279. $shopId = 520;
  280. $shop = ShopClass::getById($shopId, true);
  281. if (empty($shop)) {
  282. util::stop('没有找到门店');
  283. }
  284. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  285. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  286. $params = [
  287. 'appid' => 'OP00002119',
  288. 'serial_no' => '018b08cfddbd',
  289. 'merchant_no' => $shop->lklSjNo,
  290. 'term_no' => $shop->lklScanTermNo,
  291. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  292. 'lklCertificatePath' => $lklCertificatePath,
  293. ];
  294. $laResource = new Lakala($params);
  295. $orderSn = '20231201110113131266165492618754';
  296. $data = [
  297. 'orderSn' => $orderSn,
  298. ];
  299. $response = $laResource->refundQuery($data);
  300. echo "<pre>";
  301. print_r($response);
  302. }
  303. public function actionBalanceQuery()
  304. {
  305. $shopId = 1212;
  306. $shop = ShopClass::getById($shopId, true);
  307. if (empty($shop)) {
  308. util::stop('没有找到门店');
  309. }
  310. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  311. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  312. $params = [
  313. 'appid' => 'OP00002119',
  314. 'serial_no' => '018b08cfddbd',
  315. 'merchant_no' => $shop->lklSjNo,
  316. 'term_no' => $shop->lklScanTermNo,
  317. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  318. 'lklCertificatePath' => $lklCertificatePath,
  319. ];
  320. $laResource = new Lakala($params);
  321. $response = $laResource->accountBalanceQuery();
  322. echo "<pre>";
  323. print_r($response);
  324. }
  325. //测试环境查线上数据 ssh 20231230
  326. public function actionCsQuery()
  327. {
  328. // $shopId = 1527;
  329. // $shop = ShopClass::getById($shopId, true);
  330. // if (empty($shop)) {
  331. // util::stop('没有找到门店');
  332. // }
  333. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  334. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  335. $params = [
  336. 'appid' => 'OP00002119',
  337. 'serial_no' => '018b08cfddbd',
  338. //'merchant_no' => $shop->lklSjNo,
  339. 'merchant_no' => '82222105992004A',
  340. //'term_no' => $shop->lklScanTermNo,
  341. 'term_no' => 'H3656802',
  342. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  343. 'lklCertificatePath' => $lklCertificatePath,
  344. ];
  345. $laResource = new Lakala($params);
  346. $queryParams = [
  347. //'orderSn' => 'KD26452235',
  348. 'tradeNo' => '20231230110113130266215700775011',
  349. ];
  350. $response = $laResource->query($queryParams, 1);
  351. echo "<pre>";
  352. print_r($response);
  353. }
  354. public function actionQuery()
  355. {
  356. // $shopId = 1527;
  357. // $shop = ShopClass::getById($shopId, true);
  358. // if (empty($shop)) {
  359. // util::stop('没有找到门店');
  360. // }
  361. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  362. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  363. $params = [
  364. 'appid' => 'OP00002119',
  365. 'serial_no' => '018b08cfddbd',
  366. //'merchant_no' => $shop->lklSjNo,
  367. 'merchant_no' => '82222105992004A',
  368. //'term_no' => $shop->lklScanTermNo,
  369. 'term_no' => 'H3656802',
  370. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  371. 'lklCertificatePath' => $lklCertificatePath,
  372. ];
  373. $laResource = new Lakala($params);
  374. $queryParams = [
  375. //'orderSn' => 'KD26452235',
  376. 'tradeNo' => '20231230110113130266215700775011',
  377. ];
  378. $response = $laResource->query($queryParams, 1);
  379. echo "<pre>";
  380. print_r($response);
  381. }
  382. //零售订单查询 ssh 20231031
  383. public function actionLsTradeQuery()
  384. {
  385. $shopId = 1422;
  386. $shop = ShopClass::getById($shopId, true);
  387. if (empty($shop)) {
  388. util::stop('没有找到门店');
  389. }
  390. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  391. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  392. $params = [
  393. 'appid' => 'OP00002119',
  394. 'serial_no' => '018b08cfddbd',
  395. 'merchant_no' => $shop->lklSjNo,
  396. 'term_no' => $shop->lklScanTermNo,
  397. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  398. 'lklCertificatePath' => $lklCertificatePath,
  399. ];
  400. $laResource = new Lakala($params);
  401. $queryParams = [
  402. 'orderSn' => 'KD26461864',
  403. //'tradeNo' => '20231029110113130266215259252887',
  404. ];
  405. $response = $laResource->query($queryParams, 0);
  406. print_r($response);
  407. util::stop();
  408. if (isset($response['code']) && $response['code'] == 'BBS00000') {
  409. $connection = Yii::$app->db;
  410. $transaction = $connection->beginTransaction();
  411. try {
  412. $postData = $response['resp_data'] ?? [];
  413. $orderSn = $postData['out_trade_no'] ?? '';
  414. $total_amount = $postData['total_amount'] ?? 0;
  415. $account_type = $postData['account_type'] ?? '';
  416. if (empty($account_type)) {
  417. noticeUtil::push('支付回调失败了,没有找到钱包类型,请注意,orderSn:' . $orderSn, '15280215347');
  418. util::end();
  419. }
  420. $totalFee = $total_amount / 100;
  421. $transactionId = $postData['trade_no'] ?? 0;
  422. $capitalType = dict::getDict('capitalType', 'xhOrder', 'id');
  423. $currentPayWay = null;
  424. if ($account_type == 'WECHAT') {
  425. $currentPayWay = dict::getDict('payWay', 'wxPay');
  426. } elseif ($account_type == 'ALIPAY') {
  427. $currentPayWay = dict::getDict('payWay', 'alipay');
  428. } else {
  429. noticeUtil::push('支付回调失败了,没有找到支付类型,orderSn:' . $orderSn, '15280215347');
  430. util::end();
  431. }
  432. $attach = '';
  433. payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
  434. $transaction->commit();
  435. echo 'OK';
  436. } catch (\Exception $e) {
  437. $transaction->rollBack();
  438. Yii::error("失败原因:" . $e->getMessage());
  439. }
  440. }
  441. }
  442. //零售订单查询 ssh 20231031
  443. public function actionClear()
  444. {
  445. $shopId = 10649;
  446. $shop = ShopClass::getById($shopId, true);
  447. if (empty($shop)) {
  448. util::stop('没有找到门店');
  449. }
  450. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  451. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  452. $params = [
  453. 'appid' => 'OP00002119',
  454. 'serial_no' => '018b08cfddbd',
  455. 'merchant_no' => $shop->lklSjNo,
  456. 'term_no' => $shop->lklScanTermNo,
  457. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  458. 'lklCertificatePath' => $lklCertificatePath,
  459. ];
  460. $laResource = new Lakala($params);
  461. $queryParams = [
  462. //'orderSn' => 'KD26461864',
  463. 'tradeNo' => '20231230110113130266215700775011',
  464. ];
  465. $response = $laResource->query($queryParams, 1);
  466. print_r($response);
  467. util::stop();
  468. if (isset($response['code']) && $response['code'] == 'BBS00000') {
  469. $connection = Yii::$app->db;
  470. $transaction = $connection->beginTransaction();
  471. try {
  472. $postData = $response['resp_data'] ?? [];
  473. $orderSn = $postData['out_trade_no'] ?? '';
  474. $total_amount = $postData['total_amount'] ?? 0;
  475. $account_type = $postData['account_type'] ?? '';
  476. if (empty($account_type)) {
  477. noticeUtil::push('支付回调失败了,没有找到钱包类型,请注意,orderSn:' . $orderSn, '15280215347');
  478. util::end();
  479. }
  480. $totalFee = $total_amount / 100;
  481. $transactionId = $postData['trade_no'] ?? 0;
  482. $capitalType = dict::getDict('capitalType', 'hdPurchaseClear', 'id');
  483. $currentPayWay = null;
  484. if ($account_type == 'WECHAT') {
  485. $currentPayWay = dict::getDict('payWay', 'wxPay');
  486. } elseif ($account_type == 'ALIPAY') {
  487. $currentPayWay = dict::getDict('payWay', 'alipay');
  488. } else {
  489. noticeUtil::push('支付回调失败了,没有找到支付类型,orderSn:' . $orderSn, '15280215347');
  490. util::end();
  491. }
  492. $attach = '';
  493. payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
  494. $transaction->commit();
  495. echo 'OK';
  496. } catch (\Exception $e) {
  497. $transaction->rollBack();
  498. Yii::error("失败原因:" . $e->getMessage());
  499. }
  500. }
  501. }
  502. //交易查询 ssh 20231021
  503. public function actionTradeQuery()
  504. {
  505. $shopId = 520;
  506. $shop = ShopClass::getById($shopId, true);
  507. if (empty($shop)) {
  508. util::stop('没有找到门店');
  509. }
  510. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  511. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  512. $params = [
  513. 'appid' => 'OP00002119',
  514. 'serial_no' => '018b08cfddbd',
  515. 'merchant_no' => $shop->lklSjNo,
  516. 'term_no' => $shop->lklScanTermNo,
  517. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  518. 'lklCertificatePath' => $lklCertificatePath,
  519. ];
  520. $laResource = new Lakala($params);
  521. $queryParams = [
  522. 'orderSn' => 'CG26741062',
  523. //'tradeNo' => '20231029110113130266215259252887',
  524. ];
  525. $response = $laResource->query($queryParams, 0);
  526. print_r($response);
  527. util::stop();
  528. if (isset($response['code']) && $response['code'] == 'BBS00000') {
  529. $capitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
  530. $connection = Yii::$app->db;
  531. $transaction = $connection->beginTransaction();
  532. try {
  533. $account_type = $response['resp_data']['account_type'] ?? 0;
  534. if (empty($account_type)) {
  535. noticeUtil::push('支付回调失败了,没有找到钱包类型,请注意', '15280215347');
  536. util::end();
  537. }
  538. $currentPayWay = null;
  539. if ($account_type == 'WECHAT') {
  540. $currentPayWay = dict::getDict('payWay', 'wxPay');
  541. } elseif ($account_type == 'ALIPAY') {
  542. $currentPayWay = dict::getDict('payWay', 'alipay');
  543. } else {
  544. noticeUtil::push('支付回调失败了,没有找到支付类型', '15280215347');
  545. util::end();
  546. }
  547. $attach = '';
  548. $total_amount = $response['resp_data']['total_amount'] ?? 0;
  549. $orderSn = $response['resp_data']['out_trade_no'] ?? 0;
  550. $totalFee = $total_amount / 100;
  551. $transactionId = $response['resp_data']['trade_no'] ?? 0;
  552. payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
  553. $transaction->commit();
  554. echo 'OK';
  555. } catch (\Exception $e) {
  556. $transaction->rollBack();
  557. Yii::error("失败原因:" . $e->getMessage());
  558. }
  559. }
  560. }
  561. public function actionAliRun2()
  562. {
  563. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  564. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  565. $params = [
  566. 'appid' => 'OP00002119',
  567. 'serial_no' => '018b08cfddbd',
  568. 'merchant_no' => '82240505992000N',
  569. 'term_no' => 'C6337694',
  570. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  571. 'lklCertificatePath' => $lklCertificatePath,
  572. ];
  573. $outTradeNo = orderSn::getPurchaseSn();
  574. $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback";
  575. $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
  576. $aliParams = [
  577. 'orderSn' => $outTradeNo,
  578. 'amount' => 0.16,
  579. 'capitalType' => $currentCapitalType,
  580. 'notifyUrl' => $notifyUrl,
  581. ];
  582. $laResource = new Lakala($params);
  583. $response = $laResource->driveAliPay($aliParams);
  584. if ($response && isset($response['cmdRetCode']) && $response['cmdRetCode'] == 'GLOBAL_SUCCESS') {
  585. echo '<pre>';
  586. echo "下单成功<br/>";
  587. print_r($response);
  588. } else {
  589. echo '<pre>';
  590. echo "下单失败<br/>";
  591. print_r($response);
  592. }
  593. }
  594. public function actionAliRun3()
  595. {
  596. $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
  597. $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
  598. $params = [
  599. 'appid' => 'OP00002119',
  600. 'serial_no' => '018b08cfddbd',
  601. 'merchant_no' => '82240505992000N',
  602. 'term_no' => 'C6337694',
  603. 'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
  604. 'lklCertificatePath' => $lklCertificatePath,
  605. ];
  606. $laResource = new Lakala($params);
  607. $outTradeNo = orderSn::getPurchaseSn();
  608. $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback";
  609. $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
  610. $wxParams = [
  611. 'orderSn' => $outTradeNo,
  612. 'amount' => 0.16,
  613. 'capitalType' => $currentCapitalType,
  614. 'notifyUrl' => $notifyUrl,
  615. ];
  616. $response = $laResource->driveWxPay($wxParams);
  617. if ($response && isset($response['cmdRetCode']) && $response['cmdRetCode'] == 'GLOBAL_SUCCESS') {
  618. echo '<pre>';
  619. echo "下单成功<br/>";
  620. print_r($response);
  621. } else {
  622. echo '<pre>';
  623. echo "下单失败<br/>";
  624. print_r($response);
  625. }
  626. }
  627. //dada 城市code
  628. public function actionDadaCityCode()
  629. {
  630. $res = dada::getCityCode(0);
  631. util::success($res);
  632. }
  633. //理由
  634. public function actionDadaReasons()
  635. {
  636. $res = dada::getCancelReason(0);
  637. util::success($res);
  638. }
  639. //达达 :下单
  640. public function actionDadaAddOrder()
  641. {
  642. $orderSn = 'XSD_CS26316851';
  643. $orderInfo = OrderClass::getByOrderSn($orderSn);
  644. $res = DadaExpressServices::addOrder($orderInfo);
  645. util::success($res);
  646. }
  647. //重发快递
  648. public function actionDadaReAdd()
  649. {
  650. $orderSn = 'XSD_CS26316851';
  651. $orderInfo = OrderClass::getByOrderSn($orderSn);
  652. $res = DadaExpressServices::reAddOrder($orderInfo);
  653. util::success($res);
  654. }
  655. //达达状态查询
  656. public function actionDadaOrderStatus()
  657. {
  658. $orderSn = 'XSD_CS26316851';
  659. $res = DadaExpressServices::statusOrder($orderSn);
  660. util::success($res);
  661. }
  662. //达达取消下单
  663. public function actionDadaCancelOrder()
  664. {
  665. $orderSn = 'XSD_CS26316851';
  666. $res = DadaExpressServices::cancelOrder($orderSn, 1);
  667. util::success($res);
  668. }
  669. //获取已支持的配送公司列表接口
  670. public function actionGetAllDelivery()
  671. {
  672. $data = MiniExpressService::getAllImmeDelivery();
  673. util::success($data);
  674. }
  675. //即时配送
  676. /*
  677. * Array
  678. (
  679. [resultcode] => 0
  680. [resultmsg] => OK
  681. [shop_list] => Array
  682. (
  683. [0] => Array
  684. (
  685. [shopid] => 1588714266
  686. [delivery_id] => SFTC
  687. [audit_result] => 0
  688. [create_time] => 1612172838
  689. [remark] =>
  690. [delivery_name] => 顺丰同城急送
  691. )
  692. )
  693. )
  694. */
  695. public function actionGetBindAccount()
  696. {
  697. $merchant = WxOpenClass::getGhsWxInfo();
  698. $isOpen = 2;
  699. $r = miniUtil::getBindAccount($merchant, $isOpen);
  700. dd($r);
  701. }
  702. //下单 (沙箱)
  703. /**
  704. * Array
  705. * (
  706. * [resultcode] => 0
  707. * [resultmsg] => ok
  708. * [fee] => 10
  709. * [waybill_id] => test_shop_id1612365974_waybillid
  710. * [order_status] => 101
  711. * [dispatch_duration] => 300
  712. * )
  713. */
  714. public function actionCreateWaybill()
  715. {
  716. $merchant = WxOpenClass::getGhsWxInfo();
  717. $isOpen = 2;
  718. $shopId = 'test_shop_id';
  719. $shopOrderId = 'test_shop_id' . time();
  720. $appSecret = 'test_app_secrect';
  721. $data = [
  722. 'shopid' => $shopId,
  723. 'shop_order_id' => $shopOrderId,
  724. 'shop_no' => '1',
  725. 'delivery_sign' => miniUtil::getDeliverySign($shopId, $shopOrderId, $appSecret), //,则delivery_sign=SHA1(shopid + shop_order_id + AppSecret)
  726. 'delivery_id' => "TEST",
  727. 'openid' => 'oGKMp45YLxewOTWEbpMFzWoVqdW0',
  728. 'sender' => [
  729. 'name' => 'test',
  730. 'city' => '厦门市',
  731. 'address' => '思明区',
  732. 'address_detail' => '软件园二期',
  733. 'phone' => '19959271111',
  734. 'lng' => 118.134343,
  735. 'lat' => 24.483566,
  736. 'coordinate_type' => 0,
  737. ],
  738. 'receiver' => [
  739. 'name' => 'test',
  740. 'city' => '厦门市',
  741. 'address' => '思明区',
  742. 'address_detail' => '软件园二期',
  743. 'phone' => '19959271111',
  744. 'lng' => 118.134343,
  745. 'lat' => 24.493566,
  746. 'coordinate_type' => 0,
  747. ],
  748. 'cargo' => [
  749. 'goods_value' => 1,
  750. 'goods_weight' => 0.1,
  751. 'cargo_first_class' => '鲜花',
  752. 'cargo_second_class' => '鲜花',
  753. ],
  754. 'order_info' => [
  755. 'order_type' => 0,
  756. ],
  757. 'shop' => [
  758. 'wxa_path' => '/shop',
  759. 'img_url' => 'http://www.baidu.com/test.png',
  760. 'goods_name' => 'test',
  761. 'goods_count' => 1,
  762. ],
  763. ];
  764. $r = miniUtil::addOrder($data, $merchant, $isOpen);
  765. dd($r);
  766. }
  767. //获取运单数据
  768. /**
  769. * Array
  770. * (
  771. * [resultcode] => 0
  772. * [resultmsg] => ok
  773. * [order_status] => 101
  774. * [agent_info] => Array
  775. * (
  776. * )
  777. *
  778. * [waybill_id] => test_shop_id1612365974_waybillid
  779. * [rider_name] =>
  780. * [rider_phone] =>
  781. * [order_token] => NsXweKCKhSyAEIhAdnX3TYZsVDES0-t-tymHDONG0MpRsF31dQvVxiP_JJvLFaKS-kwXuOG3D0hzKkl7o-gzew
  782. * )
  783. */
  784. public function actionGetOrder()
  785. {
  786. $shopId = 'test_shop_id';
  787. $shopOrderId = 'test_shop_id1612365974';
  788. $appSecret = 'test_app_secrect';
  789. $merchant = WxOpenClass::getGhsWxInfo();
  790. $isOpen = 2;
  791. $data = [
  792. 'shopid' => $shopId,
  793. 'shop_order_id' => $shopOrderId,
  794. 'shop_no' => '1',
  795. 'delivery_sign' => MiniExpressService::getDeliverySign($shopId, $shopOrderId, $appSecret),
  796. ];
  797. $r = miniUtil::getOrder($data, $merchant, $isOpen);
  798. dd($r);
  799. }
  800. //沙盒 更新快递状态
  801. public function actionMockUpdateOrder()
  802. {
  803. $merchant = WxOpenClass::getGhsWxInfo();
  804. $isOpen = 2;
  805. /**
  806. * {
  807. * "shopid": "test_shop_id",
  808. * "shop_order_id": "xxxxxxxxxxx",
  809. * "waybill_id": "xxxxxxxxxxxxx",
  810. * "action_time": 12345678,
  811. * "order_status": 101,
  812. * "action_msg": "",
  813. * }
  814. */
  815. $shopId = 'test_shop_id';
  816. $shopOrderId = 'test_shop_id1612365974';
  817. $data = [
  818. 'shop_order_id' => $shopOrderId,
  819. "shopid" => $shopId,
  820. "action_time" => time(),
  821. "order_status" => 302,
  822. 'action_msg' => '状态变更',
  823. ];
  824. $r = miniUtil::mockUpdateOrder($data, $merchant, $isOpen);
  825. dd($r);
  826. }
  827. public function actionTest()
  828. {
  829. }
  830. //新增订单
  831. public function actionAddOrder()
  832. {
  833. $dada = Yii::getAlias("@vendor/dada/");
  834. require_once $dada . 'api/addOrderApi.php';
  835. require_once $dada . 'client/dadaRequestClient.php';
  836. require_once $dada . 'client/dadaResponse.php';
  837. require_once $dada . 'config/config.php';
  838. require_once $dada . 'model/orderModel.php';
  839. // isOnline 判断是否是测试环境,会有不同的域名等
  840. $isOnline = false;
  841. $sourceId = 1000000;
  842. // 初始化一个config
  843. $config = new \Config($sourceId, $isOnline);
  844. $orderModel = new \OrderModel();
  845. $orderModel->setShopNo('11047059');
  846. $orderModel->setOriginId('2018091100000002');
  847. $orderModel->setCityCode('021');
  848. $orderModel->setCargoPrice(10);
  849. $orderModel->setIsPrepay(0);
  850. $orderModel->setReceiverName('测试达达');
  851. $orderModel->setReceiverAddress('上海市崇明岛');
  852. $orderModel->setReceiverLat(31.63);
  853. $orderModel->setReceiverLng(121.41);
  854. $orderModel->setReceiverPhone('18588888888');
  855. $orderModel->setCallback('http://api.b.huaml.com/data/request');
  856. // api主要有2个参数,一个是url, 一个是业务参数
  857. $addOrderApi = new \AddOrderApi(json_encode($orderModel));
  858. $dada_client = new \DadaRequestClient($config, $addOrderApi);
  859. $resp = $dada_client->makeRequest();
  860. echo json_encode($resp);
  861. }
  862. //订单详情查询
  863. public function actionOrderQuery()
  864. {
  865. $dada = Yii::getAlias("@vendor/dada/");
  866. require_once $dada . 'api/OrderQueryApi.php';
  867. require_once $dada . 'client/dadaRequestClient.php';
  868. require_once $dada . 'client/dadaResponse.php';
  869. require_once $dada . 'config/config.php';
  870. require_once $dada . 'model/orderModel.php';
  871. // isOnline 判断是否是测试环境,会有不同的域名等
  872. $isOnline = false;
  873. $sourceId = 1000000;
  874. // 初始化一个config
  875. $config = new \Config($sourceId, $isOnline);
  876. $orderModel = new \OrderModel();
  877. $orderModel->setOrderId('2018091100000002');
  878. // api主要有2个参数,一个是url, 一个是业务参数
  879. $addOrderApi = new \OrderQueryApi(json_encode($orderModel));
  880. $dada_client = new \DadaRequestClient($config, $addOrderApi);
  881. $resp = $dada_client->makeRequest();
  882. echo json_encode($resp);
  883. }
  884. public function actionFocus()
  885. {
  886. $name = '花卉宝';
  887. if (getenv('YII_ENV') == 'dev') {
  888. $name = '花美灵';
  889. }
  890. $merchant = MerchantService::getByCondition(['name' => $name]);
  891. $list = wxUtil::getSubscribeUserList($merchant);
  892. dd($list);
  893. }
  894. //宝贝售出提醒 ssh 2020.1.30
  895. public function actionInform()
  896. {
  897. $merchant = MerchantService::getMerchantById(12362);
  898. $order = OrderService::getById(214810);
  899. InformAdminClass::sendComplete($order);
  900. }
  901. public function actionNotice()
  902. {
  903. $data = ['messageType' => 'inform', 'informWay' => 'wx', 'userType' => 'admin', 'id' => 6, 'mobile' => '15280215347'];
  904. $producer = Yii::$app->rabbitmq->getProducer('informProducer');
  905. echo '<pre>';
  906. print_r($data);
  907. $msg = serialize($data);
  908. $r = $producer->publish($msg, 'informExchange', 'informRoute');
  909. }
  910. }