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