|
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');
class Calendar_FetchAgendaEvents_Action extends Vtiger_BasicAjax_Action {
public function process(Vtiger_Request $request) {
$result = array();
$start = $request->get('startDate');
$noOfDays = $request->get('numOfDays');
$dbStartDateOject = DateTimeField::convertToDBTimeZone($start);
$dbStartDateTime = $dbStartDateOject->format('Y-m-d H:i:s');
$dbEndDateTime = $this->addDays($dbStartDateTime, $noOfDays);
$currentUser = Users_Record_Model::getCurrentUserModel();
$db = PearDatabase::getInstance();
$query = 'SELECT vtiger_activity.subject, vtiger_activity.eventstatus, vtiger_activity.priority ,vtiger_activity.visibility,
vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, vtiger_activity.time_end,
vtiger_crmentity.smownerid, vtiger_activity.activityid, vtiger_activity.activitytype, vtiger_activity.recurringtype,
vtiger_activity.location FROM vtiger_activity
INNER JOIN vtiger_crmentity ON vtiger_activity.activityid = vtiger_crmentity.crmid
LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id
LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid
WHERE vtiger_crmentity.deleted=0 AND vtiger_activity.activityid > 0 AND vtiger_activity.activitytype NOT IN ("Emails","Task") AND ';
$hideCompleted = $currentUser->get('hidecompletedevents');
if ($hideCompleted) {
$query.= "vtiger_activity.eventstatus != 'HELD' AND ";
}
$query.= " (concat(date_start,'',time_start)) >= '$dbStartDateTime' AND (concat(date_start,'',time_start)) < '$dbEndDateTime'";
$eventUserId = $currentUser->getId();
$params = array_merge(array($eventUserId), $this->getGroupsIdsForUsers($eventUserId));
$query.= " AND vtiger_crmentity.smownerid IN (".generateQuestionMarks($params).")";
$query.= ' ORDER BY time_start';
$queryResult = $db->pquery($query, $params);
while ($record = $db->fetchByAssoc($queryResult)) {
$item = array();
$item['id'] = $record['activityid'];
$item['visibility'] = $record['visibility'];
/**PVTPATCHER-B18969D07932FC5B8DB0DB85D87DD5A5-START-lng711**/
/** Don't remove the Start and Finish Markup! Modified: 2020-07-14 11:35:04 **/
$item['activitytype'] = vtranslate($record['activitytype'],'Calendar');
/** REPLACED-B18969D07932FC5B8DB0DB85D87DD5A5// $item['activitytype'] = $record['activitytype'];**/
/**PVTPATCHER-B18969D07932FC5B8DB0DB85D87DD5A5-FINISH**/
/**PVTPATCHER-CFBBADB49CD0748E2CD66C675A939095-START-lng711**/
/** Don't remove the Start and Finish Markup! Modified: 2020-07-14 11:35:04 **/
$item['status'] = vtranslate($record['eventstatus'],'Calendar');
/** REPLACED-CFBBADB49CD0748E2CD66C675A939095// $item['status'] = $record['eventstatus'];**/
/**PVTPATCHER-CFBBADB49CD0748E2CD66C675A939095-FINISH**/
/**PVTPATCHER-CCDA56FCCAC3C829D981799818BC833A-START-lng711**/
/** Don't remove the Start and Finish Markup! Modified: 2020-07-14 11:35:04 **/
$item['priority'] = vtranslate($record['priority'],'Calendar');
/** REPLACED-CCDA56FCCAC3C829D981799818BC833A// $item['priority'] = $record['priority'];**/
/**PVTPATCHER-CCDA56FCCAC3C829D981799818BC833A-FINISH**/
$item['userfullname'] = getUserFullName($record['smownerid']);
$item['title'] = decode_html($record['subject']);
$dateTimeFieldInstance = new DateTimeField($record['date_start'].' '.$record['time_start']);
$userDateTimeString = $dateTimeFieldInstance->getDisplayDateTimeValue($currentUser);
$startDateComponents = explode(' ', $userDateTimeString);
$item['start'] = $userDateTimeString;
$item['startDate'] = $startDateComponents[0];
$item['startTime'] = $startDateComponents[1];
$dateTimeFieldInstance = new DateTimeField($record['due_date'].' '.$record['time_end']);
$userDateTimeString = $dateTimeFieldInstance->getDisplayDateTimeValue($currentUser);
$endDateComponents = explode(' ', $userDateTimeString);
$item['end'] = $userDateTimeString;
$item['endDate'] = $endDateComponents[0];
$item['endTime'] = $endDateComponents[1];
if ($currentUser->get('hour_format') == '12') {
$item['startTime'] = Vtiger_Time_UIType::getTimeValueInAMorPM($item['startTime']);
$item['endTime'] = Vtiger_Time_UIType::getTimeValueInAMorPM($item['endTime']);
}
$recurringCheck = false;
if($record['recurringtype'] != '' && $record['recurringtype'] != '--None--') {
$recurringCheck = true;
}
$item['recurringcheck'] = $recurringCheck;
$result[$startDateComponents[0]][] = $item;
}
$response = new Vtiger_Response();
$response->setResult($result);
$response->emit();
}
public function addDays($datetime, $daysToAdd) {
$datetime = strtotime($datetime);
$secondsDelta = 24 * 60 * 60 * $daysToAdd;
$futureDate = $datetime + $secondsDelta;
return date("Y-m-d H:i:s", $futureDate);
}
protected function getGroupsIdsForUsers($userId) {
vimport('~~/include/utils/GetUserGroups.php');
$userGroupInstance = new GetUserGroups();
$userGroupInstance->getAllUserGroups($userId);
return $userGroupInstance->user_groups;
}
}