YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRSM00300_부서별화학물질사용현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSM00300" position="absolute 0 0 1194 791" titletext="부서별 목록조회(MSDS 조회)" oninit="SMRSM00300_oninit" onload="SMRSM00300_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="부서별 목록조회(MSDS 조회)" class="tit_1" position="absolute 0 0 213 25"/>
        <Button id="btn_gen" taborder="1" text="취급일지" class="btn4" position="absolute 971 23 1051 45" anchor="top right" onclick="btn_gen_onclick"/>
        <Button id="btn_prt" taborder="2" text="화학물질 목록 출력" class="btn4" position="absolute 1054 23 1194 45" anchor="top right" onclick="btn_prt_onclick"/>
        <Shape id="line2" class="line_6" position="absolute 0 45 1194 51" anchor="left top right"/>
        <Div id="grp_sea" taborder="3" class="div_SA2" position="absolute 0 49 1194 89" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption7" text="물질코드" class="search_name" position="absolute 432 12 508 29" anchor="default"/>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 1036 9 1042 31" anchor="top right"/>
              <Button id="btn_search" taborder="29" text="조회" class="btn1" position="absolute 1055 10 1111 32" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption1" text="부서코드" class="search_name" position="absolute 50 12 126 29" anchor="default"/>
              <Edit id="opt_deptnm" taborder="30" readonly="true" position="absolute 228 11 415 30" class="output" anchor="default"/>
              <Button id="btn_deptcd" taborder="31" class="icon_search" position="absolute 209 12 225 28" onclick="grp_sea_btn_deptcd_onclick" anchor="default"/>
              <Edit id="ipt_deptcd" taborder="32" class="input_default" position="absolute 131 11 206 30" autoselect="true" autoskip="true" onkeydown="grp_sea_ipt_deptcd_onkeydown" anchor="default"/>
              <Edit id="ipt_matrcd" taborder="33" class="input_default" position="absolute 510 11 555 30" autoselect="true" autoskip="true" anchor="default"/>
              <Button id="btn_matrcd" taborder="34" class="icon_search" position="absolute 559 12 575 28" onclick="grp_sea_btn_matrcd_onclick" anchor="default"/>
              <Edit id="opt_matrnm" taborder="35" readonly="true" position="absolute 578 11 820 30" class="output" anchor="default"/>
              <Static id="caption3" text="기준일자" class="search_name" position="absolute 839 12 915 29" anchor="default"/>
              <Calendar id="ipt_basedd" taborder="36" class="input_default" position="absolute 918 11 1016 30" autoselect="true" autoskip="true" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption21" text="부서별 화학물질 목록" class="tit_2" position="absolute 0 99 152 121"/>
        <Shape id="line3" class="line_10" position="absolute 0 115 1193 121" anchor="left top right"/>
        <Edit id="ipt_updpath" taborder="4" visible="false" position="absolute 970 93 1070 112" autoskip="true" autoselect="true"/>
        <Button id="btn_excel" taborder="5" text="엑셀출력" class="btn7" position="absolute 1112 95 1192 114" anchor="top right" onclick="btn_excel_onclick"/>
        <Static id="caption5" text="※ 1. 화학물질 목록 출력은 선택된 물품만을 대상으로 합니다." position="absolute 0 740 556 760" anchor="left bottom"/>
        <Static id="caption2" text="2. 유해등급이 1등급인 화학물질을 더블클릭하면 특별관리물질 취급일지를 작성할 수 있습니다." position="absolute 15 757 585 777" anchor="left bottom"/>
        <Grid id="grd_matrlist" taborder="6" binddataset="ds_main_matrlist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 120 1193 730" anchor="all" oncellclick="grd_matrlist_oncellclick" oncelldblclick="grd_matrlist_oncelldblclick" autosizingtype="row" extendsizetype="row">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24" band="left"/>
                <Column size="24"/>
                <Column size="128"/>
                <Column size="170"/>
                <Column size="103"/>
                <Column size="30"/>
                <Column size="102"/>
                <Column size="60"/>
                <Column size="46"/>
                <Column size="46"/>
                <Column size="46"/>
                <Column size="46"/>
                <Column size="46"/>
                <Column size="46"/>
                <Column size="46"/>
                <Column size="55"/>
                <Column size="46"/>
                <Column size="58"/>
                <Column size="58"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="44"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="3" taborder="undefined"/>
                <Cell col="1" rowspan="3" displaytype="checkbox" edittype="checkbox" taborder="undefined"/>
                <Cell col="2" rowspan="3" text="부서명" taborder="undefined"/>
                <Cell col="3" rowspan="3" text="물질명" taborder="undefined"/>
                <Cell col="4" rowspan="3" text="유해&#10;구성성분" taborder="undefined"/>
                <Cell col="5" rowspan="3" text="유해&#10;등급" taborder="undefined"/>
                <Cell col="6" rowspan="3" text="용도" taborder="undefined"/>
                <Cell col="7" rowspan="3" text="신호어" taborder="undefined"/>
                <Cell col="8" colspan="9" text="경 고 표 시" taborder="undefined"/>
                <Cell col="17" rowspan="3" text="물질안전&#10;보건자료&#10;(MSDS)" taborder="undefined"/>
                <Cell col="18" rowspan="3" text="작업&#10;공정별 &#10;관리요령" taborder="undefined"/>
                <Cell col="19" text="부서코드"/>
                <Cell col="20" text="물질코드"/>
                <Cell col="21" text="gubun"/>
                <Cell col="22" text="useqtym"/>
                <Cell col="23" text="prodcmpynm"/>
                <Cell col="24" text="pos1"/>
                <Cell col="25" text="pos2"/>
                <Cell col="26" text="pos3"/>
                <Cell col="27" text="pos4"/>
                <Cell col="28" text="pos5"/>
                <Cell col="29" text="pos6"/>
                <Cell col="30" text="pos7"/>
                <Cell col="31" text="pos8"/>
                <Cell col="32" text="pos9"/>
                <Cell col="33" text="harm"/>
                <Cell row="1" col="8" rowspan="2" text="인화성" taborder="undefined"/>
                <Cell row="1" col="9" rowspan="2" text="흡인&#10;유해성" taborder="undefined"/>
                <Cell row="1" col="10" rowspan="2" text="급성&#10;독성" taborder="undefined"/>
                <Cell row="1" col="11" rowspan="2" text="부식성" taborder="undefined"/>
                <Cell row="1" col="12" rowspan="2" text="산화성" taborder="undefined"/>
                <Cell row="1" col="13" rowspan="2" text="고압&#10;가스" taborder="undefined"/>
                <Cell row="1" col="14" rowspan="2" text="폭발성" taborder="undefined"/>
                <Cell row="1" col="15" rowspan="2" text="수생환경&#10;유해성" taborder="undefined"/>
                <Cell row="1" col="16" rowspan="2" text="경고" taborder="undefined"/>
                <Cell row="1" col="19" text="caption1"/>
                <Cell row="1" col="20" text="caption2"/>
                <Cell row="1" col="21" text="caption3"/>
                <Cell row="1" col="22" text="caption4"/>
                <Cell row="1" col="23" text="caption5"/>
                <Cell row="1" col="24" text="caption6"/>
                <Cell row="1" col="25" text="caption7"/>
                <Cell row="1" col="26" text="caption8"/>
                <Cell row="1" col="27" text="caption9"/>
                <Cell row="1" col="28" text="caption10"/>
                <Cell row="1" col="29" text="caption11"/>
                <Cell row="1" col="30" text="caption12"/>
                <Cell row="1" col="31" text="caption13"/>
                <Cell row="1" col="32" text="caption14"/>
                <Cell row="1" col="33" text="caption15"/>
                <Cell row="2" col="19" text="caption1"/>
                <Cell row="2" col="20" text="caption2"/>
                <Cell row="2" col="21" text="caption3"/>
                <Cell row="2" col="22" text="caption4"/>
                <Cell row="2" col="23" text="caption5"/>
                <Cell row="2" col="24" text="caption6"/>
                <Cell row="2" col="25" text="caption7"/>
                <Cell row="2" col="26" text="caption8"/>
                <Cell row="2" col="27" text="caption9"/>
                <Cell row="2" col="28" text="caption10"/>
                <Cell row="2" col="29" text="caption11"/>
                <Cell row="2" col="30" text="caption12"/>
                <Cell row="2" col="31" text="caption13"/>
                <Cell row="2" col="32" text="caption14"/>
                <Cell row="2" col="33" text="caption15"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow + 1"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:chk" expr="expr:chk == 'Y' || chk == '1' ? 1 : 0" autosizerow="limitmin"/>
                <Cell col="2" style="align:left middle;" class="text_left" text="bind:deptnm" wordwrap="word" autosizerow="limitmin"/>
                <Cell col="3" style="align:left middle;" class="text_left" text="bind:matrnm" wordwrap="word" autosizerow="limitmin"/>
                <Cell col="4" style="align:left middle;" class="text_left" text="bind:harmcomp" wordwrap="word" autosizerow="limitmin"/>
                <Cell col="5" class="text_center" text="bind:harmgrde" autosizerow="limitmin"/>
                <Cell col="6" style="align:left middle;" class="text_left" text="bind:usge" wordwrap="word" autosizerow="limitmin"/>
                <Cell col="7" class="text_center" text="bind:sgnl" autosizerow="limitmin"/>
                <Cell col="8" class="text_center" text="bind:warnyn1" autosizerow="limitmin"/>
                <Cell col="9" class="text_center" text="bind:warnyn2" autosizerow="limitmin"/>
                <Cell col="10" class="text_center" text="bind:warnyn3" autosizerow="limitmin"/>
                <Cell col="11" class="text_center" text="bind:warnyn4" autosizerow="limitmin"/>
                <Cell col="12" class="text_center" text="bind:warnyn5" autosizerow="limitmin"/>
                <Cell col="13" class="text_center" text="bind:warnyn6" autosizerow="limitmin"/>
                <Cell col="14" class="text_center" text="bind:warnyn7" autosizerow="limitmin"/>
                <Cell col="15" class="text_center" text="bind:warnyn8" autosizerow="limitmin"/>
                <Cell col="16" class="text_center" text="bind:warnyn9" autosizerow="limitmin"/>
                <Cell col="17" style="color:#0000ffff;color2:#0000ffff;font:arial,9,underline;selectcolor:#0000ffff;" class="text_center" text="bind:msdsfileyn" autosizerow="limitmin"/>
                <Cell col="18" style="color:#0000ffff;color2:#0000ffff;font:arial,9,underline;selectcolor:#0000ffff;" class="text_center" text="bind:workfileyn" autosizerow="limitmin"/>
                <Cell col="19" text="bind:deptcd"/>
                <Cell col="20" text="bind:matrcd"/>
                <Cell col="21" text="bind:gubun"/>
                <Cell col="22" text="bind:useqtym"/>
                <Cell col="23" text="bind:prodcmpynm"/>
                <Cell col="24" text="bind:pos1"/>
                <Cell col="25" text="bind:pos2"/>
                <Cell col="26" text="bind:pos3"/>
                <Cell col="27" text="bind:pos4"/>
                <Cell col="28" text="bind:pos5"/>
                <Cell col="29" text="bind:pos6"/>
                <Cell col="30" text="bind:pos7"/>
                <Cell col="31" text="bind:pos8"/>
                <Cell col="32" text="bind:pos9"/>
                <Cell col="33" text="bind:harm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_harmlist" taborder="7" binddataset="ds_main_harmlist" useinputpanel="false" visible="false" position="absolute 180 495 760 570">
          <Formats>
            <Format id="default">
              <Columns>
                <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"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="caption1"/>
                <Cell col="1" text="caption2"/>
                <Cell col="2" text="caption3"/>
                <Cell col="3" text="caption4"/>
                <Cell col="4" text="caption5"/>
                <Cell col="5" text="caption6"/>
                <Cell col="6" text="caption7"/>
                <Cell col="7" text="caption8"/>
                <Cell col="8" text="caption9"/>
                <Cell col="9" text="caption10"/>
                <Cell col="10" text="caption11"/>
                <Cell col="11" text="caption12"/>
                <Cell col="12" text="caption13"/>
                <Cell col="13" text="caption14"/>
                <Cell col="14" text="caption15"/>
                <Cell col="15" text="caption16"/>
                <Cell col="16" text="caption17"/>
                <Cell col="17" text="caption18"/>
              </Band>
              <Band id="body">
                <Cell text="bind:matrnm"/>
                <Cell col="1" text="bind:deptcd"/>
                <Cell col="2" text="bind:deptnm"/>
                <Cell col="3" text="bind:useqtym"/>
                <Cell col="4" text="bind:usge"/>
                <Cell col="5" text="bind:prodcmpynm"/>
                <Cell col="6" text="bind:pos1"/>
                <Cell col="7" text="bind:pos2"/>
                <Cell col="8" text="bind:pos3"/>
                <Cell col="9" text="bind:pos4"/>
                <Cell col="10" text="bind:pos5"/>
                <Cell col="11" text="bind:pos6"/>
                <Cell col="12" text="bind:pos7"/>
                <Cell col="13" text="bind:pos8"/>
                <Cell col="14" text="bind:pos9"/>
                <Cell col="15" text="bind:sgnl"/>
                <Cell col="16" text="bind:harm"/>
                <Cell col="17" text="bind:gubun"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_condition_oncolumnchanged">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="matrcd" type="STRING" size="256"/>
          <Column id="matrnm" type="STRING" size="256"/>
          <Column id="basedd" type="STRING" size="256"/>
          <Column id="chkmatrcd" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="deptcd"/>
            <Col id="deptnm"/>
            <Col id="matrcd"/>
            <Col id="matrnm"/>
            <Col id="basedd"/>
            <Col id="chkmatrcd"/>
            <Col id="instcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_matrlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_matrlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="matrcd" type="STRING" size="256" sumtext="물질코드"/>
          <Column id="matrnm" type="STRING" size="256" sumtext="물질명"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="harmcomp" type="STRING" size="256" sumtext="유해구성성분"/>
          <Column id="harmgrde" type="STRING" size="256" sumtext="유해등급"/>
          <Column id="usge" type="STRING" size="256" sumtext="용도"/>
          <Column id="sgnl" type="STRING" size="256" sumtext="신호어"/>
          <Column id="warnyn1" type="STRING" size="256" sumtext="경고표시1"/>
          <Column id="warnyn2" type="STRING" size="256" sumtext="경고표시2"/>
          <Column id="warnyn3" type="STRING" size="256" sumtext="경고표시3"/>
          <Column id="warnyn4" type="STRING" size="256" sumtext="경고표시4"/>
          <Column id="warnyn5" type="STRING" size="256" sumtext="경고표시5"/>
          <Column id="warnyn6" type="STRING" size="256" sumtext="경고표시6"/>
          <Column id="warnyn7" type="STRING" size="256" sumtext="경고표시7"/>
          <Column id="warnyn8" type="STRING" size="256" sumtext="경고표시8"/>
          <Column id="warnyn9" type="STRING" size="256" sumtext="경고표시9"/>
          <Column id="msdsfileyn" type="STRING" size="256" sumtext="msds파일여부"/>
          <Column id="msdsfilepath" type="STRING" size="256" sumtext="msds파일path"/>
          <Column id="msdsfilenm" type="STRING" size="256" sumtext="msds파일이름"/>
          <Column id="workfileyn" type="STRING" size="256" sumtext="작업공정별 작업요령 파일여부"/>
          <Column id="workfilepath" type="STRING" size="256" sumtext="작업공정별 작업요령 파일path"/>
          <Column id="workfilenm" type="STRING" size="256" sumtext="작업공정별 작업요령 파일이름"/>
          <!--  20150102 목록 및 유해성 출력을 위해 아래 항목들 추가  -->
          <Column id="chk" type="STRING" size="256" sumtext="선택여부"/>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="useqtym" type="STRING" size="256" sumtext="사용량"/>
          <Column id="prodcmpynm" type="STRING" size="256" sumtext="제조회사"/>
          <Column id="pos1" type="STRING" size="256" sumtext="위치1"/>
          <Column id="pos2" type="STRING" size="256" sumtext="위치2"/>
          <Column id="pos3" type="STRING" size="256" sumtext="위치3"/>
          <Column id="pos4" type="STRING" size="256" sumtext="위치4"/>
          <Column id="pos5" type="STRING" size="256" sumtext="위치5"/>
          <Column id="pos6" type="STRING" size="256" sumtext="위치6"/>
          <Column id="pos7" type="STRING" size="256" sumtext="위치7"/>
          <Column id="pos8" type="STRING" size="256" sumtext="위치8"/>
          <Column id="pos9" type="STRING" size="256" sumtext="위치9"/>
          <Column id="harm" type="STRING" size="256" sumtext="유해위험성list"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="file" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_popmatr" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="matrcd" type="STRING" size="256"/>
          <Column id="matrnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="returntype" type="STRING" size="256"/>
          <Column id="selectyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="matrcd"/>
            <Col id="matrnm"/>
            <Col id="deptcd"/>
            <Col id="returntype"/>
            <Col id="selectyn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_filepath" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="filepath" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_filelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="filedata" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_popdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="matrcd" type="STRING" size="256"/>
          <Column id="matrnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="ym" type="STRING" size="256"/>
          <Column id="popflag" type="STRING" size="256"/>
          <Column id="confirmflag" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="chk" type="STRING" size="256"/>
          <Column id="ymchk" type="STRING" size="256"/>
          <Column id="lastindex" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="matrcd"/>
            <Col id="matrnm"/>
            <Col id="deptcd"/>
            <Col id="deptnm"/>
            <Col id="ym"/>
            <Col id="popflag"/>
            <Col id="confirmflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_harmlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="matrnm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="useqtym" type="STRING" size="256"/>
          <Column id="usge" type="STRING" size="256"/>
          <Column id="prodcmpynm" type="STRING" size="256"/>
          <Column id="pos1" type="STRING" size="256"/>
          <Column id="pos2" type="STRING" size="256"/>
          <Column id="pos3" type="STRING" size="256"/>
          <Column id="pos4" type="STRING" size="256"/>
          <Column id="pos5" type="STRING" size="256"/>
          <Column id="pos6" type="STRING" size="256"/>
          <Column id="pos7" type="STRING" size="256"/>
          <Column id="pos8" type="STRING" size="256"/>
          <Column id="pos9" type="STRING" size="256"/>
          <Column id="sgnl" type="STRING" size="256"/>
          <Column id="harm" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_deptcd" propid="value" datasetid="ds_main_condition" columnid="deptcd"/>
      <BindItem id="item1" compid="grp_sea.opt_deptnm" propid="value" datasetid="ds_main_condition" columnid="deptnm"/>
      <BindItem id="item2" compid="grp_sea.ipt_matrcd" propid="value" datasetid="ds_main_condition" columnid="matrcd"/>
      <BindItem id="item3" compid="grp_sea.opt_matrnm" propid="value" datasetid="ds_main_condition" columnid="matrnm"/>
      <BindItem id="item4" compid="grp_sea.ipt_basedd" propid="value" datasetid="ds_main_condition" columnid="basedd"/>
      <BindItem id="item5" compid="ipt_updpath" propid="value" datasetid="ds_hidden" columnid="file"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
function SMRSM00300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRSM00300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_matrlist);
	//grdf_setRowTypeIcon(grd_matrlist, 0);
	
	fOpenForm();
}

function fOpenForm() 
{
	misfGridInit(grd_matrlist);
	
	grp_sea.ipt_basedd.value = utlf_getCurrentDate();
	grp_sea.ipt_deptcd.value = sysf_getUserInfo("dutplcecd");
	grp_sea.opt_deptnm.value = sysf_getUserInfo("dutplcenm");

	if( sysf_getUserInfo("dutplceinstcd") == "032" ) 
	{
		for(var i = 0; i < ds_main_matrlist.rowcount; i++) 
		{
			ds_main_matrlist.setColumn(i, "harmgrde", "분류");
		}	
	}
}

function ds_main_condition_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "deptcd")
	{
		var objFocus = this.getFocus();
		grp_sea.ipt_deptcd.value = e.newvalue;
		grp_sea.ipt_deptcd.setFocus();
		grp_sea.opt_deptnm.value = "";
						 	
		misfValidationCheck("02", "", "deptcd,deptnm" );
		objFocus.setFocus();
	}
	
	if(e.columnid == "matrcd")
	{
		if(utlf_isNull(e.newvalue))
		{
			ds_main_condition.setColumn(0, "matrnm", "");
		}
	}
}

function grp_sea_ipt_deptcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
	}
}

function grp_sea_btn_deptcd_onclick(obj:Button,  e:ClickEventInfo)
{
	var vOrigDeptcd = grp_sea.ipt_deptcd.value;
						       
	var recv_list = "deptcd,deptnm";
	misfOpenPopUpList("02", grp_sea.ipt_deptcd,"", recv_list);
}

function grp_sea_btn_matrcd_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_popmatr.setColumn(0, "deptcd", grp_sea.ipt_deptcd.value);
	ds_popmatr.setColumn(0, "selectyn", "");
	
	var objArg = new Object();
		objArg.arg_ds_popdata = ds_popmatr;
		
	frmf_modal("SPRSM00100", "SPRSM00100", objArg, "", "", "", "", "", "", "", "", "", "M");
	
	if(ds_popmatr.getColumn(0, "selectyn") == "Y") 
	{
		ds_main_condition.setColumn(0, "matrcd", ds_popmatr.getColumn(0, "matrcd"));
		ds_main_condition.setColumn(0, "matrnm", ds_popmatr.getColumn(0, "matrnm"));
	}
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetMatrList();
}

function fGetMatrList() 
{ 
	var oParam = {};
		oParam.id          = "TRRSM00301";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetMatrDeptList";
		oParam.inds        = "req=ds_main_condition";
		oParam.outds       = "ds_main_matrlist=matrlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSM00301";

	tranf_submit(oParam);
	
	if( utlf_isNull(ds_main_matrlist.getColumnInfo("chk")) ){
		ds_main_matrlist.addColumn("chk", "string");
	}
	
	if( sysf_getUserInfo("dutplceinstcd") == "032" ) 
	{
		ds_main_matrlist.enableevent = false;
		ds_main_matrlist.updatecontrol = false;
		
		for(var i = 0; i < ds_main_matrlist.rowcount; i++) 
		{
			ds_main_matrlist.setColumn(i, "harmgrde", "분류");
		}	
		
		ds_main_matrlist.updatecontrol = true;
		ds_main_matrlist.enableevent = true;
	}
}

function ds_main_matrlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if( e.columnid == "chk" )
	{
		obj.setColumn(e.row, "chk", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
	}
}

function grd_matrlist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
// 	if (e.row > -1) 
// 	{
// 		if (e.cell == grd_matrlist.getBindCellIndex("Body", "chk")) 
// 		{
// 			if (ds_main_matrlist.rowcount > 0) 
// 			{
// 				var sVal = "Y";
// 				if (ds_main_matrlist.getColumn(0, "chk", "Y")) 
// 				{
// 					sVal = "N";
// 				}	
// 				
// 				for(var i = 0; i < ds_main_matrlist.rowcount; i++) 
// 				{
// 					ds_main_matrlist.setColumn(i+1, "chk", sVal);
// 				}
// 				grd_matrlist.setCellPos(grd_matrlist.getBindCellIndex("body", "matrnm"));
// 				grd_matrlist.showEditor(true);
// 			}
// 		}
// 	} 
// 	else 
// 	{	
		if (e.cell == grd_matrlist.getBindCellIndex("Body", "msdsfileyn") && ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "msdsfileyn") == "다운")
		{
			fdown("1", ds_main_matrlist.rowposition);
			grd_matrlist.setCellPos(0);
			grd_matrlist.showEditor(true);
		}	
		else if (e.cell == grd_matrlist.getBindCellIndex("Body", "workfileyn") && ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "workfileyn") == "다운")
		{
			fdown("2", ds_main_matrlist.rowposition);
			grd_matrlist.setCellPos(0);
			grd_matrlist.showEditor(true);
		}
	//}
}

function grd_matrlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	if (ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "harmgrde") == "1") 
	{
		btn_gen.click();
	}
}

function fdown(flag, iRow)
{
	var filepath = "";
	var filenm = "";
	
	if(flag == "1")
	{
		filepath = ds_main_matrlist.getColumn(iRow, "msdsfilepath");
		filenm = ds_main_matrlist.getColumn(iRow, "msdsfilenm");
	}
	else if (flag == "2") 
	{
		filepath = ds_main_matrlist.getColumn(iRow, "workfilepath");
		filenm = ds_main_matrlist.getColumn(iRow, "workfilenm");
	}
	
	var fd  = new FileDialog;
	var objVFile = fd.open("FileSave", FileDialog.SAVE, "%MYDOCUMENT%", filenm);  

	ds_filepath.setColumn(0, "filepath", filepath);
	
	sysf_setErrorMsg(false);	//자바단에서 에러발생시 1.0은 오류리턴을 안해서...
	
	var oParam = {};
		oParam.id          = "TRRWC03003";
		oParam.service     = "paybaseinfomngtapp.PayBaseInfoMngt";
		oParam.method      = "reqGetManualAtt";
		oParam.inds        = "req=ds_filepath";
		oParam.outds       = "ds_filelist=attachfile";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRWC03003";

	tranf_submit(oParam);
	
	sysf_setErrorMsg(true);
	
	var sFileExt = utlf_transNullToEmpty(ds_main_matrlist.getColumn(iRow, "msdsfilenm")+"");
	
	dsf_readFileFromDs(objVFile.fullpath, ds_filelist, 0, "filedata"); // 파일저장

	if (sysf_messageBox("파일을", "Q004") == "6")
	{
		system.execShell("\"" + objVFile.fullpath + "\"");
	}
}	
		
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_matrlist, "excel", "savetype1", "false");
}

function btn_gen_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "harmgrde") != "1") 
	{
	   if (sysf_getUserInfo("dutplceinstcd") == "031"){
		frmf_modal("SMRSM00401", "SMRSM00401", "", "", "", "", "", "", "", "", "", "", "M");	   
	   }else{
		frmf_modal("SMRSM00400", "SMRSM00400", "", "", "", "", "", "", "", "", "", "", "M");
	   }
	}	
	else if (ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "harmgrde") == "1")
	{
	
	   if (sysf_getUserInfo("dutplceinstcd") == "031"){	
			ds_popdata.setColumn(0, "matrcd", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "matrcd"));
			ds_popdata.setColumn(0, "matrnm", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "matrnm"));
			ds_popdata.setColumn(0, "deptcd", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "deptcd"));
			ds_popdata.setColumn(0, "deptnm", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "deptnm"));
			
			ds_popdata.setColumn(0, "ym", String(grp_sea.ipt_basedd.value).substr(0,6));
			ds_popdata.setColumn(0, "popflag", "Y");
			ds_popdata.setColumn(0, "confirmflag", "");
			ds_popdata.setColumn(0, "gubun", "N");		
			
			var objArg = new Object();
				objArg.arg_ds_main_condition = ds_popdata;
				
			frmf_modal("SMRSM00401", "SMRSM00401", objArg, "", "", "", "", "", "", "", "", "", "M");
		}else{
			ds_popdata.setColumn(0, "matrcd", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "matrcd"));
			ds_popdata.setColumn(0, "matrnm", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "matrnm"));
			ds_popdata.setColumn(0, "deptcd", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "deptcd"));
			ds_popdata.setColumn(0, "deptnm", ds_main_matrlist.getColumn(ds_main_matrlist.rowposition, "deptnm"));
			
  		    var objArg = new Object();
				objArg.arg_ds_main_condition = ds_popdata;
				
			frmf_modal("SMRSM00400", "SMRSM00400", objArg, "", "", "", "", "", "", "", "", "", "M");		
		}
	}
}

function btn_prt_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_matrlist.rowcount < 0) 
	{
		sysf_messageBox("조회된 결과가 존재하지 않습니다. \n먼저 조회 후 출력하십시요.", "E999", "");							
		return;
	}
	
	misfGridInit(grd_harmlist);
	
	var chkcnt = 0; 
	for(var  i = 0; i < ds_main_matrlist.rowcount; i++) 
	{
		if(ds_main_matrlist.getColumn(i, "chk") == "Y")
		{
			var row = ds_main_harmlist.addRow();
			
			ds_main_harmlist.setColumn(row, "matrnm", ds_main_matrlist.getColumn(i, "matrnm"));
			ds_main_harmlist.setColumn(row, "deptcd", ds_main_matrlist.getColumn(i, "deptcd"));
			ds_main_harmlist.setColumn(row, "deptnm", ds_main_matrlist.getColumn(i, "deptnm"));
			ds_main_harmlist.setColumn(row, "useqtym", ds_main_matrlist.getColumn(i, "useqtym"));
			ds_main_harmlist.setColumn(row, "usge", ds_main_matrlist.getColumn(i, "usge"));
			ds_main_harmlist.setColumn(row, "prodcmpynm", ds_main_matrlist.getColumn(i, "prodcmpynm"));
			ds_main_harmlist.setColumn(row, "pos1", ds_main_matrlist.getColumn(i, "pos1"));
			ds_main_harmlist.setColumn(row, "pos2", ds_main_matrlist.getColumn(i, "pos2"));
			ds_main_harmlist.setColumn(row, "pos3", ds_main_matrlist.getColumn(i, "pos3"));
			ds_main_harmlist.setColumn(row, "pos4", ds_main_matrlist.getColumn(i, "pos4"));
			ds_main_harmlist.setColumn(row, "pos5", ds_main_matrlist.getColumn(i, "pos5"));
			ds_main_harmlist.setColumn(row, "pos6", ds_main_matrlist.getColumn(i, "pos6"));
			ds_main_harmlist.setColumn(row, "pos7", ds_main_matrlist.getColumn(i, "pos7"));
			ds_main_harmlist.setColumn(row, "pos8", ds_main_matrlist.getColumn(i, "pos8"));
			ds_main_harmlist.setColumn(row, "pos9", ds_main_matrlist.getColumn(i, "pos9"));
			ds_main_harmlist.setColumn(row, "sgnl", ds_main_matrlist.getColumn(i, "sgnl"));
			ds_main_harmlist.setColumn(row, "harm", ds_main_matrlist.getColumn(i, "harm"));
			ds_main_harmlist.setColumn(row, "gubun", ds_main_matrlist.getColumn(i, "gubun"));
			
			chkcnt += 1;						
		}
	}
	
	if(chkcnt ==  0) 
	{
		sysf_messageBox("선택된 자료가 없습니다. \n먼저 출력할 대상을 선택한 후 출력하십시요.", "E999", "");							
		return;
	}
	
	if(sysf_getUserInfo("dutplceinstcd") == "032") 
	{		
		var objDOM = rptf_createDOM();
			rptf_setNodeListToDOM(objDOM, "/root/main/harmlist", ds_main_harmlist);
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source;  
		var option = ""; 
		rptf_exeReportPreview30(["RPRSM00302"],[objParam], option);
	} 
	else 
	{
		var objDOM = rptf_createDOM();
			rptf_setNodeListToDOM(objDOM, "/root/main/harmlist", ds_main_harmlist);
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source;  
		var option = ""; 
		rptf_exeReportPreview30(["RPRSM00301"],[objParam], option);
	}
}

]]></Script>
  </Form>
</FDL>