Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //SUPONDO QUE VOCÊ ESTÁ NO MODEL QUE EXTENDE A DBTABLE
- //ENTÃO VOCÊ TEM NO OBJETO A SELECT
- $ts_duracao = new Zend_Db_Expr('(SELECT dur.ts_cadastro
- FROM tb_ticket_historico dur
- WHERE th.cd_historico < dur.cd_historico
- AND th.cd_ticket = dur.cd_ticket
- LIMIT 1) - th.ts_cadastro');
- $where = $this->select()->setIntegrityCheck(false)
- ->from(array('th' => 'tb_ticket_historico'),
- array('*', 'ts_duracao' => $ts_duracao))
- ->order(array('tt.cd_ticket DESC', 'th.cd_historico ASC'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement