/**
 * The MIT License (MIT) * Copyright (c) 2020 铭软科技(mingsoft.net)

 * Permission is hereby granted, free of charge, to any person obtaining a copy of
 * this software and associated documentation files (the "Software"), to deal in
 * the Software without restriction, including without limitation the rights to
 * use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
 * the Software, and to permit persons to whom the Software is furnished to do so,
 * subject to the following conditions:

 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.

 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS
 * FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
 * COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER
 * IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
 * CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */
package net.mingsoft.mdiy.action;

import cn.hutool.core.util.ObjectUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import net.mingsoft.base.entity.ResultData;
import net.mingsoft.base.util.JSONObject;
import net.mingsoft.basic.annotation.LogAnn;
import net.mingsoft.basic.bean.EUListBean;
import net.mingsoft.basic.constant.e.BusinessTypeEnum;
import net.mingsoft.basic.util.BasicUtil;
import net.mingsoft.mdiy.biz.IModelBiz;
import net.mingsoft.mdiy.biz.IPostBiz;
import net.mingsoft.mdiy.entity.ModelEntity;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.*;
import springfox.documentation.annotations.ApiIgnore;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 自定义表单表管理控制层
 * @author 铭飞开发团队
 * @version
 * 版本号：1<br/>
 * 创建日期：2017-8-12 15:58:29<br/>
 * 历史修订：<br/>
 */
@Api(value = "自定义表单接口")
@Controller
@RequestMapping("/${ms.manager.path}/mdiy/post")
public class PostAction extends BaseAction{

	private final static String TYPE="post";
	/**
	 * 注入自定义表单业务层
	 */
	@Autowired
	private IPostBiz postBiz;
	/**
	 * 注入自定义模型业务层
	 */
	@Autowired
	private IModelBiz modelBiz;

	@ApiOperation(value = "批量删除自数据接口")
	@LogAnn(title = "批量删除自数据接口",businessType= BusinessTypeEnum.DELETE)
	@PostMapping("data/delete")
	@ResponseBody
    @RequiresPermissions("mdiy:form:del")
	public ResultData delete(String modelId, HttpServletResponse response, HttpServletRequest request) {
		int[] ids = BasicUtil.getInts("ids",",");
		for (int id : ids) {
			postBiz.deleteQueryDiyFormData(id,modelId);
		}
		return ResultData.build().success();
	}
	/**
	 * 返回主界面index
	 */
	@GetMapping("/index")
	public String index(HttpServletResponse response,HttpServletRequest request){
		return "/mdiy/post/index";
	}

	/**
	 * 返回编辑界面form_form
	 */
	@GetMapping("/form")
	public String form(ModelEntity form,HttpServletResponse response,HttpServletRequest request,@ApiIgnore ModelMap model){
		if(form.getId() != null){
			ModelEntity formEntity = (ModelEntity) postBiz.getEntity(Integer.parseInt(form.getId()));
			model.addAttribute("formEntity",formEntity);
		}

		return "/mdiy/post/form";
	}

	/**
	 * 查询自定义模型列表
	 * @param model 自定义模型实体
	 * <i>model参数包含字段信息参考：</i><br/>
	 * modelName 模型名称<br/>
	 * modelTableName 模型表名<br/>
	 * modelAppId 应用编号<br/>
	 * modelJson json<br/>
	 * id 编号<br/>
	 * <dt><span class="strong">返回</span></dt><br/>
	 * <dd>[<br/>
	 * { <br/>
	 * modelName: 模型名称<br/>
	 * modelTableName: 模型表名<br/>
	 * modelAppId: 应用编号<br/>
	 * modelJson: json<br/>
	 * id: 编号<br/>
	 * }<br/>
	 * ]</dd><br/>
	 */
	@ApiOperation(value = "查询自定义模型列表接口")
	@ApiImplicitParams({
			@ApiImplicitParam(name = "modelName", value = "模型名称", required =false,paramType="query"),
			@ApiImplicitParam(name = "modelTableName", value = "模型表名", required =false,paramType="query"),
			@ApiImplicitParam(name = "modelAppId", value = "应用编号", required =false,paramType="query"),
			@ApiImplicitParam(name = "modelJson", value = "json", required =false,paramType="query"),
			@ApiImplicitParam(name = "createBy", value = "创建人", required =false,paramType="query"),
			@ApiImplicitParam(name = "createDate", value = "创建时间", required =false,paramType="query"),
			@ApiImplicitParam(name = "updateBy", value = "修改人", required =false,paramType="query"),
			@ApiImplicitParam(name = "updateDate", value = "修改时间", required =false,paramType="query"),
			@ApiImplicitParam(name = "del", value = "删除标记", required =false,paramType="query"),
			@ApiImplicitParam(name = "id", value = "编号", required =false,paramType="query"),
	})
	@GetMapping("/list")
	@ResponseBody
	public ResultData list(@ModelAttribute @ApiIgnore ModelEntity modelEntity, HttpServletResponse response, HttpServletRequest request, @ApiIgnore ModelMap model, BindingResult result) {
		modelEntity.setModelAppId(BasicUtil.getAppId());
		modelEntity.setModelCustomType(TYPE);
		BasicUtil.startPage();
		List modelList = modelBiz.query(modelEntity);
		return ResultData.build().success(new EUListBean(modelList,(int)BasicUtil.endPage(modelList).getTotal()));
	}

	/**
	 * 获取自定义模型
	 * @param modelEntity 自定义模型实体
	 * <i>model参数包含字段信息参考：</i><br/>
	 * modelName 模型名称<br/>
	 * modelTableName 模型表名<br/>
	 * modelAppId 应用编号<br/>
	 * modelJson json<br/>
	 * id 编号<br/>
	 * <dt><span class="strong">返回</span></dt><br/>
	 * <dd>{ <br/>
	 * modelName: 模型名称<br/>
	 * modelTableName: 模型表名<br/>
	 * modelAppId: 应用编号<br/>
	 * modelJson: json<br/>
	 * id: 编号<br/>
	 * }</dd><br/>
	 */
	@ApiOperation(value = "获取自定义模型列表接口")
	@ApiImplicitParam(name = "id", value = "编号", required =true,paramType="query")
	@GetMapping("/get")
	@ResponseBody
	public ResultData get(@ModelAttribute @ApiIgnore ModelEntity modelEntity,HttpServletResponse response, HttpServletRequest request,@ApiIgnore ModelMap modelMap){
		if(modelEntity.getId()==null) {
			return null;
		}
		modelEntity.setModelCustomType(TYPE);
		modelEntity.setModelAppId(BasicUtil.getAppId());
		ModelEntity _model = (ModelEntity)modelBiz.getEntity(Integer.parseInt(modelEntity.getId()));
		return ResultData.build().success(_model);
	}


	@ApiOperation(value = "导入自定义模型")
	@ApiImplicitParams({
			@ApiImplicitParam(name = "modelJson", value = "json", required =true,paramType="query"),
	})
	@LogAnn(title = "导入",businessType= BusinessTypeEnum.INSERT)
	@PostMapping("/importJson")
	@ResponseBody
	@RequiresPermissions("mdiy:form:importJson")
	public ResultData importJson(@ModelAttribute @ApiIgnore ModelEntity modelEntity, HttpServletResponse response, HttpServletRequest request,BindingResult result) {
		String model="mdiy_post_";
		//验证json的值是否合法
		if(StringUtils.isBlank(modelEntity.getModelJson())){
			return ResultData.build().error(getResString("err.empty", this.getResString("model.json")));
		}
		Map map = new HashMap();
		try{
			map = com.alibaba.fastjson.JSONObject.parseObject(modelEntity.getModelJson(), Map.class);
		}catch (Exception e){
			return ResultData.build().error(getResString("err.error", this.getResString("model.json")));
		}
		ModelEntity _modelEntity=new ModelEntity();
		//在表名前面拼接前缀
		String tableName=model+map.get("tableName");
		_modelEntity.setModelTableName(tableName);
		_modelEntity.setModelAppId(BasicUtil.getAppId());
		modelEntity.setModelCustomType(TYPE);
		//判断表名是否存在
		if(ObjectUtil.isNotNull(modelBiz.getEntity(_modelEntity))){
			return ResultData.build().error(getResString("err.exist", this.getResString("table.name")));
		}
		Map json= new HashMap();
		json.put("html",map.get("html"));
		json.put("script",map.get("script"));
		//创建表
		modelBiz.excuteSql(map.get("sql").toString().replace("{model}",model));
		modelEntity.setModelField(map.get("field").toString());
		modelEntity.setModelTableName(tableName);
		modelEntity.setModelName(map.get("title").toString());
		modelEntity.setModelAppId(BasicUtil.getAppId());
		modelEntity.setModelJson(JSONObject.toJSONString(json));
		//保存自定义模型实体
		modelBiz.saveEntity(modelEntity);
		return ResultData.build().success(modelEntity);
	}


	/**
	 * @param models 自定义模型实体
	 * <i>model参数包含字段信息参考：</i><br/>
	 * id:多个id直接用逗号隔开,例如id=1,2,3,4
	 * 批量删除自定义模型
	 *            <dt><span class="strong">返回</span></dt><br/>
	 *            <dd>{code:"错误编码",<br/>
	 *            result:"true｜false",<br/>
	 *            resultMsg:"错误信息"<br/>
	 *            }</dd>
	 */
	@ApiOperation(value = "批量删除自定义模型列表接口")
	@LogAnn(title = "批量删除自定义模型列表接口",businessType= BusinessTypeEnum.DELETE)
	@PostMapping("/delete")
	@ResponseBody
	@RequiresPermissions("mdiy:form:del")
	public ResultData delete(@RequestBody List<ModelEntity> models,HttpServletResponse response, HttpServletRequest request) {
		int[] ids = new int[models.size()];
		for(int i = 0;i<models.size();i++){
			ids[i] =Integer.parseInt(models.get(i).getId()) ;
		}
		modelBiz.delete(ids);
		return ResultData.build().success();
	}


}