| | |
|---|
| | | %s as talent_level, |
|---|
| | | o.card_id, tc.card_no, tc.card_type, |
|---|
| | | o.merchant_id, m.merchant_name, m.merchant_type, |
|---|
| | | o.benefit_id, b.benefit_name, o.order_type, |
|---|
| | | o.benefit_id, b.benefit_name, |
|---|
| | | coalesce(nullif(o.product_name_snapshot, ''), p.product_name, b.benefit_name) as product_name, |
|---|
| | | o.order_type, |
|---|
| | | o.order_amount, o.subsidy_amount, o.pay_amount, |
|---|
| | | o.order_status, o.verify_status, o.created_at, o.updated_at as pay_time |
|---|
| | | from benefit_order o |
|---|
| | | left join talent_user tu on tu.id = o.talent_id |
|---|
| | | left join talent_card tc on tc.id = o.card_id |
|---|
| | | left join benefit b on b.id = o.benefit_id |
|---|
| | | left join merchant_product p on p.id = o.product_id and p.deleted = 0 |
|---|
| | | left join merchant m on m.id = o.merchant_id |
|---|
| | | """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by o.id desc limit ? offset ?", pageArgs.toArray()); |
|---|
| | | Long total = jdbcTemplate.queryForObject(""" |
|---|
