Source for file DBMS_FIELD_CLISELECT.phpclass

Documentation is available at DBMS_FIELD_CLISELECT.phpclass

  1. <?php
  2. /**
  3.   * Class file DBMS_FIELD_CLISELECT.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.   * @since pk-06-01-17
  13.   * @version $Id: DBMS_FIELD_CLISELECT.phpclass,v 1.6 2008/06/13 15:30:16 pitlinz Exp $
  14.   */
  15.  
  16. pcf_require_class('DBMS_FIELD_FOREIGNKEY',dirname(__FILE__) . _OCSP_DIRSEP_ . "DBMS_FIELD_FOREIGNKEY.phpclass");
  17.  
  18.  
  19. /**
  20.   * Class file DBMS_FIELD_CLISELECT.phpclass
  21.   *
  22.   * @project    Open CSP-Management
  23.   * @package    dbms_field
  24.   * @category   int
  25.   *
  26.   * @author     Peter Krebs <pitlinz@users.sourceforge.net>
  27.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  28.   *
  29.   * @since pk-06-01-17
  30.   * @version $Id: DBMS_FIELD_CLISELECT.phpclass,v 1.6 2008/06/13 15:30:16 pitlinz Exp $
  31.   */
  32. class DBMS_FIELD_CLISELECT extends DBMS_FIELD_FOREIGNKEY {
  33.     /**
  34.       * source file of the class
  35.       *
  36.       * @var string $classSrcFile 
  37.       * @since pk-05-01-20
  38.       ***/
  39.     protected $classSrcFile=__FILE__;
  40.     
  41.     protected $className      = "Kunden Select List";
  42.     
  43.     /**
  44.      * lookup table
  45.      *
  46.      * @var string $lookupTable 
  47.      */
  48.     protected $lookupTable     = "T_CLI_CLIENT";
  49.     
  50.     
  51.     protected $lookupShowField = "CONCAT(CLI_NAME1,IFNULL(CONCAT(' ',CLI_NAME2),''),' (',IFNULL(CLI_NUMBER,CONCAT('ID :',CLI_ID)),')')";
  52.     protected $lookupField     = "CLI_ID";
  53.     protected $lookupSort      = "CLI_NAME1,CLI_NAME2";
  54.     protected $showNullOption  = FALSE;
  55.  
  56.     /**
  57.      * type of client (CTY_ID)
  58.      *
  59.      * @var int $ctyId 
  60.      */
  61.     protected $ctyId           = 0;
  62.  
  63.  
  64.     /**
  65.       * returns an array of field to bie shown in the edit form
  66.       * by using editTbl_echoForm
  67.       *
  68.       * the array is in the form:
  69.       *
  70.       * <code>
  71.       * [_sectionName_]
  72.       *      [TITLE] -> string
  73.       *      [_rowName_]
  74.       *         [FLDLAB]  (complete html code with <td></td>)
  75.       *         [FLDVAL] (complete html code with <td></td>)
  76.       * </code>
  77.       *
  78.       * @param boolean $debug 
  79.       *
  80.       * @returns array
  81.       *
  82.       * @since pk-06-04-26
  83.       * @version pk-06-04-29
  84.       *
  85.       */
  86.     function editTbl_getFieldEditArr($debug=FALSE) {
  87.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_FOREIGNKEY::editTbl_getFieldEditArr","",0);
  88.         $a_ret=parent::editTbl_getFieldEditArr($debug);
  89.  
  90.         $a_ret['LAYOUT']['FLD_SIZE']=NULL;      // unset parent field
  91.         $a_ret['LAYOUT']['FLD_INPUTADD']=NULL;  // unset parent field
  92.  
  93.         $a_ret['DBLOOKUP']['FLD_LUTBL']['FLDVAL']="T_CLI_CLIENT";
  94.         $a_ret['DBLOOKUP']['FLD_VALFLD']['FLDVAL']="CLI_ID";
  95.             
  96.         unset($a_ret['DBLOOKUP']['FLD_VALFLD']);
  97.         $a_ret['DBLOOKUP']['FLD_WHEREFLD']=array(
  98.                 'FLDLAB'=>"Kundenart",
  99.                 'FLDVAL'=>"#SELECT see below#"
  100.             );
  101.         $a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL']="
  102.                 <select name=\"ctyId\" size=\"1\">\n
  103.                     <option value=\"0\">--- ALLE ---</option>
  104.                     ";
  105.  
  106.         $s_query="SELECT * FROM T_CLI_TYPE ORDER BY CTY_SORTORDER,CTY_NAME";
  107.         if ($o_cursor=$GLOBALS['USRDB']->query($s_query)) {
  108.             while($a_cty=$o_cursor->fetchArrayFld()) {
  109.                 $a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL'].="<option value=\"".$a_cty['CTY_ID']."\"";
  110.                 if ($this->ctyId==$a_cty['CTY_ID']) $a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL'].=" selected";
  111.                 $a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL'].=">".$a_cty['CTY_NAME']."</option>\n";
  112.             }
  113.         }
  114.         $a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL'].="
  115.                 </select>";
  116.         return $a_ret;
  117.     }
  118.  
  119.  
  120.     function save() {
  121.         $ret=parent::save();
  122.  
  123.         $this->lookupTable      = "T_CLI_CLIENT";
  124.         $this->lookupField      = "CLI_ID";
  125.         $this->lookupSort       = "CLI_NAME1,CLI_NAME2";
  126.         $this->nullLabel        = "--- ??? ---";
  127.         $this->allowNullSelect  = FALSE;
  128.         $this->nullValue        = 0;
  129.         $this->ctyId            = (isset($_POST['ctyId']) ? intval($_POST['ctyId']) : 0);
  130.  
  131.         if (intval($this->ctyId)) {
  132.             $this->lookupWhere=" CTY_ID=".$this->ctyId;
  133.         }
  134.  
  135.         return $ret;
  136.     }
  137. }
  138. ?>

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