SMAES04900_검사통합예약통계(예약기준).xfdl 96 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAES04900" position="absolute 0 0 1196 765" titletext="검사통합예약통계(예약기준)" onload="SMAES04900_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption6" class="tit_1" position="absolute 0 0 140 25" style="" text="검사통합예약통계"/>
  8. <Div id="grp_sea" position="absolute 0 25 1195 85" style="align: top;" class="div_SA" anchor="left top right">
  9. <Layouts>
  10. <Layout>
  11. <Static id="caption2" class="search_name" position="absolute 15 35 101 52" style="" text="기준년월 :" anchor="default"/>
  12. <Shape id="line13" class="line_4" linetype="vertical" position="absolute 1110 11 1113 51" style="" anchor="top right"/>
  13. <Button id="btn_sea" class="btn1" taborder="4" position="absolute 1125 20 1181 42" style="" text="조회" onclick="grp_sea_btn_sea_onclick" anchor="top right"/>
  14. <Calendar id="ipt_fromdd" class="input_default" taborder="1" mask="yyyy-mm" position="absolute 109 33 217 52" style="align:center ;" anchor="default" onkillfocus="grp_sea_ipt_fromdd_onkillfocus" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_sea_ipt_fromdd_onchanged"/>
  15. <Combo innerdataset="ds_init_orddeptcd" datacolumn="nm" codecolumn="cd" columncount="-1" rowcount="-1" id="cmb_orddept" position="absolute 435 9 587 28" style="" onitemchanged="grp_sea_cmb_orddept_onitemchanged" anchor="default"/>
  16. <Combo innerdataset="ds_init_orddrid" datacolumn="nm" codecolumn="cd" columncount="-1" rowcount="-1" id="cmb_orddr" position="absolute 590 9 742 28" style="" anchor="default"/>
  17. <Static id="caption3" class="search_name" position="absolute 295 11 429 28" style="" text="처방과 / 처방의 :" anchor="default"/>
  18. <Combo innerdataset="ds_init_cmb_info_excuroomcdlist_excuroom" datacolumn="basecdflagdesc" codecolumn="basecd" columncount="-1" rowcount="-1" id="cmb_excuroom" class="combo_default" taborder="1" position="absolute 590 33 742 52" style="" onitemchanged="grp_sea_cmb_excuroom_onitemchanged" anchor="default"/>
  19. <Static id="caption4" class="search_name" position="absolute 295 35 427 52" style="" text="지원부서_검사실 :" anchor="default"/>
  20. <Combo innerdataset="ds_init_cmb_info_suppdept" datacolumn="depthngnm" codecolumn="suppdeptcd" columncount="-1" rowcount="-1" id="cmb_deptcd" position="absolute 435 33 587 52" style="" onitemchanged="grp_sea_cmb_deptcd_onitemchanged" anchor="default"/>
  21. <Static id="caption7" class="search_name" position="absolute 795 23 881 40" style="" text="예약부서 :" anchor="default"/>
  22. <Static id="caption5" class="search_name" position="absolute 15 11 101 28" style="" text="통계구분 :" anchor="default"/>
  23. <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="cmb_statsflag" position="absolute 110 9 218 28" style="" anchor="default">
  24. <Dataset id="innerdataset">
  25. <ColumnInfo>
  26. <Column id="codecolumn"/>
  27. <Column id="datacolumn"/>
  28. </ColumnInfo>
  29. <Rows>
  30. <Row>
  31. <Col id="codecolumn">R</Col>
  32. <Col id="datacolumn">예약건수</Col>
  33. </Row>
  34. <Row>
  35. <Col id="codecolumn">U</Col>
  36. <Col id="datacolumn">변경건수</Col>
  37. </Row>
  38. <Row>
  39. <Col id="codecolumn">C</Col>
  40. <Col id="datacolumn">취소건수</Col>
  41. </Row>
  42. </Rows>
  43. </Dataset>
  44. </Combo>
  45. <Combo innerdataset="ds_init_dept_info_initprcpexecdeptcd" datacolumn="prcpexecdeptcdnm" codecolumn="prcpexecdeptcdid" columncount="-1" rowcount="-1" id="cmb_rsrvdeptcd" position="absolute 890 21 1090 40" style="" anchor="default"/>
  46. </Layout>
  47. </Layouts>
  48. </Div>
  49. <Button id="btn_excsave" class="btn7" visible="true" position="absolute 1119 87 1195 109" style="" text="엑셀저장" onclick="btn_excsave_onclick" anchor="top right"/>
  50. <Tab id="switch1" position="absolute 0 99 1195 764" style="" anchor="all" class="tab_Normal">
  51. <Tabpages>
  52. <Tabpage id="case1" selected="true" anchor="default">
  53. <Layouts>
  54. <Layout>
  55. <Grid id="grd_daylist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" selecttype="multirow" scrollpixel="all" anchor="all">
  56. <Formats>
  57. <Format id="default">
  58. <Columns>
  59. <Column size="25" band="left"/>
  60. <Column size="100" band="left"/>
  61. <Column size="140" band="left"/>
  62. <Column size="38"/>
  63. <Column size="38"/>
  64. <Column size="38"/>
  65. <Column size="38"/>
  66. <Column size="38"/>
  67. <Column size="38"/>
  68. <Column size="38"/>
  69. <Column size="38"/>
  70. <Column size="38"/>
  71. <Column size="38"/>
  72. <Column size="38"/>
  73. <Column size="38"/>
  74. <Column size="38"/>
  75. <Column size="38"/>
  76. <Column size="38"/>
  77. <Column size="38"/>
  78. <Column size="38"/>
  79. <Column size="38"/>
  80. <Column size="38"/>
  81. <Column size="38"/>
  82. <Column size="38"/>
  83. <Column size="38"/>
  84. <Column size="38"/>
  85. <Column size="38"/>
  86. <Column size="38"/>
  87. <Column size="38"/>
  88. <Column size="38"/>
  89. <Column size="38"/>
  90. <Column size="38"/>
  91. <Column size="38"/>
  92. <Column size="38"/>
  93. <Column size="60"/>
  94. </Columns>
  95. <Rows>
  96. <Row size="24" band="head"/>
  97. <Row size="24"/>
  98. <Row size="24" band="summ"/>
  99. </Rows>
  100. <Band id="head">
  101. <Cell/>
  102. <Cell col="1" text="지원부서"/>
  103. <Cell col="2" text="검사실"/>
  104. <Cell col="3" text="1일"/>
  105. <Cell col="4" text="2일"/>
  106. <Cell col="5" text="3일"/>
  107. <Cell col="6" text="4일"/>
  108. <Cell col="7" text="5일"/>
  109. <Cell col="8" text="6일"/>
  110. <Cell col="9" text="7일"/>
  111. <Cell col="10" text="8일"/>
  112. <Cell col="11" text="9일"/>
  113. <Cell col="12" text="10일"/>
  114. <Cell col="13" text="11일"/>
  115. <Cell col="14" text="12일"/>
  116. <Cell col="15" text="13일"/>
  117. <Cell col="16" text="14일"/>
  118. <Cell col="17" text="15일"/>
  119. <Cell col="18" text="16일"/>
  120. <Cell col="19" text="17일"/>
  121. <Cell col="20" text="18일"/>
  122. <Cell col="21" text="19일"/>
  123. <Cell col="22" text="20일"/>
  124. <Cell col="23" text="21일"/>
  125. <Cell col="24" text="22일"/>
  126. <Cell col="25" text="23일"/>
  127. <Cell col="26" text="24일"/>
  128. <Cell col="27" text="25일"/>
  129. <Cell col="28" text="26일"/>
  130. <Cell col="29" text="27일"/>
  131. <Cell col="30" text="28일"/>
  132. <Cell col="31" text="29일"/>
  133. <Cell col="32" text="30일"/>
  134. <Cell col="33" text="31일"/>
  135. <Cell col="34" text="합계"/>
  136. </Band>
  137. <Band id="body">
  138. <Cell celltype="head" text="expr:currow+1"/>
  139. <Cell col="1" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey1" wordwrap="char" suppress="1" suppressalign="middle,over"/>
  140. <Cell col="2" displaytype="text" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey2" subsumtext="소계" wordwrap="char"/>
  141. <Cell col="3" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item01"/>
  142. <Cell col="4" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item02"/>
  143. <Cell col="5" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item03"/>
  144. <Cell col="6" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item04"/>
  145. <Cell col="7" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item05"/>
  146. <Cell col="8" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item06"/>
  147. <Cell col="9" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item07"/>
  148. <Cell col="10" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item08"/>
  149. <Cell col="11" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item09"/>
  150. <Cell col="12" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item10"/>
  151. <Cell col="13" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item11"/>
  152. <Cell col="14" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item12"/>
  153. <Cell col="15" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item13"/>
  154. <Cell col="16" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item14"/>
  155. <Cell col="17" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item15"/>
  156. <Cell col="18" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item16"/>
  157. <Cell col="19" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item17"/>
  158. <Cell col="20" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item18"/>
  159. <Cell col="21" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item19"/>
  160. <Cell col="22" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item20"/>
  161. <Cell col="23" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item21"/>
  162. <Cell col="24" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item22"/>
  163. <Cell col="25" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item23"/>
  164. <Cell col="26" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item24"/>
  165. <Cell col="27" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item25"/>
  166. <Cell col="28" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item26"/>
  167. <Cell col="29" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item27"/>
  168. <Cell col="30" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item28"/>
  169. <Cell col="31" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item29"/>
  170. <Cell col="32" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item30"/>
  171. <Cell col="33" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item31"/>
  172. <Cell col="34" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:total"/>
  173. </Band>
  174. <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
  175. <Cell/>
  176. <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
  177. <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
  178. <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
  179. <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
  180. <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
  181. <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
  182. <Cell col="8" displaytype="number" text="expr:getSum('item06')"/>
  183. <Cell col="9" displaytype="number" text="expr:getSum('item07')"/>
  184. <Cell col="10" displaytype="number" text="expr:getSum('item08')"/>
  185. <Cell col="11" displaytype="number" text="expr:getSum('item09')"/>
  186. <Cell col="12" displaytype="number" text="expr:getSum('item10')"/>
  187. <Cell col="13" displaytype="number" text="expr:getSum('item11')"/>
  188. <Cell col="14" displaytype="number" text="expr:getSum('item12')"/>
  189. <Cell col="15" displaytype="number" text="expr:getSum('item13')"/>
  190. <Cell col="16" displaytype="number" text="expr:getSum('item14')"/>
  191. <Cell col="17" displaytype="number" text="expr:getSum('item15')"/>
  192. <Cell col="18" displaytype="number" text="expr:getSum('item16')"/>
  193. <Cell col="19" displaytype="number" text="expr:getSum('item17')"/>
  194. <Cell col="20" displaytype="number" text="expr:getSum('item18')"/>
  195. <Cell col="21" displaytype="number" text="expr:getSum('item19')"/>
  196. <Cell col="22" displaytype="number" text="expr:getSum('item20')"/>
  197. <Cell col="23" displaytype="number" text="expr:getSum('item21')"/>
  198. <Cell col="24" displaytype="number" text="expr:getSum('item22')"/>
  199. <Cell col="25" displaytype="number" text="expr:getSum('item23')"/>
  200. <Cell col="26" displaytype="number" text="expr:getSum('item24')"/>
  201. <Cell col="27" displaytype="number" text="expr:getSum('item25')"/>
  202. <Cell col="28" displaytype="number" text="expr:getSum('item26')"/>
  203. <Cell col="29" displaytype="number" text="expr:getSum('item27')"/>
  204. <Cell col="30" displaytype="number" text="expr:getSum('item28')"/>
  205. <Cell col="31" displaytype="number" text="expr:getSum('item29')"/>
  206. <Cell col="32" displaytype="number" text="expr:getSum('item30')"/>
  207. <Cell col="33" displaytype="number" text="expr:getSum('item31')"/>
  208. <Cell col="34" displaytype="number" text="expr:getSum('total')"/>
  209. </Band>
  210. </Format>
  211. </Formats>
  212. </Grid>
  213. </Layout>
  214. </Layouts>
  215. </Tabpage>
  216. <Tabpage id="case2" anchor="default" text="주별">
  217. <Layouts>
  218. <Layout>
  219. <Grid id="grd_weeklist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" selecttype="multirow" scrollpixel="all" anchor="all">
  220. <Formats>
  221. <Format id="default">
  222. <Columns>
  223. <Column size="25" band="left"/>
  224. <Column size="115" band="left"/>
  225. <Column size="240" band="left"/>
  226. <Column size="100"/>
  227. <Column size="100"/>
  228. <Column size="100"/>
  229. <Column size="100"/>
  230. <Column size="100"/>
  231. <Column size="100"/>
  232. <Column size="100"/>
  233. </Columns>
  234. <Rows>
  235. <Row size="24" band="head"/>
  236. <Row size="24"/>
  237. <Row size="24" band="summ"/>
  238. </Rows>
  239. <Band id="head">
  240. <Cell/>
  241. <Cell col="1" text="지원부서"/>
  242. <Cell col="2" text="검사실"/>
  243. <Cell col="3" text="1주"/>
  244. <Cell col="4" text="2주"/>
  245. <Cell col="5" text="3주"/>
  246. <Cell col="6" text="4주"/>
  247. <Cell col="7" text="5주"/>
  248. <Cell col="8" text="6주"/>
  249. <Cell col="9" text="합계"/>
  250. </Band>
  251. <Band id="body">
  252. <Cell celltype="head" text="expr:currow+1"/>
  253. <Cell col="1" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey1" wordwrap="char" suppress="1" suppressalign="middle,over"/>
  254. <Cell col="2" displaytype="text" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey2" subsumtext="소계" wordwrap="char" suppressalign="middle,over"/>
  255. <Cell col="3" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item01"/>
  256. <Cell col="4" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item02"/>
  257. <Cell col="5" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item03"/>
  258. <Cell col="6" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item04"/>
  259. <Cell col="7" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item05"/>
  260. <Cell col="8" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item06"/>
  261. <Cell col="9" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:total"/>
  262. </Band>
  263. <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
  264. <Cell/>
  265. <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
  266. <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
  267. <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
  268. <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
  269. <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
  270. <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
  271. <Cell col="8" displaytype="number" text="expr:getSum('item06')"/>
  272. <Cell col="9" displaytype="number" text="expr:getSum('total')"/>
  273. </Band>
  274. </Format>
  275. </Formats>
  276. </Grid>
  277. </Layout>
  278. </Layouts>
  279. </Tabpage>
  280. <Tabpage id="case3" anchor="default">
  281. <Layouts>
  282. <Layout>
  283. <Grid id="grd_monthlist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" scrollpixel="all" selecttype="multirow" anchor="all">
  284. <Formats>
  285. <Format id="default">
  286. <Columns>
  287. <Column size="25" band="left"/>
  288. <Column size="115" band="left"/>
  289. <Column size="240" band="left"/>
  290. <Column size="47"/>
  291. <Column size="47"/>
  292. <Column size="47"/>
  293. <Column size="47"/>
  294. <Column size="47"/>
  295. <Column size="47"/>
  296. <Column size="47"/>
  297. <Column size="47"/>
  298. <Column size="47"/>
  299. <Column size="47"/>
  300. <Column size="47"/>
  301. <Column size="47"/>
  302. <Column size="80"/>
  303. <Column size="80"/>
  304. <Column size="64"/>
  305. </Columns>
  306. <Rows>
  307. <Row size="24" band="head"/>
  308. <Row size="24" band="head"/>
  309. <Row size="24"/>
  310. <Row size="24" band="summ"/>
  311. </Rows>
  312. <Band id="head">
  313. <Cell rowspan="2" taborder="undefined"/>
  314. <Cell col="1" rowspan="2" text="지원부서" taborder="undefined"/>
  315. <Cell col="2" rowspan="2" text="검사실" taborder="undefined"/>
  316. <Cell col="3" colspan="12" text="2006년" taborder="undefined"/>
  317. <Cell col="15" rowspan="2" text="합계" taborder="undefined"/>
  318. <Cell col="16" rowspan="2" text="전년도합계" taborder="undefined"/>
  319. <Cell col="17" rowspan="2" text="증감율" taborder="undefined"/>
  320. <Cell col="18" text="전년도합계"/>
  321. <Cell col="19" text="증감(%)"/>
  322. <Cell col="20" text="지원부서"/>
  323. <Cell col="21" text="검사실"/>
  324. <Cell col="22" text="1월"/>
  325. <Cell col="23" text="2월"/>
  326. <Cell col="24" text="3월"/>
  327. <Cell col="25" text="4월"/>
  328. <Cell col="26" text="5월"/>
  329. <Cell col="27" text="6월"/>
  330. <Cell col="28" text="7월"/>
  331. <Cell col="29" text="8월"/>
  332. <Cell col="30" text="9월"/>
  333. <Cell col="31" text="10월"/>
  334. <Cell col="32" text="11월"/>
  335. <Cell col="33" text="12월"/>
  336. <Cell col="34" text="합계"/>
  337. <Cell col="35" text="전년도합계"/>
  338. <Cell col="36" text="증감율"/>
  339. <Cell row="1" col="3" text="1월"/>
  340. <Cell row="1" col="4" text="2월"/>
  341. <Cell row="1" col="5" text="3월"/>
  342. <Cell row="1" col="6" text="4월"/>
  343. <Cell row="1" col="7" text="5월"/>
  344. <Cell row="1" col="8" text="6월"/>
  345. <Cell row="1" col="9" text="7월"/>
  346. <Cell row="1" col="10" text="8월"/>
  347. <Cell row="1" col="11" text="9월"/>
  348. <Cell row="1" col="12" text="10월"/>
  349. <Cell row="1" col="13" text="11월"/>
  350. <Cell row="1" col="14" text="12월"/>
  351. </Band>
  352. <Band id="body">
  353. <Cell celltype="head" text="expr:currow+1"/>
  354. <Cell col="1" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey1" wordwrap="char" suppress="1" suppressalign="middle,over"/>
  355. <Cell col="2" displaytype="text" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey2" subsumtext="소계" wordwrap="char"/>
  356. <Cell col="3" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item01"/>
  357. <Cell col="4" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item02"/>
  358. <Cell col="5" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item03"/>
  359. <Cell col="6" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item04"/>
  360. <Cell col="7" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item05"/>
  361. <Cell col="8" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item06"/>
  362. <Cell col="9" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item07"/>
  363. <Cell col="10" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item08"/>
  364. <Cell col="11" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item09"/>
  365. <Cell col="12" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item10"/>
  366. <Cell col="13" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item11"/>
  367. <Cell col="14" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item12"/>
  368. <Cell col="15" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:total"/>
  369. <Cell col="16" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:comparecnt"/>
  370. <Cell col="17" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="expr:setCompareRate(total, comparecnt)" mask="#,##0%"/>
  371. </Band>
  372. <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
  373. <Cell/>
  374. <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
  375. <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
  376. <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
  377. <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
  378. <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
  379. <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
  380. <Cell col="8" displaytype="number" text="expr:getSum('item06')"/>
  381. <Cell col="9" displaytype="number" text="expr:getSum('item07')"/>
  382. <Cell col="10" displaytype="number" text="expr:getSum('item08')"/>
  383. <Cell col="11" displaytype="number" text="expr:getSum('item09')"/>
  384. <Cell col="12" displaytype="number" text="expr:getSum('item10')"/>
  385. <Cell col="13" displaytype="number" text="expr:getSum('item11')"/>
  386. <Cell col="14" displaytype="number" text="expr:getSum('item12')"/>
  387. <Cell col="15" displaytype="number" text="expr:getSum('total')"/>
  388. <Cell col="16" displaytype="number" text="expr:getSum('comparecnt')"/>
  389. <Cell col="17" displaytype="number" text="expr:setCompareRate(getSum('total'),getSum('comparecnt'))" mask="#,##0%"/>
  390. </Band>
  391. </Format>
  392. </Formats>
  393. </Grid>
  394. </Layout>
  395. </Layouts>
  396. </Tabpage>
  397. <Tabpage id="case4" anchor="default">
  398. <Layouts>
  399. <Layout>
  400. <Grid id="grd_qurtlist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" scrollpixel="all" selecttype="multirow" anchor="all">
  401. <Formats>
  402. <Format id="default">
  403. <Columns>
  404. <Column size="25" band="left"/>
  405. <Column size="115" band="left"/>
  406. <Column size="240" band="left"/>
  407. <Column size="68"/>
  408. <Column size="68"/>
  409. <Column size="68"/>
  410. <Column size="68"/>
  411. <Column size="68"/>
  412. <Column size="68"/>
  413. <Column size="68"/>
  414. <Column size="68"/>
  415. <Column size="100"/>
  416. <Column size="100"/>
  417. <Column size="100"/>
  418. <Column size="100"/>
  419. <Column size="84"/>
  420. <Column size="84"/>
  421. <Column size="84"/>
  422. </Columns>
  423. <Rows>
  424. <Row size="24" band="head"/>
  425. <Row size="24" band="head"/>
  426. <Row size="24"/>
  427. <Row size="24" band="summ"/>
  428. </Rows>
  429. <Band id="head">
  430. <Cell rowspan="2" taborder="undefined"/>
  431. <Cell col="1" rowspan="2" text="지원부서" taborder="undefined"/>
  432. <Cell col="2" rowspan="2" text="검사실" taborder="undefined"/>
  433. <Cell col="3" colspan="2" text="1분기" taborder="undefined"/>
  434. <Cell col="5" colspan="2" text="2분기" taborder="undefined"/>
  435. <Cell col="7" colspan="2" text="3분기" taborder="undefined"/>
  436. <Cell col="9" colspan="2" text="4분기" taborder="undefined"/>
  437. <Cell col="11" colspan="4" text="전년도" taborder="undefined"/>
  438. <Cell col="15" rowspan="2" text="합계" taborder="undefined"/>
  439. <Cell col="16" rowspan="2" text="전년도합계" taborder="undefined"/>
  440. <Cell col="17" rowspan="2" text="증감율" taborder="undefined"/>
  441. <Cell col="18" text="지원부서"/>
  442. <Cell col="19" text="검사실"/>
  443. <Cell col="20" text="건수"/>
  444. <Cell col="21" text="증감율"/>
  445. <Cell col="22" text="건수"/>
  446. <Cell col="23" text="증감율"/>
  447. <Cell col="24" text="건수"/>
  448. <Cell col="25" text="증감율"/>
  449. <Cell col="26" text="건수"/>
  450. <Cell col="27" text="증감율"/>
  451. <Cell col="28" text="1분기"/>
  452. <Cell col="29" text="2분기"/>
  453. <Cell col="30" text="3분기"/>
  454. <Cell col="31" text="4분기"/>
  455. <Cell col="32" text="합계"/>
  456. <Cell col="33" text="전년도합계"/>
  457. <Cell col="34" text="증감율"/>
  458. <Cell row="1" col="3" text="건수"/>
  459. <Cell row="1" col="4" text="증감율"/>
  460. <Cell row="1" col="5" text="건수"/>
  461. <Cell row="1" col="6" text="증감율"/>
  462. <Cell row="1" col="7" text="건수"/>
  463. <Cell row="1" col="8" text="증감율"/>
  464. <Cell row="1" col="9" text="건수"/>
  465. <Cell row="1" col="10" text="증감율"/>
  466. <Cell row="1" col="11" text="1분기"/>
  467. <Cell row="1" col="12" text="2분기"/>
  468. <Cell row="1" col="13" text="3분기"/>
  469. <Cell row="1" col="14" text="4분기"/>
  470. </Band>
  471. <Band id="body">
  472. <Cell celltype="head" text="expr:currow+1"/>
  473. <Cell col="1" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey1" wordwrap="char" suppress="1" suppressalign="middle,over"/>
  474. <Cell col="2" displaytype="text" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey2" subsumtext="소계" wordwrap="char"/>
  475. <Cell col="3" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item01"/>
  476. <Cell col="4" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="expr:setCompareRate(item01, item09)" mask="#,##0%"/>
  477. <Cell col="5" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item03"/>
  478. <Cell col="6" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="expr:setCompareRate(item03, item10)" mask="#,##0%"/>
  479. <Cell col="7" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item05"/>
  480. <Cell col="8" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="expr:setCompareRate(item05, item11)" mask="#,##0%"/>
  481. <Cell col="9" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item07"/>
  482. <Cell col="10" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="expr:setCompareRate(item07, item12)" mask="#,##0%"/>
  483. <Cell col="11" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item09"/>
  484. <Cell col="12" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item10"/>
  485. <Cell col="13" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item11"/>
  486. <Cell col="14" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item12"/>
  487. <Cell col="15" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:total"/>
  488. <Cell col="16" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:comparecnt"/>
  489. <Cell col="17" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="expr:setCompareRate(total, comparecnt)" mask="#,##0%"/>
  490. </Band>
  491. <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
  492. <Cell/>
  493. <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
  494. <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
  495. <Cell col="4" displaytype="number" text="expr:setCompareRate(getSum('item01'),getSum('item09'))" mask="#,##0%"/>
  496. <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
  497. <Cell col="6" displaytype="number" text="expr:setCompareRate(getSum('item03'),getSum('item10'))" mask="#,##0%"/>
  498. <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
  499. <Cell col="8" displaytype="number" text="expr:setCompareRate(getSum('item05'),getSum('item11'))" mask="#,##0%"/>
  500. <Cell col="9" displaytype="number" text="expr:getSum('item07')"/>
  501. <Cell col="10" displaytype="number" text="expr:setCompareRate(getSum('item07'),getSum('item12'))" mask="#,##0%"/>
  502. <Cell col="11" displaytype="number" text="expr:getSum('item09')"/>
  503. <Cell col="12" displaytype="number" text="expr:getSum('item10')"/>
  504. <Cell col="13" displaytype="number" text="expr:getSum('item11')"/>
  505. <Cell col="14" displaytype="number" text="expr:getSum('item12')"/>
  506. <Cell col="15" displaytype="number" text="expr:getSum('total')"/>
  507. <Cell col="16" displaytype="number" text="expr:getSum('comparecnt')"/>
  508. <Cell col="17" displaytype="number" text="expr:setCompareRate(getSum('total'),getSum('comparecnt'))" mask="#,##0%"/>
  509. </Band>
  510. </Format>
  511. </Formats>
  512. </Grid>
  513. </Layout>
  514. </Layouts>
  515. </Tabpage>
  516. <Tabpage id="case5" anchor="default">
  517. <Layouts>
  518. <Layout>
  519. <Grid id="grd_yearlist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" selecttype="multirow" scrollpixel="all" autofittype="col" anchor="all">
  520. <Formats>
  521. <Format id="default">
  522. <Columns>
  523. <Column size="25" band="left"/>
  524. <Column size="115" band="left"/>
  525. <Column size="240" band="left"/>
  526. <Column size="98"/>
  527. <Column size="98"/>
  528. <Column size="98"/>
  529. <Column size="98"/>
  530. <Column size="98"/>
  531. <Column size="100"/>
  532. </Columns>
  533. <Rows>
  534. <Row size="24" band="head"/>
  535. <Row size="24"/>
  536. <Row size="24" band="summ"/>
  537. </Rows>
  538. <Band id="head">
  539. <Cell/>
  540. <Cell col="1" text="지원부서"/>
  541. <Cell col="2" text="검사실"/>
  542. <Cell col="3" text="2005년"/>
  543. <Cell col="4" text="2006년"/>
  544. <Cell col="5" text="2007년"/>
  545. <Cell col="6" text="2008년"/>
  546. <Cell col="7" text="2009년"/>
  547. <Cell col="8" text="합계"/>
  548. </Band>
  549. <Band id="body">
  550. <Cell celltype="head" text="expr:currow+1"/>
  551. <Cell col="1" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey1" wordwrap="char" suppress="1" suppressalign="middle,over"/>
  552. <Cell col="2" displaytype="text" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:systkey2" subsumtext="소계" wordwrap="char"/>
  553. <Cell col="3" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item01"/>
  554. <Cell col="4" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item02"/>
  555. <Cell col="5" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item03"/>
  556. <Cell col="6" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item04"/>
  557. <Cell col="7" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:item05"/>
  558. <Cell col="8" displaytype="number" style="background:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');background2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#FFFFCC' : '#FFFFFF');color:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');color2:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '#0000ff' : '#000000');font:EXPR(utlf_isNull(getColumn(currow,'systkey2')) ? '돋움체,9,bold' : '돋움체,9');" text="bind:total"/>
  559. </Band>
  560. <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
  561. <Cell/>
  562. <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
  563. <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
  564. <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
  565. <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
  566. <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
  567. <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
  568. <Cell col="8" displaytype="number" text="expr:getSum('total')"/>
  569. </Band>
  570. </Format>
  571. </Formats>
  572. </Grid>
  573. </Layout>
  574. </Layouts>
  575. </Tabpage>
  576. </Tabpages>
  577. </Tab>
  578. <Shape id="line01" position="absolute 0 109 1195 115" anchor="left top right" style="strokepen:3 solid #07a693ff;background:transparent;"/>
  579. <Div id="grp_tabbtn" taborder="1" position="absolute 0 85 336 111">
  580. <Layouts>
  581. <Layout>
  582. <Button id="btn_case1" taborder="0" text="일별" onclick="btn_case1_onclick" class="btn_tab_S" position="absolute 0 2 60 26" anchor="default"/>
  583. <Button id="btn_case2" taborder="1" text="주별" onclick="btn_case2_onclick" class="btn_tab" position="absolute 61 2 121 26" anchor="default"/>
  584. <Button id="btn_case3" taborder="2" text="월별" onclick="btn_case3_onclick" class="btn_tab" position="absolute 122 2 182 26" anchor="default"/>
  585. <Button id="btn_case4" taborder="3" text="분기별" onclick="btn_case4_onclick" class="btn_tab" position="absolute 183 2 243 26" anchor="default"/>
  586. <Button id="btn_case5" taborder="4" text="년도별" onclick="btn_case5_onclick" class="btn_tab" position="absolute 244 2 304 26" anchor="default"/>
  587. </Layout>
  588. </Layouts>
  589. </Div>
  590. </Layout>
  591. </Layouts>
  592. <Objects>
  593. <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  594. <ColumnInfo>
  595. <Column id="systkey1" type="STRING" size="256"/>
  596. <Column id="systkey2" type="STRING" size="256"/>
  597. <Column id="item01" type="STRING" size="256"/>
  598. <Column id="item02" type="STRING" size="256"/>
  599. <Column id="item03" type="STRING" size="256"/>
  600. <Column id="item04" type="STRING" size="256"/>
  601. <Column id="item05" type="STRING" size="256"/>
  602. <Column id="item06" type="STRING" size="256"/>
  603. <Column id="item07" type="STRING" size="256"/>
  604. <Column id="item08" type="STRING" size="256"/>
  605. <Column id="item09" type="STRING" size="256"/>
  606. <Column id="item10" type="STRING" size="256"/>
  607. <Column id="item11" type="STRING" size="256"/>
  608. <Column id="item12" type="STRING" size="256"/>
  609. <Column id="item13" type="STRING" size="256"/>
  610. <Column id="item14" type="STRING" size="256"/>
  611. <Column id="item15" type="STRING" size="256"/>
  612. <Column id="item16" type="STRING" size="256"/>
  613. <Column id="item17" type="STRING" size="256"/>
  614. <Column id="item18" type="STRING" size="256"/>
  615. <Column id="item19" type="STRING" size="256"/>
  616. <Column id="item20" type="STRING" size="256"/>
  617. <Column id="item21" type="STRING" size="256"/>
  618. <Column id="item22" type="STRING" size="256"/>
  619. <Column id="item23" type="STRING" size="256"/>
  620. <Column id="item24" type="STRING" size="256"/>
  621. <Column id="item25" type="STRING" size="256"/>
  622. <Column id="item26" type="STRING" size="256"/>
  623. <Column id="item27" type="STRING" size="256"/>
  624. <Column id="item28" type="STRING" size="256"/>
  625. <Column id="item29" type="STRING" size="256"/>
  626. <Column id="item30" type="STRING" size="256"/>
  627. <Column id="item31" type="STRING" size="256"/>
  628. <Column id="total" type="STRING" size="256"/>
  629. </ColumnInfo>
  630. </Dataset>
  631. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  632. <ColumnInfo>
  633. <Column id="srchdate" type="STRING" size="256"/>
  634. <Column id="srchstatsflag" type="STRING" size="256"/>
  635. <Column id="orddeptcd" type="STRING" size="256"/>
  636. <Column id="orddrid" type="STRING" size="256"/>
  637. <Column id="excuroomgrpcdid" type="STRING" size="256"/>
  638. <Column id="excuroomcd" type="STRING" size="256"/>
  639. <Column id="rsrvdeptcd" type="STRING" size="256"/>
  640. <Column id="grupcdid" type="STRING" size="256"/>
  641. <Column id="srchflag" type="STRING" size="256"/>
  642. </ColumnInfo>
  643. <Rows>
  644. <Row>
  645. <Col id="srchdate"/>
  646. <Col id="srchstatsflag"/>
  647. <Col id="orddeptcd"/>
  648. <Col id="orddrid"/>
  649. <Col id="excuroomgrpcdid"/>
  650. <Col id="excuroomcd"/>
  651. <Col id="rsrvdeptcd"/>
  652. <Col id="grupcdid"/>
  653. <Col id="srchflag"/>
  654. </Row>
  655. </Rows>
  656. </Dataset>
  657. <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  658. <ColumnInfo>
  659. <Column id="instance1" type="STRING" size="256"/>
  660. </ColumnInfo>
  661. <Rows>
  662. <Row>
  663. <Col id="instance1"/>
  664. </Row>
  665. </Rows>
  666. </Dataset>
  667. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  668. <ColumnInfo>
  669. <Column id="hidden" type="STRING" size="256"/>
  670. </ColumnInfo>
  671. <Rows>
  672. <Row>
  673. <Col id="hidden"/>
  674. </Row>
  675. </Rows>
  676. </Dataset>
  677. <Dataset id="ds_init_cmb_info_excuroomcdlist_excuroom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  678. <ColumnInfo>
  679. <Column id="basecdflagdesc" type="STRING" size="256"/>
  680. <Column id="basecd" type="STRING" size="256"/>
  681. </ColumnInfo>
  682. </Dataset>
  683. <Dataset id="ds_init_cmb_info_suppdept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  684. <ColumnInfo>
  685. <Column id="depthngnm" type="STRING" size="256"/>
  686. <Column id="suppdeptcd" type="STRING" size="256"/>
  687. </ColumnInfo>
  688. </Dataset>
  689. <Dataset id="ds_init_orddrid" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  690. <ColumnInfo>
  691. <Column id="cd" type="STRING" size="256"/>
  692. <Column id="nm" type="STRING" size="256"/>
  693. </ColumnInfo>
  694. </Dataset>
  695. <Dataset id="ds_init_orddeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  696. <ColumnInfo>
  697. <Column id="cd" type="STRING" size="256"/>
  698. <Column id="nm" type="STRING" size="256"/>
  699. </ColumnInfo>
  700. </Dataset>
  701. <Dataset id="ds_init_dept_info_initprcpexecdeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  702. <ColumnInfo>
  703. <Column id="prcpexecdeptcdid" type="STRING" size="256"/>
  704. <Column id="prcpexecdeptcdnm" type="STRING" size="256"/>
  705. </ColumnInfo>
  706. </Dataset>
  707. </Objects>
  708. <Bind>
  709. <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchdate"/>
  710. <BindItem id="item1" compid="grp_sea.cmb_orddept" propid="value" datasetid="ds_send" columnid="orddeptcd"/>
  711. <BindItem id="item2" compid="grp_sea.cmb_orddr" propid="value" datasetid="ds_send" columnid="orddrid"/>
  712. <BindItem id="item3" compid="grp_sea.cmb_excuroom" propid="value" datasetid="ds_send" columnid="excuroomcd"/>
  713. <BindItem id="item4" compid="grp_sea.cmb_deptcd" propid="value" datasetid="ds_send" columnid="excuroomgrpcdid"/>
  714. <BindItem id="item5" compid="grp_sea.cmb_statsflag" propid="value" datasetid="ds_send" columnid="srchstatsflag"/>
  715. <BindItem id="item6" compid="grp_sea.cmb_rsrvdeptcd" propid="value" datasetid="ds_send" columnid="rsrvdeptcd"/>
  716. </Bind>
  717. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  718. * System Name :
  719. * Job Name :
  720. * Creator :
  721. * Make Date : 2017-12-04
  722. * Description :
  723. *---------------------------------------------------------------------------------------
  724. * Modify Date Modifier Modify Description
  725. *---------------------------------------------------------------------------------------
  726. * 2017-06-19 Live Converter TF->XP
  727. *
  728. *---------------------------------------------------------------------------------------
  729. ****************************************************************************************/
  730. //=======================================================================================
  731. // Lib Include
  732. //---------------------------------------------------------------------------------------
  733. include "com_commonxp::comm_main.xjs";
  734. include "ast_examcurexp::AEZ0001.xjs";
  735. //=======================================================================================
  736. // Global Form Variable
  737. //---------------------------------------------------------------------------------------
  738. var arErrorCode = new HashArray();
  739. //=======================================================================================
  740. // Function
  741. //---------------------------------------------------------------------------------------
  742. /****************************************************************************************
  743. * Argument : tabId : tab버튼 그룹ID(Div)
  744. * Argument : btnId : tab버튼ID(Button)
  745. * Description : 선택된 버튼 클래스변경하여 선택효과 주기
  746. ****************************************************************************************/
  747. function fn_tabBtnChange(tabId:Div, btnId:Button) {
  748. var comCnt = tabId.components.length;
  749. for(var i = 0 ; i < comCnt ; i++) {
  750. if(tabId.components[i] == "[object Button]") tabId.components[i].class = "btn_tab";
  751. }
  752. btnId.class = "btn_tab_S";
  753. }
  754. /*-**************************************************************************************
  755. * Argument : N/A
  756. * Description : 검사통합예약통계(예약기준) 조회
  757. ****************************************************************************************/
  758. function getRsrvSytsStatsCaseList(){
  759. var grd_list = null;
  760. // 일별
  761. if (switch1.tabindex == 0) {
  762. ds_send.setColumn( 0, "srchflag","D");
  763. grd_list = switch1.case1.grd_daylist;
  764. // 주별
  765. } else if (switch1.tabindex == 1) {
  766. ds_send.setColumn( 0, "srchflag","W");
  767. grd_list = switch1.case2.grd_weeklist;
  768. // 월별
  769. } else if (switch1.tabindex == 2) {
  770. ds_send.setColumn( 0, "srchflag","M");
  771. grd_list = switch1.case3.grd_monthlist;
  772. // 분기별
  773. } else if (switch1.tabindex == 3) {
  774. ds_send.setColumn( 0, "srchflag","Q");
  775. grd_list = switch1.case4.grd_qurtlist;
  776. // 년도별
  777. } else if (switch1.tabindex == 4) {
  778. ds_send.setColumn( 0, "srchflag","Y");
  779. grd_list = switch1.case5.grd_yearlist;
  780. }
  781. dsf_createDs("ds_req");
  782. ds_req.copyData(ds_send);
  783. dsf_makeValue(ds_req, "suppdeptcd", "string", ds_send_globalinstance.getColumn(0, "instance1"));
  784. ds_main_list_item.clearData();
  785. var oParam = {};
  786. oParam.id = "TRAES04901";
  787. oParam.service = "examcurestatsapp.RsrvSysts";
  788. oParam.method = "reqGetRsrvBaseSystsCaseCntList";
  789. oParam.inds = "req=ds_req";
  790. oParam.outds = "ds_main_list_item=item";
  791. oParam.async = false;
  792. oParam.callback = "cf_TRAES04901";
  793. tranf_submit(oParam);
  794. if(arErrorCode.pop("TRAES04901") > -1) {
  795. ds_main_list_item.keystring = "G:systkey1";
  796. ds_main_list_item.reversesubsum = false;
  797. }
  798. }
  799. function cf_TRAES04901(sSvcId, nErrorCode, sErrorMsg) {
  800. arErrorCode.push(sSvcId, nErrorCode);
  801. }
  802. /*-**************************************************************************************
  803. * Argument : N/A
  804. * Description : 통계 구분별 그리드 header를 정의하는 함수
  805. ****************************************************************************************/
  806. function setTitle() {
  807. var baseDate = ds_send.getColumn(0, "srchdate") + "01";
  808. ds_main_list_item.clearData();
  809. var stMonth = "";
  810. var stYear = "";
  811. var sDayCnt = baseDate.toDate().getMonthDay();
  812. var baseYear = baseDate.substr(0,4);
  813. stMonth = baseYear + "년";
  814. var dtYearMonth = baseDate.toDate().getAddDate(-4, "Y");
  815. var addYear = "";
  816. for (var i = 0; i <= 4; i++) {
  817. addYear = dtYearMonth.getDateFormat("YYYY");
  818. stYear = stYear + addYear + "년^";
  819. dtYearMonth.getAddDate(1, "Y");
  820. }
  821. // 월별
  822. switch1.case3.grd_monthlist.setCellProperty("Head", 3, "text", stMonth);
  823. // 년도별
  824. var stYearArr = stYear.split("^");
  825. for(var i = 3 ; i <= 7 ; i++) {
  826. switch1.case5.grd_yearlist.setCellProperty("Head", i, "text", stYearArr[i-3]);
  827. }
  828. if(sDayCnt > 30) {
  829. grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "N,N,N");
  830. }else if(sDayCnt == 29) {
  831. grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "N,Y,Y");
  832. }else if(sDayCnt < 29) {
  833. grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "Y,Y,Y");
  834. }else {
  835. grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "N,N,Y");
  836. }
  837. grdf_colHidden(switch1.case4.grd_qurtlist, "item09,item10,item11,item12", "Y,Y,Y,Y");
  838. }
  839. /*-**************************************************************************************
  840. * Argument : total / comparecnt
  841. * Description : 증감율을 구하는 함수
  842. ****************************************************************************************/
  843. function setCompareRate(total, comparecnt) {
  844. var comparerate = 0;
  845. if (parseInt(total) > 0) {
  846. comparerate = ( ( parseInt(total) - parseInt(comparecnt) ) / parseInt(comparecnt) ) * 100;
  847. if (!utlf_isNull(comparerate)) {
  848. comparerate = comparerate.toString().getRound(-1,"HALF_UP");
  849. } else {
  850. comparerate = 0;
  851. }
  852. } else {
  853. comparerate = 0;
  854. }
  855. return comparerate;
  856. }
  857. //=======================================================================================
  858. // Event
  859. //---------------------------------------------------------------------------------------
  860. /****************************************************************************************
  861. * Components : Form
  862. * Description : 화면 처음 초기화시 폼초기화
  863. ****************************************************************************************/
  864. function SMAES04900_onload(obj:Form, e:LoadEventInfo) {
  865. frmf_initForm(obj);
  866. //grdf_initGrid(grd_XXX);
  867. //grdf_setGridSort(grd_XXX);
  868. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  869. lf_aezfSetSuppDeptcd(); //AEZ0001.xjs
  870. ds_send_globalinstance.setColumn(0, "instance1", frmf_getParameter("AST_DEPTCD"));
  871. // 진료과_진료의 조회
  872. ds_init_orddeptcd.clearData();
  873. ds_init_orddrid.clearData();
  874. dsf_createDsRow("ds_req", [
  875. {col:"sess_posinstcd", type:"STRING", size:256, val:sysf_getUserInfo("dutplcecd")}
  876. //, {col:"dridsorttype", type:"STRING", size:256, }
  877. ]);
  878. var oParam = {};
  879. oParam.id = "TRPMOCOM01";
  880. oParam.service = "pamcomnapp.PamComn";
  881. oParam.method = "reqGetComCD";
  882. oParam.inds = "req=ds_req";
  883. oParam.outds = "ds_init_orddeptcd=orddeptcd ds_init_orddrid=orddrid";
  884. oParam.async = false;
  885. oParam.callback = "cf_TRPMOCOM01";
  886. tranf_submit(oParam);
  887. // 지원부서/* *_검사실 조회
  888. ds_init_cmb_info_suppdept.clearData();
  889. dsf_createDsRow("ds_reqparam", [
  890. {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0, "instance1")}
  891. , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
  892. , {col:"ebasecdflag", type:"STRING", size:256, val:"E"}
  893. , {col:"initflag", type:"STRING", size:256, val:"1"}
  894. ]);
  895. var oParam = {};
  896. oParam.id = "TRAEA01301";
  897. oParam.service = "examcureacptexecapp.ExamCureAcpt";
  898. oParam.method = "reqGetInitExamCureRoomGrpCodeList";
  899. oParam.inds = "reqparam=ds_reqparam";
  900. oParam.outds = "ds_init_cmb_info_suppdept=suppdept";
  901. oParam.async = false;
  902. //oParam.callback = "cf_TRAEA01301";
  903. tranf_submit(oParam);
  904. // 수행부서 코드 가져오기
  905. ds_init_dept_info_initprcpexecdeptcd.clearData();
  906. dsf_createDsRow("ds_req", [
  907. {col:"instance1", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0, "instance1")}
  908. ]);
  909. var oParam = {};
  910. oParam.id = "TRAEB00205";
  911. oParam.service = "examcurebaseapp.ComCode";
  912. oParam.method = "reqGetPrcpExecDeptCdList";
  913. oParam.inds = "req=ds_req";
  914. oParam.outds = "ds_init_dept_info_initprcpexecdeptcd=item";
  915. oParam.async = false;
  916. //oParam.callback = "cf_TRAEB00205";
  917. tranf_submit(oParam);
  918. frmf_addComboItem("grp_sea.cmb_orddept","--전체--","","above");
  919. //frmf_addComboItem("grp_sea.cmb_orddr","--전체--","","above");
  920. ds_init_orddrid.insertRow(0);
  921. dsf_makeValue(ds_init_orddrid, "dp", "string", "");
  922. dsf_makeValue(ds_init_orddrid, "cd", "string", "");
  923. dsf_makeValue(ds_init_orddrid, "nm", "string", "--전체--");
  924. frmf_addComboItem("grp_sea.cmb_deptcd","--전체--","","above");
  925. frmf_addComboItem("grp_sea.cmb_excuroom","--전체--","","above");
  926. frmf_addComboItem("grp_sea.cmb_rsrvdeptcd","--전체--","","above");
  927. ds_send.setColumn( 0, "srchdate", utlf_getCurrentDate().substr(0,6));
  928. ds_send.setColumn( 0, "srchstatsflag", "R");
  929. setTitle();
  930. }
  931. function cf_TRPMOCOM01(sSvcId, nErrorCode, sErrorMsg) {
  932. if(nErrorCode < 0) return;
  933. ds_init_orddrid.updateColID("nmspecyn","nmsp");
  934. dsf_setDefaultVal(ds_init_orddrid, "all");
  935. }
  936. /****************************************************************************************
  937. * Components : Button
  938. * Description : 조회
  939. ****************************************************************************************/
  940. function grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo) {
  941. // 검사통합예약통계(예약기준) 조회
  942. getRsrvSytsStatsCaseList();
  943. }
  944. /****************************************************************************************
  945. * Components : Combo
  946. * Description : 처방과 변경
  947. ****************************************************************************************/
  948. function grp_sea_cmb_orddept_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  949. var orddeptcd = ds_send.getColumn(0, "orddeptcd");
  950. ds_init_orddrid.filter("dp=='"+ orddeptcd + "' || dp == ''");
  951. ds_send.setColumn(0, "orddrid", "");
  952. }
  953. /****************************************************************************************
  954. * Components : Combo
  955. * Description : 검사실 변경
  956. ****************************************************************************************/
  957. function grp_sea_cmb_excuroom_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  958. grp_sea.btn_sea.click();
  959. }
  960. /****************************************************************************************
  961. * Components : Combo
  962. * Description : 지원부서 변경
  963. ****************************************************************************************/
  964. function grp_sea_cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  965. ds_send.setColumn( 0, "excuroomcd", "");
  966. ds_init_cmb_info_excuroomcdlist_excuroom.clearData();
  967. dsf_createDsRow("ds_req", [
  968. {col:"basecd", type:"STRING", size:256, val:ds_send.getColumn(0, "basecd")}
  969. , {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send.getColumn(0, "excuroomgrpcdid")}
  970. , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
  971. ]);
  972. var oParam = {};
  973. oParam.id = "TRAES04802";
  974. oParam.service = "examcurebaseapp.ExamCureRoom";
  975. oParam.method = "reqGetExamCureRoomGrpList";
  976. oParam.inds = "req=ds_req";
  977. oParam.outds = "ds_init_cmb_info_excuroomcdlist_excuroom=item";
  978. oParam.async = false;
  979. //oParam.callback = "cf_TRAES04802";
  980. tranf_submit(oParam);
  981. frmf_addComboItem("grp_sea.cmb_excuroom","--전체--","","above");
  982. }
  983. /****************************************************************************************
  984. * Components : Button
  985. * Description : 일별선택
  986. ****************************************************************************************/
  987. function btn_case1_onclick(obj:Button, e:ClickEventInfo) {
  988. fn_tabBtnChange(grp_tabbtn, obj);
  989. switch1.tabindex = 0;
  990. // 검사통합예약통계(예약기준) 조회
  991. getRsrvSytsStatsCaseList();
  992. }
  993. /****************************************************************************************
  994. * Components : Button
  995. * Description : 주별선택
  996. ****************************************************************************************/
  997. function btn_case2_onclick(obj:Button, e:ClickEventInfo) {
  998. fn_tabBtnChange(grp_tabbtn, obj);
  999. switch1.tabindex = 1;
  1000. // 검사통합예약통계(예약기준) 조회
  1001. getRsrvSytsStatsCaseList();
  1002. }
  1003. /****************************************************************************************
  1004. * Components : Button
  1005. * Description : 월별선택
  1006. ****************************************************************************************/
  1007. function btn_case3_onclick(obj:Button, e:ClickEventInfo) {
  1008. fn_tabBtnChange(grp_tabbtn, obj);
  1009. switch1.tabindex = 2;
  1010. // 검사통합예약통계(예약기준) 조회
  1011. getRsrvSytsStatsCaseList();
  1012. }
  1013. /****************************************************************************************
  1014. * Components : Button
  1015. * Description : 분기별선택
  1016. ****************************************************************************************/
  1017. function btn_case4_onclick(obj:Button, e:ClickEventInfo) {
  1018. fn_tabBtnChange(grp_tabbtn, obj);
  1019. switch1.tabindex = 3;
  1020. // 검사통합예약통계(예약기준) 조회
  1021. getRsrvSytsStatsCaseList();
  1022. }
  1023. /****************************************************************************************
  1024. * Components : Button
  1025. * Description : 년도별선택
  1026. ****************************************************************************************/
  1027. function btn_case5_onclick(obj:Button, e:ClickEventInfo) {
  1028. fn_tabBtnChange(grp_tabbtn, obj);
  1029. switch1.tabindex = 4;
  1030. // 검사통합예약통계(예약기준) 조회
  1031. getRsrvSytsStatsCaseList();
  1032. }
  1033. /****************************************************************************************
  1034. * Components : Button
  1035. * Description : 엑셀저장
  1036. ****************************************************************************************/
  1037. function btn_excsave_onclick(obj:Button, e:ClickEventInfo) {
  1038. var grdObject = null;
  1039. if(switch1.tabindex == 0) grdObject = switch1.case1.grd_daylist;
  1040. else if(switch1.tabindex == 1) grdObject = switch1.case2.grd_weeklist;
  1041. else if(switch1.tabindex == 2) grdObject = switch1.case3.grd_monthlist;
  1042. else if(switch1.tabindex == 3) grdObject = switch1.case4.grd_qurtlist;
  1043. else if(switch1.tabindex == 4) grdObject = switch1.case5.grd_yearlist;
  1044. if( ds_main_list_item.rowcount > 0 ){
  1045. grdf_exportExcel(grdObject, "Excel", "Sheet1", false, "", "user", false);
  1046. } else {
  1047. sysf_messageBox("조회된 데이터가 ", "I004");
  1048. }
  1049. }
  1050. /****************************************************************************************
  1051. * Components : Calendar
  1052. * Description : 일자변경시 헤더변경
  1053. ****************************************************************************************/
  1054. function grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
  1055. {
  1056. setTitle();
  1057. }
  1058. ]]></Script>
  1059. </Form>
  1060. </FDL>