Source for file DBMS_FIELD_FOREIGNKEY.phpclass

Documentation is available at DBMS_FIELD_FOREIGNKEY.phpclass

  1. <?php
  2. /**
  3.   * Class file DBMS_FIELD_FOREIGNKEY.phpclass
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms_field
  7.   * @category   int
  8.   *
  9.   * @author     Peter Krebs (pk) <pitlinz@users.sourceforge.net>
  10.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  11.   *
  12.   * @version $Id: DBMS_FIELD_FOREIGNKEY.phpclass,v 1.18 2008/12/03 21:32:40 pitlinz Exp $
  13.   */
  14.  
  15.     // ---------------------------------------------------------------------------
  16.     // requirements
  17.     // ---------------------------------------------------------------------------
  18.  
  19.     pcf_require_class('DBMS_FIELD_DBLOOKUPSELECTLIST',dirname(__FILE__)."/");
  20.  
  21.     
  22. /**
  23.   * handles foreign key fields
  24.   *
  25.   * @project    Open CSP-Management
  26.   * @package    dbms_field
  27.   * @category   int
  28.   *
  29.   * @author     Peter Krebs (pk) <pitlinz@users.sourceforge.net>
  30.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  31.   *
  32.   * @version pk-06-08-09
  33.   * @version pk-06-10-05 nullToZero added
  34.   * @version pk-07-08-31
  35.   *
  36.   * @version $Id: DBMS_FIELD_FOREIGNKEY.phpclass,v 1.18 2008/12/03 21:32:40 pitlinz Exp $
  37.   */
  38. class DBMS_FIELD_FOREIGNKEY extends DBMS_FIELD_DBLOOKUPSELECTLIST 
  39. {
  40.     // ---------------------------------------------------------------------------
  41.     // constants
  42.     // ---------------------------------------------------------------------------
  43.     
  44.     /**
  45.      * @constant string CLASS_SRC_FILE
  46.      */
  47.     const CLASS_SRC_FILE = __FILE__;
  48.  
  49.     // ---------------------------------------------------------------------------
  50.     // class (static)
  51.     // ---------------------------------------------------------------------------
  52.     
  53.     /*** class vars ------------------------------------------------------ */
  54.  
  55.     /*** class methods --------------------------------------------------- */    
  56.     
  57.     // ---------------------------------------------------------------------------
  58.     // object vars
  59.     // ---------------------------------------------------------------------------
  60.     
  61.     /*** compostion --------------------------------------------------- */
  62.     
  63.     /*** attributes --------------------------------------------------- */
  64.         
  65.     /**
  66.       * source file of the class
  67.       *
  68.       * @var string $classSrcFile 
  69.       * @since pk-05-01-20
  70.       */
  71.     protected $classSrcFile=__FILE__;
  72.  
  73.     /**
  74.       * @var boolean $checkWhereAnd 
  75.       * @since pk-05-09-30
  76.       ***/
  77.     protected $checkWhereAnd      =FALSE;
  78.  
  79.     /**
  80.      * url to popup for a new entry
  81.      *
  82.      * @var string $newUrl 
  83.      */
  84.     protected $newUrl             = "";
  85.     
  86.     /**
  87.      * @var int $newFormId 
  88.      * @since pk-08-02-21
  89.      */
  90.     protected $newFormId=0;
  91.     
  92.     /**
  93.      * edit or insert data with ajax or open an popup
  94.      *
  95.      * @var boolean 
  96.      */
  97.     protected $newEditAsAjax    = TRUE;
  98.     
  99.     /**
  100.      * width of the popup window
  101.      *
  102.      * @var int $popupWndWidth 
  103.      */
  104.     protected $popupWndWidth        = "600";
  105.     
  106.     /**
  107.      * hight of the popup window
  108.      *
  109.      * @var int popupWndHeight
  110.      */
  111.     protected $popupWndHeight       = "400";
  112.  
  113.     /**
  114.       * @var string $editUrl url to the field editor
  115.       * @version pk-03-10-17
  116.       * @todo add tags to input field link new
  117.       * @access protected
  118.       ***/
  119.     protected $editUrl             = "";
  120.     
  121.     /**
  122.      * @var int $editFormId 
  123.      * @since pk-08-02-21
  124.      */
  125.     protected $editFormId=0;    
  126.  
  127.     /**
  128.       * @var int $editEnableInList link List field with edit url
  129.       * @version pk-03-10-17
  130.       * @access protected
  131.       ***/
  132.     protected $editEnableInList   = TRUE;
  133.  
  134.     /**
  135.       * @var string $myURIQueryArrgs   semicolon seperated list of url arguments
  136.       * @since pk-04-09-07
  137.       * @access protected
  138.       ***/
  139.     protected $myURIQueryArrgs    = "";
  140.     
  141.     /**
  142.      * css class of the detail layer div
  143.      * 
  144.      * @var string $myLayerDivClass 
  145.      * 
  146.      * @since pk-08-02-27
  147.      */
  148.     protected $myLayerDivClass      = "";
  149.     
  150.     /**
  151.      * css style of the detail layer div
  152.      * 
  153.      * @var string $myLayerDivStyle 
  154.      * 
  155.      * @since pk-08-02-27
  156.      */
  157.     protected $myLayerDivStyle      = "";
  158.     
  159.     // ---------------------------------------------------------------------------
  160.     // factory / construct
  161.     // ---------------------------------------------------------------------------
  162.  
  163.     // ---------------------------------------------------------------------------
  164.     // init
  165.     // ---------------------------------------------------------------------------
  166.         
  167.     /**
  168.       * convert old object vars to DBMS_FIELD_DBLOOKUPSELECTLIST
  169.       * and then calls the parent method
  170.       *
  171.       * @param array $varArr 
  172.       * @param boolean $debug 
  173.       *
  174.       */
  175.     function setObjectVars($varArr,$debug=FALSE) {
  176.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_FOREIGNKEY::setObjectVars(...)",print_r($varArr,TRUE));
  177.  
  178.         foreach($varArr as $str_name => $m_val)
  179.         {
  180.             if (!empty($m_val))
  181.             {
  182.                 switch($str_name)
  183.                 {
  184.                     case "foreignTbl":
  185.                         if (!empty($varArr['lookupTable'])) $varArr['lookupTable']=$m_val;
  186.                         unset($varArr['foreignTbl']);
  187.                         break;
  188.                     case "showField":
  189.                         if (!empty($varArr['lookupShowField'])) $varArr['lookupShowField']=$m_val;
  190.                         unset($varArr['foreignTbl']);
  191.                         break;
  192.                     case "lst_showFld":
  193.                         if (!empty($varArr['lookupShowLstField'])) $varArr['lookupShowLstField']=$m_val;
  194.                         unset($varArr['lst_showFld']);
  195.                         break;
  196.                     case "keyField":
  197.                         if (!empty($varArr['lookupField'])) $varArr['lookupField']=$m_val;
  198.                         unset($varArr['keyField']);
  199.                         break;
  200.                     case "whereAnd":
  201.                         if (!empty($varArr['lookupWhere'])) $varArr['lookupWhere']=$m_val;
  202.                         unset($varArr['whereAnd']);
  203.                         break;
  204.                     case "sortField":
  205.                         if (!empty($varArr['lookupSort'])) $varArr['lookupSort']=$m_val;
  206.                         unset($varArr['whereAnd']);
  207.                         break;
  208.                     case "allowNullSelect":
  209.                         $varArr['showNullOption']=$m_val;
  210.                         unset($varArr['allowNullSelect']);
  211.                         break;
  212.                 }
  213.             }
  214.         }
  215.         parent::setObjectVars($varArr,$debug);
  216.     }
  217.  
  218.     // ---------------------------------------------------------------------------
  219.     // dbms admin backoffice 
  220.     // ---------------------------------------------------------------------------    
  221.     
  222.     /**
  223.       * returns an array of field to bie shown in the edit form
  224.       * by using editTbl_echoForm
  225.       *
  226.       * the array is in the form:
  227.       *
  228.       * <code>
  229.       * [_sectionName_]
  230.       *      [TITLE] -> string
  231.       *      [_rowName_]
  232.       *         [FLDLAB]  (complete html code with <td></td>)
  233.       *         [FLDVAL] (complete html code with <td></td>)
  234.       * </code>
  235.       *
  236.       * @param boolean $debug 
  237.       *
  238.       * @returns array
  239.       *
  240.       * @since pk-06-04-26
  241.       * @version pk-06-04-29
  242.       *
  243.       */
  244.     function editTbl_getFieldEditArr($debug=FALSE) {
  245.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_FOREIGNKEY::editTbl_getFieldEditArr","",0);
  246.  
  247.         if (empty($this->keyField)) $this->keyField=$this->myName; // <pk-06-11-29 />
  248.         $a_ret=parent::editTbl_getFieldEditArr($debug);
  249.  
  250.         $a_ret['LAYOUT']['FLD_SIZE']=NULL;      // unset parent field
  251.         $a_ret['LAYOUT']['FLD_INPUTADD']=NULL;  // unset parent field
  252.  
  253.         $a_ret['SELECT']['FLD_MULTISEL']=NULL;  // unset parent field
  254.  
  255.         //$a_ret['DBLOOKUP']['FLD_LSTADDVALUES']['FLDVAL']="<input name=\"allowAddValues\" type=\"checkbox\"".($this->allowAddValues ? " checked=\"checked\"" : "")." value=\"1\" />ja";
  256.         unset($a_ret['DBLOOKUP']['FLD_LSTADDVALUES']); // unset parent field
  257.         
  258.         $a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL'].="<input name=\"checkWhereAnd\" type=\"checkbox\"".($this->checkWhereAnd ? " checked=\"checked\"" : "")." value=\"1\" /> beim speichern &uuml;berpr&uuml;fen.";
  259.  
  260.         // <pk-06-05-19> compat
  261.         if (!intval($this->popupWndWidth)) {
  262.             $this->popupWndWidth=max($this->newWndWidth,$this->editWndWidth);
  263.         }
  264.         if (!intval($this->popupWndHeight)) {
  265.             $this->popupWndHeight=max($this->newWndHeight,$this->editWndHeight);
  266.         }
  267.         // </pk-06-05-19>
  268.  
  269.         /*
  270.         $a_ret['FTBL_POPUPS']=array(
  271.             'TITLE'=>"Bearbeiten/Hinzuf&uuml;gen",
  272.             'FLD_NEWPUP'=>array(
  273.                 'FLDLAB'=>"Neuer Datensatz",            
  274.                 'FLDVAL'=>"
  275.                     <input name=\"allowAddValues\" type=\"checkbox\" value=\"1\" " . ($this->allowAddValues ? "checked=\"checked\"" : "") . " /> hinzuf&uuml;gen von Daten erlauben<br /> 
  276.                     URL: <input name=\"newUrl\" value=\"" . $this->newUrl . "\" size=\"50\" /><br />
  277.                     Form: <select name=\"newFormId\" id=\"" . str_replace(".","_",$this->getKey()) . "_newForm\" >
  278.                         <option value=\"\">[Formular w&auml;hlen]</option>
  279.                         " . OCSP_FORM::findForm_getHTMLOptionList($this->lookupTable,$this->newFormId,$debug) ."
  280.                     </select>"
  281.             ),
  282.  
  283.             'FLD_EDITPUP'=>array(
  284.                 'FLDLAB'=>"Datensatz bearbeiten URL",
  285.                 'FLDVAL'=>"
  286.                     <input name=\"allowEditValues\" type=\"checkbox\" value=\"1\" " . ($this->allowEditValues ? "checked=\"checked\"" : "") . " /> bearbeiten von Details erm&ouml;glichen<br />
  287.                     URL: <input name=\"editUrl\" value=\"".$this->editUrl."\" size=\"50\" /><br />
  288.                     Form: <select name=\"editFormId\" id=\"" . str_replace(".","_",$this->getKey()) . "_editForm\" >
  289.                         <option value=\"\">[Formular w&auml;hlen]</option>
  290.                         " . OCSP_FORM::findForm_getHTMLOptionList($this->lookupTable,$this->editFormId,$debug) ."
  291.                     </select>"                                    
  292.             ),
  293.             'FLD_POPUPSIZE'=>array(
  294.                 'FLDLAB'=>"Popup",
  295.                 'FLDVAL'=>"
  296.                             <input type=\"checkbox\" name=\"newEditAsAjax\" value=\"1\" " . ($this->newEditAsAjax ? "" : "checked=\"checked\" ") . " /> als Popup öffnen <hr />
  297.                             Gr&ouml;&szlig;e: 
  298.                             width=<input  name=\"popupWndWidth\" value=\"".$this->popupWndWidth."\"  size=\"4\" />&nbsp;
  299.                             height=<input name=\"popupWndHeight\"  value=\"".$this->popupWndHeight."\"  size=\"4\" />&nbsp; <hr />
  300.                             Popup Arguments: <input name=\"myURIQueryArrgs\" value=\"" .$this->myURIQueryArrgs ."\" size=\"40\" /><br />(durch Semicolon \";\" getrennte Feldnamen)  
  301.                           "
  302.             ),            
  303.             'FLD_LAYERPROPS'=>array(
  304.                 'FLDLAB'=>"Layer div class",
  305.                 'FLDVAL'=>"&lt;div class=\"<input name=\"myLayerDivClass\" value=\"" . $this->myLayerDivClass . "\" size=\"15\" />\" 
  306.                             style=\"<input name=\"myLayerDivStyle\" value=\"" . $this->myLayerDivStyle . "\" />\" &gt;"
  307.             )
  308.  
  309.         );
  310.         */
  311.         return $a_ret;
  312.     }
  313.  
  314.     /**
  315.      * update editTbl_getFieldEditArr fields after change of the table
  316.      *
  317.      * @param array $options 
  318.      * 
  319.      * @return string (js)
  320.      * 
  321.      * @since pk-08-02-10
  322.      */
  323.     public function editTbl_tableChanged($options)
  324.     {
  325.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_FOREIGNKEY::editTbl_tableChanged()");
  326.            
  327.         if ($arr_forms = OCSP_FORM::findForm_listForTable($options['table']))
  328.         {
  329.             $str_options = "var i=1;\n"; // one to not overwrite the empty option
  330.             foreach($arr_forms as $arr_row)
  331.             {
  332.                 $str_options .= "obj_opt = new Option('" . $arr_row['FRM_NAME'] . " (ID: " . $arr_row['FRM_ID'] . ")','" . $arr_row['FRM_ID'] . "');";
  333.                 $str_options .= "obj_opt.title = '" . pcf_makeJS_QuotedString($arr_row['FRM_DESC'],"'") . "';";
  334.                 $str_options .= "obj_sel.options[i++] = obj_opt;\n";             
  335.             }
  336.         } else {
  337.             $str_options = "var i=1;";
  338.         }
  339.         
  340.         $str_ret = "
  341.             if (obj_sel = document.getElementById('" . str_replace(".","_",$this->getKey()) . "_newForm'))
  342.             {
  343.                 obj_sel.selectedIndex = 0;
  344.                 obj_sel.options.length = 1;
  345.                 " . $str_options . "
  346.             } else {
  347.                 alert('" . str_replace(".","_",$this->getKey()) . "_newForm not found');
  348.             }
  349.             if (obj_sel = document.getElementById('" . str_replace(".","_",$this->getKey()) . "_editForm'))
  350.             {
  351.                 obj_sel.selectedIndex = 0;
  352.                 obj_sel.options.length = 1;
  353.                 " . $str_options . "
  354.             } else {
  355.                 alert('" . str_replace(".","_",$this->getKey()) . "_editForm not found');
  356.             }           
  357.         ";
  358.         
  359.         $str_ret = "try {" . $str_ret . "} catch(e) { alert(e); }";
  360.         return $str_ret;
  361.     }
  362.     
  363.     /**
  364.       * save the filed definition form
  365.       *
  366.       * @returns bool <code>parent::save()</code>
  367.       * @version pk-03-10-17
  368.       * @version pk-06-01-24
  369.       * @version pk-08-02-27
  370.       *
  371.       ***/
  372.     function save($debug=FALSE) {
  373.         $ret=parent::save($debug);
  374.  
  375.          if (isset($this->foreignTbl))          unset($this->foreignTbl);
  376.          if (isset($this->showField))           unset($this->showField);
  377.          if (isset($this->lst_showFld))         unset($this->lst_showFld);
  378.          if (isset($this->keyField))               unset($this->keyField);
  379.          if (isset($this->sortField))               unset($this->sortField);
  380.          if (isset($this->allowNullSelect))     unset($this->allowNullSelect);
  381.         
  382.         $this->multiselect          = FALSE;
  383.  
  384.         $this->popupWndWidth        = ((isset($_POST['popupWndWidth']) && (intval($_POST['popupWndWidth']) > 10)) ? intval($_POST['popupWndWidth']) : 600);
  385.         $this->popupWndHeight       = ((isset($_POST['popupWndHeight']) && (intval($_POST['popupWndHeight']) > 10)) ? intval($_POST['popupWndHeight']) : 380);
  386.         $this->newEditAsAjax        = ((isset($_POST['newEditAsAjax']) && intval($_POST['newEditAsAjax'])) ? FALSE : TRUE);
  387.         
  388.         $this->newUrl               = (isset($_POST['newUrl']) ? $_POST['newUrl'] : $this->newUrl);
  389.         $this->newFormId            = (isset($_POST['newFormId']) ? intval($_POST['newFormId']) : 0);
  390.         
  391.         $this->editUrl              = (isset($_POST['editUrl']) ? $_POST['editUrl'] : $this->editUrl);
  392.         $this->editFormId            = (isset($_POST['editFormId']) ? intval($_POST['editFormId']) : 0);
  393.         
  394.         if ($this->editEnableInList)
  395.         {
  396.             $this->lstDisableLinks=TRUE;
  397.         } else {
  398.             $this->lstDisableLinks=FALSE;
  399.         }
  400.         // </pk-03-10-17>
  401.  
  402.         // <pk-04-07-29 />
  403.         $this->myURIQueryArrgs      =(isset($_POST['myURIQueryArrgs']) ? $_POST['myURIQueryArrgs'] : $this->myURIQueryArrgs);
  404.         // <pk-08-02-27 />
  405.         $this->myLayerDivClass        =(isset($_POST['myLayerDivClass'])  ? $_POST['myLayerDivClass']  : "");
  406.         $this->myLayerDivStyle        =(isset($_POST['myLayerDivStyle'])  ? $_POST['myLayerDivStyle']  : "");
  407.  
  408.         return $ret;
  409.     }
  410.  
  411.     // ---------------------------------------------------------------------------
  412.     // buttons 
  413.     // ---------------------------------------------------------------------------    
  414.         
  415.     /**
  416.       * returns the html code for the new button
  417.       *
  418.       * @param string $arrName 
  419.       * @param boolean $debug 
  420.       * 
  421.       * @global array $OCSP_CONF 
  422.       *
  423.       * @returns string
  424.       *
  425.       * @since pk-08-02-22
  426.       */
  427.     function getNewBtn($arrName="DBVAL",$debug=FALSE) 
  428.     {    
  429.         global $OCSP_CONF;
  430.         
  431.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBLOOKUPSELECTLIST::getNewBtn","arrName: $arrName",0);
  432.               
  433.         if ($debug)
  434.         {            
  435.             $str_onClick = "try {
  436.                 alert('add new Detail: " . $this->myName . "');";
  437.         } else {
  438.             $str_onClick = "";
  439.         }
  440.         
  441.         $str_onClick .= "
  442.                 if (obj_form = jOCSP.getFormByHash('" . $this->myControll->jOCSP_getfrmHash() . "'))
  443.                 {
  444.                     if (obj_fld = obj_form.getFieldByDomId('" . $this->getDOMId() . "'))
  445.                     {
  446.                         obj_fld.addDetail();
  447.                     }
  448.                 }
  449.             ";
  450.         
  451.         
  452.         if ($debug)
  453.         {
  454.             $str_onClick .= "} catch(e) {alert('Field: " . $this->myName . ": ' + e);}"; 
  455.         }
  456.                 
  457.         return "<a onclick=\"" . pcf_js_escapeOnEventCmd($str_onClick) . "\"><img src=\"" . $OCSP_CONF['SYSIMGURL'] . "icons-16x16/filenew.gif\" border=\"0\" alt=\"neuer Eintrag\" align=\"middle\" class=\"button\" /></a>";
  458.     }
  459.     
  460.  
  461.     /**
  462.       * returns the html code for a button to zoom to the foreign record
  463.       *
  464.       * @param string $arrName 
  465.       * @param boolean $debug (pk-05-10-23)
  466.       *
  467.       * @returns string
  468.       *
  469.       * @version pk-05-02-22 parse url as template using ${$arrName} as value array
  470.       * @version pk-05-03-17 getPopupLinkJs added -> rewrite
  471.       * @version pk-05-10-04
  472.       * @version pk-05-10-23 param $debug added
  473.       * @version pk-06-01-03
  474.       *
  475.       ***/
  476.     function getZoomBtn($debug=FALSE) 
  477.     {
  478.         global $OCSP_CONF;
  479.         
  480.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBLOOKUPSELECTLIST::getZoomButton","arrName: $arrName",0);
  481.  
  482.         
  483.            if (!empty($this->editUrl) || intval($this->editFormId))
  484.            {        
  485.             if ($debug)
  486.             {            
  487.                 $str_onClick = "try {
  488.                     alert('edit Detail: " . $this->myName . "');";
  489.             } else {
  490.                 $str_onClick = "";
  491.             }
  492.             
  493.             $str_onClick .= "
  494.                     if (obj_form = jOCSP.getFormByHash('" . $this->myControll->jOCSP_getfrmHash() . "'))
  495.                     {
  496.                         if (obj_fld = obj_form.getFieldByDomId('" . $this->getDOMId() . "'))
  497.                         {
  498.                             obj_fld." . ($this->allowEditValues ? "editDetail" : "showDetail") ."();
  499.                         }
  500.                     }
  501.                 ";
  502.             
  503.             
  504.             if ($debug)
  505.             {
  506.                 $str_onClick .= "} catch(e) {alert('Field: " . $this->myName . ": ' + e);}"; 
  507.             }
  508.                     
  509.             return "<a onclick=\"" . pcf_js_escapeOnEventCmd($str_onClick) . "\"><img src=\"" . $OCSP_CONF['SYSIMGURL'] . "icons-16x16/" . ($this->allowEditValues ? "edit.gif" : "viewmag.gif") . "\" border=\"0\" alt=\"Details\" align=\"middle\" class=\"button\" /></a>";
  510.            } else {
  511.                return "";
  512.            }
  513.     }
  514.  
  515.     // -------------------------------------------------
  516.     // OBJECT VALUE CHECK/RETURN METHODS
  517.     // -------------------------------------------------
  518.     
  519.     /**
  520.       * returns the field value if the referenzed row exists
  521.       *
  522.       * @param  string  $aValue     the value
  523.       * @param  array   $err        error array
  524.       * @param  string  $arrName    name of the array to access fieldsarray  gloabl ${$arrName}
  525.       * @param  bool    $debug 
  526.       *
  527.       * @returns string
  528.       *
  529.       * @since   pk-03-12-13
  530.       * @version pk-03-12-13
  531.       * @version pk-04-12-31 $this->label added to NULL ERROR MSG
  532.       * @version pk-05-06-16 debug due to fieldsettings
  533.       * @version pk-07-09-10 null handling
  534.       *
  535.       ***/
  536.     function getValue($aValue,&$err,$arrName="DBVAL",$debug=False) {       
  537.         global ${$arrName};
  538.         $debug = ($debug || $this->fldDebug || $this->fldDbgGetValue); // <pk-05-06-16 />
  539.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_FOREIGNKEY::getValue(".$aValue.") | ".$this->getKey());
  540.  
  541.         $aValue=trim($aValue);
  542.         if (empty($aValue)) {
  543.             
  544.             if (!$this->isToShow($this->myForm->getFrmMode(),${$arrName},$debug))
  545.             {
  546.                 return Null;
  547.             }
  548.             
  549.             if ($debug) echoDebugLine(__FILE__,__LINE__,"NullSelect: ".($this->showNullOption ? "true" : "false")." nullToZero: ".($this->nullToZero ? "true" : "false")." allowNull: ".($this->allowNull ? "true" : "false"));
  550.             if ($this->showNullOption && $this->nullToZero)
  551.             {
  552.                 if ($debug) echoDebugLine(__FILE__,__LINE__,"Returning 0");
  553.                 return 0;
  554.             } else if ($this->showNullOption && $this->allowNull) {
  555.                 if ($debug) echoDebugLine(__FILE__,__LINE__,"Returning $aValue");
  556.                 return $aValue;
  557.             } else {
  558.                 $err['ERROR']=TRUE;
  559.                 $err[$this->myName]['MSG']=(empty($this->nullErrMsg) ? $this->myForm->getLangTxt("NULL_NOT_ALLOWED") : $this->nullErrMsg);
  560.                 $err[$this->myName]['LABEL']=$this->label;
  561.  
  562.                 if ($debug) echoDebugLine(__FILE__,__LINE__,"Returning ERROR <pre>".print_r($err,TRUE)." with value: $aValue");
  563.                 return $aValue;
  564.             }
  565.         }
  566.  
  567.         
  568.         $arr_parentError=array();
  569.         $aValue=parent::getValue($aValue,$arr_parentError,$arrName,$debug);
  570.  
  571.         if (!isset($arr_parentError['ERROR']) || !$arr_parentError['ERROR'])
  572.         {
  573.             if ($this->checkWhereAnd)
  574.             {
  575.                 if (!($obj_myDB=$this->myForm->getDBObj()))
  576.                 if ($obj_myDB->getRow($this->lookupTable,array($this->lookupField => $aValue)))
  577.                 {
  578.                     return $aValue;
  579.                 } else {
  580.                     $err['ERROR']=True;
  581.                     $err[$this->myName]['MSG']="ROW_NOT_FOUND";
  582.                     $err[$this->myName]['LABEL']=$this->label;
  583.                     return $aValue;
  584.                 }
  585.             }
  586.         }
  587.         return $aValue;
  588.     }
  589.     
  590.     // -------------------------------------------------
  591.     // jOCSP rpc commands
  592.     // -------------------------------------------------
  593.  
  594.     /**
  595.      * creates an layer for the detail record
  596.      *
  597.      * @param int $mode 
  598.      * @param array $options 
  599.      * @param boolean $debug 
  600.      * 
  601.      * @return string (js)
  602.      */
  603.     public function jOCSP_detailFormLayer($mode,&$options,$debug=FALSE)
  604.     {
  605.         if ($debug) 
  606.         {
  607.             $str_ret = "alert('jOCSP_detailFormLayer: " . pcf_js_escape(print_r($options,TRUE)) . "');";
  608.         } else {
  609.             $str_ret = "";
  610.         }
  611.  
  612.         $obj_ajax = $this->myForm->ajax_getObj(TRUE);
  613.         
  614.         if (intval($this->newFormId))
  615.         {
  616.             $obj_form = OCSP_FORM::factory_from_id($this->newFormId);
  617.             $obj_form->ajax_setObj($options['AJAXOBJ']);
  618.             $obj_form->setFrmMode($mode);
  619.             
  620.             $obj_controll = $obj_form->getControllObj('OCSP_FRMCONTR_JQUERY');
  621.             $obj_controll->setBackCmd("document.getElementById('" . $options['domId'] . "').closeDetail();");
  622.             
  623.             if ($mode == FRM_MODE_NEW)
  624.             {
  625.                 if (isset($options['FRMARRAYNAME']))
  626.                 {
  627.                     $obj_controll->setValuesFromArray($options[$options['FRMARRAYNAME']]);
  628.                 }
  629.             } else {
  630.                 if (isset($optons['foreignKey']) && (!empty($optons['foreignKey'])))
  631.                 {
  632.                     $arr_errors = array();
  633.                     if ($mix_lookupValue = $this->getValue($optons['foreignKey'],$arr_errors))
  634.                     {
  635.                         $obj_controll->addFilter($this->lookupField,$mix_lookupValue);
  636.                     }        
  637.                 } else if (isset($options['FRMARRAYNAME']) && is_array($options[$options['FRMARRAYNAME']])) {
  638.                     if ($mix_lookupValue = $this->getValue($options[$options['FRMARRAYNAME']][$this->getName()],$arr_errors))
  639.                     {
  640.                         $obj_controll->addFilter($this->lookupField,$mix_lookupValue);
  641.                     }                            
  642.                 }                 
  643.             }
  644.             
  645.             $obj_controll->setNextUrl("js:document.getElementById('" . $options['domId'] . "').closeDetail('\$*" . $this->lookupField . "\$');");
  646.             
  647.             $obj_view = $obj_form->getViewObj('OCSP_FRMVIEW_FORM');
  648.                         
  649.             $str_frmContent = $obj_view->getForm($mode);  
  650.             
  651.             
  652.         }
  653.          
  654.         $str_ret .=" 
  655.              if (obj_fld = document.getElementById('" . $options['domId'] . "'))
  656.              {
  657.                  obj_fld.closeDetail = function(aValue)
  658.                  {                     
  659.                      this.det_shadow.parentNode.removeChild(this.det_shadow);
  660.                      this.detLayer.parentNode.removeChild(this.detLayer);
  661.                      
  662.                      if (aValue) 
  663.                      {
  664.                          try {
  665.                              this.jOCSPFldObj.addOption(aValue,aValue,false,true);
  666.                              this.jOCSPFldObj.reloadOptionLst(aValue);                             
  667.                          } catch(e) {
  668.                              alert(e);
  669.                          }
  670.                      }                     
  671.                  }
  672.                  
  673.                  alert('Field: ' + typeof(obj_fld) + 'Cur Value: ' + obj_fld.value);
  674.                  
  675.                  try {                  
  676.                      dom_form = obj_fld.form;                                 
  677.                     obj_form = jOCSP.getFormByHash(dom_form.jOCSP_frmHash);
  678.                     
  679.                     
  680.                     obj_fld.det_shadow = obj_form.disableWithShadow();
  681.                     
  682.                     obj_fld.detLayer = jOCSP.dom.formLayerCreate(obj_form.getDomObj().parentNode.id);
  683.             ";
  684.         if ($this->myLayerDivClass)
  685.         {
  686.             $str_ret .= "obj_fld.detLayer.className='" . $this->myLayerDivClass . "'";
  687.         }
  688.         $str_ret .= "
  689.                     obj_fld.detLayer.innerHTML = '". pcf_js_escape($str_frmContent). "';
  690.                                                             
  691.                 } catch(e) {
  692.                     alert(e);
  693.                 }
  694.              } else {
  695.                  " . jOCSP_registerError("DBMS_FIELD_FOREIGNKEY::jOCSP_detailFormLayer() field id: " . $options['domId'] ." not found",FALSE,print_r($_REQUEST,TRUE)) ."
  696.              }
  697.          ";
  698.          return $str_ret;
  699.     }
  700.     
  701.     
  702.     /**
  703.      * shows the form or url to add a new record in the foreign table
  704.      *
  705.      * @param array $options 
  706.      * @param boolean $debug 
  707.      * 
  708.      * @return string (javascript)
  709.      */
  710.     public function jOCSP_addDetail($options,$debug=FALSE)
  711.     {
  712.         if ($this->allowAddValues)
  713.         {
  714.             if ($this->newEditAsAjax)
  715.             {
  716.                 return $this->jOCSP_detailFormLayer(FRM_MODE_NEW,$options,$debug);
  717.             }
  718.         }
  719.     }
  720.    
  721.  
  722.     /**
  723.      * shows the form or url to edit a record in the foreign table
  724.      *
  725.      * @param array $options 
  726.      * @param boolean $debug 
  727.      * 
  728.      * @return string (javascript)
  729.      */
  730.     public function jOCSP_editDetail($options,$debug=FALSE)
  731.     {
  732.         if ($this->allowEditValues)
  733.         {
  734.             if ($this->newEditAsAjax)
  735.             {
  736.                 return $this->jOCSP_detailFormLayer(FRM_MODE_EDIT,$options,$debug);
  737.             }
  738.         }
  739.     }    
  740.     
  741.     
  742.     /**
  743.      * shows the form or url to edit a record in the foreign table
  744.      *
  745.      * @param array $options 
  746.      * @param boolean $debug 
  747.      * 
  748.      * @return string (javascript)
  749.      */
  750.     public function jOCSP_showDetail($options,$debug=FALSE)
  751.     {
  752.         if ($this->allowEditValues)
  753.         {
  754.             if ($this->newEditAsAjax)
  755.             {
  756.                 return $this->jOCSP_detailFormLayer(FRM_MODE_READONLY,$options,$debug);
  757.             }
  758.         }
  759.     }     
  760. }
  761. ?>

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