TestController.php 40 KB

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