Changeset 1132

Timestamp:

Sep 3, 2008 2:43:50 PM (5 years ago)

Author:

dkg

Message:

added a notion of "valid interest" categories -- these are sort of supercategories that will be offered as a primary interest to people.

Location:

trunk/jpdd

Files:

• class.jpdd.category.php (modified) (1 diff)
• sql/db.sql (modified) (1 diff)

trunk/jpdd/class.jpdd.category.php

@@ -16 +16 @@
           return array('Edit Categories');
         }
+
+    function getInterestCategoryDropdown($name, $emptyfield = NULL, $selected = NULL, $extras = '') {
+      global $jpdd;
+      $ret = '<select name="'.$name.'" '.$extras.'>'."\n";
+      if (!is_null($emptyfield)) 
+        $ret .= '<option value="">'.htmlentities($emptyfield).'</option>'."\n";
+
+      $arr = $jpdd->getSeriesFromSQL('SELECT * FROM interest ORDER BY title', 'JPDD_Category');
+      reset($arr);
+      while(list(,$c) = each($arr)) 
+        $ret .= '<option value="'.(int)$c->_id.'"'.((!is_null($selected) && $selected == (int)$c->_id) ? ' selected' : '').' >'.
+          $c->getTitle().
+          '</option>'."\n";
+      return $ret.'</select>'."\n";
+    }
 
     function getWorkshops() {

trunk/jpdd/sql/db.sql

@@ -1025 +1025 @@
 CREATE TABLE person_interest (person_id integer NOT NULL REFERENCES
 person(id), category_id integer NOT NULL REFERENCES category(id));
+
+-- set up which categories count as valid interests:
+ALTER TABLE category ADD COLUMN valid_interest boolean NOT NULL DEFAULT false;
+UPDATE category SET valid_interest = true WHERE id IN (9,15,11,12,25);
+
+CREATE VIEW interest AS SELECT id, title, description FROM category WHERE valid_interest;
+GRANT SELECT ON interest TO "www-data";
+
+GRANT INSERT,DELETE,SELECT ON person_interest TO "www-data";