package com.product.server.report.controller;

import java.util.List;

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

import com.product.server.report.config.ReportCode;
import com.product.util.BaseUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import com.product.common.lang.StringUtils;
import com.product.core.config.CoreConst;
import com.product.core.controller.support.AbstractBaseController;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.entity.RequestParameterEntity;
import com.product.core.exception.BaseException;
import com.product.module.sys.version.ApiVersion;
import com.product.server.report.config.CmnConst;
import com.product.server.report.config.SystemCode;
import com.product.server.report.service.ReportDatasourceService;
import com.product.server.report.service.idel.IReportDatasourceService;
import com.product.util.config.SystemParamSet;


@RestController
@RequestMapping("/api/report-datasource")
public class ReportDatasourceController extends AbstractBaseController{
	
	@Autowired
	ReportDatasourceService reportDatasourceService;
	
	
	/**
	 * 	报表数据源列表
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/list-datasource/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String listDatasource(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断表名是否正常
			if (!CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG.equals(fse.getTableName())) {
				return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
			}
			DataTableEntity dt=reportDatasourceService.listDatasource(fse);
			return OK_List(dt);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(),e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_ERROR.getValue(), ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}
	
	/**
	 * 	报表数据源详情
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/find-datasource/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String findDatasource(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断表名是否正常
			if (!CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG.equals(fse.getTableName())) {
				return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
			}
			//判断uuid是否为空
			if (StringUtils.isEmpty(fse.getUUID())) {
				return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
			}
			FieldSetEntity dt=reportDatasourceService.findDatasource(fse.getUUID());
			return OK_List(dt);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(),e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_ERROR.getValue(), ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}
	
	/**
	 * 数据源-保存
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/save-datasource/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String updateDatasource(HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断表名是否正常
			if (!CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG.equals(fse.getTableName())) {
				return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
			}
			IReportDatasourceService service=(IReportDatasourceService)getProxyInstance(reportDatasourceService);
			String uuid = service.saveDatasource(fse);
			return OK_Add(uuid);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(),e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_SAVE_FAIL.getValue(), ReportCode.REPORT_DATASOURCE_SAVE_FAIL.getText()+e.getMessage());
		}
	}

	/**
	 * 报表数据源新增
	 *
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/copy-datasource/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String copyDatasource(HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse = null;
			Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if (bean != null) {
				RequestParameterEntity reqp = (RequestParameterEntity) bean;
				fse = reqp.getFormData();
			}
			//判断参数是否为空
			if (bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断表名是否正常
			if (!CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG.equals(fse.getTableName())) {
				return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
			}
			return OK_List(reportDatasourceService.copyDatasource(fse));
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(), e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_COPY_FAIL.getValue(), ReportCode.REPORT_DATASOURCE_COPY_FAIL.getText() + e.getMessage());
		}
	}
	
	/**
	 * 	报表数据源删除
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/delete-datasource/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String deleteDatasource(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断表名是否正常
			if (!CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG.equals(fse.getTableName())) {
				return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
			}
			//判断uuid是否为空
			if (StringUtils.isEmpty(fse.getUUID())) {
				return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
			}
			IReportDatasourceService service=(IReportDatasourceService)getProxyInstance(reportDatasourceService);
			boolean succ=service.deleteDatasource(fse.getUUID());
			if (succ) {
				return OK();
			}else {
				return this.error(SystemCode.SYTEM_REPORT_DATASOURCE_DELETE_ERROR.getValue(), SystemCode.SYTEM_REPORT_DATASOURCE_DELETE_ERROR.getText());
			}
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(),e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_ERROR.getValue(), ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}
	
	/**
	 * 	报表sql解析与验证
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/verify-sql/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String sqlVerify(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断uuid是否为空
			if (StringUtils.isEmpty(fse.getString(CmnConst.SQL_TEXT))) {
				return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
			}
			DataTableEntity dt=reportDatasourceService.sqlVerify(fse);
			return OK_List(dt);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e);
		}  catch (Exception e) {
			e.printStackTrace();
			return this.error("", ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}
	
	/**
	 * 	获取系统参数
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/get-system-param/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String getSysParam(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			return BaseUtil.success(SystemParamSet.SYSTEM_PARAMS);
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_ERROR.getValue(), ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}

	/**
	 * 	获取字典参数名
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/get-dict-names/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String getDictNames(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
				RequestParameterEntity reqp=(RequestParameterEntity)bean;
				fse = reqp.getFormData();
			}
			//判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			DataTableEntity dt=reportDatasourceService.getDictNames();
			return OK_List(dt);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode());
		}  catch (Exception e) {
			e.printStackTrace();
			return this.error("", e.getMessage());
		}
	}
	
	/**
	 * 	报表数据源详情
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/get-datasource-field/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String getDataReouceOfField(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			//判断表名是否正常
			if (!CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG_FIELD.equals(fse.getTableName())) {
				return this.error(SystemCode.SYSTEM_TABLE_NODATA.getValue(), SystemCode.SYSTEM_TABLE_NODATA.getText());
			}
			//判断uuid是否为空
			if (StringUtils.isEmpty(fse.getUUID())) {
				return this.error(SystemCode.SYSTEM_FORM_COUNT.getValue(), SystemCode.SYSTEM_FORM_COUNT.getText());
			}
			DataTableEntity dt=reportDatasourceService.getDataReouceOfField(fse.getUUID());
			return OK_List(dt);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(),e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_ERROR.getValue(), ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}
	
	/**
	 * 	报表数据源详情
	 * @param response
	 * @param request
	 * @return
	 */
	@RequestMapping(value = "/get-dict-and-pormpt/{version}", method = RequestMethod.POST)
	@ApiVersion(1)
	public String getDictAndPrompt(HttpServletResponse response,HttpServletRequest request) {
		try {
			//获取参数
			FieldSetEntity fse=null;
			Object bean=request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
			if(bean != null){
	            RequestParameterEntity reqp=(RequestParameterEntity)bean;
	            fse = reqp.getFormData();
	        }
	        //判断参数是否为空
			if(bean == null || fse == null) {
				return this.error(SystemCode.SYSTEM_FORM_NODATA.getValue(), SystemCode.SYSTEM_FORM_NODATA.getText());
			}
			List<String> dt=reportDatasourceService.getDictAndPrompt();
			return BaseUtil.success(dt);
		} catch (BaseException e) {
			e.printStackTrace();
			return this.error(e.getCode(),e.getMessage());
		} catch (Exception e) {
			e.printStackTrace();
			return this.error(ReportCode.REPORT_DATASOURCE_ERROR.getValue(), ReportCode.REPORT_DATASOURCE_ERROR.getText()+e.getMessage());
		}
	}
}