YNU_JEUS/app_home/himed/xpapps/crm/crmxp/xp/SPCCN00600_외부파일가져오기.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPCCN00600" position="absolute 0 0 640 306" titletext="외부파일 가져오기" oninit="SPCCN00600_oninit" onload="SPCCN00600_onload">
    <Layouts>
      <Layout>
        <Static id="caption9" text="파일불러오기" class="tit_2" position="absolute 0 2 110 23"/>
        <Edit id="ipt_addfile" taborder="1" class="input_default" position="absolute 0 23 130 42" autoselect="true"/>
        <Button id="btn_addfile" taborder="2" text="찾아보기" class="btn2" position="absolute 135 23 199 42" onclick="btn_addfile_onclick"/>
        <Button id="btn_sample" taborder="3" text="샘플파일" class="btn2" position="absolute 205 23 269 42" onclick="btn_sample_onclick"/>
        <Shape id="line12" linetype="horizontal" class="line_10" position="absolute 0 18 269 24"/>
        <Grid id="grd_clntlist" taborder="4" binddataset="ds_main_list_clntlist" useinputpanel="false" position="absolute 0 43 270 255" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24" band="left"/>
                <Column size="20" band="left"/>
                <Column size="54" band="left"/>
                <Column size="86"/>
                <Column size="78"/>
                <Column size="70"/>
                <Column size="237"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1"/>
                <Cell col="2" text="성명"/>
                <Cell col="3" text="휴대폰"/>
                <Cell col="4" text="E-mail"/>
                <Cell col="5" text="우편번호"/>
                <Cell col="6" text="주소"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:chk" expr="expr:chk == 'Y' || chk == '1' ? 1 : 0"/>
                <Cell col="2" style="align:center middle;" text="bind:innrclntnm"/>
                <Cell col="3" style="align:center middle;" text="bind:mpphontel" mask="###########" maskchar=" "/>
                <Cell col="4" style="align:center middle;" text="bind:email"/>
                <Cell col="5" style="align:center middle;" text="bind:zipcd" mask="######" maskchar=" "/>
                <Cell col="6" style="align:center middle;" text="bind:address"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_all" taborder="5" text="All" class="btn2" position="absolute 0 43 44 68" onclick="btn_all_onclick"/>
        <Static id="caption1" text="총          명" position="absolute 196 259 266 274"/>
        <Edit id="opt_clncnt" taborder="6" readonly="true" position="absolute 209 256 244 275" autoselect="true" style="align:right middle;"/>
        <Button id="btn_conform" taborder="7" text="확인" class="btn4" position="absolute 517 278 573 300" onclick="btn_conform_onclick"/>
        <Button id="btn_close" taborder="8" text="닫기" class="btn4" position="absolute 574 278 630 300" onclick="btn_close_onclick"/>
        <Static id="caption2" text="받는사람" class="tit_2" position="absolute 361 2 436 23"/>
        <Static id="caption3" text="(          명 / 500명)" position="absolute 440 3 580 17"/>
        <Static id="opt_rcvcnt" position="absolute 446 4 478 17" style="align:right middle;"/>
        <Shape id="line2" linetype="horizontal" class="line_10" position="absolute 360 18 630 24"/>
        <Grid id="grd_rcevlist" taborder="9" binddataset="ds_main_list_rcevlist" useinputpanel="false" position="absolute 360 23 630 272" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="27" band="left"/>
                <Column size="20" band="left"/>
                <Column size="54" band="left"/>
                <Column size="86"/>
                <Column size="78"/>
                <Column size="70"/>
                <Column size="237"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1"/>
                <Cell col="2" text="성명"/>
                <Cell col="3" text="휴대폰"/>
                <Cell col="4" text="E-mail"/>
                <Cell col="5" text="우편번호"/>
                <Cell col="6" text="주소"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:chk" expr="expr:chk == 'Y' || chk == '1' ? 1 : 0"/>
                <Cell col="2" style="align:center middle;" text="bind:innrclntnm"/>
                <Cell col="3" style="align:center middle;" text="bind:mpphontel" mask="###########" maskchar=" "/>
                <Cell col="4" style="align:center middle;" text="bind:email"/>
                <Cell col="5" style="align:center middle;" text="bind:zipcd" mask="######" maskchar=" "/>
                <Cell col="6" style="align:center middle;" text="bind:address"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_allchk2" taborder="10" text="All" class="btn2" position="absolute 360 23 407 48" onclick="btn_allchk2_onclick"/>
        <Button id="bnt_add" taborder="11" text="추가" class="btn4" position="absolute 286 112 342 134" onclick="bnt_add_onclick"/>
        <Button id="btn_del" taborder="12" text="삭제" class="btn3" position="absolute 286 142 342 164" onclick="btn_del_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="filenm" 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="rcvcnt" type="STRING" size="256"/>
          <Column id="clncnt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="rcvcnt">0</Col>
            <Col id="clncnt">0</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_clntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_list_clntlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="chk" type="STRING" size="256"/>
          <Column id="innrclntnm" type="STRING" size="256"/>
          <Column id="mpphontel" type="STRING" size="256"/>
          <Column id="email" type="STRING" size="256"/>
          <Column id="zipcd" type="STRING" size="256"/>
          <Column id="address" type="STRING" size="256"/>
          <Column id="addyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="chk">N</Col>
            <Col id="innrclntnm"/>
            <Col id="mpphontel"/>
            <Col id="email"/>
            <Col id="zipcd"/>
            <Col id="address"/>
            <Col id="addyn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_rcevlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_list_rcevlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="chk" type="STRING" size="256"/>
          <Column id="innrclntnm" type="STRING" size="256"/>
          <Column id="mpphontel" type="STRING" size="256"/>
          <Column id="email" type="STRING" size="256"/>
          <Column id="zipcd" type="STRING" size="256"/>
          <Column id="address" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="chk">N</Col>
            <Col id="innrclntnm"/>
            <Col id="mpphontel"/>
            <Col id="email"/>
            <Col id="zipcd"/>
            <Col id="address"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_fwd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="ipt_addfile" propid="value" datasetid="ds_main_search" columnid="filenm"/>
      <BindItem id="item1" compid="opt_rcvcnt" propid="text" datasetid="ds_main" columnid="rcvcnt"/>
      <BindItem id="item2" compid="opt_clncnt" propid="value" datasetid="ds_main" columnid="clncnt"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
function SPCCN00600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPCCN00600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_clntlist);
	grdf_initGrid(grd_rcevlist);
	
	try
	{
		ds_fwd.copyData(arg_ds_fwd);
	}
	catch(e){}
	
	ds_main_list_clntlist.clearData();
	ds_main_list_rcevlist.clearData();	
}

function btn_addfile_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_ImportExcel("ds_main_list_clntlist", 0, grd_clntlist, 0);
}

function btn_sample_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_clntlist, "파일불러오기샘플", "주소록", "true", "", "");
}

function btn_all_onclick(obj:Button,  e:ClickEventInfo)
{
	fGridAllRow(grd_clntlist);
}

function btn_allchk2_onclick(obj:Button,  e:ClickEventInfo)
{
	fGridAllRow(grd_rcevlist);
}

function fGridAllRow(grid) 
{
	var rows = this.objects[grid.binddataset].rowcount;
	var fRow = 0;
	var chk = this.objects[grid.binddataset].getColumn(0, "chk");
	if(chk == "Y")
	{
		for(var i = fRow; i < rows; i++)
		{
			this.objects[grid.binddataset].setColumn(i, "chk", "N");
		}
	}
	else
	{
		for(var i = fRow; i < rows; i++)
		{
			this.objects[grid.binddataset].setColumn(i, "chk", "Y");
		}
	}
}

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

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

function bnt_add_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_main_list_clntlist.rowposition >= 0)
	{
		fGridRowAddRow(grd_clntlist,grd_rcevlist,"add");
	}
	else 
	{
		sysf_messageBox("추가할 대상이 없습니다.","E099");
		return false;
	}
}

function btn_del_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_main_list_rcevlist.rowposition >= 0)
	{
		fGridRowAddRow(grd_rcevlist,grd_clntlist,"del");
	} 
	else 
	{
		sysf_messageBox("삭제할 대상이 없습니다.","E099");
		return false;
	}	
}

function fGridRowAddRow(sndGrid, rcvGrid, type)
{
	var sndDataset = this.objects[sndGrid.binddataset];
	var rcvDataset = this.objects[rcvGrid.binddataset];
	var sRows = sndDataset.rowcount
	var sfRow = 0
	var cntRows = sndDataset.rowcount;
	var rRows = rcvDataset.rowcount;

	for(var i = sfRow; i < sRows; i++)
	{
		if(sndDataset.getColumn(i, "chk") == "Y" )
		{
			var addRow = rcvDataset.addRow();
			rcvDataset.setColumn(addRow, "innrclntnm", sndDataset.getColumn(i, "innrclntnm"));
			rcvDataset.setColumn(addRow, "mpphontel", sndDataset.getColumn(i, "mpphontel"));
			rcvDataset.setColumn(addRow, "email", sndDataset.getColumn(i, "email"));
			rcvDataset.setColumn(addRow, "zipcd", sndDataset.getColumn(i, "zipcd"));
			rcvDataset.setColumn(addRow, "address", sndDataset.getColumn(i, "address"));
		}
	}

	//추가된 사람 목록삭제
	for(var j = sRows; j >= sfRow; j--)
	{
		if(sndDataset.getColumn(j, "chk") == "Y")
		{
			sndDataset.deleteRow(j);
			cntRows--;
		}
	}

	if(type == "add")
	{
		ds_main.setColumn(0, "rcvcnt",rRows);//수신인 숫자				
		ds_main.setColumn(0, "clncnt",cntRows);//파일사람 숫자
	}
	else
	{
		ds_main.setColumn(0, "rcvcnt",cntRows);//수신인 숫자				
		ds_main.setColumn(0, "clncnt",rRows);//파일사람 숫자
	}
}

function btn_close_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}

function btn_conform_onclick(obj:Button,  e:ClickEventInfo)
{
	var type = ds_fwd.getColumn(0, "type");
	fConfirmAddRow(grd_rcevlist, type);
}

function fConfirmAddRow(grid, type)
{
	var rows = this.objects[grid.binddataset].rowcount;
	var fRow = 0;
	var chckTemp = "N";
	
	if(fRow < rows)
	{
		if(type == "sms")//문자
		{
			var pGrid = opener.ds_main_recvrinfo_recvrlist; //parent.grd_recvrlist;
			var pfRow = 0; 
			
			for(var i = fRow; i < rows; i++)
			{
				var prows = pGrid.addRow();
				pGrid.setColumn(prows, "recvrnm", this.objects[grid.binddataset].getColumn(i, "innrclntnm"));
				pGrid.setColumn(prows, "recvrtelno", this.objects[grid.binddataset].getColumn(i, "mpphontel"));
			}						
		}
		else if(type == "email") // 메일
		{
			var email="";

			for(var i = fRow; i < rows; i++)
			{
				email += this.objects[grid.binddataset].getColumn(i, "email");
				email +=";";
			}
			opener.ds_main_emailattr.setColumn(0, "recvremail",email);
		}
		else if(type == "refemail") // 참조메일
		{
			var email="";

			for(var i = fRow; i < rows; i++)
			{
					email += this.objects[grid.binddataset].getColumn(i, "email");
					email +=";";
			}
			opener.ds_main_emailattr.setColumn(0, "refemail",email);
		}
		else //DM
		{
			var pGrid = opener.ds_main_recvrinfo_recvrlist; //parent.grd_recvrlist;
			var pfRow = 0; //parent.grd_recvrlist.fixedRows;

			for(var i = fRow; i < rows; i++)
			{
				var prows = pGrid.addRow();
				pGrid.setColumn(prows, "recvrnm", this.objects[grid.binddataset].getColumn(i, "innrclntnm"));
				pGrid.setColumn(prows, "recvrzipcd", this.objects[grid.binddataset].getColumn(i, "zipcd"));
				pGrid.setColumn(prows, "recvraddr", this.objects[grid.binddataset].getColumn(i, "address"));
			}
		}
	}
	else
	{
		sysf_messageBox("받는 사람이 추가되지", "E007");
		return;
	}
	this.close();	
}	
]]></Script>
  </Form>
</FDL>