package com.reallinkbilling.report;

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;

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

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.DAO.stockTransferListInfoDAO;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.utils.GetGodownDetailsById;

public class GetWarhouseStcokTransferList extends ActionSupport implements SessionAware {

	private static final long serialVersionUID = -2281387022437058589L;

	private SessionMap<String, Object> sessionMap;

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

	private String addSideBarJs;

	private ArrayList<stockTransferListInfoDAO> stockTransferInfoDAOList =
			new ArrayList<>();

	public String execute() {

		String result = "login";

		/*
		 * ============================================================
		 * CHECK LOGIN SESSION
		 * ============================================================
		 */
		if (sessionMap == null || sessionMap.get("login") == null) {

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

			return "login";
		}

		addSideBarJs = "FALSE";

		/*
		 * ============================================================
		 * EASY SBILL SESSION VALUES
		 * ============================================================
		 */
		String shopId = (String) sessionMap.get("shopId");
		String shopCode = (String) sessionMap.get("shopCode");
		String db = (String) sessionMap.get("db");

		/*
		 * ============================================================
		 * VALIDATE SESSION
		 * ============================================================
		 */
		if (shopId == null || shopCode == null || db == null) {

			addActionError(
					"Session Expired or Invalid. Please Login Again."
			);

			return "login";
		}

		/*
		 * Clear old records before loading new records
		 */
		stockTransferInfoDAOList.clear();

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

		try {

			connection = GetDBConnection.getDBConnection(db);

			/*
			 * ========================================================
			 * GET STOCK TRANSFER LIST
			 *
			 * Vehicle is NOT used.
			 * ========================================================
			 */
			String sql =
					"SELECT "
					+ "stock_transfer_entry_id, "
					+ "stock_transfer_date, "
					+ "stock_transfer_time, "
					+ "from_godown_id, "
					+ "to_godown_id, "
					+ "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 = ? "
					+ "ORDER BY stock_transfer_date DESC, "
					+ "stock_transfer_time DESC";

			preparedStatement =
					connection.prepareStatement(sql);

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

			resultSet = preparedStatement.executeQuery();

			while (resultSet.next()) {

				stockTransferListInfoDAO dao =
						new stockTransferListInfoDAO();

				/*
				 * ====================================================
				 * FROM GODOWN
				 * ====================================================
				 */
				String fromWarehouseName = "Main";

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

				if (fromGodownId != null
						&& !fromGodownId.trim().isEmpty()
						&& !"0".equals(fromGodownId)) {

					HashMap<String, String> godownDetails =
							GetGodownDetailsById.getGodownDetails(
									fromGodownId,
									sessionMap,
									connection
							);

					if (godownDetails != null
							&& godownDetails.get("GODOWNNAME") != null) {

						fromWarehouseName =
								godownDetails.get("GODOWNNAME");
					}
				}

				/*
				 * ====================================================
				 * TO GODOWN
				 * ====================================================
				 */
				String toWarehouseName = "Main";

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

				if (toGodownId != null
						&& !toGodownId.trim().isEmpty()
						&& !"0".equals(toGodownId)) {

					HashMap<String, String> godownDetails =
							GetGodownDetailsById.getGodownDetails(
									toGodownId,
									sessionMap,
									connection
							);

					if (godownDetails != null
							&& godownDetails.get("GODOWNNAME") != null) {

						toWarehouseName =
								godownDetails.get("GODOWNNAME");
					}
				}

				/*
				 * ====================================================
				 * SET DAO VALUES
				 * ====================================================
				 */

				dao.setEntryId(
						resultSet.getString(
								"stock_transfer_entry_id"
						)
				);

				dao.setDate(
						resultSet.getString(
								"stock_transfer_date"
						)
				);

				dao.setTime(
						resultSet.getString(
								"stock_transfer_time"
						)
				);

				dao.setFromWarehouse(
						fromWarehouseName
				);

				dao.setToWarehouse(
						toWarehouseName
				);

				dao.setTotalProducts(
						resultSet.getString(
								"total_products"
						)
				);

				/*
				 * ====================================================
				 * ENCRYPTED KEY
				 * ====================================================
				 */
				String encryptedKey =
						EncryptionDecryption.encrypt(
								resultSet.getString(
										"stock_transfer_entry_id"
								)
						);

				dao.setKey(encryptedKey);

				stockTransferInfoDAOList.add(dao);
			}

			/*
			 * ========================================================
			 * NO RECORDS
			 * ========================================================
			 */
			if (stockTransferInfoDAOList.isEmpty()) {

				addActionError(
						"No Stock Transfer Entry Found !"
				);
			}

			result = SUCCESS;

		} catch (SQLException e) {

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

			result = "error";

		} catch (Exception e) {

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

			result = "error";

		} finally {

			try {

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

			} catch (SQLException e) {
			}

			try {

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

			} catch (SQLException e) {
			}

			try {

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

			} catch (SQLException e) {
			}
		}

		return result;
	}


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

	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 getAddSideBarJs() {
		return addSideBarJs;
	}

	public void setAddSideBarJs(String addSideBarJs) {
		this.addSideBarJs = addSideBarJs;
	}

	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}

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

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

	public ArrayList<stockTransferListInfoDAO>
			getStockTransferInfoDAOList() {

		return stockTransferInfoDAOList;
	}

	public void setStockTransferInfoDAOList(
			ArrayList<stockTransferListInfoDAO>
					stockTransferInfoDAOList) {

		this.stockTransferInfoDAOList =
				stockTransferInfoDAOList;
	}
}