git config --get commit.template [6ms]
2025-10-16 12:49:57.651 [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 [2ms]
2025-10-16 12:49:57.663 [info] > git status -z -uall [7ms]
2025-10-16 12:49:57.663 [info] > git for-each-ref --sort -committerdate --format %(refname)%00%(objectname)%00%(*objectname) [2ms]
2025-10-16 12:50:02.677 [info] > git config --get commit.template [6ms]
2025-10-16 12:50:02.678 [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 [2ms]
2025-10-16 12:50:02.688 [info] > git status -z -uall [4ms]
2025-10-16 12:50:02.691 [info] > git for-each-ref --sort -committerdate --format %(refname)%00%(objectname)%00%(*objectname) [4ms]
2025-10-16 12:54:08.400 [info] > git rev-parse --show-toplevel [2ms]
2025-10-16 12:54:08.400 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 12:54:24.052 [info] > git rev-parse --show-toplevel [2ms]
2025-10-16 12:54:24.052 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 13:46:48.910 [info] > git rev-parse --show-toplevel [1ms]
2025-10-16 13:46:48.911 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 13:47:01.342 [info] > git rev-parse --show-toplevel [2ms]
2025-10-16 13:47:01.342 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:01:12.576 [info] > git rev-parse --show-toplevel [1ms]
2025-10-16 14:01:12.576 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:01:28.142 [info] > git rev-parse --show-toplevel [1ms]
2025-10-16 14:01:28.142 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:01:34.979 [info] > git rev-parse --show-toplevel [2ms]
2025-10-16 14:01:34.979 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:01:39.839 [info] > git config --get commit.template [1ms]
2025-10-16 14:01:39.847 [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]
2025-10-16 14:01:39.858 [info] > git status -z -uall [5ms]
2025-10-16 14:01:39.859 [info] > git for-each-ref --sort -committerdate --format %(refname)%00%(objectname)%00%(*objectname) [1ms]
2025-10-16 14:01:44.876 [info] > git config --get commit.template [8ms]
2025-10-16 14:01:44.878 [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 [3ms]
2025-10-16 14:01:44.893 [info] > git status -z -uall [8ms]
2025-10-16 14:01:44.893 [info] > git for-each-ref --sort -committerdate --format %(refname)%00%(objectname)%00%(*objectname) [1ms]
2025-10-16 14:01:49.055 [info] > git rev-parse --show-toplevel [5ms]
2025-10-16 14:01:49.055 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:01:49.909 [info] > git config --get commit.template [6ms]
2025-10-16 14:01:49.910 [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]
2025-10-16 14:01:49.920 [info] > git status -z -uall [4ms]
2025-10-16 14:01:49.921 [info] > git for-each-ref --sort -committerdate --format %(refname)%00%(objectname)%00%(*objectname) [2ms]
2025-10-16 14:01:51.317 [info] > git rev-parse --show-toplevel [2ms]
2025-10-16 14:01:51.318 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:02:08.938 [info] > git rev-parse --show-toplevel [1ms]
2025-10-16 14:02:08.938 [info] fatal: not a git repository (or any of the parent directories): .git
2025-10-16 14:15:05.072 [info] > g<?php
    
    error_reporting(E_ALL);
    ini_set("display_errors",1);
    ini_set('mssql.charset', 'UTF-8');
    date_default_timezone_set('America/Mexico_City');

    include_once("wsDatabase.php"); 
    include_once("_json_encode.php"); 
    
    class Matter
    {
        /**
         * Método para traer los registros de Asuntos de un Cliente conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $recidCli
         * @param integer $recidTK
         * @param integer $cliIsTmp
         * @param integer $dispTmpMat
         * @param integer $recidUser
         * @param string $Valor
         * @param integer $recidMatter
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function searchMatters($dataConnection, $recidCli, $recidTK = 0, $cliIsTmp = 0, $dispTmpMat = 0,  
                                        $recidUser = 0, $Valor = '', $recidMatter = 0, $Answer = "JSON") // Agrego $offset y $rowsPerPage
{
            /**
             * Fragmento actualizado por Luis Cano para obtener datos de Stored Procedure de forma paginada
             * ya que este tipo de conexión tiene un límite de registros a devolver
             */
            $db = new DataBase();
            $db_connect = $db->setConnection($dataConnection);
            $offset = 1;
            $rowsPerPage = 100;

            if ($db_connect == null) {
                return $db_connect;
            }

            $allRows = []; // arreglo con total de datos
            $queries = [];
            $rows = [];

            do {
                
                $query = "execute als_SearchMatters_pagination ";
                $query .= "@RecIdClient=".$recidCli;
                $query .= ", @recidTK=".$recidTK;
                $query .= ", @ClientIsTMP=".$cliIsTmp;
                $query .= ", @alsoDisplayTMPMatters=".$dispTmpMat;
                $query .= ", @userk=".$recidUser;
                $query .= ", @value='".$Valor."'";
                $query .= ", @MatterRecid=".$recidMatter;
                // parámetros de paginación
                $query .= ", @PageNumber=".$offset; // Añade Offset
                $query .= ", @RowsPerPage=".$rowsPerPage; // Añade RowsPerPage
/*echo $query;

                array_push($queries, $query);*/
                $resultado  = sqlsrv_query($db_connect, $query);

                if (!$resultado) {
                    // TODO: manejo de errores
                    return null;
                }

                $rows = [];
                while ($row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC)) {
                    $rows[] = $row;
                }

                $allRows = array_merge($allRows, $rows); // añade las filas al resultado total

                $offset++; // aumenta el offset para la próxima iteración

            } while (count($rows) > 0); // itera mientras haya datos

            $db->setDisconnection($db_connect);

            // return $queries;
            if (count($allRows) === 0) {
                return null;
            }

            if ($Answer === "JSON") {
                return json_encode($allRows);
            } else {
                return $allRows;
            }
        }

        
        /**
         * Método para traer los datos de un Asunto conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param string $idMatter
         * @param integer $recidMatter
         * @param integer $recidCli
         * @param integer $recidTK
         * @param integer $cliIsTmp
         * @param integer $dispTmpMat
         * @param integer $recidUser
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function getMatterData($dataConnection, $idMatter, $recidMatter, $recidCli, $recidTK = 0, 
                                        $cliIsTmp = 0, $dispTmpMat = 0,  $recidUser = 0, $Answer = "JSON") 
        {

            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_SearchMattersById ";
            $query .= "@MattersId='".$idMatter."'";
            $query .= ", @MattersRecid=".$recidMatter;
            $query .= ", @RecIdClient=".$recidCli;
            $query .= ", @recidTK=".$recidTK;
            $query .= ", @ClientIsTMP=".$cliIsTmp;
            $query .= ", @alsoDisplayTMPMatters=".$dispTmpMat;
            $query .= ", @userk=".$recidUser;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: getMatterData, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $rows = array();
            while( $row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
            {
                $rows[] = $row;
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

        /**
         * Método para traer los registros de Asuntos Temporales conforme a parametro de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $recidUser
         * @param integer $recidTmpCli
         * @param integer $recidClient
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function searchTmpMatters($dataConnection, $recidUser, $recidTmpCli = 0, $recidClient = 0, $Answer = "JSON") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_SearchTemporalMatters ";
            $query .= "@Userk=".$recidUser;
            $query .= ", @RecidClient=".$recidTmpCli;
            $query .= ", @RecidNoTMPCient=".$recidClient;

            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: searchTmpMatters, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $rows = array();
            while( $row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
            {
                $rows[] = $row;
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

        /**
         * Método para traer los datos de un Asunto Temporal conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $recidTmpCli
         * @param integer $recidTG
         * @param string $typeTG
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function getTmpMatterData($dataConnection, $recidTmpMat, $recidTG = 0, $typeTG = '', $Answer = "JSON") 
        {

            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_TemporalMatterData ";
            $query .= "@recidTMP=".$recidTmpMat;
            $query .= ", @recidTG=".$recidTG;
            $query .= ", @typeTG='".$typeTG."'";
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: getTmpMatterData, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $rows = array();
            while( $row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
            {
                $rows[] = $row;
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }
        
        /**
         * Método para adicionar un nuevo Asunto Temporal.
         * 
         * @param array $dataConnection
         * @param string $idMatTem
         * @param string $nameMatTem
         * @param integer $recidUser
         * @param integer $language
         * @param integer $recidTmpCli
         * @param integer $recidClient
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function insTmpMatter($dataConnection, $idMatTem, $nameMatTem, $recidUser, $language, 
                                        $recidTmpCli = 0, $recidClient = 0, $Answer = "JSON") 
        {

            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_InsertTemporalMatter ";
            $query .= "@Id='".$idMatTem."'";
            $query .= ", @Name='".$nameMatTem."'";
            $query .= ", @UserK=".$recidUser;
            $query .= ", @RecidClient=".$recidTmpCli;
            $query .= ", @RecidNoTMPCient=".$recidClient;
            $query .= ", @languagek=".$language;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: insTmpMatter, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            
            $all_data = array();
            
            do {
                $rows = array();
                while ($row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC)) {
                    array_push($rows, $row);
                }
                array_push($all_data, $rows);
            } while (sqlsrv_next_result($resultado));

            // echo json_encode(($test));
            return json_encode($rows);

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

        /**
         * Método para actualizar los datos de un Asunto Temporal.
         * 
         * @param array $dataConnection
         * @param string $idCliTem
         * @param string $nameCliTem
         * @param integer $recidTmp
         * @param integer $recidTG
         * @param string $typeTG
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function updTmpMatter($dataConnection, $idMatTem, $nameMatTem, $recidTmp, 
                                        $language, $recidTG = 0, $typeTG = '', $Answer = "JSON") 
        {

            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query  = "execute als_UpdateTemporalMatter ";
            $query .= "@Id='".$idMatTem."'";
            $query .= ", @Name='".$nameMatTem."'";
            $query .= ", @RecIdTG=".$recidTG;
            $query .= ", @typeTG='".$typeTG."'";
            $query .= ", @recidTMP=".$recidTmp;
            $query .= ", @languagek=".$language;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: updTmpMatter, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $all_data = array();
            
            do {
                $rows = array();
                while ($row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC)) {
                    array_push($rows, $row);
                }
                array_push($all_data, $rows);
            } while (sqlsrv_next_result($resultado));

            // echo json_encode(($test));
            return json_encode($rows);

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

        /**
         * Método para Eliminar los registros de Asuntos Temporales conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $recid
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function delTmpMatter($dataConnection, $recid, $Answer = "JSON") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_BorraRegistro ";
            $query .= "@Table='temp_matters'";
            $query .= ", @Recid=".$recid;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: delTmpMatter, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $rows = array();
            while( $row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
            {
                $rows[] = $row;
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

        /**
         * Método para traer los registros de Incrementos Especiales conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $recidCli
         * @param integer $recidMat
         * @param integer $tipoRes
         * @param integer $ridLang
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function getSpecialInc($dataConnection, $recidCli, $recidMat, $tipoRes = 1, $ridLang = 1, $Answer = "JSON") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_GetIncEspMatterClient ";
            $query .= "@Client=".$recidCli;
            $query .= ", @Matter=".$recidMat;
            $query .= ", @TipRes=".$tipoRes;
            $query .= ", @iLanguage=".$ridLang;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: getSpecialInc, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $rows = array();
            while( $row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
            {
                $rows[] = $row;
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

        /**
         * Método para obtener la Leyenda para la Narrativa.
         * 
         * @param array $dataConnection
         * @param integer $languageSys
         * @param integer $languageMat
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function getTextLeyNarr($dataConnection, $languageSys, $languageMat, $Answer = "JSON") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_GetLeyendaNarrativa ";
            $query .= "@langkSystem=".$languageSys;
            $query .= ", @langkMatter=".$languageMat;
            $query .= ", @screen='TimeEntry.aspx'";
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsMatter.php, Clase: Matter, Metodo: getTextLeyNarr, Mensaje: Fallo al ejecutar la consulta a MSSQL."."\n".
                                "Query: ".$query."\n"."Error: " . print_r(sqlsrv_errors()), true) );
                return null;
            }

            $rows = array();
            while( $row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
            {
                $rows[] = $row;
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);

            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }

    }