YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRSM01100_화학물질취급관리조사목록조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSM01100" position="absolute 0 0 1200 757" titletext="화학물질 취급 변경내역 조회" oninit="SMRSM01100_oninit" onload="SMRSM01100_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="화학물질 취급 변경내역 조회" class="tit_1" position="absolute 0 0 208 25"/>
        <Shape id="line2" class="line_6" position="absolute 0 46 1194 52" anchor="left top right"/>
        <Button id="btn_send" taborder="1" text="전송취소" class="btn4" visible="false" position="absolute 1054 25 1134 47" anchor="top right" onclick="btn_send_onclick"/>
        <Button id="btn_save" taborder="2" text="확정" class="btn4" visible="false" position="absolute 1137 25 1193 47" anchor="top right" onclick="btn_save_onclick"/>
        <Div id="grp_sea" taborder="3" class="div_SA2" position="absolute 0 50 1194 110" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 837 8 843 50" anchor="top right"/>
              <Button id="btn_search" taborder="20" text="조회" class="btn1" position="absolute 855 10 911 32" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Edit id="opt_deptnm" taborder="21" readonly="true" position="absolute 216 32 406 51" class="output"/>
              <Static id="caption1" text="부서코드" class="search_name" position="absolute 35 33 111 50"/>
              <Edit id="ipt_deptcd" taborder="22" class="input_default" position="absolute 117 32 192 51" autoskip="true" autoselect="true" onkeydown="grp_sea_ipt_deptcd_onkeydown"/>
              <Button id="btn_deptcd" taborder="23" class="icon_search" position="absolute 196 33 212 49" onclick="grp_sea_btn_deptcd_onclick"/>
              <Static id="caption9" text="보고일자" class="search_name" position="absolute 35 9 116 26"/>
              <Calendar id="ipt_reptddfrom" taborder="24" class="input_default" position="absolute 117 8 215 27" mask="yyyy-mm-dd" autoskip="true" autoselect="true" onchanged="grp_sea_ipt_reptddfrom_onchanged"/>
              <Static id="caption7" text="~" position="absolute 219 8 231 28"/>
              <Calendar id="ipt_reptddto" taborder="25" class="input_default" position="absolute 234 8 332 27" mask="yyyy-mm-dd" autoskip="true" autoselect="true" onchanged="grp_sea_ipt_reptddto_onchanged"/>
              <Edit id="opt_matrnm" taborder="26" readonly="true" position="absolute 575 32 817 51" class="output"/>
              <Edit id="ipt_matrcd" taborder="27" class="input_default" position="absolute 507 32 552 51" autoskip="true" autoselect="true"/>
              <Button id="btn_matrcd" taborder="28" class="icon_search" position="absolute 556 33 572 49" onclick="grp_sea_btn_matrcd_onclick"/>
              <Static id="caption8" text="물질코드" class="search_name" position="absolute 426 33 502 50"/>
              <Radio id="rdo_prcsstat" taborder="29" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 509 7 786 27" onitemchanged="grp_sea_rdo_prcsstat_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">S</Col>
                      <Col id="datacolumn">임시저장</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">T</Col>
                      <Col id="datacolumn">전송완료</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">C</Col>
                      <Col id="datacolumn">확정완료</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">%</Col>
                      <Col id="datacolumn">전 체</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption2" text="진행상태" class="search_name" position="absolute 426 9 507 26"/>
              <Button id="btn_excelAll" taborder="30" text="전체 내용 엑셀출력" class="btn7" position="absolute 915 10 1050 32" anchor="top right" onclick="grp_sea_btn_excelAll_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" class="line_10" position="absolute 0 135 230 141" anchor="left top"/>
        <Static id="caption21" text="보고 목록" class="tit_2" position="absolute 0 119 80 141" anchor="left top"/>
        <Button id="btn_excel" taborder="4" text="엑셀출력" class="btn7" position="absolute 1114 115 1194 134" anchor="top right" onclick="btn_excel_onclick"/>
        <Grid id="grd_reptlist" taborder="5" binddataset="ds_main_reptlist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 140 230 750" anchor="left top bottom" oncellclick="grd_reptlist_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23" band="left"/>
                <Column size="73"/>
                <Column size="26"/>
                <Column size="105"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="보고일자" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="순번" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="부서명" taborder="undefined"/>
                <Cell col="4" text="부서코드"/>
                <Cell row="1" col="4" text="부서코드"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="date" text="bind:reptdd" calendardisplaynulltype="nulltext"/>
                <Cell col="2" text="bind:reptseq"/>
                <Cell col="3" style="align:left top;padding:5 2 1 2;" text="bind:deptnm" wordwrap="word"/>
                <Cell col="4" text="bind:deptcd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Grid id="grd_matrlist" taborder="6" binddataset="ds_main_matrlist" useinputpanel="false" position="absolute 235 140 1193 750" anchor="all" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="35"/>
                <Column size="73"/>
                <Column size="34"/>
                <Column size="126"/>
                <Column size="93"/>
                <Column size="93"/>
                <Column size="83"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="45"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="43"/>
                <Column size="49"/>
                <Column size="49"/>
                <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"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="구분" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="적용시작&#10;일자" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="물질&#10;코드" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="물질명" taborder="undefined"/>
                <Cell col="4" rowspan="2" text="제조사" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="공급처" taborder="undefined"/>
                <Cell col="6" rowspan="2" text="용도" taborder="undefined"/>
                <Cell col="7" rowspan="2" text="월&#10;사용량" taborder="undefined"/>
                <Cell col="8" rowspan="2" text="연간&#10;사용량" taborder="undefined"/>
                <Cell col="9" rowspan="2" text="1일&#10;취급시간" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="월&#10;작업일수" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="취급자&#10;수" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="소분용기&#10;유무" taborder="undefined"/>
                <Cell col="13" rowspan="2" text="원용기&#10;경고표지" taborder="undefined"/>
                <Cell col="14" rowspan="2" text="MSDS&#10;유무" taborder="undefined"/>
                <Cell col="15" rowspan="2" text="작성자" taborder="undefined"/>
                <Cell col="16" rowspan="2" text="전송자" taborder="undefined"/>
                <Cell col="17" text="보고일자"/>
                <Cell col="18" text="순번"/>
                <Cell col="19" text="orguseqtym"/>
                <Cell col="20" text="orguseqtyy"/>
                <Cell col="21" text="orgusge"/>
                <Cell col="22" text="orgtrethrd"/>
                <Cell col="23" text="orgworkdcntm"/>
                <Cell col="24" text="orgtretmcnt"/>
                <Cell col="25" text="orgctnryn"/>
                <Cell col="26" text="orgctnrsignyn"/>
                <Cell col="27" text="orgmsdsyn"/>
                <Cell row="1" col="17" text="보고일자"/>
                <Cell row="1" col="18" text="순번"/>
                <Cell row="1" col="19" text="orguseqtym"/>
                <Cell row="1" col="20" text="orguseqtyy"/>
                <Cell row="1" col="21" text="orgusge"/>
                <Cell row="1" col="22" text="orgtrethrd"/>
                <Cell row="1" col="23" text="orgworkdcntm"/>
                <Cell row="1" col="24" text="orgtretmcnt"/>
                <Cell row="1" col="25" text="orgctnryn"/>
                <Cell row="1" col="26" text="orgctnrsignyn"/>
                <Cell row="1" col="27" text="orgmsdsyn"/>
              </Band>
              <Band id="body">
                <Cell displaytype="combo" style="align:center middle;color:BIND(color);color2:BIND(color);font:arial,9,bold;" text="bind:workflag" combodataset="ds_cmb_workflag" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="1" displaytype="date" style="color:#ff0000ff;color2:#ff0000ff;" text="bind:appdd" calendardisplaynulltype="nulltext"/>
                <Cell col="2" text="bind:matrcd"/>
                <Cell col="3" style="align:left top;padding:4 2 2 2;" text="bind:matrnm" wordwrap="word"/>
                <Cell col="4" style="align:left top;padding:4 2 2 2;" text="bind:prodcmpynm" wordwrap="word"/>
                <Cell col="5" style="align:left top;padding:4 2 2 2;" text="bind:maincustlastsuplplcenm" wordwrap="word"/>
                <Cell col="6" style="align:left top;padding:4 2 2 2;color:EXPR(col6);color2:EXPR(col6);" text="bind:usge" wordwrap="word"/>
                <Cell col="7" style="align:center top;padding:5 0 2 0;color:EXPR(col7);color2:EXPR(col7);" text="bind:useqtym" wordwrap="word"/>
                <Cell col="8" style="align:center top;padding:5 0 2 0;color:EXPR(col8);color2:EXPR(col8);" text="bind:useqtyy" wordwrap="word"/>
                <Cell col="9" style="align:center top;padding:5 0 2 0;color:EXPR(col9);color2:EXPR(col9);" text="bind:trethrd" wordwrap="word"/>
                <Cell col="10" style="align:center top;padding:5 0 2 0;color:EXPR(col10);color2:EXPR(col10);" text="bind:workdcntm" wordwrap="word"/>
                <Cell col="11" style="align:center top;padding:5 0 2 0;color:EXPR(col11);color2:EXPR(col11);" text="bind:tretmcnt" wordwrap="word"/>
                <Cell col="12" displaytype="combo" style="align:center top;padding:5 0 2 0;color:EXPR(col12);color2:EXPR(col12);" text="bind:ctnryn" wordwrap="word" combodataset="ds_cmb_ctnryn" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="13" displaytype="combo" style="align:center top;padding:5 0 2 0;color:EXPR(col13);color2:EXPR(col13);" text="bind:ctnrsignyn" wordwrap="word" combodataset="ds_cmb_ctnrsignyn" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="14" displaytype="combo" style="align:center top;padding:5 0 2 0;color:EXPR(col14);color2:EXPR(col14);" text="bind:msdsyn" wordwrap="word" combodataset="ds_cmb_msdsyn" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="15" text="bind:fstname"/>
                <Cell col="16" style="align:center;" text="bind:trnsname"/>
                <Cell col="17" text="bind:reptdd" mask="yyyy-mm-dd"/>
                <Cell col="18" text="bind:reptseq"/>
                <Cell col="19" text="bind:orguseqtym"/>
                <Cell col="20" text="bind:orguseqtyy"/>
                <Cell col="21" text="bind:orgusge"/>
                <Cell col="22" text="bind:orgtrethrd"/>
                <Cell col="23" text="bind:orgworkdcntm"/>
                <Cell col="24" text="bind:orgtretmcnt"/>
                <Cell col="25" text="bind:orgctnryn"/>
                <Cell col="26" text="bind:orgctnrsignyn"/>
                <Cell col="27" text="bind:orgmsdsyn"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" class="line_10" position="absolute 235 135 1193 141" anchor="left top right"/>
        <Static id="caption3" text="조사 내역" class="tit_2" position="absolute 235 119 315 140"/>
        <Grid id="grd_excellist" taborder="7" binddataset="ds_main_excellist" useinputpanel="false" visible="false" position="absolute 280 230 968 330">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="83"/>
                <Column size="34"/>
                <Column size="135"/>
                <Column size="35"/>
                <Column size="73"/>
                <Column size="34"/>
                <Column size="126"/>
                <Column size="93"/>
                <Column size="93"/>
                <Column size="83"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="45"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="43"/>
                <Column size="49"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="보고일자" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="순번" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="부서명" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="구분" taborder="undefined"/>
                <Cell col="4" rowspan="2" text="적용시작&#10;일자" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="물질&#10;코드" taborder="undefined"/>
                <Cell col="6" rowspan="2" text="물질명" taborder="undefined"/>
                <Cell col="7" rowspan="2" text="제조사" taborder="undefined"/>
                <Cell col="8" rowspan="2" text="공급처" taborder="undefined"/>
                <Cell col="9" rowspan="2" text="용도" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="월&#10;사용량" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="연간&#10;사용량" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="1일&#10;취급시간" taborder="undefined"/>
                <Cell col="13" rowspan="2" text="월&#10;작업일수" taborder="undefined"/>
                <Cell col="14" rowspan="2" text="취급자&#10;수" taborder="undefined"/>
                <Cell col="15" rowspan="2" text="소분용기&#10;유무" taborder="undefined"/>
                <Cell col="16" rowspan="2" text="원용기&#10;경고표지" taborder="undefined"/>
                <Cell col="17" rowspan="2" text="MSDS&#10;유무" taborder="undefined"/>
                <Cell col="18" rowspan="2" text="작성자" taborder="undefined"/>
              </Band>
              <Band id="body">
                <Cell displaytype="date" text="bind:reptdd" calendardisplaynulltype="nulltext"/>
                <Cell col="1" text="bind:reptseq"/>
                <Cell col="2" text="bind:deptnm"/>
                <Cell col="3" displaytype="combo" edittype="combo" text="bind:workflag" enable="false"/>
                <Cell col="4" displaytype="date" text="bind:appdd" calendardisplaynulltype="nulltext"/>
                <Cell col="5" text="bind:matrcd"/>
                <Cell col="6" text="bind:matrnm"/>
                <Cell col="7" text="bind:prodcmpynm"/>
                <Cell col="8" text="bind:maincustlastsuplplcenm"/>
                <Cell col="9" text="bind:usge"/>
                <Cell col="10" text="bind:useqtym"/>
                <Cell col="11" text="bind:useqtyy"/>
                <Cell col="12" text="bind:trethrd"/>
                <Cell col="13" text="bind:workdcntm"/>
                <Cell col="14" text="bind:tretmcnt"/>
                <Cell col="15" displaytype="combo" edittype="combo" text="bind:ctnryn" enable="false"/>
                <Cell col="16" displaytype="combo" edittype="combo" text="bind:ctnrsignyn" enable="false"/>
                <Cell col="17" displaytype="combo" edittype="combo" text="bind:msdsyn" enable="false"/>
                <Cell col="18" text="bind:fstname"/>
              </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="reptddfrom" type="STRING" size="256"/>
          <Column id="reptddto" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="prcsstat" type="STRING" size="256"/>
          <Column id="matrcd" type="STRING" size="256"/>
          <Column id="matrnm" type="STRING" size="256"/>
          <Column id="popflag" type="STRING" size="256"/>
          <Column id="confirmflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="reptddfrom"/>
            <Col id="reptddto"/>
            <Col id="deptcd"/>
            <Col id="deptnm"/>
            <Col id="prcsstat"/>
            <Col id="matrcd"/>
            <Col id="matrnm"/>
            <Col id="popflag"/>
            <Col id="confirmflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_reptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptdd" type="STRING" size="256" sumtext="보고일"/>
          <Column id="reptseq" type="STRING" size="256" sumtext="보고순번"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_matrlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptdd" type="STRING" size="256" sumtext="보고일"/>
          <Column id="reptseq" type="STRING" size="256" sumtext="보고순번"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="matrcd" type="STRING" size="256" sumtext="물질코드"/>
          <Column id="workflag" type="STRING" size="256" sumtext="작업구분"/>
          <Column id="appdd" type="STRING" size="256" sumtext="적용일"/>
          <Column id="useqtym" type="STRING" size="256" sumtext="월사용량"/>
          <Column id="useqtyy" type="STRING" size="256" sumtext="연간 사용량"/>
          <Column id="usge" type="STRING" size="256" sumtext="용도"/>
          <Column id="trethrd" type="STRING" size="256" sumtext="일 취급시간"/>
          <Column id="workdcntm" type="STRING" size="256" sumtext="월 작업일수"/>
          <Column id="tretmcnt" type="STRING" size="256" sumtext="취급자수"/>
          <Column id="ctnryn" type="STRING" size="256" sumtext="소분용기 유무"/>
          <Column id="ctnrsignyn" type="STRING" size="256" sumtext="원용기 경고표지 유무"/>
          <Column id="msdsyn" type="STRING" size="256" sumtext="msds 유무"/>
          <Column id="matrnm" type="STRING" size="256" sumtext="물질명"/>
          <Column id="prodcmpynm" type="STRING" size="256" sumtext="제조회사명"/>
          <Column id="maincustlastsuplplcenm" type="STRING" size="256" sumtext="주거래처명"/>
          <Column id="fstid" type="STRING" size="256" sumtext="최초등록자ID"/>
          <Column id="fstname" type="STRING" size="256" sumtext="최초등록자명"/>
          <Column id="orguseqtym" type="STRING" size="256" sumtext="월사용량"/>
          <Column id="orguseqtyy" type="STRING" size="256" sumtext="연간 사용량"/>
          <Column id="orgusge" type="STRING" size="256" sumtext="용도"/>
          <Column id="orgtrethrd" type="STRING" size="256" sumtext="일 취급시간"/>
          <Column id="orgworkdcntm" type="STRING" size="256" sumtext="월 작업일수"/>
          <Column id="orgtretmcnt" type="STRING" size="256" sumtext="취급자수"/>
          <Column id="orgctnryn" type="STRING" size="256" sumtext="소분용기 유무"/>
          <Column id="orgctnrsignyn" type="STRING" size="256" sumtext="원용기 경고표지 유무"/>
          <Column id="orgmsdsyn" type="STRING" size="256" sumtext="MSDS여부"/>
          <Column id="color" type="STRING" size="256"/>
          <Column id="trnsname" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cmb_workflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">-</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">신규</Col>
            <Col id="value">N</Col>
          </Row>
          <Row>
            <Col id="label">변경</Col>
            <Col id="value">C</Col>
          </Row>
          <Row>
            <Col id="label">중단</Col>
            <Col id="value">S</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_ctnryn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">-</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">Y</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">N</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_ctnrsignyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">-</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">Y</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">N</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cmb_msdsyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">-</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">Y</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">N</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_excellist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptdd" type="STRING" size="256" sumtext="보고일"/>
          <Column id="reptseq" type="STRING" size="256" sumtext="보고순번"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="matrcd" type="STRING" size="256" sumtext="물질코드"/>
          <Column id="workflag" type="STRING" size="256" sumtext="작업구분"/>
          <Column id="appdd" type="STRING" size="256" sumtext="적용일"/>
          <Column id="useqtym" type="STRING" size="256" sumtext="월사용량"/>
          <Column id="useqtyy" type="STRING" size="256" sumtext="연간 사용량"/>
          <Column id="usge" type="STRING" size="256" sumtext="용도"/>
          <Column id="trethrd" type="STRING" size="256" sumtext="일 취급시간"/>
          <Column id="workdcntm" type="STRING" size="256" sumtext="월 작업일수"/>
          <Column id="tretmcnt" type="STRING" size="256" sumtext="취급자수"/>
          <Column id="ctnryn" type="STRING" size="256" sumtext="소분용기 유무"/>
          <Column id="ctnrsignyn" type="STRING" size="256" sumtext="원용기 경고표지 유무"/>
          <Column id="msdsyn" type="STRING" size="256" sumtext="msds 유무"/>
          <Column id="matrnm" type="STRING" size="256" sumtext="물질명"/>
          <Column id="prodcmpynm" type="STRING" size="256" sumtext="제조회사명"/>
          <Column id="maincustlastsuplplcenm" type="STRING" size="256" sumtext="주거래처명"/>
          <Column id="fstname" type="STRING" size="256" sumtext="최초등록자명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_prvg" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cnt" type="STRING" size="256" sumtext="권한유무(있으면 1, 없으면 0)"/>
        </ColumnInfo>
      </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="prodcmpynm" type="STRING" size="256"/>
          <Column id="maincustlastsuplplcenm" 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="prodcmpynm"/>
            <Col id="maincustlastsuplplcenm"/>
            <Col id="returntype"/>
            <Col id="selectyn"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_reptddfrom" propid="value" datasetid="ds_main_condition" columnid="reptddfrom"/>
      <BindItem id="item1" compid="grp_sea.ipt_reptddto" propid="value" datasetid="ds_main_condition" columnid="reptddto"/>
      <BindItem id="item2" compid="grp_sea.rdo_prcsstat" propid="value" datasetid="ds_main_condition" columnid="prcsstat"/>
      <BindItem id="item3" compid="grp_sea.ipt_deptcd" propid="value" datasetid="ds_main_condition" columnid="deptcd"/>
      <BindItem id="item4" compid="grp_sea.opt_deptnm" propid="value" datasetid="ds_main_condition" columnid="deptnm"/>
      <BindItem id="item5" compid="grp_sea.ipt_matrcd" propid="value" datasetid="ds_main_condition" columnid="matrcd"/>
      <BindItem id="item6" compid="grp_sea.opt_matrnm" propid="value" datasetid="ds_main_condition" columnid="matrnm"/>
    </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 SMRSM01100_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

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

function fOpenForm()
{
	var cur_yymm = String(utlf_getCurrentDate()).substr(0, 6);
	var month_day = utlf_getCurrentDate().toDate().getMonthDay();

	grp_sea.ipt_reptddfrom.value = cur_yymm + "01";
	grp_sea.ipt_reptddto.value = cur_yymm + month_day;
	
	grp_sea.rdo_prcsstat.value = "T";
	misfGridInit(grd_reptlist);
	misfGridInit(grd_matrlist);
	misfGridInit(grd_excellist);
	
	var oParam = {};
		oParam.id          = "TRRSM00403";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetMatrMngtPrvg";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_prvg=matrlist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRSM00403";

	tranf_submit(oParam);
}

function cf_TRRSM00403(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		if(ds_init_prvg.getColumn(0, "cnt") == "1")
		{
			btn_save.visible = true;
			btn_send.visible = true;
		}
	}
}

function grp_sea_ipt_reptddfrom_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	misfGridInit(grd_matrlist);
}

function grp_sea_ipt_reptddto_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	misfGridInit(grd_matrlist);
}

function grp_sea_rdo_prcsstat_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	if(ds_init_prvg.getColumn(0, "cnt") == "1") 
	{
		if(obj.value == "T")
		{
			btn_save.enable = true;
			btn_send.enable = true;
		}
		else
		{
			btn_save.enable = false;
			btn_send.enable = false;
		}								
	}	
	
	misfGridInit(grd_reptlist);	
	misfGridInit(grd_matrlist);	
}

function ds_main_condition_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "deptcd")
	{
		var objFocus = this.getFocus();
		misfGridInit(grd_matrlist); 
		
		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")
	{
		misfGridInit(grd_matrlist); 
		
		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", ds_main_condition,"", recv_list);

	if(vOrigDeptcd != grp_sea.ipt_deptcd.value) 
	{
		misfGridInit(grd_matrlist); 
	}	
}

function grp_sea_btn_matrcd_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_popmatr.clearData();
	ds_popmatr.addRow();
	
	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") 
	{
		misfGridInit(grd_matrlist);
		
		ds_main_condition.setColumn(0, "matrnm", ds_popmatr.getColumn(0, "matrnm"));
		ds_main_condition.setColumn(0, "matrcd", ds_popmatr.getColumn(0, "matrcd"));	
	}
}

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

function fGetReptList() 
{
	if(String(ds_main_condition.getColumn(0, "reptddfrom")).length != 8 )
	{
		sysf_messageBox("보고일자를 정확하게 입력하십시요. ", "E999", "");
		grp_sea.ipt_reptddfrom.setFocus();
		return;
	}
	
	if(String(ds_main_condition.getColumn(0, "reptddto")).length != 8 )
	{
		sysf_messageBox("보고일자를 정확하게 입력하십시요. ", "E999", "");
		grp_sea.ipt_reptddto.setFocus();
		return;
	}	
	
	grp_sea.ipt_deptcd.value = grp_sea.ipt_deptcd.value.getTrim();
	grp_sea.ipt_matrcd.value = grp_sea.ipt_matrcd.value.getTrim();
			
	misfGridInit(grd_reptlist);
	misfGridInit(grd_matrlist);					
	misfGridInit(grd_excellist);
	
	var oParam = {};
		oParam.id          = "TRRSM01101";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetReptList";
		oParam.inds        = "req=ds_main_condition";
		oParam.outds       = "ds_main_reptlist=reptlist ds_main_excellist=excellist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSM01101";

	tranf_submit(oParam);
}

function grp_sea_btn_excelAll_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_excellist, "화학물질 취급관리 조사 내역 전체", "SheetName1", "false");
}

function grd_reptlist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	if(ds_main_reptlist.rowcount < 1) 
	{
		return;
	}
						
	misfGridInit(grd_matrlist);						
	
	ds_send.clearData();
	dsf_makeValue(ds_send, "reptdd", "string", ds_main_reptlist.getColumn(e.row, "reptdd"), 0);
	dsf_makeValue(ds_send, "reptseq", "string", ds_main_reptlist.getColumn(e.row, "reptseq"), 0);
	dsf_makeValue(ds_send, "deptcd", "string", ds_main_reptlist.getColumn(e.row, "deptcd"), 0);
	
	var oParam = {};
		oParam.id          = "TRRSM01102";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetMatrInvstList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_matrlist=matrlist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRSM01102";

	tranf_submit(oParam);
	
	grd_matrlist.setFocus();
}

function cf_TRRSM01102(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		ds_main_matrlist.addColumn("col6", "string");
		ds_main_matrlist.addColumn("col7", "string");
		ds_main_matrlist.addColumn("col8", "string");
		ds_main_matrlist.addColumn("col9", "string");
		ds_main_matrlist.addColumn("col10", "string");
		ds_main_matrlist.addColumn("col11", "string");
		ds_main_matrlist.addColumn("col12", "string");
		ds_main_matrlist.addColumn("col13", "string");
		ds_main_matrlist.addColumn("col14", "string");
		
		for(var irow = 0; irow < ds_main_matrlist.rowcount; irow++) 
		{	
			var flag = ds_main_matrlist.getColumn(irow, "workflag");
			
			if(utlf_isNull(flag))
			{
				ds_main_matrlist.setColumn(irow, "color", "");
			} 
			else if(flag == "N") 
			{
				ds_main_matrlist.setColumn(irow, "color", "#ff0000");
			} 
			else if(flag == "C") 
			{
				ds_main_matrlist.setColumn(irow, "color", "#ff0000");
				
				var iFlagCol = grd_matrlist.getBindCellIndex("body", "workflag");
			
				fSetStyleAndFlag("usge", irow, iFlagCol);
				fSetStyleAndFlag("useqtym", irow, iFlagCol);
				fSetStyleAndFlag("useqtyy", irow, iFlagCol);
				fSetStyleAndFlag("trethrd", irow, iFlagCol);
				fSetStyleAndFlag("workdcntm", irow, iFlagCol);
				fSetStyleAndFlag("tretmcnt", irow, iFlagCol);
				fSetStyleAndFlag("ctnryn", irow, iFlagCol);
				fSetStyleAndFlag("ctnrsignyn", irow, iFlagCol);
				fSetStyleAndFlag("msdsyn", irow, iFlagCol);
				
			} 
			else if(flag == "S") 
			{
				ds_main_matrlist.setColumn(irow, "color", "#ff0000");
			}	
		}	
	}
}

function fSetStyleAndFlag(pColname, pRow, pFlagCol)
{									
	var pCol = pColname;
													
	ds_main_matrlist.enableevent = false;
	ds_main_matrlist.updatecontrol = false;
	
	if(ds_main_matrlist.getColumn(pRow, pCol) == ds_main_matrlist.getColumn(pRow, "org"+pColname))
	{
		ds_main_matrlist.setColumn(pRow, "col" + grd_matrlist.getBindCellIndex("body", pCol), "");		
	} 
	else 
	{
		ds_main_matrlist.setColumn(pRow, "col" + grd_matrlist.getBindCellIndex("body", pCol), "#ff0000");
		ds_main_matrlist.setColumn(pRow, "col" + grd_matrlist.getBindCellIndex("body", pFlagCol), "#ff0000");						
	}
	ds_main_matrlist.updatecontrol = true;
	ds_main_matrlist.enableevent = true;	
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_matrlist, "화학물질 취급관리 조사 내역", "SheetName1", "false");
}

function btn_send_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_matrlist.rowcount == 0) return;

	if (sysf_messageBox( "해당 조사내역을 전송취소 하시겠습니까? ", "Q999", "") != 6 ) return;

	fClickSendBtn();
}

function fClickSendBtn() 
{
	ds_send.clearData();
	dsf_makeValue(ds_send, "reptdd", "string", ds_main_reptlist.getColumn(ds_main_reptlist.rowposition, "reptdd"), 0);
	dsf_makeValue(ds_send, "reptseq", "string", ds_main_reptlist.getColumn(ds_main_reptlist.rowposition, "reptseq"), 0);
	
	var oParam = {};
		oParam.id          = "TXRSM01101";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqExeSaveMatrInvestSendNot";
		oParam.inds        = "req=ds_send";
		oParam.async       = false;
		oParam.callback    = "cf_TXRSM01101";

	tranf_submit(oParam);
}

function cf_TXRSM01101(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		fGetReptList();
	}
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_matrlist.rowcount == 0) return;
	
	if (sysf_messageBox( "해당 조사 내역을 확정처리 하시겠습니까? ", "Q999", "") != 6 ) return;

	fClickSaveBtn();
}

function fClickSaveBtn() 
{
	ds_main_matrlist.updatecontrol = false;
	for(var i = 0; i < ds_main_matrlist.rowcount; i++) 
	{
		ds_main_matrlist.setRowType(i, "u");
	}
	ds_main_matrlist.updatecontrol = true;
	
	ds_send.clearData();
	dsf_makeValue(ds_send, "reptdd", "string", ds_main_reptlist.getColumn(ds_main_reptlist.rowposition, "reptdd"), 0);
	dsf_makeValue(ds_send, "reptseq", "string", ds_main_reptlist.getColumn(ds_main_reptlist.rowposition, "reptseq"), 0);
		
	var oParam = {};
		oParam.id          = "TXRSM01102";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqExeSaveMatrConfirm";
		oParam.inds        = "req=ds_send matrlist=ds_main_matrlist:u";
		oParam.async       = false;
		oParam.callback    = "cf_TXRSM01102";

	tranf_submit(oParam);
}

function cf_TXRSM01102(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		fGetReptList();
	}
}

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