package com.reallinkbilling.jspRedirect;



import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

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

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

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.DAO.WareHouseStockTransferInfoDAO;
import com.reallinkbilling.DAO.WareHouseStockTransferProductDetailsDAO;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.resource.GetListResource;
import com.reallinkbilling.utils.GetGodownDetailsById;

public class UpdateWarehouseStockTransferDetailsJsp extends ActionSupport
        implements SessionAware, ServletResponseAware, ServletRequestAware {

    private static final long serialVersionUID = -3983439408450302835L;

    private SessionMap<String, Object> sessionMap;

    private String fromDate;
    private String toDate;
    private String key;
    private String Date;

    private String fromWarehouseName;
    private String toWarehouseName;

    private String productName;
    private String quantity;
    private String productUnit;

    private boolean warehouseStockTransferEntrySaved;
    private boolean fromUpdate;

    private String addSideBarJs;

    private HttpServletRequest request;
    private HttpServletResponse response;

    private WareHouseStockTransferInfoDAO warehouseStockTransferInfoDAO;

    private ArrayList<WareHouseStockTransferProductDetailsDAO> warehouseStockTransferProductDAOList;

    private Map<String, String> warehouseList = new HashMap<>();


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

        // --------------------------------------------------------
        // LOAD GODOWN LIST
        // --------------------------------------------------------

        warehouseList.clear();

        warehouseList.putAll(GetListResource.getGodownList(sessionMap));

        // Main warehouse
        warehouseList.put("Main", "Main");


        // --------------------------------------------------------
        // 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 STOCK TRANSFER ENTRY ID
        // --------------------------------------------------------

        String stockTransferEntryId;

        try {

            stockTransferEntryId = EncryptionDecryption.decrypt(this.getKey());

        } catch (Exception e) {

            addActionError("Invalid Stock Transfer Key !");

            return "error";
        }


        // --------------------------------------------------------
        // DATABASE CONNECTION
        // --------------------------------------------------------

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


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

            String sql =
                    "SELECT "
                    + "stock_transfer_date, "
                    + "stock_transfer_time, "
                    + "from_godown_id, "
                    + "to_godown_id, "
                    + "vehicle_number, "
                    + "total_products, "
                    + "entry_by "
                    + "FROM shop_stock_transfer_info_master "
                    + "WHERE "
                    + "stock_transfer_date BETWEEN "
                    + "STR_TO_DATE(?,'%d-%m-%Y') "
                    + "AND STR_TO_DATE(?,'%d-%m-%Y') "
                    + "AND shop_id = ? "
                    + "AND shop_code = ? "
                    + "AND stock_transfer_entry_id = ?";


            try (PreparedStatement preparedStatement =
                    connection.prepareStatement(sql)) {


                preparedStatement.setString(1, fromDate);
                preparedStatement.setString(2, toDate);
                preparedStatement.setString(3, shopId);
                preparedStatement.setString(4, shopCode);
                preparedStatement.setString(5, stockTransferEntryId);


                try (ResultSet resultSet =
                        preparedStatement.executeQuery()) {


                    if (resultSet.next()) {


                        // ====================================================
                        // DATE
                        // ====================================================

                        SimpleDateFormat dateFormat =
                                new SimpleDateFormat("dd-MM-yyyy");

                        this.Date =
                                dateFormat.format(
                                        resultSet.getDate(
                                                "stock_transfer_date"));


                        // ====================================================
                        // GODOWN IDS
                        // ====================================================

                        String fromWarehouseId =
                                resultSet.getString("from_godown_id");

                        String toWarehouseId =
                                resultSet.getString("to_godown_id");


                        // ====================================================
                        // DEFAULT GODOWN NAME
                        // ====================================================

                        fromWarehouseName = "MAIN";

                        toWarehouseName = "MAIN";


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

                        if (fromWarehouseId != null
                                && !"0".equals(fromWarehouseId)
                                && !"".equals(fromWarehouseId)) {


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


                            if (godownDetails != null) {

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

                                if (godownName != null) {

                                    fromWarehouseName =
                                            fromWarehouseId
                                            + "|"
                                            + godownName;
                                }
                            }
                        }


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

                        if (toWarehouseId != null
                                && !"0".equals(toWarehouseId)
                                && !"".equals(toWarehouseId)) {


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


                            if (godownDetails != null) {

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

                                if (godownName != null) {

                                    toWarehouseName =
                                            toWarehouseId
                                            + "|"
                                            + godownName;
                                }
                            }
                        }


                        // ====================================================
                        // CREATE MASTER DAO
                        // ====================================================

                        warehouseStockTransferInfoDAO =
                                new WareHouseStockTransferInfoDAO();


                        warehouseStockTransferInfoDAO
                                .setTransferEntryId(
                                        stockTransferEntryId);


                        warehouseStockTransferInfoDAO
                                .setDate(Date);


                        warehouseStockTransferInfoDAO
                                .setFromWarehouseid(
                                        fromWarehouseId);


                        warehouseStockTransferInfoDAO
                                .setToWarehouseid(
                                        toWarehouseId);


                        warehouseStockTransferInfoDAO
                                .setFromWarehouseName(
                                        fromWarehouseName);


                        warehouseStockTransferInfoDAO
                                .setToWarehouseName(
                                        toWarehouseName);


                        // ====================================================
                        // LOAD PRODUCT DETAILS
                        // ====================================================

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


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


                            psProduct.setString(1, shopId);
                            psProduct.setString(2, shopCode);
                            psProduct.setString(3, stockTransferEntryId);


                            try (ResultSet rsProduct =
                                    psProduct.executeQuery()) {


                                warehouseStockTransferProductDAOList =
                                        new ArrayList<>();


                                while (rsProduct.next()) {


                                    WareHouseStockTransferProductDetailsDAO dao =
                                            new WareHouseStockTransferProductDetailsDAO();


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


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


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


                                    dao.setProductUnit(
                                            rsProduct.getString(
                                                    "stock_transfer_unit"));


                                    warehouseStockTransferProductDAOList
                                            .add(dao);
                                }
                            }
                        }


                        // ====================================================
                        // SET UPDATE FLAGS
                        // ====================================================

                        warehouseStockTransferEntrySaved = true;

                        fromUpdate = true;


//                        warehouseStockTransferInfoDAO
//                                .setWarehouseStockTransferEntrySaved(
//                                        true);


                        warehouseStockTransferInfoDAO
                                .setFromUpdate("true");


                        // ====================================================
                        // STORE DATA IN SESSION
                        // ====================================================

                        sessionMap.put(
                                "wareHouseStockTransferInfoDao",
                                warehouseStockTransferInfoDAO);


                        sessionMap.put(
                                "wareHouseStockTransferProductDAOList",
                                warehouseStockTransferProductDAOList);
                    }
                }
            }


            result = SUCCESS;


        } catch (Exception e) {

            e.printStackTrace();

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

            result = "error";
        }


        return result;
    }


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

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

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


    // ============================================================
    // SERVLET REQUEST
    // ============================================================

    @Override
    public void setServletRequest(HttpServletRequest request) {

        this.request = request;
    }


    // ============================================================
    // SERVLET RESPONSE
    // ============================================================

    @Override
    public void setServletResponse(HttpServletResponse response) {

        this.response = response;
    }


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

    public SessionMap<String, Object> getSessionMap() {

        return sessionMap;
    }


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

        this.sessionMap = sessionMap;
    }


    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 getKey() {

        return key;
    }


    public void setKey(String key) {

        this.key = key;
    }


    public String getDate() {

        return Date;
    }


    public void setDate(String date) {

        Date = date;
    }


    public String getFromWarehouseName() {

        return fromWarehouseName;
    }


    public void setFromWarehouseName(
            String fromWarehouseName) {

        this.fromWarehouseName = fromWarehouseName;
    }


    public String getToWarehouseName() {

        return toWarehouseName;
    }


    public void setToWarehouseName(
            String toWarehouseName) {

        this.toWarehouseName = toWarehouseName;
    }


    public String getProductName() {

        return productName;
    }


    public void setProductName(String productName) {

        this.productName = productName;
    }


    public String getQuantity() {

        return quantity;
    }


    public void setQuantity(String quantity) {

        this.quantity = quantity;
    }


    public String getProductUnit() {

        return productUnit;
    }


    public void setProductUnit(String productUnit) {

        this.productUnit = productUnit;
    }


   

    public boolean isWarehouseStockTransferEntrySaved() {
		return warehouseStockTransferEntrySaved;
	}


	public void setWarehouseStockTransferEntrySaved(boolean warehouseStockTransferEntrySaved) {
		this.warehouseStockTransferEntrySaved = warehouseStockTransferEntrySaved;
	}


	public boolean isFromUpdate() {

        return fromUpdate;
    }


    public void setFromUpdate(boolean fromUpdate) {

        this.fromUpdate = fromUpdate;
    }


    public String getAddSideBarJs() {

        return addSideBarJs;
    }


    public void setAddSideBarJs(String addSideBarJs) {

        this.addSideBarJs = addSideBarJs;
    }


    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 WareHouseStockTransferInfoDAO
            getWarehouseStockTransferInfoDAO() {

        return warehouseStockTransferInfoDAO;
    }


    public void setWarehouseStockTransferInfoDAO(
            WareHouseStockTransferInfoDAO
                    warehouseStockTransferInfoDAO) {

        this.warehouseStockTransferInfoDAO =
                warehouseStockTransferInfoDAO;
    }


    public ArrayList<WareHouseStockTransferProductDetailsDAO>
            getWarehouseStockTransferProductDAOList() {

        return warehouseStockTransferProductDAOList;
    }


    public void setWarehouseStockTransferProductDAOList(
            ArrayList<WareHouseStockTransferProductDetailsDAO>
                    warehouseStockTransferProductDAOList) {

        this.warehouseStockTransferProductDAOList =
                warehouseStockTransferProductDAOList;
    }


    public Map<String, String> getWarehouseList() {

        return warehouseList;
    }


    public void setWarehouseList(
            Map<String, String> warehouseList) {

        this.warehouseList = warehouseList;
    }


    public static long getSerialversionuid() {

        return serialVersionUID;
    }
}