File Source for CMS_LISTFORM

<?php
/**
* Class file CMS_LISTFORM_PAGE.phpclass
*
* @project Open CSP-Management
* @package cms
*
* @author Peter Krebs <p.krebs@wpus.at>
* @copyright (c) 2002-2005 by Peter Krebs and WURM und Partner Unternehmensservice GesmbH.
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
pcf_require_class('CMS_FORM_PAGE',dirname(__FILE__)."/");
/**
* class CMS_LISTFORM_PAGE
*
* @project Open CSP-Management
* @package cms
* @category page
*
* @author Peter Krebs <p.krebs@wpus.at>
* @copyright (c) 2002-2005 by Peter Krebs and WURM und Partner Unternehmensservice GesmbH.
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-05-05-30
* @version pk-06-01-24
*
***/
class CMS_LISTFORM_PAGE extends CMS_FORM_PAGE
{
// ---------------------------------------------------------------------------
// constants
// ---------------------------------------------------------------------------
/**
* @constant string CLASS_SRC_FILE
*
* @abstract
*/
const CLASS_SRC_FILE = __FILE__;
// ---------------------------------------------------------------------------
// class (static)
// ---------------------------------------------------------------------------
/*** class vars ------------------------------------------------------ */
/*** class methods --------------------------------------------------- */
// ---------------------------------------------------------------------------
// object vars
// ---------------------------------------------------------------------------
/**
* @var string $myClassName name of the class
***/
var $myClassName = "CMS_LISTFORM_PAGE";
/**
* returns a array of variables used by the page object
*
* array[varName]=array(
* [TYPE] datatype
* [FLDCLASS] name of DBMS_FIELD* class
* [CLASSVALS] array of values of [FLDCLASS]
*
* @global array $OCSP_CONF
*
* @returns array
*
* @since pk-04-08-10
* @version pk-05-01-14
*
*/
function getObjVarDef() {
$retArr=parent::getObjVarDef();
global $OCSP_CONF;
if (!isset($OCSP_CONF['DBMSFLD_PATH'])) $OCSP_CONF['DBMSFLD_PATH']=__OCSP_PHPINCPATH__."db"._OCSP_DIRSEP_."frmClasses"._OCSP_DIRSEP_;
unset($retArr['FRMMODE']);
$this->FRMMODE=FRM_MODE_LIST;
unset($retArr['FRMACTION']);
unset($retArr['FRMTAGADD']);
unset($retArr['FRMCANCELCMD']);
unset($retArr['FRMNEXTPAGE']);
unset($retArr['MYFORMOBJHAEDLINE']);
unset($retArr['FRMOBJECTINC']);
unset($retArr['FRMOBJECTCLASS']);
require_once $OCSP_CONF['DBMSFLD_PATH']."DBMS_FIELD_DBMS_FORMWHERE.phpclass";
$retArr['FRMLSTWHERE'] = array(
"TYPE" => "text",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMWHERE",
"CLASSVALS" => array(
"label" => "WHERE ",
"allowNull" => TRUE,
"showInList" => FALSE,
"toolTip" => t_admin("Abfrage Filter für das Formular"),
"rows" => 3,
"cols" => 64,
"myFormIdCol" => "MYFORM"
)
);
require_once $OCSP_CONF['DBMSFLD_PATH']."DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass";
$retArr['FRMPKCOLS'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => t_admin("ID Feld"),
"allowNull" => TRUE,
"showInList" => FALSE,
"toolTip" => t_admin("Für Edit,Delete,Copy"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
$retArr['FRMSELGROUP1'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => "1. " . t_admin("Gruppen Selectfeld"),
"allowNull" => TRUE,
"showInList" => TRUE,
"toolTip" => t_admin("Wird als Select Auswahl angezeigt"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
$retArr['FRMSELGROUP2'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => "2. " . t_admin("Gruppen Selectfeld"),
"allowNull" => TRUE,
"showInList" => TRUE,
"toolTip" => t_admin("Wird als Select Auswahl angezeigt"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
require_once $OCSP_CONF['DBMSFLD_PATH'] . "DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass";
$retArr['FRMTITLEGROUP1'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => t_admin("Üerschrift Gruppenfeld")." 1",
"allowNull" => TRUE,
"showInList" => TRUE,
"toolTip" => t_admin("Wird als Üerschrift angegeben"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
$retArr['FRMTITLEGROUP2'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => t_admin("Üerschrift Gruppenfeld") . " 2",
"allowNull" => TRUE,
"showInList" => TRUE,
"toolTip" => t_admin("Wird als Üerschrift angegeben"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
$retArr['FRMSORTFLD1'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => t_admin("Sortierungsfeld") ." 1",
"allowNull" => TRUE,
"showInList" => TRUE,
"toolTip" => t_admin("Nach diesem Feld wird Sortiert"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
$retArr['FRMSORTFLD2'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD_DBMS_FORMFIELDSELECT",
"CLASSVALS" => array(
"label" => t_admin("Sortierungsfeld") . " 2",
"allowNull" => TRUE,
"showInList" => TRUE,
"toolTip" => t_admin("Nach diesem Feld wird Sortiert"),
"toolTipAsTitle" => TRUE,
"myFormIdCol" => "MYFORM",
"editUrl" => '$@OCSP|ADMINURL$dbms/fieldEdit.php?FRM_ID=$*MYFORM$&FIELD=##VALUE##'
)
);
return $retArr;
}
/* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */
/* */
/* _______________________ HEADER ________________________________ */
/* */
/* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */
/**
* returns the java tag
*
* @returns string
*
* @since pk-04-08-02
*
***/
function getJavaHeaderTag($debug=FALSE) {
if ($debug) echo "<p><b>CMS_FORM_PAGE::getJavaHeaderTag(...)</b> (".get_class($this).")</p><blockquote>";
if (!$this->pageFrmObj) $this->loadFrmObj($debug);
$tag=parent::getJavaHeaderTag($debug);
if (!strstr($tag,$GLOBALS['PROJECT']['JAVASCRIPTURL']."window.js")) {
$tag .="\t<script language=\"JavaScript\" src=\"".$GLOBALS['PROJECT']['JAVASCRIPTURL']."window.js\" type=\"text/javascript\"></script>\n";
}
if (!strstr($tag,$GLOBALS['PROJECT']['JAVASCRIPTURL']."forms.js")) {
$tag .="\t<script language=\"JavaScript\" src=\"".$GLOBALS['PROJECT']['JAVASCRIPTURL']."forms.js\" type=\"text/javascript\"></script>\n";
}
if (pcf_is_instance_of($this->pageFrmObj,'DBMS_FORM')) { // <pk-06-12-10>
$tag.=$this->pageFrmObj->getJavaCode($this->FRMMODE,FALSE,$debug);
}
if ($debug) echo "</blockquote>";
return $tag;
}
// ---------------------------------------------------------------------------
// formular methods
// ---------------------------------------------------------------------------
/**
* returns an array with key fields (only the colname) not the object
*
* @param boolean $debug
*
* @returns array
*
* @since pk-06-01-25
*
***/
function getFormKeyColNames($debug=FALSE){
if ($debug) echoDebugMethod(__FILE__,get_class($this),"CMS_LISTFORM_PAGE::getFormKeyColNames()");
$a_pkFlds=array();
if (empty($this->FRMPKCOLS)) {
$a_pkFlds=$this->pageFrmObj->getAutoIncFields($debug); // get the auto_increment cols form the form
} else {
$a_tmp=explode("\n",$this->FRMPKCOLS);
foreach($a_tmp as $s_colName) {
if (strstr($s_colName,".")) {
$a_pkFlds[]=substr($s_colName,strpos($s_colName,".")+1);
} else {
$a_pkFlds[]=$s_colName;
}
}
}
return $a_pkFlds;
}
/* _______________________ BODY _______________________________ */
/**
* do formcmds and return the propriate html-code
*
* @param boolean $debug
*
* @returns string
*
* @since pk-06-01-24
* @version pk-06-09-26
*
***/
function getFormCode($debug) {
if ($debug) echoDebug(__FILE__,"<p><b>CMS_LISTFORM_PAGE::getFormCode()</b> (".get_class($this).")</p>",0);
if (!$this->pageFrmObj) $this->loadFrmObj($debug); // load the form
if (is_object($this->pageFrmObj) && (intval($this->pageFrmObj->getId()))) {
// we have a valid form
$s_cmd=(isset($_GET['FRMCMD_'.$this->pageFrmObj->getId()]) ? $_GET['FRMCMD_'.$this->pageFrmObj->getId()] : "");
if ($debug) echoDebug(__FILE__,"<p>CMD: $s_cmd</p>");
switch($_GET['FRMCMD_'.$this->pageFrmObj->getId()]) {
case "NEW": // <pk-06-09-26 />
return $this->getSingleRowFormCode(FRM_MODE_NEW,$debug);
case "EDIT":
return $this->getSingleRowFormCode(FRM_MODE_EDIT,$debug);
case "DELETE":
return $this->getSingleRowFormCode(FRM_MODE_DELETE,$debug);
case "COPY":
return $this->getSingleRowFormCode(FRM_MODE_COPY,$debug);
default:
return $this->getFormListCode($debug);
}
} else {
// we do not have a form
return "<p>FORMULAR konnte nicht nicht geladen werden</p>";
}
}
/**
* returns the html-code for the form in edit mode
* if no autoinc field is in $_GET the list is returned
*
* @param boolean $debug
*
* @returns string
*
* @version pk-07-01-15
*
***/
function getSingleRowFormCode($mode=FRM_MODE_READONLY,$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class(),"CMS_LISTFORM_PAGE::getSingleRowFormCode()","mode: $mode");
if (!$this->pageFrmObj) $this->loadFrmObj($debug); // load the forms
$a_pkFlds=$this->getFormKeyColNames($debug);
if (sizeof($a_pkFlds)) {
// assamble the where clause
$s_where=" WHERE ";$s_and="";
foreach($a_pkFlds as $s_colName) {
if (intval($_GET[$s_colName])) {
$s_where.=$s_and.$s_colName."=".intval($_GET[$s_colName]);
$s_and=" AND ";
}
}
if (empty($s_and) && ($mode != FRM_MODE_NEW)) {
// no key set -> no where -> no sense to edit
return "<p>Formular konnte nicht bearbeitet werden, da es keine Key bergeben wurde.</p>";
}
if ($mode == FRM_MODE_NEW) { // <pk-07-01-15>
$a_dataRow=array();
} else {
$s_query="SELECT * ".$this->pageFrmObj->getFromStmt().$s_where;
if (!($a_dataRow=$GLOBALS['USRDB']->quickQuery($s_query))) {
return "<p>Formular konnte nicht bearbeitet werden, da es keine Datensatz gefunden wurde.</p>";
}
}
$s_nxtUrl=pcf_HTML_changeURI_GetValue($_SERVER['REQUEST_URI'],'FRMCMD_'.$this->pageFrmObj->getId(),"");
$s_dataArrName="DBVAL_".$this->pageFrmObj->getId();
global ${$s_dataArrName};
${$s_dataArrName}=$this->pageFrmObj->reloadCheck($a_dataRow,$debug,$s_dataArrName);
return $this->pageFrmObj->getHTMLFormFromArray(${$s_dataArrName},$mode,NULL,$s_nxtUrl,$s_dataArrName,$debug);
} else {
return "<p>Formular konnte nicht bearbeitet werden, da es keine Autowert Felder hat.</p>";
//$s_ret.=$this->getFormListCode($debug);
}
}
function getListDOMId()
{
return md5($this->getMyLink() . $this->FRMLSTWHERE . $this->MYFORM);
}
/**
* returns the html-code for the form in list mode
*
* @param boolean $debug
*
* @returns string
*
* @version pk-04-12-21
* @version pk-05-10-07
*
* @var string $s_ret
* @var array $a_tmp
* @var string $s_query
* @var string $s_fldName
* @var array $a_whereValues
* @var string $s_selGrpWhere
*
***/
function getFormListCode($debug=FALSE)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"CMS_LISTFORM_PAGE::getListCode()");
$str_ret = "\n\n\n\n";
if ($this->loadFrmObj())
{
if (!empty($this->FRMLSTWHERE))
{
pcf_require_class('OCSP_TEMPLATE',"common/");
$arr_filter = array('?PAGEWHERE' => OCSP_TEMPLATE::parse($this->FRMLSTWHERE,$this->getDBVal(False)));
} else {
$arr_filter = array();
}
$arr_lstGroups = array();
if (isset($this->FRMTITLEGROUP1) && !empty($this->FRMTITLEGROUP1)) {
$arr_lstGroups[]=$this->FRMTITLEGROUP1;
}
if (isset($this->FRMTITLEGROUP2) && !empty($this->FRMTITLEGROUP2)) {
$arr_lstGroups[]=$this->FRMTITLEGROUP2;
}
$arr_orderCols=array();
if (isset($this->FRMSORTFLD1) && !empty($this->FRMSORTFLD1)) {
$arr_orderCols[]=$this->FRMSORTFLD1;
}
if (isset($this->FRMSORTFLD2) && !empty($this->FRMSORTFLD2)) {
$arr_orderCols[]=$this->FRMSORTFLD2;
}
if (sizeof($arr_orderCols))
{
$str_orderBy = implode(',',$arr_orderCols);
} else {
$str_orderBy = "";
}
$arr_lstCmds = array();
if (pcf_is_instance_of($this->myHTMLPage,'OCSP_HTMLPAGE') && ($arr_keys = $this->pageFrmObj->getPKFields()))
{
ob_start();
$this->myHTMLPage->addJsSrcLink(OCSP_OBJ::getConf('JAVASCRIPTURL')."jquery/jquery.js");
$this->myHTMLPage->addJsSrcLink(OCSP_OBJ::getConf('JAVASCRIPTURL')."jquery/jquery.form.js");
$this->myHTMLPage->addJsSrcLink(OCSP_OBJ::getConf('jOCSPURL')."jOCSP.js");
$this->myHTMLPage->addJsSrcLink(OCSP_OBJ::getConf('jOCSPURL')."jOCSP_listFormPage.js");
$this->myHTMLPage->addBodyOnLoad("jOCSP.addListFormPage(" . $this->getId() . "," . $this->pageFrmObj->getId() . ",'" . $this->getListDOMId() . "','" . base64_encode($_SERVER['REQUEST_URI']) . "');");
$this->myHTMLPage->addBodyOnLoad("jOCSP.ocspSystemUrl='" . OCSP_CONF::getInstance()->getValue('SYSTEMURL') . "';");
if (OCSP_OBJ::currentUser(True)->isPublic())
{
$arr_sec = array('PUBLIC'=>True);
} else {
$arr_sec=array(
'PUBLIC' => False,
'USER' => OCSP_OBJ::currentUser()->getId()
);
}
$this->myHTMLPage->addBodyOnLoad("jOCSP.setSecReq('".OCSP_SESSION::getInstance()->encrypt(serialize($arr_sec))."');");
$str_cmdTmpl = "if (obj_lp=jOCSP.getListFormPageById('" . $this->getListDOMId() ."')) {";
$str_cmdTmpl .= "obj_ids={";
foreach($arr_keys as $obj_fld)
{
$str_cmdTmpl .= $obj_fld->getName() . ":'\$*" .$obj_fld->getName() ."\$',";
}
$str_cmdTmpl .= " };";
$str_cmdTmpl .= " obj_lp.doCmd(obj_ids,'DOCMD_CMD');";
$str_cmdTmpl .="}";
if ($this->pageFrmObj->curUserCanEdit($debug))
{
$arr_lstCmds['EDIT'] = array(
'C' => "onclick=\"" . str_replace("DOCMD_CMD",FRM_MODE_EDIT,$str_cmdTmpl) . "\"",
'I' => "<img src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-16x16/edit.gif\" class=\"button\" alt=\"" . t_admin("Bearbeiten") . "\" />"
);
} else if ($this->pageFrmObj->curUserCanShow($debug)) {
$arr_lstCmds['ZOOM'] = array(
'C' => "onclick=\"" . str_replace("DOCMD_CMD",FRM_MODE_READONLY,$str_cmdTmpl) . "\"",
'I' => "<img src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-16x16/viewmag.gif\" class=\"button\" alt=\"" . t_admin("Anzeigen") . "\" />"
);
}
if ($this->pageFrmObj->curUserCanDelete($debug))
{
$arr_lstCmds['ZOOM'] = array(
'C' => "onclick=\"" . str_replace("DOCMD_CMD",FRM_MODE_DELETEY,$str_cmdTmpl) . "\"",
'I' => "<img src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-16x16/edittrash.gif\" class=\"button\" alt=\"" . t_admin("Löschen") . "\" />"
);
}
if ($debug) $str_ret .= "<hr />" . ob_get_contents() . "<hr />";
ob_end_clean();
}
$str_domId = $this->getListDOMId();
$str_ret.= "<div id=\"list_" . $str_domId . "\">";
$this->pageFrmObj->prepareList(array(
'FILTER' => $arr_filter,
'ORDERBY' => $str_orderBy,
'LSTGROUPS' => $arr_lstGroups,
'CONTRBUTTONS' => $arr_lstCmds,
));
$str_ret .= $this->pageFrmObj->getView()->getList();
} else {
$str_ret .= "could not load form";
}
if ($this->pageFrmObj->curUserCanInsert())
{
$str_ret .= "
<div class=\"lstFrmPapgeButtons\">
<a onclick=\"" . str_replace("DOCMD_CMD",FRM_MODE_NEW,$str_cmdTmpl) ."\"
title=\"" . t_admin('Neuer Datensatz') . "\">
<img
src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-16x16/filenew.gif\"
alt=\"" . t_admin('Neuer Datensatz') . "\"
class=\"button\"
/>
</a>
</div>
";
}
$str_ret .= "</div>";
$str_ret .= "\n\n\n\n";
return $str_ret;
}
/**
* returns the content of the page
*
* @param int $chaShowMode
* @param boolean $debug
*
* @global $OCSP_CONF
*
* @return string (html)
*
* @since pk-08-01-08
* @version pk-08-04-22
* @version pk-08-10-02
*
*/
function getContent($chaShowMode=0,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"CMS_LISTFORM_PAGE::getContent({$chaShowMode})");
switch($chaShowMode)
{
case CHAPTER_SHOWMODE_PAGEALL:
$str_ret = $this->getContent(CHAPTER_SHOWMODE_ALLWAYS_TOP,$debug);
$str_ret.= $this->getContent(CHAPTER_SHOWMODE_PROGRAMM,$debug);
$str_ret.= $this->getContent(CHAPTER_SHOWMODE_ALLWAYS_BOTTOM,$debug);
return $str_ret;
case CHAPTER_SHOWMODE_PROGRAMM:
ob_start();
$str_ret = $this->getFormListCode($debug);
$str_ret.= ob_get_contents();
ob_end_clean();
$this->getContentCalled = True;
return $str_ret;
default:
return parent::getContent($chaShowMode,$debug);
}
}
}
?>

Source for file CMS_LISTFORM_PAGE.phpclass