X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fpltableeditor.php;h=89c0b14b7cc186401e473627fcf5e3a0794ff61a;hb=b2eec295f4a018ae416566007ff9bda64a5f5734;hp=fea0c34d958731333d6d0a8911b4c6c5461db644;hpb=ed4f7de016bb136fae9f72256c827ef09d4ea863;p=platal.git

diff --git a/classes/pltableeditor.php b/classes/pltableeditor.php
index fea0c34..89c0b14 100644
--- a/classes/pltableeditor.php
+++ b/classes/pltableeditor.php
@@ -54,6 +54,17 @@ class PLTableEditor
     public $nbfields;
     // a where clause to restrict table
     public $whereclause;
+    /** Forced values
+     * This is an associative array of (field, value) to enforce.
+     * Only rows where each of the fields has the specified value will
+     * be selected; and added values will use these values for these fields:
+     *
+     * $forced_values = array('foo', 'bar')
+     * => Selects rows with WHERE foo = 'bar'
+     * => Insertions are done with SET foo = 'bar'
+     */
+    public $forced_values = array();
+
     // the field for sorting entries
     public $sortfield;
     public $sortdesc = false;
@@ -84,7 +95,10 @@ class PLTableEditor
         while ($a = $r->next()) {
             // desc will be the title of the column
             $a['desc'] = $a['Field'];
-            $a['display'] = true;
+            // display_list decides whether to display the field in 'list' mode
+            $a['display_list'] = true;
+            // display_item decides whether a field is displayed in 'item edition' mode
+            $a['display_item'] = true;
 
             if (substr($a['Type'],0,8) == 'varchar(') {
                 // limit editing box size
@@ -157,6 +171,9 @@ class PLTableEditor
                 $ip = long2ip($ip);
             }
         }
+        foreach ($this->forced_values as $field => $value) {
+            $entry[$field] = $value;
+        }
         return $entry;
     }
 
@@ -167,10 +184,11 @@ class PLTableEditor
     }
 
     // change display of a field
-    public function describe($name, $desc, $display)
+    public function describe($name, $desc, $display_list, $display_item=true)
     {
         $this->vars[$name]['desc'] = $desc;
-        $this->vars[$name]['display'] = $display;
+        $this->vars[$name]['display_list'] = $display_list;
+        $this->vars[$name]['display_item'] = $display_item;
     }
 
     // add a join table, when deleting a row corresponding entries will be deleted in these tables
@@ -216,6 +234,12 @@ class PLTableEditor
         }
     }
 
+    // force the value of a field in select and add
+    public function force_field_value($field, $value)
+    {
+        $this->forced_values[$field] = $value;
+    }
+
     // add a where clause to limit table listing
     public function set_where_clause($whereclause="1")
     {
@@ -229,6 +253,25 @@ class PLTableEditor
         $this->delete_message = $message;
     }
 
+    /** Retrieve the 'WHERE' clause to use for this PlTableEditor.
+     * Takes into account $this->whereclause and $this->forced_values.
+     *
+     * @param $extra_clause optional extra clause to add to the WHERE
+     * @return The WHERE clause to use
+     */
+    protected function get_where_clause($extra_clause=null)
+    {
+        $parts = array();
+        $parts[] = $this->whereclause;
+        if ($extra_clause !== null) {
+            $parts[] = $extra_clause;
+        }
+        foreach ($this->forced_values as $field => $val) {
+            $parts[] = XDB::format("$field = {?}", $val);
+        }
+        return implode(' AND ', $parts);
+    }
+
     // call when done
     public function apply(PlPage $page, $action, $id = false, $id2 = false)
     {
@@ -244,7 +287,7 @@ class PLTableEditor
                 if ($this->idfield2) {
                     $where .= XDB::format(" AND {$this->idfield2} = {?}", $id2);
                 }
-                XDB::rawExecute("DELETE FROM {$this->table} WHERE " . $where);
+                XDB::rawExecute("DELETE FROM {$this->table} WHERE " . $this->get_where_clause($where));
                 $page->trigSuccess("L'entrée " . $id . (($id2) ? '-' . $id2 : '') . ' a été supprimée.');
             } else if ($this->delete_action) {
                 XDB::execute($this->delete_action, $id);
@@ -258,7 +301,7 @@ class PLTableEditor
             }
         }
         if ($action == 'edit' && $id !== false) {
-            $r = XDB::query("SELECT * FROM {$this->table} WHERE {$this->idfield} = {?} AND {$this->whereclause}",$id);
+            $r = XDB::query("SELECT * FROM {$this->table} WHERE {$this->idfield} = {?} AND " . $this->get_where_clause(), $id);
             $entry = $r->fetchOneAssoc();
             $page->assign('entry', $this->prepare_edit($entry));
             $page->assign('id', $id);
@@ -273,6 +316,9 @@ class PLTableEditor
                     $importer->describe($field, @$descr['desc']);
                 }
             }
+            foreach ($this->forced_values as $field => $value) {
+                $importer->forceValue($field, $value);
+            }
             $page->assign('massadd', true);
             $importer->apply($page, $this->pl . '/massadd', $fields);
             $list = false;
@@ -299,6 +345,8 @@ class PLTableEditor
                     } else {
                         continue;
                     }
+                } elseif (array_key_exists($field, $this->forced_values)) {
+                    $val = $this->forced_values[$field];
                 } elseif ($descr['Type'] == 'set') {
                     $val = new PlFlagset();
                     if (Post::has($field)) {
@@ -317,7 +365,7 @@ class PLTableEditor
                     } elseif ($descr['Type'] == 'ip_address') {
                         $val = ip2long($val);
                     }
-                } else {
+                } elseif ($descr['display_item']) {
                     $cancel = true;
                     $page->trigError("Il manque le champ ".$field);
                 }
@@ -333,7 +381,7 @@ class PLTableEditor
                     XDB::rawExecute("UPDATE {$this->table}
                                         SET {$update}
                                       WHERE {$this->idfield} = " . XDB::escape($id) . "
-                                            AND {$this->whereclause}");
+                                      AND " . $this->get_where_clause());
                 } else {
                     $fields = implode(', ', array_keys($values));
                     $values = implode(', ', $values);
@@ -411,10 +459,10 @@ class PLTableEditor
             foreach ($this->otables as $tablename => $jointclause) {
                 $optional_joints .= ' LEFT JOIN '.$tablename.' ON ('.$jointclause.')';
             }
-            $it = XDB::iterator("SELECT t.* {$optional_fields} FROM {$this->table} AS t {$optional_joints} WHERE {$this->whereclause} $sort");
+            $it = XDB::iterator("SELECT t.* {$optional_fields} FROM {$this->table} AS t {$optional_joints} WHERE " . $this->get_where_clause() . " $sort");
             $this->nbfields = 0;
             foreach ($this->vars as $field => $descr)
-                if ($descr['display']) $this->nbfields++;
+                if ($descr['display_list']) $this->nbfields++;
             $page->assign('list', $it);
         }
         $page->assign('t', $this);