123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SSMNW00700" position="absolute 0 0 1238 805" oninit="SSMNW00700_oninit" onload="SSMNW00700_onload" titletext="연보통계">
- <Layouts>
- <Layout>
- <Div id="group3" taborder="1" class="div_SA" position="absolute 0 25 1232 65" anchor="left top right">
- <Layouts>
- <Layout>
- <Calendar id="ipt_fromdd" taborder="6" class="input_default" position="absolute 84 10 184 31" anchor="default" dateformat="yyyy-MM-dd" value="null" autoselect="true"/>
- <Static id="caption8" text="업무일자 :" class="search_name" position="absolute 10 12 81 29" anchor="default"/>
- <Button id="btn_srch" taborder="7" text="조회" class="btn1" position="absolute 1158 9 1214 31" anchor="top right" onclick="group3_btn_srch_onclick"/>
- <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1113 9 1119 31" anchor="top right"/>
- <Calendar id="ipt_todd" taborder="9" class="input_default" position="absolute 204 10 304 31" anchor="default" dateformat="yyyy-MM-dd" autoselect="true"/>
- <Static id="caption2" text="~" position="absolute 189 10 204 30" anchor="default"/>
- <Combo id="cmb_orddept" taborder="10" innerdataset="@ds_init_dept" codecolumn="deptcd" datacolumn="depthngnm" position="absolute 566 9 676 30" anchor="default"/>
- <Static id="caption3" text="부서코드 :" class="search_name" position="absolute 492 12 563 29" anchor="default"/>
- <Radio id="rdo_srchflag" taborder="11" columncount="3" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 324 12 469 29" anchor="default" onitemchanged="group3_rdo_srchflag_onitemchanged" index="-1">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn" size="256"/>
- <Column id="datacolumn" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">Y</Col>
- <Col id="datacolumn">연간</Col>
- </Row>
- <Row>
- <Col id="codecolumn">M</Col>
- <Col id="datacolumn">월간</Col>
- </Row>
- <Row>
- <Col id="codecolumn">D</Col>
- <Col id="datacolumn">일간</Col>
- </Row>
- </Rows>
- </Dataset>
- </Radio>
- </Layout>
- </Layouts>
- </Div>
- <Static id="caption6" text="연보통계" class="tit_1" position="absolute 0 0 88 25"/>
- <Tab id="switch1" taborder="5" tabindex="0" scrollbars="autoboth" position="absolute 1 76 1232 800" onchanged="switch1_onchanged">
- <Tabpages>
- <Tabpage id="case1" text="과별입실현황">
- <Layouts>
- <Layout>
- <Shape id="line1" class="line_1" position="absolute 0 20 1231 26" anchor="left top right" style="strokepen:3 solid #33bbbbff;"/>
- <Static id="caption1" text="과별입실현황" class="tit_2" position="absolute 0 2 101 19"/>
- <Grid id="grd_inptlist" class="datagrid2" taborder="1" useinputpanel="false" cellsizingtype="col" cellsizebandtype="body" position="absolute 0 24 1231 696" anchor="all" binddataset="ds_grd_inptlist" scrollpixel="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="100"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- <Column size="40"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="20" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell text="월별"/>
- <Cell col="1" colspan="2" text="1" taborder="undefined"/>
- <Cell col="3" colspan="2" text="2" taborder="undefined"/>
- <Cell col="5" colspan="2" text="3" taborder="undefined"/>
- <Cell col="7" colspan="2" text="4" taborder="undefined"/>
- <Cell col="9" colspan="2" text="5" taborder="undefined"/>
- <Cell col="11" colspan="2" text="6" taborder="undefined"/>
- <Cell col="13" colspan="2" text="7" taborder="undefined"/>
- <Cell col="15" colspan="2" text="8" taborder="undefined"/>
- <Cell col="17" colspan="2" text="9" taborder="undefined"/>
- <Cell col="19" colspan="2" text="10" taborder="undefined"/>
- <Cell col="21" colspan="2" text="11" taborder="undefined"/>
- <Cell col="23" colspan="2" text="12" taborder="undefined"/>
- <Cell col="25" colspan="2" text="전체" taborder="undefined"/>
- <Cell row="1" text="과별"/>
- <Cell row="1" col="1" text="입실"/>
- <Cell row="1" col="2" 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="입실"/>
- <Cell row="1" col="12" text="연인원" taborder="undefined"/>
- <Cell row="1" col="13" text="입실" taborder="undefined"/>
- <Cell row="1" col="14" text="연인원" taborder="undefined"/>
- <Cell row="1" col="15" text="입실" taborder="undefined"/>
- <Cell row="1" col="16" text="연인원"/>
- <Cell row="1" col="17" text="입실"/>
- <Cell row="1" col="18" text="연인원"/>
- <Cell row="1" col="19" text="입실"/>
- <Cell row="1" col="20" text="연인원"/>
- <Cell row="1" col="21" text="입실"/>
- <Cell row="1" col="22" text="연인원"/>
- <Cell row="1" col="23" text="입실"/>
- <Cell row="1" col="24" text="연인원"/>
- <Cell row="1" col="25" text="입실"/>
- <Cell row="1" col="26" text="연인원"/>
- </Band>
- <Band id="body">
- <Cell style="align:left;padding:0 0 0 3;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:deptnm"/>
- <Cell col="1" displaytype="normal" edittype="none" style="align:right middle;padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt1" wordwrap="char"/>
- <Cell col="2" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt1" wordwrap="char"/>
- <Cell col="3" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt2" wordwrap="char"/>
- <Cell col="4" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt2" wordwrap="char"/>
- <Cell col="5" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt3" wordwrap="char"/>
- <Cell col="6" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt3" wordwrap="char"/>
- <Cell col="7" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt4" wordwrap="char"/>
- <Cell col="8" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt4" wordwrap="char"/>
- <Cell col="9" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt5" wordwrap="char"/>
- <Cell col="10" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt5" wordwrap="char"/>
- <Cell col="11" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt6" wordwrap="char"/>
- <Cell col="12" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt6" wordwrap="char"/>
- <Cell col="13" displaytype="normal" style="align:right middle;padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt7" wordwrap="char"/>
- <Cell col="14" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt7" wordwrap="char"/>
- <Cell col="15" displaytype="normal" style="align:right middle;padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt8" wordwrap="char"/>
- <Cell col="16" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt8" wordwrap="char"/>
- <Cell col="17" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt9" wordwrap="char"/>
- <Cell col="18" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt9" wordwrap="char"/>
- <Cell col="19" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt10" wordwrap="char"/>
- <Cell col="20" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt10" wordwrap="char"/>
- <Cell col="21" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt11" wordwrap="char"/>
- <Cell col="22" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt11" wordwrap="char"/>
- <Cell col="23" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:inptcnt12" wordwrap="char"/>
- <Cell col="24" style="align:right middle;padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:totingcnt12" wordwrap="char"/>
- <Cell col="25" style="align:right middle;padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:suminptcnt" wordwrap="char"/>
- <Cell col="26" displaytype="number" style="padding:0 2 0 0;background:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");background2:EXPR(deptnm=="계"||deptnm=="평균재원일수(일)" ? "#eeffee" : "");" text="bind:sumtotingcnt" wordwrap="char"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="case2" text="과별퇴실현황">
- <Layouts>
- <Layout>
- <Grid id="grd_dschlist" class="datagrid2" taborder="0" useinputpanel="false" cellsizingtype="col" cellsizebandtype="body" position="absolute 0 24 1231 696" anchor="all" binddataset="ds_grd_dschlist">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="120"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="20" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell rowspan="2" text="과별/구분" taborder="undefined"/>
- <Cell col="1" colspan="2" text="입실" taborder="undefined"/>
- <Cell col="3" colspan="7" text="퇴실" taborder="undefined"/>
- <Cell row="1" col="1" text="남"/>
- <Cell row="1" col="2" 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="계"/>
- </Band>
- <Band id="body">
- <Cell displaytype="text" style="padding:0 0 0 5;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:deptnm" subsumtext="expr:"합계""/>
- <Cell col="1" displaytype="number" edittype="none" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:inptmcnt"/>
- <Cell col="2" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:inptfcnt"/>
- <Cell col="3" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:trnsoutcnt"/>
- <Cell col="4" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:dethdschcnt"/>
- <Cell col="5" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:diedschcnt"/>
- <Cell col="6" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:hopedschcnt"/>
- <Cell col="7" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:trnshosdschcnt"/>
- <Cell col="8" displaytype="number" style="align:left middle;padding:0 0 0 2;background:expr:getRowLevel(currow)>0?"#eeffeeff":"default";background2:expr:getRowLevel(currow)>0?"#eeffeeff":"default";font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:nodethdschcnt"/>
- <Cell col="9" displaytype="number" style="align:left middle;padding:0 0 0 2;background:#eeffeeff;font:expr:getRowLevel(currow)>0?"arial,9,bold":"arial,9";" text="bind:totoutrmcnt"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Shape id="line1" class="line_1" position="absolute 0 21 1231 25" anchor="left top right" style="strokepen:3 solid #33bbbbff;"/>
- <Static id="caption1" text="과별퇴실현황" class="tit_2" position="absolute 0 2 101 18"/>
- </Layout>
- </Layouts>
- </Tabpage>
- </Tabpages>
- </Tab>
- <Button id="btn_exl" taborder="3" text="엑셀" class="btn7" position="absolute 1161 72 1217 94" anchor="top right" onclick="btn_exl_onclick"/>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_main_inpt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="stsdd" type="STRING"/>
- <Column id="wardnm" type="STRING"/>
- <Column id="roomcnt" type="STRING"/>
- <Column id="ingcnt" type="STRING"/>
- <Column id="inptcnt" type="STRING"/>
- <Column id="trnsinrmcnt" type="STRING"/>
- <Column id="totinrmcnt" type="STRING"/>
- <Column id="dschcnt" type="STRING"/>
- <Column id="trnsoutrmcnt" type="STRING"/>
- <Column id="totoutrmcnt" type="STRING"/>
- <Column id="dethcnt" type="STRING"/>
- <Column id="opcnfmcnt" type="STRING"/>
- <Column id="gadong" type="STRING"/>
- <Column id="gadongper" type="STRING"/>
- <Column id="dschrate" type="STRING"/>
- <Column id="dschrateper" type="STRING"/>
- <Column id="avgrepaday" type="STRING"/>
- <Column id="realreparoomcnt" type="STRING"/>
- <Column id="indschtdpatcnt" type="STRING"/>
- <Column id="dept01" type="STRING"/>
- <Column id="dept02" type="STRING"/>
- <Column id="dept03" type="STRING"/>
- <Column id="dept04" type="STRING"/>
- <Column id="dept05" type="STRING"/>
- <Column id="dept06" type="STRING"/>
- <Column id="dept07" type="STRING"/>
- <Column id="dept08" type="STRING"/>
- <Column id="dept09" type="STRING"/>
- <Column id="dept10" type="STRING"/>
- <Column id="dept11" type="STRING"/>
- <Column id="dept12" type="STRING"/>
- <Column id="dept13" type="STRING"/>
- <Column id="dept14" type="STRING"/>
- <Column id="dept15" type="STRING"/>
- <Column id="dept16" type="STRING"/>
- <Column id="dept17" type="STRING"/>
- <Column id="dept18" type="STRING"/>
- <Column id="dept19" type="STRING"/>
- <Column id="dept20" type="STRING"/>
- <Column id="dept21" type="STRING"/>
- <Column id="dept22" type="STRING"/>
- <Column id="dept23" type="STRING"/>
- <Column id="dept24" type="STRING"/>
- <Column id="dept25" type="STRING"/>
- <Column id="dept26" type="STRING"/>
- <Column id="dept27" type="STRING"/>
- <Column id="dept28" type="STRING"/>
- <Column id="dept29" type="STRING"/>
- <Column id="dept30" type="STRING"/>
- <Column id="dept31" type="STRING"/>
- <Column id="dept32" type="STRING"/>
- <Column id="dept33" type="STRING"/>
- <Column id="dept34" type="STRING"/>
- <Column id="dept35" type="STRING"/>
- <Column id="dept36" type="STRING"/>
- <Column id="dept37" type="STRING"/>
- <Column id="dept38" type="STRING"/>
- <Column id="dept39" type="STRING"/>
- <Column id="dept40" type="STRING"/>
- <Column id="dept41" type="STRING"/>
- <Column id="dept42" type="STRING"/>
- <Column id="dept43" type="STRING"/>
- <Column id="dept44" type="STRING"/>
- <Column id="dept45" type="STRING"/>
- <Column id="dept46" type="STRING"/>
- <Column id="dept47" type="STRING"/>
- <Column id="dept48" type="STRING"/>
- <Column id="dept49" type="STRING"/>
- <Column id="dept50" type="STRING"/>
- <Column id="dept51" type="STRING"/>
- <Column id="dept52" type="STRING"/>
- <Column id="dept53" type="STRING"/>
- <Column id="dept54" type="STRING"/>
- <Column id="dept55" type="STRING"/>
- <Column id="dept56" type="STRING"/>
- <Column id="dept57" type="STRING"/>
- <Column id="dept58" type="STRING"/>
- <Column id="dept59" type="STRING"/>
- <Column id="dept60" type="STRING"/>
- <Column id="dept61" type="STRING"/>
- <Column id="dept62" type="STRING"/>
- <Column id="dept63" type="STRING"/>
- <Column id="dept64" type="STRING"/>
- <Column id="dept65" type="STRING"/>
- <Column id="dept66" type="STRING"/>
- <Column id="dept67" type="STRING"/>
- <Column id="dept68" type="STRING"/>
- <Column id="dept69" type="STRING"/>
- <Column id="dept70" type="STRING"/>
- <Column id="dept71" type="STRING"/>
- <Column id="dept72" type="STRING"/>
- <Column id="dept73" type="STRING"/>
- <Column id="dept74" type="STRING"/>
- <Column id="dept75" type="STRING"/>
- <Column id="dept76" type="STRING"/>
- <Column id="dept77" type="STRING"/>
- <Column id="dept78" type="STRING"/>
- <Column id="dept79" type="STRING"/>
- <Column id="dept80" type="STRING"/>
- <Column id="dept81" type="STRING"/>
- <Column id="dept82" type="STRING"/>
- <Column id="dept83" type="STRING"/>
- <Column id="dept84" type="STRING"/>
- <Column id="dept85" type="STRING"/>
- <Column id="dept86" type="STRING"/>
- <Column id="dept87" type="STRING"/>
- <Column id="dept88" type="STRING"/>
- <Column id="dept89" type="STRING"/>
- <Column id="dept90" type="STRING"/>
- <Column id="dept91" type="STRING"/>
- <Column id="dept92" type="STRING"/>
- <Column id="dept93" type="STRING"/>
- <Column id="dept94" type="STRING"/>
- <Column id="dept95" type="STRING"/>
- <Column id="dept96" type="STRING"/>
- <Column id="dept97" type="STRING"/>
- <Column id="dept98" type="STRING"/>
- <Column id="dept99" type="STRING"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_dept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="seq" type="STRING"/>
- <Column id="deptengabbr" type="STRING"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="fromdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="deptcd" type="STRING" size="256"/>
- <Column id="srchflag" type="STRING" size="256"/>
- <Column id="flag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="fromdd"/>
- <Col id="todd"/>
- <Col id="deptcd"/>
- <Col id="srchflag">1</Col>
- <Col id="flag">1</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_dept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="deptcd" type="STRING" size="256"/>
- <Column id="depthngnm" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="fromdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="deptcd" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_grd_dschlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="deptnm" type="STRING" size="256"/>
- <Column id="inptmcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="inptfcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="trnsoutcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="dethdschcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="diedschcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="hopedschcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="trnshosdschcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="nodethdschcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="totoutrmcnt" type="BIGDECIMAL" size="256" prop="SUM"/>
- <Column id="group" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_grd_inptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="deptnm" type="STRING" size="256"/>
- <Column id="inptcnt1" type="STRING" size="256"/>
- <Column id="totingcnt1" type="STRING" size="256"/>
- <Column id="inptcnt2" type="STRING" size="256"/>
- <Column id="totingcnt2" type="STRING" size="256"/>
- <Column id="inptcnt3" type="STRING" size="256"/>
- <Column id="totingcnt3" type="STRING" size="256"/>
- <Column id="inptcnt4" type="STRING" size="256"/>
- <Column id="totingcnt4" type="STRING" size="256"/>
- <Column id="inptcnt5" type="STRING" size="256"/>
- <Column id="totingcnt5" type="STRING" size="256"/>
- <Column id="inptcnt6" type="STRING" size="256"/>
- <Column id="totingcnt6" type="STRING" size="256"/>
- <Column id="inptcnt7" type="STRING" size="256"/>
- <Column id="totingcnt7" type="STRING" size="256"/>
- <Column id="inptcnt8" type="STRING" size="256"/>
- <Column id="totingcnt8" type="STRING" size="256"/>
- <Column id="inptcnt9" type="STRING" size="256"/>
- <Column id="totingcnt9" type="STRING" size="256"/>
- <Column id="inptcnt10" type="STRING" size="256"/>
- <Column id="totingcnt10" type="STRING" size="256"/>
- <Column id="inptcnt11" type="STRING" size="256"/>
- <Column id="totingcnt11" type="STRING" size="256"/>
- <Column id="inptcnt12" type="STRING" size="256"/>
- <Column id="totingcnt12" type="STRING" size="256"/>
- <Column id="suminptcnt" type="STRING" size="256"/>
- <Column id="sumtotingcnt" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group3.ipt_fromdd" propid="value" datasetid="ds_main_cond" columnid="fromdd"/>
- <BindItem id="item1" compid="group3.ipt_todd" propid="value" datasetid="ds_main_cond" columnid="todd"/>
- <BindItem id="item2" compid="group3.rdo_srchflag" propid="value" datasetid="ds_main_cond" columnid="srchflag"/>
- <BindItem id="item3" compid="group3.cmb_orddept" propid="value" datasetid="ds_main_cond" columnid="deptcd"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-01-16
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-01-16 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- include "com_departmentcodexp::ZSD001.xjs";
- var arErrorCode = new HashArray();
- /******************************************************************
- * Argument :
- * Description : 초기화
- ******************************************************************/
- function SSMNW00700_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SSMNW00700_onload(obj:Form, e:LoadEventInfo)
- {
- fInit();
- }
- function fInit()
- {
- var curdd = utlf_getCurrentDate();
- ds_main_cond.setColumn(0, "fromdd", curdd.substr(0,4)+"0101");
- ds_main_cond.setColumn(0, "todd", curdd.substr(0,4)+"1231");
- ds_main_cond.setColumn(0, "flag", "1");
- ds_main_cond.setColumn(0, "srchflag", "Y");
-
- var instcd = sysf_getUserInfo("dutplceinstcd");
- var standard_yn = "orduseyn";
- var ord_deptflag = 'W';
- var rslt_ref = "ds_init_dept";
- var sort_field = "depthngnm";
- var sort_method = "asc";
- var dt = utlf_getCurrentDate();
-
- // 간호외래진료부서콤보 (특정하위부서를 포함- 분만실, 육아상담실, 인공신장실)
- appf_getDeptCodeList(instcd, standard_yn, ord_deptflag, sort_field, sort_method, dt, "", "", rslt_ref, false, "");
- dsf_addDsItem( ds_init_dept, "deptcd", "depthngnm", "전체", "", "above");
-
- group3.cmb_orddept.value = sysf_getUserInfo("dutplcecd");
-
- fSearch();
- }
- /******************************************************************
- * Argument :
- * Description : 조회 button event
- ******************************************************************/
- function group3_btn_srch_onclick(obj:Button, e:ClickEventInfo)
- {
- fSearch();
- }
- function fSearch() {
-
- var deptcd = ds_main_cond.getColumn(0, "deptcd");
- var fromdd = ds_main_cond.getColumn(0, "fromdd");
- var todd = ds_main_cond.getColumn(0, "todd");
- var flag = ds_main_cond.getColumn(0, "flag");
-
- if( utlf_isNull(deptcd) ) {
- sysf_messageBox("병동을 선택하십시오.", "I");
- return;
- }
-
- ds_send.deleteAll();
- ds_send.addRow();
- ds_send.setColumn(0, "fromdd", fromdd);
- ds_send.setColumn(0, "todd", todd);
- ds_send.setColumn(0, "deptcd", deptcd);
- if(flag == "1"){
- var oParam = {};
- oParam.id = "TRSNW00701";
- oParam.service = "stsenrapp.StsPatMngt";
- oParam.method = "reqGetInrmInfo";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_grd_inptlist=inptlist";
- oParam.async = false;
- oParam.callback = "cf_TRSNW00701";
-
- tranf_submit(oParam);
-
- ds_grd_inptlist.rowposition = -1;
-
- fRowSum();
-
- } else if(flag == "2"){
- var oParam = {};
- oParam.id = "TRSNW00702";
- oParam.service = "stsenrapp.StsPatMngt";
- oParam.method = "reqGetDschInfo";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_grd_dschlist=dschlist";
- oParam.async = false;
- oParam.callback = "cf_TRSNW00702";
-
- tranf_submit(oParam);
-
- ds_grd_dschlist.rowposition = -1;
- }
- }
- function cf_TRSNW00701(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- }
- function cf_TRSNW00702(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
-
- dsf_setDefaultVal(ds_grd_dschlist, "group:1");
- ds_grd_dschlist.keystring = "G:group";
- }
- /******************************************************************
- * Argument :
- * Description : radio button event
- ******************************************************************/
- function group3_rdo_srchflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
- {
- var srchflag = ds_main_cond.getColumn(0, "srchflag");
- var curdd = utlf_getCurrentDate();
-
- if(srchflag == "Y") {
- ds_main_cond.setColumn(0, "fromdd", curdd.substr(0,4)+"0101");
- ds_main_cond.setColumn(0, "todd", curdd.substr(0,4)+"1231");
- } else if(srchflag == "M"){
- var dd = "";
- var year = curdd.substr(0,4);
- var month = curdd.substr(4,2);
-
- if((year % 4== 0 && year % 100 != 0) || (year % 400 == 0)){
- dd = "29";
- }else{
- dd = "28";
- }
-
- if(month=="01"||month=="03"||month=="05"||month=="07"||month=="08"||month=="10"||month=="12"){
- dd = "31";
- }else if(month=="02"){
-
- }else{
- dd = "30";
- }
-
- ds_main_cond.setColumn(0, "fromdd", curdd.substr(0,6)+"01");
- ds_main_cond.setColumn(0, "todd", curdd.substr(0,6)+dd);
-
- } else{
- ds_main_cond.setColumn(0, "fromdd", curdd);
- ds_main_cond.setColumn(0, "todd", curdd);
- }
- }
- /******************************************************************
- * Argument :
- * Description : 과별입실현황 Row 별 합계
- ******************************************************************/
- function fRowSum(){
- var inptsum = 0;
- var totingsum = 0;
-
- ds_grd_inptlist.enableevent = false;
- for(var i = 0; i<ds_grd_inptlist.rowcount; i++){
- ds_grd_inptlist.addColumn("suminptcnt", "string", 256);
- ds_grd_inptlist.addColumn("sumtotingcnt", "string", 256);
- for(var j = 1; j <= 12; j++){
- inptsum += ds_grd_inptlist.getColumn(i, "inptcnt"+j);
- totingsum += ds_grd_inptlist.getColumn(i, "totingcnt"+j);
- }
- if(i == ds_grd_inptlist.rowcount-1){
- ds_grd_inptlist.setColumn(i, "suminptcnt", "");
- ds_grd_inptlist.setColumn(i, "sumtotingcnt", totingsum);
- }else{
- ds_grd_inptlist.setColumn(i, "suminptcnt", inptsum);
- ds_grd_inptlist.setColumn(i, "sumtotingcnt", totingsum);
- }
- inptsum = 0;
- totingsum = 0;
- }
- ds_grd_inptlist.enableevent = true;
- }
- /******************************************************************
- * Argument :
- * Description : 엑셀 button event
- ******************************************************************/
- function btn_exl_onclick(obj:Button, e:ClickEventInfo)
- {
- var flag = ds_main_cond.getColumn(0, "flag");
- if(flag == "1"){
- if(ds_grd_inptlist.rowcount > 0){
- grdf_exportExcel(switch1.case1.grd_inptlist, "과별입실현황", "과별입실현황", false, "", "user", false);
- }else {
- sysf_messageBox("조회된 데이터가 ", "I004");
- }
- }else{
- if(ds_grd_dschlist.rowcount > 0){
- grdf_exportExcel(switch1.case2.grd_dschlist, "과별퇴실현황", "과별퇴실현황", false, "", "user", false);
- }else{
- sysf_messageBox("조회된 데이터가 ", "I004");
- }
- }
- }
- function switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
- {
- var flag = ds_main_cond.getColumn(0, "flag");
-
- if(flag == "1"){
- ds_main_cond.setColumn(0, "flag", "2");
- }else{
- ds_main_cond.setColumn(0, "flag", "1");
- }
-
- fSearch();
- }
- ]]></Script>
- </Form>
- </FDL>
|