YNU_JEUS/app_home/himed/webapps/crm/crmweb/xrw/SPCCN00600_외부파일가져오기.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* Name		: SPCCN00600_외부파일가져오기.xrw
	* Summary	: 주소록 검색
	* Programmer	: 차재훈
	* Date Written	: 2008.06.17
	* History	: 
	* Remark	: 
-->
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>외부파일 가져오기</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list>
							<clntlist>
								<chk>N</chk>
								<innrclntnm/>
								<mpphontel/>
								<email/>
								<zipcd/>
								<address/>
								<addyn/>
							</clntlist>
							<rcevlist>
								<chk>N</chk>
								<innrclntnm/>
								<mpphontel/>
								<email/>
								<zipcd/>
								<address/>
							</rcevlist>
						</list>
						<search>
							<filenm/>
						</search>
						<rcvcnt>0</rcvcnt>
						<clncnt>0</clncnt>
					</main>
					<send>
						<data>
						</data>
						<innrgrupid/>
					</send>
					<fwd>
						<type/>
					</fwd>
				</root>
			</instance>
			<submission id="TRCMS00502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list"/>
			<submission id="TRCCM00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" replace="instance" add="bottom" resultref="/root/main/list"/>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					// 그리드를 초기화시킴.
					model.removenodeset("/root/main/list/clntlist");
					model.removenodeset("/root/main/list/rcevlist");
					grd_clntlist.removeRow();
					grd_rcevlist.removeRow();
				]]>
			</script>
		</model>
		<script type="javascript">
			<![CDATA[
			//----------------------------------------//
			// 체크된 행을 대상그리드에 추가 후 삭제  //
			//----------------------------------------//
			function fGridRowAddRow(sndGrid, rcvGrid, type){
				var sRows = sndGrid.rows;
				var sfRow = sndGrid.fixedRows;
				var cntRows = sndGrid.rows-1;
				var rRows = rcvGrid.rows;
				
				for(var i=sfRow; i<sRows; i++){
					if(sndGrid.valueMatrix(i,sndGrid.colRef("chk")) == "Y" ){
						rcvGrid.addRow();
						rcvGrid.valueMatrix(rRows, rcvGrid.colRef("innrclntnm")) = sndGrid.valueMatrix(i,sndGrid.colRef("innrclntnm"));
						rcvGrid.valueMatrix(rRows, rcvGrid.colRef("mpphontel")) = sndGrid.valueMatrix(i,sndGrid.colRef("mpphontel"));
						rcvGrid.valueMatrix(rRows, rcvGrid.colRef("email")) = sndGrid.valueMatrix(i,sndGrid.colRef("email"));
						rcvGrid.valueMatrix(rRows, rcvGrid.colRef("zipcd")) = sndGrid.valueMatrix(i,sndGrid.colRef("zipcd"));
						rcvGrid.valueMatrix(rRows, rcvGrid.colRef("address")) = sndGrid.valueMatrix(i,sndGrid.colRef("address"));
																			
						rRows++;	

					}//if
				}//for
				
				//추가된 사람 목록삭제
				for(var j=sRows; j>=sfRow; j--){
					if(sndGrid.valueMatrix(j,sndGrid.colRef("chk")) == "Y"){
						sndGrid.deleterow(j,false);
						cntRows--;
					}
				}
				
				if(type == "add"){
					model.setValue("/root/main/rcvcnt",rRows-1);//수신인 숫자				
					model.setValue("/root/main/clncnt",cntRows);//파일사람 숫자
				}else{
					model.setValue("/root/main/rcvcnt",cntRows);//수신인 숫자				
					model.setValue("/root/main/clncnt",rRows-1);//파일사람 숫자
				}
				model.refresh();
			}//func
			
			//----------------------------------------//
			// 그리드 전체 행 선택 함수               //
			//----------------------------------------//
			function fGridAllRow(grid) {
				var rows = grid.rows;
				var fRow = grid.fixedRows;
				var chk = grid.valueMatrix(1,grid.colRef("chk"));
				if(chk == "Y"){
					for(var i=fRow; i<rows; i++){
						grid.valueMatrix(i,grid.colRef("chk"))="N";
					}
				}else{
					for(var i=fRow; i<rows; i++){
						grid.valueMatrix(i,grid.colRef("chk"))="Y";
					}
				}
				model.refresh();
			}
			
			//----------------------------------------//
			// 추가된 목록을 부모창에 추가            //
			//----------------------------------------//	
			function fConfirmAddRow(grid, type){
				var rows = grid.rows;
				var fRow = grid.fixedRows;
				var chckTemp = "N";
				
				if(fRow<rows){
					if(type == "sms"){	//////////////문자			
						var pGrid = parent.grd_recvrlist;
						var prows = parent.grd_recvrlist.rows;
						var pfRow = parent.grd_recvrlist.fixedRows;
						
						for(var i=fRow; i<rows; i++){
//							if(pGrid.valueMatrix(prows, pGrid.colRef("recvrnm"))=="" && chckTemp == "N"){
//								pGrid.removeRow();
//								chckTemp = "Y";
//								prows = parent.grd_recvrlist.rows;
//							}
								pGrid.addRow();
								pGrid.valueMatrix(prows, pGrid.colRef("recvrnm")) = grid.valueMatrix(i,grid.colRef("innrclntnm"));
								pGrid.valueMatrix(prows, pGrid.colRef("recvrtelno")) = grid.valueMatrix(i,grid.colRef("mpphontel"));
																					
								prows++;	
							}						
					}else if(type == "email"){//////메일
						var email="";

						for(var i=fRow; i<rows; i++){
								email += grid.valueMatrix(i,grid.colRef("email"));
								email +=";";
							}
							parent.model.setValue("/root/main/emailattr/recvremail",email);
							parent.ipt_recvremail.refresh();
					}else if(type == "refemail"){//////참조메일
						var email="";

						for(var i=fRow; i<rows; i++){
								email += grid.valueMatrix(i,grid.colRef("email"));
								email +=";";
							}
							parent.model.setValue("/root/main/emailattr/refemail",email);
							parent.ipt_refemail.refresh();							
					}else{////////////////////////// dm
						var pGrid = parent.grd_recvrlist;
						var prows = parent.grd_recvrlist.rows;
						var pfRow = parent.grd_recvrlist.fixedRows;

						for(var i=fRow; i<rows; i++){
//							if(pGrid.valueMatrix(prows, pGrid.colRef("recvrnm"))=="" && chckTemp == "N"){
//								pGrid.removeRow();
//								chckTemp = "Y";
//								prows = parent.grd_recvrlist.rows;
//							}							
								pGrid.addRow();
								pGrid.valueMatrix(prows, pGrid.colRef("recvrnm")) = grid.valueMatrix(i,grid.colRef("innrclntnm"));
								pGrid.valueMatrix(prows, pGrid.colRef("recvrzipcd")) = grid.valueMatrix(i,grid.colRef("zipcd"));
								pGrid.valueMatrix(prows, pGrid.colRef("recvraddr")) = grid.valueMatrix(i,grid.colRef("address"));
								prows++;	
							}
					}
				}else{
					messageBox("받는 사람이 추가되지", "E007");
					return;
				}
				window.close();	
			}	

			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="640" pageheight="330" style="margin-left:8; margin-top:8; margin-right:8; margin-bottom:8; ">
		<group id="grp_Condition" scroll="auto" style="left:0px; top:0px; width:280px; height:285px; ">
			<caption id="caption9" class="tit_2" style="left:5px; top:10px; width:110px; height:13px; ">파일불러오기</caption>
			<input id="ipt_addfile" ref="/root/main/search/filenm" class="input_default" style="left:0px; top:31px; width:130px; height:19px; "/>
			<button id="btn_addfile" class="btn2_letter4" style="left:135px; top:31px; width:64px; height:19px; ">
				<caption>찾아보기</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						// 파일을 선택하는 다이얼로그를 뛰운다
						var files = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");	
						
						var filename = "";
						var index = 0;
						if( files != "" ){	
							grd_clntlist.loadExcel(files, 1, true);
							grd_clntlist.deleteRow(1);
							var grid_rows = grd_clntlist.rows;
							for(var i=1; i<grid_rows; i++){
								grd_clntlist.valueMatrix(i, grd_clntlist.colRef("chk")) = "Y";
							}
							model.SetFocus("grd_clntlist");
							
							//전체 숫자
							model.setvalue("/root/main/clncnt" , grid_rows-1);
							
							//파일 이름 
							files += ",";
							for(var i=0; i<files.length; i++)
							{
								if( files.charAt(i) == ",")
								{
									filename = files.substring(index, i);
									model.setValue("/root/main/search/filenm",filename);
								}
							}							
							model.refresh();
						}
												
					]]>
				</script>
			</button>
			<button id="btn_sample" class="btn2_letter4" style="left:205px; top:31px; width:64px; height:19px; ">
				<caption>샘플파일</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var fileName = window.fileDialog("save", ",", false, "파일불러오기샘플", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
					if (fileName != "")
					{
						grd_clntlist.saveExcel(fileName, "주소록", true, true, "", "", true);
					}
					]]>
				</script>
			</button>
			<line id="line12" class="line_1" style="x1:0px; y1:26px; x2:269px; y2:26px; "/>
			<datagrid id="grd_clntlist" nodeset="/root/main/list/clntlist" allowselection="false" caption="^성명^휴대폰^E-mail^우편번호^주소" colwidth="20, 54, 86, 78, 70, 237" dataheight="25" extendlastcol="scroll" frozencols="2" rowheader="seq" rowheight="32" style="left:0px; top:51px; width:270px; height:211px; ">
				<col checkvalue="Y,N" ref="chk" type="checkbox" style="text-align:center; "/>
				<col ref="innrclntnm" style="text-align:center; "/>
				<col ref="mpphontel" format="99999999999" style="text-align:center; "/>
				<col ref="email" style="text-align:center; "/>
				<col ref="zipcd" format="999999" style="text-align:center; "/>
				<col ref="address" style="text-align:center; "/>
			</datagrid>
			<button id="btn_all" class="btn2_letter2" style="left:0px; top:55px; width:42px; height:19px; ">
				<caption>All</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridAllRow(grd_clntlist);
					]]>
				</script>
			</button>
			<caption id="caption1" style="left:195px; top:267px; width:70px; height:15px; ">총          명</caption>
			<output id="opt_clncnt" ref="/root/main/clncnt" style="left:211px; top:265px; width:35px; height:19px; text-align:right; "/>
		</group>
		<group id="group5" scroll="auto" style="left:0px; top:285px; width:622px; height:27px; ">
			<button id="btn_conform" class="btn4_letter2" style="left:503px; top:5px; width:56px; height:22px; ">
				<caption>확인</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var type = model.getValue("/root/fwd/type");
						fConfirmAddRow(grd_rcevlist, type);
					]]>
				</script>
			</button>
			<button id="btn_close" class="btn4_letter2" style="left:562px; top:5px; width:56px; height:22px; ">
				<caption>닫기</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						window.close();		
					]]>
				</script>
			</button>
		</group>
		<group id="group1" style="left:347px; top:0px; width:275px; height:280px; ">
			<caption id="caption2" class="tit_2" style="left:5px; top:10px; width:75px; height:13px; ">받는사람</caption>
			<caption id="caption3" style="left:80px; top:10px; width:140px; height:14px; ">(          명 / 500명)</caption>
			<caption id="opt_rcvcnt" ref="/root/main/rcvcnt" style="left:85px; top:10px; width:40px; height:13px; text-align:right; "/>
			<line id="line2" class="line_1" style="x1:0px; y1:26px; x2:270px; y2:26px; "/>
			<datagrid id="grd_rcevlist" nodeset="/root/main/list/rcevlist" allowselection="false" caption="^성명^휴대폰^E-mail^우편번호^주소" colwidth="20, 54, 86, 78, 70, 237" dataheight="25" extendlastcol="scroll" frozencols="2" rowheader="seq" rowheight="32" style="left:0px; top:31px; width:270px; height:249px; ">
				<col checkvalue="Y,N" ref="chk" type="checkbox" style="text-align:center; "/>
				<col ref="innrclntnm" style="text-align:center; "/>
				<col ref="mpphontel" format="99999999999" style="text-align:center; "/>
				<col ref="email" style="text-align:center; "/>
				<col ref="zipcd" format="999999" style="text-align:center; "/>
				<col ref="address" style="text-align:center; "/>
			</datagrid>
			<button id="btn_allchk2" class="btn2_letter2" style="left:0px; top:34px; width:42px; height:19px; ">
				<caption>All</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridAllRow(grd_rcevlist);
					]]>
				</script>
			</button>
		</group>
		<group id="group3" style="left:279px; top:115px; width:60px; height:70px; ">
			<button id="bnt_add" class="btn1_letter2" style="left:2px; top:8px; width:56px; height:22px; ">
				<caption>추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if (grd_clntlist.row > 0){
							fGridRowAddRow(grd_clntlist,grd_rcevlist,"add");
						} else {
							messageBox("추가할 대상이 없습니다.","E099");
							return false;
						}
					]]>
				</script>
			</button>
			<button id="btn_del" class="btn6_letter2" style="left:2px; top:38px; width:56px; height:22px; ">
				<caption>삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if (grd_rcevlist.row > 0){
							fGridRowAddRow(grd_rcevlist,grd_clntlist,"del");
						} else {
							messageBox("삭제할 대상이 없습니다.","E099");
							return false;
						}	
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>