API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 16th, 2019
311
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 76.23 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO public.users (id,uuid,version,email,maxcaloriesperday,passworddigest,username,firm_id) VALUES (1, 'a8c8d4ba-0f72-4cf7-9c80-8fd64e37c228', 1, 'skuska858@gmail.com',2000, '$2a$10$LYgpD9tZ8XSH2N5geT724OpUs.GyF2m7U2bt5Z3L2hKahrUWbxniO','ppppetoooo',null);
  2. INSERT INTO public.users (id,uuid,version,email,maxcaloriesperday,passworddigest,username,firm_id) VALUES (2, 'a8c8d4ba-0f72-4cf7-9c80-8fd64e37c229', 1, 'skuska859@gmail.com',2000, '$2a$10$LYgpD9tZ8XSH2N5geT724OpUs.GyF2m7U2bt5Z3L2hKahrUWbxniO','pppetooo',null);
  3.  
  4. INSERT INTO public.menuOption (id,uuid,version,menu,reference,title,user_id) VALUES (1, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'invoices','dashboard.home', 'InvoicesSubMenu1', 1);
  5. INSERT INTO public.menuOption (id,uuid,version,menu,reference,title,user_id) VALUES (2, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'invoices','dashboard.home', 'InvoicesSubMenu2', 1);
  6. INSERT INTO public.menuOption (id,uuid,version,menu,reference,title,user_id) VALUES (3, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'storageItems','dashboard.home', 'StorageItemsSubMenu', 1);
  7. INSERT INTO public.menuOption (id,uuid,version,menu,reference,title,user_id) VALUES (4, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'invoices','dashboard.home', 'InvoicesSubMenu1', 2);
  8. INSERT INTO public.menuOption (id,uuid,version,menu,reference,title,user_id) VALUES (5, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'storageItems','dashboard.home', 'StorageItemsSubMenu', 2);
  9.  
  10. INSERT INTO public.permission (id,uuid,version,description,key,user_id) VALUES (10, '73c8c2d7-914e-42c0-a834-94c778023803', 0, 'uctovnik', 'uct', 1);
  11. INSERT INTO public.permission (id,uuid,version,description,key,user_id) VALUES (11, '73c8c2d7-914e-42c0-a834-94c778023804', 0, 'skladnik', 'skl', 1);
  12. INSERT INTO public.permission (id,uuid,version,description,key,user_id) VALUES (12, '73c8c2d7-914e-42c0-a834-94c778023805', 0, 'predavac', 'pre', 1);
  13.  
  14. INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (1, '11c8c2d7-914e-42c0-a834-94c778023806', 0, 'Stara Gala 99', '90000 HOLICE', 'Slovakia');
  15. INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (2, '12c8c2d7-914e-42c0-a834-94c778023806', 0, 'Kukucinska 88', '90111 DUNAJSKA STREDA', 'Slovakia');
  16. INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (3, '13c8c2d7-914e-42c0-a834-94c778023806', 0, 'Hlavna 77', '90222 BRATISLAVA', 'Slovakia');
  17. INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (4, '14c8c2d7-914e-42c0-a834-94c778023806', 0, 'Dunajska 66', '90333 GYOR', 'Hungary');
  18.  
  19. INSERT INTO public.firms (id,uuid,version,accountNum,address_id,dic,icDph,ico,name,note) VALUES (2, '5d403387-e087-4e9f-880f-af7a60bb2db0', 0, '1',1, 'dic1','icDph1','ico1','firma1','poznamka 1');
  20. INSERT INTO public.firms (id,uuid,version,accountNum,address_id,dic,icDph,ico,name,note) VALUES (6, '6d403387-e087-4e9f-880f-af7a60bb2db0', 0, '2',2, 'dic2','icDph2','ico2','firma2','poznamka 2');
  21. INSERT INTO public.firms (id,uuid,version,accountNum,address_id,dic,icDph,ico,name,note) VALUES (8, '7d403387-e087-4e9f-880f-af7a60bb2db0', 0, '3',3, 'dic3','icDph3','ico3','firma3','poznamka 3');
  22. INSERT INTO public.firms (id,uuid,version,accountNum,address_id,dic,icDph,ico,name,note) VALUES (9, '8d403387-e087-4e9f-880f-af7a60bb2db0', 0, '4',4, 'dic4','icDph4','ico4','firma4','poznamka 4');
  23.  
  24. INSERT INTO public.license (id,uuid,version,typelicense,descriptionlicense,expirationdate,firm_id) VALUES (20, '5d403387-e087-4e9f-880f-af7a60bb2da1', 0, 1, 'Licencia pre dodavku materialu','2019/09/29', 2);
  25. INSERT INTO public.license (id,uuid,version,typelicense,descriptionlicense,expirationdate,firm_id) VALUES (21, '5d403387-e087-4e9f-880f-af7a60bb2da2', 0, 2, 'Licencia pre dodavku prace','2019/09/29', 2);
  26. INSERT INTO public.license (id,uuid,version,typelicense,descriptionlicense,expirationdate,firm_id) VALUES (22, '5d403387-e087-4e9f-880f-af7a60bb2da3', 0, 3, 'Licencia pre odber','2019/09/29', 2);
  27. INSERT INTO public.license (id,uuid,version,typelicense,descriptionlicense,expirationdate,firm_id) VALUES (23, '5d403387-e087-4e9f-880f-af7a60bb2da3', 0, 3, 'Licencia pre odber','2019/09/29', 6);
  28.  
  29. UPDATE public.users SET firm_id = 2 WHERE id = 1;
  30.  
  31. INSERT INTO public.storage (id,uuid,version,address,name,type,note,firm_id) VALUES (3, '3ec8ad6c-1c9f-4d16-90f5-ec0284819795', 0,'address1', 'sklad1', 'typ 1', 'poznamka 1', 2);
  32. INSERT INTO public.storage (id,uuid,version,address,name,type,note,firm_id) VALUES (4, '3ec8ad6c-1c9f-4d16-90f5-ec0284819796', 0,'address2', 'sklad2', 'typ 2', 'poznamka 2', 2);
  33. INSERT INTO public.storage (id,uuid,version,address,name,type,note,firm_id) VALUES (5, '3ec8ad6c-1c9f-4d16-90f5-ec0284819797', 0,'address3', 'sklad3', 'typ 3', 'poznamka 3', 2);
  34.  
  35. INSERT INTO public.storageItem (id,uuid,version,name,description,shortdescription,catalog,currency,mj,discount,quantity,purchasedph,saledph,purchaseprice,saleprice,mountingprice,serialnumber,sigroup,typewarranty,warranty,unit,unitprice,volume,weight,storage_id,qrcode,additions,status,note,isPhoto) VALUES (7, '5d403387-e087-4e9f-880f-af7a60bb2db1', 0, 'storageItem1','skladova polozka 1','sp1','catalog1','EUR','ks',15.3, 1, 0.11, 0.01, 11.11, 10.10, 12, 'SERIALNUM123', 'group1', 'Y', 2, 'unit1', 44, 1.1, 2.2, 3, '5d403387-e087-4e9f-880f-af7a60bb2db1', 'abcd|efgh|ijkl','evid','poznamka1',0);
  36. INSERT INTO public.storageItem (id,uuid,version,name,description,shortdescription,catalog,currency,mj,discount,quantity,purchasedph,saledph,purchaseprice,saleprice,mountingprice,serialnumber,sigroup,typewarranty,warranty,unit,unitprice,volume,weight,storage_id,qrcode,additions,status,note,isPhoto) VALUES (8, '5d403387-e087-4e9f-880f-af7a60bb2db2', 0, 'storageItem2','skladova polozka 2','sp2','catalog2','CZE','kg',17.7, 2, 0.22, 0.02, 22.22, 12.12, 13, 'SERIALNUM456', 'group2', 'M', 6, 'unit2', 55, 2.2, 3.3, 3, '5d403387-e087-4e9f-880f-af7a60bb2db2', 'abcd|efgh|ijkl', 'stored', 'poznamka2',0);
  37. INSERT INTO public.storageItem (id,uuid,version,name,description,shortdescription,catalog,currency,mj,discount,quantity,purchasedph,saledph,purchaseprice,saleprice,mountingprice,serialnumber,sigroup,typewarranty,warranty,unit,unitprice,volume,weight,storage_id,qrcode,additions,status,note,isPhoto) VALUES (9, '5d403387-e087-4e9f-880f-af7a60bb2db3', 0, 'storageItem3','skladova polozka 3','sp3','catalog3','AUD','cm',18.8, 3, 0.33, 0.03, 33.33, 13.13, 14, 'SERIALNUM789', 'group3', 'D', 300, 'unit3', 66, 3.3, 4.4, 3,'5d403387-e087-4e9f-880f-af7a60bb2db3', 'abcd|efgh|ijkl', 'new', 'poznamka3',0);
  38.  
  39. INSERT INTO public.trader(id,uuid,version,name,address,mailaddress,accountNum,ico,dic,icDph,supplyjob,supplymaterial,typepurchaser,typesuplier,note,firm_id) VALUES (33, '5d403387-e087-4e9f-880f-af7a60bb2db9', 0, 'obchodnik 1','adresa obchodnika 1','skuska858@gmail.com','0000000000000','123456789','987654321','741852963',1, 1, 0, 1, 'poznamka 1', 9);
  40. INSERT INTO public.trader(id,uuid,version,name,address,mailaddress,accountNum,ico,dic,icDph,supplyjob,supplymaterial,typepurchaser,typesuplier,note,firm_id) VALUES (34, '5d403387-e087-4e9f-880f-af7a60bb2db8', 0, 'obchodnik 2','adresa obchodnika 2','skuska860@gmail.com','111111111111','789456123','963852741','753159',0, 0, 1, 0, 'poznamka 2', 6);
  41. INSERT INTO public.trader(id,uuid,version,name,address,mailaddress,accountNum,ico,dic,icDph,supplyjob,supplymaterial,typepurchaser,typesuplier,note,firm_id) VALUES (35, '5d403387-e087-4e9f-880f-af7a60bb2db7', 0, 'obchodnik 3','adresa obchodnika 2','skuska8861@gmail.com','222222222222','456789123','147258369','7895123',1, 0, 0, 1, 'poznamka 3', 2);
  42.  
  43. INSERT INTO public.bankconnection (id,uuid,version,accountNum,bank_name,iban,note,swift,firm_id) VALUES (1, '7f403387-e087-4e9f-880f-af7a60bb2da1', 0, '0000000000000000', 'OMG', 'SK0000000000000000000000', 'niลกt', 'LOL', 2);
  44.  
  45. INSERT INTO public.dividing_dph(id,uuid,version,name,key,validFrom,validTo) VALUES (1,'7f403387-e087-4e9f-880f-af7a60bb2da1',0,'name',null,null,null);
  46.  
  47. INSERT INTO public.invoice (id,uuid,version,note,constantsymbol,dateoftheacoountingcase,dateofvatentry,deliverydate,documentdescription,documentnumber,duedate,initialdocumentnumber,invoicetype,dateofissue,paid,bankconnection_id,creditnote,trader_id,dividingdph_id,firm_id,paymentMethod,variableSymbol) VALUES (1, '9n403387-e087-4e9f-880f-af7a60bb2da1', 0, 'note1', 77777,'2019/08/16','2019/08/16','2019/08/16','description',1,'2019/09/28','initialdocnum','invoiceeeetype','2019/08/16' , '2017/08/16', 1, 1,34,1,8,'cash','6564');
  48. INSERT INTO public.invoice (id,uuid,version,note,dateofissue,paid,bankconnection_id,creditnote,trader_id,dividingdph_id,firm_id) VALUES (2, '9n406387-e087-4e9f-880f-af7a60bb2da1', 0, 'note2', '2019/08/16' , '2017/08/16', 1, 1,33,1,2);
  49. INSERT INTO public.invoice (id,uuid,version,note,dateofissue,paid,bankconnection_id,creditnote,trader_id,dividingdph_id,firm_id) VALUES (3, '9n403387-e087-4e9f-880f-af7a60bb2da1', 0, 'note3', '2019/08/16' , '2017/08/16', 1, 1,34,1,2);
  50. INSERT INTO public.invoice (id,uuid,version,note,dateofissue,paid,bankconnection_id,creditnote,trader_id,dividingdph_id,firm_id) VALUES (4, '9n503387-e087-4e9f-880f-af7a60bb2da1', 0, 'note4', '2019/08/16' , '2017/08/16', 1, 1,35,1,2);
  51.  
  52. INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (1, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'Delivered', 'DL');
  53. INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (2, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'Created', 'CR');
  54. INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (3, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'InProgress', 'IPR');
  55. INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (4, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'Denied', 'DE');
  56.  
  57. INSERT INTO public.deliverynote (id,uuid,version,dateofacceptance,dateofissue,documentnumber,note,ordernumber,status_id,customer_id,trader_id) VALUES (1, '9n403387-e087-4e9f-880f-af7a60bb2da1', 0, '2019/08/16','2019/08/16',648,'note1',1,3,2,33);
  58. INSERT INTO public.deliverynote (id,uuid,version,dateofacceptance,dateofissue,documentnumber,note,ordernumber,status_id,customer_id,trader_id) VALUES (2, '9n403387-e087-4e9f-880f-af7a60bb2da1', 0, '2019/08/16','2019/08/16',999,'note2',1,2,6,34);
  59. INSERT INTO public.deliverynote (id,uuid,version,dateofacceptance,dateofissue,documentnumber,note,ordernumber,status_id,customer_id,trader_id) VALUES (3, '9n403387-e087-4e9f-880f-af7a60bb2da1', 0, '2019/08/16','2019/08/16',724,'note3',1,1,8,35);
  60.  
  61. INSERT INTO public.offer (id,uuid,version,additions,address,layoutdate,note,projectname,realizationdate,status_id,firm_id) VALUES (1, '9n503387-e087-4e9f-880f-af7a60bb2da1', 0, 'add1','address1','2017/08/16','note1','project1','2012/08/16',2,2);
  62. INSERT INTO public.offer (id,uuid,version,additions,address,layoutdate,note,projectname,realizationdate,status_id,firm_id) VALUES (2, '9n503387-e087-4e9f-880f-af7a60bb2da1', 0, 'add2','address2','2016/08/16','note2','project1','2015/08/16',3,2);
  63. INSERT INTO public.offer (id,uuid,version,additions,address,layoutdate,note,projectname,realizationdate,status_id,firm_id) VALUES (3, '9n503387-e087-4e9f-880f-af7a60bb2da1', 0, 'add3','address3','2014/08/16','note3','project1','2019/08/16',1,2);
  64.  
  65. INSERT INTO public.storageitem_document (id,uuid,version,deliverytype,dphpercent,note,priceofone,pricewithdph,pricewithoutdph,realquantity,shippingname,invoice_id,firm_id) VALUES (1, '5d403387-e087-4e9f-880f-af7a60bb2da1', 0, 'posta',20,'test1',1000,1000,800,1,'posta123',1,2);
  66. INSERT INTO public.storageitem_document (id,uuid,version,deliverytype,dphpercent,note,priceofone,pricewithdph,pricewithoutdph,realquantity,shippingname,invoice_id,firm_id) VALUES (2, '6d403387-e087-4e9f-880f-af7a60bb2da1', 0, 'kurier',20,'test1',200,200,160,1,'UPS',1,2);
  67.  
  68. INSERT INTO public.templates_for_pdf (id,uuid,version,name,typeOfTemplate,validFrom,validTo) VALUES (1, '3ec8ad6c-1c9f-4d16-90f5-ec0284819797', 0, 'faktura', 'invoice', '2015/09/29', '2029/10/29');
  69.  
  70. UPDATE public.templates_for_pdf SET template = '<?xml version="1.0" encoding="UTF-8"?>
  71. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" version="1.0">
  72. <xsl:output encoding="UTF-8" indent="yes" method="xml" standalone="no" omit-xml-declaration="no"/>
  73. <xsl:template match="sk.elsy.allquite.app.model.Invoice">
  74. <fo:root language="EN" font-family="Arial">
  75. <fo:layout-master-set>
  76. <fo:simple-page-master master-name="A4-portrail" page-height="297mm" page-width="210mm" margin-top="5mm" margin-bottom="5mm" margin-left="20mm" margin-right="15mm">
  77. <fo:region-body margin-top="25mm" margin-bottom="20mm"/>
  78. <fo:region-before region-name="xsl-region-before" extent="25mm" display-align="before" precedence="true"/>
  79. </fo:simple-page-master>
  80. </fo:layout-master-set>
  81. <fo:page-sequence master-reference="A4-portrail">
  82.  
  83. <fo:flow flow-name="xsl-region-body" border-collapse="collapse" reference-orientation="0">
  84.  
  85.  
  86. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="2mm">
  87. <fo:table-column column-width="35%"/>
  88. <fo:table-column column-width="30%"/>
  89. <fo:table-column column-width="35%"/>
  90.  
  91. <fo:table-body font-size="95%">
  92. <fo:table-row height="10mm">
  93.  
  94. <fo:table-cell >
  95. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
  96. <fo:table-column column-width="100%"/>
  97. <fo:table-body font-size="95%">
  98. <fo:table-row>
  99. <fo:table-cell >
  100. <fo:block><fo:block font-size="12pt" font-weight="bold">Invoice template</fo:block></fo:block>
  101. </fo:table-cell>
  102. </fo:table-row>
  103. <fo:table-row>
  104.  
  105. <fo:table-cell>
  106. <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/street"/></fo:block></fo:block>
  107. </fo:table-cell>
  108. </fo:table-row>
  109. <fo:table-row>
  110. <fo:table-cell>
  111. <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/zipCode"/> </fo:block></fo:block>
  112. </fo:table-cell>
  113. </fo:table-row>
  114. <fo:table-row>
  115. <fo:table-cell>
  116. <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/country"/> </fo:block></fo:block>
  117. </fo:table-cell>
  118. </fo:table-row>
  119. </fo:table-body>
  120. </fo:table>
  121. </fo:table-cell>
  122.  
  123. <fo:table-cell>
  124. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm" text-align="center">
  125. <fo:table-column column-width="100%"/>
  126. <fo:table-body font-size="95%">
  127. <fo:table-row>
  128. <fo:table-cell >
  129. <fo:block><fo:block >&#x2028;&#x2028;&#x2028;</fo:block></fo:block>
  130. </fo:table-cell>
  131. </fo:table-row>
  132. <fo:table-row>
  133. <fo:table-cell>
  134. <fo:block><fo:block font-size="10pt">ICO: <xsl:value-of select="trader/firm/ico"/></fo:block></fo:block>
  135. </fo:table-cell>
  136. </fo:table-row>
  137. <fo:table-row>
  138. <fo:table-cell>
  139. <fo:block><fo:block font-size="10pt">DIC: <xsl:value-of select="trader/firm/dic"/></fo:block></fo:block>
  140. </fo:table-cell>
  141. </fo:table-row>
  142. <fo:table-row>
  143. <fo:table-cell>
  144. <fo:block><fo:block font-size="10pt">IC DPH:<xsl:value-of select="trader/firm/icDph"/></fo:block></fo:block>
  145. </fo:table-cell>
  146. </fo:table-row>
  147. </fo:table-body>
  148. </fo:table>
  149. </fo:table-cell>
  150.  
  151. <fo:table-cell>
  152. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
  153. <fo:table-column column-width="100%"/>
  154. <fo:table-body font-size="95%">
  155. <fo:table-row>
  156. <fo:table-cell >
  157. <fo:block><fo:block font-size="7pt">mobil: ???</fo:block></fo:block>
  158. </fo:table-cell>
  159. </fo:table-row>
  160. <fo:table-row>
  161. <fo:table-cell>
  162. <fo:block><fo:block font-size="7pt">tel: ???</fo:block></fo:block>
  163. </fo:table-cell>
  164. </fo:table-row>
  165. <fo:table-row>
  166. <fo:table-cell>
  167. <fo:block><fo:block font-size="7pt">fax: ???</fo:block></fo:block>
  168. </fo:table-cell>
  169. </fo:table-row>
  170. <fo:table-row>
  171. <fo:table-cell>
  172. <fo:block><fo:block font-size="7pt">e-mail: <xsl:value-of select="trader/mailAddress"/></fo:block></fo:block>
  173. </fo:table-cell>
  174. </fo:table-row>
  175. <fo:table-row>
  176. <fo:table-cell>
  177. <fo:block><fo:block font-size="7pt">www: ???</fo:block></fo:block>
  178. </fo:table-cell>
  179. </fo:table-row>
  180. <fo:table-row>
  181. <fo:table-cell>
  182. <fo:block><fo:block font-size="7pt">Spolocnost zapisana v OR ...</fo:block></fo:block>
  183. </fo:table-cell>
  184. </fo:table-row>
  185. </fo:table-body>
  186. </fo:table>
  187. </fo:table-cell>
  188.  
  189. </fo:table-row>
  190. </fo:table-body>
  191. </fo:table>
  192.  
  193.  
  194. <fo:table table-layout="fixed" width="100%" font-size="10pt" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="none" border-left-style="none" border-right-style="none" display-align="center" space-after="5mm">
  195. <fo:table-column column-width="70%"/>
  196. <fo:table-column column-width="30%"/>
  197. <fo:table-body font-size="95%">
  198. <fo:table-row height="10mm">
  199. <fo:table-cell >
  200. <fo:block><fo:block font-size="16pt" font-weight="bold">Faktura <xsl:value-of select="id"/></fo:block></fo:block>
  201. </fo:table-cell>
  202. <fo:table-cell>
  203. <fo:block font-size="18pt" font-weight="bold" text-align="center" border-style="solid" border-top-style="none" line-height="10mm">Cislo fakt.: <xsl:value-of select="id"/></fo:block>
  204. </fo:table-cell>
  205. </fo:table-row>
  206. </fo:table-body>
  207. </fo:table>
  208.  
  209.  
  210. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
  211. <fo:table-column column-width="50%"/>
  212. <fo:table-column column-width="50%"/>
  213. <fo:table-body font-size="95%">
  214. <fo:table-row>
  215.  
  216. <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-left-style="none">
  217. <fo:table table-layout="fixed" width="100%" display-align="center">
  218. <fo:table-column column-width="50%"/>
  219. <fo:table-column column-width="50%"/>
  220. <fo:table-body font-size="95%">
  221. <fo:table-row>
  222. <fo:table-cell >
  223. <fo:block font-size="7pt">&#x2028;</fo:block>
  224. </fo:table-cell>
  225. </fo:table-row>
  226. <fo:table-row>
  227. <fo:table-cell>
  228. <fo:block font-size="11pt" font-weight="bold" line-height="15mm">&#x2028;</fo:block>
  229. </fo:table-cell>
  230. </fo:table-row>
  231. <fo:table-row>
  232. <fo:table-cell>
  233. <fo:block font-size="10pt" font-weight="bold">&#x2028;</fo:block>
  234. </fo:table-cell>
  235. </fo:table-row>
  236. <fo:table-row>
  237. <fo:table-cell>
  238. <fo:block font-size="10pt">Platba: <xsl:value-of select="paymentMethod"/></fo:block>
  239. </fo:table-cell>
  240. </fo:table-row>
  241. <fo:table-row>
  242. <fo:table-cell>
  243. <fo:block font-size="10pt">Doprava: <xsl:value-of select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document/deliveryType"/></fo:block>
  244. </fo:table-cell>
  245. </fo:table-row>
  246. <fo:table-row>
  247. <fo:table-cell >
  248. <fo:block font-size="8pt">&#x2028;</fo:block>
  249. </fo:table-cell>
  250. </fo:table-row>
  251. </fo:table-body>
  252. </fo:table>
  253. <fo:table table-layout="fixed" width="100%" display-align="center">
  254. <fo:table-column column-width="49%"/>
  255. <fo:table-column column-width="2%"/>
  256. <fo:table-column column-width="49%"/>
  257. <fo:table-body font-size="95%">
  258. <fo:table-row>
  259. <fo:table-cell >
  260. <fo:table table-layout="fixed" width="100%" display-align="center" >
  261. <fo:table-column column-width="50%"/>
  262. <fo:table-column column-width="50%"/>
  263. <fo:table-body font-size="95%">
  264. <fo:table-row border-bottom="0.35mm solid black">
  265. <fo:table-cell>
  266. <fo:block font-size="10pt">Datum</fo:block>
  267. </fo:table-cell>
  268. </fo:table-row>
  269. <fo:table-row>
  270. <fo:table-cell >
  271. <fo:block font-size="8pt">vystavenia:</fo:block>
  272. </fo:table-cell>
  273. <fo:table-cell >
  274. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfIssue"/></fo:block>
  275. </fo:table-cell>
  276. </fo:table-row>
  277. <fo:table-row>
  278. <fo:table-cell>
  279. <fo:block font-size="8pt">splatnosti:</fo:block>
  280. </fo:table-cell>
  281. <fo:table-cell >
  282. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dueDate"/></fo:block>
  283. </fo:table-cell>
  284. </fo:table-row>
  285. <fo:table-row>
  286. <fo:table-cell >
  287. <fo:block font-size="8pt">dodania</fo:block>
  288. </fo:table-cell>
  289. <fo:table-cell >
  290. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfVatEntry"/></fo:block>
  291. </fo:table-cell>
  292. </fo:table-row>
  293. <fo:table-row>
  294. <fo:table-cell>
  295. <fo:block font-size="8pt" font-weight="bold">Bankovy ucet:</fo:block>
  296. </fo:table-cell>
  297. </fo:table-row>
  298. </fo:table-body>
  299. </fo:table>
  300. </fo:table-cell>
  301. <fo:table-cell >
  302. <fo:block></fo:block>
  303. </fo:table-cell>
  304. <fo:table-cell>
  305. <fo:table table-layout="fixed" width="100%" display-align="center">
  306. <fo:table-column column-width="50%"/>
  307. <fo:table-column column-width="50%"/>
  308. <fo:table-body font-size="95%">
  309. <fo:table-row border-bottom="0.35mm solid black">
  310. <fo:table-cell>
  311. <fo:block font-size="10pt">Symbol</fo:block>
  312. </fo:table-cell>
  313. </fo:table-row>
  314. <fo:table-row>
  315. <fo:table-cell>
  316. <fo:block font-size="8pt">konstantny</fo:block>
  317. </fo:table-cell>
  318. <fo:table-cell>
  319. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="constantSymbol"/></fo:block>
  320. </fo:table-cell>
  321. </fo:table-row>
  322. <fo:table-row>
  323. <fo:table-cell>
  324. <fo:block font-size="8pt">variabilny</fo:block>
  325. </fo:table-cell>
  326. <fo:table-cell >
  327. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="variableSymbol"/></fo:block>
  328. </fo:table-cell>
  329. </fo:table-row>
  330. <fo:table-row>
  331. <fo:table-cell >
  332. <fo:block font-size="8pt">specificky</fo:block>
  333. </fo:table-cell>
  334. <fo:table-cell >
  335. <fo:block font-size="8pt" text-align="right">???</fo:block>
  336. </fo:table-cell>
  337. </fo:table-row>
  338. <fo:table-row>
  339. <fo:table-cell>
  340. <fo:block></fo:block>
  341. </fo:table-cell>
  342. <fo:table-cell>
  343. <fo:block font-size="8pt" font-weight="bold" text-align="right">TATR</fo:block>
  344. </fo:table-cell>
  345. </fo:table-row>
  346. </fo:table-body>
  347. </fo:table>
  348. </fo:table-cell>
  349. </fo:table-row>
  350. </fo:table-body>
  351. </fo:table>
  352. <fo:table table-layout="fixed" width="100%" display-align="center" border-style="solid" border-width="0.35mm">
  353. <fo:table-column column-width="10%"/>
  354. <fo:table-column column-width="45%"/>
  355. <fo:table-column column-width="45%"/>
  356. <fo:table-body font-size="95%">
  357. <fo:table-row>
  358. <fo:table-cell>
  359. <fo:block font-size="8pt">cislo:</fo:block>
  360. </fo:table-cell>
  361. <fo:table-cell>
  362. <fo:block font-size="8pt"><xsl:value-of select="bankConnection/accountNum"/></fo:block>
  363. </fo:table-cell>
  364. <fo:table-cell>
  365. <fo:block font-size="8pt"></fo:block>
  366. </fo:table-cell>
  367. </fo:table-row>
  368. <fo:table-row>
  369. <fo:table-cell>
  370. <fo:block font-size="8pt">IBAN:</fo:block>
  371. </fo:table-cell>
  372. <fo:table-cell>
  373. <fo:block font-size="8pt"><xsl:value-of select="bankConnection/iban"/></fo:block>
  374. </fo:table-cell>
  375. <fo:table-cell>
  376. <fo:block font-size="8pt" text-align="right">SWIFT: <xsl:value-of select="bankConnection/swift"/></fo:block>
  377. </fo:table-cell>
  378. </fo:table-row>
  379. </fo:table-body>
  380. </fo:table>
  381. </fo:table-cell>
  382.  
  383. <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-right-style="none">
  384. <fo:table table-layout="fixed" width="100%" display-align="center" space-after="5mm">
  385. <fo:table-column column-width="100%"/>
  386. <fo:table-body font-size="95%">
  387. <fo:table-row>
  388. <fo:table-cell >
  389. <fo:block font-size="8pt">Objednavka:</fo:block>
  390. </fo:table-cell>
  391. </fo:table-row>
  392. <fo:table-row>
  393. <fo:table-cell >
  394. <fo:block font-size="8pt">Povodna faktura(pri dobropise): </fo:block>
  395. </fo:table-cell>
  396. </fo:table-row>
  397. <fo:table-row>
  398. <fo:table-cell border-style="solid" border-width="0.35mm" border-top-style="none" border-left-style="none" border-right-style="none">
  399. <fo:block font-size="9pt">&#x2028;Odberatel: </fo:block>
  400. </fo:table-cell>
  401. </fo:table-row>
  402. <fo:table-row>
  403. <fo:table-cell>
  404. <fo:block font-size="12pt" font-weight="bold" line-height="15mm">Customer ??? <xsl:value-of select="firm/name"/></fo:block>
  405. </fo:table-cell>
  406. </fo:table-row>
  407. <fo:table-row>
  408. <fo:table-cell>
  409. <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/street"/></fo:block>
  410. </fo:table-cell>
  411. </fo:table-row>
  412. <fo:table-row>
  413. <fo:table-cell>
  414. <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/zipCode"/></fo:block>
  415. </fo:table-cell>
  416. </fo:table-row>
  417. <fo:table-row>
  418. <fo:table-cell>
  419. <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/country"/></fo:block>
  420. </fo:table-cell>
  421. </fo:table-row>
  422. </fo:table-body>
  423. </fo:table>
  424. <fo:table table-layout="fixed" width="100%" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="none" border-left-style="none" border-right-style="none" display-align="center" space-after="5mm">
  425. <fo:table-column column-width="50%"/>
  426. <fo:table-column column-width="50%"/>
  427. <fo:table-body font-size="95%">
  428. <fo:table-row>
  429. <fo:table-cell >
  430. <fo:block><fo:block font-size="10pt" font-family="Arial" >Konecna prijemca</fo:block></fo:block>
  431. </fo:table-cell>
  432. <fo:table-cell>
  433. <fo:block font-size="10pt" text-align="center">ICO: <xsl:value-of select="firm/ico"/></fo:block>
  434. </fo:table-cell>
  435. </fo:table-row>
  436. <fo:table-row>
  437. <fo:table-cell >
  438. <fo:block font-size="10pt" >&#x2028;</fo:block>
  439. </fo:table-cell>
  440. <fo:table-cell>
  441. <fo:block font-size="10pt" text-align="center">DIC: <xsl:value-of select="firm/dic"/></fo:block>
  442. </fo:table-cell>
  443. </fo:table-row>
  444. <fo:table-row>
  445. <fo:table-cell >
  446. <fo:block font-size="10pt" >&#x2028;</fo:block>
  447. </fo:table-cell>
  448. <fo:table-cell>
  449. <fo:block font-size="10pt" text-align="center">IC DPH:<xsl:value-of select="firm/icDph"/></fo:block>
  450. </fo:table-cell>
  451. </fo:table-row>
  452. <fo:table-row>
  453. <fo:table-cell >
  454. <fo:block font-size="10pt" >???</fo:block>
  455. </fo:table-cell>
  456. </fo:table-row>
  457. <fo:table-row>
  458. <fo:table-cell >
  459. <fo:block font-size="10pt" >???</fo:block>
  460. </fo:table-cell>
  461. </fo:table-row>
  462. <fo:table-row>
  463. <fo:table-cell >
  464. <fo:block font-size="10pt" >???</fo:block>
  465. </fo:table-cell>
  466. </fo:table-row>
  467. <fo:table-row>
  468. <fo:table-cell >
  469. <fo:block font-size="10pt" >???</fo:block>
  470. </fo:table-cell>
  471. </fo:table-row>
  472. </fo:table-body>
  473. </fo:table>
  474. </fo:table-cell>
  475.  
  476. </fo:table-row>
  477. </fo:table-body>
  478. </fo:table>
  479.  
  480. <fo:table table-layout="fixed" width="100%"
  481. display-align="center" space-after="5mm">
  482. <fo:table-column column-width="21%" />
  483. <fo:table-column column-width="16%" />
  484. <fo:table-column column-width="11%" />
  485. <fo:table-column column-width="11%" />
  486. <fo:table-column column-width="8%" />
  487. <fo:table-column column-width="11%" />
  488. <fo:table-column column-width="11%" />
  489. <fo:table-column column-width="11%" />
  490. <fo:table-body font-size="95%">
  491. <fo:table-row border-bottom="0.35mm solid black">
  492. <fo:table-cell>
  493. <fo:block font-size="8pt">Oznacenie dodavky</fo:block>
  494. </fo:table-cell>
  495. <fo:table-cell>
  496. <fo:block font-size="8pt" text-align="center">Katalog. Oznacenie</fo:block>
  497. </fo:table-cell>
  498. <fo:table-cell>
  499. <fo:block font-size="8pt" text-align="center">Pocet m.j. m.j.</fo:block>
  500. </fo:table-cell>
  501. <fo:table-cell>
  502. <fo:block font-size="8pt" text-align="center">Cena za m.j.</fo:block>
  503. </fo:table-cell>
  504. <fo:table-cell>
  505. <fo:block font-size="8pt" text-align="center">DPH %</fo:block>
  506. </fo:table-cell>
  507. <fo:table-cell>
  508. <fo:block font-size="8pt" text-align="center">bez DPH</fo:block>
  509. </fo:table-cell>
  510. <fo:table-cell >
  511. <fo:block font-size="8pt" text-align="center">DPH</fo:block>
  512. </fo:table-cell>
  513. <fo:table-cell>
  514. <fo:block font-size="8pt" text-align="right">s DPH</fo:block>
  515. </fo:table-cell>
  516. </fo:table-row>
  517. <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
  518. <fo:table-row>
  519. <fo:table-cell>
  520. <fo:block font-size="8pt"><xsl:value-of select="id"/></fo:block>
  521. </fo:table-cell>
  522. <fo:table-cell>
  523. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="note"/></fo:block>
  524. </fo:table-cell>
  525. <fo:table-cell>
  526. <fo:block font-size="8pt" text-align="center">...</fo:block>
  527. </fo:table-cell>
  528. <fo:table-cell>
  529. <fo:block font-size="8pt" text-align="center">...</fo:block>
  530. </fo:table-cell>
  531. <fo:table-cell>
  532. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent"/></fo:block>
  533. </fo:table-cell>
  534. <fo:table-cell>
  535. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="priceOfOne"/></fo:block>
  536. </fo:table-cell>
  537. <fo:table-cell >
  538. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent * priceOfOne div 100"/></fo:block>
  539. </fo:table-cell>
  540. <fo:table-cell>
  541. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dphPercent * priceOfOne div 100 + priceOfOne"/></fo:block>
  542. </fo:table-cell>
  543. </fo:table-row>
  544. </xsl:for-each>
  545. </fo:table-body>
  546. </fo:table>
  547.  
  548. <fo:table table-layout="fixed" width="100%" font-size="10pt" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="solid" text-align="center" display-align="center" space-after="5mm">
  549. <fo:table-column column-width="proportional-column-width(20)"/>
  550. <fo:table-column column-width="proportional-column-width(30)"/>
  551. <fo:table-column column-width="proportional-column-width(25)"/>
  552.  
  553. <fo:table-body font-size="95%">
  554.  
  555. <fo:table-row height="8mm">
  556. <fo:table-cell border-style="solid">
  557. <fo:block>Full Name</fo:block>
  558. </fo:table-cell>
  559. <fo:table-cell border-style="solid">
  560. <fo:block>Postal Code</fo:block>
  561. </fo:table-cell>
  562. <fo:table-cell border-style="solid">
  563. <fo:block>National ID</fo:block>
  564. </fo:table-cell>
  565.  
  566. </fo:table-row>
  567. <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
  568. <fo:table-row>
  569. <fo:table-cell>
  570. <fo:block>
  571. ???<xsl:value-of select="id"/>
  572. </fo:block>
  573. </fo:table-cell>
  574. <fo:table-cell>
  575. <fo:block>
  576. ???<xsl:value-of select="note"/>
  577. </fo:block>
  578. </fo:table-cell>
  579. <fo:table-cell>
  580. <fo:block>
  581. ???<xsl:value-of select="shippingName"/>
  582. </fo:block>
  583. </fo:table-cell>
  584.  
  585.  
  586. </fo:table-row>
  587. </xsl:for-each>
  588. </fo:table-body>
  589. </fo:table>
  590. <fo:block id="end-of-document">
  591.  
  592. </fo:block>
  593. </fo:flow>
  594. </fo:page-sequence>
  595. </fo:root>
  596. </xsl:template>
  597. </xsl:stylesheet>' WHERE id = 1;
  598.  
  599. INSERT INTO public.templates_for_pdf (id,uuid,version,name,typeOfTemplate,validFrom,validTo) VALUES (2, '3ec8ad6c-1c9f-4d16-90f5-ec0284819797', 0, 'dodaci list', 'dvnote', '2015/09/29', '2029/10/29');
  600.  
  601. UPDATE public.templates_for_pdf SET template = '<?xml version="1.0" encoding="UTF-8"?>
  602. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" version="1.0">
  603. <xsl:output encoding="UTF-8" indent="yes" method="xml" standalone="no" omit-xml-declaration="no"/>
  604. <xsl:template match="sk.elsy.allquite.app.model.DeliveryNote">
  605. <fo:root language="EN" font-family="Arial">
  606. <fo:layout-master-set>
  607. <fo:simple-page-master master-name="A4-portrail" page-height="297mm" page-width="210mm" margin-top="5mm" margin-bottom="5mm" margin-left="20mm" margin-right="15mm">
  608. <fo:region-body margin-top="25mm" margin-bottom="20mm"/>
  609. <fo:region-before region-name="xsl-region-before" extent="25mm" display-align="before" precedence="true"/>
  610. </fo:simple-page-master>
  611. </fo:layout-master-set>
  612. <fo:page-sequence master-reference="A4-portrail">
  613.  
  614. <fo:flow flow-name="xsl-region-body" border-collapse="collapse" reference-orientation="0">
  615.  
  616.  
  617. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="2mm">
  618. <fo:table-column column-width="35%"/>
  619. <fo:table-column column-width="30%"/>
  620. <fo:table-column column-width="35%"/>
  621.  
  622. <fo:table-body font-size="95%">
  623. <fo:table-row height="10mm">
  624.  
  625. <fo:table-cell >
  626. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
  627. <fo:table-column column-width="100%"/>
  628. <fo:table-body font-size="95%">
  629. <fo:table-row>
  630. <fo:table-cell >
  631. <fo:block><fo:block font-size="12pt" font-weight="bold">Delivery Note</fo:block></fo:block>
  632. </fo:table-cell>
  633. </fo:table-row>
  634. <fo:table-row>
  635.  
  636. <fo:table-cell>
  637. <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/street"/></fo:block></fo:block>
  638. </fo:table-cell>
  639. </fo:table-row>
  640. <fo:table-row>
  641. <fo:table-cell>
  642. <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/zipCode"/> </fo:block></fo:block>
  643. </fo:table-cell>
  644. </fo:table-row>
  645. <fo:table-row>
  646. <fo:table-cell>
  647. <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/country"/> </fo:block></fo:block>
  648. </fo:table-cell>
  649. </fo:table-row>
  650. </fo:table-body>
  651. </fo:table>
  652. </fo:table-cell>
  653.  
  654. <fo:table-cell>
  655. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm" text-align="center">
  656. <fo:table-column column-width="100%"/>
  657. <fo:table-body font-size="95%">
  658. <fo:table-row>
  659. <fo:table-cell >
  660. <fo:block><fo:block >&#x2028;&#x2028;&#x2028;</fo:block></fo:block>
  661. </fo:table-cell>
  662. </fo:table-row>
  663. <fo:table-row>
  664. <fo:table-cell>
  665. <fo:block><fo:block font-size="10pt">ICO: <xsl:value-of select="trader/ico"/></fo:block></fo:block>
  666. </fo:table-cell>
  667. </fo:table-row>
  668. <fo:table-row>
  669. <fo:table-cell>
  670. <fo:block><fo:block font-size="10pt">DIC: <xsl:value-of select="trader/dic"/></fo:block></fo:block>
  671. </fo:table-cell>
  672. </fo:table-row>
  673. <fo:table-row>
  674. <fo:table-cell>
  675. <fo:block><fo:block font-size="10pt">IC DPH:!!! SK<xsl:value-of select="trader/ico"/></fo:block></fo:block>
  676. </fo:table-cell>
  677. </fo:table-row>
  678. </fo:table-body>
  679. </fo:table>
  680. </fo:table-cell>
  681.  
  682. <fo:table-cell>
  683. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
  684. <fo:table-column column-width="100%"/>
  685. <fo:table-body font-size="95%">
  686. <fo:table-row>
  687. <fo:table-cell >
  688. <fo:block><fo:block font-size="7pt">mobil: ???</fo:block></fo:block>
  689. </fo:table-cell>
  690. </fo:table-row>
  691. <fo:table-row>
  692. <fo:table-cell>
  693. <fo:block><fo:block font-size="7pt">tel: ???</fo:block></fo:block>
  694. </fo:table-cell>
  695. </fo:table-row>
  696. <fo:table-row>
  697. <fo:table-cell>
  698. <fo:block><fo:block font-size="7pt">fax: ???</fo:block></fo:block>
  699. </fo:table-cell>
  700. </fo:table-row>
  701. <fo:table-row>
  702. <fo:table-cell>
  703. <fo:block><fo:block font-size="7pt">e-mail: <xsl:value-of select="trader/mailAddress"/></fo:block></fo:block>
  704. </fo:table-cell>
  705. </fo:table-row>
  706. <fo:table-row>
  707. <fo:table-cell>
  708. <fo:block><fo:block font-size="7pt">www: ???</fo:block></fo:block>
  709. </fo:table-cell>
  710. </fo:table-row>
  711. <fo:table-row>
  712. <fo:table-cell>
  713. <fo:block><fo:block font-size="7pt">Spolocnost zapisana v OR ...</fo:block></fo:block>
  714. </fo:table-cell>
  715. </fo:table-row>
  716. </fo:table-body>
  717. </fo:table>
  718. </fo:table-cell>
  719.  
  720. </fo:table-row>
  721. </fo:table-body>
  722. </fo:table>
  723.  
  724.  
  725. <fo:table table-layout="fixed" width="100%" font-size="10pt" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="none" border-left-style="none" border-right-style="none" display-align="center" space-after="5mm">
  726. <fo:table-column column-width="70%"/>
  727. <fo:table-column column-width="30%"/>
  728. <fo:table-body font-size="95%">
  729. <fo:table-row height="10mm">
  730. <fo:table-cell >
  731. <fo:block><fo:block font-size="16pt" font-weight="bold">Faktura <xsl:value-of select="id"/></fo:block></fo:block>
  732. </fo:table-cell>
  733. <fo:table-cell>
  734. <fo:block font-size="18pt" font-weight="bold" text-align="center" border-style="solid" border-top-style="none" line-height="10mm">Cislo fakt.: <xsl:value-of select="id"/></fo:block>
  735. </fo:table-cell>
  736. </fo:table-row>
  737. </fo:table-body>
  738. </fo:table>
  739.  
  740.  
  741. <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
  742. <fo:table-column column-width="50%"/>
  743. <fo:table-column column-width="50%"/>
  744. <fo:table-body font-size="95%">
  745. <fo:table-row>
  746.  
  747. <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-left-style="none">
  748. <fo:table table-layout="fixed" width="100%" display-align="center">
  749. <fo:table-column column-width="50%"/>
  750. <fo:table-column column-width="50%"/>
  751. <fo:table-body font-size="95%">
  752. <fo:table-row>
  753. <fo:table-cell >
  754. <fo:block font-size="7pt">&#x2028;</fo:block>
  755. </fo:table-cell>
  756. </fo:table-row>
  757. <fo:table-row>
  758. <fo:table-cell>
  759. <fo:block font-size="11pt" font-weight="bold" line-height="15mm">&#x2028;</fo:block>
  760. </fo:table-cell>
  761. </fo:table-row>
  762. <fo:table-row>
  763. <fo:table-cell>
  764. <fo:block font-size="10pt" font-weight="bold">&#x2028;</fo:block>
  765. </fo:table-cell>
  766. </fo:table-row>
  767. <fo:table-row>
  768. <fo:table-cell>
  769. <fo:block font-size="10pt">Platba: <xsl:value-of select="paymentMethod"/></fo:block>
  770. </fo:table-cell>
  771. </fo:table-row>
  772. <fo:table-row>
  773. <fo:table-cell>
  774. <fo:block font-size="10pt">Doprava: <xsl:value-of select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document/deliveryType"/></fo:block>
  775. </fo:table-cell>
  776. </fo:table-row>
  777. <fo:table-row>
  778. <fo:table-cell >
  779. <fo:block font-size="8pt">&#x2028;</fo:block>
  780. </fo:table-cell>
  781. </fo:table-row>
  782. </fo:table-body>
  783. </fo:table>
  784. <fo:table table-layout="fixed" width="100%" display-align="center">
  785. <fo:table-column column-width="49%"/>
  786. <fo:table-column column-width="2%"/>
  787. <fo:table-column column-width="49%"/>
  788. <fo:table-body font-size="95%">
  789. <fo:table-row>
  790. <fo:table-cell >
  791. <fo:table table-layout="fixed" width="100%" display-align="center" >
  792. <fo:table-column column-width="50%"/>
  793. <fo:table-column column-width="50%"/>
  794. <fo:table-body font-size="95%">
  795. <fo:table-row border-bottom="0.35mm solid black">
  796. <fo:table-cell>
  797. <fo:block font-size="10pt">Datum</fo:block>
  798. </fo:table-cell>
  799. </fo:table-row>
  800. <fo:table-row>
  801. <fo:table-cell >
  802. <fo:block font-size="8pt">vystavenia:</fo:block>
  803. </fo:table-cell>
  804. <fo:table-cell >
  805. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfIssue"/></fo:block>
  806. </fo:table-cell>
  807. </fo:table-row>
  808. <fo:table-row>
  809. <fo:table-cell>
  810. <fo:block font-size="8pt">splatnosti:</fo:block>
  811. </fo:table-cell>
  812. <fo:table-cell >
  813. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dueDate"/></fo:block>
  814. </fo:table-cell>
  815. </fo:table-row>
  816. <fo:table-row>
  817. <fo:table-cell >
  818. <fo:block font-size="8pt">dodania</fo:block>
  819. </fo:table-cell>
  820. <fo:table-cell >
  821. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfVatEntry"/></fo:block>
  822. </fo:table-cell>
  823. </fo:table-row>
  824. <fo:table-row>
  825. <fo:table-cell>
  826. <fo:block font-size="8pt" font-weight="bold">Bankovy ucet:</fo:block>
  827. </fo:table-cell>
  828. </fo:table-row>
  829. </fo:table-body>
  830. </fo:table>
  831. </fo:table-cell>
  832. <fo:table-cell >
  833. <fo:block></fo:block>
  834. </fo:table-cell>
  835. <fo:table-cell>
  836. <fo:table table-layout="fixed" width="100%" display-align="center">
  837. <fo:table-column column-width="50%"/>
  838. <fo:table-column column-width="50%"/>
  839. <fo:table-body font-size="95%">
  840. <fo:table-row border-bottom="0.35mm solid black">
  841. <fo:table-cell>
  842. <fo:block font-size="10pt">Symbol</fo:block>
  843. </fo:table-cell>
  844. </fo:table-row>
  845. <fo:table-row>
  846. <fo:table-cell>
  847. <fo:block font-size="8pt">konstantny</fo:block>
  848. </fo:table-cell>
  849. <fo:table-cell>
  850. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="constantSymbol"/></fo:block>
  851. </fo:table-cell>
  852. </fo:table-row>
  853. <fo:table-row>
  854. <fo:table-cell>
  855. <fo:block font-size="8pt">variabilny</fo:block>
  856. </fo:table-cell>
  857. <fo:table-cell >
  858. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="variableSymbol"/></fo:block>
  859. </fo:table-cell>
  860. </fo:table-row>
  861. <fo:table-row>
  862. <fo:table-cell >
  863. <fo:block font-size="8pt">specificky</fo:block>
  864. </fo:table-cell>
  865. <fo:table-cell >
  866. <fo:block font-size="8pt" text-align="right">???</fo:block>
  867. </fo:table-cell>
  868. </fo:table-row>
  869. <fo:table-row>
  870. <fo:table-cell>
  871. <fo:block></fo:block>
  872. </fo:table-cell>
  873. <fo:table-cell>
  874. <fo:block font-size="8pt" font-weight="bold" text-align="right">TATR</fo:block>
  875. </fo:table-cell>
  876. </fo:table-row>
  877. </fo:table-body>
  878. </fo:table>
  879. </fo:table-cell>
  880. </fo:table-row>
  881. </fo:table-body>
  882. </fo:table>
  883. <fo:table table-layout="fixed" width="100%" display-align="center" border-style="solid" border-width="0.35mm">
  884. <fo:table-column column-width="10%"/>
  885. <fo:table-column column-width="45%"/>
  886. <fo:table-column column-width="45%"/>
  887. <fo:table-body font-size="95%">
  888. <fo:table-row>
  889. <fo:table-cell>
  890. <fo:block font-size="8pt">cislo:</fo:block>
  891. </fo:table-cell>
  892. <fo:table-cell>
  893. <fo:block font-size="8pt"><xsl:value-of select="bankConnection/accountNum"/></fo:block>
  894. </fo:table-cell>
  895. <fo:table-cell>
  896. <fo:block font-size="8pt"></fo:block>
  897. </fo:table-cell>
  898. </fo:table-row>
  899. <fo:table-row>
  900. <fo:table-cell>
  901. <fo:block font-size="8pt">IBAN:</fo:block>
  902. </fo:table-cell>
  903. <fo:table-cell>
  904. <fo:block font-size="8pt"><xsl:value-of select="bankConnection/iban"/></fo:block>
  905. </fo:table-cell>
  906. <fo:table-cell>
  907. <fo:block font-size="8pt" text-align="right">SWIFT: <xsl:value-of select="bankConnection/swift"/></fo:block>
  908. </fo:table-cell>
  909. </fo:table-row>
  910. </fo:table-body>
  911. </fo:table>
  912. </fo:table-cell>
  913.  
  914. <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-right-style="none">
  915. <fo:table table-layout="fixed" width="100%" display-align="center" space-after="5mm">
  916. <fo:table-column column-width="100%"/>
  917. <fo:table-body font-size="95%">
  918. <fo:table-row>
  919. <fo:table-cell >
  920. <fo:block font-size="8pt">Objednavka:</fo:block>
  921. </fo:table-cell>
  922. </fo:table-row>
  923. <fo:table-row>
  924. <fo:table-cell >
  925. <fo:block font-size="8pt">Povodna faktura(pri dobropise): </fo:block>
  926. </fo:table-cell>
  927. </fo:table-row>
  928. <fo:table-row>
  929. <fo:table-cell border-style="solid" border-width="0.35mm" border-top-style="none" border-left-style="none" border-right-style="none">
  930. <fo:block font-size="9pt">&#x2028;Odberatel: </fo:block>
  931. </fo:table-cell>
  932. </fo:table-row>
  933. <fo:table-row>
  934. <fo:table-cell>
  935. <fo:block font-size="12pt" font-weight="bold" line-height="15mm"><xsl:value-of select="customer/name"/></fo:block>
  936. </fo:table-cell>
  937. </fo:table-row>
  938. <fo:table-row>
  939. <fo:table-cell>
  940. <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="customer/address/street"/></fo:block>
  941. </fo:table-cell>
  942. </fo:table-row>
  943. <fo:table-row>
  944. <fo:table-cell>
  945. <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="customer/address/zipCode"/></fo:block>
  946. </fo:table-cell>
  947. </fo:table-row>
  948. <fo:table-row>
  949. <fo:table-cell>
  950. <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="customer/address/country"/></fo:block>
  951. </fo:table-cell>
  952. </fo:table-row>
  953. </fo:table-body>
  954. </fo:table>
  955. <fo:table table-layout="fixed" width="100%" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="none" border-left-style="none" border-right-style="none" display-align="center" space-after="5mm">
  956. <fo:table-column column-width="50%"/>
  957. <fo:table-column column-width="50%"/>
  958. <fo:table-body font-size="95%">
  959. <fo:table-row>
  960. <fo:table-cell >
  961. <fo:block><fo:block font-size="10pt" font-family="Arial" >Konecna prijemca</fo:block></fo:block>
  962. </fo:table-cell>
  963. <fo:table-cell>
  964. <fo:block font-size="10pt" text-align="center">ICO: <xsl:value-of select="firm/ico"/></fo:block>
  965. </fo:table-cell>
  966. </fo:table-row>
  967. <fo:table-row>
  968. <fo:table-cell >
  969. <fo:block font-size="10pt" >&#x2028;</fo:block>
  970. </fo:table-cell>
  971. <fo:table-cell>
  972. <fo:block font-size="10pt" text-align="center">DIC: <xsl:value-of select="firm/dic"/></fo:block>
  973. </fo:table-cell>
  974. </fo:table-row>
  975. <fo:table-row>
  976. <fo:table-cell >
  977. <fo:block font-size="10pt" >&#x2028;</fo:block>
  978. </fo:table-cell>
  979. <fo:table-cell>
  980. <fo:block font-size="10pt" text-align="center">IC DPH:!!! SK<xsl:value-of select="firm/ico"/></fo:block>
  981. </fo:table-cell>
  982. </fo:table-row>
  983. <fo:table-row>
  984. <fo:table-cell >
  985. <fo:block font-size="10pt" >???</fo:block>
  986. </fo:table-cell>
  987. </fo:table-row>
  988. <fo:table-row>
  989. <fo:table-cell >
  990. <fo:block font-size="10pt" >???</fo:block>
  991. </fo:table-cell>
  992. </fo:table-row>
  993. <fo:table-row>
  994. <fo:table-cell >
  995. <fo:block font-size="10pt" >???</fo:block>
  996. </fo:table-cell>
  997. </fo:table-row>
  998. <fo:table-row>
  999. <fo:table-cell >
  1000. <fo:block font-size="10pt" >???</fo:block>
  1001. </fo:table-cell>
  1002. </fo:table-row>
  1003. </fo:table-body>
  1004. </fo:table>
  1005. </fo:table-cell>
  1006.  
  1007. </fo:table-row>
  1008. </fo:table-body>
  1009. </fo:table>
  1010.  
  1011. <fo:table table-layout="fixed" width="100%"
  1012. display-align="center" space-after="5mm">
  1013. <fo:table-column column-width="21%" />
  1014. <fo:table-column column-width="16%" />
  1015. <fo:table-column column-width="11%" />
  1016. <fo:table-column column-width="11%" />
  1017. <fo:table-column column-width="8%" />
  1018. <fo:table-column column-width="11%" />
  1019. <fo:table-column column-width="11%" />
  1020. <fo:table-column column-width="11%" />
  1021. <fo:table-body font-size="95%">
  1022. <fo:table-row border-bottom="0.35mm solid black">
  1023. <fo:table-cell>
  1024. <fo:block font-size="8pt">Oznacenie dodavky</fo:block>
  1025. </fo:table-cell>
  1026. <fo:table-cell>
  1027. <fo:block font-size="8pt" text-align="center">Katalog. Oznacenie</fo:block>
  1028. </fo:table-cell>
  1029. <fo:table-cell>
  1030. <fo:block font-size="8pt" text-align="center">Pocet m.j. m.j.</fo:block>
  1031. </fo:table-cell>
  1032. <fo:table-cell>
  1033. <fo:block font-size="8pt" text-align="center">Cena za m.j.</fo:block>
  1034. </fo:table-cell>
  1035. <fo:table-cell>
  1036. <fo:block font-size="8pt" text-align="center">DPH %</fo:block>
  1037. </fo:table-cell>
  1038. <fo:table-cell>
  1039. <fo:block font-size="8pt" text-align="center">bez DPH</fo:block>
  1040. </fo:table-cell>
  1041. <fo:table-cell >
  1042. <fo:block font-size="8pt" text-align="center">DPH</fo:block>
  1043. </fo:table-cell>
  1044. <fo:table-cell>
  1045. <fo:block font-size="8pt" text-align="right">s DPH</fo:block>
  1046. </fo:table-cell>
  1047. </fo:table-row>
  1048. <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
  1049. <fo:table-row>
  1050. <fo:table-cell>
  1051. <fo:block font-size="8pt"><xsl:value-of select="id"/></fo:block>
  1052. </fo:table-cell>
  1053. <fo:table-cell>
  1054. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="note"/></fo:block>
  1055. </fo:table-cell>
  1056. <fo:table-cell>
  1057. <fo:block font-size="8pt" text-align="center">...</fo:block>
  1058. </fo:table-cell>
  1059. <fo:table-cell>
  1060. <fo:block font-size="8pt" text-align="center">...</fo:block>
  1061. </fo:table-cell>
  1062. <fo:table-cell>
  1063. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent"/></fo:block>
  1064. </fo:table-cell>
  1065. <fo:table-cell>
  1066. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="priceOfOne"/></fo:block>
  1067. </fo:table-cell>
  1068. <fo:table-cell >
  1069. <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent * priceOfOne div 100"/></fo:block>
  1070. </fo:table-cell>
  1071. <fo:table-cell>
  1072. <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dphPercent * priceOfOne div 100 + priceOfOne"/></fo:block>
  1073. </fo:table-cell>
  1074. </fo:table-row>
  1075. </xsl:for-each>
  1076. </fo:table-body>
  1077. </fo:table>
  1078.  
  1079. <fo:table table-layout="fixed" width="100%" font-size="10pt" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="solid" text-align="center" display-align="center" space-after="5mm">
  1080. <fo:table-column column-width="proportional-column-width(20)"/>
  1081. <fo:table-column column-width="proportional-column-width(30)"/>
  1082. <fo:table-column column-width="proportional-column-width(25)"/>
  1083.  
  1084. <fo:table-body font-size="95%">
  1085.  
  1086. <fo:table-row height="8mm">
  1087. <fo:table-cell border-style="solid">
  1088. <fo:block>Full Name</fo:block>
  1089. </fo:table-cell>
  1090. <fo:table-cell border-style="solid">
  1091. <fo:block>Postal Code</fo:block>
  1092. </fo:table-cell>
  1093. <fo:table-cell border-style="solid">
  1094. <fo:block>National ID</fo:block>
  1095. </fo:table-cell>
  1096.  
  1097. </fo:table-row>
  1098. <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
  1099. <fo:table-row>
  1100. <fo:table-cell>
  1101. <fo:block>
  1102. <xsl:value-of select="id"/>
  1103. </fo:block>
  1104. </fo:table-cell>
  1105.  
  1106.  
  1107. </fo:table-row>
  1108. </xsl:for-each>
  1109. </fo:table-body>
  1110. </fo:table>
  1111. <fo:block id="end-of-document">
  1112.  
  1113. </fo:block>
  1114. </fo:flow>
  1115. </fo:page-sequence>
  1116. </fo:root>
  1117. </xsl:template>
  1118. </xsl:stylesheet>' WHERE id = 2;
  1119.  
  1120. INSERT INTO public.templates_for_pdf (id,uuid,version,name,typeOfTemplate,validFrom,validTo) VALUES (3, '5ec8ad6c-1c9f-4d16-90f5-ec0284819797', 0, 'preddavkova faktura', '', '2015/09/29', '2029/10/29');
  1121. INSERT INTO public.templates_for_pdf (id,uuid,version,name,typeOfTemplate,validFrom,validTo) VALUES (4, '6ec8ad6c-1c9f-4d16-90f5-ec0284819797', 0, 'dobropis', '', '2015/09/29', '2029/10/29');
  1122. INSERT INTO public.templates_for_pdf (id,uuid,version,name,typeOfTemplate,validFrom,validTo) VALUES (5, '7ec8ad6c-1c9f-4d16-90f5-ec0284819797', 0, 'credit note', '', '2015/09/29', '2029/10/29');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!