def save_door_objects(cur_obj, objs):
for door in objs:
if door != cur_obj:
try:
door.lock_delay = cur_obj.lock_delay
door.back_lock = cur_obj.back_lock
door.sensor_delay = cur_obj.sensor_delay
door.opendoor_type = cur_obj.opendoor_type
door.inout_state = cur_obj.inout_state
door.lock_active = cur_obj.lock_active
door.long_open = cur_obj.long_open
door.wiegand_fmt = cur_obj.wiegand_fmt
door.card_intervaltime = cur_obj.card_intervaltime
door.reader_type = cur_obj.reader_type
door.is_att = cur_obj.is_att
p2 = re.compile(r'^([0-9]+)$')
if not p2.match(cur_obj.force_pwd):
door.force_pwd = decrypt(cur_obj.force_pwd)
if not p2.match(cur_obj.supper_pwd):
door.supper_pwd = decrypt(cur_obj.supper_pwd)
door.door_sensor_status = cur_obj.door_sensor_status
door.save(force_update=True)
except:
import traceback
traceback.print_exc()
def save_door_objects(cur_obj, objs):
for door in objs:
if door != cur_obj:
try:
door.lock_delay = cur_obj.lock_delay
door.back_lock = cur_obj.back_lock
door.sensor_delay = cur_obj.sensor_delay
door.opendoor_type = cur_obj.opendoor_type
door.inout_state = cur_obj.inout_state
door.lock_active = cur_obj.lock_active
door.long_open = cur_obj.long_open
door.wiegand_fmt = cur_obj.wiegand_fmt
door.card_intervaltime = cur_obj.card_intervaltime
door.reader_type = cur_obj.reader_type
door.is_att = cur_obj.is_att
p2 = re.compile(r"^([0-9]+)$")
if not p2.match(cur_obj.force_pwd):
door.force_pwd = decrypt(cur_obj.force_pwd)
if not p2.match(cur_obj.supper_pwd):
door.supper_pwd = decrypt(cur_obj.supper_pwd)
door.door_sensor_status = cur_obj.door_sensor_status
door.save(force_update=True)
except:
import traceback
traceback.print_exc()
def check_password(self, raw_password, password):
password = decrypt(password)
if raw_password == password:
return True
else:
return False
def get_data(request):
fun_mode = request.REQUEST.get("func", "")
if fun_mode == "video":
type = request.GET.get("type", "")
u = request.user
aa = u.areaadmin_set.all()
a_limit = aa and [int(a.area_id) for a in aa] or [int(area.pk) for area in Area.objects.all()]#非超级管理员且没有配置有效区域（默认全部）的有效区域id列表（即用户手动配置过用户区域的）
print "a_limit=", a_limit
if type == 'all_device':
devices = Device.objects.filter(area__pk__in=a_limit).filter(device_type=2).order_by('id').values_list('id', 'alias')
videos = Device.objects.filter(area__pk__in=a_limit).filter(device_type=4).order_by('id').values_list('id', 'alias')
doors = AccDoor.objects.filter(device__area__pk__in=a_limit).order_by('id').values_list('id', 'door_name')
return getJSResponse(smart_str(simplejson.dumps({ 'type': 'all', 'videos': [device for device in videos], 'devices': [device for device in devices], 'doors': [door for door in doors]})))
if type == 'device': #通过设备查找相绑定的视频服务器
device_id = request.GET.get("device_id", 0)
doors = AccDoor.objects.filter(device__area__pk__in=a_limit).filter(device__id=device_id).order_by('id').values_list('id', 'door_name')
door = [door[0] for door in doors]
linkages = AccLinkageIO.objects.filter(device__pk__in = [device_id]).filter(in_address_hide__in = door)
videos=[link.video_linkageio.id for link in linkages]
devices = Device.objects.filter(area__pk__in=a_limit).filter(id__in=videos).filter(device_type=4).order_by('id').values_list('id', 'alias', 'ipaddress', 'ip_port', 'video_login', 'comm_pwd')
return getJSResponse(smart_str(simplejson.dumps({ 'type': 'device', 'videos': [device for device in devices], 'devices': '', 'doors': [door for door in doors]})))
if type == 'door':
door_id = request.GET.get("door_id", 0)
print "door_id=", door_id
doors = AccDoor.objects.filter(device__area__pk__in=a_limit).filter(id=door_id)
print "doors=", doors, "=", doors[0].device
videos=[]
if doors:
linkages = AccLinkageIO.objects.filter(device = doors[0].device).filter(in_address_hide = doors[0].door_no)
videos=[link.video_linkageio.id for link in linkages]
devices = Device.objects.filter(area__pk__in=a_limit).filter(id__in=videos).filter(device_type=4).order_by('id').values_list('id', 'alias', 'ipaddress', 'ip_port', 'video_login', 'comm_pwd')
print "devices=", devices
return getJSResponse(smart_str(simplejson.dumps({ 'type': 'door', 'videos': [device for device in devices], 'devices': '', 'doors': ""})))
if type == 'all_video':
devices = Device.objects.filter(area__pk__in=a_limit).filter(device_type=4).order_by('id').values_list('id', 'alias', 'ipaddress', 'ip_port', 'video_login', 'comm_pwd')
return getJSResponse(smart_str(simplejson.dumps({ 'type': 'allvideo', 'videos': [device for device in devices], 'devices': ''})))
if type == 'videoserver':
device_id = request.GET.get("server_id", 0)
devices = Device.objects.filter(area__pk__in=a_limit).filter(device_type=4, id=device_id).order_by('id').values_list('id', 'alias', 'ipaddress', 'ip_port', 'video_login', 'comm_pwd')
#devices[0][5] = devices[0][5] and decrypt(devices[0][5]) or ""
device=[devices[0][0], devices[0][1], devices[0][2], devices[0][3], devices[0][4], devices[0][5] and decrypt(devices[0][5]) or ""];
return getJSResponse(smart_str(simplejson.dumps({ 'type': 'video', 'videos': '', 'devices': device})))
def check_password(self, raw_password, password):
password = decrypt(password)
if raw_password == password: return True
else: return False
def get_redis_rtlog(request):
logid = int(request.GET.get('logid', FIRSTVISIT_OR_DELBACKEND))
step = int(request.GET.get('step', 0)) #步长：即要log的最大条数
rt_type = request.GET.get('type', '') #all alarm
devid = request.REQUEST.get("devid", 0) #默认为0，表示监控所有设备的所有门的状态
#再获取实时监控记录
q_server = check_and_start_queqe_server()
#print "--",logid+step
# cfg = dict4ini.DictIni(os.getcwd()+"/appconfig.ini",values={"iaccess": {"down_newlog": 0}}) #默认0点定时下载新记录,定时删除缓存
# now_hour = datetime.datetime.now().hour
# if now_hour == cfg.iaccess.down_newlog:
# q_server.delete("MONITOR_RT")
# q_server.delete("ALARM_RT")
# logid = -1#重新取
rtid_all = 0 #缓存里所有的记录条数
rtid_alarm = 0 #缓存里所有的报警事件记录
log_count = 0 #返回的有效记录条数
valid_devices = []
if rt_type == "all":
rtid_all = q_server.lock_rlen(
"MONITOR_RT") #被锁住时以及文件缓存为空时都返回-1，即该值不可能为0 此时前端继续使用原来的logid取数据
if (rtid_all != LOCKED_OR_NOTHING) and (
rtid_all <
logid): #主要用于后台服务0时定时删除监控缓存时可能导致的不一致，故重新取，当数据量少时未必准确。
logid = FIRSTVISIT_OR_DELBACKEND #重新取
#获取门状态door_states
valid_devices = obtain_valid_devices(request)
#print '---valid_devices=',valid_devices
door_states = door_state_monitor(valid_devices) #门状态不涉及辅助输入点，故不需调整
if logid == FIRSTVISIT_OR_DELBACKEND: #监控全部时获取报警记录的初始id值
rtid_alarm = q_server.llen("ALARM_RT")
rtlog = q_server.lrange("MONITOR_RT", logid, logid + step)
elif rt_type == "alarm":
rtid_alarm = q_server.lock_rlen("ALARM_RT")
if (rtid_alarm != LOCKED_OR_NOTHING) and (
rtid_alarm < logid
): #主要用于后台服务0时定时删除监控缓存时可能导致的不一致，故重新取，当数据量少时未必准确。--包含发现报警事件的按钮如果被删除，那么跳转后直接重新开始
logid = FIRSTVISIT_OR_DELBACKEND #重新取
door_states = {"data": []}
rtlog = q_server.lrange("ALARM_RT", logid, logid + step)
#rtlog数据格式如下“0-时间 + 1-PIN号 + 2-门id + 3-事件类型 + 4-出入状态 +5-验证方式 +6-卡号+7-设备号”
#rtlog = ['2010-03-07 09:53:51,370,4,6,0,221,36656656']
#print 'door_states=',door_states
#print "----------------------rtlog=", rtlog
q_server.connection.disconnect()
cdatas = []
a_logids = []
#如下代码测试时请注释掉
if logid == FIRSTVISIT_OR_DELBACKEND:
cc = {
'log_id': logid,
'all_id': (rtid_all != LOCKED_OR_NOTHING) and rtid_all
or 0, #redis中所有记录条数
'alarm_id': rtid_alarm,
'log_count': log_count, #返回的记录条数
'data': cdatas,
'door_states': door_states["data"],
}
rtdata = simplejson.dumps(cc)
return HttpResponse(smart_str(rtdata))
if not valid_devices: #如果之前没有进入“all”则需要重新获取有效设备（主要是避免重新获取，每次请求只获取一次即可）
valid_devices = obtain_valid_devices(request) #通过设备找到对应的门以及辅助输入，作为事件点
for alog in rtlog:
log = alog.strip()
#print "log=", log
#验证数据合法性，保证了除了时间之外的数据都是数字字符，从而可以使用int()而不会出错
p1 = re.compile(
r'(((^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(10|12|0?[13578])([-\/\._])(3[01]|[12][0-9]|0?[1-9]))|(^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(11|0?[469])([-\/\._])(30|[12][0-9]|0?[1-9]))|(^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(0?2)([-\/\._])(2[0-8]|1[0-9]|0?[1-9]))|(^([2468][048]00)([-\/\._])(0?2)([-\/\._])(29))|(^([3579][26]00)([-\/\._])(0?2)([-\/\._])(29))|(^([1][89][0][48])([-\/\._])(0?2)([-\/\._])(29))|(^([2-9][0-9][0][48])([-\/\._])(0?2)([-\/\._])(29))|(^([1][89][2468][048])([-\/\._])(0?2)([-\/\._])(29))|(^([2-9][0-9][2468][048])([-\/\._])(0?2)([-\/\._])(29))|(^([1][89][13579][26])([-\/\._])(0?2)([-\/\._])(29))|(^([2-9][0-9][13579][26])([-\/\._])(0?2)([-\/\._])(29)))((\s+(0?[1-9]|1[012])(:[0-5]\d){0,2}(\s[AP]M))?$|(\s+([01]\d|2[0-3])(:[0-5]\d){0,2})?$))'
)
p2 = re.compile(r'^,(((\d+),){6}\d+)$') #r'^,(((\d+),){4}\d+)?$' 5-6
if p1.match(log[0:19]) and p2.match(log[19:]):
log_count += 1
str = log.split(",", 8) #0-7 共8部分
#print "accmonitorlog=", str
#设备名称
dev_id = int(str[7])
dev = Device.objects.filter(pk=dev_id)
alias = dev and unicode(dev[0].alias) or ""
if dev and dev[
0] not in valid_devices: #设备级别的过滤--辅助输入（含联动中触发条件为辅助输入点的）
break
#事件类型
event = int(str[3])
#验证方式（或源事件类型）,但是当事件为联动事件时为联动事件的原事件
veri_event = int(str[5])
#卡号-联动时复用为联动id号（pk）
card_no = int(str[6]) and str[6] or ''
door_id = 0
link_video = []
#print '---vari_event=',veri_event,' event=',event,' door_id',door_id,
if event == 220 or event == 221: #辅助输入点的事件
#事件点
in_address_id = int(str[2]) #辅助输入点，如1,2,3,4 9，10,11,12
event_point = unicode(dict(IN_ADDRESS_CHOICES)[in_address_id])
#验证方式
try:
verified = unicode(
dict(VERIFIED_CHOICES)[veri_event]
) #the true verified method("others" included)
except:
verified = unicode(_(u"数据异常"))
else: #与门相关
door_id_limit = obtain_valid_doors(
request, valid_devices) #可控的ip地址，不包含辅助输入点
if event == 6: #事件类型为联动事件
#print '----------------event=',event
#verified = ''#联动事件验证方式为空-固件字段复用--触发的原事件
verified = unicode(dict(VERIFIED_CHOICES)[200]) #其他
if veri_event == 220 or veri_event == 221:
number = int(str[2]) #如C4 9，10,11,12
event_point = unicode(dict(IN_ADDRESS_CHOICES)[number])
#linkage = AccLinkageIO.objects.filter(Q(device__id=dev_id), Q(trigger_opt=veri_event), Q(in_address_hide=number)|Q(in_address_hide=0))#输入点inout或0只能居其一
else:
door_id = int(str[2]) #门id（不同于门编号）
if door_id not in door_id_limit: #门级别的过滤
break #跳出for循环，该记录无效
#事件点
doors = AccDoor.objects.filter(id=door_id)
event_point = doors and unicode(doors[0]) or ""
#视频联动处理
try:
link_id = int(card_no) or 0 #联动时卡号复用为联动id号
except:
link_id = 1
card_no = '' #联动时不需要显示卡号
#print "link_id=", link_id
from mysite.iaccess.models import AccLinkageIO
try:
linkage = AccLinkageIO.objects.filter(id=link_id)
if linkage:
pwd = linkage[0].video_linkageio.comm_pwd
link_video.append(
linkage[0].video_linkageio.ipaddress)
link_video.append(
linkage[0].video_linkageio.ip_port)
link_video.append(
linkage[0].video_linkageio.video_login)
link_video.append(pwd and decrypt(pwd) or "")
link_video.append(linkage[0].lchannel_num)
except:
print_exc()
else: #其他事件--门相关或设备相关
door_id = int(str[2]) #门id--如果为0,指的是事件点为设备（如取消报警事件）
if door_id: #不为0
if door_id not in door_id_limit: #门级别的过滤
break #跳出for循环，该记录无效
#事件点
doors = AccDoor.objects.filter(id=door_id)
event_point = doors and unicode(doors[0]) or ""
else:
event_point = "" #如取消报警事件
try:
verified = unicode(
dict(VERIFIED_CHOICES)[veri_event]
) #the true verified method("others" included)
except:
verified = unicode(_(u"数据异常"))
try:
event_content = unicode(dict(
EVENT_CHOICES)[event]) #description of the triggered event
except:
event_content = unicode(_(u"数据异常"))
#print 'str[1]=',str[1]
pin_str = int(str[1]) and unicode(format_pin(str[1])) or ''
#print '---pin_str=',pin_str
emps = pin_str and Employee.objects.filter(PIN=pin_str) or ''
#print 'emps=',emps
if emps:
empname = emps[0].EName and u"%s(%s)" % (
str[1], emps[0].EName) or u"%s" % (str[1])
photo = emps[0].photo and '/file/' + unicode(
emps[0].photo) or ''
else:
empname = ''
photo = ''
#print '--str[6]=',str[6]
#state = int(str[4])!=2 and unicode(dict(STATE_CHOICES)[int(str[4])]) or ''#2直接显示空
#连动视频
#print "link_video=", link_video
#print '---photo=',photo
cdata = {
'time': str[0],
'card': card_no,
#'door': doorname,#输入点，包含门名称或者辅助输入点
'device': alias, #设备名称
'event_point': event_point, #输入点，包含门名称或者辅助输入点
'door_id': door_id, #doorid
'event_type': int(str[3]),
'content': event_content,
'state': unicode(dict(STATE_CHOICES)[int(str[4])]), #0出，1入
'verified': verified,
'emp': empname, #用户名(包含用户编号)
'photo':
photo, #有人员照片的要显示,如/file/photo/000000121.jpg 空代表无照片（或无此人）
'link_video': link_video,
}
cdatas.append(cdata)
else:
print "DATA ERROR"
cc = {
'log_id': logid,
'all_id': rtid_all, #无效
'alarm_id': rtid_alarm,
'log_count': log_count, #返回的有效的记录条数，用于改变logid
'data': cdatas,
'door_states': door_states["data"], #门状态数据
}
#print "**########**cc=",cc
rtdata = simplejson.dumps(cc)
return HttpResponse(smart_str(rtdata))
def get_redis_rtlog(request):
logid = int(request.GET.get('logid', FIRSTVISIT_OR_DELBACKEND))
step = int(request.GET.get('step', 0))#步长：即要log的最大条数
rt_type = request.GET.get('type', '')#all alarm
devid = request.REQUEST.get("devid", 0)#默认为0，表示监控所有设备的所有门的状态
#再获取实时监控记录
q_server = check_and_start_queqe_server()
#print "--",logid+step
# cfg = dict4ini.DictIni(os.getcwd()+"/appconfig.ini",values={"iaccess": {"down_newlog": 0}}) #默认0点定时下载新记录,定时删除缓存
# now_hour = datetime.datetime.now().hour
# if now_hour == cfg.iaccess.down_newlog:
# q_server.delete("MONITOR_RT")
# q_server.delete("ALARM_RT")
# logid = -1#重新取
rtid_all = 0#缓存里所有的记录条数
rtid_alarm = 0#缓存里所有的报警事件记录
log_count = 0#返回的有效记录条数
valid_devices = []
if rt_type == "all":
rtid_all = q_server.lock_rlen("MONITOR_RT")#被锁住时以及文件缓存为空时都返回-1，即该值不可能为0 此时前端继续使用原来的logid取数据
if (rtid_all != LOCKED_OR_NOTHING) and (rtid_all < logid):#主要用于后台服务0时定时删除监控缓存时可能导致的不一致，故重新取，当数据量少时未必准确。
logid = FIRSTVISIT_OR_DELBACKEND#重新取
#获取门状态door_states
valid_devices = obtain_valid_devices(request)
#print '---valid_devices=',valid_devices
door_states = door_state_monitor(valid_devices)#门状态不涉及辅助输入点，故不需调整
if logid == FIRSTVISIT_OR_DELBACKEND:#监控全部时获取报警记录的初始id值
rtid_alarm = q_server.llen("ALARM_RT")
rtlog = q_server.lrange("MONITOR_RT", logid, logid + step)
elif rt_type == "alarm":
rtid_alarm = q_server.lock_rlen("ALARM_RT")
if (rtid_alarm != LOCKED_OR_NOTHING) and (rtid_alarm < logid):#主要用于后台服务0时定时删除监控缓存时可能导致的不一致，故重新取，当数据量少时未必准确。--包含发现报警事件的按钮如果被删除，那么跳转后直接重新开始
logid = FIRSTVISIT_OR_DELBACKEND#重新取
door_states = { "data": []}
rtlog = q_server.lrange("ALARM_RT", logid, logid + step)
#rtlog数据格式如下“0-时间 + 1-PIN号 + 2-门id + 3-事件类型 + 4-出入状态 +5-验证方式 +6-卡号+7-设备号”
#rtlog = ['2010-03-07 09:53:51,370,4,6,0,221,36656656']
#print 'door_states=',door_states
#print "----------------------rtlog=", rtlog
q_server.connection.disconnect()
cdatas = []
a_logids = []
#如下代码测试时请注释掉
if logid == FIRSTVISIT_OR_DELBACKEND:
cc={
'log_id': logid,
'all_id': (rtid_all != LOCKED_OR_NOTHING) and rtid_all or 0,#redis中所有记录条数
'alarm_id': rtid_alarm,
'log_count': log_count,#返回的记录条数
'data': cdatas,
'door_states': door_states["data"],
}
rtdata = simplejson.dumps(cc)
return HttpResponse(smart_str(rtdata))
if not valid_devices:#如果之前没有进入“all”则需要重新获取有效设备（主要是避免重新获取，每次请求只获取一次即可）
valid_devices = obtain_valid_devices(request)#通过设备找到对应的门以及辅助输入，作为事件点
for alog in rtlog:
log = alog.strip()
#print "log=", log
#验证数据合法性，保证了除了时间之外的数据都是数字字符，从而可以使用int()而不会出错
p1 = re.compile(r'(((^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(10|12|0?[13578])([-\/\._])(3[01]|[12][0-9]|0?[1-9]))|(^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(11|0?[469])([-\/\._])(30|[12][0-9]|0?[1-9]))|(^((1[8-9]\d{2})|([2-9]\d{3}))([-\/\._])(0?2)([-\/\._])(2[0-8]|1[0-9]|0?[1-9]))|(^([2468][048]00)([-\/\._])(0?2)([-\/\._])(29))|(^([3579][26]00)([-\/\._])(0?2)([-\/\._])(29))|(^([1][89][0][48])([-\/\._])(0?2)([-\/\._])(29))|(^([2-9][0-9][0][48])([-\/\._])(0?2)([-\/\._])(29))|(^([1][89][2468][048])([-\/\._])(0?2)([-\/\._])(29))|(^([2-9][0-9][2468][048])([-\/\._])(0?2)([-\/\._])(29))|(^([1][89][13579][26])([-\/\._])(0?2)([-\/\._])(29))|(^([2-9][0-9][13579][26])([-\/\._])(0?2)([-\/\._])(29)))((\s+(0?[1-9]|1[012])(:[0-5]\d){0,2}(\s[AP]M))?$|(\s+([01]\d|2[0-3])(:[0-5]\d){0,2})?$))')
p2 = re.compile(r'^,(((\d+),){6}\d+)$')#r'^,(((\d+),){4}\d+)?$' 5-6
if p1.match(log[0:19]) and p2.match(log[19:]):
log_count += 1
str = log.split(",",8)#0-7 共8部分
#print "accmonitorlog=", str
#设备名称
dev_id = int(str[7])
dev = Device.objects.filter(pk=dev_id)
alias = dev and unicode(dev[0].alias) or ""
if dev and dev[0] not in valid_devices:#设备级别的过滤--辅助输入（含联动中触发条件为辅助输入点的）
break
#事件类型
event = int(str[3])
#验证方式（或源事件类型）,但是当事件为联动事件时为联动事件的原事件
veri_event = int(str[5])
#卡号-联动时复用为联动id号（pk）
card_no = int(str[6]) and str[6] or ''
door_id = 0
link_video = []
#print '---vari_event=',veri_event,' event=',event,' door_id',door_id,
if event == 220 or event == 221:#辅助输入点的事件
#事件点
in_address_id = int(str[2])#辅助输入点，如1,2,3,4 9，10,11,12
event_point = unicode(dict(IN_ADDRESS_CHOICES)[in_address_id])
#验证方式
try:
verified = unicode(dict(VERIFIED_CHOICES)[veri_event])#the true verified method("others" included)
except:
verified = unicode(_(u"数据异常"))
else:#与门相关
door_id_limit = obtain_valid_doors(request, valid_devices)#可控的ip地址，不包含辅助输入点
if event == 6:#事件类型为联动事件
#print '----------------event=',event
#verified = ''#联动事件验证方式为空-固件字段复用--触发的原事件
verified = unicode(dict(VERIFIED_CHOICES)[200])#其他
if veri_event == 220 or veri_event == 221:
number = int(str[2]) #如C4 9，10,11,12
event_point = unicode(dict(IN_ADDRESS_CHOICES)[number])
#linkage = AccLinkageIO.objects.filter(Q(device__id=dev_id), Q(trigger_opt=veri_event), Q(in_address_hide=number)|Q(in_address_hide=0))#输入点inout或0只能居其一
else:
door_id = int(str[2])#门id（不同于门编号）
if door_id not in door_id_limit:#门级别的过滤
break #跳出for循环，该记录无效
#事件点
doors = AccDoor.objects.filter(id=door_id)
event_point = doors and unicode(doors[0]) or ""
#视频联动处理
try:
link_id = int(card_no) or 0#联动时卡号复用为联动id号
except:
link_id = 1
card_no = ''#联动时不需要显示卡号
#print "link_id=", link_id
from mysite.iaccess.models import AccLinkageIO
try:
linkage = AccLinkageIO.objects.filter(id = link_id)
if linkage:
pwd = linkage[0].video_linkageio.comm_pwd
link_video.append(linkage[0].video_linkageio.ipaddress)
link_video.append(linkage[0].video_linkageio.ip_port)
link_video.append(linkage[0].video_linkageio.video_login)
link_video.append(pwd and decrypt(pwd) or "")
link_video.append(linkage[0].lchannel_num)
except:
print_exc()
else:#其他事件--门相关或设备相关
door_id = int(str[2])#门id--如果为0,指的是事件点为设备（如取消报警事件）
if door_id:#不为0
if door_id not in door_id_limit:#门级别的过滤
break #跳出for循环，该记录无效
#事件点
doors = AccDoor.objects.filter(id=door_id)
event_point = doors and unicode(doors[0]) or ""
else:
event_point = ""#如取消报警事件
try:
verified = unicode(dict(VERIFIED_CHOICES)[veri_event])#the true verified method("others" included)
except:
verified = unicode(_(u"数据异常"))
try:
event_content = unicode(dict(EVENT_CHOICES)[event])#description of the triggered event
except:
event_content = unicode(_(u"数据异常"))
#print 'str[1]=',str[1]
pin_str = int(str[1]) and unicode(format_pin(str[1])) or ''
#print '---pin_str=',pin_str
emps = pin_str and Employee.objects.filter(PIN = pin_str) or ''
#print 'emps=',emps
if emps:
empname = emps[0].EName and u"%s(%s)"%(str[1], emps[0].EName) or u"%s"%(str[1])
photo = emps[0].photo and '/file/' + unicode(emps[0].photo) or ''
else:
empname = ''
photo = ''
#print '--str[6]=',str[6]
#state = int(str[4])!=2 and unicode(dict(STATE_CHOICES)[int(str[4])]) or ''#2直接显示空
#连动视频
#print "link_video=", link_video
#print '---photo=',photo
cdata={
'time': str[0],
'card': card_no,
#'door': doorname,#输入点，包含门名称或者辅助输入点
'device': alias,#设备名称
'event_point': event_point,#输入点，包含门名称或者辅助输入点
'door_id': door_id,#doorid
'event_type': int(str[3]),
'content': event_content,
'state': unicode(dict(STATE_CHOICES)[int(str[4])]),#0出，1入
'verified': verified,
'emp': empname,#用户名(包含用户编号)
'photo': photo,#有人员照片的要显示,如/file/photo/000000121.jpg 空代表无照片（或无此人）
'link_video': link_video,
}
cdatas.append(cdata)
else:
print "DATA ERROR"
cc={
'log_id': logid,
'all_id': rtid_all,#无效
'alarm_id': rtid_alarm,
'log_count': log_count,#返回的有效的记录条数，用于改变logid
'data':cdatas,
'door_states':door_states["data"],#门状态数据
}
#print "**########**cc=",cc
rtdata = simplejson.dumps(cc)
return HttpResponse(smart_str(rtdata))