Reimbursement Queries
GetAllReembolsos
Retrieve all reimbursement requests in the system.
Query:
query {
getAllReembolsos {
idReembolso
cedula
nombres
apellidos
correo
localidad
area
desde
hasta
descripcion
estado
fechaCreacion
observaciones
director
aprobador {
id
nombre
email
}
catalogo {
idCatalogo
nombre
}
}
}
Unique identifier for the reimbursement request
Employee identification number
Location/city of the expense
Description of the reimbursement purpose
Current status (INGRESADO, EN_VALIDACIÓN, APROBADO, RECHAZADO, etc.)
Date the reimbursement was created
Additional observations or notes
Director name for approval chain
User object containing approver information
Catalog entry with reimbursement classification
GetReembolsoById
Retrieve a specific reimbursement request by ID.
Query:
query {
getReembolsoById(id: 123) {
idReembolso
cedula
nombres
apellidos
correo
localidad
area
desde
hasta
descripcion
id_aprobador
id_creador
id_compania
idAnticipos
estado
fechaCreacion
observaciones
}
}
The unique identifier of the reimbursement request
IndReReembolsoDTO object with the same fields as GetAllReembolsos.
Source: Schema/Query/Query.cs:1016-1019
GetAllReembolsosByUser
Retrieve all reimbursement requests for a specific user.
Query:
query {
getAllReembolsosByUser(id: 5, correo: "employee@example.com") {
idReembolso
nombres
apellidos
descripcion
estado
fechaCreacion
aprobador {
nombre
email
}
}
}
The user ID of the employee who created the reimbursements
The email address of the employee
GetAllReembolsosByCorreo
Retrieve all reimbursement requests by email address only.
Query:
query {
getAllReembolsosByCorreo(correo: "employee@example.com") {
idReembolso
descripcion
estado
fechaCreacion
}
}
The email address of the employee
GetAllReembolsoByUser
Retrieve a specific reimbursement request for a user.
Query:
query {
getAllReembolsoByUser(id: 5, id_reem: 123, correo: "employee@example.com") {
idReembolso
descripcion
estado
aprobador {
nombre
}
catalogo {
nombre
}
}
}
The user ID of the employee
The reimbursement ID to retrieve
The email address of the employee
GetAllReembolsosByAprobador
Retrieve all reimbursement requests assigned to a specific approver.
Query:
query {
getAllReembolsosByAprobador(id: 10) {
idReembolso
nombres
apellidos
descripcion
estado
fechaCreacion
}
}
The user ID of the approver
GetAllReembolsoByAprobador
Retrieve a specific reimbursement request for an approver.
Query:
query {
getAllReembolsoByAprobador(id: 10, id_reem: 123) {
idReembolso
descripcion
estado
nombres
apellidos
}
}
The user ID of the approver
The reimbursement ID to retrieve
Expense Detail Queries
GetAllDetalles
Retrieve all expense details across all reimbursement requests.
Query:
query {
getAllDetalles {
idDetalle
id_reembolso
fechaRegistro
fechaEmision
totalFactura
baseIvaCero
baseIva
totalIva
numDocumento
ruc
archivo
reembolso {
idReembolso
nombres
apellidos
aprobador {
nombre
}
}
}
}
Unique identifier for the expense detail
Foreign key to the parent reimbursement request
Date the expense was registered in the system
Date on the receipt/invoice
Total amount of the invoice/receipt
Tax base amount at 0% IVA rate
Tax base amount subject to IVA
Tax ID (RUC) of the vendor
Path to the uploaded receipt/invoice file
GetAllDetallesByIdReembolso
Retrieve all expense details for a specific reimbursement request.
Query:
query {
getAllDetallesByIdReembolso(id: 123) {
idDetalle
fechaEmision
totalFactura
numDocumento
ruc
tipoGasto {
nombre
}
tipoDocumento {
nombre
}
grupoGasto {
nombre
}
grupoDocumento {
nombre
}
}
}
The reimbursement ID to retrieve details for
GetDetallesSumado
Get the total sum of expenses for all reimbursement requests.
Query:
query {
getDetallesSumado {
id_reembolso
sumaTotal
}
}
Total sum of all expense details for this reimbursement
GetDetallesByIdUsuarioSumado
Get expense totals for a specific user’s reimbursement requests.
Query:
query {
getDetallesByIdUsuarioSumado(id: 5, correo: "employee@example.com") {
id_reembolso
sumaTotal
}
}
GetDetallesByIdAprobadorSumado
Get expense totals for reimbursements assigned to an approver.
Query:
query {
getDetallesByIdAprobadorSumado(id: 10) {
id_reembolso
sumaTotal
}
}
