CadastroDAO PHPのコード例

コード例 #1

0

ファイルを表示

ファイル: new.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');
include_once '../../head.php';
if (!in_array(73, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$cadastro = new Cadastro();
$DAO = new CadastroDAO();
//Verifica se a acao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
    $cadastro->setProjetoRelacionado($_POST['projeto_relacionado']);
    $cadastro->setTraducao($_POST['traducao']);
    $cadastro->setGrupo($_POST['grupo']);
    $cadastro->setEmpresa($_POST['empresa']);
    $cadastro->setUsuario(userId());
    /*observacao - vai ser gravada em uma tabela diferente*/
    $cadastro->setObservacao($_POST['comentario']);
    /*Arquivos Atual*/
    if ($_FILES['file_atual']['name'] != '') {
        $file_atual = $_FILES['file_atual'];
        $uploadDir = '../../arquivos/';
        $name_atual = sha1(date("d-m-Y H:i:s") . '-A');
        $uploadFile = $uploadDir . $name_atual;
        $extension = pathinfo($file_atual['name'], PATHINFO_EXTENSION);
        $uploadFile = $uploadFile . '.' . $extension;
        $name_atual = $name_atual . '.' . $extension;

コード例 #2

0

ファイルを表示

ファイル: finalizados.php プロジェクト: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once "../DAO/CadastroDAO.php";
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
if (!in_array(72, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
$DAO = new CadastroDAO();
$cadastro = new Cadastro();
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'reabrir') {
    $id = ValidateInteger(INPUT_GET, 'id');
    $retorno = $DAO->Reabrir($id);
    if ($retorno == 1) {
        $msg = 'Tradu&ccedil;&atilde;o Reaberto com sucesso';
        echo '<script language= "JavaScript">alert("' . $msg . '");</script>';
        echo '<script language= "JavaScript">location.href="finalizados.php";</script>';
    } else {
        print_r($retorno);
    }
}
?>
	<!-- topbar ends -->
		<div class="container-fluid">
		<div class="row-fluid">
				
			<!-- left menu starts -->
			<div class="span2 main-menu-span">
				<?php

コード例 #3

0

ファイルを表示

ファイル: inserir_documento.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');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
if (!in_array(66, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$cadastro = new Cadastro();
$DAO = new CadastroDAO();
//Verifica se a acao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'finaliza') {
    $cadastro->setId($_POST['id']);
    $cadastro->setObservacao($_POST['comentario']);
    /*Arquivos Traduzido*/
    $file = $_FILES['file'];
    $uploadDir = '../../arquivos/';
    $name = sha1(date("d-m-Y H:i:s") . '-A');
    $uploadFile = $uploadDir . $name;
    $extension = pathinfo($file['name'], PATHINFO_EXTENSION);
    $uploadFile = $uploadFile . '.' . $extension;
    $name = $name . '.' . $extension;
    /*Subir o arquivo*/
    move_uploaded_file($file['tmp_name'], $uploadFile);
    // 	echo $cadastro->getObservacao() .' - '. $cadastro->getId().' - '. 'T'.' - '. userId();
    // 	break;
    //Verifica se o nome foi preenchido
    if ($cadastro->getId() != NULL && $_FILES['file']['error'] != 4) {

コード例 #4

0

ファイルを表示

ファイル: rel_concluido.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');
$cadastro = new Cadastro();
$DAO = new CadastroDAO();
?>

<!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" />
	
<style>
	table {
		width: auto;
	}
	
	table.corpo {
		border-spacing: 0px;
		border-collapse: collapse;
		width: 623px;
	}
	
	td{
 		font-family: "Arial"; 
    	font-size: 9pt;

コード例 #5

0

ファイルを表示

ファイル: Documento.class.php プロジェクト: hexti/troncal

 function listarProjeto($id_check_list = null)
 {
     $DAO = new CadastroDAO();
     $retorno = $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    A.nome_arquivo,\r\n\t\t\t\t\t\t\t\t\tB.nome AS disciplina\r\n\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_CHECK_LISTS . " A\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " B ON A.id_disciplina = B.id\r\n\t\t\t\t\t\t\t\tWHERE A.ativo = 'S' AND \r\n\t\t\t\t\t\t\t\t\t  A.status IN ('A', 'AC')");
     foreach ($retorno as $item) {
         if ($item['id'] == $id_check_list) {
             echo '<option selected="selected" value="' . $item['id'] . '">' . $item['nome_arquivo'] . ' (' . $item['disciplina'] . ')</option>';
         } else {
             echo '<option value="' . $item['id'] . '">' . $item['nome_arquivo'] . ' (' . $item['disciplina'] . ')</option>';
         }
     }
 }

コード例 #6

0

ファイルを表示

ファイル: Cadastro.class.php プロジェクト: hexti/troncal

 function listarEmpresa($id = null)
 {
     $DAO = new CadastroDAO();
     $retorno = $DAO->Listar("SELECT id, nome FROM " . MYSQL_BASE_EMPRESAS . " WHERE ativo = 'S'");
     foreach ($retorno as $item) {
         if ($item['id'] == $id) {
             echo '<option selected="selected" value="' . $item['id'] . '">' . $item['nome'] . '</option>';
         } else {
             echo '<option value="' . $item['id'] . '">' . $item['nome'] . '</option>';
         }
     }
 }

コード例 #7

0

ファイルを表示

ファイル: view.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');
include_once '../../head.php';
if (!in_array(282, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$cadastro = new Cadastro();
$DAO = new CadastroDAO();
$cadastro->setId($_GET['id']);
$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(B.nome_arquivo, 1, 35) AS nome_arquivo, \r\n\t\t\t\t\t\t\t\t\tA.traducao,\r\n\t\t\t\t\t\t\t\t\tB.nome_arquivo AS arquivo_atual,\r\n\t\t\t\t\t\t\t\t\tA.arquivo_ingles,\r\n\t\t\t\t\t\t\t\t\tC.comentario,\r\n\t\t\t\t\t\t\t\t\tC.id AS id_comentario,\r\n\t\t\t\t\t\t\t\t\tD.nome AS disciplina\r\n\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_TRADUCAO_DOCUMENTOS . " A\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_CHECK_LISTS . " B ON A.id_check_list = B.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . MYSQL_BASE_TRADUCAO_COMENTARIOS . " C ON A.id = C.id_documento\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON B.id_disciplina = D.id\r\n\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\tA.excluido IS NULL\r\n\t\t\t\t\t\t\t\tAND B.status IN ('A', 'AC')\r\n\t\t\t\t\t\t\t\tAND C.pertence = 'U'\r\n\t\t\t\t\t\t\t\tAND A.id=" . $cadastro->getId() . "\r\n\t\t\t\t\t\t\t\tUNION ALL\r\n\t\t\t\t\t\t\t\tSELECT \t\r\n\t\t\t\t\t\t\t\t\tA.id, \r\n\t\t\t\t\t\t\t\t\tB.nome AS nome_arquivo, \r\n\t\t\t\t\t\t\t\t\tA.traducao,\r\n\t\t\t\t\t\t\t\t\tB.arquivo AS arquivo_atual,\r\n\t\t\t\t\t\t\t\t\tA.arquivo_ingles,\r\n\t\t\t\t\t\t\t\t\tC.comentario,\r\n\t\t\t\t\t\t\t\t\tC.id AS id_comentario,\r\n\t\t\t\t\t\t\t\t\t'' AS disciplina\r\n\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_TRADUCAO_DOCUMENTOS . " A\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_TRADUCAO_ARQUIVOS . " B ON SUBSTRING(A.id_check_list, 3, 11) = B.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN " . MYSQL_BASE_TRADUCAO_COMENTARIOS . " C ON A.id = C.id_documento\r\n\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\tA.excluido IS NULL\r\n\t\t\t\t\t\t\t\tAND C.pertence = 'U'\r\n\t\t\t\t\t\t\t\tAND A.id=" . $cadastro->getId() . "\r\n\t\t\t\t\t\t\t\tGROUP BY A.id");
if ($resultado) {
    foreach ($resultado as $item) {
        $cadastro->setProjetoRelacionado($item['nome_arquivo']);
        $cadastro->setDisciplina($item['disciplina']);
        if ($item['arquivo_atual'] != null) {
            if ($cadastro->getDisciplina() == '') {
                $pasta_traducao = 'traducao_docs/';
            } else {
                $pasta_traducao = '';
            }
            $arquivo_atual = '<a href="' . EXTERNAL_ROOT_PORTAL . '/arquivos/' . $pasta_traducao . $item['arquivo_atual'] . '" target="_blank">Baixar</a>';
        } else {
            $arquivo_atual = '';
        }
        if ($item['arquivo_ingles'] != null) {
            $arquivo_ingles = '<a href="' . EXTERNAL_ROOT_PORTAL . '/arquivos/' . $item['arquivo_ingles'] . '" target="_blank">Baixar</a>';

コード例 #8

0

ファイルを表示

ファイル: index.php プロジェクト: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once "../DAO/CadastroDAO.php";
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
if (!in_array(282, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
// $carta = new Documento();
$DAO = new Cadastro();
$CadastroDAO = new CadastroDAO();
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
    $id = ValidateInteger(INPUT_GET, 'id');
    $retorno = $CadastroDAO->Deletar($id);
    if ($retorno == 1) {
        echo '<script language= "JavaScript">alert("Registro removido com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="index.php";</script>';
    } else {
        echo '<script language= "JavaScript">alert("Erro ao remover o registro.");</script>';
    }
}
?>
	<!-- topbar ends -->
		<div class="container-fluid">
		<div class="row-fluid">
				
			<!-- left menu starts -->
			<div class="span2 main-menu-span">
				<?php

コード例 #9

0

ファイルを表示

ファイル: edit.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');
include_once '../../head.php';
if (!in_array(284, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$cadastro = new Cadastro();
$DAO = new CadastroDAO();
//Verifica se a acao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
    $cadastro->setProjetoRelacionado($_POST['projeto_relacionado']);
    $cadastro->setTraducao($_POST['traducao']);
    $cadastro->setGrupo($_POST['grupo']);
    $cadastro->setEmpresa($_POST['empresa']);
    $cadastro->setUsuario(userId());
    $cadastro->setId($_POST['id']);
    /*observacao - vai ser gravada em uma tabela diferente*/
    $cadastro->setObservacao($_POST['comentario']);
    $cadastro->setIdObservacao($_POST['id_comentario']);
    /*Arquivos Atual*/
    if ($_FILES['file_atual']['name'] != '') {
        $file_atual = $_FILES['file_atual'];
        $uploadDir = '../../arquivos/';
        $name_atual = sha1(date("d-m-Y H:i:s") . '-A');
        $uploadFile = $uploadDir . $name_atual;
        $extension = pathinfo($file_atual['name'], PATHINFO_EXTENSION);

コード例 #10

0

ファイルを表示

ファイル: rel_pendencia.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');
$cadastro = new Cadastro();
$DAO = new CadastroDAO();
?>

<!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" />
	
<style>
	table {
		width: auto;
	}
	
	table.corpo {
		border-spacing: 0px;
		border-collapse: collapse;
		width: 623px;
	}
	
	td{
 		font-family: "Arial"; 
    	font-size: 9pt;

PHP CadastroDAOの例