File
Thư viện sinh dữ liệu ngẫu nhiên Tiếng Việt:PhpVnDataGenerator
SanphamTableSeeder
php
1<?php2 3use Illuminate\Database\Seeder;4 5class SanphamTableSeeder extends Seeder {6 /**7 * Run the database seeds.8 *9 * @return void10 */11 public function run() {12 $list = [];13 $faker = Faker\Factory::create('vi_VN');14 $photos = array('hoahong.jpg','hoalan.jpg','hoatuoi.jpg');15 16 for ($i=1; $i <= 30; $i++) {17 $today = new DateTime();18 array_push($list, [19 'sp_ten' => "sp_ten $i",20 'sp_giaGoc' => $faker->randomFloat(2000000, 50000, 1999999),21 'sp_giaBan' => $i,22 'sp_hinh' => "hoa-$i.jpg",23 'sp_thongTin' => "sp_thong $i",24 'sp_danhGia' => "sp_danhGia $i",25 'sp_taoMoi' => $today->format('Y-m-d H:i:s'),26 'sp_capNhat' => $today->format('Y-m-d H:i:s'),27 'sp_trangThai' => $faker->numberBetween(1, 2),28 'l_ma' => $faker->numberBetween(1, 9) // Khoa ngoai29 ]);30 }31 DB::table('cusc_sanpham')->insert($list);32 }33}- Download về, giải nén
- Copy vào thư mục: `vendor\laravel\framework\src\Illuminate`
php
1<?php2 3use Illuminate\Database\Seeder;4use Illuminate\PhpVnDataGenerator\VnBase;5use Illuminate\PhpVnDataGenerator\VnFullname;6use Illuminate\PhpVnDataGenerator\VnPersonalInfo;7 8class KhachhangTableSeeder extends Seeder {9 /**10 * Run the database seeds.11 *12 * @return void13 */14 public function run() {15 $list = [];16 $uFN = new VnFullname();17 $uPI = new VnPersonalInfo();18 19 $nCustomers = 30;20 $minFemales = 10;21 $maxFemales = 15;22 $nFemales = VnBase::RandomNumber($minFemales, $maxFemales);23 $nMales = $nCustomers - $nFemales;24 25 $females = $uFN->FullNames(VnBase::VnFemale, $nFemales);26 $males = $uFN->FullNames(VnBase::VnMale, $nMales);27 28 $customers = [];29 $m = 0;30 $f = 0;31 while ($m <= $nMales-1 || $f <= $nFemales-1) {32 if ($m == $nMales) { //Đã chọn hết nam33 array_push($customers, ["gender"=>VnBase::VnFemale, "name"=>$females[$f]]);34 $f++;35 } else if ($f == $nFemales) { //Đã chọn hết nữ36 array_push($customers, ["gender"=>VnBase::VnMale, "name"=>$males[$m]]);37 $m++;38 } else {39 if (VnBase::RandomNumber(0, 1000) < 550) {40 array_push($customers, ["gender"=>VnBase::VnMale, "name"=>$males[$m]]);41 $m++;42 } else {43 array_push($customers, ["gender"=>VnBase::VnFemale, "name"=>$females[$f]]);44 $f++;45 }46 }47 }48 49 $today = new DateTime('2010-01-01 08:00:00');50 for ($i=1; $i <= $nCustomers; $i++) {51 $xs = VnBase::RandomNumber(0, 1000);52 if ($xs > 100) {53 $step = "P";54 if ($xs < 400) {55 $step .= "T";56 $xs = VnBase::RandomNumber(0, 1000);57 if ($xs < 400) {58 $step .= VnBase::RandomNumber(1000, 10800);59 } else if ($xs < 700) {60 $step .= VnBase::RandomNumber(10801, 21600);61 } else if ($xs < 900) {62 $step .= VnBase::RandomNumber(21601, 43200);63 } else {64 $step .= VnBase::RandomNumber(43201, 86400); 65 }66 $step .= "S";67 } else {68 $xs = VnBase::RandomNumber(0, 1000);69 if ($xs < 500) {70 $step .= VnBase::RandomNumber(1, 5);71 } else if ($xs < 800) {72 $step .= VnBase::RandomNumber(6, 15);73 } else {74 $step .= VnBase::RandomNumber(16, 25); 75 }76 $step .= "D";77 }78 $nextTime = new DateInterval($step);79 $today->add($nextTime);80 }81 82 $gender = $customers[$i - 1]["gender"];83 $name = $customers[$i - 1]["name"];84 $age = $uPI->Age(12);85 $birthYear= $uPI->BirthYearValue($age);86 $birthdate= $uPI->Birthdate($birthYear);87 $email = $uPI->Email ($name, $birthdate, "", "?", "", VnBase::VnMixed, VnBase::VnMixed, VnBase::VnTrue);88 $username = $uPI->Username($name, $birthdate, "?", "", VnBase::VnMixed, VnBase::VnMixed, VnBase::VnTrue);89 $password = bcrypt('123456');90 $phone = $uPI->Mobile("", VnBase::VnFalse);91 $address = $uPI->Address();92 93 array_push($list, [94 'kh_ma' => $i,95 'kh_taiKhoan' => $username,96 'kh_matKhau' => $password,97 'kh_hoTen' => $name,98 'kh_gioiTinh' => $gender == VnBase::VnMale,99 'kh_email' => $email,100 'kh_ngaySinh' => $birthdate["birthdate"],101 'kh_diaChi' => $address,102 'kh_dienThoai' => $phone,103 'kh_taoMoi' => $today->format('Y-m-d H:i:s'),104 'kh_capNhat' => $today->format('Y-m-d H:i:s'),105 'kh_trangThai' => ($i <= $nCustomers-3? 2: 3)106 ]);107 }108 // Admin109 array_push($list, [110 'kh_ma' => $nCustomers+1,111 'kh_taiKhoan' => 'dnpcuong',112 'kh_matKhau' => bcrypt('123456'),113 'kh_hoTen' => 'Dương Nguyễn Phú Cường',114 'kh_gioiTinh' => $gender == VnBase::VnMale,115 'kh_email' => '[email protected]',116 'kh_ngaySinh' => '1989-06-11',117 'kh_diaChi' => '130 Xô Viết Nghệ Tỉnh, Quận Ninh Kiều, TP Cần Thơ',118 'kh_dienThoai' => '0915659223',119 'kh_taoMoi' => $today->format('Y-m-d H:i:s'),120 'kh_capNhat' => $today->format('Y-m-d H:i:s'),121 'kh_trangThai' => 2 // Khả dụng122 ]);123 DB::table('cusc_khachhang')->insert($list);124 }125}
