|
Directory : /home/zjabogados/public_html/otrosscripts/ |
<?php require_once('../../Connections/zyz.php'); ?>
<?php
session_start();
$motorBD = $_SESSION['motorBD'];
$idusuario = $_SESSION['idusuario'];
require_once("../Libs/functionsjava.htm");
require_once("../Libs/functionsextra.php");
if (isset($_POST['paso'])) {
$paso = $_POST['paso'];
}
else {
$paso = 0;
}
if (isset($_POST['id_caso_recupero'])) {
$id_caso_recupero = $_POST['id_caso_recupero'];
}
else {
$id_caso_recupero = $_GET['id_caso_recupero'];
}
if (isset($_POST['tb_rol'])) {
$tb_rol = $_POST['tb_rol'];
}
else {
$tb_rol = $_GET['tb_rol'];
}
if ($tb_rol == 28) {
$campo_a_actualizar = 'tb_personal0personal_que_registro_el_dato';
}
if ($tb_rol == 27) {
$campo_a_actualizar = 'tb_personal0negociador';
}
if ($tb_rol == 4) {
$campo_a_actualizar = 'tb_personal0medico';
}
if ($paso == 1) {
$tb_personal = DarFormato($_POST['tb_personal'], 'n');
$sql = "UPDATE tb_caso_recupero SET $campo_a_actualizar = $tb_personal WHERE id_caso_recupero = $id_caso_recupero";
mysqli_query($zyz, $sql) or die(mysqli_error());
?>
<script language="JavaScript">
opener.parent.rightFrame.document.form_actualizar.valor.value = '';
opener.parent.rightFrame.document.form_actualizar.campo.value = 'otra';
opener.parent.rightFrame.document.form_actualizar.acc.value = 'R';
opener.parent.rightFrame.document.form_actualizar.submit();
window.close();
</script>
<?php
}
?>
<?php
mysqli_select_db($zyz, $database_zyz);
$query_rs_caso_recupero = "SELECT $campo_a_actualizar FROM tb_caso_recupero WHERE id_caso_recupero = $id_caso_recupero";
$rs_caso_recupero = mysqli_query($zyz, $query_rs_caso_recupero) or die(mysqli_error());
$row_rs_caso_recupero = mysqli_fetch_assoc($rs_caso_recupero);
$totalRows_rs_caso_recupero = mysqli_num_rows($rs_caso_recupero);
$colname_rs_personal = "-1";
if (isset($tb_rol)) {
$colname_rs_personal = (get_magic_quotes_gpc()) ? $tb_rol : addslashes($tb_rol);
}
mysqli_select_db($zyz, $database_zyz);
$query_rs_personal = sprintf("SELECT distinct p.id_personal, CONCAT(p.nombre, ' ', p.apellido) personal FROM tb_personal p WHERE (p.fecha_de_baja IS NULL or p.fecha_de_baja >= NOW())", $colname_rs_personal);
$rs_personal = mysqli_query($zyz, $query_rs_personal) or die(mysqli_error());
$row_rs_personal = mysqli_fetch_assoc($rs_personal);
$totalRows_rs_personal = mysqli_num_rows($rs_personal);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html><!-- InstanceBegin template="/Templates/Contenido.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Documento sin título</title>
<!-- InstanceEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 0px;
margin-top: 0px;
}
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.Estilo1 {
color: #FFFFFF;
font-weight: bold;
}
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table border="0" align="center" cellpadding="0" cellspacing="10">
<tr>
<td><!-- InstanceBeginEditable name="Contenido" -->
<table width="400" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="28"><img src="../img/tabla_tit_izq.jpg" width="28" height="40"></td>
<td valign="bottom" background="../img/tabla_tit_med.jpg"><table border="0" cellspacing="8" cellpadding="1">
<tr>
<td><span class="Estilo1">SELECCIONE EL
<?php
if ($tb_rol == 28) {
echo 'REGISTRADOR DE LA CARPETA';
}
if ($tb_rol == 27) {
echo 'OPERADOR';
}
if ($tb_rol == 4) {
echo 'MEDICO';
}
?>
</span></td>
</tr>
</table></td>
<td width="28"><img src="../img/tabla_tit_der.jpg" width="28" height="40"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="13" background="../img/tabla_cont_izq.jpg"> </td>
<td bgcolor="#9DC5E9"><table width="100%" border="0" cellspacing="4" cellpadding="4">
<tr>
<td>
<form method="post" name="form1" onsubmit="return Chequear(this);">
<table align="center">
<tr valign="baseline">
<td><select name="tb_personal" class="NO int" id="Personal">
<option value="" <?php if (!(strcmp("", $row_rs_caso_recupero[$campo_a_actualizar]))) {echo "selected=\"selected\"";} ?>></option>
<?php
do {
?>
<option value="<?php echo $row_rs_personal['id_personal']?>"<?php if (!(strcmp($row_rs_personal['id_personal'], $row_rs_caso_recupero[$campo_a_actualizar]))) {echo "selected=\"selected\"";} ?>><?php echo $row_rs_personal['personal']?></option>
<?php
} while ($row_rs_personal = mysqli_fetch_assoc($rs_personal));
$rows = mysqli_num_rows($rs_personal);
if($rows > 0) {
mysqli_data_seek($rs_personal, 0);
$row_rs_personal = mysqli_fetch_assoc($rs_personal);
}
?>
</select></td>
</tr>
<tr valign="baseline">
<td><div align="center">
<input type="submit" value="Procesar">
<input name="id_caso_recupero" type="hidden" id="id_caso_recupero" value="<?php echo $id_caso_recupero ?>" size="32">
<input name="tb_rol" type="hidden" id="tb_rol" value="<?php echo $tb_rol ?>" size="32">
<input name="paso" type="hidden" id="paso" value="<?php echo $paso+1 ?>" size="32">
</div></td>
</tr>
</table>
</form>
</td>
</tr>
</table></td>
<td width="13" background="../img/tabla_cont_der.jpg"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="28"><img src="../img/tabla_pie_izq2.jpg" width="28" height="19"></td>
<td background="../img/tabla_pie_med2.jpg"> </td>
<td width="28"><img src="../img/tabla_pie_der2.jpg" width="28" height="19"></td>
</tr>
</table>
</td>
</tr>
</table>
<!-- InstanceEndEditable --></td>
</tr>
</table></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
<?php
mysqli_free_result($rs_personal);
mysqli_free_result($rs_caso_recupero);
?>