File Source for DBMS_FIELD

<?php
/**
* Abstract Class file DBMS_FIELD_SUBFRM_LIST.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category layout
*
* @author Peter Krebs <p.krebs@amicas.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version pk-07-01-16
*
***/
if (!class_exists("DBMS_FIELD")) {
if (!file_exists($GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD.phpclass")) {
if (file_exists(dirname(__FILE__)."/DBMS_FIELD.phpclass")) {
$GLOBALS['OCSP']['DBMSFLD_PATH']=dirname(__FILE__)."/";
}
}
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD.phpclass";
}
/**
* Abstract Class DBMS_FIELD_SUBFRM_LIST
*
* @project Open CSP-Management
* @package dbms_field
* @category layout
*
* @author Peter Krebs <p.krebs@amicas.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version pk-07-01-16
*
***/
class DBMS_FIELD_SUBFRM extends DBMS_FIELD {
// ###########################################################
// OBJECT (CONST) VAR DECLARATION
// ###########################################################
var $className = "Subform";
/**
* source file of the class
*
* @var string $classSrcFile
***/
var $classSrcFile=__FILE__;
/**
* @var string $colType
***/
var $colType="th";
/**
* @var int $subfrmId
***/
var $subfrmId=0;
/**
* @var string $subfrmJoinCond
***/
var $subfrmJoinCond="";
/**
* @var int $subfrmMode
***/
var $subfrmMode=0;
// ###########################################################
// 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>)
* [FLDTIT] (title of the label column)
* </code>
*
* NOTE as this is not implemented in the whole classTree at the moment ensure all parents use
* editTbl_echoForm() in theire editTblForm otherwise you'll get a mismatch of field order
*
* @param boolean $debug
*
* @returns array
*
* @since pk-06-04-26
* @version pk-06-07-17 HIDDEN added to array
* @version pk-06-08-15 FLDTIT added
* @version pk-06-09-12 Tabs & Link showQuery added
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SUBFRM_LIST::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
unset($a_ret['COMMON']['FRM_DEFVAL']);
unset($a_ret['VALCHECKS']);
unset($a_ret['SHOW']['FLD_ALLOW']);
$a_ret['LAYOUT']['FLD_LABTDADD']=array(
'FLDLAB'=>"Labelstyle",
'FLDVAL'=>"
<select name=\"colType\" size=\"1\">
<option value=\"th\">th</option>
<option value=\"td class='fldName'\" ".($this->colType=="td class='fldName'" ? "selected " : "").">td class='fldName'</option>
<option value=\"td\" ".($this->colType=="td" ? "selected " : "").">td</option>
</select>\n"
);
unset($a_ret['LAYOUT']['FLD_TABIDX']);
unset($a_ret['LAYOUT']['FLD_VALTDADD']);
unset($a_ret['LAYOUT']['FLD_SIZE']);
unset($a_ret['LAYOUT']['FLD_INPUTADD']);
unset($a_ret['LAYOUT']['FLD_ADDTAG']);
unset($a_ret['LIST']);
$a_ret['SUBFORM']=array(
'TITLE'=>"Unterformular",
'HIDDENFIELD' =>"",
'ISHIDDEN' =>FALSE,
'FLD_FRMID' =>array('FLDLAB'=>"Unterformular"),
'FLD_FRMJOIN' =>array(
'FLDLAB' =>"Formular Join Template",
'FLDVAL' =>"<textarea name=\"subfrmJoinCond\" rows=\"2\" cols=\"60\">".htmlspecialchars($this->subfrmJoinCond)."</textarea>"
),
'FLD_FRMMODE' =>array(
'FLDLAB' =>"Formular Modus",
'FLDVAL' =>"
<select name=\"subfrmMode\" size=\"1\">
<option value=\"".FRM_MODE_READONLY."\" ".(($this->subfrmMode==FRM_MODE_READONLY) ? "selected" : "").">Nur lesen</option>
<option value=\"".FRM_MODE_LIST."\" ".(($this->subfrmMode==FRM_MODE_LIST) ? "selected" : "").">Liste</option>
</select>
",
),
);
$a_ret['SUBFORM']['FLD_FRMID']['FLDVAL']="<select name=\"subfrmId\" size=\"1\">\n";
$s_query ="SELECT DISTINCT FRM_ID,FRM_NAME,FRM_TABLES FROM T_DBMS_FORM WHERE FRM_ID <> ".intval($this->myFrmId);
$s_query.=" ORDER BY FRM_TABLES,FRM_NAME";
echo "<p>".$s_query."</p>";
if ($o_cursor=$GLOBALS['USRDB']->query($s_query)) {
$s_aktTbl="~INIT~";
while($a_row=$o_cursor->fetchArrayFld()) {
if ($s_aktTbl != $a_row['FRM_TABLES']) {
if ($s_aktTbl!="~INIT~") {
$a_ret['SUBFORM']['FLD_FRMID']['FLDVAL'].="</optgroup>\n";
}
$a_ret['SUBFORM']['FLD_FRMID']['FLDVAL'].="<optgroup label=\"".$a_row['FRM_TABLES']."\">\n";
$s_aktTbl = $a_row['FRM_TABLES'];
}
$a_ret['SUBFORM']['FLD_FRMID']['FLDVAL'].="<option value=\"".$a_row['FRM_ID']."\" ".(($this->myFrmId==$a_row['FRM_ID']) ? "selected": "").">".$a_row['FRM_NAME']."</option>\n";
}
if ($s_aktTbl!="~INIT~") {
$a_ret['SUBFORM']['FLD_FRMID']['FLDVAL'].="</optgroup>\n";
}
}
$a_ret['SUBFORM']['FLD_FRMID']['FLDVAL'].="</select>\n";
return $a_ret;
}
/**
* save the filed definition form
*
* @returns boolean
*
***/
function save() {
if (parent::save()) {
$this->subfrmId =$_POST['subfrmId'];
$this->subfrmJoinCond =$_POST['subfrmJoinCond'];
$this->showInList =FALSE;
$this->subfrmMode =intval($_POST['subfrmMode']);
return TRUE;
}
}
// ###########################################################
// OBJECT DATA METHODS
// ###########################################################
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// SEARCH FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT VALUE CHECK METHODS
// ###########################################################
} // end class DBMS_FIELD_SUBFRM_LIST
?>

Source for file DBMS_FIELD_SUBFRM.phpclass