/** * * @do ajax 获取浏览数据 * * @appinfo public * @author jerry * @copyright rockhippo * @param - * @return html * */ public function ajaxAppinfoHtmlAction() { $start = reqstr("start", ""); $micstart = strtotime($start); $end = reqstr("end", ""); $micend = strtotime($end); $PSys_PageviewRule = new PSys_PageviewRule(); $qzupdate_num = $ljupdate_num = $yhupdate_num = 0; $i = 0; for ($x = $micstart; $x <= $micend; $x += 86400) { $xAxis = date('Y-m-d', $x); $result["allrow"][$i]['day'] = $xAxis; $sql_qzupdate = 'select sum(total) as total from rhc_game_platform_collect where type=401 and pid = 1 and cday = ' . date('Ymd', $x); $qzRs = $PSys_PageviewRule->collectQuery($sql_qzupdate); $result["allrow"][$i]['qzupdate_num'] = intval($qzRs[0]["total"]); $qzupdate_num += intval($qzRs[0]["total"]) . ','; $sql_ljupdate = 'select sum(total) as total from rhc_game_platform_collect where type=401 and pid = 2 and cday = ' . date('Ymd', $x); $ljRs = $PSys_PageviewRule->collectQuery($sql_ljupdate); $result["allrow"][$i]['ljupdate_num'] = intval($ljRs[0]["total"]); $ljupdate_num += intval($ljRs[0]["total"]) . ','; $sql_yhupdate = 'select sum(total) as total from rhc_game_platform_collect where type=401 and pid = 3 and cday = ' . date('Ymd', $x); $yhRs = $PSys_PageviewRule->collectQuery($sql_yhupdate); $result["allrow"][$i]['yhupdate_num'] = intval($yhRs[0]["total"]); $yhupdate_num += intval($yhRs[0]["total"]) . ','; $sql_tcclose = 'select sum(total) as total from rhc_game_platform_collect where type=405 and pid = 0 and cday = ' . date('Ymd', $x); $tcRs = $PSys_PageviewRule->collectQuery($sql_tcclose); $result["allrow"][$i]['tcclose_num'] = intval($tcRs[0]["total"]); $tcclose_num += intval($tcRs[0]["total"]) . ','; $sql_tcin = 'select sum(total) as total from rhc_game_platform_collect where type=404 and pid = 0 and cday = ' . date('Ymd', $x); $tcinRs = $PSys_PageviewRule->collectQuery($sql_tcin); $result["allrow"][$i]['tcin_num'] = intval($tcinRs[0]["total"]); $tcin_num += intval($tcinRs[0]["total"]) . ','; $sql_yxjj = 'select sum(total) as total from rhc_game_platform_collect where type=502 and pid = 0 and cday = ' . date('Ymd', $x); $yxjjRs = $PSys_PageviewRule->collectQuery($sql_yxjj); $result["allrow"][$i]['yxjj_num'] = intval($yxjjRs[0]["total"]); $yxjj_num += intval($yxjjRs[0]["total"]) . ','; $sql_hdzq = 'select sum(total) as total from rhc_game_platform_collect where type=501 and pid = 0 and cday = ' . date('Ymd', $x); $hdzqRs = $PSys_PageviewRule->collectQuery($sql_hdzq); $result["allrow"][$i]['hdzq_num'] = intval($hdzqRs[0]["total"]); $hdzq_num += intval($hdzqRs[0]["total"]) . ','; $i++; } $this->smarty->assign("data", $result["allrow"]); $this->smarty->assign("qzupdate_num", $qzupdate_num); $this->smarty->assign("ljupdate_num", $ljupdate_num); $this->smarty->assign("yhupdate_num", $yhupdate_num); $this->smarty->assign("tcclose_num", $tcclose_num); $this->smarty->assign("tcin_num", $tcin_num); $this->smarty->assign("adv1_num", $adv1_num); $this->smarty->assign("adv2_num", $adv2_num); $this->smarty->assign("adv3_num", $adv3_num); $this->smarty->assign("adv4_num", $adv4_num); $this->smarty->assign("adv5_num", $adv5_num); $this->smarty->assign("hdzq_num", $hdzq_num); $this->smarty->assign("yxjj_num", $yxjj_num); $this->forward = "ajaxAppinfo"; }
/** * * @do ajax 获取浏览数据 * * @sign public * @author jerry * @copyright rockhippo * @param - * @return html * */ public function ajaxOtherHtmlAction() { $start = reqstr("start", ""); $micstart = strtotime($start); $end = reqstr("end", ""); $micend = strtotime($end); $PSys_PageviewRule = new PSys_PageviewRule(); $qzupdate_num = $ljupdate_num = $yhupdate_num = 0; $i = 0; $xAxis = $series = ""; for ($x = $micstart; $x <= $micend; $x += 86400) { $xAxis = date('Y-m-d', $x); $result["allrow"][$i]['day'] = $xAxis; $sql_fh = 'select sum(total) as total from rhc_game_platform_collect where type=301 and pid = 0 and cday = ' . date('Ymd', $x); $fhRs = $PSys_PageviewRule->collectQuery($sql_fh); $share_fh_num += intval($fhRs[0]["total"]); $result["allrow"][$i]['share_fh_num'] = intval($fhRs[0]["total"]); $sql_xy = 'select sum(total) as total from rhc_game_platform_collect where type=302 and pid = 0 and cday = ' . date('Ymd', $x); $xyRs = $PSys_PageviewRule->collectQuery($sql_xy); $xy_num += intval($xyRs[0]["total"]); $result["allrow"][$i]['xy_num'] = intval($xyRs[0]["total"]); $sql_qxshare = 'select sum(total) as total from rhc_game_platform_collect where type=303 and pid = 0 and cday = ' . date('Ymd', $x); $qxRs = $PSys_PageviewRule->collectQuery($sql_qxshare); $qxshare_num += intval($qxRs[0]["total"]); $result["allrow"][$i]['qxshare_num'] = intval($qxRs[0]["total"]); $sql_restart = 'select sum(total) as total from rhc_game_platform_collect where type=304 and pid = 0 and cday = ' . date('Ymd', $x); $reRs = $PSys_PageviewRule->collectQuery($sql_restart); $restart_num += intval($reRs[0]["total"]); $result["allrow"][$i]['restart_num'] = intval($reRs[0]["total"]); $sql_startad = 'select sum(total) as total from rhc_game_platform_collect where type=305 and pid = 0 and cday = ' . date('Ymd', $x); $adRs = $PSys_PageviewRule->collectQuery($sql_startad); $startad_num += intval($adRs[0]["total"]); $result["allrow"][$i]['startad_num'] = intval($adRs[0]["total"]); $sql_adfinish = 'select sum(total) as total from rhc_game_platform_collect where type=306 and pid = 0 and cday = ' . date('Ymd', $x); $adRs = $PSys_PageviewRule->collectQuery($sql_adfinish); $adfinish_num += intval($adRs[0]["total"]); $result["allrow"][$i]['adfinish_num'] = intval($adRs[0]["total"]); $sql_aderror = 'select sum(total) as total from rhc_game_platform_collect where type=307 and pid = 0 and cday = ' . date('Ymd', $x); $adRs = $PSys_PageviewRule->collectQuery($sql_aderror); $aderror_num += intval($adRs[0]["total"]); $result["allrow"][$i]['aderror_num'] = intval($adRs[0]["total"]); $sql_addown = 'select sum(total) as total from rhc_game_platform_collect where type=308 and pid = 0 and cday = ' . date('Ymd', $x); $adRs = $PSys_PageviewRule->collectQuery($sql_addown); $addown_num += intval($adRs[0]["total"]); $result["allrow"][$i]['addown_num'] = intval($adRs[0]["total"]); $sql_addownok = 'select sum(total) as total from rhc_game_platform_collect where type=309 and pid = 0 and cday = ' . date('Ymd', $x); $adRs = $PSys_PageviewRule->collectQuery($sql_addownok); $addownok_num += intval($adRs[0]["total"]); $result["allrow"][$i]['addownok_num'] = intval($adRs[0]["total"]); $sql_payfh = 'select sum(total) as total from rhc_game_platform_collect where type=310 and pid = 0 and cday = ' . date('Ymd', $x); $adRs = $PSys_PageviewRule->collectQuery($sql_payfh); $payfh_num += intval($adRs[0]["total"]); $result["allrow"][$i]['payfh_num'] = intval($adRs[0]["total"]); $i++; } $this->smarty->assign("data", $result["allrow"]); $this->smarty->assign("share_fh_num", $share_fh_num); $this->smarty->assign("xy_num", $xy_num); $this->smarty->assign("qxshare_num", $qxshare_num); $this->smarty->assign("restart_num", $restart_num); $this->smarty->assign("startad_num", $startad_num); $this->smarty->assign("adfinish_num", $adfinish_num); $this->smarty->assign("aderror_num", $aderror_num); $this->smarty->assign("addown_num", $addown_num); $this->smarty->assign("addownok_num", $addownok_num); $this->smarty->assign("payfh_num", $payfh_num); $this->forward = "ajaxOther"; }