select

 hrmdepartment.departmentcode,    -- 门店

 formtable_main_223.cjrq,                     --创建日期

 formtable_main_223.lcbh,                    --流程编号

 formtable_main_223.ssze                      --实收总额

 from

 formtable_main_223

 left join hrmdepartment on formtable_main_223.sqbm = hrmdepartment.id

where 1=1 ${if(len(RQ_S)==0,""," and  cjrq= '"+RQ_S+"'" )}  ${if(len(BM_S)==0,""," and  lcbh= '"+BM_S+"'" )}