springboot框架调取百度api获取节假日期,并获取某年某月的工作日天数(除去国家法定节假日)

萨瓦迪卡3年前java技术2340

统计考勤的业务需求,写了一个接口,将一年的节假日保存入库,以便获取某月的工作日天数的时候,可以去掉节假日,加上是工作日的周六周天日。精准的获取某月的应到天数。该接口是将假期保存入库。状态为1的是放假日,状态为2的是工作日。

image.png

@RestController
public class HolidayController {
    @Autowired
    private IHolidayService iHolidayService;
    static String BAIDU_URL = "http://opendata.baidu.com/api.php?resource_id=6018&format=json&query=";
    @PostMapping("/saveHoliday")
    @ResponseBody
    public ResultData saveHoliday(@RequestParam(value = "month",required = false) String month) throws ParseException {
//        System.out.println("holidayExist==="+ WorkDayUtils.getWorkDay());
        int a = 0;
        SimpleDateFormat format = new SimpleDateFormat("yyyy-M-d");
        SimpleDateFormat format1 = new SimpleDateFormat("yyyy-MM-dd");
        List<String> list = new ArrayList<String>();
        //String month = "2020-10";
        Map<String,Object> map = new HashMap<String,Object>();
        String responseStr = "";
        try{
            responseStr = HttpUtil.post(BAIDU_URL+month,map);
        }catch (Exception e){
            e.printStackTrace();
           // throw new Exception("第三方接口异常");
        }
//        JSONObject objects = JSONObject.fromObject(responseStr);
        com.alibaba.fastjson.JSONObject jsonTokenStr = JSON.parseObject(responseStr);
//        System.out.println("responseStr"+JSON.toJSONString(jsonTokenStr));
        if(jsonTokenStr.getString("status").equalsIgnoreCase("0")){
            JSONArray data = jsonTokenStr.getJSONArray("data");
            System.out.println("data"+data);
            if(data.size()>0){
                JSONObject item = data.getJSONObject(0);
                JSONArray holiday = item.getJSONArray("holiday");
                System.out.println("holiday"+holiday);
                if(holiday.size()>0){
                    for(int i = 0 ; i < holiday.size(); i ++){
                        JSONObject h = holiday.getJSONObject(i);
                        JSONArray hh = h.getJSONArray("list");
                        if(hh.size()>0){
                            for(int j = 0; j < hh.size(); j++){
                                JSONObject hhh = hh.getJSONObject(j);
                                String dateStr = hhh.getString("date");
                                dateStr = format1.format(format.parse(dateStr));
//                                if(hhh.getString("status").equals("1")){
//                                    list.add(dateStr);
//                                }
                                Holiday holidays = new Holiday();
                                holidays.setDate(dateStr);
                                List<Holiday>  holidayExist = iHolidayService.selectHolidayList(holidays);
                                System.out.println("holidayExist==="+holidayExist);
                                if(holidayExist.size()==0){//已经有数据
                                    Holiday holiday1 = new Holiday();
                                    holiday1.setDate(dateStr);
                                    holiday1.setWorkstate(hhh.getString("status"));
                                    holiday1.setValid("Y");
                                   a= iHolidayService.insertHoliday(holiday1);
                                }

                            }
                        }
                    }

                }
            }
        }
        return ResultData.toresult(a);
    }
}
百度接口地址http://opendata.baidu.com/api.php?resource_id=6018&format=json&query=2020-12 返回的数据格式为:
:

 {
    "status": "0",
    "t": "",
    "set_cache_time": "",
    "data": [
        {
            "StdStg": 6018,
            "StdStl": 8,
            "_update_time": "1580102250",
            "cambrian_appid": "0",
            "almanac": [
                {
                    "avoid": "栽种.破土.置产.祭祀.嫁娶.动土.作灶.祈福.",
                    "date": "2020-12-1",
                    "suit": "开市.交易.立券.挂匾.纳财.开光.出行.入宅.移徙.安床.纳畜.入殓.移柩.安葬."
                },
                {
                    "avoid": "",
                    "date": "2020-12-2",
                    "suit": "嫁娶.祭祀.祈福.求嗣.开光.出行.解除.出火.出行.拆卸.进人口.入宅.移徙.安床.栽种.动土.修造.纳畜.入殓.安葬.立碑.除服.成服."
                },
                {
                    "avoid": "嫁娶.开市.出火.栽种.破土.动土.入宅.移徙.安香.分居.掘井.作灶.",
                    "date": "2020-12-3",
                    "suit": "开光.解除.拆卸.修造.动土.安床.纳畜.安葬.启攒.入殓."
                },
                {
                    "avoid": "诸事不宜.",
                    "date": "2020-12-4",
                    "suit": "破屋.坏垣.余事勿取."
                },
                {
                    "avoid": "探病.安葬.",
                    "date": "2020-12-5",
                    "suit": "嫁娶.祭祀.开光.出火.出行.拆卸.修造.动土.解除.开市.交易.立券.挂匾.纳财.入宅.移徙.安床.栽种.纳畜."
                },
                {
                    "avoid": "入宅.作灶.词讼.移徙.出行.赴任.",
                    "date": "2020-12-6",
                    "suit": "祭祀.祈福.求嗣.开光.解除.理发.会亲友.栽种.纳畜.牧养.安葬.修坟.立碑.启攒."
                },
                {
                    "avoid": "嫁娶.动土.安床.造桥.掘井.",
                    "date": "2020-12-7",
                    "suit": "纳采.订盟.移徙.入宅.出行.安机械.会亲友.祭祀.祈福.斋醮.开光.安香.出火.解除.求医.针灸.治病.造屋.起基.修造.安门.造船.纳畜.牧养.移柩.入殓.启攒.谢土.修坟.立碑."
                },
                {
                    "avoid": "开市.斋醮.破土.安葬.",
                    "date": "2020-12-8",
                    "suit": "祭祀.沐浴.作灶.纳财.捕捉.畋猎.安床.扫舍."
                },
                {
                    "avoid": "移徙.开市.入宅.安葬.",
                    "date": "2020-12-9",
                    "suit": "祈福.斋醮.纳采.订盟.解除.架马.开柱眼.修造.动土.起基.上梁.归岫.造屋.合脊.掘井.除服.成服.破土.栽种."
                },
                {
                    "avoid": "嫁娶.祈福.开光.掘井.安葬.行丧.",
                    "date": "2020-12-10",
                    "suit": "纳采.订盟.祭祀.沐浴.冠笄.合帐.裁衣.修造.动土.拆卸.移徙.入宅.安门.开仓.筑堤.作厕.栽种.纳畜.补垣.塞穴."
                },
                {
                    "avoid": "入宅.动土.破土.嫁娶.作灶.造船.",
                    "date": "2020-12-11",
                    "suit": "合帐.裁衣.教牛马.余事勿取."
                },
                {
                    "avoid": "斋醮.作梁.掘井.行丧.安葬.",
                    "date": "2020-12-12",
                    "suit": "纳采.订盟.嫁娶.祭祀.祈福.安香.出火.出行.会亲友.经络.求医.治病.解除.拆卸.起基.修造.动土.定磉.扫舍.栽种.牧养.造畜椆栖."
                },
                {
                    "avoid": "嫁娶.祈福.出火.移徙.入宅.",
                    "date": "2020-12-13",
                    "suit": "纳财.开市.交易.立券.会亲友.进人口.经络.祭祀.祈福.安香.出火.求医.治病.修造.动土.拆卸.扫舍.安床.栽种.牧养.开生坟.合寿木.入殓.安葬.启攒."
                },
                {
                    "avoid": "入宅.修造.动土.破土.安门.上梁.",
                    "date": "2020-12-14",
                    "suit": "祭祀.入殓.移柩.余事勿取."
                },
                {
                    "avoid": "掘井.伐木.斋醮.作灶.",
                    "date": "2020-12-15",
                    "suit": "塑绘.开光.订盟.纳采.裁衣.冠笄.拆卸.修造.安床.入宅.出火.安葬.谢土.赴任."
                },
                {
                    "avoid": "出行.安葬.修坟.开市.",
                    "date": "2020-12-16",
                    "suit": "祭祀.塑绘.开光.裁衣.冠笄.嫁娶.纳采.拆卸.修造.动土.竖柱.上梁.安床.移徙.入宅.安香.结网.捕捉.畋猎.伐木.进人口.放水."
                },
                {
                    "avoid": "诸事不宜.",
                    "date": "2020-12-17",
                    "suit": "祭祀.求医.破屋.坏垣.余事勿取."
                },
                {
                    "avoid": "开光.栽种.治病.安门.作灶.",
                    "date": "2020-12-18",
                    "suit": "祭祀.祈福.斋醮.出行.冠笄.安机械.移徙.入宅.安香.安床.除服.成服.移柩.启攒."
                },
                {
                    "avoid": "",
                    "date": "2020-12-19",
                    "suit": "塑绘.斋醮.出行.拆卸.解除.修造.移徙.造船.入殓.除服.成服.移柩.启攒.修坟.立碑.谢土."
                },
                {
                    "avoid": "开市.破土.",
                    "date": "2020-12-20",
                    "suit": "祭祀.沐浴.安床.纳财.畋猎.捕捉."
                },
                {
                    "avoid": "嫁娶.作灶.",
                    "date": "2020-12-21",
                    "suit": "订盟.纳采.祭祀.祈福.修造.动土.上梁.破土."
                },
                {
                    "avoid": "入宅.安葬.",
                    "date": "2020-12-22",
                    "suit": "出行.沐浴.理发.补垣.塞穴."
                },
                {
                    "avoid": "入宅.动土.破土.余事勿取.",
                    "date": "2020-12-23",
                    "suit": "教牛马.余事勿取."
                },
                {
                    "avoid": "开市.安葬.",
                    "date": "2020-12-24",
                    "suit": "嫁娶.出行.求医.治病.祭祀.祈福.上梁.纳畜."
                },
                {
                    "avoid": "嫁娶.祈福.",
                    "date": "2020-12-25",
                    "suit": "开市.立券.开光.解除.安机械.上梁.启攒.安葬."
                },
                {
                    "avoid": "诸事不宜.",
                    "date": "2020-12-26",
                    "suit": "平治道涂.余事勿取."
                },
                {
                    "avoid": "开市.嫁娶.",
                    "date": "2020-12-27",
                    "suit": "求嗣.斋醮.塑绘.订盟.纳采.出火.拆卸.修造.动土.造桥.安机械.栽种.纳畜.牧养.入殓.除服.成服.移柩.破土.安葬."
                },
                {
                    "avoid": "开市.安葬.",
                    "date": "2020-12-28",
                    "suit": "嫁娶.订盟.纳采.祭祀.祈福.修造.动土.移徙.入宅."
                },
                {
                    "avoid": "诸事不宜.",
                    "date": "2020-12-29",
                    "suit": "治病.破屋.坏垣.余事勿取."
                },
                {
                    "avoid": "造桥.安门.理发.造庙.栽种.作灶.",
                    "date": "2020-12-30",
                    "suit": "祭祀.祈福.求嗣.斋醮.开光.入学.订盟.冠笄.伐木.修造.动土.起基.放水.交易.开池."
                },
                {
                    "avoid": "诸事不宜.",
                    "date": "2020-12-31",
                    "suit": "解除.坏垣.余事勿取."
                }
            ],
            "holiday": [
                {
                    "desc": "1月1日放假一天",
                    "festival": "2020-1-1",
                    "list": [
                        {
                            "date": "2020-1-1",
                            "status": "1"
                        }
                    ],
                    "list#num#baidu": 1,
                    "name": "元旦",
                    "rest": "2019年12月30日和2019年12月31日请假两天,与周末连休可拼5天小长假。"
                },
                {
                    "desc": "1月24日放假一天",
                    "festival": "2020-1-24",
                    "list": [
                        {
                            "date": "2020-1-24",
                            "status": "1"
                        }
                    ],
                    "list#num#baidu": 1,
                    "name": "除夕",
                    "rest": "农历腊月最后一天为除夕,即大年初一前夜,又称为年三十。"
                },
                {
                    "desc": "1月24日(除夕)至1月30日放假7天,1月19日,2月1日上班",
                    "festival": "2020-1-25",
                    "list": [
                        {
                            "date": "2020-1-24",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-25",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-26",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-27",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-28",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-29",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-30",
                            "status": "1"
                        },
                        {
                            "date": "2020-1-19",
                            "status": "2"
                        },
                        {
                            "date": "2020-1-31",
                            "status": "1"
                        },
                        {
                            "date": "2020-2-1",
                            "status": "1"
                        },
                        {
                            "date": "2020-2-2",
                            "status": "1"
                        }
                    ],
                    "list#num#baidu": 11,
                    "name": "春节",
                    "rest": "2020年1月19日至2020年1月23日请假5天,与周末连休可拼13天长假。"
                },
                {
                    "desc": "4月4日至4月6日放假3天",
                    "festival": "2020-4-4",
                    "list": [
                        {
                            "date": "2020-4-4",
                            "status": "1"
                        },
                        {
                            "date": "2020-4-5",
                            "status": "1"
                        },
                        {
                            "date": "2020-4-6",
                            "status": "1"
                        }
                    ],
                    "list#num#baidu": 3,
                    "name": "清明节",
                    "rest": "2020年4月7日至2020年4月10日请假4天,与周末连休可拼9天长假。"
                },
                {
                    "desc": "5月1日至5月5日放假5天,4月26日,5月9日上班",
                    "festival": "2020-5-1",
                    "list": [
                        {
                            "date": "2020-5-1",
                            "status": "1"
                        },
                        {
                            "date": "2020-5-2",
                            "status": "1"
                        },
                        {
                            "date": "2020-5-3",
                            "status": "1"
                        },
                        {
                            "date": "2020-5-4",
                            "status": "1"
                        },
                        {
                            "date": "2020-5-5",
                            "status": "1"
                        },
                        {
                            "date": "2020-4-26",
                            "status": "2"
                        },
                        {
                            "date": "2020-5-9",
                            "status": "2"
                        }
                    ],
                    "list#num#baidu": 7,
                    "name": "劳动节",
                    "rest": "2020年4月26日至2020年4月30日请假5天,与周末连休可拼11天长假。"
                },
                {
                    "desc": "6月25日至6月27日放假3天,6月28日上班",
                    "festival": "2020-6-25",
                    "list": [
                        {
                            "date": "2020-6-25",
                            "status": "1"
                        },
                        {
                            "date": "2020-6-26",
                            "status": "1"
                        },
                        {
                            "date": "2020-6-27",
                            "status": "1"
                        },
                        {
                            "date": "2020-6-28",
                            "status": "2"
                        }
                    ],
                    "list#num#baidu": 4,
                    "name": "端午节",
                    "rest": "2020年6月22日至2020年6月24日请假3天,与周末连休可拼8天长假。"
                },
                {
                    "desc": "10月1日至10月8日放假8天,9月27日,10月10日上班",
                    "festival": "2020-10-1",
                    "list": [
                        {
                            "date": "2020-10-1",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-2",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-3",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-4",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-5",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-6",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-7",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-8",
                            "status": "1"
                        },
                        {
                            "date": "2020-9-27",
                            "status": "2"
                        },
                        {
                            "date": "2020-10-10",
                            "status": "2"
                        }
                    ],
                    "list#num#baidu": 10,
                    "name": "中秋节",
                    "rest": "10月9日至10月10日请假2天,与周末连休可拼11天长假。"
                },
                {
                    "desc": "10月1日至10月8日放假8天,9月27日,10月10日上班",
                    "festival": "2020-10-1",
                    "list": [
                        {
                            "date": "2020-10-1",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-2",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-3",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-4",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-5",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-6",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-7",
                            "status": "1"
                        },
                        {
                            "date": "2020-10-8",
                            "status": "1"
                        },
                        {
                            "date": "2020-9-27",
                            "status": "2"
                        },
                        {
                            "date": "2020-10-10",
                            "status": "2"
                        }
                    ],
                    "list#num#baidu": 10,
                    "name": "国庆节",
                    "rest": "10月9日至10月10日请假2天,与周末连休可拼11天长假。"
                }
            ],
            "holidaylist": [
                {
                    "name": "元旦",
                    "startday": "2020-1-1"
                },
                {
                    "name": "除夕",
                    "startday": "2020-1-24"
                },
                {
                    "name": "春节",
                    "startday": "2020-1-25"
                },
                {
                    "name": "清明节",
                    "startday": "2020-4-4"
                },
                {
                    "name": "劳动节",
                    "startday": "2020-5-1"
                },
                {
                    "name": "端午节",
                    "startday": "2020-6-25"
                },
                {
                    "name": "中秋节",
                    "startday": "2020-10-1"
                },
                {
                    "name": "国庆节",
                    "startday": "2020-10-1"
                }
            ],
            "key": "2020年12月",
            "selectday": "2020-12-1",
            "url": "http://nourl.baidu.com/6018",
            "loc": "http://open.baidu.com/q?r=2002753&k=2020%E5%B9%B412%E6%9C%88",
            "SiteId": 2002753,
            "_version": 2767,
            "_select_time": 1580102077,
            "clicklimit": "1-3",
            "ExtendedLocation": "",
            "OriginQuery": "2020-12",
            "tplt": "calendar_new",
            "resourceid": "6018",
            "fetchkey": "6018_2020年12月",
            "role_id": 10,
            "disp_type": 0,
            "appinfo": ""
        }
    ]
}
  然后通过公共方法获取某月工作日的天数
  
      // 返回工作日集合,只排除周末
    public static List<Date> getWorkDays(int year, int month){
        // 用于储存每月工作日
        List<Date> dates = new ArrayList<Date>();

        Calendar cal = Calendar.getInstance();
        //设置月份
        cal.set(Calendar.YEAR, year);
        // 设置月份
        cal.set(Calendar.MONTH, month - 1);
        // 设置为当月第一天
        cal.set(Calendar.DATE, 1);


        while(cal.get(Calendar.YEAR) == year && cal.get(Calendar.MONTH) < month){
            // 判断当前天为本周的第几天
            int day = cal.get(Calendar.DAY_OF_WEEK);
            // 如果不为周六或者周天,将日期进行储存
            if(!(day == Calendar.SUNDAY || day == Calendar.SATURDAY)){
                dates.add((Date)cal.getTime().clone());
            }
            // 将当前日期增加一天
            cal.add(Calendar.DATE, 1);
        }
        // 返回当前月工作日集合
        return dates;


    }

    /**
     *
     * @param dateList
     * @return 返回日期字符串集合
     */
    public static List<String> getDateString(List<Date> dateList){
        // 储存日期字符串
        List<String> dateString = new ArrayList<>();
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");

        for (Date date : dateList){
            String date2 = simpleDateFormat.format(date);
            dateString.add(date2);

        }
        return dateString;
    }
    public  static int  getWorkDay(String month){
        List<Date> workDays = getWorkDays(Integer.parseInt(month.split("-")[0]), Integer.parseInt(month.split("-")[1]));
        // 获取工作日字符串集合
        List<String> dateString = getDateString(workDays);
        // 获取法定节假日集合
        List list =   staticMapper.selectHolidayByDate(month);
        System.out.println("list==="+list.size());
        List holidayList= new ArrayList();
        List workdayList= new ArrayList();
        for(int i =0;i<list.size();i++){
           Holiday holiday11 = (Holiday) list.get(i);
           if(holiday11.getWorkstate().equals("1")){
               holidayList.add(holiday11.getDate());
           }else if(holiday11.getWorkstate().equals("2")){
               workdayList.add(holiday11.getDate());
           }
        }
//             List<String> holidays = HolidayUtils.getList(month);
        // System.out.println("holidays==="+holidays);
        // 从工作日中除去法定节假日
        dateString.removeAll(holidayList);
        // 从工作日中增加周六日工作日
        dateString.addAll(workdayList);
        System.out.println(dateString.size());
        // 遍历纯工作日集合
        for (String date : dateString){
            System.out.println(date);
        }
        return dateString.size();
    }

相关文章

使用命令将本地项目上传至git

使用命令将本地项目上传至git

1.新建仓库,并获取git地址。2.找到本地的项目所在文件夹,鼠标右键git bash here,进入命令窗口。3.依次输入一下命令:git init      &nbs...

js/jquery 实现点击图片更换头像(图片)实例

    总之一句话, 可以先将 file类型 的input 隐藏 起来,通过 图片(头像)的onclick事件 来触发 file 的onclick事件。1.引入外部js:...

函数date_format(timestamp without time zone,unknow)不存在,没有匹配指定名称和参数类型的函数,您也许需要增加明确的类型转换

函数date_format(timestamp without time zone,unknow)不存在,没有匹配指定名称和参数类型的函数,您也许需要增加明确的类型转换

瀚高库报错:执行以下语句即可:CREATE OR REPLACE FUNCTION date_format(indate TIMESTAMP,&nbs...

springboot框架 后台获取微信小程序用户的openid

小程序端app.js中:// 登录     wx.login({       succ...

MyEclipse 中项目修改SVN的地址

MyEclipse 中项目修改SVN的地址

在工作环境调整时,有的时候SVN服务器的地址需要修改,而正在开发中的项目在Eclipse中有些代码没有提交,此时怎么修改SVN的地址呢?以下有一个简单的办法:一、在MyEclipse中选择Window...

 程序员的中秋礼物.......

程序员的中秋礼物.......

【小姐你好,我是程序员】“小姐你好,我是程序员。”女生礼貌地回答:“你好,程先生。”男:“……哦,叫我序员就可以了。”   【程序员的愿望】有一天一个程序员见到了上帝。上...

发表评论    

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。