/**
* 查询单个人货币日志 ----货币类型 1 = 元宝，2=铜钱，3=礼金
* @param unknown_type $moneyType 货币类型 1 = 元宝，2=铜钱，3=礼金
* @param unknown_type $startTime 时间戳
* @param unknown_type $endTime
* @param unknown_type $serverID
* @param unknown_type $account
* @param unknown_type $nickName
* @param unknown_type $offer
* @param unknown_type $pageSize
* 返回 原元宝0，变更数量1，新元宝2，变更原因3，发生时间4
*/
public static function dataMentods_searchPlayerYuanbaoLog($moneyType, $startTime, $endTime, $serverID, $account, $nickName, $offer, $pageSize)
{
if (empty($account) && empty($nickName)) {
return new DataResult(ResultStateLevel::ERROR, "请输入要查询的玩家账号或者主角名！", -1, NULL);
}
if (empty($serverID)) {
return new DataResult(ResultStateLevel::ERROR, "sorry，请刷新后再试！", -1, NULL);
}
$serverDBinfo = self::getServerConnDBLogById($serverID);
if (!$serverDBinfo["ret"]) {
return new DataResult(ResultStateLevel::ERROR, "服务器不存在或被删除！", -1, NULL);
}
$sql_IP = $serverDBinfo["IP"];
$sql_user = $serverDBinfo["user"];
$sql_pwd = $serverDBinfo["pwd"];
$sql_name = $serverDBinfo["name"];
$sql_port = $serverDBinfo["port"];
$sqlWhere = '';
$sql = '';
$sqlCount = '';
if (!empty($account)) {
$sqlWhere = " AND a.user_name ='" . $account . "'";
}
if (!empty($nickName)) {
$sqlWhere = " AND a.nick_name ='" . $nickName . "'";
}
switch ($moneyType) {
case 1:
$sql = "SELECT b.origin_yuan_bao AS '原元宝', b.change_count AS '变更数量', b.new_yuan_bao AS '新元宝', b.change_reason AS '变更原因',FROM_UNIXTIME(b.log_time)";
$sql .= " FROM red_moon_game.t_users a,red_moon_log.t_log_add_del_yuanbao b";
$sql .= " WHERE a.id = b.user_id " . $sqlWhere . " AND b.log_time >='" . $startTime . "' AND b.log_time <= '" . $endTime . "' ORDER BY b.log_time DESC LIMIT {$offer}, {$pageSize}";
$sqlCount = "SELECT COUNT(*) as num FROM red_moon_game.t_users a,red_moon_log.t_log_add_del_yuanbao b WHERE a.id = b.user_id " . $sqlWhere . " AND b.log_time >='" . $startTime . "' AND b.log_time <= '" . $endTime . "' ORDER BY b.log_time";
break;
case 2:
$sql = "SELECT b.origin_copper AS '原铜钱', b.change_count AS '变更数量', b.new_copper AS '新铜钱', b.change_reason AS '变更原因',FROM_UNIXTIME(b.log_time) ";
$sql .= " FROM red_moon_game.t_users a,red_moon_log.t_log_add_del_copper b";
$sql .= " WHERE a.id = b.user_id " . $sqlWhere . " AND b.log_time >='" . $startTime . "' AND b.log_time <= '" . $endTime . "' ORDER BY b.log_time DESC LIMIT {$offer}, {$pageSize}";
$sqlCount = "SELECT COUNT(*) as num FROM red_moon_game.t_users a,red_moon_log.t_log_add_del_copper b WHERE a.id = b.user_id " . $sqlWhere . " AND b.log_time >='" . $startTime . "' AND b.log_time <= '" . $endTime . "' ORDER BY b.log_time";
break;
case 3:
$sql = "SELECT b.origin_li_quan AS '原礼金', b.change_count AS '变更数量', b.new_li_quan AS '新礼金', b.change_reason AS '变更原因',FROM_UNIXTIME(b.log_time) ";
$sql .= " FROM red_moon_game.t_users a,red_moon_log.t_log_add_del_liquan b";
$sql .= " WHERE a.id = b.user_id " . $sqlWhere . " AND b.log_time >='" . $startTime . "' AND b.log_time <= '" . $endTime . "' ORDER BY b.log_time DESC LIMIT {$offer}, {$pageSize}";
$sqlCount = "SELECT COUNT(*) as num FROM red_moon_game.t_users a,red_moon_log.t_log_add_del_liquan b WHERE a.id = b.user_id " . $sqlWhere . " AND b.log_time >='" . $startTime . "' AND b.log_time <= '" . $endTime . "' ORDER BY b.log_time";
break;
default:
return new DataResult(ResultStateLevel::ERROR, "errorType", NULL, NULL);
break;
}
$r = sql_fetch_rowsDyn($sql, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
if (!empty($r)) {
$ary = array();
$define_doneTypeArray = enumerationDefine::Define_GameDoneType_name();
foreach ($r as $k => $v) {
$o = array();
$o[] = $v[4];
if (!isset($define_doneTypeArray[$v[3]])) {
$o[] = "";
} else {
$o[] = $define_doneTypeArray[$v[3]];
}
$o[] = $v[0];
$o[] = $v[1];
$o[] = $v[2];
$ary[] = $o;
}
$count = sql_fetch_one_cellDyn($sqlCount, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "暂无数据", $sql, NULL);
}
}
public static function dataMentods_searchQPayLog($startTime, $serverID, $offer, $pageSize)
{
if (empty($serverID)) {
return new DataResult(ResultStateLevel::ERROR, "sorry，请刷新后再试！", -1, NULL);
}
$serverDBinfo = self::getServerConnDBLogById($serverID);
if (!$serverDBinfo["ret"]) {
return new DataResult(ResultStateLevel::ERROR, "服务器不存在或被删除！", -1, NULL);
}
$sql_IP = $serverDBinfo["IP"];
$sql_user = $serverDBinfo["user"];
$sql_pwd = $serverDBinfo["pwd"];
$sql_name = $serverDBinfo["name"];
$sql_port = $serverDBinfo["port"];
$Year = date('Y', $startTime);
$Month = date('m', $startTime);
$Day = date('d', $startTime);
$sqlWhere = ' year= ' . $Year . ' and month=' . $Month . ' and day=' . $Day;
$sql = '';
$sqlTotal = '';
$sqlCount = '';
$sql = "SELECT pay_amt ,payamt_coins,pubacct_payamt_coins,FROM_UNIXTIME( pay_time),account_name FROM t_user_pay_qq where " . $sqlWhere . " order by id desc LIMIT " . $offer . "," . $pageSize;
$sqlTotal = "SELECT SUM(pay_amt) AS pay_amt,SUM(payamt_coins) AS pay_amt,SUM(pubacct_payamt_coins) AS pay_amt FROM t_user_pay_qq WHERE " . $sqlWhere;
$sqlCount = "SELECT count(1) FROM t_user_pay_qq WHERE " . $sqlWhere;
$r = sql_fetch_rowsDyn($sql, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
if (!empty($r)) {
$ary = array();
$ary[] = $r;
$r1 = sql_fetch_rowsDyn($sqlTotal, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
$ary[] = $r1;
$count = sql_fetch_one_cellDyn($sqlCount, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
return new DataResult(ResultStateLevel::SUCCESS, "1", $count, $ary);
} else {
return new DataResult(ResultStateLevel::ERROR, "暂无数据", $sql, NULL);
}
}
