def line_to_log(device, line, event=True):
'''
解析 Stamp 的行数据
'''
flds = line.split("\t") + ["", "", "", "", "", "", "",""]
#检查员工号码的合法性
pin = flds[0] #---第一个元素为人员编号
try:
if pin in settings.DISABLED_PINS: return None
except:
return None
if flds[5] == '255' and flds[3] == '3' and flds[0] == flds[4]:
print u"Swiped a invalid card: \n", line
return None
from db_utils import get_employee
emp = get_employee(pin, device)
if not emp:
return None
if emp.IsNewEmp:
emp.DeptID_id=1
emp.attarea=(device.area,) #---更新考勤区域
emp.save()
pin = emp.id
try:
logtime = datetime.datetime.strptime(flds[1], "%Y-%m-%d %H:%M:%S") #---第二个元素为打卡时间
except:
return None
now=datetime.datetime.now()
#---检查考勤记录时间的合法性
if event:
if (now + datetime.timedelta(1, 0, 0)) < logtime:
print u"时间比当前时间还要多一天"
return None
if logtime<now-datetime.timedelta(days=settings.VALID_DAYS):
print u"时间比当前要早...天", settings.VALID_DAYS
return None
if settings.CHECK_DUPLICATE_LOG or (not event): #检查重复记录
try:
if Transaction.objects.filter(TTime=logtime, UserID=emp):
print u"该记录已经存在"
return None
except: pass
#根据考勤机的时区矫正考勤记录的时区，使之同服务器的时区保持一致
if device.tz_adj <> None:
count_minutes = None
if abs(device.tz_adj)<=13:
count_minutes = device.tz_adj*3600
else:
count_minutes = device.tz_adj*60
logtime = logtime - datetime.timedelta(0, count_minutes) + server_time_delta #UTC TIM
sql = (pin, logtime, normal_state(flds[2]), normal_verify(flds[3]), None, flds[4], flds[5],device.sn)
return sql
def line_to_emp(cursor, device, line, Op, event=True):
'''
解析设备命令
line：设备post过来的命令字符串
device：传送命令的设备
'''
from mysite import settings
import os
try: #---行数据以空格分割标志名和键值对数据
if line.find("\tName=") > 0:
ops = unicode(line.decode("gb18030")).split(" ", 1)
else:
ops = line.split(" ", 1)
except:
ops = line.split(" ", 1)
if ops[0] == 'OPLOG': #-------------管理员操作记录 ops[0] 为标志名
from conv_device import line_to_oplog
return line_to_oplog(cursor, device, ops[1], event)
flds = {}
#-----------行数据中包含的所以键值对
for item in ops[1].split("\t"):
index = item.find("=")
if index > 0: flds[item[:index]] = item[index + 1:]
try:
pin = flds["PIN"] #---得到用户编号
if pin in settings.DISABLED_PINS or len(
pin) > settings.PIN_WIDTH: #----用户编号有效性验证
return
except:
return
e = get_employee(pin, device) #--- 得到命令对应的人员对象 必须有
if not e:
return
if str(ops[0]).strip() == "USER": #----------用户基本信息
if not settings.DEVICE_CREATEUSER_FLAG:
return
try:
ename = unicode(flds["Name"])[:40]
except:
ename = ' '
passwd = flds.get("Passwd", "")
card = flds.get("Card", "")
tmp_card = "" #卡号保存在isssuecard里面
agrp = flds.get("Grp", "")
tz = flds.get("TZ", "")
priv = flds.get('Pri', 0)
fldNames = ['SN', 'utime']
values = [device.id, str(datetime.datetime.now())[:19]]
if ename and (ename != e.EName):
fldNames.append('name')
values.append(ename)
e.EName = ename
from base.crypt import encryption #设备传过来的密码没加密 需要加密再和数据库中的比较
if passwd and (encryption(passwd) != e.Password):
fldNames.append('password')
values.append(passwd)
e.Password = passwd
if priv and (str(priv) != str(e.Privilege)): #考虑下数据字段类型
fldNames.append('privilege')
values.append(str(priv))
e.Privilege = str(priv)
if card and (card_to_num(card) != e.Card):
if str(card_to_num(card)).strip() != "0":
vcard = card_to_num(card)
else:
vcard = ""
fldNames.append('Card')
values.append(vcard)
tmp_card = vcard
elif card == "" and e.Card: #机器是否删除卡号
fldNames.append('Card')
values.append("")
tmp_card = ""
if agrp and (str(agrp) != str(e.AccGroup)):
fldNames.append('AccGroup')
values.append(str(agrp))
e.AccGroup = str(agrp)
if tz != e.TimeZones:
fldNames.append('TimeZones')
values.append(tz)
e.TimeZones = tz
try:
e.IsNewEmp
except:
e.IsNewEmp = False
if e.IsNewEmp: #新增用户
e.IsNewEmp = False
e.DeptID_id = 1
e.attarea = (device.area, )
e.save()
if tmp_card and not get_option("POS"):
from mysite.personnel.models.model_issuecard import IssueCard, CARD_VALID
obj_card = IssueCard()
obj_card.UserID = e
obj_card.cardno = tmp_card
obj_card.cardstatus = CARD_VALID
obj_card.save()
devs = set(e.search_device_byuser())
if devs:
try:
devs.remove(device)
except:
pass
for dev in devs:
dev.set_user([e], Op, "")
dev.set_user_fingerprint([e], Op)
time.sleep(0.01)
sql = ''
elif len(fldNames) > 2: #有新的用户信息
from mysite.personnel.models.model_issuecard import IssueCard, CARD_VALID, CARD_STOP
devs = set(e.search_device_byuser())
e.save()
try:
obj_card = IssueCard.objects.get(UserID=e, cardno=tmp_card)
except:
obj_card = None
if not obj_card and not get_option("POS"):
try:
temp_card = IssueCard.objects.get(
UserID=e, cardstatus=CARD_VALID)
temp_card.cardstatus = CARD_STOP #停用之前的卡号
temp_card.save()
except:
pass
if tmp_card: #卡处理
obj_card = IssueCard()
obj_card.UserID = e
obj_card.cardno = tmp_card
obj_card.cardstatus = CARD_VALID
obj_card.save()
else:
if not get_option("POS"): #消费的时候不能覆盖
obj_card.cardno = tmp_card
obj_card.save()
if devs:
try:
devs.remove(device)
except:
pass
for dev in devs:
dev.set_user([e], Op, "")
dev.set_user_fingerprint([e], Op)
time.sleep(0.01)
else:
pass
return e
elif str(ops[0]).strip() == "FP": #----------------用户的指纹模板
if not settings.DEVICE_CREATEBIO_FLAG:
return
if e.IsNewEmp: #新增用户
e.DeptID_id = 1
e.attarea = (device.area, )
e.save()
emps = e
try:
size = flds["Size"]
fp = flds["TMP"]
d_len = len(fp.decode("base64"))
if fp and (len(fp) == int(size) or d_len == int(size)):
devs = set(e.search_device_byuser())
if devs:
try:
devs.remove(device)
except:
pass
e = Template.objects.filter(UserID=e.id,
FingerID=int(flds["FID"]),
Fpversion=device.Fpversion)
if len(e) > 0:
e = e[0]
if fp[:100] == e.Template[:100]:
pass # Template is same
else: #指纹有修改
e.Template = fp
e.Fpversion = device.Fpversion
e.UTime = datetime.datetime.now().strftime(
"%Y-%m-%d %H:%M:%S")
e.save()
for dev in devs:
dev.set_user_fingerprint([emps], Op,
int(flds["FID"]))
time.sleep(0.01)
else: #新增指纹
e = Template()
e.UserID = emps
e.Template = fp
e.UTime = datetime.datetime.now().strftime(
"%Y-%m-%d %H:%M:%S")
e.FingerID = int(flds["FID"])
e.Fpversion = device.Fpversion
e.Valid = 1
e.save()
for dev in devs:
dev.set_user_fingerprint([emps], Op, int(flds["FID"]))
time.sleep(0.01)
return True
else:
print "size:%s TMP size:%s" % (size, len(fp))
print "template length error"
except:
import traceback
traceback.print_exc()
else:
return False
elif str(ops[0]).strip(
) == "FACE": ######################## 新增人脸模板相关命令处理 ##################
if e.IsNewEmp: #-----保存设备新增用户的其他信息
e.DeptID_id = 1
e.attarea = (device.area, )
e.save()
emps = e
try:
postuser_face(flds, e, device, Op)
return True
except:
import traceback
traceback.print_exc()
else:
return False
elif str(ops[0]).strip() == "USERPIC": #####################加入用户照片 处理
if e.IsNewEmp: #-----保存设备新增用户的其他信息
e.DeptID_id = 1
e.attarea = (device.area, )
e.save()
emps = e
try:
postuser_photo(flds, e, device)
return True
except:
import traceback
traceback.print_exc()
else:
return False
def line_to_emp(cursor, device, line, Op,event=True):
'''
解析设备命令
line：设备post过来的命令字符串
device：传送命令的设备
'''
from mysite import settings
import os
try: #---行数据以空格分割标志名和键值对数据
if line.find("\tName=") > 0:
ops = unicode(line.decode("gb18030")).split(" ", 1)
else:
ops = line.split(" ", 1)
except:
ops = line.split(" ", 1)
if ops[0] == 'OPLOG': #-------------管理员操作记录 ops[0] 为标志名
from conv_device import line_to_oplog
return line_to_oplog(cursor, device, ops[1], event)
flds = {}; #-----------行数据中包含的所以键值对
for item in ops[1].split("\t"):
index = item.find("=")
if index > 0: flds[item[:index]] = item[index + 1:]
try:
pin = str(int(flds["PIN"])) #---得到用户编号
if int(pin) in settings.DISABLED_PINS or len(pin)>settings.PIN_WIDTH: #----用户编号有效性验证
return
except:
return
e = get_employee(pin, device) #--- 得到命令对应的人员对象 必须有
if not e:
return
if str(ops[0]).strip() == "USER": #----------用户基本信息
if not settings.DEVICE_CREATEUSER_FLAG:
return
try:
ename = unicode(flds["Name"])[:40]
except:
ename = ' '
passwd = flds.get("Passwd","")
card = flds.get("Card", "")
tmp_card = "" #卡号保存在isssuecard里面
agrp = flds.get("Grp", "")
tz = flds.get("TZ","")
priv = flds.get('Pri', 0)
fldNames = ['SN', 'utime']
values = [device.id, str(datetime.datetime.now())[:19]]
if ename and (ename != e.EName):
fldNames.append('name')
values.append(ename)
e.EName = ename
from base.crypt import encryption#设备传过来的密码没加密 需要加密再和数据库中的比较
if passwd and (encryption(passwd) != e.Password):
fldNames.append('password')
values.append(passwd)
e.Password = passwd
if priv and (str(priv) !=str(e.Privilege)):#考虑下数据字段类型
fldNames.append('privilege')
values.append(str(priv))
e.Privilege = str(priv)
if card and (card_to_num(card) != e.Card):
if str(card_to_num(card)).strip()!="0":
vcard=card_to_num(card)
else:
vcard=""
fldNames.append('Card')
values.append(vcard)
tmp_card = vcard
if agrp and (str(agrp) != str(e.AccGroup)):
fldNames.append('AccGroup')
values.append(str(agrp))
e.AccGroup = str(agrp)
if tz != e.TimeZones:
fldNames.append('TimeZones')
values.append(tz)
e.TimeZones = tz
try:
e.IsNewEmp
except:
e.IsNewEmp = False
if e.IsNewEmp: #新增用户
e.IsNewEmp = False
e.DeptID_id=1
e.attarea=(device.area,)
e.save()
if tmp_card and not get_option("POS"):
from mysite.personnel.models.model_issuecard import IssueCard,CARD_VALID
obj_card = IssueCard()
obj_card.UserID = e
obj_card.cardno = tmp_card
obj_card.cardstatus = CARD_VALID
obj_card.save()
devs=set(e.search_device_byuser())
if devs:
try:
devs.remove(device)
except:
pass
for dev in devs:
dev.set_user([e], Op,"")
dev.set_user_fingerprint([e], Op)
time.sleep(0.01)
sql = ''
elif len(fldNames) > 2: #有新的用户信息
devs=set(e.search_device_byuser())
e.save()
if tmp_card:#卡处理
from mysite.personnel.models.model_issuecard import IssueCard,CARD_VALID
try:
obj_card = IssueCard.objects.get(UserID=e,cardstatus=CARD_VALID)
except:
obj_card = None
if not obj_card:
obj_card = IssueCard()
obj_card.UserID = e
obj_card.cardno = tmp_card
obj_card.cardstatus = CARD_VALID
obj_card.save()
else:
if not get_option("POS"):#消费的时候不能覆盖
obj_card.cardno = tmp_card
obj_card.save()
if devs:
try:
devs.remove(device)
except:
pass
for dev in devs:
dev.set_user([e], Op,"")
dev.set_user_fingerprint([e], Op)
time.sleep(0.01)
else:
pass
return e
elif str(ops[0]).strip() == "FP": #----------------用户的指纹模板
if not settings.DEVICE_CREATEBIO_FLAG:
return
if e.IsNewEmp: #新增用户
e.DeptID_id=1
e.attarea=(device.area,)
e.save()
emps=e
try:
size=flds["Size"]
fp = flds["TMP"]
d_len=len(fp.decode("base64"))
if fp and (len(fp)==int(size) or d_len==int(size) ):
devs=set(e.search_device_byuser())
if devs:
try:
devs.remove(device)
except:
pass
e = Template.objects.filter(UserID=e.id, FingerID=int(flds["FID"]),Fpversion=device.Fpversion)
if len(e)>0:
e=e[0]
if fp[:100] == e.Template[:100]:
pass # Template is same
else: #指纹有修改
e.Template=fp
e.Fpversion=device.Fpversion
e.UTime=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
e.save()
for dev in devs:
dev.set_user_fingerprint([emps], Op, int(flds["FID"]))
time.sleep(0.01)
else: #新增指纹
e=Template()
e.UserID=emps
e.Template=fp
e.UTime=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
e.FingerID=int(flds["FID"])
e.Fpversion=device.Fpversion
e.Valid=1
e.save()
for dev in devs:
dev.set_user_fingerprint([emps], Op, int(flds["FID"]))
time.sleep(0.01)
return True
else:
print "size:%s TMP size:%s"%(size,len(fp))
print "template length error"
except:
import traceback; traceback.print_exc();
else:
return False
elif str(ops[0]).strip() == "FACE" : ######################## 新增人脸模板相关命令处理 ##################
if e.IsNewEmp: #-----保存设备新增用户的其他信息
e.DeptID_id=1
e.attarea=(device.area,)
e.save()
emps=e
try:
from new_push import postuser_face
postuser_face(flds,e,device,Op)
return True
except:
import traceback; traceback.print_exc();
else:
return False
elif str(ops[0]).strip() == "USERPIC" : #####################加入用户照片 处理
if e.IsNewEmp: #-----保存设备新增用户的其他信息
e.DeptID_id=1
e.attarea=(device.area,)
e.save()
emps=e
try:
from new_push import postuser_photo
postuser_photo(flds,e,device)
return True
except:
import traceback; traceback.print_exc();
else:
return False
def line_to_log(device, line, event=True):
"""
解析 Stamp 的行数据
"""
flds = line.split("\t") + ["", "", "", "", "", "", "", ""]
# 检查员工号码的合法性
pin = flds[0] # ---第一个元素为人员编号
try:
if pin in settings.DISABLED_PINS:
return None
except:
return None
if flds[5] == "255" and flds[3] == "3" and flds[0] == flds[4]:
print u"Swiped a invalid card: \n", line
return None
from db_utils import get_employee
emp = get_employee(pin, device)
if not emp:
return None
if emp.IsNewEmp:
emp.DeptID_id = 1
emp.attarea = (device.area,) # ---更新考勤区域
emp.save()
pin = emp.id
try:
logtime = datetime.datetime.strptime(flds[1], "%Y-%m-%d %H:%M:%S") # ---第二个元素为打卡时间
except:
return None
now = datetime.datetime.now()
# ---检查考勤记录时间的合法性
if event:
if (now + datetime.timedelta(1, 0, 0)) < logtime:
print u"时间比当前时间还要多一天"
return None
if logtime < now - datetime.timedelta(days=settings.VALID_DAYS):
print u"时间比当前要早...天", settings.VALID_DAYS
return None
if settings.CHECK_DUPLICATE_LOG or (not event): # 检查重复记录
try:
if Transaction.objects.filter(TTime=logtime, UserID=emp):
print u"该记录已经存在"
return None
except:
pass
# 根据考勤机的时区矫正考勤记录的时区，使之同服务器的时区保持一致
if device.tz_adj <> None:
count_minutes = None
if abs(device.tz_adj) <= 13:
count_minutes = device.tz_adj * 3600
else:
count_minutes = device.tz_adj * 60
logtime = logtime - datetime.timedelta(0, count_minutes) + server_time_delta # UTC TIM
sql = (pin, logtime, normal_state(flds[2]), normal_verify(flds[3]), None, flds[4], flds[5], device.sn)
return sql