11 define(
"TITLE_SIZE_DASHBOARD", _(
"Folder and upload dashboard"));
26 $this->Name =
"size_dashboard";
27 $this->Title = TITLE_SIZE_DASHBOARD;
28 $this->MenuList =
"Admin::Dashboards::Folder/Upload Proportions";
29 $this->Dependency = array();
31 parent::__construct();
32 $this->
dbManager = $GLOBALS[
'container']->get(
'db.manager');
33 $this->uploadDao = $GLOBALS[
'container']->get(
'dao.upload');
43 $sql =
'INNER JOIN upload ON upload.pfile_fk=pfile.pfile_pk '.
44 'INNER JOIN foldercontents ON upload.upload_pk=foldercontents.child_id '.
45 'WHERE parent_fk=$1;';
46 $statementName = __METHOD__.
"GetFolderSize";
47 $folderSizesql =
'SELECT SUM(pfile_size) FROM pfile '.$sql;
48 $row = $this->
dbManager->getSingleRow($folderSizesql,array($folderId),$statementName);
51 $statementName = __METHOD__.
"GetEachUploadSize";
52 $dispSql =
"SELECT upload_pk, upload_filename, pfile_size, " .
53 "to_char(upload_ts, 'YYYY-MM-DD HH24:MI:SS') AS upload_ts FROM pfile " . $sql;
54 $results = $this->
dbManager->getRows($dispSql, [$folderId], $statementName);
56 foreach ($results as $result) {
57 $clearingDuration = $this->uploadDao->getClearingDuration($result[
"upload_pk"]);
58 $var .=
"<tr><td align='left'>" . $result[
'upload_filename'] .
59 "</td><td align='left' data-order='{$result['pfile_size']}'>" .
61 "</td><td align='left' data-order='{$clearingDuration[1]}'>$clearingDuration[0]</td>
62 <td align='left'>{$result['upload_ts']}</td></tr>";
64 return [$var, $folderSize];
75 "SELECT upload_pk, upload_filename, pfile_size, to_char(upload_ts, 'YYYY-MM-DD HH24:MI:SS') AS upload_ts " .
77 "INNER JOIN upload ON upload.pfile_fk=pfile.pfile_pk " .
78 "INNER JOIN foldercontents ON upload.upload_pk=foldercontents.child_id " .
81 __METHOD__.
"ExportData"
85 foreach ($results as $row) {
86 $clearingDuration = $this->uploadDao->getClearingDuration($row[
"upload_pk"]);
88 'name' => $row[
'upload_filename'],
89 'size' => $row[
'pfile_size'],
90 'duration' => $clearingDuration[1],
91 'date' => $row[
'upload_ts']
111 header(
'Content-Type: text/csv');
112 header(
'Content-Disposition: attachment; filename="folder_export.csv"');
114 $output = fopen(
'php://output',
'w');
115 fputcsv($output, [
'Upload Name',
'Size (bytes)',
'Clearing Duration (seconds)',
'Upload Date']);
117 foreach ($data as $row) {
135 header(
'Content-Type: application/json');
136 header(
'Content-Disposition: attachment; filename="folder_export.json"');
137 echo json_encode($data, JSON_PRETTY_PRINT);
147 if (!empty($exportFormat) && in_array($exportFormat, [
'csv',
'json'])) {
153 if (empty($folderId)) {
159 $formVars[
"onchangeURI"] =
Traceback_uri() .
"?mod=" . $this->Name .
"&selectfolderid=";
161 $formVars[
"tableVars"] = $tableVars;
162 $formVars[
"wholeFolderSize"] = $wholeFolderSize;
163 $formVars[
"currentFolderId"] = $folderId;
165 return $this->
renderString(
"admin-folder-size-form.html.twig", $formVars);
This is the Plugin class. All plugins should:
renderString($templateName, $vars=null)
getFolderAndUploadSize($folderId)
Given a folder's ID function will get size of the folder and uploads under it.
__construct()
base constructor. Most plugins will just use this
Output()
Generate the text for this plugin.
outputJSON($data)
Outputs data in JSON format.
generateExportData($folderId, $format)
Generate export data in CSV or JSON format for a given folder ID.
outputCSV($data)
Outputs data in CSV format.
FolderListOption($ParentFolder, $Depth, $IncludeTop=1, $SelectId=-1, $linkParent=false, $OldParent=0)
Create the folder tree, using OPTION tags.
FolderGetTop()
DEPRECATED! Find the top-of-tree folder_pk for the current user.
Traceback_uri()
Get the URI without query to this location.
GetParm($parameterName, $parameterType)
This function will retrieve the variables and check data types.
HumanSize( $bytes)
Translate a byte number to a proper type, xxx bytes to xxx B/KB/MB/GB/TB/PB.
#define PLUGIN_DB_WRITE
Plugin requires write permission on DB.
fo_dbManager * dbManager
fo_dbManager object