public function new_student()
{
$data['courses'] = Course::all();
$data['majors'] = DB::table('tbl_major')->get();
$data['religions'] = DB::table('tbl_religion')->get();
return view(Api::getView(), $data);
}
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 function index()
{
$data['system'] = $this->system;
$data['acam'] = Academicterm::findOrFail($this->system->phaseterm);
$data['rooms'] = Classroom::paginate(15);
return view(Api::getView(), $data);
}
public function index()
{
$common = $this->commonQuery();
$data['courses'] = $common['course'];
$data['majors'] = $common['majors'];
$data['religions'] = $common['religions'];
return view(Api::getView(), $data);
}
function manage_curriculum()
{
$c = DB::table('tbl_coursemajor')->get();
$acam = Academicterm::all();
$owner = Api::getCollege();
$cur = DB::select("SELECT a.id as cur_id, a.description as cur_description, a.academicterm as cur_academicterm,\n b.description as c_description\n FROM tbl_curriculum a, tbl_course b, tbl_coursemajor c\n WHERE a.coursemajor = c.id AND b.id = c.course AND b.college = {$owner}");
return view(Api::getView(), ['c' => $c, 'acam' => $acam, 'cur' => $cur]);
}
public function index()
{
$data['courses'] = Course::all();
$data['majors'] = DB::table('tbl_major')->get();
$data['religions'] = DB::table('tbl_religion')->get();
$data['shift'] = $data['update'] = 'yes it is';
return view(Api::getView(), $data);
}
function index()
{
$status = $this->system->classallocationstatus;
$data['system'] = $this->system;
if ($status == 99) {
if (Auth::user()->id != $this->system->employeeid) {
$data['college'] = DB::table('tbl_college')->where('id', $this->owner)->first();
}
$data['instruc'] = $this->instructors();
$otherAcademic = DB::table('tbl_academic')->where('college', '!=', '')->where('college', '!=', $this->owner)->select('id')->get();
$otherAdminist = DB::select("SELECT a.id as id FROM tbl_administration a,tbl_office b WHERE a.office = b.id AND b.college != ''");
$data['otherInst'] = array_merge($otherAcademic, $otherAdminist);
$data['acam'] = Academicterm::find(Session::get('phaseterm'));
$data['sy'] = Academicterm::orderBy('systart')->orderBy('term')->get();
$data['classes'] = Classallocation::getAlloc($this->owner, $this->system);
$data['val'] = 'valid';
} else {
$data['val'] = 'not valid status';
}
return view(Api::getView(), $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);
}
public function index()
{
$data['registrations'] = Registration::pending()->paginate(15);
return view(Api::getView(), $data);
}
public function index()
{
$data['subjects'] = Subjects::paginate(15);
return view(Api::getView(), $data);
}
