$rem_min = 0; if (!empty($focus->column_fields['reminder_time'])) { $data['set_reminder'] = $c_mod_strings['LBL_YES']; $data['reminder_str'] = $finaldata['reminder_time']; } else { $data['set_reminder'] = $c_mod_strings['LBL_NO']; } //To set recurring details $query = 'SELECT vtiger_recurringevents.*, vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, vtiger_activity.time_end FROM vtiger_recurringevents INNER JOIN vtiger_activity ON vtiger_activity.activityid = vtiger_recurringevents.activityid WHERE vtiger_recurringevents.activityid = ?'; $res = $adb->pquery($query, array($focus->id)); $rows = $adb->num_rows($res); if ($rows > 0) { $recurringObject = RecurringType::fromDBRequest($adb->query_result_rowdata($res, 0)); $recurringInfoDisplayData = $recurringObject->getDisplayRecurringInfo(); $data = array_merge($data, $recurringInfoDisplayData); } else { $data['recurringcheck'] = getTranslatedString('LBL_NO', $currentModule); $data['repeat_str'] = ''; } $sql = 'select vtiger_users.*,vtiger_invitees.* from vtiger_invitees left join vtiger_users on vtiger_invitees.inviteeid=vtiger_users.id where activityid=?'; $result = $adb->pquery($sql, array($focus->id)); $num_rows = $adb->num_rows($result); $invited_users = array(); for ($i = 0; $i < $num_rows; $i++) { $userid = $adb->query_result($result, $i, 'inviteeid'); $username = getFullNameFromQResult($result, $i, 'Users'); $invited_users[$userid] = $username; }
/** * Function to get the recurring object * @return Object - recurring object */ public function getRecurringObject() { $db = PearDatabase::getInstance(); $query = 'SELECT vtiger_recurringevents.*, vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, vtiger_activity.time_end FROM vtiger_recurringevents INNER JOIN vtiger_activity ON vtiger_activity.activityid = vtiger_recurringevents.activityid WHERE vtiger_recurringevents.activityid = ?'; $result = $db->pquery($query, array($this->getId())); if ($db->num_rows($result)) { return RecurringType::fromDBRequest($db->query_result_rowdata($result, 0)); } return false; }