$filename = $file['file']->getClientOriginalName(); $isbns = ExcelWorker::getISBNSFromExcelDocument($file, $path, $filename); $database = new DBConnection($app); $isbnsNotFound = $database->findISBN13NotInDatabase($isbns); $apiArray = $database->findAllApis(); $count = 0; foreach ($apiArray as $api) { if (!is_null($isbnsNotFound)) { $apiInfo = $database->findApiInfoFromName($api); $apiClass = new $apiInfo[Constants::API_CLASSNAME](['api_key' => $apiInfo[Constants::API_KEY]]); $apiClass->find($isbnsNotFound, $app); } $count++; } $filename = trim($filename, ".xlsx") . time() . ".xlsx"; $database->saveFile($filename, $isbns); return new JsonResponse(Util::getUploaderReturnMessage($filename)); } else { return new JsonResponse(json_encode(['response' => 'File is invalid!', 'errors' => Util::getFormErrorMessages($upload)])); } } catch (Exception $e) { return new JsonResponse($e->getMessage()); } })->bind('upload'); /** * Download Excel Function */ $app->post('/download', function (Request $request) use($app) { try { ini_set('max_execution_time', 100000); $database = new DBConnection($app);