---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "24",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 8299473615",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436180
Proximo # De Orden : 436180
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436180','436180','AG','8F3A1','24','W CARREFOUR UBER','C',
'829-947-3615','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','07:05:27','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
Ultimo ID : 64
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("64", "436180", "436180", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("64", "436180", "436180", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("64", "436180", "436180", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("64", "436180", "436180", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("64", "436180", "436180", "24", "829-947-3615", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436180",
"email":"1"
}
Orden registrada. # Orden Json : 436180 / # Orden Web : 436180
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------- J S O N R E C I B I D O ----------------
json vacio
Se envio correo para notificar Api : Se recibio un JSON VACIO en Notificacion_orden.php
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "99",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 111-222-3333",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "24",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 8299473615",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
Orden Agregador, se asigno nuevo numero de Orden : 436181
Proximo # De Orden : 436181
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436181','436181','AG','8F3A1','99','W CARREFOUR UBER','C',
'111-222-3333','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','07:05:33','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436182
Proximo # De Orden : 436182
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436182','436182','AG','8F3A1','24','W CARREFOUR UBER','C',
'829-947-3615','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','07:05:33','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
header registrado
Ultimo ID : 66
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("66", "436182", "436182", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("66", "436182", "436182", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("66", "436182", "436182", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("66", "436182", "436182", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("66", "436182", "436182", "24", "829-947-3615", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Ultimo ID : 65
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("65", "436181", "436181", "99", "111-222-3333", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("65", "436181", "436181", "99", "111-222-3333", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("65", "436181", "436181", "99", "111-222-3333", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("65", "436181", "436181", "99", "111-222-3333", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("65", "436181", "436181", "99", "111-222-3333", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436182",
"email":"1"
}
Orden registrada. # Orden Json : 436182 / # Orden Web : 436182
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Detalle registrado
Retorno : {
"status":"200",
"orden":"436181",
"email":"1"
}
Orden registrada. # Orden Json : 436181 / # Orden Web : 436181
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "24",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 8299473615",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436183
Proximo # De Orden : 436183
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436183','436183','AG','8F3A1','24','W CARREFOUR UBER','C',
'829-947-3615','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','07:05:33','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
Ultimo ID : 67
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("67", "436183", "436183", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("67", "436183", "436183", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("67", "436183", "436183", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("67", "436183", "436183", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("67", "436183", "436183", "24", "829-947-3615", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436183",
"email":"1"
}
Orden registrada. # Orden Json : 436183 / # Orden Web : 436183
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "99",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 111-222-3333",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436184
Proximo # De Orden : 436184
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436184','436184','AG','8F3A1','99','W CARREFOUR UBER','C',
'111-222-3333','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','07:05:33','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
Ultimo ID : 68
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("68", "436184", "436184", "99", "111-222-3333", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("68", "436184", "436184", "99", "111-222-3333", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("68", "436184", "436184", "99", "111-222-3333", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("68", "436184", "436184", "99", "111-222-3333", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("68", "436184", "436184", "99", "111-222-3333", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436184",
"email":"1"
}
Orden registrada. # Orden Json : 436184 / # Orden Web : 436184
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "24",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 8299473615",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436185
Proximo # De Orden : 436185
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436185','436185','AG','8F3A1','24','W CARREFOUR UBER','C',
'829-947-3615','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','12:14:17','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
Ultimo ID : 69
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("69", "436185", "436185", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("69", "436185", "436185", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("69", "436185", "436185", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("69", "436185", "436185", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("69", "436185", "436185", "24", "829-947-3615", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436185",
"email":"1"
}
Orden registrada. # Orden Json : 436185 / # Orden Web : 436185
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "99",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 111-222-3333",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436186
Proximo # De Orden : 436186
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436186','436186','AG','8F3A1','99','W CARREFOUR UBER','C',
'111-222-3333','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','19:43:02','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
Ultimo ID : 70
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("70", "436186", "436186", "99", "111-222-3333", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("70", "436186", "436186", "99", "111-222-3333", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("70", "436186", "436186", "99", "111-222-3333", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("70", "436186", "436186", "99", "111-222-3333", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("70", "436186", "436186", "99", "111-222-3333", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436186",
"email":"1"
}
Orden registrada. # Orden Json : 436186 / # Orden Web : 436186
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------- J S O N R E C I B I D O ----------------
{
"orden": "8F3A1",
"canal": "AG",
"tipo_fac": "",
"cod_unidad": "24",
"nom_unidad": "W Carrefour UBER",
"email": "",
"telefono": " 8299473615",
"nombre": "Michelle J.",
"calle": "",
"sector": "",
"casa": "",
"numero": "",
"comentario1": "",
"comentario2": "",
"comentario3": "",
"comentario4": "",
"tiponcf": "CONSUMO",
"rnc": "",
"razonsocial": "",
"fecha": "2026-06-04",
"hora": "19:59",
"hora_entrega": "2026-06-04T20:03:27-04:00",
"subtotal": 0,
"valor_descuento": 0,
"porciento_descuento": 0,
"itbis": 0,
"propina": 0,
"total": 700,
"forma_pago": "",
"cambio_efectivo": 0,
"recargo": 0,
"referencia": "Uber",
"infoComprobante": null,
"aprobacion": null,
"address": [
{
"formatted": "",
"countryCode": "592 55 232",
"city": "",
"street": "",
"number": "",
"apt": "",
"floor": "",
"entrance": "",
"pobox": "",
"comment": "",
"latLng": {
"lat": "",
"lng": ""
}
}
],
"members": [
{
"linea": 1,
"grupolinea": 1,
"plu": "1100027",
"descripcion": "Extra Salsa Bbq",
"cantidad": 1,
"precio": 30,
"ind_kit": "N",
"padre": ""
},
{
"linea": 2,
"grupolinea": 3,
"plu": "K000001",
"descripcion": "Combo Asiago Ranch Emapanizado",
"cantidad": 1,
"precio": 670,
"ind_kit": "S",
"padre": ""
},
{
"linea": 3,
"grupolinea": 3,
"plu": "X000004",
"descripcion": "SIN TOMATE (ING)",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 4,
"grupolinea": 3,
"plu": "61012",
"descripcion": "BOTELLA COCA COLA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
},
{
"linea": 5,
"grupolinea": 3,
"plu": "0900002",
"descripcion": "PAPAS MEDIANA",
"cantidad": 1,
"precio": 0,
"ind_kit": "N",
"padre": "K000001"
}
]
}
--------- Configuracion de Impuestos ---------
porc_itbis : 0.18
porc_propina : 0.1
factor_precio : 8.474
totalporcimpuestos : 1.28
Orden Agregador, se asigno nuevo numero de Orden : 436187
Proximo # De Orden : 436187
-------------- Insertar header orden -----------
sql insert into orden1d (orden_app,orden_web,canal,referencia,COD_UNIDAD,NOM_UNIDAD,TIPO_FAC,
TELEFONO,CLIENTE,EMAIL,TIPONCF,RNCCUST,
NOMCUST,FECHA,HORA,FECHA_BD,HORA_BD,HORA_ENTREGA,
SUBTOTAL,
DESCUENTO,PORC_DESCUENTO,ITBIS,PROPINA,VALOR,PAGO_EFECTIVO,PAGO_TARJETACREDITO,FORMA_PAGO,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE)
values('436187','436187','AG','8F3A1','24','W CARREFOUR UBER','C',
'829-947-3615','8F3A1 / Uber','','CONSUMO','',
'','2026-06-04','19:59','2026-07-19','20:06:05','20:03',
'593.2171875','0','0','106.77909375','0','700','0',
'0','' ,'' ,'','','','',
'','','','','','Uber',''
)
header registrado
Ultimo ID : 71
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
formatted :
countryCode : 592 55 232
city :
street :
number :
floor :
latLng : Array
comment :
-------------- Insertar detalle orden -----------
insert into orden2d (ID_ORDEN_ID,orden_app,orden_web,cod_unidad,telefono,plu,descri,kit,ind_kit,detallekit,linea,cantidad,precio,padre) values ("71", "436187", "436187", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("71", "436187", "436187", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("71", "436187", "436187", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("71", "436187", "436187", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("71", "436187", "436187", "24", "829-947-3615", "0900002", "PAPAS MEDIANA", "", "N", "S", "5", "1", "0", "K000001")
1- 1100027 Extra Salsa Bbq : 1 * 30 = 30
2- K000001 Combo Asiago Ranch Emapanizado : 1 * 670 = 670
3- X000004 SIN TOMATE (ING) : 1 * 0 = 0
4- 61012 BOTELLA COCA COLA : 1 * 0 = 0
5- 0900002 PAPAS MEDIANA : 1 * 0 = 0
Detalle registrado
Retorno : {
"status":"200",
"orden":"436187",
"email":"1"
}
Orden registrada. # Orden Json : 436187 / # Orden Web : 436187
- - - - - - - - - - - - - - - - - - - - - - - - - - - -