moe-lk / bulk-upload

app/Http/Controllers/BulkPromotion.php

<?php

namespace App\Http\Controllers;

use Webpatser\Uuid\Uuid;
use App\Models\Institution;
use App\Models\Academic_period;
use App\Models\Education_grade;
use App\Models\Institution_class;
use Illuminate\Support\Facades\DB;
use App\Models\Institution_student;
use App\Models\Institution_subject;
use Illuminate\Support\Facades\Log;
use App\Models\Institution_class_student;
use App\Models\Institution_class_subject;
use App\Models\Institution_subject_student;
use App\Models\Institution_student_admission;

class BulkPromotion extends Controller
{
    public function __construct()
    {
        $this->instituion_grade = new \App\Models\Institution_grade();

The property instituion_grade does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->education_grades = new Education_grade();

The property education_grades does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->academic_period = new Academic_period();

The property academic_period does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->institution_students = new Institution_student();

The property institution_students does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->institutions = new Institution();

The property institutions does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->institution_class_students = new Institution_class_student();

The property institution_class_students does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->institution_classes = new Institution_class();

The property institution_classes does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->institution_student_admission = new Institution_student_admission();

The property institution_student_admission does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

    }

    /**
     * Process Grade wise
     *
     * @param [type] $institutionGrade

The doc comment [type] at position 0 could not be parsed: Unknown type name '[' at position 0 in [type].

     * @param [type] $year
     * @return void
     */
    public function callback($institutionGrade, $params)
    {
        array_walk($institutionGrade, array($this, 'processGrades'), $params);
    }

    /**
     * Process Cloning process based on institution grade
     *
     * @param [type] $institutionGrade

The doc comment [type] at position 0 could not be parsed: Unknown type name '[' at position 0 in [type].

     * @param [type] $count
     * @param [type] $year
     * @return void
     */
    public function processGrades($institutionGrade, $count, $params)
    {
        try {
            DB::beginTransaction();
            if (!empty($institutionGrade) && $this->institutions->isActive($institutionGrade['institution_id'])) {
                $this->instituion_grade->updatePromoted($params['academicPeriod']->code, $institutionGrade['id']);
                $isAvailableforPromotion = false;
                $nextGrade = $this->education_grades->getNextGrade($institutionGrade['education_grade_id']);
                if (!empty($nextGrade)) {
                    $isAvailableforPromotion = $this->instituion_grade->getInstitutionGrade($institutionGrade['institution_id'], $nextGrade->id);
                }
                if (!empty($isAvailableforPromotion)) {
                    $this->process($institutionGrade, $nextGrade, $params);
                    DB::commit();
                } else {
                    DB::rollBack();
                }
                //leave school levers
                // else {
                //     $this->process($institutionGrade, $nextGrade, $params);
                // }
            }
        } catch (\Exception $e) {
            DB::rollBack();
        }
    }


    /**
     * Promote students of grate to next grade
     *
     * @param $institutionGrade
     * @param $nextGrade
     * @param $academicPeriod
     * @param $nextAcademicPeriod
     * @param array $parallelClasses
     * @param $status
     */
    public function promotion($institutionGrade, $nextGrade, $academicPeriod, $nextAcademicPeriod, $parallelClasses = [], $status)
    {
        $institution = Institution::where('id', $institutionGrade['institution_id'])->get()->first();
        $studentListToPromote = $this->institution_students->getStudentListToPromote($institutionGrade, $academicPeriod);

        $params = [
            $nextAcademicPeriod,
            $institutionGrade,
            $nextGrade,
            $status
        ];

        try {
            array_walk($studentListToPromote, array($this, 'promote'), $params);

            $output = new \Symfony\Component\Console\Output\ConsoleOutput();
            $output->writeln('##########################################################################################################################');
            $output->writeln('Promoting from ' . $institutionGrade['name'] . ' IN ' . $institution->name . ' No of Students: ' . count($studentListToPromote));

The property name does not seem to exist on App\Models\Institution. Are you sure there is no database migration missing?

            if (!empty($parallelClasses)) {
                $params = [
                    $nextAcademicPeriod,
                    $institutionGrade,
                    $nextGrade,
                    $parallelClasses,
                    $status
                ];
                array_walk($studentListToPromote, array($this, 'assingeToClasses'), $params);
                array_walk($parallelClasses, array($this, 'updateStudentCount'));
                DB::commit();
            }
        } catch (\Exception $e) {
            DB::rollBack();
            Log::error($e->getMessage());
        }
    }


    /**
     * update students count on class rooms
     *
     * @param [type] $class

The doc comment [type] at position 0 could not be parsed: Unknown type name '[' at position 0 in [type].

     * @return void
     */
    public function updateStudentCount($class)
    {
        $studentCounts = Institution_class_student::getStudentsCount($class['id']);
        unset($studentCounts['total']);
        Institution_class::query()->where('id', $class['id'])->update($studentCounts);
    }


    /**
     * Process institution grade in to the define promotion senarios
     *
     * @param $institutionGrade
     * @param $nextGrade
     * @param $year
     * @return int
     */
    public function process($institutionGrade, $nextGrade, $params)
    {
        $academicPeriod = $params['academicPeriod'];
        $previousAcademicPeriod = $params['previousAcademicPeriod'];
        $nextGradeObj = null;
        $currentGradeObj = $this->instituion_grade->getParallelClasses($institutionGrade['id'], $institutionGrade['institution_id'], $institutionGrade['education_grade_id'], $previousAcademicPeriod->id);
        if ($nextGrade !== []  && !is_null($nextGrade)) {
            $nextGradeObj = $this->instituion_grade->getParallelClasses($institutionGrade['id'], $institutionGrade['institution_id'], $nextGrade->id, $academicPeriod->id);
        }

        if (!is_null($nextGradeObj)) {
            if ($nextGradeObj->count() == 1) {
                // promote parallel classes
                $this->promotion($institutionGrade, $nextGrade, $previousAcademicPeriod, $academicPeriod, $nextGradeObj->toArray(), 1);
                return 1;
            } elseif (($nextGradeObj->count() > 1) && ($nextGradeObj->count() !==  $currentGradeObj->count())) {
                // promote pool promotion
                $this->promotion($institutionGrade, $nextGrade, $previousAcademicPeriod, $academicPeriod, [], 1);
                return 2;
            } elseif (($nextGradeObj->count() > 1) && $currentGradeObj->count() == $nextGradeObj->count()) {
                // Promote matching class name with previous class
                $this->promotion($institutionGrade, $nextGrade, $previousAcademicPeriod, $academicPeriod, $nextGradeObj->toArray(), 1);
                return 1;
            } else {
                // default pool promotion
                $this->promotion($institutionGrade, $nextGrade, $previousAcademicPeriod, $academicPeriod, [], 1);
                return 2;
            }
        } else {
            // default pool promotion
            $this->promotion($institutionGrade, $nextGrade, $previousAcademicPeriod, $academicPeriod, [], 3);
            return 2;
        }
    }


    /**
     * update promoted student's data in to the DB
     *
     * @param $student
     * @param $count
     * @param $params
     */
    public function promote($student, $count, $params)
    {

        $academicPeriod = $params[0];
        $nextGrade = $params[2];
        $status = $params[3];
        $studentData = [
            'student_status_id' => $status,
            'education_grade_id' => $nextGrade !== null ? $nextGrade->id : $student['education_grade_id'],
            'academic_period_id' => $academicPeriod->id,
            'start_date' => $academicPeriod->start_date,
            'start_year' => $academicPeriod->start_year,
            'end_date' => $academicPeriod->end_date,
            'end_year' =>   $academicPeriod->end_year,
            'institution_id' => $student['institution_id'],
            'admission_id' => $student['admission_id'],
            // 'student_id' => $student['id'],
            'created_user_id' => $student['created_user_id']
        ];

        try {
            Institution_student::where('id', (string)$student['id'])->update($studentData);
            $output = new \Symfony\Component\Console\Output\ConsoleOutput();
            $output->writeln('----------------- ' . $student['admission_id'] . ' to ' . $studentData['education_grade_id']);
        } catch (\Exception $e) {
            Log::error($e->getMessage());
        }
    }


    /**
     * get promoted new class of the students
     *
     * @param $student
     * @param $educationGrade
     * @param $nextGrade
     * @param $classes
     * @return false|int|string|null
     */
    public function getStudentClass($student, $educationGrade, $nextGrade, $classes)
    {
        $studentClass = $this->institution_class_students->getStudentNewClass($student);
        if (!is_null($studentClass)) {
            $class = array_search(str_replace($educationGrade['name'], $nextGrade->name, $studentClass->name), array_column($classes, 'name'));

The property name does not seem to exist on App\Models\Institution_class_student. Are you sure there is no database migration missing?

            if(!($class)){
                $nextGradeName = explode(" ",$nextGrade->name)[0];
                $educationGrade['name'] = explode(" ",$educationGrade['name'])[0];
                $class = array_search(str_replace($educationGrade['name'], $nextGradeName, $studentClass->name), array_column($classes, 'name'));
            }
            return $class;
        } else {
            return false;
        }
    }

    /**
     * Create class entry for promoted students
     *
     * @param $student
     * @param $count
     * @param $params
     */
    public function assingeToClasses($student, $count, $params)
    {
        $academicPeriod = $params[0];
        $educationGrade = $params[1];
        $nextGrade = $params[2];
        $classes = $params[3];
        $status = $params[4];
        $class = null;
        if (count($classes) == 1) {
            $class = $classes[0];
        } else {
            $class = $this->getStudentClass($student, $educationGrade, $nextGrade, $classes);
            if (is_numeric($class)) {
                $class = $classes[$class];
            }
        }

        if (!is_null($class)) {

            $studentObj = [
                'student_id' => $student['student_id'],
                'institution_class_id' =>  $class['id'],
                'education_grade_id' =>  $nextGrade->id,
                'academic_period_id' => $academicPeriod->id,
                'institution_id' => $student['institution_id'],
                'student_status_id' => $status,
                'created_user_id' => $student['created_user_id']
            ];
            // $allInsSubjects = Institution_class_subject::getAllSubjects($class);

            try {
                if (!$this->institution_class_students->isDuplicated($studentObj) && !is_null($class['id'])) {
                    $this->institution_class_students->create($studentObj);
                    // if (!empty($allInsSubjects)) {
                    //     $allSubjects = unique_multidim_array($allInsSubjects, 'institution_subject_id');
                    //     $this->student = $studentObj;
                    //     $allSubjects = array_map(array($this, 'setStudentSubjects'), $allSubjects);
                    //     $allSubjects = unique_multidim_array($allSubjects, 'education_subject_id');
                    //     array_walk($allSubjects, array($this, 'insertSubject'));
                    //     array_walk($allInsSubjects,array($this,'updateSubjectCount'));
                    // }
                    $output = new \Symfony\Component\Console\Output\ConsoleOutput();
                    $output->writeln('----------------- ' . $student['student_id'] . 'to ' . $class['name']);
                } else {
                    $this->institution_class_students->where('id', (string)$student['id'])->update($studentObj);
                    $output = new \Symfony\Component\Console\Output\ConsoleOutput();
                    $output->writeln('----------------- ' . $student['student_id'] . 'to ' . $class['name']);
                }
            } catch (\Exception $e) {
                
                Log::error($e->getMessage());
            }
        }
    }

    /**
     * Update subject count
     *
     * @param [type] $subject

The doc comment [type] at position 0 could not be parsed: Unknown type name '[' at position 0 in [type].

     * @return void
     */
    protected function updateSubjectCount($subject)
    {
        $totalStudents = Institution_subject_student::getStudentsCount($subject['institution_subject_id']);
        Institution_subject::where(['institution_subject_id' => $subject['institution_subject_id']])
            ->update([
                'total_male_students' => $totalStudents['total_male_students'],
                'total_female_students' => $totalStudents['total_female_students']
            ]);
    }


    /**
     * Set student subjects
     *
     * @param [type] $subject

The doc comment [type] at position 0 could not be parsed: Unknown type name '[' at position 0 in [type].

     * @return void
     */
    protected function setStudentSubjects($subject)
    {
        return [
            'id' => (string) Uuid::generate(4),
            'student_id' => $this->student['student_id'],

The property student does not exist on App\Http\Controllers\BulkPromotion. Did you mean institution_class_students?

            'institution_class_id' => $this->student['institution_class_id'],
            'institution_subject_id' => $subject['institution_subject_id'],
            'institution_id' => $this->student['institution_id'],
            'academic_period_id' => $this->student['academic_period_id'],
            'education_subject_id' => $subject['institution_subject']['education_subject_id'],
            'education_grade_id' => $this->student['education_grade_id'],
            'student_status_id' => 1,
            'created_user_id' => $this->student['created_user_id'],
            'created' => now()
        ];
    }

    /**
     * Insert subjects
     *
     * @param [type] $subject

The doc comment [type] at position 0 could not be parsed: Unknown type name '[' at position 0 in [type].

     * @return void
     */
    protected function insertSubject($subject)
    {
        if (!Institution_subject_student::isDuplicated($subject)) {
            Institution_subject_student::updateOrInsert($subject);
        }
    }
}