package com.reallinkbilling.add;

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

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

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

public class AddProductToWarehouseStockTransferList extends ActionSupport implements SessionAware {

	private static final long serialVersionUID = 1814565303287246185L;

	private SessionMap<String, Object> sessionMap;

	private String addSideBarJs;

	private String productName;
	private String Date;
	private Float quantity;
	private String entryBy;

	private String fromType;
	private String toType;

	private boolean warehouseStockTransferEntrySaved;

	private String fromWarehouseName;
	private String toWarehouseName;
	
	private boolean fromUpdate = false;

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

	private WareHouseStockTransferInfoDAO warehouseStockTransferInfoDAO = null;

	private ArrayList<WareHouseStockTransferProductDetailsDAO> warehouseStockTransferProductDAOList = null;

	@Override
	public String execute() {

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

			addActionMessage("Please Logout and Login again !");
			return "login";
		}

		/*
		 * Load Godown List
		 */
		warehouseList.putAll(GetListResource.getGodownList(sessionMap));

		/*
		 * Add Main Godown
		 */
		warehouseList.put("Main", "Main");

		/*
		 * Initialize DAO
		 */
		if (warehouseStockTransferInfoDAO == null) {
			warehouseStockTransferInfoDAO = new WareHouseStockTransferInfoDAO();
		}
		
		// ADD THIS LINE HERE
		fromUpdate = "true".equalsIgnoreCase(
		        warehouseStockTransferInfoDAO.getFromUpdate()
		);

		/*
		 * Initialize Product List
		 */
		if (warehouseStockTransferProductDAOList == null) {
			warehouseStockTransferProductDAOList = new ArrayList<>();
		}

		/*
		 * Set Transfer Information
		 */
		warehouseStockTransferInfoDAO.setDate(this.getDate());
		warehouseStockTransferInfoDAO.setEntryBy(this.getEntryBy());

		/*
		 * Only Godown type is used in EasySBill.
		 */
		warehouseStockTransferInfoDAO.setFromType("Godown");
		warehouseStockTransferInfoDAO.setToType("Godown");

		/*
		 * Handle From Godown
		 *
		 * Main = ID 0
		 */
		if ("Main".equals(this.getFromWarehouseName())) {

			warehouseStockTransferInfoDAO.setFromWarehouseName("Main");
			warehouseStockTransferInfoDAO.setFromWarehouseid("0");

		} else {

			warehouseStockTransferInfoDAO.setFromWarehouseName(this.getFromWarehouseName());

			if (this.getFromWarehouseName() != null
					&& !this.getFromWarehouseName().trim().equals("")) {

				warehouseStockTransferInfoDAO.setFromWarehouseid(
						this.getFromWarehouseName().split("\\|")[0]
				);
			}
		}

		/*
		 * Handle To Godown
		 *
		 * Main = ID 0
		 */
		if ("Main".equals(this.getToWarehouseName())) {

			warehouseStockTransferInfoDAO.setToWarehouseName("Main");
			warehouseStockTransferInfoDAO.setToWarehouseid("0");

		} else {

			warehouseStockTransferInfoDAO.setToWarehouseName(this.getToWarehouseName());

			if (this.getToWarehouseName() != null
					&& !this.getToWarehouseName().trim().equals("")) {

				warehouseStockTransferInfoDAO.setToWarehouseid(
						this.getToWarehouseName().split("\\|")[0]
				);
			}
		}

		/*
		 * Get Product Details
		 */
		HashMap<String, String> productDetails =
				GetProductDetailsById.getProductDetails(
						this.getProductName().split("-")[0],
						this.sessionMap
				);

		/*
		 * Create Product DAO
		 */
		WareHouseStockTransferProductDetailsDAO productDAO =
				new WareHouseStockTransferProductDetailsDAO();

		productDAO.setProductId(
				this.getProductName().split("-")[0]
		);

		productDAO.setProductName(
				this.getProductName().split("-")[1]
		);

		productDAO.setProductAllDetails(
				this.getProductName()
		);

		productDAO.setQuantity(
				this.getQuantity()
		);

		productDAO.setProductUnit(
				productDetails.get("CONSUMPTIONUNIT")
		);

		/*
		 * Add Product to List
		 */
		warehouseStockTransferProductDAOList.add(productDAO);

		/*
		 * Store Transfer Information in Session
		 */
		sessionMap.put(
				"wareHouseStockTransferInfoDao",
				warehouseStockTransferInfoDAO
		);

		sessionMap.put(
				"wareHouseStockTransferProductDAOList",
				warehouseStockTransferProductDAOList
		);

		/*
		 * Clear Product Fields
		 */
		this.setProductName("");
		this.setQuantity(0.0F);

		this.setWarehouseStockTransferEntrySaved(false);

		warehouseStockTransferInfoDAO.setWarehouseStockTransferEntrySaved(false);

		return "success";
	}

	@Override
	@SuppressWarnings("unchecked")
	public void validate() {

		/*
		 * Load Godown List
		 */
		warehouseList.putAll(GetListResource.getGodownList(sessionMap));

		/*
		 * Add Main Godown
		 */
		warehouseList.put("Main", "Main");

		/*
		 * Get Transfer Information from Session
		 */
		warehouseStockTransferInfoDAO =
				(WareHouseStockTransferInfoDAO) sessionMap.get(
						"wareHouseStockTransferInfoDao"
				);

		/*
		 * Get Product List from Session
		 */
		warehouseStockTransferProductDAOList =
				(ArrayList<WareHouseStockTransferProductDetailsDAO>)
						sessionMap.get(
								"wareHouseStockTransferProductDAOList"
						);

		/*
		 * Initialize Product List if null
		 */
		if (warehouseStockTransferProductDAOList == null) {

			warehouseStockTransferProductDAOList =
					new ArrayList<>();

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

		/*
		 * Initialize Transfer DAO if null
		 */
		if (warehouseStockTransferInfoDAO == null) {

			warehouseStockTransferInfoDAO =
					new WareHouseStockTransferInfoDAO();

			sessionMap.put(
					"wareHouseStockTransferInfoDao",
					warehouseStockTransferInfoDAO
			);
		}

		/*
		 * Date Validation
		 */
		if (Date == null || Date.trim().isEmpty()) {

			addActionError("Please provide Date!");
		}

		/*
		 * From Type
		 *
		 * Only Godown is allowed.
		 */
		if (fromType == null || !fromType.equals("Godown")) {

			addActionError("Please provide From Type!");
		}

		/*
		 * To Type
		 *
		 * Only Godown is allowed.
		 */
		if (toType == null || !toType.equals("Godown")) {

			addActionError("Please provide To Type!");
		}

		/*
		 * From Godown Validation
		 */
		if (fromWarehouseName == null
				|| fromWarehouseName.trim().isEmpty()) {

			addActionError("Please provide From Godown!");
		}

		/*
		 * To Godown Validation
		 */
		if (toWarehouseName == null
				|| toWarehouseName.trim().isEmpty()) {

			addActionError("Please provide To Godown!");
		}

		/*
		 * Product Validation
		 */
		if (!hasActionErrors()) {

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

				addActionError(
						"Please provide product details!"
				);

			} else if (productName.split("-").length < 2) {

				addActionError(
						"Please provide correct product details!"
				);
			}
		}

		/*
		 * Quantity Validation
		 */
		if (!hasActionErrors()) {

			if (quantity == null || quantity <= 0) {

				addActionError(
						"Please provide valid quantity!"
				);
			}
		}

		/*
		 * Duplicate Product Validation
		 */
		if (!hasActionErrors()) {

			if (warehouseStockTransferProductDAOList != null) {

				for (WareHouseStockTransferProductDetailsDAO dao :
						warehouseStockTransferProductDAOList) {

					if (dao.getProductName().equals(
							this.productName.split("-")[1])) {

						addActionError(
								"Product already added to list!"
						);
					}
				}
			}
		}

		/*
		 * From and To Godown Validation
		 *
		 * Main is allowed in both From and To.
		 *
		 * But From and To cannot be the same.
		 */
		if (!hasActionErrors()) {

			if (fromWarehouseName.equals(toWarehouseName)) {

				addActionError(
						"From and To Godown cannot be same!"
				);
			}
		}

		/*
		 * Validate Stock Availability
		 */
		if (!hasActionErrors()) {

			validateStockAvailability();
		}
	}

	/**
	 * Validate stock available in selected From Godown.
	 *
	 * Main:
	 *     shop_product_master
	 *
	 * Godown:
	 *     warehouse_stock_master
	 */
	private void validateStockAvailability() {

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

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

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

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

		try {

			connection =
					GetDBConnection.getDBConnection(db);

			if (connection == null) {
				throw new SQLException("Database connection is null");
			}

			String productId =
					productName.split("-")[0];

			float availableStock = 0f;

			/*
			 * FROM MAIN
			 */
			if ("Main".equalsIgnoreCase(fromWarehouseName)) {

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

				preparedStatement =
						connection.prepareStatement(sql);

				preparedStatement.setString(
						1,
						productId
				);

				preparedStatement.setString(
						2,
						shopId
				);

				preparedStatement.setString(
						3,
						shopCode
				);
			}

			/*
			 * FROM GODOWN
			 */
			else {

				String fromWarehouseId =
						fromWarehouseName.split("\\|")[0];

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

				preparedStatement =
						connection.prepareStatement(sql);

				preparedStatement.setString(
						1,
						productId
				);

				preparedStatement.setString(
						2,
						fromWarehouseId
				);

				preparedStatement.setString(
						3,
						shopId
				);

				preparedStatement.setString(
						4,
						shopCode
				);
			}

			resultSet =
					preparedStatement.executeQuery();

			if (resultSet.next()) {

				availableStock =
						resultSet.getFloat(
								"in_stock_quantity"
						);

				if (quantity > availableStock) {

					addActionError(
							"Entered quantity exceeds available stock ("
							+ availableStock
							+ ")"
					);
				}

			} else {

				addActionError(
						"Product not found in stock for the selected source!"
				);
			}

		} catch (Exception e) {

			addActionError(
					"Stock validation error: "
					+ e.getMessage()
			);

		} finally {

			try {

				if (resultSet != null)
					resultSet.close();

				if (preparedStatement != null)
					preparedStatement.close();

				if (connection != null)
					connection.close();

			} catch (SQLException ignored) {
			}
		}
	}

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

	public String getAddSideBarJs() {

		return addSideBarJs;
	}

	public void setAddSideBarJs(
			String addSideBarJs) {

		this.addSideBarJs = addSideBarJs;
	}

	public String getProductName() {

		return productName;
	}

	public void setProductName(
			String productName) {

		this.productName = productName;
	}

	public String getDate() {

		return Date;
	}

	public void setDate(String date) {

		Date = date;
	}

	public Float getQuantity() {

		return quantity;
	}

	public void setQuantity(Float quantity) {

		this.quantity = quantity;
	}

	public String getEntryBy() {

		return entryBy;
	}

	public void setEntryBy(String entryBy) {

		this.entryBy = entryBy;
	}

	public String getFromType() {

		return fromType;
	}

	public void setFromType(String fromType) {

		this.fromType = fromType;
	}

	public String getToType() {

		return toType;
	}

	public void setToType(String toType) {

		this.toType = toType;
	}

	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 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 Map<String, String> getWarehouseList() {

		return warehouseList;
	}

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

		this.warehouseList = warehouseList;
	}

	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 static long getSerialversionuid() {

		return serialVersionUID;
	}
}

