<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<impMappingConfigVO id="__7tkXQ8UWGSqrTJkHtCB">
  <name>试题导入</name>
  <parentId>__LgZds5MVHW3o08T7UcX</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <xml><![CDATA[<cn.myapps.runtime.dynaform.dts.excelimport.ExcelMappingDiagram>
<flowstatus>16</flowstatus>
<flowpath></flowpath>
<deleteMSG></deleteMSG>
<width>2048</width>
<height>1536</height>
<needRollback>rollback</needRollback>
<cn.myapps.runtime.dynaform.dts.excelimport.MasterSheet>
<id>1610352775405</id>
<name>试题表</name>
<scale>0</scale>
<x>84</x>
<y>222</y>
<width>142</width>
<height>34</height>
<formName>test_quiz_base_info</formName>
</cn.myapps.runtime.dynaform.dts.excelimport.MasterSheet>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610352800615</id>
<name>试题类型</name>
<scale>0</scale>
<x>12</x>
<y>144</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>quizType</fieldName>
<primaryKey>false</primaryKey>
<valueScript>(function(){  
     var value = getItemValueAsString(@quot;quizType@quot;)+@quot;@quot;;  
  	switch(value){  
        case @quot;单选题@quot;:{return @quot;1@quot;; break;}  
          case @quot;多选题@quot;:{return @quot;2@quot;; break;}  
          case @quot;判断题@quot;:{return @quot;3@quot;; break;}  
      }  
    
  })()</valueScript>
<validateRule>//判断表单某字段不能为空   
   (function(){   
   var value = getItemValueAsString(@quot;quizType@quot;);    
   if(value==null || value.trim().length()@lt;=0) {   
       return @quot;试题类型字段必须填写！@quot;;   
   }    
   })()</validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610352775405</startnodeid>
<endnodeid>1610352800615</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>66;118;84;222</pointstack>
<id>1610352880983</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610352900766</id>
<name>试题题干</name>
<scale>0</scale>
<x>92</x>
<y>60</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>quizTopic</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule>//判断表单某字段不能为空     
     (function(){     
     var value = getItemValueAsString(@quot;quizTopic@quot;);      
     if(value==null || value.trim().length()@lt;=0) {     
         return @quot;试题题干字段必须填写！@quot;;     
     }     
     })()</validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610352900766</startnodeid>
<endnodeid>1610352775405</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>84;222;215;113</pointstack>
<id>1610352926301</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610353035744</id>
<name>试题解析</name>
<scale>0</scale>
<x>207</x>
<y>321</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>quizAnalysis</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610353035744</startnodeid>
<endnodeid>1610352775405</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>84;222;286;298</pointstack>
<id>1610353073928</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610353084834</id>
<name>创建时间</name>
<scale>0</scale>
<x>327</x>
<y>278</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>createdTime</fieldName>
<primaryKey>false</primaryKey>
<valueScript>(function(){  
  return getToday();  
  })()</valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610353084834</startnodeid>
<endnodeid>1610352775405</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>84;222;212;319</pointstack>
<id>1610353135911</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.DetailSheet>
<id>1610353753619</id>
<name>试题选项</name>
<scale>0</scale>
<x>624</x>
<y>259</y>
<width>142</width>
<height>34</height>
<formName>test_quiz_option</formName>
</cn.myapps.runtime.dynaform.dts.excelimport.DetailSheet>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610354013476</id>
<name>试题号</name>
<scale>0</scale>
<x>399</x>
<y>142</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>quizCode</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610352775405</startnodeid>
<endnodeid>1610354013476</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>375;166;84;222</pointstack>
<id>1610354031927</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610354037900</id>
<name>试题号</name>
<scale>0</scale>
<x>511</x>
<y>56</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>quizCode</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610354013476</startnodeid>
<endnodeid>1610354037900</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>603;136;375;166</pointstack>
<id>1610354052497</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610354037900</startnodeid>
<endnodeid>1610353753619</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>624;259;603;136</pointstack>
<id>1610354055681</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610354072365</id>
<name>选项名称</name>
<scale>0</scale>
<x>831</x>
<y>106</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>optionName</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule>//判断表单某字段不能为空      
      (function(){      
      var value = getItemValueAsString(@quot;optionName@quot;);       
      if(value==null || value.trim().length()@lt;=0) {      
          return @quot;选项名称字段必须填写！@quot;;      
      }      
      })()</validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610354072365</startnodeid>
<endnodeid>1610353753619</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>624;259;833;110</pointstack>
<id>1610354112697</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610354115962</id>
<name>选项内容</name>
<scale>0</scale>
<x>903</x>
<y>235</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>optionContent</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule>//判断表单某字段不能为空      
      (function(){      
      var value = getItemValueAsString(@quot;optionContent@quot;);       
      if(value==null || value.trim().length()@lt;=0) {      
          return @quot;选项内容字段必须填写！@quot;;      
      }      
      })()</validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610354115962</startnodeid>
<endnodeid>1610353753619</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>624;259;903;235</pointstack>
<id>1610354190061</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610355550778</id>
<name>创建时间</name>
<scale>0</scale>
<x>836</x>
<y>353</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>createdTime</fieldName>
<primaryKey>false</primaryKey>
<valueScript>(function(){  
  return getToday();  
  })()</valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610353753619</startnodeid>
<endnodeid>1610355550778</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>836;353;624;259</pointstack>
<id>1610355573355</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610356311207</id>
<name>题库Id</name>
<scale>0</scale>
<x>38</x>
<y>311</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>topicBankId</fieldName>
<primaryKey>false</primaryKey>
<valueScript>(function(){   
  var topicBankId = new Packages.cn.myapps.common.util.cache.MemoryCacheUtil.getFromPrivateSpace(@quot;topicBankId@quot;, getWebUser());//读缓存  
   return topicBankId;   
   })()</valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610352775405</startnodeid>
<endnodeid>1610356311207</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>38;311;84;222</pointstack>
<id>1610356900735</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1610356920710</id>
<name>是否启用</name>
<scale>0</scale>
<x>407</x>
<y>390</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>isAction</fieldName>
<primaryKey>false</primaryKey>
<valueScript>(function(){ 
 return @quot;是@quot;; 
 })()</valueScript>
<validateRule></validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1610356920710</startnodeid>
<endnodeid>1610352775405</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>84;222;407;390</pointstack>
<id>1610357072733</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<cn.myapps.runtime.dynaform.dts.excelimport.Column>
<id>1612241064226</id>
<name>正确答案</name>
<scale>0</scale>
<x>255</x>
<y>55</y>
<width>142</width>
<height>34</height>
<formName></formName>
<fieldName>answer</fieldName>
<primaryKey>false</primaryKey>
<valueScript></valueScript>
<validateRule>//判断表单某字段不能为空     
     (function(){     
     var value = getItemValueAsString(@quot;answer@quot;);      
     if(value==null || value.trim().length()@lt;=0) {     
         return @quot;正确答案字段必须填写！@quot;;     
     }     
     })()</validateRule>
</cn.myapps.runtime.dynaform.dts.excelimport.Column>
<cn.myapps.runtime.dynaform.dts.excelimport.Relation>
<state></state>
<startnodeid>1612241064226</startnodeid>
<endnodeid>1610352775405</endnodeid>
<ispassed>false</ispassed>
<isreturn>false</isreturn>
<condition></condition>
<pointstack>84;222;254;57</pointstack>
<id>1612241332053</id>
<name></name>
</cn.myapps.runtime.dynaform.dts.excelimport.Relation>
</cn.myapps.runtime.dynaform.dts.excelimport.ExcelMappingDiagram>
]]></xml>
  <templatePath>/uploads/exceltemplate/试题导入新模板 (2).xlsx</templatePath>
</impMappingConfigVO>