common-tags.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2010-2013 Hewlett-Packard Development Company, L.P.
 
 SPDX-License-Identifier: LGPL-2.1-only
*/
 
use Fossology\Lib\Auth\Auth;
use Fossology\Lib\Dao\UploadDao;
 
function GetAllTags($Item, $Recurse=true, $uploadtree_tablename="uploadtree")
{
  if (empty($Item)) {
    return array();
  }
 
  global $container;
 
  $dbManager = $container->get('db.manager');
 
  $stmt = __METHOD__.".$uploadtree_tablename";
  $sql = "select true from tag_manage, $uploadtree_tablename u where is_disabled = true and tag_manage.upload_fk = u.upload_fk and u.uploadtree_pk = $1";
  $tagDisabled = $dbManager->getSingleRow($sql, array($Item), $stmt);
  if ($tagDisabled !== false) {
    return array();
  }
 
  $stmt2 = $stmt.'.lftRgt';
  $sql = "select lft,rgt, upload_fk from $uploadtree_tablename where uploadtree_pk=$1";
  $uploadtree_row = $dbManager->getSingleRow($sql,array($Item), $stmt2);
 
  $params = array($Item, $uploadtree_row['upload_fk']);
  if ($Recurse) {
    $Condition = " lft between $3 and $4 ";
    $stmt .= ".recurse";
    $params[] = $uploadtree_row['lft'];
    $params[] = $uploadtree_row['rgt'];
  } else {
    $Condition = " uploadtree.uploadtree_pk=$1 ";
  }
 
  /* Get list of unique tag_pk's for this item */
  $sql = "SELECT distinct(tag_fk) as tag_pk FROM tag_file, $uploadtree_tablename WHERE tag_file.pfile_fk = {$uploadtree_tablename}.pfile_fk and upload_fk=$2 AND $Condition UNION SELECT tag_fk as tag_pk FROM tag_uploadtree WHERE tag_uploadtree.uploadtree_fk = $1";
 
  $stmt1 = $stmt.'.theTags';
  $dbManager->prepare($stmt1,"select tag.tag AS tag_name, tag.tag_pk from tag,($sql) subquery where tag.tag_pk=subquery.tag_pk group by tag.tag_pk, tag.tag");
  $res = $dbManager->execute($stmt1,$params);
  $List = $dbManager->fetchAll($res);
  $dbManager->freeResult($res);
 
  return($List);
} // GetAllTags()
 
 
function Array2SingleSelectTag($KeyValArray, $SLName="unnamed", $SelectedVal= "",
$FirstEmpty=false, $SelElt=true, $Options="")
{
  $str ="\n<select name='$SLName' $Options>\n";
  if ($FirstEmpty) {
    $str .= "<option value='' > \n";
  }
  foreach ($KeyValArray as $key => $val) {
    if ($SelElt == true) {
      $SELECTED = ($val == $SelectedVal) ? "SELECTED" : "";
    } else {
      $SELECTED = ($key == $SelectedVal) ? "SELECTED" : "";
    }
    //    $perm = GetTaggingPerms($_SESSION['UserId'],$key);
    //    if ($perm > 1) {
      $str .= "<option value='$key' $SELECTED>$val\n";
    //    }
  }
  $str .= "</select>";
  return $str;
}
 
function TagSelect($SLName="unnamed", $SelectedVal= "",
                   $FirstEmpty=false, $SelElt=true)
{
  /* Find all the tag namespaces for this user */
  /*  UNUSED
  $sql = "select lft,rgt from uploadtree where uploadtree_pk=$Item";
  $result = pg_query($PG_CONN, $sql);
  DBCheckResult($result, $sql, __FILE__, __LINE__);
  $uploadtree_row = pg_fetch_assoc($result);
  */
 
  /* Find all the tags for this namespace */
 
  $str ="\n<select name='$SLName'>\n";
  if ($FirstEmpty) {
    $str .= "<option value='' > \n";
  }
  foreach ($KeyValArray as $key => $val) {
    if ($SelElt == true) {
      $SELECTED = ($val == $SelectedVal) ? "SELECTED" : "";
    } else {
      $SELECTED = ($key == $SelectedVal) ? "SELECTED" : "";
    }
    $perm = GetTaggingPerms($_SESSION['UserId'],$key);
    if ($perm > 1) {
      $str .= "<option value='$key' $SELECTED>$val\n";
    }
  }
  $str .= "</select>";
  return $str;
}
 
function TagFilter(&$UploadtreeRows, $tag_pk, $uploadtree_tablename)
{
  foreach ($UploadtreeRows as $key=>$UploadtreeRow) {
    $found = false;
    $tags = GetAllTags($UploadtreeRow["uploadtree_pk"], true, $uploadtree_tablename);
    foreach ($tags as $tagArray) {
      if ($tagArray['tag_pk'] == $tag_pk) {
        $found = true;
        break;
      }
      if ($found) {
        break;
      }
    }
    if ($found == false) {
      unset($UploadtreeRows[$key]);
    }
  }
}
 
function TagStatus($upload_id)
{
  global $PG_CONN, $container;
  $uploadDao = $container->get('dao.upload');
  if (!$uploadDao->isEditable($upload_id, Auth::getGroupId())) {
    return 0;
  }
 
  /* check if this upload has been disabled */
  $sql = "select tag_manage_pk from tag_manage where upload_fk = $upload_id and is_disabled = true;";
  $result = pg_query($PG_CONN, $sql);
  DBCheckResult($result, $sql, __FILE__, __LINE__);
  $count = pg_num_rows($result);
  pg_free_result($result);
  return ($count > 0) ? 0 : 1;
}