package itn.let.mjo.addr.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.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;

import egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper;
import egovframework.rte.ptl.mvc.tags.ui.pagination.PaginationInfo;
import itn.com.cmm.LoginVO;
import itn.com.utl.fcc.service.EgovStringUtil;
import itn.let.mjo.addr.service.AddrTransHistService;
import itn.let.mjo.addr.service.AddrTransHistVO;

@Controller
public class AddrTransHistController {

	@Resource (name = "AddrTransHistService")
	private AddrTransHistService addrTransHistService;
	
	
	/**
	 * 주소록 리스트
	 * @param addrVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/mjon/addr/selectAddrTransHistListAjax.do")
	public String selectAddrTransHistListAjax(@ModelAttribute("searchVO") AddrTransHistVO addrTransHistVO
			,ModelMap model) throws Exception {
		
		//로그인 권한정보 불러오기
		LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
		
		if(userId != "") {
			addrTransHistVO.setSendMberId(userId);
		} 
		
		addrTransHistVO.setPageUnit(5);
		
		/** paging */
		PaginationInfo paginationInfo = new PaginationInfo();
		paginationInfo.setCurrentPageNo(addrTransHistVO.getPageIndex());
		paginationInfo.setRecordCountPerPage(addrTransHistVO.getPageUnit());
		paginationInfo.setPageSize(addrTransHistVO.getPageSize());
		
		addrTransHistVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
		addrTransHistVO.setLastIndex(paginationInfo.getLastRecordIndex());
		addrTransHistVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
		
		addrTransHistVO.setSearchSortCnd("sendDate");
		addrTransHistVO.setSearchSortOrd("desc");
		
		
		List<AddrTransHistVO> addrTransHistList = addrTransHistService.selectAddrTransHistList(addrTransHistVO);
		
		int totCnt = 0;
		 if(addrTransHistList.size() > 0) {
 			totCnt = addrTransHistList.get(0).getTotcnt();
 		}
		 
		paginationInfo.setTotalRecordCount(totCnt);
		model.addAttribute("addrTransHistList", addrTransHistList);
		model.addAttribute("paginationInfo", paginationInfo);
		model.addAttribute("totCnt", totCnt);
		
		return "/web/addr/AddrTransHistListAjax";
	}
	
	
	
	
	
	/**
	 * 주소록 리스트 인쇄페이지
	 * @param addrVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/mjon/addr/selectAddrTransHistPrint.do")
	public String selectAddrTransHistPrint(@ModelAttribute("searchVO") AddrTransHistVO addrTransHistVO
			,ModelMap model) throws Exception {
		
		//로그인 권한정보 불러오기
		LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
		
		if(userId != "") {
			addrTransHistVO.setSendMberId(userId);
		} 
		addrTransHistVO.setRecordCountPerPage(100000);
		addrTransHistVO.setFirstIndex(0);
		
		List<AddrTransHistVO> addrTransHistList = addrTransHistService.selectAddrTransHistList(addrTransHistVO);
		
		model.addAttribute("addrTransHistList", addrTransHistList);
		
		return "/web/addr/AddrTransHistPrint";
	}
	
	
	
	
	
	

	//주소록 엑셀 다운로드 
	@RequestMapping("/web/addr/addrTransHistExcelDownload.do")
	public void addrTransHistExcelDownload(AddrTransHistVO addrTransHistVO, 
		HttpServletRequest request,
		HttpServletResponse response ,
		ModelMap model) throws Exception {
		
		addrTransHistVO.setRecordCountPerPage(100000);
		addrTransHistVO.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 ="주소록 내보내기 관리";
		
		String sheetTitle = ""; 
		try{
			if("".equals(addrTransHistVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
				addrTransHistVO.setSearchSortOrd("desc");
			}
			addrTransHistVO.setSendMberId(loginVO.getId());
			List<AddrTransHistVO> addrTransHistList = addrTransHistService.selectAddrTransHistList(addrTransHistVO);
			
			{ 
				// row, cell 개수 순서대로 증가용 필드
				int rowNumber = 0;
				int celNumber = 0;
				//화면 리스트
				sheetTitle = "주소록" ; //제목
				Sheet sheet = wb.createSheet(sheetTitle);
				row = sheet.createRow(rowNumber++);
	
				cell = row.createCell(celNumber++);
				cell.setCellValue("번호");
				cell.setCellStyle(style);

				cell = row.createCell(celNumber++);
				cell.setCellValue("보낸주소록(그룹)명");
				cell.setCellStyle(style);
	
				cell = row.createCell(celNumber++);
				cell.setCellValue("보낸날짜");
				cell.setCellStyle(style);
				
				cell = row.createCell(celNumber++);
				cell.setCellValue("수신날짜");
				cell.setCellStyle(style);
				
				cell = row.createCell(celNumber++);
				cell.setCellValue("수신인ID");
				cell.setCellStyle(style);
				
				cell = row.createCell(celNumber++);
				cell.setCellValue("수신상태");
				cell.setCellStyle(style);
	
	
				for(int i=0; i < addrTransHistList.size(); i++){
					row = sheet.createRow(rowNumber++);		//줄추가
					celNumber = 0;
					cell = row.createCell(celNumber++);
					cell.setCellStyle(style);
					cell.setCellValue(i+1); //번호

					cell = row.createCell(celNumber++);
					cell.setCellStyle(style);
					cell.setCellValue(((AddrTransHistVO)addrTransHistList.get(i)).getAddrGrpNm()); // 보낸주소록 그룹명
					
					cell = row.createCell(celNumber++);
					cell.setCellStyle(style);
					cell.setCellValue(((AddrTransHistVO)addrTransHistList.get(i)).getSendDate()); // 보낸주소록 그룹명
					
					cell = row.createCell(celNumber++);
					cell.setCellStyle(style);
					cell.setCellValue(((AddrTransHistVO)addrTransHistList.get(i)).getRecvDate()); // 수신날짜
					
					cell = row.createCell(celNumber++);
					cell.setCellStyle(style);
					cell.setCellValue(((AddrTransHistVO)addrTransHistList.get(i)).getRecvMberId()); // 수신인
					
					cell = row.createCell(celNumber++);
					cell.setCellStyle(style);
					String recvStatus = "";
					if("Y".equals(((AddrTransHistVO)addrTransHistList.get(i)).getRecvStatus())) {
						recvStatus = "수신완료";
					} else if("W".equals(((AddrTransHistVO)addrTransHistList.get(i)).getRecvStatus())) {
						recvStatus = "수신대기";	
					} else if("N".equals(((AddrTransHistVO)addrTransHistList.get(i)).getRecvStatus())) {
						recvStatus = "수신거부";
					} else {
						recvStatus = "-";
					}
					cell.setCellValue(recvStatus); // 수신상태
				
				}
				
			}
			
			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) {}
		}
	}
	
}