Skip to content
Snippets Groups Projects

收款类型配置税额计算附加税

Merged jiangxiaoming requested to merge jiangxiaoming into dev
Compare and
2 files
+ 9
4
Compare changes
  • Side-by-side
  • Inline
Files
2
@@ -71,7 +71,12 @@ public interface InvoiceMapper extends BaseMapper<InvoicePo> {
"on a.invoice_id = b.invoice_id and a.available='YES' and b.available='YES' where a.income_id = #{incomeId} ")
BigDecimal selectInvoiceTaxAmount(@Param("incomeId") Long incomeId);
//查询回单发票的附加税额
@Select("select sum(b.tax*b.rate) from t_income_invoice a left join t_invoice_detail b " +
"on a.invoice_id = b.invoice_id and a.available='YES' and b.available='YES' where a.income_id = #{incomeId} ")
BigDecimal selectInvoiceTaxAmountFujia(@Param("incomeId") Long incomeId);
@Select("SELECT SUM(b.tax * it.rate)" +
"FROM t_income_invoice a" +
"LEFT JOIN t_invoice_detail b ON a.invoice_id = b.invoice_id " +
"LEFT JOIN t_income_type it ON it.income_type_name = #{incomeType}" +
"WHERE a.available = 'YES'" +
" AND b.available = 'YES'" +
" AND a.income_id = #{incomeId}")
BigDecimal selectInvoiceTaxAmountFujia(@Param("incomeId") Long incomeId,@Param("incomeType") String incomeType);
}