ตั้งค่าวันหยุด HosXP

INSERT INTO oapp_limit(oapp_limit_id,oapp_date,oapp_clinic,oapp_limit,start_time,end_time,check_time)
select get_serialnumber('oapp_limit_id'),DATE('2025-04-21') + INTERVAL seq DAY AS calendar_date,"014" ,1,cast("06:30:00" as time),cast("16:00:00"as time),"Y"
FROM (
  SELECT a + b * 10 + c * 100 AS seq
  FROM
    (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
     UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS ones,
    (SELECT 0 AS b UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
     UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS tens,
    (SELECT 0 AS c UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) AS hundreds
) AS days
WHERE DATE('2025-04-21') + INTERVAL seq DAY <= '2026-04-21'
  AND DAYOFWEEK(DATE('2025-04-21') + INTERVAL seq DAY) not IN (4)
ORDER BY calendar_date