/**
* 会员查询
*/
public function searchAction()
{
$page = reqnum("page", 1);
$pagesize = reqnum("pagesize", 10);
$username = trim(reqstr('username', ''));
$email = trim(reqstr('email', ''));
$regtime = reqstr('regtime', '');
$logintime = reqstr('logintime', '');
if (!$username && !$email && !$regtime && !$logintime) {
$this->forward = "search";
return;
}
$url = '';
if ($username) {
$url .= '&username='******'&email=' . urlencode($email);
}
if ($regtime) {
$url .= '®time=' . urlencode($regtime);
}
if ($logintime) {
$url .= '&logintime=' . urlencode($logintime);
}
$m = new Psys_MemberUserModel();
$list = $m->SearchList($username, $email, $regtime, $logintime, $page, $pagesize);
// var_dump($list);
// exit;
self::inidate($list['allnum'], $page, $pagesize, count($list['allrow']));
$this->smarty->assign('url', $url);
$this->smarty->assign('list', $list['allrow']);
$this->smarty->assign('psys_base_url', PSYS_BASE_URL);
$this->forward = "search";
}
/**
*
* @do 跳转
*
* @access public
* @author Nick
* @copyright rockhippo
* @param -
* @return -
*
*/
public function indexAction()
{
$data['message'] = reqstr('message', '');
if ($data['message'] == 'privilege') {
$data['message'] = 'You have no privilege.';
}
$data['type'] = reqstr('type', '');
$data['Url'] = $data['jumpUrl'] = str_replace("|", "&", reqstr('url', '/index/index'));
//若多参数则改为|连接
$data['waitSecond'] = reqstr('time', 3);
$this->smarty->assign('data', $data);
$this->forward = 'index';
}
/**
* 出售充值卡
* @return multitype:number string |multitype:number string boolean
*/
public function saleAction()
{
if (!$_SESSION['Cur_X_User']) {
return array('Code' => -100);
}
$id = reqstr('cardNo', '');
$rs = array('Code' => -1, 'result' => '');
if (!$id) {
$rs['result'] = 'id为空！';
return $rs;
}
$cd = new Psys_CardModel();
$k = $cd->Sale($id);
if ($k > 0) {
$rs['Code'] = 0;
$rs['result'] = true;
} else {
$rs['result'] = '售卖失败';
}
return $rs;
}
public function pointslistAction()
{
$page = reqnum("page", 1);
$pagesize = reqnum("pagesize", 20);
$username = reqstr('username', '');
$model = new Psys_PointsModel();
$where = array();
if (!empty($username)) {
$where['username'] = username;
}
$orderby = '';
$field = '*';
$points_list = $model->GetList($where, $orderby, $page, $pagesize, $field);
if (!empty($points_list['allrow'])) {
foreach ($points_list['allrow'] as &$points) {
//获取城市信息
$points['ctime'] = date('Y-m-d H:i:s', $points['ctime']);
}
}
self::inidate($points_list['allnum'], $page, $pagesize, count($points_list['allrow']));
$this->smarty->assign('points_list', $points_list['allrow']);
$this->forward = 'pointslist';
}
/**
* 伙伴推广数据
*/
public function spreadtrainappinfoAction()
{
$data = reqstr('data');
// if (!$data) {
// return;
// }
$data = urldecode($data);
$info = array();
parse_str($data, $info);
//$date = (int)$info['date']?(int)$info['date']:7; //默认是查出7天的数据
$sdate = trim($info['sdate']) ? trim($info['sdate']) : '';
$edate = trim($info['edate']) ? trim($info['edate']) : '';
$station = (int) $info['station'] ? (int) $info['station'] : 0;
// 0 表示查询出所有车站
$hour = trim($info['time']) ? trim($info['time']) : '';
$from = trim($info['entrance']) ? trim($info['entrance']) : 'all';
$type = trim($info['type']) ? trim($info['type']) : 'pv';
//默认是游戏
if (!$sdate && !$edate) {
$edate = $sdate = date('Y-m-d');
}
if (!$sdate || !$edate) {
if ($sdate) {
$edate = $sdate;
} else {
$sdate = $edate;
}
}
//
$nt = new Psys_ActivityModel();
$action = array('entrance' => $from, 'userindex' => 'userindex', 'clickhqg' => 'clickhqg', 'userhqg' => 'userhqg', 'clickdmbj' => 'clickdmbj', 'userdmbj' => 'userdmbj', 'clickactivedetails' => 'clickactivedetails', 'useractivedetails' => 'useractivedetails', 'useractivedetailsdown' => 'useractivedetailsdown', 'userhqgdown' => 'userhqgdown', 'userdmbjdown' => 'userdmbjdown', 'opentrainapp' => 'opentrainapp');
foreach ($action as $k => $v) {
$data_tab[$k] = $nt->NewUserActivity($sdate, $edate, $station, $hour, $type, $v, $from);
}
return $data_tab;
}
/**
* 更新广告位信息
*/
public function updatefulladsAction()
{
$id = reqnum('id', 0);
$ispost = reqnum('ispost', 0);
$model = new Psys_AdsModel();
if ($ispost == 1) {
//广告名
$adname = reqstr('adname');
//名称缩写
$adsname = reqstr('adsname');
//显示位置
$colid = reqstr('colid');
//图片路径
$imgurl = reqstr('imgurl', '');
//访问路径
$actionurl = reqstr('actionurl');
$subpage = reqnum('subpage');
$flag = reqnum('flag');
$data = array('adname' => $adname, 'adsname' => $adsname, 'colid' => $colid, 'flag' => $flag, 'imgurl' => $imgurl, 'actionurl' => $actionurl, 'subpage' => $subpage, 'ctime' => time(), 'station' => '1');
$result = array('result' => 'ERROR');
if ($imgurl == '') {
MsgInfoConst::GetMsg(1041, $result);
return $result;
}
if ($id == 0) {
$nt = new Psys_AdsModel();
$where = array('adname' => $adname);
$info = $nt->GetOne($where, "id,adname,subpage,imgurl,actionurl,colid,flag");
if ($info) {
$result = array('result' => 'ADNAME');
}
$returnid = $model->AddOne($data);
// start 写操作日志
$log = array('logtype' => 72, 'guid' => $_SESSION['Cur_X_User']['id'], 'ctime' => time(), 'cip' => real_ip());
$log['logdetail'] = $_SESSION['Cur_X_User']['username'] . "于" . date("Y-m-d H:i:s") . "[添加]广告位" . $adname;
$model->admin_syslog($log);
// end 日志
$result['result'] = 'SUCCESS';
} else {
$w = array('id' => $id);
$returnid = $model->UpdateOne($data, $w);
// start 写操作日志
$log = array('logtype' => 72, 'guid' => $_SESSION['Cur_X_User']['id'], 'ctime' => time(), 'cip' => real_ip());
$log['logdetail'] = $_SESSION['Cur_X_User']['username'] . "于" . date("Y-m-d H:i:s") . "[编辑]广告位" . $adname;
$model->admin_syslog($log);
// end 日志
$result['result'] = 'SUCCESS';
}
if ($result['result'] == 'SUCCESS') {
$file = dirname(dirname(dirname(dirname(dirname(__FILE__))))) . '/temp.txt';
$fp = fopen($file, 'w');
fwrite($fp, '1');
fclose($fp);
}
return $result;
}
}
public function expAction()
{
$orderid = reqstr('orderid', '');
$username = reqstr('username', '');
$id = reqstr('id', '');
$where = '1=1 and flag=1';
if (!empty($orderid)) {
$where .= " and orderid='" . $orderid . "'";
}
if (!empty($username)) {
$where .= ' and username='******',');
$where .= " and id in (" . $id . ")";
}
$page = reqnum("page", 1);
$pagesize = reqnum("pagesize", 1000);
$m = new Psys_UserModel();
$list = $m->GetList($where, '', $page, $pagesize, "id,username,mark,goodsid,num,ctime", 'rhi_mallorder');
global $G_X;
$filestr = 'charge' . date('YmdHis') . uniqid() . '.csv';
$filename = PUBLIC_PATH . $G_X['prjstr'] . DIRECTORY_SEPARATOR . $filestr;
//设置文件名
if (!file_exists($filename)) {
touch($filename);
chmod($filename, 0777);
}
$fp = fopen($filename, 'w');
$title = array("序号", "电话号码", '发放号码', '商品id', '数目', '兑换时间');
foreach ($title as &$value) {
$value = iconv('utf-8', 'gb2312', $value);
}
fputcsv($fp, $title);
if ($list['allrow']) {
foreach ($list['allrow'] as &$row) {
$row['ctime'] = date('Y-m-d H:i:s', $row['ctime']);
if (fputcsv($fp, $row)) {
$m->UpdateOne(array('ifuse' => 1), array('id' => $row['id']), 'rhi_mallorder');
}
}
}
fclose($fp);
// header('Content-Type: application/octet-stream');
// header('Content-Disposition: attachment; filename=' . $filestr);
// header('Content-Transfer-Encoding: binary');
// header('Content-Length: ' . filesize($fileName));
// readfile($filename);
return array('status' => 1, 'filename' => $filestr);
}
/**
*
* @do ajax 获取月浏览数据
*
* @sign public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlypointHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_signModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_signModel->GetList($where, $order, 0, 0, "*", "rhc_lottery_monthly");
$start_num = $new_reg = $new_num = $cost_points = $get_points = $first_get_points = $third_get_points = $second_get_points = $fourth_get_points = $fifth_get_points = "";
foreach ($result["allrow"] as $k => $v) {
$start_num += intval($v["start_num"]);
$new_reg += intval($v["new_reg"]);
$new_num += intval($v["new_num"]);
$cost_points += intval($v["cost_points"]);
$get_points += intval($v["get_points"]);
$first_get_points += intval($v["first_get_points"]);
$third_get_points += intval($v["third_get_points"]);
$second_get_points += intval($v["second_get_points"]);
$fourth_get_points += intval($v["fourth_get_points"]);
$fifth_get_points += intval($v["fifth_get_points"]);
}
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("start_num", $start_num);
$this->smarty->assign("new_reg", $new_reg);
$this->smarty->assign("new_num", $new_num);
$this->smarty->assign("cost_points", $cost_points);
$this->smarty->assign("get_points", $get_points);
$this->smarty->assign("first_get_points", $first_get_points);
$this->smarty->assign("third_get_points", $third_get_points);
$this->smarty->assign("second_get_points", $second_get_points);
$this->smarty->assign("fourth_get_points", $fourth_get_points);
$this->smarty->assign("fifth_get_points", $fifth_get_points);
$this->forward = "ajaxMonthlyPoint";
}
/**
*
* @do 导出人寿用户数据
*
* @pingan public
* @author jerry
* @copyright rockhippo
* @param -
* @return -
*
*/
public function ajaxRensHourExportAction()
{
$start = reqstr("start", "");
$micstart = strtotime($start);
$end = reqstr("end", "");
$micend = strtotime($end);
if ($micstart != $micend) {
exit('请选择单日！');
}
$micend += 86400;
$PSys_PinganRule = new PSys_PinganRule();
$i = 0;
for ($x = $micstart; $x <= $micend; $x += 3600) {
if ($i == 24) {
break;
}
$result['allrow'][$i]['create_time'] = date('Y-m-d H:i:s', $x) . ' ~ ' . date('Y-m-d H:i:s', $x + 3600);
$sql_jn = "SELECT count(id) as total FROM rha_log_pingan WHERE type = 206 AND pid = 0 AND appkey = 'jn' AND cday = " . date('Ymd', $x) . " AND create_time >= " . $x . " AND create_time < " . ($x + 3600);
$jnRs = $PSys_PinganRule->rensQuery($sql_jn);
$result['allrow'][$i]['jn'] = $jnRs[0]['total'];
$sql_jnx = "SELECT count(id) as total FROM rha_log_pingan WHERE type = 206 AND pid = 0 AND appkey = 'jnx' AND cday = " . date('Ymd', $x) . " AND create_time >= " . $x . " AND create_time < " . ($x + 3600);
$jnxRs = $PSys_PinganRule->rensQuery($sql_jnx);
$result['allrow'][$i]['jnx'] = $jnxRs[0]['total'];
$sql_wf = "SELECT count(id) as total FROM rha_log_pingan WHERE type = 206 AND pid = 0 AND appkey = 'wf' AND cday = " . date('Ymd', $x) . " AND create_time >= " . $x . " AND create_time < " . ($x + 3600);
$wfRs = $PSys_PinganRule->rensQuery($sql_wf);
$result['allrow'][$i]['wf'] = $wfRs[0]['total'];
$sql_zb = "SELECT count(id) as total FROM rha_log_pingan WHERE type = 206 AND pid = 0 AND appkey = 'zb' AND cday = " . date('Ymd', $x) . " AND create_time >= " . $x . " AND create_time < " . ($x + 3600);
$zbRs = $PSys_PinganRule->rensQuery($sql_zb);
$result['allrow'][$i]['zb'] = $zbRs[0]['total'];
$i++;
}
//清空输出缓存
ob_clean();
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("rockhippo")->setLastModifiedBy("jerry")->setTitle("人寿认证保单时段用户数据")->setSubject("人寿数据")->setDescription("")->setKeywords("excel")->setCategory("result file");
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '日期时段')->setCellValue('B1', '济南')->setCellValue('C1', '济南西')->setCellValue('D1', '潍坊')->setCellValue('E1', '淄博');
foreach ($result['allrow'] as $k => $v) {
$num = $k + 2;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $num, $v['create_time'])->setCellValue('B' . $num, $v['jn'])->setCellValue('C' . $num, $v['jnx'])->setCellValue('D' . $num, $v['wf'])->setCellValue('E' . $num, $v['zb']);
}
$objPHPExcel->getActiveSheet()->setTitle('User');
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="人寿认证保单' . $start . '时段用户数据.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
}
public function logaddAction()
{
$logdetail = reqstr('logdetail', '');
$ipcno = reqstr('ipcno', '');
if (!$logdetail) {
return array('code' => -1);
}
if (!$ipcno) {
return array('code' => -2);
}
$data = array('logdetail' => $logdetail, 'ctime' => time(), 'cip' => real_ip(), 'user' => $this->cur_user['realname'], 'ipcno' => $ipcno);
$m = new Psys_IpcModel();
$res = $m->AddOne($data, 'rha_ipclog');
if ($res > 0) {
$data['id'] = $res;
$data['ctime'] = date('Y-m-d H:i:S', $data['ctime']);
return array('code' => 1, 'data' => $data);
} else {
return array('code' => 0);
}
}
/**
* 所选时间段范围内的每7天WiFi连接数与注册数
*/
public function wifidataweekAction()
{
$data = reqstr('data');
if (!$data) {
return;
}
$data = urldecode($data);
$info = array();
parse_str($data, $info);
$date = (int) $info['date'] ? (int) $info['date'] : 7;
//默认是查出7天的数据
$sdate = trim($info['sdate']) ? trim($info['sdate']) : '';
$edate = trim($info['edate']) ? trim($info['edate']) : '';
//默认是青岛南
$station = empty($info['station']) ? 1 : implode(',', $info['station']);
if (!$sdate || !$edate) {
$edate = date('Y-m-d');
$sdate = date('Y-m-d', strtotime("-{$date} day"));
}
if ($sdate < '2015-02-01') {
$sdate = '2015-02-01';
}
$isbaifenbi = reqnum('baifenbi', 0);
$dates = $this->cutdate($sdate, $edate);
$nt = new Psys_StationModel();
foreach ($dates as $v_date) {
$res[] = $nt->wifidataweek($station, $v_date['sdate'], $v_date['edate']);
}
$datas[0]['name'] = 'wifi连接数';
$datas[1]['name'] = '注册数';
foreach ($res as $v) {
$result['x_cat'][] = $v['datearea'];
$datas[0]['data'][] = (int) $v['wifi'];
$datas[1]['data'][] = (int) $v['reg'];
if ($isbaifenbi) {
$baifenbis[0]['name'] = '周注册连接百分比';
$b = $v['reg'] / $v['wifi'] * 100;
$baifenbis[0]['data'][] = (double) round($b, 2);
}
}
$result['y_data'] = $datas;
if ($isbaifenbi) {
$result['baifenbi'] = $baifenbis;
}
return $result;
}
public function stationeditAction()
{
$model = new Psys_TripModel();
$model->SetDb("db-rht_train");
$ispost = reqnum('ispost', 0);
if ($ispost) {
$id = reqnum('id', 0);
$sno = reqstr('sno');
$fz = reqstr('fz');
$dz = reqstr('dz');
$stime = reqstr('stime');
$dtime = reqstr('dtime');
$dzxh = reqstr('dzxh');
$isdz = reqstr('isdz');
$flag = reqstr('flag');
$appkey = reqstr('appkey');
$data = array('sno' => $sno, 'fz' => $fz, 'dz' => $dz, 'stime' => $stime, 'dtime' => $dtime, 'dzxh' => $dzxh, 'isdz' => $isdz, 'flag' => $flag, 'appkey' => $appkey);
if ($id > 0) {
$where = array('id' => $id);
$re = $model->UpdateOne($data, $where, "rht_station");
$msg = '修改';
} else {
$re = $model->AddOne($data, "rht_station");
$msg = '添加';
}
if ($re) {
echo '<script>alert("' . $msg . '成功,反回列表！");window.location.href="/trip/stlist?trainno=' . $sno . '"</script>';
exit;
}
}
$id = reqnum('id', 0);
$station = array();
if ($id > 0) {
$where = array('id' => $id);
$station = $model->GetOne($where, "*", "rht_station");
$this->smarty->assign('action', 'edit');
} else {
$this->smarty->assign('action', 'add');
}
$this->smarty->assign('station', $station);
$this->forward = "add";
}
/**
* 交易查询列表
*/
public function inquiryListAction()
{
global $G_X;
$page = reqnum('page', 1);
$pagesize = reqnum('pagesize', 10);
$orderguid = reqstr('orderguid', '');
$username = reqstr('username', '');
$producttype = reqnum('producttype', '');
$order = reqnum('order', 0);
//默认为倒序排序
$ifsucc = reqnum('ifsucc', -1);
//默认为全部
$startTime = reqstr('startTime', '');
$endTime = reqstr('endTime', date('Y-m-d H:i:s'));
//判断起始时间是否有值
if ($startTime !== '') {
$startTime = strtotime($startTime);
$endTime = strtotime($endTime);
}
$url = '';
//如果订单号不为空，重组URL
if ($orderguid) {
$url .= '&orderguid=' . $orderguid;
}
//如果用户名不为空，重组URL
if ($username) {
$url .= '&username='******'&producttype=' . $producttype;
}
//如果排序不为空，重组URL
if ($order) {
$url .= '&order=' . $order;
}
//如果起始时间不为空，重组URL
if ($startTime) {
$url .= '&startTime=' . date('Y-m-d H:i:s', $startTime) . '&endTime=' . date('Y-m-d H:i:s', $endTime);
}
//如果状态信息不为空，则查询全部
if ($ifsucc != -1) {
$url .= '&ifsucc=' . $ifsucc;
}
$model = new Psys_FinModel();
$list = $model->inquiryList($orderguid, $username, $producttype, $ifsucc, $order, $startTime, $endTime, $page, $pagesize);
//var_dump($list);exit;
//资源列表
$resModel = new Psys_ResModel();
foreach ($list['allrow'] as &$value) {
$value['ctime'] = date('Y-m-d H:i:s', $value['ctime']);
//下单时间格式转换
$value['cip'] = long2ip($value['cip']);
//下单地址格式转换
if ($value['utime'] != '' || $value['uip'] != '') {
$value['utime'] = date('Y-m-d H:i:s', $value['utime']);
$value['uip'] = long2ip($value['uip']);
}
switch ($value['producttype']) {
case 1:
//视频
$value['producttype'] = $G_X['order_type']['video_type'][1];
$where = array('id' => $value['productid']);
$result = $resModel->GetOneVideo($where);
$value['productid'] = $result['vname'];
break;
case 2:
//音乐
$value['producttype'] = $G_X['order_type']['music_type'][1];
$where = array('id' => $value['productid']);
$result = $resModel->GetOne($where, 'mname', 'rhi_music');
$value['productid'] = $result['mname'];
break;
case 3:
//游戏
$value['producttype'] = $G_X['order_type']['game_type'][1];
$where = array('id' => $value['productid']);
$result = $resModel->GetOneGame($where);
$value['productid'] = $result['appname'];
break;
case 4:
//应用
$value['producttype'] = $G_X['order_type']['app_type'][1];
$where = array('id' => $value['productid']);
$result = $resModel->GetOne($where, 'appname', 'rhi_apps');
$value['productid'] = $result['appname'];
break;
case 10:
//美食
$value['producttype'] = $G_X['order_type']['food_type'][1];
$where = array('id' => $value['productid']);
$result = $resModel->GetOne($where, 'fname', 'rhi_foodish');
$value['productid'] = $result['fname'];
break;
}
}
self::inidate($list['allnum'], $page, $pagesize, count($list['allrow']));
//$this->smarty->assign('orderguid',$orderguid);
//$this->smarty->assign('username',$username);
//$this->smarty->assign('producttyp',$producttyp);
//$this->smarty->assign('order',$order);
//$this->smarty->assign('ifsucc',$ifsucc);
//$this->smarty->assign('startTime',$startTime);
//$this->smarty->assign('endTime',$endTime);
//$this->smarty->assign('producttype',$G_X['order_type']);
$this->smarty->assign('url', $url);
$this->smarty->assign('list', $list['allrow']);
$this->forward = 'inquiryList';
}
/**
*
* @do ajax 获取月浏览数据
*
* @member public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlymemberHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_memberModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_memberModel->GetList($where, $order, 0, 0, "*", "rhc_member_monthly");
$total_active_user = $total_new_user = $total_old_user = 0;
foreach ($result["allrow"] as $k => $v) {
$total_new_user += intval($v["new_user"]);
$total_old_user += intval($v["old_user"]);
$total_active_user += intval($v["active_user"]);
$total_open_num += intval($v["open_num"]);
}
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("total_new_user", $total_new_user);
$this->smarty->assign("total_old_user", $total_old_user);
$this->smarty->assign("total_active_user", $total_active_user);
$this->smarty->assign("total_open_num", $total_open_num);
$this->forward = "ajaxMonthlyMember";
}
/**
* 更新广告位信息
*/
public function updateAction()
{
$ispost = reqnum('ispost', 0);
if ($ispost == 1) {
$id = reqnum('id');
if (!$id) {
echo 'id invalid!';
exit;
}
//广告一
$adsone = reqstr('adsone', '');
//广告二
$adstwo = reqstr('adstwo', '');
$rule = new Psys_AdsRule();
$data = array();
$data['adsone'] = $adsone;
$data['adstwo'] = $adstwo;
$data['utime'] = time();
$flag = $rule->updateStationAds($data, array('id' => $id));
$result = array('result' => 'ERROR');
if ($flag) {
$result['result'] = 'SUCCESS';
}
return $result;
}
}
/**
*
* @do ajax 获取月浏览数据
*
* @sign public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlyuserHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_signModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_signModel->GetList($where, $order, 0, 0, "*", "rhc_wxcompet_monthly");
$open_num = $share_times = $share_ok = $dl_click = $dj_click = $dl_ad_click = $dl_ios_click = $start_dl_times = $new_num = $new_reg = "";
foreach ($result["allrow"] as $k => $v) {
$open_num += intval($v["open_num"]);
$new_reg += intval($v["new_reg"]);
$new_num += intval($v["new_num"]);
$share_times += intval($v["share_times"]);
$share_ok += intval($v["share_ok"]);
$dl_click += intval($v["dl_click"]);
$dj_click += intval($v["dj_click"]);
$dl_ad_click += intval($v["dl_ad_click"]);
$dl_ios_click += intval($v["dl_ios_click"]);
$start_dl_times += intval($v["start_dl_times"]);
}
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("open_num", $open_num);
$this->smarty->assign("new_reg", $new_reg);
$this->smarty->assign("new_num", $new_num);
$this->smarty->assign("share_times", $share_times);
$this->smarty->assign("share_ok", $share_ok);
$this->smarty->assign("dl_click", $dl_click);
$this->smarty->assign("dj_click", $dj_click);
$this->smarty->assign("dl_ad_click", $dl_ad_click);
$this->smarty->assign("dl_ios_click", $dl_ios_click);
$this->smarty->assign("start_dl_times", $start_dl_times);
$this->forward = "ajaxMonthlyUser";
}
public function ajaxAddAction()
{
$m = new PSys_MenuModel();
if ($_POST['ispost']) {
$data = array();
$data['action'] = reqstr('action');
$data['name'] = reqstr('name');
$data['class'] = reqstr('class');
$data['pid'] = reqnum('pid', 0);
if ($data['action'] and $data['name']) {
$ps = $m->AddOne($data);
if ($ps) {
$m->getMenuTree(0, true);
header('location:/menu/index');
exit;
}
}
}
$all = $m->getMenuTree();
$this->smarty->assign("all", $all);
$this->smarty->assign("action", '/menu/ajaxAdd');
$this->forward = "ajaxEdit";
}
/**
*
* @do ajax 获取月浏览数据
*
* @sign public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlyanswerHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_signModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_signModel->GetList($where, $order, 0, 0, "*", "rhc_answer_monthly");
$total_01 = $total_02 = $total_03 = $total_04 = $total_05 = $total_06 = $total_07 = $total_08 = $total_09 = $total_10 = $total_11 = $total_start_times = $total_submit_times = '';
$newarr_01 = $newarr_02 = $newarr_03 = $newarr_04 = $newarr_05 = $newarr_06 = $newarr_07 = $newarr_07 = $newarr_08 = $newarr_10 = $newarr_11 = array();
foreach ($result["allrow"] as $k => $v) {
$total_start_times += $v['start_times'];
$total_submit_times += $v['submit_times'];
$answer_1 = $v['answer_1'];
$answer_2 = $v['answer_2'];
$answer_3 = $v['answer_3'];
$answer_4 = $v['answer_4'];
$answer_5 = $v['answer_5'];
$answer_6 = $v['answer_6'];
$answer_7 = $v['answer_7'];
$answer_8 = $v['answer_8'];
$answer_9 = $v['answer_9'];
$answer_10 = $v['answer_10'];
$answer_11 = $v['answer_11'];
$temparr_01 = explode("-", $answer_1);
foreach ($temparr_01 as $k => $v) {
$newarr_01[$k] += $v;
}
$temparr_02 = explode("-", $answer_2);
foreach ($temparr_02 as $k => $v) {
$newarr_02[$k] += $v;
}
$temparr_03 = explode("-", $answer_3);
foreach ($temparr_03 as $k => $v) {
$newarr_03[$k] += $v;
}
$temparr_04 = explode("-", $answer_4);
foreach ($temparr_04 as $k => $v) {
$newarr_04[$k] += $v;
}
$temparr_05 = explode("-", $answer_5);
foreach ($temparr_05 as $k => $v) {
$newarr_05[$k] += $v;
}
$temparr_06 = explode("-", $answer_6);
foreach ($temparr_06 as $k => $v) {
$newarr_06[$k] += $v;
}
$temparr_07 = explode("-", $answer_7);
foreach ($temparr_07 as $k => $v) {
$newarr_07[$k] += $v;
}
$temparr_08 = explode("-", $answer_8);
foreach ($temparr_08 as $k => $v) {
$newarr_08[$k] += $v;
}
$temparr_09 = explode("-", $answer_9);
foreach ($temparr_09 as $k => $v) {
$newarr_09[$k] += $v;
}
$temparr_10 = explode("-", $answer_10);
foreach ($temparr_10 as $k => $v) {
$newarr_10[$k] += $v;
}
$temparr_11 = explode("-", $answer_11);
foreach ($temparr_11 as $k => $v) {
$newarr_11[$k] += $v;
}
}
foreach ($newarr_01 as $v) {
$total_01 .= $v . '-';
}
foreach ($newarr_02 as $v) {
$total_02 .= $v . '-';
}
foreach ($newarr_03 as $v) {
$total_03 .= $v . '-';
}
foreach ($newarr_04 as $v) {
$total_04 .= $v . '-';
}
foreach ($newarr_05 as $v) {
$total_05 .= $v . '-';
}
foreach ($newarr_06 as $v) {
$total_06 .= $v . '-';
}
foreach ($newarr_07 as $v) {
$total_07 .= $v . '-';
}
foreach ($newarr_08 as $v) {
$total_08 .= $v . '-';
}
foreach ($newarr_09 as $v) {
$total_09 .= $v . '-';
}
foreach ($newarr_10 as $v) {
$total_10 .= $v . '-';
}
foreach ($newarr_11 as $v) {
$total_11 .= $v . '-';
}
$PSys_PointRule = new PSys_PointRule();
$sql = 'select DISTINCT answer from rhi_answer where ques_id = 11 and answer not in("A","B","C","D") and cday between ' . date('Ymd', strtotime($start . '-01')) . ' and ' . date('Ymt', strtotime($end));
//$sql = 'select answer from rhi_survey where answer_12 not in("A","B","C","D") and cday between '.date('Ymd',strtotime($start.'-01')).' and '.date('Ymt',strtotime($end));
$gamelist = $PSys_PointRule->answerSql($sql);
$this->smarty->assign("gamelist", $gamelist);
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("total_01", trim($total_01, '-'));
$this->smarty->assign("total_02", trim($total_02, '-'));
$this->smarty->assign("total_03", trim($total_03, '-'));
$this->smarty->assign("total_04", trim($total_04, '-'));
$this->smarty->assign("total_05", trim($total_05, '-'));
$this->smarty->assign("total_06", trim($total_06, '-'));
$this->smarty->assign("total_07", trim($total_07, '-'));
$this->smarty->assign("total_08", trim($total_08, '-'));
$this->smarty->assign("total_09", trim($total_09, '-'));
$this->smarty->assign("total_10", trim($total_10, '-'));
$this->smarty->assign("total_11", trim($total_11, '-'));
$this->smarty->assign("total_start_times", $total_start_times);
$this->smarty->assign("total_submit_times", $total_submit_times);
$this->forward = "ajaxMonthlyAnswer";
}
/**
*
* @do ajax 获取月浏览数据
*
* @btnclick public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlyBtnclickHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_BtnclickModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_BtnclickModel->GetList($where, $order, 0, 0, "*", "rhc_click_monthly");
$btn_201 = $btn_202 = $btn_203 = $btn_204 = $btn_205 = $btn_207 = $btn_208 = $btn_301 = $btn_302 = $btn_303 = $btn_401 = $btn_402 = $btn_501 = $btn_601 = $btn_602 = $btn_603 = $btn_604 = $btn_605 = $btn_701 = $btn_702 = $btn_801 = 0;
foreach ($result["allrow"] as $k => $v) {
$btn_201 += intval($v["btn_201"]);
$btn_202 += intval($v["btn_202"]);
$btn_203 += intval($v["btn_203"]);
$btn_204 += intval($v["btn_204"]);
$btn_205 += intval($v["btn_205"]);
$btn_207 += intval($v["btn_207"]);
$btn_208 += intval($v["btn_208"]);
$btn_301 += intval($v["btn_301"]);
$btn_302 += intval($v["btn_302"]);
$btn_303 += intval($v["btn_303"]);
$btn_401 += intval($v["btn_401"]);
$btn_402 += intval($v["btn_402"]);
$btn_501 += intval($v["btn_501"]);
$btn_601 += intval($v["btn_601"]);
$btn_602 += intval($v["btn_602"]);
$btn_603 += intval($v["btn_603"]);
$btn_604 += intval($v["btn_604"]);
$btn_605 += intval($v["btn_605"]);
$btn_701 += intval($v["btn_701"]);
$btn_702 += intval($v["btn_702"]);
$btn_801 += intval($v["btn_801"]);
}
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("btn_201", $btn_201);
$this->smarty->assign("btn_202", $btn_202);
$this->smarty->assign("btn_203", $btn_203);
$this->smarty->assign("btn_204", $btn_204);
$this->smarty->assign("btn_205", $btn_205);
$this->smarty->assign("btn_207", $btn_207);
$this->smarty->assign("btn_208", $btn_208);
$this->smarty->assign("btn_301", $btn_301);
$this->smarty->assign("btn_302", $btn_302);
$this->smarty->assign("btn_303", $btn_303);
$this->smarty->assign("btn_401", $btn_401);
$this->smarty->assign("btn_402", $btn_402);
$this->smarty->assign("btn_501", $btn_501);
$this->smarty->assign("btn_601", $btn_601);
$this->smarty->assign("btn_602", $btn_602);
$this->smarty->assign("btn_603", $btn_603);
$this->smarty->assign("btn_604", $btn_604);
$this->smarty->assign("btn_605", $btn_605);
$this->smarty->assign("btn_701", $btn_701);
$this->smarty->assign("btn_702", $btn_702);
$this->smarty->assign("btn_801", $btn_801);
$this->forward = "ajaxMonthlyBtnclick";
}
/**
*
* @do my data
*
* @access public
* @author Nick
* @copyright rockhippo
* @param -
* @return -
*
*/
public function mydataAction()
{
global $G_X;
$user = XSession::Get("TA_user");
$userModel = new PSys_UserModel();
if ($this->ispost) {
$where = array();
$where['user_id'] = $user['id'];
$data = array();
$data['nick'] = reqstr("nick", "");
$data['age'] = reqstr("age", "");
$data['phone'] = reqstr("phone", "");
$data['address'] = reqstr("address", "");
$data['photo'] = reqstr("photo", "");
$return = $userModel->UpdateOne($data, $where, "ta_user_information");
if ($return) {
$this->jump("Edit success.", "success", "/index/mydata", 1);
} else {
$this->jump("Edit failed.", "errors", "/index/mydata", 1);
}
exit;
}
$where = array();
$where['id'] = $user['id'];
$data = $userModel->GetOne($where, "*", "view_user");
$timestamp = time();
$timestamp_token = md5($G_X['upload']['unique_salt'] . $timestamp);
$this->smarty->assign("timestamp", $timestamp);
$this->smarty->assign("timestamp_token", $timestamp_token);
$this->smarty->assign("data", $data);
$this->forward = "mydata";
}
/**
*
* @do ajax 获取月浏览数据
*
* @package public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlyPackageHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$game = reqstr("game", "");
$PSys_packageModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$where["game"] = $game;
$order = "month ASC";
$result = $PSys_packageModel->GetList($where, $order, 0, 0, "*", "rhc_package_monthly");
$send_times = "";
foreach ($result["allrow"] as $k => $v) {
$send_times += intval($v["send_times"]);
}
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("send_times", $send_times);
$this->forward = "ajaxMonthlyPackage";
}
public function newsnumaction()
{
$appkey = reqstr('apk', '');
$model = new Psys_NewsModel();
$data = $model->newsNum($appkey);
return $data;
}
public function menuAction()
{
$curmenu = reqstr('m', 'account');
$this->smarty->assign('curmenu', $curmenu);
$this->forward = "menu";
}
/**
*
* @do ajax 获取月浏览数据
*
* @sign public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlysignHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_signModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_signModel->GetList($where, $order, 0, 0, "*", "rhc_sign_monthly");
$total_start_times = $total_sign_times = 0;
foreach ($result["allrow"] as $k => $v) {
$total_start_times += intval($v["start_times"]);
$total_sign_times += intval($v["sign_times"]);
$sign_rate = round(intval($v["sign_times"]) / intval($v["start_times"]) * 100, 2);
$result["allrow"][$k]['sign_rate'] = $sign_rate . "%";
}
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("total_start_times", $total_start_times);
$this->smarty->assign("total_sign_times", $total_sign_times);
$this->forward = "ajaxMonthlySign";
}
/**
* 安装包文件和对应图片的上传
*/
public function uploadfileAction()
{
//$stateArray = array();
//读取memcache缓存信息
//$memcache = XMemCache::GetInstance();
//$status = $memcache->Get('Cur_X_User');
//if(empty($_SESSION['Cur_X_User']['id']))
//{
// die('请先登录');
//}
//上传错误提示
$errorMsg = array('0' => '文件上传成功', '1' => '文件超出了服务器配置大小', '2' => '文件超出了表单配置大小', '3' => '仅部分文件上传', '4' => '没有找到上传文件', '5' => '上传文件大小为零', '6' => '未找到临时文件夹', '7' => '临时文件夹写入失败', '8' => '服务器文件上传扩展未开启', '9' => '上传图片规格不符合要求', '10' => '存放文件夹建立失败', '11' => '上传文件移动失败');
//引入图片处理类
require_once COMMON_PATH . "XThumb.php";
$imgthumb = new XThumb();
$num = reqnum("num", 0);
$appcol = reqstr('appcol', 1);
$appid = reqstr('appid', '');
$appid = $appid ? $appid : $this->getmaxappidAction($appcol);
//返回数据
$arr = array();
//json数据返回
$returnJson = '';
$error = true;
//上传文件目录设置
if ($appcol == 2) {
$root = APP_PATH;
} elseif ($appcol == 1) {
$root = GAME_PATH;
}
define('ROOT', $root);
$flag = isset($_POST['flag']) ? $_POST['flag'] : '';
if (!$flag) {
return;
}
switch ($flag) {
//logo上传
case 'logo':
$logo = isset($_FILES['file']) ? $_FILES['file'] : '';
if ($logo['error'] == 0) {
$dir = ROOT . $appid;
$img_info = getimagesize($logo['tmp_name']);
//图片比例限制
$radio = floor($img_info[0] / $img_info[1] * 10);
if (!($radio > 9 && $radio < 11)) {
$error = false;
$msg = $msg ? $msg . ',' . $logo['tmp_name'] . $errorMsg[9] : $logo['tmp_name'] . $errorMsg[9];
} else {
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $logo['tmp_name'] . $errorMsg[10] : $logo['tmp_name'] . $errorMsg[10];
} else {
//获取后缀名
//$ext = strrchr($logo['name'],'.');
$ext = '.png';
$filename = 'logo' . $ext;
//文件名及地址组装
$path = $dir . '/' . $filename;
$arr['img_name'] = str_replace(ROOT, '/', $path);
if (!move_uploaded_file($logo['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $logo['tmp_name'] . $errorMsg[11] : $logo['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 150, 150, $path);
}
}
} else {
//获取后缀名
//$ext = strrchr($logo['name'],'.');
$ext = '.png';
$filename = 'logo' . $ext;
//文件名及地址组装
$path = $dir . '/' . $filename;
$arr['img_name'] = $filename;
if (!move_uploaded_file($logo['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $logo['tmp_name'] . $errorMsg[11] : $logo['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 150, 150, $path);
}
}
}
} else {
if ($logo['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $logo['tmp_name'] . $errorMsg[$file['error']] : $logo['tmp_name'] . $errorMsg[$file['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$logo['error']];
}
}
break;
//安装文件上传
//安装文件上传
case 'installfile':
//安装文件
$installfile = isset($_FILES['file']) ? $_FILES['file'] : '';
$arr['size'] = ceil($installfile['size'] / 1000000);
if ($installfile['error'] == 0) {
$dir = ROOT . $appid;
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $errorMsg[10];
}
}
$filename = $installfile['name'];
$file_ext = strtolower(substr($filename, strrpos($filename, '.') + 1));
$appname = $appid . '.' . $file_ext;
$path = $dir . '/' . $appname;
$arr['img_name'] = $appname;
if (!move_uploaded_file($installfile['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $installfile['tmp_name'] . $errorMsg[11] : $installfile['tmp_name'] . $errorMsg[11];
}
} else {
if ($installfile['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $installfile['tmp_name'] . $errorMsg[$installfile['error']] : $installfile['tmp_name'] . $errorMsg[$installfile['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$installfile['tmp_name']];
}
}
break;
//安卓封面
//安卓封面
case 'fmandroid':
$error = true;
$fmandroid = isset($_FILES['file']) ? $_FILES['file'] : '';
if ($fmandroid['error'] == 0) {
$dir = ROOT . $appid;
$dir = $dir . '/' . 'android' . '/' . 'ads' . '/';
echo $dir;
$img_info = getimagesize($fmandroid['tmp_name']);
//计算长宽必烈
$radio = floor($img_info[0] / $img_info[1] * 100);
if (!($radio > 185 && $radio < 195)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmandroid['tmp_name'] . $errorMsg[9] : $fmandroid['tmp_name'] . $errorMsg[9];
} else {
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmandroid['tmp_name'] . $errorMsg[10] : $fmandroid['tmp_name'] . $errorMsg[10];
} else {
//获取扩展名
$filename = $fmandroid['name'];
$ext = strtolower(substr($filename, strrpos($filename, '.') + 1));
$filename = 'adshdpi';
$fname = $filename . '.' . $ext;
$path = $dir . $fname;
$arr['img_name'] = $fname;
if (!move_uploaded_file($fmandroid['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmandroid['tmp_name'] . $errorMsg[11] : $fmandroid['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 480, 255, $dir . 'adshdpi' . $ext);
$imgthumb->imgZoom($path, 540, 288, $dir . 'adsmdpi' . $ext);
$imgthumb->imgZoom($path, 720, 380, $dir . 'adsxhdpi' . $ext);
$imgthumb->imgZoom($path, 1080, 570, $dir . 'adsxxhdpi' . $ext);
}
}
} else {
//获取扩展名
$filename = $fmandroid['name'];
$ext = strtolower(substr($filename, strrpos($filename, '.') + 1));
$filename = 'adshdpi';
$fname = $filename . '.' . $ext;
$path = $dir . $fname;
$arr['img_name'] = $fname;
if (!move_uploaded_file($fmandroid['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmandroid['tmp_name'] . $errorMsg[11] : $fmandroid['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 480, 255, $dir . 'adshdpi' . $ext);
$imgthumb->imgZoom($path, 540, 288, $dir . 'adsmdpi' . $ext);
$imgthumb->imgZoom($path, 720, 380, $dir . 'adsxhdpi' . $ext);
$imgthumb->imgZoom($path, 1080, 570, $dir . 'adsxxhdpi' . $ext);
}
}
}
} else {
if ($fmandroid['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $fmandroid['tmp_name'] . $errorMsg[$fmandroid['error']] : $fmandroid['tmp_name'] . $errorMsg[$fmandroid['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$fmandroid['tmp_name']];
}
}
break;
//ppt安卓
//ppt安卓
case 'pptandroid':
$error = true;
$files = array();
$arr['img_name'] = '';
foreach ($_FILES['file'] as $k => $v) {
foreach ($v as $key => $val) {
$files[$key][$k] = $val;
}
}
foreach ($files as $key => $file) {
if ($file['error'] == 0) {
//获取图片信息
$img_info = getimagesize($file['tmp_name']);
$radio = floor($img_info[0] / $img_info[1] * 100);
if (!($radio > 55 && $radio < 61)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[9] : $file['tmp_name'] . $errorMsg[9];
} else {
$dir = ROOT . $appid . '/';
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
$filename = $file['name'];
$ext = strtolower(substr($filename, strrpos($filename, '.') + 1));
$rand = rand(100, 999);
$filename = $appid . '_' . date("YmdHis") . $rand . "." . $ext;
$path = $dir . $filename;
$newImg = $filename;
$arr['img_name'] = $newImg . ';' . $arr['img_name'];
//创建需要的文件目录
$dir0 = $dir . 'android/' . 'hdpi/';
$dir1 = $dir . 'android/' . 'mdpi/';
$dir2 = $dir . 'android/' . 'xhdpi/';
$dir3 = $dir . 'android/' . 'xxhdpi/';
//echo $path;exit;
if (!move_uploaded_file($file['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[11] : $file['tmp_name'] . $errorMsg[11];
} else {
if (!is_dir($dir0)) {
if (!mkdir($dir0, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
if (!is_dir($dir1)) {
if (!mkdir($dir1, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
if (!is_dir($dir2)) {
if (!mkdir($dir2, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
if (!is_dir($dir3)) {
if (!mkdir($dir3, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
$imgthumb->imgZoom($path, 336, 560, $dir0 . $filename);
$imgthumb->imgZoom($path, 378, 672, $dir1 . $filename);
$imgthumb->imgZoom($path, 504, 896, $dir2 . $filename);
$imgthumb->imgZoom($path, 756, 1344, $dir3 . $filename);
}
}
} else {
if ($file['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[$file['error']] : $file['tmp_name'] . $errorMsg[$file['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$file['tmp_name']];
}
}
}
break;
case 'fmios':
//ios封面图片缩放及上传
$error = true;
$fmios = isset($_FILES['file']) ? $_FILES['file'] : '';
if ($fmios['error'] == 0) {
$dir = ROOT . $appid;
$dir = $dir . '/' . 'ios' . '/' . 'ads' . '/';
$img_info = getimagesize($fmios['tmp_name']);
//图片长宽必烈
$radio = floor($img_info[0] / $img_info[1] * 100);
if (!($radio > 55 && $radio < 65)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmios['tmp_name'] . $errorMsg[9] : $fmios['tmp_name'] . $errorMsg[9];
} else {
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmios['tmp_name'] . $errorMsg[10] : $fmios['tmp_name'] . $errorMsg[10];
} else {
//获取扩展名
//$ext = strrchr($fmios['name'],'.');
$ext = '.png';
$filename = 'adsios';
$path = $dir . $filename . $ext;
$arr['img_name'] = $filename . $ext;
if (!move_uploaded_file($fmios['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmios['tmp_name'] . $errorMsg[11] : $fmios['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 960, 576, $dir . $filename . $ext);
}
}
} else {
//获取扩展名
//$ext = strrchr($fmios['name'],'.');
$ext = '.png';
$filename = 'adsios';
$path = $dir . $filename . $ext;
$arr['img_name'] = $filename . $ext;
if (!move_uploaded_file($fmios['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $fmios['tmp_name'] . $errorMsg[11] : $fmios['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 960, 576, $dir . $filename . $ext);
}
}
}
} else {
if ($fmios['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $fmios['tmp_name'] . $errorMsg[$fmios['error']] : $fmios['tmp_name'] . $errorMsg[$fmios['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$fmios['tmp_name']];
}
}
break;
//ios PPT1
//ios PPT1
case 'pptios1':
$error = true;
$files = array();
$arr['img_name'] = '';
foreach ($_FILES['file'] as $k => $v) {
foreach ($v as $key => $val) {
$files[$key][$k] = $val;
}
}
foreach ($files as $key => $file) {
if ($file['error'] == 0) {
//获取图片信息
$img_info = getimagesize($file['tmp_name']);
$radio = floor($img_info[0] / $img_info[1] * 100);
if (!($radio > 56 && $radio < 60)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[9] : $file['tmp_name'] . $errorMsg[9];
//$this->showMsg("pptitips1",$img_info['name'] . $errorMsg[9]);
} else {
$dir = ROOT . $appid . '/' . 'ios' . '/' . 'shdpi' . '/';
//echo $dir;exit;
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
$filename = substr($file['name'], 0, strpos($file['name'], '.'));
$ext = '.png';
$path = $dir . $filename . $ext;
$newImg = $filename . $ext;
$arr['img_name'] = $newImg . ';' . $arr['img_name'];
if (!move_uploaded_file($file['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[11] : $file['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 780, 1344, $dir . $filename . $ext);
}
}
} else {
if ($file['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[$file['error']] : $file['tmp_name'] . $errorMsg[$file['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$file['tmp_name']];
}
}
}
break;
case 'pptios2':
$error = true;
$files = array();
$arr['img_name'] = '';
foreach ($_FILES['file'] as $k => $v) {
foreach ($v as $key => $val) {
$files[$key][$k] = $val;
}
}
foreach ($files as $key => $file) {
if ($file['error'] == 0) {
//获取图片信息
$img_info = getimagesize($file['tmp_name']);
$radio = floor($img_info[0] / $img_info[1] * 100);
if (!($radio > 70 && $radio < 75)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[9] : $file['tmp_name'] . $errorMsg[9];
} else {
$dir = ROOT . $appid . '/' . 'ios' . '/' . 'bhdpi' . '/';
if (!is_dir($dir)) {
if (!mkdir($dir, 0777, true)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[10] : $file['tmp_name'] . $errorMsg[10];
}
}
$filename = substr($file['name'], 0, strpos($file['name'], '.'));
//$ext = strrchr($file['name'],'.');
$ext = '.png';
$path = $dir . $filename . $ext;
$newImg = $filename . $ext;
$arr['img_name'] = $newImg . ';' . $arr['img_name'];
if (!move_uploaded_file($file['tmp_name'], $path)) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[11] : $file['tmp_name'] . $errorMsg[11];
} else {
$imgthumb->imgZoom($path, 780, 1080, $dir . $filename . $ext);
}
}
} else {
if ($file['error'] > 0) {
$error = false;
$msg = $msg ? $msg . ',' . $file['tmp_name'] . $errorMsg[$file['error']] : $file['tmp_name'] . $errorMsg[$file['error']];
$arr['result'] = 'error';
$arr['msg'] = $errorMsg[$file['tmp_name']];
}
}
}
break;
}
if ($error) {
$arr['result'] = 'success';
$arr['msg'] = $errorMsg['0'];
$arr['num'] = $num;
} else {
$arr['result'] = 'error';
$arr['msg'] = $msg;
$arr['num'] = $num;
}
//json返回
$returnJson = json_encode($arr);
die("<script type='text/javascript'>window.parent.callbackFunction('" . $returnJson . "');</script>");
}
/**
* ajax提交
*/
public function loginAction()
{
$ispost = reqnum('ispost', 0);
if ($ispost == 1) {
$curcode = reqnum('code');
$beforcode = XSession::Get("AdminLoginVcode");
if ($curcode != $beforcode) {
MsgInfoConst::GetMsg(1006, $result);
return $result;
}
$registerName = reqstr('username', '');
$password = reqstr('passwd', '');
$result = array('result' => 'ERROR');
if ($registerName == '' || $password == '') {
MsgInfoConst::GetMsg(1000, $result);
return $result;
}
$memModel = new Psys_AdminUserModel();
$userone = $memModel->Login($registerName, $password, $result);
return $result;
}
$this->forward = "login";
}
public function tasksAction()
{
$appkey = reqstr('appkey', '');
$username = reqstr('username', '');
$taskid = reqstr('taskid', '');
$indate = reqstr('indate', 0);
$todate = reqstr('todate', 0);
$where = '1=1 ';
if (!empty($appkey)) {
$where .= " and appkey='" . $appkey . "'";
}
if (!empty($taskid)) {
$where .= ' and taskid=' . $taskid;
}
if (!empty($username)) {
$where .= " and username='******'";
}
if ($todate > 0) {
$where .= ' and ctime > ' . strtotime($indate);
}
if ($indate > 0) {
$where .= ' and ctime <= ' . strtotime($todate);
}
$page = reqnum("page", 1);
$pagesize = reqnum("pagesize", 10);
$applist = array('61' => '开心消消乐', '49' => '消灭星星2015', '47' => '萌宠泡泡龙', '68' => '凤凰视频', '69' => '哪吒看书', '70' => '微看点');
$m = new Psys_UserModel();
$list = $m->GetList($where, 'id DESC', $page, $pagesize, "*", 'rhi_usertask');
foreach ($list['allrow'] as $key => &$var) {
MsgInfoConst::GetAppKey($var['appkey'], $err);
$var['appkey'] = $err['msg'];
$var['taskid'] = $applist[$var['taskid']];
}
$s_arr = $arr_xip_fw[$appkey];
self::inidate($list['allnum'], $page, $pagesize, count($list['allrow']));
$this->smarty->assign('appkeys', MsgInfoConst::$appkey_arr);
//站点列表
$this->smarty->assign('tasks', $applist);
//站点列表
$this->smarty->assign('list', $list['allrow']);
$this->smarty->assign('psys_base_url', PSYS_BASE_URL);
$this->forward = "tasks";
}
/**
*
* @do ajax 获取月浏览数据
*
* @point public
* @author jerry
* @copyright rockhippo
* @param -
* @return html
*
*/
public function ajaxMonthlypointHtmlAction()
{
$start = reqstr("start", "");
$end = reqstr("end", "");
$PSys_pointModel = new PSys_PageviewModel();
$where["month_>="] = $start;
$where["month_<="] = $end;
$order = "month ASC";
$result = $PSys_pointModel->GetList($where, $order, 0, 0, "*", "rhc_point_monthly");
$total_send_point = $total_use_point = $sign_point = $download_point = $buy_point = $package_point = $huoban_point = $huafei_point = $other_point = 0;
foreach ($result["allrow"] as $k => $v) {
$total_send_point += intval($v["total_send_point"]);
$total_use_point += intval($v["total_use_point"]);
$sign_point += intval($v["sign_point"]);
$download_point += intval($v["download_point"]);
$buy_point += intval($v["buy_point"]);
$package_point += intval($v["package_point"]);
$huoban_point += intval($v["huoban_point"]);
$huafei_point += intval($v["huafei_point"]);
$other_point += intval($v["other_point"]);
$result["allrow"][$k]['total_use_point'] = abs($v["total_use_point"]);
$result["allrow"][$k]['huafei_point'] = abs($v["huafei_point"]);
}
$total_use_point = abs($total_use_point);
$huafei_point = abs($huafei_point);
$this->smarty->assign("data", $result["allrow"]);
$this->smarty->assign("total_send_point", $total_send_point);
$this->smarty->assign("total_use_point", $total_use_point);
$this->smarty->assign("sign_point", $sign_point);
$this->smarty->assign("download_point", $download_point);
$this->smarty->assign("buy_point", $buy_point);
$this->smarty->assign("package_point", $package_point);
$this->smarty->assign("huoban_point", $huoban_point);
$this->smarty->assign("huafei_point", $huafei_point);
$this->smarty->assign("other_point", $other_point);
$this->forward = "ajaxMonthlyPoint";
}
/**
*
* @do 导出excel
*
* @access public
* @author Nick
* @copyright rockhippo
* @param -
* @return -
*
*/
public function ajaxOutputExcelAction()
{
$wordArr = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");
$PSys_AccessModel = new PSys_AccessModel();
//站点数据
$where = array();
$order = "id ASC";
$field = "id,stationname";
$PSys_AccessModel = new PSys_AccessModel();
$station = $PSys_AccessModel->GetList($where, $order, 0, 0, $field, "rha_station");
$fastSearch = reqnum("fastSearch", 0);
//快速查询
$dataStatusFS = reqnum("datastatusFS", 1);
//快速查询合并、比较筛选按钮 1为合并 2为比较 默认合并
$xv = array('00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23');
switch ($fastSearch) {
case 1:
//当天
$date = date("Y-m-d");
$data = array();
if ($dataStatusFS == 1) {
$group = "`hour`";
$dbname = "rha_aclog_hour";
$result = $PSys_AccessModel->getDay($date, $group, $dbname);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '本日-合并';
$Description = '访问统计-访问人数(本日-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "小时");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`hour`,`stationid`";
$dbname = "rha_aclog_hour";
$result = $PSys_AccessModel->getDay($date, $group, $dbname);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '本日-比较';
$Description = '访问统计-访问人数(本日-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "小时");
for ($i = 0; $i < count($xv); $i++) {
$XPhpExcel->setValue("A" . ($i + 2), $i);
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['stationid']][$val['date']] = $val['total'];
}
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < count($xv); $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][$xv[$i]]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case 2:
//本周
$date = date("Y-m-d");
$bdate = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y")));
$edate = date("Y-m-d", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y")));
$data = array();
if ($dataStatusFS == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '本周-合并';
$Description = '访问统计-访问人数(本周-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 14, 2);
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '本周-比较';
$Description = '访问统计-访问人数(本周-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 14, 2);
for ($i = 0; $i < 7; $i++) {
$XPhpExcel->setValue("A" . ($i + 2), date("Y-m-d", strtotime("{$bdate} +{$i} day")));
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < 7; $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][date("Y-m-d", strtotime("{$bdate} +{$i} day"))]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case 3:
//本月
$bdate = date("Y-m-d", mktime(0, 0, 0, date("m"), 1, date("Y")));
$edate = date("Y-m-d", mktime(23, 59, 59, date("m"), date("t"), date("Y")));
$date = date("Y-m");
$data = array();
if ($dataStatusFS == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '本月-合并';
$Description = '访问统计-访问人数(本月-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 14, 2);
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '本月-比较';
$Description = '访问统计-访问人数(本月-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 14, 2);
for ($i = 0; $i < date("t"); $i++) {
$XPhpExcel->setValue("A" . ($i + 2), date("Y-m-d", strtotime("{$bdate} +{$i} day")));
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < date("t"); $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][date("Y-m-d", strtotime("{$bdate} +{$i} day"))]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
default:
$dateSearch = reqstr("dateSearch", "");
$datastatus = reqnum("datastatus", 1);
$stationC = reqstr("stationC");
$stationC = explode(",", $stationC);
$stationChoice = array();
if ($stationC == array()) {
//若为空则为不排除站点
foreach ($station['allrow'] as $key => $val) {
$stationChoice[] = $val['id'];
//选中的站点
}
} else {
foreach ($station['allrow'] as $key => $val) {
if (in_array($val['id'], $stationC)) {
$stationChoice[] = $val['id'];
//选中的站点
}
}
}
switch ($dateSearch) {
case "oneday":
$date = reqstr("oneday");
$data = array();
//x轴数据
$xv = array('00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23');
if ($datastatus == 1) {
$group = "`hour`";
$dbname = "rha_aclog_hour";
$result = $PSys_AccessModel->getDay($date, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '单日-合并';
$Description = '访问统计-访问人数(单日-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "小时");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`hour`,`stationid`";
$dbname = "rha_aclog_hour";
$result = $PSys_AccessModel->getDay($date, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '单日-比较';
$Description = '访问统计-访问人数(单日-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "小时");
for ($i = 0; $i < count($xv); $i++) {
$XPhpExcel->setValue("A" . ($i + 2), $i);
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['stationid']][$val['date']] = $val['total'];
}
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < count($xv); $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][$xv[$i]]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case "manyday":
$bdate = reqstr("bmanyday");
$edate = reqstr("emanyday");
//计算天数差
$Days = round((strtotime($edate) - strtotime($bdate)) / 3600 / 24);
$data = array();
if ($datastatus == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '多日-合并';
$Description = '访问统计-访问人数(多日-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 14, 2);
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '多日-比较';
$Description = '访问统计-访问人数(多日-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 14, 2);
for ($i = 0; $i < $Days; $i++) {
$XPhpExcel->setValue("A" . ($i + 2), date("Y-m-d", strtotime("{$bdate} +{$i} day")));
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
////重过滤$station
// $where = array();
// $where['id_IN'] = $stationChoice;
// $order = "id ASC";
// $field = "id,stationname";
// $station = $PSys_AccessModel->GetList($where, $order, 0, 0, $field, "rha_station");
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < $Days; $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][date("Y-m-d", strtotime("{$bdate} +{$i} day"))]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case "oneweek":
$day = reqstr("oneweek");
$edate = date('Y-m-d', strtotime("{$day} Sunday"));
$bdate = date('Y-m-d', strtotime("{$edate} -6 days"));
//计算天数差
$Days = round((strtotime($edate) - strtotime($bdate)) / 3600 / 24);
$data = array();
if ($datastatus == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '单周-合并';
$Description = '访问统计-访问人数(单周-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 14, 2);
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '单周-比较';
$Description = '访问统计-访问人数(单周-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 14, 2);
for ($i = 0; $i < 7; $i++) {
$XPhpExcel->setValue("A" . ($i + 2), date("Y-m-d", strtotime("{$bdate} +{$i} day")));
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
////重过滤$station
// $where = array();
// $where['id_IN'] = $stationChoice;
// $order = "id ASC";
// $field = "id,stationname";
// $station = $PSys_AccessModel->GetList($where, $order, 0, 0, $field, "rha_station");
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < 7; $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][date("Y-m-d", strtotime("{$bdate} +{$i} day"))]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case "manyweek":
$bday = reqstr("bmanyweek");
$edate2 = date('Y-m-d', strtotime("{$bday} Sunday"));
$bdate = date('Y-m-d', strtotime("{$edate2} -6 days"));
$eday = reqstr("emanyweek");
$edate = date('Y-m-d', strtotime("{$eday} Sunday"));
$bdate2 = date('Y-m-d', strtotime("{$edate} -6 days"));
//计算周数差
$Weeks = round((strtotime($edate) - strtotime($bdate)) / 3600 / 24 / 7);
$data = array();
if ($datastatus == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
foreach ($result as $key => $val) {
$data[$val['date']] = $val['total'];
}
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '多周-合并';
$Description = '访问统计-访问人数(多周-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 25, 2);
$XPhpExcel->setWidth("B", 20, 2);
for ($i = 0; $i < $Weeks; $i++) {
$num = 0;
for ($j = 1; $j <= 7; $j++) {
$day = $i * 7 + $j - 1;
$dt = date("Y-m-d", strtotime("{$bdate} +{$day} day"));
$num += $data[$dt];
if ($j == 1) {
$d = date("Y/m/d", strtotime("{$bdate} +{$day} day"));
}
if ($j == 7) {
$d .= ' - ' . date("m/d", strtotime("{$bdate} +{$day} day"));
$XPhpExcel->setValue("A" . ($i + 2), $d);
$XPhpExcel->setValue("B" . ($i + 2), $num);
}
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '多周-比较';
$Description = '访问统计-访问人数(多周-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 25, 2);
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < $Weeks; $i++) {
$num = 0;
for ($j = 1; $j <= 7; $j++) {
$day = $i * 7 + $j - 1;
$dt = date("Y-m-d", strtotime("{$bdate} +{$day} day"));
$num += $data[$val['id']][$dt];
if ($j == 1) {
$d = date("Y/m/d", strtotime("{$bdate} +{$day} day"));
}
if ($j == 7) {
$d .= ' - ' . date("m/d", strtotime("{$bdate} +{$day} day"));
$XPhpExcel->setValue("A" . ($i + 2), $d);
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $num);
}
}
}
}
//to do nick 2030 celeste
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case "onemonth":
$date = reqstr("onemonth");
$bdate = date("Y-m-01", strtotime($date));
$edate = date("Y-m-d", strtotime("{$bdate} +1 month -1 day"));
$date = date("Y-m", strtotime($date));
$Days = date("t", strtotime($date));
$data = array();
if ($datastatus == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '单月-合并';
$Description = '访问统计-访问人数(单月-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 14, 2);
$XPhpExcel->setWidth("B", 20, 2);
foreach ($result as $key => $val) {
$XPhpExcel->setValue("A" . ($key + 2), $val["date"]);
$XPhpExcel->setValue("B" . ($key + 2), $val["total"]);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($date . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '单月-比较';
$Description = '访问统计-访问人数(单月-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 14, 2);
for ($i = 0; $i < $Days; $i++) {
$XPhpExcel->setValue("A" . ($i + 2), date("Y-m-d", strtotime("{$bdate} +{$i} day")));
}
$data = array();
//遍历数据获取所需结构
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
////重过滤$station
// $where = array();
// $where['id_IN'] = $stationChoice;
// $order = "id ASC";
// $field = "id,stationname";
// $station = $PSys_AccessModel->GetList($where, $order, 0, 0, $field, "rha_station");
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
for ($i = 0; $i < $Days; $i++) {
//echo $wordArr[$val['id']].($i+2) . "~" . $data[$val['id']][$xv[$i]] . "<br>";
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $data[$val['id']][date("Y-m-d", strtotime("{$bdate} +{$i} day"))]);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
case "manymonth":
$bday = reqstr("bmanymonth");
$bdate = date("Y-m-01", strtotime($bday));
$eday = reqstr("emanymonth");
$edate = date("Y-m-d", strtotime("{$eday} +1 month -1 day"));
//计算月数差
$Months = (date("Y", strtotime($eday)) - date("Y", strtotime($bday))) * 12 + (date("m", strtotime($eday)) - date("m", strtotime($bday))) + 1;
for ($i = 0; $i < $Months; $i++) {
$dateArr[$i] = date("Y-m", strtotime("{$bday} +{$i} month"));
}
$data = array();
if ($datastatus == 1) {
$group = "date";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
foreach ($result as $key => $val) {
$data[$val['date']] = $val['total'];
}
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '多月-合并';
$Description = '访问统计-访问人数(多月-合并)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setValue("B1", "人数");
$XPhpExcel->setWidth("A", 25, 2);
$XPhpExcel->setWidth("B", 20, 2);
$day = 0;
for ($i = 0; $i < $Months; $i++) {
$nums = 0;
$num = date("t", strtotime("{$bday} +{$i} month"));
$d = date("Y-m-01", strtotime("{$bday} +{$i} month"));
for ($j = 1; $j <= $num; $j++) {
if ($j == 1) {
$d = date("Y/m", strtotime("{$bday} +{$i} month"));
$XPhpExcel->setValue("A" . ($i + 2), $d);
}
//echo $day."<br/>";
//$data['data'][1]['data'][] = intval($result[$i-1]['total']);
$nums += $data[date("Y-m-d", strtotime("{$bday} +{$day} day"))];
$day++;
}
$XPhpExcel->setValue("B" . ($i + 2), $nums);
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
} else {
$group = "`date`,`station`";
$dbname = "rha_wifi_daily";
$result = $PSys_AccessModel->getWeek($bdate, $edate, $group, $dbname, $stationChoice);
foreach ($result as $key => $val) {
$data[$val['station']][$val['date']] = $val['total'];
}
$XPhpExcel = new XPhpExcel();
$Creator = "statis.rockhippo.com";
$LastModifiedBy = $Creator;
$Title = '访问统计-访问人数';
$Subject = '多月-比较';
$Description = '访问统计-访问人数(多月-比较)';
$Keywords = $Description;
$Category = $Description;
$XPhpExcel->setBasicAttr($Creator, $LastModifiedBy, $Title, $Subject, $Description, $Keywords, $Category);
$XPhpExcel->setSheet(0, $Subject);
$XPhpExcel->setValue("A1", "日期");
$XPhpExcel->setWidth("A", 25, 2);
foreach ($station['allrow'] as $key => $val) {
$XPhpExcel->setValue($wordArr[$val['id']] . "1", $val['stationname'] . "/人数");
$XPhpExcel->setWidth($wordArr[$val['id']], 20, 2);
$day = 0;
for ($i = 0; $i < $Months; $i++) {
$nums = 0;
$num = date("t", strtotime("{$bday} +{$i} month"));
$d = date("Y-m-01", strtotime("{$bday} +{$i} month"));
for ($j = 1; $j <= $num; $j++) {
if ($j == 1) {
$d = date("Y/m", strtotime("{$bday} +{$i} month"));
$XPhpExcel->setValue("A" . ($i + 2), $d);
}
//echo $day."<br/>";
//$data['data'][1]['data'][] = intval($result[$i-1]['total']);
$nums += $data[$val['id']][date("Y-m-d", strtotime("{$bday} +{$day} day"))];
$day++;
}
$XPhpExcel->setValue($wordArr[$val['id']] . ($i + 2), $nums);
}
}
//清空输出缓存
ob_clean();
$XPhpExcel->output($bdate . "~" . $edate . "/" . $Description);
unset($XPhpExcel);
//销毁
}
break;
}
}
}
/**
* 手机品牌、浏览器、系统排行数据
*/
public function mobilerankdataAction()
{
$data = reqstr('data');
if (!$data) {
return;
}
$page = reqnum('page', 1);
$pagesize = 10;
$data = urldecode($data);
$info = array();
parse_str($data, $info);
$date = (int) $info['date'] ? (int) $info['date'] : 7;
//默认是查出7天的数据
$sdate = trim($info['sdate']) ? trim($info['sdate']) : '';
$edate = trim($info['edate']) ? trim($info['edate']) : '';
$station = (int) $info['station'] ? (int) $info['station'] : 0;
// 0 表示查询出所有车站
$type = trim($info['type']) ? trim($info['type']) : 'mobile';
//默认是手机
if (!$sdate || !$edate) {
$edate = date('Y-m-d');
$sdate = date('Y-m-d', strtotime("-{$date} day"));
}
$sdate = str_replace('-', '_', $sdate);
$edate = str_replace('-', '_', $edate);
$nt = new Psys_ResourceModel();
$data = $nt->MobileRankData($sdate, $edate, $station, $type, $page, $pagesize);
$data_graph = $nt->MobileRankData($sdate, $edate, $station, $type, $page, $pagesize, 1);
$paging = $this->paging($data['allnum'], $page, $pagesize, count($data['allrow']));
$stations = $nt->station();
$total = 0;
foreach ($data['allrow'] as &$v) {
if ($station) {
$v['stationname'] = $this->getstationname($stations, $station);
} else {
$v['stationname'] = 'ALL';
}
$total += $v['num'];
}
$phonebrand = array('mobile' => '手机品牌', 'browser' => '浏览器', 'sys' => '手机系统');
$datas[0]['type'] = 'pie';
$datas[0]['name'] = $phonebrand[$type] . '使用占比';
foreach ($data_graph['allrow'] as $v1) {
$datas[0]['data'][] = array($v1['name'], (double) round($v1['num'] / $total * 100, 2));
}
$result['y_cat'] = $datas;
return array('table' => $data['allrow'], 'paging' => $paging, 'graph' => $result);
}
