/** * 通天塔商城购买统计( 单个服按照物品总销售金额倒叙排列) * @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); } }