Example #1
0
 function listarAnexo($medicao)
 {
     $DAO = new MedicaoDao();
     $medicao = new Medicao();
     $resultado = $DAO->Listar();
     foreach ($resultado as $item) {
     }
 }
Example #2
0
<?php

include_once '../../includes.sys/ini.php';
include_once '../../includes.sys/metodos.php';
include_once '../DAO/MedicaoDAO.php';
include_once '../Medicao.class.php';
checkUserAuth(EXTERNAL_ROOT_PORTAL . '/index.php?error=true');
$medicao = new Medicao();
$DAO = new MedicaoDao();
$medicao->setId(limpaTexto($_GET['id']));
$sql = $DAO->Listar("SELECT DATE_FORMAT(ref_inicio, '%M de %Y') as referencia, numero FROM " . MYSQL_BASE_MEDICAO . " WHERE id = " . $medicao->getId());
$data = "";
foreach ($sql as $row) {
    $medicao->setNumeroMedicao($row['numero']);
    $data = $row['referencia'];
}
$resultado = $DAO->Listar("SELECT \r\n\t\t\t\t\t\t\t\tP.nome_completo,\r\n\t\t\t\t\t\t\t    CI.nome,\r\n\t\t\t\t\t\t\t    MIP.quantidade,\r\n\t\t\t\t\t\t\t    CI.grupo,\r\n\t\t\t\t\t\t\t    E.nome as empresa\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t" . MYSQL_BASE_MEDICAO_ITEM_PESSOA . " MIP\r\n\t\t\t\t\t\t\t    INNER JOIN " . MYSQL_BASE_PESSOAS . " P ON P.id = MIP.id_pessoa\r\n\t\t\t\t\t\t\t    INNER JOIN " . MYSQL_BASE_CONTRATO_ITEM . " CI ON CI.id = MIP.id_medicao_item\r\n\t\t\t\t\t\t\t    INNER JOIN " . MYSQL_BASE_EMPRESAS . " E ON E.id = MIP.id_empresa\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tMIP.id_medicao = " . $medicao->getId() . " AND\r\n\t\t\t\t\t\t\t    MIP.dat_excluido = '0000-00-00 00:00:00'\r\n\t\t\t\t\t\t\tORDER BY P.nome_completo, CI.grupo ASC");
?>

<!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 Pessoal</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />

<script type="text/javascript">

</script>

<style>
table {
Example #3
0
 function ComprovanteRemuneracao($file, $empresa, $medicao_id, $tipo)
 {
     $DAO = new MedicaoDao();
     $medicao = new Medicao();
     $request = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_MEDICAO . " WHERE id = " . $medicao_id);
     $name = NULL;
     $name_old = NULL;
     foreach ($request as $item) {
         if ($empresa == 1 && $tipo == 1) {
             $name = $item['comp_cmat_clt'];
         }
         if ($empresa == 1 && $tipo == 2) {
             $name = $item['comp_cmat_pj'];
         }
         if ($empresa == 3 && $tipo == 1) {
             $name = $item['comp_vetec_clt'];
         }
         if ($empresa == 3 && $tipo == 2) {
             $name = $item['comp_vetec_pj'];
         }
         $name_old = $name;
     }
     if ($file['error'] != UPLOAD_ERR_NO_FILE) {
         $uploadDir = '../../arquivos/medicao/remuneracao/';
         $name = sha1(date("d-m-Y H:i:s") . $empresa . $tipo);
         $uploadFile = $uploadDir . $name;
         $extension = pathinfo($file['name'], PATHINFO_EXTENSION);
         $uploadFile = $uploadFile . '.' . $extension;
         if (!empty($file['name'])) {
             $name = $name . '.' . $extension;
         } else {
             $name = NULL;
         }
         if (move_uploaded_file($file['tmp_name'], $uploadFile)) {
             if (!empty($name_old)) {
                 unlink("../../arquivos/remessa/" . $name_old);
             }
         }
     }
     return $name;
 }