Python版中控系统考勤管理

#coding:utf-8
 
import win32com.client
import sys
import smtplib
import urllib
import os
import string
import chardet
import openpyxl
import time
from datetime import datetime
from collections import Counter

 

zk = win32com.client.Dispatch('zkemkeeper.ZKEM.1')
if not zk.Connect_Net('172.10.14.224', 4370):
    print ("Connect Error")
    sys.exit(1)
 
zk.SSR_GetAllUserInfo(1)
uid = {}
while 1:
    machenum, EnrollNumber, username, other, privilege, dwEnable = zk.SSR_GetAllUserInfo(1)
    if not machenum:
        break
    else:
        if dwEnable:
            uid[EnrollNumber] = str(username.split(u'\x00')[0].encode('gbk'), encoding = "gbk")

 

#wb=openpyxl.Workbook(optimized_write=True)
#ws=wb.create_sheet()
#for key,value in sorted(uid.items()):
#  ws.append([int(key),value])
#wb.save(filename='D:\data.xlsx')
#for key,value in sorted(uid.items()):
#    print (key,value)

 

checkin = {}
last_month = time.localtime()[1]-1 or 12
if last_month == 12:
    cur_year = time.localtime()[0]-1
else:
    cur_year = time.localtime()[0]
 
if zk.ReadAllGLogData(1):  #read All checkin data
    while 1:
        dwMachineNumber, dwEnrollNumber, dwVerifyMode, dwInOutMode, dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond, dwWorkcode = zk.SSR_GetGeneralLogData(1)
        if not dwMachineNumber:
            break
        if cur_year == dwYear and 12 == dwMonth:
            if dwEnrollNumber not in checkin:
                checkin[dwEnrollNumber] = {}
            if dwDay in checkin[dwEnrollNumber]:
                checkin[dwEnrollNumber][dwDay].append(str(dwHour)+':'+str(dwMinute))
            else:
                checkin[dwEnrollNumber][dwDay] = [str(dwHour)+':'+str(dwMinute)]
    
zk.Disconnect()

 

xk = win32com.client.Dispatch('zkemkeeper.ZKEM.1')
if not xk.Connect_Net('172.10.14.237', 4370):
    print ("Connect Error")
    sys.exit(1)
 
xk.SSR_GetAllUserInfo(1)
xid = {}
while 1:
    machenum, EnrollNumber, username, other, privilege, dwEnable = xk.SSR_GetAllUserInfo(1)
    if not machenum:
        break
    else:
        if dwEnable:
            xid[EnrollNumber] = str(username.split(u'\x00')[0].encode('gbk'), encoding = "gbk")

 

#wb=openpyxl.Workbook(optimized_write=True)
#ws=wb.create_sheet()
#for key,value in sorted(uid.items()):
#  ws.append([int(key),value])
#wb.save(filename='D:\data.xlsx')
#for key,value in sorted(uid.items()):
#    print (key,value)

 

xheckin = {}
last_month = time.localtime()[1]-1 or 12
if last_month == 12:
    cur_year = time.localtime()[0]-1
else:
    cur_year = time.localtime()[0]
 
if xk.ReadAllGLogData(1):  #read All checkin data
    while 1:
        dwMachineNumber, dwEnrollNumber, dwVerifyMode, dwInOutMode, dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond, dwWorkcode = xk.SSR_GetGeneralLogData(1)
        if not dwMachineNumber:
            break
        if cur_year == dwYear and 12 == dwMonth:
            if dwEnrollNumber not in xheckin:
                xheckin[dwEnrollNumber] = {}
            if dwDay in xheckin[dwEnrollNumber]:
                xheckin[dwEnrollNumber][dwDay].append(str(dwHour)+':'+str(dwMinute))
            else:
                xheckin[dwEnrollNumber][dwDay] = [str(dwHour)+':'+str(dwMinute)]

 xk.Disconnect()

 

def user(d1, d2): 
    u = dict(d1) 
    u.update(d2) 
    return u
 
def check(d1, d2): 
    c = dict(d1) 
    c.update(d2) 
    return c

 

finaluser=user(uid,xid)
finalcheck=check(checkin,xheckin)
finaluser['54']='54'
fid = open("d:\log.xls", "a")

 

for i in sorted(finalcheck.keys()):   
    for key,value in sorted(finalcheck[i].items()):
        print(finaluser[i],key,value)
        if datetime.strptime(str(value[0]), '%H:%M') >datetime.strptime('14:00', '%H:%M'):
            print(str(finaluser[i])+' ','12月'+str(key)+'日'+' ','未打卡'+' ',str(value[len(value)-1]), file=fid)
        if datetime.strptime(str(value[len(value)-1]), '%H:%M') <datetime.strptime('14:00', '%H:%M'):
            print(str(finaluser[i])+' ','12月'+str(key)+'日'+' ',str(value[0])+' ','未打卡', file=fid)
        if datetime.strptime(str(value[len(value)-1]), '%H:%M') >datetime.strptime('14:00', '%H:%M') and datetime.strptime(str(value[0]), '%H:%M') <datetime.strptime('14:00', '%H:%M'):
            print(str(finaluser[i])+' ','12月'+str(key)+'日'+' ',str(value[0])+' ',str(value[len(value)-1]), file=fid)