se/SE/superedit-ZLECENIE.php

<?php

function ZLECENIE_KONFIGURACJA($SES_A) {
	$db = DB::getDB();
	$query="select c.*,bo.name1 as OPERATOR from COMPANIES c join BILLING_OWNER bo on c.BILLING_OWNER=bo.ID where c.ID='".$SES_A['ID_BILLING_USERS']."'";
	$result=$db->query($query);
	$COMPANIES=$db->fetch($result) or die("Error 2");

	if ($SES_A['S_IP']=="") $SES_A['S_IP']="<b>Nie przydzielono adresu IP!</b>";
	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']];
	$ROUTER_SSID=($SES_A['ROUTER_SSID'] ?: "nie zdefiniowano");
	$ROUTER_PRESHARED_KEY=($SES_A['ROUTER_PRESHARED_KEY'] ?: "nie zdefiniowano");
	$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.= " <b>(Jest dzierżawa routera, a nie ma podziału łącza!)</b>";

	$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.=" <b>(Nie przydzielono!)</b>";
		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.= " <b>(Przydzielono więcej niż jeden adres IP!)</b>";
	}
	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.=" <b>(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.= " <b>(Nie przekierowano żadnych portów!)</b>";
		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.= " <b>(A są przekierowano porty ".$PORTY."!)</b>";
	}

	echo "
		<style type=\"text/css\">
			@media print {
				.noPrint { display: none; }
			}
		</style>
		<table>
		<tr><td colspan=2><h4>".$COMPANIES->OPERATOR."<h4><hr></td></tr>
		<tr><td>Abonent:</td><td>".$COMPANIES->P_NAME." ".$COMPANIES->P_NAME_SECOND."</td></tr>
		<tr><td>Adres instalacji:</td><td>".$ADRES."</td></tr>
		<tr><td>ID usługi:</td><td>".$SES_A['ID_SERVICES']."</td></tr>
		<tr><td colspan=2><br>Parametry usługi dostępu do Internetu:</td></tr>
		<tr><td>Prędkość pobierania:</td><td>".$DOWNLOAD."</td></tr>
		<tr><td>Prędkość wysyłania:</td><td>".$UPLOAD."</td></tr>";
//		<tr><td>Podział łącza:</td><td>".$PODZIAL_LACZA."</td></tr>
	echo "
		<tr><td>Dzierżawa routera:</td><td>".$DZIERZAWA_ROUTERA."</td></tr>";
		if ($DZIERZAWA_ROUTERA == 'Tak') echo "
		<tr><td>Nazwa sieci bezprzewodowej (SSID):</td><td>".$ROUTER_SSID."</td></tr>
		<tr><td>Klucz do sieci bezprzewodowej:</td><td>".$ROUTER_PRESHARED_KEY."</td></tr>";
	echo
		"<tr><td>Publiczny adres IP:</td><td>".$PUBLICZNY_ADRES_IP."</td></tr>
		<tr><td>Przekierowanie portów:</td><td>".$PRZEKIEROWANIE_PORTOW."</td></tr>
		<tr><td colspan=2><br>Konfiguracja protokołu TCP/IP:</td></tr>
		<tr><td>Adres IP:</td><td>".$SES_A['S_IP']."</td></tr>
		<tr><td>Maska podsieci:</td><td>".$SUBNET_MASK."</td></tr>
		<tr><td>Brama domyślna:</td><td>".$GATEWAY."</td></tr>
		<tr><td>Preferowany serwer DNS:</td><td>".$GATEWAY."</td></tr>
		<td><td colspan=2></td></tr>
		<tr><td>Zarejestrowany adres fizyczny (MAC):</td><td>
	";
	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']." <span class=\"noPrint\">(<a href=\"".$_SERVER['REQUEST_URI']."&action=se-detect\">odblokuj</a>)</span>";
	else echo "odblokowany";
	if (V::get('action', '', $_GET) == "se-detect") echo "</td><tr><tr class=\"noPrint\"><td>Wynik odblokowania:</td><td>".$result_a[0];
#echo "<pre>";
#print_r($_SESSION);
#echo "</pre>";
	echo "</td></tr></table>";
}

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 '<b>',S_ADDRESS_STREET,'</b> ',A_STATUS,' ',S_IP,'<b> ',A_PROBLEM,'</b> ',A_PROBLEM_DESC,'<br> ' 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 '<b>',S_ADDRESS_STREET,'</b> ',A_STATUS,' <b> ',A_PROBLEM,'</b> ',A_PROBLEM_DESC,'<br> ' 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="( <b>$MAKE_ORDERER_TELBOX_USERS</b> 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 '<b>',t1.S_ADDRESS_STREET,'</b> | ',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 '<b>',T_DEVICE_TYPE,T_PRODUCER,'</b>(',T_DEVICE_PORTS_OK,')<b>',A_STATUS,A_STATUS_INFO,A_PROBLEM,'</b><font size=-2>',A_PROBLEM_DESC,S_ADDRESS_STREET,T_DEVICE_POWER,T_DEVICE_INFO,'Awar:',T_WORKPOINTS,'gwar.',T_GUARRANTY_EXPIRE,'</font><br>' 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 '&nbsp; <b>',T_TELBOX_NAME,'</b> &nbsp;&nbsp;','STATUS:<b>', A_STATUS,'</b>(', A_STATUS_INFO, ') <br>Problemy:<b>', A_PROBLEM,'</b>(',A_PROBLEM_DESC,A_PROBLEM_DATE,')Termin_usuniecia:',S_OTHER_INFO, '<BR>Adresy:<b>',S_ADDRESS_CITY,S_ADDRESS_POST_CODE,S_ADDRESS_POST_OFFICE,S_ADDRESS_STREET,S_ADDRESS_HOUSE,'</b><br> Typ:<b>',T_TELBOX_TYPE,'</b><br>Zamkniecie:<b>',T_TELBOX_SAVE,'</b><br>Zasilanie:<b>',T_TELBOX_POWER,'</b><br>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 = "<table border=1><tr><td colspan=2 align=center><font size=-1 face=arial><b>Nieznana/niewykryta ilosc wolnych portow - ZINWENTARYZOWAC URZADZENIA W SZAFCE !!!!!!!</td></tr><tr><td width=30%> NrSeryjny:</td><td>&nbsp; </td></tr><tr><td>Typ (np.SW8):</td><td>&nbsp;</td></tr><tr><td>Producent:</td><td>&nbsp;</td></tr><tr><td>Termin_gwarancji:</td><td align=center> - </td></tr><tr><td>Dostawca:</td><td>&nbsp;</td></tr><tr><td>Il.Sprawnych Portow:</td><td>&nbsp;</td></tr></table></font>";
		} 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: <b>$MAKE_ORDERER_DEVICES_PORTS_FREE </b>";
		}
	}

	if (!($MAKE_ORDERER_DEVICE_TELBOX_INFO)) {
		$MAKE_ORDERER_DEVICE_TELBOX_INFO = "<table border=1><tr><td colspan=2 align=center><font size=-1 face=arial><b>ZINWENTARYZOWAC SZAFKE !!!!!!!</td></tr><tr><td width=30%> SZAFKA:</td><td>Ul.:_________ Nr:_____ Kl.:_____ Pietro:_____ </td></tr><tr><td>Typ :</td><td>&nbsp;</td></tr><tr><td>Zamkniecie:</td><td>&nbsp;</td></tr><tr><td>Zasilanie:</td><td align=center> &nbsp; </td></tr><tr><td>Magistrale IN/OUT:</td><td align=left>IN: &nbsp;</td></tr><tr><td>Abonenci:</td><td>&nbsp;</td></tr>
                <tr><td colspan=2 align=center><font size=-1 face=arial><b>ZINWENTARYZOWAC URZADZENIA W SZAFCE !!!!!!!</td></tr>
                <tr><td width=30%> NrSeryjny:</td><td>&nbsp; </td></tr><tr><td>Typ (np.SW8):</td><td>&nbsp;</td></tr><tr><td>Producent:</td><td>&nbsp;</td></tr><tr><td>Termin_gwarancji:</td><td align=center> - </td></tr><tr><td>Dostawca:</td><td>&nbsp;</td></tr><tr><td>Il.Sprawnych Portow:</td><td>&nbsp;</td></tr></table></font>
                ";
	} else if (($MAKE_ORDERER_BUILDING_INFO_COUNT == 1) && (strlen($MAKE_ORDERER_BUILDING_INVENTORY_DATE) < 3)) {
		$MAKE_ORDERER_BUILDING_INFO = "<table border=1><tr><td colspan=2 align=center><font size=-1 face=arial><b>ZINWENTARYZOWAC BUDYNEK (ost. akt. $MAKE_ORDERER_BUILDING_INVENTORY_DATE) !!!!!!!</td></tr><tr><td colspan=2><font size=-1>$MAKE_ORDERER_BUILDING_INFO</font></td></tr></table></font>";
	} else if (($MAKE_ORDERER_BUILDING_INFO_COUNT == 1) && (strlen($MAKE_ORDERER_BUILDING_INVENTORY_DATE) > 3)) {
		$MAKE_ORDERER_BUILDING_INFO="<br>Inf.Budynkowa: $MAKE_ORDERER_BUILDING_INFO , data akt.: $MAKE_ORDERER_BUILDING_INVENTORY_DATE";
	}
	echo "
                  <HTML><BODY onload=\"javascript:printit();\">
                  <SCRIPT Language=\"Javascript\">
                 function printit(){
                  if (window.print) {
                   window.print() ;
                  } else {
                   var WebBrowser = '<OBJECT ID=\"WebBrowser1\" WIDTH=0 HEIGHT=0 CLASSID=\"CLSID:8856F961-340A-11D0-A96B-00C04FD705A2\"></OBJECT>';M
                   document.body.insertAdjacentHTML('beforeEnd', WebBrowser);M
                   WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box    WebBrowser1.outerHTML = \"\";  M
                  }
                 }
                 </script>";

	// 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'];
	}

	// wyszukanie wszystkich rodzai uslug na waitingu dla danej umowy
	$query = "select
			ls.`description`
		from
			`DEALS_TABLE` d
			join `SERVICES` s
				on d.`ID`=s.`ID_DEALS_TABLE`
			join `LIST_SERVICES` ls
				on s.`NAME_LIST_SERVICES`=ls.`name`
		where d.`P_DEALNUMBER`='".$out_P_DEALNUMBER."'
		group by ls.`description`
		order by ls.`description`
	";
	$result=$db->query($query);
	while ($h = $db->fetch_assoc($result)) $out_ALL_SERVICES_a[] = $h['description'];
	$out_ALL_SERVICES=implode(", ",$out_ALL_SERVICES_a);

	// 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'];
	}
?>
<style type="text/css">
.table td {
  padding: 8px;
  line-height: 100%;
  text-align: left;
  vertical-align: top;
  border-top: 1px solid #dddddd;
}
</style>
<?
	$USLUGI=array("USERS2"=>"Internet","TV"=>"Telewizja","VOIP"=>"Telefon");




//POWIZAZANIA_URZADZEN
        $query="select * from DEVICES  where ID_SERVICES='".$SES_A['ID_SERVICES']."'";
        $result=$db->query($query);
        if (!$db->num_rows($result)) {
                $POWIZAZANIA_URZADZEN_INFO.= " <b>(Nie znaleziono zadnych urzadzen)</b>";               
        }
        else {
                while ($POWIZAZANIA_URZADZEN=$db->fetch($result)) {
                        $POWIZAZANIA_URZADZEN_INFO.="<br>Device ID:".$POWIZAZANIA_URZADZEN->ID ; 
                        if(!$POWIZAZANIA_URZADZEN->CRM_LISTA_ZASOBOW_ID == '')  $POWIZAZANIA_URZADZEN_INFO.= " [Zasob]: ".$POWIZAZANIA_URZADZEN->CRM_LISTA_ZASOBOW_ID ;
                        if(!$POWIZAZANIA_URZADZEN->T_DEVICE_TYPE == '')  $POWIZAZANIA_URZADZEN_INFO.= " Typ: ".$POWIZAZANIA_URZADZEN->T_DEVICE_TYPE ;
                        if(!$POWIZAZANIA_URZADZEN->T_DEVICE_INFO == '')  $POWIZAZANIA_URZADZEN_INFO.= " Info: ".$POWIZAZANIA_URZADZEN->T_DEVICE_INFO ;
                        if(!$POWIZAZANIA_URZADZEN->T_DEVICE_SERIAL == '')  $POWIZAZANIA_URZADZEN_INFO.= " S/N: ".$POWIZAZANIA_URZADZEN->T_DEVICE_SERIAL ;        
                        if(!$POWIZAZANIA_URZADZEN->S_HW == '')  $POWIZAZANIA_URZADZEN_INFO.= " Numer MAC/HW: ".$POWIZAZANIA_URZADZEN->S_HW ;
                        if(!$POWIZAZANIA_URZADZEN->T_PRODUCER == '')  $POWIZAZANIA_URZADZEN_INFO.= " Prod: ".$POWIZAZANIA_URZADZEN->T_PRODUCER ;
                        if(!$POWIZAZANIA_URZADZEN->S_OTHER_INFO == '')  $POWIZAZANIA_URZADZEN_INFO.= " o/Info: ".$POWIZAZANIA_URZADZEN->S_OTHER_INFO ;
                        if(!$POWIZAZANIA_URZADZEN->S_IP == '')  $POWIZAZANIA_URZADZEN_INFO.= " IP: ".$POWIZAZANIA_URZADZEN->S_IP ;
                        if(!$POWIZAZANIA_URZADZEN->F_BILL_DATE == '' and !$POWIZAZANIA_URZADZEN->F_BILL_DATE == '0000-00-00')  $POWIZAZANIA_URZADZEN_INFO.= " Data fakt: ".$POWIZAZANIA_URZADZEN->F_BILL_DATE ;
                        if(!$POWIZAZANIA_URZADZEN->F_BILL_COST == '' and !$POWIZAZANIA_URZADZEN->F_BILL_COST == '0.00')  $POWIZAZANIA_URZADZEN_INFO.= " Koszt: ".$POWIZAZANIA_URZADZEN->F_BILL_COST ;
                        if(!$POWIZAZANIA_URZADZEN->T_BUY_DATE == '' and !$POWIZAZANIA_URZADZEN->T_BUY_DATE == '0000-00-00')  $POWIZAZANIA_URZADZEN_INFO.= " Data zak.: ".$POWIZAZANIA_URZADZEN->T_BUY_DATE ;
                        if(!$POWIZAZANIA_URZADZEN->T_SELLER == '')  $POWIZAZANIA_URZADZEN_INFO.= " Sprzed.: ".$POWIZAZANIA_URZADZEN->T_SELLER ;
                        if(!$POWIZAZANIA_URZADZEN->T_OWNER == '')  $POWIZAZANIA_URZADZEN_INFO.= " Właściciel: ".$POWIZAZANIA_URZADZEN->T_OWNER ;
                        if(!$POWIZAZANIA_URZADZEN->T_GUARRANTY_EXPIRE == '')  $POWIZAZANIA_URZADZEN_INFO.= " gwar.: ".$POWIZAZANIA_URZADZEN->T_GUARRANTY_EXPIRE ;
                        if(!$POWIZAZANIA_URZADZEN->A_PROBLEM == '')  $POWIZAZANIA_URZADZEN_INFO.= " Problem: ".$POWIZAZANIA_URZADZEN->A_PROBLEM ;
                        if(!$POWIZAZANIA_URZADZEN->A_PROBLEM_DESC == '')  $POWIZAZANIA_URZADZEN_INFO.= " Opis pr.: ".$POWIZAZANIA_URZADZEN->A_PROBLEM_DESC ;
                        if(!$POWIZAZANIA_URZADZEN->ADM_PASSWD == '')  $POWIZAZANIA_URZADZEN_INFO.= " Hasło: ".$POWIZAZANIA_URZADZEN->ADM_PASSWD ;
                        if(!$POWIZAZANIA_URZADZEN->T_TELBOX_NEIGHBOUR_IN_ID == '')  $POWIZAZANIA_URZADZEN_INFO.= " lokal.: ".$POWIZAZANIA_URZADZEN->T_TELBOX_NEIGHBOUR_IN_ID ;



                        }


        }





        echo "<TABLE border=2 cellspacing=0 cellpadding=0 width=100% stle=\"line-height=100%\">
                <TR><TD COLSPAN=2><font size=+1>

                <b>".$TYP_ZLECENIA."</b></font> <font size=-1>status: <b>" . $SES_A['A_STATUS'] . "</b> Nr <b>" . $SES_A['ID'] . "</b>  z dnia <b>" . $SES_A['A_PROBLEM_DATE'] . "</b></font><br>
                <font size=-2>Dodatk. Info: <b>" . $SES_A['A_STATUS_INFO'] . "</b> , Other Info:<b> " . $SES_A['S_OTHER_INFO'] . " </b>  Wystawil: <b>
                " . $_SESSION['ADM_NAME'] . "  <i>(" . $_SESSION['ADM_ACCOUNT'] . ")</i></b> Poziom:<b>" . $_SESSION['ADM_ADMIN_LEVEL'] . "</b> Zasieg: <b>" . $_SESSION['ADM_COMPANY'] . "</b>
                </TD></TR>
                <TR><TD COLSPAN=2>
                <b>Poziom problemu:</b><b>" . $SES_A['A_PROBLEM'] . "</font> </b><br>
                Opis Problemu:<b> " . $SES_A['A_PROBLEM_DESC'] . " </b>
                </TD></TR>
                <TR>
                <TD><b><i>Dane Klienta</b></i></TD>
                <TD><b><i>Dane Uslugi</b></i></TD>
                </TR>

                <TR>
                <TD style=\"line-height: 1.1\">
                Operator: <b>" .$out_OPERATOR . "</b><br>
                Umowa: <b>" . $out_P_DEALNUMBER . "</b> z dnia: <b>" . $out_P_DEAL_DATE . "</b><br>
                Abonent: <b>" . $out_P_NAME . "</b><br>
                Kontakty: <b>" . $out_P_PHONE . "</b> Fax:<b>" . $out_P_FAX . " </b><br>
		Usługi w ramach umowy: <b>" . $out_ALL_SERVICES . "</b><br>
                Adres: <b>" . $SES_A['S_ADDRESS_STREET'] . "</b>
                <font size='-2'>
                Budynek: $MAKE_ORDERER_BUILDING_INFO
                <hr>
                Telbox_info:$MAKE_ORDERER_DEVICE_TELBOX_INFO<hr>
                <!--Dev: $MAKE_ORDERER_DEVICES_LIST</font><br>
                Port: $MAKE_ORDERER_DEVICES_PORTS_FREE<hr>-->
                Magist: $MAKE_ORDERER_TELBOX_MAGISTRAL IN: $MAKE_ORDERER_TELBOX_MAGISTRAL_IN<br>
                Sciezka: $A_DB_TELBOX_TRACE_PATH
                </font>
                </TD>
                <TD style=\"font-size: 9px; line-height: 1.1\">
                <font size='-2'>
                Usluga: <b>".$USLUGI[$NAME_LIST_SERVICES]." (" . $SES_A['P_SERVICE'] . ")</b><br>
                Klasa uslugi: <b>" . $SES_A['P_SERVICE_CLASS'] . "</b><br>
                Dodatkowe urzadzenie: <b>".  $SES_A['P_DEVICE'] . "</b><br>
                Hostname: <b>" . $SES_A['S_HOST'] . "</b>  Domena: <b>" . $SES_A['S_DOMAIN'] . "</b><br>
                Username: <b>" . $SES_A['S_ACCOUNT'] . "</b> (" . $SES_A['S_ALIAS'] . ")<br>
                Password: <b>" . $SES_A['S_PASSWD'] . "</b><br>
                IP: <b>" . $SES_A['S_IP'] . "</b><br>
                MAC: <b>" . $SES_A['S_HW'] . "</b>  MAC_STATUS: <b>" . $SES_A['S_HWSTAT'] . "</b><br>
                Telbox: <b>" . $SES_A['T_TELBOX_ADDRESS'] . "</b> / <b>" . $SES_A['T_TELBOX_PORT'] . "</b><br>
                Serwer Sieciowy : <b>" . $SES_A['T_NETWORK_SERVER'] . "</b> / <b>" . $SES_A['T_TOPOLOGY_PLACE'] . "</b><br>
                Spotkania : Data <b> ".$SES_A['L_APPOITMENT_DATE']."</b> Pracownik:<b> ".$SES_A['L_APPOITMENT_USER']."</b>
                <br>Dlugosc spotkania: <b>".$SES_A['L_APPOITMENT_PERIOD']."min </b> Informacje dodatkowe:".$SES_A['L_APPOITMENT_INFO']." </b>
                <br>Typ spotkania:<b>".$SES_A['L_APPOITMENT_TYPE']." </b>  <font size=-1>(ARRANGED=umowione)</font>
                <hr>
                 <br>POWIZAZANIA URZADZEN INFO:<br>
                ".$POWIZAZANIA_URZADZEN_INFO."
                
                
                </font>
                <!--$MAKE_ORDERER_TELBOX_USERS_LIST $MAKE_ORDERER_TELBOX_USERS-->
                </TD>
                </TR>
                <tr height=2></tr>
                <tr><td><font size=+0><b>Potwierdzenie Wykonania</b></font></td><td><font size=+0><b>".$TYP_ZLECENIA." Wykonal</b></font></td></tr>
                <tr>
                <td style=\"font-size: 11px; line-height: 1.1\">
                Rozpoczete platne 30 minut [....] x 30PLN<br><br><br>
                Dnia .....................................................<br>
                <br><br>
                Podpis Abonenta .................................</td>
                <td style=\"font-size: 11px; line-height: 1.1\"><br>Dnia .....................................................<br>
                <br><br>
                Podpis Pracownika ..............................</td>
                </tr>
                </table>
                <font size=-2><i>Copyright &copy; 2014 Procesy5</i></font>
		</table>
	";

	if ($TYP_ZLECENIA=="ZLECENIE_MONTAZU") {
		echo "<p style=\"page-break-before: always\">";
		ZLECENIE_KONFIGURACJA($SES_A);
	}
}