from datetime import datetime, timedelta from sqlalchemy.orm import Session from app.config import settings from app.services.auth_service import get_password_hash from app.models.admin import AdminUser from app.models.category import Category from app.models.product import Product, ProductImage, ProductSpecification from app.models.enquiry import CustomerEnquiry, EnquiryItem from app.models.setting import SystemSetting def seed_database(db: Session): # 1. Seed Admin User existing_admin = db.query(AdminUser).filter(AdminUser.username == settings.DEFAULT_ADMIN_USERNAME).first() if not existing_admin: admin = AdminUser( username=settings.DEFAULT_ADMIN_USERNAME, email=settings.DEFAULT_ADMIN_EMAIL, hashed_password=get_password_hash(settings.DEFAULT_ADMIN_PASSWORD), full_name=settings.DEFAULT_ADMIN_NAME, role="superadmin", is_active=True ) db.add(admin) db.commit() # 2. Seed System Settings default_settings = [ ("whatsapp_number", settings.DEFAULT_WHATSAPP_NUMBER, "Primary WhatsApp number for quotations"), ("business_name", settings.BUSINESS_NAME, "Registered business name"), ("tagline", settings.BUSINESS_TAGLINE, "Business slogan / tagline"), ("phone", settings.BUSINESS_PHONE, "Direct customer support phone number"), ("email", settings.BUSINESS_EMAIL, "Business email address"), ("address", settings.BUSINESS_ADDRESS, "Physical warehouse or trading address"), ("catalogue_notice", "All products are available strictly for bulk wholesale orders and dealer distribution across India. Minimum order quantities (MOQ) apply per carton.", "Top announcement banner notice") ] for key, val, desc in default_settings: if not db.query(SystemSetting).filter(SystemSetting.key_name == key).first(): db.add(SystemSetting(key_name=key, value=val, description=desc)) db.commit() # 3. Seed Categories if empty if db.query(Category).count() == 0: categories_data = [ { "name": "Stainless Steel", "slug": "stainless-steel", "description": "High-grade mirror finish SS utensils, topes, kadais, sauce pans, and heavy gauge vessels.", "image_url": "https://images.unsplash.com/photo-1584990347449-a2928507db58?auto=format&fit=crop&w=800&q=80", "icon_name": "shield", "display_order": 1 }, { "name": "Aluminium", "slug": "aluminium", "description": "Virgin aluminium pressure cookers, heavy biryani handis, milk boilers, and commercial vessels.", "image_url": "https://images.unsplash.com/photo-1544233726-9f1d2b27be8b?auto=format&fit=crop&w=800&q=80", "icon_name": "flame", "display_order": 2 }, { "name": "Non-stick / Cookware", "slug": "non-stick-cookware", "description": "Multi-layer granite coated tawas, deep kadai with glass lids, fry pans, and appam makers.", "image_url": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=800&q=80", "icon_name": "layers", "display_order": 3 }, { "name": "Kitchen Tools", "slug": "kitchen-tools", "description": "Commercial chef knives, SS ladles, skimmers, graters, lemon squeezers, and kitchen accessories.", "image_url": "https://images.unsplash.com/photo-1593618998160-e34014e67546?auto=format&fit=crop&w=800&q=80", "icon_name": "wrench", "display_order": 4 }, { "name": "Mixed Kitchenware", "slug": "mixed-kitchenware", "description": "Multi-tier idli steamers, dinner sets, airtight storage containers, milk cans, and combo boxes.", "image_url": "https://images.unsplash.com/photo-1610557892470-55d9e80c0bce?auto=format&fit=crop&w=800&q=80", "icon_name": "package", "display_order": 5 } ] created_categories = {} for cat_data in categories_data: cat = Category(**cat_data) db.add(cat) db.flush() created_categories[cat.slug] = cat.id # 4. Seed Products products_data = [ # Stainless Steel { "category_slug": "stainless-steel", "name": "Heavy Gauge Stainless Steel Tope Set (Mirror Finish)", "slug": "ss-tope-heavy-gauge-set", "description": "Manufactured from prime food-grade stainless steel with ultra-durable heavy flat base. Designed for wholesale distribution to retail shops and institutional catering suppliers. High thermal efficiency and corrosion resistance.", "features": "• Prime AISI Food Grade Stainless Steel\n• Extra heavy 22 gauge thickness\n• High gloss mirror exterior polish with matte interior\n• Flat stability bottom compatible with gas and induction", "is_featured": True, "display_order": 1, "private_mrp": "950 - 3200", "private_cost_price": "420 - 1650", "private_notes": "Bulk packing in heavy master corrugated carton of 12 sets.", "images": [ {"url": "https://images.unsplash.com/photo-1584990347449-a2928507db58?auto=format&fit=crop&w=800&q=80", "is_primary": True}, {"url": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=800&q=80", "is_primary": False} ], "specs": [ {"size_name": "1.0 Litre (Size 10)", "dimensions": "150 x 75 mm", "gauge": "22 Gauge Heavy", "material_grade": "SS 202 Prime", "packing_unit": "24 Pcs / Carton"}, {"size_name": "2.0 Litre (Size 12)", "dimensions": "180 x 90 mm", "gauge": "22 Gauge Heavy", "material_grade": "SS 202 Prime", "packing_unit": "18 Pcs / Carton"}, {"size_name": "3.5 Litre (Size 14)", "dimensions": "210 x 105 mm", "gauge": "22 Gauge Heavy", "material_grade": "SS 202 Prime", "packing_unit": "12 Pcs / Carton"}, {"size_name": "5.0 Litre (Size 16)", "dimensions": "240 x 120 mm", "gauge": "20 Gauge Extra Heavy", "material_grade": "SS 202 Prime", "packing_unit": "12 Pcs / Carton"}, {"size_name": "8.0 Litre (Size 18)", "dimensions": "270 x 140 mm", "gauge": "20 Gauge Extra Heavy", "material_grade": "SS 202 Prime", "packing_unit": "8 Pcs / Carton"} ] }, { "category_slug": "stainless-steel", "name": "Stainless Steel Deep Belly Kadai with Steel Lid & Brass Handles", "slug": "ss-belly-kadai-lid", "description": "Traditional deep curvature belly design ensures even heat distribution for commercial frying and cooking. Sturdy riveted cool-touch handles. Includes snugly fitted stainless steel lid.", "features": "• Heavy sandwich encapsulated bottom\n• Ergonomic riveted brass / steel handles\n• Mirror polished lid included\n• Resistant to pitting and discoloration", "is_featured": True, "display_order": 2, "private_mrp": "850 - 1800", "private_cost_price": "390 - 890", "private_notes": "Fast-moving festive season item.", "images": [ {"url": "https://images.unsplash.com/photo-1544233726-9f1d2b27be8b?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "1.5 Litre / 20 cm", "dimensions": "200 x 80 mm", "gauge": "22 Gauge", "material_grade": "SS 304 Food Grade", "packing_unit": "16 Pcs / Carton"}, {"size_name": "2.5 Litre / 24 cm", "dimensions": "240 x 95 mm", "gauge": "22 Gauge", "material_grade": "SS 304 Food Grade", "packing_unit": "12 Pcs / Carton"}, {"size_name": "4.0 Litre / 28 cm", "dimensions": "280 x 115 mm", "gauge": "20 Gauge Heavy", "material_grade": "SS 304 Food Grade", "packing_unit": "8 Pcs / Carton"} ] }, { "category_slug": "stainless-steel", "name": "Stainless Steel Sauce Pan with Heavy Bakelite Handle", "slug": "ss-sauce-pan-bakelite-handle", "description": "Essential milk and tea boiler pan crafted from premium steel. Features strong stay-cool bakelite handle with sturdy stainless steel bracket.", "features": "• Spill-proof pouring spout\n• Heavy induction-friendly flat base\n• Flame guard bakelite handle", "is_featured": False, "display_order": 3, "private_mrp": "450 - 950", "private_cost_price": "210 - 450", "private_notes": "Supplied with individual color gift box.", "images": [ {"url": "https://images.unsplash.com/photo-1584990347449-a2928507db58?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "1.0 Litre (14 cm)", "dimensions": "140 x 75 mm", "gauge": "22 Gauge", "material_grade": "SS Prime", "packing_unit": "24 Pcs / Carton"}, {"size_name": "1.5 Litre (16 cm)", "dimensions": "160 x 85 mm", "gauge": "22 Gauge", "material_grade": "SS Prime", "packing_unit": "20 Pcs / Carton"}, {"size_name": "2.0 Litre (18 cm)", "dimensions": "180 x 95 mm", "gauge": "22 Gauge", "material_grade": "SS Prime", "packing_unit": "16 Pcs / Carton"} ] }, # Aluminium { "category_slug": "aluminium", "name": "Commercial Heavy Aluminium Outer Lid Pressure Cooker", "slug": "aluminium-outer-lid-pressure-cooker", "description": "Heavy-duty commercial grade aluminium pressure cooker equipped with precision weight valve, gasket release system, and safety metallic valve. Built for fast cooking and durability.", "features": "• 99.6% Pure Virgin Aluminium Body\n• Heat resistant bakelite handle\n• Gasket release safety mechanism\n• Heavy 3.25mm body thickness", "is_featured": True, "display_order": 4, "private_mrp": "1100 - 3600", "private_cost_price": "580 - 1850", "private_notes": "ISI certified safety components.", "images": [ {"url": "https://images.unsplash.com/photo-1544233726-9f1d2b27be8b?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "3 Litre Standard", "dimensions": "180 x 140 mm", "gauge": "3.25 mm Thickness", "material_grade": "Virgin Aluminium", "packing_unit": "12 Pcs / Carton"}, {"size_name": "5 Litre Standard", "dimensions": "210 x 165 mm", "gauge": "3.25 mm Thickness", "material_grade": "Virgin Aluminium", "packing_unit": "8 Pcs / Carton"}, {"size_name": "7.5 Litre Jumbo", "dimensions": "240 x 185 mm", "gauge": "3.50 mm Thickness", "material_grade": "Virgin Aluminium", "packing_unit": "6 Pcs / Carton"}, {"size_name": "10 Litre Commercial", "dimensions": "270 x 205 mm", "gauge": "4.00 mm Heavy", "material_grade": "Virgin Aluminium", "packing_unit": "4 Pcs / Carton"} ] }, { "category_slug": "aluminium", "name": "Heavy Gauge Aluminium Biryani Handi with Lid", "slug": "aluminium-biryani-handi-heavy", "description": "Traditional deep handi with wide collar rim for slow-cooking biryani, curries, and bulk commercial preparations. Uniform heat conduction prevents bottom burning.", "features": "• Heavy rim construction for easy lid sealing / dum cooking\n• Solid aluminium tight-fit lid included\n• Smooth machine-turned interior", "is_featured": False, "display_order": 5, "private_mrp": "800 - 2900", "private_cost_price": "390 - 1450", "private_notes": "High demand in catering and restaurant supply channels.", "images": [ {"url": "https://images.unsplash.com/photo-1544233726-9f1d2b27be8b?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "3.0 kg Rice Capacity", "dimensions": "260 x 160 mm", "gauge": "12 Gauge (2.6mm)", "material_grade": "Pure Commercial Aluminium", "packing_unit": "8 Pcs / Carton"}, {"size_name": "5.0 kg Rice Capacity", "dimensions": "320 x 200 mm", "gauge": "10 Gauge (3.2mm)", "material_grade": "Pure Commercial Aluminium", "packing_unit": "6 Pcs / Carton"}, {"size_name": "8.0 kg Rice Capacity", "dimensions": "380 x 230 mm", "gauge": "8 Gauge (4.0mm)", "material_grade": "Pure Commercial Aluminium", "packing_unit": "4 Pcs / Carton"} ] }, # Non-Stick Cookware { "category_slug": "non-stick-cookware", "name": "5-Layer Granite Non-Stick Dosa Tawa (Heavy Base)", "slug": "granite-non-stick-dosa-tawa", "description": "Premium 5-layer German PFOA-free granite coating ensures effortless release of dosas, rotis, and pancakes with minimal oil consumption. Thick grooved base for even thermal dispersion.", "features": "• 5-Layer scratch-resistant granite non-stick coating\n• 100% PFOA & toxin free food grade safety\n• Heavy 4mm thick aluminium forged body\n• Soft-touch ergonomic wooden-finish stay-cool handle", "is_featured": True, "display_order": 6, "private_mrp": "799 - 1499", "private_cost_price": "340 - 680", "private_notes": "Top selling B2B item with maximum re-order frequency.", "images": [ {"url": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "250 mm (10 Inch)", "dimensions": "250 x 20 mm", "gauge": "3.5 mm Base", "material_grade": "Forged Aluminium + Granite", "packing_unit": "16 Pcs / Carton"}, {"size_name": "280 mm (11 Inch)", "dimensions": "280 x 20 mm", "gauge": "4.0 mm Base", "material_grade": "Forged Aluminium + Granite", "packing_unit": "12 Pcs / Carton"}, {"size_name": "310 mm (12.5 Inch)", "dimensions": "310 x 22 mm", "gauge": "4.0 mm Base", "material_grade": "Forged Aluminium + Granite", "packing_unit": "10 Pcs / Carton"} ] }, { "category_slug": "non-stick-cookware", "name": "Non-Stick Deep Kadai with Toughened Glass Lid", "slug": "non-stick-deep-kadai-glass-lid", "description": "Multi-purpose deep frying and curry pan with high sides to prevent oil splatters. Comes with transparent toughened glass lid with steam vent.", "features": "• Induction & gas stove dual compatibility\n• Shatter-resistant tempered glass lid\n• High abrasion resistance coating (10,000+ scrub cycles)", "is_featured": True, "display_order": 7, "private_mrp": "1199 - 1899", "private_cost_price": "520 - 850", "private_notes": "Supplied in attractive retail master packaging.", "images": [ {"url": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "2.0 Litre (22 cm)", "dimensions": "220 x 75 mm", "gauge": "3.0 mm", "material_grade": "Granite Coated Aluminium", "packing_unit": "12 Pcs / Carton"}, {"size_name": "3.0 Litre (26 cm)", "dimensions": "260 x 85 mm", "gauge": "3.2 mm", "material_grade": "Granite Coated Aluminium", "packing_unit": "8 Pcs / Carton"} ] }, { "category_slug": "non-stick-cookware", "name": "Non-Stick 12 Cavity Appam Patra with Stainless Steel Lid", "slug": "non-stick-12-cavity-appam-patra", "description": "Evenly spaced 12 hemispherical cavities with superior non-stick release for crispy paniyarams and sweet appams. Heavy heat distributor base.", "features": "• 12 Uniform deep cavities\n• Quick release non-stick layer\n• Side handles for balanced lifting", "is_featured": False, "display_order": 8, "private_mrp": "599 - 799", "private_cost_price": "240 - 340", "private_notes": "Compact carton packing.", "images": [ {"url": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "12 Cavities Standard", "dimensions": "230 x 35 mm", "gauge": "2.8 mm", "material_grade": "Aluminium Die Cast", "packing_unit": "20 Pcs / Carton"} ] }, # Kitchen Tools { "category_slug": "kitchen-tools", "name": "Heavy Stainless Steel Kitchen Serving & Cooking Ladle Set (6 Pcs)", "slug": "ss-kitchen-ladle-tool-set-6pc", "description": "Comprehensive kitchenware tool collection including soup ladle, frying skimmer (jhara), turner spatula, rice server, pasta server, and slotted spoon. One-piece seamless stainless steel construction.", "features": "• 100% Solid Stainless Steel (No joints or welding points)\n• Hanging hole in handles for rack storage\n• Dishwasher safe and rust proof", "is_featured": True, "display_order": 9, "private_mrp": "499 - 899", "private_cost_price": "190 - 380", "private_notes": "Bulk supply packed in individual polybags inside master box.", "images": [ {"url": "https://images.unsplash.com/photo-1593618998160-e34014e67546?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "6-Piece Standard Set", "dimensions": "Length: 320 mm each", "gauge": "1.8 mm Heavy Sheet", "material_grade": "SS 202 High Polish", "packing_unit": "30 Sets / Carton"}, {"size_name": "7-Piece Premium Set + Stand", "dimensions": "Length: 350 mm + Rack", "gauge": "2.0 mm Heavy Sheet", "material_grade": "SS 304 Grade", "packing_unit": "20 Sets / Carton"} ] }, { "category_slug": "kitchen-tools", "name": "High Carbon Stainless Steel Chef Knife Trio Set", "slug": "high-carbon-ss-chef-knife-set", "description": "Razor sharp German-profile kitchen knives including 8-inch Chef knife, 5-inch Utility knife, and 3.5-inch Paring knife with anti-slip textured grip.", "features": "• Ultra-sharp high carbon steel edge\n• Full tang triple-riveted handle\n• Protective blade tip guards included", "is_featured": False, "display_order": 10, "private_mrp": "699 - 1299", "private_cost_price": "260 - 520", "private_notes": "High margins for retail shopkeepers.", "images": [ {"url": "https://images.unsplash.com/photo-1593618998160-e34014e67546?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "3-Piece Box Set", "dimensions": "8\" / 5\" / 3.5\"", "gauge": "2.5 mm Spine", "material_grade": "High Carbon SS", "packing_unit": "36 Sets / Carton"} ] }, # Mixed Kitchenware { "category_slug": "mixed-kitchenware", "name": "Multi-Tier Stainless Steel Idli Maker & Steamer Pot", "slug": "ss-multi-tier-idli-maker-steamer", "description": "Heavy gauge stainless steel cooker vessel with interchangeable idli plates, dhokla plates, and momo steamer tier. Features whistling steam indicator valve.", "features": "• Multi-purpose steaming system\n• Heavy induction compatible base\n• High gloss mirror finish", "is_featured": True, "display_order": 11, "private_mrp": "1299 - 2199", "private_cost_price": "560 - 980", "private_notes": "Very high wholesale turnover during festival seasons.", "images": [ {"url": "https://images.unsplash.com/photo-1610557892470-55d9e80c0bce?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "4 Plates (16 Idlis)", "dimensions": "220 x 200 mm", "gauge": "22 Gauge", "material_grade": "Food Grade SS", "packing_unit": "12 Sets / Carton"}, {"size_name": "5 Plates (20 Idlis) + Dhokla Plate", "dimensions": "240 x 230 mm", "gauge": "22 Gauge", "material_grade": "Food Grade SS", "packing_unit": "8 Sets / Carton"} ] }, { "category_slug": "mixed-kitchenware", "name": "Heavy Stainless Steel Milk Can with Airtight Triple-Lock Lid", "slug": "ss-heavy-milk-can-triple-lock", "description": "Sturdy cylindrical storage and transport can equipped with silicone airtight ring, heavy clamp latches, and solid tubular handle.", "features": "• 100% Leak-proof lock design\n• Reinforced bottom rim to resist drops\n• Seamless jointless interior", "is_featured": False, "display_order": 12, "private_mrp": "1499 - 3800", "private_cost_price": "750 - 1950", "private_notes": "Bulk supply to dairy cooperatives and rural retail networks.", "images": [ {"url": "https://images.unsplash.com/photo-1610557892470-55d9e80c0bce?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "5 Litre Capacity", "dimensions": "190 x 260 mm", "gauge": "20 Gauge Heavy", "material_grade": "SS 304 High Grade", "packing_unit": "6 Pcs / Carton"}, {"size_name": "10 Litre Capacity", "dimensions": "230 x 320 mm", "gauge": "18 Gauge Extra Heavy", "material_grade": "SS 304 High Grade", "packing_unit": "4 Pcs / Carton"}, {"size_name": "20 Litre Capacity", "dimensions": "280 x 420 mm", "gauge": "18 Gauge Extra Heavy", "material_grade": "SS 304 High Grade", "packing_unit": "2 Pcs / Carton"} ] }, { "category_slug": "mixed-kitchenware", "name": "Complete 32-Piece Laser Etched Stainless Steel Dinner Set", "slug": "ss-32pc-laser-etched-dinner-set", "description": "Exquisite heavy-gauge family dinner collection with permanent laser floral etching. Includes full plates, quarter plates, curry bowls, halwa plates, glasses, and spoons.", "features": "• Scratch-proof permanent laser embossing\n• Heavy edge curling prevents chipping\n• Premium gift master suitcase packaging", "is_featured": True, "display_order": 13, "private_mrp": "2499 - 4999", "private_cost_price": "1150 - 2400", "private_notes": "Ideal for corporate gifting and wedding season orders.", "images": [ {"url": "https://images.unsplash.com/photo-1610557892470-55d9e80c0bce?auto=format&fit=crop&w=800&q=80", "is_primary": True} ], "specs": [ {"size_name": "32-Piece Family Set", "dimensions": "Full Plate 280mm", "gauge": "22 Gauge Heavy", "material_grade": "SS 202 High Gloss", "packing_unit": "4 Sets / Master Box"}, {"size_name": "51-Piece Royal Set", "dimensions": "Full Plate 300mm", "gauge": "20 Gauge Extra Heavy", "material_grade": "SS 304 Grade", "packing_unit": "2 Sets / Master Box"} ] } ] for p_data in products_data: cat_id = created_categories.get(p_data["category_slug"]) if not cat_id: continue prod = Product( category_id=cat_id, name=p_data["name"], slug=p_data["slug"], description=p_data["description"], features=p_data["features"], is_active=True, is_featured=p_data["is_featured"], display_order=p_data["display_order"], private_mrp=p_data["private_mrp"], private_cost_price=p_data["private_cost_price"], private_notes=p_data["private_notes"] ) db.add(prod) db.flush() # Add images for idx, img in enumerate(p_data["images"]): p_img = ProductImage( product_id=prod.id, image_url=img["url"], is_primary=img["is_primary"], display_order=idx ) db.add(p_img) # Add specifications for idx, spec in enumerate(p_data["specs"]): p_spec = ProductSpecification( product_id=prod.id, size_name=spec["size_name"], dimensions=spec.get("dimensions"), gauge=spec.get("gauge"), material_grade=spec.get("material_grade"), packing_unit=spec.get("packing_unit"), display_order=idx ) db.add(p_spec) db.commit() # 5. Seed Customer Enquiries matching user's layout specification if empty if db.query(CustomerEnquiry).count() == 0: sample_enquiries = [ { "enquiry_number": "NQ-1027", "customer_name": "Rajesh Agarwal", "shop_name": "ABC Traders", "mobile_whatsapp": "9829011223", "city": "Jaipur", "message": "Urgent requirement for festive inventory. Please send quotation for transport to Jaipur depot.", "status": "New", "created_days_ago": 1, "items": [ {"name": "Heavy Gauge Stainless Steel Tope Set (Mirror Finish)", "spec": "Size: 3.5 Litre (Size 14) - 22 Gauge", "qty": "50 Pcs", "img": "https://images.unsplash.com/photo-1584990347449-a2928507db58?auto=format&fit=crop&w=400&q=80"} ] }, { "enquiry_number": "NQ-1026", "customer_name": "Mukesh Singhal", "shop_name": "XYZ Stores", "mobile_whatsapp": "9811099887", "city": "Delhi", "message": "Need delivery to Chandni Chowk wholesale market.", "status": "New", "created_days_ago": 1, "items": [ {"name": "Commercial Heavy Aluminium Outer Lid Pressure Cooker", "spec": "Size: 5 Litre Standard", "qty": "100 Pcs", "img": "https://images.unsplash.com/photo-1544233726-9f1d2b27be8b?auto=format&fit=crop&w=400&q=80"} ] }, { "enquiry_number": "NQ-1025", "customer_name": "Kailash Gehlot", "shop_name": "Marwar Bartan Bhandar", "mobile_whatsapp": "9414077665", "city": "Jodhpur", "message": "Send dealer rate list and carton packing specs.", "status": "New", "created_days_ago": 2, "items": [ {"name": "5-Layer Granite Non-Stick Dosa Tawa (Heavy Base)", "spec": "Size: 280 mm (11 Inch)", "qty": "60 Pcs", "img": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=400&q=80"}, {"name": "Non-Stick Deep Kadai with Toughened Glass Lid", "spec": "Size: 3.0 Litre (26 cm)", "qty": "40 Pcs", "img": "https://images.unsplash.com/photo-1585515320310-259814833e62?auto=format&fit=crop&w=400&q=80"} ] }, { "enquiry_number": "NQ-1024", "customer_name": "Virendra Patel", "shop_name": "Pooja Kitchen World", "mobile_whatsapp": "9825033445", "city": "Ahmedabad", "message": "Need regular monthly supply for 2 retail outlets.", "status": "Contacted", "created_days_ago": 3, "items": [ {"name": "Complete 32-Piece Laser Etched Stainless Steel Dinner Set", "spec": "Size: 32-Piece Family Set", "qty": "30 Sets", "img": "https://images.unsplash.com/photo-1610557892470-55d9e80c0bce?auto=format&fit=crop&w=400&q=80"} ] }, { "enquiry_number": "NQ-1023", "customer_name": "Suresh Gupta", "shop_name": "Gupta Metal Stores", "mobile_whatsapp": "9891044556", "city": "Kanpur", "message": "Share freight estimates via V-Trans transport.", "status": "Contacted", "created_days_ago": 4, "items": [ {"name": "Stainless Steel Deep Belly Kadai with Steel Lid & Brass Handles", "spec": "Size: 2.5 Litre / 24 cm", "qty": "80 Pcs", "img": "https://images.unsplash.com/photo-1544233726-9f1d2b27be8b?auto=format&fit=crop&w=400&q=80"} ] }, { "enquiry_number": "NQ-1022", "customer_name": "Anand Mishra", "shop_name": "Mishra Household", "mobile_whatsapp": "9450011223", "city": "Varanasi", "message": "Quotation approved, pending payment terms verification.", "status": "Closed", "created_days_ago": 6, "items": [ {"name": "Heavy Stainless Steel Milk Can with Airtight Triple-Lock Lid", "spec": "Size: 10 Litre Capacity", "qty": "25 Pcs", "img": "https://images.unsplash.com/photo-1610557892470-55d9e80c0bce?auto=format&fit=crop&w=400&q=80"} ] } ] for enq_data in sample_enquiries: enq = CustomerEnquiry( enquiry_number=enq_data["enquiry_number"], customer_name=enq_data["customer_name"], shop_name=enq_data["shop_name"], mobile_whatsapp=enq_data["mobile_whatsapp"], city=enq_data["city"], message=enq_data["message"], status=enq_data["status"], total_items=len(enq_data["items"]), created_at=datetime.utcnow() - timedelta(days=enq_data["created_days_ago"], hours=3, minutes=15) ) db.add(enq) db.flush() for itm in enq_data["items"]: e_item = EnquiryItem( enquiry_id=enq.id, product_name=itm["name"], selected_specification=itm["spec"], quantity=itm["qty"], product_image_url=itm.get("img") ) db.add(e_item) db.commit()