Items);$x++)
-
{
-
$i =& $this->GetItemRefByIndex($x);
-
if($i->UniqueID()==$ID)
-
{
-
$found=TRUE;
-
break;
-
}
-
}
-
}
-
-
if(!$found)
-
{
-
if($LoadFromDB)
-
{
-
$n = NULL;
-
$n = new $this->classname();
-
$n->tablename = $this->SourceTable;
-
$n->LoadFromDatabase($ID);
-
$index = array_push($this->Items, $n);
-
$i =& $this->Items[count($this->Items)-1];
-
}
-
else
-
$i = FALSE;
-
}
-
return $i;
-
}
-
-
function GetItemByIndex($index)
-
{
-
return $this->Items[$index];
-
}
-
-
function &GetItemRefByIndex($index)
-
{
-
return $this->Items[$index];
-
}
-
-
function &GetItemByField($Field,$Value,$LoadFromDB=TRUE)
-
{
-
$found=FALSE;
-
if(is_array($this->Items))
-
{
-
foreach($this->Items as $i)
-
{
-
if($i->Get($Field)==$Value)
-
{
-
$found = TRUE;
-
break;
-
}
-
}
-
}
-
if(!$found && $LoadFromDB==TRUE)
-
{
-
$sql = "SELECT * FROM ".$this->SourceTable." WHERE $Field = '$Value'";
-
//echo $sql;
-
$res = $this->adodbConnection->Execute($sql);
-
-
if($res && !$res->EOF)
-
{
-
$i = $this->AddItemFromArray($res->fields);
-
$i->tablename = $this->SourceTable;
-
$i->Clean();
-
}
-
else
-
$i = FALSE;
-
}
-
return $i;
-
}
-
-
function GetPage($Page, $ItemsPerPage)
-
{
-
$result = array_slice($this->Items, ($Page * $ItemsPerPage) - $ItemsPerPage, $ItemsPerPage);
-
return $result;
-
}
-
-
function GetNumPages($ItemsPerPage)
-
{
-
if( isset($_GET['reset']) && $_GET['reset'] == 1) $this->Page = 1;
-
return GetPageCount($ItemsPerPage,$this->QueryItemCount);
-
}
-
-
function &AddItemFromArray($data, $clean=FALSE)
-
{
-
$class = new $this->classname;
-
$class->SetFromArray($data);
-
$class->tablename = $this->SourceTable;
-
if($clean==TRUE)
-
$class->Clean();
-
//array_push($this->Items,$class);
-
$this->Items[] =& $class;
-
return $class;
-
}
-
-
function Query_Item($sql, $offset=-1,$rows=-1)
-
{
-
global $Errors;
-
//echo "Method QItem [".get_class($this).'], sql: ['.$sql.']
';
-
//if( get_class($this) == 'clsthemefilelist') trace();
-
$dummy =& $this->GetDummy();
-
if( !$dummy->TableExists() )
-
{
-
if($this->debuglevel) echo "ERROR: table ".$dummy->tablename." missing.
";
-
$this->Clear();
-
return false;
-
}
-
-
if($rows>-1 && $offset>-1)
-
{
-
//print_pre(debug_backtrace());
-
//echo "Executing SelectLimit $sql Offset: $offset,$rows
\n";
-
$result = $this->adodbConnection->SelectLimit($sql, $rows,$offset);
-
}
-
else {
-
$result = $this->adodbConnection->Execute($sql);
-
}
-
-
if ($result === false)
-
{
-
$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Query_Item");
-
if($this->debuglevel) {
-
echo '
'.$sql.'
';
-
echo "Error: ".$this->adodbConnection->ErrorMsg()."
";
-
}
-
$this->Clear();
-
return false;
-
}
-
-
$this->Clear();
-
-
if($this->debuglevel > 0)
-
{
-
echo "This SQL: $sql
";
-
if( ($this->debuglevel > 1) && ($result->RecordCount() > 0) )
-
{
-
echo ''.print_r($result->GetRows(), true).'
';
-
$result->MoveFirst();
-
}
-
}
-
//echo "SQL: $sql
";
-
LogEntry("SQL Loop Start\n");
-
$count = 0;
-
-
while ($result && !$result->EOF)
-
{
-
$count++;
-
$data = $result->fields;
-
$this->AddItemFromArray($data,TRUE);
-
if( defined('ADODB_EXTENSION') && constant('ADODB_EXTENSION') > 0 )
-
adodb_movenext($result);
-
else
-
$result->MoveNext();
-
}
-
-
LogEntry("SQL Loop End ($count iterations)\n");
-
$result->Free();
-
return $this->Items;
-
}
-
-
function GetOrderClause($FieldVar,$OrderVar,$DefaultField,$DefaultVar,$Priority=TRUE,$UseTableName=FALSE)
-
{
-
global $objConfig, $objSession;
-
-
if($UseTableName)
-
{
-
$TableName = $this->SourceTable.".";
-
}
-
else
-
$TableName = "";
-
-
$PriorityClause = $TableName."EditorsPick DESC, ".$TableName."Priority DESC";
-
-
if(strlen(trim($FieldVar))>0)
-
{
-
if(is_object($objSession))
-
{
-
if(strlen($objSession->GetPersistantVariable($FieldVar))>0)
-
{
-
$OrderBy = trim($TableName.$objSession->GetPersistantVariable($FieldVar) . " ".
-
$objSession->GetPersistantVariable($OrderVar));
-
$FieldUsed = $objSession->GetPersistantVariable($FieldVar);
-
}
-
}
-
$OrderBy = trim($OrderBy);
-
if (strlen(trim($OrderBy))==0)
-
{
-
if(!$UseTableName)
-
{
-
$OrderBy = trim($DefaultField." ".$DefaultVar);
-
}
-
else
-
{
-
if(strlen(trim($DefaultField))>0)
-
{
-
$OrderBy = $this->SourceTable.".".$DefaultField.".".$DefaultVar;
-
}
-
$FieldUsed=$DefaultField;
-
}
-
}
-
}
-
if(($FieldUsed != "Priority" || strlen($OrderBy)==0) && $Priority==TRUE)
-
{
-
if(strlen($OrderBy)==0)
-
{
-
$OrderBy = $PriorityClause;
-
}
-
else
-
$OrderBy = $PriorityClause.", ".$OrderBy;
-
}
-
return $OrderBy;
-
}
-
-
function GetResourceIDList()
-
{
-
$ret = array();
-
foreach($this->Items as $i)
-
array_push($ret,$i->Get("ResourceId"));
-
return $ret;
-
}
-
-
function GetFieldList($field)
-
{
-
$ret = array();
-
foreach($this->Items as $i)
-
array_push($ret,$i->Get($field));
-
return $ret;
-
}
-
-
function SetCommonField($FieldName,$FieldValue)
-
{
-
for($i=0;$i<$this->NumItems();$i++)
-
{
-
$this->Items[$i]->Set($FieldName,$fieldValue);
-
$this->Items[$i]->Update();
-
}
-
}
-
-
function ClearCategoryItems($CatId,$CatTable = "CategoryItems")
-
{
-
$CatTable = AddTablePrefix($CatTable);
-
$sql = "SELECT * FROM ".$this->SourceTable." INNER JOIN $CatTable ".
-
" ON (".$this->SourceTable.".ResourceId=$CatTable.ItemResourceId) WHERE CategoryId=$CatId";
-
$this->Clear();
-
$this->Query_Item($sql);
-
if($this->NumItems()>0)
-
{
-
foreach($this->Items as $i)
-
{
-
$i->DeleteCategoryItems($CatId,$CatTable);
-
}
-
}
-
}
-
-
function CopyToEditTable($idfield = null, $idlist = 0)
-
{
-
global $objSession;
-
-
if($idfield == null) $idfield = $this->GetIDField();
-
$edit_table = $objSession->GetEditTable($this->SourceTable);
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
if(is_array($idlist))
-
{
-
$list = implode(",",$idlist);
-
}
-
else
-
$list = $idlist;
-
$query = "SELECT * FROM ".$this->SourceTable." WHERE $idfield IN ($list)";
-
$insert = "CREATE TABLE ".$edit_table." ".$query;
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($insert,ENT_NOQUOTES)."
\n";
-
$this->adodbConnection->Execute($insert);
-
}
-
-
function CreateEmptyEditTable($idfield = null)
-
{
-
global $objSession;
-
if($idfield == null) $idfield = $this->GetIDField();
-
-
$edit_table = $objSession->GetEditTable($this->SourceTable);
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
$query = "SELECT * FROM ".$this->SourceTable." WHERE $idfield = -1";
-
$insert = "CREATE TABLE ".$edit_table." ".$query;
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($insert,ENT_NOQUOTES)."
\n";
-
$this->adodbConnection->Execute($insert);
-
//echo $insert."
";
-
}
-
-
function CopyFromEditTable($idfield = null)
-
{
-
global $objSession;
-
-
$dropRelTableFlag = false;
-
if($idfield == null) $idfield = $this->GetIDField();
-
$edit_table = $objSession->GetEditTable($this->SourceTable);
-
$sql = "SELECT * FROM $edit_table";
-
$rs = $this->adodbConnection->Execute($sql);
-
-
//echo "In Main CopyFromEditTable in class ".get_class($this).'
';
-
//echo $sql."
";
-
-
while($rs && !$rs->EOF)
-
{
-
$data = $rs->fields;
-
$c = new $this->classname;
-
$c->SetFromArray($data);
-
$c->idfield = $idfield;
-
$c->Dirty();
-
if($c->Get($idfield) < 1)
-
{
-
$old_id = $c->Get($idfield);
-
$c->UnsetIdField();
-
if(!is_numeric($c->Get("OrgId")) || $c->Get("OrgId")==0)
-
{
-
$c->Clean(array("OrgId"));
-
}
-
else
-
{
-
if($c->Get("Status") != -2)
-
{
-
$org = new $this->classname();
-
$org->LoadFromDatabase($c->Get("OrgId"));
-
$org->DeleteCustomData();
-
$org->Delete(TRUE);
-
$c->Set("OrgId",0);
-
}
-
}
-
$c->Create();
-
}
-
if(is_numeric($c->Get("ResourceId")))
-
{
-
if( isset($c->Related) && is_object($c->Related) )
-
{
-
$r = $c->Related;
-
$r->CopyFromEditTable($c->Get("ResourceId"));
-
$dropRelTableFlag = true;
-
}
-
-
unset($r);
-
-
if( isset($c->Reviews) && is_object($c->Reviews) )
-
{
-
$r = $c->Reviews;
-
$r->CopyFromEditTable($c->Get("ResourceId"));
-
}
-
}
-
if(!is_numeric($c->Get("OrgId")) || $c->Get("OrgId")==0)
-
{
-
$c->Clean(array("OrgId"));
-
}
-
else
-
{
-
if($c->Get("Status") != -2)
-
{
-
$org = new $this->classname();
-
$org->LoadFromDatabase($c->Get("OrgId"));
-
$org->DeleteCustomData();
-
$org->Delete(TRUE);
-
$c->Set("OrgId",0);
-
}
-
}
-
-
if(method_exists($c,"CategoryMemberList"))
-
{
-
$cats = $c->CategoryMemberList($objSession->GetEditTable("CategoryItems"));
-
$ci_table = $objSession->GetEditTable('CategoryItems');
-
$primary_cat = $c->GetPrimaryCategory($ci_table);
-
$c->Update();
-
UpdateCategoryItems($c,$cats,$primary_cat);
-
}
-
else
-
$c->Update();
-
-
unset($c);
-
unset($r);
-
-
$rs->MoveNext();
-
}
-
-
if ($dropRelTableFlag)
-
{
-
$objRelGlobal = new clsRelationshipList();
-
$objRelGlobal->PurgeEditTable();
-
}
-
-
if($edit_table) @$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS ".$objSession->GetEditTable("CategoryItems"));
-
}
-
-
function GetNextTempID()
-
{
-
// get next temporary id (lower then zero) from temp table
-
$db =& $this->adodbConnection;
-
$sql = 'SELECT MIN(%s) AS MinValue FROM %s';
-
return $db->GetOne( sprintf($sql, $this->GetIDField(), $this->SourceTable) ) - 1;
-
}
-
-
function PurgeEditTable($idfield = null)
-
{
-
global $objSession;
-
-
if($idfield == null) $idfield = $this->GetIDField();
-
$edit_table = $objSession->GetEditTable($this->SourceTable);
-
/* $rs = $this->adodbConnection->Execute("SELECT * FROM $edit_table");
-
while($rs && !$rs->EOF)
-
{
-
$data = $rs->fields;
-
$c = new $this->classname;
-
$c->SetFromArray($data);
-
$c->id_field = $idfield;
-
$c->tablename = $edit_table;
-
$c->Delete();
-
$rs->MoveNext();
-
}*/
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS ".$objSession->GetEditTable("CategoryItems"));
-
}
-
-
function CopyCatListToEditTable($idfield, $idlist)
-
{
-
global $objSession;
-
-
$edit_table = $objSession->GetEditTable("CategoryItems");
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
if(is_array($idlist))
-
{
-
$list = implode(",",$idlist);
-
}
-
else
-
$list = $idlist;
-
$query = "SELECT * FROM ".GetTablePrefix()."CategoryItems WHERE $idfield IN ($list)";
-
-
$insert = "CREATE TABLE ".$edit_table." ".$query;
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($insert,ENT_NOQUOTES)."
\n";
-
$this->adodbConnection->Execute($insert);
-
}
-
-
function CreateEmptyCatListTable($idfield)
-
{
-
global $objSession;
-
-
$edit_table = $objSession->GetEditTable("CategoryItems");
-
@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
$query = "SELECT * FROM ".GetTablePrefix()."CategoryItems WHERE $idfield = -1";
-
$insert = "CREATE TABLE ".$edit_table." ".$query;
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($insert,ENT_NOQUOTES)."
\n";
-
$this->adodbConnection->Execute($insert);
-
}
-
-
-
function PurgeCatListEditTable()
-
{
-
global $objSession;
-
-
$edit_table = $objSession->GetEditTable("CategoryItems");
-
$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
-
}
-
-
function AdminSearchWhereClause($SearchList)
-
{
-
$sql = "";
-
if( !is_array($SearchList) ) $SearchList = explode(",",$SearchList);
-
-
// remove empty elements
-
$SearchListTmp=Array();
-
for($f = 0; $f < count($SearchList); $f++)
-
if($SearchList[$f])
-
$SearchListTmp[]=$SearchList[$f];
-
$SearchList=$SearchListTmp;
-
-
if( !count($SearchList) || !count($this->AdminSearchFields) ) return '';
-
-
for($f = 0; $f < count($SearchList); $f++)
-
{
-
$value = $SearchList[$f];
-
if( strlen($value) )
-
{
-
$inner_sql = "";
-
for($i = 0; $i < count($this->AdminSearchFields); $i++)
-
{
-
$field = $this->AdminSearchFields[$i];
-
if( strlen( trim($value) ) )
-
{
-
if( strlen($inner_sql) ) $inner_sql .= " OR ";
-
$inner_sql .= $field." LIKE '%".$value."%'";
-
}
-
}
-
if( strlen($inner_sql) )
-
{
-
$sql .= '('.$inner_sql.') ';
-
if($f < count($SearchList) - 1) $sql .= " AND ";
-
}
-
}
-
}
-
return $sql;
-
}
-
-
function BackupData($OutFileName,$Start,$Limit)
-
{
-
$fp=fopen($Outfile,"a");
-
if($fp)
-
{
-
if($Start==1)
-
{
-
$sql = "DELETE FROM ".$this->SourceTable;
-
fputs($fp,$sql);
-
}
-
$this->Query_Item("SELECT * FROM ".$this->SourceTable." LIMIT $Start, $Limit");
-
foreach($this->Items as $i)
-
{
-
$sql = $i->CreateSQL();
-
fputs($fp,$sql);
-
}
-
fclose($fp);
-
$this->Clear();
-
}
-
}
-
-
function RestoreData($InFileName,$Start,$Limit)
-
{
-
$res = -1;
-
$fp=fopen($InFileName,"r");
-
if($fp)
-
{
-
fseek($fp,$Start);
-
$Line = 0;
-
while($Line < $Limit)
-
{
-
$sql = fgets($fp,16384);
-
$this->adodbConnection->Execute($sql);
-
$Line++;
-
}
-
$res = ftell($fp);
-
fclose($fp);
-
}
-
return $res;
-
}
-
-
function Delete_Item($Id)
-
{
-
global $objCatList;
-
-
$l =& $this->GetItem($Id);
-
$l->BasePermission=$this->BasePermission;
-
$l->DeleteCategoryItems($objCatList->CurrentCategoryID());
-
}
-
-
function Move_Item($Id, $OldCat, $ParentTo)
-
{
-
global $objCatList;
-
-
$l = $this->GetItem($Id);
-
$l->BasePermission=$this->BasePermission;
-
$l->AddtoCategory($ParentTo);
-
$l->RemoveFromCategory($OldCat);
-
}
-
-
function Copy_Item($Id, $ParentTo)
-
{
-
$l = $this->GetItem($Id);
-
$l->BasePermission=$this->BasePermission;
-
$l->AddtoCategory($ParentTo);
-
}
-
-
}/* clsItemCollection */
-
-
class clsItemList extends clsItemCollection
-
{
-
var $Page;
-
var $PerPageVar;
-
var $DefaultPerPage; // use this perpage value in case if no found in config
-
var $EnablePaging;
-
var $MaxListCount = 0;
-
var $PageEnvar;
-
var $PageEnvarIndex;
-
var $ListType;
-
-
var $LastLimitClause = ''; // used to store last limit cluse used in query
-
-
function clsItemList()
-
{
-
$this->clsItemCollection();
-
$this->EnablePaging = TRUE;
-
$this->PageEnvarIndex = "p";
-
}
-
-
function GetPageLimitSQL()
-
{
-
global $objConfig;
-
$limit = NULL;
-
if($this->EnablePaging)
-
{
-
if($this->Page<1)
-
$this->Page=1;
-
//echo "Limited to ".$objConfig->Get($this->PerPageVar)." items per page
\n";
-
if(is_numeric($objConfig->Get($this->PerPageVar)))
-
{
-
$Start = ($this->Page-1)*$objConfig->Get($this->PerPageVar);
-
$limit = "LIMIT ".$Start.",".$objConfig->Get($this->PerPageVar);
-
}
-
else
-
$limit = NULL;
-
}
-
else
-
{
-
if($this->MaxListCount)
-
{
-
$limit = "LIMIT 0, $MaxListCount";
-
}
-
}
-
return $limit;
-
}
-
-
function GetPageOffset()
-
{
-
$Start = 0;
-
if($this->EnablePaging)
-
{
-
if($this->Page < 1) $this->Page = 1;
-
$PerPage = $this->GetPerPage();
-
$Start = ($this->Page - 1) * $PerPage;
-
}
-
else
-
{
-
if((int)$this->MaxListCount == 0) $Start = -1;
-
}
-
return $Start;
-
}
-
-
function GetPageRowCount()
-
{
-
if($this->EnablePaging)
-
{
-
if($this->Page < 1) $this->Page = 1;
-
return $this->GetPerPage();
-
}
-
else
-
return (int)$this->MaxListCount;
-
}
-
-
function Query_Item($sql,$limit = null, $fix_method = 'set_first')
-
{
-
// query itemlist (module items) using $sql specified
-
// apply direct limit clause ($limit) or calculate it if not specified
-
// fix invalid page in case if needed by method specified in $fix_method
-
if(strlen($limit))
-
{
-
$sql .= " ".$limit;
-
return parent::Query_Item($sql);
-
}
-
else
-
{
-
//echo "page fix pre (class: ".get_class($this).")
";
-
$this->QueryItemCount = QueryCount($sql); // must get total item count before fixing
-
$this->FixInvalidPage($fix_method);
-
-
// specially made for cats delete
-
if ( GetVar('Action', true) != 'm_cat_delete') {
-
return parent::Query_Item($sql,$this->GetPageOffset(),$this->GetPageRowCount());
-
}
-
else {
-
return parent::Query_Item($sql);
-
}
-
}
-
}
-
-
function Query_List($whereClause,$orderByClause=NULL,$JoinCats=TRUE,$fix_method='set_first')
-
{
-
global $objSession, $Errors;
-
-
if($JoinCats)
-
{
-
$cattable = GetTablePrefix()."CategoryItems";
-
$t = $this->SourceTable;
-
$sql = "SELECT *,CategoryId FROM $t INNER JOIN $cattable ON $cattable.ItemResourceId=$t.ResourceId";
-
}
-
else
-
$sql = "SELECT * FROM ". $this->SourceTable;
-
if(trim($whereClause)!="")
-
{
-
if(isset($whereClause))
-
$sql = sprintf('%s WHERE %s',$sql,$whereClause);
-
}
-
if(strlen($orderByClause)>0)
-
{
-
if(substr($orderByClause,0,8)=="ORDER BY")
-
{
-
$sql .= " ".$orderByClause;
-
}
-
else
-
{
-
$sql .= " ORDER BY $orderByClause";
-
}
-
}
-
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo $sql."
\n";
-
-
return $this->Query_Item($sql, null, $fix_method);
-
}
-
-
function GetPerPage()
-
{
-
// return category perpage
-
global $objConfig;
-
$PerPage = $objConfig->Get( $this->PerPageVar );
-
if( !is_numeric($PerPage) ) $PerPage = $this->DefaultPerPage ? $this->DefaultPerPage : 10;
-
return $PerPage;
-
}
-
-
function FixInvalidPage($fix_method = 'set_first')
-
{
-
// in case if current page > total page count,
-
// then set current page to last possible "set_last"
-
// or first possible "set_first"
-
$PerPage = $this->GetPerPage();
-
$NumPages = ceil( $this->GetNumPages($PerPage) );
-
/*
-
echo "=====
";
-
echo "Class ".get_class($this).": Page ".$this->Page." of $NumPages
";
-
echo "PerPage: $PerPage
";
-
echo "Items Queries: ".$this->QueryItemCount."
";
-
echo "=====
";
-
*/
-
if($this->Page > $NumPages)
-
{
-
switch($fix_method)
-
{
-
case 'set_first':
-
$this->Page = 1;
-
//echo "Move 2 First (class ".get_class($this).")
";
-
break;
-
case 'set_last':
-
$this->Page = $NumPages;
-
//echo "Move 2 Last (class ".get_class($this).")
";
-
break;
-
}
-
$this->SaveNewPage();
-
}
-
}
-
-
function SaveNewPage()
-
{
-
// redefine in each list, should save to env array new page value
-
-
}
-
-
function GetPageLinkList($dest_template=NULL,$page = "",$PagesToList=10, $HideEmpty=TRUE,$EnvSuffix = '')
-
{
-
global $objConfig, $var_list_update, $var_list;
-
-
-
$v= $this->PageEnvar;
-
-
global ${$v};
-
-
if(!strlen($page))
-
$page = GetIndexURL();
-
-
$PerPage = $objConfig->Get($this->PerPageVar);
-
if($PerPage<1)
-
$PerPage=20;
-
$NumPages = ceil($this->GetNumPages($PerPage));
-
if($NumPages==1 && $HideEmpty)
-
return "";
-
-
if(strlen($dest_template))
-
{
-
$var_list_update["t"] = $dest_template;
-
}
-
else
-
$var_list_update["t"] = $var_list["t"];
-
-
$o = "";
-
if($this->Page==0 || !is_numeric($this->Page))
-
$this->Page=1;
-
if($this->Page>$NumPages)
-
$this->Page=$NumPages;
-
-
$StartPage = (int)$this->Page - ($PagesToList/2);
-
if($StartPage<1)
-
$StartPage=1;
-
-
$EndPage = $StartPage+($PagesToList-1);
-
if($EndPage>$NumPages)
-
{
-
$EndPage = $NumPages;
-
$StartPage = $EndPage-($PagesToList-1);
-
if($StartPage<1)
-
$StartPage=1;
-
}
-
-
$o = "";
-
if($StartPage>1)
-
{
-
${$v}[$this->PageEnvarIndex] = $this->Page-$PagesToList;
-
-
$prev_url = $page."?env=".BuildEnv().$EnvSuffix;
-
$o .= "<<";
-
}
-
-
for($p=$StartPage;$p<=$EndPage;$p++)
-
{
-
if($p!=$this->Page)
-
{
-
${$v}[$this->PageEnvarIndex]=$p;
-
$href = $page."?env=".BuildEnv().$EnvSuffix;
-
$o .= " $p ";
-
}
-
else
-
{
-
$o .= " $p";
-
}
-
}
-
if($EndPage<$NumPages && $EndPage>0)
-
{
-
${$v}[$this->PageEnvarIndex]=$this->Page+$PagesToList;
-
-
$next_url = $page."?env=".BuildEnv().$EnvSuffix;
-
$o .= " >>";
-
}
-
unset(${$v}[$this->PageEnvarIndex],$var_list_update["t"] );
-
return $o;
-
}
-
-
function GetAdminPageLinkList($url)
-
{
-
global $objConfig;
-
-
$update =& $GLOBALS[$this->PageEnvar]; // env_var_update
-
-
// insteresting stuff :)
-
if(!$this->PerPageVar) $this->PerPageVar = "Perpage_Links";
-
-
$PerPage = $objConfig->Get($this->PerPageVar);
-
if($PerPage < 1) $PerPage = 20;
-
-
$NumPages = ceil($this->GetNumPages($PerPage));
-
-
//echo $this->CurrentPage." of ".$NumPages." Pages";
-
-
if($this->Page > $NumPages) $this->Page = $NumPages;
-
-
$StartPage = $this->Page - 5;
-
if($StartPage < 1) $StartPage = 1;
-
$EndPage = $StartPage + 9;
-
if($EndPage > $NumPages)
-
{
-
$EndPage = $NumPages;
-
$StartPage = $EndPage-9;
-
if($StartPage < 1) $StartPage = 1;
-
}
-
-
$o = '';
-
-
if($StartPage > 1)
-
{
-
$update[$this->PageEnvarIndex]= $this->Page - 10;
-
$prev_url = $url.'?env='.BuildEnv();
-
$o .= '<<';
-
}
-
-
-
for($p = $StartPage; $p <= $EndPage; $p++)
-
{
-
if($p != $this->Page)
-
{
-
$update[$this->PageEnvarIndex] = $p;
-
$href = $url.'?env='.BuildEnv();
-
$o .= ' '.$p.' ';
-
}
-
else
-
{
-
$o .= ''.$p.'';
-
}
-
}
-
if($EndPage < $NumPages)
-
{
-
$update[$this->PageEnvarIndex] = $this->Page + 10;
-
$next_url = $url.'?env='.BuildEnv();
-
$o .= ' >>';
-
}
-
unset( $update[$this->PageEnvarIndex] );
-
return $o;
-
}
-
}
-
-
function ParseClipboard($clip)
-
{
-
$ret = array();
-
-
$parts = explode(".",$clip,3);
-
$command = $parts[0];
-
$table = $parts[1];
-
$prefix = GetTablePrefix();
-
if(substr($table,0,strlen($prefix))==$prefix)
-
$table = substr($table,strlen($prefix));
-
-
$subparts = explode("=",$parts[2],2);
-
$idfield = $subparts[0];
-
$idlist = $subparts[1];
-
$cmd = explode("-",$command);
-
$ret["command"] = $cmd[0];
-
$ret["source"] = $cmd[1];
-
$ret["table"] = $table;
-
$ret["idfield"] = $idfield;
-
$ret["ids"] = $idlist;
-
//print_pre($ret);
-
return $ret;
-
}
-
-
function UpdateCategoryItems($item,$NewCatList,$PrimaryCatId = false)
-
{
-
global $objCatList;
-
-
$CurrentList = explode(",",$item->CategoryMemberList());
-
$del_list = array();
-
$ins_list = array();
-
-
-
if(!is_array($NewCatList))
-
{
-
if(strlen(trim($NewCatList))==0)
-
$NewCatList = $objCatList->CurrentCategoryID();
-
-
$NewCatList = explode(",",$NewCatList);
-
}
-
//print_r($NewCatList);
-
-
for($i=0;$iAddToCategory($cat);
-
}
-
for($i=0;$iRemoveFromCategory($cat);
-
}
-
if($PrimaryCatId !== false) $item->SetPrimaryCategory($PrimaryCatId);
-
}
-
-
class clsCatItemList extends clsItemList
-
{
-
var $PerPageVarLong;
-
var $PerPageShortVar;
-
var $Query_SortField;
-
var $Query_SortOrder;
-
var $ItemType;
-
-
function clsCatItemList()
-
{
-
$this->ClsItemList();
-
$this->Query_SortField = array();
-
$this->Query_SortOrder = array();
-
}
-
-
function QueryOrderByClause($EditorsPick=FALSE,$Priority=FALSE,$UseTableName=FALSE)
-
{
-
global $objSession;
-
-
if($UseTableName)
-
{
-
$TableName = $this->SourceTable.".";
-
}
-
else {
-
$TableName = "";
-
}
-
-
$Orders = array();
-
-
if($EditorsPick)
-
{
-
$Orders[] = $TableName."EditorsPick DESC";
-
}
-
if($Priority)
-
{
-
$Orders[] = $TableName."Priority DESC";
-
}
-
-
if(count($this->Query_SortField)>0)
-
{
-
for($x=0; $xQuery_SortField); $x++)
-
{
-
$FieldVar = $this->Query_SortField[$x];
-
$OrderVar = $this->Query_SortOrder[$x];
-
-
if(is_object($objSession))
-
{
-
$FieldVarData = $objSession->GetPersistantVariable($FieldVar);
-
if(strlen($FieldVarData)>0)
-
{
-
$Orders[] = trim($TableName.$objSession->GetPersistantVariable($FieldVar) . " ".
-
$objSession->GetPersistantVariable($OrderVar));
-
}
-
}
-
}
-
}
-
-
if(count($Orders)>0)
-
{
-
$OrderBy = "ORDER BY ".implode(", ",$Orders);
-
}
-
else
-
$OrderBy="";
-
-
return $OrderBy;
-
}
-
-
function AddSortField($SortField, $SortOrder)
-
{
-
if(strlen($SortField))
-
{
-
$this->Query_SortField[] = $SortField;
-
$this->Query_SortOrder[] = $SortOrder;
-
}
-
}
-
-
function ClearSortFields()
-
{
-
$this->Query_SortField = array();
-
$this->Query_SortOrder = array();
-
}
-
-
/* skeletons in this closet */
-
-
function GetNewValue($CatId=NULL)
-
{
-
return 0;
-
}
-
-
function GetPopValue($CategoryId=NULL)
-
{
-
return 0;
-
}
-
-
/* end of skeletons */
-
-
function GetCountSQL($PermName,$CatId=NULL, $GroupId=NULL, $AdditonalWhere="")
-
{
-
global $objSession, $objPermissions, $objCatList;
-
-
$ltable = $this->SourceTable;
-
$acl = $objSession->GetACLClause();
-
$cattable = GetTablePrefix()."CategoryItems";
-
$CategoryTable = GetTablePrefix()."Category";
-
$ptable = GetTablePrefix()."PermCache";
-
$VIEW = $objPermissions->GetPermId($PermName);
-
-
$sql = "SELECT count(*) as CacheVal FROM $ltable ";
-
$sql .="INNER JOIN $cattable ON ($cattable.ItemResourceId=$ltable.ResourceId) ";
-
$sql .="INNER JOIN $CategoryTable ON ($CategoryTable.CategoryId=$cattable.CategoryId) ";
-
$sql .="INNER JOIN $ptable ON ($cattable.CategoryId=$ptable.CategoryId) ";
-
$sql .="WHERE ($acl AND PermId=$VIEW AND $cattable.PrimaryCat=1 AND $CategoryTable.Status=1) ";
-
-
if(strlen($AdditonalWhere)>0)
-
{
-
$sql .= "AND (".$AdditonalWhere.")";
-
}
-
-
return $sql;
-
}
-
-
function SqlCategoryList($attribs = array())
-
{
-
$CatTable = GetTablePrefix()."CategoryItems";
-
$t = $this->SourceTable;
-
-
$sql = "SELECT *,$CatTable.CategoryId FROM $t INNER JOIN $CatTable ON $CatTable.ItemResourceId=$t.ResourceId ";
-
$sql .="WHERE ($CatTable.CategoryId=".$catid." AND $t.Status=1)";
-
-
return $sql;
-
}
-
-
-
function CategoryCount($attribs=array())
-
{
-
global $objCatList, $objCountCache;
-
-
$cat = $attribs["_catid"];
-
if(!is_numeric($cat))
-
{
-
$cat = $objCatList->CurrentCategoryID();
-
}
-
if((int)$cat>0)
-
$c = $objCatList->GetCategory($cat);
-
-
$CatTable = GetTablePrefix()."CategoryItems";
-
$t = $this->SourceTable;
-
-
$sql = "SELECT count(*) as MyCount FROM $t INNER JOIN $CatTable ON ($CatTable.ItemResourceId=$t.ResourceId) ";
-
if($attribs["_subcats"])
-
{
-
$ctable = $objCatList->SourceTable;
-
$sql .= "INNER JOIN $ctable ON ($CatTable.CategoryId=$ctable.CategoryId) ";
-
$sql .= "WHERE (ParentPath LIKE '".$c->Get("ParentPath")."%' ";
-
if(!$attribs["_countcurrent"])
-
{
-
$sql .=" AND $ctable.CategoryId != $cat) ";
-
}
-
else
-
$sql .=") ";
-
}
-
else
-
$sql .="WHERE ($CatTable.CategoryId=".$cat." AND $t.Status=1) ";
-
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$sql .= "AND ($t.CreatedOn>=$today) ";
-
}
-
//echo $sql."
\n";
-
$rs = $this->adodbConnection->Execute($sql);
-
$ret = "";
-
if($rs && !$rs->EOF)
-
$ret = (int)$rs->fields["MyCount"];
-
return $ret;
-
}
-
-
function SqlGlobalCount($attribs=array())
-
{
-
global $objSession;
-
-
$p = $this->BasePermission.".VIEW";
-
$t = $this->SourceTable;
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$where = "($t.CreatedOn>=$today)";
-
}
-
-
if($attribs["_grouponly"])
-
{
-
$GroupList = $objSession->Get("GroupList");
-
}
-
else
-
$GroupList = NULL;
-
-
$sql = $this->GetCountSQL($p,NULL,$GroupList,$where);
-
return $sql;
-
}
-
-
function DoGlobalCount($attribs)
-
{
-
global $objCountCache;
-
-
$cc = $objCountCache->GetValue($this->CacheListType("_"),$this->ItemType,$this->CacheListExtraId("_"),(int)$attribs["_today"], 3600);
-
if(!is_numeric($cc))
-
{
-
$sql = $this->SqlGlobalCount($attribs);
-
$ret = QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("_"),$this->ItemType,$this->CacheListExtraId("_"),(int)$attribs["_today"],$ret);
-
}
-
else
-
$ret = $cc;
-
return $ret;
-
}
-
-
-
function CacheListExtraId($ListType)
-
{
-
global $objSession;
-
-
if(!strlen($ListType))
-
$ListType="_";
-
switch($ListType)
-
{
-
case "_":
-
$ExtraId = $objSession->Get("GroupList");
-
break;
-
case "category":
-
$ExtraId = $objSession->Get("GroupList");
-
break;
-
case "myitems":
-
$ExtraId = $objSession->Get("PortalUserId");
-
break;
-
case "hot":
-
$ExtraId = $objSession->Get("GroupList");
-
break;
-
case "pop":
-
$ExtraId = $objSession->Get("GroupList");
-
break;
-
case "pick":
-
$ExtraId = $objSession->Get("GroupList");
-
break;
-
case "favorites":
-
$ExtraId = $objSession->Get("PortalUserId");
-
break;
-
case "new":
-
$ExtraId = $objSession->Get("GroupList");
-
break;
-
}
-
return $ExtraId;
-
}
-
-
function CacheListType($ListType)
-
{
-
if(!strlen($ListType))
-
$ListType="_";
-
switch($ListType)
-
{
-
case "_":
-
$ListTypeId = 0;
-
break;
-
case "category":
-
$ListTypeId = 1;
-
break;
-
case "myitems":
-
$ListTypeId = 2;
-
break;
-
case "hot":
-
$ListTypeId = 3;
-
break;
-
case "pop":
-
$ListTypeId = 4;
-
break;
-
case "pick":
-
$ListTypeId = 5;
-
break;
-
case "favorites":
-
$ListTypeId = 6;
-
break;
-
case "new":
-
$ListTypeId = 8;
-
break;
-
}
-
return $ListTypeId;
-
}
-
-
function PerformItemCount($attribs=array())
-
{
-
global $objCountCache, $objSession;
-
-
$ret = "";
-
$ListType = $attribs["_listtype"];
-
if(!strlen($ListType))
-
$ListType="_";
-
-
$ListTypeId = $this->CacheListType($ListType);
-
//echo "ListType: $ListType ($ListTypeId)
\n";
-
$ExtraId = $this->CacheListExtraId($ListType);
-
switch($ListType)
-
{
-
case "_":
-
$ret = $this->DoGlobalCount($attribs);
-
break;
-
case "category":
-
$ret = $this->CategoryCount($attribs);
-
break;
-
case "myitems":
-
$sql = $this->SqlMyItems($attribs);
-
break;
-
case "hot":
-
$sql = $this->SqlHotItems($attribs);
-
break;
-
case "pop":
-
$sql = $this->SqlPopItems($attribs);
-
break;
-
case "pick":
-
$sql = $this->SqlPickItems($attribs);
-
break;
-
case "favorites":
-
$sql = $this->SqlFavorites($attribs);
-
break;
-
case "search":
-
$sql = $this->SqlSearchItems($attribs);
-
break;
-
case "new":
-
$sql = $this->SqlNewItems($attribs);
-
break;
-
}
-
//echo "SQL: $sql
";
-
if(strlen($sql))
-
{
-
if(is_numeric($ListTypeId))
-
{
-
$cc = $objCountCache->GetValue($ListTypeId,$this->ItemType,$ExtraId,(int)$attribs["_today"], 3600);
-
-
if(!is_numeric($cc) || $attribs['_nocache'] == 1)
-
{
-
$ret = QueryCount($sql);
-
$objCountCache->SetValue($ListTypeId,$this->ItemType,$ExtraId,(int)$attribs["_today"],$ret);
-
}
-
else
-
$ret = $cc;
-
}
-
else
-
$ret = QueryCount($sql);
-
}
-
-
return $ret;
-
}
-
-
function GetJoinedSQL($PermName, $CatId=NULL, $AdditionalWhere="")
-
{
-
global $objSession, $objPermissions;
-
-
$ltable = $this->SourceTable;
-
$acl = $objSession->GetACLClause();
-
$cattable = GetTablePrefix()."CategoryItems";
-
$CategoryTable = GetTablePrefix()."Category";
-
$ptable = GetTablePrefix()."PermCache";
-
$VIEW = $objPermissions->GetPermId($PermName);
-
$sql ="INNER JOIN $cattable ON ($cattable.ItemResourceId=$ltable.ResourceId) ";
-
$sql .="INNER JOIN $CategoryTable ON ($CategoryTable.CategoryId=$cattable.CategoryId) ";
-
$sql .= "INNER JOIN $ptable ON ($cattable.CategoryId=$ptable.CategoryId) ";
-
$sql .="WHERE ($acl AND PermId=$VIEW AND PrimaryCat=1 AND $CategoryTable.Status=1) ";
-
-
if(is_numeric($CatId))
-
{
-
$sql .= " AND ($CategoryTable.CategoryId=$CatId) ";
-
}
-
if(strlen($AdditionalWhere)>0)
-
{
-
$sql .= "AND (".$AdditionalWhere.")";
-
}
-
return $sql;
-
}
-
-
function CountFavorites($attribs)
-
{
-
if($attribs["_today"])
-
{
-
global $objSession, $objConfig, $objPermissions;
-
-
$acl = $objSession->GetACLClause();
-
$favtable = GetTablePrefix()."Favorites";
-
$ltable = $this->SourceTable;
-
$cattable = GetTablePrefix()."CategoryItems";
-
$CategoryTable = GetTablePrefix()."Category";
-
$ptable = GetTablePrefix()."PermCache";
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
-
$where = "PortalUserId=".$objSession->Get("PortalUserId")." AND $ltable.Status=1";
-
$where .= " AND $favtable.Modified >= $today AND ItemTypeId=".$this->ItemType;
-
$p = $this->BasePermission.".VIEW";
-
-
$sql = "SELECT $ltable.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $favtable INNER JOIN $ltable ON ($favtable.ResourceId=$ltable.ResourceId) ";
-
$sql .= $this->GetJoinedSQL($p,NULL,$where);
-
$ret = QueryCount($sql);
-
}
-
else
-
{
-
if (!$this->ListType == "favorites")
-
{
-
$this->ListType = "favorites";
-
$this->LoadFavorites($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
}
-
return $ret;
-
}
-
-
-
-
function CountPickItems($attribs)
-
{
-
if (!$this->ListType == "pick")
-
{
-
$this->ListType = "pick";
-
$this->LoadPickItems($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
-
return $ret;
-
}
-
-
function CountMyItems($attribs)
-
{
-
if (!$this->ListType == "myitems")
-
{
-
$this->ListType = "myitems";
-
$this->LoadMyItems($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
-
return $ret;
-
}
-
-
function CountHotItems($attribs)
-
{
-
if (!$this->ListType == "hotitems")
-
{
-
$this->ListType = "hotitems";
-
$this->LoadHotItems($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
-
return $ret;
-
}
-
-
function CountNewItems($attribs)
-
{
-
if (!$this->ListType == "newitems")
-
{
-
$this->ListType = "newitems";
-
$this->LoadNewItems($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
-
return $ret;
-
}
-
-
function CountPopItems($attribs)
-
{
-
if (!$this->ListType == "popitems")
-
{
-
$this->ListType = "popitems";
-
$this->LoadPopItems($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
-
return $ret;
-
}
-
-
-
function CountSearchItems($attribs)
-
{
-
if (!$this->ListType == "search")
-
{
-
$this->ListType = "search";
-
$this->LoadSearchItems($attribs);
-
$ret = $this->QueryItemCount;
-
}
-
else
-
$ret = $this->QueryItemCount;
-
-
return $ret;
-
}
-
-
function SqlFavorites($attribs)
-
{
-
global $objSession, $objConfig, $objPermissions;
-
-
$acl = $objSession->GetACLClause();
-
$favtable = GetTablePrefix()."Favorites";
-
$ltable = $this->SourceTable;
-
$cattable = GetTablePrefix()."CategoryItems";
-
$CategoryTable = GetTablePrefix()."Category";
-
$ptable = GetTablePrefix()."PermCache";
-
-
$where = "PortalUserId=".$objSession->Get("PortalUserId")." AND $ltable.Status=1";
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$where .= " AND $favtable.Modified >= $today AND ItemTypeId=".$this->ItemType;
-
}
-
$p = $this->BasePermission.".VIEW";
-
-
$sql = "SELECT $ltable.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $favtable INNER JOIN $ltable ON ($favtable.ResourceId=$ltable.ResourceId) ";
-
$sql .= $this->GetJoinedSQL($p,NULL,$where);
-
-
-
$OrderBy = $this->QueryOrderByClause(TRUE,TRUE,TRUE);
-
$sql .= " ".$OrderBy;
-
return $sql;
-
}
-
-
function LoadFavorites($attribs)
-
{
-
global $objSession, $objCountCache;
-
-
$sql = $this->SqlFavorites($attribs);
-
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($sql,ENT_NOQUOTES)."
\n";
-
if($attribs["_shortlist"])
-
{
-
$this->PerPageVar = $this->PerPageShortVar;
-
}
-
else
-
$this->PerPageVar = $this->PerPageVarLong;
-
-
$CachedCount = $objCountCache->GetValue($this->CacheListType("favorites"),$this->ItemType,$this->CacheListExtraId("favorites"),(int)$attribs["_today"],3600);
-
if(!is_numeric($CachedCount))
-
{
-
$this->QueryItemCount = QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("favorites"),$this->ItemType,$this->CacheListExtraId("favorites"),(int)$attribs["_today"],$this->QueryItemCount);
-
}
-
else
-
$this->QueryItemCount = (int)$CachedCount;
-
-
return $this->Query_Item($sql);
-
}
-
-
function SqlPickItems($attribs)
-
{
-
global $objSession, $objCatList;
-
-
$catid = (int)$attribs["_catid"];
-
$scope = (int)$attribs["_scope"];
-
//$JoinCats = (int)$attribs["_catinfo"] || $scope;
-
-
$TableName = $this->SourceTable;
-
if($scope)
-
{
-
if (!$catid)
-
{
-
$catid = $objCatList->CurrentCategoryID();
-
}
-
$where = "CategoryId =".$catid." AND ".$TableName.".EditorsPick=1 AND ".$TableName.".Status=1";
-
}
-
else
-
{
-
$where = $TableName.".EditorsPick=1 AND ".$TableName.".Status=1 ";
-
$catid=NULL;
-
}
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$where .= " AND ($TableName.CreatedOn>=$today)";
-
}
-
$CategoryTable = GetTablePrefix()."Category";
-
$sql = "SELECT $TableName.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $TableName ";
-
$p = $this->BasePermission.".VIEW";
-
$sql .= $this->GetJoinedSQL($p,$CatUd,$where);
-
-
$OrderBy = $this->QueryOrderByClause(TRUE,TRUE,TRUE);
-
$sql .= " ".$OrderBy;
-
return $sql;
-
}
-
-
function LoadPickItems($attribs)
-
{
-
global $objSession, $objCountCache;
-
-
$sql = $this->SqlPickItems($attribs);
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($sql,ENT_NOQUOTES)."
\n";
-
-
if($attribs["_shortlist"])
-
{
-
$this->PerPageVar = $this->PerPageShortVar;
-
}
-
else
-
$this->PerPageVar = $this->PerPageVarLong;
-
-
$CachedCount = $objCountCache->GetValue($this->CacheListType("pick"),$this->ItemType,$this->CacheListExtraId("pick"),(int)$attribs["_today"],3600);
-
if(!is_numeric($CachedCount))
-
{
-
$this->QueryItemCount= QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("pick"),$this->ItemType,$this->CacheListExtraId("pick"),(int)$attribs["_today"],$this->QueryItemCount);
-
}
-
else
-
$this->QueryItemCount=$CachedCount;
-
-
return $this->Query_Item($sql);
-
}
-
-
function SqlMyItems($attribs= array())
-
{
-
global $objSession;
-
-
$TableName = $this->SourceTable;
-
$where = " ".$TableName.".Status>-1 AND ".$TableName.".CreatedById=".$objSession->Get("PortalUserId");
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$where .= " AND ($TableName.CreatedOn>=$today)";
-
}
-
$CategoryTable = GetTablePrefix()."Category";
-
$sql = "SELECT $TableName.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $TableName ";
-
$p = $this->BasePermission.".VIEW";
-
$sql .= $this->GetJoinedSQL($p,$CatUd,$where);
-
-
$OrderBy = $this->QueryOrderByClause(TRUE,TRUE,TRUE);
-
$sql .= " ".$OrderBy;
-
-
return $sql;
-
}
-
-
function LoadMyItems($attribs=array())
-
{
-
global $objSession,$objCountCache;
-
$sql = $this->SqlMyItems($attribs);
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($sql,ENT_NOQUOTES)."
\n";
-
if($attribs["_shortlist"])
-
{
-
$this->PerPageVar = $this->PerPageShortVar;
-
}
-
else
-
$this->PerPageVar = $this->PerPageVarLong;
-
-
$CachedCount = $objCountCache->GetValue($this->CacheListType("myitems"),$this->ItemType,$this->CacheListExtraId("myitems"),(int)$attribs["_today"],3600);
-
if(!is_numeric($CachedCount))
-
{
-
$this->QueryItemCount= QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("myitems"),$this->ItemType,$this->CacheListExtraId("myitems"),(int)$attribs["_today"],$this->QueryItemCount);
-
}
-
else
-
$this->QueryItemCount=$CachedCount;
-
-
return $this->Query_Item($sql);
-
}
-
-
function SqlNewItems($attribs = array())
-
{
-
global $objSession, $objCatList;
-
-
$catid = (int)$attribs["_catid"];
-
$scope = (int)$attribs["_scope"];
-
//$JoinCats = (int)$attribs["_catinfo"] || $scope;
-
-
$TableName = $this->SourceTable;
-
if($attribs["_today"])
-
{
-
$cutoff = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
}
-
else
-
{
-
if($scope)
-
{
-
if (!$catid)
-
{
-
$catid = $objCatList->CurrentCategoryID();
-
}
-
$cutoff = $this->GetNewValue($catid);
-
}
-
else
-
$cutoff = $this->GetNewValue();
-
}
-
if($scope)
-
{
-
if (!$catid)
-
{
-
$catid = $objCatList->CurrentCategoryID();
-
}
-
-
$where = "CategoryId =".$catid." AND ((".$TableName.".CreatedOn >=".$cutoff." AND ".$TableName.".NewItem != 0) OR ".$TableName.".NewItem=1 ) AND ".$TableName.".Status=1 ";
-
}
-
else
-
{
-
$where = "((".$TableName.".CreatedOn >=".$this->GetNewValue()." AND ".$TableName.".NewItem != 0) OR ".$TableName.".NewItem=1 ) AND ".$TableName.".Status=1 ";
-
}
-
-
$CategoryTable = GetTablePrefix()."Category";
-
$sql = "SELECT $TableName.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $TableName ";
-
$p = $this->BasePermission.".VIEW";
-
$sql .= $this->GetJoinedSQL($p,$CatUd,$where);
-
-
$OrderBy = $this->QueryOrderByClause(TRUE,TRUE,TRUE);
-
$sql .= " ".$OrderBy;
-
return $sql;
-
}
-
-
function LoadNewItems($attribs)
-
{
-
global $objSession,$objCountCache;
-
-
$sql = $this->SqlNewItems($attribs);
-
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($sql,ENT_NOQUOTES)."
\n";
-
if($attribs["_shortlist"])
-
{
-
$this->PerPageVar = $this->PerPageShortVar;
-
}
-
else
-
$this->PerPageVar = $this->PerPageVarLong;
-
-
$CachedCount = $objCountCache->GetValue($this->CacheListType("new"),$this->ItemType,$this->CacheListExtraId("new"),(int)$attribs["_today"],3600);
-
if(!is_numeric($CachedCount))
-
{
-
$this->QueryItemCount= QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("new"),$this->ItemType,$this->CacheListExtraId("new"),(int)$attribs["_today"],$this->QueryItemCount);
-
}
-
else
-
$this->QueryItemCount=$CachedCount;
-
-
-
return $this->Query_Item($sql);
-
}
-
-
function SqlPopItems($attribs)
-
{
-
global $objSession, $objCatList;
-
-
$catid = (int)$attribs["_catid"];
-
$scope = (int)$attribs["_scope"];
-
//$JoinCats = (int)$attribs["_catinfo"] || $scope;
-
-
$TableName = $this->SourceTable;
-
-
if($scope)
-
{
-
if (!$catid)
-
{
-
$catid = $objCatList->CurrentCategoryID();
-
}
-
$where = "CategoryId =".$catid." AND ((".$TableName.".Hits >=".$this->GetLinkPopValue()." AND ".$TableName.".PopItem !=0) OR ".$TableName.".PopItem=1) AND ".$TableName.".Status=1";
-
}
-
else
-
{
-
$where = "((".$TableName.".CachedRating >=".$this->GetPopValue()." AND ".$TableName.".PopItem !=0 ) OR ".$TableName.".PopItem=1) AND ".$TableName.".Status=1 ";
-
-
$where = "((".$TableName.".Hits >=".$this->GetPopValue()." AND ".$TableName.".PopItem !=0) OR ".$TableName.".PopItem=1) AND ".$TableName.".Status=1 ";
-
}
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$where .= " AND ($TableName.CreatedOn>=$today)";
-
}
-
$CategoryTable = GetTablePrefix()."Category";
-
$sql = "SELECT $TableName.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $TableName ";
-
$p = $this->BasePermission.".VIEW";
-
$sql .= $this->GetJoinedSQL($p,$catid,$where);
-
-
$OrderBy = $this->QueryOrderByClause(TRUE,TRUE,TRUE);
-
$sql .= " ".$OrderBy;
-
-
return $sql;
-
}
-
-
function LoadPopItems($attribs)
-
{
-
global $objSession,$objCountCache;
-
$sql = $this->SqlPopItems($attribs);
-
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($sql,ENT_NOQUOTES)."
\n";
-
if($attribs["_shortlist"])
-
{
-
$this->PerPageVar = $this->PerPageShortVar;
-
}
-
else
-
$this->PerPageVar = $this->PerPageVarLong;
-
-
$CachedCount = $objCountCache->GetValue($this->CacheListType("pop"),$this->ItemType,$this->CacheListExtraId("pop"),(int)$attribs["_today"],3600);
-
if(!is_numeric($CachedCount))
-
{
-
$this->QueryItemCount= QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("pop"),$this->ItemType,$this->CacheListExtraId("pop"),(int)$attribs["_today"],$this->QueryItemCount);
-
}
-
else
-
$this->QueryItemCount=$CachedCount;
-
-
return $this->Query_Item($sql);
-
}
-
-
function SqlHotItems($attribs)
-
{
-
global $objSession, $objCatList;
-
-
$catid = (int)$attribs["_catid"];
-
$scope = (int)$attribs["_scope"];
-
-
// $JoinCats = (int)$attribs["_catinfo"] || $scope;
-
-
$TableName = $this->SourceTable;
-
-
$OrderBy = $TableName.".CachedRating DESC";
-
-
if($scope)
-
{
-
if (!$catid)
-
{
-
$catid = $objCatList->CurrentCategoryID();
-
}
-
$where = "CategoryId =".$catid." AND ((".$TableName.".CachedRating >=".$this->GetHotValue()." AND ".$TableName.".PopItem !=0) OR ".$TableName.".PopItem=1) AND ".$TableName.".Status=1";
-
}
-
else
-
{
-
$where = "((".$TableName.".CachedRating >=".$this->GetPopValue()." AND ".$TableName.".PopItem !=0 ) OR ".$TableName.".PopItem=1) AND ".$TableName.".Status=1 ";
-
}
-
-
if($attribs["_today"])
-
{
-
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
-
$where .= " AND ($TableName.CreatedOn>=$today)";
-
}
-
$CategoryTable = GetTablePrefix()."Category";
-
$sql = "SELECT $TableName.*,$CategoryTable.CategoryId,$CategoryTable.CachedNavBar FROM $TableName ";
-
$p = $this->BasePermission.".VIEW";
-
$CatId = !$scope? NULL : $catid;
-
$sql .= $this->GetJoinedSQL($p,$CatId,$where);
-
-
if(strlen($OrderBy))
-
$sql .= " ORDER BY $OrderBy ";
-
-
return $sql;
-
}
-
-
function LoadHotItems($attribs)
-
{
-
global $objSession,$objCountCache;
-
-
$sql = $this->SqlHotItems($attribs);
-
if($objSession->HasSystemPermission("DEBUG.LIST"))
-
echo htmlentities($sql,ENT_NOQUOTES)."
\n";
-
-
if($attribs["_shortlist"])
-
{
-
$this->PerPageVar = $this->PerPageShortVar;
-
}
-
else
-
$this->PerPageVar = $this->PerPageVarLong;
-
-
$CachedCount = $objCountCache->GetValue($this->CacheListType("hot"),$this->ItemType,$this->CacheListExtraId("hot"),(int)$attribs["_today"], 0);
-
if(!is_numeric($CachedCount))
-
{
-
$this->QueryItemCount= QueryCount($sql);
-
$objCountCache->SetValue($this->CacheListType("hot"),$this->ItemType,$this->CacheListExtraId("hot"),(int)$attribs["_today"],$this->QueryItemCount);
-
}
-
else
-
$this->QueryItemCount=$CachedCount;
-
-
return $this->Query_Item($sql);
-
}
-
-
function SqlSearchItems($attribs = array())
-
{
-
global $objConfig, $objItemTypes, $objSession, $objPermissions, $CountVal;
-
-
$acl = $objSession->GetACLClause();
-
$this->Clear();
-
//$stable = "ses_".$objSession->GetSessionKey()."_Search";
-
$stable = $objSession->GetSearchTable();
-
$ltable = $this->SourceTable;
-
$catitems = GetTablePrefix()."CategoryItems";
-
$cattable = GetTablePrefix()."Category";
-
$ptable = GetTablePrefix()."PermCache";
-
$p = $this->BasePermission.".VIEW";
-
$i = new $this->classname();
-
-
$sql = "SELECT $cattable.CategoryId,$cattable.CachedNavbar,$ltable.*, Relevance FROM $stable ";
-
$sql .= "INNER JOIN $ltable ON ($stable.ItemId=$ltable.".$i->id_field.") ";
-
-
$where = "ItemType=".$this->ItemType." AND $ltable.Status=1";
-
-
$sql .= $this->GetJoinedSQL($p,NULL,$where);
-
$sql .= " ORDER BY EdPick DESC,Relevance DESC ";
-
-
$tmp = $this->QueryOrderByClause(FALSE,TRUE,TRUE);
-
$tmp = substr($tmp,9);
-
if(strlen($tmp))
-
{
-
$sql .= ", ".$tmp." ";
-
}
-
return $sql;
-
}
-
-
function LoadSearchItems($attribs = array())
-
{
-
global $CountVal, $objSession;
-
//echo "Loading ".get_class($this)." Search Items
";
-
$sql = $this->SqlSearchItems($attribs);
-
//echo "$sql
";
-
$this->Query_Item($sql);
-
$Keywords = GetKeywords($objSession->GetVariable("Search_Keywords"));
-
//echo "SQL Loaded ItemCount (".get_class($this).'): '.$this->NumItems().'
';
-
for($i = 0; $i < $this->NumItems(); $i++)
-
{
-
$this->Items[$i]->Keywords = $Keywords;
-
}
-
if(is_numeric($CountVal[$this->ItemType]))
-
{
-
$this->QueryItemCount = $CountVal[$this->ItemType];
-
//echo "CACHE: "; print_r($CountVal); echo "
";
-
}
-
else
-
{
-
$this->QueryItemCount = QueryCount($sql);
-
//echo "SQL: ".$sql."
";
-
$CountVal[$this->ItemType] = $this->QueryItemCount;
-
}
-
-
}
-
-
function PasteFromClipboard($TargetCat,$NameField="")
-
{
-
global $objSession,$objCatList;
-
-
$clip = $objSession->GetVariable("ClipBoard");
-
if(strlen($clip))
-
{
-
$ClipBoard = ParseClipboard($clip);
-
$IsCopy = (substr($ClipBoard["command"],0,4)=="COPY") || ($ClipBoard["source"] == $TargetCat);
-
-
$item_ids = explode(",",$ClipBoard["ids"]);
-
for($i=0;$iGetItem($item_ids[$i]);
-
if(!$IsCopy) // paste to other category then current
-
{
-
$item->MoveToCategory($ClipBoard["source"],$TargetCat);
-
$clip = str_replace("CUT","COPY",$clip);
-
$objSession->SetVariable("ClipBoard",$clip);
-
}
-
else
-
{
-
$item->CopyToNewResource($TargetCat,$NameField); // create item copy, but with new ResourceId
-
$item->AddToCategory($TargetCat);
-
UpdateCategoryCount($item->type,$TargetCat);
-
-
}
-
}
-
}
-
}
-
-
function AdminPrintItems($template)
-
{
-
// prints item listing for admin (browse/advanced view) tabs
-
$o = '';
-
-
$i = 1;
-
-
$topleft = 0;
-
$topright = 0;
-
$rightcount = 0;
-
$total_items = $this->NumItems();
-
$topleft = ceil($total_items / 2);
-
$topright = $total_items - $topleft;
-
-
for($x = 0; $x < $topleft; $x++)
-
{
-
//printingleft
-
$item = $this->Items[$x];
-
if ($i > 2)
-
{
-
$o .= "
\n";
-
$i = 1;
-
}
-
$o .= $item->AdminParseTemplate($template);
-
$i++;
-
-
//printingright
-
if ($rightcount < $topright && ( ($x + $topleft) < $total_items) )
-
{
-
$item = $this->Items[ $x + $topleft ];
-
if ($i > 2)
-
{
-
$o.="
\n";
-
$i = 1;
-
}
-
$o .= $item->AdminParseTemplate($template);
-
$i++;
-
$rightcount++;
-
}
-
}
-
$o .= "\n
\n";
-
-
return $o;
-
}
-
-
}
-
-
// -------------- NEW CLASSES -----------------------
-
-
class DBList {
-
-
// table related attributes
-
var $db = null;
-
var $table_name = '';
-
var $LiveTable = '';
-
var $EditTable = '';
-
-
-
// record related attributes
-
var $records = Array();
-
var $record_count = 0;
-
var $cur_rec = -1; // "-1" means no records, or record index otherwise
-
-
// query related attributes
-
var $SelectSQL = "SELECT * FROM %s";
-
-
function DBList()
-
{
-
// use $this->SetTable('live', 'table name');
-
// in inherited constructors to set table for list
-
$this->db =&GetADODBConnection();
-
}
-
-
function SetTable($action, $table_name = null)
-
{
-
// $action = {'live', 'restore','edit'}
-
switch($action)
-
{
-
case 'live':
-
$this->LiveTable = $table_name;
-
$this->table_name = $this->LiveTable;
-
break;
-
case 'restore':
-
$this->table_name = $this->LiveTable;
-
break;
-
case 'edit':
-
global $objSession;
-
$this->table_name = $objSession->GetEditTable($this->LiveTable);
-
break;
-
}
-
}
-
-
function Clear()
-
{
-
// no use of this method at a time :)
-
$this->records = Array();
-
$this->record_count = 0;
-
$this->cur_rec = -1;
-
}
-
-
function Query()
-
{
-
// query list
-
$sql = sprintf($this->SelectSQL, $this->table_name);
-
echo "SQL: $sql
";
-
$rs =& $this->db->Execute($sql);
-
-
if( $this->db->ErrorNo() == 0 )
-
{
-
$this->records = $rs->GetRows();
-
$this->record_count = count($this->records);
-
//$this->cur_rec = $this->record_count ? 0 : -1;
-
}
-
else
-
return false;
-
}
-
-
function ProcessList($callback_method)
-
{
-
// process list using user-defined method called
-
// with one parameter - current record fields
-
// (associative array)
-
if($this->record_count > 0)
-
{
-
$this->cur_rec = 0;
-
while($this->cur_rec < $this->record_count)
-
{
-
if( method_exists($this, $callback_method) )
-
$this->$callback_method( $this->GetCurrent() );
-
$this->cur_rec++;
-
}
-
}
-
}
-
-
function &GetCurrent()
-
{
-
// return currently processed record (with change ability)
-
return ($this->cur_rec != -1) ? $this->records[$this->cur_rec] : false;
-
}
-
-
function GetDBField($field_name)
-
{
-
$rec =& $this->GetCurrent();
-
return is_array($rec) && isset($rec[$field_name]) ? $rec[$field_name] : false;
-
}
-
}
-
-
-
?>
\ No newline at end of file
![](\"img/s.gif\")