Source for file DBMS_FIELD_TREESELECT.phpclass

Documentation is available at DBMS_FIELD_TREESELECT.phpclass

  1. <?php
  2. /**
  3.   * Class file DBMS_FIELD_TREESELECT.phpclass
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms_field
  7.   * @category   int
  8.   *
  9.   * @author     Peter Krebs <pitlinz@users.sourceforge.net>
  10.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  11.   *
  12.   * @version $Id: DBMS_FIELD_TREESELECT.phpclass,v 1.9 2008/09/26 15:00:21 pitlinz Exp $
  13.   */
  14.  
  15. /**
  16.   * requirements
  17.   */
  18.  
  19. pcf_require_class('DBMS_FIELD_DBLOOKUPSELECTLIST',dirname(__FILE__) . "/");
  20.  
  21. /**
  22.   * Class DBMS_FIELD_TREESELECT
  23.   *
  24.   * @project    Open CSP-Management
  25.   * @package    dbms_field
  26.   * @category   int
  27.   *
  28.   * @author     Peter Krebs <pitlinz@users.sourceforge.net>
  29.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  30.   *
  31.   * @version pk-05-09-27
  32.   * @version $Id: DBMS_FIELD_TREESELECT.phpclass,v 1.9 2008/09/26 15:00:21 pitlinz Exp $
  33.   * @todo avoid enless loop if input data are wrog
  34.   * 
  35.   ***/
  36. class DBMS_FIELD_TREESELECT extends DBMS_FIELD_DBLOOKUPSELECTLIST {
  37.     
  38.     // ---------------------------------------------------------------------------
  39.     // constants
  40.     // ---------------------------------------------------------------------------
  41.     
  42.     /**
  43.      * @constant string CLASS_SRC_FILE
  44.      */
  45.     const CLASS_SRC_FILE = __FILE__;
  46.  
  47.     // ---------------------------------------------------------------------------
  48.     // class (static)
  49.     // ---------------------------------------------------------------------------
  50.     
  51.     /*** class vars ------------------------------------------------------ */
  52.  
  53.     /*** class methods --------------------------------------------------- */    
  54.     
  55.     // ---------------------------------------------------------------------------
  56.     // object vars
  57.     // ---------------------------------------------------------------------------
  58.     
  59.     /*** compostion --------------------------------------------------- */
  60.     
  61.     /*** attributes  -------------------------------------------------- */    
  62.     
  63.     /**
  64.      * @deprecated
  65.      */
  66.     protected $classSrcFile=__FILE__;
  67.  
  68.       
  69.     // tree definition 
  70.     
  71.     /**
  72.      * parent column in the table
  73.      *
  74.      * @var string $parentField 
  75.      */    
  76.     protected $parentField        = "";
  77.  
  78.     /**
  79.      * tree root key
  80.      *
  81.      * @var int $treeROOTKey 
  82.      */
  83.     protected $treeROOTKey        = "0";
  84.  
  85.     /**
  86.       * @var string $treeROOTShowVal 
  87.       * @since pk-05-09-27
  88.       ***/
  89.     protected $treeROOTShowVal    = "Wurzel";
  90.  
  91.     /**
  92.       * rootCheckOff
  93.       * @var boolean $rootCheckOff 
  94.       * @since pk-05-01-26
  95.       ***/
  96.     protected $rootCheckOff;
  97.     
  98.     /**
  99.      * allow root select
  100.      * @var boolean $disableROOTSelect 
  101.      * @since pk-08-04-18
  102.      */
  103.     protected $disableROOTSelect     = False;
  104.     
  105.     /*** layout attributes ----------------------------------- */
  106.     
  107.     /**
  108.      * show full tree (multi selects)
  109.      *
  110.      * @var boolean $showFullTree 
  111.      */
  112.     protected $showFullTree       = False;
  113.     
  114.     /**
  115.      * show path (parents) in RO mode
  116.      *
  117.      * @var boolean $showPathRO 
  118.      */
  119.     protected $showPathRO         = False;
  120.  
  121.     /**
  122.      * number of levels to go down from the root
  123.      *
  124.      * @var int $nofLevel 
  125.      */
  126.     protected $nofLevels          = 25;    
  127.  
  128.  
  129.     /**
  130.       * @var string $intendString 
  131.       * @access protected
  132.       */
  133.     protected $intendString="&nbsp;&nbsp;";
  134.     
  135.     // ---------------------------------------------------------------------------
  136.     // factory / construct
  137.     // ---------------------------------------------------------------------------
  138.     
  139.     // ---------------------------------------------------------------------------
  140.     // getter / setter
  141.     // ---------------------------------------------------------------------------    
  142.  
  143.     protected function getClassCacheKey()
  144.     {
  145.         $str_key = $this->parentField . $this->lookupTable . $this->lookupField . $this->lookupShowField . $this->lookupShowLstField . $this->lookupSort . $this->lookupWhere;
  146.         //echoDebugLine(__FILE__,__LINE__,"Class Key values " . $str_key . "<br />" . md5($str_key));
  147.         return md5($str_key);
  148.     }    
  149.     
  150.  
  151.     // ---------------------------------------------------------------------------
  152.     // OBJECT SETTINGS METHODS
  153.     // ---------------------------------------------------------------------------
  154.  
  155.     /**
  156.       * returns an array of field to bie shown in the edit form
  157.       * by using editTbl_echoForm
  158.       *
  159.       * the array is in the form:
  160.       *
  161.       * <code>
  162.       * [_sectionName_]
  163.       *      [TITLE] -> string
  164.       *      [_rowName_]
  165.       *         [FLDLAB]  (complete html code with <td></td>)
  166.       *         [FLDVAL] (complete html code with <td></td>)
  167.       * </code>
  168.       *
  169.       * @param boolean $debug 
  170.       *
  171.       * @returns array
  172.       *
  173.       * @since pk-06-07-04
  174.       *
  175.       ***/
  176.     function editTbl_getFieldEditArr($debug=False) 
  177.     {
  178.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_TREESELECT::editTbl_getFieldEditArr","",0);
  179.         $a_ret=parent::editTbl_getFieldEditArr($debug);
  180.  
  181.         $a_ret['DBLOOKUP']['FLD_LSTADDVALUES']=Null;
  182.         
  183.         $a_ret['DBLOOKUP']['TREEROOTKEY']=array(
  184.             'FLDLAB'=>"TREE ROOT KEY/SHOW Value:",
  185.             'FLDVAL'=>"
  186.                         <input name=\"TREEROOTKEY\" value=\"".$this->treeROOTKey."\" size=\"10\" />
  187.                         <input name=\"treeROOTShowVal\" value=\"".$this->treeROOTShowVal."\" size=\"20\" /><br />
  188.                         <input name=\"rootCheckOff\" type=\"checkbox\" ".($this->rootCheckOff ? "checked=\"checked\"" : "")." value=\"1\" /> Root nicht in DB
  189.                         <input name=\"disableROOTSelect\" type=\"checkbox\" ".($this->disableROOTSelect ? "checked=\"checked\"" : "") . " value=\"1\" />Root <strong>nicht</strong> w&auml;hlbar
  190.                     "
  191.         );
  192.         $a_ret['DBLOOKUP']['PARENTFIELD']=array(
  193.             'FLDLAB'=>"PARENT Field:",
  194.             'FLDVAL'=>"<input name=\"PARENTFIELD\" value=\"".$this->parentField."\" size=\"40\" />"
  195.         );
  196.  
  197.         $a_ret['LAYOUT']['showFullTree']=array(
  198.             'FLDLAB'=>"Vollst&auml;ndiger Baum:",
  199.             'FLDVAL'=>"<input name=\"showFullTree\" type=\"checkbox\" ".($this->showFullTree ? "checked=\"checked\"" : "")." value=\"1\" /> ALLE Werte anzeigen"
  200.         );
  201.         $a_ret['LAYOUT']['NOFLEVELS']=array(
  202.             'FLDLAB'=>"Max Anzahl Ebenen:",
  203.             'FLDVAL'=>"<input name=\"NOFLEVELS\" type=\"text\" value=\"".(intval($this->nofLevels) ? intval($this->nofLevels) : 25 )."\" />"
  204.         );
  205.         $a_ret['LAYOUT']['showPathRO']=array(
  206.             'FLDLAB'=>"Pfad bei ReadOnly:",
  207.             'FLDVAL'=>'
  208.                     <select name="showPathRO" size="1">
  209.                         <option value="0" '.(($this->showPathRO==0) ? "selected" : "").' >nein nur gew&auml;hlte Werte</option>
  210.                         <option value="1" '.(($this->showPathRO==1) ? "selected" : "").' >ja in einer Zeile</option>
  211.                         <option value="2" '.(($this->showPathRO==2) ? "selected" : "").' >ja eine Zeile/Ebene</option>
  212.                     </select>
  213.                       '
  214.         );
  215.  
  216.         return $a_ret;
  217.     }
  218.  
  219.     /**
  220.       * saves the field definition
  221.       *
  222.       * @returns boolean
  223.       *
  224.       * @version pk-05-06-26
  225.       * @version pk-05-09-27
  226.       * @version pk-07-09-26 E_ALL
  227.       ***/
  228.     function save() 
  229.     {
  230.         if (isset($this->treeTbl)) unset($this->treeTbl);
  231.  
  232.         // save the parent first to be sure to have the table in DBcheckEditInput
  233.         $ret=parent::save();
  234.  
  235.         $this->showAsCheckRadio =     False;
  236.                 
  237.         $this->parentField          =(isset($_POST['PARENTFIELD']) ? $this->DBcheckEditInput($_POST['PARENTFIELD']) : $this->parentField);
  238.         $this->treeROOTKey          =(isset($_POST['TREEROOTKEY']) ? $_POST['TREEROOTKEY'] : $this->treeROOTKey);               // pk-05-06-26 templates allowed
  239.         $this->treeROOTShowVal      =(isset($_POST['treeROOTShowVal']) ? $_POST['treeROOTShowVal'] : $this->treeROOTShowVal);   // <pk-05-09-27>
  240.         $this->showFullTree         =((isset($_POST['showFullTree']) && intval($_POST['showFullTree'])) ? TRUE : False );
  241.         $this->showPathRO           =(isset($_POST['showPathRO']) ? intval($_POST['showPathRO']) : $this->showPathRO);
  242.         $this->nofLevels            =(isset($_POST['NOFLEVELS']) ? intval($_POST['NOFLEVELS']) : $this->nofLevels);
  243.         $this->rootCheckOff         =((isset($_POST['rootCheckOff']) && intval($_POST['rootCheckOff'])) ? TRUE : False);
  244.         $this->disableROOTSelect    =((isset($_POST['disableROOTSelect']) && intval($_POST['disableROOTSelect'])) ? TRUE : False);
  245.         
  246.         if (!$this->showFullTree)   $this->reloadFormOnChange=TRUE;
  247.  
  248.         return $ret;
  249.     }
  250.  
  251.     // -----------------------------------------------------------
  252.     // DB value methods
  253.     // -----------------------------------------------------------
  254.     
  255.     /**
  256.       * returns the database query
  257.       *
  258.       * @param boolean $debug 
  259.       *
  260.       * @return string 
  261.       *
  262.       * @since pk-07-09-03
  263.       * @version pk-08-08-01
  264.       * 
  265.       */
  266.     function getMyValueQuery($debug=False)
  267.     {
  268.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_TREESELECT::getMyValueQuery()");
  269.  
  270.         $str_query ="SELECT ".$this->lookupField . " AS KEYFIELD";
  271.         $str_query.="," .$this->lookupShowField . " AS SHOWFIELD";
  272.         if (!empty($this->lookupShowLstField))
  273.         {
  274.             $str_query.="," .$this->lookupShowLstField . " AS SHOWLIST";
  275.         } else {
  276.              $str_query.="," .$this->lookupShowField . " AS SHOWLIST";
  277.         }
  278.         $str_query.="," .$this->parentField . " AS PARENTFIELD";
  279.         $str_query.=" FROM ".$this->lookupTable;
  280.  
  281.         if (!empty($this->lookupWhere)) { // <pk-05-08-10>
  282.             require_once __OCSP_PHPINCPATH__."common/pcf_templates.phpinc";
  283.             $str_query.=" WHERE ".$this->lookupWhere;
  284.         }
  285.  
  286.         if (empty($this->lookupSort)) {
  287.             $str_query.=" ORDER BY ".$this->parentField.",".$this->lookupField;
  288.         } else {
  289.             $str_query.=" ORDER BY ".$this->parentField.",".$this->lookupSort;
  290.         }
  291.  
  292.         if ($debug) echoDebugLine(__FILE__,__LINE__,"getMyValueQuery: <br/>".$str_query);
  293.         return $str_query;
  294.      }
  295.  
  296.     /**
  297.       * sets populates $this->myValues array from the database
  298.       *
  299.       * @param string $arrName 
  300.       * @param boolean $debug 
  301.       *
  302.       * @return int size of $this->myValues
  303.       *
  304.       * @since pk-07-09-03
  305.       * @version pk-08-08-01
  306.       */
  307.     function setMyValues($arrName="DBVAL",$debug=False) 
  308.     {              
  309.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_TREESELECT::setMyValues($arrName,...)");        
  310.         global ${$arrName};
  311.         
  312.         if (empty($this->myDataArrName)) $this->myDataArrName=$arrName;
  313.         $str_cacheId = $this->getClassCacheKey();
  314.         
  315.         if (
  316.             !isset(self::$classValPopulateTs[$str_cacheId] ) || 
  317.             self::$classValPopulateTs[$str_cacheId] < (time() - ini_get('max_execution_time'))
  318.         )
  319.         {
  320.             // load the values from the db
  321.             $str_query = OCSP_TEMPLATE::parse($this->getMyValueQuery(),${$arrName});
  322.             if ($debug) echoDebugLine(__FILE__,__LINE__,"query: ". $str_query);
  323.             if ($obj_cursor = OCSP_OBJ::defaultReadDBObj()->query($str_query))
  324.             {
  325.                 while($arr_row = $obj_cursor->fetchArrayFld())
  326.                 {
  327.                     self::$classCache[$str_cacheId]['ROWS'][$arr_row['KEYFIELD']] = $arr_row;
  328.                     $mix_parentKey = (empty($arr_row['PARENTFIELD']) ? 0 : $arr_row['PARENTFIELD']);
  329.                     self::$classCache[$str_cacheId]['CHILDREN'][$mix_parentKey][] = $arr_row['KEYFIELD'];
  330.                 }
  331.                 self::$classValPopulateTs=time();
  332.             }
  333.         }        
  334.  
  335.         $this->myValues = array();
  336.         if (empty($this->treeROOTKey)) $this->treeROOTKey=0;
  337.  
  338.         if (isset(self::$classCache[$str_cacheId]['ROWS'][$this->treeROOTKey]))
  339.         {
  340.             $this->myValues[$this->treeROOTKey] = self::$classCache[$str_cacheId]['ROWS'][$this->treeROOTKey];
  341.         }
  342.  
  343.         if (is_array(self::$classCache[$str_cacheId]['CHILDREN'][$this->treeROOTKey]))
  344.         {
  345.             foreach(self::$classCache[$str_cacheId]['CHILDREN'][$this->treeROOTKey] as $mix_childKey)
  346.             {
  347.                 if (!isset($this->myValues[$mix_childKey])) // to avoid miss configured tree errors
  348.                 {
  349.                     if (isset(self::$classCache[$str_cacheId]['ROWS'][$mix_childKey]))
  350.                     {
  351.                         $this->myValues[$mix_childKey] = $this->intendString . self::$classCache[$str_cacheId]['ROWS'][$mix_childKey]['SHOWFIELD'];
  352.                         $this->setMyChildValues($str_cacheId,$mix_childKey,$this->intendString,1,$debug);
  353.                     }
  354.                 } 
  355.             }
  356.         }
  357.  
  358.         return sizeof($this->myValues);
  359.     }
  360.  
  361.     
  362.     /**
  363.      * adds children of $key to $this->myValues
  364.      *
  365.      * @param mixed $key 
  366.      * @param string $intend 
  367.      * @param int $level 
  368.      * @param string showCol
  369.      * @param boolean $debug 
  370.      * 
  371.      * @since pk-08-04-15
  372.      * @version pk-08-09-26
  373.      */
  374.     protected function setMyChildValues($cacheId,$key,$intend,$level=0,$debug=False)
  375.     {
  376.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_TREESELECT::setMyChildValues({$cacheId},{$key}, ,{$level})");
  377.         
  378.         if ($level <= $this->nofLevels)
  379.         {
  380.             if (isset(self::$classCache[$cacheId]['CHILDREN'][$key]) && is_array(self::$classCache[$cacheId]['CHILDREN'][$key]))
  381.             {
  382.                 foreach(self::$classCache[$cacheId]['CHILDREN'][$key] as $mix_childKey)
  383.                 {
  384.                     if (!isset($this->myValues[$mix_childKey]))
  385.                     {
  386.                         if (isset(self::$classCache[$cacheId]['ROWS'][$mix_childKey]))
  387.                         {
  388.                             $this->myValues[$mix_childKey] = $intend . $this->intendString . self::$classCache[$cacheId]['ROWS'][$mix_childKey]['SHOWFIELD'];
  389.                             $this->setMyChildValues($cacheId,$mix_childKey,$intend . $this->intendString,($level + 1));
  390.                         } else {
  391.                             echoDebugLine(__FILE__,__LINE__,$mix_childKey . " has no row set");
  392.                         }
  393.                     } else if($debug) {
  394.                         echoDebugLine(__FILE__,__LINE__,$mix_childKey . "already set");
  395.                     }
  396.                 }
  397.             } else if($debug) {
  398.                 echoDebugLine(__FILE__,__LINE__,$key . " has no children");
  399.             }
  400.         } else {
  401.             if ($debug) echoDebugLine(__FILE__,__LINE__,"Max levels reached");
  402.         }
  403.      
  404.     }
  405.     
  406.     /**
  407.       * returns the html-code for a level select
  408.       *
  409.       * @param array $childArr 
  410.       * @param int $countSelects 
  411.       * @param int $level 
  412.       * @param mixed $aValue 
  413.       * @param string $arrName 
  414.       * @param boolean $debug 
  415.       *
  416.       * @returns string
  417.       *
  418.       * @since pk-04-08-31
  419.       *
  420.       ***/
  421.     function getLevelSelect($childArr,$countSelects,$level,$aValue,$arrName="DBVAL",$debug=False) {
  422.         $debug=($debug || $this->fldDebug);
  423.         if ($debug) echo "<p><b>DBMS_FIELD_TREESELECT::getLevelSelect(\$childArr (".sizeof($childArr)."),$countSelects,$level,$aValue,$arrName,..</b> (".get_class($this).")</p>";
  424.  
  425.         $selName=$arrName."_".$this->myName."_".$level;
  426.         $df="document.forms['".$this->getMyFormName()."']";
  427.         $ret ="\n\t<select name=\"".$selName."\" onChange=\"\n";
  428.         $ret.="\n\t         setElemValByName($df,'".$arrName."[".$this->myName."]',$df.$selName.options[$df.$selName.selectedIndex].value);";
  429.         $ret.="\n\t         $df.action='".$_SERVER['REQUEST_URI']."#".$this->myName."';";
  430.         $ret.="\n\t         $df.submit();";
  431.         $ret.="\n\t     \" size=\"1\">\n";
  432.  
  433.         if ($level==0) {
  434.             if ($this->allowNullSelect) {
  435.                 $ret.="\t\t<option value=\"".$this->treeROOTKey."\">".$this->nullLabel."</option>\n";
  436.             }
  437.         } else {
  438.             $ret.="\t\t<option value=\"".$childArr[0]['PARENTFIELD']."\">--- ??? ---</option>\n";
  439.         }
  440.         if (is_array($childArr)) {
  441.             reset($childArr);
  442.             while(list($key,$row)=each($childArr)) {
  443.                 $ret.=$this->getNotIntendedOption($row,$aValue);
  444.             }
  445.         }
  446.  
  447.         $ret.="\n\t</select>\n";
  448.         return $ret;
  449.     }
  450.  
  451.     /**
  452.       * returns the html code for level select fields
  453.       *
  454.       * @param mixed $aValue 
  455.       * @param string $arrName 
  456.       * @param boolean $debug 
  457.       *
  458.       * @returns string
  459.       *
  460.       * @since pk-04-08-31
  461.       *
  462.       ***/
  463.     function getLevelSelectFields($aValue="",$arrName="DBVAL",$debug=False) {
  464.         $debug=($debug || $this->fldDebug);
  465.         if ($debug) echo "<p><b>DBMS_FIELD_TREESELECT::getLevelSelectFields($aValue,$arrName,...)</b> (".get_class($this).")</p>";
  466.  
  467.         $level=0;
  468.         $ret="";
  469.         if (($treeDesc=$this->getPCF_TreeDesc($arrName,$debug)) && ($treePath=pcf_getTreePath($treeDesc,$aValue,$debug))) {
  470.             $countSelects=sizeof($treePath);
  471.             while($level < $countSelects) {
  472.                 if ($childArr=pcf_getTreeChildArray($treeDesc,$treePath[$level]['PARENTFIELD'],$debug)) {
  473.                     $ret.=$this->getLevelSelect($childArr,$countSelects,$level,$treePath[$level]['KEYFIELD'],$arrName,$debug);
  474.                 } else {
  475.                     // ERROR -> go out
  476.                     break;
  477.                 }
  478.                 $level++;
  479.             }
  480.  
  481.             if ($childArr=pcf_getTreeChildArray($treeDesc,$treePath[($level-1)]['KEYFIELD'],$debug)) {
  482.                 $m_key=(isset($treePath[($level-1)]['KEYFIELD']) ? $treePath[($level-1)]['KEYFIELD'] : NULL); // <pk-06-08-03 /> E_ALL
  483.                 $ret.=$this->getLevelSelect($childArr,$countSelects,$level++,$m_key,$arrName,$debug);
  484.             }
  485.         } else if ($childArr=pcf_getTreeChildArray($treeDesc,$this->treeROOTKey,$debug)) {
  486.             $countSelects=0;
  487.             $ret.=$this->getLevelSelect($childArr,$countSelects,$level++,$aValue,$arrName,$debug);
  488.         } else if ($this->allowNullSelect) {
  489.             $ret.= $this->nullLabel;
  490.         } else if (empty($this->newUrl)) {
  491.             $ret.= "ERROR NO VALUES IN TREE";
  492.         } else {
  493.             $ret.= "Sie mssen eine Datensatz einf&uuml;gen";
  494.         }
  495.  
  496.         $ret.= "<input type='hidden' name='".$arrName."[".$this->myName."]' value=\"".htmlspecialchars($aValue)."\">";
  497.         $ret.= $this->getAddButton($arrName);
  498.         $ret.= $this->getReloadButton($arrName);
  499.  
  500.         unset($treePath);
  501.  
  502.         return $ret;
  503.     }
  504.  
  505.     /**
  506.       * returns the html code
  507.       *
  508.       * @param string $aValue 
  509.       * @param array $arrName 
  510.       * @param boolean $debug 
  511.       *
  512.       * @returns string
  513.       *
  514.       * @version pk-04-08-31 $debug added
  515.       * @version pk-05-09-16
  516.       *
  517.       ***/
  518.     function getInputTag($aValue,$arrName="DBVAL",$debug=False)
  519.     {
  520.         if (!empty($arrName)) $this->myDataArrName=$arrName;
  521.         $debug=($debug || $this->fldDebug); // <pk-04-08-31>
  522.         if ($debug) echoDebugMethod(__FILE__,get_class($this),__CLASS__."::getInputTag(\$aValue,\$arrName,...) [".$this->myName."]",print_r($aValue,TRUE));
  523.  
  524.         if ($this->showFullTree) {
  525.             return parent::getInputTag($aValue,$arrName,$debug);
  526.         } else {
  527.             $str_ret .= "TODO levelselect";
  528.             /*
  529.              * @todo
  530.              
  531.             $str_ret = $this->getLevelSelectFields($aValue,$this->myDataArrName,$debug);
  532.             $str_ret.= $this->getAddTag($this->myDataArrName);
  533.               */
  534.             return $str_ret;
  535.         }
  536.     }
  537.  
  538.     /**
  539.       * returns the field value if the referenzed row exists
  540.       *
  541.       * @param  string  $aValue     the value
  542.       * @param  array   $err        error array
  543.       * @param  string  $arrName    name of the array to access fieldsarray  gloabl ${$arrName}
  544.       * @param  bool    $debug 
  545.       *
  546.       * @return string 
  547.       *
  548.       * @since   pk-05-01-26
  549.       * @version pk-05-10-05
  550.       *
  551.       ***/
  552.     function getValue($aValue,&$err,$arrName="DBVAL",$debug=False) {
  553.         $debug=($debug || $this->fldDebug);
  554.         if ($debug) echo "<hr><p><b>DBMS_FIELD_TREESELECT::getValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)." | ".$this->myName.")</p>";
  555.  
  556.         if (($aValue == $this->treeROOTKey) && ($this->rootCheckOff))
  557.         {
  558.             if ($this->disableROOTSelect)
  559.             {
  560.                 return parent::getValue(Null,$err,$arrName,$debug);
  561.             } else {
  562.                 return $aValue;
  563.             }
  564.         }
  565.         return parent::getValue($aValue,$err,$arrName,$debug);
  566.     }
  567.  
  568.  
  569.     /**
  570.       * returns the screen value
  571.       *
  572.       * @param mixed $aValue 
  573.       * @param string $arrname 
  574.       * @param boolean $debug 
  575.       *
  576.       * @returns string
  577.       *
  578.       * @todo DBMS_FIELD_TREESELECT::getScreenValue showPathRO
  579.       ***/
  580.     function getScreenValue($aValue=NULL,$arrName="DBVAL",$debug=False) {
  581.         if ($this->showPathRO) {
  582.             return parent::getScreenValue($aValue,$arrName,$debug);
  583.             /*
  584.             $ret="";
  585.             if ($treePath=pcf_getTreePath($this->getPCF_TreeDesc($arrName),$aValue,$debug)) {
  586.                 reset($treePath);
  587.                 $sep="";
  588.                 while(list($key,$row)=each($treePath)) {
  589.                     switch ($this->showPathRO) {
  590.                         case 1:
  591.                             $ret.= $sep.$row['SHOWFIELD'];
  592.                             $sep = htmlspecialchars(" -> ");
  593.                             break;
  594.                         case 2:
  595.                             $intend=htmlspecialchars($row['_INTEND']);
  596.                             $intend=str_replace(" ","&nbsp;",$intend);
  597.                             $ret.= $sep.$intend.$row['SHOWFIELD'];
  598.                             $sep = "<br />";
  599.                             break;
  600.                         default:
  601.                             $ret.= $row['SHOWFIELD']." ";
  602.                     }
  603.                 }
  604.             }
  605.             */
  606.             return $ret;
  607.         } else {
  608.             return parent::getScreenValue($aValue,$arrName,$debug);
  609.         }
  610.     }
  611.  
  612.     /**
  613.       * returns a html select with all values (distinct) where $aValue
  614.       * is selected
  615.       *
  616.       * NOTE only works on database fields
  617.       *
  618.       * @param mixed $aValue 
  619.       * @param string $arrName 
  620.       * @param string $selTagAdd added into <select ...>
  621.       * @param string $whereCond added to query ($s_query="SELECT ... FROM TABLE ".$whereCond)
  622.       *
  623.       * @return string 
  624.       *
  625.       * @since pk-05-10-18
  626.       *
  627.       * @todo object value tables
  628.       *
  629.       * @var array $a_treeDesc 
  630.       * @var array $a_treeArr 
  631.       ***/
  632.     function getTableValSelect(&$aValue,$arrName="",$selTagAdd="",$whereCond="",$nullLabel="",$debug=False) {
  633.         $debug=($debug || $this->fldDebug);
  634. $debug=TRUE;
  635.         if ($debug) echo "<p><b>DBMS_FIELD::getTableValSelect(aValue=".$aValue.",arrName=".$arrName.")</b> (".get_class($this).")</p>\n";
  636.  
  637.         $a_treeDesc=$this->getPCF_TreeDesc($arrName);
  638.  
  639.         if ($a_treeArr=pcf_getTreeArray($a_treeDesc,$this->treeROOTKey,"","",$this->nofLevels,$debug)) {
  640.             if ($debug) echo "<pre>".print_r($a_treeArr,TRUE)."</pre>";
  641.             if (!empty($arrName)) {
  642.                 $s_selName=$arrName."[".$this->myName."]";
  643.             } else {
  644.                 $s_selName=$this->myName;
  645.             }
  646.             $ret="\n<select name=\"".$s_selName."\" ".$selTagAdd.">\n";
  647.             if (!empty($nullLabel)) {
  648.                 $ret.="\t<option value=\"\">".$nullLabel."</option>\n";
  649.             } else if ($this->searchGroup_allowAll) {
  650.                 $ret.="\t<option value=\"\">--- ??? ---</option>\n";
  651.             }
  652.  
  653.  
  654.             foreach($a_treeArr as $a_treeNode) {
  655.                 if ($debug) echo "<p>Value: $aValue Row: ".$a_treeNode['KEYFIELD'];
  656.                 $s_query ="SELECT COUNT(*) FROM ".$this->myTable;
  657.                 if (!empty($whereCond)) {
  658.                     $s_query.=$whereCond;
  659.                     $s_query.=" AND ".$this->myName."=".$GLOBALS['USRDB']->qs_getSlashedValue($a_treeNode['KEYFIELD']);
  660.                 } else {
  661.                     $s_query.=" WHERE ".$this->myName."=".$GLOBALS['USRDB']->qs_getSlashedValue($a_treeNode['KEYFIELD']);
  662.                 }
  663.                 if ($debug) echo "<p>".$s_query."</p>";
  664.  
  665.                 $i_nofEntries=intval($GLOBALS['USRDB']->quickQuery($s_query,0));
  666.  
  667.                 $ret.= "\t<option value=\"".$a_treeNode['KEYFIELD']."\"";
  668.                 if ((empty($nullLabel)) && (!$this->searchGroup_allowAll) && (empty($aValue))) {
  669.                     // no null Label -> we have to set the $aValue called by ref
  670.                     $aValue=$a_treeNode['KEYFIELD'];
  671.                 }
  672.  
  673.                 if (strval($aValue)===($a_treeNode['KEYFIELD'])) {
  674.                     if ($debug) echo " <b>SELECTED</b>";
  675.                     $ret.= " selected";
  676.                 } else if (!$i_nofEntries) {
  677.                     $ret.= " disabled";
  678.                 }
  679.  
  680.                 if ($debug) echo "</p>";
  681.                 $ret.= ">&nbsp;&nbsp;".$a_treeNode['_INTEND'].$a_treeNode['SHOWFIELD']." (".$i_nofEntries.")</option>\n";
  682.             }
  683.             $ret.="\n</select>";
  684.         }
  685.  
  686.         return $ret;
  687.     }
  688.  
  689. }
  690. ?>

Documentation generated on Thu, 08 Jan 2009 17:43:12 +0100 by phpDocumentor 1.4.0a2