二维码生成方法

package controller;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import utils.DateUtil;
import utils.JfinalUtils;
import utils.JsonPrint;
import utils.QiNiuUtils;
import utils.TwoDimensionCode;

import com.jfinal.core.Controller;
import com.jfinal.kit.PathKit;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;
import com.lowagie.text.Document;
import com.lowagie.text.Element;
import com.lowagie.text.Font;
import com.lowagie.text.Image;
import com.lowagie.text.PageSize;
import com.lowagie.text.Phrase;
import com.lowagie.text.pdf.BaseFont;
import com.lowagie.text.pdf.PdfPCell;
import com.lowagie.text.pdf.PdfPTable;
import com.lowagie.text.pdf.PdfWriter;

public class ProductController extends Controller {
	int qnSwitch = Integer.parseInt(Db.findById("config", "cid", 1)
			.get("cqnswitch").toString());
	
	String qnIp = Db.findById("config", "cid", 2).get("cqnswitch").toString();
	 List<String>qiuniuImage=new ArrayList<String>();
	 List<String>bendiImage=new ArrayList<String>();
	 
	 
	/**
	 * 获取所有产品
	 */
	public void getProduct() {
		String p_name = getPara("p_name");
		if (p_name == null) {
			p_name = "";
		}
		setAttr("p_name", p_name);
		int counts = JfinalUtils
				.getCounts("SELECT count(1) FROM product p INNER JOIN product_type pt ON pt.pt_id=p.p_pt_id INNER JOIN languages l ON l.l_id=pt.pt_lid   left JOIN  qr_code ON qr_code.q_p_id=p.p_id   where p.p_name like '%"
						+ p_name + "%'");
		//这个分页的方法 只是对本地的图片路径加上项目地址。对七牛的图片
		/*Record record = JfinalUtils.getPaginate(
				this,
				counts,
				JfinalUtils.init_pageCurrent(this),
				JfinalUtils.init_pageSize(this),
				"select p.p_id,p.p_name,p.p_pic1,p.p_pic2,p.p_introduce,p.p_detail,l.l_name,pt.pt_name,p.p_score,qr_code.g_c_pic",
				" FROM product p inner join product_type pt on pt.pt_id=p.p_pt_id INNER JOIN languages l ON l.l_id=pt.pt_lid  left JOIN  qr_code ON qr_code.q_p_id=p.p_id   where p.p_name like '%"
						+ p_name + "%'", "p_pic1","g_c_pic");*/
		qiuniuImage.add("g_c_pic_ser");
		bendiImage.add("g_c_pic");
		Record record = JfinalUtils.getPaginate(this, counts, JfinalUtils.init_pageCurrent(this), JfinalUtils.init_pageSize(this)," select p.p_id,p.p_name,p.p_pic1,p.p_pic2,p.p_introduce,p.p_detail,l.l_name,pt.pt_name,p.p_score,qr_code.g_c_pic_ser,qr_code.g_c_pic", "  FROM product p inner join product_type pt on pt.pt_id=p.p_pt_id INNER JOIN languages l ON l.l_id=pt.pt_lid  left JOIN  qr_code ON qr_code.q_p_id=p.p_id   where p.p_name like '%"
						+ p_name + "%' ", qiuniuImage, bendiImage );
		setAttr("record",record);
		render("productList.jsp");
	}

	/**
	 * 查找产品信息以备修改
	 */
	public void toEditProduct() {
		Integer p_id = getParaToInt("p_id");
		setAttr("product_type", Db.find("select * from product_type"));
		setAttr("product", Db.findById("product", "p_id", p_id));
		render("editProduct.jsp");
	}

	/**
	 * 修改产品信息
	 */
	public void editProduct() {
		try {
			String p_id = getPara("p_id");
			String p_name = getPara("p_name");
			String p_pic1 = getPara("p_pic1");//如果没修改图片传来的是 七牛图片，修改的话是本地图片
			String p_introduce = getPara("p_introduce");
			String p_detail = getPara("p_detail");
			 //转换字符串
			if(null != p_detail){
				p_detail = p_detail.replaceAll(" width=\"100%\"", "");
				p_detail = p_detail.replaceAll("<img", "<img width=\"100%\"");
			} 
			String p_pt_id = getPara("p_pt_id");
			// 积分
		    String p_score= getPara("p_score");
		    String p_pic2=" ";
		    //如果七牛开关是开着的
		    if (qnSwitch==0) {
		    	if (!p_pic1.contains(qnIp)&&null!=p_pic1) {
					//表示图片时新上传的
		    		p_pic2=p_pic1;
		    	    p_pic2 = QiNiuUtils.upload("kapploy",
		    				PathKit.getWebRootPath() + "/" + p_pic1);
		    		p_pic2 = "http://olce3fpso.bkt.clouddn.com/" + p_pic2;
				} else {
                   //图片没更换
					p_pic2=p_pic1;
					//因为图片没跟换需要查出本地的图片
				     p_pic1 = Db.queryStr(" SELECT   p_pic1 FROM product where p_id=?", p_id);
				}
			} else {
				//七牛开关关闭的话，如果图片没有编辑替换 .显示的是七牛图片
				if (p_pic1.contains(qnIp)) {
					p_pic2=p_pic1;
					p_pic1 = Db.queryStr(" SELECT   p_pic1 FROM product where p_id=?", p_id);	 
				}else {
					p_pic2=p_pic1; 
				}
			}
		    //判断传来的七牛图片是不是本地的，是的话是新上传的
			Db.update(
					"product",
					"p_id",
					new Record().set("p_id", p_id).set("p_name", p_name)
							.set("p_pic1", p_pic1).set("p_pic2", p_pic2)
							.set("p_introduce", p_introduce)
							.set("p_detail", p_detail).set("p_pt_id", p_pt_id)
							.set("p_score", p_score));
			JsonPrint.printJsonBjuiTab(this, 200, "修改成功", "getProduct", true);
		} catch (Exception e) {
			JsonPrint.printJsonBjuiTab(this, 300, "修改失败", "getProduct", false);
			e.printStackTrace();
		}
	}

	/**
	 * 查找语言以备添加
	 */
	public void toAddProduct() {
		setAttr("product_type", Db.find("select * from product_type"));
		render("addProduct.jsp");
	}

	/**
	 * 添加产品
	 * 
	 * @throws IOException
	 */
	public void addProduct() throws IOException {
		String p_name = getPara("p_name");
		String p_pic1 = getPara("p_pic1");//本地图片
		String p_introduce = getPara("p_introduce");
		String p_detail = getPara("p_detail");
		
		 //转换字符串
			if(null != p_detail){
				p_detail = p_detail.replaceAll(" width=\"100%\"", "");
				p_detail = p_detail.replaceAll("<img", "<img width=\"100%\"");
			} 
		String p_pt_id = getPara("p_pt_id");
		String p_score= getPara("p_score");
		String p_pic2 = getPara("p_pic1");//本地图片
		if (null==p_pic1) {
			p_pic1="";
			p_pic2="";
		} else {
			//处理七牛图片
		    p_pic2 = QiNiuUtils.upload("kapploy",
					PathKit.getWebRootPath() + "/" + p_pic1);
			p_pic2 = "http://olce3fpso.bkt.clouddn.com/" + p_pic2;
		}
		// ----------------------二维码操作---------------------------------------------------------------------------------------------------
		// 增加商品的同时添加二维码
		// 把生成的二维码保存在项目根目录下的code的image下9
		String imgPath = this.getClass().getResource("/") + "code/image/"
				+ System.currentTimeMillis() + ".png";
		System.out.println("====打印下imgPath这个路经" + imgPath);
		System.out.println(PathKit.getWebRootPath());
		imgPath = imgPath.replace("WEB-INF", "");
		imgPath = imgPath.replace("classes", "");
		imgPath = imgPath.replace("//", "");
		imgPath = imgPath.replace("file:", "");
		String imgPath1 = imgPath.substring(imgPath.indexOf("code"),
				imgPath.length());// 留下相对路径 code/image/1493693806392.png
		Record Product = new Record();
		//为了防止id是单一的
		boolean save = Db.save(
				"product",
				"p_id",
				Product.set("p_name", p_name).set("p_pic1", p_pic1)
						.set("p_pic2", p_pic2).set("p_introduce", p_introduce)
						.set("p_detail", p_detail).set("p_pt_id", p_pt_id)
						.set("p_score", p_score));
		Record qr_code = new Record();
		Db.save("qr_code",
				"q_c_id",
				qr_code.set("q_p_id", Product.get("p_id"))
						.set("g_c_time", DateUtil.getDay("yyyy-MM-dd HH:mm:ss"))
						.set("g_c_pic", imgPath1));
		TwoDimensionCode handler = new TwoDimensionCode();
		handler.encoderQRCode("kapploy:"+Product.get("p_id") + "", imgPath);// 二维码里面存放的是产品的id
		// 本地生成二维码之后，再上传到七牛
		String g_c_pic_ser = QiNiuUtils.upload("kapploy",
				PathKit.getWebRootPath() + "/" + imgPath1);//上传七牛的是本地全路径
		g_c_pic_ser = "http://olce3fpso.bkt.clouddn.com/" + g_c_pic_ser;
		Db.update("qr_code", "q_p_id", qr_code.set("g_c_pic_ser", g_c_pic_ser));
		if (save) {
			JsonPrint.printJsonBjuiTab(this, 200, "添加成功", "getProduct", true);
		} else {
			JsonPrint.printJsonBjuiTab(this, 300, "添加失败", "getProduct", false);
		}
	}

	/**导出二维码操作
	 * @since 1.0 <br>
	 *        <b>作者： @author MZ</b> <br>
	 *        创建时间：2017-5-2 下午3:24:14
	 */
	public void toExportProduct() {
		try {
			init();
			document.setPageSize(PageSize.A2);// 设置页面大小
			File file = new File(PathKit.getWebRootPath()+"//code//pdf//"+ System.currentTimeMillis() + ".pdf");
			file.createNewFile();
			try {
				PdfWriter.getInstance(document, new FileOutputStream(file));
				document.open();
			} catch (Exception e) {
				e.printStackTrace();
			}
			String p_id=getPara("expids");
			List<Record> list = Db
					.find("SELECT   product.p_name,pt_name,product.p_score ,qr_code.g_c_pic,qr_code.g_c_time FROM   product INNER JOIN product_type ON product_type.pt_id=product.p_pt_id INNER JOIN qr_code ON  qr_code.q_p_id=product.p_id    WHERE p_id  IN ("
							+ p_id + ")");
			generatePDF(list, "商品");
			renderFile(file);
		} catch (Exception e) {
			JsonPrint.printJsonBjuiTab(this, 300, "信息导出失败", "", false);
			e.printStackTrace();
		}  
	 
	}
	
	
	Document document = new Document();// 建立一个Document对象
	private static Font headfont;// 设置字体大小
	private static Font keyfont;// 设置字体大小
	private static Font textfont;// 设置字体大小

	public void init() {
		BaseFont bfChinese;
		try {
			// bfChinese =
			// BaseFont.createFont("STSong-Light","UniGB-UCS2-H",BaseFont.NOT_EMBEDDED);
			bfChinese = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H",
					BaseFont.NOT_EMBEDDED);
			headfont = new Font(bfChinese, 10, Font.BOLD);// 设置字体大小
			keyfont = new Font(bfChinese, 8, Font.BOLD);// 设置字体大小
			textfont = new Font(bfChinese, 8, Font.NORMAL);// 设置字体大小
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	int maxWidth = 520;

	public PdfPTable createTable(int colNumber) {
		PdfPTable table = new PdfPTable(colNumber);
		try {
			table.setTotalWidth(maxWidth);
			table.setLockedWidth(true);
			table.setHorizontalAlignment(Element.ALIGN_CENTER);
			table.getDefaultCell().setBorder(1);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return table;
	}
	
	
	public PdfPCell createCell(String value, com.lowagie.text.Font font,
			int align) {
		PdfPCell cell = new PdfPCell();
		cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
		cell.setHorizontalAlignment(align);
		cell.setPhrase(new Phrase(value, font));
		return cell;
	}

	public PdfPCell createCell(String value, com.lowagie.text.Font font) {
		PdfPCell cell = new PdfPCell();
		cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
		cell.setHorizontalAlignment(Element.ALIGN_CENTER);
		cell.setPhrase(new Phrase(value, font));
		return cell;
	}

	public PdfPCell createCell(String value, com.lowagie.text.Font font,
			int align, int colspan) {
		PdfPCell cell = new PdfPCell();
		cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
		cell.setHorizontalAlignment(align);
		cell.setColspan(colspan);
		cell.setPhrase(new Phrase(value, font));
		return cell;
	}

	public PdfPCell createCell(String value, com.lowagie.text.Font font,
			int align, int colspan, boolean boderFlag) {
		PdfPCell cell = new PdfPCell();
		cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
		cell.setHorizontalAlignment(align);
		cell.setColspan(colspan);
		cell.setPhrase(new Phrase(value, font));
		cell.setPadding(3.0f);
		if (!boderFlag) {
			cell.setBorder(0);
			cell.setPaddingTop(15.0f);
			cell.setPaddingBottom(8.0f);
		}
		return cell;
	}

	
	
	public void generatePDF(List<Record> list, String type) throws Exception {
		PdfPTable table = createTable(6);
		table.addCell(createCell(type + "信息列表：", keyfont, Element.ALIGN_LEFT,
				6, false));
		table.addCell(createCell("序号", keyfont, Element.ALIGN_CENTER));
		table.addCell(createCell("产品", keyfont, Element.ALIGN_CENTER));
		table.addCell(createCell("类型", keyfont, Element.ALIGN_CENTER));
		table.addCell(createCell("积分", keyfont, Element.ALIGN_CENTER));
 		table.addCell(createCell("二维码", keyfont, Element.ALIGN_CENTER));
		table.addCell(createCell("二维码生成时间", keyfont, Element.ALIGN_CENTER));

		for (int i = 0; i < list.size(); i++) {
			Record record = list.get(i);
			table.addCell(createCell(i + 1 + "", textfont));
			table.addCell(createCell(record.get("p_name").toString(), textfont));
			table.addCell(createCell(record.get("pt_name").toString(),
					textfont));
			table.addCell(createCell(record.get("p_score").toString(),
					textfont));
			Image jpg = Image.getInstance(PathKit.getWebRootPath()
					+ File.separator + record.get("g_c_pic"));
			jpg.scaleAbsolute(50, 37);
			table.addCell(jpg);
			table.addCell(createCell(record.get("g_c_time").toString(),
					textfont));
		}
		document.add(table);
		document.close();
	}
	
 

	/**
	 * 上传图片
	 */
	public void addpics() {
		Record re = new Record();
		try {
			File f1 = getFile().getFile();
			String oldname = f1.getName();
			String na = "product/uploadimages/" + System.currentTimeMillis()
					+ oldname.substring(oldname.lastIndexOf("."));
			String filename = PathKit.getWebRootPath() + "/" + na;

			f1.renameTo(new File(filename));
			re.set("statusCode", "200");
			re.set("message", "上传成功！");
			re.set("filename", na);
			renderJson(re);
		} catch (Exception e) {
			re.set("statusCode", "300");
			re.set("message", "上传失败！");
			re.set("filename", "../");
			renderJson(re);
			e.printStackTrace();
		}
	}

	/**
	 * 删除产品
	 */
	public void dels() {
		try {
			String delids = getPara("delids");
			Db.update("DELETE FROM product WHERE p_id IN ("+delids+")");
			JsonPrint.printJsonBjuiTab(this, 200, "删除成功", "getProduct", false);
		} catch (Exception e) {
			JsonPrint.printJsonBjuiTab(this, 300, "删除失败", "getProduct", false);
			e.printStackTrace();
		}
	}
 
}