< = YEAR(CURRENT_DATE) ORDER by apertura DESC”, $link);
}
elseif ($_POST[‘vencidas’]==”1″){
$result = mysql_query(“SELECT *, UNIX_TIMESTAMP(apertura) as tsFecha FROM licitaciones WHERE YEAR(apertura) >= YEAR(CURRENT_DATE) AND apertura > CURRENT_DATE ORDER by apertura DESC”, $link);
}
elseif ($_POST[‘vencidas’]==”2″){
$result = mysql_query(“SELECT *, UNIX_TIMESTAMP(apertura) as tsFecha FROM licitaciones WHERE YEAR(apertura) >= YEAR(CURRENT_DATE) AND apertura < CURRENT_DATE ORDER by apertura DESC", $link); } } else{ if ($_POST['vencidas']=="0"){ $result = mysql_query("SELECT *, UNIX_TIMESTAMP(apertura) as tsFecha FROM licitaciones WHERE tipo='".$_POST['tipo']."' AND YEAR(apertura) >= YEAR(CURRENT_DATE) ORDER BY apertura DESC;”, $link);
}
elseif ($_POST[‘vencidas’]==”1″){
$result = mysql_query(“SELECT *, UNIX_TIMESTAMP(apertura) as tsFecha FROM licitaciones WHERE tipo='”.$_POST[‘tipo’].”‘ AND YEAR(apertura) >= YEAR(CURRENT_DATE) AND apertura >= CURRENT_DATE ORDER BY apertura DESC;”, $link);
}
elseif ($_POST[‘vencidas’]==”2″){
$result = mysql_query(“SELECT *, UNIX_TIMESTAMP(apertura) as tsFecha FROM licitaciones WHERE tipo='”.$_POST[‘tipo’].”‘ AND YEAR(apertura) >= YEAR(CURRENT_DATE) AND apertura < CURRENT_DATE ORDER BY apertura DESC;", $link); } #$result = mysql_query("SELECT * FROM licitaciones WHERE tipo='".$_POST['tipo']."' AND (MONTH(apertura) > MONTH(CURRENT_DATE) -1 OR apertura > CURRENT_DATE) ORDER BY apertura DESC;”, $link);

}
}
else if ($_POST[‘enviar’]==”Buscar”){
$result = mysql_query(“SELECT * FROM compras.licitaciones where numero = ‘”.$_POST[‘numero’].”‘ and anio = ‘”.$_POST[‘anio’].”‘;”, $link);
}
else {
$result = mysql_query(“SELECT *, UNIX_TIMESTAMP(apertura) as tsFecha FROM licitaciones WHERE YEAR(apertura) >= YEAR(CURRENT_DATE) AND apertura >= CURRENT_DATE ORDER by apertura DESC”, $link);
#$result = mysql_query(“SELECT * FROM licitaciones WHERE MONTH(apertura) > (MONTH(CURRENT_DATE)) -1 OR apertura > CURRENT_DATE ORDER by apertura DESC”, $link);
}
echo ”

Formulario Personas Fisicas

Formulario Personas Jurídicas

Mostrar:
Buscar: Número Año
“;

if ($row = mysql_fetch_array($result))
{
//cambio de fecha
$anio = substr($row[“apertura”],0,4);
$mes = substr($row[“apertura”],5,2);
$dia = substr($row[“apertura”],8,2);
//fin
do{
if ($row[“tipo”] == “COMPRA DIRECTA”)
{
$dice = “Recepcion de ofertas hasta:”;
}
else {
$dice = “Apertura:”;
}

$fechaunixhoy = mktime(0,0,0,date(‘m’),date(‘d’),date(‘Y’));

if ($row[“tsFecha”] < $fechaunixhoy){ $vencida="“;
}
else {
$vencida =””;
}

echo ”

“;

} while ($row = mysql_fetch_array($result));
echo “

“.$row[“tipo”].” N° “.$row[“numero”].”/”.$row[“anio”].”
Objeto: “.$row[“objeto”].” Expediente N°: “.$row[“expediente”].” Valor del pliego $: “.$row[“valor”].” “.$dice.” “.substr($row[“apertura”],8,2).”/”.substr($row[“apertura”],5,2).”/”.substr($row[“apertura”],0,4).” Hora: “.substr($row[“hora”],0,5).”
“.$row[“detalle”].”
Publicado el “.substr($row[“fechapub”],8,2).”/”.substr($row[“fechapub”],5,2).”/”.substr($row[“fechapub”],0,4).” a las “.substr($row[“horapub”],0,5).”

Descargar Pliego

“.$vencida.”


“;
}
else
{
echo “

“;
}

?>