<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__X5zyrIH8ZwSw6D5bhtL">
  <name>退款审核</name>
  <parentId>__hGBmZIJlszexS9jEYx0</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <readonly>true</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__yDzJ2ltb3BWmiTEib7A</searchFormId>
  <autoCompose>true</autoCompose>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
   var person_name = getItemValueAsString("person_name"); 
   var whereStr= " and 1=1 "
  if(isNotNull(person_name)){                                        
    whereStr = whereStr + " and p.item_person_name like '%"+person_name+"%' "
  }  
  var telephone = getItemValueAsString("telephone");  
  if(isNotNull(telephone)){                                        
    whereStr = whereStr + " and p.item_telephone like '%"+telephone+"%' "
  }
  var idcard_no = getItemValueAsString("idcard_no");  
  if(isNotNull(idcard_no)){                                        
    whereStr = whereStr + " and p.item_idcard_no like '%"+idcard_no+"%' "
  }
  var domain_name = getItemValueAsString("domain_name");  
  if(isNotNull(domain_name)){                                        
    whereStr = whereStr + " and p.item_domain_name like '%"+domain_name+"%' "
  }
var sql="select '"+getDomainid()+"' as domainid,p.created,p.id,p.id as item_id,p.formid,p.applicationid,r.id as item_rid,"+
    "case r.item_refund_state when '1' then '审核通过' when '2' then '审核不通过' else '待审核' end as item_refund_state,"+
    "p.item_person_name,p.item_telephone,p.item_idcard_no,p.item_pay_time,p.item_paid,p.item_pay_status,p.item_domain_name,"+
    "p.item_employee_id,p.item_domain_id,p.item_trian_id,p.item_trian_name,"+
    "p.item_plan_name,p.item_point_type,p.item_refund_time "+
    " from tlk_train_order_person p left join tlk_refund_review r on p.id = r.item_person_order_id  where p.item_trian_id='"+getDomainid()+"' and p.item_pay_status in ('5','4') "+whereStr+
    " order by p.created desc "
println(sql)
  
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>