12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109 |
- <?xml version="1.0" encoding="utf-8" standalone="no"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMAES04900" position="absolute 0 0 1196 765" titletext="검사통합예약통계(예약기준)" onload="SMAES04900_onload">
- <Layouts>
- <Layout>
- <Static id="caption6" class="tit_1" position="absolute 0 0 140 25" style="" text="검사통합예약통계"/>
- <Div id="grp_sea" position="absolute 0 25 1195 85" style="align: top;" class="div_SA" anchor="left top right">
- <Layouts>
- <Layout>
- <Static id="caption2" class="search_name" position="absolute 15 35 101 52" style="" text="기준년월 :" anchor="default"/>
- <Shape id="line13" class="line_4" linetype="vertical" position="absolute 1110 11 1113 51" style="" anchor="top right"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <Static id="caption3" class="search_name" position="absolute 295 11 429 28" style="" text="처방과 / 처방의 :" anchor="default"/>
- <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"/>
- <Static id="caption4" class="search_name" position="absolute 295 35 427 52" style="" text="지원부서_검사실 :" anchor="default"/>
- <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"/>
- <Static id="caption7" class="search_name" position="absolute 795 23 881 40" style="" text="예약부서 :" anchor="default"/>
- <Static id="caption5" class="search_name" position="absolute 15 11 101 28" style="" text="통계구분 :" anchor="default"/>
- <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="cmb_statsflag" position="absolute 110 9 218 28" style="" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">R</Col>
- <Col id="datacolumn">예약건수</Col>
- </Row>
- <Row>
- <Col id="codecolumn">U</Col>
- <Col id="datacolumn">변경건수</Col>
- </Row>
- <Row>
- <Col id="codecolumn">C</Col>
- <Col id="datacolumn">취소건수</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <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"/>
- </Layout>
- </Layouts>
- </Div>
- <Button id="btn_excsave" class="btn7" visible="true" position="absolute 1119 87 1195 109" style="" text="엑셀저장" onclick="btn_excsave_onclick" anchor="top right"/>
- <Tab id="switch1" position="absolute 0 99 1195 764" style="" anchor="all" class="tab_Normal">
- <Tabpages>
- <Tabpage id="case1" selected="true" anchor="default">
- <Layouts>
- <Layout>
- <Grid id="grd_daylist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" selecttype="multirow" scrollpixel="all" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25" band="left"/>
- <Column size="100" band="left"/>
- <Column size="140" band="left"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="38"/>
- <Column size="60"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- <Row size="24" band="summ"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="지원부서"/>
- <Cell col="2" text="검사실"/>
- <Cell col="3" text="1일"/>
- <Cell col="4" text="2일"/>
- <Cell col="5" text="3일"/>
- <Cell col="6" text="4일"/>
- <Cell col="7" text="5일"/>
- <Cell col="8" text="6일"/>
- <Cell col="9" text="7일"/>
- <Cell col="10" text="8일"/>
- <Cell col="11" text="9일"/>
- <Cell col="12" text="10일"/>
- <Cell col="13" text="11일"/>
- <Cell col="14" text="12일"/>
- <Cell col="15" text="13일"/>
- <Cell col="16" text="14일"/>
- <Cell col="17" text="15일"/>
- <Cell col="18" text="16일"/>
- <Cell col="19" text="17일"/>
- <Cell col="20" text="18일"/>
- <Cell col="21" text="19일"/>
- <Cell col="22" text="20일"/>
- <Cell col="23" text="21일"/>
- <Cell col="24" text="22일"/>
- <Cell col="25" text="23일"/>
- <Cell col="26" text="24일"/>
- <Cell col="27" text="25일"/>
- <Cell col="28" text="26일"/>
- <Cell col="29" text="27일"/>
- <Cell col="30" text="28일"/>
- <Cell col="31" text="29일"/>
- <Cell col="32" text="30일"/>
- <Cell col="33" text="31일"/>
- <Cell col="34" text="합계"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" text="expr:currow+1"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- </Band>
- <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
- <Cell/>
- <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
- <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
- <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
- <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
- <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
- <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
- <Cell col="8" displaytype="number" text="expr:getSum('item06')"/>
- <Cell col="9" displaytype="number" text="expr:getSum('item07')"/>
- <Cell col="10" displaytype="number" text="expr:getSum('item08')"/>
- <Cell col="11" displaytype="number" text="expr:getSum('item09')"/>
- <Cell col="12" displaytype="number" text="expr:getSum('item10')"/>
- <Cell col="13" displaytype="number" text="expr:getSum('item11')"/>
- <Cell col="14" displaytype="number" text="expr:getSum('item12')"/>
- <Cell col="15" displaytype="number" text="expr:getSum('item13')"/>
- <Cell col="16" displaytype="number" text="expr:getSum('item14')"/>
- <Cell col="17" displaytype="number" text="expr:getSum('item15')"/>
- <Cell col="18" displaytype="number" text="expr:getSum('item16')"/>
- <Cell col="19" displaytype="number" text="expr:getSum('item17')"/>
- <Cell col="20" displaytype="number" text="expr:getSum('item18')"/>
- <Cell col="21" displaytype="number" text="expr:getSum('item19')"/>
- <Cell col="22" displaytype="number" text="expr:getSum('item20')"/>
- <Cell col="23" displaytype="number" text="expr:getSum('item21')"/>
- <Cell col="24" displaytype="number" text="expr:getSum('item22')"/>
- <Cell col="25" displaytype="number" text="expr:getSum('item23')"/>
- <Cell col="26" displaytype="number" text="expr:getSum('item24')"/>
- <Cell col="27" displaytype="number" text="expr:getSum('item25')"/>
- <Cell col="28" displaytype="number" text="expr:getSum('item26')"/>
- <Cell col="29" displaytype="number" text="expr:getSum('item27')"/>
- <Cell col="30" displaytype="number" text="expr:getSum('item28')"/>
- <Cell col="31" displaytype="number" text="expr:getSum('item29')"/>
- <Cell col="32" displaytype="number" text="expr:getSum('item30')"/>
- <Cell col="33" displaytype="number" text="expr:getSum('item31')"/>
- <Cell col="34" displaytype="number" text="expr:getSum('total')"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="case2" anchor="default" text="주별">
- <Layouts>
- <Layout>
- <Grid id="grd_weeklist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" selecttype="multirow" scrollpixel="all" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25" band="left"/>
- <Column size="115" band="left"/>
- <Column size="240" band="left"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- <Row size="24" band="summ"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="지원부서"/>
- <Cell col="2" text="검사실"/>
- <Cell col="3" text="1주"/>
- <Cell col="4" text="2주"/>
- <Cell col="5" text="3주"/>
- <Cell col="6" text="4주"/>
- <Cell col="7" text="5주"/>
- <Cell col="8" text="6주"/>
- <Cell col="9" text="합계"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" text="expr:currow+1"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- </Band>
- <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
- <Cell/>
- <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
- <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
- <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
- <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
- <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
- <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
- <Cell col="8" displaytype="number" text="expr:getSum('item06')"/>
- <Cell col="9" displaytype="number" text="expr:getSum('total')"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="case3" anchor="default">
- <Layouts>
- <Layout>
- <Grid id="grd_monthlist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" scrollpixel="all" selecttype="multirow" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25" band="left"/>
- <Column size="115" band="left"/>
- <Column size="240" band="left"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="47"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="64"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24" band="head"/>
- <Row size="24"/>
- <Row size="24" band="summ"/>
- </Rows>
- <Band id="head">
- <Cell rowspan="2" taborder="undefined"/>
- <Cell col="1" rowspan="2" text="지원부서" taborder="undefined"/>
- <Cell col="2" rowspan="2" text="검사실" taborder="undefined"/>
- <Cell col="3" colspan="12" text="2006년" taborder="undefined"/>
- <Cell col="15" rowspan="2" text="합계" taborder="undefined"/>
- <Cell col="16" rowspan="2" text="전년도합계" taborder="undefined"/>
- <Cell col="17" rowspan="2" text="증감율" taborder="undefined"/>
- <Cell col="18" text="전년도합계"/>
- <Cell col="19" text="증감(%)"/>
- <Cell col="20" text="지원부서"/>
- <Cell col="21" text="검사실"/>
- <Cell col="22" text="1월"/>
- <Cell col="23" text="2월"/>
- <Cell col="24" text="3월"/>
- <Cell col="25" text="4월"/>
- <Cell col="26" text="5월"/>
- <Cell col="27" text="6월"/>
- <Cell col="28" text="7월"/>
- <Cell col="29" text="8월"/>
- <Cell col="30" text="9월"/>
- <Cell col="31" text="10월"/>
- <Cell col="32" text="11월"/>
- <Cell col="33" text="12월"/>
- <Cell col="34" text="합계"/>
- <Cell col="35" text="전년도합계"/>
- <Cell col="36" text="증감율"/>
- <Cell row="1" col="3" text="1월"/>
- <Cell row="1" col="4" text="2월"/>
- <Cell row="1" col="5" text="3월"/>
- <Cell row="1" col="6" text="4월"/>
- <Cell row="1" col="7" text="5월"/>
- <Cell row="1" col="8" text="6월"/>
- <Cell row="1" col="9" text="7월"/>
- <Cell row="1" col="10" text="8월"/>
- <Cell row="1" col="11" text="9월"/>
- <Cell row="1" col="12" text="10월"/>
- <Cell row="1" col="13" text="11월"/>
- <Cell row="1" col="14" text="12월"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" text="expr:currow+1"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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%"/>
- </Band>
- <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
- <Cell/>
- <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
- <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
- <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
- <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
- <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
- <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
- <Cell col="8" displaytype="number" text="expr:getSum('item06')"/>
- <Cell col="9" displaytype="number" text="expr:getSum('item07')"/>
- <Cell col="10" displaytype="number" text="expr:getSum('item08')"/>
- <Cell col="11" displaytype="number" text="expr:getSum('item09')"/>
- <Cell col="12" displaytype="number" text="expr:getSum('item10')"/>
- <Cell col="13" displaytype="number" text="expr:getSum('item11')"/>
- <Cell col="14" displaytype="number" text="expr:getSum('item12')"/>
- <Cell col="15" displaytype="number" text="expr:getSum('total')"/>
- <Cell col="16" displaytype="number" text="expr:getSum('comparecnt')"/>
- <Cell col="17" displaytype="number" text="expr:setCompareRate(getSum('total'),getSum('comparecnt'))" mask="#,##0%"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="case4" anchor="default">
- <Layouts>
- <Layout>
- <Grid id="grd_qurtlist" binddataset="ds_main_list_item" position="absolute 0 0 1195 650" style="" cellsizingtype="col" scrollpixel="all" selecttype="multirow" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25" band="left"/>
- <Column size="115" band="left"/>
- <Column size="240" band="left"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="68"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="84"/>
- <Column size="84"/>
- <Column size="84"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24" band="head"/>
- <Row size="24"/>
- <Row size="24" band="summ"/>
- </Rows>
- <Band id="head">
- <Cell rowspan="2" taborder="undefined"/>
- <Cell col="1" rowspan="2" text="지원부서" taborder="undefined"/>
- <Cell col="2" rowspan="2" text="검사실" taborder="undefined"/>
- <Cell col="3" colspan="2" text="1분기" taborder="undefined"/>
- <Cell col="5" colspan="2" text="2분기" taborder="undefined"/>
- <Cell col="7" colspan="2" text="3분기" taborder="undefined"/>
- <Cell col="9" colspan="2" text="4분기" taborder="undefined"/>
- <Cell col="11" colspan="4" text="전년도" taborder="undefined"/>
- <Cell col="15" rowspan="2" text="합계" taborder="undefined"/>
- <Cell col="16" rowspan="2" text="전년도합계" taborder="undefined"/>
- <Cell col="17" rowspan="2" text="증감율" taborder="undefined"/>
- <Cell col="18" text="지원부서"/>
- <Cell col="19" text="검사실"/>
- <Cell col="20" text="건수"/>
- <Cell col="21" text="증감율"/>
- <Cell col="22" text="건수"/>
- <Cell col="23" text="증감율"/>
- <Cell col="24" text="건수"/>
- <Cell col="25" text="증감율"/>
- <Cell col="26" text="건수"/>
- <Cell col="27" text="증감율"/>
- <Cell col="28" text="1분기"/>
- <Cell col="29" text="2분기"/>
- <Cell col="30" text="3분기"/>
- <Cell col="31" text="4분기"/>
- <Cell col="32" text="합계"/>
- <Cell col="33" text="전년도합계"/>
- <Cell col="34" text="증감율"/>
- <Cell row="1" col="3" text="건수"/>
- <Cell row="1" col="4" text="증감율"/>
- <Cell row="1" col="5" text="건수"/>
- <Cell row="1" col="6" text="증감율"/>
- <Cell row="1" col="7" text="건수"/>
- <Cell row="1" col="8" text="증감율"/>
- <Cell row="1" col="9" text="건수"/>
- <Cell row="1" col="10" text="증감율"/>
- <Cell row="1" col="11" text="1분기"/>
- <Cell row="1" col="12" text="2분기"/>
- <Cell row="1" col="13" text="3분기"/>
- <Cell row="1" col="14" text="4분기"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" text="expr:currow+1"/>
- <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"/>
- <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"/>
- <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"/>
- <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%"/>
- <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"/>
- <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%"/>
- <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"/>
- <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%"/>
- <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"/>
- <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%"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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%"/>
- </Band>
- <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
- <Cell/>
- <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
- <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
- <Cell col="4" displaytype="number" text="expr:setCompareRate(getSum('item01'),getSum('item09'))" mask="#,##0%"/>
- <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
- <Cell col="6" displaytype="number" text="expr:setCompareRate(getSum('item03'),getSum('item10'))" mask="#,##0%"/>
- <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
- <Cell col="8" displaytype="number" text="expr:setCompareRate(getSum('item05'),getSum('item11'))" mask="#,##0%"/>
- <Cell col="9" displaytype="number" text="expr:getSum('item07')"/>
- <Cell col="10" displaytype="number" text="expr:setCompareRate(getSum('item07'),getSum('item12'))" mask="#,##0%"/>
- <Cell col="11" displaytype="number" text="expr:getSum('item09')"/>
- <Cell col="12" displaytype="number" text="expr:getSum('item10')"/>
- <Cell col="13" displaytype="number" text="expr:getSum('item11')"/>
- <Cell col="14" displaytype="number" text="expr:getSum('item12')"/>
- <Cell col="15" displaytype="number" text="expr:getSum('total')"/>
- <Cell col="16" displaytype="number" text="expr:getSum('comparecnt')"/>
- <Cell col="17" displaytype="number" text="expr:setCompareRate(getSum('total'),getSum('comparecnt'))" mask="#,##0%"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="case5" anchor="default">
- <Layouts>
- <Layout>
- <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">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25" band="left"/>
- <Column size="115" band="left"/>
- <Column size="240" band="left"/>
- <Column size="98"/>
- <Column size="98"/>
- <Column size="98"/>
- <Column size="98"/>
- <Column size="98"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- <Row size="24" band="summ"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="지원부서"/>
- <Cell col="2" text="검사실"/>
- <Cell col="3" text="2005년"/>
- <Cell col="4" text="2006년"/>
- <Cell col="5" text="2007년"/>
- <Cell col="6" text="2008년"/>
- <Cell col="7" text="2009년"/>
- <Cell col="8" text="합계"/>
- </Band>
- <Band id="body">
- <Cell celltype="head" text="expr:currow+1"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- </Band>
- <Band id="summary" style="background:#ccffccff;cellfont:Dotum,9,bold;cellcolor:#0000ffff;">
- <Cell/>
- <Cell col="1" colspan="2" text="총계" taborder="undefined"/>
- <Cell col="3" displaytype="number" text="expr:getSum('item01')"/>
- <Cell col="4" displaytype="number" text="expr:getSum('item02')"/>
- <Cell col="5" displaytype="number" text="expr:getSum('item03')"/>
- <Cell col="6" displaytype="number" text="expr:getSum('item04')"/>
- <Cell col="7" displaytype="number" text="expr:getSum('item05')"/>
- <Cell col="8" displaytype="number" text="expr:getSum('total')"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- </Tabpages>
- </Tab>
- <Shape id="line01" position="absolute 0 109 1195 115" anchor="left top right" style="strokepen:3 solid #07a693ff;background:transparent;"/>
- <Div id="grp_tabbtn" taborder="1" position="absolute 0 85 336 111">
- <Layouts>
- <Layout>
- <Button id="btn_case1" taborder="0" text="일별" onclick="btn_case1_onclick" class="btn_tab_S" position="absolute 0 2 60 26" anchor="default"/>
- <Button id="btn_case2" taborder="1" text="주별" onclick="btn_case2_onclick" class="btn_tab" position="absolute 61 2 121 26" anchor="default"/>
- <Button id="btn_case3" taborder="2" text="월별" onclick="btn_case3_onclick" class="btn_tab" position="absolute 122 2 182 26" anchor="default"/>
- <Button id="btn_case4" taborder="3" text="분기별" onclick="btn_case4_onclick" class="btn_tab" position="absolute 183 2 243 26" anchor="default"/>
- <Button id="btn_case5" taborder="4" text="년도별" onclick="btn_case5_onclick" class="btn_tab" position="absolute 244 2 304 26" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_main_list_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="systkey1" type="STRING" size="256"/>
- <Column id="systkey2" type="STRING" size="256"/>
- <Column id="item01" type="STRING" size="256"/>
- <Column id="item02" type="STRING" size="256"/>
- <Column id="item03" type="STRING" size="256"/>
- <Column id="item04" type="STRING" size="256"/>
- <Column id="item05" type="STRING" size="256"/>
- <Column id="item06" type="STRING" size="256"/>
- <Column id="item07" type="STRING" size="256"/>
- <Column id="item08" type="STRING" size="256"/>
- <Column id="item09" type="STRING" size="256"/>
- <Column id="item10" type="STRING" size="256"/>
- <Column id="item11" type="STRING" size="256"/>
- <Column id="item12" type="STRING" size="256"/>
- <Column id="item13" type="STRING" size="256"/>
- <Column id="item14" type="STRING" size="256"/>
- <Column id="item15" type="STRING" size="256"/>
- <Column id="item16" type="STRING" size="256"/>
- <Column id="item17" type="STRING" size="256"/>
- <Column id="item18" type="STRING" size="256"/>
- <Column id="item19" type="STRING" size="256"/>
- <Column id="item20" type="STRING" size="256"/>
- <Column id="item21" type="STRING" size="256"/>
- <Column id="item22" type="STRING" size="256"/>
- <Column id="item23" type="STRING" size="256"/>
- <Column id="item24" type="STRING" size="256"/>
- <Column id="item25" type="STRING" size="256"/>
- <Column id="item26" type="STRING" size="256"/>
- <Column id="item27" type="STRING" size="256"/>
- <Column id="item28" type="STRING" size="256"/>
- <Column id="item29" type="STRING" size="256"/>
- <Column id="item30" type="STRING" size="256"/>
- <Column id="item31" type="STRING" size="256"/>
- <Column id="total" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="srchdate" type="STRING" size="256"/>
- <Column id="srchstatsflag" type="STRING" size="256"/>
- <Column id="orddeptcd" type="STRING" size="256"/>
- <Column id="orddrid" type="STRING" size="256"/>
- <Column id="excuroomgrpcdid" type="STRING" size="256"/>
- <Column id="excuroomcd" type="STRING" size="256"/>
- <Column id="rsrvdeptcd" type="STRING" size="256"/>
- <Column id="grupcdid" type="STRING" size="256"/>
- <Column id="srchflag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="srchdate"/>
- <Col id="srchstatsflag"/>
- <Col id="orddeptcd"/>
- <Col id="orddrid"/>
- <Col id="excuroomgrpcdid"/>
- <Col id="excuroomcd"/>
- <Col id="rsrvdeptcd"/>
- <Col id="grupcdid"/>
- <Col id="srchflag"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instance1" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instance1"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="hidden" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="hidden"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_cmb_info_excuroomcdlist_excuroom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="basecdflagdesc" type="STRING" size="256"/>
- <Column id="basecd" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_cmb_info_suppdept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="depthngnm" type="STRING" size="256"/>
- <Column id="suppdeptcd" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_orddrid" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_orddeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_dept_info_initprcpexecdeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="prcpexecdeptcdid" type="STRING" size="256"/>
- <Column id="prcpexecdeptcdnm" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchdate"/>
- <BindItem id="item1" compid="grp_sea.cmb_orddept" propid="value" datasetid="ds_send" columnid="orddeptcd"/>
- <BindItem id="item2" compid="grp_sea.cmb_orddr" propid="value" datasetid="ds_send" columnid="orddrid"/>
- <BindItem id="item3" compid="grp_sea.cmb_excuroom" propid="value" datasetid="ds_send" columnid="excuroomcd"/>
- <BindItem id="item4" compid="grp_sea.cmb_deptcd" propid="value" datasetid="ds_send" columnid="excuroomgrpcdid"/>
- <BindItem id="item5" compid="grp_sea.cmb_statsflag" propid="value" datasetid="ds_send" columnid="srchstatsflag"/>
- <BindItem id="item6" compid="grp_sea.cmb_rsrvdeptcd" propid="value" datasetid="ds_send" columnid="rsrvdeptcd"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-12-04
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-06-19 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- //=======================================================================================
- // Lib Include
- //---------------------------------------------------------------------------------------
- include "com_commonxp::comm_main.xjs";
- include "ast_examcurexp::AEZ0001.xjs";
- //=======================================================================================
- // Global Form Variable
- //---------------------------------------------------------------------------------------
- var arErrorCode = new HashArray();
- //=======================================================================================
- // Function
- //---------------------------------------------------------------------------------------
- /****************************************************************************************
- * Argument : tabId : tab버튼 그룹ID(Div)
- * Argument : btnId : tab버튼ID(Button)
- * Description : 선택된 버튼 클래스변경하여 선택효과 주기
- ****************************************************************************************/
- function fn_tabBtnChange(tabId:Div, btnId:Button) {
- var comCnt = tabId.components.length;
- for(var i = 0 ; i < comCnt ; i++) {
- if(tabId.components[i] == "[object Button]") tabId.components[i].class = "btn_tab";
- }
- btnId.class = "btn_tab_S";
- }
- /*-**************************************************************************************
- * Argument : N/A
- * Description : 검사통합예약통계(예약기준) 조회
- ****************************************************************************************/
- function getRsrvSytsStatsCaseList(){
- var grd_list = null;
- // 일별
- if (switch1.tabindex == 0) {
- ds_send.setColumn( 0, "srchflag","D");
- grd_list = switch1.case1.grd_daylist;
- // 주별
- } else if (switch1.tabindex == 1) {
- ds_send.setColumn( 0, "srchflag","W");
- grd_list = switch1.case2.grd_weeklist;
- // 월별
- } else if (switch1.tabindex == 2) {
- ds_send.setColumn( 0, "srchflag","M");
- grd_list = switch1.case3.grd_monthlist;
- // 분기별
- } else if (switch1.tabindex == 3) {
- ds_send.setColumn( 0, "srchflag","Q");
- grd_list = switch1.case4.grd_qurtlist;
- // 년도별
- } else if (switch1.tabindex == 4) {
- ds_send.setColumn( 0, "srchflag","Y");
- grd_list = switch1.case5.grd_yearlist;
- }
-
- dsf_createDs("ds_req");
- ds_req.copyData(ds_send);
- dsf_makeValue(ds_req, "suppdeptcd", "string", ds_send_globalinstance.getColumn(0, "instance1"));
- ds_main_list_item.clearData();
- var oParam = {};
- oParam.id = "TRAES04901";
- oParam.service = "examcurestatsapp.RsrvSysts";
- oParam.method = "reqGetRsrvBaseSystsCaseCntList";
- oParam.inds = "req=ds_req";
- oParam.outds = "ds_main_list_item=item";
- oParam.async = false;
- oParam.callback = "cf_TRAES04901";
- tranf_submit(oParam);
- if(arErrorCode.pop("TRAES04901") > -1) {
- ds_main_list_item.keystring = "G:systkey1";
- ds_main_list_item.reversesubsum = false;
- }
- }
- function cf_TRAES04901(sSvcId, nErrorCode, sErrorMsg) {
- arErrorCode.push(sSvcId, nErrorCode);
- }
- /*-**************************************************************************************
- * Argument : N/A
- * Description : 통계 구분별 그리드 header를 정의하는 함수
- ****************************************************************************************/
- function setTitle() {
- var baseDate = ds_send.getColumn(0, "srchdate") + "01";
- ds_main_list_item.clearData();
- var stMonth = "";
- var stYear = "";
- var sDayCnt = baseDate.toDate().getMonthDay();
- var baseYear = baseDate.substr(0,4);
- stMonth = baseYear + "년";
- var dtYearMonth = baseDate.toDate().getAddDate(-4, "Y");
- var addYear = "";
- for (var i = 0; i <= 4; i++) {
- addYear = dtYearMonth.getDateFormat("YYYY");
- stYear = stYear + addYear + "년^";
- dtYearMonth.getAddDate(1, "Y");
- }
- // 월별
- switch1.case3.grd_monthlist.setCellProperty("Head", 3, "text", stMonth);
- // 년도별
- var stYearArr = stYear.split("^");
- for(var i = 3 ; i <= 7 ; i++) {
- switch1.case5.grd_yearlist.setCellProperty("Head", i, "text", stYearArr[i-3]);
- }
- if(sDayCnt > 30) {
- grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "N,N,N");
- }else if(sDayCnt == 29) {
- grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "N,Y,Y");
- }else if(sDayCnt < 29) {
- grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "Y,Y,Y");
- }else {
- grdf_colHidden(switch1.case1.grd_daylist, "item29,item30,item31", "N,N,Y");
- }
-
- grdf_colHidden(switch1.case4.grd_qurtlist, "item09,item10,item11,item12", "Y,Y,Y,Y");
- }
- /*-**************************************************************************************
- * Argument : total / comparecnt
- * Description : 증감율을 구하는 함수
- ****************************************************************************************/
- function setCompareRate(total, comparecnt) {
- var comparerate = 0;
- if (parseInt(total) > 0) {
- comparerate = ( ( parseInt(total) - parseInt(comparecnt) ) / parseInt(comparecnt) ) * 100;
- if (!utlf_isNull(comparerate)) {
- comparerate = comparerate.toString().getRound(-1,"HALF_UP");
- } else {
- comparerate = 0;
- }
- } else {
- comparerate = 0;
- }
- return comparerate;
- }
- //=======================================================================================
- // Event
- //---------------------------------------------------------------------------------------
- /****************************************************************************************
- * Components : Form
- * Description : 화면 처음 초기화시 폼초기화
- ****************************************************************************************/
- function SMAES04900_onload(obj:Form, e:LoadEventInfo) {
- frmf_initForm(obj);
- //grdf_initGrid(grd_XXX);
- //grdf_setGridSort(grd_XXX);
- //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
- lf_aezfSetSuppDeptcd(); //AEZ0001.xjs
- ds_send_globalinstance.setColumn(0, "instance1", frmf_getParameter("AST_DEPTCD"));
- // 진료과_진료의 조회
- ds_init_orddeptcd.clearData();
- ds_init_orddrid.clearData();
- dsf_createDsRow("ds_req", [
- {col:"sess_posinstcd", type:"STRING", size:256, val:sysf_getUserInfo("dutplcecd")}
- //, {col:"dridsorttype", type:"STRING", size:256, }
- ]);
- var oParam = {};
- oParam.id = "TRPMOCOM01";
- oParam.service = "pamcomnapp.PamComn";
- oParam.method = "reqGetComCD";
- oParam.inds = "req=ds_req";
- oParam.outds = "ds_init_orddeptcd=orddeptcd ds_init_orddrid=orddrid";
- oParam.async = false;
- oParam.callback = "cf_TRPMOCOM01";
- tranf_submit(oParam);
- // 지원부서/* *_검사실 조회
- ds_init_cmb_info_suppdept.clearData();
- dsf_createDsRow("ds_reqparam", [
- {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0, "instance1")}
- , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
- , {col:"ebasecdflag", type:"STRING", size:256, val:"E"}
- , {col:"initflag", type:"STRING", size:256, val:"1"}
- ]);
- var oParam = {};
- oParam.id = "TRAEA01301";
- oParam.service = "examcureacptexecapp.ExamCureAcpt";
- oParam.method = "reqGetInitExamCureRoomGrpCodeList";
- oParam.inds = "reqparam=ds_reqparam";
- oParam.outds = "ds_init_cmb_info_suppdept=suppdept";
- oParam.async = false;
- //oParam.callback = "cf_TRAEA01301";
- tranf_submit(oParam);
- // 수행부서 코드 가져오기
- ds_init_dept_info_initprcpexecdeptcd.clearData();
- dsf_createDsRow("ds_req", [
- {col:"instance1", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0, "instance1")}
- ]);
- var oParam = {};
- oParam.id = "TRAEB00205";
- oParam.service = "examcurebaseapp.ComCode";
- oParam.method = "reqGetPrcpExecDeptCdList";
- oParam.inds = "req=ds_req";
- oParam.outds = "ds_init_dept_info_initprcpexecdeptcd=item";
- oParam.async = false;
- //oParam.callback = "cf_TRAEB00205";
- tranf_submit(oParam);
-
- frmf_addComboItem("grp_sea.cmb_orddept","--전체--","","above");
- //frmf_addComboItem("grp_sea.cmb_orddr","--전체--","","above");
- ds_init_orddrid.insertRow(0);
- dsf_makeValue(ds_init_orddrid, "dp", "string", "");
- dsf_makeValue(ds_init_orddrid, "cd", "string", "");
- dsf_makeValue(ds_init_orddrid, "nm", "string", "--전체--");
-
- frmf_addComboItem("grp_sea.cmb_deptcd","--전체--","","above");
- frmf_addComboItem("grp_sea.cmb_excuroom","--전체--","","above");
- frmf_addComboItem("grp_sea.cmb_rsrvdeptcd","--전체--","","above");
- ds_send.setColumn( 0, "srchdate", utlf_getCurrentDate().substr(0,6));
- ds_send.setColumn( 0, "srchstatsflag", "R");
- setTitle();
- }
- function cf_TRPMOCOM01(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- ds_init_orddrid.updateColID("nmspecyn","nmsp");
- dsf_setDefaultVal(ds_init_orddrid, "all");
- }
- /****************************************************************************************
- * Components : Button
- * Description : 조회
- ****************************************************************************************/
- function grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo) {
- // 검사통합예약통계(예약기준) 조회
- getRsrvSytsStatsCaseList();
- }
- /****************************************************************************************
- * Components : Combo
- * Description : 처방과 변경
- ****************************************************************************************/
- function grp_sea_cmb_orddept_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
- var orddeptcd = ds_send.getColumn(0, "orddeptcd");
- ds_init_orddrid.filter("dp=='"+ orddeptcd + "' || dp == ''");
- ds_send.setColumn(0, "orddrid", "");
- }
- /****************************************************************************************
- * Components : Combo
- * Description : 검사실 변경
- ****************************************************************************************/
- function grp_sea_cmb_excuroom_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
- grp_sea.btn_sea.click();
- }
- /****************************************************************************************
- * Components : Combo
- * Description : 지원부서 변경
- ****************************************************************************************/
- function grp_sea_cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
- ds_send.setColumn( 0, "excuroomcd", "");
- ds_init_cmb_info_excuroomcdlist_excuroom.clearData();
- dsf_createDsRow("ds_req", [
- {col:"basecd", type:"STRING", size:256, val:ds_send.getColumn(0, "basecd")}
- , {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send.getColumn(0, "excuroomgrpcdid")}
- , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
- ]);
- var oParam = {};
- oParam.id = "TRAES04802";
- oParam.service = "examcurebaseapp.ExamCureRoom";
- oParam.method = "reqGetExamCureRoomGrpList";
- oParam.inds = "req=ds_req";
- oParam.outds = "ds_init_cmb_info_excuroomcdlist_excuroom=item";
- oParam.async = false;
- //oParam.callback = "cf_TRAES04802";
- tranf_submit(oParam);
- frmf_addComboItem("grp_sea.cmb_excuroom","--전체--","","above");
- }
- /****************************************************************************************
- * Components : Button
- * Description : 일별선택
- ****************************************************************************************/
- function btn_case1_onclick(obj:Button, e:ClickEventInfo) {
- fn_tabBtnChange(grp_tabbtn, obj);
- switch1.tabindex = 0;
- // 검사통합예약통계(예약기준) 조회
- getRsrvSytsStatsCaseList();
- }
- /****************************************************************************************
- * Components : Button
- * Description : 주별선택
- ****************************************************************************************/
- function btn_case2_onclick(obj:Button, e:ClickEventInfo) {
- fn_tabBtnChange(grp_tabbtn, obj);
- switch1.tabindex = 1;
- // 검사통합예약통계(예약기준) 조회
- getRsrvSytsStatsCaseList();
- }
- /****************************************************************************************
- * Components : Button
- * Description : 월별선택
- ****************************************************************************************/
- function btn_case3_onclick(obj:Button, e:ClickEventInfo) {
- fn_tabBtnChange(grp_tabbtn, obj);
- switch1.tabindex = 2;
- // 검사통합예약통계(예약기준) 조회
- getRsrvSytsStatsCaseList();
- }
- /****************************************************************************************
- * Components : Button
- * Description : 분기별선택
- ****************************************************************************************/
- function btn_case4_onclick(obj:Button, e:ClickEventInfo) {
- fn_tabBtnChange(grp_tabbtn, obj);
- switch1.tabindex = 3;
- // 검사통합예약통계(예약기준) 조회
- getRsrvSytsStatsCaseList();
- }
- /****************************************************************************************
- * Components : Button
- * Description : 년도별선택
- ****************************************************************************************/
- function btn_case5_onclick(obj:Button, e:ClickEventInfo) {
- fn_tabBtnChange(grp_tabbtn, obj);
- switch1.tabindex = 4;
- // 검사통합예약통계(예약기준) 조회
- getRsrvSytsStatsCaseList();
- }
- /****************************************************************************************
- * Components : Button
- * Description : 엑셀저장
- ****************************************************************************************/
- function btn_excsave_onclick(obj:Button, e:ClickEventInfo) {
- var grdObject = null;
-
- if(switch1.tabindex == 0) grdObject = switch1.case1.grd_daylist;
- else if(switch1.tabindex == 1) grdObject = switch1.case2.grd_weeklist;
- else if(switch1.tabindex == 2) grdObject = switch1.case3.grd_monthlist;
- else if(switch1.tabindex == 3) grdObject = switch1.case4.grd_qurtlist;
- else if(switch1.tabindex == 4) grdObject = switch1.case5.grd_yearlist;
-
- if( ds_main_list_item.rowcount > 0 ){
- grdf_exportExcel(grdObject, "Excel", "Sheet1", false, "", "user", false);
- } else {
- sysf_messageBox("조회된 데이터가 ", "I004");
- }
- }
- /****************************************************************************************
- * Components : Calendar
- * Description : 일자변경시 헤더변경
- ****************************************************************************************/
- function grp_sea_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
- {
- setTitle();
- }
- ]]></Script>
- </Form>
- </FDL>
|