2024-09-19 朱宝民 消费记录接口,仅显示消费金额大于0的记录
| | |
| | | INNER JOIN pr_intake inta ON inta.id = och.intake_id |
| | | <where> |
| | | AND och.cl_ic_card_no IS NOT NULL AND och.client_id IS NOT NULL |
| | | AND och.cl_this_money> 0 |
| | | <if test = "clientName != null and clientName !=''"> |
| | | AND cli.name like CONCAT('%',#{clientName},'%') |
| | | </if> |
| | |
| | | INNER JOIN pr_intake inta ON inta.id = och.intake_id |
| | | <where> |
| | | AND och.cl_ic_card_no IS NOT NULL AND och.client_id IS NOT NULL |
| | | AND och.cl_this_money> 0 |
| | | <if test = "clientName != null and clientName !=''"> |
| | | AND cli.name like CONCAT('%',#{clientName},'%') |
| | | </if> |