/** * wifi每7日连接详情数据ajax */ public function wifiweekinfoAction() { $page = reqnum('page', 1); $pagesize = reqnum('rp', 100); //接收排序 $sortname = reqstr('sortname', 'date'); $sortorder = reqstr('sortorder', 'asc'); $isgrahp = reqnum('isgrahp'); $nt = new Psys_StationModel(); $data = $nt->WifiWeekInfo($sortname, $sortorder, $page, $pagesize); if ($data['allnum'] <= 0) { return 0; } //拼接返回的表格数据格式 $res['total'] = $data['allnum']; $res['page'] = $page; $res['rows'] = $data['allrow']; $graph = array(); foreach ($res['rows'] as &$v) { $graph[] = $v['cell'] = array_values($v); array_splice($v, 0, 5); } //拼接统计图数据格式 $nts = new Psys_ResourceModel(); $ydata = array(); if ($isgrahp) { foreach ($graph as $k => $v) { $cat = explode('-', $v[0]); $x_date = $result['x_cat'][] = substr($cat[0], 5) . '-' . substr($cat[1], 5); $sdate = str_replace('/', '_', $cat[0]); $edate = str_replace('/', '_', $cat[1]); $dates = array($sdate, $edate); $eventrecordinfo = $nts->EventRecordInfo($dates, 0, 1, true); //返回特殊点的提示信息 $title = ''; $descript = ''; if (!empty($eventrecordinfo)) { $flag = 1; foreach ($eventrecordinfo as $info) { $infodate = str_replace('_', '-', $info['date']); $infodates = date('m/d', strtotime($infodate)); $title .= '<br /><b>' . $info['title'] . '</b><br />' . $info['descript'] . '<br />'; $descript = '<br />'; } } else { $flag = 0; } $infos['date' . $x_date]['title'] = $title; $infos['date' . $x_date]['descript'] = $descript; //拼接数据 array_shift($v); if (!$flag) { // $datas[0]['data'][] = (int)$v['num']; $totalconn[] = (int) $v[0]; /*$avgdaily[] = (int)$v[1]; $avghour[] = (int)$v[2]; $avgtop[] = (int)$v[3];*/ } else { /*$datas[0]['data'][] = array('y'=>(int)$v['num'], 'marker'=>array('fillColor'=>'#FF0000','lineColor'=>'#FF0000',//设置当前点的颜色 'states'=>array('hover'=>array('fillColor'=>'#FF0000','lineColor'=>'#FF0000'))));//设置当前点鼠标经过的颜色*/ $totalconn[] = array('y' => (int) $v[0], 'marker' => array('fillColor' => '#FF0000', 'lineColor' => '#FF0000', 'states' => array('hover' => array('fillColor' => '#FF0000', 'lineColor' => '#FF0000')))); } /*$totalconn[] = (int)$v[0]; $avgdaily[] = (int)$v[1]; $avghour[] = (int)$v[2]; $avgtop[] = (int)$v[3];*/ $result['y_data'] = array(array('name' => '总连接数', 'data' => $totalconn, 'infos' => $infos)); } return $result; } return $res; }
/** * wifi每7日连接详情数据ajax */ public function wifiweekinfoAction() { $page = reqnum('page', 1); $pagesize = reqnum('rp', 100); //接收排序 $sortname = reqstr('sortname', 'date'); $sortorder = reqstr('sortorder', 'asc'); $isgrahp = reqnum('isgrahp'); $nt = new Psys_StationModel(); $data = $nt->WifiWeekInfo($sortname, $sortorder, $page, $pagesize); if ($data['allnum'] <= 0) { return 0; } //拼接返回的表格数据格式 $res['total'] = $data['allnum']; $res['page'] = $page; $res['rows'] = $data['allrow']; $graph = array(); foreach ($res['rows'] as &$v) { $graph[] = $v['cell'] = array_values($v); array_splice($v, 0, 5); } //拼接统计图数据格式 $ydata = array(); if ($isgrahp) { foreach ($graph as $k => $v) { $cat = explode('-', $v[0]); $result['x_cat'][] = substr($cat[0], 3) . '-' . substr($cat[1], 3); //拼接数据 array_shift($v); $totalconn[] = (int) $v[0]; $avgdaily[] = (int) $v[1]; $avghour[] = (int) $v[2]; $avgtop[] = (int) $v[3]; $result['y_data'] = array(array('name' => '总连接数', 'data' => $totalconn), array('name' => '日均', 'data' => $avgdaily), array('name' => '平均每小时(/h)', 'data' => $avghour), array('name' => '高峰时段(/h)', 'data' => $avgtop)); } return $result; } return $res; }