package com.changhong.epc.form.rest.Assets;
|
|
import com.changhong.epc.bean.admin.AssetDepreciation;
|
import com.changhong.epc.bean.form.Accrued;
|
import com.changhong.epc.bean.form.Asset;
|
import com.changhong.epc.bean.form.QueryParam;
|
import com.changhong.epc.bean.form.SectoralAssets;
|
import com.changhong.epc.constter.form.utf.FormUrlConst;
|
import com.changhong.epc.form.service.assets.AssetService;
|
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
|
import org.apache.poi.hssf.usermodel.HSSFRow;
|
import org.apache.poi.hssf.usermodel.HSSFSheet;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.web.bind.annotation.*;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
@RestController
|
public class AssetsRest implements FormUrlConst {
|
@Resource(name="assetService")
|
private AssetService assetService;
|
|
/**
|
* 页面初始化查询资产
|
* @throws Exception
|
*/
|
@RequestMapping(value = SELECT_ASSETS, method={RequestMethod.OPTIONS, RequestMethod.POST})
|
public List<SectoralAssets> selectAssets(@RequestBody Map<String,String> data){
|
return assetService.getSectoralAsset(data.get("date"));
|
}
|
|
/**
|
* 同过一级部门进行查找异常数据
|
*
|
*/
|
@RequestMapping(value = SELECT_ERRASSETS, method={RequestMethod.OPTIONS, RequestMethod.POST})
|
public List<Asset> selectErrAssets(@RequestBody QueryParam queryParam) throws Exception{
|
return assetService.getErrAsset(queryParam);
|
}
|
|
/**
|
*通过子部门查询异常资产
|
*
|
*/
|
@RequestMapping(value = SELECT_ERRASSETSBYONE, method={RequestMethod.OPTIONS, RequestMethod.POST})
|
public List<Asset> selectErrAsset(@RequestBody QueryParam queryParam) throws Exception{
|
return assetService.getErrAssetOne(queryParam);
|
}
|
/**
|
* 分页
|
* 通过条件查询
|
* 查询详细
|
* 2018-1-18
|
*/
|
@RequestMapping(value = SELECT_ACCRUED, method={RequestMethod.OPTIONS, RequestMethod.POST})
|
public List<Accrued> selectAccrued(@RequestBody QueryParam queryParam){
|
try {
|
return assetService.getAccrueds(queryParam);
|
} catch (ParseException e) {
|
return null;
|
}
|
}
|
|
/**
|
* 保存前验证资产
|
* @param assetDepreciation
|
* @return
|
*/
|
@PostMapping(VALIDATE_ASSET)
|
public Boolean validateAsset(@RequestBody AssetDepreciation assetDepreciation){
|
return assetService.validateAsset(assetDepreciation);
|
}
|
|
//下载exl
|
@GetMapping(SELECT_DOEXL)
|
public boolean doExl(String date,String useDepCode,String useDepName,String state,String assetName,String assetCode,HttpServletRequest request, HttpServletResponse response){
|
QueryParam qp = new QueryParam();
|
if(date != null && (!date.equals("null")) && (!date.equals(""))){
|
qp.setDate(date);
|
}
|
if(state != null && (!state.equals("null")) && (!state.equals(""))){
|
qp.setState(state);
|
}
|
if(assetCode != null && (!assetCode.equals("null")) && (!assetCode.equals(""))){
|
qp.setAssetCode(assetCode);
|
}
|
if(assetName != null && (!assetName.equals("null")) && (!assetName.equals(""))){
|
qp.setAssetName(assetName);
|
}
|
if(useDepCode != null && (!useDepCode.equals("null")) && (!useDepCode.equals(""))){
|
qp.setUseDepCode(useDepCode);
|
}
|
if(useDepName != null && (!useDepName.equals("null")) && (!useDepName.equals(""))){
|
qp.setUseDepName(useDepName);
|
}
|
List <Accrued> acc = new ArrayList<Accrued>();
|
try {
|
acc=assetService.getAccrueds(qp);
|
} catch (ParseException e1) {
|
}
|
|
// 第一步，创建一个webbook，对应一个Excel文件
|
HSSFWorkbook workbook = new HSSFWorkbook();
|
// 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet 页
|
HSSFSheet sheet = workbook.createSheet(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
|
// 第三步，在sheet中添加表头第0行
|
HSSFRow row = sheet.createRow(0);
|
// 第四步，创建单元格，并设置值表头 设置表头居中
|
HSSFCellStyle style = workbook.createCellStyle();
|
// 创建一个居中格
|
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
|
|
row.createCell(0).setCellValue("序号");
|
row.createCell(1).setCellValue("部门");
|
row.createCell(2).setCellValue("资产编号");
|
row.createCell(3).setCellValue("资产名称");
|
row.createCell(4).setCellValue("规格型号");
|
row.createCell(5).setCellValue("资产化日期");
|
row.createCell(6).setCellValue("预计使用年限(月)");
|
row.createCell(7).setCellValue("已使用年限(月)");
|
row.createCell(8).setCellValue("原值");
|
row.createCell(9).setCellValue("折旧方法");
|
row.createCell(10).setCellValue("累计折旧");
|
row.createCell(11).setCellValue("本月折旧");
|
row.createCell(12).setCellValue("月折旧率(%)");
|
row.createCell(13).setCellValue("折后净值");
|
|
for(int i = 0;i < 14;i++){
|
//设置表头居中
|
row.getCell(i).setCellStyle(style);
|
//设置列宽
|
sheet.setColumnWidth(i, 3500);
|
}
|
sheet.setColumnWidth(0, 1500);
|
// 第五步，写入实体数据
|
for (int i = 0; i < acc.size(); i++) {
|
row = sheet.createRow(i + 1);
|
// 第六步，创建单元格，并设置值
|
if(acc.get(i).getDepreciationMethod().equals("1")){
|
acc.get(i).setDepreciationMethod("双倍余额递减法");
|
}else if(acc.get(i).getDepreciationMethod().equals("2")){
|
acc.get(i).setDepreciationMethod("平均年限法");
|
}else if(acc.get(i).getDepreciationMethod().equals("3")){
|
acc.get(i).setDepreciationMethod("年限总和法");
|
}
|
row.createCell(0).setCellValue(i+1);
|
row.createCell(1).setCellValue(acc.get(i).getUseDepartmentName() == null ? "" : acc.get(i).getUseDepartmentName());
|
row.createCell(2).setCellValue(acc.get(i).getAssetsCode() == null ? "" : acc.get(i).getAssetsCode());
|
row.createCell(3).setCellValue(acc.get(i).getAssetsName() == null ? "" : acc.get(i).getAssetsName());
|
row.createCell(4).setCellValue(acc.get(i).getSpecifications() == null ? "" : acc.get(i).getSpecifications());
|
row.createCell(5).setCellValue(acc.get(i).getCapitalizationData() == null ? "" : acc.get(i).getCapitalizationData());
|
row.createCell(6).setCellValue(acc.get(i).getEstimateTime() == null ? "" : acc.get(i).getEstimateTime());
|
row.createCell(7).setCellValue(acc.get(i).getAlreadyTime() == null ? "" : acc.get(i).getAlreadyTime());
|
row.createCell(8).setCellValue(acc.get(i).getOriginalMoney() == null ? "" : acc.get(i).getOriginalMoney());
|
row.createCell(9).setCellValue(acc.get(i).getDepreciationMethod() == null ? "" : acc.get(i).getDepreciationMethod());
|
row.createCell(10).setCellValue(acc.get(i).getCumulativeDepreciation() == null ? 0 : acc.get(i).getCumulativeDepreciation());
|
row.createCell(11).setCellValue(acc.get(i).getCurrentDepreciation() == null ? 0 : acc.get(i).getCurrentDepreciation());
|
row.createCell(12).setCellValue(acc.get(i).getDepreciationRate() == null ? 0 : acc.get(i).getDepreciationRate());
|
row.createCell(13).setCellValue(acc.get(i).getNetMoney() == null ? 0 : acc.get(i).getNetMoney());
|
}
|
String downFileName = new String("资产折旧信息"+new SimpleDateFormat("yyyy-MM").format(new Date())+".xls");
|
try {
|
//若不进行编码在IE下会乱码
|
downFileName = URLEncoder.encode(downFileName, "UTF-8");
|
} catch (Exception e) {
|
}
|
try (OutputStream os = response.getOutputStream()){
|
// 清空response
|
response.reset();
|
response.setContentType("application/msexcel");//设置生成的文件类型
|
response.setCharacterEncoding("UTF-8");//设置文件头编码方式和文件名
|
response.setHeader("Content-Disposition", "attachment; filename=" + new String(downFileName.getBytes("utf-8"), "ISO8859-1"));
|
workbook.write(os);
|
os.flush();
|
} catch (IOException e) {
|
// System.err.println(e.getMessage());
|
return false;
|
}
|
return true;
|
}
|
|
@PostMapping(ASSET_UPDATESTATUS)
|
public int updateAssetsByState(@RequestBody Map<String,String> map){
|
return assetService.updateAssetsByState(map);
|
}
|
|
}
|
