404

D7net
:/ var / www / html / crsys_ant / adm / app / gre / Models / Medicao /
Filename : ModListarMedicaoEleger.php
back
<?php
// Models
namespace App\gre\Models\Medicao;

if (!defined('URL')) {
    header("Location: /");
    exit();
}

/**
 * Description of ModListarMedicaoEleger
 *
 * @copyright (c) year, Carlos Marques - CM
 */
class ModListarMedicaoEleger
{
   private $DadosOcor;
    private $Resultado;
   
    public function listarMedicaoEleger()
    {
        $listarMedicao = new \App\adms\Models\helper\AdmsRead();
        $listarMedicao->fullRead("SELECT 
    med.orca_id,
    med.num_revisao,
    med.num_contrato,
    MAX(CONVERT(med.obra USING utf8mb4)) AS nome_obra,
    MAX(
        CASE 
            WHEN med.complemento IS NOT NULL AND med.complemento <> '' THEN
                CONVERT(CONCAT(
                    med.endereco_obra, ', ', med.numero_obra, ' - ', med.complemento, 
                    ' - ', med.bairro, ' - ', med.municipio_obra, '/', med.uf_obra, 
                    ' - CEP: ', MASK(LPAD(med.cep_obra, 8, '0'), '#####-###')
                ) USING utf8mb4)
            ELSE
                CONVERT(CONCAT(
                    med.endereco_obra, ', ', med.numero_obra, ' - ', med.bairro, 
                    ' - ', med.municipio_obra, '/', med.uf_obra, 
                    ' - CEP: ', MASK(LPAD(med.cep_obra, 8, '0'), '#####-###')
                ) USING utf8mb4)
        END
    ) AS endereco,
    MAX(CONVERT(med.contato_obra USING utf8mb4)) AS nome_contato,
    MAX(CONVERT(v.nome USING utf8mb4)) AS nome_vend,
    MAX(CONVERT(ag.observacao USING utf8mb4)) AS observacao,
    DATE_FORMAT(med.data_agenda_medicao, '%Y-%m-%d') AS data_agendam,
    MAX(med.data_agenda_medicao) AS data_agenda,
    DATE_FORMAT(MAX(med.data_limite_liberar), '%Y-%m-%d') AS data_limite,
    DATE_FORMAT(MAX(med.data_limite_liberar), '%d/%m/%Y') AS data_limitem,
    case when length(med.telefone_obra) < 11 then
        MAX(MASK(LPAD(med.telefone_obra,10,'0'),'(##) ####-####')) 
    else
        MAX(MASK(LPAD(med.telefone_obra,11,'0'),'(##) #####-####'))  
    end
    AS tel_obra,
    case when length(med.tel_vend) < 11 then
        MAX(MASK(LPAD(med.tel_vend,10,'0'),'(##) ####-####')) 
    else
         MAX(MASK(LPAD(med.tel_vend,11,'0'),'(##) #####-####')) 
    end    
    AS tel_vend,
    DATE_FORMAT(MAX(med.data_agenda_medicao), '%d/%m/%Y %H:%i') AS data_agendamento,
    MAX(med.status_id) AS status_id,
    MAX(CONVERT(med.nome_cliente USING utf8mb4)) AS nome_cliente,
    MAX(CONVERT(sit.nome USING utf8mb4)) AS nome_sit,
    MAX(CONVERT(cr.cor USING utf8mb4)) AS cor_cr
FROM gre_cab_orcamento med
LEFT JOIN gre_agenda ag
    ON ag.empr_id = med.empr_id
    AND ag.num_contrato = med.num_contrato
INNER JOIN adms_usuarios v
    ON v.id = med.vend
INNER JOIN gre_status sit
    ON sit.id = med.status_id
INNER JOIN adms_cors cr
    ON cr.id = sit.cor_id
WHERE med.status_id IN (8)
GROUP BY DATE_FORMAT(med.data_agenda_medicao, '%Y-%m-%d')
ORDER BY data_limite DESC;");
        $this->Resultado = $listarMedicao->getResultado();
//       var_dump($this->Resultado);
//       die;
        return $this->Resultado;
    }
}