select
    sum(CASE WHEN adjustperiod = '00' THEN gl_detail.localdebitamount ELSE 0 END ) begin1,--期初余额
    sum(case when adjustperiod > '00' and #{month}>=adjustperiod  then gl_detail.localdebitamount else 0 end) borrower,--借方累计,
    sum(case when adjustperiod > '00' and #{month}>=adjustperiod  then gl_detail.localcreditamount else 0 end) lender --贷方累计
from gl_detail gl_detail,org_accountingbook,bd_accasoa,bd_account
where gl_detail.pk_accountingbook=org_accountingbook.pk_accountingbook
  and gl_detail.pk_accasoa=bd_accasoa.pk_accasoa
  and bd_accasoa.pk_account=bd_account.pk_account
  and gl_detail.yearv = #{year}
  and gl_detail.adjustperiod >= '00'
  and #{month} >=gl_detail.adjustperiod
  and org_accountingbook.code=#{bookCode} --账簿编号
  and gl_detail.discardflagv !='Y'
and gl_detail.dr = 0
and gl_detail.voucherkindv!= 255
and gl_detail.tempsaveflag!='Y'
and gl_detail.voucherkindv!= 5
and bd_account.code like #{accountCode} --科目编码