package com.reallinkbilling.delete;



import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.DAO.WareHouseStockTransferProductDetailsDAO;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.utils.StockAdjustmentUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;

public class DeleteWarehouseStockTransferEntry
        extends ActionSupport
        implements SessionAware {

    private static final long serialVersionUID = 1L;

    private SessionMap<String, Object> sessionMap;

    private String fromDate;
    private String toDate;
    private String key;
    private String addSideBarJs;

    private List<WareHouseStockTransferProductDetailsDAO>
            warehouseStockTransferProductDAOList =
            new ArrayList<>();


    // ============================================================
    // EXECUTE
    // ============================================================

    @Override
    public String execute() {

        String result = "login";

        // --------------------------------------------------------
        // SESSION CHECK
        // --------------------------------------------------------

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

            addActionMessage("Please Logout and Login again!");

            return result;
        }


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

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

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

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


        // --------------------------------------------------------
        // DECRYPT ENTRY ID
        // --------------------------------------------------------

        String entryId;

        try {

            entryId =
                    EncryptionDecryption.decrypt(key);

        } catch (Exception e) {

            addActionError("Invalid Stock Transfer Key!");

            return ERROR;
        }


        // --------------------------------------------------------
        // SOURCE / DESTINATION GODOWN
        // --------------------------------------------------------

        String fromId = null;
        String toId = null;


        try (Connection conn =
                GetDBConnection.getDBConnection(db)) {


            // ----------------------------------------------------
            // TRANSACTION START
            // ----------------------------------------------------

            conn.setAutoCommit(false);


            // ====================================================
            // STEP 1:
            // FETCH STOCK TRANSFER MASTER
            // ====================================================

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


            try (PreparedStatement ps =
                    conn.prepareStatement(fetchInfo)) {


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


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


                    if (rs.next()) {

                        // ----------------------------------------
                        // FROM GODOWN
                        // ----------------------------------------

                        int fromGodownId =
                                rs.getInt("from_godown_id");

                        if (rs.wasNull()) {

                            fromId = "MAIN";

                        } else {

                            fromId =
                                    String.valueOf(fromGodownId);
                        }


                        // ----------------------------------------
                        // TO GODOWN
                        // ----------------------------------------

                        int toGodownId =
                                rs.getInt("to_godown_id");

                        if (rs.wasNull()) {

                            toId = "MAIN";

                        } else {

                            toId =
                                    String.valueOf(toGodownId);
                        }


                    } else {

                        addActionError(
                                "No such stock transfer entry found.");

                        conn.rollback();

                        return ERROR;
                    }
                }
            }


            // ====================================================
            // STEP 2:
            // GET PRODUCT DETAILS
            // ====================================================

            String fetchProducts =
                    "SELECT "
                    + "product_id, "
                    + "product_name, "
                    + "stock_transfer_quantity "
                    + "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 =
                    conn.prepareStatement(fetchProducts)) {


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


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


                    warehouseStockTransferProductDAOList =
                            new ArrayList<>();


                    while (rs.next()) {


                        WareHouseStockTransferProductDetailsDAO dao =
                                new WareHouseStockTransferProductDetailsDAO();


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


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


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


                        warehouseStockTransferProductDAOList
                                .add(dao);
                    }
                }
            }


            // ====================================================
            // STEP 2.1:
            // CHECK PRODUCT LIST
            // ====================================================

            if (warehouseStockTransferProductDAOList.isEmpty()) {

                addActionError(
                        "No product details found for this transfer entry.");

                conn.rollback();

                return ERROR;
            }


            // ====================================================
            // STEP 3:
            // ROLLBACK STOCK FROM DESTINATION GODOWN
            // ====================================================
            //
            // Transfer originally:
            //
            // FROM  -> quantity deducted
            // TO    -> quantity added
            //
            // Delete:
            //
            // TO    -> quantity deducted
            // FROM  -> quantity added
            //
            // ====================================================

            for (WareHouseStockTransferProductDetailsDAO dao :
                    warehouseStockTransferProductDAOList) {


                boolean rolledBack =
                        StockAdjustmentUtil.adjustStock(
                                conn,
                                sessionMap,
                                dao.getProductId(),
                                dao.getQuantity(),
                                false,
                                true,
                                toId);


                if (!rolledBack) {


                    System.err.println(
                            "Rollback failed for Product ID: "
                            + dao.getProductId()
                            + " at destination: "
                            + toId);


                    addActionError(
                            "Failed to rollback stock from destination "
                            + "location for product: "
                            + dao.getProductName());


                    conn.rollback();

                    return ERROR;
                }
            }


            // ====================================================
            // STEP 4:
            // RESTORE STOCK TO SOURCE GODOWN
            // ====================================================

            for (WareHouseStockTransferProductDetailsDAO dao :
                    warehouseStockTransferProductDAOList) {


                boolean restored =
                        StockAdjustmentUtil.adjustStock(
                                conn,
                                sessionMap,
                                dao.getProductId(),
                                dao.getQuantity(),
                                true,
                                true,
                                fromId);


                if (!restored) {


                    System.err.println(
                            "Restore failed for Product ID: "
                            + dao.getProductId()
                            + " at source: "
                            + fromId);


                    addActionError(
                            "Failed to restore stock to source "
                            + "location for product: "
                            + dao.getProductName());


                    conn.rollback();

                    return ERROR;
                }
            }


            // ====================================================
            // STEP 5:
            // DELETE PRODUCT DETAILS
            // ====================================================

            String deleteProducts =
                    "DELETE FROM "
                    + "shop_stock_transfer_product_details_master "
                    + "WHERE stock_transfer_entry_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            try (PreparedStatement ps =
                    conn.prepareStatement(deleteProducts)) {


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


                int deletedProducts =
                        ps.executeUpdate();


                System.out.println(
                        "Deleted product rows: "
                        + deletedProducts);
            }


            // ====================================================
            // STEP 6:
            // DELETE MASTER TRANSFER ENTRY
            // ====================================================

            String deleteMaster =
                    "DELETE FROM "
                    + "shop_stock_transfer_info_master "
                    + "WHERE stock_transfer_entry_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            try (PreparedStatement ps =
                    conn.prepareStatement(deleteMaster)) {


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


                int deletedMaster =
                        ps.executeUpdate();


                if (deletedMaster == 0) {

                    addActionError(
                            "Stock transfer entry could not be deleted.");

                    conn.rollback();

                    return ERROR;
                }
            }


            // ====================================================
            // STEP 7:
            // COMMIT
            // ====================================================

            conn.commit();


            addActionMessage(
                    "Entry deleted successfully!");


            result = SUCCESS;


        } catch (Exception e) {


            e.printStackTrace();


            addActionError(
                    "Error occurred: "
                    + e.getClass().getSimpleName()
                    + " → "
                    + e.getMessage());


            result = ERROR;
        }


        return result;
    }


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

    @Override
    public void setSession(Map<String, Object> map) {

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


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

    public SessionMap<String, Object> getSessionMap() {

        return sessionMap;
    }


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

        this.sessionMap = sessionMap;
    }


    public String getKey() {

        return key;
    }


    public void setKey(String key) {

        this.key = key;
    }


    public String getAddSideBarJs() {

        return addSideBarJs;
    }


    public void setAddSideBarJs(String addSideBarJs) {

        this.addSideBarJs = addSideBarJs;
    }


    public List<WareHouseStockTransferProductDetailsDAO>
            getWarehouseStockTransferProductDAOList() {

        return warehouseStockTransferProductDAOList;
    }


    public void setWarehouseStockTransferProductDAOList(
            List<WareHouseStockTransferProductDetailsDAO> list) {

        this.warehouseStockTransferProductDAOList = list;
    }


    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;
    }
}