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'];