下拉搜索框 下拉搜索框 条件查询
1.
package com.fh.controller.warehousemanage.ckqd;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import org.apache.shiro.crypto.hash.SimpleHash;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.WebDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import com.fh.controller.base.BaseController;
import com.fh.entity.Page;
import com.fh.entity.system.Role;
import com.fh.util.AppUtil;
import com.fh.util.Const;
import com.fh.util.FileDownload;
import com.fh.util.FileUpload;
import com.fh.util.GetPinyin;
import com.fh.util.ObjectExcelRead;
import com.fh.util.ObjectExcelView;
import com.fh.util.PageData;
import com.fh.util.Jurisdiction;
import com.fh.util.PathUtil;
import com.fh.util.Tools;
import com.fh.service.system.fhlog.FHlogManager;
import com.fh.service.warehousemanage.ckqd.CkqdManager;
/**
* 说明:出库清单0327
* 创建人:徐志永
* 创建时间:2017-03-27
*/
@Controller
@RequestMapping(value="/ckqd")
public class CkqdController extends BaseController {
String menuUrl = "ckqd/list.do"; //菜单地址(权限用)
@Resource(name="ckqdService")
private CkqdManager ckqdService;
@Resource(name="fhlogService")
private FHlogManager FHLOG;
/**保存
* @param
* @throws Exception
*/
@RequestMapping(value="/save")
public ModelAndView save() throws Exception{
logBefore(logger, Jurisdiction.getUsername()+"新增Ckqd");
if(!Jurisdiction.buttonJurisdiction(menuUrl, "add")){return null;} //校验权限
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
pd.put("SBQD_ID", this.get32UUID()); //主键
ckqdService.save(pd);
mv.addObject("msg","success");
mv.setViewName("save_result");
return mv;
}
/**删除
* @param out
* @throws Exception
*/
@RequestMapping(value="/delete")
public void delete(PrintWriter out) throws Exception{
logBefore(logger, Jurisdiction.getUsername()+"删除Ckqd");
if(!Jurisdiction.buttonJurisdiction(menuUrl, "del")){return;} //校验权限
PageData pd = new PageData();
pd = this.getPageData();
ckqdService.delete(pd);
out.write("success");
out.close();
}
/**修改
* @param
* @throws Exception
*/
@RequestMapping(value="/edit")
public ModelAndView edit() throws Exception{
logBefore(logger, Jurisdiction.getUsername()+"修改Ckqd");
if(!Jurisdiction.buttonJurisdiction(menuUrl, "edit")){return null;} //校验权限
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
ckqdService.edit(pd);
mv.addObject("msg","success");
mv.setViewName("save_result");
return mv;
}
/**列表
* @param page
* @throws Exception
*/
@RequestMapping(value="/list")
public ModelAndView list(Page page) throws Exception{
logBefore(logger, Jurisdiction.getUsername()+"列表Ckqd");
//if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;} //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
String keywords = pd.getString("keywords"); //关键词检索条件
if(null != keywords && !"".equals(keywords)){
pd.put("keywords", keywords.trim());
}
String lastLoginStart = pd.getString("lastLoginStart"); //开始时间
String lastLoginEnd = pd.getString("lastLoginEnd"); //结束时间
if(lastLoginStart != null && !"".equals(lastLoginStart)){
pd.put("lastLoginStart", lastLoginStart+" 00:00:00");
}
if(lastLoginEnd != null && !"".equals(lastLoginEnd)){
pd.put("lastLoginEnd", lastLoginEnd+" 00:00:00");
}
page.setPd(pd);
List<PageData> varList = ckqdService.list(page); //列出Ckqd列表
mv.setViewName("warehousemanage/ckqd/ckqd_list");
mv.addObject("varList", varList);
mv.addObject("pd", pd);
mv.addObject("QX",Jurisdiction.getHC()); //按钮权限
return mv;
}
/**去新增页面
* @param
* @throws Exception
*/
@RequestMapping(value="/goAdd")
public ModelAndView goAdd()throws Exception{
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
mv.setViewName("warehousemanage/ckqd/ckqd_edit");
mv.addObject("msg", "save");
mv.addObject("pd", pd);
return mv;
}
/**去修改页面
* @param
* @throws Exception
*/
@RequestMapping(value="/goEdit")
public ModelAndView goEdit()throws Exception{
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
pd = ckqdService.findById(pd); //根据ID读取
mv.setViewName("warehousemanage/ckqd/ckqd_edit");
mv.addObject("msg", "edit");
mv.addObject("pd", pd);
return mv;
}
/**批量删除
* @param
* @throws Exception
*/
@RequestMapping(value="/deleteAll")
@ResponseBody
public Object deleteAll() throws Exception{
logBefore(logger, Jurisdiction.getUsername()+"批量删除Ckqd");
if(!Jurisdiction.buttonJurisdiction(menuUrl, "del")){return null;} //校验权限
PageData pd = new PageData();
Map<String,Object> map = new HashMap<String,Object>();
pd = this.getPageData();
List<PageData> pdList = new ArrayList<PageData>();
String DATA_IDS = pd.getString("DATA_IDS");
if(null != DATA_IDS && !"".equals(DATA_IDS)){
String ArrayDATA_IDS[] = DATA_IDS.split(",");
ckqdService.deleteAll(ArrayDATA_IDS);
pd.put("msg", "ok");
}else{
pd.put("msg", "no");
}
pdList.add(pd);
map.put("list", pdList);
return AppUtil.returnObject(pd, map);
}
/**导出到excel
* @param
* @throws Exception
*/
@RequestMapping(value="/excel")
public ModelAndView exportExcel() throws Exception{
logBefore(logger, Jurisdiction.getUsername()+"导出Ckqd到excel");
if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
ModelAndView mv = new ModelAndView();
PageData pd = new PageData();
pd = this.getPageData();
Map<String,Object> dataMap = new HashMap<String,Object>();
List<String> titles = new ArrayList<String>();
titles.add("备注1"); //1
titles.add("备注2"); //2
titles.add("备注3"); //3
titles.add("备注4"); //4
titles.add("备注5"); //5
titles.add("备注6"); //6
titles.add("备注7"); //7
titles.add("备注8"); //8
titles.add("备注9"); //9
titles.add("备注10"); //10
titles.add("备注11"); //11
titles.add("备注12"); //12
titles.add("备注13"); //13
titles.add("备注14"); //14
titles.add("备注15"); //15
titles.add("备注16"); //16
titles.add("备注17"); //17
titles.add("备注18"); //18
dataMap.put("titles", titles);
List<PageData> varOList = ckqdService.listAll(pd);
List<PageData> varList = new ArrayList<PageData>();
for(int i=0;i<varOList.size();i++){
PageData vpd = new PageData();
vpd.put("var1", varOList.get(i).getString("SBQD_ID")); //1
vpd.put("var2", varOList.get(i).getString("SBID")); //2
vpd.put("var3", varOList.get(i).getString("KHID")); //3
vpd.put("var4", varOList.get(i).getString("BAID")); //4
vpd.put("var5", varOList.get(i).getString("NAME")); //5
vpd.put("var6", varOList.get(i).getString("RKRQ")); //6
vpd.put("var7", varOList.get(i).getString("YJS")); //7
vpd.put("var8", varOList.get(i).getString("RJS")); //8
vpd.put("var9", varOList.get(i).getString("RJBB")); //9
vpd.put("var10", varOList.get(i).getString("WXJL")); //10
vpd.put("var11", varOList.get(i).getString("SBLX")); //11
vpd.put("var12", varOList.get(i).getString("ZKZT")); //12
vpd.put("var13", varOList.get(i).getString("RJGYSP")); //13
vpd.put("var14", varOList.get(i).getString("YJGYSP")); //14
vpd.put("var15", varOList.get(i).getString("BZ")); //15
vpd.put("var16", varOList.get(i).getString("CONTENT")); //16
vpd.put("var17", varOList.get(i).getString("CKRQ")); //17
vpd.put("var18", varOList.get(i).getString("CKZJY")); //18
varList.add(vpd);
}
dataMap.put("varList", varList);
ObjectExcelView erv = new ObjectExcelView();
mv = new ModelAndView(erv,dataMap);
return mv;
}
/**打开上传EXCEL页面
* @return
* @throws Exception
*/
@RequestMapping(value="/goUploadExcel")
public ModelAndView goUploadExcel()throws Exception{
ModelAndView mv = this.getModelAndView();
mv.setViewName("warehousemanage/ckqd/uploadexcel");
return mv;
}
/**下载模版
* @param response
* @throws Exception
*/
@RequestMapping(value="/downExcel")
public void downExcel(HttpServletResponse response)throws Exception{
FileDownload.fileDownload(response, PathUtil.getClasspath() + Const.FILEPATHFILE + "ItemRecord.xls", "ItemRecord.xls");
}
/**下载模版导出打印
* @param response
* @throws Exception
*/
@RequestMapping(value="/downExcel1")
public void downExcel1(HttpServletResponse response)throws Exception{
FileDownload.fileDownload(response, PathUtil.getClasspath() + Const.FILEPATHFILE + "ItemRecord.xls", "ItemRecord.xls");
}
/**从EXCEL导入到数据库
* @param file
* @return
* @throws Exception
*/
@RequestMapping(value="/readExcel")
public ModelAndView readExcel(
@RequestParam(value="excel",required=false) MultipartFile file
) throws Exception{
FHLOG.save(Jurisdiction.getUsername(), "从EXCEL导入到数据库");
ModelAndView mv = this.getModelAndView();
PageData pd = new PageData();
if(!Jurisdiction.buttonJurisdiction(menuUrl, "add")){return null;}
if (null != file && !file.isEmpty()) {
String filePath = PathUtil.getClasspath() + Const.FILEPATHFILE; //文件上传路径
String fileName = FileUpload.fileUp(file, filePath, "ckqdxcel"); //执行上传
List<PageData> listPd = (List)ObjectExcelRead.readExcel(filePath, fileName, 2, 0, 0); //执行读EXCEL操作,读出的数据导入List 2:从第3行开始;0:从第A列开始;0:第0个sheet
/*存入数据库操作======================================*/
/* pd.put("RIGHTS", ""); //权限
pd.put("LAST_LOGIN", ""); //最后登录时间
pd.put("IP", ""); //IP
pd.put("STATUS", "0"); //状态
pd.put("SKIN", "default"); //默认皮肤
pd.put("ROLE_ID", "1");
List<Role> roleList = roleService.listAllRolesByPId(pd);//列出所有系统用户角色
pd.put("ROLE_ID", roleList.get(0).getROLE_ID()); //设置角色ID为随便第一个
*/
for(int i=0;i<listPd.size();i++){
pd.put("SBQD_ID", this.get32UUID()); //ID
pd.put("CKRQ", listPd.get(i).getString("var0"));
pd.put("NAME", listPd.get(i).getString("var1"));
pd.put("SBID", listPd.get(i).getString("var2"));
pd.put("COUNT", listPd.get(i).getString("var3"));
pd.put("KHFHDZ", listPd.get(i).getString("var4"));
pd.put("SHOUHUOSHANG", listPd.get(i).getString("var5"));
pd.put("FHFZR", listPd.get(i).getString("var6"));
pd.put("PC", listPd.get(i).getString("var7"));
pd.put("YJS", listPd.get(i).getString("var8"));
/*pd.put("BZ", listPd.get(i).getString("var8")); */
ckqdService.save(pd);
}
/*存入数据库操作======================================*/
mv.addObject("msg","success");
}
mv.setViewName("save_result");
return mv;
}
@InitBinder
public void initBinder(WebDataBinder binder){
DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
binder.registerCustomEditor(Date.class, new CustomDateEditor(format,true));
}
}
<td style="vertical-align:top;padding-left:2px;">
<select class="chosen-select form-control" name="SBQD_ID" id="sbqd_id" data-placeholder="请选择设备编号" style="vertical-align:top;width: 120px;"><option value=""></option>
<option value="">全部</option>
<c:forEach items="${varList}" var="sbqd">
<option value="${sbqd.SBQD_ID }" <c:if test="${pd.SBQD_ID==sbqd.SBQD_ID}">selected</c:if>>${sbqd.NAME }</option>
</c:forEach>
</select>
</td>
sbqd 设备清单 NAME 设备名称