Esempio n. 1
0
def getreq(request):
    '''
    http://xxx/getrequest
    设备读取服务器上存储的命令------------------------------------------------------------------
    '''
    from device_http.network import network_monitor
    network_monitor(request)
    response = device_response()
    try:
        resp = ""  #---要直接发送的内容
        device = check_device(request)  #---从请求得到设备对象  不自动注册
        if device is None:
            response.write("UNKNOWN DEVICE")
            return response
        #读取服务器上存储的命令的请求都带有设备INFO信息  更新设备信息
        info = request.GET.get("INFO", "")  #版本号,用户数,指纹数,记录数,设备自身IP地址
        if info:
            sql = []
            info = info.split(",")
            device.fw_version = info[0]  #---主版本号
            device.user_count = int(info[1])  #---注册用户数
            device.fp_count = int(info[2])  #---注册指纹数
            device.fp_count = int(info[2])
            device.transaction_count = int(info[3])  #---考勤记录数
            if len(info) > 4:
                device.ipaddress = info[4]  #---考勤机IP地址
                if device.alias == "auto_add":
                    device.alias = info[4]  #由于网关问题,使名称对应的IP地址与机器IP不同时的更正。
            if len(info) > 5:
                device.Fpversion = info[5]  #指纹算法版本
            device.save()

        # 自动升级固件功能
        if not hasattr(device, "is_updating_fw"):  #该设备现在没有正升级固件
            fw = fwVerStd(device.fw_version)
            if fw:  #该设备具有固件版本号
                up_version = device.get_std_fw_version()  #用于升级的设备固件标准版本号
                if up_version > fw:  #该设备固件版本号较低
                    n = int(q_server.get_from_file("UPGRADE_FW_COUNT") or "0")
                    if n < settings.MAX_UPDATE_COUNT:  #没有超出许可同时升级固件的范围
                        #升级固件
                        errMsg = dev_update_firmware(device)
                        if not errMsg:
                            device.is_updating_fw = device.last_activity
                        if errMsg:  #升级命令错
                            appendFile((u"%s UPGRADE FW %s:%s" %
                                        (device.sn, fw, errMsg)))
                        else:
                            q_server.incr("UPGRADE_FW_COUNT")
        upsql = []
        c = 0

        const_sql = "update devcmds set CmdTransTime='%(tr)s',CmdReturn=%(cm)s where id=%(id)s"
        if db_select == 4:  #postgresql 数据库
            const_sql = '''update devcmds set "CmdTransTime"='%(tr)s',"CmdReturn"=%(cm)s where id=%(id)s'''
        elif db_select == 3:  #oracle 数据库
            const_sql = "update devcmds set CmdTransTime=to_date('%(tr)s','yyyy-mm-dd hh24:mi:ss'),CmdReturn=%(cm)s where id=%(id)s"

        maxRet = device.max_comm_count  #---每次传送给设备的命令数
        maxRetSize = device.max_comm_size * 1024  #---最大数据包长度(KB)
        get_sql = "select top " + str(
            maxRet) + " id,CmdContent,CmdReturn from devcmds "
        get_sql += " where SN_id=" + str(
            device.pk
        ) + " and (CmdTransTime is null or (CmdReturn <=-99996 and CmdReturn>-99999)) order by id "

        if db_select == 1:
            get_sql = "select id,CmdContent,CmdReturn from devcmds "
            get_sql += " where SN_id=" + str(
                device.pk
            ) + " and (CmdTransTime is null or (CmdReturn <=-99996 and CmdReturn>-99999)) order by id limit " + str(
                maxRet)
        elif db_select == 4:
            get_sql = '''select id,"CmdContent","CmdReturn" from devcmds '''
            get_sql += ''' where "SN_id"=''' + str(
                device.pk
            ) + ''' and ("CmdTransTime" is null or ("CmdReturn" <=-99996 and "CmdReturn">-99999) ) order by id limit ''' + str(
                maxRet)

        elif db_select == 3:
            get_sql = "select id,CmdContent,CmdReturn from devcmds "
            get_sql += " where SN_id=" + str(
                device.pk
            ) + " and (CmdTransTime is null or CmdReturn <=-99996 and CmdReturn>-99999)) and ROWNUM <= " + str(
                maxRet) + " ORDER BY ROWNUM ASC  "

        dev_cur = conn.cursor()
        dev_cur.execute(get_sql)
        devcmds = dev_cur.fetchall()
        connection._commit()
        for d in devcmds:  #---循环要发送给设备的命令
            cr = d[2]  #---命令返回值
            if cr:
                cr += -1
            else:
                cr = -99996
            if cr < -99999:
                continue
            if db_select == 3:
                CmdContent = d[1].read()
            else:
                CmdContent = d[1]
            if CmdContent.find("DATA UPDATE user") == 0 or CmdContent.find(
                    "SMS ") == 0:  #传送用户命令,需要解码成GB2312
                cc = CmdContent
                try:
                    cc = cc.encode("gb18030")
                except:
                    try:
                        cc = cc.decode("utf-8").encode("gb18030")
                    except:
                        errorLog(request)
            else:
                cc = str(CmdContent)
            nowcmd = str(cc)
            cc = std_cmd_convert(cc, device)  #----ZK-ECO 标准命令到 PUSH-SDK 命令的转换
            if cc: resp += "C:%d:%s\n" % (d[0], cc)  #---格式: C:设备序列号:内容 \n

            c = c + 1
            if db_select == 1:
                excsql("update devcmds set CmdTransTime= now() ,CmdReturn=" +
                       str(cr) + " where id=" + str(d[0]))
            elif db_select == 3:
                excsql(
                    const_sql % {
                        "tr":
                        datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
                        "cm": cr,
                        "id": d[0]
                    })
            else:
                upsql.append(
                    const_sql % {
                        "tr":
                        datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
                        "cm": cr,
                        "id": d[0]
                    })
            if (c >= maxRet) or (len(resp) >= maxRetSize):
                break
                #达到了最大命令数或最大命令长度限制
            if CmdContent in ["CHECK", "CLEAR DATA", "REBOOT", "RESTART"]:
                break
                #重新启动命令只能是最后一条指令  #增加查找到CHECK指令后,直接发送
        if upsql:
            excsql(";".join(upsql))
        if db_select == 1:
            excsql("update iclock set last_activity=now() where id=" +
                   str(device.pk))
        elif db_select == 3:
            excsql("update iclock set last_activity=to_date('" +
                   datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") +
                   "','yyyy-mm-dd hh24:mi:ss') where id=" + str(device.pk))
        else:
            excsql("update iclock set last_activity='" +
                   datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") +
                   "' where id=" + str(device.pk))
        if c == 0:  #没有发送任何命令时,简单向设备返回 "OK" 即可
            resp += "OK"
    except Exception, e:
        resp = u"%s" % e
        errorLog(request)
Esempio n. 2
0
def getreq(request):
    '''
    http://xxx/getrequest
    设备读取服务器上存储的命令------------------------------------------------------------------
    '''
    from device_http.network import network_monitor
    network_monitor(request)
    response = device_response()
    try:
        resp = "" #---要直接发送的内容
        device = check_device(request)  #---从请求得到设备对象  不自动注册
        if device is None: 
            response.write("UNKNOWN DEVICE")
            return response
        #读取服务器上存储的命令的请求都带有设备INFO信息  更新设备信息
        info = request.GET.get("INFO", "") #版本号,用户数,指纹数,记录数,设备自身IP地址
        if info:
            sql=[]
            info = info.split(",")
            device.fw_version=info[0]   #---主版本号
            device.user_count=int(info[1])  #---注册用户数
            device.fp_count=int(info[2])    #---注册指纹数
            device.fp_count=int(info[2])
            device.transaction_count=int(info[3])   #---考勤记录数
            if len(info)>4:
                device.ipaddress=info[4]    #---考勤机IP地址
                if device.alias=="auto_add":
                    device.alias=info[4]#由于网关问题,使名称对应的IP地址与机器IP不同时的更正。
            if len(info)>5:             
                device.Fpversion=info[5]   #指纹算法版本
            device.save()
            
        # 自动升级固件功能
        if not hasattr(device, "is_updating_fw"): #该设备现在没有正升级固件
            fw = fwVerStd(device.fw_version) 
            if fw: #该设备具有固件版本号
                up_version=device.get_std_fw_version() #用于升级的设备固件标准版本号
                if up_version>fw:   #该设备固件版本号较低
                    n=int(q_server.get_from_file("UPGRADE_FW_COUNT") or "0")
                    if n < settings.MAX_UPDATE_COUNT: #没有超出许可同时升级固件的范围
                        #升级固件
                        errMsg = dev_update_firmware(device)
                        if not errMsg: 
                            device.is_updating_fw=device.last_activity
                        if errMsg: #升级命令错
                            appendFile((u"%s UPGRADE FW %s:%s" % (device.sn, fw, errMsg)))
                        else:
                            q_server.incr("UPGRADE_FW_COUNT")
        upsql=[]
        c=0
        
        const_sql="update devcmds set CmdTransTime='%(tr)s',CmdReturn=%(cm)s where id=%(id)s"
        if db_select==4:#postgresql 数据库
            const_sql ='''update devcmds set "CmdTransTime"='%(tr)s',"CmdReturn"=%(cm)s where id=%(id)s'''
        elif db_select==3:#oracle 数据库
            const_sql="update devcmds set CmdTransTime=to_date('%(tr)s','yyyy-mm-dd hh24:mi:ss'),CmdReturn=%(cm)s where id=%(id)s"
      
        maxRet = device.max_comm_count  #---每次传送给设备的命令数
        maxRetSize = device.max_comm_size * 1024    #---最大数据包长度(KB)
        get_sql="select top "+ str(maxRet) +" id,CmdContent,CmdReturn from devcmds "
        get_sql+=" where SN_id="+str(device.pk)+" and (CmdTransTime is null or (CmdReturn <=-99996 and CmdReturn>-99999)) order by id "   

        if db_select==1:
            get_sql="select id,CmdContent,CmdReturn from devcmds "
            get_sql+=" where SN_id="+str(device.pk)+" and (CmdTransTime is null or (CmdReturn <=-99996 and CmdReturn>-99999)) order by id limit "+str(maxRet) 
        elif db_select==4:
            get_sql ='''select id,"CmdContent","CmdReturn" from devcmds '''
            get_sql+=''' where "SN_id"='''+str(device.pk)+''' and ("CmdTransTime" is null or ("CmdReturn" <=-99996 and "CmdReturn">-99999) ) order by id limit '''+str(maxRet) 
           
        elif db_select==3:
            get_sql="select id,CmdContent,CmdReturn from devcmds "
            get_sql+=" where SN_id="+str(device.pk)+" and (CmdTransTime is null or CmdReturn <=-99996 and CmdReturn>-99999)) and ROWNUM <= "+str(maxRet)+" ORDER BY ROWNUM ASC  " 
             
        dev_cur=conn.cursor()
        dev_cur.execute(get_sql)
        devcmds=dev_cur.fetchall()
        connection._commit()
        for d in devcmds:   #---循环要发送给设备的命令
            cr=d[2] #---命令返回值
            if cr:
                cr+=-1
            else:
                cr=-99996
            if cr<-99999:
                continue
            if db_select==3:
                CmdContent=d[1].read()
            else:
                CmdContent=d[1]
            if CmdContent.find("DATA UPDATE user")==0 or CmdContent.find("SMS ")==0: #传送用户命令,需要解码成GB2312
                cc=CmdContent
                try:
                    cc=cc.encode("gb18030")
                except:
                    try:
                        cc=cc.decode("utf-8").encode("gb18030")
                    except:
                        errorLog(request)
            else:                    
                cc=str(CmdContent)
            nowcmd=str(cc)
            cc=std_cmd_convert(cc, device)  #----ZK-ECO 标准命令到 PUSH-SDK 命令的转换
            if cc: resp+="C:%d:%s\n"%(d[0],cc)  #---格式: C:设备序列号:内容 \n

            c=c+1
            if db_select==1:
                excsql("update devcmds set CmdTransTime= now() ,CmdReturn="+str(cr)+" where id="+str(d[0]))
            elif db_select==3:
                excsql(const_sql%{"tr":datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"),"cm":cr,"id":d[0]})
            else: 
                upsql.append(const_sql%{"tr":datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"),"cm":cr,"id":d[0]})
            if (c>=maxRet) or (len(resp)>=maxRetSize): break;     #达到了最大命令数或最大命令长度限制
            if CmdContent in ["CHECK","CLEAR DATA","REBOOT", "RESTART"]: break; #重新启动命令只能是最后一条指令  #增加查找到CHECK指令后,直接发送
        if upsql:    
            excsql(";".join(upsql))
        if db_select==1:
            excsql("update iclock set last_activity=now() where id="+str(device.pk))
        elif db_select==3:
            excsql("update iclock set last_activity=to_date('"+datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")+"','yyyy-mm-dd hh24:mi:ss') where id="+str(device.pk))
        else:
            excsql("update iclock set last_activity='"+datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")+"' where id="+str(device.pk))
        if c == 0:#没有发送任何命令时,简单向设备返回 "OK" 即可
            resp += "OK"
    except  Exception, e:
        resp = u"%s" % e
        errorLog(request)
Esempio n. 3
0
logger.addHandler(hdlr)
logger.setLevel(logging.NOTSET)
''' 得到当前系统数据库类型 '''
from base.django_utils import get_db_type
db_select = get_db_type()

from model_utils import get_employee
from commen_utils import normal_state, normal_verify, card_to_num, excsql, device_response

server_time_delta = datetime.datetime.now() - datetime.datetime.utcnow()

from conv_att import line_to_log
from conv_device import line_to_oplog

from mysite.utils import fwVerStd
up_version = fwVerStd(settings.UPGRADE_FWVERSION)

from conv_device import update_device_sql, get_device, check_device, sync_dev, check_sync_devs, check_and_save_cache, cdata_get_options, parse_dev_info
from conv_emp import cdata_get_pin


def write_data(raw_data, device=None, Op=None):
    '''
    解析暂存的设备命令
    将设备发送的数据解析保存到数据库
    '''
    import UrlParas
    head_data, raw_data = raw_data.split("\n", 1)
    stamp_name, head = head_data.split(": ")
    stamp_name = stamp_name[1:]
    head = dict([item.split("=", 1) for item in head.split("\t")])
Esempio n. 4
0
logger.setLevel(logging.NOTSET)

''' 得到当前系统数据库类型 '''
from base.django_utils import get_db_type
db_select = get_db_type()

from model_utils import get_employee
from commen_utils import normal_state, normal_verify, card_to_num, excsql, device_response

server_time_delta = datetime.datetime.now()-datetime.datetime.utcnow()

from conv_att import line_to_log
from conv_device import line_to_oplog

from mysite.utils import fwVerStd
up_version = fwVerStd(settings.UPGRADE_FWVERSION)

from conv_device import update_device_sql,get_device,check_device,sync_dev,check_sync_devs,check_and_save_cache,cdata_get_options, parse_dev_info
from conv_emp import cdata_get_pin

def write_data(raw_data, device=None,Op=None):
    '''
    解析暂存的设备命令
    将设备发送的数据解析保存到数据库
    '''
    import UrlParas
    head_data, raw_data=raw_data.split("\n",1)
    stamp_name, head=head_data.split(": ")
    stamp_name=stamp_name[1:]
    head=dict([item.split("=",1) for item in head.split("\t")])
    if device is None: