'.$mod_strings["LBL_REGARDS_STRING"].' ,';
$list .= ' '.$current_username.'.';
$log->debug("Exiting getActivityDetails method ...");
return $list;
}
function twoDigit( $no ){
if($no < 10 && strlen(trim($no)) < 2) return "0".$no;
else return "".$no;
}
function timeString($datetime,$fmt){
$timeStr = formatUserTimeString($datetime, $fmt);
$date = new DateTimeField($timeStr);
list($h, $m) = explode(':', $date->getDisplayTime());
$timeStr = formatUserTimeString(array('hour'=>$h, 'minute'=>$m), $fmt);
return $timeStr;
}
/**
*
* @param type $datetime
* @param type $fmt
* @return Date
*/
function formatUserTimeString($datetime,$fmt){
if(is_object($datetime)){
$hr = $datetime->hour;
$min = $datetime->minute;
} else {
$hr = $datetime['hour'];
$min = $datetime['minute'];
}
$timeStr = "";
if($fmt != 'am/pm'){
$timeStr .= twoDigit($hr).":".twoDigit($min);
}else{
$am_pm = array('AM', 'PM');
$hour = twoDigit($hr%12);
if($hour == 0) {
$hour = 12;
}
$timeStr = $hour.':'.twoDigit($min).$am_pm[($hr/12)%2];
}
return $timeStr;
}
function sendInvitation($inviteesid,$mode,$subject,$desc)
{
global $current_user,$mod_strings;
require_once("modules/Emails/mail.php");
$invites=$mod_strings['INVITATION'];
$invitees_array = explode(';',$inviteesid);
$subject = $invites.' : '.$subject;
$record = $focus->id;
foreach($invitees_array as $inviteeid)
{
if($inviteeid != '')
{
$description=getActivityDetails($desc,$inviteeid,"invite");
$to_email = getUserEmailId('id',$inviteeid);
send_mail('Calendar',$to_email,$current_user->user_name,'',$subject,$description);
}
}
}
function getActivityMailInfo($return_id,$status,$activity_type)
{
$mail_data = Array();
global $adb;
$qry = "select * from vtiger_activity where activityid=?";
$ary_res = $adb->pquery($qry, array($return_id));
$send_notification = $adb->query_result($ary_res,0,"sendnotification");
$subject = $adb->query_result($ary_res,0,"subject");
$priority = $adb->query_result($ary_res,0,"priority");
$st_date = $adb->query_result($ary_res,0,"date_start");
$st_time = $adb->query_result($ary_res,0,"time_start");
$end_date = $adb->query_result($ary_res,0,"due_date");
$end_time = $adb->query_result($ary_res,0,"time_end");
$location = $adb->query_result($ary_res,0,"location");
if(!empty($st_time)){
$date = new DateTimeField($st_date.' '.$st_time);
$st_date = $date->getDisplayDate();
$st_time = $date->getDisplayTime();
}
if(!empty($end_time)){
$date = new DateTimeField($end_date.' '.$end_time);
$end_date = $date->getDisplayDate();
$end_time = $date->getDisplayTime();
}
$owner_qry = "select smownerid from vtiger_crmentity where crmid=?";
$res = $adb->pquery($owner_qry, array($return_id));
$owner_id = $adb->query_result($res,0,"smownerid");
$usr_res = $adb->pquery("select count(*) as count from vtiger_users where id=?",array($owner_id));
if($adb->query_result($usr_res, 0, 'count')>0) {
$assignType = "U";
$usr_id = $owner_id;
}
else {
$assignType = "T";
$group_qry = "select groupname from vtiger_groups where groupid=?";
$grp_res = $adb->pquery($group_qry, array($owner_id));
$grp_name = $adb->query_result($grp_res,0,"groupname");
}
$desc_qry = "select description from vtiger_crmentity where crmid=?";
$des_res = $adb->pquery($desc_qry, array($return_id));
$description = $adb->query_result($des_res,0,"description");
$rel_qry = "select case vtiger_crmentity.setype when 'Leads' then vtiger_leaddetails.lastname when 'Accounts' then vtiger_account.accountname when 'Potentials' then vtiger_potential.potentialname when 'Quotes' then vtiger_quotes.subject when 'PurchaseOrder' then vtiger_purchaseorder.subject when 'SalesOrder' then vtiger_salesorder.subject when 'Invoice' then vtiger_invoice.subject when 'Campaigns' then vtiger_campaign.campaignname when 'HelpDesk' then vtiger_troubletickets.title end as relname from vtiger_seactivityrel inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_seactivityrel.crmid left join vtiger_leaddetails on vtiger_leaddetails.leadid = vtiger_seactivityrel.crmid left join vtiger_account on vtiger_account.accountid=vtiger_seactivityrel.crmid left join vtiger_potential on vtiger_potential.potentialid=vtiger_seactivityrel.crmid left join vtiger_quotes on vtiger_quotes.quoteid= vtiger_seactivityrel.crmid left join vtiger_purchaseorder on vtiger_purchaseorder.purchaseorderid = vtiger_seactivityrel.crmid left join vtiger_salesorder on vtiger_salesorder.salesorderid = vtiger_seactivityrel.crmid left join vtiger_invoice on vtiger_invoice.invoiceid = vtiger_seactivityrel.crmid left join vtiger_campaign on vtiger_campaign.campaignid = vtiger_seactivityrel.crmid left join vtiger_troubletickets on vtiger_troubletickets.ticketid = vtiger_seactivityrel.crmid where vtiger_seactivityrel.activityid=?";
$rel_res = $adb->pquery($rel_qry, array($return_id));
$rel_name = $adb->query_result($rel_res,0,"relname");
$relatedContacts = getActivityRelatedContacts($return_id);
$mail_data['mode'] = "edit";
$mail_data['activity_mode'] = $activity_type;
$mail_data['sendnotification'] = $send_notification;
$mail_data['user_id'] = $usr_id;
$mail_data['subject'] = $subject;
$mail_data['status'] = $status;
$mail_data['taskpriority'] = $priority;
$mail_data['relatedto'] = $rel_name;
$mail_data['contact_name'] = implode(',', $relatedContacts);
$mail_data['description'] = $description;
$mail_data['assign_type'] = $assignType;
$mail_data['group_name'] = $grp_name;
$value = getaddEventPopupTime($st_time,$end_time,'24');
$start_hour = $value['starthour'].':'.$value['startmin'].''.$value['startfmt'];
if($activity_type != 'Task' )
$end_hour = $value['endhour'] .':'.$value['endmin'].''.$value['endfmt'];
$date = new DateTimeField($st_date." ".$start_hour);
$endDate = new DateTimeField($end_date." ".$end_hour);
$mail_data['st_date_time'] = $date->getDBInsertDateTimeValue();
$mail_data['end_date_time'] = $endDate->getDBInsertDateValue().' '.
$endDate->getDBInsertTimeValue();
$mail_data['location']=$location;
return $mail_data;
}
// User Select Customization
/**
* Function returns the id of the User selected by current user in the picklist of the ListView or Calendar view of Current User
* return String - Id of the user that the current user has selected
*/
function calendarview_getSelectedUserId() {
global $current_user, $default_charset;
$only_for_user = htmlspecialchars(strip_tags($_REQUEST['onlyforuser']),ENT_QUOTES,$default_charset);
if($only_for_user == '') $only_for_user = $current_user->id;
return $only_for_user;
}
function calendarview_getSelectedUserFilterQuerySuffix() {
global $current_user, $adb;
$only_for_user = calendarview_getSelectedUserId();
$qcondition = '';
if(!empty($only_for_user)) {
if($only_for_user != 'ALL') {
// For logged in user include the group records also.
if($only_for_user == $current_user->id) {
$user_group_ids = fetchUserGroupids($current_user->id);
// User does not belong to any group? Let us reset to non-existent group
if(!empty($user_group_ids)) $user_group_ids .= ',';
else $user_group_ids = '';
$user_group_ids .= $current_user->id;
$qcondition = " AND vtiger_crmentity.smownerid IN (" . $user_group_ids .")";
} else {
$qcondition = " AND vtiger_crmentity.smownerid = " . $adb->sql_escape_string($only_for_user);
}
}
}
return $qcondition;
}
/**
* Function returns the data of the user selected by current user in the picklist of the ListView or Calendar view of Current User
* @param $useridInUse - The Id of the user that the Current User has selected in dropdown picklist in Calendar modules listview or Calendar View
* return string - The array of the events for the user that the current user has selected
*/
function calendarview_getUserSelectOptions($useridInUse) {
global $adb, $app_strings, $current_user, $mod_strings;
$users = $adb->query("SELECT id,user_name FROM vtiger_users WHERE status = 'Active' and deleted = 0");
$userscount = $adb->num_rows($users);
$userSelectdata = "" . $app_strings['LBL_LIST_OF'] . " : ";
$userSelectdata .="";
return $userSelectdata;
}
// END
?>