function listarAnexo($medicao) { $DAO = new MedicaoDao(); $medicao = new Medicao(); $resultado = $DAO->Listar(); foreach ($resultado as $item) { } }
<?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órcio Troncal Belém - Relatório de Pessoal</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" /> <script type="text/javascript"> </script> <style> table {
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; }