File Source for CLI_PROFILE_LISTFORM

<?php
/**
* Class file CLI_PROFILE_LISTFORM_PAGE.phpclass
*
* @project Open CSP-Management
* @package client
*
* @author Peter Krebs <p.krebs@wpus.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version $Id: CLI_PROFILE_LISTFORM_PAGE.phpclass,v 1.3 2008/12/12 17:35:14 pitlinz Exp $
*/
require_once __OCSP_DEFAULTCONFPATH__ . "cms.conf.phpinc";
require_once __OCSP_DEFAULTCONFPATH__ . "client.conf.phpinc";
pcf_require_class('CMS_LISTFORM_PAGE',"cms/page/");
pcf_require_class('CLI_PROFILE',"client/");
/**
* class CLI_PROFILE_LISTFORM_PAGE
*
* @project Open CSP-Management
* @package cmclient
*
* @author Peter Krebs <p.krebs@wpus.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-06-10-18
* @version $Id: CLI_PROFILE_LISTFORM_PAGE.phpclass,v 1.3 2008/12/12 17:35:14 pitlinz Exp $
*/
class CLI_PROFILE_LISTFORM_PAGE extends CMS_LISTFORM_PAGE
{
// ---------------------------------------------------------------------------
// constants
// ---------------------------------------------------------------------------
/**
* @constant string CLASS_SRC_FILE
*/
const CLASS_SRC_FILE = __FILE__;
// ---------------------------------------------------------------------------
// class (static)
// ---------------------------------------------------------------------------
/*** class vars ------------------------------------------------------ */
/*** class methods --------------------------------------------------- */
// ---------------------------------------------------------------------------
// object vars
// ---------------------------------------------------------------------------
/*** compostion --------------------------------------------------- */
/*** attributes -------------------------------------------------- */
/**
* the profile id
*
* @var int
*/
protected $MYPROFILEID = 0;
// ---------------------------------------------------------------------------
// factory / construct
// ---------------------------------------------------------------------------
// ---------------------------------------------------------------------------
// getter / setter
// ---------------------------------------------------------------------------
/**
* 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]
*
*
*
* @returns array
*
* @since pk-04-08-10
* @version pk-05-01-14
*
*/
function getObjVarDef() {
$retArr=parent::getObjVarDef();
unset($retArr['MYFORM']);
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']);
unset($retArr['FRMPKCOLS']);
unset($retArr['FRMSELGROUP1']);
unset($retArr['FRMSELGROUP2']);
unset($retArr['FRMTITLEGROUP1']);
unset($retArr['FRMTITLEGROUP2']);
$str_dbmsFldPath = __OCSP_PHPINCPATH__ . "db" . _OCSP_DIRSEP_ . "frmClasses" . _OCSP_DIRSEP_;
if (!class_exists(DBMS_FIELD_FOREIGNKEY))
{
require_once $str_dbmsFldPath . "DBMS_FIELD_FOREIGNKEY.phpclass";
}
$retArr['MYPROFILEID'] = array(
'TYPE' => "int",
'FLDCLASS' => "DBMS_FIELD_FOREIGNKEY",
'CLASSVALS' => array(
'label' => "Profil",
'allowNull' => False,
'showInList' => False,
'toolTip' => "Profil",
'toolTipAsTitle' => True,
'reloadFormOnChange'=> 2,
'lookupTable' => "T_CLI_PROFILES",
'lookupField' => "CLP_ID",
'lookupShowField' => "CONCAT(CLP_TITLE,' (ID: ',CLP_ID,')')",
'lookupWhere' => "(PROJ_ID=".intval($this->getProjId())." OR PROJ_ID=0)",
'lookupSort' => "PROJ_ID DESC,CLP_SORTORDER,CLP_TITLE",
'showNullOption' => False
)
);
$retArr['FRMLSTWHERE']['CLASSVALS']['label']="Profil Filter";
$retArr['FRMLSTWHERE']['CLASSVALS']['toolTip']="Abfrage Filter für das Profil (Kunden/Mitarbeiter/Benutzer)";
$i_pfId=(isset($this->MYPROFILEID) ? intval($this->MYPROFILEID) : 0);
if ((isset($_POST['FRMARRAYNAME'])) && (isset($_POST[$_POST['FRMARRAYNAME']]['MYPROFILEID']))) {
$i_pfId=(intval($_POST[$_POST['FRMARRAYNAME']]['MYPROFILEID']) ? intval($_POST[$_POST['FRMARRAYNAME']]['MYPROFILEID']) : $i_pfId);
}
$retArr['MYFORM']['CLASSVALS']['formTable']="";
if (intval($i_pfId)) {
$s_query="SELECT CLP_TABLE FROM T_CLI_PROFILES WHERE CLP_ID=".intval($i_pfId);
if ($s_pfTbl=OCSP_OBJ::defaultReadDBObj()->quickQuery($s_query,0)) {
$retArr['MYFORM']['CLASSVALS']['formTable']=$s_pfTbl;
}
}
return $retArr;
}
// ---------------------------------------------------------------------------
// profile methods
// ---------------------------------------------------------------------------
/**
* returns the profile
*
* @param boolean $debug
*
* @return CLI_PROFILE
*/
public function &getMyProfile($debug)
{
return CLI_PROFILE::getInstance($this->MYPROFILEID);
}
/**
* loads the form object
*
* @param booelean $debug
*
* @global array $OCSP_CONF
*
* @return OCSP_FORM
*
* @version pk-07-01-11
* @version pk-08-10-02
*
*/
function loadFrmObj($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"CLI_PROFILE_LISTFORM::loadFrmObj");
if ($obj_profile = $this->getMyProfile($debug))
{
return ($this->pageFrmObj = $obj_profile->getEntryForm());
} else {
return False;
}
}
/**
* returns an array with key fields (only the colname) not the object
*
* @param boolean $debug
*
* @returns array
*
***/
function getFormKeyColNames($debug=FALSE){
if ($debug) echoDebugMethod(__FILE__,get_class($this),"CLI_PROFILE_LISTFORM_PAGE::getFormKeyColNames");
return array('CLP_IDX');
}
/* _______________________ 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__,"CMS_LISTFORM_PAGE::getFormCode() (".get_class($this).")",0);
if (!$this->pageFrmObj) $this->loadFrmObj(); // load the form
if (is_object($this->pageFrmObj) && (intval($this->pageFrmObj->getId()))) {
// we have a valid form
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 "FORMULAR konnte nicht nicht geladen werden";
}
}
/**
* 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
*
***/
function getSingleRowFormCode($mode=FRM_MODE_READONLY,$debug=FALSE) {
if ($debug) echoDebug(__FILE__,"CMS_LISTFORM_PAGE::getEditCode() (".get_class($this).")",0);
if (!$this->pageFrmObj) $this->loadFrmObj(); // load the forms
$a_pkFlds=$this->getFormKeyColNames();
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)) {
// no key set -> no where -> no sense to edit
$s_ret ="Formular konnte nicht bearbeitet werden, da es keine Key �bergeben wurde.";
$s_ret.=$this->getFormListCode($debug);
}
$s_query="SELECT * ".$this->pageFrmObj->getFromStmt().$s_where;
$s_dataArrName="DBVAL_".$this->pageFrmObj->getId();
global ${$s_dataArrName};
if (!($a_dataRow=$GLOBALS['USRDB']->quickQuery($s_query))) {
$s_ret ="Formular konnte nicht bearbeitet werden, da es keine Datensatz gefunden wurde.";
$s_ret.=$this->getFormListCode($debug);
}
$s_nxtUrl=pcf_HTML_changeURI_GetValue($_SERVER['REQUEST_URI'],'FRMCMD_'.$this->pageFrmObj->getId(),"");
$s_nxtUrl=pcf_HTML_changeURI_GetValue($s_nxtUrl,'rldFRM',"");
${$s_dataArrName}=$this->pageFrmObj->reloadCheck($a_dataRow,$debug,$s_dataArrName);
return $this->pageFrmObj->getHTMLFormFromArray(${$s_dataArrName},$mode,NULL,$s_nxtUrl,$s_dataArrName,$debug);
} else {
$s_ret ="Formular konnte nicht bearbeitet werden, da es keine Autowert Felder hat.";
$s_ret.=$this->getFormListCode($debug);
}
}
/**
* 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
*
* @version pk-08-12-12
*/
function getFormListCode($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"CLI_PROFILE_LISTFORM_PAGE::getFormListCode()");
if ($obj_profile = $this->getMyProfile($debug))
{
if ($obj_profile->isMultiple())
{
$obj_form = $obj_profile->getEntryForm(FRM_MODE_LIST);
} else {
return Null;
}
}
}
}
?>

Source for file CLI_PROFILE_LISTFORM_PAGE.phpclass