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