Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-mini-2024-07-18· OpenAIAi2 WildChat-4.8M (AI2)

import sqlite3 import math from PySide6.QtWidgets import ( QApplication, QMainWindow,…

  1. User

    import sqlite3 import math from PySide6.QtWidgets import ( QApplication, QMainWindow, QPushButton, QLabel, QVBoxLayout, QWidget, QTableWidget, QTableWidgetItem, QLineEdit, QFormLayout, QDialog, QFileDialog, QMessageBox, QComboBox, QHBoxLayout ) from PySide6.QtCore import Qt from reportlab.lib.pagesizes import letter from reportlab.pdfgen import canvas

    class ModernMainWindow(QMainWindow): def init(self): super().init() self.setWindowTitle("مدیریت هزینه‌های کافی شاپ") self.setGeometry(100, 100, 800, 600) self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")

        # Main layout
        main_widget = QWidget()
        self.setCentralWidget(main_widget)
        layout = QVBoxLayout(main_widget)
    
        # Title label
        title_label = QLabel("محاسبه گر قیمت منو کافه پیونی")
        title_label.setStyleSheet("font-size: 24px; font-weight: bold; color: Gold;")
        title_label.setAlignment(Qt.AlignCenter)
        layout.addWidget(title_label)
    
        # Buttons
        btn_materials = self.create_styled_button("مواد اولیه")
        btn_materials.clicked.connect(self.manage_materials)
        layout.addWidget(btn_materials)
    
        btn_recipes = self.create_styled_button("رسپی‌ها")
        btn_recipes.clicked.connect(self.manage_recipes)
        layout.addWidget(btn_recipes)
    
        btn_menu = self.create_styled_button("نمایش منو")
        btn_menu.clicked.connect(self.show_menu)
        layout.addWidget(btn_menu)
    
        # Footer
        footer_label = QLabel("Made By LoGiT3X with 🧡")
        footer_label.setStyleSheet("font-size: 12px; font-weight: bold; color: #f024b3;")
        footer_label.setAlignment(Qt.AlignCenter)
        layout.addWidget(footer_label)
    
    def create_styled_button(self, text):
        """Create a styled button with rounded corners and hover effects."""
        button = QPushButton(text)
        button.setStyleSheet("""
            QPushButton {
                background-color: #0786b0;
                color: black;
                border: 2px solid #fcd40d;
                border-radius: 25px;
                font-size: 20px;
                padding: 10px;
                text-align: center;
            }
            QPushButton:hover {
                background-color: #17627a;
                border-color: fcd40d;
                transition: background-color 0.3s;
            }
            QPushButton:pressed {
                background-color: #fcd40d;
                border-color: #FF0000;
            }
        """)
        return button
    
    def manage_materials(self):
        """Open the materials management window."""
        dialog = MaterialsDialog(self)
        dialog.exec()
    
    def manage_recipes(self):
        """Open the recipes management window."""
        dialog = RecipesDialog(self)
        dialog.exec()
    
    def show_menu(self):
        """Open the menu display window."""
        dialog = MenuDialog(self)
        dialog.exec()
    

    class MaterialsDialog(QDialog): def init(self, parent=None): super().init(parent) self.setWindowTitle("مدیریت مواد اولیه") self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;") self.setGeometry(100, 100, 600, 400)

        layout = QVBoxLayout(self)
    
        # Table
        self.table = QTableWidget()
        self.table.setColumnCount(2)
        self.table.setHorizontalHeaderLabels(["نام مواد", "قیمت هر گرم"])
        self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
        self.refresh_materials()
        layout.addWidget(self.table)
    
        # Add form
        form_layout = QFormLayout()
        self.name_input = QLineEdit()
        self.price_input = QLineEdit()
        form_layout.addRow("نام:", self.name_input)
        form_layout.addRow("قیمت هر گرم:", self.price_input)
    
        add_button = QPushButton("اضافه کردن")
        add_button.clicked.connect(self.add_material)
        form_layout.addWidget(add_button)
    
        layout.addLayout(form_layout)
    
    def refresh_materials(self):
        """Refresh the materials table."""
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
        cursor.execute("SELECT name, price_per_gram FROM materials")
        materials = cursor.fetchall()
        conn.close()
    
        self.table.setRowCount(len(materials))
        for row, material in enumerate(materials):
            self.table.setItem(row, 0, QTableWidgetItem(material[0]))
            self.table.setItem(row, 1, QTableWidgetItem(str(int(material[1]))))  # Convert to integer
    
    def add_material(self):
        """Add a new material."""
        name = self.name_input.text()
        price = self.price_input.text()
    
        if not name or not price:
            QMessageBox.warning(self, "خطا", "تمام فیلدها را پر کنید.")
            return
    
        try:
            price = int(price)  # Convert price to integer
        except ValueError:
            QMessageBox.warning(self, "خطا", "قیمت باید عدد باشد.")
            return
    
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
        try:
            cursor.execute("INSERT INTO materials (name, price_per_gram) VALUES (?, ?)", (name, price))
            conn.commit()
        except sqlite3.IntegrityError:
            QMessageBox.warning(self, "خطا", "این ماده قبلاً ثبت شده است.")
        finally:
            conn.close()
    
        self.refresh_materials()
        self.name_input.clear()
        self.price_input.clear()
    

    class RecipesDialog(QDialog): def init(self, parent=None): super().init(parent) self.setWindowTitle("مدیریت رسپی‌ها") self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;") self.setGeometry(100, 100, 800, 500)

        layout = QVBoxLayout(self)
    
        # Table
        self.table = QTableWidget()
        self.table.setColumnCount(2)
        self.table.setHorizontalHeaderLabels(["نام رسپی", "تعداد مواد اولیه"])
        self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
        self.refresh_recipes()
        layout.addWidget(self.table)
    
        # Buttons
        button_layout = QHBoxLayout()
        add_button = QPushButton("اضافه کردن رسپی")
        add_button.clicked.connect(self.add_recipe)
        button_layout.addWidget(add_button)
    
        edit_button = QPushButton("ویرایش رسپی")
        edit_button.clicked.connect(self.edit_recipe)
        button_layout.addWidget(edit_button)
    
        delete_button = QPushButton("حذف رسپی")
        delete_button.clicked.connect(self.delete_recipe)
        button_layout.addWidget(delete_button)
    
        layout.addLayout(button_layout)
    
    def refresh_recipes(self):
        """Fetch recipes and display them in the table."""
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
        cursor.execute("""
            SELECT r.id, r.name, COUNT(rd.material_id) 
            FROM recipes r
            LEFT JOIN recipe_details rd ON r.id = rd.recipe_id
            GROUP BY r.id
        """)
        recipes = cursor.fetchall()
        conn.close()
    
        self.table.setRowCount(len(recipes))
        for row, (recipe_id, name, material_count) in enumerate(recipes):
            self.table.setItem(row, 0, QTableWidgetItem(name))
            self.table.setItem(row, 1, QTableWidgetItem(str(material_count)))
    
    def add_recipe(self):
        """Open a dialog to add a new recipe."""
        dialog = RecipeEditDialog(self)
        dialog.exec()
        self.refresh_recipes()
    
    def edit_recipe(self):
        """Open a dialog to edit the selected recipe."""
        selected_row = self.table.currentRow()
        if selected_row == -1:
            QMessageBox.warning(self, "خطا", "لطفاً یک رسپی را انتخاب کنید.")
            return
    
        recipe_name = self.table.item(selected_row, 0).text()
        dialog = RecipeEditDialog(self, recipe_name)
        dialog.exec()
        self.refresh_recipes()
    
    def delete_recipe(self):
        """Delete the selected recipe."""
        selected_row = self.table.currentRow()
        if selected_row == -1:
            QMessageBox.warning(self, "خطا", "لطفاً یک رسپی را انتخاب کنید.")
            return
    
        recipe_name = self.table.item(selected_row, 0).text()
        confirm = QMessageBox.question(
            self, "حذف رسپی", f"آیا مطمئن هستید که می‌خواهید رسپی '{recipe_name}' را حذف کنید؟",
            QMessageBox.Yes | QMessageBox.No
        )
        if confirm == QMessageBox.Yes:
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("DELETE FROM recipes WHERE name = ?", (recipe_name,))
            cursor.execute("DELETE FROM recipe_details WHERE recipe_id = (SELECT id FROM recipes WHERE name = ?)",
                           (recipe_name,))
            conn.commit()
            conn.close()
            self.refresh_recipes()
    

    class RecipeEditDialog(QDialog): def init(self, parent=None, recipe_name=None): super().init(parent) self.recipe_name = recipe_name self.setWindowTitle("ویرایش رسپی" if recipe_name else "اضافه کردن رسپی") self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;") self.setGeometry(100, 100, 600, 400)

        layout = QVBoxLayout(self)
    
        # Recipe name
        self.name_input = QLineEdit()
        if recipe_name:
            self.name_input.setText(recipe_name)
        layout.addWidget(QLabel("نام رسپی:"))
        layout.addWidget(self.name_input)
    
        # Materials table
        self.table = QTableWidget()
        self.table.setColumnCount(2)
        self.table.setHorizontalHeaderLabels(["مواد اولیه", "مقدار (گرم)"])
        self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
        layout.addWidget(self.table)
    
        # Add material
        form_layout = QFormLayout()
        self.material_combo = QComboBox()
        self.material_combo.addItems(self.get_material_names())
        self.quantity_input = QLineEdit()
        form_layout.addRow("مواد اولیه:", self.material_combo)
        form_layout.addRow("مقدار (گرم):", self.quantity_input)
    
        add_material_button = QPushButton("اضافه کردن ماده")
        add_material_button.clicked.connect(self.add_material)
        form_layout.addWidget(add_material_button)
        layout.addLayout(form_layout)
    
        # Save button
        save_button = QPushButton("ذخیره رسپی")
        save_button.clicked.connect(self.save_recipe)
        layout.addWidget(save_button)
    
        if recipe_name:
            self.load_recipe()
    
    def get_material_names(self):
        """Get all material names from the database."""
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
        cursor.execute("SELECT name FROM materials")
        materials = [row[0] for row in cursor.fetchall()]
        conn.close()
        return materials
    
    def load_recipe(self):
        """Load the selected recipe details."""
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
        cursor.execute("""
            SELECT m.name, rd.quantity
            FROM recipe_details rd
            JOIN materials m ON rd.material_id = m.id
            WHERE rd.recipe_id = (SELECT id FROM recipes WHERE name = ?)
        """, (self.recipe_name,))
        materials = cursor.fetchall()
        conn.close()
    
        self.table.setRowCount(len(materials))
        for row, (material_name, quantity) in enumerate(materials):
            self.table.setItem(row, 0, QTableWidgetItem(material_name))
            self.table.setItem(row, 1, QTableWidgetItem(str(int(quantity))))  # Convert to integer
    
    def add_material(self):
        """Add a material to the recipe."""
        material_name = self.material_combo.currentText()
        quantity = self.quantity_input.text()
        if not quantity:
            QMessageBox.warning(self, "خطا", "لطفاً مقدار را وارد کنید.")
            return
    
        try:
            quantity = int(quantity)  # Convert to integer
        except ValueError:
            QMessageBox.warning(self, "خطا", "مقدار باید عدد باشد.")
            return
    
        current_row_count = self.table.rowCount()
        self.table.insertRow(current_row_count)
        self.table.setItem(current_row_count, 0, QTableWidgetItem(material_name))
        self.table.setItem(current_row_count, 1, QTableWidgetItem(str(quantity)))  # Convert to integer
    
    def save_recipe(self):
        """Save the recipe to the database."""
        recipe_name = self.name_input.text()
        if not recipe_name:
            QMessageBox.warning(self, "خطا", "لطفاً نام رسپی را وارد کنید.")
            return
    
        materials = []
        for row in range(self.table.rowCount()):
            material_name = self.table.item(row, 0).text()
            quantity = self.table.item(row, 1).text()
            try:
                quantity = int(quantity)  # Ensure quantity is integer
                materials.append((material_name, quantity))
            except ValueError:
                QMessageBox.warning(self, "خطا", f"مقدار برای '{material_name}' نامعتبر است.")
                return
    
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
    
        if self.recipe_name:  # Update existing recipe
            cursor.execute("UPDATE recipes SET name = ? WHERE name = ?", (recipe_name, self.recipe_name))
            cursor.execute("DELETE FROM recipe_details WHERE recipe_id = (SELECT id FROM recipes WHERE name = ?)",
                           (recipe_name,))
        else:  # Insert new recipe
            cursor.execute("INSERT INTO recipes (name) VALUES (?)", (recipe_name,))
        recipe_id = cursor.execute("SELECT id FROM recipes WHERE name = ?", (recipe_name,)).fetchone()[0]
    
        for material_name, quantity in materials:
            material_id = cursor.execute("SELECT id FROM materials WHERE name = ?", (material_name,)).fetchone()[0]
            cursor.execute("INSERT INTO recipe_details (recipe_id, material_id, quantity) VALUES (?, ?, ?)",
                           (recipe_id, material_id, quantity))
    
        conn.commit()
        conn.close()
        QMessageBox.information(self, "موفقیت", "رسپی با موفقیت ذخیره شد.")
        self.accept()
    

    class MenuDialog(QDialog): def init(self, parent=None): super().init(parent) self.setWindowTitle("نمایش منو") self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;") self.setGeometry(100, 100, 800, 500)

        layout = QVBoxLayout(self)
    
        # Table
        self.table = QTableWidget()
        self.table.setColumnCount(4)
        self.table.setHorizontalHeaderLabels(["نام محصول", "قیمت اولیه", "قیمت ثانویه", "قیمت نهایی (تومان)"])
        self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
        self.refresh_menu()
        layout.addWidget(self.table)
    
        # Export button
        export_button = QPushButton("ذخیره به PDF")
        export_button.clicked.connect(self.export_to_pdf)
        layout.addWidget(export_button)
    
    def refresh_menu(self):
        """Fetch menu items and display them in the table."""
        prices = self.calculate_prices()
        self.table.setRowCount(len(prices))
        for row, (name, raw_price, secondary_price, final_price) in enumerate(prices):
            self.table.setItem(row, 0, QTableWidgetItem(name))
            self.table.setItem(row, 1, QTableWidgetItem(f"{raw_price} تومان"))
            self.table.setItem(row, 2, QTableWidgetItem(f"{secondary_price} تومان"))
            self.table.setItem(row, 3, QTableWidgetItem(f"{final_price} تومان"))
    
    def calculate_prices(self):
        """Calculate prices for each recipe."""
        conn = sqlite3.connect("coffee_shop.db")
        cursor = conn.cursor()
        cursor.execute("""
            SELECT r.name, 
                   SUM(rd.quantity * m.price_per_gram) AS raw_price
            FROM recipes r
            JOIN recipe_details rd ON r.id = rd.recipe_id
            JOIN materials m ON rd.material_id = m.id
            GROUP BY r.id
        """)
        data = cursor.fetchall()
        conn.close()
    
        prices = []
        for name, raw_price in data:
            if raw_price is None:
                continue
            raw_price = round(raw_price)
            secondary_price = round(raw_price * 3.3)
            price_with_tax = round(secondary_price * 1.1)
            final_price = math.ceil(price_with_tax)
            prices.append((name, raw_price, secondary_price, final_price))
        return prices
    
    def export_to_pdf(self):
        """Export the menu to a PDF file."""
        file_path, _ = QFileDialog.getSaveFileName(self, "ذخیره فایل", filter="PDF Files (*.pdf)")
        if not file_path:
            return
    
        prices = self.calculate_prices()
        if not prices:
            QMessageBox.warning(self, "خطا", "هیچ محصولی برای ذخیره وجود ندارد.")
            return
    
        try:
            c = canvas.Canvas(file_path, pagesize=letter)
            c.setFont("Helvetica", 12)
            c.drawString(30, 750, "گزارش منوی کافی‌شاپ")
            y = 730
            for name, raw_price, secondary_price, final_price in prices:
                c.drawString(30, y, f"{name}: {final_price} تومان (قیمت اولیه: {raw_price}، قیمت ثانویه: {secondary_price})")
                y -= 20
                if y < 50:  # Create a new page if the content exceeds one page
                    c.showPage()
                    c.setFont("Helvetica", 12)
                    y = 750
            c.save()
            QMessageBox.information(self, "موفقیت", "منو با موفقیت به PDF ذخیره شد.")
        except Exception as e:
            QMessageBox.critical(self, "خطا", f"خطایی رخ داد: {str(e)}")
    

    if name == "main": # Initialize SQLite database def init_db(): conn = sqlite3.connect("coffee_shop.db") cursor = conn.cursor() cursor.execute(""" CREATE TABLE IF NOT EXISTS materials ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL, price_per_gram INTEGER NOT NULL -- Changed to INTEGER ) """) cursor.execute(""" CREATE TABLE IF NOT EXISTS recipes ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL ) """) cursor.execute(""" CREATE TABLE IF NOT EXISTS recipe_details ( recipe_id INTEGER NOT NULL, material_id INTEGER NOT NULL, quantity INTEGER NOT NULL, -- Changed to INTEGER FOREIGN KEY(recipe_id) REFERENCES recipes(id), FOREIGN KEY(material_id) REFERENCES materials(id) ) """) conn.commit() conn.close()

    init_db()
    
    app = QApplication([])
    window = ModernMainWindow()
    window.setStyleSheet("QApplication { font-family: B Nazanin; }")  # Set application-wide style
    window.show()
    app.exec()
    

    بخش تنظیمات رو به این برنامه اضافه کن توی بخش تنظیمات بشه بکگراند تصویری برای برنامه انتخاب کرد از فایل های سیستم همچنین سایز دلخواه به فونت های برنامه داد

  2. Assistant

    To add a settings section to the existing PyQt6 application, which allows users to select a background image and adjust the font size, you can create a new dialog for settings. This new dialog will include options to choose a background image file and a font size input.

    Here's how to implement this functionality:

    1. Create a new SettingsDialog class to handle settings.
    2. Allow users to choose a background image file using QFileDialog.
    3. Allow users to adjust the font size using a QSpinBox.
    4. Apply the selected background and font size to the main application window.

    Below is the updated code snippet that integrates the settings feature:

    from PySide6.QtWidgets import QSpinBox
    
    class SettingsDialog(QDialog):
        def __init__(self, parent=None):
            super().__init__(parent)
            self.setWindowTitle("تنظیمات")
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
            self.setGeometry(100, 100, 400, 300)
    
            self.layout = QVBoxLayout(self)
    
            # Font size
            self.font_size_label = QLabel("سایز فونت:")
            self.layout.addWidget(self.font_size_label)
    
            self.font_size_spinbox = QSpinBox()
            self.font_size_spinbox.setRange(8, 100)  # Set font size range
            self.layout.addWidget(self.font_size_spinbox)
    
            # Background image
            self.background_image_label = QLabel("انتخاب تصویر پس‌زمینه:")
            self.layout.addWidget(self.background_image_label)
    
            self.select_background_button = QPushButton("انتخاب تصویر")
            self.select_background_button.clicked.connect(self.select_background_image)
            self.layout.addWidget(self.select_background_button)
    
            # Save button
            self.save_button = QPushButton("ذخیره تنظیمات")
            self.save_button.clicked.connect(self.save_settings)
            self.layout.addWidget(self.save_button)
    
            self.background_image_path = ""
            self.font_size_spinbox.setValue(12)  # Default font size
    
        def select_background_image(self):
            """Open dialog to select a background image."""
            file_path, _ = QFileDialog.getOpenFileName(self, "انتخاب تصویر پس‌زمینه", "", "Images (*.png *.jpg *.jpeg *.bmp)")
            if file_path:
                self.background_image_path = file_path
    
        def save_settings(self):
            """Save the settings."""
            font_size = self.font_size_spinbox.value()
    
            if self.background_image_path:
                style_sheet = f"""
                    QMainWindow {{
                        background-image: url('{self.background_image_path}');
                        background-repeat: no-repeat;
                        background-position: center;
                    }}
                    QLabel, QPushButton {{
                        font-size: {font_size}px;
                    }}
                """
                self.parent().setStyleSheet(style_sheet)
            else:
                self.parent().setStyleSheet(f"QLabel, QPushButton {{ font-size: {font_size}px; }}")
    
            self.accept()
    
    # Adding the settings button to the main window
    class ModernMainWindow(QMainWindow):
        def __init__(self):
            super().__init__()
            # ... Existing Initialization Code ...
    
            # Settings button
            btn_settings = self.create_styled_button("تنظیمات")
            btn_settings.clicked.connect(self.open_settings)
            layout.addWidget(btn_settings)
    
        def open_settings(self):
            """Open the settings dialog."""
            dialog = SettingsDialog(self)
            dialog.exec()
    
    # Main application initialization
    if __name__ == "__main__":
        # Initialize the SQLite database (existing function)
        init_db()
    
        app = QApplication([])
        window = ModernMainWindow()
        window.setStyleSheet("QApplication { font-family: B Nazanin; }")  # Set application-wide style
        window.show()
        app.exec()
    

    Key Changes:

    1. SettingsDialog Class: This new class handles the settings interface, allowing users to select a background image and input a font size.

    2. select_background_image: This method opens a file dialog to choose an image file for the background.

    3. save_settings: This method is called when the user clicks the "ذخیره تنظیمات" button, applying the selected font size and background image to the main window.

    4. Settings Button: A button is added in the ModernMainWindow to open the settings dialog.

    Usage:

    • When the user clicks the "تنظیمات" button, the settings dialog opens.
    • They can select their preferred background image and adjust font size.
    • Upon saving, the changes are applied to the main application interface.

    Make sure your application has necessary permissions to access and display images and handle fonts correctly when executing the program.

  3. User

    حالا کل کد رو با این تغییرات که انجام دادی بهم بده

  4. Assistant

    بله، در ادامه، کل کد برنامه شما با تغییرات مربوط به افزودن بخش تنظیمات که شامل انتخاب تصویر پس‌زمینه و تغییر سایز فونت است ارائه شده است:

    import sqlite3
    import math
    from PySide6.QtWidgets import (
        QApplication, QMainWindow, QPushButton, QLabel, QVBoxLayout,
        QWidget, QTableWidget, QTableWidgetItem, QLineEdit, QFormLayout,
        QDialog, QFileDialog, QMessageBox, QComboBox, QHBoxLayout, QSpinBox
    )
    from PySide6.QtCore import Qt
    from reportlab.lib.pagesizes import letter
    from reportlab.pdfgen import canvas
    
    
    class ModernMainWindow(QMainWindow):
        def __init__(self):
            super().__init__()
            self.setWindowTitle("مدیریت هزینه‌های کافی شاپ")
            self.setGeometry(100, 100, 800, 600)
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
    
            # Main layout
            main_widget = QWidget()
            self.setCentralWidget(main_widget)
            layout = QVBoxLayout(main_widget)
    
            # Title label
            title_label = QLabel("محاسبه گر قیمت منو کافه پیونی")
            title_label.setStyleSheet("font-size: 24px; font-weight: bold; color: Gold;")
            title_label.setAlignment(Qt.AlignCenter)
            layout.addWidget(title_label)
    
            # Buttons
            btn_materials = self.create_styled_button("مواد اولیه")
            btn_materials.clicked.connect(self.manage_materials)
            layout.addWidget(btn_materials)
    
            btn_recipes = self.create_styled_button("رسپی‌ها")
            btn_recipes.clicked.connect(self.manage_recipes)
            layout.addWidget(btn_recipes)
    
            btn_menu = self.create_styled_button("نمایش منو")
            btn_menu.clicked.connect(self.show_menu)
            layout.addWidget(btn_menu)
    
            # Settings button
            btn_settings = self.create_styled_button("تنظیمات")
            btn_settings.clicked.connect(self.open_settings)
            layout.addWidget(btn_settings)
    
            # Footer
            footer_label = QLabel("Made By LoGiT3X with 🧡")
            footer_label.setStyleSheet("font-size: 12px; font-weight: bold; color: #f024b3;")
            footer_label.setAlignment(Qt.AlignCenter)
            layout.addWidget(footer_label)
    
        def create_styled_button(self, text):
            """Create a styled button with rounded corners and hover effects."""
            button = QPushButton(text)
            button.setStyleSheet("""
                QPushButton {
                    background-color: #0786b0;
                    color: black;
                    border: 2px solid #fcd40d;
                    border-radius: 25px;
                    font-size: 20px;
                    padding: 10px;
                    text-align: center;
                }
                QPushButton:hover {
                    background-color: #17627a;
                    border-color: fcd40d;
                    transition: background-color 0.3s;
                }
                QPushButton:pressed {
                    background-color: #fcd40d;
                    border-color: #FF0000;
                }
            """)
            return button
    
        def manage_materials(self):
            """Open the materials management window."""
            dialog = MaterialsDialog(self)
            dialog.exec()
    
        def manage_recipes(self):
            """Open the recipes management window."""
            dialog = RecipesDialog(self)
            dialog.exec()
    
        def show_menu(self):
            """Open the menu display window."""
            dialog = MenuDialog(self)
            dialog.exec()
    
        def open_settings(self):
            """Open the settings dialog."""
            dialog = SettingsDialog(self)
            dialog.exec()
    
    
    class SettingsDialog(QDialog):
        def __init__(self, parent=None):
            super().__init__(parent)
            self.setWindowTitle("تنظیمات")
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
            self.setGeometry(100, 100, 400, 300)
    
            self.layout = QVBoxLayout(self)
    
            # Font size
            self.font_size_label = QLabel("سایز فونت:")
            self.layout.addWidget(self.font_size_label)
    
            self.font_size_spinbox = QSpinBox()
            self.font_size_spinbox.setRange(8, 100)  # Set font size range
            self.layout.addWidget(self.font_size_spinbox)
    
            # Background image
            self.background_image_label = QLabel("انتخاب تصویر پس‌زمینه:")
            self.layout.addWidget(self.background_image_label)
    
            self.select_background_button = QPushButton("انتخاب تصویر")
            self.select_background_button.clicked.connect(self.select_background_image)
            self.layout.addWidget(self.select_background_button)
    
            # Save button
            self.save_button = QPushButton("ذخیره تنظیمات")
            self.save_button.clicked.connect(self.save_settings)
            self.layout.addWidget(self.save_button)
    
            self.background_image_path = ""
            self.font_size_spinbox.setValue(12)  # Default font size
    
        def select_background_image(self):
            """Open dialog to select a background image."""
            file_path, _ = QFileDialog.getOpenFileName(self, "انتخاب تصویر پس‌زمینه", "", "Images (*.png *.jpg *.jpeg *.bmp)")
            if file_path:
                self.background_image_path = file_path
    
        def save_settings(self):
            """Save the settings."""
            font_size = self.font_size_spinbox.value()
    
            if self.background_image_path:
                style_sheet = f"""
                    QMainWindow {{
                        background-image: url('{self.background_image_path}');
                        background-repeat: no-repeat;
                        background-position: center;
                    }}
                    QLabel, QPushButton {{
                        font-size: {font_size}px;
                    }}
                """
                self.parent().setStyleSheet(style_sheet)
            else:
                self.parent().setStyleSheet(f"QLabel, QPushButton {{ font-size: {font_size}px; }}")
    
            self.accept()
    
    
    class MaterialsDialog(QDialog):
        def __init__(self, parent=None):
            super().__init__(parent)
            self.setWindowTitle("مدیریت مواد اولیه")
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
            self.setGeometry(100, 100, 600, 400)
    
            layout = QVBoxLayout(self)
    
            # Table
            self.table = QTableWidget()
            self.table.setColumnCount(2)
            self.table.setHorizontalHeaderLabels(["نام مواد", "قیمت هر گرم"])
            self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
            self.refresh_materials()
            layout.addWidget(self.table)
    
            # Add form
            form_layout = QFormLayout()
            self.name_input = QLineEdit()
            self.price_input = QLineEdit()
            form_layout.addRow("نام:", self.name_input)
            form_layout.addRow("قیمت هر گرم:", self.price_input)
    
            add_button = QPushButton("اضافه کردن")
            add_button.clicked.connect(self.add_material)
            form_layout.addWidget(add_button)
    
            layout.addLayout(form_layout)
    
        def refresh_materials(self):
            """Refresh the materials table."""
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("SELECT name, price_per_gram FROM materials")
            materials = cursor.fetchall()
            conn.close()
    
            self.table.setRowCount(len(materials))
            for row, material in enumerate(materials):
                self.table.setItem(row, 0, QTableWidgetItem(material[0]))
                self.table.setItem(row, 1, QTableWidgetItem(str(int(material[1]))))  # Convert to integer
    
        def add_material(self):
            """Add a new material."""
            name = self.name_input.text()
            price = self.price_input.text()
    
            if not name or not price:
                QMessageBox.warning(self, "خطا", "تمام فیلدها را پر کنید.")
                return
    
            try:
                price = int(price)  # Convert price to integer
            except ValueError:
                QMessageBox.warning(self, "خطا", "قیمت باید عدد باشد.")
                return
    
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            try:
                cursor.execute("INSERT INTO materials (name, price_per_gram) VALUES (?, ?)", (name, price))
                conn.commit()
            except sqlite3.IntegrityError:
                QMessageBox.warning(self, "خطا", "این ماده قبلاً ثبت شده است.")
            finally:
                conn.close()
    
            self.refresh_materials()
            self.name_input.clear()
            self.price_input.clear()
    
    
    class RecipesDialog(QDialog):
        def __init__(self, parent=None):
            super().__init__(parent)
            self.setWindowTitle("مدیریت رسپی‌ها")
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
            self.setGeometry(100, 100, 800, 500)
    
            layout = QVBoxLayout(self)
    
            # Table
            self.table = QTableWidget()
            self.table.setColumnCount(2)
            self.table.setHorizontalHeaderLabels(["نام رسپی", "تعداد مواد اولیه"])
            self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
            self.refresh_recipes()
            layout.addWidget(self.table)
    
            # Buttons
            button_layout = QHBoxLayout()
            add_button = QPushButton("اضافه کردن رسپی")
            add_button.clicked.connect(self.add_recipe)
            button_layout.addWidget(add_button)
    
            edit_button = QPushButton("ویرایش رسپی")
            edit_button.clicked.connect(self.edit_recipe)
            button_layout.addWidget(edit_button)
    
            delete_button = QPushButton("حذف رسپی")
            delete_button.clicked.connect(self.delete_recipe)
            button_layout.addWidget(delete_button)
    
            layout.addLayout(button_layout)
    
        def refresh_recipes(self):
            """Fetch recipes and display them in the table."""
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("""
                SELECT r.id, r.name, COUNT(rd.material_id) 
                FROM recipes r
                LEFT JOIN recipe_details rd ON r.id = rd.recipe_id
                GROUP BY r.id
            """)
            recipes = cursor.fetchall()
            conn.close()
    
            self.table.setRowCount(len(recipes))
            for row, (recipe_id, name, material_count) in enumerate(recipes):
                self.table.setItem(row, 0, QTableWidgetItem(name))
                self.table.setItem(row, 1, QTableWidgetItem(str(material_count)))
    
        def add_recipe(self):
            """Open a dialog to add a new recipe."""
            dialog = RecipeEditDialog(self)
            dialog.exec()
            self.refresh_recipes()
    
        def edit_recipe(self):
            """Open a dialog to edit the selected recipe."""
            selected_row = self.table.currentRow()
            if selected_row == -1:
                QMessageBox.warning(self, "خطا", "لطفاً یک رسپی را انتخاب کنید.")
                return
    
            recipe_name = self.table.item(selected_row, 0).text()
            dialog = RecipeEditDialog(self, recipe_name)
            dialog.exec()
            self.refresh_recipes()
    
        def delete_recipe(self):
            """Delete the selected recipe."""
            selected_row = self.table.currentRow()
            if selected_row == -1:
                QMessageBox.warning(self, "خطا", "لطفاً یک رسپی را انتخاب کنید.")
                return
    
            recipe_name = self.table.item(selected_row, 0).text()
            confirm = QMessageBox.question(
                self, "حذف رسپی", f"آیا مطمئن هستید که می‌خواهید رسپی '{recipe_name}' را حذف کنید؟",
                QMessageBox.Yes | QMessageBox.No
            )
            if confirm == QMessageBox.Yes:
                conn = sqlite3.connect("coffee_shop.db")
                cursor = conn.cursor()
                cursor.execute("DELETE FROM recipes WHERE name = ?", (recipe_name,))
                cursor.execute("DELETE FROM recipe_details WHERE recipe_id = (SELECT id FROM recipes WHERE name = ?)",
                               (recipe_name,))
                conn.commit()
                conn.close()
                self.refresh_recipes()
    
    
    class RecipeEditDialog(QDialog):
        def __init__(self, parent=None, recipe_name=None):
            super().__init__(parent)
            self.recipe_name = recipe_name
            self.setWindowTitle("ویرایش رسپی" if recipe_name else "اضافه کردن رسپی")
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
            self.setGeometry(100, 100, 600, 400)
    
            layout = QVBoxLayout(self)
    
            # Recipe name
            self.name_input = QLineEdit()
            if recipe_name:
                self.name_input.setText(recipe_name)
            layout.addWidget(QLabel("نام رسپی:"))
            layout.addWidget(self.name_input)
    
            # Materials table
            self.table = QTableWidget()
            self.table.setColumnCount(2)
            self.table.setHorizontalHeaderLabels(["مواد اولیه", "مقدار (گرم)"])
            self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
            layout.addWidget(self.table)
    
            # Add material
            form_layout = QFormLayout()
            self.material_combo = QComboBox()
            self.material_combo.addItems(self.get_material_names())
            self.quantity_input = QLineEdit()
            form_layout.addRow("مواد اولیه:", self.material_combo)
            form_layout.addRow("مقدار (گرم):", self.quantity_input)
    
            add_material_button = QPushButton("اضافه کردن ماده")
            add_material_button.clicked.connect(self.add_material)
            form_layout.addWidget(add_material_button)
            layout.addLayout(form_layout)
    
            # Save button
            save_button = QPushButton("ذخیره رسپی")
            save_button.clicked.connect(self.save_recipe)
            layout.addWidget(save_button)
    
            if recipe_name:
                self.load_recipe()
    
        def get_material_names(self):
            """Get all material names from the database."""
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("SELECT name FROM materials")
            materials = [row[0] for row in cursor.fetchall()]
            conn.close()
            return materials
    
        def load_recipe(self):
            """Load the selected recipe details."""
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("""
                SELECT m.name, rd.quantity
                FROM recipe_details rd
                JOIN materials m ON rd.material_id = m.id
                WHERE rd.recipe_id = (SELECT id FROM recipes WHERE name = ?)
            """, (self.recipe_name,))
            materials = cursor.fetchall()
            conn.close()
    
            self.table.setRowCount(len(materials))
            for row, (material_name, quantity) in enumerate(materials):
                self.table.setItem(row, 0, QTableWidgetItem(material_name))
                self.table.setItem(row, 1, QTableWidgetItem(str(int(quantity))))  # Convert to integer
    
        def add_material(self):
            """Add a material to the recipe."""
            material_name = self.material_combo.currentText()
            quantity = self.quantity_input.text()
            if not quantity:
                QMessageBox.warning(self, "خطا", "لطفاً مقدار را وارد کنید.")
                return
    
            try:
                quantity = int(quantity)  # Convert to integer
            except ValueError:
                QMessageBox.warning(self, "خطا", "مقدار باید عدد باشد.")
                return
    
            current_row_count = self.table.rowCount()
            self.table.insertRow(current_row_count)
            self.table.setItem(current_row_count, 0, QTableWidgetItem(material_name))
            self.table.setItem(current_row_count, 1, QTableWidgetItem(str(quantity)))  # Convert to integer
    
        def save_recipe(self):
            """Save the recipe to the database."""
            recipe_name = self.name_input.text()
            if not recipe_name:
                QMessageBox.warning(self, "خطا", "لطفاً نام رسپی را وارد کنید.")
                return
    
            materials = []
            for row in range(self.table.rowCount()):
                material_name = self.table.item(row, 0).text()
                quantity = self.table.item(row, 1).text()
                try:
                    quantity = int(quantity)  # Ensure quantity is integer
                    materials.append((material_name, quantity))
                except ValueError:
                    QMessageBox.warning(self, "خطا", f"مقدار برای '{material_name}' نامعتبر است.")
                    return
    
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
    
            if self.recipe_name:  # Update existing recipe
                cursor.execute("UPDATE recipes SET name = ? WHERE name = ?", (recipe_name, self.recipe_name))
                cursor.execute("DELETE FROM recipe_details WHERE recipe_id = (SELECT id FROM recipes WHERE name = ?)",
                               (recipe_name,))
            else:  # Insert new recipe
                cursor.execute("INSERT INTO recipes (name) VALUES (?)", (recipe_name,))
            recipe_id = cursor.execute("SELECT id FROM recipes WHERE name = ?", (recipe_name,)).fetchone()[0]
    
            for material_name, quantity in materials:
                material_id = cursor.execute("SELECT id FROM materials WHERE name = ?", (material_name,)).fetchone()[0]
                cursor.execute("INSERT INTO recipe_details (recipe_id, material_id, quantity) VALUES (?, ?, ?)",
                               (recipe_id, material_id, quantity))
    
            conn.commit()
            conn.close()
            QMessageBox.information(self, "موفقیت", "رسپی با موفقیت ذخیره شد.")
            self.accept()
    
    
    class MenuDialog(QDialog):
        def __init__(self, parent=None):
            super().__init__(parent)
            self.setWindowTitle("نمایش منو")
            self.setStyleSheet("background-color: #2E2E2E; color: white; font-family: B Nazanin;")
            self.setGeometry(100, 100, 800, 500)
    
            layout = QVBoxLayout(self)
    
            # Table
            self.table = QTableWidget()
            self.table.setColumnCount(4)
            self.table.setHorizontalHeaderLabels(["نام محصول", "قیمت اولیه", "قیمت ثانویه", "قیمت نهایی (تومان)"])
            self.table.setStyleSheet("QTableWidget {background-color: #3E3E3E; color: white;} QHeaderView::section {background-color: #e7c29e; color: black; font-weight: bold;}")
            self.refresh_menu()
            layout.addWidget(self.table)
    
            # Export button
            export_button = QPushButton("ذخیره به PDF")
            export_button.clicked.connect(self.export_to_pdf)
            layout.addWidget(export_button)
    
        def refresh_menu(self):
            """Fetch menu items and display them in the table."""
            prices = self.calculate_prices()
            self.table.setRowCount(len(prices))
            for row, (name, raw_price, secondary_price, final_price) in enumerate(prices):
                self.table.setItem(row, 0, QTableWidgetItem(name))
                self.table.setItem(row, 1, QTableWidgetItem(f"{raw_price} تومان"))
                self.table.setItem(row, 2, QTableWidgetItem(f"{secondary_price} تومان"))
                self.table.setItem(row, 3, QTableWidgetItem(f"{final_price} تومان"))
    
        def calculate_prices(self):
            """Calculate prices for each recipe."""
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("""
                SELECT r.name, 
                       SUM(rd.quantity * m.price_per_gram) AS raw_price
                FROM recipes r
                JOIN recipe_details rd ON r.id = rd.recipe_id
                JOIN materials m ON rd.material_id = m.id
                GROUP BY r.id
            """)
            data = cursor.fetchall()
            conn.close()
    
            prices = []
            for name, raw_price in data:
                if raw_price is None:
                    continue
                raw_price = round(raw_price)
                secondary_price = round(raw_price * 3.3)
                price_with_tax = round(secondary_price * 1.1)
                final_price = math.ceil(price_with_tax)
                prices.append((name, raw_price, secondary_price, final_price))
            return prices
    
        def export_to_pdf(self):
            """Export the menu to a PDF file."""
            file_path, _ = QFileDialog.getSaveFileName(self, "ذخیره فایل", filter="PDF Files (*.pdf)")
            if not file_path:
                return
    
            prices = self.calculate_prices()
            if not prices:
                QMessageBox.warning(self, "خطا", "هیچ محصولی برای ذخیره وجود ندارد.")
                return
    
            try:
                c = canvas.Canvas(file_path, pagesize=letter)
                c.setFont("Helvetica", 12)
                c.drawString(30, 750, "گزارش منوی کافی‌شاپ")
                y = 730
                for name, raw_price, secondary_price, final_price in prices:
                    c.drawString(30, y, f"{name}: {final_price} تومان (قیمت اولیه: {raw_price}، قیمت ثانویه: {secondary_price})")
                    y -= 20
                    if y < 50:  # Create a new page if the content exceeds one page
                        c.showPage()
                        c.setFont("Helvetica", 12)
                        y = 750
                c.save()
                QMessageBox.information(self, "موفقیت", "منو با موفقیت به PDF ذخیره شد.")
            except Exception as e:
                QMessageBox.critical(self, "خطا", f"خطایی رخ داد: {str(e)}")
    
    
    if __name__ == "__main__":
        # Initialize SQLite database
        def init_db():
            conn = sqlite3.connect("coffee_shop.db")
            cursor = conn.cursor()
            cursor.execute("""
            CREATE TABLE IF NOT EXISTS materials (
            id INTEGER PRIMARY KEY,
            name TEXT UNIQUE NOT NULL,
            price_per_gram INTEGER NOT NULL  -- Changed to INTEGER
            )
            """)
            cursor.execute("""
            CREATE TABLE IF NOT EXISTS recipes (
            id INTEGER PRIMARY KEY,
            name TEXT UNIQUE NOT NULL
            )
            """)
            cursor.execute("""
            CREATE TABLE IF NOT EXISTS recipe_details (
            recipe_id INTEGER NOT NULL,
            material_id INTEGER NOT NULL,
            quantity INTEGER NOT NULL,  -- Changed to INTEGER
            FOREIGN KEY(recipe_id) REFERENCES recipes(id),
            FOREIGN KEY(material_id) REFERENCES materials(id)
            )
            """)
            conn.commit()
            conn.close()
    
        init_db()
    
        app = QApplication([])
        window = ModernMainWindow()
        window.setStyleSheet("QApplication { font-family: B Nazanin; }")  # Set application-wide style
        window.show()
        app.exec()
    

    این کد شامل تمام تغییرات است که شما درخواست کرده‌اید، از جمله افزودن بخش تنظیمات برای انتخاب تصویر پس‌زمینه و تغییر سایز فونت. حالا می‌توانید این کد را در محیط پایتون خود اجرا کنید و ویژگی‌های جدید را تست کنید.

  5. User

    یه سری تمحیدات در نظر بگیر که قیمت مواد اولیه و لیست مواد اولیه به صورت پیش فرض از این داک گوگل در نرم افزار کپی بشه و در بخش مواد اولیه ثبت بشه:

    https://docs.google.com/document/d/1K3FGUBqpdeFZKy0yJin9TVhYqoyOWPH87vYfs6sJUSc/edit?usp=sharing

    ولی همچنان تمامی قابلیت های برنامه بافی بمونه

  6. Assistant

    برای اینکه بتوانید اطلاعات قیمت مواد اولیه و لیست مواد اولیه را به صورت پیش‌فرض از داک گوگل کپی کنید و در بخش مواد اولیه برنامه‌ی خود ثبت کنید، باید از Google Docs API استفاده کنید. این امکان وجود دارد که داده‌ها را با استفاده از API به برنامه شما اضافه کنید. در زیر مراحلی برای انجام این کار به همراه کد نشان داده شده است.

    مراحل انجام کار:

    1. فعال‌سازی Google Docs API:

      • به Google Developers Console بروید.
      • یک پروژه جدید ایجاد کنید.
      • Google Docs API را فعال کنید.
      • یک کلید API ایجاد کنید.
    2. نصب کتابخانه‌های مورد نیاز:

      • از کتابخانه google-auth و google-api-python-client برای استفاده از API Google Docs استفاده کنید. نام این کتابخانه‌ها را می‌توانید در virtual environment خود با استفاده از pip نصب کنید:
        pip install google-auth google-auth-oauthlib google-auth-httplib2 google-api-python-client
        
    3. خواندن داده‌ها از داک گوگل:

      • با استفاده از API، داده‌ها را از داک گوگل خوانده و به برنامه اضافه کنید.

    کد نمونه:

    در اینجا یک مثال کلی از نحوه بارگذاری محتویات داک گوگل در SQLite به همراه کد موجود برای ذخیره‌سازی روزی داده‌ها آورده شده است.

    import sqlite3
    import math
    import os
    from PySide6.QtWidgets import (
        QApplication, QMainWindow, QPushButton, QLabel, QVBoxLayout,
        QWidget, QTableWidget, QTableWidgetItem, QLineEdit, QFormLayout,
        QDialog, QFileDialog, QMessageBox, QComboBox, QHBoxLayout, QSpinBox
    )
    from PySide6.QtCore import Qt
    from reportlab.lib.pagesizes import letter
    from reportlab.pdfgen import canvas
    from google.oauth2 import service_account
    from googleapiclient.discovery import build
    
    # Google Docs credentials
    SERVICE_ACCOUNT_FILE = 'path/to/your/service-account-file.json'
    SCOPES = ['https://www.googleapis.com/auth/documents.readonly']
    
    DOCS_ID = '1K3FGUBqpdeFZKy0yJin9TVhYqoyOWPH87vYfs6sJUSc'
    
    
    def get_google_docs_content(doc_id):
        """Fetch content from Google Docs."""
        credentials = service_account.Credentials.from_service_account_file(
            SERVICE_ACCOUNT_FILE, scopes=SCOPES)
        service = build('docs', 'v1', credentials=credentials)
        document = service.documents().get(documentId=doc_id).execute()
        content = document.get('body').get('content')
        
        materials = []
        for item in content:
            paragraph = item.get('paragraph')
            if paragraph:
                elements = paragraph.get('elements')
                for element in elements:
                    text_run = element.get('textRun')
                    if text_run:
                        materials.append(text_run.get('content'))
    
        return materials
    
    
    class ModernMainWindow(QMainWindow):
        # ... (existing code)
    
        def manage_materials(self):
            """Open the materials management window."""
            dialog = MaterialsDialog(self)
            dialog.fetch_initial_data()
            dialog.exec()
    
    
    class MaterialsDialog(QDialog):
        # ... (existing code)
    
        def fetch_initial_data(self):
            """Fetch initial data from Google Docs."""
            materials_data = get_google_docs_content(DOCS_ID)
    
            for line in materials_data:
                if line.strip():  # Ignore empty lines
                    parts = line.split(',')
                    if len(parts) == 2:
                        name, price = parts[0].strip(), parts[1].strip()
                        self.add_material_to_db(name, price)
    
            # Refresh the table after adding initial data
            self.refresh_materials()
    
        def add_material_to_db(self, name, price):
            """Add a material to the database."""
            if price.isdigit():  # Making sure the price is a number
                conn = sqlite3.connect("coffee_shop.db")
                cursor = conn.cursor()
                try:
                    cursor.execute("INSERT INTO materials (name, price_per_gram) VALUES (?, ?)", (name, int(price)))
                    conn.commit()
                except sqlite3.IntegrityError:
                    QMessageBox.warning(self, "خطا", f"این ماده '{name}' قبلاً ثبت شده است.")
                finally:
                    conn.close()
    
    # ... (rest of the code remains unchanged)
    
    if __name__ == "__main__":
        # Perform database initialization and GUI setup
        init_db()
        app = QApplication([])
        window = ModernMainWindow()
        window.setStyleSheet("QApplication { font-family: B Nazanin; }")  # Set application-wide style
        window.show()
        app.exec()
    

    نکات مهم:

    • کلید API: به جای path/to/your/service-account-file.json آدرس فایلی که کلید سرویس شما در آن قرار دارد را بگذارید.
    • تصویر داک گوگل: مطمئن شوید که این تصویر برای خواندن هر کاربری در دسترس است. در غیر این صورت، ممکن است لازم باشد دسترسی‌های لازم را برای گواهی‌نامه‌ها تعیین کنید.
    • فرمت داک گوگل: مطمئن شوید که اطلاعات در داک شما به صورت نام ماده, قیمت باشد تا بتوان به راحتی آنها را از هم جدا کرد.

    با این روش، می‌توانید قیمت‌های مواد اولیه را به صورت خودکار از داک گوگل دریافت کنید و به برنامه اضافه نمایید.