pabx-app/admin/grupos.php

<?php
$acao = $_GET['acao'];
$id = $_GET['id'];

if ($acao == "deleta") {
    $id = $_GET["id"] ?? "0";

    $query = "select *from pbx_grupos where id=$id";
    $result = pg_query($dbcon, $query);

    while ($dados = pg_fetch_array($result)) {
        $nome = $dados['numero'];
    }
    Ajusta_tabelas('grupo', $nome, $dbcon);

    //REALIZA BACKUP BO BANCO
//($dbcon,'pbx_grupos','D',$id,'delete','GRUPOS');

    $query = "delete from pbx_grupos where id='$id'";
    pg_query($dbcon, $query); //gera arquivos e executa o reload dos dados no asterisk  
    gera_arquivos($dbcon, 'GRUPOS');
    ?>
<?php } ?>

<table width="100%"  border="0" cellpadding="2" cellspacing="0"  class="filtro">
    <tr>
        <td colspan="4"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <td width="50%"  bgcolor="#FFFFFF" ><div align="left"><a href="#" onclick="abre_janela('820', '400', 'index.php?idProg=11023&pbxRequest=1&acao=inseri');"><img src="images/novo.gif" width="20" height="20" border="0" align="absmiddle">NOVO GRUPO </a></div></td>
                </tr>
            </table></td>
    </tr>
    <tr  class="grid" >
        <th width="5%" > <div align="center">Id</span></div></th>
        <th width="17%"  > N&uacute;mero </th>
        <th width="67%"  > Descri&ccedil;&atilde;o</th>
        <th width="11%"  ><div align="center"><span class="style11">A&Ccedil;&Atilde;O</span></div></th>
    </tr>
    <?php
    $query = "SELECT * FROM pbx_grupos order by id asc";
    $result = pg_query($dbcon, $query);
    $z == 0;
    while ($dados = pg_fetch_array($result)) {
        ?>
        <tr  class="grid">
            <td><div align="center"><?php echo $dados['id']; ?></div></td>
            <td><?php echo $dados['numero']; ?></td>
            <td><?php echo $dados['descricao']; ?></td>
            <td>
                <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                    <tr>
                        <td style="border:0"><div align="center"><a href="#" onclick="abre_janela('820', '400', 'index.php?idProg=11023&pbxRequest=1&acao=edita&id=<?php echo $dados['id']; ?>');"><img src="images/edit.gif" alt="EDITAR O GRUPO:<?php echo $dados['nome']; ?>" width="22" height="22" border="0"></a></div></td>
                        <td style="border:0"><div align="center"><a href="#" onclick="excluir('<?php echo $dados['id']; ?>', '<?php echo $dados['numero']; ?>', 'DESEJA REALMENTE EXLUIR O GRUPO:<?php echo $dados['numero']; ?>', 'index.php?idProg=10023&pbxRequest=1&acao=deleta&id=<?php echo $dados['id']; ?>', 'GRUPOS');"><img src="images/delete.gif" alt="APAGAR O GRUPO:<?php echo $dados['numero']; ?>" width="22" height="22" border="0"></a></div></td>
                    </tr>
                </table></td>
        </tr>
        <?php
        $z++;
    } if ($z == 0) {
        ?>
        <tr align="center" valign="middle" bordercolor="#999999" class="labels">
            <td colspan="4"><div align="center"><span class="info"><img src="images/shutdown.gif" width="24" height="24" border="0" align="absmiddle" /></span> N&atilde;o foram encontrados registros </div></td>
        </tr>
<?php } ?>
    <tr bordercolor="#DDDDDD">
        <td colspan="4"></td>
    </tr>
</table>


<div id="campos" style="display:none" align="center">
    <iframe src="" frameborder="0" scrolling="no" name="geral" id="geral" align="middle"></iframe>
</div>


<div id="mensagem" style="display:none;width:300;height:auto">

    <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF">
            <td width="5%" align="center" style="border: none;font-family: Arial, Helvetica, sans-serif;font-size: 16px;color: #990000;background-color: #FFFFFF;"> 
            </td>
            <td width="95%" align="center" bgcolor="#FFFFFF" style="border: none;font-family: Arial, Helvetica, sans-serif;font-size: 16px;color: #990000;background-color: #FFFFFF;"><div align="center">
                    <input name="mens" type="button" value="mens"  style="border: none;font-family: Arial, Helvetica, sans-serif;font-size: 14px;color: #990000;background-color: #FFFFFF;" id="mens">
                </div></td> 
        </tr>
        <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF">
            <td colspan="2" align="center"  bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF"><span style="color: #FFFFFF"> _        
                </span></td>
        </tr>	
        <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF">
            <td colspan="2"  bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF">
                <table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" style="border-color:#FFFFFF">
                    <tr>
                        <td width="50%" align="center"  bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF">
                            <div align="center">
                                <button id="todos" class="botoes">Sim</button>
                            </div>
                        </td>
                        <td width="50%" align="center"  bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF">
                            <div align="center">			<button id="cancela" class="botoes">N&atilde;o</button>
                            </div>
                        </td>
                    </tr>
                </table></td>
        </tr>
    </table></div>
</div>
</div>

</body>
</html>