/**
* Return the total hours by status and user
*
* @param User $user
* @param Int $status
* @param String $return one of 'times', 'hours'
* @return array
*/
static function getTimeByUserStatus(User $user, $status = 0, $return = 'times')
{
$projects = $user->getActiveProjects();
if (!is_array($projects) || !count($projects)) {
return 0;
}
// if
$project_ids = array();
foreach ($projects as $project) {
$project_ids[] = $project->getId();
}
// foreach
$order_by = $status ? '`done_date` DESC' : '`done_date` ASC';
$times = self::findAll(array('conditions' => array('(`assigned_to_user_id` = ? OR (`assigned_to_user_id` = ? AND `assigned_to_company_id` = ?)) AND `is_closed` = ? AND `project_id` IN (?)', $user->getId(), 0, 0, $status, $project_ids), 'order' => $order_by));
// findAll
if ($return == 'times') {
return $times;
}
// if
$hours = 0;
if (!is_array($times) && !count($times)) {
return 0;
}
// if
foreach ($times as $time) {
$hours += $time->getHours();
}
// foreach
return $hours;
}
/**
* Return open tickets due in specified period
*
* @access public
* @param User $user
* @param DateTimeValue $from_date
* @param DateTimeValue $to_date
* @return array
*/
function getOpenTicketsInPeriodByUser(User $user, DateTimeValue $from_date, DateTimeValue $to_date)
{
$projects = $user->getActiveProjects();
if (!is_array($projects) || !count($projects)) {
return null;
}
$project_ids = array();
foreach ($projects as $project) {
$project_ids[] = $project->getId();
}
// foreach
// TODO status values hard-coded in query
return self::findAll(array('conditions' => array('`state` IN (?) AND `project_id` IN (?)', array('new', 'open', 'pending'), $project_ids), 'order' => '`state` ASC'));
// findAll
}
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 late tickets from active projects given user has access on.
*
* @param User $user
* @return array or null
*/
function getOpenTicketsByUser(User $user)
{
$due_date = DateTimeValueLib::now()->beginningOfDay();
$projects = $user->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('`closed_on` = ? AND `project_id` IN (?)', EMPTY_DATETIME, $project_ids), 'order' => '`priority`'));
// findAll
}
/**
* Return all milestones that are assigned to the user
*
* @param User $user
* @return array
*/
static function getActiveMilestonesByUser(User $user, $archived = false)
{
$projects = $user->getActiveProjects();
if (!is_array($projects) || !count($projects)) {
return null;
}
// if
$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 (`assigned_to_user_id` = ? OR (`assigned_to_user_id` = ? AND `assigned_to_company_id` = ?)) AND ' . $archived_cond . self::getWorkspaceString($project_ids) . ' AND `completed_on` = ?', $user->getId(), 0, 0, EMPTY_DATETIME), 'order' => '`due_date`'));
// findAll
}
<?php
require_once "header.php";
?>
<?php
if (isset($_SESSION['userType'])) {
if ($_SESSION[userType] == 'student') {
require_once "classes/userClass.php";
$studentObj = new User();
$projects = $studentObj->getActiveProjects($_SESSION['userID']);
//print_r($projects);
?>
<div id="main">
<?php
foreach ($projects as $project) {
?>
<div class="panel panel-success">
<div class="panel-heading"><?php
echo $project['ProjectName'];
?>
</div>
<div class="panel-body"><?php
echo $project['Discription'];
?>
</div>
<div>
<?php
foreach ($project['SignedUp'] as $colegue) {
?>
<div class="panel-footer"> <?php
/**
* Return active milestones due in specified period
*
* @access public
* @param User $user
* @param DateTimeValue $from_date
* @param DateTimeValue $to_date
* @return array
*/
function getActiveMilestonesInPeriodByUser(User $user, DateTimeValue $from_date, DateTimeValue $to_date)
{
$projects = $user->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` ASC'));
// findAll
}
/**
* Return today milestones from active projects this user have access on
*
* @access public
* @param void
* @return array
*/
function getTodayMilestonesByUser(User $user)
{
$from_date = DateTimeValueLib::now()->beginningOfDay();
$to_date = DateTimeValueLib::now()->endOfDay();
$projects = $user->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)));
// findAll
}
