/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS = 0'); if (Registration::count()) { return; } Registration::truncate(); // $this->call("OthersTableSeeder"); $periods = [['id' => '1', 'name' => 'فترة قبول 2013', 'start_at' => '2013-08-01', 'finish_at' => '2013-10-01', 'code' => 'e2013', 'academycycle_year_id' => '1'], ['id' => '2', 'name' => 'فترة قبول 2014', 'start_at' => '2014-08-01', 'finish_at' => '2014-10-01', 'code' => 'e2014', 'academycycle_year_id' => '2'], ['id' => '3', 'name' => 'فترة قبول 2015', 'start_at' => '2015-08-01', 'finish_at' => '2015-10-01', 'code' => 'e2015', 'academycycle_year_id' => '3']]; foreach ($periods as $period) { //Period::create($period); } $this->command->info('periods entered!'); $country = [0 => null, 1 => 613, 4 => 616, 5 => 617, 6 => 618, 7 => 619, 16 => 628, 17 => 629]; $allstatuses = array("MN" => "إلغاء لعدم سداد الرسوم", "VN" => "إلغاء لعدم إرسال المستندات الموثقه", "MVN" => "إلغاء الطلب لعدم السداد وإرسال المستندات المصدقة", "DX" => "إلغاء الطلب لعدم تحميل المستندات", "XX" => "إلغاء لتكرار الطلب", "CN" => "تم الرفض", "EN" => "طالب منتظم"); $old_state = ['DM' => 3, 'MW' => 3, 'CO' => 3, 'AP' => 3, 'VC' => 3, 'DN' => 3, 'CW' => 3, 'DU' => 3, 'DC' => 3, 'MN' => 3, 'VN' => 3, 'MVN' => 3, 'DX' => 3, 'XX' => 3, 'CN' => 15, 'EN' => 26]; $reg_type = ['bachaleor' => 2, 'diplom' => 1, 'takmely' => 3]; $reg_specialty = ['islam' => 2, 'feqh' => 1, 'general' => 3]; $reg_stay_type = ['morafek' => 'companion', 'notresident' => 'non_resident', 'tourism' => 'tourism', 'work' => 'work']; $registrations = DB::connection('old')->table('registration')->get(); $all_regs = []; foreach ($registrations as $registration) { //$new_registration = new Registration(); $new_registration = []; //name $new_registration['id'] = $registration->reg_id; $new_registration['first_name'] = $registration->reg_firstname; $new_registration['second_name'] = $registration->reg_secondname; $new_registration['third_name'] = $registration->reg_thirdname; $new_registration['fourth_name'] = $registration->reg_fourthname; $new_registration['last_name'] = $registration->reg_lastname; $new_registration['last_name_latin'] = ''; $new_registration['fourth_name_latin'] = ''; $new_registration['third_name_latin'] = ''; $new_registration['second_name_latin'] = ''; $new_registration['first_name_latin'] = $registration->reg_englishname; // $new_registration['registration_type_id'] = $reg_type[$registration->reg_stage]; $new_registration['academystructure_specialty_id'] = $reg_specialty[$registration->reg_specialist]; // $new_registration['religion'] = $registration->reg_relegion; $new_registration['gender'] = $registration->reg_gender == 1 ? 'f' : 'm'; //birthday $new_registration['birthday'] = $registration->reg_birthdate; $new_registration['birth_country_id'] = !empty($country[$registration->reg_birthcountryid]) ? $country[$registration->reg_birthcountryid] : 613; // nationality $new_registration['national_id'] = $registration->reg_nationalid; $new_registration['nationality_type'] = $registration->reg_nationality ? 'E' : 'O'; $new_registration['nationality_country_id'] = !empty($country[$registration->reg_nationalitycountry]) ? $country[$registration->reg_nationalitycountry] : 613; //passport $new_registration['passeport_number'] = $registration->reg_passportnum; $new_registration['passeport_issued'] = $registration->reg_passportstartdate; $new_registration['passeport_expire'] = $registration->reg_passportenddate; $new_registration['passeport_country_id'] = !empty($country[$registration->reg_passportcountryid]) ? $country[$registration->reg_passportcountryid] : 613; //stay $new_registration['stay_expire'] = $registration->reg_stayenddate; $new_registration['stay_type'] = in_array($registration->reg_staytype, $reg_stay_type) ? $reg_stay_type[$registration->reg_staytype] : 'other'; //contact $new_registration['contact_region'] = $registration->reg_contactregion; $new_registration['contact_postalbox'] = $registration->reg_contactpostalbox; $new_registration['contact_street'] = $registration->reg_contactstreet; $new_registration['contact_home_number'] = $registration->reg_contacthomenum; $new_registration['contact_email'] = $registration->reg_contactemail; $new_registration['contact_mobile'] = $registration->reg_contactmobile; $new_registration['contact_phone'] = $registration->reg_contacthomephone; $new_registration['contact_fax'] = $registration->reg_contactfax; $new_registration['contact_country_id'] = !empty($country[$registration->reg_contact_countryid]) ? $country[$registration->reg_contact_countryid] : 613; $new_registration['contact_city_id'] = $registration->reg_contactcityid > 0 ? $registration->reg_contactcityid : null; $new_registration['contact_state_id'] = null; //degree $new_registration['social_status'] = $registration->reg_socialmarital; $new_registration['degree_speciality'] = $registration->reg_eduspecialist; $new_registration['degree_institution'] = $registration->reg_eduplace; $new_registration['degree_score'] = $registration->reg_edugrade; $new_registration['degree_graduation_year'] = $registration->reg_eduendyear; $new_registration['degree_country_id'] = !empty($country[$registration->reg_edulevelcountry]) ? $country[$registration->reg_edulevelcountry] : 613; //social $new_registration['social_job'] = $registration->reg_socialworkjob; $new_registration['social_job_status'] = $registration->reg_socialworkstatus; $new_registration['social_job_start'] = $registration->reg_socialworkstart; $new_registration['social_experience'] = $registration->reg_socialworkexpert; $new_registration['social_job_employer'] = $registration->reg_socialworkplace; $new_registration['social_job_country_id'] = !empty($country[$registration->reg_socialworkcountryid]) ? $country[$registration->reg_socialworkcountryid] : 613; $new_registration['social_job_city_id'] = $registration->reg_socialworkcityid > 0 ? $registration->reg_socialworkcityid : null; $reg_socialworksector = ''; if ($registration->reg_socialworksector == 'public') { $reg_socialworksector = 'government'; } if ($registration->reg_socialworksector == 'private') { $reg_socialworksector = 'private'; } if ($registration->reg_socialworksector == 'free') { $reg_socialworksector = 'freelance'; } $new_registration['social_job_type'] = $reg_socialworksector; //others $new_registration['email_verified'] = 0; $new_registration['verification_token'] = ''; $new_registration['debit'] = 0; //health $new_registration['health_status'] = $registration->reg_healthstatus; $new_registration['health_disabled_type'] = $registration->reg_healthdisabledtype; $new_registration['health_disabled_size'] = $registration->reg_healthdisabledsize; //skills $new_registration['computer_skills'] = $registration->reg_skillspc; $new_registration['internet_skills'] = $registration->reg_skillsnet; $new_registration['internet_link'] = $registration->reg_skillsgoodnetline; $new_registration['cyber_cafe'] = $registration->reg_skillsnearnet; $new_registration['computer_availability'] = $registration->reg_skillshaspc; //refrence $new_registration['reference'] = $registration->reg_skillsknowus; $new_registration['reference_other'] = $registration->reg_skillsknowustext; //period and prefix $period = ''; $prefix = ''; if ($registration->reg_eduyearid == '1') { $period = '1'; $prefix = 'e2013'; } if ($registration->reg_eduyearid == '2') { $period = '2'; $prefix = 'e2014'; } if ($registration->reg_eduyearid == '3') { $period = '3'; $prefix = 'e2015'; } $new_registration['username_prefix'] = $prefix; $new_registration['registration_period_id'] = $period; // $new_registration['registration_step_id'] = $old_state[$registration->reg_curstatus]; //var_dump($new_registration->toArray()); //$new_registration->save(); $new_registration['created_at'] = new DateTime(); $new_registration['updated_at'] = new DateTime(); $all_regs[] = $new_registration; } ///var_dump($all_regs); foreach (array_chunk($all_regs, 500) as $chunk) { DB::table('registrations')->insert($chunk); } foreach (Registration::all() as $registration) { //$registration->generateCode(); } $this->command->info('registration entered!'); }