nfo] [fetchCompletions] Request 4717da0e-c730-4e61-89d8-0898c25d6229 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 441.8874440006912ms
2025-05-29 16:33:54.508 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:34:06.199 [info] [fetchCompletions] Request acb275f2-fc20-4bd1-9450-284f042f95f5 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 699.1584509983659ms
2025-05-29 16:34:06.253 [info] [fetchCompletions] Request 6df530c7-6a9c-47e2-91cc-30c7df97c809 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 461.80793699994683ms
2025-05-29 16:34:06.256 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:34:11.824 [info] [fetchCompletions] Request e89a8f1a-3561-445b-af0d-efdddeddfd2c at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 396.0873329974711ms
2025-05-29 16:34:11.827 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:48:49.409 [info] [fetcher] Using Helix fetcher, Electron fetcher is not available.
2025-05-29 16:48:49.409 [info] [code-referencing] Public code references are enabled.
2025-05-29 16:48:49.416 [info] [fetcher] Using Helix fetcher, Electron fetcher is not available.
2025-05-29 16:48:49.827 [info] [fetchCompletions] Request e7ce409b-e7a9-483a-936b-a8906482ad74 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 401.7778959982097ms
2025-05-29 16:48:49.831 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:48:51.489 [info] [fetchCompletions] Request 2694e8e2-843e-4e28-8ba6-9ff634f066c7 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 383.0955920033157ms
2025-05-29 16:48:51.491 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:48:52.226 [info] [fetchCompletions] Request 3f7ffe38-db97-4a51-b1e5-3d458ac9053e at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 192.3767200000584ms
2025-05-29 16:48:52.228 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:49:07.573 [info] [fetchCompletions] Request 96505bd5-e1b7-4cef-84a9-dfe957659756 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 275.17082199826837ms
2025-05-29 16:49:07.774 [info] [fetchCompletions] Request cc52ac31-59fb-4bdc-91cd-680e2c6ffd6d at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 207.99795600026846ms
2025-05-29 16:49:07.777 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:49:08.186 [info] [fetchCompletions] Request caa3258f-67dd-4d95-a8bf-eb2d9a046886 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 238.47089099884033ms
2025-05-29 16:49:08.188 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:49:08.648 [info] [fetchCompletions] Request 1e140dbb-9e78-431c-85fe-b14268de7fc6 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 223.3755670003593ms
2025-05-29 16:49:08.649 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:49:12.017 [info] [fetchCompletions] Request bf352c53-b66e-46b1-995c-3ac0324c78d1 at <https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions> finished with 200 status after 187.62168999761343ms
2025-05-29 16:49:12.019 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-29 16:49:22.614 [info] [fetchCompletions] Request 24661d91-8aaf-4d30-8aa2-6ee6cbb07e79 at <https://proxy.individual.githubcopilot.com/v1/engines/<?php
require('oauth.php');

# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# Función para formatear Moneda
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------ -->

function formatMoney(string $amount): string
{
    $clean = preg_replace('/[^0-9.]/', '', $amount);
    return '$ ' . number_format((float)$clean, 2, '.', ',');
}

# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# MODAL PARA MOSTRAR ERRORES
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------ -->

function showMessage(string $title, string $message): void
{
    // Generar el HTML del modal
    echo <<<HTML
<div class="modal fade" id="dlgError" tabindex="-1" aria-labelledby="dlgErrorLabel" aria-hidden="true">
  <div class="modal-dialog">
    <div class="modal-content shadow p-3 mb-5 bg-white rounded">
      <div class="modal-header">
        <h5 class="modal-title" id="dlgErrorLabel">{htmlspecialchars(\$title)}</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body text-danger">
        {htmlspecialchars(\$message)}
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>
      </div>
    </div>
  </div>
</div>
<script>
  // Oculta el loader si está activo
  if (typeof hideLoader === 'function') hideLoader();

  // Función para limpiar backdrops y modal instanciado
  function cleanErrorModal() {
    const modalEl = document.getElementById('dlgError');
    const modalInstance = bootstrap.Modal.getInstance(modalEl);
    if (modalInstance) {
      modalInstance.dispose();
    }
    // Eliminar el elemento del DOM
    if (modalEl) modalEl.remove();
    // Quitar cualquier backdrop residual
    document.querySelectorAll('.modal-backdrop').forEach(el => el.remove());
    // Restaurar scroll del body
    document.body.style.overflow = '';
    document.body.style.paddingRight = '';
  }

  // Inicializar modal y eventos
  const dlg = new bootstrap.Modal(document.getElementById('dlgError'));
  document.getElementById('dlgError').addEventListener('hidden.bs.modal', cleanErrorModal);

  // Mostrar
  dlg.show();
</script>
HTML;
}

# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# OBTENGO EL TOKEN DE BOOKS
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function GetToken(){
  $sOrganiZB = "";
  if (isset($_REQUEST['pOrganiZB']))
  {    
    $sOrganiZB = $_REQUEST['pOrganiZB'];
  }
  else
  {
    echo 'Por favor introduzca el ID de la Organización de Zoho Books.';
    return;
  }  

  #----------------------------------------------------------------
  # 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 = "' . $sOrganiZB.'"';
  
  if($result = $conn->query($sql)) 
  {
    $row = $result->fetch_assoc();
  } 
  else
    exit('No se ejecuto la consulta');


  #----------------------------------------------------------------
  # RFC de la Organización
  #----------------------------------------------------------------
  $regFeCa            = $row['rfc'];

#----------------------------------------------------------------
  # Variables para Zoho Books
  #----------------------------------------------------------------
  $appOwner           = $row['appOwner'];
  $boa_RefreshToken   = $row['zbooks_rtoken'];
  $boa_ClientId       = $row['zbooksclient_id'];
  $boa_ClientSecret   = $row['zbooksclient_secret'];
  $boa_RedirectUri    = $row['RedirectUri'];
  $boa_AuthUrl        = 'https://accounts.zoho.com/oauth/v2/token';    
  $boa_GrantType      = "refresh_token";

  #----------------------------------------------------------------
  # Cerramos la conexión
  #----------------------------------------------------------------
  mysqli_close($conn);  

  #----------------------------------------------------------------
  # Obtengo el Token de Books
  #----------------------------------------------------------------
  return oauth($appOwner, 'ZBooks', $boa_RefreshToken, $boa_ClientId, $boa_ClientSecret, $boa_RedirectUri, $boa_GrantType, $boa_AuthUrl);
}

# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# USUARIO ACTIVO
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function getUser($zbToken){  
  
  if (isset($_REQUEST['pOrganiZB']))
    {
      $sOrganiZB = $_REQUEST['pOrganiZB'];
    }
  else
    {
      echo "Es necesario introducir el ID de la organización en Zoho Books";
    }

  $request_url = "https://www.zohoapis.com/books/v3/users/me?organization_id=".$sOrganiZB;

  $ch = curl_init();
  curl_setopt($ch, CURLOPT_URL, $request_url);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); 
  curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
  curl_setopt($ch, CURLOPT_HTTPHEADER, array('Authorization: Zoho-oauthtoken ' . $zbToken)); 

  $r = curl_exec($ch);
  $array = json_decode($r);
  $user  = $array->user;
  curl_close ($ch);
  
  //var_dump($array->user);
  echo '<img src="'.$user->photo_url.'" style="width:64px;height:40px;"/>';
  echo "<p>Usuario activo: " . $user->name."</p>";
  echo "<p>Rol activo: " . $user->user_role."</p>";
  echo "<p>eMail: ".$user->email."</p>";
  echo "<p>Estatus: " . $user->status."</p>";    
  
}
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# BALANZA DE COMPROBACIÓN
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function getBalCom($zbToken){  
  $sOrganiZB = "";
  
  if (isset($_REQUEST['pOrganiZB']))
  {
    $sOrganiZB = $_REQUEST['pOrganiZB'];
  }
  
  $sAnioCat      = $_POST['anio'];
  $sMesCat       = $_POST['mes'];
  $sTipoEnv      = $_POST['tipo'];
  $file_name     = basename($_FILES["fileToUpload"]["name"]);
  $file_name    = str_replace(' ', '_', $file_name);
  $temp_file     = $_FILES["fileToUpload"]["tmp_name"];
  $target_dir    = "archs_csv/";
  $target_file   = $target_dir . basename($_FILES["fileToUpload"]["name"]);
  $target_file = str_replace(' ', '_', $target_file);
  $uploadOk      = 1;
  $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));    
 
  if(empty($_POST['anio']))
  {
    echo 'Por favor introduzca el Año para el proceso.';
  }
  else if(empty($_POST['mes']))
  {
    echo 'Por favor introduzca el Mes para el proceso.'; 
  }
  else if(empty($_POST['tipo']))
  {
    echo 'Por favor introduzca el Tipo para el proceso.';
  }
  else if(empty($file_name))
  {                
    showMessage($title = 'Información faltante', $message = 'Por favor seleccione el archivo a procesar.');    
    return;
  }
  else if($sOrganiZB == "")
  {    
    showMessage($title = 'Información erronea', $message = 'Por favor introduzca el ID de la Organización de Zoho Books.');    
    return;
  }
  else
  {              
    // Check if file already exists
    if (file_exists($target_file)) {      
      # showMessage($title = 'Información', $message = 'Se eliminó un archivo pre-existente con el mismo nombre.');          
    }      
    // Allow certain file formats
    if($imageFileType != "csv" ) {    
      showMessage($title = 'Información erronea', $message = 'El archivos debe contener el libro mayor y ser tipo CSV.');    
      return;
    }
      
    // Check if $uploadOk is set to 0 by an error
    if ($uploadOk == 0) 
    {    
      ?><script>     
      document.querySelector("#lblError").innerHTML = "Lo sentimos, tu archivo no fue subido."             
    </script><?php
      return;
    } 
    else 
    {       
      // if everything is ok, try to upload file
      if (move_uploaded_file($temp_file, $target_file)) {
        // echo "El archivo ". htmlspecialchars($file_name). " ha sido subido.";
        
        $sAnioCat   = $_POST['anio'];
        $sMesCat    = $_POST['mes'];
        $sTipoEnv   = $_POST['tipo'];
    
        // $request_url = 'https://aptuslegal.app/aptusContaElec/wsBalanzaComp_v13.php?pAnioCat='.$sAnioCat.'&pMesCata='.$sMesCat."&pTipoEnvio=".$sTipoEnv.'&pOrganiZB='. $sOrganiZB."&pFileName=".$file_name;
        
        $request_url = 'https://aptuslegal.app/aptusContaElec/wsBalanzaComp_v15.php?pAnioCat='.$sAnioCat.'&pMesCata='.$sMesCat."&pTipoEnvio=".$sTipoEnv.'&pOrganiZB='. $sOrganiZB."&pFileName=".$file_name;                
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $request_url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_POST, false);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);                
        
        $r = curl_exec($ch);        
        
        $JsonResponse = json_decode($r);
        // echo $JsonResponse->message . '<BR>';
        
        if (curl_errno($ch))
        {          
            $error_msg = curl_error($ch);            
        }
        
        curl_close ($ch);        
        if (isset($error_msg))
        {
                              
          $j_array = array('code' => $JsonResponse->code, 'message' => "Error al procesar la balanza: " . $JsonResponse->message);
          $Resultado = json_encode($j_array);
          echo $Resultado;
          
          return;
        }
        else
        {          
          
          /********************************************************************/
          // LINKS DE DESCARGA
          /********************************************************************/
            
          $linkXML = '<A href="'.$JsonResponse->data->xmlFilesPath.$JsonResponse->data->xmlFileName.'" download="'.$JsonResponse->data->xmlFileName.'">'.$JsonResponse->data->xmlFileName.'</A>';
          $linkCSV = '<A href="'.$JsonResponse->data->csvFilesPath.$JsonResponse->data->csvFileName.'" download="'.$JsonResponse->data->csvFileName.'">'.$JsonResponse->data->csvFileName.'</A>';
          $linkZIP = '<A href="'.$JsonResponse->data->zipFilesPath.$JsonResponse->data->zipFileName.'" download="'.$JsonResponse->data->zipFileName.'">'.$JsonResponse->data->zipFileName.'</A>';
          
        /********************************************************************/
        // MODAL
        /********************************************************************/
        
        ?>
        <!-- Modal -->
        <div class="modal fade border" id="resultBalanzaComp" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
          <div class="modal-dialog modal-lg">
            <div class="modal-content shadow-lg p-3 mb-5 bg-white rounded">
              <div class="modal-header bg-primary text-white">
                <h5 class="modal-title" id="exampleModalLabel">Balanza de comprobación</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
              </div>
              <div class="modal-body">        
            
                <table class="table table-striped table-hover caption-top shadow">                    
                  <th class="text-center">Concepto</th><th class="text-center">Valor</th>
                    <tbody>
                    <tr>
                    <td>Mensaje:</td>
                    <td ><?php echo $JsonResponse->message ?></td>
                    </tr>

                    <tr>
                    <td>Total de abonos:</td>
                    <td class="text-end"><?php echo formatMoney($JsonResponse->data->totalCargos) ?></td>
                    </tr>
                    <tr>
                    <td>Total de cargos:</td>
                    
                    <td class="text-end"><?php echo formatMoney($JsonResponse->data->totalCargos) ?></td>
                    
                    </tr>   
                    <tr>
                    <td>Total de cuentas calculadas:</td>
                    
                    <td class="text-end"><?php echo $JsonResponse->data->totalCuentas ?></td>
                    
                    </tr>                                        
                    <tr>
                    <td>Descargar archivo XML:</td>
                    <td><p id="xml_file_name"><?php echo $linkXML ?></p></td>                    
                    </tr>
                    <tr>
                    <td>Descargar archivo CSV:</td>
                    <td><p id="csv_file_name"><?php echo $linkCSV; ?></p></td>                    
                    </tr>
                    <tr>
                    <td>Descargar archivo ZIP:</td>
                    <td><p id="zip_file_name"><?php echo $linkZIP ?></p></td>                    
                    </tr>
                    </tbody>
                </table>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>
                <!-- <button type="button" class="btn btn-primary">Save changes</button> -->
              </div>
            </div>
          </div>
        </div>
        <?php
            return;
        }
      } else {
        echo "Lo sentimos, hubo un error al cargar su archivo.";
      }
    }
  }  
  }



# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# AUXILIAR DE CUENTAS
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function getAuxCuentas(){
  // 1. Leer parámetros de entrada
  $sOrganiZB = $_REQUEST['pOrganiZB'] ?? '';
  $sAnioCat  = $_POST['anio']    ?? '';
  $sMesCat   = $_POST['mes']     ?? '';
  $sNumOrden = $_POST['txbNumeroOrden']?? ''; // ahora lo esperamos del formulario
  $TipoSolicitud = $_POST['TipoSolicitud'] ?? ''; // AF, FC, CO, DE según Anexo
  $analyticsID = 722699151; // ID de Analytics para Arochi
  $workspace = 2296733000000004013; // ID de Workspace para Arochi
  $view = 2296733000030848002; // ID de View para Arochi


  // 2. Validaciones
  if (!$sAnioCat) {
      echo 'Por favor introduzca el Año para el proceso.'; return;
  }
  if (!$sMesCat) {
      echo 'Por favor introduzca el Mes para el proceso.'; return;
  }
  if (!$sOrganiZB) {
      echo 'Por favor introduzca el ID de la Organización de Zoho Books.'; return;
  }
  if (!$sNumOrden) {
      echo 'Por favor introduzca el Número de Orden (NumOrden).'; return;
  }

  // 3. Llamada CURL al servicio
  $request_url = sprintf(
    'https://aptuslegal.app/aptusContaElec/wsAuxCuentas.php?anio=%s&mes=%s&pOrganiZB=%s&txbNumeroOrden=%s&pOrganiAnalytics=%s&workspace=%s&view=%s&TipoSolicitud=%s',
    urlencode($sAnioCat),
    urlencode($sMesCat),
    urlencode($sOrganiZB),
    urlencode($sNumOrden),
    urldecode($analyticsID),
    urldecode($workspace),
    urldecode($view),
    urldecode($TipoSolicitud) // TipoSolicitud: AF, FC, CO, DE según Anexo
  );

  $ch = curl_init($request_url);
  curl_setopt_array($ch, [
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_FOLLOWLOCATION => true,
    // GET es el método por defecto, no es necesario CURLOPT_POST = false
  ]);
  $r = curl_exec($ch);

  if (curl_errno($ch)) {
    $error_msg = curl_error($ch);
    curl_close($ch);
    echo json_encode(['code'=>'666','message'=>"Error en la llamada curl: $error_msg"]);
    return;
  }
  curl_close($ch);

  // 4. Parsear JSON de respuesta
  $resp = json_decode($r, true);
  if (!$resp || !isset($resp['code'])) {
    echo 'Respuesta inválida del servicio.'; return;
  }
  if ($resp['code'] !== '200') {
    // Mostrar el mensaje de error que regresa el servicio
    echo 'Error al generar Auxiliar: ' . ($resp['message'] ?? 'Desconocido');
    return;
  }

  // 5. Construir enlaces de descarga con los nombres reales
  $XML_Path = 'https://aptuslegal.app/aptusContaElec/archs_xml/';
  $ZIP_Path = 'https://aptuslegal.app/aptusContaElec/archs_zip/';
  $xmlFileName = $resp['xml_file'];  // viene, por ejemplo, "RFC202504AC.xml"
  $zipFileName = $resp['zip_file'];  // viene, p.ej., "RFC202504AC.zip"

  $fileXmlUrl = sprintf(
    '<a href="%s%s" download="%s">%s</a>',
    $XML_Path, $xmlFileName, $xmlFileName, 'Auxiliar de Cuentas XML'
  );
  $fileZipUrl = sprintf(
    '<a href="%s%s" download="%s">%s</a>',
    $ZIP_Path, $zipFileName, $zipFileName, 'Auxiliar de Cuentas ZIP'
  );

  // 6. Renderizar tu modal con los enlaces
  ?>
  <!-- Modal -->
  <div class="modal fade border" id="resultAuxiliarDeCuentas" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-lg">
      <div class="modal-content shadow-lg p-3 mb-5 bg-white rounded">
        <div class="modal-header bg-primary text-white">
          <h5 class="modal-title">Auxiliar de Cuentas</h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
        </div>
        <div class="modal-body">        
          <table class="table table-striped table-hover caption-top shadow">
            <thead>
              <tr>
                <th class="text-center">Concepto</th>
                <th class="text-center">Valor</th>
              </tr>
            </thead>
            <tbody>
              <tr>
                <td>Descargar archivo XML:</td>
                <td><?php echo $fileXmlUrl; ?></td>
              </tr>
              <tr>
                <td>Descargar archivo ZIP:</td>
                <td><?php echo $fileZipUrl; ?></td>
              </tr>
            </tbody>
          </table>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>
        </div>
      </div>
    </div>
  </div>
  <?php
}





# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# AUXILIAR DE FOLIOS
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function getFolios(){

    $sOrganiZB = "";
    
    if (isset($_REQUEST['pOrganiZB']))
    {
      $sOrganiZB = $_REQUEST['pOrganiZB'];
    }
  
    if(empty($_POST['anio']))
    {
      echo 'Por favor introduzca el Año para el proceso.';
    }
    else if(empty($_POST['mes']))
    {
      echo 'Por favor introduzca el Mes para el proceso.';
    }
    else if($sOrganiZB == "")
    {
      echo 'Por favor introduzca el ID de la Organización de Zoho Books.';
    }
    else
    {
        
      $sAnioCat   = $_POST['anio'];
      $sMesCat    = $_POST['mes'];
  
      $request_url = 'https://aptuslegal.app/aptusContaElec/wsFoliosFiscales.php?pAnioCat='.$sAnioCat.'&pMesCata='.$sMesCat.'&pOrganiZB='.$sOrganiZB;
      

      $ch = curl_init();
      curl_setopt($ch, CURLOPT_URL, $request_url);
      curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
      curl_setopt($ch, CURLOPT_POST, false);
      curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
  
      $r = curl_exec($ch);
  
          if (curl_errno($ch))
          {
              $error_msg = curl_error($ch);
          }
  
      curl_close ($ch);
  
          if (isset($error_msg))
          {
              $j_array = array('code' => '666', 'message' => "Error en la llamada curl " . $error_msg);
              $Resultado = json_encode($j_array);
        
              echo $Resultado;
              return;
          }
          else
          {          
          /********************************************************************/
          // LINKS DE DESCARGA
          /********************************************************************/
            $XML_Path = 'https://aptuslegal.app/aptusContaElec/archs_xml/';          
            $ZIP_Path = 'https://aptuslegal.app/aptusContaElec/archs_zip/';
            $XML_fileName   = $XML_Path.'AML9605085V8'.$sAnioCat.$sMesCat.'XF.xml';
            // basename() extrae sólo "AML9605085V8202505XF.xml"
            $xmlBasename    = basename($XML_fileName);
            // El link sigue apuntando a la URL, pero el download sólo lleva el nombre
            $fileXmlUrl     = '<a href="'.$XML_fileName.'" download="'.$xmlBasename.'">Auxiliar de folios XML</a><br>';

            // Igual para el ZIP:
            $ZIP_fileName   = $ZIP_Path.'AML9605085V8'.$sAnioCat.$sMesCat.'XF.zip';
            $zipBasename    = basename($ZIP_fileName);
            $fileZipUrl     = '<a href="'.$ZIP_fileName.'" download="'.$zipBasename.'">Auxiliar de folios ZIP</a><br>';
          /********************************************************************/          
          ?>
          <!-- Modal -->
          <div class="modal fade border" id="resultFoliosFiscales" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-lg">
              <div class="modal-content shadow-lg p-3 mb-5 bg-white rounded">
                <div class="modal-header bg-primary text-white">
                  <h5 class="modal-title" id="exampleModalLabel">Folios Fiscales</h5>
                  <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">        
              
                  <table class="table table-striped table-hover caption-top shadow">                    
                    <th class="text-center">Concepto</th><th class="text-center">Valor</th>
                      <tbody>
                      <!-- <tr>
                      <td>Mensaje:</td>
                      <td >
                      </td>
                      </tr>
  
                      <tr>
                      <td>Total de abonos:</td>
                      <td class="text-end">
                      </td>
                      </tr>
                      <tr>
                      <td>Total de cargos:</td>
                      
                      <td class="text-end">
                      </td>
                      
                      </tr>   
                      <tr>
                      <td>Total de cuentas calculadas:</td>
                      
                      <td class="text-end">
                      </td>
                      
                      </tr>                                         -->
                      <tr>
                      <td>Descargar archivo XML:</td>
                      <td><p id="xml_file_name"><?php echo $fileXmlUrl; ?></p></td>                    
                      </tr>
                      
                      <tr>
                      <td>Descargar archivo ZIP:</td>
                      <td><p id="zip_file_name"><?php echo $fileZipUrl; ?></p></td>                    
                      </tr>
                      </tbody>
                  </table>
                </div>
                <div class="modal-footer">
                  <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>
                  <!-- <button type="button" class="btn btn-primary">Save changes</button> -->
                </div>
              </div>
            </div>
          </div>
          <?php
              return;
          }
    }  
  }


# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# CATÁLOGO DE CUENTAS
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function getCatCue(){
    $sOrganiZB = "";
  
    if (isset($_REQUEST['pOrganiZB']))
    {
      $sOrganiZB = $_REQUEST['pOrganiZB'];
    }
    
    if(empty($_POST['anio']))
    {
      echo 'Por favor introduzca el Año para el proceso.';
    }
    else if(empty($_POST['mes']))
    {
      echo 'Por favor introduzca el Mes para el proceso.';
    }
    else if($sOrganiZB == "")
    {
      echo 'Por favor introduzca el ID de la Organización de Zoho Books.';
    }
    else
    {
      $sAnioCat   = $_POST['anio'];
      $sMesCat    = $_POST['mes'];
  
      $request_url = 'https://aptuslegal.app/aptusContaElec/wsCatalogoCuentas_v13.php?pAnioCat='.$sAnioCat.'&pMesCata='.$sMesCat.'&pOrganiZB='.$sOrganiZB;
      
      $ch = curl_init();
      curl_setopt($ch, CURLOPT_URL, $request_url);
      curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
      curl_setopt($ch, CURLOPT_POST, false);
      curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
  
      $r = curl_exec($ch);
      $JsonResponse = json_decode($r);
      echo $JsonResponse->message;

          if (curl_errno($ch))
          {
              $error_msg = curl_error($ch);
          }
  
      curl_close ($ch);
  
          if (isset($error_msg))
          {
              $j_array = array('code' => '500', 'message' => "Error en la llamada curl: " . $error_msg);
              $Resultado = json_encode($j_array);
        
              //echo $Resultado;
              return;
          }
          else
          {          
          /********************************************************************/
          // LINKS DE DESCARGA
          /********************************************************************/
            
              $linkXML = '<A href="'.$JsonResponse->data->xmlFilesPath.$JsonResponse->data->xmlFileName.'" download="'.$JsonResponse->data->xmlFileName.'">'.$JsonResponse->data->xmlFileName.'</A>';
              $linkZIP = '<A href="'.$JsonResponse->data->zipFilesPath.$JsonResponse->data->zipFileName.'" download="'.$JsonResponse->data->zipFileName.'">'.$JsonResponse->data->zipFileName.'</A>';
                    
          
          /********************************************************************/
          // MODAL
          /********************************************************************/
          
          ?>
          
                    <!-- Modal -->
          <div class="modal fade " id="resultCatalogoCuentas"  tabindex="-1" aria-labelledby="resultCatalogoCuentas" aria-hidden="true">
            <div class="modal-dialog modal-lg">
              <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title" id="resultCatalogoCuentas">Catálogo de cuentas</h5>
                  <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">        
              
                  <table class="table table-striped table-hover caption-top ">                    
                    <th class="text-center">Concepto</th><th class="text-center">Valor</th>
                      <tbody>
                      <tr>
                        <td>Cantidad de cuentas acreedoras:</td>
                        <td class="text-end"> <?php echo $JsonResponse->data->cantidadAcreedoras?></td>
                      </tr>
                      <tr>
                        <td>Cantidad de cuentas deudoras:</td>
                        <td class="text-end"> <?php echo $JsonResponse->data->cantidadDeudoras?></td>
                      </tr>
                      <tr>
                        <td>Total de cuentas:</td>
                        <td class="text-end"><?php echo $JsonResponse->data->cantidadCuentas?></td>
                      </tr>                      
                      <tr>
                        <td>Descargar archivo XML:</td>
                        <td><p id="xml_file_name"><?php echo $linkXML ?></p></td>
                      </tr>
                      <tr>
                        <td>Descargar archivo ZIP:</td>
                        <td><p id="xml_file_name"><?php echo $linkZIP ?></p></td>
                      </tr>
                      
                      </tbody>
                  </table>
                </div>
                <div class="modal-footer">
                  <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>
                  <!-- <button type="button" class="btn btn-primary">Save changes</button> -->
                </div>
              </div>
            </div>
          </div>
          <?php
              
            return;
          }
    }  
  }



# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# PÓLIZAS DEL PERIODO
# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
function getPolizas()
{
  $errors = [];

  // Recoger y sanear entradas
  $anio             = trim($_POST['anio'] ?? '');
  $mes              = trim($_POST['mes'] ?? '');
  $TipoSolicitud    = trim($_POST['TipoSolicitud'] ?? '');
  $txbNumeroOrden   = trim($_POST['txbNumeroOrden'] ?? '');
  $organiZB         = trim($_REQUEST['pOrganiZB'] ?? '');
  
  // Validaciones obligatorias
  if ($anio === '') {
      $errors[] = 'Por favor introduzca el Año para el proceso.';
  }
  
  if ($mes === '') {
      $errors[] = 'Por favor introduzca el Mes para el proceso.';
  }
  
  if ($organiZB === '') {
      $errors[] = 'Por favor introduzca el ID de la Organización de Zoho Books.';
  }
  
  // Validar Tipo de Solicitud
  if ($TipoSolicitud === '') {
      $errors[] = 'Por favor seleccione el Tipo de solicitud.';
  } elseif (!in_array($TipoSolicitud, ['AF', 'AC', 'CO', 'DF', 'AR'], true)) {
      $errors[] = 'Tipo de solicitud inválido. Debe ser AF (Alta de Folio), AC (Alta Complementaria), CO (Cancelación), DF (Duplicado de Folio) o AR (Alta por Reemplazo).';
  }
  
  // // Validar Número de Orden
  // if ($txbNumeroOrden === '') {
  //     $errors[] = 'Por favor introduzca el Número de orden.';
  // } elseif (!ctype_digit($txbNumeroOrden)) {
  //     $errors[] = 'Número de orden inválido. Debe ser un número entero.';
  // }
  
  // Mostrar errores y detener procesamiento
  if (!empty($errors)) {
      echo implode('<br>', $errors);
      return;
  }

    $queryParams = http_build_query([
        'Anio' => $anio,
        'Mes' => $mes,
        'pOrganiZB' => $organiZB,
        'pOrganiAnalytics' => '722699151',
        'RFC' => 'AML9605085V8',
        'workspace' => '2296733000000004013',
        'view' => '2296733000030848002',
        'appOwner' => 'arochiylindner.aptus',
        'txbNumeroOrden' => $txbNumeroOrden,
        'TipoSolicitud' => $TipoSolicitud
    ]);

    $url = "https://aptuslegal.app/aptusContaElec/wsPolizasAnalytics.php?$queryParams";
    echo implode('<br>', $url);
    $curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => $url,
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
));

$response = curl_exec($curl);

curl_close($curl);

    // Decodificar la respuesta del servicio
    $data = json_decode($response, true);
    if (!$data || $data['code'] !== "200") {
        echo "Ocurrió un error al generar las pólizas: " . ($data['message'] ?? 'Respuesta inválida del servicio.');
        return;
    }

    $xmlFileName = $data['xml_file_name'];
    $zipFileName = $data['zip_file_name'];
    $csvFileName = $data['csv_file_name'] ?? null;


    $XML_file = "https://aptuslegal.app/aptusContaElec/archs_xml/$xmlFileName";
    $ZIP_file = "https://aptuslegal.app/aptusContaElec/archs_zip/$zipFileName";
    $CSV_file = "https://aptuslegal.app/aptusContaElec/archs_csv/$csvFileName";


    // Output con HTML
    ?>
    <div class="modal fade border" id="resultPolizas" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
      <div class="modal-dialog modal-lg">
        <div class="modal-content shadow-lg p-3 mb-5 bg-white rounded">
          <div class="modal-header bg-primary text-white">
            <h5 class="modal-title" id="exampleModalLabel">Pólizas</h5>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
          </div>
          <div class="modal-body">
            <table class="table table-striped table-hover caption-top shadow">
              <thead>
                <tr><th class="text-center">Concepto</th><th class="text-center">Valor</th></tr>
              </thead>
              <tbody>
                <tr>
                  <td>Descargar archivo CSV:</td>
                  <td><a href="<?= htmlspecialchars($CSV_file) ?>" download="<?= htmlspecialchars($csvFileName) ?>">Pólizas del periodo CSV</a></td>
                </tr>
                <tr>
                  <td>Descargar archivo XML:</td>
                  <td><a href="<?= htmlspecialchars($XML_file) ?>" download="<?= htmlspecialchars($xmlFileName) ?>">Pólizas del periodo XML</a></td>
                </tr>
                <tr>
                  <td>Descargar archivo ZIP:</td>
                  <td><a href="<?= htmlspecialchars($ZIP_file) ?>" download="<?= htmlspecialchars($zipFileName) ?>">Pólizas del periodo ZIP</a></td>
                </tr>
                <tr>
                  <td>Total de Pólizas:</td>
                  <td><?= number_format($data['Total de Polizas']) ?></td>
                </tr>
                <tr>
                  <td>Total Debe:</td>
                  <td>$<?= number_format($data['Total Debe'], 2) ?></td>
                </tr>
                <tr>
                  <td>Total Haber:</td>
                  <td>$<?= number_format($data['Total Haber'], 2) ?></td>
                </tr>
              </tbody>
            </table>
          </div>
          <div class="modal-footer">
            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>
          </div>
        </div>
      </div>
    </div>
    <script>
      var myModal = new bootstrap.Modal(document.getElementById('resultPolizas'));
      myModal.show();
    </script>
    <script>
      document.getElementById('resultPolizas').addEventListener('hidden.bs.modal', function() {
        // Quitar clases y backdrops residuales
        document.body.classList.remove('modal-open');
        document.querySelectorAll('.modal-backdrop').forEach(function(b) { b.remove(); });
      });
    </script>

    <?php
}
?>