<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Storage;
use App\Traits\DateFormatTrait;
use App\Services\CachingService;
class LessonTopic extends Model
{
use HasFactory, DateFormatTrait;
protected $fillable = [
'name',
'description',
'lesson_id',
'school_id'
];
protected static function boot()
{
parent::boot();
static::deleting(static function ($topic) { // before delete() method call this
if ($topic->file) {
foreach ($topic->file as $file) {
if (Storage::disk('public')->exists($file->getRawOriginal('file_url'))) {
Storage::disk('public')->delete($file->getRawOriginal('file_url'));
}
if ($file->file_thumbnail && Storage::disk('public')->exists($file->getRawOriginal('file_thumbnail'))) {
Storage::disk('public')->delete($file->getRawOriginal('file_thumbnail'));
}
}
$topic->file()->delete();
}
});
}
public function scopeOwner($query)
{
if (Auth::user()) {
if (Auth::user()->hasRole('Super Admin')) {
return $query;
}
$sessionYearId = app(CachingService::class)->getSessionYear()->id;
if (Auth::user()->hasRole('School Admin')) {
return $query->where('school_id', Auth::user()->school_id)->whereHas('lesson.lesson_commons.syllabus.class_subject', function ($q) use ($sessionYearId) {
$q->where('session_year_id', $sessionYearId);
});
}
if (Auth::user()->hasRole('Teacher')) {
// $subject_teacher = SubjectTeacher::select(['class_section_id', 'class_subject_id'])->where(['teacher_id' => Auth::user()->id, 'school_id' => Auth::user()->school_id])->get();
// if ($subject_teacher) {
// $subject_teacher = $subject_teacher->toArray();
// $class_section_id = array_column($subject_teacher, 'class_section_id');
// $class_subject_id = array_column($subject_teacher, 'class_subject_id');
// $lesson_id = Lesson::select('id')->whereIn('class_section_id', $class_section_id)->whereIn('class_subject_id',$class_subject_id)->get()->pluck('id');
// return $query->whereIn('lesson_id', $lesson_id);
// }
$teacherId = Auth::user()->id;
return $query->whereHas('lesson.lesson_commons.syllabus.class_subject.subject_teacher', function ($query) use ($teacherId, $sessionYearId) {
$query->where(['teacher_id' => $teacherId, 'session_year_id' => $sessionYearId])
->whereColumn('class_section_id', 'class_section_id');
})->where('school_id', Auth::user()->school_id);
return $query->where('school_id', Auth::user()->school_id);
}
if (Auth::user()->hasRole('Student')) {
return $query->where('school_id', Auth::user()->school_id)->whereHas('lesson.lesson_commons.syllabus.class_subject', function ($q) use ($sessionYearId) {
$q->where('session_year_id', $sessionYearId);
});
}
}
return $query;
}
public function file()
{
return $this->morphMany(File::class, 'modal');
}
// public function topic_commons() {
// return $this->hasMany(TopicCommon::class, 'lesson_topics_id');
// }
public function lesson()
{
return $this->belongsTo(Lesson::class);
}
public function subject_teacher()
{
return $this->hasMany(SubjectTeacher::class, 'class_subject_id', 'class_subject_id');
}
public function lesson_topics()
{
return $this->hasMany(LessonTopic::class, 'lesson_id', 'lesson_id');
}
public function class_section()
{
return $this->belongsTo(ClassSection::class, 'class_section_id', 'id');
}
public function class_subject()
{
return $this->belongsTo(ClassSubject::class, 'class_subject_id', 'id');
}
// public function scopeLessonTopicTeachers($query)
// {
// $user = Auth::user();
// if ($user->hasRole('Teacher')) {
// // $teacher_id = $user->teacher()->select('id')->pluck('id')->first();
// // $subject_teacher = SubjectTeacher::select('class_section_id', 'subject_id')->where('teacher_id', $teacher_id)->get();
// $subject_teacher = SubjectTeacher::select('class_section_id', 'subject_id')->where('teacher_id', $user->id)->get();
// if ($subject_teacher) {
// $subject_teacher = $subject_teacher->toArray();
// $class_section_id = array_column($subject_teacher, 'class_section_id');
// $subject_id = array_column($subject_teacher, 'subject_id');
// $lesson_id = Lesson::select('id')->whereIn('class_section_id', $class_section_id)->whereIn('subject_id', $subject_id)->get()->pluck('id');
// return $query->whereIn('lesson_id', $lesson_id);
// }
// return $query;
// }
// return $query;
// }
public function getCreatedAtAttribute()
{
return $this->formatDateValue($this->getRawOriginal('created_at'));
}
public function getUpdatedAtAttribute()
{
return $this->formatDateValue($this->getRawOriginal('updated_at'));
}
/**
* Get all of the lesson_topic_class for the LessonTopic
*
* @return \Illuminate\Database\Eloquent\Relations\HasMany
*/
public function lesson_topic_class()
{
return $this->hasMany(LessonTopicClass::class, 'lesson_topic_id', 'id');
}
}