我有表就像这样:
p_central_ticket
================
- t_id ======> id ticket
- t_open_by ======> name that raise the ticket
- t_closed_by ======> name that closed the ticket
- t_open_time ======> open ticket time
- t_closed_time ======> closed ticket time
我应该怎么做,如果我想显示计数的所有车票关闭的名字,和关闭时间的今天,每周,每月和每年的?像这样 :
Name today weekly monthly yearly
=================================================================
test1@random.com 2 10 70 1000
test2@random.com 5 14 60 1234
样本数据 :
t_id t_open_by t_closed_by t_open_time t_closed_time
===========================================================================
1 amir@random.com test1@random.com 2018-03-28 2018-03-29
2 tiki@random.com test1@random.com 2018-04-28 2018-05-29
需要帮助的家伙...谢谢