/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); // if (RegistrationFile::count()) { // return; // } // RegistrationFile::truncate(); // $this->call("OthersTableSeeder"); $file_type = [1 => 'photo', 2 => 'nid', 3 => 'certificate', 4 => 'transcript', 5 => 'job', 6 => 'marriage', 7 => 'receipt']; $PATH = 'https://el-css.edu.om/iis/assets/admissions/'; $registrations = DB::connection('old')->table('registration')->get(); foreach ($registrations as $registration) { if ($registration->reg_nationalphoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'nid'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_nationalphoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } if ($registration->reg_eduphoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'certificate'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_eduphoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } if ($registration->reg_userphoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'photo'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_userphoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } if ($registration->reg_degreesphoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'transcript'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_degreesphoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } if ($registration->reg_workphoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'job'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_workphoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } if ($registration->reg_marriagephoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'marriage'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_marriagephoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } if ($registration->reg_paymentphoto != '') { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $registration->reg_id; $new_RegistrationFile->type = 'receipt'; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $registration->reg_paymentphoto; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } } $this->command->info('file from registration table entered!'); $registration_files = DB::connection('old')->table('reg_userdocs')->get(); foreach ($registration_files as $Rfile) { $new_RegistrationFile = new RegistrationFile(); $new_RegistrationFile->registration_id = $Rfile->rud_regid; $new_RegistrationFile->type = $file_type[$Rfile->rud_docid]; $new_RegistrationFile->valid = 1; $new_RegistrationFile->file = $PATH . $Rfile->rud_file; try { $new_RegistrationFile->save(); } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } catch (\Codesleeve\Stapler\Exceptions\FileException $e) { echo 'couldnt move file'; } if ($new_RegistrationFile->file->size() < 600) { $new_RegistrationFile->delete(); } } $this->command->info('file from reg_doc table entered!'); }