jonandres45
/ gist:4285df5716d6235a33fa22eb9abf5309
Created
March 17, 2026 19:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| else if (agregador == 2 | |
| && item.getItemId().equals("PROMO-2PM1PA4")) { | |
| Coupon orderItem = new Coupon(); | |
| orderItem.setCode("2PM1PA4"); | |
| cuponList.add(orderItem); | |
| }else if (agregador == 2 | |
| && item.getItemId().equals("PROMO-2PM1PA5")) { | |
| Coupon orderItem = new Coupon(); | |
| orderItem.setCode("2PM1PA5"); | |
| cuponList.add(orderItem); |
jonandres45
/ gist:931d11dfe33c2fae7d9d15725c0b0a55
Created
March 11, 2026 03:50
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| else if (agregador == 2 | |
| && item.getItemId().equals("PROMO-2PM1PAG4")) { | |
| Coupon orderItem = new Coupon(); | |
| orderItem.setCode("2PM1PAG4"); | |
| cuponList.add(orderItem); | |
| }else if (agregador == 2 | |
| && item.getItemId().equals("PROMO-2PM1PAG5")) { | |
| Coupon orderItem = new Coupon(); | |
| orderItem.setCode("2PM1PAG5"); | |
| cuponList.add(orderItem); |
jonandres45
/ depuracion.sql
Last active
November 25, 2025 19:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1️⃣ TAAGREGADORORDEN (depuración por país + fecha) | |
| Validación de volumen | |
| SELECT COUNT(*) AS RegistrosAEliminar | |
| FROM TAAGREGADORORDEN | |
| WHERE FIPAISID IN (0,1,2,3,4,5,6) | |
| AND FDFECHAALTA < '2023-12-31 00:00:00'; | |
| Borrado en lotes | |
| -- Lote sugerido: 20,000 | |
| DELETE FROM TAAGREGADORORDEN |
jonandres45
/ response_rappi.json
Created
March 26, 2025 15:46
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "storeId": "1930169055", | |
| "items": [ | |
| { | |
| "name": "Breakfast Muffin 130 G", | |
| "description": "Una deliciosa opción para la mañana, tradicional english muffin con una frittata de huevo natural, jamón de pavo y queso gouda, aderezado con nuestro aderezo de chipotle (240 kcal).", | |
| "sku": "10007", | |
| "type": "PRODUCT", | |
| "combo": false, | |
| "price": 72, |
jonandres45
/ lambdaconciliaciones.py
Created
March 13, 2025 20:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from xml.dom import minidom | |
| from xml.dom.minidom import parseString | |
| import json | |
| import pymysql | |
| import os | |
| from datetime import datetime | |
| import pytz | |
| from pendiente_rechazada import * | |
| from descuentos import * |
jonandres45
/ msadmin.java
Last active
March 11, 2025 04:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //src/main/java/com/alsea/delivery/repository/items/ItemRepository2.java | |
| //LINEA 14 | |
| "WHERE SM.FISUCURSALMENUID=I.FISUCURSALMENUID AND SM.FIPAISID=?1 AND SM.FIMARCAID=?2 AND SM.FISUCURSALID=?3 AND SM.FIAGREGADORID=?4 AND SM.FIESTATUS = 1 ", | |
| //src/main/java/com/alsea/delivery/repository/items/ItemRepository.java | |
| //LINEA 29 | |
| "WHERE SM.FISUCURSALMENUID=I.FISUCURSALMENUID AND SM.FIPAISID=?1 AND SM.FIMARCAID=?2 AND SM.FISUCURSALID=?3 AND SM.FIAGREGADORID=?4 AND SM.FIESTATUS = 1 ", | |