tbrehm
2010-06-16 e28564dbde4f922a6a8263e3dea32d56b60b5b5b
interface/lib/classes/listform.inc.php
@@ -28,14 +28,6 @@
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
/**
* Listenbehandlung
*
* @package listform
* @author Till Brehm
* @version 1.1
*/
class listform {
    private $debug = 0;
@@ -46,7 +38,6 @@
    private $pagingValues;
    private $searchChanged = 0;
    private $module;
   private $dateformat = 'd.m.Y';
   public $wordbook;
    public function loadListDef($file, $module = '')
@@ -100,6 +91,8 @@
            //$querystring = str_replace("{RECORDID}",$record[$table_idx],$querystring);
         $app->uses('tform');
            $querystring = str_replace("{AUTHSQL}",$app->tform->getAuthSQL('r'),$querystring);
            $querystring = str_replace("{AUTHSQL-A}",$app->tform->getAuthSQL('r','a'),$querystring);
            $querystring = str_replace("{AUTHSQL-B}",$app->tform->getAuthSQL('r','b'),$querystring);
            //* Getting the records
            $tmp_records = $app->db->queryAllRecords($querystring);
@@ -123,7 +116,7 @@
            $record = array();
                $values = $app->$datasource_class->$datasource_function($field, $record);
            } else {
                $this->errorMessage .= "Custom datasource class or function is empty<br>\r\n";
                $this->errorMessage .= "Custom datasource class or function is empty<br />\r\n";
            }
        }
        return $values;
@@ -136,14 +129,22 @@
        //* Get config variable
        $list_name = $this->listDef['name'];
        $search_prefix = $this->listDef['search_prefix'];
      if(isset($_REQUEST['Filter']) && !isset($_SESSION['search'][$list_name])) {
         //* Jump back to page 1 of the list when a new search gets started.
         $_SESSION['search'][$list_name]['page'] = 0;
      }
        //* store retrieval query
        foreach($this->listDef['item'] as $i) {
            $field = $i['field'];
            //*TODO: comment =  hat sich die suche ge�ndert
            //* The search string has been changed
            if(isset($_REQUEST[$search_prefix.$field]) && isset($_SESSION['search'][$list_name][$search_prefix.$field]) && $_REQUEST[$search_prefix.$field] != $_SESSION['search'][$list_name][$search_prefix.$field]){
                    $this->searchChanged = 1;
               //* Jump back to page 1 of the list when search has changed.
               $_SESSION['search'][$list_name]['page'] = 0;
            }
            //* Store field in session
@@ -166,7 +167,7 @@
                    $this->searchValues[$search_prefix.$field] = $out;
            } else {
                if(isset($_SESSION['search'][$list_name][$search_prefix.$field])){
                    $this->searchValues[$search_prefix.$field] = $_SESSION['search'][$list_name][$search_prefix.$field];
                    $this->searchValues[$search_prefix.$field] = htmlspecialchars($_SESSION['search'][$list_name][$search_prefix.$field]);
                }
            }
        }
@@ -276,6 +277,7 @@
    public function decode($record) 
    {
        global $conf;
        if(is_array($record)) {
            foreach($this->listDef['item'] as $field){
                $key = $field['field'];
@@ -283,11 +285,39 @@
                   switch ($field['datatype']){
                    case 'VARCHAR':
                    case 'TEXT':
                        $record[$key] = stripslashes($record[$key]);
                        $record[$key] = htmlentities(stripslashes($record[$key]),ENT_QUOTES,$conf["html_content_encoding"]);
                         break;
                    case 'DATE':
                        $record[$key] = ($record[$key] > 0) ? date($this->dateformat,$record[$key]) : '';
                    case 'DATETSTAMP':
                        if ($record[$key] > 0) {
                     // is value int?
                     if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) {
                              $record[$key] = date($this->lng('conf_format_dateshort'), $record[$key]);
                     } else {
                              $record[$key] = date($this->lng('conf_format_dateshort'), strtotime($record[$key]));
                     }
                  }
                        break;
               case 'DATE':
                        if ($record[$key] > 0) {
                     // is value int?
                     if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) {
                              $record[$key] = date($this->lng('conf_format_dateshort'), $record[$key]);
                     } else {
                              $record[$key] = date($this->lng('conf_format_dateshort'), strtotime($record[$key]));
                     }
                  }
                        break;
                    case 'DATETIME':
                        if ($record[$key] > 0) {
                     // is value int?
                     if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) {
                              $record[$key] = date($this->lng('conf_format_datetime'), $record[$key]);
                     } else {
                              $record[$key] = date($this->lng('conf_format_datetime'), strtotime($record[$key]));
                     }
                  }
                        break;
                    case 'INTEGER':
@@ -295,7 +325,7 @@
                        break;
                    case 'DOUBLE':
                        $record[$key] = $record[$key];
                        $record[$key] = htmlentities($record[$key],ENT_QUOTES,$conf["html_content_encoding"]);
                        break;
                    case 'CURRENCY':
@@ -303,7 +333,7 @@
                        break;
                    default:
                        $record[$key] = stripslashes($record[$key]);
                        $record[$key] = htmlentities(stripslashes($record[$key]),ENT_QUOTES,$conf["html_content_encoding"]);
                   }
            }
            }
@@ -327,10 +357,21 @@
                        }
                        break;
                    
                    case 'DATE':
               case 'DATETSTAMP':
                        if($record[$key] > 0) {
                            list($tag,$monat,$jahr) = explode('.',$record[$key]);
                            $record[$key] = mktime(0,0,0,$monat,$tag,$jahr);
                      $record[$key] = date('Y-m-d',strtotime($record[$key]));
                        }
                        break;
                    case 'DATE':
                        if($record[$key] != '' && $record[$key] != '0000-00-00') {
                      $record[$key] = $record[$key];
                        }
                        break;
                    case 'DATETIME':
                        if($record[$key] > 0) {
                      $record[$key] = date('Y-m-d H:i:s',strtotime($record[$key]));
                        }
                        break;
@@ -360,6 +401,20 @@
         return $app->lng($msg);
      }   
   }
   function escapeArrayValues($search_values) {
       global $conf;
      $out = array();
      if(is_array($search_values)) {
         foreach($search_values as $key => $val) {
            $out[$key] = htmlentities($val,ENT_QUOTES,$conf["html_content_encoding"]);
         }
      }
      return $out;
   }
}