/**
* Create a new query
*
* @access public
* @return ActivityFilter
*/
public function create()
{
$this->query = $this->db->table(ProjectActivity::TABLE);
$this->query->left(User::TABLE, 'uc', 'id', ProjectActivity::TABLE, 'creator_id');
$this->query->columns(ProjectActivity::TABLE . '.*', 'uc.email AS creator_email', 'uc.username AS creator_username');
return $this;
}
/**
* Create a new query
*
* @access public
* @return TaskFilter
*/
public function create()
{
$this->query = $this->db->table(Task::TABLE);
$this->query->left(User::TABLE, 'ua', 'id', Task::TABLE, 'owner_id');
$this->query->left(User::TABLE, 'uc', 'id', Task::TABLE, 'creator_id');
$this->query->columns(Task::TABLE . '.*', 'ua.email AS assignee_email', 'ua.username AS assignee_username', 'uc.email AS creator_email', 'uc.username AS creator_username');
return $this;
}
