ui-tags.php

<?php
/***********************************************************
 Copyright (C) 2010-2011 Hewlett-Packard Development Company, L.P.
 Copyright (C) 2015 Siemens AG

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

 This program 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 General Public License for more details.

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

use Fossology\Lib\Auth\Auth;
use Fossology\Lib\Dao\UploadDao;


class ui_tag extends FO_Plugin
{
  private $uploadDao;

  function __construct()
  {
    $this->Name     = "tag";
    $this->Title    = _("Tag");
    $this->DBaccess = PLUGIN_DB_WRITE;
    parent::__construct();
    $this->uploadDao = $GLOBALS['container']->get('dao.upload');
  }

  function RegisterMenus()
  {
    $text = _("Tag files or containers");
    menu_insert("Browse-Pfile::Tag",0,$this->Name,$text);
  } // RegisterMenus()

  function CreateTag($tag_array)
  {
    global $PG_CONN;

    $Upload = GetParm("upload",PARM_INTEGER);
    $Item = GetParm("item", PARM_INTEGER);

    if (empty($Item) || empty($Upload)) {
      return;
    }

    if (isset($tag_array)) {
      $tag_name = $tag_array["tag_name"];
      $tag_notes = $tag_array["tag_notes"];
      $tag_file = $tag_array["tag_file"];
      $tag_package = $tag_array["tag_package"];
      $tag_container = $tag_array["tag_container"];
      $tag_desc = $tag_array["tag_desc"];
      $tag_dir = $tag_array["tag_dir"];
    } else {
      $tag_name = GetParm('tag_name', PARM_TEXT);
      $tag_notes = GetParm('tag_notes', PARM_TEXT);
      $tag_file = GetParm('tag_file', PARM_TEXT);
      $tag_package = GetParm('tag_package', PARM_TEXT);
      $tag_container = GetParm('tag_container', PARM_TEXT);
      $tag_desc = GetParm('tag_desc', PARM_TEXT);
      $tag_dir = GetParm('tag_dir', PARM_TEXT);
    }

    if (empty($tag_name)) {
      $text = _("TagName must be specified. Tag Not created.");
      return ($text);
    }
    /* Need select tag file/package/container */
    if (empty($tag_dir) && empty($tag_file) && empty($tag_package) &&
      empty($tag_container)) {
      $text = _(
        "Need to select one option (dir/file/package/container) to create tag.");
      return ($text);
    }

    pg_exec("BEGIN;");

    /* See if the tag already exists */
    $sql = "SELECT * FROM tag WHERE tag = '$tag_name'";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    if (pg_num_rows($result) < 1) {
      pg_free_result($result);

      $Val = str_replace("'", "''", $tag_name);
      $Val1 = str_replace("'", "''", $tag_desc);
      $sql = "INSERT INTO tag (tag,tag_desc) VALUES ('$Val', '$Val1');";
      $result = pg_query($PG_CONN, $sql);
      DBCheckResult($result, $sql, __FILE__, __LINE__);
      pg_free_result($result);
    } else {
      pg_free_result($result);
    }

    /* Make sure it was added */
    $sql = "SELECT * FROM tag WHERE tag = '$tag_name' LIMIT 1;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    if (pg_num_rows($result) < 1) {
      pg_free_result($result);
      $text = _("Failed to create tag.");
      return ($text);
    }

    $row = pg_fetch_assoc($result);
    $tag_pk = $row["tag_pk"];
    pg_free_result($result);

    $pfileArray = array();
    $i = 0;

    if (! empty($tag_file)) {
      /* Get pfile_fk from uploadtree_pk */
      $sql = "SELECT pfile_fk FROM uploadtree
              WHERE uploadtree_pk = $Item LIMIT 1";
      $result = pg_query($PG_CONN, $sql);
      DBCheckResult($result, $sql, __FILE__, __LINE__);
      while ($row = pg_fetch_assoc($result)) {
        $pfileArray[$i] = $row['pfile_fk'];
        $i ++;
      }
      pg_free_result($result);
    }

    if (! empty($tag_package)) {
      /* GetPkgMimetypes */
      $MimetypeArray = GetPkgMimetypes();
      $sql = "SELECT distinct pfile.pfile_pk FROM uploadtree, pfile WHERE uploadtree.pfile_fk = pfile.pfile_pk AND (pfile.pfile_mimetypefk = $MimetypeArray[0] OR pfile.pfile_mimetypefk = $MimetypeArray[1] OR pfile.pfile_mimetypefk = $MimetypeArray[2]) AND uploadtree.upload_fk = $Upload AND uploadtree.lft >= (SELECT lft FROM uploadtree WHERE uploadtree_pk = $Item) AND uploadtree.rgt <= (SELECT rgt FROM uploadtree WHERE uploadtree_pk = $Item);";
      $result = pg_query($PG_CONN, $sql);
      DBCheckResult($result, $sql, __FILE__, __LINE__);
      while ($row = pg_fetch_assoc($result)) {
        $pfileArray[$i] = $row['pfile_pk'];
        $i ++;
      }
      pg_free_result($result);
    }
    if (! empty($tag_container)) {
      $sql = "SELECT distinct pfile_fk FROM uploadtree WHERE upload_fk = $Upload AND lft >= (SELECT lft FROM uploadtree WHERE uploadtree_pk = $Item) AND rgt <= (SELECT rgt FROM uploadtree WHERE uploadtree_pk = $Item) AND ((ufile_mode & (1<<28))=0) AND pfile_fk!=0;";
      $result = pg_query($PG_CONN, $sql);
      DBCheckResult($result, $sql, __FILE__, __LINE__);
      while ($row = pg_fetch_assoc($result)) {
        $pfileArray[$i] = $row['pfile_fk'];
        $i ++;
      }
      pg_free_result($result);
    }

    if (! empty($tag_dir)) {
      $sql = "SELECT tag_uploadtree_pk FROM tag_uploadtree WHERE tag_fk = $tag_pk AND uploadtree_fk = $Item;";
      $result = pg_query($PG_CONN, $sql);
      DBCheckResult($result, $sql, __FILE__, __LINE__);
      if (pg_num_rows($result) < 1) {
        pg_free_result($result);
        /* Add record to tag_uploadtree table */
        $Val = str_replace("'", "''", $tag_notes);
        $sql = "INSERT INTO tag_uploadtree (tag_fk,uploadtree_fk,tag_uploadtree_date,tag_uploadtree_text) VALUES ($tag_pk, $Item, now(), '$Val');";
        $result = pg_query($PG_CONN, $sql);
        DBCheckResult($result, $sql, __FILE__, __LINE__);
        pg_free_result($result);
      } else {
        $text = _("This Tag already associated with this Directory!");
        pg_exec("ROLLBACK;");
        pg_free_result($result);
        return ($text);
      }
    } else {
      foreach ($pfileArray as $pfile) {
        $sql = "SELECT tag_file_pk FROM tag_file WHERE tag_fk = $tag_pk AND pfile_fk = $pfile;";
        $result = pg_query($PG_CONN, $sql);
        DBCheckResult($result, $sql, __FILE__, __LINE__);
        if (pg_num_rows($result) < 1) {
          pg_free_result($result);
          /* Add record to tag_file table */
          $Val = str_replace("'", "''", $tag_notes);
          $sql = "INSERT INTO tag_file (tag_fk,pfile_fk,tag_file_date,tag_file_text) VALUES ($tag_pk, $pfile, now(), '$Val');";
          $result = pg_query($PG_CONN, $sql);
          DBCheckResult($result, $sql, __FILE__, __LINE__);
          pg_free_result($result);
        } else {
          $text = _("This Tag already associated with this File!");
          pg_exec("ROLLBACK;");
          pg_free_result($result);
          return ($text);
        }
      }
    }
    pg_exec("COMMIT;");
    return (null);
  }

  function EditTag()
  {
    global $PG_CONN;

    $Upload = GetParm("upload",PARM_INTEGER);
    $Item = GetParm("item",PARM_INTEGER);

    if (empty($Item) || empty($Upload)) {
      return;
    }

    $tag_pk = GetParm('tag_pk', PARM_INTEGER);
    $tag_file_pk = GetParm('tag_file_pk', PARM_INTEGER);
    $tag_name = GetParm('tag_name', PARM_TEXT);
    $tag_notes = GetParm('tag_notes', PARM_TEXT);
    $tag_file = GetParm('tag_file', PARM_TEXT);
    $tag_package = GetParm('tag_package', PARM_TEXT);
    $tag_container = GetParm('tag_container', PARM_TEXT);
    $tag_desc = GetParm('tag_desc', PARM_TEXT);
    $tag_dir = GetParm('tag_dir', PARM_TEXT);

    if (empty($tag_name)) {
      $text = _("TagName must be specified. Tag Not Updated.");
      return ($text);
    } else {
      /* Check if tag_name has changed and if the new name is already in use */
      $sql = "SELECT tag FROM tag WHERE tag_pk = '$tag_pk';";
      $result = pg_query($PG_CONN, $sql);
      DBCheckResult($result, $sql, __FILE__, __LINE__);
      $row = pg_fetch_row($result);
      pg_free_result($result);
      /* Is Tag name changed */
      if ($row[0] <> $tag_name) {
        $sql = "SELECT * FROM tag WHERE tag = '$tag_name'";
        $result = pg_query($PG_CONN, $sql);
        DBCheckResult($result, $sql, __FILE__, __LINE__);
        /* Is new Tag name defined in name space */
        if (pg_num_rows($result) >= 1) {
          $row = pg_fetch_row($result);
          pg_free_result($result);
          /* Delete old tag association */
          $this->DeleteTag();
          /* Existing tag values cannot be changed at this phase. */
          /* Create new tag association, do not delete old notes! */

          $tag_data = array("tag_pk" => $row[0], "tag_name" => $row[1], "tag_desc" => $row[3],
                            "tag_notes" => $tag_notes, "tag_file" => $tag_file, "tag_package" => $tag_package,
                            "tag_container" => $tag_container, "tag_dir" => $tag_dir);
          $this->CreateTag($tag_data);
          return (null);
        } else {
          pg_free_result($result);
        }
      }
    }
    pg_exec("BEGIN;");
    /* Update the tag table */
    $Val = str_replace("'", "''", $tag_name);
    $Val1 = str_replace("'", "''", $tag_desc);
    $sql = "UPDATE tag SET tag = '$Val', tag_desc = '$Val1' WHERE tag_pk = $tag_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    $Val = str_replace("'", "''", $tag_notes);
    if (! empty($tag_dir)) {
      $sql = "UPDATE tag_uploadtree SET tag_uploadtree_date = now(), tag_uploadtree_text = '$Val', tag_fk = $tag_pk WHERE tag_uploadtree_pk = $tag_file_pk;";
    } else {
      $sql = "UPDATE tag_file SET tag_file_date = now(), tag_file_text = '$Val', tag_fk = $tag_pk WHERE tag_file_pk = $tag_file_pk;";
    }
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);

    pg_exec("COMMIT;");
    return (null);
  }

  function DeleteTag()
  {
    global $PG_CONN;

    $Upload = GetParm("upload",PARM_INTEGER);
    $Item = GetParm("item",PARM_INTEGER);

    if (empty($Item) || empty($Upload)) {
      return;
    }
    $tag_file_pk = GetParm('tag_file_pk', PARM_INTEGER);

    $sql = "SELECT ufile_name, ufile_mode FROM uploadtree
              WHERE uploadtree_pk = $Item";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $ufile_mode = $row["ufile_mode"];
    pg_free_result($result);

    if (Isdir($ufile_mode)) {
      $sql = "DELETE FROM tag_uploadtree WHERE tag_uploadtree_pk = $tag_file_pk";
    } else {
      $sql = "DELETE FROM tag_file WHERE tag_file_pk = $tag_file_pk";
    }
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);
  }

  function ShowExistTags($Upload,$Uploadtree_pk)
  {
    global $PG_CONN;
    $VE = "";
    $VE = _("<h3>Current Tags:</h3>\n");
    $sql = "SELECT tag_pk, tag, tag_desc, tag_file_pk, tag_file_date, tag_file_text FROM tag, tag_file, uploadtree WHERE tag.tag_pk = tag_file.tag_fk AND tag_file.pfile_fk = uploadtree.pfile_fk AND uploadtree.uploadtree_pk = $Uploadtree_pk UNION SELECT tag_pk, tag, tag_desc, tag_uploadtree_pk AS tag_file_pk, tag_uploadtree_date AS tag_file_date, tag_uploadtree_text AS tag_file_text FROM tag, tag_uploadtree WHERE tag.tag_pk = tag_uploadtree.tag_fk AND tag_uploadtree.uploadtree_fk = $Uploadtree_pk;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    if (pg_num_rows($result) > 0) {
      $VE .= "<table border=1>\n";
      $text1 = _("Tag");
      $text2 = _("Tag Description");
      $text3 = _("Tag Date");
      $VE .= "<tr><th>$text1</th><th>$text2</th><th>$text3</th><th></th></tr>\n";
      while ($row = pg_fetch_assoc($result)) {
        $VE .= "<tr><td align='center'>" . $row['tag'] . "</td><td align='center'>" . $row['tag_desc'] . "</td><td align='center'>" . substr($row['tag_file_date'],0,19) . "</td>";
        if ($this->uploadDao->isEditable($Upload, Auth::getGroupId())) {
          $VE .= "<td align='center'><a href='" . Traceback_uri() . "?mod=tag&action=edit&upload=$Upload&item=$Uploadtree_pk&tag_file_pk=" . $row['tag_file_pk'] . "'>View/Edit</a>|<a href='" . Traceback_uri() . "?mod=tag&action=delete&upload=$Upload&item=$Uploadtree_pk&tag_file_pk=" . $row['tag_file_pk'] . "'>Delete</a></td></tr>\n";
        } else {
          $nopermtext = _("No permission to edit tag.");
          $VE .= "<td align='center'>$nopermtext</td></tr>\n";
        }
      }
      $VE .= "</table><p>\n";
    }
    pg_free_result($result);

    return $VE;
  }

  function ShowAjaxPage()
  {
    $VA = "";
    /* Create AJAX javascript */
    $VA .= ActiveHTTPscript("Tags");
    $VA .= "<script language='javascript'>\n";
    $VA .= "var swtemp=0,objtemp;\n";
    $VA .= "function mouseout(o){\n";
    $VA .= "     o.style.display = \"none\";\n";
    $VA .= "     swtemp = 0;\n";
    $VA .= "}\n";
    $VA .= "function removediv(inputid){\n";
    $VA .= "     getobj(inputid+\"mydiv\").style.display=\"none\";\n";
    $VA .= "}\n";
    $VA .= "function creatediv(_parent,_element,_id,_css){\n";
    $VA .= "     var newObj = document.createElement(_element);\n";
    $VA .= "     if(_id && _id!=\"\")newObj.id=_id;\n";
    $VA .= "     if(_css && _css!=\"\"){\n";
    $VA .= "             newObj.setAttribute(\"style\",_css);\n";
    $VA .= "             newObj.style.cssText = _css;\n";
    $VA .= "     }\n";
    $VA .= "     if(_parent && _parent!=\"\"){\n";
    $VA .= "             var theObj=getobj(_parent);\n";
    $VA .= "             var parent = theObj.parentNode;\n";
    $VA .= "             if(parent.lastChild == theObj){\n";
    $VA .= "                     theObj.appendChild(newObj);\n";
    $VA .= "             }\n";
    $VA .= "             else{\n";
    $VA .= "                     theObj.insertBefore(newObj, theObj.nextSibling);\n";
    $VA .= "             }\n";
    $VA .= "     }\n";
    $VA .= "     else        document.body.appendChild(newObj);\n";
    $VA .= "}\n";
    $VA .= "function getobj(o){\n";
    $VA .= "     return document.getElementById(o);\n";
    $VA .= "}\n";
    $VA .= "function Tags_Reply()\n";
    $VA .= "{\n";
    $VA .= "  if ((Tags.readyState==4) && (Tags.status==200))\n";
    $VA .= "  {\n";
    $VA .= "    var list = Tags.responseText;\n";
    $VA .= "    var text_list = list.split(\",\")\n";
    $VA .= "    var inputid = getobj(\"tag_name\");\n";
    $VA .= "    if (swtemp==1){getobj(objtemp+\"mydiv\").style.display=\"none\";}\n";
    $VA .= "    if (!getobj(inputid+\"mydiv\") && list!=\"\"){\n";
    $VA .= "        var divcss=\"width:240px;font-size:12px;position:absolute;left:\"+(inputid.offsetLeft+0)+\"px;top:\"+(inputid.offsetTop+23)+\"px;border:1px solid\";\n";
    $VA .= "        creatediv(\"\",\"div\",inputid+\"mydiv\",divcss);\n";
    $VA .= "        for (var i=0;i<text_list.length-1;i++){\n";
    $VA .= "            creatediv(inputid+\"mydiv\",\"li\",inputid+\"li\"+i,\"color:#000;background:#fff;list-style-type:none;padding:9px;margin:0;CURSOR:pointer\");\n";
    $VA .= "            getobj(inputid+\"li\"+i).innerHTML=text_list[i];\n";
    $VA .= "            getobj(inputid+\"li\"+i).onmouseover=function(){this.style.background=\"#eee\";}\n";
    $VA .= "            getobj(inputid+\"li\"+i).onmouseout=function(){this.style.background=\"#fff\"}\n";
    $VA .= "            getobj(inputid+\"li\"+i).onclick=function(){\n";
    $VA .= "                                                        inputid.value=this.innerHTML;\n";
    $VA .= "                                                        removediv(inputid);\n";
    $VA .= "                                                       }\n";
    $VA .= "        }\n";
    $VA .= "    }\n";
    $VA .= "    var newdiv=getobj(inputid+\"mydiv\");\n";
    //$VA .= "    newdiv.onclick=function(){removediv(inputid);}\n";
    $VA .= "    document.body.onclick = function(){removediv(inputid);}\n";
    $VA .= "    newdiv.onblur=function(){mouseout(this);}\n";
    $VA .= "    newdiv.style.display=\"block\";\n";
    $VA .= "    swtemp=1;\n";
    $VA .= "    objtemp=inputid;\n";
    $VA .= "    newdiv.focus();\n";
    $VA .= "  }\n";
    $VA .= "}\n;";
    $VA .= "</script>\n";

    return $VA;
  }

  function ShowCreateTagPage($Upload,$Item)
  {
    global $PG_CONN;
    $VC = "";
    $VC .= _("<h3>Create Tag:</h3>\n");

    /* Get ufile_name from uploadtree_pk */
    $sql = "SELECT ufile_name, ufile_mode FROM uploadtree
              WHERE uploadtree_pk = $Item";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $ufile_name = $row["ufile_name"];
    $ufile_mode = $row["ufile_mode"];
    pg_free_result($result);

    $VC.= "<form name='form' method='POST' action='" . Traceback_uri() ."?mod=tag&upload=$Upload&item=$Item'>\n";

    $VC .= "<p>";
    $text = _("Tag");
    $VC .= "$text: <input type='text' id='tag_name' name='tag_name' maxlength='32' utocomplete='off' onclick='Tags_Get(\"". Traceback_uri() . "?mod=tag_get&uploadtree_pk=$Item\")'/> ";

    /****** Permission comments: if user don't have add or high permission, can't see this check box ******/
    //$VC .= "<input type='checkbox' name='tag_add' value='1'/>";
    //$VC .= _("Check to confirm this is a new tag.");
    $VC .= "</p>";
    $text = _("Tag description:");
    $VC .= "<p>$text <input type='text' name='tag_desc'/></p>";
    $VC .= _("<p>Notes:</p>");
    $VC .= "<p><textarea rows='10' cols='80' name='tag_notes'></textarea></p>";

    if (Isdir($ufile_mode)) {
      $VC .= "<p><input type='hidden' name='tag_dir' value='1'/></p>";
    } else if (Iscontainer($ufile_mode)) {
      /* Recursively tagging UI part comment out */
      /*
       $text = _("Tag this files only.");
       $VC .= "<p><input type='checkbox' name='tag_file' value='1' checked/>$text</p>";
       $text = _("Tag all packages (source and binary) in this container tree.");
       $VC .= "<p><input type='checkbox' name='tag_package' value='1'/> $text</p>";
       $text = _("Tag every file in this container tree.");
       $VC .= "<p><input type='checkbox' name='tag_container' value='1'/> $text</p>";
       */
      $VC .= "<p><input type='hidden' name='tag_file' value='1'/></p>";
    } else {
      $VC .= "<p><input type='hidden' name='tag_file' value='1'/></p>";
    }
    $text = _("Create");
    $VC .= "<input type='hidden' name='action' value='add'/>\n";
    $VC .= "<input type='submit' value='$text'>\n";
    $VC .= "</form>\n";

    return $VC;
  }

  function ShowEditTagPage($Upload,$Item)
  {
    global $PG_CONN;
    $VEd = "";
    $text = _("Create New Tag");
    $VEd .= "<h4><a href='" . Traceback_uri() . "?mod=tag&upload=$Upload&item=$Item'>$text</a><h4>";

    $VEd .= _("<h3>Edit Tag:</h3>\n");
    $tag_file_pk = GetParm("tag_file_pk",PARM_INTEGER);

    /* Get ufile_name from uploadtree_pk */
    $sql = "SELECT ufile_name, ufile_mode FROM uploadtree
              WHERE uploadtree_pk = $Item";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $ufile_name = $row["ufile_name"];
    $ufile_mode = $row["ufile_mode"];
    pg_free_result($result);

    /* Get all information about $tag_file_pk (tag_file/tag_uploadtree table)*/
    if (Isdir($ufile_mode)) {
      $sql = "SELECT tag_pk, tag_uploadtree_text, tag, tag_desc FROM tag_uploadtree, tag WHERE tag_uploadtree_pk=$tag_file_pk AND tag_uploadtree.tag_fk = tag.tag_pk";
    } else {
      $sql = "SELECT tag_pk, tag_file_text, tag, tag_desc FROM tag_file, tag WHERE tag_file_pk=$tag_file_pk AND tag_file.tag_fk = tag.tag_pk";
    }
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $tag_pk = $row['tag_pk'];
    $tag = $row['tag'];
    if (Isdir($ufile_mode)) {
      $tag_notes = $row['tag_uploadtree_text'];
    } else {
      $tag_notes = $row['tag_file_text'];
    }
    $tag_desc = $row['tag_desc'];
    pg_free_result($result);

    $VEd.= "<form name='form' method='POST' action='" . Traceback_uri() ."?mod=tag&upload=$Upload&item=$Item'>\n";
    $VEd .= "<p>";
    $text = _("Tag");
    $VEd .= "$text: <input type='text' id='tag_name' name='tag_name' autocomplete='off' onclick='Tags_Get(\"". Traceback_uri() . "?mod=tag_get&uploadtree_pk=$Item\")' value=\"$tag\"/> ";
    $text = _("Tag description:");
    $VEd .= "<p>$text <input type='text' name='tag_desc' value=\"$tag_desc\"/></p>";
    $VEd .= _("<p>Notes:</p>");
    $VEd .= "<p><textarea rows='10' cols='80' name='tag_notes'>$tag_notes</textarea></p>";

    if (Isdir($ufile_mode)) {
      $VEd .= "<p><input type='hidden' name='tag_dir' value='1'/></p>";
    } else if (Iscontainer($ufile_mode)) {
      /*
       $text = _("Tag this files only.");
       $VEd .= "<p><input type='checkbox' name='tag_file' value='1' checked/>$text</p>";
       $text = _("Tag all packages (source and binary) in this container tree.");
       $VEd .= "<p><input type='checkbox' name='tag_package' value='1'/> $text</p>";
       $text = _("Tag every file in this container tree.");
       $VEd .= "<p><input type='checkbox' name='tag_container' value='1'/> $text</p>";
       */
      $VEd .= "<p><input type='hidden' name='tag_file' value='1'/></p>";
    } else {
      $VEd .= "<p><input type='hidden' name='tag_file' value='1'/></p>";
    }
    $text = _("Save");
    $VEd .= "<input type='hidden' name='action' value='update'/>\n";
    $VEd .= "<input type='hidden' name='tag_pk' value='$tag_pk'/>\n";
    $VEd .= "<input type='hidden' name='tag_file_pk' value='$tag_file_pk'/>\n";
    $VEd .= "<input type='submit' value='$text'>\n";
    $VEd .= "</form>\n";

    return $VEd;
  }

  function ShowDeleteTagPage($Upload,$Item)
  {
    global $PG_CONN;
    $VD = "";
    $VD .= _("<h3>Delete Tag:</h3>\n");

    /* Get ufile_name from uploadtree_pk */
    $sql = "SELECT ufile_name, ufile_mode FROM uploadtree
              WHERE uploadtree_pk = $Item";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    $row = pg_fetch_assoc($result);
    $ufile_name = $row["ufile_name"];
    $ufile_mode = $row["ufile_mode"];
    pg_free_result($result);

    $sql = "SELECT tag_pk, tag, tag_file_pk, tag_file_date, tag_file_text FROM tag, tag_file, uploadtree WHERE tag.tag_pk = tag_file.tag_fk AND tag_file.pfile_fk = uploadtree.pfile_fk AND uploadtree.uploadtree_pk = $Item;";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    if (pg_num_rows($result) > 0) {
      $VD .= "<form name='form' method='POST' action='" . Traceback_uri() ."?mod=tag&upload=$Upload&item=$Item'>\n";
      $VD .= "<select multiple size='10' name='tag_file_pk[]'>\n";
      while ($row = pg_fetch_assoc($result)) {
        $VD .= "<option value='" . $row['tag_file_pk'] . "'>" . "-" . $row['tag'] . "</option>\n";
      }
      $VD .= "</select>\n";
      if (Iscontainer($ufile_mode)) {
        $text = _("Delete Tag only for this file.");
        $VD .= "<p><input type='checkbox' name='tag_file' value='1' checked/>$text</p>";
        $text = _("Delete Tag for all packages (source and binary) in this container tree.");
        $VD .= "<p><input type='checkbox' name='tag_package' value='1'/>$text</p>";
        //$text = _("Delete Tag for every file in this container tree.");
        //$VD .= "<p><input type='checkbox' name='tag_container' value='1'/> $text</p>";
      } else {
        $VD .= "<p><input type='hidden' name='tag_file' value='1'/></p>";
      }
      $text = _("Delete");
      $VD .= "<input type='hidden' name='action' value='delete'/>\n";
      $VD .= "<input type='submit' value='$text'>\n";
      $VD .= "</form>\n";
    }
    pg_free_result($result);

    return ($VD);
  }

  function ShowTaggingPage($action,$ShowHeader=0)
  {
    $V = "";
    $Upload = GetParm("upload",PARM_INTEGER);
    $Item = GetParm("item",PARM_INTEGER);

    if (empty($Item) || empty($Upload)) {
      return;
    }

    /**********************************
     Display micro header
     **********************************/
    if ($ShowHeader) {
      $V .= Dir2Browse("browse",$Item,NULL,1,"Browse");
    }

    $V .=  $this->ShowExistTags($Upload,$Item);
    $V .= $this->ShowAjaxPage();

    if ($action == 'edit') {
      $V .= $this->ShowEditTagPage($Upload,$Item);
    } else {
        /* Show create tag page */
      if ($this->uploadDao->isEditable($Upload, Auth::getGroupId())) {
        $V .= $this->ShowCreateTagPage($Upload, $Item);
      } else {
        $nopermtext = _("You do not have permission to tag this upload.");
        $V .= $nopermtext;
      }
    }
    return($V);
  }


  public function Output()
  {
    $V="";
    $action = GetParm('action', PARM_TEXT);

    if ($action == 'add') {
      $rc = $this->CreateTag(null);
      if (! empty($rc)) {
        $text = _("Create Tag Failed");
        $this->vars['message'] = "$text: $rc";
      } else {
        $this->vars['message'] = _("Create Tag Successful!");
      }
    }
    if ($action == 'update') {
      $rc = $this->EditTag();
      if (! empty($rc)) {
        $text = _("Edit Tag Failed");
        $this->vars['message'] = "$text: $rc";
      } else {
        $this->vars['message'] = _("Edit Tag Successful!");
      }
    }
    if ($action == 'delete') {
      $rc = $this->DeleteTag();
      if (! empty($rc)) {
        $text = _("Delete Tag Failed");
        $this->vars['message'] = "$text: $rc";
      } else {
        $this->vars['message'] = _("Delete Tag Successful!");
      }
    }
    $V .= $this->ShowTaggingPage($action,1);

    return $V;
  }
}

$NewPlugin = new ui_tag();
$NewPlugin->Initialize();