layer 拼接分页及查询

package auto.system.qc.server;

import java.util.List;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import auto.system.common.entity.PageData;
import auto.system.four.model._NG;
import auto.system.module.core.SessionUtils;
import auto.system.module.server.BaseService;
import auto.system.module.server.dao.SystemBaseDAO;
import auto.system.qc.model._Disposal;
import auto.system.utils.ActionResult;
import auto.system.utils.TimeUtils;
import db.utils.DBUtils;
@Service
public class DisposalService extends BaseService {

	@Resource
	private SystemBaseDAO systemBaseDAO;

	@SuppressWarnings("unchecked")
	@Transactional(propagation = Propagation.REQUIRED,readOnly = true)
	public PageData getList(HttpServletRequest request) {
		String search=res.getParameter(request,"_lot","");
		String limit = res.getParameter(request, "limit", "");
		String page = res.getParameter(request, "page", "0");
		StringBuffer sql = new StringBuffer();
		StringBuffer totalSql = new StringBuffer();
		sql.append("select top "+ limit +" * ")
			.append("from (select row_number() over(order by d._no desc) as rownumber,d.*,p._dingdan,m._name _module_name from _Disposal d,_PlanLot lot,_Plan p,_Module m " + 
					"where d._lot = lot._lot and d._module_id = m._id and lot._plan_id = p._id) temp_row where temp_row.rownumber > (("+ page +"-1)*"+ limit +")");
		totalSql.append("select count(1) from _Disposal ");
		if(!"".equals(search)){
			sql.append(" and _lot like '%" + search + "%'");
		}
		List<_Disposal> list = (List<_Disposal>)DBUtils.getListBy(sql.toString(), _Disposal.class);
		return PageData.successData(list, DBUtils.getTotal(totalSql.toString()));
	}
	
	
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult delete(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		_Disposal disposal = new _Disposal(res.getParameter(request, "_id", ""));
		systemBaseDAO.delete(disposal);
		return result;
	}

	@SuppressWarnings("unchecked")
	@Transactional(propagation = Propagation.REQUIRED,readOnly = true)
	public void toLoadData(HttpServletRequest request) {
		String _id = res.getParameter(request, "_id", "");
		String sql = "select d.*,m._name _module_name,p._dingdan,m._classname _class_name from _Disposal d,_PlanLot lot,_Plan p,_Module m"
				+ " where d._id = '"+ _id +"' and d._module_id = m._id and d._lot = lot._lot and lot._plan_id = p._id";
		_Disposal disposal = (_Disposal) DBUtils.getObjectBy(sql, _Disposal.class);
		//1.此工段不良条码
		List<_NG> ngs = (List<_NG>) systemBaseDAO.findAll("from _NG where _lot = '"+ disposal.get_lot() +"' and _class_name = '"+ disposal.get_class_name() +"'");
		request.setAttribute("disposal", disposal);
		request.setAttribute("ngs", ngs);
	}

	/**
	 * 生产确认
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toZZConfirm(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_zz_confirm("O");
			disposal.set_zz_confirm_blxm(res.getParameter(request, "_zz_confirm_blxm", ""));
			disposal.set_zz_confirm_deal(res.getParameter(request, "_zz_confirm_deal", ""));
			disposal.set_zz_confirm_name(SessionUtils.getUser(request).get_name());
			disposal.set_zz_confirm_time(TimeUtils.getYearMonthDayHourMinuteStr());
			if(disposal.get_zz_confirm().equals("O") && disposal.get_ipqc_confirm().equals("O")) {//
				if(disposal.get_zz_confirm_deal().equals(disposal.get_ipqc_confirm_deal())) {//意见一致进行下一步
					disposal.set_zz_result("S");
				}else {//不一致，提交到 工艺/品质工程师处理
					disposal.set_gy_result_confirm("S");
					disposal.set_qc_result_confirm("S");
				}
			}
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	

	/**
	 * IPQC确认
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toIPQCConfirm(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_ipqc_confirm("O");
			disposal.set_ipqc_confirm_deal(res.getParameter(request, "_ipqc_confirm_deal", ""));
			disposal.set_ipqc_confirm_name(SessionUtils.getUser(request).get_name());
			disposal.set_ipqc_confirm_time(TimeUtils.getYearMonthDayHourMinuteStr());
			if(disposal.get_zz_confirm().equals("O") && disposal.get_ipqc_confirm().equals("O")) {//
				if(disposal.get_zz_confirm_deal().equals(disposal.get_ipqc_confirm_deal())) {//意见一致进行下一步
					disposal.set_zz_result("S");
				}else {//不一致，提交到 工艺/品质工程师处理
					disposal.set_gy_result_confirm("S");
					disposal.set_qc_result_confirm("S");
				}
			}
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 生产执行结果反馈
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toZZResult(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_zz_result_fxsl(Integer.parseInt(res.getParameter(request, "_zz_result_fxsl", "0")));//private Integer _zz_result_fxsl = 0;//返回数量
			disposal.set_zz_result_fxxm(res.getParameter(request, "_zz_result_fxxm", ""));//private String _zz_result_fxxm = "";//返回项目
			disposal.set_zz_result_fxnr(res.getParameter(request, "_zz_result_fxnr", ""));//private String _zz_result_fxnr = "";//返回内容
			disposal.set_zz_result_fxlp(Integer.parseInt(res.getParameter(request, "_zz_result_fxlp", "0")));//private Integer _zz_result_fxlp = 0;//返修良品  		注意：如此产品有条码，请在良品库添加返修成良品的标记
			disposal.set_zz_result_bfsl(Integer.parseInt(res.getParameter(request, "_zz_result_fxlp","0")));//private Integer _zz_result_bfsl = 0;//报废数量
			disposal.set_zz_result_confirm_name(res.getParameter(request, "_zz_result_confirm_name", ""));//private String _zz_result_confirm_name = "";//返修确认
			disposal.set_zz_result("O");
			//转由QC确认执行结果
			disposal.set_qc_confirm("S");
			disposal.set_zz_result_name(SessionUtils.getUser(request).get_name());
			disposal.set_zz_result_time(TimeUtils.getYearMonthDayHourMinuteStr());
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	

	/**
	 * QC确认生产结果
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toQCConfirm(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_qc_confirm("O");
			//转由工艺、品质工程师处理
			disposal.set_gy_result_confirm("S");
			disposal.set_qc_result_confirm("S");
			disposal.set_qc_confirm_name(SessionUtils.getUser(request).get_name());
			disposal.set_qc_confirm_time(TimeUtils.getYearMonthDayHourMinuteStr());
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}

	/**
	 * 工艺确认
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toGYResult(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_gy_result_remarks(res.getParameter(request, "_gy_result_remarks", ""));
			disposal.set_gy_result_confirm("O");
			disposal.set_gy_result_name(SessionUtils.getUser(request).get_name());
			disposal.set_gy_result_time(TimeUtils.getYearMonthDayHourMinuteStr());
			//判断下一节点
			if(disposal.get_qc_result_confirm().equals("O") && disposal.get_gy_result_confirm().equals("O")) {
				if(disposal.get_qc_result_scyf().equals("Y")) {
					disposal.set_sc_confirm("S");
					disposal.set_yf_confirm("S");
				}else if(disposal.get_qc_result_scyf().equals("N")) {
					disposal.set_result_confirm("S");
				}
			}
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 品质确认
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toQCResult(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_qc_result_remarks(res.getParameter(request, "_qc_result_remarks", ""));
			disposal.set_qc_result_scyf(res.getParameter(request, "_qc_result_scyf", "N"));//判断是否需要市场研发签批
			disposal.set_qc_result_confirm("O");
			disposal.set_qc_result_name(SessionUtils.getUser(request).get_name());
			disposal.set_qc_result_time(TimeUtils.getYearMonthDayHourMinuteStr());
			//判断下一节点
			if(disposal.get_qc_result_confirm().equals("O") && disposal.get_gy_result_confirm().equals("O")) {
				if(disposal.get_qc_result_scyf().equals("Y")) {
					disposal.set_sc_confirm("S");
					disposal.set_yf_confirm("S");
				}else if(disposal.get_qc_result_scyf().equals("N")) {
					disposal.set_result_confirm("S");
				}
			}
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 市场会签
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toSCConfirm(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_sc_confirm("O");
			disposal.set_sc_remarks(res.getParameter(request, "_sc_remarks", ""));
			disposal.set_sc_name(SessionUtils.getUser(request).get_name());
			disposal.set_sc_time(TimeUtils.getYearMonthDayHourMinuteStr());
			//判断下一节点
			if(disposal.get_sc_confirm().equals("O") && disposal.get_yf_confirm().equals("O")) {
				disposal.set_result_confirm("S");
			}
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 研发会签
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toYFConfirm(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_yf_confirm("O");
			disposal.set_yf_remarks(res.getParameter(request, "_yf_remarks", ""));
			disposal.set_yf_name(SessionUtils.getUser(request).get_name());
			disposal.set_yf_time(TimeUtils.getYearMonthDayHourMinuteStr());
			//判断下一节点
			if(disposal.get_sc_confirm().equals("O") && disposal.get_yf_confirm().equals("O")) {
				disposal.set_result_confirm("S");
			}
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 审批
	 * @param request
	 * @return
	 */
	@Transactional(propagation = Propagation.REQUIRED,readOnly = false)
	public ActionResult toResult(HttpServletRequest request) {
		ActionResult result = new ActionResult();
		try {
			String _id = res.getParameter(request, "_id", "");
			_Disposal disposal = (_Disposal) systemBaseDAO.findById(_Disposal.class, _id);
			disposal.set_result_index(res.getParameter(request, "_result_index", ""));
			disposal.set_other(res.getParameter(request, "_other", ""));
			disposal.set_bfrc(Integer.parseInt(res.getParameter(request, "_bfrc", "0")));
			disposal.set_blrc(Integer.parseInt(res.getParameter(request, "_blrc", "0")));
			disposal.set_result_confirm("O");
			disposal.set_result_name(SessionUtils.getUser(request).get_name());
			disposal.set_result_time(TimeUtils.getYearMonthDayHourMinuteStr());
			systemBaseDAO.attachDirty(disposal, null);
		}catch (Exception e) {
			result.setSuccess(false);
			result.setMsg(e.getMessage());
		}
		return result;
	}
}

package auto.system.qc.controller;

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

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import auto.system.common.entity.PageData;
import auto.system.qc.server.DisposalService;
import auto.system.utils.ActionResult;


@RequestMapping(value="/disposal")
@Controller
public class DisposalController {

	@Resource
	public DisposalService disposalService;

	/**
	 * 管理页面
	 */
	@RequestMapping("/index.do")
	public String index() {
		return "/jsp/qc/disposal/index.jsp";
	}

	@RequestMapping("/getList.do")
	@ResponseBody
	public PageData getList(HttpServletRequest request,Integer limit,Integer page) throws Exception{
		return disposalService.getList(request);
	}

	/*********************第一阶段  组长确认***********************///
	/**
	 * 
	 * 第一阶段：组长确认权限中转
	 */
	@RequestMapping(value="/toZZConfirmCheck.do")
	@ResponseBody
	public ActionResult toZZConfirmCheck(HttpServletRequest reqeust) {
		ActionResult result = new ActionResult();
		return result;
	}
	
	/**
	 * 第一阶段：组长确认页面跳转
	 */
	@RequestMapping(value="/toZZConfirmUI.do")
	public String toZZConfirmUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_zz_confirm.jsp";
	}

	/**
	 * 第一阶段：组长确认页面跳转
	 */
	@RequestMapping(value="/toZZConfirm.do")
	@ResponseBody
	public ActionResult toZZConfirm(HttpServletRequest reqeust) {
		return disposalService.toZZConfirm(reqeust);
	}
	
	/*********************第一阶段  品质确认***********************///
	/**
	 * 第一阶段：组长确认权限中转
	 */
	@RequestMapping(value="/toIPQCConfirmCheck.do")
	@ResponseBody
	public ActionResult toIPQCConfirmCheck(HttpServletRequest reqeust) {
		ActionResult result = new ActionResult();
		return result;
	}
	
	/**
	 * 第一阶段：组长确认页面跳转
	 */
	@RequestMapping(value="/toIPQCConfirmUI.do")
	public String toIPQCConfirmUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_ipqc_confirm.jsp";
	}

	/**
	 * 第一阶段：组长确认页面跳转
	 */
	@RequestMapping(value="/toIPQCConfirm.do")
	@ResponseBody
	public ActionResult toIPQCConfirm(HttpServletRequest reqeust) {
		return disposalService.toIPQCConfirm(reqeust);
	}

	/*********************第二阶段  生产执行结果反馈***********************///
	@RequestMapping(value="/toZZResultCheck.do")
	@ResponseBody
	public ActionResult toZZResultCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toZZResultUI.do")
	public String toZZResultUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_zz_result.jsp";
	}
	
	@RequestMapping(value="/toZZResult.do")
	@ResponseBody
	public ActionResult toZZResult(HttpServletRequest reqeust) {
		return disposalService.toZZResult(reqeust);
	}
	
	/*********************第三阶段 QC确认 生产执行结果***********************///
	@RequestMapping(value="/toQCConfirmCheck.do")
	@ResponseBody
	public ActionResult toQCConfirmCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toQCConfirmUI.do")
	public String toQCConfirmUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_qc_confirm.jsp";
	}

	@RequestMapping(value="/toQCConfirm.do")
	@ResponseBody
	public ActionResult toQCConfirm(HttpServletRequest reqeust) {
		return disposalService.toQCConfirm(reqeust);
	}
	
	/*********************第四阶段 工艺工程师确认***********************///
	@RequestMapping(value="/toGYResultCheck.do")
	@ResponseBody
	public ActionResult toGYResultCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toGYResultUI.do")
	public String toGYResultUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_gy_result.jsp";
	}
	
	@RequestMapping(value="/toGYResult.do")
	@ResponseBody
	public ActionResult toGYResult(HttpServletRequest reqeust) {
		return disposalService.toGYResult(reqeust);
	}
	
	/*********************第四阶段 品质工程师确认***********************///
	@RequestMapping(value="/toQCResultCheck.do")
	@ResponseBody
	public ActionResult toQCResultCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toQCResultUI.do")
	public String toQCResultUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_qc_result.jsp";
	}
	
	@RequestMapping(value="/toQCResult.do")
	@ResponseBody
	public ActionResult toQCResult(HttpServletRequest reqeust) {
		return disposalService.toQCResult(reqeust);
	}
	
	
	/*********************第五阶段 市场会签***********************///
	@RequestMapping(value="/toSCConfirmCheck.do")
	@ResponseBody
	public ActionResult toSCConfirmCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toSCConfirmUI.do")
	public String toSCConfirmUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_sc_confirm.jsp";
	}
	
	@RequestMapping(value="/toSCConfirm.do")
	@ResponseBody
	public ActionResult toSCConfirm(HttpServletRequest reqeust) {
		return disposalService.toSCConfirm(reqeust);
	}
	
	/*********************第五阶段 研发会签***********************///
	@RequestMapping(value="/toYFConfirmCheck.do")
	@ResponseBody
	public ActionResult toYFConfirmCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toYFConfirmUI.do")
	public String toYFConfirmUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_yf_confirm.jsp";
	}
	
	@RequestMapping(value="/toYFConfirm.do")
	@ResponseBody
	public ActionResult toYFConfirm(HttpServletRequest reqeust) {
		return disposalService.toYFConfirm(reqeust);
	}
	
	
	/*********************第六阶段 审批***********************///
	@RequestMapping(value="/toResultCheck.do")
	@ResponseBody
	public ActionResult toResultCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toResultUI.do")
	public String toResultUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_result.jsp";
	}
	
	@RequestMapping(value="/toResult.do")
	@ResponseBody
	public ActionResult toResult(HttpServletRequest reqeust) {
		return disposalService.toResult(reqeust);
	}
	
	
	/**
	 * 删除
	 * @param request
	 * @return
	 */
	@RequestMapping("/delete.do")
	@ResponseBody
	public ActionResult delete(HttpServletRequest request){
		return disposalService.delete(request);
	}
	
	/**
	 * 查看详情
	 * @param request
	 * @return
	 */
	@RequestMapping(value="/toLookCheck.do")
	@ResponseBody
	public ActionResult toLookCheck(HttpServletRequest request) {
		return new ActionResult();
	}

	@RequestMapping(value="/toLookUI.do")
	public String toLookUI(HttpServletRequest reqeust) {
		disposalService.toLoadData(reqeust);
		return "/jsp/qc/disposal/_details.jsp";
	}
}

layui.use([ 'jquery', 'table', 'layer', 'form' ], function() {
	var $ = layui.$;
	var table = layui.table;
	var layer = layui.layer;
	var form = layui.form;

	//显示分组
	table.render({
		elem : '#disposal-tbl',
		toolbar : '#disposal-tbl-toolbar',
		url : basePath + 'disposal/getList.do',
		page:true,
		method : 'get',
		cols : [ [ {
			field : '_no',
			width : '155',
			title : '编号'
		},{
			field : '_module_name',
			width : '140',
			title : '异常工序'
		},{
			field : '_dingdan',
			width : '110',
			title : '订单号'
		},{
			field : '_lot',
			width : '110',
			title : '批次'
		},{
			field : '_outlier_quantity',
			width : '100',
			title : '不良数量'
		},{
			field : 'state',
			width : '120',
			title : '处理状态',
			templet : '#stateTmp'
		},{
			field : '_inputdate',
			width : '160',
			title : '记录时间'
		},{
			field : '_inputmen',
			width : '100',
			title : '记录人员'
		}, {
			toolbar : '#disposal-rowtbl-toolbar',
			width : '200',
			title : '操作'
		} ] ],
		id : 'disposal-tbl',
	});
	
	//查询监听
	form.on('submit(disposal-tbl-search)', function(data) {
		table.reload('disposal-tbl', {
			where : data.field
		})
	});
	
	//监听头部工具栏事件
	table.on('toolbar(disposal-tbl)', function(obj) {
		// 获取当前行数据和lay-event的值
		var data = obj.data;
		var event = obj.event;
		switch (event) {
		case 'refresh':
			table.reload('disposal-tbl');
			break;
		default:
			break;
		}
	})
	
	//监听行工具栏事件
	table.on('tool(disposal-tbl)', function(obj) {
		// 获取当前行数据和lay-event的值
		var data = obj.data;
		var event = obj.event;
		switch (event) {
		case 'Look'://查看详情
			$.ajax({
				url : basePath + "disposal/toLookCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『详情』",
		            		content: basePath + "disposal/toLookUI.do?_id="+data._id,
		            		btn: ['关闭'],
		            		shadeClose: true,
		            		cls: function(index, layero){
		            			layer.close(layero);
		            		}
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'Result'://审批
			$.ajax({
				url : basePath + "disposal/toResultCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『审批』",
		            		content: basePath + "disposal/toResultUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'YFConfirm'://研发会签
			$.ajax({
				url : basePath + "disposal/toYFConfirmCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『研发会签』",
		            		content: basePath + "disposal/toYFConfirmUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'SCConfirm'://市场/FAE会签
			$.ajax({
				url : basePath + "disposal/toSCConfirmCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『市场/FAE会签』",
		            		content: basePath + "disposal/toSCConfirmUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'QCResult'://品质确认
			$.ajax({
				url : basePath + "disposal/toQCResultCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『品质确认』",
		            		content: basePath + "disposal/toQCResultUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'GYResult'://工艺确认
			$.ajax({
				url : basePath + "disposal/toGYResultCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『工艺确认』",
		            		content: basePath + "disposal/toGYResultUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'QCConfirm'://QC确认结果
			$.ajax({
				url : basePath + "disposal/toQCConfirmCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『QC确认结果』",
		            		content: basePath + "disposal/toQCConfirmUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'ZZResult'://生产执行结果反馈
			$.ajax({
				url : basePath + "disposal/toZZResultCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『生产执行结果反馈』",
		            		content: basePath + "disposal/toZZResultUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'IPQCConfirm'://IPQC确认
			$.ajax({
				url : basePath + "disposal/toIPQCConfirmCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『IPQC确认』",
		            		content: basePath + "disposal/toIPQCConfirmUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'ZZConfirm':
			$.ajax({
				url : basePath + "disposal/toZZConfirmCheck.do",
				type : "POST",
				dataType : 'json',
				success : function(result) {
					if (result.success) {
						layer.open({
		            		type: 2,
		            		area: ['800px', ($(window).height() - 50) + 'px'],
		            		fix: false,
		            		//不固定
		            		maxmin: true,
		            		shade: 0.3,
		            		title: "『组长确认』",
		            		content: basePath + "disposal/toZZConfirmUI.do?_id="+data._id,
		            		btn: ['确定', '关闭'],
		            		shadeClose: true,
		            		yes: function(index, layero){
		    				    var body = layer.getChildFrame('body', index);
		    				    body.find('#save').click();
		            		},
		            	    cancel: function(index) {
		            	        return true;
		            	    },
		            	});
					} else {
						layer.msg(result.msg);
					}
				},
				error : function() {
					layer.msg("ajax error");
				}
			});
			break;
		case 'delete':
			layer.confirm('确定删除该数据吗？', function(index) {
				$.ajax({
					url : basePath + "disposal/delete.do",
					type : "POST",
					data : {"_id":data._id},
					dataType : 'json',
					success : function(result) {
						if (result.success) {
							layer.msg('操作成功');
							table.reload('disposal-tbl');
						} else {
							layer.msg(result.msg);
						}
					},
					error : function() {
						console.log("ajax error");
					}
				});
			})
			break;
		default:
			break;
		}
	})
})

<%@page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%--
<%@ taglib prefix="c"  uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fn"  uri="http://java.sun.com/jsp/jstl/functions" %>
 --%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
	  <link rel="stylesheet" href="<%=basePath %>js/layui-v2.5.5/layui/css/layui.css?v=20200101">
</head>
<body style="padding-top:15px;">

<div class="layui-fluid">
	<div class="layui-card">
		<div class="layui-form layui-card-header">
	      <div class="layui-form-item">
	          <div class="layui-inline">
	            <label class="layui-form-label">生产批次</label>
	            <div class="layui-input-inline">
	              <input type="text" name="_lot" placeholder="请输入生产批次" autocomplete="off" class="layui-input">
	            </div>
	          </div>
	          <div class="layui-inline">
          		<button class="layui-btn layui-btn-sm" lay-submit lay-filter="disposal-tbl-search"><i class="layui-icon layui-icon-search"></i>  查 询</button>
	          </div>
	       </div>
		</div>
		<div class="layui-card-body">
		    <!-- 系统模块原始容器: -->
		    <table id="disposal-tbl" lay-filter="disposal-tbl" style="margin:0 5px;padding:0px;"></table>
		</div>
	</div>	
</div>

<!-- 表格行工具栏模板： -->
<script type="text/html" id="disposal-tbl-toolbar">
	<div class="layui-btn-container">
		<a class="layui-btn layui-btn-sm layui-btn-disposal" lay-event="refresh">刷新</a>
	</div>
</script>

<script type="text/html" id="disposal-rowtbl-toolbar">
	{{#  if(d._zz_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="ZZConfirm">组长确认</a>
	{{#  } }}
	{{#  if(d._ipqc_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="IPQCConfirm">IPQC确认</a>
	{{#  } }}
	{{#  if(d._zz_result == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="ZZResult">结果反馈</a>
	{{#  } }}
	{{#  if(d._qc_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="QCConfirm">QC确认结果</a>
	{{#  } }}
	{{#  if(d._gy_result_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="GYResult">工艺确认</a>
	{{#  } }}
	{{#  if(d._qc_result_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="QCResult">品质确认</a>
	{{#  } }}
	{{#  if(d._yf_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="YFConfirm">研发确认</a>
	{{#  } }}
	{{#  if(d._sc_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="SCConfirm">市场/FAE确认</a>
	{{#  } }}
	{{#  if(d._result_confirm == 'S'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="Result">审批</a>
	{{#  } }}
	{{#  if(d._result_confirm == 'O'){ }}
      	<a class="layui-btn layui-btn-xs" lay-event="Look">查看</a>
	{{#  } }}
      	<a class="layui-btn layui-btn-xs layui-btn-danger" lay-event="delete">删除</a>
</script>

<script type="text/html" id="stateTmp">
	{{#  if(d._zz_confirm == 'S' || d._ipqc_confirm == 'S'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">第一阶段</a>
	{{#  } }}
	{{#  if(d._zz_result == 'S'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">第二阶段</a>
	{{#  } }}
	{{#  if(d._qc_confirm == 'S'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">第三阶段</a>
	{{#  } }}
	{{#  if(d._gy_result_confirm == 'S' || d._qc_result_confirm == 'S'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">第四阶段</a>
	{{#  } }}
	{{#  if(d._sc_confirm == 'S' || d._yf_confirm == 'S'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">第五阶段</a>
	{{#  } }}
	{{#  if(d._result_confirm == 'S'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">第六阶段</a>
	{{#  } }}
	{{#  if(d._result_confirm == 'O'){ }}
		<a class="layui-btn layui-btn-xs layui-btn-info">关闭</a>
	{{#  } }}
</script>

</body>
<!-- layui的引用 js -->
<script type="text/javascript" src="<%=basePath %>js/layui-v2.5.5/layui/layui.js"></script>
<script type="text/javascript" src="<%=basePath %>js/xj-ui/jquery.min.js?v=202s0"></script>
<!-- 页面JS -->
<script>
var basePath = "<%=basePath %>";
</script>
<script type="text/javascript" src="<%=basePath %>jsp/qc/disposal/index.js?v=2020"></script>
</html>