123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMMNG04900" position="absolute 0 0 1200 777" titletext="물품별 부서별 안전재고조회" oninit="SMMNG04900_oninit" onload="SMMNG04900_onload">
- <Layouts>
- <Layout>
- <Grid id="grd_safestoclist" taborder="5" binddataset="ds_main_safestocinfo_safestoclist" useinputpanel="false" position="absolute 0 96 1193 771" cellsizingtype="both" extendsizetype="row" oncellclick="grd_safestoclist_oncellclick" autosizingtype="row">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="61" band="left"/>
- <Column size="75" band="left"/>
- <Column size="149" band="left"/>
- <Column size="111" band="left"/>
- <Column size="95" band="left"/>
- <Column size="35" band="left"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24" band="head"/>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell rowspan="3" text="구분" taborder="undefined"/>
- <Cell col="1" rowspan="3" text="물품코드" taborder="undefined"/>
- <Cell col="2" rowspan="3" text="물품명" taborder="undefined"/>
- <Cell col="3" rowspan="3" text="상세규격" taborder="undefined"/>
- <Cell col="4" rowspan="3" text="모델" taborder="undefined"/>
- <Cell col="5" rowspan="3" text="단위" taborder="undefined"/>
- <Cell col="6" colspan="2" text="합계" taborder="undefined"/>
- <Cell col="8" colspan="2" text="test" taborder="undefined"/>
- <Cell row="1" col="6" text="1_1" taborder="undefined"/>
- <Cell row="1" col="7" text="1_2" taborder="undefined"/>
- <Cell row="1" col="8" text="3_1"/>
- <Cell row="1" col="9" text="3_2"/>
- <Cell row="2" col="6" text="2_1" taborder="undefined"/>
- <Cell row="2" col="7" text="2_2" taborder="undefined"/>
- <Cell row="2" col="8" text="4_1"/>
- <Cell row="2" col="9" text="4_2"/>
- </Band>
- <Band id="body">
- <Cell displaytype="combo" edittype="combo" style="align:center middle;" text="bind:reqdetlflag" combodataset="ds_cmb_reqdetlflag" combocodecol="value" combodatacol="label"/>
- <Cell col="1" style="align:left middle;" text="bind:goodcd"/>
- <Cell col="2" style="align:left middle;" text="bind:csrgoodnm" wordwrap="word" autosizerow="limitmin"/>
- <Cell col="3" text="bind:csrgoodspec"/>
- <Cell col="4" text="bind:csrgoodmodel"/>
- <Cell col="5" text="bind:csrrequnit"/>
- <Cell col="6" displaytype="number" style="align:center middle;" text="bind:total2"/>
- <Cell col="7" displaytype="number" style="align:center middle;" text="bind:total"/>
- <Cell col="8"/>
- <Cell col="9"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Static id="cap_title" text="물품별 부서별 안전재고 조회" class="tit_1" position="absolute 0 0 252 25"/>
- <Static id="caption1" text="안전재고현황" class="tit_2" position="absolute 0 75 100 98"/>
- <Radio id="rdo_reqdetlflag" taborder="1" columncount="-1" rowcount="-1" innerdataset="@ds_init_codeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" position="absolute 115 69 612 92" onitemchanged="rdo_reqdetlflag_onitemchanged"/>
- <Shape id="line1" class="line_10" position="absolute 0 91 1193 97" anchor="left top right"/>
- <Div id="grp_sea" taborder="3" class="div_SA" position="absolute 0 25 1194 65" anchor="left top right">
- <Layouts>
- <Layout>
- <Button id="btn_search" taborder="8" text="조회" class="btn1" position="absolute 1070 11 1126 33" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
- <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1057 11 1063 31" anchor="top right"/>
- <Button id="button5" taborder="9" text="엑셀" class="btn7" position="absolute 1130 11 1186 33" anchor="top right" onclick="grp_sea_button5_onclick"/>
- <Static id="cap_instcd" text="업무일자 :" class="search_name" position="absolute 13 12 103 29" anchor="default"/>
- <Calendar id="ipt_workdd" taborder="10" class="ipt_workdd" position="absolute 103 11 206 30" anchor="default" autoselect="true" autoskip="true"/>
- <Static id="caption2" text="부 서 명 :" class="search_name" position="absolute 233 12 313 29" anchor="default"/>
- <Combo id="cmb_deptcd" taborder="11" innerdataset="@ds_init_csrdeptlist" codecolumn="deptcd" datacolumn="deptnm" position="absolute 311 11 411 30" anchor="default" onitemchanged="grp_sea_cmb_deptcd_onitemchanged"/>
- <Static id="caption3" text="물품조회구분 :" class="search_name" position="absolute 428 13 536 30" anchor="default"/>
- <Radio id="radio1" taborder="12" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 539 10 682 31" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">1</Col>
- <Col id="datacolumn">물품코드</Col>
- </Row>
- <Row>
- <Col id="codecolumn">2</Col>
- <Col id="datacolumn">물품명</Col>
- </Row>
- </Rows>
- </Dataset>
- </Radio>
- <Edit id="ipt_srchnm" taborder="13" autoselect="true" autoskip="true" position="absolute 682 11 897 30" anchor="default" onkeydown="grp_sea_ipt_srchnm_onkeydown"/>
- </Layout>
- </Layouts>
- </Div>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="workdd" type="STRING" size="256"/>
- <Column id="deptcd" type="STRING" size="256"/>
- <Column id="reqdetlflag" type="STRING" size="256"/>
- <Column id="flag" type="STRING" size="256"/>
- <Column id="srchnm" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="workdd"/>
- <Col id="deptcd"/>
- <Col id="reqdetlflag"/>
- <Col id="flag">1</Col>
- <Col id="srchnm"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_safestocinfo_safestoclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="reqdetlflag" type="STRING" size="256" sumtext="구분"/>
- <Column id="goodcd" type="STRING" size="256" sumtext="물품코드"/>
- <Column id="csrgoodnm" type="STRING" size="256" sumtext="물품명"/>
- <Column id="csrgoodspec" type="STRING" size="256" sumtext="물품규격"/>
- <Column id="csrgoodmodel" type="STRING" size="256" sumtext="물품모델"/>
- <Column id="csrrequnit" type="STRING" size="256" sumtext="물품모델"/>
- <Column id="depthngnm1" type="STRING" size="256" sumtext="부서1"/>
- <Column id="depthngnm2" type="STRING" size="256" sumtext="부서2"/>
- <Column id="depthngnm3" type="STRING" size="256" sumtext="부서3"/>
- <Column id="depthngnm4" type="STRING" size="256" sumtext="부서4"/>
- <Column id="depthngnm5" type="STRING" size="256" sumtext="부서5"/>
- <Column id="depthngnm6" type="STRING" size="256" sumtext="부서6"/>
- <Column id="depthngnm7" type="STRING" size="256" sumtext="부서7"/>
- <Column id="depthngnm8" type="STRING" size="256" sumtext="부서8"/>
- <Column id="depthngnm9" type="STRING" size="256" sumtext="부서9"/>
- <Column id="depthngnm10" type="STRING" size="256" sumtext="부서10"/>
- <Column id="depthngnm11" type="STRING" size="256" sumtext="부서11"/>
- <Column id="depthngnm12" type="STRING" size="256" sumtext="부서12"/>
- <Column id="depthngnm13" type="STRING" size="256" sumtext="부서13"/>
- <Column id="depthngnm14" type="STRING" size="256" sumtext="부서14"/>
- <Column id="depthngnm15" type="STRING" size="256" sumtext="부서15"/>
- <Column id="depthngnm16" type="STRING" size="256" sumtext="부서16"/>
- <Column id="depthngnm17" type="STRING" size="256" sumtext="부서17"/>
- <Column id="depthngnm18" type="STRING" size="256" sumtext="부서18"/>
- <Column id="depthngnm19" type="STRING" size="256" sumtext="부서19"/>
- <Column id="depthngnm20" type="STRING" size="256" sumtext="부서20"/>
- <Column id="depthngnm21" type="STRING" size="256" sumtext="부서21"/>
- <Column id="depthngnm22" type="STRING" size="256" sumtext="부서22"/>
- <Column id="depthngnm23" type="STRING" size="256" sumtext="부서23"/>
- <Column id="depthngnm24" type="STRING" size="256" sumtext="부서24"/>
- <Column id="depthngnm25" type="STRING" size="256" sumtext="부서25"/>
- <Column id="depthngnm26" type="STRING" size="256" sumtext="부서26"/>
- <Column id="depthngnm27" type="STRING" size="256" sumtext="부서27"/>
- <Column id="depthngnm28" type="STRING" size="256" sumtext="부서28"/>
- <Column id="depthngnm29" type="STRING" size="256" sumtext="부서29"/>
- <Column id="depthngnm30" type="STRING" size="256" sumtext="부서30"/>
- <Column id="depthngnm31" type="STRING" size="256" sumtext="부서31"/>
- <Column id="depthngnm32" type="STRING" size="256" sumtext="부서32"/>
- <Column id="depthngnm33" type="STRING" size="256" sumtext="부서33"/>
- <Column id="depthngnm34" type="STRING" size="256" sumtext="부서34"/>
- <Column id="depthngnm35" type="STRING" size="256" sumtext="부서35"/>
- <Column id="depthngnm36" type="STRING" size="256" sumtext="부서36"/>
- <Column id="depthngnm37" type="STRING" size="256" sumtext="부서37"/>
- <Column id="depthngnm38" type="STRING" size="256" sumtext="부서38"/>
- <Column id="depthngnm39" type="STRING" size="256" sumtext="부서39"/>
- <Column id="depthngnm40" type="STRING" size="256" sumtext="부서40"/>
- <Column id="depthngnm41" type="STRING" size="256" sumtext="부서41"/>
- <Column id="depthngnm42" type="STRING" size="256" sumtext="부서42"/>
- <Column id="depthngnm43" type="STRING" size="256" sumtext="부서43"/>
- <Column id="depthngnm44" type="STRING" size="256" sumtext="부서44"/>
- <Column id="depthngnm45" type="STRING" size="256" sumtext="부서45"/>
- <Column id="depthngnm46" type="STRING" size="256" sumtext="부서46"/>
- <Column id="depthngnm47" type="STRING" size="256" sumtext="부서47"/>
- <Column id="depthngnm48" type="STRING" size="256" sumtext="부서48"/>
- <Column id="depthngnm49" type="STRING" size="256" sumtext="부서49"/>
- <Column id="depthngnm50" type="STRING" size="256" sumtext="부서50"/>
- <Column id="depthngnm51" type="STRING" size="256" sumtext="부서51"/>
- <Column id="depthngnm52" type="STRING" size="256" sumtext="부서52"/>
- <Column id="depthngnm53" type="STRING" size="256" sumtext="부서53"/>
- <Column id="depthngnm54" type="STRING" size="256" sumtext="부서54"/>
- <Column id="depthngnm55" type="STRING" size="256" sumtext="부서55"/>
- <Column id="depthngnm56" type="STRING" size="256" sumtext="부서56"/>
- <Column id="depthngnm57" type="STRING" size="256" sumtext="부서57"/>
- <Column id="depthngnm58" type="STRING" size="256" sumtext="부서58"/>
- <Column id="depthngnm59" type="STRING" size="256" sumtext="부서59"/>
- <Column id="depthngnm60" type="STRING" size="256" sumtext="부서60"/>
- <Column id="depthngnm61" type="STRING" size="256" sumtext="부서61"/>
- <Column id="depthngnm62" type="STRING" size="256" sumtext="부서62"/>
- <Column id="depthngnm63" type="STRING" size="256" sumtext="부서63"/>
- <Column id="depthngnm64" type="STRING" size="256" sumtext="부서64"/>
- <Column id="depthngnm65" type="STRING" size="256" sumtext="부서65"/>
- <Column id="depthngnm66" type="STRING" size="256" sumtext="부서66"/>
- <Column id="depthngnm67" type="STRING" size="256" sumtext="부서67"/>
- <Column id="depthngnm68" type="STRING" size="256" sumtext="부서68"/>
- <Column id="depthngnm69" type="STRING" size="256" sumtext="부서69"/>
- <Column id="depthngnm70" type="STRING" size="256" sumtext="부서70"/>
- <Column id="depthngnm71" type="STRING" size="256" sumtext="부서71"/>
- <Column id="depthngnm72" type="STRING" size="256" sumtext="부서72"/>
- <Column id="depthngnm73" type="STRING" size="256" sumtext="부서73"/>
- <Column id="depthngnm74" type="STRING" size="256" sumtext="부서74"/>
- <Column id="depthngnm75" type="STRING" size="256" sumtext="부서75"/>
- <Column id="depthngnm76" type="STRING" size="256" sumtext="부서76"/>
- <Column id="depthngnm77" type="STRING" size="256" sumtext="부서77"/>
- <Column id="depthngnm78" type="STRING" size="256" sumtext="부서78"/>
- <Column id="depthngnm79" type="STRING" size="256" sumtext="부서79"/>
- <Column id="depthngnm80" type="STRING" size="256" sumtext="부서80"/>
- <Column id="depthngnm81" type="STRING" size="256" sumtext="부서81"/>
- <Column id="depthngnm82" type="STRING" size="256" sumtext="부서82"/>
- <Column id="depthngnm83" type="STRING" size="256" sumtext="부서83"/>
- <Column id="depthngnm84" type="STRING" size="256" sumtext="부서84"/>
- <Column id="depthngnm85" type="STRING" size="256" sumtext="부서85"/>
- <Column id="depthngnm86" type="STRING" size="256" sumtext="부서86"/>
- <Column id="depthngnm87" type="STRING" size="256" sumtext="부서87"/>
- <Column id="depthngnm88" type="STRING" size="256" sumtext="부서88"/>
- <Column id="depthngnm89" type="STRING" size="256" sumtext="부서89"/>
- <Column id="depthngnm90" type="STRING" size="256" sumtext="부서90"/>
- <Column id="depthngnm91" type="STRING" size="256" sumtext="부서91"/>
- <Column id="depthngnm92" type="STRING" size="256" sumtext="부서92"/>
- <Column id="depthngnm93" type="STRING" size="256" sumtext="부서93"/>
- <Column id="depthngnm94" type="STRING" size="256" sumtext="부서94"/>
- <Column id="depthngnm95" type="STRING" size="256" sumtext="부서95"/>
- <Column id="depthngnm96" type="STRING" size="256" sumtext="부서96"/>
- <Column id="depthngnm97" type="STRING" size="256" sumtext="부서97"/>
- <Column id="depthngnm98" type="STRING" size="256" sumtext="부서98"/>
- <Column id="depthngnm99" type="STRING" size="256" sumtext="부서99"/>
- <Column id="depthngnm100" type="STRING" size="256" sumtext="부서100"/>
- <Column id="total" type="STRING" size="256" sumtext="합계"/>
- <Column id="deptlnsfcnt1" type="STRING" size="256" sumtext="부서1"/>
- <Column id="deptlnsfcnt2" type="STRING" size="256" sumtext="부서2"/>
- <Column id="deptlnsfcnt3" type="STRING" size="256" sumtext="부서3"/>
- <Column id="deptlnsfcnt4" type="STRING" size="256" sumtext="부서4"/>
- <Column id="deptlnsfcnt5" type="STRING" size="256" sumtext="부서5"/>
- <Column id="deptlnsfcnt6" type="STRING" size="256" sumtext="부서6"/>
- <Column id="deptlnsfcnt7" type="STRING" size="256" sumtext="부서7"/>
- <Column id="deptlnsfcnt8" type="STRING" size="256" sumtext="부서8"/>
- <Column id="deptlnsfcnt9" type="STRING" size="256" sumtext="부서9"/>
- <Column id="deptlnsfcnt10" type="STRING" size="256" sumtext="부서10"/>
- <Column id="deptlnsfcnt11" type="STRING" size="256" sumtext="부서11"/>
- <Column id="deptlnsfcnt12" type="STRING" size="256" sumtext="부서12"/>
- <Column id="deptlnsfcnt13" type="STRING" size="256" sumtext="부서13"/>
- <Column id="deptlnsfcnt14" type="STRING" size="256" sumtext="부서14"/>
- <Column id="deptlnsfcnt15" type="STRING" size="256" sumtext="부서15"/>
- <Column id="deptlnsfcnt16" type="STRING" size="256" sumtext="부서16"/>
- <Column id="deptlnsfcnt17" type="STRING" size="256" sumtext="부서17"/>
- <Column id="deptlnsfcnt18" type="STRING" size="256" sumtext="부서18"/>
- <Column id="deptlnsfcnt19" type="STRING" size="256" sumtext="부서19"/>
- <Column id="deptlnsfcnt20" type="STRING" size="256" sumtext="부서20"/>
- <Column id="deptlnsfcnt21" type="STRING" size="256" sumtext="부서21"/>
- <Column id="deptlnsfcnt22" type="STRING" size="256" sumtext="부서22"/>
- <Column id="deptlnsfcnt23" type="STRING" size="256" sumtext="부서23"/>
- <Column id="deptlnsfcnt24" type="STRING" size="256" sumtext="부서24"/>
- <Column id="deptlnsfcnt25" type="STRING" size="256" sumtext="부서25"/>
- <Column id="deptlnsfcnt26" type="STRING" size="256" sumtext="부서26"/>
- <Column id="deptlnsfcnt27" type="STRING" size="256" sumtext="부서27"/>
- <Column id="deptlnsfcnt28" type="STRING" size="256" sumtext="부서28"/>
- <Column id="deptlnsfcnt29" type="STRING" size="256" sumtext="부서29"/>
- <Column id="deptlnsfcnt30" type="STRING" size="256" sumtext="부서30"/>
- <Column id="deptlnsfcnt31" type="STRING" size="256" sumtext="부서31"/>
- <Column id="deptlnsfcnt32" type="STRING" size="256" sumtext="부서32"/>
- <Column id="deptlnsfcnt33" type="STRING" size="256" sumtext="부서33"/>
- <Column id="deptlnsfcnt34" type="STRING" size="256" sumtext="부서34"/>
- <Column id="deptlnsfcnt35" type="STRING" size="256" sumtext="부서35"/>
- <Column id="deptlnsfcnt36" type="STRING" size="256" sumtext="부서36"/>
- <Column id="deptlnsfcnt37" type="STRING" size="256" sumtext="부서37"/>
- <Column id="deptlnsfcnt38" type="STRING" size="256" sumtext="부서38"/>
- <Column id="deptlnsfcnt39" type="STRING" size="256" sumtext="부서39"/>
- <Column id="deptlnsfcnt40" type="STRING" size="256" sumtext="부서40"/>
- <Column id="deptlnsfcnt41" type="STRING" size="256" sumtext="부서41"/>
- <Column id="deptlnsfcnt42" type="STRING" size="256" sumtext="부서42"/>
- <Column id="deptlnsfcnt43" type="STRING" size="256" sumtext="부서43"/>
- <Column id="deptlnsfcnt44" type="STRING" size="256" sumtext="부서44"/>
- <Column id="deptlnsfcnt45" type="STRING" size="256" sumtext="부서45"/>
- <Column id="deptlnsfcnt46" type="STRING" size="256" sumtext="부서46"/>
- <Column id="depthngnm47" type="STRING" size="256" sumtext="부서47"/>
- <Column id="depthngnm48" type="STRING" size="256" sumtext="부서48"/>
- <Column id="depthngnm49" type="STRING" size="256" sumtext="부서49"/>
- <Column id="depthngnm50" type="STRING" size="256" sumtext="부서50"/>
- <Column id="depthngnm51" type="STRING" size="256" sumtext="부서51"/>
- <Column id="depthngnm52" type="STRING" size="256" sumtext="부서52"/>
- <Column id="depthngnm53" type="STRING" size="256" sumtext="부서53"/>
- <Column id="depthngnm54" type="STRING" size="256" sumtext="부서54"/>
- <Column id="depthngnm55" type="STRING" size="256" sumtext="부서55"/>
- <Column id="depthngnm56" type="STRING" size="256" sumtext="부서56"/>
- <Column id="depthngnm57" type="STRING" size="256" sumtext="부서57"/>
- <Column id="depthngnm58" type="STRING" size="256" sumtext="부서58"/>
- <Column id="depthngnm59" type="STRING" size="256" sumtext="부서59"/>
- <Column id="depthngnm60" type="STRING" size="256" sumtext="부서60"/>
- <Column id="depthngnm61" type="STRING" size="256" sumtext="부서61"/>
- <Column id="depthngnm62" type="STRING" size="256" sumtext="부서62"/>
- <Column id="depthngnm63" type="STRING" size="256" sumtext="부서63"/>
- <Column id="depthngnm64" type="STRING" size="256" sumtext="부서64"/>
- <Column id="depthngnm65" type="STRING" size="256" sumtext="부서65"/>
- <Column id="depthngnm66" type="STRING" size="256" sumtext="부서66"/>
- <Column id="depthngnm67" type="STRING" size="256" sumtext="부서67"/>
- <Column id="depthngnm68" type="STRING" size="256" sumtext="부서68"/>
- <Column id="depthngnm69" type="STRING" size="256" sumtext="부서69"/>
- <Column id="depthngnm70" type="STRING" size="256" sumtext="부서70"/>
- <Column id="depthngnm71" type="STRING" size="256" sumtext="부서71"/>
- <Column id="depthngnm72" type="STRING" size="256" sumtext="부서72"/>
- <Column id="depthngnm73" type="STRING" size="256" sumtext="부서73"/>
- <Column id="depthngnm74" type="STRING" size="256" sumtext="부서74"/>
- <Column id="depthngnm75" type="STRING" size="256" sumtext="부서75"/>
- <Column id="depthngnm76" type="STRING" size="256" sumtext="부서76"/>
- <Column id="depthngnm77" type="STRING" size="256" sumtext="부서77"/>
- <Column id="depthngnm78" type="STRING" size="256" sumtext="부서78"/>
- <Column id="depthngnm79" type="STRING" size="256" sumtext="부서79"/>
- <Column id="depthngnm80" type="STRING" size="256" sumtext="부서80"/>
- <Column id="depthngnm81" type="STRING" size="256" sumtext="부서81"/>
- <Column id="depthngnm82" type="STRING" size="256" sumtext="부서82"/>
- <Column id="depthngnm83" type="STRING" size="256" sumtext="부서83"/>
- <Column id="depthngnm84" type="STRING" size="256" sumtext="부서84"/>
- <Column id="depthngnm85" type="STRING" size="256" sumtext="부서85"/>
- <Column id="depthngnm86" type="STRING" size="256" sumtext="부서86"/>
- <Column id="depthngnm87" type="STRING" size="256" sumtext="부서87"/>
- <Column id="depthngnm88" type="STRING" size="256" sumtext="부서88"/>
- <Column id="depthngnm89" type="STRING" size="256" sumtext="부서89"/>
- <Column id="depthngnm90" type="STRING" size="256" sumtext="부서90"/>
- <Column id="depthngnm91" type="STRING" size="256" sumtext="부서91"/>
- <Column id="depthngnm92" type="STRING" size="256" sumtext="부서92"/>
- <Column id="depthngnm93" type="STRING" size="256" sumtext="부서93"/>
- <Column id="depthngnm94" type="STRING" size="256" sumtext="부서94"/>
- <Column id="depthngnm95" type="STRING" size="256" sumtext="부서95"/>
- <Column id="depthngnm96" type="STRING" size="256" sumtext="부서96"/>
- <Column id="depthngnm97" type="STRING" size="256" sumtext="부서97"/>
- <Column id="depthngnm98" type="STRING" size="256" sumtext="부서98"/>
- <Column id="depthngnm99" type="STRING" size="256" sumtext="부서99"/>
- <Column id="depthngnm100" type="STRING" size="256" sumtext="부서100"/>
- <Column id="total2" type="STRING" size="256" sumtext="합계"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_csrdeptlist" 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="deptcd" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_codeinfo_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_cmb_reqdetlflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="label" type="STRING" size="256"/>
- <Column id="value" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="label">기구</Col>
- <Col id="value">1</Col>
- </Row>
- <Row>
- <Col id="label">진료재료</Col>
- <Col id="value">2</Col>
- </Row>
- <Row>
- <Col id="label">린넨</Col>
- <Col id="value">3</Col>
- </Row>
- <Row>
- <Col id="label">멸균방포</Col>
- <Col id="value">4</Col>
- </Row>
- <Row>
- <Col id="label">기타</Col>
- <Col id="value">9</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_safestocinfo_paramlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="title" type="STRING" size="256" sumtext="타이틀"/>
- <Column id="cnt" type="STRING" size="256" sumtext="갯수"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cdgrupid" type="STRING" size="256" sumtext="코드그룹ID"/>
- <Column id="srchdd" type="STRING" size="256" sumtext="조회기준일자"/>
- <Column id="flag" type="STRING" size="256" sumtext="조회기준일자"/>
- <Column id="allflag" type="STRING" size="256" sumtext="모두조회여부"/>
- </ColumnInfo>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="grp_sea.ipt_workdd" propid="value" datasetid="ds_main_cond" columnid="workdd"/>
- <BindItem id="item1" compid="grp_sea.cmb_deptcd" propid="value" datasetid="ds_main_cond" columnid="deptcd"/>
- <BindItem id="item2" compid="grp_sea.radio1" propid="value" datasetid="ds_main_cond" columnid="flag"/>
- <BindItem id="item3" compid="grp_sea.ipt_srchnm" propid="value" datasetid="ds_main_cond" columnid="srchnm"/>
- <BindItem id="item4" compid="rdo_reqdetlflag" propid="value" datasetid="ds_main_cond" columnid="reqdetlflag"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-07-11
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-07-11 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- function SMMNG04900_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SMMNG04900_onload(obj:Form, e:LoadEventInfo)
- {
- //grdf_initGrid(grd_safestoclist);
- fInitialize();
- }
- function fInitialize()
- {
- ds_main_cond.setColumn(0, "workdd", utlf_getCurrentDate());
-
- var oParam = {};
- oParam.id = "TRMNG00402";
- oParam.service = "csrapp.CsrMngt";
- oParam.method = "getCsrDeptList";
- oParam.inds = "req=ds_main_cond";
- oParam.outds = "ds_init_csrdeptlist=csrdeptlist";
- oParam.async = false;
- //oParam.callback = "cf_TRMNG00402";
- tranf_submit(oParam);
- frmf_addComboItem("grp_sea.cmb_deptcd","전체","","above");
-
- var cdgrupid = "'T95'"
-
- dsf_makeValue(ds_send_reqdata, "cdgrupid", "string", cdgrupid, 0);
- dsf_makeValue(ds_send_reqdata, "srchdd", "string", utlf_getCurrentDate(), 0);
-
- var oParam = {};
- oParam.id = "TRMNW00001";
- oParam.service = "wardcareapp.WardCareMngt";
- oParam.method = "reqGetNursHardCdInfo";
- oParam.inds = "req=ds_send_reqdata";
- oParam.outds = "ds_init_codeinfo_codelist=codelist";
- oParam.async = false;
- //oParam.callback = "cf_TRMNW00001";
- tranf_submit(oParam);
-
- frmf_addComboItem("rdo_reqdetlflag","전체","","above");
-
- ds_init_codeinfo_codelist.filterstr = "cdgrupid == 'T95' || utlf_isNull(cdid)";
- fSearch();
- }
- function fSearch()
- {
- var oParam = {};
- oParam.id = "TRMNG04901";
- oParam.service = "csrapp.CsrMngt";
- oParam.method = "reqGetSafeStoclist";
- oParam.inds = "req=ds_main_cond";
- oParam.outds = "ds_main_safestocinfo_safestoclist=safestoclist ds_main_safestocinfo_paramlist=paramlist";
- oParam.async = false;
- //oParam.callback = "cf_TRMNG04901";
- tranf_submit(oParam);
-
- var cnt = ds_main_safestocinfo_paramlist.getColumn(0, "cnt");
- var caption = ds_main_safestocinfo_paramlist.getColumn(0, "title");
- caption = caption.split("^");
- var strS = "";
- var strE = "";
- var j = 0;
-
-
- var sColumnInfo = "";
- var sRowInfo = "";
- var sHeadInfo = "";
- var sHeadInfo2 = "";
- var sHeadInfo3 = "";
- var sBodyInfo = "";
- var sFormatInfo = "";
-
- sColumnInfo += '<Columns size="61" band="left"/> \r\n';
- sColumnInfo += '<Columns size="75" band="left"/> \r\n';
- sColumnInfo += '<Columns size="149" band="left"/> \r\n';
- sColumnInfo += '<Columns size="111" band="left"/> \r\n';
- sColumnInfo += '<Columns size="95" band="left"/> \r\n';
- sColumnInfo += '<Columns size="35" band="left"/> \r\n';
-
- sRowInfo += '<Row size="24" band="head" /> \r\n';
- sRowInfo += '<Row size="24" band="head" /> \r\n';
- sRowInfo += '<Row size="24" band="head" /> \r\n';
- sRowInfo += '<Row size="24" /> \r\n';
-
- sHeadInfo = '<Cell rowspan="3" text="구분" taborder="undefined"/> \r\n';
- sHeadInfo += '<Cell col="1" rowspan="3" text="물품코드" taborder="undefined"/> \r\n';
- sHeadInfo += '<Cell col="2" rowspan="3" text="물품명" taborder="undefined"/> \r\n';
- sHeadInfo += '<Cell col="3" rowspan="3" text="상세규격" taborder="undefined"/> \r\n';
- sHeadInfo += '<Cell col="4" rowspan="3" text="모델" taborder="undefined"/> \r\n';
- sHeadInfo += '<Cell col="5" rowspan="3" text="단위" taborder="undefined"/> \r\n';
- sBodyInfo += '<Cell autosizerow="limitmin" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:reqdetlflag" combodataset="ds_cmb_reqdetlflag" combocodecol="value" combodatacol="label"/> \r\n';
- sBodyInfo += '<Cell autosizerow="limitmin" col="1" style="align:left middle;" text="bind:goodcd"/> \r\n';
- sBodyInfo += '<Cell col="2" style="align:left middle;" text="bind:csrgoodnm" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
- sBodyInfo += '<Cell col="3" style="align:left middle;" text="bind:csrgoodspec" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
- sBodyInfo += '<Cell col="4" style="align:left middle;" text="bind:csrgoodmodel" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
- sBodyInfo += '<Cell col="5" text="bind:csrrequnit" wordwrap="word" autosizerow="limitmin" padding="1 2 1 2"/> \r\n';
-
- var gubun = false;
- var row = "1";
- var strS = "";
- var strE = "";
- var k = 6;
- var row1Gubun = false;
- var row2Gubun = false;
- var total = 0;
- for(var i = 6; i < caption.length; i++)
- {
- if(utlf_isNull(caption[i]) || caption[i] == "null"){
- break;
- }
-
- strS = caption[i];
- if(strS != strE){
- sHeadInfo += '<Cell autosizerow="limitmin" col="' + k + '" colspan="2" text="'+ caption[i] +'"/> \r\n';
- sBodyInfo += '<Cell autosizerow="limitmin" col="' + k + '" displaytype="number" style="align:center middle;" text="bind:deptlnsfcnt'+(eval(k/2)-2)+'"/> \r\n';
- sBodyInfo += '<Cell autosizerow="limitmin" col="' + eval(k + 1) + '" displaytype="number" style="align:center middle;" text="bind:depthngnm'+(eval(k/2)-2)+'"/> \r\n';
- }
- strE = strS;
- if(k % 2 == 0){
- sHeadInfo2 += '<Cell row="1" col="' + k + '" text="운용"/> \r\n';
- }else{
- sHeadInfo2 += '<Cell row="1" col="' + k + '" text="물품보관실"/> \r\n';
- }
- sHeadInfo3 += '<Cell row="2" col="' + k + '" text="안전재고"/> \r\n';
- sColumnInfo += '<Columns size="70" /> \r\n';
-
- k++;
- }
-
- sHeadInfo += '<Cell col="' + k + '" colspan="2" text="합계"/> \r\n';
- sHeadInfo2 += '<Cell row="1" col="' + k + '" text="운용"/> \r\n';
- sHeadInfo2 += '<Cell row="1" col="' + (eval(k) + 1)+ '" text="물품보관실"/> \r\n';
-
- sHeadInfo3 += '<Cell row="2" col="' + k + '" text="안전재고"/> \r\n';
- sHeadInfo3 += '<Cell row="2" col="' + (eval(k) + 1) + '" text="안전재고"/> \r\n';
-
- sColumnInfo += '<Columns size="70" /> \r\n';
- sColumnInfo += '<Columns size="70" /> \r\n';
-
- sBodyInfo += '<Cell col="' + k + '" displaytype="number" style="align:center middle;" text="bind:total2"/> \r\n';
- sBodyInfo += '<Cell col="' + (eval(k) + 1) + '" displaytype="number" style="align:center middle;" text="bind:total"/> \r\n';
-
- sHeadInfo = sHeadInfo + sHeadInfo2 + sHeadInfo3;
-
- sColumnInfo = '<Columns> \r\n' + sColumnInfo + '</Columns> \r\n' ;
- sRowInfo = '<Rows> \r\n' + sRowInfo + '</Rows> \r\n';
- sHeadInfo = '<Band id="head"> \r\n' + sHeadInfo + '</Band> \r\n';
- sBodyInfo = '<Band id="body"> \r\n' + sBodyInfo + '</Band> \r\n';
- sFormatInfo = '<Formats> \r\n';
- sFormatInfo += '<Format id="default"> \r\n';
- sFormatInfo += sColumnInfo + sRowInfo + sHeadInfo + sBodyInfo;
- sFormatInfo += '</Format> \r\n';
- sFormatInfo += '</Formats>';
- grd_safestoclist.enableredraw = false;
- grd_safestoclist.formats = sFormatInfo;
- grd_safestoclist.enableredraw = true;
- grd_safestoclist.binddataset = "ds_main_safestocinfo_safestoclist";
- grd_safestoclist.updateToDataset();
- }
- function grp_sea_button5_onclick(obj:Button, e:ClickEventInfo)
- {
- grdf_exportExcel(grd_safestoclist, ds_main_cond.getColumn(0, "workdd")+"물품별안전재고", "sheet1", "true", "", "");
- }
- function rdo_reqdetlflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
- {
- grp_sea.btn_search.click();
- }
- function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- fSearch();
- }
- function grp_sea_cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- grp_sea_btn_search_onclick();
- }
- function grp_sea_ipt_srchnm_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13) {
- obj.updateToDataset();
- //setInputNodeCurText();
- grp_sea_btn_search_onclick();
-
- grp_sea.ipt_srchnm.value = "";
- }
- }
- ]]></Script>
- </Form>
- </FDL>
|