/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//Truncate
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
User::truncate();
Admin::truncate();
Customer::truncate();
Address::truncate();
Category::truncate();
Product::truncate();
Brand::truncate();
Type::truncate();
Image::truncate();
DB::statement('TRUNCATE category_product;');
Product::clearIndices();
Product::reindex();
//Unguard
Model::unguard();
//Call
$this->call(UsersTableSeeder::class);
$this->call(ProductsTableSeeder::class);
//Reguard
Model::reguard();
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Category::truncate();
$dummy = Faker::create();
foreach (range(0, 10) as $index) {
$category = Category::create(['name' => $dummy->name, 'parent_id' => 0]);
Category::create(['name' => $dummy->name, 'parent_id' => $category->id]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
Category::truncate();
News::truncate();
Model::unguard();
$this->call('CategorySeed');
$this->call('NewsSeed');
Model::reguard();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
\App\User::truncate();
\App\Receipt::truncate();
\App\Category::truncate();
$this->call('UserSeeder');
$this->call('ReceiptSeeder');
$this->call('CategorySeeder');
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
}
public function run()
{
// Disables foreign key constraints
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
$faker = Faker\Factory::create();
Category::truncate();
foreach (range(1, 10) as $index) {
$name = $faker->unique()->word();
Category::create(['name' => $name, 'slug' => str_slug($name)]);
}
// Enables foreign key constraints
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
}
public function run()
{
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
Category::truncate();
Category::create(['category' => 'Book']);
Category::create(['category' => 'Electronics']);
Category::create(['category' => 'Computer']);
Category::create(['category' => 'Joke']);
Category::create(['category' => 'Comic']);
Category::create(['category' => 'Lifestyle']);
Category::create(['category' => 'Dress']);
Category::create(['category' => 'Fashion']);
Category::create(['category' => 'Cushion']);
Category::create(['category' => 'Picture']);
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
User::truncate();
Book::truncate();
BookClub::truncate();
Publisher::truncate();
Category::truncate();
Language::truncate();
// $this->call(UserTableSeeder::class);
// factory(User::class, 5)->create();
$this->call(UserTableSeeder::class);
factory(Book::class, 14)->create();
factory(BookClub::class, 6)->create();
factory(Category::class, 3)->create();
factory(Publisher::class, 3)->create();
factory(Language::class, 3)->create();
DB::table('book_statuses')->insert(['name' => 'Available']);
DB::table('book_statuses')->insert(['name' => 'Not Available']);
Model::reguard();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
print_r('truncate' . PHP_EOL);
User::truncate();
Category::truncate();
Post::truncate();
Reply::truncate();
$faker = Faker::create();
User::create(['name' => 'Administrator', 'email' => '*****@*****.**', 'avatar' => 'assets/images/batman.png', 'password' => bcrypt('password'), 'remember_token' => str_random(10)]);
factory(App\User::class, 50)->create();
$users = User::lists('id')->toArray();
$topics = ['lifestyle', 'nightsale', 'dota2', 'berita', 'televisi'];
foreach ($topics as $t) {
print_r('Creating ' . $t . PHP_EOL);
$category = Category::create(['title' => $t, 'description' => $faker->text, 'slug' => str_slug($t)]);
$totalPost = rand(10, 20);
print_r(' Creating ' . $totalPost . ' posting' . PHP_EOL);
for ($i = 0; $i < $totalPost; $i++) {
$timestamp = $faker->dateTimeBetween('-1 year', 'now');
$post = Post::create(['user_id' => $faker->randomElement($users), 'category_id' => $category->id, 'title' => $faker->sentence, 'content' => $faker->paragraph(rand(1, 5)), 'created_at' => $timestamp, 'updated_at' => $timestamp]);
if ($faker->boolean(60)) {
$totalReply = rand(5, 20);
print_r(' Creating ' . $totalReply . ' reply' . PHP_EOL);
for ($j = 0; $j < $totalReply; $j++) {
$timestamp = $faker->dateTimeBetween('-1 year', 'now');
$reply = Reply::create(['user_id' => $faker->randomElement($users), 'post_id' => $post->id, 'content' => $faker->paragraph(rand(1, 5)), 'created_at' => $timestamp, 'updated_at' => $timestamp]);
}
$post->count_reply = $totalReply;
$post->save();
}
}
$category->count_posting = $totalPost;
$category->save();
print_r('------------------' . PHP_EOL);
}
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Category::truncate();
$data = [["name" => "Tin tức", "type" => 2, "image_url" => "frontend/images/title-news.png"], ["name" => "Hướng dẫn", "type" => 1, "image_url" => "frontend/images/navbar/huong-dan.png"], ["name" => "Đặc trưng", "type" => 1, "image_url" => "frontend/images/navbar/dac-trung.png"], ["name" => "Hoạt động", "type" => 1, "image_url" => "frontend/images/navbar/hoat-dong.png"], ["name" => "Cộng đồng", "type" => 1, "image_url" => "frontend/images/navbar/cong-dong.png"], ["name" => "Clip games", "type" => 3, "image_url" => "frontend/images/images/clip-game.png"], ["name" => "Wall paper", "type" => 3, "image_url" => "frontend/images/images/wallpaper.png"], ["name" => "Screenshot", "type" => 3, "image_url" => "frontend/images/images/screenshot.png"], ["name" => "gift code", "type" => 0, "image_url" => "frontend/images/button/gift-code.png"], ["name" => "the vip", "type" => 0, "image_url" => "frontend/images/button/the-vip.png"], ["name" => "tru thu", "type" => 0, "image_url" => "frontend/images/button/tro-thu.png"], ["name" => "Thu cuuoi", "type" => 0, "image_url" => "frontend/images/button/thu-cuoi.png"], ["name" => "trang bi", "type" => 0, "image_url" => "frontend/images/button/trang-bi.png"]];
Category::insert($data);
}
public function run()
{
Category::truncate();
Category::create(['name' => 'Accesorios', 'created_at' => \Carbon\Carbon::createFromDate(2015, 04, 01)->toDateTimeString(), 'updated_at' => \Carbon\Carbon::now()->toDateTimeString()]);
Category::create(['name' => 'Recambios', 'created_at' => \Carbon\Carbon::createFromDate(2015, 04, 01)->toDateTimeString(), 'updated_at' => \Carbon\Carbon::now()->toDateTimeString()]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Category::truncate();
CategoryTranslation::truncate();
DB::table('category_closure')->truncate();
}
public function run()
{
Category::truncate();
$posts = factory('App\\Category', 10)->create();
}
public function run()
{
$xls = 'database/seeds/seeder.xlsm';
$book = Excel::load($xls, 'UTF-8')->all();
foreach ($book as $sheet) {
if ($sheet->getTitle() === 'categories') {
Category::truncate();
foreach ($sheet as $row) {
$category = Category::create(['id' => $row->id, 'parent_id' => $row->parent_id, 'level' => $row->level, 'type' => $row->type, 'menutype' => $row->menutype, 'title' => $row->title, 'sef' => $row->sef, 'class' => $row->class, 'body' => $row->body, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc]);
}
}
if ($sheet->getTitle() === 'furnitura') {
Furnitura::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Furnitura::create(['id' => $row->id, 'category_id' => $row->category_id, 'cat2_id' => $row->cat2_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'artikul' => $row->artikul, 'otdelka' => $row->otdelka, 'pcs' => $row->pcs, 'description' => $row->description, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'links') {
Link::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Link::create(['category_id' => $row->category_id, 'title' => $row->title, 'url' => $row->url, 'description' => $row->description, 'version' => $row->version, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'news') {
News::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = News::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits, 'created_at' => $row->created_at]);
}
}
}
if ($sheet->getTitle() === 'steklo') {
Page::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Page::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'uslugi') {
Uslugi::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Uslugi::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'faq') {
Faq::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Faq::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
if ($sheet->getTitle() === 'objects') {
Object::truncate();
foreach ($sheet as $row) {
if (!empty($row->category_id)) {
$menu = Object::create(['category_id' => $row->category_id, 'title' => $row->title, 'sef' => $row->sef, 'introtext' => $row->introtext, 'fulltext' => $row->fulltext, 'image' => $row->image, 'metatitle' => $row->metatitle, 'metakey' => $row->metakey, 'metadesc' => $row->metadesc, 'hits' => $row->hits]);
}
}
}
}
}
