AddQuality.php | searchcode

/AddQuality.php

http://gestion-calls.googlecode.com/
PHP | 296 lines | 271 code | 17 blank | 8 comment | 53 complexity | c521c5188dbf1f4eaa3747b2a5b10680 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0, MIT, LGPL-3.0

<?php 

//include_once('includes/session.php');

//check_session();



include_once('includes/db.class.php');



$debug=false;



$db=new db_class();



if(!$db->connect()){

	echo "Error de Conexion: $db->print_last_error(false)";

}



include_once('includes/secure.php');



$secure=new secure();



$secure->secureGlobals();

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

	<head>

		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

		<title>:: Agregar Monitoreo ::</title>

		<style type="text/css">

				td {

			font-family: Verdana, Geneva, sans-serif;

			font-size: 13px;

			color: #333;

			padding-left:5px;

			text-align: left;

			font-weight: bold;

					}

					

				#opciones {

					font-family: Verdana, Geneva, sans-serif;

					padding-top: 5px;

					color: #000;

					/*width: 830px;*/

					padding-bottom: 5px;

					padding-left: 5px;

					font-size:8px;

					text-align: justify;

				}

	    </style>

        <!--TimePicker-->

        <script type="text/javascript" src="includes/jquery/jquery-1.3.2.js"></script>

		<script type="text/javascript" src="includes/jquery/jquery.clockpick.1.2.7.min.js"></script>

		<link href="css/jquery.clockpick.1.2.7.css" rel="stylesheet" type="text/css" />

        <link href="estilos/style.css" rel="stylesheet" type="text/css" />

        <script type="text/javascript">

		$(document).ready(function() {

		$("#fecha_inicio").clockpick({

		starthour : 0,

		endhour : 23,

		showminutes : true,

		minutedivisions:30,

		military:true

		});

		$("#fecha_fin").clockpick({

		starthour : 0,

		endhour : 23,

		showminutes : true,

		minutedivisions:30,

		military:true

		});

		});

		</script>

</head>

<?php

@mysql_query("SET NAMES 'utf8'");

if($action == "update" || $_GET[action] == "update")// esta editando.

{	

	$_sql = "SELECT t1.idmonitoreo AS idmoni, t1.campana AS camp, t1.resumen AS resume, t1.observaciones AS observ, t3.nombre AS nombre, DATE_FORMAT(t1.fecha_inicio,'%H:%i') AS horaini, DATE_FORMAT(t1.fecha_fin,'%H:%i') AS horafin, t1.calificacion AS calif, t3.user AS cc, t1.fecha_in AS fecha, t1.calificacion  AS nota FROM monitoreo AS t1 CROSS JOIN (relmonitoreousuario AS t2 CROSS JOIN usuarios AS t3) ON  (t1.idmonitoreo = t2.idmonitoreo AND t2.idusuario = t3.id AND t1.idmonitoreo = $_GET[id])";

	if(!$rowall = mysql_fetch_array($db->select($_sql))){

			echo "Query:<br> $db->last_query<br>";

			echo "Error:<br> $db->last_error";

			return;

		}

	

	$_sql = "SELECT t1.idatributo AS atributo, t1.valor AS val FROM relatrimonitoreo AS t1 CROSS JOIN (monitoreo AS t2) ON  (t1.idmonitoreo = t2.idmonitoreo AND t1.idmonitoreo = $_GET[id])";

	if(!$result = $db->select($_sql)){

			echo "Query:<br> $db->last_query<br>";

			echo "Error:<br> $db->last_error";

			return;

		}

	$_editarray = array();

	while($row = mysql_fetch_array($result)){

		array_push($_editarray,$row[atributo],$row[val]);

		}

	if($debug){

	print_r($_editarray);

	return;

	}

	}

?> 

	<body>

		<form id="form1" name="form1" method="post" action="<?=(($_GET[action]=='update' or $action=='update')?'Control/updateQuality.php':'Control/AddQuality.php')?>">

		  <table width="90%" align="center" cellpadding="0" border="2">

		  <tr>

		    <td><table width="90%" align="center" cellpadding="0" border="0">

		      <tr>

		        <td colspan="8" valign="middle"><table width="90%" align="center" cellpadding="0" border="2">

		          <tr>

		            <td><table width="90%" align="center" cellpadding="0" border="0">

		              <tr>

		                <td colspan="8" valign="middle"><p>&nbsp;</p>

		                  <div align="center">

		                    <p>

		                      <label>Campańa

		                        <input name="campana" type="text" id="campana" size="60" maxlength="255" value="<?=(($action  == "update" || $_GET[action] == "update")?$rowall[camp]:'')?>" />

	                          </label>

	                        </p>

		                    <p>

		                      <label>Hora Inicio

		                        <!--<input name="fecha_inicio" type="text" id="fecha_inicio" size="57"/>-->

		                        <input id="fecha_inicio" type="text" size="8" name="fecha_inicio" readonly="readonly" value="<?=(($action  == "update" || $_GET[action] == "update")?$rowall[horaini]: date("H:i"))?>"/>

	                          </label>

	                        </p>

		                    <p> <br />

		                      ASESOR:

		                      <?=(isset($_GET[nobreASESOR])?$_GET[nobreASESOR]:$nombreASESOR) ?>

	                        </p>

	                      </div>

		                  <p>&nbsp;</p></td>

	                  </tr>

		              <tr>

		                <td width="72%">&nbsp;</td>

		                <td width="28%">&nbsp;</td>

	                  </tr>

                      <?php

					  $_sql = "SELECT idagrupador, descripcion,total FROM agrupador";

					  if(!$result = $db->select($_sql)){

					  echo "Query:<br> $db->last_query<br>";

					  echo "Error:<br> $db->last_error";

					  return;

					  }

					  $_arreglo = array();

					  while($row = mysql_fetch_array($result))

					  {

						  //print_r($row);

						  array_push($_arreglo,$row[idagrupador],$row[descripcion],$row[total]);

					   }

					   $sizeof = count($_arreglo);

					   $sizeof /= 3;	

					   $j = 0;

					   for($i = 0; $i < sizeof($_arreglo); $i+=3)

					   {

					  ?>

                      <tr>

		                <td nowrap="nowrap"><?php echo $_arreglo[$i + 1]."-".(floatval($_arreglo[$i + 2])*100)."%"; ?></td>

	                    <td><table border="0" width="100%">

		                  <tr>

		                    <td width="33%" align="center"> SI</td>

		                    <td width="33%">NO</td>

		                    <td width="33%">N/A</td>

		                    </tr>

		                  </table></td>

		                </tr>

		              <tr>

                      <?php

					  $_sql = "SELECT descripcion, puntaje,identificador FROM atributo WHERE rel_agrup = ".$_arreglo[$i];

					  if(!$result = $db->select($_sql)){

					  echo "Query:<br> $db->last_query<br>";

					  echo "Error:<br> $db->last_error";

					  return;

					  }

					   while($row = mysql_fetch_array($result))

					  {

					  ?>

                      <tr>

		                <td id="opciones"><?php echo $row[descripcion]."-".(floatval($row[puntaje])*100)."%"; ?></td>

		                  <td><table border="0" width="100%" >

		                  <tr>

		                    <td width="33%"><input type="radio" id="opcion_<?=$row[identificador] ?>" name="opcion_<?=$row[identificador] ?>" value="SI" <?php if($action == "update" || $_GET[action] == "update"){if($_editarray[$j + 1] == 'SI'){ echo 'checked="checked"';}}?>/></td>

		                    <td width="33%"><input name="opcion_<?=$row[identificador] ?>" type="radio" id="opcion_<?=$row[identificador] ?>" value="NO" <?php if($action == "update" || $_GET[action] == "update"){if($_editarray[$j + 1] == 'NO'){ echo 'checked="checked"';}}?>/></td>

		                    <td width="33%"><input name="opcion_<?=$row[identificador] ?>" type="radio" id="opcion_<?=$row[identificador] ?>" value="NA" <?php if($action == "update" || $_GET[action] == "update"){if($_editarray[$j + 1] == 'NA'){ echo 'checked="checked"';}}else{echo 'checked="checked"';}?>/></td>

		                    </tr>

		                  </table></td>

	                  </tr>

                      <?php

					  $j+=2;

					  }

					   }

					  ?>

                      <?php 

					  if($action == "update" || $_GET[action] == "update"){

					  ?>

		              <tr>

		                <td nowrap="nowrap">Calificacion:</td>

		                

		                <td><table border="0" width="100%" >

		                  <tr>

		                    <td colspan="2"><input type="text" disabled="disabled" size="5" id="calificacion_1" name="calificacion_1" value="<?=(($action  == "update" || $_GET[action] == "update")?($rowall[calif]*100):'')?>"/></td>

		                    </tr>

		                  </table></td>

	                  </tr>

                      <?php 

					  }

					  ?>

		              <tr>

		                <td colspan="2"><p>Resumen Monitoreo: </p>

		                  <p>

		                    <textarea name="resumen" cols="120" rows="5" wrap="off" id="resumen"><?=(($action  == "update" || $_GET[action] == "update")?$rowall[resume]:'')?></textarea>

	                      </p></td>

	                  </tr>

		              <tr>

		                <td colspan="2"><p>Observaciones: </p>

		                  <p>

		                    <textarea name="observaciones" cols="120" rows="5" wrap="off"><?=(($action  == "update" || $_GET[action] == "update")?$rowall[observ]: '')?></textarea>

	                      </p></td>

	                  </tr>

		              <td colspan="2" align="center" valign="middle"><div align="center">Hora Fin:

		                <input id="fecha_fin" type="text" size="8" name="fecha_fin" readonly="readonly" value="<?=(($action  == "update" || $_GET[action] == "update")?$rowall[horafin]: date("H:i"))?>"/>

		                <br />

		                </div></td>

		                </tr>

                        <!--REMOVIDO POR QUE NO APORTA NADA AL APLICATIVO.-->

		                <!--<tr> 

		                  <td colspan="2" align="center" valign="middle">Escalamiento: 

	                      <input name="esc_cord" type="checkbox" id="esc_cord" value="1" /> 

	                      Coordinacion 

	                      <input name="esc_forma" type="checkbox" id="esc_forma" value="2" /> 

	                      Formacion 

	                      <input name="esc_super" type="checkbox" id="esc_super" value="3" /> 

	                      Supervision</td>

	                  </tr>-->

		              </table>

		              <p>

		                <input type="submit" value="<?=(($_GET[action]=='update' or $action=='update')?'Guardar Cambios':'Guardar')?>" onclick="return guardar_calidad();"/>

		              </p></td>

	              </tr>

	            </table></td>

		      </tr>

		    </table></td>

		  </tr>

		  </table>

	    <br>

      		<input type="hidden" name="idASESOR" id="idASESOR" value="<?=(isset($_GET[user])?$_GET[user]:$idASESOR) ?>" />

		   	<input type="hidden" name="id" id="id" value="<?=(isset($_GET[id])?$_GET[id]:$id) ?>" />

		   	<input type="hidden" name="idtipo" id="idtipo" value="<?php  echo $_tip; ?>" />

		</form>	

	</body>

</html>

<?php 

if($_GET[action]=='update' or $action=='update'){

	?>

	<script type="text/javascript">

	var info_bd=new Array();

	

	<?php foreach($_row as $index=>$value){?>

		info_bd['<?=$index ?>']='<?=($value=='NULL'?'':utf8_encode($value)) ?>';

	<?php }?>						

				

	formas=new Array();

	

	formas=top.frames['derecha'].document.forms;	

	forma=formas[0];

	

	elementos=new Array();

	elementos=forma.elements;

							

	for(i=0;i<elementos.length;i++){	

		

		switch(elementos[i].type){

			case 'text':						

				elementos[i].value=info_bd[elementos[i].name];				

				if(elementos[i].value=='undefined'){

					elementos[i].value='';

				}

				break;

			case 'hidden':						

				elementos[i].value=info_bd[elementos[i].name];

				elementos[i].click();

				if(elementos[i].value=='undefined'){

					elementos[i].value='';

				}

				break;

			case 'radio':				

				if(elementos[i].value==info_bd[elementos[i].name]){

					//console.log('Elemento: '+ elementos[i].name);

					//console.log(elementos[i].value+'=='+info_bd[elementos[i].name]);

					elementos[i].click();

					//elementos[i].checked=true;

					

				}

				break;																								

		}

	}

	document.getElementById('calificar').click();	 

	</script>

	<?php 

}

mysql_close();

?>