Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO public.permission (id,uuid,version,description,key,user_id) VALUES (10, '73c8c2d7-914e-42c0-a834-94c778023803', 0, 'uctovnik', 'uct', 1);
- INSERT INTO public.permission (id,uuid,version,description,key,user_id) VALUES (11, '73c8c2d7-914e-42c0-a834-94c778023804', 0, 'skladnik', 'skl', 1);
- INSERT INTO public.permission (id,uuid,version,description,key,user_id) VALUES (12, '73c8c2d7-914e-42c0-a834-94c778023805', 0, 'predavac', 'pre', 1);
- INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (1, '11c8c2d7-914e-42c0-a834-94c778023806', 0, 'Stara Gala 99', '90000 HOLICE', 'Slovakia');
- INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (2, '12c8c2d7-914e-42c0-a834-94c778023806', 0, 'Kukucinska 88', '90111 DUNAJSKA STREDA', 'Slovakia');
- INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (3, '13c8c2d7-914e-42c0-a834-94c778023806', 0, 'Hlavna 77', '90222 BRATISLAVA', 'Slovakia');
- INSERT INTO public.address (id,uuid,version,street,zipcode,country) VALUES (4, '14c8c2d7-914e-42c0-a834-94c778023806', 0, 'Dunajska 66', '90333 GYOR', 'Hungary');
- 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');
- 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');
- 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');
- 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');
- 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);
- 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);
- 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);
- 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);
- UPDATE public.users SET firm_id = 2 WHERE id = 1;
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO public.dividing_dph(id,uuid,version,name,key,validFrom,validTo) VALUES (1,'7f403387-e087-4e9f-880f-af7a60bb2da1',0,'name',null,null,null);
- 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');
- 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);
- 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);
- 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);
- INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (1, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'Delivered', 'DL');
- INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (2, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'Created', 'CR');
- INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (3, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'InProgress', 'IPR');
- INSERT INTO public.offerStatus (id,uuid,version,status, code) VALUES (4, '73c8c2d7-914e-42c0-a834-94c778023806', 0, 'Denied', 'DE');
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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');
- UPDATE public.templates_for_pdf SET template = '<?xml version="1.0" encoding="UTF-8"?>
- <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" version="1.0">
- <xsl:output encoding="UTF-8" indent="yes" method="xml" standalone="no" omit-xml-declaration="no"/>
- <xsl:template match="sk.elsy.allquite.app.model.Invoice">
- <fo:root language="EN" font-family="Arial">
- <fo:layout-master-set>
- <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">
- <fo:region-body margin-top="25mm" margin-bottom="20mm"/>
- <fo:region-before region-name="xsl-region-before" extent="25mm" display-align="before" precedence="true"/>
- </fo:simple-page-master>
- </fo:layout-master-set>
- <fo:page-sequence master-reference="A4-portrail">
- <fo:flow flow-name="xsl-region-body" border-collapse="collapse" reference-orientation="0">
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="2mm">
- <fo:table-column column-width="35%"/>
- <fo:table-column column-width="30%"/>
- <fo:table-column column-width="35%"/>
- <fo:table-body font-size="95%">
- <fo:table-row height="10mm">
- <fo:table-cell >
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block font-size="12pt" font-weight="bold">Invoice template</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/street"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/zipCode"/> </fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/firm/address/country"/> </fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm" text-align="center">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block >


</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt">ICO: <xsl:value-of select="trader/firm/ico"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt">DIC: <xsl:value-of select="trader/firm/dic"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt">IC DPH:<xsl:value-of select="trader/firm/icDph"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block font-size="7pt">mobil: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">tel: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">fax: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">e-mail: <xsl:value-of select="trader/mailAddress"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">www: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">Spolocnost zapisana v OR ...</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <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">
- <fo:table-column column-width="70%"/>
- <fo:table-column column-width="30%"/>
- <fo:table-body font-size="95%">
- <fo:table-row height="10mm">
- <fo:table-cell >
- <fo:block><fo:block font-size="16pt" font-weight="bold">Faktura <xsl:value-of select="id"/></fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <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>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-left-style="none">
- <fo:table table-layout="fixed" width="100%" display-align="center">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="7pt">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="11pt" font-weight="bold" line-height="15mm">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt">Platba: <xsl:value-of select="paymentMethod"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt">Doprava : </fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" display-align="center">
- <fo:table-column column-width="49%"/>
- <fo:table-column column-width="2%"/>
- <fo:table-column column-width="49%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:table table-layout="fixed" width="100%" display-align="center" >
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row border-bottom="0.35mm solid black">
- <fo:table-cell>
- <fo:block font-size="10pt">Datum</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">vystavenia:</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfIssue"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">splatnosti:</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dueDate"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">dodania</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfVatEntry"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt" font-weight="bold">Bankovy ucet:</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:table table-layout="fixed" width="100%" display-align="center">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row border-bottom="0.35mm solid black">
- <fo:table-cell>
- <fo:block font-size="10pt">Symbol</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">konstantny</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="constantSymbol"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">variabilny</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="variableSymbol"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">specificky</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right">???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" font-weight="bold" text-align="right">TATR</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" display-align="center" border-style="solid" border-width="0.35mm">
- <fo:table-column column-width="10%"/>
- <fo:table-column column-width="45%"/>
- <fo:table-column column-width="45%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">cislo:</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt"><xsl:value-of select="bankConnection/accountNum"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt"></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">IBAN:</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt"><xsl:value-of select="bankConnection/iban"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right">SWIFT: <xsl:value-of select="bankConnection/swift"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-right-style="none">
- <fo:table table-layout="fixed" width="100%" display-align="center" space-after="5mm">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">Objednavka:</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">Povodna faktura(pri dobropise): </fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell border-style="solid" border-width="0.35mm" border-top-style="none" border-left-style="none" border-right-style="none">
- <fo:block font-size="9pt">
Odberatel: </fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="12pt" font-weight="bold" line-height="15mm">Customer ??? <xsl:value-of select="firm/name"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/street"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/zipCode"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/country"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <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">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block font-size="10pt" font-family="Arial" >Konecna prijemca</fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="10pt" text-align="center">ICO: <xsl:value-of select="firm/ico"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >
</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="10pt" text-align="center">DIC: <xsl:value-of select="firm/dic"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >
</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="10pt" text-align="center">IC DPH:<xsl:value-of select="firm/icDph"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%"
- display-align="center" space-after="5mm">
- <fo:table-column column-width="21%" />
- <fo:table-column column-width="16%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="8%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="11%" />
- <fo:table-body font-size="95%">
- <fo:table-row border-bottom="0.35mm solid black">
- <fo:table-cell>
- <fo:block font-size="8pt">Oznacenie dodavky</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">Katalog. Oznacenie</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">Pocet m.j. m.j.</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">Cena za m.j.</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">DPH %</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">bez DPH</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="center">DPH</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right">s DPH</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt"><xsl:value-of select="id"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="note"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">...</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">...</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="priceOfOne"/></fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent * priceOfOne div 100"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dphPercent * priceOfOne div 100 + priceOfOne"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </xsl:for-each>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="none" text-align="center" display-align="center" space-after="5mm">
- <fo:table-column column-width="proportional-column-width(20)"/>
- <fo:table-column column-width="proportional-column-width(30)"/>
- <fo:table-column column-width="proportional-column-width(25)"/>
- <fo:table-body font-size="95%">
- <fo:table-row height="8mm">
- <fo:table-cell border-style="solid">
- <fo:block>Full Name</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block>Postal Code</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block>National ID</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
- <fo:table-row>
- <fo:table-cell>
- <fo:block>
- ???<xsl:value-of select="id"/>
- </fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block>
- ???<xsl:value-of select="note"/>
- </fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block>
- ???<xsl:value-of select="shippingName"/>
- </fo:block>
- </fo:table-cell>
- </fo:table-row>
- </xsl:for-each>
- </fo:table-body>
- </fo:table>
- <fo:block id="end-of-document">
- </fo:block>
- </fo:flow>
- </fo:page-sequence>
- </fo:root>
- </xsl:template>
- </xsl:stylesheet>' WHERE id = 1;
- 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');
- UPDATE public.templates_for_pdf SET template = '<?xml version="1.0" encoding="UTF-8"?>
- <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" version="1.0">
- <xsl:output encoding="UTF-8" indent="yes" method="xml" standalone="no" omit-xml-declaration="no"/>
- <xsl:template match="sk.elsy.allquite.app.model.DeliveryNote">
- <fo:root language="EN" font-family="Arial">
- <fo:layout-master-set>
- <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">
- <fo:region-body margin-top="25mm" margin-bottom="20mm"/>
- <fo:region-before region-name="xsl-region-before" extent="25mm" display-align="before" precedence="true"/>
- </fo:simple-page-master>
- </fo:layout-master-set>
- <fo:page-sequence master-reference="A4-portrail">
- <fo:flow flow-name="xsl-region-body" border-collapse="collapse" reference-orientation="0">
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="2mm">
- <fo:table-column column-width="35%"/>
- <fo:table-column column-width="30%"/>
- <fo:table-column column-width="35%"/>
- <fo:table-body font-size="95%">
- <fo:table-row height="10mm">
- <fo:table-cell >
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block font-size="12pt" font-weight="bold">Delivery Note</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/name"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/address_id/zipCode"/> </fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt"> <xsl:value-of select="trader/address/country"/> </fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm" text-align="center">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block >


</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt">ICO: <xsl:value-of select="trader/ico"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt">DIC: <xsl:value-of select="trader/dic"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="10pt">IC DPH: SK<xsl:value-of select="trader/dic"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block font-size="7pt">mobil: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">tel: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">fax: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">e-mail: <xsl:value-of select="trader/mailAddress"/></fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">www: ???</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block><fo:block font-size="7pt">Spolocnost zapisana v OR ...</fo:block></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <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">
- <fo:table-column column-width="70%"/>
- <fo:table-column column-width="30%"/>
- <fo:table-body font-size="95%">
- <fo:table-row height="10mm">
- <fo:table-cell >
- <fo:block><fo:block font-size="16pt" font-weight="bold">Faktura <xsl:value-of select="id"/></fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <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>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" display-align="center" space-after="5mm">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-left-style="none">
- <fo:table table-layout="fixed" width="100%" display-align="center">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="7pt">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="11pt" font-weight="bold" line-height="15mm">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt">Platba: <xsl:value-of select="paymentMethod"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt">Doprava : </fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">
</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" display-align="center">
- <fo:table-column column-width="49%"/>
- <fo:table-column column-width="2%"/>
- <fo:table-column column-width="49%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:table table-layout="fixed" width="100%" display-align="center" >
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row border-bottom="0.35mm solid black">
- <fo:table-cell>
- <fo:block font-size="10pt">Datum</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">vystavenia:</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfIssue"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">splatnosti:</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dueDate"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">dodania</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dateOfVatEntry"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt" font-weight="bold">Bankovy ucet:</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:table table-layout="fixed" width="100%" display-align="center">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row border-bottom="0.35mm solid black">
- <fo:table-cell>
- <fo:block font-size="10pt">Symbol</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">konstantny</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="constantSymbol"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">variabilny</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="variableSymbol"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">specificky</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="right">???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" font-weight="bold" text-align="right">TATR</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" display-align="center" border-style="solid" border-width="0.35mm">
- <fo:table-column column-width="10%"/>
- <fo:table-column column-width="45%"/>
- <fo:table-column column-width="45%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">cislo:</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt"><xsl:value-of select="bankConnection/accountNum"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt"></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt">IBAN:</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt"><xsl:value-of select="bankConnection/iban"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right">SWIFT: <xsl:value-of select="bankConnection/swift"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- <fo:table-cell border-color="white" border-width="4mm" border-style="solid" border-right-style="none">
- <fo:table table-layout="fixed" width="100%" display-align="center" space-after="5mm">
- <fo:table-column column-width="100%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">Objednavka:</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="8pt">Povodna faktura(pri dobropise): </fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell border-style="solid" border-width="0.35mm" border-top-style="none" border-left-style="none" border-right-style="none">
- <fo:block font-size="9pt">
Odberatel: </fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="12pt" font-weight="bold" line-height="15mm"><xsl:value-of select="firm/name"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/street"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/zipCode"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="10pt" font-weight="bold"><xsl:value-of select="firm/address/country"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <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">
- <fo:table-column column-width="50%"/>
- <fo:table-column column-width="50%"/>
- <fo:table-body font-size="95%">
- <fo:table-row>
- <fo:table-cell >
- <fo:block><fo:block font-size="10pt" font-family="Arial" >Konecna prijemca</fo:block></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="10pt" text-align="center">ICO: <xsl:value-of select="firm/ico"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >
</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="10pt" text-align="center">DIC: <xsl:value-of select="firm/dic"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >
</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="10pt" text-align="center">IC DPH:!!! SK<xsl:value-of select="firm/ico"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <fo:table-row>
- <fo:table-cell >
- <fo:block font-size="10pt" >???</fo:block>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- </fo:table-cell>
- </fo:table-row>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%"
- display-align="center" space-after="5mm">
- <fo:table-column column-width="21%" />
- <fo:table-column column-width="16%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="8%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="11%" />
- <fo:table-column column-width="11%" />
- <fo:table-body font-size="95%">
- <fo:table-row border-bottom="0.35mm solid black">
- <fo:table-cell>
- <fo:block font-size="8pt">Oznacenie dodavky</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">Katalog. Oznacenie</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">Pocet m.j. m.j.</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">Cena za m.j.</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">DPH %</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">bez DPH</fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="center">DPH</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right">s DPH</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
- <fo:table-row>
- <fo:table-cell>
- <fo:block font-size="8pt"><xsl:value-of select="id"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="note"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">...</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center">...</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="priceOfOne"/></fo:block>
- </fo:table-cell>
- <fo:table-cell >
- <fo:block font-size="8pt" text-align="center"><xsl:value-of select="dphPercent * priceOfOne div 100"/></fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block font-size="8pt" text-align="right"><xsl:value-of select="dphPercent * priceOfOne div 100 + priceOfOne"/></fo:block>
- </fo:table-cell>
- </fo:table-row>
- </xsl:for-each>
- </fo:table-body>
- </fo:table>
- <fo:table table-layout="fixed" width="100%" font-size="10pt" border-color="black" border-width="0.35mm" border-style="solid" border-bottom-style="none" text-align="center" display-align="center" space-after="5mm">
- <fo:table-column column-width="proportional-column-width(20)"/>
- <fo:table-column column-width="proportional-column-width(30)"/>
- <fo:table-column column-width="proportional-column-width(25)"/>
- <fo:table-body font-size="95%">
- <fo:table-row height="8mm">
- <fo:table-cell border-style="solid">
- <fo:block>Full Name</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block>Postal Code</fo:block>
- </fo:table-cell>
- <fo:table-cell>
- <fo:block>National ID</fo:block>
- </fo:table-cell>
- </fo:table-row>
- <xsl:for-each select="storageItems__document/sk.elsy.allquite.app.model.StorageItem__Document">
- <fo:table-row>
- <fo:table-cell>
- <fo:block>
- <xsl:value-of select="id"/>
- </fo:block>
- </fo:table-cell>
- </fo:table-row>
- </xsl:for-each>
- </fo:table-body>
- </fo:table>
- <fo:block id="end-of-document">
- </fo:block>
- </fo:flow>
- </fo:page-sequence>
- </fo:root>
- </xsl:template>
- </xsl:stylesheet>' WHERE id = 2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement