lmcpointofsalessystem.PDFOrders.java Source code

Introduction

Here is the source code for lmcpointofsalessystem.PDFOrders.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package lmcpointofsalessystem;

import com.lowagie.text.Document;
import com.lowagie.text.DocumentException;
import com.lowagie.text.Element;
import com.lowagie.text.Image;
import com.lowagie.text.PageSize;
import com.lowagie.text.Paragraph;
import com.lowagie.text.pdf.PdfPCell;
import com.lowagie.text.pdf.PdfPTable;
import com.lowagie.text.pdf.PdfWriter;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import static lmcpointofsalessystem.ManageEmployee.s;

/**
 *
 * @author JohnReinel
 */
public class PDFOrders {
    Connection con;
    String dataSourceName;
    Statement st;
    ResultSet rs;
    CreateOrder co = new CreateOrder();

    public PdfPTable getDatas(String tblName) {
        ;
        PdfPTable headerTable = new PdfPTable(1);
        String newT = tblName.toString();
        String col1 = co.tblOrder.getColumnName(0);
        String col2 = co.tblOrder.getColumnName(1);
        int nrow = co.tblModel.getRowCount();
        int ncol = co.tblModel.getColumnCount();
        Object[][] tabledata = new Object[nrow][ncol];
        for (int i = 0; i < nrow; i++) {
            for (int j = 0; j < ncol; j++) {
                tabledata[i][j] = co.tblModel.getValueAt(i, j);
            }
        }
        String columnExe = "";
        columnExe = "empID,Fname,Lname,Username,Password,Address,Contact,Type";
        String[] colH = columnExe.split(",");
        int colL = 0;
        colL = columnExe.split(",").length;
        headerTable = new PdfPTable(colL);
        for (int x = 0; x < colL; x++) {
            if (colH[x].toString().equals(col1)) {
                colH[x] = "OrderNo1";
            } else if (colH[x].toString().equals(col2)) {
                colH[x] = "O.CustNo";
            }

            PdfPCell newHeader = new PdfPCell();
            newHeader.addElement(new Paragraph(colH[x]));
            headerTable.addCell(newHeader);
        }
        int colNums = colH.length;
        int colCount = 0;
        for (int x = 1; x <= colL; x++) {
            colCount += 1;

            PdfPCell newCell = new PdfPCell();
            newCell.addElement(new Paragraph((x)));
            headerTable.setWidthPercentage(90);
            headerTable.addCell(newCell);
        }
        float[] widths2 = new float[colNums];
        for (int i = 0; i < colNums; i++) {
            widths2[i] = 150;
        }
        try {
            headerTable.setWidths(widths2);
        } catch (DocumentException ex) {
            Logger.getLogger(PDFEmployees.class.getName()).log(Level.SEVERE, null, ex);
        }

        return headerTable;
    }

    public void connectToDatabase() {
        dataSourceName = "LMCPOSDB1";//must be same name set in ODBC
        String dbSource = "jdbc:odbc:" + dataSourceName;
        try {
            //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//fixed for java odbc
            con = DriverManager.getConnection(dbSource, "", "");
            //in con statement, last two parameters represent username and password
            //which is being set upon SQL nstallation
            System.out.println("SUCCESS!");
            st = con.createStatement();//makes your dbase ready to accept statement
        } catch (Exception err) {
            System.out.println("Error: " + err);
        }
    }

    public PDFOrders(String tblName) throws IOException {
        try {
            LMCPointofSalesSystem connect = new LMCPointofSalesSystem();
            con = connect.con;
            st = connect.s;
            Document document = new Document(PageSize.A4.rotate(), 0, 0, 0, 0);

            PdfWriter.getInstance(document, new FileOutputStream(tblName + ".pdf"));
            document.open();
            Image image = Image.getInstance("src/lmcpointofsalessystem/Assets/header3.png");
            document.add(image);
            document.setMarginMirroring(true);

            PdfPTable newheaderTable;
            newheaderTable = getDatas(tblName);
            newheaderTable.setHorizontalAlignment(Element.ALIGN_CENTER);
            document.add(newheaderTable);
            document.close();

        } catch (FileNotFoundException ex) {
            Logger.getLogger(PDFEmployees.class.getName()).log(Level.SEVERE, null, ex);
        } catch (DocumentException ex) {
            Logger.getLogger(PDFEmployees.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}