gitea/api-extranetwork
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
dev
api-extranetwork/database/seeds/FirstRunSeeder.php
ExtraNetwork e5c4b6aa13 first commit
2026-05-12 17:04:54 +03:00

776 lines
25 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
use Illuminate\Database\Seeder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Str;
class FirstRunSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// USER DATA
DB::table('user')->insertGetId(
[
'id' => 1,
'gender' => 'M',
'name' => 'Test',
'surname' => 'User -1-',
'email' => 'test1@rezervasyon.com',
'password' => Hash::make('123456'),
"hash_key" => hash('sha512', Str::random(32) ),
'phone' => '02123668989',
'user_type' => 1,
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('user')->insertGetId(
[
'id' => 2,
'gender' => 'M',
'name' => 'Test',
'surname' => 'User -2-',
'email' => 'test2@rezervasyon.com',
'password' => Hash::make('1234567'),
"hash_key" => hash('sha512', Str::random(32) ),
'phone' => '02123668989',
'user_type' => 0,
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('user')->insertGetId(
[
'id' => 3,
'gender' => 'M',
'name' => 'Test',
'surname' => 'User -3-',
'email' => 'test3@rezervasyon.com',
'password' => Hash::make('123456'),
"hash_key" => hash('sha512', Str::random(32) ),
'phone' => '02123668989',
'user_type' => 0,
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// LANGUAGE DATA
DB::table('language')->insertGetId(
[
'id' => 7,
'code' => 'en',
'name' => 'English',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('language')->insertGetId(
[
'id' => 10,
'code' => 'de',
'name' => 'German',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('language')->insertGetId(
[
'id' => 22,
'code' => 'tr',
'name' => 'Turkish',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// CURRENCY DATA
DB::table('currency')->insertGetId(
[
'id' => 1,
'code' => 'TRY',
'name' => 'Turkish Lira',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('currency')->insertGetId(
[
'id' => 2,
'code' => 'USD',
'name' => 'US Dollar',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('currency')->insertGetId(
[
'id' => 3,
'code' => 'EUR',
'name' => 'Euro',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// CURRENCY LOCALE DATA
DB::table('currency_locale')->insertGetId(
[
'id' => 1,
'currency_code' => 'TRY',
'name' => 'Turkish Lira',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('currency_locale')->insertGetId(
[
'id' => 2,
'currency_code' => 'USD',
'name' => 'US Dollar',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('currency_locale')->insertGetId(
[
'id' => 3,
'currency_code' => 'EUR',
'name' => 'Euro',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// PROPERTY DATA
DB::table('property')->insertGetId(
[
'id' => 1,
'name' => 'Test Hotel -1-',
'destination_id' => 1,
'rating' => 1,
'currency_type' => 'EUR',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// PROPERTY MAPPING DATA
DB::table('user_property_mapping')->insertGetId(
[
'id' => 1,
'user_id' => 1,
'property_id' => 1,
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// PROPERTY CONTENT CATEGORY
DB::table('property_content_category')->insertGetId(
[
'id' => 1,
'name' => 'Location',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category')->insertGetId(
[
'id' => 2,
'name' => 'Facilities',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category')->insertGetId(
[
'id' => 3,
'name' => 'Rooms',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category')->insertGetId(
[
'id' => 4,
'name' => 'Sports/Entertainment',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category')->insertGetId(
[
'id' => 5,
'name' => 'Meals',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category')->insertGetId(
[
'id' => 6,
'name' => 'Payment',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
// PROPERTY CONTENT CATEGORY LOCALE
DB::table('property_content_category_locale')->insertGetId(
[
'id' => 1,
'content_category_id' => 1,
'name' => 'Location',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category_locale')->insertGetId(
[
'id' => 2,
'content_category_id' => 2,
'name' => 'Facilities',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category_locale')->insertGetId(
[
'id' => 3,
'content_category_id' => 3,
'name' => 'Rooms',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category_locale')->insertGetId(
[
'id' => 4,
'content_category_id' => 4,
'name' => 'Sports/Entertainment',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_content_category_locale')->insertGetId(
[
'id' => 5,
'content_category_id' => 5,
'name' => 'Meals',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 1,
'category_name' => "General",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 2,
'category_name' => "View of exterior",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 3,
'category_name' => "Bar",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 4,
'category_name' => "Sport/ leisure",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 5,
'category_name' => "Conference facilities",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 6,
'category_name' => "Lobby",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 7,
'category_name' => "Pool",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 8,
'category_name' => "Restaurant",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 9,
'category_name' => "Beach",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 10,
'category_name' => "Terrace",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category')->insertGetId(
[
'id' => 11,
'category_name' => "Accommodation",
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 1,
'property_photo_category_id' => 1,
'category_name' => 'Genel',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 2,
'property_photo_category_id' => 2,
'category_name' => 'dış görünüm',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 3,
'property_photo_category_id' => 3,
'category_name' => 'bar',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 4,
'property_photo_category_id' => 4,
'category_name' => 'Spor/eğlence',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 5,
'property_photo_category_id' => 5,
'category_name' => 'Konferans salonu',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 6,
'property_photo_category_id' => 6,
'category_name' => 'Lobi',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 7,
'property_photo_category_id' => 7,
'category_name' => 'Havuz',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 8,
'property_photo_category_id' => 8,
'category_name' => 'Restoran',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 9,
'property_photo_category_id' => 9,
'category_name' => 'Kumsal',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 10,
'property_photo_category_id' => 10,
'category_name' => 'Teras',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 11,
'property_photo_category_id' => 11,
'category_name' => 'Konaklama',
'locale' => 'tr',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 12,
'property_photo_category_id' => 1,
'category_name' => 'General',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 13,
'property_photo_category_id' => 2,
'category_name' => 'View of exterior',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 14,
'property_photo_category_id' => 3,
'category_name' => 'Bar',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 15,
'property_photo_category_id' => 4,
'category_name' => 'Sport/leisure',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 16,
'property_photo_category_id' => 5,
'category_name' => 'Conference facilities',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 17,
'property_photo_category_id' => 6,
'category_name' => 'Lobby',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 18,
'property_photo_category_id' => 7,
'category_name' => 'Pool',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 19,
'property_photo_category_id' => 8,
'category_name' => 'Restaurant',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 20,
'property_photo_category_id' => 9,
'category_name' => 'Beach',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 21,
'property_photo_category_id' => 10,
'category_name' => 'Terrace',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
DB::table('property_photo_category_locale')->insertGetId(
[
'id' => 22,
'property_photo_category_id' => 11,
'category_name' => 'Accommodation',
'locale' => 'en',
'status' => 1,
'created_by' => 1,
'updated_by' => 1,
'created_at' => time(),
'updated_at' => time(),
]
);
}
}
Reference in New Issue View Git Blame Copy Permalink