UploadTreeViewProxy.php

<?php
/*
 SPDX-FileCopyrightText: © 2014 Siemens AG
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
namespace Fossology\Lib\Proxy;
 
use Fossology\Lib\Data\Tree\ItemTreeBounds;
 
class UploadTreeViewProxy extends DbViewProxy
{
  const CONDITION_UPLOAD = 1;
  const CONDITION_RANGE = 2;
  const CONDITION_PLAIN_FILES = 3;
 
  public function __construct(ItemTreeBounds $itemTreeBounds, $constraints = array(), $viewSuffix=null)
  {
    $dbViewQuery = self::getUploadTreeView($itemTreeBounds, $constraints);
    parent::__construct($dbViewQuery, 'UploadTreeView' . ($viewSuffix ? '.' . $viewSuffix : ''));
  }
 
  private static function getUploadTreeView(ItemTreeBounds $itemTreeBounds, $constraints)
  {
    $uploadTreeTableName = $itemTreeBounds->getUploadTreeTableName();
    $isDefaultTable = $uploadTreeTableName == 'uploadtree_a' || $uploadTreeTableName == 'uploadtree';
    if ($isDefaultTable) {
      $constraints[] = self::CONDITION_UPLOAD;
    }
    $baseQuery = "SELECT * FROM $uploadTreeTableName";
    $condition = self::getConstraintsCondition($itemTreeBounds, $constraints);
    return $baseQuery . $condition;
  }
 
  private static function getConstraintsCondition(ItemTreeBounds $itemTreeBounds, $constraints)
  {
    $conditions = array();
    foreach (array_unique($constraints) as $constraint) {
      $conditions[] = self::getConstraintCondition($itemTreeBounds, $constraint);
    }
    $condition = implode(' AND ', $conditions);
    return $condition ? ' WHERE ' . $condition : '';
  }
 
  private static function getConstraintCondition(ItemTreeBounds $itemTreeBounds, $constraint)
  {
    switch ($constraint) {
      case self::CONDITION_UPLOAD:
        $uploadId = $itemTreeBounds->getUploadId();
        return "upload_fk = $uploadId";
      case self::CONDITION_RANGE:
        $left = $itemTreeBounds->getLeft();
        $right = $itemTreeBounds->getRight();
        return "lft BETWEEN $left AND $right";
      case self::CONDITION_PLAIN_FILES:
        return '((ufile_mode & (3<<28))=0) AND pfile_fk != 0';
      default:
        throw new \InvalidArgumentException("constraint $constraint is not defined");
    }
  }
}