package com.reallinkbilling.ajax;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.DAO.EmployeeInfoDAO;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;


import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;

public class SearchEmployeeInfo extends ActionSupport implements SessionAware{

	/**
	 * 
	 */
	private static final long serialVersionUID = 6280306575341472031L;
	private String key;
	private String searchOption;
	private SessionMap<String,Object> sessionMap; 
		
	
	private List<EmployeeInfoDAO> employeeInfoList = new ArrayList<EmployeeInfoDAO>();
	
	public String execute() throws Exception {

	 	String result = "login";
	 	 if(this.getSessionMap()==null || this.getSessionMap().get("login")==null){ 
	        	addActionMessage("Please Logout and Login again !");
	        	result = "login";
	    }
	 	 else
        {
	 		String shopId = (String) this.getSessionMap().get("shopId");
    		String shopCode = (String) this.getSessionMap().get("shopCode");
         
        //	System.out.println("hello");
        	
        	Connection connection = null;
       		PreparedStatement preparedStatement= null;
       		ResultSet resultSet = null;
       		
       	
       		String actualKey = this.getKey().trim();
       		
       		String sql = "";
       		if(this.getSearchOption().equals("BYNAME"))
       		{	
       		 sql = "SELECT "
       				+ "employee_id,"
       				+ "employee_name,"
       				+ "employee_mobile_number,"
       				+ "employee_designation "       			
       				+ "FROM "
       				+ "shop_employee_master "
       				+ "WHERE "
       				+ "employee_name LIKE '%"+actualKey+"%' "
					+ "AND "
					+ "shop_id = ? "
					+ "AND "
					+ "shop_code = ? ";
       			
       		}
       		else if(this.getSearchOption().equals("BYMOBILENUMBER"))
       		{
       		 sql = "SELECT "
        				+ "employee_id,"
        				+ "employee_name,"
        				+ "employee_mobile_number "       			
        				+ "FROM "
        				+ "shop_employee_master "
        				+ "WHERE "
        				+ "employee_mobile_number LIKE '%"+actualKey+"%' "
        				+ "AND "
   						+ "shop_id = ? "
   						+ "AND "
   						+ "shop_code = ? ";
           				
       		}
       		else if(this.getSearchOption().equals("BYDESIGNATION"))
       		{
       			sql = "SELECT "
        				+ "employee_id,"
        				+ "employee_name,"
        				+ "employee_mobile_number,"
        				+ "employee_designation "       			
        				+ "FROM "
        				+ "shop_employee_master "
        				+ "WHERE "
        				+ "employee_designation LIKE '%"+actualKey+"%' "
        				+ "AND "
   						+ "shop_id = ? "
   						+ "AND "
   						+ "shop_code = ? ";
       		}
       		else
       		{
       			sql = "SELECT "
        				+ "employee_id,"
        				+ "employee_name,"
        				+ "employee_mobile_number,"
        				+ "employee_designation "       			
        				+ "FROM "
        				+ "shop_employee_master "
        				+ "WHERE "
           				+ "employee_name LIKE '%"+actualKey+"%' "
           				+ "AND "
   						+ "shop_id = ? "
   						+ "AND "
   						+ "shop_code = ? ";
       				
       			
       		}
       		
       		String db = (String) this.getSessionMap().get("db");
       		try {
       			
       			
				connection = GetDBConnection.getDBConnection(db);
       			
       			preparedStatement = connection.prepareStatement(sql);
       			preparedStatement.setString(1, shopId);
       			preparedStatement.setString(2, shopCode);
       			
       			
       			resultSet = preparedStatement.executeQuery();      			
       			resultSet.last();
				int rowCount = resultSet.getRow();
				resultSet.beforeFirst();
				
				if(rowCount>0)
				{
       			 	
	       			while(resultSet.next())
	       			{
	       				EmployeeInfoDAO empInfoDAO = new EmployeeInfoDAO();
	       				
	       				empInfoDAO.setEmployeeId(resultSet.getString(1));
	       				empInfoDAO.setEmployeeName(resultSet.getString(2));
	       				empInfoDAO.setEmployeeMobileNumber(resultSet.getString(3));
	       				empInfoDAO.setEmployeeDesignation(resultSet.getString(4));
	       				
	       				empInfoDAO.setKey(EncryptionDecryption.encrypt(resultSet.getString(1)));
	       				
	       				this.getEmployeeInfoList().add(empInfoDAO);
	       			}
				}
	       				
				
   				
       		}	 catch (SQLException e) {
   				//e.printStackTrace();
   				addActionMessage(e.getErrorCode()+"||"+e.getMessage()+"|| SOME ERROR");
			
			} catch (IOException e) {
				//e.printStackTrace();
				addActionMessage(e.getMessage()+"|| SOME ERROR");
			}	
   			finally
   			{
   				if(resultSet != null)
   				{
   					try{resultSet.close(); resultSet = null;}catch(SQLException sqe){}   					
   				}
   				if(preparedStatement != null)
   				{
   					try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
   				}
   				if(connection != null)
   				{
   					try {connection.close(); connection = null;} catch (SQLException e) {}
   				}
   				
   			}
   		}
    	
		result = "success";
    	return result;
	}

	public String getKey() {
		return key;
	}

	public void setKey(String key) {
		this.key = key;
	}


	public List<EmployeeInfoDAO> getEmployeeInfoList() {
		return employeeInfoList;
	}

	public void setEmployeeInfoList(List<EmployeeInfoDAO> employeeInfoList) {
		this.employeeInfoList = employeeInfoList;
	}

	public static long getSerialversionuid() {
		return serialVersionUID;
	}

	public String getSearchOption() {
		return searchOption;
	}

	public void setSearchOption(String searchOption) {
		this.searchOption = searchOption;
	}

	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}

	
	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}

	
	
}

