---------------- J S O N R E C I B I D O ---------------- { "orden": "2032138565", "canal": "AG", "tipo_fac": "", "cod_unidad": "99", "nom_unidad": "Mega Centro - Pedidos Ya", "email": "", "telefono": "809-6202020", "nombre": "pruerba d eorden", "calle": "", "sector": "", "casa": "", "numero": "", "comentario1": "", "comentario2": "Medio de pago: MASTERCARD", "comentario3": "", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-06-04", "hora": "19:59", "hora_entrega": "2026-06-05T00:36:43.000Z", "subtotal": 1800, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1800, "forma_pago": "", "cambio_efectivo": 0, "recargo": 0, "referencia": "Pedidos Ya", "infoComprobante": null, "aprobacion": null, "address": [ { "formatted": "", "countryCode": "", "city": "", "street": "", "number": "", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "", "latLng": { "lat": "", "lng": "" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000947", "descripcion": "Double Box: 2 Pizzas Medianas Pan 1 ing. + Refresco 1.25L ", "cantidad": 1, "precio": 1430, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100185", "descripcion": "BASICA 1 ING MED PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000947" }, { "linea": 3, "grupolinea": 1, "plu": "0700065", "descripcion": "ING SOLO TOCINETA MED", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000947" }, { "linea": 4, "grupolinea": 1, "plu": "0100185", "descripcion": "BASICA 1 ING MED PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000947" }, { "linea": 5, "grupolinea": 1, "plu": "0700048", "descripcion": "ING SOLO PEPPERONI MED", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000947" }, { "linea": 6, "grupolinea": 1, "plu": "20748", "descripcion": "1.25 LITRO COCA COLA", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000947" }, { "linea": 7, "grupolinea": 2, "plu": "0200065", "descripcion": "Cheesesticks", "cantidad": 1, "precio": 370, "ind_kit": "N", "padre": "" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1800 totalporcimpuestos : 1.28 Orden Agregador, se asigno nuevo numero de Orden : 138339 Proximo # De Orden : 138339 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('138339','138339','AG','138565','99','MEGA CENTRO - PEDIDOS YA','C', '809-620-2020','138565 / Pedidos Ya','','CONSUMO','', '','2026-06-04','19:59','2026-07-15','16:52:30','', '1525.415625','0','0','274.5748125','0','1800','0', '0','','','','' ,'','','','', '','MEDIO DE PAGO: MASTERCARD','','','','Pedidos Ya','','0' ) Header Registrado Ultimo ID : 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - formatted : countryCode : city : street : number : floor : lat : lng : 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 ("1", "138339", "138339", "99", "809-620-2020", "K000947", "Double Box: 2 Pizzas Medianas Pan 1 ing. + Refresc", "K000947", "S", "N", "1", "1", "1211.85796875", ""), ("1", "138339", "138339", "99", "809-620-2020", "0100185", "BASICA 1 ING MED PAN", "K000947", "N", "S", "2", "1", "0", "K000947"), ("1", "138339", "138339", "99", "809-620-2020", "0700065", "ING SOLO TOCINETA MED", "K000947", "N", "S", "3", "1", "0", "K000947"), ("1", "138339", "138339", "99", "809-620-2020", "0100185", "BASICA 1 ING MED PAN", "K000947", "N", "S", "4", "1", "0", "K000947"), ("1", "138339", "138339", "99", "809-620-2020", "0700048", "ING SOLO PEPPERONI MED", "K000947", "N", "S", "5", "1", "0", "K000947"), ("1", "138339", "138339", "99", "809-620-2020", "20748", "1.25 LITRO COCA COLA", "K000947", "N", "S", "6", "1", "0", "K000947"), ("1", "138339", "138339", "99", "809-620-2020", "0200065", "Cheesesticks", "", "N", "N", "7", "1", "313.55765625", "") 1- K000947 Double Box: 2 Pizzas Medianas Pan 1 ing. + Refresco 1.25L : 1 * 1430 = 1430 2- 0100185 BASICA 1 ING MED PAN : 1 * 0 = 0 3- 0700065 ING SOLO TOCINETA MED : 1 * 0 = 0 4- 0100185 BASICA 1 ING MED PAN : 1 * 0 = 0 5- 0700048 ING SOLO PEPPERONI MED : 1 * 0 = 0 6- 20748 1.25 LITRO COCA COLA : 1 * 0 = 0 7- 0200065 Cheesesticks : 1 * 370 = 370 Detalle Registrado Retorno : { "status":"200", "orden":"138339", "email":"1" } Orden registrada. # Orden Json : 138339 / # Orden Web : 138339 - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---------------- J S O N R E C I B I D O ---------------- { "orden": "254022174", "canal": "Web", "tipo_fac": "D", "cod_unidad": "99", "nom_unidad": "DESARROLLO", "email": "albaalbuez@gmail.com", "telefono": " 8293191997", "nombre": "Alba Albuez", "calle": "Calle Danae", "sector": "", "casa": "", "numero": "19", "comentario1": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "comentario2": "", "comentario3": "No", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-07-14", "hora": "20:00", "hora_entrega": "00:00", "subtotal": 0, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1440, "forma_pago": "TARJETA", "cambio_efectivo": 0, "recargo": 95, "referencia": "", "infoComprobante": null, "aprobacion": "", "address": [ { "formatted": "C. Danae 19, Santo Domingo, República Dominicana", "countryCode": "DO", "city": "Santo Domingo", "street": "Calle Danae", "number": "19", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "latLng": { "lat": "18.4677404", "lng": "-69.8968101" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000029", "descripcion": "2 Pizzas Grande 1 Ing.", "cantidad": 1, "precio": 1345, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 3, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 4, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 5, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 6, "grupolinea": 1, "plu": "0700053", "descripcion": "ING SOLO JAMON GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 7, "grupolinea": 1, "plu": "0700085", "descripcion": "ING SOLO MAIZ GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1440 totalporcimpuestos : 1.28 Proximo # De Orden : 138340 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('022174','138340','WEB','022174','99','DESARROLLO','D', '829-319-1997','ALBA ALBUEZ','albaalbuez@gmail.com','CONSUMO','', '','2026-07-14','20:00','2026-07-15','17:37:45','00:00', '1139.824453125','0','0','222.2684015625','0','1440','0', '0','TARJETA','TARJETA','','18.4677404' ,'-69.8968101','SANTO DOMINGO','CALLE DANAE','19', '','CASA ROSADA, FRENTE A LA OFICINA NACIONA','L DE DEFENSA PúBLICA','','TARJETA','','','95' ) ---------------- J S O N R E C I B I D O ---------------- { "orden": "254022174", "canal": "Web", "tipo_fac": "D", "cod_unidad": "99", "nom_unidad": "DESARROLLO", "email": "albaalbuez@gmail.com", "telefono": " 8293191997", "nombre": "Alba Albuez", "calle": "Calle Danae", "sector": "", "casa": "", "numero": "19", "comentario1": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "comentario2": "", "comentario3": "No", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-07-14", "hora": "20:00", "hora_entrega": "00:00", "subtotal": 0, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1440, "forma_pago": "TARJETA", "cambio_efectivo": 0, "recargo": 95, "referencia": "", "infoComprobante": null, "aprobacion": "", "address": [ { "formatted": "C. Danae 19, Santo Domingo, República Dominicana", "countryCode": "DO", "city": "Santo Domingo", "street": "Calle Danae", "number": "19", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "latLng": { "lat": "18.4677404", "lng": "-69.8968101" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000029", "descripcion": "2 Pizzas Grande 1 Ing.", "cantidad": 1, "precio": 1345, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 3, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 4, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 5, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 6, "grupolinea": 1, "plu": "0700053", "descripcion": "ING SOLO JAMON GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 7, "grupolinea": 1, "plu": "0700085", "descripcion": "ING SOLO MAIZ GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1440 totalporcimpuestos : 1.28 Proximo # De Orden : 138341 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('022174','138341','WEB','022174','99','DESARROLLO','D', '829-319-1997','ALBA ALBUEZ','albaalbuez@gmail.com','CONSUMO','', '','2026-07-14','20:00','2026-07-15','17:38:16','00:00', '1139.824453125','0','0','222.2684015625','0','1440','0', '0','TARJETA','TARJETA','','18.4677404' ,'-69.8968101','SANTO DOMINGO','CALLE DANAE','19', '','CASA ROSADA, FRENTE A LA OFICINA NACIONA','L DE DEFENSA PúBLICA','','TARJETA','','','95' ) ---------------- J S O N R E C I B I D O ---------------- { "orden": "254022174", "canal": "Web", "tipo_fac": "D", "cod_unidad": "99", "nom_unidad": "DESARROLLO", "email": "albaalbuez@gmail.com", "telefono": " 8293191997", "nombre": "Alba Albuez", "calle": "Calle Danae", "sector": "", "casa": "", "numero": "19", "comentario1": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "comentario2": "", "comentario3": "No", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-07-14", "hora": "20:00", "hora_entrega": "00:00", "subtotal": 0, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1440, "forma_pago": "TARJETA", "cambio_efectivo": 0, "recargo": 95, "referencia": "", "infoComprobante": null, "aprobacion": "", "address": [ { "formatted": "C. Danae 19, Santo Domingo, República Dominicana", "countryCode": "DO", "city": "Santo Domingo", "street": "Calle Danae", "number": "19", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "latLng": { "lat": "18.4677404", "lng": "-69.8968101" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000029", "descripcion": "2 Pizzas Grande 1 Ing.", "cantidad": 1, "precio": 1345, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 3, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 4, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 5, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 6, "grupolinea": 1, "plu": "0700053", "descripcion": "ING SOLO JAMON GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 7, "grupolinea": 1, "plu": "0700085", "descripcion": "ING SOLO MAIZ GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1440 totalporcimpuestos : 1.28 Proximo # De Orden : 138342 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('022174','138342','WEB','022174','99','DESARROLLO','D', '829-319-1997','ALBA ALBUEZ','albaalbuez@gmail.com','CONSUMO','', '','2026-07-14','20:00','2026-07-15','17:43:43','00:00', '1139.824453125','0','0','222.2684015625','0','1440','0', '0','TARJETA','TARJETA','','18.4677404' ,'-69.8968101','SANTO DOMINGO','CALLE DANAE','19', '','CASA ROSADA, FRENTE A LA OFICINA NACIONA','L DE DEFENSA PúBLICA','','TARJETA','','','95' ) Header Registrado Ultimo ID : 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - formatted : C. Danae 19, Santo Domingo, República Dominicana countryCode : DO city : Santo Domingo street : Calle Danae number : 19 floor : lat : 18.4677404 lng : -69.8968101 comment : Casa rosada, frente a la Oficina Nacional de Defensa Pública -------------- 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 ("1", "022174", "138342", "99", "829-319-1997", "K000029", "2 Pizzas Grande 1 Ing.", "K000029", "S", "N", "1", "1", "1139.824453125", ""), ("1", "022174", "138342", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "2", "1", "0", "K000029"), ("1", "022174", "138342", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "3", "1", "0", "K000029"), ("1", "022174", "138342", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "4", "1", "0", "K000029"), ("1", "022174", "138342", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "5", "1", "0", "K000029"), ("1", "022174", "138342", "99", "829-319-1997", "0700053", "ING SOLO JAMON GDE", "K000029", "N", "S", "6", "1", "0", "K000029"), ("1", "022174", "138342", "99", "829-319-1997", "0700085", "ING SOLO MAIZ GDE", "K000029", "N", "S", "7", "1", "0", "K000029") 1- K000029 2 Pizzas Grande 1 Ing. : 1 * 1345 = 1345 2- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 3- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 4- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 5- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 6- 0700053 ING SOLO JAMON GDE : 1 * 0 = 0 7- 0700085 ING SOLO MAIZ GDE : 1 * 0 = 0 Detalle Registrado Retorno : { "status":"200", "orden":"138342", "email":"1" } Orden registrada. # Orden Json : 022174 / # Orden Web : 138342 - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---------------- J S O N R E C I B I D O ---------------- { "orden": "254022174", "canal": "Web", "tipo_fac": "D", "cod_unidad": "99", "nom_unidad": "DESARROLLO", "email": "albaalbuez@gmail.com", "telefono": " 8293191997", "nombre": "Alba Albuez", "calle": "Calle Danae", "sector": "", "casa": "", "numero": "19", "comentario1": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "comentario2": "", "comentario3": "No", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-07-14", "hora": "20:00", "hora_entrega": "00:00", "subtotal": 0, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1440, "forma_pago": "TARJETA", "cambio_efectivo": 0, "recargo": 95, "referencia": "", "infoComprobante": null, "aprobacion": "", "address": [ { "formatted": "C. Danae 19, Santo Domingo, República Dominicana", "countryCode": "DO", "city": "Santo Domingo", "street": "Calle Danae", "number": "19", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "latLng": { "lat": "18.4677404", "lng": "-69.8968101" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000029", "descripcion": "2 Pizzas Grande 1 Ing.", "cantidad": 1, "precio": 1345, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 3, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 4, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 5, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 6, "grupolinea": 1, "plu": "0700053", "descripcion": "ING SOLO JAMON GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 7, "grupolinea": 1, "plu": "0700085", "descripcion": "ING SOLO MAIZ GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1440 totalporcimpuestos : 1.28 Proximo # De Orden : 138343 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('022174','138343','WEB','022174','99','DESARROLLO','D', '829-319-1997','ALBA ALBUEZ','albaalbuez@gmail.com','CONSUMO','', '','2026-07-14','20:00','2026-07-15','17:47:00','00:00', '1139.824453125','0','0','222.2684015625','0','1440','0', '0','TARJETA','TARJETA','','18.4677404' ,'-69.8968101','S','CALLE DANAE','19', '','CASA ROSADA, FRENTE A LA OFICINA NACIONA','L DE DEFENSA PúBLICA','','TARJETA','','','95' ) Header Registrado Ultimo ID : 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - formatted : C. Danae 19, Santo Domingo, República Dominicana countryCode : DO city : Santo Domingo street : Calle Danae number : 19 floor : lat : 18.4677404 lng : -69.8968101 comment : Casa rosada, frente a la Oficina Nacional de Defensa Pública -------------- 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 ("1", "022174", "138343", "99", "829-319-1997", "K000029", "2 Pizzas Grande 1 Ing.", "K000029", "S", "N", "1", "1", "1139.824453125", ""), ("1", "022174", "138343", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "2", "1", "0", "K000029"), ("1", "022174", "138343", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "3", "1", "0", "K000029"), ("1", "022174", "138343", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "4", "1", "0", "K000029"), ("1", "022174", "138343", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "5", "1", "0", "K000029"), ("1", "022174", "138343", "99", "829-319-1997", "0700053", "ING SOLO JAMON GDE", "K000029", "N", "S", "6", "1", "0", "K000029"), ("1", "022174", "138343", "99", "829-319-1997", "0700085", "ING SOLO MAIZ GDE", "K000029", "N", "S", "7", "1", "0", "K000029") 1- K000029 2 Pizzas Grande 1 Ing. : 1 * 1345 = 1345 2- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 3- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 4- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 5- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 6- 0700053 ING SOLO JAMON GDE : 1 * 0 = 0 7- 0700085 ING SOLO MAIZ GDE : 1 * 0 = 0 Detalle Registrado Retorno : { "status":"200", "orden":"138343", "email":"1" } Orden registrada. # Orden Json : 022174 / # Orden Web : 138343 - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---------------- J S O N R E C I B I D O ---------------- { "orden": "254022174", "canal": "Web", "tipo_fac": "D", "cod_unidad": "99", "nom_unidad": "DESARROLLO", "email": "albaalbuez@gmail.com", "telefono": " 8293191997", "nombre": "Alba Albuez", "calle": "Calle Danae", "sector": "", "casa": "", "numero": "19", "comentario1": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "comentario2": "", "comentario3": "No", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-07-14", "hora": "20:00", "hora_entrega": "00:00", "subtotal": 0, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1440, "forma_pago": "TARJETA", "cambio_efectivo": 0, "recargo": 95, "referencia": "", "infoComprobante": null, "aprobacion": "", "address": [ { "formatted": "C. Danae 19, Santo Domingo, República Dominicana", "countryCode": "DO", "city": "Santo Domingo", "street": "Calle Danae", "number": "19", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "latLng": { "lat": "18.4677404", "lng": "-69.8968101" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000029", "descripcion": "2 Pizzas Grande 1 Ing.", "cantidad": 1, "precio": 1345, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 3, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 4, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 5, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 6, "grupolinea": 1, "plu": "0700053", "descripcion": "ING SOLO JAMON GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 7, "grupolinea": 1, "plu": "0700085", "descripcion": "ING SOLO MAIZ GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1440 totalporcimpuestos : 1.28 Proximo # De Orden : 138344 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('022174','138344','WEB','022174','99','DESARROLLO','D', '829-319-1997','ALBA ALBUEZ','albaalbuez@gmail.com','C','', '','2026-07-14','20:00','2026-07-15','17:52:28','00:00', '1139.824453125','0','0','222.2684015625','0','1440','0', '0','TARJETA','TARJETA','','18.4677404' ,'-69.8968101','S','CALLE DANAE','19', '','CASA ROSADA, FRENTE A LA OFICINA NACIONA','L DE DEFENSA PúBLICA','','TARJETA','','','95' ) Header Registrado Ultimo ID : 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - formatted : C. Danae 19, Santo Domingo, República Dominicana countryCode : DO city : Santo Domingo street : Calle Danae number : 19 floor : lat : 18.4677404 lng : -69.8968101 comment : Casa rosada, frente a la Oficina Nacional de Defensa Pública -------------- 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 ("1", "022174", "138344", "99", "829-319-1997", "K000029", "2 Pizzas Grande 1 Ing.", "K000029", "S", "N", "1", "1", "1139.824453125", ""), ("1", "022174", "138344", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "2", "1", "0", "K000029"), ("1", "022174", "138344", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "3", "1", "0", "K000029"), ("1", "022174", "138344", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "4", "1", "0", "K000029"), ("1", "022174", "138344", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "5", "1", "0", "K000029"), ("1", "022174", "138344", "99", "829-319-1997", "0700053", "ING SOLO JAMON GDE", "K000029", "N", "S", "6", "1", "0", "K000029"), ("1", "022174", "138344", "99", "829-319-1997", "0700085", "ING SOLO MAIZ GDE", "K000029", "N", "S", "7", "1", "0", "K000029") 1- K000029 2 Pizzas Grande 1 Ing. : 1 * 1345 = 1345 2- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 3- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 4- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 5- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 6- 0700053 ING SOLO JAMON GDE : 1 * 0 = 0 7- 0700085 ING SOLO MAIZ GDE : 1 * 0 = 0 Detalle Registrado Retorno : { "status":"200", "orden":"138344", "email":"1" } Orden registrada. # Orden Json : 022174 / # Orden Web : 138344 - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---------------- J S O N R E C I B I D O ---------------- { "orden": "254022174", "canal": "Web", "tipo_fac": "D", "cod_unidad": "99", "nom_unidad": "DESARROLLO", "email": "albaalbuez@gmail.com", "telefono": " 8293191997", "nombre": "Alba Albuez", "calle": "Calle Danae", "sector": "", "casa": "", "numero": "19", "comentario1": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "comentario2": "", "comentario3": "No", "comentario4": "", "tiponcf": "CONSUMO", "rnc": "", "razonsocial": "", "fecha": "2026-07-14", "hora": "20:00", "hora_entrega": "00:00", "subtotal": 0, "valor_descuento": 0, "porciento_descuento": 0, "itbis": 0, "propina": 0, "total": 1440, "forma_pago": "TARJETA", "cambio_efectivo": 0, "recargo": 95, "referencia": "", "infoComprobante": null, "aprobacion": "", "address": [ { "formatted": "C. Danae 19, Santo Domingo, República Dominicana", "countryCode": "DO", "city": "Santo Domingo", "street": "Calle Danae", "number": "19", "apt": "", "floor": "", "entrance": "", "pobox": "", "comment": "Casa rosada, frente a la Oficina Nacional de Defensa Pública", "latLng": { "lat": "18.4677404", "lng": "-69.8968101" } } ], "members": [ { "linea": 1, "grupolinea": 1, "plu": "K000029", "descripcion": "2 Pizzas Grande 1 Ing.", "cantidad": 1, "precio": 1345, "ind_kit": "S", "padre": "" }, { "linea": 2, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 3, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 4, "grupolinea": 1, "plu": "0700047", "descripcion": "ING SOLO PEPPERONI GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 5, "grupolinea": 1, "plu": "0100182", "descripcion": "BASICA 1 ING GDE PAN", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 6, "grupolinea": 1, "plu": "0700053", "descripcion": "ING SOLO JAMON GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" }, { "linea": 7, "grupolinea": 1, "plu": "0700085", "descripcion": "ING SOLO MAIZ GDE", "cantidad": 1, "precio": 0, "ind_kit": "N", "padre": "K000029" } ] } --------- Configuracion de Impuestos --------- porc_itbis : 0.18 porc_propina : 0.1 factor_precio : 8.474 Valor descuento : 0 Porciento descuento : 0 Total Orden : 1440 totalporcimpuestos : 1.28 Proximo # De Orden : 138345 -------------- 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,TCNO,TCAPROB,GEOLOCATION_LATITUD,GEOLOCATION_LONGITUD,CIUDAD,CALLE,CASA,SECTOR,COMENTA1,COMENTA2,COMENTA3,COMENTA4,CANALNOMBRE,INFOCOMPROBANTE,RECARGO) values('022174','138345','WEB','022174','99','DESARROLLO','D', '829-319-1997','ALBA ALBUEZ','albaalbuez@gmail.com','C','', '','2026-07-14','20:00','2026-07-15','19:42:39','00:00', '1139.824453125','0','0','222.2684015625','0','1440','0', '0','TARJETA','TARJETA','','18.4677404' ,'-69.8968101','S','CALLE DANAE','19', '','CASA ROSADA, FRENTE A LA OFICINA NACIONA','L DE DEFENSA PúBLICA','','TARJETA','','','95' ) Header Registrado Ultimo ID : 2 - - - - - - - - - - - - - - - - - - - - - - - - - - - - formatted : C. Danae 19, Santo Domingo, República Dominicana countryCode : DO city : Santo Domingo street : Calle Danae number : 19 floor : lat : 18.4677404 lng : -69.8968101 comment : Casa rosada, frente a la Oficina Nacional de Defensa Pública -------------- 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 ("2", "022174", "138345", "99", "829-319-1997", "K000029", "2 Pizzas Grande 1 Ing.", "K000029", "S", "N", "1", "1", "1139.824453125", ""), ("2", "022174", "138345", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "2", "1", "0", "K000029"), ("2", "022174", "138345", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "3", "1", "0", "K000029"), ("2", "022174", "138345", "99", "829-319-1997", "0700047", "ING SOLO PEPPERONI GDE", "K000029", "N", "S", "4", "1", "0", "K000029"), ("2", "022174", "138345", "99", "829-319-1997", "0100182", "BASICA 1 ING GDE PAN", "K000029", "N", "S", "5", "1", "0", "K000029"), ("2", "022174", "138345", "99", "829-319-1997", "0700053", "ING SOLO JAMON GDE", "K000029", "N", "S", "6", "1", "0", "K000029"), ("2", "022174", "138345", "99", "829-319-1997", "0700085", "ING SOLO MAIZ GDE", "K000029", "N", "S", "7", "1", "0", "K000029") 1- K000029 2 Pizzas Grande 1 Ing. : 1 * 1345 = 1345 2- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 3- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 4- 0700047 ING SOLO PEPPERONI GDE : 1 * 0 = 0 5- 0100182 BASICA 1 ING GDE PAN : 1 * 0 = 0 6- 0700053 ING SOLO JAMON GDE : 1 * 0 = 0 7- 0700085 ING SOLO MAIZ GDE : 1 * 0 = 0 Detalle Registrado Retorno : { "status":"200", "orden":"138345", "email":"1" } Orden registrada. # Orden Json : 022174 / # Orden Web : 138345 - - - - - - - - - - - - - - - - - - - - - - - - - - - -