Exemplo n.º 1
0
 /**
  * 
  */
 public function postImportToTable(Request $req, $db, $file_id)
 {
     // dd($file_id);
     $db = $this->mod($db);
     $response['msg'] = '';
     $response['code'] = 200;
     $date = date('Y-m-d h:i:s');
     if ($req->get('data')) {
         $tanda_ok_for_log_import = 'ok';
         $jumlah_baris = 0;
         $jumlah_kolom = 0;
         foreach ($req->get('data') as $value) {
             $value['fileentries_id'] = '';
             $value['files_id'] = $file_id;
             // dd($value);
             $row = json_encode($value);
             $jumlah_kolom = count($row);
             if (!$db->create($value)) {
                 $tanda_ok_for_log_import = 'err';
                 $response['msg'] .= "Data ini {$row} Error <br>";
                 return json_encode($response);
             } else {
                 $tanda_ok_for_log_import = 'ok';
                 $response['msg'] .= "Data ini {$row}  OK <br>";
             }
             $jumlah_baris++;
         }
         if ($tanda_ok_for_log_import == 'ok') {
             $data_import['files_id'] = $file_id;
             $data_import['status_import'] = 'OK';
             $data_import['jumlah_baris'] = $jumlah_baris;
             $data_import['jumlah_kolom'] = $jumlah_kolom;
             $data_import['users_id'] = \Sentry::getUser()->id;
             Import::create($data_import);
         }
         return json_encode($response);
     }
     $response['code'] = 404;
     $response['msg'] = "Gagal Import File !!!";
     return json_encode($response);
 }