批量修改成绩
__LgZds5MVHW3o08T7UcX
16
2048
1536
notRollback
1618538131343
考试人员
0
415
84
142
34
system_exam_person
1618538208276
准考证
0
266
239
142
34
idCardNo
true
//判断表单某字段不能为空
(function(){
var idCardNo = getItemValueAsString(@quot;idCardNo@quot;);
var sql = @quot;select '@quot;+getDomainid()+@quot;' as domainid,@quot;+
@quot;a.ITEM_SECURITYID,@quot; + //保安员id
@quot;a.ITEM_IDCARDNO,@quot; + //身份证
@quot;a.ITEM_NAME,@quot; + //姓名
@quot;a.ITEM_COMPANY,@quot; + //所属公司
@quot;a.ITEM_MOBILE,@quot; + //手机号
@quot;a.ITEM_WRITTENSCORE,@quot; + //笔试成绩
@quot;a.ITEM_OPERATESCORE,@quot; + //实操成绩
@quot;a.ITEM_SUMSCORE,@quot; + //总成绩
@quot;a.ITEM_TESTSTATE,@quot; + //考试成绩状态
@quot;a.ITEM_NOTICESTATE,@quot; + //考试通知状态
@quot;a.ITEM_SCOREMSGSTATE,@quot; + //成绩通知状态
@quot;a.ITEM_CARDSTATE,@quot; + //制证状态
@quot;a.ITEM_APPLYID,@quot; + //报名id
@quot;a.ITEM_WRITTENSTATE,@quot; + //笔试状态
@quot;a.ITEM_WRITTENRECORD,@quot; + //笔试做题记录
@quot;a.ITEM_ISMAKEUP,@quot; + //是否补考
@quot;a.ITEM_SIGNIN,@quot; + //是否签到
@quot;a.ITEM_CONFIRMDATE,@quot; + //确认成绩的时间
@quot;a.ITEM_EXAMID,@quot; + //考试id
@quot;a.ID,@quot;+
@quot;a.ID as ITEM_ID@quot;+
@quot; from tlk_system_exam_person a where ITEM_IDCARDNO = '@quot;+idCardNo+@quot;' @quot;+
@quot; and CREATED = (select MAX(CREATED) from tlk_system_exam_person where ITEM_IDCARDNO = a.ITEM_IDCARDNO) @quot;;
var datas=findBySQL(sql);
if(isNotNull(datas)){
var SCOREMSGSTATE=datas.getItemValueAsString(@quot;SCOREMSGSTATE@quot;);
if(@quot;1@quot;.equals(SCOREMSGSTATE)){
return idCardNo + @quot; 已确认成绩,无法修改成绩！@quot;;
}
}
})()
1618538131343
1618538131343
false
false
520;150;520;150
1618538241753
1618538131343
1618538131343
false
false
518;99;518;99
1618538254002
1618538208276
1618538208276
false
false
398;239;398;239
1618538272556
1618538131343
1618538131343
false
false
547;77;547;77
1618538290704
1618538131343
1618538131343
false
false
581;136;581;136
1618538320011
1618538208276
1618538208276
false
false
398;239;398;239
1618538323900
1618538131343
1618538131343
false
false
572;83;572;83
1618538328330
1618538131343
1618538208276
false
false
398;239;572;83
1618538375791
1618538384559
理论成绩
0
391
250
142
34
writtenScore
false
1618538413494
体能成绩
0
499
251
142
34
operateScore
false
1618538131343
1618538384559
false
false
447;250;415;84
1618538434312
1618538131343
1618538413494
false
false
622;229;415;84
1618538438890
1618538470454
总成绩
0
648
243
142
34
sumScore
false
(function(){
var loginNo=getWebUser().getLoginno();
var userId = getUserIdByLoginno(loginNo);
var examId=getSession(userId + @quot;examId@quot;);
var writtenScore=getItemValueAsInt(@quot;writtenScore@quot;);
var operateScore=getItemValueAsInt(@quot;operateScore@quot;);
var examInfoDoc = findDocument(examId);
var isComputerExam = examInfoDoc.findItem(@quot;isComputerExam@quot;).getValue();
var isStamina = examInfoDoc.findItem(@quot;isStamina@quot;).getValue();
var examRules = examInfoDoc.findItem(@quot;examRules@quot;).getValue();
var writtenRatio = examInfoDoc.findItem(@quot;writtenRatio@quot;).getValue();
var operateRatio= examInfoDoc.findItem(@quot;operateRatio@quot;).getValue();
var examStandard= examInfoDoc.findItem(@quot;examStandard@quot;).getValue();
var writtenPassScore = examInfoDoc.findItem(@quot;writtenPassScore@quot;).getValue();
var operatePassScore= examInfoDoc.findItem(@quot;operatePassScore@quot;).getValue();
if(@quot;1@quot;.equals(isComputerExam) @amp;@amp; @quot;0@quot;.equals(isStamina) ){
return writtenScore;
}else if(@quot;0@quot;.equals(isComputerExam) @amp;@amp; @quot;1@quot;.equals(isStamina) ){
return operateScore;
} else if(@quot;1@quot;.equals(isComputerExam) @amp;@amp; @quot;1@quot;.equals(isStamina) ){
if(@quot;0@quot;.equals(examRules)){
writtenScore = writtenScore * (writtenRatio / 100);
operateScore = operateScore * (operateRatio / 100);
return writtenScore + operateScore;
}else{
return writtenScore + operateScore;
}
}
})()
1618538131343
1618538470454
false
false
648;245;415;84
1618538798827
]]>
/uploads/exceltemplate/试题导入新模板.xlsx