Warning: fopen(./LogosArochi/MAR-130925.png): failed to open stream: Permission denied in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 188 [Mon Jul 21 12:54:25.708672 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP Stack trace: [Mon Jul 21 12:54:25.708676 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708680 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP 2. fopen() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:188 [Mon Jul 21 12:54:25.708686 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 189 [Mon Jul 21 12:54:25.708690 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP Stack trace: [Mon Jul 21 12:54:25.708693 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708696 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP 2. fwrite() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:189 [Mon Jul 21 12:54:25.708701 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 190 [Mon Jul 21 12:54:25.708704 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP Stack trace: [Mon Jul 21 12:54:25.708707 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708710 2025] [php7:notice] [pid 2890624] [client 136.143.177.44:52298] PHP 2. fclose() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:190 [Mon Jul 21 12:54:25.708711 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP Warning: fopen(./LogosArochi/MAR-130923.png): failed to open stream: Permission denied in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 188 [Mon Jul 21 12:54:25.708720 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP Stack trace: [Mon Jul 21 12:54:25.708719 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP Warning: fopen(./LogosArochi/MAR-130925.png): failed to open stream: Permission denied in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 188 [Mon Jul 21 12:54:25.708724 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708727 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP Stack trace: [Mon Jul 21 12:54:25.708729 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP 2. fopen() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:188 [Mon Jul 21 12:54:25.708731 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708735 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP 2. fopen() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:188 [Mon Jul 21 12:54:25.708735 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 189 [Mon Jul 21 12:54:25.708739 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP Stack trace: [Mon Jul 21 12:54:25.708741 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 189 [Mon Jul 21 12:54:25.708742 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708744 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP Stack trace: [Mon Jul 21 12:54:25.708755 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708754 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP 2. fwrite() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:189 [Mon Jul 21 12:54:25.708758 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP 2. fwrite() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:189 [Mon Jul 21 12:54:25.708762 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 190 [Mon Jul 21 12:54:25.708764 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 190 [Mon Jul 21 12:54:25.708765 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP Stack trace: [Mon Jul 21 12:54:25.708767 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP Stack trace: [Mon Jul 21 12:54:25.708769 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708770 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708773 2025] [php7:notice] [pid 2885037] [client 136.143.176.60:32878] PHP 2. fclose() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:190 [Mon Jul 21 12:54:25.708774 2025] [php7:notice] [pid 2890659] [client 136.143.176.44:40186] PHP 2. fclose() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:190 [Mon Jul 21 12:54:25.708787 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP Warning: fopen(./LogosArochi/MAR-130925.png): failed to open stream: Permission denied in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 188 [Mon Jul 21 12:54:25.708799 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP Stack trace: [Mon Jul 21 12:54:25.708804 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708809 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP 2. fopen() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:188 [Mon Jul 21 12:54:25.708815 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 189 [Mon Jul 21 12:54:25.708818 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP Stack trace: [Mon Jul 21 12:54:25.708821 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708824 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP 2. fwrite() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:189 [Mon Jul 21 12:54:25.708829 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 190 [Mon Jul 21 12:54:25.708832 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP Stack trace: [Mon Jul 21 12:54:25.708835 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708838 2025] [php7:notice] [pid 2889415] [client 136.143.177.61:53128] PHP 2. fclose() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:190 [Mon Jul 21 12:54:25.708912 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP Warning: fopen(./LogosArochi/MAR-130925.png): failed to open stream: Permission denied in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 188 [Mon Jul 21 12:54:25.708921 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP Stack trace: [Mon Jul 21 12:54:25.708925 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708929 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP 2. fopen() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:188 [Mon Jul 21 12:54:25.708935 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 189 [Mon Jul 21 12:54:25.708938 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP Stack trace: [Mon Jul 21 12:54:25.708942 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708945 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP 2. fwrite() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:189 [Mon Jul 21 12:54:25.708950 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 190 [Mon Jul 21 12:54:25.708953 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP Stack trace: [Mon Jul 21 12:54:25.708956 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.708960 2025] [php7:notice] [pid 2890108] [client 136.143.176.60:44114] PHP 2. fclose() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:190 [Mon Jul 21 12:54:25.709152 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP Warning: fopen(./LogosArochi/MAR-130925.png): failed to open stream: Permission denied in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 188 [Mon Jul 21 12:54:25.709160 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP Stack trace: [Mon Jul 21 12:54:25.709165 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.709168 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP 2. fopen() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:188 [Mon Jul 21 12:54:25.709174 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 189 [Mon Jul 21 12:54:25.709177 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP Stack trace: [Mon Jul 21 12:54:25.709180 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.709184 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP 2. fwrite() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:189 [Mon Jul 21 12:54:25.709188 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php on line 190 [Mon Jul 21 12:54:25.709191 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP Stack trace: [Mon Jul 21 12:54:25.709194 2025] [php7:notice] [pid 2891128] [client 136.143.177.43:48100] PHP 1. {main}() /var/www/html/imagenesAptusLegal/arochi/wsImageSave_v3.php:0 [Mon Jul 21 12:54:25.709197 2 "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Anio de vigencia."); $Resultado = json_encode($j_array); return; } if($mesCata == "") { $j_array = array('code' => "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Mes de vigencia."); $Resultado = json_encode($j_array); return; } if($tipoEnvio == "") { $j_array = array('code' => "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Tipo de Envio."); $Resultado = json_encode($j_array); return; } if($csvFileName == "") { $j_array = array('code' => "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Nombre del Archivo CSV a procesar."); $Resultado = json_encode($j_array); return $Resultado; } if($organi_id_ZB == "") { $j_array = array('code' => "306", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Organization ID de Books"); $Resultado = json_encode($j_array); return $Resultado; } $dirBase = realpath("../"); ### DEFINICIÓN DE CONSTANTES ################################################### $SendaCVS = "archs_csv/"; $SendaXML = "archs_xml/"; $SendaZIP = "archs_zip/"; #---------------------------------------------------------------- # Creamos la conexión a la base de datos #---------------------------------------------------------------- $conn = mysqli_connect("127.0.0.1", "aptuslegal", "#Aptus2021#", "vendorbills"); if (!$conn) { echo "Error: No se pudo conectar a MySQL." . PHP_EOL; echo "errno de depuración: " . mysqli_connect_errno() . PHP_EOL; exit; } #---------------------------------------------------------------- # Traemos los valores de conexión utilizando el organizationId #---------------------------------------------------------------- $sql = 'SELECT * FROM conndetails WHERE organization_id = ' . $organi_id_ZB; if($result = $conn->query($sql)) { $row = $result->fetch_assoc(); } else { exit('No se ejecuto la consulta'); } #---------------------------------------------------------------- # Cerramos la conexión #---------------------------------------------------------------- mysqli_close($conn); #---------------------------------------------------------------- # Variables para Zoho Workdrive #---------------------------------------------------------------- $wdrv_parent_id = $row['zworkdrvbalcom_id']; $woa_RefreshToken = $row['zworkdrv_rtoken']; $woa_ClientId = $row['zworkdrvclient_id']; $woa_ClientSecret = $row['zworkdrvclient_secret']; $woa_RedirectUri = $row['RedirectUri']; $woa_AuthUrl = 'https://accounts.zoho.com/oauth/v2/token'; $woa_GrantType = "refresh_token"; #---------------------------------------------------------------- # RFC de la Organización #---------------------------------------------------------------- $regFeCa = $row['rfc']; #== Creación de la variable de tipo DOM, aquí se conforma el XML a timbrar posteriormente. $xml = new DOMdocument('1.0', 'UTF-8'); $root = $xml->createElement("BCE:Balanza"); $root = $xml->appendChild($root); $fileName = $SendaCVS.$csvFileName; $csvToJson = csvToJson($fileName); $arrayJson = json_decode($csvToJson, true); // Función para limpiar números (igual que en tu versión) function limpiarNumero($valor) { if ($valor === null || $valor === '' || trim($valor) === '') return 0.00; if (is_numeric($valor)) return floatval($valor); $clean = str_replace([',', '$', ' '], '', $valor); return floatval($clean) ?: 0.00; } // Inicializamos las estructuras de datos $sumasMayores = []; // Para almacenar los totales de las cuentas mayores $arrayDetalle = []; $valoresOriginales = []; // Nuevo: Almacena todos los valores originales $totalCargos = 0.00; $totalAbonos = 0.00; $Account1count = 0; // PRIMERA PASADA: Recopilar datos originales y calcular sumas foreach($arrayJson as $item => $value) { $accountCode = trim($value['account_code']); if (empty($accountCode)) continue; // Procesar valores manteniendo precisión $saldoIni = limpiarNumero($value['opening_balance']); $debe = limpiarNumero($value['debit_total']); $haber = limpiarNumero($value['credit_total']); $saldoFin = limpiarNumero($value['closing_balance']); // Guardar valores originales (para todas las cuentas) $valoresOriginales[$accountCode] = [ 'SaldoIni' => $saldoIni, 'Debe' => $debe, 'Haber' => $haber, 'SaldoFin' => $saldoFin, 'ClaveSat' => $value['account.CF.Codigo del SAT'] ?? '' ]; // Sumar totales generales $totalCargos += $debe; $totalAbonos += $haber; // Procesar solo cuentas numéricas con Clave SAT $codCue = substr($accountCode, 0, 3); if(is_numeric($codCue) && !empty($value['account.CF.Codigo del SAT'])) { $Account1count += 1; // Si NO es cuenta mayor, sumar a su cuenta mayor correspondiente if (!preg_match('/-00-000$/', $accountCode)) { $prefijo = strtok($accountCode, '-'); $cuentaMayor = $prefijo . '-00-000'; if (!isset($sumasMayores[$cuentaMayor])) { $sumasMayores[$cuentaMayor] = [ 'SaldoIni' => 0.00, 'Debe' => 0.00, 'Haber' => 0.00, 'SaldoFin' => 0.00 ]; } // Sumar a la cuenta mayor (igual que tu versión) $sumasMayores[$cuentaMayor]['SaldoIni'] += $saldoIni; $sumasMayores[$cuentaMayor]['Debe'] += $debe; $sumasMayores[$cuentaMayor]['Haber'] += $haber; $sumasMayores[$cuentaMayor]['SaldoFin'] += $saldoFin; } } } // SEGUNDA PASADA: Construir arrayDetalle conservando valores originales foreach ($valoresOriginales as $accountCode => $datos) { $codCue = substr($accountCode, 0, 3); if (is_numeric($codCue) && !empty($datos['ClaveSat'])) { // Para CUENTAS MAYORES: Usar las sumas calculadas if (preg_match('/-00-000$/', $accountCode) && isset($sumasMayores[$accountCode])) { $arrayDetalle[] = [ "ClaveSat" => $datos['ClaveSat'], "NumCta" => $accountCode, "SaldoIni" => number_format($sumasMayores[$accountCode]['SaldoIni'], 2, '.', ''), "Debe" => number_format($sumasMayores[$accountCode]['Debe'], 2, '.', ''), "Haber" => number_format($sumasMayores[$accountCode]['Haber'], 2, '.', ''), "SaldoFin" => number_format($sumasMayores[$accountCode]['SaldoFin'], 2, '.', '') ]; } // Para SUBCUENTAS: Mantener valores ORIGINALES sin cambios else { $arrayDetalle[] = [ "ClaveSat" => $datos['ClaveSat'], "NumCta" => $accountCode, "SaldoIni" => number_format($datos['SaldoIni'], 2, '.', ''), "Debe" => number_format($datos['Debe'], 2, '.', ''), "Haber" => number_format($datos['Haber'], 2, '.', ''), "SaldoFin" => number_format($datos['SaldoFin'], 2, '.', '') ]; } } } #== Se crea e inserta el primer nodo donde se declaran los namespaces ====== cargaAttNodo($root, array( "Version"=>"1.3", "RFC"=>$regFeCa, "Mes"=>$mesCata, "Anio"=>$anioCat, "TipoEnvio"=>$tipoEnvio, "xsi:schemaLocation"=>"http://www.sat.gob.mx/esquemas/ContabilidadE/1_3/BalanzaComprobacion http://www.sat.gob.mx/esquemas/ContabilidadE/1_3/BalanzaComprobacion/BalanzaComprobacion_1_3.xsd", "xmlns:xsi"=>"http://www.w3.org/2001/XMLSchema-instance", "xmlns:BCE"=>"http://www.sat.gob.mx/esquemas/ContabilidadE/1_3/BalanzaComprobacion") ); $arrayToCSV = Array(); $arrayToCSV[] = array('NumCta','SaldoIni', 'Debe', 'Haber', 'SaldoFin', 'ClaveSat'); foreach($arrayDetalle as $item => $value) { if($value['ClaveSat'] != "") { $codCue = substr($value['NumCta'],0,3); if(is_numeric($codCue)) { $cuentas = $xml->createElement("BCE:Ctas"); $cuenta = $root->appendChild($cuentas); cargaAttNodo($cuenta, array( "SaldoFin"=>$value['SaldoFin'], "Haber"=>$value['Haber'], "Debe"=>$value['Debe'], "SaldoIni"=>$value['SaldoIni'], "NumCta"=>$value['NumCta'] ) ); // Creamos el array para el archivo CSV $arrayToCSV[] = array($value['NumCta'],$value['SaldoIni'], $value['Debe'], $value['Haber'], $value['SaldoFin'], $value['ClaveSat']); } } } #=== Se guarda el archivo .XML de la Balanza de Comprobación ======================= $xmlFilesPath = 'archs_xml/'; $csvFilesPath = 'archs_csv/'; $zipFilesPath = 'archs_zip/'; if($tipoEnvio == "N") { $file_name_with_full_path = $xmlFilesPath.$regFeCa.$anioCat.$mesCata."BN.xml"; $file_name_csv_full_path = $csvFilesPath.$regFeCa.$anioCat.$mesCata."BN.csv"; } else { $file_name_with_full_path = $xmlFilesPath.$regFeCa.$anioCat.$mesCata."BC.xml"; $file_name_csv_full_path = $csvFilesPath.$regFeCa.$anioCat.$mesCata."BC.csv"; } #=== Si existe el archivo CSV se elimina para crear el nuevo ======================= if(file_exists($file_name_csv_full_path)){ unlink($file_name_csv_full_path); } $fp = fopen($file_name_csv_full_path, 'w'); foreach ($arrayToCSV as $fields) { fputcsv($fp, $fields); } fclose($fp); #=== Si existe el archivo XML se elimina para crear el nuevo ======================= if(file_exists($file_name_with_full_path)){ unlink($file_name_with_full_path); } #=== Se guarda el archivo XML creado ======================= $cfdi = $xml->saveXML(); $xml->formatOutput = true; $xml->save($file_name_with_full_path); unset($xml); #=== Se dan permisos de escritura al archivo .xml. ========================= if($tipoEnvio == "N") { chmod($SendaXML.$regFeCa.$anioCat.$mesCata."BN.xml", 0777); } else { chmod($SendaXML.$regFeCa.$anioCat.$mesCata."BC.xml", 0777); } #=== Se procede a crear el archivo ZIP del Catalogo de Cuentas ========================= $zip = new ZipArchive(); $zipFilesPath = 'archs_zip/'; if($tipoEnvio == "N") { $nombreArchivoZip = $zipFilesPath.$regFeCa.$anioCat.$mesCata."BN.zip"; $nameArchZip = $regFeCa.$anioCat.$mesCata."BN.zip"; } else { $nombreArchivoZip = $zipFilesPath.$regFeCa.$anioCat.$mesCata."BC.zip"; $nameArchZip = $regFeCa.$anioCat.$mesCata."BC.zip"; } #=== Si existe el archivo ZIP se elimina para crear el nuevo ======================= if(file_exists($nombreArchivoZip)){ unlink($nombreArchivoZip); } if (!$zip->open($nombreArchivoZip, ZipArchive::CREATE | ZipArchive::OVERWRITE)) { exit("Error abriendo ZIP en $nombreArchivoZip"); } $nombre = basename($file_name_with_full_path); $zip->addFile($file_name_with_full_path, $nombre); $resultado = $zip->close(); if (!$resultado) { exit("Error creando archivo ZIP"); } #=== FIN DEL PROCESO ======================= $resultData = array( 'xmlFilesPath' => $xmlFilesPath, 'xmlFileName' => $regFeCa.$anioCat.$mesCata."BN.xml", 'csvFilesPath' => $csvFilesPath, 'csvFileName' => $regFeCa.$anioCat.$mesCata."BN.csv", 'zipFilesPath' => $zipFilesPath, 'zipFileName' => $regFeCa.$anioCat.$mesCata."BN.zip", 'totalCargos' => round($totalCargos,2), 'totalAbonos' => round($totalAbonos,2), 'totalCuentas' => $Account1count, 'cantidadDeudoras' => 333); if($tipoEnvio == "N") { $j_array = array('code' => "200", 'message' => 'Proceso de creacion de Archivo (NORMAL) de Balanza de Comprobacion fue exitoso', 'data' => $resultData); } else { $j_array = array('code' => "200", 'message' => "Proceso de creacion de Archivo (COMPLEMENTARIO) de Balanza de Comprobacion fue exitoso", 'data' => $resultData); } $Resultado = json_encode($j_array); echo $Resultado; return $Resultado; ### FUNCIONES DEL MÓDULO ######################################################### # Funcion para convertir CSV a formato JSON function csvToJson($fname) { if (!($fp = fopen($fname, 'r'))) { die("No se pudo abrir el arcivo CSV..."); } $key = fgetcsv($fp,"1024",","); $json = array(); while ($row = fgetcsv($fp,"1024",",")) { $json[] = array_combine($key, $row); } fclose($fp); return json_encode($json); } # Función que integra los nodos al archivo .XML function cargaAttNodo(&$nodo, $attr){ global $xmldoc; foreach ($attr as $key => $val){ $val = preg_replace('/\s\s+/', ' ', $val); $val = trim($val); if (strlen($val)>0){ $val = utf8_encode(str_replace("|","/",$val)); $nodo->setAttribute($key,$val); } } }