169 lines
6.0 KiB
PHP
169 lines
6.0 KiB
PHP
<?php session_start();
|
|
|
|
require_once('../fpdf/fpdf.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");
|
|
|
|
unset($rapHisArray);
|
|
$rapHisArray = sqlGetResAsArray("select * from softspm_rep.rep_002_history_saved where DHS_REPORT_NAME='".$_GET['rp']."' order by DHS_ID");
|
|
|
|
unset($_SESSION['from']);
|
|
unset($_SESSION['to']);
|
|
$_SESSION['from'] = $rapHisArray[0]['DHS_DATE_FROM'];
|
|
$_SESSION['to'] = $rapHisArray[0]['DHS_DATE_TO'];
|
|
|
|
mysql_close($con);
|
|
|
|
class PDF extends FPDF
|
|
{
|
|
// Page header
|
|
function Header()
|
|
{
|
|
if ( $this->PageNo() == 1 )
|
|
{
|
|
$this->Image('../images/logo_head_pge.jpg',10,8,71);
|
|
$this->Ln(15);
|
|
|
|
$this -> SetFont('Calibri_b', '', 11);
|
|
$this->Cell(0,5,iconv('utf-8','windows-1250','Dział Odwodnienia'),0,1,'R');
|
|
$this->Cell(0,4,iconv('utf-8','windows-1250','Oddział Odwodnienia '.str_replace('Dębina', 'P/Bełchatów - bariera ochronna Dębina', $_SESSION['syndis_eq_stock'])),0,1,'R');
|
|
$this->Ln();
|
|
|
|
$this -> SetFont('Calibri_b', '', 11);
|
|
$title = iconv('utf-8','windows-1250','Wykaz pracy studni za okres od: '.$_SESSION['from'].' do: '.$_SESSION['to']);
|
|
$this->Cell(0,4,$title,0,0,'L');
|
|
$this->Ln();
|
|
}
|
|
|
|
$this -> SetFont('calibri', '', 8);
|
|
$this->Cell(10,5,iconv('utf-8','windows-1250','Lp.'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','Studnia'),1,0,'C');
|
|
$this->Cell(35,5,iconv('utf-8','windows-1250','Agregat'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','Moc [kW]'),1,0,'C');
|
|
$this->Cell(20,5,iconv('utf-8','windows-1250','Czas pracy [h]'),1,0,'C');
|
|
$this->Cell(20,5,iconv('utf-8','windows-1250','Ilość wody [m3]'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','Q [m3/min]'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','HST0 [m]'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','HD [m]'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','Temp. [C]'),1,0,'C');
|
|
$this->Cell(15,5,iconv('utf-8','windows-1250','Cl [mg/l]'),1,0,'C');
|
|
$this->Ln();
|
|
|
|
|
|
}
|
|
|
|
// Page footer
|
|
function Footer()
|
|
{
|
|
// Position at 1.5 cm from bottom
|
|
$this->SetY(-15);
|
|
// Arial italic 8
|
|
$this->SetFont('Calibri_i','',6);
|
|
// Page number
|
|
$this->Cell(50,10,iconv('utf-8','windows-1250','© SoftSPM, '.date('Y')),0,0,'L');
|
|
$this->Cell(90,10,'www.softspm.com',0,0,'C');
|
|
$this->Cell(50,10,'Strona '.$this->PageNo().'/{nb}',0,0,'R');
|
|
}
|
|
}
|
|
|
|
// Instanciation of inherited class
|
|
$pdf = new PDF();
|
|
$pdf->AddFont('calibri','','calibri.php');
|
|
$pdf->AddFont('Calibri_b','','Calibri_b.php');
|
|
$pdf->AddFont('Calibri_i','','Calibri_i.php');
|
|
|
|
$pdf->AliasNbPages();
|
|
$pdf->AddPage(); //190
|
|
//$pdf->AddPage('L'); //277
|
|
|
|
$pdf->SetLineWidth(.1);
|
|
|
|
$pdf -> SetFont('calibri', '', 9);
|
|
$bariera = "";
|
|
$licznik_bariera=0;
|
|
$bariera_woda=0;
|
|
$calosc_woda=0;
|
|
|
|
for($i=0;$i<count($rapHisArray);$i++)
|
|
{
|
|
|
|
if ($bariera!=$rapHisArray[$i]['DHS_BARIERA'])
|
|
{
|
|
if ($licznik_bariera>0)
|
|
{
|
|
$pdf -> SetFont('Calibri_b', '', 8);
|
|
$pdf->Cell(95,5,iconv('utf-8','windows-1250','Razem bariera '.$bariera.':'),1,0,'L');
|
|
$pdf->Cell(20,5,iconv('utf-8','windows-1250',round($bariera_woda,0)),1,0,'R');
|
|
$pdf->Ln();
|
|
$pdf->Ln();
|
|
|
|
$bariera_woda=0;
|
|
}
|
|
|
|
|
|
$pdf -> SetFont('calibri', '', 8);
|
|
$pdf->Cell(0,5,iconv('utf-8','windows-1250','Bariera '.$rapHisArray[$i]['DHS_BARIERA']),1,0,'L');
|
|
$pdf->Ln();
|
|
|
|
|
|
$bariera=$rapHisArray[$i]['DHS_BARIERA'];
|
|
$licznik_bariera++;
|
|
}
|
|
|
|
if ($rapHisArray[$i]['DHS_WORK_TIME_VAL']>0) $rapHisArray[$i]['DHS_WORK_TIME_VAL'] = round($rapHisArray[$i]['DHS_WORK_TIME_VAL'],0);
|
|
else $rapHisArray[$i]['DHS_WORK_TIME_VAL']='';
|
|
|
|
if ($rapHisArray[$i]['DHS_HST0_VAL']>0) $rapHisArray[$i]['DHS_HST0_VAL'] = round($rapHisArray[$i]['DHS_HST0_VAL'],1);
|
|
else $rapHisArray[$i]['DHS_HST0_VAL']='';
|
|
|
|
if ($rapHisArray[$i]['DHS_HD_VAL']>0) $rapHisArray[$i]['DHS_HD_VAL'] = round($rapHisArray[$i]['DHS_HD_VAL'],1);
|
|
else $rapHisArray[$i]['DHS_HD_VAL']='';
|
|
|
|
if ($rapHisArray[$i]['DHS_P_VAL']>0) $rapHisArray[$i]['DHS_P_VAL'] = round($rapHisArray[$i]['DHS_P_VAL'],1);
|
|
else $rapHisArray[$i]['DHS_P_VAL']='';
|
|
|
|
if ($rapHisArray[$i]['DHS_VM3_VAL']>0) $rapHisArray[$i]['DHS_VM3_VAL'] = round($rapHisArray[$i]['DHS_VM3_VAL'],0);
|
|
else $rapHisArray[$i]['DHS_VM3_VAL']=null;
|
|
|
|
|
|
$pdf->Cell(10,4,iconv('utf-8','windows-1250',$i+1),1,0,'R');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_WELL']),1,0,'C');
|
|
$pdf->Cell(35,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_AGREGAT']),1,0,'C');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_P_VAL']),1,0,'R');
|
|
$pdf->Cell(20,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_WORK_TIME_VAL']),1,0,'R');
|
|
$pdf->Cell(20,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_VM3_VAL']),1,0,'R');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_QS_VAL']),1,0,'R');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_HST0_VAL']),1,0,'R');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_HD_VAL']),1,0,'R');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_WTEMP_VAL']),1,0,'R');
|
|
$pdf->Cell(15,4,iconv('utf-8','windows-1250',$rapHisArray[$i]['DHS_CL_VAL']),1,0,'R');
|
|
$pdf->Ln();
|
|
|
|
|
|
$bariera_woda+= (float) $rapHisArray[$i]['DHS_VM3_VAL'];
|
|
$calosc_woda += (float) $rapHisArray[$i]['DHS_VM3_VAL'];
|
|
}
|
|
|
|
$pdf -> SetFont('Calibri_b', '', 8);
|
|
$pdf->Cell(117,5,iconv('utf-8','windows-1250','Razem bariera '.$bariera.':'),1,0,'L');
|
|
$pdf->Cell(40,5,iconv('utf-8','windows-1250',round($bariera_woda,0)),1,0,'R');
|
|
$pdf->Ln();
|
|
$pdf->Ln();
|
|
|
|
$pdf -> SetFont('Calibri_b', '', 9);
|
|
$pdf->Cell(117,6,iconv('utf-8','windows-1250','Razem wszystkie studnie:'),1,0,'L');
|
|
$pdf->Cell(40,6,iconv('utf-8','windows-1250',round($calosc_woda,0)),1,0,'R');
|
|
$pdf->Ln();
|
|
|
|
|
|
$pdf->Output();
|
|
?>
|
|
|
|
|