1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* PWWEB\Localisation\Database\Seeders\Currency Seeder. |
5
|
|
|
* |
6
|
|
|
* Standard seeder for the Currency Model. |
7
|
|
|
* |
8
|
|
|
* @author Frank Pillukeit <[email protected]> |
9
|
|
|
* @copyright 2020 pw-websolutions.com |
10
|
|
|
* @license http://www.opensource.org/licenses/mit-license.html MIT License |
11
|
|
|
*/ |
12
|
|
|
|
13
|
|
|
namespace PWWEB\Localisation\Database\Seeders; |
14
|
|
|
|
15
|
|
|
use Illuminate\Database\Seeder; |
16
|
|
|
use Illuminate\Support\Facades\DB; |
17
|
|
|
|
18
|
|
|
class CurrencySeeder extends Seeder |
19
|
|
|
{ |
20
|
|
|
/** |
21
|
|
|
* Run the database seeds. |
22
|
|
|
* |
23
|
|
|
* @return void |
24
|
|
|
*/ |
25
|
|
|
public function run() |
26
|
|
|
{ |
27
|
|
|
// Initializing variables. |
28
|
|
|
$createdAt = date('Y-m-d H:i:s'); |
29
|
|
|
$currencies = []; |
30
|
|
|
|
31
|
|
|
// Definition of default currencies. |
32
|
|
|
$currencies[] = ['name' => 'Australian Dollar', 'iso' => 'AUD', 'numeric_code' => '036', 'active' => '1', 'entity_code' => 'A$', 'standard' => '0']; |
33
|
|
|
$currencies[] = ['name' => 'Bulgarian Lev', 'iso' => 'BGN', 'numeric_code' => '975', 'active' => '0', 'entity_code' => 'lev', 'standard' => '0']; |
34
|
|
|
$currencies[] = ['name' => 'Brazilian Real', 'iso' => 'BRL', 'numeric_code' => '986', 'active' => '0', 'entity_code' => 'R$', 'standard' => '0']; |
35
|
|
|
$currencies[] = ['name' => 'Canadian Dollar', 'iso' => 'CAD', 'numeric_code' => '124', 'active' => '0', 'entity_code' => 'C$', 'standard' => '0']; |
36
|
|
|
$currencies[] = ['name' => 'Swiss Franc', 'iso' => 'CHF', 'numeric_code' => '756', 'active' => '0', 'entity_code' => 'SFr', 'standard' => '0']; |
37
|
|
|
$currencies[] = ['name' => 'Yuan Renminbi', 'iso' => 'CNY', 'numeric_code' => '156', 'active' => '0', 'entity_code' => '¥', 'standard' => '0']; |
38
|
|
|
$currencies[] = ['name' => 'Czech Koruna', 'iso' => 'CZK', 'numeric_code' => '203', 'active' => '0', 'entity_code' => 'Kč', 'standard' => '0']; |
39
|
|
|
$currencies[] = ['name' => 'Danish Krone', 'iso' => 'DKK', 'numeric_code' => '208', 'active' => '0', 'entity_code' => 'kr', 'standard' => '0']; |
40
|
|
|
$currencies[] = ['name' => 'Euro', 'iso' => 'EUR', 'numeric_code' => '978', 'active' => '1', 'entity_code' => '€', 'standard' => '0']; |
41
|
|
|
$currencies[] = ['name' => 'Pound Sterling', 'iso' => 'GBP', 'numeric_code' => '826', 'active' => '1', 'entity_code' => '£', 'standard' => '1']; |
42
|
|
|
$currencies[] = ['name' => 'Hong Kong Dollar', 'iso' => 'HKD', 'numeric_code' => '344', 'active' => '0', 'entity_code' => 'HK$', 'standard' => '0']; |
43
|
|
|
$currencies[] = ['name' => 'Croatian Kuna', 'iso' => 'HRK', 'numeric_code' => '191', 'active' => '0', 'entity_code' => 'kuna', 'standard' => '0']; |
44
|
|
|
$currencies[] = ['name' => 'Forint', 'iso' => 'HUF', 'numeric_code' => '348', 'active' => '0', 'entity_code' => 'Ft', 'standard' => '0']; |
45
|
|
|
$currencies[] = ['name' => 'Rupiah', 'iso' => 'IDR', 'numeric_code' => '360', 'active' => '0', 'entity_code' => 'Rp', 'standard' => '0']; |
46
|
|
|
$currencies[] = ['name' => 'New Israeli Sheqel', 'iso' => 'ILS', 'numeric_code' => '376', 'active' => '0', 'entity_code' => '₪', 'standard' => '0']; |
47
|
|
|
$currencies[] = ['name' => 'Indian Rupee', 'iso' => 'INR', 'numeric_code' => '356', 'active' => '0', 'entity_code' => '₹', 'standard' => '0']; |
48
|
|
|
$currencies[] = ['name' => 'Yen', 'iso' => 'JPY', 'numeric_code' => '392', 'active' => '0', 'entity_code' => '¥', 'standard' => '0']; |
49
|
|
|
$currencies[] = ['name' => 'Won', 'iso' => 'KRW', 'numeric_code' => '410', 'active' => '0', 'entity_code' => '₩', 'standard' => '0']; |
50
|
|
|
$currencies[] = ['name' => 'Lithuanian Litas', 'iso' => 'LTL', 'numeric_code' => '440', 'active' => '0', 'entity_code' => 'Lt', 'standard' => '0']; |
51
|
|
|
$currencies[] = ['name' => 'Latvian Lats', 'iso' => 'LVL', 'numeric_code' => '428', 'active' => '0', 'entity_code' => 'Ls', 'standard' => '0']; |
52
|
|
|
$currencies[] = ['name' => 'Mexican Peso', 'iso' => 'MXN', 'numeric_code' => '484', 'active' => '0', 'entity_code' => 'Mex$', 'standard' => '0']; |
53
|
|
|
$currencies[] = ['name' => 'Malaysian Ringgit', 'iso' => 'MYR', 'numeric_code' => '458', 'active' => '0', 'entity_code' => 'RM', 'standard' => '0']; |
54
|
|
|
$currencies[] = ['name' => 'Norwegian Krone', 'iso' => 'NOK', 'numeric_code' => '578', 'active' => '0', 'entity_code' => 'kr', 'standard' => '0']; |
55
|
|
|
$currencies[] = ['name' => 'New Zealand Dollar', 'iso' => 'NZD', 'numeric_code' => '554', 'active' => '0', 'entity_code' => 'NZ$', 'standard' => '0']; |
56
|
|
|
$currencies[] = ['name' => 'Philippine Peso', 'iso' => 'PHP', 'numeric_code' => '608', 'active' => '0', 'entity_code' => '₱', 'standard' => '0']; |
57
|
|
|
$currencies[] = ['name' => 'Zloty', 'iso' => 'PLN', 'numeric_code' => '985', 'active' => '0', 'entity_code' => 'zł', 'standard' => '0']; |
58
|
|
|
$currencies[] = ['name' => 'Leu', 'iso' => 'RON', 'numeric_code' => '946', 'active' => '0', 'entity_code' => 'leu', 'standard' => '0']; |
59
|
|
|
$currencies[] = ['name' => 'Russian Ruble', 'iso' => 'RUB', 'numeric_code' => '643', 'active' => '0', 'entity_code' => 'PP', 'standard' => '0']; |
60
|
|
|
$currencies[] = ['name' => 'Swedish Krona', 'iso' => 'SEK', 'numeric_code' => '752', 'active' => '0', 'entity_code' => 'kr', 'standard' => '0']; |
61
|
|
|
$currencies[] = ['name' => 'Singapore Dollar', 'iso' => 'SGD', 'numeric_code' => '702', 'active' => '0', 'entity_code' => 'S$', 'standard' => '0']; |
62
|
|
|
$currencies[] = ['name' => 'Baht', 'iso' => 'THB', 'numeric_code' => '764', 'active' => '0', 'entity_code' => '฿', 'standard' => '0']; |
63
|
|
|
$currencies[] = ['name' => 'Turkish Lira', 'iso' => 'TRY', 'numeric_code' => '949', 'active' => '0', 'entity_code' => 'TL', 'standard' => '0']; |
64
|
|
|
$currencies[] = ['name' => 'US Dollar', 'iso' => 'USD', 'numeric_code' => '840', 'active' => '1', 'entity_code' => '$', 'standard' => '0']; |
65
|
|
|
$currencies[] = ['name' => 'Rand', 'iso' => 'ZAR', 'numeric_code' => '710', 'active' => '0', 'entity_code' => 'R', 'standard' => '0']; |
66
|
|
|
|
67
|
|
|
foreach ($currencies as $id => $currency) { |
68
|
|
|
$currencies[$id] = array_merge($currency, ['created_at' => $createdAt, 'updated_at' => $createdAt]); |
69
|
|
|
} |
70
|
|
|
|
71
|
|
|
$tableNames = config('pwweb.localisation.table_names'); |
72
|
|
|
|
73
|
|
|
DB::table($tableNames['currencies'])->insert($currencies); |
74
|
|
|
} |
75
|
|
|
} |
76
|
|
|
|