From b51329cdfaa6f10cbae2537230b675ffc34e33ce Mon Sep 17 00:00:00 2001
From: =?utf8?q?V=C3=A1s=C3=A1ry=20D=C3=A1niel?= <vasary@elgekko.net>
Date: Fri, 1 Mar 2024 22:39:14 +0100
Subject: [PATCH] Excel export for Partners, view headers style changed

---
 .../src/main/resources/application-dev.yaml   | 13 ++--
 sly-crm-ui/pom.xml                            |  6 ++
 .../user/lis/ui/data/PartnersDataModel.java   | 22 +++++-
 .../lis/ui/data/common/CachedDataModel.java   | 68 +++++++++++++++++--
 .../ui/data/common/IDataHeaderProvider.java   |  7 ++
 .../lis/ui/data/common/IRowDataProvider.java  |  7 ++
 .../properties/ApplicationUIProperties.java   |  1 +
 .../user/lis/ui/view/PartnersViewModel.java   |  5 ++
 .../src/main/resources/web/associates.zul     | 17 ++---
 .../resources/web/editor/project-editor.zul   |  6 +-
 .../resources/web/import-invoices-approve.zul |  7 +-
 .../resources/web/import-invoices-assign.zul  |  7 +-
 .../web/import-invoices-suspended.zul         |  6 +-
 .../main/resources/web/invoice-payment.zul    |  4 +-
 .../src/main/resources/web/invoices.zul       |  9 ++-
 .../src/main/resources/web/partners.zul       | 30 ++++----
 .../src/main/resources/web/projects.zul       |  7 +-
 .../main/resources/web/service-records.zul    | 16 +++--
 .../src/main/resources/web/settings.zul       |  6 +-
 .../resources/web/static/css/webclient.css    |  3 +
 20 files changed, 179 insertions(+), 68 deletions(-)
 create mode 100644 sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IDataHeaderProvider.java
 create mode 100644 sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IRowDataProvider.java

diff --git a/sly-crm-app/src/main/resources/application-dev.yaml b/sly-crm-app/src/main/resources/application-dev.yaml
index 5fc5748..1b0d776 100644
--- a/sly-crm-app/src/main/resources/application-dev.yaml
+++ b/sly-crm-app/src/main/resources/application-dev.yaml
@@ -20,12 +20,12 @@ spring:
       enabled: always
   datasource:
     type: com.zaxxer.hikari.HikariDataSource
-    url: jdbc:db2://localhost:50000/slycrm
+    #    url: jdbc:db2://localhost:50000/slycrm
+    #    username: db2admin
+    #    password: password
+    url: jdbc:db2://db2.in.useribm.hu:50000/slycrm
     username: db2admin
-    password: password
-#    url: jdbc:db2://db2.in.useribm.hu:50000/slycrm
-#    username: db2admin
-#    password: Passw@rd01
+    password: Passw@rd01
 camunda.bpm:
   generic-properties.properties:
     telemetry-reporter-activate: false
@@ -59,7 +59,8 @@ application:
   ui:
     user-name: user
     password: password
-  #    disable-profile-save: true
+    export-temp-path: /temp
+    disable-profile-save: true
   workflow:
     import-invoice:
       input-path: /temp/invoice-import
diff --git a/sly-crm-ui/pom.xml b/sly-crm-ui/pom.xml
index 55f14c1..e2ab68e 100644
--- a/sly-crm-ui/pom.xml
+++ b/sly-crm-ui/pom.xml
@@ -127,5 +127,11 @@
             <artifactId>sly-crm-workflow</artifactId>
             <version>0.0.1-SNAPSHOT</version>
         </dependency>
+        <!-- https://mvnrepository.com/artifact/org.dhatim/fastexcel -->
+        <dependency>
+            <groupId>org.dhatim</groupId>
+            <artifactId>fastexcel</artifactId>
+            <version>0.15.0</version>
+        </dependency>
     </dependencies>
 </project>
\ No newline at end of file
diff --git a/sly-crm-ui/src/main/java/hu/user/lis/ui/data/PartnersDataModel.java b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/PartnersDataModel.java
index 8333d8f..7c7885e 100644
--- a/sly-crm-ui/src/main/java/hu/user/lis/ui/data/PartnersDataModel.java
+++ b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/PartnersDataModel.java
@@ -5,6 +5,8 @@ import hu.user.lis.db.repository.PartnerRepository;
 import hu.user.lis.service.data.EntityDataService;
 import hu.user.lis.service.data.PartnerService;
 import hu.user.lis.ui.data.common.CachedSpringDataModel;
+import hu.user.lis.ui.data.common.IDataHeaderProvider;
+import hu.user.lis.ui.data.common.IRowDataProvider;
 import lombok.extern.log4j.Log4j2;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.config.ConfigurableBeanFactory;
@@ -18,7 +20,7 @@ import java.util.List;
 @Component
 @Log4j2
 @Scope(ConfigurableBeanFactory.SCOPE_PROTOTYPE)
-public class PartnersDataModel extends CachedSpringDataModel<Partner> {
+public class PartnersDataModel extends CachedSpringDataModel<Partner> implements IDataHeaderProvider, IRowDataProvider<Partner> {
     @Autowired
     PartnerRepository partnerRepository;
 
@@ -91,4 +93,22 @@ public class PartnersDataModel extends CachedSpringDataModel<Partner> {
     public void delete(Partner selectedEntity) {
         partnerRepository.delete(selectedEntity);
     }
+
+    public void export() {
+        super.export("partners", this, this);
+    }
+
+    @Override
+    public String[] mapHeaders() {
+        return new String[]{
+                "Név", "Adószám", "Cím", "Aktív"
+        };
+    }
+
+    @Override
+    public String[] mapRowData(Partner data) {
+        return new String[]{
+                data.getName(), data.getVatNr(), data.getAddress(), String.valueOf(data.isActive())
+        };
+    }
 }
diff --git a/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/CachedDataModel.java b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/CachedDataModel.java
index 8d07b12..f0195c6 100644
--- a/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/CachedDataModel.java
+++ b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/CachedDataModel.java
@@ -1,31 +1,53 @@
 package hu.user.lis.ui.data.common;
 
+import hu.user.lis.ui.properties.ApplicationUIProperties;
 import lombok.Setter;
 import lombok.extern.log4j.Log4j2;
+import org.dhatim.fastexcel.Workbook;
+import org.dhatim.fastexcel.Worksheet;
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Component;
 import org.zkoss.bind.BindUtils;
 import org.zkoss.zul.FieldComparator;
+import org.zkoss.zul.Filedownload;
 import org.zkoss.zul.ListModelList;
 import org.zkoss.zul.event.ListDataEvent;
 
+import java.io.OutputStream;
+import java.nio.file.Files;
+import java.nio.file.Path;
+import java.nio.file.Paths;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
 import java.util.Comparator;
 import java.util.HashMap;
 import java.util.List;
 
-@Component
 @Log4j2
+@Component
 public abstract class CachedDataModel<T> extends ListModelList<T> {
     public static final String NATURAL = "natural";
+
     public static final String ASCENDING = "ascending";
+
     public static final String DESCENDING = "descending";
-    private int CACHE_SIZE = 100;
+
+    private final int CACHE_SIZE = 100;
+
+    private final HashMap<Integer, T> cache = new HashMap<>();
+
     private int cacheStart;
+
     private int cacheEnd;
+
     private int resultSetSize = -1;
-    private HashMap<Integer, T> cache = new HashMap<>();
+
     @Setter
     private FieldComparator sortComparator;
 
+    @Autowired
+    private ApplicationUIProperties applicationUIProperties;
+
     public CachedDataModel() {
 
         setMultiple(false);
@@ -166,8 +188,46 @@ public abstract class CachedDataModel<T> extends ListModelList<T> {
     @Override
     public void sort(Comparator<T> cmpr, boolean ascending) {
         sortComparator = (FieldComparator) cmpr;
-//        log.info("Sort {} {}", sortComparator.getOrderBy(), ascending);
         reset();
     }
+
+    public Path export(String name, IDataHeaderProvider headerProvider, IRowDataProvider<T> rowDataProvider) {
+        String timestamp = DateTimeFormatter.ofPattern("yyyyMMdd-HHmmss").format(LocalDateTime.now());
+        Path result = Paths.get(applicationUIProperties.getExportTempPath(), String.format("%s-%s.xlsx", name, timestamp));
+        int resultSetCount = getResultSetCount();
+        if (resultSetCount == 0) {
+            return null;
+        }
+        int pageCount = resultSetCount / CACHE_SIZE;
+        if (resultSetCount % CACHE_SIZE > 0) {
+            pageCount++;
+        }
+        int row = 0;
+        try (OutputStream os = Files.newOutputStream(result)) {
+            Workbook wb = new Workbook(os, "SLY-CRM", "1.0");
+            Worksheet ws = wb.newWorksheet("Sheet 1");
+            String[] headers = headerProvider.mapHeaders();
+            for (int h = 0; h < headers.length; h++) {
+                ws.value(row, h, headers[h]);
+            }
+            for (int i = 0; i < pageCount; i++) {
+                List<T> datas = getResultSet(i, CACHE_SIZE, sortComparator);
+                log.info("Got {} records", datas.size());
+                for (T data : datas) {
+                    String[] rowData = rowDataProvider.mapRowData(data);
+                    row++;
+                    for (int o = 0; o < rowData.length; o++) {
+                        ws.value(row, o, rowData[o]);
+                    }
+                }
+            }
+            wb.finish();
+
+            Filedownload.save(result.toFile(), "application/vnd.ms-excel");
+        } catch (Exception e) {
+            log.error(e.getMessage());
+        }
+        return result;
+    }
 }
 
diff --git a/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IDataHeaderProvider.java b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IDataHeaderProvider.java
new file mode 100644
index 0000000..f10ec93
--- /dev/null
+++ b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IDataHeaderProvider.java
@@ -0,0 +1,7 @@
+package hu.user.lis.ui.data.common;
+
+public interface IDataHeaderProvider {
+
+    String[] mapHeaders();
+
+}
diff --git a/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IRowDataProvider.java b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IRowDataProvider.java
new file mode 100644
index 0000000..ef68d3e
--- /dev/null
+++ b/sly-crm-ui/src/main/java/hu/user/lis/ui/data/common/IRowDataProvider.java
@@ -0,0 +1,7 @@
+package hu.user.lis.ui.data.common;
+
+public interface IRowDataProvider<T> {
+
+    String[] mapRowData(T data);
+
+}
diff --git a/sly-crm-ui/src/main/java/hu/user/lis/ui/properties/ApplicationUIProperties.java b/sly-crm-ui/src/main/java/hu/user/lis/ui/properties/ApplicationUIProperties.java
index 9299b29..9df3973 100644
--- a/sly-crm-ui/src/main/java/hu/user/lis/ui/properties/ApplicationUIProperties.java
+++ b/sly-crm-ui/src/main/java/hu/user/lis/ui/properties/ApplicationUIProperties.java
@@ -17,4 +17,5 @@ public class ApplicationUIProperties {
 
     private boolean disableProfileSave;
 
+    private String exportTempPath;
 }
diff --git a/sly-crm-ui/src/main/java/hu/user/lis/ui/view/PartnersViewModel.java b/sly-crm-ui/src/main/java/hu/user/lis/ui/view/PartnersViewModel.java
index 87e15b9..e66457d 100644
--- a/sly-crm-ui/src/main/java/hu/user/lis/ui/view/PartnersViewModel.java
+++ b/sly-crm-ui/src/main/java/hu/user/lis/ui/view/PartnersViewModel.java
@@ -86,4 +86,9 @@ public class PartnersViewModel extends FilterActiveViewModel<Partner> {
                     }
                 });
     }
+
+    @Command
+    public void onExport() {
+        partnersDataModel.export();
+    }
 }
diff --git a/sly-crm-ui/src/main/resources/web/associates.zul b/sly-crm-ui/src/main/resources/web/associates.zul
index 5dc4a87..3263382 100644
--- a/sly-crm-ui/src/main/resources/web/associates.zul
+++ b/sly-crm-ui/src/main/resources/web/associates.zul
@@ -1,5 +1,3 @@
-<?link rel="stylesheet" type="text/css" href="~./static/css/skeleton.css" ?>
-<?link rel="stylesheet" type="text/css" href="~./static/css/webclient.css" ?>
 <zk>
     <!--    <style>-->
     <!--        .z-listitem-selected>.z-listcell>.z-listcell-content {-->
@@ -8,16 +6,19 @@
     <!--    </style>-->
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.AssociatesViewModel')">
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Munkatársak" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
-                    <toolbarbutton label="Új" iconSclass="z-icon-plus" onClick="@command('onAdd')"/>
+                <toolbar align="end">
+                    <toolbarbutton label="Új" iconSclass="z-icon-plus"
+                                   onClick="@command('onAdd')"/>
                     <toolbarbutton label="Szerkeszt" iconSclass="z-icon-edit"
-                                   onClick="@command('onEdit')" disabled="@load(empty vm.selectedEntity)"/>
+                                   onClick="@command('onEdit')"
+                                   disabled="@load(empty vm.selectedEntity)"/>
                     <toolbarbutton label="Töröl" iconSclass="z-icon-remove"
-                                   onClick="@command('onDelete')" disabled="@load(empty vm.selectedEntity)"/>
+                                   onClick="@command('onDelete')"
+                                   disabled="@load(empty vm.selectedEntity)"/>
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
         <borderlayout>
             <north flex="true">
diff --git a/sly-crm-ui/src/main/resources/web/editor/project-editor.zul b/sly-crm-ui/src/main/resources/web/editor/project-editor.zul
index aa366c1..565d4f5 100644
--- a/sly-crm-ui/src/main/resources/web/editor/project-editor.zul
+++ b/sly-crm-ui/src/main/resources/web/editor/project-editor.zul
@@ -2,7 +2,11 @@
 <zk>
     <window id="projectEditor" hflex="true" vflex="true"
             viewModel="@id('vm') @init('hu.user.lis.ui.editor.ProjectEditorModel')">
-        <caption label="Projekt szerkesztés"/>
+        <caption>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
+                <label value="Projekt szerkesztés" sclass="list-title"/>
+            </hbox>
+        </caption>
         <borderlayout>
             <center id="centerPanel" border="none" vflex="true" hflex="true" autoscroll="true">
                 <vlayout hflex="true" vflex="min">
diff --git a/sly-crm-ui/src/main/resources/web/import-invoices-approve.zul b/sly-crm-ui/src/main/resources/web/import-invoices-approve.zul
index a66489e..5ca445d 100644
--- a/sly-crm-ui/src/main/resources/web/import-invoices-approve.zul
+++ b/sly-crm-ui/src/main/resources/web/import-invoices-approve.zul
@@ -2,16 +2,15 @@
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.ApproveInvoicesViewModel')">
         <!--        <timer id="timer" delay="1000" repeats="true" onTimer="@command('uiTick')"/>-->
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Számla import - Jóváhagyás" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
+                <toolbar align="end">
                     <toolbarbutton label="Frissít" iconSclass="z-icon-refresh" onClick="@command('onRefresh')"/>
                     <!--                    <toolbarbutton label="Léptet" iconSclass="z-icon-tasks"-->
                     <!--                                   onClick="@command('onCompleteTask')" disabled="@load(empty vm.selectedEntity)"/>-->
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
-
         <borderlayout>
             <north flex="true">
             </north>
diff --git a/sly-crm-ui/src/main/resources/web/import-invoices-assign.zul b/sly-crm-ui/src/main/resources/web/import-invoices-assign.zul
index fec78df..8f577ef 100644
--- a/sly-crm-ui/src/main/resources/web/import-invoices-assign.zul
+++ b/sly-crm-ui/src/main/resources/web/import-invoices-assign.zul
@@ -2,16 +2,15 @@
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.AssignInvoicesViewModel')">
         <!--        <timer id="timer" delay="1000" repeats="true" onTimer="@command('uiTick')"/>-->
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Számla import - Csatolás" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
+                <toolbar align="end">
                     <toolbarbutton label="Frissít" iconSclass="z-icon-refresh" onClick="@command('onRefresh')"/>
                     <!--                    <toolbarbutton label="Léptet" iconSclass="z-icon-tasks"-->
                     <!--                                   onClick="@command('onCompleteTask')" disabled="@load(empty vm.selectedEntity)"/>-->
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
-
         <borderlayout>
             <north flex="true">
             </north>
diff --git a/sly-crm-ui/src/main/resources/web/import-invoices-suspended.zul b/sly-crm-ui/src/main/resources/web/import-invoices-suspended.zul
index 9cc8a19..f4e3464 100644
--- a/sly-crm-ui/src/main/resources/web/import-invoices-suspended.zul
+++ b/sly-crm-ui/src/main/resources/web/import-invoices-suspended.zul
@@ -2,13 +2,13 @@
 <zk>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.ImportInvoicesSuspendedViewModel')">
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Számla parkoló" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
+                <toolbar align="end">
                     <toolbarbutton label="Iktatás" iconSclass="z-icon-forward" onClick="@command('onStartAssignment')"
                                    disabled="@load(empty vm.selectedEntity)"/>
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
         <borderlayout>
             <north hflex="true">
diff --git a/sly-crm-ui/src/main/resources/web/invoice-payment.zul b/sly-crm-ui/src/main/resources/web/invoice-payment.zul
index 396b02e..b2ad8ac 100644
--- a/sly-crm-ui/src/main/resources/web/invoice-payment.zul
+++ b/sly-crm-ui/src/main/resources/web/invoice-payment.zul
@@ -10,9 +10,9 @@
     </style>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.InvoicePaymentViewModel')">
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Számla kiegyenlítés" sclass="list-title"/>
-            </hlayout>
+            </hbox>
         </caption>
 
         <borderlayout>
diff --git a/sly-crm-ui/src/main/resources/web/invoices.zul b/sly-crm-ui/src/main/resources/web/invoices.zul
index 42b9d68..1dd314b 100644
--- a/sly-crm-ui/src/main/resources/web/invoices.zul
+++ b/sly-crm-ui/src/main/resources/web/invoices.zul
@@ -6,9 +6,9 @@
     </zscript>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.InvoicesViewModel')">
         <caption>
-            <hlayout hflex="true">
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Számlák" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
+                <toolbar align="end">
                     <toolbarbutton label="Szerkeszt" iconSclass="z-icon-edit" onClick="@command('onEdit')"
                                    disabled="@load(empty vm.selectedEntity)"/>
                     <!--                        <toolbarbutton label="Projekt módosítás" iconSclass="z-icon-forward"-->
@@ -17,9 +17,8 @@
                                    onClick="@command('onInvoicePayment')"
                                    disabled="@load(empty vm.selectedEntity || vm.selectedEntity.planned)"/>
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
-
         <borderlayout>
             <north hflex="true">
                 <toolbar>
@@ -65,7 +64,7 @@
                                    onClick="@command('setIncoming', incoming=false)"/>
 
                     <separator orient="vertical"/>
-                    
+
                     <toolbarbutton mode="toggle" iconSclass="z-icon-credit-card" label="Kiegyenlítve"
                                    checked="@bind(vm.invoiceFilter.paid)"/>
                 </toolbar>
diff --git a/sly-crm-ui/src/main/resources/web/partners.zul b/sly-crm-ui/src/main/resources/web/partners.zul
index 8d02a09..7c54a3e 100644
--- a/sly-crm-ui/src/main/resources/web/partners.zul
+++ b/sly-crm-ui/src/main/resources/web/partners.zul
@@ -1,9 +1,9 @@
 <zk>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.PartnersViewModel')">
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Partnerek" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
+                <toolbar align="end">
                     <toolbarbutton label="Új" iconSclass="z-icon-plus"
                                    onClick="@command('onAdd')"/>
                     <toolbarbutton label="Szerkeszt" iconSclass="z-icon-edit"
@@ -13,7 +13,7 @@
                                    onClick="@command('onDelete')"
                                    disabled="@load(empty vm.selectedEntity)"/>
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
         <borderlayout>
             <north hflex="true">
@@ -38,20 +38,6 @@
                     <listbox vflex="true" model="@load(vm.partnersDataModel)" multiple="false"
                              itemRenderer="@load(vm.partnersDataModel.renderer)" onSelect="@command('onListSelection')"
                              sizedByContent="true" span="true">
-                        <!--                        <listfoot>-->
-                        <!--                            <listfooter colspan="@load(vm.partnersDataModel.renderer.colCount)">-->
-                        <!--                                <toolbar>-->
-                        <!--                                    <toolbarbutton label="Hozzáadás" iconSclass="z-icon-plus"-->
-                        <!--                                                   onClick="@command('onAdd')"/>-->
-                        <!--                                    <toolbarbutton label="Szerkesztés" iconSclass="z-icon-edit"-->
-                        <!--                                                   onClick="@command('onEdit')"-->
-                        <!--                                                   disabled="@load(empty vm.selectedEntity)"/>-->
-                        <!--                                    <toolbarbutton label="Törlés" iconSclass="z-icon-remove"-->
-                        <!--                                                   onClick="@command('onDelete')"-->
-                        <!--                                                   disabled="@load(empty vm.selectedEntity)"/>-->
-                        <!--                                </toolbar>-->
-                        <!--                            </listfooter>-->
-                        <!--                        </listfoot>-->
                         <listhead sizable="true" menupopup="editPopup"
                                   onColSize="@command('onHeaderSizeChanged', node=node)"
                                   children="@bind(vm.partnersDataModel.renderer.columnSettings) @template('head-item')">
@@ -74,7 +60,15 @@
                             </listitem>
                         </template>
                     </listbox>
-
+                    <!--                                <div style="width: 100%; height: 10px; background: red"></div>
+                    sclass="hboxRemoveWhiteStrips"
+                    -->
+                    <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
+                        <toolbar align="end">
+                            <toolbarbutton label="Export" iconSclass="z-icon-file-excel-o"
+                                           onClick="@command('onExport')"/>
+                        </toolbar>
+                    </hbox>
                 </vlayout>
             </center>
         </borderlayout>
diff --git a/sly-crm-ui/src/main/resources/web/projects.zul b/sly-crm-ui/src/main/resources/web/projects.zul
index 90caacc..012746e 100644
--- a/sly-crm-ui/src/main/resources/web/projects.zul
+++ b/sly-crm-ui/src/main/resources/web/projects.zul
@@ -1,9 +1,9 @@
 <zk>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.ProjectsViewModel')">
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Projektek" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
+                <toolbar align="end">
                     <toolbarbutton label="Új" iconSclass="z-icon-plus"
                                    onClick="@command('onAdd')"/>
                     <toolbarbutton label="Szerkeszt" iconSclass="z-icon-edit"
@@ -16,9 +16,8 @@
                                    onClick="@command('onStartProcess')"
                                    disabled="@load(empty vm.selectedEntity)"/>
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
-
         <borderlayout>
             <north flex="true">
                 <toolbar>
diff --git a/sly-crm-ui/src/main/resources/web/service-records.zul b/sly-crm-ui/src/main/resources/web/service-records.zul
index fb66a7f..7e4af83 100644
--- a/sly-crm-ui/src/main/resources/web/service-records.zul
+++ b/sly-crm-ui/src/main/resources/web/service-records.zul
@@ -2,18 +2,20 @@
 <zk>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.ServiceRecordsViewModel')">
         <caption>
-            <hlayout>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
                 <label value="Munkalapok" sclass="list-title"/>
-                <toolbar style="margin-left: 50px">
-                    <toolbarbutton label="Új" iconSclass="z-icon-plus" onClick="@command('onAdd')"/>
+                <toolbar align="end">
+                    <toolbarbutton label="Új" iconSclass="z-icon-plus"
+                                   onClick="@command('onAdd')"/>
                     <toolbarbutton label="Szerkeszt" iconSclass="z-icon-edit"
-                                   onClick="@command('onEdit')" disabled="@load(empty vm.selectedEntity)"/>
+                                   onClick="@command('onEdit')"
+                                   disabled="@load(empty vm.selectedEntity)"/>
                     <toolbarbutton label="Töröl" iconSclass="z-icon-remove"
-                                   onClick="@command('onDelete')" disabled="@load(empty vm.selectedEntity)"/>
+                                   onClick="@command('onDelete')"
+                                   disabled="@load(empty vm.selectedEntity)"/>
                 </toolbar>
-            </hlayout>
+            </hbox>
         </caption>
-
         <borderlayout>
             <north flex="true">
                 <toolbar>
diff --git a/sly-crm-ui/src/main/resources/web/settings.zul b/sly-crm-ui/src/main/resources/web/settings.zul
index 956e685..d067e5a 100644
--- a/sly-crm-ui/src/main/resources/web/settings.zul
+++ b/sly-crm-ui/src/main/resources/web/settings.zul
@@ -1,6 +1,10 @@
 <zk>
     <window id="centerPanel" vflex="true" viewModel="@id('vm') @init('hu.user.lis.ui.view.SettingsViewModel')">
-        <caption sclass="list-title" label="Beállítások"/>
+        <caption>
+            <hbox pack="stretch" sclass="hboxRemoveWhiteStrips" hflex="true">
+                <label value="Beállítások" sclass="list-title"/>
+            </hbox>
+        </caption>
 
         <panel collapsible="true" open="false" border="rounded"
                onOpen="@command('onOpenFormPanel', parentPanel=centerPanel)">
diff --git a/sly-crm-ui/src/main/resources/web/static/css/webclient.css b/sly-crm-ui/src/main/resources/web/static/css/webclient.css
index 65393ac..e1aee26 100644
--- a/sly-crm-ui/src/main/resources/web/static/css/webclient.css
+++ b/sly-crm-ui/src/main/resources/web/static/css/webclient.css
@@ -1,3 +1,6 @@
+.z-caption-content {
+    width: 100%
+}
 .number-box {
     text-align: right;
     width: 100px;
-- 
2.54.0