---------------- 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 : 436172 Proximo # De Orden : 436172 -------------- 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('436172','436172','AG','8F3A1','24','W CARREFOUR UBER','C', '829-947-3615','8F3A1 / Uber','','CONSUMO','', '','2026-06-04','19:59','2026-07-16','12:09:15','20:03', '593.2171875','0','0','106.77909375','0','700','0', '0','' ,'' ,'','','','', '','','','','','Uber','' ) header registrado Ultimo ID : 56 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 ("56", "436172", "436172", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("56", "436172", "436172", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("56", "436172", "436172", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("56", "436172", "436172", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("56", "436172", "436172", "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":"436172", "email":"1" } Orden registrada. # Orden Json : 436172 / # Orden Web : 436172 - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---------------- 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 : 436173 Proximo # De Orden : 436173 -------------- 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('436173','436173','AG','8F3A1','24','W CARREFOUR UBER','C', '829-947-3615','8F3A1 / Uber','','CONSUMO','', '','2026-06-04','19:59','2026-07-16','18:10:48','20:03', '593.2171875','0','0','106.77909375','0','700','0', '0','' ,'' ,'','','','', '','','','','','Uber','' ) header registrado Ultimo ID : 57 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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 ("57", "436173", "436173", "24", "829-947-3615", "1100027", "Extra Salsa Bbq", "", "N", "N", "1", "1", "25.42359375", ""), ("57", "436173", "436173", "24", "829-947-3615", "K000001", "Combo Asiago Ranch Emapanizado", "", "S", "N", "2", "1", "567.79359375", ""), ("57", "436173", "436173", "24", "829-947-3615", "X000004", "SIN TOMATE (ING)", "", "N", "S", "3", "1", "0", "K000001"), ("57", "436173", "436173", "24", "829-947-3615", "61012", "BOTELLA COCA COLA", "", "N", "S", "4", "1", "0", "K000001"), ("57", "436173", "436173", "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":"436173", "email":"1" } Orden registrada. # Orden Json : 436173 / # Orden Web : 436173 - - - - - - - - - - - - - - - - - - - - - - - - - - - -