package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.ValidatorException;
import javax.servlet.http.HttpSession;

import com.google.gson.JsonObject;

import apiClients.AadhaarApiClient;
import apiClients.AadhaarOtpApiClient;
import apiClients.AadhaarOtpApiClient.AadhaarOtpResult;
import apiClients.PanApiClient;

@ManagedBean(name = "odb")
@ViewScoped
public class OverDraftBean implements Serializable 
{	
	private static final long serialVersionUID = 1L;
	
	private String aadhaarNumber, otp, requestId, name, gender, address, imageUrl, email, mobile, pinCode, employmentType, 
				   orgName, bankName, bankIfsc, accountNo, panNo, panOtp, panApiResponse;
	
	private int branchId;
	
	private double monthlyIncome;
	
	private Date applicationDate = new Date(), dob = new Date();
	
	private boolean showAadharVerify = false, showAadharSend = true, showAadharOtp = false, showAadharField = true, 
					showPanField = true, aadharVerified = false, panVerified = false;
	
	
	
	public OverDraftBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
	    branchId = (int) ss.getAttribute("branchId");
	}
	
	    
	
//	 public static void main(String[] args) throws Exception {
//	        JsonObject response = callAadhaarApi("551097583432", "https://gwitapi.in/DEMO", "101");
//	        JsonObject firstItem = response.getAsJsonArray("track").get(0).getAsJsonObject();
//
//	        String requestId = getSafeString(firstItem, "requestId");
//	        System.out.println("RequestId: " + requestId);
//	        
//	        String message = getSafeString(firstItem, "message");
//	        System.out.println("Message: " + message);
//	        
//	        System.out.println("Status: " + firstItem.get("Status").getAsBoolean());
//	    }
	    
	
	
	public void sendOtp() throws Exception 
	{	
		if (aadhaarNumber.length() < 12) 
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Enter Valid Aadhar No."));
		
			return;
		}
		
		
		AadhaarApiClient aac = new AadhaarApiClient();
		
		
		JsonObject response = aac.callAadhaarApi(aadhaarNumber, "https://finko.online/SOFT/", "101");
        JsonObject firstItem = response.getAsJsonArray("track").get(0).getAsJsonObject();
        
        
        requestId = aac.getSafeString(firstItem, "requestId");
        System.out.println("RequestId: " + requestId);
        
        
        String message = aac.getSafeString(firstItem, "message");
        System.out.println("Message: " + message);
        FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
        
        
        System.out.println("Status: " + firstItem.get("Status").getAsBoolean());
        boolean status = firstItem.get("Status").getAsBoolean();
	    if (status) 
	    {
	    	this.showAadharSend = false;
			this.showAadharOtp = true;
	        this.showAadharVerify = true;
	    }

	    FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
	}
	
	
	
	public void verifyOtp() 
	{
		String aadharOtp = otp;    
		   
		AadhaarOtpApiClient aoac = new AadhaarOtpApiClient();
		
        AadhaarOtpResult result = null;
		try 
		{
			result = aoac.verifyOtp(requestId, aadharOtp,aadhaarNumber);
		} 
		catch (Exception e1) 
		{
			e1.printStackTrace();
		}
        System.out.println("Status: " + result.status);
        
        if (result.status) 
        {
            System.out.println("Name: " + result.name);
            name = result.name;
           
            System.out.println("Aadhaar: " + result.aadhaarNumber);
            
            System.out.println("DOB: " + result.dob);
            
            SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-yyyy");
            try 
            {
				dob = formatter.parse(result.dob);
			} 
            catch (ParseException e) 
            {
				e.printStackTrace();
			}
            
            System.out.println("Gender: " + result.gender);
            gender = result.gender;
            
            System.out.println("Address: " + result.fullAddress);
            address = result.fullAddress;
            
            System.out.println("Image bytes len: " + (result.imageUrl == null ? 0 : result.imageUrl.length()));
            imageUrl = result.imageUrl;
                        
            aadharVerified = true;
            showAadharVerify = false;
            showAadharSend = true;
            showAadharField = false;
        } 
        else 
        {
        	FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(result.message));
            System.out.println("Error Message: " + result.message);
            otp = "";
        }
	}
	
	
	
	public void verifyPanOtp()
	{
		System.out.println("Pan Verifying");
        
    	FacesContext context = FacesContext.getCurrentInstance();
        if (panNo == null || panNo.isEmpty()) 
        {
            context.addMessage("kycForm:pan", new FacesMessage(FacesMessage.SEVERITY_ERROR, "Error", "Please enter a valid PAN number."));
            return;
        }
        
        String message = null;
        PanApiClient pc = new PanApiClient();
		JsonObject response = null;
		boolean isPanValid;
		
		try 
		{
			response = pc.callPanApi(panNo, "https://gwitapi.in/", "KYC");
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		
	    panApiResponse = response.toString();
        JsonObject firstItem = response.getAsJsonArray("track").get(0).getAsJsonObject();

        boolean status = firstItem.get("status").getAsBoolean();
        System.out.println("Status: " + status);
        
        if (status) 
        {
             isPanValid = true;   
             panVerified = true;
        } 
        else 
        {
        	isPanValid = false;
        	message = pc.getSafeString(firstItem, "message");
        }
        
        
        if (isPanValid) 
        {
            context.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Success", "PAN verified successfully."));
            showPanField = false;
        } 
        else 
        {
            context.addMessage("kycForm:pan", new FacesMessage(FacesMessage.SEVERITY_WARN, 
            				   "Verification Failed", "Invalid PAN number. " + message));
        }
	}
	

	
	public void validateOtp(FacesContext context, UIComponent component, Object value) throws ValidatorException 
	{
	    String otpValue = (String) value;
	    
	    if (otpValue == null || otpValue.isEmpty()) 
	    {
	        throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                "OTP cannot be empty!", null));
	    }
	    
	    if (!otpValue.matches("\\d+")) 
	    {
	        throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                "OTP must contain only digits!", null));
	    }

	    if (otpValue.length() < 4 || otpValue.length() > 6) 
	    {
	        throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                "OTP must be between 4 and 6 digits!", null));
	    }
	}

	
	
	public void validateAadhaar(FacesContext context, UIComponent component, Object value) throws ValidatorException 
	{
	    String aadhaarValue = (String) value;

	    if (aadhaarValue == null || aadhaarValue.isEmpty()) 
	    {
	        throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                "Aadhaar number cannot be empty!", null));
	    }

	    if (!aadhaarValue.matches("\\d+")) 
	    {
	        throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                "Aadhaar number must contain only digits!", null));
	    }

	    if (aadhaarValue.length() != 12) 
	    {
	        throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                "Aadhaar number must be exactly 12 digits!", null));
	    }
	}

	
	public void submit()
	{
//		if (!aadharVerified) 
//		{
//			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Aadhar not Verified"));
//			return;
//		}
//		
//		if (!panVerified) 
//		{
//			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Pan not Verified"));
//			return;
//		}
		
		saveApplication();
	}
	
	
	
	public void saveApplication()
	{
		String cid = generateNextCustomerId();
		
		try(Connection conn = DataBaseConnection.JAVAConnection()) 
		{
			String qq = "INSERT INTO od_application (aadhar_no, aadhar_verified, pan_no, pan_verified, photo, name, gender, dob, "
					  + "email, mobile, address, pin_code, monthly_income, emp_type, org_name, bank_name, bank_ifsc, account_no, "
					  + "application_date, branch_id, customer_id) "
					  + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
			
			try(PreparedStatement ps = conn.prepareStatement(qq)) 
			{
				ps.setString(1, aadhaarNumber);
				ps.setBoolean(2, aadharVerified);
				ps.setString(3, panNo);
				ps.setBoolean(4, panVerified);
				ps.setString(5, imageUrl);
				ps.setString(6, name);
				ps.setString(7, gender);
				ps.setDate(8, new java.sql.Date(dob.getTime()));
				ps.setString(9, email);
				ps.setString(10, mobile);
				ps.setString(11, address);
				ps.setString(12, pinCode);
				ps.setDouble(13, monthlyIncome);
				ps.setString(14, employmentType);
				ps.setString(15, orgName);
				ps.setString(16, bankName);
				ps.setString(17, bankIfsc);
				ps.setString(18, accountNo);
				ps.setDate(19, new java.sql.Date(applicationDate.getTime()));
				ps.setInt(20, branchId);
				ps.setString(21, cid);
				
				int i = ps.executeUpdate();
				if (i>0) 
				{
					resetFlow();
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Apllicaton Submitted"));
				}
				else 
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Apllicaton not Submitted"));
				}
				
			} 
			catch (Exception e) 
			{
				e.printStackTrace();
			}
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}

	

	
	
	
	public void resetFlow() 
	{	
		aadhaarNumber = otp = requestId = name = gender = address = imageUrl = email = mobile = pinCode = employmentType = 
		orgName = bankName = bankIfsc = accountNo = panNo = panOtp = panApiResponse = "";

		monthlyIncome = 0;
		
		dob = applicationDate = new Date();
		
		showAadharVerify = showAadharOtp = aadharVerified = panVerified = false;
		showAadharSend = showAadharField = showPanField = true;
	}
	
	
	
	public String generateNextCustomerId() 
	{
	    String nextCustomerId = "CUST-0000000001";
	    String sql = "SELECT customer_id FROM od_application ORDER BY customer_id DESC LIMIT 1";

	    try (Connection con = DataBaseConnection.JAVAConnection();
	         PreparedStatement ps = con.prepareStatement(sql);
	         ResultSet rs = ps.executeQuery()) 
	    {
	        if (rs.next()) 
	        {
	            String lastId = rs.getString("customer_id");
	            String numericPart = lastId.substring(lastId.lastIndexOf("-") + 1);
	            long newIdNum = Long.parseLong(numericPart) + 1;
	            nextCustomerId = String.format("CUST-%010d", newIdNum);
	        }
	    } 
	    catch (Exception e) 
	    {
	        e.printStackTrace();
	    }

	    return nextCustomerId;
	}

	
	
	public String getAadhaarNumber() {
		return aadhaarNumber;
	}
	public void setAadhaarNumber(String aadhaarNumber) {
		this.aadhaarNumber = aadhaarNumber;
	}
	public String getOtp() {
		return otp;
	}
	public void setOtp(String otp) {
		this.otp = otp;
	}

	
	public String getRequestId() {
		return requestId;
	}

	public void setRequestId(String requestId) {
		this.requestId = requestId;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getImageUrl() {
		return imageUrl;
	}

	public void setImageUrl(String imageUrl) {
		this.imageUrl = imageUrl;
	}

	

	public boolean isShowAadharVerify() {
		return showAadharVerify;
	}



	public void setShowAadharVerify(boolean showAadharVerify) {
		this.showAadharVerify = showAadharVerify;
	}



	public boolean isShowAadharSend() {
		return showAadharSend;
	}



	public void setShowAadharSend(boolean showAadharSend) {
		this.showAadharSend = showAadharSend;
	}



	public boolean isShowAadharField() {
		return showAadharField;
	}



	public void setShowAadharField(boolean showAadharField) {
		this.showAadharField = showAadharField;
	}



	public boolean isShowPanField() {
		return showPanField;
	}



	public void setShowPanField(boolean showPanField) {
		this.showPanField = showPanField;
	}



	public boolean isShowAadharOtp() {
		return showAadharOtp;
	}



	public void setShowAadharOtp(boolean showAadharOtp) {
		this.showAadharOtp = showAadharOtp;
	}



	public String getEmail() {
		return email;
	}



	public void setEmail(String email) {
		this.email = email;
	}



	public String getMobile() {
		return mobile;
	}



	public void setMobile(String mobile) {
		this.mobile = mobile;
	}



	public String getPinCode() {
		return pinCode;
	}



	public void setPinCode(String pinCode) {
		this.pinCode = pinCode;
	}



	public String getEmploymentType() {
		return employmentType;
	}



	public void setEmploymentType(String employmentType) {
		this.employmentType = employmentType;
	}



	public String getOrgName() {
		return orgName;
	}



	public void setOrgName(String orgName) {
		this.orgName = orgName;
	}



	public double getMonthlyIncome() {
		return monthlyIncome;
	}



	public void setMonthlyIncome(double monthlyIncome) {
		this.monthlyIncome = monthlyIncome;
	}



	public String getBankName() {
		return bankName;
	}



	public void setBankName(String bankName) {
		this.bankName = bankName;
	}



	public String getBankIfsc() {
		return bankIfsc;
	}



	public void setBankIfsc(String bankIfsc) {
		this.bankIfsc = bankIfsc;
	}



	public String getAccountNo() {
		return accountNo;
	}



	public void setAccountNo(String accountNo) {
		this.accountNo = accountNo;
	}



	public String getPanNo() {
		return panNo;
	}



	public void setPanNo(String panNo) {
		this.panNo = panNo;
	}



	public String getPanOtp() {
		return panOtp;
	}



	public void setPanOtp(String panOtp) {
		this.panOtp = panOtp;
	}



	public Date getApplicationDate() {
		return applicationDate;
	}



	public void setApplicationDate(Date applicationDate) {
		this.applicationDate = applicationDate;
	}



	public boolean isAadharVerified() {
		return aadharVerified;
	}



	public void setAadharVerified(boolean aadharVerified) {
		this.aadharVerified = aadharVerified;
	}



	public boolean isPanVerified() {
		return panVerified;
	}



	public void setPanVerified(boolean panVerified) {
		this.panVerified = panVerified;
	}



	public Date getDob() {
		return dob;
	}



	public void setDob(Date dob) {
		this.dob = dob;
	}

}