123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
- <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
- <xhtml:head>
- <xhtml:title>약가생성내역</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <mech>
- <instcd/>
- <calcscorcd/>
- <insuedicd/>
- <hngnm/>
- <fromdd/>
- <todd/>
- <purcamt/>
- <gnrlrbpnt/>
- <fstrgstrid/>
- <fstrgstdt/>
- <lastupdtrid/>
- <lastupdtdt/>
- </mech>
- <cont>
- <instcd/>
- <goodflag/>
- <goodcd/>
- <goodnm/>
- <purccondd/>
- <purcconno/>
- <purcconseq/>
- <conqty/>
- <congoodunitcost/>
- <chkyn/>
- <fstrgstrid/>
- <fstrgstdt/>
- <lastupdtrid/>
- <lastupdtdt/>
- </cont>
- <wchk>
- <instcd/>
- <goodflag/>
- <goodcd/>
- <purcchkdd/>
- <purcchkno/>
- <purcchkseq/>
- <purccondd/>
- <purcconno/>
- <chkqty/>
- <chkgoodunitcost/>
- <chkamt/>
- <acntcd/>
- <delivedeptcd/>
- <fstrgstrid/>
- <fstrgstdt/>
- <lastupdtrid/>
- <lastupdtdt/>
- </wchk>
- <pur>
- <instcd/>
- <kwanri_gubun/>
- <pum_code/>
- <pum_name/>
- <ky_ymd/>
- <ky_seq/>
- <ibgo_ymd/>
- <ibgo_seq/>
- <qty/>
- <danga1/>
- <keumak/>
- <chul_buseo/>
- <user_id/>
- <sys_date/>
- <upd_date/>
- </pur>
- <h604>
- <instcd/>
- <goodcd/>
- <edicd/>
- <itemnm/>
- <appdd/>
- <appseqno/>
- <windd/>
- <winqty/>
- <winamt/>
- <oneunitcost/>
- <notiyn/>
- <fstrgstrid/>
- <fstrgstdt/>
- <lastupdtrid/>
- <lastupdtdt/>
- </h604>
- <h602>
- <instcd/>
- <goodcd/>
- <appitemcd/>
- <itemnm/>
- <appno/>
- <reptflag/>
- <lnno/>
- <winno/>
- <winseqno/>
- <purcdd/>
- <purcqty/>
- <purcamt/>
- <oneunitcost/>
- <statcd/>
- <fstrgstrid/>
- <fstrgstdt/>
- <lastupdtrid/>
- <lastupdtdt/>
- </h602>
- </main>
- <send>
- <fromdd/>
- <todd/>
- <srchflag/>
- </send>
- <init>
- <target>
- <cont>계약</cont>
- <wchk>검수</wchk>
- <pur>입고</pur>
- <h604>집계</h604>
- <h602>신고</h602>
- </target>
- </init>
- <hidden>
- <rowcnt/>
- </hidden>
- <temp>
- <xlslist>
- <col1/>
- </xlslist>
- </temp>
- </root>
- </instance>
- <submission id="TRPIE04301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main"/>
- </model>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- grd_mech.rowHeightMin = 23;
- grd_cont.rowHeightMin = 23;
- grd_wchk.rowHeightMin = 23;
- grd_pur.rowHeightMin = 23;
- grd_h604.rowHeightMin = 23;
- grd_h602.rowHeightMin = 23;
-
- grd_target.row = 0;
- grd_target.col = 0;
- model.toggle("cont");
- model.setValue("/root/send/srchflag", "cont");
-
- model.setValue("/root/send/fromdd", getCurrentDate());
- model.setValue("/root/send/todd", getCurrentDate());
- ipt_fromdd.refresh();
- ipt_todd.refresh();
- ]]>
- </script>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
- </xhtml:head>
- <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
- <caption id="caption1" class="tit_1" style="left:0px; top:0px; width:165px; height:14px; ">재료 수가 변경 내역 조회</caption>
- <datagrid id="grd_mech" nodeset="/root/main/mech" autoresize="true" backcoloralternate="transparent" caption="기관코드^수가코드^EDI코드^수가명^수가시작일^수가종료일^구입가^최초작성자^최초작성일^최종수정자^최종수정일^일반가^보험가" colsep="^" colwidth="0, 80, 0, 200, 75, 0, 75, 0, 0, 0, 0, 75, 75" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:85px; width:595px; height:680px; ">
- <col ref="instcd"/>
- <col explorerbar="sortshow" ref="calcscorcd" style="text-align:center; "/>
- <col ref="insuedicd" style="text-align:center; "/>
- <col explorerbar="sortshow" ref="hngnm"/>
- <col ref="fromdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="todd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col explorerbar="sortshow" ref="purcamt" format="#,###" style="font-weight:bold; text-align:right; "/>
- <col ref="fstrgstrid"/>
- <col ref="fstrgstdt"/>
- <col ref="lastupdtrid"/>
- <col ref="lastupdtdt"/>
- <col ref="gnrlrbpnt" format="#,###.#" style="font-weight:bold; text-align:right; "/>
- <col ref="insurbpnt" format="#,###.#" style="font-weight:bold; text-align:right; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_mech.isCell(event.target) || grd_mech.row < 1) {
- return;
- }
-
- var calcscorcd = model.getValue("/root/main/mech[" + grd_mech.row + "]/calcscorcd");
- var flag = model.getValue("/root/send/srchflag");
- var grd = document.controls("grd_" + flag);
-
- var row = grd.findRow(calcscorcd, 0, 2, false, true);
- if (row > 0) {
- model.setFocus("grd_" + flag);
- grd.row = row;
- } else {
- grd.row = 0;
- }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_mech.gridToInstance();
- grd_mech.resizeCells();
- ]]>
- </script>
- </datagrid>
- <caption id="caption6" class="tit_2" style="left:5px; top:65px; width:90px; height:13px; ">재료 수가</caption>
- <line id="line3" class="line_1" style="x1:0px; y1:80px; x2:595px; y2:80px; "/>
- <switch id="switch1" style="left:600px; top:60px; width:595px; height:705px; border-width:0; border-style:solid; ">
- <case id="cont" selected="true" style="left:0px; top:0px; width:100.00%; height:100.00%; ">
- <line id="line1" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
- <datagrid id="grd_cont" nodeset="/root/main/cont" autoresize="true" backcoloralternate="transparent" caption="기관코드^물품구분^물품코드^물품명^계약일자^계약번호^계약순번^계약량^계약단가^검수여부^최초작성자^최초작성일시^최종수정자^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 200, 80, 60, 0, 0, 80, 0, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
- <col ref="instcd"/>
- <col ref="goodflag"/>
- <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
- <col explorerbar="sortshow" ref="goodnm"/>
- <col ref="purccondd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="purcconno" style="text-align:center; "/>
- <col ref="purcconseq"/>
- <col ref="conqty"/>
- <col ref="congoodunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
- <col ref="chkyn"/>
- <col ref="fstrgstrid"/>
- <col ref="fstrgstdt"/>
- <col ref="lastupdtrid"/>
- <col ref="lastupdtdt"/>
- <col ref="lastupdtdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_cont.isCell(event.target) || grd_cont.row < 1) {
- return;
- }
-
- var goodcd = model.getValue("/root/main/cont[" + grd_cont.row + "]/goodcd");
-
- var row = grd_mech.findRow(goodcd, 0, 1, false, true);
- if (row > 0) {
- model.setFocus("grd_mech");
- grd_mech.row = row;
- } else {
- grd_mech.row = 0;
- }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_cont.gridToInstance();
- grd_cont.resizeCells();
- ]]>
- </script>
- </datagrid>
- <caption id="caption7" class="tit_2" style="left:0px; top:5px; width:105px; height:13px; ">계약 내역</caption>
- </case>
- <case id="wchk">
- <datagrid id="grd_wchk" nodeset="/root/main/wchk" autoresize="true" backcoloralternate="transparent" caption="기관코드^물품구분^물품코드^검수일자^검수번호^검수순번^계약일자^계약번호^검수수량^검수단가^검수금액^계정과목^출고부서^최초작성자^최초작성일시^최종수정자^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 80, 60, 0, 80, 60, 60, 80, 0, 0, 0, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
- <col ref="instcd"/>
- <col ref="goodflag"/>
- <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
- <col explorerbar="sortshow" ref="purcchkdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="purcchkno" style="text-align:center; "/>
- <col ref="purcchkseq"/>
- <col explorerbar="sortshow" ref="purccondd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="purcconno" style="text-align:center; "/>
- <col ref="chkqty" style="text-align:center; "/>
- <col ref="chkgoodunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
- <col ref="chkamt"/>
- <col ref="acntcd"/>
- <col ref="delivedeptcd"/>
- <col ref="fstrgstrid"/>
- <col ref="fstrgstdt"/>
- <col ref="lastupdtrid"/>
- <col ref="lastupdtdt"/>
- <col ref="lastupdtdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_wchk.isCell(event.target) || grd_wchk.row < 1) {
- return;
- }
-
- var goodcd = model.getValue("/root/main/wchk[" + grd_wchk.row + "]/goodcd");
-
- var row = grd_mech.findRow(goodcd, 0, 1, false, true);
- if (row > 0) {
- model.setFocus("grd_mech");
- grd_mech.row = row;
- } else {
- grd_mech.row = 0;
- model.resetInstanceNode("/root/main/mech");
- grd_mech.refresh();
- }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_wchk.gridToInstance();
- grd_wchk.resizeCells();
- ]]>
- </script>
- </datagrid>
- <caption id="caption2" class="tit_2" style="left:5px; top:5px; width:100px; height:13px; ">검수 내역</caption>
- <line id="line4" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
- </case>
- <case id="pur">
- <line id="line2" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
- <caption id="caption8" class="tit_2" style="left:0px; top:5px; width:85px; height:13px; ">구매 내역</caption>
- <datagrid id="grd_pur" nodeset="/root/main/pur" autoresize="true" backcoloralternate="transparent" caption="기관코드^관리구분^물품코드^물품명^계약일자^계약번호^입고일자^입고순번^구입량^구입단가^구입금액^출고부서^최초작성자^최초작성일시^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 200, 0, 0, 80, 0, 60, 80, 0, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
- <col ref="instcd"/>
- <col ref="kwanri_gubun"/>
- <col explorerbar="sortshow" ref="pum_code" style="text-align:center; "/>
- <col explorerbar="sortshow" ref="pum_name"/>
- <col ref="ky_ymd"/>
- <col ref="ky_seq"/>
- <col ref="ibgo_ymd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="ibgo_seq"/>
- <col ref="qty" style="text-align:center; "/>
- <col ref="danga1" format="#,###" style="font-weight:bold; text-align:right; "/>
- <col ref="keumak"/>
- <col ref="chul_buseo"/>
- <col ref="user_id"/>
- <col ref="sys_date"/>
- <col ref="upd_date"/>
- <col ref="upd_dd" format="yyyy-mm-dd" style="text-align:center; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_pur.isCell(event.target) || grd_pur.row < 1) {
- return;
- }
-
- var pum_code = model.getValue("/root/main/pur[" + grd_pur.row + "]/pum_code");
-
- var row = grd_mech.findRow(pum_code, 0, 1, false, true);
- if (row > 0) {
- model.setFocus("grd_mech");
- grd_mech.row = row;
- } else {
- grd_mech.row = 0;
- model.resetInstanceNode("/root/main/mech");
- grd_mech.refresh();
- }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_pur.gridToInstance();
- grd_pur.resizeCells();
- ]]>
- </script>
- </datagrid>
- </case>
- <case id="h604">
- <datagrid id="grd_h604" nodeset="/root/main/h604" autoresize="true" backcoloralternate="transparent" caption="기관코드^신청여부^물품코드^EDI코드^물품명^신청일자^신청일련번호^구입량^구입가^개당단가^입고일자" colsep="^" colwidth="0, 0, 80, 0, 200, 80, 0, 60, 0, 80, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; ">
- <col ref="instcd"/>
- <col ref="notiyn"/>
- <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
- <col ref="edicd"/>
- <col explorerbar="sortshow" ref="itemnm"/>
- <col ref="appdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="appseqno"/>
- <col ref="winqty" style="text-align:center; "/>
- <col ref="winamt"/>
- <col ref="oneunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
- <col ref="windd" format="yyyy-mm-dd" style="text-align:center; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_h604.isCell(event.target) || grd_h604.row < 1) {
- return;
- }
-
- var goodcd = model.getValue("/root/main/h604[" + grd_h604.row + "]/goodcd");
-
- var row = grd_mech.findRow(goodcd, 0, 1, false, true);
- if (row > 0) {
- model.setFocus("grd_mech");
- grd_mech.row = row;
- } else {
- grd_mech.row = 0;
- model.resetInstanceNode("/root/main/mech");
- grd_mech.refresh();
- }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_h604.gridToInstance();
- grd_h604.resizeCells();
- ]]>
- </script>
- </datagrid>
- <line id="line5" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
- <caption id="caption5" class="tit_2" style="left:0px; top:5px; width:85px; height:13px; ">발주 내역</caption>
- </case>
- <case id="h602">
- <caption id="caption9" class="tit_2" style="left:0px; top:5px; width:85px; height:13px; ">신고 내역</caption>
- <line id="line6" class="line_1" style="x1:0px; y1:20px; x2:595px; y2:20px; "/>
- <datagrid id="grd_h602" nodeset="/root/main/h602" autoresize="true" backcoloralternate="transparent" caption="기관코드^신고서구분^물품코드^신고품목코드^물품명^신청번호^줄번호^입고번호^입고순번^구입일자^구립량^구입가^개당단가^상태^최초작성자^최초작성일시^최종수정자^최종수정일시^최종수정일" colsep="^" colwidth="0, 0, 80, 0, 195, 85, 0, 0, 0, 0, 0, 0, 80, 60, 0, 0, 0, 0, 80" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:595px; height:680px; text-align:center; ">
- <col ref="instcd"/>
- <col ref="reptflag"/>
- <col explorerbar="sortshow" ref="goodcd" style="text-align:center; "/>
- <col ref="appitemcd"/>
- <col explorerbar="sortshow" ref="itemnm"/>
- <col ref="appno" style="text-align:center; "/>
- <col ref="lnno"/>
- <col ref="winno"/>
- <col ref="winseqno"/>
- <col ref="purcdd"/>
- <col ref="purcqty"/>
- <col ref="purcamt"/>
- <col ref="oneunitcost" format="#,###" style="font-weight:bold; text-align:right; "/>
- <col disabled="true" ref="statcd" type="combo">
- <choices>
- <item>
- <label>완료</label>
- <value>1</value>
- </item>
- <item>
- <label>미완료</label>
- <value>2</value>
- </item>
- <item>
- <label>SAM생성</label>
- <value>3</value>
- </item>
- <item>
- <label>전송</label>
- <value>4</value>
- </item>
- </choices>
- </col>
- <col ref="fstrgstrid"/>
- <col ref="fstrgstdt"/>
- <col ref="lastupdtrid"/>
- <col ref="lastupdtdt"/>
- <col ref="lastupdtdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_h602.isCell(event.target) || grd_h602.row < 1) {
- return;
- }
-
- var goodcd = model.getValue("/root/main/h602[" + grd_h602.row + "]/goodcd");
-
- var row = grd_mech.findRow(goodcd, 0, 1, false, true);
- if (row > 0) {
- model.setFocus("grd_mech");
- grd_mech.row = row;
- } else {
- grd_mech.row = 0;
- model.resetInstanceNode("/root/main/mech");
- grd_mech.refresh();
- }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_h602.gridToInstance();
- grd_h602.resizeCells();
- ]]>
- </script>
- </datagrid>
- </case>
- </switch>
- <shape id="roundrect1" appearance="roundrect" style="left:0px; top:20px; width:815px; height:35px; "/>
- <caption id="caption3" class="search_name" style="left:5px; top:30px; width:87px; height:17px; ">적용일자 :</caption>
- <input id="ipt_fromdd" ref="/root/send/fromdd" class="input_search" inputtype="date" format="yyyy-mm-dd" appearance="input" style="left:100px; top:29px; width:90px; height:19px; "/>
- <input id="ipt_todd" ref="/root/send/todd" class="input_search" inputtype="date" format="yyyy-mm-dd" appearance="input" style="left:206px; top:29px; width:90px; height:19px; "/>
- <caption id="cap_period" style="left:190px; top:31px; width:17px; height:17px; text-align:center; ">~</caption>
- <datagrid id="grd_target" nodeset="/root/init/target" allowselection="false" backcoloralternate="transparent" colsep="^" colwidth="50,50,50,50,50" mergecellsfixedrows="bycolrec" rowsep="|" selectionmode="free" style="left:454px; top:26px; width:251px; height:24px; background-color:#ffffff; border-left-width:1; border-top-width:1; border-right-width:0; border-bottom-width:0; border-style:solid; ">
- <col ref="cont" style="font-weight:bold; text-align:center; "/>
- <col ref="wchk" style="font-weight:bold; text-align:center; "/>
- <col ref="pur" style="font-weight:bold; text-align:center; "/>
- <col ref="h604" style="font-weight:bold; text-align:center; "/>
- <col ref="h602" style="font-weight:bold; text-align:center; "/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- if (!grd_target.isCell(event.target)) {
- return;
- }
-
- var flag = grd_target.colAttribute(grd_target.col, "ref");
- model.toggle(flag);
- model.setValue("/root/send/srchflag", flag);
- ]]>
- </script>
- </datagrid>
- <caption id="caption4" class="search_name" style="left:350px; top:30px; width:87px; height:17px; ">비교대상 :</caption>
- <button id="btnSearch" class="btn1_letter2" navindex="13" style="left:745px; top:27px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- submit("TRPIE04301");
- model.setValue("/root/hidden/rowcnt", "Count : " + instance1.selectNodes("/root/main/mech").length);
- cap_rowcnt.refresh();
- ]]>
- </script>
- </button>
- <line id="line7" style="x1:726px; y1:25px; x2:726px; y2:50px; border-color:#FFD799; "/>
- <caption id="cap_rowcnt" ref="/root/hidden/rowcnt" style="left:465px; top:60px; width:115px; height:20px; font-weight:bold; color:#808080; text-align:right; "/>
- <button id="btn_excel" class="btn2_letter4" style="left:820px; top:35px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- var flag = model.getValue("/root/send/srchflag");
-
- var fileName = window.fileDialog("save", ",", false, "재료수가변경내역_" + "수가 vs " + model.getValue("/root/init/target/" + flag) + "_" + getCurrentDate(), "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
-
- if (fileName == "") {
- return;
- }
-
- var grd = document.controls("grd_" + flag);
-
- model.resetInstanceNode("/root/temp/xlslist");
-
- var cols = grd_xls.cols;
- if (cols > 0) {
- for (var i = 0; i < cols; i++) {
- grd_xls.removeColumn(false);
- }
- }
-
- model.removeNode("/root/temp/xlslist");
- model.makeNode("/root/temp/xlslist");
-
- var colArr = new Array();
- var idx1 = 0;
- var capArr = grd_mech.caption.split("^");
- var cap = "";
- var wArr = new Array();
-
- for (var i = 0; i < grd_mech.cols; i++) {
- if (!grd_mech.colHidden(i)) {
- colArr[idx1] = grd_mech.colAttribute(i, "ref");
- cap += capArr[i] + "^";
- wArr[idx1] = Math.round(grd_mech.colWidth(i) * 1.2);
- idx1++;
- }
- }
-
- cap+= "VS^";
- colArr[idx1] = "blank";
- wArr[idx1] = 100;
-
- var idx2 = idx1 + 1;
- capArr = grd.caption.split("^");
- for (var i = 0; i < grd.cols; i++) {
- if (!grd.colHidden(i)) {
- colArr[idx2] = "t" + grd.colAttribute(i, "ref");
- cap += capArr[i] + "^";
- wArr[idx2] = Math.round(grd.colWidth(i) * 1.2);
- idx2++;
- }
- }
-
- cap = cap.substr(0, cap.length - 1);
-
- for (var i = 0; i < colArr.length; i++) {
- grd_xls.addColumn("ref:" + colArr[i] + "; type:output; ", false);
- grd_xls.colWidth(i) = wArr[i];
- }
- grd_xls.caption = cap;
-
- var cnt = instance1.selectNodes("/root/main/mech").length;
- for (var i = 1; i <= cnt; i++) {
- for (var j = 0; j < colArr.length; j++) {
-
- if (j == idx1) {
- continue;
- }
-
- if (j < idx1) {
- model.makeValue("/root/temp/xlslist[" + i + "]/" + colArr[j], model.getValue("/root/main/mech[" + i + "]/" + colArr[j]));
- } else {
- var ref = colArr[j].substr(1, colArr[j].length - 1);
- model.makeValue("/root/temp/xlslist[" + i + "]/" + colArr[j], model.getValue("/root/main/" + flag + "[" + i + "]/" + ref));
- }
- }
- }
-
- grd_xls.refresh();
-
- grd_xls.saveExcel(fileName, "sheetname:수가 vs " + model.getValue("/root/init/target/" + flag) + ";colhiddenextend:false;rowhiddenextend:false");
- messageBox("엑셀 저장이 완료되었습니다.", "I999");
- ]]>
- </script>
- </button>
- <datagrid id="grd_xls" nodeset="/root/temp/xlslist" visibility="hidden" caption="caption1" colsep="^" mergecellsfixedrows="bycolrec" rowsep="|" style="left:890px; top:20px; width:100px; height:35px; ">
- <col ref="col1"/>
- </datagrid>
- </xhtml:body>
- </xhtml:html>
|