package com.kind.personnel.basetest;
import java.text.DecimalFormat;
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.springframework.stereotype.Controller;
import org.springframework.stereotype.Service;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;
import com.kind.framework.core.Action;
import com.kind.framework.core.bean.DataContext;
import com.kind.framework.core.bean.Pagination;
import com.kind.framework.service.BaseActionService;
import com.stylefeng.guns.common.utils.excel.ExportExcel;
import cn.hutool.core.util.StrUtil;
import io.undertow.servlet.spec.HttpServletResponseImpl;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* yy 2017.12.15
*
*/
/*@Controller
@RequestMapping(value = "/fitmaterials/index")*/
@Service
@Action(requireLogin = true, action = "#perbasess_main", description = "应用系统配置", powerCode = "personnel.appconfig", requireTransaction = false)
public class FitMaterialAction extends BaseActionService {
@Override
public int handleData(HashMap<String, String> hmLogSql, DataContext dc) {
HttpServletResponse response = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getResponse();
List<Object> paramData = new ArrayList<Object>();
String s_order = null;
StringBuffer sql = new StringBuffer("");
// 初始化查询语句
sql.append("select pb.PERSONID,pb.PERSONNAME, (SELECT DMNR FROM SYS_DMB WHERE DMLX='SEX' AND SYS_DMB.DM=pb.SEX) AS SEX,pb.IDCARD,(SELECT DMNR FROM SYS_DMB WHERE DMLX='NATION' AND SYS_DMB.DM=pb.NATION) AS NATION,pb.HOMETOWN,pb.BIRTHDATE,pb.BIRTHPLACE,pb.WORKDATE,(SELECT cvalue FROM d_code WHERE parentno='HR11' AND ordidx=pb.healthstatus) as healthstatus,pb.SPECIALTY,(SELECT cvalue FROM d_code WHERE parentno='HR14' AND ordidx=pb.politicalstatus) as politicalstatus,pb.JOINPARTYTIME,pb.ENTRYDATE from HR_PERSONNEL_BASE pb where pb.isdel=0 ");
String qname = dc.getRequestString("name");
if (StrUtil.isNotBlank(qname)) {
sql.append(" AND pb.PERSONNAME like ?");
paramData.add("%" + qname + "%");
}
if (StrUtil.isNotBlank(s_order)) {
sql.append(s_order);
}
System.out.println("======"+qname);
// Pagination pdata = this.getPagination(hmLogSql, sql.toString(), Integer.parseInt(page), Integer.parseInt(rows), paramData);
List<Map<String, Object>> HR02List = null;
HR02List = this.getSelectList(hmLogSql, sql.toString(), paramData);
try {
List<Map<String, Object>> result = HR02List;
for (Map<String, Object> map : result) {
map.put("姓名",(map.get("PERSONNAME")));
map.put("性别", (map.get("SEX")));
map.put("身份证号码", (map.get("IDCARD")));
map.put("民族", (map.get("NATION")));
map.put("籍贯", (map.get("HOMETOWN")));
map.put("出生年月",(map.get("BIRTHDATE")));
map.put("出生地", (map.get("BIRTHPLACE")));
map.put("参加工作时间",(map.get("WORKDATE")));
map.put("健康状况",(map.get("HEALTHSTATUS")));
map.put("离职时间",(map.get("SPECIALTY")));
map.put("政治面貌",(map.get("POLITICALSTATUS")));
map.put("入党时间", (map.get("JOINPARTYTIME")));
map.put("到集团本部时",(map.get("ENTRYDATE")));
}
List<String> columnList = new ArrayList<String>();
columnList.add("姓名");
columnList.add("性别");
columnList.add("身份证号码");
columnList.add("民族");
columnList.add("籍贯");
columnList.add("出生年月");
columnList.add("出生地");
columnList.add("参加工作时间");
columnList.add("健康状况");
columnList.add("离职时间");
columnList.add("政治面貌");
columnList.add("入党时间");
columnList.add("到集团本部时");
String fileName = "人事信息_" + new SimpleDateFormat("yyyyMMdd").format(new Date()) + ".xlsx";
;
String title = "人事信息表";
new ExportExcel(title, columnList).setDataList(result).write(response, fileName).dispose();
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}
@Override
public String pageAddress(DataContext arg0) {
// TODO Auto-generated method stub
return null;
}
@Override
public String verifyParameter(DataContext arg0) {
// TODO Auto-generated method stub
return null;
}
}