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