ui-list-bucket-files.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2010-2015 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 list_bucket_files extends FO_Plugin
{
  function __construct()
  {
    $this->Name       = "list_bucket_files";
    $this->Title      = _("List Files for Bucket");
    $this->Dependency = array("nomoslicense");
    $this->DBaccess   = PLUGIN_DB_READ;
    $this->LoginFlag  = 0;
    parent::__construct();
  }
 
  function RegisterMenus()
  {
    // micro-menu
    $bucketagent_pk = GetParm("bapk",PARM_INTEGER);
    $uploadtree_pk = GetParm("item",PARM_INTEGER);
    $bucket_pk = GetParm("bpk",PARM_INTEGER);
    $bucketpool_pk = GetParm("bp",PARM_INTEGER);
    $nomosagent_pk = GetParm("napk",PARM_INTEGER);
 
    $URL = $this->Name . "&bapk=$bucketagent_pk&item=$uploadtree_pk&bpk=$bucket_pk&bp=$bucketpool_pk&napk=$nomosagent_pk&page=-1";
    $text = _("Show All Files");
    menu_insert($this->Name."::Show All",0, $URL, $text);
  } // RegisterMenus()
 
  function Initialize()
  {
    $this->State=PLUGIN_STATE_READY;
    return true;
  } // Initialize()
 
 
  function Output()
  {
    if ($this->State != PLUGIN_STATE_READY) {
      return;
    }
    global $PG_CONN;
 
    /*  Input parameters */
    $bucketagent_pk = GetParm("bapk",PARM_INTEGER);
    $uploadtree_pk = GetParm("item",PARM_INTEGER);
    $bucket_pk = GetParm("bpk",PARM_INTEGER);
    $bucketpool_pk = GetParm("bp",PARM_INTEGER);
    $nomosagent_pk = GetParm("napk",PARM_INTEGER);
    $BinNoSrc = GetParm("bns",PARM_INTEGER);  // 1 if requesting binary with no src
    $Excl = GetParm("excl",PARM_RAW);
 
    if (empty($uploadtree_pk) || empty($bucket_pk) || empty($bucketpool_pk))
    {
      $text = _("is missing required parameters.");
      echo $this->Name . " $text";
      return;
    }
 
    /* Check upload permission */
    $Row = GetSingleRec("uploadtree", "WHERE uploadtree_pk = $uploadtree_pk");
    $uploadDao = $GLOBALS['container']->get('dao.upload');
    if ( !$uploadDao->isAccessible($Row['upload_fk'], Auth::getGroupId()) )
    {
      $text = _("Permission Denied");
      echo "<h2>$text item 1</h2>";
      return;
    }
 
    $Page = GetParm("page",PARM_INTEGER);
    if (empty($Page)) {
      $Page=0;
    }
 
    $V="";
    $Time = time();
    $Max = 200;
 
    // Create cache of bucket_pk => bucket_name
    // Since we are going to do a lot of lookups
    $sql = "select bucket_pk, bucket_name from bucket_def where bucketpool_fk=$bucketpool_pk";
    $result_name = pg_query($PG_CONN, $sql);
    DBCheckResult($result_name, $sql, __FILE__, __LINE__);
    $bucketNameCache = array();
    while ($name_row = pg_fetch_assoc($result_name)) {
      $bucketNameCache[$name_row['bucket_pk']] = $name_row['bucket_name'];
    }
    pg_free_result($result_name);
 
    switch($this->OutputType)
    {
      case "XML":
        break;
      case "HTML":
        // micro menus
        $V .= menu_to_1html(menu_find($this->Name, $MenuDepth),0);
 
        /* Get all the files under this uploadtree_pk with this bucket */
        $V .= _("The following files are in bucket: '<b>");
        $V .= $bucketNameCache[$bucket_pk];
        $V .= "</b>'.\n";
        $text = _("Display");
        $text1 = _("excludes");
        $text2 = _("files with these licenses");
        if (!empty($Excl)) $V .= "<br>$text <b>$text1</b> $text2: $Excl";
 
        $Offset = ($Page <= 0) ? 0 : $Page*$Max;
        $PkgsOnly = false;
 
        // Get bounds of subtree (lft, rgt) for this uploadtree_pk
        $sql = "SELECT lft,rgt,upload_fk FROM uploadtree
              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);
 
        /* Get uploadtree table */
        $uploadtree_tablename = GetUploadtreeTableName($upload_pk);
 
        /* If $BinNoSrc, then only list binary packages in this subtree
         * that do not have Source packages.
        * Else list files in the asked for bucket.
        */
        if ($BinNoSrc)
        {
        }
        else
        {
          $Offset= ($Page < 0) ? 0 : $Page*$Max;
          $limit = ($Page < 0) ? "ALL":$Max;
          // Get all the uploadtree_pk's with this bucket (for this agent and bucketpool)
          // in this subtree.
          // It would be best to sort by pfile_pk, so that the duplicate pfiles are
          // correctly indented, but pfile_pk has no meaning to the user.  So a compromise,
          // sorting by ufile_name is used.
          $sql = "select uploadtree.*, bucket_file.nomosagent_fk as nomosagent_fk
               from uploadtree, bucket_file, bucket_def
               where upload_fk=$upload_pk and uploadtree.lft between $lft and $rgt
                 and ((ufile_mode & (3<<28)) = 0)
                 and uploadtree.pfile_fk=bucket_file.pfile_fk
                 and agent_fk=$bucketagent_pk
                 and bucket_fk=$bucket_pk
                 and bucketpool_fk=$bucketpool_pk
                 and bucket_pk=bucket_fk
                 and nomosagent_fk=$nomosagent_pk
                 order by uploadtree.ufile_name
                 limit $limit offset $Offset";
          $fileresult = pg_query($PG_CONN, $sql);
          DBCheckResult($fileresult, $sql, __FILE__, __LINE__);
          $Count = pg_num_rows($fileresult);
        }
        $file_result_temp = pg_fetch_all($fileresult);
        $sourted_file_result = array(); // the final file list will display
        $max_num = $Count;
        for($i = 0; $i < $max_num; $i++)
        {
          $row = $file_result_temp[$i];
          if (empty($row)) continue;
          $sourted_file_result[] = $row;
          for($j = $i + 1; $j < $max_num; $j++)
          {
            $row_next = $file_result_temp[$j];
            if (!empty($row_next) && ($row['pfile_fk'] == $row_next['pfile_fk']))
            {
              $sourted_file_result[] = $row_next;
              $file_result_temp[$j] = null;
            }
          }
        }
 
        if ($Count < (1.25 * $Max)) $Max = $Count;
        if ($Max < 1) $Max = 1;  // prevent div by zero in corner case of no files
 
        /* Get the page menu */
        if (($Count >= $Max) && ($Page >= 0))
        {
          $VM = "<P />\n" . MenuEndlessPage($Page,intval((($Count+$Offset)/$Max))) . "<P />\n";
          $V .= $VM;
        }
        else
        {
          $VM = "";
        }
 
        // base url
        $baseURL = "?mod=" . $this->Name . "&bapk=$bucketagent_pk&item=$uploadtree_pk&bpk=$bucket_pk&bp=$bucketpool_pk&napk=$nomosagent_pk&page=-1";
 
        // for each uploadtree rec ($fileresult), find all the licenses in it and it's children
        $ShowBox = 1;
        $ShowMicro=NULL;
        $RowNum = $Offset;
        $Header = "";
        $LinkLast = "list_bucket_files&bapk=$bucketagent_pk";
 
        /* file display loop/table */
        $V .= "<table>";
        $text = _("File");
        $V .= "<tr><th>$text</th><th>&nbsp";
        $ExclArray = explode(":", $Excl);
        $ItemNumb = 0;
        $PrevPfile_pk = 0;
 
        if ($Count > 0)
        foreach ($sourted_file_result as $row)
        {
          // get all the licenses in this subtree (bucket uploadtree_pk)
          $pfile_pk = $row['pfile_fk'];
          $licstring = GetFileLicenses_string($nomosagent_pk, $row['pfile_fk'], $row['uploadtree_pk'], $uploadtree_tablename);
          if (empty($licstring)) $licstring = '-';
          $URLlicstring = urlencode($licstring);
 
          /* Allow user to exclude files with this exact license list */
          if (!empty($Excl))
          $URL = $baseURL ."&excl=".urlencode($Excl).":".$URLlicstring;
          else
          $URL = $baseURL ."&excl=$URLlicstring";
          $text = _("Exclude files with license");
          $Header = "<a href=$URL>$text: $licstring.</a>";
 
          $ok = !($Excl && in_array($licstring, $ExclArray));
 
          if ($ok)
          {
            $nomosagent_pk = $row['nomosagent_fk'];
            $LinkLast = "view-license&bapk=$bucketagent_pk&napk=$nomosagent_pk";
            $V .= "<tr><td>";
            if ($PrevPfile_pk == $pfile_pk)
            {
              $V .= "<div style='margin-left:2em;'>";
            }
            else
            {
              $V .= "<div>";
            }
            $V .= Dir2Browse("browse", $row['uploadtree_pk'], $LinkLast, $ShowBox, $ShowMicro, ++$RowNum, $Header, '', $uploadtree_tablename);
            $V .= "</div>";
 
            $V .= "</td>";
            $V .= "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>";  // spaces to seperate licenses
 
            // show the entire license list as a single string with links to the files
            // in this container with that license.
            $V .= "<td>$licstring</td></tr>";
            $V .= "<tr><td colspan=3><hr></td></tr>";  // separate files
          }
          $PrevPfile_pk = $pfile_pk;
        }
        pg_free_result($fileresult);
        $V .= "</table>";
        if (!empty($VM)) {
          $V .= $VM . "\n";
        }
        $V .= "<hr>\n";
        $Time = time() - $Time;
        $text = _("Elapsed time");
        $text1 = _("seconds");
        $V .= "<small>$text: $Time $text1</small>\n";
        break;
      case "Text":
        break;
      default:
        break;
    }
    if (!$this->OutputToStdout) {
      return($V);
    }
    print($V);
    return;
  } // Output()
 
}
 
$NewPlugin = new list_bucket_files;
$NewPlugin->Initialize();