ValidateLoadArchivesController.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654
  1. <?php
  2. namespace App\Http\Controllers;
  3. use Illuminate\Http\Request;
  4. use Illuminate\Support\Facades\Validator;
  5. use Illuminate\Support\Facades\Log;
  6. use Illuminate\Support\Facades\DB;
  7. use PhpOffice\PhpSpreadsheet\IOFactory;
  8. use ZipArchive;
  9. /**
  10. * Controller for validating Excel and ZIP files for equipment documentation loading
  11. * Validates Excel headers structure and compares file listings with ZIP contents
  12. */
  13. class ValidateLoadArchivesController extends Controller
  14. {
  15. private $responseController;
  16. private $encryptionController;
  17. private $documentManagementController;
  18. // Expected headers in row 7 of Excel file with their corresponding column letters
  19. private $expectedHeaders = [
  20. ['letter' => 'D', 'category' => 'CÓDIGO DE EQUIPO'],
  21. ['letter' => 'H', 'category' => 'FICHA DE SEGURIDAD DE PRODUCTOS QUÍMICOS'],
  22. ['letter' => 'J', 'category' => 'FICHA TÉCNICA'],
  23. ['letter' => 'L', 'category' => 'FOTOGRAFÍAS - DIAGRAMAS'],
  24. ['letter' => 'N', 'category' => 'DATOS DEL PROVEEDOR'],
  25. ['letter' => 'P', 'category' => 'MANUALES DE OPERACIÓN'],
  26. ['letter' => 'R', 'category' => 'MANUALES DE MANTENIMIENTO PREVENTIVO'],
  27. ['letter' => 'T', 'category' => 'MANUALES DE MANTENIMIENTO CORRECTIVO'],
  28. ['letter' => 'V', 'category' => 'DOCUMENTOS ADICIONALES']
  29. ];
  30. // Mapping of file extensions to their types for validation
  31. private $extensionTypes = [
  32. // Archivos de almacenamiento
  33. 'zip' => 'STORAGE', 'rar' => 'STORAGE', 'tar' => 'STORAGE', '7z' => 'STORAGE',
  34. // Formatos de audio
  35. 'mp3' => 'AUDIO', 'mpeg' => 'AUDIO', 'wav' => 'AUDIO', 'ogg' => 'AUDIO', 'opus' => 'AUDIO',
  36. // Archivos de imagen
  37. 'jpeg' => 'IMG', 'jpg' => 'IMG', 'png' => 'IMG', 'gif' => 'IMG', 'bmp' => 'IMG', 'tiff' => 'IMG', 'svg' => 'IMG',
  38. // Archivos de texto
  39. 'txt' => 'TEXT',
  40. // Archivos de video
  41. 'webm' => 'VIDEO', 'mpeg4' => 'VIDEO', 'mp4' => 'VIDEO', '3gpp' => 'VIDEO', 'mov' => 'VIDEO', 'avi' => 'VIDEO', 'wmv' => 'VIDEO', 'flv' => 'VIDEO',
  42. // Planos de Auto CAD
  43. 'dwg' => 'CAD', 'dxf' => 'CAD',
  44. // Modelos de 3D Studio
  45. '3ds' => '3D',
  46. // Dibujos de Illustrator
  47. 'ai' => 'ILLUSTRATOR',
  48. // Imágenes de Photoshop
  49. 'psd' => 'PHOTOSHOP',
  50. // Formato de documento portátil
  51. 'pdf' => 'PDF',
  52. // Hoja de cálculo en Excel
  53. 'xls' => 'EXCEL', 'xlsx' => 'EXCEL',
  54. // Presentaciones de PowerPoint
  55. 'ppt' => 'POWERPOINT', 'pptx' => 'POWERPOINT',
  56. // Documentos de texto de Word
  57. 'doc' => 'WORD', 'docx' => 'WORD',
  58. // Dibujos de Visio
  59. 'vsd' => 'VISIO', 'vsdx' => 'VISIO'
  60. ];
  61. // File size limits in MB by extension
  62. private $fileSizeLimits = [
  63. // 50MB limit
  64. 'pdf' => 50, 'doc' => 50, 'docx' => 50, 'vsd' => 50, 'vsdx' => 50,
  65. // 75MB limit
  66. 'xls' => 75, 'xlsx' => 75,
  67. // 100MB limit
  68. 'ppt' => 100, 'pptx' => 100,
  69. // 250MB limit (default for all others)
  70. 'zip' => 250, 'rar' => 250, 'tar' => 250, '7z' => 250,
  71. 'mp3' => 250, 'mpeg' => 250, 'wav' => 250, 'ogg' => 250, 'opus' => 250,
  72. 'jpeg' => 250, 'jpg' => 250, 'png' => 250, 'gif' => 250, 'bmp' => 250, 'tiff' => 250, 'svg' => 250,
  73. 'txt' => 250, 'webm' => 250, 'mpeg4' => 250, 'mp4' => 250, '3gpp' => 250, 'mov' => 250, 'avi' => 250, 'wmv' => 250, 'flv' => 250,
  74. 'dwg' => 250, 'dxf' => 250, '3ds' => 250, 'ai' => 250, 'psd' => 250
  75. ];
  76. public function __construct()
  77. {
  78. $this->responseController = new ResponseController();
  79. $this->encryptionController = new EncryptionController();
  80. $this->documentManagementController = new DocumentManagementController();
  81. }
  82. /**
  83. * Main validation endpoint that validates both Excel and ZIP files
  84. * Checks Excel headers, ZIP integrity, file listings, and compares them
  85. */
  86. public function validateFiles(Request $request)
  87. {
  88. Log::info('=== INICIANDO VALIDACIÓN DE ARCHIVOS ===');
  89. // Validate request inputs
  90. Log::info('Paso 1: Validando tipos de archivo');
  91. $validator = Validator::make($request->all(), [
  92. 'id_user' => 'required|string',
  93. 'linea' => 'required|integer',
  94. 'excel_file' => 'required|file|mimes:xlsx,xls',
  95. 'zip_file' => 'required|file|mimes:zip'
  96. ]);
  97. if ($validator->fails()) {
  98. Log::error('Error en validación de tipos de archivo', $validator->errors()->toArray());
  99. return $this->responseController->makeResponse(
  100. true,
  101. 'Se encontraron uno o más errores.',
  102. $this->responseController->makeErrors($validator->errors()->messages()),
  103. 400
  104. );
  105. }
  106. Log::info('✓ Tipos de archivo válidos');
  107. // Validate Excel file headers structure
  108. Log::info('Paso 2: Validando encabezados de Excel');
  109. $excelValidation = $this->validateExcelHeaders($request->file('excel_file'));
  110. if ($excelValidation['error']) {
  111. Log::error('Error en encabezados Excel: ' . $excelValidation['message']);
  112. return $this->responseController->makeResponse(true, $excelValidation['message'], [], 400);
  113. }
  114. Log::info('✓ Encabezados de Excel válidos');
  115. // Extract and validate file listings from Excel
  116. Log::info('Paso 3: Extrayendo listado de archivos del Excel');
  117. $filesValidation = $this->extractAndValidateFiles($request->file('excel_file'));
  118. if ($filesValidation['error']) {
  119. Log::error('Error extrayendo archivos Excel: ' . $filesValidation['message']);
  120. return $this->responseController->makeResponse(true, $filesValidation['message'], [], 400);
  121. }
  122. Log::info('✓ Archivos extraídos: ' . count($filesValidation['files']) . ' archivos encontrados');
  123. // Validate ZIP file integrity
  124. Log::info('Paso 4: Validando integridad del archivo ZIP');
  125. $zipValidation = $this->validateZipFile($request->file('zip_file'));
  126. if ($zipValidation['error']) {
  127. Log::error('Error validando ZIP: ' . $zipValidation['message']);
  128. return $this->responseController->makeResponse(true, $zipValidation['message'], [], 400);
  129. }
  130. Log::info('✓ Archivo ZIP válido');
  131. // Compare Excel file listings with ZIP contents
  132. Log::info('Paso 5: Comparando listados Excel vs ZIP y validando tamaños');
  133. $comparison = $this->compareExcelWithZip($filesValidation['files'], $request->file('zip_file'));
  134. // Check for file size validation errors
  135. if (isset($comparison['error'])) {
  136. Log::error('Error en validación de tamaños: ' . $comparison['error']);
  137. return $this->responseController->makeResponse(true, $comparison['error'], [], 400);
  138. }
  139. Log::info('✓ Comparación completada', [
  140. 'valid' => $comparison['valid'],
  141. 'missing_in_zip' => count($comparison['missing_in_zip'] ?? []),
  142. 'extra_in_zip' => count($comparison['extra_in_zip'] ?? [])
  143. ]);
  144. // Upload temp files if validation is successful
  145. if ($comparison['valid']) {
  146. Log::info('Paso 6: Subiendo archivos temporales');
  147. $tempFiles = $this->uploadTempFiles($request);
  148. if ($tempFiles['error']) {
  149. Log::error('Error subiendo archivos temporales: ' . $tempFiles['message']);
  150. return $this->responseController->makeResponse(true, $tempFiles['message'], [], 400);
  151. }
  152. Log::info('✓ Archivos temporales subidos');
  153. // Extract and save individual files as temp
  154. Log::info('Paso 7: Extrayendo y guardando archivos individuales como temporales');
  155. $individualTempFiles = $this->extractAndSaveIndividualFilesAsTemp($request->file('zip_file'), $request->input('linea'), "0000000001");
  156. if ($individualTempFiles === false) {
  157. return $this->responseController->makeResponse(true, 'Error procesando archivos individuales', [], 400);
  158. }
  159. Log::info('✓ Archivos individuales guardados como temporales: ' . count($individualTempFiles));
  160. $comparison['temp_files'] = $tempFiles['files'];
  161. $comparison['individual_temp_files'] = $individualTempFiles;
  162. }
  163. Log::info('=== VALIDACIÓN COMPLETADA EXITOSAMENTE ===');
  164. return $this->responseController->makeResponse(false, 'Validación completada.', $comparison);
  165. }
  166. /**
  167. * Validates that Excel file has the correct headers in row 7
  168. * Each column must match the expected category name exactly
  169. */
  170. private function validateExcelHeaders($file)
  171. {
  172. try {
  173. Log::info(' - Cargando archivo Excel: ' . $file->getClientOriginalName());
  174. $spreadsheet = IOFactory::load($file->getPathname());
  175. $worksheet = $spreadsheet->getActiveSheet();
  176. Log::info(' - Excel cargado, validando encabezados en fila 7');
  177. // Check each expected header in row 7
  178. foreach ($this->expectedHeaders as $header) {
  179. $cellValue = $worksheet->getCell($header['letter'] . '7')->getValue();
  180. if (trim($cellValue) !== $header['category']) {
  181. return [
  182. 'error' => true,
  183. 'message' => "El encabezado en la columna {$header['letter']} no coincide. Se esperaba: '{$header['category']}', se encontró: '{$cellValue}'"
  184. ];
  185. }
  186. }
  187. return ['error' => false];
  188. } catch (\Exception $e) {
  189. return ['error' => true, 'message' => 'Error al procesar el archivo Excel: ' . $e->getMessage()];
  190. }
  191. }
  192. /**
  193. * Validates ZIP file integrity and ensures it's not empty
  194. */
  195. private function validateZipFile($file)
  196. {
  197. Log::info(' - Abriendo archivo ZIP: ' . $file->getClientOriginalName());
  198. $zip = new ZipArchive();
  199. $result = $zip->open($file->getPathname());
  200. if ($result !== TRUE) {
  201. return ['error' => true, 'message' => 'No se pudo abrir el archivo ZIP.'];
  202. }
  203. if ($zip->numFiles === 0) {
  204. $zip->close();
  205. return ['error' => true, 'message' => 'El archivo ZIP está vacío.'];
  206. }
  207. Log::info(' - ZIP contiene ' . $zip->numFiles . ' archivos');
  208. $zip->close();
  209. return ['error' => false];
  210. }
  211. /**
  212. * Extracts file listings from Excel starting from row 8
  213. * Validates file extensions and creates structured file list
  214. * Only processes rows with equipment code (column D)
  215. */
  216. private function extractAndValidateFiles($file)
  217. {
  218. try {
  219. $spreadsheet = IOFactory::load($file->getPathname());
  220. $worksheet = $spreadsheet->getActiveSheet();
  221. $highestRow = $worksheet->getHighestRow();
  222. Log::info(' - Procesando ' . ($highestRow - 7) . ' filas de datos (filas 8-' . $highestRow . ')');
  223. $files = [];
  224. // Process each row starting from row 8 (data rows)
  225. for ($row = 8; $row <= $highestRow; $row++) {
  226. $equipmentCode = trim($worksheet->getCell('D' . $row)->getValue());
  227. if (empty($equipmentCode)) continue; // Skip rows without equipment code
  228. $hasFiles = false;
  229. $rowFiles = [];
  230. // Check each file category column (excluding equipment code column D)
  231. foreach ($this->expectedHeaders as $header) {
  232. if ($header['letter'] === 'D') continue;
  233. $cellValue = trim($worksheet->getCell($header['letter'] . $row)->getValue());
  234. if (empty($cellValue)) continue;
  235. // Handle multiple files separated by commas
  236. $fileNames = explode(',', $cellValue);
  237. foreach ($fileNames as $fileName) {
  238. $fileName = trim($fileName);
  239. if (empty($fileName)) continue;
  240. // Validate file extension
  241. $extension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
  242. if (!isset($this->extensionTypes[$extension])) {
  243. return [
  244. 'error' => true,
  245. 'message' => "Extensión inválida '{$extension}' en archivo '{$fileName}' para equipo '{$equipmentCode}'"
  246. ];
  247. }
  248. $rowFiles[] = [
  249. 'equipment_code' => $equipmentCode,
  250. 'category' => $header['category'],
  251. 'file_name' => $fileName,
  252. 'type' => $this->extensionTypes[$extension]
  253. ];
  254. $hasFiles = true;
  255. }
  256. }
  257. if ($hasFiles) {
  258. $files = array_merge($files, $rowFiles);
  259. }
  260. }
  261. return ['error' => false, 'files' => $files];
  262. } catch (\Exception $e) {
  263. return ['error' => true, 'message' => 'Error al extraer archivos del Excel: ' . $e->getMessage()];
  264. }
  265. }
  266. /**
  267. * Compares file listings from Excel with actual files in ZIP
  268. * Returns validation status and lists of missing/extra files
  269. */
  270. private function compareExcelWithZip($excelFiles, $zipFile)
  271. {
  272. $zip = new ZipArchive();
  273. $zip->open($zipFile->getPathname());
  274. // Extract all file names and sizes from ZIP
  275. Log::info(' - Extrayendo nombres de archivos del ZIP');
  276. $zipFiles = [];
  277. $zipFileSizes = [];
  278. for ($i = 0; $i < $zip->numFiles; $i++) {
  279. $fullPath = $zip->getNameIndex($i);
  280. // Skip directories (entries ending with /)
  281. if (substr($fullPath, -1) === '/') {
  282. continue;
  283. }
  284. // Extract filename and size
  285. $fileName = basename($fullPath);
  286. if (!empty($fileName)) {
  287. $zipFiles[] = $fileName;
  288. $zipFileSizes[$fileName] = $zip->statIndex($i)['size'];
  289. }
  290. }
  291. $zip->close();
  292. Log::info(' - ZIP contiene ' . count($zipFiles) . ' archivos (excluyendo directorios)');
  293. // Validate file sizes
  294. Log::info(' - Validando tamaños de archivos');
  295. foreach ($zipFileSizes as $fileName => $size) {
  296. $extension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
  297. if (isset($this->fileSizeLimits[$extension])) {
  298. $limitMB = $this->fileSizeLimits[$extension];
  299. $limitBytes = $limitMB * 1024 * 1024;
  300. if ($size > $limitBytes) {
  301. $sizeMB = round($size / (1024 * 1024), 2);
  302. return [
  303. 'valid' => false,
  304. 'error' => "El archivo '{$fileName}' excede el límite de tamaño. Tamaño: {$sizeMB}MB, Límite: {$limitMB}MB"
  305. ];
  306. }
  307. }
  308. }
  309. // Get file names from Excel listings
  310. $excelFileNames = array_column($excelFiles, 'file_name');
  311. Log::info(' - Excel lista ' . count($excelFileNames) . ' archivos');
  312. // Find discrepancies between Excel and ZIP
  313. $missingInZip = array_diff($excelFileNames, $zipFiles);
  314. $extraInZip = array_diff($zipFiles, $excelFileNames);
  315. Log::info(' - Archivos faltantes en ZIP: ' . count($missingInZip));
  316. Log::info(' - Archivos extra en ZIP: ' . count($extraInZip));
  317. return [
  318. 'valid' => empty($missingInZip) && empty($extraInZip),
  319. 'missing_in_zip' => array_values($missingInZip),
  320. 'extra_in_zip' => array_values($extraInZip)
  321. ];
  322. }
  323. /**
  324. * Uploads Excel and ZIP files as temporary files using DocumentManagementController
  325. */
  326. private function uploadTempFiles(Request $request)
  327. {
  328. try {
  329. $tempFiles = [];
  330. // Upload Excel file
  331. $excelRequest = new Request();
  332. $excelRequest->files->set('file', $request->file('excel_file'));
  333. $excelRequest->merge([
  334. 'id_user' => $request->input('id_user'),
  335. 'linea' => $request->input('linea')
  336. ]);
  337. $excelResponse = $this->documentManagementController->uploadTempFile($excelRequest);
  338. $excelData = json_decode($excelResponse->getContent());
  339. Log::info('Excel upload response:', ['data' => $excelData]);
  340. if ($excelData->error) {
  341. $errorMsg = isset($excelData->message) ? $excelData->message : 'Error desconocido subiendo Excel';
  342. return ['error' => true, 'message' => 'Error subiendo Excel: ' . $errorMsg];
  343. }
  344. $tempFiles['excel'] = $excelData->response->idArchivo;
  345. // Upload ZIP file
  346. $zipRequest = new Request();
  347. $zipRequest->files->set('file', $request->file('zip_file'));
  348. $zipRequest->merge([
  349. 'id_user' => $request->input('id_user'),
  350. 'linea' => $request->input('linea')
  351. ]);
  352. $zipResponse = $this->documentManagementController->uploadTempFile($zipRequest);
  353. $zipData = json_decode($zipResponse->getContent());
  354. Log::info('ZIP upload response:', ['data' => $zipData]);
  355. if ($zipData->error) {
  356. $errorMsg = isset($zipData->message) ? $zipData->message : 'Error desconocido subiendo ZIP';
  357. return ['error' => true, 'message' => 'Error subiendo ZIP: ' . $errorMsg];
  358. }
  359. $tempFiles['zip'] = $zipData->response->idArchivo;
  360. return ['error' => false, 'files' => $tempFiles];
  361. } catch (\Exception $e) {
  362. return ['error' => true, 'message' => 'Error en uploadTempFiles: ' . $e->getMessage()];
  363. }
  364. }
  365. /**
  366. * Process endpoint that moves temp files to final storage
  367. */
  368. public function processLoadArchives(Request $request)
  369. {
  370. Log::info('=== INICIANDO PROCESAMIENTO DE ARCHIVOS ===');
  371. $validator = Validator::make($request->all(), [
  372. 'id_user' => 'required|string',
  373. 'linea' => 'required|integer',
  374. 'temp_files' => 'required|array',
  375. 'temp_files.excel' => 'required|string',
  376. 'temp_files.zip' => 'required|string',
  377. 'individual_temp_files' => 'required|array'
  378. ]);
  379. if ($validator->fails()) {
  380. return $this->responseController->makeResponse(
  381. true,
  382. 'Se encontraron uno o más errores.',
  383. $this->responseController->makeErrors($validator->errors()->messages()),
  384. 400
  385. );
  386. }
  387. $form = $request->all();
  388. // $idUser = $this->encryptionController->decrypt($form['id_user']);
  389. $idUser = "0000000001";
  390. if (!$idUser) {
  391. return $this->responseController->makeResponse(true, 'ID de usuario inválido.', [], 400);
  392. }
  393. $finalFiles = [];
  394. try {
  395. // Move Excel to final
  396. Log::info('Moviendo Excel a almacenamiento final');
  397. $excelFinal = $this->moveToFinal($form['temp_files']['excel'], $form['linea'], $idUser);
  398. if (!$excelFinal) {
  399. return $this->responseController->makeResponse(true, 'Error procesando Excel', [], 400);
  400. }
  401. $finalFiles['excel'] = $excelFinal;
  402. // Move ZIP to final
  403. Log::info('Moviendo ZIP a almacenamiento final');
  404. $zipFinal = $this->moveToFinal($form['temp_files']['zip'], $form['linea'], $idUser);
  405. if (!$zipFinal) {
  406. return $this->responseController->makeResponse(true, 'Error procesando ZIP', [], 400);
  407. }
  408. $finalFiles['zip'] = $zipFinal;
  409. // Move individual temp files to final storage
  410. Log::info('Moviendo archivos individuales de temporal a final');
  411. $individualFiles = [];
  412. foreach ($form['individual_temp_files'] as $tempFile) {
  413. $finalFileId = $this->moveToFinal($tempFile['temp_id'], $form['linea'], $idUser);
  414. if ($finalFileId) {
  415. $individualFiles[] = [
  416. 'original_name' => $tempFile['original_name'],
  417. 'final_id' => $finalFileId
  418. ];
  419. }
  420. }
  421. $finalFiles['individual_files'] = $individualFiles;
  422. Log::info('Archivos individuales procesados: ' . count($individualFiles));
  423. Log::info('=== PROCESAMIENTO COMPLETADO EXITOSAMENTE ===');
  424. return $this->responseController->makeResponse(false, 'Archivos procesados exitosamente.', $finalFiles);
  425. } catch (\Exception $e) {
  426. Log::error('Error en procesamiento: ' . $e->getMessage());
  427. return $this->responseController->makeResponse(true, 'Error interno: ' . $e->getMessage(), [], 500);
  428. }
  429. }
  430. /**
  431. * Moves a temporary file to final storage using DocumentManagementController
  432. */
  433. private function moveToFinal($tempId, $line, $idUser)
  434. {
  435. try {
  436. $tempIdDec = $this->encryptionController->decrypt($tempId);
  437. if (!$tempIdDec) {
  438. return false;
  439. }
  440. $tempFile = DB::table('S002V01TARTE')->where('ARTE_IDAR', $tempIdDec)->first();
  441. if (!$tempFile) {
  442. return false;
  443. }
  444. $result = $this->documentManagementController->moveFinalFile($line, 'GDEL', 'CA', $tempFile, $idUser);
  445. return $result[0] ? $result[1] : false;
  446. } catch (\Exception $e) {
  447. Log::error('Error en moveToFinal: ' . $e->getMessage());
  448. return false;
  449. }
  450. }
  451. /**
  452. * Extracts individual files from ZIP and saves them as temporary files
  453. */
  454. private function extractAndSaveIndividualFilesAsTemp($zipFile, $line, $idUser)
  455. {
  456. try {
  457. $zip = new ZipArchive();
  458. if ($zip->open($zipFile->getPathname()) !== TRUE) {
  459. Log::error('Cannot open ZIP file');
  460. return false;
  461. }
  462. $tempFiles = [];
  463. $tempDir = storage_path('app/tempFiles/extracted_' . time());
  464. mkdir($tempDir, 0755, true);
  465. for ($i = 0; $i < $zip->numFiles; $i++) {
  466. $fullPath = $zip->getNameIndex($i);
  467. // Skip directories
  468. if (substr($fullPath, -1) === '/') {
  469. continue;
  470. }
  471. $fileName = basename($fullPath);
  472. if (empty($fileName)) continue;
  473. // Extract file to temp directory
  474. if ($zip->extractTo($tempDir, $fullPath)) {
  475. $finalExtractPath = $tempDir . '/' . $fileName;
  476. if (file_exists($tempDir . '/' . $fullPath)) {
  477. rename($tempDir . '/' . $fullPath, $finalExtractPath);
  478. }
  479. if (file_exists($finalExtractPath)) {
  480. // Upload as temp file
  481. $tempFileId = $this->uploadExtractedFileAsTemp($finalExtractPath, $fileName, $line, $idUser);
  482. if ($tempFileId) {
  483. $tempFiles[] = [
  484. 'original_name' => $fileName,
  485. 'temp_id' => $tempFileId
  486. ];
  487. }
  488. unlink($finalExtractPath);
  489. }
  490. }
  491. }
  492. $zip->close();
  493. //$this->removeDirectory($tempDir);
  494. return $tempFiles;
  495. } catch (\Exception $e) {
  496. Log::error('Error en extractAndSaveIndividualFilesAsTemp: ' . $e->getMessage());
  497. return false;
  498. }
  499. }
  500. /**
  501. * Uploads an extracted file as temporary file
  502. */
  503. private function uploadExtractedFileAsTemp($filePath, $fileName, $line, $idUser)
  504. {
  505. try {
  506. $extension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
  507. $mimeType = $this->getMimeType($extension);
  508. // Create a temporary uploaded file object
  509. $tempFile = new \Illuminate\Http\UploadedFile(
  510. $filePath,
  511. $fileName,
  512. $mimeType,
  513. null,
  514. true
  515. );
  516. $request = new Request();
  517. $request->files->set('file', $tempFile);
  518. $request->merge([
  519. 'id_user' => $this->encryptionController->encrypt($idUser),
  520. 'linea' => $line
  521. ]);
  522. $response = $this->documentManagementController->uploadTempFile($request);
  523. $data = json_decode($response->getContent());
  524. return $data->error ? false : $data->response->idArchivo;
  525. } catch (\Exception $e) {
  526. Log::error('Error en uploadExtractedFileAsTemp: ' . $e->getMessage());
  527. return false;
  528. }
  529. }
  530. /**
  531. * Gets MIME type for file extension
  532. */
  533. private function getMimeType($extension)
  534. {
  535. $mimeTypes = [
  536. 'pdf' => 'application/pdf',
  537. 'doc' => 'application/msword',
  538. 'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
  539. 'xls' => 'application/vnd.ms-excel',
  540. 'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
  541. 'ppt' => 'application/vnd.ms-powerpoint',
  542. 'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
  543. 'jpg' => 'image/jpeg', 'jpeg' => 'image/jpeg',
  544. 'png' => 'image/png', 'gif' => 'image/gif', 'bmp' => 'image/bmp',
  545. 'txt' => 'text/plain', 'dwg' => 'application/acad', 'dxf' => 'application/dxf'
  546. ];
  547. return $mimeTypes[$extension] ?? 'application/octet-stream';
  548. }
  549. /**
  550. * Recursively removes a directory and its contents
  551. */
  552. private function removeDirectory($dir)
  553. {
  554. if (!is_dir($dir)) return;
  555. $files = array_diff(scandir($dir), ['.', '..']);
  556. foreach ($files as $file) {
  557. $path = $dir . '/' . $file;
  558. is_dir($path) ? $this->removeDirectory($path) : unlink($path);
  559. }
  560. rmdir($dir);
  561. }
  562. }