Mebel do'koni uchun axborot tizimining dasturiy ta'minotini ishlab chiqish
![conn.commit()
print(f"{nomi} mahsuloti muvaffaqiyatli qo‘shildi.")
# Misol: Mahsulot qo‘shish
mahsulot_qoshish("Yotoq karavoti", 1500000, 5)
mahsulot_qoshish("Oshxona stoli", 800000, 10)
3. Mahsulotlar ro‘yxatini chiqarish
def mahsulotlarni_korish():
cursor.execute("SELECT * FROM mahsulotlar")
mahsulotlar = cursor.fetchall()
print("ID | Nomi | Narxi | Zaxira")
for m in mahsulotlar:
print(f"{m[0]} | {m[1]} | {m[2]} so'm | {m[3]} dona")
# Misol: Ro‘yxatni chiqarish
mahsulotlarni_korish()
4. Sotuvni ro‘yxatdan o‘tkazish
def sotuv_qilish(mahsulot_id, miqdor):
# Zaxirani tekshirish
cursor.execute("SELECT zaxira FROM mahsulotlar WHERE id = ?",
(mahsulot_id,))
zaxira = cursor.fetchone()
if zaxira and zaxira[0] >= miqdor:
cursor.execute("INSERT INTO sotuvlar (mahsulot_id, miqdor)
VALUES (?, ?)", (mahsulot_id, miqdor))
cursor.execute("UPDATE mahsulotlar SET zaxira = zaxira - ? WHERE
id = ?", (miqdor, mahsulot_id))
conn.commit()
print("Sotuv muvaffaqiyatli amalga oshirildi.")
42](https://docx.uz/documents/3ba42765-c659-494f-8f07-b141b82abe08/page_42.png?v=1)
![else:
print("Yetarli zaxira mavjud emas.")
# Misol: 1-id mahsulotdan 2 dona sotish
sotuv_qilish(1, 2)
5. Sotuvlar bo‘yicha hisobot
def sotuv_hisoboti():
cursor.execute("""
SELECT m.nomi, s.miqdor, m.narxi, s.miqdor * m.narxi AS
jami_summa, s.sana
FROM sotuvlar s
JOIN mahsulotlar m ON s.mahsulot_id = m.id
""")
hisob = cursor.fetchall()
print("Mahsulot | Miqdor | Narx | Jami | Sana")
for row in hisob:
print(f"{row[0]} | {row[1]} dona | {row[2]} so'm | {row[3]} so'm |
{row[4]}")
# Hisobotni ko‘rish
sotuv_hisoboti()
43](https://docx.uz/documents/3ba42765-c659-494f-8f07-b141b82abe08/page_43.png?v=1)
Mebel do'koni uchun axborot tizimining dasturiy ta'minotini ishlab chiqish