61 lines
6.5 KiB
PHP
61 lines
6.5 KiB
PHP
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
use App\Models\Subkriteria;
|
|
|
|
class MobilSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*/
|
|
public function run(): void
|
|
{
|
|
// Ambil ID subkriteria berdasarkan nama subkriteria "Jenis Mobil"
|
|
$subKriteriaJenisMobil = DB::table('sub_kriteria')
|
|
->whereIn('nama_subkriteria', ['2-5 Penumpang (2 Baris)', '6-7 Penumpang (3 Baris)', '9-12 Penumpang (Elf/Van)', '30-45 Penumpang (Bus)'])
|
|
->pluck('id', 'nama_subkriteria');
|
|
|
|
$mobils = [
|
|
['nama_mobil' => 'Innova Reborn Diesel', 'gambar' => 'innova.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Segitiga Pengaman, APAR, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '600000', 'konsumsi_bbm' => 12, 'tahun' => 2021],
|
|
['nama_mobil' => 'Brio AT', 'gambar' => 'brio.jpg', 'kelengkapan_mobil' => 'Ban Cadangan, Segitiga Pengaman, Dongkrak', 'jenis_mobil' => '2-5 Penumpang (2 Baris)', 'harga_sewa_per_hari' => '300000', 'konsumsi_bbm' => 12, 'tahun' => 2021],
|
|
['nama_mobil' => 'Avanza New', 'gambar' => 'avanza_new.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '350000', 'konsumsi_bbm' => 14, 'tahun' => 2023],
|
|
['nama_mobil' => 'Agya CVT', 'gambar' => 'agya.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Segitiga Pengaman', 'jenis_mobil' => '2-5 Penumpang (2 Baris)', 'harga_sewa_per_hari' => '250000', 'konsumsi_bbm' => 18, 'tahun' => 2022],
|
|
['nama_mobil' => 'Xenia New', 'gambar' => 'xenia.jpg', 'kelengkapan_mobil' => 'Ban Cadangan, APAR, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '350000', 'konsumsi_bbm' => 14, 'tahun' => 2022],
|
|
['nama_mobil' => 'Avanza Facellit', 'gambar' => 'avanza_facelift.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Segitiga Pengaman', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '350000', 'konsumsi_bbm' => 13, 'tahun' => 2021],
|
|
['nama_mobil' => 'Rush', 'gambar' => 'rush.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '450000', 'konsumsi_bbm' => 13, 'tahun' => 2022],
|
|
['nama_mobil' => 'Xpander', 'gambar' => 'expander.jpg', 'kelengkapan_mobil' => 'Kunci Roda, APAR, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '400000', 'konsumsi_bbm' => 13, 'tahun' => 2022],
|
|
['nama_mobil' => 'Terios', 'gambar' => 'terios.jpg', 'kelengkapan_mobil' => 'Ban Cadangan, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '375000', 'konsumsi_bbm' => 13, 'tahun' => 2021],
|
|
['nama_mobil' => 'Toyota Alphard', 'gambar' => 'alphard.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Segitiga Pengaman, APAR', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '1300000', 'konsumsi_bbm' => 8, 'tahun' => 2020],
|
|
['nama_mobil' => 'Sigra Manual', 'gambar' => 'sigra_manual.jpg', 'kelengkapan_mobil' => 'Segitiga Pengaman, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '250000', 'konsumsi_bbm' => 17, 'tahun' => 2020],
|
|
['nama_mobil' => 'Sigra AT (MATIC)', 'gambar' => 'sigra_at.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '300000', 'konsumsi_bbm' => 16, 'tahun' => 2022],
|
|
['nama_mobil' => 'Raize', 'gambar' => 'raize.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Segitiga Pengaman, Dongkrak', 'jenis_mobil' => '2-5 Penumpang (2 Baris)', 'harga_sewa_per_hari' => '375000', 'konsumsi_bbm' => 15, 'tahun' => 2022],
|
|
['nama_mobil' => 'Calya', 'gambar' => 'calya.jpg', 'kelengkapan_mobil' => 'Ban Cadangan, Dongkrak', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '240000', 'konsumsi_bbm' => 15, 'tahun' => 2021],
|
|
['nama_mobil' => 'Ertiga', 'gambar' => 'ertiga.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, APAR', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '350000', 'konsumsi_bbm' => 14, 'tahun' => 2022],
|
|
['nama_mobil' => 'Daihatsu Luxio', 'gambar' => 'luxio.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Segitiga Pengaman, APAR', 'jenis_mobil' => '6-7 Penumpang (3 Baris)', 'harga_sewa_per_hari' => '550000', 'konsumsi_bbm' => 12, 'tahun' => 2021],
|
|
['nama_mobil' => 'Hiace Premo', 'gambar' => 'hiace_premo.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Segitiga Pengaman, APAR, Dongkrak', 'jenis_mobil' => '9-12 Penumpang (Elf/Van)', 'harga_sewa_per_hari' => '850000', 'konsumsi_bbm' => 15, 'tahun' => 2021],
|
|
['nama_mobil' => 'Hiace Comuter', 'gambar' => 'hiace_comuter.jpg', 'kelengkapan_mobil' => 'Ban Cadangan, Segitiga Pengaman, Dongkrak', 'jenis_mobil' => '9-12 Penumpang (Elf/Van)', 'harga_sewa_per_hari' => '1100000', 'konsumsi_bbm' => 9, 'tahun' => 2020],
|
|
['nama_mobil' => 'Isuzu Elf Long', 'gambar' => 'elf_long.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Segitiga Pengaman, APAR, Dongkrak', 'jenis_mobil' => '9-12 Penumpang (Elf/Van)', 'harga_sewa_per_hari' => '750000', 'konsumsi_bbm' => 9, 'tahun' => 2019],
|
|
['nama_mobil' => 'Bus Medium', 'gambar' => 'bus_medium.jpg', 'kelengkapan_mobil' => 'Kunci Roda, APAR, Dongkrak', 'jenis_mobil' => '30-45 Penumpang (Bus)', 'harga_sewa_per_hari' => '1300000', 'konsumsi_bbm' => 6, 'tahun' => 2020],
|
|
['nama_mobil' => 'Big Bus', 'gambar' => 'big_bus.jpg', 'kelengkapan_mobil' => 'Kunci Roda, Ban Cadangan, Segitiga Pengaman, APAR, Dongkrak', 'jenis_mobil' => '30-45 Penumpang (Bus)', 'harga_sewa_per_hari' => '2200000', 'konsumsi_bbm' => 5, 'tahun' => 2019],
|
|
];
|
|
|
|
foreach ($mobils as $mobil) {
|
|
DB::table('mobil')->insert([
|
|
'nama_mobil' => $mobil['nama_mobil'],
|
|
'gambar' => $mobil['gambar'],
|
|
'sub_kriteria_id' => $subKriteriaJenisMobil[$mobil['jenis_mobil']],
|
|
'kelengkapan_mobil' => $mobil['kelengkapan_mobil'],
|
|
'harga_sewa_per_hari' => $mobil['harga_sewa_per_hari'],
|
|
'konsumsi_bbm' => $mobil['konsumsi_bbm'],
|
|
'tahun' => $mobil['tahun'],
|
|
'created_at' => now(),
|
|
'updated_at' => now(),
|
|
]);
|
|
}
|
|
}
|
|
}
|