DataTablesUtility.php

<?php
/*
 SPDX-FileCopyrightText: © 2014 Siemens AG
 Author: J.Najjar
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
namespace Fossology\Lib\Util;
 
use Monolog\Logger;
 
class DataTablesUtility
{
  private $logger;
 
  function __construct()
  {
    $this->logger = new Logger(self::class);
  }
 
  public function getSortingParametersFromArray($inputArray, $columNamesInDatabase, $defaultSearch = array())
  {
    if (array_key_exists('iSortingCols', $inputArray)) {
      if ($inputArray['iSortingCols'] > count($columNamesInDatabase)) {
        $this->logger->warning(
          "did have enough columNames for " . $inputArray['iSortingCols'] .
          " sort columns.");
        return null;
      }
      return $this->getSortingParametersFromArrayImpl($inputArray,
        $columNamesInDatabase, $defaultSearch);
    } else {
      $this->logger->warning("did not find iSortingCols in inputArray");
      return null;
    }
  }
 
 
  private function getSortingParametersFromArrayImpl($inputArray, $columNamesInDatabase, $defaultSearch = array())
  {
    $orderArray = array();
    $sortedCols = array();
    for ($i = 0; $i < $inputArray['iSortingCols']; $i ++) {
      $whichCol = 'iSortCol_' . $i;
      $colNumber = $inputArray[$whichCol];
      $sortedCols[] = intval($colNumber);
 
      $isSortable = $inputArray['bSortable_' . $i];
      if ($isSortable !== "true") {
        continue;
      }
      $name = $columNamesInDatabase[$colNumber];
 
      $whichDir = 'sSortDir_' . $i;
      $order = $inputArray[$whichDir];
      $orderArray[] = $name . " " . $order;
    }
 
    foreach ($defaultSearch as $search) {
      $colNumber = $search[0];
      $order = $search[1];
      if (in_array($colNumber, $sortedCols)) {
        continue;
      }
      $isSortable = $inputArray['bSortable_' . $colNumber];
      if ($isSortable !== "true") {
        continue;
      }
 
      $name = $columNamesInDatabase[$colNumber];
      $orderArray[] = $name . " " . $order;
    }
    return $orderArray;
  }
 
 
  public function getSortingString($inputArray, $columNamesInDatabase, $defaultSearch = array())
  {
    $orderArray = $this->getSortingParametersFromArray($inputArray, $columNamesInDatabase, $defaultSearch);
    return empty($orderArray) ? "" : "ORDER BY " . implode(", ", $orderArray);
  }
}