/** * \brief test for Isdir Isartifact Iscontainer */ function test_Is() { print "Starting unit test for common-dir.php\n"; print "test function Isdir()\n"; $mode = 536888320; $result = Isdir($mode); $this->assertEquals(true, $result); $mode = 33188; $result = Isdir($mode); $this->assertEquals(false, $result); print "test function Isartifact()\n"; $mode = 536888320; $result = Isartifact($mode); $this->assertEquals(false, $result); $mode = 805323776; $result = Isartifact($mode); $this->assertEquals(true, $result); print "test function Iscontainer()\n"; $mode = 536888320; $result = Iscontainer($mode); $this->assertEquals(true, $result); $mode = 805323776; $result = Iscontainer($mode); $this->assertEquals(true, $result); print "test function DirMode2String()\n"; $result = DirMode2String($mode); $this->assertEquals("a-d-----S---", $result); //print "Ending unit test for common-dir.php\n"; }
/** * * @param int $uploadTreeId * @param Request $request * @return int $jobQueueId */ private function getJobQueueId($uploadTreeId, Request $request) { $uploadEntry = $this->uploadDao->getUploadEntry($uploadTreeId); $uploadId = intval($uploadEntry['upload_fk']); $userId = Auth::getUserId(); $groupId = Auth::getGroupId(); if ($uploadId <= 0 || !$this->uploadDao->isAccessible($uploadId, $groupId)) { throw new Exception('permission denied'); } $bulkScope = $request->get('bulkScope'); switch ($bulkScope) { case 'u': $uploadTreeTable = $this->uploadDao->getUploadtreeTableName($uploadId); $topBounds = $this->uploadDao->getParentItemBounds($uploadId, $uploadTreeTable); $uploadTreeId = $topBounds->getItemId(); break; case 'f': if (!Isdir($uploadEntry['ufile_mode']) && !Iscontainer($uploadEntry['ufile_mode']) && !Isartifact($uploadEntry['ufile_mode'])) { $uploadTreeId = $uploadEntry['parent'] ?: $uploadTreeId; } break; default: throw new InvalidArgumentException('bad scope request'); } $refText = $request->get('refText'); $actions = $request->get('bulkAction'); $licenseRemovals = array(); foreach ($actions as $licenseAction) { $licenseRemovals[$licenseAction['licenseId']] = $licenseAction['action'] == 'remove'; } $bulkId = $this->licenseDao->insertBulkLicense($userId, $groupId, $uploadTreeId, $licenseRemovals, $refText); if ($bulkId <= 0) { throw new Exception('cannot insert bulk reference'); } $upload = $this->uploadDao->getUpload($uploadId); $uploadName = $upload->getFilename(); $job_pk = JobAddJob($userId, $groupId, $uploadName, $uploadId); /** @var DeciderJobAgentPlugin $deciderPlugin */ $deciderPlugin = plugin_find("agent_deciderjob"); $dependecies = array(array('name' => 'agent_monk_bulk', 'args' => $bulkId)); $conflictStrategyId = intval($request->get('forceDecision')); $errorMsg = ''; $jqId = $deciderPlugin->AgentAdd($job_pk, $uploadId, $errorMsg, $dependecies, $conflictStrategyId); if (!empty($errorMsg)) { throw new Exception(str_replace('<br>', "\n", $errorMsg)); } return $jqId; }
private function getJobQueueId($uploadTreeId) { $uploadEntry = $this->uploadDao->getUploadEntry($uploadTreeId); $uploadId = intval($uploadEntry['upload_fk']); if ($uploadId <= 0) { throw new Exception('permission denied'); } $bulkScope = filter_input(INPUT_POST, 'bulkScope'); switch ($bulkScope) { case 'u': $uploadTreeTable = $this->uploadDao->getUploadtreeTableName($uploadId); $row = $this->dbManager->getSingleRow("SELECT uploadtree_pk FROM {$uploadTreeTable} WHERE upload_fk = \$1 ORDER BY uploadtree_pk LIMIT 1", array($uploadId), __METHOD__ . "adam" . $uploadTreeTable); $uploadTreeId = $row['uploadtree_pk']; break; case 'f': if (!Isdir($uploadEntry['ufile_mode']) && !Iscontainer($uploadEntry['ufile_mode']) && !Isartifact($uploadEntry['ufile_mode'])) { $uploadTreeId = $uploadEntry['parent'] ?: $uploadTreeId; } break; default: throw new InvalidArgumentException('bad scope request'); } $userId = Auth::getUserId(); $groupId = Auth::getGroupId(); $refText = filter_input(INPUT_POST, 'refText'); $action = filter_input(INPUT_POST, 'bulkAction'); $licenseId = GetParm('licenseId', PARM_INTEGER); $removing = $action === 'remove'; $bulkId = $this->licenseDao->insertBulkLicense($userId, $groupId, $uploadTreeId, $licenseId, $removing, $refText); if ($bulkId <= 0) { throw new Exception('cannot insert bulk reference'); } $upload = $this->uploadDao->getUpload($uploadId); $uploadName = $upload->getFilename(); $job_pk = JobAddJob($userId, $groupId, $uploadName, $uploadId); /** @var DeciderJobAgentPlugin $deciderPlugin */ $deciderPlugin = plugin_find("agent_deciderjob"); $dependecies = array(array('name' => 'agent_monk_bulk', 'args' => $bulkId)); $conflictStrategyId = intval(filter_input(INPUT_POST, 'forceDecision')); $errorMsg = ''; $jqId = $deciderPlugin->AgentAdd($job_pk, $uploadId, $errorMsg, $dependecies, $conflictStrategyId); if (!empty($errorMsg)) { throw new Exception(str_replace('<br>', "\n", $errorMsg)); } return $jqId; }
/** * \brief Given an Upload and UploadtreePk item, display: * - The histogram for the directory BY LICENSE. * - The file listing for the directory, with license navigation. */ function ShowUploadHist($Upload, $Item, $Uri) { /***** Get all the licenses PER item (file or directory) under this UploadtreePk. Save the data 3 ways: - Number of licenses PER item. - Number of items PER license. - Number of items PER license family. *****/ $VF = ""; // return values for file listing $VH = ""; // return values for license histogram $V = ""; // total return value global $Plugins; global $PG_CONN; $Lics = array(); // license summary for an item in the directory $ModLicView =& $Plugins[plugin_find_id("view-license")]; /* Arrays for storying item->license and license->item mappings */ $LicGID2Item = array(); $LicItem2GID = array(); $MapLic2GID = array(); /* every license should have an ID number */ /* Get the counts for each license under this UploadtreePk*/ LicenseGetAll($Item, $Lics); // key is license name, value is count $LicTotal = $Lics[' Total ']; /* Ensure that every license is associated with an ID */ /* MapLic2Gid key is license name, value is a sequence number (GID) */ $MapNext = 0; foreach ($Lics as $Key => $Val) { $MapLic2GID[$Key] = $MapNext++; } /****************************************/ /* Get ALL the items under this UploadtreePk */ $Children = DirGetList($Upload, $Item); $ChildCount = 0; $ChildLicCount = 0; $ChildDirCount = 0; /* total number of directory or containers */ foreach ($Children as $C) { if (Iscontainer($C['ufile_mode'])) { $ChildDirCount++; } } $VF .= "<table border=0>"; foreach ($Children as $C) { if (empty($C)) { continue; } /* Store the item information */ $IsDir = Isdir($C['ufile_mode']); $IsContainer = Iscontainer($C['ufile_mode']); /* Determine the hyperlinks */ if (!empty($C['pfile_fk']) && !empty($ModLicView)) { $LinkUri = "{$Uri}&item=" . $C['uploadtree_pk']; $LinkUri = preg_replace("/mod=license/", "mod=view-license", $LinkUri); } else { $LinkUri = NULL; } if (Iscontainer($C['ufile_mode'])) { $uploadtree_pk = DirGetNonArtifact($C['uploadtree_pk']); $LicUri = "{$Uri}&item=" . $uploadtree_pk; } else { $LicUri = NULL; } /* Populate the output ($VF) - file list */ /* Find number of licenses in child */ // if (($ChildDirCount < 20) || (!$IsContainer)) // { $LicCount = LicenseCount($C['uploadtree_pk']); } // else { $LicCount=0; } $LicCount = 0; $VF .= '<tr><td id="Lic-' . $LicCount . '" align="left">'; $HasHref = 0; $HasBold = 0; if ($IsContainer) { $VF .= "<a href='{$LicUri}'>"; $HasHref = 1; $VF .= "<b>"; $HasBold = 1; } else { if (!empty($LinkUri)) { $VF .= "<a href='{$LinkUri}'>"; $HasHref = 1; } } $VF .= $C['ufile_name']; if ($IsDir) { $VF .= "/"; } if ($HasBold) { $VF .= "</b>"; } if ($HasHref) { $VF .= "</a>"; } $VF .= "</td><td>"; if ($LicCount) { $VF .= "[" . number_format($LicCount, 0, "", ",") . " "; //$VF .= "<a href=\"javascript:LicColor('Lic-$ChildCount','LicGroup-','" . trim($LicItem2GID[$ChildCount]) . "','lightgreen');\">"; $VF .= "license" . ($LicCount == 1 ? "" : "s"); $VF .= "</a>"; $VF .= "]"; $ChildLicCount += $LicCount; } $VF .= "</td>"; $VF .= "</tr>\n"; $ChildCount++; } $VF .= "</table>\n"; // print "ChildCount=$ChildCount ChildLicCount=$ChildLicCount\n"; /*************************************** Problem: $ChildCount can be zero! This happens if you have a container that does not unpack to a directory. For example: file.gz extracts to archive.txt that contains a license. Same problem seen with .pdf and .Z files. Solution: if $ChildCount == 0, then just view the license! $ChildCount can also be zero if the directory is empty. ***************************************/ if ($ChildCount == 0) { $sql = "SELECT * FROM uploadtree WHERE uploadtree_pk = '{$Item}';"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); pg_free_result($result); if (IsDir($row['ufile_mode'])) { return; } $ModLicView =& $Plugins[plugin_find_id("view-license")]; return $ModLicView->Output(); } /****************************************/ /* List the licenses */ $VH .= "<table border=1 width='100%'>\n"; $SFbL = plugin_find_id("search_file_by_license"); $text = _("Count"); $VH .= "<tr><th width='10%'>{$text}</th>"; $text = _("Files"); if ($SFbL >= 0) { $VH .= "<th width='10%'>{$text}</th>"; } $text = _("License"); $VH .= "<th>{$text}</th>\n"; /* krsort + arsort = consistent sorting order */ arsort($Lics); /* Redo the sorting */ $SortOrder = array(); foreach ($Lics as $Key => $Val) { if (empty($Val)) { continue; } $SortOrder[] = $Val . "|" . str_replace("'", "", $Key) . "|" . $Key; } usort($SortOrder, array($this, "SortName")); $LicsTotal = array(); foreach ($SortOrder as $Key => $Val) { if (empty($Val)) { continue; } list($x, $y, $z) = explode("\\|", $Val, 3); $LicsTotal[$z] = $x; } $Total = 0; foreach ($Lics as $Key => $Val) { if ($Key != ' Total ') { $GID = $MapLic2GID[$Key]; $VH .= "<tr><td align='right'>{$Val}</td>"; $Total += $Val; if ($SFbL >= 0) { $VH .= "<td align='center'><a href='"; $VH .= Traceback_uri(); $text = _("Show"); $VH .= "?mod=search_file_by_license&item={$Item}&lic=" . urlencode($Key) . "'>{$text}</a></td>"; } $VH .= "<td id='LicGroup-{$GID}'>"; $Uri = Traceback_uri() . "?mod=license_listing&item={$Item}&lic={$GID}"; // $VH .= "<a href=\"javascript:LicColor('LicGroup-$GID','Lic-','" . trim($LicGID2Item[$GID]) . "','yellow'); "; // $VH .= "\">"; $VH .= htmlentities($Key); $VH .= "</a>"; $VH .= "</td></tr>\n"; } } $VH .= "</table>\n"; $VH .= "<br>\n"; $text = _("Total licenses"); $VH .= "{$text}: {$Total}\n"; /****************************************/ /* Licenses use Javascript to highlight */ $VJ = ""; // return values for the javascript $VJ .= "<script language='javascript'>\n"; $VJ .= "<!--\n"; $VJ .= "var LastSelf='';\n"; $VJ .= "var LastPrefix='';\n"; $VJ .= "var LastListing='';\n"; $VJ .= "function LicColor(Self,Prefix,Listing,color)\n"; $VJ .= "{\n"; $VJ .= "if (LastSelf!='')\n"; $VJ .= " { document.getElementById(LastSelf).style.backgroundColor='white'; }\n"; $VJ .= "LastSelf = Self;\n"; $VJ .= "if (LastPrefix!='')\n"; $VJ .= " {\n"; $VJ .= " List = LastListing.split(' ');\n"; $VJ .= " for(var i in List)\n"; $VJ .= " {\n"; $VJ .= " document.getElementById(LastPrefix + List[i]).style.backgroundColor='white';\n"; $VJ .= " }\n"; $VJ .= " }\n"; $VJ .= "LastPrefix = Prefix;\n"; $VJ .= "LastListing = Listing;\n"; $VJ .= "if (Self!='')\n"; $VJ .= " {\n"; $VJ .= " document.getElementById(Self).style.backgroundColor=color;\n"; $VJ .= " }\n"; $VJ .= "if (Listing!='')\n"; $VJ .= " {\n"; $VJ .= " List = Listing.split(' ');\n"; $VJ .= " for(var i in List)\n"; $VJ .= " {\n"; $VJ .= " document.getElementById(Prefix + List[i]).style.backgroundColor=color;\n"; $VJ .= " }\n"; $VJ .= " }\n"; $VJ .= "}\n"; $VJ .= "// -->\n"; $VJ .= "</script>\n"; /* Combine VF and VH */ $V .= "<table border=0 width='100%'>\n"; $V .= "<tr><td valign='top' width='50%'>{$VH}</td><td valign='top'>{$VF}</td></tr>\n"; $V .= "</table>\n"; $V .= "<hr />\n"; $V .= $VJ; return $V; }
/** * @param $Uploadtree_pk * @param $Uri * @param $uploadtree_tablename * @param $Agent_pk * @param $upload_pk * @return array */ protected function getFileListing($Uploadtree_pk, $Uri, $uploadtree_tablename, $Agent_pk, $upload_pk) { $VF = ""; // return values for file listing /******* File Listing ************/ /* Get ALL the items under this Uploadtree_pk */ $Children = GetNonArtifactChildren($Uploadtree_pk, $uploadtree_tablename); $ChildCount = 0; $ChildLicCount = 0; $ChildDirCount = 0; /* total number of directory or containers */ foreach ($Children as $c) { if (Iscontainer($c['ufile_mode'])) { $ChildDirCount++; } } $VF .= "<table border=0>"; foreach ($Children as $child) { if (empty($child)) { continue; } $ChildCount++; global $Plugins; $ModLicView =& $Plugins[plugin_find_id($this->viewName)]; /* Determine the hyperlink for non-containers to view-license */ if (!empty($child['pfile_fk']) && !empty($ModLicView)) { $LinkUri = Traceback_uri(); $LinkUri .= "?mod=" . $this->viewName . "&agent={$Agent_pk}&upload={$upload_pk}&item={$child['uploadtree_pk']}"; } else { $LinkUri = NULL; } /* Determine link for containers */ if (Iscontainer($child['ufile_mode'])) { $uploadtree_pk = DirGetNonArtifact($child['uploadtree_pk'], $uploadtree_tablename); $LicUri = "{$Uri}&item=" . $uploadtree_pk; } else { $LicUri = NULL; } /* Populate the output ($VF) - file list */ /* id of each element is its uploadtree_pk */ $LicCount = 0; $cellContent = Isdir($child['ufile_mode']) ? $child['ufile_name'] . '/' : $child['ufile_name']; if (Iscontainer($child['ufile_mode'])) { $cellContent = "<a href='{$LicUri}'><b>{$cellContent}</b></a>"; } else { if (!empty($LinkUri)) { $cellContent = "<a href='{$LinkUri}'>{$cellContent}</a>"; } } $VF .= "<tr><td id='{$child['uploadtree_pk']}' align='left'>{$cellContent}</td><td>"; if ($LicCount) { $VF .= "[" . number_format($LicCount, 0, "", ",") . " "; $VF .= "license" . ($LicCount == 1 ? "" : "s"); $VF .= "</a>"; $VF .= "]"; $ChildLicCount += $LicCount; } $VF .= "</td></tr>\n"; } $VF .= "</table>\n"; return array($ChildCount, $VF); }
/** * \brief Given an $Uploadtree_pk, display: * - The histogram for the directory BY LICENSE. * - The file listing for the directory. */ function ShowUploadHist($Uploadtree_pk, $Uri, $tag_pk) { global $PG_CONN; $VF = ""; // return values for file listing $VLic = ""; // return values for license histogram $V = ""; // total return value $UniqueTagArray = array(); global $Plugins; $ModLicView =& $Plugins[plugin_find_id("view-license")]; /******* Get license names and counts ******/ /* Find lft and rgt bounds for this $Uploadtree_pk */ $sql = "SELECT lft,rgt,upload_fk FROM {$this->uploadtree_tablename}\n WHERE uploadtree_pk = {$Uploadtree_pk}"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); $lft = $row["lft"]; $rgt = $row["rgt"]; $upload_pk = $row["upload_fk"]; pg_free_result($result); if (empty($lft)) { $text = _("Job unpack/adj2nest hasn't completed."); $VLic = "<b>{$text}</b><p>"; return $VLic; } /* Find total number of files for this $Uploadtree_pk * Exclude artifacts and directories. */ $sql = "SELECT count(*) as count FROM {$this->uploadtree_tablename}\n WHERE upload_fk = {$upload_pk} \n and {$this->uploadtree_tablename}.lft BETWEEN {$lft} and {$rgt}\n and ((ufile_mode & (1<<28))=0) \n and ((ufile_mode & (1<<29))=0) and pfile_fk!=0"; //$uTime = microtime(true); $result = pg_query($PG_CONN, $sql); //printf( "<small>count files Elapsed time: %.2f seconds</small>", microtime(true) - $uTime); // convert usecs to secs DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); $FileCount = $row["count"]; pg_free_result($result); /* Get the counts for each license under this UploadtreePk*/ if (empty($tag_pk)) { $TagTable = ""; $TagClause = ""; } else { $TagTable = " right join tag_file on tag_file.pfile_fk=license_file_ref.pfile_fk "; $TagClause = " and tag_fk={$tag_pk}"; } /** advanced interface allowing user to select dataset (agent version) */ $Agent_name = 'nomos'; $dataset = "nomos_dataset"; $Agent_pk = GetParm("agent", PARM_STRING); /** if do not specify agent, get the latest agent result for this upload */ if (empty($Agent_pk)) { $Agent_pk = LatestAgentpk($upload_pk, "nomos_ars"); } if ($Agent_pk == 0) { $text = _("No data available. Use Jobs > Agents to schedule a license scan."); $VLic = "<b>{$text}</b><p>"; return $VLic; } /** get nomos select dataset */ $AgentSelect = AgentSelect($Agent_name, $upload_pk, true, $dataset, $dataset, $Agent_pk, "onchange=\"addArsGo('newds', 'nomos_dataset');\""); /** change the nomos license result when selecting one version of nomos */ if (!empty($AgentSelect)) { $action = Traceback_uri() . "?mod=nomoslicense&upload={$upload_pk}&item={$Uploadtree_pk}"; $VLic .= "<script type='text/javascript'>\n function addArsGo(formid, selectid)\n {\n var selectobj = document.getElementById(selectid);\n var Agent_pk = selectobj.options[selectobj.selectedIndex].value;\n document.getElementById(formid).action='{$action}'+'&agent='+Agent_pk;\n document.getElementById(formid).submit();\n return;\n }\n </script>"; /* form to select new dataset, show dataset */ $VLic .= "<form action='{$action}' id='newds' method='POST'>\n"; $VLic .= $AgentSelect; $VLic .= "</form>"; } $orderBy = array('count', 'license_name'); $ordersql = "liccount desc"; static $ordercount = 1; static $orderlic = 1; /** sorting by count/licnese name */ if (isset($_GET['orderBy']) && in_array($_GET['orderBy'], $orderBy)) { $order = $_GET['orderBy']; if (isset($_GET['orderc'])) { $ordercount = $_GET['orderc']; } if (isset($_GET['orderl'])) { $orderlic = $_GET['orderl']; } if ('count' == $order && 1 == $ordercount) { $ordersql = "liccount desc"; $ordercount = 0; } else { if ('count' == $order && 0 == $ordercount) { $ordersql = "liccount "; $ordercount = 1; } else { if ('license_name' == $order && 1 == $orderlic) { $ordersql = "rf_shortname "; $orderlic = 0; } else { if ('license_name' == $order && 0 == $orderlic) { $ordersql = "rf_shortname desc"; $orderlic = 1; } } } } } // Void ARE EXCLUDED FROM LICENSE COUNT $sql = "SELECT distinct(SS.rf_shortname) as licname, count(SS.rf_shortname) as liccount, SS.rf_shortname from \n (SELECT distinct(license_file_ref.pfile_fk), rf_shortname\n from license_file_ref {$TagTable}\n right join {$this->uploadtree_tablename} on license_file_ref.pfile_fk={$this->uploadtree_tablename}.pfile_fk \n where rf_shortname <> 'Void' and upload_fk='{$upload_pk}' and {$this->uploadtree_tablename}.lft BETWEEN {$lft} and {$rgt} \n and agent_fk={$Agent_pk} {$TagClause} group by license_file_ref.pfile_fk, rf_shortname\n ) as SS\n group by rf_shortname order by {$ordersql}"; //$uTime = microtime(true); $result = pg_query($PG_CONN, $sql); //$Time = microtime(true) - $uTime; // convert usecs to secs //$text = _("histogram Elapsed time: %.2f seconds"); //printf( "<small>$text</small>", $Time); DBCheckResult($result, $sql, __FILE__, __LINE__); /* Write license histogram to $VLic */ $LicCount = 0; $UniqueLicCount = 0; $NoLicFound = 0; $VLic .= "<table border=1 width='100%' id='lichistogram'>\n"; $text = _("Count"); $VLic .= "<tr><th>"; $VLic .= "<a href=?mod=" . "{$this->Name}" . Traceback_parm_keep(array("upload", "item", "tag", "agent")) . "&orderBy=count&orderc={$ordercount}>{$text}</a>"; $VLic .= "</th>"; $text = _("Files"); $VLic .= "<th width='10%'>{$text}</th>"; $text = _("License Name"); $VLic .= "<th>"; $VLic .= "<a href=?mod=" . "{$this->Name}" . Traceback_parm_keep(array("upload", "item", "tag", "agent")) . "&orderBy=license_name&orderl={$orderlic}>{$text}</a>"; $VLic .= "</th></tr>\n"; while ($row = pg_fetch_assoc($result)) { $UniqueLicCount++; $LicCount += $row['liccount']; /* Count */ $VLic .= "<tr><td align='right'>{$row['liccount']}</td>"; /* Show */ $VLic .= "<td align='center'><a href='"; $VLic .= Traceback_uri(); $text = _("Show"); $tagClause = $tag_pk ? "&tag={$tag_pk}" : ""; $VLic .= "?mod=list_lic_files&napk={$Agent_pk}&item={$Uploadtree_pk}&lic=" . urlencode($row['rf_shortname']) . $tagClause . "'>{$text}</a></td>"; /* License name */ $VLic .= "<td align='left'>"; $rf_shortname = rawurlencode($row['rf_shortname']); $VLic .= "<a id='{$rf_shortname}' onclick='FileColor_Get(\"" . Traceback_uri() . "?mod=ajax_filelic&napk={$Agent_pk}&item={$Uploadtree_pk}&lic={$rf_shortname}&ut={$this->uploadtree_tablename}\")'"; $VLic .= ">{$row['licname']} </a>"; $VLic .= "</td>"; $VLic .= "</tr>\n"; if ($row['licname'] == "No_license_found") { $NoLicFound = $row['liccount']; } } $VLic .= "</table>\n"; $VLic .= "<p>\n"; $VLic .= _("Hint: Click on the license name to "); $text = _("highlight"); $VLic .= "<span style='background-color:{$this->HighlightColor}'>{$text} </span>"; $VLic .= _("where the license is found in the file listing.<br>\n"); $VLic .= "<table border=0 id='licsummary'>"; $text = _("Unique licenses"); $VLic .= "<tr><td align=right>{$UniqueLicCount}</td><td>{$text}</td></tr>"; $NetLic = $LicCount - $NoLicFound; $text = _("Licenses found"); $VLic .= "<tr><td align=right>{$NetLic}</td><td>{$text}</td></tr>"; $text = _("Files with no licenses"); $VLic .= "<tr><td align=right>{$NoLicFound}</td><td>{$text}</td></tr>"; $text = _("Files"); $VLic .= "<tr><td align=right>{$FileCount}</td><td>{$text}</td></tr>"; $VLic .= "</table>"; pg_free_result($result); /******* File Listing ************/ /* Get ALL the items under this Uploadtree_pk */ $Children = GetNonArtifactChildren($Uploadtree_pk, $this->uploadtree_tablename); /* Filter out Children that don't have tag */ if (!empty($tag_pk)) { TagFilter($Children, $tag_pk, $this->uploadtree_tablename); } $ChildCount = 0; $ChildLicCount = 0; //$uTime = microtime(true); if (!empty($Children)) { /* For alternating row background colors */ $RowStyle1 = "style='background-color:#ecfaff'"; // pale blue $RowStyle2 = "style='background-color:#ffffe3'"; // pale yellow $ColorSpanRows = 1; // Alternate background color every $ColorSpanRows $RowNum = 0; $VF .= "<table border=0 id='dirlist'>"; foreach ($Children as $C) { if (empty($C)) { continue; } $IsDir = Isdir($C['ufile_mode']); $IsContainer = Iscontainer($C['ufile_mode']); /* Determine the hyperlink for non-containers to view-license */ if (!empty($C['pfile_fk']) && !empty($ModLicView)) { $LinkUri = Traceback_uri(); $LinkUri .= "?mod=view-license&napk={$Agent_pk}&upload={$upload_pk}&item={$C['uploadtree_pk']}"; } else { $LinkUri = NULL; } /* Determine link for containers */ if (Iscontainer($C['ufile_mode'])) { $uploadtree_pk = DirGetNonArtifact($C['uploadtree_pk'], $this->uploadtree_tablename); $LicUri = "{$Uri}&item=" . $uploadtree_pk; } else { $LicUri = NULL; } /* Populate the output ($VF) - file list */ /* id of each element is its uploadtree_pk */ /* Set alternating row background color - repeats every $ColorSpanRows rows */ $RowStyle = $RowNum++ % (2 * $ColorSpanRows) < $ColorSpanRows ? $RowStyle1 : $RowStyle2; $VF .= "<tr {$RowStyle}>"; $VF .= "<td id='{$C['uploadtree_pk']}' align='left'>"; $HasHref = 0; $HasBold = 0; if ($IsContainer) { $VF .= "<a href='{$LicUri}'>"; $HasHref = 1; $VF .= "<b>"; $HasBold = 1; } else { if (!empty($LinkUri)) { $VF .= "<a href='{$LinkUri}'>"; $HasHref = 1; } } $VF .= $C['ufile_name']; if ($IsDir) { $VF .= "/"; } if ($HasBold) { $VF .= "</b>"; } if ($HasHref) { $VF .= "</a>"; } /* show licenses under file name */ $VF .= "<br>"; $VF .= GetFileLicenses_string($Agent_pk, $C['pfile_fk'], $C['uploadtree_pk'], $this->uploadtree_tablename); $VF .= "</td><td valign='top'>"; /* display file links */ $VF .= FileListLinks($C['upload_fk'], $C['uploadtree_pk'], $Agent_pk, $C['pfile_fk'], true, $UniqueTagArray, $this->uploadtree_tablename); $VF .= "</td>"; $VF .= "</tr>\n"; $ChildCount++; } $VF .= "</table>\n"; } //$Time = microtime(true) - $uTime; // convert usecs to secs //$text = _("Sum of children Elapsed time: %.2f seconds"); //printf( "<small>$text</small>", $Time); /*************************************** Problem: $ChildCount can be zero! This happens if you have a container that does not unpack to a directory. For example: file.gz extracts to archive.txt that contains a license. Same problem seen with .pdf and .Z files. Solution: if $ChildCount == 0, then just view the license! $ChildCount can also be zero if the directory is empty. ***************************************/ if ($ChildCount == 0) { $sql = "SELECT * FROM {$this->uploadtree_tablename} WHERE uploadtree_pk = '{$Uploadtree_pk}';"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); pg_free_result($result); if (IsDir($row['ufile_mode'])) { return; } $ModLicView =& $Plugins[plugin_find_id("view-license")]; return $ModLicView->Output(); } $V .= ActiveHTTPscript("FileColor"); /* Add javascript for color highlighting This is the response script needed by ActiveHTTPscript responseText is license name',' followed by a comma seperated list of uploadtree_pk's */ $script = "\n <script type=\"text/javascript\" charset=\"utf-8\">\n var Lastutpks=''; /* save last list of uploadtree_pk's */\n var LastLic=''; /* save last License (short) name */\n var color = '{$this->HighlightColor}';\n function FileColor_Reply()\n {\n if ((FileColor.readyState==4) && (FileColor.status==200))\n {\n /* remove previous highlighting */\n var numpks = Lastutpks.length;\n if (numpks > 0) document.getElementById(LastLic).style.backgroundColor='white';\n while (numpks)\n {\n document.getElementById(Lastutpks[--numpks]).style.backgroundColor='white';\n }\n\n utpklist = FileColor.responseText.split(',');\n LastLic = utpklist.shift();\n numpks = utpklist.length;\n Lastutpks = utpklist;\n\n /* apply new highlighting */\n elt = document.getElementById(LastLic);\n if (elt != null) elt.style.backgroundColor=color;\n while (numpks)\n {\n document.getElementById(utpklist[--numpks]).style.backgroundColor=color;\n }\n }\n return;\n }\n </script>\n "; $V .= $script; /****** Filters *******/ /* Only display the filter pulldown if there are filters available * Currently, this is only tags. */ /** @todo qualify with tag namespace to avoid tag name collisions. **/ /* turn $UniqueTagArray into key value pairs ($SelectData) for select list */ $SelectData = array(); if (count($UniqueTagArray)) { foreach ($UniqueTagArray as $UTA_row) { $SelectData[$UTA_row['tag_pk']] = $UTA_row['tag_name']; } $V .= "Tag filter"; $myurl = "?mod=" . $this->Name . Traceback_parm_keep(array("upload", "item")); $Options = " id='filterselect' onchange=\"js_url(this.value, '{$myurl}&tag=')\""; $V .= Array2SingleSelectTag($SelectData, "tag_ns_pk", $tag_pk, true, false, $Options); } /****** Combine VF and VLic ********/ $V .= "<table border=0 width='100%'>\n"; $V .= "<tr><td valign='top' >{$VLic}</td><td valign='top'>{$VF}</td></tr>\n"; $V .= "</table>\n"; $V .= "<hr />\n"; return $V; }
/** * \brief Given an $File1uploadtree_pk, * $Children are non artifact children of $File1uploadtree_pk * * \return a string with the html table, file listing (the browse tree), * for these children. */ function HTMLFileList($File1uploadtree_pk, $Children, $FolderContents) { global $PG_CONN; global $Plugins; $OutBuf = ""; // return values for file listing $Uri = Traceback_uri() . "?mod={$this->Name}"; $OutBuf .= "<table style='text-align:left;' >"; if (!empty($FolderContents)) { usort($FolderContents, 'picker_name_cmp'); /* write subfolders */ foreach ($FolderContents as $Folder) { if ($Folder && array_key_exists('folder_pk', $Folder)) { $folder_pk = $Folder['folder_pk']; $folder_name = htmlentities($Folder['name']); $OutBuf .= "<tr>"; $OutBuf .= "<td></td>"; $OutBuf .= "<td>"; $OutBuf .= "<a href='{$Uri}&folder={$folder_pk}&item={$File1uploadtree_pk}'><b>{$folder_name}</b></a>/"; $OutBuf .= "</td></tr>"; } else { if ($Folder && array_key_exists('uploadtree_pk', $Folder)) { $bitem = $Folder['uploadtree_pk']; $upload_filename = htmlentities($Folder['name']); $OutBuf .= "<tr>"; $OutBuf .= "<td>"; $text = _("Select"); $Options = "id=filepick2 onclick='AppJump({$bitem})')"; $OutBuf .= "<button type='button' {$Options}> {$text} </button>\n"; $OutBuf .= "</td>"; $OutBuf .= "<td>"; $OutBuf .= "<a href='{$Uri}&bitem={$bitem}&item={$File1uploadtree_pk}'><b>{$upload_filename}</b></a>/"; $OutBuf .= "</td></tr>"; } } } } else { if (empty($Children)) { $text = _("No children to compare"); $OutBuf .= "<tr><td colspan=2>{$text}</td></tr>"; } else { usort($Children, 'picker_ufile_name_cmp'); foreach ($Children as $Child) { if (empty($Child)) { continue; } $OutBuf .= "<tr>"; $IsDir = Isdir($Child['ufile_mode']); $IsContainer = Iscontainer($Child['ufile_mode']); $LinkUri = $Uri . "&bitem={$Child['uploadtree_pk']}&item={$File1uploadtree_pk}"; $OutBuf .= "<td>"; $text = _("Select"); $Options = "id=filepick onclick='AppJump({$Child['uploadtree_pk']})')"; $OutBuf .= "<button type='button' {$Options}> {$text} </button>\n"; $OutBuf .= "</td>"; $OutBuf .= "<td>"; if ($IsContainer) { $OutBuf .= "<a href='{$LinkUri}'> {$Child['ufile_name']}</a>"; } else { $OutBuf .= $Child['ufile_name']; } if ($IsDir) { $OutBuf .= "/"; } $OutBuf .= "</td>"; $OutBuf .= "</tr>"; } } } $OutBuf .= "</table>"; return $OutBuf; }
/** * \brief Given an $Uploadtree_pk, display: \n * (1) The histogram for the directory BY LICENSE. \n * (2) The file listing for the directory. * * \param $Uploadtree_pk * \param $Uri * \param $filter * \param $uploadtree_tablename * \param $Agent_pk - agent id */ function ShowUploadHist($Uploadtree_pk, $Uri, $filter, $uploadtree_tablename, $Agent_pk) { global $PG_CONN; $VF = ""; // return values for file listing $VLic = ""; // return values for license histogram $V = ""; // total return value $upload_pk = ""; $VCopyright = ''; global $Plugins; $ModLicView =& $Plugins[plugin_find_id("copyrightview")]; $rows = $this->GetRows($Uploadtree_pk, $Agent_pk, $upload_pk, 0, $filter); if (!is_array($rows)) { return $rows; } $orderBy = array('count', 'copyright'); static $ordercount = 1; static $ordercopyright = 1; $order = ""; /** sorting by count/copyright statement */ if (isset($_GET['orderBy']) && in_array($_GET['orderBy'], $orderBy)) { $order = $_GET['orderBy']; if (isset($_GET['orderc'])) { $ordercount = $_GET['orderc']; } if (isset($_GET['ordercp'])) { $ordercopyright = $_GET['ordercp']; } if ('count' == $order && 1 == $ordercount) { $ordercount = 0; } else { if ('count' == $order && 0 == $ordercount) { $ordercount = 1; } else { if ('copyright' == $order && 1 == $ordercopyright) { $ordercopyright = 0; } else { if ('copyright' == $order && 0 == $ordercopyright) { $ordercopyright = 1; } } } } } /* Write license histogram to $VLic */ $CopyrightCount = 0; $UniqueCopyrightCount = 0; $NoCopyrightFound = 0; $VCopyright = ""; $VCopyright .= "<table border=1 width='100%' id='copyright'>\n"; $text = _("Count"); $text1 = _("Files"); $text2 = _("Copyright Statements"); $text3 = _("Email"); $text4 = _("URL"); $VCopyright .= "<tr><th>"; $VCopyright .= "<a href=?mod=" . "{$this->Name}" . Traceback_parm_keep(array("upload", "item", "filter", "agent")) . "&orderBy=count&orderc={$ordercount}>{$text}</a>"; $VCopyright .= "</th>"; $VCopyright .= "<th width='10%'>{$text1}</th>"; $VCopyright .= "<th>"; $VCopyright .= "<a href=?mod=" . "{$this->Name}" . Traceback_parm_keep(array("upload", "item", "filter", "agent")) . "&orderBy=copyright&ordercp={$ordercopyright}>{$text2}</a>"; $VCopyright .= "</th>"; $VCopyright .= "</th></tr>\n"; $EmailCount = 0; $UniqueEmailCount = 0; $NoEmailFound = 0; $VEmail = "<table border=1 width='100%'id='copyrightemail'>\n"; $VEmail .= "<tr><th width='10%'>{$text}</th>"; $VEmail .= "<th width='10%'>{$text1}</th>"; $VEmail .= "<th>{$text3}</th></tr>\n"; $UrlCount = 0; $UniqueUrlCount = 0; $NoUrlFound = 0; $VUrl = "<table border=1 width='100%' id='copyrighturl'>\n"; $VUrl .= "<tr><th width='10%'>{$text}</th>"; $VUrl .= "<th width='10%'>{$text1}</th>"; $VUrl .= "<th>{$text4}</th></tr>\n"; if (!is_array($rows)) { $VCopyright .= "<tr><td colspan=3>{$rows}</td></tr>"; } else { foreach ($rows as $row) { $hash = $row['hash']; if ($row['type'] == 'statement') { $UniqueCopyrightCount++; $CopyrightCount += $row['copyright_count']; $VCopyright .= "<tr><td align='right'>{$row['copyright_count']}</td>"; $VCopyright .= "<td align='center'><a href='"; $VCopyright .= Traceback_uri(); $URLargs = "?mod=copyrightlist&agent={$Agent_pk}&item={$Uploadtree_pk}&hash=" . $hash . "&type=" . $row['type']; if (!empty($filter)) { $URLargs .= "&filter={$filter}"; } $VCopyright .= $URLargs . "'>Show</a></td>"; $VCopyright .= "<td align='left'>"; /* strip out characters we don't want to see This is a hack until the agent stops writing these chars to the db. */ $S = $row['content']; $S = htmlentities($S); $S = str_replace("Â", "", $S); // comes from utf-8 copyright symbol $VCopyright .= $S; /* Debugging $hex = bin2hex($S); $VCopyright .= "<br>$hex" ; End Debugging */ $VCopyright .= "</td>"; $VCopyright .= "</tr>\n"; } else { if ($row['type'] == 'email') { $UniqueEmailCount++; $EmailCount += $row['copyright_count']; $VEmail .= "<tr><td align='right'>{$row['copyright_count']}</td>"; $VEmail .= "<td align='center'><a href='"; $VEmail .= Traceback_uri(); $VEmail .= "?mod=copyrightlist&agent={$Agent_pk}&item={$Uploadtree_pk}&hash=" . $hash . "&type=" . $row['type'] . "'>Show</a></td>"; $VEmail .= "<td align='left'>"; $VEmail .= htmlentities($row['content']); $VEmail .= "</td>"; $VEmail .= "</tr>\n"; } else { if ($row['type'] == 'url') { $UniqueUrlCount++; $UrlCount += $row['copyright_count']; $VUrl .= "<tr><td align='right'>{$row['copyright_count']}</td>"; $VUrl .= "<td align='center'><a href='"; $VUrl .= Traceback_uri(); $VUrl .= "?mod=copyrightlist&agent={$Agent_pk}&item={$Uploadtree_pk}&hash=" . $hash . "&type=" . $row['type'] . "'>Show</a></td>"; $VUrl .= "<td align='left'>"; $VUrl .= htmlentities($row['content']); $VUrl .= "</td>"; $VUrl .= "</tr>\n"; } } } } } $VCopyright .= "</table>\n"; $VCopyright .= "<p>\n"; $text = _("Unique Copyrights"); $text1 = _("Total Copyrights"); $VCopyright .= "{$text}: {$UniqueCopyrightCount}<br>\n"; $NetCopyright = $CopyrightCount; $VCopyright .= "{$text1}: {$NetCopyright}"; $VEmail .= "</table>\n"; $VEmail .= "<p>\n"; $text = _("Unique Emails"); $text1 = _("Total Emails"); $VEmail .= "{$text}: {$UniqueEmailCount}<br>\n"; $NetEmail = $EmailCount; $VEmail .= "{$text1}: {$NetEmail}"; $VUrl .= "</table>\n"; $VUrl .= "<p>\n"; $text = _("Unique URLs"); $text1 = _("Total URLs"); $VUrl .= "{$text}: {$UniqueUrlCount}<br>\n"; $NetUrl = $UrlCount; $VUrl .= "{$text1}: {$NetUrl}"; /******* File Listing ************/ /* Get ALL the items under this Uploadtree_pk */ $Children = GetNonArtifactChildren($Uploadtree_pk, $uploadtree_tablename); $ChildCount = 0; $ChildLicCount = 0; $ChildDirCount = 0; /* total number of directory or containers */ foreach ($Children as $C) { if (Iscontainer($C['ufile_mode'])) { $ChildDirCount++; } } $VF .= "<table border=0>"; foreach ($Children as $C) { if (empty($C)) { continue; } $IsDir = Isdir($C['ufile_mode']); $IsContainer = Iscontainer($C['ufile_mode']); /* Determine the hyperlink for non-containers to view-license */ if (!empty($C['pfile_fk']) && !empty($ModLicView)) { $LinkUri = Traceback_uri(); $LinkUri .= "?mod=view-license&agent={$Agent_pk}&upload={$upload_pk}&item={$C['uploadtree_pk']}"; } else { $LinkUri = NULL; } /* Determine link for containers */ if (Iscontainer($C['ufile_mode'])) { $uploadtree_pk = DirGetNonArtifact($C['uploadtree_pk'], $uploadtree_tablename); $LicUri = "{$Uri}&item=" . $uploadtree_pk; } else { $LicUri = NULL; } /* Populate the output ($VF) - file list */ /* id of each element is its uploadtree_pk */ $LicCount = 0; $VF .= "<tr><td id='{$C['uploadtree_pk']}' align='left'>"; $HasHref = 0; $HasBold = 0; if ($IsContainer) { $VF .= "<a href='{$LicUri}'>"; $HasHref = 1; $VF .= "<b>"; $HasBold = 1; } else { if (!empty($LinkUri)) { $VF .= "<a href='{$LinkUri}'>"; $HasHref = 1; } } $VF .= $C['ufile_name']; if ($IsDir) { $VF .= "/"; } if ($HasBold) { $VF .= "</b>"; } if ($HasHref) { $VF .= "</a>"; } $VF .= "</td><td>"; if ($LicCount) { $VF .= "[" . number_format($LicCount, 0, "", ",") . " "; $VF .= "license" . ($LicCount == 1 ? "" : "s"); $VF .= "</a>"; $VF .= "]"; $ChildLicCount += $LicCount; } $VF .= "</td>"; $VF .= "</tr>\n"; $ChildCount++; } $VF .= "</table>\n"; /*************************************** Problem: $ChildCount can be zero! This happens if you have a container that does not unpack to a directory. For example: file.gz extracts to archive.txt that contains a license. Same problem seen with .pdf and .Z files. Solution: if $ChildCount == 0, then just view the license! $ChildCount can also be zero if the directory is empty. ***************************************/ if ($ChildCount == 0) { $sql = "SELECT * FROM {$this->uploadtree_tablename} WHERE uploadtree_pk = '{$Uploadtree_pk}';"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); pg_free_result($result); if (IsDir($row['ufile_mode'])) { return; } $ModLicView =& $Plugins[plugin_find_id("copyrightview")]; return $ModLicView->Output(); } /* Combine VF and VLic */ $text = _("Jump to"); $text1 = _("Emails"); $text2 = _("Copyright Statements"); $text3 = _("URLs"); $V .= "<table border=0 width='100%'>\n"; $V .= "<tr><td><a name=\"statements\"></a>{$text}: <a href=\"#emails\">{$text1}</a> | <a href=\"#urls\">{$text3}</a></td><td></td></tr>\n"; $V .= "<tr><td valign='top' width='50%'>{$VCopyright}</td><td valign='top'>{$VF}</td></tr>\n"; $V .= "<tr><td><a name=\"emails\"></a>Jump to: <a href=\"#statements\">{$text2}</a> | <a href=\"#urls\">{$text3}</a></td><td></td></tr>\n"; $V .= "<tr><td valign='top' width='50%'>{$VEmail}</td><td valign='top'></td></tr>\n"; $V .= "<tr><td><a name=\"urls\"></a>Jump To: <a href=\"#statements\">{$text2}</a> | <a href=\"#emails\">{$text1}</a></td><td></td></tr>\n"; $V .= "<tr><td valign='top' width='50%'>{$VUrl}</td><td valign='top'></td></tr>\n"; $V .= "</table>\n"; $V .= "<hr />\n"; return $V; }
function OutputOpen() { if ($this->State != PLUGIN_STATE_READY) { return 0; } $uploadId = GetParm("upload", PARM_INTEGER); if (empty($uploadId)) { return; } $uploadTreeId = GetParm("item", PARM_INTEGER); if (empty($uploadTreeId)) { $parent = $this->uploadDao->getUploadParent($uploadId); if (!isset($parent)) { $this->invalidParm = true; return; } $item = $this->uploadDao->getNextItem($uploadId, $parent); if ($item === UploadDao::NOT_FOUND) { $this->invalidParm = true; return; } $uploadTreeId = $item->getId(); return new RedirectResponse(Traceback_uri() . '?mod=' . $this->Name . Traceback_parm_keep(array("upload", "show")) . "&item={$uploadTreeId}"); } $uploadTreeTableName = $this->uploadDao->getUploadtreeTableName($uploadId); $uploadEntry = $this->uploadDao->getUploadEntry($uploadTreeId, $uploadTreeTableName); if (Isdir($uploadEntry['ufile_mode']) || Iscontainer($uploadEntry['ufile_mode'])) { $parent = $this->uploadDao->getUploadParent($uploadId); if (!isset($parent)) { $this->invalidParm = true; return; } $item = $this->uploadDao->getNextItem($uploadId, $parent); if ($item === UploadDao::NOT_FOUND) { $this->invalidParm = true; return; } $uploadTreeId = $item->getId(); return new RedirectResponse(Traceback_uri() . '?mod=' . $this->Name . Traceback_parm_keep(array("upload", "show")) . "&item={$uploadTreeId}"); } return parent::OutputOpen(); }
protected function handle(Request $request) { $vars = array(); $uploadId = intval($request->get('upload')); $uploadTreeId = intval($request->get('item')); if (empty($uploadTreeId) || empty($uploadId)) { $text = _("Empty Input"); $vars['message'] = "<h2>{$text}</h2>"; return $this->responseBad($vars); } if (!$this->uploadDao->isAccessible($uploadId, Auth::getGroupId())) { $text = _("Permission Denied"); $vars['message'] = "<h2>{$text}</h2>"; return $this->responseBad(); } $uploadTreeTableName = $this->uploadDao->getUploadtreeTableName($uploadId); $uploadEntry = $this->uploadDao->getUploadEntry($uploadTreeId, $uploadTreeTableName); if (Isdir($uploadEntry['ufile_mode']) || Iscontainer($uploadEntry['ufile_mode'])) { $parent = $this->uploadDao->getUploadParent($uploadEntry['upload_fk']); if (!isset($parent)) { return $this->responseBad(); } $uploadTree = $this->uploadDao->getNextItem($uploadEntry['upload_fk'], $parent); if ($uploadTree === UploadDao::NOT_FOUND) { return $this->responseBad(); } $uploadTreeId = $uploadTree->getId(); return new RedirectResponse(Traceback_uri() . '?mod=' . $this->getName() . Traceback_parm_keep(array('show', 'upload')) . "&item={$uploadTreeId}"); } if (empty($uploadTreeId)) { return $this->responseBad('No item selected.'); } $copyrightDecisionMap = $this->decisionTypes->getMap(); $vars['micromenu'] = Dir2Browse($this->modBack, $uploadTreeId, NULL, $showBox = 0, "View", -1, '', '', $uploadTreeTableName); $lastItem = GetParm("lastItem", PARM_INTEGER); $changed = GetParm("changedSomething", PARM_STRING); $userId = Auth::getUserId(); if (!empty($lastItem) && $changed == "true") { $lastUploadEntry = $this->uploadDao->getUploadEntry($lastItem, $uploadTreeTableName); $clearingType = $_POST['clearingTypes']; $description = $_POST['description']; $textFinding = $_POST['textFinding']; $comment = $_POST['comment']; $this->copyrightDao->saveDecision($this->decisionTableName, $lastUploadEntry['pfile_fk'], $userId, $clearingType, $description, $textFinding, $comment); } $scanJobProxy = new ScanJobProxy($this->agentDao, $uploadId); $scanJobProxy->createAgentStatus(array($this->agentName)); $selectedScanners = $scanJobProxy->getLatestSuccessfulAgentIds(); $highlights = array(); if (array_key_exists($this->agentName, $selectedScanners)) { $latestXpAgentId = $selectedScanners[$this->agentName]; $highlights = $this->copyrightDao->getHighlights($uploadTreeId, $this->tableName, $latestXpAgentId, $this->typeToHighlightTypeMap); } if (count($highlights) < 1) { $vars['message'] = _("No ") . $this->tableName . _(" data is available for this file."); } /* @var $view ui_view */ $view = plugin_find("view"); $theView = $view->getView(null, null, $showHeader = 0, "", $highlights, false, true); list($pageMenu, $textView) = $theView; list($description, $textFinding, $comment, $decisionType) = $this->copyrightDao->getDecision($this->decisionTableName, $uploadEntry['pfile_fk']); $vars['description'] = $description; $vars['textFinding'] = $textFinding; $vars['comment'] = $comment; $vars['itemId'] = $uploadTreeId; $vars['uploadId'] = $uploadId; $vars['pageMenu'] = $pageMenu; $vars['textView'] = $textView; $vars['legendBox'] = $this->legendBox(); $vars['uri'] = Traceback_uri() . "?mod=" . $this->Name; $vars['optionName'] = $this->optionName; $vars['formName'] = "CopyRightForm"; $vars['ajaxAction'] = $this->ajaxAction; $vars['skipOption'] = $this->skipOption; $vars['selectedClearingType'] = $decisionType; $vars['clearingTypes'] = $copyrightDecisionMap; $vars['xptext'] = $this->xptext; $agentId = intval($request->get("agent")); $vars = array_merge($vars, $this->additionalVars($uploadId, $uploadTreeId, $agentId)); return $this->render('ui-cp-view.html.twig', $this->mergeWithDefault($vars)); }
/** * \brief Given an Upload and UploadtreePk item, display: * - The file listing for the directory, with license navigation. * - Recursively traverse the tree. * \note This is recursive! * Output goes to stdout! */ function ShowLicenseTree($Upload, $Item, $Uri, $Path = NULL) { /***** Get all the licenses PER item (file or directory) under this UploadtreePk. Save the data 3 ways: - Number of licenses PER item. - Number of items PER license. - Number of items PER license family. *****/ global $Plugins; $Time = time(); $ModLicView =& $Plugins[plugin_find_id("view-license")]; if ($Path == NULL) { $Path = array(); } /****************************************/ /* Get the items under this UploadtreePk */ $Children = DirGetList($Upload, $Item); $Name = ""; foreach ($Children as $C) { if (empty($C)) { continue; } /* Store the item information */ $IsDir = Isdir($C['ufile_mode']); $IsContainer = Iscontainer($C['ufile_mode']); $IsArtifact = Isartifact($C['ufile_mode']); /* Load licenses for the item */ $Lics = array(); LicenseGetAll($C['uploadtree_pk'], $Lics); /* Determine the hyperlinks */ if (!empty($C['pfile_fk'])) { $LinkUri = "{$Uri}&item=" . $C['uploadtree_pk']; $LinkUri = str_replace("mod=license-tree", "mod=view-license", $LinkUri); } else { $LinkUri = NULL; } if (Iscontainer($C['ufile_mode'])) { $uploadtree_pk = DirGetNonArtifact($C['uploadtree_pk']); $LicUri = "{$Uri}&item=" . $uploadtree_pk; $LicUri = str_replace("mod=license-tree", "mod=license", $LicUri); } else { $LicUri = NULL; } /* Populate the output */ ksort($Lics); $LicCount = $Lics[' Total ']; $LicSum = ""; foreach ($Lics as $Key => $Val) { if ($Key == " Total ") { continue; } if (!empty($LicSum)) { $LicSum .= ","; } $LicSum .= $Key; } /* Display the results */ if ($LicCount > 0) { $LicSum = ""; foreach ($Lics as $Key => $Val) { if ($Key == " Total ") { continue; } if (!empty($LicSum)) { $LicSum .= ","; } $LicSum .= $Key; } $Name = $C['ufile_name']; if ($IsArtifact) { $Name = str_replace("artifact.", "", $Name); } if ($this->OutputType == 'HTML') { $this->ShowOutputHTML($LicCount, $LicSum, $IsContainer, $IsArtifact, $IsDir, $Path, $Name, $LicUri, $LinkUri); } else { if ($this->OutputType == 'CSV') { $this->ShowOutputCSV($LicCount, $LicSum, $IsContainer, $IsArtifact, $IsDir, $Path, $Name, $LicUri, $LinkUri); } } } /* Recurse! */ if (($IsDir || $IsContainer) && $LicCount > 0) { $NewPath = $Path; $NewPath[] = $Name; $this->ShowLicenseTree($Upload, $C['uploadtree_pk'], $Uri, $NewPath); } } /* for each item in the directory */ flush(); }
/** * \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 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 $PG_CONN; $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 $key => $value) { if ($value->Name == 'Tag' or $value->Name == 'Compare') { $MenuTag[] = $value; } } /* Get the (non artifact) children */ $Results = GetNonArtifactChildren($Item, $uploadtree_tablename); $ShowSomething = 0; $V .= "<table class='text' style='border-collapse: collapse' border=0 padding=0>\n"; foreach ($Results as $Row) { if (empty($Row['uploadtree_pk'])) { continue; } $ShowSomething = 1; $Link = NULL; $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 */ $sql = "select uploadtree_pk from uploadtree\n where parent={$Row['uploadtree_pk']} limit 1"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $HasChildren = pg_num_rows($result); pg_free_result($result); $Parm = "upload={$Upload}&show={$Show}&item=" . $Row['uploadtree_pk']; if ($HasChildren) { $Link = $Uri . "&show={$Show}&upload={$Upload}&item=" . $Row['uploadtree_pk']; } /* Show details children */ 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>"; } } /* Display item */ $V .= "<td>"; if (Iscontainer($Row['ufile_mode'])) { $V .= "<b>"; } if (!empty($Link)) { $V .= "<a href='{$Link}'>"; } $V .= $Name; if (Isdir($Row['ufile_mode'])) { $V .= "/"; } if (!empty($Link)) { $V .= "</a>"; } if (Iscontainer($Row['ufile_mode'])) { $V .= "</b>"; } $V .= "</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); } } $V .= "</td>"; } /* 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 generate the link for one side of a diff element. * * \param $MasterRow - Master row * \param $side * \param $agent_pk - agent id * \param $filter - filter * \param $plugin * \param $ModLicView * \param $uploadtree_pk1 - uploadtree pk1 * \param $uploadtree_pk2 - uploadtree pk2 * * \return the link for one side of a diff element */ function GetDiffLink($MasterRow, $side, $agent_pk, $filter, $plugin, $ModLicView, $uploadtree_pk1, $uploadtree_pk2) { /* calculate opposite side number */ if ($side == 1) { $OppositeSide = 2; $OppositeItem = $uploadtree_pk2; } else { $OppositeSide = 1; $OppositeItem = $uploadtree_pk1; } $OppositeChild = $MasterRow[$OppositeSide]; $Child = $MasterRow[$side]; /* if the opposite column element is empty, then use the original uploadtree_pk */ if (empty($OppositeChild)) { $OppositeParm = "&item{$OppositeSide}={$OppositeItem}"; } else { $OppositeParm = "&item{$OppositeSide}={$OppositeChild['uploadtree_pk']}"; } $IsDir = Isdir($Child['ufile_mode']); $IsContainer = Iscontainer($Child['ufile_mode']); /* Determine the hyperlink for non-containers to view-license */ if (!empty($Child['pfile_fk']) && !empty($ModLicView)) { $LinkUri = Traceback_uri(); $LinkUri .= "?mod=view-license&napk={$agent_pk}&upload={$Child['upload_fk']}&item={$Child['uploadtree_pk']}"; } else { $LinkUri = NULL; } /* Determine link for containers */ if (Iscontainer($Child['ufile_mode'])) { $Container_uploadtree_pk = $Child['uploadtree_pk']; $LicUri = "?mod={$plugin->Name}&item{$side}={$Child['uploadtree_pk']}{$OppositeParm}&col={$side}"; if (!empty($filter)) { $LicUri .= "&filter={$filter}"; } } else { $LicUri = NULL; } $HasHref = 0; $HasBold = 0; $Flink = ""; if ($IsContainer) { $Flink = "<a href='{$LicUri}'>"; $HasHref = 1; $Flink .= "<b>"; $HasBold = 1; } else { if (!empty($LinkUri)) { $Flink .= "<a href='{$LinkUri}'>"; $HasHref = 1; } } $Flink .= $Child['ufile_name']; if ($IsDir) { $Flink .= "/"; } if ($HasBold) { $Flink .= "</b>"; } if ($HasHref) { $Flink .= "</a>"; } return $Flink; }
/** * @return bool */ public function isFile() { return !Isartifact($this->fileMode) && !Isdir($this->fileMode) && !Iscontainer($this->fileMode); }
/** * \brief Get an html linked string of a file browse path. * * \param $Mod - Module name (e.g. "browse") * \param $UploadtreePk * \param $LinkLast - create link (a href) for last item and use LinkLast as the module name * \param $ShowBox - true to draw a box around the string * \param $ShowMicro - true to show micro menu * \param $Enumerate - if >= zero number the folder/file path (the stuff in the yellow bar) * starting with the value $Enumerate * \param $PreText - optional additional text to preceed the folder path * \param $PostText - optional text to follow the folder path * \param $uploadtree_tablename * * \return string of browse paths */ function Dir2Browse($Mod, $UploadtreePk, $LinkLast = NULL, $ShowBox = 1, $ShowMicro = NULL, $Enumerate = -1, $PreText = '', $PostText = '', $uploadtree_tablename = "uploadtree") { $V = ""; if ($ShowBox) { $V .= "<div style='border: thin dotted gray; background-color:lightyellow'>\n"; } if ($Enumerate >= 0) { $V .= "<table border=0 width='100%'><tr><td width='5%'>"; $V .= "<font size='+2'>" . number_format($Enumerate, 0, "", ",") . ":</font>"; $V .= "</td><td>"; } $Opt = Traceback_parm_keep(array("folder", "show")); $Uri = Traceback_uri() . "?mod={$Mod}"; /* Get array of upload recs for this path, in top down order. This does not contain artifacts. */ $Path = Dir2Path($UploadtreePk, $uploadtree_tablename); $Last =& $Path[count($Path) - 1]; $V .= "<font class='text'>\n"; /* Add in additional text */ if (!empty($PreText)) { $V .= "{$PreText}<br>\n"; } /* Get the FOLDER list for the upload */ $text = _("Folder"); $V .= "<b>{$text}</b>: "; if (array_key_exists(0, $Path)) { $List = FolderGetFromUpload($Path[0]['upload_fk']); $Uri2 = Traceback_uri() . "?mod=browse" . Traceback_parm_keep(array("show")); for ($i = 0; $i < count($List); $i++) { $Folder = $List[$i]['folder_pk']; $FolderName = htmlentities($List[$i]['folder_name']); $V .= "<b><a href='{$Uri2}&folder={$Folder}'>{$FolderName}</a></b>/ "; } } $FirstPath = 1; /* every firstpath belongs on a new line */ /* Print the upload, itself (on the next line since it is not a folder) */ if (count($Path) == -1) { $Upload = $Path[0]['upload_fk']; $UploadName = htmlentities($Path[0]['ufile_name']); $UploadtreePk = $Path[0]['uploadtree_pk']; $V .= "<br><b><a href='{$Uri2}&folder={$Folder}&upload={$Upload}&item={$UploadtreePk}'>{$UploadName}</a></b>"; // $FirstPath=0; } else { $V .= "<br>"; } /* Show the path within the upload */ if ($FirstPath != 0) { for ($p = 0; !empty($Path[$p]['uploadtree_pk']); $p++) { $P =& $Path[$p]; if (empty($P['ufile_name'])) { continue; } $UploadtreePk = $P['uploadtree_pk']; if (!$FirstPath) { $V .= "/ "; } if (!empty($LinkLast) || $P != $Last) { if ($P == $Last) { $Uri = Traceback_uri() . "?mod={$LinkLast}"; } $V .= "<a href='{$Uri}&upload=" . $P['upload_fk'] . $Opt . "&item=" . $UploadtreePk . "'>"; } if (Isdir($P['ufile_mode'])) { $V .= $P['ufile_name']; } else { if (!$FirstPath && Iscontainer($P['ufile_mode'])) { $V .= "<br>\n "; } $V .= "<b>" . $P['ufile_name'] . "</b>"; } if (!empty($LinkLast) || $P != $Last) { $V .= "</a>"; } $FirstPath = 0; } } $V .= "</font>\n"; if (!empty($ShowMicro)) { $MenuDepth = 0; /* unused: depth of micro menu */ $V .= menu_to_1html(menu_find($ShowMicro, $MenuDepth), 1); } if ($Enumerate >= 0) { if ($PostText) { $V .= " {$PostText}"; } $V .= "</td></tr></table>"; } if ($ShowBox) { $V .= "</div>\n"; } return $V; }
/** * \brief Given an $Uploadtree_pk, display: \n * (1) The histogram for the directory BY bucket. \n * (2) The file listing for the directory. */ function ShowUploadHist($Uploadtree_pk, $Uri) { global $PG_CONN; $VF = ""; // return values for file listing $VLic = ""; // return values for output $V = ""; // total return value $UniqueTagArray = array(); global $Plugins; $ModLicView =& $Plugins[plugin_find_id("view-license")]; /******* Get Bucket names and counts ******/ /* Find lft and rgt bounds for this $Uploadtree_pk */ $sql = "SELECT lft,rgt,upload_fk FROM {$this->uploadtree_tablename}\n WHERE uploadtree_pk = {$Uploadtree_pk}"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); if (pg_num_rows($result) < 1) { pg_free_result($result); $text = _("Invalid URL, nonexistant item"); return "<h2>{$text} {$Uploadtree_pk}</h2>"; } $row = pg_fetch_assoc($result); $lft = $row["lft"]; $rgt = $row["rgt"]; $upload_pk = $row["upload_fk"]; pg_free_result($result); /* Get the ars_pk of the scan to display, also the select list */ $ars_pk = GetArrayVal("ars", $_GET); $BucketSelect = SelectBucketDataset($upload_pk, $ars_pk, "selectbdata", "onchange=\"addArsGo('newds','selectbdata');\""); if ($ars_pk == 0) { /* No bucket data for this upload */ return $BucketSelect; } /* Get scan keys */ $sql = "select agent_fk, nomosagent_fk, bucketpool_fk from bucket_ars where ars_pk={$ars_pk}"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); $bucketagent_pk = $row["agent_fk"]; $nomosagent_pk = $row["nomosagent_fk"]; $bucketpool_pk = $row["bucketpool_fk"]; pg_free_result($result); /* Create bucketDefArray as individual query this is MUCH faster than incorporating it with a join in the following queries. */ $bucketDefArray = initBucketDefArray($bucketpool_pk); /*select all the buckets for entire tree for this bucketpool */ $sql = "SELECT distinct(bucket_fk) as bucket_pk,\n count(bucket_fk) as bucketcount, bucket_reportorder\n from bucket_file, bucket_def,\n (SELECT distinct(pfile_fk) as PF from {$this->uploadtree_tablename} \n where upload_fk={$upload_pk} \n and ((ufile_mode & (1<<28))=0)\n and ((ufile_mode & (1<<29))=0)\n and {$this->uploadtree_tablename}.lft BETWEEN {$lft} and {$rgt}) as SS\n where PF=pfile_fk and agent_fk={$bucketagent_pk} \n and bucket_file.nomosagent_fk={$nomosagent_pk}\n and bucket_pk=bucket_fk\n and bucketpool_fk={$bucketpool_pk}\n group by bucket_fk,bucket_reportorder\n order by bucket_reportorder asc"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $historows = pg_fetch_all($result); pg_free_result($result); /* Show dataset list */ if (!empty($BucketSelect)) { $action = Traceback_uri() . "?mod=bucketbrowser&upload={$upload_pk}&item={$Uploadtree_pk}"; $VLic .= "<script type='text/javascript'>\nfunction addArsGo(formid, selectid ) \n{\nvar selectobj = document.getElementById(selectid);\nvar ars_pk = selectobj.options[selectobj.selectedIndex].value;\ndocument.getElementById(formid).action='{$action}'+'&ars='+ars_pk;\ndocument.getElementById(formid).submit();\nreturn;\n}\n</script>"; /* form to select new dataset (ars_pk) */ $VLic .= "<form action='{$action}' id='newds' method='POST'>\n"; $VLic .= $BucketSelect; $VLic .= "</form>"; } $sql = "select bucketpool_name, version from bucketpool where bucketpool_pk={$bucketpool_pk}"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); $bucketpool_name = $row['bucketpool_name']; $bucketpool_version = $row['version']; pg_free_result($result); /* Write bucket histogram to $VLic */ $bucketcount = 0; $Uniquebucketcount = 0; $NoLicFound = 0; if (is_array($historows)) { $text = _("Bucket Pool"); $VLic .= "{$text}: {$bucketpool_name} v{$bucketpool_version}<br>"; $VLic .= "<table border=1 width='100%'>\n"; $text = _("Count"); $VLic .= "<tr><th width='10%'>{$text}</th>"; $text = _("Files"); $VLic .= "<th width='10%'>{$text}</th>"; $text = _("Bucket"); $VLic .= "<th align='left'>{$text}</th></tr>\n"; foreach ($historows as $bucketrow) { $Uniquebucketcount++; $bucket_pk = $bucketrow['bucket_pk']; $bucketcount = $bucketrow['bucketcount']; $bucket_name = $bucketDefArray[$bucket_pk]['bucket_name']; $bucket_color = $bucketDefArray[$bucket_pk]['bucket_color']; /* Count */ $VLic .= "<tr><td align='right' style='background-color:{$bucket_color}'>{$bucketcount}</td>"; /* Show */ $VLic .= "<td align='center'><a href='"; $VLic .= Traceback_uri(); $text = _("Show"); $VLic .= "?mod=list_bucket_files&bapk={$bucketagent_pk}&item={$Uploadtree_pk}&bpk={$bucket_pk}&bp={$bucketpool_pk}&napk={$nomosagent_pk}" . "'>{$text}</a></td>"; /* Bucket name */ $VLic .= "<td align='left'>"; $VLic .= "<a id='{$bucket_pk}' onclick='FileColor_Get(\"" . Traceback_uri() . "?mod=ajax_filebucket&bapk={$bucketagent_pk}&item={$Uploadtree_pk}&bucket_pk={$bucket_pk}\")'"; $VLic .= ">{$bucket_name} </a>"; /* Allow users to tag an entire bucket */ /* Future, maybe v 2.1 $TagHref = "<a href=" . Traceback_uri() . "?mod=bucketbrowser&upload=$upload_pk&item=$Uploadtree_pk&bapk=$bucketagent_pk&bpk=$bucket_pk&bp=$bucketpool_pk&napk=$nomosagent_pk&tagbucket=1>Tag</a>"; $VLic .= " [$TagHref]"; */ $VLic .= "</td>"; $VLic .= "</tr>\n"; // if ($row['bucket_name'] == "No Buckets Found") $NoLicFound = $row['bucketcount']; } $VLic .= "</table>\n"; $VLic .= "<p>\n"; $text = _("Unique buckets"); $VLic .= "{$text}: {$Uniquebucketcount}<br>\n"; } /******* File Listing ************/ /* Get ALL the items under this Uploadtree_pk */ $Children = GetNonArtifactChildren($Uploadtree_pk, $this->uploadtree_tablename); if (count($Children) == 0) { $sql = "SELECT * FROM {$this->uploadtree_tablename} WHERE uploadtree_pk = '{$Uploadtree_pk}'"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); pg_free_result($result); if (empty($row) || IsDir($row['ufile_mode'])) { return; } // $ModLicView = &$Plugins[plugin_find_id("view-license")]; // return($ModLicView->Output() ); } $ChildCount = 0; $Childbucketcount = 0; /* Countd disabled until we know we need them $NumSrcPackages = 0; $NumBinPackages = 0; $NumBinNoSrcPackages = 0; */ /* get mimetypes for packages */ $MimetypeArray = GetPkgMimetypes(); $VF .= "<table border=0>"; foreach ($Children as $C) { if (empty($C)) { continue; } /* update package counts */ /* This is an expensive count. Comment out until we know we really need it IncrSrcBinCounts($C, $MimetypeArray, $NumSrcPackages, $NumBinPackages, $NumBinNoSrcPackages); */ $IsDir = Isdir($C['ufile_mode']); $IsContainer = Iscontainer($C['ufile_mode']); /* Determine the hyperlink for non-containers to view-license */ if (!empty($C['pfile_fk']) && !empty($ModLicView)) { $LinkUri = Traceback_uri(); $LinkUri .= "?mod=view-license&napk={$nomosagent_pk}&bapk={$bucketagent_pk}&upload={$upload_pk}&item={$C['uploadtree_pk']}"; } else { $LinkUri = NULL; } /* Determine link for containers */ if (Iscontainer($C['ufile_mode'])) { $uploadtree_pk = DirGetNonArtifact($C['uploadtree_pk'], $this->uploadtree_tablename); $tmpuri = "?mod=" . $this->Name . Traceback_parm_keep(array("upload", "folder", "ars")); $LicUri = "{$tmpuri}&item=" . $uploadtree_pk; } else { $LicUri = NULL; } /* Populate the output ($VF) - file list */ /* id of each element is its uploadtree_pk */ $VF .= "<tr><td id='{$C['uploadtree_pk']}' align='left'>"; $HasHref = 0; $HasBold = 0; if ($IsContainer) { $VF .= "<a href='{$LicUri}'>"; $HasHref = 1; $VF .= "<b>"; $HasBold = 1; } else { if (!empty($LinkUri)) { $VF .= "<a href='{$LinkUri}'>"; $HasHref = 1; } } $VF .= $C['ufile_name']; if ($IsDir) { $VF .= "/"; } if ($HasBold) { $VF .= "</b>"; } if ($HasHref) { $VF .= "</a>"; } /* print buckets */ $VF .= "<br>"; $VF .= "<span style='position:relative;left:1em'>"; /* get color coded string of bucket names */ $VF .= GetFileBuckets_string($nomosagent_pk, $bucketagent_pk, $C['uploadtree_pk'], $bucketDefArray, ",", True); $VF .= "</span>"; $VF .= "</td><td valign='top'>"; /* display item links */ $VF .= FileListLinks($C['upload_fk'], $C['uploadtree_pk'], $nomosagent_pk, $C['pfile_fk'], True, $UniqueTagArray, $this->uploadtree_tablename); $VF .= "</td>"; $VF .= "</tr>\n"; $ChildCount++; } $VF .= "</table>\n"; $V .= ActiveHTTPscript("FileColor"); /* Add javascript for color highlighting This is the response script needed by ActiveHTTPscript responseText is bucket_pk',' followed by a comma seperated list of uploadtree_pk's */ $script = "\n <script type=\"text/javascript\" charset=\"utf-8\">\n var Lastutpks=''; /* save last list of uploadtree_pk's */\n var Lastbupk=''; /* save last bucket_pk */\n var color = '#4bfe78';\n function FileColor_Reply()\n {\n if ((FileColor.readyState==4) && (FileColor.status==200))\n {\n /* remove previous highlighting */\n var numpks = Lastutpks.length;\n if (numpks > 0) document.getElementById(Lastbupk).style.backgroundColor='white';\n while (numpks)\n {\n document.getElementById(Lastutpks[--numpks]).style.backgroundColor='white';\n }\n\n utpklist = FileColor.responseText.split(',');\n Lastbupk = utpklist.shift();\n numpks = utpklist.length;\n Lastutpks = utpklist;\n\n /* apply new highlighting */\n elt = document.getElementById(Lastbupk);\n if (elt != null) elt.style.backgroundColor=color;\n while (numpks)\n {\n document.getElementById(utpklist[--numpks]).style.backgroundColor=color;\n }\n }\n return;\n }\n </script>\n "; $V .= $script; /* Display source, binary, and binary missing source package counts */ /* Counts disabled above until we know we need these $VLic .= "<ul>"; $text = _("source packages"); $VLic .= "<li> $NumSrcPackages $text"; $text = _("binary packages"); $VLic .= "<li> $NumBinPackages $text"; $text = _("binary packages with no source package"); $VLic .= "<li> $NumBinNoSrcPackages $text"; $VLic .= "</ul>"; */ /* Combine VF and VLic */ $V .= "<table border=0 width='100%'>\n"; $V .= "<tr><td valign='top' width='50%'>{$VLic}</td><td valign='top'>{$VF}</td></tr>\n"; $V .= "</table>\n"; $V .= "<hr />\n"; return $V; }
/** * \brief Display the edit tag page. */ function ShowEditTagPage($Upload, $Item) { global $PG_CONN; $VEd = ""; $text = _("Create New Tag"); $VEd .= "<h4><a href='" . Traceback_uri() . "?mod=tag&upload={$Upload}&item={$Item}'>{$text}</a><h4>"; $VEd .= _("<h3>Edit Tag:</h3>\n"); $tag_file_pk = GetParm("tag_file_pk", PARM_INTEGER); /* Get ufile_name from uploadtree_pk */ $sql = "SELECT ufile_name, ufile_mode FROM uploadtree\n WHERE uploadtree_pk = {$Item}"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); $ufile_name = $row["ufile_name"]; $ufile_mode = $row["ufile_mode"]; pg_free_result($result); /* Get all information about $tag_file_pk (tag_file/tag_uploadtree table)*/ if (Isdir($ufile_mode)) { $sql = "SELECT tag_pk, tag_uploadtree_text, tag, tag_desc FROM tag_uploadtree, tag WHERE tag_uploadtree_pk={$tag_file_pk} AND tag_uploadtree.tag_fk = tag.tag_pk"; } else { $sql = "SELECT tag_pk, tag_file_text, tag, tag_desc FROM tag_file, tag WHERE tag_file_pk={$tag_file_pk} AND tag_file.tag_fk = tag.tag_pk"; } $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $row = pg_fetch_assoc($result); $tag_pk = $row['tag_pk']; $tag = $row['tag']; if (Isdir($ufile_mode)) { $tag_notes = $row['tag_uploadtree_text']; } else { $tag_notes = $row['tag_file_text']; } $tag_desc = $row['tag_desc']; pg_free_result($result); $VEd .= "<form name='form' method='POST' action='" . Traceback_uri() . "?mod=tag&upload={$Upload}&item={$Item}'>\n"; $VEd .= "<p>"; $text = _("Tag"); $VEd .= "{$text}: <input type='text' id='tag_name' name='tag_name' autocomplete='off' onclick='Tags_Get(\"" . Traceback_uri() . "?mod=tag_get&uploadtree_pk={$Item}\")' value=\"{$tag}\"/> "; $text = _("Tag description:"); $VEd .= "<p>{$text} <input type='text' name='tag_desc' value=\"{$tag_desc}\"/></p>"; $VEd .= _("<p>Notes:</p>"); $VEd .= "<p><textarea rows='10' cols='80' name='tag_notes'>{$tag_notes}</textarea></p>"; if (Isdir($ufile_mode)) { $VEd .= "<p><input type='hidden' name='tag_dir' value='1'/></p>"; } else { if (Iscontainer($ufile_mode)) { /* $text = _("Tag this files only."); $VEd .= "<p><input type='checkbox' name='tag_file' value='1' checked/>$text</p>"; $text = _("Tag all packages (source and binary) in this container tree."); $VEd .= "<p><input type='checkbox' name='tag_package' value='1'/> $text</p>"; $text = _("Tag every file in this container tree."); $VEd .= "<p><input type='checkbox' name='tag_container' value='1'/> $text</p>"; */ $VEd .= "<p><input type='hidden' name='tag_file' value='1'/></p>"; } else { $VEd .= "<p><input type='hidden' name='tag_file' value='1'/></p>"; } } $text = _("Save"); $VEd .= "<input type='hidden' name='action' value='update'/>\n"; $VEd .= "<input type='hidden' name='tag_pk' value='{$tag_pk}'/>\n"; $VEd .= "<input type='hidden' name='tag_file_pk' value='{$tag_file_pk}'/>\n"; $VEd .= "<input type='submit' value='{$text}'>\n"; $VEd .= "</form>\n"; return $VEd; }