Beispiel #1
0
 /**
  * Переводим ФИО с русс. на укр.
  * @param Request $request
  * @return mixed
  */
 public function fio(Request $request)
 {
     $firstName = $request->get('firstName');
     $lastName = $request->get('lastName');
     $middleName = $request->get('middleName');
     return response()->json(Fio::translate($firstName, $lastName, $middleName));
 }
Beispiel #2
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $bar = $this->output->createProgressBar(Fio::count());
     Fio::chunk(2000, function ($rows) use($bar) {
         $bar->advance(2000);
         $firstNames = [];
         $lastNames = [];
         $middleNames = [];
         foreach ($rows as $row) {
             // рабиваем фио на составляющие
             $row['name'] = explode(' ', $row['name']);
             $row['nameRU'] = explode(' ', $row['nameRU']);
             if (count($row['name']) != 3 || count($row['nameRU']) != 3) {
                 continue;
             }
             $firstNames[] = ['nameUA' => $row['name'][1], 'nameRU' => $row['nameRU'][1]];
             $lastNames[] = ['nameUA' => $row['name'][0], 'nameRU' => $row['nameRU'][0]];
             $middleNames[] = ['nameUA' => $row['name'][2], 'nameRU' => $row['nameRU'][2]];
         }
         DB::insert("INSERT IGNORE INTO `first_names` (`nameUA`, `nameRU`) VALUES {$this->_implodeValues($firstNames)} ON DUPLICATE KEY UPDATE c=c+1");
         DB::insert("INSERT IGNORE INTO `last_names` (`nameUA`, `nameRU`) VALUES {$this->_implodeValues($lastNames)} ON DUPLICATE KEY UPDATE c=c+1");
         DB::insert("INSERT IGNORE INTO `middle_names` (`nameUA`, `nameRU`) VALUES {$this->_implodeValues($middleNames)} ON DUPLICATE KEY UPDATE c=c+1");
     });
 }
Beispiel #3
0
 /**
  * Проверяем ФИО работников на валидность
  * @return \Illuminate\Http\JsonResponse
  */
 public function checkNewWorkers()
 {
     $result = [];
     $workers = json_decode(Input::get('workers'), true);
     foreach (array_chunk($workers, 1000) as $chunk) {
         Fio::checkFIO($chunk, $result);
     }
     return response()->json($result);
 }