function check_for_entries($student_no)
{
$entries = Students::all();
$counter = 0;
foreach ($entries as $entry) {
if ($entry->student_id == $student_no) {
$counter++;
}
}
return $counter;
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$input = Request::all();
// $student = new Students;
// $student->school_id = $input['school_id'];
// $student->lastname = $input['lastname'];
// $student->firstname = $input['firstname'];
// $student->middlename = $input['middlename'];
// $student->password = $input['password'];
// $student->save();
//dd($input);
Students::create($input);
$user = new User();
$user->school_id = $input['school_id'];
$user->password = $input['password'];
$user->status = "0";
$user->save();
return $input;
}
public function instituteReport($Iid)
{
/****Admin****/
$today = date('Y-m-d');
$y = date("Y");
//return $today;
$totalStudents = Students::where('status', '=', 1)->where('institute_code', '=', $Iid)->count();
$totalStudentsMale = Students::where('status', '=', 1)->where('institute_code', '=', $Iid)->where('gender', '=', 'Male')->count();
$totalStudentsFemale = Students::where('status', '=', 1)->where('institute_code', '=', $Iid)->where('gender', '=', 'Female')->count();
$totalTeachesrs = Teacher::where('institute_code', '=', $Iid)->count();
$teacherAttendence = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Teacher')->where('status', '=', 0)->where('created_at', 'LIKE', "%{$today}%")->count();
$teacherAttendence1 = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Teacher')->where('status', '=', 1)->where('created_at', 'LIKE', "%{$today}%")->count();
$total = $teacherAttendence + $teacherAttendence1;
//return $total;
$today_atten = (int) ($total / $totalTeachesrs * 100);
//return $today_atten;
$a1 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$y}%")->where('type', '=', 'Teacher')->where('status', '=', 1)->count();
$a0 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$y}%")->where('type', '=', 'Teacher')->where('status', '=', 0)->count();
$ay = $a1 + $a0;
//return $ay;
if ($y % 4 == 0) {
$x = 366;
$year_percent = (int) ($ay / $x * 100);
} else {
$yx = 365;
$year_percent = (int) ($ay / $yx * 100);
}
//return $atten_percent;
// return $AtotalInstitute;
$totalTeacherMale = Teacher::where('institute_code', '=', $Iid)->where('gender', '=', 'Male')->count();
$totalTeacherFemale = Teacher::where('institute_code', '=', $Iid)->where('gender', '=', 'Female')->count();
$m = date("Y-m");
///$h=Holyday::where('holiday_date','LIKE',"%2016-03%")->get();
//$h=Holyday::where('holiday_date','LIKE',"%$m%")->get();
$d = date('t');
$at = Holyday::where('holiday_date', 'LIKE', "%{$m}%")->count();
$p = $d - $at;
//return $p;
$a12 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$m}%")->where('type', '=', 'Teacher')->where('status', '=', 1)->count();
$a02 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$m}%")->where('type', '=', 'Teacher')->where('status', '=', 0)->count();
$ay2 = $a12 + $a02;
//return $a12.$a02;
$t = $totalTeachesrs * $p;
$ms = (int) ($ay2 / $t * 100);
$at = Holyday::where('holiday_date', 'LIKE', "%{$m}%")->count();
$InstiHolyday = InstiHolyday::where('holiday_date', 'LIKE', "%{$m}%")->where('institute_code', '=', $Iid)->count();
$InstiWeekEnd = AcademicCalender::where('institute_code', '=', $Iid)->pluck('weekendday');
$WeekEnd1 = str_limit($InstiWeekEnd, 3, '');
$WeekEnd2 = substr($InstiWeekEnd, 4);
$WeekEnd3 = substr($InstiWeekEnd, 9);
// return date('d', strtotime($WeekEnd1));
$month = date('m');
$year = date("Y");
$start_date = "01-" . $month . "-" . $year;
$start_time = strtotime($start_date);
$end_time = strtotime("+1 month", $start_time);
for ($i = $start_time; $i < $end_time; $i += 86400) {
$list[] = date('D', $i);
}
$p = $d - ($at + $InstiHolyday);
$ms = (int) ($p / $d * 100);
//students attendence report saif...
//today attendence calculation
$totalStudents = Students::where('institute_code', '=', $Iid)->count();
$totalstudentsAtten = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Student')->where('status', '=', 0)->where('created_at', 'LIKE', "%{$today}%")->count();
$studentTodayReport = (int) ($totalstudentsAtten / $totalStudents * 100);
//monthly calculation
$stdPrestAve = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Student')->where('status', '=', 0)->where('created_at', 'LIKE', "%{$m}%")->count();
//$presentPersent= (int)(($stdPrestAve/$p)*100);
$mtotal = $totalStudents * $p;
$monthpresentPersent = (int) ($stdPrestAve / $mtotal * 100);
///yearly calculation
return view('superadmin.ListofInstituteReport')->with('totalStudents', $totalStudents)->with('totalTeachesrs', $totalTeachesrs)->with('totalStudentsMale', $totalStudentsMale)->with('totalStudentsFemale', $totalStudentsFemale)->with('today', $today_atten)->with('year', $year_percent)->with('m', $totalTeacherMale)->with('f', $totalTeacherFemale)->with('mon', $ms)->with('studentTodayReport', $studentTodayReport)->with('monthpresentPersent', $monthpresentPersent);
}
//Route::get('/movies', function () {
//$Movies = \App\Movie::where('title','=','shuga')->get();
//$Movies = \App\movie::where('rating','>'2)->get(); //select * from movies where rating > 2
//return $movies;
//$movie= new \App\Movie();
//$Movie->title='Akirachix';
//$movie->genre='awesome';
//$movie->rating=5;
//$movie->save();
// $movie= \App\Movie::find(5);
// $movie->genre='Horror';
// $movie->rating=4;
// $movie->save();
// return $movie;
//return \App\Movie::all();
Route::get('/students', function () {
//$Students = \App\Students::where('lastname','=','Maich')->get();
//return $Students;
$students = new \App\Students();
$students->id = '6';
$students->firstname = 'Cate';
$students->lastname = 'Mwai';
$students->save();
// $movie= \App\Movie::find(5);
// $movie->genre='Horror';
// $movie->rating=4;
// $movie->save();
// return $movie;
return \App\Students::all();
Route::get('/movies', 'studentsController@index');
});
public function getMarkViews()
{
// $stdInfo=Students::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class','=',$cid)->first();
$stdInfo = Students::where('institute_code', '=', Auth::user()->institute_id)->where('st_id', '=', Auth::user()->uid)->first();
$stdClass = ClassAdd::where('class_id', '=', $stdInfo->class)->pluck('class_name');
//return $stdInof->class;
$showAllMark = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->get();
$showAllMarkExamName = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->select('exam_name')->distinct()->get();
// $showAllMarkExamName=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->first();
//return $showAllMark->sub_mark;
$allGrad = GradeSystem::where('institute_code', '=', Auth::user()->institute_id)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->get();
return view('admin.resultMark.markviews')->with('stdInfo', $stdInfo)->with('stdClass', $stdClass)->with('showAllMark', $showAllMark)->with('MarkViewGrade', $MarkViewGrade)->with('allGrad', $allGrad)->with('showAllMarkExamName', $showAllMarkExamName);
}
public function getMarkViews($roll, $cid)
{
$stdInfo = Students::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class', '=', $cid)->first();
$stdClass = ClassAdd::where('class_id', '=', $stdInfo->class)->pluck('class_name');
$showAllMark = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->get();
$showAllMarkExamName = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->select('exam_name')->distinct()->get();
// $showAllMarkExamName=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->first();
//return $showAllMark->sub_mark;
$allGrad = GradeSystem::where('institute_code', '=', Auth::user()->institute_id)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->get();
/* foreach ($allGrad as $key => $value) {
//return $MarkViewGrade->sub_mark;
$MarkViewGrade=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get();
//return $MarkViewGrade;
foreach ($MarkViewGrade as $key => $markget) {
// return $value->mark_form;
if ($markget->sub_mark>=$value->mark_form && $markget->sub_mark<=$value->mark_upto) {
$point=$value->grade_point ;
$grade=$value->grade_name ;
return view('admin.resultMark.markviews')->with('stdInfo',$stdInfo)->with('stdClass',$stdClass)
->with('showAllMark',$showAllMark)->with('MarkViewGrade',$MarkViewGrade)->with('allGrad',$allGrad)->with('point',$point)->with('grade',$grade);
}
else {
return 2 ;
}
}
}*/
// return $point.$grade;
return view('admin.resultMark.markviews')->with('stdInfo', $stdInfo)->with('stdClass', $stdClass)->with('showAllMark', $showAllMark)->with('MarkViewGrade', $MarkViewGrade)->with('allGrad', $allGrad)->with('showAllMarkExamName', $showAllMarkExamName);
}
public function updateInvoice($id)
{
$class = Input::get('class');
$section = Input::get('section');
$student = Input::get('student');
$feetype = Input::get('feetype');
$amount = Input::get('amount');
$paidamountid = Input::get('paid');
$answer = Input::get('answer');
$date = Input::get('date');
//return $paidamountid;
$studentid = Students::where('institute_code', '=', Auth::user()->institute_id)->where('name', '=', $student)->where('class', '=', $class)->pluck('st_id');
return $studentid;
$classname = ClassAdd::where('institute_code', '=', Auth::user()->institute_id)->where('class_id', '=', $class)->pluck('class_name');
$feetypename = AccountFeeType::where('institute_code', '=', Auth::user()->institute_id)->where('fee_id', '=', $feetype)->pluck('fee_type');
$up = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('id', '=', $id)->update(['class_id' => $class, 'class_name' => $classname, 'section_id' => $section, 'student_name' => $student, 'student_id' => $studentid, 'fee_type' => $feetypename, 'fee_id' => $feetype, 'total_amount' => $amount, 'payment_ammount' => $paidamountid, 'due_amount' => $answer, 'date' => $date]);
Session::flash('data', 'Success!');
return redirect::to('admin/edit/invoice/' . $id);
}
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
public function create(array $data)
{
return Students::create(['school_id' => $data['school_id'], 'lastname' => $data['lastname'], 'firstname' => $data['firstname'], 'middlename' => $data['middlename'], 'password' => bcrypt($data['password'])]);
}
function daily_report()
{
$date = $_POST['reportDate'];
$branch = $_POST['branch'];
if ($branch == '0') {
$entries = Students::latest('entry_time')->where('entry_time', '=', $date)->get();
} else {
switch ($branch) {
case 1:
$branch = "CS";
break;
case 2:
$branch = "IT";
break;
case 3:
$branch = "EC";
break;
case 4:
$branch = "EN";
break;
case 5:
$branch = "EI";
break;
case 6:
$branch = "CE";
break;
case 7:
$branch = "ME";
break;
case 8:
$branch = "MCA";
break;
case 9:
$branch = "MBA";
break;
}
$entries = Students::latest('entry_time')->where('entry_time', '=', $date)->get();
}
return view('DailyReportGenerated', compact('entries', 'branch', 'date'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$students = Students::all();
$data = array('students' => $students);
return view('students.list', $data);
}
