from fastapi import APIRouter, Depends, UploadFile, File, Form from app.backend.db.database import get_db from sqlalchemy.orm import Session from app.backend.schemas import Complaint, VerifyComplaint from app.backend.classes.complaint_class import ComplaintClass from app.backend.classes.dropbox_class import DropboxClass import os import smtplib from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.mime.base import MIMEBase from email import encoders from string import Template from typing import Optional complaints = APIRouter( prefix="/complaints", tags=["Complaints"] ) @complaints.post("/store") def store(complaints: Complaint = Depends(Complaint.as_form), support: Optional[UploadFile] = File(None), db: Session = Depends(get_db)): complaints_dict = complaints.dict() id = ComplaintClass(db).store(complaints_dict) attachment_path = None if support: dropbox_client = DropboxClass(db) filename = dropbox_client.upload(name=id, description='complaint', data=support, dropbox_path='/complaints/', computer_path=os.path.join(os.path.dirname(__file__))) data = ComplaintClass(db).update(id, filename) attachment_path = filename # Ruta del archivo para adjuntar send_email(id, complaints_dict, "contacto@jisparking.com", attachment_path) send_email(id, complaints_dict, "patriciogomez@jisparking.com", attachment_path) return {"message": data if support else ""} def send_email(id, complaint_data: dict, recipient: str, attachment_path: Optional[str] = None): sender_email = "no-reply@jisparking.com" sender_password = "Noreply2024!" subject = "Canal de Denuncias - Detalles de la Denuncia" html_template = Template(""" Detalles de la Denuncia

Detalles de la Denuncia

N° de Denuncia ${id}
¿Cuál es su relación con Jisparking SpA? ${relationship}
Lugar donde sucedió el incidente: ${incident_place}
Tipo de Denuncia ${complaint_type}
¿Desea permanecer en el anonimato para esta denuncia? ${anonymous}
¿En qué fecha sucedió el incidente? ${incident_date}
¿Dónde sucedió la infracción? ${incident_place_detail}
¿Cómo tomó conocimiento de este hecho? ${knowledge}
¿Puede identificar a las personas comprometidas en esta infracción? ${identify}
Descripción ${description}
Correo ${email}
""") # Substitute the placeholders with actual values html_content = html_template.substitute( id=id, relationship=complaint_data.get('relationship', 'N/A'), incident_place=complaint_data.get('incident_place', 'N/A'), complaint_type=complaint_data.get('complaint_type', 'N/A'), anonymous=complaint_data.get('anonymous', 'N/A'), incident_date=complaint_data.get('incident_date', 'N/A'), incident_place_detail=complaint_data.get('incident_place_detail', 'N/A'), knowledge=complaint_data.get('knowledge', 'N/A'), identify=complaint_data.get('identify', 'N/A'), description=complaint_data.get('description', 'N/A'), email=complaint_data.get('email', 'N/A') ) # Create the email msg = MIMEMultipart() msg['From'] = sender_email msg['To'] = recipient msg['Subject'] = subject # Attach the HTML content msg.attach(MIMEText(html_content, 'html')) # Attach the file if provided if attachment_path: with open(attachment_path, 'rb') as attachment: part = MIMEBase('application', 'octet-stream') part.set_payload(attachment.read()) encoders.encode_base64(part) part.add_header( "Content-Disposition", f"attachment; filename= {os.path.basename(attachment_path)}", ) msg.attach(part) # Send the email try: server = smtplib.SMTP_SSL('mail.jisparking.com', 465) server.login(sender_email, sender_password) server.sendmail(sender_email, recipient, msg.as_string()) server.quit() print("Email sent successfully") except Exception as e: print(f"Failed to send email: {e}") @complaints.post("/verify") def verify(id: str = Form(...), password: str = Form(...), db: Session = Depends(get_db)): data = ComplaintClass(db).verify({"id": id, "password": password}) return {"message": data}