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