class UserService:
userRepository = UserRepository()
def getUserDetails(self, userid):
return self.userRepository.getUserDetails(userid)
def submitUserDetails(self, jsonRequest):
return self.userRepository.submitUserDetails(jsonRequest)
def validateUsernamePassword(self, username_password):
return self.userRepository.validateUsernamePassword(username_password)
def __init__(self):
self.food_repo = FoodRepository()
self.user_repo = UserRepository()
# create formatter and add it to the handlers
formatter = logging.Formatter(
'[%(levelname)s] %(asctime)s - %(message)s',
datefmt="%d/%m/%Y %H:%M:%S")
# create file handler which logs even debug messages
my_handler = RotatingFileHandler('gmail.log',
mode='a',
maxBytes=10 * pow(10, 6),
backupCount=5,
encoding=None,
delay=0)
my_handler.setFormatter(formatter)
my_handler.setLevel(logging.DEBUG)
# create logger with 'spam_application'
self.logger = logging.getLogger('gmail')
self.logger.setLevel(logging.DEBUG)
self.logger.addHandler(my_handler)
def __init__(self):
# create formatter and add it to the handlers
formatter = logging.Formatter(
'[%(levelname)s] %(asctime)s - %(message)s',
datefmt="%d/%m/%Y %H:%M:%S")
# create file handler which logs even debug messages
my_handler = RotatingFileHandler('food_assistance.log',
mode='a',
maxBytes=10 * pow(10, 6),
backupCount=5,
encoding=None,
delay=0)
my_handler.setFormatter(formatter)
my_handler.setLevel(logging.DEBUG)
# create logger with 'spam_application'
self.logger = logging.getLogger('food_assistance')
self.logger.setLevel(logging.DEBUG)
self.logger.addHandler(my_handler)
self.root = Tk()
self.root.title("Assistance de cuisine")
self.root.geometry('800x260+0+0')
self.root.configure(padx="10", pady="10")
self.food_repository = FoodRepository()
self.user_repository = UserRepository()
self.db_manager = DBManager()
self.db_manager.init()
self.gmail = GmailManager()
self.measuring_units = ('', 'g', 'kg', 'l', 'cl', 'ml', 'sachet',
'paquet', 'bouteille')
self.foods = self.food_repository.get_foods(
) # Liste des aliments dans la liste des courses
self.mail_sender_accept = self.user_repository.get_users_mails()
self.tree_columns = ('id', 'quantity', 'unit', 'food')
def __init__(self):
self.nid = IntegerField(
required=False,
widget=Widget.InputText(attributes={'class': 'hide'}))
self.name = StringField()
self.domain = StringField()
self.business_mobile = StringField()
self.business_phone = StringField()
self.qq = StringField()
self.address = StringField(widget=Widget.TextArea(
attributes={'class': 'address'}))
self.backend_mobile = StringField()
self.backend_phone = StringField()
self.user_id = IntegerField(widget=Widget.Select(
attributes={},
choices=UserService(UserRepository()).get_user_to_select()))
self.province_id = IntegerField(
widget=Widget.Select(attributes={'id': 'province'},
choices=[{
'value': 0,
'text': '请选择省份'
}]))
self.city_id = IntegerField(widget=Widget.Select(
attributes={'id': 'city'}, choices=[{
'value': 0,
'text': '请选择市'
}]))
self.county_id = IntegerField(
widget=Widget.Select(attributes={'id': 'county'},
choices=[{
'value': 0,
'text': '请选择县（区）'
}]))
super(MerchantForm, self).__init__()
def post(self):
post_data = self.get_argument('post_data', None)
post_data_dict = json.loads(post_data)
if self.session['CheckCode'].upper() == post_data_dict.get(
'checkcode').upper():
user = post_data_dict.get('username', None)
if re.match(pattern, user):
email = user
user = None
else:
email = None
pwd = post_data_dict.get('password', None)
# Service层
user_request = UserRequest(username=user,
email=email,
password=pwd)
Mapper.register(ModelUserService, UserRepository())
Mapper.register(UserService, ModelUserService())
user_service = UserService() # 依赖注入Model(业务逻辑层)的对应‘协调’
response = user_service.check_login(user_request)
if response.status:
self.session['is_login'] = True
response_str = json.dumps(response.status, cls=JsonCustomEncoder)
self.write(response_str)
class GmailManager:
def __init__(self):
self.food_repo = FoodRepository()
self.user_repo = UserRepository()
# create formatter and add it to the handlers
formatter = logging.Formatter(
'[%(levelname)s] %(asctime)s - %(message)s',
datefmt="%d/%m/%Y %H:%M:%S")
# create file handler which logs even debug messages
my_handler = RotatingFileHandler('gmail.log',
mode='a',
maxBytes=10 * pow(10, 6),
backupCount=5,
encoding=None,
delay=0)
my_handler.setFormatter(formatter)
my_handler.setLevel(logging.DEBUG)
# create logger with 'spam_application'
self.logger = logging.getLogger('gmail')
self.logger.setLevel(logging.DEBUG)
self.logger.addHandler(my_handler)
def connect(self):
# Login to INBOX
self.logger.info("Connexion au compte Gmail en cours...")
imap = imaplib.IMAP4_SSL("imap.gmail.com", 993)
try:
imap.login(param.gmail['username'], param.gmail['password'])
return imap
except:
self.logger.error("Unexpected error: %s", sys.exc_info()[1])
def read(self):
imap = self.connect()
try:
self.logger.info("Recherche de nouveaux emails en cours...")
imap.select()
result, data = imap.uid('search', None,
"UNSEEN") # search and return uids instead
uids = data[0].split()
if len(uids) == 0:
self.logger.info("Pas de nouveau email.")
return
else:
self.logger.info('Nouveaux emails non lus en attente...')
foods = self.food_repo.get_foods()
sender_accept = self.user_repo.get_users_mails()
for uid in uids:
result, data = imap.uid('fetch', uid, '(RFC822)')
raw_email = data[0][1]
email_message = email.message_from_bytes(raw_email)
get_from = re.search('<([^>]+)>', email_message['from'],
re.IGNORECASE)
mail_from = get_from if not get_from else get_from.group(1)
self.logger.info(
"Nouveau email reçu de `%s`. Traitement en cours...",
mail_from)
if get_from and mail_from in sender_accept:
self.logger.info(
"L'expéditeur `%s` est utilisateur de l'app --> mail accepté..."
)
msg = ''
if email_message.is_multipart():
for payload in email_message.get_payload():
# if payload.is_multipart(): ...
msg = payload.get_payload()
break
else:
msg = email_message.get_payload()
self.logger.info("Commande reçue: `%s`.", mail_from, msg)
if msg.strip().lower() in ['send shopping list', 'send']:
self.send(mail_from, foods)
pass
except:
self.logger.error("Unexpected error: %s", sys.exc_info()[1])
finally:
try:
self.logger.info('Déconnexion du compte en cours...')
imap.logout()
except:
self.logger.error("Unexpected error: %s", sys.exc_info()[1])
def send(self, to, foods):
fromaddr = param.gmail['username']
toaddr = to
msg = MIMEMultipart('alternative')
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "Liste de courses"
html = '<div style="max-width:700px; background-color:#f5f5f5; margin:auto;">' \
'<div style="font-size: 1.5em;color: whitesmoke;padding: 20px;text-align: center;background-color: #187718;">' \
'FoodAssistance' \
'</div>' \
'<div style="padding: 15px;color: #272727;">' \
'<p>Bonjour,</p>' \
'<p>Vous trouverez ci-dessous votre liste des courses :</p><ul>'
for food in foods:
quantity = str(food.quantity) if food.quantity and float(
food.quantity) > 0 else ''
html += '<li>%s %s <strong>%s</strong></li>' % (
quantity, str(food.measuring_units), food.name)
html += '</ul>' \
'</div>' \
'<div style="font-size: 0.85em;color: whitesmoke;padding: 5px 15px;text-align: center;background-color: #2d3271;">' \
'Ce message vous a été envoyé automatiquement, merci de ne pas y répondre. ' \
'Votre réponse ne sera pas traitée ! <br> Nous vous invitons à ajouter l\'adresse mail ' \
'[email protected] à votre carnet d\'adresses. Ainsi, vous serez sûr(e) de ' \
'recevoir nos mails.</div>' \
'</div>'
msg.attach(MIMEText(html, 'html'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, param.gmail['password'])
server.sendmail(fromaddr, toaddr, msg.as_string())
server.quit()
self.logger.info("Envoi de la liste des courses à `%s`.", toaddr)
#!/usr/bin/env/ python # -*-coding:utf-8 -*- from Infrastructure.DI.DI import Mapper from Model.User import UserService from Repository.UserRepository import UserRepository from Model.Merchant import MerchantService from Repository.MerChantRepository import MerchantRepository from Model.Region import ProvinceService, CountryService, CityService from Repository.RegionRepository import ProvinceRepository, CountryRepository, CityRepository #依赖关系 Mapper.register(UserService, UserRepository()) Mapper.register(MerchantService, MerchantRepository()) Mapper.register(ProvinceService, ProvinceRepository()) Mapper.register(CityService, CityRepository()) Mapper.register(CountryService, CountryRepository())
class Assistance:
def __init__(self):
# create formatter and add it to the handlers
formatter = logging.Formatter(
'[%(levelname)s] %(asctime)s - %(message)s',
datefmt="%d/%m/%Y %H:%M:%S")
# create file handler which logs even debug messages
my_handler = RotatingFileHandler('food_assistance.log',
mode='a',
maxBytes=10 * pow(10, 6),
backupCount=5,
encoding=None,
delay=0)
my_handler.setFormatter(formatter)
my_handler.setLevel(logging.DEBUG)
# create logger with 'spam_application'
self.logger = logging.getLogger('food_assistance')
self.logger.setLevel(logging.DEBUG)
self.logger.addHandler(my_handler)
self.root = Tk()
self.root.title("Assistance de cuisine")
self.root.geometry('800x260+0+0')
self.root.configure(padx="10", pady="10")
self.food_repository = FoodRepository()
self.user_repository = UserRepository()
self.db_manager = DBManager()
self.db_manager.init()
self.gmail = GmailManager()
self.measuring_units = ('', 'g', 'kg', 'l', 'cl', 'ml', 'sachet',
'paquet', 'bouteille')
self.foods = self.food_repository.get_foods(
) # Liste des aliments dans la liste des courses
self.mail_sender_accept = self.user_repository.get_users_mails()
self.tree_columns = ('id', 'quantity', 'unit', 'food')
def start(self):
self.display_window()
def display_course_tab(self, tab):
""" Affiche l'onglet "Liste de courses" """
# Formulaire d'ajout de nourriture
add_frame = Frame(tab)
add_frame.grid(column=0, row=0, sticky=(W, E), padx=15, pady=10)
food_name_var = StringVar()
food_name_entry = ttk.Entry(add_frame, textvariable=food_name_var)
food_name_entry.grid(column=0, row=0, sticky=(W, E))
food_name_entry.configure(width=40)
self.add_placeholder(food_name_entry, "Nom de l'aliment...")
food_quantity_var = StringVar()
food_quantity_spinbox = Spinbox(add_frame,
textvariable=food_quantity_var,
from_=0.0,
to_=1000.0)
food_quantity_spinbox.configure(width=10)
food_quantity_spinbox.grid(column=1, row=0, padx=10)
food_measuring_units_cb = ttk.Combobox(add_frame,
values=self.measuring_units,
state='readonly')
food_measuring_units_cb.configure(width=10)
food_measuring_units_cb.grid(column=2, row=0)
food_add_btn = ttk.Button(add_frame, text="Ajouter l'aliment")
foods_tree = ttk.Treeview(tab, columns=self.tree_columns)
for col in self.tree_columns:
foods_tree.heading(col,
text=col.title(),
command=lambda c=col: sortby(foods_tree, c, 0))
def add_food(event=None):
""" Fonction appelée lorsque l'utilisateur clique sur "Ajouter l'aliment" """
food_add_btn.config(state='disabled')
food_name = food_name_var.get().strip()
# Vérification du nom de l'aliment
if len(food_name) == 0 or food_name == "Nom de l'aliment...":
messagebox.showerror(
None, "Le nom de l'aliment ne peut pas être vide !")
food_add_btn.config(state='normal')
return
if len(food_name) > 50:
messagebox.showerror(
None,
"Le nom de l'aliment ne peut pas contenir plus de 50 caractères !"
)
food_add_btn.config(state='normal')
return
# Vérification des quantités
food_quantity = food_quantity_var.get().strip()
if not food_quantity.isnumeric() and food_quantity:
messagebox.showerror(None, "La quantité doit être un nombre !")
food_add_btn.config(state='normal')
food_quantity_var.set(0)
return
food_quantity = float(food_quantity) if food_quantity else float(0)
if food_quantity < 0:
messagebox.showerror(
None, "La quantité ne peut pas être un nombre négatif !")
food_add_btn.config(state='normal')
return
new_food = Food(food_name, food_quantity,
food_measuring_units_cb.get())
self.food_repository.save(new_food)
self.foods.append(new_food)
foods_tree.insert('',
0,
values=(new_food.id, new_food.quantity,
new_food.measuring_units, new_food.name))
food_name_var.set('')
food_name_entry.focus()
food_quantity_var.set(0)
food_measuring_units_cb.current(0)
food_add_btn.config(state='normal')
food_add_btn.config(command=add_food)
food_add_btn.grid(column=4, row=0, padx=(10, 0))
# Liste des courses
tree_scroll = ttk.Scrollbar(tab)
tree_scroll.grid(column=1, row=1, sticky=(S, N))
tree_scroll.configure(command=foods_tree.yview)
foods_tree.configure(yscrollcommand=tree_scroll.set, height=6)
foods_tree['show'] = 'headings'
foods_tree.heading('quantity', text='#')
foods_tree.column('quantity', width=10)
foods_tree.heading('unit', text='Unité')
foods_tree.column('unit', width=10)
foods_tree.heading('food', text='Aliment')
foods_tree.column('food', width=400)
foods_tree.configure(displaycolumns=('quantity', 'unit', 'food'))
foods_tree.grid(column=0, row=1, sticky=(W, E))
# Bouton de suppression d'un aliment et d'envoie
actions_frame = Frame(tab)
actions_frame.grid(column=0, row=3, sticky=(W, E))
actions_frame.configure(background='lightgrey', pady=10, padx=10)
send_btn = Button(actions_frame,
text='Envoyer la liste',
command=self.send_foods)
send_btn.grid(column=0, row=0)
send_btn.configure(background='darkgreen', foreground='white')
def delete_selected_food():
if len(foods_tree.selection()) == 0:
return
answer = messagebox.askquestion(
None,
'Êtes-vous sûr de vouloir supprimer cette aliment de la liste ?'
)
if answer == 'no':
return
for item in foods_tree.selection():
food_id = foods_tree.item(item, 'values')[0]
for food in self.foods:
if int(food.id) == int(food_id):
self.food_repository.delete(food)
self.foods.remove(food)
foods_tree.delete(item)
del food
break
delete_selected_food = Button(actions_frame,
text="Supprimer l'aliment",
command=delete_selected_food)
delete_selected_food.grid(column=1, row=0, padx=10)
delete_selected_food.configure(background='#FF9D00',
foreground='white')
def delete_all_foods():
if len(foods_tree.get_children()) == 0:
return
answer = messagebox.askyesnocancel(
None,
'Cliquez sur Yes pour supprimer tous les aliments de la liste.\n'
'Cliquez sur No pour supprimer chaque aliment un à un.\n'
'Cliquez sur Cancel pour ne supprimer aucun aliment.')
if answer is None:
return
for item in foods_tree.get_children():
food_id = foods_tree.item(item, 'values')[0]
for food in self.foods:
if int(food.id) == int(food_id):
if answer == False:
answer_del_food = messagebox.askyesnocancel(
None,
'Voulez-vous supprimer "%s" de la liste ?\n'
'Cliquez sur Cancel pour arrêter la suppression.'
% food.name)
# If user click on Cancel, stop the loop
if answer_del_food is None:
return
# If user click sur No, jut continue the loop for next food
if not answer_del_food:
continue
self.food_repository.delete(food)
self.foods.remove(food)
foods_tree.delete(item)
del food
break
delete_all_foods_btn = Button(actions_frame,
text='Supprimer tous les aliments',
command=delete_all_foods)
delete_all_foods_btn.grid(column=2, row=0)
delete_all_foods_btn.configure(background='darkred',
foreground='white')
for food in self.foods:
foods_tree.insert('',
'end',
values=(food.id, food.quantity,
food.measuring_units, food.name))
# Bindings event
food_name_entry.bind('<Return>', add_food)
food_quantity_spinbox.bind('<Return>', add_food)
food_measuring_units_cb.bind('<Return>', add_food)
def send_foods(self):
"""
Envoi la liste des courses à tous les utilisateurs
"""
for mail in self.mail_sender_accept:
self.gmail.send(mail, self.foods)
def display_config_tab(self, tab):
"""
Affiche l'onglet de "Configuration"
"""
config_label = ttk.Label(tab, text="Utilisateurs")
config_label.grid(column=0, row=0, padx=10, pady=10)
user_mail_var = StringVar()
user_email_entry = ttk.Entry(tab, textvariable=user_mail_var)
user_email_entry.grid(column=1, row=0, sticky=(W, E))
user_email_entry.config(width=40)
self.add_placeholder(user_email_entry, 'Adresse mail...')
add_user_mail_btn = ttk.Button(tab, text="Ajouter l'adresse mail")
add_user_mail_btn.grid(column=2, row=0, padx=(5, 0))
users_mails__sb = Scrollbar(tab)
users_mails__sb.grid(column=2, row=1, sticky=(W, N, S))
users_mails_lb = Listbox(tab, yscrollcommand=users_mails__sb.set)
users_mails_lb.grid(column=1, row=1, sticky=(W, E))
users_mails__sb.config(command=users_mails_lb.yview)
def add_mail(event=None):
mail = user_mail_var.get().strip()
if mail == 'Adresse mail...' or mail == '':
messagebox.showerror(None,
"L'adresse mail ne peut pas être vide !")
return
if not re.match(
r"(^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+$)",
mail):
messagebox.showerror(
None, "L'adresse mail n'a pas un format valide !")
return
self.user_repository.add_mail(mail)
self.mail_sender_accept.append(mail)
users_mails_lb.insert('end', mail)
user_mail_var.set('')
def del_mail():
for item in users_mails_lb.curselection():
mail = users_mails_lb.get(item)
question = messagebox.askquestion(
None,
"Êtes-vous sûr(e) de vouloir supprimer l'adresse mail %s de la liste ?"
% mail)
if question == 'yes':
self.mail_sender_accept.remove(mail)
users_mails_lb.delete(item)
self.user_repository.del_mail(mail)
add_user_mail_btn.config(command=add_mail)
user_email_entry.bind('<Return>', add_mail)
del_mail_btn = Button(tab,
text="Supprimer l'adresse mail",
command=del_mail)
del_mail_btn.grid(column=1, row=2, sticky=(W, E, N))
del_mail_btn.configure(bg='darkred', fg='white')
for mail in self.mail_sender_accept:
users_mails_lb.insert('end', mail)
def display_window(self):
root_frame = VerticalScrolledFrame(self.root)
root_frame.grid(column=0, row=0)
# Tabs
notebook = ttk.Notebook(root_frame.interior)
tab_course = ttk.Frame(notebook)
tab_config = ttk.Frame(notebook)
notebook.add(tab_course, text='Liste de courses')
notebook.add(tab_config, text='Configuration')
notebook.grid(column=0, row=0)
# Liste de courses
self.display_course_tab(tab_course)
self.display_config_tab(tab_config)
self.root.rowconfigure(0, weight=1)
self.root.columnconfigure(0, weight=1)
# Mainloop
self.root.mainloop()
def add_placeholder(self, entry, text):
entry.insert(0, text)
entry.bind('')
entry.bind('<FocusIn>',
lambda event: self.on_focusin_entry(event, text))
entry.bind('<FocusOut>',
lambda event: self.on_focusout_entry(event, text))
def on_focusin_entry(self, event, text):
entry = event.widget
if entry.get() == text:
entry.delete(0, "end") # delete all the text in the entry
entry.insert(0, '')
entry.config(foreground='black')
def on_focusout_entry(self, event, text):
entry = event.widget
if entry.get() == '':
entry.insert(0, text)
entry.config(foreground='grey')