<table width="550" cellspacing="0" cellpadding="0" border="0">
<tr>
<td width="550" valign="top">
Código PHP:
<?
include "../conexion2.php";
if (!isset($accion)){
$fechav=$vdia. "/" .$vmes. "/" .$vano;
$result=mysql_query("select * from prueba where id=$id", $conexion);
$row=mysql_fetch_row($result);
echo"<html>
<head>
<title>prueba</title>
<script type='text/javascript' src='formexp.js'></script>
<script>
function expandir_formulario(){
if (document.m.propuesta.value == '0'){
xDisplay('capaexpansion', 'none')
xDisplay('capaexpansion2', 'none')
}
if (document.m.propuesta.value == 'si'){
xDisplay('capaexpansion', 'block')
xDisplay('capaexpansion2', 'none')
}
if (document.m.propuesta.value == 'no'){
xDisplay('capaexpansion', 'none')
xDisplay('capaexpansion2', 'none')
}
}
</script>
</head>
<body>
<form action=\"actualizar.php?accion=guardar\" method=\"post\">
<input type=hidden name=fechav value=''>
<input type=hidden name=horav value=''>
<input type=hidden name=fechap value=''>
<input type=hidden name=horap value=''>
<input type=hidden name=frespuesta value=''>
<input type=hidden name=medio value=''>
<input type=\"hidden\" name=\"id\" value=\"$row[0]\">
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr>
<td width=20> </td>
<td width=160><font class=texto>Ejecutivo</font></td>
<td width=180>
<select name=\"ejecutivo\" style='width:180px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value=\"$row[1]\" Selected>Ejecutivo</option>
<option value=Ejecutivo1>Ejecutivo1</option>
<option value=Ejecutivo2>Ejecutivo2</option>
<option value=Ejecutivo3>Ejecutivo3</option>
</select>
</td>
<td width=190> </td>
</tr>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160><font class=texto>Agencia ó Central</font></td>
<td width=180>
<select name=\"agencia\" style='width:180px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value=\"$row[2]\" Selected>Agencia</option>
<option value=Agencia1>Agencia1</option>
<option value=Agencia2>Agencia2</option>
<option value=Agencia3>Agencia3</option>
<option value=Agencia4>Agencia4</option>
<option value=Agencia5>Agencia5</option>
</select>
</td>
<td width=190> </td>
</tr>
</table>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160><font class=texto>Representante</font></td>
<td width=310><input type=\"text\" value=\"$row[3]\" name=\"representante\" style='width:300px;height:18px;font-size:12px;font-family:arial;font-weight:normal; color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'></td>
<td width=60> </td>
</tr>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160><font class=texto>Motivo de Visita</font></td>
<td width=310><input type=\"text\" value=\"$row[4]\" name=\"visita\" style='width:300px;height:18px;font-size:12px;font-family:arial;font-weight:normal; color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'></td>
<td width=60> </td>
</tr>
</table>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160 valign=top><font class=texto>Fecha de visita a la agencia</font></td>
<td width=210 valign=top>
<select name=\"vdia\" style='width:45px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value='' selected>Día</option>
<option value=1>1</option>
<option value=2>2</option>
<option value=3>3</option>
<option value=4>4</option>
<option value=5>5</option>
<option value=6>6</option>
<option value=7>7</option>
<option value=8>8</option>
<option value=9>9</option>
<option value=10>10</option>
</select>
<select name=\"vmes\" style='width:90px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value='' selected>Mes</option>
<option value=enero>Enero</option>
<option value=febrero>Febrero</option>
<option value=marzo>Marzo</option>
<option value=abril>Abril</option>
<option value=mayo>Mayo</option>
<option value=junio>Junio</option>
<option value=julio>Julio</option>
<option value=agosto>Agosto</option>
<option value=septiembre>Septiembre</option>
<option value=octubre>Octubre</option>
<option value=noviembre>Noviembre</option>
<option value=diciembre>Diciembre</option>
</select>
<select name=\"vano\" style='width:55px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value='' selected>Año</option>
<option value=2006>2006</option>
<option value=2007>2007</option>
<option value=2008>2008</option>
<option value=2009>2009</option>
<option value=2010>2010</option>
<option value=2011>2011</option>
<option value=2012>2012</option>
<option value=2013>2013</option>
<option value=2014>2014</option>
<option value=2015>2015</option>
</select>
</td>
<td width=160> </td>
</tr>
</table>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160><font class=texto>Cliente</font></td>
<td width=310>
<select name=\"cliente\" style='width:300px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value=\"$row[7]\" Selected>Cliente</option>
<option value=Cliente1>Cliente1</option>
<option value=Cliente2>Cliente2</option>
<option value=Cliente3>Cliente3</option>
<option value=Cliente4>Cliente4</option>
<option value=Cliente5>Cliente5</option>
</select>
</td>
<td width=60> </td>
</tr>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160><font class=texto>Producto</font></td>
<td width=310><input type=\"text\" value=\"$row[8]\" name=\"producto\" style='width:300px;height:18px;font-size:12px;font-family:arial;font-weight:normal; color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'></td>
<td width=60> </td>
</tr>
</table>
<div id=capainicio>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160 valign=top><font class=texto>Propuesta</font></td>
<td width=310 valign=top>
<select name=\"propuesta\" onchange='expandir_formulario()' style='width:50px;height:18px;font-size:12px;font-family:arial;font-weight:normal;color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'>
<option value=\"$row[9]\" selected>--</option>
<option value=si>Si</option>
<option value=no>No</option>
</select>
</td>
<td width=60> </td>
</tr>
</table>
</div>
<div id=capaexpansion>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160 valign=top><font class=texto>Pendiente de Respuesta</font></td>
<td width=310 valign=top><input type=\"text\" value=\"$row[10]\" name=\"prespuesta\" style='width:300px;height:18px;font-size:12px;font-family:arial;font-weight:normal; color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'></td>
<td width=60 valign=top> </td>
</tr>
</table>
</div>
<div id=capaexpansion2></div>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=5></td></tr>
<tr>
<td width=20> </td>
<td width=160 valign=top><font class=texto>Observación</font></td>
<td width=310 valign=top><textarea rows=2 value=\"$row[11]\" name=\"observacion\" cols=28 value='' style='width:300px;height:50px;font-size:12px;font-family:arial;font-weight:normal; color:000000;border-width:1;border-style:solid;border-color:CCCDCF;background-color:ffffff'></textarea></td>
<td width=60> </td>
</tr>
</table>
<table width=550 cellspacing=0 cellpadding=0 border=0>
<tr><td height=20></td></tr>
<tr>
<td width=180> </td>
<td width=100>
<input type=\"submit\" value=\"Guardar\" name=button style='width:100px;height:22px;font-size:12px;font-family:arial;font-weight:normal;color:ffffff;border-width:1;border-style:solid;border-color:CCCDCF;background-color:235374'><br>
</td>
<td width=50> </td>
<td width=100><input type=reset value=Cancelar name=reset style='width:100px;height:22px;font-size:12px;font-family:arial;font-weight:normal;color:ffffff;border-width:1;border-style:solid;border-color:CCCDCF;background-color:235374'></td>
<td width=120> </td>
</tr>
<tr><td height=30></td></tr>
</table>
</form>
</body>
</html>";
}elseif($accion=="guardar"){
$sql = "UPDATE status SET ejecutivo='$ejecutivo', agencia='$agencia', representante='$representante', visita='$visita', fechav='$fechav', cliente='$cliente', producto='$producto', propuesta='$propuesta', prespuesta='$prespuesta', observacion='$observacion' WHERE id=$id";
$result = mysql_query($sql);
echo"
<html>
<body>
<h3>Los registros han sido actualizados</h3>
</body>
</html>";
}
include "cerrar_conexion.php";
?>
</tr>
</table>