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()