从 zend 表中获取最近 7 天的记录 [英] Get last 7 days records from table in zend

问题描述

伙计们，我想从桌子上获取过去 7 天的封闭门票这是我写的查询

Hi guys i am trying to get last 7 days closed tickets from table Here is the query i have wrote

'closed' => new Zend_Db_Expr('SUM(IF(rt.assignee_id IS NOT NULL,IF(rt.status_id = 24,1,0),0))')

谁能帮助我如何在 IF 中添加我的条件?

can any one help me how can i add my condition inside IF?

提前致谢.

推荐答案

'closed' =>new Zend_Db_Expr('SUM(IF(rt.assignee_id IS NOT NULL, IF(rt.status_id = 24, IF(created >= CURDATE() - INTERVAL 7 DAY, 1,0),0),0))')

不是 100% 确定 CURDATE() - INTERVAL 7 DAY，但我想你会理解它.

not 100% sure about the CURDATE() - INTERVAL 7 DAY, but i think you will understand it.

这篇关于从 zend 表中获取最近 7 天的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！