return;
} elseif (isset($_SESSION['next_reminder_interval']) && $_SESSION['next_reminder_time'] - $_SESSION['next_reminder_interval'] > $cur_time) {
echo "<script type='text/javascript' id='_vtiger_activityreminder_callback_interval_'>" . $_SESSION['next_reminder_interval'] * 1000 . "</script>";
return;
}
$log = LoggerManager::getLogger('Activity_Reminder');
$smarty = new vtigerCRM_Smarty();
if (isPermitted('Calendar', 'index') == 'yes') {
$active = $adb->pquery("select * from vtiger_users where id=?", array($current_user->id));
$active_res = $adb->query_result($active, 0, 'reminder_interval');
if ($active_res == 'None') {
$_SESSION['next_reminder_time'] = 'None';
}
if ($active_res != 'None') {
$interval = $adb->query_result($active, 0, "reminder_interval");
$intervalInMinutes = ConvertToMinutes($interval);
// check for reminders every minute
$time = time();
$_SESSION['next_reminder_time'] = $time + $intervalInMinutes * 60;
$date = date('Y-m-d', strtotime("+{$intervalInMinutes} minutes", $time));
$time = date('H:i', strtotime("+{$intervalInMinutes} minutes", $time));
$callback_query = "SELECT * FROM vtiger_activity_reminder_popup inner join vtiger_crmentity where " . " vtiger_activity_reminder_popup.status = 0 and " . " vtiger_activity_reminder_popup.recordid = vtiger_crmentity.crmid " . " and vtiger_crmentity.smownerid = " . $current_user->id . " and vtiger_crmentity.deleted = 0 " . " and ((DATE_FORMAT(vtiger_activity_reminder_popup.date_start,'%Y-%m-%d') <= '" . $date . "')" . " AND (TIME_FORMAT(vtiger_activity_reminder_popup.time_start,'%H:%i') <= '" . $time . "'))";
$result = $adb->query($callback_query);
$cbrows = $adb->num_rows($result);
if ($cbrows > 0) {
for ($index = 0; $index < $cbrows; ++$index) {
$reminderid = $adb->query_result($result, $index, "reminderid");
$cbrecord = $adb->query_result($result, $index, "recordid");
$cbmodule = $adb->query_result($result, $index, "semodule");
$focus = CRMEntity::getInstance($cbmodule);
if ($cbmodule == 'Calendar') {
$active = $adb->pquery("select * from vtiger_users where id=?", array($current_user->id));
$active_res = $adb->query_result($active, 0, 'reminder_interval');
if ($active_res != 'None') {
$reminder_next = $adb->query_result($active, 0, "reminder_next_time");
$lastlogin_time = $adb->query_result($active, 0, "date_entered");
if (empty($reminder_next)) {
$reminder_next = date('Y-m-d H:i');
}
if (strtotime($lastlogin_time) > strtotime($reminder_next)) {
$reminder_next = $lastlogin_time;
}
$reminder_next_time = strtotime($reminder_next);
$cur_time = mktime(date('H'), date('i'), 0, date('m'), date('d'), date('Y'));
if ($reminder_next_time <= $cur_time) {
$cb_time = $adb->query_result($active, 0, "reminder_interval");
$cb_time = ConvertToMinutes($cb_time);
$cb_mktime = strtotime($reminder_next);
$cbdate1 = date('Y-m-d', strtotime("+{$cb_time} minutes", $cb_mktime));
$cbtime1 = date('H:i', strtotime("+{$cb_time} minutes", $cb_mktime));
$callback_query = "SELECT * FROM vtiger_activity_reminder_popup inner join vtiger_crmentity where " . " vtiger_activity_reminder_popup.status = 0 and " . " vtiger_activity_reminder_popup.recordid = vtiger_crmentity.crmid " . " and vtiger_crmentity.smownerid = " . $current_user->id . " and vtiger_crmentity.deleted = 0 " . " and ((DATE_FORMAT(vtiger_activity_reminder_popup.date_start,'%Y-%m-%d') < '" . $cbdate1 . "')" . " OR ((DATE_FORMAT(vtiger_activity_reminder_popup.date_start,'%Y-%m-%d') = '" . $cbdate1 . "')" . " AND (TIME_FORMAT(vtiger_activity_reminder_popup.time_start,'%H:%i') <= '" . $cbtime1 . "')))";
$result = $adb->query($callback_query);
$cbrows = $adb->num_rows($result);
if ($cbrows > 0) {
for ($index = 0; $index < $cbrows; ++$index) {
$reminderid = $adb->query_result($result, $index, "reminderid");
$cbrecord = $adb->query_result($result, $index, "recordid");
$cbmodule = $adb->query_result($result, $index, "semodule");
$focus = CRMEntity::getInstance($cbmodule);
if ($cbmodule == 'Calendar') {
$focus->retrieve_entity_info($cbrecord, $cbmodule);
$cbsubject = $focus->column_fields['subject'];
