NaoReembolsavelDAO PHP代码示例

示例#1

0

显示文件

文件： new.php 项目： hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once INTERNAL_ROOT_PORTAL . '/includes.sys/metodos.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/DAO/NaoReembolsavelDAO.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/NaoReembolsavel.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
if (!in_array(269, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
//Verifica se a opcao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'salvar') {
    $DAO = new NaoReembolsavelDAO();
    $naoreembolsavel = new NaoReembolsavel();
    $naoreembolsavel->setNome($_POST['nome']);
    $naoreembolsavel->setUsuario(userId());
    $resultado = $DAO->Gravar($naoreembolsavel);
    if ($resultado == 1) {
        echo '<script language= "JavaScript">alert("Registro cadastrado com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="index.php";</script>';
    } else {
        echo '<script language= "JavaScript">alert("Erro ao gravar o registro, favor entrar em contato com a TI.");</script>';
    }
}
?>
<!-- topbar ends -->
<div class="container-fluid">
	<div class="row-fluid">

		<!-- left menu starts -->

示例#2

0

显示文件

文件： NaoReembolsavel.class.php 项目： hexti/troncal

 function listarNaoReembolsaveis($id)
 {
     $DAO = new NaoReembolsavelDAO();
     $resultado = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\t\t\tA.id, \r\n\t\t\t\t\t\t\t\t\t\tB.nome,\r\n\t\t\t\t\t\t\t\t\t\tA.quantidade,\r\n\t\t\t\t\t\t\t\t\t\tA.valor,\r\n\t\t\t\t\t\t\t\t\t\tC.nome as empresa\r\n\t\t\t\t\t\t\t\t  FROM tb_medicao_naoreembolsavel_item A\r\n\t\t\t\t\t\t\t\t  INNER JOIN \r\n\t\t\t\t\t\t\t\t\t\ttb_medicao_naoreembolsavel B ON A.id_naoreembolsavel = B.id\r\n\t\t\t\t\t\t\t\t  INNER JOIN \r\n\t\t\t\t\t\t\t\t\t\ttb_empresa C ON A.id_empresa = C.Id \r\n\t\t\t\t\t\t\t\t  WHERE \r\n\t\t\t\t\t\t\t\t\t\tA.id_medicao = " . $id . " AND \r\n\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\tB.excluido IS NULL\r\n\t\t\t\t\t\t\t\t  ORDER BY A.id DESC");
     $confirm = "return confirm('Deseja remover esse registro?');";
     foreach ($resultado as $item) {
         echo '<tr>';
         echo '	<td>' . $item['nome'] . '</td>';
         echo '	<td class="center">' . number_format($item['quantidade'], 3, ',', '.') . '</td>';
         echo '	<td class="center">' . number_format($item['valor'], 2, ',', '.') . '</td>';
         echo '	<td>' . $item['empresa'] . '</td>';
         echo '		<td><a class="btn btn-info" href="anexo_naoReembolsavelEdit.php?id=' . $item['id'] . '">';
         echo '			<i class="icon-edit icon-white"></i> Editar';
         echo '		</a>';
         echo '		<a class="btn btn-danger" onclick="' . $confirm . '" href="anexo_naoReembolsavel.php?cmd=del&id=' . $id . '&item=' . $item['id'] . '">';
         echo '			<i class="icon-trash icon-white"></i> Deletar';
         echo '		</a>';
         echo '</tr>';
     }
 }

示例#3

0

显示文件

文件： anexo_naoReembolsavel.php 项目： hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once INTERNAL_ROOT_PORTAL . '/includes.sys/metodos.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/DAO/MedicaoDAO.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/Medicao.class.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/Item.class.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/NaoReembolsavel.class.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/DAO/NaoReembolsavelDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
$DAO = new MedicaoDAO();
$medicao = new Medicao();
$item_medicao = new Item();
$naoreembolsavel = new NaoReembolsavel();
$NRDAO = new NaoReembolsavelDAO();
$id = limpaTexto($_GET['id']);
$naoreembolsavel->setIdMedicao($id);
$query = mysql_query("SELECT id FROM " . MYSQL_BASE_PRESTACAO_CONTAS . " WHERE finalizado IS NULL AND id = " . $id);
if (mysql_num_rows($query) == 0) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
//verifica NUMERO da medi��o
$query = mysql_query("SELECT \r\n\t\t\t\t\t\tMONTHNAME(data_referencia) as mes, \r\n\t\t\t\t\t\tYEAR(data_referencia) as ano,\r\n\t\t\t\t\t\tM.id \r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\t" . MYSQL_BASE_MEDICAO . " M \r\n\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PRESTACAO_CONTAS . " PC ON MONTH(PC.data_referencia) = MONTH(M.ref_inicio) AND YEAR(PC.data_referencia) = YEAR(M.ref_inicio)\r\n\t\t\t\t\tWHERE PC.id=" . $id . " LIMIT 1");
while ($row = mysql_fetch_array($query)) {
    $data = $row['mes'] . ' de ' . $row['ano'];
    $id_medicao = $row['id'];
}
if (!in_array(54, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}

示例#4

0

显示文件

文件： anexo_naoReembolsavelEdit.php 项目： hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once INTERNAL_ROOT_PORTAL . '/includes.sys/metodos.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/DAO/MedicaoDAO.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/Medicao.class.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/Item.class.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/NaoReembolsavel.class.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/DAO/NaoReembolsavelDAO.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
$DAO = new MedicaoDAO();
$medicao = new Medicao();
$item_medicao = new Item();
$naoreembolsavel = new NaoReembolsavel();
$NRDAO = new NaoReembolsavelDAO();
$naoreembolsavel->setId(limpaTexto($_GET['id']));
//verifica NUMERO da medi��o
$query = mysql_query("SELECT * FROM " . MYSQL_BASE_MEDICAO . " WHERE id=" . $naoreembolsavel->getId());
while ($row = mysql_fetch_array($query)) {
    $numero_medicao = $row['numero'];
    if ($row['id_contrato'] == 1) {
        $tipo_medicao = 'Contrato';
    } else {
        $tipo_medicao = 'Aditivo';
    }
}
if (!in_array(54, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="index.php";</script>';
}
//Verifica se foi executado a acao de salvar item

示例#5

0

显示文件

文件： index.php 项目： hexti/troncal

<?php

include_once '../../includes.sys/ini.php';
include_once INTERNAL_ROOT_PORTAL . '/includes.sys/metodos.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/DAO/NaoReembolsavelDAO.php';
include_once INTERNAL_ROOT_PORTAL . '/medicao/NaoReembolsavel.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
include_once INTERNAL_ROOT_PORTAL . '/head.php';
if (!in_array(268, listarAcesso())) {
    echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/modulos.php";</script>';
}
$contrato = new NaoReembolsavel();
$DAO = new NaoReembolsavelDAO();
if (!empty($_GET['cmd']) && $_GET['cmd'] == 'del') {
    $id = ValidateInteger(INPUT_GET, 'id');
    $retorno = $DAO->Deletar($id);
    if ($retorno == 1) {
        echo '<script language= "JavaScript">alert("Nao Reemvolsavel removido com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="index.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

示例#6

0

显示文件

文件： edit.php 项目： hexti/troncal

$id = limpaTexto($_GET['id']);
$naoreembolsavel = new NaoReembolsavel();
//Verifica se a opcao de salvar foi iniciada
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'editar') {
    $DAO = new NaoReembolsavelDAO();
    $naoreembolsavel->setNome($_POST['nome']);
    $naoreembolsavel->setId($id);
    $resultado = $DAO->Atualizar($naoreembolsavel);
    if ($resultado == 1) {
        echo '<script language= "JavaScript">alert("Registro cadastrado com sucesso");</script>';
        echo '<script language= "JavaScript">location.href="index.php";</script>';
    } else {
        echo '<script language= "JavaScript">alert("Erro ao gravar o registro, favor entrar em contato com a TI.");</script>';
    }
} else {
    $DAO = new NaoReembolsavelDAO();
    $resultado = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_MEDICAO_NAOREEMBOLSAVEL . " WHERE excluido IS NULL AND id=" . $id);
    foreach ($resultado as $item) {
        $naoreembolsavel->setNome($item['nome']);
    }
}
?>
<!-- topbar ends -->
<div class="container-fluid">
	<div class="row-fluid">

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

PHP NaoReembolsavelDAO示例