static function getArrayInfo($raw_data, $full = false){
if(config_option("wysiwyg_tasks")){
if($raw_data['type_content'] == "text"){
$desc = nl2br(htmlspecialchars($raw_data['text']));
}else{
$desc = purify_html(nl2br($raw_data['text']));
}
}else{
if($raw_data['type_content'] == "text"){
$desc = htmlspecialchars($raw_data['text']);
}else{
$desc = html_to_text(html_entity_decode(nl2br($raw_data['text']), null, "UTF-8"));
}
}
$member_ids = ObjectMembers::instance()->getCachedObjectMembers($raw_data['id']);
$tmp_task = new ProjectTask();
$tmp_task->setObjectId($raw_data['id']);
$tmp_task->setId($raw_data['id']);
$tmp_task->setAssignedToContactId($raw_data['assigned_to_contact_id']);
$result = array(
'id' => $raw_data['id'],
't' => $raw_data['name'],
'desc' => $desc,
'members' => $member_ids,
'c' => strtotime($raw_data['created_on']),
'cid' => (int)$raw_data['created_by_id'],
'otype' => $raw_data['object_subtype'],
'pc' => (int)$raw_data['percent_completed'],
'memPath' => str_replace('"',"'", str_replace("'", "\'", json_encode($tmp_task->getMembersToDisplayPath($member_ids))))
);
if ($full) {
$result['description'] = $raw_data['text'];
}
$result['mas'] = (int)array_var($raw_data, 'multi_assignment');
if ($raw_data['completed_by_id'] > 0) {
$result['s'] = 1;
}
if ($raw_data['parent_id'] > 0) {
$result['pid'] = (int)$raw_data['parent_id'];
}
//if ($this->getPriority() != 200)
$result['pr'] = (int)$raw_data['priority'];
if ($raw_data['milestone_id'] > 0) {
$result['mid'] = (int)$raw_data['milestone_id'];
}
if ($raw_data['assigned_to_contact_id'] > 0) {
$result['atid'] = (int)$raw_data['assigned_to_contact_id'];
}
$result['atName'] = $tmp_task->getAssignedToName();
if ($raw_data['completed_by_id'] > 0) {
$result['cbid'] = (int)$raw_data['completed_by_id'];
$result['con'] = strtotime($raw_data['completed_on']);;
}
if ($raw_data['due_date'] != EMPTY_DATETIME) {
$result['dd'] = strtotime($raw_data['due_date']) + logged_user()->getTimezone() * 3600;
$result['udt'] = $raw_data['use_due_time'] ? 1 : 0;
}
if ($raw_data['start_date'] != EMPTY_DATETIME) {
$result['sd'] = strtotime($raw_data['start_date']) + logged_user()->getTimezone() * 3600;
$result['ust'] = $raw_data['use_start_time'] ? 1 : 0;
}
$time_estimate = $raw_data['time_estimate'];
$result['te'] = $raw_data['time_estimate'];
if ($time_estimate > 0) $result['et'] = DateTimeValue::FormatTimeDiff(new DateTimeValue(0), new DateTimeValue($time_estimate * 60), 'hm', 60) ;
$result['tz'] = logged_user()->getTimezone() * 3600;
$ot = $tmp_task->getOpenTimeslots();
if ($ot){
$users = array();
$time = array();
$paused = array();
foreach ($ot as $t){
if (!$t instanceof Timeslot) continue;
$time[] = $t->getSeconds();
$users[] = $t->getContactId();
$paused[] = $t->isPaused()?1:0;
if ($t->isPaused() && $t->getContactId() == logged_user()->getId()) {
$result['wpt'] = $t->getPausedOn()->getTimestamp();
}
}
$result['wt'] = $time;
$result['wid'] = $users;
$result['wp'] = $paused;
}
if ($raw_data['repeat_forever'] > 0 || $raw_data['repeat_num'] > 0 || $raw_data['repeat_end'] != EMPTY_DATETIME) {
$result['rep'] = 1;
}
return $result;
}
/**
* Return manager instance
*
* @access protected
* @param void
* @return ObjectMembers
*/
function manager() {
if(!($this->manager instanceof ObjectMembers)) $this->manager = ObjectMembers::instance();
return $this->manager;
} // manager
function new_list_tasks()
{
//load config options into cache for better performance
load_user_config_options_by_category_name('task panel');
$isJson = array_var($_GET, 'isJson', false);
if ($isJson) {
ajx_current("empty");
}
$request_conditions = $this->get_tasks_request_conditions();
$conditions = $request_conditions['conditions'];
$filter_value = $request_conditions['filterValue'];
$filter = $request_conditions['filter'];
$status = $request_conditions['status'];
$tasks = array();
$pendingstr = $status == 0 ? " AND `e`.`completed_on` = " . DB::escape(EMPTY_DATETIME) . " " : "";
$milestone_conditions = " AND `is_template` = false " . $pendingstr;
//Find all internal milestones for these tasks
$internalMilestones = ProjectMilestones::instance()->listing(array("extra_conditions" => $milestone_conditions))->objects;
//Find all external milestones for these tasks, external milestones are the ones that belong to a parent member and have tasks in the current member
$milestone_ids = array();
$task_ids = array();
if ($tasks) {
foreach ($tasks as $task) {
$task_ids[] = $task['id'];
if ($task['milestone_id'] != 0) {
$milestone_ids[$task['milestone_id']] = $task['milestone_id'];
}
}
// generate request cache
ObjectMembers::instance()->getCachedObjectMembers(0, $task_ids);
ProjectTasks::instance()->findByRelatedCached(0, $task_ids);
}
$cp_values = array();
if (count($task_ids) > 0) {
$cp_rows = DB::executeAll("SELECT * FROM " . TABLE_PREFIX . "custom_property_values WHERE object_id IN (" . implode(',', $task_ids) . ")");
if (is_array($cp_rows)) {
foreach ($cp_rows as $row) {
if (!isset($cp_values[$row['object_id']])) {
$cp_values[$row['object_id']] = array();
}
if (!isset($cp_values[$row['object_id']][$row['custom_property_id']])) {
$cp_values[$row['object_id']][$row['custom_property_id']] = array();
}
$cp_values[$row['object_id']][$row['custom_property_id']][] = $row['value'];
}
}
}
tpl_assign('cp_values', $cp_values);
$int_milestone_ids = array();
foreach ($internalMilestones as $milestone) {
$int_milestone_ids[] = $milestone->getId();
}
$milestone_ids = array_diff($milestone_ids, $int_milestone_ids);
if (count($milestone_ids) == 0) {
$milestone_ids[] = 0;
}
$ext_milestone_conditions = " `is_template` = false " . $pendingstr . ' AND `object_id` IN (' . implode(',', $milestone_ids) . ')';
$externalMilestones = ProjectMilestones::findAll(array('conditions' => $ext_milestone_conditions));
// Get Users Info
if (logged_user()->isGuest()) {
$users = array(logged_user());
} else {
$users = allowed_users_in_context(ProjectTasks::instance()->getObjectTypeId(), active_context(), ACCESS_LEVEL_READ, '', true);
}
$allUsers = Contacts::getAllUsers(null, true);
$user_ids = array(-1);
foreach ($allUsers as $user) {
$user_ids[] = $user->getId();
}
// only companies with users
$companies = Contacts::findAll(array("conditions" => "e.is_company = 1", "join" => array("table" => Contacts::instance()->getTableName(), "jt_field" => "object_id", "j_sub_q" => "SELECT xx.object_id FROM " . Contacts::instance()->getTableName(true) . " xx WHERE \r\n\t\t\t\t\txx.is_company=0 AND xx.company_id = e.object_id AND xx.object_id IN (" . implode(",", $user_ids) . ") LIMIT 1")));
tpl_assign('tasks', $tasks);
if (!$isJson) {
$all_templates = COTemplates::findAll(array('conditions' => '`trashed_by_id` = 0 AND `archived_by_id` = 0'));
tpl_assign('all_templates', $all_templates);
if (user_config_option('task_display_limit') > 0 && count($tasks) > user_config_option('task_display_limit')) {
tpl_assign('displayTooManyTasks', true);
array_pop($tasks);
}
tpl_assign('object_subtypes', array());
tpl_assign('internalMilestones', $internalMilestones);
tpl_assign('externalMilestones', $externalMilestones);
tpl_assign('users', $users);
tpl_assign('allUsers', $allUsers);
tpl_assign('companies', $companies);
if (strtotime(user_config_option('tasksDateStart'))) {
//this return null if date is 0000-00-00 00:00:00
$dateStart = new DateTime('@' . strtotime(user_config_option('tasksDateStart')));
$dateStart = $dateStart->format(user_config_option('date_format'));
} else {
$dateStart = '';
}
if (strtotime(user_config_option('tasksDateEnd'))) {
//this return null if date is 0000-00-00 00:00:00
$dateEnd = new DateTime('@' . strtotime(user_config_option('tasksDateEnd')));
$dateEnd = $dateEnd->format(user_config_option('date_format'));
} else {
$dateEnd = '';
}
$userPref = array();
$showDimensionCols = array_map('intval', explode(',', user_config_option('tasksShowDimensionCols')));
$userPref = array('filterValue' => isset($filter_value) ? $filter_value : '', 'filter' => $filter, 'dateStart' => $dateStart, 'dateEnd' => $dateEnd, 'status' => $status, 'showTime' => user_config_option('tasksShowTime'), 'showDates' => user_config_option('tasksShowDates'), 'showStartDates' => user_config_option('tasksShowStartDates'), 'showEndDates' => user_config_option('tasksShowEndDates'), 'showBy' => user_config_option('tasksShowAssignedBy'), 'showClassification' => user_config_option('tasksShowClassification'), 'showSubtasksStructure' => user_config_option('tasksShowSubtasksStructure'), 'showTags' => user_config_option('tasksShowTags', 0), 'showEmptyMilestones' => user_config_option('tasksShowEmptyMilestones', 1), 'showTimeEstimates' => user_config_option('tasksShowTimeEstimates', 1), 'showTimePending' => user_config_option('tasksShowTimePending', 1), 'showTimeWorked' => user_config_option('tasksShowTimeWorked', 1), 'showPercentCompletedBar' => user_config_option('tasksShowPercentCompletedBar', 1), 'showQuickEdit' => user_config_option('tasksShowQuickEdit', 1), 'showQuickComplete' => user_config_option('tasksShowQuickComplete', 1), 'showQuickComment' => user_config_option('tasksShowQuickComment', 1), 'showQuickAddSubTasks' => user_config_option('tasksShowQuickAddSubTasks', 1), 'showDimensionCols' => $showDimensionCols, 'groupBy' => user_config_option('tasksGroupBy'), 'orderBy' => user_config_option('tasksOrderBy'), 'previousPendingTasks' => user_config_option('tasksPreviousPendingTasks', 1), 'defaultNotifyValue' => user_config_option('can notify from quick add'));
hook::fire('tasks_user_preferences', null, $userPref);
tpl_assign('userPreferences', $userPref);
tpl_assign('userPermissions', array('can_add' => ProjectTask::canAdd(logged_user(), active_context()) ? 1 : 0));
ajx_set_no_toolbar(true);
}
}
/**
* Return manager instance
*
* @access protected
* @param void
* @return ObjectMembers
*/
function manager()
{
if (!$this->manager instanceof ObjectMembers) {
$this->manager = ObjectMembers::instance();
}
return $this->manager;
}
function canBeDeleted(&$error_message)
{
$childs = $this->getAllChildren();
if (MemberPropertyMembers::isMemberAssociated($this->getId())) {
$error_message = lang("cannot delete member is associated");
return false;
}
$continue_check = false;
if (count($childs) == 0) {
$continue_check = true;
} else {
if ($this->getParentMemberId() > 0) {
$child_ots = DimensionObjectTypeHierarchies::getAllChildrenObjectTypeIds($this->getDimensionId(), $this->getParentMember()->getObjectTypeId(), false);
}
foreach ($childs as $child) {
// check if child can be put in the parent (or root)
if ($this->getParentMemberId() == 0) {
$dim_ot = DimensionObjectTypes::findOne(array("conditions" => array("`dimension_id` = ? AND `object_type_id` = ?", $this->getDimensionId(), $child->getObjectTypeId())));
if (!$dim_ot->getIsRoot()) {
$error_message = lang("cannot delete member cannot be root");
return false;
}
} else {
if (!in_array($child->getObjectTypeId(), $child_ots)) {
$error_message = lang("cannot delete member childs cannot be moved to parent");
return false;
}
}
}
$continue_check = true;
}
if (!$continue_check) {
return false;
} else {
$child_ids = $this->getAllChildrenIds();
$child_ids[] = $this->getId();
$child_ids_str = implode(",", $child_ids);
$objects_in_member = ObjectMembers::instance()->findAll(array('conditions' => 'member_id = ' . $this->getId()));
if (!$objects_in_member || count($objects_in_member) == 0) {
return true;
} else {
$more_conditions = "";
if (Plugins::instance()->isActivePlugin('core_dimensions')) {
$person_dim = Dimensions::findByCode('feng_persons')->getId();
$more_conditions = " AND member_id NOT IN (SELECT id FROM " . TABLE_PREFIX . "members WHERE dimension_id={$person_dim})";
}
$object_id_condition = $this->getObjectId() > 0 ? " AND o.id <> " . $this->getObjectId() : "";
foreach ($objects_in_member as $om) {
$obj_members = ObjectMembers::findAll(array("conditions" => array("`object_id` = ? AND `is_optimization` = 0 AND member_id IN ({$child_ids_str}) AND EXISTS (SELECT o.id FROM " . TABLE_PREFIX . "objects o WHERE o.id = ? AND o.trashed_by_id=0 {$object_id_condition})" . $more_conditions, $om->getObjectId(), $om->getObjectId())));
if (count($obj_members) >= 1) {
$error_message = lang("cannot delete member has objects");
return false;
}
$db_res = DB::execute("SELECT object_type_id FROM " . TABLE_PREFIX . "objects WHERE id=" . $om->getObjectId());
$row = $db_res->fetchRow();
if ($row && array_var($row, 'object_type_id')) {
$req_dim_ids = DimensionObjectTypeContents::getRequiredDimensions(array_var($row, 'object_type_id'));
if (in_array($this->getDimensionId(), $req_dim_ids)) {
$error_message = lang("cannot delete member is required for objects");
return false;
}
}
}
}
}
return true;
}
/**
* End task templates
*/
function getArrayInfo($full = false)
{
if (config_option("wysiwyg_tasks")) {
if ($this->getTypeContent() == "text") {
$desc = nl2br(htmlspecialchars($this->getText()));
} else {
$desc = purify_html(nl2br($this->getText()));
}
} else {
if ($this->getTypeContent() == "text") {
$desc = htmlspecialchars($this->getText());
} else {
$desc = html_to_text(html_entity_decode(nl2br($this->getText()), null, "UTF-8"));
}
}
$member_ids = ObjectMembers::instance()->getCachedObjectMembers($this->getId());
$result = array('id' => $this->getId(), 't' => $this->getObjectName(), 'desc' => $desc, 'members' => $member_ids, 'c' => $this->getCreatedOn() instanceof DateTimeValue ? $this->getCreatedOn()->getTimestamp() : 0, 'cid' => $this->getCreatedById(), 'otype' => $this->getObjectSubtype(), 'pc' => $this->getPercentCompleted(), 'memPath' => str_replace('"', "'", escape_character(json_encode($this->getMembersIdsToDisplayPath()))));
if ($full) {
$result['description'] = $this->getText();
}
$result['mas'] = $this->getColumnValue('multi_assignment', 0);
if ($this->isCompleted()) {
$result['s'] = 1;
}
if ($this->getParentId() > 0) {
$result['pid'] = $this->getParentId();
}
//if ($this->getPriority() != 200)
$result['pr'] = $this->getPriority();
if ($this->getMilestoneId() > 0) {
$result['mid'] = $this->getMilestoneId();
}
if ($this->getAssignedToContactId() > 0) {
$result['atid'] = $this->getAssignedToContactId();
}
$result['atName'] = $this->getAssignedToName();
if ($this->getCompletedById() > 0) {
$result['cbid'] = $this->getCompletedById();
$result['con'] = $this->getCompletedOn()->getTimestamp();
}
if ($this->getDueDate() instanceof DateTimeValue) {
$result['dd'] = $this->getDueDate()->getTimestamp() + logged_user()->getTimezone() * 3600;
$result['udt'] = $this->getUseDueTime() ? 1 : 0;
}
if ($this->getStartDate() instanceof DateTimeValue) {
$result['sd'] = $this->getStartDate()->getTimestamp() + logged_user()->getTimezone() * 3600;
$result['ust'] = $this->getUseStartTime() ? 1 : 0;
}
$time_estimate = $this->getTimeEstimate();
$result['te'] = $this->getTimeEstimate();
if ($time_estimate > 0) {
$result['et'] = DateTimeValue::FormatTimeDiff(new DateTimeValue(0), new DateTimeValue($time_estimate * 60), 'hm', 60);
}
$result['tz'] = logged_user()->getTimezone() * 3600;
$ot = $this->getOpenTimeslots();
if ($ot) {
$users = array();
$time = array();
$paused = array();
foreach ($ot as $t) {
if (!$t instanceof Timeslot) {
continue;
}
$time[] = $t->getSeconds();
$users[] = $t->getContactId();
$paused[] = $t->isPaused() ? 1 : 0;
if ($t->isPaused() && $t->getContactId() == logged_user()->getId()) {
$result['wpt'] = $t->getPausedOn()->getTimestamp();
}
}
$result['wt'] = $time;
$result['wid'] = $users;
$result['wp'] = $paused;
}
if ($this->isRepetitive()) {
$result['rep'] = 1;
}
return $result;
}
static function getArrayInfo($raw_data, $full = false)
{
$desc = "";
if ($full) {
if (config_option("wysiwyg_tasks")) {
if ($raw_data['type_content'] == "text") {
$desc = nl2br(htmlspecialchars($raw_data['text']));
} else {
$desc = purify_html(nl2br($raw_data['text']));
}
} else {
if ($raw_data['type_content'] == "text") {
$desc = htmlspecialchars($raw_data['text']);
} else {
$desc = html_to_text(html_entity_decode(nl2br($raw_data['text']), null, "UTF-8"));
}
}
}
$member_ids = ObjectMembers::instance()->getCachedObjectMembers($raw_data['id']);
$tmp_task = new ProjectTask();
$tmp_task->setObjectId($raw_data['id']);
$tmp_task->setId($raw_data['id']);
$tmp_task->setAssignedToContactId($raw_data['assigned_to_contact_id']);
$result = array('id' => (int) $raw_data['id'], 'name' => $raw_data['name'], 'description' => $desc, 'members' => $member_ids, 'createdOn' => strtotime($raw_data['created_on']), 'createdById' => (int) $raw_data['created_by_id'], 'otype' => $raw_data['object_subtype'], 'percentCompleted' => (int) $raw_data['percent_completed'], 'memPath' => str_replace('"', "'", escape_character(json_encode($tmp_task->getMembersIdsToDisplayPath()))));
if (isset($raw_data['isread'])) {
$result['isread'] = $raw_data['isread'];
}
$result['multiAssignment'] = (int) array_var($raw_data, 'multi_assignment');
if ($raw_data['completed_by_id'] > 0) {
$result['status'] = 1;
}
if ($raw_data['parent_id'] > 0) {
$result['parentId'] = (int) $raw_data['parent_id'];
}
$result['subtasksIds'] = $tmp_task->getSubTasksIds();
//if ($this->getPriority() != 200)
$result['priority'] = (int) $raw_data['priority'];
if ($raw_data['milestone_id'] > 0) {
$result['milestoneId'] = (int) $raw_data['milestone_id'];
}
if ($raw_data['assigned_by_id'] > 0) {
$result['assignedById'] = (int) $raw_data['assigned_by_id'];
}
if ($raw_data['assigned_to_contact_id'] > 0) {
$result['assignedToContactId'] = (int) $raw_data['assigned_to_contact_id'];
}
$result['atName'] = $tmp_task->getAssignedToName();
if ($raw_data['completed_by_id'] > 0) {
$result['completedById'] = (int) $raw_data['completed_by_id'];
$result['completedOn'] = strtotime($raw_data['completed_on']);
}
if ($raw_data['due_date'] != EMPTY_DATETIME) {
$result['useDueTime'] = $raw_data['use_due_time'] ? 1 : 0;
if ($result['useDueTime']) {
$result['dueDate'] = strtotime($raw_data['due_date']) + logged_user()->getTimezone() * 3600;
} else {
$result['dueDate'] = strtotime($raw_data['due_date']);
}
}
if ($raw_data['start_date'] != EMPTY_DATETIME) {
$result['useStartTime'] = $raw_data['use_start_time'] ? 1 : 0;
if ($result['useStartTime']) {
$result['startDate'] = strtotime($raw_data['start_date']) + logged_user()->getTimezone() * 3600;
} else {
$result['startDate'] = strtotime($raw_data['start_date']);
}
}
$time_estimate = $raw_data['time_estimate'];
$result['timeEstimate'] = $raw_data['time_estimate'];
if ($time_estimate > 0) {
$result['timeEstimateString'] = str_replace(',', ',<br>', DateTimeValue::FormatTimeDiff(new DateTimeValue(0), new DateTimeValue($time_estimate * 60), 'hm', 60));
}
$result['timeZone'] = logged_user()->getTimezone() * 3600;
$ot = $tmp_task->getOpenTimeslots();
if ($ot) {
$users = array();
$time = array();
$paused = array();
foreach ($ot as $t) {
if (!$t instanceof Timeslot) {
continue;
}
$time[] = $t->getSeconds();
$users[] = $t->getContactId();
$paused[] = $t->isPaused() ? 1 : 0;
if ($t->isPaused() && $t->getContactId() == logged_user()->getId()) {
$result['pauseTime'] = $t->getPausedOn()->getTimestamp();
}
}
$result['workingOnTimes'] = $time;
$result['workingOnIds'] = $users;
$result['workingOnPauses'] = $paused;
}
$total_minutes = $tmp_task->getTotalMinutes();
if ($total_minutes > 0) {
$result['worked_time'] = $total_minutes;
$result['worked_time_string'] = str_replace(',', ',<br>', DateTimeValue::FormatTimeDiff(new DateTimeValue(0), new DateTimeValue($total_minutes * 60), 'hm', 60));
} else {
$result['worked_time'] = 0;
}
$pending_time = $time_estimate - $total_minutes;
if ($pending_time > 0) {
$result['pending_time'] = $pending_time;
$result['pending_time_string'] = str_replace(',', ',<br>', DateTimeValue::FormatTimeDiff(new DateTimeValue(0), new DateTimeValue($pending_time * 60), 'hm', 60));
} else {
$result['pending_time'] = 0;
}
if ($raw_data['repeat_forever'] > 0 || $raw_data['repeat_num'] > 0 || $raw_data['repeat_end'] != EMPTY_DATETIME && $raw_data['repeat_end'] != '') {
$result['repetitive'] = 1;
}
$tmp_members = array();
if (count($member_ids) > 0) {
$tmp_members = Members::findAll(array("conditions" => "id IN (" . implode(',', $member_ids) . ")"));
}
$result['can_add_timeslots'] = can_add_timeslots(logged_user(), $tmp_members);
//tasks dependencies
if (config_option('use tasks dependencies')) {
//get all dependant tasks ids, not completed yet
$pending_tasks_ids = ProjectTaskDependencies::getDependenciesForTaskOnlyPendingIds($tmp_task->getId());
//get the total of previous tasks
$result['dependants'] = $pending_tasks_ids;
$result['previous_tasks_total'] = ProjectTaskDependencies::countPendingPreviousTasks($tmp_task->getId());
}
return $result;
}
/**
* This function will return paginated result. Result is an array where first element is
* array of returned object and second populated pagination object that can be used for
* obtaining and rendering pagination data using various helpers.
*
* Items and pagination array vars are indexed with 0 for items and 1 for pagination
* because you can't use associative indexing with list() construct
*
* @access public
* @param array $arguments Query argumens (@see find()) Limit and offset are ignored!
* @param integer $items_per_page Number of items per page
* @param integer $current_page Current page number
* @return array
*/
function paginate($arguments = null, $items_per_page = 10, $current_page = 1)
{
if (isset($this) && instance_of($this, 'ObjectMembers')) {
return parent::paginate($arguments, $items_per_page, $current_page);
} else {
return ObjectMembers::instance()->paginate($arguments, $items_per_page, $current_page);
}
// if
}
function new_list_tasks(){
//load config options into cache for better performance
load_user_config_options_by_category_name('task panel');
// get query parameters, save user preferences if necessary
$status = array_var($_GET,'status',null);
if (is_null($status) || $status == '') {
$status = user_config_option('task panel status',2);
} else
if (user_config_option('task panel status') != $status) {
set_user_config_option('task panel status', $status, logged_user()->getId());
}
$previous_filter = user_config_option('task panel filter', 'no_filter');
$filter = array_var($_GET, 'filter');
if (is_null($filter) || $filter == '') {
$filter = $previous_filter;
} else if ($previous_filter != $filter) {
set_user_config_option('task panel filter', $filter, logged_user()->getId());
}
if ($filter != 'no_filter'){
$filter_value = array_var($_GET,'fval');
if (is_null($filter_value) || $filter_value == '') {
$filter_value = user_config_option('task panel filter value', null, logged_user()->getId());
set_user_config_option('task panel filter value', $filter_value, logged_user()->getId());
$filter = $previous_filter;
set_user_config_option('task panel filter', $filter, logged_user()->getId());
} else
if (user_config_option('task panel filter value') != $filter_value) {
set_user_config_option('task panel filter value', $filter_value, logged_user()->getId());
}
}
$isJson = array_var($_GET,'isJson',false);
if ($isJson) ajx_current("empty");
$template_condition = "`is_template` = 0 ";
//Get the task query conditions
$task_filter_condition = "";
switch($filter){
case 'assigned_to':
$assigned_to = $filter_value;
if ($assigned_to > 0) {
$task_filter_condition = " AND (`assigned_to_contact_id` = " . $assigned_to . ") ";
} else {
if ($assigned_to == -1)
$task_filter_condition = " AND `assigned_to_contact_id` = 0";
}
break;
case 'assigned_by':
if ($filter_value != 0) {
$task_filter_condition = " AND `assigned_by_id` = " . $filter_value . " ";
}
break;
case 'created_by':
if ($filter_value != 0) {
$task_filter_condition = " AND `created_by_id` = " . $filter_value . " ";
}
break;
case 'completed_by':
if ($filter_value != 0) {
$task_filter_condition = " AND `completed_by_id` = " . $filter_value . " ";
}
break;
case 'milestone':
$task_filter_condition = " AND `milestone_id` = " . $filter_value . " ";
break;
case 'priority':
$task_filter_condition = " AND `priority` = " . $filter_value . " ";
break;
case 'subtype':
if ($filter_value != 0) {
$task_filter_condition = " AND `object_subtype` = " . $filter_value . " ";
}
break;
case 'subscribed_to':
if ($filter_value > 0) {
$res20 = DB::execute("SELECT object_id FROM ". TABLE_PREFIX . "object_subscriptions WHERE `contact_id` = " . $filter_value);
$subs_rows = $res20->fetchAll($res20);
$subs = array();
if(count($subs_rows) > 0){
foreach($subs_rows as $row) $subs[] = $row['object_id'];
unset($res20, $subs_rows, $row);
if(count($subs) > 0){
$task_filter_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `id` IN(" . implode(',', $subs) . ")";
}
}else{
$task_filter_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `id` = -1";
}
}
break;
case 'no_filter':
$task_filter_condition = "";
break;
default:
flash_error(lang('task filter criteria not recognised', $filter));
}
$task_status_condition = "";
$now_date = DateTimeValueLib::now();
$now_date->advance(logged_user()->getTimezone() * 3600);
$now = $now_date->format('Y-m-d 00:00:00');
$now_end = $now_date->format('Y-m-d 23:59:59');
switch($status){
case 0: // Incomplete tasks
$task_status_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME);
break;
case 1: // Complete tasks
$task_status_condition = " AND `completed_on` > " . DB::escape(EMPTY_DATETIME);
break;
case 10: // Active tasks
$task_status_condition = " AND (SELECT COUNT(ts.object_id) FROM ".TABLE_PREFIX."timeslots ts WHERE ts.rel_object_id=o.id AND ts.end_time = '".EMPTY_DATETIME."') > 0";
break;
case 11: // Overdue tasks
$task_status_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `due_date` < '$now'";
break;
case 12: // Today tasks
$task_status_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `due_date` >= '$now' AND `due_date` <= '$now_end'";
break;
case 13: // Today + Overdue tasks
$task_status_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `due_date` <= '$now_end'";
break;
case 20: // Actives task by current user
$task_status_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `start_date` <= '$now' AND `assigned_to_contact_id` = " . logged_user()->getId();
break;
case 21: // Subscribed tasks by current user
$res20 = DB::execute("SELECT object_id FROM ". TABLE_PREFIX . "object_subscriptions WHERE `contact_id` = " . logged_user()->getId());
$subs_rows = $res20->fetchAll($res20);
foreach($subs_rows as $row) $subs[] = $row['object_id'];
unset($res20, $subs_rows, $row);
$task_status_condition = " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " AND `id` IN(" . implode(',', $subs) . ")";
break;
case 2: // All tasks
break;
default:
throw new Exception('Task status "' . $status . '" not recognised');
}
$task_assignment_conditions = "";
if (!SystemPermissions::userHasSystemPermission(logged_user(), 'can_see_assigned_to_other_tasks')) {
$task_assignment_conditions = " AND assigned_to_contact_id = ".logged_user()->getId();
}
$conditions = "AND $template_condition $task_filter_condition $task_status_condition $task_assignment_conditions";
//Now get the tasks
$tasks = ProjectTasks::instance()->listing(array(
"extra_conditions" => $conditions,
"start" => 0,
"limit" => user_config_option('task_display_limit', 501),
"count_results" => false,
"raw_data" => true,
))->objects;
$pendingstr = $status == 0 ? " AND `completed_on` = " . DB::escape(EMPTY_DATETIME) . " " : "";
$milestone_conditions = " AND `is_template` = false " . $pendingstr;
//Find all internal milestones for these tasks
$internalMilestones = ProjectMilestones::instance()->listing(array("extra_conditions" => $milestone_conditions))->objects;
//Find all external milestones for these tasks, external milestones are the ones that belong to a parent member and have tasks in the current member
$milestone_ids = array();
if($tasks){
$task_ids = array();
foreach ($tasks as $task){
$task_ids[] = $task['id'];
if ($task['milestone_id'] != 0) {
$milestone_ids[$task['milestone_id']] = $task['milestone_id'];
}
}
// generate request cache
ObjectMembers::instance()->getCachedObjectMembers(0, $task_ids);
ProjectTasks::instance()->findByRelatedCached(0, $task_ids);
}
$int_milestone_ids = array();
foreach($internalMilestones as $milestone) {
$int_milestone_ids[] = $milestone->getId();
}
$milestone_ids = array_diff($milestone_ids, $int_milestone_ids);
if (count($milestone_ids) == 0) $milestone_ids[] = 0;
$ext_milestone_conditions = " `is_template` = false " . $pendingstr . ' AND `object_id` IN (' . implode(',',$milestone_ids) . ')';
$externalMilestones = ProjectMilestones::findAll(array('conditions' => $ext_milestone_conditions));
// Get Users Info
$users = allowed_users_in_context(ProjectTasks::instance()->getObjectTypeId(), active_context(), ACCESS_LEVEL_READ);
$allUsers = Contacts::getAllUsers();
$user_ids = array(-1);
foreach ($allUsers as $user) {
$user_ids[] = $user->getId();
}
// only companies with users
$companies = Contacts::findAll(array(
"conditions" => "e.is_company = 1",
"join" => array(
"table" => Contacts::instance()->getTableName(),
"jt_field" => "object_id",
"j_sub_q" => "SELECT xx.object_id FROM ".Contacts::instance()->getTableName(true)." xx WHERE
xx.is_company=0 AND xx.company_id = e.object_id AND xx.object_id IN (".implode(",", $user_ids).") LIMIT 1"
)
));
tpl_assign('tasks', $tasks);
if (config_option('use tasks dependencies')) {
$dependency_count = array();
foreach ($tasks as $task) {
$previous = 0;
$ptasks = ProjectTaskDependencies::getDependenciesForTask($task['id']);
foreach ($ptasks as $pdep) {
$ptask = ProjectTasks::findById($pdep->getPreviousTaskId());
if ($ptask instanceof ProjectTask && !$ptask->isCompleted()) $previous++;
}
$dependants = ProjectTaskDependencies::getDependantsForTask($task['id']);
$dep_csv = "";
foreach ($dependants as $dep) $dep_csv .= ($dep_csv==""?"":",") . $dep->getTaskId();
$dependency_count[] = array('id' => $task['id'], 'count' => $previous, 'dependants' => $dep_csv);
}
tpl_assign('dependency_count', $dependency_count);
}
if (!$isJson){
$all_templates = COTemplates::findAll(array('conditions' => '`trashed_by_id` = 0 AND `archived_by_id` = 0'));
tpl_assign('all_templates', $all_templates);
if (user_config_option('task_display_limit') > 0 && count($tasks) > user_config_option('task_display_limit')) {
tpl_assign('displayTooManyTasks', true);
array_pop($tasks);
}
tpl_assign('object_subtypes',array());
tpl_assign('internalMilestones', $internalMilestones);
tpl_assign('externalMilestones', $externalMilestones);
tpl_assign('users', $users);
tpl_assign('allUsers', $allUsers);
tpl_assign('companies', $companies);
$userPref = array();
$userPref = array(
'filterValue' => isset($filter_value) ? $filter_value : '',
'filter' => $filter,
'status' => $status,
'showWorkspaces' => user_config_option('tasksShowWorkspaces',1),
'showTime' => user_config_option('tasksShowTime'),
'showDates' => user_config_option('tasksShowDates'),
'showTags' => user_config_option('tasksShowTags',0),
'showEmptyMilestones' => user_config_option('tasksShowEmptyMilestones',1),
'showTimeEstimates' => user_config_option('tasksShowTimeEstimates',1),
'groupBy' => user_config_option('tasksGroupBy'),
'orderBy' => user_config_option('tasksOrderBy'),
'defaultNotifyValue' => user_config_option('can notify from quick add'),
);
hook::fire('tasks_user_preferences', null, $userPref);
tpl_assign('userPreferences', $userPref);
ajx_set_no_toolbar(true);
}
}
function associate_member_to_status_member($project_member, $old_project_status, $status_member_id, $status_dimension, $status_ot = null, $remove_prev_associations = true)
{
if ($status_dimension instanceof Dimension && in_array($status_dimension->getId(), config_option('enabled_dimensions'))) {
// asociate project objects to the new project_status member
if ($old_project_status != $status_member_id) {
$object_members = ObjectMembers::instance()->findAll(array('conditions' => "member_id = " . $project_member->getId() . " AND is_optimization=0"));
// remove objects from old project_type member
if ($old_project_status > 0) {
foreach ($object_members as $om) {
$obj = Objects::findObject($om->getObjectId());
if ($obj instanceof ContentDataObject) {
ObjectMembers::removeObjectFromMembers($obj, logged_user(), null, array($old_project_status));
}
}
}
// add objects to new project_type member
if (is_numeric($status_member_id) && $status_member_id > 0) {
$member_to_add = Members::findById($status_member_id);
foreach ($object_members as $om) {
ObjectMembers::addObjectToMembers($om->getObjectId(), array($member_to_add));
}
if ($member_to_add instanceof Member && $member_to_add->getObjectId() > 0) {
$rel_obj = Objects::findObject($member_to_add->getObjectId());
if ($rel_obj instanceof ContentDataObject) {
ObjectMembers::addObjectToMembers($rel_obj->getId(), array($project_member));
$rel_obj->addToSharingTable();
$null = null;
Hook::fire("after_auto_classifying_associated_object_of_member", array('obj' => $rel_obj, 'mem' => $project_member), $null);
}
}
}
}
$member_dimension = $project_member->getDimension();
$a = DimensionMemberAssociations::instance()->findOne(array('conditions' => array('dimension_id=? AND object_type_id=? AND associated_dimension_id=?' . ($status_ot instanceof ObjectType ? ' AND associated_object_type_id=' . $status_ot->getId() : ''), $member_dimension->getId(), $project_member->getObjectTypeId(), $status_dimension->getId())));
// create relation between members and remove old relations
if ($a instanceof DimensionMemberAssociation) {
if (is_numeric($status_member_id) && $status_member_id > 0) {
$mpm = MemberPropertyMembers::findOne(array('id' => true, 'conditions' => array('association_id = ? AND member_id = ? AND property_member_id = ?', $a->getId(), $project_member->getId(), $status_member_id)));
if (is_null($mpm)) {
$sql = "INSERT INTO " . TABLE_PREFIX . "member_property_members (association_id, member_id, property_member_id, is_active, created_on, created_by_id)\r\n\t\t\t\t\t\tVALUES (" . $a->getId() . "," . $project_member->getId() . "," . $status_member_id . ", 1, NOW()," . logged_user()->getId() . ");";
DB::executeAll($sql);
}
}
if ($remove_prev_associations) {
MemberPropertyMembers::instance()->delete('association_id = ' . $a->getId() . ' AND member_id = ' . $project_member->getId() . " AND property_member_id <> '{$status_member_id}'");
}
}
$a = DimensionMemberAssociations::instance()->findOne(array('conditions' => array('associated_dimension_id=? AND associated_object_type_id=? AND dimension_id=?' . ($status_ot instanceof ObjectType ? ' AND object_type_id=' . $status_ot->getId() : ''), $member_dimension->getId(), $project_member->getObjectTypeId(), $status_dimension->getId())));
// create relation between members and remove old relations
if ($a instanceof DimensionMemberAssociation) {
if (is_numeric($status_member_id) && $status_member_id > 0) {
$mpm = MemberPropertyMembers::findOne(array('id' => true, 'conditions' => array('association_id = ? AND member_id = ? AND property_member_id = ?', $a->getId(), $project_member->getId(), $status_member_id)));
if (is_null($mpm)) {
$sql = "INSERT INTO " . TABLE_PREFIX . "member_property_members (association_id, member_id, property_member_id, is_active, created_on, created_by_id)\r\n\t\t\t\t\t\tVALUES (" . $a->getId() . "," . $status_member_id . "," . $project_member->getId() . ", 1, NOW()," . logged_user()->getId() . ");";
DB::executeAll($sql);
}
}
if ($remove_prev_associations) {
MemberPropertyMembers::instance()->delete('association_id = ' . $a->getId() . ' AND property_member_id = ' . $project_member->getId() . " AND member_id <> '{$status_member_id}'");
}
}
}
}
function addToMembers($members_array, $remove_old_comment_members = false)
{
ObjectMembers::addObjectToMembers($this->getId(), $members_array);
/*if (Plugins::instance()->isActivePlugin('mail') && $this instanceof MailContent) {
$inline_images = ProjectFiles::findAll(array("conditions" => "mail_id = ".$this->getId()));
foreach ($inline_images as $inline_img) {
$inline_img->addToMembers($members_array);
$inline_img->addToSharingTable();
}
}*/
if ($this->isCommentable()) {
$comments = $this->getComments(true);
foreach ($comments as $comment) {
if ($remove_old_comment_members) {
ObjectMembers::instance()->delete("object_id = " . $comment->getId());
}
$comment->addToMembers($members_array);
$comment->addToSharingTable();
}
}
}
