<?php
require_once('tcpdf/tcpdf_include.php');
require("../inc/db_connect.inc.php");
setlocale(LC_MONETARY, 'de_DE');

$billCOMPANY = 'Tekoplan GmbH';
$from = strtotime('2018-05-01');
$to = strtotime("+1 month", $from);
$monthYEAR=date("F Y",$from);

$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Markus Stapf');
$pdf->SetTitle('Rechnungsausgangsbuch');
$pdf->SetSubject('MSIS-HOSTING');
$pdf->SetKeywords('Rechnungsausgangsbuch, MSIS-HOSTING, Webdesign');

// remove default header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);

// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

// set margins
$pdf->SetMargins(10, PDF_MARGIN_TOP, 10);

// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

// set some language-dependent strings (optional)
if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
    require_once(dirname(__FILE__).'/lang/eng.php');
    $pdf->setLanguageArray($l);
}
// ---------------------------------------------------------

$i=0;
$x=0;
$y=0;
$sql = "SELECT * FROM billlist WHERE billCOMPANY='$billCOMPANY' AND billTYP='RG' AND billDATE>='$from' AND billDATE<='$to' ORDER by billDATE"; //115
$result = mysql_query($sql, $link);
while($row_bill = @mysql_fetch_array($result))
{
	$i=$i+1;

	$billID =  $row_bill['ID'];
	$billDATE = date("d.m.Y",$row_bill['billDATE']);
	$billTYP = $row_bill['billTYP'];
	$billNR = $row_bill['billNR'];
	$billBOOK = $row_bill['billBOOK'];
	$billTOPDF = $row_bill['billTOPDF'];
	$billTOEMAIL = $row_bill['billTOEMAIL'];
	$billPRINT = $row_bill['billPRINT'];
	$billCUSTOMERNR = $row_bill['billCUSTOMERNR'];
	$billCUSTOMERNAME = $row_bill['billCUSTOMERNAME'];
	$billSUM = $row_bill['billSUM'];
	$billDISCOUNT = $row_bill['billDISCOUNT'];
	$billDEMAND = $row_bill['billDEMAND'];
	$billPAID = $row_bill['billPAID'];
	$billBANKACCOUNT = $row_bill['billBANKACCOUNT'];
	$billPAIDDATE = $row_bill['billPAIDDATE'];

	$sql = "SELECT * FROM customers WHERE customerNR='$billCUSTOMERNR'";
	$resultcustomer = mysql_query($sql, $link);
	while($row_customer = @mysql_fetch_array($resultcustomer))
	{
		$customerNAME = $row_customer['customerNAME'];
		$customerFIRSTNAME = $row_customer['customerFIRSTNAME'];
		$customerCOMPANY = $row_customer['customerCOMPANY'];
		$customerSTREET = $row_customer['customerSTREET'];
		$customerZIP = $row_customer['customerZIP'];
		$customerCITY = $row_customer['customerCITY'];
		$customerCOUNTRY = $row_customer['customerCOUNTRY'];
		$customerUID= $row_customer['customerUID'];
		$customerUIDOK = $row_customer['customerUIDOK'];
	}

	$x=$x+$billSUM;
	$x=money_format('%.2n',$x);

	if($customerUIDOK==1)
	{
		$billNETTO = $billSUM;
		$billBRUTTO = $billSUM;
		$billMWST = '0';
	}
	else
	{
		$billNETTO = $billSUM;
		$billBRUTTO = $billNETTO * 1.19;
		$billMWST = $billBRUTTO - $billNETTO;
		$billDEMAND = $billDEMAND * 1.19;
	}

	if($billPAID!='paid')
	{
		$billDEMAND=0;
		$status="offen";
	}
	else
	{
		$status="bezahlt";
	}

	$code='
	<tr class="td_white">
	<td height="35" valign="top">'.$billDATE.'</td>
	<td valign="top">'.$billNR.'</td>
	<td valign="top">'.$billCUSTOMERNR.'</td>
	<td valign="top">'.$customerNAME.', '.$customerFIRSTNAME.' <br />'.$customerCOMPANY.'<br />'.$customerSTREET.'<br />'.$customerZIP.' '.$customerCITY.'<br />'.$customerCOUNTRY.' <br /></td>
	<td valign="top">'.$customerUID.'</td>
	<td valign="top">'.$status.'</td>
	<td valign="top">'.money_format('%.2n',$billNETTO).'</td>
	<td valign="top">'.money_format('%.2n',$billBRUTTO).'</td>
	<td valign="top">'.money_format('%.2n',$billMWST).'</td>
	<td valign="top">'.money_format('%.2n',$billDEMAND).'</td>
	<td valign="top">'.$billPAIDDATE.'</td>
	<td valign="top">'.$billBANKACCOUNT.'</td>
	</tr>';
	$tr .= $code; //115 Einträge


	if ($i % 12 == 0)
	{

		$y=$y+$billDEMAND;
		$y=money_format('%.2n',$y);
		$w=$w+$billMWST;
		$w=money_format('%.2n',$w);
		$v=$v+$billBRUTTO;
		$v=money_format('%.2n',$v);

		$tabelle1 = '
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
		  <tr class="td_grey">
			<td width="80" class="td_grey">Datum</td>
			<td class="td_grey" width="80">Beleg-Nr.</td>
			<td class="td_grey" width="70">Kunden-Nr.</td>
			<td class="td_grey" width="280">Kunde</td>
			<td class="td_grey" width="80">USt.ID.</td>
			<td class="td_grey" width="80">Status</td>
			<td class="td_grey" width="120">NETTO</td>
			<td class="td_grey" width="120">BRUTTO</td>
			<td class="td_grey" width="80">MwSt.</td>
			<td class="td_grey" width="120">IST</td>
			<td class="td_grey" width="80">Zahldatum</td>
			<td class="td_grey" width="200">Konto</td>
		  </tr>
		  '.$tr.'
		  <tr class="td_grey">
			<td class="td_grey" width="670">Zwischensumme:</td>
			<td class="td_grey" width="120">'.$x.'</td>
			<td class="td_grey" width="120">'.$v.'</td>
			<td class="td_grey" width="80">'.$w.'</td>
			<td class="td_grey" width="120">'.$y.'</td>
			<td class="td_grey" width="80">&nbsp;</td>
			<td class="td_grey" width="200">&nbsp;</td>
		  </tr>
		</table>
		';
		$html .= $tabelle1;

		$pdf->SetDisplayMode('fullpage', 'SinglePage', 'UseNone');

		// set font
		$pdf->SetFont('dejavusans', '', 7.5);
		// add a page
		$pdf->AddPage('L', 'A3');
		// Print a text
		$pdf->writeHTML($html, true, false, true, false, '');
		$tr="";
	}
}

// ---------------------------------------------------------

//Close and output PDF document
$pdf->Output('Rechnungsausgangsbuch.pdf', 'I');

//============================================================+
// END OF FILE
//============================================================+

// Anzahl Seiten



?>