 如果增加两个公司怎么处理呢？现在我只实现增加一个 ！@@！#下面的是我的sql 第三行对应的为增加的公司 select r.r_idno,r.r_name, sum(case when dept_no='1' then total_money else 0 end), sum(case when dept_no='2' then total_money else 0 end), ${if(len(deptNo)==0||deptNo==0||deptNo=='0',"","sum(case when dept_no='"+deptNo+"' then total_money else 0 end) as deptm,")} sum(case when dept_no='3' then total_money else 0 end) from tk_finance_dcard_log_rt f left join (select distinct r_name,r_idno,cardno from basic_retire_info) r on f.opcard_no=substr(r.cardno,length(r.cardno)-15,16) where 1=1 and allot_time<to_date('${if(len($endDate)==0,today(),$endDate)}','YYYY-MM-DD')+1 and allot_time>=to_date('${if(len($startDate)==0,today(),$startDate)}','YYYY-MM-DD') ${if(len($idNo)==0,""," and r.r_idno='"+$idNo+"'")} ${if(len(totalMoney)==0||totalMoney==0||totalMoney=='0'," "," and f.total_money <= ("+totalMoney+")")} group by r.r_idno,r.r_name order by r.r_idno,r.r_name |
