public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $name = NULL, $url = NULL, $author = NULL, $order_type = DbInterface::ORDER_ASC, $quant_limit = NULL, $quant_started = NULL) { $typeOfReturn = $typeOfReturn === NULL ? NULL : $typeOfReturn; $order_type = parent::verifyOrderType($order_type); //echo "login[".$login."] - password[".$password."]"; $arrayFilter = array(); $query = "SELECT * FROM `image` WHERE 1"; if ($id !== NULL) { $query .= " AND `id` = '" . DataHandler::forceInt($id) . "'"; } if ($active !== NULL) { $query .= " AND `active` = '" . DataHandler::forceInt($active) . "'"; } if ($name !== NULL) { $query .= " AND `name` = '" . DataHandler::forceString($name) . "'"; } if ($url !== NULL) { $query .= " AND `url` = '" . DataHandler::forceString($url) . "'"; } if ($author !== NULL) { $query .= " AND `author` = '" . DataHandler::forceString($author) . "'"; } //limite $query .= parent::limit($quant_limit, $quant_started); $query .= " ORDER BY `order` {$order_type} "; //executa a query $ReturnDataVO = parent::query($query); //verifica se conseguiu ocorreu tudo certo if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $typeOfReturn * @param $id * @param $active * @param $state_id * @param $state * @param $country * @param $alias * @param $street * @param $number * @param $quant_limit * @param $quant_started * @return unknown_type */ public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $state_id = NULL, $state = NULL, $country = NULL, $alias = NULL, $street = NULL, $number = NULL, $quant_limit = NULL, $quant_started = NULL) { $arrayFilter = array(); $query = "SELECT \n\t\t\t\t\t\t*\n\t\t\t\t\t\tFROM \n\t\t\t\t\t \taddress \n\t\t\t\t\t WHERE 1 "; $this->addFilter($query, $id, $active, $state_id, $state, $country, $alias, $street, $number); $queryCount = "Select \n\t\t\t\t \t\t\taddress.*,\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\taddress\n\t\t\t\t\t\t\tWHERE 1\n \t \t\t\t\t\t"; $this->addFilter($queryCount, $id, $active, $state_id, $state, $country, $alias, $street, $number); //limite $query .= parent::limit($quant_limit, $quant_started); //executa a query $ReturnDataVO = parent::query($query); //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; //echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $table * @param $table_id * @param $typeOfReturn * @param $quant_limit * @param $quant_started * @return $ReturnDataVO */ public function selectByTableId($table, $table_id, $typeOfReturn = ContentDAO::RETURN_STD_OBJECT, $quant_limit = NULL, $quant_started = NULL, $active = 1, $search = "", $order_colunm = "order", $order_type = "ASC") { $search_query = ""; if ($search != "") { $search = DataHandler::forceString($search); $search_query = " AND\r\n\t\t\t\t\t\t\t\t(`content`.`title` LIKE '{$search}' OR\r\n\t\t\t\t\t\t\t\t`content`.`content` LIKE '{$search}' \r\n\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t"; } $query = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t`content`.*,\r\n\t\t\t\t\t\t\t\t`" . $table . "`.id as " . $table . "_id\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'content' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id AND\r\n\t\t\t\t\t\t\t `link`.active = " . $active . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `content`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `content`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "' AND\r\n\t\t\t\t\t\t\t `" . $table . "`.active = " . $active . "\r\n\t\t\t\t\t\t\t {$search_query}\r\n\t\t\t\t\t\t\t ORDER BY `link`.{$order_colunm} {$order_type}\r\n\t\t\t\t\t\t"; $queryCount = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'content' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id AND\r\n\t\t\t\t\t\t\t `link`.active = " . $active . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `content`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `content`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "' AND\r\n\t\t\t\t\t\t\t `" . $table . "`.active = " . $active . "\r\n\t\t\t\t\t\t\t {$search_query}\r\n\t\t\t\t\t\t"; //limite $query .= parent::limit($quant_limit, $quant_started); //executa a query $ReturnDataVO = parent::query($query); //echo $query; //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; //echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $typeOfReturn * @param $id * @param $active * @param $uid * @param $name * @param $description * @param $order_type * @param $quant_limit * @param $quant_started * @return ReturnDataVO (ReturnDataVO) */ public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $table = NULL, $table_id = NULL, $user_id = NULL, $title = NULL, $description = NULL, $date = NULL, $symble_date = ">=", $order_type = NULL, $quant_started = NULL, $quant_limit = NULL) { $arrayFilter = array(); $query = "SELECT \r\n\t\t\t\t\t\t*\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \tcomment \r\n\t\t\t\t\t WHERE 1 "; $this->addFilter($query, $id, $active, $table, $table_id, $user_id, $title, $description, $date, $symble_date, $order_type); $queryCount = "Select \r\n\t\t\t\t \t\t\tcomment.*,\r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\tcomment\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t"; $this->addFilter($queryCount, $id, $active, $table, $table_id, $user_id, $title, $description, $date, $symble_date, $order_type); //limite $query .= parent::limit($quant_limit, $quant_started); //executa a query $ReturnDataVO = parent::query($query); //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); //echo $query; if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; //echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $table * @param $table_id * @param $typeOfReturn * @param $quant_limit * @param $quant_started * @return $ReturnDataVO */ public function selectByTableId($table, $table_id, $typeOfReturn = HighLightsDAO::RETURN_STD_OBJECT, $quant_limit = NULL, $quant_started = NULL) { $query = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t`highlights`.*,\r\n\t\t\t\t\t\t\t\t`" . $table . "`.id as " . $table . "_id\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'highlights' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `highlights`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `highlights`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "'\r\n\t\t\t\t\t\t"; $queryCount = "\r\n\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t " . $table . "\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `link`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `link`.table = '" . $table . "' AND\r\n\t\t\t\t\t\t\t `link`.linked_table = 'highlights' AND\r\n\t\t\t\t\t\t\t `link`.table_id = `" . $table . "`.id\r\n\t\t\t\t\t\t\tINNER JOIN \r\n\t\t\t\t\t\t\t `highlights`\r\n\t\t\t\t\t\t\t ON \r\n\t\t\t\t\t\t\t `highlights`.id = linked_table_id \r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t 1 AND\r\n\t\t\t\t\t\t\t `" . $table . "`.id = '" . $table_id . "'\r\n\t\t\t\t\t\t"; //limite $query .= parent::limit($quant_limit, $quant_started); //executa a query $ReturnDataVO = parent::query($query); //echo $query; //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; //echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * * @param (string) $typeDeRetorno UsuarioDAO::RETORNO_STD_OBJECT, UsuarioDAO::RETORNO_VO, UsuarioDAO::RETORNO_ARRAY * @param (int) $id (opcional) * @param (int) $active (opcional) * @param (string) $name (opcional) * @param (string) $uf (opcional) * @param (id) $country_id (opcional) * @param (int) $quant_limite = NULL * @param (int) $quant_started = NULL * * @return class ReturnDataVO */ public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $name = NULL, $uf = NULL, $country_id = NULL, $quant_limit = NULL, $quant_started = NULL) { $arrayFilter = array(); $query = "SELECT \r\n\t\t\t\t\t\tstate.*,\r\n\t\t\t\t\t\tcountry.id as country_id,\r\n\t\t\t\t\t\tcountry.name as country_name\r\n\t\t\t\t\t FROM \r\n\t\t\t\t\t \tstate \r\n\t\t\t\t\t INNER JOIN country\r\n\t\t\t\t\t WHERE 1 AND state.country_id = country.id"; $this->addFilter($query, $id, $active, $name, $country_id, $uf); $queryCount = "Select \r\n\t\t\t\t \t\t\tstate.*,\r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\tstate\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t"; $this->addFilter($queryCount, $id, $active, $name, $country_id, $uf); //limite $query .= parent::limit($quant_limit, $quant_started); //executa a query //echo $query; $ReturnDataVO = parent::query($query); //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; //echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $typeOfReturn * @param $name * @param $mobile * @param $telephone * @param $email * @param $rg * @param $cpf * @param $company * @param $quant_limit * @param $quant_started * @param $user_type_id * @return ReturnDataVO */ public function search($typeOfReturn = NULL, $name = NULL, $mobile = NULL, $telephone = NULL, $email = NULL, $rg = NULL, $cpf = NULL, $company = NULL, $quant_limit = NULL, $quant_started = NULL, $user_type_id = NULL, $recive_news = NULL) { $arrayFilter = array(); $query = "SELECT \r\n\t\t\t\t\t\t\tuser.id as user_id,\r\n\t\t\t\t\t\t\tuser.active,\r\n\t\t\t\t\t\t\tuser.user_type_id,\r\n\t\t\t\t\t\t\tuser.login,\r\n\t\t\t\t\t\t\tuser.password,\r\n\t\t\t\t\t\t\tuser.email as user_email, \r\n\t\t\t\t\t\t\tuser_details.*\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \t\tuser_details\r\n\t\t\t\t\t \tINNER JOIN \r\n\t\t\t\t\t \t\tuser ON user.id = user_details.id\r\n\t\t\t\t\t WHERE 1 "; $this->addFilterToSearch($query, $name, $mobile, $telephone, $email, $rg, $cpf, $company, $user_type_id, $recive_news); $queryCount = "\r\n\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \t\tuser_details\r\n\t\t\t\t\t \tINNER JOIN \r\n\t\t\t\t\t \t\tuser ON user.id = user_details.id\r\n\t\t\t\t\t WHERE 1 \r\n\t \t \t\t\t\t\t"; $this->addFilterToSearch($queryCount, $name, $mobile, $telephone, $email, $rg, $cpf, $company, $user_type_id, $recive_news); //limite $query .= parent::limit($quant_limit, $quant_started); // echo $query; //executa a query $ReturnDataVO = parent::query($query); //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; //echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $typeOfReturn * @param $table * @param $table_id * @param $linked_table * @param $linked_table_id * @param $active * @param $quant_started * @param $quant_limit * @return (ReturnDataVO) $ReturnDataVO */ function select($typeOfReturn = DbInterface::RETURN_ARRAY, $table = NULL, $table_id = NULL, $linked_table = NULL, $linked_table_id = NULL, $active = NULL, $quant_started = NULL, $quant_limit = NULL, $order_by = "order", $order_type = " ASC ") { /*if($table == NULL || $table_id == NULL){ $ReturnDataVO = new ReturnDataVO(); $ReturnDataVO->success = FALSE; $ReturnDataVO->code_return = DbInterface::ERROR_LINK_DONOT_HAVE_TABLE_OR_TABLE_ID; return $ReturnDataVO; }*/ //pegando todos os links com essa table $query = "SELECT * \r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t`link`\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t"; $queryCount = "SELECT Count(*) as count\r\n\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t`link`\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t"; if ($table != NULL) { $query .= " AND `table` = '{$table}' "; $queryCount .= " AND `table` = '{$table}' "; } if ($table_id != NULL) { $query .= " AND `table_id` = '{$table_id}' "; $queryCount .= " AND `table_id` = '{$table_id}' "; } if ($linked_table != NULL) { $query .= " AND linked_table = '{$linked_table}' "; $queryCount .= " AND linked_table = '{$linked_table}' "; } if ($linked_table_id != NULL) { $query .= " AND linked_table_id = '" . DataHandler::forceInt($linked_table_id) . "' "; $queryCount .= " AND linked_table_id = '" . DataHandler::forceInt($linked_table_id) . "' "; } if ($active != NULL) { $query .= " AND active = '" . DataHandler::forceInt($active) . "' "; $queryCount .= " AND active = '" . DataHandler::forceInt($active) . "' "; } $query .= " ORDER BY `{$order_by}` {$order_type}"; //Debug::li($query); $query .= parent::limit($quant_limit, $quant_started); $ReturnDataVO = parent::query($query); //echo $query; $ReturnTotalDataVO = parent::query($queryCount); //echo $queryCount; //print_r($ReturnTotalDataVO);exit(); if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); break; } $ReturnTotalDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; // echo Debug::print_r($ReturnDataVO); return $ReturnDataVO; } else { return $ReturnDataVO; } }
/** * @param $typeOfReturn * @param $id * @param $active * @param $user_type_id * @param $login * @param $password * @param $email_type * @param $quant_limit * @param $quant_started * @return ReturnDataVO (ReturnDataVO) */ public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $user_type_id = NULL, $login = NULL, $password = NULL, $email = NULL, $quant_limit = NULL, $quant_started = NULL) { $arrayFilter = array(); $query = "SELECT \r\n\t\t\t\t\t\t*\r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t \tuser \r\n\t\t\t\t\t WHERE 1 "; $this->addFilter($query, $id, $active, $user_type_id, $login, $password, $email); $queryCount = "SELECT \r\n\t\t\t\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\tuser\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t"; $this->addFilter($queryCount, $id, $active, $user_type_id, $login, $password, $email); //limite $query .= parent::limit($quant_limit, $quant_started); //executa a query $ReturnDataVO = parent::query($query); //executa a query para gerar count total $ReturnTotalDataVO = parent::query($queryCount); if (FALSE) { $ReturnDataVO = new ReturnDataVO(); } if ($ReturnDataVO->success) { switch ($typeOfReturn) { case DbInterface::RETURN_ARRAY: $ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY); break; case DbInterface::RETURN_VO: $ReturnDataVO->fetchAllVO($this); break; case DbInterface::RETURN_STD_OBJECT: default: //retornar tudo em objeto $ReturnDataVO->fetchAll(); break; } $ReturnTotalDataVO->fetchAll(); $tempTotal = $ReturnTotalDataVO->result[0]->count; $ReturnDataVO->count_total = $tempTotal; return $ReturnDataVO; } else { return $ReturnDataVO; } }