weaver-matfron-new/interface/mingfeng/getPortalEducational.jsp

<%@ page import="weaver.general.*" %>
<%@page import="weaver.conn.RecordSet"%>
<%@ page import="com.alibaba.fastjson.JSONObject" %>
<%@ page import="java.util.*" %>
<%@ page import="com.engine.matfron.entity.OptionVO" %>
<%@ page import="com.engine.matfron.entity.SeriesParam" %>
<%@ page import="java.util.stream.Collectors" %>
<%@ page import="java.text.DecimalFormat" %>
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page"/>
<jsp:useBean id="bb" class="weaver.general.BaseBean" scope="page" />
<%@ page language="java" contentType="text/html; charset=UTF-8" %>

<%
    String subcompanyid1 = "62";
    JSONObject jsonObject = new JSONObject();
    OptionVO optionVO = getPortalEducational(subcompanyid1);
    jsonObject.put("data",optionVO);

%>
<%=jsonObject.toString()  %>

<%!

    public OptionVO getPortalEducational(String subcompanyid1) {


        DecimalFormat df = new DecimalFormat("#.0");
        RecordSet rs = new RecordSet();
        LinkedList<SeriesParam> seriesData = new LinkedList<>();
        LinkedList<String> nameSet = new LinkedList<>();

        String sql =" select t.xl,d.name,count(1) as sum " +
                    " from uf_jypxjl t\n" +
                    " inner join hrmresource h on h.workcode = t.ygbh\n" +
                    " left join hrmeducationlevel d on t.xl = d.id \n" +
                    " where t.xl is not null \n" +
                    " and h.status in(0,1,2,3)\n" +
                    " and (h.belongto is null or h.belongto = -1 )\n" +
                    " and h.subcompanyid1 = " + subcompanyid1 +
                    " group by t.xl,d.name " +
                    " order by t.xl desc " ;

        rs.executeQuery(sql);
        while (rs.next()) {
            String name = Util.formatMultiLang (Util.null2String(rs.getString("name")));
            seriesData.add(SeriesParam.builder().value(Util.getDoubleValue(rs.getString("sum"))).name(name).build());
            nameSet.add(name);
        }

        // double percentage = seriesData.stream().mapToDouble(SeriesParam::getValue).sum();
        // seriesData.forEach(item -> item.setValue(Double.valueOf(df.format((item.getValue() * 100) / percentage))));

//        LinkedList<String> legendDataFirst = new LinkedList<>();
//        if (nameSet.size() > 2) {
//            legendDataFirst = treeSetSplitExample(nameSet);
//        }

        return OptionVO.builder()
                .titleText("学历分析")
                .legendDataFirst(nameSet)
//                .legendDataTwo(nameSet)
                .seriesData(seriesData)
                .build();
    }

%>


<%!
    /**
     * 平分legendData
     * @param nameSet
     */
    private LinkedList<String> treeSetSplitExample(LinkedList<String> nameSet) {
        int splitSize = nameSet.size() / 2;
        LinkedList<String> legendDataFirst = nameSet.stream()
                .collect(Collectors.partitioningBy(e -> nameSet.indexOf(e) < splitSize,
                        Collectors.toCollection(LinkedList::new)))
                .get(false);
        nameSet.removeAll(legendDataFirst);
        return legendDataFirst;
    }


%>