|
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
|
|
|
|