package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
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.LoanInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import report_package.DataBaseReportMethods;

@ManagedBean(name="bulkEmiDetailJson")
@ViewScoped
public class BulkEmiDetailJsonBean implements Serializable
{
	String json;
	Date payDate;

	public BulkEmiDetailJsonBean() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		String sDate = params.get("sDate");
		String searchBase = params.get("searchBase");
		String selectedCenter = params.get("selectedCenter");
		String branchStr = params.get("branchId");
		int branchId = Integer.valueOf(branchStr);
		
		 if(searchBase.contains("'") || sDate.contains("'") || selectedCenter.contains("'"))
			{
		 searchBase="";
				sDate="";
				selectedCenter="";
			}
		 
		   ArrayList<LoanInfo> loanList;
		   DataBaseMethods dbm=new DataBaseMethods();
		   
		   
			DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
			if(sDate!=null && !sDate.equals(""))
			{
				try {
					payDate = (Date)formatter.parse(sDate);
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
	 if(searchBase.equalsIgnoreCase("Search Date"))
	   {
		 loanList= dbm.allOtherLoanList(branchId,"-1", payDate,"grouploan", selectedCenter);
	   }
	   else
	   {
		   loanList= dbm.allOtherLoanListTillLeftAllLoan(branchId,"-1", payDate,"grouploan", selectedCenter);
	   }
        
        
  
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();
			Connection conn=DataBaseConnection.JAVAConnection();
		     if(loanList.size()>0)
		     {
		    	 for(LoanInfo uu : loanList)
				   {
		    		 
		    		 String detail=new DataBaseReportMethods().rdDueAmountForCdsReport(uu.getShareHolderNo(),payDate, conn);
						if(detail.contains("#"))
						{
							String arrRd[]=detail.split("\\#");
							uu.setRdEmiAmtDue(Double.parseDouble(arrRd[2]));
							uu.setRd_fdNo(arrRd[0]);
						}
						else
						{
							uu.setRd_fdNo("");
							uu.setRdEmiAmtDue(0);
						}
						
					   JSONObject obj = new JSONObject();
					   
					   obj.put("sno",uu.getSno());
					   obj.put("name",uu.getApplicantName());
					   obj.put("fatherHusbandName",uu.getFatherHusbandName());
					   obj.put("address",uu.getAddress());
					   obj.put("paidAmount",uu.getPaidAmount());
					   obj.put("totalPaid",uu.getAmountPaidSaving());
					   
					   obj.put("totalLeft",uu.getAmountLeftPaidSaving());
					 
					   obj.put("tillLeft",uu.getTillLeft());
					   obj.put("tillLeftSaving",uu.getTillLeftSaving());
					   
					   obj.put("emiAmount",uu.getInstallAmount());
					   obj.put("savingAmount",uu.getExtraAmt());
					   obj.put("totalEmi",uu.getTotEmiAmt());
					   
					   obj.put("loanAmount",uu.getLoanAmount());
					   obj.put("interestAmount",uu.getInterestAmount());
					   obj.put("savingTotal",uu.getSavingTotal());
					   
					   obj.put("totalAmount",uu.getTotalAmountToBePaidSaving());
					   obj.put("memberNo",uu.getShareHolderNo());
					   obj.put("loanNo",uu.getUserId());
					   
					   obj.put("strLoanCloseDate",uu.getStrLoanCloseDate());
					   
					   obj.put("contactNo",uu.getContactNo());
					   
					   if(uu.getRd_fdNo()==null || uu.getRd_fdNo().equalsIgnoreCase(""))
					   {
						   obj.put("rdNo","");
					   }
					   else
					   {
						   obj.put("rdNo",uu.getRd_fdNo());
					   }
					   
					   obj.put("rdAmount",uu.getRdEmiAmtDue());
					   
					   
					   arr.add(obj);
				   }
					
		     }
		    	 /*String status="";
		    	 if(i==1)
		    	 {
		    		 status="Registered Successfully";
		    	 }
		    	 else if(i==-1)
		    	 {
		    		 status="Please enter a unique email id.";
		    	 }
		    	 else
		    	 {
		    		status="Something went wrong.";
		    	 }*/
		    	
		    	  
			      

		    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	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;
	}
}
