List of usage examples for com.itextpdf.text.pdf PdfPCell setHorizontalAlignment
public void setHorizontalAlignment(int horizontalAlignment)
From source file:juaam.PDFHandle.java
private void createTable(Document document) throws BadElementException { TableModel model = tab.getModel(); PdfPTable table = new PdfPTable(model.getColumnCount()); for (int i = 0; i < model.getColumnCount(); i++) { String st = model.getColumnName(i); PdfPCell c1 = new PdfPCell(new Phrase(st)); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1);/* w w w.j a va 2 s. c o m*/ } // t.setBorderColor(BaseColor.GRAY); // t.setPadding(4); // t.setSpacing(4); // t.setBorderWidth(1); // PdfPCell c1 = new PdfPCell(new Phrase("Serial")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Registration No")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Name")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Batch")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Contact")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Registration Mode")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Reciept No.")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Amount")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("No of Participants")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // // c1 = new PdfPCell(new Phrase("Date")); // c1.setHorizontalAlignment(Element.ALIGN_CENTER); // table.addCell(c1); // table.setHeaderRows(1); // table.addCell("1.0"); // table.addCell("1.1"); // table.addCell("1.2"); // table.addCell("2.1"); // table.addCell("2.2"); // table.addCell("2.3"); // table.addCell("2.3"); // table.addCell("2.32"); // table.addCell("2.33"); // table.addCell("2.34"); //FileWriter excel = new FileWriter(file); for (int i = 0; i < model.getRowCount(); i++) { for (int j = 0; j < model.getColumnCount(); j++) { String value = (model.getValueAt(i, j).toString()); table.addCell(value); } } try { document.add(table); // subCatPart.add(table); } catch (DocumentException ex) { Logger.getLogger(PDFHandle.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:klasy.PdfFiles.java
public static void createTable() { try {//from w w w . j a v a 2 s .c om Document document = new Document(); PdfWriter.getInstance(document, new FileOutputStream(FILE2)); document.open(); PdfPTable table = new PdfPTable(8); PdfPCell c1 = new PdfPCell(new Phrase("Imie pasazera")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Nazwisko pasazera")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Data lotu")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Data wystawienia biletu")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Cel podrozy: ")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Cena: ")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Model samolotu: ")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); c1 = new PdfPCell(new Phrase("Nr lotu: ")); c1.setHorizontalAlignment(Element.ALIGN_CENTER); table.addCell(c1); Functions f = new Functions(); for (Bilet b : bilety) { Miasto m = f.getMiasto(b); Samolot s = f.getSamolot(b); table.addCell(b.getImie_pasazera()); table.addCell(b.getNazwisko_pasazera()); table.addCell(b.getData_lotu()); table.addCell(b.getData_wystawienia_biletu()); table.addCell(m.getNazwa()); table.addCell(Double.toString(m.getCena())); table.addCell(s.getModel()); table.addCell(s.getNr_samolotu()); //JOptionPane.showMessageDialog(null, b); } Paragraph preface = new Paragraph(); preface.add(table); document.add(preface); document.close(); addEmptyLine(preface, 30); preface.add(new Paragraph("Wygenerowano: " + new Date(), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ smallBold)); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } }
From source file:lk.score.androphsy.report.ReportPdf.java
License:Open Source License
private void CreateTable(Paragraph subpara, String feature) { System.out.println("Report Create Table: " + feature); try {/* w w w. j a v a2s. c o m*/ String query = ""; Connection conn = new ConnectDb().getConnection(); Statement stmt = conn.createStatement(); if (feature == "PRIMARY_ACC") { query = "SELECT host AS 'Account Type', username AS 'User Name'," + " password AS 'Password (HASHED)'" + " FROM Androspy_Account" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND primary_acc = " + 1; } else if (feature == "OTHER_ACC") { query = "SELECT host AS 'Account Type', username AS 'User Name'," + " password AS 'Password'" + " FROM Androspy_Account" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND primary_acc != " + 1; } else if (feature == "SMS") { query = "SELECT subject AS 'Subject', body AS 'Message Body'," + " type AS 'Message Type', date_received AS 'Received Date', date_sent AS 'Send Date'" + " FROM Sms" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Phone Book") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " times_contacted AS 'Times Contacted', last_time_contacted AS 'Last Contacted Date'" + " FROM Contacts" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Gmail") { query = "SELECT fromaddress AS 'From Address'," + " toaddress AS 'To Address', ccaddress AS 'CC Address', bccaddress AS 'BCC Address'," + " replytoaddress AS 'Reply To Address', subject AS 'Subject', snippet As 'Message Body', " + "datesent AS 'Send Date', datereceive AS 'Received Date'" + " FROM Gmail_Store" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Calendar") { query = "SELECT title AS 'Title', description AS 'Event', location AS 'Location'," + " start_time AS 'Start Time', end_time AS 'End Time', created_by AS 'Creator'" + " FROM Calendar_Event" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "YouTube") { query = "SELECT query AS 'Search' , search_date AS 'Time Stamp'" + " FROM Youtube_History" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("FACEBOOK_MESSAGES")) { query = "SELECT IFNULL(sender, '') AS 'Sender'," + " IFNULL(text, '') AS 'Message'," + " IFNULL(conversation_date, '') AS 'Date'," + " IFNULL(logitude, '') AS 'Longitude'," + " IFNULL(latitude, '') AS 'Latitude'" + " FROM Facebook_Message" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("FACEBOOK_CONTACTS")) { query = "SELECT IFNULL(first_name, '') AS 'First Name'," + " IFNULL(last_name, '') AS 'Last Name'," + " IFNULL(display_name, '') AS 'Display Name'," + " IFNULL(added_time, '') AS 'Time Stamp'," + " IFNULL(type, '') AS 'Contact Type'" + " FROM Fb_Contacts" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("FACEBOOK_NOTIFICATIONS")) { query = "SELECT IFNULL(notification, '') AS 'Notification'," + " IFNULL(update_date, '') AS 'Date'" + " FROM Facebook_Notifications" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("LINKEDIN_PROFILE")) { query = "SELECT first_name AS 'First Name', last_name AS 'Last Name', display_name AS 'Display Name'," + "country AS 'Country', join_date AS 'Join Date', connections AS 'No of Connections'" + " FROM Linkedin_Profile" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("LINKEDIN_CONNECTIONS")) { query = "SELECT IFNULL(first_name, '') AS 'First Name'," + " IFNULL(last_name, '') AS 'Last Name'," + " IFNULL(display_name, '') AS 'Display Name'," + " IFNULL(title, '') AS 'Title'" + " FROM Linkedin_Connections" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("LINKEDIN_INVITATIONS")) { query = "SELECT IFNULL(from_display_name, '') AS 'Sender Name'," + " IFNULL(title, '') AS 'Title'," + " IFNULL(invitation_date, '') AS 'Invitation Date'" + " FROM Linkedin_Invitation" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("LINKEDIN_MESSAGES")) { query = "SELECT from_display_name AS 'Remote Party', from_title AS 'Remote Party Title'," + " message_date AS 'Message Date', subject AS Subject, message_body AS Message" + " FROM Linkedin_Message" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("DEFAULT_BROWSER_HISTORY")) { query = "SELECT title AS Title, url AS URL, " + "last_visit_date AS 'Last Visit Date', visits AS 'No of Visitis'" + " FROM Browser_History" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'DEFAULTB'"; } else if (feature.equals("DEFAULT_BOOKMARKS")) { query = "SELECT title AS Title, url AS URL, " + "created_date AS 'Creaded Date', modified_date AS 'Modified Date', deleted AS Deleted," + "account_name AS 'Created By', account_type AS 'Account Type'" + " FROM Androspy_Bookmark" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'DEFAULTB'"; } else if (feature.equals("DEFAULT_WEB_FORM_DATA")) { query = "SELECT url AS 'URL', name AS 'Parameter Name', value AS 'Parameter Value'" + " FROM WebForm f, WebFormData d" + " WHERE f.case_id = d.case_id AND f.device_id = d.device_id" + " AND d.urlid = f.id" + " AND d.case_id = " + AndrospyMain.gb_CaseId + " AND d.device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("DEFAULT_COOKIES")) { query = "SELECT host AS 'Host', " + "cookie_name AS 'Cookie Name', cookie_value AS 'Cookie Value', path AS Path, " + "secure AS Secure, httponly AS 'Http Only', created_date AS 'Created Date', " + "expire_date AS 'Expire Date', last_access_date AS 'Last Access Date'" + " FROM Browser_Cookies" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'DEFAULTB'"; } else if (feature.equals("DEFAULT_WEB_SEARCH")) { query = "SELECT search_text AS 'Search Text', " + "search_date AS 'Search Date'" + " FROM WebSearch" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'DEFAULTB'"; } else if (feature.equals("CHROME_BROWSER_HISTORY")) { query = "SELECT title AS Title, url AS URL, " + "last_visit_date AS 'Last Visit Date', visits AS 'No of Visitis'" + " FROM Browser_History" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'CHROME'"; } else if (feature.equals("CHROME_COOKIES")) { query = "SELECT host AS 'Host', " + "cookie_name AS 'Cookie Name', cookie_value AS 'Cookie Value', path AS Path, " + "secure AS Secure, httponly AS 'Http Only', created_date AS 'Created Date', " + "expire_date AS 'Expire Date', last_access_date AS 'Last Access Date'" + " FROM Browser_Cookies" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'CHROME'"; } else if (feature.equals("CHROME_WEB_SEARCH")) { query = "SELECT search_text AS 'Search Text', " + "search_date AS 'Search Date'" + " FROM WebSearch" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'CHROME'"; } else if (feature.equals("CHROME_CREDIT_CARD")) { query = "SELECT name AS Name, expire_month AS 'Expire Month', expire_year AS 'Exire Year', " + "modified_date AS 'Modified Date'" + " FROM Browser_Credit_Card" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'CHROME'"; } else if (feature.equals("Firefox_BROWSER_HISTORY")) { query = "SELECT title AS Title, url AS URL, " + "last_visit_date AS 'Last Visit Date', visits AS 'No of Visitis'" + " FROM Browser_History" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'Firefox'"; } else if (feature.equals("Firefox_BOOKMARKS")) { query = "SELECT title AS Title, url AS URL, " + "created_date AS 'Creaded Date', modified_date AS 'Modified Date', deleted AS Deleted," + "account_name AS 'Created By', account_type AS 'Account Type'" + " FROM Androspy_Bookmark" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'Firefox'"; } else if (feature.equals("Firefox_WEB_SEARCH")) { query = "SELECT search_text AS 'Search Text', " + "search_date AS 'Search Date'" + " FROM WebSearch" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'Firefox'"; } else if (feature.equals("Firefox_COOKIES")) { query = "SELECT host AS 'Host', " + "cookie_name AS 'Cookie Name', cookie_value AS 'Cookie Value', path AS Path, " + "secure AS Secure, httponly AS 'Http Only', created_date AS 'Created Date', " + "expire_date AS 'Expire Date', last_access_date AS 'Last Access Date'" + " FROM Browser_Cookies" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND browser = 'Firefox'"; } else if (feature == "ALL_CALL_LOG") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', duration AS 'Call Duration', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 100; } else if (feature == "INCOMING_CALLS") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', duration AS 'Call Duration', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 100 + " AND type = " + 1; } else if (feature == "MISSED_CALLS") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', duration AS 'Call Duration', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 100 + " AND type = " + 3; } else if (feature == "CANCELLED_CALLS") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', duration AS 'Call Duration', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 500; } else if (feature == "OUTGOING_CALLS") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', duration AS 'Call Duration', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 100 + " AND type = " + 2; } else if (feature == "ALL_SMS_LOG") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', " + "messageid AS 'Message_Id', m_subject AS 'Message Subject', m_content AS 'Message Body', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 300; } else if (feature == "SMS_INBOX") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', " + "messageid AS 'Message_Id', m_subject AS 'Message Subject', m_content AS 'Message Body', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 300 + " AND type = " + 1; } else if (feature == "SMS_OUTBOX") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', " + "messageid AS 'Message_Id', m_subject AS 'Message Subject', m_content AS 'Message Body', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 300 + " AND type != " + 1; } else if (feature == "ALL_MMS_LOG") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', " + "messageid AS 'Message_Id', m_subject AS 'Message Subject', m_content AS 'Message Body', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 200; } else if (feature == "MMS_INBOX") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', " + "messageid AS 'Message_Id', m_subject AS 'Message Subject', m_content AS 'Message Body', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 200 + " AND type = " + 1; } else if (feature == "MMS_OUTBOX") { query = "SELECT contact_no AS 'Contact No', name AS 'Name'," + " date AS 'Contacted Date', " + "messageid AS 'Message_Id', m_subject AS 'Message Subject', m_content AS 'Message Body', " + "countryiso AS 'Country Code', geolocationcode AS 'Geo Location'" + " FROM Event_Log" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId + " AND logtype = " + 200 + " AND type != " + 1; } else if (feature == "Wi-Fi Access Points") { query = "SELECT ssid AS 'SSID', password AS 'Password', key_mgmt AS 'Key Management'" + " FROM Wifi_Info" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature.equals("Wi-Fi Access Points")) { query = "SELECT ssid AS 'SSID', password AS 'Password', key_mgmt AS 'Key Management'" + " FROM Wifi_Info" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "BT_USED") { query = "SELECT device_address AS 'Target Device BT Address', mimetype AS 'MIME Type', " + " in_file_name AS 'File Name', totalbytes AS 'File Size', location AS Location, direction AS Direction, visibility AS Visibility, confirm AS Confirm," + " status AS 'Transfer Status', date AS 'Transfer Date', scanned As Scanned" + " FROM Bluetooth_Tranfer" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "BT_SEEN") { query = "SELECT bmac AS 'Bluetooth Address'," + " device_name AS 'Device Name', seen_date AS 'Last Seen Date', 'used_date' AS 'Last_Paired_Date'" + " FROM Bluetooth_Device" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Skype Account") { System.out.println("Skype Account"); query = "SELECT skypename, fullname, birthday, country, city reg_date, gender" + " FROM Skype_Account" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Skype Contacts") { System.out.println("Skype Contacts"); query = "SELECT skypename, fullname, birthday, displayname, country, city, gender, phone" + " FROM Skype_Contacts" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Skype Calls") { System.out.println("Skype Calls"); query = "SELECT identity, display_name, call_duration, start_time_stamp" + " FROM Skype_Call" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } else if (feature == "Skype Messages") { System.out.println("Skype Messages"); query = "SELECT author, from_display_name, dialog_partner, message, time_stamp" + " FROM Skype_Message" + " WHERE case_id = " + AndrospyMain.gb_CaseId + " AND device_id = " + AndrospyMain.gb_DeviceId; } if (query != ("")) { if (!bflagall) { query += " AND favourite = " + 1; } System.out.println("query: " + query); ResultSet rs = stmt.executeQuery(query); ResultSetMetaData rsmeta = rs.getMetaData(); int colcount = rsmeta.getColumnCount(); PdfPTable pdftable = new PdfPTable(colcount); pdftable.setWidthPercentage(100 / colcount); pdftable.setTotalWidth(527); pdftable.setLockedWidth(true); for (int i = 1; i <= colcount; i++) { PdfPCell c1 = new PdfPCell(new Phrase(rsmeta.getColumnLabel(i))); c1.setHorizontalAlignment(Element.ALIGN_CENTER); pdftable.addCell(c1); } pdftable.setHeaderRows(1); while (rs.next()) { for (int i = 1; i <= colcount; i++) { System.out.println("add table cell report " + rs.getString(i)); pdftable.addCell(rs.getString(i)); } } subpara.add(pdftable); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }
From source file:Login.ventas.fproyectos.java
/** * Creates new form cliente/*ww w .jav a2s . co m*/ * @param user */ public fproyectos(Login user) { Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); @SuppressWarnings("MismatchedReadAndWriteOfArray") String[] fecha = { "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre" }; initComponents(); Calendar rightNow = Calendar.getInstance(); int ccyy = rightNow.get(Calendar.YEAR); int month = rightNow.get(Calendar.MONTH); setSize(d.width, d.height - 95); this.usuario = user; add(f); f.setLocation(jPanel1.getX(), jPanel1.getY()); add(f3); f3.setLocation(jPanel1.getX(), jPanel1.getY()); add(f4); f4.setLocation(jPanel1.getX(), jPanel1.getY()); add(f5); f5.setLocation(jPanel1.getX(), jPanel1.getY()); add(f2); f2.setLocation(jPanel1.getX(), jPanel1.getY()); f2.getjButton1().addMouseListener(new java.awt.event.MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { try { ServiceHb helper = new ServiceHb(); helper.iniciarTransaccion(); Fcomisiones fc = helper.getFcomisiones(idcliente, idinstalacion); if (helper.getFcomisiones(idcliente, idinstalacion) == null) { fc = new Fcomisiones(); Calendar d = Calendar.getInstance(); fc.setFecha(new java.sql.Date(d.getTime().getTime())); fc.setClientes( (Clientes) helper.obtenerObjeto(Clientes.class, Integer.parseInt(idcliente))); fc.setInstalacion((Instalacion) helper.obtenerObjeto(Instalacion.class, Integer.parseInt(idinstalacion))); fc.setRentabilidad(f2.getjLabel20().getText()); fc.setValor1(f2.getjLabel11().getText().substring(2, f2.getjLabel11().getText().length())); fc.setValor2(f2.getjLabel2().getText().substring(3, f2.getjLabel2().getText().length())); fc.setDiferido(f2.getjLabel4().getText()); fc.setDias(numeroinstala); helper.crearObjeto(fc); helper.confirmarTransaccion(); helper.cerrarSesion(); JOptionPane.showMessageDialog(null, "Comision prepara con fecha " + Funcion.DateFormatSql(d.getTime())); } else { Calendar d = Calendar.getInstance(); fc.setFecha(new java.sql.Date(d.getTime().getTime())); fc.setRentabilidad(f2.getjLabel20().getText()); fc.setValor1(f2.getjLabel11().getText().substring(2, f2.getjLabel11().getText().length())); fc.setValor2(f2.getjLabel2().getText().substring(3, f2.getjLabel2().getText().length())); fc.setDiferido(f2.getjLabel4().getText()); fc.setDias(numeroinstala); helper.actualizarObjeto(fc); helper.confirmarTransaccion(); helper.cerrarSesion(); JOptionPane.showMessageDialog(null, "Actualizado / Comision prepara con fecha " + Funcion.DateFormatSql(d.getTime())); } } catch (Exception io) { System.out.println(io); } } }); f2.getjButton2().addMouseListener(new java.awt.event.MouseAdapter() { @Override @SuppressWarnings("UseSpecificCatch") public void mouseClicked(MouseEvent e) { float ancho = 0; try { Document documento = new Document(PageSize.A4, 0, 0, 0, 0); ancho = documento.getPageSize().getWidth() - 100; FileOutputStream ficheroPdf; PdfWriter writer = null; PdfWriter writer2 = null; String direccion = ""; Calendar now2 = Calendar.getInstance(); try { JFileChooser chooser = new JFileChooser(); chooser.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY); //Mostrar la ventana para abrir archivo y recoger la respuesta //En el parmetro del showOpenDialog se indica la ventana // al que estar asociado. Con el valor this se asocia a la // ventana que la abre. int respuesta = chooser.showOpenDialog(null); String cadena = ""; if (respuesta == JFileChooser.APPROVE_OPTION) { direccion = chooser.getSelectedFile().getAbsolutePath(); } Calendar d = Calendar.getInstance(); ficheroPdf = new FileOutputStream(direccion + "/" + idcliente + idinstalacion + ".pdf"); writer = PdfWriter.getInstance(documento, ficheroPdf); } catch (IOException ex) { System.out.println(ex.toString()); } ServiceHb helper = null; try { List<Productos> lt = null; helper = new ServiceHb(); helper.iniciarTransaccion(); PdfPTable tabla; PdfPCell casilla; PdfPTable salto = null; PdfPCell celda; Font fontpersonalizado = FontFactory.getFont("ARIAL", 7, Font.BOLD); Font fontpersonalizado2 = FontFactory.getFont("ARIAL", 7, Font.NORMAL); documento.open(); PdfContentByte canvas = writer.getDirectContent(); fondos(documento, canvas); //Materiales double total = 0; double total2 = 0; double total3 = 0; double total4 = 0; double total5 = 0; tabla = new PdfPTable(6); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); celda = new PdfPCell(new Paragraph("ADQUISICION DE MATERIALES")); celda.setColspan(6); celda.setHorizontalAlignment(Element.ALIGN_CENTER); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); float pagina = documento.getPageSize().getHeight() - 140; final float max = pagina; pagina = pagina - tabla.getRow(0).calculateHeights(); if (ltart != null) { Object nuevo2[] = { "FECHA", "DETALLE", "CANT.", "PRECIO", "SUBTOTAL", "TOTAL DIARIO" }; for (Object obj : nuevo2) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(1).calculateHeights(); int tam = 0; double diario = 0; int turno = 0; for (int i = 0; i < ltart.size(); i++) { turno = 0; fact = helper.getFacturafecha(ltart.get(i).getIdfactura()); String fecha = ""; if (fact != null) { fecha = Funcion.DateFormatSql(fact.getFecha()); } if ((i + 1) == ltart.size()) { diario = diario + Double.parseDouble(ltart.get(i).getTotal()); turno = 1; } else { fact2 = helper.getFacturafecha(ltart.get(i + 1).getIdfactura()); String fecha2 = ""; if (fact2 != null) { fecha2 = Funcion.DateFormatSql(fact2.getFecha()); if (fecha.equalsIgnoreCase(fecha2)) { diario = diario + Double.parseDouble(ltart.get(i).getTotal()); } else { diario = diario + Double.parseDouble(ltart.get(i).getTotal()); turno = 1; } } } String uni = "$ " + df.format(Double.parseDouble(ltart.get(i).getUnitario())) .replace(",", "."); String tot = "$ " + df.format(Double.parseDouble(ltart.get(i).getTotal())).replace(",", "."); total = total + Double.parseDouble(ltart.get(i).getTotal()); if (turno == 0) { Object nuevo[] = { fecha, ltart.get(i).getDescripcion(), ltart.get(i).getCantidad(), uni, tot, "" }; for (Object obj : nuevo) { celda = new PdfPCell( new Paragraph((String) obj, new Font(fontpersonalizado2))); if (((String) obj).equalsIgnoreCase("")) { celda.setBorder(Rectangle.RIGHT); } celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } } else { Object nuevo[] = { fecha, ltart.get(i).getDescripcion(), ltart.get(i).getCantidad(), uni, tot, "$ " + df.format(diario).replace(",", ".") }; int va = 0; for (Object obj : nuevo) { va++; celda = new PdfPCell( new Paragraph((String) obj, new Font(fontpersonalizado2))); if (va == 5) { celda.setBorder(Rectangle.BOTTOM); } celda.setColspan(1); celda.setBorderColor(new Color(195, 195, 195)); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } diario = 0; } pagina = pagina - tabla.getRow(tam).getMaxHeights(); tam++; if (pagina < 11) { salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(6); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); pagina = max; tam = 0; } } } salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); celda = new PdfPCell(new Paragraph("Total", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell( new Paragraph("Adquisicin de Materiales", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(4); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("$ " + df.format(total).replace(",", "."), new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); documento.add(tabla); documento.newPage(); fondos(documento, canvas); /*Parte 2*/ tabla = new PdfPTable(4); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1, 1 }); celda = new PdfPCell(new Paragraph("MANO DE OBRA TECNICOS")); celda.setColspan(4); celda.setHorizontalAlignment(Element.ALIGN_CENTER); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); pagina = documento.getPageSize().getHeight() - 140; pagina = pagina - tabla.getRow(0).calculateHeights(); if (list != null) { Object nuevo2[] = { "FECHA", "DETALLE", "CANT.", "SUBTOTAL" }; for (Object obj : nuevo2) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(1).calculateHeights(); int tam = 0; double diario = 0; int turno = 0; for (Ctepagar list1 : list) { if (list1.getDetalle().contains("ci:")) { String fecha = list1.getFecha(); String desc = list1.getDetalle(); String[] cadena = desc.split(" "); String result = ""; int contador = 0; for (String n : cadena) { if (n.contains("ci:")) { result = result + ", "; contador++; } else { result = result + n + " "; } } result = result.substring(0, result.length() - 2); String uni = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); String tot = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); total2 = total2 + Double.parseDouble(list1.getValor()); Object nuevo[] = { fecha, result, "" + contador, tot }; for (Object obj : nuevo) { celda = new PdfPCell( new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(tam).getMaxHeights(); tam++; if (pagina < 90) { salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado2))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(4); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1, 1 }); pagina = max; tam = 0; } } } } salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); celda = new PdfPCell(new Paragraph("Total", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("Mano de Obra Tcnicos", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(2); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("$ " + df.format(total2).replace(",", "."), new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); celda = new PdfPCell(new Paragraph("TRANSPORTE")); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_CENTER); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); pagina = documento.getPageSize().getHeight() - 140; pagina = pagina - tabla.getRow(0).calculateHeights(); if (list != null) { Object nuevo2[] = { "FECHA", "DETALLE", "SUBTOTAL" }; for (Object obj : nuevo2) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(1).calculateHeights(); int tam = 0; for (Ctepagar list1 : list) { if (list1.getDetalle().contains("Transporte")) { String fecha = list1.getFecha(); String desc = list1.getDetalle(); String result = ""; String uni = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); String tot = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); total3 = total3 + Double.parseDouble(list1.getValor()); Object nuevo[] = { fecha, desc, tot }; for (Object obj : nuevo) { celda = new PdfPCell( new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(tam).getMaxHeights(); tam++; if (pagina < 50) { salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado2))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); pagina = max; tam = 0; } } } } salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); celda = new PdfPCell(new Paragraph("Total", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("Transporte", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("$ " + df.format(total3).replace(",", "."), new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); celda = new PdfPCell(new Paragraph("COMBUSTIBLE")); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_CENTER); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); pagina = documento.getPageSize().getHeight() - 140; pagina = pagina - tabla.getRow(0).calculateHeights(); if (list != null) { Object nuevo2[] = { "FECHA", "DETALLE", "SUBTOTAL" }; for (Object obj : nuevo2) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(1).calculateHeights(); int tam = 0; for (Ctepagar list1 : list) { if (list1.getDetalle().contains("Combustible")) { String fecha = list1.getFecha(); String desc = list1.getDetalle(); String result = ""; String uni = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); String tot = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); total4 = total4 + Double.parseDouble(list1.getValor()); Object nuevo[] = { fecha, desc, tot }; for (Object obj : nuevo) { celda = new PdfPCell( new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(tam).getMaxHeights(); tam++; if (pagina < 50) { salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); pagina = max; tam = 0; } } } } salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); celda = new PdfPCell(new Paragraph("Total", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("Combustible", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("$ " + df.format(total4).replace(",", "."), new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); documento.add(tabla); documento.newPage(); fondos(documento, canvas); //Extras tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); celda = new PdfPCell(new Paragraph("EXTRAS")); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_CENTER); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); pagina = documento.getPageSize().getHeight() - 140; pagina = pagina - tabla.getRow(0).calculateHeights(); if (list != null) { Object nuevo2[] = { "FECHA", "DETALLE", "SUBTOTAL" }; for (Object obj : nuevo2) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(1).calculateHeights(); int tam = 0; for (Ctepagar list1 : list) { if (!list1.getDetalle().contains("Combustible") && !list1.getDetalle().contains("ci:") && !list1.getDetalle().contains("Transporte")) { String fecha = list1.getFecha(); String desc = list1.getDetalle(); String result = ""; String uni = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); String tot = "$ " + df.format(Double.parseDouble(list1.getValor())).replace(",", "."); total5 = total5 + Double.parseDouble(list1.getValor()); Object nuevo[] = { fecha, desc, tot }; for (Object obj : nuevo) { celda = new PdfPCell( new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } pagina = pagina - tabla.getRow(tam).getMaxHeights(); tam++; if (pagina < 50) { salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); documento.add(tabla); documento.newPage(); fondos(documento, canvas); tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); pagina = max; tam = 0; } } } } salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); celda = new PdfPCell(new Paragraph("Total", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("Extra", new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("$ " + df.format(total5).replace(",", "."), new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); documento.add(tabla); documento.newPage(); fondos(documento, canvas); //Final Vendedor tabla = new PdfPTable(3); tabla.setHorizontalAlignment(PdfPTable.ALIGN_CENTER); tabla.setTotalWidth(ancho); tabla.setLockedWidth(true); tabla.setWidths(new int[] { 1, 3, 1 }); celda = new PdfPCell(new Paragraph(nombrecliente)); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_CENTER); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); celda = new PdfPCell(new Paragraph("Venta")); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_LEFT); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); pagina = documento.getPageSize().getHeight() - 140; pagina = pagina - tabla.getRow(0).calculateHeights(); Object nuevo2[] = { "FECHA", "DETALLE", "TOTAL" }; for (Object obj : nuevo2) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo3[] = { "", nombreinstalacion, totalinstalacion }; for (Object obj : nuevo3) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorderColor(new Color(195, 195, 195)); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } celda = new PdfPCell(new Paragraph("INVERSION", new Font(fontpersonalizado))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); Object nuevo4[] = { "Uso de Materiales", "", "$ " + df.format(total).replace(",", ".") }; for (Object obj : nuevo4) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo5[] = { "Mano de obra tcnicos", "", "$ " + df.format(total2).replace(",", ".") }; for (Object obj : nuevo5) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo6[] = { "Transporte", "", "$ " + df.format(total3).replace(",", ".") }; for (Object obj : nuevo6) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo7[] = { "Combustible", "", "$ " + df.format(total4).replace(",", ".") }; for (Object obj : nuevo7) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo71[] = { "Extras", "", "$ " + df.format(total5).replace(",", ".") }; for (Object obj : nuevo71) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo8[] = { "Total Inversin", "", "$ " + df.format(total + total2 + total3 + total4).replace(",", ".") }; for (Object obj : nuevo8) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado2))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } celda = new PdfPCell(new Paragraph("")); celda.setColspan(3); celda.setHorizontalAlignment(Element.ALIGN_LEFT); celda.setBorder(PdfPCell.NO_BORDER); tabla.addCell(celda); Object nuevo9[] = { "Utilidad del proyecto", "", "$ " + df.format(proyectoval - total - total2 - total3 - total4).replace(",", ".") }; for (Object obj : nuevo9) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setColspan(1); celda.setBorder(PdfPCell.NO_BORDER); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } Object nuevo10[] = { "Rentabilidad ", "", df.format(porcent).replace(",", ".") + " %" }; for (Object obj : nuevo10) { celda = new PdfPCell(new Paragraph((String) obj, new Font(fontpersonalizado))); celda.setBorder(PdfPCell.NO_BORDER); celda.setColspan(1); celda.setHorizontalAlignment(Element.ALIGN_CENTER); tabla.addCell(celda); } salto = new PdfPTable(1); casilla = new PdfPCell(new Phrase("", new Font(fontpersonalizado))); casilla.setMinimumHeight(90); casilla.setBorder(PdfPCell.NO_BORDER); salto.addCell(casilla); documento.add(salto); documento.add(tabla); /*Fin Parte 3*/ documento.close(); helper.cerrarSesion(); } catch (Exception ex) { documento.close(); } JOptionPane.showMessageDialog(null, "PDF Generado"); } catch (Exception io) { System.out.println(io); } } }); f.getjTable1().addMouseListener(new java.awt.event.MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { int row = f.getjTable1().getSelectedRow(); int col = f.getjTable1().getSelectedColumn(); if (col == 4) { f2.setVisible(true); f.setVisible(false); idcliente = f.getjTable1().getValueAt(row, 5).toString(); idinstalacion = f.getjTable1().getValueAt(row, 6).toString(); f2.getjLabel15().setText(f.getjTable1().getValueAt(row, 0).toString()); f2.getjLabel8().setText(f.getjTable1().getValueAt(row, 2).toString()); nombrecliente = f.getjTable1().getValueAt(row, 0).toString(); nombreinstalacion = f.getjTable1().getValueAt(row, 2).toString(); updateTablas up = new updateTablas(1); up.start(); } } }); f5.getjComboBox1().addActionListener(new java.awt.event.ActionListener() { @Override public void actionPerformed(ActionEvent e) { DefaultTableModel temp2 = (DefaultTableModel) f5.getjTable2().getModel(); for (int i = temp2.getRowCount() - 1; i >= 0; i--) { temp2.removeRow(i); } f5.setComi(null); f5.setNinstalacion(""); f5.setNcliente(""); f5.setList(null); f5.setId(""); updateTablas up = new updateTablas(4); up.start(); } }); f3.getjTable1().addMouseListener(new java.awt.event.MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { int row = f3.getjTable1().getSelectedRow(); int col = f3.getjTable1().getSelectedColumn(); if (col == 6) { visible(f4); fcomisiones = f3.getjTable1().getValueAt(row, 6).toString(); try { ServiceHb helper = new ServiceHb(); helper.iniciarTransaccion(); Fcomisiones ft = (Fcomisiones) helper.obtenerObjeto(Fcomisiones.class, Integer.parseInt(fcomisiones)); numeroinstala = ft.getDias(); f4.setIdcliente("" + ft.getClientes().getId()); f4.setIdinstalacion("" + ft.getInstalacion().getId()); f4.getDiasint().setText(numeroinstala); helper.cerrarSesion(); } catch (Exception io) { } f4.getjLabel1().setText(fcomisiones); f4.getC1().setText(f3.getjTable1().getValueAt(row, 0).toString()); f4.getC2().setText(f3.getjTable1().getValueAt(row, 1).toString()); double campo1 = Double .parseDouble(f3.getjTable1().getValueAt(row, 3).toString().replace("$ ", "")); double campo2 = Double .parseDouble(f3.getjTable1().getValueAt(row, 4).toString().replace("-$ ", "")); f4.getC3().setText(f3.getjTable1().getValueAt(row, 3).toString()); f4.getC4().setText(f3.getjTable1().getValueAt(row, 4).toString()); f4.getC5().setText(f3.getjTable1().getValueAt(row, 5).toString()); f4.getC6().setText("$ " + df.format((campo1 - campo2)).replace(",", ".")); updateTablas up = new updateTablas(3); up.start(); } } }); setVisible(false); }
From source file:main.ItextPDF.java
public void createPdf(String filename, Person person) { // step 1//from ww w. j a v a2s .c o m Document document = new Document(); // step 2 try { PdfWriter.getInstance(document, new FileOutputStream(filename)); // step 3 document.open(); BaseFont bf_ru = BaseFont.createFont(FONT_RU, BaseFont.IDENTITY_H, BaseFont.EMBEDDED); Font font_ru = new Font(bf_ru, 10); BaseFont bf_ch = BaseFont.createFont(FONT_CH, BaseFont.IDENTITY_H, BaseFont.EMBEDDED); Font font_ch = new Font(bf_ch, 10); ResourceBundle rb_ch = ResourceBundle.getBundle("bundles/lang", Locale.CHINA); ResourceBundle rb_ru = ResourceBundle.getBundle("bundles/lang", Locale.GERMANY); // Paragraph preface = new Paragraph(rb_ch.getString("pdfFileheder1"), font_ch); preface.setAlignment(Element.ALIGN_CENTER); document.add(preface); preface = new Paragraph(rb_ru.getString("pdfFileheder1"), font_ru); preface.setAlignment(Element.ALIGN_CENTER); document.add(preface); document.add(new Phrase(rb_ch.getString("pdfFileheder2"), font_ch)); document.add(new Phrase(rb_ru.getString("pdfFileheder2"), font_ru)); Phrase pr = new Phrase("\n "); pr.add(new Phrase(rb_ch.getString("part1"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part1"), font_ru)); document.add(pr); PdfPTable basetable = new PdfPTable(2); basetable.setWidthPercentage(100); PdfPTable table1 = new PdfPTable(4); pr = new Phrase(rb_ch.getString("nameDesc"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("nameDesc"), font_ru)); PdfPCell cell = new PdfPCell(pr); cell.setHorizontalAlignment(Element.ALIGN_LEFT); cell.setRowspan(3); table1.addCell(cell); //line 1 //PdfPTable table2 = new PdfPTable(2); pr = new Phrase(rb_ch.getString("lastname"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("lastname"), font_ru)); PdfPCell cell1 = new PdfPCell(pr); PdfPCell cell2 = new PdfPCell(new Paragraph(person.getField1())); cell2.setColspan(2); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("fathername"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("fathername"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField2())); table1.addCell(cell1); cell2.setColspan(2); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("firstname"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("firstname"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField3())); table1.addCell(cell1); cell2.setColspan(2); table1.addCell(cell2); //basetable.addCell(table1); //basetable.addCell(table2); ///line 2 1.2 1.3 //table1 = new PdfPTable(4); pr = new Phrase(rb_ch.getString("chinaseName"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("chinaseName"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField4())); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("othername"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("othername"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField5())); table1.addCell(cell1); table1.addCell(cell2); //1.4 1.5 pr = new Phrase(rb_ch.getString("sex"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("sex"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField6() + " " + person.getField7())); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("databirth"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("databirth"), font_ru)); cell1 = new PdfPCell(pr); pr = new Phrase(); pr.add(new Phrase(person.getField8())); pr.add(new Phrase("/")); pr.add(new Phrase(person.getField9())); pr.add(new Phrase("/")); pr.add(new Phrase(person.getField10())); cell2 = new PdfPCell(pr); table1.addCell(cell1); table1.addCell(cell2); //1.6 1.7 pr = new Phrase(rb_ch.getString("citizen"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("citizen"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField11())); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("old_citizen_of"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("old_citizen_of"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField12())); table1.addCell(cell1); table1.addCell(cell2); //1.8 pr = new Phrase(rb_ch.getString("birthplace"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("birthplace"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField13())); cell1.setColspan(2); table1.addCell(cell1); cell2.setColspan(2); table1.addCell(cell2); //1.9 pr = new Phrase(rb_ch.getString("passportData"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportData"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField14())); cell1.setColspan(2); table1.addCell(cell1); cell2.setColspan(2); table1.addCell(cell2); //1.10 pr = new Phrase(rb_ch.getString("passportType"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportType"), font_ru)); cell1 = new PdfPCell(pr); pr = new Phrase(person.getField15() + " " + person.getField16() + " " + person.getField17() + " " + person.getField18() + " " + person.getField19(), font_ru); cell2 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); cell2.setColspan(2); table1.addCell(cell2); //1.11 1.12 pr = new Phrase(rb_ch.getString("passportNumber"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportNumber"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField20())); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("passportGivenDate"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportGivenDate"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell( new Paragraph(person.getField21() + "/" + person.getField22() + "/" + person.getField23())); table1.addCell(cell1); table1.addCell(cell2); //1.13 1.14 pr = new Phrase(rb_ch.getString("passportGivenPlace"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportGivenPlace"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph(person.getField24())); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("passportValidDate"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportValidDate"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell( new Paragraph(person.getField25() + "/" + person.getField26() + "/" + person.getField27())); table1.addCell(cell1); table1.addCell(cell2); //1.15 pr = new Phrase(rb_ch.getString("passportProfession"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("passportProfession"), font_ru)); cell1 = new PdfPCell(pr); /*cell2 = new PdfPCell(new Paragraph( person.getField28() + " " + person.getField29() + " " + person.getField30() ));*/ table1.addCell(cell1); //table1.addCell(cell2); //cell2 = new PdfPCell(new Paragraph(rs.getString("FIELD" + 16))); PdfPTable innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("profession1"), font_ch); if (!person.getField28().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession1"), font_ru)); PdfPCell innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.BOTTOM); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession10"), font_ch); if (!person.getField37().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField38(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession10"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.LEFT); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession2"), font_ch); if (!person.getField29().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession2"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.BOTTOM); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession11"), font_ch); if (!person.getField39().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField40(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession11"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.LEFT); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession3"), font_ch); if (!person.getField30().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession3"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.RIGHT); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession12"), font_ch); if (!person.getField41().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField42(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession12"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.NO_BORDER); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession4"), font_ch); if (!person.getField31().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession4"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.RIGHT); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession13"), font_ch); if (!person.getField43().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession13"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.NO_BORDER); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession5"), font_ch); if (!person.getField32().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession5"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.RIGHT); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession14"), font_ch); if (!person.getField44().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession14"), font_ru)); innercell = new PdfPCell(pr); //innercell.setBorder(Rectangle.NO_BORDER); innertable.addCell(innercell); pr = new Phrase(rb_ch.getString("profession6"), font_ch); if (!person.getField33().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession6"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("profession15"), font_ch); if (!person.getField45().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession15"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("profession7"), font_ch); if (!person.getField34().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession7"), font_ru)); innertable.addCell(pr); pr = new Phrase(""); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("profession8"), font_ch); if (!person.getField35().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession8"), font_ru)); innertable.addCell(pr); pr = new Phrase(""); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("profession9"), font_ch); if (!person.getField36().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession9"), font_ru)); innertable.addCell(pr); pr = new Phrase(""); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("profession16"), font_ch); if (!person.getField173().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(person.getField174(), font_ru)); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("profession16"), font_ru)); innertable.addCell(pr); pr = new Phrase(""); innertable.addCell(pr); cell2.setColspan(3); cell2.addElement(innertable); table1.addCell(cell2); //1.16 pr = new Phrase(rb_ch.getString("education"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("education"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph("")); cell1.setColspan(1); table1.addCell(cell1); innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("education1"), font_ch); if (!person.getField46().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("education1"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("education2"), font_ch); if (!person.getField47().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("education2"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("education3"), font_ch); if (!person.getField48().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField49(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("education3"), font_ru)); innertable.addCell(pr); innertable.addCell(new Phrase()); cell2.setColspan(3); cell2.addElement(innertable); table1.addCell(cell2); //1.17 pr = new Phrase(rb_ch.getString("workPlace"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("workPlace"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph("")); cell1.setColspan(1); table1.addCell(cell1); innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("workPlace1"), font_ch); if (!person.getField50().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField50(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("workPlace1"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("workPlace2"), font_ch); if (!person.getField51().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField51(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("workPlace2"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("workPlace3"), font_ch); if (!person.getField52().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField52(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("workPlace3"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("workPlace4"), font_ch); if (!person.getField53().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField53(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("workPlace4"), font_ru)); innertable.addCell(pr); cell2.setColspan(3); cell2.addElement(innertable); table1.addCell(cell2); // PdfPCell tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); // document.add(basetable); //////////////////////////////////////////////////////////page2 basetable = new PdfPTable(2); basetable.setWidthPercentage(100); table1 = new PdfPTable(4); //1.18 1.19 pr = new Phrase(rb_ch.getString("homeAddr"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("homeAddr"), font_ru)); cell1 = new PdfPCell(pr); pr = new Paragraph(""); if (!person.getField54().equals("")) { pr.add(new Phrase(person.getField54(), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("zipCode"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("zipCode"), font_ru)); cell1 = new PdfPCell(pr); pr = new Paragraph(""); if (!person.getField55().equals("")) { pr.add(new Phrase(person.getField55(), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell1); table1.addCell(cell2); //1.20 1.21 pr = new Phrase(rb_ch.getString("phoneNum"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("phoneNum"), font_ru)); cell1 = new PdfPCell(pr); pr = new Paragraph(""); if (!person.getField56().equals("")) { pr.add(new Phrase(person.getField56(), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("email"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("email"), font_ru)); cell1 = new PdfPCell(pr); pr = new Paragraph(""); if (!person.getField57().equals("")) { pr.add(new Phrase(person.getField57(), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell1); table1.addCell(cell2); //1.22 pr = new Phrase(rb_ch.getString("familyStatus"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("familyStatus"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(" "); if (!person.getField66().equals("")) { pr.add(new Phrase(rb_ru.getString("familyStatus1"), font_ru)); pr.add(new Phrase(" ")); } if (!person.getField67().equals("")) { pr.add(new Phrase(rb_ru.getString("familyStatus2"), font_ru)); pr.add(new Phrase(" ")); } if (!person.getField68().equals("")) { pr.add(new Phrase(rb_ru.getString("familyStatus3"), font_ru)); pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField69(), font_ru)); } cell2 = new PdfPCell(pr); cell2.setColspan(3); table1.addCell(cell2); /*tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell);*/ //1.23 pr = new Phrase(rb_ch.getString("familyStaff"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("familyStaff"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); innertable = new PdfPTable(4); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("familyStaff1"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("familyStaff1"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("familyStaff2"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("familyStaff2"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("familyStaff3"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("familyStaff3"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("familyStaff4"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("familyStaff4"), font_ru)); innertable.addCell(pr); //add 4 empty row //for(int l =0 ; l < 16; l++){ innertable.addCell(new Phrase(person.getField58(), font_ru)); innertable.addCell(new Phrase(person.getField59(), font_ru)); innertable.addCell(new Phrase(person.getField60(), font_ru)); innertable.addCell(new Phrase(person.getField61(), font_ru)); innertable.addCell(new Phrase(person.getField62(), font_ru)); innertable.addCell(new Phrase(person.getField63(), font_ru)); innertable.addCell(new Phrase(person.getField64(), font_ru)); innertable.addCell(new Phrase(person.getField65(), font_ru)); innertable.addCell(new Phrase(person.getField66(), font_ru)); innertable.addCell(new Phrase(person.getField67(), font_ru)); innertable.addCell(new Phrase(person.getField68(), font_ru)); innertable.addCell(new Phrase(person.getField69(), font_ru)); innertable.addCell(new Phrase(person.getField70(), font_ru)); innertable.addCell(new Phrase(person.getField71(), font_ru)); innertable.addCell(new Phrase(person.getField72(), font_ru)); innertable.addCell(new Phrase(person.getField73(), font_ru)); //} tcell = new PdfPCell(innertable); tcell.setColspan(3); table1.addCell(tcell); //1.24 pr = new Phrase(rb_ch.getString("contactPerson"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("contactPerson"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("contactPerson1"), font_ch); if (!person.getField74().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField74(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("contactPerson1"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("contactPerson2"), font_ch); if (!person.getField75().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField75(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("contactPerson2"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("contactPerson3"), font_ch); if (!person.getField76().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField76(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("contactPerson3"), font_ru)); innertable.addCell(pr); pr = new Phrase(" "); innertable.addCell(pr); tcell = new PdfPCell(innertable); tcell.setColspan(3); table1.addCell(tcell); //1.25 pr = new Phrase(rb_ch.getString("visitedPlace"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("visitedPlace"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField77().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField77(), font_ru)); } cell2 = new PdfPCell(pr); cell2.setColspan(2); table1.addCell(cell2); // tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); ////////////////////////////////////////////// document.add(basetable); ///////////////////////////////////////part2 pr = new Phrase("\n"); pr.add(new Phrase(rb_ch.getString("part2Title"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part2Title"), font_ru)); pr.add(new Phrase("\n")); document.add(pr); //2.1 basetable = new PdfPTable(2); basetable.setWidthPercentage(100); table1 = new PdfPTable(2); table1.setWidths(new int[] { 1, 5 }); pr = new Phrase(rb_ch.getString("travelPurpose"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose"), font_ru)); cell1 = new PdfPCell(pr); cell1.setRowspan(6); table1.addCell(cell1); innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("travelPurpose1"), font_ch); if (!person.getField78().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose1"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose8"), font_ch); if (!person.getField79().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose8"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose2"), font_ch); if (!person.getField80().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose2"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose9"), font_ch); if (!person.getField82().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose9"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose3"), font_ch); if (!person.getField81().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose3"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose10"), font_ch); if (!person.getField84().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose10"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose4"), font_ch); if (!person.getField83().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose4"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose11"), font_ch); if (!person.getField86().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose11"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose5"), font_ch); if (!person.getField85().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose5"), font_ru)); innertable.addCell(pr); innertable.addCell(new Phrase(" ")); pr = new Phrase(rb_ch.getString("travelPurpose6"), font_ch); if (!person.getField87().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose6"), font_ru)); innertable.addCell(pr); innertable.addCell(new Phrase(" ")); pr = new Phrase(rb_ch.getString("travelPurpose7"), font_ch); if (!person.getField88().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose7"), font_ru)); innertable.addCell(pr); innertable.addCell(new Phrase(" ")); innertable.addCell(new Phrase()); cell2.addElement(innertable); table1.addCell(cell2); // innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("travelPurpose12"), font_ch); if (!person.getField89().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose12"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose13"), font_ch); if (!person.getField90().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose13"), font_ru)); innertable.addCell(pr); /*for(int j=12; j < 14; j++){ pr = new Phrase(rb_ch.getString("travelPurpose"+j), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("travelPurpose"+j), font_ru)); innertable.addCell(pr); }*/ cell2 = new PdfPCell(new Phrase("")); cell2.addElement(innertable); table1.addCell(cell2); // innertable = new PdfPTable(2); innertable.setWidthPercentage(100); /*for(int j=14; j < 16; j++){ pr = new Phrase(rb_ch.getString("travelPurpose"+j), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("travelPurpose"+j), font_ru)); innertable.addCell(pr); }*/ pr = new Phrase(rb_ch.getString("travelPurpose14"), font_ch); if (!person.getField91().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose14"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose15"), font_ch); if (!person.getField92().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose15"), font_ru)); innertable.addCell(pr); cell2 = new PdfPCell(new Phrase("")); cell2.addElement(innertable); table1.addCell(cell2); // innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("travelPurpose16"), font_ch); if (!person.getField93().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose16"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose17"), font_ch); if (!person.getField94().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose17"), font_ru)); innertable.addCell(pr); /*for(int j=16; j < 18; j++){ pr = new Phrase(rb_ch.getString("travelPurpose"+j), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("travelPurpose"+j), font_ru)); innertable.addCell(pr); }*/ cell2 = new PdfPCell(new Phrase("")); cell2.addElement(innertable); table1.addCell(cell2); // innertable = new PdfPTable(2); innertable.setWidthPercentage(100); /*for(int j=18; j < 20; j++){ pr = new Phrase(rb_ch.getString("travelPurpose"+j), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("travelPurpose"+j), font_ru)); innertable.addCell(pr); }*/ pr = new Phrase(rb_ch.getString("travelPurpose18"), font_ch); if (!person.getField95().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose18"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("travelPurpose19"), font_ch); if (!person.getField96().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose19"), font_ru)); innertable.addCell(pr); cell2 = new PdfPCell(new Phrase("")); cell2.addElement(innertable); table1.addCell(cell2); // innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("travelPurpose20"), font_ch); if (!person.getField97().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField98(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("travelPurpose20"), font_ru)); PdfPCell innerCell2 = new PdfPCell(pr); innerCell2.setColspan(2); innertable.addCell(innerCell2); cell2 = new PdfPCell(new Phrase("")); cell2.addElement(innertable); table1.addCell(cell2); ///2.2 pr = new Phrase(rb_ch.getString("planingTravel"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("planingTravel"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(rb_ch.getString("planingTravel1"), font_ch); if (!person.getField99().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("planingTravel1"), font_ru)); pr.add(new Phrase("\n \n")); pr.add(new Phrase(rb_ch.getString("planingTravel2"), font_ch)); if (!person.getField100().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("planingTravel2"), font_ru)); pr.add(new Phrase("\n \n")); pr.add(new Phrase(rb_ch.getString("planingTravel3"), font_ch)); if (!person.getField101().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("planingTravel3"), font_ru)); pr.add(new Phrase("\n \n")); pr.add(new Phrase(rb_ch.getString("planingTravel4"), font_ch)); if (!person.getField102().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("planingTravel4"), font_ru)); pr.add(new Phrase("\n \n")); pr.add(new Phrase(rb_ch.getString("planingTravel5"), font_ch)); if (!person.getField103().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField104(), font_ch)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("planingTravel5"), font_ru)); pr.add(new Phrase("\n \n")); cell2 = new PdfPCell(pr); table1.addCell(cell2); tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); ///////////////////////////////////// table1 = new PdfPTable(2); table1.setWidths(new int[] { 4, 1 }); pr = new Phrase(rb_ch.getString("fastService"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("fastService"), font_ru)); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ch.getString("fastService2"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("fastService2"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField144().equals("")) { pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } if (!person.getField105().equals("")) { pr.add(new Phrase(rb_ch.getString("no"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("no"), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell2); tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); document.add(basetable); //////////////////////////////////////////////////////////page3 basetable = new PdfPTable(2); basetable.setWidthPercentage(100); table1 = new PdfPTable(3); table1.setWidths(new int[] { 1, 1, 1 }); //2.4 2.5 pr = new Phrase(rb_ch.getString("dataSuggestion"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("dataSuggestion"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph("")); cell1.setColspan(2); table1.addCell(cell1); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("dataViseted"), font_ch); if (!person.getField106().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField106(), font_ch)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("dataViseted"), font_ru)); cell1 = new PdfPCell(pr); cell2 = new PdfPCell(new Paragraph("")); cell1.setColspan(2); table1.addCell(cell1); table1.addCell(cell2); //2.6 pr = new Phrase(rb_ch.getString("marshrut"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("marshrut"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); innertable = new PdfPTable(2); innertable.setWidthPercentage(100); pr = new Phrase(rb_ch.getString("date"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("date"), font_ru)); innertable.addCell(pr); pr = new Phrase(rb_ch.getString("addressMore"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("addressMore"), font_ru)); innertable.addCell(pr); //add 4 empty row /*for(int l =0 ; l < 10; l++){ innertable.addCell(new Phrase(" ")); }*/ pr = new Phrase(""); if (!person.getField107().equals("")) { pr.add(new Phrase(person.getField107(), font_ru)); } if (!person.getField108().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField108(), font_ru)); } if (!person.getField109().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField109(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField110().equals("")) { pr.add(new Phrase(person.getField110(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField111().equals("")) { pr.add(new Phrase(person.getField111(), font_ru)); } if (!person.getField112().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField112(), font_ru)); } if (!person.getField113().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField113(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField114().equals("")) { pr.add(new Phrase(person.getField114(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField115().equals("")) { pr.add(new Phrase(person.getField115(), font_ru)); } if (!person.getField116().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField116(), font_ru)); } if (!person.getField117().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField117(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField118().equals("")) { pr.add(new Phrase(person.getField118(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField119().equals("")) { pr.add(new Phrase(person.getField119(), font_ru)); } if (!person.getField120().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField120(), font_ru)); } if (!person.getField121().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField121(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField122().equals("")) { pr.add(new Phrase(person.getField122(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField123().equals("")) { pr.add(new Phrase(person.getField123(), font_ru)); } if (!person.getField124().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField124(), font_ru)); } if (!person.getField125().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField125(), font_ru)); } innertable.addCell(pr); pr = new Phrase(""); if (!person.getField126().equals("")) { pr.add(new Phrase(person.getField126(), font_ru)); } innertable.addCell(pr); tcell = new PdfPCell(innertable); tcell.setColspan(2); table1.addCell(tcell); //2.7 pr = new Phrase(rb_ch.getString("howpay"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("howpay"), font_ru)); cell1 = new PdfPCell(pr); pr = new Phrase(""); if (!person.getField127().equals("")) { pr.add(new Phrase(person.getField127(), font_ru)); } cell2 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); table1.addCell(cell2); //2.8 pr = new Phrase(rb_ch.getString("infoAboutVisit"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("infoAboutVisit"), font_ru)); cell1 = new PdfPCell(pr); cell1.setRowspan(4); table1.addCell(cell1); pr = new Phrase(rb_ch.getString("nazvanie"), font_ch); if (!person.getField128().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField128(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("nazvanie"), font_ru)); cell2 = new PdfPCell(pr); cell2.setColspan(2); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("address"), font_ch); if (!person.getField129().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField129(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("address"), font_ru)); cell2 = new PdfPCell(pr); cell2.setColspan(2); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("tel"), font_ch); if (!person.getField130().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField130(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("tel"), font_ru)); cell2 = new PdfPCell(pr); cell2.setColspan(2); table1.addCell(cell2); pr = new Phrase(rb_ch.getString("relation"), font_ch); if (!person.getField131().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField131(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("relation"), font_ru)); cell2 = new PdfPCell(pr); cell2.setColspan(2); table1.addCell(cell2); //2.9 pr = new Phrase(rb_ch.getString("oldVisa"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("oldVisa"), font_ru)); cell1 = new PdfPCell(pr); pr = new Paragraph(""); if (!person.getField132().equals("")) { pr.add(new Phrase(person.getField132(), font_ru)); } cell2 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); table1.addCell(cell2); //2.10 pr = new Phrase(rb_ch.getString("otherViseted"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("otherViseted"), font_ru)); cell1 = new PdfPCell(pr); pr = new Paragraph(""); if (!person.getField133().equals("")) { pr.add(new Phrase(person.getField133(), font_ru)); } cell2 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); table1.addCell(cell2); // tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); ///////////////////////////////////// document.add(basetable); ///////////////////////////////////////part3 pr = new Phrase("\n"); pr.add(new Phrase(rb_ch.getString("part3"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part3"), font_ru)); pr.add(new Phrase("\n")); document.add(pr); //3.1 basetable = new PdfPTable(2); basetable.setWidthPercentage(100); table1 = new PdfPTable(4); table1.setWidths(new int[] { 1, 1, 1, 1 }); pr = new Phrase(rb_ch.getString("wrongVisit"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("wrongVisit"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(3); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField134().equals("")) { pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } if (!person.getField135().equals("")) { pr.add(new Phrase(rb_ch.getString("no"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("no"), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell2); //3.2 pr = new Phrase(rb_ch.getString("rejectedVisit"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("rejectedVisit"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(3); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField136().equals("")) { pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } if (!person.getField137().equals("")) { pr.add(new Phrase(rb_ch.getString("no"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("no"), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell2); //3.3 pr = new Phrase(rb_ch.getString("sudimost"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("sudimost"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(3); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField138().equals("")) { pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } if (!person.getField139().equals("")) { pr.add(new Phrase(rb_ch.getString("no"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("no"), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell2); //3.4 pr = new Phrase(rb_ch.getString("illness"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("illness"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(3); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField140().equals("")) { pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } if (!person.getField141().equals("")) { pr.add(new Phrase(rb_ch.getString("no"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("no"), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell2); //3.5 pr = new Phrase(rb_ch.getString("ilnessContry"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("ilnessContry"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(3); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField142().equals("")) { pr.add(new Phrase(rb_ch.getString("yes"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("yes"), font_ru)); } if (!person.getField143().equals("")) { pr.add(new Phrase(rb_ch.getString("no"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("no"), font_ru)); } cell2 = new PdfPCell(pr); table1.addCell(cell2); //3.6 pr = new Phrase(rb_ch.getString("ilnessContryMoreDesc"), font_ch); if (!person.getField145().equals("")) { pr.add(new Phrase(person.getField145(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("ilnessContryMoreDesc"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(4); table1.addCell(cell1); //3.7 pr = new Phrase(rb_ch.getString("ilnessContryOtherDesc"), font_ch); if (!person.getField146().equals("")) { pr.add(new Phrase(person.getField146(), font_ru)); } pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("ilnessContryOtherDesc"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(4); table1.addCell(cell1); //3.8 pr = new Phrase(rb_ch.getString("ilnessContryPersonData"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("ilnessContryPersonData"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(4); table1.addCell(cell1); //3.8.1 pr = new Phrase(rb_ch.getString("info"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("info"), font_ru)); pr.add(new Phrase("\n")); cell1 = new PdfPCell(pr); table1.addCell(cell1); //3.8.2 pr = new Phrase(rb_ch.getString("person1"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("person1"), font_ru)); pr.add(new Phrase("\n")); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ch.getString("photo"), font_ch)); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("photo"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); //3.8.3 pr = new Phrase(rb_ch.getString("person2"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("person2"), font_ru)); pr.add(new Phrase("\n")); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ch.getString("photo"), font_ch)); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("photo"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); //3.8.4 pr = new Phrase(rb_ch.getString("person3"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("person3"), font_ru)); pr.add(new Phrase("\n")); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ch.getString("photo"), font_ch)); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("photo"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); //3.8.body //for(int i = 1; i< 4; i++){ //fio pr = new Phrase(rb_ch.getString("part3.8_1"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part3.8_1"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField147().equals("")) { pr.add(new Phrase(person.getField147(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField148().equals("")) { pr.add(new Phrase(person.getField148(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField149().equals("")) { pr.add(new Phrase(person.getField149(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); //sex pr = new Phrase(rb_ch.getString("part3.8_2"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part3.8_2"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField150().equals("")) { pr.add(new Phrase(person.getField150(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField151().equals("")) { pr.add(new Phrase(person.getField151(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField152().equals("")) { pr.add(new Phrase(person.getField152(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); // pr = new Phrase(rb_ch.getString("part3.8_3"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part3.8_3"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField153().equals("")) { pr.add(new Phrase(person.getField153(), font_ru)); } if (!person.getField154().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField154(), font_ru)); } if (!person.getField155().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField155(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField156().equals("")) { pr.add(new Phrase(person.getField156(), font_ru)); } if (!person.getField157().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField157(), font_ru)); } if (!person.getField158().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField158(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(""); if (!person.getField159().equals("")) { pr.add(new Phrase(person.getField159(), font_ru)); } if (!person.getField160().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField160(), font_ru)); } if (!person.getField161().equals("")) { pr.add(new Phrase("/")); pr.add(new Phrase(person.getField161(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); //} tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); document.add(basetable); //////////////////////////////////////part4 pr = new Phrase("\n"); pr.add(new Phrase(rb_ch.getString("part4"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part4"), font_ru)); pr.add(new Phrase("\n")); document.add(pr); //4.1 basetable = new PdfPTable(2); basetable.setWidthPercentage(100); table1 = new PdfPTable(2); table1.setWidths(new int[] { 1, 1 }); pr = new Phrase(rb_ch.getString("part4.1"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part4.1"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); //4.2 pr = new Phrase(rb_ch.getString("part4.2"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part4.2"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); //4.3 pr = new Phrase(rb_ch.getString("part4.3"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part4.3"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); //4.4 pr = new Phrase(rb_ch.getString("part4.4"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part4.4"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(rb_ch.getString("part4.5"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part4.5"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); //4.5 pr = new Phrase(rb_ch.getString("part4.5"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part4.5"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); // tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); // document.add(basetable); //////////////////////////////////////part5 pr = new Phrase("\n"); pr.add(new Phrase(rb_ch.getString("part5"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part5"), font_ru)); pr.add(new Phrase("\n")); document.add(pr); basetable = new PdfPTable(2); basetable.setWidthPercentage(100); table1 = new PdfPTable(4); table1.setWidths(new int[] { 1, 1, 1, 1 }); //5.1 5.2 pr = new Phrase(rb_ch.getString("part5.1"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part5.1"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField162().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField162(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(rb_ch.getString("part5.2"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part5.2"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField163().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField163(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); //5.3 5.4 pr = new Phrase(rb_ch.getString("part5.3"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part5.3"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField164().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField164(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(rb_ch.getString("part5.4"), font_ch); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ru.getString("part5.4"), font_ru)); cell1 = new PdfPCell(pr); table1.addCell(cell1); pr = new Phrase(); if (!person.getField165().equals("")) { pr.add(new Phrase(" ")); pr.add(new Phrase(person.getField165(), font_ru)); } cell1 = new PdfPCell(pr); table1.addCell(cell1); //5.5 pr = new Phrase(rb_ch.getString("part5.5"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part5.5"), font_ru)); pr.add(new Phrase("\n")); pr.add(new Phrase(rb_ch.getString("part5.5.1"), font_ch)); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part5.5.1"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(4); table1.addCell(cell1); //5.5 pr = new Phrase(rb_ch.getString("part5.6"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part5.6"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); pr = new Phrase(rb_ch.getString("part5.7"), font_ch); pr.add(new Phrase(" ")); pr.add(new Phrase(rb_ru.getString("part5.7"), font_ru)); cell1 = new PdfPCell(pr); cell1.setColspan(2); table1.addCell(cell1); // tcell = new PdfPCell(table1); tcell.setColspan(2); basetable.addCell(tcell); ///////////////////////////////////// document.add(basetable); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } // step 5 document.close(); // }
From source file:ManagementPackage.ServiceEnd.java
private void txtDoneActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtDoneActionPerformed // TODO add your handling code here: Document doc = new Document(); try {// w w w . j a v a 2s .c om long time = new Date().getTime(); TransNo = "" + time; PdfWriter.getInstance(doc, new FileOutputStream("Invoices\\Invoices" + time + ".pdf")); doc.open(); PdfPTable table = new PdfPTable(4); PdfPCell cell1 = new PdfPCell(new Paragraph("Shop Management System \n\n", FontFactory.getFont(FontFactory.TIMES_BOLD, 20, Font.BOLD, BaseColor.WHITE))); cell1.setColspan(10); cell1.setPadding(10); cell1.setHorizontalAlignment(Element.ALIGN_CENTER); cell1.setBackgroundColor(BaseColor.BLACK); table.addCell(cell1); PdfPCell cell21 = new PdfPCell(new Paragraph("\n\n")); cell21.setColspan(10); cell21.setBorder(2); cell21.setBorderColorLeft(BaseColor.WHITE); table.addCell(cell21); PdfPCell cell2 = new PdfPCell(new Paragraph("Invoice/Money Receipt\n")); cell2.setColspan(10); cell2.setPadding(10); cell2.setHorizontalAlignment(Element.ALIGN_CENTER); cell2.setBackgroundColor(BaseColor.LIGHT_GRAY); table.addCell(cell2); PdfPCell cell3 = new PdfPCell(new Paragraph("Transaction No: " + time, FontFactory.getFont(null, 10))); cell3.setColspan(2); cell3.setPaddingBottom(10); cell3.setPaddingTop(10); cell3.setBorder(2); cell3.setBorderColorLeft(BaseColor.WHITE); table.addCell(cell3); PdfPCell cell4 = new PdfPCell( new Paragraph("Date: " + formatedDateTime, FontFactory.getFont(null, 10))); cell4.setColspan(3); cell4.setPaddingBottom(10); cell4.setPaddingTop(10); cell4.setBorder(2); cell4.setHorizontalAlignment(Element.ALIGN_RIGHT); cell4.setBorderColorRight(BaseColor.WHITE); table.addCell(cell4); //table.addCell("Sl No"); table.addCell("Product Name"); table.addCell("Rate"); table.addCell("Qty"); table.addCell("Amount (TK)"); String query = "select product_name, rate, qty, amount from temp_trans WHERE trans_by = '" + user + "'"; try { pst = con.prepareStatement(query); rs = pst.executeQuery(); while (rs.next()) { //String sl_no = rs.getString("sl_no"); String product_name = rs.getString("product_name"); String rate = rs.getString("rate"); String qty = rs.getString("qty"); String amount = rs.getString("amount"); //table.addCell(sl_no); table.addCell(product_name); table.addCell(rate); table.addCell(qty); PdfPCell cellAmount = new PdfPCell(new Paragraph(amount)); cellAmount.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellAmount); } rs.close(); pst.close(); } catch (SQLException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } PdfPCell cellb = new PdfPCell(new Paragraph(" ")); cellb.setColspan(10); cellb.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellb); // PdfPCell celltxtTotal = new PdfPCell(new Paragraph("Total")); celltxtTotal.setColspan(3); celltxtTotal.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal); PdfPCell celltxtTotal1 = new PdfPCell(new Paragraph(txtTotal.getText())); celltxtTotal1.setColspan(2); celltxtTotal1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal1); PdfPCell celltxtAdjust = new PdfPCell(new Paragraph("Adjustment")); celltxtAdjust.setColspan(3); celltxtAdjust.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust); PdfPCell celltxtAdjust1 = new PdfPCell(new Paragraph(txtAdjust.getText())); celltxtAdjust1.setColspan(2); celltxtAdjust1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust1); PdfPCell celltxtTotalPaid = new PdfPCell(new Paragraph("Billed By: " + user)); celltxtTotalPaid.setColspan(2); //celltxtTotalPaid.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid); PdfPCell celltxtTotalPaid0 = new PdfPCell(new Paragraph("Total Paid")); celltxtTotalPaid0.setColspan(1); celltxtTotalPaid0.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid0); PdfPCell celltxtTotalPaid1 = new PdfPCell(new Paragraph(txtTotalPaid.getText())); celltxtTotalPaid1.setColspan(2); celltxtTotalPaid1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid1); doc.add(table); doc.close(); savePermanently(); clearTempTable(); //JOptionPane.showMessageDialog(null, "Report Created!"); // open PDF file File file = new File("Invoices\\Invoices" + time + ".pdf"); if (file.toString().endsWith(".pdf")) Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + file); else { Desktop desktop = Desktop.getDesktop(); desktop.open(file); } } catch (DocumentException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (FileNotFoundException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:ManagementPackage.Setting.java
private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem4ActionPerformed // TODO add your handling code here: totalAdjustment = 0;//ww w .j a v a 2 s . co m totalTotalPaid = 0; total = 0; Document doc = new Document(); try { long time = new Date().getTime(); PdfWriter.getInstance(doc, new FileOutputStream("Reports\\Daily" + time + " " + formatedDate + ".pdf")); doc.open(); PdfPTable table = new PdfPTable(5); PdfPCell cell1 = new PdfPCell(new Paragraph("Shop Management System \n\n", FontFactory.getFont(FontFactory.TIMES_BOLD, 20, Font.BOLD, BaseColor.WHITE))); cell1.setColspan(10); cell1.setPadding(10); cell1.setHorizontalAlignment(Element.ALIGN_CENTER); cell1.setBackgroundColor(BaseColor.BLACK); table.addCell(cell1); PdfPCell cell21 = new PdfPCell(new Paragraph("\n\n")); cell21.setColspan(10); cell21.setBorder(2); cell21.setBorderColorLeft(BaseColor.WHITE); table.addCell(cell21); PdfPCell cell2 = new PdfPCell(new Paragraph("Daily Report\n")); cell2.setColspan(10); cell2.setPadding(10); cell2.setHorizontalAlignment(Element.ALIGN_CENTER); cell2.setBackgroundColor(BaseColor.LIGHT_GRAY); table.addCell(cell2); PdfPCell cell4 = new PdfPCell(new Paragraph("Date: " + formatedDateTime)); cell4.setColspan(10); cell4.setPaddingBottom(10); cell4.setPaddingTop(10); cell4.setBorder(2); cell4.setHorizontalAlignment(Element.ALIGN_RIGHT); cell4.setBorderColorRight(BaseColor.WHITE); table.addCell(cell4); table.addCell("Transaction No"); table.addCell("Billed By"); table.addCell("Product Name"); table.addCell("Qty"); table.addCell("Amount (TK)"); String PrevTransNo = " "; String query = "select trans_no, product_name, qty, amount, trans_by from trans_details where date = '" + formatedDate + "'"; try { pst = con.prepareStatement(query); rs = pst.executeQuery(); while (rs.next()) { String NewTransNo = rs.getString("trans_no"); String product_name = rs.getString("product_name"); String qty = rs.getString("qty"); String amount = rs.getString("amount"); String trans_by = rs.getString("trans_by"); total = total + Float.parseFloat(amount); if (PrevTransNo.equals(NewTransNo)) table.addCell(" "); else { table.addCell(NewTransNo); String query1 = "select adjustment, total_paid from paid_amount where trans_no = '" + NewTransNo + "'"; pst1 = con1.prepareStatement(query1); rs1 = pst1.executeQuery(); String adjustment = rs1.getString("adjustment"); String total_paid = rs1.getString("total_paid"); totalAdjustment = totalAdjustment + Float.parseFloat(adjustment); totalTotalPaid = totalTotalPaid + Float.parseFloat(total_paid); rs1.close(); pst1.close(); } PrevTransNo = rs.getString("trans_no"); table.addCell(trans_by); table.addCell(product_name); table.addCell(qty); PdfPCell cellAmount = new PdfPCell(new Paragraph(amount)); cellAmount.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellAmount); } rs.close(); pst.close(); } catch (SQLException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } PdfPCell cellb = new PdfPCell(new Paragraph(" ")); cellb.setColspan(10); cellb.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellb); // PdfPCell celltxtTotal = new PdfPCell(new Paragraph("Total")); celltxtTotal.setColspan(3); celltxtTotal.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal); PdfPCell celltxtTotal1 = new PdfPCell(new Paragraph("" + total)); celltxtTotal1.setColspan(2); celltxtTotal1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal1); PdfPCell celltxtAdjust = new PdfPCell(new Paragraph("Adjustment")); celltxtAdjust.setColspan(3); celltxtAdjust.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust); PdfPCell celltxtAdjust1 = new PdfPCell(new Paragraph("" + totalAdjustment)); celltxtAdjust1.setColspan(2); celltxtAdjust1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust1); PdfPCell celltxtTotalPaid = new PdfPCell(new Paragraph("Total Paid")); celltxtTotalPaid.setColspan(3); celltxtTotalPaid.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid); PdfPCell celltxtTotalPaid1 = new PdfPCell(new Paragraph("" + totalTotalPaid)); celltxtTotalPaid1.setColspan(2); celltxtTotalPaid1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid1); doc.add(table); doc.close(); //JOptionPane.showMessageDialog(null, "Report Created!"); // open PDF file File file = new File("Reports\\Daily" + time + " " + formatedDate + ".pdf"); if (file.toString().endsWith(".pdf")) Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + file); else { Desktop desktop = Desktop.getDesktop(); desktop.open(file); } } catch (DocumentException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (FileNotFoundException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:ManagementPackage.Setting.java
private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem5ActionPerformed // TODO add your handling code here: totalAdjustment = 0;/* ww w. j a va2 s . c om*/ totalTotalPaid = 0; total = 0; Document doc = new Document(); try { long time = new Date().getTime(); PdfWriter.getInstance(doc, new FileOutputStream("Reports\\Monthly" + time + " " + formatedDate + ".pdf")); doc.open(); PdfPTable table = new PdfPTable(5); PdfPCell cell1 = new PdfPCell(new Paragraph("Shop Management System \n\n", FontFactory.getFont(FontFactory.TIMES_BOLD, 20, Font.BOLD, BaseColor.WHITE))); cell1.setColspan(10); cell1.setPadding(10); cell1.setHorizontalAlignment(Element.ALIGN_CENTER); cell1.setBackgroundColor(BaseColor.BLACK); table.addCell(cell1); PdfPCell cell21 = new PdfPCell(new Paragraph("\n\n")); cell21.setColspan(10); cell21.setBorder(2); cell21.setBorderColorLeft(BaseColor.WHITE); table.addCell(cell21); PdfPCell cell2 = new PdfPCell(new Paragraph("Monthly Report\n")); cell2.setColspan(10); cell2.setPadding(10); cell2.setHorizontalAlignment(Element.ALIGN_CENTER); cell2.setBackgroundColor(BaseColor.LIGHT_GRAY); table.addCell(cell2); PdfPCell cell4 = new PdfPCell(new Paragraph("Date: " + formatedDateTime)); cell4.setColspan(10); cell4.setPaddingBottom(10); cell4.setPaddingTop(10); cell4.setBorder(2); cell4.setHorizontalAlignment(Element.ALIGN_RIGHT); cell4.setBorderColorRight(BaseColor.WHITE); table.addCell(cell4); table.addCell("Transaction No"); table.addCell("Billed By"); table.addCell("Product Name"); table.addCell("Qty"); table.addCell("Amount (TK)"); String PrevTransNo = " "; String query = "select trans_no, product_name, qty, amount, trans_by from trans_details where date like '%" + month + "%'"; try { pst = con.prepareStatement(query); rs = pst.executeQuery(); while (rs.next()) { String NewTransNo = rs.getString("trans_no"); String product_name = rs.getString("product_name"); String qty = rs.getString("qty"); String amount = rs.getString("amount"); String trans_by = rs.getString("trans_by"); total = total + Float.parseFloat(amount); if (PrevTransNo.equals(NewTransNo)) table.addCell(" "); else { table.addCell(NewTransNo); String query1 = "select adjustment, total_paid from paid_amount where trans_no = '" + NewTransNo + "'"; pst1 = con1.prepareStatement(query1); rs1 = pst1.executeQuery(); String adjustment = rs1.getString("adjustment"); String total_paid = rs1.getString("total_paid"); totalAdjustment = totalAdjustment + Float.parseFloat(adjustment); totalTotalPaid = totalTotalPaid + Float.parseFloat(total_paid); rs1.close(); pst1.close(); } PrevTransNo = rs.getString("trans_no"); table.addCell(trans_by); table.addCell(product_name); table.addCell(qty); PdfPCell cellAmount = new PdfPCell(new Paragraph(amount)); cellAmount.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellAmount); } rs.close(); pst.close(); } catch (SQLException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } PdfPCell cellb = new PdfPCell(new Paragraph(" ")); cellb.setColspan(10); cellb.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellb); // PdfPCell celltxtTotal = new PdfPCell(new Paragraph("Total")); celltxtTotal.setColspan(3); celltxtTotal.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal); PdfPCell celltxtTotal1 = new PdfPCell(new Paragraph("" + total)); celltxtTotal1.setColspan(2); celltxtTotal1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal1); PdfPCell celltxtAdjust = new PdfPCell(new Paragraph("Adjustment")); celltxtAdjust.setColspan(3); celltxtAdjust.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust); PdfPCell celltxtAdjust1 = new PdfPCell(new Paragraph("" + totalAdjustment)); celltxtAdjust1.setColspan(2); celltxtAdjust1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust1); PdfPCell celltxtTotalPaid = new PdfPCell(new Paragraph("Total Paid")); celltxtTotalPaid.setColspan(3); celltxtTotalPaid.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid); PdfPCell celltxtTotalPaid1 = new PdfPCell(new Paragraph("" + totalTotalPaid)); celltxtTotalPaid1.setColspan(2); celltxtTotalPaid1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid1); doc.add(table); doc.close(); //JOptionPane.showMessageDialog(null, "Report Created!"); // open PDF file File file = new File("Reports\\Monthly" + time + " " + formatedDate + ".pdf"); if (file.toString().endsWith(".pdf")) Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + file); else { Desktop desktop = Desktop.getDesktop(); desktop.open(file); } } catch (DocumentException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (FileNotFoundException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:ManagementPackage.Setting.java
private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem6ActionPerformed // TODO add your handling code here: totalAdjustment = 0;//from w ww .j a v a 2 s . c om totalTotalPaid = 0; total = 0; Document doc = new Document(); try { long time = new Date().getTime(); PdfWriter.getInstance(doc, new FileOutputStream("Reports\\Yearly" + time + " " + formatedDate + ".pdf")); doc.open(); PdfPTable table = new PdfPTable(5); PdfPCell cell1 = new PdfPCell(new Paragraph("Shop Management System \n\n", FontFactory.getFont(FontFactory.TIMES_BOLD, 20, Font.BOLD, BaseColor.WHITE))); cell1.setColspan(10); cell1.setPadding(10); cell1.setHorizontalAlignment(Element.ALIGN_CENTER); cell1.setBackgroundColor(BaseColor.BLACK); table.addCell(cell1); PdfPCell cell21 = new PdfPCell(new Paragraph("\n\n")); cell21.setColspan(10); cell21.setBorder(2); cell21.setBorderColorLeft(BaseColor.WHITE); table.addCell(cell21); PdfPCell cell2 = new PdfPCell(new Paragraph("Yearly Report\n")); cell2.setColspan(10); cell2.setPadding(10); cell2.setHorizontalAlignment(Element.ALIGN_CENTER); cell2.setBackgroundColor(BaseColor.LIGHT_GRAY); table.addCell(cell2); PdfPCell cell4 = new PdfPCell(new Paragraph("Date: " + formatedDateTime)); cell4.setColspan(10); cell4.setPaddingBottom(10); cell4.setPaddingTop(10); cell4.setBorder(2); cell4.setHorizontalAlignment(Element.ALIGN_RIGHT); cell4.setBorderColorRight(BaseColor.WHITE); table.addCell(cell4); table.addCell("Transaction No"); table.addCell("Billed By"); table.addCell("Product Name"); table.addCell("Qty"); table.addCell("Amount (TK)"); String PrevTransNo = " "; String query = "select trans_no, product_name, qty, amount, trans_by from trans_details where date like '%" + year + "%'"; try { pst = con.prepareStatement(query); rs = pst.executeQuery(); while (rs.next()) { String NewTransNo = rs.getString("trans_no"); String product_name = rs.getString("product_name"); String qty = rs.getString("qty"); String amount = rs.getString("amount"); String trans_by = rs.getString("trans_by"); total = total + Float.parseFloat(amount); if (PrevTransNo.equals(NewTransNo)) table.addCell(" "); else { table.addCell(NewTransNo); String query1 = "select adjustment, total_paid from paid_amount where trans_no = '" + NewTransNo + "'"; pst1 = con1.prepareStatement(query1); rs1 = pst1.executeQuery(); String adjustment = rs1.getString("adjustment"); String total_paid = rs1.getString("total_paid"); totalAdjustment = totalAdjustment + Float.parseFloat(adjustment); totalTotalPaid = totalTotalPaid + Float.parseFloat(total_paid); rs1.close(); pst1.close(); } PrevTransNo = rs.getString("trans_no"); table.addCell(trans_by); table.addCell(product_name); table.addCell(qty); PdfPCell cellAmount = new PdfPCell(new Paragraph(amount)); cellAmount.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellAmount); } rs.close(); pst.close(); } catch (SQLException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } PdfPCell cellb = new PdfPCell(new Paragraph(" ")); cellb.setColspan(10); cellb.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(cellb); // PdfPCell celltxtTotal = new PdfPCell(new Paragraph("Total")); celltxtTotal.setColspan(3); celltxtTotal.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal); PdfPCell celltxtTotal1 = new PdfPCell(new Paragraph("" + total)); celltxtTotal1.setColspan(2); celltxtTotal1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotal1); PdfPCell celltxtAdjust = new PdfPCell(new Paragraph("Adjustment")); celltxtAdjust.setColspan(3); celltxtAdjust.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust); PdfPCell celltxtAdjust1 = new PdfPCell(new Paragraph("" + totalAdjustment)); celltxtAdjust1.setColspan(2); celltxtAdjust1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtAdjust1); PdfPCell celltxtTotalPaid = new PdfPCell(new Paragraph("Total Paid")); celltxtTotalPaid.setColspan(3); celltxtTotalPaid.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid); PdfPCell celltxtTotalPaid1 = new PdfPCell(new Paragraph("" + totalTotalPaid)); celltxtTotalPaid1.setColspan(2); celltxtTotalPaid1.setHorizontalAlignment(Element.ALIGN_RIGHT); table.addCell(celltxtTotalPaid1); doc.add(table); doc.close(); //JOptionPane.showMessageDialog(null, "Report Created!"); // open PDF file File file = new File("Reports\\Yearly" + time + " " + formatedDate + ".pdf"); if (file.toString().endsWith(".pdf")) Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + file); else { Desktop desktop = Desktop.getDesktop(); desktop.open(file); } } catch (DocumentException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (FileNotFoundException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(ServiceEnd.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:Measurment_Result_Record.MeasurmentSetup.java
/** * write the given table datas to the given document * @param doc document to write the result tables on * @param table the result table /*from w w w . j a v a 2s. c o m*/ * @param m_title the measurment title */ public static void addResultTablesTotheDocument(Document doc, JTable table, String m_title) throws DocumentException { //add the measurment title and table Paragraph measurmenttitle = new Paragraph(m_title + "\n "); measurmenttitle.getFont().setStyle(com.itextpdf.text.Font.BOLD); doc.add(measurmenttitle); int colmWidth = table.getColumnCount(); int rowCount = table.getModel().getRowCount(); PdfPTable resultTable = new PdfPTable(colmWidth); resultTable.setHorizontalAlignment(Element.ALIGN_LEFT); //add the table headers for (int i = 0; i < colmWidth; i++) { String headertext = table.getModel().getColumnName(i); PdfPCell cell = new PdfPCell(new Paragraph(headertext)); cell.setHorizontalAlignment(Element.ALIGN_CENTER); cell.setBackgroundColor(BaseColor.LIGHT_GRAY); resultTable.addCell(cell); } //add the table body for (int r = 0; r < rowCount; r++) { for (int c = 0; c < colmWidth; c++) { String data = table.getValueAt(r, c).toString(); resultTable.addCell(data); } } resultTable.setSpacingAfter(10); //add the table to the document doc.add(resultTable); }