File Source for OCSP_FRMCONTR_PEAR

<?php
/**
* openCSP class file OCSP_FRMCONTR_PEAR_DATAGRID.phpclass
*
* @project Open CSP-Management
* @package default
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-26.11.2008
* @version $Id: OCSP_FRMCONTR_PEAR_DATAGRID.phpclass,v 1.2 2008/11/28 13:20:39 pitlinz Exp $
*/
// ---------------------------------------------------------
// requirements
// ---------------------------------------------------------
pcf_require_class('OCSP_FRMCONTR_LIST',"db/forms/");
pcf_require_class('PEAR_DATAGRID_DATASOURCE_OCSP_FRMCONTR_LIST',"db/forms/helper/");
if (!class_exists('Structures_DataGrid'))
{
@require_once("Structures" . _OCSP_DIRSEP_ . "DataGrid.php");
if (!class_exists('Structures_DataGrid'))
{
throw new Exception("MISSING PEAR:" . Structures_DataGrid_DataSource);
}
}
if (!defined('PEAR_DATAGRID_MAXLIMIT'))
{
define('PEAR_DATAGRID_MAXLIMIT',18446744073709551615);
}
/**
* openCSP class OCSP_FRMCONTR_PEAR_DATAGRID
*
* @project Open CSP-Management
* @package default
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-26.11.2008
* @version $Id: OCSP_FRMCONTR_PEAR_DATAGRID.phpclass,v 1.2 2008/11/28 13:20:39 pitlinz Exp $
*/
class OCSP_FRMCONTR_PEAR_DATAGRID extends OCSP_FRMCONTR_LIST
{
// ---------------------------------------------------------------------------
// constants
// ---------------------------------------------------------------------------
// ---------------------------------------------------------------------------
// class (static)
// ---------------------------------------------------------------------------
/*** class vars ------------------------------------------------------ */
/*** class methods --------------------------------------------------- */
// ---------------------------------------------------------------------------
// object vars
// ---------------------------------------------------------------------------
/*** compostion --------------------------------------------------- */
/**
* the data grid
*
* @var Structures_DataGrid $myPearDataGrid
*/
protected $myPearDataGrid = Null;
/**
* the data source
*
* @var PEAR_DATAGRID_DATASOURCE_OCSP_FRMCONTR_LIST $myPearDataSource
*/
protected $myPearDataSource = Null;
/*** attributes -------------------------------------------------- */
/**
* special sort prepended to the default list sort
*
* @var string $myDataGridSort
*/
protected $myDataGridSort = "";
/**
* pear data offset
*
* @var int $myPearDataOffset
*/
protected $myPearDataOffset = 0;
/**
* pear data limit
*
* @var int $myPearDataLimit
*/
protected $myPearDataLimit = 0;
/**
* the encodung
*
* @var string
*/
protected $encoding = 'ISO-8859-15';
// ---------------------------------------------------------------------------
// factory / construct
// ---------------------------------------------------------------------------
/**
* constructor
*
*/
public function __construct()
{
$this->myPearDataGrid = & new Structures_DataGrid();
}
// ---------------------------------------------------------------------------
// getter / setter
// ---------------------------------------------------------------------------
/**
* returns the grid data source object
*
* @return PEAR_DATAGRID_DATASOURCE_OCSP_FRMCONTR_LIST
*/
public function &getDataSource($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_PEAR_DATAGRID::getDataSource()");
if (!pcf_is_instance_of($this->myPearDataSource,'PEAR_DATAGRID_DATASOURCE_OCSP_FRMCONTR_LIST'))
{
$this->myPearDataSource = PEAR_DATAGRID_DATASOURCE_OCSP_FRMCONTR_LIST::factory($this,$debug);
}
return $this->myPearDataSource;
}
/**
* returns the data grid with the source binded
*
* @param boolean $debug
*
* @return unknown
*/
public function &getDataGrid($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_PEAR_DATAGRID::getDataGrid()");
if (!($obj_dataSource = $this->myPearDataGrid->getDataSource()))
{
$this->myPearDataGrid->bindDataSource($this->getDataSource($debug));
} else {
if ($debug) echoDebugLine(__FILE__,__LINE__,"<p>Datasource already set to: " . get_class($obj_dataSource));
}
return $this->myPearDataGrid;
}
/**
* returns the order by string
*
* appends $this->myDataGridSort
*
* @param boolean $debug
*
* @return string (mySQL)
*/
public function getOrderBy($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_PEAR_DATAGRID::getOrderBy()",$this->myDataGridSort);
if (!empty($this->myDataGridSort))
{
$str_sort = $this->myDataGridSort . ",";
} else {
$str_sort = "";
}
return $str_sort . parent::getOrderBy($debug);
}
/**
* sets the offset
*
* @param int $offset
*/
public function setOffset($offset)
{
if ($this->getOffset() != intval($offset))
{
parent::setOffset($offset);
if (!intval($this->getLimit()))
{
$this->setLimit(PEAR_DATAGRID_MAXLIMIT);
}
$this->invalidateValues();
}
}
/**
* sets the limit
*
* @param int $limit;
*/
public function setLimit($limit)
{
if($this->getLimit() != intval($limit))
{
parent::setLimit(intval($limit));
$this->invalidateValues();
}
}
/**
* sets the data grid sort
*
* note: forces a reload of the list values
*
* @param string $sort
*/
public function setDataGridSort($sort)
{
if ($this->myDataGridSort != $sort)
{
$this->myDataGridSort = $sort;
if ($this->valuesAreLoaded())
{
$this->invalidateValues();
}
}
}
// ---------------------------------------------------------------------------
// list db methods
// ---------------------------------------------------------------------------
/**
* returns the number of total rows
*
* @return int
*/
public function getNofListRows($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_PEAR_DATAGRID::getNofListRows()");
if (!$this->valuesAreLoaded())
{
$this->loadListValues($debug);
}
return parent::getNofListRows();
}
public function getListRows($offset=0,$limit=PEAR_DATAGRID_MAXLIMIT,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FRMCONTR_PEAR_DATAGRID::getListRows");
if (!$this->valuesAreLoaded())
{
$this->loadListValues();
}
$arr_fields = $this->getMyForm()->getFields();
$this->myListIdx = $offset;
$int_idx = 0;
$int_size = sizeof($this->myListValues);
// set the global data array
$str_globalArrName="LISTROW_".$this->myForm->getId();
global ${$str_globalArrName};
$arr_ret = array();
if ($debug)
{
echoDebugLine(__FILE__,__LINE__,"<pre>
offset: {$offset} ({$this->myListIdx})
int_size: {$int_size} / {$limit}
</pre>");
}
while(($this->myListIdx < $int_size) && (($int_idx < $limit) || (intval($limit) == 0)))
{
if (isset($this->myListValues[$this->myListIdx]))
{
$this->curRow=&$this->myListValues[$this->myListIdx];
if ($debug) echoDebugLine(__FILE__,__LINE__,"<p>current row</p><pre>" . print_r($this->curRow,True)) . "</pre>";
if ($obj_tblObj=$this->myForm->getMyTblObj(True,$debug))
{
if ($this->lstObjValTS)
{
$obj_tblObj->setDBVal($this->curRow,$debug);
} else {
$obj_tblObj->setDBRow($this->curRow,True,$debug);
}
// check show
if (!empty($this->userCanShowMethod) && method_exists($obj_tblObj,$this->userCanShowMethod))
{
eval("\$b_canShow=\$obj_tblObj->".$this->userCanShowMethod."(\$debug);");
if (!$b_canShow) continue;
}
if ($obj_tblObj->isPopulated())
{
$this->curRow=array_merge($this->curRow,$obj_tblObj->getDBVal());
} else {
$this->curRow=array_merge($this->curRow,$obj_tblObj->getDBRow(False,$debug));
}
}
${$str_globalArrName} = $this->curRow;
$arr_ret[$int_idx] = array();
foreach($arr_fields as &$obj_field)
{
if ($obj_field->exportCSV() && $obj_field->isToShow(FRM_MODE_LIST,$str_globalArrName))
{
$mix_listValue=(isset($this->curRow[$obj_field->getName()]) ? $this->curRow[$obj_field->getName()] : Null);
$arr_ret[$int_idx][$obj_field->getName()] = $obj_field->getCSV_Value($mix_listValue,$str_globalArrName,$debug);
if (strstr($this->encoding,'ISO-8859-1') !== False)
{
if (OCSP_OBJ::isMultiByteStr($arr_ret[$int_idx][$obj_field->getName()]))
{
$arr_ret[$int_idx][$obj_field->getName()] = utf8_decode($arr_ret[$int_idx][$obj_field->getName()]);
}
} else if (strstr($this->encoding,'UTF8')) {
if (!OCSP_OBJ::isUTF8($arr_ret[$int_idx][$obj_field->getName()]))
{
$arr_ret[$int_idx][$obj_field->getName()] = utf8_encode($arr_ret[$int_idx][$obj_field->getName()]);
}
}
}
}
$int_idx++;
}
$this->myListIdx++;
} // while(($this->myListIdx < $int_size) && (($int_idx ....)))
return $arr_ret;
}
}

Source for file OCSP_FRMCONTR_PEAR_DATAGRID.phpclass