public function index()
{
$data['classes'] = Classallocation::where('academicterm', $this->system->currentacademicterm)->where('instructor', Auth::user()->id)->get();
$data['system'] = $this->system;
$data['acam'] = Academicterm::find($this->system->currentacademicterm);
return view(Api::getView(), $data);
}
public static function getInstructorsSched($id)
{
$sy = Session::get('phaseterm');
$classes = Classallocation::where('academicterm', $sy)->where('instructor', $id)->get();
$data = [];
foreach ($classes as $class) {
$d = self::where('classallocation', $class->id)->get();
foreach ($d as $dd) {
$data[] = $dd;
}
}
return $data;
}
public function getSchedRoom($room, $system)
{
$classes = Classallocation::where('academicterm', $system->phaseterm)->get();
foreach ($classes as $class) {
if ($this->ctr > count($this->color) - 1) {
$this->ctr = 0;
}
$dayperiods = Day_period::where('classallocation', $class->id)->where('classroom', $room)->get();
$this->getSched($dayperiods, $class);
$this->ctr++;
}
return $this->returnCollection();
}
public function show($id)
{
$inst = Party::find($id);
if ($inst instanceof ModelNotFoundException) {
return view('errors.404');
}
$data['instructor'] = $inst;
$data['classes'] = Classallocation::where('academicterm', $this->system->phaseterm)->where('instructor', $id);
$data['days'] = Day::where('id', '!=', 8)->get();
$data['times'] = Time::all();
$schedCollection = new SchedCollection();
$data['table_day'] = $schedCollection->getSchedInstructor($id, $this->system);
return view('instructor.sched', $data);
}
public function index()
{
$status = $this->system->classallocationstatus;
$data['system'] = $this->system;
if ($status == 4) {
$c = DB::table('tbl_completion')->where('academicterm', $this->system->phaseterm)->where('stage', 4)->where('status', 'O')->count();
if ($c == env('COLLEGE_COUNT')) {
$data['val'] = 'ok';
$data['class'] = Classallocation::where('academicterm', $this->system->phaseterm)->get();
} else {
$data['colleges'] = DB::table('tbl_college')->where('id', '!=', 6)->get();
$data['val'] = 'you cannot continue';
}
} elseif ($status == 3) {
$data['colleges'] = DB::table('tbl_college')->where('id', '!=', 6)->get();
$data['val'] = 'you cannot continue';
} else {
$data['colleges'] = DB::table('tbl_college')->where('id', '!=', 6)->get();
$data['val'] = 'not yet';
}
return view(Api::getView(), $data);
}
function init()
{
$data['val'] = '';
if ($this->system->phaseterm == env('FIN')) {
$stat = $this->system->classallocationstatus;
if ($stat == 2 or $stat == 1) {
$c = DB::table('tbl_completion')->where('stage', 2)->where('academicterm', $system->phaseterm)->where('status', 'O');
if ($c == env('COLLEGE_COUNT')) {
// update the systemvalues
DB::table('tbl_systemvalues')->update(['classallocationstatus' => 3]);
// delete classallocation for this phaseterm
Classallocation::where('academicterm', $system->phaseterm)->delete();
$sec = DB::table('out_section')->get();
foreach ($sec as $section) {
// if the section is zero it will not satisfy this condition
for ($i = 1; $i <= $section->section; $i++) {
$class = new Classallocation();
$class->academicterm = $section->academicterm;
$class->coursemajor = $section->coursemajor;
$class->subject = $section->subject;
$class->instructor = 0;
$class->reserved = 0;
$class->enrolled = 0;
$class->save();
}
}
$data['val'] = 'OK';
} else {
$data['val'] = 'college count';
}
} else {
$data['val'] = 'cannot run';
}
} else {
$data['val'] = 'cannot run in this phase';
}
return view('edp.initClass', $data);
}
