示例#1
0
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()
示例#2
0
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()
示例#3
0
 def check_password(self, raw_password, password):
     password = decrypt(password)
     if raw_password == password:
         return True
     else:
         return False
示例#4
0
文件: view.py 项目: SongJLG/johan-doc
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})))
示例#5
0
 def check_password(self, raw_password, password):
     password = decrypt(password)
     if raw_password == password: return True
     else: return False
示例#6
0
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))
示例#7
0
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))