$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;
}
