|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/Calendar/actions/ |
Upload File : |
<?php
/*+***********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*************************************************************************************/
vimport ('~~/include/Webservices/Query.php');
if (class_exists("ParsVT_Loader")) {
ParsVT_Loader::ParsAutoload('Calendar_Feed_Action');
}
if (!class_exists("Calendar_Feed_Action")) {
class Calendar_Feed_Action extends Vtiger_BasicAjax_Action {
public function process(Vtiger_Request $request) {
if($request->get('mode') === 'batch') {
$feedsRequest = $request->get('feedsRequest',array());
$result = array();
if(count($feedsRequest)) {
foreach($feedsRequest as $key=>$value) {
$requestParams = array();
$requestParams['start'] = $value['start'];
$requestParams['end'] = $value['end'];
$requestParams['type'] = $value['type'];
$requestParams['userid'] = $value['userid'];
$requestParams['color'] = $value['color'];
$requestParams['textColor'] = $value['textColor'];
$requestParams['targetModule'] = $value['targetModule'];
$requestParams['fieldname'] = $value['fieldname'];
$requestParams['group'] = $value['group'];
$requestParams['mapping'] = $value['mapping'];
$requestParams['conditions'] = $value['conditions'];
$result[$key] = $this->_process($requestParams);
}
}
echo json_encode($result);
} else {
$requestParams = array();
$requestParams['start'] = $request->get('start');
$requestParams['end'] = $request->get('end');
$requestParams['type'] = $request->get('type');
$requestParams['userid'] = $request->get('userid');
$requestParams['color'] = $request->get('color');
$requestParams['textColor'] = $request->get('textColor');
$requestParams['targetModule'] = $request->get('targetModule');
$requestParams['fieldname'] = $request->get('fieldname');
$requestParams['group'] = $request->get('group');
$requestParams['mapping'] = $request->get('mapping');
$requestParams['conditions'] = $request->get('conditions','');
echo $this->_process($requestParams);
}
}
public function _process($request) {
try {
$start = $request['start'];
$end = $request['end'];
$type = $request['type'];
$userid = $request['userid'];
$color = $request['color'];
$textColor = $request['textColor'];
$targetModule = $request['targetModule'];
$fieldName = $request['fieldname'];
$isGroupId = $request['group'];
$mapping = $request['mapping'];
$conditions = $request['conditions'];
$result = array();
switch ($type) {
case 'Events' : if($fieldName == 'date_start,due_date' || $userid) {
$this->pullEvents($start, $end, $result,$userid,$color,$textColor,$isGroupId,$conditions);
} else {
$this->pullDetails($start, $end, $result, $type, $fieldName, $color, $textColor, $conditions);
}
break;
case 'Calendar' : if($fieldName == 'date_start,due_date') {
$this->pullTasks($start, $end, $result,$color,$textColor);
} else {
$this->pullDetails($start, $end, $result, $type, $fieldName, $color, $textColor);
}
break;
case 'MultipleEvents' : $this->pullMultipleEvents($start,$end, $result,$mapping);break;
case $type : $this->pullDetails($start, $end, $result, $type, $fieldName, $color, $textColor);break;
}
return json_encode($result);
} catch (Exception $ex) {
return $ex->getMessage();
}
}
protected function pullDetails($start, $end, &$result, $type, $fieldName, $color = null, $textColor = 'white', $conditions = '') {
$moduleModel = Vtiger_Module_Model::getInstance($type);
$nameFields = $moduleModel->getNameFields();
foreach($nameFields as $i => $nameField) {
$fieldInstance = $moduleModel->getField($nameField);
if(!$fieldInstance->isViewable()) {
unset($nameFields[$i]);
}
}
$nameFields = array_values($nameFields);
$selectFields = implode(',', $nameFields);
$fieldsList = explode(',', $fieldName);
if(count($fieldsList) == 2) {
$db = PearDatabase::getInstance();
$user = Users_Record_Model::getCurrentUserModel();
$userAndGroupIds = array_merge(array($user->getId()),$this->getGroupsIdsForUsers($user->getId()));
$queryGenerator = new QueryGenerator($moduleModel->get('name'), $user);
$meta = $queryGenerator->getMeta($moduleModel->get('name'));
$queryGenerator->setFields(array_merge(array_merge($nameFields, array('id')), $fieldsList));
$query = $queryGenerator->getQuery();
$query.= " AND (($fieldsList[0] >= ? AND $fieldsList[1] < ?) OR ($fieldsList[1] >= ?)) ";
$params = array($start,$end,$start);
$query.= " AND vtiger_crmentity.smownerid IN (".generateQuestionMarks($userAndGroupIds).")";
$params = array_merge($params, $userAndGroupIds);
$queryResult = $db->pquery($query, $params);
$records = array();
while($rowData = $db->fetch_array($queryResult)) {
$records[] = DataTransform::sanitizeDataWithColumn($rowData, $meta);
}
} else {
if($fieldName == 'birthday') {
$startDateComponents = split('-', $start);
$endDateComponents = split('-', $end);
$year = $startDateComponents[0];
$db = PearDatabase::getInstance();
$user = Users_Record_Model::getCurrentUserModel();
$userAndGroupIds = array_merge(array($user->getId()),$this->getGroupsIdsForUsers($user->getId()));
$queryGenerator = new QueryGenerator($moduleModel->get('name'), $user);
$meta = $queryGenerator->getMeta($moduleModel->get('name'));
$queryGenerator->setFields(array_merge(array_merge($nameFields, array('id')), $fieldsList));
$query = $queryGenerator->getQuery();
$query.= " AND ((CONCAT('$year-', date_format(birthday,'%m-%d')) >= ? AND CONCAT('$year-', date_format(birthday,'%m-%d')) <= ? )";
$params = array($start,$end);
$endDateYear = $endDateComponents[0];
if ($year !== $endDateYear) {
$query .= " OR (CONCAT('$endDateYear-', date_format(birthday,'%m-%d')) >= ? AND CONCAT('$endDateYear-', date_format(birthday,'%m-%d')) <= ? )";
$params = array_merge($params,array($start,$end));
}
$query .= ")";
$query.= " AND vtiger_crmentity.smownerid IN (". generateQuestionMarks($userAndGroupIds).")";
$params = array_merge($params,$userAndGroupIds);
$queryResult = $db->pquery($query, $params);
$records = array();
while($rowData = $db->fetch_array($queryResult)) {
$records[] = DataTransform::sanitizeDataWithColumn($rowData, $meta);
}
} else {
$query = "SELECT $selectFields, $fieldsList[0] FROM $type";
$query.= " WHERE $fieldsList[0] >= '$start' AND $fieldsList[0] <= '$end' ";
if(!empty($conditions)) {
$conditions = Zend_Json::decode(Zend_Json::decode($conditions));
$query .= 'AND '.$this->generateCalendarViewConditionQuery($conditions);
}
if($type == 'PriceBooks') {
$records = $this->queryForRecords($query, false);
} else {
$records = $this->queryForRecords($query);
}
}
}
foreach ($records as $record) {
$item = array();
list ($modid, $crmid) = vtws_getIdComponents($record['id']);
$item['id'] = $crmid;
$item['title'] = decode_html($record[$nameFields[0]]);
if(count($nameFields) > 1) {
$item['title'] = decode_html(trim($record[$nameFields[0]].' '.$record[$nameFields[1]]));
}
if(!empty($record[$fieldsList[0]])) {
$item['start'] = $record[$fieldsList[0]];
} else {
$item['start'] = $record[$fieldsList[1]];
}
if(count($fieldsList) == 2) {
$item['end'] = $record[$fieldsList[1]];
}
if($fieldName == 'birthday') {
$recordDateTime = new DateTime($record[$fieldName]);
$calendarYear = $year;
if($recordDateTime->format('m') < $startDateComponents[1]) {
$calendarYear = $endDateYear;
}
$recordDateTime->setDate($calendarYear, $recordDateTime->format('m'), $recordDateTime->format('d'));
$item['start'] = $recordDateTime->format('Y-m-d');
}
$urlModule = $type;
if ($urlModule === 'Events') {
$urlModule = 'Calendar';
}
$item['url'] = sprintf('index.php?module='.$urlModule.'&view=Detail&record=%s', $crmid);
$item['color'] = $color;
$item['textColor'] = $textColor;
$item['module'] = $moduleModel->getName();
$item['sourceModule'] = $moduleModel->getName();
$item['fieldName'] = $fieldName;
$item['conditions'] = '';
if(!empty($conditions)) {
$item['conditions'] = Zend_Json::encode(Zend_Json::encode($conditions));
}
$result[] = $item;
}
}
protected function generateCalendarViewConditionQuery($conditions) {
$conditionQuery = $operator = '';
switch ($conditions['operator']) {
case 'e' : $operator = '=';
}
if(!empty($operator) && !empty($conditions['fieldname']) && !empty($conditions['value'])) {
$conditionQuery = ' '.$conditions['fieldname'].$operator.'\'' .$conditions['value'].'\' ';
}
return $conditionQuery;
}
protected function getGroupsIdsForUsers($userId) {
vimport('~~/include/utils/GetUserGroups.php');
$userGroupInstance = new GetUserGroups();
$userGroupInstance->getAllUserGroups($userId);
return $userGroupInstance->user_groups;
}
protected function queryForRecords($query, $onlymine=true) {
$user = Users_Record_Model::getCurrentUserModel();
if ($onlymine) {
$groupIds = $this->getGroupsIdsForUsers($user->getId());
$groupWsIds = array();
foreach($groupIds as $groupId) {
$groupWsIds[] = vtws_getWebserviceEntityId('Groups', $groupId);
}
$userwsid = vtws_getWebserviceEntityId('Users', $user->getId());
$userAndGroupIds = array_merge(array($userwsid),$groupWsIds);
$query .= " AND assigned_user_id IN ('".implode("','",$userAndGroupIds)."')";
}
// TODO take care of pulling 100+ records
return vtws_query($query.';', $user);
}
protected function pullEvents($start, $end, &$result, $userid = false, $color = null, $textColor = 'white', $isGroupId = false, $conditions = '') {
$dbStartDateOject = DateTimeField::convertToDBTimeZone($start);
$dbStartDateTime = $dbStartDateOject->format('Y-m-d H:i:s');
$dbStartDateTimeComponents = explode(' ', $dbStartDateTime);
$dbStartDate = $dbStartDateTimeComponents[0];
$dbEndDateObject = DateTimeField::convertToDBTimeZone($end);
$dbEndDateTime = $dbEndDateObject->format('Y-m-d H:i:s');
$currentUser = Users_Record_Model::getCurrentUserModel();
$db = PearDatabase::getInstance();
$groupsIds = Vtiger_Util_Helper::getGroupsIdsForUsers($currentUser->getId());
require('user_privileges/user_privileges_'.$currentUser->id.'.php');
require('user_privileges/sharing_privileges_'.$currentUser->id.'.php');
$moduleModel = Vtiger_Module_Model::getInstance('Events');
if($userid && !$isGroupId){
$focus = new Users();
$focus->id = $userid;
$focus->retrieve_entity_info($userid, 'Users');
$user = Users_Record_Model::getInstanceFromUserObject($focus);
$userName = $user->getName();
$queryGenerator = new QueryGenerator($moduleModel->get('name'), $user);
}else{
$queryGenerator = new QueryGenerator($moduleModel->get('name'), $currentUser);
}
$queryGenerator->setFields(array('subject', 'eventstatus', 'visibility','date_start','time_start','due_date','time_end','assigned_user_id','id','activitytype','recurringtype'));
$query = $queryGenerator->getQuery();
$query.= " AND vtiger_activity.activitytype NOT IN ('Emails','Task') AND ";
$hideCompleted = $currentUser->get('hidecompletedevents');
if($hideCompleted)
$query.= "vtiger_activity.eventstatus != 'HELD' AND ";
if(!empty($conditions)) {
$conditions = Zend_Json::decode(Zend_Json::decode($conditions));
$query .= $this->generateCalendarViewConditionQuery($conditions).'AND ';
}
$query.= " ((concat(date_start, '', time_start) >= '$dbStartDateTime' AND concat(due_date, '', time_end) < '$dbEndDateTime') OR ( due_date >= '$dbStartDate'))";
$params = array();
if(empty($userid)){
$eventUserId = $currentUser->getId();
$params = array_merge(array($eventUserId), $this->getGroupsIdsForUsers($eventUserId));
}else{
$eventUserId = $userid;
$params = array($eventUserId);
}
$query.= " AND vtiger_crmentity.smownerid IN (". generateQuestionMarks($params).")";
$queryResult = $db->pquery($query, $params);
while($record = $db->fetchByAssoc($queryResult)){
$item = array();
$crmid = $record['activityid'];
$visibility = $record['visibility'];
$activitytype = $record['activitytype'];
$status = $record['eventstatus'];
$ownerId = $record['smownerid'];
$item['id'] = $crmid;
$item['visibility'] = $visibility;
$item['activitytype'] = $activitytype;
$item['status'] = $status;
$recordBusy = true;
if(in_array($ownerId, $groupsIds)) {
$recordBusy = false;
} else if($ownerId == $currentUser->getId()){
$recordBusy = false;
}
// if the user is having view all permission then it should show the record
// as we are showing in detail view
if($profileGlobalPermission[1] ==0 || $profileGlobalPermission[2] ==0) {
$recordBusy = false;
}
if(!$currentUser->isAdminUser() && $visibility == 'Private' && $userid && $userid != $currentUser->getId() && $recordBusy) {
$item['title'] = decode_html($userName).' - '.decode_html(vtranslate('Busy','Events')).'*';
$item['url'] = '';
} else {
$item['title'] = decode_html($record['subject']).' - ('.decode_html(vtranslate($record['eventstatus'],'Calendar')).')';
$item['url'] = sprintf('index.php?module=Calendar&view=Detail&record=%s', $crmid);
}
$dateTimeFieldInstance = new DateTimeField($record['date_start'].' '.$record['time_start']);
$userDateTimeString = $dateTimeFieldInstance->getDisplayDateTimeValue($currentUser);
$dateTimeComponents = explode(' ',$userDateTimeString);
$dateComponent = $dateTimeComponents[0];
//Conveting the date format in to Y-m-d.since full calendar expects in the same format
$dataBaseDateFormatedString = DateTimeField::__convertToDBFormat($dateComponent, $currentUser->get('date_format'));
$item['start'] = $dataBaseDateFormatedString.' '. $dateTimeComponents[1];
$dateTimeFieldInstance = new DateTimeField($record['due_date'].' '.$record['time_end']);
$userDateTimeString = $dateTimeFieldInstance->getDisplayDateTimeValue($currentUser);
$dateTimeComponents = explode(' ',$userDateTimeString);
$dateComponent = $dateTimeComponents[0];
//Conveting the date format in to Y-m-d.since full calendar expects in the same format
$dataBaseDateFormatedString = DateTimeField::__convertToDBFormat($dateComponent, $currentUser->get('date_format'));
$item['end'] = $dataBaseDateFormatedString.' '. $dateTimeComponents[1];
$item['className'] = $cssClass;
$item['allDay'] = false;
$item['color'] = $color;
$item['textColor'] = $textColor;
$item['module'] = $moduleModel->getName();
$recurringCheck = false;
if($record['recurringtype'] != '' && $record['recurringtype'] != '--None--') {
$recurringCheck = true;
}
$item['recurringcheck'] = $recurringCheck;
$item['userid'] = $eventUserId;
$item['fieldName'] = 'date_start,due_date';
$item['conditions'] = '';
if(!empty($conditions)) {
$item['conditions'] = Zend_Json::encode(Zend_Json::encode($conditions));
}
$result[] = $item;
}
}
protected function pullMultipleEvents($start, $end, &$result, $data) {
foreach ($data as $id=>$backgroundColorAndTextColor) {
$userEvents = array();
$colorComponents = explode(',',$backgroundColorAndTextColor);
$this->pullEvents($start, $end, $userEvents ,$id, $colorComponents[0], $colorComponents[1], $colorComponents[2]);
$result[$id] = $userEvents;
}
}
protected function pullTasks($start, $end, &$result, $color = null,$textColor = 'white') {
$user = Users_Record_Model::getCurrentUserModel();
$db = PearDatabase::getInstance();
$moduleModel = Vtiger_Module_Model::getInstance('Calendar');
$userAndGroupIds = array_merge(array($user->getId()),$this->getGroupsIdsForUsers($user->getId()));
$queryGenerator = new QueryGenerator($moduleModel->get('name'), $user);
$queryGenerator->setFields(array('activityid','subject', 'taskstatus','activitytype', 'date_start','time_start','due_date','time_end','id'));
$query = $queryGenerator->getQuery();
$query.= " AND vtiger_activity.activitytype = 'Task' AND ";
$currentUser = Users_Record_Model::getCurrentUserModel();
$hideCompleted = $currentUser->get('hidecompletedevents');
if($hideCompleted)
$query.= "vtiger_activity.status != 'Completed' AND ";
$query.= " ((date_start >= '$start' AND due_date < '$end') OR ( due_date >= '$start'))";
$params = $userAndGroupIds;
$query.= " AND vtiger_crmentity.smownerid IN (".generateQuestionMarks($params).")";
$queryResult = $db->pquery($query,$params);
while($record = $db->fetchByAssoc($queryResult)){
$item = array();
$crmid = $record['activityid'];
$item['title'] = decode_html($record['subject']).' - ('.decode_html(vtranslate($record['status'],'Calendar')).')';
$item['status'] = $record['status'];
$item['activitytype'] = $record['activitytype'];
$item['id'] = $crmid;
$dateTimeFieldInstance = new DateTimeField($record['date_start'].' '.$record['time_start']);
$userDateTimeString = $dateTimeFieldInstance->getDisplayDateTimeValue();
$dateTimeComponents = explode(' ',$userDateTimeString);
$dateComponent = $dateTimeComponents[0];
//Conveting the date format in to Y-m-d.since full calendar expects in the same format
$dataBaseDateFormatedString = DateTimeField::__convertToDBFormat($dateComponent, $user->get('date_format'));
$item['start'] = $dataBaseDateFormatedString.' '. $dateTimeComponents[1];
$item['end'] = $record['due_date'];
$item['url'] = sprintf('index.php?module=Calendar&view=Detail&record=%s', $crmid);
$item['color'] = $color;
$item['textColor'] = $textColor;
$item['module'] = $moduleModel->getName();
$item['allDay'] = true;
$item['fieldName'] = 'date_start,due_date';
$item['conditions'] = '';
$result[] = $item;
}
}
}
}