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. // Extract and save individual files as temp
  153. Log::info('Paso 7: Extrayendo y guardando archivos individuales como temporales');
  154. $individualTempFiles = $this->extractAndSaveIndividualFilesAsTemp($request->file('zip_file'), $request->input('linea'), "0000000001");
  155. if ($individualTempFiles === false) {
  156. return $this->responseController->makeResponse(true, 'Error procesando archivos individuales', [], 400);
  157. }
  158. Log::info('✓ Archivos individuales guardados como temporales: ' . count($individualTempFiles));
  159. $comparison['temp_files'] = $tempFiles['files'];
  160. $comparison['individual_temp_files'] = $individualTempFiles;
  161. }
  162. Log::info('=== VALIDACIÓN COMPLETADA EXITOSAMENTE ===');
  163. return $this->responseController->makeResponse(false, 'Validación completada.', $comparison);
  164. }
  165. /**
  166. * Validates that Excel file has the correct headers in row 7
  167. * Each column must match the expected category name exactly
  168. */
  169. private function validateExcelHeaders($file)
  170. {
  171. try {
  172. Log::info(' - Cargando archivo Excel: ' . $file->getClientOriginalName());
  173. $spreadsheet = IOFactory::load($file->getPathname());
  174. $worksheet = $spreadsheet->getActiveSheet();
  175. Log::info(' - Excel cargado, validando encabezados en fila 7');
  176. // Check each expected header in row 7
  177. foreach ($this->expectedHeaders as $header) {
  178. $cellValue = $worksheet->getCell($header['letter'] . '7')->getValue();
  179. if (trim($cellValue) !== $header['category']) {
  180. return [
  181. 'error' => true,
  182. 'message' => "El encabezado en la columna {$header['letter']} no coincide. Se esperaba: '{$header['category']}', se encontró: '{$cellValue}'"
  183. ];
  184. }
  185. }
  186. return ['error' => false];
  187. } catch (\Exception $e) {
  188. return ['error' => true, 'message' => 'Error al procesar el archivo Excel: ' . $e->getMessage()];
  189. }
  190. }
  191. /**
  192. * Validates ZIP file integrity and ensures it's not empty
  193. */
  194. private function validateZipFile($file)
  195. {
  196. Log::info(' - Abriendo archivo ZIP: ' . $file->getClientOriginalName());
  197. $zip = new ZipArchive();
  198. $result = $zip->open($file->getPathname());
  199. if ($result !== TRUE) {
  200. return ['error' => true, 'message' => 'No se pudo abrir el archivo ZIP.'];
  201. }
  202. if ($zip->numFiles === 0) {
  203. $zip->close();
  204. return ['error' => true, 'message' => 'El archivo ZIP está vacío.'];
  205. }
  206. Log::info(' - ZIP contiene ' . $zip->numFiles . ' archivos');
  207. $zip->close();
  208. return ['error' => false];
  209. }
  210. /**
  211. * Extracts file listings from Excel starting from row 8
  212. * Validates file extensions and creates structured file list
  213. * Only processes rows with equipment code (column D)
  214. */
  215. private function extractAndValidateFiles($file)
  216. {
  217. try {
  218. $spreadsheet = IOFactory::load($file->getPathname());
  219. $worksheet = $spreadsheet->getActiveSheet();
  220. $highestRow = $worksheet->getHighestRow();
  221. Log::info(' - Procesando ' . ($highestRow - 7) . ' filas de datos (filas 8-' . $highestRow . ')');
  222. $files = [];
  223. // Process each row starting from row 8 (data rows)
  224. for ($row = 8; $row <= $highestRow; $row++) {
  225. $equipmentCode = trim($worksheet->getCell('D' . $row)->getValue());
  226. if (empty($equipmentCode)) continue; // Skip rows without equipment code
  227. $hasFiles = false;
  228. $rowFiles = [];
  229. // Check each file category column (excluding equipment code column D)
  230. foreach ($this->expectedHeaders as $header) {
  231. if ($header['letter'] === 'D') continue;
  232. $cellValue = trim($worksheet->getCell($header['letter'] . $row)->getValue());
  233. if (empty($cellValue)) continue;
  234. // Handle multiple files separated by commas
  235. $fileNames = explode(',', $cellValue);
  236. foreach ($fileNames as $fileName) {
  237. $fileName = trim($fileName);
  238. if (empty($fileName)) continue;
  239. // Validate file extension
  240. $extension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
  241. if (!isset($this->extensionTypes[$extension])) {
  242. return [
  243. 'error' => true,
  244. 'message' => "Extensión inválida '{$extension}' en archivo '{$fileName}' para equipo '{$equipmentCode}'"
  245. ];
  246. }
  247. $rowFiles[] = [
  248. 'equipment_code' => $equipmentCode,
  249. 'category' => $header['category'],
  250. 'file_name' => $fileName,
  251. 'type' => $this->extensionTypes[$extension]
  252. ];
  253. $hasFiles = true;
  254. }
  255. }
  256. if ($hasFiles) {
  257. $files = array_merge($files, $rowFiles);
  258. }
  259. }
  260. return ['error' => false, 'files' => $files];
  261. } catch (\Exception $e) {
  262. return ['error' => true, 'message' => 'Error al extraer archivos del Excel: ' . $e->getMessage()];
  263. }
  264. }
  265. /**
  266. * Compares file listings from Excel with actual files in ZIP
  267. * Returns validation status and lists of missing/extra files
  268. */
  269. private function compareExcelWithZip($excelFiles, $zipFile)
  270. {
  271. $zip = new ZipArchive();
  272. $zip->open($zipFile->getPathname());
  273. // Extract all file names and sizes from ZIP
  274. Log::info(' - Extrayendo nombres de archivos del ZIP');
  275. $zipFiles = [];
  276. $zipFileSizes = [];
  277. for ($i = 0; $i < $zip->numFiles; $i++) {
  278. $fullPath = $zip->getNameIndex($i);
  279. // Skip directories (entries ending with /)
  280. if (substr($fullPath, -1) === '/') {
  281. continue;
  282. }
  283. // Extract filename and size
  284. $fileName = basename($fullPath);
  285. if (!empty($fileName)) {
  286. $zipFiles[] = $fileName;
  287. $zipFileSizes[$fileName] = $zip->statIndex($i)['size'];
  288. }
  289. }
  290. $zip->close();
  291. Log::info(' - ZIP contiene ' . count($zipFiles) . ' archivos (excluyendo directorios)');
  292. // Validate file sizes
  293. Log::info(' - Validando tamaños de archivos');
  294. foreach ($zipFileSizes as $fileName => $size) {
  295. $extension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
  296. if (isset($this->fileSizeLimits[$extension])) {
  297. $limitMB = $this->fileSizeLimits[$extension];
  298. $limitBytes = $limitMB * 1024 * 1024;
  299. if ($size > $limitBytes) {
  300. $sizeMB = round($size / (1024 * 1024), 2);
  301. return [
  302. 'valid' => false,
  303. 'error' => "El archivo '{$fileName}' excede el límite de tamaño. Tamaño: {$sizeMB}MB, Límite: {$limitMB}MB"
  304. ];
  305. }
  306. }
  307. }
  308. // Get file names from Excel listings
  309. $excelFileNames = array_column($excelFiles, 'file_name');
  310. Log::info(' - Excel lista ' . count($excelFileNames) . ' archivos');
  311. // Find discrepancies between Excel and ZIP
  312. $missingInZip = array_diff($excelFileNames, $zipFiles);
  313. $extraInZip = array_diff($zipFiles, $excelFileNames);
  314. Log::info(' - Archivos faltantes en ZIP: ' . count($missingInZip));
  315. Log::info(' - Archivos extra en ZIP: ' . count($extraInZip));
  316. return [
  317. 'valid' => empty($missingInZip) && empty($extraInZip),
  318. 'missing_in_zip' => array_values($missingInZip),
  319. 'extra_in_zip' => array_values($extraInZip)
  320. ];
  321. }
  322. /**
  323. * Uploads Excel and ZIP files as temporary files using DocumentManagementController
  324. */
  325. private function uploadTempFiles(Request $request)
  326. {
  327. try {
  328. $tempFiles = [];
  329. // Upload Excel file
  330. $excelRequest = new Request();
  331. $excelRequest->files->set('file', $request->file('excel_file'));
  332. $excelRequest->merge([
  333. 'id_user' => $request->input('id_user'),
  334. 'linea' => $request->input('linea')
  335. ]);
  336. $excelResponse = $this->documentManagementController->uploadTempFile($excelRequest);
  337. $excelData = json_decode($excelResponse->getContent());
  338. Log::info('Excel upload response:', ['data' => $excelData]);
  339. if ($excelData->error) {
  340. $errorMsg = isset($excelData->message) ? $excelData->message : 'Error desconocido subiendo Excel';
  341. return ['error' => true, 'message' => 'Error subiendo Excel: ' . $errorMsg];
  342. }
  343. $tempFiles['excel'] = $excelData->response->idArchivo;
  344. // Upload ZIP file
  345. $zipRequest = new Request();
  346. $zipRequest->files->set('file', $request->file('zip_file'));
  347. $zipRequest->merge([
  348. 'id_user' => $request->input('id_user'),
  349. 'linea' => $request->input('linea')
  350. ]);
  351. $zipResponse = $this->documentManagementController->uploadTempFile($zipRequest);
  352. $zipData = json_decode($zipResponse->getContent());
  353. Log::info('ZIP upload response:', ['data' => $zipData]);
  354. if ($zipData->error) {
  355. $errorMsg = isset($zipData->message) ? $zipData->message : 'Error desconocido subiendo ZIP';
  356. return ['error' => true, 'message' => 'Error subiendo ZIP: ' . $errorMsg];
  357. }
  358. $tempFiles['zip'] = $zipData->response->idArchivo;
  359. return ['error' => false, 'files' => $tempFiles];
  360. } catch (\Exception $e) {
  361. return ['error' => true, 'message' => 'Error en uploadTempFiles: ' . $e->getMessage()];
  362. }
  363. }
  364. /**
  365. * Process endpoint that moves temp files to final storage
  366. */
  367. public function processLoadArchives(Request $request)
  368. {
  369. Log::info('=== INICIANDO PROCESAMIENTO DE ARCHIVOS ===');
  370. $validator = Validator::make($request->all(), [
  371. 'id_user' => 'required|string',
  372. 'linea' => 'required|integer',
  373. 'temp_files' => 'required|array',
  374. 'temp_files.excel' => 'required|string',
  375. 'temp_files.zip' => 'required|string',
  376. 'individual_temp_files' => 'required|array'
  377. ]);
  378. if ($validator->fails()) {
  379. return $this->responseController->makeResponse(
  380. true,
  381. 'Se encontraron uno o más errores.',
  382. $this->responseController->makeErrors($validator->errors()->messages()),
  383. 400
  384. );
  385. }
  386. $form = $request->all();
  387. // $idUser = $this->encryptionController->decrypt($form['id_user']);
  388. $idUser = "0000000001";
  389. if (!$idUser) {
  390. return $this->responseController->makeResponse(true, 'ID de usuario inválido.', [], 400);
  391. }
  392. $finalFiles = [];
  393. try {
  394. // Move Excel to final
  395. Log::info('Moviendo Excel a almacenamiento final');
  396. $excelFinal = $this->moveToFinal($form['temp_files']['excel'], $form['linea'], $idUser);
  397. if (!$excelFinal) {
  398. return $this->responseController->makeResponse(true, 'Error procesando Excel', [], 400);
  399. }
  400. $finalFiles['excel'] = $excelFinal;
  401. // Move ZIP to final
  402. Log::info('Moviendo ZIP a almacenamiento final');
  403. $zipFinal = $this->moveToFinal($form['temp_files']['zip'], $form['linea'], $idUser);
  404. if (!$zipFinal) {
  405. return $this->responseController->makeResponse(true, 'Error procesando ZIP', [], 400);
  406. }
  407. $finalFiles['zip'] = $zipFinal;
  408. // Move individual temp files to final storage
  409. Log::info('Moviendo archivos individuales de temporal a final');
  410. $individualFiles = [];
  411. foreach ($form['individual_temp_files'] as $tempFile) {
  412. $finalFileId = $this->moveToFinal($tempFile['temp_id'], $form['linea'], $idUser);
  413. if ($finalFileId) {
  414. $individualFiles[] = [
  415. 'original_name' => $tempFile['original_name'],
  416. 'final_id' => $finalFileId
  417. ];
  418. }
  419. }
  420. $finalFiles['individual_files'] = $individualFiles;
  421. Log::info('Archivos individuales procesados: ' . count($individualFiles));
  422. Log::info('=== PROCESAMIENTO COMPLETADO EXITOSAMENTE ===');
  423. return $this->responseController->makeResponse(false, 'Archivos procesados exitosamente.', $finalFiles);
  424. } catch (\Exception $e) {
  425. Log::error('Error en procesamiento: ' . $e->getMessage());
  426. return $this->responseController->makeResponse(true, 'Error interno: ' . $e->getMessage(), [], 500);
  427. }
  428. }
  429. /**
  430. * Moves a temporary file to final storage using DocumentManagementController
  431. */
  432. private function moveToFinal($tempId, $line, $idUser)
  433. {
  434. try {
  435. $tempIdDec = $this->encryptionController->decrypt($tempId);
  436. if (!$tempIdDec) {
  437. return false;
  438. }
  439. $tempFile = DB::table('S002V01TARTE')->where('ARTE_IDAR', $tempIdDec)->first();
  440. if (!$tempFile) {
  441. return false;
  442. }
  443. $result = $this->documentManagementController->moveFinalFile($line, 'GDEL', 'CA', $tempFile, $idUser);
  444. return $result[0] ? $result[1] : false;
  445. } catch (\Exception $e) {
  446. Log::error('Error en moveToFinal: ' . $e->getMessage());
  447. return false;
  448. }
  449. }
  450. /**
  451. * Extracts individual files from ZIP and saves them as temporary files
  452. */
  453. private function extractAndSaveIndividualFilesAsTemp($zipFile, $line, $idUser)
  454. {
  455. try {
  456. $zip = new ZipArchive();
  457. if ($zip->open($zipFile->getPathname()) !== TRUE) {
  458. Log::error('Cannot open ZIP file');
  459. return false;
  460. }
  461. $tempFiles = [];
  462. $tempDir = storage_path('app/tempFiles/extracted_' . time());
  463. mkdir($tempDir, 0755, true);
  464. for ($i = 0; $i < $zip->numFiles; $i++) {
  465. $fullPath = $zip->getNameIndex($i);
  466. // Skip directories
  467. if (substr($fullPath, -1) === '/') {
  468. continue;
  469. }
  470. $fileName = basename($fullPath);
  471. if (empty($fileName)) continue;
  472. // Extract file to temp directory
  473. if ($zip->extractTo($tempDir, $fullPath)) {
  474. $finalExtractPath = $tempDir . '/' . $fileName;
  475. if (file_exists($tempDir . '/' . $fullPath)) {
  476. rename($tempDir . '/' . $fullPath, $finalExtractPath);
  477. }
  478. if (file_exists($finalExtractPath)) {
  479. // Upload as temp file
  480. $tempFileId = $this->uploadExtractedFileAsTemp($finalExtractPath, $fileName, $line, $idUser);
  481. if ($tempFileId) {
  482. $tempFiles[] = [
  483. 'original_name' => $fileName,
  484. 'temp_id' => $tempFileId
  485. ];
  486. }
  487. unlink($finalExtractPath);
  488. }
  489. }
  490. }
  491. $zip->close();
  492. //$this->removeDirectory($tempDir);
  493. return $tempFiles;
  494. } catch (\Exception $e) {
  495. Log::error('Error en extractAndSaveIndividualFilesAsTemp: ' . $e->getMessage());
  496. return false;
  497. }
  498. }
  499. /**
  500. * Uploads an extracted file as temporary file
  501. */
  502. private function uploadExtractedFileAsTemp($filePath, $fileName, $line, $idUser)
  503. {
  504. try {
  505. $extension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
  506. $mimeType = $this->getMimeType($extension);
  507. // Create a temporary uploaded file object
  508. $tempFile = new \Illuminate\Http\UploadedFile(
  509. $filePath,
  510. $fileName,
  511. $mimeType,
  512. null,
  513. true
  514. );
  515. $request = new Request();
  516. $request->files->set('file', $tempFile);
  517. $request->merge([
  518. 'id_user' => $this->encryptionController->encrypt($idUser),
  519. 'linea' => $line
  520. ]);
  521. $response = $this->documentManagementController->uploadTempFile($request);
  522. $data = json_decode($response->getContent());
  523. return $data->error ? false : $data->response->idArchivo;
  524. } catch (\Exception $e) {
  525. Log::error('Error en uploadExtractedFileAsTemp: ' . $e->getMessage());
  526. return false;
  527. }
  528. }
  529. /**
  530. * Gets MIME type for file extension
  531. */
  532. private function getMimeType($extension)
  533. {
  534. $mimeTypes = [
  535. 'pdf' => 'application/pdf',
  536. 'doc' => 'application/msword',
  537. 'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
  538. 'xls' => 'application/vnd.ms-excel',
  539. 'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
  540. 'ppt' => 'application/vnd.ms-powerpoint',
  541. 'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
  542. 'jpg' => 'image/jpeg', 'jpeg' => 'image/jpeg',
  543. 'png' => 'image/png', 'gif' => 'image/gif', 'bmp' => 'image/bmp',
  544. 'txt' => 'text/plain', 'dwg' => 'application/acad', 'dxf' => 'application/dxf'
  545. ];
  546. return $mimeTypes[$extension] ?? 'application/octet-stream';
  547. }
  548. /**
  549. * Recursively removes a directory and its contents
  550. */
  551. private function removeDirectory($dir)
  552. {
  553. if (!is_dir($dir)) return;
  554. $files = array_diff(scandir($dir), ['.', '..']);
  555. foreach ($files as $file) {
  556. $path = $dir . '/' . $file;
  557. is_dir($path) ? $this->removeDirectory($path) : unlink($path);
  558. }
  559. rmdir($dir);
  560. }
  561. }