package com.reallinkbilling.download;

import static java.awt.Color.WHITE;
import static org.apache.pdfbox.pdmodel.font.PDType1Font.HELVETICA;
import static org.vandeseer.easytable.settings.HorizontalAlignment.CENTER;
import static org.vandeseer.easytable.settings.HorizontalAlignment.LEFT;

import java.awt.Color;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.pdfbox.pdmodel.PDDocument;
import org.apache.pdfbox.pdmodel.PDPage;
import org.apache.pdfbox.pdmodel.PDPageContentStream;
import org.apache.pdfbox.pdmodel.common.PDRectangle;
import org.apache.pdfbox.pdmodel.font.PDType1Font;
import org.apache.struts2.ServletActionContext;
import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;
import org.vandeseer.easytable.TableDrawer;
import org.vandeseer.easytable.structure.Row;
import org.vandeseer.easytable.structure.Table;
import org.vandeseer.easytable.structure.Table.TableBuilder;
import org.vandeseer.easytable.structure.cell.TextCell;

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.DAO.EmployeePresentDetailsDAO;
import com.reallinkbilling.db.GetDBConnection;

public class DownloadEmployeeAbsentEntryReport extends ActionSupport
        implements SessionAware {

    private static final long serialVersionUID = 1L;

    private HttpSession session;

    public HttpServletRequest request;
    public HttpServletResponse response;

    private SessionMap<String, Object> sessionMap;

    private String fromDate;
    private String toDate;
    private String employeeName;

    private List<EmployeePresentDetailsDAO> employeePresentDetailsDAOList =
            new ArrayList<EmployeePresentDetailsDAO>();

    private static final float PADDING5 = 5f;
    private static final float PADDING20 = 20f;
    private static final float PADDING30 = 30f;

    public void download() {

        this.setSession(
                ServletActionContext.getRequest().getSession(false)
        );

        if (this.getSession() == null
                || this.getSession().getAttribute("login") == null) {

            addActionMessage("Please Login First !!!");
            return;
        }

        response = ServletActionContext.getResponse();
        request = ServletActionContext.getRequest();

        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        try {

            String shopId = (String) this.getSessionMap().get("shopId");
            String shopCode = (String) this.getSessionMap().get("shopCode");
            String db = (String) this.getSessionMap().get("db");

            String shopName =
                    (String) this.getSessionMap().get("shopnameenglish");

            connection = GetDBConnection.getDBConnection(db);

            /*
             * Fetch report data
             *
             * Employee name is optional.
             * If employeeName is blank, "%" is used and
             * all employees are selected.
             */
            String sql =
                    "SELECT "
                    + "entry_id,"
                    + "DATE_FORMAT(marking_date,'%d-%m-%Y'),"
                    + "employee_id,"
                    + "employee_name,"
                    + "type_of_marking,"
                    + "details,"
                    + "entry_by "
                    + "FROM "
                    + "shop_employee_presenty_details "
                    + "WHERE "
                    + "marking_date BETWEEN "
                    + "STR_TO_DATE(?,'%d-%m-%Y') "
                    + "AND "
                    + "STR_TO_DATE(?,'%d-%m-%Y') "
                    + "AND "
                    + "shop_id = ? "
                    + "AND "
                    + "shop_code = ? "
                    + "AND "
                    + "employee_name LIKE ? "
                    + "ORDER BY marking_date, entry_id";

            preparedStatement = connection.prepareStatement(sql);

            preparedStatement.setString(1, this.getFromDate());
            preparedStatement.setString(2, this.getToDate());
            preparedStatement.setString(3, shopId);
            preparedStatement.setString(4, shopCode);

            if (this.getEmployeeName() == null
                    || this.getEmployeeName().trim().isEmpty()) {

                preparedStatement.setString(5, "%");

            } else {

                preparedStatement.setString(
                        5,
                        "%" + this.getEmployeeName().trim() + "%"
                );
            }

            resultSet = preparedStatement.executeQuery();

            while (resultSet.next()) {

                EmployeePresentDetailsDAO detailsDAO =
                        new EmployeePresentDetailsDAO();

                detailsDAO.setEntryId(resultSet.getString(1));
                detailsDAO.setMarkingDate(resultSet.getString(2));
                detailsDAO.setEmployeeId(resultSet.getString(3));
                detailsDAO.setEmployeeName(resultSet.getString(4));
                detailsDAO.setTypeOfMarking(resultSet.getString(5));
                detailsDAO.setDetails(resultSet.getString(6));
                detailsDAO.setEntryBy(resultSet.getString(7));

                this.getEmployeePresentDetailsDAOList().add(detailsDAO);
            }

            /*
             * No records found
             */
            if (this.getEmployeePresentDetailsDAOList().size() == 0) {

                addActionError(
                        "Details not found for provided dates and employee!"
                );

                return;
            }

            /*
             * PDF path
             */
            String path =
                    request.getSession()
                           .getServletContext()
                           .getRealPath("/images/");

            /*
             * Create PDF
             */
            PDDocument document = new PDDocument();

            int pageCount = 1;

            PDPage page = new PDPage(PDRectangle.A4);
            document.addPage(page);

            PDPageContentStream contentStream =
                    new PDPageContentStream(document, page);

            float startY =
                    page.getMediaBox().getHeight() - PADDING20;

            float currentY = startY;

            /*
             * Create PDF Header
             */
            Table header = createHeader(
                    shopName,
                    pageCount
            );

            TableDrawer.builder()
                    .contentStream(contentStream)
                    .table(header)
                    .startX(PADDING30)
                    .startY(startY)
                    .build()
                    .draw();

            /*
             * Create details table
             */
            TableBuilder tableDetailsBuilder =
                    createDetailsTableHeader();

            int size =
                    this.getEmployeePresentDetailsDAOList().size();

            for (int i = 0; i < size; i++) {

                /*
                 * Create new page when required
                 */
                if (currentY < 100) {

                    /*
                     * Draw existing table
                     */
                    Table previousTable =
                            tableDetailsBuilder.build();

                    TableDrawer.builder()
                            .contentStream(contentStream)
                            .table(previousTable)
                            .startX(PADDING5)
                            .startY(startY - 55)
                            .build()
                            .draw();

                    contentStream.close();

                    /*
                     * New page
                     */
                    pageCount++;

                    page = new PDPage(PDRectangle.A4);

                    document.addPage(page);

                    contentStream =
                            new PDPageContentStream(
                                    document,
                                    page
                            );

                    currentY =
                            page.getMediaBox().getHeight()
                            - PADDING20;

                    /*
                     * New page header
                     */
                    header = createHeader(
                            shopName,
                            pageCount
                    );

                    TableDrawer.builder()
                            .contentStream(contentStream)
                            .table(header)
                            .startX(PADDING30)
                            .startY(currentY)
                            .build()
                            .draw();

                    /*
                     * Create fresh details table
                     */
                    tableDetailsBuilder =
                            createDetailsTableHeader();

                }

                EmployeePresentDetailsDAO dao =
                        this.getEmployeePresentDetailsDAOList()
                            .get(i);

                String entryId =
                        dao.getEntryId() == null
                        ? ""
                        : dao.getEntryId();

                String date =
                        dao.getMarkingDate() == null
                        ? ""
                        : dao.getMarkingDate();

                String employee =
                        dao.getEmployeeName() == null
                        ? ""
                        : dao.getEmployeeName();

                String type =
                        dao.getTypeOfMarking() == null
                        ? ""
                        : dao.getTypeOfMarking();

                String details =
                        dao.getDetails() == null
                        ? ""
                        : dao.getDetails();

                String entryBy =
                        dao.getEntryBy() == null
                        ? ""
                        : dao.getEntryBy();

                /*
                 * Add row
                 */
                Row employeeInfo =
                        Row.builder()

//                        .add(
//                            TextCell.builder()
//                            .text(entryId)
//                            .horizontalAlignment(CENTER)
//                            .borderWidth(0.5F)
//                            .lineSpacing(1F)
//                            .build()
//                        )

                        .add(
                            TextCell.builder()
                            .text(date)
                            .horizontalAlignment(CENTER)
                            .borderWidth(0.5F)
                            .lineSpacing(1F)
                            .build()
                        )

                        .add(
                            TextCell.builder()
                            .text(employee)
                            .horizontalAlignment(LEFT)
                            .borderWidth(0.5F)
                            .lineSpacing(1F)
                            .build()
                        )

                        .add(
                            TextCell.builder()
                            .text(type)
                            .horizontalAlignment(CENTER)
                            .borderWidth(0.5F)
                            .lineSpacing(1F)
                            .build()
                        )

                        .add(
                            TextCell.builder()
                            .text(details)
                            .horizontalAlignment(LEFT)
                            .borderWidth(0.5F)
                            .lineSpacing(1F)
                            .build()
                        )

                        .add(
                            TextCell.builder()
                            .text(entryBy)
                            .horizontalAlignment(LEFT)
                            .borderWidth(0.5F)
                            .lineSpacing(1F)
                            .build()
                        )

                        .backgroundColor(WHITE)
                        .textColor(Color.BLACK)
                        .font(PDType1Font.HELVETICA)
                        .fontSize(9)
                        .horizontalAlignment(CENTER)
                        .height(25F)
                        .build();

                tableDetailsBuilder.addRow(employeeInfo);

                currentY = currentY - 25;
            }

            /*
             * Draw final table
             */
            Table finalTable =
                    tableDetailsBuilder.build();

            TableDrawer.builder()
                    .contentStream(contentStream)
                    .table(finalTable)
                    .startX(PADDING5)
                    .startY(
                            page.getMediaBox().getHeight()
                            - PADDING20
                            - 55
                    )
                    .build()
                    .draw();

            contentStream.close();

            /*
             * File name
             */
            String employeePart = "";

            if (this.getEmployeeName() != null
                    && !this.getEmployeeName().trim().isEmpty()) {

                employeePart =
                        "-Employee-"
                        + this.getEmployeeName().trim();
            }

            String fileName =
                    "employee-absent-entry-fromDate-"
                    + this.getFromDate()
                    + "-ToDate-"
                    + this.getToDate()
                    + employeePart
                    + "-report.pdf";

            String filePath =
                    path + "/" + fileName;

            /*
             * Save PDF
             */
            document.save(filePath);
            document.close();

            /*
             * Send PDF to browser
             */
            response.setHeader(
                    "Content-disposition",
                    "inline; filename=" + fileName
            );

            response.setContentType("application/pdf");

            FileInputStream fileInputStream =
                    new FileInputStream(filePath);

            OutputStream outputStream =
                    response.getOutputStream();

            byte[] buffer = new byte[4096];

            int bytesRead;

            while ((bytesRead =
                    fileInputStream.read(buffer)) != -1) {

                outputStream.write(
                        buffer,
                        0,
                        bytesRead
                );
            }

            fileInputStream.close();

            outputStream.flush();
            outputStream.close();

        }
        catch (SQLException e) {

            addActionError(
                    e.getErrorCode()
                    + " || "
                    + e.getMessage()
                    + " || Something Went Wrong!"
            );

        }
        catch (IOException e) {

            addActionError(
                    e.getMessage()
                    + " || "
                    + e.getCause()
                    + " || Something Went Wrong!"
            );

        }
        finally {

            if (resultSet != null) {

                try {
                    resultSet.close();
                }
                catch (SQLException e) {
                }
            }

            if (preparedStatement != null) {

                try {
                    preparedStatement.close();
                }
                catch (SQLException e) {
                }
            }

            if (connection != null) {

                try {
                    connection.close();
                }
                catch (SQLException e) {
                }
            }
        }
    }


    /*
     * ==========================================================
     * PDF HEADER
     * ==========================================================
     */
    private Table createHeader(
            String shopName,
            int pageCount) {

        TableBuilder tableHeaderBuilder =
                Table.builder()
                .addColumnsOfWidth(585)
                .font(HELVETICA)
                .borderColor(Color.BLACK)
                .horizontalAlignment(CENTER);

        Row headerName =
                Row.builder()

                .add(
                    TextCell.builder()
                    .text(
                        shopName == null
                        ? ""
                        : shopName
                    )
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .lineSpacing(10F)
                    .build()
                )

                .backgroundColor(WHITE)
                .textColor(Color.BLACK)
                .font(PDType1Font.HELVETICA_BOLD)
                .fontSize(18)
                .horizontalAlignment(CENTER)
                .build();


        Row info1 =
                Row.builder()

                .add(
                    TextCell.builder()
                    .text(
                        "Employee Absent Entry Report"
                        + "       Page No. : "
                        + pageCount
                    )
                    .borderWidthBottom(0.0F)
                    .horizontalAlignment(CENTER)
                    .build()
                )

                .backgroundColor(WHITE)
                .textColor(Color.BLACK)
                .font(PDType1Font.HELVETICA_BOLD)
                .fontSize(11)
                .horizontalAlignment(CENTER)
                .build();


        String employeeText = "";

        if (this.getEmployeeName() != null
                && !this.getEmployeeName().trim().isEmpty()) {

            employeeText =
                    " and Employee : "
                    + this.getEmployeeName().trim();
        }


        Row info2 =
                Row.builder()

                .add(
                    TextCell.builder()
                    .text(
                        "From Date : "
                        + this.getFromDate()
                        + " and To Date : "
                        + this.getToDate()
                        + employeeText
                    )
                    .borderWidthBottom(0.0F)
                    .horizontalAlignment(CENTER)
                    .build()
                )

                .backgroundColor(WHITE)
                .textColor(Color.BLACK)
                .font(PDType1Font.HELVETICA_BOLD)
                .fontSize(8)
                .horizontalAlignment(CENTER)
                .build();


        tableHeaderBuilder.addRow(headerName);
        tableHeaderBuilder.addRow(info1);
        tableHeaderBuilder.addRow(info2);

        return tableHeaderBuilder.build();
    }


    /*
     * ==========================================================
     * DETAILS TABLE HEADER
     * ==========================================================
     */
    private TableBuilder createDetailsTableHeader() {

        /*
         * Total width = 585
         *
         * Entry Id       = 55
         * Date           = 70
         * Employee Name  = 125
         * Type           = 90
         * Details        = 145
         * Entry By       = 100
         *
         * Total = 585
         */
        TableBuilder tableDetailsBuilder =
                Table.builder()

                .addColumnsOfWidth(
                       
                        70,
                        125,
                        90,
                        200,
                        100
                )

                .font(HELVETICA)
                .borderWidth(0.5F)
                .borderColor(Color.BLACK)
                .horizontalAlignment(CENTER);


        Row tableHeader =
                Row.builder()

//                .add(
//                    TextCell.builder()
//                    .text("Entry Id")
//                    .horizontalAlignment(CENTER)
//                    .borderWidth(0.5F)
//                    .lineSpacing(1F)
//                    .build()
//                )

                .add(
                    TextCell.builder()
                    .text("Date")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5F)
                    .lineSpacing(1F)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Employee Name")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5F)
                    .lineSpacing(1F)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Type Of Marking")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5F)
                    .lineSpacing(1F)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Details")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5F)
                    .lineSpacing(1F)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Entry By")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5F)
                    .lineSpacing(1F)
                    .build()
                )

                .backgroundColor(Color.LIGHT_GRAY)
                .textColor(Color.BLACK)
                .font(PDType1Font.HELVETICA_BOLD)
                .fontSize(9)
                .horizontalAlignment(CENTER)
                .build();


        tableDetailsBuilder.addRow(tableHeader);

        return tableDetailsBuilder;
    }


    /*
     * ==========================================================
     * GETTERS / SETTERS
     * ==========================================================
     */

    public HttpSession getSession() {
        return session;
    }

    public void setSession(HttpSession session) {
        this.session = session;
    }


    public SessionMap<String, Object> getSessionMap() {
        return sessionMap;
    }

    public void setSessionMap(
            SessionMap<String, Object> sessionMap) {

        this.sessionMap = sessionMap;
    }


    @SuppressWarnings("unchecked")
    public void setSession(Map<String, Object> map) {

        sessionMap =
                (SessionMap<String, Object>) map;
    }


    public HttpServletRequest getRequest() {
        return request;
    }

    public void setRequest(
            HttpServletRequest request) {

        this.request = request;
    }


    public HttpServletResponse getResponse() {
        return response;
    }

    public void setResponse(
            HttpServletResponse response) {

        this.response = response;
    }


    public String getFromDate() {
        return fromDate;
    }

    public void setFromDate(String fromDate) {
        this.fromDate = fromDate;
    }


    public String getToDate() {
        return toDate;
    }

    public void setToDate(String toDate) {
        this.toDate = toDate;
    }


    public String getEmployeeName() {
        return employeeName;
    }

    public void setEmployeeName(String employeeName) {
        this.employeeName = employeeName;
    }


    public List<EmployeePresentDetailsDAO>
    getEmployeePresentDetailsDAOList() {

        return employeePresentDetailsDAOList;
    }


    public void setEmployeePresentDetailsDAOList(
            List<EmployeePresentDetailsDAO>
            employeePresentDetailsDAOList) {

        this.employeePresentDetailsDAOList =
                employeePresentDetailsDAOList;
    }

}
