苍穹报表开发样例

已于 2022-06-01 16:51:43 修改
阅读量1.8w 收藏 1
点赞数 1
分类专栏： 金蝶云苍穹开发 文章标签： intellij-idea
于 2022-04-21 10:18:28 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/tanrt/article/details/124313946
版权

 1: 猪场生产日报

package zb.pc.formplugin.pcsr.pigfarmdaily;

import kd.bos.algo.*;
import kd.bos.algo.input.CollectionInput;
import kd.bos.dataentity.entity.DynamicObject;
import kd.bos.dataentity.entity.DynamicObjectCollection;
import kd.bos.entity.report.AbstractReportListDataPlugin;
import kd.bos.entity.report.FilterInfo;
import kd.bos.entity.report.ReportQueryParam;
import kd.bos.orm.query.QCP;
import kd.bos.orm.query.QFilter;
import kd.bos.servicehelper.QueryServiceHelper;
import org.apache.commons.lang3.StringUtils;
import zb.common.constant.PigFieldConstant;
import zb.pc.common.constant.BaseConstant;
import zb.pc.common.constant.ImmediateLiveStockConstant;
import zb.pc.common.constant.ImportSeedRecordConstant;
import zb.pc.common.constant.pbdem.deadrecord.DeadRecordConstant;
import zb.pc.common.constant.pbsm.AbnPregRecordConstant;
import zb.pc.common.constant.pbsm.BirthConstant;
import zb.pc.common.constant.pbsm.MatingRecordConstant;
import zb.pc.common.enums.PigStateEnum;
import zb.pc.common.enums.PigTypeEnum;
import zb.pc.common.utils.DateUtil;

import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.*;
import java.util.stream.Collectors;

/**
 * @Module:
 * @ClassName: PigfarmDaily
 * @Description: 繁殖报表--猪场生产日报
 * @Author xxx
 * @Date 2022/4/18
 * @Version 1.0
 */
public class PigfarmDailyListDataPlugin extends AbstractReportListDataPlugin {


    @Override
    public DataSet query(ReportQueryParam param, Object o) throws Throwable {
        // 创建一个空的DataSet
        Collection<Object[]> coll = new ArrayList<>();
        //将自定义的字段和类型对应插入
        ArrayList<String> names = PigfarmDailyListDataPlugin.FieldEnum.getNames();
        ArrayList<DataType> types = PigfarmDailyListDataPlugin.FieldEnum.getTypes();
        RowMeta rowMeta = RowMetaFactory.createRowMeta(names.toArray(new String[]{}), types.toArray(new DataType[]{}));
        CollectionInput inputs = new CollectionInput(rowMeta, coll);
        //Algo 创建dataSet
        DataSet resultDataSet = Algo.create(this.getClass().getName()).createDataSet(inputs);
        FilterInfo filterInfo = param.getFilter();
        DynamicObject farm = filterInfo.getDynamicObject("zb_pigfarmfilter");
        Date startDate = filterInfo.getDate("zb_stardate");
        Date endDate = filterInfo.getDate("zb_enddate");
        DynamicObjectCollection fields = QueryServiceHelper.query(PigFieldConstant.FORMBILLID, String.join(",", PigFieldConstant.ID), new QFilter[]{new QFilter(PigFieldConstant.ZB_PIGFARM, QCP.equals, farm.getPkValue())});
        List<Long> fieldId = fields.stream().map(info -> info.getLong(BaseConstant.ID)).collect(Collectors.toList());
        DynamicObjectCollection matingQuery = QueryServiceHelper.query(MatingRecordConstant.FORMBILLID,
                String.join(",", MatingRecordConstant.ENTRYENTITYID_ZB_PB_MATINGRECORD_ET + "." + MatingRecordConstant.MATINGRECORD_ET_ZB_ISHBFEMALE, MatingRecordConstant.ZB_PIGFIELD),
                new QFilter[]{new QFilter(MatingRecordConstant.ZB_PIGFARM, QCP.equals, farm.getPkValue()).and(MatingRecordConstant.ZB_BIZDATE, QCP.large_equals, startDate).and(MatingRecordConstant.ZB_BIZDATE, QCP.less_equals, endDate)});
        Map<Long, Map<Boolean, Long>> matings = matingQuery.stream().filter(Objects::nonNull).
                collect(Collectors.groupingBy(info -> info.getLong(MatingRecordConstant.ZB_PIGFIELD),
                        Collectors.groupingBy(item -> item.getBoolean(MatingRecordConstant.ENTRYENTITYID_ZB_PB_MATINGRECORD_ET + "." + MatingRecordConstant.MATINGRECORD_ET_ZB_ISHBFEMALE),
                                Collectors.counting())));

        DynamicObjectCollection abnQuery = QueryServiceHelper.query(AbnPregRecordConstant.FORMBILLID,
                String.join(",", AbnPregRecordConstant.ENTRYENTITYID_ZB_PB_ABNPREGRECORD_ET + "." + AbnPregRecordConstant.ABNPREGRECORD_ET_ABNREASON, AbnPregRecordConstant.PIGFIELD),
                new QFilter[]{new QFilter(AbnPregRecordConstant.PIGFARM, QCP.equals, farm.getPkValue()).and(AbnPregRecordConstant.BIZDATE, QCP.large_equals, startDate).and(AbnPregRecordConstant.BIZDATE, QCP.less_equals, endDate)});
        Map<Long, Map<Boolean, Long>> abns = abnQuery.stream().filter(Objects::nonNull).
                collect(Collectors.groupingBy(info -> info.getLong(AbnPregRecordConstant.PIGFIELD),
                        Collectors.groupingBy(item -> item.getBoolean(AbnPregRecordConstant.ENTRYENTITYID_ZB_PB_ABNPREGRECORD_ET + "." + AbnPregRecordConstant.ABNPREGRECORD_ET_ABNREASON),
                                Collectors.counting())));

        DynamicObjectCollection birthQuery = QueryServiceHelper.query(BirthConstant.FormBillId, String.join(",",
                        BirthConstant.Totallive, BirthConstant.Totaldith, BirthConstant.Totalmumy, BirthConstant.Totalderm, BirthConstant.EntryEntityId_zb_birth_detail, BirthConstant.Pigfield),
                new QFilter[]{new QFilter(BirthConstant.Pigfarm, QCP.equals, farm.getPkValue()).and(BirthConstant.Bizdate, QCP.large_equals, startDate).and(BirthConstant.Bizdate, QCP.less_equals, endDate)});
        Map<Long, List<DynamicObject>> births = birthQuery.stream().filter(Objects::nonNull).collect(Collectors.groupingBy(info -> info.getLong(BirthConstant.Pigfield)));

        DynamicObjectCollection deadQuery = QueryServiceHelper.query(DeadRecordConstant.FORMBILLID, String.join(",", DeadRecordConstant.ZB_PIGFIELD,
                DeadRecordConstant.ZB_PIGTYPE + ".number"), new QFilter[]{new QFilter(DeadRecordConstant.ZB_PIGFARM, QCP.equals, farm.getPkValue()).and(DeadRecordConstant.ZB_BIZDATE, QCP.large_equals, startDate).and(DeadRecordConstant.ZB_BIZDATE, QCP.less_equals, endDate)});
        Map<Long, Map<String, Long>> deads = deadQuery.stream().filter(Objects::nonNull).collect(Collectors.groupingBy(info -> info.getLong(AbnPregRecordConstant.PIGFIELD),
                Collectors.groupingBy(item -> item.getString(DeadRecordConstant.ZB_PIGTYPE + ".number"),
                        Collectors.counting())));


        DynamicObjectCollection importQuery = QueryServiceHelper.query(ImportSeedRecordConstant.FORMBILLID,
                String.join(",", ImportSeedRecordConstant.ZB_PIGFIELD, ImportSeedRecordConstant.ZB_SOWNO, ImportSeedRecordConstant.ZB_PIGNO),
                new QFilter[]{new QFilter(ImportSeedRecordConstant.ZB_PIGFARM, QCP.equals, farm.getPkValue()).and(ImportSeedRecordConstant.ZB_BIZDATE, QCP.large_equals, startDate).and(ImportSeedRecordConstant.ZB_BIZDATE, QCP.less_equals, endDate)});
        Map<Long, List<DynamicObject>> imports = importQuery.stream().filter(Objects::nonNull).collect(Collectors.groupingBy(info -> info.getLong(ImportSeedRecordConstant.ZB_PIGFIELD)));


        DynamicObjectCollection immeQuery = QueryServiceHelper.query(ImmediateLiveStockConstant.FORMBILLID, String.join(",",
                        ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGFIELD,
                        ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number",
                        ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number",
                        ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY),
                new QFilter[]{new QFilter(ImmediateLiveStockConstant.ZB_PIGFARM, QCP.in, farm.getPkValue()).and(ImmediateLiveStockConstant.ZB_BIZDATE, QCP.equals, DateUtil.getLastDate(endDate))});
        Map<Long, List<DynamicObject>> immes = immeQuery.stream().filter(Objects::nonNull).collect(Collectors.groupingBy(info -> info.getLong(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGFIELD)));

        for (Long field : fieldId) {
            Object[] row = new Object[names.size()];
            row[FieldEnum.PIGFIELD.no] = field;
            row[FieldEnum.PRODUCTION.no] = matings.get(field).get(false);
            row[FieldEnum.RESERVE.no] = matings.get(field).get(true);
            //异常原因  空怀:1  返情:2  流产:3
            row[FieldEnum.KH.no] = abns.get(field).get("1");
            row[FieldEnum.FQ.no] = abns.get(field).get("2");
            row[FieldEnum.LC.no] = abns.get(field).get("3");
            int details = births.get(field).stream().mapToInt(info -> info.getDynamicObjectCollection(BirthConstant.EntryEntityId_zb_birth_detail).size()).sum();
            row[FieldEnum.TOTALSON.no] = details;
            int lives = births.get(field).stream().mapToInt(info -> info.getInt(BirthConstant.Totallive)).sum();
            row[FieldEnum.TOTALLIVE.no] = lives;
            row[FieldEnum.TOTALDITH.no] = births.get(field).stream().mapToInt(info -> info.getInt(BirthConstant.Totaldith)).sum();
            row[FieldEnum.TOTALMUMY.no] = births.get(field).stream().mapToInt(info -> info.getInt(BirthConstant.Totalmumy)).sum();
            row[FieldEnum.TOTALDERM.no] = births.get(field).stream().mapToInt(info -> info.getInt(BirthConstant.Totalderm)).sum();
            row[FieldEnum.QUALIFIED.no] = details == 0 ? 0 : new BigDecimal(lives).divide(new BigDecimal(details), 3, RoundingMode.HALF_UP);
            row[FieldEnum.LACTATION.no] = deads.get(field).get(PigTypeEnum.PIGLETS.getValue());
            row[FieldEnum.CONSERVATION.no] = deads.get(field).get(PigTypeEnum.CONSERVATION.getValue());
            row[FieldEnum.FATTEN.no] = deads.get(field).get(PigTypeEnum.FATTENPIG.getValue());
            row[FieldEnum.PRODUCTINGSOW.no] = deads.get(field).get(PigTypeEnum.PRODUCTION_SOW.getValue());
            row[FieldEnum.RESERVESOW.no] = deads.get(field).get(PigTypeEnum.BACKUP_SOW.getValue());
            row[FieldEnum.PRODUCTIONBOAR.no] = deads.get(field).get(PigTypeEnum.PRODUCTION_BOAR.getValue());
            row[FieldEnum.RESERVEBOAR.no] = deads.get(field).get(PigTypeEnum.BACKUP_BOAR.getValue());

            row[FieldEnum.INTRODUCTION.no] = imports.get(field).stream().mapToInt(info -> info.getInt(ImportSeedRecordConstant.ZB_SOWNO) + info.getInt(ImportSeedRecordConstant.ZB_PIGNO)).sum();

            row[FieldEnum.LIVESTOCKCOUNT.no] = immes.get(field).stream().
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKLACTATION.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number"), PigTypeEnum.PIGLETS.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKCONSERVATION.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number"), PigTypeEnum.CONSERVATION.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKFATTEN.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number"), PigTypeEnum.FATTENPIG.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKPR.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number"), PigStateEnum.BR.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKKD.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number"), PigStateEnum.KHWP.getValue()) ||
                            StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number"), PigStateEnum.DNWP.getValue()) ||
                            StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number"), PigStateEnum.LCWP.getValue()) ||
                            StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number"), PigStateEnum.FQWP.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKHY.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGSTATE + ".number"), PigStateEnum.HY.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKPRO.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number"), PigTypeEnum.PRODUCTION_BOAR.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKPRORESERVESW.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number"), PigTypeEnum.BACKUP_SOW.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
            row[FieldEnum.LIVESTOCKPRORESERVEBO.no] = immes.get(field).stream().
                    filter(info -> StringUtils.equals(info.getString(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_PIGTYPE + ".number"), PigTypeEnum.BACKUP_BOAR.getValue())).
                    mapToInt(info -> info.getInt(ImmediateLiveStockConstant.ENTRYENTITYID_ZB_LIVESTOCK + "." + ImmediateLiveStockConstant.ZB_LIVESTOCK_ZB_QUANTITY)).sum();
        }

        return resultDataSet;
    }

    enum FieldEnum {
        PIGFIELD("zb_pigfield", DataType.LongType, 0),
        PRODUCTION("zb_production", DataType.IntegerType, 1),
        RESERVE("zb_reserve", DataType.IntegerType, 2),
        KH("zb_kh", DataType.IntegerType, 3),
        FQ("zb_fq", DataType.IntegerType, 4),
        LC("zb_lc", DataType.IntegerType, 5),
        TOTALSON("zb_totalson", DataType.IntegerType, 6),
        TOTALLIVE("zb_totallive", DataType.IntegerType, 7),
        TOTALDITH("zb_totaldith", DataType.IntegerType, 8),
        TOTALMUMY("zb_totalmumy", DataType.IntegerType, 9),
        TOTALDERM("zb_totalderm", DataType.IntegerType, 10),
        QUALIFIED("zb_qualified", DataType.IntegerType, 11),
        LACTATION("zb_lactation", DataType.IntegerType, 12),
        CONSERVATION("zb_conservation", DataType.IntegerType, 13),
        FATTEN("zb_fatten", DataType.IntegerType, 14),
        PRODUCTINGSOW("zb_productingsow", DataType.IntegerType, 15),
        RESERVESOW("zb_reservesow", DataType.IntegerType, 16),
        PRODUCTIONBOAR("zb_productionboar", DataType.IntegerType, 17),
        RESERVEBOAR("zb_reserveboar", DataType.IntegerType, 18),
        FAT("zb_fat", DataType.IntegerType, 19),
        FATCOUNT("zb_fatcount", DataType.IntegerType, 20),
        BREEDING("zb_breeding", DataType.IntegerType, 21),
        BREEDINGCOUNT("zb_breedingcount", DataType.IntegerType, 22),
        PIGLET("zb_piglet", DataType.IntegerType, 23),
        PIGLETCOUNT("zb_pigletcount", DataType.IntegerType, 24),
        RESERVES("zb_reserves", DataType.IntegerType, 25),
        RESERVESCOUNT("zb_reservescount", DataType.IntegerType, 26),
        PRODUCTIONS("zb_productions", DataType.IntegerType, 27),
        PRODUCTIONSCOUNT("zb_productionscount", DataType.IntegerType, 28),
        INTRODUCTION("zb_introduction", DataType.IntegerType, 29),
        PIGLETS("zb_piglets", DataType.IntegerType, 30),
        LIVESTOCKCOUNT("zb_livestockcount", DataType.IntegerType, 31),
        LIVESTOCKLACTATION("zb_livestocklactation", DataType.IntegerType, 32),
        LIVESTOCKCONSERVATION("zb_livestockconservation", DataType.IntegerType, 33),
        LIVESTOCKFATTEN("zb_livestockfatten", DataType.IntegerType, 34),
        LIVESTOCKPR("zb_livestockpr", DataType.IntegerType, 35),
        LIVESTOCKKD("zb_livestockkd", DataType.IntegerType, 36),
        LIVESTOCKHY("zb_livestockhy", DataType.IntegerType, 37),
        LIVESTOCKPRO("zb_livestockpro", DataType.IntegerType, 38),
        LIVESTOCKPRORESERVESW("zb_livestockproreservesw", DataType.IntegerType, 39),
        LIVESTOCKPRORESERVEBO("zb_livestockproreservebo", DataType.IntegerType, 40);

        private String name;
        private DataType type;
        private Integer no;

        FieldEnum(String name, DataType type, Integer no) {
            this.name = name;
            this.type = type;
            this.no = no;
        }

        private static ArrayList<String> getNames() {
            PigfarmDailyListDataPlugin.FieldEnum[] fieldEnums = values();
            ArrayList<String> list = new ArrayList();
            for (int i = 0; i < fieldEnums.length; i++) {
                list.add(fieldEnums[i].name);
            }
            return list;
        }

        private static ArrayList<DataType> getTypes() {
            PigfarmDailyListDataPlugin.FieldEnum[] fieldEnums = values();
            ArrayList<DataType> list = new ArrayList();
            for (int i = 0; i < fieldEnums.length; i++) {
                list.add(fieldEnums[i].type);
            }
            return list;
        }
    }
}

2：繁殖用电明细

package zb.pc.formplugin.pcem.report.useeldetail;

import kd.bos.algo.*;
import kd.bos.algo.input.CollectionInput;
import kd.bos.dataentity.entity.DynamicObject;
import kd.bos.dataentity.utils.ObjectUtils;
import kd.bos.db.DB;
import kd.bos.db.DBRoute;
import kd.bos.entity.report.AbstractReportColumn;
import kd.bos.entity.report.AbstractReportListDataPlugin;
import kd.bos.entity.report.FilterInfo;
import kd.bos.entity.report.ReportQueryParam;
import zb.common.enums.DBRouteEnum;

import java.util.*;

/**
 * @Description: 正邦报表-繁殖综合-繁殖用电明细
 * @Author xxx
 * @Date 2022/5/26
 */
public class UseElDetailReportListPlugin extends AbstractReportListDataPlugin {

    //报表的自定义字段,必须和表报中的标识名一一对应
    private static final String[] fieldNames = {"zb_area", "zb_monthlivestock", "zb_nowstock", "zb_ammeternum", "zb_electrovalence"
            ,"zb_quota", "zb_superquota", "zb_taotal", "zb_oneweek", "zb_towweek"
            ,"zb_threeweek", "zb_fourweek"};
    //报表列表上所有字段对应的数据类型,必须和FIELDS中的元素一一对应
    private static final DataType[] dataTypes = {DataType.StringType, DataType.DoubleType, DataType.DoubleType, DataType.IntegerType, DataType.DoubleType
            ,DataType.DoubleType, DataType.DoubleType, DataType.DoubleType, DataType.DoubleType, DataType.DoubleType
            ,DataType.DoubleType, DataType.DoubleType};


    /**
     * 报表查询方法
     * @param reportQueryParam
     * @param o
     * @return
     * @throws Throwable
     */
    @Override
    public DataSet query(ReportQueryParam reportQueryParam, Object o) throws Throwable {
        DataSet resultDataSet = null;
        Collection<Object[]> coll = new ArrayList<>();
        RowMeta  rowMeta= RowMetaFactory.createRowMeta(fieldNames, dataTypes);

        FilterInfo filter = reportQueryParam.getFilter();
        DynamicObject pigFarm = filter.getDynamicObject("zb_pigfarmfilter");
        Date month = filter.getDate("zb_datemonth");
        Date startDate = null;
        Date endDate = null;

        if(ObjectUtils.isEmpty(month)){
            coll = null;
        }else{
            StringBuffer sql = new StringBuffer();
            sql.append("/*dialect*/ \n");
            sql.append("SELECT temp.fk_zb_pigfarmid \n");
            sql.append("       ,temp.fk_zb_listareaid \n");
            sql.append("       ,temp.qty qty \n");
            sql.append("       ,nvl(d.fk_zb_electprice, 0) electprice \n");
            sql.append("\t\t\t ,e.fname areaname \n");
            sql.append(" \n");
            sql.append("FROM ( \n");
            sql.append("  SELECT DISTINCT a.fk_zb_pigfarmid,c.fk_zb_listareaid,COUNT(c.fk_zb_listareaid) qty \n");
            sql.append("  FROM yzpc.tk_zb_pc_hydropowerrecord a \n");
            sql.append("  INNER JOIN yzpc.tk_zb_pc_electricentry b ON a.fid=b.fid \n");
            sql.append("  INNER JOIN yzpc.tk_zb_pc_electtable c ON b.fk_zb_electric=c.fid \n");
            sql.append("\tAND c.fstatus='C' AND c.fenable=1 \n");
            sql.append("\tWHERE a.fbillstatus='C' \n");
            sql.append("\tAND a.fk_zb_pigfarmid='560583063785050245' \n");
            sql.append("  GROUP BY a.fk_zb_pigfarmid,c.fk_zb_listareaid \n");
            sql.append(") temp \n");
            sql.append("LEFT JOIN yzpc.tk_zb_pc_pigfarm d ON d.fid=temp.fk_zb_pigfarmid \n");
            sql.append("LEFT JOIN yzpc.tk_zb_pc_areaarchives_l e ON e.fid=temp.fk_zb_listareaid AND e.flocaleid='zh_CN' \n");

            Collection<Object[]> sqlData = DB.query(DBRoute.of(DBRouteEnum.PC.getValue()), sql.toString(), rs -> {
                Collection<Object[]> tempColl = new ArrayList<>();
                while (rs.next()) {
                    Object[] rowData = new Object[fieldNames.length];
                    rowData[0]=rs.getString("areaname"); //区域
                    rowData[3]=rs.getString("qty"); //电表个数
                    rowData[4]=rs.getString("electprice"); //电价
                    tempColl.add(rowData);
                }
                return tempColl;
            });
            coll = sqlData;
        }


        CollectionInput input = new CollectionInput(rowMeta, coll);
        resultDataSet= Algo.create(this.getClass().getName()).createDataSet(input);
        return resultDataSet;
    }

    /**
     * 改变列信息
     * @param columns
     * @return
     * @throws Throwable
     */
    @Override
    public List<AbstractReportColumn> getColumns(List<AbstractReportColumn> columns) throws Throwable {
        return super.getColumns(columns);
    }

    /**
     * 设置进度，用于异步查询时界面显示进度
     * @param percent
     */
    @Override
    public void setProgress(int percent) {
        super.setProgress(percent);
    }
}

Gecko （脑）
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
自定义报表样例
07-29
基于Java平台的报表工具产品，采用Excel的习惯来制作报表，功能强大、性能优异，且易学易用。
苍穹开发指南.docx
03-16
苍穹开发指南 苍穹开发指南是为苍穹开发人员提供的详细开发代码示例，旨在帮助开发人员快速掌握苍穹开发技术。以下是苍穹开发指南中涉及到的知识点： 概述 在开始苍穹开发之前，需要了解一些基本概念。苍穹开发...
苍穹外卖开发笔记（1.项目介绍和开发环境）
Kiritoasu的博客
04-11 860
本项目主要为b站黑马程序员苍穹外卖项目学习笔记
金蝶苍穹，报表查询插件
LGangJin的博客
02-28 613
苍穹金蝶报表查询插件
苍穹开发指南（一）
老洪的博客
02-27 2112
概述 概念介绍 为什么要开发插件 使用应用开发平台的设计器开发业务对象，全程配置，简单易学，但不够灵活。 配置业务对象时使用的业务语意，需要预先定义，遇到未考虑的业务场景，则无法处理。 业务对象设计器，目标是实现常见的80%业务语意，利用开放的插件开发，实现剩余20%的功能。 插件如何工作？ 界面加载、及用户与界面交互时，系统会调用插件接口方法，即触发插件事件，通知插件工作； 插件通过实现事件接口方法，捕获插件事件...
模板-纯报表开发
weixin_44698828的博客
04-12 200
*&---------------------------------------------------------------------* *&优化有风险，大改需谨慎！切记切记! *&---------------------------------------------------------------------* *& 程序名称：XXXX查询报表 *& 程序名：ZSDR_XXX *& 开发日期：2022-04-11 *& 创建者
蓝书（算法竞赛进阶指南）刷题记录——hdu2196 Computer（换根DP）
hzk_cpp的博客
06-10 234
题目：hdu2196. 题目大意：给定一棵nnn个点的带边权无向树，求每一个点出发可以到达最远点的距离. 1≤n≤1041\leq n\leq 10^41≤n≤104. 先考虑以某一个点为根，求出f[i][0/1]f[i][0/1]f[i][0/1]表示以点iii为根的子树中iii出发可以到达的最大距离///次大距离. 然后在通过换根DP求出f[i][2]f[i][2]f[i][2]出发不进入原来...
苍穹外卖开发笔记（2.管理端-员工管理 分类管理）
Kiritoasu的博客
04-11 1116
本章为管理端 员工页面 菜品分类关联端相关增删改查功能编写
金蝶云苍穹_插件开发指南
03-06
金蝶云苍穹插件开发指南知识点 金蝶云苍穹插件开发指南是一份详细的开发文档，旨在指导开发者如何开发金蝶云苍穹插件。下面是该指南中的主要知识点： 1. 插件开发的必要性：插件可以扩展金蝶云苍穹的功能，使其...
云苍穹开发一些实例代码
03-06
云苍穹开发一些实例代码 云苍穹开发是一种基于 Java 语言的分布式服务框架，旨在提供高性能、高可扩展性、高可靠性的分布式服务解决方案。以下是云苍穹开发的一些实例代码和相关知识点： 1. 本地开发找不到插件...
金蝶云苍穹_插件开发指南.docx
08-10
金蝶云苍穹_插件开发指南.docx
金蝶云苍穹KDE脚本插件开发指南
03-06
金蝶云苍穹KDE脚本插件开发指南 本资源为金蝶云苍穹KDE脚本插件开发指南，旨在指导开发者快速掌握KDE脚本插件的开发技术。该指南涵盖了插件开发的各个方面，包括概念介绍、插件开发指南、插件事件详解等内容。 一...
金蝶云苍穹插件开发指南大全（精华版）.pdf
04-08
金蝶云苍穹插件开发指南大全（精华版）
金蝶云苍穹开发环境搭建
kw1870的博客
07-21 3081
本文旨在帮助新手快速搭建金蝶云苍穹轻量级环境进行开发和学习
苍穹外卖开发心得
在校学生，爱折腾。喜欢写代码、健身，读点轻松的心理学，哲学书籍。
04-05 952
苍穹外卖开发心得
记录金蝶苍穹开发代码实例
userRobee的博客
08-04 1148
苍穹开发记录
JAVA对DataSet的操作大集合
热门推荐
MIYAOW
08-31 2万+
本博文用来收集JAVA在编程中对DataSet操作所使用的方法。 /** * 将list放map的结构 转化成dataset * @param list * @return */ private DataSet toDataSet(List list) { DataSet dataSet = new DataSet(); if (list == null || l
DataSet数据集的遍历
小娴不是仙的博客
03-24 2204
关于Dataset数据集的遍历问题。     一.遍历一列多行的数据集 foreach (DataRow row in ds.Tables[0].Rows) { al.Add(row[0].ToString()); }     二.遍历一行多列的数据集 foreach (DataColumn column in ds.Tables[
Lombok的认识
最新发布
2301_77358195的博客
07-21 546
例如，过度使用Lombok可能会导致代码可读性下降，因为自动生成的方法可能不如手动编写的方法直观易懂。通过注解的形式自动生成构造器、getter/setter、equals、hashcode、toString等方法，并可以自动化生成日志变量，简化java开发、提高效率。Lombok是一个Java库，它可以通过简单的注解形式来帮助开发人员简化Java代码的编写，特别是减少模板代码的书写。总的来说，Lombok是一个有用的工具，但使用时需要权衡其优缺点，并根据具体需求进行选择。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值