protected function startup()
{
parent::startup();
$this->pagerFiles = new \Pager($this, 'pagingFiles');
$this->files = $this->context->createServiceFiles();
if (!$this->user->isInRole('administrator')) {
$this->files->where('file.user_id = ' . $this->user->id);
}
}
public static function getfile($module_name, $module_id)
{
$file_key = sha1($module_name . $module_id . 'o');
if (isset(static::$cache[$file_key])) {
return static::$cache[$file_key];
} else {
return static::$cache[$file_key] = Files::where('module_name', $module_name)->where('module_id', intval($module_id))->remember(SettingsModel::one('cachelife'))->first();
}
}
public function get_index()
{
$records = Files::where('parent_id', '=', (int) $_GET['node'])->get();
$result = '[';
foreach ($records as $record) {
$result .= '{
text: \'' . $record->text . '\',
leaf: ' . ($record->leaf ? 'true' : 'false') . ',
id: ' . $record->id . '
},';
}
$result .= ']';
return $result;
}
public function more()
{
$user = User::with('Course', 'Gender', 'userType')->where('StudentID', Auth::user()->StudentID)->first();
$adminGroupPages = GroupPage::where('StudentID', Auth::user()->StudentID)->where('delFlag', 0)->orderBy('created_at', 'DESC')->get();
$groupPages = GroupPageMember::with('groupPages')->where('StudentID', Auth::user()->StudentID)->where('delFlag', 0)->orderBy('created_at', 'DESC')->get();
if (Auth::user()->UserTypeID == 2) {
$files = Files::where('delFlag', 0)->where('folderID', 0)->where('OwnerID', Auth::user()->StudentID)->get();
$fileFolders = FilesFolder::where('OwnerID', Auth::user()->StudentID)->where('delFlag', 0)->orderBy('created_at', 'DESC')->get();
$activities = GroupPageActivity::where('OwnerID', Auth::user()->StudentID)->where('delFlag', 0)->get();
$quizzes = Quiz::where('delFlag', 0)->orderBy('created_at', 'DESC')->get();
} else {
$activities = GroupPageActivityGroup::with('groupPage', 'groupPageActivityFiles')->where('deadline', '>', date('Y-m-d H:i:s'))->whereExists(function ($q) {
$q->select(DB::raw(0))->from('grouppagemember')->whereRaw('grouppagemember.grouppageID = grouppageactivitygroup.grouppageID')->where('StudentID', Auth::user()->StudentID)->whereRaw('grouppagemember.delFlag = 0');
})->orderBy('deadline', 'ASC')->get();
$quizzes = QuizGroupPage::with('groupPageMember', 'groupPage', 'quiz')->where('delFlag', 0)->whereNotExists(function ($q) {
$q->select(DB::raw(0))->from('quiztaken', 'grouppagemember')->where('quiztaken.OwnerID', Auth::user()->StudentID)->whereRaw('quiztaken.quizID = quizgrouppage.quizID')->where('delFlag', 0);
})->get();
}
return View::make('validated.more', compact('user', 'adminGroupPages', 'groupPages', 'files', 'fileFolders', 'activities', 'quizzes'));
}
public function listedFiles()
{
$files = Files::where('id_inscription', '=', $this->id)->orderBy('created_at', 'asc')->get();
// dd($files);
/*$files = $this->hasMany('Files', 'id_inscription', 'id')->orderBy('created_at','ASC');*/
$archivitos = array();
// dd(substr($files[0]->title, -1));
// dd(count($files));
for ($i = 0, $counter = 1; $i < count($files);) {
$band = false;
$position = null;
for ($j = 0; $j < count($files); $j++) {
if (substr($files[$j]->title, -1) == $counter) {
// var_dump(substr($files[$j]->title, -1));
$band = true;
$position = $j;
}
}
if ($band) {
$archivitos[] = $files[$position];
$i++;
} else {
// var_dump(null."Aqui");
$archivitos[] = null;
}
/*if(substr($files[$i]->title, -1) == $counter+1):
var_dump(substr($files[$i]->title, -1));
$archivitos[] = $files[$i];
$i++;
else:
var_dump('No');
$archivitos[] = null;
endif;*/
$counter++;
}
// dd(new Illuminate\Database\Eloquent\Collection($archivitos));
return new Illuminate\Database\Eloquent\Collection($archivitos);
}
public function postPostsaveord()
{
$order = Input::get('order');
$id = Input::get('id');
$kappa = Files::where('id', $id)->first();
$kappa->ord = $order;
$kappa->save();
return [];
}
/**
* Upload file
* @return array
*/
public function add()
{
$data = array('module_id' => Input::get('module_id'), 'module_name' => Input::get('module_name'), 'num' => Input::get('num'), 'filepath' => Input::get('path'));
$filename = ltrim($data['filepath'], '/');
$name = basename($filename);
$extension = pathinfo($filename, PATHINFO_EXTENSION);
$dbfile = Files::where('path', 'like', "%{$name}")->first();
if ($dbfile) {
$filename = $dbfile->path;
$name = $dbfile->name;
$extension = $dbfile->extension;
}
$fid = Files::register($name, $filename, $extension, $data['module_name'], $data['module_id']);
$data['error'] = '0';
$data['succes'] = 'Uploaded!';
Log::info("File added #{$fid} - '{$filename}'");
return $data;
}
/**
* Download a File
*/
public function getDownloadFile($md5)
{
//Get the file
$file = \Files::where('key', '=', $md5)->first();
//Check if file exists
if (file_exists($file['file_sys_ref'] . $file['file_md5'])) {
return Response::download($file['file_sys_ref'] . $file['file_md5'], $file['file_name']);
} else {
Log::error("File " . $file['file_name'] . " does not exists.");
throw new \FileNotFoundException();
}
}
public function deleteFileFolder($id)
{
$folder = FilesFolder::find($id);
if (Auth::user()->StudentID == $folder->OwnerID) {
FilesFolder::find($id)->update(array('delFlag' => 1)) ? Files::where('folderID', $id)->update(array('delFlag' => 1)) : '';
}
}
public function getThumbsDown($id)
{
try {
$file = Files::where('id', $id)->firstOrFail();
$this->googleAnalytics('/files/thumbs-down/' . $id);
$file->thumbs_down++;
$file->save();
$thumbs = array();
if (Cookie::get('ps_thumbs')) {
$cookie = Cookie::get('ps_thumbs');
$thumbs = unserialize($cookie);
if (isset($thumbs['files'][$file->id])) {
return Response::json(array('status' => 'fail', 'message' => __("Већ сте оценили овај материјал")));
}
}
$thumbs['files'][$file->id] = 'down';
Cookie::queue('ps_thumbs', serialize($thumbs), '86400');
$response = array('status' => 'success', 'message' => __("Хвала на труду. Ваш глас је забележен"), 'thumbsUp' => $file->thumbs_up, 'thumbsDown' => $file->thumbs_down);
return Response::json($response);
} catch (Exception $e) {
return Response::json(array('status' => 'fail'));
}
}
<?php
$records = Files::where('parent_id', '=', (int) $_GET['node'])->get();
?>
[
<?php
foreach ($records as $record) {
?>
{
text: '<?php
echo $record->text;
?>
',
leaf: <?php
if ($record->leaf) {
echo 'true';
} else {
echo 'false';
}
?>
,
id: <?php
echo $record->id;
?>
},
<?php
}
?>
public static function coverImage($id)
{
return Files::where(array('module_name' => 'post_cover', 'module_id' => $id))->remember(SettingsModel::one('cachelife'))->first();
}
public function route($query = '')
{
$parts = explode('/', $query);
if ($parts) {
$uri = end($parts);
$this->data['page'] = Post::findURI($uri, 1);
if ($this->data['page']) {
PostResources::init();
// Verify if page is redirectable
if ($this->data['page']->redirect_to) {
$redirect_url = Post::getFullURI($this->data['page']->redirect_to);
if ($redirect_url) {
return Redirect::to($redirect_url);
}
}
// Verify if page is redirectable
if ($this->data['page']->redirect_to) {
$redirect_url = Post::getFullURI($this->data['page']->redirect_to);
if ($redirect_url) {
return Redirect::to($redirect_url);
}
}
Template::clearBreadCrumbs();
Template::addBreadCrumb("/", varlang('acasa'));
// Get pages resources
$this->data['parents'] = Post::getParents($this->data['page']['parent'], 1);
$this->data['parent'] = Post::findID($this->data['page']['parent'], 1);
$this->data['colevels'] = Post::findWithParent($this->data['page']['parent']);
$this->data['super_parent'] = array_first($this->data['parents'], function ($key, $item) {
return $item['parent'] == 0;
});
// get real page URI
$segments = array();
$parrents_ids = array($this->data['page']->id);
foreach (array_reverse($this->data['parents']) as $parrent) {
$segments[] = $parrent['uri'];
$parrents_ids[] = $parrent['id'];
Template::addBreadCrumb(Post::getURL(implode('/', $segments)), $parrent['title']);
}
$segments[] = $this->data['page']['uri'];
Template::addBreadCrumb(Post::getURL($query), $this->data['page']['title']);
$realURI = implode('/', $segments);
// Verify if real uri is correct
if ($realURI === $query) {
// get global data
View::share(array('active_page_id' => $this->data['page']->id, 'parrents_ids' => $parrents_ids, 'super_parent' => $this->data['super_parent']));
// Verify if this page is clone
if ($this->data['page']->clone_id) {
$clone = Post::findID($this->data['page']->clone_id, 1);
if ($clone) {
$this->data['page'] = $clone;
}
}
// Set page title
$this->data['top_title'] = $this->data['page']['title'];
WebAPL\Template::setPageTitle($this->data['page']['title']);
$this->data['page_url'] = WebAPL\Language::url("page/" . $realURI);
// Get page files
if ($this->data['page']->show_files) {
$this->data['page']['files'] = Files::where(array('module_name' => 'page', 'module_id' => $this->data['page']->id, 'type' => 'document'))->remember(SettingsModel::one('cachelife'))->get();
} else {
$this->data['page']['files'] = array();
}
// register one view
Post::oneView($this->data['page']['id']);
Template::setMetaMultiple(array('og:title' => $this->data['page']->title, 'description' => $this->data['page']->text, 'og:description' => $this->data['page']->text), true);
// load page
PageController::loadGeneralResources();
View::share('page', $this->data['page']);
if ($this->data['page']->general_node) {
return $this->loadHome();
} else {
return $this->loadPage();
}
} else {
throw new Exception("Query '{$query}' is not valid", 404);
}
} else {
throw new Exception("Page with uri '{$uri}' not found", 404);
}
} else {
throw new Exception("No valid page URI", 404);
}
}
public static function fileListPrepare($field, $post)
{
return Files::where(array('module_name' => 'doc_post_lang', 'module_id' => $post->post_lang_id, 'type' => 'document'))->get();
}
public static function dropFile($path, $id = 0)
{
$used = Files::where('path', 'like', "%{$path}")->where('id', '<>', $id)->count();
if (file_exists($_SERVER['DOCUMENT_ROOT'] . '/' . $path) && $used == 0) {
unlink($_SERVER['DOCUMENT_ROOT'] . '/' . $path);
}
}
