Changeset 49

Timestamp:

07/17/07 19:30:09 (18 months ago)

Author:

aarkerio

Message:

Add calendar and events

Location:

trunk/app

Files:

• config/sql/karamelo.sql (modified) (1 diff)
• controllers/events_controller.php (modified) (9 diffs)
• vendors/Calendar.php (added)
• views/events/calendar.thtml (added)
• webroot/css/styles.css (modified) (1 diff)

trunk/app/config/sql/karamelo.sql

@@ -864 +864 @@
 );
 
+CREATE TABLE events (
+    id serial PRIMARY KEY,
+   title varchar(100) NOT NULL,
+   description  varchar(255) NOT NULL,
+    "when" timestamp(0) with time zone DEFAULT now() NOT NULL,
+    status int NOT NULL DEFAULT 0
+);
+
 CREATE TABLE lessons (   --  lessons 
 id serial PRIMARY KEY,

trunk/app/controllers/events_controller.php

@@ -7 +7 @@
  
 uses('sanitize');
+loadModel('User');
+vendor('Calendar');
 
 class EventsController extends AppController
@@ -14 +16 @@
    public $components    = array('Portal');
    
-   public function display()
+   public function calendar()
    {  
-      $this->layout    = 'ajax';
+      $this->layout  = 'portal';
       
-      $conditions = null;
+      $conditions    = array("Event.status"=>1);
       
-      $fields     = array("Subject.id", "Subject.title", "Subject.code");
+      $fields        = array("Event.id", "Event.title", "Event.description", "Event.when");
       
-      $order      = "Subject.title";
+      $order         = "Event.when DESC";
       
-      $limit      =  null;
+      $limit         =  null;
       
-      $this->set('data', $this->Subject->findAll($conditions, $fields, $order, $limit));
+      $this->set('data', $this->Event->findAll($conditions, $fields, $order, $limit));
       
-      $this->render('qs', 'ajax');
+      $cal = new Calendar ('2007', '7'); 
       
+      $dts['Month']   = $cal->getFullMonthName();
+      
+      $dts['Display'] = $cal->display();
+      
+      $this->set('dts', $dts);
+      
+      $this->set('Element', $this->Portal->statics()); // Charge Portal components aka Sidebars
    }
    
@@ -36 +45 @@
       $this->layout    = 'portal';
       
-      $conditions = array("Subject.code"=>$code);
+      $conditions = array("Event.code"=>$code);
       
-      $fields     = array("Subject.id", "Subject.title", "Subject.code");
+      $fields     = array("Event.id", "Event.title", "Event.code");
       
-      $order      = "Subject.title";
+      $order      = "Event.title";
       
       $limit      =  20;
       
-      $this->set('data', $this->Subject->findAll($conditions, $fields, $order, $limit, null, 2));
+      $this->set('data', $this->Event->findAll($conditions, $fields, $order, $limit, null, 2));
       
-        $this->set('Element', $this->Portal->statics()); // Charge Portal components aka Sidebars
+      $this->set('Element', $this->Portal->statics()); // Charge Portal components aka Sidebars
    }
    
    public function show($subject_id)
     {   
-        $this->pageTitle = 'Karamelo :: Subject';
+        $this->pageTitle = 'Karamelo :: Event';
         $this->layout    = 'default'; //$this->Blog->field;
-        $conditions = array("Subject.id"=>$subject_id);
-        $fields     = array("Subject.id", "Subject.title", "Subject.code");
-        $order      = "Subject.title DESC";
+        $conditions = array("Event.id"=>$subject_id);
+        $fields     = array("Event.id", "Event.title", "Event.code");
+        $order      = "Event.title DESC";
         
         $this->set('subjects', $this->Portal->cms()); // Using Portal component
@@ -61 +70 @@
         $this->set('randomQuote', $this->Portal->quote()); // quote footer
         
-        $this->set('data', $this->Subject->findAll($conditions, $fields, $order));
+        $this->set('data', $this->Event->findAll($conditions, $fields, $order));
         
     }
@@ -76 +85 @@
       $order      = "title DESC";
       
-      $this->set('data', $this->Subject->findAll($conditions, $fields, $order));
+      $this->set('data', $this->Event->findAll($conditions, $fields, $order));
    }
    
@@ -84 +93 @@
      
     // adds new classroom to database
-    if (!empty($this->data["Subject"]))
+    if (!empty($this->data["Event"]))
     {
         $this->Sanitize = new Sanitize;
         
-        $this->Sanitize->cleanArray($this->data["Subject"]); //Hopefully this is enough
+        $this->Sanitize->cleanArray($this->data["Event"]); //Hopefully this is enough
         
-        if ($this->Subject->save($this->data["Subject"]))
+        if ($this->Event->save($this->data["Event"]))
          {
            $this->msgFlash('Your subject has been saved.','/admin/subjects/listing');
@@ -101 +110 @@
   {
      
-    if (empty($this->data["Subject"]))
+    if (empty($this->data["Event"]))
     {
         $this->layout = 'admin';
         
-        $this->Subject->id = $id;
+        $this->Event->id = $id;
         
-        $this->data = $this->Subject->read();
+        $this->data = $this->Event->read();
     }
     else
@@ -113 +122 @@
         $this->Sanitize = new Sanitize;
         
-        $this->Sanitize->cleanArray($this->data["Subject"]); //Hopefully this is enough
+        $this->Sanitize->cleanArray($this->data["Event"]); //Hopefully this is enough
         
-        if ($this->Subject->save($this->data['Subject']))
+        if ($this->Event->save($this->data['Event']))
         {
             $this->msgFlash('Your subject has been updated', '/admin/subjects/listing');
@@ -125 +134 @@
   {
         // deletes task from database
-        $this->Subject->del($id);
-        $this->msgFlash('Subject has been deleted','/admin/subjects/listing');
+        $this->Event->del($id);
+        $this->msgFlash('Event has been deleted','/admin/subjects/listing');
   }
   

trunk/app/webroot/css/styles.css

@@ -396 +396 @@
 }
 
-
+/* overall table */
+#calendar table {
+border:1px solid #fff;
+padding: 0;
+margin:20px;
+}
+
+/* the day headers across the top */
+#calendar th {
+background: #565;
+color: #fff;
+margin: 3px;
+padding: 2px 5px;
+}
+
+/* how days this month will look, make dates appear in top right */
+#calendar td {
+background: #eee;
+color: #000;
+padding: 2px;
+margin:0;
+height:60px;
+text-align:right;
+vertical-align:top;
+border:1px solid #fff;
+}
+
+/* these are the days falling outside this month */
+#calendar td.notInMonth {
+background: #999;
+}
+