404

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

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

/**
 * Description of ModListarMedicaoAgendar
 *
 * @copyright (c) year, Carlos Marques - CM
 */
class ModListarMedicaoAgendar
{
   private $DadosOcor;
    private $Resultado;
   
    public function listarMedicao()
    {
        $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,
    CASE 
        WHEN MAX(med.data_limite_liberar) IS NULL THEN 
            DATE_FORMAT(DATE_ADD(MAX(med.data_contrato), INTERVAL 5 DAY), '%Y-%m-%d')
        ELSE    
            DATE_FORMAT(DATE_ADD(MAX(med.data_limite_liberar), INTERVAL 5 DAY), '%Y-%m-%d')
    END 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 (7,8)
 and med.medidor_id is null
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;
    }
    public function listarOcorrencia($Dados = null)
    {
        $this->DadosOcor = $Dados;
      //  var_dump( $this->DadosOcor );
        $listarOcorrencia = new \App\adms\Models\helper\AdmsRead();
        $listarOcorrencia->fullRead("select ocor.num_contrato,
				                        stat.nome nome_estatus,
                                        ocor.status_id,                
                                        u.nome nome_usu,
                                        DATE_FORMAT(ocor.data, '%d/%m/%Y %H:%i' ) AS data_ocor,
                                         ocor.ocorrencia
                                FROM gre_ocorrencias ocor
                                left join adms_usuarios u
                                  on u.id = ocor.usu_ocorrencia
								left join gre_status stat
								  on stat.id = ocor.status_id
                              where ocor.status_id in(7,8)
                              and ocor.num_contrato = :num_contrato
                              and ocor.empr_id = :empr_id
                              order by ocor.data desc ", 
                            "num_contrato=". $this->DadosOcor[0]['num_contrato']."&empr_id=". $_SESSION['id_user']);
        $this->Resultado = $listarOcorrencia->getResultado();
    // var_dump($this->Resultado);
    //   die;
        return $this->Resultado;
    }

}