File Source for OCSP_FRMCONTR_LIST

<?php
/**
* openCSP class file
*
* @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-29.05.2008
* @version $Id: OCSP_FRMCONTR_LIST_FLEXGRID.phpclass,v 1.8 2008/09/02 07:07:18 pitlinz Exp $
*/
// ---------------------------------------------------------
// requirements
// ---------------------------------------------------------
if (!class_exists('OCSP_FRMCONTR_LIST'))
{
require dirname(__FILE__) . _OCSP_DIRSEP_ . "OCSP_FRMCONTR_LIST.phpclass";
}
/**
* openCSP class file
*
* @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-29.05.2008
* @version $Id: OCSP_FRMCONTR_LIST_FLEXGRID.phpclass,v 1.8 2008/09/02 07:07:18 pitlinz Exp $
*/
class OCSP_FRMCONTR_LIST_FLEXGRID extends OCSP_FRMCONTR_LIST
{
/*** class constants --------------------------------------------- */
/**
* @constant string CLASS_SRC_FILE
*
* @abstract
*/
const CLASS_SRC_FILE = __FILE__;
/*** compostion --------------------------------------------------- */
/*** attributes -------------------------------------------------- */
/**
* @var string $myJsonUrl
*/
protected $myJsonUrl = "";
/*** factory / construct ----------------------------------------- */
/*** getter / setter ---------------------------------------------- */
/**
* @param string
*/
public function setJsonUrl($aUrl)
{
$this->myJsonUrl = $aUrl;
}
/**
* @return string
*/
public function getJsonUrl()
{
if (empty($this->myJsonUrl))
{
$this->myJsonUrl = OCSP_OBJ::getConf('jOCSPURL') . "flexgridRPC.php";
}
$str_url = pcf_HTML_changeURI_GetValue($this->myJsonUrl,'lstKey',$this->getListKey());
$str_url = pcf_HTML_changeURI_GetValue($str_url,'lstFRM_ID',$this->myForm->getId());
return $str_url;
}
/**
* returns the jason string for a page
*
* @param int $page
* @param int $rp
* @param string $sortname
* @param string $sortorder
* @param string $qtype (filter column name)
* @param string $query (filter value)
* @param boolean $debug
*
* @return string
*
*/
public function getJsonPage($page,$rp,$sortname,$sortorder,$qtype="",$query="",$debug=False)
{
ob_start();
$str_debug="";
$this->setOffset((intval($page)-1) * $rp);
$this->setLimit($rp);
if (!empty($query) && (strtolower($query) != "undefined"))
{
if (intval($query))
{
$this->myFilter['?FLEXGRID' . $qtype] = " $qtype =" . $query;
} else {
$bol_like = False;
if (strstr($query,"*"))
{
$query=str_replace("*","%",$query);
$bol_like=True;
} else if (strstr($query,"%")) {
$bol_like=True;
}
if ($bol_like)
{
$this->myFilter['?FLEXGRID' . $qtype] = " UPPER($qtype) LIKE '" . strtoupper($query) . "'";
} else {
$this->myFilter['?FLEXGRID' . $qtype] = " UPPER($qtype) LIKE '" . strtoupper($query) . "%'";
}
}
}
if (!empty($sortname) && (strtolower($sortname) != "undefined"))
{
$str_orderBy = $sortname;
if (!empty($sortorder) && (strtolower($sortorder) != "undefined"))
{
$str_orderBy .= " " . $sortorder;
}
$this->setOrderBy($str_orderBy);
}
$str_ret = "{";
$str_ret .= "page: " . $page;
$str_ret .= ",total: " . $this->getNofTotalRows();
$arr_cols = array();
$arr_idCols = array();
if ($arr_fields = $this->myForm->getFields(Null,$debug))
{
foreach($arr_fields as &$obj_fld)
{
if ($debug) $str_debug .= "Fld: ".$obj_fld->getName()." ";
if (!$obj_fld->isHidden('flexgrid'))
{
$arr_cols[] = $obj_fld->getName();
}
if ($obj_fld->isPrimaryKey())
{
$arr_idCols[] = $obj_fld->getName();
}
}
}
$str_debug.= " FIELDLIST: " . implode('|',array_merge($arr_cols,$arr_idCols));
$str_ret .= ",rows: [";
$cha_rowSep = "";
$arr_LeftButtons = $this->myView->getPosButtons(-1);
$arr_RightButtons = $this->myView->getPosButtons(1);
while($arr_row = $this->getListRow($debug))
{
if (sizeof($arr_idCols) == 1)
{
$str_rowId = $arr_row[$arr_idCols[0]];
} else {
$str_rowid = "";
$cha_sep = "";
foreach($arr_idCols as $str_colName)
{
$str_rowId .= $cha_sep . $str_colName."-".$arr_row[$str_colName];
$cha_sep = '_';
}
}
$str_ret .= $cha_rowSep . "{id: '" .$str_rowId . "',cell:[";
$cha_sep="";
if (sizeof($arr_LeftButtons))
{
$str_buttons = "";
foreach($arr_LeftButtons as $str_cmd)
{
$str_buttons .= "<a href=\"#\" " . pcf_tmpl_parse($this->tbl_rowBtnCmds[$str_cmd],$arr_row) . ">";
$str_buttons .= $this->myView->getButtonImgTag($str_cmd);
$str_buttons .= "</a>";
}
$str_ret .= $cha_sep . "'" . pcf_js_escape($str_buttons) ."'";
$cha_sep = ",";
}
foreach($arr_cols as $str_colName)
{
$str_ret .= $cha_sep ."'" . pcf_js_escape($this->myForm->getField($str_colName)->getListValue($arr_row[$str_colName])) . "'";
$cha_sep = ',';
}
if (sizeof($arr_RightButtons))
{
$str_buttons = "";
foreach($arr_RightButtons as $str_cmd)
{
$str_buttons .= "<a href=\"#\" " . pcf_tmpl_parse($this->tbl_rowBtnCmds[$str_cmd],$arr_row) . ">";
$str_buttons .= $this->myView->getButtonImgTag($str_cmd);
$str_buttons .= "</a>";
}
$str_ret .= $cha_sep . "'" . pcf_js_escape($str_buttons) ."'";
$cha_sep = ",";
}
$str_ret .= "]}";
$cha_rowSep = ",";
}
$str_ret .= "]";
if ($debug)
{
$str_ret .= ", debug: '" . pcf_js_escape($str_debug) . "'";
$str_ret .= ", lstQuery: '" . pcf_js_escape($this->getListQuery()) ."'";
$str_ret .= ", obOutput: '" . pcf_js_escape(ob_get_contents()) . "'";
}
ob_end_clean();
$str_ret .= "}";
return $str_ret;
}
}
?>

Source for file OCSP_FRMCONTR_LIST_FLEXGRID.phpclass