585 lines
17 KiB
PHP
585 lines
17 KiB
PHP
<?php
|
|
/***************************************************/
|
|
/* this class represents a category + its children */
|
|
/***************************************************/
|
|
|
|
/**
|
|
* Category class for handling categories.
|
|
*/
|
|
class Category {
|
|
var $iCatId;
|
|
var $iParentId;
|
|
var $sName;
|
|
var $sDescription;
|
|
var $aApplicationsIds; // an array that contains the appId of every application linked to this category
|
|
var $aSubcatsIds; // an array that contains the appId of every application linked to this category
|
|
|
|
|
|
/**
|
|
* constructor, fetches the data.
|
|
*/
|
|
function Category($iCatId = null)
|
|
{
|
|
// we are working on an existing category
|
|
if($iCatId=="0" || $iCatId)
|
|
{
|
|
/*
|
|
* We fetch the data related to this vendor.
|
|
*/
|
|
$sQuery = "SELECT *
|
|
FROM appCategory
|
|
WHERE catId = '?' ORDER BY catName;";
|
|
if($hResult = query_parameters($sQuery, $iCatId))
|
|
{
|
|
$oRow = query_fetch_object($hResult);
|
|
if($oRow)
|
|
{
|
|
$this->iCatId = $iCatId;
|
|
$this->iParentId = $oRow->catParent;
|
|
$this->sName = $oRow->catName;
|
|
$this->sDescription = $oRow->catDescription;
|
|
}
|
|
}
|
|
|
|
/*
|
|
* We fetch applicationsIds.
|
|
*/
|
|
$sQuery = "SELECT appId
|
|
FROM appFamily
|
|
WHERE catId = '?'
|
|
AND state = 'accepted' ORDER BY appName";
|
|
if($hResult = query_parameters($sQuery, $iCatId))
|
|
{
|
|
while($oRow = query_fetch_object($hResult))
|
|
{
|
|
$this->aApplicationsIds[] = $oRow->appId;
|
|
}
|
|
}
|
|
|
|
/*
|
|
* We fetch subcatIds.
|
|
*/
|
|
$sQuery = "SELECT catId
|
|
FROM appCategory
|
|
WHERE catParent = '?' ORDER BY catName;";
|
|
if($hResult = query_parameters($sQuery, $iCatId))
|
|
{
|
|
while($oRow = query_fetch_object($hResult))
|
|
{
|
|
$this->aSubcatsIds[] = $oRow->catId;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
/**
|
|
* Creates a new category.
|
|
*/
|
|
function create()
|
|
{
|
|
$hResult = query_parameters("INSERT INTO appCategory (catName, catDescription, catParent) ".
|
|
"VALUES('?', '?', '?')",
|
|
$this->sName, $this->sDescription, $this->iParentId);
|
|
if($hResult)
|
|
{
|
|
$this->iCatId = query_appdb_insert_id();
|
|
$this->category($this->iCatId);
|
|
return true;
|
|
}
|
|
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Update category.
|
|
* Returns true on success and false on failure.
|
|
*/
|
|
function update()
|
|
{
|
|
if(!query_parameters("UPDATE appCategory SET catName = '?', catDescription = '?', catParent = '?' WHERE catId = '?'",
|
|
$this->sName, $this->sDescription, $this->iParentId, $this->iCatId))
|
|
return false;
|
|
|
|
return true;
|
|
}
|
|
|
|
|
|
/**
|
|
* Deletes the category from the database.
|
|
*/
|
|
function delete()
|
|
{
|
|
if(!$this->canEdit())
|
|
return false;
|
|
|
|
if(sizeof($this->aApplicationsIds)>0)
|
|
return FALSE;
|
|
|
|
$sQuery = "DELETE FROM appCategory
|
|
WHERE catId = '?'
|
|
LIMIT 1";
|
|
query_parameters($sQuery, $this->iCatId);
|
|
|
|
return true;
|
|
}
|
|
|
|
function objectGetMailOptions($sAction, $bMailSubmitter, $bParentAction)
|
|
{
|
|
return new mailOptions();
|
|
}
|
|
|
|
function objectGetChildren()
|
|
{
|
|
/* We don't have any (or we do, sort of, but we don't use them for anything at the moment) */
|
|
return array();
|
|
}
|
|
|
|
/* Get a category's subcategory objects. Names are indented according
|
|
to subcategory level */
|
|
function getSubCatList($iLevel = 0)
|
|
{
|
|
$aOut = array();
|
|
$iId = $this->iCatId ? $this->iCatId : 0;
|
|
|
|
$sIndent = '';
|
|
for($i = 0; $i < $iLevel; $i++)
|
|
$sIndent .= ' ';
|
|
|
|
$hResult = query_parameters("SELECT * FROM appCategory WHERE catParent = '?'
|
|
ORDER BY catName", $iId);
|
|
|
|
while($oRow = mysql_fetch_object($hResult))
|
|
{
|
|
$oCat = new category($oRow->catId);
|
|
$oCat->sName = $sIndent.$oCat->sName;
|
|
$aOut[] = $oCat;
|
|
$aOut = array_merge($aOut, $oCat->getSubCatList($iLevel + 1));
|
|
}
|
|
return $aOut;
|
|
}
|
|
|
|
/* Get all category objects, ordered and with category names indented
|
|
according to subcategory level.
|
|
Optionally includes the 'Main' top category. */
|
|
static function getOrderedList($bIncludeMain = false)
|
|
{
|
|
$oCat = new category();
|
|
|
|
if(!$bIncludeMain)
|
|
return $oCat->getSubCatList(0);
|
|
|
|
$oCat->sName = 'Main';
|
|
$aCats = array($oCat);
|
|
$aCats = array_merge($aCats, $oCat->getSubCatList(1));
|
|
|
|
return $aCats;
|
|
}
|
|
|
|
/* Returns an SQL statement that will match items in the current category
|
|
and all sub-categories */
|
|
public function getSqlQueryPart()
|
|
{
|
|
$sRet = '';
|
|
$aSubCats = $this->getSubCatList();
|
|
$sRet .= " ( catId = '{$this->iCatId}' ";
|
|
foreach($aSubCats as $oCat)
|
|
{
|
|
$iCatId = $oCat->objectGetId();
|
|
$sRet .= " OR catId = '$iCatId' ";
|
|
}
|
|
$sRet .= ") ";
|
|
|
|
return $sRet;
|
|
}
|
|
|
|
function objectGetMail($sAction, $bMailSubmitter, $bParentAction)
|
|
{
|
|
/* We don't send notification mails */
|
|
return array(null, null, null);
|
|
}
|
|
|
|
/**
|
|
* returns a path like:
|
|
*
|
|
* { ROOT, Games, Simulation }
|
|
*/
|
|
function getCategoryPath()
|
|
{
|
|
$aPath = array();
|
|
$iCatId = $this->iCatId;
|
|
|
|
/* loop, working up through categories until we have no parent */
|
|
while($iCatId != 0)
|
|
{
|
|
$hResult = query_parameters("SELECT catName, catId, catParent FROM appCategory WHERE catId = '?'",
|
|
$iCatId);
|
|
if(!$hResult || query_num_rows($hResult) != 1)
|
|
break;
|
|
$oCatRow = query_fetch_object($hResult);
|
|
$aPath[] = array($oCatRow->catId, $oCatRow->catName);
|
|
$iCatId = $oCatRow->catParent;
|
|
}
|
|
$aPath[] = array(0, "ROOT");
|
|
return array_reverse($aPath);
|
|
}
|
|
|
|
/* return the total number of applications in this category */
|
|
function getApplicationCount($depth = null)
|
|
{
|
|
$MAX_DEPTH = 5;
|
|
|
|
if($depth)
|
|
$depth++;
|
|
else
|
|
$depth = 0;
|
|
|
|
/* if we've reached our max depth, just return 0 and stop recursing */
|
|
if($depth >= $MAX_DEPTH)
|
|
return 0;
|
|
|
|
$totalApps = 0;
|
|
|
|
/* add on all apps in each category this category includes */
|
|
if($this->aSubcatsIds)
|
|
{
|
|
while(list($i, $iSubcatId) = each($this->aSubcatsIds))
|
|
{
|
|
$subCat = new Category($iSubcatId);
|
|
$totalApps += $subCat->getApplicationCount($depth);
|
|
}
|
|
}
|
|
|
|
$totalApps += sizeof($this->aApplicationsIds); /* add on the apps at this category level */
|
|
|
|
return $totalApps;
|
|
}
|
|
|
|
/**
|
|
* create the Category: line at the top of appdb pages$
|
|
*/
|
|
function make_cat_path($aPath, $iAppId = '', $iVersionId = '', $iqSysId = '')
|
|
{
|
|
$sStr = "";
|
|
$iCatCount = 0;
|
|
while(list($iCatIdx, list($iCatId, $sName)) = each($aPath))
|
|
{
|
|
if($sName == "ROOT")
|
|
$sCatname = "Main";
|
|
else
|
|
$sCatname = $sName;
|
|
|
|
if ($iCatCount > 0) $sStr .= " > ";
|
|
$sStr .= html_ahref($sCatname,"objectManager.php?sClass=category&iId=$iCatId&sAction=view&sTitle=Browse+Applications");
|
|
$iCatCount++;
|
|
}
|
|
|
|
if($iAppId)
|
|
{
|
|
$oApp = new Application($iAppId);
|
|
if($iVersionId)
|
|
{
|
|
$oVersion = new Version($iVersionId);
|
|
$sStr .= " > ".$oApp->objectMakeLink();
|
|
$sStr .= " > ".$oVersion->sName;
|
|
} else
|
|
{
|
|
$sStr .= " > ".$oApp->sName;
|
|
}
|
|
}
|
|
|
|
// QEMU
|
|
|
|
if($iqSysId)
|
|
{
|
|
$oqSys = new qemuSystem($iqSysId);
|
|
$sStr .= " (".$oqSys->sDescription.")";
|
|
}
|
|
|
|
return $sStr;
|
|
}
|
|
|
|
public function objectGetState()
|
|
{
|
|
// We currenly don't queue categories
|
|
return 'accepted';
|
|
}
|
|
|
|
function objectGetId()
|
|
{
|
|
return $this->iCatId;
|
|
}
|
|
|
|
public function objectMakeLink()
|
|
{
|
|
return '<a href="'.$this->objectMakeUrl()."\">{$this->sName}</a>'";
|
|
}
|
|
|
|
public function objectMakeUrl()
|
|
{
|
|
return BASE."objectManager.php?sClass=category&sAction=view&iId={$this->iCatId}&sTitle=Browse+Applications";
|
|
}
|
|
|
|
public function objectAllowNullId($sAction)
|
|
{
|
|
switch($sAction)
|
|
{
|
|
case 'view':
|
|
return true;
|
|
|
|
default:
|
|
return false;
|
|
}
|
|
}
|
|
|
|
function objectGetSubmitterId()
|
|
{
|
|
/* We don't log that */
|
|
return 0;
|
|
}
|
|
|
|
function objectGetCustomVars($sAction)
|
|
{
|
|
switch($sAction)
|
|
{
|
|
case 'add':
|
|
return array('iParentId');
|
|
|
|
default:
|
|
return null;
|
|
}
|
|
}
|
|
|
|
function outputEditor($aValues = null)
|
|
{
|
|
$aCategories = category::getOrderedList(true);
|
|
$aCatNames = array();
|
|
$aCatIds = array();
|
|
|
|
$iParentId = $this->iParentId;
|
|
if(!$iParentId && $aValues)
|
|
$iParentId = getInput('iParentId', $aValues);
|
|
|
|
foreach($aCategories as $oCategory)
|
|
{
|
|
$aCatNames[] = $oCategory->sName;
|
|
$aCatIds[] = $oCategory->objectGetId();
|
|
}
|
|
|
|
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">
|
|
<tr>
|
|
<td width=\"15%\" class=\"box-label\"><b>Category name</b></td>
|
|
<td class=\"box-body\">
|
|
<input type=\"text\" size=\"50\" name=\"sName\" value=\"".$this->sName."\">
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"15%\" class=\"box-label\"><b>Description</b></td>
|
|
<td class=\"box-body\">
|
|
<input type=\"text\" size=\"50\" name=\"sDescription\" value=\"".$this->sDescription."\">
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td width=\"15%\" class=\"box-label\"><b>Parent</b></td>
|
|
<td class=\"box-body\">
|
|
".html_select("iParentId",$aCatIds,$iParentId, $aCatNames)."
|
|
</td>
|
|
</tr>
|
|
</table>";
|
|
}
|
|
|
|
function allowAnonymousSubmissions()
|
|
{
|
|
return FALSE;
|
|
}
|
|
|
|
function getOutputEditorValues($aClean)
|
|
{
|
|
$this->sName = $aClean['sName'];
|
|
$this->iParentId = $aClean['iParentId'];
|
|
$this->sDescription = $aClean['sDescription'];
|
|
}
|
|
|
|
function mustBeQueued()
|
|
{
|
|
return $_SESSION['current']->hasPriv('admin');
|
|
}
|
|
|
|
function canEdit()
|
|
{
|
|
return $_SESSION['current']->hasPriv('admin');
|
|
}
|
|
|
|
/**
|
|
* display the full path of the Category we are looking at
|
|
*/
|
|
function displayPath($appId, $versionId = '', $qsysId = '')
|
|
{
|
|
$sCatFullPath = Category::make_cat_path($this->getCategoryPath(), $appId, $versionId, $qsysId);
|
|
echo html_frame_start("",'98%','',2);
|
|
echo "<p><b>Category: ". $sCatFullPath ."</b><br>\n";
|
|
echo html_frame_end();
|
|
}
|
|
|
|
public function display()
|
|
{
|
|
// list sub categories
|
|
$sCatFullPath = Category::make_cat_path($this->getCategoryPath());
|
|
$aSubs = $this->aSubcatsIds;
|
|
|
|
echo "<div class='default_container'>\n";
|
|
|
|
// Allow editing categories
|
|
if($this->canEdit())
|
|
{
|
|
$oM = new objectManager('category', '', $this->iCatId);
|
|
$oM->setReturnTo($this->objectMakeUrl());
|
|
echo "<p>\n";
|
|
echo '<a href="'.$oM->makeUrl('add', null, 'Add Category')."&iParentId={$this->iCatId}\">Add</a>";;
|
|
if($this->iCatId) // We can't edit the 'Main' category
|
|
{
|
|
echo ' ';
|
|
echo '<a href="'.$oM->makeUrl('edit', $this->iCatId, 'Edit Category').'">Edit</a>';
|
|
echo ' ';
|
|
echo '<a href="'.$oM->makeUrl('delete', $this->iCatId, 'Delete Category').'">Delete</a>';
|
|
}
|
|
echo "</p>\n";
|
|
}
|
|
|
|
// Output sub-categories
|
|
if($aSubs)
|
|
{
|
|
echo html_frame_start("",'98%','',2);
|
|
echo "<p><b>Category: ". $sCatFullPath ."</b><br>\n";
|
|
echo html_frame_end();
|
|
|
|
echo html_frame_start("","98%","",0);
|
|
|
|
$oTable = new Table();
|
|
$oTable->SetWidth("100%");
|
|
$oTable->SetBorder(0);
|
|
$oTable->SetCellPadding(3);
|
|
$oTable->SetCellSpacing(1);
|
|
|
|
$oTableRow = new TableRow();
|
|
$oTableRow->SetClass("color4");
|
|
$oTableRow->AddTextCell("Sub Category");
|
|
$oTableRow->AddTextCell("Description");
|
|
$oTableRow->AddTextCell("No. Apps");
|
|
$oTable->SetHeader($oTableRow);
|
|
|
|
while(list($i,$iSubcatId) = each($aSubs))
|
|
{
|
|
$oSubCat= new Category($iSubcatId);
|
|
|
|
//set row color
|
|
$sColor = ($i % 2) ? "color0" : "color1";
|
|
|
|
$oTableRowHighlight = GetStandardRowHighlight($i);
|
|
|
|
$sUrl = $oSubCat->objectMakeUrl();
|
|
|
|
$oTableRowClick = new TableRowClick($sUrl);
|
|
$oTableRowClick->SetHighlight($oTableRowHighlight);
|
|
|
|
//get number of apps in this sub-category
|
|
$iAppcount = $oSubCat->getApplicationCount();
|
|
|
|
//format desc
|
|
$sDesc = substr(stripslashes($oSubCat->sDescription),0,70);
|
|
|
|
//display row
|
|
$oTableRow = new TableRow();
|
|
$oTableRow->SetClass($sColor);
|
|
$oTableRow->SetRowClick($oTableRowClick);
|
|
|
|
$oTableCell = new TableCell($oSubCat->sName);
|
|
$oTableCell->SetCellLink($sUrl);
|
|
$oTableRow->AddCell($oTableCell);
|
|
$oTableRow->AddTextCell("$sDesc ");
|
|
$oTableRow->AddTextCell("$iAppcount ");
|
|
|
|
$oTable->AddRow($oTableRow);
|
|
}
|
|
|
|
// output the table
|
|
echo $oTable->GetString();
|
|
|
|
echo html_frame_end( count($aSubs) . ' categories');
|
|
}
|
|
|
|
|
|
// list applications in this category
|
|
$aApps = $this->aApplicationsIds;
|
|
if($aApps)
|
|
{
|
|
echo html_frame_start("",'98%','',2);
|
|
echo "<p><b>Category: ". $sCatFullPath ."</b><br>\n";
|
|
echo html_frame_end();
|
|
|
|
echo html_frame_start("","98%","",0);
|
|
|
|
$oTable = new Table();
|
|
$oTable->SetWidth("100%");
|
|
$oTable->SetBorder(0);
|
|
$oTable->SetCellPadding(3);
|
|
$oTable->SetCellSpacing(1);
|
|
|
|
$oTableRow = new TableRow();
|
|
$oTableRow->SetClass("color4");
|
|
$oTableRow->AddTextCell("Application name");
|
|
$oTableRow->AddTextCell("Description");
|
|
$oTableRow->AddTextCell("No. Versions");
|
|
|
|
$oTable->SetHeader($oTableRow);
|
|
|
|
while(list($i, $iAppId) = each($aApps))
|
|
{
|
|
$oApp = new Application($iAppId);
|
|
|
|
//set row color
|
|
$sColor = ($i % 2) ? "color0" : "color1";
|
|
|
|
$oTableRowHighlight = GetStandardRowHighlight($i);
|
|
|
|
$sUrl = $oApp->objectMakeUrl();
|
|
|
|
$oTableRowClick = new TableRowClick($sUrl);
|
|
$oTableRowClick->SetHighlight($oTableRowHighlight);
|
|
|
|
//format desc
|
|
$sDesc = util_trim_description($oApp->sDescription);
|
|
|
|
//display row
|
|
$oTableRow = new TableRow();
|
|
$oTableRow->SetRowClick($oTableRowClick);
|
|
$oTableRow->SetClass($sColor);
|
|
$oTableRow->AddTextCell($oApp->objectMakeLink());
|
|
$oTableRow->AddTextCell("$sDesc ");
|
|
$oTableRow->AddTextCell(sizeof($oApp->aVersionsIds));
|
|
|
|
$oTable->AddRow($oTableRow);
|
|
}
|
|
|
|
// output table
|
|
echo $oTable->GetString();
|
|
|
|
echo html_frame_end( count($aApps) . " applications in this category");
|
|
}
|
|
|
|
// Show a message if this category is empty
|
|
if(!$aApps && !$aSubs)
|
|
{
|
|
echo html_frame_start("",'98%','',2);
|
|
echo "<p><b>Category: ". $sCatFullPath ."</b><br>\n";
|
|
echo html_frame_end();
|
|
|
|
echo html_frame_start('','90%','',2);
|
|
echo 'This category has no sub-categories or applications';
|
|
echo html_frame_end();
|
|
}
|
|
}
|
|
}
|
|
|
|
?>
|