package egovframework.migration.web;

import java.util.Map;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import egovframework.migration.service.MariaMigrationService;

@Controller
public class MariaMigrationController {

	@Resource(name = "MariaMigrationService")
    private MariaMigrationService mariaMigrationService; 
	
	@RequestMapping(value="/maria/migration.do")
	public String mariaTestPage(ModelMap model) throws Exception{
		
		int selectKcdfBasicCount =	mariaMigrationService.selectKcdfBasicCount();
		
		mariaMigrationService.kcdfMigration();
		
		/*List<OrcaleTestVO> list = orcalTestDAO.selectOracleBasicList();*/
		mariaMigrationService.selectOracleBasicList();
		
		
		
		
		int selectMariaBasicCount = mariaMigrationService.selectMariaBasicCount();
		
		int selectOraclePublishCount =	mariaMigrationService.selectOraclePublishCount();
		int selectMariaPublishCount = mariaMigrationService.selectMariaPublishCount();
		
		int selectOracleFileCount =	mariaMigrationService.selectOracleFileCount();
		int selectMariaFileCount = mariaMigrationService.selectMariaFileCount();
		
		int selectOracleResrvationCount =	mariaMigrationService.selectOracleResrvationCount();
		int selectMariaResrvationCount = mariaMigrationService.selectMariaResrvationCount();
		
		/*model.addAttribute("selectOracleBasicCount", selectOracleBasicCount );
		model.addAttribute("selectMariaBasicCount", selectMariaBasicCount );
		
		model.addAttribute("selectOraclePublishCount", selectOraclePublishCount );
		model.addAttribute("selectMariaPublishCount", selectMariaPublishCount );
		
		model.addAttribute("selectOracleFileCount", selectOracleFileCount );
		model.addAttribute("selectMariaFileCount", selectMariaFileCount );
		
		model.addAttribute("selectOracleResrvationCount", selectOracleResrvationCount );
		model.addAttribute("selectMariaResrvationCount", selectMariaResrvationCount );*/
		return "test/oracle/TestOracle";
	}
	
	@RequestMapping(value="/maria/dataBaseAjax.do")
	public ModelAndView mariaDataBaseAjax(@RequestParam Map<String, Object> commandMap){
		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		
		
		String type = (String) commandMap.get("type");
		
		System.out.println("type : " + type);
		if(type =="basic" || type.equals("basic")){
			mariaMigrationService.selectOracleBasicList();
		}else if(type =="Publish" || type.equals("Publish")){
			mariaMigrationService.selectOraclePublishList();
		}else if(type =="file" || type.equals("file")){
			mariaMigrationService.selectOracleFileList();
		}else if(type =="Resrvation" || type.equals("Resrvation")){
			mariaMigrationService.selectOracleResrvationList();
		} 
		
		modelAndView.addObject("result", "TEST");
		return modelAndView;
	}
}