storage.php

<?php
/**
 * Copyright (c) UNA, Inc - https://una.io
 * MIT License - https://opensource.org/licenses/MIT
 *
 * @defgroup    UnaCoreSamples Samples
 * @{
 */

/*
 
INSERT INTO `sys_objects_storage` (`object`, `engine`, `params`, `token_life`, `cache_control`, `levels`, `table_files`, `ext_mode`, `ext_allow`, `ext_deny`, `quota_size`, `current_size`, `quota_number`, `current_number`, `max_file_size`, `ts`) VALUES
('sample', 'Local', '', 360, 2592000, 0, 'sample', 'allow-deny', 'jpg,jpeg,jpe,gif,png,svg', '', 0, 0, 0, 0, 0, 0);

CREATE TABLE IF NOT EXISTS `sample` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(10) unsigned NOT NULL,
  `remote_id` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `mime_type` varchar(128) NOT NULL,
  `ext` varchar(32) NOT NULL,
  `size` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `modified` int(11) NOT NULL,
  `private` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `remote_id` (`remote_id`)
);

*/

require_once('./../inc/header.inc.php');
require_once(BX_DIRECTORY_PATH_INC . "design.inc.php");

$oTemplate = BxDolTemplate::getInstance();
$oTemplate->setPageNameIndex (BX_PAGE_DEFAULT);
$oTemplate->setPageHeader ("Sample storage");
$oTemplate->setPageContent ('page_main_code', PageCompMainCode());
$oTemplate->getPageCode();

/**
 * page code function
 */
function PageCompMainCode()
{
    ob_start();

    ?>
<form enctype="multipart/form-data" method="POST">
    Choose a file to upload:
    <input name="file" type="file" />
    <br />
    <input type="submit" name="add" value="Upload File" />
</form>
    <?php

    $iProfileId = 123;
    BxDolStorage::pruning(); // pruning is needed to clear expired security tokens, you can call it on cron when your server is not busy
    $oStorage = BxDolStorage::getObjectInstance('sys_files');

    $aStorageObject = $oStorage->getObjectData();
    echo "<b>Engine: " . $aStorageObject['engine'] . '</b><br />';
    echo "<b>Endpoint: " . getParam('sys_storage_s3_endpoint') . '</b><br />';

    // echo '<pre>reloadMimeTypesFromFile: [' . $oStorage->reloadMimeTypesFromFile(/*'/Users/alex/mime.types'*/'/etc/apache2/mime.types') . ']</pre>';

    if (isset($_POST['add'])) {
        $iId = $oStorage->storeFileFromForm($_FILES['file'], true, $iProfileId);
        if ($iId) {
            $iCount = $oStorage->afterUploadCleanup($iId, $iProfileId);
            echo "<hr />uploaded file id: " . $iId . "(deleted ghosts:" . $iCount . ")<hr />";
        } else {
            echo "<hr />error uploading file: " . $oStorage->getErrorString() . "<hr />";
        }
    }

    if (isset($_POST['delete'])) {
        foreach ($_POST['file_id'] as $iFileId) {
            $bRet = $oStorage->deleteFile($iFileId, $iProfileId);
            if ($bRet)
                echo "<hr />deleted file id: " . $iFileId . "<hr />";
            else
                echo "<hr />file deleting error: " . $oStorage->getErrorString() . "<hr />";
        }
    } elseif (isset($_POST['public']) || isset($_POST['private'])) {
        $isPrivate = isset($_POST['private']) && $_POST['private'] ? true : false;
        $sAction = $isPrivate ? 'private' : 'public';
        foreach ($_POST['file_id'] as $iFileId) {
            $bRet = $oStorage->setFilePrivate($iFileId, $isPrivate);
            if ($bRet)
                echo "<hr /> making <b>$sAction</b> file id: " . $iFileId . "<hr />";
            else
                echo "<hr />file making <b>$sAction</b> error: " . $oStorage->getErrorString() . "<hr />";
        }
    }

    $a = $oStorage->getFilesAll();
    echo "<h2>Files List:</h2> <hr />";
    foreach ($a as $r)
        echo $r['file_name'] . '(private:[' . $oStorage->isFilePrivate($r['id']) . ']) : <img src="' . $oStorage->getFileUrlById($r['id']) . '" style="max-width:150px;" /> <hr />';

    echo '<form method="POST">';
    foreach ($a as $r)
        echo '<input type="checkbox" name="file_id[]" value="' . $r['id'] . '" /> ' . $r['file_name'] . '<br />';
    echo '<input type="submit" name="delete" value="Delete" /> <input type="submit" name="public" value="Set Public" /> <input type="submit" name="private" value="Set Private" />';
    echo '</form>';

    $s = ob_get_clean();
    return DesignBoxContent("Sample storage", $s, BX_DB_PADDING_DEF);

}

/** @} */