123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMRSC08400" position="absolute 0 0 1211 804" titletext="국세청 세금계산서와 계약건 내역 비교" oninit="SMRSC08400_oninit" onload="SMRSC08400_onload">
- <Layouts>
- <Layout>
- <Static id="caption6" text="국세청 세금계산서 & 계약건 내역 비교" class="tit_1" position="absolute 0 0 280 25"/>
- <Tab id="switch1" taborder="1" tabindex="0" position="absolute 0 29 1195 793" anchor="all">
- <Tabpages>
- <Tabpage id="case_compare" text="색인">
- <Layouts>
- <Layout>
- <Static id="caption35" text="검수내역과 세금계산서 비교 리스트" class="tit_2" position="absolute 0 75 315 96"/>
- <Shape id="line2" linetype="horizontal" class="line_10" position="absolute 0 91 1195 97" anchor="left top right"/>
- <Grid id="grd_keumcomparelst" taborder="22" binddataset="ds_main_cmprlst_cmprinfo" useinputpanel="false" position="absolute 0 96 1195 736" autoenter="select" cellsizingtype="col" anchor="all" onlbuttonup="switch1_case_compare_grd_keumcomparelst_onlbuttonup" selecttype="multirow" tooltiptype="hover">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="22" band="left"/>
- <Column size="20" band="left"/>
- <Column size="39" band="left"/>
- <Column size="39" band="left"/>
- <Column size="75" band="left"/>
- <Column size="35" band="left"/>
- <Column size="33" band="left"/>
- <Column size="90" band="left"/>
- <Column size="200"/>
- <Column size="70"/>
- <Column size="90"/>
- <Column size="30"/>
- <Column size="80"/>
- <Column size="50"/>
- <Column size="70"/>
- <Column size="55"/>
- <Column size="90"/>
- <Column size="75"/>
- <Column size="35"/>
- <Column size="60"/>
- <Column size="60"/>
- <Column size="60"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="0"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1"/>
- <Cell col="2" text="유형"/>
- <Cell col="3" text="구분"/>
- <Cell col="4" colspan="2" text="계약일자/SEQ" taborder="undefined"/>
- <Cell col="6" colspan="2" text="거래처" taborder="undefined"/>
- <Cell col="8" text="계약건명"/>
- <Cell col="9" text="계약금액"/>
- <Cell col="10" text="사업자등록번호"/>
- <Cell col="11" text="발행"/>
- <Cell col="12" text="세금계산서"/>
- <Cell col="13" text="미용"/>
- <Cell col="14" text="계산서"/>
- <Cell col="15" colspan="2" text="계정과목" taborder="undefined"/>
- <Cell col="17" colspan="2" text="검수일자/SEQ" taborder="undefined"/>
- <Cell col="19" text="(국)세금"/>
- <Cell col="20" text="(국)미용"/>
- <Cell col="21" text="(국)계산"/>
- <Cell col="22" text="FAX"/>
- <Cell col="23" text="HP"/>
- <Cell col="24" text="TEL"/>
- <Cell col="25" text="금액"/>
- <Cell col="26" text="참고사항"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" displaytype="checkbox" edittype="checkbox" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:select" expr="expr:select == 'Y' || select == '1' ? 1 : 0"/>
- <Cell col="2" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:cont_type"/>
- <Cell col="3" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:conflagnm"/>
- <Cell col="4" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purccondd" calendardisplaynulltype="nulltext"/>
- <Cell col="5" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purcconno"/>
- <Cell col="6" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:suplplcecd"/>
- <Cell col="7" style="align:left top;padding:4 2 2 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:suppcustnm" wordwrap="word"/>
- <Cell col="8" style="align:left top;padding:4 2 2 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:goodcntnm" wordwrap="word" tooltiptext="bind:goodcntnm"/>
- <Cell col="9" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:totconamt"/>
- <Cell col="10" style="align:center middle;background:BIND(colBack);background2:BIND(colBack);" text="bind:entrregno" mask="expr:utlf_isNull(entrregno) ? '' : '###-##-#####'" maskchar=" "/>
- <Cell col="11" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:issueyn"/>
- <Cell col="12" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:ttaxamt"/>
- <Cell col="13" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:ttaxamt2"/>
- <Cell col="14" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:sumamt3"/>
- <Cell col="15" style="padding:2 2 2 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:acntcd"/>
- <Cell col="16" style="align:center top;padding:4 2 2 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:acntnm" wordwrap="word" tooltiptext="bind:acntnm"/>
- <Cell col="17" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purcchkdd" calendardisplaynulltype="nulltext"/>
- <Cell col="18" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purcchkno"/>
- <Cell col="19" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:n1"/>
- <Cell col="20" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:n2"/>
- <Cell col="21" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:n3"/>
- <Cell col="22" style="align:center top;padding:4 2 2 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:faxno" wordwrap="word"/>
- <Cell col="23" displaytype="text" edittype="text" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:taxhp"/>
- <Cell col="24" style="align:center top;padding:4 2 2 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:cntctel" wordwrap="word"/>
- <Cell col="25" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:tamt"/>
- <Cell col="26" displaytype="text" edittype="text" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:cmt"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Div id="grp_sea" taborder="25" position="absolute 0 0 1195 60" class="div_SA2" anchor="left top right">
- <Layouts>
- <Layout>
- <Static id="caption2" text="계정과목 :" class="search_name" position="absolute 547 8 633 25" anchor="default"/>
- <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1034 7 1040 29" anchor="default"/>
- <Calendar id="ipt_srchbasedd" taborder="9" class="input_default" position="absolute 104 7 191 26" mask="yyyy-mm" anchor="default" autoselect="true" autoskip="true" onchanged="switch1_case_compare_grp_sea_ipt_srchbasedd_onchanged" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
- <Static id="caption1" text="기준일자 :" class="search_name" position="absolute 19 9 109 26" anchor="default"/>
- <Button id="btn_regnohelp" taborder="10" class="icon_search" position="absolute 360 37 376 53" anchor="default" onclick="switch1_case_compare_grp_sea_btn_regnohelp_onclick"/>
- <Edit id="ipt_suppcustnm" taborder="11" position="absolute 378 35 497 54" anchor="default" class="output" style="background:URL('theme://images/bg_edit_R.png') stretch 5,5;" readonly="true"/>
- <Edit id="ipt_suppcustcd" taborder="12" class="input" position="absolute 303 35 357 54" anchor="default" autoselect="true" onkeydown="switch1_case_compare_grp_sea_ipt_suppcustcd_onkeydown"/>
- <Static id="caption5" text="거래처 :" class="search_name" position="absolute 231 36 321 53" anchor="default" enable="true"/>
- <Edit id="ipt_srchwinacnt" taborder="13" class="input" position="absolute 631 7 711 26" anchor="default" enable="true" autoselect="true" autoskip="true"/>
- <Edit id="opt_srchwinacntnm" taborder="14" readonly="true" position="absolute 734 7 849 26" anchor="default" class="output"/>
- <Button id="btn_srchwinacnt" taborder="15" class="icon_search" position="absolute 714 9 730 25" anchor="default" onclick="switch1_case_compare_grp_sea_btn_srchwinacnt_onclick"/>
- <Button id="btn_save" taborder="17" text="저장" class="btn4" position="absolute 1123 7 1179 29" anchor="default" onclick="switch1_case_compare_grp_sea_btn_save_onclick"/>
- <Button id="btn_sea" taborder="18" text="조회" class="btn1" position="absolute 1052 7 1108 29" anchor="default" onclick="switch1_case_compare_grp_sea_btn_sea_onclick"/>
- <Calendar id="ipt_srchchktodd" taborder="19" class="combo_default" position="absolute 428 7 531 26" anchor="default" enable="true" autoselect="true" autoskip="true"/>
- <Static id="caption42" text="~" position="absolute 413 8 428 28" anchor="default"/>
- <Calendar id="ipt_srchchkfrdd" taborder="20" class="combo_default" position="absolute 307 7 410 26" anchor="default" enable="true" autoselect="true" autoskip="true"/>
- <Static id="caption14" text="검수일자 :" class="search_name" position="absolute 230 5 315 30" anchor="default"/>
- <Combo id="cmb_instcd" taborder="21" innerdataset="ds_init_cmb_instcd" codecolumn="cdid" datacolumn="cdnm" class="combo_default" visible="false" position="absolute 192 6 212 25" anchor="default"/>
- <Static id="caption12" text="구 분 :" class="search_name" position="absolute 20 37 110 54"/>
- <Combo id="cmb_conflagnm" taborder="22" position="absolute 105 35 206 54" codecolumn="codecolumn" datacolumn="datacolumn" index="-1">
- <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">단가</Col>
- <Col id="datacolumn">단가</Col>
- </Row>
- <Row>
- <Col id="codecolumn">수의</Col>
- <Col id="datacolumn">수의</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- </Layout>
- </Layouts>
- </Div>
- <Button id="button5" taborder="26" text="Excel 저장" class="btn5" position="absolute 1120 71 1195 91" onclick="switch1_case_compare_button5_onclick"/>
- <Button id="btn_prta" taborder="28" text="출력" class="btn6" position="absolute 1063 71 1119 91" onclick="switch1_case_compare_btn_prta_onclick"/>
- <Button id="button7" taborder="29" text="거래처저장" class="btn2" visible="false" position="absolute 615 72 698 91" onclick="switch1_case_compare_button7_onclick"/>
- <CheckBox id="bol_selectall" taborder="30" visible="false" position="absolute 24 97 44 115" onclick="switch1_case_compare_bol_selectall_onclick" truevalue="true" falsevalue="false"/>
- <Static id="caption3" position="absolute 848 71 1058 89" style="color:#0000ffff;align:right middle;font:돋움체,10,bold;"/>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="case_upload" text="업 로 드">
- <Layouts>
- <Layout>
- <Static id="caption7" text="국세청 세금계산서 내역 업로드" class="tit_2" position="absolute 0 55 215 78"/>
- <Shape id="line3" linetype="horizontal" class="line_10" position="absolute 0 71 1195 77" anchor="left top right"/>
- <Static id="caption4" position="absolute 802 48 942 66" style="color:#0000ffff;font:돋움체,10,bold;"/>
- <Grid id="grd_upperlimitupload" taborder="22" binddataset="ds_main_upperlimitlst_upperlimitinfo" useinputpanel="false" position="absolute 0 76 1195 721" autoenter="select" cellsizingtype="col" anchor="all" oncellclick="switch1_case_upload_grd_upperlimitupload_oncellclick" selecttype="multirow" onlbuttonup="switch1_case_upload_grd_upperlimitupload_onlbuttonup" tooltiptype="hover">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="21" band="left"/>
- <Column size="50"/>
- <Column size="60"/>
- <Column size="80"/>
- <Column size="180"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="110"/>
- <Column size="150"/>
- <Column size="60"/>
- <Column size="150"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="100"/>
- <Column size="80"/>
- <Column size="100"/>
- <Column size="150"/>
- <Column size="150"/>
- <Column size="150"/>
- <Column size="150"/>
- <Column size="100"/>
- <Column size="60"/>
- <Column size="80"/>
- <Column size="120"/>
- <Column size="80"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="구분"/>
- <Cell col="2" text="기준일자"/>
- <Cell col="3" text="(A)작성일자"/>
- <Cell col="4" text="(B)승인번호"/>
- <Cell col="5" text="(C)발급일자"/>
- <Cell col="6" text="(D)전송일자"/>
- <Cell col="7" text="(E)사업자등록번호"/>
- <Cell col="8" text="(G)상호"/>
- <Cell col="9" text="(H)대표자"/>
- <Cell col="10" text="(I)주소"/>
- <Cell col="11" text="(K)종사업자"/>
- <Cell col="12" text="(O)합계금액"/>
- <Cell col="13" text="(P)공급가액"/>
- <Cell col="14" text="(Q)세액"/>
- <Cell col="15" text="(R)분류"/>
- <Cell col="16" text="(S)종류"/>
- <Cell col="17" text="(T)발급유형"/>
- <Cell col="18" text="(U)비고"/>
- <Cell col="19" text="(W)공급자이메일"/>
- <Cell col="20" text="(X)공급받는자이메일"/>
- <Cell col="21" text="(AA)품목명"/>
- <Cell col="22" text="(AB)규격"/>
- <Cell col="23" text="(AC)수량"/>
- <Cell col="24" text="(AD)단가"/>
- <Cell col="25" text="최종 업로드 시간"/>
- <Cell col="26" text="최종 입력자"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:flag"/>
- <Cell col="2" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:basedd" mask="yyyy-MM" calendardisplaynulltype="nulltext"/>
- <Cell col="3" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:acptdd" calendardisplaynulltype="nulltext"/>
- <Cell col="4" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:appno"/>
- <Cell col="5" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:issuedd" calendardisplaynulltype="nulltext"/>
- <Cell col="6" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:senddd" calendardisplaynulltype="nulltext"/>
- <Cell col="7" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:entrregno" mask="expr:utlf_isNull(entrregno) ? '' : '###-##-#####'" maskchar=" "/>
- <Cell col="8" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:cmpynm" wordwrap="word" tooltiptext="bind:cmpynm"/>
- <Cell col="9" style="align:left;background:BIND(colBack);background2:BIND(colBack);" text="bind:prsdnm"/>
- <Cell col="10" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:addr" wordwrap="word" tooltiptext="bind:addr"/>
- <Cell col="11" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:mnrplcno"/>
- <Cell col="12" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:totamt"/>
- <Cell col="13" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:samt"/>
- <Cell col="14" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:amount"/>
- <Cell col="15" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:taxgubun"/>
- <Cell col="16" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:taxkind"/>
- <Cell col="17" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:issuetype"/>
- <Cell col="18" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:remark" wordwrap="word" tooltiptext="bind:remark"/>
- <Cell col="19" style="align:top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:semail" wordwrap="word"/>
- <Cell col="20" style="align:top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:demail" wordwrap="word"/>
- <Cell col="21" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:goodcntnm" wordwrap="word" tooltiptext="bind:goodcntnm"/>
- <Cell col="22" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:goodspec"/>
- <Cell col="23" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:qty"/>
- <Cell col="24" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:unitcost"/>
- <Cell col="25" text="bind:lastupdtdt" mask="expr:utlf_isNull(lastupdtdt) ? '' : '####-##-## ##:##:##'"/>
- <Cell col="26" text="bind:lastupdtrid"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="button1" taborder="23" text="업로드" class="btn5" position="absolute 1142 52 1195 71" anchor="top right" onclick="switch1_case_upload_button1_onclick"/>
- <Div id="group1" taborder="24" position="absolute 0 2 1195 42" class="div_SA2" anchor="left top right">
- <Layouts>
- <Layout>
- <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1049 10 1055 32" anchor="top right"/>
- <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 1061 9 1117 31" anchor="top right" onclick="switch1_case_upload_group1_btn_search_onclick"/>
- <Static id="caption8" text="기준일자 :" class="search_name" position="absolute 19 11 109 28" anchor="default"/>
- <Calendar id="ipt_ubasedd" taborder="7" class="input_default" position="absolute 104 10 204 29" mask="yyyy-mm" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
- <Static id="caption9" text="거래처명 :" class="search_name" position="absolute 235 11 325 28" anchor="default"/>
- <Edit id="ipt_custnm" taborder="8" class="input" position="absolute 322 10 500 29" anchor="default" autoselect="true" autoskip="true"/>
- <MaskEdit id="ipt_uentrregno" taborder="9" mask="###-##-#####" class="input" position="absolute 661 10 839 29" anchor="default" autoselect="true" autoskip="true" maskchar=" " trimtype="both" type="string" displaynulltext=" " style="align:left middle;"/>
- <Static id="caption10" text="사업자 등록번호 :" class="search_name" position="absolute 534 11 658 28" anchor="default"/>
- <Button id="button3" taborder="10" text="저장" class="btn4" position="absolute 1123 8 1179 30" onclick="switch1_case_upload_group1_button3_onclick"/>
- </Layout>
- </Layouts>
- </Div>
- <Button id="button4" taborder="25" text="전체삭제" class="btn5" position="absolute 1073 52 1137 71" anchor="top right" onclick="switch1_case_upload_button4_onclick"/>
- <Button id="btn_upchk" taborder="26" text="검증" class="btn2" position="absolute 948 52 990 71" anchor="top right" onclick="switch1_case_upload_btn_upchk_onclick"/>
- <Static id="caption11" text="※ 기준일자(YYYYMM)" position="absolute 215 56 345 71" style="background:#ffcc66ff;"/>
- <Button id="button8" taborder="27" text="Excel 저장" class="btn5" position="absolute 994 52 1069 71" anchor="top right" onclick="switch1_case_upload_button8_onclick"/>
- </Layout>
- </Layouts>
- </Tabpage>
- </Tabpages>
- </Tab>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_oncolumnchanged">
- <ColumnInfo>
- <Column id="srchbasedd" type="STRING" size="256"/>
- <Column id="srchgoodcd" type="STRING" size="256"/>
- <Column id="srchchkfrdd" type="STRING" size="256"/>
- <Column id="srchchktodd" type="STRING" size="256"/>
- <Column id="srchwinacnt" type="STRING" size="256"/>
- <Column id="srchwinacntnm" type="STRING" size="256"/>
- <Column id="suppcustcd" type="STRING" size="256"/>
- <Column id="suppcustnm" type="STRING" size="256"/>
- <Column id="ugoodcd" type="STRING" size="256"/>
- <Column id="uwinacnt" type="STRING" size="256"/>
- <Column id="uwinacntnm" type="STRING" size="256"/>
- <Column id="ubasedd" type="STRING" size="256"/>
- <Column id="ucustnm" type="STRING" size="256"/>
- <Column id="uentrregno" type="STRING" size="256"/>
- <Column id="umaincustlastsuplplce" type="STRING" size="256"/>
- <Column id="umaincustlastsuplplcenm" type="STRING" size="256"/>
- <Column id="sdata" type="STRING" size="256"/>
- <Column id="refcond" type="STRING" size="256"/>
- <Column id="retrnm" type="STRING" size="256"/>
- <Column id="custstat" type="STRING" size="256"/>
- <Column id="list" type="STRING" size="256"/>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="ufromdd" type="STRING" size="256"/>
- <Column id="utodd" type="STRING" size="256"/>
- <Column id="srchfromdd" type="STRING" size="256"/>
- <Column id="srchtodd" type="STRING" size="256"/>
- <Column id="selectyn" type="STRING" size="256"/>
- <Column id="purccnsttndd" type="STRING" size="256"/>
- <Column id="purccnsttnno" type="STRING" size="256"/>
- <Column id="purccondd" type="STRING" size="256"/>
- <Column id="purcconno" type="STRING" size="256"/>
- <Column id="acptdd" type="STRING" size="256"/>
- <Column id="entrregno" type="STRING" size="256"/>
- <Column id="totamt" type="STRING" size="256"/>
- <Column id="conflagnm" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="srchbasedd"/>
- <Col id="srchgoodcd"/>
- <Col id="srchchkfrdd"/>
- <Col id="srchchktodd"/>
- <Col id="srchwinacnt"/>
- <Col id="srchwinacntnm"/>
- <Col id="suppcustcd"/>
- <Col id="suppcustnm"/>
- <Col id="ugoodcd"/>
- <Col id="uwinacnt"/>
- <Col id="uwinacntnm"/>
- <Col id="ubasedd"/>
- <Col id="ucustnm"/>
- <Col id="uentrregno"/>
- <Col id="umaincustlastsuplplce"/>
- <Col id="umaincustlastsuplplcenm"/>
- <Col id="sdata"/>
- <Col id="refcond"/>
- <Col id="retrnm"/>
- <Col id="custstat"/>
- <Col id="list"/>
- <Col id="instcd"/>
- <Col id="ufromdd"/>
- <Col id="utodd"/>
- <Col id="srchfromdd"/>
- <Col id="srchtodd"/>
- <Col id="selectyn"/>
- <Col id="purccnsttndd"/>
- <Col id="purccnsttnno"/>
- <Col id="purccondd"/>
- <Col id="purcconno"/>
- <Col id="acptdd"/>
- <Col id="entrregno"/>
- <Col id="totamt"/>
- <Col id="conflagnm"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_cmprlst_cmprinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_cmprlst_cmprinfo_oncolumnchanged">
- <ColumnInfo>
- <Column id="select" type="STRING" size="256" sumtext="선택"/>
- <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
- <Column id="cont_type" type="STRING" size="256" sumtext="유형"/>
- <Column id="conflagnm" type="STRING" size="256" sumtext="계약방법"/>
- <Column id="purccondd" type="STRING" size="256" sumtext="계약일자"/>
- <Column id="purcconno" type="STRING" size="256" sumtext="계약seq"/>
- <Column id="goodcntnm" type="STRING" size="256" sumtext="계약건명"/>
- <Column id="totconamt" type="STRING" size="256" sumtext="계약금액"/>
- <Column id="suplplcecd" type="STRING" size="256" sumtext="거래처코드"/>
- <Column id="suppcustnm" type="STRING" size="256" sumtext="거래처명"/>
- <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
- <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
- <Column id="entrregno" type="STRING" size="256" sumtext="사업자등록번호"/>
- <Column id="purcchkdd" type="STRING" size="256" sumtext="검수일자"/>
- <Column id="purcchkno" type="STRING" size="256" sumtext="검수seq"/>
- <Column id="ttaxamt" type="STRING" size="256" sumtext="세금계산서"/>
- <Column id="ttaxamt2" type="STRING" size="256" sumtext="미용"/>
- <Column id="sumamt3" type="STRING" size="256" sumtext="계산서"/>
- <Column id="n1" type="STRING" size="256" sumtext="(국)세금계산서"/>
- <Column id="n2" type="STRING" size="256" sumtext="(국)미용"/>
- <Column id="n3" type="STRING" size="256" sumtext="(국)계산서"/>
- <Column id="issueyn" type="STRING" size="256" sumtext="발행완료"/>
- <Column id="faxno" type="STRING" size="256" sumtext="fax"/>
- <Column id="taxhp" type="STRING" size="256" sumtext="세금계산서담당자"/>
- <Column id="cntctel" type="STRING" size="256" sumtext="사무실번호"/>
- <Column id="tamt" type="STRING" size="256" sumtext="금액"/>
- <Column id="cmt" type="STRING" size="256" sumtext="참고사항"/>
- <Column id="purccnsttndd" type="STRING" size="256" sumtext="품의일자"/>
- <Column id="purccnsttnno" type="STRING" size="256" sumtext="품의seq"/>
- <Column id="colBack" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_upperlimitlst_upperlimitinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="flag" type="STRING" size="256" sumtext="구분"/>
- <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
- <Column id="acptdd" type="STRING" size="256" sumtext="작성일자(검수일자)"/>
- <Column id="appno" type="STRING" size="256" sumtext="승인번호"/>
- <Column id="issuedd" type="STRING" size="256" sumtext="발급일자"/>
- <Column id="senddd" type="STRING" size="256" sumtext="전송일자"/>
- <Column id="entrregno" type="STRING" size="256" sumtext="사업자등록번호"/>
- <Column id="cmpynm" type="STRING" size="256" sumtext="상호"/>
- <Column id="prsdnm" type="STRING" size="256" sumtext="대표자"/>
- <Column id="addr" type="STRING" size="256" sumtext="주소"/>
- <Column id="mnrplcno" type="STRING" size="256" sumtext="종사업자번호"/>
- <Column id="totamt" type="STRING" size="256" sumtext="합계금액"/>
- <Column id="samt" type="STRING" size="256" sumtext="공급가액"/>
- <Column id="amount" type="STRING" size="256" sumtext="세액"/>
- <Column id="taxgubun" type="STRING" size="256" sumtext="전자세금계산서 분류"/>
- <Column id="taxkind" type="STRING" size="256" sumtext="전자세금계산서 종류"/>
- <Column id="issuetype" type="STRING" size="256" sumtext="발급유형"/>
- <Column id="remark" type="STRING" size="256" sumtext="비고"/>
- <Column id="semail" type="STRING" size="256" sumtext="공급자이메일"/>
- <Column id="demail" type="STRING" size="256" sumtext="공급받는자 이메일"/>
- <Column id="goodcntnm" type="STRING" size="256" sumtext="품목명"/>
- <Column id="goodspec" type="STRING" size="256" sumtext="품목규격"/>
- <Column id="qty" type="STRING" size="256" sumtext="품목수량"/>
- <Column id="unitcost" type="STRING" size="256" sumtext="품목단가"/>
- <Column id="colBack" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_prtinfo_cmprlst" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="appno" type="STRING" size="256" sumtext="승인번호"/>
- <Column id="entrregno" type="STRING" size="256" sumtext="사업장등록번호"/>
- <Column id="cmpynm" type="STRING" size="256" sumtext="상호"/>
- <Column id="prsdnm" type="STRING" size="256" sumtext="대표"/>
- <Column id="addr" type="STRING" size="256" sumtext="주소"/>
- <Column id="semail" type="STRING" size="256" sumtext="공급자 e-mail"/>
- <Column id="mnrplcno" type="STRING" size="256" sumtext="종사업장번호"/>
- <Column id="acptdd" type="STRING" size="256" sumtext="작성일자"/>
- <Column id="samt" type="STRING" size="256" sumtext="공급가액"/>
- <Column id="amount" type="STRING" size="256" sumtext="세액"/>
- <Column id="totamt" type="STRING" size="256" sumtext="합계금액"/>
- <Column id="remark" type="STRING" size="256" sumtext="비고"/>
- <Column id="goodcntnm" type="STRING" size="256" sumtext="품목"/>
- <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
- <Column id="qty" type="STRING" size="256" sumtext="수량"/>
- <Column id="unitcost" type="STRING" size="256" sumtext="단가"/>
- <Column id="bizcont" type="STRING" size="256" sumtext="업태"/>
- <Column id="item" type="STRING" size="256" sumtext="종목"/>
- <Column id="taxgubun" type="STRING" size="256" sumtext="분류"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_copynode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="switch1.case_compare.grp_sea.ipt_srchbasedd" propid="value" datasetid="ds_send" columnid="srchbasedd"/>
- <BindItem id="item1" compid="switch1.case_compare.grp_sea.ipt_srchchkfrdd" propid="value" datasetid="ds_send" columnid="srchchkfrdd"/>
- <BindItem id="item2" compid="switch1.case_compare.grp_sea.ipt_srchchktodd" propid="value" datasetid="ds_send" columnid="srchchktodd"/>
- <BindItem id="item3" compid="switch1.case_compare.grp_sea.ipt_srchwinacnt" propid="value" datasetid="ds_send" columnid="srchwinacnt"/>
- <BindItem id="item4" compid="switch1.case_compare.grp_sea.opt_srchwinacntnm" propid="value" datasetid="ds_send" columnid="srchwinacntnm"/>
- <BindItem id="item5" compid="switch1.case_compare.grp_sea.cmb_conflagnm" propid="value" datasetid="ds_send" columnid="conflagnm"/>
- <BindItem id="item6" compid="switch1.case_compare.grp_sea.ipt_suppcustcd" propid="value" datasetid="ds_send" columnid="suppcustcd"/>
- <BindItem id="item7" compid="switch1.case_compare.grp_sea.ipt_suppcustnm" propid="value" datasetid="ds_send" columnid="suppcustnm"/>
- <BindItem id="item8" compid="switch1.case_upload.group1.ipt_ubasedd" propid="value" datasetid="ds_send" columnid="ubasedd"/>
- <BindItem id="item9" compid="switch1.case_upload.group1.ipt_custnm" propid="value" datasetid="ds_send" columnid="ucustnm"/>
- <BindItem id="item10" compid="switch1.case_upload.group1.ipt_uentrregno" propid="value" datasetid="ds_send" columnid="uentrregno"/>
- <BindItem id="item11" compid="switch1.case_compare.grp_sea.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-06-19
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-06-19 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- include "mis_miscommonxp::MIS.xjs";
- include "mis_miscommonxp::RSZ001.xjs";
- function SMRSC08400_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SMRSC08400_onload(obj:Form, e:LoadEventInfo)
- {
- grdf_initGrid(switch1.case_compare.grd_keumcomparelst);
- grdf_setRowTypeIcon(switch1.case_compare.grd_keumcomparelst, 0);
- grdf_initGrid(switch1.case_upload.grd_upperlimitupload);
- grdf_setRowTypeIcon(switch1.case_upload.grd_upperlimitupload, 0);
-
- fGetScreenInit();
- var gDutplceinstcd = sysf_getUserInfo("dutplceinstcd");
-
- ds_send.setColumn(0, "instcd", gDutplceinstcd);
- }
- function fGetScreenInit()
- {
- misfGridInit(switch1.case_upload.grd_upperlimitupload);
- misfGridInit(switch1.case_compare.grd_keumcomparelst);
-
- ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
-
- var curdate = utlf_getCurrentDate();
- var cvtdate = curdate.toDate("YYYYMMDD");
-
- ds_send.setColumn(0, "srchbasedd", String(utlf_getCurrentDate()).substr(0,6));
-
- var basedd = ds_send.getColumn(0, "srchbasedd");
- ds_send.setColumn(0, "srchchkfrdd", basedd + "01");
-
- var dt = new Date(String(utlf_getCurrentDate()).substr(0, 4), String(utlf_getCurrentDate()).substr(4, 2), 0);
- switch1.case_compare.grp_sea.ipt_srchchktodd.value = String(utlf_getCurrentDate()).substr(0,6)+dt.getDate();
- var srchbasedd = ds_send.getColumn(0, "srchbasedd");
- ds_send.setColumn(0, "ubasedd", String(utlf_getCurrentDate()).substr(0,6));
- switch1.tabindex = 0;
- switch1.case_compare.grp_sea.cmb_conflagnm.index = 1;
- }
- function switch1_case_compare_grp_sea_ipt_srchbasedd_onchanged(obj:Calendar, e:ChangeEventInfo)
- {
- var basedd = String(obj.value).substr(0,6);
- ds_send.setColumn(0, "srchbasedd", basedd);
-
- var cvtdate = String(basedd).toDate("YYYYMM");
-
- ds_send.setColumn(0, "srchchkfrdd", basedd + "01");
- var tobasedd = cvtdate.getAddDate(1,"M").getDateFormat("YYYYMM");
- var dt = new Date(String(basedd).substr(0, 4), String(basedd).substr(4, 2), 0);
- ds_send.setColumn(0, "srchchktodd", String(basedd).substr(0,6) + dt.getDate());
- }
- function ds_send_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if( e.columnid == "ubasedd" ){
- obj.setColumn(e.row, e.columnid, (e.newvalue).substr(0, 6));
- }
- if(e.columnid == "srchwinacnt")
- {
- switch1.case_compare.grp_sea.ipt_srchwinacnt.value = e.newvalue;
- switch1.case_compare.grp_sea.ipt_srchwinacnt.setFocus();
-
- if(utlf_isNull(e.newvalue))
- {
- switch1.case_compare.grp_sea.opt_srchwinacntnm.value = "";
- }
- else
- {
- rszfValidationCheck("TRRAC00111", "acntlist", "acntflag,useyn,jobgb,srhtxt","1,,," + e.newvalue ,"","winacnt,winacntnm" ,switch1.case_compare.grp_sea.ipt_srchwinacnt,"PPRAC00100","","");
- }
- }
- if(e.columnid == "suppcustcd")
- {
- var objFocus = this.getFocus();
- switch1.case_compare.grp_sea.ipt_suppcustcd.setFocus();
- misfSearchCust(switch1.case_compare.grp_sea.ipt_suppcustnm,switch1.case_compare.grp_sea.cmb_instcd, "", ds_send.getColumn(0, "suppcustcd"));
- objFocus.setFocus();
- }
- }
- function switch1_case_compare_grp_sea_btn_srchwinacnt_onclick(obj:Button, e:ClickEventInfo)
- {
- rszfOpenPopUpListByWndName(switch1.case_compare.grp_sea.ipt_srchwinacnt,"","srchwinacnt,srchwinacntnm","PPRAC00100","","");
- }
- function switch1_case_compare_grp_sea_btn_regnohelp_onclick(obj:Button, e:ClickEventInfo)
- {
- var sinstcd = ds_send.getColumn(0, "instcd");
- rszfOpenPopUpListByWndName(switch1.case_compare.grp_sea.ipt_suppcustcd,"","suppcustcd,suppcustnm","SPRSD00220","instcd",sinstcd);
- }
- function switch1_case_compare_grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo)
- {
- var oParam = {};
- oParam.id = "TRRSC08404";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqGetTaxCmprLst";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_cmprlst_cmprinfo=cmprinfo";
- oParam.async = false;
- oParam.callback = "cf_TRRSC08404";
- tranf_submit(oParam);
-
- ds_main_cmprlst_cmprinfo.addColumn("colBack", "string");
-
- if( utlf_isNull(ds_main_cmprlst_cmprinfo.getColumnInfo("select")) ){
- ds_main_cmprlst_cmprinfo.addColumn("select", "string");
- }
-
- ds_main_cmprlst_cmprinfo.enableevent = false;
- ds_main_cmprlst_cmprinfo.updatecontrol = false;
- for(var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++)
- {
- var n1 = ds_main_cmprlst_cmprinfo.getColumn(i, "n1");
- var n2 = ds_main_cmprlst_cmprinfo.getColumn(i, "n2");
- var n3 = ds_main_cmprlst_cmprinfo.getColumn(i, "n3");
-
- var ttaxamt = ds_main_cmprlst_cmprinfo.getColumn(i, "ttaxamt");
- var ttaxamt2 = ds_main_cmprlst_cmprinfo.getColumn(i, "ttaxamt2");
- var sumamt3 = ds_main_cmprlst_cmprinfo.getColumn(i, "sumamt3");
-
- if(utlf_isNull(n1) && utlf_isNull(n2) && utlf_isNull(n3))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "#FFFFCC");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "ALL", "#FFFFCC", "B", i);
- }
- else
- {
- if((n1 == "Y" && !utlf_isNull(ttaxamt)) &&(utlf_isNull(n2) && ttaxamt2 == "0" ) &&(utlf_isNull(n3) && sumamt3 == "0"))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else if((utlf_isNull(n1) && ttaxamt == "0") &&(n2 == "Y" && !utlf_isNull(ttaxamt2)) &&(utlf_isNull(n3) && sumamt3 == "0" ))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else if((utlf_isNull(n1) && ttaxamt == "0") &&(utlf_isNull(n2) && ttaxamt2 == "0" ) &&(n3 == "Y"&& !utlf_isNull(sumamt3)))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else if((n1 == "Y" && !utlf_isNull(ttaxamt))&&(n2 == "Y" && !utlf_isNull(ttaxamt2))&&(utlf_isNull(n3) && sumamt3 == "0" ))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else if((n1 == "Y" && !utlf_isNull(ttaxamt)) &&(utlf_isNull(n2) && ttaxamt2 == "0" ) &&(n3 == "Y" && !utlf_isNull(sumamt3)))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else if((utlf_isNull(n1) && ttaxamt == "0") &&(n2 == "Y" && !utlf_isNull(ttaxamt2)) &&(n3 == "Y" && !utlf_isNull(sumamt3)))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else if((n1 == "Y" && !utlf_isNull(ttaxamt)) &&(n2 == "Y" && !utlf_isNull(ttaxamt2)) &&(n3 == "Y" && !utlf_isNull(sumamt3)))
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "white", "B", i);
- ds_main_cmprlst_cmprinfo.setColumn(i, "issueyn", "★");
- }
- else
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "#FFFFCC");
- //misfSetGridColor(switch1.case_compare.grd_keumcomparelst, "all", "#FFFFCC", "B", i);
- }
- }
- }
- ds_main_cmprlst_cmprinfo.updatecontrol = true;
- ds_main_cmprlst_cmprinfo.enableevent = true;
-
-
- var curdate = utlf_getCurrentDate();
- var cvtdate = curdate.toDate("YYYYMM");
- var tobasedd = cvtdate.getAddDate(-1,"M").getDateFormat("YYYYMM");
- var basedd = ds_send.getColumn(0, "srchbasedd");
- if((ds_main_cmprlst_cmprinfo.rowcount > 0) && (tobasedd == basedd))
- {
- for(var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++)
- {
- ds_main_cmprlst_cmprinfo.updatecontrol = false;
- ds_main_cmprlst_cmprinfo.setRowType(i, "i");
- ds_main_cmprlst_cmprinfo.updatecontrol = true;
- }
- updtdata = grdf_getGridUpdateData(switch1.case_compare.grd_keumcomparelst).rowcount;
-
- var oParam = {};
- oParam.id = "TXRSC08404";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqSCmprinfoInsert";
- oParam.inds = "cmprinfo=ds_main_cmprlst_cmprinfo:u";
- oParam.outds = "ds_=item";
- oParam.async = false;
- //oParam.callback = "cf_TXRSC08404";
- tranf_submit(oParam);
-
- for(var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++)
- {
- ds_main_cmprlst_cmprinfo.updatecontrol = false;
- ds_main_cmprlst_cmprinfo.setRowType(i, "1");
- ds_main_cmprlst_cmprinfo.updatecontrol = true;
- }
- }
- }
- function cf_TRRSC08404(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0)
- {
- return;
- }
- else
- {
- var lstCnt = ds_main_cmprlst_cmprinfo.rowcount;
- switch1.case_compare.caption3.text = "(건수:" + lstCnt + "건)"
- }
- }
- function ds_main_cmprlst_cmprinfo_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "select")
- {
- obj.setColumn(e.row, "select", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
-
- if(e.newvalue == 0)
- {
- obj.updatecontrol = false;
- obj.setRowType(e.row, "");
- obj.updatecontrol = true;
- }
- }
- }
- function switch1_case_compare_bol_selectall_onclick(obj:CheckBox, e:ClickEventInfo)
- {
- var row = ds_main_cmprlst_cmprinfo.rowcount;
- if( row > 0 )
- {
- if(obj.value == "true")
- {
- for( var i = 0; i < row; i++ )
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "select" , "Y");
- }
- }
- else
- {
- for( var i = 0; i < row; i++ )
- {
- ds_main_cmprlst_cmprinfo.setColumn(i, "select" , "N");
- }
- }
- }
- }
- function switch1_case_compare_button7_onclick(obj:Button, e:ClickEventInfo)
- {
- updtdata = grdf_getGridUpdateData(switch1.case_compare.grd_keumcomparelst).rowcount;
-
- if(updtdata == 0)
- {
- sysf_messageBox("저장할 데이터가 ","E014");
- return false;
- }
- else
- {
- var oParam = {};
- oParam.id = "TXRSC08403";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqSetCustUpdate";
- oParam.inds = "keumcomparelst=ds_main_cmprlst_cmprinfo:u";
- oParam.outds = "ds_=item";
- oParam.async = false;
- oParam.callback = "cf_TXRSC08403";
- tranf_submit(oParam);
- }
- }
- function cf_TXRSC08403(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0)
- {
- sysf_messageBox("저장","E009");
- return;
- }
- else
- {
- sysf_messageBox("저장이","I002");
- switch1.case_compare.grp_sea.btn_sea.click();
- }
- }
- function switch1_case_compare_btn_prta_onclick(obj:Button, e:ClickEventInfo)
- {
- ds_prtinfo_cmprlst.clearData();
-
- var totamtlist = "";
-
- for(var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++)
- {
- if(ds_main_cmprlst_cmprinfo.getColumn(i, "select") == "Y")
- {
- var ttaxamt = ds_main_cmprlst_cmprinfo.getColumn(i, "ttaxamt");
- var ttaxamt2 = ds_main_cmprlst_cmprinfo.getColumn(i, "ttaxamt2");
- var sumamt3 = ds_main_cmprlst_cmprinfo.getColumn(i, "sumamt3");
- var entrregno = ds_main_cmprlst_cmprinfo.getColumn(i, "entrregno");
- var purcchkdd = ds_main_cmprlst_cmprinfo.getColumn(i, "purcchkdd");
- var n1 = ds_main_cmprlst_cmprinfo.getColumn(i, "n1");
- var n2 = ds_main_cmprlst_cmprinfo.getColumn(i, "n2");
- var n3 = ds_main_cmprlst_cmprinfo.getColumn(i, "n3");
-
- var temp = "";
- var tamt = "";
-
- if(!utlf_isNull(n1) && !utlf_isNull(n2) && !utlf_isNull(n3))
- {
- temp = "7";
- }
- else if(!utlf_isNull(n1) && !utlf_isNull(n2) && utlf_isNull(n3))
- {
- temp="6";
- }
- else if(!utlf_isNull(n1) && utlf_isNull(n2) && !utlf_isNull(n3))
- {
- temp="5";
- }
- else if(utlf_isNull(n1) && !utlf_isNull(n2) && !utlf_isNull(n3))
- {
- temp="4";
- }
- else if(!utlf_isNull(n1) && utlf_isNull(n2) && utlf_isNull(n3))
- {
- temp="3";
- }
- else if(utlf_isNull(n1) && !utlf_isNull(n2) && utlf_isNull(n3))
- {
- temp="2";
- }
- else if(utlf_isNull(n1) && utlf_isNull(n2) && !utlf_isNull(n3))
- {
- temp="1";
- }
- else
- {
- temp ="0";
- }
-
- if(temp == "7")
- {
- tamt = "'" + ttaxamt+ "','" + ttaxamt2+ "','" +sumamt3 + "'" ;
- }
- else if(temp == "6")
- {
- tamt = "'" + ttaxamt+ "','" + ttaxamt2 + "'";
- }
- else if(temp == "5")
- {
- tamt = "'" + ttaxamt+ "','" + sumamt3 + "'";
- }
- else if(temp == "4")
- {
- tamt = "'" + ttaxamt2+ "','" + sumamt3 + "'";
- }
- else if(temp == "3")
- {
- tamt = "'" + ttaxamt + "'";
- }
- else if(temp == "2")
- {
- tamt = "'" + ttaxamt2 + "'";
- }
- else if(temp == "1")
- {
- tamt = "'" + sumamt3 + "'" ;
- }
-
- ds_main_cmprlst_cmprinfo.setColumn(i, "tamt", tamt);
-
- ds_send.setColumn(0, "totamt", tamt);
- ds_send.setColumn(0, "entrregno", entrregno);
- ds_send.setColumn(0, "acptdd", purcchkdd);
-
- var oParam = {};
- oParam.id = "TRRSC08405";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqGetPrtTaxLst";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_prtinfo_cmprlst=cmprinfo";
- oParam.async = false;
- //oParam.callback = "cf_TRRSC08405";
- tranf_submit(oParam);
- var objDOM = rptf_createDOM();
- rptf_setNodeListToDOM(objDOM, "/root/prtinfo/cmprlst/cmprinfo", ds_prtinfo_cmprlst);
- var objParam = new Object();
- objParam.xml_data_XML1 = objDOM.documentElement.source;
- var option = "";
- rptf_exeReportPreview30(["RPRSD08401"],[objParam], option);
- }
- }
- }
- function switch1_case_compare_grp_sea_btn_save_onclick(obj:Button, e:ClickEventInfo)
- {
- updtdata = grdf_getGridUpdateData(switch1.case_compare.grd_keumcomparelst).rowcount;
-
- if(updtdata == 0)
- {
- sysf_messageBox("저장할 데이터가 ","E014");
- return false;
- }
- else
- {
- var oParam = {};
- oParam.id = "TXRSC08403";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqSetCustUpdate";
- oParam.inds = "keumcomparelst=ds_main_cmprlst_cmprinfo:u";
- oParam.outds = "ds_=item";
- oParam.async = false;
- oParam.callback = "cf_TXRSC08403";
- tranf_submit(oParam);
- }
- }
- function switch1_case_compare_button5_onclick(obj:Button, e:ClickEventInfo)
- {
- if( ds_main_cmprlst_cmprinfo.rowcount > 0)
- {
- grdf_exportExcel(switch1.case_compare.grd_keumcomparelst, "세금계산서 비교 리스트_" + utlf_getCurrentDate(), "Sheet", "true", "", "");
- }
- else
- {
- sysf_messageBox("저장 데이터가","I004");
- }
- }
- function switch1_case_upload_group1_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- switch1.case_upload.caption4.text = "";
- var ubasedd = ds_send.getColumn(0, "ubasedd");
-
- ds_send.setColumn(0, "ufromdd", ubasedd +"01");
- ds_send.setColumn(0, "utodd", ubasedd +"31");
-
- var oParam = {};
- oParam.id = "TRRSC08401";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqGetTaxLst";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_upperlimitlst_upperlimitinfo=upperlimitinfo";
- oParam.async = false;
- oParam.callback = "cf_TRRSC08401";
- tranf_submit(oParam);
-
- ds_main_upperlimitlst_upperlimitinfo.addColumn("colBack", "string");
-
- ds_copynode.clearData();
- frmf_clearParameter("SMRSD00400_");
-
- ds_main_upperlimitlst_upperlimitinfo.enableevent = false;
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
-
- for(var i = 0; i < ds_main_upperlimitlst_upperlimitinfo.rowcount; i++)
- {
- var flag = ds_main_upperlimitlst_upperlimitinfo.getColumn(i, "flag");
- if(flag == "제외")
- {
- ds_main_upperlimitlst_upperlimitinfo.setColumn(i, "colBack", "#fec3c3");
- //misfSetGridColor(switch1.case_upload.grd_upperlimitupload, "all", "#fec3c3", "B", i);
- }
- else
- {
- ds_main_upperlimitlst_upperlimitinfo.setColumn(i, "colBack", "white");
- //misfSetGridColor(switch1.case_upload.grd_upperlimitupload, "all", "white", "B", i);
- }
- }
-
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- ds_main_upperlimitlst_upperlimitinfo.enableevent = true;
- }
- function cf_TRRSC08401(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0) return;
- else
- {
- var lstCnt = ds_main_upperlimitlst_upperlimitinfo.rowcount;
-
- if( lstCnt > 0 )
- {
- switch1.case_upload.caption4.text = "(건수:" + lstCnt + "건)";
- }
- }
- }
- function switch1_case_upload_group1_button3_onclick(obj:Button, e:ClickEventInfo)
- {
- if(grdf_getGridUpdateData(switch1.case_upload.grd_upperlimitupload).rowcount != 0)
- {
- var oParam = {};
- oParam.id = "TXRSC08402";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqSetTaxDelete";
- oParam.inds = "upperlimitinfo=ds_main_upperlimitlst_upperlimitinfo:u";
- oParam.outds = "ds_=item";
- oParam.async = false;
- oParam.callback = "cf_TXRSC08402";
- tranf_submit(oParam);
- }
-
- ds_copynode.clearData();
- frmf_clearParameter("SMRSD00400_");
- }
- function cf_TXRSC08402(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0) return;
- else
- {
- switch1.case_upload.group1.btn_search.click();
- sysf_messageBox(" ", "I001", "");
- }
- }
- function switch1_case_upload_btn_upchk_onclick(obj:Button, e:ClickEventInfo)
- {
- ds_copynode.clearData();
- frmf_clearParameter("SMRSD00400_");
- frmf_setParameter("para_ubasedd" , switch1.case_upload.group1.ipt_ubasedd.value);
- var objArg = new Object();
- objArg.arg_ds_init = ds_send;
- frmf_modal("SPRSD08401", "SPRSD08401", objArg, "", "", "", "", "", "", "", "", "", "M");
- var acptdd = ds_copynode.getColumn(0, "para_acptdd");
- var entrregno = ds_copynode.getColumn(0, "para_entrregno");
- var totamt = ds_copynode.getColumn(0, "para_totamt");
-
-
- ds_send.setColumn(0, "acptdd", acptdd);
- ds_send.setColumn(0, "entrregno", entrregno);
- ds_send.setColumn(0, "totamt", totamt);
-
- var oParam = {};
- oParam.id = "TRRSC08403";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqGetOverTaxLst";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_upperlimitlst_upperlimitinfo=upperlimitinfo";
- oParam.async = false;
- //oParam.callback = "cf_TRRSC08403";
- tranf_submit(oParam);
- }
- function switch1_case_upload_button8_onclick(obj:Button, e:ClickEventInfo)
- {
- if( ds_main_upperlimitlst_upperlimitinfo.rowcount > 0)
- {
- grdf_exportExcel(switch1.case_upload.grd_upperlimitupload, "세금계산서 내역 업로드_" + utlf_getCurrentDate(), "Sheet", "true", "", "");
- }
- else
- {
- sysf_messageBox("저장 데이터가","I004");
- }
- }
- function switch1_case_upload_button4_onclick(obj:Button, e:ClickEventInfo)
- {
- for ( var i = 0; i < ds_main_upperlimitlst_upperlimitinfo.rowcount; i++)
- {
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
- ds_main_upperlimitlst_upperlimitinfo.setRowType(i, "d");
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- }
- }
- function switch1_case_upload_button1_onclick(obj:Button, e:ClickEventInfo)
- {
- ds_main_upperlimitlst_upperlimitinfo.clearData();
-
- grdf_ImportExcel("ds_main_upperlimitlst_upperlimitinfo ", 2, switch1.case_upload.grd_upperlimitupload, 0);
-
- for (var i = 0; i < ds_main_upperlimitlst_upperlimitinfo.rowcount; i++)
- {
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
- ds_main_upperlimitlst_upperlimitinfo.setRowType(i, "i");
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- }
-
- var lstCnt = ds_main_upperlimitlst_upperlimitinfo.rowcount;
- if( lstCnt > 0 )
- {
- var oParam = {};
- oParam.id = "TXRSC08401";
- oParam.service = "purcbaseapp.PurcBaseMngt";
- oParam.method = "reqSetTaxInsert";
- oParam.inds = "sdata=ds_main_upperlimitlst_upperlimitinfo:u";
- oParam.outds = "ds_=item";
- oParam.async = false;
- oParam.callback = "cf_TXRSC08401";
- tranf_submit(oParam);
- }
- }
- function cf_TXRSC08401(sSvcId, nErrorCode, sErrorMsg)
- {
- if(nErrorCode < 0) return;
- else
- {
- switch1.case_upload.group1.btn_search.click();
- sysf_messageBox("업로드되었습니다.", "I000");
- switch1.case_upload.caption4.text = "(건수:" + lstCnt + "건)";
- }
- }
- function switch1_case_upload_grd_upperlimitupload_oncellclick(obj:Grid, e:GridClickEventInfo)
- {
- // var rows = grdf_getSelectedRows(switch1.case_upload.grd_upperlimitupload);
- //
- // for(var i = 0; i < rows.length; i++)
- // {
- // var m_row = rows[i];
- //
- // ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
- // ds_main_upperlimitlst_upperlimitinfo.setRowType(m_row, "");
- // ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- //
- // var flag = ds_copynode.getColumn(0, "para_flag");
- // if(flag == "F")
- // {
- // ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
- // ds_main_upperlimitlst_upperlimitinfo.setRowType(m_row, "u");
- // ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- // }
- // else
- // {
- // ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
- // ds_main_upperlimitlst_upperlimitinfo.setRowType(m_row, "d");
- // ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- // }
- // }
- }
- function switch1_case_compare_grp_sea_ipt_suppcustcd_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if( e.keycode == 13 ){
- obj.updateToDataset();
- }
- }
- function switch1_case_compare_grd_keumcomparelst_onlbuttonup(obj:Grid, e:GridMouseEventInfo)
- {
- ds_main_cmprlst_cmprinfo.enableevent = false;
- ds_main_cmprlst_cmprinfo.updatecontrol = false;
-
- for( var i=0 ; i<ds_main_cmprlst_cmprinfo.rowcount ; i++ ){
- ds_main_cmprlst_cmprinfo.setColumn(i, "select", "N");
- ds_main_cmprlst_cmprinfo.setRowType(i, 1);
- }
-
- for( var i=0 ; i<switch1.case_compare.grd_keumcomparelst.selectcount ; i++ ){
- for( var j=switch1.case_compare.grd_keumcomparelst.selectstartrow[i] ; j<=switch1.case_compare.grd_keumcomparelst.selectendrow[i] ; j++ ){
- ds_main_cmprlst_cmprinfo.setColumn(j, "select", "Y");
- ds_main_cmprlst_cmprinfo.setRowType(j, 4);
- }
- }
- ds_main_cmprlst_cmprinfo.updatecontrol = true;
- ds_main_cmprlst_cmprinfo.enableevent = true;
- }
- function switch1_case_upload_grd_upperlimitupload_onlbuttonup(obj:Grid, e:GridMouseEventInfo)
- {
- ds_main_upperlimitlst_upperlimitinfo.enableevent = false;
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
-
- for( var i=0 ; i<ds_main_upperlimitlst_upperlimitinfo.rowcount ; i++ ){
- ds_main_upperlimitlst_upperlimitinfo.setRowType(i, 1);
- }
-
- var flag = ds_copynode.getColumn(0, "para_flag");
-
- for( var i=0 ; i<switch1.case_upload.grd_upperlimitupload.selectcount ; i++ ){
- for( var j=switch1.case_upload.grd_upperlimitupload.selectstartrow[i] ; j<=switch1.case_upload.grd_upperlimitupload.selectendrow[i] ; j++ ){
- if( flag == "F" ){
- ds_main_upperlimitlst_upperlimitinfo.setRowType(j, 4);
- }else{
- ds_main_upperlimitlst_upperlimitinfo.setRowType(j, 8);
- }
- }
- }
-
- ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
- ds_main_upperlimitlst_upperlimitinfo.enableevent = true;
- }
- ]]></Script>
- </Form>
- </FDL>
|