File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/database/seeders/DealerSeeder.php
Back
<?php namespace Database\Seeders; use Illuminate\Database\Console\Seeds\WithoutModelEvents; use Illuminate\Database\Seeder; use Illuminate\Support\Facades\DB; class DealerSeeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('dealers')->truncate(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); $dealers = DB::connection('autohub_connect')->table('vts_dealerships')->get(); if ($dealers->isNotEmpty()) { foreach ($dealers as $dealer) { // Insert into the current database DB::table('dealers')->insert([ 'id' => $dealer->deal_id, // Ensure no conflicts with auto-increment 'comp_id' => $dealer->comp_id, 'dealer_code' => $dealer->deal_code, 'dealer_name' => $dealer->deal_name, 'dealer_address' => $dealer->deal_address, 'city' => $dealer->deal_city, 'contact' => $dealer->deal_contact, 'status' => $dealer->deal_status, ]); } } } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings