Example #1
0
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>';
}
//Verifica se foi executado a acao de salvar item
if (!empty($_POST['cmd']) && $_POST['cmd'] == 'novo') {