def is_exist_view(self):
print("로그인 정보 검증")
self.mc = controller.Member_Controller()
# self.e = self.e_email.get()
# self.p = self.e_passwd.get()
self.mc.sign_in_info(self.e_email.get(), self.e_passwd.get())
self.toplevel.destroy()
def delete_yn(self):
cm = controller.Member_Controller()
result = cm.delete_info_controller()
if result == 1:
self.drop_club_message()
else:
self.drop_club_fale_message()
def club__join_form(self, window):
cm = controller.Member_Controller()
cmc = controller.Member_Controller.cookie_email
if bool(cmc):
toplevel = tkinter.Toplevel(window)
result = cm.club_join_form_controller()
print("클럽가입폼 result", result)
self.club_input = tkinter.Entry(toplevel)
self.club_sign_btn = tkinter.Button(toplevel,
text="가입",
command=self.club_join,
width=10)
self.club_input.grid(row=0, column=0)
self.club_sign_btn.grid(row=0, column=1, sticky="w")
self.treeview_join = tkinter.ttk.Treeview(
toplevel, columns=["클럽", "소개"], displaycolumns=["클럽", "소개"])
self.treeview_join.column('#0', stretch="NO", width=0)
self.treeview_join.heading("#0", text="index", anchor="center")
self.treeview_join.column('#1', width=100)
self.treeview_join.heading("#1", text="클럽", anchor="center")
self.treeview_join.column('#2', width=100)
self.treeview_join.heading("#2", text="소개", anchor="center")
self.treeview_join.grid(row=1, column=0)
for index in range(len(result)):
self.treeview_join.insert(
'',
index,
values=[result[index]["clubid"], result[index]["intro"]])
else:
self.login_plz()
def club_update(self, clubid, club_up, admin, intro):
cm = controller.Member_Controller()
if bool(clubid) and bool(club_up):
cm.club_update_controller(clubid, club_up, admin, intro)
else:
tkinter.messagebox.showwarning("클럽 수정", "값을 입력해 주세요")
def club_secession_form(self, window):
cm = controller.Member_Controller()
cmc = cm.cookie_email
if bool(cmc):
self.toplevel = tkinter.Toplevel(window)
result = cm.join_club_list()
print("클럽 탈퇴 폼 RESULT", result)
self.l_clubid = tkinter.Label(self.toplevel, text="클럽명: ")
self.e_clubid = tkinter.Entry(self.toplevel)
self.e_club_list = tkinter.Listbox(self.toplevel)
self.delete_button = tkinter.Button(
self.toplevel,
text="탈퇴",
command=lambda: self.club_secession(self.e_clubid.get(), cmc[
"email"]))
self.cancle_button = tkinter.Button(self.toplevel,
text="취소",
command=self.cancle_func)
self.l_clubid.pack()
self.e_clubid.pack()
self.e_club_list.pack()
self.delete_button.pack()
self.cancle_button.pack()
for index in range(len(result)):
self.e_club_list.insert(index, result[index]["clubid"])
pass
else:
self.login_plz()
def insert_ok(self):
num = 0
# 이메일 정규 표현식
self.email_re = re.compile('^[a-zA-Z0-9+-_.]')
self.email_match = self.email_re.match(self.e_email.get())
self.email1_re = re.compile('[a-zA-Z0-9-]+\\.[a-zA-Z0-9-.]+$')
self.email1_match = self.email1_re.match(self.e_email1.get())
# 전화번호 정규 표현식
self.phone_re = re.compile('010') #'\\d{3}'
self.phone_match = self.phone_re.match(self.e_phone_number.get())
self.phone1_re = re.compile('\\d{4}')
self.phone1_match = self.phone1_re.match(self.e_phone_number1.get())
self.phone2_re = re.compile('\\d{4}')
self.phone2_match = self.phone2_re.match(self.e_phone_number2.get())
# 생일 정규 표현식
self.birth_day_re = re.compile('\\d{6}')
self.birth_day_match = self.birth_day_re.match(self.e_birth_day.get())
self.birty_day1_re = re.compile('\\d{7}')
self.birth_day1_match = self.birty_day1_re.match(
self.e_birth_day1.get())
if bool(self.email_match) and bool(self.email1_match):
num += 1
email_result = self.e_email.get() + '@' + self.e_email1.get()
print(email_result)
if bool(self.phone_match) and bool(self.phone1_match) and bool(
self.phone2_match):
num += 10
phone_result = self.e_phone_number.get(
) + '-' + self.e_phone_number1.get(
) + '-' + self.e_phone_number2.get()
print(phone_result)
if bool(self.birth_day_match) and bool(self.birth_day1_match):
num += 20
birth_day_result = self.e_birth_day.get(
) + '-' + self.e_birth_day1.get()
print(birth_day_result)
print("확인버튼")
if num == 31:
self.mc = controller.Member_Controller()
num = 0
# self.mc.sign_up_info(self.e_email.get(),self.e_passwd.get(),self.e_name.get(),self.e_nick_name.get(),self.e_phone_number.get(),self.e_birth_day.get(),self.e_address.get())
self.mc.sign_up_info(email_result, self.e_passwd.get(),
self.e_name.get(), self.e_nick_name.get(),
phone_result, birth_day_result,
self.e_address.get())
elif num == 1:
tkinter.messagebox.showwarning("정규표현식",
"전화번호,생년월일과 나머지 정보를 다시 입력하세요.")
elif num == 11:
tkinter.messagebox.showwarning("정규표현식", "생년월일과 나머지 정보를 입력하세요.")
elif num == 21:
tkinter.messagebox.showwarning("정규표현식", "전화번호와 나머지 정보를 입력하세요.")
elif num == 30:
tkinter.messagebox.showwarning("정규표현식", "이메일과 나머지 정보를 다시 입력하세요.")
else:
tkinter.messagebox.showwarning("정규표현식", "정보를 모두 입력하세요.")
def club_search(self, input_clubid):
cm = controller.Member_Controller()
if bool(input_clubid):
result = cm.club_search_list(input_clubid)
print("리스트 result", result)
if bool(result):
for i in self.treeview_list.get_children():
self.treeview_list.delete(i)
for index in range(len(result)):
print("클럽 조회 View")
self.treeview_list.insert('',
index,
values=[
result[index]["clubid"],
result[index]["intro"]
])
else:
tkinter.messagebox.showwarning("TravelClub",
"입력하신 클럽이 존재하지 않습니다.")
else:
result2 = cm.club_search_list_controller()
print("리스트 result2", result2)
for i in self.treeview_list.get_children():
self.treeview_list.delete(i)
for index in range(len(result2)):
self.treeview_list.insert(
'',
index,
values=[result2[index]["clubid"], result2[index]["intro"]])
def log_out(self):
cm = controller.Member_Controller()
cmc = controller.Member_Controller.cookie_email
if bool(cmc):
cm.delete_cookie()
tkinter.messagebox.showinfo("TravelClub", "로그아웃 완료")
else:
tkinter.messagebox.showwarning("TravelClub", "로그인이 되어있지 않습니다.")
def delete_member(self,window):
print("회원 탈퇴 폼 접근")
cm = controller.Member_Controller()
cmc = cm.cookie_email
print("회원탈퇴폼 cmc",cmc)
# toplevel = tkinter.Toplevel(window)
if bool(cmc):
toplevel = tkinter.Toplevel(window)
self.delete_label = tkinter.Label(toplevel, text= "확인 버튼을 누르시면 계정이 생성한 클럽도 같이 삭제 됩니다. 정말 탈퇴하시겠습니까?")
self.delete_button = tkinter.Button(toplevel, text="확인", command=self.delete_yn)
self.delete_cancle_button = tkinter.Button(toplevel, text="취소", command=lambda : self.delete_cancle(toplevel))
self.delete_label.pack()
self.delete_button.pack()
self.delete_cancle_button.pack()
else:
self.login_plz()
def my_club_user_list(self, clubid, email, window):
cm = controller.Member_Controller()
if bool(clubid):
user_list = cm.club_user_select(clubid, email)
# result = cm.club_search_list(clubid)
print("리스트 result", user_list)
print(self.treeview.get_children())
if bool(user_list):
# print("클럽조회 view {0}".format(range(len(user_list)))
for i in self.treeview.get_children():
self.treeview.delete(i)
for index in range(len(user_list)):
# self.club_listbox.delete(index,self.club_listbox.size())
# self.treeview.delete(str(index))
self.treeview.insert('',
index,
values=[
user_list[index]["name"],
user_list[index]["phonenumber"],
user_list[index]["email"]
])
else:
tkinter.messagebox.showwarning("TravelClub", "검색란에 클럽을 입력하세요.")
def club_delete_info(self, window):
cm = controller.Member_Controller()
cmc = cm.cookie_email
if bool(cmc):
self.toplevel = tkinter.Toplevel(window)
result = cm.club_select_all_controller(cmc["email"])
print("클럽 삭제 폼 RESULT", result)
self.l_clubid = tkinter.Label(self.toplevel, text="클럽명")
self.e_clubid = tkinter.Entry(self.toplevel)
# self.e_club_list = tkinter.Listbox(self.toplevel)
self.delete_button = tkinter.Button(self.toplevel,
text="삭제",
command=self.club_delete)
self.cancle_button = tkinter.Button(self.toplevel,
text="취소",
command=self.cancle_func)
self.l_clubid.grid(row=0, column=0)
self.e_clubid.grid(row=0, column=1)
# self.e_club_list.grid(row=1,column=0)
self.delete_button.grid(row=0, column=2)
self.cancle_button.grid(row=0, column=3, sticky="w")
self.treeview_del = tkinter.ttk.Treeview(self.toplevel,
columns=["클럽"],
displaycolumns=["클럽"])
self.treeview_del.column('#0', width=0, stretch="NO")
self.treeview_del.heading("#0", text="index", anchor="center")
self.treeview_del.column('#1', width=100)
self.treeview_del.heading("#1", text="클럽", anchor="center")
self.treeview_del.grid(row=2, column=1)
for index in range(len(result)):
# self.e_club_list.insert(index,result[index])
self.treeview_del.insert('', index, values=[result[index]])
else:
self.login_plz()
def club_secession(self, clubid, email):
if bool(clubid):
cm = controller.Member_Controller()
cm.club_secession(clubid, email)
else:
self.valeu_message()
def update_info(self, window):
cm = controller.Member_Controller()
cmc = controller.Member_Controller.cookie_email
if bool(cmc):
result = cm.detail_member_info()
print("result", result)
self.toplevel = tkinter.Toplevel(window)
self.toplevel.geometry("300x250")
self.l_email = tkinter.Label(self.toplevel, text="이메일: ")
self.e_email = tkinter.Entry(self.toplevel)
self.l_passwd = tkinter.Label(self.toplevel, text="패스워드: ")
self.e_passwd = tkinter.Entry(self.toplevel)
self.l_name = tkinter.Label(self.toplevel, text="이름: ")
self.e_name = tkinter.Entry(self.toplevel)
self.l_nick_name = tkinter.Label(self.toplevel, text="닉네임: ")
self.e_nick_name = tkinter.Entry(self.toplevel)
self.l_phone_number = tkinter.Label(self.toplevel, text="전화번호: ")
self.e_phone_number = tkinter.Entry(self.toplevel)
self.l_birth_day = tkinter.Label(self.toplevel, text="생년월일: ")
self.e_birth_day = tkinter.Entry(self.toplevel)
self.l_address = tkinter.Label(self.toplevel, text="거주지: ")
self.e_address = tkinter.Entry(self.toplevel)
self.l_clubid = tkinter.Label(self.toplevel, text="가입한 클럽: ")
self.e_clubid = tkinter.Entry(self.toplevel)
self.ok_button = tkinter.Button(self.toplevel,
text="수정",
command=self.my_update_button,
width=10)
self.cancle_button = tkinter.Button(self.toplevel,
text="취소",
command=self.cancle_func,
width=10)
self.l_email.grid(row=0, column=0)
self.e_email.grid(row=0, column=1)
self.l_passwd.grid(row=1, column=0)
self.e_passwd.grid(row=1, column=1)
self.l_name.grid(row=2, column=0)
self.e_name.grid(row=2, column=1)
self.l_nick_name.grid(row=3, column=0)
self.e_nick_name.grid(row=3, column=1)
self.l_phone_number.grid(row=4, column=0)
self.e_phone_number.grid(row=4, column=1)
self.l_birth_day.grid(row=5, column=0)
self.e_birth_day.grid(row=5, column=1)
self.l_address.grid(row=6, column=0)
self.e_address.grid(row=6, column=1)
self.l_clubid.grid(row=7, column=0)
self.e_clubid.grid(row=7, column=1)
self.ok_button.grid(row=8, column=0, sticky="w")
self.cancle_button.grid(row=8, column=1, sticky="w")
self.e_email.insert(0, result.u_email)
self.e_email.configure(state="readonly")
self.e_passwd.insert(0, result.u_passwd)
self.e_name.insert(0, result.u_name)
self.e_name.configure(state="readonly")
self.e_nick_name.insert(0, result.u_nick_name)
self.e_phone_number.insert(0, result.u_phone_number)
self.e_birth_day.insert(0, result.u_birthday)
self.e_birth_day.configure(state="readonly")
self.e_address.insert(0, result.u_address)
self.e_clubid.configure(state="readonly")
# if not bool(result.u_clubid):
# self.e_clubid.configure(state="readonly")
# else:
# self.e_clubid.insert(0,result.u_clubid)
# self.e_clubid.configure(state="readonly")
else:
self.login_plz()
def club_delete(self):
cm = controller.Member_Controller()
cm.club_delete_controller(self.e_clubid.get())
def my_update_button(self):
cm = controller.Member_Controller()
cm.update_info_con(self.e_email.get(), self.e_passwd.get(),
self.e_nick_name.get(), self.e_phone_number.get(),
self.e_address.get())
def club_join(self):
cm = controller.Member_Controller()
cm.club_join_controller(self.club_input.get())
def club_update_info(self, window):
cm = controller.Member_Controller()
cmc = cm.cookie_email
if bool(cmc):
print("cmc", cmc)
result = cm.club_detail_controller()
print("클럽수정 result", result[0]["clubid"])
self.toplevel = tkinter.Toplevel(window)
self.toplevel.geometry("500x400")
self.l_clubid = tkinter.Label(self.toplevel, text="클럽명: ")
self.l_clubid.grid(row=0, column=0)
self.e_clubid = tkinter.Entry(self.toplevel)
self.e_clubid.grid(row=0, column=1)
self.l_clubid_up = tkinter.Label(self.toplevel, text="변경할 클럽명: ")
self.l_clubid_up.grid(row=1, column=0)
self.e_clubid_up = tkinter.Entry(self.toplevel)
self.e_clubid_up.grid(row=1, column=1)
self.l_club_admin = tkinter.Label(self.toplevel, text="관리자: ")
self.l_club_admin.grid(row=2, column=0)
self.e_club_admin = tkinter.Entry(self.toplevel)
self.e_club_admin.grid(row=2, column=1)
self.l_club_intro = tkinter.Label(self.toplevel, text="소개: ")
self.l_club_intro.grid(row=3, column=0)
self.e_club_intro = tkinter.Entry(self.toplevel)
self.e_club_intro.grid(row=3, column=1)
self.ok_button = tkinter.Button(
self.toplevel,
text="수정",
width=10,
command=lambda: self.club_update(self.e_clubid.get(
), self.e_clubid_up.get(), self.e_club_admin.get(),
self.e_club_intro.get()))
self.ok_button.grid(row=4, column=0)
self.cancle_button = tkinter.Button(self.toplevel,
text="취소",
width=10,
command=self.cancle_func)
self.cancle_button.grid(row=4, column=1, sticky="w")
self.e_club_admin.insert(0, result[0]["c_email"])
self.e_club_admin.configure(state="readonly")
self.treeview_up = tkinter.ttk.Treeview(
self.toplevel,
columns=["클럽", "관리자", "소개"],
displaycolumns=["클럽", "관리자", "소개"])
self.treeview_up.column('#0', width=0, stretch="NO")
self.treeview_up.heading("#0", text="index", anchor="center")
self.treeview_up.column('#1', width=100)
self.treeview_up.heading("#1", text="클럽", anchor="center")
self.treeview_up.column('#2', width=100)
self.treeview_up.heading("#2", text="관리자", anchor="center")
self.treeview_up.column('#3', width=100)
self.treeview_up.heading("#3", text="소개", anchor="center")
self.treeview_up.grid(row=5, column=1, pady=10)
for index in range(len(result)):
self.treeview_up.insert('',
index,
values=[
result[index]["clubid"],
result[index]["c_email"],
result[index]["intro"]
])
else:
self.login_plz()
def club_create(self):
cm = controller.Member_Controller()
cm.create_club(self.e_clubid.get(), self.e_club_intro.get())
