根据前端传的季度标识获取对应的月份区间,简单的树形结构查询

根据前端的标识判断对应的季度月份区间

public  Map<String, String> getQuarterStartEndTime(String quarter) {
        SimpleDateFormat formatter= new SimpleDateFormat("yyyy-MM");
        Map<String, String> result = new HashMap<>();
        Calendar start = Calendar.getInstance();
        Calendar end = Calendar.getInstance();
        try {
            if (quarter.equals("Q1")) {
                start.set(Calendar.MONTH, 0);
                start.set(Calendar.DATE,1);
                end.set(Calendar.MONTH, 2);
                end.set(Calendar.DATE, 31);
            } else if (quarter.equals("Q2")) {
                start.set(Calendar.MONTH, 3);
                start.set(Calendar.DATE,1);
                end.set(Calendar.MONTH, 5);
                end.set(Calendar.DATE, 30);
            } else if (quarter.equals("Q3")) {
                start.set(Calendar.MONTH, 6);
                start.set(Calendar.DATE,1);
                end.set(Calendar.MONTH, 8);
                end.set(Calendar.DATE, 30);
            } else if (quarter.equals("Q4")) {
                start.set(Calendar.MONTH, 9);
                start.set(Calendar.DATE,1);
                end.set(Calendar.MONTH, 11);
                end.set(Calendar.DATE, 31);
            }
            result.put("startTime", formatter.format(start.getTime()));
            result.put("endTime",formatter.format(end.getTime()));
            System.out.println(result.get("startTime"));
        } catch (Exception e) {

        }
        return result;
    }

简单的树形结构

@GetMapping("/test1")
    public JSONArray getDepartmentLevelList() {
        List<Department> departments = testMapper.getFirstDepartList();
        JSONArray departs = getLevelList(departments);
        return departs;
    }

    public JSONArray getLevelList(List<Department> departments) {
        JSONArray addChild = new JSONArray();
        for (Department department : departments) {
            JSONObject jsonMenu =JSONObject.parseObject(JSON.toJSONString(department));
            List<Department> nextDeparts = testMapper.findBySuborDepartment(department.getId());
            if (nextDeparts.size() > 0) {
                JSONArray nextChilds = getLevelList(nextDeparts);
                jsonMenu.put("departments", nextChilds);
            }
            if (nextDeparts.size() ==0)
            {
                String[] s=new String[0];
                jsonMenu.put("departments",s);
            }
            addChild.add(jsonMenu);
        }
        return addChild;
    }

mapper类

@Select(value = "select * from t_tee where pendid is null")
    List<Department> getFirstDepartList();

    /**
     * 查询该部门的下级部门
     *
     * @param
     * @return
     */
    @Select(value = "select * from t_tee  where pendid = #{pendid}")
    List<Department> findBySuborDepartment(String id);