PageRenderTime 31ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 1ms

/modules/Calendar/calendarLayout.php

https://bitbucket.org/thomashii/vtigercrm-5.4-for-postgresql
PHP | 2203 lines | 1839 code | 139 blank | 225 comment | 395 complexity | 268aeff444a6aa0109477f46291c5705 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0 
    

  1. <?php
    2. 

  2. /*+********************************************************************************
    3. 

  3.  * The contents of this file are subject to the vtiger CRM Public License Version 1.0
    4. 

  4.  * ("License"); You may not use this file except in compliance with the License
    5. 

  5.  * The Original Code is:  vtiger CRM Open Source
    6. 

  6.  * The Initial Developer of the Original Code is vtiger.
    7. 

  7.  * Portions created by vtiger are Copyright (C) vtiger.
    8. 

  8.  * All Rights Reserved.
    9. 

  9.  ********************************************************************************/
    10. 

  10. 

  11. require_once('include/database/PearDatabase.php');
    12. 

  12. require_once('include/utils/CommonUtils.php');
    13. 

  13. require_once('include/utils/UserInfoUtil.php');
    14. 

  14. require_once('modules/Calendar/CalendarCommon.php');
    15. 

  15. 

  16. 

  17. /**
    18. 

  18.  *  Function creates HTML to display Events and  Todos div tags
    19. 

  19.  *  @param array    $param_arr      - collection of objects and strings
    20. 

  20.  *  @param string   $viewBox        - string 'listview' or 'hourview' or may be empty. if 'listview' means get Events ListView.if 'hourview' means gets Events HourView. if empty means get Todos ListView
    21. 

  21.  *  @param string   $subtab         - string 'todo' or 'event'. if 'todo' means Todos View else Events View
    22. 

  22.  */
    23. 

  23. function calendar_layout(& $param_arr,$viewBox='',$subtab='')
    24. 

  24. {
    25. 

  25. 	global $mod_strings,$cal_log;
    26. 

  26. 	$category = getParentTab();
    27. 

  27. 	$cal_log->debug("Entering calendar_layout() method");
    28. 

  28. 	$cal_header = array ();
    29. 

  29. 	if (isset($param_arr['size']) && $param_arr['size'] == 'small')
    30. 

  30. 		$param_arr['calendar']->show_events = false;
    31. 

  31. 

  32. 	$cal_header['view'] = $param_arr['view'];
    33. 

  33. 	$cal_header['IMAGE_PATH'] = $param_arr['IMAGE_PATH'];
    34. 

  34.         $cal_header['calendar'] = $param_arr['calendar'];
    35. 

  35. 	$eventlabel = $mod_strings['LBL_EVENTS'];
    36. 

  36. 	$todolabel = $mod_strings['LBL_TODOS'];
    37. 

  37. 	//if $param_arr['size'] is set to 'small', get small(mini) calendar
    38. 

  38. 	if(isset($param_arr['size']) && $param_arr['size'] == 'small')
    39. 

  39. 	{
    40. 

  40. 		get_mini_calendar($param_arr);
    41. 

  41. 	}
    42. 

  42. 	else
    43. 

  43. 	{
    44. 

  44. 		// User Select Customization
    45. 

  45. 		$onlyForUserParam = "onlyforuser=" . calendarview_getSelectedUserId();
    46. 

  46. 		// END
    47. 

  47. 

  48. 		//To differentiate selected subtab from unselected one - Starts
    49. 

  49. 		if($subtab == 'event')
    50. 

  50. 		{
    51. 

  51. 			$eventtab_class = 'dvtSelectedCell';
    52. 

  52. 			$todotab_class = 'dvtUnSelectedCell';
    53. 

  53. 		        $event_anchor = $eventlabel;
    54. 

  54. 		//	Added for User Based CustomView for Calendar module
    55. 

  55. 			$todo_anchor = "<a href='index.php?module=Calendar&action=index&view=".$cal_header['view']."".$cal_header['calendar']->date_time->get_date_str()."&viewOption=".$viewBox."&subtab=todo&parenttab=".$category."&$onlyForUserParam'>".$todolabel."</a>";
    56. 

  56. 					
    57. 

  57. 		}
    58. 

  58. 		elseif($subtab == 'todo')
    59. 

  59. 		{
    60. 

  60. 			$eventtab_class = 'dvtUnSelectedCell';
    61. 

  61. 			$todotab_class = 'dvtSelectedCell';
    62. 

  62. 		//	Added User Based CustomView for Calendar module
    63. 

  63. 			$event_anchor = "<a href='index.php?module=Calendar&action=index&view=".$cal_header['view']."".$cal_header['calendar']->date_time->get_date_str()."&viewOption=".$viewBox."&subtab=event&parenttab=".$category."&$onlyForUserParam'>".$eventlabel."</a>";
    64. 

  64. 			$todo_anchor = $todolabel;
    65. 

  65. 		}
    66. 

  66. 		//Ends
    67. 

  67. 		//To get calendar header and its links(like Day,Week,Month,Year and etc.)
    68. 

  68. 		get_cal_header_tab($cal_header,$viewBox,$subtab);
    69. 

  69. 		$subheader = "";
    70. 

  70. 		$subheader .=<<<EOQ
    71. 

  71. 			<tr>
    72. 

  72. 				<td colspan="8" class="calBorder">
    73. 

  73. 					<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%">
    74. 

  74. 						<tr>
    75. 

  75. 							<td>
    76. 

  76. 							
    77. 

  77. 								<table class="small" border="0" cellpadding="3" cellspacing="0" width="100%">
    78. 

  78. 									<tr>
    79. 

  79. 										<td class="dvtTabCache" style="width: 10px;" nowrap="nowrap">&nbsp;</td>
    80. 

  80. 										<td class="$eventtab_class" id="pi" align="center" nowrap="nowrap" width="75">$event_anchor</td>
    81. 

  81. 										<td class="dvtTabCache" style="width: 10px;" nowrap="nowrap">&nbsp;</td>
    82. 

  82. 										<td class="$todotab_class" style="width:100px;" id="mi" align="center" nowrap="nowrap">$todo_anchor</td>
    83. 

  83. 										<td class="dvtTabCache" nowrap="nowrap">&nbsp;</td>
    84. 

  84. 									</tr>
    85. 

  85. 								</table>
    86. 

  86. 							</td>
    87. 

  87. 						</tr>
    88. 

  88. 						<tr>
    89. 

  89. 							<td class="calInnerBorder" align="left" bgcolor="#ffffff" valign="top">
    90. 

  90. EOQ;
    91. 

  91. 		echo $subheader;
    92. 

  92. 		if($viewBox == 'hourview' && $subtab == 'event')
    93. 

  93. 		{
    94. 

  94. 			get_cal_header_data($param_arr,$viewBox,$subtab);
    95. 

  95. 			getHourView($param_arr);
    96. 

  96. 		}
    97. 

  97. 		elseif($viewBox == 'listview' && $subtab == 'event')
    98. 

  98. 		{
    99. 

  99. 			get_cal_header_data($param_arr,$viewBox,$subtab);
    100. 

  100. 			getEventListView($param_arr);
    101. 

  101. 		}
    102. 

  102. 		elseif($subtab == 'todo')
    103. 

  103. 		{
    104. 

  104. 			$todo_list = "";
    105. 

  105. 			$todo_list .= getTodosListView($param_arr,'',$subtab);
    106. 

  106. 			$todo_list .= '</td></tr></table></td></tr></table><br>';
    107. 

  107. 			echo $todo_list;
    108. 

  108. 		}
    109. 

  109. 	}
    110. 

  110. 	
    111. 

  111. 	$cal_log->debug("Exiting calendar_layout() method");	
    112. 

  112. 	
    113. 

  113. }
    114. 

  114. 

  115. /**
    116. 

  116.  * Function creates HTML to display small(mini) Calendar 
    117. 

  117.  * @param array   $cal    - collection of objects and strings
    118. 

  118.  */
    119. 

  119. function get_mini_calendar(& $cal){
    120. 

  120. 	global $current_user,$adb,$cal_log,$mod_strings,$theme;
    121. 

  121. 	$category = getParentTab();
    122. 

  122. 	$cal_log->debug('Entering get_mini_calendar() method...');
    123. 

  123. 	$count = 0;
    124. 

  124. 	//To decide number of rows(weeks) in a month
    125. 

  125. 	if ($cal['calendar']->month_array[$cal['calendar']->slices[35]]->start_time->month != $cal['calendar']->date_time->month) {
    126. 

  126. 		$rows = 5;
    127. 

  127. 	} else {
    128. 

  128. 		$rows = 6;
    129. 

  129. 	}
    130. 

  130. 	$minical = "";
    131. 

  131. 	$minical .= "<table class='mailClient ' bgcolor='white' border='0' cellpadding='2' cellspacing='0' width='98%'>
    132. 

  132. 				<tr>
    133. 

  133. 					<td class='calHdr'>&nbsp;</td>
    134. 

  134. 					<td style='padding:5px' colspan='6' class='calHdr' align='center'>".get_previous_cal($cal)."&nbsp;";
    135. 

  135. 					$minical .= "<a style='text-decoration: none;' href='index.php?module=Calendar&action=index&view=".$cal['view']."".$cal['calendar']->date_time->get_date_str()."&parenttab=".$category."'><b>".display_date($cal['view'],$cal['calendar']->date_time)."</b></a>&nbsp;".get_next_cal($cal)."</td>";
    136. 

  136. 					$minical .= "<td class='calHdr' align='right'><a href='javascript:ghide(\"miniCal\");'><img src='". vtiger_imageurl('close.gif', $theme). "' align='right' border='0'></a>
    137. 

  137. 				</td></tr>";
    138. 

  138. 	$minical .= "<tr class='hdrNameBg'>";
    139. 

  139. 	//To display days in week 
    140. 

  140. 	$minical .= '<th width="12%">'.$mod_strings['LBL_WEEK'].'</th>';
    141. 

  141. 	for ($i = 0; $i < 7; $i ++){
    142. 

  142. 		$weekday = $mod_strings['cal_weekdays_short'][$i];
    143. 

  143. 		$minical .= '<th width="12%">'.$weekday.'</th>';
    144. 

  144. 	}
    145. 

  145. 	$minical .= "</tr>";	
    146. 

  146. 	$event_class = '';
    147. 

  147. 	$class = '';
    148. 

  148. 	for ($i = 0; $i < $rows; $i++){
    149. 

  149. 		$minical .= "<tr>";
    150. 

  150. 

  151. 		//calculate blank days for first week
    152. 

  152. 		for ($j = 0; $j < 7; $j ++){
    153. 

  153. 			$cal['slice'] = $cal['calendar']->month_array[$cal['calendar']->slices[$count]];
    154. 

  154. 			$class = dateCheck($cal['slice']->start_time->get_formatted_date());
    155. 

  155. 			if($j == 0){
    156. 

  156. 				$minical .= "<td style='text-align:center' ><a href='index.php?module=Calendar&action=index&view=week".$cal['slice']->start_time->get_date_str()."&parenttab=".$category."'>".$cal['slice']->start_time->week."</td>";
    157. 

  157. 			}
    158. 

  158. 			
    159. 

  159. 			//To differentiate day having events from other days
    160. 

  160. 			if(count($cal['slice']->activities) != 0 && ($cal['slice']->start_time->get_formatted_date() == $cal['slice']->activities[0]->start_time->get_formatted_date())){
    161. 

  161. 				$event_class = 'class="eventDay"';
    162. 

  162. 			}else{
    163. 

  163. 				$event_class = '';
    164. 

  164. 			}
    165. 

  165. 			//To differentiate current day from other days
    166. 

  166. 			if($class != '' ){
    167. 

  167. 				$class = 'class="'.$class.'"';
    168. 

  168. 			}else{
    169. 

  169. 				$class = $event_class;
    170. 

  170. 			}
    171. 

  171. 			
    172. 

  172. 			//To display month dates
    173. 

  173. 			if ($cal['slice']->start_time->getMonth() == $cal['calendar']->date_time->getMonth()){
    174. 

  174. 				$minical .= "<td ".$class." style='text-align:center' >";
    175. 

  175. 				$minical .= "<a href='index.php?module=Calendar&action=index&view=".$cal['slice']->getView()."".$cal['slice']->start_time->get_date_str()."&parenttab=".$category."'>";
    176. 

  176. 				$minical .= $cal['slice']->start_time->get_Date()."</a></td>";
    177. 

  177. 			}else{
    178. 

  178. 				$minical .= "<td style='text-align:center' ></td>";
    179. 

  179. 			}
    180. 

  180. 			$count++;
    181. 

  181. 		}
    182. 

  182. 		$minical .= '</tr>';
    183. 

  183. 	}
    184. 

  184. 	$minical .= "</table>";
    185. 

  185. 	echo $minical;
    186. 

  186. 	$cal_log->debug("Exiting get_mini_calendar() method...");
    187. 

  187. }
    188. 

  188. 

  189. /**
    190. 

  190.  * Function creates HTML to display Calendar Header and its Links
    191. 

  191.  * @param array    $header   - collection of objects and strings
    192. 

  192.  * @param string   $viewBox  - string 'listview' or 'hourview' or may be empty. if 'listview' means Events ListView.if 'hourview' means Events HourView. if empty means get Todos ListView
    193. 

  193.  * @param string   $subtab   - string 'todo' or 'event'. if 'todo' means Todos View else Events View
    194. 

  194.  */
    195. 

  195. function get_cal_header_tab(& $header,$viewBox,$subtab)
    196. 

  196. {
    197. 

  197. 	global $mod_strings,$cal_log;
    198. 

  198. 	$category = getParentTab();
    199. 

  199. 	$cal_log->debug("Entering get_cal_header_tab() method...");
    200. 

  200. 	$tabhtml = "";
    201. 

  201. 	$count = 1;
    202. 

  202. 	include_once 'modules/Calendar/addEventUI.php';
    203. 

  203. 	include_once 'modules/Calendar/header.php';
    204. 

  204. 	$eventlabel = $mod_strings['LBL_EVENTS'];
    205. 

  205. 	$todolabel = $mod_strings['LBL_TODOS'];
    206. 

  206. 	$div = "<div id='miniCal' style='width:300px; position:absolute; display:none; left:100px; top:100px; z-index:100000; background-color:white'></div>
    207. 

  207. 		<div id='calSettings' class='layerPopup calSettings' style='display:none;width:500px;' align=center ></div>
    208. 

  208. 		<div id='dataArray'></div>
    209. 

  209. 		";
    210. 

  210. 	echo $div;
    211. 

  211. 	$tabhtml .= "<table class='small calHdr' align='center' border='0' cellpadding='5' cellspacing='0' width='100%'><tr>";
    212. 

  212.         $links = array ('day','week','month','year');
    213. 

  213. 	//To differentiate the selected link from unselected links
    214. 

  214. 	foreach ($links as $link)
    215. 

  215. 	{
    216. 

  216. 		if ($header['view'] == $link)
    217. 

  217. 		{
    218. 

  218. 			$class = 'calSel';
    219. 

  219. 			$anchor = $mod_strings["LBL_".$header['calendar']->getCalendarView($link)];
    220. 

  220. 		}
    221. 

  221. 		else
    222. 

  222. 		{
    223. 

  223. 			$class = 'calUnSel';
    224. 

  224. 			$anchor = "<a href='index.php?module=Calendar&action=index&view=".$link."".$header['calendar']->date_time->get_date_str()."&viewOption=".$viewBox."&subtab=".$subtab."&parenttab=".$category."'>".$mod_strings["LBL_".$header['calendar']->getCalendarView($link)]."</a>";
    225. 

  225. 		}
    226. 

  226. 	
    227. 

  227. 		if($count == 1)
    228. 

  228. 			$tabhtml .= "<!-- day week month buttons --> <td style='border-left: 1px solid #666666;' class=".$class.">".$anchor."</td>";
    229. 

  229. 		else
    230. 

  230. 			$tabhtml .= "<td class=".$class.">".$anchor."</td>";
    231. 

  231. 		$count++;
    232. 

  232. 	}
    233. 

  233. 	//To get Navigation(next&previous) links and display Date info
    234. 

  234. 	$tabhtml .= "<td width='30%'>
    235. 

  235. 			<table border='0' cellpadding='0' cellspacing='0'>
    236. 

  236. 			<tr>
    237. 

  237. 				<td>".get_previous_cal($header,$viewBox,$subtab)."
    238. 

  238. 				</td>";
    239. 

  239. 	$tabhtml .= "<td class='calendarNav'>".display_date($header['view'],$header['calendar']->date_time)."</td>";
    240. 

  240. 	$tabhtml .= "<td>".get_next_cal($header,$viewBox,$subtab)."
    241. 

  241. 		     </td></tr>
    242. 

  242. 		    </table>
    243. 

  243. 		</td>";
    244. 

  244. 		$tabhtml .= "<td width='2%'><img onClick='fnvshobj(this,\"miniCal\"); getMiniCal(\"view=".$header['calendar']->view."".$header['calendar']->date_time->get_date_str()."&viewOption=".$viewBox."&subtab=".$subtab."&parenttab=".$category."\");' src='".$header['IMAGE_PATH']."btnL3Calendar.gif' alt='".$mod_strings['LBL_OPENCAL']."...' title='".$mod_strings['LBL_OPENCAL']."...' align='absmiddle' border='0'></td>";
    245. 

  245. 		$tabhtml .= "<td width=20% ><img onClick='fnvshobj(this,\"calSettings\"); getCalSettings(\"view=".$header['calendar']->view."".$header['calendar']->date_time->get_date_str()."&viewOption=".$viewBox."&subtab=".$subtab."&parenttab=".$category."\");' src='".$header['IMAGE_PATH']."tbarSettings.gif' alt='".$mod_strings['LBL_SETTINGS']."' title='".$mod_strings['LBL_SETTINGS']."' align='absmiddle' border='0'></td>";
    246. 

  246. 	$tabhtml .= "<td class='calHdr calTopRight componentName'>".$app_strings['Calendar']."</td>";	
    247. 

  247. 	$tabhtml .= "</tr>";
    248. 

  248. 	echo $tabhtml;
    249. 

  249. 	$cal_log->debug("Exiting get_cal_header_tab() method...");
    250. 

  250. }
    251. 

  251. 

  252. /**
    253. 

  253.  * Function creates HTML to display number of Events, Todos and pending list in calendar under header(Eg:Total Events : 5, 2 Pending / Total To Dos: 4, 1 Pending)
    254. 

  254.  * @param array  $cal_arr   - collection of objects and strings
    255. 

  255.  * @param string $viewBox   - string 'listview' or 'hourview'. if 'listview' means Events ListView.if 'hourview' means Events HourView.
    256. 

  256.  */
    257. 

  257. function get_cal_header_data(& $cal_arr,$viewBox,$subtab)
    258. 

  258. {
    259. 

  259. 	global $mod_strings,$cal_log,$current_user,$adb,$theme;
    260. 

  260. 	$cal_log->debug("Entering get_cal_header_data() method...");
    261. 

  261. 	global $current_user,$app_strings;
    262. 

  262.         $date_format = $current_user->date_format;
    263. 

  263. 	$format = $cal_arr['calendar']->hour_format;
    264. 

  264. 	$hour_startat = timeString(array('hour' => date('H:i', (time() + (5 * 60))), 'minute' => 0), '24');
    265. 

  265. 	$hour_endat = timeString(array('hour'=>date('H:i',(time() + (60 * 60))),'minute'=>0),'24');
    266. 

  266. 	$time_arr = getaddEventPopupTime($hour_startat,$hour_endat,$format);
    267. 

  267. 	$date = new DateTimeField(null);
    268. 

  268. 	
    269. 

  269. 	//To get date in user selected format
    270. 

  270. 	$temp_date = $date->getDisplayDate();
    271. 

  271. 	
    272. 

  272. 	if($current_user->column_fields['is_admin']=='on')
    273. 

  273. 		$Res = $adb->pquery("select * from vtiger_activitytype",array());
    274. 

  274. 	else
    275. 

  275. 	{
    276. 

  276. 		$roleid=$current_user->roleid;
    277. 

  277. 		$subrole = getRoleSubordinates($roleid);
    278. 

  278. 		if(count($subrole)> 0)
    279. 

  279. 		{
    280. 

  280. 			$roleids = $subrole;
    281. 

  281. 			array_push($roleids, $roleid);
    282. 

  282. 		}
    283. 

  283. 		else
    284. 

  284. 		{	
    285. 

  285. 			$roleids = $roleid;
    286. 

  286. 		}
    287. 

  287. 

  288. 		if (count($roleids) > 1) {
    289. 

  289. 			$Res=$adb->pquery("select distinct activitytype from  vtiger_activitytype inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_activitytype.picklist_valueid where roleid in (". generateQuestionMarks($roleids) .") and picklistid in (select picklistid from vtiger_activitytype) order by sortid asc", array($roleids));
    290. 

  290. 		} else {
    291. 

  291. 			$Res=$adb->pquery("select distinct activitytype from vtiger_activitytype inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_activitytype.picklist_valueid where roleid = ? and picklistid in (select picklistid from vtiger_activitytype) order by sortid asc", array($roleid));
    292. 

  292. 		}
    293. 

  293. 	}
    294. 

  294. 	
    295. 

  295. 	$eventlist='';
    296. 

  296. 	for($i=0; $i<$adb->num_rows($Res);$i++)
    297. 

  297. 	{
    298. 

  298. 		$eventlist .= $adb->query_result($Res,$i,'activitytype').";";
    299. 

  299. 	}
    300. 

  300. 	
    301. 

  301. 	$headerdata = "";
    302. 

  302. 	$headerdata .="
    303. 

  303. 			<div style='display: block;' id='mnuTab'>
    304. 

  304. 			<form name='EventViewOption' method='POST' action='index.php' style='display:inline;'>
    305. 

  305. 			<input type='hidden' id='complete_view' name='complete_view' value='' />
    306. 

  306. 			<table align='center' border='0' cellpadding='5' cellspacing='0' width='98%'>
    307. 

  307. 			<tr><td colspan='3'>&nbsp;</td></tr>";
    308. 

  308. 			if(isPermitted("Calendar","EditView") == "yes")
    309. 

  309. 			{
    310. 

  310. 			$headerdata .="<tr>
    311. 

  311. 				<td>
    312. 

  312. 				<table><tr><td class='calAddButton' style='cursor:pointer;height:30px' align='center' width='15%' onMouseOver='fnAddEvent(this,\"addEventDropDown\",\"".$temp_date."\",\"".$temp_date."\",\"".$time_arr['starthour']."\",\"".$time_arr['startmin']."\",\"".$time_arr['startfmt']."\",\"".$time_arr['endhour']."\",\"".$time_arr['endmin']."\",\"".$time_arr['endfmt']."\",\"".$viewBox."\",\"".$subtab."\",\"".$eventlist."\");'>
    313. 

  313. 					".$mod_strings['LBL_ADD']."
    314. 

  314. 					<img src='".vtiger_imageurl('menuDnArrow.gif', $theme)."' style='padding-left: 5px;' border='0'>
    315. 

  315. 				</td></tr></table> </td>";
    316. 

  316. 			}
    317. 

  317. 			else
    318. 

  318. 			{
    319. 

  319. 				$headerdata .="<tr><td>&nbsp;</td>";
    320. 

  320. 			}
    321. 

  321. 	$headerdata .="<td align='center' width='43%'><span id='total_activities'>";//USER SELECT CUSTOMIZATION
    322. 

  322. 	$headerdata .= getEventInfo($cal_arr,'listcnt'); 
    323. 

  323. 	$headerdata .= "</span></td>
    324. 

  324. 				<td align='center' width='40%'><table border=0 cellspacing=0 cellpadding=2><tr><td class=small><b>".$mod_strings['LBL_VIEW']." : </b></td><td>";//USER SELECT CUSTOMIZATION
    325. 

  325. 	$view_options = getEventViewOption($cal_arr,$viewBox);
    326. 

  326. 

  327. 	// User Select Customization
    328. 

  328. 	$view_options .= calendarview_getUserSelectOptions( calendarview_getSelectedUserId() );
    329. 

  329. 	// END
    330. 

  330. 

  331. 	$headerdata .=$view_options."</td></tr></table>
    332. 

  332. 				</td>
    333. 

  333. 			</tr>
    334. 

  334. 		</table></form>";
    335. 

  335. 	echo $headerdata;	
    336. 

  336. 	$cal_log->debug("Exiting get_cal_header_data() method...");
    337. 

  337. }
    338. 

  338. 

  339. /**
    340. 

  340.  * Function creates HTML select statement to display View selection box
    341. 

  341.  * @param array  $cal     - collection of objects and strings 
    342. 

  342.  * @param string $viewBox - string 'listview' or 'hourview'. if 'listview' means get Events ListView.if 'hourview' means get Events HourView.
    343. 

  343.  * return string $view   - html selection box
    344. 

  344.  */
    345. 

  345. function getEventViewOption(& $cal,$viewBox)
    346. 

  346. {
    347. 

  347. 	global $mod_strings,$cal_log;
    348. 

  348. 	$category = getParentTab();
    349. 

  349. 	if($viewBox == 'listview')
    350. 

  350. 	{
    351. 

  351. 		$list_sel = 'selected';
    352. 

  352. 		$hr_sel = '';
    353. 

  353. 	}
    354. 

  354. 	else
    355. 

  355. 	{
    356. 

  356. 		$list_sel = '';
    357. 

  357. 		$hr_sel = 'selected';
    358. 

  358. 	}
    359. 

  359. 	$cal_log->debug("Entering getEventViewOption() method...");
    360. 

  360. 	$view = "<input type='hidden' name='view' value='".$cal['calendar']->view."'>
    361. 

  361. 			<input type='hidden' name='hour' value='".$cal['calendar']->date_time->hour."'>
    362. 

  362. 			<input type='hidden' name='day' value='".$cal['calendar']->date_time->day."'>
    363. 

  363. 			<input type='hidden' name='week' value='".$cal['calendar']->date_time->week."'>
    364. 

  364. 			<input type='hidden' name='month' value='".$cal['calendar']->date_time->month."'>
    365. 

  365. 			<input type='hidden' name='year' value='".$cal['calendar']->date_time->year."'>
    366. 

  366. 			<input type='hidden' name='parenttab' value='".$category."'>
    367. 

  367. 			<input type='hidden' name='module' value='Calendar'>
    368. 

  368. 			<input type='hidden' name='return_module' value='Calendar'>
    369. 

  369. 			<input type='hidden' name='action' value=''>
    370. 

  370. 			<input type='hidden' name='return_action' value=''>
    371. 

  371. 							 
    372. 

  372. 		        <select name='viewOption' class='importBox' id='view_Option' onChange='fnRedirect();'>";
    373. 

  373. 	if($cal['view'] == 'day')
    374. 

  374. 	{
    375. 

  375. 		$view .="<option value='listview' ".$list_sel.">".$mod_strings['LBL_LISTVIEW']."</option>
    376. 

  376. 			 <option value='hourview' ".$hr_sel.">".$mod_strings['LBL_HRVIEW']."</option>";	
    377. 

  377. 	}
    378. 

  378. 	elseif($cal['view'] == 'week')
    379. 

  379. 	{
    380. 

  380. 		$view .="<option value='listview' ".$list_sel.">".$mod_strings['LBL_LISTVIEW']."</option>
    381. 

  381. 			 <option value='hourview' ".$hr_sel.">".$mod_strings['LBL_WEEKVIEW']."</option>";
    382. 

  382. 	}
    383. 

  383. 	elseif($cal['view'] == 'month')
    384. 

  384. 	{
    385. 

  385. 		$view .="<option value='listview' ".$list_sel.">".$mod_strings['LBL_LISTVIEW']."</option>
    386. 

  386. 			 <option value='hourview' ".$hr_sel.">".$mod_strings['LBL_MONTHVIEW']."</option>";
    387. 

  387. 	}
    388. 

  388. 	elseif($cal['view'] == 'year')
    389. 

  389. 	{
    390. 

  390. 		$view .="<option value='listview' ".$list_sel.">".$mod_strings['LBL_LISTVIEW']."</option>
    391. 

  391. 			 <option value='hourview' ".$hr_sel.">".$mod_strings['LBL_YEARVIEW']."</option>";
    392. 

  392. 	}
    393. 

  393. 	else
    394. 

  394. 		die("view is not defined");
    395. 

  395. 	$view .="</select>";
    396. 

  396. 	$cal_log->debug("Exiting getEventViewOption() method...");
    397. 

  397. 	return $view;
    398. 

  398. }
    399. 

  399. 

  400. /**
    401. 

  401.  * Function creates HTML anchor tag to get previous-day/week/month/year view
    402. 

  402.  * @param array  $cal        - collection of objects and strings
    403. 

  403.  * @param string $viewBox    - string 'listview' or 'hourview' or may be empty. if 'listview' means previous link in Events ListView.if 'hourview' means previous link in Events HourView. if empty means previous link in Todos ListView
    404. 

  404.  * @param string   $subtab   - string 'todo' or 'event' or may be empty. if 'todo' means Todos View. if 'event' means Events View. if empty means small calendar view. 
    405. 

  405.  * return string $link       - html tags in string format
    406. 

  406.  */
    407. 

  407. function get_previous_cal(& $cal,$viewBox='',$subtab='')
    408. 

  408. {
    409. 

  409. 	global $mod_strings,$cal_log,$theme;
    410. 

  410. 	$category = getParentTab();
    411. 

  411. 	$cal_log->debug("Entering get_previous_cal() method...");
    412. 

  412. 	if(isset($cal['size']) && $cal['size'] == 'small')
    413. 

  413.         {
    414. 

  414. 		$link = "<a href='javascript:getMiniCal(\"view=".$cal['calendar']->view."".$cal['calendar']->get_datechange_info('prev')."&parenttab=".$category."\")'><img src= '". vtiger_imageurl('small_left.gif', $theme)."' border='0' align='absmiddle' /></a>";
    415. 

  415. 	}
    416. 

  416. 	else
    417. 

  417. 	{
    418. 

  418. 		$link = "<a href='index.php?action=index&module=Calendar&view=".$cal['calendar']->view."".$cal['calendar']->get_datechange_info('prev')."&viewOption=".$viewBox."&subtab=".$subtab."&parenttab=".$category."&onlyforuser=".calendarview_getSelectedUserId()."' onclick='VtigerJS_DialogBox.block();return true;'><img src='".$cal['IMAGE_PATH']."cal_prev_nav.gif' border='0' align='absmiddle' /></a>";
    419. 

  419. 	}
    420. 

  420. 	$cal_log->debug("Exiting get_previous_cal() method...");
    421. 

  421. 	return $link;
    422. 

  422. }
    423. 

  423. 

  424. /**
    425. 

  425.  * Function creates HTML anchor tag to get next-day/week/month/year view
    426. 

  426.  * @param array  $cal        - collection of objects and strings
    427. 

  427.  * @param string $viewBox    - string 'listview' or 'hourview' or may be empty. if 'listview' means next link in Events ListView.if 'hourview' means next link in Events HourView. if empty means next link in Todos ListView
    428. 

  428.  * @param string $subtab     - string 'todo' or 'event' or may be empty. if 'todo' means Todos View. if 'event' means Events View. if empty means small calendar view. 
    429. 

  429.  * return string $link       - html tags in string format
    430. 

  430.  */
    431. 

  431. function get_next_cal(& $cal,$viewBox='',$subtab='')
    432. 

  432. {
    433. 

  433. 	global $mod_strings,$cal_log,$theme;
    434. 

  434. 	$category = getParentTab();
    435. 

  435. 	$cal_log->debug("Entering get_next_cal() method...");
    436. 

  436. 	if(isset($cal['size']) && $cal['size'] == 'small')
    437. 

  437. 	{
    438. 

  438. 		$link = "<a href='javascript:getMiniCal(\"view=".$cal['calendar']->view."".$cal['calendar']->get_datechange_info('next')."&parenttab=".$category."\")'  ><img src='". vtiger_imageurl('small_right.gif', $theme)."' border='0' align='absmiddle' /></a>";
    439. 

  439. 	}
    440. 

  440. 	else
    441. 

  441. 	{
    442. 

  442. 		$link = "<a href='index.php?action=index&module=Calendar&view=".$cal['calendar']->view."".$cal['calendar']->get_datechange_info('next')."&viewOption=".$viewBox."&subtab=".$subtab."&parenttab=".$category."&onlyforuser=".calendarview_getSelectedUserId()."' onclick='VtigerJS_DialogBox.block();return true;'><img src='".$cal['IMAGE_PATH']."cal_next_nav.gif' border='0' align='absmiddle' /></a>";
    443. 

  443. 	}
    444. 

  444. 	$cal_log->debug("Exiting get_next_cal() method...");
    445. 

  445. 	return $link;
    446. 

  446. 

  447. }
    448. 

  448. 

  449. /**
    450. 

  450.  * Function to get date info depending upon on the calendar view(Eg: 21 July 2000)
    451. 

  451.  * @param string  $view        - calendar view(day/week/month/year)
    452. 

  452.  * @param array   $date_time   - contains DateTime object
    453. 

  453.  * return string  $label       - date info(Eg for dayview : 13 July 2000)
    454. 

  454.  */
    455. 

  455. function display_date($view,$date_time)
    456. 

  456. {
    457. 

  457. 	global $cal_log;
    458. 

  458. 	$cal_log->debug("Entering display_date() method...");
    459. 

  459. 	if ($view == 'day')
    460. 

  460.         {
    461. 

  461. 		//$label = $date_time->getdayofWeek()." ";
    462. 

  462. 		$label = $date_time->get_Date()." ";
    463. 

  463. 		$label .= $date_time->getmonthName()." ";
    464. 

  464. 		$label .= $date_time->year;
    465. 

  465. 		$cal_log->debug("Exiting display_date() method...");
    466. 

  466. 		return $label;
    467. 

  467.         }
    468. 

  468. 	elseif ($view == 'week')
    469. 

  469.         {
    470. 

  470.                 $week_start = $date_time->getThisweekDaysbyIndex(1);
    471. 

  471.                 $week_end = $date_time->getThisweekDaysbyIndex(7);
    472. 

  472.                 $label = $week_start->get_Date()." ";
    473. 

  473.                 $label .= $week_start->getmonthName()." ";
    474. 

  474.                 $label .= $week_start->year;
    475. 

  475.                 $label .= " - ";
    476. 

  476.                 $label .= $week_end->get_Date()." ";
    477. 

  477.                 $label .= $week_end->getmonthName()." ";
    478. 

  478.                 $label .= $week_end->year;
    479. 

  479. 		$cal_log->debug("Exiting display_date() method...");
    480. 

  480. 		return $label;
    481. 

  481.         }
    482. 

  482. 

  483. 	elseif ($view == 'month')
    484. 

  484. 	{
    485. 

  485. 		$label = $date_time->getmonthName()." ";
    486. 

  486. 		$label .= $date_time->year;
    487. 

  487. 		$cal_log->debug("Exiting display_date() method...");
    488. 

  488. 		return $label;
    489. 

  489.         }
    490. 

  490. 	elseif ($view == 'year')
    491. 

  491. 	{
    492. 

  492. 		$cal_log->debug("Exiting display_date() method...");
    493. 

  493. 		return $date_time->year;
    494. 

  494.         }
    495. 

  495. 

  496. }
    497. 

  497. /**
    498. 

  498.  *  Function to get css class name for date
    499. 

  499.  *  @param   string  $slice_date    - date
    500. 

  500.  *  returns  string                 - css class name or empty string 
    501. 

  501.  */
    502. 

  502. function dateCheck($slice_date)
    503. 

  503. {
    504. 

  504. 	global $cal_log;
    505. 

  505. 	$cal_log->debug("Entering dateCheck() method...");
    506. 

  506. 	$userCurrenDate = new DateTimeField(date('Y-m-d H:i:s'));
    507. 

  507. 	$today = $userCurrenDate->getDisplayDate();
    508. 

  508. 	if($today == $slice_date)
    509. 

  509. 	{
    510. 

  510. 		$cal_log->debug("Exiting dateCheck() method...");
    511. 

  511. 		//css class for day having event(s)
    512. 

  512. 		return 'currDay';
    513. 

  513. 	}
    514. 

  514. 	else
    515. 

  515. 	{
    516. 

  516. 		$cal_log->debug("Exiting dateCheck() method...");
    517. 

  517. 		return '';
    518. 

  518. 	}
    519. 

  519. }
    520. 

  520. 

  521. /**
    522. 

  522.  * Function to construct respective calendar layout depends on the calendar view
    523. 

  523.  * @param  array     $view      -  collection of objects and strings
    524. 

  524.  */
    525. 

  525. function getHourView(& $view)
    526. 

  526. {
    527. 

  527. 	global $cal_log,$theme;
    528. 

  528. 	$hourview_layout = '';
    529. 

  529. 	$cal_log->debug("Entering getHourView() method...");
    530. 

  530. 	$hourview_layout .= '<br /><!-- HOUR VIEW LAYER STARTS HERE -->
    531. 

  531. 		<div id="hrView" align=center>';
    532. 

  532. 		
    533. 

  533. 	if($view['view'] == 'day')
    534. 

  534. 		$hourview_layout .= getDayViewLayout($view);
    535. 

  535. 	elseif($view['view'] == 'week')
    536. 

  536. 		$hourview_layout .= getWeekViewLayout($view);
    537. 

  537. 	elseif($view['view'] == 'month')
    538. 

  538. 		 $hourview_layout .= getMonthViewLayout($view);
    539. 

  539. 	elseif($view['view'] == 'year')
    540. 

  540. 		 $hourview_layout .= getYearViewLayout($view);
    541. 

  541. 	else
    542. 

  542. 		die("view:".$view['view']." is not defined");
    543. 

  543. 		
    544. 

  544. 	$hourview_layout .= '<br></div>
    545. 

  545. 		</div>';
    546. 

  546. 	$hourview_layout .= '<br></td></tr></table></td></tr></table>
    547. 

  547. 		</td></tr></table>
    548. 

  548. 		</td></tr></table>
    549. 

  549. 		</td></tr></table>
    550. 

  550. 		</div>
    551. 

  551. 		</td>
    552. 

  552. 	        <td valign=top><img src="'.vtiger_imageurl('showPanelTopRight.gif', $theme).'"></td>
    553. 

  553. 		</tr>
    554. 

  554. 		   </table>
    555. 

  555. 	<br>';
    556. 

  556. 	echo $hourview_layout;
    557. 

  557. 	$cal_log->debug("Exiting getHourView() method...");
    558. 

  558. }
    559. 

  559. 

  560. /**
    561. 

  561.  * Fuction constructs Events ListView depends on the view
    562. 

  562.  * @param   array  $cal            - collection of objects and strings
    563. 

  563.  * @param   string $mode           - string 'listcnt' or empty. if empty means get Events ListView else get total no. of events and no. of pending events Info.
    564. 

  564.  * returns  string $activity_list  - total no. of events and no. of pending events Info(Eg: Total Events : 2, 1 Pending).
    565. 

  565.  */
    566. 

  566. function getEventListView(& $cal,$mode='')
    567. 

  567. {
    568. 

  568. 	global $cal_log,$theme;
    569. 

  569. 	$list_view = "";
    570. 

  570.         $cal_log->debug("Entering getEventListView() method...");
    571. 

  571. 	if($cal['calendar']->view == 'day')
    572. 

  572. 	{
    573. 

  573. 		$start_date = $end_date = $cal['calendar']->date_time->get_DB_formatted_date();
    574. 

  574. 	}
    575. 

  575. 	elseif($cal['calendar']->view == 'week')
    576. 

  576. 	{
    577. 

  577. 		$start_date = $cal['calendar']->slices[0];
    578. 

  578. 		$end_date = $cal['calendar']->slices[6];
    579. 

  579. 		$start_date = DateTimeField::convertToDBFormat($start_date);
    580. 

  580. 		$end_date = DateTimeField::convertToDBFormat($end_date);
    581. 

  581. 	}
    582. 

  582. 	elseif($cal['calendar']->view == 'month')
    583. 

  583.         {
    584. 

  584. 		$start_date = $cal['calendar']->date_time->getThismonthDaysbyIndex(0);
    585. 

  585. 		$end_date = $cal['calendar']->date_time->getThismonthDaysbyIndex($cal['calendar']->date_time->daysinmonth - 1);
    586. 

  586. 		$start_date = $start_date->get_DB_formatted_date();
    587. 

  587. 		$end_date = $end_date->get_DB_formatted_date();
    588. 

  588.         }
    589. 

  589. 	elseif($cal['calendar']->view == 'year')
    590. 

  590.         {
    591. 

  591. 		$start_date = $cal['calendar']->date_time->getThisyearMonthsbyIndex(0);
    592. 

  592. 		$end_date = $cal['calendar']->date_time->get_first_day_of_changed_year('increment');
    593. 

  593. 		$start_date = $start_date->get_DB_formatted_date();
    594. 

  594. 		$end_date = $end_date->get_DB_formatted_date();
    595. 

  595. 	}
    596. 

  596. 	else
    597. 

  597.         {
    598. 

  598. 		die("view:".$cal['calendar']->view." is not defined");
    599. 

  599.         }
    600. 

  600. 	//if $mode value is empty means get Events list in array format else get the count of total events and pending events in array format.
    601. 

  601. 	if($mode != '')
    602. 

  602. 	{
    603. 

  603. 		$activity_list = getEventList($cal, $start_date, $end_date,$mode);
    604. 

  604. 		$cal_log->debug("Exiting getEventListView() method...");
    605. 

  605. 		return $activity_list;
    606. 

  606. 	}
    607. 

  607. 	else
    608. 

  608. 	{
    609. 

  609. 		$ret_arr = getEventList($cal, $start_date, $end_date,$mode);
    610. 

  610. 	        $activity_list = $ret_arr[0];
    611. 

  611. 	        $navigation_array = $ret_arr[1];
    612. 

  612. 	}
    613. 

  613. 	//To get Events listView
    614. 

  614. 	$list_view .="<br><div id='listView'>";
    615. 

  615. 	$list_view .=constructEventListView($cal,$activity_list,$navigation_array);
    616. 

  616. 	$list_view .="<br></div>
    617. 

  617. 		</div>";
    618. 

  618. 	$list_view .="<br></td></tr></table></td></tr></table>
    619. 

  619. 			</td></tr></table>
    620. 

  620. 		</td></tr></table>
    621. 

  621. 		</div>
    622. 

  622. 		</td></tr></table>
    623. 

  623. 		</td>
    624. 

  624. 		<td valign=top><img src='".vtiger_imageurl('showPanelTopRight.gif', $theme)."'></td>
    625. 

  625. 		</tr>
    626. 

  626. 	</table>
    627. 

  627. 	<br>";
    628. 

  628. 	echo $list_view;
    629. 

  629. 	$cal_log->debug("Exiting getEventListView() method...");
    630. 

  630. }
    631. 

  631. 

  632. 

  633. /**
    634. 

  634.  * Fuction constructs Todos ListView depends on the view
    635. 

  635.  * @param   array  $cal            - collection of objects and strings
    636. 

  636.  * @param   string $check          - string 'listcnt' or empty. if empty means get Todos ListView else get total no. of Todos and no. of pending todos Info.
    637. 

  637.  * returns  string $todo_list      - total no. of todos and no. of pending todos Info(Eg: Total Todos : 2, 1 Pending).
    638. 

  638.  */
    639. 

  639. function getTodosListView($cal, $check='',$subtab='')
    640. 

  640. {
    641. 

  641. 	global $cal_log,$theme;
    642. 

  642. 	$list_view = "";
    643. 

  643.         $cal_log->debug("Entering getTodosListView() method...");
    644. 

  644. 	if($cal['calendar']->view == 'day') {
    645. 

  645. 		$start_date = $end_date = $cal['calendar']->date_time->get_DB_formatted_date();
    646. 

  646. 	} elseif ($cal['calendar']->view == 'week') {
    647. 

  647. 		$start_date = $cal['calendar']->slices[0];
    648. 

  648. 		$end_date = $cal['calendar']->slices[6];
    649. 

  649. 		$start_date = DateTimeField::convertToDBFormat($start_date);
    650. 

  650. 		$end_date = DateTimeField::convertToDBFormat($end_date);
    651. 

  651. 	} elseif ($cal['calendar']->view == 'month') {
    652. 

  652. 		$start_date = $cal['calendar']->date_time->getThismonthDaysbyIndex(0);
    653. 

  653. 		$end_date = $cal['calendar']->date_time->getThismonthDaysbyIndex($cal['calendar']->
    654. 

  654. 				date_time->daysinmonth - 1);
    655. 

  655. 		$start_date = $start_date->get_DB_formatted_date();
    656. 

  656. 		$end_date = $end_date->get_DB_formatted_date();
    657. 

  657. 	} elseif ($cal['calendar']->view == 'year') {
    658. 

  658. 		$start_date = $cal['calendar']->date_time->getThisyearMonthsbyIndex(0);
    659. 

  659. 		$end_date = $cal['calendar']->date_time->get_first_day_of_changed_year('increment');
    660. 

  660. 		$start_date = $start_date->get_DB_formatted_date();
    661. 

  661. 		$end_date = $end_date->get_DB_formatted_date();
    662. 

  662. 	} else {
    663. 

  663. 		die("view:" . $cal['calendar']->view . " is not defined");
    664. 

  664. 	}
    665. 

  665. 	//if $check value is empty means get Todos list in array format else get the count of total todos and pending todos in array format.
    666. 

  666. 	if($check != '')
    667. 

  667. 	{
    668. 

  668. 		$todo_list = getTodoList($cal, $start_date, $end_date,$check);
    669. 

  669. 		$cal_log->debug("Exiting getTodosListView() method...");
    670. 

  670. 		return $todo_list;
    671. 

  671. 	}
    672. 

  672. 	else
    673. 

  673. 	{
    674. 

  674. 		$ret_arr = getTodoList($cal, $start_date, $end_date,$check);
    675. 

  675. 		$todo_list = $ret_arr[0];
    676. 

  676. 		$navigation_arr = $ret_arr[1];
    677. 

  677. 	}
    678. 

  678. 	$cal_log->debug("Exiting getTodosListView() method...");
    679. 

  679. 	$list_view .="<div id='mnuTab2' style='background-color: rgb(255, 255, 215); display:block;'>";
    680. 

  680. 	//To get Todos listView
    681. 

  681. 	$list_view .= constructTodoListView($todo_list,$cal,$subtab,$navigation_arr);
    682. 

  682. 	$list_view .="</div></div></td></tr></table></td></tr></table>
    683. 

  683. 		</td></tr></table>
    684. 

  684. 		</td></tr></table>
    685. 

  685. 		</td></tr></table>
    686. 

  686. 		</div>
    687. 

  687. 		</td>
    688. 

  688. 		<td valign=top><img src='".vtiger_imageurl('showPanelTopRight.gif', $theme)."'></td>
    689. 

  689. 	</tr>
    690. 

  690. 	</table>
    691. 

  691. 

  692. 	";
    693. 

  693. 	echo $list_view;
    694. 

  694. }
    695. 

  695. 

  696. /**
    697. 

  697.  * Function creates HTML to display Calendar DayView
    698. 

  698.  * @param  array     $cal            - collections of objects and strings.
    699. 

  699.  * return  string    $dayview_layout - html tags in string format
    700. 

  700.  */
    701. 

  701. function getDayViewLayout(& $cal)
    702. 

  702. {
    703. 

  703. 	global $current_user,$app_strings,$cal_log,$adb;
    704. 

  704. 	$no_of_rows = 1;
    705. 

  705. 	$cal_log->debug("Entering getDayViewLayout() method...");
    706. 

  706.         $date_format = $current_user->date_format;
    707. 

  707. 	$day_start_hour = $cal['calendar']->day_start_hour;
    708. 

  708. 	$day_end_hour = $cal['calendar']->day_end_hour;
    709. 

  709. 	$format = $cal['calendar']->hour_format;
    710. 

  710. 	$show_complete_view = false;
    711. 

  711. 	if(!empty($_REQUEST['complete_view'])){
    712. 

  712. 		$show_complete_view =true;
    713. 

  713. 	}
    714. 

  714. 	$dayview_layout = '';
    715. 

  715. 	$dayview_layout .= '<!-- Day view layout starts here --> <table border="0" cellpadding="10" cellspacing="0" width="100%">';
    716. 

  716. 	$dayview_layout .= '<tr>
    717. 

  717. 					<td id="mainContent" style="border-top: 1px solid rgb(204, 204, 204);">
    718. 

  718. 					<table border="0" cellpadding="5" cellspacing="0" width="100%">';
    719. 

  719. 	if(!empty($show_complete_view)) {
    720. 

  720. 		$dayview_layout .= '<tr><td width=12% class="lvtCol" bgcolor="blue" valign=top><img onClick="document.EventViewOption.complete_view.value=0;fnRedirect();" src="'.vtiger_imageurl('activate.gif', $theme).'" border="0"></td><td class="dvtCellInfo">&nbsp;</td><td class="dvtCellInfo">&nbsp;</td></tr>';
    721. 

  721. 		$day_start_hour = 0;
    722. 

  722. 		$day_end_hour = 23;
    723. 

  723. 	} else {
    724. 

  724. 		$dayview_layout .= '<tr><td width=12% class="lvtCol" bgcolor="blue" valign=top><img onClick="document.EventViewOption.complete_view.value=1;fnRedirect();" src="'.vtiger_imageurl('inactivate.gif', $theme).'" border="0"></td><td class="dvtCellInfo">&nbsp;</td><td class="dvtCellInfo">&nbsp;</td></tr>';
    725. 

  725. 	}
    726. 

  726. 	for($j=0;$j<24;$j++)
    727. 

  727. 	{
    728. 

  728. 		$slice = $cal['calendar']->slices[$j];
    729. 

  729. 		$act = $cal['calendar']->day_slice[$slice]->activities;
    730. 

  730. 		if(!empty($act))
    731. 

  731. 		{
    732. 

  732. 			$temprows = count($act);
    733. 

  733. 			$no_of_rows = ($no_of_rows>$temprows)?$no_of_rows:$temprows;
    734. 

  734. 		}
    735. 

  735. 	}
    736. 

  736. 	for($i=$day_start_hour;$i<=$day_end_hour;$i++)
    737. 

  737. 	{
    738. 

  738. 		$time = array('hour'=>$i,'minute'=>0);
    739. 

  739. 		$sub_str = formatUserTimeString($time,$format);
    740. 

  740. 		$y = $i+1;
    741. 

  741. 		$hour_startat = formatUserTimeString(array('hour'=>$i,'minute'=>0),'24');
    742. 

  742. 		$hour_endat = formatUserTimeString(array('hour'=>$y,'minute'=>0),'24');
    743. 

  743. 

  744. 		$time_arr = getaddEventPopupTime($hour_startat,$hour_endat,$format);
    745. 

  745. 		$date = new DateTimeField(null);
    746. 

  746. 		$endDate = new DateTimeField(date('Y-m-d', time() + (1*24*50*60)));
    747. 

  747. 		$sttemp_date = $date->getDisplayDate();
    748. 

  748. 		$endtemp_date = $endDate->getDisplayDate();
    749. 

  749. 

  750. 		$js_string = "";
    751. 

  751. 		if(isPermitted("Calendar","EditView") == "yes")
    752. 

  752. 		              $js_string = 'onClick="fnvshobj(this,\'addEvent\'); gshow(\'addEvent\',\'Call\',\''.$sttemp_date.'\',\''.$endtemp_date.'\',\''.$time_arr['starthour'].'\',\''.$time_arr['startmin'].'\',\''.$time_arr['startfmt'].'\',\''.$time_arr['endhour'].'\',\''.$time_arr['endmin'].'\',\''.$time_arr['endfmt'].'\',\'hourview\',\'event\')"';
    753. 

  753. 		$dayview_layout .= '<tr>
    754. 

  754. 					<td style="cursor:pointer;" class="lvtCol" valign=top height="75"  width="10%" '.$js_string.'>'.$sub_str.'</td>';
    755. 

  755. 		//To display events in Dayview
    756. 

  756. 		$dayview_layout .= getdayEventLayer($cal,$cal['calendar']->slices[$i],$no_of_rows);
    757. 

  757. 		$dayview_layout .= '</tr>';
    758. 

  758. 	}
    759. 

  759. 	$dayview_layout .= '</table>
    760. 

  760. 			</td></tr></table>';
    761. 

  761. 	$cal_log->debug("Exiting getDayViewLayout() method...");
    762. 

  762. 	return $dayview_layout;		
    763. 

  763. }
    764. 

  764. 

  765. /**
    766. 

  766.  * Function creates HTML to display Calendar WeekView
    767. 

  767.  * @param  array     $cal             - collections of objects and strings.
    768. 

  768.  * return  string    $weekview_layout - html tags in string format
    769. 

  769.  */
    770. 

  770. function getWeekViewLayout(& $cal)
    771. 

  771. {
    772. 

  772. 	global $current_user,$app_strings,$cal_log,$theme;
    773. 

  773. 	$category = getParentTab();
    774. 

  774. 	$cal_log->debug("Entering getWeekViewLayout() method...");
    775. 

  775.         $date_format = $current_user->date_format;
    776. 

  776. 	$day_start_hour = $cal['calendar']->day_start_hour;
    777. 

  777. 	$day_end_hour = $cal['calendar']->day_end_hour;
    778. 

  778. 	$format = $cal['calendar']->hour_format;
    779. 

  779. 	$show_complete_view = false;
    780. 

  780. 	if(!empty($_REQUEST['complete_view'])){
    781. 

  781. 		$show_complete_view =true;
    782. 

  782. 	}
    783. 

  783. 	$weekview_layout = '';
    784. 

  784.     $weekview_layout .= '<table border="0" cellpadding="10" cellspacing="0" width="98%" class="calDayHour" style="background-color: #dadada">';
    785. 

  785. 	for ($col=0;$col<=7;$col++)
    786. 

  786.     {
    787. 

  787.     	if($col==0) {
    788. 

  788.             	$weekview_layout .= '<tr>';
    789. 

  789.             	if(!empty($show_complete_view)) {
    790. 

  790.             		$weekview_layout .= '<td width=12% class="lvtCol" bgcolor="blue" valign=top><img onClick="document.EventViewOption.complete_view.value=0;fnRedirect();" src="'.vtiger_imageurl('activate.gif', $theme).'" border="0"></td>';
    791. 

  791. 					$day_start_hour = 0;
    792. 

  792. 					$day_end_hour = 23;
    793. 

  793.             	} else {
    794. 

  794.             		$weekview_layout .= '<td width=12% class="lvtCol" bgcolor="blue" valign=top><img onClick="document.EventViewOption.complete_view.value=1;fnRedirect();" src="'.vtiger_imageurl('inactivate.gif', $theme).'" border="0"></td>';
    795. 

  795.             	}
    796. 

  796. 		} else {
    797. 

  797. 			//To display Days in Week
    798. 

  798. 			$cal['slice'] = $cal['calendar']->week_array[$cal['calendar']->slices[$col-1]];
    799. 

  799. 			$date = $cal['calendar']->date_time->getThisweekDaysbyIndex($col);
    800. 

  800. 			$day = $date->getdayofWeek_inshort();
    801. 

  801. 			$weekview_layout .= '<td width=12% class="lvtCol" bgcolor="blue" valign=top>';
    802. 

  802. 			$weekview_layout .= '<a href="index.php?module=Calendar&action=index&view='.$cal['slice']->getView().'&'.$cal['slice']->start_time->get_date_str().'&parenttab='.$category.'">';
    803. 

  803. 			$weekview_layout .= $date->get_Date().' - '.$day;
    804. 

  804. 			$weekview_layout .= "</a>";
    805. 

  805. 			$weekview_layout .= '</td>';
    806. 

  806. 		}
    807. 

  807. 	}
    808. 

  808. 	$weekview_layout .= '</tr></table>';
    809. 

  809. 	$weekview_layout .= '<table border="0" cellpadding="10" cellspacing="1" width="98%" class="calDayHour" style="background-color: #dadada">';
    810. 

  810. 	//To display Hours in User selected format
    811. 

  811. 	for($i=$day_start_hour;$i<=$day_end_hour;$i++)
    812. 

  812. 	{
    813. 

  813. 		$count = $i;
    814. 

  814. 		$hour_startat = formatUserTimeString(array('hour'=>$i,'minute'=>0),'24');
    815. 

  815. 		$hour_endat = formatUserTimeString(array('hour'=>($i+1),'minute'=>0),'24');
    816. 

  816. 		$time_arr = getaddEventPopupTime($hour_startat,$hour_endat,$format);
    817. 

  817. 		
    818. 

  818. 		$weekview_layout .= '<tr>';
    819. 

  819. 		for ($column=1;$column<=1;$column++)
    820. 

  820.         	{
    821. 

  821. 			$time = array('hour'=>$i,'minute'=>0);
    822. 

  822. 			$sub_str = formatUserTimeString($time,$format);
    823. 

  823. 			$weekview_layout .= '<td style="border-top: 1px solid rgb(239, 239, 239); background-color: rgb(234, 234, 234); height: 40px;" valign="top" width="12%">';
    824. 

  824. 			$weekview_layout .=$sub_str;
    825. 

  825. 	                $weekview_layout .= '</td>';
    826. 

  826. 		}
    827. 

  827. 		for ($column=0;$column<=6;$column++)
    828. 

  828. 		{
    829. 

  829. 			$temp_ts = $cal['calendar']->week_array[$cal['calendar']->slices[$column]]->start_time->ts;
    830. 

  830. 			$date = new DateTimeField(date('Y-m-d', $temp_ts));
    831. 

  831. 			$sttemp_date = $date->getDisplayDate();
    832. 

  832. 			if($i != 23)
    833. 

  833. 				$endtemp_date = $sttemp_date;
    834. 

  834. 			else
    835. 

  835. 			{
    836. 

  836. 				$endtemp_ts = $cal['calendar']->week_array[$cal['calendar']->slices[$column+1]]->start_time->ts;
    837. 

  837. 				$endDate = new DateTimeField(date('Y-m-d', $temp_ts));
    838. 

  838. 				$endtemp_date = $endDate->getDisplayDate();
    839. 

  839. 			}
    840. 

  840. 

  841. 			$weekview_layout .= '<td class="cellNormal" onMouseOver="cal_show(\'create_'.$sttemp_date.''.$time_arr['starthour'].''.$time_arr['startfmt'].'\')" onMouseOut="fnHide_Event(\'create_'.$sttemp_date.''.$time_arr['starthour'].''.$time_arr['startfmt'].'\')"  style="height: 40px;" bgcolor="white" valign="top" width="12%" align=right vlign=top>';
    842. 

  842. 			$weekview_layout .= '<div id="create_'.$sttemp_date.''.$time_arr['starthour'].''.$time_arr['startfmt'].'" style="visibility: hidden;">';
    843. 

  843. 			if(isPermitted("Calendar","EditView") == "yes")
    844. 

  844. 		                        $weekview_layout .='<img onClick="fnvshobj(this,\'addEvent\'); gshow(\'addEvent\',\'Call\',\''.$sttemp_date.'\',\''.$endtemp_date.'\',\''.$time_arr['starthour'].'\',\''.$time_arr['startmin'].'\',\''.$time_arr['startfmt'].'\',\''.$time_arr['endhour'].'\',\''.$time_arr['endmin'].'\',\''.$time_arr['endfmt'].'\',\'hourview\',\'event\')" src="'.vtiger_imageurl('cal_add.gif', $theme).'" border="0">';
    845. 

  845. 					
    846. 

  846.                         $weekview_layout .='</div>';
    847. 

  847. 			//To display events in WeekView
    848. 

  848. 			$weekview_layout .=getweekEventLayer($cal,$cal['calendar']->week_hour_slices[$count]);
    849. 

  849. 			$weekview_layout .= '</td>';
    850. 

  850. 			$count = $count+24;
    851. 

  851. 		}
    852. 

  852. 		$weekview_layout .= '</tr>';
    853. 

  853. 	}
    854. 

  854. 	$weekview_layout .= '</table>';
    855. 

  855. 	return $weekview_layout;
    856. 

  856. 	$cal_log->debug("Exiting getWeekViewLayout() method...");
    857. 

  857. 		
    858. 

  858. }
    859. 

  859. 

  860. /**
    861. 

  861.  * Function creates HTML to display Calendar MonthView
    862. 

  862.  * @param  array     $cal            - collections of objects and strings.
    863. 

  863.  * return  string    $monthview_layout - html tags in string format
    864. 

  864.  */
    865. 

  865. function getMonthViewLayout(& $cal)
    866. 

  866. {
    867. 

  867. 	global $current_user,$app_strings,$cal_log,$theme;
    868. 

  868. 	$category = getParentTab();
    869. 

  869. 	$cal_log->debug("Entering getMonthViewLayout() method...");
    870. 

  870. 	$date_format = $current_user->date_format;
    871. 

  871. 	$count = 0;
    872. 

  872. 	//To get no. of rows(weeks) in month
    873. 

  873.         if ($cal['calendar']->month_array[$cal['calendar']->slices[35]]->start_time->month != $cal['calendar']->date_time->month) {
    874. 

  874.                 $rows = 5;
    875. 

  875.         } else {
    876. 

  876.                 $rows = 6;
    877. 

  877.         }
    878. 

  878. 	$format = $cal['calendar']->hour_format;
    879. 

  879. 	$hour_startat = formatUserTimeString(array('hour'=>date('H:i'),'minute'=>0),'24');
    880. 

  880.         $hour_endat = formatUserTimeString(array('hour'=>date('H:i',(time() + (60 * 60))),'minute'=>0),'24');
    881. 

  881. 	$time_arr = getaddEventPopupTime($hour_startat,$hour_endat,$format);
    882. 

  882. 	$monthview_layout = '';
    883. 

  883. 	$monthview_layout .= '<table class="calDayHour" style="background-color: rgb(218, 218, 218);" border="0" cellpadding="5" cellspacing="1" width="98%"><tr>';
    884. 

  884. 	//To display days in week 
    885. 

  885. 	for ($i = 0; $i < 7; $i ++)
    886. 

  886. 	{
    887. 

  887. 		$first_row = $cal['calendar']->month_array[$cal['calendar']->slices[$i]];
    888. 

  888. 		$weekday = $first_row->start_time->getdayofWeek();
    889. 

  889. 		$monthview_layout .= '<td class="lvtCol" valign="top" width="14%">'.$weekday.'</td>';
    890. 

  890. 	}
    891. 

  891. 	$monthview_layout .= '</tr></table>';
    892. 

  892. 	$monthview_layout .= '<!-- month headers --> <table border=0 cellspacing=1 cellpadding=5 width=98% class="calDayHour" >';
    893. 

  893. 	$cnt = 0;
    894. 

  894. 	for ($i = 0; $i < $rows; $i ++)
    895. 

  895. 	{
    896. 

  896. 	        $monthview_layout .= '<tr>';
    897. 

  897. 		for ($j = 0; $j < 7; $j ++)
    898. 

  898.                 {
    899. 

  899. 			$temp_ts = $cal['calendar']->month_array[$cal['calendar']->slices[$count]]->start_time->ts;
    900. 

  900. 	                $temp_date = (($date_format == 'dd-mm-yyyy')?(date('d-m-Y',$temp_ts)):(($date_format== 'mm-dd-yyyy')?(date('m-d-Y',$temp_ts)):(($date_format == 'yyyy-mm-dd')?(date('Y-m-d', $temp_ts)):(''))));
    901. 

  901. 			if($cal['calendar']->day_start_hour != 23)
    902. 

  902. 				$endtemp_date = $temp_date;
    903. 

  903. 			else
    904. 

  904. 			{
    905. 

  905. 				$endtemp_ts = $cal['calendar']->month_array[$cal['calendar']->slices[$count+1]]->start_time->ts;
    906. 

  906. 				$endtemp_date = (($date_format == 'dd-mm-yyyy')?(date('d-m-Y',$endtemp_ts)):(($date_format== 'mm-dd-yyyy')?(date('m-d-Y',$endtemp_ts)):(($date_format == 'yyyy-mm-dd')?(date('Y-m-d', $endtemp_ts)):(''))));
    907. 

  907. 			}
    908. 

  908. 			$cal['slice'] = $cal['calendar']->month_array[$cal['calendar']->slices[$count]];
    909. 

  909. 			$monthclass = dateCheck($cal['slice']->start_time->get_formatted_date());
    910. 

  910. 			if($monthclass != '')
    911. 

  911. 				$monthclass = 'calSel';
    912. 

  912. 			else
    913. 

  913. 				$monthclass = 'dvtCellLabel';
    914. 

  914. 			//to display dates in month
    915. 

  915. 			if ($cal['slice']->start_time->getMonth() == $cal['calendar']->date_time->getMonth())
    916. 

  916. 			{
    917. 

  917. 				$monthview_layout .= '<td style="text-align:left;" class="'.$monthclass.'" width="14%" onMouseOver="cal_show(\'create_'.$temp_date.''.$time_arr['starthour'].'\')" onMouseOut="fnHide_Event(\'create_'.$temp_date.''.$time_arr['starthour'].'\')">';
    918. 

  918. 				$monthview_layout .= '<a href="index.php?module=Calendar&action=index&view='.$cal['slice']->getView().''.$cal['slice']->start_time->get_date_str().'&parenttab='.$category.'">';
    919. 

  919. 				$monthview_layout .= $cal['slice']->start_time->get_Date();
    920. 

  920. 				$monthview_layout .= '</a>';
    921. 

  921. 				$monthview_layout .= '<div id="create_'.$temp_date.''.$time_arr['starthour'].'" style="visibility:hidden;">';
    922. 

  922. 				if(isPermitted("Calendar","EditView") == "yes")
    923. 

  923.                                 $monthview_layout .='<a onClick="fnvshobj(this,\'addEvent\'); gshow(\'addEvent\',\'Call\',\''.$temp_date.'\',\''.$endtemp_date.'\',\''.$time_arr['starthour'].'\',\''.$time_arr['startmin'].'\',\''.$time_arr['startfmt'].'\',\''.$time_arr['endhour'].'\',\''.$time_arr['endmin'].'\',\''.$time_arr['endfmt'].'\',\'hourview\',\'event\')" href="javascript:void(0)"><img src="' . vtiger_imageurl('cal_add.gif', $theme). '" border="0"></a>';
    924. 

  924.                                 $monthview_layout .= '  </div></td>';
    925. 

  925. 			}
    926. 

  926. 			else
    927. 

  927. 			{
    928. 

  928. 				$monthview_layout .= '<td class="dvtCellLabel" width="14%">&nbsp;</td>';
    929. 

  929. 			}
    930. 

  930. 			$count++;
    931. 

  931. 		}
    932. 

  932. 		$monthview_layout .= '</tr>';
    933. 

  933. 		$monthview_layout .= '<tr>';
    934. 

  934. 		for ($j = 0; $j < 7; $j ++)
    935. 

  935. 		{
    936. 

  936. 			$monthview_layout .= '<td bgcolor="white" height="90" valign="top" width="200" align=right>';
    937. 

  937. 			$monthview_layout .= getmonthEventLayer($cal,$cal['calendar']->slices[$cnt]);
    938. 

  938. 			$monthview_layout .= '</td>';
    939. 

  939. 			$cnt++;
    940. 

  940. 		}
    941. 

  941. 		$monthview_layout .= '</tr>';
    942. 

  942. 	}
    943. 

  943. 	$monthview_layout .= '</table>';
    944. 

  944. 	return $monthview_layout;
    945. 

  945. 	$cal_log->debug("Exiting getMonthViewLayout() method...");
    946. 

  946. 		
    947. 

  947. }
    948. 

  948. 

  949. /**
    950. 

  950.  * Function creates HTML to display Calendar YearView
    951. 

  951.  * @param  array     $cal            - collections of objects and strings.
    952. 

  952.  * return  string    $yearview_layout - html tags in string format
    953. 

  953.  */
    954. 

  954. function getYearViewLayout(& $cal)
    955. 

  955. {
    956. 

  956. 	global $mod_strings,$cal_log;
    957. 

  957. 	$category = getParentTab();
    958. 

  958. 	$cal_log->debug("Entering getYearViewLayout() method...");
    959. 

  959. 	$yearview_layout = '';
    960. 

  960. 	$yearview_layout .= '<table border="0" cellpadding="5" cellspacing="0" width="100%">';
    961. 

  961. 	$count = 0;
    962. 

  962. 	//year view divided as 4 rows and 3 columns
    963. 

  963. 	for($i=0;$i<4;$i++)
    964. 

  964. 	{
    965. 

  965. 		$yearview_layout .= '<tr>';
    966. 

  966. 		for($j=0;$j<3;$j++)
    967. 

  967.         	{
    968. 

  968. 			$cal['slice'] = $cal['calendar']->year_array[$cal['calendar']->slices[$count]];
    969. 

  969. 			$yearview_layout .= '<td width="33%">
    970. 

  970. 						<table class="mailClient " border="0" cellpadding="2" cellspacing="0" width="98%">
    971. 

  971. 							<tr>
    972. 

  972. 								<td colspan="7" class="calHdr" style="padding:5px">
    973. 

  973. 								<a style="text-decoration: none;" href="index.php?module=Calendar&action=index&view=month&hour=0&day=1&month='.($count+1).'&year='.$cal['calendar']->date_time->year.'&parenttab='.$category.'"><b>
    974. 

  974. 									'.$cal['slice']->start_time->month_inlong.'
    975. 

  975. 									</b></a>
    976. 

  976. 								</td>
    977. 

  977. 							</tr><tr class="hdrNameBg">';
    978. 

  978. 			for($w=0;$w<7;$w++)
    979. 

  979. 			{
    980. 

  980. 				$yearview_layout .= '<th width="14%">'.$mod_strings['cal_weekdays_short'][$w].'</th>';
    981. 

  981. 			}
    982. 

  982. 			$yearview_layout .= '</tr>';
    983. 

  983. 			$date = DateTimeField::convertToDBFormat($cal['calendar']->month_day_slices
    984. 

  984. 					[$count][35]);
    985. 

  985. 			list($_3rdyear,$_3rdmonth,$_3rddate) = explode("-",$date);
    986. 

  986. 			$date = DateTimeField::convertToDBFormat($cal['calendar']->month_day_slices
    987. 

  987. 					[$count][6]);
    988. 

  988. 			list($_2ndyear,$_2ndmonth,$_2nddate) = explode("-",$date);
    989. 

  989. 			//to get no. of rows(weeks) in month
    990. 

  990. 			if ($_3rdmonth != $_2ndmonth) {
    991. 

  991. 	        	        $rows = 5;
    992. 

  992.         		} else {
    993. 

  993. 		                $rows = 6;
    994. 

  994. 		        }
    995. 

  995. 			$cnt = 0;
    996. 

  996. 			$date_stack = Array();
    997. 

  997. 			for ($k = 0; $k < 5; $k ++)
    998. 

  998.         		{
    999. 

  999. 				$yearview_layout .= '<tr>';
    1000. 

  1000. 				for ($mr = 0; $mr < 7; $mr ++)
    1001. 

  1001. 				{
    1002. 

  1002. 					$date = DateTimeField::convertToDBFormat($cal['calendar']->month_day_slices
    1003. 

  1003. 							[$count][$cnt]);
    1004. 

  1004. 					list($_1styear,$_1stmonth,$_1stdate) = explode("-", $date);
    1005. 

  1005. 					if(count($cal['slice']->activities) != 0)
    1006. 

  1006. 					{
    1007. 

  1007. 						for($act_count = 0;$act_count<count($cal['slice']->activities);$act_count++)
    1008. 

  1008. 						{
    1009. 

  1009. 							array_push($date_stack,$cal['slice']->activities[$act_count]->
    1010. 

  1010. 									start_time->get_formatted_date());
    1011. 

  1011. 						}
    1012. 

  1012. 					}
    1013. 

  1013. 					if(in_array($cal['calendar']->month_day_slices[$count][$cnt],$date_stack))
    1014. 

  1014. 						$event_class = 'class="eventDay"'; 
    1015. 

  1015. 					else
    1016. 

  1016. 						$event_class = '';
    1017. 

  1017. 					if($_1stmonth == $_2ndmonth)
    1018. 

  1018. 						$curclass = dateCheck($cal['calendar']->month_day_slices[$count][$cnt]);
    1019. 

  1019. 					if($curclass != '')
    1020. 

  1020. 					{
    1021. 

  1021. 						$class = 'class="'.$curclass.'"';
    1022. 

  1022. 						$curclass = '';
    1023. 

  1023. 					}
    1024. 

  1024. 					else
    1025. 

  1025. 					{
    1026. 

  1026. 						$class = $event_class;
    1027. 

  1027. 						$event_class = '';
    1028. 

  1028. 					}
    1029. 

  1029. 					$date = $_1stdate + 0;
    1030. 

  1030. 					$month = $_1stmonth + 0;
    1031. 

  1031. 					$yearview_layout .= '<td '.$class.' style="text-align:center">';
    1032. 

  1032. 					if($rows == 6 && $k==0)
    1033. 

  1033. 					{
    1034. 

  1034. 						$tdate = DateTimeField::convertToDBFormat($cal['calendar']->
    1035. 

  1035. 								month_day_slices[$count][35+$mr]);
    1036. 

  1036. 						list($tempyear,$tempmonth,$tempdate) = explode("-", $tdate);
    1037. 

  1037. 						if($tempmonth == $_2ndmonth)
    1038. 

  1038. 							$yearview_layout .= '<a href="index.php?module=Calendar&action=index&view=day&hour=0&day='.$tempdate.'&month='.$tempmonth.'&year='.$tempyear.'&parenttab='.$category.'">'.$tempdate;
    1039. 

  1039. 					}
    1040. 

  1040. 					if($_1stmonth == $_2ndmonth)
    1041. 

  1041. 					{
    1042. 

  1042. 						$yearview_layout .= '<a href="index.php?module=Calendar&action=index&view=day&hour=0&day='.$date.'&month='.$month.'&year='.$_1styear.'&parenttab='.$category.'">'.$date;
    1043. 

  1043. 					}
    1044. 

  1044. 					$yearview_layout .= '</a></td>';
    1045. 

  1045. 				$cnt++;
    1046. 

  1046. 				}
    1047. 

  1047. 	                	$yearview_layout .= '</tr>';
    1048. 

  1048. 			}
    1049. 

  1049. 			$yearview_layout .= '
    1050. 

  1050. 						</table>		
    1051. 

  1051. 						
    1052. 

  1052. 

  1053. 						';
    1054. 

  1054. 			$count++;	
    1055. 

  1055. 		}
    1056. 

  1056. 		$yearview_layout .= '</tr>';
    1057. 

  1057. 	}
    1058. 

  1058. 	$yearview_layout .= '</table>';
    1059. 

  1059. 	return $yearview_layout;
    1060. 

  1060. 	$cal_log->debug("Exiting getYearViewLayout() method...");
    1061. 

  1061.         
    1062. 

  1062. 	
    1063. 

  1063. }
    1064. 

  1064. 

  1065. /**
    1066. 

  1066.  * Function creates HTML To display events in day view
    1067. 

  1067.  * @param  array     $cal         - collection of objects and strings
    1068. 

  1068.  * @param  string    $slice       - date:time(eg: 2006-07-13:10)
    1069. 

  1069.  * returns string    $eventlayer  - hmtl in string format
    1070. 

  1070.  */
    1071. 

  1071. function getdayEventLayer(& $cal,$slice,$rows)
    1072. 

  1072. {
    1073. 

  1073. 	global $mod_strings,$cal_log,$listview_max_textlength,$adb,$current_user,$theme;
    1074. 

  1074. 	$category = getParentTab();
    1075. 

  1075. 	$cal_log->debug("Entering getdayEventLayer() method...");
    1076. 

  1076. 	$eventlayer = '';
    1077. 

  1077. 	$arrow_img_name = '';
    1078. 

  1078. 	$rows = $rows + 1;
    1079. 

  1079. 	$last_colwidth = 100 / $rows;
    1080. 

  1080. 	$width = 100 / $rows ;
    1081. 

  1081. 	$act = $cal['calendar']->day_slice[$slice]->activities;
    1082. 

  1082. 	if(!empty($act))
    1083. 

  1083. 	{
    1084. 

  1084. 		for($i=0;$i<count($act);$i++)
    1085. 

  1085. 		{
    1086. 

  1086. 			$rowspan = 1;
    1087. 

  1087. 			$arrow_img_name = 'event'.$cal['calendar']->day_slice[$slice]->start_time->hour.'_'.$i;
    1088. 

  1088. 			$subject = $act[$i]->subject;
    1089. 

  1089. 			$id = $act[$i]->record;
    1090. 

  1090. 			if($listview_max_textlength && (strlen($subject)>$listview_max_textlength))
    1091. 

  1091. 				$subject = substr($subject,0,$listview_max_textlength)."...";
    1092. 

  1092. 			$format = $cal['calendar']->hour_format;
    1093. 

  1093. 			$duration_hour = $act[$i]->duration_hour;
    1094. 

  1094. 			$duration_min =$act[$i]->duration_minute;
    1095. 

  1095. 			$user = $act[$i]->owner;
    1096. 

  1096. 			$priority = $act[$i]->priority;
    1097. 

  1097. 			if($duration_min != '00')
    1098. 

  1098. 				$rowspan = $duration_hour+$rowspan;
    1099. 

  1099. 			elseif($duration_hour != '0')
    1100. 

  1100. 			{
    1101. 

  1101. 				$rowspan = $duration_hour;
    1102. 

  1102. 			}
    1103. 

  1103. 			$row_cnt = $rowspan;
    1104. 

  1104. 			$start_hour = timeString($act[$i]->start_time,$format);
    1105. 

  1105. 			$end_hour = timeString($act[$i]->end_time,$format);
    1106. 

  1106. 			$account_name = $act[$i]->accountname;
    1107. 

  1107. 			$eventstatus = $act[$i]->eventstatus;
    1108. 

  1108. 			$color = $act[$i]->color;
    1109. 

  1109. 			$image = vtiger_imageurl($act[$i]->image_name, $theme);
    1110. 

  1110. 			if($act[$i]->recurring)
    1111. 

  1111. 				$recurring = '<img src="'.vtiger_imageurl($act[$i]->recurring, $theme).'" align="middle" border="0"></img>';
    1112. 

  1112. 			else
    1113. 

  1113. 				$recurring = '&nbsp;';
    1114. 

  1114. 			$height = $rowspan * 75;
    1115. 

  1115. 			$javacript_str = '';
    1116. 

  1116. 			$idShared = "normal"; if($act[$i]->shared) $idShared = "shared";	
    1117. 

  1117. 			/*if($eventstatus != 'Held')
    1118. 

  1118. 			{*/
    1119. 

  1119. 			if($idShared == "normal")
    1120. 

  1120. 			{
    1121. 

  1121. 				if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete") == "yes")
    1122. 

  1122. 					$javacript_str = 'onMouseOver="cal_show(\''.$arrow_img_name.'\');" onMouseOut="fnHide_Event(\''.$arrow_img_name.'\');"';
    1123. 

  1123. 				$action_str = '<img src="' . vtiger_imageurl('cal_event.jpg', $theme). '" id="'.$arrow_img_name.'" style="visibility: hidden;" onClick="getcalAction(this,\'eventcalAction\','.$id.',\''.$cal['view'].'\',\''.$cal['calendar']->date_time->hour.'\',\''.$cal['calendar']->date_time->get_DB_formatted_date().'\',\'event\');" align="middle" border="0">';
    1124. 

  1124. 			}
    1125. 

  1125. 			else
    1126. 

  1126. 			{
    1127. 

  1127. 				$javacript_str = '';
    1128. 

  1128. 				$eventlayer .= '&nbsp;';
    1129. 

  1129. 			}
    1130. 

  1130. 			$eventlayer .= '<td class="dvtCellInfo" rowspan="'.$rowspan.'" colspan="1" width="'.$width.'%" >';
    1131. 

  1131. 			
    1132. 

  1132. 			$visibility_query=$adb->pquery('SELECT visibility from vtiger_activity where activityid=?',array($id));
    1133. 

  1133. 			$visibility = $adb->query_result($visibility_query,0,'visibility');
    1134. 

  1134. 			$user_query = $adb->pquery("SELECT vtiger_crmentity.smownerid,vtiger_users.user_name from vtiger_crmentity,vtiger_users where crmid=? and vtiger_crmentity.smownerid=vtiger_users.id", array($id));
    1135. 

  1135. 			$userid = $adb->query_result($user_query,0,"smownerid");
    1136. 

  1136. 			$assigned_role_query=$adb->pquery("select roleid from vtiger_user2role where userid=?",array($userid));
    1137. 

  1137. 			$assigned_role_id = $adb->query_result($assigned_role_query,0,"roleid");			
    1138. 

  1138. 			$role_list = $adb->pquery("SELECT * from vtiger_role WHERE parentrole LIKE '". formatForSqlLike($current_user->column_fields['roleid']) . formatForSqlLike($assigned_role_id) ."'",array());
    1139. 

  1139. 			$is_shared = $adb->pquery("SELECT * from vtiger_sharedcalendar where userid=? and sharedid=?",array($userid,$current_user->id));
    1140. 

  1140. 			$userName = getFullNameFromArray('Users', $current_user->column_fields);
    1141. 

  1141. 			if(($current_user->column_fields['is_admin']!='on' && $adb->num_rows($role_list)==0 && (($adb->num_rows($is_shared)==0 && ($visibility=='Public' || $visibility=='Private')) || $visibility=='Private')) && $userName!=$user)
    1142. 

  1142. 			{
    1143. 

  1143. 				$eventlayer .= '<div id="event_'.$cal['calendar']->day_slice[$slice]->start_time->hour.'_'.$i.'" class="event" style="height:'.$height.'px;">';
    1144. 

  1144. 			}
    1145. 

  1145. 			else{
    1146. 

  1146. 				$eventlayer .= '<div id="event_'.$cal['calendar']->day_slice[$slice]->start_time->hour.'_'.$i.'" class="event" style="height:'.$height.'px;" '.$javacript_str.'>';
    1147. 

  1147. 			}
    1148. 

  1148. 			$eventlayer .= '<table border="0" cellpadding="1" cellspacing="0" width="100%">
    1149. 

  1149. 				<tr>
    1150. 

  1150. 				<td width="10%" align="center"><img src="'.$image.'" align="middle" border="0"></td>
    1151. 

  1151. 				<td width="90%"><b>'.$start_hour.' - '.$end_hour.'</b></td></tr>';
    1152. 

  1152. 			$eventlayer .= '<tr><td align="center">'.$recurring.'</td>';
    1153. 

  1153. 			
    1154. 

  1154. 			if(($current_user->column_fields['is_admin']!='on' && $adb->num_rows($role_list)==0 && (($adb->num_rows($is_shared)==0 && ($visibility=='Public' || $visibility=='Private')) || $visibility=='Private')) && $userName!=$user)
    1155. 

  1155. 			{
    1156. 

  1156. 				$eventlayer .= '<td><font color="silver"><b>'.$user.' - '.$mod_strings['LBL_BUSY'].'</b></font></td>'; 
    1157. 

  1157. 			}else{
    1158. 

  1158. 				$eventlayer .= '<td><a href="index.php?action=DetailView&module=Calendar&record='.$id.'&activity_mode=Events&viewtype=calendar&parenttab='.$category.'"><span class="orgTab">'.$subject.'</span></a></td>
    1159. 

  1159. 				</tr>
    1160. 

  1160. 				<tr><td align="center">';
    1161. 

  1161. 				if($act[$i]->shared)
    1162. 

  1162. 					$eventlayer .= '<img src="' . vtiger_imageurl('cal12x12Shared.gif', $theme). '" align="middle" border="0">';
    1163. 

  1163. 				else
    1164. 

  1164. 					$eventlayer .= '&nbsp;';
    1165. 

  1165. 				$eventlayer .= '</td><td>('.$user.' | '.getTranslatedString($eventstatus).' | '.getTranslatedString($priority).')</td></tr><tr><td align="center">'.$action_str.'</td><td>&nbsp;</td></tr>';
    1166. 

  1166. 			}			$eventlayer .= '</table></div></td>';
    1167. 

  1167. 		}
    1168. 

  1168. 		$eventlayer .= '<td class="dvtCellInfo" rowspan="1" width="'.$last_colwidth.'%">&nbsp;</td>';
    1169. 

  1169. 	}
    1170. 

  1170. 	else
    1171. 

  1171. 	{
    1172. 

  1172. 		$eventlayer .= '<td class="dvtCellInfo" colspan="'.($rows - 1).'" width="'.($last_colwidth * ($rows - 1)).'%" rowspan="1">&nbsp;</td>';
    1173. 

  1173. 		$eventlayer .= '<td class="dvtCellInfo" rowspan="1" width="'.$last_colwidth.'%">&nbsp;</td>';
    1174. 

  1174. 	}
    1175. 

  1175. 	$cal_log->debug("Exiting getdayEventLayer() method...");
    1176. 

  1176. 	return $eventlayer;
    1177. 

  1177. }
    1178. 

  1178. 

  1179. /**
    1180. 

  1180.  * Function creates HTML To display events in week view
    1181. 

  1181.  * @param  array     $cal         - collection of objects and strings
    1182. 

  1182.  * @param  string    $slice       - date:time(eg: 2006-07-13:10)
    1183. 

  1183.  * returns string    $eventlayer  - hmtl in string format
    1184. 

  1184.  */
    1185. 

  1185. function getweekEventLayer(& $cal,$slice)
    1186. 

  1186. {
    1187. 

  1187. 	global $mod_strings,$cal_log,$listview_max_textlength,$adb,$current_user,$theme;
    1188. 

  1188. 	$category = getParentTab();
    1189. 

  1189. 	$cal_log->debug("Entering getweekEventLayer() method...");
    1190. 

  1190.         $eventlayer = '';
    1191. 

  1191.         $arrow_img_name = '';
    1192. 

  1192. 	$act = $cal['calendar']->week_slice[$slice]->activities;
    1193. 

  1193. 	if(!empty($act))
    1194. 

  1194.         {
    1195. 

  1195. 		for($i=0;$i<count($act);$i++)
    1196. 

  1196.                 {
    1197. 

  1197. 			/* fix given by dartagnanlaf START --integrated by Minnie */
    1198. 

  1198. 			$arrow_img_name = 'weekevent'.$cal['calendar']->week_slice[$slice]->start_time->get_formatted_date().'_'.$act[$i]->start_time->hour.'_'.$i;
    1199. 

  1199. 			/* fix given by dartagnanlaf END --integrated by Minnie */
    1200. 

  1200. 			$id = $act[$i]->record;
    1201. 

  1201.                         $subject = $act[$i]->subject;
    1202. 

  1202. 			if($listview_max_textlength && (strlen($subject)>$listview_max_textlength))
    1203. 

  1203. 				$subject = substr($subject,0,$listview_max_textlength)."...";
    1204. 

  1204. 			$format = $cal['calendar']->hour_format;
    1205. 

  1205. 			$start_hour = timeString($act[$i]->start_time, $format);
    1206. 

  1206. 			$end_hour = timeString($act[$i]->end_time, $format);
    1207. 

  1207. 			$account_name = $act[$i]->accountname;
    1208. 

  1208. 			$eventstatus = $act[$i]->eventstatus;
    1209. 

  1209. 			$user = $act[$i]->owner;
    1210. 

  1210. 			$priority = $act[$i]->priority;
    1211. 

  1211. 			$image =  vtiger_imageurl($act[$i]->image_name, $theme);
    1212. 

  1212. 			$idShared = "normal"; if($act[$i]->shared) $idShared = "shared";
    1213. 

  1213. 			if($act[$i]->recurring)
    1214. 

  1214. 				$recurring = '<img src="'.vtiger_imageurl($act[$i]->recurring, $theme).'" align="middle" border="0"></img>';
    1215. 

  1215. 			else
    1216. 

  1216. 				$recurring = '&nbsp;';
    1217. 

  1217.                         $color = $act[$i]->color;
    1218. 

  1218. 			if($idShared == "normal")
    1219. 

  1219. 			{
    1220. 

  1220. 				if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete") == "yes")
    1221. 

  1221. 					$javacript_str = 'onMouseOver="cal_show(\''.$arrow_img_name.'\');" onMouseOut="fnHide_Event(\''.$arrow_img_name.'\');"';
    1222. 

  1222. 				$action_str = '<img src="' . vtiger_imageurl('cal_event.jpg', $theme). '" id="'.$arrow_img_name.'" style="visibility: hidden;" onClick="getcalAction(this,\'eventcalAction\','.$id.',\''.$cal['view'].'\',\''.$cal['calendar']->date_time->hour.'\',\''.$cal['calendar']->date_time->get_DB_formatted_date().'\',\'event\');" align="middle" border="0">';
    1223. 

  1223. 			}
    1224. 

  1224. 			else
    1225. 

  1225. 			{
    1226. 

  1226. 				$javacript_str = '';
    1227. 

  1227. 				$eventlayer .= '&nbsp;';
    1228. 

  1228. 			}
    1229. 

  1229. 			
    1230. 

  1230. 			$visibility_query=$adb->pquery('SELECT visibility from vtiger_activity where activityid=?',array($id));
    1231. 

  1231. 			$visibility = $adb->query_result($visibility_query,0,'visibility');
    1232. 

  1232. 			$user_query = $adb->pquery("SELECT vtiger_crmentity.smownerid,vtiger_users.user_name from vtiger_crmentity,vtiger_users where crmid=? and vtiger_crmentity.smownerid=vtiger_users.id", array($id));
    1233. 

  1233. 			$userid = $adb->query_result($user_query,0,"smownerid");
    1234. 

  1234. 			$assigned_role_query=$adb->pquery("select roleid from vtiger_user2role where userid=?",array($userid));
    1235. 

  1235. 			$assigned_role_id = $adb->query_result($assigned_role_query,0,"roleid");			
    1236. 

  1236. 			$role_list = $adb->pquery("SELECT * from vtiger_role WHERE parentrole LIKE '". formatForSqlLike($current_user->column_fields['roleid']) . formatForSqlLike($assigned_role_id) ."'",array());
    1237. 

  1237. 			$is_shared = $adb->pquery("SELECT * from vtiger_sharedcalendar where userid=? and sharedid=?",array($userid,$current_user->id));
    1238. 

  1238. 			$userName = getFullNameFromArray('Users', $current_user->column_fields);
    1239. 

  1239. 			if(($current_user->column_fields['is_admin']!='on' && $adb->num_rows($role_list)==0 && (($adb->num_rows($is_shared)==0 && ($visibility=='Public' || $visibility=='Private')) || $visibility=='Private')) && $userName!=$user)
    1240. 

  1240. 			{
    1241. 

  1241. 				$eventlayer .= '<div id="event_'.$cal['calendar']->day_slice[$slice]->start_time->hour.'_'.$i.'" class="event" style="height:'.$height.'px;">';
    1242. 

  1242. 			}
    1243. 

  1243. 			else{
    1244. 

  1244. 				$eventlayer .= '<div id="event_'.$cal['calendar']->day_slice[$slice]->start_time->hour.'_'.$i.'" class="event" style="height:'.$height.'px;" '.$javacript_str.'>';
    1245. 

  1245. 			}
    1246. 

  1246. 												 
    1247. 

  1247. 			$eventlayer .='<table border="0" cellpadding="1" cellspacing="0" width="100%">
    1248. 

  1248. 				<tr>
    1249. 

  1249. 					<td width="10%" align="center"><img src="'.$image.'" align="middle" border="0"></td>
    1250. 

  1250. 					<td width="90%"><b>'.$start_hour.' - '.$end_hour.'</b></td>
    1251. 

  1251. 				</tr>
    1252. 

  1252. 				<tr>
    1253. 

  1253. 					<td align="center">'.$recurring.'</td>';
    1254. 

  1254. 					if(($current_user->column_fields['is_admin']!='on' && $adb->num_rows($role_list)==0 && (($adb->num_rows($is_shared)==0 && ($visibility=='Public' || $visibility=='Private')) || $visibility=='Private')) && $userName!=$user)
    1255. 

  1255. 					{	
    1256. 

  1256. 						$eventlayer .= '<td><font color="silver"><b>'.$user.'-'.$mod_strings['LBL_BUSY'].'</b></font></td>';
    1257. 

  1257. 					}else{//CALUSER CUST END							
    1258. 

  1258. 						$eventlayer .= '<td><a href="index.php?action=DetailView&module=Calendar&record='.$id.'&activity_mode=Events&viewtype=calendar&parenttab='.$category.'"><span class="orgTab">'.$subject.'</span></a></td>
    1259. 

  1259. 							</tr>
    1260. 

  1260. 							<tr><td align="center">';
    1261. 

  1261. 						if($act[$i]->shared)
    1262. 

  1262. 							$eventlayer .= '<img src="' . vtiger_imageurl('cal12x12Shared.gif', $theme). '" align="middle" border="0">';
    1263. 

  1263. 						else
    1264. 

  1264. 							$eventlayer .= '&nbsp;';
    1265. 

  1265. 						$eventlayer .= '</td><td>('.$user.' | '.getTranslatedString($eventstatus).' | '.getTranslatedString($priority).')</td></tr><tr><td align="center">'.$action_str.'</td><td>&nbsp;</td></tr>';
    1266. 

  1266. 					}
    1267. 

  1267. 				$eventlayer .= '</table></div><br>';
    1268. 

  1268.                 }
    1269. 

  1269. 		$cal_log->debug("Exiting getweekEventLayer() method...");
    1270. 

  1270. 		return $eventlayer;
    1271. 

  1271. 	}
    1272. 

  1272. 			
    1273. 

  1273. }
    1274. 

  1274. 

  1275. /**
    1276. 

  1276.  * Function creates HTML To display events in month view
    1277. 

  1277.  * @param  array     $cal         - collection of objects and strings
    1278. 

  1278.  * @param  string    $slice       - date(eg: 2006-07-13)
    1279. 

  1279.  * returns string    $eventlayer  - hmtl in string format
    1280. 

  1280.  */
    1281. 

  1281. function getmonthEventLayer(& $cal,$slice)
    1282. 

  1282. {
    1283. 

  1283. 	global $mod_strings,$cal_log,$adb,$current_user,$theme;
    1284. 

  1284. 	$category = getParentTab();
    1285. 

  1285. 	$cal_log->debug("Entering getmonthEventLayer() method...");
    1286. 

  1286. 	$eventlayer = '';
    1287. 

  1287. 	$arrow_img_name = '';
    1288. 

  1288. 	$act = $cal['calendar']->month_array[$slice]->activities;
    1289. 

  1289. 	if(!empty($act))
    1290. 

  1290.         {
    1291. 

  1291. 		$no_of_act = count($act);
    1292. 

  1292. 		if($no_of_act>2)
    1293. 

  1293. 		{
    1294. 

  1294. 			$act_row = 2;
    1295. 

  1295. 			$remin_list = $no_of_act - $act_row;
    1296. 

  1296. 		}
    1297. 

  1297. 		else
    1298. 

  1298. 		{
    1299. 

  1299. 			$act_row = $no_of_act;
    1300. 

  1300. 			$remin_list = null;
    1301. 

  1301. 		}
    1302. 

  1302.                 for($i=0;$i<$act_row;$i++)
    1303. 

  1303.                 {
    1304. 

  1304.                         $arrow_img_name = 'event'.$cal['calendar']->month_array[$slice]->start_time->hour.'_'.$i;
    1305. 

  1305. 						$id = $act[$i]->record;
    1306. 

  1306.                         $subject = $act[$i]->subject;
    1307. 

  1307.                         if(strlen($subject)>10)
    1308. 

  1308.                                 $subject = substr($subject,0,10)."...";
    1309. 

  1309. 						$format = $cal['calendar']->hour_format;
    1310. 

  1310. 						$start_hour = timeString($act[$i]->start_time,$format);
    1311. 

  1311.                         $end_hour = timeString($act[$i]->end_time,$format);
    1312. 

  1312.                         $account_name = $act[$i]->accountname;
    1313. 

  1313.                         $image = vtiger_imageurl($act[$i]->image_name, $theme);
    1314. 

  1314. 						$color = $act[$i]->color;
    1315. 

  1315. 						//Added for User Based Customview for Calendar Module
    1316. 

  1316. 						$visibility_query=$adb->pquery('SELECT visibility from vtiger_activity where activityid=?',array($id));
    1317. 

  1317. 						$visibility = $adb->query_result($visibility_query,0,'visibility');
    1318. 

  1318. 						$user_query = $adb->pquery("SELECT vtiger_crmentity.smownerid,vtiger_users.user_name from vtiger_crmentity,vtiger_users where crmid=? and vtiger_crmentity.smownerid=vtiger_users.id", array($id));
    1319. 

  1319. 						$userid = $adb->query_result($user_query,0,"smownerid");
    1320. 

  1320. 						$username = $adb->query_result($user_query,0,"user_name");
    1321. 

  1321. 						$assigned_role_query=$adb->pquery("select roleid from vtiger_user2role where userid=?",array($userid));
    1322. 

  1322. 						$assinged_role_id = $adb->query_result($assigned_role_query,0,"roleid");
    1323. 

  1323. 						$role_list = $adb->pquery("SELECT * from vtiger_role WHERE parentrole LIKE '". formatForSqlLike($current_user->column_fields['roleid']) . formatForSqlLike($assinged_role_id) ."'",array());
    1324. 

  1324. 						$is_shared = $adb->pquery("SELECT * from vtiger_sharedcalendar where userid=? and sharedid=?",array($userid,$current_user->id));
    1325. 

  1325. 						
    1326. 

  1326. 						if(($current_user->column_fields['is_admin']!='on' && $adb->num_rows($role_list)==0 && (($adb->num_rows($is_shared)==0 && ($visibility=='Public' || $visibility=='Private')) || $visibility=='Private')) && $current_user->id != $userid)
    1327. 

  1327. 						{			
    1328. 

  1328. 							$eventlayer .='<div class ="event" id="event_'.$cal['calendar']->month_array[$slice]->start_time->hour.'_'.$i.'">
    1329. 

  1329. 							<nobr><img src="'.$image.'" border="0"></img>&nbsp;'.$username.' - '.$mod_strings["LBL_BUSY"].'</nobr>
    1330. 

  1330.     	                    </div><br>';
    1331. 

  1331. 						}else{			
    1332. 

  1332. 							$eventlayer .='<div class ="event" id="event_'.$cal['calendar']->month_array[$slice]->start_time->hour.'_'.$i.'">
    1333. 

  1333. 							<nobr><img src="'.$image.'" border="0"></img>&nbsp;<a href="index.php?action=DetailView&module=Calendar&record='.$id.'&activity_mode=Events&viewtype=calendar&parenttab='.$category.'"><span class="orgTab">'.$start_hour.' - '.$end_hour.'</span></a></nobr>
    1334. 

  1334.     	                    </div><br>';
    1335. 

  1335. 						}
    1336. 

  1336. 				}
    1337. 

  1337. 					
    1338. 

  1338. 			if($remin_list != null)
    1339. 

  1339. 			{
    1340. 

  1340. 				$eventlayer .='<div valign=bottom align=right width=10%>
    1341. 

  1341. 				<a href="index.php?module=Calendar&action=index&view='.$cal['calendar']->month_array[$slice]->getView().'&'.$cal['calendar']->month_array[$slice]->start_time->get_date_str().'&parenttab='.$category.'" class="webMnu">
    1342. 

  1342. 				+'.$remin_list.'&nbsp;'.$mod_strings['LBL_MORE'].'</a></div>';
    1343. 

  1343. 			}
    1344. 

  1344. 			$cal_log->debug("Exiting getmonthEventLayer() method...");
    1345. 

  1345.             return $eventlayer;
    1346. 

  1346.         }
    1347. 

  1347. }
    1348. 

  1348. 

  1349. /**
    1350. 

  1350.  * Function to get events list scheduled between specified dates
    1351. 

  1351.  * @param array   $calendar              -  collection of objects and strings
    1352. 

  1352.  * @param string  $start_date            -  date string
    1353. 

  1353.  * @param string  $end_date              -  date string
    1354. 

  1354.  * @param string  $info                  -  string 'listcnt' or empty string. if 'listcnt' means it returns no. of events and no. of pending events in array format else it returns events list in array format
    1355. 

  1355.  * return array  $Entries               -  eventslists in array format
    1356. 

  1356.  */
    1357. 

  1357. function getEventList(& $calendar,$start_date,$end_date,$info='')
    1358. 

  1358. {
    1359. 

  1359. 	global $log,$theme;
    1360. 

  1360. 	$Entries = Array();
    1361. 

  1361. 	$category = getParentTab();
    1362. 

  1362. 	global $adb,$current_user,$mod_strings,$app_strings,$cal_log,$listview_max_textlength,$list_max_entries_per_page;
    1363. 

  1363. 	require('user_privileges/user_privileges_'.$current_user->id.'.php');
    1364. 

  1364.         require('user_privileges/sharing_privileges_'.$current_user->id.'.php');
    1365. 

  1365. 	$cal_log->debug("Entering getEventList() method...");
    1366. 

  1366. 

  1367. 	$and = "AND (
    1368. 

  1368. 					(
    1369. 

  1369. 						(
    1370. 

  1370. 							(to_timestamp(date_start || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') >= ? AND to_timestamp(date_start ||' ' ||time_start, 'YYYY-MM-DD HH24:MI:SS') <= ?)
    1371. 

  1371. 							OR	(to_timestamp(due_date || ' ' || time_end, 'YYYY-MM-DD HH24:MI:SS') >= ? AND to_timestamp(due_date ||' ' ||time_end, 'YYYY-MM-DD HH24:MI:SS') <= ? )
    1372. 

  1372. 							OR	(to_timestamp(date_start || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') <= ? AND to_timestamp(due_date ||' ' ||time_end, 'YYYY-MM-DD HH24:MI:SS') >= ?)
    1373. 

  1373. 						)
    1374. 

  1374. 						AND vtiger_recurringevents.activityid is NULL
    1375. 

  1375. 					)
    1376. 

  1376. 				OR (
    1377. 

  1377. 						(to_timestamp(vtiger_recurringevents.recurringdate || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') >= ?
    1378. 

  1378. 							AND to_timestamp(vtiger_recurringevents.recurringdate || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') <= ?)
    1379. 

  1379. 						OR	(to_timestamp(due_date || ' ' ||time_end, 'YYYY-MM-DD HH24:MI:SS') >= ? AND to_timestamp(due_date || ' ' ||time_end, 'YYYY-MM-DD HH24:MI:SS') <= ?)
    1380. 

  1380. 						OR	(to_timestamp(vtiger_recurringevents.recurringdate || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') <= ?
    1381. 

  1381. 							AND to_timestamp(due_date || ' ' ||time_end, 'YYYY-MM-DD HH24:MI:SS') >= ?)
    1382. 

  1382. 					)
    1383. 

  1383. 				)";
    1384. 

    1385. 

  1385. 	$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>
    1386. 

  1386. 							'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
    1387. 

  1387. 	$query = "select * from ( SELECT distinct on (vtiger_activity.activityid) vtiger_groups.groupname, $userNameSql as user_name,vtiger_crmentity.smownerid, vtiger_crmentity.crmid,
    1388. 

  1388.        		vtiger_activity.* FROM vtiger_activity
    1389. 

  1389. 		INNER JOIN vtiger_crmentity
    1390. 

  1390. 			ON vtiger_crmentity.crmid = vtiger_activity.activityid
    1391. 

  1391. 		LEFT JOIN vtiger_groups
    1392. 

  1392. 			ON vtiger_groups.groupid = vtiger_crmentity.smownerid
    1393. 

  1393. 		LEFT JOIN vtiger_users
    1394. 

  1394. 	       		ON vtiger_users.id = vtiger_crmentity.smownerid 
    1395. 

  1395. 		LEFT OUTER JOIN vtiger_recurringevents
    1396. 

  1396. 			ON vtiger_recurringevents.activityid = vtiger_activity.activityid
    1397. 

  1397. 		WHERE vtiger_crmentity.deleted = 0
    1398. 

  1398. 			AND (vtiger_activity.activitytype not in ('Emails','Task')) $and ";
    1399. 

    1400. 

  1400.         $list_query = $query." AND vtiger_crmentity.smownerid = "  . $current_user->id;
    1401. 

  1401. 

  1402. 	// User Select Customization: Changes should made also in (Appointment::readAppointment)
    1403. 

  1403. 	$query_filter_prefix = calendarview_getSelectedUserFilterQuerySuffix();
    1404. 

  1404. 	$query .= $query_filter_prefix;
    1405. 

  1405. 	$count_query .= $query_filter_prefix;
    1406. 

  1406. 	// END
    1407. 

  1407. 

  1408. 	$startDate = new DateTimeField($start_date.' 00:00');
    1409. 

  1409. 	$endDate = new DateTimeField($end_date. ' 23:59');
    1410. 

  1410. 	$params = $info_params = array(
    1411. 

  1411. 		$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1412. 

  1412. 		$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1413. 

  1413. 		$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1414. 

  1414. 		$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1415. 

  1415. 		$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1416. 

  1416. 		$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue()
    1417. 

  1417. 	);
    1418. 

  1418. 	if($info != '')
    1419. 

  1419. 	{
    1420. 

  1420. 		$groupids = explode(",", fetchUserGroupids($current_user->id)); // Explode can be removed, once implode is removed from fetchUserGroupids
    1421. 

  1421. 		if (count($groupids) > 0) {
    1422. 

  1422. 

  1423. 			$com_q = " AND (vtiger_crmentity.smownerid = ?
    1424. 

  1424. 					OR vtiger_groups.groupid in (". generateQuestionMarks($groupids) ."))
    1425. 

  1425. 					order BY vtiger_activity.activityid ) as t ";
    1426. 

  1426. 		} else {			
    1427. 

  1427. 			$com_q = " AND vtiger_crmentity.smownerid = ?
    1428. 

  1428. 				order BY vtiger_activity.activityid ) as t ";
    1429. 

  1429. 		}
    1430. 

  1430. 			
    1431. 

  1431. 		$pending_query = $query." AND (vtiger_activity.eventstatus = 'Planned')".$com_q;
    1432. 

  1432. 		$total_q =  $query."".$com_q;
    1433. 

  1433. 		array_push($info_params, $current_user->id);
    1434. 

  1434. 		
    1435. 

  1435. 		if (count($groupids) > 0) {
    1436. 

  1436. 			array_push($info_params, $groupids);
    1437. 

  1437. 		}
    1438. 

  1438. 

  1439. 		$total_res = $adb->pquery($total_q, $info_params);
    1440. 

  1440. 		$total = $adb->num_rows($total_res);
    1441. 

  1441. 

  1442. 		$res = $adb->pquery($pending_query, $info_params);
    1443. 

  1443. 		$pending_rows = $adb->num_rows($res);
    1444. 

  1444. 		$cal_log->debug("Exiting getEventList() method...");
    1445. 

  1445. 		return Array('totalevent'=>$total,'pendingevent'=>$pending_rows);
    1446. 

  1446. 	}
    1447. 

  1447. 	if($is_admin==false && $profileGlobalPermission[1] == 1 && $profileGlobalPermission[2] == 1 && $defaultOrgSharingPermission[16] == 3)
    1448. 

  1448. 	{
    1449. 

  1449. 		$sec_parameter=getCalendarViewSecurityParameter();
    1450. 

  1450. 		$query .= $sec_parameter;
    1451. 

  1451. 	}
    1452. 

  1452. 	if(isset($_REQUEST['type']) && $_REQUEST['type'] == 'search')
    1453. 

  1453. 	{
    1454. 

  1454. 		$search_where = calendar_search_where($_REQUEST['field_name'],$_REQUEST['search_option'],$_REQUEST['search_text']);
    1455. 

  1455. 		$group_cond .= $search_where;
    1456. 

  1456. 	}
    1457. 

  1457. 	$group_cond .= " order BY vtiger_activity.activityid ) as t ORDER BY t.date_start,t.time_start ASC";
    1458. 

  1458. 

  1459. 	//Ticket 6476
    1460. 

  1460. 	if(PerformancePrefs::getBoolean('LISTVIEW_COMPUTE_PAGE_COUNT', false) === true){
    1461. 

  1461. 		$count_result = $adb->pquery( mkCountQuery( $query),$params);
    1462. 

  1462. 		$noofrows = $adb->query_result($count_result,0,"count");
    1463. 

  1463. 	}else{
    1464. 

  1464. 		$noofrows = null;
    1465. 

  1465. 	}
    1466. 

  1466. 	global $currentModule;
    1467. 

  1467. 	$queryMode = (isset($_REQUEST['query']) && $_REQUEST['query'] == 'true');
    1468. 

  1468. 	//$viewid is used as a key for cache query and other info so pass the dates as viewid
    1469. 

  1469. 	$viewid = $start_date.$end_date;
    1470. 

  1470. 	$start = ListViewSession::getRequestCurrentPage($currentModule, $adb->convert2sql($query,
    1471. 

  1471. 			$params), $viewid, $queryMode);
    1472. 

  1472. 

  1473. 	$navigation_array = VT_getSimpleNavigationValues($start,$list_max_entries_per_page,$noofrows);
    1474. 

  1474. 

  1475. 	//end
    1476. 

  1476. 

  1477. 	$start_rec = ($start-1) * $list_max_entries_per_page;
    1478. 

  1478. 	$end_rec = $navigation_array['end_val'];
    1479. 

  1479.         //print_r($navigation_array);die();
    1480. 

  1480.         //echo $end_rec.'val';
    1481. 

  1481. 	
    1482. 

  1482.         $list_query = $adb->convert2Sql($query, $params);
    1483. 

  1483. 	$_SESSION['Calendar_listquery'] = $list_query;
    1484. 

  1484.         
    1485. 

  1485.     if($start_rec < 0)
    1486. 

  1486. 		$start_rec = 0;
    1487. 

  1487. 	$query .= $group_cond." limit $list_max_entries_per_page offset $start_rec ";
    1488. 

  1488. 

  1489.  	//if( $adb->dbType == "pgsql"){
    1490. 

  1490.  	//    $query = fixPostgresQuery($query, $log, 0);
    1491. 

  1491.  	//}
    1492. 

  1492. 

  1493. 	
    1494. 

  1494.         
    1495. 

  1495. 	$result = $adb->pquery($query, $params);
    1496. 

  1496. 	$rows = $adb->num_rows($result);
    1497. 

  1497. 	$c = 0;
    1498. 

  1498. 	if($start > 1)
    1499. 

  1499. 		$c = ($start-1) * $list_max_entries_per_page;
    1500. 

  1500. 	for($i=0;$i<$rows;$i++)
    1501. 

  1501. 	{
    1502. 

  1502. 		$element = Array();
    1503. 

  1503. 		$element['no'] = $c+1;
    1504. 

  1504. 		$image_tag = "";
    1505. 

  1505. 		$contact_data = "";
    1506. 

  1506. 		$more_link = "";
    1507. 

  1507. 		$start_time = $adb->query_result($result,$i,"time_start");
    1508. 

  1508. 		$end_time = $adb->query_result($result,$i,"time_end");
    1509. 

  1509. 		$date_start = $adb->query_result($result,$i,"date_start");
    1510. 

  1510. 		$due_date = $adb->query_result($result,$i,"due_date");
    1511. 

  1511. 		$date = new DateTimeField($date_start.' '.$start_time);
    1512. 

  1512. 		$endDate = new DateTimeField($due_date.' '.$end_time);
    1513. 

  1513. 		if(!empty($start_time)){
    1514. 

  1514. 			$start_time = $date->getDisplayTime();
    1515. 

  1515. 		}
    1516. 

  1516. 		if(!empty($end_time)){
    1517. 

  1517. 			$end_time = $endDate->getDisplayTime();
    1518. 

  1518. 		}
    1519. 

  1519. 		$format = $calendar['calendar']->hour_format;
    1520. 

  1520. 		$value = getaddEventPopupTime($start_time,$end_time,$format);
    1521. 

  1521. 		$start_hour = $value['starthour'].':'.$value['startmin'].''.$value['startfmt'];
    1522. 

  1522. 		$end_hour = $value['endhour'] .':'.$value['endmin'].''.$value['endfmt'];
    1523. 

  1523. 		$element['starttime'] = $date->getDisplayDate().' '.$start_hour;
    1524. 

  1524. 		$element['endtime'] = $endDate->getDisplayDate().' '.$end_hour;
    1525. 

  1525. 		$contact_id = $adb->query_result($result,$i,"contactid");
    1526. 

  1526. 		$id = $adb->query_result($result,$i,"activityid");
    1527. 

  1527. 		$subject = $adb->query_result($result,$i,"subject");
    1528. 

  1528. 		$eventstatus = $adb->query_result($result,$i,"eventstatus");
    1529. 

  1529. 		$assignedto = $adb->query_result($result,$i,"user_name");
    1530. 

  1530. 		$userid = $adb->query_result($result,$i,"smownerid");
    1531. 

  1531. 		$idShared = "normal";
    1532. 

  1532. 		if(!empty($assignedto) && $userid != $current_user->id && $adb->query_result($result,$i,"visibility") == "Public")
    1533. 

  1533. 		{
    1534. 

  1534. 			$que = "select * from vtiger_sharedcalendar where sharedid=? and userid=?";
    1535. 

  1535. 			$row = $adb->pquery($que, array($current_user->id, $userid));
    1536. 

  1536. 			$no = $adb->getRowCount($row);
    1537. 

  1537. 			if($no > 0) $idShared = "shared";
    1538. 

  1538. 			else  $idShared = "normal";
    1539. 

  1539. 				
    1540. 

  1540. 

  1541. 		}
    1542. 

  1542.                 if($listview_max_textlength && (strlen($subject)>$listview_max_textlength))
    1543. 

  1543. 	                $subject = substr($subject,0,$listview_max_textlength)."...";
    1544. 

  1544. 		if($contact_id != '')
    1545. 

  1545. 		{
    1546. 

  1546. 			$displayValueArray = getEntityName('Contacts', $contact_id);
    1547. 

  1547. 			if (!empty($displayValueArray)) {
    1548. 

  1548. 				foreach ($displayValueArray as $key => $field_value) {
    1549. 

  1549. 					$contactname = $field_value;
    1550. 

  1550. 				}
    1551. 

  1551. 			}
    1552. 

  1552. 			$contact_data = "<b>".$contactname."</b>,";
    1553. 

  1553. 		}
    1554. 

  1554. 		$more_link = "<a href='index.php?action=DetailView&module=Calendar&record=".$id."&activity_mode=Events&viewtype=calendar&parenttab=".$category."' class='webMnu'>[".$mod_strings['LBL_MORE']."...]</a>";
    1555. 

  1555. 		$type = $adb->query_result($result,$i,"activitytype");
    1556. 

  1556. 		if($type == 'Call')
    1557. 

  1557. 			$image_tag = "<img src='" . vtiger_imageurl('Calls.gif', $theme). "' align='middle'>&nbsp;".$app_strings['Call'];
    1558. 

  1558. 		else if($type == 'Meeting')
    1559. 

  1559. 			$image_tag = "<img src='" . vtiger_imageurl('Meetings.gif', $theme). "' align='middle'>&nbsp;".$app_strings['Meeting'];
    1560. 

  1560. 		else
    1561. 

  1561. 			$image_tag = "&nbsp;".getTranslatedString($type);
    1562. 

  1562.         	$element['eventtype'] = $image_tag;
    1563. 

  1563. 		$element['eventdetail'] = $contact_data." ".$subject."&nbsp;".$more_link;
    1564. 

  1564. 		/*if(getFieldVisibilityPermission('Events',$current_user->id,'parent_id') == '0')
    1565. 

  1565. 		{
    1566. 

  1566. 			$element['relatedto']= getRelatedTo('Calendar',$result,$i);
    1567. 

  1567. 		}*/
    1568. 

  1568. 		if($idShared == "normal")
    1569. 

  1569. 		{
    1570. 

  1570. 			if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete")=="yes")
    1571. 

  1571. 				$element['action'] ="<img onClick='getcalAction(this,\"eventcalAction\",".$id.",\"".$calendar['view']."\",\"".$calendar['calendar']->date_time->hour."\",\"".$calendar['calendar']->date_time->get_DB_formatted_date()."\",\"event\");' src='" . vtiger_imageurl('cal_event.jpg', $theme). "' border='0'>";
    1572. 

  1572. 		}
    1573. 

  1573. 		else
    1574. 

  1574. 		{
    1575. 

  1575. 			if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete")=="yes")
    1576. 

  1576. 				$element['action']="<img onClick=\"alert('".$mod_strings["SHARED_EVENT_DEL_MSG"]."')\"; src='" . vtiger_imageurl('cal_event.jpg', $theme). "' border='0'>";
    1577. 

  1577. 		}
    1578. 

  1578. 		if(getFieldVisibilityPermission('Events',$current_user->id,'eventstatus') == '0')
    1579. 

  1579. 		{
    1580. 

  1580. 			if(!$is_admin && $eventstatus != '')
    1581. 

  1581. 			{
    1582. 

  1582. 				$roleid=$current_user->roleid;
    1583. 

  1583. 				$roleids = Array();
    1584. 

  1584. 				$subrole = getRoleSubordinates($roleid);
    1585. 

  1585. 				if(count($subrole)> 0)
    1586. 

  1586. 				$roleids = $subrole;
    1587. 

  1587. 				array_push($roleids, $roleid);
    1588. 

  1588. 

  1589. 				//here we are checking wheather the table contains the sortorder column .If  sortorder is present in the main picklist table, then the role2picklist will be applicable for this table...
    1590. 

  1590. 

  1591. 				$sql="select * from vtiger_eventstatus where eventstatus=?";
    1592. 

  1592. 				$res = $adb->pquery($sql,array(decode_html($eventstatus)));
    1593. 

  1593. 				$picklistvalueid = $adb->query_result($res,0,'picklist_valueid');
    1594. 

  1594. 				if ($picklistvalueid != null) {
    1595. 

  1595. 					$pick_query="select * from vtiger_role2picklist where picklistvalueid=$picklistvalueid and roleid in (". generateQuestionMarks($roleids) .")";
    1596. 

  1596. 					$res_val=$adb->pquery($pick_query,array($roleids));
    1597. 

  1597. 					$num_val = $adb->num_rows($res_val);
    1598. 

  1598. 				}
    1599. 

  1599. 				if($num_val > 0)
    1600. 

  1600. 				$element['status'] = getTranslatedString(decode_html($eventstatus));
    1601. 

  1601. 				else
    1602. 

  1602. 				$element['status'] = "<font color='red'>".$app_strings['LBL_NOT_ACCESSIBLE']."</font>";
    1603. 

  1603. 

  1604. 

  1605. 			}else
    1606. 

  1606. 			$element['status'] = getTranslatedString(decode_html($eventstatus));
    1607. 

  1607. 		}
    1608. 

  1608. 		if(!empty($assignedto))
    1609. 

  1609. 			$element['assignedto'] = $assignedto;
    1610. 

  1610. 		else
    1611. 

  1611. 			$element['assignedto'] = $adb->query_result($result,$i,"groupname");
    1612. 

  1612. 		$element['visibility'] = $adb->query_result($result,$i,"visibility");
    1613. 

  1613. 		$c++;
    1614. 

  1614. 		$Entries[] = $element;
    1615. 

  1615. 	}
    1616. 

  1616. 	$ret_arr[0] = $Entries;
    1617. 

  1617.         $ret_arr[1] = $navigation_array;
    1618. 

  1618. 	$cal_log->debug("Exiting getEventList() method...");
    1619. 

  1619. 	return $ret_arr;
    1620. 

  1620. }
    1621. 

  1621. 

  1622. /**
    1623. 

  1623.  * Function to get todos list scheduled between specified dates
    1624. 

  1624.  * @param array   $calendar              -  collection of objects and strings
    1625. 

  1625.  * @param string  $start_date            -  date string
    1626. 

  1626.  * @param string  $end_date              -  date string
    1627. 

  1627.  * @param string  $info                  -  string 'listcnt' or empty string. if 'listcnt' means it returns no. of todos and no. of pending todos in array format else it returns todos list in array format
    1628. 

  1628.  * return array   $Entries               -  todolists in array format
    1629. 

  1629.  */
    1630. 

  1630. function getTodoList(& $calendar,$start_date,$end_date,$info='')
    1631. 

  1631. {
    1632. 

  1632. 	global $log,$app_strings,$theme;
    1633. 

  1633.         $Entries = Array();
    1634. 

  1634. 	$category = getParentTab();
    1635. 

  1635. 	global $adb,$current_user,$mod_strings,$cal_log,$list_max_entries_per_page;
    1636. 

  1636. 	$cal_log->debug("Entering getTodoList() method...");
    1637. 

  1637. 	require('user_privileges/user_privileges_'.$current_user->id.'.php');
    1638. 

  1638. 	require('user_privileges/sharing_privileges_'.$current_user->id.'.php');
    1639. 

  1639. 

  1640. 	$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>
    1641. 

  1641. 							'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
    1642. 

  1642.    $query = "SELECT vtiger_groups.groupname, $userNameSql as user_name, vtiger_crmentity.crmid, vtiger_cntactivityrel.contactid,
    1643. 

  1643. 				vtiger_activity.* FROM vtiger_activity
    1644. 

  1644.                 INNER JOIN vtiger_crmentity
    1645. 

  1645. 					ON vtiger_crmentity.crmid = vtiger_activity.activityid
    1646. 

  1646.                 LEFT JOIN vtiger_cntactivityrel
    1647. 

  1647. 					ON vtiger_cntactivityrel.activityid = vtiger_activity.activityid
    1648. 

  1648. 				LEFT JOIN vtiger_groups
    1649. 

  1649. 					ON vtiger_groups.groupid = vtiger_crmentity.smownerid
    1650. 

  1650. 				LEFT JOIN vtiger_users
    1651. 

  1651. 					ON vtiger_users.id = vtiger_crmentity.smownerid";
    1652. 

  1652. 	$query .= getNonAdminAccessControlQuery('Calendar',$current_user);
    1653. 

  1653. 	$query .= "WHERE vtiger_crmentity.deleted = 0 AND vtiger_activity.activitytype = 'Task'".
    1654. 

  1654. 					" AND ((to_timestamp(date_start || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') >= ? AND to_timestamp(date_start || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') <= ?)
    1655. 

  1655. 							OR	(to_timestamp(due_date || ' ' || time_end, 'YYYY-MM-DD HH24:MI:SS') >= ? AND to_timestamp(due_date || ' ' || time_end, 'YYYY-MM-DD HH24:MI:SS') <= ? )
    1656. 

  1656. 							OR	(to_timestamp(date_start || ' ' || time_start, 'YYYY-MM-DD HH24:MI:SS') <= ? AND to_timestamp(due_date || ' ' || time_end, 'YYYY-MM-DD HH24:MI:SS') >= ?)
    1657. 

  1657. 						)";
    1658. 

    1659. 

  1659. 	$list_query = $query." AND vtiger_crmentity.smownerid = "  . $current_user->id;
    1660. 

  1660. 

  1661. 	$startDate = new DateTimeField($start_date.' 00:00');
    1662. 

  1662. 	$endDate = new DateTimeField($end_date. ' 23:59');
    1663. 

  1663. 	$params = $info_params = array($startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1664. 

  1664. 									$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue(),
    1665. 

  1665. 									$startDate->getDBInsertDateTimeValue(), $endDate->getDBInsertDateTimeValue());
    1666. 

  1666. 	
    1667. 

  1667.         if($info != '')
    1668. 

  1668. 		{
    1669. 

  1669. 			//added to fix #4816
    1670. 

  1670. 			$groupids = explode(",", fetchUserGroupids($current_user->id));
    1671. 

  1671. 			if (count($groupids) > 0 && !is_admin($current_user)) {
    1672. 

  1672. 				$com_q = " AND (vtiger_crmentity.smownerid = ?
    1673. 

  1673. 					OR vtiger_groups.groupid in (". generateQuestionMarks($groupids) ."))";
    1674. 

  1674. 				array_push($info_params, $current_user->id);
    1675. 

  1675. 				array_push($info_params, $groupids);
    1676. 

  1676. 			} elseif(!is_admin($current_user)) {			
    1677. 

  1677. 				$com_q = " AND vtiger_crmentity.smownerid = ?";
    1678. 

  1678. 				array_push($info_params, $current_user->id);
    1679. 

  1679. 			}
    1680. 

  1680. 			//end
    1681. 

  1681. 

  1682. 			$pending_query = $query." AND (vtiger_activity.status != 'Completed')".$com_q;
    1683. 

  1683. 			$total_q =  $query."".$com_q;
    1684. 

  1684. 			 //if( $adb->dbType == "pgsql")
    1685. 

  1685. 			 //{
    1686. 

  1686.  		     // 	$pending_query = fixPostgresQuery( $pending_query, $log, 0);
    1687. 

  1687. 		     // 	$total_q = fixPostgresQuery( $total_q, $log, 0);
    1688. 

  1688. 			//}
    1689. 

  1689. 			$total_res = $adb->pquery($total_q, $info_params);
    1690. 

  1690. 			$total = $adb->num_rows($total_res);
    1691. 

  1691.                 
    1692. 

  1692. 			$res = $adb->pquery($pending_query, $info_params);
    1693. 

  1693. 		        $pending_rows = $adb->num_rows($res);
    1694. 

  1694. 		
    1695. 

  1695. 			$cal_log->debug("Exiting getTodoList() method...");
    1696. 

  1696. 			return Array('totaltodo'=>$total,'pendingtodo'=>$pending_rows);
    1697. 

  1697.         }
    1698. 

  1698. 	
    1699. 

  1699. 	$group_cond = '';
    1700. 

  1700. 	$group_cond .= " ORDER BY vtiger_activity.date_start,vtiger_activity.time_start ASC";
    1701. 

  1701. 	if(isset($_REQUEST['start']) && $_REQUEST['start'] != '')
    1702. 

  1702. 		$start = vtlib_purify($_REQUEST['start']);
    1703. 

  1703. 	else 
    1704. 

  1704. 		$start = 1;
    1705. 

  1705. 

  1706. //T6477 changes
    1707. 

  1707. 	if(PerformancePrefs::getBoolean('LISTVIEW_COMPUTE_PAGE_COUNT', false) === true){
    1708. 

  1708. 		$count_res = $adb->pquery(mkCountQuery($query), $params);
    1709. 

  1709.    		$total_rec_count = $adb->query_result($count_res,0,'count');
    1710. 

  1710. 	}else{
    1711. 

  1711. 		$total_rec_count = null;
    1712. 

  1712. 	}
    1713. 

  1713. 

  1714. 	$navigation_array = VT_getSimpleNavigationValues($start,$list_max_entries_per_page,$total_rec_count);
    1715. 

  1715. 

  1716. 	$start_rec = ($start-1) * $list_max_entries_per_page;
    1717. 

  1717. 	$end_rec = $navigation_array['end_val'];
    1718. 

  1718.         
    1719. 

  1719.         $list_query = $adb->convert2Sql($query, $params);
    1720. 

  1720. 	$_SESSION['Calendar_listquery'] = $list_query;
    1721. 

  1721. 

  1722. 	if($start_rec < 0)
    1723. 

  1723. 		$start_rec = 0;
    1724. 

  1724. 

  1725. 	//ends
    1726. 

  1726. 	$query .= $group_cond." offset $start_rec limit $list_max_entries_per_page";
    1727. 

  1727. 

  1728. 	//if( $adb->dbType == "pgsql"){
    1729. 

  1729.  	//    $query = fixPostgresQuery( $query, $log, 0);
    1730. 

  1730. 	//}
    1731. 

  1731. 

  1732.     $result = $adb->pquery($query, $params);
    1733. 

  1733.     $rows = $adb->num_rows($result);
    1734. 

  1734. 	$c=0;
    1735. 

  1735. 	if($start > 1)
    1736. 

  1736. 		$c = ($start-1) * $list_max_entries_per_page;
    1737. 

  1737. 	for($i=0;$i<$rows;$i++)
    1738. 

  1738.         {
    1739. 

  1739. 		
    1740. 

  1740.                 $element = Array();
    1741. 

  1741. 		$contact_name = '';
    1742. 

  1742.                 $element['no'] = $c+1;
    1743. 

  1743.                 $more_link = "";
    1744. 

  1744.                 $start_time = $adb->query_result($result,$i,"time_start");
    1745. 

  1745. 				$date_start = $adb->query_result($result,$i,"date_start");
    1746. 

  1746. 				$due_date = $adb->query_result($result,$i,"due_date");
    1747. 

  1747. 				$date = new DateTimeField($date_start.' '.$start_time);
    1748. 

  1748. 				$endDate = new DateTimeField($due_date);
    1749. 

  1749. 				if(!empty($start_time)){
    1750. 

  1750. 					$start_time = $date->getDisplayTime();
    1751. 

  1751. 				}
    1752. 

  1752.                 $format = $calendar['calendar']->hour_format;
    1753. 

  1753. 				$value = getaddEventPopupTime($start_time,$start_time,$format);
    1754. 

  1754.                 $element['starttime'] = $value['starthour'].':'.$value['startmin'].''.$value['startfmt'];
    1755. 

  1755. 				$element['startdate'] = $date->getDisplayDate();
    1756. 

  1756. 				$element['duedate'] = $endDate->getDisplayDate();
    1757. 

  1757. 

  1758.                 $id = $adb->query_result($result,$i,"activityid");
    1759. 

  1759.                 $subject = $adb->query_result($result,$i,"subject");
    1760. 

  1760. 		$more_link = "<a href='index.php?action=DetailView&module=Calendar&record=".$id."&activity_mode=Task&viewtype=calendar&parenttab=".$category."' class='webMnu'>".$subject."</a>";
    1761. 

  1761. 		$element['tododetail'] = $more_link;
    1762. 

  1762. 		if(getFieldVisibilityPermission('Calendar',$current_user->id,'taskstatus') == '0')
    1763. 

  1763. 		{
    1764. 

  1764. 			$taskstatus = $adb->query_result($result,$i,"status");
    1765. 

  1765. 

  1766. 			if(!$is_admin && $taskstatus != '')
    1767. 

  1767. 			{
    1768. 

  1768. 				$roleid=$current_user->roleid;
    1769. 

  1769. 				$roleids = Array();
    1770. 

  1770. 				$subrole = getRoleSubordinates($roleid);
    1771. 

  1771. 				if(count($subrole)> 0)
    1772. 

  1772. 				$roleids = $subrole;
    1773. 

  1773. 				array_push($roleids, $roleid);
    1774. 

  1774. 

  1775. 				//here we are checking wheather the table contains the sortorder column .If  sortorder is present in the main picklist table, then the role2picklist will be applicable for this table...
    1776. 

  1776. 

  1777. 				$sql="select * from vtiger_taskstatus where taskstatus=?";
    1778. 

  1778. 				$res = $adb->pquery($sql,array(decode_html($taskstatus)));
    1779. 

  1779. 				$picklistvalueid = $adb->query_result($res,0,'picklist_valueid');
    1780. 

  1780. 				if ($picklistvalueid != null) {
    1781. 

  1781. 					$pick_query="select * from vtiger_role2picklist where picklistvalueid=$picklistvalueid and roleid in (". generateQuestionMarks($roleids) .")";
    1782. 

  1782. 					$res_val=$adb->pquery($pick_query,array($roleids));
    1783. 

  1783. 					$num_val = $adb->num_rows($res_val);
    1784. 

  1784. 				}
    1785. 

  1785. 				if($num_val > 0)
    1786. 

  1786. 				$element['status'] = getTranslatedString(decode_html($taskstatus));
    1787. 

  1787. 				else
    1788. 

  1788. 				$element['status'] = "<font color='red'>".$app_strings['LBL_NOT_ACCESSIBLE']."</font>";
    1789. 

  1789. 

  1790. 

  1791. 			}else
    1792. 

  1792. 			$element['status'] = getTranslatedString(decode_html($taskstatus));
    1793. 

  1793. 			
    1794. 

  1794. 			
    1795. 

  1795. 		}
    1796. 

  1796. 		if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete") == "yes")
    1797. 

  1797. 			$element['action'] ="<img onClick='getcalAction(this,\"taskcalAction\",".$id.",\"".$calendar['view']."\",\"".$calendar['calendar']->date_time->hour."\",\"".$calendar['calendar']->date_time->get_DB_formatted_date()."\",\"todo\");' src='" . vtiger_imageurl('cal_event.jpg', $theme). "' border='0'>";
    1798. 

  1798. 		$assignedto = $adb->query_result($result,$i,"user_name");
    1799. 

  1799. 		if(!empty($assignedto))
    1800. 

  1800. 			$element['assignedto'] = $assignedto;
    1801. 

  1801. 		else
    1802. 

  1802. 			$element['assignedto'] = $adb->query_result($result,$i,"groupname");
    1803. 

  1803. 		$c++;
    1804. 

  1804. 		$Entries[] = $element;
    1805. 

  1805. 	}
    1806. 

  1806. 	$ret_arr[0] = $Entries;
    1807. 

  1807.         $ret_arr[1] = $navigation_array;
    1808. 

  1808. 	$cal_log->debug("Exiting getTodoList() method...");
    1809. 

  1809. 	return $ret_arr;
    1810. 

  1810. }
    1811. 

  1811. 

  1812. /**
    1813. 

  1813.  * Function to get number of Events and Todos Info
    1814. 

  1814.  * @param array    $cal              - collection of objects and strings 
    1815. 

  1815.  * @param string   $mode             - string 'listcnt' or may be empty. if empty means get Events/Todos ListView else get total events/todos and no. of pending events/todos Info.
    1816. 

  1816.  * return array    $event_todo_info  - collection of events/todos info.
    1817. 

  1817.  */
    1818. 

  1818. function getEventInfo(& $cal, $mode)
    1819. 

  1819. {
    1820. 

  1820. 	global $mod_strings,$cal_log;
    1821. 

  1821. 	$cal_log->debug("Entering getEventInfo() method...");
    1822. 

  1822. 	$event = Array();
    1823. 

  1823. 	$event['event']=getEventListView($cal, $mode);
    1824. 

  1824. 	$event_info = "";
    1825. 

  1825. 	$event_info .= $mod_strings['LBL_TOTALEVENTS']."&nbsp;".$event['event']['totalevent'];
    1826. 

  1826. 	if($event['event']['pendingevent'] != null)
    1827. 

  1827. 		 $event_info .= ", ".$event['event']['pendingevent']."&nbsp;".$mod_strings['LBL_PENDING'];
    1828. 

  1828. 	$cal_log->debug("Exiting getEventInfo() method...");
    1829. 

  1829. 	
    1830. 

  1830. 	return $event_info;
    1831. 

  1831. }
    1832. 

  1832. 

  1833. function getTodoInfo(& $cal, $mode)
    1834. 

  1834. {
    1835. 

  1835.         global $mod_strings,$cal_log;
    1836. 

  1836.         $cal_log->debug("Entering getTodoInfo() method...");
    1837. 

  1837.         $todo = Array();
    1838. 

  1838.         $todo['todo'] = getTodosListView($cal, $mode);
    1839. 

  1839.         $todo_info = "";
    1840. 

  1840.         $todo_info .=$mod_strings['LBL_TOTALTODOS']."&nbsp;".$todo['todo']['totaltodo'];
    1841. 

  1841.         if($todo['todo']['pendingtodo'] != null)
    1842. 

  1842.                 $todo_info .= ", ".$todo['todo']['pendingtodo']."&nbsp;".$mod_strings['LBL_PENDING'];
    1843. 

  1843.         $cal_log->debug("Exiting getTodoInfo() method...");
    1844. 

  1844. 

  1845.         return $todo_info;
    1846. 

  1846. }
    1847. 

  1847. 

  1848. 

  1849. /**
    1850. 

  1850.  * Function creates HTML to display Events ListView
    1851. 

  1851.  * @param array  $entry_list    - collection of strings(Event Information)
    1852. 

  1852.  * return string $list_view     - html tags in string format
    1853. 

  1853.  */
    1854. 

  1854. function constructEventListView(& $cal,$entry_list,$navigation_array='')
    1855. 

  1855. {
    1856. 

  1856. 	global $mod_strings,$app_strings,$adb,$cal_log,$current_user,$theme;
    1857. 

  1857. 	$cal_log->debug("Entering constructEventListView() method...");
    1858. 

  1858. 	$format = $cal['calendar']->hour_format;
    1859. 

  1859. 	$date_format = $current_user->date_format;
    1860. 

  1860. 	$date = new DateTimeField(null);
    1861. 

  1861. 	$endDate = new DateTimeField(date("Y-m-d H:i:s", (time() +
    1862. 

  1862. 			(1 * 24 * 60 * 60))));
    1863. 

  1863. 	$hour_startat = $date->getDisplayTime();
    1864. 

  1864. 	$hour_endat = $endDate->getDisplayTime();
    1865. 

  1865. 	$time_arr = getaddEventPopupTime($hour_startat,$hour_endat,$format);
    1866. 

  1866. 	$temp_ts = $cal['calendar']->date_time->ts;
    1867. 

  1867. 	//to get date in user selected date format
    1868. 

  1868. 	$temp_date = $date->getDisplayDate();
    1869. 

  1869. 	if($cal['calendar']->day_start_hour != 23)
    1870. 

  1870. 		$endtemp_date = $temp_date;
    1871. 

  1871. 	else
    1872. 

  1872. 	{
    1873. 

  1873. 		$endtemp_date = $endDate->getDisplayDate();
    1874. 

  1874. 	}
    1875. 

  1875. 	$list_view = "";
    1876. 

  1876. 	$start_datetime = $app_strings['LBL_START_DATE_TIME'];
    1877. 

  1877. 	$end_datetime = $app_strings['LBL_END_DATE_TIME'];
    1878. 

  1878. 	//Events listview header labels
    1879. 

  1879. 	$header = Array('0'=>'#',
    1880. 

  1880.                         '1'=>$start_datetime,
    1881. 

  1881.                         '2'=>$end_datetime,
    1882. 

  1882.                         '3'=>$mod_strings['LBL_EVENTTYPE'],
    1883. 

  1883.                         '4'=>$mod_strings['LBL_EVENTDETAILS']
    1884. 

  1884. 			);
    1885. 

  1885. 	$header_width = Array('0'=>'5%',
    1886. 

  1886. 			      '1'=>'15%',
    1887. 

  1887. 			      '2'=>'15%',
    1888. 

  1888. 			      '3'=>'10%',
    1889. 

  1889. 			      '4'=>'33%'
    1890. 

  1890. 		             );
    1891. 

  1891. 	if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete") == "yes")
    1892. 

  1892. 	{
    1893. 

  1893. 		array_push($header,$mod_strings['LBL_ACTION']);
    1894. 

  1894. 		 array_push($header_width,'10%');
    1895. 

  1895. 	}
    1896. 

  1896. 	if(getFieldVisibilityPermission('Events',$current_user->id,'eventstatus') == '0')
    1897. 

  1897. 	{
    1898. 

  1898. 		array_push($header,$mod_strings['LBL_STATUS']);
    1899. 

  1899. 		array_push($header_width,'$10%');
    1900. 

  1900. 	}
    1901. 

  1901. 	array_push($header,$mod_strings['LBL_ASSINGEDTO']);
    1902. 

  1902. 	array_push($header_width,'15%');
    1903. 

  1903. 	
    1904. 

  1904.         $list_view .="<table style='background-color: rgb(204, 204, 204);' class='small' align='center' border='0' cellpadding='5' cellspacing='1' width='98%'>
    1905. 

  1905.                         <tr>";
    1906. 

  1906. 	$header_rows = count($header);
    1907. 

  1907. 

  1908. 	$navigationOutput = getTableHeaderSimpleNavigation($navigation_array, $url_string,"Calendar","index");
    1909. 

  1909. 

  1910. 	if($navigationOutput != '') {
    1911. 

  1911. 		$list_view .= "<tr width=100% bgcolor=white><td align=center colspan=$header_rows>";
    1912. 

  1912. 		$list_view .= "<table align=center width='98%'><tr>".$navigationOutput."</tr></table></td></tr>";
    1913. 

  1913. 	}
    1914. 

  1914. 	$list_view .= "<tr>";
    1915. 

  1915. 	for($i=0;$i<$header_rows;$i++) {
    1916. 

  1916. 		$list_view .="<td nowrap='nowrap' class='lvtCol' width='".$header_width[$i]."'>".$header[$i]."</td>";
    1917. 

  1917. 	}
    1918. 

  1918. 	$list_view .="</tr>";
    1919. 

  1919. 	$rows = count($entry_list);
    1920. 

  1920. 	if($rows != 0) {
    1921. 

  1921. 		$userName = getFullNameFromArray('Users', $current_user->column_fields);
    1922. 

  1922. 		
    1923. 

  1923. 		for($i=0;$i<count($entry_list);$i++) {
    1924. 

  1924. 			$list_view .="<tr class='lvtColData' onmouseover='this.className=\"lvtColDataHover\"' onmouseout='this.className=\"lvtColData\"' bgcolor='white'>";
    1925. 

  1925. 

  1926. 			$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>
    1927. 

  1927. 							'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
    1928. 

  1928. 			$assigned_role_query=$adb->pquery("select vtiger_user2role.roleid,vtiger_user2role.userid
    1929. 

  1929. 												from vtiger_user2role
    1930. 

  1930. 												INNER JOIN vtiger_users ON vtiger_users.id=vtiger_user2role.userid
    1931. 

  1931. 												WHERE $userNameSql=?",
    1932. 

  1932. 												array($entry_list[$i]['assignedto']));
    1933. 

  1933. 			$assigned_user_role_id = $adb->query_result($assigned_role_query,0,"roleid");
    1934. 

  1934. 			$assigned_user_id = $adb->query_result($assigned_role_query,0,"userid");
    1935. 

  1935. 			$role_list = $adb->pquery("SELECT * from vtiger_role WHERE parentrole LIKE '". formatForSqlLike($current_user->column_fields['roleid']) . formatForSqlLike($assigned_user_role_id) ."'",array());
    1936. 

  1936. 			$is_shared = $adb->pquery("SELECT * from vtiger_sharedcalendar where userid=? and sharedid=?",array($assigned_user_id,$current_user->id));
    1937. 

  1937. 

  1938. 			foreach($entry_list[$i] as $key=>$entry) {
    1939. 

  1939. 				if($key!='visibility') {
    1940. 

  1940. 					if(($key=='eventdetail'|| $key=='action') 
    1941. 

  1941. 						&& ($current_user->column_fields['is_admin']!='on'
    1942. 

  1942. 								&& $adb->num_rows($role_list)==0
    1943. 

  1943. 								&& ($adb->num_rows($is_shared)==0  || $entry_list[$i]['visibility']=='Private'))
    1944. 

  1944. 						&& $userName!=$entry_list[$i]['assignedto']) {
    1945. 

  1945. 						
    1946. 

  1946. 						if($key=='eventdetail')
    1947. 

  1947. 							$list_view .="<td nowrap='nowrap'><font color='red'><b>".$entry_list[$i]['assignedto']." - ".$mod_strings['LBL_BUSY']."</b></font></td>";
    1948. 

  1948. 						else
    1949. 

  1949. 							$list_view .="<td nowrap='nowrap'><font color='red'>".$app_strings['LBL_NOT_ACCESSIBLE']."</font></td>";
    1950. 

  1950. 					}else
    1951. 

  1951. 						$list_view .="<td nowrap='nowrap'>$entry</td>";
    1952. 

  1952. 				}
    1953. 

  1953. 			}
    1954. 

  1954. 			$list_view .="</tr>";
    1955. 

  1955. 		}
    1956. 

  1956. 	}
    1957. 

  1957. 	else
    1958. 

  1958. 	{
    1959. 

  1959. 		$list_view .="<tr><td style='background-color:#efefef;height:340px' align='center' colspan='9'>
    1960. 

  1960. 				";
    1961. 

  1961. 			$list_view .="<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 45%; position: relative; z-index: 5000;'>
    1962. 

  1962. 					<table border='0' cellpadding='5' cellspacing='0' width='98%'>
    1963. 

  1963. 						<tr>
    1964. 

  1964. 							<td rowspan='2' width='25%'>
    1965. 

  1965. 								<img src='" . vtiger_imageurl('empty.jpg', $theme). "' height='60' width='61'></td>
    1966. 

  1966. 							<td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='75%'><span class='genHeaderSmall'>".$app_strings['LBL_NO']." ".$app_strings['Events']." ".$app_strings['LBL_FOUND']." !</span></td>
    1967. 

  1967. 						</tr>
    1968. 

  1968. 						<tr>";
    1969. 

  1969. 			//checking permission for Create/Edit Operation
    1970. 

  1970. 			if(isPermitted("Calendar","EditView") == "yes")
    1971. 

  1971.                         {
    1972. 

  1972.                                 $list_view .="<td class='small' align='left' nowrap='nowrap'>".$app_strings['LBL_YOU_CAN_CREATE']."&nbsp;".$app_strings['LBL_AN']."&nbsp;".$app_strings['Event']."&nbsp;".$app_strings['LBL_NOW'].".&nbsp;".$app_strings['LBL_CLICK_THE_LINK'].":<br>
    1973. 

  1973. 					&nbsp;&nbsp;-<a href='javascript:void(0);' onClick='gshow(\"addEvent\",\"Call\",\"".$temp_date."\",\"".$endtemp_date."\",\"".$time_arr['starthour']."\",\"".$time_arr['startmin']."\",\"".$time_arr['startfmt']."\",\"".$time_arr['endhour']."\",\"".$time_arr['endmin']."\",\"".$time_arr['endfmt']."\",\"listview\",\"event\");'>".$app_strings['LBL_CREATE']."&nbsp;".$app_strings['LBL_AN']."&nbsp;".$app_strings['Event']."</a><br>
    1974. 

  1974. 					</td>";
    1975. 

  1975. 			}
    1976. 

  1976. 			else
    1977. 

  1977. 			{
    1978. 

  1978. 				$list_view .="<td class='small' align='left' nowrap='nowrap'>".$app_strings['LBL_YOU_ARE_NOT_ALLOWED_TO_CREATE']."&nbsp;".$app_strings['LBL_AN']."&nbsp;".$app_strings['Event']."<br></td>";
    1979. 

  1979. 			}
    1980. 

  1980. 			$list_view .="</tr>
    1981. 

  1981.                                         </table>
    1982. 

  1982. 				</div>";
    1983. 

  1983. 			$list_view .="</td></tr>";			
    1984. 

  1984. 	}
    1985. 

  1985. 	$list_view .="</table>";
    1986. 

  1986. 	$cal_log->debug("Exiting constructEventListView() method...");
    1987. 

  1987. 	return $list_view;
    1988. 

  1988. }
    1989. 

  1989. 

  1990. /**
    1991. 

  1991.  * Function creates HTML to display Todos ListView
    1992. 

  1992.  * @param array  $todo_list     - collection of strings(Todo Information)
    1993. 

  1993.  * @param array  $cal           - collection of objects and strings 
    1994. 

  1994.  * return string $list_view     - html tags in string format
    1995. 

  1995.  */
    1996. 

  1996. function constructTodoListView($todo_list,$cal,$subtab,$navigation_array='')
    1997. 

  1997. {
    1998. 

  1998. 	global $mod_strings,$cal_log,$adb,$theme;
    1999. 

  1999. 	$cal_log->debug("Entering constructTodoListView() method...");
    2000. 

  2000.         global $current_user,$app_strings;
    2001. 

  2001.         $date_format = $current_user->date_format;
    2002. 

  2002.         $format = $cal['calendar']->hour_format;
    2003. 

  2003. 		$date = new DateTimeField(null);
    2004. 

  2004. 		$endDate = new DateTimeField(date("Y-m-d H:i:s", (time() +
    2005. 

  2005. 				(1 * 24 * 60 * 60))));
    2006. 

  2006. 		$hour_startat = $date->getDisplayTime();
    2007. 

  2007. 		$hour_endat = $endDate->getDisplayTime();
    2008. 

  2008. 		
    2009. 

  2009.         $time_arr = getaddEventPopupTime($hour_startat,$hour_endat,$format);
    2010. 

  2010.         //to get date in user selected date format
    2011. 

  2011.         $temp_date = $date->getDisplayDate();
    2012. 

  2012. 		if($cal['calendar']->day_start_hour != 23)
    2013. 

  2013. 			$endtemp_date = $temp_date;
    2014. 

  2014. 		else {
    2015. 

  2015. 			$endtemp_date = $endDate->getDisplayDate();
    2016. 

  2016. 		}
    2017. 

  2017.         $list_view = "";
    2018. 

  2018. 	//labels of listview header
    2019. 

  2019. 	if($cal['view'] == 'day')
    2020. 

  2020. 	{
    2021. 

  2021. 		$colspan = 9;
    2022. 

  2022. 		$header = Array('0'=>'#','1'=>$mod_strings['LBL_TIME'],
    2023. 

  2023. 								'2'=>$mod_strings['LBL_START_DATE'],
    2024. 

  2024. 								'3'=>$mod_strings['LBL_DUE_DATE'],
    2025. 

  2025. 								'4'=>$mod_strings['LBL_TODO']);
    2026. 

  2026. 		$header_width = Array('0'=>'5%','1'=>'10%','2'=>'10%','3'=>'38%',);
    2027. 

  2027. 		if(getFieldVisibilityPermission('Calendar',$current_user->id,'taskstatus') == '0')
    2028. 

  2028. 		{
    2029. 

  2029. 			array_push($header,$mod_strings['LBL_STATUS']);
    2030. 

  2030. 			array_push($header_width,'10%');
    2031. 

  2031. 		}
    2032. 

  2032. 

  2033. 		if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete") == "yes")
    2034. 

  2034. 		{
    2035. 

  2035. 			array_push($header,$mod_strings['LBL_ACTION']);
    2036. 

  2036. 			array_push($header_width,'10%');
    2037. 

  2037. 		}
    2038. 

  2038. 		array_push($header,$mod_strings['LBL_ASSINGEDTO']);
    2039. 

  2039. 		array_push($header_width,'15%');
    2040. 

  2040. 	}
    2041. 

  2041. 	else
    2042. 

  2042. 	{
    2043. 

  2043. 		$colspan = 10;
    2044. 

  2044. 	        $header = Array('0'=>'#',
    2045. 

  2045.                         '1'=>$mod_strings['LBL_TIME'],
    2046. 

  2046. 						'2'=>$mod_strings['LBL_START_DATE'],
    2047. 

  2047. 						'3'=>$mod_strings['LBL_DUE_DATE'],
    2048. 

  2048.                         '4'=>$mod_strings['LBL_TODO']
    2049. 

  2049. 			);
    2050. 

  2050. 		$header_width = Array('0'=>'5%',
    2051. 

  2051. 			'1'=>'10%',
    2052. 

  2052. 			'2'=>'10%',
    2053. 

  2053. 			'3'=>'10%',
    2054. 

  2054. 			'4'=>'28%'
    2055. 

  2055. 			);
    2056. 

  2056. 		if(getFieldVisibilityPermission('Calendar',$current_user->id,'taskstatus') == '0')
    2057. 

  2057. 		{
    2058. 

  2058. 			array_push($header,$mod_strings['LBL_STATUS']);
    2059. 

  2059. 			array_push($header_width,'10%');
    2060. 

  2060. 		}
    2061. 

  2061. 		if(isPermitted("Calendar","EditView") == "yes" || isPermitted("Calendar","Delete") == "yes")
    2062. 

  2062. 		{
    2063. 

  2063. 			array_push($header,$mod_strings['LBL_ACTION']);
    2064. 

  2064. 		}
    2065. 

  2065. 		array_push($header,$mod_strings['LBL_ASSINGEDTO']);
    2066. 

  2066. 		array_push($header_width,'15%');
    2067. 

  2067. 		
    2068. 

  2068. 	}
    2069. 

  2069. 	if($current_user->column_fields['is_admin']=='on')
    2070. 

  2070. 		$Res = $adb->pquery("select * from vtiger_activitytype",array());
    2071. 

  2071. 	else
    2072. 

  2072. 	{
    2073. 

  2073. 		$roleid=$current_user->roleid;
    2074. 

  2074. 		$subrole = getRoleSubordinates($roleid);
    2075. 

  2075. 		if(count($subrole)> 0)
    2076. 

  2076. 		{
    2077. 

  2077. 			$roleids = $subrole;
    2078. 

  2078. 			array_push($roleids, $roleid);
    2079. 

  2079. 		}
    2080. 

  2080. 		else
    2081. 

  2081. 		{	
    2082. 

  2082. 			$roleids = $roleid;
    2083. 

  2083. 		}
    2084. 

  2084. 

  2085. 		if (count($roleids) > 1) {
    2086. 

  2086. 			$Res=$adb->pquery("select distinct activitytype from  vtiger_activitytype inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_activitytype.picklist_valueid where roleid in (". generateQuestionMarks($roleids) .") and picklistid in (select picklistid from vtiger_activitytype) order by sortid asc",array($roleids));
    2087. 

  2087. 		} else {
    2088. 

  2088. 			$Res=$adb->pquery("select distinct activitytype from vtiger_activitytype inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_activitytype.picklist_valueid where roleid = ? and picklistid in (select picklistid from vtiger_activitytype) order by sortid asc",array($roleid));
    2089. 

  2089. 		}
    2090. 

  2090. 	}
    2091. 

  2091. 	$eventlist='';
    2092. 

  2092. 	for($i=0; $i<$adb->num_rows($Res);$i++)
    2093. 

  2093. 	{
    2094. 

  2094. 		$eventlist .= $adb->query_result($Res,$i,'activitytype').";";
    2095. 

  2095. 	}
    2096. 

  2096. 	
    2097. 

  2097. 	$list_view .="<table align='center' border='0' cellpadding='5' cellspacing='0' width='98%'>
    2098. 

  2098. 			<tr><td colspan='3'>&nbsp;</td></tr>";
    2099. 

  2099. 			//checking permission for Create/Edit Operation
    2100. 

  2100. 			if(isPermitted("Calendar","EditView") == "yes")
    2101. 

  2101. 			{
    2102. 

  2102. 			$list_view .="<tr>
    2103. 

  2103. 				<td class='calAddButton' onMouseOver='fnAddEvent(this,\"addEventDropDown\",\"".$temp_date."\",\"".$endtemp_date."\",\"".$time_arr['starthour']."\",\"".$time_arr['startmin']."\",\"".$time_arr['startfmt']."\",\"".$time_arr['endhour']."\",\"".$time_arr['endmin']."\",\"".$time_arr['endfmt']."\",\"\",\"".$subtab."\",\"".$eventlist."\");'style='border: 1px solid #666666;cursor:pointer;height:30px' align='center' width='10%'>
    2104. 

  2104.                                         ".$mod_strings['LBL_ADD']."
    2105. 

  2105.                                         <img src='".vtiger_imageurl('menuDnArrow.gif', $theme)."' style='padding-left: 5px;' border='0'>                                                                                                                         </td>";
    2106. 

  2106. 			}
    2107. 

  2107. 			else
    2108. 

  2108. 			{
    2109. 

  2109. 				$list_view .="<tr><td>&nbsp;</td>";
    2110. 

  2110. 			}
    2111. 

  2111. 			$list_view .="<td align='center' width='60%'><span  id='total_activities'>".getTodoInfo($cal,'listcnt')."</span>&nbsp;</td>
    2112. 

  2112. 				<td align='right' width='28%'>&nbsp;</td>
    2113. 

  2113. 			</tr>
    2114. 

  2114. 		</table>
    2115. 

  2115. 

  2116. 			<br><table style='background-color: rgb(204, 204, 204);' class='small' align='center' border='0' cellpadding='5' cellspacing='1' width='98%'>
    2117. 

  2117.                         ";
    2118. 

  2118. 	$header_rows = count($header);
    2119. 

  2119. 	$navigationOutput = getTableHeaderSimpleNavigation($navigation_array, $url_string,"Calendar","index");
    2120. 

  2120. 

  2121. 	if($navigationOutput != '')
    2122. 

  2122. 	{
    2123. 

  2123. 		$list_view .= "<tr width=100% bgcolor=white><td align=center colspan=$header_rows>";
    2124. 

  2124. 		$list_view .= "<table align=center width='98%'><tr>".$navigationOutput."</tr></table></td></tr>";
    2125. 

  2125. 	}
    2126. 

  2126. 	$list_view .= "<tr>";
    2127. 

  2127.         for($i=0;$i<$header_rows;$i++)
    2128. 

  2128.         {
    2129. 

  2129.                 $list_view .="<td class='lvtCol' width='".$header_width[$i]."' nowrap='nowrap'>".$header[$i]."</td>";
    2130. 

  2130.         }
    2131. 

  2131.         $list_view .="</tr>";
    2132. 

  2132. 	$rows = count($todo_list);
    2133. 

  2133.         if($rows != 0)
    2134. 

  2134.         {
    2135. 

  2135.                 for($i=0;$i<count($todo_list);$i++)
    2136. 

  2136.                 {
    2137. 

  2137.                         $list_view .="<tr style='height: 25px;' bgcolor='white'>";
    2138. 

  2138.                         foreach($todo_list[$i] as $key=>$entry)
    2139. 

  2139.                         {
    2140. 

  2140.                                 $list_view .="<td>".$entry."</td>";
    2141. 

  2141.                         }
    2142. 

  2142.                         $list_view .="</tr>";
    2143. 

  2143.                 }
    2144. 

  2144.         }
    2145. 

  2145.         else
    2146. 

  2146.         {
    2147. 

  2147. 		$list_view .="<tr><td style='background-color:#efefef;height:340px' align='center' colspan='".$colspan."'>";
    2148. 

  2148. 		$list_view .="<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 45%; position: relative; z-index: 5000;'>
    2149. 

  2149. 			<table border='0' cellpadding='5' cellspacing='0' width='98%'>
    2150. 

  2150. 			<tr>
    2151. 

  2151. 				<td rowspan='2' width='25%'>
    2152. 

  2152. 					<img src='" . vtiger_imageurl('empty.jpg', $theme). "' height='60' width='61'></td>
    2153. 

  2153. 				<td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='75%'><span class='genHeaderSmall'>".$app_strings['LBL_NO']." ".$app_strings['Todos']." ".$app_strings['LBL_FOUND']." !</span></td>
    2154. 

  2154. 			</tr>
    2155. 

  2155. 			<tr>";
    2156. 

  2156. 		//checking permission for Create/Edit Operation
    2157. 

  2157. 		if(isPermitted("Calendar","EditView") == "yes")
    2158. 

  2158. 		{
    2159. 

  2159. 			$list_view .="<td class='small' align='left' nowrap='nowrap'>".$app_strings['LBL_YOU_CAN_CREATE']."&nbsp;".$app_strings['LBL_A']."&nbsp;".$app_strings['Todo']."&nbsp;".$app_strings['LBL_NOW'].".&nbsp;".$app_strings['LBL_CLICK_THE_LINK']."&nbsp;:<br>
    2160. 

  2160. 					&nbsp;&nbsp;-<a href='javascript:void(0);' onClick='gshow(\"createTodo\",\"todo\",\"".$temp_date."\",\"".$temp_date."\",\"".$time_arr['starthour']."\",\"".$time_arr['startmin']."\",\"".$time_arr['startfmt']."\",\"".$time_arr['endhour']."\",\"".$time_arr['endmin']."\",\"".$time_arr['endfmt']."\",\"listview\",\"todo\");'>".$app_strings['LBL_CREATE']." ".$app_strings['LBL_A']." ".$app_strings['Todo']."</a>
    2161. 

  2161. 					</td>";
    2162. 

  2162. 		}
    2163. 

  2163. 		else
    2164. 

  2164. 		{
    2165. 

  2165. 			$list_view .="<td class='small' align='left' nowrap='nowrap'>".$app_strings['LBL_YOU_ARE_NOT_ALLOWED_TO_CREATE']."&nbsp;".$app_strings['LBL_A']."&nbsp;".$app_strings['Todo']."<br></td>";
    2166. 

  2166. 		}
    2167. 

  2167. 										 
    2168. 

  2168.                 $list_view .="</tr>
    2169. 

  2169. 			</table>
    2170. 

  2170. 			</div>";
    2171. 

  2171. 		$list_view .="</td></tr>";
    2172. 

  2172.         }
    2173. 

  2173. 	$list_view .="</table><br>";
    2174. 

  2174. 	$cal_log->debug("Exiting constructTodoListView() method...");
    2175. 

  2175.         return $list_view;
    2176. 

  2176. }
    2177. 

  2177. 

  2178. /**
    2179. 

  2179.  * Function returns the list of privileges and permissions of the events that the current user can view the details of.
    2180. 

  2180.  * return string - query that is used as secondary parameter to fetch the events that the user can view and the schedule of the users
    2181. 

  2181.  */
    2182. 

  2182. function getCalendarViewSecurityParameter()
    2183. 

  2183. {
    2184. 

  2184. 		global $current_user;
    2185. 

  2185. 		require('user_privileges/user_privileges_'.$current_user->id.'.php');
    2186. 

  2186.         require('user_privileges/sharing_privileges_'.$current_user->id.'.php');
    2187. 

  2187.         
    2188. 

  2188. 		require_once('modules/Calendar/CalendarCommon.php');
    2189. 

  2189. 		$shared_ids = getSharedCalendarId($current_user->id);
    2190. 

  2190. 		if(isset($shared_ids) && $shared_ids != '')
    2191. 

  2191. 			$condition = " or (vtiger_crmentity.smownerid in($shared_ids)) or (vtiger_crmentity.smownerid NOT LIKE ($current_user->id))";// and vtiger_activity.visibility = 'Public')";
    2192. 

  2192. 		else
    2193. 

  2193. 			$condition = "or (vtiger_crmentity.smownerid NOT LIKE ($current_user->id))";
    2194. 

  2194. 		$sec_query .= " and (vtiger_crmentity.smownerid in($current_user->id) $condition or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '".$current_user_parent_role_seq."::%')";
    2195. 

  2195. 

  2196. 		if(sizeof($current_user_groups) > 0)
    2197. 

  2197. 		{
    2198. 

  2198. 			$sec_query .= " or (vtiger_groups.groupid in (". implode(",", $current_user_groups) ."))";
    2199. 

  2199. 		}
    2200. 

  2200. 		$sec_query .= ")";	
    2201. 

  2201. 		return $sec_query;
    2202. 

  2202. }
    2203. 

  2203. ?>
    2204.