--show-toplevel [1ms]
2024-12-13 12:49:20.927 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:50:58.016 [info] > git rev-parse --show-toplevel [0ms]
2024-12-13 12:50:58.016 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:51:01.442 [info] > git rev-parse --show-toplevel [2ms]
2024-12-13 12:51:01.442 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:51:37.603 [info] > git rev-parse --show-toplevel [0ms]
2024-12-13 12:51:37.603 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:51:39.523 [info] > git rev-parse --show-toplevel [1ms]
2024-12-13 12:51:39.523 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:51:47.001 [info] > git rev-parse --show-toplevel [0ms]
2024-12-13 12:51:47.001 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:51:48.661 [info] > git rev-parse --show-toplevel [1ms]
2024-12-13 12:51:48.661 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:52:03.679 [info] > git rev-parse --show-toplevel [1ms]
2024-12-13 12:52:03.679 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:52:04.172 [info] > git rev-parse --show-toplevel [0ms]
2024-12-13 12:52:04.172 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 12:52:06.357 [info] > git rev-parse --show-toplevel [1ms]
2024-12-13 12:52:06.357 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 13:16:52.609 [info] > git rev-parse --show-toplevel [2ms]
2024-12-13 13:16:52.609 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 13:28:21.999 [info] > git config --get commit.template [3ms]
2024-12-13 13:28:22.000 [info] > git for-each-ref --format=%(refname)%00%(upstream:short)%00%(objectname)%00%(upstream:track)%00%(upstream:remotename)%00%(upstream:remoteref) refs/heads/master refs/remotes/master [1ms]
2024-12-13 13:28:22.007 [info] > git status -z -uall [4ms]
2024-12-13 13:28:22.007 [info] > git for-each-ref --sort -committerdate --format %(refname) %(objectname) %(*objectname) [1ms]
2024-12-13 13:28:28.965 [info] > git config --get commit.template [1ms]
2024-12-13 13:28:28.968 [info] > git for-each-ref --format=%(refname)%00%(upstream:short)%00%(objectname)%00%(upstream:track)%00%(upstream:remotename)%00%(upstream:remoteref) refs/heads/master refs/remotes/master [1ms]
2024-12-13 13:28:28.975 [info] > git status -z -uall [3ms]
2024-12-13 13:28:28.975 [info] > git for-each-ref --sort -committerdate --format %(refname) %(objectname) %(*objectname) [1ms]
2024-12-13 14:26:49.405 [info] > git config --get commit.template [1ms]
2024-12-13 14:26:49.408 [info] > git for-each-ref --format=%(refname)%00%(upstream:short)%00%(objectname)%00%(upstream:track)%00%(upstream:remotename)%00%(upstream:remoteref) refs/heads/master refs/remotes/master [1ms]
2024-12-13 14:26:49.414 [info] > git status -z -uall [3ms]
2024-12-13 14:26:49.414 [info] > git for-each-ref --sort -committerdate --format %(refname) %(objectname) %(*objectname) [1ms]
2024-12-13 14:26:54.424 [info] > git config --get commit.template [3ms]
2024-12-13 14:26:54.424 [info] > git for-each-ref --format=%(refname)%00%(upstream:short)%00%(objectname)%00%(upstream:track)%00%(upstream:remotename)%00%(upstream:remoteref) refs/heads/master refs/remotes/master [0ms]
2024-12-13 14:26:54.430 [info] > git status -z -uall [2ms]
2024-12-13 14:26:54.430 [info] > git for-each-ref --sort -committerdate --format %(refname) %(objectname) %(*objectname) [1ms]
2024-12-13 14:27:17.879 [info] > git rev-parse --show-toplevel [2ms]
2024-12-13 14:27:17.879 [info] fatal: not a git repository (or any of the parent directories): .git
2024-12-13 14:50:07.686 [info] > git config --get commit.template [4ms]
2024-12-13 14:50:07.686 [info] > git for-each-ref --format=%(refname)%00%(upstream:short)%00%(objectname)%00%(upstream:track)%00%(upstr<?php
require('oauth.php');

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

function formatMoney($Money)
{
    return "$ ".number_format(sprintf('%0.2f', preg_replace("/[^0-9.]/", "", $Money)),2);
}

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

function showMessage($title, $message){
  
  echo '<div class="modal fade" id="dlgError" tabindex="2" aria-labelledby="exampleModalLabel" aria-hidden="true">';
  echo '<div class="modal-dialog">';
    echo '<div class="modal-content shadow p-3 mb-5 bg-white rounded">';
      echo '<div class="modal-header">';
        echo '<h5 class="modal-title" id="dlgErrorLabel">'. $title . ' </h5>';
        echo '<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>';
      echo '</div>';
      echo '<div class="modal-body text-danger">';
        echo $message;
      echo '</div>';
      echo '<div class="modal-footer">';
        echo '<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cerrar</button>';
      echo '</div>';
    echo '</div>';
  echo '</div>';
echo '</div>';


echo '<script type="text/javascript">showMessages();</script>';
}

# ------------------------------------------------------------------------------------------------------------------------------------------------------------------
# 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_v14.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(){
    $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/wsPolizas.php?Anio='.$sAnioCat.'&Mes='.$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.'PP.xml';
            $ZIP_fileName = $ZIP_Path.'AML9605085V8'.$sAnioCat.$sMesCat.'PP.zip';
          
                        
              $fileXmlUrl = '<A href="'.$XML_fileName.'" download="'.$XML_fileName.'">Pólizas del periodo XML</A></BR>';
              $fileZipUrl = '<A href="'.$ZIP_fileName.'" download="'.$ZIP_fileName.'">Pólizas del periodo ZIP</A></BR>';
          /********************************************************************/     
          ?>
          <!-- Modal -->
          <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">                    
                    <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;
          }
    }  
  }
?>