def saveCheckForget(request):
from mysite.iclock.models.model_trans import Transaction
from mysite.att.models.checkexact_model import CheckExact
l=[]
userids=request.POST.get('UserIDs')
deptids=request.POST.get('deptIDs')
sdate=request.POST.get('checkdate')+' '+request.POST.get('checktime')
st=datetime.datetime.strptime(sdate,'%Y-%m-%d %H:%M:%S')
nt=st.strftime('%Y-%m-%d %H:%M:%S')
ct=ATTSTATES[int(request.POST.get('checktype'))][0]
reson=request.POST.get('reson')
first_name=request.user.first_name
#if not allowAction(st,3):
# return getJSResponse("result=1;message=%s"%(_('Save Fail,account has been locked!')))
if len(userids)>0 and userids!='null':
uids=userids.split(',')
elif len(deptids)>0:
deptIDS=deptids.split(',')
uids=Employee.objects.filter(DeptID__in=deptIDS ).values_list('id', flat=True).order_by('id')
if not first_name:
first_name=request.user
time=datetime.datetime.now()
time=datetime.datetime.strftime(time,'%Y-%m-%d %H:%M:%S')
try:
for i in uids:
if settings.DATABASE_ENGINE == 'oracle':
sql_log="""insert into %s (UserID, CHECKTIME, CHECKTYPE, YUYIN,MODIFYBY,"DATE") values('%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'), '%s', '%s', '%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'))""" % (CheckExact._meta.db_table, int(i), nt,ct, reson, first_name,time)
sql="""insert into %s (userid, checktime, checktype,verifycode) values('%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'), '%s',5)""" % (Transaction._meta.db_table, int(i), nt, ct)
# print sql_log,sql
else:
sql_log="""insert into %s (UserID, CHECKTIME, CHECKTYPE, YUYIN,MODIFYBY,DATE) values('%s', '%s', '%s', '%s', '%s', '%s')""" % (CheckExact._meta.db_table, int(i), nt,ct, reson, first_name,time)
sql="""insert into %s (userid, checktime, checktype,verifycode) values('%s', '%s', '%s',5)""" % (Transaction._meta.db_table, int(i), nt, ct)
ret=customSql(sql)
if ret!=None:
deleteCalcLog(UserID=i)
ret=customSql(sql_log)
else:
break
#adminLog(time=datetime.datetime.now(),User=request.user, model=u"%s"%Transaction._meta.verbose_name,action=_("Add"),object=request.META["REMOTE_ADDR"]).save()
if ret!=None:
return HttpResponse("result=0")
else:
return HttpResponse("result=1;message=%s"%(_(u'保存失败，考勤记录可能重复了')))
except:
import traceback;traceback.print_exc()
def savespecialday(request):
if request.method == "POST":
id = request.POST.get('id', '')
userids = request.POST.get('UserID', '')
if id == "_new_":
userids = userids.split(',')
st = request.POST.get('StartSpecDay', '')
et = request.POST.get('EndSpecDay', '')
at = request.POST.get('ApplyDate', '')
reson = request.POST.get('YUANYING', '')
dateid = request.POST.get('DateID', '')
clearance = request.POST.get('clearance', '')
st = datetime.datetime.strptime(st, "%Y-%m-%d %H:%M:%S")
et = datetime.datetime.strptime(et, "%Y-%m-%d %H:%M:%S")
if not allowAction(st, 2, et):
return getJSResponse("result=1;message=%s" % (_(u'账户已经被锁定！')))
try:
if id == "_new_":
for i in userids:
if settings.DATABASE_ENGINE == 'oracle':
sql = """insert into %s (UserID, StartSpecDay, EndSpecDay, YUANYING,"DATE",DateID,clearance,State) values('%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'), to_date('%s','YYYY-MM-DD HH24:MI:SS'), '%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'),'%s','%s','0')""" % (
USER_SPEDAY._meta.db_table, int(i), st, et, reson,
at, dateid, clearance)
else:
sql = """insert into %s (UserID, StartSpecDay, EndSpecDay, YUANYING,Date,DateID,clearance,State) values('%s', '%s', '%s', '%s','%s','%s','%s','0')""" % (
USER_SPEDAY._meta.db_table, int(i), st, et, reson,
at, dateid, clearance)
customSql(sql)
deleteCalcLog(UserID=i)
else:
if settings.DATABASE_ENGINE == 'oracle':
sql = """update %s set StartSpecDay=to_date('%s','YYYY-MM-DD HH24:MI:SS'),EndSpecDay=to_date('%s','YYYY-MM-DD HH24:MI:SS'),YUANYING='%s',"DATE"=to_date('%s','YYYY-MM-DD HH24:MI:SS'),DateID='%s',clearance='%s' where id=%s""" % (
USER_SPEDAY._meta.db_table, st, et, reson, at, dateid,
clearance, id)
else:
sql = "update %s set StartSpecDay='%s',EndSpecDay='%s',YUANYING='%s',Date='%s',DateID='%s',clearance='%s' where id=%s" % (
USER_SPEDAY._meta.db_table, st, et, reson, at, dateid,
clearance, id)
customSql(sql)
deleteCalcLog(UserID=id)
except:
return getJSResponse(u"result=1;message=%s" % (_(u'非法异常')))
return getJSResponse("result=0")
def savespecialday(request):
if request.method=="POST":
id=request.POST.get('id','')
userids=request.POST.get('UserID','')
if id=="_new_":
userids=userids.split(',')
st=request.POST.get('StartSpecDay','')
et=request.POST.get('EndSpecDay','')
at=request.POST.get('ApplyDate','')
reson=request.POST.get('YUANYING','')
dateid=request.POST.get('DateID','')
clearance=request.POST.get('clearance','')
st=datetime.datetime.strptime(st,"%Y-%m-%d %H:%M:%S")
et=datetime.datetime.strptime(et,"%Y-%m-%d %H:%M:%S")
if not allowAction(st,2,et):
return getJSResponse("result=1;message=%s"%(_(u'账户已经被锁定！')))
try:
if id=="_new_":
for i in userids:
if settings.DATABASE_ENGINE == 'oracle':
sql="""insert into %s (UserID, StartSpecDay, EndSpecDay, YUANYING,"DATE",DateID,clearance,State) values('%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'), to_date('%s','YYYY-MM-DD HH24:MI:SS'), '%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'),'%s','%s','0')""" % (USER_SPEDAY._meta.db_table, int(i),st,et,reson, at,dateid,clearance)
else:
sql="""insert into %s (UserID, StartSpecDay, EndSpecDay, YUANYING,Date,DateID,clearance,State) values('%s', '%s', '%s', '%s','%s','%s','%s','0')""" % (USER_SPEDAY._meta.db_table, int(i), st, et,reson, at,dateid,clearance)
customSql(sql)
deleteCalcLog(UserID=i)
else:
if settings.DATABASE_ENGINE == 'oracle':
sql="""update %s set StartSpecDay=to_date('%s','YYYY-MM-DD HH24:MI:SS'),EndSpecDay=to_date('%s','YYYY-MM-DD HH24:MI:SS'),YUANYING='%s',"DATE"=to_date('%s','YYYY-MM-DD HH24:MI:SS'),DateID='%s',clearance='%s' where id=%s"""%(USER_SPEDAY._meta.db_table,st,et,reson,at,dateid,clearance,id)
else:
sql="update %s set StartSpecDay='%s',EndSpecDay='%s',YUANYING='%s',Date='%s',DateID='%s',clearance='%s' where id=%s"%(USER_SPEDAY._meta.db_table,st,et,reson,at,dateid,clearance,id)
customSql(sql)
deleteCalcLog(UserID=id)
except:
return getJSResponse(u"result=1;message=%s"%(_(u'非法异常')))
return getJSResponse("result=0")
def saveCheckForget(request):
from mysite.iclock.models.model_trans import Transaction
from mysite.att.models.checkexact_model import CheckExact
l = []
userids = request.POST.get('UserIDs')
deptids = request.POST.get('deptIDs')
sdate = request.POST.get('checkdate') + ' ' + request.POST.get('checktime')
st = datetime.datetime.strptime(sdate, '%Y-%m-%d %H:%M:%S')
nt = st.strftime('%Y-%m-%d %H:%M:%S')
ct = ATTSTATES[int(request.POST.get('checktype'))][0]
reson = request.POST.get('reson')
first_name = request.user.first_name
#if not allowAction(st,3):
# return getJSResponse("result=1;message=%s"%(_('Save Fail,account has been locked!')))
if len(userids) > 0 and userids != 'null':
uids = userids.split(',')
elif len(deptids) > 0:
deptIDS = deptids.split(',')
uids = Employee.objects.filter(DeptID__in=deptIDS).values_list(
'id', flat=True).order_by('id')
if not first_name:
first_name = request.user
time = datetime.datetime.now()
time = datetime.datetime.strftime(time, '%Y-%m-%d %H:%M:%S')
try:
for i in uids:
if settings.DATABASE_ENGINE == 'oracle':
sql_log = """insert into %s (UserID, CHECKTIME, CHECKTYPE, YUYIN,MODIFYBY,"DATE") values('%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'), '%s', '%s', '%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'))""" % (
CheckExact._meta.db_table, int(i), nt, ct, reson,
first_name, time)
sql = """insert into %s (userid, checktime, checktype,verifycode) values('%s', to_date('%s','YYYY-MM-DD HH24:MI:SS'), '%s',5)""" % (
Transaction._meta.db_table, int(i), nt, ct)
# print sql_log,sql
else:
sql_log = """insert into %s (UserID, CHECKTIME, CHECKTYPE, YUYIN,MODIFYBY,DATE) values('%s', '%s', '%s', '%s', '%s', '%s')""" % (
CheckExact._meta.db_table, int(i), nt, ct, reson,
first_name, time)
sql = """insert into %s (userid, checktime, checktype,verifycode) values('%s', '%s', '%s',5)""" % (
Transaction._meta.db_table, int(i), nt, ct)
ret = customSql(sql)
if ret != None:
deleteCalcLog(UserID=i)
ret = customSql(sql_log)
else:
break
#adminLog(time=datetime.datetime.now(),User=request.user, model=u"%s"%Transaction._meta.verbose_name,action=_("Add"),object=request.META["REMOTE_ADDR"]).save()
if ret != None:
return HttpResponse("result=0")
else:
return HttpResponse("result=1;message=%s" % (_(u'保存失败，考勤记录可能重复了')))
except:
import traceback
traceback.print_exc()
