package com.reallinkbilling.utils;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import org.apache.struts2.dispatcher.SessionMap;

public class StockAdjustmentUtil {

    // ============================================================
    // ADJUST STOCK
    // ============================================================

    public static boolean adjustStock(
            Connection conn,
            SessionMap<String, Object> session,
            String productId,
            float qty,
            boolean add,
            Boolean isWarehouse,
            String locationId) throws Exception {


        // --------------------------------------------------------
        // VALIDATION
        // --------------------------------------------------------

        if (session == null) {
            throw new IllegalArgumentException(
                    "Session cannot be null.");
        }

        if (isWarehouse == null) {
            throw new IllegalArgumentException(
                    "isWarehouse cannot be null.");
        }

        if (productId == null || productId.trim().isEmpty()) {
            throw new IllegalArgumentException(
                    "Product ID cannot be empty.");
        }

        if (locationId == null || locationId.trim().isEmpty()) {
            throw new IllegalArgumentException(
                    "Location ID cannot be empty.");
        }


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

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

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


        // ========================================================
        // MAIN STOCK
        // ========================================================
        //
        // MAIN stock is stored in:
        //
        // shop_product_master
        //
        // Column:
        //
        // in_stock_quantity
        //
        // ========================================================

        if ("MAIN".equalsIgnoreCase(locationId)) {


            String selectSql =
                    "SELECT in_stock_quantity "
                    + "FROM shop_product_master "
                    + "WHERE product_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            String updateSql =
                    "UPDATE shop_product_master "
                    + "SET in_stock_quantity = ? "
                    + "WHERE product_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            // ----------------------------------------------------
            // GET CURRENT MAIN STOCK
            // ----------------------------------------------------

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


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


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


                    if (rs.next()) {


                        float current =
                                rs.getFloat("in_stock_quantity");


                        float newQty;


                        if (add) {

                            // Add stock
                            newQty = current + qty;

                        } else {

                            // Deduct stock
                            newQty = current - qty;
                        }


                        // ------------------------------------------------
                        // DO NOT ALLOW NEGATIVE STOCK
                        // ------------------------------------------------

                        if (newQty < 0) {

                            System.err.println(
                                    "Error: Negative stock in MAIN "
                                    + "stock for product "
                                    + productId
                                    + ". Current Stock: "
                                    + current
                                    + ", Quantity: "
                                    + qty);

                            return false;
                        }


                        // ------------------------------------------------
                        // UPDATE MAIN STOCK
                        // ------------------------------------------------

                        try (PreparedStatement updatePs =
                                conn.prepareStatement(updateSql)) {


                            updatePs.setFloat(1, newQty);
                            updatePs.setString(2, productId);
                            updatePs.setString(3, shopId);
                            updatePs.setString(4, shopCode);


                            int rowsUpdated =
                                    updatePs.executeUpdate();


                            if (rowsUpdated > 0) {

                                return true;
                            }


                            System.err.println(
                                    "MAIN stock update failed for "
                                    + "product "
                                    + productId);


                            return false;
                        }
                    }


                    // ------------------------------------------------
                    // PRODUCT NOT FOUND
                    // ------------------------------------------------

                    System.err.println(
                            "No stock entry found in "
                            + "shop_product_master for product "
                            + productId
                            + ", shopId="
                            + shopId
                            + ", shopCode="
                            + shopCode);
                }
            }


        } else {


            // ========================================================
            // GODOWN / WAREHOUSE STOCK
            // ========================================================
            //
            // EasySBill has only:
            //
            // warehouse_stock_master
            //
            // There is no subsite_stock_master.
            //
            // locationId = warehouse/godown ID
            //
            // ========================================================


            if (!isWarehouse) {

                throw new IllegalArgumentException(
                        "EasySBill supports only MAIN or "
                        + "Godown/Warehouse stock.");
            }


            String selectSql =
                    "SELECT in_stock_quantity "
                    + "FROM warehouse_stock_master "
                    + "WHERE product_id = ? "
                    + "AND warehouse_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            String updateSql =
                    "UPDATE warehouse_stock_master "
                    + "SET in_stock_quantity = ? "
                    + "WHERE product_id = ? "
                    + "AND warehouse_id = ? "
                    + "AND shop_id = ? "
                    + "AND shop_code = ?";


            // ----------------------------------------------------
            // GET CURRENT GODOWN STOCK
            // ----------------------------------------------------

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


                ps.setString(1, productId);
                ps.setString(2, locationId);
                ps.setString(3, shopId);
                ps.setString(4, shopCode);


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


                    if (rs.next()) {


                        float current =
                                rs.getFloat("in_stock_quantity");


                        float newQty;


                        if (add) {

                            // Add stock
                            newQty = current + qty;

                        } else {

                            // Deduct stock
                            newQty = current - qty;
                        }


                        // ------------------------------------------------
                        // DO NOT ALLOW NEGATIVE STOCK
                        // ------------------------------------------------

                        if (newQty < 0) {

                            System.err.println(
                                    "Error: Negative stock in "
                                    + "warehouse_stock_master "
                                    + "for product "
                                    + productId
                                    + " at warehouse "
                                    + locationId
                                    + ". Current Stock: "
                                    + current
                                    + ", Quantity: "
                                    + qty);

                            return false;
                        }


                        // ------------------------------------------------
                        // UPDATE GODOWN STOCK
                        // ------------------------------------------------

                        try (PreparedStatement updatePs =
                                conn.prepareStatement(updateSql)) {


                            updatePs.setFloat(1, newQty);
                            updatePs.setString(2, productId);
                            updatePs.setString(3, locationId);
                            updatePs.setString(4, shopId);
                            updatePs.setString(5, shopCode);


                            int rowsUpdated =
                                    updatePs.executeUpdate();


                            if (rowsUpdated > 0) {

                                return true;
                            }


                            System.err.println(
                                    "Warehouse stock update failed "
                                    + "for product "
                                    + productId
                                    + " at warehouse "
                                    + locationId);


                            return false;
                        }
                    }


                    // ------------------------------------------------
                    // STOCK ENTRY NOT FOUND
                    // ------------------------------------------------

                    System.err.println(
                            "No stock entry found in "
                            + "warehouse_stock_master for product "
                            + productId
                            + " at warehouse "
                            + locationId
                            + ", shopId="
                            + shopId
                            + ", shopCode="
                            + shopCode);
                }
            }
        }


        return false;
    }
}