forked from SimplesIP/pabx-app
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
235 lines
11 KiB
235 lines
11 KiB
<?php |
|
//include dos arquivos padrões do sistema |
|
include('menu2.php'); |
|
|
|
|
|
|
|
$acao = $_GET['acao']; |
|
$id = $_GET['id']; |
|
$tipo = $_GET['tipo']; |
|
|
|
if ($acao == "deleta") { |
|
if ($tipo == 'f') { |
|
$id = $_GET["id"] ?? "0"; |
|
$query = "delete from pbx_backups where id='$id'"; |
|
pg_query($dbcon, $query); |
|
} else { |
|
?> |
|
<script>alert('NÃO É POSSÍVEL APAGAR UM BACKUP PADRÃO DO SISTEMA');</script> |
|
<?php |
|
} |
|
?> |
|
<script>MM_goToURL('backups.php');</script> |
|
<?php |
|
} |
|
|
|
|
|
if ($acao == "restaura") { |
|
//localiza nomes que darão erro pelo nome ser igual de funcões do PostGresql |
|
$base = array('"', 'group', 'language', 'monitor-type', 'console"language"', 'call"group"', 'call-limit', 'pickup"group"'); |
|
$troca = array("'", '"group"', '"language"', '"monitor-type"', 'consolelanguage', 'callgroup', '"call-limit"', 'pickupgroup'); |
|
|
|
|
|
|
|
$id = $_GET["id"] ?? "0"; |
|
$reload = $_GET["reload"]; |
|
$query = "select * from pbx_backups where id='$id'"; |
|
$result = pg_query($dbcon, $query); |
|
|
|
while ($dados = pg_fetch_array($result)) { |
|
$comando = str_replace($base, $troca, $dados['comando_retorno']); |
|
} |
|
//retorna backu |
|
pg_query($dbcon, $comando); |
|
|
|
if ($reload != '') { |
|
//gera arquivo//gera arquivos e executa o reload dos dados no asterisk |
|
gera_arquivos($dbcon, $reload); |
|
} |
|
?> |
|
<script>alert('BACKUP RESTAURADO COM SUCESSO!');</script> |
|
<script>MM_goToURL('backups.php');</script> |
|
<?php |
|
} |
|
?> |
|
|
|
<table width="100%" border="1" cellpadding="0" cellspacing="0"> |
|
<tr> |
|
<td colspan="7" background="img/button03.gif"><div align="center" class="date">BACKUPS DO SISTEMA</div></td> |
|
</tr> |
|
<tr bordercolor="#990000" bgcolor="#990000" > |
|
<td colspan="7"><form name="form1" method="post" action="admin/backups.php"> |
|
<table width="100%" border="0" cellspacing="0" cellpadding="0"> |
|
<tr class="date" background="img/button03.gif"> |
|
<td width="21%" background="img/button03.gif">DATA:</td> |
|
<td width="28%" background="img/button03.gif">TABELA:</td> |
|
<td width="44%" background="img/button03.gif" >TIPO:</td> |
|
<td width="7%" background="img/button03.gif"> </td> |
|
</tr> |
|
<tr > |
|
<td background="img/button03.gif"><input name="data" type="text" class="textbox" id="data" size="20" maxlength="10" onclick="displayCalendar(document.forms[0].data, 'dd/mm/yyyy', this)"></td> |
|
<td background="img/button03.gif"><select name="tabela" class="textbox"> |
|
<option value="">-------------------------------</option> |
|
<?php |
|
$query = "SELECT tabela FROM pbx_backups group by tabela order by tabela asc"; |
|
$result = pg_query($dbcon, $query); |
|
|
|
while ($dados = pg_fetch_array($result)) { |
|
?> |
|
<option value="<?php echo $dados['tabela']; ?>"><?php echo $dados['tabela']; ?></option> |
|
<?php } ?> |
|
</select></td> |
|
<td background="img/button03.gif"><select name="tipo" class="textbox"> |
|
<option value="">-------------------------------</option> |
|
<?php |
|
$query = "SELECT executa_reload FROM pbx_backups group by executa_reload order by executa_reload asc"; |
|
$result = pg_query($dbcon, $query); |
|
|
|
while ($dados = pg_fetch_array($result)) { |
|
?> |
|
<option value="<?php echo $dados['executa_reload']; ?>"><?php echo $dados['executa_reload']; ?></option> |
|
<?php } ?> |
|
</select></td> |
|
<td width="7%" background="img/button03.gif"><input name="Submit" type="submit" class="textbox" value="Buscar"></td> |
|
</tr> |
|
</table> |
|
</form></td> |
|
</tr> |
|
<tr bordercolor="#990000" bgcolor="#990000" class="dados" > |
|
<td width="11%"> <div align="center">DATA </div></td> |
|
<td width="11%"> <div align="center">HORA </div></td> |
|
<td width="25%"> TABELA </td> |
|
<td width="23%">TIPO</td> |
|
<td width="13%">ACÃO</td> |
|
<td width="9%"> <div align="center">PADRÃO</div></td> |
|
<td width="8%"><div align="center"><span class="style11">AÇÃO</span></div></td> |
|
</tr> |
|
<?php |
|
$pg = $_GET['pg']; |
|
$numreg = 30; // Quantos registros por página vai ser mostrado\ |
|
if (!isset($pg)) { |
|
$pg = 0; |
|
} |
|
$inicial = $pg * $numreg; |
|
|
|
$tabela = trim($_POST["tabela"]); |
|
$data = trim($_POST["data"]); |
|
$tipo = trim($_POST["tipo"]); |
|
|
|
$query = "SELECT * FROM pbx_backups where 1=1 "; |
|
$query1 = "SELECT * FROM pbx_backups where 1=1 "; |
|
if ($data != '') { |
|
$query .= "and data='$data'"; |
|
$query1 .= "and data='$data'"; |
|
} |
|
if ($tabela != '') { |
|
$query .= "and tabela='$tabela'"; |
|
$query1 .= "and tabela='$tabela'"; |
|
} |
|
if ($tipo != '') { |
|
$query .= "and executa_reload='$tipo'"; |
|
$query1 .= "and executa_reload='$tipo'"; |
|
} |
|
$query .= "order by id desc LIMIT $numreg OFFSET $inicial "; |
|
|
|
|
|
$sql_conta = pg_query($query1); |
|
$quantreg = pg_num_rows($sql_conta); |
|
|
|
$result = pg_query($dbcon, $query); |
|
$z == 0; |
|
while ($dados = pg_fetch_array($result)) { |
|
?> |
|
<tr bordercolor="#FFFFB6" class="dadosResult" > |
|
<td><div align="center"><?php echo arruma_data($dados['data']); ?></div></td> |
|
<td><div align="center"><?php echo $dados['hora']; ?> </div></td> |
|
<td ><?php echo $dados['tabela']; ?></td> |
|
<td><?php echo $dados['executa_reload']; ?></td> |
|
<td><?php |
|
if (trim($dados['tipo']) == 'U') { |
|
echo 'ATUALIZAÇÃO'; |
|
} |
|
if (trim($dados['tipo']) == 'D') { |
|
echo 'INSERÇÃO'; |
|
} |
|
?></td> |
|
<td><div align="center"><span ><?php |
|
if ($dados['padrao'] == 'f') { |
|
echo "NÃO"; |
|
} else { |
|
echo "SIM"; |
|
} |
|
?></span></div></td> |
|
<td><table width="100%" border="0" cellspacing="0" cellpadding="0"> |
|
<tr> |
|
<td><div align="center"><a href="backups.php?acao=restaura&id=<?php echo $dados['id']; ?>&reload= <?php echo $dados['executa_reload']; ?>"><img src="images/edit.gif" alt="RESTAURAR O BACKUP:<?php echo trim($dados['tabela']); ?>" width="22" height="22" border="0"></a></div></td> |
|
<td><div align="center"><a href="#" onClick="excluir('<?php echo $dados['id']; ?>', '<?php echo trim($dados['tabela']); ?>', 'DESEJA REALMENTE EXLUIR O BACKUP:<?php echo trim($dados['tabela']); ?>', 'backups.php?acao=deleta&id=<?php echo $dados['id']; ?>&tipo=<?php echo $dados['padrao']; ?>', 'BACKUPS');"><img src="images/delete.gif" alt="APAGAR O BACKUP:<?php echo trim($dados['tabela']); ?>" width="22" height="22" border="0"></a></div></td> |
|
</tr> |
|
</table></td> |
|
</tr> |
|
<?php |
|
$z++; |
|
} |
|
?> |
|
<tr align="center" valign="middle" bordercolor="#999999" class="labels"> |
|
<td colspan="7"><?php include ('pag.php'); ?></td> |
|
</tr> |
|
<?php if ($z == 0) { ?> |
|
<tr align="center" valign="middle" bordercolor="#999999" class="labels"> |
|
<td colspan="7"><div align="center"><span class="info"><img src="images/shutdown.gif" width="24" height="24" border="0" align="absmiddle" /></span> Não foram encontrados registros </div></td> |
|
</tr> |
|
<?php } ?> |
|
<tr bordercolor="#DDDDDD"> |
|
<td colspan="7"> </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="">Sim</button> |
|
</div> |
|
</td> |
|
<td width="50%" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border-color:#FFFFFF"> |
|
<div align="center"> |
|
<button id="cancela" class="button">Não</button> |
|
</div> |
|
</td> |
|
</tr> |
|
</table></td> |
|
</tr> |
|
</table></div> |
|
|
|
|
|
<br> |
|
</div> |
|
<hr class="hidden" /> |
|
<hr class="hidden" /> |
|
<div id="foot"> |
|
<p class="fl"> </p> |
|
<p class="fr"> </p> |
|
</div> |
|
</div> |
|
|
|
</body> |
|
</html>
|