/**
* 通天塔商城购买统计( 单个服按照物品总销售金额倒叙排列)
* @param unknown_type $startTime 时间戳
* @param unknown_type $endTime 时间戳
* @param unknown_type $serverID
* 返回：物品 ID=0，购买数量=1，购买单价=2，购买人数=3，购买次数=4，消费总额=5，占比=6 ，物品名称=7
*/
private static function dataMentods_towerMallSellingItem($startTime, $endTime, $serverID)
{
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"];
$sql = "SELECT a.*,b.name FROM\r\n \t\t \t\t(SELECT item_id AS item_id, SUM(item_num) AS '购买数量', MAX(price) AS '购买单价', COUNT(DISTINCT user_id) AS '购买人数', \r\n \t\t \t\tCOUNT(id) AS '购买次数', SUM(cost) AS '消费总额', SUM(cost) / (SELECT SUM(cost) FROM t_log_tower_buy WHERE log_time >= '" . $startTime . "' AND log_time <= '" . $endTime . "') AS '占商城所有卖出物品的百分比' \r\n \t\t \t\tFROM red_moon_log.t_log_tower_buy\r\n \t\t \t\tWHERE log_time >= '" . $startTime . "' AND log_time <= '" . $endTime . "'\r\n \t\t \t\tGROUP BY item_id ORDER BY SUM(cost) DESC) AS a LEFT JOIN red_moon_config.t_item_template b ON a.item_id = b.template_id ";
$r = sql_fetch_rowsDyn($sql, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
if (!empty($r)) {
return new DataResult(ResultStateLevel::SUCCESS, NULL, NULL, $r);
} else {
return new DataResult(ResultStateLevel::ERROR, "null data", NULL, NULL);
}
}
/**
* 查询用户信息
* @param unknown_type $startTime 时间戳
* @param unknown_type $endTime 时间戳
* @param unknown_type $serverID
*
*/
public static function dataMentods_searchUserInfo($serverID, $userName, $type)
{
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"];
if ($type == 0) {
$sql = "SELECT id, nick_name, LEVEL, total_online_time,FROM_UNIXTIME(last_online_date), FROM_UNIXTIME(register_date), career, money, vip_id,yuan_bao, bind_yuan_bao, copper,bind_copper FROM sszt_game.t_users WHERE nick_name = '" . $userName . "';";
} else {
if ($type == 1) {
$sql = "SELECT id, nick_name, LEVEL, total_online_time,FROM_UNIXTIME(last_online_date), FROM_UNIXTIME(register_date), career, money, vip_id,yuan_bao, bind_yuan_bao, copper,bind_copper FROM sszt_game.t_users WHERE user_name = '" . $userName . "';";
} else {
$sql = "SELECT id, nick_name, user_name,LEVEL, money FROM sszt_game.t_users WHERE nick_name like '%" . $userName . "%';";
}
}
$r = sql_fetch_rowsDyn($sql, $sql_IP, $sql_user, $sql_pwd, $sql_name, "log_" . $serverID, $sql_port);
if (!empty($r)) {
return new DataResult(ResultStateLevel::SUCCESS, NULL, NULL, $r);
} else {
return new DataResult(ResultStateLevel::ERROR, "null data", NULL, NULL);
}
}
