query($query);
$COMPANIES=$db->fetch($result) or die("Error 2");
if ($SES_A['S_IP']=="") $SES_A['S_IP']="Nie przydzielono adresu IP!";
else {
$IP_a=explode('.',$SES_A['S_IP']);
$SUBNET_MASK="255.255.255.0";
$GATEWAY=$IP_a[0].".".$IP_a[1].".".$IP_a[2].".1";
}
if (preg_match("/^[[:alpha:]_]*/",$SES_A['S_ADDRESS_STREET'],$ULICA)) {
$BUDYNEK_MIESZKANIE=substr($SES_A['S_ADDRESS_STREET'],strlen($ULICA[0]));
if (preg_match("/^[[:digit:]]*/",$BUDYNEK_MIESZKANIE,$BUDYNEK)) {
$query="select * from BUILDINGS where S_ADDRESS_STREET like '".$ULICA[0].$BUDYNEK[0]."%' limit 1";
$result=$db->query($query);
if ($BUILDINGS=$db->fetch($result)) {
$ADRES=$BUILDINGS->S_ADDRESS_CITY.", ". preg_replace("/[[:digit:]].*/","",$BUILDINGS->S_ADDRESS_STREET_FULL)." ".$BUDYNEK_MIESZKANIE;
}
}
}
if (!isset($ADRES)) $ADRES=$SES_A['S_ADDRESS_STREET'];
$DOWNLOAD=$SES_A['P_SERVICE_QUOTA'];
$UPLOAD=$DOWNLOAD*$SES_A['P_SERVICE_UPLOAD_RATIO'];
if ($DOWNLOAD<1024) $DOWNLOAD.=" Kbps";
else $DOWNLOAD=($DOWNLOAD/1024)." Mbps";
if ($UPLOAD<1024) $UPLOAD.=" Kbps";
else $UPLOAD=($UPLOAD/1024)." Mbps";
$STATUSY=array("YES"=>"Tak","NO"=>"Nie","UNKNOWN"=>"Nie wiadomo");
$DZIERZAWA_ROUTERA=$STATUSY[$SES_A['S_SOHO_WIFI_ROUTER_1292']];
$PODZIAL_LACZA=$STATUSY[$SES_A['CONN_DIV']];
$PUBLICZNY_ADRES_IP=$STATUSY[$SES_A['S_PUBLIC_IP']];
$PRZEKIEROWANIE_PORTOW=$STATUSY[$SES_A['S_E_PORT_1293']];
if ($PODZIAL_LACZA=="Nie" && $DZIERZAWA_ROUTERA=="Tak") $PODZIAL_LACZA.= " (Jest dzierżawa routera, a nie ma podziału łącza!)";
$query="select * from EXTRA_SERVICES where ID_SERVICES='".$SES_A['ID_SERVICES']."' and E_SERVICE='E_NAT_IP' and T_NETWORK_SERVER='".$SES_A['T_NETWORK_SERVER']."'";
$result=$db->query($query);
if (!$db->num_rows($result)) {
if ($PUBLICZNY_ADRES_IP=="Tak") $PUBLICZNY_ADRES_IP.=" (Nie przydzielono!)";
elseif ($PUBLICZNY_ADRES_IP=="Nie wiadomo") $PUBLICZNY_ADRES_IP="Nie";
}
elseif ($db->num_rows($result)>1) {
if ($PUBLICZNY_ADRES_IP=="Nie wiadomo") $PUBLICZNY_ADRES_IP="Tak";
$PUBLICZNY_ADRES_IP.= " (Przydzielono więcej niż jeden adres IP!)";
}
else {
$EXTRA_SERVICES=$db->fetch($result);
if ($PUBLICZNY_ADRES_IP=="Nie wiadomo") $PUBLICZNY_ADRES_IP="Tak";
if ($PUBLICZNY_ADRES_IP=="Tak") $PUBLICZNY_ADRES_IP.=" (".$EXTRA_SERVICES->E_S_V.")";
else $PUBLICZNY_ADRES_IP.=" (A jest przydzielony adres IP ".$EXTRA_SERVICES->E_S_V."!)";
}
$query="select * from EXTRA_SERVICES where ID_SERVICES='".$SES_A['ID_SERVICES']."' and E_SERVICE='E_PORT' and T_NETWORK_SERVER='".$SES_A['T_NETWORK_SERVER']."'";
$result=$db->query($query);
if (!$db->num_rows($result)) {
if ($PRZEKIEROWANIE_PORTOW=="Tak") $PRZEKIEROWANIE_PORTOW.= " (Nie przekierowano żadnych portów!)";
elseif ($PRZEKIEROWANIE_PORTOW=="Nie wiadomo") $PRZEKIEROWANIE_PORTOW="Nie";
}
else {
while ($EXTRA_SERVICES=$db->fetch($result)) {
if ($EXTRA_SERVICES->E_S_V=="TCP_UDP") $PORTY_a[]=$EXTRA_SERVICES->E_S_V2;
elseif ($EXTRA_SERVICES->E_S_V=="TCP_UDP_RANGE") $PORTY_a[]=$EXTRA_SERVICES->E_S_V2."-".$EXTRA_SERVICES->E_S_V3;
}
$PORTY=implode(",",$PORTY_a);
if ($PRZEKIEROWANIE_PORTOW=="Nie wiadomo") $PRZEKIEROWANIE_PORTOW="Tak";
if ($PRZEKIEROWANIE_PORTOW=="Tak") $PRZEKIEROWANIE_PORTOW.=" (".$PORTY.")";
else $PRZEKIEROWANIE_PORTOW.= " (A są przekierowano porty ".$PORTY."!)";
}
echo "
".$COMPANIES->OPERATOR."
|
| Abonent: | ".$COMPANIES->P_NAME." ".$COMPANIES->P_NAME_SECOND." |
| Adres instalacji: | ".$ADRES." |
| ID usługi: | ".$SES_A['ID_SERVICES']." |
Parametry usługi dostępu do Internetu: |
| Prędkość pobierania: | ".$DOWNLOAD." |
| Prędkość wysyłania: | ".$UPLOAD." |
";
// | Podział łącza: | ".$PODZIAL_LACZA." |
echo "
| Dzierżawa routera: | ".$DZIERZAWA_ROUTERA." |
| Publiczny adres IP: | ".$PUBLICZNY_ADRES_IP." |
| Przekierowanie portów: | ".$PRZEKIEROWANIE_PORTOW." |
Konfiguracja protokołu TCP/IP: |
| Adres IP: | ".$SES_A['S_IP']." |
| Maska podsieci: | ".$SUBNET_MASK." |
| Brama domyślna: | ".$GATEWAY." |
| Preferowany serwer DNS: | ".$GATEWAY." |
| |
| Zarejestrowany adres fizyczny (MAC): |
";
if (V::get('action', '', $_GET) == "se-detect") {
if ($SES_A['S_HWSTAT'] == "FIXED") {
$result=file_get_contents("http://se.dev.webone.pl/odblokuj.php?action=se-detect&komp=".$SES_A['S_IP']."&ADM_ACCOUNT=".$_SESSION['ADM_ACCOUNT']);
$result_a=explode("\n",$result);
if ($result_a[0]=="OK") $SES_A['S_HWSTAT']="DETECT";
else $result_a[0].=" (".$result_a[1].")";
} else $result_a[0]= "ERROR (adres MAC już wcześniej został odblokowany!)";
}
if ($SES_A['S_HWSTAT']=="FIXED") echo $SES_A['S_HW']." (odblokuj)";
else echo "odblokowany";
if (V::get('action', '', $_GET) == "se-detect") echo " |
|
| Wynik odblokowania: | ".$result_a[0];
#echo "";
#print_r($_SESSION);
#echo " ";
echo " |
";
}
function ZLECENIE() {
$TYP_ZLECENIA = V::get('TYP_ZLECENIA', '', $_GET);
$ID_SERVICES = V::get('ID_SERVICES', '', $_GET);
$db = DB::getDB();
$query="select NAME_LIST_SERVICES from SERVICES where ID='".$ID_SERVICES."';";
$result=$db->query($query);
$row=$db->fetch($result) or die('Error 0');
$NAME_LIST_SERVICES=$row->NAME_LIST_SERVICES;
$query="select * from SES_".$NAME_LIST_SERVICES."_A where ID_SERVICES='".$ID_SERVICES."';";
$result=$db->query($query);
$SES_A=$db->fetch_array($result) or die('Error 1');
if ($TYP_ZLECENIA=="KONFIGURACJA" && $NAME_LIST_SERVICES == "USERS2") {
ZLECENIE_KONFIGURACJA($SES_A);
exit();
}
$WHILECNT = "0";
$A_DB_TELBOX_TRACE_PATH_GO = "GO";
$A_DB_TELBOX_TRACE_PATH_CUST = "";
$A_DB_TELBOX_TRACE_PATH = "";
$UNTIL1 = $SES_A['T_TELBOX_ADDRESS'];
while (($A_DB_TELBOX_TRACE_PATH_GO == 'GO') && ($WHILECNT < 50)) {
$query = "select T_TELBOX_NEIGHBOUR_IN from TELBOXES where T_TELBOX_NAME='$UNTIL1' ORDER BY ID limit 0,1 ";
$result=$db->query($query) or die("Error 2");
while ($h = $db->fetch_row($result)) {
$WHILECNT++;
$UNTIL1 = $h[0];
}
if ($db->num_rows($result) == 0) {
$A_DB_TELBOX_TRACE_PATH_GO = "STOP";
} else {
$A_DB_TELBOX_TRACE_PATH = $A_DB_TELBOX_TRACE_PATH . " " . $UNTIL1;
}
}
if (($SES_A['T_TELBOX_ADDRESS']) && (!($SES_A['T_TELBOX_ADDRESS'] == "N/S;"))) {
if ($NAME_LIST_SERVICES == "USERS2") {
$query="select '',S_ADDRESS_STREET,' ',A_STATUS,' ',S_IP,' ',A_PROBLEM,' ',A_PROBLEM_DESC,'
' from SES_".$NAME_LIST_SERVICES."_A where T_TELBOX_ADDRESS='" . $SES_A['T_TELBOX_ADDRESS'] . "' and A_ADM_COMPANY like '" . $_SESSION['ADM_COMPANY'] . "' ORDER BY A_STATUS,(substring_index(S_ADDRESS_STREET,'/',-1)+0),ID ;";
} else {
$query="select '',S_ADDRESS_STREET,' ',A_STATUS,' ',A_PROBLEM,' ',A_PROBLEM_DESC,'
' from SES_".$NAME_LIST_SERVICES."_A where T_TELBOX_ADDRESS='" . $SES_A['T_TELBOX_ADDRESS'] . "' and A_ADM_COMPANY like '" . $_SESSION['ADM_COMPANY'] . "' ORDER BY ID ;";
}
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
foreach ($h as $value) {
$MAKE_ORDERER_TELBOX_USERS_LIST = $MAKE_ORDERER_TELBOX_USERS_LIST . " $value";
}
}
$query = "select ID from SES_".$NAME_LIST_SERVICES."_A where T_TELBOX_ADDRESS='".$SES_A['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 ;";
$result=$db->query($query);
$MAKE_ORDERER_TELBOX_USERS = $db->num_rows($result);
$MAKE_ORDERER_TELBOX_USERS="( $MAKE_ORDERER_TELBOX_USERS aktywnych )";
$query = "select T_TELBOX_NAME,' | ' from TELBOXES where T_TELBOX_NEIGHBOUR_IN='".$SES_A['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY T_TELBOX_NAME ";
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
foreach ($h as $value) {
$MAKE_ORDERER_TELBOX_MAGISTRAL = $MAKE_ORDERER_TELBOX_MAGISTRAL . " $value";
}
}
$MAKE_ORDERER_TELBOX_MAGISTRAL_OUT_COUNT = $db->num_rows($result);
//PATCH 2003-09-30 for BUILDINGS
$query="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='".$SES_A['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 ";
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
foreach ($h as $value) {
$MAKE_ORDERER_BUILDING_INFO = $MAKE_ORDERER_BUILDING_INFO . " $value";
}
}
$MAKE_ORDERER_BUILDING_INFO_COUNT = $db->num_rows($result);
$query = "select t1.B_INVENTORY_DATE from BUILDINGS as t1, TELBOXES as t2 where t2.T_TELBOX_NAME='".$SES_A['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 ";
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
$MAKE_ORDERER_BUILDING_INVENTORY_DATE = $h[0];
}
//EOF BUILDING PATCH
$query = "select T_TELBOX_NEIGHBOUR_IN,' | ' from TELBOXES where T_TELBOX_NAME='".$SES_A['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY T_TELBOX_NAME ";
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
foreach ($h as $value) {
$MAKE_ORDERER_TELBOX_MAGISTRAL_IN = $MAKE_ORDERER_TELBOX_MAGISTRAL_IN . " $value";
}
}
$query = "select ID from SES_".$NAME_LIST_SERVICES."_A where T_TELBOX_ADDRESS='".$SES_A['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 ;";
$result=$db->query($query);
$MAKE_ORDERER_TELBOX_USERS_COUNT = $db->num_rows($result);
$query="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='".$SES_A['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID ;";
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
foreach ($h as $value) {
$MAKE_ORDERER_DEVICES_LIST = $MAKE_ORDERER_DEVICES_LIST . " $value";
}
}
$MAKE_ORDERER_DEVICES_COUNT = $db->num_rows($result);
$query = "select sum(T_DEVICE_PORTS_OK) from DEVICES where T_TELBOX_NEIGHBOUR_IN='".$SES_A['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID ;";
$result=$db->query($query);
while ($h = $db->fetch_row($result)) {
$MAKE_ORDERER_DEVICES_PORTS = $h[0];
}
$query = "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='".$SES_A['T_TELBOX_ADDRESS']."' and A_ADM_COMPANY like '".$_SESSION['ADM_COMPANY']."' ORDER BY ID limit 0,1 ;";
$result=$db->query($query);
while ($h = $db->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 = $SES_A['P_NAME'];
$out_P_PHONE = $SES_A['P_PHONE'];
$out_P_FAX = $SES_A['P_FAX'];
$query="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`='" . $SES_A['ID_BILLING_USERS'] . "'
";
$result=$db->query($query);
if ($h = $db->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 = $SES_A['P_DEALNUMBER'];
$out_P_DEAL_DATE = $SES_A['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 ;
$query="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`='" . $ID_SERVICES . "'
";
$result=$db->query($query);
if ($h = $db->fetch_assoc($result)) {
$out_P_DEALNUMBER = $h['P_DEALNUMBER'];
$out_P_DEAL_DATE = $h['P_DEALDATE'];
}
// fetch user billing owner data from `BILLING_OWNER
$query = "select
BO.name1 as OPERATOR
from BILLING_USERS BU
join BILLING_OWNER BO on BU.BILLING_OWNER=BO.ID
where BU.`ID`='" . $SES_A['ID_BILLING_USERS'] . "'
";
$result=$db->query($query);
if ($h = $db->fetch_assoc($result)) {
$out_OPERATOR = $h['OPERATOR'];
}
?>
$USLUGI=array("USERS2"=>"Internet","TV"=>"Telewizja","VOIP"=>"Telefon");
echo "
".$TYP_ZLECENIA." status: " . $SES_A['A_STATUS'] . " Nr " . $SES_A['ID'] . " z dnia " . $SES_A['A_PROBLEM_DATE'] . "
Dodatk. Info: " . $SES_A['A_STATUS_INFO'] . " , Other Info: " . $SES_A['S_OTHER_INFO'] . " Wystawil:
" . $_SESSION['ADM_NAME'] . " (" . $_SESSION['ADM_ACCOUNT'] . ") Poziom:" . $_SESSION['ADM_ADMIN_LEVEL'] . " Zasieg: " . $_SESSION['ADM_COMPANY'] . "
|
Poziom problemu:" . $SES_A['A_PROBLEM'] . "
Opis Problemu: " . $SES_A['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: " . $SES_A['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: ".$USLUGI[$NAME_LIST_SERVICES]." (" . $SES_A['P_SERVICE'] . ")
Klasa uslugi: " . $SES_A['P_SERVICE_CLASS'] . "
Dodatkowe urzadzenie: ". $SES_A['P_DEVICE'] . "
Hostname: " . $SES_A['S_HOST'] . " Domena: " . $SES_A['S_DOMAIN'] . "
Username: " . $SES_A['S_ACCOUNT'] . " (" . $SES_A['S_ALIAS'] . ")
Password: " . $SES_A['S_PASSWD'] . "
IP: " . $SES_A['S_IP'] . "
MAC: " . $SES_A['S_HW'] . " MAC_STATUS: " . $SES_A['S_HWSTAT'] . "
Telbox: " . $SES_A['T_TELBOX_ADDRESS'] . " / " . $SES_A['T_TELBOX_PORT'] . "
Serwer Sieciowy : " . $SES_A['T_NETWORK_SERVER'] . " / " . $SES_A['T_TOPOLOGY_PLACE'] . "
Spotkania : Data ".$SES_A['L_APPOITMENT_DATE']." Pracownik: ".$SES_A['L_APPOITMENT_USER']."
Dlugosc spotkania: ".$SES_A['L_APPOITMENT_PERIOD']."min Informacje dodatkowe:".$SES_A['L_APPOITMENT_INFO']."
Typ spotkania:".$SES_A['L_APPOITMENT_TYPE']." (ARRANGED=umowione)
$MAKE_ORDERER_TELBOX_USERS_LIST $MAKE_ORDERER_TELBOX_USERS
|
| Potwierdzenie Wykonania | ".$TYP_ZLECENIA." Wykonal |
Rozpoczete platne 30 minut [....] x 30PLN
Dnia .....................................................
Podpis Abonenta ................................. |
Dnia .....................................................
Podpis Pracownika .............................. |
Copyright © 2014 Procesy5
";
if ($TYP_ZLECENIA=="ZLECENIE_MONTAZU") {
echo "
";
ZLECENIE_KONFIGURACJA($SES_A);
}
}