<select id="selectPageWithParam" resultType="com.cmb.xft.ini.domain.pojo.InvoiceRiskAlarmResult">
select ira.id as id,
ira.enterprise_id as enterprise_id,
ira.alarm_date as alarm_date,
ira.invoice_in_id as invoice_in_id,
ira.alarm_info as alarm_info,
i.invoice_code as invoice_code,
i.invoice_number as invoice_number,
i.electronic_invoice_number as electronic_invoice_number,
i.issue_time as issue_time,
i.invoice_type as invoice_type,
i.sys_invoice_type as sys_invoice_type,
i.invoice_status as invoice_status,
i.buyer_company_name as buyer_company_name,
i.buyer_taxpayer_id as buyer_taxpayer_id,
i.seller_company_name as seller_company_name,
i.seller_taxpayer_id as seller_taxpayer_id,
i.tax_included_amount as tax_included_amount
from invoice_in_risk_alarm ira
left join invoice_in i on ira.invoice_in_id = i.id
where ira.enterprise_id = #{enterpriseId}
<if test="param.newestAlarmDateStart != null">
and ira.alarm_date >= #{param.newestAlarmDateStart}
</if>
<if test="param.newestAlarmDateEnd != null">
and ira.alarm_date <= #{param.newestAlarmDateEnd}
</if>
<if test="param.alarmInfo != null and param.alarmInfo.size() != 0">
and
<foreach collection="param.alarmInfo" item="alarmInfo" open="(" separator="or" close=")">
ira.alarm_info like concat('%', #{alarmInfo}, '%')
</foreach>
</if>
<if test="param.sysInvoiceTypes != null and param.sysInvoiceTypes.size() != 0">
and i.sys_invoice_type in
<foreach collection="param.sysInvoiceTypes" item="invoiceType" open="(" separator="," close=")">
#{invoiceType}
</foreach>
</if>
<if test="param.invoiceStatuses != null and param.invoiceStatuses.size() != 0">
and i.invoice_status in
<foreach collection="param.invoiceStatuses" item="invoiceStatus" open="(" separator="," close=")">
#{invoiceStatus}
</foreach>
</if>
<if test="param.sellerTaxpayerId != null and param.sellerTaxpayerId != ''">
and i.seller_taxpayer_id like concat('%', #{param.sellerTaxpayerId}, '%')
</if>
<if test="param.sellerCompanyName != null and param.sellerCompanyName != ''">
and i.seller_company_name like concat('%', #{param.sellerCompanyName}, '%')
</if>
<if test="param.invoiceNumber != null and param.invoiceNumber != ''">
and i.invoice_number like concat('%', #{param.invoiceNumber}, '%')
</if>
<if test="param.invoiceCodePattern != null and param.invoiceCodePattern != ''">
and i.invoice_code like concat('%', #{param.invoiceCodePattern}, '%')
</if>
<if test="param.electronicInvoiceNumber != null and param.electronicInvoiceNumber != ''">
and i.electronic_invoice_number like concat('%', #{param.electronicInvoiceNumber}, '%')
</if>
<if test="param.issueTimeStart != null">
and i.issue_time >= #{param.issueTimeStart}
</if>
<if test="param.issueTimeEnd != null">
and i.issue_time < #{param.issueTimeEnd}
</if>
<if test="param.taxIncludedAmountStart != null">
and i.tax_included_amount >= #{param.taxIncludedAmountStart}
</if>
<if test="param.taxIncludedAmountTo != null">
and i.tax_included_amount <= #{param.taxIncludedAmountTo}
</if>
<choose>
<when test="param.orderQueryParam != null">
order by
<if test="param.orderQueryParam.field != null and param.orderQueryParam.field != ''">
${param.orderQueryParam.field} ${param.orderQueryParam.method},
</if>
ira.update_time desc
</when>
<otherwise>
order by ira.update_time desc, i.invoice_number desc
</otherwise>
</choose>
</select>
这一段有什么错误吗
POJO相关介绍
扫一扫
5709
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
