public function findAll($opciones = array(), $pagina = 1, $items_by_page = 20) { $db = CoreDb::getInstance(); $where = ""; // select all active users if (sizeof($opciones) > 0) { $w = CoreRoute::getWhere($opciones); if (sizeof($w) > 0) { $where = " WHERE " . implode(" AND ", $w); } } $result = $db->query("SELECT count(id) as total FROM " . $this->dbTable . $where, 1); $total = $result[0]["total"]; $result = $db->query("SELECT * FROM " . $this->dbTable . $where . " LIMIT " . ($pagina - 1) * $items_by_page . "," . $items_by_page); return array("records" => $result, "total" => $total); }
public static function getDbInstance() { return CoreDb::getInstance(); }