from tkinter import *
from tkinter import ttk
import time
from tkinter import messagebox
win = Tk()
win.title('家康粮油蔬菜水果超市--用户管理系统')
win.geometry('800x600+400+200')
win.resizable(width=False,height=False)
#win.attributes('-topmost',-1)
#会员查询
group1 = LabelFrame(win,text='查询',font=(None ,10),padx=5,pady=5)
group1.grid(row=0,column = 0,padx=20,pady=3)
Label(group1,text = '请输入用户姓名/卡号/手机号:',font=(None ,10)).grid(row=0,column = 0,padx=10,pady=10)
Id = StringVar()
Id.set('')
user = Entry(group1,textvariable = Id,width = 35)
user.grid(row=0,column = 1,padx=10,pady=10)
def clean():
user.delete(0,END)
#会员信息
group2 = LabelFrame(win,text='会员信息',font=(None ,10),padx=5,pady=5)
group2.grid(row=1,column = 0,padx=10,pady=3)
Label(group2,text = '卡号:',font=(None ,10)).grid(row=1,column = 0,padx=5,pady=5)
varSid = StringVar()
varSid.set('')
sid = Entry(group2,width=10,state='disabled',textvariable = varSid)
sid.grid(row=1,column = 1,padx=5,pady=5)
Label(group2,text = '姓名:',font=(None ,10)).grid(row=1,column = 2,padx=5,pady=5)
varName = StringVar()
varName.set('')
name = Entry(group2,width=10,state='disabled',textvariable = varName)
name.grid(row=1,column = 3,padx=5,pady=5)
Label(group2,text = '电话:',font=(None ,10)).grid(row=1,column = 4,padx=5,pady=5)
varTel = StringVar()
varTel.set('')
tel = Entry(group2,width=20,state='disabled',textvariable = varTel)
tel.grid(row=1,column = 5,padx=5,pady=5)
Label(group2,text = '地址:',font=(None ,10)).grid(row=1,column = 6,padx=5,pady=5)
varAdd = StringVar()
varAdd.set('')
adress = Entry(group2,width=30,state='disabled',textvariable = varAdd)
adress.grid(row=1,column = 7,padx=5,pady=5)
#消费记录
group3 = LabelFrame(win,text='客户消费明细',font=(None ,10),padx=5,pady=5)
group3.grid(row=3,column = 0,columnspan=3,padx=10,pady=1)
tree = ttk.Treeview(group3,show='headings',columns=('col1','col2','col3','col4',\
'col5','col6','col7','col8',))
tree.column('col1',width=70,anchor='center')
tree.heading('col1',text='卡号')
tree.column('col2',width=80,anchor='center')
tree.heading('col2',text='姓名')
tree.column('col3',width=110,anchor='center')
tree.heading('col3',text='最近消费金额')
tree.column('col4',width=120,anchor='center')
tree.heading('col4',text='最近消费时间')
tree.column('col5',width=140,anchor='center')
tree.heading('col5',text='消费总额')
tree.column('col6',width=80,anchor='center')
tree.heading('col6',text='可兑换次数')
tree.column('col7',width=80,anchor='center')
tree.heading('col7',text='已兑换次数')
tree.column('col8',width=60,anchor='center')
tree.heading('col8',text='备注')
#加滚动条
vbar = Scrollbar(group3, orient=VERTICAL)
vbar.config(command = tree.yview)
tree.configure(yscrollcommand=vbar.set)
tree.grid(row=3)
vbar.grid(row=3, column=1,sticky=NS)
tree.grid()
#积分兑换
group4 = LabelFrame(win,text='积分兑换',font=(None ,10),padx=5,pady=5)
group4.grid(row=2,column =0,padx=20,pady=3)
Label(group4,text = '消费总额:',font=(None ,10)).grid(row=0,column = 0,padx=5,pady=5)
varTot = StringVar()
varTot.set('')
total = Entry(group4,width=10,state='disabled',textvariable = varTot)
total.grid(row=0,column = 1,padx=5,pady=5)
Label(group4,text = '可兑换次数:',font=(None ,10)).grid(row=0,column = 2,padx=5,pady=5)
varKe = StringVar()
varKe.set('')
total = Entry(group4,width=10,state='disabled',textvariable = varKe)
total.grid(row=0,column = 3,padx=5,pady=5)
Label(group4,text = '已兑换次数:',font=(None ,10)).grid(row=0,column = 4,padx=5,pady=5)
varYi = StringVar()
varYi.set('')
total = Entry(group4,width=10,state='disabled',textvariable = varYi)
total.grid(row=0,column = 5,padx=5,pady=5)
#查询
def chaXun():
userList = []
tag = False
file = open('Data.cyp','r')
for j in file:
userDict = {}
temp = []
temp.append(j.split('|'))
userDict['卡号'] = temp[0][0]
userDict['姓名'] = temp[0][1]
userDict['最近消费金额'] = temp[0][2]
userDict['最近消费时间'] = temp[0][3]
userDict['消费总额'] = temp[0][4]
userDict['可兑换次数'] = temp[0][5]
userDict['已兑换次数'] = temp[0][6]
userDict['备注'] = temp[0][7]
userDict['电话'] = temp[0][8]
userDict['地址'] = temp[0][9][:-1]
userList.append(userDict)
#print(userList)
#print(len(Id.get()))
if Id.get()!='':
#加卡号和电话号
for i in range(len(userList)):
if Id.get() == userList[i]['电话']:
varSid.set(userList[i]['卡号'])
varName.set(userList[i]['姓名'])
varTel.set(userList[i]['电话'])
varAdd.set(userList[i]['地址'])
varTot.set(userList[i]['消费总额'])
varKe.set(userList[i]['可兑换次数'])
varYi.set(userList[i]['已兑换次数'])
tag = True
break
for i in range(len(userList)):
#Id.get() == userList[i]['姓名']
if Id.get() == userList[i]['姓名']:
varSid.set(userList[i]['卡号'])
varName.set(userList[i]['姓名'])
varTel.set(userList[i]['电话'])
varAdd.set(userList[i]['地址'])
varTot.set(userList[i]['消费总额'])
varKe.set(userList[i]['可兑换次数'])
varYi.set(userList[i]['已兑换次数'])
tag = True
break
#加电话号
#print(userList)
for i in range(len(userList)):
if Id.get() == userList[i]['卡号']:
varSid.set(userList[i]['卡号'])
varName.set(userList[i]['姓名'])
varTel.set(userList[i]['电话'])
varAdd.set(userList[i]['地址'])
varTot.set(userList[i]['消费总额'])
varKe.set(userList[i]['可兑换次数'])
varYi.set(userList[i]['已兑换次数'])
tag = True
break
if tag == False:
messagebox.showinfo('提示','没有发现此用户!!')
else:
messagebox.showinfo('提示','请先输入卡号再继续操作！')
return userList
Button(group1,text='查询',width = 15,command = chaXun).grid(row=0,column = 2,padx=10,pady=10)
#相关操作
group5 = LabelFrame(win,text='操作管理',font=(None ,10),padx=5,pady=5)
group5.grid(row=4,column =0,padx=20,pady=5)
#添加用户
def add():
addWin = Tk()
addWin.geometry('300x350+500+250')
addWin.title('添加用户')
addWin.resizable(width=False,height=False)
#addWin.attributes('-topmost',-1)
Label(addWin,text = '卡号:',font=(None ,10)).grid(row=0,column = 0,padx=15,pady=15)
addId = Entry(addWin,width=30)
addId.grid(row=0,column = 1,padx=5,pady=5)
Label(addWin,text = '姓名:',font=(None ,10)).grid(row=1,column = 0,padx=15,pady=15)
addName = Entry(addWin,width=30)
addName.grid(row=1,column = 1,padx=5,pady=5)
Label(addWin,text = '手机:',font=(None ,10)).grid(row=2,column = 0,padx=15,pady=15)
addTel = Entry(addWin,width=30)
addTel.grid(row=2,column = 1,padx=5,pady=5)
Label(addWin,text = '地址:',font=(None ,10)).grid(row=3,column = 0,padx=15,pady=15)
addAdress = Entry(addWin,width=30)
addAdress.grid(row=3,column = 1,padx=5,pady=5)
Label(addWin,text = '备注:',font=(None ,10)).grid(row=4,column = 0,padx=15,pady=15)
addRemarks = Entry(addWin,width=30)
addRemarks.grid(row=4,column = 1,padx=5,pady=5)
def addUser():
resList = []
file = open('Data.cyp','r')
for j in file:
userDict = {}
temp = []
j = j.strip('\n')
temp.append(j.split('|'))
if temp[0][0]!='\n':
userDict['卡号'] = temp[0][0]
userDict['姓名'] = temp[0][1]
userDict['最近消费金额'] = temp[0][2]
userDict['最近消费时间'] = temp[0][3]
userDict['消费总额'] = temp[0][4]
userDict['可兑换次数'] = temp[0][5]
userDict['已兑换次数'] = temp[0][6]
userDict['备注'] = temp[0][7]
userDict['电话'] = temp[0][8]
userDict['地址'] = temp[0][9]
resList.append(userDict)
file.close()
atg = False
for i in range(len(resList)):
if addId.get() == resList[i]['卡号']:
atg = True
if atg == True:
messagebox.showinfo('警告','你输入的卡号已经存在!!!')
addWin.destroy()
else:
r = messagebox.askyesno('提示','确定添加该用户吗？')
if addId.get()==''or addName.get()==''or addTel.get()==''or addAdress.get()==''or addRemarks=='':
messagebox.showinfo('提示','您输入的信息不完整!')
addWin.destroy()
elif r == True:
file = open('Data.cyp','a+')
file.write(addId.get()+'|')
file.write(addName.get()+'|')
file.write('0'+'|')#最近消费金额
file.write(str(time.strftime('%d/%m/%Y'))+'|')#最近消费时间
file.write('0'+'|')#消费总额
file.write('0'+'|')#可兑换次数
file.write('0'+'|')#已兑换次数
file.write(addRemarks.get()+'|')
file.write(addTel.get()+'|')
file.write(addAdress.get())
file.write('\n')
file.close()
messagebox.showinfo('提示','添加成功!')
addWin.destroy()
else:
addWin.destroy()
Button(addWin,text='添加',width = 20,command = addUser).grid(row=5,column = 0,columnspan=2,padx=15,pady=15)
#浏览用户
def infoView():
items = tree.get_children()
for item in items:
tree.delete(item)
file = open('Data.cyp','r')
userList = []
for i in file:
t = i.split('|')
userList.append(t)
userList.sort(key=lambda x:x[4])
for i in range(len(userList)):
tree.insert('',0,values=(userList[i][0],userList[i][1],userList[i][2],userList[i][3],\
userList[i][4],userList[i][5],userList[i][6],userList[i][7]))
file.close()
#读取文件
def read():
resList = []
file = open('Data.cyp','r')
for j in file:
userDict = {}
temp = []
j = j.strip('\n')
temp.append(j.split('|'))
if temp[0][0]!='\n':
userDict['卡号'] = temp[0][0]
userDict['姓名'] = temp[0][1]
userDict['最近消费金额'] = temp[0][2]
userDict['最近消费时间'] = temp[0][3]
userDict['消费总额'] = temp[0][4]
userDict['可兑换次数'] = temp[0][5]
userDict['已兑换次数'] = temp[0][6]
userDict['备注'] = temp[0][7]
userDict['电话'] = temp[0][8]
userDict['地址'] = temp[0][9]
resList.append(userDict)
file.close()
return resList
def delUser():
iids = tree.selection()
name = tree.item(iids,'values')
resList = read()
#print(resList)
'''
#读取文件
resList = []
file = open('Data.cyp','r')
for j in file:
userDict = {}
temp = []
temp.append(j.split('|'))
userDict['序号'] = temp[0][0]
userDict['姓名'] = temp[0][1]
userDict['最近消费金额'] = temp[0][2]
userDict['最近消费时间'] = temp[0][3]
userDict['消费总额'] = temp[0][4]
userDict['可兑换次数'] = temp[0][5]
userDict['已兑换次数'] = temp[0][6]
userDict['备注'] = temp[0][7]
userDict['电话'] = temp[0][8]
userDict['地址'] = temp[0][9][:-1]
resList.append(userDict)
file.close()
'''
if iids == '':
messagebox.showinfo('提示','请先选中您所要删除的用户!')
else:
r = messagebox.askyesno('提示','确定删除该用户吗？')
if r == True:
for i in range(len(resList)):
if name[1] == resList[i]['姓名']:
del resList[i]
tree.delete(iids)
messagebox.showinfo('提示','删除成功')
break
#写入文件
file = open('Data.cyp','w')
for j in range(len(resList)):
file.write( resList[j]['卡号']+'|')
file.write( resList[j]['姓名']+'|')
file.write( resList[j]['最近消费金额']+'|')
file.write(resList[j]['最近消费时间']+'|')
file.write( resList[j]['消费总额']+'|')
file.write( resList[j]['可兑换次数']+'|')
#file.write( resList[j]['可兑换次数']+'|')
file.write( resList[j]['已兑换次数']+'|')
file.write( resList[j]['备注']+'|')
file.write( resList[j]['电话']+'|')
file.write( resList[j]['地址'])
file.write('\n')
file.close()
infoView()
def helpme():
messagebox.showinfo('提示','寒江独钓\nQQ:35959248!\n电话:13630622588')
def winExit():
win.destroy()
#消费记录
def buy():
if Id.get()=='':
messagebox.showinfo('提示','请先输入姓名再继续操作!')
else:
chaXun()
r = messagebox.askyesno('提示','确定是该用户吗？')
if r == True:
buyWin = Tk()
buyWin.geometry('250x200+500+350')
buyWin.title('添加购物记录')
varTime = str(time.strftime('%d/%m/%Y'))
Label(buyWin,text = '购物时间:',font=(None ,10)).grid(row=0,column = 0,padx=10,pady=30)
Label(buyWin,text=varTime,font=(None ,10)).grid(row=0,column = 1,padx=10,pady=10)
Label(buyWin,text = '消费金额:',font=(None ,10)).grid(row=1,column = 0,padx=10,pady=10)
varTot = StringVar()
buyNum = Entry(buyWin,width=15,textvariable = varTot)
buyNum.grid(row=1,column = 1,padx=10,pady=10)
#更新购物金额
def update():
resList = chaXun()
#print(resList)
for i in range(len(resList)):
if varSid.get() == resList[i]['卡号']:
resList[i]['最近消费金额']=buyNum.get()
resList[i]['消费总额']=str(int(resList[i]['消费总额'])+int(resList[i]['最近消费金额']))
messagebox.showinfo('提示','更新成功')
#写入文件
file = open('Data.cyp','w')
for j in range(len(resList)):
#print(resDict)
file.write( resList[j]['卡号']+'|')
file.write( resList[j]['姓名']+'|')
file.write( resList[j]['最近消费金额']+'|')
file.write(str(time.strftime('%d/%m/%Y'))+'|')
file.write( resList[j]['消费总额']+'|')
if ((int(resList[i]['消费总额'])-int(resList[i]['已兑换次数'])*500)/500) >=1:
resList[i]['可兑换次数'] = str(int((int(resList[i]['消费总额'])-int(resList[i]['已兑换次数'])*500)/500))
else:
resList[i]['可兑换次数'] = '0'
#file.write( str(int(resList[j]['消费总额'])//500)+'|')
file.write( resList[j]['可兑换次数']+'|')
file.write( resList[j]['已兑换次数']+'|')
file.write( resList[j]['备注']+'|')
file.write( resList[j]['电话']+'|')
file.write( resList[j]['地址'])
file.write('\n')
#print( resList[i])
file.close()
buyWin.destroy()
infoView()
Button(buyWin,text='确定',width = 11,command = update).grid(row=2,column = 0,padx=10,pady=10)
Button(buyWin,text='取消',width = 11,command = lambda:buyWin.destroy()).grid(row=2,column = 1,padx=10,pady=10)
def zzz():
messagebox.showinfo('提示','功能开发中')
Button(group1,text='消费记录',width = 15,command = buy).grid(row=0,column = 3,padx=10,pady=10)
#Button(group1,text='自定义',width = 7,command = zzz).grid(row=0,column = 4,padx=10,pady=10)
def clean():
infoView()
Id.set('')
varSid.set('')
varName.set('')
varTel.set('')
varAdd.set('')
varTot.set('')
varKe.set('')
varYi.set('')
def menoyTotal():
menoySum = 0
resList = read()
for i in range(len(resList)):
menoySum = menoySum + int(resList[i]['消费总额'])
messagebox.showinfo('恭喜','一共赚了'+str(menoySum)+'元')
Button(group5,text='刷新数据',width = 11,command = clean).grid(row=4,column = 0,padx=10,pady=10)
Button(group5,text='添加用户',width = 11,command = add).grid(row=4,column = 1,padx=10,pady=10)
Button(group5,text='浏览用户',width = 11,command = infoView).grid(row=4,column = 2,padx=10,pady=10)
Button(group5,text='删除用户',width = 11,command = delUser).grid(row=4,column = 3,padx=10,pady=10)
Button(group5,text='销售总额',width = 11,command = menoyTotal).grid(row=4,column = 4,padx=10,pady=10)
Button(group5,text='帮助',width = 11,command = helpme).grid(row=4,column = 5,padx=10,pady=10)
Button(group5,text='退出',width = 11,command = winExit).grid(row=4,column = 6,padx=10,pady=10)
def duihuan():
resList = read()
if Id.get()=='':
messagebox.showinfo('提示','请先输入姓名再继续操作!')
else:
r = messagebox.askyesno('提示','确定要兑换吗？')
if r == True:
for i in range(len(resList)):
if varSid.get() == resList[i]['卡号']:# and resList[i]['可兑换次数'] > 0:
if int(resList[i]['可兑换次数']) > 0:
resList[i]['已兑换次数'] = str(int(resList[i]['已兑换次数']) + 1)
if ((int(resList[i]['消费总额'])-int(resList[i]['已兑换次数'])*500)/500) >=1:
resList[i]['可兑换次数'] = str(int((int(resList[i]['消费总额'])-int(resList[i]['已兑换次数'])*500)/500))
else:
resList[i]['可兑换次数'] = '0'
break
else:
messagebox.showinfo('提示','你的兑换次数已用完！')
break
#写入文件
file = open('Data.cyp','w')
for j in range(len(resList)):
file.write( resList[j]['卡号']+'|')
file.write( resList[j]['姓名']+'|')
file.write( resList[j]['最近消费金额']+'|')
file.write(resList[j]['最近消费时间']+'|')
file.write( resList[j]['消费总额']+'|')
#file.write( str(int(resList[j]['可兑换次数'])//500)+'|')
file.write( resList[j]['可兑换次数']+'|')
file.write( resList[j]['已兑换次数']+'|')
file.write( resList[j]['备注']+'|')
file.write( resList[j]['电话']+'|')
file.write( resList[j]['地址'])
file.write('\n')
file.close()
infoView()
Button(group4,text='申请兑换',width = 13,command = duihuan).grid(row=0,column = 6,padx=10,pady=10)
Button(group4,text='自定义',width = 12,command = duihuan).grid(row=0,column = 7,padx=10,pady=10)
mainloop()
