<?php include 'naglowek.php';?>
<?php

$daneklienta = $_POST ['daneklienta'];
$nazwaproduktu = $_POST['nazwaproduktu'];
$ilosc = $_POST['ilosc'];
$jm = $_POST['jm'];
$cenanetto = $_POST['cenanetto'];
$data = date('H:i, jS F Y');

?>

<table align = 'center' border = '2' rules = 'all' class ="tabela_dd1 " cellpadding = "10"><br />
    <td>
    <?php
echo'<p align = center><h4>DOKUMENT DOSTAWY</h4></p>';
echo '<p align = center>Zamówienie przyjęte o ';
echo date('H:i. jS F Y');
echo '</p>';
           

echo "<p align = center>ODBIORCA:  ".$daneklienta."</p>";


echo "<table class = 'stripeMe' bgcolor= white align = 'center' id='tabela_dd'>
<td>NAZWA PRODUKTU</td><td>ILOŚĆ</td><td>J.M</td><td>CENA NETTO</td><td>WARTOŚĆC NETTO</td><td>WARTOŚĆ BRUTTO</td>";
for($i=0; $i<count($nazwaproduktu); $i++):
echo"
<tr>
<td>".$nazwaproduktu[$i]."</td>
<td>".$ilosc[$i]."</td>
<td>".$jm[$i]."</td>
<td>".$cenanetto[$i]."</td>
<td>".$wartoscnetto[$i] = $ilosc[$i] * $cenanetto[$i]. "</td>
<td>".$wartoscbrutto[$i] = $ilosc[$i] * $cenanetto[$i] * 1.05. "</td>
</tr>";

endfor;


echo"</table>";

echo "<table align = right>";
echo "<tr>";
echo "<td>WARTOŚĆ NETTO:"; 
echo"</td>";
echo "<td>".$sumanetto = array_sum($wartoscnetto)."";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>WARTOŚĆ NETTO:";
echo"</td>";
echo"<td>".$sumabrutto = array_sum($wartoscbrutto)."";
echo "</td>" ;
echo "</tr>";

echo "</table>";


include("fpdf/fpdf.php"); 


$string1 = implode("\n", $nazwaproduktu);
$string2 = implode("\n", $ilosc);
$string3 = implode("\n", $cenanetto);
//$string4 = implode("\n", $vat);
$string5 = implode("\p", $wartoscnetto);

$pdf=new FPDF();
$pdf->Open();
$pdf->AddPage('P', 'A4');

$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');

$tekst = iconv('utf-8','windows-1250//TRANSLIT', 
    ' 
    Sprzedawa:
    JARTEX S.C. Jan Jarosz i Łukasz Jarosz 
    Ul.Olsztyńska 20 
    14-310 Miłakowo 
    Telefon: 89 758 59 30');


$pdf -> SetFont('arial_ce', 'B',  20);
$pdf -> SetXY(10, 10);



$pdf -> SetFont('arial_ce', 'B',  10);
$x = $pdf->GetX();
$y = $pdf->GetY();

$orginal = iconv('utf-8','windows-1250//TRANSLIT','ORGINAŁ');
$pdf->Text($x+90, $y+5, $orginal);

$file_logo ='nowelogo.gif';
$pdf->Image($file_logo, $x+150, $y);


$pdf->Write(5,  'data: '.$data);

$pdf->SetXY($x, $y+25);
$pdf->MultiCell(92,5, 
    $tekst,1,'L',0);

$pdf->SetXY($x+100, $y+25);
$pdf->MultiCell(92,5, 
    $tekst,1,'L',0);

$pdf -> SetFont('arial_ce', 'B',  16);
$pdf->Text(80,80, 'DOKUMENT DOSTAWY', 'c');

$pdf -> SetFont('arial_ce', 'B',  10);
$pdf->SetXY($x, $y+75);
$string1_1 = iconv('utf-8','windows-1250//TRANSLIT', $string1);
$pdf->MultiCell(0,7,'NAZWA PRODUKTU
'.$string1_1 ,0,'L',0);


$tekst_ilosc = iconv('utf-8','windows-1250//TRANSLIT','ILOŚĆ
'.$string2);
$pdf->SetXY($x+45, $y+75);
$pdf->MultiCell(0,7,
$tekst_ilosc ,0,'L',0);

$pdf->SetXY($x+70, $y+75);
$pdf->MultiCell(0,7,'CENA NETTO
'.$string3 ,0,'L',0);

$pdf->SetXY($x+105, $y+75);
$pdf->MultiCell(0,7,'PODATEK VAT
' ,0,'L',0);

$nazwaproduktu_2 = iconv('utf-8','windows-1250//TRANSLIT',$string5);
$pdf->SetXY($x+100, $y+75);
$pdf->MultiCell(0,7,
$nazwaproduktu_2 ,0,'L',0);

$tekst_wartosc_netto = iconv('utf-8','windows-1250//TRANSLIT','WARTOŚĆ NETTO
');
$pdf->SetXY($x+135, $y+75);
$pdf->MultiCell(0,7,$tekst_wartosc_netto,0,'L',0);

$pdf -> SetFont('arial_ce', 'B',  14);
$tekst_sumanetto = iconv('utf-8','windows-1250//TRANSLIT','Wartość netto: '.$sumanetto);
$pdf->Text($x+110, $y+170, $tekst_sumanetto);

$tekst_sumabrutto = iconv('utf-8','windows-1250//TRANSLIT','Wartość brutto: '.$sumabrutto);
$pdf->Text($x+110, $y+180, $tekst_sumabrutto);

$pdf -> SetFont('arial_ce', '',  12);
$tekst_podpisy = iconv('utf-8','windows-1250//TRANSLIT',
'Wystawił: .......................  Wydał: ....................... Odebrał: .......................'
    );
$pdf->Text($x+50, $y+220, $tekst_podpisy);

$pdf->SetFont('arial_ce','', $size = 10);
$pdf->SetXY($x, $y + 235);
$pdf->MultiCell(0,20, 'INFORMACJE / UWAGI :', 1);

$pdf->SetDisplayMode(100);


$pdf->Output('ddddddd.pdf');

?>
       
       
<?php
  
 
mysql_connect('localhost', 'root', '');
mysql_select_db('jartexsoft_cba_pl');


$sql = "INSERT INTO dokumenty_dostaw (`nazwa_produktu`, `ilosc`) VALUES";
 
$tablica =  $_POST['nazwaproduktu'] ;
$tablica2 = $_POST['ilosc'];
 
$tablica_len = count($tablica);
 
 
 
foreach($tablica as $k => $wartosc){
   $ilosc = $tablica2[$k];
  echo $sql;
  $sql .= "('$wartosc' '$ilosc' )".((($k >= $tablica_len) || ($tablica_len == 1)) ? ';' : ',');
 
}

echo $sql;
mysql_query($sql);



?>
        
        
        
</td>
</table>
<br />


<?php include 'stopka.php'; ?>