package?com.rpc.route;

import?java.util.linkedHashMap;
import?java.util.List;
import?java.util.TreeMap;

import?javax.servlet.http.HttpServletResponse;

import?org.json.JSONobject;

import?com.rpc.baseRPC;
import?com.rpc.IsExcute;
import?com.rpc.RequestInfo;

import?java.io.FileOutputStream;

import?com.itextpdf.text.Chapter;
import?com.itextpdf.text.Document;
import?com.itextpdf.text.Font;
import?com.itextpdf.text.PageSize;
import?com.itextpdf.text.Paragraph;
import?com.itextpdf.text.Phrase;
import?com.itextpdf.text.Section;
import?com.itextpdf.text.pdf.baseFont;
import?com.itextpdf.text.pdf.PdfPCell;
import?com.itextpdf.text.pdf.PdfPTable;
import?com.itextpdf.text.pdf.PdfWriter;

import?ywt.Core.Ioc.ServiceImplementation;

@ServiceImplementation（Name?=?“exportpdf“）
public?class?ExportPdf?extends?baseRPC{
	private?TreeMap?requestParasMap?=?null;
	private?static?final?long?serialVersionUID?=?1L;?
	public?ExportPdf（RequestInfo?requestInfo?HttpServletResponse?response）{
		this.requestParasMap?=?requestInfo.requestParasMap;
	}
	@Override
	public?JSONobject?doPut（）?throws?Exception?{
		//?TODO?Auto-generated?method?stub
		return?null;
	}
	@Override
	public?JSONobject?doGet（）?throws?Exception?{
		JSONobject?jo?=?new?JSONobject（）;
		String?sql=“select?a.ida.user_ida.trip_citya.is_audita.audit_sugesta.pay_commissionFROM_UNIXTIME（a.com_exa_time）?as?com_exa_time?FROM_UNIXTIME（a.trip_stime）“
				+?“??as?trip_stime?FROM_UNIXTIME（a.trip_etime）?as?trip_etimec.real_namec.mobile?（select?att_url?from?m_trip_attachment?where?trip_id=a.id??“
				+?“?and?att_type?=0）?as?gotrip_url（select?att_url?from?m_trip_attachment?where?trip_id=a.id??and?att_type?=1）?as?backtrip_url“
				+?“?（?select?sugest?from?m_trip_sugest?where?id=a.audit_type）?as?sugest?from?m_trip_info?a?“
????????????????+?“??left?join?m_user_log?b?on?a.user_id=b.user_id?left?join?m_user_info?c?on?b.user_id=c.user_id??where?1=1?“;
		try?{
			ListnkedHashMap>?list?=?sqlHelper.ExecuteDataMap（sql）;
			writeCharpter（list）;
			return?IsExcute.isExceptionStr（jo?200?requestParasMap）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?IsExcute.isExceptionStr（jo?300?requestParasMap）;
	}
	@Override
	public?JSONobject?doPost（）?throws?Exception?{
		//?TODO?Auto-generated?method?stub
		return?null;
	}
	@Override
	public?JSONobject?doDelete（）?throws?Exception?{
		//?TODO?Auto-generated?method?stub
		return?null;
	}

	/**
	?*?添加含有章節的pdf文件
	?*?
	?*?@throws?Exception
	?*/
	public?static?void?writeCharpter（ListnkedHashMap>?list）?throws?Exception?{
		/*?設置中文編碼?*/
		baseFont?baseFontChinese?=?baseFont.create