<?php

require_once('tcpdf/config/lang/eng.php');
require_once('tcpdf/tcpdf.php');

list ($deliverynote,$boardtype) = explode(":",$_POST['deliverynote']);
if ($result = pg_query($dbconn,"SELECT deliverydate FROM deliverynote WHERE deliverynote = '".pg_escape_string($deliverynote)."'")) {
  $row = pg_fetch_row($result);
  $deliverydate = $row[0];
}else{
  $deliverydate = 'unknown';
}

$select = "SELECT 
		allboards.serialnumber AS serialnumber, 
		allboards.boardtype AS boardtype, 
		allboards.deliverynote AS deliverynote, 
		deliverynote.deliverydate AS deliverydate, 
		boardtests.state AS state, 
		errors2.errortype AS errortype, 
		errors2.aliceid AS aliceid, 
		errors2.laserid AS laserid, 
		errors2.errordescription AS errordescription 
	FROM 
		errors2,
		allboards,
		deliverynote,
		boardtests 
	WHERE 
		errors2.serialnumber = allboards.serialnumber 
		AND errors2.boardtype = allboards.boardtype 
		AND deliverynote.boardtype = allboards.boardtype 
		AND deliverynote.deliverynote = allboards.deliverynote 
		AND boardtests.serialnumber = allboards.serialnumber 
		AND boardtests.boardtype = '".pg_escape_string($boardtype)."' 
		AND allboards.deliverynote = '".pg_escape_string($deliverynote)."' 
		AND boardtests.state = 'bad' 
	ORDER BY 
		serialnumber ASC";

$result = pg_query($dbconn,$select);
if (pg_num_rows($result)==0){
    $select = "SELECT 
		allboards.serialnumber AS serialnumber, 
		allboards.boardtype AS boardtype, 
		allboards.deliverynote AS deliverynote, 
		deliverynote.deliverydate AS deliverydate, 
		boardtests.state AS state, 
		errors.errortype AS errortype, 
		errors.aliceid AS aliceid, 
		errors.laserid AS laserid, 
		errors.errordescription AS errordescription 
	FROM 
		errors,
		allboards,
		deliverynote,
		boardtests 
	WHERE 
		errors.serialnumber = allboards.serialnumber 
		AND errors.boardtype = allboards.boardtype 
		AND deliverynote.boardtype = allboards.boardtype 
		AND deliverynote.deliverynote = allboards.deliverynote 
		AND boardtests.serialnumber = allboards.serialnumber 
		AND boardtests.boardtype = '".pg_escape_string($boardtype)."' 
		AND allboards.deliverynote = '".pg_escape_string($deliverynote)."' 
		AND boardtests.state = 'bad' 
	ORDER BY 
		serialnumber ASC";

    $result = pg_query($dbconn,$select);
}

if (!$result) {
  $text = "Failed!! Something is wrong query database";
  include 'forms/ok_form.html';
}else{
  // create new PDF document
  $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  // set document information
  $pdf->SetCreator(PDF_CREATOR);
  $pdf->SetAuthor('Thomas Janson');
  $pdf->SetTitle('auto generated report');
  $pdf->SetSubject('robtestDB');
  // set default header data
  //$title = 'Fehlerbericht der Lieferung '.$deliverynote.' mit Lieferdatum '.$deliverydate;
  $title = 'Error Report of Delivery '.$deliverynote.' and Date of Delivery '.$deliverydate;
  $headertext = "Date: ".date('Y-m-d');
  $pdf->SetHeaderData('', 0, $title ,$headertext);
  // set header and footer fonts
  $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
  $pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
  // set default monospaced font
  $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
  // set margins
  $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
  $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
  $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
  // set auto page breaks
  $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
  // set some language dependent string
  $pdf->setLanguageArray($l);
  // fill page with data
  $pdf->SetFont('times','',10);
  $pdf->AddPage();
  //
  $srlnum = '';
  while($row=pg_fetch_row($result)) {
    if ($srlnum != $row[1]."_".$row[0]) {
      $srlnum = $row[1]."_".$row[0];
//      if ($pdf->getY() > 145.0 ) {
//        $pdf->AddPage();
//      }
      $pdf->setFont('','B',11);
      $pdf->MultiCell(0,6,'',0,'L',0,1,'','',true);
      $pdf->MultiCell(34,6,'SerialNumber',0,'L',0,0,'','',true);
      $pdf->setFont('','');
      $pdf->MultiCell(0,6,$srlnum,0,'L',0,1,'','',true);
      $y = $pdf->getY();
      $x = $pdf->getX();
      $pdf->Line($x,$y,$x+175,$y);
      $errtyp='';
    }else{
      $srlnum = $row[1]."_".$row[0];
    }
    if ($errtyp != $row[5]) {
      $pdf->setFont('','B',10);
      $errtyp = $row[5];
      $pdf->MultiCell(34,6,'ErrorType',0,'L',0,0,'','',true);
      $pdf->setFont('','');
      $pdf->MultiCell(0,6,$errtyp,0,'L',0,1,'','',true);
      $pdf->setFont('','BI',9);
      $pdf->MultiCell(17,6,'AliceID',0,'L',0,0,'','',true);
      $pdf->MultiCell(17,6,'LaserID',0,'L',0,0,'','',true);
      $pdf->MultiCell(0,6,'ErrorDescription',0,'L',0,1,'','',true);
    }else{
      $errtyp=$row[5];
    }
    $pdf->setFont('','');
    $pdf->MultiCell(17,6,$row[6],0,'L',0,0,'','',true);
    $pdf->MultiCell(17,6,$row[7],0,'L',0,0,'','',true);
    $pdf->MultiCell(141,6,$row[8],0,'L',0,1,'','',true);
    $pdf->MultiCell(0,3,'',0,'L',0,1,'','',true);
    
  }

  //
  $pdf->Output(K_PATH_MAIN.'/cache/report.pdf','F');

  echo '    <p>Please use this link to download <a href="tcpdf/cache/report.pdf">report.pdf</a></p>'."\n";
//  echo '    <p><a href="tcpdf/cache/report.pdf">report.pdf</a></p>'."\n";

}


?>