<?php
include("config.inc");
include("common.inc");
global $default;
//echo "<label style='float:left; width:350px; margin:15px 2px 5px 20px;color: #000; font-size: 12pt; font-weight:bold;'>","Proceso No: ".$default->conn[ "server" ]." de ".$default->conn[ "user" ]." , ".$default->conn[ "password" ]."</label>";
//Por objetos Recomendado
$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
// check connection
if ($conn->connect_error) {
trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR);
}
$clave=$_POST['clave'];
$ciudad_proc=$_POST['ciudad_proc'];
$clave = stripslashes($clave);
$ciudad_proc = stripslashes($ciudad_proc);
$sql="SELECT * FROM $tbl_name WHERE no_tramite='$clave'";
$rs=$conn->query($sql);
if($rs === false) {
trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
} else {
$rows_returned = $rs->num_rows;
}
echo
$rs->data_seek(0);
while($row = $rs->fetch_assoc()){
echo $row['col1'] . '<br>';
}
//Devuelve numero de registros
$count = $rs->num_rows;
if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php"
$rs->data_seek(0);
while($row = $rs->fetch_assoc()){
$no_tramite= $row['no_tramite']; //echo $row['col1'] . '<br>';
}
echo "<br>";
echo "<label style='float:left; width:350px; margin:15px 2px 5px 20px;color: #000; font-size: 12pt; font-weight:bold;'>","Proceso No: ".$no_tramite." de ".$ciudad_proc,"</label>";
echo "<br>";
echo "<br>";
$tbl_name="control_estados";
$sql="SELECT estado,obs,quien,fecha FROM $tbl_name WHERE no_tramite='$no_tramite' and web='SI' order by lugar";
$rs=$conn->query($sql);
if($rs === false) {
trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
} else {
$rows_returned = $rs->num_rows;
}
//Devuelve numero de registros
$count = $rs->num_rows;
echo "<br>";
echo"<table border='0' align='center' width='80%' style='background:#FFFF;color: #000'>";
echo"<tr style='background:#176515;color: #FFFF00'>";
echo"<th>ESTADO</th>";
echo"<th>OBSERVACIÓN</th>";
echo"<th>RESPONSABLE</th>";
echo"<th>FECHA</th> ";
echo"</tr>";
$n=0;
$rs->data_seek(0);
while($row = $rs->fetch_assoc()){
$no_tramite= $row['no_tramite']; //echo $row['col1'] . '<br>';
$estado = $row['estado'];
$obs = $row['obs'];
$quien= $row['quien'];
$fecha = $row['fecha'];
if ($n==0){
echo"<tr style='background:#F1F1F1;color: #000' align='center'>";
$n=1;
}
else{ echo"<tr style='background:#B9B9B9;color: #000' align='center'>";
$n=0; }
echo "<td>$estado </td>";
echo "<td>$obs </td>";
echo "<td>$quien </td>";
echo "<td>$fecha </td>";
echo "</tr>";
}
echo "</table>";
$rs->free();
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<form id='wrapper' name='formu' action='consulta_proceso.php'>";
echo "<input id='clave3_boton' type='submit' value='VOLVER'/>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "</form>";
}
else {
echo "<br>";
echo "<br>";
echo "<label id='clave_proc2_lb'>","PROCESO NO ENCONTRADO","</label>";
echo "<br>";
echo "<br>";
echo "<form id='wrapper' name='formu' action='consulta_proceso.php'>";
echo "<input id='clave2_boton' type='submit' value='VOLVER'/>";
echo "<br>";
echo "<br>";
echo "</form>";
}
ob_end_flush();
?>