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;
}
}
