PHP Event::find_all方法代码示例

 public function show($id = null)
 {
     $group = self::load_group($id);
     $sort = "user_groups.id ASC";
     if (isset($_GET['sort'])) {
         $options = array("nickname" => "users.nickname ASC", "email" => "users.email ASC", "activated" => "users.activated DESC", "created" => "users.created_at ASC");
         if (isset($options[$_GET['sort']])) {
             $sort = $options[$_GET['sort']];
         }
     }
     $group_events = array();
     foreach ($group->events() as $event) {
         $group_events[] = $event->id;
     }
     $all_events = Event::find_all();
     $events = array();
     foreach ($all_events as $event) {
         if (!in_array($event->id, $group_events)) {
             $events[] = $event;
         }
     }
     $this->assign("events", $events);
     $this->assign("users", $group->user_groups($sort));
     $this->assign("group", $group);
     $this->title = "View Group";
     $this->render("group/show.tpl");
 }

 public function edit($id = null)
 {
     $this->tinymce = true;
     $survey = self::load_survey($id);
     if ($this->post) {
         $survey->name = $this->PostData("name");
         $survey->description = $this->PostData("description");
         $survey->permalink = $this->PostData("permalink");
         $survey->intro = $this->PostData("intro");
         $survey->finish = $this->PostData("finish");
         $survey->active = $this->PostData("active");
         $survey->event_id = $this->PostData("event_id");
         if ($survey->Save()) {
             Site::Flash("notice", "The survey has been edited");
             Redirect("admin/surveys/{$survey->id}");
         }
     }
     $all_events = Event::find_all("", "events.startdate ASC");
     $events = array('' => 'None');
     foreach ($all_events as $event) {
         $events[$event->id] = $event->name;
     }
     $this->assign("events", $events);
     $this->assign("survey", $survey);
     $this->title = "Edit Survey";
     $this->render("survey/edit.tpl");
 }

 public function index()
 {
     $all_events = Event::find_all("events.visible = true OR events.advertised = true", "events.startdate DESC");
     $events = array();
     foreach ($all_events as $event) {
         if ($event->check_user(Site::CurrentUser())) {
             $events[] = $event;
         }
     }
     $this->assign("events", $events);
     $this->title = "Events";
     $this->render("event/index.tpl");
 }

 public function show($nickname = null)
 {
     $user = $this->load_user($nickname);
     $all_events = Event::find_all("", "events.startdate DESC");
     $events = array();
     foreach ($all_events as $event) {
         $events[$event->id] = $event->name;
     }
     $this->assign("user", $user);
     $this->assign("events", $events);
     $this->title = "View User";
     $this->render("user/show.tpl");
 }

 public static function render($title = null, $headcontent = null)
 {
     self::init();
     global $site;
     global $config;
     $smarty = new SmartySite();
     $smarty->assign("title", $title);
     $smarty->assign("site", $site);
     $smarty->assign("content", "|--|CONTENT|--|");
     $smarty->assign("headcontent", $headcontent);
     $smarty->assign("next_event", Event::next_event());
     $all_events = Event::find_all("events.visible = true", "events.startdate DESC");
     $events = array();
     foreach ($all_events as $event) {
         if ($event->check_user(Site::CurrentUser())) {
             $events[] = $event;
         }
     }
     $smarty->assign("all_events", $events);
     $output = $smarty->fetch("application/layout.tpl");
     $output = explode("|--|CONTENT|--|", $output);
     return array("header" => $output[0], "footer" => $output[1]);
 }

 public function save()
 {
     if ($this->permalink == "") {
         $this->permalink = self::make_permalink($this->name);
     }
     // If this is a new event, create a new achievement category
     if (!$this->achievement_category_id) {
         $achievement_category = new AchievementCategory();
         $achievement_category->category_name = $this->name;
         $achievement_category->save();
         $this->achievement_category_id = $achievement_category->id;
     }
     $result = parent::save(self::table);
     if ($result && $this->next) {
         $id = mysql_real_escape_string($this->id);
         $events = Event::find_all("events.next = TRUE and events.id <> '{$id}'");
         foreach ($events as $event) {
             $event->next = false;
             $event->save();
         }
     }
     return $result;
 }

function RenderPage($title, $content, $layout = "layout", $nosql = false, $vars = array())
{
    global $site;
    global $config;
    $smarty = new SmartySite();
    $smarty->assign("title", $title);
    $smarty->assign("content", $content);
    $smarty->assign("headcontent", "");
    $smarty->assign("site", $site);
    foreach ($vars as $name => $value) {
        $smarty->assign($name, $value);
    }
    if (isset($_SESSION['csrf'])) {
        $smarty->assign("csrf", $_SESSION['csrf']);
    }
    if (!$nosql) {
        $revert = false;
        if (isset($config['dev_sql']) && $config['dev_sql']) {
            $config['dev_sql'] = false;
            $revert = true;
        }
        $smarty->assign("next_event", Event::next_event());
        $events = array('future' => Event::find_all("(events.visible = true OR events.advertised = true) AND events.enddate > NOW()", "events.enddate ASC"), 'past' => Event::find_all("(events.visible = true OR events.advertised = true) AND events.enddate <= NOW()", "events.enddate DESC"));
        foreach ($events as $type => $collection) {
            ${$type} = array();
            foreach ($collection as $key => $event) {
                if ($event->check_user(Site::CurrentUser())) {
                    array_push(${$type}, $event);
                }
            }
            $smarty->assign("{$type}Events", ${$type});
        }
        $smallEvents = array();
        $largeEvents = array();
        foreach ($future as $event) {
            if ($event->capacity < 50) {
                $smallEvents[] = $event;
            } else {
                $largeEvents[] = $event;
            }
        }
        $smallEvents = array_slice($smallEvents, 0, 3);
        $largeEvents = array_slice($largeEvents, 1, 1);
        $smarty->assign('smallEvents', $smallEvents);
        $smarty->assign('largeEvents', $largeEvents);
        if ($revert) {
            $config['dev_sql'] = true;
        }
    }
    // Determine SSL or not
    $protocol = "http";
    if (isset($_SERVER['SERVER_PORT']) and $_SERVER['SERVER_PORT'] == 443) {
        $protocol = "https";
    }
    $baseuri = "{$protocol}://{$_SERVER['HTTP_HOST']}";
    $smarty->assign("protocol", $protocol);
    $smarty->assign("baseuri", $baseuri);
    $smarty->display("application/{$layout}.tpl");
    if (isset($config['dev_sql']) && $config['dev_sql']) {
        file_put_contents("logs/sql.log", "\r\n", FILE_APPEND);
    }
    die;
}

 public function index($permalink = null)
 {
     $sort = $this->GetData('sort', "id");
     if ($sort == "nickname") {
         $order = "users.nickname ASC";
     } elseif ($sort == "date") {
         $order = "event_signups.created_at DESC";
     } elseif ($sort == "id") {
         $order = "event_signups.id ASC";
     } elseif ($sort == "seat") {
         $order = "event_seats.row ASC, event_seats.number ASC";
     } elseif ($sort == "ticket") {
         $order = "event_tickets.name ASC";
     } elseif ($sort == "event") {
         $order = "events.name DESC";
     } elseif ($sort == "voucher") {
         $order = "event_signups.voucher DESC";
     } else {
         $order = "event_signups.paid DESC, users.nickname ASC";
     }
     if (isset($_SESSION['signupadminquery'])) {
         $query = $_SESSION['signupadminquery'];
     } else {
         $query = (object) array('event_id' => null, 'signup_id' => null);
     }
     if (isset($_GET['event_id'])) {
         $query->event_id = $this->GetData('event_id');
     }
     if (isset($_GET['signup_id'])) {
         $query->signup_id = $this->GetData('signup_id');
     }
     $_SESSION['signupadminquery'] = $query;
     $filters = array();
     if ($query->event_id) {
         $event_id = mysql_real_escape_string($query->event_id);
         $filters[] = "events.id = '{$event_id}'";
     }
     if ($query->signup_id) {
         $signup_id = mysql_real_escape_string($query->signup_id);
         $filters[] = "event_signups.id = '{$signup_id}'";
     }
     $filter = implode(' AND ', $filters);
     $page = $this->GetData('page', 1);
     $signups = EventSignup::paginate($filter, $order, $page, 100);
     $allEvents = Event::find_all("", "events.startdate DESC");
     $events = array('' => 'All');
     foreach ($allEvents as $event) {
         $events[$event->id] = $event->name;
     }
     $this->assign('query', $query);
     $this->assign('events', $events);
     $this->assign("signups", $signups);
     $this->assign("sort", $sort);
     $this->title = "Event Signups";
     $this->render("event_signup/index.tpl");
 }

 public function index()
 {
     $events = Event::find_all("", "events.created_at ASC");
     $this->assign("events", $events);
     $this->title = "Events";
     $this->render("event/index.tpl");
 }