<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__xZXtTQaOEkGmrneY1L8">
  <name>person_refund</name>
  <parentId>__HIZjMfqH2bnkhj0pPWl</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <description>退款审核记录</description>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <readonly>true</readonly>
  <relatedMap><![CDATA[                                                                                                                                                                                                                                                                                                                                                                                                                                    ]]></relatedMap>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__mdj3y1xSUl0O8DbPuId</searchFormId>
  <autoCompose>true</autoCompose>
  <relatedForm></relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[//在表单控件值脚本中获取当前文档对象
(function(){
  var z_name = getItemValueAsString("z_name"); 
  var z_idCard = getItemValueAsString("z_idCard"); 
  var z_phone = getItemValueAsString("z_phone"); 
var refundState = getItemValueAsString("refundState");
var learnName = getItemValueAsString("lesson");
var time = getItemValueAsString("time");
var whereStr = " where a.ITEM_TRAINID = '"+getDomainid()+"' ";  //显示本企业   
//var whereStr = " where 1=1 ";   
if(isNotNull(z_name)){            
    whereStr += "and a.ITEM_NAME like '%"+z_name+"%' ";  
}   
if(isNotNull(z_phone)){            
  whereStr += "and a.ITEM_PHONE = '"+z_phone+"' ";            
} 

if(isNotNull(z_idCard)){            
  whereStr += "and a.ITEM_IDCARDNO like concat('%','"+z_idCard+"','%') ";            
}      
if(isNotNull(refundState)){            
  whereStr += "and a.ITEM_REFUNDSTATE = '"+refundState+"' ";            
}  
if(isNotNull(learnName)){            
  whereStr += "and a.ITEM_LEARNNAME like concat('%','"+learnName+"','%') ";            
} 
  if(isNotNull(time)){            
    whereStr += "and a.CREATED like '%"+time+"%' ";  
}
  if(isNotNull(learnName)){            
    whereStr += "and a.ITEM_LESSONNAME like '%"+learnName+"%' ";  
}


var sql = "select '"+getDomainid()+"' as domainid,"+
"a.ITEM_SECURITYID," + //保安员id
"a.CREATED,"+  
"a.ITEM_NAME,"+
"a.ITEM_IDCARDNO,"+
"a.ITEM_LESSONID," + //课程id
"a.ITEM_LESSONNAME," + //课程名称
"a.ITEM_LEARNID," + //所属企业id
"a.ITEM_LEARNNAME," + //所属企业
"a.ITEM_TRAINID," + //培训机构id
"a.ITEM_TRAINNAME," + //培训机构
"a.ITEM_ORDERID," + //订单id
"case a.ITEM_REFUNDSTATE when '0' then '申请中'"+
" when '1' then '成功'"+
" when '2' then '拒绝'"+
" end ITEM_REFUNDSTATE," + //退款状态
"a.ITEM_REFUNDDATE," + //退款时间
"a.ITEM_AMOUNT," + //总价
"a.ITEM_COMMENT," + //拒绝原因
"a.ID,"+
"a.ID as ITEM_ID"+
" from tlk_apply_person_refund a"+whereStr;
println("sql==>" + sql);
return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"z_name","isCommonFilter":"true"}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>