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();
}
/**
* Get project activities records from table challenge AND user_info
*/
public function getProjectActivities($projectId, $start, $limit)
{
$sql = "(SELECT challenge.user_id, challenge.id, challenge.project_id, challenge.title, challenge.stmt, challenge.type, challenge.status, challenge.likes, challenge.dislikes, challenge.creation_time, challenge.last_update_time,\r\n\t\t\t\t\t\tuser.first_name, user.last_name, user.username \r\n\t\t\t\t\tFROM challenges as challenge JOIN user_info as user JOIN projects as project \r\n\t\t\t\t\t\tWHERE challenge.project_id = ? AND challenge.status != 3 \r\n\t\t\t\t\t\t\tAND challenge.status != 7 AND user.id = challenge.user_id \r\n\t\t\t\t\t\t\tAND challenge.blob_id = 0 AND challenge.project_id = project.id)\r\n\t\t\t\tUNION\r\n\t\t\t\t(SELECT challenge.user_id, challenge.id, challenge.project_id, challenge.title, blob.stmt, challenge.type, challenge.status, challenge.likes, challenge.dislikes, challenge.creation_time, challenge.last_update_time,\r\n\t\t\t\t\t\tuser.first_name, user.last_name, user.username \r\n\t\t\t\t\tFROM challenges as challenge JOIN user_info as user JOIN blobs as `blob` JOIN projects as project\r\n\t\t\t\t\t\tWHERE challenge.project_id = ? AND challenge.status != 3 \r\n\t\t\t\t\t\t\tAND challenge.status != 7 AND user.id = challenge.user_id \r\n\t\t\t\t\t\t\tAND challenge.blob_id = blob.id AND challenge.project_id = project.id)\r\n\t\t\t\tORDER BY last_update_time DESC ";
if (isset($start) && isset($limit)) {
$sql .= " LIMIT {$start},{$limit} ;";
} else {
$sql .= ";";
}
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($projectId);
$sqlQuery->setNumber($projectId);
$projectActivitities = $this->getListChallenge($sqlQuery);
$DAOFactory = new DAOFactory();
$challengeResponsesDAO = $DAOFactory->getChallengeResponsesDAO();
foreach ($projectActivitities as $activity) {
if ($activity) {
$activity->setResponses($challengeResponsesDAO->getResponses($activity->getId()));
}
}
return $projectActivitities;
}
public function __construct()
{
$DAOFactory = new DAOFactory();
$this->collapDAO = $DAOFactory->getChallengeResponsesDAO();
}