[Sommaire] [Imprimer]

   1  <?php
   2      /**************************************************************************\
   3      * eGroupWare - Registration                                                *
   4      * http://www.eGroupWare.org                                                *
   5      * This file written by Jason Wies (Zone) <zone@users.sourceforge.net>      *
   6      * Based on calendar/inc/class.soholiday.inc.php by Mark Peters             *
   7      * --------------------------------------------                             *
   8      *  This program is free software; you can redistribute it and/or modify it *
   9      *  under the terms of the GNU General Public License as published by the   *
  10      *  Free Software Foundation; either version 2 of the License, or (at your  *
  11      *  option) any later version.                                              *
  12      \**************************************************************************/
  13  
  14      /* $Id: class.somanagefields.inc.php 20009 2005-11-26 14:30:35Z nelius_weiss $ */
  15  
  16      class somanagefields
  17      {
  18          var $debug = False;
  19          var $db;
  20          var $db_fields;
  21  
  22  		function somanagefields()
  23          {
  24              $this->db = clone($GLOBALS['egw']->db);
  25  
  26              $this->db_fields = array ('field_name', 'field_text', 'field_type', 'field_values', 'field_required', 'field_order');
  27          }
  28  
  29  		function update_field ($field_info)
  30          {
  31              if ($field_info['field_values'])
  32              {
  33                  $field_info['field_values'] = base64_encode (serialize ($field_info['field_values']));
  34              }
  35  
  36              $sql = "UPDATE egw_reg_fields SET ";
  37  
  38              reset ($this->db_fields);
  39              while (list ($num, $field) = each ($this->db_fields))
  40              {
  41                  if ($num)
  42                  {
  43                      $sql .= ", ";
  44                  }
  45                  $sql .= "$field='$field_info[$field]'";
  46              }
  47  
  48              $sql .= " WHERE field_name='$field_info[field_name]'";
  49              $rv = $this->db->query ($sql);
  50  
  51              return $rv;
  52          }
  53  
  54  		function insert_field ($field_info)
  55          {
  56              if ($field_info['field_values'])
  57              {
  58                  $field_info['field_values'] = base64_encode (serialize ($field_info['field_values']));
  59              }
  60  
  61              $sql = "INSERT INTO egw_reg_fields (";
  62              $sql2 = "(";
  63  
  64              reset ($this->db_fields);
  65              while (list ($num, $field) = each ($this->db_fields))
  66              {
  67                  if ($num)
  68                  {
  69                      $sql .= ', ';
  70                      $sql2 .= ', ';
  71                  }
  72                  $sql .= $field;
  73                  $sql2 .= "'$field_info[$field]'";
  74              }
  75  
  76              $sql  .= ') VALUES ';
  77              $sql2 .= ')';
  78  
  79              $sql .= $sql2;
  80  
  81              $rv = $this->db->query ($sql);
  82  
  83              return $rv;
  84          }
  85  
  86  		function remove_field ($field_info)
  87          {
  88              $rv = $this->db->query ("DELETE FROM egw_reg_fields WHERE field_name='$field_info[field_name]'");
  89  
  90              return $rv;
  91          }
  92  
  93  		function get_field_list ()
  94          {
  95              $sql = "SELECT ";
  96  
  97              reset ($this->db_fields);
  98              while (list ($num, $db_field_name) = each ($this->db_fields))
  99              {
 100                  if ($num)
 101                  {
 102                      $sql .= ', ';
 103                  }
 104                  $sql .= $db_field_name;
 105              }
 106  
 107              $sql .= " FROM egw_reg_fields ORDER BY field_order";
 108              $this->db->query ($sql);
 109              while ($this->db->next_record ())
 110              {
 111                  $rarray[] = $this->db->Record;
 112              }
 113  
 114              return $rarray;
 115          }
 116      }
 117  ?>