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())