+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Bug: Double use where and etc (/showthread.php?tid=75018)
Bug: Double use where and etc - XTAZ - 12-08-2019
Hello!
Model have paginate method, I needs extends it in my model.
I extends countAllResults() and findAll()
PHP Code:
public function paginateByUser($user_id = null, int $perPage = 20, string $group = 'default', int $page = 0)
{
// Get the necessary parts.
$page = $page >= 1 ? $page : (ctype_digit($_GET['page'] ?? '') && $_GET['page'] > 1 ? $_GET['page'] : 1);
$total = $this->countAllResultsByUser($user_id, false);
// Store it in the Pager library so it can be
// paginated in the views.
$pager = \Config\Services::pager();
$this->pager = $pager->store($group, $page, $perPage, $total);
$offset = ($page - 1) * $perPage;
return $this->findAllByUser($user_id, $perPage, $offset);
}
public function findAllByUser($user_id = null, int $limit = 0, int $offset = 0)
{
if (is_null($user_id))
$user_id = \Config\Services::auth()->getUserID();
$this->select($this->table.'.*');
$this->join('users_projects up', 'up.project_id = '.$this->table.'.project_id AND up.deleted_at IS NULL AND up.user_id = '.intval($user_id));
return parent::findAll($limit, $offset);
}
public function countAllResultsByUser($user_id = null, bool $reset = true, bool $test = false)
{
if (is_null($user_id))
$user_id = \Config\Services::auth()->getUserID();
$this->join('users_projects up', 'up.project_id = '.$this->table.'.project_id AND up.deleted_at IS NULL AND up.user_id = '.intval($user_id));
return parent::countAllResults($reset, $test);
}
I cant remove join from one function, because it can be used independently.
Generated query:
Code:
SELECT `my_table`.*
FROM `my_table`
JOIN `users_projects` `up` ON `up`.`project_id` = `my_table`.`project_id` AND `up`.`deleted_at` IS NULL AND `up`.`user_id` = 1
JOIN `users_projects` `up` ON `up`.`project_id` = `my_table`.`project_id` AND `up`.`deleted_at` IS NULL AND `up`.`user_id` = 1
WHERE `my_table`.`deleted_at` IS NULL
AND `my_table`.`deleted_at` IS NULLNow I must use this hack in function findAllByUser():
PHP Code:
$compiledSelect = $this->getCompiledSelect(false);
if (strpos($compiledSelect, 'users_projects') === false)
{
$this->join('users_projects up', 'up.project_id = '.$this->table.'.project_id AND up.deleted_at IS NULL AND up.user_id = '.intval($user_id));
}