/**
* \brief Given a Folder_pk, list every upload in the folder.
*/
function ShowFolder($Folder, $Show)
{
global $Plugins;
global $PG_CONN;
$V = "";
/* Get list of uploads in this folder */
$sql = "SELECT * FROM upload\n INNER JOIN uploadtree ON upload_fk = upload_pk\n AND upload.pfile_fk = uploadtree.pfile_fk\n AND parent IS NULL\n AND lft IS NOT NULL \n WHERE upload_pk IN\n (SELECT child_id FROM foldercontents WHERE foldercontents_mode & 2 != 0 AND parent_fk = {$Folder})\n ORDER BY upload_filename,upload_desc,upload_pk,upload_origin;";
$result = pg_query($PG_CONN, $sql);
DBCheckResult($result, $sql, __FILE__, __LINE__);
$Uri = Traceback_uri() . "?mod=" . $this->Name;
$V .= "<table border=1 width='100%'>";
$V .= "<tr><td valign='top' width='20%'>\n";
$V .= FolderListScript();
$text = _("Folder Navigation");
$V .= "<center><H3>{$text}</H3></center>\n";
$V .= "<center><small>";
if ($Folder != GetUserRootFolder()) {
$text = _("Top");
$V .= "<a href='" . Traceback_uri() . "?mod=" . $this->Name . "'>{$text}</a> |";
}
$text = _("Expand");
$V .= "<a href='javascript:Expand();'>{$text}</a> |";
$text = _("Collapse");
$V .= "<a href='javascript:Collapse();'>{$text}</a> |";
$text = _("Refresh");
$V .= "<a href='" . Traceback() . "'>{$text}</a>";
$V .= "</small></center>";
$V .= "<P>\n";
$V .= "<form>\n";
$V .= FolderListDiv($Folder, 0, $Folder, 1);
$V .= "</form>\n";
$V .= "</td><td valign='top'>\n";
$text = _("Uploads");
$V .= "<center><H3>{$text}</H3></center>\n";
$V .= "<table class='text' id='browsetbl' border=0 width='100%' cellpadding=0>\n";
$text = _("Upload Name and Description");
$text1 = _("Upload Date");
$V .= "<th>{$text}</th><th>{$text1}</th></tr>\n";
/* Browse-Pfile menu */
$MenuPfile = menu_find("Browse-Pfile", $MenuDepth);
/* Browse-Pfile menu without the compare menu item */
$MenuPfileNoCompare = menu_remove($MenuPfile, "Compare");
while ($Row = pg_fetch_assoc($result)) {
if (empty($Row['upload_pk'])) {
continue;
}
$Desc = htmlentities($Row['upload_desc']);
$UploadPk = $Row['upload_pk'];
/* check permission on upload */
$UploadPerm = GetUploadPerm($UploadPk);
if ($UploadPerm < PERM_READ) {
continue;
}
$Name = $Row['ufile_name'];
if (empty($Name)) {
$Name = $Row['upload_filename'];
}
/* If UploadtreePk is not an artifact, then use it as the root.
Else get the first non artifact under it.
*/
if (Isartifact($Row['ufile_mode'])) {
$UploadtreePk = DirGetNonArtifact($Row['uploadtree_pk'], $uploadtree_tablename);
} else {
$UploadtreePk = $Row['uploadtree_pk'];
}
$V .= "<tr><td>";
if (IsContainer($Row['ufile_mode'])) {
$V .= "<a href='{$Uri}&upload={$UploadPk}&folder={$Folder}&item={$UploadtreePk}&show={$Show}'>";
$V .= "<b>" . $Name . "</b>";
$V .= "</a>";
} else {
$V .= "<b>" . $Name . "</b>";
}
$V .= "<br>";
if (!empty($Desc)) {
$V .= "<i>" . $Desc . "</i><br>";
}
$Upload = $Row['upload_pk'];
$Parm = "upload={$Upload}&show={$Show}&item=" . $Row['uploadtree_pk'];
if (Iscontainer($Row['ufile_mode'])) {
$V .= menu_to_1list($MenuPfile, $Parm, " ", " ", 1, $UploadPk);
} else {
$V .= menu_to_1list($MenuPfileNoCompare, $Parm, " ", " ", 1, $UploadPk);
}
/* Job queue link */
$text = _("History");
if (plugin_find_id('showjobs') >= 0) {
$V .= "<a href='" . Traceback_uri() . "?mod=showjobs&upload={$UploadPk}'>[{$text}]</a>";
$V .= "</td>\n";
$V .= "<td align='right'>" . substr($Row['upload_ts'], 0, 19) . "</td>";
}
$V .= "<tr><td colspan=2> </td></tr>\n";
}
pg_free_result($result);
$V .= "</table>\n";
$V .= "</td></tr>\n";
$V .= "</table>\n";
return $V;
}
/**
* \brief Given a upload_pk, list every item in it.
* If it is an individual file, then list the file contents.
*/
function ShowItem($Upload, $Item, $Show, $Folder, $uploadtree_tablename)
{
global $container;
/** @var DbManager */
$dbManager = $container->get('db.manager');
$RowStyle1 = "style='background-color:#ecfaff'";
// pale blue
$RowStyle2 = "style='background-color:#ffffe3'";
// pale yellow
$ColorSpanRows = 3;
// Alternate background color every $ColorSpanRows
$RowNum = 0;
$V = "";
/* Use plugin "view" and "download" if they exist. */
$Uri = Traceback_uri() . "?mod=" . $this->Name . "&folder={$Folder}";
/* there are three types of Browse-Pfile menus */
/* menu as defined by their plugins */
$MenuPfile = menu_find("Browse-Pfile", $MenuDepth);
/* menu but without Compare */
$MenuPfileNoCompare = menu_remove($MenuPfile, "Compare");
/* menu with only Tag and Compare */
$MenuTag = array();
foreach ($MenuPfile as $value) {
if ($value->Name == 'Tag' or $value->Name == 'Compare') {
$MenuTag[] = $value;
}
}
$Results = GetNonArtifactChildren($Item, $uploadtree_tablename);
$ShowSomething = 0;
$V .= "<table class='text' style='border-collapse: collapse' border=0 padding=0>\n";
$stmtGetFirstChild = __METHOD__ . '.getFirstChild';
$dbManager->prepare($stmtGetFirstChild, "SELECT uploadtree_pk FROM {$uploadtree_tablename} WHERE parent=\$1 limit 1");
foreach ($Results as $Row) {
if (empty($Row['uploadtree_pk'])) {
continue;
}
$ShowSomething = 1;
$Name = $Row['ufile_name'];
/* Set alternating row background color - repeats every $ColorSpanRows rows */
$RowStyle = $RowNum++ % (2 * $ColorSpanRows) < $ColorSpanRows ? $RowStyle1 : $RowStyle2;
$V .= "<tr {$RowStyle}>";
/* Check for children so we know if the file should by hyperlinked */
$result = $dbManager->execute($stmtGetFirstChild, array($Row['uploadtree_pk']));
$HasChildren = $dbManager->fetchArray($result);
$dbManager->freeResult($result);
$Parm = "upload={$Upload}&show={$Show}&item=" . $Row['uploadtree_pk'];
$Link = $HasChildren ? "{$Uri}&show={$Show}&upload={$Upload}&item={$Row['uploadtree_pk']}" : NULL;
if ($Show == 'detail') {
$V .= "<td class='mono'>" . DirMode2String($Row['ufile_mode']) . "</td>";
if (!Isdir($Row['ufile_mode'])) {
$V .= "<td align='right'> " . number_format($Row['pfile_size'], 0, "", ",") . " </td>";
} else {
$V .= "<td> </td>";
}
}
$displayItem = Isdir($Row['ufile_mode']) ? "{$Name}/" : $Name;
if (!empty($Link)) {
$displayItem = "<a href=\"{$Link}\">{$displayItem}</a>";
}
if (Iscontainer($Row['ufile_mode'])) {
$displayItem = "<b>{$displayItem}</b>";
}
$V .= "<td>{$displayItem}</td>\n";
if (!Iscontainer($Row['ufile_mode'])) {
$V .= menu_to_1list($MenuPfileNoCompare, $Parm, "<td>", "</td>\n", 1, $Upload);
} else {
if (!Isdir($Row['ufile_mode'])) {
$V .= menu_to_1list($MenuPfile, $Parm, "<td>", "</td>\n", 1, $Upload);
} else {
$V .= menu_to_1list($MenuTag, $Parm, "<td>", "</td>\n", 1, $Upload);
}
}
}
/* foreach($Results as $Row) */
$V .= "</table>\n";
if (!$ShowSomething) {
$text = _("No files");
$V .= "<b>{$text}</b>\n";
} else {
$V .= "<hr>\n";
if (count($Results) == 1) {
$text = _("1 item");
$V .= "{$text}\n";
} else {
$text = _("items");
$V .= count($Results) . " {$text}\n";
}
}
return $V;
}
/**
* \brief test for menu_functions()
*/
function test_menu_functions()
{
print "test function menu_insert()\n";
global $MenuList;
$Path = "TestMenu::Test1::Test2";
$LastOrder = 0;
$URI = "TestURI";
$Title = "TestTitle";
$Target = "TestTarget";
$HTML = "TestHTML";
$countMenuListBefore = count($MenuList);
$result = menu_insert($Path, $LastOrder, $URI, $Title, $Target, $HTML);
$this->assertEquals($Path, $MenuList[$countMenuListBefore]->FullName);
print "test function menu_find)\n";
$depth = 2;
$result = menu_find("Test1", $depth);
print "test function menu_to_1html)\n";
$result = menu_to_1html($MenuList);
$this->assertRegExp("/TestMenu/", $result);
print "test function menu_to_1list)\n";
$Parm = "";
$result = menu_to_1list($MenuList, $Parm, "", "");
$this->assertRegExp("/TestMenu/", $result);
print "Ending unit test for common-menu.php\n";
}
