File Source for OCSP_FRMCONTR

<?php
/**
* Class file OCSP_FRMCONTR_LIST.phpclass
*
* @project Open CSP-Management
* @package forms
* @category dbms_form
*
* @author Peter Krebs (pk) <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-07-07-02
*
* @version $Id: OCSP_FRMCONTR_LIST.phpclass,v 1.23 2008/11/30 13:35:29 pitlinz Exp $
*
*/
// -----------------------------------------------------
// requirements
// -----------------------------------------------------
pcf_require_class('OCSP_FRMCONTR',"db/forms/");
pcf_require_class('OCSP_TEMPLATE',"common/");
/**
* class OCSP_FRMCONTR_LIST
*
* @project Open CSP-Management
* @package forms
* @category dbms_form
*
* @author Peter Krebs (pk) <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-07-07-02
*
*/
class OCSP_FRMCONTR_LIST extends OCSP_FRMCONTR
{
/*** Aggregations: */
/*** Compositions: */
/*** Attributes: */
/**
* @var array $lstTables
* array(
* 'TABLE'=string
* 'COLS'=>array()
* 'KEYS'=array()
*))
* @access protected
*/
protected $lstTables=array();
/**
* @var array $lstObjValCols
* @access protected
*/
protected $lstObjValCols=array();
/**
* @var string $lstQuery (without limit,offset and order)
* @access protected
*/
protected $lstQuery="";
/**
* @var array $myListValues
* @access protected
*/
protected $myListValues=array();
/**
* @var double $listLoadTS
* @access protected
*/
protected $listLoadTS=0;
/**
* @var double $lstObjValTS
* @access protected
*/
protected $lstObjValTS=0;
/**
* @var int $myListIdx
* @access protected
*/
protected $myListIdx=0;
/**
* @var int $lst_limit
* @access protected
*/
protected $lst_limit=0;
/**
* @var int $lst_offset
* @access protected
*/
protected $lst_offset=0;
/**
* url for (auto)pageing
*
* @var string
*/
protected $lst_pageingUrl = "";
/**
* @var array $lst_groupValues
* @access protected
*/
protected $lst_groupValues;
/**
* @var string $lst_orderBy
* @access protected
*/
protected $lst_orderBy="";
// commands & events
/**
* @var string $tbl_sortLink
* @access protected
*/
protected $tbl_sortLink="";
/**
* an array with a java event as key and a js-function template
*
* @example
* $myRowCmds['onClick']="alert('\$*COLNAME$')";
* will output <tr onClick="alert('VALUE OF $this->curRow[$COLNAME]')" >
*
* NOTE: avoid " in PARAM as the generated code is enclosed by "
*
* @var array $myRowCmds
* @access protected
*/
protected $myRowCmds=array();
/** array of command templates for each row
* $tbl_rowBtnCmds[CMDNAME]=CMDTMPLATE
*
* it will generate a button - column as follows:
*
* <td&gt&lta pcf_tmpl_parse(CMDTMPLATE,$this->curRow) > $this->myView->getButtonImgTag(CMDNMAE) <a>
*
*
* @var array $tbl_rowBtnCmds
* @access protected
*/
protected $tbl_rowBtnCmds=array();
/**
* @var array $tbl_footerCmds
* @access protected
*/
protected $tbl_footerCmds=array();
/**
* @var string $myListKey
*/
protected $myListKey = "";
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// init methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// getter/setter methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* @param string $aKey
*/
public function setListKey($aKey)
{
$this->myListKey = $aKey;
}
/**
* @return string
*/
public function getListKey()
{
return $this->myListKey;
}
/**
* @param boolean $debug
* @return int
*/
function getOffset($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getOffset()");
return $this->lst_offset;
}
/**
* @param int $offset
*/
function setOffset($offset)
{
$this->lst_offset=$offset;
}
/**
* @return int
*/
function getLimit()
{
return $this->lst_limit;
}
/**
* @param int $limit
*/
function setLimit($limit)
{
$this->lst_limit=intval($limit);
}
/**
* returns the unfiltered list sql statement
*
* if $this->lstQuery is empty the query is generated out of the form
*
* @param boolean $debug
*
* @return string
*
* @since pk-08-01-19
*
*/
function getListQuery($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getListQuery()");
if (!empty($this->lstQuery))
{
if ($debug) echoDebugLine(__FILE__,__LINE__,"returning already set: " . $this->lstQuery);
return $this->lstQuery;
// <<<< return <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"the form has: ".sizeof($this->lstTables)." tables");
if (sizeof($this->lstTables)==1)
{
$arr_keys=array_keys($this->lstTables);
$this->lstQuery="SELECT * FROM ".$arr_keys[0];
return $this->lstQuery;
// <<<< return <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
} else if ($obj_tblObj=$this->myForm->getMyTblObj()) {
$str_query ="SELECT * FROM ".$obj_tblObj->getMyTable();
$arr_joinCols=$this->myForm->getJoinCols();
if ($debug) echoDebugLine(__FILE__,__LINE__,"<p>JoinCols: </p><pre>".print_r($arr_joinCols,TRUE)."</pre>");
foreach($this->lstTables as $str_tbl => $arr_tblDef)
{
if ($str_tbl != $obj_tblObj->getMyTable())
{
foreach($arr_joinCols as $str_col => $arr_tableJoinCols)
{
echoDebugLine(__FILE__,__LINE__,"<p>\$arr_joinColsstrong: $str_col</strong><pre>".print_r($arr_tableJoinCols,TRUE)."</pre>");
}
echoDebugLine(__FILE__,__LINE__,"<p><strong>$str_tbl</strong><pre>".print_r($arr_tblDef,TRUE)."</pre>");
}
}
echo $str_query;
ocsp_logError(__FILE__,__LINE__,"@TODO the form (".get_class($this->myForm)." ID ".$this->myForm->getId().") has: ".sizeof($this->lstTables)." tables");
} else {
$arr_keys=array();
foreach($this->lstTables as $str_tbl => $arr_tblDef)
{
if ($this->myDBObj->tblExists($str_tbl))
{
$arr_keys[$str_tbl]=$this->myDBObj->getPrimaryKeys($str_tbl);
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"<p><strong>$str_tbl</strong><pre>".print_r($arr_tblDef,TRUE)."</pre>");
}
$str_query ="SELECT * FROM ".$this->myForm->getMastertable();
unset($arr_keys[$this->myForm->getMastertable()]);
// try to bild join
$int_maxLoops=sizeof($arr_keys)*sizeof($arr_keys);
$arr_cols=$this->myDBObj->getDBTblDesc($this->myForm->getMastertable());
if ($debug) echoDebugLine(__FILE__,__LINE__,"<pre>".print_r($arr_keys,TRUE)."\ncols:\n".print_r($arr_cols,TRUE)."</pre>");
while(sizeof($arr_keys) && is_array($arr_keys) && intval($int_maxLoops))
{
foreach($arr_keys as $str_tbl => $arr_keys)
{
if (is_array($arr_keys))
{
$b_tblAdded=False;
reset($arr_keys);
while(!$b_tblAdded && (list(,$str_key) = each($arr_keys)))
{
if (isset($arr_cols[$str_key]))
{
$str_query.=" JOIN $str_tbl USING($str_key)";
unset($arr_keys[$str_tbl]);
$b_tblAdded=True;
}
}
}
}
$int_maxLoops--;
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"ListQuery: $str_query");
$this->lstQuery=$str_query;
return $this->lstQuery;
// <<<< return <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
}
return NULL;
}
/**
* returns the where condition for the filter
*
* you have to prepend "WHERE" OR "AND" to the returned string
*
* @param boolean $debug
* @return string
*
* @since pk-08-06-26
* @version pk-08-10-01 if filter value is an array -> make or statement
*
*/
public function getFilterWhere($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getFilterWhere()");
$this->getDBObj();
$str_conditions = "";
$str_whereAnd="";
foreach($this->myFilter as $str_col => $m_val)
{
if (substr($str_col,0,1)=="?")
{
$str_conditions .= $str_whereAnd . $m_val;
} else if (substr($str_col,0,1) == "~") {
$str_conditions .= $str_whereAnd . substr($str_col,1) . " " . $this->myDBObj->qs_getLikeStmt($m_val,False,False,$debug);
} else if (is_array($m_val)) { // <pk-08-10-01>
$str_orSep = "";
$str_orCondition = "";
foreach($m_val as $m_orVal)
{
$str_orCondition .= $str_orSep . $str_col . "=" . $this->myDBObj->qs_getSlashedValue($m_orVal);
$str_orSep = " OR ";
}
if (!empty($str_orCondition))
{
$str_conditions .= $str_whereAnd . "(" . $str_orCondition . ")";
} else {
$str_conditions .= $str_whereAnd . "1=1"; // to avoid errors for empty conditions
}
} else {
$str_conditions .= $str_whereAnd . $str_col . "=" . $this->myDBObj->qs_getSlashedValue($m_val);
}
$str_whereAnd=" AND ";
}
return $str_conditions;
}
/**
* sets a query for the list elements
* @param string
*/
function setListQuery($aSqlStatement)
{
$this->lstQuery=$aSqlStatement;
}
/**
* @param boolean $debug
* @return string
*/
function getOrderBy($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getOrderBy()");
return $this->lst_orderBy;
}
/**
* @param string $orderStr
*/
function setOrderBy($orderStr)
{
$this->lst_orderBy=$orderStr;
}
// row buttons (right)
/**
* @return int (the size of $this->tbl_rowBtnCmds)
* @access public
*/
function getNofBtnCols()
{
return sizeof($this->tbl_rowBtnCmds);
}
/**
* adds a button command to the end of a row
*
* @param string $aCmd
* @param string $aTmpl
*/
function addCmdButton($aCmd,$aTmpl)
{
$this->tbl_rowBtnCmds[$aCmd]=$aTmpl;
}
/**
* returns the row command button array
*
* @param int $pos // -1: left; 1: right (default); 0: both
* @return array
*
* @since pk-08-06-02
*/
function getCmdButtons($pos=0)
{
if (!intval($pos))
{
return $this->tbl_rowBtnCmds;
} else if (intval($pos) < 0) {
$arr_ret = array();
foreach($this->tbl_rowBtnCmds as $arr_btn)
{
if (isset($arr_btn['POS']) && (intval($arr_btn['POS']) < 0))
{
$arr_ret[] = $arr_btn;
}
}
return $arr_ret;
} else {
$arr_ret = array();
foreach($this->tbl_rowBtnCmds as $arr_btn)
{
if (!isset($arr_btn['POS']) || (intval($arr_btn['POS']) > -1))
{
$arr_ret[] = $arr_btn;
}
}
return $arr_ret;
}
}
/**
* tr code is generated as follows
* <code>
* echo "<tr $event=\"".pcf_escape_doubleQuote(pcf_tmpl_parse($jsCmd)."\">";
* </code>
*
* note sending $event twice overwrites the older setting
*
* @param string $event
* @param string $jsCmd
*/
function setRowCmd($event,$jsCmd)
{
$this->myRowCmds[$event]=$jsCmd;
}
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// list db methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* @return boolean if the list values have been loaded
*/
public function valuesAreLoaded()
{
return ($this->listLoadTS > time()-ini_get('max_execution_time'));
}
/**
* sets the loaded values as invalide
*
* @since pk-08-11-26
*/
public function invalidateValues()
{
$this->listLoadTS = 0;
}
/**
* @return mixed (False if the list rows have not been loaded else the size of $this->myListValues)
*/
function getNofListRows()
{
if ($this->valuesAreLoaded())
{
return sizeof($this->myListValues);
} else {
return False;
}
}
/**
* @param boolean $debug
*/
function initList($debug=False)
{
if (!pcf_is_instance_of($this->myView,'OCSP_FRMVIEW'))
{
$this->myView=$this->myForm->getListView(NULL,$debug);
}
$this->listLoadTS=0;
$arr_flds=$this->myView->getFields($debug);
foreach($arr_flds as &$objField)
{
$objField->setControll($this);
$arr_fldDesc=$objField->getdbDesc();
$str_tbl=$objField->getTable();
if (!empty($str_tbl))
{
if (substr($str_tbl,0,8)=="OBJVALS_")
{
$this->lstObjValCols[$str_tbl][]=$objField->getName();
} else {
if (!isset($this->lstTables[$objField->getTable()]))
{
$this->lstTables[$objField->getTable()]=array('TABLE'=>$objField->getTable());
}
if (isset($arr_fldDesc['COLNAME']))
{
$this->lstTables[$objField->getTable()]['COLS'][]=$arr_fldDesc['COLNAME'];
if (isset($arr_fldDesc['PRIMARY_KEY']) && ($arr_fldDesc['PRIMARY_KEY']))
{
$this->lstTables[$objField->getTable()]['PK'][]=$arr_fldDesc['COLNAME'];
}
}
}
}
}
if ($arr_groups=$this->myForm->get_listGroups())
{
foreach(array_keys($arr_groups) as $str_col)
{
$this->lst_groupValues[$str_col]=NULL;
}
}
}
/**
* @param string $tbl
* @param array $fieldNames
* @param boolean $debug
*
* @todo OCSP_FRMCONTR_LIST::loadListObjectValues() replace inline SQL
*
* @return boolean
*/
function loadListObjectValues($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::loadListObjectValues()");
if (sizeof($this->myListValues) < 1)
{
return False;
}
if (sizeof($this->lstObjValCols))
{
foreach($this->lstObjValCols as $str_tbl => $arr_cols)
{
$str_dbTbl=substr($str_tbl,8);
if (!isset($this->lstTables[$str_dbTbl]['PK']))
{
$this->lstObjValCols[$str_tbl]['LOADED']=False;
continue;
}
if (sizeof($arr_cols) < 1)
{
$this->lstObjValCols[$str_tbl]['LOADED']=False;
continue;
}
$arr_pkCol=$this->lstTables[$str_dbTbl]['PK'];
if (sizeof($arr_pkCol) < 1)
{
$this->lstObjValCols[$str_tbl]['LOADED']=False;
continue;
}
$b_singleKey=(sizeof($arr_pkCol) == 1);
if (!$b_singleKey)
{
ocsp_logError(__FILE__,__LINE__,$str_dbTbl." has more then 1 private key columns code not implemented");
$this->lstObjValCols[$str_tbl]['LOADED']=False;
continue;
}
$str_query="SELECT CONCAT(".$str_dbTbl."_OV.OV_NAME,'|',".$str_dbTbl.".".$arr_pkCol[0].") AS OV_IDX";
$char_sep=',';
$str_query.=$char_sep.$str_dbTbl."_OV.".$arr_pkCol[0];
$str_query.=$char_sep."OV_NAME,OV_VALUE FROM ".$str_dbTbl."_OV,".$str_dbTbl;
if ($debug) echoDebugLine(__FILE__,__LINE__,"OV fields: <pre>".print_r($arr_cols,TRUE)."</pre>");
$str_query.=" WHERE ".$this->myDBObj->qs_getWhereIn('OV_NAME',$arr_cols);
$arr_pkValues=array();
foreach($arr_pkCol as $str_pkName)
{
$str_query.=" AND ".$str_dbTbl."_OV.".$str_pkName."=".$str_dbTbl.".".$str_pkName;
}
if (sizeof($this->myFilter))
{
foreach($this->myFilter as $str_col => $m_val)
{
$str_query.=" AND ".$str_dbTbl.".".$str_col."=".$this->myDBObj->qs_getSlashedValue($m_val);
}
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"querry for objectvalues: <br />".$str_query);
if ($arr_objValues=$this->myDBObj->queryArray($str_query,0,-1))
{
foreach($this->myListValues as $i_idx => $arr_values)
{
foreach($arr_cols as $str_col)
{
if (isset($arr_objValues[$str_col."|".$arr_values[$arr_pkCol[0]]]['OV_VALUE']))
{
$this->myListValues[$i_idx][$str_col]=$arr_objValues[$str_col."|".$arr_values[$arr_pkCol[0]]]['OV_VALUE'];
} else {
$this->myListValues[$i_idx][$str_col]=NULL;
}
}
}
$this->lstObjValCols[$str_tbl]['LOADED']=TRUE;
$this->lstObjValTS=time();
} else {
ocsp_logError(__FILE__,__LINE__,"no objectvalues found with query: <br />".$str_query,E_NOTICE);
$this->lstObjValCols[$str_tbl]['LOADED']=False;
}
}
}
}
/**
* loads the list values from the database to $this->myListValues
* an always sets $this->listLoadTS to time()
*
* @param boolean $debug
* @param boolean $forceReload
*
* @return int number of rows found or False
*
* @todo OCSP_FRMCONTR_LIST::loadListValues() replace inline SQL
*
* @version pk-08-01-19 use $this->getListQuery to set $this->lstQuery
* @version pk-08-02-15 ~ => LIKE filter type added
* @version pk-08-06-26
* @version pk-08-11-26 $forceReload added
*/
function loadListValues($debug=False,$forceReload=False)
{
if($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::loadListValues()","ListQuery: ".$this->lstQuery."<br />Filter: <pre>".print_r($this->myFilter,TRUE)."</pre>");
if ($this->valuesAreLoaded() && !$forceReload) {
if ($debug) echoDebugLine(__FILE__,__LINE__,"ValuesAreLoaded");
return True;
}
$this->getDBObj($debug); // ensure $this->myDBObj is set
$this->getListQuery($debug); // ensure $this->lstQuery is set
if (!empty($this->lstQuery))
{
$str_query=$this->lstQuery;
if (sizeof($this->myFilter))
{
if (stristr($str_query,"where"))
{
$str_query.=" AND (";
} else {
$str_query.=" WHERE (";
}
// <pk-08-06-26>
$str_query .= $this->getFilterWhere($debug) . ")";
// </pk-08-06-26>
}
if ($this->getOrderBy())
{
$str_query.=" ORDER BY ".$this->getOrderBy();
}
if (intval($this->getLimit()))
{
$str_query.=" LIMIT ".intval($this->getOffset()).",".(intval($this->getLimit()));
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"List Query is set to: <br /><strong>".$this->lstQuery."</strong>".str_replace($this->lstQuery,"",$str_query));
$this->myListIdx=0;
$this->listLoadTS=time();
if ($debug) echoDebugLine(__FILE__,__LINE__,"listquery: " . $str_query);
if ($this->myListValues=$this->myDBObj->queryArray($str_query,-1,-1,TRUE,$debug))
{
return sizeof($this->myListValues);
} else {
if ($debug) ocsp_logError(__FILE__,__LINE__,'list has no values');
return 0;
}
} else {
if ($debug) echoDebugLine(__FILE__,__LINE__,"\$this->lstQuery is empty");
return False;
}
return False;
}
/**
* @return array $this->myListValues
* @since pk-07-09-16
*/
function getListValues()
{
return $this->myListValues;
}
/**
* @param boolean $debug
* @return array
*/
function getListRow($debug=False)
{
if($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getListRow()","Index: ".$this->myListIdx);
if ($this->listLoadTS < time()-ini_get('max_execution_time'))
{
if ($debug) echoDebugLine(__FILE__,__LINE__,time()-ini_get('max_execution_time'));
$this->loadListValues($debug);
}
if (isset($this->myListValues[$this->myListIdx]))
{
$this->curRow=&$this->myListValues[$this->myListIdx++];
if ($obj_tblObj=$this->getMyForm()->getMyTblObj(True,$debug))
{
if ($this->lstObjValTS)
{
$obj_tblObj->setDBVal($this->curRow,$debug);
} else {
$obj_tblObj->setDBRow($this->curRow,TRUE,$debug);
}
if (!empty($this->userCanShowMethod) && method_exists($obj_tblObj,$this->userCanShowMethod))
{
eval("\$b_canShow=\$obj_tblObj->".$this->userCanShowMethod."(\$debug);");
if (!$b_canShow) return $this->getListRow($debug);
}
if ($this->lstObjValTS)
{
$this->curRow=array_merge($this->curRow,$obj_tblObj->getDBVal());
} else {
$this->curRow=array_merge($this->curRow,$obj_tblObj->getDBRow(False,$debug));
}
}
return $this->curRow;
} else {
return NULL;
}
}
/**
* checks the listgroups for the current row and calls
* $this->myView->getGroupRow if it's to do
*
* @param boolean $debug
*
* @return string
*/
function getListGroups($debug)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getListGroups()");
$str_ret="";
$b_toChange=False;
if (is_array($this->lst_groupValues))
{
foreach($this->lst_groupValues as $str_col => $mix_value)
{
if (isset($this->curRow[$str_col]))
{
if (($b_toChange) || ($this->curRow[$str_col] != $mix_value))
{
$b_toChange=TRUE; // change each following group
$str_ret.=$this->myView->getGroupRow($str_col,$this->curRow,$debug);
$this->lst_groupValues[$str_col]=$this->curRow[$str_col];
}
}
}
}
return $str_ret;
}
/**
* returns the total number of rows
*
* @param boolean $debug
*
* @return int
*
* @since pk-08-05-30
*/
function getNofTotalRows($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getNofTotalRows()");
$this->getDBObj($debug); // ensure $this->myDBObj is set
$this->getListQuery($debug); // ensure $this->lstQuery is set
if (!empty($this->lstQuery))
{
$str_query=$this->lstQuery;
if (sizeof($this->myFilter))
{
if (stristr($str_query,"where"))
{
$str_query.=" AND (";
} else {
$str_query.=" WHERE (";
}
$str_whereAnd="";
foreach($this->myFilter as $str_col => $m_val)
{
if (substr($str_col,0,1)=="?")
{
$str_query .= $str_whereAnd . $m_val;
} else if (substr($str_col,0,1) == "~") {
$str_query .= $str_whereAnd . substr($str_col,1) . " " . $this->myDBObj->qs_getLikeStmt($m_val,False,False,$debug);
} else {
$str_query .= $str_whereAnd . $str_col . "=" . $this->myDBObj->qs_getSlashedValue($m_val);
}
$str_whereAnd=" AND ";
}
$str_query.=")";
}
$int_fromPos = stripos($str_query,'FROM');
$str_query = "SELECT COUNT(*) " . substr($str_query,($int_fromPos -1));
if ($debug) echoDebugLine(__FILE__,__LINE__,"Query: " . $str_query);
return intval($this->myDBObj->getOne($str_query));
} else {
if ($debug) echoDebugLine(__FILE__,__LINE__,"No ListQuery");
return 0;
}
}
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// controll elementes
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// table tag <table ...>
/**
* @param boolean $debug
* @return string the table id
* @access public
*/
function getTableId($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getTableId()");
return "tbl_".$this->myForm->getName();
}
/**
* @param boolean $debug
* @return string
* @access public
*/
function getTableEvents($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getTableId()");
return "";
}
// header
/**
* @param boolean $debug
* @return string
* @access public
*/
function getHeadRowEvents($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getHeadRowEvents()");
return "";
}
/**
* @param DBMS_FIELD $objField
* @param boolean $debug
* @return string
* @access public
*/
function getHeadColEvents(&$objField,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getHeadColEvents()");
if ($this->tbl_sortLink)
{
$str_link=$this->parseFieldTmpl($objField,$this->tbl_sortLink);
return " ondblclick=\"document.location=\"".$str_link.";\"";
}
}
// footer --------------------------------------
/**
* pageing is tourned on if the $_GET['offset'] and $_GET['limit'] are set
*
* @return boolean
*
* @since pk-08-11-21
*/
public function checkAutopageing($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::checkAutopageing()");
if (isset($_GET['offset']) && isset($_GET['limit']))
{
if ($debug) echoDebugLine(__FILE__,__LINE__,"offset & limit found");
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && ($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest'))
{
// jOCSP.load()
if ($debug) echoDebugLine(__FILE__,__LINE__,"Ajax request: <pre>" . print_r($_GET,True) . "</pre>");
return isset($_GET['inToDiv']);
} else {
return True;
}
}
return False;
}
/**
* returns the html code for the pageing back button
*
* @return string
*/
public function getPageingBackButton($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getPageingBackButton()");
pcf_require_class('OCSP_AJAX',"ajax/");
if (OCSP_AJAX::isAjaxCall() && !OCSP_AJAX::isjOCSPLoad())
{
if ($debug) echoDebugLine(__FILE__,__LINE__,"ajax call not supported");
return "";
}
$str_url = (empty($this->lst_pageingUrl) ? $_SERVER["REQUEST_URI"] : $this->lst_pageingUrl);
$int_offset = ((($this->lst_offset - $this->lst_limit) > 0) ? ($this->lst_offset - $this->lst_limit) : 0);
$str_url = pcf_HTML_changeURI_GetValue($str_url,'offset',$int_offset);
$str_return = "<div style=\"float:left;display:block;width:30px;height:28px;\"><a ";
if (OCSP_AJAX::isjOCSPLoad())
{
$str_return .= "onclick=\"jOCSP.load('{$_GET['inToDiv']}','{$str_url}');\"";
} else {
$str_return .= "href=\"{$str_url}\"";
}
$str_return .= "><img src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-22x22/1leftarrow.gif\" class=\"button\" alt=\"back\" title=\"" . t_admin('Zurück') . "\" /></a>";
$str_return .= "</div>";
return $str_return;
}
public function getPageingNext()
{
pcf_require_class('OCSP_AJAX',"ajax/");
if (OCSP_AJAX::isAjaxCall() && !OCSP_AJAX::isjOCSPLoad())
{
return "";
}
$str_url = (empty($this->lst_pageingUrl) ? $_SERVER["REQUEST_URI"] : $this->lst_pageingUrl);
$int_offset = $this->lst_offset + $this->lst_limit;
$str_url = pcf_HTML_changeURI_GetValue($str_url,'offset',$int_offset);
$str_return = "<div style=\"float:right;display:block;width:30px;height:28px;text-align:right;\"><a ";
if (OCSP_AJAX::isjOCSPLoad())
{
$str_return .= "onclick=\"jOCSP.load('{$_GET['inToDiv']}','{$str_url}');\"";
} else {
$str_return .= "href=\"{$str_url}\"";
}
$str_return .= "><img src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-22x22/1rightarrow.gif\" class=\"button\" alt=\"next\" title=\"" . t_admin('Weiter') . "\" /></a>";
$str_return .= "</div>";
return $str_return;
}
/**
* @param boolean $debug
* @return string
* @access public
*/
function getFooterLinks($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getTableFooter()",print_r($this->tbl_footerCmds,True));
$str_ret = "";
if ($this->checkAutopageing($debug))
{
$str_ret .= $this->getPageingBackButton();
$str_ret .= $this->getPageingNext();
}
if (sizeof($this->tbl_footerCmds))
{
foreach($this->tbl_footerCmds as $str_name => $str_link)
{
$str_ret.=$str_link;
}
}
if (OCSP_OBJ::currentUser()->isGroupMember(_OCSP_GROUP_DBMS_))
{
$str_ret .= "
<a href=\"" . OCSP_CONF::getInstance()->getValue('ADMINURL') . "dbms/form.php?FRM_ID=" . $this->getMyForm()->getId() . "\" title=\"" . t_admin('Formular bearbeiten') . "\">
<img src=\"" . OCSP_CONF::getInstance()->getValue('SYSIMGURL') . "icons-22x22/editConstruct.gif\" class=\"button\" />
</a>
";
}
return $str_ret;
}
public function addFooterCommand($aName,$htmlTag)
{
$this->tbl_footerCmds[$aName] = $htmlTag;
}
/**
* sets the footer cmd array
*
* NOTE: overwrites existing commands
*
* command array:
* - name
* - html code
*
* @param array $footerCmd
* @param boolean $debug
*/
function setFooterCmdArr($footerCmd,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::setFooterCmdArr()");
$this->tbl_footerCmds=$footerCmd;
}
// row and cols
function getRowId($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getRowId()");
$str_ret="trId";
foreach($this->lstTables as $arr_tblDesc)
{
if (isset($arr_tblDesc['PK']) && is_array($arr_tblDesc['PK']))
{
foreach($arr_tblDesc['PK'] as $str_colName)
$str_ret.="_".$str_colName."-".$this->curRow[$str_colName];
}
}
return $str_ret;
}
/**
* @param boolean $debug
* @return string
* @access public
*
* @requires __OCSP_PHPINCPATH__."common/pcf_templates.phpinc";
*
*/
function getRowCmd($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getRowCmd()");
$str_ret="";
if (is_array($this->myRowCmds) && sizeof($this->myRowCmds))
{
foreach($this->myRowCmds as $str_event => $str_cmd)
{
if ($debug) echoDebugLine(__FILE__,__LINE__,"<p><strong>{$str_event}</strong></p>");
$str_ret.=" ".$str_event."=\"".pcf_escape_doubleQuote(OCSP_TEMPLATE::parse($str_cmd,$this->curRow,$debug))."\"";
}
}
return $str_ret;
}
/**
* @param DBMS_FIELD $objField
* @param boolean $debug
* @return string
*/
function getColCmd($objField,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getColCmd()");
return "";
}
/**
* @param DBMS_FIELD $objField
* @param boolean $debug
* @return string
*/
function getColLink($objField,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getColLink()");
if ($arr_lnk=$objField->getListLinkArr())
{
if ((isset($arr_lnk['A'])) && (!empty($arr_lnk['A'])))
{
return "<a " . OCSP_TEMPLATE::parse($arr_lnk['A'],$this->curRow) . ">";
}
}
return "";
}
/**
* @param DBMS_FIELD $objField
* @param boolean $debug
* @return string
*/
function getColLinkEnd($objField,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getColLinkEnd()");
if ($arr_lnk=$objField->getListLinkArr())
{
if ((isset($arr_lnk['A'])) && (!empty($arr_lnk['A']))) {
return "</a>";
}
}
return "";
}
/**
* @param string $outerElem
* @param string $linkElem
* @param boolean $debug
* @return string
*/
function getRowButtons($outerElem="td",$linkElem="a",$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_LIST::getRowButton()");
$str_ret="";
if (sizeof($this->tbl_rowBtnCmds)) {
foreach($this->tbl_rowBtnCmds as $str_cmd => $str_tmpl)
{
$str_ret.="<{$outerElem}><{$linkElem} " . OCSP_TEMPLATE::parse($str_tmpl,$this->curRow) . ">";
$str_ret.=$this->myView->getButtonImgTag($str_cmd,$debug)."</{$linkElem}></{$outerElem}>";
}
}
return $str_ret;
}
} // end of OCSP_FRMCONTR_LIST
?>

Source for file OCSP_FRMCONTR_LIST.phpclass