Tiger任务管理系统-8

完成的任务的表格设计

完成了任务的主页总接口开发

复习前端的知识，好久没碰前端了，生疏了

不玩虚的整干货，贴一段SQL

SELECT
COUNT(IF(overdue_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), ' 00:00:00')
AND overdue_time > CONCAT(CURDATE(), ' 00:00:00')
AND status = 'open', TRUE, NULL)) AS count_today_due_task,
COUNT(IF(overdue_time < CONCAT(CURDATE(), ' 00:00:00')
AND status = 'open', TRUE, NULL)) AS count_overdue_task,
COUNT(IF(overdue_time > CONCAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), ' 00:00:00')
AND status = 'open', TRUE, NULL)) AS count_pending_task,
COUNT(IF(overdue_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), ' 00:00:00')
AND overdue_time > CONCAT(CURDATE(), ' 00:00:00')
AND status = 'close', TRUE, NULL)) AS count_today_complete_task
FROM task_task_info tti

附上Tiger任务开源链接 Tiger任务管理系统源码 

上一篇：第七天 实现任务列表

下一篇：明天见