只有一个不同数据 其他都相同的 使用 GROUP_CONCAT(JQLX.C_QXJMC)
SELECT qxj.T_KQ_QXJ_ID,qxj.T_KQ_QXJ_DATE,emp.EMPNAME,GROUP_CONCAT(JQLX.C_QXJMC) AS C_QXJMC
FROM T_KQ_QXJ qxj
LEFT JOIN T_KQ_JQLX jqlx ON qxj.T_KQ_QXJ_ID=jqlx.T_KQ_JQLX_FOREIGNKEY
LEFT JOIN org_employee emp ON qxj.C_EMPID =emp.EMP_ID
WHERE qxj.T_KQ_QXJ_OWNER='19872' AND qxj.C_CJJD ='1' AND jqlx.C_QXJJSSJ>now() AND concat(qxj.T_KQ_QXJ_DATE,emp.EMPNAME) like '%%'
GROUP BY T_KQ_QXJ_DATE,emp.EMPNAME,qxj.T_KQ_QXJ_ID
ORDER BY T_KQ_QXJ_DATE DESC
前端分开接收 var qjlx = po.c_jqlx.split(",");
frame的模态框关闭 frameElement.api.close();
子页面向父页面传值 $("#T_KQ_JQLX_ID",window.parent.document).val(chk_value);
request.getParameter 后端获取前端参数