YNU_JEUS/app_home/himed/xpapps/mis/acntbaseinfoxp/xp/SMRAC01300_법인카드모니터링.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAC01300" position="absolute 0 0 1198 758" titletext="법인카드모니터링" oninit="SMRAC01300_oninit" onload="SMRAC01300_onload">
    <Layouts>
      <Layout>
        <Div id="grp_sea" taborder="14" position="absolute 1 42 1193 82" class="div_SA2" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="0" text="조회" class="btn1" position="absolute 1116 8 1172 30" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Shape id="line6" linetype="vertical" position="absolute 1098 8 1104 30" anchor="top right"/>
              <Edit id="ipt_usernm" taborder="2" class="input_default" position="absolute 885 11 1025 30" anchor="left top" autoselect="true" autoskip="true"/>
              <Static id="caption11" text="사용자" class="search_name" position="absolute 816 13 880 30" anchor="left top"/>
              <Edit id="ipt_deptnm" taborder="3" class="input_default" position="absolute 660 11 800 30" anchor="left top" autoselect="true" autoskip="true"/>
              <Static id="caption7" text="부서명" class="search_name" position="absolute 591 13 655 30" anchor="left top"/>
              <MaskEdit id="ipt_cardno" taborder="4" mask="9999-9999-9999-9999" class="input_default" position="absolute 435 11 575 30" anchor="left top" autoselect="true" autoskip="true"/>
              <Static id="caption6" text="카드번호" class="search_name" position="absolute 356 13 435 30" anchor="left top"/>
              <Calendar id="ipt_cnfmddto" taborder="5" class="input_default" position="absolute 213 11 313 30" mask="yyyy-mm-dd" anchor="left top" dateformat="yyyy-MM-dd" value="null" autoselect="true" autoskip="true"/>
              <Static id="caption2" text="~" position="absolute 198 15 213 30" anchor="left top"/>
              <Calendar id="ipt_cnfmddfrom" taborder="6" class="input_default" position="absolute 97 11 197 30" mask="yyyy-mm-dd" anchor="left top" dateformat="yyyy-MM-dd" value="null" autoselect="true" autoskip="true"/>
              <Static id="cap_instcd" text="승인일자" class="search_name" position="absolute 26 13 89 30" anchor="left top"/>
            </Layout>
          </Layouts>
        </Div>
        <Static text="법인카드 모니터링" position="absolute 0 0 147 25" id="caption1" class="tit_1" anchor="left top"/>
        <Shape id="line2" linetype="horizontal" class="line_6" position="absolute 0 38 1195 44" anchor="left top right"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1139 19 1195 41" onclick="btn_save_onclick" anchor="top right"/>
        <Button id="btn_upload" taborder="4" text="엑셀 Upload" class="btn7" position="absolute 969 93 1063 112" onclick="btn_upload_onclick" anchor="top right"/>
        <Static id="caption4" text="승인내역" class="tit_2" position="absolute 1 94 114 111" anchor="left top"/>
        <Button id="btn_excel" taborder="7" text="엑셀출력" class="btn7" position="absolute 1122 93 1194 112" onclick="btn_excel_onclick" anchor="top right"/>
        <Grid id="grd_itemlist" taborder="8" binddataset="ds_main_iteminfo_itemlist" useinputpanel="false" position="absolute 0 116 1195 708" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25"/>
                <Column size="56"/>
                <Column size="147"/>
                <Column size="59"/>
                <Column size="39"/>
                <Column size="121"/>
                <Column size="68"/>
                <Column size="55"/>
                <Column size="61"/>
                <Column size="72"/>
                <Column size="71"/>
                <Column size="75"/>
                <Column size="100"/>
                <Column size="108"/>
                <Column size="68"/>
                <Column size="100"/>
                <Column size="205"/>
              </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" rowspan="2" text="카드&#13;&#10;구분" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="카드소지자" taborder="undefined"/>
                <Cell col="6" rowspan="2" text="거래은행" taborder="undefined"/>
                <Cell col="7" rowspan="2" text="사용&#13;&#10;구분" taborder="undefined"/>
                <Cell col="8" rowspan="2" text="매출종류" taborder="undefined"/>
                <Cell col="9" rowspan="2" text="할부기간" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="승인일자" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="승인시간" taborder="undefined"/>
                <Cell col="12" rowspan="2" text="승인번호" taborder="undefined"/>
                <Cell col="13" rowspan="2" text="가맹점명/국가명" taborder="undefined"/>
                <Cell col="14" rowspan="2" text="승인금액&#13;&#10;(원화)" taborder="undefined"/>
                <Cell col="15" rowspan="2" text="환율" taborder="undefined"/>
                <Cell col="16" rowspan="2" text="비고" taborder="undefined"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:headnm"/>
                <Cell col="2" style="align:left middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:deptnm"/>
                <Cell col="3" style="align:left middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cardno"/>
                <Cell col="4" style="align:left middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cardtp"/>
                <Cell col="5" style="align:left middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:usernm"/>
                <Cell col="6" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:banknm"/>
                <Cell col="7" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:ioflag"/>
                <Cell col="8" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:saleskind"/>
                <Cell col="9" style="align:right middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:instprd"/>
                <Cell col="10" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cnfmdt"/>
                <Cell col="11" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cnfmtm"/>
                <Cell col="12" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cnfmno"/>
                <Cell col="13" style="align:left middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:busnnm"/>
                <Cell col="14" displaytype="number" edittype="masknumber" style="align:right middle;color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cnfmamtk" mask="999,999"/>
                <Cell col="15" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:exchrate"/>
                <Cell col="16" style="color:BIND(fontcolor);color2:BIND(fontcolor);" text="bind:cmt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption9" text="특정요일(토,일,공휴일) : 파랑색(●)" position="absolute 270 736 470 755" style="color:blue;" anchor="left bottom"/>
        <Shape id="line7" linetype="horizontal" class="line_10" position="absolute 0 111 1195 117" anchor="left top right"/>
        <Button id="btn_delete" taborder="11" text="행삭제" class="btn2" position="absolute 1066 93 1119 112" onclick="btn_delete_onclick" anchor="top right"/>
        <Static id="caption8" text="※ 1. 엑셀자료를 Upload 할 경우, 3000건 기준 4~5분 정도 소요될 수 있습니다. 화면에 자료가 보여질 때까지 잠시만 기다려 주십시요." position="absolute 0 718 724 738" anchor="left bottom"/>
        <Static id="caption10" text="특정시간대(22:00~익일08:30) : 붉은색(○)" position="absolute 30 736 265 756" style="color:red;" anchor="left bottom"/>
        <Static id="caption12" text="2." position="absolute 15 736 30 755" anchor="left bottom"/>
        <Static id="cp_totalcnt" text="총" position="absolute 812 92 837 112" anchor="top right"/>
        <MaskEdit id="ipt_itemcnt" taborder="13" class="input_default" enable="false" position="absolute 840 93 915 112" usebitmapcache="false" type="number" trimtype="none" anchor="top right"/>
        <Static id="caption13" text="건" position="absolute 918 93 943 113" anchor="top right"/>
        <Div position="absolute 275 197 910 477" id="grp_dupinfo" visible="false" style="border:1 solid #808080ff ;">
          <Layouts>
            <Layout>
              <Static text="아래 승인내역이 중복되어 작업을 중단합니다." position="absolute 15 15 304 32" id="caption3" class="tit_2" style="color:red;"/>
              <Grid position="absolute 15 36 619 246" id="grd_duplist" binddataset="ds_temp_dupinfo_duplist">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25"/>
                      <Column size="90"/>
                      <Column size="134"/>
                      <Column size="80"/>
                      <Column size="130"/>
                      <Column size="130"/>
                    </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"/>
                      <Cell col="1" text="bind:flagcd"/>
                      <Cell col="2" text="bind:cardno"/>
                      <Cell col="3" text="bind:cnfmno"/>
                      <Cell col="4" text="bind:cnfmamtk"/>
                      <Cell col="5" text="bind:cnfmamtf"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button position="absolute 560 250 616 272" id="btn_close" class="btn4" taborder="8" text="닫기" onclick="grp_dupinfo_btn_close_onclick"/>
              <Shape position="absolute 14 31 619 37" linetype="horizontal" id="line1" class="line_10"/>
              <Button position="absolute 543 10 619 29" align="align:left middle;" id="button1" class="btn7" taborder="6" text="엑셀출력" onclick="grp_dupinfo_button1_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_iteminfo_itemlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="flagcd" type="STRING"/>
          <Column id="cardno" type="STRING"/>
          <Column id="cardtp" type="STRING"/>
          <Column id="acctno" type="STRING"/>
          <Column id="banknm" type="STRING"/>
          <Column id="usernm" type="STRING"/>
          <Column id="ioflag" type="STRING"/>
          <Column id="cnfmno" type="STRING"/>
          <Column id="cnfmdt" type="STRING"/>
          <Column id="cnfmtm" type="STRING"/>
          <Column id="saleskind" type="STRING"/>
          <Column id="cnfmamtk" type="STRING"/>
          <Column id="cnfmamtf" type="STRING"/>
          <Column id="amtsign" type="STRING"/>
          <Column id="amt" type="STRING"/>
          <Column id="addtax" type="STRING"/>
          <Column id="svcamt" type="STRING"/>
          <Column id="instprd" type="STRING"/>
          <Column id="exchrate" type="STRING"/>
          <Column id="naticd" type="STRING"/>
          <Column id="natinm" type="STRING"/>
          <Column id="busnid" type="STRING"/>
          <Column id="busnnm" type="STRING"/>
          <Column id="induflag" type="STRING"/>
          <Column id="zipcd" type="STRING"/>
          <Column id="addr1" type="STRING"/>
          <Column id="addr2" type="STRING"/>
          <Column id="telno" type="STRING"/>
          <Column id="acntcd" type="STRING"/>
          <Column id="acntnm" type="STRING"/>
          <Column id="headnm" type="STRING"/>
          <Column id="deptnm" type="STRING"/>
          <Column id="cmt" type="STRING"/>
          <Column id="chk" type="STRING"/>
          <Column id="fontcolor" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_dupinfo_duplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="flagcd" type="STRING"/>
          <Column id="cardno" type="STRING"/>
          <Column id="cnfmno" type="STRING"/>
          <Column id="cnfmamtk" type="STRING"/>
          <Column id="cnfmamtf" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cnfmddfrom" type="STRING" size="256"/>
          <Column id="cnfmddto" type="STRING" size="256"/>
          <Column id="cardno" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="usernm" type="STRING" size="256"/>
          <Column id="cmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="itemcnt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="Dataset00" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_cnfmddfrom" propid="value" datasetid="ds_send_search" columnid="cnfmddfrom"/>
      <BindItem id="item1" compid="grp_sea.ipt_cnfmddto" propid="value" datasetid="ds_send_search" columnid="cnfmddto"/>
      <BindItem id="item2" compid="grp_sea.ipt_cardno" propid="value" datasetid="ds_send_search" columnid="cardno"/>
      <BindItem id="item3" compid="grp_sea.ipt_deptnm" propid="value" datasetid="ds_send_search" columnid="deptnm"/>
      <BindItem id="item4" compid="grp_sea.ipt_usernm" propid="value" datasetid="ds_send_search" columnid="usernm"/>
    </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 "ast_tumorelctxp::combolist.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_acntcommonxp::RAD001.xjs";

function SMRAC01300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAC01300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_setRowTypeIcon(grd_itemlist, 0);
	grdf_setRowTypeIcon(grp_dupinfo.grd_duplist, 0);
	misfGridInit(grd_itemlist);
	misfGridInit(grp_dupinfo.grd_duplist);
	ds_send_search.setColumn(0, "cnfmddfrom", utlf_getCurrentDate());	//승인일자 설정
	ds_send_search.setColumn(0, "cnfmddto", utlf_getCurrentDate());		//승인일자 설정 
	ds_send_search.setColumn(0, "cnfmddfrom", "20170101");
	ds_send_search.setColumn(0, "cnfmddto", "20170102");
	grp_sea.btn_search.click();
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_send_search.getColumn(0, "cnfmddfrom").length != 8)
	{
		sysf_messageBox("승인일자를 확인하십시요 ", "I999", "");
		grp_sea.ipt_cnfmddfrom.setFocus();
		return;
	}
	if(ds_send_search.getColumn(0, "cnfmddto").length != 8)
	{
		sysf_messageBox("승인일자를 확인하십시요 ", "I999", "");
		grp_sea.ipt_cnfmddto.setFocus();
		return;
	}					
	
	misfGridInit(grd_itemlist);
	
	var oParam = {};
		oParam.id          = "TRRAC01302";
		oParam.service     = "acntbaseinfoapp.AcntBaseInfo";
		oParam.method      = "reqGetCardCnfmList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_iteminfo_itemlist=itemlist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAC01302";
	tranf_submit(oParam);
}

function cf_TRRAC01302(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		//특정요일 및 특정시간대 구분표시
		//가. 특정요일(토,일,공휴일) : 파랑색    --> 적용안함(2017.08.14)
		//나. 특정시간대(22:00~익일06:00) : 붉은색
		//check 컬럼에 값이 ● 이면 파랑색 ○ 이면 빨강색
		ds_main_iteminfo_itemlist.updatecontrol = false;
		for(var i = 0; i < ds_main_iteminfo_itemlist.rowcount; i++)
		{
			if(ds_main_iteminfo_itemlist.getColumn(i, "chk") == "○")
			{
				ds_main_iteminfo_itemlist.setColumn(i, "fontcolor", "#FF0000");
			}
			else
			{
				ds_main_iteminfo_itemlist.setColumn(i, "fontcolor", "");
			}
		}
		ds_main_iteminfo_itemlist.updatecontrol = true;
		
		//총건수 표시
		ipt_itemcnt.value = ds_main_iteminfo_itemlist.rowcount;
	}
}
function btn_upload_onclick(obj:Button,  e:ClickEventInfo)
{
	sysf_messageBox("엑셀 Upload를 하실 때는 반드시 양식에 맞게 입력해주셔야 합니다.", "I999", "");
					
	var fd = new FileDialog();
	var file = fd.open("open", FileDialog.LOAD,"%MYDOCUMENT%");
	file.open(VirtualFile.openRead | VirtualFile.openBinary);

	file.close();

	var objExtCommon = new ExtCommon();
	ds_main_iteminfo_itemlist.clearData();
	objExtCommon.excelImportByIndex(file.fullpath, 0,"ds_main_iteminfo_itemlist");
	div.grd_tmp.createFormat();
	
	
	if(!utlf_isNull(file))
	{
		//타이틀에 해당하는 첫행은 자동 삭제되도록 수정
		for(var i = 0; i < ds_main_iteminfo_itemlist.rowcount; i++)
		{
			var arrPostion = new Array();
				arrPostion[0] = i;
			grdf_setStatus(grd_itemlist, "I", arrPostion);
		}
		ipt_itemcnt.value = ds_main_iteminfo_itemlist.rowcount;
		
		sysf_messageBox("Upload 가 완료되었습니다. \n데이터를 확인 후 저장버튼을 누르십시요." , "I999", "");
	}	
}

//행삭제
function btn_delete_onclick(obj:Button,  e:ClickEventInfo)
{
	var sRow = ds_main_iteminfo_itemlist.rowposition;
	var status = ds_main_iteminfo_itemlist.getRowType(sRow);


	//엑셀 Upload한 상태에서만 행삭제가 가능토록 한다.
	if(status == 4)
	{
		sysf_messageBox("행삭제는 엑셀 Upload 후 자료 저장 전까지만 사용이 가능합니다. ", "E999", "");
		return;
	}	
	
	if(sysf_messageBox( "선택한 행을 삭제하시겠습니까?", "Q999","") != 6)
	{
		return; 
	}
	
	ds_main_iteminfo_itemlist.deleteRow(ds_main_iteminfo_itemlist.rowposition);

	ipt_itemcnt.value = ds_main_iteminfo_itemlist.rowcount;
}

//엑셀출력
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_itemlist, "승인내역" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
}

//저장
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	ExecData();
}

function ExecData()
{
	var oParam = {};
		oParam.id          = "TXRAC01301";
		oParam.service     = "acntbaseinfoapp.AcntBaseInfo";
		oParam.method      = "reqSaveCardCnfmList";
		oParam.inds        = "req=ds_main_iteminfo_itemlist:U";
		oParam.outds       = "ds_temp_dupinfo_duplist=duplist";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAC01301";

	tranf_submit(oParam);
}

function cf_TXRAC01301(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) return;
    else
    {		 //저장 중 중복내역이 존재하면
		//f(grd_duplist.rows > grd_duplist.fixedRows)
		if(ds_temp_dupinfo_duplist.rowcount > 0)
		{
			grp_dupinfo.visible = true;
		} 
		else
		{
			misfGridInit(grd_itemlist);
			
			sysf_messageBox("저장되었습니다. \n조회를 통해 저장된 자료를 다시 한번 확인하십시요. ", "I999", "");
		}
		
    
    }
}

function grp_dupinfo_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_itemlist, "중복내역" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
}

function grp_dupinfo_btn_close_onclick(obj:Button,  e:ClickEventInfo)
{
	grp_dupinfo.visible = false;
}
]]></Script>
  </Form>
</FDL>