| Server IP : 66.29.137.217 / Your IP : 18.119.107.255 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/cbt.bofirm.com/app/Repositories/ |
Upload File : |
<?php
/**
* File name: QuizRepository.php
* Last modified: 10/07/21, 3:08 PM
* Author: NearCraft - https://codecanyon.net/user/nearcraft
* Copyright (c) 2021
*/
namespace App\Repositories;
use Illuminate\Support\Facades\DB;
class QuizRepository
{
/**
* Quiz Configuration Steps
*
* @param null $qId
* @param string $active
* @return array[]
*/
public function getSteps($qId = null, $active = 'details')
{
return [
[
'step' => 1,
'key' => 'details',
'title' => __('Details'),
'status' => $active == 'details' ? 'active' : 'inactive',
'url' => $qId != null ? route('quizzes.edit', ['quiz' => $qId]) : ''
],
[
'step' => 2,
'key' => 'settings',
'title' => __('Settings'),
'status' => $active == 'settings' ? 'active' : 'inactive',
'url' => $qId != null ? route('quizzes.settings', ['quiz' => $qId]) : ''
],
[
'step' => 3,
'key' => 'questions',
'title' => __('Questions'),
'status' => $active == 'questions' ? 'active' : 'inactive',
'url' => $qId != null ? route('quizzes.questions', ['quiz' => $qId]) : ''
],
[
'step' => 4,
'key' => 'schedules',
'title' => __('Schedules'),
'status' => $active == 'schedules' ? 'active' : 'inactive',
'url' => $qId != null ? route('quizzes.schedules.index', ['quiz' => $qId]) : ''
]
];
}
/**
* Quiz Overall Stats Query
*
* @param $quizId
* @param $scheduleId
* @return \Illuminate\Support\Collection
*/
public function getQuizSessionStats($quizId, $scheduleId)
{
$key = $scheduleId ? 'quiz_schedule_id' : 'quiz_id';
$value = $scheduleId ? $scheduleId : $quizId;
return DB::table('quiz_sessions')
->where($key, '=', $value)
->selectRaw("count(case when status = 'completed' then 1 end) as total_attempts")
->selectRaw("count(case when JSON_EXTRACT(`results`, \"$.pass_or_fail\") = 'Passed' then 1 end) as pass_count")
->selectRaw("count(case when JSON_EXTRACT(`results`, \"$.pass_or_fail\") = 'Failed' then 1 end) as failed_count")
->selectRaw("count(DISTINCT(user_id)) as unique_test_takers")
->selectRaw("avg(total_time_taken) as avg_time")
->selectRaw("avg(JSON_EXTRACT(`results`, \"$.score\")) as avg_score")
->selectRaw("avg(JSON_EXTRACT(`results`, \"$.percentage\")) as avg_percentage")
->selectRaw("avg(JSON_EXTRACT(`results`, \"$.accuracy\")) as avg_accuracy")
->selectRaw("avg(JSON_EXTRACT(`results`, \"$.speed\")) as avg_speed")
->selectRaw("max(CAST(JSON_EXTRACT(`results`, \"$.score\") AS DECIMAL(10,6))) as high_score")
->selectRaw("min(CAST(JSON_EXTRACT(`results`, \"$.score\") AS DECIMAL(10,6))) as low_score")
->selectRaw("sum(JSON_EXTRACT(`results`, \"$.answered_questions\")) as sum_answered")
->selectRaw("sum(JSON_EXTRACT(`results`, \"$.total_questions\")) as sum_questions")
->get();
}
}