万年历/节假日/日历API

HezhezhiyuLe

已于 2022-03-25 10:09:02 修改

阅读量1.1w

点赞数 4

分类专栏： Tool 后端文章标签：日历节假日

于 2021-05-13 11:05:25 首次发布

本文链接：https://blog.csdn.net/HezhezhiyuLe/article/details/116740272

版权

后端同时被 2 个专栏收录

52 篇文章

订阅专栏

Tool

20 篇文章

订阅专栏

本文介绍了一个稳定、高效且准确的节假日API，并提供了详细的调用示例与数据解析方法，帮助开发者实现节假日及其放假安排的查询功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前言

业务需求，需要判断节假日。
简单来说，我们有一个节假日日历即可解决，但是市面上百度小米华为都有自己的日历但是就是没有API，我的需求是找一个稳定，高效，准确的日历
以下调用均为CURL调用，官方支持SDK调用，考虑到成本，使用CURL
我是为了加班费计算（节假日、补班）需要用到节假日的，有相同需求的可以看这篇

预期

在这里插入图片描述

开发

日历类总链接，有三个API
根据自己的需求用对应的API，我要知道节假日及其放假安排，所以调用第二个接口

参考链接

 https://www.kancloud.cn/topthink-doc/think-api/1861639

调用须知

调用前要登陆获取登陆密钥 AppCode

https://docs.topthink.com/think-api/1835086

1、查询当天详细信息

接口

GET https://api.topthink.com/calendar/day

调用

https://api.topthink.com/calendar/day?appCode=写自己的&date=2021-5-1

响应

{
    "code": 0,
    "message": "Success",
    "data": {
        "animalsYear": "牛",
        "weekday": "星期六",
        "lunarYear": "辛丑年",
        "lunar": "三月二十",
        "year-month": "2021-5",
        "date": "2021-5-1",
        "suit": "结婚.领证.订婚.求嗣.修坟.赴任.祈福.祭祀.纳畜.启钻.捕捉.嫁娶.纳采.盖屋.栽种.斋醮.招赘.纳婿.藏宝",
        "avoid": "搬家.装修.开业.入宅.开工.动土.出行.安葬.上梁.开张.旅游.破土.修造.开市.纳财.移徙.立券.竖柱.放水.分居.行丧.开仓.置产.筑堤.出货",
        "holiday": "劳动节",
        "desc": "5月1日至5日放假调休，共5天。4月25日（星期日）、5月8日（星期六）上班"
    }
}

2、根据传入的月份返回近期的假期列表

接口

POST https://api.topthink.com/calendar/month

调用

{
    "yearMonth":"2021-5"
}

响应

接口查询一个月会返回两个月数据
观察了下发现"status": "1"是放假 "status": "2"是工作日（补班）

{
    "code": 0,
    "message": "Success",
    "data": {
        "year": "2021",
        "year-month": "2021-5",
        "holiday": "[{\"desc\":\"4月3日至5日放假调休，共3天\",\"festival\":\"2021-4-4\",\"list\":[{\"date\":\"2021-4-3\",\"status\":\"1\"},{\"date\":\"2021-4-4\",\"status\":\"1\"},{\"date\":\"2021-4-5\",\"status\":\"1\"}],\"list#num#\":3,\"name\":\"清明节\",\"rest\":\"\"},{\"desc\":\"5月1日至5日放假调休，共5天。4月25日（星期日）、5月8日（星期六）上班\",\"festival\":\"2021-5-1\",\"list\":[{\"date\":\"2021-5-1\",\"status\":\"1\"},{\"date\":\"2021-5-2\",\"status\":\"1\"},{\"date\":\"2021-5-3\",\"status\":\"1\"},{\"date\":\"2021-5-4\",\"status\":\"1\"},{\"date\":\"2021-5-5\",\"status\":\"1\"},{\"date\":\"2021-4-25\",\"status\":\"2\"},{\"date\":\"2021-5-8\",\"status\":\"2\"}],\"list#num#\":7,\"name\":\"劳动节\",\"rest\":\"\"},{\"desc\":\"6月12日至14日放假，共3天\",\"festival\":\"2021-6-14\",\"list\":[{\"date\":\"2021-6-12\",\"status\":\"1\"},{\"date\":\"2021-6-13\",\"status\":\"1\"},{\"date\":\"2021-6-14\",\"status\":\"1\"}],\"list#num#\":3,\"name\":\"端午节\",\"rest\":\"\"}]",
        "holiday_array": [
            {
                "desc": "4月3日至5日放假调休，共3天",
                "festival": "2021-4-4",
                "list": [
                    {
                        "date": "2021-4-3",
                        "status": "1"
                    },
                    {
                        "date": "2021-4-4",
                        "status": "1"
                    },
                    {
                        "date": "2021-4-5",
                        "status": "1"
                    }
                ],
                "list#num#": 3,
                "name": "清明节",
                "rest": "",
                "list_num": 3
            },
            {
                "desc": "5月1日至5日放假调休，共5天。4月25日（星期日）、5月8日（星期六）上班",
                "festival": "2021-5-1",
                "list": [
                    {
                        "date": "2021-5-1",
                        "status": "1"
                    },
                    {
                        "date": "2021-5-2",
                        "status": "1"
                    },
                    {
                        "date": "2021-5-3",
                        "status": "1"
                    },
                    {
                        "date": "2021-5-4",
                        "status": "1"
                    },
                    {
                        "date": "2021-5-5",
                        "status": "1"
                    },
                    {
                        "date": "2021-4-25",
                        "status": "2"
                    },
                    {
                        "date": "2021-5-8",
                        "status": "2"
                    }
                ],
                "list#num#": 7,
                "name": "劳动节",
                "rest": "",
                "list_num": 7
            },
            {
                "desc": "6月12日至14日放假，共3天",
                "festival": "2021-6-14",
                "list": [
                    {
                        "date": "2021-6-12",
                        "status": "1"
                    },
                    {
                        "date": "2021-6-13",
                        "status": "1"
                    },
                    {
                        "date": "2021-6-14",
                        "status": "1"
                    }
                ],
                "list#num#": 3,
                "name": "端午节",
                "rest": "",
                "list_num": 3
            }
        ]
    }
}

3、根据传入年份返回当年假期列表

接口

此接口只能查询节假日具体那一天，不可以查看具体放几天，以及补班

POST https://api.topthink.com/calendar/year

调用

{
    "year":"2021"
}

响应

{
    "code": 0,
    "message": "Success",
    "data": {
        "year": "2021",
        "holidaylist": "[{\"name\":\"元旦\",\"startday\":\"2021-1-1\"},{\"name\":\"除夕\",\"startday\":\"2021-2-11\"},{\"name\":\"春节\",\"startday\":\"2021-2-12\"},{\"name\":\"清明节\",\"startday\":\"2021-4-4\"},{\"name\":\"劳动节\",\"startday\":\"2021-5-1\"},{\"name\":\"端午节\",\"startday\":\"2021-6-14\"},{\"name\":\"中秋节\",\"startday\":\"2021-9-21\"},{\"name\":\"国庆节\",\"startday\":\"2021-10-1\"}]",
        "holiday_list": [
            {
                "name": "元旦",
                "startday": "2021-1-1"
            },
            {
                "name": "除夕",
                "startday": "2021-2-11"
            },
            {
                "name": "春节",
                "startday": "2021-2-12"
            },
            {
                "name": "清明节",
                "startday": "2021-4-4"
            },
            {
                "name": "劳动节",
                "startday": "2021-5-1"
            },
            {
                "name": "端午节",
                "startday": "2021-6-14"
            },
            {
                "name": "中秋节",
                "startday": "2021-9-21"
            },
            {
                "name": "国庆节",
                "startday": "2021-10-1"
            }
        ]
    }
}

解析

拿到数据，我们把需要的节假日工作日可以存储在数据库中

1、SQL

create table holiday_array
(
    holiday_date date          not null comment '节假日准确日期' primary key,
    `desc`       varchar(256)  null comment '节假日备注',
    status       int default 1 not null comment '是否为工作日（补班）'
)
    comment '节假日数组';

2、Bean

@Table(name = "holiday_array")
public class Holiday {
    @Id
    private Date holidayDate;
    private String desc;
    private Integer status;

    public Date getHolidayDate() {
        return holidayDate;
    }

    public void setHolidayDate(Date holidayDate) {
        this.holidayDate = holidayDate;
    }

    public String getDesc() {
        return desc;
    }

    public void setDesc(String desc) {
        this.desc = desc;
    }

    public Integer getStatus() {
        return status;
    }

    public void setStatus(Integer status) {
        this.status = status;
    }
}

3、mapper

 @Repository
public interface HolidayArrayMapper extends Mapper<Holiday> {

    //区间查询
    @Select("select count(1) form holiday_array where holiday_date between #{start}  and #{end} ")
    int findHolidayByDate(@Param("start") String start,@Param("end") String end);
    //单日查询
    @Select("select count(1) from holiday_array where holiday_date =#{date} ")
    int findHolidayByDate2(@Param("date") String date);
    //单日查询 当天是否为节假日
    @Select("select status from holiday_array where holiday_date =#{date}")
    Integer findHolidayByDate3(@Param("date") String date);
    //批量插入
    @Insert({
            "<script>",
            "insert into holiday_array(holiday_date,`desc`,status) values ",
            "<foreach collection='recordList' item='item' index='index' separator=','>",
            "(#{item.holidayDate}, #{item.desc}, #{item.status})"+ "</foreach>",
            "</script>"
    })
    int insertHoliday(@Param("recordList") List<Holiday> recordList );

}

4、响应体解析

	//存储库
    @Autowired
    private HolidayArrayMapper holidayArrayMapper;
    //使用spring自带模板发送 需要代理的可以看https://blog.csdn.net/HezhezhiyuLe/article/details/112177771
    @Autowired
    private RestTemplate restTemplate;
    /**
     * 每月更新节假日 每月一号执行
     */
    @Scheduled(cron = "0 0 2 1 * ? *")
    public void holiday(){
        String ny = DateUtil.getNY();
        Map<String, String> map = new HashMap<>();
        map.put("yearMonth",ny);
        List<Holiday> holidays = new ArrayList<>();
        try {
            HttpHeaders headers = new HttpHeaders();
            headers.set("Authorization", appCode);
            HttpEntity<Map> requestEntity = new HttpEntity<>(map, headers);
            String post =restTemplate.postForEntity(holidayUrl,requestEntity,String.class).getBody();
            if(!IFNull.strNotNull(post)||!post.contains("\"code\":0")){
                return;
            }
            map.clear();
            JSONObject holidayJson = JSON.parseObject(post);
            JSONObject data = holidayJson.getJSONObject("data");
            List<JSONObject> holiday_array = JSON.parseArray(data.getString("holiday_array"), JSONObject.class);
            for (JSONObject holiday : holiday_array) {
                List<JSONObject> list = JSON.parseArray(holiday.getString("list"), JSONObject.class);
                for (JSONObject jsonObject : list) {
                    String date = jsonObject.getString("date");
                    String status = jsonObject.getString("status");
                    Holiday holiday1 = new Holiday();
                    if("1".equals(status)){
                        //节假日日期：名称
                        holiday1.setHolidayDate(DateUtil.parseDate(date));
                        holiday1.setDesc(holiday.getString("name"));
                        holiday1.setStatus(1);
                    }else {
                        //调休工作日时间：备注
                        holiday1.setHolidayDate(DateUtil.parseDate(date));
                        holiday1.setDesc(holiday.getString("desc"));
                        holiday1.setStatus(2);

                    }
                    int holidayByDate = holidayArrayMapper.findHolidayByDate2(date);
                    if(holidayByDate==0){
                        holidays.add(holiday1);
                    }else {
                        System.out.println("重复节假日"+holiday1);
                    }
                }
            }
         } catch (Exception e) {
            e.printStackTrace();
            return;
        }
        //存储
        if(holidays.size()>0){
            int i = holidayArrayMapper.insertHoliday(holidays);
            System.out.println(i);
        }

    }