import qrcode
import sqlite3
from datetime import datetime
 
# สร้างฐานข้อมูล SQLite
conn = sqlite3.connect("cow_feeding.db")
c = conn.cursor()
 
# ตารางเก็บข้อมูลวัว
c.execute('''CREATE TABLE IF NOT EXISTS cows (
                id TEXT PRIMARY KEY,
                name TEXT,
                breed TEXT,
                dob TEXT,
                weight INTEGER
            )''')
 
# ตารางเก็บข้อมูลอาหาร
c.execute('''CREATE TABLE IF NOT EXISTS food (
                id TEXT PRIMARY KEY,
                type TEXT,
                production_date TEXT,
                ingredients TEXT,
                cost REAL
            )''')
 
# ตารางบันทึกการกินอาหาร
c.execute('''CREATE TABLE IF NOT EXISTS feeding_logs (
                log_id INTEGER PRIMARY KEY AUTOINCREMENT,
                cow_id TEXT,
                food_id TEXT,
                date TEXT,
                given_amount REAL,
                leftover_amount REAL,
                consumed_amount REAL,
                FOREIGN KEY(cow_id) REFERENCES cows(id),
                FOREIGN KEY(food_id) REFERENCES food(id)
            )''')
conn.commit()
 
# ฟังก์ชันสร้าง QR Code
def generate_qr(data, filename):
    qr = qrcode.make(data)
    qr.save(filename)
    print(f"QR Code saved as {filename}")
 
# ตัวอย่างการสร้าง QR Code ให้วัวและอาหาร
cow_data = "{\"id\": \"W-01\", \"name\": \"วัวแดง\", \"breed\": \"โคนม\", \"dob\": \"2023-05-10\", \"weight\": 450}"
generate_qr(cow_data, "cow_W-01.png")
 
food_data = "{\"id\": \"F-20250331-01\", \"type\": \"หญ้าเนเปียร์\", \"production_date\": \"2025-03-31\", \"ingredients\": \"หญ้าสด 100%\", \"cost\": 5.0}"
generate_qr(food_data, "food_F-20250331-01.png")
 
# ปิดฐานข้อมูล
conn.close()
 
 
}

aW1wb3J0IHFyY29kZQppbXBvcnQgc3FsaXRlMwpmcm9tIGRhdGV0aW1lIGltcG9ydCBkYXRldGltZQoKIyDguKrguKPguYnguLLguIfguJDguLLguJnguILguYnguK3guKHguLnguKUgU1FMaXRlCmNvbm4gPSBzcWxpdGUzLmNvbm5lY3QoImNvd19mZWVkaW5nLmRiIikKYyA9IGNvbm4uY3Vyc29yKCkKCiMg4LiV4Liy4Lij4Liy4LiH4LmA4LiB4LmH4Lia4LiC4LmJ4Lit4Lih4Li54Lil4Lin4Lix4LinCmMuZXhlY3V0ZSgnJydDUkVBVEUgVEFCTEUgSUYgTk9UIEVYSVNUUyBjb3dzICgKICAgICAgICAgICAgICAgIGlkIFRFWFQgUFJJTUFSWSBLRVksCiAgICAgICAgICAgICAgICBuYW1lIFRFWFQsCiAgICAgICAgICAgICAgICBicmVlZCBURVhULAogICAgICAgICAgICAgICAgZG9iIFRFWFQsCiAgICAgICAgICAgICAgICB3ZWlnaHQgSU5URUdFUgogICAgICAgICAgICApJycnKQoKIyDguJXguLLguKPguLLguIfguYDguIHguYfguJrguILguYnguK3guKHguLnguKXguK3guLLguKvguLLguKMKYy5leGVjdXRlKCcnJ0NSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIGZvb2QgKAogICAgICAgICAgICAgICAgaWQgVEVYVCBQUklNQVJZIEtFWSwKICAgICAgICAgICAgICAgIHR5cGUgVEVYVCwKICAgICAgICAgICAgICAgIHByb2R1Y3Rpb25fZGF0ZSBURVhULAogICAgICAgICAgICAgICAgaW5ncmVkaWVudHMgVEVYVCwKICAgICAgICAgICAgICAgIGNvc3QgUkVBTAogICAgICAgICAgICApJycnKQoKIyDguJXguLLguKPguLLguIfguJrguLHguJnguJfguLbguIHguIHguLLguKPguIHguLTguJnguK3guLLguKvguLLguKMKYy5leGVjdXRlKCcnJ0NSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIGZlZWRpbmdfbG9ncyAoCiAgICAgICAgICAgICAgICBsb2dfaWQgSU5URUdFUiBQUklNQVJZIEtFWSBBVVRPSU5DUkVNRU5ULAogICAgICAgICAgICAgICAgY293X2lkIFRFWFQsCiAgICAgICAgICAgICAgICBmb29kX2lkIFRFWFQsCiAgICAgICAgICAgICAgICBkYXRlIFRFWFQsCiAgICAgICAgICAgICAgICBnaXZlbl9hbW91bnQgUkVBTCwKICAgICAgICAgICAgICAgIGxlZnRvdmVyX2Ftb3VudCBSRUFMLAogICAgICAgICAgICAgICAgY29uc3VtZWRfYW1vdW50IFJFQUwsCiAgICAgICAgICAgICAgICBGT1JFSUdOIEtFWShjb3dfaWQpIFJFRkVSRU5DRVMgY293cyhpZCksCiAgICAgICAgICAgICAgICBGT1JFSUdOIEtFWShmb29kX2lkKSBSRUZFUkVOQ0VTIGZvb2QoaWQpCiAgICAgICAgICAgICknJycpCmNvbm4uY29tbWl0KCkKCiMg4Lif4Lix4LiH4LiB4LmM4LiK4Lix4LiZ4Liq4Lij4LmJ4Liy4LiHIFFSIENvZGUKZGVmIGdlbmVyYXRlX3FyKGRhdGEsIGZpbGVuYW1lKToKICAgIHFyID0gcXJjb2RlLm1ha2UoZGF0YSkKICAgIHFyLnNhdmUoZmlsZW5hbWUpCiAgICBwcmludChmIlFSIENvZGUgc2F2ZWQgYXMge2ZpbGVuYW1lfSIpCgojIOC4leC4seC4p+C4reC4ouC5iOC4suC4h+C4geC4suC4o+C4quC4o+C5ieC4suC4hyBRUiBDb2RlIOC5g+C4q+C5ieC4p+C4seC4p+C5geC4peC4sOC4reC4suC4q+C4suC4owpjb3dfZGF0YSA9ICJ7XCJpZFwiOiBcIlctMDFcIiwgXCJuYW1lXCI6IFwi4Lin4Lix4Lin4LmB4LiU4LiHXCIsIFwiYnJlZWRcIjogXCLguYLguITguJnguKFcIiwgXCJkb2JcIjogXCIyMDIzLTA1LTEwXCIsIFwid2VpZ2h0XCI6IDQ1MH0iCmdlbmVyYXRlX3FyKGNvd19kYXRhLCAiY293X1ctMDEucG5nIikKCmZvb2RfZGF0YSA9ICJ7XCJpZFwiOiBcIkYtMjAyNTAzMzEtMDFcIiwgXCJ0eXBlXCI6IFwi4Lir4LiN4LmJ4Liy4LmA4LiZ4LmA4Lib4Li14Lii4Lij4LmMXCIsIFwicHJvZHVjdGlvbl9kYXRlXCI6IFwiMjAyNS0wMy0zMVwiLCBcImluZ3JlZGllbnRzXCI6IFwi4Lir4LiN4LmJ4Liy4Liq4LiUIDEwMCVcIiwgXCJjb3N0XCI6IDUuMH0iCmdlbmVyYXRlX3FyKGZvb2RfZGF0YSwgImZvb2RfRi0yMDI1MDMzMS0wMS5wbmciKQoKIyDguJvguLTguJTguJDguLLguJnguILguYnguK3guKHguLnguKUKY29ubi5jbG9zZSgpCgoKfQ==