<?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();
?>