Query sql for cakephp

Question

Query sql for cakephp

Navigation

#1 by (0 votes)

1

How do I query below in cakephp?

    SELECT * 
    FROM tramitacaos
    INNER JOIN protocolos ON tramitacaos.protocolo_id = protocolos.id
    WHERE (
    protocolo_id, data_origem
    )
    IN (
    SELECT protocolo_id, MAX( data_origem ) 
    FROM tramitacaos
    WHERE unidade_origem_id =462
    GROUP BY protocolo_id
    )

php cakephp-3

asked by anonymous 05.04.2016 / 21:18

1 answer

How to create a multiple image preview via "multiple input" html? Jboss Error 09: 51: 36,559 INFO ** [Server] JBoss (MX MicroKernel)

score 0 · Accepted Answer

You can use this query using ConnectionManager

use Cake\Datasource\ConnectionManager;

$connection = ConnectionManager::get('default');
$results = $connection->execute(
    'SELECT 
        * 
    FROM tramitacaos
    INNER JOIN protocolos 
        ON tramitacaos.protocolo_id = protocolos.id
    WHERE 
        (protocolo_id, data_origem) IN 
        (
            SELECT 
                protocolo_id, 
                MAX( data_origem ) 
            FROM 
                tramitacaos
            WHERE 
                unidade_origem_id = :unidadeOrigemId
            GROUP BY protocolo_id
        )',
        ['unidadeOrigemId' => 462]
    )->fetchAll('assoc');