<?php

/**
 * Classe DAO - Tipi
 * @since 22/03/2011 14:29:02
 * @author Oliveira, Humberto <holiveira.wordpress[at]gmail.com[dot]com>
 */
 
class TipiDAO {

 public function TipiDAO() { }
 

 public function listarGeral() {
  $db = DataBaseServer::getInstancia();
  
  echo $_REQUEST['limit'];

  $_pag['porPagina'] = $db->getParameter('QTDREGPAGINA');
  $_pag['total']     = $db->getNumRowsTable("TAB_TIPI");

  $db->query("select ID_NCM
                   , DS_NCM
       , NR_PERCENTUAL
       , BL_TRIBUTADO
       , ID_NCMPAI
       , BL_ANALITICO
                      from TAB_TIPI
                  order by ID_NCM asc ");
      
  if ($db->getNumRows() > 0) {
   $listaTipi = array();
   for ($cont = 0; $cont < $db->getNumRows(); $cont++) {
    $listaTipi[$cont] = new Tipi();
    $listaTipi[$cont]->setIdNcm($db->result('ID_NCM', $cont));
    $listaTipi[$cont]->setDsNcm($db->result('DS_NCM', $cont));
    $listaTipi[$cont]->setNrPercentual($db->result('NR_PERCENTUAL', $cont));
    $listaTipi[$cont]->setBlTributado($db->result('BL_TRIBUTADO', $cont));
    $listaTipi[$cont]->setIdNcmPai($db->result('ID_NCMPAI', $cont));
    $listaTipi[$cont]->setBlAnalitico($db->result('BL_ANALITICO', $cont));
   }
   $_REQUEST['total']   = $_pag['total'];
   $_REQUEST['totalRegPagina']   = $_pag['porPagina'];
   return $listaTipi;
  } else {
   return false;
  }
 }
 
}

?>