package itn.let.mjo.pay.web;

import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Locale;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.HandlerMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;

import egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper;
import egovframework.rte.ptl.mvc.tags.ui.pagination.PaginationInfo;
import itn.com.cmm.EgovMessageSource;
import itn.com.cmm.LoginVO;
import itn.com.cmm.util.RedirectUrlMaker;
import itn.com.utl.fcc.service.EgovStringUtil;
import itn.let.mjo.pay.service.MjonPayService;
import itn.let.mjo.pay.service.MjonPrePayService;
import itn.let.mjo.pay.service.MjonPrePayVO;
import itn.let.uss.umt.service.EgovUserManageService;

@Controller
public class MjonPrePayController {

	private static final Logger LOGGER = LoggerFactory.getLogger(MjonPrePayController.class);
	
	@Resource(name = "mjonPayService")
    private MjonPayService mjonPayService;
	
	@Resource(name = "mjonPrePayService")
    private MjonPrePayService mjonPrePayService;
	
	/** EgovMessageSource */
    @Resource(name="egovMessageSource")
    EgovMessageSource egovMessageSource;
    
    /** userManageService */
	@Resource(name = "userManageService")
	private EgovUserManageService userManageService;
	
	//배열 정의{"컬럼순차번호, 컬럼이름, 컬럼내용, 컬럼이름에 붙여야할 내용(엑셀코드양식다운로드시 필요)"}
	private String[][] sendPrePayExcelValue ={
	    {"0" ,"번호" , "1" , "" },
	    {"1", "아이디" , "아이디" , ""}, 
	    {"2", "전송사" , "개인전용계좌", ""}, 
	    {"3", "선결제일시" , "2021-06-08 11:05:38", ""}, 
	    {"4", "결제금액" , "1000", ""},
	    {"5", "등록일자" , "2021-06-08 11:05:38", ""},
	} ;
	
    /**
     * 결제 리스트
     * @param searchVO
     * @param model
     * @return	"/uss/ion/msg/SendNumberList"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/PrePayList.do"})
	public String selectPrePayList(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request,
			ModelMap model) throws Exception{
		
		String pattern = (String) request.getAttribute(HandlerMapping.BEST_MATCHING_PATTERN_ATTRIBUTE) ;
		
		// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}

		/** pageing */
		PaginationInfo paginationInfo = new PaginationInfo();
		paginationInfo.setCurrentPageNo(mjonPrePayVO.getPageIndex());
		paginationInfo.setRecordCountPerPage(mjonPrePayVO.getPageUnit());
		paginationInfo.setPageSize(mjonPrePayVO.getPageSize());
		
		mjonPrePayVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
		mjonPrePayVO.setLastIndex(paginationInfo.getLastRecordIndex());
		mjonPrePayVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
		
		if("".equals(mjonPrePayVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
			mjonPrePayVO.setSearchSortCnd("prePayDate");
			mjonPrePayVO.setSearchSortOrd("desc");
		}
		
        List<MjonPrePayVO> resultList = mjonPrePayService.selectPrePayList(mjonPrePayVO);   
        
        model.addAttribute("resultList", resultList);
        model.addAttribute("totSumPrice", resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotSum() : 0);
        paginationInfo.setTotalRecordCount(resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotCnt() : 0);
		model.addAttribute("paginationInfo", paginationInfo);
		
		return "/uss/ion/pay/prePay/PrePayList";
	}
    
    
    /**
     * 선결제 등록화면
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/PrePayRegist.do"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/PrePayRegist.do"})
	public String PrePayRegist(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request,
			ModelMap model) throws Exception{
    	
    	// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}
    	
    	
    	return "/uss/ion/pay/prePay/PrePayRegist";
    }
    
    
    /**
     * 선결제 등록 처리
     * @param searchVO
     * @param model
     * @return	"uss/ion/pay/insertPrePayRegistAjax"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/insertPrePayRegistAjax.do"})
	public ModelAndView insertPrePayRegistAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request,
			ModelMap model) throws Exception{
    	
       	ModelAndView modelAndView = new ModelAndView();
       	modelAndView.setViewName("jsonView");
    	
    	// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			modelAndView.addObject("result", "loginFail");
			modelAndView.addObject("message", "로그인이 필요합니다.");
			return modelAndView;
		}
		
		try {
		
			LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
	    	String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
			
			String mberId = mjonPrePayVO.getMberId();
			mjonPrePayVO.setFrstRegisterId(userId);
			mjonPrePayVO.setLastUpdusrId(userId);
			
			if(mjonPrePayVO.getAmt().length() == 0 
					|| mjonPrePayVO.getMberId().length() == 0 
					|| mjonPrePayVO.getPrePayDate().length() == 0) {
				
				modelAndView.addObject("result", "dataFail");
				modelAndView.addObject("message", "필수 입력값을 확인해 주세요.");
				
				return modelAndView;
				
			}
			
			int mberCnt = mjonPrePayService.selectBLineMberCnt(mberId);
			
			if(mberCnt > 0) {
				
				int resultCnt = mjonPrePayService.insertPrePayInfo(mjonPrePayVO);
				
				if(resultCnt > 0) {
					
					modelAndView.addObject("result", "success");
					modelAndView.addObject("message", "등록이 완료되었습니다.");
					
				}else {
					
					modelAndView.addObject("result", "insertFail");
					modelAndView.addObject("message", "선결제 정보 등록 중 오류가 발생하였습니다.");
					
					return modelAndView;
				}
				
			}else {
				
				modelAndView.addObject("result", "mberFail");
				modelAndView.addObject("message", mberId + "의 회원정보를 찾을 수 없습니다.");
				
				return modelAndView;
			}
			
			
		} catch (Exception e) {
			
			System.out.println("++++++++++++++ insertPrePayRegistAjax Controller Error !!! " + e);
			modelAndView.addObject("result", "Error");
			modelAndView.addObject("message", "등록 중 오류가 발생하였습니다.");
			
			return modelAndView;
		}
		
    	return modelAndView;
    }
    
    
    /**
     * 선결제 삭제 처리
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/PrePayDelete.do"
     * @throws Exception
     */
    @RequestMapping(value = {"/uss/ion/pay/PrePayDelete.do"})
    public String deleteCash(
    		@RequestParam("chkEach") String[] chkEach,
    		@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
            HttpServletRequest request , RedirectAttributes redirectAttributes,
            Model model) throws Exception {
    	try {
    		LoginVO	loginVO = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
        	String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
        	
        	if(userId == "") {
        		
        		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("info.user.login"));
        		RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uat/uia/EgovLoginUsr.do");
        		return redirectUrlMaker.getRedirectUrl();
        		
        	}
        	
        	for(String id: chkEach) {
        		mjonPrePayVO.setPrePayId(id);
        		mjonPrePayService.deletePrePayInfo(mjonPrePayVO);
     	    }
    		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
    		RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
    		return redirectUrlMaker.getRedirectUrl();
    	}catch(Exception e) {
    		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.delete"));
    	}
    	redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
		RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
		return redirectUrlMaker.getRedirectUrl();
    }
    
    /**
     * 선결제 수정화면
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/PrePayModify.do"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/PrePayModify.do"})
	public String PrePayModify(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request, RedirectAttributes redirectAttributes,
			ModelMap model) throws Exception{
    	
    	// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}
    	
		try {
			
			MjonPrePayVO resultVO = mjonPrePayService.selectPrePayInfo(mjonPrePayVO);
			
			model.addAttribute("resultVO", resultVO);
			
		} catch (Exception e) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.msg"));
			RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
			return redirectUrlMaker.getRedirectUrl();
		}
    	
    	return "/uss/ion/pay/prePay/PrePayModify";
    }
    
    
    /**
     * 선결제 수정화면
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/updatePrePayModify.do"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/updatePrePayModify.do"})
	public String updatePrePayModify(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request, RedirectAttributes redirectAttributes,
			ModelMap model) throws Exception{
    	
    	// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}
    	
		try {
			
			String mberId = mjonPrePayVO.getMberId();
			
			int mberCnt = mjonPrePayService.selectBLineMberCnt(mberId);
			
			if(mberCnt > 0) {
				
				LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		    	String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
		    	
		    	mjonPrePayVO.setLastUpdusrId(userId);
		    	mjonPrePayVO.setAmt(mjonPrePayVO.getAmt().replace(",", ""));
				int resultCnt = mjonPrePayService.updatePrePayModify(mjonPrePayVO);
				
			}else {
				
				redirectAttributes.addFlashAttribute("message", mberId + "의 회원정보를 찾을 수 없습니다.");
				RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
				return redirectUrlMaker.getRedirectUrl();
				
			}
			

			
		} catch (Exception e) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.msg"));
			RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
			return redirectUrlMaker.getRedirectUrl();
		}
    	
    	return "redirect:/uss/ion/pay/PrePayList.do";
    }
    
    
    /**
     * 결제 리스트 팝업
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/PrePayPopupListAjax.do"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/PrePayPopupListAjax.do"})
	public String selectPrePayPopupListAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request,
			ModelMap model) throws Exception{
		
		String pattern = (String) request.getAttribute(HandlerMapping.BEST_MATCHING_PATTERN_ATTRIBUTE) ;
		
		// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}

		/** pageing */
		PaginationInfo paginationInfo = new PaginationInfo();
		paginationInfo.setCurrentPageNo(mjonPrePayVO.getPageIndex());
		paginationInfo.setRecordCountPerPage(mjonPrePayVO.getPageUnit());
		paginationInfo.setPageSize(mjonPrePayVO.getPageSize());
		
		mjonPrePayVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
		mjonPrePayVO.setLastIndex(paginationInfo.getLastRecordIndex());
		mjonPrePayVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
		
		if("".equals(mjonPrePayVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
			mjonPrePayVO.setSearchSortCnd("prePayDate");
			mjonPrePayVO.setSearchSortOrd("desc");
		}
		
		//특정 회원 정보리스트만 조회 되도록 검색값 셋팅
		String mberId = mjonPrePayVO.getMberId();
        List<MjonPrePayVO> resultList = mjonPrePayService.selectPrePayList(mjonPrePayVO);   
        
        model.addAttribute("resultList", resultList);
        model.addAttribute("totSumPrice", resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotSum() : 0);
        paginationInfo.setTotalRecordCount(resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotCnt() : 0);
		model.addAttribute("paginationInfo", paginationInfo);

		model.addAttribute("mberId", mberId);
		
		return "/uss/ion/pay/prePay/popup/PrePayPopupList";
	}
    
    
    
    /**
     * 선결제 등록화면
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/PrePayPopupRegistAjax.do"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/PrePayPopupRegistAjax.do"})
	public String selectPrePayPopupRegistAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request,
			ModelMap model) throws Exception{
    	
    	// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}
    	
		System.out.println(mjonPrePayVO.getMberId());
		String mberId = mjonPrePayVO.getMberId();
		
		model.addAttribute("mberId", mberId);
    	
    	return "/uss/ion/pay/prePay/popup/PrePayPopupRegist";
    }
    
    /**
     * 선결제 수정화면
     * @param searchVO
     * @param model
     * @return	"/uss/ion/pay/PrePayModify.do"
     * @throws Exception
     */
    @RequestMapping(value= {"/uss/ion/pay/PrePayPopupModifyAjax.do"})
	public String selectPrePayPopupModifyAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request, RedirectAttributes redirectAttributes,
			ModelMap model) throws Exception{
    	
    	// 미인증 사용자에 대한 보안처리
		Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
		if(!isAuthenticated) {
			model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
			return "uat/uia/EgovLoginUsr";
		}
    	
		try {
			
			MjonPrePayVO resultVO = mjonPrePayService.selectPrePayInfo(mjonPrePayVO);
			
			model.addAttribute("resultVO", resultVO);
			
		} catch (Exception e) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.msg"));
			RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayPopupListAjax.do");
			return redirectUrlMaker.getRedirectUrl();
		}
    	
    	return "/uss/ion/pay/prePay/popup/PrePayPopupModify";
    }
    
    
    //관리자 결제 엑셀 다운로드 
    @RequestMapping(value= {"/uss/ion/pay/SendPrePayExcelDownload.do"})
  	public void SendPrePayExcelDownload( MjonPrePayVO mjonPrePayVO, 
			HttpServletRequest request,
			HttpServletResponse response ,
			ModelMap model) throws Exception {
  		
    	mjonPrePayVO.setRecordCountPerPage(5000);
    	mjonPrePayVO.setFirstIndex(0);
  		LoginVO loginVO = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
		
  		// 메모리에 100개의 행을 유지합니다. 행의 수가 넘으면 디스크에 적습니다.
  		SXSSFWorkbook wb = new SXSSFWorkbook(100);
  		CellStyle style = wb.createCellStyle();
  		style.setBorderBottom(CellStyle.BORDER_THIN); //테두리 두껍게 
   		style.setBorderLeft(CellStyle.BORDER_THIN);
   		style.setBorderRight(CellStyle.BORDER_THIN);
   		style.setBorderTop(CellStyle.BORDER_THIN);
   		Font font = wb.createFont();
   		font.setBoldweight(Font.BOLDWEIGHT_BOLD);  //글씨 bold
   		
  		Cell cell = null;
  		Row row = null;
  		
  		String fileName ="B선 회원 선결제내역";
  		
  		String sheetTitle = ""; 
  		try{
  			if("".equals(mjonPrePayVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
  				mjonPrePayVO.setSearchSortCnd("prePayDate");
  				mjonPrePayVO.setSearchSortOrd("desc");
  			}
  			
  	        List<MjonPrePayVO> resultList = mjonPrePayService.selectPrePayList(mjonPrePayVO); 
  			
  			{ //화면 리스트
  				sheetTitle = "선결제내역" ; //제목
  				Sheet sheet = wb.createSheet(sheetTitle);
  				sheet.setColumnWidth(0, 2500);
  				sheet.setColumnWidth(1, 3500);
  				sheet.setColumnWidth(2, 3500);
  				sheet.setColumnWidth(3, 4000);
  				sheet.setColumnWidth(4, 3500);
  				sheet.setColumnWidth(5, 5000);
  				row = sheet.createRow(0);
  		        for(int i=0 ; i < sendPrePayExcelValue.length ; i++) {
  	 		       cell = row.createCell(i);
  	 		       cell.setCellStyle(style);
  		 	       cell.setCellValue(sendPrePayExcelValue[i][1]);
  	 		    }
  			    
  		        for(int i=0; i <  resultList.size(); i++){
  			    	row = sheet.createRow(i+1);
  			    	for(int j=0 ; j < sendPrePayExcelValue.length ; j++) {
  			    		// 번호, 	회원 아이디, 전용 전송사, 선결제 일자, 결제 금액, 등록일자
  			        	cell = row.createCell(j);
  			        	cell.setCellStyle(style);
  			        	if(j==0) cell.setCellValue(i+1); //번호
  			        	if(j==1) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getMberId()); 			//회원 아이디
  			        	if(j==2) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getAgentCodeDc()); 	//전용 전송사
  			        	if(j==3) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getPrePayDate() + " " + ((MjonPrePayVO)resultList.get(i)).getPrePayTime()); //선결제 일자
  			        	if(j==4) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getAmt()); 			//결제금액
  			        	if(j==5) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getLastUpdtPnttm()); 	//등록일자/수정일자
  				 	}
  		        }
  		        
  			}
  	    response.setHeader("Set-Cookie", "fileDownload=true; path=/");
  		SimpleDateFormat mSimpleDateFormat = new SimpleDateFormat ( "yyyy_MM_dd_HH_mm_ss", Locale.KOREA );
  		Date currentTime = new Date ();
  		String mTime = mSimpleDateFormat.format ( currentTime );
  		fileName = fileName+"("+mTime+")";
  		
  		response.setHeader("Content-Disposition", String.format("attachment; filename=\""+new String((fileName).getBytes("KSC5601"),"8859_1")+".xlsx"));
  		wb.write(response.getOutputStream());
  	    
  		}catch(Exception e) {
  			response.setHeader("Set-Cookie", "fileDownload=false; path=/");
  			response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate");
  			response.setHeader("Content-Type","text/html; charset=utf-8");
  			OutputStream out = null;
  			try {
  				out = response.getOutputStream();
  				byte[] data = new String("fail..").getBytes();
  				out.write(data, 0, data.length);
  			} catch(Exception ignore) {
  				ignore.printStackTrace();
  			} finally {
  				if(out != null) try { out.close(); } catch(Exception ignore) {}
  			}
  		}finally {
  			// 디스크 적었던 임시파일을 제거합니다.
  			wb.dispose();
  			try { wb.close(); } catch(Exception ignore) {}
  		}
  	}
    
    
}