<?xml version="1.0" encoding="UTF-8"?><bm:modelxmlns:bm="http://www.leaf-framework.org/schema/bm"><bm:operations><bm:operationname="query"><bm:query-sql><![CDATA[ SELECT t.project_number, t.contract_number, t.bp_id_tenant_n, t.contract_status_n, t.contract_status, t.creation_date, t.contract_id FROM con_contract_lv t #WHERE_CLAUSE# ]]></bm:query-sql></bm:operation></bm:operations><bm:fields><bm:fieldname="project_number"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="PROJECT_NUMBER"/><bm:fieldname="contract_number"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="CONTRACT_NUMBER"/><bm:fieldname="bp_id_tenant_n"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="BP_ID_TENANT_N"/><bm:fieldname="contract_status_n"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="CONTRACT_STATUS_N"/><bm:fieldname="contract_status"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="CONTRACT_STATUS"required="true"/><bm:fieldname="contract_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="CONTRACT_ID"required="true"/><bm:fieldname="creation_date"databaseType="DATE"datatype="java.util.Date"physicalName="CREATION_DATE"/></bm:fields><bm:data-filters><bm:data-filtername="data_class"enforceOperations="query"expression="t.data_class='NORMAL'"/><bm:data-filtername="access_token"enforceOperations="query"expression="exists (select 1 from con_contract_bp cb,cus_weixin_register cr where cb.contract_id = t.contract_id and cb.id_type = cr.id_type and cb.id_card_no = cr.id_card_no and cb.enabled_flag='Y' and cr.access_token=${@access_token})"/></bm:data-filters><bm:query-fields><bm:query-fieldfield="project_number"matchany="true"queryOperator="like"/><bm:query-fieldfield="contract_number"matchany="true"queryOperator="like"/><bm:query-fieldfield="bp_id_tenant_n"matchany="true"queryOperator="like"/><bm:query-fieldfield="contract_status"queryOperator="="/><bm:query-fieldfield="creation_date"queryExpression="trunc(t.creation_date) = to_date(${@creation_date},'yyyy-mm-dd')"/></bm:query-fields></bm:model>