def cardtimes_report(request):
'''
打卡详情表
'''
deptids = request.POST.get('DeptIDs', '')
userids = request.POST.get('UserIDs', '')
st = request.POST.get('ComeTime', '')
et = request.POST.get('EndTime', '')
st = datetime.datetime.strptime(st, '%Y-%m-%d')
et = datetime.datetime.strptime(et, '%Y-%m-%d')
et = et + datetime.timedelta(seconds=86399)
r = cardtime_calculate(request, deptids, userids, st, et)
loadall = request.REQUEST.get('pa', '')
if not loadall:
objdata = {}
allr = cardtime_calculate(request, deptids, userids, st, et, True)
objdata['data'] = allr['datas']
objdata['fields'] = allr['fieldnames']
heads = {}
for i in range(len(allr['fieldnames'])):
heads[allr['fieldnames'][i]] = allr['fieldcaptions'][i]
objdata['heads'] = heads
tmp_name = save_datalist(objdata)
r['tmp_name'] = tmp_name #用于导出 没有这个字段导出报错。
return getJSResponse(smart_str(dumps(r)))
def dailycalcReport(request):
deptIDs = request.POST.get('DeptIDs', "")
userIDs = request.POST.get('UserIDs', "")
st = request.POST.get('ComeTime', '')
et = request.POST.get('EndTime', '')
st = datetime.datetime.strptime(st, '%Y-%m-%d')
et = datetime.datetime.strptime(et, '%Y-%m-%d')
#修改 郭学文 2010-05-17
# et=et+datetime.timedelta(days=-1)
# print "-------------------",st,et,deptIDs,userIDs
# st=datetime.datetime(2008,5,1)
# et=datetime.datetime(2008,5,30)
r = CalcReportItem(request, deptIDs, userIDs, st, et, 1)
# print "11111111111111111111111"
loadall = request.REQUEST.get('pa', '')
if not loadall:
allr = CalcReportItem(request, deptIDs, userIDs, st, et, 1, True)
objdata = {}
objdata['data'] = allr['datas']
objdata['fields'] = allr['fieldnames']
heads = {}
for i in range(len(allr['fieldnames'])):
heads[allr['fieldnames'][i]] = allr['fieldcaptions'][i]
objdata['heads'] = heads
tmp_name = save_datalist(objdata)
r['tmp_name'] = tmp_name
# print "allr['fieldnames']:%s"%r['fieldnames']
return getJSResponse(smart_str(dumps(r)))
def le_reprot(request):
'''
汇总最早与最晚计算报表
'''
deptids = request.POST.get('DeptIDs', '')
userids = request.POST.get('UserIDs', '')
st = request.POST.get('ComeTime', '')
et = request.POST.get('EndTime', '') + " 23:59:59"
st = datetime.datetime.strptime(st, '%Y-%m-%d')
et = datetime.datetime.strptime(et, '%Y-%m-%d %H:%M:%S')
r = le_reprot_calculate(request, deptids, userids, st, et)
loadall = request.REQUEST.get('pa', '')
if not loadall:
objdata = {}
allr = le_reprot_calculate(request, deptids, userids, st, et, True)
objdata['data'] = allr['datas']
objdata['fields'] = allr['fieldnames']
heads = {}
for i in range(len(allr['fieldnames'])):
heads[allr['fieldnames'][i]] = allr['fieldcaptions'][i]
objdata['heads'] = heads
tmp_name = save_datalist(objdata)
r['tmp_name'] = tmp_name #用于导出 没有这个字段导出报错。
return getJSResponse(smart_str(dumps(r)))
def calcLeaveReport(request):
deptIDs = request.POST.get('DeptIDs', "")
userIDs = request.POST.get('UserIDs', "")
st = request.POST.get('ComeTime', '')
et = request.POST.get('EndTime', '')
st = datetime.datetime.strptime(st, '%Y-%m-%d')
et = datetime.datetime.strptime(et, '%Y-%m-%d')
r = CalcLeaveReportItem(request, deptIDs, userIDs, st, et)
loadall = request.REQUEST.get('pa', '')
p_datas = r['datas']
if not loadall:
objdata = {}
allr = CalcLeaveReportItem(request, deptIDs, userIDs, st, et, 0, True)
objdata['data'] = allr['datas']
objdata['fields'] = allr['fieldnames']
heads = {}
for i in range(len(allr['fieldnames'])):
heads[allr['fieldnames'][i]] = allr['fieldcaptions'][i]
objdata['heads'] = heads
tmp_name = save_datalist(objdata)
r['tmp_name'] = tmp_name
r['datas'] = p_datas
return getJSResponse(smart_str(dumps(r)))
def GenerateEmpPunchCard(request):
from mysite.iclock.models.model_trans import Transaction
import datetime
cudt = datetime.datetime.now().strftime("%Y-%m-%d")
d1 = request.POST.get("starttime", cudt) + " 00:00:00"
d2 = request.POST.get("endtime", cudt) + " 23:59:59"
empids = request.POST.get("empids")
deptids = request.POST.get("deptids")
sql = """
select a.badgenumber,a.name,b.checktime
from userinfo a inner join checkinout b on a.userid = b.userid
where b.checktime>='%s' and b.checktime<='%s'
""" % (d1, d2)
if empids:
sql = sql + " and a.userid in (%s) " % (empids)
if deptids and not empids:
sql = sql + " and a.defaultdeptid in (%s) " % (deptids)
sql = sql + " order by a.badgenumber,b.checktime "
dts = []
d1_dt = datetime.datetime.strptime(request.POST.get("starttime", cudt),
"%Y-%m-%d")
d2_dt = datetime.datetime.strptime(request.POST.get("endtime", cudt),
"%Y-%m-%d")
diffdays = (d2_dt - d1_dt).days
i = 0
while i <= diffdays:
dts.append(d1_dt + datetime.timedelta(days=i))
i += 1
readybaseEmp = []
if empids:
requiredAtt = Employee.objects.filter(
isatt='1',
id__in=empids).order_by("PIN").values_list("PIN", "EName")
elif deptids:
requiredAtt = Employee.objects.filter(
isatt='1',
DeptID__in=deptids).order_by("PIN").values_list("PIN", "EName")
else:
requiredAtt = Employee.objects.filter(
isatt='1').order_by("PIN").values_list("PIN", "EName")
if not requiredAtt.count():
tmp_name = save_datalist({
"data": [],
"fields": fields,
"heads": header
})
return getJSResponse([[]])
else:
for i in requiredAtt:
for dt_temp in dts:
l = list(i)
l.append(dt_temp.strftime("%Y-%m-%d"))
readybaseEmp.append(l)
cs = connection.cursor()
cs.execute(sql)
data = cs.fetchall()
datas = []
for row in data:
datas.append(list(row))
for item in datas:
if item[2]:
item.append(item[2].strftime("%Y-%m-%d"))
item.append(item[2].strftime("%H:%M"))
item.remove(item[2])
i = 0
ii = len(datas)
for emp in readybaseEmp:
cc = filter(lambda x: x[0] == emp[0] and x[2] == emp[2], datas)
punchcarddetail = ",".join([i[3] for i in cc])
emp.append(punchcarddetail)
fields = ['badgenumber', 'name', 'checkdate', 'time']
header0 = [{
'badgenumber': _(u'人员编号')
}, {
'name': _(u'姓名')
}, {
'checkdate': _(u'打卡日期')
}, {
'time': _(u'打卡时间')
}]
header = {
'badgenumber': u'%s' % _(u'人员编号'),
'name': u'%s' % _(u'姓名'),
'checkdate': u'%s' % _(u'打卡日期'),
'time': u'%s' % _(u'打卡时间')
}
headers = "[" + ",".join([u"'%s'" % i.values()[0] for i in header0]) + "]"
r = {}
datatotmp = []
for row in readybaseEmp:
datatotmp.append({
'badgenumber': row[0],
'name': row[1],
'checkdate': row[2],
'time': row[3]
})
tmp_name = save_datalist({
"data": datatotmp,
"fields": fields,
"heads": header
})
if len(readybaseEmp) == 0: readybaseEmp.append([])
try:
offset = int(request.REQUEST.get(PAGE_VAR, 1))
except:
offset = 1
limit = int(request.REQUEST.get(PAGE_LIMIT_VAR, settings.PAGE_LIMIT))
mnp = request.REQUEST.get(MAX_NO_PAGE, 0)
if len(data) <= int(mnp):
limit = int(mnp)
paginator = Paginator(readybaseEmp, limit)
item_count = paginator.count
if offset > paginator.num_pages: offset = paginator.num_pages
if offset < 1: offset = 1
pgList = paginator.page(offset)
cc = {}
cc["page_count"] = paginator.num_pages
cc["record_count"] = item_count
cc["page_number"] = offset
cc["heads"] = headers
cc["data"] = pgList.object_list
cc["fields"] = fields
cc["tmp_name"] = tmp_name
return GenerateEmpPunchCardJsonData(request, cc)
def GenerateEmpCardList(request):
from mysite.personnel.models.model_issuecard import IssueCard
try:
depts = userDeptList(request.user)
if depts:
data = IssueCard.objects.filter(UserID__DeptID__in=userDeptList(
request.user)).order_by("UserID__PIN").values_list(
"UserID__PIN", "UserID__EName", "cardno", "issuedate",
"effectivenessdate", "cardstatus")
else:
data = IssueCard.objects.all().order_by("UserID__PIN").values_list(
"UserID__PIN", "UserID__EName", "cardno", "issuedate",
"effectivenessdate", "cardstatus")
header0 = [_(u'工号'), _(u'姓名'),
_(u'卡号'), _(u'发卡日期')] #,_(u'有效日期'),_(u'卡状态')
headers = "[" + ",".join([u"'%s'" % i for i in header0]) + "]"
fields = ['PIN', 'EName', 'cardno',
'issuedate'] #,'effectivenessdate','cardstatus'
header = {
'PIN': u'%s' % _(u'工号'),
'EName': u'%s' % _(u'姓名'),
'cardno': u'%s' % _(u'卡号'),
'issuedate': u'%s' % _(u'发卡日期')
}
# 'effectivenessdate':u'%s'%_(u'有效日期'),
# 'cardstatus':u'%s'%_(u'卡状态')}
r = {}
datatotmp = []
for row in data:
# r[fields[5]] = row[5]
# r[fields[4]] = row[4]
r[fields[3]] = row[3]
r[fields[2]] = row[2]
r[fields[1]] = row[1]
r[fields[0]] = row[0]
datatotmp.append(r.copy())
tmp_name = save_datalist({
"data": datatotmp,
"fields": fields,
"heads": header
})
try:
offset = int(request.REQUEST.get(PAGE_VAR, 1))
except:
offset = 1
if len(data) == 0:
data = []
data.append([])
limit = int(request.REQUEST.get(PAGE_LIMIT_VAR, settings.PAGE_LIMIT))
mnp = request.REQUEST.get(MAX_NO_PAGE, 0)
if len(data) <= int(mnp):
limit = int(mnp)
paginator = Paginator(data, limit)
item_count = paginator.count
if offset > paginator.num_pages: offset = paginator.num_pages
if offset < 1: offset = 1
pgList = paginator.page(offset)
cc = {}
cc["page_count"] = paginator.num_pages
cc["record_count"] = item_count
cc["page_number"] = offset
cc["heads"] = headers
cc["data"] = pgList.object_list
cc["fields"] = fields
cc["tmp_name"] = tmp_name
except:
import traceback
traceback.print_exc()
return GenerateEmpCardJsonData(request, cc)
def GenerateEmpEducation(request):
from mysite.personnel.sql import GenerateEmpEducation_sql
deptids = request.POST.get("deptids")
sql = GenerateEmpEducation_sql(request, deptids)
header0 = [
_(u'部门'),
_(u'小学'),
_(u'初中'),
_(u'普通高中'),
_(u'本科'),
_(u'硕士研究生'),
_(u'博士研究生')
]
headers = "[" + ",".join([u"'%s'" % i for i in header0]) + "]"
header = {
'DeptName': u'%s' % _(u'部门'),
'pupil': u'%s' % _(u'小学'),
'middle_studemt': u'%s' % _(u'初中'),
'high_studemt': u'%s' % _(u'普通高中'),
'university_studemt': u'%s' % _(u'本科'),
'graduate_studemt': u'%s' % _(u'硕士研究生'),
'doctor': u'%s' % _(u'博士研究生')
}
fields = [
'DeptName', 'pupil', 'middle_studemt', 'high_studemt',
'university_studemt', 'graduate_studemt', 'doctor'
]
cs = connection.cursor()
cs.execute(sql)
# data=[]
# while True:
# t=cs.fetchone()
# if t is None:
# break
# data.append(list(t))
data = cs.fetchall()
r = {}
datatotmp = []
for row in data:
r[fields[6]] = row[6]
r[fields[5]] = row[5]
r[fields[4]] = row[4]
r[fields[3]] = row[3]
r[fields[2]] = row[2]
r[fields[1]] = row[1]
r[fields[0]] = row[0]
datatotmp.append(r.copy())
tmp_name = save_datalist({
"data": datatotmp,
"fields": fields,
"heads": header
})
if len(data) == 0: data.append([])
try:
offset = int(request.REQUEST.get(PAGE_VAR, 1))
except:
offset = 1
limit = int(request.REQUEST.get(PAGE_LIMIT_VAR, settings.PAGE_LIMIT))
mnp = request.REQUEST.get(MAX_NO_PAGE, 0)
if len(data) <= int(mnp):
limit = int(mnp)
paginator = Paginator(data, limit)
item_count = paginator.count
if offset > paginator.num_pages: offset = paginator.num_pages
if offset < 1: offset = 1
pgList = paginator.page(offset)
cc = {}
cc["page_count"] = paginator.num_pages
cc["record_count"] = item_count
cc["page_number"] = offset
cc["heads"] = headers
cc["data"] = pgList.object_list
cc["fields"] = fields
cc["tmp_name"] = tmp_name
return GenerateEmpEducationJsonData(request, cc)
def GenerateEmpFlow(request):
cudt = datetime.datetime.now().strftime("%Y-%m-%d")
d1 = request.POST.get("starttime", cudt)
d2 = request.POST.get("endtime", cudt)
deptids = request.POST.get("deptids")
sql = GenerateEmpFlow_sql(request, deptids, d1, d2)
cs = connection.cursor()
cs.execute(sql)
header0 = [{
'DeptName': _(u'部门')
}, {
'newin': _(u'新进')
}, {
'transferin': _(u'调入')
}, {
'transferout': _(u'调出')
}, {
'selfleave': _(u'自离')
}, {
'passiveleave': _(u'辞退')
}, {
'normalleave': _(u'辞职')
}]
header = {
'DeptName': u'%s' % _(u'部门'),
'newin': u'%s' % _(u'新进'),
'transferin': u'%s' % _(u'调入'),
'transferout': u'%s' % _(u'调出'),
'selfleave': u'%s' % _(u'自离'),
'passiveleave': u'%s' % _(u'辞退'),
'normalleave': u'%s' % _(u'辞职')
}
headers = "[" + ",".join([u"'%s'" % i.values()[0] for i in header0]) + "]"
fields = [
'DeptName', 'newin', 'transferin', 'transferout', 'selfleave',
'passiveleave', 'normalleave'
]
cc = {}
data = cs.fetchall()
r = {}
datatotmp = []
for row in data:
r[fields[6]] = row[6]
r[fields[5]] = row[5]
r[fields[4]] = row[4]
r[fields[3]] = row[3]
r[fields[2]] = row[2]
r[fields[1]] = row[1]
r[fields[0]] = row[0]
datatotmp.append(r.copy())
tmp_name = save_datalist({
"data": datatotmp,
"fields": fields,
"heads": header
})
if len(data) == 0:
data = []
data.append([])
try:
offset = int(request.REQUEST.get(PAGE_VAR, 1))
except:
offset = 1
limit = int(request.REQUEST.get(PAGE_LIMIT_VAR, settings.PAGE_LIMIT))
mnp = request.REQUEST.get(MAX_NO_PAGE, 0)
if len(data) <= int(mnp):
limit = int(mnp)
paginator = Paginator(data, limit)
item_count = paginator.count
if offset > paginator.num_pages: offset = paginator.num_pages
if offset < 1: offset = 1
pgList = paginator.page(offset)
cc["page_count"] = paginator.num_pages
cc["record_count"] = item_count
cc["page_number"] = offset
cc["heads"] = headers
cc["data"] = pgList.object_list
cc["fields"] = fields
cc["tmp_name"] = tmp_name
return GenerateEmpFlowJsonData(request, cc)
def GenerateDeptRoster(request):
from mysite.personnel.sql import GenerateDeptRoster_sql
deptids = request.POST.get("deptids")
#emps =Employee.objects.filter(DeptID__in=deptids).order_by('DeptID','PIN').values_list('PIN','EName','DeptID__name','Title','Mobile','Birthday','birthplace','Education')
sql = GenerateDeptRoster_sql(request, deptids)
cs = connection.cursor()
cs.execute(sql)
header0 = [
_(u'工号'),
_(u'姓名'),
_(u'部门'),
_(u'职位'),
_(u'手机'),
_(u'年龄'),
_(u'籍贯'),
_(u'学历')
]
header = {
'PIN': u'%s' % _(u'工号'),
'EName': u'%s' % _(u'姓名'),
'Department': u'%s' % _(u'部门'),
'position': u'%s' % _(u'职位'),
'mobile': u'%s' % _(u'手机'),
'age': u'%s' % _(u'年龄'),
'native': u'%s' % _(u'籍贯'),
'education': u'%s' % _(u'学历')
}
headers = "[" + ",".join([u"'%s'" % i for i in header0]) + "]"
fields = [
'PIN', 'EName', 'Department', 'position', 'mobile', 'age', 'native',
'education'
]
cc = {}
data = cs.fetchall()
r = {}
datatotmp = []
cudt = datetime.datetime.now()
cudd = datetime.date(cudt.year, cudt.month, cudt.day)
for row in data:
r[fields[7]] = row[7]
r[fields[6]] = row[6]
if row[5]:
if settings.DATABASES["default"][
"ENGINE"] == "django.db.backends.oracle":
cudd = datetime.datetime(cudt.year, cudt.month, cudt.day)
r[fields[5]] = (cudd - row[5]).days / 365
else:
r[fields[5]] = row[5]
r[fields[4]] = row[4]
r[fields[3]] = row[3]
r[fields[2]] = row[2]
r[fields[1]] = row[1]
r[fields[0]] = row[0]
datatotmp.append(r.copy())
tmp_name = save_datalist({
"data": datatotmp,
"fields": fields,
"heads": header
})
try:
data_list = []
for item in data:
tmp = list(item)
if tmp[5]:
tmp[5] = (cudd - tmp[5]).days / 365
data_list.append(list(tmp))
if len(data_list) == 0:
data_list = []
data_list.append([])
try:
offset = int(request.REQUEST.get(PAGE_VAR, 1))
except:
offset = 1
limit = int(request.REQUEST.get(PAGE_LIMIT_VAR, settings.PAGE_LIMIT))
mnp = request.REQUEST.get(MAX_NO_PAGE, 0)
if len(data_list) <= int(mnp):
limit = int(mnp)
paginator = Paginator(data_list, limit)
item_count = paginator.count
if offset > paginator.num_pages: offset = paginator.num_pages
if offset < 1: offset = 1
pgList = paginator.page(offset)
cc = {}
cc["page_count"] = paginator.num_pages
cc["record_count"] = item_count
cc["page_number"] = offset
cc["heads"] = headers
cc["data"] = pgList.object_list
cc["fields"] = fields
cc["tmp_name"] = tmp_name
except:
import traceback
traceback.print_exc()
return GenerateEmpRosterJsonData(request, cc)