package com.company.pm.entity.dto;

import io.jmix.core.metamodel.annotation.JmixEntity;

@JmixEntity(name = "pm_ChartValuePie")
public class ChartValuePie {
    private String category;

    private Long value;

    private String categoryColor;

    public String getCategoryColor() {
        return categoryColor;
    }

    public void setCategoryColor(String categoryColor) {
        this.categoryColor = categoryColor;
    }

    public Long getValue() {
        return value;
    }

    public void setValue(Long value) {
        this.value = value;
    }

    public String getCategory() {
        return category;
    }

    public void setCategory(String category) {
        this.category = category;
    }
}





<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<window xmlns="http://jmix.io/schema/ui/window"
        caption="msg://manualRequestDataScreen.caption">
    <data>
        <collection id="chartValuePiesDc" class="com.company.pm.entity.dto.ChartValuePie">
            <fetchPlan extends="_base"/>
            <loader id="chartValuePiesDl"/>
        </collection>
    </data>
    <layout expand="table">
        <filter id="filter" dataLoader="chartValuePiesDl">
            <properties include=".*"/>
        </filter>
        <groupTable id="table"
                    width="100%"
                    dataContainer="chartValuePiesDc">
            <actions>
                <action id="excelExport" type="excelExport"/>
            </actions>
            <columns>
                <column id="category"/>
                <column id="value"/>
                <column id="categoryColor"/>
            </columns>
            <simplePagination itemsPerPageVisible="true" itemsPerPageDefaultValue="5000"/>
            <buttonsPanel>
                <button id="tableExcelExportBtn" action="table.excelExport"/>
            </buttonsPanel>
        </groupTable>
    </layout>
</window>



package com.company.pm.screen.manualrequestdata;

import com.company.pm.entity.dto.ChartValuePie;
import io.jmix.core.DataManager;
import io.jmix.core.LoadContext;
import io.jmix.core.Metadata;
import io.jmix.gridexportui.action.ExcelExportAction;
import io.jmix.ui.UiComponents;
import io.jmix.ui.component.Filter;
import io.jmix.ui.component.GroupTable;
import io.jmix.ui.model.CollectionLoader;
import io.jmix.ui.screen.*;
import org.springframework.beans.factory.annotation.Autowired;

import javax.inject.Named;
import java.util.*;

@UiController("pm_ManualRequestDataScreen")
@UiDescriptor("manual-request-data-screen.xml")
public class ManualRequestDataScreen extends Screen {

    @Autowired
    private Metadata metadata;
    @Autowired
    private CollectionLoader<ChartValuePie> chartValuePiesDl;

    @Subscribe
    public void onBeforeShow(final BeforeShowEvent event) {
        chartValuePiesDl.load();
    }

    @Install(to = "chartValuePiesDl", target = Target.DATA_LOADER)
    private List<ChartValuePie> chartValuePiesDlLoadDelegate(final LoadContext<ChartValuePie> loadContext) {
        List<ChartValuePie> chartValuePieList = new ArrayList<>();
        for (int i=0;i<5;i++) {
            ChartValuePie chartValuePie = metadata.create(ChartValuePie.class);
            chartValuePie.setCategory("category" + i);
            chartValuePie.setValue((long) i);
            chartValuePie.setCategoryColor("categoryColor" + i);
            chartValuePieList.add(chartValuePie);
        }
        return chartValuePieList;
    }
}