Beispiel #1
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $converter = new PersonalNameConverter();
     $string = $converter('Karl-Peter von Schmidt');
     dd($string);
     $loader = LoaderFactory::make($this->argument('loader'));
     $loader->setFile($this->argument('file'));
     // $loader->setOption('delimiter', ';');
     // $loader->setOption('header_row', 1);
     // $loader->setOption('headers', 'number');
     // $loader->setOption('strict', false);
     $loader->load();
     $reader = $loader->getReader();
     // $reader = var_export($reader, 1);
     // \File::put(base_path('config/components/loaders/csv.php'), $reader);
     // $reader = json_encode($reader, JSON_PRETTY_PRINT);
     // dd($reader);
     // if ($key = $this->argument('key')) {
     //     $reader = array_get($reader, $key);
     // }
     // $data = [];
     // foreach ($reader as $row) {
     //     $data[] = $row;
     // }
     // $this->table(array_keys(head($data)), $data);
     // return;
     // foreach ($loader->getReader() as $key => $row)
     // {
     //     echo $key; var_dump($row);
     //     echo '-----';
     // }
     // dd($loader);
 }
Beispiel #2
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $loader = LoaderFactory::make('csv');
     $loader->setFile('test/names.csv');
     $loader->load();
     $data = $loader->getData();
     $normalized = [];
     foreach ($data as $key => $row) {
         $normalized[$row['country']]['country'] = $row['country'];
         $normalized[$row['country']]['cities'][$row['city']]['city'] = $row['city'];
         $normalized[$row['country']]['cities'][$row['city']]['people'][$key] = array_only($row, ['first', 'last']);
     }
     $countries = [];
     $cities = [];
     $people = [];
     $idCountry = 1;
     $idCity = 1;
     $idPerson = 1;
     foreach ($normalized as $keyCountry => $valueCountry) {
         $countries[] = ['id' => $keyCountry + 1, 'country' => $valueCountry['country']];
         foreach ($valueCountry['cities'] as $keyCity => $valueCity) {
             $cities[] = ['id' => $idCity, 'city' => $valueCity['city'], 'country' => $idCountry];
             foreach ($valueCity['people'] as $keyPerson => $valuePerson) {
                 $people[] = ['id' => $idPerson, 'first' => $valuePerson['first'], 'last' => $valuePerson['last'], 'city' => $idCity];
                 $idPerson++;
             }
             $idCity++;
         }
         $idCountry++;
     }
     $writer = new CsvWriter(',');
     $writer->setStream(fopen(storage_path('test/norm_countries.csv'), 'w'));
     $writer->writeItem(array('id', 'country'));
     foreach ($countries as $key => $value) {
         $writer->writeItem($value);
     }
     $writer->finish();
     $writer = new CsvWriter(',');
     $writer->setStream(fopen(storage_path('test/norm_cities.csv'), 'w'));
     $writer->writeItem(array('id', 'city', 'country'));
     foreach ($cities as $key => $value) {
         $writer->writeItem($value);
     }
     $writer->finish();
     $writer = new CsvWriter(',');
     $writer->setStream(fopen(storage_path('test/norm_people.csv'), 'w'));
     $writer->writeItem(array('id', 'first', 'last', 'city'));
     foreach ($people as $key => $value) {
         $writer->writeItem($value);
     }
     $writer->finish();
     dd($normalized);
 }