<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__2hwWY1B1GKxDeds5AIH">
  <name>Confirm_the_score</name>
  <parentId>__AT2erAITyWrFQyQEh3m</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <description>确认成绩</description>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <lastModifyTime>2021-11-13T10:19:21.000+08:00</lastModifyTime>
  <readonly>false</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__U70CMfB0cst74BxjnJR</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__9hkv8xD76wz3NBM39ER</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
  //成绩确认状态 为未确认且 分数要大于0 才可以确认成绩
  /*var loginNo=getWebUser().getLoginno();      
var userId = getUserIdByLoginno(loginNo);   
var examId=getSession(userId + "examId"); */
  var classId = new Packages.cn.myapps.common.util.cache.MemoryCacheUtil.getFromPrivateSpace("classId", getWebUser());//读缓存
  println("classId--->"+classId);
  var whereStr = "where ITEM_CLASSID = '"+classId+"' and ITEM_SCORESTATE = '0' and ITEM_SUMSCORE > 0";
  var name = getItemValueAsString("name");
  var learnname = getItemValueAsString("learnname");
  var teststate = getItemValueAsString("testState");
  var idcardno = getItemValueAsString("idcarno");
  var phone = getItemValueAsString("phone");
  if(isNotNull(name)){            
    whereStr += " and ITEM_NAME like concat('%','"+name+"','%') ";            
  } 
  if(isNotNull(teststate)){            
    whereStr += " and ITEM_graduationTestResults = '"+teststate+"'";            
  } 
  if(isNotNull(idcardno)){            
    whereStr += " and ITEM_idcardno like concat('%','"+idcardno+"','%') ";            
  } 
  if(isNotNull(phone)){            
    whereStr += " and ITEM_phone like concat('%','"+phone+"','%') ";            
  } 
  if(isNotNull(learnname)){            
    whereStr += " and ITEM_COMPANY like concat('%','"+learnname+"','%') ";              
  }     

  var sql =  "select "+
      "'"+ getDomainid() +"' as domainid,"+  
      "ITEM_IDCARDNO," + //身份证
      "ITEM_NAME," + //姓名
      "ITEM_COMPANY," + //所属公司
      "ITEM_PHONE," + //手机号
      "ITEM_GRADUATIONTHEORYSCORE," + //笔试成绩
      "ITEM_GRADUATIONOPERATIONSCORE," + //实操成绩
      "ITEM_SUMSCORE," + //总成绩
      "ITEM_TRAININGNOTICE," + //实操培训通知
      "ITEM_SCORESTATE," + //成绩确认状态
      "ITEM_LESSONPROGRESS,"+//课程学习进度
      "ITEM_ISMAKEUP," + //是否补考
      "ITEM_INTERNSHIPTIME,"+
      "case ITEM_graduationTestResults when '0' then '进行中' when '1' then '合格' when '2' then '不合格' else '进行中' end as ITEM_graduationTestResults,"+
      "ITEM_CLASSID,"+ //班级id
      "ID AS ITEM_ID,"+
      "ID"+
      " from tlk_level_class_student "+whereStr;
  println("ddd"+sql)
  return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"name","isCommonFilter":"true","paramKey":1657170910976}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>293</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>