231 lines
10 KiB
PHP
231 lines
10 KiB
PHP
<?php
|
||
/*********************************************************************************
|
||
* The contents of this file are subject to the SugarCRM Public License Version 1.1.2
|
||
* ("License"); You may not use this file except in compliance with the
|
||
* License. You may obtain a copy of the License at http://www.sugarcrm.com/SPL
|
||
* Software distributed under the License is distributed on an "AS IS" basis,
|
||
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
|
||
* the specific language governing rights and limitations under the License.
|
||
* The Original Code is: SugarCRM Open Source
|
||
* The Initial Developer of the Original Code is SugarCRM, Inc.
|
||
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
|
||
* All Rights Reserved.
|
||
* Contributor(s): ______________________________________.
|
||
********************************************************************************/
|
||
/*********************************************************************************
|
||
* $Header: /advent/projects/wesat/vtiger_crm/sugarcrm/modules/Activities/OpenListView.php,v 1.22 2005/04/19 17:00:30 ray Exp $
|
||
* Description: TODO: To be written.
|
||
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
|
||
* All Rights Reserved.
|
||
* Contributor(s): ______________________________________..
|
||
********************************************************************************/
|
||
|
||
/**
|
||
* Function to get Pending/Upcoming activities
|
||
* @param integer $mode - number to differentiate upcoming and pending activities
|
||
* return array $values - activities record in array format
|
||
*/
|
||
function getPendingActivities($mode,$view=''){
|
||
global $log;
|
||
$log->debug("Entering getPendingActivities() method ...");
|
||
require_once('data/Tracker.php');
|
||
require_once('include/utils/utils.php');
|
||
require_once('user_privileges/default_module_view.php');
|
||
|
||
global $currentModule;
|
||
global $singlepane_view;
|
||
global $theme;
|
||
global $focus;
|
||
global $action;
|
||
global $adb;
|
||
global $app_strings;
|
||
global $current_language;
|
||
global $current_user;
|
||
$current_module_strings = return_module_language($current_language, 'Calendar');
|
||
|
||
$theme_path="themes/".$theme."/";
|
||
$image_path=$theme_path."images/";
|
||
|
||
if($_REQUEST['activity_view']==''){
|
||
$activity_view='today';
|
||
}else{
|
||
$activity_view=vtlib_purify($_REQUEST['activity_view']);
|
||
}
|
||
|
||
$dbStartDateTime = new DateTimeField(date('Y-m-d H:i:s'));
|
||
$userStartDate = $dbStartDateTime->getDisplayDate();
|
||
$userStartDateTime = new DateTimeField($userStartDate.' 00:00:00');
|
||
$startDateTime = $userStartDateTime->getDBInsertDateTimeValue();
|
||
|
||
$userEndDateTime = new DateTimeField($userStartDate.' 23:59:00');
|
||
$endDateTime = $userEndDateTime->getDBInsertDateTimeValue();
|
||
|
||
if($view == 'today'){
|
||
$upcoming_condition = " AND (CAST((CONCAT(date_start,' ',time_start)) AS DATETIME) BETWEEN '$startDateTime' AND '$endDateTime'
|
||
OR CAST((CONCAT(vtiger_recurringevents.recurringdate,' ',time_start)) AS DATETIME) BETWEEN '$startDateTime' AND '$endDateTime')";
|
||
$pending_condition = " AND (CAST((CONCAT(date_start,' ',time_start)) AS DATETIME) BETWEEN '$startDateTime' AND '$endDateTime'
|
||
OR CAST((CONCAT(vtiger_recurringevents.recurringdate,' ',time_start)) AS DATETIME) BETWEEN '$startDateTime' AND '$endDateTime')";
|
||
}else if($view == 'all'){
|
||
$upcoming_condition = " AND (CAST((CONCAT(date_start,' ',time_start)) AS DATETIME) >= '$startDateTime'
|
||
OR CAST((CONCAT(vtiger_recurringevents.recurringdate,' ',time_start)) AS DATETIME) >= '$startDateTime')";
|
||
$pending_condition = " AND (CAST((CONCAT(date_start,' ',time_start)) AS DATETIME) <= '$startDateTime'
|
||
OR CAST((CONCAT(vtiger_recurringevents.recurringdate,' ',time_start)) AS DATETIME) <= '$startDateTime')";
|
||
}
|
||
|
||
if($mode != 1){
|
||
$list_query = " select vtiger_crmentity.crmid,vtiger_crmentity.smownerid,vtiger_crmentity.".
|
||
"setype, vtiger_recurringevents.recurringdate, vtiger_activity.activityid, ".
|
||
"vtiger_activity.activitytype, vtiger_activity.date_start, vtiger_activity.due_date,".
|
||
"from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=".
|
||
"vtiger_activity.activityid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = ".
|
||
"vtiger_crmentity.smownerid left outer join vtiger_recurringevents on ".
|
||
"vtiger_recurringevents.activityid=vtiger_activity.activityid";
|
||
$list_query .= getNonAdminAccessControlQuery('Calendar',$current_user);
|
||
$list_query .= " WHERE vtiger_crmentity.deleted=0 and vtiger_activity.activitytype not in ".
|
||
"('Emails') AND ( vtiger_activity.status is NULL OR vtiger_activity.status not in".
|
||
"('Completed','Deferred')) and ( vtiger_activity.eventstatus is NULL OR vtiger_activity.".
|
||
"eventstatus not in ('Held','Not Held') )".$upcoming_condition;
|
||
|
||
}else{
|
||
$list_query = "select vtiger_crmentity.crmid,vtiger_crmentity.smownerid,vtiger_crmentity".
|
||
"setype, vtiger_recurringevents.recurringdate, vtiger_activity.activityid, vtiger_activity".
|
||
".activitytype, vtiger_activity.date_start, vtiger_activity.due_date, from vtiger_activity".
|
||
"inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid ".
|
||
"LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid ".
|
||
"left outer join vtiger_recurringevents on vtiger_recurringevents.activityid=".
|
||
"vtiger_activity.activityid";
|
||
$list_query .= getNonAdminAccessControlQuery('Calendar',$current_user);
|
||
$list_query .= "WHERE vtiger_crmentity.deleted=0 and (vtiger_activity.".
|
||
"activitytype not in ('Emails')) AND (vtiger_activity.status is NULL OR vtiger_activity.".
|
||
"status not in ('Completed','Deferred')) and (vtiger_activity.eventstatus is NULL OR ".
|
||
"vtiger_activity.eventstatus not in ('Held','Not Held')) ".$pending_condition;
|
||
|
||
$list_query.= " GROUP BY vtiger_activity.activityid";
|
||
$list_query.= " ORDER BY date_start,time_start ASC";
|
||
$res = $adb->query($list_query);
|
||
$noofrecords = $adb->num_rows($res);
|
||
$open_activity_list = array();
|
||
$noofrows = $adb->num_rows($res);
|
||
if (count($res)>0){
|
||
for($i=0;$i<$noofrows;$i++){
|
||
$dateValue = $adb->query_result($res,$i,'date_start') . ' ' .
|
||
$adb->query_result($res,$i,'time_start');
|
||
$endDateValue = $adb->query_result($res,$i,'due_date') . ' ' .
|
||
$adb->query_result($res,$i,'time_end');
|
||
$recurringDateValue = $adb->query_result($res,$i,'due_date') . ' ' .
|
||
$adb->query_result($res,$i,'time_start');
|
||
$date = new DateTimeField($dateValue);
|
||
$endDate = new DateTimeField($endDateValue);
|
||
$recurringDate = new DateTimeField($recurringDateValue);
|
||
|
||
$open_activity_list[] = Array('name' => $adb->query_result($res,$i,'subject'),
|
||
'id' => $adb->query_result($res,$i,'activityid'),
|
||
'type' => $adb->query_result($res,$i,'activitytype'),
|
||
'module' => $adb->query_result($res,$i,'setype'),
|
||
'date_start' => $date->getDisplayDate(),
|
||
'due_date' => $endDate->getDisplayDate(),
|
||
'recurringdate' => $recurringDate->getDisplayDate(),
|
||
'priority' => $adb->query_result($res,$i,'priority'), // Armando L<>scher 04.07.2005 -> <20>priority -> Desc: Get vtiger_priority from db
|
||
);
|
||
}
|
||
}
|
||
|
||
$title=array();
|
||
$title[]=$view;
|
||
$title[]='myUpcoPendAct.gif';
|
||
$title[]='home_myact';
|
||
$title[]='showActivityView';
|
||
$title[]='MyUpcumingFrm';
|
||
$title[]='activity_view';
|
||
|
||
$header=array();
|
||
$header[] =$current_module_strings['LBL_LIST_SUBJECT'];
|
||
$header[] ='Type';
|
||
|
||
$return_url="&return_module=$currentModule&return_action=DetailView&return_id=" . ((is_object($focus)) ? $focus->id : "");
|
||
$oddRow = true;
|
||
$entries=array();
|
||
|
||
foreach($open_activity_list as $event){
|
||
$recur_date=preg_replace('/--/','',$event['recurringdate']);
|
||
if($recur_date!=""){
|
||
$event['date_start']=$event['recurringdate'];
|
||
}
|
||
$font_color_high = "color:#00DD00;";
|
||
$font_color_medium = "color:#DD00DD;";
|
||
|
||
switch ($event['priority']){
|
||
case 'High':
|
||
$font_color=$font_color_high;
|
||
break;
|
||
case 'Medium':
|
||
$font_color=$font_color_medium;
|
||
break;
|
||
default:
|
||
$font_color='';
|
||
}
|
||
|
||
if($event['type'] != 'Task' && $event['type'] != 'Emails' && $event['type'] != ''){
|
||
$activity_type = 'Events';
|
||
}else{
|
||
$activity_type = 'Task';
|
||
}
|
||
}
|
||
$entries[$event['id']] = array(
|
||
'0' => '<a href="index.php?action=DetailView&module='.$event["module"].'&activity_mode='.$activity_type.'&record='.$event["id"].''.$return_url.'" style="'.$font_color.';">'.$event["name"].'</a>',
|
||
'IMAGE' => '<IMG src="'.$image_path.$event["type"].'s.gif">',
|
||
);
|
||
}
|
||
$values=Array('noofactivities'=>$noofrecords,'Title'=>$title,'Header'=>$header,'Entries'=>$entries);
|
||
$log->debug("Exiting getPendingActivities method ...");
|
||
return $values;
|
||
}
|
||
|
||
/**
|
||
* Function creates HTML to display ActivityView selection box
|
||
* @param string $activity_view - activity view
|
||
* return string $ACTIVITY_VIEW_SELECT_OPTION - HTML selection box
|
||
*/
|
||
function getActivityview($activity_view)
|
||
{
|
||
global $log;
|
||
$log->debug("Entering getActivityview(".$activity_view.") method ...");
|
||
$today = DateTimeField::convertToUserFormat(date("Y-m-d"));
|
||
|
||
if($activity_view == 'Today')
|
||
{
|
||
$selected1 = 'selected';
|
||
}
|
||
else if($activity_view == 'This Week')
|
||
{
|
||
$selected2 = 'selected';
|
||
}
|
||
else if($activity_view == 'This Month')
|
||
{
|
||
$selected3 = 'selected';
|
||
}
|
||
else if($activity_view == 'This Year')
|
||
{
|
||
$selected4 = 'selected';
|
||
}
|
||
|
||
//constructing the combo values for activities
|
||
$ACTIVITY_VIEW_SELECT_OPTION = '<select class=small name="activity_view" onchange="showActivityView(this)">';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '<option value="Today" '.$selected1.'>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= 'Today';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '</option>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '<option value="This Week" '.$selected2.'>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= 'This Week';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '</option>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '<option value="This Month" '.$selected3.'>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= 'This Month';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '</option>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '<option value="This Year" '.$selected4.'>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= 'This Year';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '</option>';
|
||
$ACTIVITY_VIEW_SELECT_OPTION .= '</select>';
|
||
|
||
$log->debug("Exiting getActivityview method ...");
|
||
return $ACTIVITY_VIEW_SELECT_OPTION;
|
||
}
|
||
?>
|