Security_user::createOrUpdateStudentProfile() - Code Metrics - moe-lk/bulk-upload - Measure and Improve Code Quality continuously with Scrutinizer

Security_user::createOrUpdateStudentProfile() D
last analyzed 2022-03-28 10:30 UTC

↳ Parent: Security_user

Complexity

Conditions	18
Paths	129

Size

Total Lines	61
Code Lines	52

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	18
eloc	52
c	0
b	0
f	0
nc	129
nop	3
dl	0
loc	61
rs	4.625

How to fix Long Method Complexity

<?php

namespace App\Models;

use App\Models\User_contact;
use Lsf\UniqueUid\UniqueUid;
use App\Models\Unique_user_id;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Security_user extends Model
{

    use SoftDeletes;

    public const CREATED_AT = 'created';
    public const UPDATED_AT = 'modified';
    /**
     * The database table used by the model.
     *
     * @var string
     */

    public $timestamps = true;

    protected $softDelete = true;

    protected $table = 'security_users';

    protected $appends = [
        'special_need_name'
    ];

    /**
     * Attributes that should be mass-assignable.
     *
     * @var array
     */
    protected $fillable = [
        'openemis_no',
        'first_name',
        'last_name',
        'address',
        'address_area_id',
        'birthplace_area_id',
        'gender_id',
        'remember_token',
        'date_of_birth',
        'nationality_id',
        'identity_type_id',
        'identity_number',
        'is_student',
        'modified_user_id',
        'modified',
        'created_user_id',
        'created',
        'username',
        'password',
    ];

    /**
     * The attributes excluded from the model's JSON form.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'modified_user_id',
        'middle_name',
        'third_name',
        'modified',
        'created_user_id',
        'created'

    ];


    public function getSpecialNeedNameAttribute()
    {
        return optional($this->special_needs())->special_need_difficulty_id;
    }

    /**
     * The attributes that should be casted to native types.
     *
     * @var array
     */
    protected $casts = [];

    public function institutionStudents()
    {
        return $this->hasOne(Institution_student::class, 'student_id');
    }

    public function institutionStudentsClass()
    {
        return $this->hasOne(Institution_student::class, 'student_id');
    }

    /**
     * The attributes that should be mutated to dates.
     *
     * @var array
     */
    protected $dates = ['date_of_birth', 'date_of_death', 'last_login', 'modified', 'created'];

    public function rules()
    {
        return [
            'identity_number' => [
                'required',
                'unique:security_users,identity_number',
            ]
        ];
    }

    public function getAuthPassword()
    {
        return $this->password;

    }

    public function uploads()
    {
        return $this->hasMany('App\Models\Upload');
    }

    public function class()
    {
        return $this->belongsTo('App\Models\Institution_class_student', 'id', 'student_id');
    }

    public function special_needs()
    {
        return $this->hasMany('App\Models\User_special_need', 'id', 'security_user_id');
    }

    public function genUUID()
    {
        $uuid = Uuid::generate(4);
filter:
    dependency_paths: ["lib/*"]
        return str_split($uuid, '8')[0];
    }

    /**
     * First level search for students
     *
     * @param array $student
     * @return array
     */
    public function getMatches($student)
    {
        return $this
            ->where('gender_id', $student['gender'] + 1)
            ->where('institutions.code', $student['schoolid'])
            ->where('date_of_birth', $student['b_date'])
            ->join('institution_students', 'security_users.id', 'institution_students.student_id')
            ->join('institutions', 'institution_students.institution_id', 'institutions.id')
            ->get()->toArray();
    }

    /**
     * First level search for students
     *
     * @param array $student
     * @return array
     */
    public function getStudentCount($student)
    {
        return $this

            ->where('gender_id', $student['gender'] + 1)
            ->where('institutions.code', $student['schoolid'])
            ->where('date_of_birth', $student['b_date'])
            ->join('institution_students', 'security_users.id', 'institution_students.student_id')
            ->join('institutions', 'institution_students.institution_id', 'institutions.id')
            ->count();
    }

    /**
     * insert student data from examination
     * @input array
     * @return array
     */
    public function insertExaminationStudent($student)
    {
        $this->uniqueUserId = new Unique_user_id();

        $this->uniqueUId = new UniqueUid();

        $uniqueId = $this->uniqueUId::getUniqueAlphanumeric();
        $studentData = [
            'username' => str_replace('-', '', $uniqueId),
            'openemis_no' => $uniqueId, // Openemis no is unique field, in case of the duplication it will failed
            'first_name' => $student['f_name'], // here we save full name in the column of first name. re reduce breaks of the system.
            'last_name' => genNameWithInitials($student['f_name']),
            'gender_id' => $student['gender'] + 1,
            'date_of_birth' => $student['b_date'],
            'address' => $student['pvt_address'],
            'is_student' => 1,
            'updated_from' => 'doe',
            'created' => now(),
            'created_user_id' => 1
        ];
        try {
            $id = $this->insertGetId($studentData);
            $studentData['id'] = $id;
            $this->uniqueUserId->updateOrInsertRecord($studentData);
            return $studentData;
        } catch (\Exception $th) {
            Log::error($th->getMessage());
            // in case of duplication of the Unique ID this will recursive till success.
            $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();

            $this->insertExaminationStudent($sis_student);
        }
        return $studentData;
    }

    /**
     * Update the existing student's data
     *
     * @param array $student
     * @param array $sis_student
     * @return array
     */
    public function updateExaminationStudent($student, $sis_student)
    {
        $this->uniqueUserId = new Unique_user_id();

        $this->uniqueUId = new UniqueUid();
        // regenerate unique id if it's not available
        $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ?  $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric();

        $studentData = [
            'username' => str_replace('-', '', $uniqueId),
            'openemis_no' => $uniqueId, // Openemis no is unique field, in case of the duplication it will failed
            'first_name' => $student['f_name'], // here we save full name in the column of first name. re reduce breaks of the system.
            'last_name' => genNameWithInitials($student['f_name']),
            'date_of_birth' => $student['b_date'],
            'address' => $student['pvt_address'],
            'updated_from' => 'doe',
            'modified' => now()
        ];

        try {
            self::where('id', $sis_student['student_id'])->update($studentData);
            $studentData['id'] = $sis_student['student_id'];
            $this->uniqueUserId->updateOrInsertRecord($studentData);
            return $studentData;
        } catch (\Exception $th) {
            Log::error($th);
            // in case of duplication of the Unique ID this will recursive.
            $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
            $this->updateExaminationStudent($student,$sis_student);
        }
    }

    public static function createOrUpdateStudentProfile($row, $prefix, $file)
    {
        try {
            $uniqueUid = new UniqueUid();
            $BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')->first();
            $nationalityId = Nationality::where('name', 'like', '%' . $row['nationality'] . '%')->first();
            $identityType = Identity_type::where('national_code', 'like', '%' . $row['identity_type'] . '%')->first();
            
            $date = $row['date_of_birth_yyyy_mm_dd'];
            $identityType = $identityType !== null ? $identityType->id : null;
            $nationalityId = $nationalityId !== null ? $nationalityId->id : null;

            $BirthArea = $BirthArea !== null ? $BirthArea->id : null;
            $openemisNo = $uniqueUid::getUniqueAlphanumeric();
            $preferred_name = null;
            if (array_key_exists('preferred_name', $row)) {
                $preferred_name = $row['preferred_name'];
            }
            switch ($prefix) {
                case 'create':
                    return  Security_user::create([
                        'username' => str_replace('-', '', $openemisNo),
                        'openemis_no' => $openemisNo,
                        'first_name' => $row['full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
                        'last_name' => genNameWithInitials($row['full_name']),
                        'preferred_name' => $preferred_name,
                        'gender_id' => $row['gender_mf'],
                        'date_of_birth' => $date,
                        'address' => $row['address'],
                        'birthplace_area_id' => $BirthArea,
                        'nationality_id' => $nationalityId,
                        'identity_type_id' => $identityType,
                        'identity_number' => $row['identity_number'],
                        'is_student' => 1,
                        'created_user_id' => $file['security_user_id']
                    ]);
                case 'update':
                    if (!is_null($row['student_id'])) {
                        $studentInfo =  Security_user::where('openemis_no',trim($row['student_id']))->first();
                        self::query()->where('openemis_no', $row['student_id'])
                            ->update([
                                'first_name' => $row['full_name'] ? $row['full_name'] : $studentInfo['first_name'], // here we save full name in the column of first name. re reduce breaks of the system.
                                'last_name' => $row['full_name'] ? genNameWithInitials($row['full_name']) : genNameWithInitials($studentInfo['first_name']),
                                'preferred_name' => $preferred_name,
                                'gender_id' => is_numeric($row['gender_mf']) ? $row['gender_mf'] : $studentInfo['gender_id'],
                                'date_of_birth' => $date ? $date : $studentInfo['date_of_birth'],
                                'address' => $row['address'] ? $row['address'] : $studentInfo['address'],
                                'birthplace_area_id' => $row['birth_registrar_office_as_in_birth_certificate'] ? $BirthArea : $studentInfo['birthplace_area_id'],
                                'nationality_id' => $row['nationality'] ? $nationalityId : $studentInfo['nationality_id'],
                                'identity_type_id' => $row['identity_type'] ? $identityType : $studentInfo['identity_type_id'],
                                'identity_number' => $row['identity_number'] ? $row['identity_number'] : $studentInfo['identity_number'],
                                'is_student' => 1,
                                'modified' => now(),
                                'modified_user_id' => $file['security_user_id']
                            ]);
                            return $studentInfo;
                    }
                    break;
            }
        } catch (\Exception $e) {
            dd($e);
        }
    }

    public static function createOrUpdateGuardianProfile($row, $prefix, $file)
    {
        try {
            $uniqueUid = new UniqueUid();
            $AddressArea = Area_administrative::where('name', 'like', '%' . $row[$prefix . 's_address_area'] . '%')->first();
            $nationalityId = Nationality::where('name', 'like', '%' . $row[$prefix . 's_nationality'] . '%')->first();
            $identityType = Identity_type::where('national_code', 'like', '%' . $row[$prefix . 's_identity_type'] . '%')->first();
            $openemisNo = $uniqueUid::getUniqueAlphanumeric();

            $identityType = ($identityType !== null) ? $identityType->id : null;
            $nationalityId = $nationalityId !== null ? $nationalityId->id : null;

            $guardian = null;
            if (!empty($row[$prefix . 's_identity_number'])) {
                $guardian = Security_user::where('identity_type_id', '=', $nationalityId)
                    ->where('identity_number', '=', $row[$prefix . 's_identity_number'])->first();
            }

            if (is_null($guardian)) {
                $guardian = self::create([
                    'username' => str_replace('-', '', $openemisNo),
                    'openemis_no' => $openemisNo,
                    'first_name' => $row[$prefix . 's_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
                    'last_name' => genNameWithInitials($row[$prefix . 's_full_name']),
                    'gender_id' => 1,
                    'date_of_birth' => $row[$prefix . 's_date_of_birth_yyyy_mm_dd'],
                    'address' => $row[$prefix . 's_address'],
                    'address_area_id' => $AddressArea ? $AddressArea->id : null,
                    'nationality_id' => $nationalityId,
                    'identity_type_id' => $identityType,
                    'identity_number' => $row[$prefix . 's_identity_number'],
                    'is_guardian' => 1,
                    'created_user_id' => $file['security_user_id']
                ]);


                $guardian['guardian_relation_id'] = 1;
                if (array_key_exists($prefix . 's_phone', $row)) {
                    $father['contact'] = $row[$prefix . 's_phone'];

                    User_contact::createOrUpdate($father, $file['security_user_id']);
                }
            } else {
                Security_user::where('id', $guardian->id)->update(['address_area_id' => $AddressArea ? $AddressArea->id : null,]);
            }
            return $guardian;
        } catch (\Exception $e) {
            Log::error($e->getMessage(), [$e]);
        }
    }
}


1			<?php
2
3			namespace App\Models;
4
5			use App\Models\User_contact;
6			use Lsf\UniqueUid\UniqueUid;
7			use App\Models\Unique_user_id;
8			use Illuminate\Support\Facades\DB;
9			use Illuminate\Support\Facades\Log;
10			use Illuminate\Database\Eloquent\Model;
11			use Illuminate\Database\Eloquent\SoftDeletes;
12
13			class Security_user extends Model
14			{
15
16			use SoftDeletes;
17
18			public const CREATED_AT = 'created';
19			public const UPDATED_AT = 'modified';
20			/**
21			* The database table used by the model.
22			*
23			* @var string
24			*/
25
26			public $timestamps = true;
27
28			protected $softDelete = true;
29
30			protected $table = 'security_users';
31
32			protected $appends = [
33			'special_need_name'
34			];
35
36			/**
37			* Attributes that should be mass-assignable.
38			*
39			* @var array
40			*/
41			protected $fillable = [
42			'openemis_no',
43			'first_name',
44			'last_name',
45			'address',
46			'address_area_id',
47			'birthplace_area_id',
48			'gender_id',
49			'remember_token',
50			'date_of_birth',
51			'nationality_id',
52			'identity_type_id',
53			'identity_number',
54			'is_student',
55			'modified_user_id',
56			'modified',
57			'created_user_id',
58			'created',
59			'username',
60			'password',
61			];
62
63			/**
64			* The attributes excluded from the model's JSON form.
65			*
66			* @var array
67			*/
68			protected $hidden = [
69			'password',
70			'modified_user_id',
71			'middle_name',
72			'third_name',
73			'modified',
74			'created_user_id',
75			'created'
76
77			];
78
79
80			public function getSpecialNeedNameAttribute()
81			{
82			return optional($this->special_needs())->special_need_difficulty_id;
83			}
84
85			/**
86			* The attributes that should be casted to native types.
87			*
88			* @var array
89			*/
90			protected $casts = [];
91
92			public function institutionStudents()
93			{
94			return $this->hasOne(Institution_student::class, 'student_id');
95			}
96
97			public function institutionStudentsClass()
98			{
99			return $this->hasOne(Institution_student::class, 'student_id');
100			}
101
102			/**
103			* The attributes that should be mutated to dates.
104			*
105			* @var array
106			*/
107			protected $dates = ['date_of_birth', 'date_of_death', 'last_login', 'modified', 'created'];
108
109			public function rules()
110			{
111			return [
112			'identity_number' => [
113			'required',
114			'unique:security_users,identity_number',
115			]
116			];
117			}
118
119			public function getAuthPassword()
120			{
121			return $this->password;
			0 ignored issues – show Bug introduced 2020-05-27 14:51 UTC by Report Bug Copy Issue Report The property `password` does not seem to exist on `App\Models\Security_user`. Are you sure there is no database migration missing? Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct. Loading history...
122			}
123
124			public function uploads()
125			{
126			return $this->hasMany('App\Models\Upload');
127			}
128
129			public function class()
130			{
131			return $this->belongsTo('App\Models\Institution_class_student', 'id', 'student_id');
132			}
133
134			public function special_needs()
135			{
136			return $this->hasMany('App\Models\User_special_need', 'id', 'security_user_id');
137			}
138
139			public function genUUID()
140			{
141			$uuid = Uuid::generate(4);
			0 ignored issues – show Bug introduced 2020-06-12 04:48 UTC by Report Bug Copy Issue Report The type `App\Models\Uuid` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
142			return str_split($uuid, '8')[0];
143			}
144
145			/**
146			* First level search for students
147			*
148			* @param array $student
149			* @return array
150			*/
151			public function getMatches($student)
152			{
153			return $this
154			->where('gender_id', $student['gender'] + 1)
155			->where('institutions.code', $student['schoolid'])
156			->where('date_of_birth', $student['b_date'])
157			->join('institution_students', 'security_users.id', 'institution_students.student_id')
158			->join('institutions', 'institution_students.institution_id', 'institutions.id')
159			->get()->toArray();
160			}
161
162			/**
163			* First level search for students
164			*
165			* @param array $student
166			* @return array
167			*/
168			public function getStudentCount($student)
169			{
170			return $this
			0 ignored issues – show Bug Best Practice introduced 2020-09-01 13:16 UTC by Report Bug Copy Issue Report The expression `return $this->where('gen...titutions.id')->count()` also could return the type `Illuminate\Database\Eloq...e\Query\Builder\|integer` which is incompatible with the documented return type `array`. Loading history...
171			->where('gender_id', $student['gender'] + 1)
172			->where('institutions.code', $student['schoolid'])
173			->where('date_of_birth', $student['b_date'])
174			->join('institution_students', 'security_users.id', 'institution_students.student_id')
175			->join('institutions', 'institution_students.institution_id', 'institutions.id')
176			->count();
177			}
178
179			/**
180			* insert student data from examination
181			* @input array
182			* @return array
183			*/
184			public function insertExaminationStudent($student)
185			{
186			$this->uniqueUserId = new Unique_user_id();
			0 ignored issues – show Bug introduced 2020-06-12 04:48 UTC by Report Bug Copy Issue Report The property `uniqueUserId` does not seem to exist on `App\Models\Security_user`. Are you sure there is no database migration missing? Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct. Loading history...
187			$this->uniqueUId = new UniqueUid();
			0 ignored issues – show Bug introduced 2020-06-16 11:51 UTC by Report Bug Copy Issue Report The property `uniqueUId` does not seem to exist on `App\Models\Security_user`. Are you sure there is no database migration missing? Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct. Loading history...
188			$uniqueId = $this->uniqueUId::getUniqueAlphanumeric();
189			$studentData = [
190			'username' => str_replace('-', '', $uniqueId),
191			'openemis_no' => $uniqueId, // Openemis no is unique field, in case of the duplication it will failed
192			'first_name' => $student['f_name'], // here we save full name in the column of first name. re reduce breaks of the system.
193			'last_name' => genNameWithInitials($student['f_name']),
194			'gender_id' => $student['gender'] + 1,
195			'date_of_birth' => $student['b_date'],
196			'address' => $student['pvt_address'],
197			'is_student' => 1,
198			'updated_from' => 'doe',
199			'created' => now(),
200			'created_user_id' => 1
201			];
202			try {
203			$id = $this->insertGetId($studentData);
204			$studentData['id'] = $id;
205			$this->uniqueUserId->updateOrInsertRecord($studentData);
206			return $studentData;
207			} catch (\Exception $th) {
208			Log::error($th->getMessage());
209			// in case of duplication of the Unique ID this will recursive till success.
210			$sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-09-17 09:56 UTC by Report Bug Copy Issue Report `$sis_student` was never initialized. Although not strictly required by PHP, it is generally a good practice to add `$sis_student = array();` before regardless. Loading history...
211			$this->insertExaminationStudent($sis_student);
212			}
213			return $studentData;
214			}
215
216			/**
217			* Update the existing student's data
218			*
219			* @param array $student
220			* @param array $sis_student
221			* @return array
222			*/
223			public function updateExaminationStudent($student, $sis_student)
224			{
225			$this->uniqueUserId = new Unique_user_id();
			0 ignored issues – show Bug introduced 2020-06-12 04:48 UTC by Report Bug Copy Issue Report The property `uniqueUserId` does not seem to exist on `App\Models\Security_user`. Are you sure there is no database migration missing? Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct. Loading history...
226			$this->uniqueUId = new UniqueUid();
227			// regenerate unique id if it's not available
228			$uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ? $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric();
229
230			$studentData = [
231			'username' => str_replace('-', '', $uniqueId),
232			'openemis_no' => $uniqueId, // Openemis no is unique field, in case of the duplication it will failed
233			'first_name' => $student['f_name'], // here we save full name in the column of first name. re reduce breaks of the system.
234			'last_name' => genNameWithInitials($student['f_name']),
235			'date_of_birth' => $student['b_date'],
236			'address' => $student['pvt_address'],
237			'updated_from' => 'doe',
238			'modified' => now()
239			];
240
241			try {
242			self::where('id', $sis_student['student_id'])->update($studentData);
243			$studentData['id'] = $sis_student['student_id'];
244			$this->uniqueUserId->updateOrInsertRecord($studentData);
245			return $studentData;
246			} catch (\Exception $th) {
247			Log::error($th);
248			// in case of duplication of the Unique ID this will recursive.
249			$sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
250			$this->updateExaminationStudent($student,$sis_student);
251			}
252			}
253
254			public static function createOrUpdateStudentProfile($row, $prefix, $file)
255			{
256			try {
257			$uniqueUid = new UniqueUid();
258			$BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')->first();
259			$nationalityId = Nationality::where('name', 'like', '%' . $row['nationality'] . '%')->first();
260			$identityType = Identity_type::where('national_code', 'like', '%' . $row['identity_type'] . '%')->first();
261
262			$date = $row['date_of_birth_yyyy_mm_dd'];
263			$identityType = $identityType !== null ? $identityType->id : null;
264			$nationalityId = $nationalityId !== null ? $nationalityId->id : null;
265
266			$BirthArea = $BirthArea !== null ? $BirthArea->id : null;
267			$openemisNo = $uniqueUid::getUniqueAlphanumeric();
268			$preferred_name = null;
269			if (array_key_exists('preferred_name', $row)) {
270			$preferred_name = $row['preferred_name'];
271			}
272			switch ($prefix) {
273			case 'create':
274			return Security_user::create([
275			'username' => str_replace('-', '', $openemisNo),
276			'openemis_no' => $openemisNo,
277			'first_name' => $row['full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
278			'last_name' => genNameWithInitials($row['full_name']),
279			'preferred_name' => $preferred_name,
280			'gender_id' => $row['gender_mf'],
281			'date_of_birth' => $date,
282			'address' => $row['address'],
283			'birthplace_area_id' => $BirthArea,
284			'nationality_id' => $nationalityId,
285			'identity_type_id' => $identityType,
286			'identity_number' => $row['identity_number'],
287			'is_student' => 1,
288			'created_user_id' => $file['security_user_id']
289			]);
290			case 'update':
291			if (!is_null($row['student_id'])) {
292			$studentInfo = Security_user::where('openemis_no',trim($row['student_id']))->first();
293			self::query()->where('openemis_no', $row['student_id'])
294			->update([
295			'first_name' => $row['full_name'] ? $row['full_name'] : $studentInfo['first_name'], // here we save full name in the column of first name. re reduce breaks of the system.
296			'last_name' => $row['full_name'] ? genNameWithInitials($row['full_name']) : genNameWithInitials($studentInfo['first_name']),
297			'preferred_name' => $preferred_name,
298			'gender_id' => is_numeric($row['gender_mf']) ? $row['gender_mf'] : $studentInfo['gender_id'],
299			'date_of_birth' => $date ? $date : $studentInfo['date_of_birth'],
300			'address' => $row['address'] ? $row['address'] : $studentInfo['address'],
301			'birthplace_area_id' => $row['birth_registrar_office_as_in_birth_certificate'] ? $BirthArea : $studentInfo['birthplace_area_id'],
302			'nationality_id' => $row['nationality'] ? $nationalityId : $studentInfo['nationality_id'],
303			'identity_type_id' => $row['identity_type'] ? $identityType : $studentInfo['identity_type_id'],
304			'identity_number' => $row['identity_number'] ? $row['identity_number'] : $studentInfo['identity_number'],
305			'is_student' => 1,
306			'modified' => now(),
307			'modified_user_id' => $file['security_user_id']
308			]);
309			return $studentInfo;
310			}
311			break;
312			}
313			} catch (\Exception $e) {
314			dd($e);
315			}
316			}
317
318			public static function createOrUpdateGuardianProfile($row, $prefix, $file)
319			{
320			try {
321			$uniqueUid = new UniqueUid();
322			$AddressArea = Area_administrative::where('name', 'like', '%' . $row[$prefix . 's_address_area'] . '%')->first();
323			$nationalityId = Nationality::where('name', 'like', '%' . $row[$prefix . 's_nationality'] . '%')->first();
324			$identityType = Identity_type::where('national_code', 'like', '%' . $row[$prefix . 's_identity_type'] . '%')->first();
325			$openemisNo = $uniqueUid::getUniqueAlphanumeric();
326
327			$identityType = ($identityType !== null) ? $identityType->id : null;
328			$nationalityId = $nationalityId !== null ? $nationalityId->id : null;
329
330			$guardian = null;
331			if (!empty($row[$prefix . 's_identity_number'])) {
332			$guardian = Security_user::where('identity_type_id', '=', $nationalityId)
333			->where('identity_number', '=', $row[$prefix . 's_identity_number'])->first();
334			}
335
336			if (is_null($guardian)) {
337			$guardian = self::create([
338			'username' => str_replace('-', '', $openemisNo),
339			'openemis_no' => $openemisNo,
340			'first_name' => $row[$prefix . 's_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
341			'last_name' => genNameWithInitials($row[$prefix . 's_full_name']),
342			'gender_id' => 1,
343			'date_of_birth' => $row[$prefix . 's_date_of_birth_yyyy_mm_dd'],
344			'address' => $row[$prefix . 's_address'],
345			'address_area_id' => $AddressArea ? $AddressArea->id : null,
346			'nationality_id' => $nationalityId,
347			'identity_type_id' => $identityType,
348			'identity_number' => $row[$prefix . 's_identity_number'],
349			'is_guardian' => 1,
350			'created_user_id' => $file['security_user_id']
351			]);
352
353
354			$guardian['guardian_relation_id'] = 1;
355			if (array_key_exists($prefix . 's_phone', $row)) {
356			$father['contact'] = $row[$prefix . 's_phone'];
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-12-22 09:45 UTC by Report Bug Copy Issue Report `$father` was never initialized. Although not strictly required by PHP, it is generally a good practice to add `$father = array();` before regardless. Loading history...
357			User_contact::createOrUpdate($father, $file['security_user_id']);
358			}
359			} else {
360			Security_user::where('id', $guardian->id)->update(['address_area_id' => $AddressArea ? $AddressArea->id : null,]);
361			}
362			return $guardian;
363			} catch (\Exception $e) {
364			Log::error($e->getMessage(), [$e]);
365			}
366			}
367			}
368

moe-lk / bulk-upload

Security_user::createOrUpdateStudentProfile() D last analyzed 2022-03-28 10:30 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like

Security_user::createOrUpdateStudentProfile() D
last analyzed 2022-03-28 10:30 UTC