function apply_members_to_subtasks($member_ids, $recursive = false) {
$object_controller = new ObjectController();
foreach ($this->getSubTasks() as $subtask) {
$object_controller->add_to_members($subtask, $member_ids);
if ($recursive) {
$subtask->apply_members_to_subtasks($member_ids, $recursive);
}
}
}
function core_dim_add_new_contact_to_person_dimension($object)
{
/* @var $object Contact */
$person_ot = ObjectTypes::findOne(array("conditions" => "`name` = 'person'"));
$company_ot = ObjectTypes::findOne(array("conditions" => "`name` = 'company'"));
$person_dim = Dimensions::findOne(array("conditions" => "`code` = 'feng_persons'"));
if ($person_ot instanceof ObjectType && $person_dim instanceof Dimension) {
$oid = $object->isCompany() ? $company_ot->getId() : $person_ot->getId();
$tmp_mem = Members::findOne(array("conditions" => "`dimension_id` = " . $person_dim->getId() . " AND `object_type_id` = {$oid} AND `object_id` = " . $object->getId()));
$reload_dimension = true;
if ($tmp_mem instanceof Member) {
$member = $tmp_mem;
$reload_dimension = false;
} else {
$member = new Member();
$member->setName($object->getObjectName());
$member->setDimensionId($person_dim->getId());
$parent_member_id = 0;
$depth = 1;
if ($object->isCompany()) {
$member->setObjectTypeId($company_ot->getId());
} else {
$member->setObjectTypeId($person_ot->getId());
if ($object->getCompanyId() > 0) {
$pmember = Members::findOne(array('conditions' => '`object_id` = ' . $object->getCompanyId() . ' AND `object_type_id` = ' . $company_ot->getId() . ' AND `dimension_id` = ' . $person_dim->getId()));
if ($pmember instanceof Member) {
$parent_member_id = $pmember->getId();
$depth = $pmember->getDepth() + 1;
}
}
}
$member->setParentMemberId($parent_member_id);
$member->setDepth($depth);
$member->setObjectId($object->getId());
$member->save();
}
$sql = "INSERT INTO `" . TABLE_PREFIX . "contact_dimension_permissions` (`permission_group_id`, `dimension_id`, `permission_type`)\n\t\t\t\t SELECT `c`.`permission_group_id`, " . $person_dim->getId() . ", 'check'\n\t\t\t\t FROM `" . TABLE_PREFIX . "contacts` `c` \n\t\t\t\t WHERE `c`.`is_company`=0 AND `c`.`user_type`!=0 AND `c`.`disabled`=0 AND `c`.`object_id`=" . $object->getId() . "\n\t\t\t\t ON DUPLICATE KEY UPDATE `dimension_id`=`dimension_id`;";
DB::execute($sql);
$sql = "INSERT INTO `" . TABLE_PREFIX . "contact_member_permissions` (`permission_group_id`, `member_id`, `object_type_id`, `can_write`, `can_delete`)\n\t\t\t\t SELECT `c`.`permission_group_id`, " . $member->getId() . ", `ot`.`id`, (`c`.`object_id` = " . $object->getId() . ") as `can_write`, (`c`.`object_id` = " . $object->getId() . ") as `can_delete`\n\t\t\t\t FROM `" . TABLE_PREFIX . "contacts` `c` JOIN `" . TABLE_PREFIX . "object_types` `ot` \n\t\t\t\t WHERE `c`.`is_company`=0 AND `c`.`object_id`=" . $object->getId() . "\n\t\t\t\t \tAND `c`.`user_type`!=0 AND `c`.`disabled`=0\n\t\t\t\t\tAND `ot`.`type` IN ('content_object', 'comment')\n\t\t\t\t ON DUPLICATE KEY UPDATE `member_id`=`member_id`;";
DB::execute($sql);
DB::execute("DELETE FROM `" . TABLE_PREFIX . "contact_member_permissions` WHERE `permission_group_id` = 0;");
// NEW! Add contact to its own member to be searchable
if (logged_user() instanceof Contact) {
$ctrl = new ObjectController();
$ctrl->add_to_members($object, array($member->getId()));
} else {
$object->addToMembers(array($member));
$object->addToSharingTable();
}
// add permission to creator
if ($object->getCreatedBy() instanceof Contact) {
DB::execute("INSERT INTO `" . TABLE_PREFIX . "contact_member_permissions` (`permission_group_id`, `member_id`, `object_type_id`, `can_write`, `can_delete`)\n\t\t\t\t SELECT " . $object->getCreatedBy()->getPermissionGroupId() . ", " . $member->getId() . ", `ot`.`id`, 1, 1\n\t\t\t\t FROM `" . TABLE_PREFIX . "object_types` `ot` \n\t\t\t\t WHERE `ot`.`type` IN ('content_object', 'comment')\n\t\t\t\t ON DUPLICATE KEY UPDATE `member_id`=`member_id`;");
}
if ($reload_dimension) {
evt_add("reload dimension tree", $member->getDimensionId());
}
}
}
/**
* Copies tasks from milestoneFrom to milestoneTo.
*
* @param ProjectMilestone $milestoneFrom
* @param ProjectMilestone $milestoneTo
*/
function copyTasks(ProjectMilestone $milestoneFrom, ProjectMilestone $milestoneTo, $as_template = false)
{
//FIXME
foreach ($milestoneFrom->getTasks($as_template) as $sub) {
if ($sub->getParentId() != 0) {
continue;
}
$new = ProjectTasks::createTaskCopy($sub);
$new->setMilestoneId($milestoneTo->getId());
$new->save();
$object_controller = new ObjectController();
$members = $milestoneFrom->getMemberIds();
if (count($members)) {
$object_controller->add_to_members($new, $members);
}
/*
foreach ($sub->getWorkspaces() as $workspace) {
if (ProjectTask::canAdd(logged_user(), $workspace)) {
$new->addToWorkspace($workspace);
}
}
if (!$as_template && active_project() instanceof Project && ProjectTask::canAdd(logged_user(), active_project())) {
$new->removeFromAllWorkspaces();
$new->addToWorkspace(active_project());
}
*/
$new->copyCustomPropertiesFrom($sub);
$new->copyLinkedObjectsFrom($sub);
ProjectTasks::copySubTasks($sub, $new, $as_template);
}
}
/**
* Edit specific message
*
* @access public
* @param void
* @return null
*/
function edit()
{
$this->setTemplate('add_message');
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current('empty');
return;
}
$message = ProjectMessages::findById(get_id());
if (!$message instanceof ProjectMessage) {
flash_error(lang('message dnx'));
ajx_current("empty");
return;
}
// if
if (!$message->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
$message_data = array_var($_POST, 'message');
if (!is_array($message_data)) {
$message_data = array('name' => $message->getObjectName(), 'text' => $message->getText(), 'type_content' => $message->getTypeContent());
// set layout for modal form
if (array_var($_REQUEST, 'modal')) {
$this->setLayout("json");
tpl_assign('modal', true);
}
}
// if
tpl_assign('message', $message);
tpl_assign('message_data', $message_data);
if (is_array(array_var($_POST, 'message'))) {
foreach ($message_data as $k => &$v) {
$v = remove_scripts($v);
}
try {
//MANAGE CONCURRENCE WHILE EDITING
/* FIXME or REMOVEME
$upd = array_var($_POST, 'updatedon');
if ($upd && $message->getUpdatedOn()->getTimestamp() > $upd && !array_var($_POST,'merge-changes') == 'true')
{
ajx_current('empty');
evt_add("handle edit concurrence", array(
"updatedon" => $message->getUpdatedOn()->getTimestamp(),
"genid" => array_var($_POST,'genid')
));
return;
}
if (array_var($_POST,'merge-changes') == 'true')
{
$this->setTemplate('view');
$edited_note = ProjectMessages::findById($message->getId());
tpl_assign('message', $edited_note);
tpl_assign('subscribers', $edited_note->getSubscribers());
ajx_extra_data(array("name" => $edited_note->getObjectName(), 'icon'=>'ico-message'));
ajx_set_no_toolbar(true);
ajx_set_panel(lang ('tab name',array('name'=>$edited_note->getObjectName())));
return;
}
*/
if (config_option("wysiwyg_messages")) {
$message_data['type_content'] = "html";
$message_data['text'] = preg_replace("/[\n|\r|\n\r]/", '', array_var($message_data, 'text'));
} else {
$message_data['type_content'] = "text";
}
$message->setFromAttributes($message_data);
DB::beginWork();
$message->save();
$object_controller = new ObjectController();
$member_ids = json_decode(array_var($_POST, 'members'));
$object_controller->add_to_members($message, $member_ids);
$object_controller->link_to_new_object($message);
$object_controller->add_subscribers($message);
$object_controller->add_custom_properties($message);
$message->resetIsRead();
DB::commit();
ApplicationLogs::createLog($message, ApplicationLogs::ACTION_EDIT);
flash_success(lang('success edit message', $message->getObjectName()));
if (array_var($_POST, 'popup', false)) {
ajx_current("reload");
} else {
ajx_current("back");
}
if (array_var($_REQUEST, 'modal')) {
evt_add("reload current panel");
}
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
// try
}
// if
}
/**
* Copies subtasks from taskFrom to taskTo.
*
* @param ProjectTask $taskFrom
* @param ProjectTask $taskTo
*/
function copySubTasks(ProjectTask $taskFrom, ProjectTask $taskTo, $as_template = false) {
foreach ( $taskFrom->getSubTasks () as $sub ) {
if ($sub->getId() == $taskTo->getId()) continue;
$new = ProjectTasks::createTaskCopy ( $sub );
$new->setIsTemplate ( $as_template );
$new->setParentId ( $taskTo->getId () );
$new->setMilestoneId ( $taskTo->getMilestoneId () );
$new->setOrder ( ProjectTasks::maxOrder ( $new->getParentId (), $new->getMilestoneId () ) );
if ($sub->getIsTemplate ()) {
$new->setFromTemplateId ( $sub->getId () );
}
$new->save ();
$object_controller = new ObjectController();
if (count($taskFrom->getMemberIds())) {
$object_controller->add_to_members($new, $taskFrom->getMemberIds());
}
$new->copyCustomPropertiesFrom ( $sub );
$new->copyLinkedObjectsFrom ( $sub );
ProjectTasks::copySubTasks ( $sub, $new, $as_template );
}
}
function instantiate($arguments = null)
{
$selected_members = array();
$id = array_var($arguments, '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($arguments, 'parameterValues', array_var($_POST, 'parameterValues'));
if (count($parameters) > 0 && !isset($parameterValues)) {
ajx_current("back");
return;
}
$instantiation_id = 0;
if (count($parameters) > 0) {
$instantiation_id = $this->save_instantiated_parameters($template, $parameters, $parameterValues);
}
if (array_var($_POST, 'members') || array_var($arguments, 'members')) {
$selected_members = array_var($arguments, 'members', json_decode(array_var($_POST, 'members')));
} else {
$context = active_context();
foreach ($context as $selection) {
if ($selection instanceof Member) {
$selected_members[] = $selection->getId();
}
}
}
if (array_var($_POST, 'additional_member_ids')) {
$add_mem_ids = explode(',', array_var($_POST, 'additional_member_ids'));
if (is_array($add_mem_ids)) {
foreach ($add_mem_ids as $add_mem_id) {
if (is_numeric($add_mem_id)) {
$selected_members[] = $add_mem_id;
}
}
}
}
$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();
$copies = array();
$copiesIds = array();
$dependencies = array();
Hook::fire("verify_objects_before_template_instantiation", $template, $objects);
foreach ($objects as $object) {
if (!$object instanceof ContentDataObject) {
continue;
}
// copy object
if ($object instanceof TemplateTask) {
//dependencies
$ptasks = ProjectTaskDependencies::getDependenciesForTemplateTask($object->getId());
if (!empty($ptasks)) {
foreach ($ptasks as $d) {
$dependencies[] = $d;
}
}
$copy = $object->copyToProjectTask($instantiation_id);
//if is subtask
if ($copy->getParentId() > 0) {
foreach ($copies as $c) {
if ($c instanceof ProjectTask) {
if ($c->getFromTemplateObjectId() == $object->getParentId()) {
$copy->setParentId($c->getId());
}
}
}
}
} else {
if ($object instanceof TemplateMilestone) {
$copy = $object->copyToProjectMilestone();
} else {
$copy = $object->copy(false);
if ($copy->columnExists('from_template_id')) {
$copy->setColumnValue('from_template_id', $object->getId());
}
}
}
if ($copy->columnExists('is_template')) {
$copy->setColumnValue('is_template', false);
}
$copy->save();
$copies[] = $copy;
$copiesIds[$object->getId()] = $copy->getId();
$ret = null;
Hook::fire('after_template_object_instantiation', array('template' => $template, 'original' => $object, 'copy' => $copy), $ret);
/* Set instantiated object members:
* if no member is active then the instantiated object is put in the same members as the original
* if any members are selected then the instantiated object will be put in those members
*/
$template_object_members = $object->getMembers();
$object_members = array();
if (count($selected_members) == 0) {
//change members according to context
foreach ($active_context as $selection) {
if ($selection instanceof Member) {
// member selected
foreach ($template_object_members as $i => $object_member) {
if ($object_member instanceof Member && $object_member->getObjectTypeId() == $selection->getObjectTypeId()) {
unset($template_object_members[$i]);
}
}
$object_members[] = $selection->getId();
}
}
} else {
$object_members = $selected_members;
}
foreach ($template_object_members as $object_member) {
$object_members[] = $object_member->getId();
}
$controller->add_to_members($copy, $object_members);
// set property values as defined in template
instantiate_template_task_parameters($object, $copy, $parameterValues);
// subscribe assigned to
if ($copy instanceof ProjectTask) {
foreach ($copy->getOpenSubTasks(false) as $m_task) {
if ($m_task->getAssignedTo() instanceof Contact) {
$m_task->subscribeUser($m_task->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($m_task->getAssignedTo());
}
}
}
}
}
foreach ($copies as $c) {
if ($c instanceof ProjectTask) {
if ($c->getMilestoneId() > 0) {
// find milestone in copies
foreach ($copies as $m) {
if ($m instanceof ProjectMilestone && $m->getFromTemplateObjectId() == $c->getMilestoneId()) {
$c->setMilestoneId($m->getId());
$c->save();
break;
}
}
}
}
}
//copy dependencies
foreach ($dependencies as $dependencie) {
if ($dependencie instanceof ProjectTaskDependency) {
$dep = new ProjectTaskDependency();
$dep->setPreviousTaskId($copiesIds[$dependencie->getPreviousTaskId()]);
$dep->setTaskId($copiesIds[$dependencie->getTaskId()]);
$dep->save();
}
}
DB::commit();
foreach ($copies as $c) {
if ($c instanceof ProjectTask) {
ApplicationLogs::createLog($c, ApplicationLogs::ACTION_ADD);
}
}
if (is_array($parameters) && count($parameters) > 0) {
ajx_current("back");
} else {
ajx_current("back");
}
}
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");
}
}
}
/**
* @param $email MailContent to classify
* @param $members array of member ids in which the $email will be classified
* @param $classification_data additional data needed for classification
* @param $process_conversation boolean, if true all the conversation will be classified
* @param $after_receiving boolean, indicates wheather the function was called after receiving the email or if only the user is classiffying the email
*/
function do_classify_mail($email, $members, $classification_data = null, $process_conversation = true, $after_receiving = false)
{
try {
$ctrl = new ObjectController();
$create_task = false;
//array_var($classification_data, 'create_task') == 'checked';
if (is_null($classification_data)) {
$classification_data = array();
MailUtilities::parseMail($email->getContent(), $decoded, $parsedEmail, $warnings);
for ($j = 0; $j < count(array_var($parsedEmail, "Attachments", array())); $j++) {
$classification_data["att_" . $j] = true;
}
}
foreach ($members as $k => &$mem_id) {
if ($mem_id == "") {
unset($members[$k]);
}
}
$canWriteFiles = $this->checkFileWritability($classification_data, $parsedEmail);
if ($canWriteFiles) {
// if $after_receiving == true transaction has already been started, so dont start a new one
if (!$after_receiving) {
DB::beginWork();
}
if (count($members) > 0) {
$account_owner = logged_user() instanceof contact ? logged_user() : Contacts::findById($email->getAccount()->getContactId());
$ctrl->add_to_members($email, $members, $account_owner);
if ($after_receiving && $email->getHasAttachments() && user_config_option('auto_classify_attachments') || !$after_receiving && $email->getHasAttachments() && (user_config_option('mail_drag_drop_prompt') == 'classify' || user_config_option('mail_drag_drop_prompt') == 'prompt' && intval(array_var($_REQUEST, 'classify_attachments')) > 0)) {
if (count($members) > 0) {
$member_instances = Members::findAll(array('conditions' => 'id IN (' . implode(',', $members) . ')'));
MailUtilities::parseMail($email->getContent(), $decoded, $parsedEmail, $warnings);
$this->classifyFile($classification_data, $email, $parsedEmail, $member_instances, false, !$after_receiving);
}
}
} else {
$email->removeFromMembers(logged_user() instanceof contact ? logged_user() : Contacts::findById($email->getAccount()->getContactId(), $email->getMembers()));
}
if ($process_conversation) {
$conversation = MailContents::getMailsFromConversation($email);
if (count($members) > 0) {
$member_instances = Members::findAll(array('conditions' => 'id IN (' . implode(',', $members) . ')'));
foreach ($conversation as $conv_email) {
// dont process orignal email again
if ($conv_email->getId() == $email->getId()) {
continue;
}
$account_owner = logged_user() instanceof contact ? logged_user() : Contacts::findById($conv_email->getAccount()->getContactId());
$ctrl->add_to_members($conv_email, $members, $account_owner);
MailUtilities::parseMail($conv_email->getContent(), $decoded, $parsedEmail, $warnings);
if ($conv_email->getHasAttachments()) {
if ($after_receiving && user_config_option('auto_classify_attachments') || !$after_receiving && (user_config_option('mail_drag_drop_prompt') == 'classify' || user_config_option('mail_drag_drop_prompt') == 'prompt' && intval(array_var($_REQUEST, 'classify_attachments')) > 0)) {
$this->classifyFile($classification_data, $conv_email, $parsedEmail, $member_instances, false, !$after_receiving);
}
}
}
} else {
if (!$after_receiving) {
foreach ($conversation as $conv_email) {
$conv_email->removeFromMembers(logged_user() instanceof contact ? logged_user() : Contacts::findById($email->getAccount()->getContactId(), $conv_email->getMembers()));
}
}
}
}
if (!$after_receiving) {
DB::commit();
}
flash_success(lang('success classify email'));
if ($create_task) {
ajx_replace(true);
$this->redirectTo('task', 'add_task', array('from_email' => $email->getId(), 'replace' => 1));
} else {
ajx_current("back");
if (!$after_receiving) {
evt_add("reload current panel", array());
}
}
} else {
flash_error(lang("error classifying attachment cant open file"));
ajx_current("empty");
}
// If can write files
// Error...
} catch (Exception $e) {
if (!$after_receiving) {
DB::rollback();
}
flash_error($e->getMessage());
ajx_current("empty");
}
}
function import_google_calendar_for_user($user)
{
if ($user instanceof ExternalCalendarUser) {
$calendars = ExternalCalendars::findByExtCalUserId($user->getId());
$service = $this->connect_with_google_calendar($user);
$contact = Contacts::findById($user->getContactId());
try {
//update or insert events for calendars
foreach ($calendars as $calendar) {
if ($calendar->getSync() == 0) {
continue;
}
$optParams = array();
$syncToken = $calendar->getExternalCalendarPropertyValue("syncToken");
//if syncToken is not present we have to make a full sync
if ($syncToken) {
//incremental sync get events created or updated from las check
$optParams['syncToken'] = $syncToken;
} else {
//full sync get events starting from past 2 weeks
$previous_week = strtotime("-2 week");
$time_min = date(DATE_RFC3339, $previous_week);
$optParams['timeMin'] = $time_min;
}
//Try to get events for this calendar
try {
$events = $service->events->listEvents($calendar->getOriginalCalendarId(), $optParams);
} catch (Exception $e) {
Logger::log("Fail to get events from external calendar: " . $calendar->getId());
Logger::log($e->getMessage());
//remove the syncToken for this calendar so the next time we do a full sync
$syncTokenProp = $calendar->getExternalCalendarProperty("syncToken");
if ($syncTokenProp) {
$syncTokenProp->delete();
}
//go to the next calendar
continue;
}
//Working with events
while (true) {
foreach ($events->getItems() as $event) {
//check if is a cancelled event
if ($event->getStatus() == "cancelled") {
$cancelled_event = ProjectEvents::findBySpecialId($event->getId(), $calendar->getId());
//delete ProjectEvent
if ($cancelled_event instanceof ProjectEvent) {
$cancelled_event->delete();
}
continue;
}
//check if is a recurrent event
if (is_array($event->getRecurrence())) {
continue;
}
//check if is a recurrent event instance
if (!is_null($event->getRecurringEventId()) && $event->getRecurringEventId() != '') {
continue;
}
//get all the data that we need from google event
$event_id = $event->getId();
$event_name = $event->getSummary();
$event_desc = $event->getDescription();
$event_start_date = ExternalCalendarController::date_google_to_sql($event->getStart());
$event_end_date = ExternalCalendarController::date_google_to_sql($event->getEnd());
$event_type = 1;
if ($event->getStart()->getDate()) {
$event_type = 2;
//set this times because we have a bug with all day events times
$event_start_date = DateTimeValueLib::dateFromFormatAndString(DATE_MYSQL, $event_start_date);
$event_start_date->advance(12 * 3600);
$event_start_date = $event_start_date->toMySQL();
$event_end_date = DateTimeValueLib::dateFromFormatAndString(DATE_MYSQL, $event_start_date);
$event_end_date->advance(1 * 3600);
$event_end_date = $event_end_date->toMySQL();
}
$event_updated_date = EMPTY_DATETIME;
if (!is_null($event->getUpdated()) && $event->getUpdated() != '') {
$event_updated_date_str = strtotime($event->getUpdated());
$event_updated_date = date(DATE_MYSQL, $event_updated_date_str);
}
//Save event
try {
DB::beginWork();
//if event exist update it
$new_event = ProjectEvents::findBySpecialId($event_id, $calendar->getId());
if (!$new_event instanceof ProjectEvent) {
//Create ProjectEvent from google event
$new_event = new ProjectEvent();
}
$new_event->setSpecialID($event_id);
$new_event->setStart($event_start_date);
$new_event->setDuration($event_end_date);
$new_event->setTypeId($event_type);
$new_event->setObjectName($event_name);
$new_event->setDescription($event_desc);
$new_event->setUpdateSync($event_updated_date);
$new_event->setExtCalId($calendar->getId());
$new_event->save();
//Invitation insert only if not exists
$conditions = array('event_id' => $new_event->getId(), 'contact_id' => $user->getContactId());
if (EventInvitations::findById($conditions) == null) {
$invitation = new EventInvitation();
$invitation->setEventId($new_event->getId());
$invitation->setContactId($user->getContactId());
$invitation->setInvitationState(1);
$invitation->setUpdateSync();
$invitation->setSpecialId($event_id);
$invitation->save();
}
//Subscription insert only if not exists
if (ObjectSubscriptions::findBySubscriptions($new_event->getId(), $contact) == null) {
$subscription = new ObjectSubscription();
$subscription->setObjectId($new_event->getId());
$subscription->setContactId($user->getContactId());
$subscription->save();
}
$member = array();
if ($calendar->getRelatedTo()) {
$member_ids = explode(",", $calendar->getRelatedTo());
foreach ($member_ids as $member_id) {
$member[] = $member_id;
}
}
$object_controller = new ObjectController();
$object_controller->add_to_members($new_event, $member, $contact);
DB::commit();
} catch (Exception $e) {
DB::rollback();
Logger::log("Fail to save event for external calendar user: "******"syncToken", $nextSyncToken);
}
break;
}
}
}
//foreach calendars
} catch (Exception $e) {
Logger::log("Fail to get events for external calendar user: " . $user->getId());
Logger::log($e->getMessage());
}
}
}
function classifyFile($classification_data, $email, $parsedEmail, $members, $remove_prev) {
if (!is_array($classification_data)) $classification_data = array();
if (!isset($parsedEmail["Attachments"])) {
return;
//throw new Exception(lang('no attachments found for email'));
}
$account_owner = logged_user() instanceof contact ? logged_user() : Contacts::findById($email->getAccount()->getContactId());
for ($c = 0; $c < count($classification_data); $c++) {
if (isset($classification_data["att_".$c]) && $classification_data["att_".$c]) {
$att = $parsedEmail["Attachments"][$c];
$fName = str_starts_with($att["FileName"], "=?") ? iconv_mime_decode($att["FileName"], 0, "UTF-8") : utf8_safe($att["FileName"]);
if (trim($fName) == "" && strlen($att["FileName"]) > 0) $fName = utf8_encode($att["FileName"]);
$extension = get_file_extension(basename($fName));
$type_file_allow = FileTypes::getByExtension($extension);
if(!($type_file_allow instanceof FileType) || $type_file_allow->getIsAllow() == 1){
try {
//$sql = "SELECT o.id FROM ".TABLE_PREFIX."objects o,".TABLE_PREFIX."project_files f WHERE o.id = f.object_id AND f.mail_id = ".$email->getId()." AND o.name = ".DB::escape($fName)."";
$sql = "SELECT o.id FROM ".TABLE_PREFIX."objects o,".TABLE_PREFIX."project_files f WHERE o.id = f.object_id AND o.name = ".DB::escape($fName)."";
$db_res = DB::execute($sql);
$row = $db_res->fetchRow();
$file = ProjectFiles::findById($row['id']);
DB::beginWork();
if ($file == null){
$fileIsNew = true;
$file = new ProjectFile();
$file->setFilename($fName);
$file->setIsVisible(true);
$file->setMailId($email->getId());
$file->save();
$object_controller = new ObjectController();
$object_controller->add_to_members($file, array(), $account_owner);
} else {
$fileIsNew = false;
}
if($remove_prev){
$dim_ids = array(0);
foreach ($members as $m) $dim_ids[$m->getDimensionId()] = $m->getDimensionId();
ObjectMembers::delete('`object_id` = ' . $file->getId() . ' AND `member_id` IN (SELECT `m`.`id` FROM `'.TABLE_PREFIX.'members` `m` WHERE `m`.`dimension_id` IN ('.implode(',',$dim_ids).'))');
}
$file->addToMembers($members);
$file->addToSharingTable();
$enc = array_var($parsedMail,'Encoding','UTF-8');
$ext = utf8_substr($fName, strrpos($fName, '.') + 1, utf8_strlen($fName, $enc), $enc);
$mime_type = '';
if (Mime_Types::instance()->has_type($att["content-type"])) {
$mime_type = $att["content-type"]; //mime type is listed & valid
} else {
$mime_type = Mime_Types::instance()->get_type($ext); //Attempt to infer mime type
}
$userid = logged_user() ? logged_user()->getId() : "0";
$tempFileName = ROOT ."/tmp/". $userid ."x". gen_id();
$fh = fopen($tempFileName, 'w') or die("Can't open file");
fwrite($fh, $att["Data"]);
fclose($fh);
$fileToSave = array(
"name" => $fName,
"type" => $mime_type,
"tmp_name" => $tempFileName,
"error" => 0,
"size" => filesize($tempFileName)
);
if ($fileIsNew) {
$revision = $file->handleUploadedFile($fileToSave, true, lang('attachment from email', $email->getSubject())); // handle uploaded file
ApplicationLogs::createLog($file, ApplicationLogs::ACTION_ADD);
}else{
$revision = $file->getLastRevision();
$new_hash = hash_file("sha256", $tempFileName);
if ($revision->getHash() != $new_hash) {
$revision = $file->handleUploadedFile($fileToSave, true, lang('attachment from email', $email->getSubject())); // handle uploaded file
ApplicationLogs::createLog($file, ApplicationLogs::ACTION_ADD);
}
}
DB::commit();
// Error...
} catch(Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
}else{
flash_error(lang('file extension no allow classify', $fName));
}
if (isset($tempFileName) && is_file($tempFileName)) unlink($tempFileName);
}
}
}
function addTimeslot(Contact $user)
{
if ($this->hasOpenTimeslots($user)) {
throw new Error("Cannot add timeslot: user already has an open timeslot");
}
$timeslot = new Timeslot();
$dt = DateTimeValueLib::now();
$timeslot->setStartTime($dt);
$timeslot->setContactId($user->getId());
$timeslot->setRelObjectId($this->getObjectId());
$timeslot->save();
$object_controller = new ObjectController();
$object_controller->add_to_members($timeslot, $this->getMemberIds());
}
$sql = "";
$first_row = true;
$cant = 0;
$count = 0;
$processed_objects = array();
$user = Contacts::findOne(array("conditions"=>"user_type = (SELECT id FROM ".TABLE_PREFIX."permission_groups WHERE name='Super Administrator')"));
$object_controller = new ObjectController();
$objects = Objects::findAll(array('id'=>true, "conditions" => "id NOT IN(SELECT object_id FROM ".TABLE_PREFIX."processed_objects)", "order" => "id DESC", "limit" => OBJECT_COUNT));
foreach ($objects as $obj) {
$cobj = Objects::findObject($obj);
if ($cobj instanceof ContentDataObject) {
$object_controller->add_to_members($cobj, $cobj->getMemberIds(), $user);
$cobj->addToSearchableObjects(true);
// add mails to sharing table for account owners
if ($cobj instanceof MailContent && $cobj->getAccount() instanceof MailAccount) {
$db_result = DB::execute("SELECT contact_id FROM ".TABLE_PREFIX."mail_account_contacts WHERE account_id = ".$cobj->getAccountId());
$macs = $db_result->fetchAll();
if ($macs && is_array($macs) && count($macs) > 0) {
$pgs = array();
foreach ($macs as $mac) {
$contact_id = $mac['contact_id'];
$mac_pgs = DB::executeAll("SELECT permission_group_id FROM ".TABLE_PREFIX."contacts WHERE object_id=$contact_id");
foreach ($mac_pgs as $mac_pg) $pgs[$mac_pg['permission_group_id']] = $mac_pg['permission_group_id'];
}
if ($sql == "" && count($pgs) > 0) $sql = "INSERT INTO ".TABLE_PREFIX."sharing_table (group_id, object_id) VALUES ";
foreach ($pgs as $pgid) {
/**
* Classify specific email
*
*/
function classify()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$email = MailContents::findById(get_id());
if (!$email instanceof MailContent) {
flash_error(lang('email dnx'));
ajx_current("empty");
return;
}
if ($email->getIsDeleted()) {
flash_error(lang('email dnx deleted'));
ajx_current("empty");
return;
}
if (!$email->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
MailUtilities::parseMail($email->getContent(), $decoded, $parsedEmail, $warnings);
if (array_var($_POST, 'submit')) {
try {
$ctrl = new ObjectController();
$create_task = array_var($classification_data, 'create_task') == 'checked';
$canWriteFiles = $this->checkFileWritability($classification_data, $parsedEmail);
if ($canWriteFiles) {
DB::beginWork();
if ($members = json_decode(array_var($_POST, 'members'))) {
$ctrl->add_to_members($email, $members);
}
$conversation = MailContents::getMailsFromConversation($email);
foreach ($conversation as $conv_email) {
$ctrl->add_to_members($conv_email, $members);
MailUtilities::parseMail($conv_email->getContent(), $decoded, $parsedEmail, $warnings);
if ($conv_email->getHasAttachments()) {
$this->classifyFile($classification_data, $conv_email, $parsedEmail, $members);
}
}
DB::commit();
flash_success(lang('success classify email'));
if ($create_task) {
ajx_replace(true);
$this->redirectTo('task', 'add_task', array('from_email' => $email->getId(), 'replace' => 1));
} else {
ajx_current("back");
evt_add("reload mails panel", array());
}
} else {
flash_error(lang("error classifying attachment cant open file"));
ajx_current("empty");
}
// If can write files
// Error...
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
}
tpl_assign('email', $email);
tpl_assign('parsedEmail', $parsedEmail);
}
/**
* Show and process edit milestone form
*
* @access public
* @param void
* @return null
*/
function edit()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$this->setTemplate('add_milestone');
if (array_var($_REQUEST, "template_milestone")) {
$milestone = TemplateMilestones::findById(get_id());
$this->setTemplate(get_template_path('add_template_milestone', 'template_milestone'));
if (!$milestone instanceof TemplateMilestone) {
flash_error(lang('milestone dnx'));
ajx_current("empty");
return;
}
// if
} else {
$milestone = ProjectMilestones::findById(get_id());
if (!$milestone instanceof ProjectMilestone) {
flash_error(lang('milestone dnx'));
ajx_current("empty");
return;
}
// if
}
if (!$milestone->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$milestone_data = array_var($_POST, 'milestone');
if (!is_array($milestone_data)) {
// set layout for modal form
if (array_var($_REQUEST, 'modal')) {
$this->setLayout("json");
tpl_assign('modal', true);
}
$milestone_data = array('name' => $milestone->getObjectName(), 'due_date' => $milestone->getDueDate(), 'description' => $milestone->getDescription(), 'is_urgent' => $milestone->getIsUrgent());
// array
}
// if
tpl_assign('milestone_data', $milestone_data);
tpl_assign('milestone', $milestone);
if (is_array(array_var($_POST, 'milestone'))) {
if (array_var($milestone_data, 'due_date_value') != '') {
$milestone_data['due_date'] = getDateValue(array_var($milestone_data, 'due_date_value'));
} else {
$now = DateTimeValueLib::now();
$milestone_data['due_date'] = DateTimeValueLib::make(0, 0, 0, $now->getMonth(), $now->getDay(), $now->getYear());
}
$milestone->setFromAttributes($milestone_data);
$urgent = array_var($milestone_data, 'is_urgent');
$milestone->setIsUrgent($urgent);
try {
$member_ids = json_decode(array_var($_POST, 'members'));
DB::beginWork();
$milestone->save();
$object_controller = new ObjectController();
$object_controller->add_to_members($milestone, $member_ids);
$object_controller->add_subscribers($milestone);
$object_controller->link_to_new_object($milestone);
$object_controller->add_custom_properties($milestone);
$object_controller->add_reminders($milestone);
DB::commit();
ApplicationLogs::createLog($milestone, ApplicationLogs::ACTION_EDIT);
//Send Template milestone to view
if ($milestone instanceof TemplateMilestone) {
$object = array("action" => "edit", "object_id" => $milestone->getObjectId(), "type" => $milestone->getObjectTypeName(), "id" => $milestone->getId(), "name" => $milestone->getObjectName(), "ico" => "ico-milestone", "manager" => get_class($milestone->manager()));
evt_add("template object added", array('object' => $object));
}
$is_template = $milestone instanceof TemplateMilestone;
if (array_var($_REQUEST, 'modal')) {
ajx_current("empty");
$this->setLayout("json");
$this->setTemplate(get_template_path("empty"));
// reload milestone info because plugins may have updated some task info (for example: name prefix)
if ($is_template) {
$milestone = TemplateMilestones::findById($milestone->getId());
$params = array('msg' => lang('success edit milestone', $milestone->getObjectName()), 'milestone' => $milestone->getArrayInfo(), 'reload' => array_var($_REQUEST, 'reload'));
if ($milestone instanceof TemplateMilestone) {
$params = $object;
}
print_modal_json_response($params, true, array_var($_REQUEST, 'use_ajx'));
} else {
$milestone = ProjectMilestones::findById($milestone->getId());
flash_success(lang('success edit milestone', $milestone->getObjectName()));
evt_add("reload current panel");
}
} else {
if ($milestone instanceof TemplateMilestone) {
flash_success(lang('success edit template', $milestone->getObjectName()));
} else {
flash_success(lang('success edit milestone', $milestone->getObjectName()));
}
if (array_var($task_data, 'inputtype') != 'taskview') {
ajx_current("back");
} else {
ajx_current("reload");
}
}
/*
flash_success(lang('success edit milestone', $milestone->getObjectName()));
if (array_var($_REQUEST, 'modal')) {
evt_add("reload current panel");
}
ajx_current("back");*/
} 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()));
} else {
flash_error($e->getMessage());
}
ajx_current("empty");
}
// try
}
// if
}
function repetitive_event_related_edit($event,$data){
// run the query to set the event data
$event->setFromAttributes($data);
$this->registerInvitations($data, $event, false);
if (isset($data['confirmAttendance'])) {
$this->change_invitation_state($data['confirmAttendance'], $event->getId(), $user_filter);
}
DB::beginWork();
$event->save();
if($event->getSpecialID() != ""){
$this->sync_calendar_extern($event);
}
$object_controller = new ObjectController();
$object_controller->add_to_members($event, array_var($task_data, 'members'));
$object_controller->add_subscribers($event);
$object_controller->link_to_new_object($event);
$object_controller->add_custom_properties($event);
$object_controller->add_reminders($event);
$event->resetIsRead();
ApplicationLogs::createLog($event, ApplicationLogs::ACTION_EDIT);
}
function edit_timeslot()
{
ajx_current("empty");
$timeslot_data = array_var($_POST, 'timeslot');
$timeslot = Timeslots::findById(array_var($timeslot_data, 'id', 0));
if (!$timeslot instanceof Timeslot) {
flash_error(lang('timeslot dnx'));
return;
}
//context permissions or members
$member_ids = json_decode(array_var($_POST, 'members', array()));
// clean member_ids
$tmp_mids = array();
foreach ($member_ids as $mid) {
if (!is_null($mid) && trim($mid) != "") {
$tmp_mids[] = $mid;
}
}
$member_ids = $tmp_mids;
if (empty($member_ids)) {
if (!can_add(logged_user(), active_context(), Timeslots::instance()->getObjectTypeId())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
} else {
if (count($member_ids) > 0) {
$enteredMembers = Members::findAll(array('conditions' => 'id IN (' . implode(",", $member_ids) . ')'));
} else {
$enteredMembers = array();
}
if (!can_add(logged_user(), $enteredMembers, Timeslots::instance()->getObjectTypeId())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
}
try {
$hoursToAdd = array_var($timeslot_data, 'hours', 0);
$minutes = array_var($timeslot_data, 'minutes', 0);
if (strpos($hoursToAdd, ',') && !strpos($hoursToAdd, '.')) {
$hoursToAdd = str_replace(',', '.', $hoursToAdd);
}
if (strpos($hoursToAdd, ':') && !strpos($hoursToAdd, '.')) {
$pos = strpos($hoursToAdd, ':') + 1;
$len = strlen($hoursToAdd) - $pos;
$minutesToAdd = substr($hoursToAdd, $pos, $len);
if (!strlen($minutesToAdd) <= 2 || !strlen($minutesToAdd) > 0) {
$minutesToAdd = substr($minutesToAdd, 0, 2);
}
$mins = $minutesToAdd / 60;
$hours = substr($hoursToAdd, 0, $pos - 1);
$hoursToAdd = $hours + $mins;
}
if ($minutes) {
$min = str_replace('.', '', $minutes / 6);
$hoursToAdd = $hoursToAdd + ("0." . $min);
}
if ($hoursToAdd <= 0) {
flash_error(lang('time has to be greater than 0'));
return;
}
$startTime = getDateValue(array_var($timeslot_data, 'date'));
$startTime = $startTime->add('h', 8 - logged_user()->getTimezone());
$endTime = getDateValue(array_var($timeslot_data, 'date'));
$endTime = $endTime->add('h', 8 - logged_user()->getTimezone() + $hoursToAdd);
$timeslot_data['start_time'] = $startTime;
$timeslot_data['end_time'] = $endTime;
$timeslot_data['name'] = $timeslot_data['description'];
//Only admins can change timeslot user
if (!array_var($timeslot_data, 'contact_id') && !logged_user()->isAdministrator()) {
$timeslot_data['contact_id'] = $timeslot->getContactId();
}
$timeslot->setFromAttributes($timeslot_data);
$user = Contacts::findById($timeslot_data['contact_id']);
$billing_category_id = $user->getDefaultBillingId();
$bc = BillingCategories::findById($billing_category_id);
if ($bc instanceof BillingCategory) {
$timeslot->setBillingId($billing_category_id);
$hourly_billing = $bc->getDefaultValue();
$timeslot->setHourlyBilling($hourly_billing);
$timeslot->setFixedBilling($hourly_billing * $hoursToAdd);
$timeslot->setIsFixedBilling(false);
}
DB::beginWork();
$timeslot->save();
$member_ids = json_decode(array_var($_POST, 'members', ''));
$object_controller = new ObjectController();
$object_controller->add_to_members($timeslot, $member_ids);
DB::commit();
ApplicationLogs::createLog($timeslot, ApplicationLogs::ACTION_EDIT);
ajx_extra_data(array("timeslot" => $timeslot->getArrayInfo()));
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
}
// try
}
private function save_object($request)
{
$response = false;
if (!empty($request['args'])) {
$service = $request['srv'];
switch ($service) {
case "task":
if ($request['args']['id']) {
$object = ProjectTasks::instance()->findByid($request['args']['id']);
} else {
$object = new ProjectTask();
}
if ($object instanceof ProjectTask) {
if (!empty($request['args']['title'])) {
$object->setObjectName($request['args']['title']);
}
if (!empty($request['args']['description'])) {
$object->setText($request['args']['description']);
}
if (!empty($request['args']['due_date'])) {
if ($request['args']['due_date'] != '' && $request['args']['due_date'] != date_format_tip('dd/mm/yyyy')) {
$date_format = 'dd/mm/yyyy';
$object->setDueDate(DateTimeValueLib::dateFromFormatAndString($date_format, $value));
}
}
if (!empty($request['args']['completed'])) {
$object->setPercentCompleted($request['args']['completed']);
}
if (!empty($request['args']['assign_to'])) {
$object->setAssignedToContactId($request['args']['assign_to']);
}
if (!empty($request['args']['priority'])) {
$object->setPriority($request['args']['priority']);
}
}
break;
case 'note':
if ($request['args']['id']) {
$object = ProjectMessages::instance()->findByid($request['args']['id']);
} else {
$object = new ProjectMessage();
}
if ($object instanceof ProjectMessage) {
if (!empty($request['args']['title'])) {
$object->setObjectName($request['args']['title']);
}
if (!empty($request['args']['title'])) {
$object->setText($request['args']['text']);
}
}
break;
}
// END SWITCH
if ($object) {
try {
$context = array();
$members = array();
if (!empty($request['args']['members'])) {
$members = $request['args']['members'];
$context = get_context_from_array($members);
}
//Check permissions:
if ($request['args']['id'] && $object->canEdit(logged_user()) || !$request['args']['id'] && $object->canAdd(logged_user(), $context)) {
DB::beginWork();
$object->save();
$object_controller = new ObjectController();
if (!$request['args']['id']) {
$object_controller->add_to_members($object, $members);
}
DB::commit();
$response = true;
}
} catch (Exception $e) {
DB::rollback();
return false;
}
}
}
return $this->response('json', $response);
}
function import_google_calendar()
{
$users_cal = ExternalCalendarUsers::findAll();
if (count($users_cal) > 0) {
foreach ($users_cal as $users) {
$contact = Contacts::findById($users->getContactId());
$calendars = ExternalCalendars::findByExtCalUserId($users->getId());
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_AuthSub');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Calendar');
$user = $users->getAuthUser();
$pass = $users->getAuthPass();
$service = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
try {
$client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
$gdataCal = new Zend_Gdata_Calendar($client);
//update or insert events for calendars
foreach ($calendars as $calendar) {
//check the deleted calendars
$delete_calendar = true;
$calFeed = $gdataCal->getCalendarListFeed();
foreach ($calFeed as $calF) {
$cal_src = explode("/", $calF->content->src);
array_pop($cal_src);
$calendar_visibility = end($cal_src);
array_pop($cal_src);
$calendar_user = end($cal_src);
if ($calendar_user == $calendar->getCalendarUser()) {
$delete_calendar = false;
}
}
if (!$delete_calendar) {
$calendar_user = $calendar->getCalendarUser();
$calendar_visibility = $calendar->getCalendarVisibility();
$query = $gdataCal->newEventQuery();
$query->setUser($calendar_user);
$query->setVisibility($calendar_visibility);
$query->setSingleEvents(true);
$query->setProjection('full');
// execute and get results
$event_list = $gdataCal->getCalendarEventFeed($query);
$array_events_google = array();
foreach ($event_list as $event) {
$event_id = explode("/", $event->id->text);
$special_id = end($event_id);
$event_name = lang("untitle event");
if ($event->title->text != "") {
$event_name = $event->title->text;
}
$array_events_google[] = $special_id;
$new_event = ProjectEvents::findBySpecialId($special_id);
if ($new_event) {
if ($new_event->getUpdateSync() instanceof DateTimeValue && strtotime(ProjectEvents::date_google_to_sql($event->updated)) > $new_event->getUpdateSync()->getTimestamp()) {
$start = strtotime(ProjectEvents::date_google_to_sql($event->when[0]->startTime));
$fin = strtotime(ProjectEvents::date_google_to_sql($event->when[0]->endTime));
if ($fin - $start == 86400) {
$new_event->setStart(date("Y-m-d H:i:s", $start));
$new_event->setDuration(date("Y-m-d H:i:s", $start));
$new_event->setTypeId(2);
} elseif ($fin - $start > 86400) {
$t_s = explode(' ', date("Y-m-d H:i:s", $start));
$t_f = explode(' ', date("Y-m-d H:i:s", $fin));
$date_s = new DateTimeValue(strtotime($t_s[0] . "00:00:00") - $contact->getTimezone() * 3600);
$date_f = new DateTimeValue(strtotime($t_f[0] . "23:59:59 -1 day") - $contact->getTimezone() * 3600);
$new_event->setStart(date("Y-m-d H:i:s", $date_s->getTimestamp()));
$new_event->setDuration(date("Y-m-d H:i:s", $date_f->getTimestamp()));
$new_event->setTypeId(2);
} else {
$new_event->setStart(ProjectEvents::date_google_to_sql($event->when[0]->startTime));
$new_event->setDuration(ProjectEvents::date_google_to_sql($event->when[0]->endTime));
}
$new_event->setObjectName($event_name);
$new_event->setDescription($event->content->text);
$new_event->setUpdateSync(ProjectEvents::date_google_to_sql($event->updated));
$new_event->setExtCalId($calendar->getId());
$new_event->save();
}
} else {
$new_event = new ProjectEvent();
$start = strtotime(ProjectEvents::date_google_to_sql($event->when[0]->startTime));
$fin = strtotime(ProjectEvents::date_google_to_sql($event->when[0]->endTime));
if ($fin - $start == 86400) {
$new_event->setStart(date("Y-m-d H:i:s", $start));
$new_event->setDuration(date("Y-m-d H:i:s", $start));
$new_event->setTypeId(2);
} elseif ($fin - $start > 86400) {
$t_s = explode(' ', date("Y-m-d H:i:s", $start));
$t_f = explode(' ', date("Y-m-d H:i:s", $fin));
$date_s = new DateTimeValue(strtotime($t_s[0] . "00:00:00") - $contact->getTimezone() * 3600);
$date_f = new DateTimeValue(strtotime($t_f[0] . "23:59:59 -1 day") - $contact->getTimezone() * 3600);
$new_event->setStart(date("Y-m-d H:i:s", $date_s->getTimestamp()));
$new_event->setDuration(date("Y-m-d H:i:s", $date_f->getTimestamp()));
$new_event->setTypeId(2);
} else {
$new_event->setStart(ProjectEvents::date_google_to_sql($event->when[0]->startTime));
$new_event->setDuration(ProjectEvents::date_google_to_sql($event->when[0]->endTime));
$new_event->setTypeId(1);
}
$new_event->setObjectName($event_name);
$new_event->setDescription($event->content->text);
$new_event->setSpecialID($special_id);
$new_event->setUpdateSync(ProjectEvents::date_google_to_sql($event->updated));
$new_event->setExtCalId($calendar->getId());
$new_event->save();
$conditions = array('event_id' => $new_event->getId(), 'contact_id' => $contact->getId());
//insert only if not exists
if (EventInvitations::findById($conditions) == null) {
$invitation = new EventInvitation();
$invitation->setEventId($new_event->getId());
$invitation->setContactId($contact->getId());
$invitation->setInvitationState($contact instanceof Contact && $contact->getId() == $contact->getId() ? 1 : 0);
$invitation->save();
}
//insert only if not exists
if (ObjectSubscriptions::findBySubscriptions($new_event->getId(), $contact) == null) {
$subscription = new ObjectSubscription();
$subscription->setObjectId($new_event->getId());
$subscription->setContactId($contact->getId());
$subscription->save();
}
if ($users->getRelatedTo()) {
$member = array();
$member_ids = explode(",", $users->getRelatedTo());
foreach ($member_ids as $member_id) {
$member[] = $member_id;
}
$object_controller = new ObjectController();
$object_controller->add_to_members($new_event, $member);
} else {
$member_ids = array();
$context = active_context();
if (count($context) > 0) {
foreach ($context as $selection) {
if ($selection instanceof Member) {
$member_ids[] = $selection->getId();
}
}
}
if (count($member_ids) == 0 && $contact instanceof Contact) {
$m = Members::findById($contact->getPersonalMemberId());
if (!$m instanceof Member) {
$person_dim = Dimensions::findByCode('feng_persons');
if ($person_dim instanceof Dimension) {
$member_ids = Members::findAll(array('id' => true, 'conditions' => array("object_id = ? AND dimension_id = ?", $contact->getId(), $person_dim->getId())));
}
} else {
$member_ids[] = $m->getId();
}
}
$object_controller = new ObjectController();
$object_controller->add_to_members($new_event, $member_ids, $contact);
}
}
}
// foreach event list
//check the deleted events
$events_delete = ProjectEvents::findByExtCalId($calendar->getId());
if ($events_delete) {
foreach ($events_delete as $event_delete) {
if (!in_array($event_delete->getSpecialID(), $array_events_google)) {
$event_delete->trash();
$event_delete->setSpecialID("");
$event_delete->setExtCalId(0);
$event_delete->save();
}
}
}
} else {
$events = ProjectEvents::findByExtCalId($calendar->getId());
if ($calendar->delete()) {
if ($events) {
foreach ($events as $event) {
$event->trash();
$event->setSpecialID("");
$event->setExtCalId(0);
$event->save();
}
}
}
}
}
//foreach calendars
} catch (Exception $e) {
//Logger::log($e->getMessage());
}
}
}
}
function edit_custom_report()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$report_id = array_var($_GET, 'id');
$report = Reports::getReport($report_id);
if (!$report->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
if (is_array(array_var($_POST, 'report'))) {
try {
ajx_current("empty");
$report_data = array_var($_POST, 'report');
$member_ids = json_decode(array_var($_POST, 'members'));
if (!is_array($member_ids) || count($member_ids) == 0) {
flash_error(lang('must choose at least one member'));
ajx_current("empty");
return;
}
$members = Members::findAll(array("conditions" => array("`id` IN(?)", $member_ids)));
DB::beginWork();
$report->setObjectName($report_data['name']);
$report->setDescription($report_data['description']);
$report->setReportObjectTypeId($report_data['report_object_type_id']);
$report->setOrderBy($report_data['order_by']);
$report->setIsOrderByAsc($report_data['order_by_asc'] == 'asc');
$report->save();
$conditions = array_var($_POST, 'conditions');
if (!is_array($conditions)) {
$conditions = array();
}
foreach ($conditions as $condition) {
$newCondition = new ReportCondition();
if ($condition['id'] > 0) {
$newCondition = ReportConditions::getCondition($condition['id']);
}
if ($condition['deleted'] == "1") {
$newCondition->delete();
continue;
}
$newCondition->setReportId($report_id);
$custom_prop_id = isset($condition['custom_property_id']) ? $condition['custom_property_id'] : 0;
$newCondition->setCustomPropertyId($custom_prop_id);
$newCondition->setFieldName($condition['field_name']);
$newCondition->setCondition($condition['condition']);
if ($condition['field_type'] == 'boolean') {
$newCondition->setValue(isset($condition['value']) && $condition['value']);
} else {
if ($condition['field_type'] == 'date') {
if ($condition['value'] == '') {
$newCondition->setValue('');
} else {
$dtFromWidget = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $condition['value']);
$newCondition->setValue(date("m/d/Y", $dtFromWidget->getTimestamp()));
}
} else {
$newCondition->setValue(isset($condition['value']) ? $condition['value'] : '');
}
}
$newCondition->setIsParametrizable(isset($condition['is_parametrizable']));
$newCondition->save();
}
ReportColumns::delete('report_id = ' . $report_id);
$columns = array_var($_POST, 'columns');
asort($columns);
//sort the array by column order
foreach ($columns as $column => $order) {
if ($order > 0) {
$newColumn = new ReportColumn();
$newColumn->setReportId($report_id);
if (is_numeric($column)) {
$newColumn->setCustomPropertyId($column);
} else {
$newColumn->setFieldName($column);
}
$newColumn->save();
}
}
$object_controller = new ObjectController();
$object_controller->add_to_members($report, $member_ids);
DB::commit();
flash_success(lang('custom report updated'));
ajx_current('back');
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
// try
} else {
$this->setTemplate('add_custom_report');
tpl_assign('url', get_url('reporting', 'edit_custom_report', array('id' => $report_id)));
if ($report instanceof Report) {
tpl_assign('id', $report_id);
$report_data = array('name' => $report->getObjectName(), 'description' => $report->getDescription(), 'report_object_type_id' => $report->getReportObjectTypeId(), 'order_by' => $report->getOrderBy(), 'order_by_asc' => $report->getIsOrderByAsc());
tpl_assign('report_data', $report_data);
$conditions = ReportConditions::getAllReportConditions($report_id);
tpl_assign('conditions', $conditions);
$columns = ReportColumns::getAllReportColumns($report_id);
$colIds = array();
foreach ($columns as $col) {
if ($col->getCustomPropertyId() > 0) {
$colIds[] = $col->getCustomPropertyId();
} else {
$colIds[] = $col->getFieldName();
}
}
tpl_assign('columns', $colIds);
}
$selected_type = $report->getReportObjectTypeId();
$types = array(array("", lang("select one")));
$object_types = ObjectTypes::getAvailableObjectTypes();
foreach ($object_types as $ot) {
$types[] = array($ot->getId(), lang($ot->getName()));
}
tpl_assign('object_types', $types);
tpl_assign('selected_type', $selected_type);
tpl_assign('object', $report);
tpl_assign('allowed_columns', $this->get_allowed_columns($selected_type), true);
}
}
/**
* Add company
*
* @param void
* @return null
*/
function add_company()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$notAllowedMember = '';
if (!Contact::canAdd(logged_user(), active_context(), $notAllowedMember)) {
if (str_starts_with($notAllowedMember, '-- req dim --')) {
flash_error(lang('must choose at least one member of', str_replace_first('-- req dim --', '', $notAllowedMember, $in)));
} else {
trim($notAllowedMember) == "" ? flash_error(lang('you must select where to keep', lang('the contact'))) : flash_error(lang('no context permissions to add', lang("contacts"), $notAllowedMember));
}
ajx_current("empty");
return;
}
// if
$company = new Contact();
$company->setIsCompany(1);
$company_data = array_var($_POST, 'company');
if (!is_array($company_data)) {
// set layout for modal form
if (array_var($_REQUEST, 'modal')) {
$this->setLayout("json");
tpl_assign('modal', true);
}
$company_data = array('timezone' => logged_user()->getTimezone());
// array
}
// if
tpl_assign('company', $company);
tpl_assign('company_data', $company_data);
// telephone types
$all_telephone_types = TelephoneTypes::getAllTelephoneTypesInfo();
tpl_assign('all_telephone_types', $all_telephone_types);
// address types
$all_address_types = AddressTypes::getAllAddressTypesInfo();
tpl_assign('all_address_types', $all_address_types);
// webpage types
$all_webpage_types = WebpageTypes::getAllWebpageTypesInfo();
tpl_assign('all_webpage_types', $all_webpage_types);
// email types
$all_email_types = EmailTypes::getAllEmailTypesInfo();
tpl_assign('all_email_types', $all_email_types);
$company_data['all_phones'] = array();
$company_data['all_addresses'] = array();
$company_data['all_webpages'] = array();
if (is_array(array_var($_POST, 'company'))) {
foreach ($company_data as $k => &$v) {
$v = remove_scripts($v);
}
$company->setFromAttributes($company_data);
$company->setObjectName();
try {
$company_data['contact_type'] = 'company';
Contacts::validate($company_data);
DB::beginWork();
if (isset($_SESSION['new_contact_picture']) && $_SESSION['new_contact_picture']) {
$company->setPictureFile($_SESSION['new_contact_picture']);
$_SESSION['new_contact_picture'] = null;
}
$company->save();
// save phones, addresses and webpages
$this->save_phones_addresses_webpages($company_data, $company);
if ($company_data['email'] != "") {
$company->addEmail($company_data['email'], 'work', true);
}
// save additional emails
$this->save_non_main_emails($company_data, $company);
$object_controller = new ObjectController();
$object_controller->add_subscribers($company);
$member_ids = json_decode(array_var($_POST, 'members'));
if (!is_null($member_ids)) {
$object_controller->add_to_members($company, $member_ids);
}
$object_controller->link_to_new_object($company);
$object_controller->add_custom_properties($company);
DB::commit();
ApplicationLogs::createLog($company, ApplicationLogs::ACTION_ADD);
flash_success(lang('success add client', $company->getObjectName()));
evt_add("company added", array("id" => $company->getObjectId(), "name" => $company->getObjectName()));
ajx_current("back");
if (array_var($_REQUEST, 'modal')) {
evt_add("reload current panel");
}
} catch (Exception $e) {
DB::rollback();
ajx_current("empty");
if (array_var($_REQUEST, 'modal')) {
ajx_extra_data(array('error' => $e->getMessage()));
} else {
flash_error($e->getMessage());
}
}
// try
}
// if
}
private function upload_file($file, $filename, $path, $members) {
try {
if ($file == null) {
$file = new ProjectFile();
$file->setFilename($filename);
$file->setIsVisible(true);
$file->setCreatedOn(new DateTimeValue(time()));
}
$file_dt['name'] = $file->getFilename();
$file_dt['size'] = filesize($path);
$file_dt['tmp_name'] = $path;
$extension = trim(get_file_extension($filename));
$file_dt['type'] = Mime_Types::instance()->get_type($extension);
if(!trim($file_dt['type'])) $file_dt['type'] = 'text/html';
DB::beginWork();
$file->save();
$ctrl = new ObjectController() ;
if (is_array($members)) {
$ctrl->add_to_members($file, array_flat($members));
}
$revision = $file->handleUploadedFile($file_dt, true, '');
ApplicationLogs::createLog($file, ApplicationLogs::ACTION_ADD);
DB::commit();
return true;
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
return false;
} // upload_extracted_file
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;
}
/**
* Edit specific webpage
*
* @access public
* @param void
* @return null
*/
function edit()
{
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$this->setTemplate('add');
$webpage = ProjectWebpages::findById(get_id());
if (!$webpage instanceof ProjectWebpage) {
flash_error(lang('webpage dnx'));
ajx_current("empty");
return;
}
if (!$webpage->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$webpage_data = array_var($_POST, 'webpage');
if (!is_array($webpage_data)) {
$webpage_data = array('url' => $webpage->getUrl(), 'name' => $webpage->getObjectName(), 'description' => $webpage->getDescription());
}
if (is_array(array_var($_POST, 'webpage'))) {
try {
$webpage->setFromAttributes($webpage_data);
DB::beginWork();
$webpage->save();
$member_ids = json_decode(array_var($_POST, 'members'));
$object_controller = new ObjectController();
$object_controller->add_to_members($webpage, $member_ids);
$object_controller->link_to_new_object($webpage);
$object_controller->add_subscribers($webpage);
$object_controller->add_custom_properties($webpage);
ApplicationLogs::createLog($webpage, ApplicationLogs::ACTION_EDIT);
$webpage->resetIsRead();
DB::commit();
flash_success(lang('success edit webpage', $webpage->getObjectName()));
ajx_current("back");
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
}
tpl_assign('webpage', $webpage);
tpl_assign('webpage_data', $webpage_data);
}
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;
}
try {
$sql = "";
$first_row = true;
$cant = 0;
$count = 0;
$processed_objects = array();
$user = Contacts::findOne(array("conditions" => "user_type = (SELECT id FROM " . TABLE_PREFIX . "permission_groups WHERE name='Super Administrator')"));
$object_controller = new ObjectController();
$objects = Objects::findAll(array('id' => true, "conditions" => "id NOT IN(SELECT object_id FROM " . TABLE_PREFIX . "processed_objects)", "order" => "id DESC", "limit" => OBJECT_COUNT));
foreach ($objects as $obj) {
$cobj = Objects::findObject($obj);
if ($cobj instanceof ContentDataObject) {
if (!$cobj instanceof Workspace) {
$mem_ids = $cobj->getMemberIds();
if (count($mem_ids) > 0) {
$object_controller->add_to_members($cobj, $mem_ids, $user);
} else {
$cobj->addToSharingTable();
}
$cobj->addToSearchableObjects(true);
}
// add mails to sharing table for account owners
if ($cobj instanceof MailContent && $cobj->getAccount() instanceof MailAccount) {
$db_result = DB::execute("SELECT contact_id FROM " . TABLE_PREFIX . "mail_account_contacts WHERE account_id = " . $cobj->getAccountId());
$macs = $db_result->fetchAll();
if ($macs && is_array($macs) && count($macs) > 0) {
$pgs = array();
foreach ($macs as $mac) {
$contact_id = $mac['contact_id'];
$mac_pgs = DB::executeAll("SELECT permission_group_id FROM " . TABLE_PREFIX . "contacts WHERE object_id={$contact_id}");
foreach ($mac_pgs as $mac_pg) {
/**
* Show and process edit milestone form
*
* @access public
* @param void
* @return null
*/
function edit() {
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$this->setTemplate('add_milestone');
$milestone = ProjectMilestones::findById(get_id());
if(!($milestone instanceof ProjectMilestone)) {
flash_error(lang('milestone dnx'));
ajx_current("empty");
return;
} // if
if(!$milestone->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$milestone_data = array_var($_POST, 'milestone');
if(!is_array($milestone_data)) {
$milestone_data = array(
'name' => $milestone->getObjectName(),
'due_date' => $milestone->getDueDate(),
'description' => $milestone->getDescription(),
'is_urgent' => $milestone->getIsUrgent()
); // array
} // if
tpl_assign('milestone_data', $milestone_data);
tpl_assign('milestone', $milestone);
if(is_array(array_var($_POST, 'milestone'))) {
if (array_var($milestone_data, 'due_date_value') != ''){
$milestone_data['due_date'] = getDateValue(array_var($milestone_data, 'due_date_value'));
} else {
$now = DateTimeValueLib::now();
$milestone_data['due_date'] = DateTimeValueLib::make(0, 0, 0, $now->getMonth(), $now->getDay(), $now->getYear());
}
$milestone->setFromAttributes($milestone_data);
$urgent = array_var($milestone_data, 'is_urgent') == 'checked';
$milestone->setIsUrgent($urgent);
try {
$member_ids = json_decode(array_var($_POST, 'members'));
DB::beginWork();
$milestone->save();
$object_controller = new ObjectController();
$object_controller->add_to_members($milestone, $member_ids);
$object_controller->add_subscribers($milestone);
$object_controller->link_to_new_object($milestone);
$object_controller->add_custom_properties($milestone);
$object_controller->add_reminders($milestone);
ApplicationLogs::createLog($milestone, ApplicationLogs::ACTION_EDIT);
DB::commit();
flash_success(lang('success edit milestone', $milestone->getObjectName()));
ajx_current("back");
} catch(Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
} // try
} // if
} // edit
function repetitive_task_related_edit($task, $task_data)
{
$was_template = $task->getIsTemplate();
$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;
}
DB::beginWork();
$task->save();
$task->setObjectName(array_var($task_data, 'name'));
$task->save();
// 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, array_var($task_data, 'members'));
$object_controller->add_subscribers($task);
$object_controller->link_to_new_object($task);
$object_controller->add_custom_properties($task);
$object_controller->add_reminders($task);
// 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)) {
$sub->setAssignedToContactId($assigned_to);
$modified = true;
}
if ($apply_ms) {
$sub->setMilestoneId($milestone_id);
$modified = true;
}
if ($modified) {
$sub->save();
}
}
$task->resetIsRead();
ApplicationLogs::createLog($task, ApplicationLogs::ACTION_EDIT);
DB::commit();
}
function edit_timeslot()
{
if (!can_add(logged_user(), active_context(), Timeslots::instance()->getObjectTypeId())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
ajx_current("empty");
$timeslot_data = array_var($_POST, 'timeslot');
$timeslot = Timeslots::findById(array_var($timeslot_data, 'id', 0));
if (!$timeslot instanceof Timeslot) {
flash_error(lang('timeslot dnx'));
return;
}
try {
$hoursToAdd = array_var($timeslot_data, 'hours', 0);
$minutes = array_var($timeslot_data, 'minutes', 0);
if (strpos($hoursToAdd, ',') && !strpos($hoursToAdd, '.')) {
$hoursToAdd = str_replace(',', '.', $hoursToAdd);
}
if (strpos($hoursToAdd, ':') && !strpos($hoursToAdd, '.')) {
$pos = strpos($hoursToAdd, ':') + 1;
$len = strlen($hoursToAdd) - $pos;
$minutesToAdd = substr($hoursToAdd, $pos, $len);
if (!strlen($minutesToAdd) <= 2 || !strlen($minutesToAdd) > 0) {
$minutesToAdd = substr($minutesToAdd, 0, 2);
}
$mins = $minutesToAdd / 60;
$hours = substr($hoursToAdd, 0, $pos - 1);
$hoursToAdd = $hours + $mins;
}
if ($minutes) {
$min = str_replace('.', '', $minutes / 6);
$hoursToAdd = $hoursToAdd + ("0." . $min);
}
if ($hoursToAdd <= 0) {
flash_error(lang('time has to be greater than 0'));
return;
}
$startTime = getDateValue(array_var($timeslot_data, 'date'));
$startTime = $startTime->add('h', 8 - logged_user()->getTimezone());
$endTime = getDateValue(array_var($timeslot_data, 'date'));
$endTime = $endTime->add('h', 8 - logged_user()->getTimezone() + $hoursToAdd);
$timeslot_data['start_time'] = $startTime;
$timeslot_data['end_time'] = $endTime;
$timeslot_data['name'] = $timeslot_data['description'];
//Only admins can change timeslot user
if (array_var($timeslot_data, 'contact_id', false) && !logged_user()->isAdministrator()) {
$timeslot_data['contact_id'] = $timeslot->getContactId();
}
$timeslot->setFromAttributes($timeslot_data);
$user = Contacts::findById($timeslot_data['contact_id']);
$billing_category_id = $user->getDefaultBillingId();
$bc = BillingCategories::findById($billing_category_id);
if ($bc instanceof BillingCategory) {
$timeslot->setBillingId($billing_category_id);
$hourly_billing = $bc->getDefaultValue();
$timeslot->setHourlyBilling($hourly_billing);
$timeslot->setFixedBilling($hourly_billing * $hoursToAdd);
$timeslot->setIsFixedBilling(false);
}
DB::beginWork();
$timeslot->save();
$member_ids = json_decode(array_var($_POST, 'members', ''));
if ($member_ids && count($member_ids)) {
ajx_add("time-panel", "reload");
} else {
foreach (active_context() as $dimension) {
$names[] = $dimension->getName();
}
flash_error(lang('select member to add timeslots', implode(", ", $names)));
//flash_error(lang('must choose at least one member'));
DB::rollback();
return;
}
$object_controller = new ObjectController();
$object_controller->add_to_members($timeslot, $member_ids);
DB::commit();
ajx_extra_data(array("timeslot" => $timeslot->getArrayInfo()));
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
}
// try
}
/**
* Add company
*
* @param void
* @return null
*/
function add_company() {
if (logged_user()->isGuest()) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
$notAllowedMember = '';
if(!Contact::canAdd(logged_user(),active_context(),$notAllowedMember)) {
if (str_starts_with($notAllowedMember, '-- req dim --')) flash_error(lang('must choose at least one member of', str_replace_first('-- req dim --', '', $notAllowedMember, $in)));
else flash_error(lang('no context permissions to add',lang("contacts"), $notAllowedMember));
ajx_current("empty");
return;
} // if
$company = new Contact();
$company->setIsCompany(1);
$company_data = array_var($_POST, 'company');
if(!is_array($company_data)) {
$company_data = array(
'timezone' => logged_user()->getTimezone(),
); // array
} // if
tpl_assign('company', $company);
tpl_assign('company_data', $company_data);
if (is_array(array_var($_POST, 'company'))) {
$company->setFromAttributes($company_data);
$company->setObjectName();
try {
Contacts::validate($company_data);
DB::beginWork();
$company->save();
if($company_data['address'] != "")
$company->addAddress($company_data['address'], $company_data['city'], $company_data['state'], $company_data['country'], $company_data['zipcode'], 'work', true);
if($company_data['phone_number'] != "") $company->addPhone($company_data['phone_number'], 'work', true);
if($company_data['fax_number'] != "") $company->addPhone($company_data['fax_number'], 'fax', true);
if($company_data['homepage'] != "") $company->addWebpage($company_data['homepage'], 'work');
if($company_data['email'] != "") $company->addEmail($company_data['email'], 'work' , true);
$object_controller = new ObjectController();
$object_controller->add_subscribers($company);
$member_ids = json_decode(array_var($_POST, 'members'));
if (!is_null($member_ids)) {
$object_controller->add_to_members($company, $member_ids);
}
$object_controller->link_to_new_object($company);
$object_controller->add_custom_properties($company);
ApplicationLogs::createLog($company, ApplicationLogs::ACTION_ADD);
DB::commit();
flash_success(lang('success add client', $company->getObjectName()));
evt_add("company added", array("id" => $company->getObjectId(), "name" => $company->getObjectName()));
ajx_current("back");
} catch(Exception $e) {
DB::rollback();
ajx_current("empty");
flash_error($e->getMessage());
} // try
} // if
} // add_company
function SaveMail(&$content, MailAccount $account, $uidl, $state = 0, $imap_folder_name = '')
{
if (strpos($content, '+OK ') > 0) {
$content = substr($content, strpos($content, '+OK '));
}
self::parseMail($content, $decoded, $parsedMail, $warnings);
$encoding = array_var($parsedMail, 'Encoding', 'UTF-8');
$enc_conv = EncodingConverter::instance();
$to_addresses = self::getAddresses(array_var($parsedMail, "To"));
$from = self::getAddresses(array_var($parsedMail, "From"));
$message_id = self::getHeaderValueFromContent($content, "Message-ID");
$in_reply_to_id = self::getHeaderValueFromContent($content, "In-Reply-To");
$uid = trim($uidl);
if (str_starts_with($uid, '<') && str_ends_with($uid, '>')) {
$uid = utf8_substr($uid, 1, utf8_strlen($uid, $encoding) - 2, $encoding);
}
if ($uid == '') {
$uid = trim($message_id);
if ($uid == '') {
$uid = array_var($parsedMail, 'Subject', 'MISSING UID');
}
if (str_starts_with($uid, '<') && str_ends_with($uid, '>')) {
$uid = utf8_substr($uid, 1, utf8_strlen($uid, $encoding) - 2, $encoding);
}
}
// do not save duplicate emails
if (MailContents::mailRecordExists($account->getId(), $uid, $imap_folder_name == '' ? null : $imap_folder_name)) {
return;
}
if (!$from) {
$parsedMail["From"] = self::getFromAddressFromContent($content);
$from = array_var($parsedMail["From"][0], 'address', '');
}
if (defined('EMAIL_MESSAGEID_CONTROL') && EMAIL_MESSAGEID_CONTROL) {
if (trim($message_id) != "") {
$id_condition = " AND `message_id`='" . trim($message_id) . "'";
} else {
$id_condition = " AND `name`='" . trim(array_var($parsedMail, 'Subject')) . "' AND `from`='{$from}'";
if (array_var($parsedMail, 'Date')) {
$sent_date_dt = new DateTimeValue(strtotime(array_var($parsedMail, 'Date')));
$sent_date_str = $sent_date_dt->toMySQL();
$id_condition .= " AND `sent_date`='" . $sent_date_str . "'";
}
}
$same = MailContents::findOne(array('conditions' => "`account_id`=" . $account->getId() . $id_condition, 'include_trashed' => true));
if ($same instanceof MailContent) {
return;
}
}
$from_spam_junk_folder = strpos(strtolower($imap_folder_name), 'spam') !== FALSE || strpos(strtolower($imap_folder_name), 'junk') !== FALSE || strpos(strtolower($imap_folder_name), 'trash') !== FALSE;
$user_id = logged_user() instanceof Contact ? logged_user()->getId() : $account->getContactId();
$max_spam_level = user_config_option('max_spam_level', null, $user_id);
if ($max_spam_level < 0) {
$max_spam_level = 0;
}
$mail_spam_level = strlen(trim(array_var($decoded[0]['Headers'], 'x-spam-level:', '')));
// if max_spam_level >= 10 then nothing goes to junk folder
$spam_in_subject = false;
if (config_option('check_spam_in_subject')) {
$spam_in_subject = strpos_utf(strtoupper(array_var($parsedMail, 'Subject')), "**SPAM**") !== false;
}
if ($max_spam_level < 10 && ($mail_spam_level > $max_spam_level || $from_spam_junk_folder) || $spam_in_subject) {
$state = 4;
// send to Junk folder
}
//if you are in the table spam MailSpamFilters
$spam_email = MailSpamFilters::getFrom($account->getId(), $from);
if ($spam_email) {
$state = 0;
if ($spam_email[0]->getSpamState() == "spam") {
$state = 4;
}
} else {
if ($state == 0) {
if ($from == $account->getEmailAddress()) {
if (strpos($to_addresses, $from) !== FALSE) {
$state = 5;
} else {
$state = 1;
}
//Show only in sent folder
}
}
}
if (!isset($parsedMail['Subject'])) {
$parsedMail['Subject'] = '';
}
$mail = new MailContent();
$mail->setAccountId($account->getId());
$mail->setState($state);
$mail->setImapFolderName($imap_folder_name);
$mail->setFrom($from);
$cc = trim(self::getAddresses(array_var($parsedMail, "Cc")));
if ($cc == '' && array_var($decoded, 0) && array_var($decoded[0], 'Headers')) {
$cc = array_var($decoded[0]['Headers'], 'cc:', '');
}
$mail->setCc($cc);
$from_name = trim(array_var(array_var(array_var($parsedMail, 'From'), 0), 'name'));
$from_encoding = detect_encoding($from_name);
if ($from_name == '') {
$from_name = $from;
} else {
if (strtoupper($encoding) == 'KOI8-R' || strtoupper($encoding) == 'CP866' || $from_encoding != 'UTF-8' || !$enc_conv->isUtf8RegExp($from_name)) {
//KOI8-R and CP866 are Russian encodings which PHP does not detect
$utf8_from = $enc_conv->convert($encoding, 'UTF-8', $from_name);
if ($enc_conv->hasError()) {
$utf8_from = utf8_encode($from_name);
}
$utf8_from = utf8_safe($utf8_from);
$mail->setFromName($utf8_from);
} else {
$mail->setFromName($from_name);
}
}
$subject_aux = $parsedMail['Subject'];
$subject_encoding = detect_encoding($subject_aux);
if (strtoupper($encoding) == 'KOI8-R' || strtoupper($encoding) == 'CP866' || $subject_encoding != 'UTF-8' || !$enc_conv->isUtf8RegExp($subject_aux)) {
//KOI8-R and CP866 are Russian encodings which PHP does not detect
$utf8_subject = $enc_conv->convert($encoding, 'UTF-8', $subject_aux);
if ($enc_conv->hasError()) {
$utf8_subject = utf8_encode($subject_aux);
}
$utf8_subject = utf8_safe($utf8_subject);
$mail->setSubject($utf8_subject);
} else {
$utf8_subject = utf8_safe($subject_aux);
$mail->setSubject($utf8_subject);
}
$mail->setTo($to_addresses);
$sent_timestamp = false;
if (array_key_exists("Date", $parsedMail)) {
$sent_timestamp = strtotime($parsedMail["Date"]);
}
if ($sent_timestamp === false || $sent_timestamp === -1 || $sent_timestamp === 0) {
$mail->setSentDate(DateTimeValueLib::now());
} else {
$mail->setSentDate(new DateTimeValue($sent_timestamp));
}
// if this constant is defined, mails older than this date will not be fetched
if (defined('FIRST_MAIL_DATE')) {
$first_mail_date = DateTimeValueLib::makeFromString(FIRST_MAIL_DATE);
if ($mail->getSentDate()->getTimestamp() < $first_mail_date->getTimestamp()) {
// return true to stop getting older mails from the server
return true;
}
}
$received_timestamp = false;
if (array_key_exists("Received", $parsedMail) && $parsedMail["Received"]) {
$received_timestamp = strtotime($parsedMail["Received"]);
}
if ($received_timestamp === false || $received_timestamp === -1 || $received_timestamp === 0) {
$mail->setReceivedDate($mail->getSentDate());
} else {
$mail->setReceivedDate(new DateTimeValue($received_timestamp));
if ($state == 5 && $mail->getSentDate()->getTimestamp() > $received_timestamp) {
$mail->setReceivedDate($mail->getSentDate());
}
}
$mail->setSize(strlen($content));
$mail->setHasAttachments(!empty($parsedMail["Attachments"]));
$mail->setCreatedOn(new DateTimeValue(time()));
$mail->setCreatedById($account->getContactId());
$mail->setAccountEmail($account->getEmail());
$mail->setMessageId($message_id);
$mail->setInReplyToId($in_reply_to_id);
$mail->setUid($uid);
$type = array_var($parsedMail, 'Type', 'text');
switch ($type) {
case 'html':
$utf8_body = $enc_conv->convert($encoding, 'UTF-8', array_var($parsedMail, 'Data', ''));
//Solve bad syntax styles outlook if it exists
if (substr_count($utf8_body, "<style>") != substr_count($utf8_body, "</style>") && substr_count($utf8_body, "/* Font Definitions */") >= 1) {
$p1 = strpos($utf8_body, "/* Font Definitions */", 0);
$utf8_body1 = substr($utf8_body, 0, $p1);
$p0 = strrpos($utf8_body1, "</style>");
$html_content = ($p0 >= 0 ? substr($utf8_body1, 0, $p0) : $utf8_body1) . substr($utf8_body, $p1);
$utf8_body = str_replace_first("/* Font Definitions */", "<style>", $utf8_body);
}
if ($enc_conv->hasError()) {
$utf8_body = utf8_encode(array_var($parsedMail, 'Data', ''));
}
$utf8_body = utf8_safe($utf8_body);
$mail->setBodyHtml($utf8_body);
break;
case 'text':
$utf8_body = $enc_conv->convert($encoding, 'UTF-8', array_var($parsedMail, 'Data', ''));
if ($enc_conv->hasError()) {
$utf8_body = utf8_encode(array_var($parsedMail, 'Data', ''));
}
$utf8_body = utf8_safe($utf8_body);
$mail->setBodyPlain($utf8_body);
break;
case 'delivery-status':
$utf8_body = $enc_conv->convert($encoding, 'UTF-8', array_var($parsedMail, 'Response', ''));
if ($enc_conv->hasError()) {
$utf8_body = utf8_encode(array_var($parsedMail, 'Response', ''));
}
$utf8_body = utf8_safe($utf8_body);
$mail->setBodyPlain($utf8_body);
break;
default:
if (array_var($parsedMail, 'FileDisposition') == 'inline') {
$attachs = array_var($parsedMail, 'Attachments', array());
$attached_body = "";
foreach ($attachs as $k => $attach) {
if (array_var($attach, 'Type') == 'html' || array_var($attach, 'Type') == 'text') {
$attached_body .= $enc_conv->convert(array_var($attach, 'Encoding'), 'UTF-8', array_var($attach, 'Data'));
}
}
$mail->setBodyHtml($attached_body);
}
break;
}
if (isset($parsedMail['Alternative'])) {
foreach ($parsedMail['Alternative'] as $alt) {
if ($alt['Type'] == 'html' || $alt['Type'] == 'text') {
$body = $enc_conv->convert(array_var($alt, 'Encoding', 'UTF-8'), 'UTF-8', array_var($alt, 'Data', ''));
if ($enc_conv->hasError()) {
$body = utf8_encode(array_var($alt, 'Data', ''));
}
// remove large white spaces
$exploded = preg_split("/[\\s]+/", $body, -1, PREG_SPLIT_NO_EMPTY);
$body = implode(" ", $exploded);
// remove html comments
$body = preg_replace('/<!--.*-->/i', '', $body);
}
$body = utf8_safe($body);
if ($alt['Type'] == 'html') {
$mail->setBodyHtml($body);
} else {
if ($alt['Type'] == 'text') {
$plain = html_to_text(html_entity_decode($body, null, "UTF-8"));
$mail->setBodyPlain($plain);
}
}
// other alternative parts (like images) are not saved in database.
}
}
$repository_id = self::SaveContentToFilesystem($mail->getUid(), $content);
$mail->setContentFileId($repository_id);
try {
if ($in_reply_to_id != "") {
if ($message_id != "") {
$conv_mail = MailContents::findOne(array("conditions" => "`account_id`=" . $account->getId() . " AND `in_reply_to_id` = '{$message_id}'"));
if (!$conv_mail) {
$conv_mail = MailContents::findOne(array("conditions" => "`account_id`=" . $account->getId() . " AND `message_id` = '{$in_reply_to_id}'"));
} else {
// Search for other discontinued conversation part to link it
$other_conv_emails = MailContents::findAll(array("conditions" => "`account_id`=" . $account->getId() . " AND `message_id` = '{$in_reply_to_id}' AND `conversation_id`<>" . $conv_mail->getConversationId()));
}
} else {
$conv_mail = MailContents::findOne(array("conditions" => "`account_id`=" . $account->getId() . " AND `message_id` = '{$in_reply_to_id}'"));
}
if ($conv_mail instanceof MailContent) {
// Remove "Re: ", "Fwd: ", etc to compare the subjects
$conv_original_subject = strtolower($conv_mail->getSubject());
if (($pos = strrpos($conv_original_subject, ":")) !== false) {
$conv_original_subject = trim(substr($conv_original_subject, $pos + 1));
}
}
if ($conv_mail instanceof MailContent && $conv_original_subject != "" && strpos(strtolower($mail->getSubject()), strtolower($conv_original_subject)) !== false) {
$mail->setConversationId($conv_mail->getConversationId());
if (isset($other_conv_emails) && is_array($other_conv_emails)) {
foreach ($other_conv_emails as $ocm) {
$ocm->setConversationId($conv_mail->getConversationId());
$ocm->save();
}
}
} else {
$conv_id = MailContents::getNextConversationId($account->getId());
$mail->setConversationId($conv_id);
}
} else {
$conv_id = MailContents::getNextConversationId($account->getId());
$mail->setConversationId($conv_id);
}
$mail->save();
// CLASSIFY RECEIVED MAIL WITH THE CONVERSATION
$member_ids = array();
if (user_config_option('classify_mail_with_conversation', null, $account->getContactId()) && isset($conv_mail) && $conv_mail instanceof MailContent) {
$member_ids = array_merge($member_ids, $conv_mail->getMemberIds());
}
// CLASSIFY MAILS IF THE ACCOUNT HAS A DIMENSION MEMBER
$account_owner = Contacts::findById($account->getContactId());
if ($account->getMemberId() != 0) {
$member = $account->getMember();
if ($member && $member instanceof Member) {
$member_ids[] = $member->getId();
}
}
if (count($member_ids) > 0) {
$ctrl = new ObjectController();
$ctrl->add_to_members($mail, $member_ids, $account_owner);
}
$user = Contacts::findById($account->getContactId());
if ($user instanceof Contact) {
$mail->subscribeUser($user);
}
$mail->addToSharingTable();
// to apply email rules
$null = null;
Hook::fire('after_mail_download', $mail, $null);
} catch (Exception $e) {
FileRepository::deleteFile($repository_id);
if (strpos($e->getMessage(), "Query failed with message 'Got a packet bigger than 'max_allowed_packet' bytes'") === false) {
throw $e;
}
}
unset($parsedMail);
return false;
}
