/**
*
* @author Ignacio Vazquez - elpepe.uy@gmail.com
* @param ProjectTask $object
*/
function addObject($object)
{
if ($this->hasObject($object)) {
return;
}
if (!$object->isTemplate() && $object->canBeTemplate()) {
// the object isn't a template but can be, create a template copy
$copy = $object->copy();
$copy->setColumnValue('is_template', true);
if ($copy instanceof ProjectTask) {
// don't copy milestone and parent task
$copy->setMilestoneId(0);
$copy->setParentId(0);
}
$copy->save();
//Also copy members..
// $memberIds = json_decode(array_var($_POST, 'members'));
// $controller = new ObjectController() ;
// $controller->add_to_members($copy, $memberIds);
// copy subtasks
if ($copy instanceof ProjectTask) {
ProjectTasks::copySubTasks($object, $copy, true);
} else {
if ($copy instanceof ProjectMilestone) {
ProjectMilestones::copyTasks($object, $copy, true);
}
}
// copy custom properties
$copy->copyCustomPropertiesFrom($object);
// copy linked objects
$linked_objects = $object->getAllLinkedObjects();
if (is_array($linked_objects)) {
foreach ($linked_objects as $lo) {
$copy->linkObject($lo);
}
}
// copy reminders
$reminders = ObjectReminders::getByObject($object);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$copy_reminder->setDate(EMPTY_DATETIME);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($copy);
$copy_reminder->setType($reminder->getType());
// $copy_reminder->setContactId($reminder->getContactId()); //TODO Feng 2 - No anda
$copy_reminder->save();
}
$template = $copy;
} else {
// the object is already a template or can't be one, use it as it is
$template = $object;
}
$to = new TemplateObject();
$to->setObject($template);
$to->setTemplate($this);
$to->save();
return $template->getObjectId();
}
function send_reminders() {
_log("Sending reminders...");
Env::useHelper('permissions');
$sent = 0;
$ors = ObjectReminders::getDueReminders();
foreach ($ors as $or) {
$function = $or->getType();
try {
$ret = 0;
Hook::fire($function, $or, $ret);
$sent += $ret;
} catch (Exception $ex) {
_log("Error sending reminder: " . $ex->getMessage());
}
}
_log("$sent reminders sent.");
}
function mail_on_page_load()
{
//check if have outbox mails
$usu = logged_user();
$accounts = MailAccounts::instance()->getMailAccountsByUser($usu);
$account_ids = array();
foreach ($accounts as $acc) {
$account_ids[] = $acc->getId();
}
if (count($account_ids) == 0) {
return;
}
$accounts_sql = " AND account_id IN (" . implode(',', $account_ids) . ")";
$user_pg_ids = $usu->getPermissionGroupIds();
if (count($user_pg_ids) == 0) {
return;
}
$permissions_sql = " AND EXISTS (SELECT sh.group_id FROM " . TABLE_PREFIX . "sharing_table sh WHERE sh.object_id=o.id AND sh.group_id IN (" . implode(',', $user_pg_ids) . "))";
$conditions = array("conditions" => array("`state` >= 200 AND (`state`%2 = 0) AND `archived_on`=0 AND `trashed_on`=0 {$accounts_sql} {$permissions_sql} AND `created_by_id` =" . $usu->getId()));
$outbox_mails = MailContents::findAll($conditions);
if ($outbox_mails != null) {
if (count($outbox_mails) >= 1) {
$arguments = array("conditions" => array("`context` LIKE 'mails_in_outbox%' AND `contact_id` = " . $usu->getId() . ";"));
$exist_reminder = ObjectReminders::find($arguments);
if (!(count($exist_reminder) > 0)) {
$reminder = new ObjectReminder();
$minutes = 0;
$reminder->setMinutesBefore($minutes);
$reminder->setType("reminder_popup");
$reminder->setContext("mails_in_outbox " . count($outbox_mails));
$reminder->setObject($usu);
$reminder->setUserId($usu->getId());
$reminder->setDate(DateTimeValueLib::now());
$reminder->save();
}
}
}
}
/**
* Edit task
*
* @access public
* @param void
* @return null
*/
function edit_task()
{
$isTemplateTask = false;
if (array_var($_REQUEST, 'template_task') == true) {
$isTemplateTask = true;
}
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$this->setTemplate('add_task');
if (array_var($_REQUEST, "template_task")) {
$task = TemplateTasks::findById(array_var($_REQUEST, "template_task_id", get_id()));
$this->setTemplate(get_template_path('add_template_task', 'template_task'));
if (array_var($_REQUEST, 'template_id')) {
$template_id = array_var($_REQUEST, 'template_id');
} else {
$template_id = $task->getTemplateId();
}
tpl_assign('additional_tt_params', array_var($_REQUEST, 'additional_tt_params'));
tpl_assign('template_id', $template_id);
if (!$task instanceof TemplateTask) {
flash_error(lang('task list dnx'));
ajx_current("empty");
return;
}
// if
} else {
$task = ProjectTasks::findById(get_id());
if (!$task instanceof ProjectTask) {
flash_error(lang('task list dnx'));
ajx_current("empty");
return;
}
// if
if (!$task->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
}
if (array_var($_GET, 'replace')) {
ajx_replace(true);
}
$task_data = array_var($_POST, 'task');
$time_estimate = array_var($_POST, 'hours', 0) * 60 + array_var($_POST, 'minutes', 0);
if ($time_estimate > 0) {
$estimatedTime = $time_estimate;
} else {
$estimatedTime = $task->getTimeEstimate();
}
if (!is_array($task_data)) {
// set layout for modal form
if (array_var($_REQUEST, 'modal')) {
$this->setLayout("json");
tpl_assign('modal', true);
}
$this->getRepeatOptions($task, $occ, $rsel1, $rsel2, $rsel3, $rnum, $rend, $rjump);
$dd = $task->getDueDate() instanceof DateTimeValue ? $task->getDueDate() : null;
if ($dd instanceof DateTimeValue && $task->getUseDueTime()) {
$dd->advance(logged_user()->getTimezone() * 3600);
}
$sd = $task->getStartDate() instanceof DateTimeValue ? $task->getStartDate() : null;
if ($sd instanceof DateTimeValue && $task->getUseStartTime()) {
$sd->advance(logged_user()->getTimezone() * 3600);
}
$post_dd = null;
if (array_var($_POST, 'task_due_date')) {
$post_dd = getDateValue(array_var($_POST, 'task_due_date'));
if ($post_dd instanceof DateTimeValue) {
$duetime = getTimeValue(array_var($_POST, 'task_due_time'));
if (is_array($duetime)) {
$post_dd->setHour(array_var($duetime, 'hours'));
$post_dd->setMinute(array_var($duetime, 'mins'));
$post_dd->advance(logged_user()->getTimezone() * 3600);
}
}
}
$post_st = null;
if (array_var($_POST, 'task_start_date')) {
$post_st = getDateValue(array_var($_POST, 'task_start_date'));
if ($post_st instanceof DateTimeValue) {
$starttime = getTimeValue(array_var($_POST, 'task_start_time'));
if (is_array($starttime)) {
$post_st->setHour(array_var($starttime, 'hours'));
$post_st->setMinute(array_var($starttime, 'mins'));
$post_st->advance(logged_user()->getTimezone() * 3600);
}
}
}
if (config_option("wysiwyg_tasks")) {
$text_post = preg_replace("/[\n|\r|\n\r]/", '', array_var($_POST, 'text', $task->getText()));
} else {
$text_post = array_var($_POST, 'text', $task->getText());
}
$task_data = array('name' => array_var($_POST, 'name', $task->getObjectName()), 'text' => $text_post, 'milestone_id' => array_var($_POST, 'milestone_id', $task->getMilestoneId()), 'due_date' => getDateValue($post_dd, $dd), 'start_date' => getDateValue($post_st, $sd), 'parent_id' => $task->getParentId(), 'assigned_to_contact_id' => array_var($_POST, 'assigned_to_contact_id', $task->getAssignedToContactId()), 'selected_members_ids' => json_decode(array_var($_POST, 'members', null)), 'priority' => array_var($_POST, 'priority', $task->getPriority()), 'time_estimate' => $estimatedTime, 'percent_completed' => $task->getPercentCompleted(), 'forever' => $task->getRepeatForever(), 'rend' => $rend, 'rnum' => $rnum, 'rjump' => $rjump, 'rsel1' => $rsel1, 'rsel2' => $rsel2, 'rsel3' => $rsel3, 'occ' => $occ, 'repeat_by' => $task->getRepeatBy(), 'object_subtype' => array_var($_POST, "object_subtype", $task->getObjectSubtype() != 0 ? $task->getObjectSubtype() : config_option('default task co type')), 'type_content' => $task->getTypeContent(), 'multi_assignment' => $task->getColumnValue('multi_assignment', 0), 'send_notification_subscribers' => user_config_option("can notify subscribers"));
// array
//control dates of parent and subtasks
$task_data['type_control'] = "";
$parent_data = $task->getParent();
if ($parent_data) {
$task_data['type_control'] = "child";
$task_data['control_title'] = $parent_data->getObjectName();
$task_data['control_due_date'] = $parent_data->getDueDate() instanceof DateTimeValue ? $parent_data->getDueDate()->getTimestamp() + logged_user()->getTimezone() * 3600 : null;
$task_data['control_start_date'] = $parent_data->getStartDate() instanceof DateTimeValue ? $parent_data->getStartDate()->getTimestamp() + logged_user()->getTimezone() * 3600 : null;
}
$subtask_data = $task->getAllSubTasks();
if ($subtask_data) {
$task_data['type_control'] = "father";
$task_data['control_title'] = $task->getObjectName();
$task_data['control_due_date'] = getDateValue($post_dd, $dd) instanceof DateTimeValue ? getDateValue($post_dd, $dd)->getTimestamp() : null;
$task_data['control_start_date'] = getDateValue($post_st, $sd) instanceof DateTimeValue ? getDateValue($post_st, $sd)->getTimestamp() : null;
}
}
// if
//I find all those related to the task to find out if the original
$task_related = ProjectTasks::findByRelated($task->getObjectId());
if (!$task_related) {
//is not the original as the original look plus other related
if ($task->getOriginalTaskId() != "0") {
$task_related = ProjectTasks::findByTaskAndRelated($task->getObjectId(), $task->getOriginalTaskId());
}
}
if ($task_related) {
$pending_id = 0;
foreach ($task_related as $t_rel) {
if ($task->getStartDate() <= $t_rel->getStartDate() && $task->getDueDate() <= $t_rel->getDueDate() && !$t_rel->isCompleted()) {
$pending_id = $t_rel->getId();
break;
}
}
tpl_assign('pending_task_id', $pending_id);
tpl_assign('task_related', true);
} else {
tpl_assign('pending_task_id', 0);
tpl_assign('task_related', false);
}
tpl_assign('task', $task);
tpl_assign('task_data', $task_data);
if (is_array(array_var($_POST, 'task'))) {
foreach ($task_data as $k => &$v) {
$v = remove_scripts($v);
}
$send_edit = false;
if ($task->getAssignedToContactId() == array_var($task_data, 'assigned_to_contact_id')) {
$send_edit = true;
}
$old_owner = $task->getAssignedTo();
if (array_var($task_data, 'parent_id') == $task->getId()) {
flash_error(lang("task own parent error"));
ajx_current("empty");
return;
}
try {
try {
$task_data['due_date'] = getDateValue(array_var($_POST, 'task_due_date'));
$task_data['start_date'] = getDateValue(array_var($_POST, 'task_start_date'));
} catch (Exception $e) {
throw new Exception(lang('date format error', date_format_tip(user_config_option('date_format'))));
}
if ($task_data['due_date'] instanceof DateTimeValue) {
$duetime = getTimeValue(array_var($_POST, 'task_due_time'));
if (is_array($duetime)) {
$task_data['due_date']->setHour(array_var($duetime, 'hours'));
$task_data['due_date']->setMinute(array_var($duetime, 'mins'));
$task_data['due_date']->advance(logged_user()->getTimezone() * -3600);
}
$task_data['use_due_time'] = is_array($duetime);
}
if ($task_data['start_date'] instanceof DateTimeValue) {
$starttime = getTimeValue(array_var($_POST, 'task_start_time'));
if (is_array($starttime)) {
$task_data['start_date']->setHour(array_var($starttime, 'hours'));
$task_data['start_date']->setMinute(array_var($starttime, 'mins'));
$task_data['start_date']->advance(logged_user()->getTimezone() * -3600);
}
$task_data['use_start_time'] = is_array($starttime);
}
//control date subtask whit parent
if (array_var($_POST, 'control_dates') == "child") {
$parent = $task->getParent();
if ($parent->getStartDate() instanceof DateTimeValue && $task_data['start_date'] instanceof DateTimeValue) {
if ($task_data['start_date']->getTimestamp() < $parent->getStartDate()->getTimestamp()) {
$parent->setStartDate($task_data['start_date']);
$parent->setUseStartTime($task_data['use_start_time']);
}
} else {
$parent->setStartDate($task_data['start_date']);
$parent->setUseStartTime(array_var($task_data, 'use_start_time', 0));
}
if ($parent->getDueDate() instanceof DateTimeValue && $task_data['due_date'] instanceof DateTimeValue) {
if ($task_data['due_date']->getTimestamp() > $parent->getDueDate()->getTimestamp()) {
$parent->setDueDate($task_data['due_date']);
$parent->setUseDueTime($task_data['use_due_time']);
}
} else {
$parent->setDueDate($task_data['due_date']);
$parent->setUseDueTime(array_var($task_data, 'use_due_time', 0));
}
// calculate and set estimated time
$totalMinutes = array_var($task_data, 'time_estimate_hours') * 60 + array_var($task_data, 'time_estimate_minutes');
$parent->setTimeEstimate($totalMinutes);
$parent->save();
}
$err_msg = $this->setRepeatOptions($task_data);
if ($err_msg) {
throw new Exception($err_msg);
}
if (!isset($task_data['parent_id'])) {
$task_data['parent_id'] = 0;
}
$member_ids = json_decode(array_var($_POST, 'members'));
// keep old dates to check for subtasks
$old_start_date = $task->getStartDate();
$old_due_date = $task->getDueDate();
if (config_option("wysiwyg_tasks")) {
$task_data['type_content'] = "html";
$task_data['text'] = str_replace(array("\r", "\n", "\r\n"), array('', '', ''), array_var($task_data, 'text'));
} else {
$task_data['type_content'] = "text";
}
$task->setFromAttributes($task_data);
$totalMinutes = array_var($task_data, 'time_estimate_hours') * 60 + array_var($task_data, 'time_estimate_minutes');
$task->setTimeEstimate($totalMinutes);
if ($task->getParentId() > 0 && $task->hasChild($task->getParentId())) {
flash_error(lang('task child of child error'));
ajx_current("empty");
return;
}
if (isset($task_data['percent_completed']) && $task_data['percent_completed'] >= 0 && $task_data['percent_completed'] <= 100) {
$task->setPercentCompleted($task_data['percent_completed']);
}
DB::beginWork();
$task->save();
if (!isset($task_data['percent_completed'])) {
$task->calculatePercentComplete();
}
// dependencies
if (config_option('use tasks dependencies')) {
$previous_tasks = array_var($task_data, 'previous');
if (is_array($previous_tasks)) {
foreach ($previous_tasks as $ptask) {
if ($ptask == $task->getId()) {
continue;
}
$dep = ProjectTaskDependencies::findById(array('previous_task_id' => $ptask, 'task_id' => $task->getId()));
if (!$dep instanceof ProjectTaskDependency) {
$dep = new ProjectTaskDependency();
$dep->setPreviousTaskId($ptask);
$dep->setTaskId($task->getId());
$dep->save();
}
}
$saved_ptasks = ProjectTaskDependencies::findAll(array('conditions' => 'task_id = ' . $task->getId()));
foreach ($saved_ptasks as $pdep) {
if (!in_array($pdep->getPreviousTaskId(), $previous_tasks)) {
$pdep->delete();
}
}
} else {
ProjectTaskDependencies::delete('task_id = ' . $task->getId());
}
}
// Add assigned user to the subscibers list
if ($task->getAssignedToContactId() > 0 && Contacts::instance()->findById($task->getAssignedToContactId())) {
if (!isset($_POST['subscribers'])) {
$_POST['subscribers'] = array();
}
$_POST['subscribers']['user_' . $task->getAssignedToContactId()] = '1';
}
$object_controller = new ObjectController();
if ($isTemplateTask) {
$object_controller->add_to_members($task, $member_ids, null, false);
} else {
$object_controller->add_to_members($task, $member_ids);
}
$is_template = $task instanceof TemplateTask;
$object_controller->add_subscribers($task, null, !$is_template);
$object_controller->link_to_new_object($task);
$object_controller->add_custom_properties($task);
if (!$task->isCompleted()) {
//to make sure the task it is not completed yet, and that it has subscribed people
$old_reminders = ObjectReminders::getByObject($task);
$object_controller->add_reminders($task);
//adding the new reminders, if any
$object_controller->update_reminders($task, $old_reminders);
//updating the old ones
if (logged_user() instanceof Contact && (!is_array($old_reminders) || count($old_reminders) == 0) && (user_config_option("add_task_autoreminder") && logged_user()->getId() != $task->getAssignedToContactId() || user_config_option("add_self_task_autoreminder") && logged_user()->getId() == $task->getAssignedToContactId())) {
//if there is no asignee, but it still has subscribers
$reminder = new ObjectReminder();
$def = explode(",", user_config_option("reminders_tasks"));
$minutes = $def[2] * $def[1];
$reminder->setMinutesBefore($minutes);
$reminder->setType($def[0]);
$reminder->setContext("due_date");
$reminder->setObject($task);
$reminder->setUserId(0);
$date = $task->getDueDate();
if ($date instanceof DateTimeValue) {
$rdate = new DateTimeValue($date->getTimestamp() - $minutes * 60);
$reminder->setDate($rdate);
}
$reminder->save();
}
}
if (!is_array($member_ids) || count($member_ids) == 0) {
$member_ids = array(0);
}
$members = Members::findAll(array('conditions' => "id IN (" . implode(',', $member_ids) . ")"));
$task->apply_members_to_subtasks($members, true);
// apply values to subtasks
$assigned_to = $task->getAssignedToContactId();
$subtasks = $task->getAllSubTasks();
$milestone_id = $task->getMilestoneId();
$apply_ms = array_var($task_data, 'apply_milestone_subtasks');
$apply_at = array_var($task_data, 'apply_assignee_subtasks', '');
foreach ($subtasks as $sub) {
$modified = false;
//if ($apply_at || !($sub->getAssignedToContactId() > 0)) {
if ($apply_at) {
$sub->setAssignedToContactId($assigned_to);
$modified = true;
}
if ($apply_ms) {
$sub->setMilestoneId($milestone_id);
$modified = true;
}
if ($modified) {
$sub->save();
}
//control date parent whit subtask
if ($_POST['control_dates'] == "father") {
if ($sub->getStartDate() instanceof DateTimeValue) {
if ($task->getStartDate() instanceof DateTimeValue) {
if ($task->getStartDate()->getTimestamp() > $sub->getStartDate()->getTimestamp()) {
$sub->setStartDate($task->getStartDate());
}
}
} else {
if ($task->getStartDate() instanceof DateTimeValue) {
$sub->setStartDate($task->getStartDate());
}
}
$sub->setUseStartTime($task->getUseStartTime());
if ($sub->getDueDate() instanceof DateTimeValue) {
if ($task->getDueDate() instanceof DateTimeValue) {
if ($task->getDueDate()->getTimestamp() < $sub->getDueDate()->getTimestamp()) {
$sub->setDueDate($task->getDueDate());
}
}
} else {
if ($task->getDueDate() instanceof DateTimeValue) {
$sub->setDueDate($task->getDueDate());
}
}
$sub->setUseDueTime($task->getUseDueTime());
$sub->save();
}
}
$task->resetIsRead();
$log_info = '';
if ($send_edit == true) {
$log_info = $task->getAssignedToContactId();
} else {
if ($send_edit == false) {
$task->setAssignedBy(logged_user());
$task->save();
}
}
if (config_option('repeating_task') == 1) {
$opt_rep_day['saturday'] = false;
$opt_rep_day['sunday'] = false;
if (array_var($task_data, 'repeat_saturdays', false)) {
$opt_rep_day['saturday'] = true;
}
if (array_var($task_data, 'repeat_sundays', false)) {
$opt_rep_day['sunday'] = true;
}
$this->repetitive_task($task, $opt_rep_day);
}
if (isset($_POST['type_related'])) {
if ($_POST['type_related'] == "all" || $_POST['type_related'] == "news") {
$task_data['members'] = json_decode(array_var($_POST, 'members'));
unset($task_data['due_date']);
unset($task_data['use_due_time']);
unset($task_data['start_date']);
unset($task_data['use_start_time']);
$this->repetitive_tasks_related($task, "edit", $_POST['type_related'], $task_data);
}
}
if (config_option('multi_assignment') && Plugins::instance()->isActivePlugin('crpm')) {
if (array_var($task_data, 'multi_assignment_aplly_change') == 'subtask') {
$null = null;
Hook::fire('edit_subtasks', $task, $null);
}
}
//for calculate member status we save de task again after the object have the members
$task->save();
// save subtasks added in 'subtasks' tab
$sub_tasks_to_log = $this->saveSubtasks($task, array_var($task_data, 'subtasks'), $member_ids);
DB::commit();
foreach ($sub_tasks_to_log['add'] as $st_to_log) {
ApplicationLogs::createLog($st_to_log, ApplicationLogs::ACTION_ADD);
}
foreach ($sub_tasks_to_log['edit'] as $st_to_log) {
ApplicationLogs::createLog($st_to_log, ApplicationLogs::ACTION_EDIT);
}
foreach ($sub_tasks_to_log['trash'] as $st_to_log) {
ApplicationLogs::createLog($st_to_log, ApplicationLogs::ACTION_TRASH);
}
//Send Template task to view
if ($task instanceof TemplateTask) {
$objectId = $task->getObjectId();
$id = $task->getId();
$objectTypeName = $task->getObjectTypeName();
$objectName = $task->getObjectName();
$manager = get_class($task->manager());
$milestoneId = $task instanceof TemplateTask ? $task->getMilestoneId() : '0';
$subTasks = $task->getSubTasks();
$parentId = $task->getParentId();
$ico = "ico-task";
$action = "edit";
$object = TemplateController::prepareObject($objectId, $id, $objectName, $objectTypeName, $manager, $action, $milestoneId, $subTasks, $parentId, $ico);
$template_task_data = array('object' => $object);
if (array_var($_REQUEST, 'additional_tt_params')) {
$additional_tt_params = json_decode(str_replace("'", '"', array_var($_REQUEST, 'additional_tt_params')), true);
foreach ($additional_tt_params as $k => $v) {
$template_task_data[$k] = $v;
}
}
if (!array_var($_REQUEST, 'modal')) {
evt_add("template object added", $template_task_data);
}
}
try {
// notify asignee
if (array_var($task_data, 'send_notification') && $task->getAssignedToContactId() != $task->getAssignedById()) {
$new_owner = $task->getAssignedTo();
if ($new_owner instanceof Contact) {
Notifier::taskAssigned($task);
}
// if
}
// if
if (array_var($task_data, 'send_notification')) {
foreach ($sub_tasks_to_log['assigned'] as $st_to_log) {
Notifier::taskAssigned($st_to_log);
}
}
} catch (Exception $e) {
}
// try
//notify subscribers
$isSilent = true;
if (array_var($task_data, 'send_notification_subscribers')) {
$isSilent = false;
}
ApplicationLogs::createLog($task, ApplicationLogs::ACTION_EDIT, false, false, true, $log_info);
//flash_success(lang('success edit task list', $task->getObjectName()));
if (array_var($_REQUEST, 'modal')) {
if (array_var($_REQUEST, 'reload')) {
evt_add("reload current panel");
} else {
ajx_current("empty");
$this->setLayout("json");
$this->setTemplate(get_template_path("empty"));
// reload task info because plugins may have updated some task info (for example: name prefix)
if ($is_template) {
$task = TemplateTasks::findById($task->getId());
} else {
$task = ProjectTasks::findById($task->getId());
}
$params = array('msg' => lang('success edit task list', $task->getObjectName()), 'task' => $task->getArrayInfo(), 'reload' => array_var($_REQUEST, 'reload'));
if ($task instanceof TemplateTask) {
//$params['msg'] = lang('success edit template', $task->getObjectName());
$params['object'] = $template_task_data['object'];
}
//print_modal_json_response($params, true, array_var($_REQUEST, 'use_ajx'));
ajx_extra_data($params);
}
} else {
ajx_current("back");
}
// if has subtasks and dates were changed, ask the user if the subtasks dates should also be changed
if ($task instanceof ProjectTask && $task->countOpenSubTasks() > 0) {
// check if there was any due date changes
$dd_advance_info = null;
if ($task->getDueDate() instanceof DateTimeValue && $old_due_date instanceof DateTimeValue && $old_due_date->getTimestamp() != $task->getDueDate()->getTimestamp()) {
$dd_to_advance_ts = $task->getDueDate()->getTimestamp() - $old_due_date->getTimestamp();
if ($dd_to_advance_ts != 0) {
$dd_advance_info = get_time_info($dd_to_advance_ts);
}
}
// check if there was any start date changes
$sd_advance_info = null;
if ($task->getStartDate() instanceof DateTimeValue && $old_start_date instanceof DateTimeValue && $old_start_date->getTimestamp() != $task->getStartDate()->getTimestamp()) {
$sd_to_advance_ts = $task->getStartDate()->getTimestamp() - $old_start_date->getTimestamp();
if ($sd_to_advance_ts != 0) {
$sd_advance_info = get_time_info($sd_to_advance_ts);
}
}
if ($dd_advance_info != null || $sd_advance_info != null) {
evt_add('ask to change subtasks dates', array('dd_diff' => $dd_advance_info, 'sd_diff' => $sd_advance_info, 'task_id' => $task->getId()));
}
}
} catch (Exception $e) {
DB::rollback();
if (array_var($_REQUEST, 'modal')) {
$this->setLayout("json");
$this->setTemplate(get_template_path("empty"));
print_modal_json_response(array('errorCode' => 1, 'errorMessage' => $e->getMessage(), 'showMessage' => 1), true, array_var($_REQUEST, 'use_ajx'));
} else {
flash_error($e->getMessage());
}
ajx_current("empty");
}
// try
}
// if
}
/**
* Clear Reminders by user
*
* @param User $user
* @return boolean
*/
static function clearByUser(User $user)
{
return ObjectReminders::delete('`user_id` = ' . DB::escape($user->getId()));
}
function findByEvent($event_id)
{
return ObjectReminders::findAll(array('conditions' => array('`object_id` = ?', $event_id)));
}
function popup_reminders()
{
ajx_current("empty");
// if no new popup reminders don't make useless queries
if (GlobalCache::isAvailable()) {
$check = GlobalCache::get('check_for_popup_reminders_' . logged_user()->getId(), $success);
if ($success && $check == 0) {
return;
}
}
$reminders = ObjectReminders::getDueReminders("reminder_popup");
$popups = array();
foreach ($reminders as $reminder) {
$object = $reminder->getObject();
$context = $reminder->getContext();
$type = $object->getObjectTypeName();
$date = $object->getColumnValue($reminder->getContext());
if (!$date instanceof DateTimeValue) {
continue;
}
if ($object->isTrashed()) {
$reminder->delete();
continue;
}
// convert time to the user's locale
$timezone = logged_user()->getTimezone();
if ($date->getTimestamp() + 5 * 60 < DateTimeValueLib::now()->getTimestamp()) {
// don't show popups older than 5 minutes
$reminder->delete();
continue;
}
if ($reminder->getUserId() == 0) {
if (!$object->isSubscriber(logged_user())) {
// reminder for subscribers and user is not subscriber
continue;
}
} else {
if ($reminder->getUserId() != logged_user()->getId()) {
continue;
}
}
if ($context == "due_date" && $object instanceof ProjectTask) {
if ($object->isCompleted()) {
// don't show popups for completed tasks
$reminder->delete();
continue;
}
}
$url = $object->getViewUrl();
$link = '<a href="#" onclick="og.openLink(\'' . $url . '\');return false;">' . clean($object->getObjectName()) . '</a>';
evt_add("popup", array('title' => lang("{$context} {$type} reminder"), 'message' => lang("{$context} {$type} reminder desc", $link, format_datetime($date)), 'type' => 'reminder', 'sound' => 'info'));
if ($reminder->getUserId() == 0) {
// reminder is for all subscribers, so change it for one reminder per user (except logged_user)
// otherwise if deleted it won't notify other subscribers and if not deleted it will keep notifying
// logged user
$subscribers = $object->getSubscribers();
foreach ($subscribers as $subscriber) {
if ($subscriber->getId() != logged_user()->getId()) {
$new = new ObjectReminder();
$new->setContext($reminder->getContext());
$new->setDate($reminder->getDate());
$new->setMinutesBefore($reminder->getMinutesBefore());
$new->setObject($object);
$new->setUser($subscriber);
$new->setType($reminder->getType());
$new->save();
}
}
}
$reminder->delete();
}
// popup reminders already checked for logged user
if (GlobalCache::isAvailable()) {
$today_next_reminders = ObjectReminders::findAll(array('conditions' => array("`date` > ? AND `date` < ?", DateTimeValueLib::now(), DateTimeValueLib::now()->endOfDay()), 'limit' => config_option('cron reminder limit', 100)));
if (count($today_next_reminders) == 0) {
GlobalCache::update('check_for_popup_reminders_' . logged_user()->getId(), 0, 60 * 30);
}
}
}
/**
* Return manager instance
*
* @access protected
* @param void
* @return ObjectReminders
*/
function manager() {
if(!($this->manager instanceof ObjectReminders)) $this->manager = ObjectReminders::instance();
return $this->manager;
} // manager
function clearReminders($user = null, $include_subscribers = false)
{
if (isset($user)) {
return ObjectReminders::clearByObjectAndUser($this, $user, $include_subscribers);
} else {
return ObjectReminders::clearByObject($this);
}
}
function popup_reminders()
{
ajx_current("empty");
// extra data to send to interface
$extra_data = array();
// if no new popup reminders don't make useless queries
if (GlobalCache::isAvailable()) {
$check = GlobalCache::get('check_for_popup_reminders_' . logged_user()->getId(), $success);
if ($success && $check == 0) {
return;
}
}
$reminders = ObjectReminders::getDueReminders("reminder_popup");
$popups = array();
foreach ($reminders as $reminder) {
$context = $reminder->getContext();
if (str_starts_with($context, "mails_in_outbox")) {
if ($reminder->getUserId() > 0 && $reminder->getUserId() != logged_user()->getId()) {
continue;
}
preg_match('!\\d+!', $context, $matches);
evt_add("popup", array('title' => lang("mails_in_outbox reminder"), 'message' => lang("mails_in_outbox reminder desc", $matches[0]), 'type' => 'reminder', 'sound' => 'info'));
$reminder->delete();
continue;
}
if (str_starts_with($context, "eauthfail")) {
if ($reminder->getUserId() == logged_user()->getId()) {
$acc = trim(substr($context, strrpos($context, " ")));
evt_add("popup", array('title' => lang("failed to authenticate email account"), 'message' => lang("failed to authenticate email account desc", $acc), 'type' => 'reminder', 'sound' => 'info'));
$reminder->delete();
}
continue;
}
$object = $reminder->getObject();
$type = $object->getObjectTypeName();
$date = $object->getColumnValue($reminder->getContext());
if (!$date instanceof DateTimeValue) {
continue;
}
if ($object->isTrashed()) {
$reminder->delete();
continue;
}
// convert time to the user's locale
$timezone = logged_user()->getTimezone();
if ($date->getTimestamp() + 5 * 60 < DateTimeValueLib::now()->getTimestamp()) {
// don't show popups older than 5 minutes
//$reminder->delete();
//continue;
}
if ($reminder->getUserId() == 0) {
if (!$object->isSubscriber(logged_user())) {
// reminder for subscribers and user is not subscriber
continue;
}
} else {
if ($reminder->getUserId() != logged_user()->getId()) {
continue;
}
}
if ($context == "due_date" && $object instanceof ProjectTask) {
if ($object->isCompleted()) {
// don't show popups for completed tasks
$reminder->delete();
continue;
}
}
$url = $object->getViewUrl();
$link = '<a href="#" onclick="og.openLink(\'' . $url . '\');return false;">' . clean($object->getObjectName()) . '</a>';
evt_add("popup", array('title' => lang("{$context} {$type} reminder", clean($object->getObjectName())), 'message' => lang("{$context} {$type} reminder desc", $link, format_datetime($date)), 'type' => 'reminder', 'sound' => 'info'));
if ($reminder->getUserId() == 0) {
// reminder is for all subscribers, so change it for one reminder per user (except logged_user)
// otherwise if deleted it won't notify other subscribers and if not deleted it will keep notifying
// logged user
$subscribers = $object->getSubscribers();
foreach ($subscribers as $subscriber) {
if ($subscriber->getId() != logged_user()->getId()) {
$new = new ObjectReminder();
$new->setContext($reminder->getContext());
$new->setDate($reminder->getDate());
$new->setMinutesBefore($reminder->getMinutesBefore());
$new->setObject($object);
$new->setUser($subscriber);
$new->setType($reminder->getType());
$new->save();
}
}
}
$reminder->delete();
}
// popup reminders already checked for logged user
if (GlobalCache::isAvailable()) {
$today_next_reminders = ObjectReminders::findAll(array('conditions' => array("`date` > ? AND `date` < ?", DateTimeValueLib::now(), DateTimeValueLib::now()->endOfDay()), 'limit' => config_option('cron reminder limit', 100)));
if (count($today_next_reminders) == 0) {
GlobalCache::update('check_for_popup_reminders_' . logged_user()->getId(), 0, 60 * 30);
}
}
// check for member modifications
if (isset($_POST['dims_check_date'])) {
$dims_check_date = new DateTimeValue($_POST['dims_check_date']);
$dims_check_date_sql = $dims_check_date->toMySQL();
$members_log_count = ApplicationLogs::instance()->count("member_id>0 AND created_on>'{$dims_check_date_sql}'");
if ($members_log_count > 0) {
$extra_data['reload_dims'] = 1;
}
}
ajx_extra_data($extra_data);
}
/**
* Delete this object
*
* @param void
* @return boolean
*/
function delete()
{
if ($this->isAccountOwner()) {
return false;
}
// if
$this->deleteAvatar();
//$this->deletePersonalProject();
MailAccountUsers::deleteByUser($this);
GroupUsers::clearByUser($this);
Contacts::updateUserIdOnUserDelete($this->getId());
ProjectUsers::clearByUser($this);
ObjectSubscriptions::clearByUser($this);
ObjectReminders::clearByUser($this);
EventInvitations::clearByUser($this);
UserPasswords::clearByUser($this);
return parent::delete();
}
/**
* 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, 'ObjectReminders')) {
return parent::paginate($arguments, $items_per_page, $current_page);
} else {
return ObjectReminders::instance()->paginate($arguments, $items_per_page, $current_page);
//$instance =& ObjectReminders::instance();
//return $instance->paginate($arguments, $items_per_page, $current_page);
}
// if
}
/**
* Edit task
*
* @access public
* @param void
* @return null
*/
function edit_task() {
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$this->setTemplate('add_task');
$task = ProjectTasks::findById(get_id());
if(!($task instanceof ProjectTask)) {
flash_error(lang('task list dnx'));
ajx_current("empty");
return;
} // if
if(!$task->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
} // if
if (array_var($_GET, 'replace')) {
ajx_replace(true);
}
$task_data = array_var($_POST, 'task');
$time_estimate = (array_var($_POST, 'hours', 0) * 60) + array_var($_POST, 'minutes', 0);
if($time_estimate > 0){
$estimatedTime = $time_estimate;
}else{
$estimatedTime = $task->getTimeEstimate();
}
if(!is_array($task_data)) {
$this->getRepeatOptions($task, $occ, $rsel1, $rsel2, $rsel3, $rnum, $rend, $rjump);
$dd = $task->getDueDate() instanceof DateTimeValue ? $task->getDueDate()->advance(logged_user()->getTimezone() * 3600, false) : null;
$sd = $task->getStartDate() instanceof DateTimeValue ? $task->getStartDate()->advance(logged_user()->getTimezone() * 3600, false) : null;
$post_dd = null;
if(array_var($_POST, 'task_due_date')){
$post_dd = getDateValue(array_var($_POST, 'task_due_date'));
if ($post_dd instanceof DateTimeValue) {
$duetime = getTimeValue(array_var($_POST, 'task_due_time'));
if (is_array($duetime)) {
$post_dd->setHour(array_var($duetime, 'hours'));
$post_dd->setMinute(array_var($duetime, 'mins'));
$post_dd->advance(logged_user()->getTimezone() * 3600, false);
}
}
}
$post_st = null;
if(array_var($_POST, 'task_start_date')){
$post_st = getDateValue(array_var($_POST, 'task_start_date'));
if ($post_st instanceof DateTimeValue) {
$starttime = getTimeValue(array_var($_POST, 'task_start_time'));
if (is_array($starttime)) {
$post_st->setHour(array_var($starttime, 'hours'));
$post_st->setMinute(array_var($starttime, 'mins'));
$post_st->advance(logged_user()->getTimezone() * 3600, false);
}
}
}
if(config_option("wysiwyg_tasks")){
$text_post = preg_replace("/[\n|\r|\n\r]/", '', array_var($_POST, 'text', $task->getText()));
}else{
$text_post = array_var($_POST, 'text', $task->getText());
}
$task_data = array(
'name' => array_var($_POST, 'name', $task->getObjectName()),
'text' => $text_post,
'milestone_id' => array_var($_POST, 'milestone_id',$task->getMilestoneId()),
'due_date' => getDateValue($post_dd, $dd),
'start_date' => getDateValue($post_st, $sd),
'parent_id' => $task->getParentId(),
'assigned_to_contact_id' => array_var($_POST, 'assigned_to_contact_id', $task->getAssignedToContactId()),
'priority' => array_var($_POST, 'priority', $task->getPriority()),
'send_notification' => array_var($_POST, 'notify') == 'true',
'time_estimate' => $estimatedTime,
'percent_completed' => $task->getPercentCompleted(),
'forever' => $task->getRepeatForever(),
'rend' => $rend,
'rnum' => $rnum,
'rjump' => $rjump,
'rsel1' => $rsel1,
'rsel2' => $rsel2,
'rsel3' => $rsel3,
'occ' => $occ,
'repeat_by' => $task->getRepeatBy(),
'object_subtype' => array_var($_POST, "object_subtype", ($task->getObjectSubtype() != 0 ? $task->getObjectSubtype() : config_option('default task co type'))),
'type_content' => $task->getTypeContent(),
'multi_assignment' => $task->getColumnValue('multi_assignment',0)
); // array
//control dates of parent and subtasks
$task_data ['type_control'] = "";
$parent_data = $task->getParent();
if($parent_data){
$task_data ['type_control'] = "child";
$task_data ['control_title'] = $parent_data->getObjectName();
$task_data ['control_due_date'] = $parent_data->getDueDate() instanceof DateTimeValue ? $parent_data->getDueDate()->getTimestamp() + logged_user()->getTimezone() * 3600 : null;
$task_data ['control_start_date'] = $parent_data->getStartDate() instanceof DateTimeValue ? $parent_data->getStartDate()->getTimestamp() + logged_user()->getTimezone() * 3600 : null;
}
$subtask_data = $task->getAllSubTasks();
if($subtask_data){
$task_data ['type_control'] = "father";
$task_data ['control_title'] = $task->getObjectName();
$task_data ['control_due_date'] = getDateValue($post_dd, $dd) instanceof DateTimeValue ? getDateValue($post_dd, $dd)->getTimestamp() : null;
$task_data ['control_start_date'] = getDateValue($post_st, $sd)instanceof DateTimeValue ? getDateValue($post_st, $sd)->getTimestamp() : null;
}
} // if
//I find all those related to the task to find out if the original
$task_related = ProjectTasks::findByRelated($task->getObjectId());
if(!$task_related){
//is not the original as the original look plus other related
if($task->getOriginalTaskId() != "0"){
$task_related = ProjectTasks::findByTaskAndRelated($task->getObjectId(),$task->getOriginalTaskId());
}
}
if($task_related){
$pending_id = 0;
foreach($task_related as $t_rel){
if($task->getStartDate() <= $t_rel->getStartDate() && $task->getDueDate() <= $t_rel->getDueDate() && !$t_rel->isCompleted()){
$pending_id = $t_rel->getId();
break;
}
}
tpl_assign('pending_task_id', $pending_id);
tpl_assign('task_related', true);
}else{
tpl_assign('pending_task_id', 0);
tpl_assign('task_related', false);
}
tpl_assign('task', $task);
tpl_assign('task_data', $task_data);
if(is_array(array_var($_POST, 'task'))) {
$send_edit = false;
if($task->getAssignedToContactId() == array_var($task_data, 'assigned_to_contact_id')){
$send_edit = true;
}
$old_owner = $task->getAssignedTo();
if (array_var($task_data, 'parent_id') == $task->getId()) {
flash_error(lang("task own parent error"));
ajx_current("empty");
return;
}
$task_data['due_date'] = getDateValue(array_var($_POST, 'task_due_date'));
$task_data['start_date'] = getDateValue(array_var($_POST, 'task_start_date'));
if ($task_data['due_date'] instanceof DateTimeValue) {
$duetime = getTimeValue(array_var($_POST, 'task_due_time'));
if (is_array($duetime)) {
$task_data['due_date']->setHour(array_var($duetime, 'hours'));
$task_data['due_date']->setMinute(array_var($duetime, 'mins'));
}
$task_data['due_date']->advance(logged_user()->getTimezone() * -3600);
$task_data['use_due_time'] = is_array($duetime);
}
if ($task_data['start_date'] instanceof DateTimeValue) {
$starttime = getTimeValue(array_var($_POST, 'task_start_time'));
if (is_array($starttime)) {
$task_data['start_date']->setHour(array_var($starttime, 'hours'));
$task_data['start_date']->setMinute(array_var($starttime, 'mins'));
}
$task_data['start_date']->advance(logged_user()->getTimezone() * -3600);
$task_data['use_start_time'] = is_array($starttime);
}
//control date subtask whit parent
if(array_var($_POST, 'control_dates') == "child"){
$parent = $task->getParent();
if ($parent->getStartDate() instanceof DateTimeValue && $task_data['start_date'] instanceof DateTimeValue) {
if($task_data['start_date']->getTimestamp() < $parent->getStartDate()->getTimestamp()){
$parent->setStartDate($task_data['start_date']);
$parent->setUseStartTime($task_data['use_start_time']);
}
}else{
$parent->setStartDate($task_data['start_date']);
$parent->setUseStartTime(array_var($task_data, 'use_start_time',0));
}
if ($parent->getDueDate() instanceof DateTimeValue && $task_data['due_date'] instanceof DateTimeValue) {
if($task_data['due_date']->getTimestamp() > $parent->getDueDate()->getTimestamp()){
$parent->setDueDate($task_data['due_date']);
$parent->setUseDueTime($task_data['use_due_time']);
}
}else{
$parent->setDueDate($task_data['due_date']);
$parent->setUseDueTime(array_var($task_data, 'use_due_time',0));
}
// calculate and set estimated time
$totalMinutes = (array_var($task_data, 'time_estimate_hours') * 60) + (array_var($task_data, 'time_estimate_minutes'));
$parent->setTimeEstimate($totalMinutes);
$parent->save();
}
try {
$err_msg = $this->setRepeatOptions($task_data);
if ($err_msg) {
flash_error($err_msg);
ajx_current("empty");
return;
}
if (!isset($task_data['parent_id'])) {
$task_data['parent_id'] = 0;
}
$member_ids = json_decode(array_var($_POST, 'members'));
$was_template = $task->getIsTemplate();
if(config_option("wysiwyg_tasks")){
$task_data['type_content'] = "html";
$task_data['text'] = preg_replace("/[\n|\r|\n\r]/", '', array_var($task_data, 'text'));
}else{
$task_data['type_content'] = "text";
}
$task->setFromAttributes($task_data);
$task->setIsTemplate($was_template); // is_template value must not be changed from ui
$totalMinutes = (array_var($task_data, 'time_estimate_hours') * 60) + (array_var($task_data, 'time_estimate_minutes'));
$task->setTimeEstimate($totalMinutes);
if ($task->getParentId() > 0 && $task->hasChild($task->getParentId())) {
flash_error(lang('task child of child error'));
ajx_current("empty");
return;
}
if (isset($task_data['percent_completed']) && $task_data['percent_completed'] >= 0 && $task_data['percent_completed'] <= 100) {
$task->setPercentCompleted($task_data['percent_completed']);
}
DB::beginWork();
$task->save();
if (!isset($task_data['percent_completed'])) {
$task->calculatePercentComplete();
}
// dependencies
if (config_option('use tasks dependencies')) {
$previous_tasks = array_var($task_data, 'previous');
if (is_array($previous_tasks)) {
foreach ($previous_tasks as $ptask) {
if ($ptask == $task->getId()) continue;
$dep = ProjectTaskDependencies::findById(array('previous_task_id' => $ptask, 'task_id' => $task->getId()));
if (!$dep instanceof ProjectTaskDependency) {
$dep = new ProjectTaskDependency();
$dep->setPreviousTaskId($ptask);
$dep->setTaskId($task->getId());
$dep->save();
}
}
$saved_ptasks = ProjectTaskDependencies::findAll(array('conditions' => 'task_id = '. $task->getId()));
foreach ($saved_ptasks as $pdep) {
if (!in_array($pdep->getPreviousTaskId(), $previous_tasks)) $pdep->delete();
}
} else {
ProjectTaskDependencies::delete('task_id = '. $task->getId());
}
}
// Add assigned user to the subscibers list
if ($task->getAssignedToContactId() > 0 && Contacts::instance()->findById( $task->getAssignedToContactId()) ) {
if (!isset($_POST['subscribers'])) $_POST['subscribers'] = array();
$_POST['subscribers']['user_'.$task->getAssignedToContactId()] = 'checked';
}
$object_controller = new ObjectController();
$object_controller->add_to_members($task, $member_ids);
$object_controller->add_subscribers($task);
$object_controller->link_to_new_object($task);
$object_controller->add_custom_properties($task);
if ($task->getDueDate()!= null && !$task->isCompleted() && $task->getSubscriberIds() != null){ //to make sure the task has a due date and it is not completed yet, and that it has subscribed people
$old_reminders = ObjectReminders::getByObject($task);
if($old_reminders != null){
$object_controller = new ObjectController();
$object_controller->add_reminders($task); //adding the new reminders, if any
$object_controller->update_reminders($task, $old_reminders); //updating the old ones
}else if ( (user_config_option("add_task_autoreminder") && logged_user()->getId() != $task->getAssignedTo()->getId()) //if the user is going to set up reminders for tasks assigned to its colleagues
|| (user_config_option("add_self_task_autoreminder") && logged_user()->getId() == $task->getAssignedTo()->getId()) //if the user is going to set up reminders for his own tasks
|| $task->getAssignedTo() == null ){ //if there is no asignee, but it still has subscribers
$reminder = new ObjectReminder();
$def = explode(",",user_config_option("reminders_tasks"));
$minutes = $def[2] * $def[1];
$reminder->setMinutesBefore($minutes);
$reminder->setType($def[0]);
$reminder->setContext("due_date");
$reminder->setObject($task);
$reminder->setUserId(0);
$date = $task->getDueDate();
if ($date instanceof DateTimeValue) {
$rdate = new DateTimeValue($date->getTimestamp() - $minutes * 60);
$reminder->setDate($rdate);
}
$reminder->save();
}
}
$task->apply_members_to_subtasks($member_ids, true);
// apply values to subtasks
$assigned_to = $task->getAssignedToContactId();
$subtasks = $task->getAllSubTasks();
$milestone_id = $task->getMilestoneId();
$apply_ms = array_var($task_data, 'apply_milestone_subtasks') == "checked";
$apply_at = array_var($task_data, 'apply_assignee_subtasks', '') == "checked";
foreach ($subtasks as $sub) {
$modified = false;
//if ($apply_at || !($sub->getAssignedToContactId() > 0)) {
if ($apply_at) {
$sub->setAssignedToContactId($assigned_to);
$modified = true;
}
if ($apply_ms) {
$sub->setMilestoneId($milestone_id);
$modified = true;
}
if ($modified) {
$sub->save();
}
//control date parent whit subtask
if($_POST['control_dates'] == "father"){
if ($sub->getStartDate() instanceof DateTimeValue) {
if ($task->getStartDate() instanceof DateTimeValue) {
if($task->getStartDate()->getTimestamp() > $sub->getStartDate()->getTimestamp())
$sub->setStartDate($task->getStartDate());
}
}else{
if ($task->getStartDate() instanceof DateTimeValue)
$sub->setStartDate($task->getStartDate());
}
$sub->setUseStartTime($task->getUseStartTime());
if ($sub->getDueDate() instanceof DateTimeValue) {
if ($task->getDueDate() instanceof DateTimeValue) {
if($task->getDueDate()->getTimestamp() < $sub->getDueDate()->getTimestamp())
$sub->setDueDate($task->getDueDate());
}
}else{
if($task->getDueDate() instanceof DateTimeValue)
$sub->setDueDate($task->getDueDate());
}
$sub->setUseDueTime($task->getUseDueTime());
$sub->save();
}
}
$task->resetIsRead();
$log_info = '';
if($send_edit == true){
$log_info = $task->getAssignedToContactId();
}else if($send_edit == false){
$task->setAssignedBy(logged_user());
$task->save();
}
ApplicationLogs::createLog($task, ApplicationLogs::ACTION_EDIT, false, false, true, $log_info);
if(config_option('repeating_task') == 1){
$opt_rep_day['saturday'] = false;
$opt_rep_day['sunday'] = false;
if(array_var($task_data, 'repeat_saturdays',false)){
$opt_rep_day['saturday'] = true;
}
if(array_var($task_data, 'repeat_sundays',false)){
$opt_rep_day['sunday'] = true;
}
$this->repetitive_task($task, $opt_rep_day);
}
if(isset($_POST['type_related'])){
if($_POST['type_related'] == "all" || $_POST['type_related'] == "news"){
$task_data['members'] = json_decode(array_var($_POST, 'members'));
unset($task_data['due_date']);
unset($task_data['use_due_time']);
unset($task_data['start_date']);
unset($task_data['use_start_time']);
$this->repetitive_tasks_related($task,"edit",$_POST['type_related'],$task_data);
}
}
if(config_option('multi_assignment') && Plugins::instance()->isActivePlugin('crpm')){
if(array_var($task_data, 'multi_assignment_aplly_change') == 'subtask') {
$null = null;
Hook::fire('edit_subtasks', $task, $null);
}
}
DB::commit();
try {
if(array_var($task_data, 'send_notification') == 'checked' && $send_edit == false) {
$new_owner = $task->getAssignedTo();
if($new_owner instanceof Contact) {
Notifier::taskAssigned($task);
} // if
} // if
} catch(Exception $e) {
} // try
flash_success(lang('success edit task list', $task->getObjectName()));
ajx_current("back");
} catch(Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
} // try
} // if
} // edit_task
/**
* Copies related data from an object to another (members, linked_objects, custom_properties, subscribers, reminders and comments)
* @param $object: Original object to copy data
* @param $copy: Object to be modified with the data of the $orignal object
* @param $options: set which type of data will not be copied
*/
function copy_additional_object_data($object, &$copy, $options = array())
{
if (!$object instanceof ContentDataObject || !$copy instanceof ContentDataObject) {
// if not valid objects return
return;
}
$copy_members = !array_var($options, 'dont_copy_members');
$copy_linked_objects = !array_var($options, 'dont_copy_linked_objects');
$copy_custom_properties = !array_var($options, 'dont_copy_custom_properties');
$copy_subscribers = !array_var($options, 'dont_copy_subscribers');
$copy_reminders = !array_var($options, 'dont_copy_reminders');
$copy_comments = !array_var($options, 'dont_copy_comments');
$controller = new ObjectController();
// copy members
if ($copy_members) {
$object_members = $object->getMembers();
$copy->addToMembers($object_members);
Hook::fire('after_add_to_members', $copy, $object_members);
$copy->addToSharingTable();
}
// copy linked objects
if ($copy_linked_objects) {
$copy->copyLinkedObjectsFrom($object);
}
// copy custom properties
if ($copy_custom_properties) {
// custom properties defined in "settings"
$cp_object_type_id = $object->getObjectTypeId();
if ($object instanceof TemplateTask || $object instanceof TemplateMilestone) {
$cp_object_type_id = $copy->getObjectTypeId();
}
$custom_props = CustomProperties::getAllCustomPropertiesByObjectType($cp_object_type_id);
foreach ($custom_props as $c_prop) {
$values = CustomPropertyValues::getCustomPropertyValues($object->getId(), $c_prop->getId());
if (is_array($values)) {
foreach ($values as $val) {
$cp = new CustomPropertyValue();
$cp->setObjectId($copy->getId());
$cp->setCustomPropertyId($val->getCustomPropertyId());
$cp->setValue($val->getValue());
$cp->save();
}
}
}
// object properties (key-value)
$copy->copyCustomPropertiesFrom($object);
}
// copy subscribers
if ($copy_subscribers) {
$subscribers_array = array();
foreach ($object->getSubscriberIds() as $user_id) {
$subscribers_array["user_" . $user_id] = "1";
}
$controller->add_subscribers($copy, $subscribers_array);
}
// copy reminders
if ($copy_reminders) {
$reminders = ObjectReminders::getByObject($object);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $copy->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($copy);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
}
// copy comments
if ($copy_comments) {
foreach ($object->getAllComments() as $com) {
$new_com = new Comment();
$new_com->setAuthorEmail($com->getAuthorEmail());
$new_com->setAuthorName($com->getAuthorName());
$new_com->setAuthorHomepage($com->getAuthorHomepage());
$new_com->setCreatedById($com->getCreatedById());
$new_com->setCreatedOn($com->getCreatedOn());
$new_com->setUpdatedById($com->getUpdatedById());
$new_com->setUpdatedOn($com->getUpdatedOn());
$new_com->setText($com->getText());
$new_com->setRelObjectId($copy->getId());
$new_com->save();
}
}
}
function render_add_reminders($object, $context, $defaults = null, $genid = null, $type_object = '') {
require_javascript('og/Reminders.js');
if(!is_array($defaults)) $defaults = array();
if($type_object == "event"){
$def = explode(",", user_config_option("reminders_events"));
$default_defaults = array(
'type' => array_var($def, 0),
'duration' => array_var($def, 1),
'duration_type' => array_var($def, 2),
'for_subscribers' => true,
);
} else if ($type_object == "task"){
$def = explode(",", user_config_option("reminders_tasks"));
$default_defaults = array(
'type' => array_var($def, 0),
'duration' => array_var($def, 1),
'duration_type' => array_var($def, 2),
'for_subscribers' => true,
);
} else {
$default_defaults = array(
'type' => 'reminder_popup',
'duration' => '15',
'duration_type' => '1',
'for_subscribers' => true,
);
}
foreach ($default_defaults as $k => $v) {
if (!isset($defaults[$k])) $defaults[$k] = $v;
}
if (is_null($genid)) {
$genid = gen_id();
}
$types = ObjectReminderTypes::findAll();
$typecsv = "";
foreach ($types as $type) {
if ($typecsv != "") {
$typecsv .= ",";
}
$typecsv .= '"'.$type->getName().'"';
}
$output = '
<div id="'.$genid.'" class="og-add-reminders">
<a id="'.$genid.'-link" href="#" onclick="og.addReminder(this.parentNode, \''.$context.'\', \''.array_var($defaults, 'type').'\', \''.array_var($defaults, 'duration').'\', \''.array_var($defaults, 'duration_type').'\', \''.array_var($defaults, 'for_subscribers').'\', this);return false;">' . lang("add object reminder") . '</a>
</div>
<script>
og.reminderTypes = ['.$typecsv.'];
</script>
';
if ($object->isNew()) {
$output .= '<script>og.addReminder(document.getElementById("'.$genid.'"), \''.$context.'\', \''.array_var($defaults, 'type').'\', \''.array_var($defaults, 'duration').'\', \''.array_var($defaults, 'duration_type').'\', \''.array_var($defaults, 'for_subscribers').'\', document.getElementById("'.$genid.'-link"));</script>';
} else {
$reminders = ObjectReminders::getAllRemindersByObjectAndUser($object, logged_user(), $context, true);
foreach($reminders as $reminder) {
$mins = $reminder->getMinutesBefore();
if ($mins % 10080 == 0) {
$duration = $mins / 10080;
$duration_type = "10080";
} else if ($mins % 1440 == 0) {
$duration = $mins / 1440;
$duration_type = "1440";
} else if ($mins % 60 == 0) {
$duration = $mins / 60;
$duration_type = "60";
} else {
$duration = $mins;
$duration_type = "1";
}
$type = $reminder->getType();
$forSubscribers = $reminder->getUserId() == 0 ? "true" : "false";
$output .= '<script>og.addReminder(document.getElementById("'.$genid.'"), "'.$context.'", "'.$type.'", "'.$duration.'", "'.$duration_type.'", '.$forSubscribers.', document.getElementById(\''.$genid.'-link\'));</script>';
} // for
}
return $output;
}
function cloneTask($new_st_date = '', $new_due_date = '', $copy_status = false, $copy_repeat_options = true, $parent_subtask = 0)
{
$new_task = new TemplateTask();
if ($parent_subtask != 0) {
$new_task->setParentId($parent_subtask);
} else {
$new_task->setParentId($this->getParentId());
}
$new_task->setObjectName($this->getObjectName());
$new_task->setText($this->getText());
$new_task->setAssignedToContactId($this->getAssignedToContactId());
$new_task->setAssignedOn($this->getAssignedOn());
$new_task->setAssignedById($this->getAssignedById());
$new_task->setTimeEstimate($this->getTimeEstimate());
$new_task->setStartedOn($this->getStartedOn());
$new_task->setStartedById($this->getStartedById());
$new_task->setPriority($this->getPriority());
$new_task->setState($this->getState());
$new_task->setOrder($this->getOrder());
$new_task->setMilestoneId($this->getMilestoneId());
$new_task->setFromTemplateId($this->getFromTemplateId());
$new_task->setUseStartTime($this->getUseStartTime());
$new_task->setUseDueTime($this->getUseDueTime());
$new_task->setTypeContent($this->getTypeContent());
if ($this->getParentId() == 0) {
//if not subtask
if ($this->getOriginalTaskId() == 0) {
$new_task->setOriginalTaskId($this->getObjectId());
} else {
$new_task->setOriginalTaskId($this->getOriginalTaskId());
}
}
if ($this->getDueDate() instanceof DateTimeValue) {
$new_task->setDueDate(new DateTimeValue($this->getDueDate()->getTimestamp()));
}
if ($this->getStartDate() instanceof DateTimeValue) {
$new_task->setStartDate(new DateTimeValue($this->getStartDate()->getTimestamp()));
}
if ($copy_status) {
$new_task->setCompletedById($this->getCompletedById());
$new_task->setCompletedOn($this->getCompletedOn());
}
if ($copy_repeat_options) {
$new_task->setRepeatEnd($this->getRepeatEnd());
$new_task->setRepeatForever($this->getRepeatForever());
$new_task->setRepeatNum($this->getRepeatNum());
$new_task->setRepeatBy($this->getRepeatBy());
$new_task->setRepeatD($this->getRepeatD());
$new_task->setRepeatM($this->getRepeatM());
$new_task->setRepeatY($this->getRepeatY());
}
if ($new_st_date != "") {
if ($new_task->getStartDate() instanceof DateTimeValue) {
$new_task->setStartDate($new_st_date);
}
}
if ($new_due_date != "") {
if ($new_task->getDueDate() instanceof DateTimeValue) {
$new_task->setDueDate($new_due_date);
}
}
$new_task->save();
if (is_array($this->getAllLinkedObjects())) {
foreach ($this->getAllLinkedObjects() as $lo) {
$new_task->linkObject($lo);
}
}
$sub_tasks = $this->getAllSubTasks();
foreach ($sub_tasks as $st) {
$new_dates = $this->getNextRepetitionDatesSubtask($st, $new_task, $new_st_date, $new_due_date);
if ($st->getParentId() == $this->getId()) {
$new_st = $st->cloneTask(array_var($new_dates, 'st'), array_var($new_dates, 'due'), $copy_status, $copy_repeat_options, $new_task->getId());
if ($copy_status) {
$new_st->setCompletedById($st->getCompletedById());
$new_st->setCompletedOn($st->getCompletedOn());
$new_st->save();
}
$new_task->attachTask($new_st);
}
}
foreach ($this->getAllComments() as $com) {
$new_com = new Comment();
$new_com->setAuthorEmail($com->getAuthorEmail());
$new_com->setAuthorName($com->getAuthorName());
$new_com->setAuthorHomepage($com->getAuthorHomepage());
$new_com->setCreatedById($com->getCreatedById());
$new_com->setCreatedOn($com->getCreatedOn());
$new_com->setUpdatedById($com->getUpdatedById());
$new_com->setUpdatedOn($com->getUpdatedOn());
$new_com->setText($com->getText());
$new_com->setRelObjectId($new_task->getId());
$new_com->save();
}
$_POST['subscribers'] = array();
foreach ($this->getSubscribers() as $sub) {
$_POST['subscribers']["user_" . $sub->getId()] = "checked";
}
$obj_controller = new ObjectController();
$obj_controller->add_to_members($new_task, $this->getMemberIds());
$obj_controller->add_subscribers($new_task);
foreach ($this->getCustomProperties() as $prop) {
$new_prop = new ObjectProperty();
$new_prop->setRelObjectId($new_task->getId());
$new_prop->setPropertyName($prop->getPropertyName());
$new_prop->setPropertyValue($prop->getPropertyValue());
$new_prop->save();
}
$custom_props = CustomProperties::getAllCustomPropertiesByObjectType("TemplateTasks");
foreach ($custom_props as $c_prop) {
$values = CustomPropertyValues::getCustomPropertyValues($this->getId(), $c_prop->getId());
if (is_array($values)) {
foreach ($values as $val) {
$cp = new CustomPropertyValue();
$cp->setObjectId($new_task->getId());
$cp->setCustomPropertyId($val->getCustomPropertyId());
$cp->setValue($val->getValue());
$cp->save();
}
}
}
$reminders = ObjectReminders::getByObject($this);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $new_task->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($new_task);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
return $new_task;
}
function instantiate()
{
$selected_members = array();
$id = get_id();
$template = COTemplates::findById($id);
if (!$template instanceof COTemplate) {
flash_error(lang("template dnx"));
ajx_current("empty");
return;
}
$parameters = TemplateParameters::getParametersByTemplate($id);
$parameterValues = array_var($_POST, 'parameterValues');
if (count($parameters) > 0 && !isset($parameterValues)) {
ajx_current("back");
return;
}
if (array_var($_POST, 'members')) {
$selected_members = json_decode(array_var($_POST, 'members'));
} else {
$context = active_context();
foreach ($context as $selection) {
if ($selection instanceof Member) {
$selected_members[] = $selection->getId();
}
}
}
$objects = $template->getObjects();
$controller = new ObjectController();
if (count($selected_members > 0)) {
$selected_members_instances = Members::findAll(array('conditions' => 'id IN (' . implode($selected_members) . ')'));
} else {
$selected_members_instances = array();
}
DB::beginWork();
$active_context = active_context();
foreach ($objects as $object) {
if (!$object instanceof ContentDataObject) {
continue;
}
// copy object
$copy = $object->copy();
if ($copy->columnExists('is_template')) {
$copy->setColumnValue('is_template', false);
}
if ($copy instanceof ProjectTask) {
// don't copy parent task and milestone
$copy->setMilestoneId(0);
$copy->setParentId(0);
}
$copy->save();
/* if (!can_write(logged_user(), $selected_members_instances, $copy->getObjectTypeId()) ) {
flash_error(lang('no context permissions to add', $copy instanceof ProjectTask ? lang("tasks") : ($copy instanceof ProjectMilestone ? lang('milestones') : '')));
DB::rollback();
ajx_current("empty");
return;
}*/
// Copy members from origial object, if it doesn't have then use active context members
/* $template_object_members = $object->getMemberIds();
if (count($template_object_members) == 0) {
$object_member_ids = active_context_members(false);
if (count($object_member_ids) > 0) {
$template_object_members = Members::findAll(array("id" => true, "conditions" => "id IN (".implode(",", $object_member_ids).")"));
}
}*/
/* Set instantiated object members:
* foreach dimension:
* if no member is active then the instantiated object is put in the same members as the original for current dimension
* if a member is selected in current dimension then the instantiated object will be put in that member
*/
$template_object_members = $object->getMembers();
$object_members = array();
foreach ($active_context as $selection) {
if ($selection instanceof Member) {
// member selected
$object_members[] = $selection->getId();
} else {
if ($selection instanceof Dimension) {
// no member selected
foreach ($template_object_members as $tom) {
if ($tom->getDimensionId() == $selection->getId()) {
$object_members[] = $tom->getId();
}
}
}
}
}
$controller->add_to_members($copy, $object_members);
// copy linked objects
$copy->copyLinkedObjectsFrom($object);
// copy subtasks if applicable
if ($copy instanceof ProjectTask) {
ProjectTasks::copySubTasks($object, $copy, false);
foreach ($copy->getOpenSubTasks(false) as $m_task) {
$controller->add_to_members($m_task, $object_members);
}
$manager = $copy->manager();
} else {
if ($copy instanceof ProjectMilestone) {
ProjectMilestones::copyTasks($object, $copy, false);
foreach ($copy->getTasks(false) as $m_task) {
$controller->add_to_members($m_task, $object_members);
}
$manager = $copy->manager();
}
}
// copy custom properties
$copy->copyCustomPropertiesFrom($object);
// set property values as defined in template
$objProp = TemplateObjectProperties::getPropertiesByTemplateObject($id, $object->getId());
foreach ($objProp as $property) {
$propName = $property->getProperty();
$value = $property->getValue();
if ($manager->getColumnType($propName) == DATA_TYPE_STRING || $manager->getColumnType($propName) == DATA_TYPE_INTEGER) {
if (is_array($parameterValues)) {
foreach ($parameterValues as $param => $val) {
if (strpos($value, '{' . $param . '}') !== FALSE) {
$value = str_replace('{' . $param . '}', $val, $value);
}
}
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_DATE || $manager->getColumnType($propName) == DATA_TYPE_DATETIME) {
$operator = '+';
if (strpos($value, '+') === false) {
$operator = '-';
}
$opPos = strpos($value, $operator);
if ($opPos !== false) {
// Is parametric
$dateParam = substr($value, 1, strpos($value, '}') - 1);
$date = $parameterValues[$dateParam];
$dateUnit = substr($value, strlen($value) - 1);
// d, w or m (for days, weeks or months)
if ($dateUnit == 'm') {
$dateUnit = 'M';
// make month unit uppercase to call DateTimeValue::add with correct parameter
}
$dateNum = (int) substr($value, strpos($value, $operator), strlen($value) - 2);
$date = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $date);
$date = new DateTimeValue($date->getTimestamp() - logged_user()->getTimezone() * 3600);
// set date to GMT 0
$value = $date->add($dateUnit, $dateNum);
} else {
$value = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $value);
}
}
}
if ($value != '') {
if (!$copy->setColumnValue($propName, $value)) {
$copy->object->setColumnValue($propName, $value);
}
$copy->save();
}
}
// subscribe assigned to
if ($copy instanceof ProjectTask) {
foreach ($copy->getOpenSubTasks(false) as $m_task) {
if ($m_task->getAssignedTo() instanceof Contact) {
$m_task->subscribeUser($copy->getAssignedTo());
}
}
if ($copy->getAssignedTo() instanceof Contact) {
$copy->subscribeUser($copy->getAssignedTo());
}
} else {
if ($copy instanceof ProjectMilestone) {
foreach ($copy->getTasks(false) as $m_task) {
if ($m_task->getAssignedTo() instanceof Contact) {
$m_task->subscribeUser($copy->getAssignedTo());
}
}
}
}
// copy reminders
$reminders = ObjectReminders::getByObject($object);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $copy->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($copy);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
}
DB::commit();
if (is_array($parameters) && count($parameters) > 0) {
ajx_current("back");
} else {
if (!$choose_ctx) {
ajx_current("back");
} else {
ajx_current("reload");
}
}
}
function cloneEvent($new_st_date, $new_due_date)
{
$new_event = new ProjectEvent();
$new_event->setObjectName($this->getObjectName());
$new_event->setDescription($this->getDescription());
$new_event->setTypeId($this->getTypeId());
if ($this->getDuration() instanceof DateTimeValue) {
$new_event->setDuration(new DateTimeValue($this->getDuration()->getTimestamp()));
}
if ($this->getStart() instanceof DateTimeValue) {
$new_event->setStart(new DateTimeValue($this->getStart()->getTimestamp()));
}
$new_event->setOriginalEventId($this->getObjectId());
$new_event->save();
// set next values for repetetive task
if ($new_event->getStart() instanceof DateTimeValue) {
$new_event->setStart($new_st_date);
}
if ($new_event->getDuration() instanceof DateTimeValue) {
$new_event->setDuration($new_due_date);
}
$invitations = EventInvitations::findByEvent($this->getId());
if ($invitations) {
foreach ($invitations as $invitation) {
$invit = new EventInvitation();
$invit->setEventId($new_event->getId());
$invit->setContactId($invitation->getContactId());
$invit->setInvitationState(logged_user() instanceof Contact && logged_user()->getId() == $invitation->getContactId() ? 1 : 0);
$invit->save();
}
}
$subscriptions = ObjectSubscriptions::findByEvent($this->getId());
if ($subscriptions) {
foreach ($subscriptions as $subscription) {
$subscrip = new ObjectSubscription();
$subscrip->setObjectId($new_event->getId());
$subscrip->setContactId($subscription->getContactId());
$subscrip->save();
}
}
$reminders = ObjectReminders::findByEvent($this->getId());
if ($reminders) {
foreach ($reminders as $reminder) {
$remind = new ObjectReminder();
$remind->setObjectId($new_event->getId());
$remind->setMinutesBefore($reminder->getMinutesBefore());
$remind->setType($reminder->getType());
$remind->setContext($reminder->getContext());
$remind->setUserId(0);
$date = $new_event->getStart();
if ($date instanceof DateTimeValue) {
$rdate = new DateTimeValue($date->getTimestamp() - $reminder->getMinutesBefore() * 60);
$remind->setDate($rdate);
}
$remind->save();
}
}
$member_ids = array();
$context = active_context();
foreach ($context as $selection) {
if ($selection instanceof Member) {
$member_ids[] = $selection->getId();
}
}
$object_controller = new ObjectController();
$object_controller->add_to_members($new_event, $member_ids);
return $new_event;
}
function do_delete()
{
$id = $this->getId();
ContactAddresses::instance()->delete("`contact_id` = {$id}");
ContactImValues::instance()->delete("`contact_id` = {$id}");
ContactEmails::instance()->delete("`contact_id` = {$id}");
ContactTelephones::instance()->delete("`contact_id` = {$id}");
ContactWebpages::instance()->delete("`contact_id` = {$id}");
ContactConfigOptionValues::instance()->delete("`contact_id` = {$id}");
ContactPasswords::instance()->delete("`contact_id` = {$id}");
ObjectSubscriptions::instance()->delete("`contact_id` = {$id}");
ObjectReminders::instance()->delete("`contact_id` = {$id}");
ContactPermissionGroups::instance()->delete("`contact_id` = {$id}");
ContactMemberPermissions::instance()->delete("`permission_group_id` = " . $this->getPermissionGroupId());
ContactDimensionPermissions::instance()->delete("`permission_group_id` = " . $this->getPermissionGroupId());
SystemPermissions::instance()->delete("`permission_group_id` = " . $this->getPermissionGroupId());
TabPanelPermissions::instance()->delete("`permission_group_id` = " . $this->getPermissionGroupId());
$this->delete();
$ret = null;
Hook::fire("after_user_deleted", $this, $ret);
}
function instantiate()
{
$id = get_id();
$template = COTemplates::findById($id);
if (!$template instanceof COTemplate) {
flash_error(lang("template dnx"));
ajx_current("empty");
return;
}
$parameters = TemplateParameters::getParametersByTemplate($id);
$parameterValues = array_var($_POST, 'parameterValues');
if (count($parameters) > 0 && !isset($parameterValues)) {
ajx_current("back");
return;
}
$objects = $template->getObjects();
foreach ($objects as $object) {
if (!$object instanceof ProjectDataObject) {
continue;
}
// copy object
$copy = $object->copy();
if ($copy->columnExists('is_template')) {
$copy->setColumnValue('is_template', false);
}
if ($copy instanceof ProjectTask) {
// don't copy parent task and milestone
$copy->setMilestoneId(0);
$copy->setParentId(0);
}
$copy->save();
$wsId = array_var($_POST, 'project_id', active_or_personal_project()->getId());
// if specified, set workspace
$workspace = Projects::findById($wsId);
if (!$workspace instanceof Project) {
$workspace = active_or_personal_project();
}
$copy->addToWorkspace($workspace);
// add object tags and specified tags
$tags = implode(',', $object->getTagNames());
$copy->setTagsFromCSV($tags . "," . array_var($_POST, 'tags'));
// copy linked objects
$copy->copyLinkedObjectsFrom($object);
// copy subtasks if applicable
if ($copy instanceof ProjectTask) {
ProjectTasks::copySubTasks($object, $copy, false);
$manager = new ProjectTask();
} else {
if ($copy instanceof ProjectMilestone) {
ProjectMilestones::copyTasks($object, $copy, false);
$manager = new ProjectMilestone();
}
}
// copy custom properties
$copy->copyCustomPropertiesFrom($object);
// set property values as defined in template
$objProp = TemplateObjectProperties::getPropertiesByTemplateObject($id, $object->getId());
foreach ($objProp as $property) {
$propName = $property->getProperty();
$value = $property->getValue();
if ($manager->getColumnType($propName) == DATA_TYPE_STRING) {
if (is_array($parameterValues)) {
foreach ($parameterValues as $param => $val) {
$value = str_replace('{' . $param . '}', $val, $value);
}
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_DATE || $manager->getColumnType($propName) == DATA_TYPE_DATETIME) {
$operator = '+';
if (strpos($value, '+') === false) {
$operator = '-';
}
$opPos = strpos($value, $operator);
if ($opPos !== false) {
$dateParam = substr($value, 1, strpos($value, '}') - 1);
$dateUnit = substr($value, strlen($value) - 1);
// d, w or m (for days, weeks or months)
if ($dateUnit == 'm') {
$dateUnit = 'M';
// make month unit uppercase to call DateTimeValue::add with correct parameter
}
$dateNum = (int) substr($value, strpos($value, $operator), strlen($value) - 2);
$date = $parameterValues[$dateParam];
$date = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $date);
$value = $date->add($dateUnit, $dateNum);
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_INTEGER) {
if (is_array($parameterValues)) {
foreach ($parameterValues as $param => $val) {
$value = str_replace('{' . $param . '}', $val, $value);
}
}
}
}
}
if ($value != '') {
$copy->setColumnValue($propName, $value);
$copy->save();
}
}
//copy assigned to company if applicable
if ($copy->getAssignedToUserId() != 0) {
$copy->setAssignedToCompanyId($copy->getAssignedTo()->getCompanyId());
$copy->save();
}
// copy reminders
$reminders = ObjectReminders::getByObject($object);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $copy->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($copy);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
}
if (is_array($parameters) && count($parameters) > 0) {
ajx_current("back");
} else {
ajx_current("reload");
}
}
static function sendQueuedEmails()
{
$date = DateTimeValueLib::now();
$date->add("d", -2);
$emails = QueuedEmails::getQueuedEmails($date);
if (count($emails) <= 0) {
return 0;
}
Env::useLibrary('swift');
$mailer = self::getMailer();
if (!$mailer instanceof Swift_Mailer) {
throw new NotifierConnectionError();
}
// if
$fromSMTP = config_option("mail_transport", self::MAIL_TRANSPORT_MAIL) == self::MAIL_TRANSPORT_SMTP && config_option("smtp_authenticate", false);
$count = 0;
foreach ($emails as $email) {
try {
$body = $email->getBody();
$subject = $email->getSubject();
Hook::fire('notifier_email_body', $body, $body);
Hook::fire('notifier_email_subject', $subject, $subject);
if ($fromSMTP && config_option("smtp_address")) {
$pos = strrpos($email->getFrom(), "<");
if ($pos !== false) {
$sender_name = trim(substr($email->getFrom(), 0, $pos));
} else {
$sender_name = "";
}
$from = array(config_option("smtp_address") => $sender_name);
} else {
$pos = strrpos($email->getFrom(), "<");
if ($pos !== false) {
$sender_name = trim(substr($email->getFrom(), 0, $pos));
$sender_address = str_replace(array("<", ">"), array("", ""), trim(substr($email->getFrom(), $pos, strlen($email->getFrom()) - 1)));
} else {
$sender_name = "";
$sender_address = $email->getFrom();
}
$from = array($sender_address => $sender_name);
}
$message = Swift_Message::newInstance($subject)->setFrom($from)->setBody($body)->setContentType('text/html');
if ($email->columnExists('attachments')) {
$attachments = json_decode($email->getColumnValue('attachments'));
foreach ($attachments as $a) {
// if file does not exists or its size is greater than 20 MB then don't process the atachments
if (!file_exists($a->path) || filesize($a->path) / (1024 * 1024) > 20) {
continue;
}
$attach = Swift_Attachment::fromPath($a->path, $a->type);
$attach->setDisposition($a->disposition);
if ($a->cid) {
$attach->setId($a->cid);
}
if ($a->name) {
$attach->setFilename($a->name);
}
$message->attach($attach);
}
}
$to = prepare_email_addresses(implode(",", explode(";", $email->getTo())));
foreach ($to as $address) {
$message->addTo(array_var($address, 0), array_var($address, 1));
}
$cc = prepare_email_addresses(implode(",", explode(";", $email->getCc())));
foreach ($cc as $address) {
$message->addCc(array_var($address, 0), array_var($address, 1));
}
$bcc = prepare_email_addresses(implode(",", explode(";", $email->getBcc())));
foreach ($bcc as $address) {
$message->addBcc(array_var($address, 0), array_var($address, 1));
}
$result = $mailer->send($message);
if ($result) {
DB::beginWork();
// save notification history after cron sent the email
self::saveNotificationHistory(array('email_object' => $email));
// delte from queued_emails
$email->delete();
DB::commit();
}
$count++;
} catch (Exception $e) {
DB::rollback();
// save log in server
if (defined('EMAIL_ERRORS_LOGDIR') && file_exists(EMAIL_ERRORS_LOGDIR) && is_dir(EMAIL_ERRORS_LOGDIR)) {
$err_msg = ROOT_URL . "\nError sending notification (queued_email_id=" . $email->getId() . ") using account " . print_r($from, 1) . "\n\nError detail:\n" . $e->getMessage() . "\n" . $e->getTraceAsString();
file_put_contents(EMAIL_ERRORS_LOGDIR . basename(ROOT), $err_msg, FILE_APPEND);
}
Logger::log("There has been a problem when sending the Queued emails.\nError Message: " . $e->getMessage() . "\nTrace: " . $e->getTraceAsString());
$msg = $e->getMessage();
if (strpos($msg, 'Failed to authenticate') !== false) {
$from_k = array_keys($from);
$usu = Contacts::getByEmail($from_k[0]);
$rem = ObjectReminders::instance()->findOne(array('conditions' => "context='eauthfail " . $from_k[0] . "'"));
if (!$rem instanceof ObjectReminder && $usu instanceof Contact) {
$reminder = new ObjectReminder();
$reminder->setMinutesBefore(0);
$reminder->setType("reminder_popup");
$reminder->setContext("eauthfail " . $from_k[0]);
$reminder->setObject($usu);
$reminder->setUserId($usu->getId());
$reminder->setDate(DateTimeValueLib::now());
$reminder->save();
}
}
}
}
return $count;
}
function move_event() {
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$event = ProjectEvents::findById(get_id());
if(!$event->canEdit(logged_user())){
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$is_read = $event->getIsRead(logged_user()->getId());
$year = array_var($_GET, 'year', $event->getStart()->getYear());
$month = array_var($_GET, 'month', $event->getStart()->getMonth());
$day = array_var($_GET, 'day', $event->getStart()->getDay());
$hour = array_var($_GET, 'hour', 0);
$min = array_var($_GET, 'min', 0);
if ($hour == -1) $hour = format_date($event->getStart(), 'H', logged_user()->getTimezone() );
if ($min == -1) $min = format_date($event->getStart(), 'i', logged_user()->getTimezone() );
if ($event->isRepetitive()) {
$orig_date = DateTimeValueLib::dateFromFormatAndString('Y-m-d H:i:s', array_var($_GET, 'orig_date'));
$diff = DateTimeValueLib::get_time_difference($orig_date->getTimestamp(), mktime($hour, $min, 0, $month, $day, $year));
$new_start = new DateTimeValue($event->getStart()->getTimestamp());
$new_start->add('d', $diff['days']);
$new_start->add('h', $diff['hours']);
$new_start->add('m', $diff['minutes']);
if ($event->getRepeatH()) {
$event->setRepeatDow(date("w", mktime($hour, $min, 0, $month, $day, $year))+1);
$wnum = 0;
$tmp_day = $new_start->getDay();
while ($tmp_day > 0) {
$tmp_day -= 7;
$wnum++;
}
$event->setRepeatWnum($wnum);
}
} else {
$new_start = new DateTimeValue(mktime($hour, $min, 0, $month, $day, $year) - logged_user()->getTimezone() * 3600);
}
$diff = DateTimeValueLib::get_time_difference($event->getStart()->getTimestamp(), $event->getDuration()->getTimestamp());
$new_duration = new DateTimeValue($new_start->getTimestamp());
$new_duration->add('d', $diff['days']);
$new_duration->add('h', $diff['hours']);
$new_duration->add('m', $diff['minutes']);
// see if we have to reload
$os = format_date($event->getStart(), 'd', logged_user()->getTimezone() );
$od = format_date($event->getDuration(), 'd', logged_user()->getTimezone() );
$ohm = format_date($event->getDuration(), 'H:i', logged_user()->getTimezone() );
$nd = format_date($new_duration, 'd', logged_user()->getTimezone() );
$nhm = format_date($new_duration, 'H:i', logged_user()->getTimezone() );
$different_days = ($os != $od && $ohm != '00:00') || ($day != $nd && $nhm != '00:00');
DB::beginWork();
$event->setStart($new_start->format("Y-m-d H:i:s"));
$event->setDuration($new_duration->format("Y-m-d H:i:s"));
$event->save();
$old_reminders = ObjectReminders::getByObject($event);
if($old_reminders != null){
$object_controller = new ObjectController();
$object_controller->update_reminders($event, $old_reminders); //updating the old ones
}else if(user_config_option("add_event_autoreminder")){
$reminder = new ObjectReminder();
$def = explode(",",user_config_option("reminders_events"));
$minutes = array_var($def, 2) * array_var($def, 1);
$reminder->setMinutesBefore($minutes);
$reminder->setType(array_var($def, 0));
$reminder->setContext("start");
$reminder->setObject($event);
$reminder->setUserId(0);
$date = $event->getStart();
if ($date instanceof DateTimeValue) {
$rdate = new DateTimeValue($date->getTimestamp() - $minutes * 60);
$reminder->setDate($rdate);
}
$reminder->save();
}
if (!$is_read) {
$event->setIsRead(logged_user()->getId(), false);
}
if($event->getSpecialID() != ""){
$this->sync_calendar_extern($event);
}
DB::commit();
ajx_extra_data($this->get_updated_event_data($event));
if ($different_days || $event->isRepetitive()) ajx_current("reload");
else ajx_current("empty");
}
/**
* Return manager instance
*
* @access protected
* @param void
* @return ObjectReminders
*/
function manager()
{
if (!$this->manager instanceof ObjectReminders) {
$this->manager = ObjectReminders::instance();
}
return $this->manager;
}
function cloneTask($copy_status = false)
{
$new_task = new ProjectTask();
$new_task->setParentId($this->getParentId());
$new_task->setTitle($this->getTitle());
$new_task->setText($this->getText());
$new_task->setAssignedToCompanyId($this->getAssignedToCompanyId());
$new_task->setAssignedToUserId($this->getAssignedToUserId());
$new_task->setAssignedOn($this->getAssignedOn());
$new_task->setAssignedById($this->getAssignedById());
$new_task->setTimeEstimate($this->getTimeEstimate());
$new_task->setStartedOn($this->getStartedOn());
$new_task->setStartedById($this->getStartedById());
$new_task->setPriority($this->getPriority());
$new_task->setState($this->getState());
$new_task->setOrder($this->getOrder());
$new_task->setMilestoneId($this->getMilestoneId());
$new_task->setIsPrivate($this->getIsPrivate());
$new_task->setIsTemplate($this->getIsTemplate());
$new_task->setFromTemplateId($this->getFromTemplateId());
if ($this->getDueDate() instanceof DateTimeValue) {
$new_task->setDueDate(new DateTimeValue($this->getDueDate()->getTimestamp()));
}
if ($this->getStartDate() instanceof DateTimeValue) {
$new_task->setStartDate(new DateTimeValue($this->getStartDate()->getTimestamp()));
}
if ($copy_status) {
$new_task->setCompletedById($this->getCompletedById());
$new_task->setCompletedOn($this->getCompletedOn());
}
$new_task->save();
$new_task->setTagsFromCSV(implode(",", $this->getTagNames()));
foreach ($this->getWorkspaces() as $ws) {
$new_task->addToWorkspace($ws);
}
if (is_array($this->getAllLinkedObjects())) {
foreach ($this->getAllLinkedObjects() as $lo) {
$new_task->linkObject($lo);
}
}
$sub_tasks = $this->getAllSubTasks();
foreach ($sub_tasks as $st) {
if ($st->getParentId() == $this->getId()) {
$new_st = $st->cloneTask($copy_status);
if ($copy_status) {
$new_st->setCompletedById($st->getCompletedById());
$new_st->setCompletedOn($st->getCompletedOn());
$new_st->save();
}
$new_task->attachTask($new_st);
}
}
foreach ($this->getAllComments() as $com) {
$new_com = new Comment();
$new_com->setAuthorEmail($com->getAuthorEmail());
$new_com->setAuthorName($com->getAuthorName());
$new_com->setAuthorHomepage($com->getAuthorHomepage());
$new_com->setCreatedById($com->getCreatedById());
$new_com->setCreatedOn($com->getCreatedOn());
$new_com->setUpdatedById($com->getUpdatedById());
$new_com->setUpdatedOn($com->getUpdatedOn());
$new_com->setIsAnonymous($com->getIsAnonymous());
$new_com->setIsPrivate($com->getIsPrivate());
$new_com->setText($com->getText());
$new_com->setRelObjectId($new_task->getId());
$new_com->setRelObjectManager("ProjectTasks");
$new_com->save();
}
$_POST['subscribers'] = array();
foreach ($this->getSubscribers() as $sub) {
$_POST['subscribers']["user_" . $sub->getId()] = "checked";
}
$obj_controller = new ObjectController();
$obj_controller->add_subscribers($new_task);
foreach ($this->getCustomProperties() as $prop) {
$new_prop = new ObjectProperty();
$new_prop->setRelObjectId($new_task->getId());
$new_prop->setRelObjectManager($prop->getRelObjectManager());
$new_prop->setPropertyName($prop->getPropertyName());
$new_prop->setPropertyValue($prop->getPropertyValue());
$new_prop->save();
}
$custom_props = CustomProperties::getAllCustomPropertiesByObjectType("ProjectTasks");
foreach ($custom_props as $c_prop) {
$values = CustomPropertyValues::getCustomPropertyValues($this->getId(), $c_prop->getId());
if (is_array($values)) {
foreach ($values as $val) {
$cp = new CustomPropertyValue();
$cp->setObjectId($new_task->getId());
$cp->setCustomPropertyId($val->getCustomPropertyId());
$cp->setValue($val->getValue());
$cp->save();
}
}
}
$reminders = ObjectReminders::getByObject($this);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $new_task->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($new_task);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
return $new_task;
}