package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.LoanInfo;
import main_package.RdDetails;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="loanNoDetailJson")
@ViewScoped

public class LoanNoDetailJsonBean implements Serializable
{
	String json;
	 int currentDueEmi=0;double currentDueAmount=0,penaltyDue;
	
	public LoanNoDetailJsonBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String loanType = params.get("loanType");
		String loanNo=params.get("loanNoWithName");
		String penaltyStatus=params.get("penaltyStatus");
		/*String pwd=params.get("pwd");*/
		
		DataBaseMethods dbm=new DataBaseMethods();
	   
        //UserInfo user_info=new UserInfo();
        LoanInfo loan_info=new LoanInfo();
       if(loanNo==null || loanNo.equals(""))
       {
    	   
       }
       else
       {
    	   if(loanNo.contains("/"))
    	   {
    		   loanNo=loanNo.substring(0,loanNo.indexOf("/"));
        	}
    	   penaltyDue=0;
    	   //user_info=new DataBase().userInfoByLoanNoLoanType(loanNo,loanType);
    	   loan_info=new DataBaseMethods().loanInfoByLoanNoLoanType(loanNo,loanType, conn);
    	   
    	   if(penaltyStatus!=null && penaltyStatus.equalsIgnoreCase("yes")) 
    	   {
    		   double  penaltyAmount=dbm.calculatePenaltyAndChequeBounceCharges(loanNo, "Penalty", loanType, conn);
	   			double penaltyPaid=dbm.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);
	   			penaltyDue=penaltyAmount-penaltyPaid;
	   			penaltyDue=Double.parseDouble(new DecimalFormat("##.##").format(penaltyDue));
   			
    	   }
    	   
			
	   	   ArrayList<LoanInfo> loanEMIList;
	   	   loanEMIList=dbm.loanInstallment(loanType,loanNo, conn);
	   	  currentDueEmi=0;currentDueAmount=0;
	   		for(int l=0;l<loanEMIList.size();l++)
	   		{
	   			Date dt=new Date();
	   			if(loanEMIList.get(l).getStatus().equals("Paid"))
	   			{
	   				loanEMIList.get(l).setColorStatus("paid");
	   			}
	   			else
	   			{
	   				if(loanEMIList.get(l).getInstallDate().before(dt))
	   				{
	   					loanEMIList.get(l).setColorStatus("due");
	   					if(loanEMIList.get(l).getColorStatus().equalsIgnoreCase("due"))
	   					{
	   						currentDueEmi+=1;
	   						currentDueAmount+=loanEMIList.get(l).getDueAmount();
	   					}
	   				}
	   				else
	   				{
	   					loanEMIList.get(l).setColorStatus("upcoming");
	   				}
	   			}
	   		}
   	   
       }
		
     List<String> list=new ArrayList<>();
     
     
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();

		    /* if(user_info!=null)
		     {
		    	 JSONObject obj = new JSONObject();
		    	 
		    	 
		    	 obj.put("applicantName", user_info.getFirst_applicantName());
		    	 
		    	 arr.add(obj);
		     }*/
		     
			if (loan_info != null) {

			    JSONObject obj = new JSONObject();

			    UserInfo uu = dbm.memberBasicDetail(loan_info.getShareHolderNo(), conn);

			    // Member Details
			    obj.put("shareHolderNo", loan_info.getShareHolderNo());
			    obj.put("applicantName", loan_info.getApplicantName());
			    obj.put("contactNo", uu.getContactNo());
			    obj.put("address", uu.getAddress());
			    obj.put("latitude", uu.getLatitude());
			    obj.put("longitude", uu.getLongitude());

			    // Loan Details
			    if (loan_info.getLoanType().equalsIgnoreCase("Group Loan")
			            || loan_info.getLoanType().equalsIgnoreCase("grouploan")) {
			        obj.put("loanNo", loan_info.getSubLoanNo());
			    } else {
			        obj.put("loanNo", loan_info.getLoanNo());
			    }

			    obj.put("loanAmount", loan_info.getLoanAmount());
			    obj.put("loanInterest", loan_info.getLoanInterest());
			    obj.put("loanEMI", (int) loan_info.getInstallAmount());
			    obj.put("terms", loan_info.getLoanTerm());
			    obj.put("frequency", loan_info.getFrequency());
			    obj.put("filecharge", loan_info.getFileCharge());
			    obj.put("savingAmount", (int) loan_info.getExtraAmt());
			    obj.put("requestDate", loan_info.getStrRequestDate());
			    obj.put("approveDate", loan_info.getStrApprovalDate());

			    // Due Details
			    obj.put("currentDueEmi", currentDueEmi);
			    obj.put("currentDueAmount", currentDueAmount);
			    obj.put("duePenalty", penaltyDue);

			    // RD Details
			    ArrayList<RdDetails> rdList =
			            fetchAllRdDetailsByShareHolderNo(loan_info.getShareHolderNo());

			    obj.put("isRdConnected", !rdList.isEmpty());

			    JSONArray rdArray = new JSONArray();

			    for (RdDetails rd : rdList) {
			        JSONObject rdObj = new JSONObject();

			        rdObj.put("rdNumber", rd.getRdNumber());
			        rdObj.put("schemeType", rd.getSchemeType());
			        rdObj.put("terms", rd.getTerms());
			        rdObj.put("installmentAmount", rd.getInstallmentAmount());
			        rdObj.put("interestRate", rd.getInterestRate());
			        rdObj.put("maturityValue", rd.getMaturityValue());
			        rdObj.put("maturityDate", rd.getMaturityDate());
			        rdObj.put("frequency", rd.getFrequency());

			        rdArray.add(rdObj);
			    }

			    obj.put("rdDetails", rdArray);

			    arr.add(obj);
			}
		    	
			      

		    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	
	public ArrayList<RdDetails> fetchAllRdDetailsByShareHolderNo(
	        String shareholderNo) {

	    DataBaseMethodsHemant dbn = new DataBaseMethodsHemant();
	    ArrayList<RdDetails> rdDetails =
	            dbn.fetchAllRdDetailsByShareHolderNo(shareholderNo);

	    return rdDetails;
	}
	
	
	public void renderJson() throws IOException {
 	    FacesContext facesContext = FacesContext.getCurrentInstance();
 	    ExternalContext externalContext = facesContext.getExternalContext();
 	    externalContext.setResponseContentType("application/json");
 	    externalContext.setResponseCharacterEncoding("UTF-8");
 	    externalContext.getResponseOutputWriter().write(json);
 	    facesContext.responseComplete();
 	    
 	    
 	}

	public String getJson() {
		return json;
	}

	public void setJson(String json) {
		this.json = json;
	}
	
}
