piper-assistant / data.py
indirapravianti's picture
Deploy Piper sticker restock manager Gradio app
1a65785
Raw
History Blame Contribute Delete
3 kB
import random
import pandas as pd
SAMPLE_CATALOG = [
"Holographic Cat Sticker", "Sakura Die-Cut Sticker", "Rainbow Unicorn Sticker",
"Kawaii Sushi Sticker", "Kawaii Ramen Sticker", "Kawaii Boba Tea Sticker",
"Floral Wreath Sticker", "Mountain Landscape Sticker", "Ocean Wave Sticker",
"Butterfly Garden Sticker", "Vintage Bicycle Sticker", "Coffee Cup Sticker",
"Galaxy Star Sticker", "Cactus Succulent Sticker", "Koi Fish Sticker",
"Cherry Blossom Sticker", "Batik Pattern Sticker", "Wayang Shadow Sticker",
"Borobudur Temple Sticker", "Komodo Dragon Sticker", "Gamelan Sticker",
"Javanese Dancer Sticker", "Tropical Bird Sticker", "Monstera Leaf Sticker",
"Cute Dog Sticker", "Cute Rabbit Sticker", "Panda Bear Sticker",
"Space Astronaut Sticker", "Retro Cassette Sticker", "Mushroom Forest Sticker",
]
SAMPLE_STORES = {
"Toko Alat Tulis Maju (Solo)": {"city": "Solo", "method": "Hand delivery", "consignment_pct": 30},
"Art Corner Klaten": {"city": "Klaten", "method": "Hand delivery", "consignment_pct": 25},
"Semarang Stationery": {"city": "Semarang", "method": "Hand delivery", "consignment_pct": 30},
"Gramedia Jogja": {"city": "Yogyakarta", "method": "Hand delivery", "consignment_pct": 35},
"Jakarta Creative Supply": {"city": "Jakarta", "method": "Post/courier", "consignment_pct": 30},
"Bandung Art Store": {"city": "Bandung", "method": "Post/courier", "consignment_pct": 28},
"Bali Artisan Shop": {"city": "Bali", "method": "Post/courier", "consignment_pct": 25},
}
STORE_NAMES = list(SAMPLE_STORES.keys())
SAMPLE_PO_EXAMPLES = [
[
"Toko Alat Tulis Maju (Solo)",
"Pesanan bulan Juni 2026:\n- Stiker kucing hologram 20 pcs\n- Stiker sakura die-cut 15 pcs\n"
"- Rainbow unicorn stiker 10 pcs\n- Stiker boba tea kawaii 25 pcs\n"
"Tolong kirim sebelum tanggal 5 ya kak",
],
[
"Jakarta Creative Supply",
"PO #JCS-2026-06\nItem | Qty\nHolographic Cat | 30\nGalaxy Star | 20\n"
"Monstera Leaf | 15\nBatik Pattern | 25\nKoi Fish | 10\nPlease ship via JNE REG",
],
[
"Bali Artisan Shop",
"hai kak, mau order lagi ya:\nstiker borobudur 20, wayang 15, gamelan 10, "
"penari jawa 20, batik 30\noh ya ada rekomendasi best seller bulan ini? "
"mau coba jual juga\nmakasih!",
],
[
"Bandung Art Store",
"Monthly restock:\n1. Sakura Die-Cut x25\n2. Cherry Blossom x20\n"
"3. Floral Wreath x15\n4. Butterfly Garden x10\n5. Vintage Bicycle x10\n"
"6. Coffee Cup x20\nNote: last month's sakura sold out in 2 weeks!",
],
[
"Art Corner Klaten",
"kak pesan:\nkucing holo 15\nunicorn 10\nsushi kawaii 20\nramen kawaii 20\n"
"boba 15\nmushroom forest 10\nspace astronaut 5",
],
]
def make_default_stock() -> pd.DataFrame:
random.seed(42)
return pd.DataFrame(
[{"Product": p, "In Stock": random.randint(5, 120)} for p in SAMPLE_CATALOG]
)