/**
* @param $typeOfReturn
* @param $id
* @param $active
* @param $email
*/
public function select($typeOfReturn = NULL, $id = NULL, $active = NULL, $email = NULL, $quant_limit = NULL, $quant_started = NULL, $date = NULL, $date_symbol = ">=")
{
$arrayFilter = array();
$query = "SELECT *\r\n\t\t\t\t\t FROM \r\n\t\t\t\t\t \t " . $this->TABLE_NAME . "\r\n\t\t\t\t \t WHERE 1 ";
$this->addFilter($query, $id, $active, $email, $date, $date_symbol);
$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\t" . $this->TABLE_NAME . "\r\n\t\t\t\t\t\t\tWHERE 1\r\n \t \t\t\t\t\t";
$this->addFilter($queryCount, $id, $active, $email, $date, $date_symbol);
//limite
$query .= parent::limit($quant_limit, $quant_started);
//executa a query
$ReturnDataVO = parent::query($query);
// var_dump($query);
//executa a query
$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->success = FALSE;
$ReturnDataVO->result = "error newsletter not have vo";
// var_dump($ReturnDataVO);
// $ReturnDataVO->fetchAllVO($this);
// exit();
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;
}
}
