def load_products_cards(self):
import os
# 1. Очищаем старое содержимое
for widget in self.scrollable_frame.winfo_children():
widget.destroy()
# 2. Получаем товары
products = self.db.get_all_products()
print(f"DEBUG: Найдено товаров в базе: {len(products)}") # Это покажет в консоли, видны ли вообще товары
images_dir = "images"
for p in products:
# --- Обработка данных ---
try: discount = float(str(p.discount).replace('%', '').strip())
except: discount = 0.0
try: qty = float(str(p.quantity).strip())
except: qty = 0.0
bg_color = "#ADD8E6" if qty == 0 else ("#2E8B57" if discount > 10 else "#FFFFFF")
fg_color = "white" if (discount > 10 and qty > 0) else "black"
card_frame = tk.Frame(self.scrollable_frame, bg=bg_color, bd=2, relief=tk.SOLID)
card_frame.pack(fill=tk.X, padx=10, pady=5, ipady=5)
# --- ФОТО (самый простой способ) ---
img_container = tk.Frame(card_frame, width=120, height=120, bg="#FFFFFF", bd=1, relief=tk.SOLID)
img_container.pack(side=tk.LEFT, padx=15, pady=10)
photo_name = str(p.photo).strip() if p.photo else ""
img_path = os.path.join(images_dir, photo_name)
# Если файла нет — ставим заглушку
if not photo_name or not os.path.exists(img_path):
img_path = os.path.join(images_dir, "picture.png")
try:
img = tk.PhotoImage(file=img_path).subsample(2, 2)
img_lbl = tk.Label(img_container, image=img, bg="#FFFFFF")
img_lbl.image = img
img_lbl.pack()
except:
tk.Label(img_container, text="Нет фото", bg="#FFFFFF").pack()
# --- ТЕКСТОВАЯ ИНФО ---
info_frame = tk.Frame(card_frame, bg=bg_color)
info_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True, padx=15, pady=10)
tk.Label(info_frame, text=f"{p.category} | {p.name}", font=("Arial", 12, "bold"), bg=bg_color, fg=fg_color).pack(anchor=tk.W)
tk.Label(info_frame, text=f"Цена: {p.price} руб.", font=("Arial", 10, "bold"), bg=bg_color, fg=fg_color).pack(anchor=tk.W)