|
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_cyc'])) {
$id_caso_cyc = $_POST['id_caso_cyc'];
}
else {
$id_caso_cyc = $_GET['id_caso_cyc'];
}
if (isset($_POST['tb_rol'])) {
$tb_rol = $_POST['tb_rol'];
}
else {
$tb_rol = $_GET['tb_rol'];
}
if ($tb_rol == 9) {
$campo_a_actualizar = 'tb_personal0personal_que_registro_el_dato';
}
if ($tb_rol == 1) {
$campo_a_actualizar = 'tb_personal0negociador';
}
if ($tb_rol == 4) {
$campo_a_actualizar = 'tb_personal0procurador';
}
if ($paso == 1) {
$tb_personal = DarFormato($_POST['tb_personal'], 'n');
$sql = "UPDATE tb_caso_cyc SET $campo_a_actualizar = $tb_personal WHERE id_caso_cyc = $id_caso_cyc";
mysql_query($sql, $zyz) or die(mysql_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
mysql_select_db($database_zyz, $zyz);
$query_rs_caso_cyc = "SELECT $campo_a_actualizar FROM tb_caso_cyc WHERE id_caso_cyc = $id_caso_cyc";
$rs_caso_cyc = mysql_query($query_rs_caso_cyc, $zyz) or die(mysql_error());
$row_rs_caso_cyc = mysql_fetch_assoc($rs_caso_cyc);
$totalRows_rs_caso_cyc = mysql_num_rows($rs_caso_cyc);
$colname_rs_personal = "-1";
if (isset($_GET['tb_rol'])) {
$colname_rs_personal = (get_magic_quotes_gpc()) ? $_GET['tb_rol'] : addslashes($_GET['tb_rol']);
}
mysql_select_db($database_zyz, $zyz);
$query_rs_personal = sprintf("SELECT p.id_personal, CONCAT(p.nombre, ' ', p.apellido) personal FROM tb_personal p INNER JOIN tb_usuario u ON u.tb_personal = p.id_personal INNER JOIN tb_rel_usuario_grupo rug ON rug.tb_usuario = u.id_usuario INNER JOIN tb_rel_grupo_rol rgr ON rgr.tb_grupo = rug.tb_grupo WHERE rgr.tb_rol = %s AND p.fecha_de_baja is null", $colname_rs_personal);
$rs_personal = mysql_query($query_rs_personal, $zyz) or die(mysql_error());
$row_rs_personal = mysql_fetch_assoc($rs_personal);
$totalRows_rs_personal = mysql_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="300" 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 == 9) {
echo 'REGISTRADOR DEL caso_cyc';
}
if ($tb_rol == 1) {
echo 'NEGOCIADOR';
}
if ($tb_rol == 4) {
echo 'procurador';
}
?>
</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>
<?php
$tb_moto_modelo = explode(' - ', $row_rs_caso_cyc['tb_moto_modelo']);
?>
<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_cyc[$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_cyc[$campo_a_actualizar]))) {echo "selected=\"selected\"";} ?>><?php echo $row_rs_personal['personal']?></option>
<?php
} while ($row_rs_personal = mysql_fetch_assoc($rs_personal));
$rows = mysql_num_rows($rs_personal);
if($rows > 0) {
mysql_data_seek($rs_personal, 0);
$row_rs_personal = mysql_fetch_assoc($rs_personal);
}
?>
</select></td>
</tr>
<tr valign="baseline">
<td><div align="center">
<input type="submit" value="Procesar">
<input name="id_caso_cyc" type="hidden" id="id_caso_cyc" value="<?php echo $id_caso_cyc ?>" 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
mysql_free_result($rs_personal);
mysql_free_result($rs_caso_cyc);
?>