} $res = array(); $res['img'] = $img; $res['img1'] = $img1; $res = json_encode($res); exit($res); } } else { $roomsname = array(); foreach ($roomsChkIds as $item) { $roomsname[] = "'" . $roomsIds[$item] . "'"; } $list = array(); if (count($roomsname) > 0) { $rooms = implode(',', $roomsname); $list = MroomRateCompare::getMroomsRateAvgData($start_date, $end_date, $rooms, $contrastIndex); } //中国地图数据 $aRoomData = array(); //机房地图 foreach ($list as $item) { $aRoomItem = array(); $aRoomItem['name'] = $item['CLIENT_REGION']; $aRoomItem['value'] = $item['RTT']; //平均值 $aRoomData[] = $aRoomItem; } $aRoomData = json_encode($aRoomData); //导出功能 if ($command == 'exportMroomRateAvgCsv') { $tableHead = array('CLIENT_REGION' => '地区', 'RTT' => '平均值');
$tableItem['VUL_1'] = $item['A_MROOM_P99']; $tableItem['VUL_2'] = $item['B_MROOM_P99']; $tableItem['VUL_3'] = $item['A_MROOM_IQR']; $tableItem['VUL_4'] = $item['B_MROOM_IQR']; } } } } } } $aRoomData[] = $aRoomItem; $bRoomData[] = $bRoomItem; $tableList[] = $tableItem; } //处理英文与中文国家的映射 $countrys = MroomRateCompare::getCountryEchart(); foreach ($countrys as $value) { $mapName[$value['NAME_EN']] = $value['NAME_CN']; } //消除null值对图表展示的影响 foreach ($roomData as &$row) { foreach ($row as &$value) { if ($value === null) { $value = '0'; } } } //为bar添加默认值 if (empty($roomData)) { $roomData = array("name" => array(''), 'avalue' => array(0), 'bvalue' => array(0)); }
$_POST['b_roomname'] = empty($_POST['b_roomname']) ? $ndroom[1]['NAME'] : $_POST['b_roomname']; $_POST['showType'] = empty($_POST['showType']) ? 1 : $_POST['showType']; $_POST['contrastIndex'] = empty($_POST['contrastIndex']) ? 1 : $_POST['contrastIndex']; //对比指标 extract($_POST, EXTR_IF_EXISTS); if (isset($_SERVER["HTTP_X_REQUESTED_WITH"]) && strtolower($_SERVER["HTTP_X_REQUESTED_WITH"]) == "xmlhttprequest") { if ($ajaxMethod == "getMaxAndMinTimeById") { //处理ajax请求获取测试机房的最大时间区间 $roomid = $_POST['roomid']; $res = MroomRateCompare::getMaxTimeRange($roomid, 'splunk_mroom_compare_rtt'); echo $res === false ? json_encode(array("status" => false)) : json_encode(array("status" => true, "datas" => $res)); exit; //处理ajax完毕,避免多余输出 } } else { $list = MroomRateCompare::getRateCompareData($start_date, $end_date, $a_roomname, $b_start_date, $b_end_date, $b_roomname, $contrastIndex, $showType); //中国地图数据 $aRoomData = array(); //a机房地图 $bRoomData = array(); //b机房地图 $roomData = array(); //a-b机房柱状图 $tableList = array(); $tableHead = array(); foreach ($list as $item) { $aRoomItem = array(); $aRoomItem['name'] = $item['CLIENT_REGION']; $bRoomItem = array(); $bRoomItem['name'] = $item['CLIENT_REGION']; $roomData['name'][] = $item['CLIENT_REGION'];