public static function ConvertTasks($checkPerms = true, $regEvent = true)
{
if (!(IsModuleInstalled('tasks') && CModule::IncludeModule('tasks'))) {
return 0;
}
$taskEntity = new CTasks();
$dbRes = $taskEntity->GetList(array(), array('!UF_CRM_TASK' => null), array('ID', 'TITLE', 'DESCRIPTION', 'RESPONSIBLE_ID', 'PRIORITY', 'STATUS', 'CREATED_DATE', 'DATE_START', 'CLOSED_DATE', 'START_DATE_PLAN', 'END_DATE_PLAN', 'DEADLINE', 'UF_CRM_TASK'), false);
$total = 0;
while ($arTask = $dbRes->GetNext()) {
$taskID = intval($arTask['ID']);
$count = CCrmActivity::GetCount(array('=TYPE_ID' => CCrmActivityType::Task, '=ASSOCIATED_ENTITY_ID' => $taskID));
if ($count === 0 && CCrmActivity::CreateFromTask($taskID, $arTask, $checkPerms, $regEvent) > 0) {
$total++;
}
}
return $total;
}
$data = isset($_REQUEST['ENTITY_DATA']) && is_array($_REQUEST['ENTITY_DATA']) ? $_REQUEST['ENTITY_DATA'] : array();
if (count($data) == 0) {
__CrmMobileActivityEditEndResonse(array('ERROR' => GetMessage('CRM_ENTITY_DATA_NOT_FOUND')));
}
$ID = isset($data['ID']) ? intval($data['ID']) : 0;
if ($ID <= 0) {
__CrmMobileActivityEditEndResonse(array('ERROR' => GetMessage('CRM_ENTITY_ID_NOT_FOUND')));
}
$dbItem = CCrmActivity::GetList(array(), array('=ID' => $ID), false, false, array('OWNER_TYPE_ID', 'OWNER_ID'));
$item = $dbItem->Fetch();
if (!is_array($item)) {
__CrmMobileActivityEditEndResonse(array('ERROR' => GetMessage('CRM_ACTIVITY_NOT_FOUND', array('#ID#' => $ID))));
}
$ownerTypeID = isset($item['OWNER_TYPE_ID']) ? intval($item['OWNER_TYPE_ID']) : 0;
$ownerID = isset($item['OWNER_ID']) ? intval($item['OWNER_ID']) : 0;
if (!CCrmActivity::CheckUpdatePermission($ownerTypeID, $ownerID)) {
__CrmMobileActivityEditEndResonse(array('ERROR' => 'Access denied.'));
}
$completed = (isset($data['COMPLETED']) ? intval($data['COMPLETED']) : 0) > 0;
if (CCrmActivity::Complete($ID, $completed, array('REGISTER_SONET_EVENT' => true))) {
$dbRes = CCrmActivity::GetList(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => 'N'));
$currentItem = $dbRes->Fetch();
$formatParams = isset($_REQUEST['FORMAT_PARAMS']) ? $_REQUEST['FORMAT_PARAMS'] : array();
CCrmMobileHelper::PrepareActivityItem($currentItem, $formatParams, array('ENABLE_COMMUNICATIONS' => true));
__CrmMobileActivityEditEndResonse(array('SAVED_ENTITY_ID' => $ID, 'SAVED_ENTITY_DATA' => CCrmMobileHelper::PrepareActivityData($currentItem)));
} else {
__CrmMobileActivityEditEndResonse(array('ERROR' => CCrmActivity::GetLastErrorMessage()));
}
} else {
__CrmMobileActivityEditEndResonse(array('ERROR' => 'Action is not supported in current context.'));
}
}
CCrmDeal::SaveProductRows($dealID, array(array('PRODUCT_ID' => intval($arProduct['ID']), 'PRICE' => doubleval($arProduct['PRICE']), 'QUANTITY' => 1)));
}
}
}
// Add event
require_once "event.demo.php";
$CCrmEvent = new CCrmEvent();
foreach ($arEvents as $ID => $arParams) {
$arEvents[$ID]['ID'] = $CCrmEvent->Add($arParams);
}
// Add relation
$arParams = array('COMPANY_ID' => $arCompany['39']['ID'], 'CONTACT_ID' => $arContacts['51']['ID']);
$CCrmLead->Update($arLeads['57']['ID'], $arParams);
// Add activity
require_once "activity.demo.php";
$CCrmActivity = new CCrmActivity();
foreach ($arActivities as $ID => $arParams) {
$activityId = $CCrmActivity->Add($arParams["FIELDS"], false, false);
CCrmActivity::SaveCommunications($activityId, array($arParams["COMMUNICATIONS"]), $arParams["FIELDS"], false, false);
}
//Add invoice
CCrmInvoice::installDisableSaleEvents();
require_once "invoice.demo.php";
$CCrmInvoice = new CCrmInvoice();
$b_false = false;
foreach ($arInvoices as $arInvoice) {
$CCrmInvoice->Add($arInvoice, $b_false, WIZARD_SITE_ID);
}
}
COption::SetOptionString("crm", "form_features", "N");
// <-- Convert LEAD CURRENCY and PRODUCT
// Convert DEAL EVENTS -->
if (COption::GetOptionString('crm', '~CRM_DEAL_EVENT_CONVERT_11_5_7', 'N') !== 'Y') {
$dbDeals = CCrmDeal::GetListEx(array(), array('@EVENT_ID' => array('PHONE', 'INFO')), false, false, array());
while ($arDeal = $dbDeals->Fetch()) {
CCrmActivity::CreateFromDealEvent($arDeal);
}
COption::SetOptionString('crm', '~CRM_DEAL_EVENT_CONVERT_11_5_7', 'Y');
}
// <-- Convert DEAL EVENTS
// SETUP DEFAULT RESPONSIBLE FOR COMPANIES-->
if (COption::GetOptionString('crm', '~CRM_COMPANY_RESPONSIBLE_11_5_7', 'N') !== 'Y') {
try {
if (CCrmCompany::SetDefaultResponsible(true)) {
COption::SetOptionString('crm', '~CRM_COMPANY_RESPONSIBLE_11_5_7', 'Y');
}
} catch (Exception $e) {
}
}
// FIX FOR CALENDAR EVENT BINBINGS-->
if (COption::GetOptionString('crm', '~CRM_CAL_EVENT_BINDING_12_0_4', 'N') !== 'Y') {
try {
if ($DB->TableExists('b_crm_act')) {
CCrmActivity::RefreshCalendarBindings();
COption::SetOptionString('crm', '~CRM_CAL_EVENT_BINDING_12_0_4', 'Y');
}
} catch (Exception $e) {
}
}
//<-- FIX FOR CALENDAR EVENT BINBINGS
}
function Fetch()
{
if ($result = parent::Fetch()) {
if (array_key_exists('SETTINGS', $result)) {
$result['SETTINGS'] = is_string($result['SETTINGS']) ? unserialize($result['SETTINGS']) : array();
}
if ($this->selectCommunications) {
$result['COMMUNICATIONS'] = CCrmActivity::GetCommunications($result['ID']);
}
}
return $result;
}
/**
* This is not a part of public API.
* This function is for internal use only.
*
* @access private
*/
public static function onAfterCommentUpdate($entityType, $taskID, $arData)
{
// 'TK' is our entity type
if ($entityType !== 'TK') {
return;
}
if (empty($arData["MESSAGE_ID"])) {
return;
}
$arMessage = false;
if (CModule::IncludeModule("socialnetwork")) {
$parser = new CTextParser();
$parser->allow = array("HTML" => 'Y', "ANCHOR" => 'Y', "BIU" => 'Y', "IMG" => "Y", "VIDEO" => "Y", "LIST" => 'N', "QUOTE" => 'Y', "CODE" => 'Y', "FONT" => 'Y', "SMILES" => "N", "UPLOAD" => 'N', "NL2BR" => 'N', "TABLE" => "Y");
$oTask = CTaskItem::getInstance($taskID, CTasksTools::GetCommanderInChief());
$arTask = $oTask->getData();
$bCrmTask = isset($arTask["UF_CRM_TASK"]) && (is_array($arTask["UF_CRM_TASK"]) && (isset($arTask["UF_CRM_TASK"][0]) && strlen($arTask["UF_CRM_TASK"][0]) > 0) || !is_array($arTask["UF_CRM_TASK"]) && strlen($arTask["UF_CRM_TASK"]) > 0);
switch ($arData["ACTION"]) {
case "DEL":
case "HIDE":
$dbLogComment = CSocNetLogComments::GetList(array("ID" => "DESC"), array("EVENT_ID" => $bCrmTask ? array('crm_activity_add_comment') : array('tasks_comment'), "SOURCE_ID" => intval($arData["MESSAGE_ID"])), false, false, array("ID"));
while ($arLogComment = $dbLogComment->Fetch()) {
CSocNetLogComments::Delete($arLogComment["ID"]);
}
break;
case "SHOW":
$dbLogComment = CSocNetLogComments::GetList(array("ID" => "DESC"), array("EVENT_ID" => $bCrmTask ? array('crm_activity_add_comment') : array('tasks_comment'), "SOURCE_ID" => intval($arData["MESSAGE_ID"])), false, false, array("ID"));
$arLogComment = $dbLogComment->Fetch();
if (!$arLogComment) {
$arMessage = CForumMessage::GetByID(intval($arData["MESSAGE_ID"]));
if ($arMessage) {
$arFilter = false;
if (!$bCrmTask) {
$arFilter = array("EVENT_ID" => "tasks", "SOURCE_ID" => $taskID);
} elseif (CModule::IncludeModule("crm")) {
$dbCrmActivity = CCrmActivity::GetList(array(), array('TYPE_ID' => CCrmActivityType::Task, 'ASSOCIATED_ENTITY_ID' => $taskID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('ID'));
if ($arCrmActivity = $dbCrmActivity->Fetch()) {
$arFilter = array("EVENT_ID" => "crm_activity_add", "ENTITY_ID" => $arCrmActivity["ID"]);
}
}
if ($arFilter) {
$dbLog = CSocNetLog::GetList(array("ID" => "DESC"), $arFilter, false, false, array("ID", "ENTITY_TYPE", "ENTITY_ID"));
if ($arLog = $dbLog->Fetch()) {
$log_id = $arLog["ID"];
$entity_type = $arLog["ENTITY_TYPE"];
$entity_id = $arLog["ENTITY_ID"];
} else {
$entity_type = $arTask["GROUP_ID"] ? SONET_ENTITY_GROUP : SONET_ENTITY_USER;
$entity_id = $arTask["GROUP_ID"] ? $arTask["GROUP_ID"] : $arTask["CREATED_BY"];
$rsUser = CUser::GetByID($arTask["CREATED_BY"]);
if ($arUser = $rsUser->Fetch()) {
$arSoFields = array("ENTITY_TYPE" => $entity_type, "ENTITY_ID" => $entity_id, "EVENT_ID" => "tasks", "LOG_DATE" => $arTask["CREATED_DATE"], "TITLE_TEMPLATE" => "#TITLE#", "TITLE" => $arTask["TITLE"], "MESSAGE" => "", "TEXT_MESSAGE" => $strMsgNewTask, "MODULE_ID" => "tasks", "CALLBACK_FUNC" => false, "SOURCE_ID" => $taskID, "ENABLE_COMMENTS" => "Y", "USER_ID" => $arTask["CREATED_BY"], "URL" => CTaskNotifications::GetNotificationPath($arUser, $taskID), "PARAMS" => serialize(array("TYPE" => "create")));
$log_id = CSocNetLog::Add($arSoFields, false);
if (intval($log_id) > 0) {
$arRights = CTaskNotifications::__UserIDs2Rights(self::getTaskMembersByTaskId($taskID));
if ($arTask["GROUP_ID"]) {
$arRights[] = "S" . SONET_ENTITY_GROUP . $arTask["GROUP_ID"];
}
CSocNetLogRights::Add($log_id, $arRights);
}
}
}
}
if ($log_id > 0) {
$sText = COption::GetOptionString("forum", "FILTER", "Y") == "Y" ? $arMessage["POST_MESSAGE_FILTER"] : $arMessage["POST_MESSAGE"];
$strURL = $GLOBALS['APPLICATION']->GetCurPageParam("", array("IFRAME", "MID", "SEF_APPLICATION_CUR_PAGE_URL", BX_AJAX_PARAM_ID, "result"));
$strURL = ForumAddPageParams($strURL, array("MID" => intval($arData["MESSAGE_ID"]), "result" => "reply"), false, false);
$arFieldsForSocnet = array("ENTITY_TYPE" => $entity_type, "ENTITY_ID" => $entity_id, "EVENT_ID" => $bCrmTask ? 'crm_activity_add_comment' : 'tasks_comment', "MESSAGE" => $sText, "TEXT_MESSAGE" => $parser->convert4mail($sText), "URL" => str_replace("?IFRAME=Y", "", str_replace("&IFRAME=Y", "", str_replace("IFRAME=Y&", "", $strURL))), "MODULE_ID" => "tasks", "SOURCE_ID" => intval($arData["MESSAGE_ID"]), "LOG_ID" => $log_id, "RATING_TYPE_ID" => "FORUM_POST", "RATING_ENTITY_ID" => intval($arData["MESSAGE_ID"]));
$arFieldsForSocnet["USER_ID"] = $arMessage["AUTHOR_ID"];
$arFieldsForSocnet["=LOG_DATE"] = $GLOBALS["DB"]->CurrentTimeFunction();
$ufFileID = array();
$dbAddedMessageFiles = CForumFiles::GetList(array("ID" => "ASC"), array("MESSAGE_ID" => intval($arData["MESSAGE_ID"])));
while ($arAddedMessageFiles = $dbAddedMessageFiles->Fetch()) {
$ufFileID[] = $arAddedMessageFiles["FILE_ID"];
}
if (count($ufFileID) > 0) {
$arFieldsForSocnet["UF_SONET_COM_FILE"] = $ufFileID;
}
$ufDocID = $GLOBALS["USER_FIELD_MANAGER"]->GetUserFieldValue("FORUM_MESSAGE", "UF_FORUM_MESSAGE_DOC", intval($arData["MESSAGE_ID"]), LANGUAGE_ID);
if ($ufDocID) {
$arFieldsForSocnet["UF_SONET_COM_DOC"] = $ufDocID;
}
$comment_id = CSocNetLogComments::Add($arFieldsForSocnet, false, false);
CSocNetLog::CounterIncrement($comment_id, false, false, "LC");
}
}
}
break;
case "EDIT":
$arMessage = CForumMessage::GetByID(intval($arData["MESSAGE_ID"]));
if ($arMessage) {
$dbLogComment = CSocNetLogComments::GetList(array("ID" => "DESC"), array("EVENT_ID" => $bCrmTask ? 'crm_activity_add_comment' : 'tasks_comment', "SOURCE_ID" => intval($arData["MESSAGE_ID"])), false, false, array("ID", "LOG_ID"));
$arLogComment = $dbLogComment->Fetch();
if ($arLogComment) {
$sText = COption::GetOptionString("forum", "FILTER", "Y") == "Y" ? $arMessage["POST_MESSAGE_FILTER"] : $arMessage["POST_MESSAGE"];
$arFieldsForSocnet = array("LOG_ID" => intval($arLogComment["LOG_ID"]), "MESSAGE" => $sText, "TEXT_MESSAGE" => $parser->convert4mail($sText));
$ufFileID = array();
$arFilesIds = array();
$taskId = null;
if (isset($arData['PARAMS']['PARAM2']) && !empty($arData['PARAMS']['PARAM2'])) {
$taskId = (int) $arData['PARAMS']['PARAM2'];
}
$dbAddedMessageFiles = CForumFiles::GetList(array("ID" => "ASC"), array("MESSAGE_ID" => intval($arData["MESSAGE_ID"])));
while ($arAddedMessageFiles = $dbAddedMessageFiles->Fetch()) {
$ufFileID[] = $arAddedMessageFiles["FILE_ID"];
$arFilesIds[] = $arAddedMessageFiles["FILE_ID"];
}
if (count($ufFileID) > 0) {
$arFieldsForSocnet["UF_SONET_COM_FILE"] = $ufFileID;
}
$ufDocID = $GLOBALS["USER_FIELD_MANAGER"]->GetUserFieldValue("FORUM_MESSAGE", "UF_FORUM_MESSAGE_DOC", intval($arData["MESSAGE_ID"]), LANGUAGE_ID);
if ($ufDocID) {
$arFieldsForSocnet["UF_SONET_COM_DOC"] = $ufDocID;
if (is_array($ufDocID)) {
$arFilesIds = array_merge($arFilesIds, $ufDocID);
}
}
$ufUrlPreview = $GLOBALS["USER_FIELD_MANAGER"]->GetUserFieldValue("FORUM_MESSAGE", "UF_FORUM_MES_URL_PRV", intval($arData["MESSAGE_ID"]), LANGUAGE_ID);
if ($ufUrlPreview) {
$arFieldsForSocnet["UF_SONET_COM_URL_PRV"] = $ufUrlPreview;
}
if ($taskId && !empty($arFilesIds)) {
self::addFilesRights($taskId, $arFilesIds);
}
CSocNetLogComments::Update($arLogComment["ID"], $arFieldsForSocnet);
}
}
break;
default:
}
}
// add records to log. only EDIT and DEL actions handled
// here may be edit or delete
if ($arData['ACTION'] == 'EDIT' || $arData['ACTION'] == 'DEL') {
$messageAuthorId = null;
$messageEditDate = null;
$messagePostDate = null;
if ($arData['ACTION'] == 'EDIT') {
if (array_key_exists('AUTHOR_ID', $arData['PARAMS']) && array_key_exists('EDIT_DATE', $arData['PARAMS']) && array_key_exists('POST_DATE', $arData['PARAMS'])) {
$messageAuthorId = $arData['PARAMS']['AUTHOR_ID'];
$messageEditDate = $arData['PARAMS']['EDIT_DATE'];
$messageEditDate = $arData['PARAMS']['POST_DATE'];
} else {
if ($arMessage === false) {
$arMessage = CForumMessage::GetByID($messageId);
}
$messageAuthorId = $arMessage['AUTHOR_ID'];
$messageEditDate = $arMessage['EDIT_DATE'];
$messageEditDate = $arMessage['POST_DATE'];
}
$createdDate = $messageEditDate ? ConvertTimeStamp(MakeTimeStamp($messageEditDate, CSite::GetDateFormat()), "FULL") : $messagePostDate;
} else {
// in case of DEL action, there is no PARAMS passed in $arData, so this is a temporal fix
$messageAuthorId = is_object($GLOBALS['USER']) && method_exists($GLOBALS['USER'], 'getId') ? $GLOBALS['USER']->getId() : CTasksTools::GetCommanderInChief();
//$arData['PARAMS']['AUTHOR_ID'];
$createdDate = ConvertTimeStamp(time(), "FULL");
}
// Tasks log
$arLogFields = array("TASK_ID" => (int) $taskID, "USER_ID" => static::getOccurAsUserId($messageAuthorId), "CREATED_DATE" => $createdDate, "FIELD" => "COMMENT_" . $arData['ACTION'], "TO_VALUE" => $arData['MESSAGE_ID']);
$log = new CTaskLog();
$log->Add($arLogFields);
}
}
public static function DeleteCrmActivityComment($arFields)
{
if (!isset($arFields["SOURCE_ID"]) || intval($arFields["SOURCE_ID"]) <= 0) {
return array("NO_SOURCE" => "Y");
}
$dbResult = CSocNetLog::GetList(array(), array("ID" => $arFields["LOG_ID"]), false, false, array('ID', 'ENTITY_ID'));
if ($arLog = $dbResult->Fetch()) {
$dbCrmActivity = CCrmActivity::GetList(array(), array('ID' => $arLog['ENTITY_ID'], 'CHECK_PERMISSIONS' => 'N'));
if ($arCrmActivity = $dbCrmActivity->Fetch()) {
if ($arCrmActivity['TYPE_ID'] == CCrmActivityType::Task) {
if (CModule::IncludeModule("forum")) {
$res = ForumActions("DEL", array("MID" => intval($arFields["SOURCE_ID"])), $strErrorMessage, $strOKMessage);
return array("ERROR" => $strErrorMessage, "NOTES" => $strOKMessage);
} else {
return array("ERROR" => GetMessage("CRM_SL_DELETE_COMMENT_SOURCE_ERROR_FORUM_NOT_INSTALLED"), "NOTES" => false);
}
} else {
return array("NO_SOURCE" => "Y");
}
} else {
return array("NO_SOURCE" => "Y");
}
} else {
return array("NO_SOURCE" => "Y");
}
}
public static function GetResponsibleID($typeID, $ID, $checkRights = true)
{
$typeID = intval($typeID);
$ID = intval($ID);
if (!(self::IsDefined($typeID) && $ID > 0)) {
return 0;
}
$key = "{$typeID}_{$ID}";
if (isset(self::$RESPONSIBLES[$key])) {
return self::$RESPONSIBLES[$key];
}
$result = 0;
switch ($typeID) {
case self::Lead:
$dbRes = CCrmLead::GetListEx(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => $checkRights ? 'Y' : 'N'), false, false, array('ASSIGNED_BY_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['ASSIGNED_BY_ID']) : 0;
break;
case self::Contact:
$dbRes = CCrmContact::GetListEx(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => $checkRights ? 'Y' : 'N'), false, false, array('ASSIGNED_BY_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['ASSIGNED_BY_ID']) : 0;
break;
case self::Company:
$dbRes = CCrmCompany::GetListEx(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => $checkRights ? 'Y' : 'N'), false, false, array('ASSIGNED_BY_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['ASSIGNED_BY_ID']) : 0;
break;
case self::Deal:
$dbRes = CCrmDeal::GetListEx(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => $checkRights ? 'Y' : 'N'), false, false, array('ASSIGNED_BY_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['ASSIGNED_BY_ID']) : 0;
break;
case self::Invoice:
$dbRes = CCrmInvoice::GetList(array(), array('ID' => $ID), false, false, array('RESPONSIBLE_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['RESPONSIBLE_ID']) : 0;
break;
case self::Activity:
$dbRes = CCrmActivity::GetList(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => $checkRights ? 'Y' : 'N'), false, false, array('RESPONSIBLE_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['RESPONSIBLE_ID']) : 0;
break;
case self::Quote:
$dbRes = CCrmQuote::GetList(array(), array('=ID' => $ID, 'CHECK_PERMISSIONS' => $checkRights ? 'Y' : 'N'), false, false, array('ASSIGNED_BY_ID'));
$arRes = $dbRes ? $dbRes->Fetch() : null;
$result = $arRes ? intval($arRes['ASSIGNED_BY_ID']) : 0;
break;
}
self::$RESPONSIBLES[$key] = $result;
return $result;
}
public static function AttachRecordToCall($params)
{
if (!CModule::IncludeModule('crm')) {
return false;
}
CVoxImplantHistory::WriteToLog($params, 'CRM ATTACH RECORD TO CALL');
if ($params['CALL_WEBDAV_ID'] > 0) {
$activityId = CCrmActivity::GetIDByOrigin('VI_' . $params['CALL_ID']);
if ($activityId) {
$arFields['STORAGE_TYPE_ID'] = CCrmActivity::GetDefaultStorageTypeID();
$arFields['STORAGE_ELEMENT_IDS'] = array($params['CALL_WEBDAV_ID']);
CCrmActivity::Update($activityId, $arFields, false);
}
}
return true;
}
function GetCrmEntityCommunications($entityType, $entityID, $communicationType)
{
$fullNameFormat = \Bitrix\Crm\Format\PersonNameFormatter::getFormat();
if ($entityType === 'LEAD') {
$data = array('ownerEntityType' => 'LEAD', 'ownerEntityId' => $entityID, 'entityType' => 'LEAD', 'entityId' => $entityID, 'entityTitle' => "{$entityType}_{$entityID}", 'entityDescription' => '', 'tabId' => 'main', 'communications' => array());
$entity = CCrmLead::GetByID($entityID);
if (!$entity) {
return array('ERROR' => 'Invalid data');
}
// Prepare title
$name = isset($entity['NAME']) ? $entity['NAME'] : '';
$secondName = isset($entity['SECOND_NAME']) ? $entity['SECOND_NAME'] : '';
$lastName = isset($entity['LAST_NAME']) ? $entity['LAST_NAME'] : '';
if ($name !== '' || $secondName !== '' || $lastName !== '') {
$data['entityTitle'] = CUser::FormatName($fullNameFormat, array('LOGIN' => '', 'NAME' => $name, 'SECOND_NAME' => $secondName, 'LAST_NAME' => $lastName), false, false);
$data['entityDescription'] = isset($entity['TITLE']) ? $entity['TITLE'] : '';
} else {
$data['entityTitle'] = isset($entity['TITLE']) ? $entity['TITLE'] : '';
$data['entityDescription'] = '';
}
// Try to load entity communications
if (!CCrmActivity::CheckReadPermission(CCrmOwnerType::ResolveID($entityType), $entityID)) {
return array('ERROR' => GetMessage('CRM_PERMISSION_DENIED'));
}
if ($communicationType !== '') {
$dbResFields = CCrmFieldMulti::GetList(array('ID' => 'asc'), array('ENTITY_ID' => $entityType, 'ELEMENT_ID' => $entityID, 'TYPE_ID' => $communicationType));
while ($arField = $dbResFields->Fetch()) {
if (empty($arField['VALUE'])) {
continue;
}
$comm = array('type' => $communicationType, 'value' => $arField['VALUE']);
$data['communications'][] = $comm;
}
}
return array('DATA' => array('TABS' => array(array('id' => 'lead', 'title' => GetMessage('CRM_COMMUNICATION_TAB_LEAD'), 'active' => true, 'items' => array($data)))));
} elseif ($entityType === 'DEAL') {
$entity = CCrmDeal::GetByID($entityID);
if (!$entity) {
return array('ERROR' => 'Invalid data');
}
$dealData = array();
// Prepare company data
$entityCompanyData = null;
$entityCompanyID = isset($entity['COMPANY_ID']) ? intval($entity['COMPANY_ID']) : 0;
$entityCompany = $entityCompanyID > 0 ? CCrmCompany::GetByID($entityCompanyID) : null;
if (is_array($entityCompany)) {
$entityCompanyData = array('ownerEntityType' => 'DEAL', 'ownerEntityId' => $entityID, 'entityType' => 'COMPANY', 'entityId' => $entityCompanyID, 'entityTitle' => isset($entityCompany['TITLE']) ? $entityCompany['TITLE'] : '', 'entityDescription' => '', 'communications' => array());
if ($communicationType !== '') {
$entityCompanyComms = CCrmActivity::PrepareCommunications('COMPANY', $entityCompanyID, $communicationType);
foreach ($entityCompanyComms as &$entityCompanyComm) {
$comm = array('type' => $entityCompanyComm['TYPE'], 'value' => $entityCompanyComm['VALUE']);
$entityCompanyData['communications'][] = $comm;
}
unset($entityCompanyComm);
}
}
// Try to get contact of deal
$entityContactID = isset($entity['CONTACT_ID']) ? intval($entity['CONTACT_ID']) : 0;
if ($entityContactID > 0) {
$entityContact = CCrmContact::GetByID($entityContactID);
if (is_array($entityContact)) {
$item = array('ownerEntityType' => 'DEAL', 'ownerEntityId' => $entityID, 'entityType' => 'CONTACT', 'entityId' => $entityContactID, 'entityTitle' => CUser::FormatName($fullNameFormat, array('LOGIN' => '', 'NAME' => $entityContact['NAME'], 'LAST_NAME' => $entityContact['LAST_NAME'], 'SECOND_NAME' => $entityContact['SECOND_NAME']), false, false), 'tabId' => 'deal', 'communications' => array());
$entityCompany = isset($entityContact['COMPANY_ID']) ? CCrmCompany::GetByID($entityContact['COMPANY_ID']) : null;
if ($entityCompany && isset($entityCompany['TITLE'])) {
$item['entityDescription'] = $entityCompany['TITLE'];
}
if ($communicationType !== '') {
$entityContactComms = CCrmActivity::PrepareCommunications('CONTACT', $entityContactID, $communicationType);
foreach ($entityContactComms as &$entityContactComm) {
$comm = array('type' => $entityContactComm['TYPE'], 'value' => $entityContactComm['VALUE']);
$item['communications'][] = $comm;
}
unset($entityContactComm);
}
if ($communicationType === '' || !empty($item['communications'])) {
$dealData["CONTACT_{$entityContactID}"] = $item;
}
}
}
if ($entityCompanyData && !empty($entityCompanyData['communications'])) {
$dealData['COMPANY_' . $entityCompanyID] = $entityCompanyData;
$dealData['COMPANY_' . $entityCompanyID]['tabId'] = 'deal';
}
// Try to get previous communications
$entityComms = CCrmActivity::GetCommunicationsByOwner('DEAL', $entityID, $communicationType);
foreach ($entityComms as &$entityComm) {
CCrmActivity::PrepareCommunicationInfo($entityComm);
$key = "{$entityComm['ENTITY_TYPE']}_{$entityComm['ENTITY_ID']}";
if (!isset($dealData[$key])) {
$dealData[$key] = array('ownerEntityType' => 'DEAL', 'ownerEntityId' => $entityID, 'entityType' => CCrmOwnerType::ResolveName($entityComm['ENTITY_TYPE_ID']), 'entityId' => $entityComm['ENTITY_ID'], 'entityTitle' => isset($entityComm['TITLE']) ? $entityComm['TITLE'] : '', 'entityDescription' => isset($entityComm['DESCRIPTION']) ? $entityComm['DESCRIPTION'] : '', 'tabId' => 'deal', 'communications' => array());
}
if ($communicationType !== '') {
$commFound = false;
foreach ($dealData[$key]['communications'] as &$comm) {
if ($comm['value'] === $entityComm['VALUE']) {
$commFound = true;
break;
}
}
unset($comm);
if ($commFound) {
continue;
}
$comm = array('type' => $entityComm['TYPE'], 'value' => $entityComm['VALUE']);
$dealData[$key]['communications'][] = $comm;
}
}
unset($entityComm);
$companyData = array();
// Try to get contacts of company
if ($entityCompany > 0) {
$entityComms = CCrmActivity::GetCompanyCommunications($entityCompanyID, $communicationType);
foreach ($entityComms as &$entityComm) {
CCrmActivity::PrepareCommunicationInfo($entityComm);
$key = "{$entityComm['ENTITY_TYPE']}_{$entityComm['ENTITY_ID']}";
if (!isset($companyData[$key])) {
$companyData[$key] = array('ownerEntityType' => 'DEAL', 'ownerEntityId' => $entityID, 'entityType' => CCrmOwnerType::ResolveName($entityComm['ENTITY_TYPE_ID']), 'entityId' => $entityComm['ENTITY_ID'], 'entityTitle' => isset($entityComm['TITLE']) ? $entityComm['TITLE'] : '', 'entityDescription' => isset($entityComm['DESCRIPTION']) ? $entityComm['DESCRIPTION'] : '', 'tabId' => 'company', 'communications' => array());
}
if ($communicationType !== '') {
$comm = array('type' => $entityComm['TYPE'], 'value' => $entityComm['VALUE']);
$companyData[$key]['communications'][] = $comm;
}
}
unset($entityComm);
}
if ($entityCompanyData && !empty($entityCompanyData['communications'])) {
$companyData['COMPANY_' . $entityCompanyID] = $entityCompanyData;
$companyData['COMPANY_' . $entityCompanyID]['tabId'] = 'company';
}
return array('DATA' => array('TABS' => array(array('id' => 'deal', 'title' => GetMessage('CRM_COMMUNICATION_TAB_DEAL'), 'active' => true, 'items' => array_values($dealData)), array('id' => 'company', 'title' => GetMessage('CRM_COMMUNICATION_TAB_COMPANY'), 'items' => array_values($companyData)))));
} elseif ($entityType === 'COMPANY') {
$companyData = array();
$entity = CCrmCompany::GetByID($entityID);
if (!$entity) {
return array('ERROR' => 'Invalid data');
}
$companyItem = array('ownerEntityType' => 'COMPANY', 'ownerEntityId' => $entityID, 'entityType' => 'COMPANY', 'entityId' => $entityID, 'entityTitle' => isset($entity['TITLE']) ? $entity['TITLE'] : "{$entityType}_{$entityID}", 'entityDescription' => '', 'tabId' => 'company', 'communications' => array());
// Try to load entity communications
if (!CCrmActivity::CheckReadPermission(CCrmOwnerType::ResolveID($entityType), $entityID)) {
return array('ERROR' => GetMessage('CRM_PERMISSION_DENIED'));
}
if ($communicationType !== '') {
$dbResFields = CCrmFieldMulti::GetList(array('ID' => 'asc'), array('ENTITY_ID' => $entityType, 'ELEMENT_ID' => $entityID, 'TYPE_ID' => $communicationType));
while ($arField = $dbResFields->Fetch()) {
if (empty($arField['VALUE'])) {
continue;
}
$comm = array('type' => $communicationType, 'value' => $arField['VALUE']);
$companyItem['communications'][] = $comm;
}
}
$companyData["{$entityType}_{$entityID}"] = $companyItem;
if ($communicationType !== '') {
$entityComms = CCrmActivity::GetCompanyCommunications($entityID, $communicationType, 50);
foreach ($entityComms as &$entityComm) {
CCrmActivity::PrepareCommunicationInfo($entityComm);
$key = "{$entityComm['ENTITY_TYPE']}_{$entityComm['ENTITY_ID']}";
if (!isset($companyData[$key])) {
$companyData[$key] = array('ownerEntityType' => 'COMPANY', 'ownerEntityId' => $entityID, 'entityType' => $entityComm['ENTITY_TYPE'], 'entityId' => $entityComm['ENTITY_ID'], 'entityTitle' => isset($entityComm['TITLE']) ? $entityComm['TITLE'] : '', 'entityDescription' => isset($entityComm['DESCRIPTION']) ? $entityComm['DESCRIPTION'] : '', 'tabId' => 'company', 'communications' => array());
}
$comm = array('type' => $entityComm['TYPE'], 'value' => $entityComm['VALUE']);
$companyData[$key]['communications'][] = $comm;
}
unset($entityComm);
}
return array('DATA' => array('TABS' => array(array('id' => 'company', 'title' => GetMessage('CRM_COMMUNICATION_TAB_COMPANY'), 'active' => true, 'items' => array_values($companyData)))));
} elseif ($entityType === 'CONTACT') {
$contactData = array();
$entity = CCrmContact::GetByID($entityID);
if (!$entity) {
return array('ERROR' => 'Invalid data');
}
$entityCompany = isset($entity['COMPANY_ID']) ? CCrmCompany::GetByID($entity['COMPANY_ID']) : null;
$contactItem = array('ownerEntityType' => 'CONTACT', 'ownerEntityId' => $entityID, 'entityType' => 'CONTACT', 'entityId' => $entityID, 'entityTitle' => CUser::FormatName($fullNameFormat, array('LOGIN' => '', 'NAME' => $entity['NAME'], 'LAST_NAME' => $entity['LAST_NAME'], 'SECOND_NAME' => $entity['SECOND_NAME']), false, false), 'entityDescription' => $entityCompany && isset($entityCompany['TITLE']) ? $entityCompany['TITLE'] : '', 'tabId' => 'contact', 'communications' => array());
// Try to load entity communications
if (!CCrmActivity::CheckReadPermission(CCrmOwnerType::ResolveID($entityType), $entityID)) {
return array('ERROR' => GetMessage('CRM_PERMISSION_DENIED'));
}
if ($communicationType !== '') {
$dbResFields = CCrmFieldMulti::GetList(array('ID' => 'asc'), array('ENTITY_ID' => $entityType, 'ELEMENT_ID' => $entityID, 'TYPE_ID' => $communicationType));
while ($arField = $dbResFields->Fetch()) {
if (empty($arField['VALUE'])) {
continue;
}
$comm = array('type' => $communicationType, 'value' => $arField['VALUE']);
$contactItem['communications'][] = $comm;
}
}
$contactData["{$entityType}_{$entityID}"] = $contactItem;
return array('DATA' => array('TABS' => array(array('id' => 'contact', 'title' => GetMessage('CRM_COMMUNICATION_TAB_CONTACT'), 'active' => true, 'items' => array_values($contactData)))));
}
return array('ERROR' => 'Invalid data');
}
public static function findByPhoneNumber($number, $params = array())
{
if (!is_string($number)) {
throw new \Bitrix\Main\ArgumentTypeException('number', 'string');
}
if ($number === '') {
throw new \Bitrix\Main\ArgumentException('Is empty', 'number');
}
if (!is_array($params)) {
$params = array();
}
$userID = isset($params['USER_ID']) ? intval($params['USER_ID']) : 0;
if ($userID <= 0) {
$userID = CCrmPerms::GetCurrentUserID();
}
$isAdmin = CCrmPerms::IsAdmin($userID);
$userPermissions = CCrmPerms::GetUserPermissions($userID);
$enableExtendedMode = isset($params['ENABLE_EXTENDED_MODE']) ? (bool) $params['ENABLE_EXTENDED_MODE'] : true;
$contactFormID = isset($params['CONTACT_FORM_ID']) ? intval($params['CONTACT_FORM_ID']) : '';
if ($contactFormID === '') {
$contactFormID = CCrmContact::DEFAULT_FORM_ID;
}
$dups = array();
$criterion = new \Bitrix\Crm\Integrity\DuplicateCommunicationCriterion('PHONE', $number);
$entityTypes = array(CCrmOwnerType::Contact, CCrmOwnerType::Company, CCrmOwnerType::Lead);
foreach ($entityTypes as $entityType) {
$duplicate = $criterion->find($entityType, 1);
if ($duplicate !== null) {
$dups[] = $duplicate;
}
}
$entityByType = array();
foreach ($dups as &$dup) {
/** @var \Bitrix\Crm\Integrity\Duplicate $dup */
$entities = $dup->getEntities();
if (!(is_array($entities) && !empty($entities))) {
continue;
}
//Each entity type limited by 50 items
foreach ($entities as &$entity) {
/** @var \Bitrix\Crm\Integrity\DuplicateEntity $entity */
$entityTypeID = $entity->getEntityTypeID();
$entityID = $entity->getEntityID();
$fields = null;
if ($entityTypeID === CCrmOwnerType::Contact) {
$dbEntity = CCrmContact::GetListEx(array(), array('=ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('ID', 'HONORIFIC', 'NAME', 'SECOND_NAME', 'LAST_NAME', 'PHOTO', 'POST', 'COMPANY_ID', 'COMPANY_TITLE', 'ASSIGNED_BY_ID'));
$entityFields = is_object($dbEntity) ? $dbEntity->Fetch() : null;
if (is_array($entityFields)) {
$formattedName = CCrmContact::PrepareFormattedName(array('HONORIFIC' => isset($entityFields['HONORIFIC']) ? $entityFields['HONORIFIC'] : '', 'NAME' => isset($entityFields['NAME']) ? $entityFields['NAME'] : '', 'SECOND_NAME' => isset($entityFields['SECOND_NAME']) ? $entityFields['SECOND_NAME'] : '', 'LAST_NAME' => isset($entityFields['LAST_NAME']) ? $entityFields['LAST_NAME'] : ''));
$fields = array('ID' => intval($entityFields['ID']), 'FORMATTED_NAME' => $formattedName, 'PHOTO' => isset($entityFields['PHOTO']) ? intval($entityFields['PHOTO']) : 0, 'COMPANY_ID' => isset($entityFields['COMPANY_ID']) ? intval($entityFields['COMPANY_ID']) : 0, 'COMPANY_TITLE' => isset($entityFields['COMPANY_TITLE']) ? $entityFields['COMPANY_TITLE'] : '', 'POST' => isset($entityFields['POST']) ? $entityFields['POST'] : '', 'ASSIGNED_BY_ID' => isset($entityFields['ASSIGNED_BY_ID']) ? intval($entityFields['ASSIGNED_BY_ID']) : 0, 'CAN_READ' => CCrmContact::CheckReadPermission($entityID, $userPermissions));
if ($fields['CAN_READ'] && $enableExtendedMode) {
$deals = array();
$dbDeal = CCrmDeal::GetListEx(array('BEGINDATE' => 'ASC'), array('=CONTACT_ID' => $entityID, 'CLOSED' => 'N', 'CHECK_PERMISSIONS' => $isAdmin ? 'N' : 'Y'), false, array('nTopCount' => 2), array('ID', 'TITLE', 'STAGE_ID'), array('PERMS' => $userPermissions));
if (is_object($dbDeal)) {
while ($dealFields = $dbDeal->Fetch()) {
$dealID = intval($dealFields['ID']);
//$dealFields['CAN_READ'] = CCrmDeal::CheckReadPermission($dealID, $userPermissions);
$dealFields['SHOW_URL'] = CCrmOwnerType::GetShowUrl(CCrmOwnerType::Deal, $dealID);
$deals[] = $dealFields;
}
}
$fields['DEALS'] =& $deals;
unset($deals);
}
}
} elseif ($entityTypeID === CCrmOwnerType::Company) {
$dbEntity = CCrmCompany::GetListEx(array(), array('=ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('ID', 'TITLE', 'LOGO', 'ASSIGNED_BY_ID'));
$entityFields = is_object($dbEntity) ? $dbEntity->Fetch() : null;
if (is_array($entityFields)) {
$fields = array('ID' => intval($entityFields['ID']), 'TITLE' => isset($entityFields['TITLE']) ? $entityFields['TITLE'] : '', 'LOGO' => isset($entityFields['LOGO']) ? intval($entityFields['LOGO']) : 0, 'ASSIGNED_BY_ID' => isset($entityFields['ASSIGNED_BY_ID']) ? intval($entityFields['ASSIGNED_BY_ID']) : 0, 'CAN_READ' => CCrmCompany::CheckReadPermission($entityID, $userPermissions));
if ($fields['CAN_READ'] && $enableExtendedMode) {
$deals = array();
$dbDeal = CCrmDeal::GetListEx(array('BEGINDATE' => 'ASC'), array('=COMPANY_ID' => $entityID, 'CLOSED' => 'N', 'CHECK_PERMISSIONS' => $isAdmin ? 'N' : 'Y'), false, array('nTopCount' => 2), array('ID', 'TITLE', 'STAGE_ID'), array('PERMS' => $userPermissions));
if (is_object($dbDeal)) {
while ($dealFields = $dbDeal->Fetch()) {
$dealID = intval($dealFields['ID']);
//$dealFields['CAN_READ'] = CCrmDeal::CheckReadPermission($dealID, $userPermissions);
$dealFields['SHOW_URL'] = CCrmOwnerType::GetShowUrl(CCrmOwnerType::Deal, $dealID);
$deals[] = $dealFields;
}
}
$fields['DEALS'] =& $deals;
unset($deals);
}
}
} elseif ($entityTypeID === CCrmOwnerType::Lead) {
$dbEntity = CCrmLead::GetListEx(array(), array('=ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('ID', 'TITLE', 'HONORIFIC', 'NAME', 'SECOND_NAME', 'LAST_NAME', 'POST', 'COMPANY_TITLE', 'ASSIGNED_BY_ID'));
$entityFields = is_object($dbEntity) ? $dbEntity->Fetch() : null;
if (is_array($entityFields)) {
$formattedName = '';
if (!empty($entityFields['NAME']) || !empty($entityFields['SECOND_NAME']) || !empty($entityFields['LAST_NAME'])) {
$formattedName = CCrmLead::PrepareFormattedName(array('HONORIFIC' => isset($entityFields['HONORIFIC']) ? $entityFields['HONORIFIC'] : '', 'NAME' => isset($entityFields['NAME']) ? $entityFields['NAME'] : '', 'SECOND_NAME' => isset($entityFields['SECOND_NAME']) ? $entityFields['SECOND_NAME'] : '', 'LAST_NAME' => isset($entityFields['LAST_NAME']) ? $entityFields['LAST_NAME'] : ''));
}
$fields = array('ID' => intval($entityFields['ID']), 'TITLE' => isset($entityFields['TITLE']) ? $entityFields['TITLE'] : '', 'FORMATTED_NAME' => $formattedName, 'COMPANY_TITLE' => isset($entityFields['COMPANY_TITLE']) ? $entityFields['COMPANY_TITLE'] : '', 'POST' => isset($entityFields['POST']) ? $entityFields['POST'] : '', 'ASSIGNED_BY_ID' => isset($entityFields['ASSIGNED_BY_ID']) ? intval($entityFields['ASSIGNED_BY_ID']) : 0, 'CAN_READ' => CCrmLead::CheckReadPermission($entityID, $userPermissions));
}
}
if (!is_array($fields)) {
continue;
}
if ($fields['CAN_READ'] && $enableExtendedMode) {
$showUrl = $fields['SHOW_URL'] = CCrmOwnerType::GetShowUrl($entityTypeID, $entityID);
if ($showUrl !== '') {
$fields['ACTIVITY_LIST_URL'] = CCrmUrlUtil::AddUrlParams($showUrl, array("{$contactFormID}_active_tab" => 'tab_activity'));
$fields['INVOICE_LIST_URL'] = CCrmUrlUtil::AddUrlParams($showUrl, array("{$contactFormID}_active_tab" => 'tab_invoice'));
if ($entityTypeID === CCrmOwnerType::Contact || $entityTypeID === CCrmOwnerType::Company) {
$fields['DEAL_LIST_URL'] = CCrmUrlUtil::AddUrlParams($showUrl, array("{$contactFormID}_active_tab" => 'tab_deal'));
}
}
$activities = array();
$dbActivity = CCrmActivity::GetList(array('DEADLINE' => 'ASC'), array('COMPLETED' => 'N', 'BINDINGS' => array(array('OWNER_TYPE_ID' => $entityTypeID, 'OWNER_ID' => $entityID)), 'CHECK_PERMISSIONS' => $isAdmin ? 'N' : 'Y'), false, array('nTopCount' => 4), array('ID', 'SUBJECT', 'START_TIME', 'END_TIME', 'DEADLINE'), array('PERMS' => $userPermissions));
if (is_object($dbActivity)) {
while ($activityFields = $dbActivity->Fetch()) {
$activityFields['SHOW_URL'] = CCrmOwnerType::GetShowUrl(CCrmOwnerType::Activity, $activityFields['ID']);
$activities[] =& $activityFields;
unset($activityFields);
}
}
$fields['ACTIVITIES'] =& $activities;
unset($activities);
}
$entityTypeName = CCrmOwnerType::ResolveName($entityTypeID);
if (!isset($entityByType[$entityTypeName])) {
$entityByType[$entityTypeName] = array($fields);
} elseif (!in_array($entityID, $entityByType[$entityTypeName], true)) {
$entityByType[$entityTypeName][] = $fields;
}
}
}
unset($dup);
return $entityByType;
}
protected static function SendMessageToSocNet($arFields, $bSpawnedByAgent, $arChanges = null, $arTask = null, array $parameters = array())
{
global $USER, $DB;
$effectiveUserId = self::getEffectiveUserId($arFields, array(), $bSpawnedByAgent, $parameters);
if (!CModule::IncludeModule('socialnetwork')) {
return null;
}
$bCrmTask = isset($arTask) && isset($arTask["UF_CRM_TASK"]) && (is_array($arTask["UF_CRM_TASK"]) && (isset($arTask["UF_CRM_TASK"][0]) && strlen($arTask["UF_CRM_TASK"][0]) > 0) || !is_array($arTask["UF_CRM_TASK"]) && strlen($arTask["UF_CRM_TASK"]) > 0);
$arLogFilter = false;
if (!$bCrmTask) {
$arLogFilter = array("EVENT_ID" => "tasks", "SOURCE_ID" => $arTask["ID"]);
} elseif (CModule::IncludeModule("crm")) {
$dbCrmActivity = CCrmActivity::GetList(array(), array('TYPE_ID' => CCrmActivityType::Task, 'ASSOCIATED_ENTITY_ID' => $arTask["ID"], 'CHECK_PERMISSIONS' => 'N'), false, false, array('ID'));
if ($arCrmActivity = $dbCrmActivity->Fetch()) {
$arLogFilter = array("EVENT_ID" => "crm_activity_add", "ENTITY_ID" => $arCrmActivity["ID"]);
}
}
if (!$arLogFilter) {
return null;
}
static $arCheckedUsers = array();
// users that checked for their existing
static $cachedSiteTimeFormat = -1;
// select "real" author
$occurAsUserId = CTasksTools::getOccurAsUserId();
if (!$occurAsUserId) {
$occurAsUserId = $effectiveUserId;
}
if ($cachedSiteTimeFormat === -1) {
$cachedSiteTimeFormat = CSite::GetDateFormat('FULL', SITE_ID);
}
static $cachedAllSitesIds = -1;
if ($cachedAllSitesIds === -1) {
$cachedAllSitesIds = array();
$dbSite = CSite::GetList($by = 'sort', $order = 'desc', array('ACTIVE' => 'Y'));
while ($arSite = $dbSite->Fetch()) {
$cachedAllSitesIds[] = $arSite['ID'];
}
}
// Check that user exists
if (!in_array((int) $arFields["CREATED_BY"], $arCheckedUsers, true)) {
$rsUser = CUser::GetList($by = 'ID', $order = 'ASC', array('ID' => $arFields["CREATED_BY"]), array('FIELDS' => array('ID')));
if (!($arUser = $rsUser->Fetch())) {
return false;
}
$arCheckedUsers[] = (int) $arFields["CREATED_BY"];
}
if (is_array($arChanges)) {
if (count($arChanges) == 0) {
$rsSocNetLogItems = CSocNetLog::GetList(array("ID" => "DESC"), $arLogFilter, false, false, array("ID", "ENTITY_TYPE", "ENTITY_ID"));
while ($arRes = $rsSocNetLogItems->Fetch()) {
$authorUserId = false;
if (isset($arFields['CREATED_BY'])) {
$authorUserId = (int) $arFields['CREATED_BY'];
} elseif (isset($arTask['CREATED_BY'])) {
$authorUserId = (int) $arTask['CREATED_BY'];
}
// Add author to list of users that view log about task in livefeed
// But only when some other person change task
// or if added FORUM_TOPIC_ID
if ($authorUserId !== $effectiveUserId || $arTask['FORUM_TOPIC_ID'] == 0 && isset($arFields['FORUM_TOPIC_ID']) && $arFields['FORUM_TOPIC_ID'] > 0) {
$authorGroupCode = 'U' . $authorUserId;
$rsRights = CSocNetLogRights::GetList(array(), array('LOG_ID' => $arRes['ID'], 'GROUP_CODE' => $authorGroupCode));
// If task's author hasn't rights yet, give them
if (!($arRights = $rsRights->fetch())) {
CSocNetLogRights::Add($arRes["ID"], array($authorGroupCode));
}
}
}
return null;
} elseif (count($arChanges) == 1 && isset($arChanges['STATUS'])) {
return null;
// if only status changes - don't send message, because it will be sent by SendStatusMessage()
}
}
if ($bSpawnedByAgent === 'Y') {
$bSpawnedByAgent = true;
} elseif ($bSpawnedByAgent === 'N') {
$bSpawnedByAgent = false;
}
if (!is_bool($bSpawnedByAgent)) {
return false;
}
$taskId = false;
if (is_array($arFields) && isset($arFields['ID']) && $arFields['ID'] > 0) {
$taskId = $arFields['ID'];
} elseif (is_array($arTask) && isset($arTask['ID']) && $arTask['ID'] > 0) {
$taskId = $arTask['ID'];
}
// We will mark this to false, if we send update message and log item already exists
$bSocNetAddNewItem = true;
$logDate = $DB->CurrentTimeFunction();
$curTimeTimestamp = time() + CTimeZone::GetOffset();
if (!$bCrmTask) {
$arSoFields = array('EVENT_ID' => 'tasks', 'TITLE' => $arFields['TITLE'], 'MESSAGE' => '', 'MODULE_ID' => 'tasks');
} else {
$arSoFields = array();
}
// If changes and task data given => we are prepare "update" message,
// or "add" message otherwise
if (is_array($arChanges) && is_array($arTask)) {
// Prepare "update" message here
if (strlen($arFields["CHANGED_DATE"]) > 0) {
$createdDateTimestamp = MakeTimeStamp($arFields["CHANGED_DATE"], $cachedSiteTimeFormat);
if ($createdDateTimestamp > $curTimeTimestamp) {
$logDate = $DB->CharToDateFunction($arFields["CHANGED_DATE"], "FULL", SITE_ID);
}
}
$arChangesFields = array_keys($arChanges);
$arSoFields['TEXT_MESSAGE'] = str_replace('#CHANGES#', implode(', ', CTaskNotifications::__Fields2Names($arChangesFields)), GetMessage('TASKS_SONET_TASK_CHANGED_MESSAGE'));
if (!$bCrmTask) {
if ($arFields["GROUP_ID"] === NULL && $arTask['GROUP_ID'] || $arFields['GROUP_ID']) {
$arSoFields["ENTITY_TYPE"] = SONET_ENTITY_GROUP;
$arSoFields["ENTITY_ID"] = $arFields["GROUP_ID"] ? $arFields["GROUP_ID"] : $arTask['GROUP_ID'];
} else {
$arSoFields["ENTITY_TYPE"] = SONET_ENTITY_USER;
$arSoFields["ENTITY_ID"] = $arFields["CREATED_BY"] ? $arFields["CREATED_BY"] : $arTask["CREATED_BY"];
}
}
$arSoFields['PARAMS'] = serialize(array('TYPE' => 'modify', 'CHANGED_FIELDS' => $arChangesFields, 'CREATED_BY' => $arFields["CREATED_BY"] ? $arFields["CREATED_BY"] : $arTask["CREATED_BY"], 'CHANGED_BY' => $occurAsUserId ? $occurAsUserId : $arFields['CHANGED_BY'], 'PREV_REAL_STATUS' => isset($arTask['REAL_STATUS']) ? $arTask['REAL_STATUS'] : false));
// Determine, does item exists in sonet log
$rsSocNetLogItems = CSocNetLog::GetList(array("ID" => "DESC"), $arLogFilter, false, false, array("ID", "ENTITY_TYPE", "ENTITY_ID"));
if ($rsSocNetLogItems->Fetch()) {
$bSocNetAddNewItem = false;
// item already exists, update it, not create.
}
} else {
if (strlen($arFields["CREATED_DATE"]) > 0) {
$createdDateTimestamp = MakeTimeStamp($arFields["CREATED_DATE"], $cachedSiteTimeFormat);
if ($createdDateTimestamp > $curTimeTimestamp) {
$logDate = $DB->CharToDateFunction($arFields["CREATED_DATE"], "FULL", SITE_ID);
}
}
$arSoFields['TEXT_MESSAGE'] = GetMessage('TASKS_SONET_NEW_TASK_MESSAGE');
if ($arFields["GROUP_ID"]) {
$arSoFields["ENTITY_TYPE"] = SONET_ENTITY_GROUP;
$arSoFields["ENTITY_ID"] = $arFields["GROUP_ID"];
} else {
$arSoFields["ENTITY_TYPE"] = SONET_ENTITY_USER;
$arSoFields["ENTITY_ID"] = $arFields["CREATED_BY"];
}
$arParamsLog = array('TYPE' => 'create', 'CREATED_BY' => $arFields["CREATED_BY"] ? $arFields["CREATED_BY"] : $arTask["CREATED_BY"], 'PREV_REAL_STATUS' => isset($arTask['REAL_STATUS']) ? $arTask['REAL_STATUS'] : false);
if ($occurAsUserId) {
$arParamsLog["CREATED_BY"] = $occurAsUserId;
}
$arSoFields['PARAMS'] = serialize($arParamsLog);
}
// rating entity id (ilike)
$arSoFields["RATING_ENTITY_ID"] = $taskId;
$arSoFields["RATING_TYPE_ID"] = "TASK";
// Do we need add new item to socnet?
// We adds new item, if it is not exists.
$logID = false;
if (IsModuleInstalled("webdav") || IsModuleInstalled("disk")) {
$ufDocID = $GLOBALS["USER_FIELD_MANAGER"]->GetUserFieldValue("TASKS_TASK", "UF_TASK_WEBDAV_FILES", $taskId, LANGUAGE_ID);
if ($ufDocID) {
$arSoFields["UF_SONET_LOG_DOC"] = $ufDocID;
}
}
if ($bSocNetAddNewItem) {
$arSoFields['=LOG_DATE'] = $logDate;
$arSoFields['CALLBACK_FUNC'] = false;
$arSoFields['SOURCE_ID'] = $taskId;
$arSoFields['ENABLE_COMMENTS'] = 'Y';
$arSoFields['URL'] = CTaskNotifications::GetNotificationPath(array('ID' => (int) $arFields["CREATED_BY"]), $taskId, false);
$arSoFields['USER_ID'] = $arFields['CREATED_BY'];
$arSoFields['TITLE_TEMPLATE'] = '#TITLE#';
// Set all sites because any user from any site may be
// added to task in future. For example, new auditor, etc.
$arSoFields['SITE_ID'] = $cachedAllSitesIds;
$logID = CSocNetLog::Add($arSoFields, false);
if (intval($logID) > 0) {
CSocNetLog::Update($logID, array("TMP_ID" => $logID));
$arTaskParticipant = CTaskNotifications::GetRecipientsIDs($arFields, false);
// Exclude author
$arLogCanViewedBy = array_diff($arTaskParticipant, array($arFields['CREATED_BY']));
$arRights = CTaskNotifications::__UserIDs2Rights($arLogCanViewedBy);
if (isset($arFields['GROUP_ID'])) {
$arRights = array_merge($arRights, self::prepareRightsCodesForViewInGroupLiveFeed($logID, $arFields['GROUP_ID']));
}
CSocNetLogRights::Add($logID, $arRights);
CSocNetLog::SendEvent($logID, "SONET_NEW_EVENT", $logID);
}
} else {
$arSoFields['=LOG_DATE'] = $logDate;
$arSoFields['=LOG_UPDATE'] = $logDate;
// All tasks posts in live feed should be from director
if (isset($arFields['CREATED_BY'])) {
$arSoFields['USER_ID'] = $arFields['CREATED_BY'];
} elseif (isset($arTask['CREATED_BY'])) {
$arSoFields['USER_ID'] = $arTask['CREATED_BY'];
} elseif ($occurAsUserId) {
$arSoFields['USER_ID'] = $occurAsUserId;
} else {
unset($arSoFields['USER_ID']);
}
$rsSocNetLogItems = CSocNetLog::GetList(array("ID" => "DESC"), $arLogFilter, false, false, array("ID", "ENTITY_TYPE", "ENTITY_ID"));
while ($arRes = $rsSocNetLogItems->Fetch()) {
CSocNetLog::Update($arRes["ID"], $arSoFields);
$arTaskParticipant = CTaskNotifications::GetRecipientsIDs($arFields, false, true);
$bAuthorMustBeExcluded = false;
$authorUserId = false;
if (isset($arFields['CREATED_BY'])) {
$authorUserId = (int) $arFields['CREATED_BY'];
} elseif (isset($arTask['CREATED_BY'])) {
$authorUserId = (int) $arTask['CREATED_BY'];
}
// Get current rights
$rsRights = CSocNetLogRights::GetList(array(), array('LOG_ID' => $arRes['ID']));
$arCurrentRights = array();
while ($arRights = $rsRights->fetch()) {
$arCurrentRights[] = $arRights['GROUP_CODE'];
}
// If author changes the task and author doesn't have
// access to task yet, don't give access to him.
if ($authorUserId === $effectiveUserId) {
$authorGroupCode = 'U' . $authorUserId;
// If task's author hasn't rights yet, still exclude him
if (!in_array($authorGroupCode, $arCurrentRights, true)) {
$bAuthorMustBeExcluded = true;
}
}
if ($bAuthorMustBeExcluded) {
$arLogCanViewedBy = array_diff($arTaskParticipant, array($authorUserId));
} else {
$arLogCanViewedBy = $arTaskParticipant;
}
$arNewRights = CTaskNotifications::__UserIDs2Rights($arLogCanViewedBy);
$bGroupChanged = false;
if (isset($arFields['GROUP_ID'], $arTask['GROUP_ID']) && $arFields['GROUP_ID'] && $arFields['GROUP_ID'] != $arTask['GROUP_ID']) {
$bGroupChanged = true;
}
// If rights really changed, update them
if (count(array_diff($arCurrentRights, $arNewRights)) || count(array_diff($arNewRights, $arCurrentRights)) || $bGroupChanged) {
if (isset($arFields['GROUP_ID'])) {
$arNewRights = array_merge($arNewRights, self::prepareRightsCodesForViewInGroupLiveFeed($logID, $arFields['GROUP_ID']));
} elseif (isset($arTask['GROUP_ID'])) {
$arNewRights = array_merge($arNewRights, self::prepareRightsCodesForViewInGroupLiveFeed($logID, $arTask['GROUP_ID']));
}
CSocNetLogRights::DeleteByLogID($arRes["ID"], true);
CSocNetLogRights::Add($arRes["ID"], $arNewRights);
}
}
}
return $logID;
}
public function createActivities(array $params)
{
$count = isset($params['COUNT']) ? (int) $params['COUNT'] : 0;
if ($count <= 0) {
return;
}
$typeID = isset($params['TYPE_ID']) ? (int) $params['TYPE_ID'] : \CCrmActivityType::Undefined;
if (!\CCrmActivityType::IsDefined($typeID)) {
return;
}
$ownerTypeID = isset($params['OWNER_TYPE_ID']) ? (int) $params['OWNER_TYPE_ID'] : \CCrmOwnerType::Undefined;
if (!\CCrmOwnerType::IsDefined($ownerTypeID)) {
return;
}
$ownerID = isset($params['OWNER_ID']) ? (int) $params['OWNER_ID'] : 0;
if ($ownerID <= 0) {
return;
}
$clientTypeID = isset($params['CLIENT_TYPE_ID']) ? (int) $params['CLIENT_TYPE_ID'] : \CCrmOwnerType::Undefined;
$clientID = isset($params['CLIENT_ID']) ? (int) $params['CLIENT_ID'] : 0;
if (!\CCrmOwnerType::IsDefined($clientTypeID) || $clientID <= 0) {
$clientTypeID = $ownerTypeID;
$clientID = $ownerID;
}
$commType = $typeID === \CCrmActivityType::Call ? 'PHONE' : '';
$values = array();
if ($commType === 'PHONE' || $commType === 'EMAIL') {
$values = self::getEntityMultifieldValues($clientTypeID, $clientID, $commType);
if (empty($values)) {
return;
}
}
$userIDs = isset($params['USER_IDS']) && is_array($params['USER_IDS']) ? $params['USER_IDS'] : array();
if (empty($userIDs)) {
$userIDs[] = \CCrmSecurityHelper::GetCurrentUserID();
}
$date = isset($params['DATE']) ? $params['DATE'] : null;
if (!$date) {
$date = $date = new Date();
}
$maxDateOffset = isset($params['MAX_DATE_OFFSET']) ? (int) $params['MAX_DATE_OFFSET'] : 0;
$dateTimeFormat = Date::convertFormatToPhp(FORMAT_DATETIME);
$subjectPrefix = isset($params['SUBJECT_PREFIX']) ? $params['SUBJECT_PREFIX'] : '';
for ($i = 0; $i < $count; $i++) {
$time = DateTime::createFromTimestamp($date->getTimestamp());
if ($maxDateOffset > 0) {
$time->add(mt_rand(0, $maxDateOffset) . ' days');
}
$time->setTime(mt_rand(8, 20), mt_rand(0, 59), 0);
$siteTime = $time->format($dateTimeFormat);
$fields = array('TYPE_ID' => $typeID, 'START_TIME' => $siteTime, 'END_TIME' => $siteTime, 'SUBJECT' => "{$subjectPrefix} ({$siteTime})", 'COMPLETED' => mt_rand(1, 10) % 2 !== 0 ? 'Y' : 'N', 'PRIORITY' => \CCrmActivityPriority::Medium, 'DESCRIPTION' => '', 'DESCRIPTION_TYPE' => \CCrmContentType::PlainText, 'LOCATION' => '', 'DIRECTION' => \CCrmActivityDirection::Outgoing, 'NOTIFY_TYPE' => \CCrmActivityNotifyType::None, 'RESPONSIBLE_ID' => self::getRandomItem($userIDs), 'OWNER_ID' => $ownerID, 'OWNER_TYPE_ID' => $ownerTypeID, 'BINDINGS' => array(array('OWNER_TYPE_ID' => $ownerTypeID, 'OWNER_ID' => $ownerID)));
$ID = \CCrmActivity::Add($fields, false, true, array('REGISTER_SONET_EVENT' => true));
$comms = array(array('TYPE' => $commType, 'VALUE' => self::getRandomItem($values, ''), 'ENTITY_ID' => $clientID, 'ENTITY_TYPE_ID' => $clientTypeID));
\CCrmActivity::SaveCommunications($ID, $comms, $fields, false, false);
}
}
$arSelect = $arResult['SELECTED_FIELDS'];
if ($arResult['DISPLAY_CLIENT'] && (empty($arSelect) || in_array('CLIENT', $arSelect, true))) {
$columnHtml = '';
$clientInfo = isset($item['CLIENT_INFO']) ? $item['CLIENT_INFO'] : null;
if (is_array($clientInfo)) {
$columnHtml = CCrmViewHelper::PrepareEntityBaloonHtml(array('ENTITY_TYPE_ID' => $clientInfo['ENTITY_TYPE_ID'], 'ENTITY_ID' => $clientInfo['ENTITY_ID'], 'PREFIX' => "{$arResult['UID']}_{$item['~ID']}_CLIENT", 'TITLE' => isset($clientInfo['TITLE']) ? $clientInfo['TITLE'] : '', 'SHOW_URL' => isset($clientInfo['SHOW_URL']) ? $clientInfo['SHOW_URL'] : ''));
}
$arRowData['columns']['CLIENT'] = $columnHtml;
}
$arResult['GRID_DATA'][] = $arRowData;
// <-- Preparing grig row
// Preparing activity editor item -->
$commData = array();
if (!empty($communications)) {
foreach ($communications as &$arComm) {
CCrmActivity::PrepareCommunicationInfo($arComm);
$commData[] = array('id' => $arComm['ID'], 'type' => $arComm['TYPE'], 'value' => $arComm['VALUE'], 'entityId' => $arComm['ENTITY_ID'], 'entityType' => CCrmOwnerType::ResolveName($arComm['ENTITY_TYPE_ID']), 'entityTitle' => $arComm['TITLE'], 'entityUrl' => CCrmOwnerType::GetShowUrl($arComm['ENTITY_TYPE_ID'], $arComm['ENTITY_ID']));
}
unset($arComm);
}
$responsibleID = isset($item['~RESPONSIBLE_ID']) ? intval($item['~RESPONSIBLE_ID']) : 0;
$responsibleUrl = isset($item['PATH_TO_RESPONSIBLE']) ? $item['PATH_TO_RESPONSIBLE'] : '';
if ($responsibleUrl === '') {
$responsibleUrl = CComponentEngine::MakePathFromTemplate($arResult['PATH_TO_USER_PROFILE'], array('user_id' => $responsibleID));
}
$editorItem = array('ID' => $item['~ID'], 'typeID' => $item['~TYPE_ID'], 'subject' => $item['~SUBJECT'], 'description' => isset($item['DESCRIPTION_RAW']) ? $item['DESCRIPTION_RAW'] : '', 'descriptionHtml' => isset($item['DESCRIPTION_HTML']) ? $item['DESCRIPTION_HTML'] : '', 'direction' => intval($item['~DIRECTION']), 'location' => $item['~LOCATION'], 'start' => isset($item['~START_TIME']) ? ConvertTimeStamp(MakeTimeStamp($item['~START_TIME']), 'FULL', SITE_ID) : '', 'end' => isset($item['~END_TIME']) ? ConvertTimeStamp(MakeTimeStamp($item['~END_TIME']), 'FULL', SITE_ID) : '', 'deadline' => isset($item['~DEADLINE']) ? ConvertTimeStamp(MakeTimeStamp($item['~DEADLINE']), 'FULL', SITE_ID) : '', 'completed' => $item['~COMPLETED'] == 'Y', 'notifyType' => intval($item['~NOTIFY_TYPE']), 'notifyValue' => intval($item['~NOTIFY_VALUE']), 'priority' => intval($item['~PRIORITY']), 'responsibleID' => $responsibleID, 'responsibleName' => isset($item['~RESPONSIBLE_FULL_NAME'][0]) ? $item['~RESPONSIBLE_FULL_NAME'] : GetMessage('CRM_UNDEFINED_VALUE'), 'responsibleUrl' => $responsibleUrl, 'storageTypeID' => intval($item['STORAGE_TYPE_ID']), 'files' => $item['FILES'], 'webdavelements' => $item['WEBDAV_ELEMENTS'], 'diskfiles' => $item['DISK_FILES'], 'associatedEntityID' => isset($item['~ASSOCIATED_ENTITY_ID']) ? intval($item['~ASSOCIATED_ENTITY_ID']) : 0);
if (!$commLoaded) {
$editorItem['communicationsLoaded'] = false;
} else {
$editorItem['communicationsLoaded'] = true;
$editorItem['communications'] = $commData;
$contactComms = CCrmActivity::PrepareCommunications('CONTACT', $contactID, $commType);
foreach ($contactComms as &$comm) {
$item['COMMUNICATIONS'][] = array('TYPE' => $comm['TYPE'], 'VALUE' => $comm['VALUE']);
}
unset($comm);
if (!empty($item['COMMUNICATIONS'])) {
$items[$contactKey] =& $item;
}
unset($item);
}
}
}
// Try to get previous communications
$invoiceComms = CCrmActivity::GetCommunicationsByOwner('INVOICE', $ownerID, $commType);
foreach ($invoiceComms as &$comm) {
if (!CCrmActivity::PrepareCommunicationInfo($comm)) {
continue;
}
$commKey = "{$comm['ENTITY_TYPE']}_{$comm['ENTITY_ID']}";
if (!isset($items[$commKey])) {
$items[$commKey] = array('OWNER_ID' => $ownerID, 'OWNER_TYPE_ID' => CCrmOwnerType::Invoice, 'TITLE' => $comm['TITLE'], 'DESCRIPTION' => $comm['DESCRIPTION'], 'IMAGE_URL' => '', 'COMMUNICATIONS' => array());
$commEntityType = $comm['ENTITY_TYPE'];
if (!isset($imageless[$commEntityType])) {
$imageless[$commEntityType] = array();
}
$imageless[$commEntityType][] = $comm['ENTITY_ID'];
}
if ($commType !== 'PERSON') {
$isFound = false;
foreach ($items[$commKey]['COMMUNICATIONS'] as &$itemComm) {
if ($comm['VALUE'] === $itemComm['VALUE']) {
public function Synchronize()
{
$currentDay = time() + CTimeZone::GetOffset();
$currentDayEnd = ConvertTimeStamp(mktime(23, 59, 59, date('n', $currentDay), date('j', $currentDay), date('Y', $currentDay)), 'FULL', SITE_ID);
$count = 0;
if ($this->typeID === self::CurrentActivies) {
//Count of open user activities (start time: before tomorrow)
$filter = array('RESPONSIBLE_ID' => $this->userID, 'COMPLETED' => 'N', '<=START_TIME' => $currentDayEnd);
$count = CCrmActivity::GetCount($filter);
} elseif ($this->typeID === self::CurrentCompanyActivies) {
$count = CCrmActivity::GetCurrentQuantity($this->userID, CCrmOwnerType::Company);
} elseif ($this->typeID === self::CurrentContactActivies) {
$count = CCrmActivity::GetCurrentQuantity($this->userID, CCrmOwnerType::Contact);
} elseif ($this->typeID === self::CurrentLeadActivies) {
$count = CCrmActivity::GetCurrentQuantity($this->userID, CCrmOwnerType::Lead);
if (CCrmUserCounterSettings::GetValue(CCrmUserCounterSettings::ReckonActivitylessItems, true)) {
$leadTable = CCrmLead::TABLE_NAME;
$activityTable = CCrmActivity::USER_ACTIVITY_TABLE_NAME;
$statusStr = "'CONVERTED'";
$statusCount = 1;
$statuses = self::GetStatusList('STATUS');
$isFound = false;
foreach ($statuses as &$status) {
if (!$isFound) {
$isFound = $status['STATUS_ID'] === 'CONVERTED';
} else {
$statusStr .= ",'{$status['STATUS_ID']}'";
$statusCount++;
// Foolproof
if ($statusCount === 10) {
break;
}
}
}
unset($status);
global $DBType;
$sqlData = array('FROM' => '', 'WHERE' => "l.ASSIGNED_BY_ID = {$this->userID} AND l.STATUS_ID NOT IN({$statusStr}) AND l.ID NOT IN(SELECT a.OWNER_ID FROM {$activityTable} a WHERE a.USER_ID = 0 AND a.OWNER_TYPE_ID = 1)", 'GROUPBY' => '');
$count += CSqlUtil::GetRowCount($sqlData, $leadTable, 'l', $DBType);
}
} elseif ($this->typeID === self::CurrentDealActivies) {
$count = CCrmActivity::GetCurrentQuantity($this->userID, CCrmOwnerType::Deal);
if (CCrmUserCounterSettings::GetValue(CCrmUserCounterSettings::ReckonActivitylessItems, true)) {
$dealTable = CCrmDeal::TABLE_NAME;
$activityTable = CCrmActivity::USER_ACTIVITY_TABLE_NAME;
$stageStr = "'WON'";
$stageCount = 1;
$stages = self::GetStatusList('DEAL_STAGE');
$isFound = false;
foreach ($stages as &$stage) {
if (!$isFound) {
$isFound = $stage['STATUS_ID'] === 'WON';
} else {
$stageStr .= ",'{$stage['STATUS_ID']}'";
$stageCount++;
// Foolproof
if ($stageCount === 10) {
break;
}
}
}
unset($stage);
global $DB;
$dbResult = $DB->Query("SELECT COUNT(d.ID) AS CNT FROM {$dealTable} d WHERE d.ASSIGNED_BY_ID = {$this->userID} AND d.STAGE_ID NOT IN({$stageStr}) AND d.ID NOT IN(SELECT a.OWNER_ID FROM {$activityTable} a WHERE a.USER_ID = 0 AND a.OWNER_TYPE_ID = 2)", false, 'File: ' . __FILE__ . '<br/>Line: ' . __LINE__);
$result = $dbResult->Fetch();
$count += is_array($result) ? intval($result['CNT']) : 0;
}
} elseif ($this->typeID === self::CurrentQuoteActivies) {
$count = 0;
if (CCrmUserCounterSettings::GetValue(CCrmUserCounterSettings::ReckonActivitylessItems, true)) {
$quoteTable = CCrmQuote::TABLE_NAME;
$statusStr = "'APPROVED'";
$statusCount = 1;
$statuses = self::GetStatusList('QUOTE_STATUS');
$isFound = false;
foreach ($statuses as &$status) {
if (!$isFound) {
$isFound = $status['STATUS_ID'] === 'APPROVED';
} else {
$statusStr .= ",'{$status['STATUS_ID']}'";
$statusCount++;
// Foolproof
if ($statusCount === 10) {
break;
}
}
}
unset($status);
global $DB;
$currentDay = time() + CTimeZone::GetOffset();
$currentDayEnd = ConvertTimeStamp(mktime(23, 59, 59, date('n', $currentDay), date('j', $currentDay), date('Y', $currentDay)), 'FULL', SITE_ID);
$currentDayEnd = $DB->CharToDateFunction($DB->ForSql($currentDayEnd), 'FULL');
$dbResult = $DB->Query("SELECT COUNT(q.ID) AS CNT FROM {$quoteTable} q WHERE q.ASSIGNED_BY_ID = {$this->userID} AND q.CLOSEDATE IS NOT NULL AND q.CLOSEDATE <= {$currentDayEnd} AND q.STATUS_ID NOT IN ({$statusStr})", false, 'File: ' . __FILE__ . '<br/>Line: ' . __LINE__);
$result = $dbResult->Fetch();
$count += is_array($result) ? intval($result['CNT']) : 0;
}
}
if ($this->curValue !== $count) {
$this->curValue = $count;
if ($this->code !== '') {
CUserCounter::Set($this->userID, $this->code, $this->curValue, SITE_ID, '', false);
}
}
$this->RefreshLastCalculatedTime();
return $this->curValue;
}
public static function beforeViewDataQuery(&$select, &$filter, &$group, &$order, &$limit, &$options, &$runtime)
{
// Dynamic data setup
//Crm\ActivityTable::ProcessQueryOptions($options);
if (!isset($select['CRM_ACTIVITY_COMPANY_BY_ID'])) {
foreach ($select as $k => $v) {
if (strpos($k, 'CRM_ACTIVITY_COMPANY_BY_') === 0) {
$select['CRM_ACTIVITY_COMPANY_BY_ID'] = 'COMPANY_BY.ID';
break;
}
}
}
// permission
$addClause = CCrmActivity::BuildPermSql('crm_activity');
if ($addClause === false) {
// access dinied
$filter = array($filter, '=ID' => '0');
} elseif (!empty($addClause)) {
global $DB;
// HACK: add escape chars for ORM
$addClause = str_replace('crm_activity.ID', $DB->escL . 'crm_activity' . $DB->escR . '.ID', $addClause);
$filter = array($filter, '=IS_ALLOWED' => '1');
$runtime['IS_ALLOWED'] = array('data_type' => 'integer', 'expression' => array('CASE WHEN ' . $addClause . ' THEN 1 ELSE 0 END'));
}
}
public function Delete($ID, $arOptions = array())
{
global $DB, $APPLICATION;
$ID = intval($ID);
$iUserId = CCrmSecurityHelper::GetCurrentUserID();
$sWherePerm = '';
if ($this->bCheckPermission) {
$arEntityAttr = $this->cPerms->GetEntityAttr('COMPANY', $ID);
$sEntityPerm = $this->cPerms->GetPermType('COMPANY', 'DELETE', $arEntityAttr[$ID]);
if ($sEntityPerm == BX_CRM_PERM_NONE) {
return false;
} else {
if ($sEntityPerm == BX_CRM_PERM_SELF) {
$sWherePerm = " AND ASSIGNED_BY_ID = {$iUserId}";
} else {
if ($sEntityPerm == BX_CRM_PERM_OPEN) {
$sWherePerm = " AND (OPENED = 'Y' OR ASSIGNED_BY_ID = {$iUserId})";
}
}
}
}
$APPLICATION->ResetException();
$events = GetModuleEvents('crm', 'OnBeforeCrmCompanyDelete');
while ($arEvent = $events->Fetch()) {
if (ExecuteModuleEventEx($arEvent, array($ID)) === false) {
$err = GetMessage("MAIN_BEFORE_DEL_ERR") . ' ' . $arEvent['TO_NAME'];
if ($ex = $APPLICATION->GetException()) {
$err .= ': ' . $ex->GetString();
}
$APPLICATION->throwException($err);
return false;
}
}
$obRes = $DB->Query("DELETE FROM b_crm_company WHERE ID = {$ID}{$sWherePerm}", false, 'FILE: ' . __FILE__ . '<br /> LINE: ' . __LINE__);
if (is_object($obRes) && $obRes->AffectedRowsCount() > 0) {
$DB->Query("DELETE FROM b_crm_entity_perms WHERE ENTITY='COMPANY' AND ENTITY_ID = {$ID}", false, 'FILE: ' . __FILE__ . '<br /> LINE: ' . __LINE__);
$GLOBALS['USER_FIELD_MANAGER']->Delete(self::$sUFEntityID, $ID);
$CCrmFieldMulti = new CCrmFieldMulti();
$CCrmFieldMulti->DeleteByElement('COMPANY', $ID);
$CCrmEvent = new CCrmEvent();
$CCrmEvent->DeleteByElement('COMPANY', $ID);
\Bitrix\Crm\Integrity\DuplicateEntityRanking::unregisterEntityStatistics(CCrmOwnerType::Company, $ID);
\Bitrix\Crm\Integrity\DuplicateOrganizationCriterion::unregister(CCrmOwnerType::Company, $ID);
\Bitrix\Crm\Integrity\DuplicateCommunicationCriterion::unregister(CCrmOwnerType::Company, $ID);
\Bitrix\Crm\Integrity\DuplicateIndexMismatch::unregisterEntity(CCrmOwnerType::Company, $ID);
$enableDupIndexInvalidation = is_array($arOptions) && isset($arOptions['ENABLE_DUP_INDEX_INVALIDATION']) ? (bool) $arOptions['ENABLE_DUP_INDEX_INVALIDATION'] : true;
if ($enableDupIndexInvalidation) {
\Bitrix\Crm\Integrity\DuplicateIndexBuilder::markAsJunk(CCrmOwnerType::Company, $ID);
}
CCrmActivity::DeleteByOwner(CCrmOwnerType::Company, $ID);
CCrmSearch::DeleteSearch('COMPANY', $ID);
CCrmSonetSubscription::UnRegisterSubscriptionByEntity(CCrmOwnerType::Company, $ID);
CCrmLiveFeed::DeleteLogEvents(array('ENTITY_TYPE_ID' => CCrmOwnerType::Company, 'ENTITY_ID' => $ID));
if (defined("BX_COMP_MANAGED_CACHE")) {
$GLOBALS["CACHE_MANAGER"]->ClearByTag("crm_entity_name_" . CCrmOwnerType::Company . "_" . $ID);
}
}
return true;
}
$arResult['GRID_FILTER_NAME'] = '';
}
if (isset($filter['SUBJECT'])) {
if ($filter['SUBJECT'] !== '') {
$filter['%SUBJECT'] = $arResult['SEARCH_VALUE'] = $filter['SUBJECT'];
}
unset($filter['SUBJECT']);
}
if ($entityTypeID > 0 && $entityID > 0) {
$arResult['RUBRIC']['ENABLED'] = true;
$filter['BINDINGS'] = array(array('OWNER_TYPE_ID' => $entityTypeID, 'OWNER_ID' => $entityID));
$arResult['RUBRIC']['TITLE'] = CCrmOwnerType::GetCaption($entityTypeID, $entityID);
$arResult['RUBRIC']['FILTER_PRESETS'] = array('clear_filter', 'filter_not_completed', 'filter_completed');
}
$arResult['ITEMS'] = array();
$dbRes = CCrmActivity::GetList($sort, $filter, false, $navParams, $select);
$dbRes->NavStart($navParams['nPageSize'], false);
$arResult['PAGE_NAVNUM'] = intval($dbRes->NavNum);
// pager index
$arResult['PAGE_NUMBER'] = intval($dbRes->NavPageNomer);
// current page index
$arResult['PAGE_NAVCOUNT'] = intval($dbRes->NavPageCount);
// page count
$arResult['PAGER_PARAM'] = "PAGEN_{$arResult['PAGE_NAVNUM']}";
$arResult['PAGE_NEXT_NUMBER'] = $arResult['PAGE_NUMBER'] + 1;
while ($item = $dbRes->Fetch()) {
$itemID = intval($item['ID']);
$ownerID = intval($item['OWNER_ID']);
$ownerTypeID = intval($item['OWNER_TYPE_ID']);
CCrmMobileHelper::PrepareActivityItem($item, $arParams, array('ENABLE_COMMUNICATIONS' => false));
$arResult['ITEMS'][] =& $item;
public static function OnDiskFileDelete($objectID, $deletedByUserID)
{
$objectID = (int) $objectID;
if ($objectID <= 0) {
return;
}
\CCrmActivity::HandleStorageElementDeletion(StorageType::Disk, $objectID);
\CCrmQuote::HandleStorageElementDeletion(StorageType::Disk, $objectID);
}
} elseif (!check_bitrix_sessid()) {
$arResult[0] = "*";
} elseif (in_array($action, array("add_comment", "edit_comment", "delete_comment", "file_comment_upload"))) {
$log_id = $_REQUEST["log_id"];
if ($arLog = CSocNetLog::GetByID($log_id)) {
$log_entity_type = $arLog["ENTITY_TYPE"];
$arListParams = strpos($log_entity_type, "CRM") === 0 && IsModuleInstalled("crm") ? array("IS_CRM" => "Y", "CHECK_CRM_RIGHTS" => "Y") : array("CHECK_RIGHTS" => "Y", "USE_SUBSCRIBE" => "N");
} else {
$log_id = 0;
}
if (intval($log_id) <= 0 || !($rsLog = CSocNetLog::GetList(array(), array("ID" => $log_id), false, false, array(), $arListParams)) || !($arLog = $rsLog->Fetch())) {
$arResult["strMessage"] = GetMessage("Log event not found");
}
if (!isset($arResult["strMessage"])) {
$arEntityXMLID = array("tasks" => "TASK", "forum" => "FORUM", "photo_photo" => "PHOTO", "sonet" => "SOCNET", "lists_new_element" => array("WF", "WF", "FORUM|COMMENT"));
if ($arLog["ENTITY_TYPE"] == "CRMACTIVITY" && CModule::IncludeModule('crm') && ($arActivity = CCrmActivity::GetByID($arLog["ENTITY_ID"], false)) && $arActivity["TYPE_ID"] == CCrmActivityType::Task) {
$entity_xml_id = "TASK_" . $arActivity["ASSOCIATED_ENTITY_ID"];
} elseif ($arLog["ENTITY_TYPE"] == "WF" && $arLog["SOURCE_ID"] > 0 && CModule::IncludeModule('bizproc') && ($workflowId = \CBPStateService::getWorkflowByIntegerId($arLog["SOURCE_ID"]))) {
$entity_xml_id = "WF_" . $workflowId;
} else {
$entity_xml_id = array_key_exists($arLog["EVENT_ID"], $arEntityXMLID) && $arLog["SOURCE_ID"] > 0 ? $arEntityXMLID[$arLog["EVENT_ID"]] . "_" . $arLog["SOURCE_ID"] : strtoupper($arLog["EVENT_ID"]) . "_" . $arLog["ID"];
}
$arCommentEvent = CSocNetLogTools::FindLogCommentEventByLogEventID($arLog["EVENT_ID"]);
if (!$arCommentEvent) {
$arResult["strMessage"] = GetMessage("Comment event not found");
}
}
if (!isset($arResult["strMessage"])) {
$feature = CSocNetLogTools::FindFeatureByEventID($arCommentEvent["EVENT_ID"]);
if (array_key_exists("OPERATION_ADD", $arCommentEvent) && $arCommentEvent["OPERATION_ADD"] == "log_rights") {
$bCanAddComments = CSocNetLogRights::CheckForUser($log_id, $GLOBALS["USER"]->GetID());
function __CrmActivityListRenderItems($items, $showMode, $showTop, &$editorCfg)
{
$editorItems = array();
$count = count($items);
$now = time() + CTimeZone::GetOffset();
$toolbarID = '';
if ($editorCfg['ENABLE_TOOLBAR']) {
$toolbarID = $editorCfg['EDITOR_ID'] . '_toolbar';
?>
<ul id="<?php
echo htmlspecialcharsbx($toolbarID);
?>
" class="crm-view-actions">
<?php
if ($editorCfg['ENABLE_TASK_ADD']) {
?>
<li class="crm-activity-command-add-task">
<i></i>
<span><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_LIST_ADD_TASK'));
?>
</span>
</li>
<?php
}
?>
<?php
if ($editorCfg['ENABLE_CALENDAR_EVENT_ADD']) {
?>
<li class="crm-activity-command-add-call">
<i></i>
<span><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_LIST_ADD_CALL'));
?>
</span>
</li>
<li class="crm-activity-command-add-meeting">
<i></i>
<span><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_LIST_ADD_MEETING'));
?>
</span>
</li>
<?php
}
?>
<?php
if ($editorCfg['ENABLE_EMAIL_ADD']) {
?>
<li class="crm-activity-command-add-email">
<i></i>
<span><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_LIST_ADD_EMAIL'));
?>
</span>
</li>
<?php
}
?>
</ul>
<?php
}
?>
<table class="crm-view-table crm-activity-table">
<thead>
<tr class="crm-activity-table-head" style="<?php
echo $count > 0 ? '' : 'display:none;';
?>
" >
<td> </td>
<td><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_ROW_COL_TTL_TYPE'));
?>
</td>
<td><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_ROW_COL_TTL_SUBJECT'));
?>
</td>
<td><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_ROW_COL_TTL_DEAD_LINE'));
?>
</td>
<td><?php
echo htmlspecialcharsbx(GetMessage('CRM_ACTIVITY_ROW_COL_TTL_RESPONSIBLE'));
?>
</td>
</tr>
</thead>
<tbody>
<?php
$processed = 0;
for ($i = 0; $i < $count; $i++) {
$item =& $items[$i];
if ($showMode == 'NOT_COMPLETED' && $item['COMPLETED'] == 'Y' || $showMode == 'COMPLETED' && $item['COMPLETED'] == 'N') {
continue;
}
$processed++;
$commData = array();
if (isset($item['COMMUNICATIONS'])) {
foreach ($item['COMMUNICATIONS'] as &$arComm) {
CCrmActivity::PrepareCommunicationInfo($arComm);
$commData[] = array('id' => $arComm['ID'], 'type' => $arComm['TYPE'], 'value' => $arComm['VALUE'], 'entityId' => $arComm['ENTITY_ID'], 'entityType' => CCrmOwnerType::ResolveName($arComm['ENTITY_TYPE_ID']), 'entityTitle' => $arComm['TITLE']);
}
unset($arComm);
}
$rowID = $editorCfg['PREFIX'];
if ($rowID !== '') {
$rowID .= '_';
}
$rowID .= '_row_' . strval($processed);
$editorItem = array('ID' => $item['~ID'], 'rowID' => $rowID, 'typeID' => $item['~TYPE_ID'], 'subject' => strval($item['~SUBJECT']), 'description' => strval($item['~DESCRIPTION']), 'direction' => intval($item['~DIRECTION']), 'location' => strval($item['~LOCATION']), 'start' => isset($item['~START_TIME']) ? ConvertTimeStamp(MakeTimeStamp($item['~START_TIME']), 'FULL', SITE_ID) : '', 'end' => isset($item['~END_TIME']) ? ConvertTimeStamp(MakeTimeStamp($item['~END_TIME']), 'FULL', SITE_ID) : '', 'deadline' => isset($item['~DEADLINE']) ? ConvertTimeStamp(MakeTimeStamp($item['~DEADLINE']), 'FULL', SITE_ID) : '', 'completed' => strval($item['~COMPLETED']) == 'Y', 'notifyType' => intval($item['~NOTIFY_TYPE']), 'notifyValue' => intval($item['~NOTIFY_VALUE']), 'priority' => intval($item['~PRIORITY']), 'responsibleID' => isset($item['~RESPONSIBLE_ID'][0]) ? intval($item['~RESPONSIBLE_ID']) : 0, 'responsibleName' => isset($item['~RESPONSIBLE_FULL_NAME'][0]) ? $item['~RESPONSIBLE_FULL_NAME'] : GetMessage('CRM_UNDEFINED_VALUE'), 'storageTypeID' => intval($item['STORAGE_TYPE_ID']), 'files' => $item['FILES'], 'webdavelements' => $item['WEBDAV_ELEMENTS'], 'associatedEntityID' => isset($item['~ASSOCIATED_ENTITY_ID']) ? intval($item['~ASSOCIATED_ENTITY_ID']) : 0, 'communications' => $commData);
if (isset($item['OWNER_TYPE_ID']) && isset($item['OWNER_ID'])) {
$editorItem['ownerType'] = CCrmOwnerType::ResolveName($item['OWNER_TYPE_ID']);
$editorItem['ownerID'] = $item['OWNER_ID'];
$editorItem['ownerTitle'] = CCrmOwnerType::GetCaption($item['OWNER_TYPE_ID'], $item['OWNER_ID']);
$editorItem['ownerUrl'] = CCrmOwnerType::GetShowUrl($item['OWNER_TYPE_ID'], $item['OWNER_ID']);
}
$editorItems[] = $editorItem;
$rowClass = 'crm-activity-row';
if ($processed % 2 === 0) {
$rowClass .= ' crm-activity-row-even';
}
if (intval($item['~PRIORITY']) === CCrmActivityPriority::High) {
$rowClass .= ' crm-activity-row-important';
}
?>
<tr id="<?php
echo htmlspecialcharsbx($rowID);
?>
" class="<?php
echo htmlspecialcharsbx($rowClass);
?>
" style="<?php
echo $showTop > 0 && $processed > $showTop ? 'display:none;' : '';
?>
">
<td><!--Delete-->
<?php
if (!$arResult['READ_ONLY']) {
?>
<span class="crm-view-table-column-delete"></span>
<?php
}
?>
</td>
<td> <!--Type-->
<a class="crm-activity-type" href="#"><?php
echo $item['TYPE_NAME'];
?>
</a>
</td>
<td> <!--Subject-->
<a class="crm-activity-subject" href="#"><?php
echo $item['SUBJECT'];
?>
</a>
</td>
<td> <!--End time-->
<?php
$deadline = isset($item['~DEADLINE']) ? MakeTimeStamp($item['~DEADLINE']) : null;
?>
<span <?php
echo $item['~COMPLETED'] !== 'Y' && $deadline !== null && $deadline < $now ? 'style="color:#ff0000;"' : '';
?>
>
<?php
echo $deadline !== null ? htmlspecialcharsbx(CCrmComponentHelper::TrimDateTimeString(FormatDate('FULL', $deadline))) : '';
?>
</span>
</td>
<td> <!--Responsible-->
<span>
<?php
echo isset($item['RESPONSIBLE_FULL_NAME'][0]) ? $item['RESPONSIBLE_FULL_NAME'] : GetMessage('CRM_UNDEFINED_VALUE');
?>
</span>
</td>
</tr>
<?php
}
unset($item);
?>
</tbody>
</table>
<?php
if ($showTop > 0 && $processed > $showTop) {
?>
<div class="crm-activity-show-all-wrapper">
<a href="#" class="crm-activity-command-show-all" ><?php
echo str_replace('#COUNT#', strval($processed), GetMessage('CRM_ACTIVITY_SHOW_ALL'));
?>
</a>
</div>
<?php
}
$GLOBALS['APPLICATION']->IncludeComponent('bitrix:crm.activity.editor', '', array('CONTAINER_ID' => $editorCfg['CONTAINER_ID'], 'EDITOR_ID' => $editorCfg['EDITOR_ID'], 'EDITOR_TYPE' => $editorCfg['EDITOR_TYPE'], 'PREFIX' => $editorCfg['PREFIX'], 'OWNER_TYPE' => $editorCfg['OWNER_TYPE'], 'OWNER_ID' => $editorCfg['OWNER_ID'], 'ENABLE_TASK_ADD' => $editorCfg['ENABLE_TASK_ADD'], 'ENABLE_CALENDAR_EVENT_ADD' => $editorCfg['ENABLE_CALENDAR_EVENT_ADD'], 'ENABLE_EMAIL_ADD' => $editorCfg['ENABLE_EMAIL_ADD'], 'READ_ONLY' => $editorCfg['READ_ONLY'], 'ENABLE_UI' => $editorCfg['ENABLE_UI'], 'ENABLE_TOOLBAR' => $editorCfg['ENABLE_TOOLBAR'], 'TOOLBAR_ID' => $toolbarID, 'BUTTON_ID' => $editorCfg['BUTTON_ID'], 'EDITOR_ITEMS' => $editorItems), null, array('HIDE_ICONS' => 'Y'));
}
$arResult["arLogTmpID"][] = $arEventsID["ID"];
$arTmpEventsNew[] = $arEventsID;
if (in_array($arEventsID["EVENT_ID"], array("blog_post", "blog_post_important", "idea")) && intval($arEventsID["SOURCE_ID"]) > 0) {
$arDiskUFEntity["BLOG_POST"][] = $arEventsID["SOURCE_ID"];
} elseif (!in_array($arEventsID["EVENT_ID"], array("data", "photo", "photo_photo", "bitrix24_new_user", "intranet_new_user", "news"))) {
$arDiskUFEntity["SONET_LOG"][] = $arEventsID["ID"];
}
}
if (isset($arDiskUFEntity) && (!empty($arDiskUFEntity["SONET_LOG"]) || !empty($arDiskUFEntity["BLOG_POST"]))) {
$events = GetModuleEvents("socialnetwork", "OnAfterFetchDiskUfEntity");
while ($arEvent = $events->Fetch()) {
ExecuteModuleEventEx($arEvent, array($arDiskUFEntity));
}
}
if (!empty($arActivity2Log) && CModule::IncludeModule('crm') && CModule::IncludeModule('tasks')) {
$rsActivity = CCrmActivity::GetList(array(), array("@ID" => array_keys($arActivity2Log), "TYPE_ID" => CCrmActivityType::Task, "CHECK_PERMISSIONS" => "N"), false, false, array("ID", "ASSOCIATED_ENTITY_ID"));
while (($arActivity = $rsActivity->Fetch()) && intval($arActivity["ASSOCIATED_ENTITY_ID"]) > 0) {
$taskItem = new CTaskItem(intval($arActivity["ASSOCIATED_ENTITY_ID"]), $GLOBALS["USER"]->GetId());
if (!$taskItem->CheckCanRead()) {
unset($arActivity2Log[$arActivity["ID"]]);
}
}
}
if ($bFirstPage) {
$last_date = $arTmpEventsNew[count($arTmpEventsNew) - 1][$arParams["USE_FOLLOW"] == "Y" ? "DATE_FOLLOW" : "LOG_UPDATE"];
} elseif ($dbEventsID && $dbEventsID->NavContinue() && ($arEvents = $dbEventsID->GetNext())) {
$next_page_date = $arParams["USE_FOLLOW"] == "Y" ? $arEvents["DATE_FOLLOW"] : $arEvents["LOG_UPDATE"];
if ($GLOBALS["USER"]->IsAuthorized() && $arResult["LAST_LOG_TS"] < MakeTimeStamp($next_page_date)) {
$next_page_date = $arResult["LAST_LOG_TS"];
}
}
public function Delete($ID, $arOptions = array())
{
global $DB, $APPLICATION;
$ID = intval($ID);
$iUserId = CCrmSecurityHelper::GetCurrentUserID();
$this->LAST_ERROR = '';
$APPLICATION->ResetException();
if (!is_array($arOptions)) {
$arOptions = array();
}
if (isset($arOptions['CHECK_DEPENDENCIES']) && (bool) $arOptions['CHECK_DEPENDENCIES']) {
$dbRes = self::GetListEx(array(), array('=ID' => $ID), false, false, array('TITLE', 'STATUS_ID', 'COMPANY_ID', 'CONTACT_ID'));
$arFields = $dbRes ? $dbRes->Fetch() : null;
if (is_array($arFields) && isset($arFields['STATUS_ID']) && $arFields['STATUS_ID'] === 'CONVERTED' && (CCrmCompany::Exists(isset($arFields['COMPANY_ID']) ? intval($arFields['COMPANY_ID']) : 0) || CCrmContact::Exists(isset($arFields['CONTACT_ID']) ? intval($arFields['CONTACT_ID']) : 0))) {
$title = isset($arFields['TITLE']) && $arFields['TITLE'] !== '' ? $arFields['TITLE'] : $ID;
$err = GetMessage('CRM_LEAD_DELETION_DEPENDENCIES_FOUND', array('#TITLE#' => $title));
$this->LAST_ERROR = $err;
$APPLICATION->throwException($err);
return false;
}
}
$sWherePerm = '';
if ($this->bCheckPermission) {
$arEntityAttr = $this->cPerms->GetEntityAttr('LEAD', $ID);
$sEntityPerm = $this->cPerms->GetPermType('LEAD', 'DELETE', $arEntityAttr[$ID]);
if ($sEntityPerm == BX_CRM_PERM_NONE) {
return false;
} else {
if ($sEntityPerm == BX_CRM_PERM_SELF) {
$sWherePerm = " AND ASSIGNED_BY_ID = {$iUserId}";
} else {
if ($sEntityPerm == BX_CRM_PERM_OPEN) {
$sWherePerm = " AND (OPENED = 'Y' OR ASSIGNED_BY_ID = {$iUserId})";
}
}
}
}
$events = GetModuleEvents('crm', 'OnBeforeCrmLeadDelete');
while ($arEvent = $events->Fetch()) {
if (ExecuteModuleEventEx($arEvent, array($ID)) === false) {
$err = GetMessage("MAIN_BEFORE_DEL_ERR") . ' ' . $arEvent['TO_NAME'];
if ($ex = $APPLICATION->GetException()) {
$err .= ': ' . $ex->GetString();
}
$APPLICATION->throwException($err);
$this->LAST_ERROR = $err;
return false;
}
}
//By defaut we need to clean up related bizproc entities
$processBizproc = isset($arOptions['PROCESS_BIZPROC']) ? (bool) $arOptions['PROCESS_BIZPROC'] : true;
if ($processBizproc) {
$bizproc = new CCrmBizProc('LEAD');
$bizproc->ProcessDeletion($ID);
}
$tableName = CCrmLead::TABLE_NAME;
$sSql = "DELETE FROM {$tableName} WHERE ID = {$ID}{$sWherePerm}";
$obRes = $DB->Query($sSql, false, 'FILE: ' . __FILE__ . '<br /> LINE: ' . __LINE__);
if (is_object($obRes) && $obRes->AffectedRowsCount() > 0) {
CCrmSearch::DeleteSearch('LEAD', $ID);
$DB->Query("DELETE FROM b_crm_entity_perms WHERE ENTITY='LEAD' AND ENTITY_ID = {$ID}", false, 'FILE: ' . __FILE__ . '<br /> LINE: ' . __LINE__);
$GLOBALS['USER_FIELD_MANAGER']->Delete(self::$sUFEntityID, $ID);
$CCrmFieldMulti = new CCrmFieldMulti();
$CCrmFieldMulti->DeleteByElement('LEAD', $ID);
$CCrmEvent = new CCrmEvent();
$CCrmEvent->DeleteByElement('LEAD', $ID);
\Bitrix\Crm\EntityAddress::unregister(CCrmOwnerType::Lead, $ID, \Bitrix\Crm\EntityAddress::Primary);
\Bitrix\Crm\Integrity\DuplicateEntityRanking::unregisterEntityStatistics(CCrmOwnerType::Lead, $ID);
\Bitrix\Crm\Integrity\DuplicatePersonCriterion::unregister(CCrmOwnerType::Lead, $ID);
\Bitrix\Crm\Integrity\DuplicateOrganizationCriterion::unregister(CCrmOwnerType::Lead, $ID);
\Bitrix\Crm\Integrity\DuplicateCommunicationCriterion::unregister(CCrmOwnerType::Lead, $ID);
\Bitrix\Crm\Integrity\DuplicateIndexMismatch::unregisterEntity(CCrmOwnerType::Lead, $ID);
$enableDupIndexInvalidation = is_array($arOptions) && isset($arOptions['ENABLE_DUP_INDEX_INVALIDATION']) ? (bool) $arOptions['ENABLE_DUP_INDEX_INVALIDATION'] : true;
if ($enableDupIndexInvalidation) {
\Bitrix\Crm\Integrity\DuplicateIndexBuilder::markAsJunk(CCrmOwnerType::Lead, $ID);
}
// Deletion of lead details
CCrmProductRow::DeleteByOwner('L', $ID);
CCrmProductRow::DeleteSettings('L', $ID);
CCrmActivity::DeleteByOwner(CCrmOwnerType::Lead, $ID);
CCrmSonetSubscription::UnRegisterSubscriptionByEntity(CCrmOwnerType::Lead, $ID);
CCrmLiveFeed::DeleteLogEvents(array('ENTITY_TYPE_ID' => CCrmOwnerType::Lead, 'ENTITY_ID' => $ID));
if (defined("BX_COMP_MANAGED_CACHE")) {
$GLOBALS["CACHE_MANAGER"]->ClearByTag("crm_entity_name_" . CCrmOwnerType::Lead . "_" . $ID);
}
$afterEvents = GetModuleEvents('crm', 'OnAfterCrmLeadDelete');
while ($arEvent = $afterEvents->Fetch()) {
ExecuteModuleEventEx($arEvent, array($ID));
}
}
return true;
}
$ownerTypeID = CCrmOwnerType::ResolveID($ownerTypeName);
$ownerID = isset($binding['ID']) ? (int) $binding['ID'] : 0;
if ($ownerTypeID === CCrmOwnerType::Undefined || $ownerID <= 0) {
die;
}
$userPermissions = CCrmPerms::GetCurrentUserPermissions();
if (!CCrmActivity::CheckReadPermission($ownerTypeID, $ownerID, $userPermissions)) {
die;
}
if (count($bindings) > 1) {
array_splice($bindings, 1);
}
$componentParams['BINDINGS'] = $componentData['params']['BINDINGS'] = $bindings;
//Sanitaizing of Permission Type
$permissionType = isset($componentParams['PERMISSION_TYPE']) ? strtoupper($componentParams['PERMISSION_TYPE']) : 'READ';
if ($permissionType !== 'READ' && !CCrmActivity::CheckUpdatePermission($ownerTypeID, $ownerID, $userPermissions)) {
$componentParams['PERMISSION_TYPE'] = $componentData['params']['PERMISSION_TYPE'] = 'READ';
}
//For custom reload with params
$ajaxLoaderParams = array('url' => '', 'method' => 'POST', 'dataType' => 'ajax', 'data' => array('PARAMS' => $componentData));
global $APPLICATION;
Header('Content-Type: text/html; charset=' . LANG_CHARSET);
$APPLICATION->ShowAjaxHead();
$componentParams['ENABLE_CONTROL_PANEL'] = false;
//Force AJAX mode
$componentParams['AJAX_MODE'] = 'Y';
$componentParams['AJAX_OPTION_JUMP'] = 'N';
$componentParams['AJAX_OPTION_HISTORY'] = 'N';
$componentParams['AJAX_LOADER'] = $ajaxLoaderParams;
$APPLICATION->IncludeComponent('bitrix:crm.activity.list', isset($componentData['template']) ? $componentData['template'] : '', $componentParams, false, array('HIDE_ICONS' => 'Y', 'ACTIVE_COMPONENT' => 'Y'));
require_once $_SERVER['DOCUMENT_ROOT'] . '/bitrix/modules/main/include/epilog_after.php';
public static function prepareRecoveryData($entityTypeID, $entityID, array $options = null)
{
if (!is_int($entityTypeID)) {
$entityTypeID = intval($entityTypeID);
}
if (!\CCrmOwnerType::IsDefined($entityTypeID)) {
throw new Main\ArgumentException('Is not defined', 'entityTypeID');
}
if (!is_int($entityID)) {
$entityID = intval($entityID);
}
if ($entityID <= 0) {
throw new Main\ArgumentException('Must be greater than zero', 'entityID');
}
if (!is_array($options)) {
$options = array();
}
$item = new EntityRecoveryData();
$item->setEntityTypeID($entityTypeID);
$item->setEntityID($entityID);
$userID = isset($options['USER_ID']) ? intval($options['USER_ID']) : 0;
if ($userID > 0) {
$item->setUserID($userID);
}
if ($entityTypeID === \CCrmOwnerType::Lead) {
$result = \CCrmLead::GetListEx(array(), array('=ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('*', 'UF_*'));
$fields = is_object($result) ? $result->Fetch() : null;
if (!is_array($fields)) {
throw new Main\ObjectNotFoundException("The lead with ID '{$entityTypeID}' is not found");
}
$item->setDataItem('FIELDS', $fields);
if (isset($fields['TITLE'])) {
$item->setTitle($fields['TITLE']);
}
if (isset($fields['ASSIGNED_BY_ID'])) {
$item->setResponsibleID(intval($fields['ASSIGNED_BY_ID']));
}
} elseif ($entityTypeID === \CCrmOwnerType::Contact) {
$result = \CCrmContact::GetListEx(array(), array('=ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('*', 'UF_*'));
$fields = is_object($result) ? $result->Fetch() : null;
if (!is_array($fields)) {
throw new Main\ObjectNotFoundException("The contact with ID '{$entityTypeID}' is not found");
}
$item->setDataItem('FIELDS', $fields);
$item->setTitle(\CCrmContact::GetFullName($fields, true));
if (isset($fields['ASSIGNED_BY_ID'])) {
$item->setResponsibleID(intval($fields['ASSIGNED_BY_ID']));
}
} elseif ($entityTypeID === \CCrmOwnerType::Company) {
$result = \CCrmCompany::GetListEx(array(), array('=ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, false, array('*', 'UF_*'));
$fields = is_object($result) ? $result->Fetch() : null;
if (!is_array($fields)) {
throw new Main\ObjectNotFoundException("The company with ID '{$entityTypeID}' is not found");
}
$item->setDataItem('FIELDS', $fields);
if (isset($fields['TITLE'])) {
$item->setTitle($fields['TITLE']);
}
if (isset($fields['ASSIGNED_BY_ID'])) {
$item->setResponsibleID(intval($fields['ASSIGNED_BY_ID']));
}
} else {
throw new Main\NotSupportedException("The entity type '" . \CCrmOwnerType::ResolveName($entityTypeID) . "' is not supported in current context");
}
$entityTypeName = \CCrmOwnerType::ResolveName($entityTypeID);
//MULTI FIELDS -->
$multiFieldData = array();
$multiFieldTypes = array(\CCrmFieldMulti::PHONE, \CCrmFieldMulti::EMAIL, \CCrmFieldMulti::WEB, \CCrmFieldMulti::IM);
foreach ($multiFieldTypes as $multiFieldType) {
$result = \CCrmFieldMulti::GetListEx(array('ID' => 'ASC'), array('TYPE_ID' => $multiFieldType, 'ENTITY_ID' => $entityTypeName, 'ELEMENT_ID' => $entityID, 'CHECK_PERMISSIONS' => 'N'), false, array('nTopCount' => 50), array('VALUE_TYPE', 'VALUE'));
if (!is_object($result)) {
continue;
}
while ($multiFields = $result->Fetch()) {
$valueType = isset($multiFields['VALUE_TYPE']) ? $multiFields['VALUE_TYPE'] : '';
$value = isset($multiFields['VALUE']) ? $multiFields['VALUE'] : '';
if ($value === '') {
continue;
}
if (!isset($multiFieldData[$multiFieldType])) {
$multiFieldData[$multiFieldType] = array();
}
$multiFieldData[$multiFieldType][] = array('VALUE_TYPE' => $valueType, 'VALUE' => $value);
}
}
if (!empty($multiFieldData)) {
$item->setDataItem('MULTI_FIELDS', $multiFieldData);
}
//<-- MULTI FIELDS
//ACTIVITIES -->
$activityIDs = \CCrmActivity::GetBoundIDs($entityTypeID, $entityID);
if (!empty($activityIDs)) {
$item->setDataItem('ACTIVITY_IDS', $activityIDs);
}
//<-- ACTIVITIES
//EVENTS -->
$eventIDs = array();
$result = \CCrmEvent::GetListEx(array('EVENT_REL_ID' => 'ASC'), array('ENTITY_TYPE' => $entityTypeName, 'ENTITY_ID' => $entityID, 'EVENT_TYPE' => 0, 'CHECK_PERMISSIONS' => 'N'), false, false, array('EVENT_REL_ID'));
if (is_object($result)) {
while ($eventFields = $result->Fetch()) {
$eventIDs[] = intval($eventFields['EVENT_REL_ID']);
}
}
if (!empty($eventIDs)) {
$item->setDataItem('EVENT_IDS', $eventIDs);
}
//<-- EVENTS
return $item;
}
$arContact['PATH_TO_CONTACT_SHOW'] = CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_CONTACT_SHOW'], array('contact_id' => $arContact['ID']));
$arContact['PATH_TO_CONTACT_EDIT'] = CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_CONTACT_EDIT'], array('contact_id' => $arContact['ID']));
$arContact['PATH_TO_CONTACT_COPY'] = CHTTP::urlAddParams(CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_CONTACT_EDIT'], array('contact_id' => $arContact['ID'])), array('copy' => 1));
$arContact['PATH_TO_CONTACT_DELETE'] = CHTTP::urlAddParams($bInternal ? $APPLICATION->GetCurPage() : $arParams['PATH_TO_CONTACT_LIST'], array('action_' . $arResult['GRID_ID'] => 'delete', 'ID' => $arContact['ID'], 'sessid' => $arResult['SESSION_ID']));
$arContact['PATH_TO_USER_PROFILE'] = CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_USER_PROFILE'], array('user_id' => $arContact['ASSIGNED_BY']));
$arContact['CONTACT_FORMATTED_NAME'] = CUser::FormatName(\Bitrix\Crm\Format\PersonNameFormatter::getFormat(), array('LOGIN' => '', 'NAME' => $arContact['NAME'], 'LAST_NAME' => $arContact['LAST_NAME'], 'SECOND_NAME' => $arContact['SECOND_NAME']), false, false);
$typeID = isset($arContact['TYPE_ID']) ? $arContact['TYPE_ID'] : '';
$arContact['CONTACT_TYPE_NAME'] = isset($arResult['TYPE_LIST'][$typeID]) ? $arResult['TYPE_LIST'][$typeID] : $typeID;
$arContact['PATH_TO_USER_CREATOR'] = CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_USER_PROFILE'], array('user_id' => $arContact['CREATED_BY']));
$arContact['PATH_TO_USER_MODIFIER'] = CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_USER_PROFILE'], array('user_id' => $arContact['MODIFY_BY']));
$arContact['CREATED_BY_FORMATTED_NAME'] = CUser::FormatName($arParams['NAME_TEMPLATE'], array('LOGIN' => $arContact['CREATED_BY_LOGIN'], 'NAME' => $arContact['CREATED_BY_NAME'], 'LAST_NAME' => $arContact['CREATED_BY_LAST_NAME'], 'SECOND_NAME' => $arContact['CREATED_BY_SECOND_NAME']), true, false);
$arContact['MODIFY_BY_FORMATTED_NAME'] = CUser::FormatName($arParams['NAME_TEMPLATE'], array('LOGIN' => $arContact['MODIFY_BY_LOGIN'], 'NAME' => $arContact['MODIFY_BY_NAME'], 'LAST_NAME' => $arContact['MODIFY_BY_LAST_NAME'], 'SECOND_NAME' => $arContact['MODIFY_BY_SECOND_NAME']), true, false);
if (isset($arContact['~ACTIVITY_TIME'])) {
$time = MakeTimeStamp($arContact['~ACTIVITY_TIME']);
$arContact['~ACTIVITY_EXPIRED'] = $time <= $now;
$arContact['~ACTIVITY_IS_CURRENT_DAY'] = $arContact['~ACTIVITY_EXPIRED'] || CCrmActivity::IsCurrentDay($time);
}
if ($arResult['ENABLE_TASK']) {
$arContact['PATH_TO_TASK_EDIT'] = CHTTP::urlAddParams(CComponentEngine::MakePathFromTemplate(COption::GetOptionString('tasks', 'paths_task_user_edit', ''), array('task_id' => 0, 'user_id' => $userID)), array('UF_CRM_TASK' => 'C_' . $arContact['ID'], 'TITLE' => urlencode(GetMessage('CRM_TASK_TITLE_PREFIX')), 'TAGS' => urlencode(GetMessage('CRM_TASK_TAG')), 'back_url' => urlencode($arParams['PATH_TO_CONTACT_LIST'])));
}
if (IsModuleInstalled('sale')) {
$arContact['PATH_TO_QUOTE_ADD'] = CHTTP::urlAddParams(CComponentEngine::makePathFromTemplate($arParams['PATH_TO_QUOTE_EDIT'], array('quote_id' => 0)), array('contact_id' => $arContact['ID']));
$arContact['PATH_TO_INVOICE_ADD'] = CHTTP::urlAddParams(CComponentEngine::makePathFromTemplate($arParams['PATH_TO_INVOICE_EDIT'], array('invoice_id' => 0)), array('contact' => $arContact['ID']));
}
if ($arResult['ENABLE_BIZPROC']) {
$arContact['BIZPROC_STATUS'] = '';
$arContact['BIZPROC_STATUS_HINT'] = '';
$arDocumentStates = CBPDocument::GetDocumentStates(array('crm', 'CCrmDocumentContact', 'CONTACT'), array('crm', 'CCrmDocumentContact', 'CONTACT_' . $arContact['ID']));
$arContact['PATH_TO_BIZPROC_LIST'] = CHTTP::urlAddParams(CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_CONTACT_SHOW'], array('contact_id' => $arContact['ID'])), array('CRM_CONTACT_SHOW_V12_active_tab' => 'tab_bizproc'));
$totalTaskQty = 0;
$docStatesQty = count($arDocumentStates);
protected function rebind($seedID, $targID)
{
\CCrmDeal::Rebind(\CCrmOwnerType::Contact, $seedID, $targID);
\CCrmQuote::Rebind(\CCrmOwnerType::Contact, $seedID, $targID);
\CCrmActivity::Rebind(\CCrmOwnerType::Contact, $seedID, $targID);
\CCrmLiveFeed::Rebind(\CCrmOwnerType::Contact, $seedID, $targID);
\CCrmSonetRelation::RebindRelations(\CCrmOwnerType::Contact, $seedID, $targID);
\CCrmEvent::Rebind(\CCrmOwnerType::Contact, $seedID, $targID);
}
<?php
if (!defined('B_PROLOG_INCLUDED') || B_PROLOG_INCLUDED !== true) {
die;
}
use Bitrix\Crm\Integration\StorageType;
global $APPLICATION;
$APPLICATION->AddHeadScript('/bitrix/js/crm/instant_editor.js');
$APPLICATION->SetAdditionalCSS('/bitrix/js/crm/css/crm.css');
$APPLICATION->SetAdditionalCSS("/bitrix/themes/.default/crm-entity-show.css");
if (SITE_TEMPLATE_ID === 'bitrix24') {
$APPLICATION->SetAdditionalCSS("/bitrix/themes/.default/bitrix24/crm-entity-show.css");
}
//Preliminary registration of disk api.
if (CCrmActivity::GetDefaultStorageTypeID() === StorageType::Disk) {
CJSCore::Init(array('uploader', 'file_dialog'));
}
$arResult['CRM_CUSTOM_PAGE_TITLE'] = GetMessage('CRM_COMPANY_SHOW_TITLE', array('#ID#' => $arResult['ELEMENT']['ID'], '#TITLE#' => $arResult['ELEMENT']['TITLE']));
$enableInstantEdit = $arResult['ENABLE_INSTANT_EDIT'];
$instantEditorID = strtolower($arResult['FORM_ID']) . '_editor';
$bizprocDispatcherID = strtolower($arResult['FORM_ID']) . '_bp_disp';
$arTabs = array();
$arTabsExt = array();
$arTabs[] = array('id' => 'tab_1', 'name' => GetMessage('CRM_TAB_1'), 'title' => GetMessage('CRM_TAB_1_TITLE'), 'icon' => '', 'fields' => $arResult['FIELDS']['tab_1'], 'display' => false);
$arTabs[] = array('id' => 'tab_details', 'name' => GetMessage('CRM_TAB_DETAILS'), 'title' => GetMessage('CRM_TAB_DETAILS_TITLE'), 'icon' => '', 'fields' => $arResult['FIELDS']['tab_details'], 'display' => false);
$liveFeedTab = null;
if (!empty($arResult['FIELDS']['tab_live_feed'])) {
$liveFeedTab = array('id' => 'tab_live_feed', 'name' => GetMessage('CRM_TAB_LIVE_FEED'), 'title' => GetMessage('CRM_TAB_LIVE_FEED_TITLE'), 'icon' => '', 'fields' => $arResult['FIELDS']['tab_live_feed']);
$arTabs[] = $liveFeedTab;
}
if (!empty($arResult['FIELDS']['tab_activity'])) {
public function Delete($ID, $arOptions = array())
{
global $DB, $APPLICATION;
$ID = intval($ID);
$iUserId = CCrmSecurityHelper::GetCurrentUserID();
if (!is_array($arOptions)) {
$arOptions = array();
}
$sWherePerm = '';
if ($this->bCheckPermission) {
$arEntityAttr = $this->cPerms->GetEntityAttr('DEAL', $ID);
$sEntityPerm = $this->cPerms->GetPermType('DEAL', 'DELETE', $arEntityAttr[$ID]);
if ($sEntityPerm == BX_CRM_PERM_NONE) {
return false;
} else {
if ($sEntityPerm == BX_CRM_PERM_SELF) {
$sWherePerm = " AND ASSIGNED_BY_ID = {$iUserId}";
} else {
if ($sEntityPerm == BX_CRM_PERM_OPEN) {
$sWherePerm = " AND (OPENED = 'Y' OR ASSIGNED_BY_ID = {$iUserId})";
}
}
}
}
$APPLICATION->ResetException();
$events = GetModuleEvents('crm', 'OnBeforeCrmDealDelete');
while ($arEvent = $events->Fetch()) {
if (ExecuteModuleEventEx($arEvent, array($ID)) === false) {
$err = GetMessage("MAIN_BEFORE_DEL_ERR") . ' ' . $arEvent['TO_NAME'];
if ($ex = $APPLICATION->GetException()) {
$err .= ': ' . $ex->GetString();
}
$APPLICATION->throwException($err);
return false;
}
}
//By defaut we need to clean up related bizproc entities
$processBizproc = isset($arOptions['PROCESS_BIZPROC']) ? (bool) $arOptions['PROCESS_BIZPROC'] : true;
if ($processBizproc) {
$bizproc = new CCrmBizProc('DEAL');
$bizproc->ProcessDeletion($ID);
}
$dbRes = $DB->Query("DELETE FROM b_crm_deal WHERE ID = {$ID}{$sWherePerm}", false, 'FILE: ' . __FILE__ . '<br /> LINE: ' . __LINE__);
if (is_object($dbRes) && $dbRes->AffectedRowsCount() > 0) {
CCrmSearch::DeleteSearch('DEAL', $ID);
$DB->Query("DELETE FROM b_crm_entity_perms WHERE ENTITY='DEAL' AND ENTITY_ID = {$ID}", false, 'FILE: ' . __FILE__ . '<br /> LINE: ' . __LINE__);
$GLOBALS['USER_FIELD_MANAGER']->Delete(self::$sUFEntityID, $ID);
$CCrmFieldMulti = new CCrmFieldMulti();
$CCrmFieldMulti->DeleteByElement('DEAL', $ID);
$CCrmEvent = new CCrmEvent();
$CCrmEvent->DeleteByElement('DEAL', $ID);
Bitrix\Crm\History\DealStageHistoryEntry::unregister($ID);
Bitrix\Crm\Statistics\DealSumStatisticEntry::unregister($ID);
Bitrix\Crm\Statistics\DealInvoiceStatisticEntry::unregister($ID);
Bitrix\Crm\Statistics\DealActivityStatisticEntry::unregister($ID);
// Deletion of deal details
CCrmProductRow::DeleteByOwner('D', $ID);
CCrmProductRow::DeleteSettings('D', $ID);
CCrmActivity::DeleteByOwner(CCrmOwnerType::Deal, $ID);
CCrmSonetSubscription::UnRegisterSubscriptionByEntity(CCrmOwnerType::Deal, $ID);
CCrmLiveFeed::DeleteLogEvents(array('ENTITY_TYPE_ID' => CCrmOwnerType::Deal, 'ENTITY_ID' => $ID));
self::PullChange('DELETE', array('ID' => $ID));
if (defined("BX_COMP_MANAGED_CACHE")) {
$GLOBALS["CACHE_MANAGER"]->ClearByTag("crm_entity_name_" . CCrmOwnerType::Deal . "_" . $ID);
}
$afterEvents = GetModuleEvents('crm', 'OnAfterCrmDealDelete');
while ($arEvent = $afterEvents->Fetch()) {
ExecuteModuleEventEx($arEvent, array($ID));
}
}
return true;
}