/**
* \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 Return the entire <td> ... </td> for $Child file listing table
* differences are highlighted.
* @param $Child
* @param $agent_pk
* @param $OtherChild
* @param $BucketDefArray
*
* @return the entire html <td> ... </td> for $Child file listing table
* differences are highlighted.
*/
function ChildElt($Child, $agent_pk, $OtherChild, $BucketDefArray)
{
$UniqueTagArray = array();
$bucketstr = $Child['bucketstr'];
/* If both $Child and $OtherChild are specified,
* reassemble bucketstr and highlight the differences
*/
if ($OtherChild and $OtherChild) {
$bucketstr = "";
foreach ($Child['bucketarray'] as $bucket_pk) {
$bucket_color = $BucketDefArray[$bucket_pk]['bucket_color'];
$BucketStyle = "style='color:#606060;background-color:{$bucket_color}'";
$DiffStyle = "style='background-color:{$bucket_color};text-decoration:underline;text-transform:uppercase;border-style:outset'";
$bucket_name = $BucketDefArray[$bucket_pk]['bucket_name'];
if (!empty($bucketstr)) {
$bucketstr .= ", ";
}
if (in_array($bucket_pk, $OtherChild['bucketarray'])) {
/* license is in both $Child and $OtherChild */
$Style = $BucketStyle;
} else {
/* license is missing from $OtherChild */
$Style = $DiffStyle;
}
$bucketstr .= "<span {$Style}>{$bucket_name}</span>";
}
}
$ColStr = "<td id='{$Child['uploadtree_pk']}' align='left'>";
$ColStr .= "{$Child['linkurl']}";
/* show buckets under file name */
$ColStr .= "<br>";
$ColStr .= "<span style='position:relative;left:1em'>";
$ColStr .= $bucketstr;
$ColStr .= "</span>";
$ColStr .= "</td>";
/* display file links if this is a real file */
$ColStr .= "<td valign='top'>";
$uploadtree_tablename = GetUploadtreeTableName($Child['upload_fk']);
$ColStr .= FileListLinks($Child['upload_fk'], $Child['uploadtree_pk'], $agent_pk, $Child['pfile_fk'], True, $UniqueTagArray, $uploadtree_tablename);
$ColStr .= "</td>";
return $ColStr;
}
/**
* \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 get the entire <td> ... </td> for $Child file listing table
* License differences are highlighted.
*/
function ChildElt($Child, $agent_pk, $OtherChild)
{
$UniqueTagArray = array();
$licstr = $Child['licstr'];
/* If both $Child and $OtherChild are specified,
* reassemble licstr and highlight the differences
*/
if ($OtherChild and $OtherChild) {
$licstr = "";
$DiffLicStyle = "style='background-color:#ffa8a8'";
// mid red pastel
foreach ($Child['licarray'] as $rf_pk => $rf_shortname) {
if (!empty($licstr)) {
$licstr .= ", ";
}
if (@$OtherChild['licarray'][$rf_pk]) {
/* license is in both $Child and $OtherChild */
$licstr .= $rf_shortname;
} else {
/* license is missing from $OtherChild */
$licstr .= "<span {$DiffLicStyle}>{$rf_shortname}</span>";
}
}
}
$ColStr = "<td id='{$Child['uploadtree_pk']}' align='left'>";
$ColStr .= "{$Child['linkurl']}";
/* show licenses under file name */
$ColStr .= "<br>";
$ColStr .= "<span style='position:relative;left:1em'>";
$ColStr .= $licstr;
$ColStr .= "</span>";
$ColStr .= "</td>";
/* display item links */
$ColStr .= "<td valign='top'>";
$uploadtree_tablename = GetUploadtreeTableName($Child['upload_fk']);
$ColStr .= FileListLinks($Child['upload_fk'], $Child['uploadtree_pk'], $agent_pk, $Child['pfile_fk'], True, $UniqueTagArray, $uploadtree_tablename);
$ColStr .= "</td>";
return $ColStr;
}
/**
* @param array $child
* @param int $uploadId
* @param int $selectedAgentId
* @param array $pfileLicenses
* @param int $groupId
* @param string $uri
* @param array $UniqueTagArray
* @param boolean $isFlat
* @param int[] $latestSuccessfulAgentIds
* @return array
*/
private function createFileDataRow($child, $uploadId, $selectedAgentId, $pfileLicenses, $groupId, $uri, &$UniqueTagArray, $isFlat, $latestSuccessfulAgentIds)
{
$fileId = $child['pfile_fk'];
$childUploadTreeId = $child['uploadtree_pk'];
$linkUri = '';
if (!empty($fileId)) {
$linkUri = Traceback_uri();
$linkUri .= "?mod=view-license&upload={$uploadId}&item={$childUploadTreeId}";
if ($selectedAgentId) {
$linkUri .= "&agentId={$selectedAgentId}";
}
}
/* Determine link for containers */
$isContainer = Iscontainer($child['ufile_mode']);
if ($isContainer && !$isFlat) {
$uploadtree_pk = $child['uploadtree_pk'];
$linkUri = "{$uri}&item=" . $uploadtree_pk;
if ($selectedAgentId) {
$linkUri .= "&agentId={$selectedAgentId}";
}
} else {
if ($isContainer) {
$uploadtree_pk = Isartifact($child['ufile_mode']) ? DirGetNonArtifact($childUploadTreeId, $this->uploadtree_tablename) : $childUploadTreeId;
$linkUri = "{$uri}&item=" . $uploadtree_pk;
if ($selectedAgentId) {
$linkUri .= "&agentId={$selectedAgentId}";
}
}
}
/* Populate the output ($VF) - file list */
/* id of each element is its uploadtree_pk */
$fileName = $child['ufile_name'];
if ($isContainer) {
$fileName = "<a href='{$linkUri}'><span style='color: darkblue'> <b>{$fileName}</b> </span></a>";
} else {
if (!empty($linkUri)) {
$fileName = "<a href='{$linkUri}'>{$fileName}</a>";
}
}
/* show licenses under file name */
$childItemTreeBounds = new ItemTreeBounds($childUploadTreeId, $this->uploadtree_tablename, $child['upload_fk'], $child['lft'], $child['rgt']);
$licenseEntries = array();
if ($isContainer) {
$agentFilter = $selectedAgentId ? array($selectedAgentId) : $latestSuccessfulAgentIds;
$licenseEntries = $this->licenseDao->getLicenseShortnamesContained($childItemTreeBounds, $agentFilter, array());
} else {
if (array_key_exists($fileId, $pfileLicenses)) {
foreach ($pfileLicenses[$fileId] as $shortName => $rfInfo) {
$agentEntries = array();
foreach ($rfInfo as $agent => $match) {
$agentName = $this->agentNames[$agent];
$agentEntry = "<a href='?mod=view-license&upload={$child['upload_fk']}&item={$childUploadTreeId}&format=text&agentId={$match['agent_id']}&licenseId={$match['license_id']}#highlight'>" . $agentName . "</a>";
if ($match['match_percentage'] > 0) {
$agentEntry .= ": {$match['match_percentage']}%";
}
$agentEntries[] = $agentEntry;
}
$licenseEntries[] = $shortName . " [" . implode("][", $agentEntries) . "]";
}
}
}
$licenseList = implode(', ', $licenseEntries);
$fileListLinks = FileListLinks($uploadId, $childUploadTreeId, 0, $fileId, true, $UniqueTagArray, $this->uploadtree_tablename, !$isFlat);
if (!$isContainer) {
$text = _("Copyright/Email/Url");
$fileListLinks .= "[<a href='" . Traceback_uri() . "?mod=copyright-view&upload={$uploadId}&item={$childUploadTreeId}' >{$text}</a>]";
$text = _("ReadMe_OSS");
$fileListLinks .= "[<a href='" . Traceback_uri() . "?mod=ui_readmeoss&upload={$uploadId}&item={$childUploadTreeId}' >{$text}</a>]";
$text = _("SPDX");
$fileListLinks .= "[<a href='" . Traceback_uri() . "?mod=ui_spdx2&upload={$uploadId}&item={$childUploadTreeId}' >{$text}</a>]";
}
return array($fileName, $licenseList, $fileListLinks);
}
/**
* @param array $child
* @param int $uploadId
* @param int $selectedAgentId
* @param array $pfileLicenses
* @param int $groupId
* @param ClearingDecision[][] $editedMappedLicenses
* @param string $uri
* @param null|ClearingView $ModLicView
* @param array $UniqueTagArray
* @param boolean $isFlat
* @param int[] $latestSuccessfulAgentIds
* @return array
*/
private function createFileDataRow($child, $uploadId, $selectedAgentId, $pfileLicenses, $groupId, $editedMappedLicenses, $uri, $ModLicView, &$UniqueTagArray, $isFlat, $latestSuccessfulAgentIds)
{
$fileId = $child['pfile_fk'];
$childUploadTreeId = $child['uploadtree_pk'];
$linkUri = '';
if (!empty($fileId) && !empty($ModLicView)) {
$linkUri = Traceback_uri();
$linkUri .= "?mod=view-license&upload={$uploadId}&item={$childUploadTreeId}";
if ($selectedAgentId) {
$linkUri .= "&agentId={$selectedAgentId}";
}
}
/* Determine link for containers */
$isContainer = Iscontainer($child['ufile_mode']);
if ($isContainer && !$isFlat) {
$fatChild = $this->uploadDao->getFatItemArray($child['uploadtree_pk'], $uploadId, $this->uploadtree_tablename);
$uploadtree_pk = $fatChild['item_id'];
$linkUri = "{$uri}&item=" . $uploadtree_pk;
if ($selectedAgentId) {
$linkUri .= "&agentId={$selectedAgentId}";
}
$child['ufile_name'] = $fatChild['ufile_name'];
if (!Iscontainer($fatChild['ufile_mode'])) {
$isContainer = false;
}
} else {
if ($isContainer) {
$uploadtree_pk = Isartifact($child['ufile_mode']) ? DirGetNonArtifact($childUploadTreeId, $this->uploadtree_tablename) : $childUploadTreeId;
$linkUri = "{$uri}&item=" . $uploadtree_pk;
if ($selectedAgentId) {
$linkUri .= "&agentId={$selectedAgentId}";
}
}
}
/* Populate the output ($VF) - file list */
/* id of each element is its uploadtree_pk */
$fileName = $child['ufile_name'];
if ($isContainer) {
$fileName = "<a href='{$linkUri}'><span style='color: darkblue'> <b>{$fileName}</b> </span></a>";
} else {
if (!empty($linkUri)) {
$fileName = "<a href='{$linkUri}'>{$fileName}</a>";
}
}
/* show licenses under file name */
$childItemTreeBounds = new ItemTreeBounds($childUploadTreeId, $this->uploadtree_tablename, $child['upload_fk'], $child['lft'], $child['rgt']);
if ($isContainer) {
$agentFilter = $selectedAgentId ? array($selectedAgentId) : $latestSuccessfulAgentIds;
$licenseEntries = $this->licenseDao->getLicenseShortnamesContained($childItemTreeBounds, $agentFilter, array());
$editedLicenses = $this->clearingDao->getClearedLicenses($childItemTreeBounds, $groupId);
} else {
$licenseEntries = array();
if (array_key_exists($fileId, $pfileLicenses)) {
foreach ($pfileLicenses[$fileId] as $shortName => $rfInfo) {
$agentEntries = array();
foreach ($rfInfo as $agent => $match) {
$agentName = $this->agentNames[$agent];
$agentEntry = "<a href='?mod=view-license&upload={$child['upload_fk']}&item={$childUploadTreeId}&format=text&agentId={$match['agent_id']}&licenseId={$match['license_id']}#highlight'>" . $agentName . "</a>";
if ($match['match_percentage'] > 0) {
$agentEntry .= ": {$match['match_percentage']}%";
}
$agentEntries[] = $agentEntry;
}
$licenseEntries[] = $shortName . " [" . implode("][", $agentEntries) . "]";
}
}
/* @var $decision ClearingDecision */
if (false !== ($decision = $this->clearingFilter->getDecisionOf($editedMappedLicenses, $childUploadTreeId, $fileId))) {
$editedLicenses = $decision->getPositiveLicenses();
} else {
$editedLicenses = array();
}
}
$concludedLicenses = array();
/** @var LicenseRef $licenseRef */
foreach ($editedLicenses as $licenseRef) {
$projectedId = $this->licenseProjector->getProjectedId($licenseRef->getId());
$projectedName = $this->licenseProjector->getProjectedShortname($licenseRef->getId(), $licenseRef->getShortName());
$concludedLicenses[$projectedId] = $projectedName;
}
$editedLicenseList = implode(', ', $concludedLicenses);
$licenseList = implode(', ', $licenseEntries);
$fileListLinks = FileListLinks($uploadId, $childUploadTreeId, 0, $fileId, true, $UniqueTagArray, $this->uploadtree_tablename, !$isFlat);
$getTextEditUser = _("Edit");
$fileListLinks .= "[<a href='#' onclick='openUserModal({$childUploadTreeId})' >{$getTextEditUser}</a>]";
if ($isContainer) {
$getTextEditBulk = _("Bulk");
$fileListLinks .= "[<a href='#' onclick='openBulkModal({$childUploadTreeId})' >{$getTextEditBulk}</a>]";
}
$filesThatShouldStillBeCleared = array_key_exists($childItemTreeBounds->getItemId(), $this->filesThatShouldStillBeCleared) ? $this->filesThatShouldStillBeCleared[$childItemTreeBounds->getItemId()] : 0;
$filesToBeCleared = array_key_exists($childItemTreeBounds->getItemId(), $this->filesToBeCleared) ? $this->filesToBeCleared[$childItemTreeBounds->getItemId()] : 0;
$filesCleared = $filesToBeCleared - $filesThatShouldStillBeCleared;
$img = $filesCleared == $filesToBeCleared ? 'green' : 'red';
return array($fileName, $licenseList, $editedLicenseList, $img, "{$filesCleared}/{$filesToBeCleared}", $fileListLinks);
}
