123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278 |
- <?xml version="1.0" encoding="utf-8" standalone="no"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMRAD01400" position="absolute 0 0 1280 777" titletext="전표자동분개" onload="SMRAD01400_onload">
- <Layouts>
- <Layout>
- <Div id="group1" position="absolute 0 0 1195 21" style="" scrollbars="none">
- <Layouts>
- <Layout>
- <Static id="caption6" class="tit_1" position="absolute 0 0 145 22" style="" text="전표자동분개" anchor="default"/>
- <Static id="caption4" class="patient_text_black" position="absolute 922 0 1194 200" style="" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- <Div id="group3" scrollbars="autoboth" position="absolute 0 15 1195 750" style="">
- <Layouts>
- <Layout>
- <Div id="grp_sea" position="absolute 0 33 1195 97" style="align: top;">
- <Layouts>
- <Layout>
- <Shape id="roundrect1" anchor="default" type="roundrectangle" position="absolute 0 0 1195 64" style="border:1 solid #ffd799 #ffd799;background:#fffbf2 ;"/>
- <Static id="caption7" class="search_name" position="absolute 16 11 141 28" style="" text="전표구분 :"/>
- <Button id="btn_search" class="btn1" taborder="4" position="absolute 1130 8 1186 30" style="align:left ;" text="조회" onclick="group3_grp_sea_btn_search_onclick"/>
- <Static id="caption1" class="search_name" position="absolute 375 11 464 28" style="" text="발의일자 :"/>
- <Calendar id="input2" class="input_s_essential" position="absolute 465 10 570 29" style="" anchor="default" autoselect="true"/>
- <Combo innerdataset="ds_init_R0008list_R0008" datacolumn="cdnm" codecolumn="cdid" columncount="-1" rowcount="-1" id="cmb_slipflag" class="combo_default" position="absolute 105 10 320 29" style=""/>
- <Shape id="line1" class="line_4" linetype="vertical" position="absolute 1105 8 1108 30" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
- <Edit id="ipt_deptnm" class="input_s_essential" taborder="10" position="absolute 850 10 995 29" style="" anchor="default"/>
- <Button id="btn_deptcd" class="icon_search" taborder="9" position="absolute 830 10 846 26" style="" text="" onclick="group3_grp_sea_btn_deptcd_onclick"/>
- <Edit id="ipt_deptcd" class="input_s_essential" taborder="8" position="absolute 730 10 825 29" style="" anchor="default"/>
- <Static id="caption5" class="search_name" position="absolute 630 11 720 28" style="" text="발의부서 :"/>
- <Combo datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="cmb_slipendyn" class="combo_default" position="absolute 465 36 570 55" style="">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </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">2</Col>
- <Col id="datacolumn">분개후</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Static id="caption2" class="search_name" position="absolute 375 37 500 54" style="" text="분개구분 :"/>
- <Combo innerdataset="" datacolumn="" codecolumn="" columncount="-1" rowcount="-1" id="cmb_slipkind" class="combo_default" position="absolute 105 35 320 54" style=""/>
- <Static id="caption3" class="search_name" position="absolute 16 36 141 53" style="" text="전표유형 :"/>
- </Layout>
- </Layouts>
- </Div>
- <Shape id="line3" class="line_1" linetype="horizontal" position="absolute 0 125 1195 128" style="" anchor="default"/>
- <Static id="caption21" class="tit_2" position="absolute 3 107 134 128" style="" text="전표 자동분개"/>
- <Grid id="grd_autosliplist" binddataset="ds_main_list_detailist" position="absolute 0 130 1195 734" style="" onlbuttonup="group3_grd_autosliplist_onlbuttonup" oncelldblclick="group3_grd_autosliplist_oncelldblclick" cellsizingtype="col">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="23"/>
- <Column size="62"/>
- <Column size="50"/>
- <Column size="50"/>
- <Column size="72"/>
- <Column size="77"/>
- <Column size="68"/>
- <Column size="58"/>
- <Column size="108"/>
- <Column size="60"/>
- <Column size="58"/>
- <Column size="74"/>
- <Column size="77"/>
- <Column size="90"/>
- <Column size="79"/>
- <Column size="66"/>
- <Column size="88"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="83"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="120"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell text="기관코드"/>
- <Cell col="1" rowspan="2" taborder="undefined"/>
- <Cell col="2" rowspan="2" text="순번" taborder="undefined"/>
- <Cell col="3" rowspan="2" text="전표구분번호" wordwrap="char" taborder="undefined"/>
- <Cell col="4" rowspan="2" text="작업구분" taborder="undefined"/>
- <Cell col="5" rowspan="2" text="발의일자" taborder="undefined"/>
- <Cell col="6" colspan="3" text="미결" taborder="undefined"/>
- <Cell col="9" rowspan="2" text="전표구분" taborder="undefined"/>
- <Cell col="10" rowspan="2" text="전표유형" taborder="undefined"/>
- <Cell col="11" rowspan="2" text="차대구분" taborder="undefined"/>
- <Cell col="12" rowspan="2" text="계정코드" taborder="undefined"/>
- <Cell col="13" rowspan="2" text="계정명" taborder="undefined"/>
- <Cell col="14" rowspan="2" text="상대계정코드" taborder="undefined"/>
- <Cell col="15" rowspan="2" text="상대계정명" taborder="undefined"/>
- <Cell col="16" rowspan="2" text="귀속부서" taborder="undefined"/>
- <Cell col="17" rowspan="2" text="귀속부서명" taborder="undefined"/>
- <Cell col="18" rowspan="2" text="기표부서" taborder="undefined"/>
- <Cell col="19" rowspan="2" text="기표부서명" taborder="undefined"/>
- <Cell col="20" rowspan="2" text="입출금예정일" taborder="undefined"/>
- <Cell col="21" rowspan="2" text="전표적요" taborder="undefined"/>
- <Cell col="22" rowspan="2" text="상대처구분" taborder="undefined"/>
- <Cell col="23" rowspan="2" text="상대처코드" taborder="undefined"/>
- <Cell col="24" rowspan="2" text="상대처명" taborder="undefined"/>
- <Cell col="25" rowspan="2" text="기재사항제목1" taborder="undefined"/>
- <Cell col="26" rowspan="2" text="기재사항코드1" taborder="undefined"/>
- <Cell col="27" rowspan="2" text="기재사항내역1" taborder="undefined"/>
- <Cell col="28" rowspan="2" text="기재사항제목2" taborder="undefined"/>
- <Cell col="29" rowspan="2" text="기재사항코드2" taborder="undefined"/>
- <Cell col="30" rowspan="2" text="기재사항내역2" taborder="undefined"/>
- <Cell col="31" rowspan="2" text="기타기재사항" taborder="undefined"/>
- <Cell col="32" rowspan="2" text="프로젝트ID" taborder="undefined"/>
- <Cell col="33" rowspan="2" text="합계금액" taborder="undefined"/>
- <Cell col="34" rowspan="2" text="공급가액" taborder="undefined"/>
- <Cell col="35" rowspan="2" text="부가가치세" taborder="undefined"/>
- <Cell col="36" rowspan="2" text="증빙구분" taborder="undefined"/>
- <Cell col="37" rowspan="2" text="사용일자" taborder="undefined"/>
- <Cell col="38" rowspan="2" text="거래처" taborder="undefined"/>
- <Cell col="39" rowspan="2" text="거래처명" taborder="undefined"/>
- <Cell col="40" rowspan="2" text="거래처주소" taborder="undefined"/>
- <Cell col="41" rowspan="2" text="거래처대표자" taborder="undefined"/>
- <Cell col="42" rowspan="2" text="거래처 업태" taborder="undefined"/>
- <Cell col="43" rowspan="2" text="거래처 종목" taborder="undefined"/>
- <Cell col="44" rowspan="2" text="전화번호" taborder="undefined"/>
- <Cell col="45" rowspan="2" text="증빙적요" taborder="undefined"/>
- <Cell col="46" rowspan="2" text="법인카드번호" taborder="undefined"/>
- <Cell col="47" rowspan="2" text="카드사코드" taborder="undefined"/>
- <Cell col="48" rowspan="2" text="사용자" taborder="undefined"/>
- <Cell col="49" rowspan="2" text="소유부서" taborder="undefined"/>
- <Cell col="50" rowspan="2" text="소유부서명" taborder="undefined"/>
- <Cell col="51" rowspan="2" text="고정자산매입구분" taborder="undefined"/>
- <Cell col="52" rowspan="2" text="매입매출구분" taborder="undefined"/>
- <Cell col="53" rowspan="2" text="과세구분" taborder="undefined"/>
- <Cell col="54" rowspan="2" text="처리일자" taborder="undefined"/>
- <Cell col="55" text="기관코드"/>
- <Cell col="56" text="순번"/>
- <Cell col="57" text="전표구분번호"/>
- <Cell col="58" text="작업 구분"/>
- <Cell col="59" text="발의일자"/>
- <Cell col="60" text="전표일자"/>
- <Cell col="61" text="전표번호"/>
- <Cell col="62" text="일련번호"/>
- <Cell col="63" text="전표구분"/>
- <Cell col="64" text="전표유형"/>
- <Cell col="65" text="차대구분"/>
- <Cell col="66" text="계정코드"/>
- <Cell col="67" text="계정명"/>
- <Cell col="68" text="상대계정코드"/>
- <Cell col="69" text="상대계정명"/>
- <Cell col="70" text="귀속부서"/>
- <Cell col="71" text="귀속부서명"/>
- <Cell col="72" text="기표부서"/>
- <Cell col="73" text="기표부서명"/>
- <Cell col="74" text="입출금예정일"/>
- <Cell col="75" text="전표적요"/>
- <Cell col="76" text="상대처구분"/>
- <Cell col="77" text="상대처코드"/>
- <Cell col="78" text="상대처명"/>
- <Cell col="79" text="기재사항제목1"/>
- <Cell col="80" text="기재사항코드1"/>
- <Cell col="81" text="기재사항내역1"/>
- <Cell col="82" text="기재사항제목2"/>
- <Cell col="83" text="기재사항코드2"/>
- <Cell col="84" text="기재사항내역2"/>
- <Cell col="85" text="기타기재사항"/>
- <Cell col="86" text="프로젝트ID"/>
- <Cell col="87" text="합계금액"/>
- <Cell col="88" text="공급가액"/>
- <Cell col="89" text="부가가치세"/>
- <Cell col="90" text="증빙구분"/>
- <Cell col="91" text="사용일자"/>
- <Cell col="92" text="거래처"/>
- <Cell col="93" text="거래처명"/>
- <Cell col="94" text="거래처주소"/>
- <Cell col="95" text="거래처대표자"/>
- <Cell col="96" text="거래처 업태"/>
- <Cell col="97" text="거래처 종목"/>
- <Cell col="98" text="전화번호"/>
- <Cell col="99" text="증빙적요"/>
- <Cell col="100" text="법인카드번호"/>
- <Cell col="101" text="카드사코드"/>
- <Cell col="102" text="사용자"/>
- <Cell col="103" text="소유부서"/>
- <Cell col="104" text="소유부서명"/>
- <Cell col="105" text="고정자산매입구분"/>
- <Cell col="106" text="매입매출구분"/>
- <Cell col="107" text="과세구분"/>
- <Cell col="108" text="처리일자"/>
- <Cell row="1" text="기관코드"/>
- <Cell row="1" col="6" text="전표일자"/>
- <Cell row="1" col="7" text="전표번호"/>
- <Cell row="1" col="8" text="일련번호"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" celltype="head"/>
- <Cell col="2" displaytype="text" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="expr:getRowLevel(currow) == 1 ? '' : seqno"/>
- <Cell col="3" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:slipseqno"/>
- <Cell col="4" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:workflag"/>
- <Cell col="5" displaytype="date" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:genrdd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
- <Cell col="6" displaytype="date" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:unsldd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
- <Cell col="7" displaytype="combo" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:unslno" combodataset="ds_display_slipkind"/>
- <Cell col="8" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:unslseqno"/>
- <Cell col="9" displaytype="combo" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:slipflag" combodataset="ds_display_slipflag" combocodecol="cdid" combodatacol="cdnm"/>
- <Cell col="10" displaytype="combo" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:slipkind" combodataset="ds_display_slipkind" combocodecol="cd" combodatacol="nm"/>
- <Cell col="11" displaytype="combo" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:drcrflag" combodataset="ds_display_dcrflag" combocodecol="cd" combodatacol="nm"/>
- <Cell col="12" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:acntcd"/>
- <Cell col="13" style="align:left top;background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:acntnm" wordwrap="char"/>
- <Cell col="14" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:rlaacntcd"/>
- <Cell col="15" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:rlaacntnm"/>
- <Cell col="16" style="align:left middle;background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:costcntrdeptcd"/>
- <Cell col="17" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:costcntrdeptnm"/>
- <Cell col="18" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:slipdeptcd"/>
- <Cell col="19" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:slipdeptnm"/>
- <Cell col="20" displaytype="date" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:defrayreqdd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
- <Cell col="21" style="align:left top;background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:slipcmt" wordwrap="char"/>
- <Cell col="22" displaytype="combo" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:rlaflag" combodataset="ds_display_custflag" combocodecol="cd" combodatacol="nm"/>
- <Cell col="23" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:rlacd"/>
- <Cell col="24" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:rlanm"/>
- <Cell col="25" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:notefactnm1"/>
- <Cell col="26" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:notefactcd1"/>
- <Cell col="27" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:notefactspec1"/>
- <Cell col="28" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:notefactnm2"/>
- <Cell col="29" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:notefactcd2"/>
- <Cell col="30" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="expr:getRowLevel(currow) == 1 ? '차대소계' : notefactspec2"/>
- <Cell col="31" style="align:left top;background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:etcnotefact" wordwrap="char"/>
- <Cell col="32" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:projectid"/>
- <Cell col="33" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');font:EXPR(getRowLevel(currow) == 1 ? 'arial,9,bold' : '');" text="bind:amt"/>
- <Cell col="34" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:suplamt"/>
- <Cell col="35" displaytype="number" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:valaddtax"/>
- <Cell col="36" displaytype="combo" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:profflag" combodataset="ds_display_profflag" combocodecol="cd" combodatacol="nm"/>
- <Cell col="37" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:usedd"/>
- <Cell col="38" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:entrregno"/>
- <Cell col="39" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:custnm"/>
- <Cell col="40" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:custaddr"/>
- <Cell col="41" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:custprsd"/>
- <Cell col="42" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:custbizcond"/>
- <Cell col="43" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:custitem"/>
- <Cell col="44" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:cntctel"/>
- <Cell col="45" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:mainrec"/>
- <Cell col="46" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:instcardseqno"/>
- <Cell col="47" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:cardcmpycd"/>
- <Cell col="48" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:posspsn"/>
- <Cell col="49" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:possdeptcd"/>
- <Cell col="50" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:possdeptnm"/>
- <Cell col="51" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:fixasetflag"/>
- <Cell col="52" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:taxbillflag"/>
- <Cell col="53" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:taxkind"/>
- <Cell col="54" displaytype="date" style="background:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');background2:EXPR(getRowLevel(currow) == 1 ? '#ccffff' : '');" text="bind:prcdd" mask="yyyy-MM-dd" calendardisplaynulltype="nulltext"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="btn_delrow" class="btn2" taborder="9" position="absolute 1139 102 1192 121" style="align:left ;" text="행삭제" onclick="group3_btn_delrow_onclick"/>
- <Button id="btn_addrow" class="btn2" taborder="8" visible="false" position="absolute 940 102 993 121" style="align:left ;" text="행추가" onclick="group3_btn_addrow_onclick"/>
- <Button id="btn_autotr" class="btn4" taborder="23" position="absolute 1130 3 1186 25" style="" text="분개" onclick="group3_btn_autotr_onclick"/>
- <CheckBox text="모든 일자 자동분개" truevalue="A" falsevalue="" datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="checkbox1" enable="false" visible="false" position="absolute 920 5 1055 25" style="">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">A</Col>
- <Col id="datacolumn">모든 일자 자동분개</Col>
- </Row>
- </Rows>
- </Dataset>
- </CheckBox>
- <Button id="btn_save" class="btn4" taborder="23" visible="true" position="absolute 1070 3 1126 25" style="" text="저장" onclick="group3_btn_save_onclick"/>
- <Button id="btn_5" class="btn2" position="absolute 1070 102 1134 121" style="align:left ;" text="엑셀출력" onclick="group3_btn_5_onclick"/>
- </Layout>
- </Layouts>
- </Div>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_source" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="slipinfo" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_save" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="detailist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="detailist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="slipflag" type="STRING" size="256"/>
- <Column id="genrdd" type="STRING" size="256"/>
- <Column id="alldate" type="STRING" size="256"/>
- <Column id="deptcd" type="STRING" size="256"/>
- <Column id="deptnm" type="STRING" size="256"/>
- <Column id="slipkind" type="STRING" size="256"/>
- <Column id="slipendyn" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="slipflag">1</Col>
- <Col id="genrdd"/>
- <Col id="alldate"/>
- <Col id="deptcd"/>
- <Col id="deptnm"/>
- <Col id="slipkind"/>
- <Col id="slipendyn">1</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_display" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="detailist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="detailist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_display_slipkind" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="cd">1</Col>
- <Col id="nm">대체</Col>
- </Row>
- <Row>
- <Col id="cd">2</Col>
- <Col id="nm">입금</Col>
- </Row>
- <Row>
- <Col id="cd">3</Col>
- <Col id="nm">출금</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_display_profflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="nm">법인카드</Col>
- <Col id="cd">1</Col>
- </Row>
- <Row>
- <Col id="nm">개인신용카드</Col>
- <Col id="cd">2</Col>
- </Row>
- <Row>
- <Col id="nm">현금영수증</Col>
- <Col id="cd">3</Col>
- </Row>
- <Row>
- <Col id="nm">세금계산서</Col>
- <Col id="cd">4</Col>
- </Row>
- <Row>
- <Col id="nm">계산서</Col>
- <Col id="cd">5</Col>
- </Row>
- <Row>
- <Col id="nm">기타</Col>
- <Col id="cd">6</Col>
- </Row>
- <Row>
- <Col id="nm">근로소득</Col>
- <Col id="cd">7</Col>
- </Row>
- <Row>
- <Col id="nm">비과세근로소득</Col>
- <Col id="cd">8</Col>
- </Row>
- <Row>
- <Col id="nm">퇴직소득</Col>
- <Col id="cd">9</Col>
- </Row>
- <Row>
- <Col id="nm">일용근로소득</Col>
- <Col id="cd">A</Col>
- </Row>
- <Row>
- <Col id="nm">사업소득</Col>
- <Col id="cd">B</Col>
- </Row>
- <Row>
- <Col id="nm">기타소득</Col>
- <Col id="cd">C</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_R0008list_R0008" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="cdnm"/>
- <Col id="cdid"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_display_bankflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="nm"/>
- <Col id="cd"/>
- </Row>
- <Row>
- <Col id="nm">국민카드</Col>
- <Col id="cd">01</Col>
- </Row>
- <Row>
- <Col id="nm">롯데카드</Col>
- <Col id="cd">02</Col>
- </Row>
- <Row>
- <Col id="nm">비씨카드</Col>
- <Col id="cd">03</Col>
- </Row>
- <Row>
- <Col id="nm">삼성카드</Col>
- <Col id="cd">04</Col>
- </Row>
- <Row>
- <Col id="nm">신한카드</Col>
- <Col id="cd">05</Col>
- </Row>
- <Row>
- <Col id="nm">씨티카드</Col>
- <Col id="cd">06</Col>
- </Row>
- <Row>
- <Col id="nm">엘지카드</Col>
- <Col id="cd">07</Col>
- </Row>
- <Row>
- <Col id="nm">외환카드</Col>
- <Col id="cd">08</Col>
- </Row>
- <Row>
- <Col id="nm">우리카드</Col>
- <Col id="cd">09</Col>
- </Row>
- <Row>
- <Col id="nm">조흥카드</Col>
- <Col id="cd">10</Col>
- </Row>
- <Row>
- <Col id="nm">현대카드</Col>
- <Col id="cd">11</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_R0008list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_display_custflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="nm">거래처</Col>
- <Col id="cd">1</Col>
- </Row>
- <Row>
- <Col id="nm">부서</Col>
- <Col id="cd">3</Col>
- </Row>
- <Row>
- <Col id="nm">교직원</Col>
- <Col id="cd">4</Col>
- </Row>
- <Row>
- <Col id="nm">개인</Col>
- <Col id="cd">5</Col>
- </Row>
- <Row>
- <Col id="nm">기타</Col>
- <Col id="cd">9</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_display_fixasetflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="nm">일반매입매출</Col>
- <Col id="cd">00</Col>
- </Row>
- <Row>
- <Col id="nm">건·구축물</Col>
- <Col id="cd">01</Col>
- </Row>
- <Row>
- <Col id="nm">기계장치</Col>
- <Col id="cd">02</Col>
- </Row>
- <Row>
- <Col id="nm">차량운반구</Col>
- <Col id="cd">03</Col>
- </Row>
- <Row>
- <Col id="nm">기타감가상각물</Col>
- <Col id="cd">04</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_display_dcrflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- <Column id="nm" type="STRING" size="256"/>
- <Column id="cd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="nm">차변</Col>
- <Col id="cd">D</Col>
- </Row>
- <Row>
- <Col id="nm">대변</Col>
- <Col id="cd">C</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_code" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="codelist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codelist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_display_slipflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- <Column id="cdnm" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="cdnm">전체</Col>
- <Col id="cdid">A</Col>
- </Row>
- <Row>
- <Col id="cdnm">일반전표</Col>
- <Col id="cdid">1</Col>
- </Row>
- <Row>
- <Col id="cdid">2</Col>
- <Col id="cdnm">입원수익전표</Col>
- </Row>
- <Row>
- <Col id="cdid">3</Col>
- <Col id="cdnm">외래수익전표</Col>
- </Row>
- <Row>
- <Col id="cdid">4</Col>
- <Col id="cdnm">건진수익전표</Col>
- </Row>
- <Row>
- <Col id="cdid">5</Col>
- <Col id="cdnm">급여전표</Col>
- </Row>
- <Row>
- <Col id="cdid">6</Col>
- <Col id="cdnm">물류전표(입고)</Col>
- </Row>
- <Row>
- <Col id="cdid">7</Col>
- <Col id="cdnm">물류전표(출고)</Col>
- </Row>
- <Row>
- <Col id="cdid">8</Col>
- <Col id="cdnm">감가상각전표</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="temp" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="temp"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send_data" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="mngtcd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="mngtcd"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_code_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_notelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_list_detailist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_source_slipinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group3.grp_sea.input2" propid="value" datasetid="ds_main_condition" columnid="genrdd"/>
- <BindItem id="item1" compid="group3.grp_sea.cmb_slipflag" propid="value" datasetid="ds_main_condition" columnid="slipflag"/>
- <BindItem id="item2" compid="group3.grp_sea.ipt_deptnm" propid="value" datasetid="ds_main_condition" columnid="deptnm"/>
- <BindItem id="item3" compid="group3.grp_sea.ipt_deptcd" propid="value" datasetid="ds_main_condition" columnid="deptcd"/>
- <BindItem id="item4" compid="group3.grp_sea.cmb_slipendyn" propid="value" datasetid="ds_main_condition" columnid="slipendyn"/>
- <BindItem id="item5" compid="group3.grp_sea.cmb_slipkind" propid="value" datasetid="ds_main_condition" columnid="slipkind"/>
- <BindItem id="item6" compid="group3.checkbox1" propid="value" datasetid="ds_main_condition" columnid="alldate"/>
- </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::RAC001.xjs";
- include "mis_acntcommonxp::RAD001.xjs";
- include "com_basiccodexp::ZBC001.xjs";
- var deptcd = "";
- var acntdept = "";
- function SMRAD01400_onload(obj:Form, e:LoadEventInfo) {
- frmf_initForm(obj);
- //grdf_initGrid(grd_XXX);
- //grdf_setGridSort(grd_XXX);
- grdf_setRowTypeIcon(group3.grd_autosliplist, 1);
- fOpenForm();
- }
- //전체에서 event와 src를 제외한 script 를 모두포함.
-
- function fOpenForm()
- {
- var instcd = sysf_getUserInfo("dutplceinstcd");
- deptcd = sysf_getUserInfo("dutplcecd");
- var deptnm = sysf_getUserInfo("dutplcenm");
- ds_send_data.setColumn( 0, "instcd", instcd);
- ds_send_data.setColumn( 0, "mngtcd", "acntdept");
- // submit("TRRAZ00001");
- var oParam = {};
- oParam.id = "TRRAZ00001";
- oParam.service = "acntcommonapp.AcntCommon";
- oParam.method = "reqGetAcntMngtCodeList";
- oParam.inds = "req=ds_send_data";
- oParam.outds = "ds_init_code_codelist=codelist";
- oParam.async = false;
- oParam.callback = "cf_TRRAZ00001";
- tranf_submit(oParam);
- /*
- function cf_TRRAZ00001(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- }
- function cf_TRRAZ00001(sSvcId, nErrorCode, sErrorMsg) {
- arErrorCode.push(sSvcId, nErrorCode);
- }
- arErrorCode.pop("TRRAZ00001") > -1
- arErrorCode.pop("TRRAZ00001") < 0
- */
-
- //model.refresh();
- }
-
- function cf_TRRAZ00001(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
-
- acntdept = ds_init_code_codelist.getColumn(0, "cdid");
- if (deptcd != deptcd)
- {
- //model.setValue(group3.grp_sea.cmb_slipflag.attribute("ref"), "1");
- ds_main_condition.setColumn(0,"slipflag","1");
- //group3.grp_sea.cmb_slipflag.enable = false;
- //model.setValue(group3.grp_sea.cmb_slipkind.attribute("ref"), "3");
- ds_main_condition.setColumn(0,"slipkind","3");
- //group3.grp_sea.cmb_slipkind.enable = false;
- //model.setValue(group3.grp_sea.ipt_deptcd.attribute("ref"), deptcd);
- //model.setValue(group3.grp_sea.ipt_deptnm.attribute("ref"), deptnm);
- //group3.grp_sea.ipt_deptcd.enable = false;
- //group3.grp_sea.ipt_deptnm.enable = false;
- }
- if(radfCheckInstMngt(sysf_getUserInfo("dutplceinstcd"), 'condition7') == "Y")
- {
- misfComboComCdList("R0360", group3.grp_sea.cmb_slipkind, "Y");
- }
- else
- {
- misfComboComCdList("R0359", group3.grp_sea.cmb_slipkind, "Y");
- }
- misfComboComCdList("R0008", group3.grp_sea.cmb_slipflag, "N");
-
- ds_main_notelist.clearData();
- var sToday = utlf_getCurrentDate().toString();
- ds_main_condition.setColumn( 0, "genrdd",sToday);
- var instcd = sysf_getUserInfo("dutplceinstcd");
- ds_main_condition.setColumn( 0, "instcd",instcd);
- ds_main_list_detailist.clearData();
- ds_main_list_detailist.addRow();
- ds_main_list_detailist.clearData();//조회시 기존 데이터 삭제
- // for(var i = group3.grd_autosliplist.fixedCols ; i < group3.grd_autosliplist.cols ; i++)
- // {
- // group3.grd_autosliplist.colDisabled(i) = true;
- // }
- }
- function fAddDelRow(sStatus)
- {
- if(sStatus == "A")
- {
- misfGridIUD(group3.grd_autosliplist, sStatus);
- group3.grd_autosliplist.valueMatrix(group3.grd_autosliplist.row, group3.grd_autosliplist.colRef("instcd")) = sysf_getUserInfo("dutplceinstcd");
- group3.grd_autosliplist.valueMatrix(group3.grd_autosliplist.row, group3.grd_autosliplist.colRef("genrdd")) = ds_main_condition.getColumn(0, "genrdd");
- group3.grd_autosliplist.valueMatrix(group3.grd_autosliplist.row, group3.grd_autosliplist.colRef("slipflag")) = ds_main_condition.getColumn(0, "slipflag");
- }
- else
- {
- misfGridIUD(group3.grd_autosliplist, sStatus);
- }
- }
- function fSaveClick()
- {
- var oParam = {};
- oParam.id = "TXRAD01402";
- oParam.service = "slipapp.AccBook";
- oParam.method = "reqExeAutoBookkeeping";
- oParam.inds = "req=ds_main_list_detailist:U";
- oParam.outds = "";
- oParam.async = false;
- // oParam.callback = "cf_TXRAD01402";
- tranf_submit(oParam);
- }
- //========================================================================================
- //기재사항코드 조회
- //========================================================================================
- function fRetrive()
- {
- ds_main_list_detailist.clearData();
- ds_main_list_detailist.addRow();
- ds_main_list_detailist.clearData();//조회시 기존 데이터 삭제
- dsf_makeValue( ds_send, "send", "string", "" );
- ds_send.copyData(ds_main_condition);
- var oParam = {};
- oParam.id = "TRRAD01401";
- oParam.service = "slipapp.AccBook";
- oParam.method = "reqGetAutoBookkeeping";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_list_detailist=detailist";
- oParam.async = false;
- oParam.callback = "cf_TRRAD01401";
- tranf_submit(oParam);
- ds_main_list_detailist.keystring = "G:+slipkind+drcrflag";
-
- }
- function cf_TRRAD01401(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
-
- // group3.grd_autosliplist.subtotalposition="below";
- // group3.grd_autosliplist.multitotals=true;
- //
- // group3.grd_autosliplist.subtotal("sum", group3.grd_autosliplist.colRef("slipseqno"), group3.grd_autosliplist.colRef("amt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#3366ff; color:#0000ff; font-weight:bold; ", 30, "전표구분번호별합계", false);
- //
- // group3.grd_autosliplist.subtotal("sum", group3.grd_autosliplist.colRef("workflag"), group3.grd_autosliplist.colRef("amt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#0000ff; font-weight:bold; ", 30, "업무별합계", false);
- //
- // group3.grd_autosliplist.subtotal("sum", group3.grd_autosliplist.colRef("unslno"), group3.grd_autosliplist.colRef("amt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#00ffff; color:#0000ff; font-weight:bold; ", 30, "전표차대합계", false);
- //
- // group3.grd_autosliplist.subtotal("sum", group3.grd_autosliplist.colRef("drcrflag"), group3.grd_autosliplist.colRef("amt"), "format:#,###; roundmode:round; roundpostion:2", "background-color:#ccffff; font-weight:bold; ", 30, "차대소계", false);
- }
- function fAutoBookClick()
- {
- dsf_makeValue( ds_send, "send", "string", "" );
- ds_send.copyData(ds_main_condition);
- //model.refresh();
- // submit("TXRAD01403");
- var oParam = {};
- oParam.id = "TRRAD01401";
- oParam.service = "slipapp.AccBook";
- oParam.method = "reqRunAutoBookkeeping";
- oParam.inds = "req=ds_send";
- oParam.outds = "";
- oParam.async = false;
- //oParam.callback = "cf_TRRAD01401";
- tranf_submit(oParam);
- /*
- function cf_TRRAD01401(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- }
- function cf_TRRAD01401(sSvcId, nErrorCode, sErrorMsg) {
- arErrorCode.push(sSvcId, nErrorCode);
- }
- arErrorCode.pop("TRRAD01401") > -1
- arErrorCode.pop("TRRAD01401") < 0
- */
- //model.refresh();
- }
- //========================================================================================
- //관리항목 상세정보 조회(그리드용)
- //========================================================================================
- function fGetMngItemInfo(pRow)
- {
- if ( pRow > 0 )
- {
- ds_send.clearData();
- ds_send.addRow();
- var strItem ;
- strItem = grd_notelist.valueMatrix(grd_notelist.row, grd_notelist.colRef("mngitem"));
- ds_main_condition.setColumn( 0, "mngitem",strItem);
- ds_main_list_detailist.clearData();
- ds_main_list_detailist.addRow();
- ds_main_list_detailist.clearData();//조회시 기존 데이터 삭제
- ds_send.copyData(ds_main_condition);
- // submit("TRRAD01002");
- var oParam = {};
- oParam.id = "TRRAD01002";
- oParam.service = "slipapp.AccBook";
- oParam.method = "reqGetManageItemDetail";
- oParam.inds = "req=ds_";
- oParam.outds = "ds_=detailist";
- oParam.async = false;
- oParam.callback = "cf_TRRAD01002";
- tranf_submit(oParam);
- /*
- function cf_TRRAD01002(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- }
- function cf_TRRAD01002(sSvcId, nErrorCode, sErrorMsg) {
- arErrorCode.push(sSvcId, nErrorCode);
- }
- arErrorCode.pop("TRRAD01002") > -1
- arErrorCode.pop("TRRAD01002") < 0
- */
- }
- }
- //========================================================================================
- //각종 코드 Help Open
- //========================================================================================
- function fOpenPopupHelp(pHelper, pControl, pInstance, pCdgrupid, pValueControl, pNodeName)
- {
- misfOpenPopUpList(pHelper, pControl, pCdgrupid, pInstance, pValueControl, pNodeName);
- //model.refresh();
- }
- //========================================================================================
- //엑셀입력(excel file을 그리드에 입력)
- //========================================================================================
- function fInputExcel(pGrid)
- {
- var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- if(fileName != "")
- {
- pGrid.loadExcel(fileName, 1, true);
- pGrid.deleteRow(1);
- for(i = 1; i < pGrid.rows; i++)
- {
- pGrid.rowStatus(i) = 1;
- }
- //pGrid.refresh();
- }
- }
- function group3_grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo) {
- fRetrive();
- }
- function group3_grp_sea_btn_deptcd_onclick(obj:Button, e:ClickEventInfo) {
- misfOpenPopUpList("02", group3.grp_sea.ipt_deptcd, "", "deptcd,deptnm");
- //model.refresh();
- }
- function group3_grd_autosliplist_onlbuttonup(obj:Grid, e:MouseEventInfo) { // 사용여부 확인 필요
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("acntcd"))
- // {
- // misfOpenPopUpList("05", group3.grd_autosliplist, "", "acntcd,acntnm");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("rlaacntcd"))
- // {
- // misfOpenPopUpList("05", group3.grd_autosliplist, "", "rlaacntcd,rlaacntnm");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("costcntrdeptcd"))
- // {
- // misfOpenPopUpList("02", group3.grd_autosliplist, "", "costcntrdeptcd,costcntrdeptnm");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("slipdeptcd"))
- // {
- // misfOpenPopUpList("02", group3.grd_autosliplist, "", "slipdeptcd,slipdeptnm");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("possdeptcd"))
- // {
- // misfOpenPopUpList("02", group3.grd_autosliplist, "", "possdeptcd,possdeptnm");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("entrregno"))
- // {
- // misfOpenPopUpList("14", group3.grd_autosliplist, "", "entrregno,custnm,custprsd,cntctel,custaddr,custbizcond,custitem");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("rlacd"))
- // {
- // var strPopup;
- // var strChk;
- // var rownum ;
- // rownum = group3.grd_autosliplist.row;
- // strChk = ds_main_list_detailist.getColumn(rownum, "rlaflag");
- //
- // if ( strChk == "1" ) {
- // strPopup = "14";
- // } else if ( strChk == "3" ) {
- // strPopup = "02";
- // } else if ( strChk == "4" ) {
- // strPopup = "01";
- // } else if ( strChk == "5" ) {
- // strPopup = "31";
- // } else {
- // return;
- // }
- //
- // misfOpenPopUpList(strPopup, group3.grd_autosliplist, "", "rlacd,rlanm");
- //
- // //model.refresh();
- //
- // }
- //
- // if(group3.grd_autosliplist.col == group3.grd_autosliplist.colRef("notefactcd1"))
- // {
- // /* 순서 체크 해야 함 notefactnm1*/
- // misfOpenPopUpList("15", group3.grd_autosliplist, "", "notefactcd1,notefactspec1");
- // var strtmp = group3.grd_autosliplist.valueMatrix(group3.grd_autosliplist.row, group3.grd_autosliplist.colRef("notefactcd1")) ;
- // if (strtmp != "")
- // {
- // group3.grd_autosliplist.valueMatrix(group3.grd_autosliplist.row, group3.grd_autosliplist.colRef("notefactnm1")) = "계좌번호";
- // }
- //
- // //model.refresh();
- //
- // }
- }
- function group3_grd_autosliplist_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
- var nRow = ds_main_list_detailist.rowposition;
- if (nRow >= 0 && !utlf_isNull(ds_main_list_detailist.getColumn(nRow,"unsldd")))
- {
- dsf_makeValue( ds_source_slipinfo, "instcd", "string", ds_main_list_detailist.getColumn(nRow,"instcd"));
- dsf_makeValue( ds_source_slipinfo, "slipdt", "string", ds_main_list_detailist.getColumn(nRow,"unsldd"));
- dsf_makeValue( ds_source_slipinfo, "slipno", "string", ds_main_list_detailist.getColumn(nRow,"unslno"));
- //model.refresh();
- frmf_modal("SMRAD08100", "SMRAD08100", ds_source_slipinfo, "", "", "", "", "", "", "", "", "", "M");
- }
- }
- function group3_btn_delrow_onclick(obj:Button, e:ClickEventInfo) {
- fAddDelRow("D");
- }
- function group3_btn_addrow_onclick(obj:Button, e:ClickEventInfo) {
- fAddDelRow("A");
- }
- function group3_btn_autotr_onclick(obj:Button, e:ClickEventInfo) {
- var slipkind = ds_main_condition.getColumn(0, "slipkind");
- var slipflag = ds_main_condition.getColumn(0, "slipflag");
- if(deptcd == acntdept)
- {
- if((utlf_isNull(slipkind) || slipkind == "3") && slipflag == "1")
- {
- sysf_messageBox("CTMS 출금전표는 임상연구지원 센터 권한입니다.", "I000");
- return;
- }
- }
- else
- {
-
- if((utlf_isNull(slipkind) || slipkind == "1" || slipkind == "2") && slipflag == "1")
- {
- sysf_messageBox("CTMS 대체, 입금 전표는 재무팀 권한입니다.", "I000");
- return;
- }
- }
- fAutoBookClick();
- fRetrive();
- }
- function group3_btn_save_onclick(obj:Button, e:ClickEventInfo) {
- var slipkind = ds_main_condition.getColumn(0, "slipkind");
- var slipflag = ds_main_condition.getColumn(0, "slipflag");
- if(deptcd == acntdept)
- {
- if((utlf_isNull(slipkind) || slipkind == "3" ) && slipflag == "1")
- {
- sysf_messageBox("CTMS 출금전표는 임상연구지원 센터 권한입니다.", "I000");
- return;
- }
- }
- fSaveClick();
- fRetrive();
- }
- function group3_btn_5_onclick(obj:Button, e:ClickEventInfo) {
- radfSaveExcel(group3.grd_autosliplist);
- }
- ]]></Script>
- </Form>
- </FDL>
|