<label class="control-label"><b>Despachar Workflow?</b></label>
<div class="controls">
<label class="radio">
<input type="radio" name="workflow" id="optionsRadios1" value="S">
Sim
</label>
<div style="clear:both"></div>
<label class="radio">
<input type="radio" name="workflow" id="optionsRadios2" value="N" checked="checked">
Não
</label>
</div>
</div>
<?php
if (isUserNTGM() == false) {
?>
<div class="control-group">
<label class="control-label"><b>NTGM Vê?</b></label>
<div class="controls">
<label class="radio">
<input type="radio" name="ntgm" id="optionsRadios1" value="S">
Sim
</label>
<div style="clear:both"></div>
<label class="radio">
<input type="radio" name="ntgm" id="optionsRadios2" value="N" checked="checked">
Não
</label>
</div>
</div>
public function ListarAta($query = null)
{
try {
$permissoes = listarAcesso();
if ($query == null) {
$data = Date("Y-m-d");
$stmt = $this->p->query("SELECT A.id AS id,\r\n\t\t\t\t\t\t\t\t\t\t\t\tA.cod_ata,\r\n\t\t\t\t\t\t\t\t\t\t\t\tA.aprovado,\r\n\t\t\t\t\t\t\t\t\t\t\t\tA.finalizado,\r\n\t\t\t\t\t\t\t\t\t\t\t\tA.dat_ata,\r\n\t\t\t\t\t\t\t\t\t\t\t\tA.dat_aprovado,\r\n\t\t\t\t\t\t\t\t\t\t\t\tB.destinatario,\r\n\t\t\t\t\t\t\t\t\t\t\t\tB.assunto,\r\n\t\t\t\t\t\t\t\t\t\t\t\tB.versao,\r\n\t\t\t\t\t\t\t\t\t\t\t\tB.ngtm,\r\n\t\t\t\t\t\t\t\t\t\t\t\tP.nome_completo AS nome_criou\r\n\t\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_ATAS . " A\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_ATAS_CONTEUDO . " B ON A.id = B.id_ata\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " P ON P.id = A.id_usuario\r\n\t\t\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\t\t\tB.principal = 'S' AND A.dat_excluido IS NULL\r\n\t\t\t\t\t\t\t\t\t\tORDER BY A.id DESC");
$count == 0;
$confirm = "return confirm('Deseja remover esse registro?');";
foreach ($stmt as $item) {
if ($item['aprovado'] == "S") {
$disabled = 'disabled';
//$disabled_edit= 'disabled';
$aprovado = "return false";
$edit = "return false";
$bt_aprova = 'Aprovado';
} else {
$disabled = "";
$aprovado = "return confirm('Deseja aprovar esse registro?');";
$edit = "";
//$disabled_edit= "";
$bt_aprova = 'Aprovar';
}
if ($item['finalizado'] != NULL) {
$disabled = 'disabled';
// $disabled_edit= 'disabled';
$aprovado = "return false";
$edit = "return false";
$bt_aprova = 'Aprovado';
}
// if ($item['versao'] >= 2){
// $edit = "return false";
// //$disabled_edit= 'disabled';
// }
if (isUserNTGM() == true && $item['ngtm'] == 'S' || isUserNTGM() == false) {
echo '<tr>';
echo ' <td style="display: none;">' . $count . '</td>';
echo ' <td>' . $item['cod_ata'] . '</td>';
echo ' <td>' . $item['destinatario'] . '</td>';
echo ' <td>' . mb_strtoupper($item['assunto']) . '</td>';
echo ' <td>' . dataBrasil($item['dat_ata'], 0) . '</td>';
echo ' <td>' . $item['versao'] . '</td>';
echo ' <td>' . $item['nome_criou'] . '</td>';
echo ' <td>';
$count += 1;
//Verifica se pode excluir
if (in_array(70, $permissoes) && empty($item['finalizado'])) {
echo ' <a data-rel="tooltip" title="Visualizar Ata" class="btn btn-success" href="view.php?id=' . $item['id'] . '" target="_blank">';
echo ' <i class="icon-eye-open icon-white"></i>';
echo ' </a>';
}
if (in_array(83, $permissoes) && $item['finalizado'] == NULL && $item['dat_aprovado'] != NULL) {
echo ' <a data-rel="tooltip" title="Finalizar Ata" class="btn btn-warning" href="finaliza.php?id=' . $item['id'] . '">';
echo ' <i class="icon-upload icon-white"></i>';
echo ' </a>';
}
//Verifica se pode finalizar
if (in_array(68, $permissoes) && empty($item['finalizado'])) {
if ($disabled == "") {
echo ' <a data-rel="tooltip" title="Aprovar Ata" class="btn btn-success" onclick="' . $aprovado . '" href="index.php?cmd=fin&id=' . $item['id'] . '">';
echo ' <i class="icon-ok icon-white"></i> ';
echo ' </a>';
}
}
//Verifica se pode editar
if (in_array(69, $permissoes) && empty($item['finalizado'])) {
//if($disabled_edit == ""){
echo ' <a data-rel="tooltip" title="Editar Ata" class="btn btn-info" onclick="' . $edit . '" href="edit.php?id=' . $item['id'] . '">';
echo ' <i class="icon-edit icon-white"></i>';
echo ' </a>';
// }
}
if (in_array(157, $permissoes) && empty($item['finalizado'])) {
//if($disabled_edit == ""){
echo ' <a data-rel="tooltip" title="Editar Código da Ata" class="btn btn-info" onclick="' . $edit . '" href="edit_cod.php?id=' . $item['id'] . '">';
echo ' <i class="icon-barcode icon-white"></i>';
echo ' </a>';
//}
}
if (in_array(69, $permissoes)) {
echo ' <a data-rel="tooltip" title="Comentar Ata" class="btn btn-info" href="comentario.php?id=' . $item['id'] . '">';
echo ' <i class="icon-comment icon-white"></i>';
echo ' </a>';
}
if (in_array(74, $permissoes) && empty($item['finalizado'])) {
if ($disabled == "") {
echo ' <a data-rel="tooltip" title="Deletar" class="btn btn-danger" onclick="' . $confirm . '" href="index.php?cmd=del&id=' . $item['id'] . '">';
echo ' <i class="icon-trash icon-white"></i>';
echo ' </a>';
}
}
if (in_array(69, $permissoes) && empty($item['finalizado'])) {
if ($item['file'] != NULL) {
echo ' <a data-rel="tooltip" title="Baixar Anexo" class="btn btn-info" href="' . EXTERNAL_ROOT_PORTAL . '/arquivos/' . $item['file'] . ' "target="_blank">';
echo ' <i class="icon-arrow-down icon-white"></i>';
echo ' </a>';
}
}
connectSQL();
$cod_ata = str_replace("/", "_", $item['cod_ata']);
$query = mysql_query("SELECT id FROM " . MYSQL_BASE_DOCUMENTOS . " WHERE cod_documento LIKE '" . $cod_ata . "' ORDER BY id DESC LIMIT 1");
while ($row = mysql_fetch_array($query)) {
if (in_array(70, $permissoes)) {
echo ' <a data-rel="tooltip" title="Protocolo" class="btn btn-success" href="' . EXTERNAL_ROOT_PORTAL . '/ged/documento/view.php?id=' . $row['id'] . '" target="_blank">';
echo ' <i class="icon-file icon-white"></i>';
echo ' </a>';
}
}
if (in_array(69, $permissoes) && empty($item['finalizado'])) {
echo ' <a data-rel="tooltip" title="Download Word" class="btn btn-inverse" href="' . EXTERNAL_ROOT_PORTAL . '/ged/ata/Ata_word.php?id=' . $item['id'] . '" target="_blank">';
echo ' <i class="icon-download-alt icon-white"></i>';
echo ' </a>';
}
echo ' </td>';
echo '</tr>';
}
}
} else {
$stmt = $this->p->query($query);
}
$this->p->__destruct();
return $stmt;
} catch (PDOException $ex) {
echo "Erro: " . $ex->getMessage();
}
}
$aprovado = "return false";
$edit = "return false";
$bt_aprova = 'Aprovado';
} else {
$disabled = "";
$aprovado = "return confirm('Deseja aprovar esse registro?');";
$edit = "";
$bt_aprova = 'Aprovar';
}
if ($item['finalizado'] != NULL) {
$disabled = 'disabled';
$aprovado = "return false";
$edit = "return false";
$bt_aprova = 'Aprovado';
}
if (isUserNTGM() == true && $item['ngtm'] == 'S' || isUserNTGM() == false) {
echo '<tr>';
echo ' <td style="display: none;">' . $count . '</td>';
echo ' <td>' . $item['cod_ata'] . '</td>';
echo ' <td>' . $item['destinatario'] . '</td>';
echo ' <td>' . mb_strtoupper($item['assunto']) . '</td>';
echo ' <td>' . dataBrasil($item['dat_ata'], 0) . '</td>';
echo ' <td>' . $item['versao'] . '</td>';
echo ' <td>' . $item['nome_criou'] . '</td>';
echo ' <td>';
echo ' <a target="_blank" data-rel="tooltip" title="Visualizar" class="btn btn-success" href="' . EXTERNAL_ROOT_PORTAL . '/ged/ata/view.php?id=' . $item['id'] . '">';
echo ' <i class="icon-eye-open icon-white"></i>';
echo ' </a>';
$count += 1;
connectSQL();
$cod_ata = str_replace("/", "_", $item['cod_ata']);
