public function showDashboard() { $data = []; $loginid = Session::get('user')->id; $collegeid = Session::get('user')->collegeid; $flag = Session::get('user')->flag; $tb = ""; if ($flag == 1) { $tb = "Admin"; } else { if ($flag == 2) { $tb = "Teacher"; } else { if ($flag == 3) { $tb = "Student"; } else { $tb = "Staff"; } } } $dt = $tb::where('loginid', '=', $loginid)->first(); $data['name'] = $dt->name; $data['pic'] = $dt->profilepic; $data['id'] = $loginid; //Cards value $data['students'] = Student::where('collegeid', '=', $collegeid)->count(); $data['teachers'] = Teacher::where('collegeid', '=', $collegeid)->count(); $data['subjects'] = Subject::where('collegeid', '=', $collegeid)->count(); $data['parents'] = $data['students'] * 2; return View::make('pages.dashboard', array('data' => $data, 'flag' => $flag)); }
/** * Find a subject of an University * * @return JSON Ajax */ public function find() { if (Request::ajax()) { $subject = Subject::where('name', Input::get('name'))->where('university_id', Auth::id())->first(); return Response::json($subject); } }
/** * Display a listing of the resource. * * @return Response */ public function index($classId, $subjectId) { $user = \Auth::user(); $term = 'First Term'; if ($_GET['class']) { $this->class = $_GET['class']; $this->subject = $_GET['subject']; \Session::put('class', $_GET['class']); \Session::put('subject', $_GET['subject']); } $classe_id = Classe::where('name', $classId)->first()->id; $subject_id = Subject::where('name', $this->subject)->first()->id; $classeName = Classe::where('name', $this->class)->first()->name; $subjectName = Subject::where('name', $this->subject)->first()->name; //dd($classe_id); $count = 1; $questions = Question::where('classe_id', $classId)->where('subject_id', $subjectId)->orderBy(\DB::raw('RAND()'))->get(); $totals = Question::where('classe_id', $classId)->where('subject_id', $subjectId)->paginate(1); $checked_items = []; if (\Session::has('checked_items')) { $checked_items = \Session::get('checked_items'); } // $checked_items = array_merge($checked_items, \Input::get('abc')); \Session::flash('checked_items', $checked_items); }
/** * Find a unused section * * @return JSON Ajax */ public function findUnusedSection() { if (Request::ajax()) { $subject = Subject::where('university_id', Auth::id())->where("_id", new MongoId(Input::get("_id")))->first(); $sections = $subject->sections()->where('is_free', true)->whereNull('deleted_at')->get(); if (count($sections) > 0) { return Response::json(array('subject' => $subject->_id, 'sections' => $sections)); } } }
public function getLastIdSubject($idCourse) { $idCourseTest = (int) ($idCourse / 1000) * 1000; $idCoureFirst = (int) ($idCourse / 1000000); $subject = Subject::where('id_course', '>=', $idCourseTest)->where('id_course', '<=', $idCourseTest + 100)->orderBy('id', 'desc')->first(); if (is_null($subject)) { return $idCoureFirst * 1000000; } else { $id = (string) $subject->id; $first = (string) $idCoureFirst; $last = substr($id, 3, strlen($id) - 3); return $first . $last; } }
public function sitemap() { $sitemap = App::make("sitemap"); // set item's url, date, priority, freq $sitemap->add(Request::root(), '2012-08-25T20:10:00+02:00', '1.0', 'daily'); $sitemap->add(Request::root() . "/marketing", '2013-08-20T20:20:00+02:00', '1.0', 'monthly'); $sitemap->add(Request::root() . "/puskice", '2013-08-20T20:20:00+02:00', '1.0', 'monthly'); if (Cache::has('posts_query')) { $posts = Cache::get('posts_query'); } else { $posts = News::get(); Cache::put('posts_query', $posts, 10080); } foreach ($posts as $post) { if ($post->post_type == 1) { $sitemap->add(Request::root() . "/vest/" . Puskice::dateToUrl($post->created_at) . "/" . $post->permalink, $post->updated_at, '1.0', 'daily'); } if ($post->post_type == 2) { $sitemap->add(Request::root() . "/stranica/" . $post->permalink, $post->updated_at, '1.0', 'daily'); } if ($post->post_type == 3) { $subject = Subject::where('news_id', '=', $post->id)->first(); if ($subject != null) { $sitemap->add(Request::root() . "/" . Puskice::getYear($subject->semester) . "/" . Puskice::getDepartment($subject->department) . "/" . $post->permalink, $post->updated_at, '1.0', 'monthly'); } else { Log::info('Predmet za vest: ' . $post->id . ' nije definisan'); } } } if (Cache::has('meme_query')) { $memes = Cache::get('meme_query'); } else { $memes = MemeInstance::get(); Cache::put('meme_query', $memes, 10080); } foreach ($memes as $meme) { $sitemap->add(Request::root() . "/meme/" . $meme->id . "-" . $meme->permalink, $meme->updated_at, '1.0', 'daily'); } // show your sitemap (options: 'xml' (default), 'html', 'txt', 'ror-rss', 'ror-rdf') return $sitemap->render('xml'); }
public function getlist() { $rules = ['class' => 'required', 'section' => 'required', 'shift' => 'required', 'session' => 'required', 'date' => 'required', 'subject' => 'required']; $validator = \Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::to('/attendance/list/')->withErrors($validator); } else { $classes2 = ClassModel::orderby('code', 'asc')->lists('name', 'code'); $subjects = Subject::where('class', Input::get('class'))->lists('name', 'code'); $attendance = DB::table('Attendance')->join('Student', 'Attendance.regiNo', '=', 'Student.regiNo')->select('Attendance.id', 'Attendance.regiNo', 'Student.rollNo', 'Student.firstName', 'Student.middleName', 'Student.lastName', 'Attendance.status')->where('Attendance.class', '=', Input::get('class'))->where('Attendance.section', '=', Input::get('section'))->Where('Attendance.shift', '=', Input::get('shift'))->where('Attendance.session', '=', trim(Input::get('session')))->where('Attendance.subject', '=', Input::get('subject'))->where('Attendance.date', '=', $this->parseAppDate(Input::get('date')))->get(); $formdata = new formfoo(); $formdata->class = Input::get('class'); $formdata->section = Input::get('section'); $formdata->shift = Input::get('shift'); $formdata->session = Input::get('session'); $formdata->subject = Input::get('subject'); $formdata->date = Input::get('date'); if (count($attendance) == 0) { $noResult = array("noresult" => "No Attendance Found!!"); return View::Make('app.attendanceList', compact('classes2', 'attendance', 'subjects', 'formdata', 'noResult')); //return Redirect::to('/attendance/list')->withInput(Input::all())->with("noresult","No Attendance Found!!"); } return View::Make('app.attendanceList', compact('classes2', 'attendance', 'subjects', 'formdata')); } }
public function getlist() { $rules = ['class' => 'required', 'section' => 'required', 'shift' => 'required', 'session' => 'required', 'exam' => 'required', 'subject' => 'required']; $validator = \Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::to('/mark/list/')->withErrors($validator); } else { $classes2 = ClassModel::orderby('code', 'asc')->lists('name', 'code'); $subjects = Subject::where('class', Input::get('class'))->lists('name', 'code'); $marks = DB::table('Marks')->join('Student', 'Marks.regiNo', '=', 'Student.regiNo')->select('Marks.id', 'Marks.regiNo', 'Student.rollNo', 'Student.firstName', 'Student.middleName', 'Student.lastName', 'Marks.written', 'Marks.mcq', 'Marks.practical', 'Marks.ca', 'Marks.total', 'Marks.grade', 'Marks.point', 'Marks.Absent')->where('Marks.class', '=', Input::get('class'))->where('Marks.section', '=', Input::get('section'))->Where('Marks.shift', '=', Input::get('shift'))->where('Marks.session', '=', trim(Input::get('session')))->where('Marks.subject', '=', Input::get('subject'))->where('Marks.exam', '=', Input::get('exam'))->get(); $formdata = new formfoo(); $formdata->class = Input::get('class'); $formdata->section = Input::get('section'); $formdata->shift = Input::get('shift'); $formdata->session = Input::get('session'); $formdata->subject = Input::get('subject'); $formdata->exam = Input::get('exam'); if (count($marks) == 0) { $noResult = array("noresult" => "No Results Found!!"); //return Redirect::to('/mark/list')->with("noresult","No Results Found!!"); return View::Make('app.markList', compact('classes2', 'subjects', 'marks', 'noResult', 'formdata')); } return View::Make('app.markList', compact('classes2', 'subjects', 'marks', 'formdata')); } }
public function exportData($id_course) { $listSubject = Subject::select('id', 'name', 'id_course', 'mean', 'total', 'num_word', 'time_date')->where('id_course', $id_course)->get(); $size = count($listSubject); for ($i = 0; $i < $size; $i++) { $subject = $listSubject[$i]; $count = Word::where('id_subject', $subject->id)->count(); Subject::where('id', $subject->id)->update(array('total' => $count)); } try { $course_name = $this->convertNameCourse($id_course); $strListSubject = json_encode(Subject::select('id', 'name', 'id_course', 'mean', 'total', 'num_word', 'time_date')->where('id_course', $id_course)->get()); $strListWord = json_encode(Word::select('id_word', 'id_subject', 'id_course', 'word', 'mean', 'example', 'example_mean', 'num_ef', 'time_date', 'next_time', 'num_n', 'num_i', 'max_q', 'phonetic', 'des')->where('id_course', $id_course)->get()); $filePathSubject = public_path() . '/AllData/' . $course_name . '/' . $id_course . '/json/'; $filePathWord = public_path() . '/AllData/' . $course_name . '/' . $id_course . '/json/'; $this->createFolder($filePathSubject); $this->createFolder($filePathWord); $fileNameSubject = $filePathSubject . 'subject.json'; $fileNameWord = $filePathWord . 'words.json'; $fileSubject = fopen($fileNameSubject, "w"); $fileWord = fopen($fileNameWord, "w"); if (fwrite($fileSubject, $strListSubject) && fwrite($fileWord, $strListWord)) { fclose($fileSubject); fclose($fileWord); return true; } else { fclose($fileSubject); fclose($fileWord); return false; } } catch (Exception $e) { return false; } }
public function singleSubject($year, $department, $permalink) { try { $permalink = str_replace("_", "-", $permalink); if (Session::get('user_level') >= Config::get('cms.viewAdminNews')) { $page = News::where('post_type', '=', 3)->where('published', '>=', 1)->where('permalink', '=', $permalink)->firstOrFail(); } else { $page = News::where('post_type', '=', 3)->where('published', '=', 2)->where('created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->where('permalink', '=', $permalink)->firstOrFail(); } $subjects = Subject::where('news_id', '=', $page->id)->get(); $sub = Subject::where('news_id', '=', $page->id)->first(); $allow = false; foreach ($subjects as $key => $subject) { if ($year == Puskice::getYear($subject->semester) && Puskice::getDepartment($subject->department) == $department) { $allow = true; } } if (!$allow) { App::abort(404); } $articles = News::inCategories(Config::get('settings.homepage'))->where('published', '=', 2)->where('post_type', '=', 1)->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->distinct('permalink')->groupBy('news.id')->orderBy('news.created_at', 'desc')->take(10)->get(); $featured = News::where('published', '=', 2)->where('featured', '=', 1)->where('post_type', '=', 1)->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->orderBy('created_at', 'desc')->take(3)->get(); $results = News::inCategories(Config::get('settings.results'))->where('published', '=', 2)->where('post_type', '=', 1)->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->distinct('permalink')->groupBy('news.id')->orderBy('news.created_at', 'desc')->take(4)->get(); $featuredImage = News::inCategories(array(25))->where('published', '=', 2)->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->where('post_type', '=', 1)->distinct('permalink')->groupBy('news.id')->orderBy('news.created_at', 'desc')->take(3)->get(); $didYouKnow = News::inCategories(array(30))->where('published', '=', 2)->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->where('post_type', '=', 1)->distinct('permalink')->groupBy('news.id')->orderBy('news.created_at', 'desc')->take(3)->get(); $magazine = News::inCategories(Config::get('settings.magazine'))->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->where('published', '=', 2)->where('post_type', '=', 1)->distinct('permalink')->groupBy('news.id')->orderBy('news.created_at', 'desc')->take(4)->get(); $ourComment = News::inCategories(array(17))->where('published', '=', 2)->where('news.created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->where('post_type', '=', 1)->distinct('permalink')->groupBy('news.id')->orderBy('news.created_at', 'desc')->take(4)->get(); $feed = getFeed('http://bazaznanja.puskice.org/feed/qa.rss', 4); $poll = null; $poll = Poll::where('published', '=', '1')->where('end_date', '>', date("Y-m-d H:i:s", strtotime('now')))->where('created_at', '<', date("Y-m-d H:i:s", strtotime('now')))->first(); if (isset($poll->id)) { $poll->pollOptions; } View::share('title', strip_tags($page->title) . " | Пушкице"); $ogimage = firstImage($page); $meta = "\t<meta property='og:image' content='" . str_replace(" ", "%20", $ogimage) . "'/>\n\t\t\t\t\t\t<meta property='og:title' content='" . __($page->title . " | Пушкице") . "'/>\n\t\t\t\t\t\t<meta property='fb:app_id' content='355697367892039'/>\n\t\t\t\t\t\t<meta property='og:site_name' content='" . __("Пушкице - ФОН Андерграунд") . "'/>\n\t\t\t\t\t\t<meta property='og:type' content='article'/>\n\t\t\t\t\t\t<meta property='og:url' content='" . _l(Request::root() . "/" . Puskice::getYear($sub->semester) . "/" . Puskice::getDepartment($sub->department) . "/" . $page->permalink) . "'/>\n\t\t\t\t\t\t<meta property='og:description' content='" . __(dots(strip_tags($page->short_content), 500)) . "' />\n\t\t\t\t\t\t<meta name='twitter:card' content='summary_large_image'>\n\t\t\t\t\t\t<meta name='twitter:site' content='" . __("Пушкице - ФОН Андерграунд") . "'>\n\t\t\t\t\t\t<meta name='twitter:creator' content='@puskice'>\n\t\t\t\t\t\t<meta name='twitter:domain' content='puskice.org'>\n\t\t\t\t\t\t<meta name='twitter:app:name:iphone' content='" . __("Пушкице") . "'>\n\t\t\t\t\t\t<meta name='twitter:app:name:ipad' content='" . __("Пушкице") . "'>\n\t\t\t\t\t\t<meta name='twitter:title' content='" . __($page->title . " | Пушкице") . "'>\n\t\t\t\t\t\t<meta name='twitter:description' content='" . __(dots(strip_tags($page->short_content), 500)) . "'>\n\t\t\t\t\t\t<meta name='twitter:image' content='" . str_replace(" ", "%20", $ogimage) . "'>"; $page->view_count++; $page->save(); $data = array('articles' => $articles, 'featured' => $featured, 'results' => $results, 'ourComment' => $ourComment, 'magazine' => $magazine, 'featuredImage' => $featuredImage, 'didYouKnow' => $didYouKnow, 'feed' => $feed, 'poll' => $poll, 'meta' => $meta, 'sub' => $sub, 'page' => $page); $this->setLayout($data); $this->layout->center = View::make('frontend.content.subject', $data); } catch (Exception $e) { return App::abort(404); } }
/* |-------------------------------------------------------------------------- | Application Routes |-------------------------------------------------------------------------- | | Here is where you can register all of the routes for an application. | It's a breeze. Simply tell Laravel the URIs it should respond to | and give it the Closure to execute when that URI is requested. | */ Route::get('/', function () { return View::make('sem'); })->before('auth'); Route::get('main/{sem}', function ($sem) { $subjects = Subject::where('sem', '=', $sem)->orderBy('name')->get(); return View::make('sub')->with('subjects', $subjects)->with('sem', $sem); })->before('auth'); Route::get('question/{id}', 'QuestionController@showQuestion')->before('auth'); //Show Route::get('question/create/{id}', 'QuestionController@createQuestion')->before('auth'); //Create Route::post('question/{id}', 'QuestionController@storeQuestion')->before('auth'); //Store Route::get('question/edit/{qid}', 'QuestionController@editQuestion')->before('auth'); //Edit Route::put('question/{qid}', 'QuestionController@updateQuestion')->before('auth'); //Update Route::delete('question/{qid}', 'QuestionController@deleteQuestion')->before('auth'); //Delete Route::get('generate/{id}', 'GenerateController@pickUnits')->before('admin');
public function getSubjects($category_id) { $subjects = Subject::where('category_id', '=', $category_id)->get(array('id', 'name')); return Response::json($subjects); }