public function action_index() { $session = Session::instance(); //print_r(Company::checkIfApproved($session->get('userId'))); //print_r($session); $projects = array(); $projects = MyDB::getCompletedProjects(); if ($session->get('userType') == 'student') { $projects = User::getActiveProjects($session->get('userId')); } if ($session->get('userType') == 'company') { $projects = Company::getActiveProjects($session->get('userId')); } $this->response->body(View::factory('header') . View::factory('welcome')->set('projects', $projects)->set('userType', $session->get('userType'))); }
/** * Return milestones scheduled for today from projects related with specific company * * @param Company $company * @return array */ function getTodayMilestonesByCompany(Company $company) { $from_date = DateTimeValueLib::now()->beginningOfDay(); $to_date = DateTimeValueLib::now()->endOfDay(); $projects = $company->getActiveProjects(); if (!is_array($projects) || !count($projects)) { return null; } $project_ids = array(); foreach ($projects as $project) { $project_ids[] = $project->getId(); } // foreach return self::findAll(array('conditions' => array('`completed_on` = ? AND (`due_date` >= ? AND `due_date` < ?) AND `project_id` IN (?)', EMPTY_DATETIME, $from_date, $to_date, $project_ids), 'order' => '`due_date`')); // findAll }
/** * Return milestones scheduled for today from projects related with specific company * * @param Company $company * @return array */ function getTodayMilestonesByCompany(Company $company, $archived = false) { $from_date = DateTimeValueLib::now()->beginningOfDay(); $to_date = DateTimeValueLib::now()->endOfDay(); $projects = $company->getActiveProjects(); if (!is_array($projects) || !count($projects)) { return null; } $project_ids = array(); foreach ($projects as $project) { $project_ids[] = $project->getId(); } // foreach if ($archived) { $archived_cond = "`archived_by_id` <> 0 AND "; } else { $archived_cond = "`archived_by_id` = 0 AND "; } return self::findAll(array('conditions' => array('`is_template` = false AND `completed_on` = ? AND (`due_date` >= ? AND `due_date` < ?) AND ' . $archived_cond . self::getWorkspaceString($project_ids), EMPTY_DATETIME, $from_date, $to_date), 'order' => '`due_date`')); // findAll }
echo "<div class='panel-footer' >" . $comment['Comment'] . " " . $comment['Date_Created'] . "</div>"; } ?> </div> </div> <?php } ?> </div> <?php } if ($_SESSION['userType'] == 'company') { require_once "classes/companyClass.php"; $companyObj = new Company(); $projects = $companyObj->getActiveProjects($_SESSION['companyID']); ?> <div class="container"> <?php foreach ($projects as $project) { ?> <div> <div class="container text-left"><h3><?php echo $project['ProjectName']; ?> </h3></div> <div class="container text-left"><p><?php echo $project['Discription']; ?> </p></div>