package com.reallinkbilling.print;



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

import java.awt.Color;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

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

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.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.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.utils.GetGodownDetailsById;

public class PrintWarehouseStockTransfer extends ActionSupport
        implements SessionAware {

    private static final long serialVersionUID = 1L;

    private SessionMap<String, Object> sessionMap;

    private String key;

    private HttpServletRequest request;
    private HttpServletResponse response;

    private String transferEntryId;

    private String transferDate;
    private String transferTime;

    private String fromWarehouseName;
    private String toWarehouseName;

    private String companyName;
    private String companyAddress;

    private List<StockTransferProduct> productList =
            new ArrayList<>();

    // ============================================================
    // PROFESSIONAL PDF STYLING
    // ============================================================

    private static final Color HEADER_BG =
            new Color(248, 249, 250);

    private static final Color BORDER_COLOR =
            new Color(169, 169, 169);

    private static final Color ACCENT_LINE =
            new Color(108, 117, 125);

    private static final float PADDING_30 = 30f;

    private static final int TITLE_FONT_SIZE = 18;
    private static final int SUBTITLE_FONT_SIZE = 14;
    private static final int HEADER_FONT_SIZE = 11;
    private static final int BODY_FONT_SIZE = 10;
    private static final int SMALL_FONT_SIZE = 8;


    // ============================================================
    // PRINT STOCK TRANSFER
    // ============================================================

    public String printStockTransfer() {
    	
    	//System.out.println("in printstocktransfer class");

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

        if (sessionMap == null ||
                sessionMap.get("login") == null) {

            addActionError("Please Login First !!!");
            return ERROR;
        }

        try {

            // ----------------------------------------------------
            // GET SESSION DETAILS
            // ----------------------------------------------------

            String shopId =
                    String.valueOf(sessionMap.get("shopId"));

            String shopCode =
                    String.valueOf(sessionMap.get("shopCode"));

            String db =
                    String.valueOf(sessionMap.get("db"));

            companyName =
                    String.valueOf(
                            sessionMap.get("shopnameenglish"));

            if (companyName == null ||
                    companyName.equals("null") ||
                    companyName.trim().isEmpty()) {

                companyName = "REAL LINK";
            }

            companyAddress =
                    String.valueOf(
                            sessionMap.get("shopaddresseng"));

            if (companyAddress == null ||
                    companyAddress.equals("null")) {

                companyAddress = "";
            }


            // ----------------------------------------------------
            // DECRYPT STOCK TRANSFER ENTRY ID
            // ----------------------------------------------------

            if (key == null ||
                    key.trim().isEmpty()) {

                addActionError(
                        "Invalid Stock Transfer Key !");

                return ERROR;
            }

            transferEntryId =
                    EncryptionDecryption.decrypt(key);


            if (transferEntryId == null ||
                    transferEntryId.trim().isEmpty()) {

                addActionError(
                        "Invalid Stock Transfer Key !");

                return ERROR;
            }


            // ----------------------------------------------------
            // LOAD DATA
            // ----------------------------------------------------

            loadStockTransferDetails(
                    db,
                    shopId,
                    shopCode
            );


            if (productList.isEmpty()) {

                addActionError(
                        "No Stock Transfer Details Found!");

                return ERROR;
            }


            // ----------------------------------------------------
            // GENERATE PDF
            // ----------------------------------------------------

            generatePDF();


            return NONE;

        } catch (Exception e) {

            e.printStackTrace();

            try {

                if (!response.isCommitted()) {

                    addActionError(
                            "Error while printing Stock Transfer: "
                            + e.getMessage());

                    return ERROR;
                }

            } catch (Exception ignored) {
            }

            return ERROR;
        }
    }


    // ============================================================
    // LOAD STOCK TRANSFER DETAILS
    // ============================================================

    private void loadStockTransferDetails(
            String db,
            String shopId,
            String shopCode) throws Exception {


        try (Connection connection =
                     GetDBConnection.getDBConnection(db)) {
        	//System.out.println("in try block before connection");

            // ====================================================
            // MASTER
            // ====================================================

            String masterSql =
                    "SELECT "
                    + "stock_transfer_date, "
                    + "stock_transfer_time, "
                    + "from_godown_id, "
                    + "to_godown_id "
                    + "FROM shop_stock_transfer_info_master "
                    + "WHERE stock_transfer_entry_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            String fromGodownId = null;
            String toGodownId = null;


            try (PreparedStatement ps =
                         connection.prepareStatement(masterSql)) {


                ps.setString(1, transferEntryId);
                ps.setString(2, shopId);
                ps.setString(3, shopCode);


                try (ResultSet rs =
                             ps.executeQuery()) {


                    if (!rs.next()) {

                        throw new Exception(
                                "Stock Transfer Entry not found!");
                    }


                    // ------------------------------------------------
                    // DATE
                    // ------------------------------------------------

                    Date date =
                            rs.getDate(
                                    "stock_transfer_date");

                    if (date != null) {

                        transferDate =
                                new SimpleDateFormat(
                                        "dd-MM-yyyy")
                                        .format(date);

                    } else {

                        transferDate = "";
                    }


                    // ------------------------------------------------
                    // TIME
                    // ------------------------------------------------

                    Object timeObject =
                            rs.getObject(
                                    "stock_transfer_time");

                    if (timeObject != null) {

                        transferTime =
                                String.valueOf(
                                        timeObject);

                    } else {

                        transferTime = "";
                    }


                    fromGodownId =
                            rs.getString(
                                    "from_godown_id");

                    toGodownId =
                            rs.getString(
                                    "to_godown_id");
                }
            }


            // ====================================================
            // FROM GODOWN
            // ====================================================

            fromWarehouseName =
                    getGodownName(
                            fromGodownId,
                            connection);


            // ====================================================
            // TO GODOWN
            // ====================================================

            toWarehouseName =
                    getGodownName(
                            toGodownId,
                            connection);
          //  System.out.println("after 1st query run");

            // ====================================================
            // PRODUCTS
            // ====================================================

            String productSql =
                    "SELECT "
                    + "product_id, "
                    + "product_name, "
                    + "stock_transfer_quantity, "
                    + "stock_transfer_unit "
                    + "FROM shop_stock_transfer_product_details_master "
                    + "WHERE stock_transfer_entry_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ? "
                    + "ORDER BY entry_id";


            try (PreparedStatement ps =
                         connection.prepareStatement(productSql)) {


                ps.setString(1, transferEntryId);
                ps.setString(2, shopId);
                ps.setString(3, shopCode);


                try (ResultSet rs =
                             ps.executeQuery()) {


                    productList.clear();


                    while (rs.next()) {

                        StockTransferProduct product =
                                new StockTransferProduct();


                        product.setProductId(
                                rs.getString(
                                        "product_id"));


                        product.setProductName(
                                rs.getString(
                                        "product_name"));


                        product.setQuantity(
                                rs.getFloat(
                                        "stock_transfer_quantity"));


                        product.setUnit(
                                rs.getString(
                                        "stock_transfer_unit"));


                        productList.add(product);
                    }
                }
            }
        }
    }


    // ============================================================
    // GET GODOWN NAME
    // ============================================================

    private String getGodownName(
            String godownId,
            Connection connection) throws Exception {


        if (godownId == null ||
                godownId.trim().isEmpty() ||
                "0".equals(godownId)) {

            return "MAIN";
        }


        Map<String, String> godownDetails =
                GetGodownDetailsById.getGodownDetails(
                        godownId,
                        sessionMap,
                        connection);


        if (godownDetails != null) {

            String name =
                    godownDetails.get(
                            "GODOWNNAME");

            if (name != null &&
                    !name.trim().isEmpty()) {

                return name;
            }
        }


        return godownId;
    }


    // ============================================================
    // GENERATE PDF
    // ============================================================

    private void generatePDF() throws Exception {

        PDDocument document =
                new PDDocument();


        PDPage page =
                new PDPage(PDRectangle.A4);


        document.addPage(page);


        PDPageContentStream contentStream =
                new PDPageContentStream(
                        document,
                        page);


        createProfessionalHeader(
                contentStream,
                page);


        createProductTable(
                document,
                contentStream,
                page);


        contentStream.close();


        // ========================================================
        // RESPONSE
        // ========================================================

        String fileName =
                "Stock-Transfer-"
                + transferEntryId
                + "-"
                + transferDate
                + ".pdf";


        response.reset();


        response.setContentType(
                "application/pdf");


        response.setHeader(
                "Content-Disposition",
                "inline; filename=\"" + fileName + "\"");


        response.setHeader(
                "Cache-Control",
                "no-cache, no-store, must-revalidate");


        response.setHeader(
                "Pragma",
                "no-cache");


        response.setDateHeader(
                "Expires",
                0);


        try (OutputStream outputStream =
                     response.getOutputStream()) {

            document.save(outputStream);

            outputStream.flush();
        }


        document.close();
    }


    // ============================================================
    // HEADER
    // ============================================================

    private void createProfessionalHeader(
            PDPageContentStream contentStream,
            PDPage page) throws Exception {


        float pageWidth =
                page.getMediaBox().getWidth();


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


        float tableWidth =
                pageWidth - (2 * PADDING_30);


        // ========================================================
        // COMPANY NAME
        // ========================================================

        Row companyNameRow =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text(
                        companyName
                        .toUpperCase())
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(BLACK)
                .font(HELVETICA_BOLD)
                .fontSize(TITLE_FONT_SIZE)
                .build();


        // ========================================================
        // ADDRESS
        // ========================================================

        Row addressRow =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text(companyAddress)
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(BLACK)
                .font(HELVETICA_OBLIQUE)
                .fontSize(BODY_FONT_SIZE)
                .build();


        // ========================================================
        // SEPARATOR
        // ========================================================

//        Row separatorRow =
//                Row.builder()
//                .add(
//                    TextCell.builder()
//                    .text(
//                        "------------------------------------------------------------")
//                    .horizontalAlignment(CENTER)
//                    .borderWidth(0)
//                    .build()
//                )
//                .backgroundColor(WHITE)
//                .textColor(ACCENT_LINE)
//                .font(HELVETICA)
//                .fontSize(SMALL_FONT_SIZE)
//                .build();


        // ========================================================
        // REPORT NAME
        // ========================================================

        Row reportTitleRow =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text("STOCK TRANSFER PRINT")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(BLACK)
                .font(HELVETICA_BOLD)
                .fontSize(SUBTITLE_FONT_SIZE)
                .build();


        // ========================================================
        // DATE / TIME / FROM / TO
        // ========================================================

        String reportDetails =
                "Date: " + transferDate
                + "  |  Time: " + transferTime;


        Row reportDetailsRow =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text(reportDetails)
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(BLACK)
                .font(HELVETICA)
                .fontSize(BODY_FONT_SIZE)
                .build();

     // FROM GODOWN / TO GODOWN ROW
        String warehouseDetails =
                "From Godown: " + fromWarehouseName
                + "     |     To Godown: " + toWarehouseName;

        Row warehouseDetailsRow =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text(warehouseDetails)
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(BLACK)
                .font(HELVETICA)
                .fontSize(BODY_FONT_SIZE)
                .build();

        // ========================================================
        // FINAL SEPARATOR
        // ========================================================

        Row separatorRow2 =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text(
                        "------------------------------------------------------------")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(ACCENT_LINE)
                .font(HELVETICA)
                .fontSize(SMALL_FONT_SIZE)
                .build();


        Table header =
                Table.builder()
                .addColumnsOfWidth(tableWidth)
                .font(HELVETICA)
                .borderWidth(0)
                .addRow(companyNameRow)
                .addRow(addressRow)
                //.addRow(separatorRow)
                .addRow(reportTitleRow)
                .addRow(reportDetailsRow)
                .addRow(warehouseDetailsRow)
                .addRow(separatorRow2)
                .build();


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


    // ============================================================
    // PRODUCT TABLE
    // ============================================================

    private void createProductTable(
            PDDocument document,
            PDPageContentStream contentStream,
            PDPage page) throws Exception {


        float pageWidth =
                page.getMediaBox().getWidth();


        float tableStartY =
                page.getMediaBox().getHeight()
                - PADDING_30
                - 125;


        float currentY =
                tableStartY;


        // ========================================================
        // TABLE COLUMNS
        // Sr No | Product Name | Quantity | Signature
        // ========================================================

        TableBuilder tableBuilder =
                Table.builder()
                .addColumnsOfWidth(
                        55,
                        pageWidth
                        - (2 * PADDING_30)
                        - 55
                        - 110
                        - 100,
                        110,
                        100)
                .font(HELVETICA)
                .borderWidth(0.5f)
                .borderColor(BORDER_COLOR)
                .horizontalAlignment(LEFT);


        // ========================================================
        // HEADER
        // ========================================================

        Row tableHeader =
                Row.builder()

                .add(
                    TextCell.builder()
                    .text("Sr. No.")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5f)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Product Name")
                    .horizontalAlignment(LEFT)
                    .borderWidth(0.5f)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Quantity")
                    .horizontalAlignment(RIGHT)
                    .borderWidth(0.5f)
                    .build()
                )

                .add(
                    TextCell.builder()
                    .text("Signature")
                    .horizontalAlignment(CENTER)
                    .borderWidth(0.5f)
                    .build()
                )

                .backgroundColor(HEADER_BG)
                .textColor(BLACK)
                .font(HELVETICA_BOLD)
                .fontSize(HEADER_FONT_SIZE)
                .build();


        tableBuilder.addRow(tableHeader);


        int srNo = 1;

        float totalQuantity = 0f;


        // ========================================================
        // PRODUCT ROWS
        // ========================================================

        for (StockTransferProduct product :
                productList) {


            float rowHeight =
                    estimateRowHeight(product);


            // ----------------------------------------------------
            // PAGE BREAK
            // ----------------------------------------------------

            if (currentY - rowHeight < 55) {

                Table currentTable =
                        tableBuilder.build();


                TableDrawer.builder()
                        .contentStream(contentStream)
                        .table(currentTable)
                        .startX(PADDING_30)
                        .startY(tableStartY)
                        .build()
                        .draw();


                contentStream.close();


                PDPage newPage =
                        new PDPage(PDRectangle.A4);


                document.addPage(newPage);


                contentStream =
                        new PDPageContentStream(
                                document,
                                newPage);


                createProfessionalHeader(
                        contentStream,
                        newPage);


                tableBuilder =
                        Table.builder()
                        .addColumnsOfWidth(
                                55,
                                pageWidth
                                - (2 * PADDING_30)
                                - 55
                                - 110
                                - 100,
                                110,
                                100)
                        .font(HELVETICA)
                        .borderWidth(0.5f)
                        .borderColor(BORDER_COLOR)
                        .horizontalAlignment(LEFT);


                tableBuilder.addRow(tableHeader);


                tableStartY =
                        newPage.getMediaBox().getHeight()
                        - PADDING_30
                        - 125;


                currentY =
                        tableStartY;
            }


            // ----------------------------------------------------
            // ALTERNATING ROW
            // ----------------------------------------------------

            Color rowBG =
                    (srNo % 2 == 0)
                    ? new Color(250, 250, 250)
                    : WHITE;


            String quantityText =
                    formatQuantity(
                            product.getQuantity());


            Row dataRow =
                    Row.builder()

                    .add(
                        TextCell.builder()
                        .text(
                            String.valueOf(srNo))
                        .horizontalAlignment(CENTER)
                        .borderWidth(0.5f)
                        .build()
                    )

                    .add(
                        TextCell.builder()
                        .text(
                            product.getProductName())
                        .horizontalAlignment(LEFT)
                        .borderWidth(0.5f)
                        .build()
                    )

                    .add(
                        TextCell.builder()
                        .text(quantityText)
                        .horizontalAlignment(RIGHT)
                        .borderWidth(0.5f)
                        .build()
                    )

                    .add(
                        TextCell.builder()
                        .text("")
                        .horizontalAlignment(CENTER)
                        .borderWidth(0.5f)
                        .build()
                    )

                    .backgroundColor(rowBG)
                    .textColor(BLACK)
                    .font(HELVETICA)
                    .fontSize(BODY_FONT_SIZE)
                    .build();


            tableBuilder.addRow(dataRow);


            currentY -= rowHeight;

            totalQuantity +=
                    product.getQuantity();

            srNo++;
        }


//        // ========================================================
//        // TOTAL
//        // ========================================================
//
//        Row totalRow =
//                Row.builder()
//
//                .add(
//                    TextCell.builder()
//                    .text("")
//                    .horizontalAlignment(CENTER)
//                    .borderWidth(0.5f)
//                    .build()
//                )
//
//                .add(
//                    TextCell.builder()
//                    .text("TOTAL")
//                    .horizontalAlignment(RIGHT)
//                    .borderWidth(0.5f)
//                    .build()
//                )
//
//                .add(
//                    TextCell.builder()
//                    .text(
//                        formatQuantity(
//                            totalQuantity))
//                    .horizontalAlignment(RIGHT)
//                    .borderWidth(0.5f)
//                    .build()
//                )
//
//                .add(
//                    TextCell.builder()
//                    .text("")
//                    .horizontalAlignment(CENTER)
//                    .borderWidth(0.5f)
//                    .build()
//                )
//
//                .backgroundColor(HEADER_BG)
//                .textColor(BLACK)
//                .font(HELVETICA_BOLD)
//                .fontSize(HEADER_FONT_SIZE)
//                .build();
//
//
//        tableBuilder.addRow(totalRow);


        // ========================================================
        // DRAW FINAL TABLE
        // ========================================================

        Table finalTable =
                tableBuilder.build();


        TableDrawer.builder()
                .contentStream(contentStream)
                .table(finalTable)
                .startX(PADDING_30)
                .startY(tableStartY)
                .build()
                .draw();


        // ========================================================
        // FOOTER
        // ========================================================

        addFooter(
                contentStream,
                page,
                srNo - 1,
                totalQuantity);
    }


    // ============================================================
    // FOOTER
    // ============================================================

    private void addFooter(
            PDPageContentStream contentStream,
            PDPage page,
            int totalProducts,
            float totalQuantity) throws Exception {


        float pageWidth =
                page.getMediaBox().getWidth();


        String summaryText =
                "Total Products: "
                + totalProducts
                + "  |  Total Quantity: "
                + formatQuantity(totalQuantity)
                + "  |  Generated: "
                + new SimpleDateFormat(
                        "dd-MM-yyyy HH:mm")
                        .format(new Date());


        Row summaryRow =
                Row.builder()
                .add(
                    TextCell.builder()
                    .text(summaryText)
                    .horizontalAlignment(CENTER)
                    .borderWidth(0)
                    .build()
                )
                .backgroundColor(WHITE)
                .textColor(BLACK)
                .font(HELVETICA_OBLIQUE)
                .fontSize(SMALL_FONT_SIZE)
                .build();


        Table footerTable =
                Table.builder()
                .addColumnsOfWidth(
                        pageWidth
                        - (2 * PADDING_30))
                .font(HELVETICA)
                .borderWidth(0)
                .addRow(summaryRow)
                .build();


        TableDrawer.builder()
                .contentStream(contentStream)
                .table(footerTable)
                .startX(PADDING_30)
                .startY(PADDING_30)
                .build()
                .draw();
    }


    // ============================================================
    // QUANTITY FORMAT
    // ============================================================

    private String formatQuantity(float quantity) {

        if (quantity == (long) quantity) {

            return String.format(
                    "%,d",
                    (long) quantity);
        }

        return String.format(
                "%,.2f",
                quantity);
    }


    // ============================================================
    // ROW HEIGHT
    // ============================================================

    private float estimateRowHeight(
            StockTransferProduct product) {


        String productName =
                product == null ||
                product.getProductName() == null
                ? ""
                : product.getProductName()
                        .replaceAll("\\s+", " ")
                        .trim();


        int lines =
                Math.max(
                        1,
                        (int) Math.ceil(
                                productName.length()
                                / 40.0));


        return Math.max(
                20f,
                lines * 11f);
    }


    // ============================================================
    // SESSION
    // ============================================================

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

        this.sessionMap =
                (SessionMap<String, Object>) session;
    }


    public SessionMap<String, Object>
            getSessionMap() {

        return sessionMap;
    }


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

        this.sessionMap = sessionMap;
    }


    // ============================================================
    // KEY
    // ============================================================

    public String getKey() {

        return key;
    }


    public void setKey(String key) {

        this.key = key;
    }


    // ============================================================
    // INNER PRODUCT DAO
    // ============================================================

    private static class StockTransferProduct {

        private String productId;

        private String productName;

        private float quantity;

        private String unit;


        public String getProductId() {

            return productId;
        }


        public void setProductId(
                String productId) {

            this.productId = productId;
        }


        public String getProductName() {

            return productName;
        }


        public void setProductName(
                String productName) {

            this.productName = productName;
        }


        public float getQuantity() {

            return quantity;
        }


        public void setQuantity(
                float quantity) {

            this.quantity = quantity;
        }


        public String getUnit() {

            return unit;
        }


        public void setUnit(String unit) {

            this.unit = unit;
        }
    }
}