LicenseMap.php

<?php
/*
Copyright (C) 2014-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.
*/

namespace Fossology\Lib\BusinessRules;

use Fossology\Lib\Data\LicenseRef;
use Fossology\Lib\Db\DbManager;
use Fossology\Lib\Proxy\LicenseViewProxy;

class LicenseMap
{
  const CONCLUSION = 1;
  const TRIVIAL = 2;
  const FAMILY = 3;
  const REPORT = 4;

  private $dbManager;
  private $usageId;
  private $groupId;
  private $map = array();

  public function __construct(DbManager $dbManager, $groupId, $usageId=null, $full=false)
  {
    $this->usageId = $usageId?:self::CONCLUSION;
    $this->groupId = $groupId;
    $this->dbManager = $dbManager;
    if ($this->usageId == self::TRIVIAL && !$full) {
      return;
    }
    $licenseView = new LicenseViewProxy($groupId);
    if ($full) {
      $query = $licenseView->asCTE()
            .' SELECT distinct on(rf_pk) rf_pk rf_fk, rf_shortname parent_shortname, rf_parent FROM (
                SELECT r1.rf_pk, r2.rf_shortname, usage, rf_parent FROM '.$licenseView->getDbViewName()
            .' r1 inner join license_map on usage=$1 and rf_fk=r1.rf_pk
             left join license_ref r2 on rf_parent=r2.rf_pk
            UNION
            SELECT rf_pk, rf_shortname, -1 usage, rf_pk rf_parent from '.$licenseView->getDbViewName()
            .') full_map ORDER BY rf_pk,usage DESC';

      $stmt = __METHOD__.".$this->usageId,$groupId,full";
    } else {
      $query = $licenseView->asCTE()
            .' SELECT rf_fk, rf_shortname parent_shortname, rf_parent FROM license_map, '.$licenseView->getDbViewName()
            .' WHERE rf_pk=rf_parent AND rf_fk!=rf_parent AND usage=$1';
      $stmt = __METHOD__.".$this->usageId,$groupId";
    }
    $dbManager->prepare($stmt,$query);
    $res = $dbManager->execute($stmt,array($this->usageId));
    while ($row = $dbManager->fetchArray($res)) {
      $this->map[$row['rf_fk']] = $row;
    }
    $dbManager->freeResult($res);
  }

  public function getProjectedId($licenseId)
  {
    if (array_key_exists($licenseId, $this->map)) {
      return $this->map[$licenseId]['rf_parent'];
    }
    return $licenseId;
  }

  public function getProjectedShortname($licenseId, $defaultName=null)
  {
    if (array_key_exists($licenseId, $this->map)) {
      return $this->map[$licenseId]['parent_shortname'];
    }
    return $defaultName;
  }

  public function getUsage()
  {
    return $this->usageId;
  }

  public function getGroupId()
  {
    return $this->groupId;
  }

  public function getTopLevelLicenseRefs()
  {
    $licenseView = new LicenseViewProxy($this->groupId,
      array('columns'=>array('rf_pk','rf_shortname','rf_fullname')),
      'license_visible');
    $query = $licenseView->asCTE()
          .' SELECT rf_pk, rf_shortname, rf_fullname FROM '.$licenseView->getDbViewName()
          .' LEFT JOIN license_map ON rf_pk=rf_fk AND rf_fk!=rf_parent AND usage=$1'
          .' WHERE license_map_pk IS NULL';
    $stmt = __METHOD__.".$this->usageId,$this->groupId";
    $this->dbManager->prepare($stmt,$query);
    $res = $this->dbManager->execute($stmt,array($this->usageId));
    $topLevel = array();
    while ($row = $this->dbManager->fetchArray($res)) {
      $topLevel[$row['rf_pk']] = new LicenseRef($row['rf_pk'],$row['rf_shortname'],$row['rf_fullname']);
    }
    return $topLevel;
  }

  public static function getMappedLicenseRefView($usageExpr='$1')
  {
    return "SELECT bot.rf_pk rf_origin, top.rf_pk, top.rf_shortname, top.rf_fullname FROM ONLY license_ref bot "
          ."LEFT JOIN license_map ON bot.rf_pk=rf_fk AND usage=$usageExpr "
          ."INNER JOIN license_ref top ON rf_parent=top.rf_pk OR rf_parent IS NULL AND bot.rf_pk=top.rf_pk";
  }

  public function getObligationsForLicenseRef($license_ref, $candidate = false)
  {
    $tableName = $candidate ? "obligation_candidate_map" : "obligation_map";
    $sql = "SELECT distinct(ob_fk) FROM $tableName WHERE rf_fk = $1;";
    $ob_fks = $this->dbManager->getRows($sql, [$license_ref],
      __METHOD__ . $tableName);
    $returnVal = [];
    foreach ($ob_fks as $row) {
      $returnVal[] = $row['ob_fk'];
    }
    return $returnVal;
  }
}