File: /home/asjudine/www/ingresar_evaluacion_abogados_asist_geren_adm.php
<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;
require_once("Conectarse.php");
$control = mysql_query('SELECT nombre_completo FROM Usuarios WHERE cedula = "'.$_GET["ced2"]. '" and codigo = "'.$_GET["codigo"].'" ');
if (!$control) {
die('Invalid query 1: ' . mysql_error());
}
list($apenom) = mysql_fetch_row($control);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Evaluacion Abogados</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.titulos {font: 16px; color: red; font-family:Arial; font-weight:bold}
.boton {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
.texto {background-color: #CCFFCC; font-size: 10px; font-family: Arial; color:#0000CC; display: block;}
.fecha {font-size: 12px; font-family: Arial; color:#990000; display: block; }
.campo {background-color:#FFFFAA; width: 100px; border:2px solid #990000;}
.lista {font-family: Arial; font-size: 12px; color: #003333;}
.lista2 {font-family: Arial; font-size: 16px; color: #FF6600;}
.boton2 {
font-family: Verdana;
font-size: 8 pt;
color: #000080;
background-color: #C0C0C0;
border-style: solid;
width:90px;
height:22px;
}
body {
background-image: url();
}
.Estilo50 {color: #CC3333;
font-family: "Arial Narrow";
font-weight: bold;
}
.Estilo51 {
color: #3366FF;
font-weight: bold;
}
.boton1 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
.boton11 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
-->
</style>
<script languaje="JavaScript">
function Mostrar_Fecha()
{
var mydate=new Date()
var year=mydate.getYear()
if (year < 1000)
year+=1900
var day=mydate.getDay()
var month=mydate.getMonth()
var daym=mydate.getDate()
if (daym<10)
daym="0"+daym
var dayarray=new Array("Domingo","Lunes","Martes","Miercoles","Jueves","Viernes","Sabado")
var montharray=new Array("Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre")
document.write("<b><font face='Arial, Helvetica, sans-serif'>"+dayarray[day]+" "+daym+" de "+montharray[month]+" de "+year+"</font></b>")
}
</script>
<script language="javascript">
function AbreGral()
{
var menu;
menu=window.open("mostrar_ingreso.php","","toolbar=no,scrollbars=no,width=800,height=500,status=yes");
menu.focus();
var ventana = window.self;
ventana.opener = window.self;
ventana.close();
}
</script>
</head>
<body onLoad="document.formulario.cedula.focus()" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="formulario" action="" method="post">
<table width="530" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="530"><fieldset>
<table width="514" border="0" align="center" cellpadding="2" cellspacing="2">
<tr bgcolor="#FFFFCC">
<td colspan="5" class="titulos"><div align="center">LISTADO ABOGADOS EVALUACION ASISTENTE GERENCIA ADMINISTRATIVA</div></td>
</tr>
<tr bgcolor="#ECE9D8">
<td height="22" colspan="5" class="fecha"><div align="center">
<script languaje="JavaScript">Mostrar_Fecha()</script>
</div></td>
</tr>
<tr bgcolor="#FFCC99">
<td colspan="5" bgcolor="#CCFFCC"><span class="Estilo51">Funcionario : </span><input name="apenom" type="text" class="Estilo66" id="apenom" value="<?php echo $apenom ?>" size="60" maxlength="65" readonly=""/> </td>
</tr>
<tr>
<td width="393" bgcolor="#CCFFCC"><div align="center"><span class="Estilo51">Motivo : </span></div></td>
<td bgcolor="#CCFFCC" colspan="4"><div align="center"><span class="Estilo51">Calificacion : </span></div></td>
</tr>
<tr>
<td bgcolor="#CCFFCC">
Calificacion MENSUAL :
<select name="mess" required>
<option value="0" required>--SELECCIONE EL MES--</option>
<option value="1">ENERO</option>
<option value="2">FEBRERO</option>
<option value="3">MARZO</option>
<option value="4">ABRIL</option>
<option value="5">MAYO</option>
<option value="6">JUNIO</option>
<option value="7">JULIO</option>
<option value="8">AGOSTO</option>
<option value="9">SEPTIEMBRE</option>
<option value="10">OCTUBRE</option>
<option value="11">NOVIEMBRE</option>
<option value="12">DICIEMBRE</option>
</select>
</td>
<td width="13" bgcolor="#CCFFCC">B</td>
<td width="13" bgcolor="#CCFFCC">M</td>
<td width="13" bgcolor="#CCFFCC">A</td>
<td width="13" bgcolor="#CCFFCC">F</td>
</tr>
<tr>
<td bgcolor="#CCFFCC" align="center">
<input name="codigosu2" type="text" class="Estilo66" id="codigosu2" value="POR CUMPLIMIENTO JORNADA PRESENCIAL" size="60" maxlength="60" readonly />
</td>
<td bgcolor="#CCFFCC"><input type="radio" name="a" id="a1" value="1"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="a" id="a2" value="2"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="a" id="a3" value="3"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="a" id="a4" value="-3"></td>
</tr>
<!--<tr>
<td bgcolor="#CCFFCC" align="center">
<input name="codigosu2" type="text" class="Estilo66" id="codigosu2" value="CUMPLIMIENTO JORNADA PRESENCIAL MAXIMA" size="60" maxlength="60" readonly />
</td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b1" value="1"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b2" value="2"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b3" value="3"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b4" value="-3"></td>
</tr>-->
<tr>
<td bgcolor="#CCFFCC" align="center">
<input name="codigosu2" type="text" class="Estilo66" id="codigosu2" value="POR CUMPLIMIENTO SOPORTE VIATICOS" size="60" maxlength="60" readonly />
</td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b1" value="1"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b2" value="2"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b3" value="3"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="b" id="b4" value="-3"></td>
</tr>
<tr>
<td bgcolor="#CCFFCC" align="center">
<input name="codigosu2" type="text" class="Estilo66" id="codigosu2" value="POR REEMBOLSO VIATICOS" size="60" maxlength="60" readonly />
</td>
<td bgcolor="#CCFFCC"><input type="radio" name="c" id="c1" value="1"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="c" id="c2" value="2"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="c" id="c3" value="3"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="c" id="c4" value="-3"></td>
</tr>
<tr>
<td bgcolor="#CCFFCC" align="center">
<input name="codigosu2" type="text" class="Estilo66" id="codigosu2" value="POR LA PRONTITUD EN REQUERIMIENTOS" size="60" maxlength="60" readonly />
</td>
<td bgcolor="#CCFFCC"><input type="radio" name="d" id="d1" value="1"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="d" id="d2" value="2"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="d" id="d3" value="3"></td>
<td bgcolor="#CCFFCC"><input type="radio" name="d" id="d4" value="-3"></td>
</tr>
<!--<input name="punaten" type="text" class="Estilo66" id="punaten" value="0" size="4" maxlength="4" />-->
<tr bgcolor="#FFCC99">
<td colspan="5" bgcolor="#CCFFCC"><div align="center" class="Estilo51">
<input name="menu2" type="button" class="Estilo50" id="menu2" onClick="window.location.href='listado_evaluacion_abogados_asist_geren_adm.php'" value="IR AL MENU">
<input name="guardarcalificaion" type="submit" class="Estilo51" id="consultar" value="GUARDAR CALIFICACION" />
</div></td>
</tr>
</table>
</fieldset></td>
</tr>
</table></tr></tr>
</form>
</body>
</html>
<?php
if(isset($_POST["guardarcalificaion"]))
{
require_once("Conectarse.php");
$dia= date("d");
$mes =date("m");
$ano= date("Y");
$fechasis = $ano.'-'.$mes.'-'.$dia;
$mess = $_POST['mess'];
$a = $_POST['a'];
$b = $_POST['b'];
$c = $_POST['c'];
$d = $_POST['d'];
if(a == 1){$a = 1;}
elseif(a == 2){$a = 2;}
elseif(a == 3){$a = 3;}
elseif(a == -3){$a = -3;}
if(b == 1){$b = 1;}
elseif(b == 2){$b = 2;}
elseif(b == 3){$b = 3;}
elseif(b == -3){$b = -3;}
if(c == 1){$c = 1;}
elseif(c == 2){$c = 2;}
elseif(c == 3){$c = 3;}
elseif(c == -3){$c = -3;}
if(d == 1){$d = 1;}
elseif(d == 2){$d = 2;}
elseif(d == 3){$d = 3;}
elseif(d == -3){$d = -3;}
//$total = $a + $b + $c + $d + $e;
$contro2 = mysql_query('SELECT codigo,cedula,nombre_completo,calif_1,calif_2,calif_3,calif_4 FROM eval_abog_asist_gerencia_adm WHERE codigo = "'.$_GET["codigo"].'" and cedula = "'.$_GET["ced2"].'" and mes= "'.$_POST['mess'].'" ');
if (!$contro2) {
die('Invalid query: ' . mysql_error());
}
$recor = mysql_num_rows($contro2);
//list($codigo, $cedula, $nombre, $gerencia) = mysql_num_rows($control2);
if ((mysql_num_rows($contro2)==0))
{
if($mes == $mess)
{
if ($mess == 1){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 2){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 3){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 4){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 5){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 6){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 7){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 8){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 9){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 10){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 11){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
elseif($mess == 12){$acmes1 = $a; $acmes2 = $b; $acmes3 = $c; $acmes4 = $d;}
$totalmensual = $a + $b + $c + $d;
if ($acmes1=='0' || $acmes2=='0' || $acmes3=='0' || $acmes4=='0' || $acmes1=='' || $acmes2=='' || $acmes3=='' || $acmes4=='')
{
echo "<script>alert('No Ha Seleccionado Todas Las Calificaciones');</script>";
}
else
{
$ins = mysql_query("INSERT INTO eval_abog_asist_gerencia_adm(codigo, cedula, nombre_completo, calif_1 ,calif_2, calif_3, calif_4, mes, acumulado_mensual,fecha) VALUES ('".$_GET['codigo']."','".$_GET['ced2']."','".$_POST['apenom']."', '$acmes1', '$acmes2', '$acmes3', '$acmes4','".$mess."', '".$totalmensual."', '".$fechasis."')");
echo "<script>alert('La informacion fue Grabada correctamente');</script>";
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='listado_evaluacion_abogados_asist_geren_adm.php'</SCRIPT> ";
}
}
else
{
echo "<script>alert('Seleccione el mes correcto');</script>";
}
}
else
{
$control3 = mysql_query('SELECT calif_1,calif_2,calif_3,calif_4 FROM eval_abog_asist_gerencia_adm WHERE codigo = "'.$_GET["codigo"].'" and cedula = "'.$_GET["ced2"].'" ');
if (!$control3) {
die('Invalid query: ' . mysql_error());
}
list($cal1, $cal2, $cal3, $cal4, $cal5) = mysql_fetch_row($control3);
if ($cal1=='0'||$cal2=='0'||$cal3=='0'||$cal4=='0')
{
$mss = mysql_query("UPDATE eval_abog_asist_gerencia_adm set calif_1 = '".$acmes1."', calif_2= '".$acmes2."', calif_3 = '".$acmes3."', calif_4 = '".$acmes4."' WHERE codigo = '".$_GET["codigo"]."' and cedula = '".$_GET["ced2"]."' ");
if (!$mss) {
die('Invalid query update 174: ' . mysql_error());
}
echo "<script>alert('La informacion Se Actualizo');</script>";
}
else{
echo "<script>alert('Ya tiene Calificacion');</script>";
}
}
}
?>