include './pages/dashboard.php'; break; case 'inbox': if (!isset($_SESSION['user_id'])) { redirect_to(SITE_URL . DS . 'login' . DS); } $mits = Task::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Tasks WHERE archived = 0 AND completed = 0 AND date_scheduled = "0000-00-00" ORDER BY date_added ASC'); $big_rocks = Task::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Tasks WHERE big_rock = 1 AND date_scheduled BETWEEN ' . $sql_week_range); $labels = Context::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Contexts GROUP BY name ORDER BY name ASC'); include './pages/inbox.php'; break; case 'archive': $mits = Task::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Tasks WHERE archived = 1 || completed = 1 ORDER BY date_scheduled ASC'); $big_rocks = Task::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Tasks WHERE big_rock = 1 AND date_scheduled BETWEEN ' . $sql_week_range); $inbox_items = Task::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Tasks WHERE date_scheduled = "0000-00-00" AND big_rock = 0 AND completed = 0 ORDER BY id DESC'); $labels = Context::find_by_sql('SELECT * FROM ' . $_SESSION['user_id'] . '_Contexts GROUP BY name ORDER BY name ASC'); include './pages/archive.php'; break; case 'list': include './pages/list.php'; break; case 'account': if (!isset($_SESSION['user_id'])) { redirect_to(SITE_URL . DS . 'login' . DS); } include './pages/account.php'; break; case 'admin-options': if (!isset($_SESSION['user_id'])) { redirect_to(SITE_URL . DS . 'login' . DS); }