217 lines
9.2 KiB
PHP
217 lines
9.2 KiB
PHP
<?php session_start();
|
|
|
|
require_once'../fpdf/fpdf.php';
|
|
require_once'../language/polish.php';
|
|
require_once'../func.php';
|
|
require_once'../dbaccess.php';
|
|
$con = mysql_connect($db_host, $db_user, $db_user_pass) or die ('cannot connect to db');
|
|
mysql_select_db($db_name);
|
|
mysql_query("SET NAMES utf8");
|
|
mysql_query("SET CHARACTER_SET utf8_general_ci");
|
|
|
|
$fontSize = 10;
|
|
$lineWidth = 6;
|
|
|
|
|
|
class PDF extends FPDF
|
|
{
|
|
// Page header
|
|
function Header()
|
|
{
|
|
// Arial bold 15
|
|
$this -> SetFont('arial_ce', '', 10);
|
|
// Title
|
|
$left = iconv('utf-8','windows-1250','Oddział: '.$_SESSION['site810inf_ordMainArray'][0]['ORD_PLC']);
|
|
//$this->Cell(190,5,$title,1,0,'L');
|
|
$this->Cell(95,5,$left,0,0,'L');
|
|
$this->Cell(95,5,'Data: '.date('Y-m-d'),0,0,'R');
|
|
//$this->Cell(100,5,$title,1,0,'R');
|
|
// Line break
|
|
//$this->Ln(15);
|
|
$this->Ln();
|
|
}
|
|
|
|
// Page footer
|
|
function Footer()
|
|
{
|
|
// Position at 1.5 cm from bottom
|
|
$this->SetY(-15);
|
|
// Arial italic 8
|
|
$this->SetFont('Arial','I',8);
|
|
$this->Cell(0,10,'Strona '.$this->PageNo().'/{nb}',0,0,'R');
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
// Instanciation of inherited class
|
|
$pdf = new PDF();
|
|
$pdf->AddFont('arial_ce','','arial_ce.php');
|
|
$pdf->AddFont('arial_ce','I','arial_ce_i.php');
|
|
$pdf->AddFont('arial_ce','B','arial_ce_b.php');
|
|
$pdf->AddFont('arial_ce','BI','arial_ce_bi.php');
|
|
$pdf->setFillColor(240,240,240);
|
|
|
|
$pdf->AliasNbPages();
|
|
$pdf->AddPage();
|
|
//$pdf->SetFont('Times','',$fontSize);
|
|
|
|
// tytuł zlecenia
|
|
$pdf->SetLineWidth(.1);
|
|
$pdf->SetFont('arial_ce', 'B', 14);
|
|
$pdf->Cell(190,10,iconv('utf-8','windows-1250','Zlecenie nr: '.$_SESSION['site810inf_ordMainArray'][0]['ORD_NO']),0,1,'C');
|
|
$pdf->SetFont('arial_ce', '', 12);
|
|
$pdf->Cell(190,5,iconv('utf-8','windows-1250',setDicName($_SESSION['site810inf_ordMainArray'][0]['ORD_SCOPE_DIC_ID'])).' w studni: '.$_SESSION['site810inf_ordMainArray'][0]['ORD_OBJ_NAME'],0,1,'C');
|
|
$pdf->Ln();
|
|
|
|
//Label
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(0,$lineWidth,iconv('utf-8','windows-1250','Parametry studni '.$_SESSION['site810inf_ordMainArray'][0]['ORD_OBJ_NAME']),1,1,'C',1);
|
|
|
|
//Lokalizacja
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Lokalizacja studni'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250','Bariera '.$_SESSION['site810inf_ordMainArray'][0]['OWP_LOKAL']),1,1,'L');
|
|
|
|
//Głębokość
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Głębokość studni [m]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_GLEB_S']),1,1,'L');
|
|
|
|
//Zasyp
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Zasyp studni [m]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_ZASYP']),1,1,'L');
|
|
|
|
//Średnica studni [mm]
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Średnica studni [mm]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_SRED']),1,1,'L');
|
|
|
|
//Głębokość zabudowy agregatu pompowego [m]
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Głębokość zabudowy agregatu [m]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_GLEB_AG']),1,1,'L');
|
|
|
|
//Typ i numer zabudowanej pompy
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Typ i numer zabudowanej pompy'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',str_replace(', nr',' nr',$_SESSION['site810inf_ordMainArray'][0]['OWP_PUMP'])),1,1,'L');
|
|
|
|
//Typ i numer zabudowanego silnika
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Typ i numer zabudowanego silnika'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',str_replace(', nr',' nr',$_SESSION['site810inf_ordMainArray'][0]['OWP_ENG'])),1,1,'L');
|
|
|
|
//Średnica kolektora tłocznego [mm]
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Średnica kolektora tłocznego [mm]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_SRED_KOL']),1,1,'L');
|
|
|
|
//Metan
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Metan [%]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_METAN']),1,1,'L');
|
|
|
|
//Sonda hydrostatyczna
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Sonda hydrostatyczna'),1,0,'L');
|
|
if (strlen($_SESSION['site810inf_ordMainArray'][0]['OWP_SONDA'])>20)
|
|
$showField = str_replace(array(', nr',', dł'),array(' nr',' dł'),$_SESSION['site810inf_ordMainArray'][0]['OWP_SONDA']);
|
|
else
|
|
$showField = null;
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$showField),1,1,'L');
|
|
|
|
//Dojazd
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Dojazd'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',setDicName($_SESSION['site810inf_ordMainArray'][0]['OWP_DOJAZD'])),1,1,'L');
|
|
|
|
$pdf->Ln();
|
|
|
|
|
|
//Label - new
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(0,$lineWidth,iconv('utf-8','windows-1250','Wymiana agregatu pompowego'),1,1,'C',1);
|
|
|
|
//Typ pompy i nr pompy do zabudowy
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Typ pompy i nr pompy do zabudowy'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',str_replace(', nr',' nr',$_SESSION['site810inf_newAggArray'][0]['ONA_PUMP'])),1,1,'L');
|
|
|
|
//Typ silnika i nr silnika do zabudowy
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Typ silnika i nr silnika do zabudowy'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',str_replace(', nr',' nr',$_SESSION['site810inf_newAggArray'][0]['ONA_ENG'])),1,1,'L');
|
|
|
|
//Głębokość zabudowy agregatu pompowego [m]
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Głębokość zabudowy agregatu [m]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_newAggArray'][0]['ONA_GLEB_AG']),1,1,'L');
|
|
|
|
//Przewód zasilający
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Przewód zasilający OGŁ / dł. [m] (nr plomb)'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',str_replace('(',' (',$_SESSION['site810inf_newAggArray'][0]['ONA_CABLE'])),1,1,'L');
|
|
|
|
//Średnica kolektora tłocznego [mm]
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Średnica kolektora tłocznego [mm]'),1,0,'L');
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$_SESSION['site810inf_newAggArray'][0]['ONA_SRED_KOL']),1,1,'L');
|
|
|
|
//Sonda hydrostatyczna
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(75,$lineWidth,iconv('utf-8','windows-1250','Sonda hydrostatyczna'),1,0,'L');
|
|
if (strlen($_SESSION['site810inf_newAggArray'][0]['ONA_SONDA'])>20)
|
|
$showField = str_replace(array(', nr',', dł'),array(' nr',' dł'),$_SESSION['site810inf_newAggArray'][0]['ONA_SONDA']);
|
|
else
|
|
$showField = null;
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(115,$lineWidth,iconv('utf-8','windows-1250',$showField),1,1,'L');
|
|
|
|
|
|
|
|
$pdf->Ln();
|
|
|
|
$pdf->Cell(190,$lineWidth,iconv('utf-8','windows-1250','Dodatkowy opis'),1,1,'L',1);
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->MultiCell(190,6,iconv('utf-8','windows-1250',$_SESSION['site810inf_ordMainArray'][0]['OWP_INNE']),1,'J');
|
|
|
|
$pdf->Ln();
|
|
|
|
$pdf->SetFont('arial_ce', 'B', $fontSize);
|
|
$pdf->Cell(95,$lineWidth,iconv('utf-8','windows-1250','Osoba zlecająca'),1,0,'C',1);
|
|
$pdf->Cell(95,$lineWidth,iconv('utf-8','windows-1250','Osoba przyjmująca zlecenie'),1,1,'C',1);
|
|
|
|
$pdf->SetFont('arial_ce', '', $fontSize);
|
|
$pdf->Cell(95,35,'',1,0,'C');
|
|
$pdf->Cell(95,35,'',1,1,'C');
|
|
|
|
$pdf->Cell(95,$lineWidth,iconv('utf-8','windows-1250','Data zlecenia: '.$_SESSION['site810inf_ordMainArray'][0]['ORD_AUDIT_DATE']),1,0,'L');
|
|
$pdf->Cell(95,$lineWidth,iconv('utf-8','windows-1250','Data przyjęcia zlecenia: '.$_SESSION['site810inf_ordMainArray'][0]['ORD_START_DATE']),1,0,'L');
|
|
|
|
$pdf->Output();
|
|
|
|
|
|
mysql_close($con);
|
|
?>
|
|
|
|
|