<?php
$conexion= pg_connect("host=172.16.0.108 port=5432 dbname=enterprise_2016 password=postgres 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{
         
         
         
    
     
     
?>

<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>
                          
           
     
                     <input type="submit" value="Habilitar Recibo de Pago">    
                   
                        
                    
                    
                    
                
                  
</form>
 <?php  } ?>