rechnung.php 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  2. <HTML>
  3. <HEAD>
  4. <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-15">
  5. <style>
  6. .normal
  7. {
  8. font-family: Arial;
  9. font-size: 12px;
  10. }
  11. td.list
  12. {
  13. font-family: Arial;
  14. font-size: 10px;
  15. }
  16. td.list_header
  17. {
  18. font-family: Arial;
  19. font-size: 10px;
  20. font-weight: bold;
  21. border-bottom-style: solid;
  22. border-color: #000000;
  23. border-bottom-width: 1px;
  24. border-top-style: solid;
  25. border-top-width: 1px;
  26. }
  27. </style>
  28. </HEAD>
  29. <BODY LANG="de-DE" DIR="LTR">
  30. <DIV ALIGN=RIGHT>
  31. <TABLE WIDTH="100%" BORDER=0 CELLPADDING=1 CELLSPACING=0>
  32. <TR>
  33. <TD ROWSPAN=3 COLSPAN=2 WIDTH=161 align="left" style="font-weight: bold; font-family: Arial; font-size: 22px;">URSPRUNG</TD>
  34. <TD ROWSPAN=3 COLSPAN=4 WIDTH=274 align="left" style="font-weight: bold; font-family: Arial; font-size: 16px;"><?php echo $assistant_data[13]; ?></TD>
  35. <TD COLSPAN=2 WIDTH=1 align="right" class="normal">Ust.-ID.Nr.</TD>
  36. <TD COLSPAN=2 WIDTH=1 align="left" class="normal"><?php echo $assistant_data[14]; ?></TD>
  37. </TR>
  38. <TR>
  39. <TD COLSPAN=2 WIDTH=1 align="right" class="normal">SteuerNr.</TD>
  40. <TD COLSPAN=2 WIDTH=1 align="left" class="normal"><?php echo $assistant_data[10]; ?></TD>
  41. </TR>
  42. <TR>
  43. <TD COLSPAN=4 WIDTH=1 align="center" class="normal"><?php echo $assistant_data[16]; ?></TD>
  44. </TR>
  45. <TR>
  46. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><b>Waren f&uuml;r Mensch und Natur</b></TD>
  47. <TD ROWSPAN=10 COLSPAN=8 WIDTH=465 align="center" style="font-weight: bold; font-family: Arial; font-size: 22px;">Rechnung <?php echo $bill_data[5]; ?>
  48. <P ALIGN=CENTER style="font-weight: normal; font-family: Arial; font-size: 14px;">Kundennummer: <?php echo $customer_data[0]; ?></P>
  49. <P ALIGN=CENTER style="font-weight: normal; font-family: Arial; font-size: 14px;"><?php echo $assistant_data[6]; ?>, den <?php echo $bill_data[3]; ?></P>
  50. </TD>
  51. </TR>
  52. <TR>
  53. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><?php echo $assistant_data[1]." ".$assistant_data[2]; ?></TD>
  54. </TR>
  55. <TR>
  56. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><?php echo $assistant_data[3]." ".$assistant_data[4]; ?></TD>
  57. </TR>
  58. <TR>
  59. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><?php echo $assistant_data[5]." ".$assistant_data[6]; ?></TD>
  60. </TR>
  61. <TR>
  62. <TD COLSPAN=2 WIDTH=161 align="left" class="normal">Tel: <?php echo $assistant_data[7]; ?></TD>
  63. </TR>
  64. <TR>
  65. <TD COLSPAN=2 WIDTH=161 align="left" class="normal">Fax: <?php echo $assistant_data[8]; ?></TD>
  66. </TR>
  67. <TR>
  68. <TD COLSPAN=2 WIDTH=161 align="left" class="normal">&nbsp;
  69. </TD>
  70. </TR>
  71. <TR>
  72. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><?php echo $customer_data[2]." ".$customer_data[3]; ?></TD>
  73. </TR>
  74. <TR>
  75. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><?php echo $customer_data[4]." ".$customer_data[5]; ?></TD>
  76. </TR>
  77. <TR>
  78. <TD COLSPAN=2 WIDTH=161 align="left" class="normal"><?php echo $customer_data[6]." ".$customer_data[7]; ?></TD>
  79. </TR>
  80. <TR>
  81. <TD COLSPAN=2 WIDTH=161 align="left" class="normal">Tel: <?php echo $customer_data[8]; ?></TD>
  82. <TD COLSPAN=4 WIDTH=274 class="normal">&nbsp;</TD>
  83. <TD COLSPAN=4 WIDTH=1 align="left" class="normal">Rechnungsdatum = Lieferdatum</TD>
  84. </TR>
  85. <TR>
  86. <TD COLSPAN=2 WIDTH=161 align="left" class="normal">Fax: <?php echo $customer_data[9]; ?></TD>
  87. <TD COLSPAN=4 WIDTH=274 class="normal">&nbsp;</TD>
  88. <TD COLSPAN=4 WIDTH=1 align="left" class="normal">Bezahlung per Lastschrifteinzug</TD>
  89. </TR>
  90. </table>
  91. <br>
  92. <TABLE WIDTH="100%" border="0" CELLPADDING=4 CELLSPACING=0>
  93. <THEAD>
  94. <TR>
  95. <TD align="left" class="normal">Rechnung: <?php echo $bill_data[5]; ?></TD>
  96. <TD colspan="10" align="right" class="normal">Kundennummer: <?php echo $customer_data[0]; ?></TD>
  97. </TR>
  98. <TR>
  99. <TD WIDTH="1%" align="center" class="list_header">Artikelnummer</TD>
  100. <TD COLSPAN=2 WIDTH="80%" align="center" class="list_header">Bezeichnung</TD>
  101. <TD WIDTH="1%" align="center" class="list_header">Menge</TD>
  102. <TD WIDTH="20%" align="center" class="list_header">Anmerkung</TD>
  103. <TD WIDTH="1%" align="center" class="list_header">Einzelpreis</TD>
  104. <TD COLSPAN=2 WIDTH="1%" align="center" class="list_header">Rab.</TD>
  105. <TD COLSPAN=2 WIDTH="1%" align="center" class="list_header">MwSt.</TD>
  106. <TD WIDTH="1%" align="center" class="list_header">Gesamt</TD>
  107. </TR>
  108. </THEAD>
  109. <TBODY>
  110. <?php
  111. $netto = 0;
  112. $taxes = $tax->get();
  113. for($i = 0; $i < count($bill_product_data); $i++)
  114. {
  115. $product_data = $product->get($bill_product_data[$i][2]);
  116. if($bill_data[5] == -1)
  117. {
  118. $price_data = $price->getPrice($customer_data[11], $bill_product_data[$i][2]);
  119. $tax_data = $tax->get($product_data[0][4]);
  120. }
  121. else
  122. {
  123. $price_data = array(array('','','',$bill_product_data[$i][6]));
  124. //$tax_data = array(array('', '', $bill_product_data[$i][7]));
  125. $tax_data = $tax->get($product_data[0][4]);
  126. }
  127. $price_netto = $price_data[0][3];
  128. $price_netto_rab = $price_data[0][3] + round($price_data[0][3] * $bill_product_data[$i][5], 2);
  129. $price_brutto = $price_netto + round($price_netto * $tax_data[0][2], 2);
  130. $price_brutto_rab = $price_brutto + round($price_brutto * $bill_product_data[$i][5], 2);
  131. $price_brutto_full = round($price_brutto_rab * $bill_product_data[$i][3],2);
  132. $price_netto_full = round($price_netto_rab * $bill_product_data[$i][3],2);
  133. for($j = 0; $j < count($taxes); $j++)
  134. {
  135. if($taxes[$j][0] == $tax_data[0][0])
  136. {
  137. // add needed array fields for tax sum
  138. while(count($taxes[$j]) < 4)
  139. $taxes[$j] [] = 0;
  140. if($priceset_data[2] == 1)
  141. $taxes[$j][3] += $price_brutto_full/($taxes[$j][2]+1);
  142. else
  143. $taxes[$j][3] += $price_netto_full;
  144. }
  145. }
  146. if($priceset_data[2] == 1)
  147. $netto += $price_netto_full;
  148. else
  149. $netto += $price_brutto_full;
  150. ?>
  151. <TR VALIGN=TOP>
  152. <TD WIDTH="1%" align="center" class="list"><?php echo $product_data[0][0]; ?></TD>
  153. <TD COLSPAN=2 WIDTH="80%" align="center" class="list"><?php echo $product_data[0][1]; ?></TD>
  154. <TD WIDTH="1%" align="center" class="list"><?php echo $bill_product_data[$i][3]; ?></TD>
  155. <TD WIDTH="20%" align="center" class="list"><?php echo $bill_product_data[$i][4]; ?></TD>
  156. <?php
  157. if($priceset_data[2] == 1)
  158. {
  159. ?>
  160. <TD WIDTH="1%" align="center" class="list"><?php echo $price_brutto; ?></TD>
  161. <TD COLSPAN=2 WIDTH="1%" align="center" class="list"><?php echo $bill_product_data[$i][5]; ?></TD>
  162. <TD COLSPAN=2 WIDTH="1%" align="center" class="list"><?php echo $tax_data[0][2]; ?></TD>
  163. <TD WIDTH="1%" align="center" class="list"><?php echo $price_brutto_full; ?></TD>
  164. <?php
  165. }
  166. else
  167. {
  168. ?>
  169. <TD WIDTH="1%" align="center" class="list"><?php echo $price_netto; ?></TD>
  170. <TD COLSPAN=2 WIDTH="1%" align="center" class="list"><?php echo $bill_product_data[$i][5]; ?></TD>
  171. <TD COLSPAN=2 WIDTH="1%" align="center" class="list"><?php echo $tax_data[0][2]; ?></TD>
  172. <TD WIDTH="1%" align="center" class="list"><?php echo $price_netto_full; ?></TD>
  173. <?php
  174. }
  175. ?>
  176. </TR>
  177. <?php
  178. }
  179. ?>
  180. <TR>
  181. <TD COLSPAN=11 WIDTH="100%" align="center" class="list" style="border-bottom-style: solid; border-bottom-color: #000000; border-bottom-width: 1px;">&nbsp;</TD>
  182. </TR>
  183. </TBODY>
  184. </table>
  185. <TABLE WIDTH="100%" border="0" CELLPADDING=4 CELLSPACING=0>
  186. <?php
  187. $tax_overall = 0;
  188. $netto_overall = 0;
  189. for($i = 0; $i < count($taxes); $i++)
  190. {
  191. if(count($taxes[$i]) >= 4)
  192. {
  193. $tax_overall += round($taxes[$i][3]*$taxes[$i][2], 2);
  194. $netto_overall += round($taxes[$i][3], 2);
  195. ?>
  196. <TR>
  197. <TD align="right" class="normal">&nbsp;</TD>
  198. <TD align="left" class="normal">&nbsp;</TD>
  199. <TD WIDTH=150 align="right" class="normal">Steuer <?php echo round($taxes[$i][2]*100, 2); ?>% MwSt. aus</TD>
  200. <TD WIDTH=84 align="right" class="normal"><?php echo round($taxes[$i][3], 2); ?></TD>
  201. <TD WIDTH=84 align="right" class="normal"><?php echo round($taxes[$i][3]*$taxes[$i][2], 2); ?></TD>
  202. </TR>
  203. <?php
  204. }
  205. }
  206. ?>
  207. <TR>
  208. <TD width=1 align="right" class="normal">Bankverbindung: </TD>
  209. <TD align="left" class="normal"><?php echo $assistant_data[15]; ?></TD>
  210. <TD align="right" class="normal">Steuer gesamt:</TD>
  211. <TD WIDTH=84 align="center" class="normal">&nbsp;</TD>
  212. <TD WIDTH=84 align="right" class="normal"><?php echo $tax_overall; ?></TD>
  213. </TR>
  214. <TR>
  215. <TD width=1 align="right" class="normal">BLZ: </TD>
  216. <TD align="left" class="normal"><?php echo $assistant_data[11]; ?></TD>
  217. <TD align="right" class="normal">&nbsp;</TD>
  218. <TD WIDTH=84 align="center" class="normal">&nbsp;</TD>
  219. <TD WIDTH=84 align="right" class="normal">&nbsp;</TD>
  220. </TR>
  221. <TR>
  222. <TD width=1 align="right" class="normal">Kontonummer: </TD>
  223. <TD align="left" class="normal"><?php echo $assistant_data[12]; ?></TD>
  224. <TD align="right" class="normal"><b>Rechnungssumme:</b></TD>
  225. <TD WIDTH=84 align="center" class="normal">&nbsp;</TD>
  226. <TD WIDTH=84 align="right" class="normal"><b><?php echo $tax_overall+$netto_overall; ?></b></TD>
  227. </TR>
  228. </TABLE>
  229. </DIV>
  230. </BODY>
  231. </HTML>