@@ -30,13 +30,13 @@ |
||
| 30 | 30 | */ |
| 31 | 31 | public function handle() |
| 32 | 32 | { |
| 33 | - try{ |
|
| 33 | + try { |
|
| 34 | 34 | ini_set('memory_limit', '-1'); |
| 35 | 35 | (new ExaminationStudentsExport)->queue('/examination/student_data_with_nsid.csv')->chain([ |
| 36 | 36 | (new ExportReady($this->user)) |
| 37 | 37 | ]); |
| 38 | 38 | |
| 39 | - }catch(\Exception $e){ |
|
| 39 | + }catch (\Exception $e) { |
|
| 40 | 40 | $output = new \Symfony\Component\Console\Output\ConsoleOutput(); |
| 41 | 41 | $output->writeln($e->getMessage()); |
| 42 | 42 | } |
@@ -22,17 +22,17 @@ discard block |
||
| 22 | 22 | |
| 23 | 23 | $institution = Institution_class::find($file['institution_class_id']); |
| 24 | 24 | $this->user = User::find($file['security_user_id']); |
| 25 | - $this->subject = 'SIS Bulk Upload: Process Terminated'.$institution->institution->code.': '. $institution->name.' '. date('Y:m:d H:i:s'); |
|
| 25 | + $this->subject = 'SIS Bulk Upload: Process Terminated'.$institution->institution->code.': '.$institution->name.' '.date('Y:m:d H:i:s'); |
|
| 26 | 26 | $this->from_address = env('MAIL_FROM_ADDRESS'); |
| 27 | 27 | $this->from_name = 'SIS Bulk Uploader'; |
| 28 | 28 | $this->with = [ |
| 29 | 29 | 'name' => $this->user->first_name, |
| 30 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 30 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 31 | 31 | ]; |
| 32 | 32 | $this->viewData = [ |
| 33 | 33 | 'name'=>$this->user->first_name, "body" => "Apologize ,The process of you file has been terminated in the middle, |
| 34 | 34 | We advice you to check the student data and re-upload with only with correct data which are not in the system ", |
| 35 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 35 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 36 | 36 | ]; |
| 37 | 37 | } |
| 38 | 38 | |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | public function build() |
| 45 | 45 | { |
| 46 | 46 | return $this->view('emails.mail') |
| 47 | - ->from($this->from_address,$this->from_name) |
|
| 47 | + ->from($this->from_address, $this->from_name) |
|
| 48 | 48 | ->to($this->user->email) |
| 49 | 49 | ->subject($this->subject) |
| 50 | 50 | ->with($this->with); |
@@ -19,17 +19,17 @@ discard block |
||
| 19 | 19 | public function __construct($user) |
| 20 | 20 | { |
| 21 | 21 | $this->user = $user; |
| 22 | - $this->subject = 'The DoE data is ready to download '. date('Y:m:d H:i:s'); |
|
| 22 | + $this->subject = 'The DoE data is ready to download '.date('Y:m:d H:i:s'); |
|
| 23 | 23 | $this->from_address = env('MAIL_FROM_ADDRESS'); |
| 24 | 24 | $this->from_name = 'SIS Bulk Uploader'; |
| 25 | 25 | $this->with = [ |
| 26 | 26 | 'name' => $this->user->first_name, |
| 27 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/downloadExportexamination' : env('APP_URL').'/bulk-upload/downloadExportexamination' |
|
| 27 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/downloadExportexamination' : env('APP_URL').'/bulk-upload/downloadExportexamination' |
|
| 28 | 28 | ]; |
| 29 | 29 | |
| 30 | 30 | $this->viewData = [ |
| 31 | 31 | 'name'=>$this->user->first_name, "body" =>'Your requested file is ready to download', |
| 32 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/downloadExportexamination' : env('APP_URL').'/bulk-upload/downloadExportexamination' |
|
| 32 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/downloadExportexamination' : env('APP_URL').'/bulk-upload/downloadExportexamination' |
|
| 33 | 33 | ]; |
| 34 | 34 | } |
| 35 | 35 | |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | public function build() |
| 42 | 42 | { |
| 43 | 43 | return $this->view('emails.mail') |
| 44 | - ->from($this->from_address,$this->from_name) |
|
| 44 | + ->from($this->from_address, $this->from_name) |
|
| 45 | 45 | ->to($this->user->email) |
| 46 | 46 | ->subject($this->subject) |
| 47 | 47 | ->with($this->with); |
@@ -31,16 +31,16 @@ discard block |
||
| 31 | 31 | $institution = Institution_class::find($file['institution_class_id']); |
| 32 | 32 | |
| 33 | 33 | $this->user = User::find($file['security_user_id']); |
| 34 | - $this->subject = 'SIS Bulk Upload: Upload Failed '.$institution->institution->code.': '. $institution->name . date('Y:m:d H:i:s'); |
|
| 34 | + $this->subject = 'SIS Bulk Upload: Upload Failed '.$institution->institution->code.': '.$institution->name.date('Y:m:d H:i:s'); |
|
| 35 | 35 | $this->from_address = env('MAIL_FROM_ADDRESS'); |
| 36 | 36 | $this->from_name = 'SIS Bulk Uploader'; |
| 37 | 37 | $this->with = [ |
| 38 | 38 | 'name' => $this->user->first_name, |
| 39 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 39 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 40 | 40 | ]; |
| 41 | 41 | $this->viewData = [ |
| 42 | 42 | 'name'=>$this->user->first_name, "body" => "The class you tried to import data is exceeded the student count limit.Please check the class / increase the student limit", |
| 43 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 43 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 44 | 44 | ]; |
| 45 | 45 | } |
| 46 | 46 | |
@@ -52,7 +52,7 @@ discard block |
||
| 52 | 52 | public function build() |
| 53 | 53 | { |
| 54 | 54 | return $this->view('emails.mail') |
| 55 | - ->from($this->from_address,$this->from_name) |
|
| 55 | + ->from($this->from_address, $this->from_name) |
|
| 56 | 56 | ->to($this->user->email) |
| 57 | 57 | ->subject($this->subject) |
| 58 | 58 | ->with($this->with); |
@@ -24,17 +24,17 @@ discard block |
||
| 24 | 24 | |
| 25 | 25 | |
| 26 | 26 | $this->user = User::find($file['security_user_id']); |
| 27 | - $this->subject = 'SIS Bulk Upload: ' .$file['subject']. $institution->institution->code.': '. $institution->name.' '. date('Y:m:d H:i:s'); |
|
| 27 | + $this->subject = 'SIS Bulk Upload: '.$file['subject'].$institution->institution->code.': '.$institution->name.' '.date('Y:m:d H:i:s'); |
|
| 28 | 28 | $this->from_address = env('MAIL_FROM_ADDRESS'); |
| 29 | 29 | $this->from_name = 'SIS Bulk Uploader'; |
| 30 | 30 | $this->with = [ |
| 31 | 31 | 'name' => $this->user->first_name, |
| 32 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 32 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 33 | 33 | ]; |
| 34 | 34 | $this->viewData = [ |
| 35 | - 'name'=>$this->user->first_name, "body" => "We found some errors on your data file ". $file['filename']. ' Pleas fix the errors and re-upload only with incorrect data, |
|
| 35 | + 'name'=>$this->user->first_name, "body" => "We found some errors on your data file ".$file['filename'].' Pleas fix the errors and re-upload only with incorrect data, |
|
| 36 | 36 | We uploaded the correct data to the system', |
| 37 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 37 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 38 | 38 | ]; |
| 39 | 39 | } |
| 40 | 40 | |
@@ -46,7 +46,7 @@ discard block |
||
| 46 | 46 | public function build() |
| 47 | 47 | { |
| 48 | 48 | return $this->view('emails.mail') |
| 49 | - ->from($this->from_address,$this->from_name) |
|
| 49 | + ->from($this->from_address, $this->from_name) |
|
| 50 | 50 | ->to($this->user->email) |
| 51 | 51 | ->subject($this->subject) |
| 52 | 52 | ->with($this->with); |
@@ -23,16 +23,16 @@ discard block |
||
| 23 | 23 | |
| 24 | 24 | |
| 25 | 25 | $this->user = User::find($file['security_user_id']); |
| 26 | - $this->subject = 'SIS Bulk Upload: IncorrectTemplate'.$institution->institution->code.': '. $institution->name.' '. date('Y:m:d H:i:s'); |
|
| 26 | + $this->subject = 'SIS Bulk Upload: IncorrectTemplate'.$institution->institution->code.': '.$institution->name.' '.date('Y:m:d H:i:s'); |
|
| 27 | 27 | $this->from_address = env('MAIL_FROM_ADDRESS'); |
| 28 | 28 | $this->from_name = 'SIS Bulk Uploader'; |
| 29 | 29 | $this->with = [ |
| 30 | 30 | 'name' => $this->user->first_name, |
| 31 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 31 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 32 | 32 | ]; |
| 33 | 33 | $this->viewData = [ |
| 34 | 34 | 'name'=>$this->user->first_name, "body" => "The Template you used for upload having some issues, please reconfirm and re-upload with correct template", |
| 35 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/' .$file['filename'] : env('APP_URL').'/bulk-upload/download/' .$file['filename'] |
|
| 35 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL').'/download/'.$file['filename'] : env('APP_URL').'/bulk-upload/download/'.$file['filename'] |
|
| 36 | 36 | ]; |
| 37 | 37 | } |
| 38 | 38 | |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | public function build() |
| 45 | 45 | { |
| 46 | 46 | return $this->view('emails.mail') |
| 47 | - ->from($this->from_address,$this->from_name) |
|
| 47 | + ->from($this->from_address, $this->from_name) |
|
| 48 | 48 | ->to($this->user->email) |
| 49 | 49 | ->subject($this->subject) |
| 50 | 50 | ->with($this->with); |
@@ -25,16 +25,16 @@ discard block |
||
| 25 | 25 | |
| 26 | 26 | |
| 27 | 27 | $this->user = User::find($file['security_user_id']); |
| 28 | - $this->subject = 'SIS Bulk Upload: ' .$file['subject'].' Empty ' . $institution->institution->code.': '. $institution->name.' '. date('Y:m:d H:i:s'); |
|
| 28 | + $this->subject = 'SIS Bulk Upload: '.$file['subject'].' Empty '.$institution->institution->code.': '.$institution->name.' '.date('Y:m:d H:i:s'); |
|
| 29 | 29 | $this->from_address = env('MAIL_FROM_ADDRESS'); |
| 30 | 30 | $this->from_name = 'SIS Bulk Uploader'; |
| 31 | 31 | $this->with = [ |
| 32 | 32 | 'name' => $this->user->first_name, |
| 33 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL') : env('APP_URL').'/bulk-upload/' |
|
| 33 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL') : env('APP_URL').'/bulk-upload/' |
|
| 34 | 34 | ]; |
| 35 | 35 | $this->viewData = [ |
| 36 | - 'name'=>$this->user->first_name, "body" => "No data Found in ". $file['filename']. ' Please re-upload the file with data', |
|
| 37 | - 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL') : env('APP_URL').'/bulk-upload/' |
|
| 36 | + 'name'=>$this->user->first_name, "body" => "No data Found in ".$file['filename'].' Please re-upload the file with data', |
|
| 37 | + 'link' => \App::environment('local') || \App::environment('stage') ? env('APP_URL') : env('APP_URL').'/bulk-upload/' |
|
| 38 | 38 | ]; |
| 39 | 39 | } |
| 40 | 40 | |
@@ -46,7 +46,7 @@ discard block |
||
| 46 | 46 | public function build() |
| 47 | 47 | { |
| 48 | 48 | return $this->view('emails.mail') |
| 49 | - ->from($this->from_address,$this->from_name) |
|
| 49 | + ->from($this->from_address, $this->from_name) |
|
| 50 | 50 | ->to($this->user->email) |
| 51 | 51 | ->subject($this->subject) |
| 52 | 52 | ->with($this->with); |
@@ -71,11 +71,11 @@ discard block |
||
| 71 | 71 | { |
| 72 | 72 | if (!is_null($id)) { |
| 73 | 73 | return self::find($id) |
| 74 | - ->select('institution_grades.id as insGrade','institution_classes.id', 'institution_classes.name', 'institution_grades.education_grade_id') |
|
| 75 | - ->join('institution_classes', function ($join) use ($educationGradeId, $academicPeriodId) { |
|
| 74 | + ->select('institution_grades.id as insGrade', 'institution_classes.id', 'institution_classes.name', 'institution_grades.education_grade_id') |
|
| 75 | + ->join('institution_classes', function($join) use ($educationGradeId, $academicPeriodId) { |
|
| 76 | 76 | $join->on('institution_classes.institution_id', '=', 'institution_grades.institution_id') |
| 77 | 77 | ->where('institution_classes.academic_period_id', $academicPeriodId) |
| 78 | - ->join('institution_class_grades', function ($join) use ($educationGradeId) { |
|
| 78 | + ->join('institution_class_grades', function($join) use ($educationGradeId) { |
|
| 79 | 79 | $join->on('institution_class_grades.institution_class_id', '=', 'institution_classes.id') |
| 80 | 80 | ->where('institution_class_grades.education_grade_id', $educationGradeId); |
| 81 | 81 | }); |
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | ->where('institution_grades.education_grade_id', $educationGradeId) |
| 84 | 84 | ->where('institution_grades.institution_id', $institutionId) |
| 85 | 85 | ->get(); |
| 86 | - }else{ |
|
| 86 | + }else { |
|
| 87 | 87 | return null; |
| 88 | 88 | } |
| 89 | 89 | } |
@@ -95,8 +95,8 @@ discard block |
||
| 95 | 95 | * @param $year |
| 96 | 96 | * @param $id |
| 97 | 97 | */ |
| 98 | - public function updatePromoted($year, $id){ |
|
| 99 | - self::where('id',$id)->update(['promoted'=>$year]); |
|
| 98 | + public function updatePromoted($year, $id) { |
|
| 99 | + self::where('id', $id)->update(['promoted'=>$year]); |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | /** |
@@ -106,9 +106,9 @@ discard block |
||
| 106 | 106 | * @param $gradeId |
| 107 | 107 | * @return mixed |
| 108 | 108 | */ |
| 109 | - public function getInstitutionGrade($institutionId, $gradeId){ |
|
| 110 | - return self::where('education_grade_id',$gradeId) |
|
| 111 | - ->where('institution_id',$institutionId)->get()->first(); |
|
| 109 | + public function getInstitutionGrade($institutionId, $gradeId) { |
|
| 110 | + return self::where('education_grade_id', $gradeId) |
|
| 111 | + ->where('institution_id', $institutionId)->get()->first(); |
|
| 112 | 112 | } |
| 113 | 113 | |
| 114 | 114 | /** |
@@ -116,14 +116,14 @@ discard block |
||
| 116 | 116 | * @param null $institution |
| 117 | 117 | * @return mixed |
| 118 | 118 | */ |
| 119 | - public function getInstitutionGradeToPromoted($year, $institution = null){ |
|
| 119 | + public function getInstitutionGradeToPromoted($year, $institution = null) { |
|
| 120 | 120 | return self::query() |
| 121 | - ->select('education_grades.name','institutions.code','institutions.name as institution_name','institution_grades.id','institution_grades.institution_id','institution_grades.education_grade_id') |
|
| 122 | - ->where('promoted','=',$year-1) |
|
| 123 | - ->join('education_grades','institution_grades.education_grade_id','=','education_grades.id') |
|
| 124 | - ->join('institutions', function($join) use ($year,$institution){ |
|
| 125 | - $join->on('institutions.id','=','institution_grades.institution_id') |
|
| 126 | - ->where('institutions.code','=',$institution); |
|
| 121 | + ->select('education_grades.name', 'institutions.code', 'institutions.name as institution_name', 'institution_grades.id', 'institution_grades.institution_id', 'institution_grades.education_grade_id') |
|
| 122 | + ->where('promoted', '=', $year - 1) |
|
| 123 | + ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id') |
|
| 124 | + ->join('institutions', function($join) use ($year, $institution){ |
|
| 125 | + $join->on('institutions.id', '=', 'institution_grades.institution_id') |
|
| 126 | + ->where('institutions.code', '=', $institution); |
|
| 127 | 127 | }) |
| 128 | 128 | ->orderBy('institution_id') |
| 129 | 129 | ->get()->toArray(); |
@@ -133,13 +133,13 @@ discard block |
||
| 133 | 133 | * @param $year |
| 134 | 134 | * @return mixed |
| 135 | 135 | */ |
| 136 | - public function getInstitutionGradeList($year){ |
|
| 136 | + public function getInstitutionGradeList($year) { |
|
| 137 | 137 | return self::query() |
| 138 | - ->select('education_grades.name','institutions.code','institutions.name as institution_name','institution_grades.id','institution_grades.institution_id','institution_grades.education_grade_id') |
|
| 139 | - ->where('promoted','=',$year-1) |
|
| 140 | - ->join('education_grades','institution_grades.education_grade_id','=','education_grades.id') |
|
| 138 | + ->select('education_grades.name', 'institutions.code', 'institutions.name as institution_name', 'institution_grades.id', 'institution_grades.institution_id', 'institution_grades.education_grade_id') |
|
| 139 | + ->where('promoted', '=', $year - 1) |
|
| 140 | + ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id') |
|
| 141 | 141 | ->join('institutions', function($join) use ($year){ |
| 142 | - $join->on('institutions.id','=','institution_grades.institution_id'); |
|
| 142 | + $join->on('institutions.id', '=', 'institution_grades.institution_id'); |
|
| 143 | 143 | }) |
| 144 | 144 | ->orderBy('institution_id') |
| 145 | 145 | ->get() |
@@ -4,7 +4,7 @@ discard block |
||
| 4 | 4 | |
| 5 | 5 | use Illuminate\Database\Eloquent\Model; |
| 6 | 6 | |
| 7 | -class Institution_shift extends Base_Model { |
|
| 7 | +class Institution_shift extends Base_Model { |
|
| 8 | 8 | |
| 9 | 9 | /** |
| 10 | 10 | * The database table used by the model. |
@@ -41,29 +41,29 @@ discard block |
||
| 41 | 41 | */ |
| 42 | 42 | protected $dates = ['modified', 'created']; |
| 43 | 43 | |
| 44 | - public function shiftExists($shift){ |
|
| 44 | + public function shiftExists($shift) { |
|
| 45 | 45 | return self::query() |
| 46 | - ->where('institution_id',$shift['institution_id']) |
|
| 47 | - ->where('location_institution_id',$shift['location_institution_id']) |
|
| 48 | - ->where('shift_option_id',$shift['shift_option_id']) |
|
| 49 | - ->where('academic_period_id',$shift['academic_period_id'])->exists(); |
|
| 46 | + ->where('institution_id', $shift['institution_id']) |
|
| 47 | + ->where('location_institution_id', $shift['location_institution_id']) |
|
| 48 | + ->where('shift_option_id', $shift['shift_option_id']) |
|
| 49 | + ->where('academic_period_id', $shift['academic_period_id'])->exists(); |
|
| 50 | 50 | } |
| 51 | 51 | |
| 52 | - public function getShiftsToClone(int $year){ |
|
| 52 | + public function getShiftsToClone(int $year) { |
|
| 53 | 53 | return self::query() |
| 54 | 54 | ->select('institution_shifts.*') |
| 55 | - ->join('academic_periods','academic_periods.id','=','institution_shifts.academic_period_id') |
|
| 55 | + ->join('academic_periods', 'academic_periods.id', '=', 'institution_shifts.academic_period_id') |
|
| 56 | 56 | // ->where('academic_periods.code',$year) |
| 57 | - ->where('institution_shifts.cloned',$year) |
|
| 57 | + ->where('institution_shifts.cloned', $year) |
|
| 58 | 58 | ->get()->toArray(); |
| 59 | 59 | } |
| 60 | 60 | |
| 61 | - public function getShiftsTodelete(int $year,$academic_period_id){ |
|
| 61 | + public function getShiftsTodelete(int $year, $academic_period_id) { |
|
| 62 | 62 | return self::query() |
| 63 | 63 | ->select('institution_shifts.*') |
| 64 | - ->join('academic_periods','academic_periods.id','=','institution_shifts.academic_period_id') |
|
| 65 | - ->where('academic_period_id',$academic_period_id) |
|
| 66 | - ->where('institution_shifts.cloned',$year) |
|
| 64 | + ->join('academic_periods', 'academic_periods.id', '=', 'institution_shifts.academic_period_id') |
|
| 65 | + ->where('academic_period_id', $academic_period_id) |
|
| 66 | + ->where('institution_shifts.cloned', $year) |
|
| 67 | 67 | ->get()->toArray(); |
| 68 | 68 | } |
| 69 | 69 | } |