[Main] dbuse(true) initparam(printMode,reportId,dt_from,dt_to,uri_no,tokui_cd,syohin_nm) deforgpage(blank) defheadarea(hed) defbodyarea(mei) subroutine(SelectRecords) loop(PrintNormal,@rs1,Key1,Key2) printreport($printMode,true) #------------------------------------------------- # SQL実行 #------------------------------------------------- [SelectRecords] new($param) #addparam($param,$sort) addparam($param,$dt_from) addparam($param,$dt_to) addparam($param,$uri_no) addparam($param,$tokui_cd) addparam($param,$syohin_nm) dbselect(SelectRecords,@rs1,$param) #------------------------------------------------- # 改ページ処理 #------------------------------------------------- [page_flg] #改ページ挿入 HPAGEBREAK($_row) #------------------------------------------------- # 改ページ処理 #------------------------------------------------- [PageBreak] #25行ごとに改ページ div($row_no,30,$kekka,$amari) #明細行が25行なら改ページ case($page_flg,$amari,0,1,0) #改ページ処理 iterate(page_flg,$page_flg) #------------------------------------------------- # Key1設定ルーチン #------------------------------------------------- [KeyInfo_key1] keyvalue(dummy) keybreakproc(GroupBegin_key1,GroupEnd_key1) #------------------------------------------------- # Key1開始時 #------------------------------------------------- [GroupBegin_key1] deforgpage(blank) #Importするかどうか,FormatNormalするかどうか pageopen(true,false) deforgpage(formats) resetorg() #------------------------------------------------- # Key1終了時 #------------------------------------------------- [GroupEnd_key1] #FormatNormalするかどうか #setdouble($con,0) #putcell(16,22,@rs1.uri_row) pageclose(false) #------------------------------------------------- # Key2設定ルーチン #------------------------------------------------- [KeyInfo_key2] keyvalue(@rs1.row_page) keybreakproc(GroupBegin_key2,GroupEnd_key2) #------------------------------------------------- # Key2開始時 #------------------------------------------------- [GroupBegin_key2] #------------------------------------------------- # Key2終了時 #------------------------------------------------- [GroupEnd_key2] HPAGEBREAK($_row) #------------------------------------------------- # 明細表示処理 #------------------------------------------------- [PrintNormal] #subroutine(PageBreak) formatspecialrow($_row,0,1,5) #formatspecialrow($_row,0,1,1) putline(,,,,@rs1.uriage#,,,@rs1.keihi1#,@rs1.keihi2#,@rs1.keihi3#,@rs1.keihi4#,@rs1.keihi5#,@rs1.keihi6#,@rs1.keihi7#,@rs1.keihi8#,@rs1.keihi9#,@rs1.keihi10#,@rs1.keihi11#,@rs1.keihi12#,,@rs1.keihi_kei#) #formatspecialrow($_row,0,2,1) putline(支払明細書#,@rs1.output_ymd#,@rs1.haiso_tan_nm#,,売上#,%控除#,差引計 #,@rs1.hin_nm1#,@rs1.hin_nm2#,@rs1.hin_nm3#,@rs1.hin_nm4#,@rs1.hin_nm5#,@rs1.hin_nm6#,@rs1.hin_nm7#,@rs1.hin_nm8#,@rs1.hin_nm9#,@rs1.hin_nm10#,@rs1.hin_nm11#,@rs1.hin_nm12#,,控除合計 #,差引合計 #,給与設定額#,今月の差益 #,前月繰越#,次月繰越 #,丸協運輸開発株式会社#) #formatspecialrow($_row,0,3,1) putline(,,,,) #formatspecialrow($_row,0,4,1) putline(,,,,支払額#,,,,控除額#) putline(,)