12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMRAT01600" position="absolute 0 0 1204 781" titletext="근로소득 조회/수정" oninit="SMRAT01600_oninit" onload="SMRAT01600_onload">
- <Layouts>
- <Layout>
- <Static id="caption6" text="근로소득 조회/수정" class="tit_1" position="absolute 0 0 293 23"/>
- <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1138 22 1194 44" anchor="top right" onclick="btn_save_onclick"/>
- <Button id="btn_close" taborder="2" text="닫기" class="btn4" visible="false" position="absolute 1080 22 1136 44" anchor="top right" onclick="btn_close_onclick"/>
- <Button id="btn_print" taborder="3" text="출력" class="btn4" visible="false" position="absolute 1021 22 1077 44" anchor="top right" onclick="btn_print_onclick"/>
- <Shape id="line1" class="line_6" position="absolute 0 43 1194 49" anchor="left top right"/>
- <Div id="grp_sea" taborder="4" class="div_SA" position="absolute 0 47 1195 107" anchor="left top right">
- <Layouts>
- <Layout>
- <Shape id="line5" linetype="vertical" class="line_4" position="absolute 1044 6 1050 54"/>
- <Static id="caption1" text="조회구분 :" class="search_name" position="absolute 315 9 405 26"/>
- <Calendar id="ipt_frym" taborder="7" class="input_s_essential" position="absolute 515 8 615 27" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
- <Static id="caption2" text="~" position="absolute 617 10 632 30"/>
- <Combo id="cmb_instcd" taborder="8" class="combo_s_essential" position="absolute 119 8 295 27" onitemchanged="grp_sea_cmb_instcd_onitemchanged"/>
- <Static id="caption3" text="기관구분 :" class="search_name" position="absolute 29 9 119 26"/>
- <Static id="caption5" text="내/외국인구분 :" class="search_name" position="absolute 755 9 879 26"/>
- <Button id="btn_search" taborder="9" text="조회" class="btn1" position="absolute 1063 19 1119 41" onclick="grp_sea_btn_search_onclick"/>
- <Calendar id="ipt_toym" taborder="10" class="input_s_essential" position="absolute 630 8 730 27" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
- <Static id="caption8" text="소 득 자 :" class="search_name" position="absolute 315 35 403 52"/>
- <Button id="btn_entregnohelp" taborder="11" class="icon_search" position="absolute 509 35 525 51" onclick="grp_sea_btn_entregnohelp_onclick"/>
- <Edit id="ipt_rrgstno" taborder="12" class="input_search" position="absolute 405 34 505 53" onkeydown="grp_sea_ipt_rrgstno_onkeydown"/>
- <Edit id="ipt_name" taborder="13" class="input_search" position="absolute 529 34 655 53" onkeydown="grp_sea_ipt_name_onkeydown"/>
- <Static id="caption20" text="거주자 구분 :" class="search_name" position="absolute 755 34 860 51"/>
- <Combo id="cmb_day" taborder="16" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_s_essential" position="absolute 405 8 505 27" onitemchanged="grp_sea_cmb_day_onitemchanged">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">P</Col>
- <Col id="datacolumn">지급일자</Col>
- </Row>
- <Row>
- <Col id="codecolumn">G</Col>
- <Col id="datacolumn">귀속년월</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Combo id="cmb_day00" taborder="17" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_s_essential" position="absolute 877 7 977 26">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn" size="256"/>
- <Column id="datacolumn" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn"/>
- <Col id="datacolumn">전체</Col>
- </Row>
- <Row>
- <Col id="codecolumn">1</Col>
- <Col id="datacolumn">내국인</Col>
- </Row>
- <Row>
- <Col id="codecolumn">9</Col>
- <Col id="datacolumn">외국인</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Combo id="cmb_day01" taborder="18" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_s_essential" position="absolute 877 32 977 51">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn" size="256"/>
- <Column id="datacolumn" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn"/>
- <Col id="datacolumn">전체</Col>
- </Row>
- <Row>
- <Col id="codecolumn">P1</Col>
- <Col id="datacolumn">거주자</Col>
- </Row>
- <Row>
- <Col id="codecolumn">2</Col>
- <Col id="datacolumn">비거주자</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- </Layout>
- </Layouts>
- </Div>
- <Shape id="line3" class="line_10" position="absolute 0 129 1195 135" anchor="left top right"/>
- <Static id="caption21" text="소득자 목록" class="tit_2" position="absolute 0 113 96 134"/>
- <Edit id="output9" taborder="5" readonly="true" visible="false" position="absolute 70 152 95 172"/>
- <Static id="caption19" text="계" class="cell_1" position="absolute 540 158 627 179" style="align:center middle;" anchor="top right"/>
- <MaskEdit id="output8" taborder="6" readonly="true" mask="(-)#,###" position="absolute 630 160 717 179" anchor="top right"/>
- <Shape id="line11" linetype="vertical" class="line_3" position="absolute 626 135 632 179" anchor="top right"/>
- <Static id="caption18" text="급여" class="cell_1" position="absolute 630 135 717 158" style="align:center middle;" anchor="top right"/>
- <Shape id="line9" linetype="vertical" class="line_3" position="absolute 716 135 722 179" anchor="top right"/>
- <Shape id="line8" linetype="vertical" class="line_3" position="absolute 796 135 802 179" anchor="top right"/>
- <Shape id="line12" linetype="vertical" class="line_3" position="absolute 871 135 877 179" anchor="top right"/>
- <Shape id="line13" linetype="vertical" class="line_3" position="absolute 964 135 970 179" anchor="top right"/>
- <Shape id="line2" linetype="vertical" class="line_3" position="absolute 973 135 979 179" anchor="top right"/>
- <Shape id="line6" linetype="vertical" class="line_3" position="absolute 1055 135 1061 179"/>
- <Shape id="line10" linetype="vertical" class="line_3" position="absolute 1191 135 1197 179" anchor="top right"/>
- <MaskEdit id="output2" taborder="7" readonly="true" mask="(-)#,###" position="absolute 1062 160 1192 179" anchor="top right"/>
- <Static id="caption9" text="품의+사업주부담 합계" class="cell_1" position="absolute 1062 135 1192 158" anchor="top right"/>
- <Static id="caption7" text="기관합계" class="cell_1" position="absolute 977 135 1059 158" anchor="top right"/>
- <MaskEdit id="output1" taborder="8" readonly="true" mask="(-)#,###" position="absolute 977 160 1059 179" anchor="top right"/>
- <MaskEdit id="output5" taborder="9" readonly="true" mask="(-)#,###" position="absolute 875 160 965 179" anchor="top right"/>
- <Static id="caption15" text="본인부담합계" class="cell_1" position="absolute 875 135 965 158" style="align:center middle;" anchor="top right"/>
- <Static id="caption16" text="원천세" class="cell_1" position="absolute 800 135 872 158" style="align:center middle;" anchor="top right"/>
- <MaskEdit id="output6" taborder="10" readonly="true" mask="(-)#,###" position="absolute 800 160 872 179" anchor="top right"/>
- <MaskEdit id="output7" taborder="11" readonly="true" mask="(-)#,###" position="absolute 720 160 797 179" anchor="top right"/>
- <Static id="caption17" text="실지급액" class="cell_1" position="absolute 720 135 797 158" style="align:center middle;" anchor="top right"/>
- <Button id="btn_excelformat" taborder="12" text="엑셀양식" class="btn7" position="absolute 630 110 710 129" anchor="top right" onclick="btn_excelformat_onclick"/>
- <Edit id="opt_temp" taborder="13" readonly="true" visible="false" position="absolute 609 110 629 129" anchor="top right"/>
- <Button id="btn_excelupload" taborder="14" text="엑셀 upolad" class="btn7" position="absolute 711 110 813 129" anchor="top right" onclick="btn_excelupload_onclick"/>
- <Button id="button1" taborder="15" text="주민등록번호검사" class="btn2" position="absolute 814 110 930 129" anchor="top right" onclick="button1_onclick"/>
- <Button id="btn_openpsn" taborder="16" text="소득자등록" class="btn2" position="absolute 931 110 1006 129" anchor="top right" onclick="btn_openpsn_onclick"/>
- <Button id="btn_addrow" taborder="17" text="행추가" class="btn2" position="absolute 1007 110 1060 129" anchor="top right" onclick="btn_addrow_onclick"/>
- <Button id="btn_delrow" taborder="18" text="행삭제" class="btn2" position="absolute 1061 110 1114 129" anchor="top right" onclick="btn_delrow_onclick"/>
- <Button id="btn_excel" taborder="19" text="엑셀출력" class="btn7" position="absolute 1115 110 1195 129" anchor="top right" onclick="btn_excel_onclick"/>
- <Grid id="grd_etcproflist" taborder="20" binddataset="ds_main_list_etcproflist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 180 1195 773" anchor="all" selecttype="multirow" onexpanddown="grd_etcproflist_onexpanddown">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="24"/>
- <Column size="35"/>
- <Column size="111"/>
- <Column size="74"/>
- <Column size="100"/>
- <Column size="60"/>
- <Column size="90"/>
- <Column size="72"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="85"/>
- <Column size="0"/>
- <Column size="0"/>
- </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" 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" rowspan="3" text="지급일자" taborder="undefined"/>
- <Cell col="7" rowspan="3" text="귀속년월" taborder="undefined"/>
- <Cell col="8" rowspan="3" text="급여 (A)" taborder="undefined"/>
- <Cell col="9" rowspan="3" text="실지급액 (C=A-B)" taborder="undefined"/>
- <Cell col="10" colspan="3" text="원천세" taborder="undefined"/>
- <Cell col="13" colspan="4" text="본인부담금" taborder="undefined"/>
- <Cell col="17" rowspan="3" text="본인부담합 계(B)" taborder="undefined"/>
- <Cell col="18" colspan="5" text="기관부담금" taborder="undefined"/>
- <Cell col="23" rowspan="3" text="기관합계" taborder="undefined"/>
- <Cell col="24" rowspan="3" text="품의금액 지급총액(+) 4대보험사업주 부담금" taborder="undefined"/>
- <Cell col="25" text="instcd"/>
- <Cell col="26" text="seqno"/>
- <Cell row="1" col="10" rowspan="2" text="소득세" taborder="undefined"/>
- <Cell row="1" col="11" rowspan="2" text="주민세" taborder="undefined"/>
- <Cell row="1" col="12" rowspan="2" text="합계" taborder="undefined"/>
- <Cell row="1" col="13" rowspan="2" text="건강보험" taborder="undefined"/>
- <Cell row="1" col="14" rowspan="2" text="장기요양" taborder="undefined"/>
- <Cell row="1" col="15" rowspan="2" text="국민연금" taborder="undefined"/>
- <Cell row="1" col="16" rowspan="2" text="고용보험" taborder="undefined"/>
- <Cell row="1" col="18" rowspan="2" text="건강보험" taborder="undefined"/>
- <Cell row="1" col="19" rowspan="2" text="장기요양" taborder="undefined"/>
- <Cell row="1" col="20" rowspan="2" text="국민연금" taborder="undefined"/>
- <Cell row="1" col="21" rowspan="2" text="고용보험" taborder="undefined"/>
- <Cell row="1" col="22" rowspan="2" text="산재보험" taborder="undefined"/>
- <Cell row="1" col="25" text="instcd"/>
- <Cell row="1" col="26" text="seqno"/>
- <Cell row="2" col="25" text="instcd"/>
- <Cell row="2" col="26" text="seqno"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" displaytype="text" edittype="text" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:chknm" editautoselect="true" enable="false"/>
- <Cell col="2" displaytype="text" edittype="mask" style="align:center middle;background:BIND(BgColor);background2:BIND(BgColor);" text="bind:pumno" mask="########-########" maskchar=" " editautoselect="true"/>
- <Cell col="3" displaytype="text" edittype="text" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:name" editautoselect="true" expandshow="show"/>
- <Cell col="4" edittype="mask" style="align:center middle;background:BIND(BgColor);background2:BIND(BgColor);" text="bind:rrgstno" mask="######-#######" maskchar=" " editautoselect="true"/>
- <Cell col="5" displaytype="combo" edittype="combo" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:ionatiflag" editautoselect="true" enable="false"/>
- <Cell col="6" displaytype="date" edittype="date" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:paydd" editautoselect="true" calendardisplaynulltype="nulltext"/>
- <Cell col="7" displaytype="date" edittype="date" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:getdd" mask="expr:chkyn == 'Y' || !utlf_isNull(Popflag) ? '' : 'yyyy-MM'" editautoselect="true" calendardisplaynulltype="nulltext"/>
- <Cell col="8" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:payamt" editautoselect="true"/>
- <Cell col="9" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:realamt" editautoselect="true"/>
- <Cell col="10" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:incmtax" editautoselect="true" enable="false"/>
- <Cell col="11" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:resdntax" editautoselect="true" enable="false"/>
- <Cell col="12" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:taxsum" editautoselect="true"/>
- <Cell col="13" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:healthamt" editautoselect="true" enable="false"/>
- <Cell col="14" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:mtrtamt" editautoselect="true" enable="false"/>
- <Cell col="15" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:pensionamt" editautoselect="true" enable="false"/>
- <Cell col="16" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:empinsuamt" editautoselect="true" enable="false"/>
- <Cell col="17" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:psnsum" editautoselect="true"/>
- <Cell col="18" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:healthamt2" editautoselect="true" enable="false"/>
- <Cell col="19" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:mtrtamt2" editautoselect="true" enable="false"/>
- <Cell col="20" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:pensionamt2" editautoselect="true" enable="false"/>
- <Cell col="21" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:empinsuamt2" editautoselect="true" enable="false"/>
- <Cell col="22" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:indinsuamt2" editautoselect="true" enable="false"/>
- <Cell col="23" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:instsum" editautoselect="true"/>
- <Cell col="24" displaytype="number" edittype="normal" style="background:BIND(BgColor);background2:BIND(BgColor);" text="bind:puminstsum" editautoselect="true"/>
- <Cell col="25" text="bind:instcd"/>
- <Cell col="26" text="bind:seqno"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Grid id="grd_excelformat" taborder="21" binddataset="ds_format" useinputpanel="false" visible="false" position="absolute 60 457 1120 722">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="111"/>
- <Column size="100"/>
- <Column size="90"/>
- <Column size="72"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="70"/>
- <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="급여 (A)" taborder="undefined"/>
- <Cell col="5" colspan="2" text="원천세" taborder="undefined"/>
- <Cell col="7" colspan="4" text="본인부담금" taborder="undefined"/>
- <Cell col="11" colspan="5" text="기관부담금" taborder="undefined"/>
- <Cell row="1" col="5" rowspan="2" text="소득세" taborder="undefined"/>
- <Cell row="1" col="6" rowspan="2" text="주민세" taborder="undefined"/>
- <Cell row="1" col="7" rowspan="2" text="건강보험" taborder="undefined"/>
- <Cell row="1" col="8" rowspan="2" text="장기요양" taborder="undefined"/>
- <Cell row="1" col="9" rowspan="2" text="국민연금" taborder="undefined"/>
- <Cell row="1" col="10" rowspan="2" text="고용보험" taborder="undefined"/>
- <Cell row="1" col="11" rowspan="2" text="건강보험" taborder="undefined"/>
- <Cell row="1" col="12" rowspan="2" text="장기요양" taborder="undefined"/>
- <Cell row="1" col="13" rowspan="2" text="국민연금" taborder="undefined"/>
- <Cell row="1" col="14" rowspan="2" text="고용보험" taborder="undefined"/>
- <Cell row="1" col="15" rowspan="2" text="산재보험" taborder="undefined"/>
- </Band>
- <Band id="body">
- <Cell text="bind:pumno"/>
- <Cell col="1" text="bind:rrgstno"/>
- <Cell col="2" text="bind:paydd"/>
- <Cell col="3" text="bind:getdd"/>
- <Cell col="4" displaytype="number" text="bind:payamt"/>
- <Cell col="5" displaytype="number" text="bind:incmtax" enable="false"/>
- <Cell col="6" displaytype="number" text="bind:resdntax" enable="false"/>
- <Cell col="7" displaytype="number" text="bind:healthamt" enable="false"/>
- <Cell col="8" displaytype="number" text="bind:mtrtamt" enable="false"/>
- <Cell col="9" displaytype="number" text="bind:pensionamt" enable="false"/>
- <Cell col="10" displaytype="number" text="bind:empinsuamt" enable="false"/>
- <Cell col="11" displaytype="number" text="bind:healthamt2" enable="false"/>
- <Cell col="12" displaytype="number" text="bind:mtrtamt2" enable="false"/>
- <Cell col="13" displaytype="number" text="bind:pensionamt2" enable="false"/>
- <Cell col="14" displaytype="number" text="bind:empinsuamt2" enable="false"/>
- <Cell col="15" displaytype="number" text="bind:indinsuamt2" enable="false"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_send_retrparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_retrparams_oncolumnchanged">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="frdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="ionatiflag" type="STRING" size="256"/>
- <Column id="residentflag" type="STRING" size="256"/>
- <Column id="rrgstno" type="STRING" size="256"/>
- <Column id="name" type="STRING" size="256"/>
- <Column id="dayflag" type="STRING" size="256"/>
- <Column id="retrkind" type="STRING" size="256"/>
- <Column id="pumno" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="frdd"/>
- <Col id="todd"/>
- <Col id="ionatiflag"/>
- <Col id="residentflag"/>
- <Col id="rrgstno"/>
- <Col id="name"/>
- <Col id="dayflag"/>
- <Col id="retrkind">all</Col>
- <Col id="pumno"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send_printparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="payAmt" type="STRING" size="256"/>
- <Column id="realAmt" type="STRING" size="256"/>
- <Column id="taxSum" type="STRING" size="256"/>
- <Column id="psnSum" type="STRING" size="256"/>
- <Column id="instSum" type="STRING" size="256"/>
- <Column id="puminstSum" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="payAmt"/>
- <Col id="realAmt"/>
- <Col id="taxSum"/>
- <Col id="psnSum"/>
- <Col id="instSum"/>
- <Col id="puminstSum"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_list_etcproflist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_list_etcproflist_oncolumnchanged">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
- <Column id="seqno" type="STRING" size="256" sumtext="일련번호"/>
- <Column id="rrgstno" type="STRING" size="256" sumtext="주민등록번호"/>
- <Column id="chkyn" type="STRING" size="256" sumtext="확인여부"/>
- <Column id="chknm" type="STRING" size="256" sumtext="확인여부"/>
- <Column id="paydd" type="STRING" size="256" sumtext="지급일자"/>
- <Column id="getdd" type="STRING" size="256" sumtext="귀속년월"/>
- <Column id="pumno" type="STRING" size="256" sumtext="품의번호"/>
- <Column id="payamt" type="STRING" size="256" sumtext="필요경비"/>
- <Column id="incmtax" type="STRING" size="256" sumtext="소득세"/>
- <Column id="resdntax" type="STRING" size="256" sumtext="주민세"/>
- <Column id="healthamt" type="STRING" size="256" sumtext="건강보험(본인부담금)"/>
- <Column id="mtrtamt" type="STRING" size="256" sumtext="장기요양(본인부담금)"/>
- <Column id="pensionamt" type="STRING" size="256" sumtext="국민연금(본인부담금)"/>
- <Column id="empinsuamt" type="STRING" size="256" sumtext="고용보험(본인부담금)"/>
- <Column id="healthamt2" type="STRING" size="256" sumtext="건강보험(기관부담금)"/>
- <Column id="mtrtamt2" type="STRING" size="256" sumtext="장기요양(기관부담금)"/>
- <Column id="pensionamt2" type="STRING" size="256" sumtext="국민연금(기관부담금)"/>
- <Column id="empinsuamt2" type="STRING" size="256" sumtext="고용보험(기관부담금)"/>
- <Column id="indinsuamt2" type="STRING" size="256" sumtext="산재보험(기관부담금)"/>
- <Column id="taxsum" type="STRING" size="256" sumtext="원천세(합계)"/>
- <Column id="psnsum" type="STRING" size="256" sumtext="본인부담계"/>
- <Column id="instsum" type="STRING" size="256" sumtext="기관합계"/>
- <Column id="realamt" type="STRING" size="256" sumtext="실지급액"/>
- <Column id="puminstsum" type="STRING" size="256" sumtext="품의금액지급총액 + 4대보험사업주부담금"/>
- <Column id="name" type="STRING" size="256" sumtext="소득자성명"/>
- <Column id="entcodd" type="STRING" size="256" sumtext="입사일자"/>
- <Column id="supaddr" type="STRING" size="256" sumtext="상위주소"/>
- <Column id="infaddr" type="STRING" size="256" sumtext="하위주소"/>
- <Column id="address" type="STRING" size="256" sumtext="주소"/>
- <Column id="ionatiflag" type="STRING" size="256" sumtext="내/외국인"/>
- <Column id="residentflag" type="STRING" size="256" sumtext="거주자구분"/>
- <Column id="slipyn" type="STRING" size="256" sumtext="전표입력여부"/>
- <Column id="cnt" type="STRING" size="256" sumtext="지급건수"/>
- <Column id="rrgstnovalidyn" type="STRING" size="256" sumtext="유효여부"/>
- <Column id="BgColor" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_format" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="checkedcnt" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row/>
- </Rows>
- </Dataset>
- <Dataset id="ds_pop6data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="pumno" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
- <Column id="emplno" type="STRING" size="256" sumtext="사번"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_temp_authchk_userauth" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="slipreqapproval" type="STRING" size="256" sumtext="전표승인요청권한"/>
- <Column id="slipreqcancel" type="STRING" size="256" sumtext="전표승인요청취소권한"/>
- <Column id="sliprecognition" type="STRING" size="256" sumtext="전표승인권한"/>
- <Column id="slipcancel" type="STRING" size="256" sumtext="전표승인취소권한"/>
- <Column id="authmgt" type="STRING" size="256" sumtext="권한부여 권한"/>
- <Column id="etctax" type="STRING" size="256" sumtext="기타소득세 권한"/>
- <Column id="custstat" type="STRING" size="256" sumtext="거래처지급중지권한"/>
- <Column id="rcvcheck" type="STRING" size="256" sumtext="계산서입금확인권한"/>
- <Column id="incmcnfm" type="STRING" size="256" sumtext="소득확인현황권한"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_send_rertparams2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="name" type="STRING" size="256"/>
- <Column id="rrgstno" type="STRING" size="256"/>
- <Column id="retrflag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="name"/>
- <Col id="rrgstno"/>
- <Col id="retrflag"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_hidden_incmpsn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
- <Column id="rrgstno" type="STRING" size="256" sumtext="주민등록번호"/>
- <Column id="name" type="STRING" size="256" sumtext="성명"/>
- <Column id="entcodd" type="STRING" size="256" sumtext="입사일자"/>
- <Column id="ionatiflag" type="STRING" size="256" sumtext="내외국인구분"/>
- <Column id="residentflag" type="STRING" size="256" sumtext="거주지구분"/>
- <Column id="residncnati" type="STRING" size="256" sumtext="거주지국"/>
- <Column id="zipcd" type="STRING" size="256" sumtext="우편번호"/>
- <Column id="zipcd1" type="STRING" size="256" sumtext="우편번호1"/>
- <Column id="zipcd2" type="STRING" size="256" sumtext="우편번호2"/>
- <Column id="zipcdseqno" type="STRING" size="256" sumtext="우편번호일련번호"/>
- <Column id="supaddr" type="STRING" size="256" sumtext="상위주소"/>
- <Column id="infaddr" type="STRING" size="256" sumtext="하위주소"/>
- <Column id="status" type="STRING" size="256" sumtext="상태"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_list_prntetcproflist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_hidden_prntetclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_hidden_prntetclist_etcproflist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send_retrparams" columnid="instcd"/>
- <BindItem id="item1" compid="grp_sea.cmb_day" propid="value" datasetid="ds_send_retrparams" columnid="dayflag"/>
- <BindItem id="item2" compid="grp_sea.ipt_frym" propid="value" datasetid="ds_send_retrparams" columnid="frdd"/>
- <BindItem id="item3" compid="grp_sea.ipt_toym" propid="value" datasetid="ds_send_retrparams" columnid="todd"/>
- <BindItem id="item4" compid="grp_sea.cmb_day00" propid="value" datasetid="ds_send_retrparams" columnid="ionatiflag"/>
- <BindItem id="item5" compid="grp_sea.ipt_rrgstno" propid="value" datasetid="ds_send_retrparams" columnid="rrgstno"/>
- <BindItem id="item6" compid="grp_sea.ipt_name" propid="value" datasetid="ds_send_retrparams" columnid="name"/>
- <BindItem id="item7" compid="grp_sea.cmb_day01" propid="value" datasetid="ds_send_retrparams" columnid="residentflag"/>
- <BindItem id="item8" compid="output8" propid="value" datasetid="ds_send_printparams" columnid="payAmt"/>
- <BindItem id="item9" compid="output7" propid="value" datasetid="ds_send_printparams" columnid="realAmt"/>
- <BindItem id="item10" compid="output6" propid="value" datasetid="ds_send_printparams" columnid="taxSum"/>
- <BindItem id="item11" compid="output5" propid="value" datasetid="ds_send_printparams" columnid="psnSum"/>
- <BindItem id="item12" compid="output1" propid="value" datasetid="ds_send_printparams" columnid="instSum"/>
- <BindItem id="item13" compid="output2" propid="value" datasetid="ds_send_printparams" columnid="puminstSum"/>
- <BindItem id="item14" compid="output9" propid="value" datasetid="ds_hidden" columnid="checkedcnt"/>
- </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_acntcommonxp::RAD001.xjs";
- var gPopflag = ""
- function SMRAT01600_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SMRAT01600_onload(obj:Form, e:LoadEventInfo)
- {
- grdf_initGrid(grd_etcproflist);
- grdf_setRowTypeIcon(grd_etcproflist, 0);
-
- try
- {
- ds_pop6data.copyData(arg_ds_pop6data);
- }
- catch(e)
- {
- }
-
- gPopflag = ds_pop6data.getColumn(0, "pumno");
-
- fInitialize();
-
- ds_send_retrparams.setColumn(0, "dayflag", "P");
-
- if (!utlf_isNull(gPopflag))
- {
- grp_sea.cmb_instcd.enable = false;
-
- btn_close.visible = true; //닫기버튼
-
- ds_send_retrparams.setColumn(0, "pumno", ds_pop6data.getColumn(0, "pumno"));
-
- grp_sea.btn_search.click();
-
- ds_send_retrparams.setColumn(0, "pumno", "");
- }
- }
- function fInitialize()
- {
- var oParam = {};
- oParam.id = "TRRAI00301";
- oParam.service = "accountinfoapp.AccountInfo";
- oParam.method = "reqGetAuthchk";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_temp_authchk_userauth=userauth";
- oParam.async = false;
- oParam.callback = "cf_TRRAI00301";
- tranf_submit(oParam);
-
- ds_main_list_etcproflist.clearData();
-
- misfComboComCdListMulti("Z0007", "grp_sea.cmb_instcd");
-
- ds_send_retrparams.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
- ds_send_retrparams.setColumn(0, "frdd", utlf_getCurrentDate());
- ds_send_retrparams.setColumn(0, "todd", utlf_getCurrentDate());
-
- ds_send_rertparams2.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
- }
- function cf_TRRAI00301(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0)
- {
- grp_sea.enable = false;
- return;
- }
- else
- {
- if(ds_temp_authchk_userauth.getColumn(0, "etctax") != "Y")
- {
- sysf_messageBox("해당 프로그램의 사용 권한이 없습니다. " + "\n\n" +
- "권한 부여에 관해서는 재무파트의 담당자에게 문의바랍니다. ", "E000");
- grp_sea.enable = false;
- return;
- }
- }
- }
- function grp_sea_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- if( obj.value != sysf_getUserInfo("dutplceinstcd"))
- {
- btn_save.enable = false;
- btn_print.enable = false;
- btn_openpsn.enable = false;
- btn_addrow.enable = false;
- btn_delrow.enable = false;
-
- btn_excelupload.enable = false;
- btn_excelformat.enable = false;
- }
- else
- {
- btn_save.enable = true;
- btn_print.enable = true;
- btn_openpsn.enable = true;
- btn_addrow.enable = true;
- btn_delrow.enable = true;
-
- btn_excelupload.enable = true;
- btn_excelformat.enable = true;
- }
- ds_send_rertparams2.setColumn(0, "instcd", ds_send_retrparams.getColumn(0, "instcd"));
-
- fRetrieve();
- }
- function fRetrieve()
- {
- ds_main_list_etcproflist.clearData();
-
- var oParam = {};
- oParam.id = "TRRAT01601";
- oParam.service = "addtaxapp.Addtax";
- oParam.method = "reqGetEarnIncmList";
- oParam.inds = "req=ds_send_retrparams";
- oParam.outds = "ds_main_list_etcproflist=etcproflist";
- oParam.async = false;
- //oParam.callback = "cf_TRRAT01601";
- tranf_submit(oParam);
- dsf_setDefaultVal(ds_main_list_etcproflist, "rrgstnovalidyn:Y");
- var column = "pumno,name,rrgstno,ionatiflag,paydd,getdd,payamt,incmtax,resdntax,healthamt,mtrtamt,pensionamt,empinsuamt,healthamt2,mtrtamt2,pensionamt2,empinsuamt2,indinsuamt2";
- column = column.split(",");
-
- ds_main_list_etcproflist.updatecontrol = false;
- for(var i = 0; i < ds_main_list_etcproflist.rowcount; i++)
- {
- if(ds_main_list_etcproflist.getColumn(i, "chkyn") == "Y")
- {
- ds_main_list_etcproflist.setColumn(i, "chknm", "확인");
- for(var j = 0; j < column.length; j++)
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", column[j]), "edittype", "none");
- }
- }
- else
- {
- for(var j = 0; j < column.length; j++)
- {
- if(column[j] == "ionatiflag")
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", column[j]), "edittype", "combo");
- }
- else if(column[j] == "paydd" || column[j] == "getdd")
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", column[j]), "edittype", "date");
- }
- else
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", column[j]), "edittype", "normal");
- }
- }
- }
- }
- ds_main_list_etcproflist.updatecontrol = true;
-
- fSetControlAttr();
- }
- function fSetControlAttr()
- {
- if(ds_send_retrparams.getColumn(0, "retrkind") == "sum")
- {
- btn_save.enable = false;
- btn_addrow.enable = false;
- btn_delrow.enable = false;
- btn_print.enable = true;
-
- var column = "incmflag,name,rrgstno,posyear,paytotamt,payamt,proftax,chk";
- column = column.split(",");
- for(var j = 0; j < column.length; j++)
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", column[j]), "edittype", "none");
- }
- }
- else
- {
- if(!utlf_isNull(ds_send_retrparams.getColumn(0, "rrgstno")) && !utlf_isNull(ds_send_retrparams.getColumn(0, "name")))
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", "chk"), "edittype", "normal");
- }
- else
- {
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", "chk"), "edittype", "none");
- }
- }
- }
- function grp_sea_cmb_day_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- if(obj.value == "G")
- {
- grp_sea.ipt_frym.dateformat = "yyyy-MM";
- grp_sea.ipt_frym.editformat = "yyyy-MM";
-
- grp_sea.ipt_toym.dateformat = "yyyy-MM";
- grp_sea.ipt_toym.editformat = "yyyy-MM";
- }
-
- if(obj.value == "P")
- {
- grp_sea.ipt_frym.dateformat = "yyyy-MM-dd";
- grp_sea.ipt_frym.editformat = "yyyy-MM-dd";
-
- grp_sea.ipt_toym.dateformat = "yyyy-MM-dd";
- grp_sea.ipt_toym.editformat = "yyyy-MM-dd";
- }
- }
- function grp_sea_ipt_rrgstno_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- grp_sea.ipt_name.setFocus();
- }
- }
- function ds_send_retrparams_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "rrgstno")
- {
- if(utlf_isNull(e.newvalue))
- {
- obj.setColumn(0, "name", "");
- return;
- }
-
- ds_send_rertparams2.setColumn(0, "name", "");
- ds_send_rertparams2.setColumn(0, "rrgstno", e.newvalue);
- ds_send_rertparams2.setColumn(0, "retrflag", "code");
- var oParam = {};
- oParam.id = "TRRAC00612";
- oParam.service = "acntbaseinfoapp.AcntBaseInfo";
- oParam.method = "reqGetEarnedIncmPsn";
- oParam.inds = "req=ds_send_rertparams2";
- oParam.outds = "ds_hidden_incmpsn=incmpsn";
- oParam.async = false;
- oParam.callback = "cf_TRRAC00612";
- tranf_submit(oParam);
- fRetrieve();
- }
-
- if(e.columnid == "name")
- {
- if(utlf_isNull(e.newvalue))
- {
- obj.setColumn(0, "rrgstno", "");
- return;
- }
-
- ds_send_rertparams2.setColumn(0, "rrgstno", "");
- ds_send_rertparams2.setColumn(0, "name", e.newvalue);
- ds_send_rertparams2.setColumn(0, "retrflag", "name");
- var oParam = {};
- oParam.id = "TRRAC00612";
- oParam.service = "acntbaseinfoapp.AcntBaseInfo";
- oParam.method = "reqGetEarnedIncmPsn";
- oParam.inds = "req=ds_send_rertparams2";
- oParam.outds = "ds_hidden_incmpsn=incmpsn";
- oParam.async = false;
- oParam.callback = "cf_TRRAC00612";
- tranf_submit(oParam);
-
- fRetrieve();
- }
- }
- function cf_TRRAC00612(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0)
- {
- return;
- }
- else
- {
- dsf_setFixVal(ds_hidden_incmpsn, "status:-");
- if (ds_hidden_incmpsn.rowcount > 0)
- {
- ds_send_retrparams.setColumn(0, "name", ds_hidden_incmpsn.getColumn(0, "name"));
- ds_send_retrparams.setColumn(0, "rrgstno", ds_hidden_incmpsn.getColumn(0, "rrgstno"));
- }
- else
- {
- ds_send_retrparams.setColumn(0, "name", "");
- ds_send_retrparams.setColumn(0, "rrgstno", "");
- }
- }
- }
- function grp_sea_btn_entregnohelp_onclick(obj:Button, e:ClickEventInfo)
- {
- misfOpenPopUpList("61", ds_send_retrparams, "", "rrgstno,name");
-
- if(utlf_isNull(grp_sea.ipt_rrgstno.value))
- {
- return;
- }
- ds_send_rertparams2.setColumn(0, "name", "");
- ds_send_rertparams2.setColumn(0, "rrgstno", ds_send_retrparams.getColumn(0, "rrgstno"));
- ds_send_rertparams2.setColumn(0, "retrflag", "code");
-
- var oParam = {};
- oParam.id = "TRRAC00612";
- oParam.service = "acntbaseinfoapp.AcntBaseInfo";
- oParam.method = "reqGetEarnedIncmPsn";
- oParam.inds = "req=ds_send_rertparams2";
- oParam.outds = "ds_hidden_incmpsn=incmpsn";
- oParam.async = false;
- oParam.callback = "cf_TRRAC00612";
- tranf_submit(oParam);
-
- fRetrieve();
- }
- function grp_sea_ipt_name_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- grp_sea.btn_search.setFocus();
- }
- }
- function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- fRetrieve();
- }
- function btn_close_onclick(obj:Button, e:ClickEventInfo)
- {
- this.close();
- }
- function btn_print_onclick(obj:Button, e:ClickEventInfo)
- {
- var flag = true;
- if(utlf_isNull(ds_send_retrparams.getColumn(0, "rrgstno")))
- {
- flag = false;
- }
-
- if( flag == true )
- {
- fPrint();
- }
- else
- {
- sysf_messageBox("소득자 기준으로 조회해야 출력 가능합니다. 소득자를 조회해주십시오.", "E000", "");
- }
- }
- function fPrint()
- {
- var iLength = ds_main_list_prntetcproflist.rowcount;
- ds_hidden_prntetclist_etcproflist.clearData();
- ds_hidden_prntetclist.clearData();
-
- if(grdf_getSelectedRows(grd_etcproflist).length > 0)
- {
- for(var a = 0 ; a < grdf_getSelectedRows(grd_etcproflist).length; a++ )
- {
- var addRow = ds_hidden_prntetclist_etcproflist.addRow();
- ds_hidden_prntetclist_etcproflist.copyRow(addRow, ds_main_list_etcproflist, a);
- }
- }
- else
- {
- for(var i = 0; i < iLength; i++)
- {
- var addRow = ds_hidden_prntetclist_etcproflist.addRow();
- ds_hidden_prntetclist_etcproflist.copyRow(addRow, ds_main_list_etcproflist, i);
- }
- }
-
- var lstcnt = ds_hidden_prntetclist_etcproflist.rowcount-1;
-
- dsf_makeValue(ds_hidden_prntlist, "lstpaydd", "string", ds_hidden_prntetclist_etcproflist.getColumn(lstcnt, "paydd"), 0);
- dsf_makeValue(ds_hidden_prntlist, "flag", "string", "1", 0);
- var objDOM = rptf_createDOM();
- rptf_setNodeListToDOM(objDOM, "/root/hidden/prntetclist/etcproflist", ds_hidden_prntetclist_etcproflist);
- rptf_setNodeListToDOM(objDOM, "/root/hidden/prntlist", ds_hidden_prntlist);
- var objParam = new Object();
- objParam.xml_data_XML1 = objDOM.documentElement.source;
- var option = "";
- rptf_exeReportPreview30(["RPRAD00216"],[objParam], option);
-
- dsf_makeValue(ds_hidden_prntlist, "flag", "string", "2", 0);
-
- var objDOM = rptf_createDOM();
- rptf_setNodeListToDOM(objDOM, "/root/hidden/prntetclist/etcproflist", ds_hidden_prntetclist_etcproflist);
- rptf_setNodeListToDOM(objDOM, "/root/hidden/prntlist", ds_hidden_prntlist);
- var objParam = new Object();
- objParam.xml_data_XML1 = objDOM.documentElement.source;
- var option = "";
- rptf_exeReportPreview30(["RPRAD00216"],[objParam], option);
- }
- function btn_save_onclick(obj:Button, e:ClickEventInfo)
- {
- fSave();
- }
- function fSave()
- {
- for(var i = 0; i < ds_main_list_etcproflist.rowcount; i++)
- {
- var sRrgstno = ds_main_list_etcproflist.getColumn(i, "rrgstno");
- var sPumno = ds_main_list_etcproflist.getColumn(i, "pumno");
- var sPayamt = ds_main_list_etcproflist.getColumn(i, "payamt");
- var sPaydd = ds_main_list_etcproflist.getColumn(i, "paydd");
- var sGetdd = ds_main_list_etcproflist.getColumn(i, "getdd");
-
- if(String(sPumno).length != 12 )
- {
- if ( ds_main_list_etcproflist.getRowType(i) == 2 && ds_main_list_etcproflist.getRowType(i) == 4)
- {
- sysf_messageBox("품의번호를 12자리 형태 ( 예 : 20150203-0017 ) 로" , "C001");
- return;
- }
- }
-
- if(utlf_isNull(sRrgstno))
- {
- sysf_messageBox("소득자를", "C001");
- return;
- }
-
- if(String(sPaydd).length != 8 )
- {
- sysf_messageBox("지급일자를 8자리 형태 ( 예 : 2017-02-03 ) 로" , "C001");
- return;
- }
- if(String(sGetdd).length != 6 )
- {
- sysf_messageBox("귀속년월을 6자리 형태 ( 예 : 2015-02 ) 로" , "C001");
- return;
- }
-
- if(utlf_isNull(sPayamt))
- {
- sysf_messageBox("급여를", "C001");
- return;
- }
-
- }
- var oParam = {};
- oParam.id = "TXRAT01601";
- oParam.service = "addtaxapp.Addtax";
- oParam.method = "reqExeSaveEichList";
- oParam.inds = "req=ds_main_list_etcproflist:U";
- oParam.outds = "";
- oParam.async = false;
- oParam.callback = "cf_TXRAT01601";
- tranf_submit(oParam);
- }
- function cf_TXRAT01601(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0)
- {
- return;
- }
- else
- {
- fRetrieve();
- }
- }
- function btn_excelformat_onclick(obj:Button, e:ClickEventInfo)
- {
- ds_format.clearData();
- var addRow = ds_format.addRow();
-
- var sTitle = "근로소득 입력 양식";
-
- ds_format.setColumn(addRow, "pumno", "201703120001");
- ds_format.setColumn(addRow, "rrgstno", "9103291674112");
- ds_format.setColumn(addRow, "paydd", "20170310");
- ds_format.setColumn(addRow, "getdd", "201703");
- grdf_exportExcel(grd_excelformat, sTitle, "see", "false");
- }
- function btn_excelupload_onclick(obj:Button, e:ClickEventInfo)
- {
- grdf_ImportExcel("ds_format", 2, grd_excelformat)
-
- ds_main_list_etcproflist.clearData();
-
- for (var i = 0; i < ds_format.rowcount; i++)
- {
- var row = ds_main_list_etcproflist.addRow();
-
- ds_main_list_etcproflist.setColumn(i, "pumno", ds_format.getColumn(i, "pumno"));
- ds_main_list_etcproflist.setColumn(i, "rrgstno", ds_format.getColumn(i, "rrgstno"));
- ds_main_list_etcproflist.setColumn(i, "paydd", ds_format.getColumn(i, "paydd"));
- ds_main_list_etcproflist.setColumn(i, "getdd", ds_format.getColumn(i, "getdd"));
- ds_main_list_etcproflist.setColumn(i, "payamt", ds_format.getColumn(i, "payamt"));
- ds_main_list_etcproflist.setColumn(i, "incmtax", ds_format.getColumn(i, "incmtax"));
- ds_main_list_etcproflist.setColumn(i, "resdntax", ds_format.getColumn(i, "resdntax"));
- ds_main_list_etcproflist.setColumn(i, "healthamt", ds_format.getColumn(i, "healthamt"));
- ds_main_list_etcproflist.setColumn(i, "mtrtamt", ds_format.getColumn(i, "mtrtamt"));
- ds_main_list_etcproflist.setColumn(i, "pensionamt", ds_format.getColumn(i, "pensionamt"));
- ds_main_list_etcproflist.setColumn(i, "empinsuamt", ds_format.getColumn(i, "empinsuamt"));
- ds_main_list_etcproflist.setColumn(i, "healthamt2", ds_format.getColumn(i, "healthamt2"));
- ds_main_list_etcproflist.setColumn(i, "mtrtamt2", ds_format.getColumn(i, "mtrtamt2"));
- ds_main_list_etcproflist.setColumn(i, "pensionamt2", ds_format.getColumn(i, "pensionamt2"));
- ds_main_list_etcproflist.setColumn(i, "empinsuamt2", ds_format.getColumn(i, "empinsuamt2"));
- ds_main_list_etcproflist.setColumn(i, "indinsuamt2", ds_format.getColumn(i, "indinsuamt2"));
- ds_main_list_etcproflist.setColumn(i, "instcd", grp_sea.cmb_instcd.value);
-
- if(!utlf_isNull(gPopflag))
- {
- ds_main_list_etcproflist.setColumn(i, "pumno", ds_pop6data.getColumn(0, "pumno"));
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", "pumno"), "edittype", "none");
- }
- }
- }
- function button1_onclick(obj:Button, e:ClickEventInfo)
- {
- for(var i = 0; i < ds_main_list_etcproflist.rowcount; i++)
- {
- sRrgstno = ds_main_list_etcproflist.getColumn(i, "rrgstno");
-
- if(!radfJuminCheck(sRrgstno) && ds_main_list_etcproflist.getColumn(i, "ionatiflag") == "1" || !radfFgnJuminCheck(sRrgstno) && ds_main_list_etcproflist.getColumn(i, "ionatiflag") == "9")
- {
- ds_main_list_etcproflist.setColumn(i, "BgColor", "#ff99cc");
- ds_main_list_etcproflist.setColumn(i, "rrgstnovalidyn", "N");
- }
- }
- }
- function btn_openpsn_onclick(obj:Button, e:ClickEventInfo)
- {
- var objArg = new Object();
- objArg.arg_ds_target = ds_hidden_incmpsntemp;
-
- frmf_modal("SPRAC00612", "SPRAC00612", objArg, "", "", "", "", "", "", "", "", "", "M");
- }
- function btn_addrow_onclick(obj:Button, e:ClickEventInfo)
- {
- var dayno = utlf_getCurrentDate();
- var addRow = ds_main_list_etcproflist.addRow();
-
- ds_main_list_etcproflist.setColumn(addRow, "paydd", dayno);
- ds_main_list_etcproflist.setColumn(addRow, "getdd", String(dayno).substr(0,6));
- ds_main_list_etcproflist.setColumn(addRow, "instcd", grp_sea.cmb_instcd.value);
- ds_main_list_etcproflist.setColumn(addRow, "name", ds_hidden_incmpsn.getColumn(0, "name"));
- ds_main_list_etcproflist.setColumn(addRow, "rrgstno", ds_hidden_incmpsn.getColumn(0, "rrgstno"));
- ds_main_list_etcproflist.setColumn(addRow, "ionatiflag", ds_hidden_incmpsn.getColumn(0, "ionatiflag"));
- ds_main_list_etcproflist.setColumn(addRow, "residentflag", ds_hidden_incmpsn.getColumn(0, "residentflag"));
-
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", "ionatiflag"), "edittype", "none");
-
- if (!utlf_isNull(gPopflag))
- {
- ds_main_list_etcproflist.setColumn(addRow, "pumno", ds_pop6data.getColumn(0, "pumno"));
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", "chknm"), "edittype", "none");
- grd_etcproflist.setCellProperty("Body", grd_etcproflist.getBindCellIndex("Body", "pumno"), "edittype", "none");
- }
- }
- function btn_delrow_onclick(obj:Button, e:ClickEventInfo)
- {
- if(ds_main_list_etcproflist.getColumn(ds_main_list_etcproflist.rowposition, "chkyn") == "Y")
- {
- sysf_messageBox(" 확인(체크) 처리된 내역은 수정불가합니다.", "E999", "");
- return;
- }
-
- var status = ds_main_list_etcproflist.getRowType(ds_main_list_etcproflist.rowposition);
-
- if(status == 1)
- {
- ds_main_list_etcproflist.updatecontrol = false;
- ds_main_list_etcproflist.setRowType(ds_main_list_etcproflist.rowposition, "d");
- ds_main_list_etcproflist.updatecontrol = true;
- }
- else if(status == 2)
- {
- ds_main_list_etcproflist.deleteRow(ds_main_list_etcproflist.rowposition);
- }
- else if(status == 4)
- {
- ds_main_list_etcproflist.updatecontrol = false;
- ds_main_list_etcproflist.setRowType(ds_main_list_etcproflist.rowposition, "d");
- ds_main_list_etcproflist.updatecontrol = true;
- }
- }
- function btn_excel_onclick(obj:Button, e:ClickEventInfo)
- {
- if(fGridStatusCheck())
- {
- var sTitle = "근로소득 " + utlf_transEmptyToNull(String(ds_send_retrparams.getColumn(0, "frdd")).substr(2, 2)) + "-" + utlf_transEmptyToNull(String(ds_send_retrparams.getColumn(0, "frdd")).substr(4, 2)) + utlf_transEmptyToNull(String(ds_send_retrparams.getColumn(0, "frdd")).substr(6, 2))
- + " ~ " + utlf_transEmptyToNull(String(ds_send_retrparams.getColumn(0, "todd")).substr(2, 2))+ "-" + utlf_transEmptyToNull(String(ds_send_retrparams.getColumn(0, "todd")).substr(4, 2))+ "-" + utlf_transEmptyToNull(String(ds_send_retrparams.getColumn(0, "todd")).substr(6, 2));
- grdf_exportExcel(grd_etcproflist, sTitle, "see", "false");
- }
- }
- function grd_etcproflist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
- {
- ds_hidden_incmpsn.setColumn(0, "name", ds_main_list_etcproflist.getColumn(e.row, "name"));
-
- misfOpenPopUpList("61", ds_hidden_incmpsn, "", "rrgstno,name,zipcd,zipcd1,zipcd2,zipcdseqno,supaddr,infaddr,ionatiflag", "")
-
- ds_main_list_etcproflist.setColumn(e.row, "name", ds_hidden_incmpsn.getColumn(0, "name"));
- ds_main_list_etcproflist.setColumn(e.row, "rrgstno", ds_hidden_incmpsn.getColumn(0, "rrgstno"));
- ds_main_list_etcproflist.setColumn(e.row, "ionatiflag", ds_hidden_incmpsn.getColumn(0, "ionatiflag"));
- }
- function ds_main_list_etcproflist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "name" || e.columnid == "rrgstno")
- {
- ds_send_rertparams2.setColumn(0, "instcd", ds_send_retrparams.getColumn(0, "instcd"));
-
- if(e.columnid == "name")
- {
- ds_send_rertparams2.setColumn(0, "name", e.newvalue);
- ds_send_rertparams2.setColumn(0, "rrgstno", "");
- ds_send_rertparams2.setColumn(0, "retrflag", "name");
- }
- else if(e.columnid == "rrgstno")
- {
- ds_send_rertparams2.setColumn(0, "name", "");
- ds_send_rertparams2.setColumn(0, "rrgstno", e.newvalue);
- ds_send_rertparams2.setColumn(0, "retrflag", "code");
- }
- var oParam = {};
- oParam.id = "TRRAC00612";
- oParam.service = "acntbaseinfoapp.AcntBaseInfo";
- oParam.method = "reqGetEarnedIncmPsn";
- oParam.inds = "req=ds_send_rertparams2";
- oParam.outds = "ds_hidden_incmpsn=incmpsn";
- oParam.async = false;
- oParam.callback = "cf_TRRAC00612_1";
- tranf_submit(oParam);
- }
- else if(e.columnid == "payamt")
- {
- var sPayamt = e.newvalue
- var sIncmtax = obj.getColumn(e.row, "incmtax");
- var sResdntax = obj.getColumn(e.row, "resdntax");
- var sHealthamt = obj.getColumn(e.row, "healthamt");
- var sMtrtamt = obj.getColumn(e.row, "mtrtamt");
- var sPensionamt = obj.getColumn(e.row, "pensionamt");
- var sEmpinsuamt = obj.getColumn(e.row, "empinsuamt");
- var sHealthamt2 = obj.getColumn(e.row, "healthamt2");
- var sMtrtamt2 = obj.getColumn(e.row, "mtrtamt2");
- var sPensionamt2 = obj.getColumn(e.row,"pensionamt2");
- var sEmpinsuamt2 = obj.getColumn(e.row, "empinsuamt2");
- var sIndinsuamt2 = obj.getColumn(e.row, "indinsuamt2");
-
- var iPayamt = (utlf_isNull(sPayamt))? 0: parseInt(sPayamt );
- var iIncmtax = (utlf_isNull(iIncmtax))? 0: parseInt(iIncmtax );
- var iResdntax = (utlf_isNull(iResdntax))? 0: parseInt(iResdntax );
- var iHealthamt = (utlf_isNull(iHealthamt))? 0: parseInt(iHealthamt );
- var iMtrtamt = (utlf_isNull(iMtrtamt))? 0: parseInt(iMtrtamt );
- var iPensionamt = (utlf_isNull(iPensionamt))? 0: parseInt(iPensionamt );
- var iEmpinsuamt = (utlf_isNull(iEmpinsuamt))? 0: parseInt(iEmpinsuamt );
- var iHealthamt2 = (utlf_isNull(iHealthamt2))? 0: parseInt(iHealthamt2 );
- var iMtrtamt2 = (utlf_isNull(iMtrtamt2))? 0: parseInt(iMtrtamt2 );
- var iPensionamt2 = (utlf_isNull(iPensionamt2))? 0: parseInt(iPensionamt2 );
- var iEmpinsuamt2 = (utlf_isNull(iEmpinsuamt2))? 0: parseInt(iEmpinsuamt2 );
- var iIndinsuamt2 = (utlf_isNull(iIndinsuamt2))? 0: parseInt(iIndinsuamt2 );
-
- var fPayamt = parseFloat(iPayamt);
- iIncmtax = parseInt(fPayamt * 0.04 / 10) * 10;
- iResdntax = parseInt(iIncmtax * 0.1 / 10) * 10;
-
- obj.setColumn(e.row, "incmtax", iIncmtax);
- obj.setColumn(e.row, "resdntax", iResdntax);
- obj.setColumn(e.row, "taxsum", iIncmtax + iResdntax);
- obj.setColumn(e.row, "psnsum", iIncmtax + iResdntax + iHealthamt + iMtrtamt + iPensionamt + iEmpinsuamt);
- obj.setColumn(e.row, "instsum", iHealthamt2 + iMtrtamt2 + iPensionamt2 + iEmpinsuamt2 + iIndinsuamt2);
- obj.setColumn(e.row, "realamt", iPayamt - (iIncmtax + iResdntax + iHealthamt + iMtrtamt + iPensionamt + iEmpinsuamt));
- obj.setColumn(e.row, "puminstsum", iPayamt + (iHealthamt2 + iMtrtamt2 + iPensionamt2 + iEmpinsuamt2 + iIndinsuamt2));
- }
- else if(e.columnid == "incmtax" || e.columnid == "resdntax") || e.columnid == "healthamt" || e.columnid == "mtrtamt" ||
- e.columnid == "pensionamt" || e.columnid == "empinsuamt" || e.columnid == "healthamt2" || e.columnid == "mtrtamt2" ||
- e.columnid == "pensionamt2" || e.columnid == "empinsuamt2" || e.columnid == "indinsuamt2")
- {
- var sPayamt = obj.getColumn(e.row, "payamt");
- var sIncmtax = obj.getColumn(e.row, "incmtax");
- var sResdntax = obj.getColumn(e.row, "resdntax");
- var sHealthamt = obj.getColumn(e.row, "healthamt");
- var sMtrtamt = obj.getColumn(e.row, "mtrtamt");
- var sPensionamt = obj.getColumn(e.row, "pensionamt");
- var sEmpinsuamt = obj.getColumn(e.row, ."empinsuamt");
- var sHealthamt2 = obj.getColumn(e.row, "healthamt2");
- var sMtrtamt2 = obj.getColumn(e.row, "mtrtamt2");
- var sPensionamt2 = obj.getColumn(e.row, "pensionamt2");
- var sEmpinsuamt2 = obj.getColumn(e.row, "empinsuamt2");
- var sIndinsuamt2 = obj.getColumn(e.row, "indinsuamt2");
-
- var iPayamt = (utlf_isNull(sPayamt))? 0: parseInt(sPayamt );
- var iIncmtax = (utlf_isNull(sIncmtax))? 0: parseInt(sIncmtax );
- var iResdntax = (utlf_isNull(sResdntax))? 0: parseInt(sResdntax );
- var iHealthamt = (utlf_isNull(sHealthamt))? 0: parseInt(sHealthamt );
- var iMtrtamt = (utlf_isNull(sMtrtamt))? 0: parseInt(sMtrtamt );
- var iPensionamt = (utlf_isNull(sPensionamt))? 0: parseInt(sPensionamt );
- var iEmpinsuamt = (utlf_isNull(sEmpinsuamt))? 0: parseInt(sEmpinsuamt );
- var iHealthamt2 = (utlf_isNull(sHealthamt2))? 0: parseInt(sHealthamt2 );
- var iMtrtamt2 = (utlf_isNull(sMtrtamt2))? 0: parseInt(sMtrtamt2 );
- var iPensionamt2 = (utlf_isNull(sPensionamt2))? 0: parseInt(sPensionamt2 );
- var iEmpinsuamt2 = (utlf_isNull(sEmpinsuamt2))? 0: parseInt(sEmpinsuamt2 );
- var iIndinsuamt2 = (utlf_isNull(sIndinsuamt2))? 0: parseInt(sIndinsuamt2 );
-
- obj.setColumn(e.row, "taxsum", iIncmtax + iResdntax);
- obj.setColumn(e.row, "psnsum", iIncmtax + iResdntax + iHealthamt + iMtrtamt + iPensionamt + iEmpinsuamt);
- obj.setColumn(e.row, "instsum", iHealthamt2 + iMtrtamt2 + iPensionamt2 + iEmpinsuamt2 + iIndinsuamt2);
- obj.setColumn(e.row, "realamt", iPayamt - (iIncmtax + iResdntax + iHealthamt + iMtrtamt + iPensionamt + iEmpinsuamt));
- obj.setColumn(e.row, "puminstsum", iPayamt + (iHealthamt2 + iMtrtamt2 + iPensionamt2 + iEmpinsuamt2 + iIndinsuamt2));
- }
- }
- function cf_TRRAC00612_1(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0)
- {
- return;
- }
- else
- {
- dsf_setFixVal(ds_hidden_incmpsn, "status:-");
-
- if (ds_hidden_incmpsn.rowcount > 0)
- {
- ds_send_retrparams.setColumn(0, "name", ds_hidden_incmpsn.getColumn(0, "name"));
- ds_send_retrparams.setColumn(0, "rrgstno", ds_hidden_incmpsn.getColumn(0, "rrgstno"));
- ds_send_retrparams.setColumn(0, "ionatiflag", ds_hidden_incmpsn.getColumn(0, "ionatiflag"));
- }
- else
- {
- }
- }
- }]]></Script>
- </Form>
- </FDL>
|