Advertisement
RobsonAlexandre

Subquery com Zend_Db_Table com Zend_Db_Expr

Nov 26th, 2012
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. //SUPONDO QUE VOCÊ ESTÁ NO MODEL QUE EXTENDE A DBTABLE
  2. //ENTÃO VOCÊ TEM NO OBJETO A SELECT
  3.         $ts_duracao = new Zend_Db_Expr('(SELECT dur.ts_cadastro
  4.                            FROM tb_ticket_historico dur
  5.                            WHERE th.cd_historico < dur.cd_historico
  6.                            AND th.cd_ticket = dur.cd_ticket
  7.                            LIMIT 1) - th.ts_cadastro');
  8.         $where = $this->select()->setIntegrityCheck(false)                        
  9.                         ->from(array('th' => 'tb_ticket_historico'),
  10.                                 array('*', 'ts_duracao' => $ts_duracao))
  11.             ->order(array('tt.cd_ticket DESC', 'th.cd_historico ASC'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement