Ejemplo n.º 1
0
while ($row = tep_db_fetch_array($q)) {
    $i = new improvement($row['improvements_id']);
    $i->updateStatus('4', '5', $username);
}
$logger->write("- Auto move to Checkings Tab");
//$q = tep_db_query("SELECT improvements_id, DATEDIFF(deadline, '$today') AS deadline_diff FROM improvements WHERE status<4 HAVING deadline_diff<=1");
$q = tep_db_query("SELECT improvements_id, DATEDIFF(deadline, '{$today}') AS deadline_diff FROM improvements WHERE status<4 OR status=7 HAVING deadline_diff<=1");
while ($row = tep_db_fetch_array($q)) {
    $i = new improvement($row['improvements_id']);
    $targets = array();
    $targets[] = $i->owner_id;
    if ($i->pic > 0) {
        $targets[] = $i->pic;
    }
    $message = $obj_notifications->messageTemplateDeadlineReminder($username, 'Improvement', $i->id, $row['deadline_diff'], improvement::getTeamCategories($i->team, $i->category), $i->name);
    $obj_notifications->broadcast($targets, $message, $username, 'open=improvement&id=' . $i->id, false, $targets);
}
$logger->write("- Deadline Notifications Sent");
$logger->write("Task 3 - End");
$logger->write("Task 4a (CLEAR OLD NOTIFICATIONS) - Start");
////////////////////////////////////////////////
// CLEAR OLD NOTIFICATIONS OLDER THAN 1 MONTH //
////////////////////////////////////////////////
$max_days = 30;
$date_max = date('Y-m-d 00:00:00', strtotime("-{$max_days} days"));
$q = tep_db_query("DELETE FROM minierp_users_has_notifications WHERE posted_date<='{$date_max}' AND status=0 AND need_feedback=0");
$logger->write("Task 4b (RESET NEW STATUS FOR UNCONFIRMED FEEDBACK) - Start");
/////////////////////////////////////////
// SET BACK UNANSWERED FEEDBACK AS NEW //
/////////////////////////////////////////
$q = tep_db_query("UPDATE minierp_users_has_notifications SET status=0 WHERE need_feedback=1 AND status=1");
Ejemplo n.º 2
0
function tep_db_error($query, $errno, $error)
{
    global $session_userinfo, $DEBUGER_USERNAME;
    $timestamp = date('d.m.Y H:i:s');
    $username = isset($session_userinfo) ? $session_userinfo['username'] : '******';
    use_class('logger');
    $logger = new logger('general', 'query_error', false);
    //save error to a log file
    $logger->write('User: '******'REQUEST_URI']);
    if (isset($_POST) && count($_POST) > 0) {
        $logger->write('--- POST vars sent ---');
        foreach ($_POST as $pk => $pv) {
            $logger->write("{$pk} = {$pv}");
        }
        $logger->write('--- POST vars end ---');
    }
    $logger->write($errno . ' - ' . $error);
    $logger->write($query);
    $logger->close();
    //notify it team via notfication system
    use_class('notifications');
    $obj_notifications = new notifications();
    $team_followers = load_config('teams_followers');
    $message = '<strong>ACHTUNG!</strong> Query Error found in ' . $_SERVER['REQUEST_URI'] . ', please check general query error log file for details!';
    $obj_notifications->broadcast($team_followers[1], $message, 'auto-set', 'open=log-analyzer&logfilename=general_query_error', true);
    if (SERVERTYPE != SERVERTYPE_LIVE || isset($session_userinfo) && in_array($session_userinfo['username'], $DEBUGER_USERNAME)) {
        $show_err_msg = SERVERTYPE != SERVERTYPE_LIVE ? 'accessing a non live environment' : 'logged in as ' . $session_userinfo['username'];
        die('<em>This detail error message is displayed because you are ' . $show_err_msg . '</em><br /><br />' . '<strong>Query Error: ' . $errno . '</strong>' . '<br />' . $error . '<br /><br />' . '<strong>QUERY:</strong><br />' . $query);
    } else {
        die("Sorry, Manobo found an error while executing a database query," . "<br />a log has been created and a notification has been sent to IT Team." . "<br /><br />If you keep seeing this error message please wait until further notice from IT Team." . "<br /><br />We're sorry for the inconvenience.");
    }
}