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); }