public function get_total_results()
{
if (!empty($this->where)) {
foreach ($this->where as $where) {
$this->basic_model->where($where[0], $where[1], $where[2]);
}
}
if (!empty($this->or_where)) {
foreach ($this->or_where as $or_where) {
$this->basic_model->or_where($or_where[0], $or_where[1], $or_where[2]);
}
}
if (!empty($this->like)) {
foreach ($this->like as $like) {
$this->basic_model->like($like[0], $like[1], $like[2]);
}
}
if (!empty($this->or_like)) {
foreach ($this->or_like as $or_like) {
$this->basic_model->or_like($or_like[0], $or_like[1], $or_like[2]);
}
}
if (!empty($this->having)) {
foreach ($this->having as $having) {
$this->basic_model->having($having[0], $having[1], $having[2]);
}
}
if (!empty($this->or_having)) {
foreach ($this->or_having as $or_having) {
$this->basic_model->or_having($or_having[0], $or_having[1], $or_having[2]);
}
}
if (!empty($this->relation)) {
foreach ($this->relation as $relation) {
$this->basic_model->join_relation($relation[0], $relation[1], $relation[2]);
}
}
if (!empty($this->relation_n_n)) {
$columns = $this->get_columns();
foreach ($columns as $column) {
//Use the relation_n_n ONLY if the column is called . The set_relation_n_n are slow and it will make the table slower without any reason as we don't need those queries.
if (isset($this->relation_n_n[$column->field_name])) {
$this->basic_model->set_relation_n_n_field($this->relation_n_n[$column->field_name]);
}
}
}
return $this->basic_model->get_total_results();
}
protected function get_total_results()
{
if (!empty($this->where)) {
foreach ($this->where as $where) {
$this->basic_model->where($where[0], $where[1], $where[2]);
}
}
if (!empty($this->or_where)) {
foreach ($this->or_where as $or_where) {
$this->basic_model->or_where($or_where[0], $or_where[1], $or_where[2]);
}
}
if (!empty($this->like)) {
foreach ($this->like as $like) {
$this->basic_model->like($like[0], $like[1], $like[2]);
}
}
if (!empty($this->or_like)) {
foreach ($this->or_like as $or_like) {
$this->basic_model->or_like($or_like[0], $or_like[1], $or_like[2]);
}
}
if (!empty($this->relation)) {
foreach ($this->relation as $relation) {
$this->basic_model->join_relation($relation[0], $relation[1], $relation[2]);
}
}
return $this->basic_model->get_total_results();
}