ListaDao::Listar PHP 코드 예제들

예제 #1

0

파일 보기

파일: result_versoes.php 프로젝트: hexti/troncal

if ($lista->getDisciplina() == 0) {
    $disciplina = '';
} else {
    $disciplina = " AND A.id_disciplina = " . $lista->getDisciplina();
}
if ($lista->getTipoDeDocumento() == 0) {
    $tipo_documento = '';
} else {
    $tipo_documento = " AND A.id_tipo_doc = " . $lista->getTipoDeDocumento();
}
if ($lista->getStatus() == 'T') {
    $status = '';
} else {
    $status = " AND L.status = '" . $lista->getStatus() . "'";
}
$resultado = $DAO->Listar("SELECT \t\r\n\t\t\t\t\t\t\t\t\tA.id,\r\n\t\t\t\t\t\t\t\t\tSUBSTRING(N.nome_arquivo, 1, 35) AS codigo_cons,\r\n\t\t\t\t\t\t\t\t\tL.nome AS nome_empresa,\r\n\t\t\t\t\t\t\t\t\tA.titulo,\r\n\t\t\t\t\t\t\t\t\tD.nome AS nome_obra,\r\n\t\t\t\t\t\t\t\t\tC.nome AS nome_fase,\r\n\t\t\t\t\t\t\t\t\tE.nome AS nome_tipo,\r\n\t\t\t\t\t\t\t\t\tF.nome AS nome_disciplina,\r\n\t\t\t\t\t\t\t\t\tA.id_nucleo,\r\n\t\t\t\t\t\t\t\t\tB.status,\r\n\t\t\t\t\t\t\t\t\tN.revisao,\r\n\t\t\t\t\t\t\t\t\tB.data_recebido,\r\n \t\t\t\t\t\t\t\t\tB.id_remessa_arquivo,\r\n\t\t\t\t\t\t\t\t\tB.id_pedido_informacao,\r\n\t\t\t\t\t\t\t\t\tB.data_pedido_informacao\r\n\t\t\t\t\t\t\t\tFROM tb_projeto_cad A\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_cad_terceirizado B\tON A.id = B.id_cad_projeto\t\t\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_fase_projeto C \t\t\t\tON A.id_fase = C.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_projeto_obra D \t\t\t\tON A.id_obra = D.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_tipo_documento E \t\t\t\tON A.id_tipo_doc = E.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_disciplina F \t\t\t\t\tON A.id_disciplina = F.id\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_cod_projeto G \t\t\t\t\tON A.id_cod_projeto = G.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_nucleo H \t\t\t\t\t\tON A.id_nucleo = H.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_contrato I \t\t\tON A.id_contrato = I.id\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_empresa L \t\t\t\t\t\tON A.id_empresa = L.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_check_list_projetos N \t\t\tON A.id_tipo_doc = N.id_tipo_documento\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  AND A.id_nucleo = N.id_nucleo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  AND A.id_fase = N.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  AND A.id_obra = N.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  AND A.id_disciplina = N.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  AND A.numero = N.sequencial\r\n\t\t\t\t\t\t\t\tWHERE A.excluido IS NULL\r\n\t\t\t\t\t\t\t\t" . $empresa . "" . $obra . "" . $fase . "" . $disciplina . "" . $tipo_documento . "" . $status . "\r\n\t\t\t\t\t\t\t\tGROUP BY A.id \r\n\t\t\t\t\t\t\t\tORDER BY L.nome, D.codigo, C.codigo, E.codigo, F.codigo, A.numero");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {
/* 		border-spacing: 0px; */

예제 #2

0

파일 보기

파일: relatorio_avanco2.php 프로젝트: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/CadastroDAO.php';
include_once '../Cadastro.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
$lista = new Lista();
$DAO = new ListaDao();
$resumo_aprovado = $DAO->Listar("SELECT\r\n \t\t\t\t\t\t\t\t\t\t\tA.id_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\tF.nome AS nome_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\tB.status,\r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(DISTINCT(A.id)) AS total_aprovado\r\n\t\t\t\t\t\t\t\t\t\tFROM tb_projeto_cad A\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_cad_cliente B \t\t\tON A.id = B.id_projeto_cad AND B.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN tb_fase_projeto C \t\t\t\tON A.id_fase = C.id\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN tb_projeto_obra D \t\t\t\tON A.id_obra = D.id\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN tb_tipo_documento E \t\t\t\tON A.id_tipo_doc = E.id\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN tb_disciplina F \t\t\t\t\tON A.id_disciplina = F.id\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_cod_projeto G \t\t\t\t\tON A.id_cod_projeto = G.id\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_nucleo H \t\t\t\t\t\tON A.id_nucleo = H.id\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_contrato I \t\t\tON A.id_contrato = I.id\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_trecho J \t\t\t\tON A.id_trecho = J.id\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_empresa L \t\t\t\t\t\tON A.id_empresa = L.id\r\n\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\tB.id = (SELECT id FROM tb_projeto_cad_cliente WHERE id_projeto_cad = A.id ORDER BY id DESC LIMIT 1)\r\n \t\t\t\t\t\t\t\t\t\t\tAND B.status IN ('A', 'P')\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY A.id_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t B.status\r\n\t\t\t\t\t\t\t\t\t\t");
?>
<html>
<script type="text/javascript"
	src="https://www.google.com/jsapi?autoload={'modules':[{'name':'visualization','version':'1','packages':['corechart']}]}"></script>

<img src="../../img/logo_grafico.png" align="left"> <br></br>
<div id="columnchart_values" style="width: 900px; height: 300px;"></div>

<div class="add-border">


</html>
<?php 
foreach ($resumo_aprovado as $item) {
    $aprovado = 0;
    if ($item['total_aprovado'] != '') {
        $aprovado = $item['total_aprovado'];
    }
    echo 'teste' . $aprovado;
    $grafico .= "['" . $item['nome_disciplina'] . "', " . $aprovado . ", '" . $aprovado . "', 22, '22', 23, '23'],";
    ?>

예제 #3

0

파일 보기

파일: grafico_projeto.php 프로젝트: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/CadastroDAO.php';
include_once '../Cadastro.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
$lista = new Lista();
$DAO = new ListaDao();
$previsto = $DAO->Listar("SELECT COUNT(id) AS num_previstos\r\n\t\t\t\t\t\t\tFROM tb_projeto_cad;");
$entregue = $DAO->Listar("SELECT id \r\n\t\t\t\t\t\t\tFROM tb_remessa_arquivo \r\n\t\t\t\t\t\t\tGROUP BY id_codigo_projeto, id_nucleo, id_contrato, id_obra, id_trecho, id_fase_projeto, id_disciplina, id_tipo_documento, sequencial;");
$aprovado = $DAO->Listar("SELECT COUNT(id) AS num_aprovados\r\n\t\t\t\t\t\t\tFROM tb_check_list_projetos \r\n\t\t\t\t\t\t\tWHERE ativo = 'S' \r\n\t\t\t\t\t\t\tAND status IN ('A', 'AC');");
foreach ($previsto as $item) {
    $num_previstos = $item['num_previstos'];
}
$num_entregues = $entregue->rowCount();
foreach ($aprovado as $item) {
    $num_aprovados = $item['num_aprovados'];
}
?>
<html>
  <head>
  
  <style>
	table {
/* 		border-spacing: 0px; */
/* 		border-collapse: collapse; */
		width: 623px;
	}
	
	table.corpo {

예제 #4

0

파일 보기

파일: detalha_cliente.php 프로젝트: hexti/troncal

        break;
    case 'P':
        $filtro_status = 'Em An&aacute;lise';
        break;
    case 'V':
        $filtro_status = 'Pendente';
        break;
    default:
        $filtro_status = 'Em An&aacute;lise';
}
$query = '';
if (!empty($empresa) || !empty($obra) || !empty($fase) || !empty($disciplina) || !empty($tipo_documento) || !empty($status)) {
    $where = " WHERE " . $empresa . $obra . $fase . $disciplina . $tipo_documento . $status;
    $where = substr($where, 0, -4);
}
$resultado = $DAO->Listar("SELECT G.codigo AS cod_cod_projeto,\r\n\t\t\t\t\t\t\t\t\tH.codigo AS cod_nucleo,\r\n\t\t\t\t\t\t\t\t\tI.codigo AS cod_contrato,\r\n\t\t\t\t\t\t\t\t\tD.codigo AS cod_obra,\r\n\t\t\t\t\t\t\t\t\tJ.codigo AS cod_trecho,\r\n\t\t\t\t\t\t\t\t\tC.codigo AS cod_fase,\r\n\t\t\t\t\t\t\t\t\tF.codigo AS cod_disciplina,\r\n\t\t\t\t\t\t\t\t\tE.codigo AS cod_tipo_documento,\r\n\t\t\t\t\t\t\t\t\tL.nome AS nome_empresa,\r\n\t\t\t\t\t\t\t\t\tA.titulo,\r\n\t\t\t\t\t\t\t\t\tD.nome AS nome_obra,\r\n\t\t\t\t\t\t\t\t\tC.nome AS nome_fase,\r\n\t\t\t\t\t\t\t\t\tE.nome AS nome_tipo,\r\n\t\t\t\t\t\t\t\t\tF.nome AS nome_disciplina,\r\n\t\t\t\t\t\t\t\t\tA.id_nucleo,\r\n\t\t\t\t\t\t\t\t\tB.status,\r\n\t\t\t\t\t\t\t\t\tB.revisao,\r\n\t\t\t\t\t\t\t\t\tB.data_entrada,\r\n\t\t\t\t\t\t\t\t\tB.cod_entrada,\r\n\t\t\t\t\t\t\t\t\tB.data_conclusao,\r\n\t\t\t\t\t\t\t\t\tB.num_oficio,\r\n \t\t\t\t\t\t\t\t\tA.numero\r\n\t\t\t\t\t\t\t\tFROM tb_projeto_cad A\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_cad_cliente B \t\t\tON A.id = B.id_projeto_cad AND B.excluido IS NULL AND B.id = (SELECT id FROM tb_projeto_cad_cliente WHERE id_projeto_cad = A.id ORDER BY id DESC LIMIT 1)\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_fase_projeto C \t\t\t\tON A.id_fase = C.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_projeto_obra D \t\t\t\tON A.id_obra = D.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_tipo_documento E \t\t\t\tON A.id_tipo_doc = E.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_disciplina F \t\t\t\t\tON A.id_disciplina = F.id\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_cod_projeto G \t\t\t\t\tON A.id_cod_projeto = G.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_nucleo H \t\t\t\t\t\tON A.id_nucleo = H.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_contrato I \t\t\tON A.id_contrato = I.id\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_trecho J \t\t\t\tON A.id_trecho = J.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN tb_empresa L \t\t\t\t\t\tON A.id_empresa = L.id\r\n\t\t\t\t\t\t\t\t" . $where . "\r\n \t\t\t\t\t\t\t\tGROUP BY A.id\r\n\t\t\t\t\t\t\t\tORDER BY L.nome, D.codigo, C.codigo, E.codigo, F.codigo");
//".$empresa.$obra.$fase.$disciplina.$tipo_documento.$status."
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {

예제 #5

0

파일 보기

파일: relatorio_lista_substituidos.php 프로젝트: hexti/troncal

$data = "";
$retira_pendente = "";
//verifica se foi digitado a data Inicial e Final
if (!empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND (criado BETWEEN '" . $dataInicio . " 00:00:00' AND '" . $dataFim . " 23:59:59')";
}
//Verifica se so a data inicial foi digitada
if (!empty($dataInicio) && empty($dataFim)) {
    $data .= " AND criado >= '" . $dataInicio . " 00:00:00'";
}
//Verifica se so a data final foi digitada
if (empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND criado <= '" . $dataFim . " 23:59:59'";
}
//Fim - Verifica o STATUS
$resultado = $DAO->Listar("SELECT * FROM vw_projetos_substituidos\r\n \t\t\t\t\t\t\t\tWHERE\r\n \t\t\t\t\t\t\t\t\texcluido IS NULL\r\n \t\t\t\t\t\t\t\t" . $where_disciplina . $where_fases . $where_obras . $data . " \r\n \t\t\t\t\t\t\t\tORDER BY criado;");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projetos Substituidos</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {
/* 		border-spacing: 0px; */

예제 #6

0

파일 보기

파일: edit.php 프로젝트: hexti/troncal

        // 		break;
        if ($retorno == 1) {
            echo '<script language= "JavaScript">alert("Registro alterado com sucesso");</script>';
            echo '<script language= "JavaScript">location.href="index.php";</script>';
        } else {
            print_r($retorno);
            $msg = utf8_encode("Erro - Registro não foi salvo, erro:" . $retorno);
            echo '<script language= "JavaScript">alert("' . $msg . '");</script>';
        }
    } else {
        echo '<script language= "JavaScript">alert("Preenchas todos os campos.");</script>';
    }
} else {
    $lista->setId(limpaTexto($_GET['id']));
    //Pegando o nome do projeto
    $retorno = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_PROJETO_CADASTRO . " WHERE id=" . $lista->getId());
    foreach ($retorno as $item) {
        $lista->setTitulo($item['titulo']);
        $lista->setEmpresa($item['id_empresa']);
        $lista->setCodProjeto($item['id_cod_projeto']);
        // 		$lista->setNucleo($item['id_nucleo']);
        // 		$lista->setContrato($item['id_contrato']);
        $lista->setObra($item['id_obra']);
        // 		$lista->setTrecho($item['id_trecho']);
        $lista->setFaseDoProjeto($item['id_fase']);
        $lista->setDisciplina($item['id_disciplina']);
        $lista->setTipoDeDocumento($item['id_tipo_doc']);
    }
}
?>
<!-- topbar ends -->

예제 #7

0

파일 보기

파일: relatorio_cliente.php 프로젝트: hexti/troncal

if ($_POST['r_em_analise'] == 'S') {
    $em_analise = "EA";
    //verificar se funciona assim...
} else {
    $em_analise = 'T';
}
$status = " (status IN ('" . $aprovado . "','" . $reprovado . "','" . $em_analise . "')) AND ";
$query = '';
if (!empty($empresa) || !empty($obra) || !empty($fase) || !empty($disciplina) || !empty($tipo_documento) || !empty($status)) {
    $where = " WHERE " . $obra . $fase . $disciplina . $tipo_documento . $status . $data;
    $where = substr($where, 0, -4);
} else {
    $where = " WHERE " . $data;
    $where = substr($where, 0, -4);
}
$resultado = $DAO->Listar("SELECT *\r\n\t\t\t\t\t\t\tFROM vw_relatorio_analitico_cliente\r\n\t\t\t\t\t\t\t" . $where);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {
/* 		border-spacing: 0px; */

예제 #8

0

파일 보기

파일: relatorio_analitico_wf.php 프로젝트: hexti/troncal

    $status = '';
}
$data = "";
//verifica se foi digitado a data Inicial e Final
if (!empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND (A.dat_criado BETWEEN '" . $dataInicio . " 00:00:00' AND '" . $dataFim . " 23:59:59')";
}
//Verifica se so a data inicial foi digitada
if (!empty($dataInicio) && empty($dataFim)) {
    $data .= " AND A.dat_criado >= '" . $dataInicio . " 00:00:00'";
}
//Verifica se so a data final foi digitada
if (empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND A.dat_criado <= '" . $dataFim . " 23:59:59'";
}
$resultado = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\tA.id\r\n\t\t\t\t\t\t\t\t\t,A.dat_criado\r\n\t\t\t\t\t\t\t\t\t,IF (A.finalizado IS NULL, 'Em An&aacute;lise', 'Finalizado') AS finalizado\r\n\t\t\t\t\t\t\t\t\t,C.cod_documento \r\n\t\t\t\t\t\t\t\t\t,D.nome AS obra\r\n\t\t\t\t\t\t\t\t\t,E.nome AS disciplina\r\n\t\t\t\t\t\t\t\tFROM tb_work_flow A\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_work_flow_fluxo \tB ON A.id = B.id_work_flow\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_documento \t\tC ON A.id_documento = C.id\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_projeto_obra \t\tD ON D.codigo = SUBSTRING(C.cod_documento, 13, 3)\r\n\t\t\t\t\t\t\t\tINNER JOIN tb_disciplina \t\tE ON E.codigo = SUBSTRING(C.cod_documento, 23, 3)\r\n\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\tdat_excluido IS NULL\r\n\t\t\t\t\t\t\t\t\tAND is_projeto = 'S'\r\n \t\t\t\t\t\t\t\t\t{$obra} {$disciplina} {$status} {$data}\r\n\t\t\t\t\t\t\t\tGROUP BY A.id_documento, A.id\r\n\t\t\t\t\t\t\t\tORDER BY A.finalizado ASC, D.nome, E.nome");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de
	Projeto</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />

<script type="text/javascript">

</script>

<style>
table {

예제 #9

0

파일 보기

파일: relatorio_lista_mestra.php 프로젝트: hexti/troncal

if (empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND CK.criado <= '" . $dataFim . " 23:59:59'";
    $retira_pendente = " AND B.id = 0";
}
//Inicio - Verifica o STATUS
foreach ($_POST['check_status'] as $item) {
    $check_status .= "'" . $item . "',";
}
$status = substr($check_status, 0, -1);
if ($status == "") {
    $where_status = '';
} else {
    $where_status = " AND CK.status IN (" . $status . ")";
}
//Fim - Verifica o STATUS
$resultado = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\t\tCK.nome_arquivo AS nome_arquivo,\r\n\t\t\t\t\t\t\t        E.nome AS nome_empresa,\r\n\t\t\t\t\t\t\t        CK.criado AS data_recebido,\r\n\t\t\t\t\t\t\t        FP.nome AS nome_fase,\r\n\t\t\t\t\t\t\t        PO.nome AS nome_obra,\r\n\t\t\t\t\t\t\t        TD.nome AS nome_tipo_documento,\r\n\t\t\t\t\t\t\t        D.nome AS nome_disciplina,\r\n\t\t\t\t\t\t\t        RA.titulo AS titulo,\r\n\t\t\t\t\t\t\t        RA.id AS id_remessa_arquivo,\r\n\t\t\t\t\t\t\t        TD.id AS id_tipo_documento,\r\n \t\t\t\t\t\t\t\t\tTD.nome AS nome_tipo_documento,\r\n\t\t\t\t\t\t\t        D.id AS id_disciplina,\r\n\t\t\t\t\t\t\t        FP.id AS id_fase_projeto,\r\n\t\t\t\t\t\t\t        PO.id AS id_obra,\r\n\t\t\t\t\t\t\t        E.id AS id_empresa,\r\n\t\t\t\t\t\t\t        RA.revisao AS revisao,\r\n\t\t\t\t\t\t\t        PIA.id_pedido_informacao AS id_pedido_informacao,\r\n\t\t\t\t\t\t\t        PI.criado AS data_pedido_informacao,\r\n\t\t\t\t\t\t\t        (CASE CK.status\r\n\t\t\t\t\t\t\t            WHEN 'A' THEN 'A'\r\n\t\t\t\t\t\t\t            WHEN 'R' THEN 'R'\r\n\t\t\t\t\t\t\t            WHEN 'AC' THEN 'AC'\r\n\t\t\t\t\t\t\t            WHEN 'C' THEN 'C'\r\n\t\t\t\t\t\t\t            WHEN 'O' THEN 'O'\r\n\t\t\t\t\t\t\t            WHEN '' THEN 'EA'\r\n\t\t\t\t\t\t\t            ELSE 'P'\r\n\t\t\t\t\t\t\t        END) AS status\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\ttb_remessa_arquivo RA\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_check_list_projetos CK ON CK.id_remessa_arquivo = RA.id AND CK.ativo = 'S'\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_projeto_obra PO ON PO.id = RA.id_obra\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_tipo_documento TD ON TD.id = RA.id_tipo_documento\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_disciplina D ON D.id = RA.id_disciplina\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_cod_projeto CP ON CP.id = RA.id_codigo_projeto\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_nucleo N ON N.id = RA.id_nucleo\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_projeto_contrato PC ON PC.id = RA.id_contrato\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_projeto_trecho PT ON PT.id = RA.id_trecho\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_remessa_lista RL ON RL.id = RA.id_remessa_lista\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_empresa E ON E.id = RL.id_empresa\r\n\t\t\t\t\t\t\t\t    INNER JOIN tb_fase_projeto FP ON FP.id = RA.id_fase_projeto\r\n\t\t\t\t\t\t\t\t    LEFT JOIN tb_pedido_informacao_arquivo PIA ON PIA.id_lista_arquivo = RA.id\r\n\t\t\t\t\t\t\t\t    LEFT JOIN tb_pedido_informacao PI ON PI.id = PIA.id_pedido_informacao\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\tCK.id > 0\r\n \t\t\t\t\t\t\t\t\t" . $where_fases . $where_obras . $where_tipos . $wehre_disciplina . $where_status . $where_disciplina . $data . "\r\n\t\t\t\t\t\t\t\tGROUP BY RA.id_codigo_projeto, RA.id_nucleo, RA.id_contrato, RA.id_obra, RA.id_trecho, RA.id_fase_projeto, RA.id_disciplina, RA.id_tipo_documento, RA.sequencial, RA.revisao ");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {
/* 		border-spacing: 0px; */

예제 #10

0

파일 보기

파일: relatorio_avanco.php 프로젝트: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/CadastroDAO.php';
include_once '../Cadastro.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
$lista = new Lista();
$DAO = new ListaDao();
$resultado_total_geral = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tA.id_disciplina, \r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(A.id) AS total_previsao,\r\n\t\t\t\t\t\t\t\t\t\t\tB.nome\r\n\t\t\t\t\t\t\t\t\t\tFROM tb_projeto_cad A\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " B ON B.id = A.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\tWHERE A.excluido IS NULL GROUP BY A.id_disciplina;");
$resultado_terceirizado = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tid_disciplina, \r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(A.id) AS total_terceirizada\r\n\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\ttb_projeto_cad A\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN tb_projeto_cad_terceirizado B ON B.id_cad_projeto = A.id AND B.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\t\tA.excluido IS NULL AND \r\n\t\t\t\t\t\t\t\t\t\t\tB.id = (SELECT id FROM tb_projeto_cad_terceirizado WHERE id_cad_projeto = A.id ORDER BY id DESC LIMIT 1) \r\n\t\t\t\t\t\t\t\t\t\tGROUP BY A.id_disciplina;");
$resultado_aprovado_cliente = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\tid_disciplina, \r\n\t\t\t\t\t\t\t\t\t\t\t\tCOUNT(A.id) AS total_aprovado\r\n\t\t\t\t\t\t\t\t\t\t\tFROM tb_projeto_cad A\r\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_cad_cliente B ON B.id_projeto_cad = A.id AND B.excluido IS NULL AND B.id = (SELECT id FROM tb_projeto_cad_cliente WHERE id_projeto_cad = A.id ORDER BY id DESC LIMIT 1)\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE A.excluido IS NULL \r\n\t\t\t\t\t\t\t\t\t\t\tAND B.status = 'A'\r\n\t\t\t\t\t\t\t\t\t\t\tGROUP BY A.id_disciplina;");
$array = array();
foreach ($resultado_total_geral as $item) {
    $array['disciplina'][] = $item['id_disciplina'];
    $array['total'][] = $item['total_previsao'];
    $array['nome'][] = $item['nome'];
}
$keys = array_keys($array['disciplina']);
foreach ($resultado_terceirizado as $item) {
    foreach ($keys as $row) {
        if ($array['disciplina'][$row] == $item['id_disciplina']) {
            $array['terceirizado'][$row] = $item['total_terceirizada'];
        }
    }
}
if ($resultado_aprovado_cliente->rowCount() > 0) {
    foreach ($resultado_aprovado_cliente as $item) {
        foreach ($keys as $row) {
            if ($array['disciplina'][$row] == $item['id_disciplina']) {
                $array['cliente'][$row] = $item['total_aprovado'];

예제 #11

0

파일 보기

파일: relatorio_sintetico_wf.php 프로젝트: hexti/troncal

    $status = '';
}
$data = "";
//verifica se foi digitado a data Inicial e Final
if (!empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND (A.dat_criado BETWEEN '" . $dataInicio . " 00:00:00' AND '" . $dataFim . " 23:59:59')";
}
//Verifica se so a data inicial foi digitada
if (!empty($dataInicio) && empty($dataFim)) {
    $data .= " AND A.dat_criado >= '" . $dataInicio . " 00:00:00'";
}
//Verifica se so a data final foi digitada
if (empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND A.dat_criado <= '" . $dataFim . " 23:59:59'";
}
$resultado = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t    D.nome AS obra,\r\n\t\t\t\t\t\t\t\t    E.nome AS disciplina,\r\n\t\t\t\t\t\t\t\t\tIF (A.finalizado IS NULL, 'Em An&aacute;lise', 'Finalizado') AS finalizado, \r\n\t\t\t\t\t\t\t\t\tCOUNT(DISTINCT(A.id)) AS total\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t    tb_work_flow A\r\n\t\t\t\t\t\t\t\t        INNER JOIN\r\n\t\t\t\t\t\t\t\t    tb_work_flow_fluxo B ON A.id = B.id_work_flow\r\n\t\t\t\t\t\t\t\t        INNER JOIN\r\n\t\t\t\t\t\t\t\t    tb_documento C ON A.id_documento = C.id\r\n\t\t\t\t\t\t\t\t        INNER JOIN\r\n\t\t\t\t\t\t\t\t    tb_projeto_obra D ON D.codigo = SUBSTRING(C.cod_documento, 13, 3)\r\n\t\t\t\t\t\t\t\t        INNER JOIN\r\n\t\t\t\t\t\t\t\t    tb_disciplina E ON E.codigo = SUBSTRING(C.cod_documento, 23, 3)\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t    A.dat_excluido IS NULL\r\n\t\t\t\t\t\t\t\t        AND is_projeto = 'S'\r\n \t\t\t\t\t\t\t\t\t\t{$obra} {$disciplina} {$status} {$data}\r\n\t\t\t\t\t\t\t\tGROUP BY D.codigo, E.codigo, IF (A.finalizado IS NULL, 'Em An&aacute;lise', 'Finalizado')\r\n\t\t\t\t\t\t\t\tORDER BY D.nome , E.nome\r\n \t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de
	Projeto</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />

<script type="text/javascript">

</script>

<style>
table {

예제 #12

0

파일 보기

파일: controle_projeto_terceirizada.php 프로젝트: hexti/troncal

    $em_analise = "EA";
    //Em Analise (Verificado)
} else {
    $em_analise = 'T';
}
if ($_POST['r_pendente'] == 'S') {
    $pendente = 'P';
    //Pendente, só existe na tabela 'tb_remessa_arquivo'
    // 	$valida_sql = ' ';
} else {
    $pendente = 'T';
    // 	$valida_sql = ' AND A.id = 0';
}
$status = " AND status IN ('" . $aprovado . "','" . $reprovado . "','" . $aprovado_comentario . "','" . $em_analise . "','" . $pendente . "')";
//O resultado total de acordo com o filtro
$total_geral = $DAO->Listar("SELECT COUNT(id_remessa_arquivo) AS total_geral \r\n\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_projetista \r\n\t\t\t\t\t\t\t\t\tWHERE status != 'O'\t" . $empresa . $fase . $status);
if ($_POST['r_obra_fase'] == 'S') {
    $resumo_por_fase = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra, \r\n\t\t\t\t\t\t\t\t\t\t\tnome_fase, \r\n \t\t\t\t\t\t\t\t\t\t\tstatus, \r\n \t\t\t\t\t\t\t\t\t\t\tCOUNT(id_remessa_arquivo) AS total \r\n\t\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_projetista \r\n\t\t\t\t\t\t\t\t\t\tWHERE status != 'O' " . $empresa . $fase . $status . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY id_obra, id_fase_projeto, status");
}
if ($_POST['r_produto'] == 'S') {
    $resumo_por_tipo = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra, \r\n\t\t\t\t\t\t\t\t\t\t\tnome_tipo_documento AS nome_tipo, \r\n \t\t\t\t\t\t\t\t\t\t\tstatus, \r\n \t\t\t\t\t\t\t\t\t\t\tCOUNT(id_remessa_arquivo) AS total \r\n\t\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_projetista \r\n\t\t\t\t\t\t\t\t\t\tWHERE status != 'O' " . $empresa . $fase . $status . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY id_obra, id_tipo_documento, status");
}
if ($_POST['r_obra_disciplina'] == 'S') {
    $resumo_por_obra_disciplina = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\t\tnome_obra, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\tnome_disciplina, \r\n\t\t \t\t\t\t\t\t\t\t\t\t\tstatus, \r\n\t\t \t\t\t\t\t\t\t\t\t\t\tCOUNT(id_remessa_arquivo) AS total \r\n\t\t\t\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_projetista \r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE status != 'O' " . $empresa . $fase . $status . "\r\n\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY id_obra, id_disciplina, status");
}
if ($_POST['r_disciplina'] == 'S') {
    $resumo_por_disciplina = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\tnome_disciplina, \r\n\t \t\t\t\t\t\t\t\t\t\t\tstatus, \r\n\t \t\t\t\t\t\t\t\t\t\t\tCOUNT(id_remessa_arquivo) AS total \r\n\t\t\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_projetista \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE status != 'O' " . $empresa . $fase . $status . "\r\n\t\t\t\t\t\t\t\t\t\t\tGROUP BY id_disciplina, status");
}
if ($_POST['r_obra'] == 'S') {
    $resumo_por_obra = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra, \r\n \t\t\t\t\t\t\t\t\t\t\tstatus, \r\n \t\t\t\t\t\t\t\t\t\t\tCOUNT(id_remessa_arquivo) AS total \r\n\t\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_projetista \r\n\t\t\t\t\t\t\t\t\t\tWHERE status != 'O' " . $empresa . $fase . $status . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY id_obra, status");
}

예제 #13

0

파일 보기

파일: relatorio_analitico_finalizados.php 프로젝트: hexti/troncal

} else {
    $tipo_documento = " id_tipo_documento = " . $lista->getTipoDeDocumento() . " AND";
    $query = mysql_query("SELECT nome FROM " . MYSQL_BASE_TIPO_DOCUMENTOS . " WHERE id =" . $lista->getTipoDeDocumento());
    while ($row = mysql_fetch_array($query)) {
        $filtro_tipo = $row['nome'];
    }
}
$query = '';
if (!empty($obra) || !empty($disciplina) || !empty($tipo_documento)) {
    $where = " WHERE " . $obra . $disciplina . $tipo_documento . $data;
    $where = substr($where, 0, -4);
} else {
    $where = " WHERE " . $data;
    $where = substr($where, 0, -4);
}
$resultado = $DAO->Listar("SELECT * FROM vw_relatorio_projetos_finalizados " . $where);
$rowCount = $resultado->rowCount();
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {

예제 #14

0

파일 보기

파일: detalha_terceirizada.php 프로젝트: hexti/troncal

    case 'O':
        $filtro_status = 'Aprovado com Coment&aacute;rio';
        break;
    case 'C':
        $filtro_status = 'Arp';
        break;
    case 'P':
        $filtro_status = 'Em An&aacute;lise';
        break;
    case 'V':
        $filtro_status = 'Pendente';
        break;
    default:
        $filtro_status = 'Em An&aacute;lise';
}
$resultado = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\tcod_cod_projeto,\r\n\t\t\t\t\t\t\t\t\tcod_nucleo,\r\n\t\t\t\t\t\t\t\t\tcod_contrato,\r\n\t\t\t\t\t\t\t\t\tcod_obra,\r\n\t\t\t\t\t\t\t\t\tcod_trecho,\r\n\t\t\t\t\t\t\t\t\tcod_fase,\r\n\t\t\t\t\t\t\t\t\tcod_disciplina,\r\n\t\t\t\t\t\t\t\t\tcod_tipo_documento,\r\n\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\tnome_empresa,\r\n\t\t\t\t\t\t\t\t\ttitulo,\r\n \t\t\t\t\t\t\t\t\tnumero,\r\n\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\tnome_fase,\r\n\t\t\t\t\t\t\t\t\tnome_tipo,\r\n\t\t\t\t\t\t\t\t\tnome_disciplina,\r\n\t\t\t\t\t\t\t\t\tid_nucleo,\r\n\t\t\t\t\t\t\t\t\trevisao,\r\n\t\t\t\t\t\t\t\t\tdata_recebido,\r\n\t\t\t\t\t\t\t\t\tid_pedido_informacao,\r\n\t\t\t\t\t\t\t\t\tid_remessa_arquivo,\r\n\t\t\t\t\t\t\t\t\tdata_pedido_informacao FROM \r\n \t\t\t\t\t\t\t\t(SELECT \r\n\t\t\t\t\t\t\t\t\tG.codigo AS cod_cod_projeto,\r\n\t\t\t\t\t\t\t\t\tH.codigo AS cod_nucleo,\r\n\t\t\t\t\t\t\t\t\tI.codigo AS cod_contrato,\r\n\t\t\t\t\t\t\t\t\tD.codigo AS cod_obra,\r\n\t\t\t\t\t\t\t\t\tJ.codigo AS cod_trecho,\r\n\t\t\t\t\t\t\t\t\tC.codigo AS cod_fase,\r\n\t\t\t\t\t\t\t\t\tF.codigo AS cod_disciplina,\r\n\t\t\t\t\t\t\t\t\tE.codigo AS cod_tipo_documento,\r\n\t\t\t\t\t\t\t\t\tB.status,\r\n\t\t\t\t\t\t\t\t\tL.nome AS nome_empresa,\r\n\t\t\t\t\t\t\t\t\tA.titulo,\r\n \t\t\t\t\t\t\t\t\tA.numero,\r\n\t\t\t\t\t\t\t\t\tD.nome AS nome_obra,\r\n\t\t\t\t\t\t\t\t\tC.nome AS nome_fase,\r\n\t\t\t\t\t\t\t\t\tE.nome AS nome_tipo,\r\n\t\t\t\t\t\t\t\t\tF.nome AS nome_disciplina,\r\n\t\t\t\t\t\t\t\t\tA.id_nucleo,\r\n\t\t\t\t\t\t\t\t\tB.revisao,\r\n\t\t\t\t\t\t\t\t\tB.data_recebido,\r\n\t\t\t\t\t\t\t\t\tB.id_pedido_informacao,\r\n\t\t\t\t\t\t\t\t\tB.id_remessa_arquivo,\r\n\t\t\t\t\t\t\t\t\tB.data_pedido_informacao\r\n\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\ttb_projeto_cad A\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_cad_terceirizado B ON B.id_cad_projeto = A.id AND B.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_fase_projeto C \t\t\tON A.id_fase = C.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_obra D \t\t\tON A.id_obra = D.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_tipo_documento E \t\t\tON A.id_tipo_doc = E.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_disciplina F \t\t\t\tON A.id_disciplina = F.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_cod_projeto G \t\t\t\tON A.id_cod_projeto = G.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_nucleo H \t\t\t\t\tON A.id_nucleo = H.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_contrato I \t\tON A.id_contrato = I.id\r\n \t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_trecho J \t\t\t\tON A.id_trecho = J.id\r\n\t\t\t\t\t\t\t\t\tINNER JOIN tb_empresa L \t\t\t\tON L.id = A.id_empresa\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_check_list_projetos N \t\tON A.id_tipo_doc = N.id_tipo_documento\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_nucleo = N.id_nucleo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_fase = N.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_obra = N.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_disciplina = N.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.numero = N.sequencial\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\tB.id = (SELECT id FROM tb_projeto_cad_terceirizado WHERE id_cad_projeto = A.id ORDER BY id DESC LIMIT 1) \r\n\t\t\t\t\t\t\t\t\tAND A.excluido IS NULL\r\n \t\t\t\t\t\t\t\t\t" . $empresa . $obra . $fase . $disciplina . $tipo_documento . $status . "\r\n\t\t\t\t\t\t\t\tUNION ALL\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tSELECT \r\n \t\t\t\t\t\t\t\t\t'' AS cod_cod_projeto,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_nucleo,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_contrato,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_obra,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_trecho,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_fase,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_disciplina,\r\n\t\t\t\t\t\t\t\t\t'' AS cod_tipo_documento,\r\n\t\t\t\t\t\t\t\t\t'V' AS status,\r\n\t\t\t\t\t\t\t\t\tL.nome AS nome_empresa,\r\n\t\t\t\t\t\t\t\t\tA.titulo,\r\n \t\t\t\t\t\t\t\t\tA.numero,\r\n\t\t\t\t\t\t\t\t\tD.nome AS nome_obra,\r\n\t\t\t\t\t\t\t\t\tC.nome AS nome_fase,\r\n\t\t\t\t\t\t\t\t\tE.nome AS nome_tipo,\r\n\t\t\t\t\t\t\t\t\tF.nome AS nome_disciplina,\r\n\t\t\t\t\t\t\t\t\tA.id_nucleo,\r\n\t\t\t\t\t\t\t\t\t'' AS revisao,\r\n\t\t\t\t\t\t\t\t\t'' AS data_recebido,\r\n\t\t\t\t\t\t\t\t\t'' AS id_pedido_informacao,\r\n\t\t\t\t\t\t\t\t\t'' AS id_remessa_arquivo,\r\n\t\t\t\t\t\t\t\t\t'' AS data_pedido_informacao\r\n\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\ttb_projeto_cad A\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_fase_projeto C \tON A.id_fase = C.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_obra D \tON A.id_obra = D.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_tipo_documento E \tON A.id_tipo_doc = E.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_disciplina F \t\tON A.id_disciplina = F.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_cod_projeto G \t\tON A.id_cod_projeto = G.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_nucleo H \t\t\tON A.id_nucleo = H.id\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_contrato I ON A.id_contrato = I.id\r\n \t\t\t\t\t\t\t\t\tLEFT JOIN tb_projeto_trecho J \t\t\t\tON A.id_trecho = J.id\r\n\t\t\t\t\t\t\t\t\tINNER JOIN tb_empresa L \t\tON L.id = A.id_empresa\r\n\t\t\t\t\t\t\t\t\tLEFT JOIN tb_check_list_projetos N \tON A.id_tipo_doc = N.id_tipo_documento\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_nucleo = N.id_nucleo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_fase = N.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_obra = N.id_obra_codigo\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.id_disciplina = N.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND A.numero = N.sequencial\r\n\t\t\t\t\t\t\t\tWHERE A.id NOT IN (SELECT DISTINCT(id_cad_projeto) FROM tb_projeto_cad_terceirizado)\r\n \t\t\t\t\t\t\t\tAND A.excluido IS NULL\r\n\t\t\t\t\t\t\t\t" . $empresa . $obra . $fase . $disciplina . $tipo_documento . $valida_sql . ") AS Z\r\n \t\t\t\t\t\t\t\tORDER BY \tnome_empresa,\r\n\t\t\t\t\t\t\t\t\t\t\tcod_obra,\r\n\t\t\t\t\t\t\t\t\t\t\tcod_fase,\r\n \t\t\t\t\t\t\t\t\t\t\tcod_tipo_documento,\r\n\t\t\t\t\t\t\t\t\t\t\tcod_disciplina");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {
/* 		border-spacing: 0px; */

예제 #15

0

파일 보기

파일: relatorio_sintetico_finalizados.php 프로젝트: hexti/troncal

} else {
    $tipo_documento = " id_tipo_documento = " . $lista->getTipoDeDocumento() . " AND";
    $query = mysql_query("SELECT nome FROM " . MYSQL_BASE_TIPO_DOCUMENTOS . " WHERE id =" . $lista->getTipoDeDocumento());
    while ($row = mysql_fetch_array($query)) {
        $filtro_tipo = $row['nome'];
    }
}
$query = '';
if (!empty($obra) || !empty($disciplina) || !empty($tipo_documento)) {
    $where = " WHERE " . $obra . $disciplina . $tipo_documento . $data;
    $where = substr($where, 0, -4);
} else {
    $where = " WHERE " . $data;
    $where = substr($where, 0, -4);
}
$resultado = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\tCOUNT(id) AS total, \r\n\t\t\t\t\t\t\t\tcodigo_obra,\r\n\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\tcodigo_disciplina,\r\n\t\t\t\t\t\t\t\tnome_disciplina,\r\n\t\t\t\t\t\t\t\tcodigo_tipo_documento,\r\n\t\t\t\t\t\t\t\tnome_tipo_documento\r\n\t\t\t\t\t\t\tFROM vw_relatorio_projetos_finalizados \r\n\t\t\t\t\t\t\t" . $where . " \r\n\t\t\t\t\t\t\tGROUP BY \r\n\t\t\t\t\t\t\t\tid_obra_codigo,\r\n\t\t\t\t\t\t\t\tid_disciplina, \r\n\t\t\t\t\t\t\t\tid_tipo_documento\r\n\t\t\t\t\t\t\tORDER BY codigo_obra, codigo_disciplina, codigo_tipo_documento");
$rowCount = $resultado->rowCount();
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Cons&oacute;rcio Troncal Bel&eacute;m - Relat&oacute;rio de Projeto</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
	
<script type="text/javascript">

</script>

<style>
	table {

예제 #16

0

파일 보기

파일: controle_projeto_cliente.php 프로젝트: hexti/troncal

if (!empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND (data_entrada BETWEEN '" . $dataInicio . " 00:00:00' AND '" . $dataFim . " 23:59:59' )";
    $valida_sql = ' AND A.id = 0';
}
//Verifica se so a data inicial foi digitada
if (!empty($dataInicio) && empty($dataFim)) {
    $data .= " AND data_entrada >= '" . $dataInicio . " 00:00:00' ";
    $valida_sql = ' AND A.id = 0';
}
//Verifica se so a data final foi digitada
if (empty($dataInicio) && !empty($dataFim)) {
    $data .= " AND data_entrada <= '" . $dataFim . " 23:59:59' ";
    $valida_sql = ' AND A.id = 0';
}
$status = " AND status IN ('" . $aprovado . "','" . $reprovado . "','" . $aprovado_comentario . "','" . $em_analise . "','" . $pendente . "')";
$total_geral = $DAO->Listar("SELECT COUNT(id_documento) AS total_geral\r\n\t\t\t\t\t\t\t\t\tFROM vw_relatorio_analitico_cliente WHERE id_documento != '' " . $status . $data);
if ($_POST['r_obra_fase'] == 'S') {
    $resumo_por_fase = $DAO->Listar("SELECT \r\n \t\t\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\tnome_fase,\r\n\t\t\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(id_documento) AS total\r\n\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\tvw_relatorio_analitico_cliente \t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\tWHERE id_documento != ''\r\n\t\t\t\t\t\t\t\t\t\t\t  " . $status . $data . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY \r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\tnome_fase,\r\n\t\t\t\t\t\t\t\t\t\t\tstatus ASC");
}
if ($_POST['r_produto'] == 'S') {
    $resumo_por_tipo = $DAO->Listar("SELECT \t\r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\tnome_tipo,\r\n\t\t\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(id_documento) AS total\r\n\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\tvw_relatorio_analitico_cliente \t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\tWHERE id_documento != ''\r\n\t\t\t\t\t\t\t\t\t\t\t  " . $status . $data . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY \r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\tnome_tipo,\r\n\t\t\t\t\t\t\t\t\t\t\tstatus ASC");
}
if ($_POST['r_obra_disciplina'] == 'S') {
    $resumo_por_obra_disciplina = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\t\tnome_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\t\t\t\tCOUNT(id_documento) AS total\r\n\t\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\t\tvw_relatorio_analitico_cliente \t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE id_documento != ''\r\n\t\t\t\t\t\t\t\t\t\t\t\t  " . $status . $data . "\r\n\t\t\t\t\t\t\t\t\t\t\tGROUP BY nome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t nome_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t status");
}
if ($_POST['r_disciplina'] == 'S') {
    $resumo_por_disciplina = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\tnome_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(id_documento) AS total\r\n\t\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\t\tvw_relatorio_analitico_cliente \t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE id_documento != ''\r\n\t\t\t\t\t\t\t\t\t\t\t\t  " . $status . $data . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY nome_disciplina,\r\n\t\t\t\t\t\t\t\t\t\t\t\t status");
}
if ($_POST['r_obra'] == 'S') {
    $resumo_por_obra = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\tnome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\t\t\tCOUNT(id_documento) AS total\r\n\t\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\t\tvw_relatorio_analitico_cliente \t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE id_documento != ''\r\n\t\t\t\t\t\t\t\t\t\t\t\t  " . $status . $data . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY nome_obra,\r\n\t\t\t\t\t\t\t\t\t\t\t\t status");
}

PHP ListaDao::Listar 예제들