signatures for nvidia modules for version 5.14.0-1038-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1038-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1042-oem
Description-md5: 0a0c3c5bbd701c3cb36bf153210682c6
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1042-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1042-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1044-oem
Description-md5: 8104ac9421447d0cd0ed88f6446c88a2
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1044-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1044-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1045-oem
Description-md5: ca88660d8392b9cd6000af6a0a9bd163
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1045-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1045-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1046-oem
Description-md5: b834088b46c77834df4da898e1c1a5f7
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1046-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1046-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1047-oem
Description-md5: 8989f1f8614c2ee65d02f9831ab415d6
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1047-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1047-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1048-oem
Description-md5: 683143259c7092db88ebde49e2e38ef8
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1048-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1048-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1049-oem
Description-md5: c88571a95bba71b588f6a087d577ebc7
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1049-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1049-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1050-oem
Description-md5: 6de9fbb417ed403cbb1243d75177739a
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1050-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1050-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1051-oem
Description-md5: 207981ea9d4e9307afe9d1627ea3c878
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1051-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1051-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1052-oem
Description-md5: 344777bda925c12c9b365c3155e75060
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1052-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1052-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1054-oem
Description-md5: 79d3ecc93d0982113aad8f854838b3d7
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1054-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1054-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1055-oem
Description-md5: 3054d06799edfe42f0a05d5117c0f995
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1055-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1055-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1056-oem
Description-md5: 626e177104a3077df1eea007bc08798a
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1056-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1056-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1057-oem
Description-md5: d876df0e0d344b5b2c2bb242445db3a5
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1057-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1057-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1058-oem
Description-md5: 7f896ad4cad521426b7d6ca8ca9613ca
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1058-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1058-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.14.0-1059-oem
Description-md5: 34f4eb0f1c9993a229aa28f96cf1231e
Description-en: Linux kernel signatures for nvidia modules for version 5.14.0-1059-oem
 This package contains the Linux kernel signatures nvidia modules for
 version 5.14.0-1059-oem.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-100-generic
Description-md5: 3c8af2b81833190f4b030b220bf66911
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-100-generic
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-100-generic.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-100-lowlatency
Description-md5: b4290e6d5e687e49ccdd9c43b1330cb1
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-100-lowlatency
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-100-lowlatency.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1003-intel-iotg
Description-md5: 3dc01a9c0f4b9c595fa277a3d1845664
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1003-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1003-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1006-gcp
Description-md5: fd1d58a932b53315b2781a1766d3ef01
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1006-gcp
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1006-gcp.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1007-azure
Description-md5: d8d769a1ed4fa65443ba82c0157cc2cf
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1007-azure
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1007-azure.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1007-oracle
Description-md5: 4764fe4f2a7548cbdb394e44589b8a05
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1007-oracle
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1007-oracle.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1008-azure
Description-md5: 85ee528fb07b656392807c7734587c59
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1008-azure
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1008-azure.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1008-intel-iotg
Description-md5: 46230df8e1b3b5c672e2c7dedd1096fa
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1008-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1008-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-101-generic
Description-md5: 028666201fceded537ea8b2cb28660f8
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-101-generic
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-101-generic.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-101-lowlatency
Description-md5: 3f37ebbfab4dc4cf6e9c929f1a1690ea
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-101-lowlatency
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-101-lowlatency.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1010-intel-iotg
Description-md5: 4d7a65830c6e32a3f44233ec8c421c8b
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1010-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1010-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1011-aws
Description-md5: 84254e593661e226f66867b9c96a7dac
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1011-aws
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1011-aws.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1012-gcp
Description-md5: 92ed70a464db1914199d1350e1c1bf25
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1012-gcp
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1012-gcp.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1013-azure
Description-md5: 1d41a02009264e19b0b92cf900911e34
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1013-azure
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1013-azure.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1013-gcp
Description-md5: db8221607ad4d9b139eb2be12bb17f5f
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1013-gcp
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1013-gcp.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1013-oracle
Description-md5: 89b8d33ca7564ca3657cf03c1ba548a5
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1013-oracle
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1013-oracle.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1014-aws
Description-md5: fe9ed6e3964916c1c1d2fd50670d9e01
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1014-aws
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1014-aws.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1014-azure
Description-md5: d3267d6ab30903c5ef7635b5b4fad682
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1014-azure
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1014-azure.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1015-aws
Description-md5: e6cd0f65db9e86aa4b61a3f1006897f2
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1015-aws
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1015-aws.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1015-intel-iotg
Description-md5: 0e1bb2fd62994165e2b9dbc1630c7087
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1015-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1015-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1016-gcp
Description-md5: 811b0b0d5cbc8f762fa6f22b3fe09d12
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1016-gcp
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1016-gcp.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1016-intel-iotg
Description-md5: 432674c24deb6ac03d2824da5754ff25
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1016-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1016-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1016-oracle
Description-md5: 647ac0a910a77f19c89bc3fc85056013
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1016-oracle
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1016-oracle.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1017-aws
Description-md5: 1dbf73b31ca69a1b2a2ad4cb5d2fca76
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1017-aws
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1017-aws.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1017-azure
Description-md5: bfe66a361f58b3f826e7573d0a60a3af
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1017-azure
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1017-azure.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1017-gcp
Description-md5: 4b66f00dc02dbaee52cd6a4ae68a6342
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1017-gcp
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1017-gcp.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1017-intel-iotg
Description-md5: a32d3f1c84cee95f7295c0b8410317e0
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1017-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1017-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1017-oracle
Description-md5: 53b5da3c1471345667c5d3a050f33412
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1017-oracle
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1017-oracle.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1018-gcp
Description-md5: 585fd99f7c2f122dc1f94e8fe5e09e06
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1018-gcp
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1018-gcp.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1018-intel-iotg
Description-md5: df48e601579cd7b62220a7d28658d19f
Description-en: Linux kernel signatures for nvidia modules for version 5.15.0-1018-intel-iotg
 This package contains the Linux kernel signatures nvidia modules for
 version 5.15.0-1018-intel-iotg.
 .
 You likely do not want to install this package directly.

Package: linux-signatures-nvidia-5.15.0-1018-oracle
Description-md5: ef9b3e4<?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 Timekeeper
    {
        /**
         * Método para traer los registros de Abogados conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $usrRecId
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function searchTks($dataConnection, $usrRecId, $Answer = "JSON", $encode = "false") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_SearchTks ";
            $query .= "@UsrRecId=".$usrRecId;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsTimekeeper.php, Clase: Timekeeper, Metodo: searchTks, 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[] = array(
                    "recid" => $row["recid"],
                    "known_name" => $encode === "false"? utf8_decode($row["known_name"]) : $row["known_name"],
                    "id" => $row["id"], 
                    "restriction" => $row["restriction"], 
                    "entry_min_days" => $row["entry_min_days"], 
                    "entry_max_days" => $row["entry_max_days"], 
                    "partner_to_report" => $row["partner_to_report"], 
                );
            }

            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);
            
            if( count($rows) === 0 )
            {
                return null;
            }		
            
            return $rows;
        }

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

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_SearchDelegates ";
            $query .= "@UsrRecId=".$usrRecId;
            $query .= ", @freeTKs=".$freeTKs;
            
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsTimekeeper.php, Clase: Timekeeper, Metodo: searchDelegates, 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 el numero de horas para un día determinado de un abogado.
         * 
         * @param array $dataConnection
         * @param string $dateDay   (Nota: formato DD/MM/YYYY)
         * @param integer $tkRecId
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function getHoursDay($dataConnection, $dateDay, $tkRecId, $Answer = "JSON") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_GetHoursDay ";
            $query .= "@theDate='".$dateDay."'";
            $query .= ", @tkRecid=".$tkRecId;
           
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsTimekeeper.php, Clase: Timekeeper, Metodo: getHoursDay, 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 Abogados a Reportar conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $tkRecId
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function getTkToReport($dataConnection, $tkRecId, $Answer = "JSON") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_GetTkToReport ";
            $query .= "@TkRecId=".$tkRecId;
           
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsTimekeeper.php, Clase: Timekeeper, Metodo: getTkToReport, 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 Abogados para Sincronizar tiempos conforme a parametros de búsqueda.
         * 
         * @param array $dataConnection
         * @param integer $tkRecId
         * @param string $Answer    Tipo de respuesta del metodo, default JSON
         * 
         * @return array $rows      En formato JSON o ARRAY
        */
        public function searchTksSync($dataConnection, $tkRecId, $Answer = "JSON", $encode = "false") 
        {
            $db =  new DataBase();
            $db_connect = $db->setConnection($dataConnection);

            if($db_connect == null)
            {
                return $db_connect;
            }
            
            $query = "execute als_SearchTksSync ";
            $query .= "@TkRecId=".$tkRecId;
           
            $resultado  = sqlsrv_query($db_connect, $query);

            if( !$resultado) 
            {
                die( print_r( "\n"."Programa: wsTimekeeper.php, Clase: Timekeeper, Metodo: searchTksSync, 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;
                  $rows[] = array(
                    "recid" => $row["recid"],
                    "id" => $row["id"],
                    "long_name" => $encode === "true"? utf8_decode($row["long_name"]) : $row["long_name"]
                  );
            }
            //mssql_free_result($resultado );		  				

            $db->setDisconnection($db_connect);
            
            if( count($rows) === 0 )
            {
                return null;
            }		
            
            if( $Answer  === "JSON") 
            {
                return _json_encode($rows);
            }
            else
            {
                return $rows;
            }
        }
        
    }