huahuibao/app-ghs/controllers/TestController.php

<?php

namespace ghs\controllers;

use biz\admin\classes\AdminClass;
use biz\ghs\classes\GhsClass;
use biz\shop\classes\ShopClass;
use biz\sj\services\MerchantService;
use biz\wx\classes\WxMessageClass;
use bizGhs\custom\classes\CustomClass;
use bizGhs\custom\classes\CustomDebtChangeClass;
use bizGhs\express\services\DadaExpressServices;
use bizGhs\order\classes\OrderClass;
use bizGhs\order\classes\OrderItemClass;
use bizGhs\order\classes\RefundOrderClass;
use bizHd\message\classes\InformAdminClass;
use bizHd\order\services\OrderService;
use bizHd\purchase\classes\PurchaseClass;
use bizHd\purchase\classes\PurchaseClearClass;
use bizHd\wx\classes\WxOpenClass;
use bizGhs\express\services\MiniExpressService;
use bizHd\order\classes\OrderClass as ClassesOrderClass;
use bizHd\refund\classes\HdRefundClass;
use common\components\arrayUtil;
use common\components\dateUtil;
use common\components\dict;
use common\components\expressUtil;
use common\components\lakala\Lakala;
use common\components\miniUtil;
use common\components\noticeUtil;
use common\components\orderSn;
use common\components\shippingUtil;
use common\components\wxUtil;
use common\components\payUtil;
use Yii;
use common\components\util;

use wkhtmltox\Image\Converter;


class TestController extends BaseController
{

    public $guestAccess = ['fx', 'on', 'in', 'clear-query', 'ip', 'html', 'debt', 'apply', 'clear', 'ls-trade-query', 'ls-trade-refund', 'refund-query', 'inform', 'notice', 'order-query', 'add-order', 'index', 'get', 'trade-query', 'query', 'balance-query', 'refund', 'recharge-query', 'sim'];

    public function actionFx()
    {
        $ghsShopId = 7855;
        $ghsShop = ShopClass::getById($ghsShopId, true);
        if (empty($ghsShop)) {
            util::fail('没有找到供货商的门店');
        }
        $refundFee = bcmul(64, 100);
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $ghsShop->lklSjNo,
            'term_no' => $ghsShop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $refundReason = '';
        $aliParams = [
            'refundSn' => 'RD_CS001',
            'orderSn' => 'CG27325720',
            'refundAmount' => $refundFee,
            'refundReason' => $refundReason,
            'thirdNo' => '20240723110113130266217435048128',
        ];
        $response = $laResource->refund($aliParams);
        echo '<pre>';
        print_r($response);
    }

    public function actionOn()
    {

        $merchant = WxOpenClass::getMallWxInfo();
        $ptStyle = dict::getDict('ptStyle', 'mall');

        $ret = miniUtil::generateShortLink($merchant, 'pages/home/recent', '', $ptStyle);
        print_r($ret);

        util::stop();
        $merchant = WxOpenClass::getGhsWxInfo();
        $ptStyle = dict::getDict('ptStyle', 'ghs');
        if (getenv('YII_ENV') == 'production') {
            $appId = 'wxcf32b3f0684c2433';
        } else {
            $appId = 'wx21b7c3ef12082099';
        }
        $data = [
            'appid' => $appId,
        ];

        //查询小程序是否已开通发货信息管理服务
        $res = shippingUtil::isTradeManage($merchant, $data, $ptStyle);
        echo '<pre>';
        print_r($res);

        //查询小程序是否已完成交易结算管理确认
        $ret = shippingUtil::isTradeManageConfirmComplete($merchant, $data, $ptStyle);
        echo '<pre>';
        print_r($ret);

        $r = expressUtil::getAllDelivery($merchant, $ptStyle);
        print_r($r);

    }

    public function actionIn()
    {
        $searchTime = 'custom';
        $startTime = '2024-05-04';
        $endTime = '2024-05-04';
        $mainId = 23390;
        $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
        $start = $period['startTime'];
        $end = $period['endTime'];
        $where['time'] = ['between', [$start, $end]];

        $currentStartDate = date('Y-m-d', strtotime($start));
        $currentEndDate = date('Y-m-d', strtotime($end));
        $currentStartTime = $currentStartDate . ' 00:00:00';
        $currentEndTime = $currentEndDate . ' 23:59:59';

        $totalAmount = 0;
        $itemTotalAmount = 0;

        $where = ['mainId' => $mainId, 'status' => ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]]];
        $where['payTime'] = ['between', [$currentStartTime, $currentEndTime]];
        $ghsOrderList = OrderClass::getAllByCondition($where, null, '*');
        if (!empty($ghsOrderList)) {
            foreach ($ghsOrderList as $ghsKey => $ghsOrder) {
                $book = $ghsOrder['book'] ?? 0;
                $status = $ghsOrder['status'] ?? 0;
                $orderSn = $ghsOrder['orderSn'] ?? '';
                $actPrice = $ghsOrder['actPrice'] ?? 0;
                $discountAmount = $ghsOrder['discountAmount'] ?? 0;
                $labourCost = $ghsOrder['labourCost'] ?? 0;
                $tkPrice = $ghsOrder['tkPrice'] ?? 0;
                if ($book == 1 && $status == 2) {
                    //预订单待发货的不算收入
                    continue;
                }
                if ($status == 0 || $status == 5) {
                    continue;
                }
                $totalAmount = bcadd($totalAmount, $actPrice, 2);
                $orderItemList = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*', null, true);
                $currentAmount = 0;
                if (!empty($orderItemList)) {
                    foreach ($orderItemList as $orderItem) {
                        $refundNum = $orderItem->refundNum ?? 0;
                        $name = $orderItem->name ?? '';
                        $productId = $orderItem->productId ?? 0;
                        $num = $orderItem->xhNum ?? 0;
                        $xhUnitPrice = $orderItem->xhUnitPrice ?? 0;


                        $remainNum = bcsub($num, $refundNum);
                        $classId = $orderItem->classId ?? 0;
                        $className = $classList[$classId]['name'] ?? '已删除';
                        $amount = bcmul($remainNum, $xhUnitPrice, 2);

                        $currentAmount = bcadd($currentAmount, $amount, 2);

                        $arr[$classId]['className'] = $className;
                        $arr[$classId]['classId'] = $classId;
                        if (isset($arr[$classId]['income'])) {
                            $arr[$classId]['income'] = bcadd($amount, $arr[$classId]['income'], 2);
                        } else {
                            $arr[$classId]['expend'] = 0;
                            $arr[$classId]['income'] = $amount;
                        }
                    }
                    if (floatval($currentAmount) != floatval($actPrice) && $discountAmount <= 0 && $labourCost <= 0 && $tkPrice <= 0) {
                        echo $orderSn . ' ' . $currentAmount . ' ' . $actPrice . ' ' . $discountAmount . ' ' . $labourCost . ' ' . $tkPrice;
                        die;
                    }
                    if (floatval($actPrice) != floatval($currentAmount)) {
                        echo $actPrice . ' ' . $currentAmount . ' ' . $orderSn . ' ====' . abs(bcsub($actPrice, $currentAmount, 2)) . "\n";
                    } else {
                        echo $actPrice . ' ' . $currentAmount . ' ' . $orderSn . "\n";
                    }

                    $itemTotalAmount = bcadd($itemTotalAmount, $currentAmount, 2);

                    if ($tkPrice > 0) {
                        $refundList = RefundOrderClass::getAllByCondition(['relateOrderSn' => $orderSn], null, '*', null, true);
                        if (!empty($refundList)) {
                            foreach ($refundList as $refund) {
                                if ($refund->refundType == 1) {
                                    //退货退款前面已经考虑，这里不再处理 OK
                                } else {
                                    //$refund->refundPrice
                                }
                            }
                        }
                    }

                }


            }
        }
        echo $totalAmount . ' ' . $itemTotalAmount;
        die;
    }

    public function actionIp()
    {
        $ip = $_SERVER['SERVER_ADDR'] ?? '';
        echo $ip;
    }

    public function actionHtml()
    {
        $c = new Converter(null, [
            "fmt" => "png",
            "in" => "/tmp/a.html",
            "out" => "/tmp/test.png"
        ]);
        $c->convert();
    }

    //欠款的查询与跟踪 ssh 20240103
    public function actionDebt()
    {
        $customId = 17081;
        $custom = CustomClass::getById($customId, true);
        if (empty($custom)) {
            echo '没有找到客户';
            die;
        }
        $flag = [];
        $changeList = CustomDebtChangeClass::getAllByCondition(['customId' => $customId], null, '*');
        if (!empty($changeList)) {
            foreach ($changeList as $change) {
                $event = $change['evnet'] ?? '';
                $relateId = $change['relateId'] ?? 0;
                $amount = $change['amount'] ?? 0;

                if (strpos($event, '购买花材') >= 0) {
                    $flag['40-' . $relateId] = $amount;
                }
                if (strpos($event, '退款') >= 0) {
                    $flag['33-' . $relateId] = $amount;
                }
                if (strpos($event, '结账') >= 0) {
                    $flag['20-' . $relateId] = $amount;
                }

            }
        }
        print_r($flag);
        $orderList = OrderClass::getAllByCondition(['customId' => $customId, 'debtPrice>' => 0], null, 'id,actPrice,payTime', null);
        $arr = [];
        if (!empty($orderList)) {
            foreach ($orderList as $order) {
                $payTime = $order['payTime'] ?? '';
                $id = $order['id'] ?? 0;
                $arr[$payTime] = $order;
                if (isset($flag['40-' . $id]) == false) {
                    echo '40-' . $id . "订单有问题\n";
                }
            }
        }
        //20
        $clearList = PurchaseClearClass::getAllByCondition(['customId' => $customId, 'status' => 2], null, 'id,actPrice,payTime', null);
        if (!empty($clearList)) {
            foreach ($clearList as $clear) {
                $payTime = $clear['payTime'] ?? '';
                $id = $clear['id'] ?? 0;
                $arr[$payTime] = $clear;
                if (isset($flag['20-' . $id]) == false) {
                    echo '20-' . $id . "结账有问题\n";
                }
            }
        }
        //33
        $refundList = RefundOrderClass::getAllByCondition(['customId' => $customId], null, 'id,refundPrice,updateTime', null);
        if (!empty($refundList)) {
            foreach ($refundList as $refund) {
                $id = $refund['id'] ?? 0;
                $updateTime = $refund['updateTime'] ?? '';
                $arr[$updateTime] = $refund;
                if (isset($flag['33-' . $id]) == false) {
                    echo '33-' . $id . "退款单有问题\n";
                }
            }
        }
        echo "<pre>";
        ksort($arr);
        print_r($arr);
        die;
    }

    //订单退款接口 ssh 20250815
    public function actionRefund()
    {
        $shopId = 13626;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::fail('没有找到所在的门店');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklB2BTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $refundReason = '暂无';
        $refundOrderSn = orderSn::getCgRefundSn();
        $refundPrice = 0;
        if ($refundPrice <= 0) {
            util::fail('请填写金额');
        }
        $refundFee = bcmul($refundPrice, 100);
        $orderSn = 'KD26628409';
        $originTradeNo = '20250815110113130166222385664461';
        //$originLogNo = '66215266025626';
        $aliParams = [
            'refundSn' => $refundOrderSn,
            'orderSn' => $orderSn,
            'refundAmount' => $refundFee,
            'refundReason' => $refundReason,
            'originTradeNo' => $originTradeNo,
            //'originLogNo' => $originLogNo,
        ];
        $response = $laResource->refund($aliParams);
        echo '<pre>';
        print_r($response);
    }

    //订单退款接口（这个有云音响声音会通知商家） ssh 20250815
    public function actionLsTradeRefund()
    {
        util::stop('接口已关闭');
        $shopId = 17117;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店哦');
        }
        $orderSn = 'KD26615540';
        $orderInfo = ClassesOrderClass::getByCondition(['orderSn' => $orderSn], true);
        if (!empty($orderInfo)) {
            util::stop('有订单，不能走这个退款渠道');
        }
        $actPrice = 0;
        if ($actPrice <= 0) {
            util::fail('请填写退款金额');
        }
        $order = ['orderSn' => $orderSn, 'actPrice' => $actPrice];
        $respond = HdRefundClass::onlyRefundAmount($shop, $order);
        echo "<pre>";
        print_r($respond);
        util::stop();
    }

    public function actionApply()
    {
        $id = 2888;
        $shopId = 36524;
        $cg = PurchaseClass::getById($id, true);
        $shop = ShopClass::getById($shopId, true);
        WxMessageClass::hdNewCgOrderInform($shop, $cg);
    }

    public function actionGet()
    {
        ini_set('memory_limit', '2045M');
        set_time_limit(0);

        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';

        $arr = [
            //['name' => '兴义友缘鲜花批发', 'merchantNo' => '8227070539900D5', 'wx' => [700462399, 700461988], 'zfb' => '2088060407151682'],
            //['name' => '平潭满天星鲜花批发', 'merchantNo' => '82239105399050B', 'wx' => [700281483, 700281906], 'zfb' => '2088060350376257'],
            //['name' => '瑞安飘荷鲜花批发', 'merchantNo' => '8223330539907K4', 'wx' => [702289830, 702290333], 'zfb' => '2088060739137125'],
            //['name' => '昆明康多鲜农业', 'merchantNo' => '82273105399069E', 'wx' => [704625998, 704626119], 'zfb' => '2088160160941295'],
            //['name' => '宜宾花房里', 'merchantNo' => '82267105399041L', 'wx' => [702588640, 702570297], 'zfb' => '2088060798606945'],
            //['name' => '普莲花艺', 'merchantNo' => '8223990539902H8', 'wx' => [709291364, 709278546], 'zfb' => '2088160744835387'],
            //['name' => '凯里壹号鲜花工厂', 'merchantNo' => '82271305992000N', 'wx' => [735074420, 735074312], 'zfb' => '2088660471452939'],
            //['name' => '平潭花天下', 'merchantNo' => '8223910599200DU', 'wx' => [742408710, 742408308], 'zfb' => '2088860472568840'],
            //['name' => '徐州贴心鲜花批发', 'merchantNo' => '82230305992005L', 'wx' => [770844003, 770842534], 'zfb' => '2088370485434992'],
            //['name' => '海沧好多花换店', 'merchantNo' => '8223930599200CN', 'wx' => [772684174, 772684211], 'zfb' => '2088370864383343'],
            //['name' => '九江伊朵鲜花批发', 'merchantNo' => '82242405992002A', 'wx' => [774681090, 774681246], 'zfb' => '2088470298005142'],
            //['name' => '眉山花鲜谷', 'merchantNo' => '82266705992003C', 'wx' => [801669421, 801668546], 'zfb' => '2088870521514083'],
            ['name' => '颍上四季花都', 'merchantNo' => '82237205992004C', 'wx' => [802165446, 802165923], 'zfb' => '2088870568169143'],
            //['name' => '徐州云之南鲜花', 'merchantNo' => '82230305992006C', 'wx' => [788161779, 788162410], 'zfb' => '2088670707622207'],
            //['name' => '济南伟伟鲜花批发', 'merchantNo' => '8224510599200EL', 'wx' => [789073494, 789074603], 'zfb' => '2088670850497224'],
            //['name' => '赣州紫荆鲜花批发', 'merchantNo' => '82242805992004J', 'wx' => [790052021, 790051859], 'zfb' => '2088670969143838'],
            ['name' => '东莞惠雅鲜花（莞城店）', 'merchantNo' => '8226020599200GJ', 'wx' => [796953190, 796976959], 'zfb' => '2088770940104912'],
            ['name' => '东莞惠雅鲜花（南城店）', 'merchantNo' => '8226020599200JK', 'wx' => [802315656, 802315755], 'zfb' => '2088870583889365'],
            //['name' => '沈阳市云花鲜花批发-专业化扫码', 'merchantNo' => '8222210599200BT', 'wx' => [796180053], 'zfb' => '2088770820458908'],
            //['name' => '沈阳市云花鲜花批发-聚合收银台', 'merchantNo' => '8222210599200BS', 'wx' => [796157674], 'zfb' => '2088770815918545'],
            //['name' => '日照温暖小筑', 'merchantNo' => '82247705992002F', 'wx' => [781363841, 781362087], 'zfb' => '2088570557754874'],
            //['name' => '昆明建芳基地鲜花直发', 'merchantNo' => '8223970599200AH', 'wx' => [775915046, 775915051], 'zfb' => '2088470558755358'],
            //['name' => '日照月下鲜花批发', 'merchantNo' => '82247705992002D', 'wx' => [759404451, 759404055], 'zfb' => '2088170264295192'],
            //['name' => '陆丰幸运花坊', 'merchantNo' => '82259705992001N', 'wx' => [762636401,762635754 ], 'zfb' => '2088170810827880'],
            //['name' => '阜阳芳棠鲜花批发', 'merchantNo' => '82237205992002Q', 'wx' => [733203298, 733203681], 'zfb' => '2088660084283241'],
            //['name' => '厦门拾花蒲鲜花批发', 'merchantNo' => '8223930599200BH', 'wx' => [732030422, 732025011], 'zfb' => '2088560833972467'],
            //['name' => '肇庆兄弟花业鲜花批发', 'merchantNo' => '8225880599200AN', 'wx' => [731684756, 731684322], 'zfb' => '2088560782624772'],
            //['name' => '肇庆兄弟花业鲜花', 'merchantNo' => '82259305992002N', 'wx' => [730218291, 730219211], 'zfb' => '2088560548315555'],
            //['name' => '威海香石竹鲜花批发', 'merchantNo' => '82246505992000U', 'wx' => [729504083, 729504414], 'zfb' => '2088560407402224'],
            //['name' => '泉州捷芳鲜花批发', 'merchantNo' => '82239705992008W', 'wx' => [728826707, 728825779], 'zfb' => '2088560237460207'],
            //['name' => '广州永康花卉', 'merchantNo' => '8225810599200Y3', 'wx' => [727926337, 727926569], 'zfb' => '2088560032189462'],
            //['name' => '滨州如意花行', 'merchantNo' => '82246605992001M', 'wx' => [727308107, 727308964], 'zfb' => '2088460923731135'],
            //['name' => '惠州三志冷链物流', 'merchantNo' => '82259505992006G', 'wx' => [724937969, 724937772], 'zfb' => '2088460474825075'],
            //['name' => '昆明盛丰鲜花', 'merchantNo' => '8227310599200NB', 'wx' => [723743381, 723741476], 'zfb' => '2088460361380780'],
            //['name' => '通化合作共赢鲜花批发', 'merchantNo' => '82224505992000F', 'wx' => [722633111, 722633200], 'zfb' => '2088460240538741'],
            //['name' => '保宝大鱼鲜花批发', 'merchantNo' => '82213405992003N', 'wx' => [722176713, 722177612], 'zfb' => '2088460184251890'],
            //['name' => '扬州蝶歌鲜花批发', 'merchantNo' => '82231205992002J', 'wx' => [720348651, 720340811], 'zfb' => '2088360895948941'],
            //['name' => '广州海翔', 'merchantNo' => '8225810599200X2', 'wx' => [718750241, 718749687], 'zfb' => '2088360610239679'],
            //['name' => '张家口小武鲜花批发', 'merchantNo' => '82213805992003C', 'wx' => [718870355, 718869728], 'zfb' => '2088360640586325'],
            //['name' => '昆明集花舍', 'merchantNo' => '8227310599200MT', 'wx' => [717537251, 717535414], 'zfb' => '2088360233711727'],
            //['name' => '莆田天天鲜花', 'merchantNo' => '82239405992002Y', 'wx' => [716506112, 716505639], 'zfb' => '2088260946172403'],
            //['name' => '广州丽林花卉', 'merchantNo' => '8225810599200WL', 'wx' => [716446742, 716446533], 'zfb' => '2088260930808222'],
            //['name' => '云边鲜花', 'merchantNo' => '8224280539901WN', 'wx' => [714259139, 714259551], 'zfb' => '2088260548077906'],
            //['name' => '昆明旭海花卉', 'merchantNo' => '8227310539906E6', 'wx' => [713302803, 713297761], 'zfb' => '2088260404231017'],
            //['name' => '小齐鲜花', 'merchantNo' => '8223330539907VC', 'wx' => [713310834, 713310425], 'zfb' => '2088260401286023'],
            //['name' => '南粤鲜花', 'merchantNo' => '822581053990EXM', 'wx' => [712157088, 712156995], 'zfb' => '2088260262478670'],
            //['name' => '漳州芊朵鲜花批发', 'merchantNo' => '8223930539904QB', 'wx' => [710546236, 710546515], 'zfb' => '2088160997750356'],
            //['name' => '普莲花艺菊花', 'merchantNo' => '8223990539902HH', 'wx' => [710176042, 710176534], 'zfb' => '2088160942506715'],
            //['name' => '珠海天天鲜花', 'merchantNo' => '8225850539901HD', 'wx' => [700245931, 700245512], 'zfb' => '2088060333130498'],
            //['name' => '昆明花公子', 'merchantNo' => '82273105399063S', 'wx' => [695125651, 695125138], 'zfb' => '2088950525165619'],
            //['name' => '拉萨锦程鲜花批发', 'merchantNo' => '82277105399006C', 'wx' => [700769942, 700769684], 'zfb' => '2088060467437515'],
            //['name' => '曹景农业', 'merchantNo' => '82273105399066F', 'wx' => [700606738, 700607227], 'zfb' => '2088060440996637'],
            //['name' => '长春花路鲜花批发', 'merchantNo' => '8222410539902H0', 'wx' => [693914035, 693914448], 'zfb' => '2088950439662839'],
            //['name' => '花农鲜花批发', 'merchantNo' => '8223770539900G5', 'wx' => [692272589, 692273256], 'zfb' => '2088950310047593'],
            //['name' => '济南青云花卉', 'merchantNo' => '8224510539905L7', 'wx' => [687204114, 687202978], 'zfb' => '2088850832792981'],
            //['name' => '拉萨锦彩鲜花批发', 'merchantNo' => '82277105399005L', 'wx' => [683019997, 683013077], 'zfb' => '2088850186898461'],
            //['name' => '漳州美阁', 'merchantNo' => '8223990539902DD', 'wx' => [682826666, 682826884], 'zfb' => '2088850141413061'],
            //['name' => '重庆大金地', 'merchantNo' => '8226900539907SM', 'wx' => [682449297, 682449425], 'zfb' => '2088850044459951'],
            //['name' => '重庆花小满', 'merchantNo' => '8226900539907QZ', 'wx' => [680848742, 680848078], 'zfb' => '2088750658156797'],
            //['name' => '国兰花尚OK', 'merchantNo' => '82239305992006L', 'wx' => [600913569, 600907053], 'zfb' => '2088820709029782'],
            //['name' => '花掌柜OK', 'merchantNo' => '82240505992000P', 'wx' => [600466131, 600465187], 'zfb' => '2088820656569304'],
            //['name' => '纯彩花艺OK', 'merchantNo' => '82239305992006M', 'wx' => [600922790, 600915407], 'zfb' => '2088820710146836'],
            //['name' => '集美天天鲜花OK', 'merchantNo' => '82239305992006P', 'wx' => [601036538, 601036322], 'zfb' => '2088820726763339'],
            //['name' => '丰行花行OK', 'merchantNo' => '82260205992007P', 'wx' => [601053759, 601052157], 'zfb' => '2088820725885465'],
            //['name' => '独家花行OK', 'merchantNo' => '82239305992006Q', 'wx' => [601049483, 601048223], 'zfb' => '2088820725546555'],
            //['name' => '好多花海沧OK', 'merchantNo' => '82239305992006R', 'wx' => [601052177, 601053735], 'zfb' => '2088820725549695'],
            //['name' => '美天鲜花OK', 'merchantNo' => '82259505992003F', 'wx' => [601062064, 601138175], 'zfb' => '2088820729400990'],
            //['name' => '天天陈江店OK', 'merchantNo' => '82259505992003E', 'wx' => [601060616, 601059382], 'zfb' => '2088820725555368'],
            //['name' => '叶上花OK', 'merchantNo' => '82231805992002G', 'wx' => [601062892, 601062589], 'zfb' => '2088820728763546'],
            //['name' => '好又多（小明）OK', 'merchantNo' => '82239305992006S', 'wx' => [601135715, 601067347], 'zfb' => '2088820729698012'],
            //['name' => '我卖花OK', 'merchantNo' => '82227505992000R', 'wx' => [601177139, 601148755], 'zfb' => '2088820746424032'],
            //['name' => '问境OK', 'merchantNo' => '8226900599200KX', 'wx' => [601299388, 601299453], 'zfb' => '2088820787661843'],
            //['name' => '昱成OK', 'merchantNo' => '8226900599200KY', 'wx' => [601312993, 601325844], 'zfb' => '2088820788900240'],
            //['name' => '杭州斗南', 'merchantNo' => '杭州斗南', 'wx' => [601405963, 601405929], 'zfb' => '2088820793601705'],
            //['name' => '杭州斗南(没用)', 'merchantNo' => '8223310599200AD', 'wx' => [601254682, 601250805], 'zfb' => '2088820782666872'],
            //['name' => '珑松花卉长安店', 'merchantNo' => '82260205992007U', 'wx' => [602499045, 602497558], 'zfb' => '2088820959620797'],
            //['name' => '福州花福（个人）', 'merchantNo' => '82239105992007P', 'wx' => [603301197, 603302321], 'zfb' => '2088920058098261'],
            //['name' => '福州花福', 'merchantNo' => '82239105992007N', 'wx' => [602796807, 602774796], 'zfb' => '2088820996010582'],
            //['name' => '昆明新宏源', 'merchantNo' => '82239305992007H', 'wx' => [606098318, 606100317], 'zfb' => '2088920878302843'],
            //['name' => '昆明纯彩', 'merchantNo' => '82239905992003L', 'wx' => [604923629, 604922175], 'zfb' => '2088920533160795'],
            //['name' => '花优田（军兴旺）', 'merchantNo' => '8227310599200GX', 'wx' => [605191281, 605190492], 'zfb' => '2088920588715249'],
            //['name' => '肇庆兄弟鲜花', 'merchantNo' => '82259305992001V', 'wx' => [628299301, 628297384], 'zfb' => '2088930936937722'],
            //['name' => '郑州唯一鲜花', 'merchantNo' => '8224910599200NB', 'wx' => [624877731, 624877902], 'zfb' => '2088830970964611'],
            //['name' => '昆明期待鲜花', 'merchantNo' => '8227310599200J6', 'wx' => [615582300, 615582180], 'zfb' => '2088530113958388'],
            //['name' => '厦门遇见你', 'merchantNo' => '82239305992008D', 'wx' => [614782373, 614783346], 'zfb' => '2088430828233036'],
            //['name' => '淄博花超鲜花批发', 'merchantNo' => '82245305992001R', 'wx' => [614685779, 614682986], 'zfb' => '2088430805221810'],
            //['name' => '广州国恋', 'merchantNo' => '8225810599200Q7', 'wx' => [612321716, 612320978], 'zfb' => '2088330479975012'],
            //['name' => '欣研鲜花', 'merchantNo' => '82260305992001Y', 'wx' => [612181234, 612181615], 'zfb' => '2088330365608286'],
            //['name' => '村长冷链', 'merchantNo' => '82260205992008G', 'wx' => [612168406, 612168000], 'zfb' => '2088330360870932'],
            //['name' => '惠州惠雅鲜花批发', 'merchantNo' => '82259505992003S', 'wx' => [611676975, 611677314], 'zfb' => '2088330136601427'],
            //['name' => '杭州斗南鲜花', 'merchantNo' => '8223310599200AR', 'wx' => [608955814, 608955082], 'zfb' => '2088130449323603'],
            //['name' => '营口简约花卉', 'merchantNo' => '8227310599200HJ', 'wx' => [608439898, 608440994], 'zfb' => '2088130112725929'],
            //['name' => '惠雅鲜花惠州店', 'merchantNo' => '82260205992007Z', 'wx' => [608406948, 608403207], 'zfb' => '2088130098167302'],
            //['name' => '云南珑松花卉珠海店', 'merchantNo' => '82258505992002U', 'wx' => [608062727, 608056474], 'zfb' => '2088030873238576'],
            //['name' => '昆明鹏诚花卉', 'merchantNo' => '8227310599200JK', 'wx' => [630710385, 630711403], 'zfb' => '2088040532857091'],
            //['name' => '云南昆明鲜花导航', 'merchantNo' => '8227310599200K7', 'wx' => [644628542, 644625621], 'zfb' => '2088440522565852'],
            //['name' => '兄弟花业', 'merchantNo' => '82260205992009C', 'wx' => [644547729, 644547591], 'zfb' => '2088440499878526'],
            //['name' => '花小苪', 'merchantNo' => '8227310599200K5', 'wx' => [644457809, 644457051], 'zfb' => '2088440462746403'],
            //['name' => '昆明君花阁', 'merchantNo' => '82239905992004Z', 'wx' => [644889761, 644889492], 'zfb' => '2088440579676361'],
            //['name' => '天雨花卉', 'merchantNo' => '82270705992000V', 'wx' => [644883152, 644883508], 'zfb' => '2088440575173671'],
            //['name' => '惠雅物流广州线', 'merchantNo' => '82259505992004N', 'wx' => [646083092, 646078226], 'zfb' => '2088440854131130'],
            //['name' => '小向花卉', 'merchantNo' => '8227310599200K8', 'wx' => [644771350, 644769766], 'zfb' => '2088440549798194'],
            //['name' => '小蔡鲜花批发', 'merchantNo' => '8223050599200BF', 'wx' => [644014296, 643948823], 'zfb' => '2088440255505707'],
            //['name' => '花千禧鲜花批发', 'merchantNo' => '8224510599200B2', 'wx' => [651543674, 651544159], 'zfb' => '2088640601421088'],
            //['name' => '九江云朵鲜花', 'merchantNo' => '82242405992001G', 'wx' => [653862657, 653862178], 'zfb' => '2088740712634499'],
            //['name' => '阿魏鲜花批发', 'merchantNo' => '82237405992001D', 'wx' => [655133268, 655133420], 'zfb' => '2088840200937795'],
            //['name' => '木合生花卉', 'merchantNo' => '8227310599200KP', 'wx' => [656152589, 656153824], 'zfb' => '2088840636484902'],
            //['name' => '珑松花卉广州店', 'merchantNo' => '8225810599200T4', 'wx' => [656366815, 656367359], 'zfb' => '2088840687638415'],
            //['name' => '珑松花卉老香洲店', 'merchantNo' => '82258505992003E', 'wx' => [658185273, 658185986], 'zfb' => '2088940386892391'],
            //['name' => '花瀚鲜花供应链', 'merchantNo' => '8227310539905FA', 'wx' => [662010955, 662011741], 'zfb' => '2088150197406980'],
            //['name' => '惠州润涵冷链', 'merchantNo' => '8225950539903PR', 'wx' => [662169374, 662170009], 'zfb' => '2088150247119691'],
            //['name' => '晋江大自然', 'merchantNo' => '82239705399059B', 'wx' => [667550571, 667550712], 'zfb' => '2088350427115891'],
            //['name' => '漳州世纪花都', 'merchantNo' => '82239905399029K', 'wx' => [667664263, 667664414], 'zfb' => '2088350452589810'],
            //['name' => '勇记花卉', 'merchantNo' => '822581053990C8L', 'wx' => [669207179, 669206707], 'zfb' => '2088450081165255'],
            //['name' => '昆明云花卉', 'merchantNo' => '8227310539905MX', 'wx' => [669707865, 669707085], 'zfb' => '2088450254255811'],
            //['name' => '重庆皓宇花卉', 'merchantNo' => '8226900539907DQ', 'wx' => [671813161, 671812388], 'zfb' => '2088450973467274'],
            //['name' => '花好鲜安海店', 'merchantNo' => '8223970539905DL', 'wx' => [673613561, 673614705], 'zfb' => '2088550536124360'],
            //['name' => '绵阳斗南鲜花批发', 'merchantNo' => '8226590539900LC', 'wx' => [673714302, 673713951], 'zfb' => '2088550559541331'],
            //['name' => '厦门艺七', 'merchantNo' => '82239305399049D', 'wx' => [677648289, 677648886], 'zfb' => '2088650829805140'],
            //['name' => '珠海花果山见面', 'merchantNo' => '8225850539901E5', 'wx' => [674772111, 674727608], 'zfb' => '2088550993954513'],
            //['name' => '昆明镜中花卉', 'merchantNo' => '8227310539905TK', 'wx' => [676577816, 676577537], 'zfb' => '2088650588974260'],
            //['name' => '福州花福', 'merchantNo' => '8223910539904QX', 'wx' => [676794503, 676796025], 'zfb' => '2088650642029974'],
            //['name' => '昆明徐记花卉', 'merchantNo' => '8227310539905G1', 'wx' => [663329224, 663329205], 'zfb' => '2088150735316911'],
            //['name' => '昆明云中花花卉', 'merchantNo' => '8227310539905JB', 'wx' => [665786989, 665787567], 'zfb' => '2088250764618395'],
            //['name' => '石狮花好鲜', 'merchantNo' => '82239705399058M', 'wx' => [667184997, 667185665], 'zfb' => '2088350227756195'],
            //['name' => '遵义镜中花卉', 'merchantNo' => '82270305399014K', 'wx' => [663285723, 663285152], 'zfb' => '2088150699238043'],
            //['name' => '悠悠鲜花直营', 'merchantNo' => '82246605399018S', 'wx' => [662942118, 662941578], 'zfb' => '2088150532490953'],
            //['name' => '扬州花儿很仙', 'merchantNo' => '82231205992001R', 'wx' => [641935836, 641934793], 'zfb' => '2088340698052621'],
            //['name' => '福清花好鲜', 'merchantNo' => '82239105992008S', 'wx' => [639783869, 639783652], 'zfb' => '2088340156624896'],
            //['name' => '北京花篮子', 'merchantNo' => '8221000599200QM', 'wx' => [639324663, 639322821], 'zfb' => '2088240926611870'],
            //['name' => '云南云漫梦金鹏', 'merchantNo' => '8227310599200K0', 'wx' => [638438213, 638437418], 'zfb' => '2088240671151089'],
            //['name' => '心悦花艺馆', 'merchantNo' => '82247305992002L', 'wx' => [632850138, 632849309], 'zfb' => '2088140048248384'],
            //['name' => '买手很忙', 'merchantNo' => '8227310599200GJ', 'wx' => [601597167, 601595526], 'zfb' => '2088820818930267'],
            //['name' => '七彩花都', 'merchantNo' => '8227310599200GF', 'wx' => [601176481, 601148503], 'zfb' => '2088820748594478'],
            //['name' => '十年', 'merchantNo' => '82252305992001U', 'wx' => [601285154, 601261795], 'zfb' => '2088820782171763'],
            //['name' => '都市花季OK', 'merchantNo' => '82239305992006U', 'wx' => [601174342, 601147649], 'zfb' => '2088820748507346'],
            //['name' => '花样年华OK', 'merchantNo' => '82260205992007Q', 'wx' => [601134352, 601091710], 'zfb' => '2088820735043444'],
            //['name' => '精茂城OK', 'merchantNo' => '8225840599200TF', 'wx' => [601173752, 601143352], 'zfb' => '2088820746800005'],
            //['name' => '莱漫OK', 'merchantNo' => '82239305992007A', 'wx' => [601288494, 601288166], 'zfb' => '2088820783686611'],
            //['name' => '莱漫(没用)', 'merchantNo' => '82239305992006T', 'wx' => [601134065, 601125595], 'zfb' => '2088820743859918'],
            //['name' => '福州我要花OK', 'merchantNo' => '82239105992007J', 'wx' => [601134030, 601128111], 'zfb' => '2088820745276973'],
            //['name' => '泉城OK', 'merchantNo' => '82239705992004F', 'wx' => [601273270, 601272854], 'zfb' => '2088820784658561'],
            //['name' => '泉城(没用)', 'merchantNo' => '82239705992004E', 'wx' => [601133056, 601133821], 'zfb' => '2088820746111323'],
            //['name' => '美丽花行OK', 'merchantNo' => '82239305992006V', 'wx' => [601155249, 601149712], 'zfb' => '2088820747673312'],
            //['name' => '三叶OK', 'merchantNo' => '82236805992001Y', 'wx' => [601152233, 601151024], 'zfb' => '2088820747556725'],
            //['name' => '花大苪OK', 'merchantNo' => '8227310599200GG', 'wx' => [601174221, 601165136], 'zfb' => '2088820751181377'],
            //['name' => '十堰天天鲜花OK', 'merchantNo' => '82252305992001S', 'wx' => [601171131, 601170642], 'zfb' => '2088820750844626'],
            //['name' => '珑松花卉OK', 'merchantNo' => '82260205992007S', 'wx' => [601176093, 601174262], 'zfb' => '2088820754742492'],
            //['name' => '惠雅鲜花OK', 'merchantNo' => '82260205992007R', 'wx' => [601173390, 601174002], 'zfb' => '2088820753174540'],
            //['name' => '锦绣花卉OK', 'merchantNo' => '82252305992001T', 'wx' => [601176719, 601176660], 'zfb' => '2088820754751663'],
            //['name' => '祥瑞鲜花同安店OK', 'merchantNo' => '82239305992006W', 'wx' => [601178350, 601177795], 'zfb' => '2088820755715024'],
            //['name' => '祥瑞鲜花翔安店OK', 'merchantNo' => '82239305992006X', 'wx' => [601178260, 601178199], 'zfb' => '2088820754481553'],
            //['name' => '初见花季OK', 'merchantNo' => '82239305992006Y', 'wx' => [601178998, 601179605], 'zfb' => '2088820757223312'],
            //['name' => '荣发鲜花OK', 'merchantNo' => '82242705992000D', 'wx' => [601179681, 601179180], 'zfb' => '2088820756926593'],
            //['name' => '花千朵（多多）OK', 'merchantNo' => '82239305992006Z', 'wx' => [601223474, 601208096], 'zfb' => '2088820766783276'],
            //['name' => '花悠星OK', 'merchantNo' => '8225810599200NH', 'wx' => [601228194, 601227691], 'zfb' => '2088820774587446'],
            //['name' => '花悠星(没用)', 'merchantNo' => '8225810599200NG', 'wx' => [601223630, 601210952], 'zfb' => '2088820767072874'],
            //['name' => '源花汇OK', 'merchantNo' => '82222105992004A', 'wx' => [601221944, 601214269], 'zfb' => '2088820770594246'],
            //['name' => '源花汇2(没用)', 'merchantNo' => '8227310599200GD', 'wx' => [601136305, 601067016], 'zfb' => '2088820729832744'],
        ];
        if (empty($arr)) {
            echo '没有需要认证门店';
            return false;
        }
        $new = [];
        foreach ($arr as $item) {
            $wx = $item['wx'];
            $zfb = $item['zfb'];
            $merchantNo = $item['merchantNo'];
            $name = $item['name'] . ' ' . $merchantNo;
            $group = [];
            foreach ($wx as $oneWx) {
                $params = [
                    'appid' => 'OP00002119',
                    'serial_no' => '018b08cfddbd',
                    'merchant_no' => $merchantNo,
                    'term_no' => 'C6337694',
                    'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
                    'lklCertificatePath' => $lklCertificatePath,
                ];
                $data = [
                    'subMerchantId' => $oneWx,
                    'tradeMode' => 'WECHAT',
                ];
                $laResource = new Lakala($params);
                $response = $laResource->openStateQuery($data);
                $statusName = '出错了';
                if ($response['retCode'] == '000000') {
                    $checkResult = $response['respData']['checkResult'] ?? '';
                    $statusName = '未认证';
                    if ($checkResult == 'AUTHORIZE_STATE_AUTHORIZED') {
                        $statusName = '已认证';
                    }
                }
                $group[] = '微信 ' . $oneWx . ' ' . $statusName;
            }

            $params = [
                'appid' => 'OP00002119',
                'serial_no' => '018b08cfddbd',
                'merchant_no' => $merchantNo,
                'term_no' => 'C6337694',
                'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
                'lklCertificatePath' => $lklCertificatePath,
            ];
            $data = [
                'subMerchantId' => $zfb,
                'tradeMode' => 'ALIPAY',
            ];
            $laResource = new Lakala($params);
            $response = $laResource->openStateQuery($data);
            $statusName = '出错了';
            if ($response['retCode'] == '000000') {
                $checkResult = $response['respData']['checkResult'] ?? '';
                $statusName = '未认证';
                if ($checkResult == 'AUTHORIZED') {
                    $statusName = '已认证';
                }
            }
            $group[] = '支付宝 ' . $zfb . ' ' . $statusName;
            $new[] = ['name' => $name, 'status' => $group];
        }
        if (!empty($new)) {
            foreach ($new as $info) {
                echo "<table style='font-size:40px;margin-bottom:10px;border-top: 2px solid black;padding-top:12px;padding-bottom: 12px;'>";
                echo "<tr><td>{$info['name']}</td></tr>";
                if (!empty($info['status'])) {
                    foreach ($info['status'] as $item) {
                        echo "<tr><td>{$item}</td></tr>";
                    }
                }
                echo "</table>";
            }
        }
    }

    public function actionRefundQuery()
    {
        $shopId = 520;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店16');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);

        $orderSn = '20231201110113131266165492618754';
        $data = [
            'orderSn' => $orderSn,
        ];
        $response = $laResource->refundQuery($data);
        echo "<pre>";
        print_r($response);
    }

    public function actionBalanceQuery()
    {
        $shopId = 1212;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店17');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $response = $laResource->accountBalanceQuery();
        echo "<pre>";
        print_r($response);
    }

    //测试环境查线上数据 ssh 20231230
    public function actionCsQuery()
    {
//        $shopId = 1527;
//        $shop = ShopClass::getById($shopId, true);
//        if (empty($shop)) {
//            util::stop('没有找到门店18');
//        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            //'merchant_no' => $shop->lklSjNo,
            'merchant_no' => '82222105992004A',
            //'term_no' => $shop->lklScanTermNo,
            'term_no' => 'H3656802',
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            //'orderSn' => 'KD26452235',
            'tradeNo' => '20231230110113130266215700775011',
        ];
        $response = $laResource->query($queryParams, 1);
        echo "<pre>";
        print_r($response);
    }

    public function actionQuery()
    {
        $shopId = 726;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店19');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            'orderSn' => 'KD26481486',
            //'tradeNo' => '20231230110113130266215700775011',
        ];
        $response = $laResource->query($queryParams, 0);
        echo "<pre>";
        print_r($response);
    }

    public function actionClearQuery()
    {
        $shopId = 7831;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店20');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            'orderSn' => 'CL28847484',
            //'tradeNo' => '66217906316756',
        ];
        $response = $laResource->query($queryParams, 0);
        echo "<pre>";
        print_r($response);
    }

    //零售订单查询 ssh 20231031
    public function actionLsTradeQuery()
    {
        $shopId = 13626;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店21');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            'orderSn' => 'KD26628409',
            //'tradeNo' => '66222010853306',
        ];
        $response = $laResource->query($queryParams, 0);
        print_r($response);
        util::stop();
        if (isset($response['code']) && $response['code'] == 'BBS00000') {

            $connection = Yii::$app->db;
            $transaction = $connection->beginTransaction();
            try {

                $postData = $response['resp_data'] ?? [];
                $orderSn = $postData['out_trade_no'] ?? '';
                $total_amount = $postData['total_amount'] ?? 0;
                $account_type = $postData['account_type'] ?? '';
                if (empty($account_type)) {
                    noticeUtil::push('支付回调失败了，没有找到钱包类型，请注意，orderSn:' . $orderSn, '15280215347');
                    util::end();
                }
                $totalFee = $total_amount / 100;
                $transactionId = $postData['trade_no'] ?? 0;
                $capitalType = dict::getDict('capitalType', 'xhOrder', 'id');

                $currentPayWay = null;
                if ($account_type == 'WECHAT') {
                    $currentPayWay = dict::getDict('payWay', 'wxPay');
                } elseif ($account_type == 'ALIPAY') {
                    $currentPayWay = dict::getDict('payWay', 'alipay');
                } else {
                    noticeUtil::push('支付回调失败了，没有找到支付类型，orderSn:' . $orderSn, '15280215347');
                    util::end();
                }
                $attach = '';
                payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
                $transaction->commit();
                echo 'OK';
            } catch (\Exception $e) {
                $transaction->rollBack();
                Yii::error("失败原因：" . $e->getMessage());
            }
        }
    }

    //零售订单查询 ssh 20231031
    public function actionClear()
    {
        $shopId = 10649;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店22');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            //'orderSn' => 'KD26461864',
            'tradeNo' => '20231230110113130266215700775011',
        ];
        $response = $laResource->query($queryParams, 1);
        print_r($response);
        util::stop();
        if (isset($response['code']) && $response['code'] == 'BBS00000') {

            $connection = Yii::$app->db;
            $transaction = $connection->beginTransaction();
            try {

                $postData = $response['resp_data'] ?? [];
                $orderSn = $postData['out_trade_no'] ?? '';
                $total_amount = $postData['total_amount'] ?? 0;
                $account_type = $postData['account_type'] ?? '';
                if (empty($account_type)) {
                    noticeUtil::push('支付回调失败了，没有找到钱包类型，请注意，orderSn:' . $orderSn, '15280215347');
                    util::end();
                }
                $totalFee = $total_amount / 100;
                $transactionId = $postData['trade_no'] ?? 0;

                $capitalType = dict::getDict('capitalType', 'hdPurchaseClear', 'id');

                $currentPayWay = null;
                if ($account_type == 'WECHAT') {
                    $currentPayWay = dict::getDict('payWay', 'wxPay');
                } elseif ($account_type == 'ALIPAY') {
                    $currentPayWay = dict::getDict('payWay', 'alipay');
                } else {
                    noticeUtil::push('支付回调失败了，没有找到支付类型，orderSn:' . $orderSn, '15280215347');
                    util::end();
                }
                $attach = '';
                payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
                $transaction->commit();
                echo 'OK';
            } catch (\Exception $e) {
                $transaction->rollBack();
                Yii::error("失败原因：" . $e->getMessage());
            }
        }
    }

    //交易查询 ssh 20231021
    public function actionTradeQuery()
    {
        $shopId = 30300;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店，编号677230');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            'orderSn' => 'CG29126449',
            //'tradeNo' => '66221061685504',
        ];
        $response = $laResource->query($queryParams, 0);
        echo "<pre>";
        print_r($response);
        util::stop();
        if (isset($response['code']) && $response['code'] == 'BBS00000') {
            $capitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
            $connection = Yii::$app->db;
            $transaction = $connection->beginTransaction();
            try {

                $account_type = $response['resp_data']['account_type'] ?? 0;
                if (empty($account_type)) {
                    noticeUtil::push('支付回调失败了，没有找到钱包类型，请注意', '15280215347');
                    util::end();
                }
                $currentPayWay = null;
                if ($account_type == 'WECHAT') {
                    $currentPayWay = dict::getDict('payWay', 'wxPay');
                } elseif ($account_type == 'ALIPAY') {
                    $currentPayWay = dict::getDict('payWay', 'alipay');
                } else {
                    noticeUtil::push('支付回调失败了，没有找到支付类型', '15280215347');
                    util::end();
                }

                $attach = '';
                $total_amount = $response['resp_data']['total_amount'] ?? 0;
                $orderSn = $response['resp_data']['out_trade_no'] ?? 0;
                $totalFee = $total_amount / 100;
                $transactionId = $response['resp_data']['trade_no'] ?? 0;
                payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
                $transaction->commit();
                echo 'OK';
            } catch (\Exception $e) {
                $transaction->rollBack();
                Yii::error("失败原因：" . $e->getMessage());
            }
        }
    }

    //充值销账恢复 ssh 20250610
    public function actionRechargeQuery()
    {
        $shopId = 23580;
        $shop = ShopClass::getById($shopId, true);
        if (empty($shop)) {
            util::stop('没有找到门店，编号677230');
        }
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => $shop->lklSjNo,
            'term_no' => $shop->lklScanTermNo,
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $queryParams = [
            'orderSn' => 'CRS55742',
            //'tradeNo' => '66221061685504',
        ];
        $response = $laResource->query($queryParams, 0);
        echo "<pre>";
        print_r($response);
        util::stop();
        if (isset($response['code']) && $response['code'] == 'BBS00000') {
            $capitalType = dict::getDict('capitalType', 'customRechargeToGhs', 'id');
            $connection = Yii::$app->db;
            $transaction = $connection->beginTransaction();
            try {

                $account_type = $response['resp_data']['account_type'] ?? 0;
                if (empty($account_type)) {
                    noticeUtil::push('支付回调失败了，没有找到钱包类型，请注意', '15280215347');
                    util::end();
                }
                $currentPayWay = null;
                if ($account_type == 'WECHAT') {
                    $currentPayWay = dict::getDict('payWay', 'wxPay');
                } elseif ($account_type == 'ALIPAY') {
                    $currentPayWay = dict::getDict('payWay', 'alipay');
                } else {
                    noticeUtil::push('支付回调失败了，没有找到支付类型', '15280215347');
                    util::end();
                }

                $attach = '';
                $total_amount = $response['resp_data']['total_amount'] ?? 0;
                $orderSn = $response['resp_data']['out_trade_no'] ?? 0;
                $totalFee = $total_amount / 100;
                $transactionId = $response['resp_data']['trade_no'] ?? 0;
                payUtil::thirdPay($currentPayWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);
                $transaction->commit();
                echo 'OK';
            } catch (\Exception $e) {
                $transaction->rollBack();
                Yii::error("失败原因：" . $e->getMessage());
            }
        }
    }


    public function actionAliRun2()
    {
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => '82240505992000N',
            'term_no' => 'C6337694',
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $outTradeNo = orderSn::getPurchaseSn();
        $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback";
        $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
        $aliParams = [
            'orderSn' => $outTradeNo,
            'amount' => 0.16,
            'capitalType' => $currentCapitalType,
            'notifyUrl' => $notifyUrl,
        ];
        $laResource = new Lakala($params);
        $response = $laResource->driveAliPay($aliParams);
        if ($response && isset($response['cmdRetCode']) && $response['cmdRetCode'] == 'GLOBAL_SUCCESS') {
            echo '<pre>';
            echo "下单成功<br/>";
            print_r($response);
        } else {
            echo '<pre>';
            echo "下单失败<br/>";
            print_r($response);
        }
    }

    public function actionAliRun3()
    {
        $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem';
        $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer';
        $params = [
            'appid' => 'OP00002119',
            'serial_no' => '018b08cfddbd',
            'merchant_no' => '82240505992000N',
            'term_no' => 'C6337694',
            'merchantPrivateKeyPath' => $merchantPrivateKeyPath,
            'lklCertificatePath' => $lklCertificatePath,
        ];
        $laResource = new Lakala($params);
        $outTradeNo = orderSn::getPurchaseSn();
        $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback";
        $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id');
        $wxParams = [
            'orderSn' => $outTradeNo,
            'amount' => 0.16,
            'capitalType' => $currentCapitalType,
            'notifyUrl' => $notifyUrl,
        ];
        $response = $laResource->driveWxPay($wxParams);
        if ($response && isset($response['cmdRetCode']) && $response['cmdRetCode'] == 'GLOBAL_SUCCESS') {
            echo '<pre>';
            echo "下单成功<br/>";
            print_r($response);
        } else {
            echo '<pre>';
            echo "下单失败<br/>";
            print_r($response);
        }
    }

    //dada 城市code
    public function actionDadaCityCode()
    {
        $res = dada::getCityCode(0);
        util::success($res);
    }

    //理由
    public function actionDadaReasons()
    {
        $res = dada::getCancelReason(0);
        util::success($res);
    }

    //达达 ：下单
    public function actionDadaAddOrder()
    {
        $orderSn = 'XSD_CS26316851';
        $orderInfo = OrderClass::getByOrderSn($orderSn);
        $res = DadaExpressServices::addOrder($orderInfo);
        util::success($res);
    }

    //重发快递
    public function actionDadaReAdd()
    {
        $orderSn = 'XSD_CS26316851';
        $orderInfo = OrderClass::getByOrderSn($orderSn);
        $res = DadaExpressServices::reAddOrder($orderInfo);
        util::success($res);
    }

    //达达状态查询
    public function actionDadaOrderStatus()
    {
        $orderSn = 'XSD_CS26316851';
        $res = DadaExpressServices::statusOrder($orderSn);
        util::success($res);
    }

    //达达取消下单
    public function actionDadaCancelOrder()
    {
        $orderSn = 'XSD_CS26316851';
        $res = DadaExpressServices::cancelOrder($orderSn, 1);
        util::success($res);
    }

    //获取已支持的配送公司列表接口
    public function actionGetAllDelivery()
    {
        $data = MiniExpressService::getAllImmeDelivery();
        util::success($data);
    }

    //即时配送
    /*
     * Array
(
    [resultcode] => 0
    [resultmsg] => OK
    [shop_list] => Array
        (
            [0] => Array
                (
                    [shopid] => 1588714266
                    [delivery_id] => SFTC
                    [audit_result] => 0
                    [create_time] => 1612172838
                    [remark] =>
                    [delivery_name] => 顺丰同城急送
                )

        )
)
     */
    public function actionGetBindAccount()
    {
        $merchant = WxOpenClass::getGhsWxInfo();
        $isOpen = 2;
        $r = miniUtil::getBindAccount($merchant, $isOpen);
        dd($r);
    }


    //下单 (沙箱)

    /**
     * Array
     * (
     * [resultcode] => 0
     * [resultmsg] => ok
     * [fee] => 10
     * [waybill_id] => test_shop_id1612365974_waybillid
     * [order_status] => 101
     * [dispatch_duration] => 300
     * )
     */
    public function actionCreateWaybill()
    {
        $merchant = WxOpenClass::getGhsWxInfo();
        $isOpen = 2;
        $shopId = 'test_shop_id';
        $shopOrderId = 'test_shop_id' . time();
        $appSecret = 'test_app_secrect';
        $data = [
            'shopid' => $shopId,
            'shop_order_id' => $shopOrderId,
            'shop_no' => '1',
            'delivery_sign' => miniUtil::getDeliverySign($shopId, $shopOrderId, $appSecret), //，则delivery_sign=SHA1(shopid + shop_order_id + AppSecret)
            'delivery_id' => "TEST",
            'openid' => 'oGKMp45YLxewOTWEbpMFzWoVqdW0',
            'sender' => [
                'name' => 'test',
                'city' => '厦门市',
                'address' => '思明区',
                'address_detail' => '软件园二期',
                'phone' => '19959271111',
                'lng' => 118.134343,
                'lat' => 24.483566,
                'coordinate_type' => 0,
            ],
            'receiver' => [
                'name' => 'test',
                'city' => '厦门市',
                'address' => '思明区',
                'address_detail' => '软件园二期',
                'phone' => '19959271111',
                'lng' => 118.134343,
                'lat' => 24.493566,
                'coordinate_type' => 0,
            ],
            'cargo' => [
                'goods_value' => 1,
                'goods_weight' => 0.1,
                'cargo_first_class' => '鲜花',
                'cargo_second_class' => '鲜花',
            ],
            'order_info' => [
                'order_type' => 0,
            ],
            'shop' => [
                'wxa_path' => '/shop',
                'img_url' => 'http://www.baidu.com/test.png',
                'goods_name' => 'test',
                'goods_count' => 1,
            ],

        ];

        $r = miniUtil::addOrder($data, $merchant, $isOpen);
        dd($r);

    }

    //获取运单数据

    /**
     * Array
     * (
     * [resultcode] => 0
     * [resultmsg] => ok
     * [order_status] => 101
     * [agent_info] => Array
     * (
     * )
     *
     * [waybill_id] => test_shop_id1612365974_waybillid
     * [rider_name] =>
     * [rider_phone] =>
     * [order_token] => NsXweKCKhSyAEIhAdnX3TYZsVDES0-t-tymHDONG0MpRsF31dQvVxiP_JJvLFaKS-kwXuOG3D0hzKkl7o-gzew
     * )
     */
    public function actionGetOrder()
    {
        $shopId = 'test_shop_id';
        $shopOrderId = 'test_shop_id1612365974';
        $appSecret = 'test_app_secrect';
        $merchant = WxOpenClass::getGhsWxInfo();
        $isOpen = 2;
        $data = [
            'shopid' => $shopId,
            'shop_order_id' => $shopOrderId,
            'shop_no' => '1',
            'delivery_sign' => MiniExpressService::getDeliverySign($shopId, $shopOrderId, $appSecret),
        ];
        $r = miniUtil::getOrder($data, $merchant, $isOpen);
        dd($r);
    }


    //沙盒 更新快递状态
    public function actionMockUpdateOrder()
    {
        $merchant = WxOpenClass::getGhsWxInfo();
        $isOpen = 2;
        /**
         * {
         * "shopid": "test_shop_id",
         * "shop_order_id": "xxxxxxxxxxx",
         * "waybill_id": "xxxxxxxxxxxxx",
         * "action_time": 12345678,
         * "order_status": 101,
         * "action_msg": "",
         * }
         */
        $shopId = 'test_shop_id';
        $shopOrderId = 'test_shop_id1612365974';
        $data = [
            'shop_order_id' => $shopOrderId,
            "shopid" => $shopId,
            "action_time" => time(),
            "order_status" => 302,
            'action_msg' => '状态变更',
        ];
        $r = miniUtil::mockUpdateOrder($data, $merchant, $isOpen);
        dd($r);
    }

    public function actionTest()
    {


    }


    //新增订单
    public function actionAddOrder()
    {
        $dada = Yii::getAlias("@vendor/dada/");
        require_once $dada . 'api/addOrderApi.php';
        require_once $dada . 'client/dadaRequestClient.php';
        require_once $dada . 'client/dadaResponse.php';
        require_once $dada . 'config/config.php';
        require_once $dada . 'model/orderModel.php';

        // isOnline 判断是否是测试环境，会有不同的域名等
        $isOnline = false;
        $sourceId = 1000000;
        // 初始化一个config
        $config = new \Config($sourceId, $isOnline);

        $orderModel = new \OrderModel();
        $orderModel->setShopNo('11047059');
        $orderModel->setOriginId('2018091100000002');
        $orderModel->setCityCode('021');
        $orderModel->setCargoPrice(10);
        $orderModel->setIsPrepay(0);
        $orderModel->setReceiverName('测试达达');
        $orderModel->setReceiverAddress('上海市崇明岛');
        $orderModel->setReceiverLat(31.63);
        $orderModel->setReceiverLng(121.41);
        $orderModel->setReceiverPhone('18588888888');
        $orderModel->setCallback('http://api.b.huaml.com/data/request');

        // api主要有2个参数，一个是url， 一个是业务参数
        $addOrderApi = new \AddOrderApi(json_encode($orderModel));

        $dada_client = new \DadaRequestClient($config, $addOrderApi);
        $resp = $dada_client->makeRequest();
        echo json_encode($resp);
    }

    //订单详情查询
    public function actionOrderQuery()
    {
        $dada = Yii::getAlias("@vendor/dada/");
        require_once $dada . 'api/OrderQueryApi.php';
        require_once $dada . 'client/dadaRequestClient.php';
        require_once $dada . 'client/dadaResponse.php';
        require_once $dada . 'config/config.php';
        require_once $dada . 'model/orderModel.php';

        // isOnline 判断是否是测试环境，会有不同的域名等
        $isOnline = false;
        $sourceId = 1000000;
        // 初始化一个config
        $config = new \Config($sourceId, $isOnline);

        $orderModel = new \OrderModel();
        $orderModel->setOrderId('2018091100000002');

        // api主要有2个参数，一个是url， 一个是业务参数
        $addOrderApi = new \OrderQueryApi(json_encode($orderModel));

        $dada_client = new \DadaRequestClient($config, $addOrderApi);
        $resp = $dada_client->makeRequest();
        echo json_encode($resp);
    }

    public function actionFocus()
    {
        $name = '花卉宝';
        if (getenv('YII_ENV') == 'dev') {
            $name = '花美灵';
        }
        $merchant = MerchantService::getByCondition(['name' => $name]);
        $list = wxUtil::getSubscribeUserList($merchant);
        dd($list);
    }

    //宝贝售出提醒 ssh 2020.1.30
    public function actionInform()
    {
        $merchant = MerchantService::getMerchantById(12362);
        $order = OrderService::getById(214810);
        InformAdminClass::sendComplete($order);
    }

    public function actionNotice()
    {
        if (getenv('YII_ENV') != 'production') {
            $orderId = 524691;
            $order = \bizHd\order\classes\OrderClass::getById($orderId, true);
            $shop = ShopClass::getById(36524, true);
            $customName = $order->customName ?? '';
            $result = '配送方取消';
            WxMessageClass::expressErrorInform($shop, $customName, $orderId, $result);
        }
    }

    //重要有用的方法 ssh 20250717
    public function actionSim()
    {
        //将石少华的号模拟成别人的号进行测试，有多处需要同步修改，关键词 simulate_other ssh 20250717
        $get = Yii::$app->request->get();
        $id = $get['id'] ?? 0;
        $simulateKey = 'simulate_admin_id';
        if ($id == 0) {
            Yii::$app->redis->executeCommand('DEL', [$simulateKey]);
            util::stop('已将石少华账号清空');
        }
        $admin = AdminClass::getById($id, true);
        if (empty($admin)) {
            util::fail('管理员无效');
        }
        $adminName = $admin->name ?? '';
        Yii::$app->redis->executeCommand('SET', [$simulateKey, $id]);
        echo "已将石少华账号设置为：" . $adminName;
    }

}