huahuibao/console/controllers/HdOrderController.php

<?php

namespace console\controllers;

use bizHd\order\classes\OrderClass;
use bizHd\order\models\Order;
use common\components\dict;
use common\components\noticeUtil;
use yii\console\Controller;
use Yii;
use biz\shop\classes\ShopExtClass;
use bizHd\shop\classes\ShopClass;
use bizHd\wx\classes\WxOpenClass;
use common\components\payUtil;
use biz\wx\classes\WxMessageClass;

class HdOrderController extends Controller
{

    //【重要脚本，不能删除】花店订单脚本
    public function actionSelect()
    {
        $query = new \yii\db\Query();
        $query->from(Order::tableName());
        $now = time();
        $current = bcsub($now, 120);
        $time = date("Y-m-d H:i:s", $current);
        $query->where(['status' => 1])->andWhere(['<=', 'addTime', $time]);
        $query->orderBy('deadline ASC');
        foreach ($query->batch() as $batchOrder) {
            foreach ($batchOrder as $order) {
                $connection = Yii::$app->db;
                $transaction = $connection->beginTransaction();
                $id = $order['id'] ?? 0;
                $orderSn = $order['orderSn'] ?? '';
                try {
                    $order = OrderClass::getById($id, true);

                    $orderSn = $order->orderSn ?? '';
                    $totalFee = $order->mainPay ?? 0;
                    $capitalType = dict::getDict('capitalType', 'xhOrder', 'id');

                    //查询微信是否付款成功
                    $payWay = dict::getDict('payWay', 'wxPay');

                    $wx = Yii::getAlias("@vendor/wxPayApi_v3.0.10");
                    require_once($wx . '/lib/WxPay.Api.php');
                    require_once($wx . '/example/WxPay.MicroPay.php');

                    //获取微信商户号等信息
                    $sjExtend = WxOpenClass::getMallWxInfo();

                    $microPay = new \MicroPay();
                    $payReturn = $microPay->query($orderSn, $sjExtend);
                    if ($payReturn["return_code"] == "SUCCESS" && $payReturn["result_code"] == "SUCCESS") {
                        if ($payReturn["trade_state"] == "SUCCESS") {
                            //支付成功
                            $transactionId = $payReturn['transaction_id'] ?? '';
                            $order->onlinePay = dict::getDict('onlinePay', 'yes');
                            $order->save();
                            $attach = '';
                            payUtil::thirdPay($payWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);

                            //打印小票和语音播报
                            $newOrder = OrderClass::getById($id, true);
                            OrderClass::onlinePrint($newOrder);
                            ShopExtClass::hdGatheringReport($newOrder);

                            $shopId = $newOrder->shopId ?? 0;
                            $shop = ShopClass::getById($shopId, true);
                            WxMessageClass::gatheringIncomeInform($shop, $newOrder);

                            noticeUtil::push("查到微信已付款！订单号：{$orderSn}", '15280215347');

                            continue;

                        }
                    }

                    //查询支付宝是否付款成功
                    $payWay = dict::getDict('payWay', 'alipay');

                    $aliF2F = Yii::getAlias("@vendor/alipayF2F");
                    require_once($aliF2F . '/f2fpay/model/builder/AlipayTradePayContentBuilder.php');
                    require_once($aliF2F . '/f2fpay/service/AlipayTradeService.php');

                    $aliPId = '2021003122664465';
                    $aliKey = 'MIIEpAIBAAKCAQEAnefrChYa5FUbGTlZNMTDNG531WrVP+TBPw3/hSmycRlBE/1sg9EryM0S3a9OQKQenRdYOoalqkkBuzt41ygJUC5hfNeaiV2OzphIiAyxUaiL1mSftP5B8joBN3HGG2AKbcvKlWcFoeiGY4ZmV/K0t3fqj/uPP6N/pEtnx6X4Ifgz4WGCDKUXKqT1Pyk2rqyIpel2EYk+HtC+9iicfac9kKQQiksDopb7sYosttdk64Dmjp2nMLDSpR+KOZUaqB39MEeHcJGeTzdVrp+Z9wW/NcJzSkSUb9juA0YjmogdbiKltykVHTbP6J0uPyByvzfyyY22QPqwNPiIPbCN6H543QIDAQABAoIBAQCO0+rOecYjSDO1siDVUTC8KTutR+/R1klRjojUWy3zjQNHYJAZ/0ZaX9wzttDSOWETeL0uWwJYL6coQxf/jVA3PWyirqYyn/R/PFFG9iwhj5HE/8lRvjXKMttM2lV2B34HaDE6yC/ZDmkYdsX1wSvjU81QJRuiVXIsGqSpep8hoVvVAn5sjvoC+zBSUaCsYy+7v7IXc6L8f/oLCBXY1r5j/+F/XFU1uFv4j162eRShQs6jQyVqQGLGCy4sSujj+8mpd6uCyJSIGJQHJlaN6cibTYStU/Z9+I/AP/+wQPVx31OwEC5J2xBfSHsezMsHSF7HQnfpQSz5AsOYZ3MOkiglAoGBAPV8sZz3C1gQ6WX5eKZE7PEUSxvAHsP+X6AAA6sWfH4cZq1uGJXgiDpTqN5dOqfNpNAU8gBDNTx4xUZ+cDuDH4WYxqkCe3CDdL97QmXDl2PnNvCKgHl735g3U1v3kCXgUAfBomc/xEIDguiEtsjPpknfjte/HmDE0zrWMOAQkJqXAoGBAKSrD5ryiVREpBmUohsI1g+e7BVR2nAtGYiquXIk2lkk5eQVO1yDh/LOU0jf8kI+UyRv16fANBjXqVc/twG016US5FNPV6fSllevsr0V020QemInO0+yJnTojSAfcayLroQId8Y3nPqVPpKMwvjvV7r50nGCCqXBtQsF4KITRzqrAoGAZBNyYNgBguRaEd1Sxw2gPmOUfvqiUCo6F4MJ+8xN8idn4FnaofcH8ic613PQPqpB/yYaxeqgIEfnvGY9ILXCuvbePfYqFmMwzALWvZ+v7uVKa2M7HstWCrq7O+m/lQFN/ut8ZnUDcBn4WwwHa/PjCYietetO2gpDRmAdSqrWGH8CgYBkwp+r6pkJzW60kHSZIlEKAe7oJMwLNC2ZqQ4MwGwzfBaH+E34kCuR8ZqYzyAIVOa/Nwi5By1Zvi1KzBwJmUUTJ3o7WCOE96EzSrmOZlqXNCwO/36Vh6dshhhE/birIlXJSP0xdzpBQy2ksyli9eGy8cdJ2Y72Wo+TjSclRbKiPQKBgQD1C/CJRQbahz6B3Sc4NOiFUQioM30qDKbDibzUq95u5PtQOx69+/h68tA2nj7ILZOXoh6/KF6LM9WK0QctY0HR5Uy4Uz8YkY/Y0L/LExSkNdpYqbpBc8DdIsKYHoMLNHDwc03tpINRLrmq00sD0907oeuY8/2l6P7XOZSnCvE5Fw==';
                    $aliPublicKey = 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAgEb9zdQQDva63DhksZHPZCDrRe2xvZcTRy9mEiWs/pUhCG0QABkuePUyvqTAKINiCEv2QJmdF8qt3hmTSXuME5bT4vghckSGUTp4CNzsT90Vfjk4wci+bpAqNnpUASDuqZLCzebTuOhxYtGVBqYzhp/CxcC/Mag3ISjUG6jRqyUi15R1e2ruq74sohLGnb4m3nnwRVwnNVAaUcVfV1J0Nb0/9pusrj2t6FCyCkFeWbRDzKhplPQejaET2p5yplwSUpd1gqF+3srIn3erW5uAR6F0Z0NoCMzlo5TEXKWY2XMq97ubueE7Cgp8/c3dh5dkscAT2CCWwRq23aKozp+XMwIDAQAB';

                    $config = array(
                        //签名方式,默认为RSA2(RSA2048)
                        'sign_type' => "RSA2",
                        //支付宝公钥
                        'alipay_public_key' => $aliPublicKey,
                        //商户私钥
                        'merchant_private_key' => $aliKey,
                        //编码格式
                        'charset' => "UTF-8",
                        //支付宝网关
                        'gatewayUrl' => "https://openapi.alipay.com/gateway.do",
                        //应用ID
                        'app_id' => $aliPId,
                        //异步通知地址,只有扫码支付预下单可用
                        'notify_url' => Yii::$app->params['mallHost'] . "/notice/ali-callback",
                        //最大查询重试次数
                        'MaxQueryRetry' => "10",
                        //查询间隔
                        'QueryDuration' => "3"
                    );

                    //构造查询业务请求参数对象
                    $queryContentBuilder = new \AlipayTradeQueryContentBuilder();
                    $queryContentBuilder->setOutTradeNo($orderSn);

                    //初始化类对象，调用queryTradeResult方法获取查询应答
                    $queryResponse = new \AlipayTradeService($config);
                    $queryResult = $queryResponse->queryTradeResult($queryContentBuilder);
                    if ($queryResult->getTradeStatus() == 'SUCCESS') {
                        $respond = $queryResult->getResponse();
                        $transactionId = $respond->trade_no ?? '';

                        $order->onlinePay = dict::getDict('onlinePay', 'yes');
                        $order->save();

                        $attach = '';
                        payUtil::thirdPay($payWay, $capitalType, $orderSn, $totalFee, $attach, $transactionId);

                        //打印小票和语音播报
                        $newOrder = OrderClass::getById($id, true);
                        OrderClass::onlinePrint($newOrder);
                        ShopExtClass::hdGatheringReport($newOrder);

                        $shopId = $newOrder->shopId ?? 0;
                        $shop = ShopClass::getById($shopId, true);
                        WxMessageClass::gatheringIncomeInform($shop, $newOrder);

                        noticeUtil::push("查到支付宝已付款！订单号：{$orderSn}", '15280215347');

                    }

                } catch (\Exception $e) {
                    $transaction->rollBack();
                    $msg = $e->getMessage();
                    noticeUtil::push("查询订单是否付款出错了！订单号：{$orderSn}，错误信息：{$msg}", '15280215347');
                }
            }
        }
    }

}