<?php
$conexion= pg_connect("host=172.16.0.102 port=5432 dbname=tves_2018 password=s1st3m4s2424bd user=postgres");




    ?>


              
        <?php $q=pg_query("SELECT h.codnom, h.codperi, h.fecdesper, h.fechasper, n.desnom "
                . " FROM sno_periodo h "
                . " inner join sno_nomina n "
                . " on n.codnom = h.codnom "
                . " where h.estatus_periodo = '0' "
                . " and h.cerper = '1'"
                . " order by h.codnom ,h.codperi");
        
        
        $rows = pg_num_rows($q);

 if ( $rows == 0){
       echo "<div style=' text-align: center; border: 1px solid darkgoldenrod; color:  #ffffff; background-color: #ff8647;'> NO HAY PERIODOS POR HABILITAR</div>";
     } else{
     
?>

//<?php 
//        echo "<pre>"; //modificaciones personales ojo
//        while($reg = pg_fetch_array($q)){
//        var_dump($reg);
//        }
//        die;
//       ?>


<form action="generar2.php" method="post">
    <tr height="80">
        <td width="193" valign="middle" align="right">
            <div align="left">
                <span class="Estilo2"><strong>Seleccionar Nomina:</strong></span>
            </div>
        </td>
          
        
        <td width="471" valign="middle" align="center">
            <div align="left">
                <SELECT name="nomina">
                <?php
                while ($reg = pg_fetch_array($q)){
                //$codnom = $reg['codnom'];
                $codnom= $reg[0];
                $codperi= $reg[1];
                $fecdesper= $reg[2];
                $fechasper= $reg[3];
                $desnom= $reg[4];
                ?>      
                <OPTION VALUE= '<?php echo $codnom.' '.$codperi;?>'><?php echo $codnom.' - '.$desnom.' - Periodo '.$codperi.' - '. $fecdesper.' / '. $fechasper;//echo $reg['desnom'];?></OPTION>
                <?php
                }   
                ?>             
                </SELECT>
            </div>              
            <input type="submit" value="Habilitar Recibo de Pago">    
             
</form>
 <?php  } ?>