package hb.controller;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.imageio.ImageIO;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.jeecgframework.core.util.ResourceUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.fr.third.com.lowagie.text.Chunk;
import com.fr.third.com.lowagie.text.Document;
import com.fr.third.com.lowagie.text.DocumentException;
import com.fr.third.com.lowagie.text.Element;
import com.fr.third.com.lowagie.text.Font;
import com.fr.third.com.lowagie.text.Image;
import com.fr.third.com.lowagie.text.PageSize;
import com.fr.third.com.lowagie.text.Paragraph;
import com.fr.third.com.lowagie.text.Phrase;
import com.fr.third.com.lowagie.text.Rectangle;
import com.fr.third.com.lowagie.text.pdf.BaseFont;
import com.fr.third.com.lowagie.text.pdf.ColumnText;
import com.fr.third.com.lowagie.text.pdf.PdfContentByte;
import com.fr.third.com.lowagie.text.pdf.PdfPCell;
import com.fr.third.com.lowagie.text.pdf.PdfPRow;
import com.fr.third.com.lowagie.text.pdf.PdfPTable;
import com.fr.third.com.lowagie.text.pdf.PdfWriter;
import com.fr.third.com.lowagie.text.pdf.draw.LineSeparator;
import hb.entity.OrganizeInformationModel;
import hb.service.ComponentPictureLedgerService;
/**
* 组件图片台账
*
* @author jf
*
*/
@Controller
@RequestMapping("/cplController")
public class ComponentPictureLedgerController {
@Autowired
private ComponentPictureLedgerService pictureLedgerService;
/**
* @author jf
* @param 根据条件查询基础图片台账信息
*/
@RequestMapping(params = "queryComponentPictureLedger")
@ResponseBody
public List> queryComponentPictureLedger(HttpServletRequest request,
HttpServletResponse response) {
try {
String LOCATIONA_CODE = new String(request.getParameter("LOCATIONA_CODE").getBytes("ISO8859-1"), "UTF-8");
String LOCATIONB_CODE = new String(request.getParameter("LOCATIONB_CODE").getBytes("ISO8859-1"), "UTF-8");
String LOCATIONC_CODE = new String(request.getParameter("LOCATIONC_CODE").getBytes("ISO8859-1"), "UTF-8");
String TAG = new String(request.getParameter("TAG").getBytes("ISO8859-1"), "UTF-8");
String DTM = request.getParameter("DTM");
String device_type = new String(request.getParameter("device_type").getBytes("ISO8859-1"), "UTF-8");
String device_type_childer = new String(request.getParameter("device_type_childer").getBytes("ISO8859-1"),
"UTF-8");
String device_medium_state = new String(request.getParameter("device_medium_state").getBytes("ISO8859-1"),
"UTF-8");
String UTM = request.getParameter("UTM");
String poos = request.getParameter("poos");
String ON_REMOVAL_BOX = request.getParameter("ON_REMOVAL_BOX");
String INSPECTION_FREQUENCY_CODE = new String(
request.getParameter("INSPECTION_FREQUENCY_CODE").getBytes("ISO8859-1"), "UTF-8");
OrganizeInformationModel org = new OrganizeInformationModel();
org.setComponentTypeCode(device_type);
org.setSubTypeCode(device_type_childer);
org.setManufacturersCode(device_medium_state);
org.setUtm(UTM);
org.setTag(TAG);
org.setDtm(DTM);
org.setPoos(poos);
org.setLocationaCode(LOCATIONA_CODE);
org.setLocationbCode(LOCATIONB_CODE);
org.setLocationcCode(LOCATIONC_CODE);
org.setOnRemovalBox(ON_REMOVAL_BOX);
org.setInspectionFrequencyCode(INSPECTION_FREQUENCY_CODE);
List> componentFoundationLedgers = pictureLedgerService.findComponentPictureInfo(org);
return componentFoundationLedgers;
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}