---

pgtable.php

Go to the documentation of this file.

<?php
############################################################################
#    Copyright (C) 2004 by Paolo Armani & Stefano Menegon                  #
#    paolo.armani@gmail.com   menegon@itc.it                               #
#                                                                          #
#    This program is free software; you can redistribute it and#or modify  #
#    it under the terms of the GNU Library General Public License as       #
#    published by the Free Software Foundation; either version 2 of the    #
#    License, or (at your option) any later version.                       #
#                                                                          #
#    This program is distributed in the hope that it will be useful,       #
#    but WITHOUT ANY WARRANTY; without even the implied warranty of        #
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         #
#    GNU General Public License for more details.                          #
#                                                                          #
#    You should have received a copy of the GNU Library General Public     #
#    License along with this program; if not, write to the                 #
#    Free Software Foundation, Inc.,                                       #
#    59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             #
############################################################################


//                                                                            //
/*! \brief the main class that is used to create the web interface to a postgresql database
 * \param $db Pgdb object, to interface with postgresql db
 * \param $pkey name of column to use as a pkey ($pkey[schema][table]=column)
 * \param $ref hash of references to other tables
 * \param $inh if a table inherits other tables
 * \param $perms not used, to manage perms in the future
 * \param $priority table priority, not used
 * \param $form html form informations
 * \param $actions array of action allowed (edit, insert....)
 * \param $operator array of operator for each pseudotype
 * \param $user not used
 * \param $group not used
 * \param $configSchema not used
 * \param $indexPriotity priority priority of column, if must be reorder from postgres column order ($priority[schema][table][column]=number)
 * \param $erros Pgmessage object
 * \param $messages Pgmessage object
 * \param $STRINGS array of strings, form multilanguage support
 */

class Pgtable{
  var $db; //pgdb object

  var $pkey; 
  var $ref;  //ref. to other tables
  var $inh; //inherited tables  
  var $perms; //table perms
  var $priority; //table priority

  var $form; //info to make html form 
  var $data; //array with keys in/out/old  for input/output data
  var $links;

  var $actions;  

  var $user;
  var $group;
  var $configSchema;

  var $operator;

  var $indexPriority; //[table][schema][field]=>priority, to order $forms etc.

  var $errors;
  var $messages;
  var $STRINGS;

  //                                                                            //
  /*! \brief initialize pgtable object
   * \param $db_conn valid postgresql connection (the returned value of pg_connect() function)
   * \param $configFile ini file in wich there are set some variables as icons urls etc.
   * \param $users not used
   * \param $group not used
   * \param $configSchema not used
   * \return
   */
  function Pgtable($db_conn, $configFile, $user='', $group='', $configSchema=''){
    $this->db=new Pgdb($db_conn);

    $this->user=$user;
    $this->group=$group;
    $this->configSchema=$configSchema;

    $this->form=array();
    $this->data=array();
    $this->perms=array();
    $this->priority=array();

    $this->errors = new Pgmessages(); 
    $this->messages = new Pgmessages(); 

    $this->data["in"]=array_merge($_GET, $_POST);

    $this->conf=parse_ini_file($configFile,true);

    $this->formName=$this->conf["html"]["formName"];
    $this->db->SQL_DEBUG=$this->conf["debug"]["SQL"];
    $this->db->filesDir=$this->conf["DbFiles"];

    $this->STRINGS=parse_ini_file($this->conf["strings"],true);

    $this->operator=array("text"=>array("~*"=>$this->STRINGS["match"],
                                        "!~*"=>$this->STRINGS["not_match"],
                                        "="=>$this->STRINGS["eq"],
                                        "!="=>$this->STRINGS["not_eq"],
                                        ">"=>$this->STRINGS["greater"],
                                        "<"=>$this->STRINGS["minor"],
                                        ">="=>$this->STRINGS["greater_eq"],
                                        "<="=>$this->STRINGS["minor_eq"]
                                        ),
                          "numeric"=>array("="=>$this->STRINGS["eq"],
                                           "!="=>$this->STRINGS["not_eq"],
                                           ">"=>$this->STRINGS["greater"],
                                           "<"=>$this->STRINGS["minor"],
                                           ">="=>$this->STRINGS["greater_eq"],
                                           "<="=>$this->STRINGS["minor_eq"]
                                           ),
                          "generic"=>array("="=>$this->STRINGS["eq"],
                                           "!="=>$this->STRINGS["not_eq"]
                                           ),
                          "geometry"=>array("&&"=>$this->STRINGS["in_box"]
                                            //,"="=>"vicino alla zona"
                                            )   
                          );

  }
  
  //                                                                            //
  /*! \brief reorder the table, how $indexPriority specify
   */
  function sort_field(){
    $this->set_priority();
  }

  //                                                                            //
  /*! \brief set the priority of a column and reorder columns
   * \param $priority integer vvalue
   * \param $schema schema of table
   * \param $table  table name
   * \param $field column name
   */
  function set_priority($priority=0, $schema=false, $table=false, $field=false){
    if($schema && $table && $field){
      $this->indexPriority[$schema][$table][$field] =$priority;
    }
    arsort($this->indexPriority);
  }

  //                                                                            //
  /*! \brief set default perms and priority number of a table
   * \param $schema schema of table
   * \param $table  table name
   */
  //set table and column perms, priority 
  //ocio!! parte è meglio farla nella classe pgdb
  function set_perms_priority( $tbSchema, $tbName){
    //setta permessi sulla tabella

    //table_perms (azioni possibili su tabella)
    /*
    setto valori default parametro (se non ci fosse nella tabella)

    SELECT * FROM ($this->useSchema?('"'.$this->configSchema.'"."'):'')table_perms where "schema"=pg_escape_string$tbSchema and "table"=  and ((username= or isnull ) and (groupname= or isnull)) order by username, groupname...
    foreach result 
      sovraschivo se definito il parametro
          quello di tutti gruppi e utenti(null null)
          quello del gruppo e di tutti gli utenti appartenentivi(null)
          quello del gruppo e dello utente 

    */
    //column_perms  (azioni possibili su singole colonne)

    //record_perms  (permessi singoli record, se bisogna applicarli)


   //setta permessi sulla colonna


    //setta priorità

   foreach($this->db->attribs[$tbSchema][$tbName] as $field=>$val){
     $attrib=&$this->db->attribs[$tbSchema][$tbName][$field];
     $this->indexPriority[$tbSchema][$tbName][$field]=$attrib["priority"];
   }
   //riordina per priorità....
   $this->sort_field();
    /* 
      $this->db->attribs[$tbSchema][$tbName][$key]["display"]
      $this->db->attribs[$tbSchema][$tbName][$key]["display"]=//select perms where (user IS NULL and group is null) or  (group= and user IS NULL ) or user=12 and user
         //array("new"=>$tmp, "edit"=>$tmp, "search"=>$tmp,"view"=>$tmp,"preSearch"=>$tmp);
    }
   */       
  }

  //                                                                            //
  /*! \brief set defaults variable when a new table is initialized
   * \param $tbSchema schema of table
   * \param $tbName  table name
   */
  function set_defaults($tbSchema, $tbName){

    //table

    //     $this->actions[$tbSchema][$tbName]=array('search','edit','insert','delete','view', 'export', 'preMultipleInsert', 'copy', 'modifySearch', 'multipleInsert');
     $this->actions[$tbSchema][$tbName]=array('search','edit','insert','delete','view', 'preMultipleInsert', 'copy', 'modifySearch', 'multipleInsert');

    $this->perms[$tbSchema][$tbName]=false;
    $this->piority[$tbSchema][$tbName]=false;
    

    //columns
    foreach($this->db->attribs[$tbSchema][$tbName] as $key=>$val){
      $field=&$this->db->attribs[$tbSchema][$tbName][$key]; 

      //      $field["display"]=array("new"=>true, "edit"=>true, "search"=>true,"view"=>true,"preSearch"=>true, "export"=>true);
      //      $field["priority"]=0;
      
      //form //to remove unused values
      $this->form[$tbSchema][$tbName][$key]=array(
                              "default"=>$field['adsrc'],
                              "type"=>$field['type'],
                              "name"=>$field['attname'],
                              "input-name"=>'['.$tbSchema.']['.$tbName.']['.$field['attname'].']',
                              "interpolate"=>true
                              );
      //    switch($field["type"])
      //NOTA: switch tipi dopo aver dato possibilita di configurare... quindi conf  operators, fDefault, interpolate etc... 
      //  CONFIURO ORA serve dato che si usa alter type, configuro SUBITO!!!
    }
  }

  //                                                                            //
  /*! \brief initialize a new table
   * \param $tbSchema schema of table
   * \param $tbName  table name
   * \param $pkey the primary key column of the table
   */
  function add_table($tbSchema, $tbName, $pkey=false){

    $this->pkey[$tbSchema][$tbName]=$pkey?$pkey:'oid'; //specific for postgres

    //read table structures
    //    $this->attribs[$tbSchema][$tbName]=
    $this->db->get_table_attributes($tbSchema, $tbName);
    
    //    array_to_html( $this->db->attribs);
    //references keys
    $this->ref[$tbSchema][$tbName]= $this->db->get_foreign_keys($tbSchema, $tbName);
    //inherited tables
    $this->inh[$tbSchema][$tbName]= $this->db->get_inh_tables($tbSchema, $tbName);

    $this->set_defaults($tbSchema, $tbName);
    $this->set_perms_priority($tbSchema, $tbName);
   
  }  

  //                                                                            //
  /*! \brief join an existent parent table with its childs, adding links down view/edit pages
   * \note if db is created with foeing key or references commandes, this is called automatically
   * \param $schemaParent schema of parent table
   * \param $parent parent table
   * \param $parentcol parent table column
   * \param $schemaChild schema of child table
   * \param $child child table
   * \param $childcol child table column
   */
  function join_child($schemaParent='public', $parent, $parentcol, $chemaChild='public', $child, $childcol){
    $this->ref[$schemaParent][$parent][$parentcol]["child"][]=array('table'=>$child, 'field'=>$childcol, 'schema'=>$schemaChild);
  }
 

  //                                                                            //
  /*! \brief join an existent child table with its parent,
   * \note if db is created with foeing key or references commandes, this is called automatically and a popup window is opened when necessary. In this case, for small parent references, it is somtimes better use a select list of possible values: see alter_parent() function for this. 
   * \param $schemaChild schema of child table
   * \param $child child table
   * \param $childcol child table column
   * \param $schemaParent schema of parent table
   * \param $parent parent table
   * \param $parentcol parent table column
   * \param $query valid sql query that select all valid childs 
   * \note $query must is a valid sql query that returns two columns, first mast be renamed (with AS sintax) as "OID" , the second as $field. First must correspond to values to insert in $tbName.$field and second as a label of this. 
   * \note $query must have no semicolon 
   * \param $type='popup' or 'select' : the first open a new window, the second make a select menu(DONT USE THIS FOR LONG TABLES!!|)
   * \param $when=array('search', 'view', 'preSearch', 'insert', 'edit')  when join
   */
  function join_parent($schemaChild='public', $child, $childcol, $schemaParent='public', $parent, $parentcol, $schema='public', $query="", $type="popup", $when=array('search', 'view', 'preSearch', 'new', 'edit')){
    $this->ref[$schemaChild][$child][$childcol]["parent"]=array('table'=>$parent, 'field'=>$parentcol, "schema"=>$schemaParent, "when"=>$when, "query"=>$query, "type"=>$type);
  }
  
  
  //                                                                            //
  /*! \brief change parent references attributes. Used to alter default values of prelinked tables(for examples type or to specify a query)
   * \param $schemaChild schema of child table
   * \param $child child table
   * \param $childcol child table column
   * \param $arr hash with this facoltative keys: table, field, query, type=>(popup or select),  when=>array('search', 'view', 'preSearch', 'insert', 'edit')
   * \note $query must is a valid sql query that returns two columns, first mast be renamed (with AS sintax) as "OID" , the second as $field. First must correspond to values to insert in $tbName.$field and second as a label of this. 
   * \note $query must have no semicolon 
   */
  function alter_parent($schemaChild, $child, $childcol, $arr=array()){
    $this->ref[$schemaChild][$child][$childcol]["parent"]=array_merge($this->ref[$schema][$child][$childcol]["parent"],$arr);
  }


  //                                                                            //
  /*! \brief called when neccesary from internal functions to set form defaults or similar
   * \param $when when this function is called (search, insert, edit....)
   */
  function auto_join($tbSchema, $tbName, $field, $when){
    if(is_array($this->ref[$tbSchema][$tbName][$field]["parent"]) && is_array($this->ref[$tbSchema][$tbName][$field]["parent"]["when"]) && in_array($when, $this->ref[$tbSchema][$tbName][$field]["parent"]["when"])){
      $ref_field=$this->ref[$tbSchema][$tbName][$field]["parent"]["field"];
      $ref_table=$this->ref[$tbSchema][$tbName][$field]["parent"]["table"];
      $query=$this->ref[$tbSchema][$tbName][$field]["parent"]["query"];
      if($query==''){
        $query='SELECT "'.pg_escape_string($ref[$field]["parent"]["field"]).'" AS "OID", "'.pg_escape_string($ref[$field]["parent"]["field"]).'" AS "'.pg_escape_string($field).'" FROM "';
        $query.=$this->db->useSchema?(pg_escape_string($tbSchema).'"."'):'';
        $query.=pg_escape_string($ref[$field]["parent"]["table"]).'" ORDER BY "OID"';
      }
     
      switch($this->ref[$tbSchema][$tbName][$field]["parent"]["type"]){
      case 'select':
        $this->form[$tbSchema][$tbName][$field]['values']=prepare_array_select($this->db->dbConn, $query);
        $this->form[$tbSchema][$tbName][$field]['type']='select';
        if($this->db->SQL_DEBUG) echo $query."<br>\n";
      break;
      default:
        $str0='['.urlencode($tbSchema).']['.urlencode($ref_table).']';
        $str1=$str0.'['.urlencode($ref_field).']';
        $this->form[$tbSchema][$tbName][$field]['ref_table']["search"]=$_SERVER["PHP_SELF"].'?tbInfo'.$str0.'[pkey]='.urlencode($ref_field).'&action='.$this->STRINGS["submit"]["search"]; //."&operator".$str1.'=%3D&value'.$str1."=";
        $this->form[$tbSchema][$tbName][$field]['ref_table']["view"]=$_SERVER["PHP_SELF"].'?tbInfo'.$str0.'[pkey]='.urlencode($ref_field).'&action='.$this->STRINGS["submit"]["view"]."&pkey".$str0."=";
        $this->form[$tbSchema][$tbName][$field]['type']='popup';
      }
    }
  }

  //                                                                            //
  /*! \brief called when neccesary from internal functions to set query with joins
   * \param $when when this function is called (search, insert, edit....)
   */
  function auto_join_query($tbSchema, $tbName, $when){
    
      if($when!='search' && $when!='view') return '';
      $ref=&$this->ref[$tbSchema][$tbName];
      $i=0;

      $schemaTable='"'.($this->db->useSchema?(pg_escape_string($tbSchema).'"."'):'').pg_escape_string($tbName).'"';
      $join=" FROM $schemaTable ";

      $select="SELECT ";
      if($this->pkey[$tbSchema][$table]=='' || $this->pkey[$tbSchema][$table]=='oid') $select.="$schemaTable.oid, ";
      $first=true;
      foreach($this->db->attribs[$tbSchema][$tbName] as $field=>$val){
        if($first) $first=false;
        else $select.=', ';

      
        if(is_array($ref[$field]["parent"]) && is_array($ref[$field]["parent"]["when"]) && in_array($when, $ref[$field]["parent"]["when"]) && $ref[$field]["parent"]["type"]=="select"){
          $this->form[$tbSchema][$tbName][$field]['type']='select';

          //set sub query
          if($ref[$field]["parent"]["query"]==''){
             $query='SELECT "'.pg_escape_string($ref[$field]["parent"]["field"]).'" AS "OID", "'.pg_escape_string($ref[$field]["parent"]["field"]).'" AS "'.pg_escape_string($field).'" FROM "';
             $query.=$this->db->useSchema?(pg_escape_string($tbSchema).'"."'):'';
             $query.=pg_escape_string($ref[$field]["parent"]["table"]).'" ORDER BY "OID"';
          }
          else{
             $query=$ref[$field]["parent"]["query"];
          }
          
          $join.=$this->db->useSchema
             ?(" LEFT JOIN (".$query.') AS "TMP'.$i.'" ON("'.$tbSchema.'"."'.$tbName.'"."'.pg_escape_string($field)."\"=\"TMP$i\".\"OID\") ")
             :(" LEFT JOIN (".$query.') AS "TMP'.$i.'" ON("'.$tbName.'"."'.pg_escape_string($field)."\"=\"TMP$i\".\"OID\") ");
          
          $select.="\"TMP$i\".\"".pg_escape_string($field).'"';
          $i++;
        }
        else{
          $select.='"'.pg_escape_string($field).'"';
        }
      }
      $select.=$join;
      
      if($i)  return $select;
      else return '';
  }
    

  //                                                                            //
  /*! \brief return appropriate html code for an operator 
   * \param $name html input name value
   * \param $type type of current field(int, text...)
   * \param $defVal='' default value
   */
  function operator($name, $type='', $defVal=false){
    switch($type){
        case 'text': 
        case 'varchar': 
          $src= html_select($name,$this->operator["text"],$defVal);
        break;
        case 'date':
        case 'time':
        case 'timestamp':
        case 'timestamptz':
        case 'float8':
        case 'int8':
        case 'int4':
        case 'oid':
          $src= html_select($name,$this->operator["numeric"],$defVal);
        break;
        case 'geometry':
          $src= html_select($name,$this->operator["geometry"],$defVal);
        break;
        default: $src= html_select($name,$this->operator["generic"],$defVal);
    }
    return $src;
  }

  //                                                                            //
  /*! \brief called when the html button 'Delete' is clicked
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   */
  function delete($tbSchema, $tbName){
    $this->parse_data_in($this->data["in"]["val"]); 

    $arr=&$this->data["in"];

    $numDelete=$numError=0;
    if(is_array($arr["pkey"][$tbSchema][$tbName]))
    foreach($arr["pkey"][$tbSchema][$tbName] as $num=>$pkey){

      $ok=$this->db->delete($tbSchema, $tbName, $pkey, $this->pkey[$tbSchema][$tbName]);

      if($ok===false){
        $numError++;
      }
      else{
        array_unset($arr["pkey"][$tbSchema][$tbName], $num);
        //if(is_array($arr["total"][$tbSchema][$tbName])) $arr["total"][$tbSchema][$tbName]--;
        $numDelete++;
      }
    }
    if($numError)  $this->errors->add($this->STRINGS["ERROR"].":  $numError ".$this->STRINGS["record_not_del"]);  //records NOT deleted
    if($numDelete)  $this->messages->add($this->STRINGS["NOTICE"].": $numDelete ".$this->STRINGS["record_del"]); //records deleted succesfull
  }
    


  //                                                                            //
  /*! \brief called when the html button 'Save' is clicked (only  save modified data)
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   */
  function update($tbSchema, $tbName){
    $this->parse_data_in($this->data["in"]["val"]); 

    $arr=&$this->data["in"];

    $numUpdate=$numError=0;
    if(is_array($arr["pkey"][$tbSchema][$tbName]))
    foreach($arr["pkey"][$tbSchema][$tbName] as $num=>$pkey){

      $pkey=$this->db->update($tbSchema, $tbName, $arr["val"][$tbSchema][$tbName][$num], $pkey, $this->pkey[$tbSchema][$tbName], $num);

      if($pkey===false){
        $numError++;
      }
      else{
        $arr["pkey"][$tbSchema][$tbName][$num]=$pkey;
        $numUpdate++;
      }
    }
    if($numError)  $this->errors->add($this->STRINGS["ERROR"].":  $numError ".$this->STRINGS["record_not_up"]);  //records NOT updated
    if($numUpdate)  $this->messages->add($this->STRINGS["NOTICE"].": $numUpdate ".$this->STRINGS["record_up"]); //records updated succesfull
  }
    

  //                                                                            //
  /*! \brief called when the html button 'Copy' is clicked 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return bidimensional array, that corespond to html table
   */
  function copy($tbSchema, $tbName){
    return $this->view_edit($tbSchema, $tbName, 'new', $this->data["in"]);
  }
    
  //                                                                            //
  /*! \brief called when the html button 'Insert' is clicked (only insert new data)
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   */
  function insert($tbSchema, $tbName){
    $this->parse_data_in($this->data["in"]["val"]); 

    $arr=&$this->data["in"];

    $numInsert=$numError=0;
    foreach($arr["val"][$tbSchema][$tbName] as $num=>$val){

      $pkey=$this->db->insert($tbSchema, $tbName, $arr["val"][$tbSchema][$tbName][$num], $this->pkey[$tbSchema][$tbName], $num);

      if($pkey===false){
        $numError++;
      }
      else{
        $arr["pkey"][$tbSchema][$tbName][$num]=$pkey;
        $numInsert++;
      }
    }
    if($numError)  $this->errors->add($this->STRINGS["ERROR"].":  $numError ".$this->STRINGS["record_not_in"]);  //records NOT inserted
    if($numInsert)  $this->messages->add($this->STRINGS["NOTICE"].": $numInsert ".$this->STRINGS["record_in"]); //records updated inserted
  }
    
  //                                                                            //
  /*! \brief called when the html button 'new search' is clicked 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return bidimensional array, that corespond to html table
   */
  function pre_search_new( $tbSchema, $tbName){
    return $this->pre_search( $tbSchema, $tbName, true);
  }

  //                                                                            //
  /*! \brief called when the html button 'modify search' is clicked 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return bidimensional array, that corespond to html table
   */
  function pre_search_modify( $tbSchema, $tbName){
    return $this->pre_search( $tbSchema, $tbName, false);
  }

  //                                                                            //
  /*! \brief called when frrom pre_search_modify  and pre_search_new functions 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $new if is a new query
   * \return bidimensional array, that corespopnd to html table
   */
  function pre_search( $tbSchema, $tbName, $new=true){
    //set data[out] array
    foreach($this->indexPriority[$tbSchema][$tbName] as $field=>$priority){
      if ($this->db->attribs[$tbSchema][$tbName][$field]["display"]["preSearch"]){

        if($new || !is_array($this->data["in"]["s"][$tbSchema][$tbName][$field])) $max=0;
        else $max=count($this->data["in"]["s"][$tbSchema][$tbName][$field]);

        for($i=0; $i<=$max; $i++){
          $this->data["out"][$tbSchema][$tbName][$i][$field]='';
        }
      }
    }

    $this->parse_data_out('preSearch', $tbSchema, $tbName); 
    return $this->src[$tbSchema][$tbName]; 
  }
  

  //                                                                            //
  /*! \brief called when the html button 'View' is clicked 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return bidimensional array, that corespond to html table
   */
  function view($tbSchema, $tbName){
    return $this->view_edit($tbSchema, $tbName, 'view', $this->data["in"]);
  }

  //                                                                            //
  /*! \brief called when the html button 'edit' or 'insert'  is clicked 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return bidimensional array, that corespond to html table
   */
  function edit($tbSchema, $tbName){
    return $this->view_edit($tbSchema, $tbName, 'edit', $this->data["in"]);
  }


  //                                                                            //
  /*! \brief called when the html button 'new insert' is clicked 
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return bidimensional array, that corespond to html table
   */
  function pre_insert($tbSchema, $tbName){
    //number of inputs
    $lines=$this->data["in"]["numInsert"][$tbSchema][$tbName];
    $lines=$lines?$lines:1;

    $this->single[$tbSchema][$tbName]=($lines==1);

    //set data[out] array
    for($i=1; $i<=$lines; $i++){
      foreach($this->indexPriority[$tbSchema][$tbName] as $field=>$priority){
        if ($this->db->attribs[$tbSchema][$tbName][$field]["display"]["new"]){
          if($i==1) $this->src[$tbSchema][$tbName]['___field'][$field]=$field;
          $this->data["out"][$tbSchema][$tbName][$i][$field]='';
        }
      }
    }

    $this->parse_data_out("new", $tbSchema, $tbName); 

    return $this->src[$tbSchema][$tbName]; 
  }

  //                                                                            //
  /*! \brief called from others functions
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $when when is called (new, edit, search,...)
   * \param $datain input data ($_POST or $_GET)
   * \return bidimensional array, that corespopnd to html table
   */
  function view_edit($tbSchema, $tbName, $when, &$datain){
    $pkey=$this->pkey[$tbSchema][$tbName];
    $ref=&$this->ref[$tbSchema][$tbName];

    if(!is_array($datain["pkey"][$tbSchema][$tbName])) return;
    $query=$this->auto_join_query($tbSchema, $tbName, $when);

    $lines=0;
    foreach($datain["pkey"][$tbSchema][$tbName] as $num=>$pkeyVal){
      $arr=$this->db->set_value_from_pkey($tbSchema, $tbName, $pkeyVal, $pkey, $query);
      $fields=0;
      foreach($this->indexPriority[$tbSchema][$tbName] as $field=>$priority){
        if ($this->db->attribs[$tbSchema][$tbName][$field]["display"][$when]){
          $this->data["out"][$tbSchema][$tbName][$num][$field]=$arr[$field];

          //added to manage files 
          if(array_key_exists('file',$this->db->attribs[$tbSchema][$tbName][$field]))
            $this->data["out"][$tbSchema][$tbName][$num][$field]=($when!='new')?$arr:'';


          //added to manage child references 
          if($when!="new" && is_array($ref[$field]["child"])){
            foreach($ref[$field]["child"] as $val){
              $refLink[$num][]=array('schema'=>$tbSchema, 'table'=>$val["table"], "field"=>$val["field"], "val"=>$arr[$field]);
            }
          }
          
          //add links for search
          if($lines==0){
            if($when!="new") $this->src[$tbSchema][$tbName]['___field'][' ']='';
            if ($when=='search'){
              $this->src[$tbSchema][$tbName]['___field'][$field]=$this->order($tbSchema, $tbName, $field);
            }
            else{
              $this->src[$tbSchema][$tbName]['___field'][$field]=$field;
            }
          }

          if(!$fields){
            $pkeys[$num]=$pkeyVal;
          }

          $fields++;
        }
      }
      $lines++;
    }
    

    $this->single[$tbSchema][$tbName]=($lines==1);

    if($when!='new' & $lines>=1){
      if ($lines>1 &&   !(array_key_exists("ref_field",$this->data["in"]["tbInfo"][$tbSchema][$tbName]))){
        $js="<script language=\"javascript\">\nfunction checkAll(form){\n";
        foreach($pkeys as $num=>$pkeyVal){
          $this->src[$tbSchema][$tbName][$num][' ']=$this->actions($tbSchema, $tbName, $pkey, $num, $pkeyVal, $refLink[$num]);
          $input="pkey[$tbSchema][$tbName][$num]";

          $input=addslashes($input);
          //dont works with text browser links !!!
          $js.="form.elements['$input'].checked=form.elements['___checkAll'].checked;\n";
        }
        $js.="\n};\n</script>\n";
        
        $old_search=arr_to_hidden($this->links[$tbSchema][$tbName]["search"]);
        
        $html=$js.'<h5><input type="checkbox" name="___checkAll" onclick="checkAll(this.form);" checked />'.$this->STRINGS["select_all"].$old_search.'</h5>';
        
        $this->src[$tbSchema][$tbName]['___field'][' ']=$html;
      }
      else{
        if ($when=='search'){
          $old_search=arr_to_hidden($this->links[$tbSchema][$tbName]["search"]);
          $this->src[$tbSchema][$tbName][$num][' ']='<input type="hidden" name="tbInfo['.$tbSchema.']['.$tbName.'][single]" value="1" />'.$old_search;
        }
        
        foreach($pkeys as $num=>$pkeyVal){
          $this->src[$tbSchema][$tbName][$num][' '].=$this->actions($tbSchema, $tbName, $pkey, $num,  $pkeyVal, $refLink[$num], "hidden");
        }
      }
    }


    
    $this->parse_data_out($when, $tbSchema, $tbName); 
    return $this->src[$tbSchema][$tbName]; 
  }

  
  //                                                                            //
  /*! \brief for order links in search table
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $field column name
   * \return html code
   */
  function order($tbSchema, $tbName, $field){
    //only get, POST to make
    //links immagini da sistemare in base a config
    $thisOrder=($this->links[$tbSchema][$tbName]["record"]==$field);
    $orderDesc=($this->links[$tbSchema][$tbName]["order"][$field]["order"][$tbSchema][$tbName]=='DESC');
    $link=$_SERVER["PHP_SELF"].'?'.arr_to_url($this->links[$tbSchema][$tbName]["order"][$field]);
    $title=$this->STRINGS["view_order"].($orderDesc?$this->STRINGS["biggest"]:$this->STRINGS["smallest"]);

    $img=$thisOrder?'':'1';
    $img=$orderDesc ? $this->conf["Images"]['up'.$img] : $this->conf["Images"]['down'.$img];

    $html=$field.'<div id="searchIcon"><a href="'.$link.'"><img target="'.$title.'" title="'.$title.'" src="'.$img.'"></a></div>';
    
    //$tmp_arr[$key]=$key.'<div id="searchIcon"><form method="POST">'.$this->search_arr["order-post"][$tbSchema][$table][$key].' <input type="submit"  title="Visulizza in ordine '.($this->search_arr["order-asc"][$tbSchema][$table][$key]?'crescente':'decrescente').'" value="'.($this->search_arr["this-order"][$tbSchema][$table][$key]?($this->search_arr["order-asc"][$tbSchema][$table][$key]?'>>':'<<'):'Ordina').'" /></form></div>';
    return $html;
  }

  //                                                                            //
  /*! \brief add links for each records to modify, delete, view and child subtables if exists
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $field column name
   * \param $num line number of current sets of records
   * \param $pkey pkey value of current record
   * \param $refLink hash to manage refernces to subtables 
   * \param $type="checkbox" if use a checkbox or a hidden input type
   * \return html code
   */
  function actions($tbSchema, $tbName, $field, $num, $pkey, $refLink=array(), $type="checkbox"){
    if(array_key_exists("ref_field",$this->data["in"]["tbInfo"][$tbSchema][$tbName])){
      $tbInfo=&$this->data["in"]["tbInfo"][$tbSchema][$tbName];
      $onclick="opener.document.".$tbInfo["ref_inputForm"].".elements['".$tbInfo["ref_inputInput"]."'].value='".$pkey."'; window.close();";
      $icons='<div id="searchIcon"><a href="javascript:'.$onclick.'" ><img title="'.$this->STRINGS["select"].'"  target="'.$this->STRINGS["select"].'" src="'.$this->conf["Images"]["select"].'"  class="searchIcon" /></a></div>';
      return $icons;
    }

    if($type=="checkbox")
      $checkBox= "<input type=\"checkbox\" name=\"pkey[$tbSchema][$tbName][$num]\" value=\"$pkey\" checked /> ";
    else
      $checkBox= "<input type=\"hidden\" name=\"pkey[$tbSchema][$tbName][$num]\" value=\"$pkey\"/> ";

    $tmp=$this->links[$tbSchema][$tbName]["search"];
    $tmp["tbInfo"]=$this->data["in"]["tbInfo"];
    $tmp["pkey"][$tbSchema][$tbName][0]=$pkey;
    $tmp["action"]=$this->STRINGS["submit"]["delete"];
    
    $tmp1["tbInfo"]=$this->data["in"]["tbInfo"];
    $tmp1["pkey"][$tbSchema][$tbName][0]=$pkey;
    $tmp1["action"]=$this->STRINGS["submit"]["view"];

    $tmp2["tbInfo"]=$this->data["in"]["tbInfo"];
    $tmp2["pkey"][$tbSchema][$tbName][0]=$pkey;
    $tmp2["action"]=$this->STRINGS["submit"]["edit"];

    $tmp3["tbInfo"]=$this->data["in"]["tbInfo"];
    $tmp3["action"]=
    $tmp3["pkey"][$tbSchema][$tbName][0]=$pkey;

    $icons=(in_array('view',$this->actions[$tbSchema][$tbName])) ? ('<a href="'.$_SERVER["PHP_SELF"]."?".arr_to_url($tmp1).'"><img title="'.$this->STRINGS["submit"]["view"].'" target="'.$this->STRINGS["submit"]["view"].'" src="'.$this->conf["Images"]["view"].'" class="searchIcon"></a>') :'';
    $icons.=(in_array('edit',$this->actions[$tbSchema][$tbName])) ? ('<a href="'.$_SERVER["PHP_SELF"]."?".arr_to_url($tmp2).'"><img title="'.$this->STRINGS["submit"]["edit"].'" target="'.$this->STRINGS["submit"]["edit"].'" src="'.$this->conf["Images"]["edit"].'" class="searchIcon"></a>') :'';
    $icons.=(in_array('delete',$this->actions[$tbSchema][$tbName])) ? ('<a href="'.$_SERVER["PHP_SELF"]."?".arr_to_url($tmp).'" onclick="return confirm(\''.$this->STRINGS["confirm_rm_one"].'\');"><img title="'.$this->STRINGS["submit"]["delete"].'" target="'.$this->STRINGS["submit"]["delete"].'" src="'.$this->conf["Images"]["delete"].'" class="searchIcon"></a>') :'';


    $tableRef='';
    $i=true;
    if(is_array($refLink)){
      foreach($refLink as $num1=>$val1){
        if($i) $tableRef='<br>'.$this->STRINGS["element_subtables"];
        $i=false;
        $schemaTable="[".urlencode($val1["schema"])."][".urlencode($val1["table"])."]";
        $fieldUrl="[".urlencode($val1["field"])."][0]"; 
        $url=$_SERVER["PHP_SELF"]."?tbInfo".$schemaTable."[pkey]=&s".$schemaTable.$fieldUrl."=".urlencode($val1["val"])."&op".$schemaTable.$fieldUrl."=".urlencode("=")."&action=".urlencode($this->STRINGS["submit"]["search"]);

        $tableRef.='<br><a href="'.$url.'" target="_blank">'.htmlentities($val1["table"]).'</a>';  
      }
    }

    $html='<div id="searchIcon">'.$checkBox.$icons.'</div>'.$tableRef;
    return $html;
  }

  //                                                                            //
  /*! \brief called when the html button 'export' is clicked, export current selected records in dbf
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \return file link
   */
  function export( $tbSchema, $tbName){
    $this->messages->add($this->STRINGS["exporting"]);
    $inherited=&$this->data["in"]["inherited"][$tbSchema][$tbName];
    $inherited=($inherited=='0')?0:1;

    $query=$this->db->selectClause($tbSchema, $tbName, "*", $inherited);
    $query.=$this->search($tbSchema, $tbName, true);

    $file=$this->db->export($query);

    return $file; 
  }

  //                                                                            //
  /*! \brief called when the html button 'search' is clicked
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $export=false
   * \return bidimensional array corespond to html table if $export=false, sql query if $export=true
   */
  function search( $tbSchema, $tbName, $export=false){
    $this->parse_data_in($this->data["in"]["s"],'search'); 

    $value=&$this->data["in"]["s"][$tbSchema][$tbName];
    $op=&$this->data["in"]["op"][$tbSchema][$tbName];
    $logic=&$this->data["in"]["logic"][$tbSchema][$tbName];
    $mainLogic=&$this->data["in"]["mainLogic"][$tbSchema][$tbName];
    $offset=$this->data["in"]["offset"][$tbSchema][$tbName];
    //    $total=$this->data["in"]["total"][$tbSchema][$tbName];
    $limit=&$this->data["in"]["limit"][$tbSchema][$tbName];
    $record=$this->data["in"]["record"][$tbSchema][$tbName];
    $order=$this->data["in"]["order"][$tbSchema][$tbName];
    $inherited=&$this->data["in"]["inherited"][$tbSchema][$tbName];

    $inherited=($inherited=='0')?0:1;
    // SET WHERE CONDITION
    // UNSET VOID VARIABLE
    $where_sql='';
    $first_levelClause=false;
    if(is_array($value))
    foreach($value as $field=>$val1){

      $second_levelClause=false;
      if(is_array($value[$field]))
      foreach($value[$field] as $num=>$val){

        if($val){
          
          if(!$second_levelClause){
            if($first_levelClause){
              $where_sql.="$mainLogic ("; 
            }
            else{
              $where_sql.="(";
            }
          }
          else{
            $where_sql.=$logic[$field][$num];
          }

          $where_sql.=$this->db->whereClause($tbSchema, $tbName, $field, $val, $op[$field][$num]);

          $first_levelClause=$second_levelClause=true;

        }
        else{
          array_unset($value[$field], $num);
          array_unset($op[$field], $num);
          array_unset($logic[$field], $num);
        }
      }
      
      if(!$second_levelClause){
        array_unset($value[$field], $num);
        array_unset($op[$field], $num);
        array_unset($logic[$field], $num);
      }
      else{
        $where_sql.=') ';
      }
      
    }

    if($where_sql){
      $where_sql=' WHERE '.$where_sql;
    }


    //ORDER
    // occio !!! problema order con join!!!! così non funziona!!! devo fare join anche sul select delle pkey
    if($record && $order){
      $order_sql=$this->db->orderClause($tbSchema, $tbName, $record, $order);
    }
    else{
      $order_sql='';
    }

    if ($export) return($where_sql.$order_sql);  
        
    //LIMIT & OFFSET & TOTAL records number
    if(!($limit>=1 && $limit<="100")){
      $limit=10;
    }
    
    //    if(!$total){
    $time=getmicrotime();
    $total=$this->db->numRecords($tbSchema, $tbName, $inherited, $where_sql);
    $time=round(getmicrotime()-$time,3);
    $this->messages->add("$total ".$this->STRINGS["found_in"]." $time ".$this->STRINGS["seconds"]);
    //    }

    if($offset!=''){
      if($offset<=$total){
        $offset_sql=$offset-1;
      }
      else
        $offset_sql=$offset-$limit-1;
    }
    else{
      $offset=1;
      $offset_sql=0;
    }

    $limit_sql=$this->db->limitClause($limit, $offset_sql);

    //select pkeys of searched records 

    $select_sql=$this->db->selectClause($tbSchema, $tbName, $this->pkey[$tbSchema][$tbName], $inherited);
    $query=$select_sql.$where_sql.$order_sql.$limit_sql;

    //    $time=getmicrotime();
    $tmp=transpose($this->db->select($query));
    //    $time=round(getmicrotime()-$time,3);
    //    $this->messages->add("$total records found in $time seconds.");

    $pkeys["pkey"][$tbSchema][$tbName]=$tmp[ $this->pkey[$tbSchema][$tbName] ];

    //set $this->links, needed to remember current research parameters to continue 
    //query in fallows researchs or to optimize it (oreder, next result page...)
    

    $x=$this->data["in"];
    $tmp=array("s"=>$x["s"],
               "op"=>$x["op"],
               "logic"=>$x["logic"],
               "mainLogic"=>$x["mainLogic"], 
               "limit"=>$x["limit"],
               //              "total"=>$x["total"],
               "inherited"=>$x["inherited"],
               "action"=>$this->STRINGS["submit"]["search"],// solo per bottoni order e search_bar
               "offset"=>$x["offset"], //no per search_bar
               "order"=>$x["order"],//  no per order
               "record"=>$x["record"], //no per order
               "tbInfo"=>$x["tbInfo"],  //Serve??????
               );
    

    //    $tmp["total"][$tbSchema][$tbName]=$total;

    $links=&$this->links[$tbSchema][$tbName];

    $links["offset"]=$offset;
    $links["limit"]=$limit;
    $links["record"]=$record;
    $links["total"]=$total;
    

    //search links
    $links["search"]=$tmp;
    array_unset($links["search"], "action");

    //searchBar links
    $links["searchBar"]=$tmp;
    array_unset($links["searchBar"]["offset"][$tbSchema], $tbName);

    //order links
    $attribs=&$this->db->attribs[$tbSchema][$tbName];
    foreach($attribs as $field=>$val){
      $links["order"][$field]=$tmp;
      $links["order"][$field]["offset"][$tbSchema][$tbName]=1; 
      $links["order"][$field]["order"][$tbSchema][$tbName]=($record==$field && $order=='ASC')?'DESC':'ASC';
      $links["order"][$field]["record"][$tbSchema][$tbName]=$val["attname"];
    }



#    echo array_to_html($links["order"]);

    
    return ($this->view_edit($tbSchema, $tbName, 'search', $pkeys));
    
  }
    


  //                                                                            //
  /*! \brief parse submitted data 
   * \note  because of recursion of query, the fallowing functions must works also if is called more than once on the same data : so dont coud for example add a constant string to a parameter because in  some cases it adds more times the same string....
   * \param $arr hash to parse
   * \param $when when is calles(search, edit, insert...)
   */
  function parse_data_in(&$arr,$when=''){
    if (is_array($arr)){
    foreach($arr as $tbSchema=> $arr1){
      if (is_array($arr1)){
      foreach($arr1 as $tbName=> $arr2){
        if (is_array($arr2)){
        foreach($arr2 as $num=> $record){
          if (is_array($record)){
          foreach($record as $field=> $val){
            if(is_array($val)){
              if(array_key_exists('year',$val) && array_key_exists('month',$val) && array_key_exists('day',$val)){
                if($val['year'] && $val['month'] && $val['day']){
                  $arr[$tbSchema][$tbName][$num][$field]=$val['year'].'-'.$val['month'].'-'.$val['day']; 
                  if((array_key_exists('hour',$val) && array_key_exists('minute',$val)) && $val['hour']!='' && $val['minute']!='')
                    $arr[$tbSchema][$tbName][$num][$field].=' '.$val['hour'].':'.$val['minute'];                      
                  //to add fuso orario for  type 'timestamptz'
                }
                else{
                  $arr[$tbSchema][$tbName][$num][$field]='';                  
                }
              }  
              elseif(array_key_exists('hour',$val) && array_key_exists('minute',$val)){
                if($val['hour']!='' && $val['minute']!='')
                  $arr[$tbSchema][$tbName][$num][$field]=$val['hour'].':'.$val['minute'];                     
                //to add fuso orario for  type 'timestamptz'
              }
              else{
                //dont works with files delete button
                //$arr[$tbSchema][$tbName][$num][$field]='';                  
              }
            }
            else{
             
              $field1= ($when=='search') ? $num : $field;
              switch($this->db->attribs[$tbSchema][$tbName][$field1]["type"]){
              case 'float8':
                //convert comma into dot for numbers 
                $arr[$tbSchema][$tbName][$num][$field]=str_replace(",", ".", $val);
              break;
                /*
                Dont work because of recursion of query... so I modify pgdb
              case 'geometry':
                if($val){
                  if($this->db->attribs[$tbSchema][$tbName][$field1]['geosrid']){
                    $arr[$tbSchema][$tbName][$num][$field]= "transform('".pg_escape_string($val)."',".$this->db->attribs[$tbSchema][$tbName][$field1]['geosrid'].")";
                  }
                  else{
                    $arr[$tbSchema][$tbName][$num][$field]=("'".$val."'");
                  }
                }
                */
                break;
              default:
                $arr[$tbSchema][$tbName][$num][$field]=trim($arr[$tbSchema][$tbName][$num][$field]);
              }
            }
          }}
        }}
      }}
    }}
  }
                
  //                                                                            //
  /*! \brief parse output data hash, from a bidimensional array of values(corespond to a part of postgres table), create a html table structured in a bidimensinal hash 
   * \param $when when is calles(search, edit, insert...)
   * \param $tbSchema schema of table
   * \param $tbName  table name
   */
  function parse_data_out($when, $tbSchema, $tbName){
    $first=true;
    if(is_array($this->data["out"][$tbSchema][$tbName]))
    foreach($this->data["out"][$tbSchema][$tbName] as $num=>$record){
      foreach($this->data["out"][$tbSchema][$tbName][$num] as $field=>$val){ 
        //   if keyexist(field, separator[table][schema]) ->  aggiungi separatore

        //set table references
        if($first) $this->auto_join($tbSchema, $tbName, $field, $when);
        
        $form=&$this->form[$tbSchema][$tbName][$field];
        $attribs=&$this->db->attribs[$tbSchema][$tbName][$field];
        $src=&$this->src[$tbSchema][$tbName][$num][$field];
        $value='';

        //set value of each field(if is an insert form is db default value, otherwise...) and comparison operators if presearch and edit/delete links if select
        switch($when){
        case 'preSearch':
          if($num!=0){
            $logic=($this->data["in"]["logic"][$tbSchema][$tbName][$field][$num]!='')? $this->data["in"]["logic"][$tbSchema][$tbName][$field][$num] : 'AND';
            $src= html_select("logic[$tbSchema][$tbName][$field][$num]", array("AND"=>$this->STRINGS["_and"],"OR"=>$this->STRINGS["_or"], "AND NOT"=>$this->STRINGS["and_not"], "OR NOT"=>$this->STRINGS["or_not"]), $logic,1,0,1);
          }
          $src.=$this->operator("op[$tbSchema][$tbName][$field][$num]", $form["type"],$this->data["in"]["op"][$tbSchema][$tbName][$field][$num]);
          $value=$this->data["in"]["s"][$tbSchema][$tbName][$field][$num];
          break;
        case 'new':
          //nel caso di copia, sovrascrivere solo le chiavi non nulle..... ma per copia non funziona... da sistemare
          if($this->data["out"][$tbSchema][$tbName][$num][$field]=='' && $attribs['adsrc']!=''){
            $tmp =$this->db->select('SELECT '.$attribs['adsrc'].";");
            $value=current($tmp[0]);
          }
          else{
            $value=$this->data["out"][$tbSchema][$tbName][$num][$field];
          }
          break;
        default:
          $value=$this->data["out"][$tbSchema][$tbName][$num][$field];
        }

        //create html
        switch($when){
        case 'view':
        case 'search':
          $src.=$this->view_sub($tbSchema, $tbName, $field, $num, $when, $value);
        break;
        default:
          $src.=$this->form_sub($tbSchema, $tbName, $field, $num, $when, $value);
        }
        $fieldNum++;
      }
      $first=false;
      $rowNum++;
    }
  }


  //                                                                            //
  /*! \brief called for each field, to make an appropriate input form
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $field column name
   * \param $num line number of current sets of records
   * \param $when when is calles(search, edit, insert...)
   * \param $def current value of the field  
   */
  function form_sub($tbSchema, $tbName, $field, $num, $when, $def){
    
    $name=($when=="preSearch")?'s':'val'; //form root name
    $form=&$this->form[$tbSchema][$tbName][$field];
    $attribs=&$this->db->attribs[$tbSchema][$tbName][$field];
    $refTable=&$this->ref[$tbSchema][$tbName][$field];
    
    if($when=="preSearch"){
      $name=$name."[$tbSchema][$tbName][$field][$num]";
    }
    else{
      $name=$name."[$tbSchema][$tbName][$num][$field]";
    }

    $src='';
    switch($form["type"]){
    case 'bool': 
      $src= html_select($name,array("t"=>$this->STRINGS["_yes"], "f"=>$this->STRINGS["_no"]), $def,1,0,0);
    break;
    case 'select':
      $src= html_select($name,$form["values"] ,$def,1,0,0) ;
    break;
    case 'popup':
      $refTbInfo='&tbInfo['.urlencode($tbSchema).']['.urlencode($this->ref[$tbSchema][$tbName][$field]["parent"]["table"]).']';
      $url=$form["ref_table"]["search"].$refTbInfo."[ref_field]=".urlencode($this->ref[$tbSchema][$tbName][$field]["parent"]["field"]).$refTbInfo."[ref_inputInput]=".urlencode($name).$refTbInfo."[ref_inputForm]=".$this->formName;
      $src='<input type="text" size="40" name="'.$name.'" value="'.$def.'" />';// onclick="window.open(\''.$url.'\');" />';
      $src.='<input type="button" onclick="window.open(\''.$url.'\');" value="'.$this->STRINGS["select"].'" />';

    break;
    case 'date':
      $src= date_select($name,$def,0) ;
    break;
    case 'time':
      $src= time_select($name,$def,0) ;
    break;
    case 'timestamptz':
      //to add fuso orario
      //      $src= html_select($name[""],$date,0) ;
    case 'timestamp':
      list( $date, $time)=split(' ', $def);
      $src.= date_select($name,$date,0) ;
      $src.= time_select($name,$time,0) ;
      break;

    case 'file':
    case 'lobject':
      $linkName="<b>".$def[$attribs["file"]["name_col"]]."</b>";
      if($attribs["file"]["size_col"]) $linkName.="<br><b>Size:</b> ".$def[$attribs["file"]["size_col"]];        
      if($attribs["file"]["mime_type_col"]) $linkName.="<br><b>Type:</b> ".$def[$attribs["file"]["mime_type_col"]];      
      
      $mimeType=$def[$attribs["file"]["mime_type_col"]];
      $link=$this->file_url($def[$field], $form["type"]=='lobject', $mimeType);
      $thumbnail=$this->file_url($def[$attribs["file"]["thumbnail_col"]], $form["type"]=='lobject', 'image/jpeg');
    
      $src.=$this->file_view($linkName, $link, $thumbnail, $mimeType);

      if($link && !$this->db->attribs[$tbSchema][$tbName][$field]["attnotnull"]) $src.='<br><input name="'.$name.'[del]" type="checkbox" value="1" />'.$this->STRINGS["delete"];
      $src.='<br><input type="file" size="10" name="'.$name.'[file]" />';
    break;
    /*
    case 'geometry':
      if($def){
        list($minx, $miny, $minz, $maxx, $maxy, $maxz)=minExtension(getExtension($def), 500);
        $stringADD1="&mapext="."$minx+$miny+$maxx+$maxy";
        $stringADD2="&minx=$minx&miny=$miny&maxx=$maxx&maxy=$maxy";
      }
      $geoType=($name=='value'?'BOX3D':$attribs['geotype']);

      $ref_map="/mapserv.php?mode=reference&map_size=350%20350".$stringADD1;
      $map='/mappa_popup.php?geometryType='.$geoType.'&formName='.urlencode($name).($def?'&projection='.$attribs['geosrid'].$stringADD2."&scale=10000":'');     
      $src='<a onclick="window.open(\''.$map.'\',\'Mappa\',\'width=620,height=550, toolbar=no, status=yes, resizable=yes, menubar=no, scrolls=no\')"><img name="img'.$name.$form["input-name"].'" src="'.$ref_map.'" class="thumbnail" /></a>';
     
      $src.='<input type="hidden" size="40" name="'.$name.'[data]" value="'.$def.'" />';
      
      //      $this->warnings( $map);
      break;    

      */
    default: 
      $tmp=(in_array($attribs["type"],array('float8', 'int4', 'int8', 'oid')) && $form["type"]!='select') ? 'style="text-align: right;" ' :'';
      $src='<input type="text" size="40" '.$tmp.'name="'.$name.'" value="'.($form["interpolate"]?htmlentities($def):$def).'" />';
    }

    if($when=='edit'){
      $src.='<input type="hidden" name="old'."[$tbSchema][$tbName][$num][$field]".'" value="'.($form["interpolate"]?htmlentities($def):$def).'" />';
    }

    return $src;
  }
  

  //                                                                            //
  /*! \brief called for each field, to view its value in an appropriate parsed mode
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $field column name
   * \param $num line number of current sets of records
   * \param $when when is calles(search, edit, insert...)
   * \param $def current value of the field  
   */
  function view_sub($tbSchema, $tbName, $field, $num, $when, $def){

    $name='val'; //form root name
    $form=&$this->form[$tbSchema][$tbName][$field];
    $attribs=&$this->db->attribs[$tbSchema][$tbName][$field];
    $refTable=&$this->ref[$tbSchema][$tbName][$field];
   
    $src='';
    switch($form["type"]){
    case 'bool': 
      if ($def=='t'){$src=$this->STRINGS["_yes"];}
      elseif($def=='f'){$src=$this->STRINGS["_no"];}
      break;

    case 'popup':  
      $ref='['.urlencode($tbSchema).']['.urlencode($this->ref[$tbSchema][$tbName][$field]["parent"]["table"]).']';
      $pkeyField=urlencode($this->ref[$tbSchema][$tbName][$field]["parent"]["field"]);
      $pkey=urlencode($def);                       
      $url="tbInfo".$ref."[pkey]=$pkeyField&pkey".$ref."[0]=$pkey&action=".$this->STRINGS["submit"]["view"];
      $src='<a href="?'.$url.'" target="_blank" title="'.$this->STRINGS["references_view"].'">'.($form["interpolate"]?htmlentities($def):$def).'</a>';
    break;
    case 'file': 
    case 'lobject': 
      $linkName="<b>".$def[$attribs["file"]["name_col"]]."</b>";
      if($attribs["file"]["size_col"]) $linkName.="<br><b>".$this->STRINGS["size"].":</b> ".$def[$attribs["file"]["size_col"]];  
      if($attribs["file"]["mime_type_col"]) $linkName.="<br><b>".$this->STRINGS["type"].":</b> ".$def[$attribs["file"]["mime_type_col"]];        
      
      $mimeType=$def[$attribs["file"]["mime_type_col"]];
      $link=$this->file_url($def[$field], $form["type"]=='lobject', $mimeType);
      $thumbnail=$this->file_url($def[$attribs["file"]["thumbnail_col"]], $form["type"]=='lobject', 'image/jpeg');
    
      $src.=$this->file_view($linkName, $link, $thumbnail, $mimeType);
      break;
      /*
    case 'geometry':
      
        if($def){
          list($minx, $miny, $minz, $maxx, $maxy, $maxz)=minExtension(getExtension($def), 500);
          $stringADD1="&mapext="."$minx+$miny+$maxx+$maxy";
          $stringADD2="&minx=$minx&miny=$miny&maxx=$maxx&maxy=$maxy";
        }
      
        $ref_map="/mapserv.php?mode=reference&map_size=350%20350".$stringADD1;
        $map='/mappa_popup.php?'.($def?'&projection='.$attribs['geosrid'].$stringADD2."&scale=10000":'');       
        $src='<a onclick="window.open(\''.$map.'\',\'Mappa\',\'width=620,height=550, toolbar=no, status=yes, resizable=yes, menubar=no, scrolls=no\')"><img name="img'.$name.$this->form[$num]["input-name"].'" src="'.$ref_map.'" class="thumbnail" /></a>';
        //      $this->warnings( $map);

        break;
      */
      default: 
        if(in_array($attribs["type"],array('float8', 'int4', 'int8', 'oid')) && $form["type"]!='select'){
          $src='<div style="text-align: right; max-width: 150px;">'.$def.'</div>';              
        }
        else{
          $src= $form["interpolate"] ? htmlentities($def) : $def;
        }
      }
    return $src;
  }


  //                                                                            //
  /*! \brief set when a column is displayed or not
   * \note to call before alter_type if alter_type is called!!!
   * \param $tbSchema schema name of the table
   * \param $tbName table name
   * \param $field column name, or arrays of column names, or false if all the columns 
   * \param $value=true if true view selected columns, if false hide they
   * \param $when when apply current changes (new, edit, search...) it could be an array
   */
  function alter_display($schema, $table, $fields=false, $value=true,  $when=array("new", "edit", "search", "view", "preSearch", "export")){
    if(!is_array($when)) $when=array($when);
    
    if($fields){
      if(!is_array($fields)) $fields=array($fields);
    }
    else{
      $fields=array_keys($this->db->attribs[$schema][$table]);
    }

    foreach($fields as $key1=>$field){
      foreach($when as $key=>$val1){
        $this->db->attribs[$schema][$table][$field]["display"][$val1]=$value;
      }
    }
  }


  //                                                                            //
  /*! \brief change type of a field
   *  \param $tbSchema='public' schema name
   *  \param $tbName table name
   *  \param $tbField field name
   *  \param $type new type to change, eg "file" or "lobject" to store files directly into the database
   *  \param $proprieties : array for file or lobject types: it could be contain key as:
         maxsize (in byte)
         type    (it could be an array, and is matched with mime-type)
         mime_type_col (column of the same table in wich send mime_type of the file)
         name_col (column of the same table in wich send filename)
         size_col (column of the same table in wich send file size in byte)
         thumbnail_col (column of the same table of type oid in wich send thumbnail)
         thumbnail_size (size in pixel of thumbnail)
         exif_col (column of the same table  in wich send exif info of the image)
         mime_type (if you would insert a unique type of file, and so mime_type_col and type are not necessary )
   *  \param change_propriety if alter display array 
   *  \param where=false if change only form or attribs array or both
   */

  function alter_type($tbSchema="public", $tbName, $tbField, $type, $proprieties=false, $change_propriety=true, $where=false){

    if($where){
      $this->{$where}[$name]["type"]=$type;
    }
    else{
      $this->db->attribs[$tbSchema][$tbName][$tbField]["type"]=$type;
      $this->form[$tbSchema][$tbName][$tbField]["type"]=$type;
    }
    
    if($proprieties["mime_type"]){
      $proprieties["type"]=$proprieties["mime_type"];
    }

    $this->db->attribs[$tbSchema][$tbName][$tbField]["file"]=$proprieties;

    $this->form[$tbSchema][$tbName][$tbField]["interpolate"]=false;
    if($proprieties["exif_col"]){
      $this->form[$tbSchema][$tbName][$proprieties["exif_col"]]["interpolate"]=false;
    }
    
    
    if($change_propriety){
      switch($type){
      case "file": 
      case "lobject": 
        $this->alter_display($tbSchema, $tbName,$tbField, true, array("new", "edit", "view","search"));
        $this->alter_display($tbSchema, $tbName,$tbField, false, "preSearch");
      break;
      case "pkey": 
        $this->alter_display($tbSchema, $tbName,$tbField, false,array("new", "edit"));
        $this->alter_display($tbSchema, $tbName,$tbField, true,array("search", "view","preSearch"));
      break;
      }

      //set cacarcteristic of others columns 
      $xxx=array("thumbnail_col");
      foreach($xxx as $key=>$val){
        if($proprieties[$val]){
          $this->alter_display($tbSchema, $tbName, $proprieties[$val],false);
        }
      }

      $xxx=array("exif_col", "size_col", "name_col", "mime_type_col");
      foreach($xxx as $key=>$val){
        if($proprieties[$val]){
          $this->alter_display($tbSchema, $tbName, $proprieties[$val],false,array("new", "edit"));
          $this->alter_display($tbSchema, $tbName, $proprieties[$val],true,array("search", "view","preSearch", "export"));
        }
      }
    }
  }

  //                                                                            //
  function file_url($file, $lobject=false, $mimeType=''){
    if(!$file) return '';
    if($lobject){
      return ('./lobjview.php?loid='.$file.'&mime-type='.$mimeType);
    }
    else{
      return $this->db->filesDir["remote"].$file;
    }
  }

  //                                                                            //
  function file_view($linkName, $link, $thumbnail, $mimeType){
    if(!$link) return '';
    $src='';
    $class="thumbnail";
    if(!$thumbnail){
      $class="icon";
      
      $file=$this->conf["MimeTypeIcons"]["remote"].$mimeType.".png";
      $unknow=$this->conf["MimeTypeIcons"]["remote"]."unknow.png";
      $fileLocal=$this->conf["MimeTypeIcons"]["local"].$mimeType.".png";
      $thumbnail=file_exists($fileLocal) ? $file : $unknow;
    }
    return ('<a class="file" href="'.$link. '"  target="_blank"><img src="'.$thumbnail.'" class="'.$class.'" /><br>'.$linkName.'</a>'); 
  }

  
  //                                                                            //
  /*! \brief main function
   *  \param $tbSchema='public' schema name
   *  \param $tbName table name
   *  \return a hash with keys: text: text to display at the bottom of the table
                                search_bar: search bar 
                                submit: submit buttons
                                table: html table
  */
  function switch_actions($tbSchema='public', $tbName){
   $action=($this->data["in"]["action"])?$this->data["in"]["action"]:$this->STRINGS["submit"]["preSearch"];
   $tmp= array_search($action, $this->STRINGS["submit"]);
   $action=$tmp?$tmp:$this->STRINGS["submit"]["preSearch"];
  
   //   if(!$this->checkPerms($action, $this->data->actions[$tbName][$tbSchema])) exit;
   if(!in_array($action,$this->actions[$tbSchema][$tbName]) && !in_array('search',$this->actions[$tbSchema][$tbName])){
     echo "Permission denied !!!";
     exit;
   }

  switch ($action){

  case "preMultipleInsert":
    $resultArr["text"]=$this->STRINGS["Insert_"].html_select("numInsert[$tbSchema][$tbName]",range(1,25), 1,0,0,1).$this->STRINGS["new_records"];
    $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('multipleInsert', 'preSearch')); 
    break;
    
  case "copy":
    $tb=$this->copy($tbSchema, $tbName);

    if($this->single[$tbSchema][$tbName]==true){
      $hc=0; $hr=2; $tr=1;
    }
    else{
      $hc=2; $tr=0; $hr=0;
    }

    $resultArr["table"]=array("table"=>$tb, "headerCol"=>$hc, "headerRow"=>$hr, "transpose"=>$tr);
    $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('insert','preSearch')); 
    break;
  case "new":
  case "multipleInsert":

    $tb=$this->pre_insert($tbSchema, $tbName);

    if($this->single[$tbSchema][$tbName]==true){
      $hc=0; $hr=2; $tr=1;
    }
    else{
      $hc=2; $tr=0; $hr=0;
    }

    $resultArr["table"]=array("table"=>$tb, "headerCol"=>$hc, "headerRow"=>$hr, "transpose"=>$tr);
    $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('insert','preSearch')); 
    break;

  case "view":
    $tb=$this->view($tbSchema, $tbName);

    if($this->single[$tbSchema][$tbName]==true){
      $hc=0; $hr=2; $tr=1;
    }
    else{
      $hc=2; $tr=0; $hr=0;
    }

    $resultArr["table"]=array("table"=>$tb, "headerCol"=>$hc, "headerRow"=>$hr, "transpose"=>$tr);

    $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('edit','delete', 'preSearch', 'copy', 'new', 'preMultipleInsert','export')); 
    break;

  case "insert":
    $this->insert($tbSchema, $tbName);
    list($resultArr["table"], $resultArr["submit"])=$this->switch_edit($tbSchema, $tbName);
    breaK;
  
  case "save":
    $this->update($tbSchema, $tbName);
    list($resultArr["table"], $resultArr["submit"])=$this->switch_edit($tbSchema, $tbName);
    breaK;
   
  case "edit":
    list($resultArr["table"], $resultArr["submit"])=$this->switch_edit($tbSchema, $tbName);
    break;

    
  case "delete":
    $this->delete($tbSchema, $tbName);
  // DA SISTEMARE!!!!
  //    if($this->data["in"]["tbInfo"][$tbSchema][$tbName]["single"]==1){ 
      $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('preSearch','new', 'preMultipleInsert')); 
  //    }
  //    if($this->data["in"]["tbInfo"][$tbSchema][$tbName]["oldAction"]=='edit'){
  //  list($resultArr["table"], $resultArr["submit"])=$this->switch_edit($tbSchema, $tbName);
  //}
    break;
    
  case "export":
    $file=$this->export($tbSchema, $tbName);
    $resultArr["text"]="<a href=$file>$file</a>";
    $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('newSearch', 'new', 'preMultipleInsert')); 
    break;

  case "search":

    $resultArr["table"]=array("table"=>$this->search($tbSchema, $tbName), "headerCol"=>2, "headerRow"=>0, "noInterpolate"=>$intArr, "noIntType"=>0);
    $xxx=&$this->links[$tbSchema][$tbName];
  
    $resultArr["search_bar"]=$this->search_bar($xxx['searchBar'], $this->conf["Images"]["previous"], $this->conf["Images"]["next"], $this->conf["Images"]["search"], $xxx["total"], $xxx["offset"], $xxx["limit"], 10, "offset[$tbSchema][$tbName]"); 

    if(array_key_exists("ref_field",$this->data["in"]["tbInfo"][$tbSchema][$tbName])){
      $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('modifySearch', 'newSearch'));
    }
    else{
      $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('modifySearch', 'newSearch','edit', 'delete', 'copy', 'new', 'preMultipleInsert','export')); 
    }
    break;      

  case "modifySearch": 
    $resultArr["table"]=array("table"=>$this->pre_search_modify($tbSchema, $tbName), "headerCol"=>0, "headerRow"=>1, "transpose"=>1);
    $limit=$this->data["in"]["limit"][$tbSchema][$tbName];
    $mainLogic=$this->data["in"]["mainLogic"][$tbSchema][$tbName];
    $inherited=$this->data["in"]["inherited"][$tbSchema][$tbName];
  default:  
    if($action!='modifySearch')
      $resultArr["table"]=array("table"=>$this->pre_search_new($tbSchema, $tbName), "headerCol"=>0, "headerRow"=>1,  "transpose"=>1);
    if(array_key_exists("ref_field",$this->data["in"]["tbInfo"][$tbSchema][$tbName])){
      $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('search'));
    }
    else{
      $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('search','new', 'preMultipleInsert')); 
    }
    $resultArr["text"]=$this->STRINGS["View_"].html_select("limit[$tbSchema][$tbName]",array(10, 25, 50, 100), $limit,0,0,1).$this->STRINGS["lines_a_page"];
    $resultArr["text"].='<br>'.$this->STRINGS["Search_"].html_select("mainLogic[$tbSchema][$tbName]",array("AND"=>$this->STRINGS["all_match"], 'OR'=>$this->STRINGS["one_match"]), $mainLogic,1,0,1).'.';
    $resultArr["text"].=$this->inh[$tbSchema][$tbName]?('<br><br><input type="radio" value="0" name="inherited['.$tbSchema.']['.$tbName.']" '.(($inherited=='0')?'checked':'').' />'.$this->STRINGS["no_inherited"].'<br><input type="radio" value="1" name="inherited['.$tbSchema.']['.$tbName.']" '.(($inherited!='0')?'checked':'').' />'.$this->STRINGS["inherited"]):'';
  
    //  secure_unset($this->tbInfo[$tbSchema][$tbName]['inherited']);
  }

  $resultArr["text"].=arr_to_hidden($this->data["in"]["tbInfo"], 'tbInfo');



  //convert bidimensional hash into a html table
  if(is_array($resultArr["table"])){
    $resultArr["table"]= html_table($resultArr["table"]["table"],$resultArr["table"]["headerCol"],$resultArr["table"]["headerRow"],1,1,1,0, $resultArr["table"]["transpose"], false);
  }

  //make submit buttons 
  $submit='';
  foreach($resultArr["submit"] as $key=>$val){
    if($val==$resultArr["submit"]["delete"]){
      $submit.='<input type="submit" value="'.$val.'" name="action" onclick="return confirm(\''.$this->STRINGS["confirm_rm_more"].'\');" />';
    }
    else{
      $submit.='<input type="submit" value="'.$val.'" name="action" />';
    }
  }
  $resultArr["submit"]=$submit;
  
  return $resultArr;  
 }

  //                                                                            //
 function  switch_edit($tbSchema, $tbName){
    $this->data["in"]["tbInfo"][$tbSchema][$tbName]["oldAction"]='edit';
    $this->data["in"]["tbInfo"][$tbSchema][$tbName]["oldSingle"]=$this->data["in"]["tbInfo"][$tbSchema][$tbName]["single"];

    $tb=$this->edit($tbSchema, $tbName);

    if($this->single[$tbSchema][$tbName]==true){
      $hc=0; $hr=2; $tr=1;
    }
    else{
      $hc=2; $tr=0; $hr=0;
    }

    $resultArr["table"]=array("table"=>$tb, "headerCol"=>$hc, "headerRow"=>$hr, "transpose"=>$tr);

    $resultArr["submit"]=$this->submit($tbSchema, $tbName, array('save','delete','view','preSearch', 'copy', 'new', 'preMultipleInsert','export')); 
    return (array($resultArr["table"], $resultArr["submit"]));
 }


  //                                                                            //
 /*! \brief to  be called to know how table is requested
  *   \return list(schemaname, tablename, primary key)
  */
 function get_table(){
   $tbInfo=$this->data["in"]["tbInfo"];
   if(!is_array($tbInfo)) user_error("Malformend POST or GET request!! tbInfo parameter absent!! ",E_USER_ERROR);
   $tbSchema=key($tbInfo);
   if(!is_array($tbInfo[$tbSchema])) user_error("Malformend POST or GET request!! tbInfo parameter absent!! ",E_USER_ERROR);
   $tbName=key($tbInfo[$tbSchema]);
   if(!is_array($tbInfo[$tbSchema][$tbName])) user_error("Malformend POST or GET request!! tbInfo parameter absent!! ",E_USER_ERROR);
   $tbPkey=$tbInfo[$tbSchema][$tbName]["pkey"];
   return array($tbSchema, $tbName, $tbPkey);
 } 


  //                                                                            //
 function search_bar($searchUrl=false, $previousUrl=false, $nextUrl=false, $otherUrl=false, $total=false, $offset=false, $limit=false, $numPages=false, $nameOffset){
   //   if($this->method=='GET' || $this->method=='get'){
   $searchUrl=$_SERVER["PHP_SELF"].'?'.arr_to_url($searchUrl);
   //   }
    $numPages=($numPages===false)?10:$numPages;
    return search_bar($searchUrl, $previousUrl, $nextUrl, $otherUrl, $total, $offset, $limit, $numPages, $nameOffset);
  }
 
  //                                                                            //
 function submit($tbSchema, $tbName, $arr){
    $ret=array();
    foreach($arr as $key=>$val){
      $val1=$val;
      switch($val){
        case 'new': $val1='insert';
        break;
        case 'save': $val1='edit';
        break;
        case 'newSearch': $val1='search';
        break;
        case 'preSearch': $val1='search';
        break;
      }
      if( in_array($val1,$this->actions[$tbSchema][$tbName])){
        $ret[]=$this->STRINGS["submit"][$val]; 
      }
    }
    return $ret;
  }

}
?>

---