";
echo "";
echo "| ".$h[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_NAME]]." |
";
echo " |
";
echo " | ";
echo "|
(".$h[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM]].") Typ:".$h[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_TYPE]]."[.............................................] Zabezpiecznie:".$h[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_SAVE]]."[.........................] Zasilanie:".$h[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_POWER]]."[...............................][OK] |
";
echo " | ";
echo "| Abonenci | ";
$zap_SQLABO="select S_ADDRESS_STREET,A_STATUS,A_PROBLEM,A_PROBLEM_DESC from USERS2 where T_TELBOX_ADDRESS='$ARG1_VAL'";
$result_abo = mysql_query($zap_SQLABO,$conn) or die("Blad zapytania3!\n $zap_SQLABO");
$TEMPTOT=0; $TEMPOK=0;
while ($i=mysql_fetch_row($result_abo)) {
$ABO_A_PROBLEM_COLOR=USERS_COLUMN_COLOR_RETURN(A_PROBLEM,$i[2],color);
echo "($i[0] $i[1] $i[2] ), ";
$TEMPTOT++;
if(($i[1]==NORMAL) || ($i[1]==WARNING) || ($i[1]==OFF_SOFT) ) $TEMPOK++;
}
echo "($TEMPTOT uzytkownikow ($TEMPOK aktywnych)) [OK]";
echo " |
";
echo "| Urzadzenia | ";
$zap_SQLDEV="select * from DEVICES where T_TELBOX_NEIGHBOUR_IN='$ARG1_VAL'";
$result_dev = mysql_query($zap_SQLDEV,$conn) or die("Blad zapytania3!\n $zap_SQLDEV");
while ($j=mysql_fetch_row($result_dev)) {
$DEV_A_STATUS_COLOR=USERS_COLUMN_COLOR_RETURN(A_STATUS,$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][A_STATUS]],color);
$DEV_A_PROBLEM_COLOR=USERS_COLUMN_COLOR_RETURN(A_PROBLEM,$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][A_PROBLEM]],color);
echo "X".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_DEVICE_TYPE]]."(spr. ".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_DEVICE_PORTS_OK]]." [......]) $DEV_A_PROBLEM_COLORS_INF: ".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][A_STATUS_INFO]]." | ".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_DEVICE_INFO]]." |SN:".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_DEVICE_SERIAL]]."[........................] |Producent:".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_PRODUCER]]."[.......................] |gwarancja do:".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_GUARRANTY_EXPIRE]]."[.............] |Zasil.:".$j[$_SESSION[DEVICES_COLUMN][DESC_TO_KEY][T_DEVICE_POWER]]."[..............] [OK]
";
}
echo "X Typ:[.................] Sprawnych_Portow:[..............] Nr/Ser:[..............................] Producent:[..............................] Gwarancja_do:[.............] Zasil.:[..................]";
echo " |
";
echo "| Magistrale | ";
echo "";
$zap_SQLMIN="select * from TELBOXES where T_TELBOX_NAME='".$h[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_NEIGHBOUR_IN]]."' ";
$result_min = mysql_query($zap_SQLMIN,$conn) or die("Blad zapytania5!\n $zap_SQLMIN");
while ($l=mysql_fetch_row($result_min)) {
$MIN_A_PROBLEM_COLOR=USERS_COLUMN_COLOR_RETURN(A_PROBLEM,$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM]],color);
$MIN_A_STATUS_COLOR=USERS_COLUMN_COLOR_RETURN(A_STATUS,$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_STATUS]],color);
// echo "".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_NAME]]." $MIN_A_PROBLEM_COLORP_DATE:".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM_DATE]]." |S_INF: ".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM_DESC]]." | Opis:".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM_DESC]]."Data:".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM_DATE]]." | Typ:".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_TYPE]]." |Zabezp: ".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_SAVE]]." |V: ".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_POWER]]."
";
echo "".$l[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_NAME]]."[.....................][OK] | ";
}
//echo " ";
$zap_SQLMOUT="select * from TELBOXES where T_TELBOX_NEIGHBOUR_IN='$ARG1_VAL'";
$result_mout = mysql_query($zap_SQLMOUT,$conn) or die("Blad zapytania4!\n $zap_SQLMOUT");
while ($k=mysql_fetch_row($result_mout)) {
$MOUT_A_STATUS_COLOR=USERS_COLUMN_COLOR_RETURN(A_STATUS,$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_STATUS]],color);
$MOUT_A_PROBLEM_COLOR=USERS_COLUMN_COLOR_RETURN(A_PROBLEM,$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM]],color);
// echo "".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_NAME]]."$MOUT_A_PROBLEM_COLOR S_INF: ".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM_DESC]]." | Opis:".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][A_PROBLEM_DESC]]." Typ:".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_TYPE]]." |Zabezp: ".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_SAVE]]." |V: ".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_POWER]]."
";
echo " | ".$k[$_SESSION[TELBOX_COLUMN][DESC_TO_KEY][T_TELBOX_NAME]]."[.....................][OK] | ";
}
echo "[.....................] | [.....................] | [.....................] |
";
echo " |
";
}
}
$MENU_INIT="DOL";
}