class Category
{
// Code chua run, code bang notepad de tam tham khao
var $Info;
function Parse()
{
$QueryStr = "SELECT * FROM " . CATEGORY_TABLE . " WHERE 1 ORDER BY position DESC";
$Result = @mysql_query ($QueryStr)
// or return ErrorHandler("MySQL", mysql_error());
//if (!$Result) return ErrorHandler($Context,$ErrMsg);
while ($Row = @mysql_fetch_assoc($Result))
$Cat[] = $Row;
$this->sortCat($Cat, 0, 1);
return 1;
}
function sortCat($CatArr, $Node, $Level)
{
for ($i=0, $i< Count($CatArr); $i++)
if ($CatArr[$i][parent] == $Node)
{
$CatArr[level] = $Level;
$this->Info[] = $CatArr[$i];
this->sortCat($CatArr, $CatArr[$i][id], $Level+1);
}
return 1;
}
// Ham nay anh tach ra tu bo core cua thang coder ben anh
// Chi de tham khao vi no lien quan den pattern cua he thong nua
function moveUp($CatID)
{
$QueryStr = "SELECT c1.id, c1.position,c1.parent,c2.id,c2.position,c2.parent
FROM " .TBL_CATEGORIES."c1,".TBL_CATEGORIES." c2
WHERE c1.position < c2.position
AND c2.id = $CatID
AND c1.parent = c2.parent
ORDER BY c1.position DESC";
if ($result = MySQL::Query($QueryStr))
{
if (@mysql_num_rows($result)!=0)
{
$row = @mysql_fetch_row($result);
$cat1 = array("position" =>$row[4]);
$cat2 = array("position" =>$row[1]);
return (Category::Update($cat1,"id=$row[0]"))
&&(Category::Update($cat2,"id=$row[3]"));
}
}
}
}