FM / Repositories

/home/techb158/ileadtechnology.com/SSM/app/Repositories/

/home/techb158/ileadtechnology.com/SSM/app/Repositories

Name	Size	Mode	Actions
academic/	-	0755	rm
auth/	-	0755	rm
calendar/	-	0755	rm
communication/	-	0755	rm
configuration/	-	0755	rm
employee/	-	0755	rm
exam/	-	0755	rm
finance/	-	0755	rm
frontend/	-	0755	rm
institute/	-	0755	rm
inventory/	-	0755	rm
library/	-	0755	rm
post/	-	0755	rm
reception/	-	0755	rm
resource/	-	0755	rm
student/	-	0755	rm
transport/	-	0755	rm
upload/	-	0755	rm
utility/	-	0755	rm
.DS_Store	10244	0644	edit dl rm
HomeRepository.php	7864	0644	edit dl rm
TagRepository.php	1650	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/SSM/app/Repositories/HomeRepository.php (7864B)

<?php
namespace App\Repositories;

use Carbon\Carbon;
use App\Models\Post\Article;
use App\Models\Utility\Todo;
use App\Models\Academic\Batch;
use App\Models\Calendar\Event;
use App\Models\Academic\Course;
use App\Models\Library\BookLog;
use App\Models\Student\Student;
use App\Models\Calendar\Holiday;
use App\Models\Employee\Employee;
use App\Models\Library\BookLogDetail;
use App\Models\Library\BookPostDetail;
use Illuminate\Validation\ValidationException;

class HomeRepository
{
    protected $batch;
    protected $course;
    protected $student;
    protected $employee;
    protected $article;
    protected $holiday;
    protected $todo;
    protected $event;
    protected $book_post_detail;
    protected $book_log_detail;
    protected $book_log;

/**
     * Instantiate a new instance.
     *
     * @return void
     */
    public function __construct(
        Batch $batch,
        Course $course,
        Student $student,
        Employee $employee,
        Article $article,
        Holiday $holiday,
        Todo $todo,
        Event $event,
        BookPostDetail $book_post_detail,
        BookLogDetail $book_log_detail,
        BookLog $book_log
    ) {
        $this->batch = $batch;
        $this->course = $course;
        $this->student = $student;
        $this->employee = $employee;
        $this->article = $article;
        $this->holiday = $holiday;
        $this->todo = $todo;
        $this->event = $event;
        $this->book_post_detail = $book_post_detail;
        $this->book_log_detail = $book_log_detail;
        $this->book_log = $book_log;
    }

/**
     * Get dashboard data.
     *
     * @return Array
     */
    public function getData()
    {
        $student_birthday_count = $this->student->whereHas('studentRecords', function ($q) {
            $q->whereNull('date_of_exit')->filterBySession();
        })->whereRaw('DATE_FORMAT(date_of_birth, "%m-%d") = ?', [Carbon::now()->format('m-d')])->count();

$employee_birthday_count = $this->employee->whereHas('employeeTerms', function ($q) {
            $q->whereNull('date_of_leaving');
        })->whereRaw('DATE_FORMAT(date_of_birth, "%m-%d") = ?', [Carbon::now()->format('m-d')])->count();

$birthday_count = $student_birthday_count + $employee_birthday_count;

$anniversary_count = $this->employee->whereHas('employeeTerms', function ($q) {
            $q->whereNull('date_of_leaving');
        })->whereRaw('DATE_FORMAT(date_of_anniversary, "%m-%d") = ?', [Carbon::now()->format('m-d')])->count();

$work_anniversary_count = $this->employee->whereHas('employeeTerms', function ($q) {
            $q->whereNull('date_of_leaving')->whereRaw('DATE_FORMAT(date_of_joining, "%m-%d") = ?', [Carbon::now()->format('m-d')]);
        })->count();

$articles = \Auth::user()->can('list-article') ? $this->article->with('articleType')->filterBySession()->orderBy('date_of_article', 'desc')->take(5)->get() : [];

$events = array();
        if (\Auth::user()->can('list-event')) {
            $event_query =  $this->event->with('eventType')->filterBySession()->where('start_date','>=',date('Y-m-d'));

if (\Auth::user()->hasAnyRole([config('system.default_role.student'), config('system.default_role.parent')])) {
                $event_query->whereIn('audience',['everyone','selected_course','selected_batch']);
            }

$events = $event_query->orderBy('start_date', 'asc')->take(5)->get();
        }
        
        $books = array();
        $book_log_stats = array();
        $total_book_count = 0;
        $pending_return_book_count = 0;
        $overdue_return_book_count = 0;
        if (\Auth::user()->hasRole(config('system.default_role.librarian'))) {
            $total_book_count = $this->book_post_detail->count();
            $pending_return_book_count = $this->book_log_detail->whereNotNull('date_of_return')->orWhere('is_non_returnable',1)->count();
            $overdue_return_book_count = $this->book_log_detail->whereHas('bookLog', function($q) {
                $q->where('due_date','<',date('Y-m-d'));
            })->where(function($q1) {
                $q1->whereNotNull('date_of_return')->orWhere('is_non_returnable',1);
            })->count();
        }

return compact('birthday_count', 'anniversary_count', 'work_anniversary_count', 'articles','events','books','book_log_stats','total_book_count','pending_return_book_count','overdue_return_book_count');
    }

/**
     * Get dashboard chart data.
     *
     * @param Array $params
     * @return Array
     */
    public function getStudentStrengthChartData($params = array())
    {
        if (! \Auth::user()->hasAnyRole([
            config('system.default_role.admin'),
            config('system.default_role.manager'),
            config('system.default_role.principal'),
        ])) {
            return [];
        }

$strength_chart_type = gv($params, 'strength_chart_type', 'course');

$chart_data = array();
        $batches = $this->batch->with('course')->withCount(['studentRecords' => function ($q) {
            $q->whereNull('date_of_exit');
        }])->filterBySession()->get();

$total = 0;
        foreach ($batches as $batch) {
            $total += $batch->student_records_count;
            $chart_data[$batch->course->name.' '.$batch->name] = $batch->student_records_count;
        }

$batches = $chart_data;

if ($strength_chart_type == 'course') {
            $chart_data = array();
            $courses = $this->course->with('batches')->filterBySession()->get();

foreach ($courses as $course) {
                $strength = 0;
                foreach ($course->batches as $batch) {
                    $strength += gv($batches, $course->name.' '.$batch->name);
                }

$chart_data[$course->name] = $strength;
            }
        }

$strength = $this->getChartData($chart_data);

return compact('strength','total');
    }

public function getChartData($chart_data)
    {
        return [
            'labels' => array_keys($chart_data),
            'datasets' => [
                [
                    'label' => trans('student.strength'),
                    'backgroundColor' => '#f87979',
                    'data' => array_values($chart_data)
                ]
            ]
        ];
    }

/**
     * Get library book log chart data.
     *
     * @param Array $params
     * @return Array
     */
    public function getLibraryBookLogChartData($params = array())
    {
        if (! \Auth::user()->hasRole(config('system.default_role.librarian'))) {
            return [];
        }

$book_logs = $this->book_log->withCount([
            'bookLogDetails as book_issue_count','bookLogDetails as book_return_count' => function ($q) {
                $q->whereNotNull('date_of_return')->orWhere('is_non_returnable', 1);
            }
        ])->DateOfIssueBetween([
            'start_date' => config('config.default_academic_session.start_date'),
            'end_date' => config('config.default_academic_session.end_date')
        ])->get();

}

/**
     * Get dashboard event data.
     *
     * @param Array $params
     * @return Array
     */
    public function getCalendarEventData($params = array())
    {
        $holidays = $this->holiday->all();

$todos = $this->todo->filterByUserId(\Auth::user()->id)->whereStatus(0)->get();

$event_query = $this->event->filterBySession();

if (\Auth::user()->hasAnyRole([config('system.default_role.student'), config('system.default_role.parent')])) {
            $event_query->whereIn('audience',['everyone','selected_course','selected_batch']);
        }

$events = $event_query->get();

return compact('holidays','todos','events');
    }
}

cmd: