- Record Edit View Url */ public function getEditViewUrl() { $module = $this->getModule(); return 'index.php?module=Calendar&view='.$module->getEditViewName().'&record='.$this->getId(); } /** * Function to get the Delete Action url for the record * @return - Record Delete Action Url */ public function getDeleteUrl() { $module = $this->getModule(); return 'index.php?module=Calendar&action='.$module->getDeleteActionName().'&record='.$this->getId(); } /** * Funtion to get Duplicate Record Url * @return */ public function getDuplicateRecordUrl(){ $module = $this->getModule(); return 'index.php?module=Calendar&view='.$module->getEditViewName().'&record='.$this->getId().'&isDuplicate=true'; } public function getRelatedToContactIdList() { $adb = PearDatabase::getInstance(); $query = 'SELECT * from vtiger_cntactivityrel where activityid=?'; $result = $adb->pquery($query, array($this->getId())); $num_rows = $adb->num_rows($result); $contactIdList = array(); for($i=0; $i<$num_rows; $i++) { $row = $adb->fetchByAssoc($result, $i); $contactIdList[$i] = $row['contactid']; } return $contactIdList; } public function getRelatedContactInfo() { $contactIdList = $this->getRelatedToContactIdList(); $relatedContactInfo = array(); foreach($contactIdList as $contactId) { $relatedContactInfo[] = array('name' => Vtiger_Util_Helper::getRecordName($contactId) ,'id' => $contactId); } return $relatedContactInfo; } public function getInvities() { $adb = PearDatabase::getInstance(); $sql = "select vtiger_invitees.* from vtiger_invitees where activityid=?"; $result = $adb->pquery($sql,array($this->getId())); $invitiesId = array(); $num_rows = $adb->num_rows($result); for($i=0; $i<$num_rows; $i++) { $invitiesId[] = $adb->query_result($result, $i,'inviteeid'); } return $invitiesId; } public function getInviteUserMailData() { $adb = PearDatabase::getInstance(); $return_id = $this->getId(); $cont_qry = "select * from vtiger_cntactivityrel where activityid=?"; $cont_res = $adb->pquery($cont_qry, array($return_id)); $noofrows = $adb->num_rows($cont_res); $cont_id = array(); if($noofrows > 0) { for($i=0; $i<$noofrows; $i++) { $cont_id[] = $adb->query_result($cont_res,$i,"contactid"); } } $cont_name = ''; foreach($cont_id as $key=>$id) { if($id != '') { $contact_name = Vtiger_Util_Helper::getRecordName($id); $cont_name .= $contact_name .', '; } } $parentId = $this->get('parent_id'); $parentName = ''; if($parentId != '') { $parentName = Vtiger_Util_Helper::getRecordName($parentId); } $cont_name = trim($cont_name,', '); $mail_data = Array(); $mail_data['user_id'] = $this->get('assigned_user_id'); $mail_data['subject'] = $this->get('subject'); $moduleName = $this->getModuleName(); $mail_data['status'] = (($moduleName=='Calendar')?($this->get('taskstatus')):($this->get('eventstatus'))); $mail_data['activity_mode'] = (($moduleName=='Calendar')?('Task'):('Events')); $mail_data['taskpriority'] = $this->get('taskpriority'); $mail_data['relatedto'] = $parentName; $mail_data['contact_name'] = $cont_name; $mail_data['description'] = $this->get('description'); $mail_data['assign_type'] = $this->get('assigntype'); $mail_data['group_name'] = getGroupName($this->get('assigned_user_id')); $mail_data['mode'] = $this->get('mode'); //TODO : remove dependency on request; $value = getaddEventPopupTime($_REQUEST['time_start'],$_REQUEST['time_end'],'24'); $start_hour = $value['starthour'].':'.$value['startmin'].''.$value['startfmt']; if($_REQUEST['activity_mode']!='Task') $end_hour = $value['endhour'] .':'.$value['endmin'].''.$value['endfmt']; $startDate = new DateTimeField($_REQUEST['date_start']." ".$start_hour); $endDate = new DateTimeField($_REQUEST['due_date']." ".$end_hour); $mail_data['st_date_time'] = $startDate->getDBInsertDateTimeValue(); $mail_data['end_date_time'] = $endDate->getDBInsertDateTimeValue(); $mail_data['location']=$this->get('location'); return $mail_data; } }