<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__m0J46dqNBzxui0Lawij">
  <name>lesson_auth_base_info</name>
  <parentId>__UTrlSN8IBYuGePSbeK8</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <description><![CDATA[课程授权]]></description>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <newPage>false</newPage>
  <readonly>false</readonly>
  <relatedMap><![CDATA[                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                ]]></relatedMap>
  <displayType>relatedForm</displayType>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <waterMarkScript></waterMarkScript>
  <removeActivityScript></removeActivityScript>
  <confirmActivityScript></confirmActivityScript>
  <searchFormId>__TJYTtW1UjGnltVUidj3</searchFormId>
  <styleId></styleId>
  <autoCompose>true</autoCompose>
  <relatedForm>__t8b3WI9MCRgmpSycGIZ</relatedForm>
  <templateForm></templateForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[#include "sysfunction";
(function(){        
   var authLessonId = getItemValueAsString("authLessonId");                    
   var authUserId = getItemValueAsString("authUserId"); 
  
   var whereStr = "where 1=1 ";           
                    
   if(isNotNull(authLessonId)){              
     whereStr += "and a.ITEM_AUTHLESSONID ='"+authLessonId+"' ";              
  }    

  if(isNotNull(authUserId)){              
    whereStr += "and a.ITEM_AUTHUSERID ='"+authUserId+"' ";             
  }              
    
        var sql="select "+        
         "'"+ getDomainid() +"' as domainid,"+      
        "b.ITEM_LESSONNAME," + //授权课程	        
        "a.ITEM_AUTHLESSONID," + //授权课程Id	        
        "a.ITEM_AUTHUSERID," + //授权人员Id	        
        "a.ITEM_AUTHUSERNAME," + //授权人员名称	        
        "a.ITEM_AUTHRECORDID," + //授权记录Id    
        "c.ITEM_PROGRESS,"+ //学习进度
        "a.ITEM_STUDIED,"+ //已学习节id 
        "a.ITEM_ISNEXTC,"+ //是否下一章
        "a.ITEM_ISNEXTS,"+ //是否下一节
        "SUBSTRING_INDEX(a.ITEM_validityDate ,'~',-1) ITEM_validityDate," + //有效期   
        "b.ITEM_URL," + //授权课程封面 
        "a.ITEM_AUTHLESSONCOVER,"+   
        "a.ID AS ITEM_ID,"+                       
        "a.ID "+           
        "from tlk_lesson_auth_base_info a "+        
        "INNER JOIN "+sysfunction.DS_ORGANIZATIONAUTH+
        ".tlk_lesson_base_info b on a.ITEM_AUTHLESSONID = b.ID "+
         "left JOIN "+sysfunction.DS_ORGANIZATIONAUTH+
            ".tlk_lesson_progress b on a.ITEM_AUTHLESSONID = b.ID "+
        whereStr; 
println("sql---->"+sql);
        return sql;        
        })()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{field:'authLessonId',isCommonFilter:'true'},{field:'authUserId',isCommonFilter:'true'}]]]></commonFilterCondition>
  <authorityCondition></authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
</ListView>