From d66aafdea1c90bc8229a4bc104cc5629ad683de9 Mon Sep 17 00:00:00 2001
From: hxp <ale99527@vip.qq.com>
Date: 星期五, 15 十一月 2024 12:21:06 +0800
Subject: [PATCH] 10284 【后台】 修复tqxbqy充值金额入库数值类型错误问题;
---
serverinfo/payorderupd.php | 22 ++++++++++++++++++++++
InterfaceConfig.php | 7 ++++---
api/quick/paytqxbqy.php | 2 +-
3 files changed, 27 insertions(+), 4 deletions(-)
diff --git a/InterfaceConfig.php b/InterfaceConfig.php
index 08e1ae7..57b5d08 100644
--- a/InterfaceConfig.php
+++ b/InterfaceConfig.php
@@ -5,7 +5,7 @@
;娓告垙鍚�
GameName=xbqy
;娓犻亾appID鍒楄〃
-ChannelList=test,qkbt6game,qkbt7game,qkbt8game,qkbt9game,qkbt10game,hygame,hyx7game,hygame2,hygameyy,bthygame,bthygameyy,hy005,mlgtgame,hyyngame,hyenglish,hyksgame,sohagame,qkbt52,x7bt5
+ChannelList=test,tqxbqy,qkbt10game,hygame,hyx7game,hygame2,hygameyy,bthygame,bthygameyy,hy005,mlgtgame,hyyngame,hyenglish,hyksgame,sohagame,qkbt52,x7bt5
;鍙娇鐢℅M鍚庡彴鐨勭敤鎴风粍缁囧崟浣嶅垪琛紝瓒呯骇绠$悊鍘熼粯璁ゅ睘浜庣涓�涓粍缁�
OrganizationList=secondworld,sohagame
;閰嶇疆缁勭粐瀵瑰簲鍙鐞嗙殑娓犻亾appID
@@ -124,8 +124,8 @@
Key_hy005_Md5_Key=liwhn0emwotwxqxpdwa9jlsuwkvaqa1c
Key_hy005_Callback_Key=32203045955147303357927711850104
-Key_tqxbqy_Md5_Key=liwhn0emwotwxqxpdwa9jlsuwkvaqa1c
-Key_tqxbqy_Callback_Key=32203045955147303357927711850104
+Key_tqxbqy_Md5_Key=raytitr7xjpld7hstukedccekuhq4pgv
+Key_tqxbqy_Callback_Key=78010593308784252768778951840518
Key_btgotq_Md5_Key=liwhn0emwotwxqxpdwa9jlsuwkvaqa1c
Key_btgotq_Callback_Key=32203045955147303357927711850104
@@ -199,6 +199,7 @@
Key_bthygame='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
Key_bthygameyy='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
Key_hy005='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
+Key_tqxbqy='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
Key_hygtgame='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
Key_hyyngame='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
Key_hyenglish='Y0dGbWVIQlFUREE0Tm1Gbk9DOWhhMjlMSzJrNFpsQjZiMUJQZFRsUVNIcHdkbEI2Y2k5UGJYSjJTejE9'
diff --git a/api/quick/paytqxbqy.php b/api/quick/paytqxbqy.php
index d5e4f46..426d0f1 100644
--- a/api/quick/paytqxbqy.php
+++ b/api/quick/paytqxbqy.php
@@ -89,7 +89,7 @@
$game_order = $xmlData->GetValue("game_order"); //娓告垙鍦ㄨ皟鐢≦uickSDK鍙戣捣鏀粯鏃朵紶閫掔殑娓告垙鏂硅鍗�,杩欓噷浼氬師鏍蜂紶鍥�
$order_no = $xmlData->GetValue("order_no"); //QuickSDK鍞竴璁㈠崟鍙�
$pay_time = $xmlData->GetValue("pay_time"); //鏀粯鏃堕棿 2015-01-01 23:00:00
-$amount = $xmlData->GetValue("amount"); //鎴愪氦閲戦锛屽崟浣嶅厓锛屾父鎴忔渶缁堝彂鏀鹃亾鍏烽噾棰濆簲浠ユ涓哄噯
+$amount = floatval($xmlData->GetValue("amount")); //鎴愪氦閲戦锛屽崟浣嶅厓锛屾父鎴忔渶缁堝彂鏀鹃亾鍏烽噾棰濆簲浠ユ涓哄噯
$status = intval($xmlData->GetValue("status")); //鍏呭�肩姸鎬�:0鎴愬姛, 1澶辫触(涓�1鏃� 搴旇繑鍥濬AILED澶辫触)
$extras_params = $xmlData->GetValue("extras_params"); //鍙负绌�,鍏呭�肩姸鎬佹父鎴忓鎴风璋冪敤SDK鍙戣捣鏀粯鏃跺~鍐欑殑閫忎紶鍙傛暟.娌℃湁鍒欎负绌�
$extras_params = json_decode(urldecode($extras_params), true);
diff --git a/serverinfo/payorderupd.php b/serverinfo/payorderupd.php
new file mode 100644
index 0000000..9e8d681
--- /dev/null
+++ b/serverinfo/payorderupd.php
@@ -0,0 +1,22 @@
+<?php
+include_once "/Common/Logging.php";
+include_once "/db/DBOper.php";
+
+\Logging\CreateLogging("payorderupd.php");
+
+$find = array("Channel" => "tqxbqy");
+\DBOper\Find("PayOrder", $find, $orderArray, array("OrderAmount" => 1, "OriginalAmount" => 1));
+
+$totalCount = count($orderArray);
+\Logging\LogInfo("totalCount:" . $totalCount);
+echo "totalCount:" . $totalCount . "<br/>";
+$okCount = 0;
+foreach ($orderArray as $info) {
+ $OrderAmount = floatval($info["OrderAmount"]);
+ $OriginalAmount = floatval($info["OriginalAmount"]);
+ if (\DBOper\Update("PayOrder", $find, array("OrderAmount" => $OrderAmount, "OriginalAmount" => $OriginalAmount))) {
+ $okCount += 1;
+ }
+}
+\Logging\LogInfo("okCount:" . $okCount);
+echo "okCount:" . $okCount . "<br/>";
--
Gitblit v1.8.0