html->onclick = \"window.location='". $this->SystemSettings[FULL_PATH] ."?Action=Edit&\$evalkey'\";";
public $Data;
public $Columns;
public $sql;
public $sql2;
public $DataKey = array();
*/
private $srtArg;
public $isSortable = 1;
public $isPageable = 0;
//extends list basic, adding chks, # numbers, etc
public function __construct($DataKey)
{//note: DATAKEY has to be pressent in the query
parent::__construct();
if($DataKey!= ""){
if(is_array($DataKey)){
$this->DataKey = array_flip($DataKey);
foreach($this->DataKey as $key => $value)
$this->DataKey[$key] = -1;
}else{
$this->DataKey[$DataKey] = -1;
}
}else{
unset($this->DataKey);
}
$this->ToolBar->Buttons[btnNew]->blnShow = $this->Security->blnNew;
$this->ToolBar->Buttons[btnDelete]->blnShow = $this->Security->blnDelete;
$this->ToolBar->Buttons[btnExport]->blnShow = 1;
//$this->ToolBar->Buttons[btnExport]->blnShow = 1;
//print_rr($this->ToolBar->Buttons);
}
public function ListSQL($sql,$Debug=0, $path="", $action="")
{//print_rr($this->isSortable);
if(isset($this->Pages[$this->SystemSettings[SCRIPT_NAME]]->Sort) && $this->isSortable == 1)
{//replace ORDER BY with new Order by
//echo $sql ."
";
$srtArg = $this->Pages[$this->SystemSettings[SCRIPT_NAME]]->Sort;
//print_rr($this);
if($srtArg[srtCurrent] == $srtArg[srtNew])
{
if($srtArg[srtDir] == "DESC")
$srtArg[srtDir] = "ASC";
else
$srtArg[srtDir] = "DESC";
}else{
$srtArg[srtCurrent] = $srtArg[srtNew];
$srtArg[srtDir] = false;
}
//apply new ORDER BY
$idxOrder = strripos($sql, "ORDER BY");
if($idxOrder >> 0)
$sql = substr($sql, 0, $idxOrder);
$sql .= "ORDER BY `". $srtArg[srtCurrent] ."` ". $srtArg[srtDir];
//echo $idxOrder.$sql;
}
$this->srtArg = $srtArg;
//print_rr($srtArg);
parent::ListSQL($sql, $Debug);
//print_rr($this->SystemSettings);
if(isset($this->DataKey)){
foreach($this->DataKey as $key => $value)
{//print_rr($this->Columns);
//set datakey column idxs
$this->DataKey[$key] = $this->Columns[$key]->idx;
//hide PK
$this->Columns[$key]->Header->html->class =
$this->Columns[$key]->html->class = "tdPK";
}
}
if($action == ""){
$action = "Edit";
}
if($path == ""){
$path = $this->SystemSettings[FULL_PATH];
}
if(isset($this->DataKey)){
$this->eval = "\$column->html->onclick = \"window.location='$path?Action=$action&\$evalkey'\";";
}
}
public function renderList()
{//vd($this->srtArg);
return parent::renderList($this->srtArg);
}
//delete
public function renderTable($strCaption="", $tableHTML=null)
{
global $BR;
$strList = $this->renderList();
$htmlAttr = NemoControl::renderAttributes($tableHTML);
if($strCaption != "")
$strCaption = "$strCaption";
if($this->isPageable == 1 && $this->SystemSettings["PageSize"] > 0)
{
$Pager = $this->renderPager();
}
return "
$strCaption
$strList
$Pager
";
// I REMOVED THE BREAK TO DECREASE SPACING - JACQUES - 20130923
}
protected function renderPager()
{
global $SP, $BR;
$intPages = ceil($this->intRecords/$this->SystemSettings["PageSize"]);
for($i = 1; $i <= $intPages; $i++)
{
$strPager .= "$SP$SPPages[$this->SystemSettings[SCRIPT_NAME]]->PageNumber ? "class='aCurrent'":"href='?pagPageNumber=$i'") .">$i$SP$SP";
if($i % 75 == 0)
$strPager .= "$BR";
}
if($this->Pages[$this->SystemSettings[SCRIPT_NAME]]->PageNumber != 1)
$strFirst = "$SP$SP<<$SP$SPFirst$SP$SP<$SP$SPPrevious$SP";
else
$strFirst = "$SP$SP<<$SP$SPFirst$SP$SP<$SP$SPPrevious$SP";
if($this->Pages[$this->SystemSettings[SCRIPT_NAME]]->PageNumber != $intPages)
$strLast = "$SPNext$SP$SP>$SP$SPLast$SP$SP>>";
else
$strLast = "$SPNext$SP$SP>$SP$SPLast$SP$SP>>";
return "
";
}
}
?>