def commit_ok(self):
if self.lock.get() < 0 or self.stock.get() < 0 or self.barrel.get() < 0:
messagebox.showerror("commit error","please check you input to confim there is not empty")
return
try:
errorstr = ""
search_sql = "select user_id from person where user_name = '%s' and priot = %d;"%(self.user_name,self.priot)
self.conn = mydb.Commission().getConn()
self.cursor = self.conn.cursor()
self.cursor.execute(search_sql)
self.user_id = self.cursor.fetchone()
now = datetime.datetime.now()
time_str = "%s/%s/%s"%(now.year,now.month,now.day)
self.info = [self.user_id[0],self.user_name,time_str,"hdkdajlk",self.lock.get(),self.stock.get(),self.barrel.get()]
insert_sql = "insert into sales values(%d,'%s','%s','%s',%d,%d,%d);"%(self.info[0],self.info[1],self.info[2],self.info[3],self.info[4],self.info[5],self.info[6])
#print(insert_sql)
self.cursor.execute(insert_sql)
self.conn.commit()
mydb.Commission().getCommission()
messagebox.showinfo("success","ok")
except pymysql.Error as e:
self.conn.rollback()
print(e)
finally:
self.conn.close()
self.destroy()
def look_sales_year(self):
comm = mydb.Commission()
res = list(comm.get_manager_search_month(2))
show_sale = showmanagersales.show_salary()
if res is None:
messagebox.showerror("Error","data is none")
return
id_name = comm.get_id_to_name()
num = [0,"","",0,0,0,0]
num[1] = res[0][1][:4]
id1 = res[0][0]
for r in res:
if id1 == r[0] and num[1] == r[1][:4]:
#index = r[0]
num[2] = id_name[r[0]-1][1]
num[1] = r[1][:4]
num[3] += r[2]
num[4] += r[3]
num[5] += r[4]
num[6] += r[5]
else:
num[0] += 1
show_sale.showSalaryData(num)
num[1] = r[1][:4]
num[2] = id_name[r[0]-1][1]
num[3] = r[2]
num[4] = r[3]
num[5] = r[4]
num[6] = r[5]
num[0] += 1
show_sale.showSalaryData(num)
def login(self):
time_start = time.time()
lp = LineProfiler()
self.comm = mydb.Commission()
self.userinfo = [self.name.get(), self.v.get(), self.password.get()]
lp_wrapper = lp(self.comm.login)
lp_wrapper(self.userinfo)
lp.print_stats()
time_finish = time.time()
print("login function over ,elapse", time_finish - time_start)
#self.comm.login(self.userinfo)
self.destroy()
def ok(self):
name = self.name.get()
comm = mydb.Commission()
user_id = list(comm.get_id_from_name(name))[0]
res = comm.get_records_form_id(user_id)
num = [0, "", name, 0, 0, 0, 0., 0.]
sh = showsearch.show_salary()
for r in res:
num[0] += 1
num[1] = r[0]
num[3:] = r[1:]
sh.showSearchData(num)
def look_sales_month(self):
comm = mydb.Commission()
res = list(comm.get_user_search_month([self.user_name, self.priot]))
show_sale = showsales.show_sale()
if res is None:
messagebox.showerror("Error", "data is none")
return
num = [0, "", 0, 0, 0]
for r in res:
num[0] += 1
num[1:] = r
show_sale.showData(num)
def look_salary_month(self):
comm = mydb.Commission()
res = list(comm.get_user_search_month([self.user_name, self.priot]))
show_salary = showsalary.show_salary()
if res is None:
messagebox.showerror("Error", "data is none")
return
num = [0, "", 0, 0, 0, 0.]
for r in res:
num[0] += 1
num[1] = r[0]
num[2:] = r[1:]
show_salary.showSalaryData(num)
def look_sales_month(self):
comm = mydb.Commission()
res = list(comm.get_manager_search_month(1))
show_sale = showmanagersales.show_salary()
if res is None:
messagebox.showerror("Error","data is none")
return
id_name = comm.get_id_to_name()
num = [0,"","",0,0,0,0]
for r in res:
name = id_name[r[0]-1][1]
num[2] = name
num[1] = r[1]
num[0] += 1
num[3:] = r[2:6]
show_sale.showSalaryData(num)
def look_sales_year(self):
comm = mydb.Commission()
res = list(comm.get_user_search_month([self.user_name, self.priot]))
show_sale = showsales.show_sale()
if res is None:
messagebox.showerror("Error", "data is none")
return
num = [1, "", 0, 0, 0]
num[1] = res[0][0][:4]
for r in res:
if num[1] == r[0][:4]:
num[2] += r[1]
num[3] += r[2]
num[4] += r[3]
else:
show_sale.showData(num)
num[0] += 1
num[1] = r[0][:4]
num[2:] = r[1:]
show_sale.showData(num)
def ok(self):
if self.name.get()=="" or self.password.get()=="" or self.comfirm_pass.get()=="" or self.age.get()=="" or self.tele.get()=="" or self.addr.get()=="":
messagebox.showerror("regist error","please check you input to confirm there is not empty")
return
if self.password.get() != self.comfirm_pass.get():
messagebox.showerror("regist error","password is not right")
return
try:
errstr = ""
if len(str(int(self.tele.get()))) != 11:
errstr += "please confirm the number of telephon is 11;"
if len(self.name.get()) > 8:
errstr += "the length of name is outof 8;"
if len(self.addr.get()) > 20:
errstr += "the length of addr is outof 20;"
if int(self.age.get()) < 0 and int(self.age.get()) > 70:
errstr += "the num of age is less than 0 or more than 70;"
self.userinfo = [str(self.name.get()),int(self.tele.get()),str(self.addr.get()),int(self.age.get()),int(self.v.get()),str(self.password.get())]
self.comm = mydb.Commission()
self.comm.addUser(self.userinfo)
except:
messagebox.showinfo("Error","please check you input;"+errstr)
return
self.destroy()