Documentation
SmartLib

# Mise à jour du système
sudo apt update && sudo apt upgrade -y

# Dépendances système
sudo apt install -y python3 python3-pip python3-tk samba avahi-daemon

# Modules Python
pip install reportlab paramiko mfrc522 RPi.GPIO --break-system-packages

# Activer SPI
sudo raspi-config  # → Interface Options → SPI → Enable

# Vérifier que SPI est activé
lsmod | grep spi

# Doit afficher : spidev  spi_bcm2835

# Test rapide de lecture RFID
python3 -c "from mfrc522 import SimpleMFRC522; r=SimpleMFRC522(); print(r.read())"

# Configuration
USER_HOME = "/home/abdel"
DB_PATH   = "/home/abdel/tfe/smartlib.db"

#Base de donnée
def init_db():
    conn = sqlite3.connect(DB_PATH)
    c    = conn.cursor()
    c.execute("""CREATE TABLE IF NOT EXISTS books (
        id       INTEGER PRIMARY KEY AUTOINCREMENT,
        title    TEXT NOT NULL,
        author   TEXT,
        genre    TEXT DEFAULT 'Général',
        quantity INTEGER DEFAULT 1
    )""")
    c.execute("""CREATE TABLE IF NOT EXISTS users (
        id   INTEGER PRIMARY KEY AUTOINCREMENT,
        uid  TEXT UNIQUE NOT NULL,
        name TEXT NOT NULL,
        email TEXT DEFAULT ''
    )""")
    c.execute("""CREATE TABLE IF NOT EXISTS loans (
        id          INTEGER PRIMARY KEY AUTOINCREMENT,
        user_id     INTEGER REFERENCES users(id),
        book_id     INTEGER REFERENCES books(id),
        borrow_date DATETIME,
        due_date    DATETIME,
        return_date DATETIME,
        status      TEXT DEFAULT 'En cours'
    )""")
    conn.commit()
    conn.close()

#RFID
def read_rfid():
    try:
        from mfrc522 import SimpleMFRC522
        r   = SimpleMFRC522()
        uid, _ = r.read()
        logger.info(f"🔖 RFID détecté - UID: {uid}")
        return str(uid)
    except Exception as e:
        logger.error(f"✗ Erreur lecture RFID: {e}")
        return None
    finally:
        GPIO.cleanup()

# Configuration SMTP
SMTP_EMAIL    = "abdelwadoud.bako@gmail.com"
SMTP_PASSWORD = "uhcamcmeuuonrlvt"   # App password Gmail
DESTINATAIRE  = "abdelwadoud.bako@inraci.be"

def send_email_with_pdf(pdf_path, book_title):
    if not SMTP_EMAIL or not SMTP_PASSWORD: return

    # Attendre que le PDF soit généré (max 2,5s)
    wait = 0
    while not os.path.exists(pdf_path) and wait < 5:
        time.sleep(0.5); wait += 0.5

    try:
        msg = MIMEMultipart()
        msg['From'], msg['To'] = SMTP_EMAIL, DESTINATAIRE
        msg['Subject'] = f"□ SmartLib : {book_title}"
        msg.attach(MIMEText(f"Livre emprunté : {book_title}", 'plain'))

        # Attacher le PDF
        with open(pdf_path, "rb") as f:
            part = MIMEBase('application', 'octet-stream')
            part.set_payload(f.read())
        encoders.encode_base64(part)
        msg.attach(part)

        # Envoi via Gmail SMTP port 587
        s = smtplib.SMTP('smtp.gmail.com', 587)
        s.starttls()
        s.login(SMTP_EMAIL, SMTP_PASSWORD)
        s.sendmail(SMTP_EMAIL, DESTINATAIRE, msg.as_string())
        s.quit()
    except Exception as e:
        logger.error(f"✗ Erreur Email: {e}")

def generate_receipt(book_id, borrow_date, due_date, username):
    conn = sqlite3.connect(DB_PATH); c = conn.cursor()
    c.execute("SELECT title, author, genre FROM books WHERE id=?", (book_id,))
    b = c.fetchone(); conn.close()
    if not b: return None

    title, author, genre = b
    fname = f"recu_emprunt_{book_id}_{datetime.now().strftime('%Y%m%d_%H%M')}.pdf"
    local = os.path.join(USER_HOME, fname)
    samba = os.path.join(SAMBAPATH, fname)
    os.makedirs(SAMBAPATH, exist_ok=True)

    # Création du PDF A4
    pdf = canvas.Canvas(local, pagesize=A4)
    w, h = A4
    pdf.setFont("Helvetica-Bold", 16)
    pdf.drawString(50, h-50,  "■ SmartLib - Reçu")
    pdf.setFont("Helvetica", 12)
    pdf.drawString(50, h-70,  f"Date : {datetime.now().strftime('%d/%m/%Y %H:%M')}")
    pdf.drawString(50, h-90,  f"Utilisateur : {username}")
    pdf.drawString(70, h-140, f"Titre  : {title}")
    pdf.drawString(70, h-160, f"Auteur : {author}")
    pdf.drawString(70, h-180, f"Genre  : {genre}")
    pdf.drawString(70, h-200, f"Emprunté le : {borrow_date}")
    pdf.drawString(70, h-220, f"À rendre    : {due_date}")
    pdf.save()

    try: shutil.copy2(local, samba)
    except Exception as e: print(f"Erreur Samba: {e}")
    return local, title

[global]
netbios name = smartlib

[SmartLib_Receipts]
path          = /home/abdel/smartlib_receipts
browseable    = yes
writable      = yes
guest ok      = yes
read only     = no
valid users   = abdel

# Dans la barre d'adresse de l'explorateur :
\\smartlib.local\SmartLib_Receipts

# Ou par IP directe :
\\192.168.0.195\SmartLib_Receipts

def setup_logging():
    logger = logging.getLogger("SmartLib")
    logger.setLevel(logging.INFO)
    try:
        handler   = logging.handlers.SysLogHandler(address='/dev/log')
        formatter = logging.Formatter(
            '%(asctime)s SmartLib: %(levelname)s - %(message)s')
        handler.setFormatter(formatter)
        logger.addHandler(handler)
    except Exception as e:
        console = logging.StreamHandler()
        logger.addHandler(console)
    return logger

logger = setup_logging()

sudo journalctl -f | grep SmartLib
# Ou :
sudo journalctl -u smartlib -f

# m  h  dom mon dow  commande

# Sauvegarde quotidienne de la base à 2h02
0 2 * * * cp /home/abdel/smartlib.db /home/abdel/smartlib/backups/smartlib_$(date +\%Y\%m\%d).db

# Suppression des backups vieux de +7 jours
0 2 * * * find /home/abdel/smartlib/backups -name 'smartlib_backup_*.db' -mtime +7 -delete

REMOTE_HOST = "ssh-abdel.alwaysdata.net"
REMOTE_PORT = 22
REMOTE_USER = "abdel"
REMOTE_PATH = "/home/abdel/backups/"

ssh abdel@ssh-abdel.alwaysdata.net
# Lister les backups :
ls -lh /home/abdel/backups/