package com.reallinkbilling.jspRedirect;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
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.stockTransferListInfoDAO;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.utils.GetGodownDetailsById;

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

	private static final long serialVersionUID = -4494326594175576161L;

	private SessionMap<String, Object> sessionMap;

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

	private HttpServletRequest request = null;
	private HttpServletResponse response = null;

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

	private String addSideBarJs;

	public String execute() {

//		System.out.println("======================================");
//		System.out.println("StockTransferListJsp EXECUTED");
//		System.out.println("======================================");

		String result = "login";

		if (sessionMap == null) {

			//System.out.println("SESSION MAP IS NULL");

			addActionMessage("Session is null. Please login again !");
			return "login";
		}

//		System.out.println("shopId  = " + sessionMap.get("shopId"));
//		System.out.println("shopCode = " + sessionMap.get("shopCode"));
//		System.out.println("db = " + sessionMap.get("db"));
//		System.out.println("role = " + sessionMap.get("role"));

		if (sessionMap.get("shopId") == null
				|| sessionMap.get("shopCode") == null
				|| sessionMap.get("db") == null) {

			//System.out.println("REQUIRED SESSION VALUE IS MISSING");

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

		//System.out.println("SESSION CHECK PASSED");

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

		Date d = new Date();

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

		setToDate(dateFormat.format(d));
		setFromDate(dateFormat.format(d));

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

		try {

			connection = GetDBConnection.getDBConnection(db);

			/*
			 * ============================================================
			 * GET STOCK TRANSFER LIST
			 *
			 * vehicle_number removed
			 * ============================================================
			 */
			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, getFromDate());
			preparedStatement.setString(2, getToDate());
			preparedStatement.setString(3, shopId);
			preparedStatement.setString(4, shopCode);

			resultSet = preparedStatement.executeQuery();

			while (resultSet.next()) {

				stockTransferListInfoDAO dao =
						new stockTransferListInfoDAO();

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

				String fromGodownName = "MAIN";

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

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

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

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

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

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

				String toGodownName = "MAIN";

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

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

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

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

						toGodownName =
								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(
						fromGodownName
				);

				dao.setToWarehouse(
						toGodownName
				);

				/*
				 * Vehicle removed completely.
				 */

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

				/*
				 * ========================================================
				 * ENCRYPTED KEY
				 * ========================================================
				 */

				String encryptedKey =
						EncryptionDecryption.encrypt(
								resultSet.getString(
										"stock_transfer_entry_id"
								)
						);

				dao.setKey(encryptedKey);

				setKey(encryptedKey);

				stockTransferInfoDAOList.add(dao);
			}

			/*
			 * ============================================================
			 * NO RECORDS
			 * ============================================================
			 */

			if (stockTransferInfoDAOList.isEmpty()) {

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

			result = SUCCESS;

		} catch (SQLException e) {

			e.printStackTrace();

			addActionError(
					"SQL ERROR: "
					+ e.getErrorCode()
					+ " || "
					+ e.getMessage()
			);

			result = "error";

		} catch (Exception e) {

			e.printStackTrace();

			addActionError(
					"ERROR: "
					+ e.getClass().getName()
					+ " || "
					+ e.getMessage()
			);

			result = "error";

		} finally {

			try {

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

			} catch (SQLException ignored) {
			}

			try {

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

			} catch (SQLException ignored) {
			}

			try {

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

			} catch (SQLException ignored) {
			}
		}

		return result;
	}


	// ============================================================
	// GETTERS AND 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 static long getSerialversionuid() {
		return serialVersionUID;
	}

	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
	@SuppressWarnings("unchecked")
	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;
	}

	public String getKey() {
		return key;
	}

	public void setKey(String key) {
		this.key = key;
	}

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

	@Override
	public void setServletRequest(
			HttpServletRequest req) {

		this.request = req;
	}

	@Override
	public void setServletResponse(
			HttpServletResponse res) {

		this.response = res;
	}
}