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); } }