/**
* Display a listing of the resource.
* GET /questions
*
* @return Response
*/
public function index()
{
if (Input::has('onlyAnswered')) {
return Question::has('answer')->with('answer')->orderBy('created_at', 'DESC')->get();
}
if (Input::has('best')) {
return Question::orderByRaw('RAND()')->take(3)->get();
}
return Question::orderBy('created_at', 'DESC')->get();
}
public function home()
{
$data['users'] = User::get()->count();
$data['fusers'] = User::whereSex('female')->get()->count();
$data['posts'] = Post::get()->count();
$data['cposts'] = Post::whereType('0')->get()->count();
$data['cpoll'] = Question::orderBy('id', 'desc')->first();
$data['vfcpoll'] = UsersAnswer::whereQuestionId($data['cpoll']->id)->get()->count();
$posts = PostReport::select(DB::raw('post_id, count(*) as rcount'))->groupBy(['post_id'])->orderBy('rcount', 'desc')->get();
$data['rposts'] = '';
$i = 0;
foreach ($posts as $key) {
$post = Post::find($key->post_id);
$data['rposts'][$i++] = ['id' => $post->id, 'text' => $post->post, 'uid' => $post->user_id, 'disable' => User::find($post->user_id)->disable, 'type' => $post->type, 'total' => $key->rcount, 'r1' => PostReport::wherePostId($post->id)->whereReportId(1)->get()->count(), 'r2' => PostReport::wherePostId($post->id)->whereReportId(2)->get()->count(), 'r3' => PostReport::wherePostId($post->id)->whereReportId(3)->get()->count()];
}
return View::make('admin.home', $data);
}
public function getViewresult()
{
$result = Results::where('user_id', Auth::user()->id)->first();
$result = Results::find($result['id']);
$data['pageTitle'] = "Quizzler | Dashboard";
$data['urlAddBack'] = "backends/dashboard";
$data['btnAddBack'] = '<i class="icon-reply"></i><span>Back<span>';
$data['labelPage'] = "The Quizzler Result";
$data['questions'] = Question::orderBy('id', 'desc')->get();
$data['formOrigin'] = 'quizz';
$data['activeD'] = 'active';
$result = Results::where('user_id', Auth::user()->id)->first();
$result = Results::find($result['id']);
$data['resultActive'] = $result->active;
if ($result->score >= 50) {
$data['resultScore'] = " Your scored " . $result->score . " %, You Passed.";
} else {
$data['resultScore'] = " Your scored " . $result->score . " %, You Failed.";
}
$data['resultQuestionId'] = json_decode($result->question_quizzler_answer);
return View::make('backends.dashboard.result', $data);
}
<?php
/*
|--------------------------------------------------------------------------
| 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 () {
$questions = Question::orderBy('created_at', 'desc')->get();
return View::make('index')->with('questions', $questions);
});
Route::post('/', function () {
$body = Input::get('question');
if (!empty($body)) {
$answer = Answer::orderByRaw("RAND()")->get()->first();
Question::create(array('body' => $body, 'answer' => $answer->body));
}
$questions = Question::orderBy('created_at', 'desc')->get();
return View::make('index')->with('questions', $questions);
});
public function carnival()
{
//return 'We Are Working';
//Changed
$data['date'] = $this->getBaseDateTime();
/*19-May-2015 Ehsan*/
$user = User::find(Auth::user()->id);
$url = Picture::find($user->picture);
$data['self'] = $url;
/*!!!!19-May-2015 Ehsan*/
// Everyday Question Generation
$data['question'] = null;
$data['prev_question'] = null;
$question = Question::orderBy('id', 'desc')->first();
$prev_question = Question::orderBy('id', 'desc')->skip(1)->first();
if ($question) {
$data['question'] = $question;
$data['options_of_question'] = QuestionOption::whereQuestionId($question->id)->get();
//$get_count_of_the_answers = DB::table('users_answers')->select(DB::raw('option_number,count(*) as count'))->join('question_options','users_answers.option_id', '=', 'question_options.id')->whereQuestionId($question->id)->groupBy('option_id')->groupBy('option_number')->orderBy('option_number')->get();
$data['answered'] = UsersAnswer::whereUserId(Auth::user()->id)->whereQuestionId($question->id)->first();
}
if ($prev_question) {
$data['prev_question'] = $prev_question;
$options_of_question = QuestionOption::whereQuestionId($prev_question->id)->get();
$total_answer = 0;
foreach ($options_of_question as $key) {
$current_answer = DB::table('users_answers')->select(DB::raw('count(*) as count'))->whereOptionId($key->id)->first()->count;
$total_answer += $current_answer;
$answers_count[$key->option_number] = array('option_details' => $key->option_details, 'total_answer' => $current_answer);
}
try {
foreach ($options_of_question as $key) {
$cur = $answers_count[$key->option_number]['total_answer'] * 1.0;
$percentage = $cur / $total_answer * 100.0;
$answers_count[$key->option_number]['total_answer'] = number_format((double) $percentage, 2, '.', '');
}
} catch (Exception $e) {
$answers_count[1]['total_answer'] = 33;
$answers_count[2]['total_answer'] = 33;
$answers_count[3]['total_answer'] = 33;
}
$data['total_votes'] = $total_answer;
$data['answers'] = $answers_count;
}
// ENd of Question Related Code
// Top And Flop Post Generation
$posts = Post::select('posts.*')->join('users', 'users.id', '=', 'posts.user_id')->where('users.disable', '0')->whereType('3')->orderBy('posts.id', 'desc')->take(30)->lists('id');
$top_post = DB::table('likes')->select(DB::raw('count(*) as like_count, post_id'))->whereIn('post_id', $posts)->orderBy('like_count', 'desc')->groupBy('post_id')->first();
// return json_encode($top_post);
$flop_post = DB::table('dislikes')->select(DB::raw('count(*) as dislike_count, post_id'))->whereIn('post_id', $posts)->orderBy('dislike_count', 'desc')->groupBy('post_id')->first();
$data['flop_post'] = null;
$data['top_post'] = null;
if ($top_post) {
$post = Post::whereId($top_post->post_id)->first();
/*19-May-2015 Ehsan*/
$user = User::find($post->user_id);
$url = Picture::find($user->picture);
$url = $url->url;
/*!!!!19-May-2015 Ehsan*/
$text = htmlentities($post->post);
/*Eve-26-May-Ehsan*/
/*!!!!Eve-26-May-Ehsan*/
$text = preg_replace('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', '<a target="_blank" href="$1">$1</a>', $text);
$text = preg_replace('/#([a-zA-Z0-9\\x{0980}-\\x{09FF}_])+/u', '<a href="#" class="tags">$0</a>', $text);
$text = nl2br($text);
$text = Emojione::shortnameToImage($text);
$now = Carbon::parse($post->created_at);
$data['top_post'] = array('id' => $post->id, 'post' => $text, 'user_id' => $post->user_id, 'img' => asset($url), 'like' => Like::wherePostId($post->id)->get()->count(), 'dislike' => Dislike::wherePostId($post->id)->get()->count(), 'liked' => Like::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'disliked' => Dislike::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'comment' => Comment::wherePostId($post->id)->get()->count(), 'ago' => $now->diffForHumans());
} else {
$data['top_post'] = null;
}
if ($flop_post) {
$post = Post::whereId($flop_post->post_id)->first();
/*19-May-2015 Ehsan*/
$user = User::find($post->user_id);
$url = Picture::find($user->picture);
$url = $url->url;
/*!!!!19-May-2015 Ehsan*/
$text = htmlentities($post->post);
/*Eve-26-May-Ehsan*/
/*!!!!Eve-26-May-Ehsan*/
$text = preg_replace('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', '<a target="_blank" href="$1">$1</a>', $text);
$text = preg_replace('/#([a-zA-Z0-9\\x{0980}-\\x{09FF}_])+/u', '<a href="#" class="tags">$0</a>', $text);
$text = nl2br($text);
$text = Emojione::shortnameToImage($text);
$now = Carbon::parse($post->created_at);
$data['flop_post'] = array('id' => $post->id, 'post' => $text, 'user_id' => $post->user_id, 'img' => asset($url), 'like' => Like::wherePostId($post->id)->get()->count(), 'dislike' => Dislike::wherePostId($post->id)->get()->count(), 'liked' => Like::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'disliked' => Dislike::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'comment' => Comment::wherePostId($post->id)->get()->count(), 'ago' => $now->diffForHumans());
} else {
$data['flop_post'] = null;
}
// Top And Flop Post Generation end
// Get All Available Reports and Feelings
$data['feelings'] = Feeling::get();
$data['reports'] = Report::get();
//
$data['notifications'] = $this->getNotification();
//Get Current Trends
$now = Carbon::now();
$before_12hours = Carbon::now()->subHours(12);
$data['tags'] = DB::table('hash_tagged_posts')->select('tag_id', 'tag', DB::raw('count(*) as count'))->join('hashtags', 'hashtags.id', '=', 'hash_tagged_posts.tag_id')->whereIn('hash_tagged_posts.post_id', function ($query) {
$query->select('id')->from('posts')->whereType('3');
})->whereBetween('hash_tagged_posts.created_at', array($before_12hours, $now))->groupBy(['tag_id', 'tag'])->orderBy('count', 'desc')->take(3)->get();
//Get Current Trends End
$data['page'] = "carnival";
return View::make('carnival')->with('data', $data);
}
public function getIndex()
{
$questions = Question::orderBy('id', 'DESC')->get();
return View::make('admin.teacher.questions.questionIndex')->with('questions', $questions);
}
public function getIndex()
{
$question = Question::orderBy('pin', 'desc')->orderBy('pin', 'desc')->orderBy('updated_at', 'desc')->orderBy('question_id', 'desc')->get();
return View::make('faq.index')->with(compact('question'));
}
Mail::send('emails.test', array(), function ($message) {
//$message->from('*****@*****.**', 'c01tana Ltd');
$message->to('*****@*****.**', 'rocard')->subject('test mail');
});
return 'done.';
});
Route::get('/', function () {
$data['users'] = User::all();
//$data['questions'] = DB::select( DB::raw("SELECT * FROM `questions` ORDER BY `created_at` DESC LIMIT 1") );
$data['questions'] = Question::orderBy('created_at', 'desc')->paginate(10);
$data['count'] = Question::all()->count();
return View::make('site.home')->with($data);
});
Route::get('questions', function () {
$data['users'] = User::all();
$data['questions'] = Question::orderBy('created_at', 'desc')->paginate(10);
$data['count'] = Question::all()->count();
return View::make('site.questions')->with($data);
});
Route::get('question/{id}/{slug}', function ($id, $slug) {
$data['users'] = User::all();
$data['qvotes'] = Qvote::where('question_id', '=', $id)->get();
$data['question'] = Question::find($id);
$data['answers'] = Answer::where('question_id', '=', $id)->orderBy('votes', 'desc')->get();
$data['comments'] = Comment::where('question_id', '=', $id)->orderBy('created_at', 'desc')->get();
$data['count'] = Answer::where('question_id', '=', $id)->count();
return View::make('site.question')->with($data);
});
Route::get('users', function () {
$data['users'] = User::orderBy('reputation', 'desc')->paginate(20);
return View::make('site.users')->with($data);
foreach ($usa->answer as $ansobj) {
$tempansarr[$ansobj->question_id] = $ansobj->answer_text;
}
foreach ($usa->categoryvendoranswer as $catansobj) {
$tempcatansarr[$catansobj->categoryvendor_id] = $catansobj->answer;
}
$useransarr[$usa->id]['login'] = $usa->email;
$useransarr[$usa->id]['id'] = $usa->id;
$useransarr[$usa->id]['answers'] = $tempansarr;
$useransarr[$usa->id]['catanswers'] = $tempcatansarr;
// dd($useransarr[]);
}
//dd($userswithanswers);
// $questions = Question::all();
// $users = User::whereIn('id', $user_ids)->get();
$questions = Question::orderBy('page')->where('event', '=', $exceleve)->where('page', '!=', 0)->orderBy('order')->get();
$categoryvendors = Categoryvendor::all();
// HEADER ROW FOR FOR EXCEL
$header1 = array();
$header1[] = '';
$header2 = array();
$header2[] = 'Login';
$preprojectnumber = '';
foreach ($questions as $header) {
/*echo $header->class_name."<br>";
echo $header->question_group."<br>";*/
if ($header->class_name != 'projects checkbox group') {
//echo "1";
$header1[] = $header->question_group;
$header2[] = $header->question_text;
} else {
public function getDashboard()
{
return View::make('dashboard')->withQuestions(Question::orderBy('created_at', 'DESC')->get());
}