common-tags.php

Go to the documentation of this file.

<?php
/***********************************************************
 Copyright (C) 2010-2013 Hewlett-Packard Development Company, L.P.

 This library is free software; you can redistribute it and/or
 modify it under the terms of the GNU Lesser General Public
 License version 2.1 as published by the Free Software Foundation.

 This library is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 Lesser General Public License for more details.

 You should have received a copy of the GNU Lesser General Public License
 along with this library; if not, write to the Free Software Foundation, Inc.0
 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 ***********************************************************/

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;
}