public function doAction()
{
$userInfo_json = base64_decode($_POST['data']);
$userInfo_array = json_decode($userInfo_json, true);
$expandInfo = Cache_GetLogGM::getInstance()->get_expand_silverlog($userInfo_array);
$data = array();
//$data['data']['all_total'] = $userInfo['all_page'];
unset($userInfo['all_total']);
//$data['data']['list'] = $userInfo;
$data['data']['fields'] = array('modules' => '渠道', 'login_count' => '登陆人数', 'player_count' => '人数', 'times' => '次数', 'flag_count' => '金额', 'ratio' => '金额占比');
$data['data']['list'] = !empty($expandInfo[2]) ? $expandInfo[2] : array();
$tmp_arr = array();
foreach ($data['data']['list'] as $k => $r) {
$tmp_arr = $r;
if (!empty($expandInfo[3])) {
$tmp_arr['ratio'] = sprintf("%.2f", $r['flag_count'] / $expandInfo[3] * 100) . "%";
} else {
$tmp_arr['ratio'] = sprintf("%.2f", 0);
}
$tmp_arr['login_count'] = $expandInfo[0];
$data['data']['list'][$k] = $tmp_arr;
}
$data['data']['total'] = $expandInfo[1];
$data['data']['login_count'] = $expandInfo[0];
$data['status'] = 1;
echo json_encode($data);
}
public function doAction()
{
$online = Cache_GetLogGM::getInstance()->get_online_num();
$data = array();
$data['data'] = $online;
$data['status'] = 1;
echo json_encode($data);
}
public function doAction()
{
$userInfo_json = base64_decode($_POST['data']);
$userInfo_array = json_decode($userInfo_json, true);
$level_info = Cache_GetLogGM::getInstance()->get_onlineav($userInfo_array);
$data = array();
$data['data']['total'] = $level_info[0];
$data['data']['list'] = $level_info[1];
$data['status'] = 1;
echo json_encode($data);
}
public function doAction()
{
$userInfo_json = base64_decode($_POST['data']);
$userInfo_array = json_decode($userInfo_json, true);
$online_data = Cache_GetLogGM::getInstance()->get_onlineLog($userInfo_array);
$result['data']['fields'] = array('time' => '时间', 'num' => '在线人数');
$data = array();
//$data['data']['all_total'] = $userInfo['all_page'];
unset($userInfo['all_total']);
//$data['data']['list'] = $userInfo;
$data['data']['list'] = $online_data;
// $player_data = Cache_GetUserInfoGM::getInstance()->get_playerInfo($userInfo_array);
$data['data']['info'] = array("新创建角色" => $player_data['reg_count'], "老用户登录数" => $player_data['old_login_count']);
$data['data']['reg_count'] = 0;
$data['data']['old_login_count'] = 0;
$data['status'] = 1;
echo json_encode($data);
}
public function doAction()
{
$sqlInfo_json = base64_decode($_POST['data']);
$sqlInfo_array = json_decode($sqlInfo_json, true);
$data = array();
if (empty($sqlInfo_array['sqlSentence'])) {
$data['status'] = 0;
}
if ($sqlInfo_array['dbtype'] == 'log') {
$sql_info = Cache_GetLogGM::getInstance()->get_sqlLog($sqlInfo_array);
} elseif ($sqlInfo_array['dbtype'] == 'game') {
$sql_info = Cache_GetUserInfoGM::getInstance()->get_sqlLog($sqlInfo_array['sqlSentence']);
} else {
$data['status'] = 0;
}
$data['status'] = 1;
$data['data']['list'] = $sql_info;
echo json_encode($data, JSON_UNESCAPED_UNICODE);
}
/**
* 获取礼券消耗
*
* @param array $objDataInfo
* @return unknown
*/
public function get_expand_giftlog($objDataInfo)
{
$page = $objDataInfo['page'] ? $objDataInfo['page'] : '1';
$page_size = $objDataInfo['size'] ? $objDataInfo['size'] : '20';
$all_page = $objDataInfo['all_page'];
$etime = $objDataInfo['etime'];
$stime = $objDataInfo['stime'];
$serverId = $objDataInfo['server_id'];
$condition = ' type = 2 AND';
if ($stime) {
$start_time = date('Y-m-d 00:00:00', strtotime($stime));
// $condition .= " add_time >= ".strtotime($start_time)." AND";
} else {
$start_time = date('Y-m-d 00:00:00', time());
// $condition .= " add_time >= ".strtotime($start_time)." AND";
}
if ($etime) {
$end_time = date('Y-m-d 23:59:59', strtotime($etime));
// $condition .= " add_time <= ".strtotime($end_time)." AND";
} else {
$end_time = date('Y-m-d 23:59:59', time());
// $condition .= " add_time <= ".strtotime($end_time)." AND";
}
if ($condition) {
$condition = 'where ' . $condition;
$condition = substr($condition, 0, -3);
}
//$page_total_num_sql = 'select count(`id`) as total from log_online '.$condition;
//$page_total_num = $this->get_one($page_total_num_sql,null);
//$page_num = ceil($page_total_num['total']/$page_size);
//$page_num_sql = 'select * from log_online '.$condition.' limit '.($page*$page_size-$page_size).','.$page_size;
$table = Cache_GetLogGM::get_table_name("log_color_gold_", $start_time, $end_time, false);
$login_count_sql = "select count(distinct a.player_id) as login_count,sum(a.item_num) as total from (" . $table . " ) as a " . $condition . "";
$login_count = $this->select_one($login_count_sql);
$page_num_sql = 'select count(log_id) as times,channel as modules,cmd_id as modules,sum(item_num) as flag_count,count(distinct player_id) as player_count from (' . $table . ') as a ' . $condition . ' group by cmd_id';
$userInfoData = $this->select_all($page_num_sql);
#转换
$cmd_arr = $this->select_all("select * from cmd_id ");
$cmd_arr = empty($cmd_arr) ? array() : $cmd_arr;
$cmd_arr1 = array();
foreach ($cmd_arr as $ca) {
$cmd_arr1[$ca['cmd_id']] = $ca['describe'];
}
$userInfoData = empty($userInfoData) ? array() : $userInfoData;
foreach ($userInfoData as &$ud) {
$tmp_mod = $cmd_arr1[$ud['modules']];
$ud['modules'] = empty($tmp_mod) ? $ud['modules'] : $tmp_mod;
}
#
$expandInfo = array();
$expandInfo[0] = $login_count['login_count'];
$expandInfo[1] = $login_count['total'];
$expandInfo[2] = $userInfoData;
//$userInfoData['all_page'] = $page_num;
return $expandInfo;
}
public function duowandata()
{
$data = array();
$data['data'] = array();
$data['status'] = $this->success;
$date = $_REQUEST['date'];
$sdate = strtotime($date);
#开始时间
$edate = $sdate + 86400;
#结束时间
$cusernum = Cache_GetUserInfoGM::getInstance()->get_user_num($sdate, $edate);
#创建人数
$clogin = Cache_GetLogGM::getInstance()->get_login_num($date);
#登陆人数
$maxonline = Cache_GetLogGM::getInstance()->get_maxonline_num($sdate, $edate);
#最高在线人数
$cusernum = empty($cusernum) ? 0 : $cusernum;
$clogin = empty($clogin) ? 0 : $clogin;
$maxonline = empty($maxonline) ? 0 : $maxonline;
$data['data'] = array('reg_nums' => $cusernum, 'login_nums' => $clogin, 'max_online' => $maxonline);
echo json_encode($data);
}
