'); $WHILECNT = "0"; $A_DB_TELBOX_TRACE_PATH_GO = "GO"; $A_DB_TELBOX_TRACE_PATH_CUST = ""; $A_DB_TELBOX_TRACE_PATH = ""; $UNTIL1 = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']; while (($A_DB_TELBOX_TRACE_PATH_GO == 'GO') && ($WHILECNT < 50)) { //TODO 2007-04-28 sprawdzic funkcjonalnosc ADM_COMPANY czy nie wyklucza jakiejs opcji programu $UNTIL1_SQL="select T_TELBOX_NEIGHBOUR_IN from TELBOXES where T_TELBOX_NAME='$UNTIL1' and A_ADM_COMPANY like '" .$_SESSION[ADM_COMPANY]. "' ORDER BY ID limit 0,1 "; $UNTIL1_SQL = "select T_TELBOX_NEIGHBOUR_IN from TELBOXES where T_TELBOX_NAME='$UNTIL1' ORDER BY ID limit 0,1 "; ZAP_SQL($UNTIL1_SQL); while ($h = mysql_fetch_row($result)) { $WHILECNT++; $UNTIL1 = $h[0]; } if (mysql_numrows($result) == 0) { $A_DB_TELBOX_TRACE_PATH_GO = "STOP"; } else { $A_DB_TELBOX_TRACE_PATH = $A_DB_TELBOX_TRACE_PATH . " " . $UNTIL1; } } if (($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']) && (!($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS'] == "N/S;"))) { if ($thiss->DETECT_TABLE_NAME == "USERS2") { $ZAP_SQL = "select '',S_ADDRESS_STREET,' ',A_STATUS,' ',S_IP,' ',A_PROBLEM,' ',A_PROBLEM_DESC,'
' from $thiss->DETECT_TABLE_NAME where T_TELBOX_ADDRESS='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS'] . "' and A_ADM_COMPANY like '" . $_SESSION['ADM_COMPANY'] . "' ORDER BY A_STATUS,(substring_index(S_ADDRESS_STREET,'/',-1)+0),ID ;"; } else { $ZAP_SQL = "select '',S_ADDRESS_STREET,' ',A_STATUS,' ',A_PROBLEM,' ',A_PROBLEM_DESC,'
' from $thiss->DETECT_TABLE_NAME where T_TELBOX_ADDRESS='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS'] . "' and A_ADM_COMPANY like '" . $_SESSION['ADM_COMPANY'] . "' ORDER BY ID ;"; } ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { foreach ($h as $value) { $MAKE_ORDERER_TELBOX_USERS_LIST = $MAKE_ORDERER_TELBOX_USERS_LIST . " $value"; } } $ZAP_SQL = "select ID from $thiss->DETECT_TABLE_NAME where T_TELBOX_ADDRESS='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and ( A_STATUS='NORMAL' or A_STATUS='WARNING' or A_STATUS='OFF_SOFT' or A_STATUS='MONITOR' ) and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID ;"; ZAP_SQL($ZAP_SQL); $MAKE_ORDERER_TELBOX_USERS = mysql_numrows($result); $MAKE_ORDERER_TELBOX_USERS="( $MAKE_ORDERER_TELBOX_USERS aktywnych )"; $ZAP_SQL = "select T_TELBOX_NAME,' | ' from TELBOXES where T_TELBOX_NEIGHBOUR_IN='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY T_TELBOX_NAME "; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { foreach ($h as $value) { $MAKE_ORDERER_TELBOX_MAGISTRAL = $MAKE_ORDERER_TELBOX_MAGISTRAL . " $value"; } } $MAKE_ORDERER_TELBOX_MAGISTRAL_OUT_COUNT = mysql_numrows($result); //PATCH 2003-09-30 for BUILDINGS $ZAP_SQL = "select '',t1.S_ADDRESS_STREET,' | ',t1.A_STATUS,t1.S_ADMIN_NAME,t1.P_ADMIN_NAME from BUILDINGS as t1, TELBOXES as t2 where t2.T_TELBOX_NAME='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and t1.S_ADDRESS_STREET = t2.T_TELBOX_BUILDING_IN and t1.A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY t1.S_ADDRESS_STREET "; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { foreach ($h as $value) { $MAKE_ORDERER_BUILDING_INFO = $MAKE_ORDERER_BUILDING_INFO . " $value"; } } $MAKE_ORDERER_BUILDING_INFO_COUNT = mysql_numrows($result); $ZAP_SQL = "select t1.B_INVENTORY_DATE from BUILDINGS as t1, TELBOXES as t2 where t2.T_TELBOX_NAME='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and t1.S_ADDRESS_STREET = t2.T_TELBOX_BUILDING_IN and t1.A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY t1.S_ADDRESS_STREET "; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { $MAKE_ORDERER_BUILDING_INVENTORY_DATE = $h[0]; } //EOF BUILDING PATCH $ZAP_SQL = "select T_TELBOX_NEIGHBOUR_IN,' | ' from TELBOXES where T_TELBOX_NAME='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY T_TELBOX_NAME "; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { foreach ($h as $value) { $MAKE_ORDERER_TELBOX_MAGISTRAL_IN = $MAKE_ORDERER_TELBOX_MAGISTRAL_IN . " $value"; } } $ZAP_SQL = "select ID from $thiss->DETECT_TABLE_NAME where T_TELBOX_ADDRESS='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and ( A_STATUS='NORMAL' or A_STATUS='WARNING' or A_STATUS='OFF_SOFT' or A_STATUS='MONITOR' ) and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID ;"; ZAP_SQL($ZAP_SQL); $MAKE_ORDERER_TELBOX_USERS_COUNT = mysql_numrows($result); // $ZAP_SQL="select ID from DEVICES where T_TELBOX_NEIGHBOUR_IN='".$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][T_TELBOX_ADDRESS]."' and A_ADM_COMPANY like '".$_SESSION[ADM_COMPANY]."' ORDER BY ID ;"; // ZAP_SQL($ZAP_SQL); $ZAP_SQL="select '',T_DEVICE_TYPE,T_PRODUCER,'(',T_DEVICE_PORTS_OK,')',A_STATUS,A_STATUS_INFO,A_PROBLEM,'',A_PROBLEM_DESC,S_ADDRESS_STREET,T_DEVICE_POWER,T_DEVICE_INFO,'Awar:',T_WORKPOINTS,'gwar.',T_GUARRANTY_EXPIRE,'
' from DEVICES where T_TELBOX_NEIGHBOUR_IN='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID ;"; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { foreach ($h as $value) { $MAKE_ORDERER_DEVICES_LIST = $MAKE_ORDERER_DEVICES_LIST . " $value"; } } $MAKE_ORDERER_DEVICES_COUNT = mysql_numrows($result); $ZAP_SQL = "select sum(T_DEVICE_PORTS_OK) from DEVICES where T_TELBOX_NEIGHBOUR_IN='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID ;"; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { $MAKE_ORDERER_DEVICES_PORTS = $h[0]; } $ZAP_SQL = "select ' ',T_TELBOX_NAME,' ','STATUS:', A_STATUS,'(', A_STATUS_INFO, ')
Problemy:', A_PROBLEM,'(',A_PROBLEM_DESC,A_PROBLEM_DATE,')Termin_usuniecia:',S_OTHER_INFO, '
Adresy:',S_ADDRESS_CITY,S_ADDRESS_POST_CODE,S_ADDRESS_POST_OFFICE,S_ADDRESS_STREET,S_ADDRESS_HOUSE,'
Typ:',T_TELBOX_TYPE,'
Zamkniecie:',T_TELBOX_SAVE,'
Zasilanie:',T_TELBOX_POWER,'
Inne inf: ',T_NETWORK_SERVER,'Instalowal:',T_WHO_CONNECTED,T_WHEN_CONNECTED from TELBOXES where T_TELBOX_NAME='".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID limit 0,1 ;"; ZAP_SQL($ZAP_SQL); while ($h = mysql_fetch_row($result)) { foreach ($h as $value) { $MAKE_ORDERER_DEVICE_TELBOX_INFO = $MAKE_ORDERER_DEVICE_TELBOX_INFO . " $value"; } } if ($MAKE_ORDERER_DEVICES_COUNT == 0) { $MAKE_ORDERER_DEVICES_PORTS_FREE = "

Nieznana/niewykryta ilosc wolnych portow - ZINWENTARYZOWAC URZADZENIA W SZAFCE !!!!!!!
NrSeryjny:
Typ (np.SW8):
Producent:
Termin_gwarancji:	-
Dostawca:
Il.Sprawnych Portow:

"; } else { if (!($MAKE_ORDERER_DEVICES_COUNT == 1)) { $MAKE_ORDERER_DEVICES_PORTS_FREE = $MAKE_ORDERER_DEVICES_PORTS - ($MAKE_ORDERER_DEVICES_COUNT * 2 ) + 1 - $MAKE_ORDERER_TELBOX_USERS_COUNT - $MAKE_ORDERER_TELBOX_MAGISTRAL_OUT_COUNT; } else { $MAKE_ORDERER_DEVICES_PORTS_FREE = $MAKE_ORDERER_DEVICES_PORTS - 1 - $MAKE_ORDERER_TELBOX_USERS_COUNT - $MAKE_ORDERER_TELBOX_MAGISTRAL_OUT_COUNT ; } $MAKE_ORDERER_DEVICES_PORTS_FREE = "Ilosc wolnych portow: $MAKE_ORDERER_DEVICES_PORTS_FREE "; } } if (!($MAKE_ORDERER_DEVICE_TELBOX_INFO)) { $MAKE_ORDERER_DEVICE_TELBOX_INFO = "

ZINWENTARYZOWAC SZAFKE !!!!!!!
SZAFKA:	Ul.:_________ Nr:_____ Kl.:_____ Pietro:_____
Typ :
Zamkniecie:
Zasilanie:
Magistrale IN/OUT:	IN:
Abonenci:
ZINWENTARYZOWAC URZADZENIA W SZAFCE !!!!!!!
NrSeryjny:
Typ (np.SW8):
Producent:
Termin_gwarancji:	-
Dostawca:
Il.Sprawnych Portow:

"; } else if (($MAKE_ORDERER_BUILDING_INFO_COUNT == 1) && (strlen($MAKE_ORDERER_BUILDING_INVENTORY_DATE) < 3)) { $MAKE_ORDERER_BUILDING_INFO = "

ZINWENTARYZOWAC BUDYNEK (ost. akt. $MAKE_ORDERER_BUILDING_INVENTORY_DATE) !!!!!!!
$MAKE_ORDERER_BUILDING_INFO

"; } else if (($MAKE_ORDERER_BUILDING_INFO_COUNT == 1) && (strlen($MAKE_ORDERER_BUILDING_INVENTORY_DATE) > 3)) { $MAKE_ORDERER_BUILDING_INFO="
Inf.Budynkowa: $MAKE_ORDERER_BUILDING_INFO , data akt.: $MAKE_ORDERER_BUILDING_INVENTORY_DATE"; } echo " "; // 2012-10-03 // TODO: empty $MAKE_ORDERER_BUILDING_INFO // TODO: pole P_SERVICE: $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_SERVICE'] // TODO: brak pola P_SERVICE_CLASS: $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_SERVICE_CLASS'] // TODO: brak pola P_DEVICE: $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEVICE'] // fetch user data from `BILLING_USERS_ADD` $out_P_NAME = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_NAME']; $out_P_PHONE = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_PHONE']; $out_P_FAX = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_FAX']; $sql = "select P_NAME , P_NAME_SECOND , P_ADDRESS_STREET , P_ADDRESS_HOME , P_ADDRESS_HOUSE , id_users , P_PHONE , P_FAX , P_CONTACT_PERSON from `BILLING_USERS_ADD` where `id_users`='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_BILLING_USERS'] . "' "; ZAP_SQL($sql); if ($h = mysql_fetch_assoc($result)) { $out_P_NAME = $h['P_NAME'] . ' ' . $h['P_NAME_SECOND']; $out_P_PHONE = $h['P_PHONE']; $out_P_FAX = $h['P_FAX']; } // fetch user deal data from `DEALS_TABLE` $out_P_DEALNUMBER = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEALNUMBER']; $out_P_DEAL_DATE = $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEAL_DATE']; // DEALS_TABLE.P_DEALPREFIX as DEALS_TABLE_P_DEALPREFIX , DEALS_TABLE.P_DEALNUMBER as DEALS_TABLE_P_DEALNUMBER , DEALS_TABLE.P_DEALNUMBER_OLD as DEALS_TABLE_P_DEALNUMBER_OLD , // DEALS_TABLE.P_DEALDATE as DEALS_TABLE_P_DEALDATE, DEALS_TABLE.P_DEALDATE_TERM as DEALS_TABLE_P_DEALDATE_TERM //echo "P_DEAL_DATE".$TAB2."'$h->DEALS_TABLE_P_DEALDATE'".$TAB ; //echo "P_DEALNUMBER".$TAB2."'".strstr($h->t6_BILLING_OWNER_EMAIL,'@')."/$h->DEALS_TABLE_P_DEALPREFIX/$h->DEALS_TABLE_P_DEALNUMBER $h->DEALS_TABLE_P_DEALNUMBER_OLD'".$TAB ; //echo "P_DEALEXPIRE".$TAB2."'$h->DEALS_TABLE_P_DEALDATE_TERM'".$TAB ; //echo "P_BILLING_NO".$TAB2."'$h->ID_SERVICES'".$TAB ; $sql = "select t2.A_STATUS as A_STATUS , t2.HANGUP_FROM , t2.HANGUP_TILL , t2.HANGUP_STATUS , t2.ABONAMENT_VALUE , d.P_DEALNUMBER , d.P_DEALDATE from `SERVICES` as t2 left join `DEALS_TABLE` as d on (d.`ID`=t2.`ID_DEALS_TABLE`) where t2.`ID`='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_SERVICES'] . "' "; ZAP_SQL($sql); if ($h = mysql_fetch_assoc($result)) { $out_P_DEALNUMBER = $h['P_DEALNUMBER']; $out_P_DEAL_DATE = $h['P_DEALDATE']; } // fetch user billing owner data from `BILLING_OWNER` $sql = "select BO.name1 as OPERATOR from BILLING_USERS BU join BILLING_OWNER BO on BU.BILLING_OWNER=BO.ID where BU.`ID`='" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID_BILLING_USERS'] . "' "; ZAP_SQL($sql); if ($h = mysql_fetch_assoc($result)) { $out_OPERATOR = $h['OPERATOR']; } echo "

$ARG1_VAL status: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_STATUS'] . " Nr " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['ID'] . " z dnia " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DATE'] . " Dodatk. Info. " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_STATUS_INFO'] . " ---- Other Info: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_OTHER_INFO'] . " Wystawil: " . $_SESSION['ADM_NAME'] . " (" . $_SESSION['ADM_ACCOUNT'] . ") Poziom:" . $_SESSION['ADM_ADMIN_LEVEL'] . " Zasieg: " . $_SESSION['ADM_AREA'] . "(" . $_SESSION['ADM_COMPANY'] . ")
Poziom problemu:" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM'] . " Opis Problemu: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['A_PROBLEM_DESC'] . "
*Dane Klienta*	*Dane Uslugi*
Operator: " .$out_OPERATOR . " Umowa: " . $out_P_DEALNUMBER . " z dnia: " . $out_P_DEAL_DATE . " Abonent: " . $out_P_NAME . " Kontakty: " . $out_P_PHONE . " Fax:" . $out_P_FAX . " Adres: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_ADDRESS_STREET'] . " Budynek: $MAKE_ORDERER_BUILDING_INFO Telbox_info:$MAKE_ORDERER_DEVICE_TELBOX_INFO Dev: $MAKE_ORDERER_DEVICES_LIST Port: $MAKE_ORDERER_DEVICES_PORTS_FREE Magist: $MAKE_ORDERER_TELBOX_MAGISTRAL IN: $MAKE_ORDERER_TELBOX_MAGISTRAL_IN Sciezka: $A_DB_TELBOX_TRACE_PATH	Usluga " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_SERVICE'] . " Klasa uslugi: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_SERVICE_CLASS'] . " Dodatkowe urzadzenie: ". $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['P_DEVICE'] . " Hostname: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_HOST'] . " Domena: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_DOMAIN'] . " Username: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_ACCOUNT'] . " (" . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_ALIAS'] . ") Password: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_PASSWD'] . " IP: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_IP'] . " MAC: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_HW'] . " MAC_STATUS: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['S_HWSTAT'] . " Telbox: " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_ADDRESS'] . " / " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TELBOX_PORT'] . " Serwer Sieciowy : " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_NETWORK_SERVER'] . " / " . $_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['T_TOPOLOGY_PLACE'] . " Spotkania : Data ".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['L_APPOITMENT_DATE']." Pracownik: ".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['L_APPOITMENT_USER']." Dlugosc spotkania: ".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['L_APPOITMENT_PERIOD']."min Informacje dodatkowe:".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['L_APPOITMENT_INFO']." Typ spotkania:".$_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD']['L_APPOITMENT_TYPE']." (ARRANGED=umowione) $MAKE_ORDERER_TELBOX_USERS_LIST $MAKE_ORDERER_TELBOX_USERS
Potwierdzenie Wykonania	$ARG1_VAL Wykonal
Rozpoczete platne godziny [....] x 30PLN Dnia ........................ Podpis Abonenta .........................	Dnia ........................ Podpis Pracownika .........................