PHP Remessa примеры использования

Пример #1

Файл: download.php Проект: hexti/troncal

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
if (!empty($_GET['arquivo'])) {
    $nome_arquivo = $_GET['arquivo'];
    //file location
    // 	    header("Content-type: application/vnd.ms-excel");
    header("Content-type: application/force-download");
    header('Content-Disposition: attachment; filename="' . basename($nome_arquivo) . '"');
    readfile('../../arquivos/remessa/' . $nome_arquivo);
    //  ../../arquivos/remessa
    header("Pragma: no-cache");
} else {
    $lista = $_GET['lista'];
    $remessa = new Remessa();
    $DAO = new RemessaDAO();
    $res = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista =" . $lista);
    foreach ($res as $item) {
        $remessa->setFile($item['file']);
        $nome_arquivo = $remessa->getFile();
        //file location
        // 	    header("Content-type: application/vnd.ms-excel");
        header("Content-type: application/force-download");
        header('Content-Disposition: attachment; filename="' . basename($nome_arquivo) . '"');
        readfile('../../arquivos/' . $nome_arquivo);
        header("Pragma: no-cache");
    }
}
?>

Пример #2

Файл: view_grd.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../Remessa.class.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
if (!in_array(165, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
$id = limpaTexto($_GET['id']);
$remessa = new Remessa();
$DAO = new RemessaDAO();
$sql_lista = $DAO->Listar("SELECT A.id, A.criado, B.nome, C.nome_completo, A.id_empresa, C.id AS id_usuario\r\n\t\t\t\t\t\t\tFROM " . MYSQL_BASE_REMESSA_LISTAS . " A \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_EMPRESAS . " B ON A.id_empresa = B.id \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " C ON A.id_usuario = C.id\r\n\t\t\t\t\t\t\tWHERE A.id =" . $id);
foreach ($sql_lista as $item) {
    $remessa->setId($item['id']);
    $remessa->setCriado($item['criado']);
    $remessa->setEmpresa($item['nome']);
    $remessa->setIdEmpresa($item['id_empresa']);
    $remessa->setIdUsuario($item['id_usuario']);
    $remessa->setNome($item['nome_completo']);
}
$resultado = $DAO->Listar("SELECT \tA.id_remessa_lista, \r\n\t\t\t\t\t\t\t\t\tSUBSTRING(A.file,4,35) AS cod_doc, \r\n\t\t\t\t\t\t\t\t\tB.nome_completo, \r\n\t\t\t\t\t\t\t\t\tC.nome AS obra, \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 disciplina, \r\n\t\t\t\t\t\t\t\t\tSUBSTRING(A.file,37,2) AS revisao \r\n\t\t\t\t\t\t\tFROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " A \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " B ON B.id = A.id_usuario \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " C ON C.codigo = SUBSTRING(A.file,16,3) \r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.codigo = SUBSTRING(A.file,26,3) \r\n\t\t\t\t\t\t\tWHERE excluido IS NULL \r\n\t\t\t\t\t\t\tAND A.id_remessa_lista =" . $id);
?>

<style>
	table {
/* 		border-spacing: 0px; */
/* 		border-collapse: collapse; */
		width: 800px;
	}

Пример #3

Файл: edit.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
$remessa->setId(limpaTexto($_GET['lista']));
if (!in_array(235, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'editar') {
    $msg_erro = NULL;
    $msg_sucesso = NULL;
    $file = $_FILES['file'];
    $remessa->setFile($file['name']);
    $remessa->setTitulo($_POST['titulo']);
    $remessa->setIdArquivo($_POST['id']);
    if ($file['error'] == UPLOAD_ERR_NO_FILE) {
        $res = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id = " . $remessa->getIdArquivo());
        foreach ($res as $item) {
            $remessa->setFile($item['file']);
        }
        $num = 1;
    } else {
        $res = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE file = '" . $file['name'] . "' AND excluido IS NULL");
        $num = $res->rowCount();
    }

Пример #4

Файл: arquivo.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$remessa->setId(0);
$DAO = new RemessaDAO();
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
    $remessa->salvarTitulos($_FILES['files']);
}
if (!empty($_GET['id'])) {
    $remessa->setId(limpaTexto($_GET['id']));
}
?>
<!-- topbar ends -->
<div class="container-fluid">
	<div class="row-fluid">

		<!-- left menu starts -->
		<div class="span2 main-menu-span">
				<?php 
include_once '../menu.php';
?>
			</div>
		<!--/span-->
		<!-- left menu ends -->

Пример #5

Файл: index.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
if (!in_array(165, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
    $id = limpaTexto($_GET['id']);
    $retorno = $DAO->DeletarLista($id);
    if ($retorno == 1) {
        echo '<script language= "JavaScript">alert("Lista removida com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="index.php";</script>';
    } else {
        echo '<script language= "JavaScript">alert("Erro ao remover o registro.");</script>';
    }
}
/*Download compactado*/
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'compact') {
    $remessa->zipar(limpaTexto($_GET['id']));
}
// echo gethostname();
?>
	<!-- topbar ends -->
		<div class="container-fluid">
		<div class="row-fluid">

Пример #6

Файл: RemessaDAO_ListaProjetoConcluido.php Проект: hexti/troncal

 public function Listar($query = null)
 {
     try {
         $remessa = new Remessa();
         if ($query == null) {
             $stmt = $this->p->query("SELECT rl.*, \r\n\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista = rl.id AND excluido IS NULL) as total, \r\n\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista = rl.id AND finalizado IS NOT NULL AND excluido IS NULL) as total_finalizado,\r\n\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(id) FROM " . MYSQL_BASE_REMESSA_ARQUIVOS . " WHERE id_remessa_lista = rl.id AND titulo IS NOT NULL AND excluido IS NULL) as total_titulo, \r\n\t\t\t\t\t\t\t\t\t\t\te.nome, \r\n\t\t\t\t\t\t\t\t\t\t\tp.nome_completo \r\n\t\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_REMESSA_LISTAS . " rl, \r\n\t\t\t\t\t\t\t\t\t\t\t " . MYSQL_BASE_PESSOAS . " p, \r\n\t\t\t\t\t\t\t\t\t\t\t " . MYSQL_BASE_EMPRESAS . " e \r\n\t\t\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\t\tp.id = rl.id_usuario \r\n\t\t\t\t\t\t\t\t\t\tAND e.id = rl.id_empresa \r\n\t\t\t\t\t\t\t\t\t\tAND rl.excluido IS NULL \r\n\t\t\t\t\t\t\t\t\t\tAND rl.tipo = 'P' \r\n\t\t\t\t\t\t\t\t\t\tAND rl.finalizado IS NULL \r\n\t\t\t\t\t\t\t\t\t\tORDER BY rl.criado DESC ");
             $count = 0;
             $confirm = "return confirm('Deseja remover esse registro?');";
             $user = userId();
             connectSQL();
             foreach ($stmt as $item) {
                 $query = mysql_query("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\tD.nome,\r\n\t\t\t\t\t\t\t\t\t\t\tD.id,\r\n\t\t\t\t\t\t\t\t\t\t\tPO.nome as obra,\r\n\t\t\t\t\t\t\t\t\t\t\tFP.nome as fase,\r\n\t\t\t\t\t\t\t\t\t\t\tTD.nome as tipo\r\n\t\t\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_REMESSA_ARQUIVOS . " RA\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_DISCIPLINAS . " D ON D.id = RA.id_disciplina\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PROJETO_OBRA . " PO ON PO.id = RA.id_obra\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_FASE_PROJETOS . " FP ON FP.id = RA.id_fase_projeto\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_TIPO_DOCUMENTOS . " TD ON TD.id = RA.id_tipo_documento\r\n\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\tRA.id_remessa_lista = " . $item['id'] . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY D.nome");
                 $disciplina = " ";
                 $obra = " ";
                 $fase = " ";
                 $tipo = " ";
                 $id_disc = " ";
                 while ($row = mysql_fetch_array($query)) {
                     $disciplina .= " " . $row['nome'] . ',';
                     $id_disc = $row['id'] . ',';
                     $obra .= " " . $row['obra'] . ',';
                     $tipo .= " " . $row['tipo'] . ',';
                     $fase .= " " . $row['fase'] . ',';
                 }
                 $disciplina = substr($disciplina, 0, -1);
                 $obra = substr($obra, 0, -1);
                 $tipo = substr($tipo, 0, -1);
                 $fase = substr($fase, 0, -1);
                 $id_disc = substr($id_disc, 0, -1);
                 $query = mysql_query("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\tP.nome_completo \r\n\t\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_PESSOAS . " P\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_RESPONSAVEL_DISCIPLINA . " RD ON RD.verificador = P.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\tRD.id_disciplina IN (" . $id_disc . ") AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.aprovador_verificador = 'V' AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY P.id");
                 $verificador = " ";
                 while ($row = mysql_fetch_array($query)) {
                     $explode = explode(' ', $row['nome_completo']);
                     $verificador .= " " . $explode[0] . ',';
                 }
                 $verificador = substr($verificador, 0, -1);
                 $query_aprovador = mysql_query("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\tP.nome_completo\r\n\t\t\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_PESSOAS . " P\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_RESPONSAVEL_DISCIPLINA . " RD ON RD.verificador = P.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\tRD.id_disciplina IN (" . $id_disc . ") AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.aprovador_verificador = 'A' AND\r\n\t\t\t\t\t\t\t\t\t\t\tRD.excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY P.id");
                 $aprovador = " ";
                 while ($row = mysql_fetch_array($query_aprovador)) {
                     $explode = explode(' ', $row['nome_completo']);
                     $aprovador .= " " . $explode[0] . ',';
                 }
                 $aprovador = substr($aprovador, 0, -1);
                 echo '<tr>';
                 echo '	<td style="display: none;">' . $count . '</td>';
                 echo '	<td>Lista ' . $item['id'] . '</td>';
                 echo '	<td>' . $obra . '</td>';
                 echo '	<td>' . $fase . '</td>';
                 echo '	<td>' . $disciplina . '</td>';
                 echo '	<td>' . $tipo . '</td>';
                 echo '	<td>' . $verificador . '</td>';
                 echo '	<td>' . $aprovador . '</td>';
                 echo '	<td>' . dataBrasil($item['criado'], false) . '</td>';
                 echo '	<td>' . $item['total_finalizado'] . '/' . $item['total'] . '</td>';
                 echo '	<td>' . $item['nome_completo'] . '</td>';
                 echo '	<td>' . $item['nome'] . '</td>';
                 echo '	<td>';
                 $count += 1;
                 if (in_array(165, listarAcesso())) {
                     echo '			<a data-rel="tooltip" data-original-title="Visualizar" class="btn btn-info" href="view.php?id=' . $item['id'] . '">';
                     echo '			<i class="icon-eye-open icon-white"></i>';
                     echo '		</a>';
                 }
                 //Gerar FED
                 if (in_array(165, listarAcesso())) {
                     echo '			<a data-rel="tooltip" data-original-title="FED" class="btn btn-info" target="_blank" href="view_grd.php?id=' . $item['id'] . '">';
                     echo '			<i class="icon-list-alt icon-white"></i>';
                     echo '		</a>';
                 }
                 //Verifica se pode fazer download
                 if (in_array(165, listarAcesso()) && $item['total'] > 0) {
                     echo '			<a data-rel="tooltip" title="Download" class="btn btn-inverse" href="index.php?cmd=compact&id=' . $item['id'] . '">';
                     echo '			<i class="icon-download-alt icon-white"></i>';
                     echo '		</a>';
                 }
                 if ($item['id_usuario'] == $user) {
                     echo '		<a data-rel="tooltip" title="Deletar" class="btn btn-danger" onclick="' . $confirm . '" href="index.php?lista=' . $remessa->getId() . '&cmd=del&id=' . $item['id'] . '">';
                     echo '			<i class="icon-trash icon-white"></i>';
                     echo '		</a>';
                 }
                 if (in_array(210, listarAcesso())) {
                     if ($item['total_titulo'] < $item['total']) {
                         echo '		<a data-rel="tooltip" title="Arquivo CSV" class="btn btn-info" href="arquivo.php?id=' . $item['id'] . '">';
                         echo '			<i class="icon-file icon-white"></i>';
                         echo '		</a>';
                     }
                 }
                 echo '	</td>';
                 echo '</tr>';
             }
         } else {
             $stmt = $this->p->query($query);
             return $stmt;
         }
         $this->p = null;
     } catch (PDOException $ex) {
         echo "Erro: " . $ex->getMessage();
     }
 }

Пример #7

Файл: view.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(165, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
$remessa = new Remessa();
$DAO = new RemessaDAO();
$remessa->setId(limpaTexto($_GET['id']));
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
    $id = ValidateInteger(INPUT_GET, 'id');
    $retorno = $DAO->DeletarArquivo($id);
    if ($retorno == 1) {
        echo '<script language= "JavaScript">alert("Categoria removido com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="view.php?id=' . $_GET['lista'] . '";</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">

Пример #8

Файл: new.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
if (!in_array(166, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
connectSQL();
$msg_codigo_erro = "";
$validador = 0;
$inseridos = 0;
$remessa = new Remessa();
$get = NULL;
if (!empty($_GET['id'])) {
    $get = "?id=" . $_GET['id'];
    $remessa->setId($_GET['id']);
}
//Verifica se a opcao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'inserir') {
    $msg_success = NULL;
    $erros = 0;
    $DAO = new RemessaDAO();
    $msg_erro = NULL;
    $msg_not_insert = NULL;
    $file_ary = reArrayFiles($_FILES['files']);
    $msg_codigo_erro = "";
    $count = 0;

Пример #9

Файл: upload.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
include_once '../../projeto/CheckList.class.php';
session_start();
$acesso = listarAcesso();
$remessa = new Remessa();
$cheklist = new CheckList();
$array_disciplina = array();
$DAO = new RemessaDAO();
connectSQL();
// foreach ($_FILES["images"]["error"] as $key => $error) {
//     if ($error == UPLOAD_ERR_OK) {
//         $name = $_FILES["images"]["name"][$key];
//         move_uploaded_file( $_FILES["images"]["tmp_name"][$key], "uploads/" . $_FILES['images']['name'][$key]);
//     }
// }
// echo "<h2>Successfully Uploaded Images</h2>";
$user = userId();
if ($user == 82) {
    $empresa = 8;
} else {
    $resultado = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\tE.id\r\n\t\t\t\t\t\t\tFROM " . MYSQL_BASE_EMPRESAS . " E\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_CARGOS . " C ON C.id_empresa = E.id\r\n\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " P ON P.id_cargo = C.id\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tP.id=" . $user);
    $empresa = 10;
    foreach ($resultado as $item) {
        //if($item['id'] == 10 || $item['id'] == 9 || $item['id'] == 8 || $item['id'] == 21){
        $empresa = $item['id'];
        //}

Пример #10

Файл: view.php Проект: hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/RemessaDAO.php';
include_once '../Remessa.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once '../../head.php';
$remessa = new Remessa();
$DAO = new RemessaDAO();
$remessa->setId(limpaTexto($_GET['id']));
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
    $id = ValidateInteger(INPUT_GET, 'id');
    $retorno = $DAO->Deletar($id);
    if ($retorno == 1) {
        echo '<script language= "JavaScript">alert("Categoria 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 
include_once '../menu.php';
?>