Beispiel #1
0
 function findAll($oInicio = 0, $oQtd = 1000000, $oFiltro = "", $oOrdem = "Product_Value_ID")
 {
     //atualiza o total de registros
     $this->regTotal($oFiltro);
     $arrResultado = array();
     $r = new Recordset();
     //localiza o registro
     if ($oFiltro == "") {
         $sql = "select * from {$this->tbnome} order by {$oOrdem} limit {$oInicio}, {$oQtd}";
     } else {
         $sql = "select * from {$this->tbnome} where 1=1 {$oFiltro} order by {$oOrdem} limit {$oInicio}, {$oQtd}";
     }
     if ($this->debugMode == 1) {
         echo "<br>Debug|Product_ValueClass|findAll|1: " . $sql;
     }
     $r->open($sql, $this->c);
     if ($r->record_count > 0) {
         while (!$r->EOF) {
             $arrResultado[] = array("Product_Value_ID" => $r->item("Product_Value_ID"), "Product_ID" => $r->item("Product_ID"), "Client_ID" => $r->item("Client_ID"), "Value" => $r->item("Value"), "Date" => $r->item("Date"));
             $r->move_next();
         }
     }
     $r->close();
     return $arrResultado;
 }
Beispiel #2
0
 function findAllByProduct($oInicio = 0, $oQtd = 10, $oFiltro = "", $oOrdem = "Inventory_ID")
 {
     //atualiza o total de registros
     $this->regTotal($oFiltro);
     $arrResultado = array();
     $r = new Recordset();
     //localiza o registro
     $sql = "SELECT Product_ID, Codebar, SUM(Quantity) as Qtd FROM {$this->tbnome} where 1=1 {$oFiltro} Group By Codebar order by {$oOrdem} limit {$oInicio}, {$oQtd} ";
     if ($this->debugMode == 1) {
         echo "<br>Debug|InventoryClass|findAllByProduct|1: " . $sql;
     }
     $r->open($sql, $this->c);
     if ($r->record_count > 0) {
         while (!$r->EOF) {
             $arrResultado[] = array("Product_ID" => $r->item("Product_ID"), "Codebar" => $r->item("Codebar"), "Qtd" => $r->item("Qtd"));
             $r->move_next();
         }
     }
     $r->close();
     return $arrResultado;
 }