辦公室常用工具
出自六年制學程
伙伴的工時計算
全日上班天列表：SELECT start,`end`-start FROM calendar WHERE type LIKE '%上班%' && user_name='○○○' && start LIKE '2024-0X-%' && `end`-start>=60000 order by start非全日上班列表：
SELECT start,`end`-start FROM calendar WHERE type LIKE '%上班%' && user_name='○○○' && start LIKE '2024-0X-%' && `end`-start<60000 order by start折算日數
SELECT sum(`end`-start)/36000 FROM calendar WHERE type LIKE '%上班%' && user_name='○○○' && start LIKE '2024-0X-%'
