bucket-diff.php

<?php
/*
 SPDX-FileCopyrightText: © 2011-2014 Hewlett-Packard Development Company, L.P.
 SPDX-FileCopyrightText: © 2015 Siemens AG
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
use Fossology\Lib\Auth\Auth;
use Fossology\Lib\Dao\UploadDao;
 
class ui_diff_buckets extends FO_Plugin
{
  var  $ColumnSeparatorStyleL = "style='border:solid 0 #006600; border-left-width:2px;padding-left:1em'";
  var  $threshold  = 150;  
  function __construct()
  {
    $this->Name       = "bucketsdiff";
    $this->Title      = _("Compare Buckets Browser");
    $this->Dependency = array("browse","view");
    $this->DBaccess   = PLUGIN_DB_READ;
    $this->LoginFlag  = 0;
    parent::__construct();
  }
 
  function Install()
  {
    global $PG_CONN;
    if (empty($PG_CONN)) { return(1); } /* No DB */
 
    return(0);
  } // Install()
 
 
  function Initialize()
  {
    global $_GET;
 
    if ($this->State != PLUGIN_STATE_INVALID) { return(1); } // don't re-run
    if ($this->Name !== "") // Name must be defined
    {
      global $Plugins;
      $this->State=PLUGIN_STATE_VALID;
      $Plugins[] = $this;
    }
 
    return($this->State == PLUGIN_STATE_VALID);
  } // Initialize()
 
  function GetTreeInfo($Uploadtree_pk)
  {
    global $PG_CONN;
 
    $TreeInfo = GetSingleRec("uploadtree", "WHERE uploadtree_pk = $Uploadtree_pk");
    $TreeInfo['agent_pk'] = LatestAgentpk($TreeInfo['upload_fk'], "nomos_ars");
 
   /* Get the ars_pk of the scan to display, also the select list  */
    $ars_pk = GetArrayVal("ars", $_GET);
    $BucketSelect = SelectBucketDataset($TreeInfo['upload_fk'], $ars_pk, "selectbdata",
                                        "onchange=\"addArsGo('newds','selectbdata');\"");
    $TreeInfo['ars_pk'] = $ars_pk;
    if ($ars_pk == 0)
    {
      /* No bucket data for this upload */
      return $BucketSelect;  // $BucketSelect is error message
    }
 
    /* Get scan keys */
    $where = "where ars_pk=$ars_pk";
    $row = GetSingleRec("bucket_ars", $where);
    if (empty($row)) Fatal("No bucket data $where", __FILE__, __LINE__);
    $TreeInfo['bucketagent_pk'] = $row["agent_fk"];
    $TreeInfo['nomosagent_pk'] = $row["nomosagent_fk"];
    $TreeInfo['bucketpool_pk'] = $row["bucketpool_fk"];
    unset($row);
 
    return $TreeInfo;
  }
 
 
  function UploadHist($Uploadtree_pk, $TreeInfo, $BucketDefArray)
  {
    global $PG_CONN;
 
    $HistStr = '';
    $lft = $TreeInfo['lft'];
    $rgt = $TreeInfo['rgt'];
    $upload_pk = $TreeInfo['upload_fk'];
    $agent_pk = $TreeInfo['agent_pk'];
    $bucketagent_pk = $TreeInfo['bucketagent_pk'];
    $nomosagent_pk = $TreeInfo['nomosagent_pk'];
    $bucketpool_pk = $TreeInfo['bucketpool_pk'];
 
    /*select all the buckets for entire tree for this bucketpool */
    $sql = "SELECT distinct(bucket_fk) as bucket_pk,
                   count(bucket_fk) as bucketcount, bucket_reportorder
              from bucket_file, bucket_def,
                  (SELECT distinct(pfile_fk) as PF from uploadtree
                     where upload_fk=$upload_pk
                       and ((ufile_mode & (1<<28))=0)
                       and uploadtree.lft BETWEEN $lft and $rgt) as SS
              where PF=pfile_fk and agent_fk=$bucketagent_pk
                    and bucket_file.nomosagent_fk=$nomosagent_pk
                    and bucket_pk=bucket_fk
                    and bucketpool_fk=$bucketpool_pk
              group by bucket_fk,bucket_reportorder
              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);
 
if (false)
{
    /* Show dataset list */
    if (!empty($BucketSelect))
    {
      $action = Traceback_uri() . "?mod=bucketbrowser&upload=$upload_pk&item=$Uploadtree_pk";
 
      $HistStr .= "<script type='text/javascript'>
function addArsGo(formid, selectid )
{
var selectobj = document.getElementById(selectid);
var ars_pk = selectobj.options[selectobj.selectedIndex].value;
document.getElementById(formid).action='$action'+'&ars='+ars_pk;
document.getElementById(formid).submit();
return;
}
</script>";
 
      /* form to select new dataset (ars_pk) */
      $HistStr .= "<form action='$action' id='newds' method='POST'>\n";
      $HistStr .= $BucketSelect;
      $HistStr .= "</form>";
    }
}
 
    /* any rows? */
    if (count($historows) == 0) return $HistStr;
 
    $sql = "select bucketpool_name 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'];
    pg_free_result($result);
 
    /* Write bucket histogram to $HistStr  */
    $TotalCount = 0;
    $NoLicFound = 0;
    $HistStr .= "<table border=1 id='histogram'>\n";
 
    $text = _("Count");
    $HistStr .= "<tr><th >$text</th>";
 
    $text = _("Files");
    $HistStr .= "<th >$text</th>";
 
    $text = _("Bucket");
    $HistStr .= "<th align=left>$text</th></tr>\n";
 
    if(empty($historows))
    {
      return;
    }
    foreach ($historows as $row)
    {
      $TotalCount += $row['bucketcount'];
      $bucket_pk = $row['bucket_pk'];
      $bucketcount = $row['bucketcount'];
      $bucket_name = $BucketDefArray[$bucket_pk]['bucket_name'];
      $bucket_color = $BucketDefArray[$bucket_pk]['bucket_color'];
 
      /*  Count  */
      $HistStr .= "<tr><td align='right' style='background-color:$bucket_color'>$row[bucketcount]</td>";
 
      /*  Show  */
      $ShowTitle = _("Click Show to list files with this license.");
      $HistStr .= "<td align='center'><a href='";
      $HistStr .= Traceback_uri();
 
      $text = _("Show");
      $HistStr .= "?mod=list_bucket_files&bapk=$bucketagent_pk&item=$Uploadtree_pk&bpk=$bucket_pk&bp=$bucketpool_pk&napk=$nomosagent_pk" . "'>$text</a></td>";
 
      /*  Bucket name  */
      $HistStr .= "<td align='left'>";
      $HistStr .= "<a id='$bucket_pk' onclick='FileColor_Get(\"" . Traceback_uri() . "?mod=ajax_filebucket&bapk=$bucketagent_pk&item=$Uploadtree_pk&bucket_pk=$bucket_pk\")'";
      $HistStr .= ">$bucket_name </a>";
      $HistStr .= "</td>";
      $HistStr .= "</tr>\n";
    }
    $HistStr .= "</table>\n";
    $HistStr .= "<p>\n";
 
    return($HistStr);
  } // UploadHist()
 
 
 
  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 ($Child 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;
  }
 
 
  function ItemComparisonRows($Master, $agent_pk1, $agent_pk2, $BucketDefArray)
  {
    $TableStr = "";
    $RowStyle1 = "style='background-color:#ecfaff'";  // pale blue
    $RowStyle2 = "style='background-color:#ffffe3'";  // pale yellow
    $RowNum = 0;
 
    foreach ($Master as $key => $Pair)
    {
      $RowStyle = (++$RowNum % 2) ? $RowStyle1 : $RowStyle2;
      $TableStr .= "<tr $RowStyle>";
 
      $Child1 = GetArrayVal("1", $Pair);
      $Child2 = GetArrayVal("2", $Pair);
      if (empty($Child1))
      {
        $TableStr .= "<td></td><td></td>";
        $TableStr .= "<td $this->ColumnSeparatorStyleL>&nbsp;</td>";
        $TableStr .= $this->ChildElt($Child2, $agent_pk2, $Child1, $BucketDefArray);
      }
      else if (empty($Child2))
      {
        $TableStr .= $this->ChildElt($Child1, $agent_pk1, $Child2, $BucketDefArray);
        $TableStr .= "<td $this->ColumnSeparatorStyleL>&nbsp;</td>";
        $TableStr .= "<td></td><td></td>";
      }
      else if (!empty($Child1) and !empty($Child2))
      {
        $TableStr .= $this->ChildElt($Child1, $agent_pk1, $Child2, $BucketDefArray);
        $TableStr .= "<td $this->ColumnSeparatorStyleL>&nbsp;</td>";
        $TableStr .= $this->ChildElt($Child2, $agent_pk2, $Child1, $BucketDefArray);
      }
 
      $TableStr .= "</tr>";
    }
 
    return($TableStr);
  } // ItemComparisonRows()
 
 
  function AddBucketStr($TreeInfo, &$Children, $BucketDefArray)
  {
    if (!is_array($Children)) return;
    $agent_pk = $TreeInfo['agent_pk'];
    foreach($Children as &$Child)
    {
      $Child['bucketarray'] = GetFileBuckets($TreeInfo['nomosagent_pk'], $TreeInfo['bucketagent_pk'], $Child['uploadtree_pk'], $TreeInfo['bucketpool_pk']);
 
      $Child['bucketstr'] = GetFileBuckets_string($TreeInfo['nomosagent_pk'], $TreeInfo['bucketagent_pk'], $Child['uploadtree_pk'], $BucketDefArray, ",", True);
    }
  }
 
 
  function EvalThreshold($MyArray, $Threshold, $BucketDefArray)
  {
    foreach($MyArray as $bucket_pk)
    {
      $bucket_evalorder = $BucketDefArray[$bucket_pk]['bucket_evalorder'];
      if ($bucket_evalorder > $Threshold) return False;
    }
    return True;
  }
 
  /* @brief remove files where all the buckets in both pairs
   * are below a bucket_evalorder threshold.
  function filter_evalordermin(&$Master, $BucketDefArray, $threshold)
  {
    foreach($Master as $Key =>&$Pair)
    {
      $Pair1 = GetArrayVal("1", $Pair);
      $Pair2 = GetArrayVal("2", $Pair);
 
      if (empty($Pair1))
      {
        if ($this->EvalThreshold($Pair2['bucketarray'], $threshold, $BucketDefArray) == True)
          unset($Master[$Key]);
        else
          continue;
      }
      else if (empty($Pair2))
      {
        if ($this->EvalThreshold($Pair1['bucketarray'], $threshold, $BucketDefArray) == True)
          unset($Master[$Key]);
        else
          continue;
      }
      else
      if (($this->EvalThreshold($Pair1['bucketarray'], $threshold, $BucketDefArray) == True)
          and ($this->EvalThreshold($Pair2['bucketarray'], $threshold, $BucketDefArray) == True))
        unset($Master[$Key]);
    }
    return;
  }   End of evalordermin */
 
 
  function filter_samebucketlist(&$Master)
  {
    foreach($Master as $Key =>&$Pair)
    {
      $Pair1 = GetArrayVal("1", $Pair);
      $Pair2 = GetArrayVal("2", $Pair);
 
      if (empty($Pair1) or empty($Pair2)) continue;
      if ($Pair1['bucketstr'] == $Pair2['bucketstr'])
        unset($Master[$Key]);
    }
    return;
  }  /* End of samebucketlist */
 
  function FilterChildren($filter, &$Master, $BucketDefArray)
  {
//debugprint($Master, "Master");
    switch($filter)
    {
      case 'samebucketlist':
        $this->filter_samebucketlist($Master);
        break;
      default:
        break;
    }
  }
 
 
  function HTMLout($Master, $uploadtree_pk1, $uploadtree_pk2, $in_uploadtree_pk1, $in_uploadtree_pk2, $filter, $TreeInfo1, $TreeInfo2, $BucketDefArray)
  {
    /* Initialize */
    $FreezeText = _("Freeze Path");
    $FrozenText = _("Frozen, Click to unfreeze");
    $OutBuf = '';
 
    /******* javascript functions ********/
    $OutBuf .= "\n<script language='javascript'>\n";
    /* function to replace this page specifying a new filter parameter */
    $OutBuf .= "function ChangeFilter(selectObj, utpk1, utpk2){";
    $OutBuf .= "  var selectidx = selectObj.selectedIndex;";
    $OutBuf .= "  var filter = selectObj.options[selectidx].value;";
    $OutBuf .= '  window.location.assign("?mod=' . $this->Name .'&item1="+utpk1+"&item2="+utpk2+"&filter=" + filter); ';
    $OutBuf .= "}\n";
 
    /* Freeze function (path list in banner)
     FreezeColNo is the ID of the column to freeze: 1 or 2
    Toggle Freeze button label: Freeze Path <-> Unfreeze Path
    Toggle Freeze button background color: white to light blue
    Toggle which paths are frozen: if path1 freezes, then unfreeze path2.
    Rewrite urls: eg &item1 ->  &Fitem1
    */
    $OutBuf .= "function Freeze(FreezeColNo) {";
    $OutBuf .=  "var FreezeElt1 = document.getElementById('Freeze1');";
    $OutBuf .=  "var FreezeElt2 = document.getElementById('Freeze2');";
    $OutBuf .=  "var AddFreezeArg = 1; "; //1 to add &freeze=, 0 to remove &freeze= from url
    $OutBuf .=  "var old_uploadtree_pk;\n";
 
    /* change the freeze labels to denote their new status */
    $OutBuf .=  "if (FreezeColNo == '1')";
    $OutBuf .=  "{";
    $OutBuf .=    "if (FreezeElt1.innerHTML == '$FrozenText') ";
    $OutBuf .=    "{";
    $OutBuf .=      "FreezeElt1.innerHTML = '$FreezeText';";
    $OutBuf .=      "FreezeElt1.style.backgroundColor = 'white'; ";
    $OutBuf .=      "AddFreezeArg = 0;";
    $OutBuf .=    "}";
    $OutBuf .=    "else { ";
    $OutBuf .=      "FreezeElt1.innerHTML = '$FrozenText'; ";
    $OutBuf .=      "FreezeElt1.style.backgroundColor = '#EAF7FB'; ";
    $OutBuf .=      "FreezeElt2.innerHTML = '$FreezeText';";
    $OutBuf .=      "FreezeElt2.style.backgroundColor = 'white';";
    $OutBuf .=      "old_uploadtree_pk = $in_uploadtree_pk1;";
    $OutBuf .=    "}";
    $OutBuf .=  "}";
    $OutBuf .=  "else {";
    $OutBuf .=    "if (FreezeElt2.innerHTML == '$FrozenText') ";
    $OutBuf .=    "{";
    $OutBuf .=      "FreezeElt2.innerHTML = '$FreezeText';";
    $OutBuf .=      "FreezeElt2.style.backgroundColor = 'white';";
    $OutBuf .=      "AddFreezeArg = 0;";
    $OutBuf .=    "}";
    $OutBuf .=    "else {";
    $OutBuf .=      "FreezeElt1.innerHTML = '$FreezeText';";
    $OutBuf .=      "FreezeElt1.style.backgroundColor = 'white';";
    $OutBuf .=      "FreezeElt2.innerHTML = '$FrozenText';";
    $OutBuf .=      "FreezeElt2.style.backgroundColor = '#EAF7FB';";
    $OutBuf .=      "old_uploadtree_pk = $in_uploadtree_pk2;";
    $OutBuf .=    "}";
    $OutBuf .=  "}";
 
    /* Alter the url to add or remove freeze={column number}  */
    $OutBuf .=  "var i=0;\n";
    $OutBuf .=  "var linkid;\n";
    $OutBuf .=  "var linkelt;\n";
    $OutBuf .=  "var FreezeIdx;\n";
    $OutBuf .=  "var BaseURL;\n";
    $OutBuf .=  "var numlinks = document.links.length;\n";
    $OutBuf .=  "for (i=0; i < numlinks; i++)\n";
    $OutBuf .=  "{";
    $OutBuf .=    "linkelt = document.links[i];\n";
    // freeze is the last url arg, so trim it off if it exists
    $OutBuf .=      "FreezeIdx = linkelt.href.indexOf('&freeze');\n";
    $OutBuf .=      "if (FreezeIdx > 0) \n";
    $OutBuf .=        "BaseURL = linkelt.href.substr(0,FreezeIdx); \n";
    $OutBuf .=      "else ";
    $OutBuf .=        "BaseURL = linkelt.href; \n";
    $OutBuf .=      "if (AddFreezeArg == 1) \n ";
    $OutBuf .=        "linkelt.href = BaseURL + '&freeze=' + FreezeColNo + '&itemf=' + old_uploadtree_pk;";
    $OutBuf .=      "else \n";
    $OutBuf .=        "linkelt.href = BaseURL;";
    $OutBuf .=  "}\n";
    $OutBuf .= "}\n";
    $OutBuf .= "</script>\n";
    /******* END javascript functions  ********/
 
 
    /* Select list for filters */
    $SelectFilter = "<select name='diff_filter' id='diff_filter' onchange='ChangeFilter(this,$uploadtree_pk1, $uploadtree_pk2)'>";
    $Selected = ($filter == 'none') ? "selected" : "";
    $SelectFilter .= "<option $Selected value='none'>Remove nothing";
 
    $Selected = ($filter == 'samebucketlist') ? "selected" : "";
    $SelectFilter .= "<option $Selected value='samebucketlist'>Remove unchanged bucket lists";
    $SelectFilter .= "</select>";
 
    $StyleRt = "style='float:right'";
    $OutBuf .= "<a name='flist' href='#histo' $StyleRt > Jump to histogram </a><br>";
 
    /* Switch to license diff view */
    $text = _("Switch to license view");
    $switchURL = Traceback_uri();
    $switchURL .= "?mod=nomosdiff&item1=$uploadtree_pk1&item2=$uploadtree_pk2";
    $OutBuf .= "<a href='$switchURL' $StyleRt > $text </a> ";
 
 
//    $TableStyle = "style='border-style:collapse;border:1px solid black'";
    $TableStyle = "";
    $OutBuf .= "<table border=0 id='dirlist' $TableStyle>";
 
    /* Select filter pulldown */
    $OutBuf .= "<tr><td colspan=5 align='center'>Filter: $SelectFilter<br>&nbsp;</td></tr>";
 
    /* File path */
    $OutBuf .= "<tr>";
    $Path1 = Dir2Path($uploadtree_pk1);
    $Path2 = Dir2Path($uploadtree_pk2);
    $OutBuf .= "<td colspan=2>";
    $OutBuf .= Dir2BrowseDiff($Path1, $Path2, $filter, 1, $this);
    $OutBuf .= "</td>";
    $OutBuf .= "<td $this->ColumnSeparatorStyleL colspan=3>";
    $OutBuf .= Dir2BrowseDiff($Path1, $Path2, $filter, 2, $this);
    $OutBuf .= "</td></tr>";
 
    /* File comparison table */
    $OutBuf .= $this->ItemComparisonRows($Master, $TreeInfo1['agent_pk'], $TreeInfo2['agent_pk'], $BucketDefArray);
 
    /*  Separator row */
    $ColumnSeparatorStyleTop = "style='border:solid 0 #006600; border-top-width:2px; border-bottom-width:2px;'";
    $OutBuf .= "<tr>";
    $OutBuf .= "<td colspan=5 $ColumnSeparatorStyleTop>";
    $OutBuf .= "<a name='histo' href='#flist' style='float:right'> Jump to top </a>";
    $OutBuf .= "</a>";
    $OutBuf .= "</tr>";
 
    /* License histogram */
    $OutBuf .= "<tr>";
    $Tree1Hist = $this->UploadHist($uploadtree_pk1, $TreeInfo1, $BucketDefArray);
    $OutBuf .= "<td colspan=2 valign='top' align='center'>$Tree1Hist</td>";
    $OutBuf .= "<td $this->ColumnSeparatorStyleL>&nbsp;</td>";
    $Tree2Hist = $this->UploadHist($uploadtree_pk2, $TreeInfo2, $BucketDefArray);
    $OutBuf .= "<td colspan=2 valign='top' align='center'>$Tree2Hist</td>";
    $OutBuf .= "</tr></table>\n";
 
    $OutBuf .= "<a href='#flist' style='float:right'> Jump to top </a><p>";
 
    return $OutBuf;
  }
 
 
  function Output()
  {
    if ($this->State != PLUGIN_STATE_READY) { return(0); }
 
    $uTime = microtime(true);
    $V="";
    $UpdCache = GetParm("updcache",PARM_INTEGER);
 
    /* Remove "updcache" from the GET args and set $this->UpdCache
     * This way all the url's based on the input args won't be
     * polluted with updcache
     * Use Traceback_parm_keep to ensure that all parameters are in order
     */
    $CacheKey = "?mod=" . $this->Name . Traceback_parm_keep(array("item1","item2", "filter", "col", "freeze", "itemf"));
 
    if ($UpdCache )
    {
      $UpdCache = $_GET['updcache'];
      $_SERVER['REQUEST_URI'] = preg_replace("/&updcache=[0-9]*/","",$_SERVER['REQUEST_URI']);
      unset($_GET['updcache']);
      $V = ReportCachePurgeByKey($CacheKey);
    }
    else
      $V = ReportCacheGet($CacheKey);
 
    $Cached = !empty($V);
    if (!$Cached)
    {
      $V = $this->htmlContent();
    }
 
    if (!$this->OutputToStdout) { return($V); }
    print "$V";
    $Time = microtime(true) - $uTime;  // convert usecs to secs
    $text = _("Elapsed time: %.2f seconds");
    printf( "<small>$text</small>", $Time);
 
    if ($Cached)
    {
      $text = _("cached");
      $text1 = _("Update");
      echo " <i>$text</i>   <a href=\"$_SERVER[REQUEST_URI]&updcache=1\"> $text1 </a>";
    }
    else if ($Time > 0.5)
    {
      ReportCachePut($CacheKey, $V);
    }
    return;
  }
 
  public function htmlContent()
  {
    $filter = GetParm("filter",PARM_STRING);
    if (empty($filter)) $filter = "none";
    $FreezeCol = GetParm("freeze",PARM_INTEGER);  // which column to freeze?  1 or 2 or null
    $ClickedCol = GetParm("col",PARM_INTEGER);    // which column was clicked on?  1 or 2 or null
    $ItemFrozen = GetParm("itemf",PARM_INTEGER);  // frozen item or null
    $in_uploadtree_pk1 = GetParm("item1",PARM_INTEGER);
    $in_uploadtree_pk2 = GetParm("item2",PARM_INTEGER);
 
    if (empty($in_uploadtree_pk1) || empty($in_uploadtree_pk2))
      Fatal("Bad input parameters.  Both item1 and item2 must be specified.", __FILE__, __LINE__);
 
    /* If you click on a item in a frozen column, then you are a dope so ignore $ItemFrozen */
    if ($FreezeCol == $ClickedCol)
    {
      $ItemFrozen= 0;
      $FreezeCol = 0;
    }
 
    /* @var $uploadDao UploadDao */
    $uploadDao = $GLOBALS['container']->get('dao.upload');
    /* Check item1 upload permission */
    $Item1Row = $uploadDao->getUploadEntry($in_uploadtree_pk1);
    if ( !$uploadDao->isAccessible($Item1Row['upload_fk'], Auth::getGroupId()) )
    {
      $text = _("Permission Denied");
      return "<h2>$text item 1</h2>";
    }
 
    /* Check item2 upload permission */
    $Item2Row = $uploadDao->getUploadEntry($in_uploadtree_pk2);
    if (!$uploadDao->isAccessible($Item2Row['upload_fk'], Auth::getGroupId()))
    {
      $text = _("Permission Denied");
      return "<h2>$text item 2</h2>";
    }
 
    $uploadtree_pk1 = $in_uploadtree_pk1;
    $uploadtree_pk2 = $in_uploadtree_pk2;
 
      if ($FreezeCol == 1)
      {
        $uploadtree_pk1 = $ItemFrozen;
      }
      else if ($FreezeCol == 2)
      {
        $uploadtree_pk2 = $ItemFrozen;
      }
 
 
    $newURL = Traceback_dir() . "?mod=" . $this->Name . "&item1=$uploadtree_pk1&item2=$uploadtree_pk2";
    if (!empty($filter)) $newURL .= "&filter=$filter";
 
    // rewrite page with new uploadtree_pks */
    if (($uploadtree_pk1 != $in_uploadtree_pk1)
        || ($uploadtree_pk2 != $in_uploadtree_pk2))
    {
print <<< JSOUT
<script type="text/javascript">
  window.location.assign('$newURL');
</script>
JSOUT;
    }
 
    $TreeInfo1 = $this->GetTreeInfo($uploadtree_pk1);
    $TreeInfo2 = $this->GetTreeInfo($uploadtree_pk2);
    $ErrText = _("No license data for tree %d.  Use Jobs > Agents to schedule a license scan.");
    $ErrMsg= '';
    if ($TreeInfo1['agent_pk'] == 0)
    {
      $ErrMsg = sprintf($ErrText, 1);
    }
    else
    if ($TreeInfo2['agent_pk'] == 0)
    {
      $ErrMsg = sprintf($ErrText, 2);
    }
    else
    {
      $BucketDefArray1 = initBucketDefArray($TreeInfo1['bucketpool_pk']);
      $BucketDefArray2 = initBucketDefArray($TreeInfo2['bucketpool_pk']);
      $BucketDefArray = $BucketDefArray1 + $BucketDefArray2;
 
      /* Get list of children */
      $Children1 = GetNonArtifactChildren($uploadtree_pk1);
      $Children2 = GetNonArtifactChildren($uploadtree_pk2);
 
      /* Add fuzzyname to children */
      FuzzyName($Children1);  // add fuzzyname to children
      FuzzyName($Children2);  // add fuzzyname to children
 
      /* add element licstr to children */
      $this->AddBucketStr($TreeInfo1, $Children1, $BucketDefArray);
      $this->AddBucketStr($TreeInfo2, $Children2, $BucketDefArray);
 
      /* Master array of children, aligned.   */
      $Master = MakeMaster($Children1, $Children2);
 
      /* add linkurl to children */
      FileList($Master, $TreeInfo1['agent_pk'], $TreeInfo2['agent_pk'], $filter, $this, $uploadtree_pk1, $uploadtree_pk2);
 
      /* Apply filter */
      $this->FilterChildren($filter, $Master, $BucketDefArray);
    }
 
      if($this->OutputType=='HTML')
      {
        if ($ErrMsg)
          $V .= $ErrMsg;
        else
          $V .= $this->HTMLout($Master, $uploadtree_pk1, $uploadtree_pk2, $in_uploadtree_pk1, $in_uploadtree_pk2, $filter, $TreeInfo1, $TreeInfo2, $BucketDefArray);
      }
      return $V;
  }
 
}
 
$NewPlugin = new ui_diff_buckets;
$NewPlugin->Initialize();