Changeset 556

Timestamp:

Sep 10, 2007 12:25:26 PM (6 years ago)

Author:

dkg

Message:

adding events as an explicit class to the JPDD project, so a single web site can track multiple events.

Location:

trunk/jpdd

Files:

• class.jpdd.event.php (added)
• class.jpdd.php (modified) (1 diff)
• config.inc.php (modified) (1 diff)
• snippets/home.default.html (modified) (1 diff)
• sql/basics.sql (modified) (2 diffs)
• sql/db.sql (modified) (1 diff)

trunk/jpdd/class.jpdd.php

@@ -35 +35 @@
                                                     'table' => 'organization',
                                                     'sort' => 'title'));
+      $this->addClassMapEntry('event', array('classname' => 'JPDD_Event', 
+                                                    'filename' => 'class.jpdd.event.php',
+                                                    'table' => 'event',
+                                                    'sort' => 'start_time'));
 
     }

trunk/jpdd/config.inc.php

@@ -10 +10 @@
   'db_name' => 'jpdd',
 
-  'site_name' => 'New York Performance Assessment Professional Development Day',
+  'active_events' => array(3),
+
+  'site_name' => 'New York Performance Assessment Moderation Workshop',
 
   // HACK!  this stuff should really be in the database, so this tool
   // could be used to plan multiple PDDs.
-  'site_subtitle' => 'Building a Performance Assessment Culture in Our Schools',
-  'site_date' => 'Jan 31, 2007',
+  'site_subtitle' => 'Applying Performance Standards Rubrics',
+  'site_date' => 'Sep 29, 2007',
 
   // should start and end in a '/'.  If installed in the root of the

trunk/jpdd/snippets/home.default.html

@@ -2 +2 @@
 href="http://performanceassessment.org/">New York Performance
 Standards Consortium</a> will be hosting a Professional Development
-Day for New York City teachers at <a href="http://jrec.org/">the Julia
-Richman Education Complex</a> on Wednesday, 31 January, 2007.
+Day for NYPSC member schools at <a href="http://jrec.org/">the Julia
+Richman Education Complex</a> on Saturday, 29 September, 2007.
 
-<p>On this website, you can see the workshops that will be offered on
-that day.  If you plan on attending, you can register for a workshop
-now.
-
-  <h2>Schedule</h2>
-  <dl>
-    <dt>8:30-9:00</dt>
-    <dd>Breakfast</dd>
-    
-    <dt>9:00-9:15</dt>
-    <dd>Consortium & DYO welcome and news</dd>
-    
-    <dt>9:15-9:35</dt>
-    <dd>Guest speaker: Mike Winerip, Pulitzer Prize winning journalist
-      and, recently, education columnist for The New York Times</dd>
-      
-      <dt>9:45-12:00</dt>
-      <dd><a href="category">Workshops</a> (a 15-minute break will be included)</dd>
-    </dl>
-    
+<p>This web site can be used to coordinate logistics for that day.
 </div>

trunk/jpdd/sql/basics.sql

@@ -72 +72 @@
 --
 
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('privilege', 'id'), 8, true);
+SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('privilege', 'id'), 10, true);
 
 
@@ -88 +88 @@
 7       Edit Categories This allows users to modify the available categories
 8       Send Broadcast  This allows users to broadcast templated messages to groups of signed-up users
+9       List Events     This allows users to see a list of all historical events
+10      Edit Events     This allows users to create and modify existing events
 \.
 
 
 --
--- PostgreSQL database dump complete
+-- Postgresql database dump complete
 --
 

trunk/jpdd/sql/db.sql

@@ -835 +835 @@
 --
 
+
+
+CREATE OR REPLACE VIEW workshop_columns AS SELECT workshop_id,
+ SUM(CASE WHEN category_id IN(9) THEN 1 ELSE 0 END) > 0 AS math,
+ SUM(CASE WHEN category_id IN(15) THEN 1 ELSE 0 END) > 0 AS art,
+ SUM(CASE WHEN category_id IN(11) THEN 1 ELSE 0 END) > 0 AS science,
+ SUM(CASE WHEN category_id IN(12) THEN 1 ELSE 0 END) > 0 AS history,
+ SUM(CASE WHEN category_id IN(25) THEN 1 ELSE 0 END) > 0 AS english,
+ SUM(CASE WHEN category_id IN(30) THEN 1 ELSE 0 END) > 0 AS unione
+  FROM workshop_category GROUP BY workshop_id;
+
+CREATE OR REPLACE VIEW pommo_import AS SELECT first_name, middle_name, last_name, email, workshop_columns.*, organization.shortname AS school, organization.id = 31 as gates, organization.id = 9 as consortium from person LEFT JOIN attendance ON (person.id = person_id) LEFT JOIN workshop_columns USING (workshop_id) LEFT JOIN affiliation ON (person.id = affiliation.person_id) LEFT JOIN organization ON (organization_id = organization.id) ORDER BY last_name,first_name;
+
+
+CREATE VIEW pv AS select MAX(first) as first, MAX(mid) as mid, MAX(last) as last, email, MAX(school) as school, 
+ SUM(CASE WHEN lower(tag) LIKE '%math%' THEN 1 ELSE 0 END) > 0 AS math,
+ SUM(CASE WHEN lower(tag) LIKE '%history%' THEN 1 ELSE 0 END) > 0 AS history,
+ SUM(CASE WHEN lower(tag) LIKE '%science%' THEN 1 ELSE 0 END) > 0 AS science,
+ SUM(CASE WHEN lower(tag) LIKE '%art%' THEN 1 ELSE 0 END) > 0 AS art,
+ SUM(CASE WHEN lower(tag) LIKE '%english%' THEN 1 ELSE 0 END) > 0 AS english,
+ SUM(CASE WHEN lower(tag) LIKE '%gates%' THEN 1 ELSE 0 END) > 0 AS gates,
+ SUM(CASE WHEN lower(tag) LIKE '%empire%' THEN 1 ELSE 0 END) > 0 AS empire,
+ SUM(CASE WHEN lower(tag) LIKE '%admin%' THEN 1 ELSE 0 END) > 0 AS admin,
+ SUM(CASE WHEN lower(tag) LIKE '%amerhistgrant%' THEN 1 ELSE 0 END) > 0 AS amerhistgrant,
+ SUM(CASE WHEN lower(tag) LIKE '%network%' THEN 1 ELSE 0 END) > 0 AS network
+ from pp LEFT JOIN pt ON (pp.id = pp_id)  GROUP BY email;
+
+CREATE TABLE event (
+ id serial NOT NULL PRIMARY KEY,
+ title text NOT NULL,
+ start_time timestamp with time zone NOT NULL,
+ end_time timestamp with time zone NOT NULL
+);
+
+ALTER TABLE workshop ADD COLUMN event_id int;
+ALTER TABLE workshop ADD CONSTRAINT workshop_event_fkey FOREIGN KEY (event_id) REFERENCES event(id);
+
+-- fix existing columns here
+ALTER TABLE workshop ALTER COLUMN event_id SET NOT NULL;
+
+ALTER TABLE event ADD COLUMN description text;
+ALTER TABLE event ADD COLUMN motto text;