public function GetMayor()
{
$Controller = new Controller();
$sql = "select max(ID_MERMA) as mayor from " . $this->tabla;
$result = $Controller->ejecute($sql);
$row = mysql_fetch_array($result);
return $row["mayor"];
}
public function getArea($idarea)
{
if (isset($idarea) && $idarea != "") {
$Controller = new Controller();
return $Controller->ejecute("Select * from AREAS WHERE ID_AREA=" . $idarea);
}
}
public function TablePersonalizada($sql)
{
$Controller = new Controller();
//$sql= "SELECT * FROM USUARIOS";
$result = $Controller->ejecute($sql);
$nfilas = mysql_num_rows($result);
$tabla = "";
if ($nfilas > 0) {
$tabla = "<table class='filapar' align='center' border=1>";
$tabla = $tabla . "<tr class='titulosTabla'><td>N°</td><td>Nombre</td><td>Departamento</td><td>Fecha de Creacion</td></tr>";
for ($i = 0; $i < $nfilas; $i++) {
$id_obra = mysql_result($result, $i, 0);
$nombre_obra = mysql_result($result, $i, 3);
$id_departamento = mysql_result($result, $i, 2);
$sql2 = "SELECT NOMBRE_DEPARTAMENTO FROM DEPARTAMENTOS WHERE ID_DEPARTAMENTO = {$id_departamento}";
$result2 = $Controller->ejecute($sql2);
$nfilas2 = mysql_num_rows($result2);
if ($nfilas2 > 0) {
$departamento = mysql_result($result2, 0, 0);
} else {
$departamento = "Administrador";
}
$fecha_inicio_obra = mysql_result($result, $i, 6);
$indice = $i + 1;
$tabla = "{$tabla} <tr>";
$tabla = "{$tabla} <td> {$indice} </td>";
$tabla = "{$tabla} <td> {$nombre_obra} </td>";
$tabla = "{$tabla} <td>{$departamento}</td>";
$tabla = "{$tabla} <td>{$fecha_inicio_obra}</td>";
//$tabla = "$tabla <td align='center' ><a href='paso.php?c=8&editar=".$id_usuario."'><img border=0 src='imagenes/editar.jpg' width='15' height='15' ></a></td>";
//$tabla = "$tabla <td align='center' ><a href='javascript: display_alert($id_usuario)' ><img border=0 src='imagenes/delete.jpg' width='15' height='15'></a></td>";
$tabla = "{$tabla} </tr>";
}
$tabla = $tabla . "</table>";
}
//$tabla = "hola!!! $sql";
return $tabla;
}
