<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__VGjAmihQPU9rxPerAAP">
  <name>学习进度</name>
  <parentId>__8mUPq7c0c0L2jsYWY7B</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>05</pageLines>
  <showTotalRow>false</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <readonly>false</readonly>
  <relatedMap><![CDATA[                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ]]></relatedMap>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId></searchFormId>
  <autoCompose>false</autoCompose>
  <styleId>__15NqIxv7w9nnnfUTNnH</styleId>
  <relatedForm>__D4EpH6h8KaRIHkp7tvR</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
 var domainId = getDomainid();
var sql="select '"+getDomainid()+"' as domainid,"+
  "d.ID,"+
  "e.ITEM_IDCARDNO,"+
  "e.ITEM_NAME,"+
  "e.ITEM_PHONE,"+
  "d.ID as ITEM_ID,"+
   "a.ITEM_AUTHLESSONNAME,"+  //课程名称
   "e.ITEM_SECURITYID," + //保安员id
    "c.ITEM_SECTIONNAME," + //节名称
    "ifnull(d.ITEM_PROGRESS,'0') ITEM_PROGRESS," + //学习进度
    "ifnull(d.ITEM_ISCOMPLETE,'0') ITEM_ISCOMPLETE," + //是否完成
    "c.ID as ITEM_SECTIONID,"+ //节ID
    "d.ID as ITEM_PROGRESSID"+//进度ID
    " from tlk_grade_card_registration e "+
    " LEFT JOIN "+
    "tlk_lesson_auth_base_info a on a.ITEM_AUTHUSERID=e.ITEM_IDCARDNO"+
    " LEFT JOIN "+
   	" tlk_lesson_chapter b on b.ITEM_LESSONID = a.ITEM_AUTHLESSONID"+
    " LEFT JOIN "+
    " tlk_lesson_section c on b.ID = c.ITEM_LESSONCHAPTERID"+
    " LEFT JOIN "+
    " tlk_level_learning_process d on d.ITEM_SECTIONID = c.ID and d.ITEM_IDCARDNO = a.ITEM_AUTHUSERID "
return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>