function __construct()
{
global $configs;
$this->baseUrl = $configs["COLLAP_BASE_URL"];
$this->jobsBaseUrl = $configs["JOBS_COLLAP_BASE_URL"];
$this->url = rtrim($this->baseUrl, "/") . $_SERVER[REQUEST_URI];
global $logger;
$this->logger = $logger;
$this->logger->debug("BaseController started");
if (isset($_SESSION["user_id"])) {
$this->userId = $_SESSION["user_id"];
$this->username = $_SESSION["username"];
$this->firstName = $_SESSION['first_name'];
$this->lastName = $_SESSION['last_name'];
}
$DAOFactory = new DAOFactory();
$this->challengesDAO = $DAOFactory->getChallengesDAO();
$this->projectsDAO = $DAOFactory->getProjectsDAO();
$this->userInfoDAO = $DAOFactory->getUserInfoDAO();
$this->userSkillDAO = $DAOFactory->getSkillsDAO();
$this->challengeResponsesDAO = $DAOFactory->getChallengeResponsesDAO();
$this->projectResponsesDAO = $DAOFactory->getProjectResponsesDAO();
$this->teamsDAO = $DAOFactory->getTeamsDAO();
$this->notificationsDAO = $DAOFactory->getNotificationsDAO();
$this->userEducationDAO = $DAOFactory->getEducationDAO();
$this->userTechStrengthDAO = $DAOFactory->getTechnicalStrengthDAO();
$this->userWorkHistoryDAO = $DAOFactory->getWorkingHistoryDAO();
$this->userJobPreferenceDAO = $DAOFactory->getJobPreferenceDAO();
$this->userSkillsInsertDAO = $DAOFactory->getUserSkillsDAO();
$this->jobLocationsDAO = $DAOFactory->getWorkingLocationsDAO();
$this->userPreferredLocationsDAO = $DAOFactory->getUserLocationsDAO();
$this->involveInDAO = $DAOFactory->getInvolveInDAO();
$this->userSocialLinksDAO = $DAOFactory->getUserSocialLinksDAO();
$this->collaborativeRoleDAO = $DAOFactory->getUserCollaborativeRoleDAO();
$this->userPushFormsDAO = $DAOFactory->getFormsDAO();
$this->userPushFormsInsertDAO = $DAOFactory->getUserFormsDAO();
$this->userAccessAidDAO = $DAOFactory->getUserAccessAidDAO();
$this->process();
}
public function __construct()
{
$DAOFactory = new DAOFactory();
$this->collapDAO = $DAOFactory->getProjectResponsesDAO();
}
public function getUserPublicProjects($userId, $start, $limit)
{
$sql = "(SELECT DISTINCT project.id, project.project_title as title, project.stmt as statement, project.type, project.creation_time, project.status, \r\n\t\t\t\t\tuser.first_name, user.last_name, user.username \r\n\t\t\t\t\tFROM projects as project JOIN user_info as user JOIN teams as team \r\n\t\t\t\t\tWHERE (project.user_id = ? OR team.user_id = ?) \r\n\t\t\t\t\t\tAND project.user_id = user.id \r\n\t\t\t\t\t\tAND project.type = 'Public' \r\n\t\t\t\t\t\tAND team.member_status = 1\r\n\t\t\t\t\t\tAND project.blob_id = 0)\r\n\t\t\t\tUNION\r\n\t\t\t\t(SELECT DISTINCT project.id, project.project_title as title, project.stmt as statement, project.type, project.creation_time, project.status, user.first_name, user.last_name, user.username \r\n\t\t\t\t\tFROM projects as project JOIN user_info as user JOIN teams as team JOIN blobs as `blob` \r\n\t\t\t\t\tWHERE (project.user_id = ? OR team.user_id = ?) \r\n\t\t\t\t\t\tAND project.user_id = user.id \r\n\t\t\t\t\t\tAND project.type = 'Public' AND team.member_status = 1\r\n\t\t\t\t\t\tAND project.blob_id = blob.id)\r\n\t\t\t\t\tORDER BY creation_time DESC ";
if (isset($start) && isset($limit)) {
$sql .= " LIMIT {$start},{$limit} ;";
} else {
$sql .= " ;";
}
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($userId);
$sqlQuery->setNumber($userId);
$sqlQuery->setNumber($userId);
$sqlQuery->setNumber($userId);
return $this->getListProjects($sqlQuery);
$projects = $this->getListProjects($sqlQuery);
$DAOFactory = new DAOFactory();
$projectResponsesDAO = $DAOFactory->getProjectResponsesDAO();
foreach ($projects as $project) {
if ($project) {
$project->setResponses($projectResponsesDAO->queryAllResponse($project->getId()));
}
}
return $projects;
}
