| Server IP : 66.29.137.217 / Your IP : 52.15.60.240 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/ideyshare.name.ng/app/controllers/ |
Upload File : |
<?php
namespace App\Controllers;
use App\Core\Database;
use App\Models\File;
use App\Models\FileFolder;
use App\Helpers\AuthHelper;
use App\Helpers\CoreHelper;
use App\Helpers\FileHelper;
use App\Helpers\FileFolderHelper;
use App\Helpers\ThemeHelper;
use App\Helpers\TranslateHelper;
class AccountSearchController extends AccountController
{
public function search() {
// pickup request
$request = $this->getRequest();
$db = Database::getDatabase();
$Auth = AuthHelper::getAuth();
// pickup params
$searchTerm = trim($request->query->get('t'));
if (strlen($searchTerm) == 0) {
return $this->redirect(CoreHelper::getCoreSitePath());
}
$pageTitle = TranslateHelper::t("search_page_title", "Searching [[[TERM]]]", array('TERM' => str_replace(array('"', '\''), '', $searchTerm)));
$filterUploadedDateRange = $request->query->has('filterUploadedDateRange') ? $request->query->get('filterUploadedDateRange') : '';
// prep params for template
$templateParams = $this->getFileManagerTemplateParams();
$templateParams = array_merge(array(
'pageTitle' => $pageTitle,
'pageType' => 'search',
'searchTerm' => $searchTerm,
'initialFileId' => null,
'filterUploadedDateRange' => $filterUploadedDateRange,
), $templateParams);
// load template
return $this->render('account/index.html', $templateParams);
}
public function ajaxSearchWidget() {
// setup result array
$rs = array();
// load database
$db = Database::getDatabase();
$Auth = AuthHelper::getAuth();
// get variables
$request = $this->getRequest();
$type = $request->query->get("type");
$query = $request->query->get("query");
if (strlen($query) == 0) {
return $this->renderJson($rs);
}
switch ($type) {
case 'images':
// lookup images (in this theme this is actually all files)
$images = $db->getRows('SELECT file.*, users.username, file_folder.folderName '
. 'FROM file '
. 'LEFT JOIN users ON file.userId = users.id '
. 'LEFT JOIN file_folder ON file.folderId = file_folder.id '
. 'WHERE file.status = "active" AND '
. '('
. 'file.userId = ' . (int) $Auth->id . ' OR file.uploadedUserId = ' . (int) $Auth->id . ' '
. 'OR ((file.folderId IN (SELECT folder_id FROM file_folder_share LEFT JOIN file_folder_share_item ON file_folder_share.id = file_folder_share_item.file_folder_share_id WHERE file_folder_share.shared_with_user_id = ' . (int) $Auth->id . ')))'
. ') '
. 'AND (file.originalFilename LIKE "%' . $db->escape($query) . '%" OR file.shortUrl LIKE "%' . $db->escape($query) . '%" OR file.keywords LIKE "%' . $db->escape($query) . '%") '
. 'ORDER BY uploadedDate DESC '
. 'LIMIT 10');
if ($images) {
foreach ($images AS $image) {
// hydrate so we have access to the file object
$fileObj = File::hydrateSingleRecord($image);
// prepare data
$lRs = array();
$lRs['id'] = $image['id'];
$lRs['title'] = $image['originalFilename'];
$lRs['url'] = $fileObj->getFullShortUrl();
$lRs['thumbnail'] = FileHelper::getIconPreviewImageUrl($image, false, 48, false, 100, 100, 'middle');
$lRs['owner'] = strlen($image['username']) ? $image['username'] : TranslateHelper::t('guest_user', 'Guest User');
$lRs['uploaded_date'] = CoreHelper::formatDate($image['uploadedDate']);
$lRs['folder_name'] = strlen($image['folderName']) ? ('in ' . $image['folderName']) : '';
$lRs['none'] = '';
// add to overall array
$rs[] = $lRs;
}
}
break;
case 'folders':
// lookup folders
$folders = $db->getRows('SELECT file_folder.id, file_folder.userId, users.username, file_folder.parentId, file_folder.folderName, file_folder.accessPassword, file_folder.coverImageId, (SELECT COUNT(file.id) FROM file WHERE file.folderId = file_folder.id AND file.status = "active") AS total_files '
. 'FROM file_folder '
. 'LEFT JOIN users ON file_folder.userId = users.id '
. 'WHERE file_folder.status IN ("active", "trash") AND (file_folder.folderName LIKE "%' . $db->escape($query) . '%") AND '
. '('
. 'file_folder.userId = ' . (int) $Auth->id . ' '
. 'OR ((file_folder.id IN (SELECT folder_id FROM file_folder_share LEFT JOIN file_folder_share_item ON file_folder_share.id = file_folder_share_item.file_folder_share_id WHERE file_folder_share.shared_with_user_id = ' . (int) $Auth->id . ')))'
. ') '
. 'ORDER BY date_added DESC, folderName ASC '
. 'LIMIT 10');
if ($folders) {
foreach ($folders AS $folder) {
// hydrate so we have access to the folder object
$folderObj = FileFolder::hydrateSingleRecord($folder);
$icon = 'folder_full_fm_grid.png';
if ($folder['fileCount'] == 0 && $folder['isPublic'] == 1) {
$icon = 'folder_fm_grid.png';
}
elseif ($folder['fileCount'] > 0 && $folder['isPublic'] == 1) {
$icon = 'folder_full_fm_grid.png';
}
elseif ($folder['fileCount'] >= 0 && $folder['isPublic'] == 0) {
$icon = 'folder_lock_fm_grid.png';
}
// prepare data
$lRs = array();
$lRs['id'] = $folder['id'];
$lRs['title'] = $folder['folderName'];
$lRs['url'] = $folderObj->getFolderUrl();
$lRs['thumbnail'] = ThemeHelper::getLoadedInstance()->getAccountImagePath() . '/' . $icon;
$lRs['owner'] = strlen($folder['username']) ? $folder['username'] : TranslateHelper::t('guest_user', 'Guest User');
$lRs['total_files'] = $folder['total_files'] . ' ' . ($folder['total_files'] == 1 ? (TranslateHelper::t('file', 'file')) : (TranslateHelper::t('files', 'files')));
$lRs['none'] = '';
// add to overall array
$rs[] = $lRs;
}
}
break;
}
return $this->renderJson($rs);
}
}