summary_backend.php

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
header("Cache-Control: no-cache, no-store, must-revalidate");

require_once("dbroconf.php");
require_once("helper_php/time.php");

foreach ($db_ro_confs as $conf) {
  if ($_GET["fs"] == $conf["fs"]) {
    $conn = new mysqli($conf["host"], $conf["user"], $conf["pass"], $conf["db"]);

    $usersql = "SELECT COUNT(DISTINCT uid) AS Users from ACCT_STAT WHERE count>0";
    $numfilesql = "SELECT SUM(count) AS Files FROM ACCT_STAT WHERE type='file'";
    $sizesql = "SELECT SUM(blocks) * 512 AS Size FROM ACCT_STAT";
    $oldnumfilesql = "SELECT COUNT(*) AS Oldfiles FROM ENTRIES WHERE type='file' AND last_access<" . $sixmonthsago;
    $oldsizesql = "SELECT SUM(blocks) * 512 AS Oldsize FROM ENTRIES WHERE ENTRIES.last_access<" . $sixmonthsago;

    $outp = "[";
    $userresult = $conn->query($usersql) or trigger_error($conn->error."[$usersql]");
    $numfilesresult = $conn->query($numfilesql) or trigger_error($conn->error."[$numfilesql]");
    $sizeresult = $conn->query($sizesql) or trigger_error($conn->error."[$sizesql]");
    $oldnumfilesresult = $conn->query($oldnumfilesql) or trigger_error($conn->error."[$oldnumfilesql]");
    $oldsizeresult = $conn->query($oldsizesql) or trigger_error($conn->error."[$oldsizesql]");
  
    $userrs = $userresult->fetch_array(MYSQLI_ASSOC);
    $numfilesrs = $numfilesresult->fetch_array(MYSQLI_ASSOC);
    $sizers = $sizeresult->fetch_array(MYSQLI_ASSOC);
    $oldnumfilesrs = $oldnumfilesresult->fetch_array(MYSQLI_ASSOC);
    $oldsizers = $oldsizeresult->fetch_array(MYSQLI_ASSOC);

    $percentold = sprintf('%0.2f', ($oldsizers["Oldsize"]/$sizers["Size"])*100);
    $available = $conf["size"] - $sizers["Size"];
  
    if ($outp != "[") {$outp .= ",";}
    $outp .= '{"File_System":"'       . $conf["fs"] . '",';
    $outp .= '"Number_of_Users":'     . (is_null($userrs["Users"]) ? 0 : $userrs["Users"])  . ',';
    $outp .= '"Total_Space":'         . (is_null($conf["size"]) ? 0 : $conf["size"]) . ',';
    $outp .= '"Used_Space":'          . (is_null($sizers["Size"]) ? 0 : $sizers["Size"])  . ',';
    $outp .= '"Available_Space":'     . (is_null($available) ? 0 : $available)  . ',';
    $outp .= '"Number_of_Files":'     . (is_null($numfilesrs["Files"]) ? 0 : $numfilesrs["Files"])  . ',';
    $outp .= '"Size_of_Old_Files":'   . (is_null($oldsizers["Oldsize"]) ? 0 : $oldsizers["Oldsize"])  . ',';
    $outp .= '"Number_of_Old_Files":' . (is_null($oldnumfilesrs["Oldfiles"]) ? 0 : $oldnumfilesrs["Oldfiles"])  . ',';
    $outp .= '"Percent_Old_Space":'   . (is_null($percentold) ? 0: $percentold) . '}';
    $outp .= "]";
    echo($outp);
  }
}
?>