项目作者: wbylily
项目描述 :
# -*- code:utf-8 -*- # # from lib.iot.readcard import standard as readcard from lib.iot.displayA import tft from lib.data.edict import edict from lib.iot.PLI import qr from datetime import datetime from time import sleep from lib.database.dbserver import dbServer def receivedata(data): sql="select * from attendance.user_card where card_no like '%"+data+"%'" rs=attendance.dbconn.Execute(sql) if(len(rs)<=0): o.clear() o.draw_rotated_text("庚商随身考勤智能终端", (214, 30), angle) o.draw_rotated_text("没有找到注册卡,", (144, 24), angle) o.draw_rotated_text("请使用小程序注册", (120, 24), angle) o.displaytxt() showqr(data) sql="insert into attendance.common_hdwlog(cardnumber,datetime,status)" sql+=" values('"+data+"',now(),'1')" else: o.clear() o.draw_rotated_text("庚商随身考勤智能终端", (214, 30), angle) o.draw_rotated_text("考勤成功,谢谢", (128, 24), angle) o.displaytxt() sql="insert into attendance.common_hdwlog(cardnumber,datetime,status,username)" sql+=" values('"+data+"',now(),'1','"+rs[0]['username']+"')" attendance.dbconn.CommitData(sql) print datetime.now(),"receivedata:",data def showqr(data): strurl="/user/:user/registrcard/"+data #imagefile="d:\\work\\project\\wxattendance\\pycode\\images\\registrcard.png" imagefile="/code/pycode/images/registrcard.png" qr.make_qr(strurl,imagefile) o.displayimg(o.draw_rotated_image(imagefile,angle,(120, 120))) if __name__=='__main__': fillcolor=(10,250,200) angle=270 o=tft() o.open() #o.setfont('simhei.ttf', 24) #o.begin() o.clear() o.draw_rotated_text("庚商实验室管理系统", (144, 32), angle) o.draw_rotated_text("随身考勤智能终端测试", (120, 30), angle) o.displaytxt() dev=readcard.drive("tx800t") cfg=edict() cfg.serialname="/dev/ttyUSB0" dev.CreditCardMode("TouchOff")#读到卡显示,但不会连续读相同的卡号,且读不到不会有反应 #dev.CreditCardMode("InsertCard")#能够反映出啥时候读到卡,啥时候卡不在的,只在状态变化时打印 dev.receive =receivedata sleep(2) o.clear() o.draw_rotated_text("庚商随身考勤智能终端", (144, 30), angle) o.draw_rotated_text("请刷卡!等待中。。。", (120, 24), angle) o.displaytxt() # o.display() myserver=dbServer('mysql','localhost',"root","gengshang") attendance=myserver.database.attendance dev.open(cfg)
高级语言:
项目地址: git://github.com/wbylily/-.git