public static function DataSync($paramUserId = 0)
{
$exchangeScheme = COption::GetOptionString("dav", "exchange_scheme", "http");
$exchangeServer = COption::GetOptionString("dav", "exchange_server", "");
$exchangePort = COption::GetOptionString("dav", "exchange_port", "80");
$exchangeUsername = COption::GetOptionString("dav", "exchange_username", "");
$exchangePassword = COption::GetOptionString("dav", "exchange_password", "");
if (empty($exchangeServer)) {
CAgent::RemoveAgent("CDavExchangeTasks::DataSync();", "dav");
COption::SetOptionString("dav", "agent_tasks", "N");
return "";
}
$exchange = new CDavExchangeTasks($exchangeScheme, $exchangeServer, $exchangePort, $exchangeUsername, $exchangePassword);
$exchangeMailbox = COption::GetOptionString("dav", "exchange_mailbox", "");
$exchangeUseLogin = COption::GetOptionString("dav", "exchange_use_login", "Y");
self::InitUserEntity();
$maxNumber = 5;
$index = 0;
$paramUserId = intval($paramUserId);
$arUserFilter = array("ACTIVE" => "Y", "!UF_DEPARTMENT" => false);
if ($paramUserId > 0) {
$arUserFilter["ID_EQUAL_EXACT"] = $paramUserId;
}
if ($exchangeUseLogin == "N") {
$arUserFilter["!UF_BXDAVEX_MAILBOX"] = false;
}
$arAdditionalExtendedProperties = array(array('DistinguishedPropertySetId' => 'PublicStrings', 'PropertyName' => 'BX_TASKS_GUID', 'PropertyType' => 'String'), array('DistinguishedPropertySetId' => 'PublicStrings', 'PropertyName' => 'BX_TASKS_SERIALIZED_DATA', 'PropertyType' => 'String'));
$dbUserList = CUser::GetList($by = "UF_BXDAVEX_TSKSYNC", $order = "asc", $arUserFilter, array("SELECT" => array("ID", "LOGIN", "UF_BXDAVEX_MAILBOX", "UF_BXDAVEX_TSKSYNC")));
while ($arUser = $dbUserList->Fetch()) {
$index++;
if ($index > $maxNumber) {
break;
}
$GLOBALS["USER_FIELD_MANAGER"]->Update("USER", $arUser["ID"], array("UF_BXDAVEX_TSKSYNC" => ConvertTimeStamp(time(), FULL)));
$mailbox = $exchangeUseLogin == "Y" ? $arUser["LOGIN"] . $exchangeMailbox : $arUser["UF_BXDAVEX_MAILBOX"];
if (empty($mailbox)) {
continue;
}
$arFoldersList = $exchange->GetFoldersList(array("mailbox" => $mailbox));
if (!is_array($arFoldersList)) {
if (DAV_CALDAV_DEBUG) {
CDav::WriteToLog('Error during tasks exchange: $exchange->GetFoldersList() returns unexpected result', '');
}
return;
}
$arUserFolders = array("tasks" => GetMessage("DAV_EC_TASKS"));
foreach ($arFoldersList as $value) {
$arUserFolders[$value["XML_ID"]] = $value["NAME"];
}
$arUserTaskItems = array();
$arUserTaskItemsFolder = array();
foreach ($arUserFolders as $userFolderXmlId => $userFolder) {
$arTaskItemsList = $exchange->GetList(array("mailbox" => $mailbox, "FolderId" => $userFolderXmlId), array("ItemShape" => "IdOnly"), $arAdditionalExtendedProperties);
if (!is_array($arTaskItemsList)) {
if (DAV_CALDAV_DEBUG) {
CDav::WriteToLog('Error during tasks exchange: $exchange->GetList() returns unexpected result', '');
}
return;
}
foreach ($arTaskItemsList as $value) {
$arUserTaskItems[] = array("XML_ID" => $value["XML_ID"], "MODIFICATION_LABEL" => $value["MODIFICATION_LABEL"]);
$arUserTaskItemsFolder[$value["XML_ID"]] = $userFolderXmlId;
}
}
$arModifiedUserTaskItems = CTaskSync::SyncTaskItems("exchange", $arUser["ID"], $arUserTaskItems);
foreach ($arModifiedUserTaskItems as $value) {
$arModifiedTaskItem = $exchange->GetById($value["XML_ID"], $arAdditionalExtendedProperties);
if (is_array($arModifiedTaskItem) && count($arModifiedTaskItem) > 0) {
$arModifiedTaskItem = $arModifiedTaskItem[0];
$arModifyEventArray = array_merge($arModifiedTaskItem, array("ID" => $value["ID"], "USER_ID" => $arUser["ID"], "FOLDER_ID" => $arUserFolders[$arUserTaskItemsFolder[$arModifiedTaskItem["XML_ID"]]]));
//XML_ID, MODIFICATION_LABEL, SUBJECT, BODY, BODY_TYPE, DATE_CREATE, IMPORTANCE, REMINDER_MINUTES_BEFORE_START, ACTUAL_WORK, BILLING_INFORMATION, MILEAGE, START_DATE, DUE_DATE, IS_COMPLETE, IS_RECURRING, PERCENT_COMPLETE, STATUS, STATUS_DESCRIPTION, TOTAL_WORK, OWNER, RECURRING_TYPE, RECURRING_INTERVAL, RECURRING_DAYOFMONTH, RECURRING_DAYSOFWEEK, RECURRING_DAYOFWEEKINDEX, RECURRING_MONTH, RECURRING_STARTDATE, RECURRING_NUMBEROFOCCURRENCES, RECURRING_ENDDATE
CTaskSync::SyncModifyTaskItem($arModifyEventArray);
}
}
}
return "CDavExchangeTasks::DataSync();";
}
/**
* This method is deprecated. Use CTaskItem::delete() instead.
* @deprecated
*/
public static function Delete($ID, $arParams = array())
{
global $DB, $CACHE_MANAGER, $USER;
if (isset($USER) && is_object($USER)) {
$actorUserId = (int) $USER->getId();
} else {
$actorUserId = 1;
}
if (isset($arParams['META::EVENT_GUID'])) {
$eventGUID = $arParams['META::EVENT_GUID'];
unset($arParams['META::EVENT_GUID']);
} else {
$eventGUID = sha1(uniqid('AUTOGUID', true));
}
$paramSkipExchangeSync = false;
if (is_array($arParams)) {
if (isset($arParams['skipExchangeSync']) && ($arParams['skipExchangeSync'] === 'Y' || $arParams['skipExchangeSync'] === true)) {
$paramSkipExchangeSync = true;
}
}
$ID = intval($ID);
if ($ID < 1) {
return false;
}
$rsTask = CTasks::GetByID($ID, false);
if ($arTask = $rsTask->Fetch()) {
foreach (GetModuleEvents('tasks', 'OnBeforeTaskDelete', true) as $arEvent) {
if (ExecuteModuleEventEx($arEvent, array($ID, $arTask)) === false) {
return false;
}
}
CTaskCountersProcessor::onBeforeTaskDelete($ID, $arTask);
CTaskMembers::DeleteByTaskID($ID);
CTaskFiles::DeleteByTaskID($ID);
CTaskDependence::DeleteByTaskID($ID);
CTaskDependence::DeleteByDependsOnID($ID);
CTaskTags::DeleteByTaskID($ID);
$strSql = "DELETE FROM b_tasks_viewed WHERE TASK_ID = " . $ID;
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$strSql = "DELETE FROM b_tasks_reminder WHERE TASK_ID = " . $ID;
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
// clear cache
if ($arTask["GROUP_ID"]) {
$CACHE_MANAGER->ClearByTag("tasks_group_" . $arTask["GROUP_ID"]);
}
$arParticipants = array_unique(array_merge(array($arTask["CREATED_BY"], $arTask["RESPONSIBLE_ID"]), $arTask["ACCOMPLICES"], $arTask["AUDITORS"]));
foreach ($arParticipants as $userId) {
$CACHE_MANAGER->ClearByTag("tasks_user_" . $userId);
}
$strSql = "UPDATE b_tasks_template SET TASK_ID = NULL WHERE TASK_ID = " . $ID;
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$strSql = "UPDATE b_tasks_template SET PARENT_ID = " . ($arTask["PARENT_ID"] ? $arTask["PARENT_ID"] : "NULL") . " WHERE PARENT_ID = " . $ID;
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$strSql = "UPDATE b_tasks SET PARENT_ID = " . ($arTask["PARENT_ID"] ? $arTask["PARENT_ID"] : "NULL") . " WHERE PARENT_ID = " . $ID;
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$strUpdate = $DB->PrepareUpdate("b_tasks", array('ZOMBIE' => 'Y', 'CHANGED_BY' => $actorUserId, 'CHANGED_DATE' => date($DB->DateFormatToPHP(CSite::GetDateFormat('FULL')), time() + CTasksTools::getTimeZoneOffset())), "tasks");
$strSql = "UPDATE b_tasks SET " . $strUpdate . " WHERE ID = " . (int) $ID;
if ($DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__)) {
CTaskNotifications::SendDeleteMessage($arTask);
if ($arTask["FORUM_TOPIC_ID"] && CModule::IncludeModule("forum")) {
CForumTopic::Delete($arTask["FORUM_TOPIC_ID"]);
}
if (!$paramSkipExchangeSync) {
CTaskSync::DeleteItem($arTask);
}
// MS Exchange
// Emit pull event
try {
$arPullRecipients = array();
foreach ($arParticipants as $userId) {
$arPullRecipients[] = (int) $userId;
}
$taskGroupId = 0;
// no group
if (isset($arTask['GROUP_ID']) && $arTask['GROUP_ID'] > 0) {
$taskGroupId = (int) $arTask['GROUP_ID'];
}
$arPullData = array('TASK_ID' => (int) $ID, 'BEFORE' => array('GROUP_ID' => $taskGroupId), 'TS' => time(), 'event_GUID' => $eventGUID);
self::EmitPullWithTagPrefix($arPullRecipients, 'TASKS_GENERAL_', 'task_remove', $arPullData);
self::EmitPullWithTag($arPullRecipients, 'TASKS_TASK_' . (int) $ID, 'task_remove', $arPullData);
} catch (Exception $e) {
}
foreach (GetModuleEvents('tasks', 'OnTaskDelete', true) as $arEvent) {
ExecuteModuleEventEx($arEvent, array($ID));
}
if (CModule::IncludeModule("search")) {
CSearch::DeleteIndex("tasks", $ID);
}
}
return true;
}
return false;
}
