/** * @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; } }