st.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 437.7453099996783 ms
2025-05-05 10:47:29.081 [info] [streamChoices] request done: headerRequestId: [42d183c3-15e8-46c2-ad17-f84cc3c38389] model deployment ID: []
2025-05-05 10:47:29.328 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 245.4198930002749 ms
2025-05-05 10:47:29.330 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:47:29.334 [info] [streamChoices] request done: headerRequestId: [38d8afe7-2196-4ba2-986a-8f161f1ae102] model deployment ID: []
2025-05-05 10:47:31.279 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 334.6818889998831 ms
2025-05-05 10:47:31.282 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:47:31.285 [info] [streamChoices] request done: headerRequestId: [40912ab3-d411-4cc6-8ad6-7f0336180c67] model deployment ID: []
2025-05-05 10:47:33.377 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 732.6965600000694 ms
2025-05-05 10:47:33.380 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:47:33.383 [info] [streamChoices] request done: headerRequestId: [b0c31a66-056f-491e-8f1d-7e78863ef37d] model deployment ID: []
2025-05-05 10:47:55.081 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 505.345160999801 ms
2025-05-05 10:47:55.083 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:47:55.087 [info] [streamChoices] request done: headerRequestId: [b13bafe8-aa6a-4a2d-9b9d-b400061be33d] model deployment ID: []
2025-05-05 10:50:42.959 [warning] [relatedFiles] unknown language html
2025-05-05 10:50:43.632 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 645.030389000196 ms
2025-05-05 10:50:43.634 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:50:43.636 [info] [streamChoices] request done: headerRequestId: [b0f57763-2f4f-4623-af86-87669455e5bb] model deployment ID: []
2025-05-05 10:50:43.637 [info] [ghostText] Filtered out solution matching next line
2025-05-05 10:50:45.368 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 185.22090700035915 ms
2025-05-05 10:50:45.370 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:50:45.370 [info] [streamChoices] request done: headerRequestId: [30872096-a086-485a-b0f5-ad90bac2abb0] model deployment ID: []
2025-05-05 10:51:25.473 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 464.2609739997424 ms
2025-05-05 10:51:25.474 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:51:25.474 [info] [streamChoices] request done: headerRequestId: [ba72e581-ade6-49ff-b04b-a7ae2859ae36] model deployment ID: []
2025-05-05 10:55:37.118 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copilot/completions] took 492.3527250001207 ms
2025-05-05 10:55:37.120 [info] [streamChoices] solution 0 returned. finish reason: [stop]
2025-05-05 10:55:37.121 [info] [streamChoices] request done: headerRequestId: [f3335277-6732-4dff-8558-6e28f6f4e79d] model deployment ID: []
2025-05-05 11:53:02.566 [info] [fetcher] Using Helix fetcher, Electron fetcher is not available.
2025-05-05 11:53:02.566 [info] [code-referencing] Public code references are enabled.
2025-05-05 11:53:02.729 [info] [fetcher] Using Helix fetcher, Electron fetcher is not available.
2025-05-05 11:53:03.140 [info] [fetchCompletions] request.response: [https://proxy.individual.githubcopilot.com/v1/engines/gpt-4o-copil<?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(){
    $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/wsAuxCuentas.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.'XC.xml';
            $ZIP_fileName = $ZIP_Path.'AML9605085V8'.$sAnioCat.$sMesCat.'XC.zip';
          
                        
              $fileXmlUrl = '<A href="'.$XML_fileName.'" download="'.$XML_fileName.'">Auxiliar de cuentas XML</A></BR>';
              $fileZipUrl = '<A href="'.$ZIP_fileName.'" download="'.$ZIP_fileName.'">Auxiliar de cuentas ZIP</A></BR>';
          /********************************************************************/          
          ?>
          <!-- Modal -->
          <div class="modal fade border" id="resultAuxiliarDeCuentas" 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">Auxiliar 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 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;
          }
    }  
  }




# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# 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';
            $ZIP_fileName = $ZIP_Path.'AML9605085V8'.$sAnioCat.$sMesCat.'XF.zip';
          
                        
              $fileXmlUrl = '<A href="'.$XML_fileName.'" download="'.$XML_fileName.'">Auxiliar de folios XML</A></BR>';
              $fileZipUrl = '<A href="'.$ZIP_fileName.'" download="'.$ZIP_fileName.'">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 = [];

    $anio = $_POST['anio'] ?? null;
    $mes = $_POST['mes'] ?? null;
    $TipoSolicitud = $_POST['TipoSolicitud'] ?? null;
    $txbNumeroOrden = $_POST['txbNumeroOrden'] ?? null;
    $organiZB = $_REQUEST['pOrganiZB'] ?? '';

    if (empty($anio)) {
        $errors[] = 'Por favor introduzca el Año para el proceso.';
    }

    if (empty($mes)) {
        $errors[] = 'Por favor introduzca el Mes para el proceso.';
    }

    if (empty($organiZB)) {
        $errors[] = 'Por favor introduzca el ID de la Organización de Zoho Books.';
    }

    if(!empty($TipoSolicitud) && !in_array($TipoSolicitud, ['AF', 'AC', 'CO', 'DF', 'AR'])) {
        $errors[] = 'Tipo de solicitud inválido. Debe ser AF, AC, CO, DF o AR.';
    }
    if (!empty($txbNumeroOrden) && !is_numeric($txbNumeroOrden)) {
        $errors[] = 'Número de orden inválido. Debe ser un número.';
    }

    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'];

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

    // 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 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
}
?>