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>
