File Source for DBMS_FIELD_DBLOOKUPPOPUPSELECT.phpclass

<?php
/**
* Class file DBMS_FIELD_DBLOOKUPPOPUPSELECT.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-06-02-10
* @version $Id: DBMS_FIELD_DBLOOKUPPOPUPSELECT.phpclass,v 1.4 2008/08/08 02:00:42 pitlinz Exp $
*/
pcf_require_class('DBMS_FIELD_DBLOOKUPSELECTLIST',dirname(__FILE__) . "/");
/**
* Class DBMS_FIELD_DBLOOKUPPOPUPSELECT
*
* handels select fields (<SELECT>) where the values are selected form the database
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-06-02-10
* @version $Id: DBMS_FIELD_DBLOOKUPPOPUPSELECT.phpclass,v 1.4 2008/08/08 02:00:42 pitlinz Exp $
*/
class DBMS_FIELD_DBLOOKUPPOPUPSELECT extends DBMS_FIELD_DBLOOKUPSELECTLIST {
// ###########################################################
// OBJECT (CONST) VAR DECLARATION
// ###########################################################
var $className = "LookupDbPopUp";
/**
* source file of the class
*
* @var string $classSrcFile
***/
var $classSrcFile=__FILE__;
/**
* @var int $popUp_frmId
***/
var $popUp_frmId=0;
/**
* @var int $popUp_url
***/
var $popUp_url="";
/**
* @var int $popUp_width
***/
var $popUp_width=350;
/**
* @var int $popUp_height
***/
var $popUp_height=500;
// ###########################################################
// OBJECT SETTINGS METHODS
// ###########################################################
/**
* returns an array of field to bie shown in the edit form
* by using editTbl_echoForm
*
* the array is in the form:
*
* <code>
* [_sectionName_]
* [TITLE] -> string
* [_rowName_]
* [FLDLAB] (complete html code with <td></td>)
* [FLDVAL] (complete html code with <td></td>)
* </code>
*
* @param boolean $debug
*
* @returns array
*
* @since pk-06-04-26
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBLOOKUPPOPUPSELECT::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
$a_ret['SELECT']['FLD_RADCHKBOX']=NULL; // unset parent value
$a_ret['DBLOOKUP']['FLD_LSTADDVALUES']=array(
'FLDLAB'=>"Werte hinzufügen",
'FLDVAL'=>"<input name=\"allowAddValues\" type=\"checkbox\"".($this->allowAddValues ? "checked" : "")." value=\"1\">ja fals im Formular möglich"
);
$a_ret['DBLOOKUP']['FLD_LSTEDITVALUES']=array(
'FLDLAB'=>"Werte bearbeiten",
'FLDVAL'=>"<input name=\"allowEditValues\" type=\"checkbox\"".($this->allowEditValues ? "checked" : "")." value=\"1\">ja fals im Formular möglich"
);
$a_ret['LOOKUPFORM']=array(
'TITLE'=>"Popup Formular",
'FLD_POPFORM'=>array(
'FLDLAB'=>"Popup Formular"
),
'FLD_POPLINK'=>array(
'FLDLAB'=>"URL <a href=\"".$GLOBALS['OCSP']['SYSTEMURL']."help/templatevars.html\" target=\"_blank\">?</a>",
'FLDVAL'=>"<input name=\"popUp_url\" value=\"".$this->popUp_url."\" size=\"40\">"
),
'FLD_POPUPSIZE'=>array(
'FLDLAB'=>"Popup Größe",
'FLDVAL'=>"
width: <input name=\"popUp_width\" value=\"".$this->popUp_width."\" size=\"4\"> px
height: <input name=\"popUp_height\" value=\"".$this->popUp_height."\" size=\"4\"> px
"
)
);
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL']="<select name=\"popUp_frmId\" size=\"1\">\n";
$s_query="SELECT FRM_ID,FRM_NAME,FRM_TABLES FROM T_DBMS_FORM ORDER BY FRM_TABLES,FRM_NAME";
$b_found=FALSE;
if ($o_cursor=$GLOBALS['USRDB']->query($s_query)) {
while($a_row=$o_cursor->fetchArrayFld()) {
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL'].="\t<option value=\"".$a_row['FRM_ID']."\" title=\"".$a_row['FRM_TABLES']."\"";
if ($this->popUp_frmId == $a_row['FRM_ID']) {
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL'].=" selected";
$b_found=TRUE;
}
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL'].=">".$a_row['FRM_NAME']." (".$a_row['FRM_ID'].")</option>\n";
}
}
if (!$b_found) {
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL'].="\t<option value=\"\" selected>[URL]</option>\n";
}
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL'].="</select>";
if ($GLOBALS['USER']->isGroupMember($GLOBALS['GROUPS']['DBMS'])) {
$a_ret['LOOKUPFORM']['FLD_POPFORM']['FLDVAL'].="<a onClick=\"
var frmId=getSelectedOptionByName(document.forms['frmEdit'],'popUp_frmId');
if (frmId=='') {
alert('Wählen Sie zuerst ein Formular aus');
} else {
var link='".$GLOBALS['PROJECT']['ADMINURL']."dbms/fieldList.php?';
link=link+'&FRM_ID='+frmId;
openLinkWnd(link);
}
\" title=\"Formular bearbeiten\">
<img src=\"".$GLOBALS['OCSP']['SYSIMGURL']."icons-16x16/utilities.png\" border=\"0\" class=\"button\">
</a>";
}
return $a_ret;
}
/**
* save the filed definition form
*
* @returns boolean
*
* @version pk-04-12-31
* @version pk-06-02-06 popUp_frmId
*
***/
function save() {
$ret=parent::save();
$this->popUp_frmId =(intval($_POST['popUp_frmId']));
$this->popUp_url =$_POST['popUp_url'];
$this->popUp_width =(intval($_POST['popUp_width']));
$this->popUp_height =(intval($_POST['popUp_height']));
return $ret;
}
// ###########################################################
// OBJECT DATA METHODS
// ###########################################################
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
/**
* return a javascript code sequence to popup a input or edit dialog
*
* if $selName isset this is used instead of $this->myName
*
* if $mode is different from FRM_MODE_NEW the popup must get
* the value through javascript
*
* see $GLOBALS['OCSP']['SYSTEMURL']."forms/popup_form.php" for details
*
* if !empty $setMethod popup_form.php calls this method after adding
* the option instead of selecting the option
*
* @param int $mode
* @param string $selName since 06-02-10 (name of the select element if different from $this->myName)
* @param string $setMethod (js method template to call instead of directly setting the value)
* @param boolean $debug
*
* @returns string
*
* @since pk-06-02-06
* @version pk-06-04-29
*
***/
function getPopupLinkJs($mode=FRM_MODE_LIST,$selName="",$setMethod="",$debug=FALSE) {
if ($debug) echo "<p><b>DBMS_FIELD_DBLOOKUPPOPUPSELECT::getPopupLinkJs(...)</b> (".get_class($this)."/".$this->myName.")</p>";
if (empty($this->popUp_url)) {
$s_url=$GLOBALS['OCSP']['SYSTEMURL']."forms/popup_form.php?";
} else {
$s_url=pcf_tmpl_parse($this->popUp_url,NULL,$debug);
}
$a_args['FRMID'] =$this->popUp_frmId;
$a_args['FRMMODE'] =$mode;
$a_args['ARRNAME'] =$this->myDataArrName;
$a_args['ARRFLD'] =$this->myName; // the form, data array name
$a_args['SELFLD'] =(empty($selName) ? $this->myName : $selName); // optional name for use in js
$a_args['SETMETHOD']=$setMethod;
$a_args['TBL'] =$this->lookupTable;
$a_args['OPENERFRM']=$this->getFrmId();
$a_args['OFRMNAME'] =$this->getMyFormName();
$a_args['OTBL'] =$this->getTable();
$a_args['OGET'] =$_GET;
//$a_args['OPOST'] =$_POST;
//$a_args['SHOWFIELD']=$this->lookupShowField;
//$a_args['LUWHERE'] =$this->lookupWhere;
//$a_args['KEYFIELD'] =$this->lookupField;
require_once __OCSP_PHPINCPATH__."common/pcf_md5.phpinc";
$s_url=pcf_HTML_changeURI_GetValue($s_url,"ARGS",urlencode(pcfmd5_encrypt(serialize($a_args))));
if ($this->reloadFormOnChange) {
$s_url=pcf_HTML_changeURI_GetValue($s_url,"OPENERRELOAD","1");
} else {
$s_url=pcf_HTML_changeURI_GetValue($s_url,"OPENERRELOAD","");
}
$s_url=pcf_HTML_changeURI_GetValue($s_url,session_name(),session_id());
$s_jCmd="\nvar url_".$this->myName."='';\n";
while(strlen($s_url)>0) {
$s_jCmd.="url_".$this->myName."=url_".$this->myName."+'".substr($s_url,0,32)."';\n";
$s_url=substr($s_url,32);
}
$s_jCmd.="var opt_".$this->myName."='width=".$this->popUp_width.",height=".$this->popUp_height.",toolbar=no,location=no,status=yes,menubar=no,scrollbars=yes,resizable=yes';\n";
$s_jCmd.="hWnd_".$this->myName."=window.open(url_".$this->myName.",'".$this->myName."', opt_".$this->myName.");\n";
$s_jCmd.="hWnd_".$this->myName.".focus();\n";
if ($debug) echo "<blockquote><pre>".htmlspecialchars($s_jCmd)."</pre></blockquote>";
return $s_jCmd;
}
/**
* overwrite the parent method as we use the searchform
*
* @param boolean $debug
*
* @returns string
*
* @since pk-06-04-26
*
***/
function getNewBtn($arrName,$debug=FALSE) {
$debug=($debug || $this->fldDebug);
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBLOOKUPPOPUPSELECT::getNewBtn","",0);
return "";
}
function getPopupBtn($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBLOOKUPPOPUPSELECT::getPopupBtn","",0);
$s_ret ="<!--\n\t\t _______ SEARCH VALUES BUTTON _______ \n";
$s_ret.="\t\t--> <a name=\"".$this->getMyFormName()."_".$this->myName."\" onClick=\"";
$s_ret.=$this->getPopupLinkJs(FRM_MODE_LIST,"","",$debug);
$s_ret.="\n";
$s_ret.="\t\t \"><img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/view_multicolumn.gif\" border=\"0\" alt=\"Suchen/Hinzufügen\" title=\"Suchen/Hinzufügen\" valign=\"middle\" align=\"middle\" class=\"button\">";
$s_ret.="</a><!--\n";
$s_ret.="\t\t _______ SEARCH VALUES BUTTON _______ \n-->";
return $s_ret;
}
/**
* returns the html code for the select
*
* @param string $aValue
* @param array $arrName
* @param boolean $debug
*
* @returns string
*
* @version pk-05-12-01
* @version pk-06-02-06 popUp_frmId
*
***/
function getInputTag($aValue,$arrName="DBVAL",$debug=FALSE) {
$debug=($debug || $this->fldDebug);
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBLOOKUPPOPUPSELECT::getInputTag","aValue=$aValue",0);
global ${$arrName};
$s_ret=parent::getInputTag($aValue,$arrName,$debug);
$s_ret.=$this->getPopupBtn($debug);
return $s_ret;
}
// ###########################################################
// SEARCH FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT VALUE CHECK METHODS
// ###########################################################
} // end class DBMS_FIELD_DBLOOKUPPOPUPSELECT
?>

Source for file DBMS_FIELD_DBLOOKUPPOPUPSELECT.phpclass