|
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/www/crm/modules/Calendar/ |
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.
*
********************************************************************************/
require_once('include/RelatedListView.php');
require_once('modules/Contacts/Contacts.php');
require_once('modules/Products/Products.php');
require_once('include/utils/UserInfoUtil.php');
// functions added for group calendar -Jaguar
/**
* Function to get duration
* @param string $time_start - activity start time
* @param string $duration_hours - duration in hours
* @param string $duration_minutes - duration in minutes
* return string $end_time - time string
*/
function get_duration($time_start,$duration_hours,$duration_minutes)
{
global $log;
$log->debug("Entering get_duration(".$time_start.",".$duration_hours.",".$duration_minutes.") method ...");
$time=explode(":",$time_start);
$time_mins = $time[1];
$time_hrs = $time[0];
$mins = ($time_mins + $duration_minutes) % 60;
$hrs_min = floor(($time_mins + $duration_minutes) / 60);
if(!isset($hrs))
$hrs=0;
$hrs = $duration_hours + $hrs_min + $time_hrs;
if($hrs<10)
$hrs=$hrs;
if($mins<10)
$mins="0".$mins;
$end_time = $hrs .$mins;
$log->debug("Exiting get_duration method ...");
return $end_time;
}
/**
* Function to convert time to number
* @param string $time_start - activity start time
* return integer $start_time - time
*/
function time_to_number($time_start)
{
global $log;
$log->debug("Entering time_to_number(".$time_start.") method ...");
$start_time_array = explode(":",$time_start);
if(preg_match("/^[0]/",$start_time_array[0]))
{
$time_start_hrs=str_replace('0',"",$start_time_array[0]);
}
else
{
$time_start_hrs=$start_time_array[0];
}
$start_time= $time_start_hrs .$start_time_array[1];
$log->debug("Exiting time_to_number method ...");
return $start_time;
}
/**
* Function to status availability of user
* @param string $owner - ownername
* @param integer $userid - userid
* @param integer $activity_id - activityid
* @param string $avail_date - date in string format
* @param string $activity_start_time - time string
* @param string $activity_end_time - time string
* return string $availability - html img tag in string
*/
function status_availability($owner,$userid,$activity_id,$avail_date,$activity_start_time,$activity_end_time)
{
global $adb,$image_path,$log,$theme;
$log->debug("Entering status_availability(".$owner,$userid.",".$activity_id.",".$avail_date.",".$activity_start_time.",".$activity_end_time.") method ...");
$avail_flag="false";
$avail_date=DateTimeField::convertToDBFormat($avail_date);
if( $owner != $userid)
{
$usr_query="select activityid,vtiger_activity.date_start,vtiger_activity.due_date, vtiger_activity.time_start,vtiger_activity.duration_hours,vtiger_activity.duration_minutes,vtiger_crmentity.smownerid from vtiger_activity,vtiger_crmentity where vtiger_crmentity.crmid=vtiger_activity.activityid and ('".$avail_date."' like date_start) and vtiger_crmentity.smownerid=? and vtiger_activity.activityid !=? and vtiger_crmentity.deleted=0";
}
else
{
$usr_query="select activityid,vtiger_activity.date_start,vtiger_activity.due_date, vtiger_activity.time_start,vtiger_activity.duration_hours,vtiger_activity.duration_minutes,vtiger_crmentity.smownerid from vtiger_activity,vtiger_crmentity where vtiger_crmentity.crmid=vtiger_activity.activityid and ('".$avail_date."' like date_start) and vtiger_crmentity.smownerid=? and vtiger_activity.activityid !=? and vtiger_crmentity.deleted=0";
}
$result_cal=$adb->pquery($usr_query, array($userid, $activity_id));
$noofrows_cal = $adb->num_rows($result_cal);
$avail_flag="false";
if($noofrows_cal!=0)
{
while($row_cal = $adb->fetch_array($result_cal))
{
$usr_date_start=$row_cal['date_start'];
$usr_due_date=$row_cal['due_date'];
$usr_time_start=$row_cal['time_start'];
$usr_hour_dur=$row_cal['duration_hours'];
$usr_mins_dur=$row_cal['duration_minutes'];
$user_start_time=time_to_number($usr_time_start);
$user_end_time=get_duration($usr_time_start,$usr_hour_dur,$usr_mins_dur);
if( ( ($user_start_time > $activity_start_time) && ( $user_start_time < $activity_end_time) ) || ( ( $user_end_time > $activity_start_time) && ( $user_end_time < $activity_end_time) ) || ( ( $activity_start_time == $user_start_time ) || ($activity_end_time == $user_end_time) ) )
{
$availability= 'busy';
$avail_flag="true";
$log->info("user start time-- ".$user_start_time."user end time".$user_end_time);
$log->info("Availability ".$availability);
}
}
}
if($avail_flag!="true")
{
$recur_query="SELECT vtiger_activity.activityid, vtiger_activity.time_start, vtiger_activity.duration_hours, vtiger_activity.duration_minutes , vtiger_crmentity.smownerid, vtiger_recurringevents.recurringid, vtiger_recurringevents.recurringdate as date_start from vtiger_activity inner join vtiger_crmentity on vtiger_activity.activityid = vtiger_crmentity.crmid inner join vtiger_recurringevents on vtiger_activity.activityid=vtiger_recurringevents.activityid where ('".$avail_date."' like vtiger_recurringevents.recurringdate) and vtiger_crmentity.smownerid=? and vtiger_activity.activityid !=? and vtiger_crmentity.deleted=0";
$result_cal=$adb->pquery($recur_query, array($userid, $activity_id));
$noofrows_cal = $adb->num_rows($result_cal);
$avail_flag="false";
if($noofrows_cal!=0)
{
while($row_cal = $adb->fetch_array($result_cal))
{
$usr_date_start=$row_cal['date_start'];
$usr_time_start=$row_cal['time_start'];
$usr_hour_dur=$row_cal['duration_hours'];
$usr_mins_dur=$row_cal['duration_minutes'];
$user_start_time=time_to_number($usr_time_start);
$user_end_time=get_duration($usr_time_start,$usr_hour_dur,$usr_mins_dur);
if( ( ($user_start_time > $activity_start_time) && ( $user_start_time < $activity_end_time) ) || ( ( $user_end_time > $activity_start_time) && ( $user_end_time < $activity_end_time) ) || ( ( $activity_start_time == $user_start_time ) || ($activity_end_time == $user_end_time) ) )
{
$availability= 'busy';
$avail_flag="true";
$log->info("Recurring Events:: user start time-- ".$user_start_time."user end time".$user_end_time);
$log->info("Recurring Events:: Availability ".$availability);
}
}
}
}
if($avail_flag == "true")
{
$availability=' <IMG SRC="' . vtiger_imageurl('busy.gif', $theme). '">';
}
else
{
$availability=' <IMG SRC="' . vtiger_imageurl('free.gif', $theme). '">';
}
$log->debug("Exiting status_availability method ...");
return $availability;
}
?>