|
spJobFacturaGet
|
00
|
0
|
[]
|
4:26 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:26 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:25 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:25 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:25 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:25 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:24 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:24 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:24 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:23 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:23 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:23 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:23 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:22 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:22 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:22 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:21 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:21 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:21 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:21 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:20 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:20 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:20 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:19 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:19 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:19 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:19 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:18 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:18 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:18 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:17 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:17 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:17 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:17 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:16 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:16 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:16 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:15 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:15 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:15 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:15 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:14 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:14 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:14 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:13 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:13 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:13 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:13 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:12 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:12 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:12 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:11 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:11 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:11 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:11 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:10 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:10 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:10 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:09 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:09 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:09 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:09 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:08 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:08 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:08 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:07 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:07 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:07 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:07 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:06 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:06 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:06 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:06 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:05 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:05 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:05 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:04 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:04 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:04 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:04 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
4:03 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:03:27</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:03:27</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:03:27</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:03:27</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:03:27</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:03 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:03:10</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:03:10</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:03:10</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:03:10</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:03:10</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:03 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:02:53</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:02:53</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:02:53</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:02:53</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:02:53</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:02 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:02:36</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:02:36</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:02:36</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:02:36</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:02:36</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:02 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:02:19</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:02:19</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:02:19</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:02:19</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:02:19</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:02 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:02:03</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:02:03</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:02:03</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:02:03</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:02:03</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:02 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:01:46</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:01:46</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:01:46</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:01:46</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:01:46</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:01 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:01:28</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:01:28</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:01:29</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:01:29</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:01:29</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:01 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:01:11</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:01:11</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:01:12</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:01:12</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:01:12</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:01 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:00:54</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:00:54</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:00:55</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:00:55</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:00:55</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:00 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:00:38</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:00:38</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:00:38</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:00:38</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:00:38</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:00 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:00:21</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:00:21</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:00:21</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:00:21</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:00:21</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:00 PM
|
|
spJobFacturaGet
|
00
|
0
|
<b>2024-11-28 16:00:06</b>: Obteniendo Ultima FA guardada
<b>2024-11-28 16:00:06</b>: Obteniendo facturas de clickeat en BD local
<b>2024-11-28 16:00:07</b>: Facturas en memoria
[{"RowNum":"1","Consecutivo":1646760,"IdFactura":8302847,"Telefono":null,"Nombre":null,"NumeroTarjeta":"5555XXXXXXXX4444","Id_restaurante_cliente":"30","FechaFacturado":"2024-11-28 10:16:20.413","MontoTotal":4850,"CostoEntrega":0,"ImpuestoServicio":0,"ImpuestoVenta":557.9646017699115,"Descuento":0,"IdFormaPago":1,"Correo":null,"Autorizacion":"946634","TipoEntrega":"R","Direccion":{"Nombre_provincia":"SAN JOSE","Nombre_canton":"SAN JOSE","Nombre_distrito":"SAN JOSE","Nombre_barrio":"SAN JOSE","Latitud":9.8556891,"Longitud":-84.1035991,"Direccion":"2km oeste del, Hospital México, San José, Carvajal Castro","Nombre_direccion":"Parque de Diversiones","Punto_referencia":"Recoger","ClienteRegistrado":1},"Comentario":"Sin comentarios","PagaCon":0,"Productos":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1975,"IdProductoCliente":"ND","NombreProducto":"Hut Pack","Precio":4292.035398230089,"Descuento":0,"MontoTotal":4850,"Cantidad":1,"ImpuestoVenta":557.9646017699115,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":4850,"IdIngredientePadre":1975,"EsCombo":true,"EsSeleccionMultiple":false}],"Ingredientes":[{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1986,"IdProductoCliente":"ND","NombreProducto":"Coca cola 16 onz","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false},{"IdFactura":8302847,"IdItem":"AA367CEE-AD03-4014-9FDE-B80989A3C85B","IdProducto":1997,"IdProductoCliente":"ND","NombreProducto":"Hut pack Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":0,"EsSeleccionMultiple":false}],"VersionApp":"1.0.3","Dispositivo":"web"}]
<b>2024-11-28 16:00:07</b>: Insertando facturas de clickeat en BD local
<hr><b>2024-11-28 16:00:07</b>: Error->[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'Telefono', table 'ClickEat.dbo.tbFactura'; column does not allow nulls. INSERT fails.|[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.<hr>
|
4:00 PM
|
|
spJobFacturaGet
|
00
|
0
|
[]
|
3:59 PM
|
|
spFacturaAdd-Ingredientes
|
00
|
8303111
|
[{"IdFactura":8303111,"IdItem":"782F5C06-FC79-422E-B25D-55A1B5934E89","IdProducto":834,"IdProductoCliente":"23024","NombreProducto":"Pizza Grande Pan Pizza Pepperoni","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":750,"EsSeleccionMultiple":false},{"IdFactura":8303111,"IdItem":"782F5C06-FC79-422E-B25D-55A1B5934E89","IdProducto":835,"IdProductoCliente":"23023","NombreProducto":"Pizza Grande Pan Pizza Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":748,"EsSeleccionMultiple":false},{"IdFactura":8303111,"IdItem":"782F5C06-FC79-422E-B25D-55A1B5934E89","IdProducto":835,"IdProductoCliente":"23023","NombreProducto":"Pizza Grande Pan Pizza Jamón","Precio":0,"Descuento":0,"MontoTotal":0,"Cantidad":1,"ImpuestoVenta":0,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":0,"IdIngredientePadre":749,"EsSeleccionMultiple":false}]
|
3:59 PM
|
|
spFacturaAdd-Productos
|
00
|
8303111
|
[{"IdFactura":8303111,"IdItem":"782F5C06-FC79-422E-B25D-55A1B5934E89","IdProducto":838,"IdProductoCliente":"91018","NombreProducto":"3x1 Grandes Pan Pizza","Precio":12831.85840707965,"Descuento":0,"MontoTotal":14500,"Cantidad":1,"ImpuestoVenta":1668.141592920354,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":14500,"IdIngredientePadre":838,"Comentario":"N\/D","EsCombo":true,"EsSeleccionMultiple":false}]
|
3:59 PM
|
|
spFacturaAdd-Direccion
|
00
|
8303111
|
{"Nombre_provincia":"CARTAGO","Nombre_canton":"LA UNION","Nombre_distrito":"SAN RAFAEL","Nombre_barrio":"YERBABUENA","Latitud":9.905740737915039,"Longitud":-83.97888946533203,"Direccion":"Casa G13","Nombre_direccion":"Residencial Estancia la antigua","Punto_referencia":"Casa G13","Id_direccion":231456,"ClienteRegistrado":1}
|
3:59 PM
|
|
spFacturaAdd-Ingredientes
|
00
|
8303112
|
[]
|
3:59 PM
|
|
spFacturaAdd-Productos
|
00
|
8303112
|
[{"IdFactura":8303112,"IdItem":"17EA3594-5CA8-40DE-AB02-E708E83958DC","IdProducto":1764,"IdProductoCliente":"94696","NombreProducto":"Gran Hut Jamón","Precio":3097.345132743363,"Descuento":0,"MontoTotal":3500.000000000001,"Cantidad":1,"ImpuestoVenta":402.6548672566372,"ImpuestoServicio":0,"TipoNodo":"PRO","MontoTotalOriginal":3500.000000000001,"IdIngredientePadre":1764,"Comentario":"N\/D","EsCombo":false,"EsSeleccionMultiple":false}]
|
3:59 PM
|