123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839 |
- <?xml version="1.0" encoding="utf-8" standalone="no"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMRST03300" position="absolute 0 0 1195 750" titletext="재고종합조회(약품)" onload="SMRST03300_onload">
- <Layouts>
- <Layout>
- <Div id="group1" position="absolute 0 0 1195 21" style="" scrollbars="none">
- <Layouts>
- <Layout>
- <Static id="caption6" class="tit_1" position="absolute 0 0 189 22" style="" text="재고종합조회(약품)" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- <Div id="group5" scrollbars="autoboth" position="absolute 0 38 1195 700" style="">
- <Layouts>
- <Layout>
- <Grid id="grd_stoclist" binddataset="ds_main_list_goodstoc" visible="false" position="absolute 599 511 1187 655" style="">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="53"/>
- <Column size="279"/>
- <Column size="225"/>
- </Columns>
- <Rows>
- <Row size="25" band="head"/>
- <Row size="25"/>
- </Rows>
- <Band id="head">
- <Cell text="caption1"/>
- <Cell col="1" text="부서"/>
- <Cell col="2" text="수 량"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" text="bind:stocdeptnm"/>
- <Cell col="2" text="bind:stocqty"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Shape id="line7" class="line_2" linetype="horizontal" position="absolute 0 581 594 584" style="" anchor="default"/>
- <Shape id="line3" class="line_2" linetype="horizontal" position="absolute 0 557 594 560" style="" anchor="default"/>
- <Shape id="line2" class="line_2" linetype="horizontal" position="absolute 0 533 594 536" style="" anchor="default"/>
- <Shape id="line8" class="line_3" linetype="horizontal" position="absolute 0 655 594 658" style="" anchor="default"/>
- <Static id="caption21" class="tit_2" position="absolute 5 78 193 99" style="" text="입고내역"/>
- <Div id="group6" position="absolute 0 12 1189 73" style="align: top;" class="div_SA">
- <Layouts>
- <Layout>
- <Button id="btn_search" class="btn1" taborder="8" position="absolute 1116 20 1172 42" style="align:left ;" text="조회" onclick="group5_group6_btn_search_onclick" anchor="default"/>
- <Shape id="line14" class="line_4" linetype="vertical" position="absolute 1109 9 1112 52" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
- <Static id="caption10" class="search_name" position="absolute 15 9 112 26" style="" text="기관코드 :" anchor="default"/>
- <Static id="caption4" class="search_name" position="absolute 15 36 101 53" style="" text="작업년월 :" anchor="default"/>
- <Static id="caption7" class="search_name" position="absolute 382 9 475 26" style="" text="부 서 :" anchor="default"/>
- <Combo innerdataset="ds_init_instcd" datacolumn="cdnm" codecolumn="cdid" columncount="-1" rowcount="-1" id="cmb_instcd" class="combo_essential" enable="False" position="absolute 100 8 333 27" style="align:center ;" anchor="default"/>
- <Calendar id="ipt_frdd" class="input_essential" mask="yyyy-mm" position="absolute 100 35 205 54" style="align:center middle;" anchor="default" onkillfocus="group5_group6_ipt_frdd_onkillfocus" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true"/>
- <Calendar id="ipt_todd" class="input_essential" mask="yyyy-mm" position="absolute 228 35 333 54" style="align:center middle;" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true"/>
- <Static id="caption11" class="search_n_b" position="absolute 212 38 224 55" style="font:,,bolder;" text="~" anchor="default"/>
- <Button id="btn_searchgoodcd" class="icon_search" position="absolute 582 36 598 52" style="" text="" onclick="group5_group6_btn_searchgoodcd_onclick" anchor="default"/>
- <Edit id="opt_goodspec" class="output_fix" position="absolute 821 35 899 54" style="" anchor="default" readonly="true" enable="false"/>
- <Edit id="input9" class="input_essential" position="absolute 600 35 707 54" style="" anchor="default"/>
- <Edit id="ipt_goodcd" class="input_essential" position="absolute 467 35 578 54" style="" anchor="default" onkillfocus="group5_group6_ipt_goodcd_onkillfocus" onkeydown="group5_group6_ipt_goodcd_onkeydown"/>
- <Static id="caption1" class="search_name" position="absolute 382 36 477 53" style="" text="약품코드 :" anchor="default"/>
- <Edit id="opt_goodmodel" class="output_fix" position="absolute 901 35 997 54" style="" anchor="default" readonly="true" enable="false"/>
- <Edit id="ipt_goodnm" class="input_fix" position="absolute 601 35 816 54" style="" anchor="default" onkillfocus="group5_group6_ipt_goodnm_onkillfocus" onkeydown="group5_group6_ipt_goodnm_onkeydown"/>
- <Edit id="opt_prodcmpynm" class="output_fix" position="absolute 998 35 1080 54" style="" anchor="default" readonly="true" enable="false"/>
- <Combo innerdataset="@ds_init_cmb_deptcd_deptcdlist" datacolumn="deptnm" codecolumn="deptcd" columncount="-1" rowcount="-1" id="cmb_deptcd" class="combo_essential" position="absolute 467 10 620 29" style="align:center ;" anchor="default"/>
- <Edit id="opt_goodflag" position="absolute 990 10 1090 30" style="" anchor="default" readonly="true" visible="false"/>
- </Layout>
- </Layouts>
- </Div>
- <Shape id="line15" class="line_1" linetype="horizontal" position="absolute 0 95 730 98" style="strokepen:5 solid #33bbbbff;" anchor="default"/>
- <Grid id="grd_win" binddataset="ds_main_list_goodwin" position="absolute 0 100 730 487" style="">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="81"/>
- <Column size="58"/>
- <Column size="55"/>
- <Column size="81"/>
- <Column size="62"/>
- <Column size="80"/>
- <Column size="73"/>
- <Column size="120"/>
- <Column size="116"/>
- <Column size="100"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="25" band="head"/>
- <Row size="25"/>
- </Rows>
- <Band id="head">
- <Cell text="입고일자"/>
- <Cell col="1" text="번호"/>
- <Cell col="2" text="순번"/>
- <Cell col="3" text="입고유형"/>
- <Cell col="4" text="수량"/>
- <Cell col="5" text="단가"/>
- <Cell col="6" text="금액"/>
- <Cell col="7" text="주거래처"/>
- <Cell col="8" text="보조거래처"/>
- </Band>
- <Band id="body">
- <Cell displaytype="date" edittype="date" text="bind:windd" calendardisplaynulltype="none"/>
- <Cell col="1" displaytype="text" edittype="none" style="align:center middle;" text="bind:winno"/>
- <Cell col="2" displaytype="text" edittype="none" style="align:center middle;" text="bind:winseqno"/>
- <Cell col="3" text="bind:iokindnm"/>
- <Cell col="4" displaytype="number" style="align:right middle;" text="bind:winqty"/>
- <Cell col="5" displaytype="number" style="align:right middle;" text="bind:winunitcost"/>
- <Cell col="6" displaytype="number" style="align:right middle;" text="bind:winamt"/>
- <Cell col="7" text="bind:suplplcenm"/>
- <Cell col="8" text="bind:subsuplplcenm"/>
- <Cell col="9" displaytype="text" style="align:right middle;" text="bind:instcd"/>
- <Cell col="10" text="bind:goodcd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Grid id="grd_gooddelive" binddataset="ds_main_list_gooddelive" position="absolute 735 100 1187 655" style="" oncelldblclick="group5_grd_gooddelive_oncelldblclick">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="116"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="97"/>
- <Column size="71"/>
- <Column size="137"/>
- </Columns>
- <Rows>
- <Row size="25" band="head"/>
- <Row size="25"/>
- </Rows>
- <Band id="head">
- <Cell text="출고일자"/>
- <Cell col="1" text="번호"/>
- <Cell col="2" text="순번"/>
- <Cell col="3" text="출고유형"/>
- <Cell col="4" text="수량"/>
- <Cell col="5" text="입고부서"/>
- </Band>
- <Band id="body">
- <Cell displaytype="date" edittype="date" text="bind:delivedd" calendardisplaynulltype="none"/>
- <Cell col="1" text="bind:deliveno"/>
- <Cell col="2" text="bind:deliveseqno"/>
- <Cell col="3" text="bind:iokindnm"/>
- <Cell col="4" displaytype="number" edittype="masknumber" text="bind:delivedeptqty"/>
- <Cell col="5" style="align:left;" text="bind:windeptnm"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Shape id="line1" class="line_1" linetype="horizontal" position="absolute 735 96 1187 98" style="strokepen:5 solid #33bbbbff;" anchor="default"/>
- <Static id="caption3" class="tit_2" position="absolute 740 78 928 99" style="" text="출고내역"/>
- <Shape id="line5" class="line_1" linetype="horizontal" position="absolute 599 506 1187 509" style="strokepen:5 solid #33bbbbff;" anchor="default" visible="false"/>
- <Static id="caption5" class="tit_2" position="absolute 604 490 792 511" style="" text="부서별 ONLINE 재고" visible="false"/>
- <Static id="caption13" class="tit_2" position="absolute 5 490 193 511" style="" text="입출고 합계"/>
- <Shape id="line6" class="line_1" linetype="horizontal" position="absolute 0 508 594 511" style="strokepen:5 solid #33bbbbff;" anchor="default"/>
- <Static id="caption2" class="cell_1" position="absolute 0 536 85 559" style="align: middle;" text="이월수량"/>
- <Static id="caption16" class="cell_1" position="absolute 0 560 85 583" style="align: middle;" text="입고합계"/>
- <Static id="caption17" class="cell_1" position="absolute 0 584 85 607" style="align: middle;" text="출고합계"/>
- <Static id="caption18" class="cell_1" position="absolute 0 608 85 631" style="align: middle;" text="재고수량"/>
- <Div id="group2" position="absolute 404 81 824 391" style="background:beige;" visible="false">
- <Layouts>
- <Layout>
- <Grid id="grd_goodlist" binddataset="ds_init_main_goodlist" visible="true" position="absolute 3 28 418 303" style="" oncelldblclick="group5_group2_grd_goodlist_oncelldblclick" anchor="default">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="24"/>
- <Column size="102"/>
- <Column size="270"/>
- <Column size="0"/>
- <Column size="0"/>
- </Columns>
- <Rows>
- <Row size="25" band="head"/>
- <Row size="25"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="약품코드"/>
- <Cell col="2" text="약품명"/>
- <Cell col="3" text="기관코드"/>
- <Cell col="4" text="물품구분"/>
- <Cell col="5" text="작업년월"/>
- <Cell col="6" text="부서코드"/>
- <Cell col="7" text="대분류코드"/>
- <Cell col="8" text="재고조정처리여부"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" style="align:left middle;" text="bind:goodcd"/>
- <Cell col="2" style="align:left middle;" text="bind:goodnm"/>
- <Cell col="3" text="bind:instcd"/>
- <Cell col="4" text="bind:goodflag"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="button1" class="btn2" position="absolute 364 4 417 23" style="" text="숨기기" onclick="group5_group2_button1_onclick" anchor="default" visible="false"/>
- </Layout>
- </Layouts>
- </Div>
- <Grid id="grd_goodsum" binddataset="ds_main_list_goodsum" class="datagrid2" visible="false" position="absolute 10 380 595 490" style="">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="70"/>
- <Column size="37"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="28" band="head"/>
- <Row size="25"/>
- </Rows>
- <Band id="head">
- <Cell text="작업년월"/>
- <Cell col="1" text="마감 여부"/>
- <Cell col="2" text="이월수량"/>
- <Cell col="3" text="입고수량"/>
- <Cell col="4" text="입고금액"/>
- <Cell col="5" text="출고합계"/>
- <Cell col="6" text="재고수량"/>
- </Band>
- <Band id="body">
- <Cell text="bind:workmm"/>
- <Cell col="1" text="bind:colseyn"/>
- <Cell col="2" style="align:right;" text="bind:brngfwrdqty"/>
- <Cell col="3" style="align:right;" text="bind:winqty"/>
- <Cell col="4" style="align:right;" text="bind:winamt"/>
- <Cell col="5" style="align:right;" text="bind:deliveqty"/>
- <Cell col="6" style="align:right;" text="bind:stocqty"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="btn_detail" class="btn2" position="absolute 230 536 327 555" style="" text="상세내역보기" onclick="group5_btn_detail_onclick"/>
- <Button id="btn_excel_all" class="btn2" position="absolute 660 74 724 93" style="" text="엑셀저장" onclick="group5_btn_excel_all_onclick"/>
- <Button id="button2" class="btn2" position="absolute 1126 75 1190 94" style="" text="엑셀저장" onclick="group5_button2_onclick"/>
- <MaskEdit id="ss" taborder="1" position="absolute 87 537 226 557" mask="###,###,##0" enable="false"/>
- <MaskEdit id="output1" taborder="2" position="absolute 88 562 225 582" mask="###,###,##0" enable="false"/>
- <MaskEdit id="output3" taborder="3" mask="###,###,##0" position="absolute 88 586 225 606" enable="false"/>
- <MaskEdit id="output4" taborder="4" mask="###,###,##0" position="absolute 88 610 225 630" enable="false"/>
- <MaskEdit id="output2" taborder="5" mask="###,###,##0" position="absolute 232 562 369 582" enable="false"/>
- <MaskEdit id="output5" taborder="6" mask="###,###,##0" position="absolute 334 535 473 555" visible="false" enable="false"/>
- </Layout>
- </Layouts>
- </Div>
- <Div id="group4" scrollbars="none" position="absolute 0 20 1187 47" style="">
- <Layouts>
- <Layout>
- <Button id="btn_init" class="btn4" position="absolute 1119 3 1187 25" style="" text="초기화" onclick="group4_btn_init_onclick" anchor="default"/>
- <Shape id="line4" class="line_6" linetype="horizontal" position="absolute 0 25 1195 28" style="" anchor="default"/>
- <Button id="btn_print" class="btn6" enable="True" position="absolute 0 3 60 25" style="" text="출력" onclick="group4_btn_print_onclick" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_hidden_list_goodsum_goodsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="brngfwrdqty" type="STRING" size="256"/>
- <Column id="orgdeliveqty" type="STRING" size="256"/>
- <Column id="winqty" type="STRING" size="256"/>
- <Column id="winamt" type="STRING" size="256"/>
- <Column id="deliveqty" type="STRING" size="256"/>
- <Column id="stocqty" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main_list_goodwin" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="goodwinlist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="goodwinlist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_list_gooddelive" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="gooddelivelist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="gooddelivelist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send_goodstoc" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="goodcd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="goodcd"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="stocsumqty" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="stocsumqty"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_hidden_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="goodinfo" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_hidden_list_goodsum" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main_list_goodsum" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="goodsumlist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="goodsumlist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main_list_goodstoc" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="goodstoclist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="goodstoclist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send_goodiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="goodflag" type="STRING" size="256"/>
- <Column id="deptcd" type="STRING" size="256"/>
- <Column id="goodcd" type="STRING" size="256"/>
- <Column id="goodnm" type="STRING" size="256"/>
- <Column id="goodspec" type="STRING" size="256"/>
- <Column id="goodmodel" type="STRING" size="256"/>
- <Column id="prodcmpynm" type="STRING" size="256"/>
- <Column id="iofrdd" type="STRING" size="256"/>
- <Column id="iotodd" type="STRING" size="256"/>
- <Column id="stocym" type="STRING" size="256"/>
- <Column id="lrgcd" type="STRING" size="256"/>
- <Column id="lrgnm" type="STRING" size="256"/>
- <Column id="flag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="goodflag"/>
- <Col id="deptcd"/>
- <Col id="goodcd"/>
- <Col id="goodnm"/>
- <Col id="goodspec"/>
- <Col id="goodmodel"/>
- <Col id="prodcmpynm"/>
- <Col id="iofrdd"/>
- <Col id="iotodd"/>
- <Col id="stocym"/>
- <Col id="lrgcd"/>
- <Col id="lrgnm"/>
- <Col id="flag"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send_deptgref" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_init_cmb_deptcd_deptcdlist" 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="deptnm" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_list_goodwin_goodwinlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_init_main_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_list_goodsum_goodsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_list_gooddelive_gooddelivelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_list_goodstoc_goodstoclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_prtinfo_list_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_prtinfo_list_send_goodiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_prtinfo_list_goodwin_goodwinlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_prtinfo_list_gooddelive_gooddelivelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_prtinfo_list_goodsum_goodsumlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group5.group6.cmb_instcd" propid="value" datasetid="ds_send_goodiolist" columnid="instcd"/>
- <BindItem id="item1" compid="group5.group6.ipt_frdd" propid="value" datasetid="ds_send_goodiolist" columnid="iofrdd"/>
- <BindItem id="item2" compid="group5.group6.ipt_todd" propid="value" datasetid="ds_send_goodiolist" columnid="iotodd"/>
- <BindItem id="item3" compid="group5.group6.opt_goodspec" propid="value" datasetid="ds_send_goodiolist" columnid="goodspec"/>
- <BindItem id="item4" compid="group5.group6.ipt_goodcd" propid="value" datasetid="ds_send_goodiolist" columnid="goodcd"/>
- <BindItem id="item5" compid="group5.group6.opt_goodmodel" propid="value" datasetid="ds_send_goodiolist" columnid="goodmodel"/>
- <BindItem id="item6" compid="group5.group6.ipt_goodnm" propid="value" datasetid="ds_send_goodiolist" columnid="goodnm"/>
- <BindItem id="item7" compid="group5.group6.opt_prodcmpynm" propid="value" datasetid="ds_send_goodiolist" columnid="prodcmpynm"/>
- <BindItem id="item8" compid="group5.group6.cmb_deptcd" propid="value" datasetid="ds_send_goodiolist" columnid="deptcd"/>
- <BindItem id="item9" compid="group5.group6.opt_goodflag" propid="value" datasetid="ds_send_goodiolist" columnid="goodflag"/>
- <BindItem id="item16" compid="group5.ss" propid="value" datasetid="ds_hidden_list_goodsum_goodsumlist" columnid="brngfwrdqty"/>
- <BindItem id="item10" compid="group5.output1" propid="value" datasetid="ds_hidden_list_goodsum_goodsumlist" columnid="winqty"/>
- <BindItem id="item11" compid="group5.output3" propid="value" datasetid="ds_hidden_list_goodsum_goodsumlist" columnid="deliveqty"/>
- <BindItem id="item13" compid="group5.output4" propid="value" datasetid="ds_hidden_list_goodsum_goodsumlist" columnid="stocqty"/>
- <BindItem id="item12" compid="group5.output2" propid="value" datasetid="ds_hidden_list_goodsum_goodsumlist" columnid="winamt"/>
- <BindItem id="item14" compid="group5.output5" propid="value" datasetid="ds_hidden_list_goodsum_goodsumlist" columnid="orgdeliveqty"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-06-19
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-06-19 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- include "mis_miscommonxp::MIS.xjs";
- include "mis_miscommonxp::RSZ001.xjs";
- function SMRST03300_onload(obj:Form, e:LoadEventInfo) {
- frmf_initForm(obj);
- grdf_initGrid(group5.grd_win);
- grdf_setRowTypeIcon(group5.group2.grd_goodlist, 0);
- //grdf_setGridSort(grd_XXX);
- //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
- //화면 Control을 초기화한다
- fInitialize();
- }
- //전체에서 event와 src를 제외한 script 를 모두포함.
- // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
- function fInitialize() {
- //rszfUserGoodFlagList(cmb_goodflag,sysf_getUserInfo("userid"));
- //hidden col
- // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
- ds_send_goodiolist.setColumn(0,"goodflag", "PH");
- rszfUserInstList(group5.group6.cmb_instcd,sysf_getUserInfo("userid"));
- ds_send_goodiolist.setColumn(0,"instcd", sysf_getUserInfo("dutplceinstcd"));
-
- rszfComboStockArthDeptcdList("group5.group6.cmb_deptcd",sysf_getUserInfo("dutplceinstcd"),group5.group6.opt_goodflag.value );
- if(ds_init_cmb_deptcd_deptcdlist.rowcount == 1){
- ds_send_goodiolist.setColumn( 0, "deptcd",ds_init_cmb_deptcd_deptcdlist.getColumn(0,"deptcd"));
- }
- var curdate = utlf_getCurrentDate().substring(0,6);
- group5.group6.ipt_frdd.value = curdate;
- group5.group6.ipt_todd.value = curdate;
-
- misfGridInit(group5.grd_win);
- misfGridInit(group5.grd_gooddelive);
- misfGridInit(group5.grd_stoclist);
- misfGridInit(group5.grd_goodsum);
- group5.grd_stoclist.subtotalposition = "after";
- //model.refresh();
- }
- function fRetrevie()
- {
- if(fCheckRetrieveData() == false)return;
-
- ds_send_goodiolist.setColumn(0,"iofrdd",ds_send_goodiolist.getColumn(0,"iofrdd").substring(0,6));
- ds_send_goodiolist.setColumn(0,"iotodd",ds_send_goodiolist.getColumn(0,"iotodd").substring(0,6));
- var oParam = {};
- oParam.id = "TRRST01302";
- oParam.service = "stocsumapp.StocSumMngt";
- oParam.method = "reqGetGoodStocByWin";
- oParam.inds = "req=ds_send_goodiolist";
- oParam.outds = "ds_main_list_goodwin=goodwinlist ds_main_list_gooddelive=gooddelivelist ds_main_list_goodsum=goodsumlist ds_main_list_goodstoc=goodstoclist";
- oParam.async = false;
- oParam.callback = "cf_TRRST01302";
- tranf_submit(oParam);
-
- }
- function cf_TRRST01302(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- /*
- group5.grd_gooddelive.subtotal("clear", group5.grd_gooddelive.colRef("iokindnm"), group5.grd_gooddelive.colRef("delivedeptqty"));
- group5.grd_gooddelive.subtotal("sum", group5.grd_gooddelive.colRef("iokindnm"), group5.grd_gooddelive.colRef("delivedeptqty"), "#,###.##","font-weight:normal;", group5.grd_gooddelive.colRef("delivedd"), "합계");
- group5.grd_gooddelive.addRow(false);
- group5.grd_gooddelive.valueMatrix(group5.grd_gooddelive.row,group5.grd_gooddelive.colRef("delivedd"))="재고보정";
- var deliveqty = Number(ds_main_list_goodsum_goodsumlist.getColumn(0, "deliveqty"));
- var orgdeliveqty = Number(ds_main_list_goodsum_goodsumlist.getColumn(0, "orgdeliveqty"));
- group5.grd_gooddelive.valueMatrix(group5.grd_gooddelive.row,group5.grd_gooddelive.colRef("delivedeptqty"))=deliveqty - orgdeliveqty;
- group5.grd_gooddelive.rowStyle(group5.grd_gooddelive.row, "data", "font-weight") = "normal";
- */
- var brngfwrdqty = 0;
- var winqty = 0;
- var winamt = 0;
- var deliveqty= 0;
- var stocqty = 0;
- for(var k =0; k <ds_main_list_goodsum.rowcount;k++){
- brngfwrdqty = parseFloat(ds_main_list_goodsum.getColumn(k,"brngfwrdqty"));
- winqty = winqty+parseFloat(ds_main_list_goodsum.getColumn(k,"winqty"));
- winamt = winamt+parseFloat(ds_main_list_goodsum.getColumn(k,"winamt"));
- deliveqty = deliveqty+parseFloat(ds_main_list_goodsum.getColumn(k,"deliveqty"));
- stocqty = stocqty+parseFloat(ds_main_list_goodsum.getColumn(k,"stocqty"));
- }
- ds_hidden_list_goodsum_goodsumlist.setColumn( 0, "brngfwrdqty" ,brngfwrdqty);
- ds_hidden_list_goodsum_goodsumlist.setColumn( 0, "winqty" ,winqty);
- ds_hidden_list_goodsum_goodsumlist.setColumn( 0, "winamt" ,winamt);
- ds_hidden_list_goodsum_goodsumlist.setColumn( 0, "deliveqty" ,deliveqty);
- ds_hidden_list_goodsum_goodsumlist.setColumn( 0, "stocqty" ,stocqty);
- //group5.grd_stoclist.subtotal("clear", 0, 0);
- //group5.grd_stoclist.subtotal("sum", 0, 2, "format:#,###.0; ", "background-color:#ffff99; font-weight:bold; ", group5.grd_stoclist.colRef("stocdeptnm"), "합계");
-
- //model.refresh();
- }
- function fCheckRetrieveData()
- {
- if(utlf_isNull(group5.group6.cmb_instcd.value))
- {
- group5.group6.cmb_instcd.setFocus();
- return false;
- }
- if(utlf_isNull(group5.group6.cmb_deptcd.value))
- {
- group5.group6.cmb_deptcd.setFocus();
- return false;
- }
- if(utlf_isNull(group5.group6.ipt_frdd.value))
- {
- group5.group6.ipt_frdd.setFocus();
- return false;
- }
- if(utlf_isNull(group5.group6.ipt_todd.value))
- {
- group5.group6.ipt_todd.setFocus();
- return false;
- }
- if(utlf_isNull(group5.group6.ipt_goodcd.value) )
- {
- group5.group6.ipt_goodcd.setFocus();
- return false;
- }
- }
- function group5_group6_btn_search_onclick(obj:Button, e:ClickEventInfo) {
- fRetrevie();
- }
- function group5_group6_btn_searchgoodcd_onclick(obj:Button, e:ClickEventInfo) {
- fSearchGoodSearch(3);
- }
- function fSearchGoodSearch(flag) {
-
- if(flag!=2) {
- ds_send_goodiolist.setColumn(0, "goodnm", "");
- }
-
- var oParam = {};
- oParam.id = "TRRSD00192";
- oParam.service = "purccommonapp.PurcCommon";
- oParam.method = "reqGetPhamGoodListByCond";
- oParam.inds = "req=ds_send_goodiolist";
- oParam.outds = "ds_init_main_goodlist=goodlist";
- oParam.async = false;
- oParam.callback = "cf_TRRSD00192";
- tranf_submit(oParam);
- }
- function cf_TRRSD00192(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- ds_init_main_goodlist.addColumn("goodspec","string");
- ds_init_main_goodlist.addColumn("goodmodel","string");
- ds_init_main_goodlist.addColumn("prodcmpynm","string");
-
- var nodecnts = ds_init_main_goodlist.rowcount;
-
- if (nodecnts >= 2) {
- group5.group2.visible = true;
- } else if (nodecnts == 1) {
- var goodcd = ds_init_main_goodlist.getColumn(0, "goodcd");
- var goodnm = ds_init_main_goodlist.getColumn(0, "goodnm");
- var goodspec = ds_init_main_goodlist.getColumn(0, "goodspec");
- var goodmodel = ds_init_main_goodlist.getColumn(0, "goodmodel");
- var prodcmpynm = ds_init_main_goodlist.getColumn(0, "prodcmpynm");
- dsf_makeValue( ds_send_goodiolist, "goodcd", "string", goodcd)
- dsf_makeValue( ds_send_goodiolist, "goodnm", "string", goodnm)
- dsf_makeValue( ds_send_goodiolist, "goodspec", "string", goodspec)
- dsf_makeValue( ds_send_goodiolist, "goodmodel", "string", goodmodel)
- dsf_makeValue( ds_send_goodiolist, "prodcmpynm", "string", prodcmpynm)
- } else {
- sysf_messageBox("검색된 코드가 없습니다.", "I");
- }
- }
- function group5_group6_ipt_goodcd_onkillfocus(obj:Edit, e:KillFocusEventInfo) {
-
- fSearchGoodSearch();
- }
- function group5_group6_ipt_goodcd_onkeydown(obj:Edit, e:KeyEventInfo) {
- obj.updateToDataset();
-
- if (e.keycode == 13)
- {
- //group5.group6.ipt_goodnm.value = "";
- fSearchGoodSearch(1);
-
- }
- }
- function group5_group6_ipt_goodnm_onkillfocus(obj:Edit, e:KillFocusEventInfo) {
- if(group5.group6.ipt_goodnm.value.length == 0)
- {
- group5.group6.ipt_goodcd.value = "";
- group5.group6.opt_goodspec.value = "";
- group5.group6.opt_goodmodel.value = "";
- group5.group6.opt_prodcmpynm.value = "";
- }
- else {
- ds_send_goodiolist.setColumn( 0, "goodcd" , "")
- ds_send_goodiolist.setColumn( 0, "flag", "N");
- group5.group6.btn_searchgoodcd.dispatch("DOMActivate");
- // submit("TRRSD00192");
- }
- // rszfValidationCheck("TRRSD00191", "goodlist" , "refcond,instcd,goodflag,goodnm",
- // "goodnm," + model.getValue(group5.group6.cmb_instcd.attribute("ref")) + "," + model.getValue(group5.group6.opt_goodflag.attribute("ref")) + "," + model.getValue(group5.group6.ipt_goodnm.attribute("ref")) ,"","goodcd,goodnm,goodspec,goodmodel,prodcmpynm",
- // ipt_goodcd,"SPRSD00210","instcd,goodflag,goodnm","cmb_instcd,group5.group6.opt_goodflag,ipt_goodnm","Y");
- //model.refresh();
- }
- function group5_group6_ipt_goodnm_onkeydown(obj:Edit, e:KeyEventInfo) {
- obj.updateToDataset();
- if (e.keycode == 13)
- {
- fSearchGoodSearch(2);
- }
- }
- function group5_grd_gooddelive_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
- var grdinx = ds_main_list_gooddelive.rowposition;
- dsf_makeValue( ds_temp, "drugcd", "string", ds_send_goodiolist.getColumn(0, "goodcd"));
- dsf_makeValue( ds_temp, "toddflag", "string", ds_main_list_gooddelive.getColumn(grdinx, "delivedd"));
- dsf_makeValue( ds_temp, "indeptcd", "string", ds_main_list_gooddelive.getColumn(grdinx, "windeptnm"));
- dsf_makeValue( ds_temp, "issdeptcd", "string", ds_send_goodiolist.getColumn(0, "deptcd"));
- var objArg = new Object();
- objArg.arg_ds_temp = ds_temp;
- var wndobj = frmf_findPopup("SMRST03302");
-
- if(utlf_isNull(wndobj)){
- trace('1');
- frmf_open("SMRST03302", "SMRST03302", objArg, "", "", "", "", "", "", "", "", "", "M");
- } else {
- trace('2');
- wndobj.ds_main_prcplist_prcpinfo.clearData();
- wndobj.ds_temp.clearData();
- // wndobj.ds_temp.setColumn( 0, "drugcd", ds_temp.getColumn(0, "drugcd"));
- // wndobj.dsf_makeValue( ds_send, "toddflag", "string", ds_temp.getColumn(0, "toddflag"));
- // wndobj.dsf_makeValue( ds_send, "indeptcd", "string", ds_temp.getColumn(0, "indeptcd"));
- // wndobj.dsf_makeValue( ds_send, "issdeptcd", "string", ds_temp.getColumn(0, "issdeptcd"));
-
- wndobj.fInitialize();
- //wndobj.model.refresh();
- }
- }
- function group5_group2_grd_goodlist_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
- var ind = obj.getCellPos();
-
- //if (isDataCell() == true) {
- if (ind >= 0) {
- var cnts = ds_init_main_goodlist.rowcount;
- var row = ds_init_main_goodlist.rowposition;
- var goodcd = ds_init_main_goodlist.getColumn(row, "goodcd");
- var goodnm = ds_init_main_goodlist.getColumn(row, "goodnm");
- var goodspec = ds_init_main_goodlist.getColumn(row, "goodspec");
- var goodmodel = ds_init_main_goodlist.getColumn(row, "goodmodel");
- var prodcmpynm = ds_init_main_goodlist.getColumn(row, "prodcmpynm");
- dsf_makeValue( ds_send_goodiolist, "goodcd", "string", goodcd);
- dsf_makeValue( ds_send_goodiolist, "goodnm", "string", goodnm);
- dsf_makeValue( ds_send_goodiolist, "goodspec", "string", goodspec);
- dsf_makeValue( ds_send_goodiolist, "goodmodel", "string", goodmodel);
- dsf_makeValue( ds_send_goodiolist, "prodcmpynm", "string", prodcmpynm);
- group5.group2.visible = false;
- //model.refresh();
- }
- }
- function group5_group2_button1_onclick(obj:Button, e:ClickEventInfo) {
- group5.group2.visible = false
- }
- function group5_btn_detail_onclick(obj:Button, e:ClickEventInfo) {
- if(group5.btn_detail.text=="상세내역보기"){
- group5.grd_goodsum.visible = true;
- group5.btn_detail.text ="상세내역숨기기"
- }else if(group5.btn_detail.text=="상세내역숨기기"){
- group5.grd_goodsum.visible = false;
- group5.btn_detail.text="상세내역보기"
- }
- //group5.btn_detail.refresh();
- }
- function group5_btn_excel_all_onclick(obj:Button, e:ClickEventInfo) {
- grdf_exportExcel(group5.grd_win, "재고 종합 입고현황", "재고 종합 입고현황1", "true", "", "");
- }
- function group5_button2_onclick(obj:Button, e:ClickEventInfo) {
- grdf_exportExcel(group5.grd_gooddelive, "재고 종합 출고현황", "재고 종합 출고현황1", "false", "", "");
- }
- function group4_btn_init_onclick(obj:Button, e:ClickEventInfo) {
- fInitialize();
- }
- function group4_btn_print_onclick(obj:Button, e:ClickEventInfo) {
- //ds_prtinfo_list.clearData();
- // dsf_makeValue( ds_prtinfo_list_send, "goodiolist", "string", "" );
- // dsf_makeValue( ds_prtinfo_list_goodwin, "goodwinlist", "string", "" );
- // dsf_makeValue( ds_prtinfo_list_gooddelive, "gooddelivelist", "string", "" );
- // dsf_makeValue( ds_prtinfo_list_goodsum, "goodsumlist", "string", "" );
-
- ds_prtinfo_list_goodwin_goodwinlist.copyData(ds_main_list_goodwin_goodwinlist);
- ds_prtinfo_list_gooddelive_gooddelivelist.copyData(ds_main_list_gooddelive_gooddelivelist);
- ds_prtinfo_list_goodsum_goodsumlist.copyData(ds_main_list_goodsum_goodsumlist);
-
- var objDOM = rptf_createDOM();
- var objParam = new Object();
- rptf_setNodeListToDOM(objDOM, "/root/prtinfo/list/send/goodiolist" , ds_send_goodiolist);
- rptf_setNodeListToDOM(objDOM, "/root/prtinfo/list/goodwin/goodwinlist" , ds_main_list_goodwin);
- rptf_setNodeListToDOM(objDOM, "/root/prtinfo/list/gooddelive/gooddelivelist" , ds_main_list_gooddelive);
- rptf_setNodeListToDOM(objDOM, "/root/prtinfo/list/goodsum/goodsumlist" , ds_main_list_goodsum);
- objParam.xml_data_XML1 = objDOM.documentElement.source;
- var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
- rptf_exeReportPreview30(["RPRST03300"],[objParam], option);
- }
- ]]></Script>
- </Form>
- </FDL>
|