SMPIF31300_미수월마감내역조회.xfdl 151 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMPIF31300" position="absolute 0 0 1207 739" titletext="미수월마감 내역조회" oninit="SMPIF31300_oninit" onload="SMPIF31300_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 15 1211 714" id="grp_biz" scrollbars="autoboth" anchor="all">
  8. <Layouts>
  9. <Layout>
  10. <Div position="absolute 1 9 1199 44" align="align:center top;" id="grp_sea" class="div_SA" anchor="left top right">
  11. <Layouts>
  12. <Layout>
  13. <Static text="마감월 :" position="absolute 15 9 90 26" id="caption2" class="search_name" anchor="default"/>
  14. <Button position="absolute 1123 7 1179 29" id="button1" class="btn1" text="조회" anchor="top right" onclick="grp_biz_grp_sea_button1_onclick"/>
  15. <Shape position="absolute 1105 7 1111 29" linetype="vertical" id="line13" class="line_4" anchor="top right"/>
  16. <Calendar position="absolute 90 9 187 28" id="ipt_endmonthfrom" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_biz_grp_sea_ipt_endmonthfrom_onchanged" onkillfocus="grp_biz_grp_sea_ipt_endmonthfrom_onkillfocus"/>
  17. <Calendar position="absolute 223 8 320 27" id="ipt_endmonthto" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  18. <Static text="보험유형 :" position="absolute 419 9 505 26" id="caption4" class="search_name" anchor="default"/>
  19. <Radio position="absolute 508 8 653 24" id="rdo_insukindflag" class="radio_search" columncount="3" rowcount="1" codecolumn="value" datacolumn="label" anchor="default" innerdataset="@ds_rdo_insukindflag" onitemchanged="grp_biz_grp_sea_rdo_insukindflag_onitemchanged"/>
  20. <Static text="~" position="absolute 201 11 216 26" id="caption10" anchor="default"/>
  21. <Static text="중간합계설정 :" position="absolute 714 9 830 26" id="caption11" class="search_name" anchor="default"/>
  22. <Combo position="absolute 836 8 1020 27" id="cmb_subtotalflag" class="combo_search" taborder="3" codecolumn="value" datacolumn="label" anchor="default" innerdataset="@ds_cmb_subtotalflag"/>
  23. </Layout>
  24. </Layouts>
  25. </Div>
  26. <Tab position="absolute 1 58 1202 664" id="switch1" class="sw_box" anchor="all" onchanged="grp_biz_switch1_onchanged">
  27. <Tabpages>
  28. <Tabpage text="미수월마감내역(보험/산재)" id="case_uncomonthendinsu">
  29. <Layouts>
  30. <Layout>
  31. <Grid position="absolute 0 10 1197 575" id="grd_uncomonthendinsu" class="datagrid2" binddataset="ds_main_uncomonthendinsu" anchor="all" onkeydown="grp_biz_switch1_case_uncomonthendinsu_grd_uncomonthendinsu_onkeydown" oncellclick="grp_biz_switch1_case_uncomonthendinsu_grd_uncomonthendinsu_oncellclick" selecttype="multirow" cellsizingtype="col">
  32. <Formats>
  33. <Format id="default">
  34. <Columns>
  35. <Column size="40" band="left"/>
  36. <Column size="53" band="left"/>
  37. <Column size="64" band="left"/>
  38. <Column size="76" band="left"/>
  39. <Column size="73" band="left"/>
  40. <Column size="35" band="left"/>
  41. <Column size="56" band="left"/>
  42. <Column size="109"/>
  43. <Column size="95"/>
  44. <Column size="95"/>
  45. <Column size="95"/>
  46. <Column size="95"/>
  47. <Column size="100"/>
  48. <Column size="95"/>
  49. <Column size="95"/>
  50. <Column size="95"/>
  51. <Column size="95"/>
  52. <Column size="95"/>
  53. <Column size="100"/>
  54. <Column size="95"/>
  55. <Column size="95"/>
  56. <Column size="95"/>
  57. <Column size="95"/>
  58. <Column size="95"/>
  59. <Column size="95"/>
  60. <Column size="95"/>
  61. <Column size="95"/>
  62. <Column size="95"/>
  63. <Column size="94"/>
  64. <Column size="95"/>
  65. <Column size="95"/>
  66. <Column size="100"/>
  67. <Column size="95"/>
  68. <Column size="95"/>
  69. <Column size="95"/>
  70. <Column size="95"/>
  71. <Column size="95"/>
  72. <Column size="100"/>
  73. <Column size="95"/>
  74. <Column size="95"/>
  75. <Column size="95"/>
  76. <Column size="95"/>
  77. <Column size="95"/>
  78. <Column size="95"/>
  79. <Column size="95"/>
  80. <Column size="95"/>
  81. <Column size="95"/>
  82. <Column size="95"/>
  83. <Column size="95"/>
  84. <Column size="95"/>
  85. <Column size="95"/>
  86. <Column size="95"/>
  87. <Column size="70"/>
  88. </Columns>
  89. <Rows>
  90. <Row size="32" band="head"/>
  91. <Row size="24"/>
  92. <Row size="24" band="summ"/>
  93. </Rows>
  94. <Band id="head">
  95. <Cell/>
  96. <Cell col="1" text="미수&#10;년월"/>
  97. <Cell col="2" text="보험&#10;유형"/>
  98. <Cell col="3" text="청구&#10;구분"/>
  99. <Cell col="4" text="내원&#10;유형"/>
  100. <Cell col="5" text="청구&#10;분야"/>
  101. <Cell col="6" text="청구&#10;건수"/>
  102. <Cell col="7" text="총&#10;진료비"/>
  103. <Cell col="8" text="본인&#10;부담금"/>
  104. <Cell col="9" text="청구액"/>
  105. <Cell col="10" text="상한액"/>
  106. <Cell col="11" text="지원금"/>
  107. <Cell col="12" text="장애인금"/>
  108. <Cell col="13" text="심결&#10;건수"/>
  109. <Cell col="14" text="심결&#10;총진료비"/>
  110. <Cell col="15" text="심사결정액"/>
  111. <Cell col="16" text="심결&#10;상한액"/>
  112. <Cell col="17" text="심결&#10;지원금"/>
  113. <Cell col="18" text="심결&#10;장애인"/>
  114. <Cell col="19" text="삭감&#10;건수"/>
  115. <Cell col="20" text="조정&#10;삭감액"/>
  116. <Cell col="21" text="실삭감액"/>
  117. <Cell col="22" text="반송&#10;건수"/>
  118. <Cell col="23" text="반송&#10;총진료비"/>
  119. <Cell col="24" text="반송액"/>
  120. <Cell col="25" text="반송&#10;상한액(심결)"/>
  121. <Cell col="26" text="반송&#10;지원금(심결)"/>
  122. <Cell col="27" text="반송&#10;장애인(심결)"/>
  123. <Cell col="28" text="지급반송액"/>
  124. <Cell col="29" text="반송&#10;상한액"/>
  125. <Cell col="30" text="반송&#10;지원금"/>
  126. <Cell col="31" text="반송&#10;장애인"/>
  127. <Cell col="32" text="보류&#10;건수"/>
  128. <Cell col="33" text="보류&#10;총진료비"/>
  129. <Cell col="34" text="보류액"/>
  130. <Cell col="35" text="보류&#10;상한액"/>
  131. <Cell col="36" text="보류&#10;지원금"/>
  132. <Cell col="37" text="보류&#10;장애인"/>
  133. <Cell col="38" text="환수액"/>
  134. <Cell col="39" text="환수&#10;예정액"/>
  135. <Cell col="40" text="환수예정&#10;정산액"/>
  136. <Cell col="41" text="결손액"/>
  137. <Cell col="42" text="입금&#10;건수"/>
  138. <Cell col="43" text="입금액"/>
  139. <Cell col="44" text="추가입금"/>
  140. <Cell col="45" text="전미수금"/>
  141. <Cell col="46" text="미수금"/>
  142. <Cell col="47" text="종결&#10;여부"/>
  143. <Cell col="48" text="청구&#10;접수번호"/>
  144. <Cell col="49" text="입금&#10;접수번호"/>
  145. <Cell col="50" text="환수&#10;접수번호"/>
  146. <Cell col="51" text="환수예정&#10;정산접수번호"/>
  147. <Cell col="52" text="마감월"/>
  148. </Band>
  149. <Band id="body">
  150. <Cell celltype="head" expr="currow+1"/>
  151. <Cell col="1" displaytype="expr:getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'none' : 'date'" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:uncoym" mask="yyyy/MM" enable="false"/>
  152. <Cell col="2" displaytype="expr:getRowLevel(currow) == 0 ? 'combo' : 'text'" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 2 ? '년월소계' : getRowLevel(currow) == 1 ? '' : getRowLevel(currow) == 3 ? '' : insukind" combodataset="ds_cmb_insukind" combocodecol="value" combodatacol="label" enable="false"/>
  153. <Cell col="3" displaytype="expr:getRowLevel(currow) == 0 ? 'combo' : 'text'" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 3 ? '구분합계' : getRowLevel(currow) == 2 ? '' : getRowLevel(currow) == 1 ? '' : clamflag" combodataset="ds_init_P0155list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  154. <Cell col="4" displaytype="expr:getRowLevel(currow) == 0 ? 'combo' : 'text'" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 1 ? '유형합계' : getRowLevel(currow) == 2 ? '' : getRowLevel(currow) == 3 ? '' : ioflag" combodataset="ds_init_P0028list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  155. <Cell col="5" displaytype="combo" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:ordfildcd" combodataset="ds_init_P0458list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  156. <Cell col="6" displaytype="normal" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clcnt" enable="false"/>
  157. <Cell col="7" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clmcstotamt" enable="false"/>
  158. <Cell col="8" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clownbamt" enable="false"/>
  159. <Cell col="9" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clclamamt" enable="false"/>
  160. <Cell col="10" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clownbmaxexamt" enable="false"/>
  161. <Cell col="11" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clsuppamt" enable="false"/>
  162. <Cell col="12" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clhandicaprfund" enable="false"/>
  163. <Cell col="13" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrcnt" enable="false"/>
  164. <Cell col="14" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrmcstotamt" enable="false"/>
  165. <Cell col="15" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrjrsltamt" enable="false"/>
  166. <Cell col="16" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrownbmaxexamt" enable="false"/>
  167. <Cell col="17" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrsuppamt" enable="false"/>
  168. <Cell col="18" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrhandicaprfund" enable="false"/>
  169. <Cell col="19" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdcnt" enable="false"/>
  170. <Cell col="20" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdadjtrdamt" enable="false"/>
  171. <Cell col="21" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdorgrdamt" enable="false"/>
  172. <Cell col="22" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdcnt" enable="false"/>
  173. <Cell col="23" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdmcstotamt" enable="false"/>
  174. <Cell col="24" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdsendamt" enable="false"/>
  175. <Cell col="25" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdjrownbmaxexamt" enable="false"/>
  176. <Cell col="26" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdjrsuppamt" enable="false"/>
  177. <Cell col="27" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdjrhandicaprfund" enable="false"/>
  178. <Cell col="28" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdjudgdeciamt" enable="false"/>
  179. <Cell col="29" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdownbmaxexamt" enable="false"/>
  180. <Cell col="30" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdsuppamt" enable="false"/>
  181. <Cell col="31" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdhandicaprfund" enable="false"/>
  182. <Cell col="32" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtcnt" enable="false"/>
  183. <Cell col="33" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtmcstotamt" enable="false"/>
  184. <Cell col="34" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtreteamt" enable="false"/>
  185. <Cell col="35" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtownbmaxexamt" enable="false"/>
  186. <Cell col="36" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtsuppamt" enable="false"/>
  187. <Cell col="37" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rthandicaprfund" enable="false"/>
  188. <Cell col="38" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtnamt" enable="false"/>
  189. <Cell col="39" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtnscheamt" enable="false"/>
  190. <Cell col="40" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:stfrtnamt" enable="false"/>
  191. <Cell col="41" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:lossamt" enable="false"/>
  192. <Cell col="42" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:depocnt" enable="false"/>
  193. <Cell col="43" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:depoamt" enable="false"/>
  194. <Cell col="44" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:adddepoamt" enable="false"/>
  195. <Cell col="45" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:bfuncoamt" enable="false"/>
  196. <Cell col="46" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:uncoamt" enable="false"/>
  197. <Cell col="47" displaytype="checkbox" edittype="checkbox" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:endyn"/>
  198. <Cell col="48" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clamacptno" enable="false"/>
  199. <Cell col="49" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:depoacptno" enable="false"/>
  200. <Cell col="50" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtnacptno" enable="false"/>
  201. <Cell col="51" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:stfrtnacptno" enable="false"/>
  202. <Cell col="52" displaytype="expr:getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'none' : 'date'" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:endym" mask="yyyy/MM" enable="false"/>
  203. </Band>
  204. <Band id="summary">
  205. <Cell/>
  206. <Cell col="1" style="color:red;color2:red;font:arial,9,bold;" text="총계"/>
  207. <Cell col="2"/>
  208. <Cell col="3"/>
  209. <Cell col="4"/>
  210. <Cell col="5"/>
  211. <Cell col="6" displaytype="number" style="align:right middle;color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clcnt')"/>
  212. <Cell col="7" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clmcstotamt')"/>
  213. <Cell col="8" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clownbamt')"/>
  214. <Cell col="9" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clclamamt')"/>
  215. <Cell col="10" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clownbmaxexamt')"/>
  216. <Cell col="11" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clsuppamt')"/>
  217. <Cell col="12" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clhandicaprfund')"/>
  218. <Cell col="13" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrcnt')"/>
  219. <Cell col="14" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrmcstotamt')"/>
  220. <Cell col="15" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrjrsltamt')"/>
  221. <Cell col="16" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrownbmaxexamt')"/>
  222. <Cell col="17" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrsuppamt')"/>
  223. <Cell col="18" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum(jrhandicaprfund')"/>
  224. <Cell col="19" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rdcnt')"/>
  225. <Cell col="20" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('rdadjtrdamt')"/>
  226. <Cell col="21" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('rdorgrdamt')"/>
  227. <Cell col="22" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdcnt')"/>
  228. <Cell col="23" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdmcstotamt')"/>
  229. <Cell col="24" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum(sdsendamt)"/>
  230. <Cell col="25" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdjrownbmaxexamt')"/>
  231. <Cell col="26" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdjrsuppamt')"/>
  232. <Cell col="27" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdjrhandicaprfund')"/>
  233. <Cell col="28" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdjudgdeciamt')"/>
  234. <Cell col="29" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdownbmaxexamt')"/>
  235. <Cell col="30" displaytype="number" style="color:red;color2:red;font:arial,9,bol;" text="expr:getSum('sdsuppamt')"/>
  236. <Cell col="31" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('sdhandicaprfund')"/>
  237. <Cell col="32" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtcnt')"/>
  238. <Cell col="33" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtmcstotamt')"/>
  239. <Cell col="34" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtreteamt')"/>
  240. <Cell col="35" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtownbmaxexamt')"/>
  241. <Cell col="36" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtsuppamt')"/>
  242. <Cell col="37" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rthandicaprfund')"/>
  243. <Cell col="38" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtnamt')"/>
  244. <Cell col="39" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtnscheamt')"/>
  245. <Cell col="40" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('stfrtnamt')"/>
  246. <Cell col="41" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('lossamt')"/>
  247. <Cell col="42" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('depocnt')"/>
  248. <Cell col="43" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('depoamt')"/>
  249. <Cell col="44" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('adddepoamt')"/>
  250. <Cell col="45" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('bfuncoamt')"/>
  251. <Cell col="46" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('uncoamt')"/>
  252. <Cell col="47"/>
  253. <Cell col="48"/>
  254. <Cell col="49"/>
  255. <Cell col="50"/>
  256. <Cell col="51"/>
  257. <Cell col="52"/>
  258. </Band>
  259. </Format>
  260. </Formats>
  261. </Grid>
  262. </Layout>
  263. </Layouts>
  264. </Tabpage>
  265. <Tabpage text="미수월마감내역(보호)" id="case_uncomonthendproc">
  266. <Layouts>
  267. <Layout>
  268. <Grid position="absolute 0 10 1197 575" id="grd_uncomonthendproc" class="datagrid2" binddataset="ds_main_uncomonthendproc" anchor="all" onkeydown="grp_biz_switch1_case_uncomonthendproc_grd_uncomonthendproc_onkeydown" selecttype="multirow" oncellclick="grp_biz_switch1_case_uncomonthendproc_grd_uncomonthendproc_oncellclick" cellsizingtype="col">
  269. <Formats>
  270. <Format id="default">
  271. <Columns>
  272. <Column size="30"/>
  273. <Column size="59"/>
  274. <Column size="65"/>
  275. <Column size="77"/>
  276. <Column size="72"/>
  277. <Column size="50"/>
  278. <Column size="0"/>
  279. <Column size="52"/>
  280. <Column size="95"/>
  281. <Column size="95"/>
  282. <Column size="95"/>
  283. <Column size="95"/>
  284. <Column size="95"/>
  285. <Column size="62"/>
  286. <Column size="95"/>
  287. <Column size="95"/>
  288. <Column size="95"/>
  289. <Column size="95"/>
  290. <Column size="51"/>
  291. <Column size="95"/>
  292. <Column size="95"/>
  293. <Column size="95"/>
  294. <Column size="51"/>
  295. <Column size="95"/>
  296. <Column size="95"/>
  297. <Column size="95"/>
  298. <Column size="95"/>
  299. <Column size="57"/>
  300. <Column size="95"/>
  301. <Column size="95"/>
  302. <Column size="95"/>
  303. <Column size="95"/>
  304. <Column size="95"/>
  305. <Column size="95"/>
  306. <Column size="95"/>
  307. <Column size="95"/>
  308. <Column size="56"/>
  309. <Column size="95"/>
  310. <Column size="95"/>
  311. <Column size="95"/>
  312. <Column size="95"/>
  313. <Column size="49"/>
  314. <Column size="95"/>
  315. <Column size="95"/>
  316. <Column size="95"/>
  317. <Column size="95"/>
  318. <Column size="100"/>
  319. </Columns>
  320. <Rows>
  321. <Row size="32" band="head"/>
  322. <Row size="24"/>
  323. <Row size="24" band="summ"/>
  324. </Rows>
  325. <Band id="head">
  326. <Cell/>
  327. <Cell col="1" text="미수&#10;년월"/>
  328. <Cell col="2" text="보험&#10;유형"/>
  329. <Cell col="3" text="청구&#10;구분"/>
  330. <Cell col="4" text="내원&#10;유형"/>
  331. <Cell col="5" text="청구&#10;분야"/>
  332. <Cell col="6" text="시군구"/>
  333. <Cell col="7" text="청구&#10;건수"/>
  334. <Cell col="8" text="총진료비"/>
  335. <Cell col="9" text="본인&#10;부담금"/>
  336. <Cell col="10" text="청구액"/>
  337. <Cell col="11" text="장애인"/>
  338. <Cell col="12" text="대불금"/>
  339. <Cell col="13" text="심결&#10;건수"/>
  340. <Cell col="14" text="심결&#10;총진료비"/>
  341. <Cell col="15" text="심사결정액"/>
  342. <Cell col="16" text="심결&#10;장애인"/>
  343. <Cell col="17" text="심결&#10;대불금"/>
  344. <Cell col="18" text="삭감&#10;건수"/>
  345. <Cell col="19" text="조정&#10;삭감액"/>
  346. <Cell col="20" text="실삭감액"/>
  347. <Cell col="21" text="기관&#10;삭감액"/>
  348. <Cell col="22" text="반송&#10;건수"/>
  349. <Cell col="23" text="반송&#10;총진료비"/>
  350. <Cell col="24" text="반송액"/>
  351. <Cell col="25" text="반송&#10;장애인"/>
  352. <Cell col="26" text="반송&#10;대불금"/>
  353. <Cell col="27" text="보류&#10;건수"/>
  354. <Cell col="28" text="보류&#10;총진료비"/>
  355. <Cell col="29" text="보류액"/>
  356. <Cell col="30" text="보류&#10;장애인"/>
  357. <Cell col="31" text="보류&#10;대불금"/>
  358. <Cell col="32" text="환수액"/>
  359. <Cell col="33" text="환수&#10;예정액"/>
  360. <Cell col="34" text="환수&#10;예정정산액"/>
  361. <Cell col="35" text="결손액"/>
  362. <Cell col="36" text="입금&#10;건수"/>
  363. <Cell col="37" text="입금액"/>
  364. <Cell col="38" text="추가입금"/>
  365. <Cell col="39" text="전미수금"/>
  366. <Cell col="40" text="미수금"/>
  367. <Cell col="41" text="종결&#10;여부"/>
  368. <Cell col="42" text="청구&#10;접수번호"/>
  369. <Cell col="43" text="입금&#10;접수번호"/>
  370. <Cell col="44" text="환수&#10;접수번호"/>
  371. <Cell col="45" text="환수예정&#10;정산접수번호"/>
  372. <Cell col="46" text="마감월"/>
  373. </Band>
  374. <Band id="body">
  375. <Cell celltype="head" expr="currow+1"/>
  376. <Cell col="1" displaytype="expr:getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'none' : 'date'" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:uncoym" mask="yyyy/MM" enable="false"/>
  377. <Cell col="2" displaytype="expr:getRowLevel(currow) == 0 ? 'combo' : 'text'" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 2 ? '년월소계' : getRowLevel(currow) == 1 ? '' : getRowLevel(currow) == 3 ? '' : insukind" combodataset="ds_cmb_insukind" combocodecol="value" combodatacol="label" enable="false"/>
  378. <Cell col="3" displaytype="expr:getRowLevel(currow) == 0 ? 'combo' : 'text'" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 3 ? '구분합계' : getRowLevel(currow) == 2 ? '' : getRowLevel(currow) == 1 ? '' : clamflag" combodataset="ds_init_P0155list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  379. <Cell col="4" displaytype="expr:getRowLevel(currow) == 0 ? 'combo' : 'text'" style="align:center;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 1 ? '유형합계' : getRowLevel(currow) == 2 ? '' : getRowLevel(currow) == 3 ? '' : ioflag" combodataset="ds_init_P0028list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  380. <Cell col="5" displaytype="combo" style="align:center middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:ordfildcd" combodataset="ds_init_P0458list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  381. <Cell col="6" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:assomark" enable="false"/>
  382. <Cell col="7" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clcnt" enable="false"/>
  383. <Cell col="8" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clmcstotamt" enable="false"/>
  384. <Cell col="9" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clownbamt" enable="false"/>
  385. <Cell col="10" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clclamamt" enable="false"/>
  386. <Cell col="11" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clhandicaprfund" enable="false"/>
  387. <Cell col="12" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clsubtamt" enable="false"/>
  388. <Cell col="13" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrcnt" enable="false"/>
  389. <Cell col="14" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrmcstotamt" enable="false"/>
  390. <Cell col="15" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrjrsltamt" enable="false"/>
  391. <Cell col="16" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrhandicaprfund" enable="false"/>
  392. <Cell col="17" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:jrsubtamt" enable="false"/>
  393. <Cell col="18" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdcnt" enable="false"/>
  394. <Cell col="19" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdadjtrdamt" enable="false"/>
  395. <Cell col="20" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdorgrdamt" enable="false"/>
  396. <Cell col="21" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rdinstrdamt" enable="false"/>
  397. <Cell col="22" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdcnt" enable="false"/>
  398. <Cell col="23" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdmcstotamt" enable="false"/>
  399. <Cell col="24" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdsendamt" enable="false"/>
  400. <Cell col="25" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdjrhandicaprfund" enable="false"/>
  401. <Cell col="26" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:sdsubtamt" enable="false"/>
  402. <Cell col="27" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtcnt" enable="false"/>
  403. <Cell col="28" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtmcstotamt" enable="false"/>
  404. <Cell col="29" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtreteamt" enable="false"/>
  405. <Cell col="30" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rthandicaprfund" enable="false"/>
  406. <Cell col="31" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtsubtamt" enable="false"/>
  407. <Cell col="32" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtnamt" enable="false"/>
  408. <Cell col="33" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtnscheamt" enable="false"/>
  409. <Cell col="34" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:stfrtnamt" enable="false"/>
  410. <Cell col="35" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:lossamt" enable="false"/>
  411. <Cell col="36" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:depocnt" enable="false"/>
  412. <Cell col="37" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:depoamt" enable="false"/>
  413. <Cell col="38" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:adddepoamt" enable="false"/>
  414. <Cell col="39" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:bfuncoamt" enable="false"/>
  415. <Cell col="40" displaytype="number" style="align:right middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:uncoamt" enable="false"/>
  416. <Cell col="41" displaytype="checkbox" edittype="checkbox" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:endyn"/>
  417. <Cell col="42" style="align:left middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:clamacptno" enable="false"/>
  418. <Cell col="43" style="align:left middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:depoacptno" enable="false"/>
  419. <Cell col="44" style="align:left middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:rtnacptno" enable="false"/>
  420. <Cell col="45" style="align:left middle;background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:stfrtnacptno" enable="false"/>
  421. <Cell col="46" displaytype="expr:getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'none' : 'date'" style="background:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');background2:EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff');color:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');color2:EXPR(getRowLevel(currow) == 1 ? '#3333ff' : getRowLevel(currow) == 2 ? '#663300' : getRowLevel(currow) == 3 ? '#008000' : '#000000');font:EXPR(getRowLevel(currow) == 1 || getRowLevel(currow) == 2 || getRowLevel(currow) == 3 ? 'arial,9,bold' : '');" text="bind:endym" mask="yyyy/MM" enable="false"/>
  422. </Band>
  423. <Band id="summary">
  424. <Cell/>
  425. <Cell col="1" style="color:red;color2:red;font:arial,9,bold;" text="총계"/>
  426. <Cell col="2"/>
  427. <Cell col="3"/>
  428. <Cell col="4"/>
  429. <Cell col="5"/>
  430. <Cell col="6"/>
  431. <Cell col="7" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clcnt')"/>
  432. <Cell col="8" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clmcstotamt')"/>
  433. <Cell col="9" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clownbamt')"/>
  434. <Cell col="10" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clclamamt')"/>
  435. <Cell col="11" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clhandicaprfund')"/>
  436. <Cell col="12" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('clsubtamt')"/>
  437. <Cell col="13" displaytype="number" style="align:center middle;color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrcnt')"/>
  438. <Cell col="14" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrmcstotamt')"/>
  439. <Cell col="15" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrjrsltamt')"/>
  440. <Cell col="16" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrhandicaprfund')"/>
  441. <Cell col="17" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('jrsubtamt')"/>
  442. <Cell col="18" displaytype="number" style="align:center middle;color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rdcnt')"/>
  443. <Cell col="19" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rdadjtrdamt')"/>
  444. <Cell col="20" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rdorgrdamt')"/>
  445. <Cell col="21" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rdinstrdamt')"/>
  446. <Cell col="22" displaytype="number" style="align:center middle;color:red;color2:red;font:arial,9,bold;" text="expr:getSum('sdcnt')"/>
  447. <Cell col="23" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('sdmcstotamt')"/>
  448. <Cell col="24" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('sdsendamt')"/>
  449. <Cell col="25" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('sdjrhandicaprfund')"/>
  450. <Cell col="26" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('sdsubtamt')"/>
  451. <Cell col="27" displaytype="number" style="align:center middle;color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtcnt')"/>
  452. <Cell col="28" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtmcstotamt')"/>
  453. <Cell col="29" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtreteamt')"/>
  454. <Cell col="30" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rthandicaprfund')"/>
  455. <Cell col="31" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtsubtamt')"/>
  456. <Cell col="32" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtnamt')"/>
  457. <Cell col="33" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('rtnscheamt')"/>
  458. <Cell col="34" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('stfrtnamt')"/>
  459. <Cell col="35" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('lossamt')"/>
  460. <Cell col="36" displaytype="number" style="align:center middle;color:red;color2:red;font:arial,9,bold;" text="expr:getSum('depocnt')"/>
  461. <Cell col="37" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('depoamt')"/>
  462. <Cell col="38" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('adddepoamt')"/>
  463. <Cell col="39" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('bfuncoamt')"/>
  464. <Cell col="40" displaytype="number" style="color:red;color2:red;font:arial,9,bold;" text="expr:getSum('uncoamt')"/>
  465. <Cell col="41"/>
  466. <Cell col="42"/>
  467. <Cell col="43"/>
  468. <Cell col="44"/>
  469. <Cell col="45"/>
  470. <Cell col="46"/>
  471. </Band>
  472. </Format>
  473. </Formats>
  474. </Grid>
  475. </Layout>
  476. </Layouts>
  477. </Tabpage>
  478. </Tabpages>
  479. </Tab>
  480. <Button position="absolute 1121 61 1201 80" id="btn_excel" class="btn7" taborder="5" text="엑셀저장" anchor="top right" onclick="grp_biz_btn_excel_onclick"/>
  481. <Div position="absolute 404 540 639 660" id="grp_endprcs" anchor="default" style="background:#ffffffff;border:1 solid #808080ff ;">
  482. <Layouts>
  483. <Layout>
  484. <Shape id="roundrect2" type="roundrectangle" class="roundrect_search" position="absolute 0 24 226 84" anchor="default"/>
  485. <Static text="마감처리" position="absolute 1 0 89 23" id="caption1" class="tit_1" anchor="default"/>
  486. <Static text="마감처리월 :" position="absolute 11 32 112 49" id="caption3" class="search_name" anchor="default"/>
  487. <Calendar position="absolute 115 32 212 51" id="input1" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_biz_grp_endprcs_input1_onchanged"/>
  488. <Button position="absolute 59 89 115 111" id="button2" class="btn4" text="확인" anchor="default" onclick="grp_biz_grp_endprcs_button2_onclick"/>
  489. <Button position="absolute 119 89 175 111" id="button3" class="btn4" text="닫기" anchor="default" onclick="grp_biz_grp_endprcs_button3_onclick"/>
  490. <Static text="보험유형 :" position="absolute 11 57 112 74" id="caption12" class="search_name" anchor="default"/>
  491. <Combo position="absolute 115 57 212 76" id="input4" class="combo_search" codecolumn="value" datacolumn="label" anchor="default" innerdataset="@ds_cmb_insukindflag"/>
  492. </Layout>
  493. </Layouts>
  494. </Div>
  495. <Div position="absolute 651 540 886 660" id="grp_endcncl" anchor="default" style="background:#ffffffff;border:1 solid #808080ff ;">
  496. <Layouts>
  497. <Layout>
  498. <Static text="마감취소" position="absolute 1 0 89 23" id="caption5" class="tit_1" anchor="default"/>
  499. <Shape position="absolute 0 24 226 84" id="roundrect3" class="roundrect_search" type="roundrectangle" anchor="default"/>
  500. <Static text="마감취소월 :" position="absolute 13 34 114 51" id="caption7" class="search_name" anchor="default"/>
  501. <Calendar position="absolute 116 31 213 50" id="input2" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  502. <Button position="absolute 64 89 120 111" id="button4" class="btn4" text="확인" anchor="default" onclick="grp_biz_grp_endcncl_button4_onclick"/>
  503. <Button position="absolute 124 89 180 111" id="button5" class="btn4" text="닫기" anchor="default" onclick="grp_biz_grp_endcncl_button5_onclick"/>
  504. <Static text="보험유형 :" position="absolute 13 59 114 76" id="caption13" class="search_name" anchor="default"/>
  505. <Combo position="absolute 116 56 213 75" id="combo1" class="combo_search" codecolumn="value" datacolumn="label" anchor="default" innerdataset="@ds_cmb_insukindflag"/>
  506. </Layout>
  507. </Layouts>
  508. </Div>
  509. <Div position="absolute 943 540 1178 659" id="grp_lastend" anchor="default" style="background:#ffffffff;border:1 solid #808080ff ;">
  510. <Layouts>
  511. <Layout>
  512. <Static text="최종마감" position="absolute 1 0 89 23" id="caption8" class="tit_1" anchor="default"/>
  513. <Shape position="absolute 0 24 226 84" id="roundrect4" class="roundrect_search" type="roundrectangle" anchor="default"/>
  514. <Static text="최종마감월 :" position="absolute 11 33 112 50" id="caption9" class="search_name" anchor="default"/>
  515. <Calendar position="absolute 115 33 212 52" id="input3" class="input_search" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  516. <Button position="absolute 64 89 120 111" id="button6" class="btn4" text="확인" anchor="default" onclick="grp_biz_grp_lastend_button6_onclick"/>
  517. <Button position="absolute 124 89 180 111" id="button7" class="btn4" text="닫기" anchor="default" onclick="grp_biz_grp_lastend_button7_onclick"/>
  518. <Combo position="absolute 115 58 212 77" id="combo2" class="combo_search" codecolumn="value" datacolumn="label" anchor="default" innerdataset="@ds_cmb_insukindflag"/>
  519. <Static text="보험유형 :" position="absolute 11 58 112 75" id="caption14" class="search_name" anchor="default"/>
  520. </Layout>
  521. </Layouts>
  522. </Div>
  523. <Button position="absolute 880 61 944 80" id="button10" class="btn5" text="종결저장" anchor="top right" onclick="grp_biz_button10_onclick"/>
  524. <Button position="absolute 956 61 1009 80" id="button13" class="btn2" text="셀카피" anchor="top right" onclick="grp_biz_button13_onclick"/>
  525. <Button position="absolute 1011 61 1064 80" id="button8" class="btn2" text="열카피" anchor="top right" onclick="grp_biz_button8_onclick"/>
  526. <Button position="absolute 1066 61 1119 80" id="button9" class="btn2" text="행카피" anchor="top right" onclick="grp_biz_button9_onclick"/>
  527. </Layout>
  528. </Layouts>
  529. </Div>
  530. <Div position="absolute 0 675 1199 708" id="grp_btn" anchor="left right bottom">
  531. <Layouts>
  532. <Layout>
  533. <Button position="absolute 1035 5 1115 27" id="btn_endcncl" class="btn4" text="마감취소" anchor="right bottom" onclick="grp_btn_btn_endcncl_onclick"/>
  534. <Button position="absolute 954 5 1034 27" id="btn_endtret" class="btn4" text="마감처리" anchor="right bottom" onclick="grp_btn_btn_endtret_onclick"/>
  535. <Shape position="absolute 1 0 1195 6" linetype="horizontal" id="line32" class="line_6" anchor="left right bottom"/>
  536. <Button position="absolute 1117 5 1197 27" id="btn_lastend" class="btn4" text="최종마감" anchor="right bottom" onclick="grp_btn_btn_lastend_onclick"/>
  537. </Layout>
  538. </Layouts>
  539. </Div>
  540. <Static id="caption6" text="미수월마감 내역 조회" class="tit_1" position="absolute 1 0 225 23"/>
  541. </Layout>
  542. </Layouts>
  543. <Objects>
  544. <Dataset id="ds_main_uncomonthendinsu" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  545. <ColumnInfo>
  546. <Column id="uncoym" type="STRING" size="256" sumtext="미수년월" prop="KEY"/>
  547. <Column id="insukind" type="STRING" size="256" sumtext="년월소계" prop="TEXT"/>
  548. <Column id="clamflag" type="STRING" size="256" sumtext="구분합계" prop="TEXT"/>
  549. <Column id="ioflag" type="STRING" size="256" prop="TEXT" sumtext="유형합계"/>
  550. <Column id="ordfildcd" type="STRING" size="256" sumtext="청구분야"/>
  551. <Column id="clcnt" type="BIGDECIMAL" size="256" sumtext="청구건수" prop="SUM"/>
  552. <Column id="clmcstotamt" type="BIGDECIMAL" size="256" sumtext="총진료비" prop="SUM"/>
  553. <Column id="clownbamt" type="BIGDECIMAL" size="256" sumtext="본인부담금" prop="SUM"/>
  554. <Column id="clclamamt" type="BIGDECIMAL" size="256" sumtext="청구액" prop="SUM"/>
  555. <Column id="clownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="상한액" prop="SUM"/>
  556. <Column id="clsuppamt" type="BIGDECIMAL" size="256" sumtext="지원금" prop="SUM"/>
  557. <Column id="clhandicaprfund" type="BIGDECIMAL" size="256" sumtext="장애인" prop="SUM"/>
  558. <Column id="jrcnt" type="BIGDECIMAL" size="256" sumtext="심결건수" prop="SUM"/>
  559. <Column id="jrmcstotamt" type="BIGDECIMAL" size="256" sumtext="심결총진료비" prop="SUM"/>
  560. <Column id="jrjrsltamt" type="BIGDECIMAL" size="256" sumtext="심사결정액" prop="SUM"/>
  561. <Column id="jrownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="심결상한액" prop="SUM"/>
  562. <Column id="jrsuppamt" type="BIGDECIMAL" size="256" sumtext="심결지원금" prop="SUM"/>
  563. <Column id="jrhandicaprfund" type="BIGDECIMAL" size="256" sumtext="심결장애인" prop="SUM"/>
  564. <Column id="rdcnt" type="BIGDECIMAL" size="256" sumtext="삭감건수" prop="SUM"/>
  565. <Column id="rdadjtrdamt" type="BIGDECIMAL" size="256" sumtext="조정삭감액" prop="SUM"/>
  566. <Column id="rdorgrdamt" type="BIGDECIMAL" size="256" sumtext="실삭감액" prop="SUM"/>
  567. <Column id="sdcnt" type="BIGDECIMAL" size="256" sumtext="반송건수" prop="SUM"/>
  568. <Column id="sdmcstotamt" type="BIGDECIMAL" size="256" sumtext="반송총진료비" prop="SUM"/>
  569. <Column id="sdsendamt" type="BIGDECIMAL" size="256" sumtext="반송액" prop="SUM"/>
  570. <Column id="sdjrownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="반송상한액(심결)" prop="SUM"/>
  571. <Column id="sdjrsuppamt" type="BIGDECIMAL" size="256" sumtext="반송지원금(심결)" prop="SUM"/>
  572. <Column id="sdjrhandicaprfund" type="BIGDECIMAL" size="256" sumtext="반송장애인(심결)" prop="SUM"/>
  573. <Column id="sdjudgdeciamt" type="BIGDECIMAL" size="256" sumtext="지급반송액" prop="SUM"/>
  574. <Column id="sdownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="반송상한액" prop="SUM"/>
  575. <Column id="sdsuppamt" type="BIGDECIMAL" size="256" sumtext="반송지원금" prop="SUM"/>
  576. <Column id="sdhandicaprfund" type="BIGDECIMAL" size="256" sumtext="반송장애인" prop="SUM"/>
  577. <Column id="rtcnt" type="BIGDECIMAL" size="256" sumtext="보류건수" prop="SUM"/>
  578. <Column id="rtmcstotamt" type="BIGDECIMAL" size="256" sumtext="보류총진료비" prop="SUM"/>
  579. <Column id="rtreteamt" type="BIGDECIMAL" size="256" sumtext="보류액" prop="SUM"/>
  580. <Column id="rtownbmaxexamt" type="BIGDECIMAL" size="256" sumtext="보류상한액" prop="SUM"/>
  581. <Column id="rtsuppamt" type="BIGDECIMAL" size="256" sumtext="보류지원금" prop="SUM"/>
  582. <Column id="rthandicaprfund" type="BIGDECIMAL" size="256" sumtext="보류장애인" prop="SUM"/>
  583. <Column id="rtnamt" type="BIGDECIMAL" size="256" sumtext="환수액" prop="SUM"/>
  584. <Column id="rtnscheamt" type="BIGDECIMAL" size="256" sumtext="환수예정액" prop="SUM"/>
  585. <Column id="stfrtnamt" type="BIGDECIMAL" size="256" sumtext="환수예정정산액" prop="SUM"/>
  586. <Column id="lossamt" type="BIGDECIMAL" size="256" sumtext="결손액" prop="SUM"/>
  587. <Column id="depocnt" type="BIGDECIMAL" size="256" sumtext="입금건수" prop="SUM"/>
  588. <Column id="depoamt" type="BIGDECIMAL" size="256" sumtext="입금액" prop="SUM"/>
  589. <Column id="adddepoamt" type="BIGDECIMAL" size="256" sumtext="추가입금" prop="SUM"/>
  590. <Column id="bfuncoamt" type="BIGDECIMAL" size="256" sumtext="전미수금" prop="SUM"/>
  591. <Column id="uncoamt" type="BIGDECIMAL" size="256" sumtext="미수금" prop="SUM"/>
  592. <Column id="endyn" type="STRING" size="256" sumtext="종결여부"/>
  593. <Column id="endym" type="STRING" size="256" sumtext="마감월"/>
  594. <Column id="clamacptno" type="STRING" size="256" sumtext="청구접수번호"/>
  595. <Column id="depoacptno" type="STRING" size="256" sumtext="입금접수번호"/>
  596. <Column id="rtnacptno" type="STRING" size="256" sumtext="환수접수번호"/>
  597. <Column id="stfrtnacptno" type="STRING" size="256" sumtext="환수예정정산접수번호"/>
  598. </ColumnInfo>
  599. </Dataset>
  600. <Dataset id="ds_main_uncomonthendproc" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  601. <ColumnInfo>
  602. <Column id="uncoym" type="STRING" size="256" sumtext="미수년월" prop="KEY"/>
  603. <Column id="insukind" type="STRING" size="256" sumtext="년월소계" prop="TEXT"/>
  604. <Column id="clamflag" type="STRING" size="256" sumtext="구분합계" prop="TEXT"/>
  605. <Column id="ioflag" type="STRING" size="256" sumtext="유형합계" prop="TEXT"/>
  606. <Column id="ordfildcd" type="STRING" size="256" sumtext="청구분야"/>
  607. <Column id="assomark" type="STRING" size="256" sumtext="시도"/>
  608. <Column id="clcnt" type="BIGDECIMAL" size="256" sumtext="청구건수"/>
  609. <Column id="clmcstotamt" type="BIGDECIMAL" size="256" sumtext="총진료비"/>
  610. <Column id="clownbamt" type="BIGDECIMAL" size="256" sumtext="본인부담금"/>
  611. <Column id="clclamamt" type="BIGDECIMAL" size="256" sumtext="청구액"/>
  612. <Column id="clhandicaprfund" type="BIGDECIMAL" size="256" sumtext="장애인"/>
  613. <Column id="clsubtamt" type="BIGDECIMAL" size="256" sumtext="대불금"/>
  614. <Column id="jrcnt" type="BIGDECIMAL" size="256" sumtext="심결건수"/>
  615. <Column id="jrmcstotamt" type="BIGDECIMAL" size="256" sumtext="심결총진료비"/>
  616. <Column id="jrjrsltamt" type="BIGDECIMAL" size="256" sumtext="심사결정액"/>
  617. <Column id="jrhandicaprfund" type="BIGDECIMAL" size="256" sumtext="심결장애인"/>
  618. <Column id="jrsubtamt" type="BIGDECIMAL" size="256" sumtext="심결대불금"/>
  619. <Column id="rdcnt" type="BIGDECIMAL" size="256" sumtext="삭감건수"/>
  620. <Column id="rdadjtrdamt" type="BIGDECIMAL" size="256" sumtext="조정삭감액"/>
  621. <Column id="rdorgrdamt" type="BIGDECIMAL" size="256" sumtext="실삭감액"/>
  622. <Column id="rdinstrdamt" type="BIGDECIMAL" size="256" sumtext="기관삭감액"/>
  623. <Column id="sdcnt" type="BIGDECIMAL" size="256" sumtext="반송건수"/>
  624. <Column id="sdmcstotamt" type="BIGDECIMAL" size="256" sumtext="반송총진료비"/>
  625. <Column id="sdsendamt" type="BIGDECIMAL" size="256" sumtext="반송액"/>
  626. <Column id="sdjrhandicaprfund" type="BIGDECIMAL" size="256" sumtext="반송장애인(심결)"/>
  627. <Column id="sdsubtamt" type="BIGDECIMAL" size="256" sumtext="반송대불금"/>
  628. <Column id="rtcnt" type="BIGDECIMAL" size="256" sumtext="보류건수"/>
  629. <Column id="rtmcstotamt" type="BIGDECIMAL" size="256" sumtext="보류총진료비"/>
  630. <Column id="rtreteamt" type="BIGDECIMAL" size="256" sumtext="보류액"/>
  631. <Column id="rthandicaprfund" type="BIGDECIMAL" size="256" sumtext="보류장애인"/>
  632. <Column id="rtsubtamt" type="BIGDECIMAL" size="256" sumtext="보류대불금"/>
  633. <Column id="rtnamt" type="BIGDECIMAL" size="256" sumtext="환수액"/>
  634. <Column id="rtnscheamt" type="BIGDECIMAL" size="256" sumtext="환수예정액"/>
  635. <Column id="stfrtnamt" type="BIGDECIMAL" size="256" sumtext="환수예정정산액"/>
  636. <Column id="lossamt" type="BIGDECIMAL" size="256" sumtext="결손액"/>
  637. <Column id="depocnt" type="BIGDECIMAL" size="256" sumtext="입금건수"/>
  638. <Column id="depoamt" type="BIGDECIMAL" size="256" sumtext="입금액"/>
  639. <Column id="adddepoamt" type="BIGDECIMAL" size="256" sumtext="추가입금"/>
  640. <Column id="bfuncoamt" type="BIGDECIMAL" size="256" sumtext="전미수금"/>
  641. <Column id="uncoamt" type="BIGDECIMAL" size="256" sumtext="미수금"/>
  642. <Column id="endyn" type="STRING" size="256" sumtext="종결여부"/>
  643. <Column id="endym" type="STRING" size="256" sumtext="마감월"/>
  644. <Column id="clamacptno" type="STRING" size="256" sumtext="청구접수번호"/>
  645. <Column id="depoacptno" type="STRING" size="256" sumtext="입금접수번호"/>
  646. <Column id="rtnacptno" type="STRING" size="256" sumtext="환수접수번호"/>
  647. <Column id="stfrtnacptno" type="STRING" size="256" sumtext="환수예정정산접수번호"/>
  648. </ColumnInfo>
  649. </Dataset>
  650. <Dataset id="ds_send_uncoendmonth" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  651. <ColumnInfo>
  652. <Column id="endmonthfrom" type="STRING" size="256"/>
  653. <Column id="endmonthto" type="STRING" size="256"/>
  654. <Column id="insukindflag" type="STRING" size="256"/>
  655. <Column id="subtotalflag" type="STRING" size="256"/>
  656. </ColumnInfo>
  657. <Rows>
  658. <Row/>
  659. </Rows>
  660. </Dataset>
  661. <Dataset id="ds_send_uncoendprcs" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  662. <ColumnInfo>
  663. <Column id="flag" type="STRING" size="256"/>
  664. <Column id="month" type="STRING" size="256"/>
  665. <Column id="insukindflag" type="STRING" size="256"/>
  666. </ColumnInfo>
  667. <Rows>
  668. <Row>
  669. <Col id="insukindflag">1</Col>
  670. </Row>
  671. </Rows>
  672. </Dataset>
  673. <Dataset id="ds_send_getupdatedatalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  674. <ColumnInfo>
  675. <Column id="getupdatedata" type="STRING" size="256"/>
  676. </ColumnInfo>
  677. <Rows>
  678. <Row/>
  679. </Rows>
  680. </Dataset>
  681. <Dataset id="ds_rdo_insukindflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  682. <ColumnInfo>
  683. <Column id="label" type="STRING" size="256"/>
  684. <Column id="value" type="STRING" size="256"/>
  685. </ColumnInfo>
  686. <Rows>
  687. <Row>
  688. <Col id="label">보험</Col>
  689. <Col id="value">11</Col>
  690. </Row>
  691. <Row>
  692. <Col id="label">보호</Col>
  693. <Col id="value">20</Col>
  694. </Row>
  695. <Row>
  696. <Col id="label">산재</Col>
  697. <Col id="value">41</Col>
  698. </Row>
  699. </Rows>
  700. </Dataset>
  701. <Dataset id="ds_cmb_subtotalflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  702. <ColumnInfo>
  703. <Column id="label" type="STRING" size="256"/>
  704. <Column id="value" type="STRING" size="256"/>
  705. </ColumnInfo>
  706. <Rows>
  707. <Row>
  708. <Col id="label">미수년월-청구구분-입원외래</Col>
  709. <Col id="value">1</Col>
  710. </Row>
  711. <Row>
  712. <Col id="label">미수년월-입원외래</Col>
  713. <Col id="value">2</Col>
  714. </Row>
  715. </Rows>
  716. </Dataset>
  717. <Dataset id="ds_init_P0421list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  718. <ColumnInfo>
  719. <Column id="cdid" type="STRING" size="256"/>
  720. <Column id="cdnm" type="STRING" size="256"/>
  721. </ColumnInfo>
  722. <Rows>
  723. <Row/>
  724. </Rows>
  725. </Dataset>
  726. <Dataset id="ds_init_P0155list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  727. <ColumnInfo>
  728. <Column id="cdnm" type="STRING" size="256"/>
  729. <Column id="cdid" type="STRING" size="256"/>
  730. </ColumnInfo>
  731. <Rows>
  732. <Row/>
  733. </Rows>
  734. </Dataset>
  735. <Dataset id="ds_init_P0028list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  736. <ColumnInfo>
  737. <Column id="cdnm" type="STRING" size="256"/>
  738. <Column id="cdid" type="STRING" size="256"/>
  739. </ColumnInfo>
  740. <Rows>
  741. <Row/>
  742. </Rows>
  743. </Dataset>
  744. <Dataset id="ds_init_P0458list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  745. <ColumnInfo>
  746. <Column id="cdid" type="STRING" size="256"/>
  747. <Column id="cdnm" type="STRING" size="256"/>
  748. </ColumnInfo>
  749. <Rows>
  750. <Row/>
  751. </Rows>
  752. </Dataset>
  753. <Dataset id="ds_cmb_insukind" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  754. <ColumnInfo>
  755. <Column id="label" type="STRING" size="256"/>
  756. <Column id="value" type="STRING" size="256"/>
  757. </ColumnInfo>
  758. <Rows>
  759. <Row>
  760. <Col id="label">보험</Col>
  761. <Col id="value">1</Col>
  762. </Row>
  763. <Row>
  764. <Col id="label">보호</Col>
  765. <Col id="value">4</Col>
  766. </Row>
  767. <Row>
  768. <Col id="label">보호</Col>
  769. <Col id="value">4</Col>
  770. </Row>
  771. <Row>
  772. <Col id="label">산재</Col>
  773. <Col id="value">6</Col>
  774. </Row>
  775. </Rows>
  776. </Dataset>
  777. <Dataset id="ds_main_check_uncomonthend" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  778. <ColumnInfo>
  779. <Column id="checkyn" type="STRING" size="256" sumtext="처리여부"/>
  780. <Column id="monthcheckyn" type="STRING" size="256" sumtext="전달처리여부"/>
  781. <Column id="cancelcheckyn" type="STRING" size="256" sumtext="취소체크"/>
  782. <Column id="maxendym" type="STRING" size="256" sumtext="최종마감월"/>
  783. </ColumnInfo>
  784. <Rows>
  785. <Row/>
  786. </Rows>
  787. </Dataset>
  788. <Dataset id="ds_cmb_insukindflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  789. <ColumnInfo>
  790. <Column id="label" type="STRING" size="256"/>
  791. <Column id="value" type="STRING" size="256"/>
  792. </ColumnInfo>
  793. <Rows>
  794. <Row>
  795. <Col id="label">보험</Col>
  796. <Col id="value">1</Col>
  797. </Row>
  798. <Row>
  799. <Col id="label">보호</Col>
  800. <Col id="value">4</Col>
  801. </Row>
  802. <Row>
  803. <Col id="label">산재</Col>
  804. <Col id="value">6</Col>
  805. </Row>
  806. </Rows>
  807. </Dataset>
  808. </Objects>
  809. <Bind>
  810. <BindItem id="item0" compid="grp_biz.grp_sea.ipt_endmonthfrom" propid="value" datasetid="ds_send_uncoendmonth" columnid="endmonthfrom"/>
  811. <BindItem id="item1" compid="grp_biz.grp_sea.ipt_endmonthto" propid="value" datasetid="ds_send_uncoendmonth" columnid="endmonthto"/>
  812. <BindItem id="item2" compid="grp_biz.grp_sea.rdo_insukindflag" propid="value" datasetid="ds_send_uncoendmonth" columnid="insukindflag"/>
  813. <BindItem id="item3" compid="grp_biz.grp_sea.cmb_subtotalflag" propid="value" datasetid="ds_send_uncoendmonth" columnid="subtotalflag"/>
  814. <BindItem id="item4" compid="grp_biz.grp_endprcs.input1" propid="value" datasetid="ds_send_uncoendprcs" columnid="month"/>
  815. <BindItem id="item5" compid="grp_biz.grp_endprcs.input4" propid="value" datasetid="ds_send_uncoendprcs" columnid="insukindflag"/>
  816. <BindItem id="item6" compid="grp_biz.grp_endcncl.input2" propid="value" datasetid="ds_send_uncoendprcs" columnid="month"/>
  817. <BindItem id="item7" compid="grp_biz.grp_endcncl.combo1" propid="value" datasetid="ds_send_uncoendprcs" columnid="insukindflag"/>
  818. <BindItem id="item8" compid="grp_biz.grp_lastend.input3" propid="value" datasetid="ds_send_uncoendprcs" columnid="month"/>
  819. <BindItem id="item9" compid="grp_biz.grp_lastend.combo2" propid="value" datasetid="ds_send_uncoendprcs" columnid="insukindflag"/>
  820. </Bind>
  821. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  822. * System Name :
  823. * Job Name :
  824. * Creator :
  825. * Make Date : 2016-05-24
  826. * Description :
  827. *---------------------------------------------------------------------------------------
  828. * Modify Date Modifier Modify Description
  829. *---------------------------------------------------------------------------------------
  830. * 2016-05-24 Live Converter TF->XP
  831. *
  832. *---------------------------------------------------------------------------------------
  833. ****************************************************************************************/
  834. include "com_commonxp::comm_main.xjs";
  835. include "pam_pamcomnxp::PAM001.xjs";
  836. include "pam_pamcomnxp::PAM.xjs";
  837. var col = "N";
  838. var arow = new Array();
  839. function SMPIF31300_oninit(obj:Form, e:InitEventInfo)
  840. {
  841. frmf_initForm(obj);
  842. }
  843. function SMPIF31300_onload(obj:Form, e:LoadEventInfo)
  844. {
  845. fInitialize();
  846. }
  847. function fInitialize()
  848. {
  849. grdf_setToolTipBind(grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu);
  850. grdf_setToolTipBind(grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc);
  851. grp_biz.grp_endcncl.visible = false;
  852. grp_biz.grp_endprcs.visible = false;
  853. grp_biz.grp_lastend.visible = false;
  854. var endmonth = utlf_getCurrentDate();
  855. var yearmonth = String(endmonth).substr(0,6);
  856. ds_send_uncoendmonth.setColumn(0, "endmonthfrom", yearmonth);
  857. ds_send_uncoendmonth.setColumn(0, "endmonthto", yearmonth);
  858. grp_biz.grp_sea.rdo_insukindflag.index = 0;
  859. grp_biz.grp_endprcs.input4.index = 0;
  860. grp_biz.grp_endcncl.combo1.index = 0;
  861. grp_biz.grp_lastend.combo2.index = 0;
  862. grp_biz.switch1.tabindex = 0;
  863. var arrParam = [{dsNm: "ds_init_P0421list", cdGrpId: "P0421"}
  864. ,{dsNm: "ds_init_P0155list", cdGrpId: "P0155"}
  865. ,{dsNm: "ds_init_P0028list", cdGrpId: "P0028"}
  866. ,{dsNm: "ds_init_P0458list", cdGrpId: "P0458"}]
  867. appf_getCodeList(arrParam);
  868. pamGetDeptCDDrIDList();
  869. }
  870. //조회
  871. function grp_biz_grp_sea_button1_onclick(obj:Button, e:ClickEventInfo)
  872. {
  873. var endmonthfrom = ds_send_uncoendmonth.getColumn(0, "endmonthfrom");
  874. var endmonthto = ds_send_uncoendmonth.getColumn(0, "endmonthto");
  875. if(utlf_isNull(endmonthfrom) && utlf_isNull(endmonthto))
  876. {
  877. sysf_messageBox("마감월을","C001");
  878. return false;
  879. }
  880. var oParam = {};
  881. oParam.id = "TRPIF31301";
  882. oParam.service = "clamuncoapp.ClamUnco";
  883. oParam.method = "reqGetUncoMonthEnd";
  884. oParam.inds = "req=ds_send_uncoendmonth";
  885. oParam.outds = "ds_main_uncomonthendinsu=uncomonthendinsu ds_main_uncomonthendproc=uncomonthendproc";
  886. oParam.async = false;
  887. //oParam.callback = "cf_TRPIF31301";
  888. tranf_submit(oParam);
  889. var insukindflag = ds_send_uncoendmonth.getColumn(0, "insukindflag");
  890. var subtotalflag = ds_send_uncoendmonth.getColumn(0, "subtotalflag");
  891. if(insukindflag == "11" || insukindflag == "41")
  892. {
  893. if(subtotalflag == "1")
  894. {
  895. ds_main_uncomonthendinsu.keystring= "G:uncoym,clamflag,ioflag";
  896. }
  897. else
  898. {
  899. ds_main_uncomonthendinsu.keystring= "G:uncoym,ioflag";
  900. }
  901. }
  902. if(insukindflag == "20")
  903. {
  904. if(subtotalflag == "1")
  905. {
  906. ds_main_uncomonthendproc.keystring= "G:uncoym,clamflag,ioflag";
  907. }
  908. else
  909. {
  910. ds_main_uncomonthendproc.keystring= "G:uncoym,ioflag";
  911. }
  912. }
  913. }
  914. function grp_biz_grp_sea_rdo_insukindflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  915. {
  916. var insukindflag = ds_send_uncoendmonth.getColumn(0, "insukindflag");
  917. if(insukindflag == "11" || insukindflag == "41" )
  918. {
  919. grp_biz.switch1.tabindex = 0;
  920. }
  921. else
  922. {
  923. grp_biz.switch1.tabindex = 1;
  924. }
  925. }
  926. //엑셀저장
  927. function grp_biz_btn_excel_onclick(obj:Button, e:ClickEventInfo)
  928. {
  929. if(grp_biz.grp_sea.rdo_insukindflag.value == 11 || grp_biz.grp_sea.rdo_insukindflag.value == 41)
  930. {
  931. var today = utlf_getCurrentDate();
  932. if (ds_main_uncomonthendinsu.rowcount > 0)
  933. {
  934. grdf_exportExcel(grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu, "미수월마감내역조회-미수월마감내역(보험+산재)_ "+today, "see");
  935. }
  936. else
  937. {
  938. sysf_messageBox("엑셀저장할 내역이", "I004");
  939. }
  940. }
  941. else
  942. {
  943. var today = utlf_getCurrentDate();
  944. if (ds_main_uncomonthendproc.rowcount > 0)
  945. {
  946. grdf_exportExcel(grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc, "미수월마감내역조회-미수월마감내역(보호)_ "+today, "see");
  947. }
  948. else
  949. {
  950. sysf_messageBox("엑셀저장할 내역이", "I004");
  951. }
  952. }
  953. }
  954. function grp_biz_switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
  955. {
  956. if(obj.tabindex == 0)
  957. {
  958. ds_send_uncoendmonth.setColumn(0, "insukindflag", "11");
  959. }
  960. else if(obj.tabindex == 1)
  961. {
  962. ds_send_uncoendmonth.setColumn(0, "insukindflag", "20");
  963. }
  964. }
  965. //마감처리확인
  966. function grp_biz_grp_endprcs_button2_onclick(obj:Button, e:ClickEventInfo)
  967. {
  968. if(utlf_isNull(grp_biz.grp_endprcs.input1.value))
  969. {
  970. sysf_messageBox("마감처리월은","I003");
  971. return;
  972. }
  973. ds_main_check_uncomonthend.clearData();
  974. var oParam = {};
  975. oParam.id = "TRPIF31302";
  976. oParam.service = "clamuncoapp.ClamUnco";
  977. oParam.method = "reqGetUncoMonthEndCheck";
  978. oParam.inds = "req=ds_send_uncoendprcs";
  979. oParam.outds = "ds_main_check_uncomonthend=uncomonthend";
  980. oParam.async = false;
  981. //oParam.callback = "cf_TRPIF31302";
  982. tranf_submit(oParam);
  983. if(ds_main_check_uncomonthend.getColumn(0, "checkyn") == "Y")
  984. {
  985. sysf_messageBox("마감처리월에 이미 마감처리한 데이터가 존재합니다. 기존 마감데이터 마감취소 후 마감처리 ","I006"); // 가능합니다.
  986. return;
  987. }
  988. if(ds_main_check_uncomonthend.getColumn(0, "monthcheckyn") != "Y")
  989. {
  990. var rtnval;
  991. rtnval = sysf_messageBox("전월 마감처리 내역이 없습니다. 전월 마감처리 후 당월 마감처리 가능합니다.\n 강제로 실행","S001");
  992. if ( rtnval != "6" )
  993. {
  994. return;
  995. }
  996. }
  997. ds_send_uncoendprcs.setColumn(0, "flag", "1");
  998. var oParam = {};
  999. oParam.id = "TRPIF31302";
  1000. oParam.service = "clamuncoapp.ClamUnco";
  1001. oParam.method = "reqSetUncoMonthEndPrcs";
  1002. oParam.inds = "req=ds_send_uncoendprcs";
  1003. oParam.outds = "";
  1004. oParam.async = false;
  1005. oParam.callback = "cf_TRPIF31302";
  1006. tranf_submit(oParam);
  1007. }
  1008. function cf_TRPIF31302()
  1009. {
  1010. grp_biz_grp_sea_button1_onclick();
  1011. }
  1012. function grp_biz_grp_endprcs_button3_onclick(obj:Button, e:ClickEventInfo)
  1013. {
  1014. grp_biz.grp_endprcs.visible = false;
  1015. }
  1016. //마감취소확인
  1017. function grp_biz_grp_endcncl_button4_onclick(obj:Button, e:ClickEventInfo)
  1018. {
  1019. if(utlf_isNull(grp_biz.grp_endcncl.input2.value))
  1020. {
  1021. sysf_messageBox("마감취소월은","I003");
  1022. return;
  1023. }
  1024. ds_main_check_uncomonthend.clearData();
  1025. var oParam = {};
  1026. oParam.id = "TRPIF31302";
  1027. oParam.service = "clamuncoapp.ClamUnco";
  1028. oParam.method = "reqGetUncoMonthEndCheck";
  1029. oParam.inds = "req=ds_send_uncoendprcs";
  1030. oParam.outds = "ds_main_check_uncomonthend=uncomonthend";
  1031. oParam.async = false;
  1032. //oParam.callback = "cf_TRPIF31302";
  1033. tranf_submit(oParam);
  1034. if(ds_main_check_uncomonthend.getColumn(0, "cancelcheckyn") == "Y")
  1035. {
  1036. sysf_messageBox("다음달 마감처리 내역이 존재하는 데이터는 취소","E001");
  1037. return;
  1038. }
  1039. ds_send_uncoendprcs.setColumn(0, "flag", "2");
  1040. var oParam = {};
  1041. oParam.id = "TRPIF31302";
  1042. oParam.service = "clamuncoapp.ClamUnco";
  1043. oParam.method = "reqSetUncoMonthEndPrcs";
  1044. oParam.inds = "req=ds_send_uncoendprcs";
  1045. oParam.outds = "";
  1046. oParam.async = false;
  1047. oParam.callback = "cf_TRPIF31302";
  1048. tranf_submit(oParam);
  1049. }
  1050. function cf_TRPIF31302()
  1051. {
  1052. grp_biz_grp_sea_button1_onclick();
  1053. }
  1054. function grp_biz_grp_endcncl_button5_onclick(obj:Button, e:ClickEventInfo)
  1055. {
  1056. grp_biz.grp_endcncl.visible = false;
  1057. }
  1058. //최종마감
  1059. function grp_biz_grp_lastend_button6_onclick(obj:Button, e:ClickEventInfo)
  1060. {
  1061. if(utlf_isNull(grp_biz.grp_lastend.input3.value))
  1062. {
  1063. sysf_messageBox("최종마감월은","I003");
  1064. return;
  1065. }
  1066. ds_send_uncoendprcs.setColumn(0, "flag", "3");
  1067. var oParam = {};
  1068. oParam.id = "TRPIF31302";
  1069. oParam.service = "clamuncoapp.ClamUnco";
  1070. oParam.method = "reqSetUncoMonthEndPrcs";
  1071. oParam.inds = "req=ds_send_uncoendprcs";
  1072. oParam.outds = "";
  1073. oParam.async = false;
  1074. //oParam.callback = "cf_TRPIF31302";
  1075. tranf_submit(oParam);
  1076. }
  1077. function grp_biz_grp_lastend_button7_onclick(obj:Button, e:ClickEventInfo)
  1078. {
  1079. grp_biz.grp_lastend.visible = false;
  1080. }
  1081. //마감처리
  1082. function grp_btn_btn_endtret_onclick(obj:Button, e:ClickEventInfo)
  1083. {
  1084. grp_biz.grp_endcncl.visible= false;
  1085. grp_biz.grp_endprcs.visible = true;
  1086. grp_biz.grp_lastend.visible= false;
  1087. }
  1088. //마감취소
  1089. function grp_btn_btn_endcncl_onclick(obj:Button, e:ClickEventInfo)
  1090. {
  1091. grp_biz.grp_endcncl.visible= true;
  1092. grp_biz.grp_endprcs.visible = false;
  1093. grp_biz.grp_lastend.visible= false;
  1094. }
  1095. //최종마감
  1096. function grp_btn_btn_lastend_onclick(obj:Button, e:ClickEventInfo)
  1097. {
  1098. grp_biz.grp_endcncl.visible= false;
  1099. grp_biz.grp_endprcs.visible = false;
  1100. grp_biz.grp_lastend.visible= true;
  1101. }
  1102. //종결저장
  1103. function grp_biz_button10_onclick(obj:Button, e:ClickEventInfo)
  1104. {
  1105. var insuflag = ds_send_uncoendmonth.getColumn(0, "insukindflag");
  1106. if(insuflag == "11" || insuflag == "41")
  1107. {
  1108. var oParam = {};
  1109. oParam.id = "TXPIF31302";
  1110. oParam.service = "clamuncoapp.ClamUnco";
  1111. oParam.method = "reqSetUncoMonthEndInsuEndYN";
  1112. oParam.inds = "req=ds_main_uncomonthendinsu:U";
  1113. oParam.outds = "";
  1114. oParam.async = false;
  1115. //oParam.callback = "cf_TXPIF31302";
  1116. tranf_submit(oParam);
  1117. }
  1118. else
  1119. {
  1120. var oParam = {};
  1121. oParam.id = "TXPIF31302";
  1122. oParam.service = "clamuncoapp.ClamUnco";
  1123. oParam.method = "reqSetUncoMonthEndInsuEndYN";
  1124. oParam.inds = "req=ds_main_uncomonthendproc:U";
  1125. oParam.outds = "";
  1126. oParam.async = false;
  1127. //oParam.callback = "cf_TXPIF31302";
  1128. tranf_submit(oParam);
  1129. }
  1130. var oParam = {};
  1131. oParam.id = "TRPIF31301";
  1132. oParam.service = "clamuncoapp.ClamUnco";
  1133. oParam.method = "reqGetUncoMonthEnd";
  1134. oParam.inds = "req=ds_send_uncoendmonth";
  1135. oParam.outds = "ds_main_uncomonthendinsu=uncomonthendinsu ds_main_uncomonthendproc=uncomonthendproc";
  1136. oParam.async = false;
  1137. //oParam.callback = "cf_TRPIF31301";
  1138. tranf_submit(oParam);
  1139. var insukindflag = ds_send_uncoendmonth.getColumn(0, "insukindflag");
  1140. var subtotalflag = ds_send_uncoendmonth.getColumn(0, "subtotalflag");
  1141. if(insukindflag == "11" || insuflag == "41")
  1142. {
  1143. if(subtotalflag == "1")
  1144. {
  1145. ds_main_uncomonthendinsu.keystring= "G:uncoym,ioflag,clamflag";
  1146. }
  1147. else
  1148. {
  1149. ds_main_uncomonthendinsu.keystring= "G:uncoym,ioflag";
  1150. }
  1151. }
  1152. if(insukindflag == "20")
  1153. {
  1154. if(subtotalflag == "1")
  1155. {
  1156. ds_main_uncomonthendproc.keystring= "G:uncoym,ioflag,clamflag";
  1157. }
  1158. else
  1159. {
  1160. ds_main_uncomonthendproc.keystring= "G:uncoym,ioflag";
  1161. }
  1162. }
  1163. }
  1164. function grp_biz_button13_onclick(obj:Button, e:ClickEventInfo)
  1165. {
  1166. col = "N";
  1167. if(grp_biz.switch1.tabindex == 0)
  1168. {
  1169. var sExprBack = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1170. for(var i = 1; i < 53; i++)
  1171. {
  1172. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background", sExprBack);
  1173. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background2", sExprBack);
  1174. }
  1175. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.selecttype = "area";
  1176. }
  1177. else if(grp_biz.switch1.tabindex == 1)
  1178. {
  1179. var sExprBack = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1180. for(var i = 1; i < 53; i++)
  1181. {
  1182. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background", sExprBack);
  1183. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background2", sExprBack);
  1184. }
  1185. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.selecttype = "area";
  1186. }
  1187. }
  1188. function grp_biz_button8_onclick(obj:Button, e:ClickEventInfo)
  1189. {
  1190. col = "Y";
  1191. if(grp_biz.switch1.tabindex == 0)
  1192. {
  1193. var sExprBack = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1194. for(var i = 1; i < 53; i++)
  1195. {
  1196. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background", sExprBack);
  1197. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background2", sExprBack);
  1198. }
  1199. }
  1200. else if(grp_biz.switch1.tabindex == 1)
  1201. {
  1202. var sExprBack = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1203. for(var i = 1; i < 53; i++)
  1204. {
  1205. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background", sExprBack);
  1206. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background2", sExprBack);
  1207. }
  1208. }
  1209. }
  1210. function grp_biz_button9_onclick(obj:Button, e:ClickEventInfo)
  1211. {
  1212. col = "N";
  1213. if(grp_biz.switch1.tabindex == 0)
  1214. {
  1215. var sExprBack = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1216. for(var i = 1; i < 53; i++)
  1217. {
  1218. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background", sExprBack);
  1219. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background2", sExprBack);
  1220. }
  1221. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.selecttype = "row";
  1222. }
  1223. else if(grp_biz.switch1.tabindex == 1)
  1224. {
  1225. var sExprBack = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1226. for(var i = 1; i < 53; i++)
  1227. {
  1228. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background", sExprBack);
  1229. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background2", sExprBack);
  1230. }
  1231. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.selecttype = "row";
  1232. }
  1233. }
  1234. function grp_biz_switch1_case_uncomonthendinsu_grd_uncomonthendinsu_onkeydown(obj:Grid, e:KeyEventInfo)
  1235. {
  1236. if(e.ctrlKey && e.keycode == 67)
  1237. {
  1238. if(arow.length > 0)
  1239. {
  1240. system.setClipboard("CF_TEXT", arow);
  1241. }
  1242. else
  1243. {
  1244. grdf_clipboardCopy(grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu, "PAM");
  1245. }
  1246. }
  1247. }
  1248. function grp_biz_switch1_case_uncomonthendproc_grd_uncomonthendproc_onkeydown(obj:Grid, e:KeyEventInfo)
  1249. {
  1250. if(e.ctrlKey && e.keycode == 67)
  1251. {
  1252. grdf_clipboardCopy(grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc, "PAM");
  1253. }
  1254. }
  1255. function grp_biz_grp_endprcs_input1_onchanged(obj:Calendar, e:ChangeEventInfo)
  1256. {
  1257. var value = obj.value;
  1258. ds_send_uncoendprcs.setColumn(0, "month", String(value).substr(0,6));
  1259. }
  1260. function grp_biz_switch1_case_uncomonthendinsu_grd_uncomonthendinsu_oncellclick(obj:Grid, e:GridClickEventInfo)
  1261. {
  1262. var sExpr = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1263. for(var i = 1; i < 53; i++)
  1264. {
  1265. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background", sExpr);
  1266. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", i, "background2", sExpr);
  1267. }
  1268. var sExprBack = "EXPR(";
  1269. if(col == "Y")
  1270. {
  1271. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.selecttype = "cell";
  1272. for(var i = 0; i < ds_main_uncomonthendinsu.rowcount; i++)
  1273. {
  1274. arow[i] = ds_main_uncomonthendinsu.getColumn(i, e.col-1);
  1275. sExprBack += "currow == "+i+" ? '#FFE7E5' : "
  1276. }
  1277. sExprBack += "'#ffffff')";
  1278. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", e.col, "background", sExprBack)
  1279. grp_biz.switch1.case_uncomonthendinsu.grd_uncomonthendinsu.setCellProperty("Body", e.col, "background2", sExprBack)
  1280. }
  1281. else
  1282. {
  1283. }
  1284. }
  1285. function grp_biz_switch1_case_uncomonthendproc_grd_uncomonthendproc_oncellclick(obj:Grid, e:GridClickEventInfo)
  1286. {
  1287. var sExpr = "EXPR(getRowLevel(currow) == 1 ? '#ffffcc' : getRowLevel(currow) == 2 ? '#d9f0ff' : getRowLevel(currow) == 3 ? '#ffd9ff' : '#ffffff')";
  1288. for(var i = 1; i < 53; i++)
  1289. {
  1290. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background", sExpr);
  1291. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", i, "background2", sExpr);
  1292. }
  1293. var sExprBack = "EXPR(";
  1294. if(col == "Y")
  1295. {
  1296. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.selecttype = "cell";
  1297. for(var i = 0; i < ds_main_uncomonthendproc.rowcount; i++)
  1298. {
  1299. arow[i] = ds_main_uncomonthendproc.getColumn(i, e.col-1);
  1300. sExprBack += "currow == "+i+" ? '#FFE7E5' : "
  1301. }
  1302. sExprBack += "'#ffffff')";
  1303. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", e.col, "background", sExprBack)
  1304. grp_biz.switch1.case_uncomonthendproc.grd_uncomonthendproc.setCellProperty("Body", e.col, "background2", sExprBack)
  1305. }
  1306. else
  1307. {
  1308. }
  1309. }
  1310. function grp_biz_grp_sea_ipt_endmonthfrom_onchanged(obj:Calendar, e:ChangeEventInfo)
  1311. {
  1312. ds_send_uncoendmonth.setColumn(0, "endmonthfrom", String(obj.value).substr(0,6));
  1313. }
  1314. function grp_biz_grp_sea_ipt_endmonthfrom_onkillfocus(obj:Calendar, e:KillFocusEventInfo)
  1315. {
  1316. ds_send_uncoendmonth.setColumn(0, "endmonthto", ds_send_uncoendmonth.getColumn(0, "endmonthfrom"));
  1317. }
  1318. ]]></Script>
  1319. </Form>
  1320. </FDL>