123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMRAH01300" position="absolute 0 0 1198 780" titletext="정산비등록" oninit="SMRAH01300_oninit" onload="SMRAH01300_onload">
- <Layouts>
- <Layout>
- <Static id="caption6" text="정산비등록" class="tit_1" position="absolute 0 0 293 25"/>
- <Shape id="line2" class="line_6" position="absolute 0 46 1194 52" anchor="left top right"/>
- <Button id="button3" taborder="1" text="출력" class="btn6" position="absolute 1081 25 1137 47" onclick="button3_onclick" anchor="top right"/>
- <Button id="btn_save" taborder="2" text="저장" class="btn4" position="absolute 1139 25 1195 47" onclick="btn_save_onclick" anchor="top right"/>
- <Div id="grp_sea" taborder="3" class="div_SA2" position="absolute 0 50 1195 130" anchor="left top right">
- <Layouts>
- <Layout>
- <Static id="caption7" text="년도 및 분기 :" class="search_name" position="absolute 16 7 125 24" anchor="default"/>
- <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1116 3 1122 31" anchor="top right"/>
- <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1126 7 1182 29" onclick="grp_sea_btn_search_onclick" anchor="top right"/>
- <Edit id="input1" taborder="2" position="absolute 135 6 185 25" autoselect="true" autoskip="true" style="align:center middle;" onkeydown="grp_sea_input1_onkeydown" anchor="default"/>
- <Combo id="cmb_dateflag" taborder="3" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_essential" position="absolute 190 6 230 25" onitemchanged="grp_sea_cmb_dateflag_onitemchanged" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">1</Col>
- <Col id="datacolumn">1</Col>
- </Row>
- <Row>
- <Col id="codecolumn">2</Col>
- <Col id="datacolumn">2</Col>
- </Row>
- <Row>
- <Col id="codecolumn">3</Col>
- <Col id="datacolumn">3</Col>
- </Row>
- <Row>
- <Col id="codecolumn">4</Col>
- <Col id="datacolumn">4</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Static id="caption2" text="/ 4 분기" position="absolute 240 6 300 26" anchor="default"/>
- <Static id="caption3" text="정산구분 :" class="search_name" position="absolute 325 7 420 24" anchor="default"/>
- <Combo id="combo1" taborder="4" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_essential" enable="false" position="absolute 415 6 550 25" onitemchanged="grp_sea_combo1_onitemchanged" 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>
- </Combo>
- <Static id="caption5" text="정산부서 :" class="search_name" position="absolute 580 7 675 24" anchor="default"/>
- <Combo id="combo2" taborder="5" innerdataset="@ds_init_deptinfo_deptlist" codecolumn="deptcd" datacolumn="deptnm" class="combo_essential" position="absolute 670 6 885 25" onitemchanged="grp_sea_combo2_onitemchanged" anchor="default"/>
- <Combo id="combo3" taborder="6" innerdataset="@ds_init_emplnoinfo_emplnolist" codecolumn="emplno" datacolumn="emplnm" class="combo_essential" enable="false" position="absolute 985 6 1102 25" onitemchanged="grp_sea_combo3_onitemchanged" anchor="default"/>
- <Static id="caption8" text="정산자 :" class="search_name" position="absolute 910 7 985 24" anchor="default"/>
- <Static id="caption9" text="분기 수령금액 :" class="search_name" position="absolute 16 30 133 47" anchor="default"/>
- <Static id="caption10" text="년 수령금액 :" class="search_name" position="absolute 16 54 151 71" anchor="default"/>
- <MaskEdit id="input2" taborder="7" mask="(-)#,###" enable="false" position="absolute 135 29 295 48" autoselect="true" autoskip="true" anchor="default"/>
- <MaskEdit id="input3" taborder="8" mask="(-)#,###" enable="false" position="absolute 135 53 295 72" autoselect="true" autoskip="true" anchor="default"/>
- <Static id="caption11" text="정산금액 :" class="search_name" position="absolute 325 54 460 71" anchor="default"/>
- <MaskEdit id="input4" taborder="9" mask="(-)#,###" enable="false" position="absolute 415 30 575 49" autoselect="true" autoskip="true" anchor="default"/>
- <MaskEdit id="input5" taborder="10" mask="(-)#,###" enable="false" position="absolute 415 54 575 73" autoselect="true" autoskip="true" anchor="default"/>
- <Static id="caption12" text="정산금액 :" class="search_name" position="absolute 325 30 442 47" anchor="default"/>
- <Static id="caption13" text="차액 :" class="search_name" position="absolute 600 56 735 73" anchor="default"/>
- <Static id="caption14" text="차액 :" class="search_name" position="absolute 600 30 717 47" anchor="default"/>
- <MaskEdit id="input6" taborder="11" mask="(-)#,###" enable="false" position="absolute 670 30 830 49" autoselect="true" autoskip="true" anchor="default"/>
- <MaskEdit id="input7" taborder="12" mask="(-)#,###" enable="false" position="absolute 670 54 830 73" autoselect="true" autoskip="true" anchor="default"/>
- <Static id="caption15" text="최종저장 :" class="search_name" position="absolute 895 30 990 47" anchor="default"/>
- <CheckBox id="bool1" taborder="13" position="absolute 985 28 1010 48" truevalue="Y" falsevalue="N" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- <Shape id="line1" class="line_10" position="absolute -1 180 1194 186" anchor="left top right"/>
- <Button id="button1" taborder="4" text="행추가" class="btn2" position="absolute 1088 160 1141 179" onclick="button1_onclick" anchor="top right"/>
- <Button id="button2" taborder="5" text="행삭제" class="btn2" position="absolute 1142 160 1195 179" onclick="button2_onclick" anchor="top right"/>
- <Static id="caption1" text="정산비등록" class="tit_2" position="absolute 0 164 121 186"/>
- <Grid id="grd_acntinoutlist" taborder="6" binddataset="ds_main_datalist_jungsan" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 185 1194 775" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="20"/>
- <Column size="38"/>
- <Column size="37"/>
- <Column size="108"/>
- <Column size="75"/>
- <Column size="40"/>
- <Column size="164"/>
- <Column size="361"/>
- <Column size="126"/>
- <Column size="205"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="NO"/>
- <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="금액"/>
- <Cell col="9" text="증빙유형"/>
- <Cell col="10" text="caption1"/>
- <Cell col="11" text="caption2"/>
- <Cell col="12" text="caption3"/>
- <Cell col="13" text="caption4"/>
- <Cell col="14" text="caption5"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" text="bind:seq2"/>
- <Cell col="2" text="bind:seq"/>
- <Cell col="3" displaytype="date" edittype="date" text="bind:baldate" calendardisplaynulltype="nulltext"/>
- <Cell col="4" displaytype="text" edittype="text" style="align:center middle;" text="bind:baltime" mask="##:##" maskchar=" "/>
- <Cell col="5" text="bind:day"/>
- <Cell col="6" displaytype="combo" edittype="combo" text="bind:youngdo" combodataset="ds_cmb_youngdo" combocodecol="value" combodatacol="label"/>
- <Cell col="7" displaytype="text" edittype="text" text="bind:kdesc"/>
- <Cell col="8" displaytype="number" edittype="normal" text="bind:amt"/>
- <Cell col="9" displaytype="combo" edittype="combo" text="bind:jeungbing" combodataset="ds_cmb_jeungbing" combocodecol="value" combodatacol="label"/>
- <Cell col="10" text="bind:year"/>
- <Cell col="11" text="bind:bungi"/>
- <Cell col="12" text="bind:buseocode"/>
- <Cell col="13" text="bind:sabun"/>
- <Cell col="14" text="bind:gubun"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Static id="caption16" text="* 주의사항 : 정산비 등록할 때 순번이 동일한 것이 있으면 에러가 발생하므로 같은 순번이 없도록 수정하여 저장해 주시기 바랍니다." visible="false" position="absolute 88 163 800 178"/>
- <Button id="btn_excelinput" taborder="7" text="엑셀입력" class="btn7" position="absolute 1007 160 1087 179" visible="false" onclick="btn_excelinput_onclick" anchor="top right"/>
- <Button id="btn_excelsave" taborder="8" text="엑셀샘플" class="btn7" position="absolute 926 160 1006 179" visible="false" onclick="btn_excelsave_onclick" anchor="top right"/>
- <Grid id="datagrid1" taborder="9" binddataset="ds_sampledata" useinputpanel="false" visible="false" position="absolute 370 290 860 380" autoenter="select" cellsizingtype="col">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="23"/>
- <Column size="38"/>
- <Column size="37"/>
- <Column size="121"/>
- <Column size="71"/>
- <Column size="113"/>
- <Column size="217"/>
- <Column size="361"/>
- <Column size="150"/>
- <Column size="205"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="NO"/>
- <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="금액"/>
- <Cell col="9" text="증빙유형"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" text="bind:seq2"/>
- <Cell col="2" text="bind:seq"/>
- <Cell col="3" text="bind:baldate"/>
- <Cell col="4" text="bind:baltime"/>
- <Cell col="5" text="bind:day"/>
- <Cell col="6" displaytype="combo" edittype="combo" text="bind:youngdo"/>
- <Cell col="7" displaytype="text" edittype="text" text="bind:kdesc"/>
- <Cell col="8" displaytype="number" edittype="normal" text="bind:amt"/>
- <Cell col="9" displaytype="combo" edittype="combo" text="bind:jeungbing"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="btn_dedu" taborder="10" text="직원인건비내역등록" class="btn2" position="absolute 798 160 925 179" onclick="btn_dedu_onclick" visible="false" anchor="top right"/>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_send_retrparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_retrparam_oncolumnchanged">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="yyyy" type="STRING" size="256"/>
- <Column id="quarter" type="STRING" size="256"/>
- <Column id="gubun" type="STRING" size="256"/>
- <Column id="buseocode" type="STRING" size="256"/>
- <Column id="sabun" type="STRING" size="256"/>
- <Column id="depthngnm" type="STRING" size="256"/>
- <Column id="oksign" type="STRING" size="256"/>
- <Column id="userid" type="STRING" size="256"/>
- <Column id="poweryn" type="STRING" size="256"/>
- <Column id="sanyn" type="STRING" size="256"/>
- <Column id="srchsabun" type="STRING" size="256"/>
- <Column id="buseoname" type="STRING" size="256"/>
- <Column id="opener" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="yyyy"/>
- <Col id="quarter"/>
- <Col id="gubun"/>
- <Col id="buseocode"/>
- <Col id="sabun"/>
- <Col id="depthngnm"/>
- <Col id="oksign"/>
- <Col id="userid"/>
- <Col id="poweryn"/>
- <Col id="sanyn"/>
- <Col id="srchsabun"/>
- <Col id="buseoname"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_datalist_amtinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="quartertotalamt" type="STRING" size="256"/>
- <Column id="quarterjungsanamt" type="STRING" size="256"/>
- <Column id="quartermergeamt" type="STRING" size="256"/>
- <Column id="totalamt" type="STRING" size="256"/>
- <Column id="jungsanamt" type="STRING" size="256"/>
- <Column id="mergeamt" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="quartertotalamt"/>
- <Col id="quarterjungsanamt"/>
- <Col id="quartermergeamt"/>
- <Col id="totalamt"/>
- <Col id="jungsanamt"/>
- <Col id="mergeamt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_datalist_managerinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="m" type="STRING" size="256"/>
- <Column id="year" type="STRING" size="256"/>
- <Column id="bungi" type="STRING" size="256"/>
- <Column id="seqno" type="STRING" size="256"/>
- <Column id="gubun" type="STRING" size="256"/>
- <Column id="buseocode" type="STRING" size="256"/>
- <Column id="sabun" type="STRING" size="256"/>
- <Column id="oksign" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="m"/>
- <Col id="year"/>
- <Col id="bungi"/>
- <Col id="seqno"/>
- <Col id="gubun"/>
- <Col id="buseocode"/>
- <Col id="sabun"/>
- <Col id="oksign"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_datalist_jungsan" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_datalist_jungsan_oncolumnchanged">
- <ColumnInfo>
- <Column id="seq" type="STRING" size="256" sumtext="순번"/>
- <Column id="seq2" type="STRING" size="256" sumtext="순번"/>
- <Column id="baldate" type="STRING" size="256" sumtext="발생일자"/>
- <Column id="baltime" type="STRING" size="256" sumtext="발생시각"/>
- <Column id="youngdo" type="STRING" size="256" sumtext="용도"/>
- <Column id="kdesc" type="STRING" size="256" sumtext="지출내역"/>
- <Column id="amt" type="STRING" size="256" sumtext="금액"/>
- <Column id="jeungbing" type="STRING" size="256" sumtext="증빙유형"/>
- <Column id="year" type="STRING" size="256" sumtext="년도"/>
- <Column id="bungi" type="STRING" size="256" sumtext="분기"/>
- <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
- <Column id="sabun" type="STRING" size="256" sumtext="사번"/>
- <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
- <Column id="day" type="STRING" size="256" sumtext="요일"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_sampledata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="baldate" type="STRING" size="256"/>
- <Column id="baltime" type="STRING" size="256"/>
- <Column id="day" type="STRING" size="256"/>
- <Column id="kdesc" type="STRING" size="256"/>
- <Column id="youngdo" type="STRING" size="256"/>
- <Column id="jeungbing" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_init_deptinfo_deptlist" 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_emplnoinfo_emplnolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="emplnm" type="STRING" size="256"/>
- <Column id="emplno" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_cmb_youngdo" 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">1.인건비</Col>
- <Col id="value">1</Col>
- </Row>
- <Row>
- <Col id="label">2.초빙강사료</Col>
- <Col id="value">2</Col>
- </Row>
- <Row>
- <Col id="label">3.회의및행사비</Col>
- <Col id="value">3</Col>
- </Row>
- <Row>
- <Col id="label">4.학회참가경비</Col>
- <Col id="value">4</Col>
- </Row>
- <Row>
- <Col id="label">5.도서인쇄비</Col>
- <Col id="value">5</Col>
- </Row>
- <Row>
- <Col id="label">6.소모품비</Col>
- <Col id="value">6</Col>
- </Row>
- <Row>
- <Col id="label">7.경조사비</Col>
- <Col id="value">7</Col>
- </Row>
- <Row>
- <Col id="label">8.우편통신비</Col>
- <Col id="value">8</Col>
- </Row>
- <Row>
- <Col id="label">9.자산구입비</Col>
- <Col id="value">9</Col>
- </Row>
- <Row>
- <Col id="label">X.기타</Col>
- <Col id="value">X</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_cmb_jeungbing" 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">1.세금계산서</Col>
- <Col id="value">1</Col>
- </Row>
- <Row>
- <Col id="label">2.계산서</Col>
- <Col id="value">2</Col>
- </Row>
- <Row>
- <Col id="label">3.인건비영수증</Col>
- <Col id="value">3</Col>
- </Row>
- <Row>
- <Col id="label">4.자산등록요청서</Col>
- <Col id="value">4</Col>
- </Row>
- <Row>
- <Col id="label">5.부서법인카드</Col>
- <Col id="value">5</Col>
- </Row>
- <Row>
- <Col id="label">6.현금영수증</Col>
- <Col id="value">6</Col>
- </Row>
- <Row>
- <Col id="label">7.원천징수영수증</Col>
- <Col id="value">7</Col>
- </Row>
- <Row>
- <Col id="label">X.기타</Col>
- <Col id="value">X</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_temp_jungsanjayn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="sanyn" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_sanynlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="sanyn" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_powerlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="poweryn" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_temp_powerinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="poweryn" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_main2_managerinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_datalist_prntinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_datalist_textinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="grp_sea.input1" propid="value" datasetid="ds_send_retrparam" columnid="yyyy"/>
- <BindItem id="item1" compid="grp_sea.cmb_dateflag" propid="value" datasetid="ds_send_retrparam" columnid="quarter"/>
- <BindItem id="item2" compid="grp_sea.combo1" propid="value" datasetid="ds_send_retrparam" columnid="gubun"/>
- <BindItem id="item3" compid="grp_sea.combo2" propid="value" datasetid="ds_send_retrparam" columnid="buseocode"/>
- <BindItem id="item4" compid="grp_sea.combo3" propid="value" datasetid="ds_send_retrparam" columnid="sabun"/>
- <BindItem id="item5" compid="grp_sea.input2" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="quartertotalamt"/>
- <BindItem id="item6" compid="grp_sea.input4" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="quarterjungsanamt"/>
- <BindItem id="item7" compid="grp_sea.input6" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="quartermergeamt"/>
- <BindItem id="item8" compid="grp_sea.bool1" propid="value" datasetid="ds_main_datalist_managerinfo" columnid="oksign"/>
- <BindItem id="item9" compid="grp_sea.input3" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="totalamt"/>
- <BindItem id="item10" compid="grp_sea.input5" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="jungsanamt"/>
- <BindItem id="item11" compid="grp_sea.input7" propid="value" datasetid="ds_main_datalist_amtinfo" columnid="mergeamt"/>
- </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";
- function SMRAH01300_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SMRAH01300_onload(obj:Form, e:LoadEventInfo)
- {
- grdf_initGrid(grd_acntinoutlist);
- grdf_setRowTypeIcon(grd_acntinoutlist, 0);
-
- grdf_initGrid(datagrid1);
- grdf_setRowTypeIcon(datagrid1, 0);
-
- fResetForm();
- }
- function fResetForm()
- {
- frmf_modal("SMRAH01800", "SMRAH01800", "", "", "", "", "", "", "", "", "", "", "M");
- ds_send_retrparam.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
- ds_send_retrparam.setColumn(0, "quarter", "1");
- ds_send_retrparam.setColumn(0, "yyyy", String(utlf_getCurrentDate()).substr(0,4));
-
- var oParam = {};
- oParam.id = "TRRAH01203";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqGetEmplnoList";
- oParam.inds = "req=ds_send_retrparam";
- oParam.outds = "ds_init_emplnoinfo_emplnolist=emplnolist";
- oParam.async = false;
- //oParam.callback = "cf_TRRAH01203";
- tranf_submit(oParam);
-
- var Emplno = sysf_getUserInfo("userid");
- var Deptcd = sysf_getUserInfo("dutplcecd");
- ds_send_retrparam.setColumn(0, "userid", Emplno);
- ds_send_retrparam.setColumn(0, "sabun", Emplno);
- ds_send_retrparam.setColumn(0, "buseocode", Deptcd);
- ds_send_retrparam.setColumn(0, "gubun", "1");
-
- var oParam = {};
- oParam.id = "TRRAH01302";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqGetSanjaynList";
- oParam.inds = "req=ds_send_retrparam";
- oParam.outds = "ds_temp_jungsanjayn=jungsanjayn";
- oParam.async = false;
- //oParam.callback = "cf_TRRAH01302";
- tranf_submit(oParam);
- ds_sanynlist.setColumn(0, "sanyn", ds_temp_jungsanjayn.getColumn(0, "sanyn"));
- ds_send_retrparam.setColumn(0, "sanyn", ds_temp_jungsanjayn.getColumn(0, "sanyn"));
-
- var oParam = {};
- oParam.id = "TRRAH01303";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqGetSanjadeptList";
- oParam.inds = "req=ds_send_retrparam";
- oParam.outds = "ds_init_deptinfo_deptlist=deptlist";
- oParam.async = false;
- //oParam.callback = "cf_TRRAH01303";
- tranf_submit(oParam);
- ds_powerlist.setColumn(0, "poweryn", ds_temp_powerinfo.getColumn(0, "poweryn"));
- ds_send_retrparam.setColumn(0, "poweryn", ds_temp_powerinfo.getColumn(0, "poweryn"));
-
- var poweryn = ds_powerlist.getColumn(0, "poweryn");
- var oksign = ds_main_datalist_managerinfo.getColumn(0, "oksign");
-
- var sanyn = ds_sanynlist.getColumn(0, "sanyn");
-
- if(sanyn == "Y")
- {
- ds_powerlist.setColumn(0, "poweryn", "Y");
- ds_send_retrparam.setColumn(0, "poweryn", "Y");
- }
- if(oksign != "Y")
- {
- if(poweryn == "Y")
- {
- grp_sea.bool1.enable = true;
- grp_sea.combo1.enable = true;
- ds_send_retrparam.setColumn(0, "gubun", "1");
- }
- else if (sanyn == "Y")
- {
- grp_sea.bool1.enable = true;
- grp_sea.combo1.enable = true;
- ds_send_retrparam.setColumn(0, "gubun", "2");
- }
- else
- {
- grp_sea.bool1.enable = false;
- ds_send_retrparam.setColumn(0, "gubun", "2");
- }
- }
- else
- {
- grp_sea.bool1.enable = false;
- //model.getValue("/root/main/datalist/jungsan").disabled = true;
- }
- fRetrieve();
- frmf_inputEnterKey("grp_sea.combo1", "onitemchanged", new ItemChangeEventInfo );
- }
- function fRetrieve()
- {
- ds_main_datalist_amtinfo.clearData();
- ds_main_datalist_jungsan.clearData();
- ds_main_datalist_managerinfo.clearData();
-
- var oParam = {};
- oParam.id = "TRRAH01301";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqGetJungSanList";
- oParam.inds = "req=ds_send_retrparam";
- oParam.outds = "ds_main_datalist_jungsan=jungsan ds_main_datalist_amtinfo=amtinfo ds_main_datalist_managerinfo=managerinfo ds_main_datalist_prntinfo=prntinfo ds_main_datalist_textinfo=textinfo";
- oParam.async = false;
- //oParam.callback = "cf_TRRAH01301";
- tranf_submit(oParam);
- ds_main2_managerinfo.copyData(ds_main_datalist_managerinfo);
-
- var oksign = ds_main_datalist_managerinfo.getColumn(0, "oksign");
-
- if(oksign == "Y")
- {
- grp_sea.bool1.enable = false;
- button1.enable = false;
- button2.enable = false;
- btn_save.enable = false;
-
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "baldate"), "edittype", "none");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "youngdo"), "edittype", "none");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "kdesc"), "edittype", "none");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "amt"), "edittype", "none");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "jeungbing"), "edittype", "none");
- }
- else
- {
- grp_sea.bool1.enable = true;
- button1.enable = true;
- button2.enable = true;
- btn_save.enable = true;
-
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "baldate"), "edittype", "date");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "youngdo"), "edittype", "combo");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "kdesc"), "edittype", "text");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "amt"), "edittype", "normal");
- grd_acntinoutlist.setCellProperty("Body", grd_acntinoutlist.getBindCellIndex("Body", "jeungbing"), "edittype", "combo");
- }
- }
- function grp_sea_input1_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- grp_sea.cmb_dateflag.setFocus();
- }
- }
- function ds_send_retrparam_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "yyyy")
- {
- //frmf_inputEnterKey("grp_sea.combo1", "onitemchanged", new ItemChangeEventInfo );
-
- //grp_sea.btn_search.click();
- }
- }
- function grp_sea_cmb_dateflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- frmf_inputEnterKey("grp_sea.combo1", "onitemchanged", new ItemChangeEventInfo );
- grp_sea.combo1.setFocus();
- grp_sea.btn_search.click();
- }
- function grp_sea_combo1_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- misfGridInit(grd_acntinoutlist);
-
- var oParam = {};
- oParam.id = "TRRAH01302";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqGetSanjaynList";
- oParam.inds = "req=ds_send_retrparam";
- oParam.outds = "ds_temp_jungsanjayn=jungsanjayn";
- oParam.async = false;
- //oParam.callback = "cf_TRRAH01302";
- tranf_submit(oParam);
-
- var poweryn = ds_powerlist.getColumn(0, "poweryn");
- var oksign = ds_main_datalist_managerinfo.getColumn(0, "oksign");
- var sanyn = ds_temp_jungsanjayn.getColumn(0, "sanyn");
- if(oksign != "Y")
- {
- if(poweryn == "Y")
- {
- grp_sea.bool1.enable = true;
-
- if(ds_send_retrparam.getColumn(0, "gubun") == "1")
- {
- ds_send_retrparam.setColumn(0, "sabun", "00000");
- }
- else
- {
- ds_send_retrparam.setColumn(0, "sabun", sysf_getUserInfo("userid"));
- }
- }
- else if (sanyn == "Y")
- {
- grp_sea.bool1.enable = true;
-
- if(ds_send_retrparam.getColumn(0, "gubun") == "1")
- {
- ds_send_retrparam.setColumn(0, "sabun", "00000");
- }
- else
- {
- ds_send_retrparam.setColumn(0, "sabun", sysf_getUserInfo("userid"));
- }
- }
- else
- {
- grp_sea.bool1.enable = false;
- ds_send_retrparam.setColumn(0, "sabun", sysf_getUserInfo("userid"));
- }
- }
- else
- {
- grp_sea.bool1.enable = false;
-
- //model.getValue("/root/main/datalist/jungsan").disabled = true;
-
- if(poweryn == "Y" || sanyn == "Y")
- {
- if(ds_send_retrparam.getColumn(0, "gubun") == "1")
- {
- ds_send_retrparam.setColumn(0, "sabun", "00000");
- }
- else
- {
- ds_send_retrparam.setColumn(0, "sabun", sysf_getUserInfo("userid"));
- }
- }
- else
- {
- ds_send_retrparam.setColumn(0, "sabun", sysf_getUserInfo("userid"));
- }
- }
- ds_send_retrparam.setColumn(0, "srchsabun", sysf_getUserInfo("userid"));
-
- var oParam = {};
- oParam.id = "TRRAH01303";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqGetSanjadeptList";
- oParam.inds = "req=ds_send_retrparam";
- oParam.outds = "ds_init_deptinfo_deptlist=deptlist";
- oParam.async = false;
- //oParam.callback = "cf_TRRAH01303";
- tranf_submit(oParam);
-
- grp_sea.combo2.setFocus();
-
- grp_sea.btn_search.click();
- }
- function grp_sea_combo2_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- grp_sea.btn_search.click();
- grp_sea.combo3.setFocus();
- }
- function grp_sea_combo3_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- misfGridInit(grd_acntinoutlist);
- grp_sea.btn_search.click();
- }
- function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- fRetrieve();
- }
- function ds_main_datalist_jungsan_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "baldate")
- {
- var sDate = obj.getColumn(e.row, "baldate");
-
- if (String(sDate).length < 8)
- {
- obj.setColumn(e.row, "day", "");
- }
- else
- {
- obj.setColumn(e.row, "day", getDateTime(sDate.toDate(), "W"));
- }
- }
- }
- function btn_dedu_onclick(obj:Button, e:ClickEventInfo)
- {
- if (grp_sea.combo1.value != "1")
- {
- sysf_messageBox("부서경비의 경우에만 직원인건비 내역 등록이 가능합니다. ", "E000");
- return;
- }
- if (utlf_isNull(grp_sea.combo2.text))
- {
- sysf_messageBox("정산부서가 선택되지 않았습니다. ", "E000");
- return;
- }
-
- dsf_makeValue(ds_send_retrparam, "buseoname", "string", grp_sea.combo2.text, 0);
- dsf_makeValue(ds_send_retrparam, "opener", "string", "SMRAH01300", 0);
-
- frmf_modal("SMRAH02600", "SMRAH02600", "", "", "", "", "", "", "", "", "", "", "M");
- }
- function btn_excelsave_onclick(obj:Button, e:ClickEventInfo)
- {
- misfGridInit(datagrid1);
-
- var addRow = ds_sampledata.addRow();
-
- ds_sampledata.setColumn(addRow, "baldate", "20170301");
- ds_sampledata.setColumn(addRow, "baltime", "1630");
- ds_sampledata.setColumn(addRow, "day", "입력 불필요");
- ds_sampledata.setColumn(addRow, "kdesc", "NO,순번은 순서대로 입력해 주세오.예)1,2,3");
- ds_sampledata.setColumn(addRow, "youngdo", "코드로 입력");
- ds_sampledata.setColumn(addRow, "jeungbing", "코드로 입력");
-
- grdf_exportExcel(datagrid1, "정산비등록_Sample", "정산비등록_Sample", false, "", "user", false);
- }
- function btn_excelinput_onclick(obj:Button, e:ClickEventInfo)
- {
- if(utlf_isNull(ds_main_datalist_amtinfo.getColumn(0, "quartertotalamt")))
- {
- sysf_messageBox("분기 수령금액이 존재하지 않습니다. \n정산년도와 분기를 확인하십시요. ", "E999", "");
- grp_sea.cmb_dateflag.setFocus();
- return;
- }
- sysf_messageBox("엑셀입력을 하실 때 꼭 샘플양식에 맞게 입력해주세요.","I999", "");
-
- grdf_ImportExcel("ds_main_datalist_jungsan", 2, grd_acntinoutlist)
-
- ds_main_datalist_jungsan.updatecontrol = false;
- for(var i = 0; i < ds_main_datalist_jungsan.rowcount; i++)
- {
- ds_main_datalist_jungsan.setColumn(i, "gubun", "0");
-
- ds_main_datalist_jungsan.setRowType(i, "i");
-
- ds_main_datalist_jungsan.setColumn(i, "year", ds_send_retrparam.getColumn(0, "yyyy"));
- ds_main_datalist_jungsan.setColumn(i, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
- ds_main_datalist_jungsan.setColumn(i, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));
- ds_main_datalist_jungsan.setColumn(i, "sabun", ds_send_retrparam.getColumn(0, "sabun"));
- ds_main_datalist_jungsan.setColumn(i, "gubun", ds_send_retrparam.getColumn(0, "gubun"));
-
- var sDate = ds_main_datalist_jungsan.getColumn(i, "baldate");
-
- if (String(sDate).length < 8)
- {
- ds_main_datalist_jungsan.setColumn(i, "day", "");
- }
- else
- {
- ds_main_datalist_jungsan.setColumn(i, "day", getDateTime(sDate.toDate(), "W"));
- }
- }
- }
- function button1_onclick(obj:Button, e:ClickEventInfo)
- {
- if(utlf_isNull(ds_main_datalist_amtinfo.getColumn(0, "quartertotalamt")))
- {
- sysf_messageBox("분기 수령금액이 존재하지 않습니다. \n정산년도와 분기를 확인하십시요. ", "E999", "");
- grp_sea.cmb_dateflag.setFocus();
- return;
- }
-
- var addRow = ds_main_datalist_jungsan.addRow();
-
- ds_main_datalist_jungsan.setColumn(addRow, "baldate", utlf_getCurrentDate());
- ds_main_datalist_jungsan.setColumn(addRow, "baltime", "0000");
-
- ds_main_datalist_jungsan.setColumn(addRow, "year", ds_send_retrparam.getColumn(0, "yyyy"));
- ds_main_datalist_jungsan.setColumn(addRow, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
- ds_main_datalist_jungsan.setColumn(addRow, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));
- ds_main_datalist_jungsan.setColumn(addRow, "sabun", ds_send_retrparam.getColumn(0, "sabun"));
- ds_main_datalist_jungsan.setColumn(addRow, "gubun", ds_send_retrparam.getColumn(0, "gubun"));
-
- if(ds_main_datalist_jungsan.rowposition == 0)
- {
- ds_main_datalist_jungsan.setColumn(0, "seq", "1");
- ds_main_datalist_jungsan.setColumn(0, "seq2", "1");
- }
- else
- {
- ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "seq2", parseInt(ds_main_datalist_jungsan.getColumn(ds_main_datalist_jungsan.rowposition-1, "seq2"))+1);
-
- var ll_seq_max = 0;
- var ll_seq = 0;
-
- for(var i = 0; i < ds_main_datalist_jungsan.rowcount; i++)
- {
- ll_seq = parseInt(ds_main_datalist_jungsan.getColumn(i, "seq"));
-
- if (ll_seq > ll_seq_max)
- {
- ll_seq_max = ll_seq ;
- }
- }
- ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "seq", ll_seq_max + 1);
- }
- var sDate = ds_main_datalist_jungsan.getColumn(ds_main_datalist_jungsan.rowposition, "baldate");
-
- if (String(sDate).length < 8)
- {
- ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "day", "");
- }
- else
- {
- ds_main_datalist_jungsan.setColumn(ds_main_datalist_jungsan.rowposition, "day", getDateTime(sDate.toDate(), "W"));
- }
- }
- function button2_onclick(obj:Button, e:ClickEventInfo)
- {
- var status = ds_main_datalist_jungsan.getRowType(ds_main_datalist_jungsan.rowposition);
-
- if(status == 1)
- {
- ds_main_datalist_jungsan.updatecontrol = false;
- ds_main_datalist_jungsan.setRowType(ds_main_datalist_jungsan.rowposition, "d");
- ds_main_datalist_jungsan.updatecontrol = true;
- }
- else if(status == 2)
- {
- ds_main_datalist_jungsan.deleteRow(ds_main_datalist_jungsan.rowposition);
- }
- else if(status == 4)
- {
- ds_main_datalist_jungsan.updatecontrol = false;
- ds_main_datalist_jungsan.setRowType(ds_main_datalist_jungsan.rowposition, "d");
- ds_main_datalist_jungsan.updatecontrol = true;
- }
- else if(status == 8)
- {
- ds_main_datalist_jungsan.updatecontrol = false;
- ds_main_datalist_jungsan.setRowType(ds_main_datalist_jungsan.rowposition, "d");
- ds_main_datalist_jungsan.updatecontrol = true;
- }
- }
- function button3_onclick(obj:Button, e:ClickEventInfo)
- {
- dsf_makeValue(ds_send_retrparam, "deptnm", "string", grp_sea.combo2.text, 0);
- dsf_makeValue(ds_send_retrparam, "emplnm", "string", grp_sea.combo3.text, 0);
-
- var objDOM = rptf_createDOM();
- rptf_setNodeListToDOM(objDOM, "/root/main/datalist/jungsan", ds_main_datalist_jungsan);
- rptf_setNodeListToDOM(objDOM, "/root/main/datalist/prntinfo", ds_main_datalist_prntinfo);
- rptf_setNodeListToDOM(objDOM, "/root/main/datalist/textinfo", ds_main_datalist_textinfo);
- rptf_setNodeListToDOM(objDOM, "/root/send/retrparam", ds_send_retrparam);
- var objParam = new Object();
- objParam.xml_data_XML1 = objDOM.documentElement.source;
- var option = "";
- rptf_exeReportPreview30(["SMRAH01301"],[objParam], option);
- }
- function btn_save_onclick(obj:Button, e:ClickEventInfo)
- {
- var cnt = ds_main_datalist_jungsan.rowcount;
-
- for( var i = 0 ; i < cnt ; i++)
- {
- if(utlf_isNull(ds_main_datalist_jungsan.getColumn(i, "youngdo")))
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 계정구분값이 누락되었습니다. \n계정구분값은 필수 입력값입니다. ", "E000");
- return;
- }
-
- if(utlf_isNull(ds_main_datalist_jungsan.getColumn(i, "jeungbing")))
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 증빙유형값이 누락되었습니다. \n증빙유형값은 필수 입력값입니다. ", "E000");
- return;
- }
- }
-
- fSaveData();
- }
- function fSaveData()
- {
- var updtdata = grdf_getGridUpdateData(grd_acntinoutlist).rowcount;
- var copydata = ds_main2_managerinfo.getColumn(0, "oksign");
- var data = ds_main_datalist_managerinfo.getColumn(0, "oksign");
-
- if (updtdata == 0 && data == copydata)
- {
- sysf_messageBox("변경된 데이터가","I004");
- return;
- }
-
- for(var i = 0; i < ds_main_datalist_jungsan.rowcount; i++)
- {
- if(ds_main_datalist_jungsan.getRowType(i) == 8)
- {
- return;
- }
-
- var baldate = String(ds_main_datalist_jungsan.getColumn(i, "baldate")).substr(4,2);
- var balyear = String(ds_main_datalist_jungsan.getColumn(i, "baldate")).substr(0,4);
- var yyyy = ds_send_retrparam.getColumn(0, "yyyy");
-
- var quarter = grp_sea.cmb_dateflag.value;
-
- if(yyyy != balyear)
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 발생년도가 적합하지 않습니다.", "I000");
- return;
- }
- if(quarter == "1")
- {
- if(baldate < "01" || baldate > "03")
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 발생일자가 1분기에 적합하지 않습니다.", "I000");
- return;
- }
- }
- else if(quarter == "2")
- {
- if(baldate < "04" || baldate > "06")
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 발생일자가 2분기에 적합하지 않습니다.", "I000");
- return;
- }
- }
- else if(quarter == "3")
- {
- if(baldate < "07" || baldate > "09")
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 발생일자가 3분기에 적합하지 않습니다.", "I000");
- return;
- }
- }
- else if(quarter == "4")
- {
- if(baldate < "10" || baldate > "12")
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 발생일자가 4분기에 적합하지 않습니다.", "I000");
- return;
- }
- }
- var baltime= ds_main_datalist_jungsan.getColumn(i, "baltime");
- if(String(baltime).length != 4)
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 발생시각이 적합하지 않습니다.", "I000");
- return;
- }
-
- var amt = ds_main_datalist_jungsan.getColumn(i, "amt");
- if( utlf_isNull(amt))
- {
- sysf_messageBox("[ " + i+1 + " ]번째 행의 금액이 누락되었습니다. \n금액은 필수 입력값입니다. ", "E000");
- return;
- }
-
- }
- if( sysf_messageBox("정산 내역을", "Q002") != 6 )
- {
- return ;
- }
-
- var seq_no = ds_main_datalist_managerinfo.getColumn(0, "seqno");
-
- if(utlf_isNull(seq_no))
- {
- ds_main_datalist_managerinfo.setColumn(0, "seqno", "1");
- }
- ds_main_datalist_managerinfo.setColumn(0, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
-
- var oParam = {};
- oParam.id = "TXRAH01301";
- oParam.service = "acntknuhapp.Acntknuh";
- oParam.method = "reqExeSaveJungSanList";
- oParam.inds = "req=ds_main_datalist_jungsan:u req2=ds_main_datalist_managerinfo:u";
- oParam.outds = "ds_=seqno";
- oParam.typeStr = "m";
- oParam.async = false;
- //oParam.callback = "cf_TXRAH01301";
- tranf_submit(oParam);
- fRetrieve();
- }
- function fSave()
- {
- // var tPath = "/root/hidden/savelist/managerinfo";
- // var vData = "";
- // var vHeader = "m" + "▦" // 01. 상태
- // + "year" + "▦" // 02. 년도
- // + "bungi" + "▦" // 03. 분기
- // + "seqno" + "▦" // 04. 순번
- // + "gubun" + "▦" // 05. 구분
- // + "buseocode" + "▦" // 06. 부서코드
- // + "sabun" + "▦" // 07. 사번
- // + "oksign" + "▩" // 08. 승인여부
- //
- // vData += model.getValue("/root/main/datalist/managerinfo/m") + "▦" // 01. 상태
- // + model.getValue("/root/main/datalist/managerinfo/year") + "▦" // 02. 년도
- // + model.getValue("/root/send/retrparam/quarter") + "▦" // 03. 분기
- // + model.getValue("/root/main/datalist/managerinfo/seqno") + "▦" // 04. 순번
- // + model.getValue("/root/main/datalist/managerinfo/gubun") + "▦" // 05. 구분
- // + model.getValue("/root/main/datalist/managerinfo/buseocode") + "▦" // 06. 부서코드
- // + model.getValue("/root/main/datalist/managerinfo/sabun") + "▦" // 07. 사번
- // + model.getValue("/root/main/datalist/managerinfo/oksign") + "▦" // 08. 승인여부
- //
- // model.setValue(tPath ,vHeader+vData);
- }]]></Script>
- </Form>
- </FDL>
|