YNU_JEUS/app_home/himed/xpapps/mis/stocsumxp/xp/SMRST03500_기간별제조사별구입량현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRST03500" position="absolute 0 0 1199 758" titletext="기간별제조사별구입량현황" oninit="SMRST03500_oninit" onload="SMRST03500_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 48 1195 83" align="align:center top;" id="group6" class="div_SA">
          <Layouts>
            <Layout>
              <Static text="입고일자 :" position="absolute 13 9 99 26" id="caption2" class="search_name"/>
              <Button position="absolute 1125 7 1181 29" id="btn_sea" class="btn1" taborder="3" text="조회" onclick="group6_btn_sea_onclick"/>
              <Calendar position="absolute 100 9 214 28" id="ipt_winfromdd" class="input_essential" taborder="1" autoselect="true"/>
              <Calendar position="absolute 238 9 352 28" id="ipt_wintodd" class="input_essential" taborder="2" autoselect="true"/>
              <Static text="~" position="absolute 220 9 235 29" align="align:center middle;" id="caption22"/>
            </Layout>
          </Layouts>
        </Div>
        <Tab position="absolute 0 84 1195 752" id="sw_flag" class="sw_box" onchanged="sw_flag_onchanged">
          <Tabpages>
            <Tabpage text="월별" id="case_grid">
              <Layouts>
                <Layout>
                  <Shape position="absolute 0 25 1195 31" linetype="horizontal" id="line15" class="line_10"/>
                  <Static text="기간별 제조사별 구입량 현황" position="absolute 1 9 216 27" id="caption3" class="tit_2"/>
                  <Grid position="absolute 0 30 1191 640" id="grd_winqty" binddataset="ds_main_winqtylist">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="24"/>
                          <Column size="0"/>
                          <Column size="120"/>
                          <Column size="400"/>
                          <Column size="250"/>
                          <Column size="250"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="입고년"/>
                          <Cell col="2" text="입고년월"/>
                          <Cell col="3" text="제조사"/>
                          <Cell col="4" text="입고수량"/>
                          <Cell col="5" text="입고금액"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow + 1"/>
                          <Cell col="1" text="bind:winyy" mask="####"/>
                          <Cell col="2" displaytype="text" style="background:EXPR(winmmBkcolor);background2:EXPR(winmmBkcolor);font:EXPR(prodcmpycdnmFont);" text="bind:winmm" mask="expr:winmm.length == 6 ? '####-##' : '' " maskchar=" " suppress="1" suppressalign="middle,over"/>
                          <Cell col="3" style="align:left middle;background:EXPR(prodcmpycdnmBkcolor);background2:EXPR(prodcmpycdnmBkcolor);font:EXPR(prodcmpycdnmFont);" text="bind:prodcmpycdnm"/>
                          <Cell col="4" displaytype="number" style="align:right middle;background:EXPR(prodcmpycdnmBkcolor);background2:EXPR(prodcmpycdnmBkcolor);font:EXPR(prodcmpycdnmFont);" text="bind:sumqty" mask="###,###,###.##"/>
                          <Cell col="5" displaytype="number" style="align:right middle;background:EXPR(prodcmpycdnmBkcolor);background2:EXPR(prodcmpycdnmBkcolor);font:EXPR(prodcmpycdnmFont);" text="bind:sumamt" mask="###,###,###.##"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Button position="absolute 1140 5 1190 24" id="button14" class="btn7" taborder="4" text="엑셀" onclick="sw_flag_case_grid_button14_onclick"/>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage text="거래처 별" id="case_report">
              <Layouts>
                <Layout>
                  <Div position="absolute 10 8 1185 635" id="grp_biz" scrollbars="autoboth">
                    <Layouts>
                      <Layout width="1175" height="627"/>
                    </Layouts>
                  </Div>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Static id="caption6" text="기간별 제조사별 구입량 현황" class="tit_1" position="absolute 0 0 213 25"/>
        <Button id="button34" taborder="1" text="출력" class="btn6" visible="false" position="absolute 0 25 56 47"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="winfromdd" type="STRING" size="256"/>
          <Column id="wintodd" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="winfromdd"/>
            <Col id="wintodd"/>
            <Col id="flag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_winqtylist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_properties_report_mainreport_params" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group6.ipt_winfromdd" propid="value" datasetid="ds_send" columnid="winfromdd"/>
      <BindItem id="item1" compid="group6.ipt_wintodd" propid="value" datasetid="ds_send" columnid="wintodd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::PIC002.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_miscommonxp::RBC001.xjs";
include "mis_miscommonxp::RSZ001.xjs";

var arErrorCode 	= new HashArray();
var RetrYn = "Y";
function SMRST03500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	//폼 초기화
}

function SMRST03500_onload(obj:Form, e:LoadEventInfo)
{
	//화면 Control을 초기화한다
	fInitialize();
}

function fInitialize() {		
			
	misfGridInit(sw_flag.case_grid.grd_winqty);

	var curdate = new Date();//getCurrentDate();
		
	group6.ipt_wintodd.value = curdate.getDateFormat();
	group6.ipt_winfromdd.value = curdate.getAddDate(-1, "M").getDateFormat();
		
	//makeReportPreview(0, 0,1160,600, "grp_biz");	
	sw_flag.tabindex = 0;
	
	ds_send.setColumn(0, "flag", "mnth");	
}

function group6_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
	misfMsterDetailRetrieve();	
	fRetrieve();
}

function fRetrieve() {
	if (!validCondition()) {
		return;
	} 	
	ds_main_winqtylist.clearData();	
	ds_properties_report_mainreport_params.clearData();
		
	fClearGrid(sw_flag.case_grid.grd_winqty);	
	
	var oParam = {};
		oParam.id          = "TRRST03501";
		oParam.service     = "stocsumapp.StocSumMngt";
		oParam.method      = "reqGetTermCustWinQtyList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_winqtylist=winqtylist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRST03501";

	tranf_submit(oParam);
	if (arErrorCode.pop("TRRST03501") > -1) {
		if (ds_send.getColumn(0, "flag") == "mnth") {
			fAfterRetrieve();
		} else {
// 			if (document.all("ivr_grp_biz")) {
// 				grp_biz.removeChild("ivr_grp_biz");
// 			}			
			var objDOM = rptf_createDOM();			
			rptf_setNodeListToDOM(objDOM, "root/main/winqtylist", ds_main_winqtylist);	// 데이터셋 1				
		
			var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source;														// 최상의노드 XML 스트링 추출
		
			var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
			//var option = "open=1;save=1;directprint=1;printdialog=0;print=1;zoom=0;";
			rptf_exeReportPreview30(["RPRST03501"],[objParam], option, "", "sw_flag.case_report.grp_biz");
		}		
	}	
}

function cf_TRRST03501(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
}

function validCondition() {
	if(utlf_transNullToEmpty(group6.ipt_winfromdd.value).length== 0 ) {
		sysf_messageBox("입고시작일자를 " ,"C001");
		group6.ipt_winfromdd.setFocus();
		return false;
	}
	
	if(utlf_transNullToEmpty(group6.ipt_wintodd.value).length== 0 ) {
		sysf_messageBox("입고종료일자를 " ,"C001");
		group6.ipt_wintodd.setFocus();		
		return false;
	}
	return true;
}

function fClearGrid(o) {
// 	for (var i = o.fixedRows; i <= o.rows; i++) {
// 		o.deleteRow(i);
// 	}
}

//조회후 그리드 셋팅
function fAfterRetrieve() {
	var iCnt = ds_main_winqtylist.rowcount;
		
	if(utlf_isNull(ds_main_winqtylist.getColumnInfo("winmmBkcolor"))){
		ds_main_winqtylist.addColumn("winmmBkcolor", "string");
		ds_main_winqtylist.addColumn("prodcmpycdnmBkcolor", "string");	
		ds_main_winqtylist.addColumn("prodcmpycdnmFont", "string");
	}
			
	for (var i = 0; i < iCnt; i++) {
		switch (ds_main_winqtylist.getColumn(i,  "lvl1") + "" + ds_main_winqtylist.getColumn(i, "lvl2") + "" + ds_main_winqtylist.getColumn(i, "lvl3") ) {
			case "110":								
				ds_main_winqtylist.setColumn(i, "winmmBkcolor", "#ccffff");
				ds_main_winqtylist.setColumn(i, "winmm", "제조사별 누계");
				break;
			case "111":
				ds_main_winqtylist.setColumn(i, "prodcmpycdnmBkcolor",  "#ffff99");
				ds_main_winqtylist.setColumn(i, "prodcmpycdnm",  "총 합계");
				break;
			case "001":
				ds_main_winqtylist.setColumn(i, "prodcmpycdnm",  ds_main_winqtylist.getColumn(i, "winmm")+" 소계");
				ds_main_winqtylist.setColumn(i, "prodcmpycdnmBkcolor",  "#ffff99");
				ds_main_winqtylist.setColumn(i, "winmmBkcolor", "#ffff99");
				
				ds_main_winqtylist.setColumn(i, "prodcmpycdnmFont",  "arial,9,bold");
				break;
			default:
				ds_main_winqtylist.setColumn(i, "prodcmpycdnmBkcolor",  "");
				ds_main_winqtylist.setColumn(i, "winmmBkcolor", "");				
				ds_main_winqtylist.setColumn(i, "prodcmpycdnmFont",  "");
				break;
		}
				
	}	
}

function sw_flag_case_grid_button14_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(sw_flag.case_grid.grd_winqty,"기간별제조사별구입량현황");
}

function sw_flag_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
{
	if(sw_flag.tabindex == 0){		
		ds_send.setColumn(0, "flag", "mnth");		
		group6_btn_sea_onclick();
	}else if(sw_flag.tabindex == 1){
		ds_send.setColumn(0, "flag", "prod");		
		group6_btn_sea_onclick();
	}
}
]]></Script>
  </Form>
</FDL>