package json_package;

import java.io.IOException;
import java.sql.Connection;
import java.text.DecimalFormat;
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 org.json.simple.JSONObject;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRavi;
import main_package.DataBaseMethodsRaviK;
import main_package.LoanInfo;
import report_package.DataBaseReportMethods;
import report_package.LoanPaymentReceipt;

@ManagedBean(name = "payLoanEmiReceiptJsonBean")
@ViewScoped
public class myNidhiPayLoanEmiReceiptJsonBean
{
    private String json;
    DataBaseMethodsRavi dbr = new DataBaseMethodsRavi();
    DataBaseMethods dbm = new DataBaseMethods();
    DataBaseMethodTaheer dbt = new DataBaseMethodTaheer();
    LoanPaymentReceipt lpr = new LoanPaymentReceipt();
    DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();
    
    
    
    public myNidhiPayLoanEmiReceiptJsonBean()
    {
        JSONObject mainobj = new JSONObject();

        try
        {
            Map<String, String> params =
                    FacesContext.getCurrentInstance()
                    .getExternalContext()
                    .getRequestParameterMap();

            
            String loanNo = params.get("loanNo");
            String emiAmountStr = params.get("emiAmount");
            String branchIdStr = params.get("branchId");
            String shareHolderNo = params.get("shareHolderNo");
            
			if (loanNo == null || loanNo.trim().equals("")) {
				mainobj.put("status", "error");
				mainobj.put("message", "loanNo is required");

				json = mainobj.toJSONString();
				return;
			}

			if (emiAmountStr == null || emiAmountStr.trim().equals("")) {
				mainobj.put("status", "error");
				mainobj.put("message", "emiAmount is required");

				json = mainobj.toJSONString();
				return;
			}

			if (branchIdStr == null || branchIdStr.trim().equals("")) {
				mainobj.put("status", "error");
				mainobj.put("message", "branchId is required");

				json = mainobj.toJSONString();
				return;
			}

			if (shareHolderNo == null || shareHolderNo.trim().equals("")) {
				mainobj.put("status", "error");
				mainobj.put("message", "shareHolderNo is required");

				json = mainobj.toJSONString();
				return;
			}

            double emiAmount = Double.parseDouble(emiAmountStr);
            int branchId = Integer.parseInt(branchIdStr);
 
            
            Connection conn = DataBaseConnection.JAVAConnection();
            
			String loanType = dbt.loanTypeByLoanNo(loanNo);
			LoanInfo info = dbm.loanInfoByLoanNoLoanType(loanNo, loanType, conn);
			String dateOfApproval = info.getStrApprovalDate();
			String term = lpr.calculateTerm(String.valueOf(info.getFrequencyVal()), info.getLoanTerm());
			String name = dbm.shareHolderDetailByColumnName(shareHolderNo, "first_applicantName", conn);
			String fatherName = dbm.shareHolderDetailByColumnName(shareHolderNo, "father_husband_name", conn);
			String dob = dbm.shareHolderDetailByColumnName(shareHolderNo, "dob", conn);
			String branchName = dbm.branchNameByBranchId(branchId, conn);
			String branchCode = dbm.branchCodeByBranchId(branchId, conn);
			String receiptDate = new SimpleDateFormat("dd/MM/yyyy").format(new Date());
			Date receiptDateObj = new SimpleDateFormat("dd/MM/yyyy").parse(receiptDate);
			double chequeBounce = dbrk.getPaidBounce(loanNo, receiptDateObj, conn);
			String age = "";
			if (dob != null && !dob.trim().equals("")) {
				SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
				Date dobDate = sdf.parse(dob);
				age = lpr.ageCalculate(dobDate);
			}
			String address = dbm.shareHolderDetailByColumnName(shareHolderNo, "address", conn);
			String companyName = dbr.companyName(conn);
			String companyAddress = dbr.companyAddress(conn);
			String nextDueDate = "";
			ArrayList<LoanInfo> loanEMIList = dbm.loanInstallment(loanType, loanNo, conn);
			for (LoanInfo ii : loanEMIList) {
				if (ii.getStatus().equalsIgnoreCase("Due")) {
					nextDueDate = ii.getStrInstlmntDate();
					break;
				}
			}
			String amountInWords = new DataBaseReportMethods()
			        .numberToWords(
			            Integer.parseInt(
			                new DecimalFormat("##").format(emiAmount)
			            )
			        )
			        .toUpperCase();
			conn.close();

			
            JSONObject obj = new JSONObject();
            
            obj.put("companyName", companyName);
            obj.put("companyAddress", companyAddress);
            obj.put("name", name);
            obj.put("fatherName", fatherName);
            obj.put("age", age);
            obj.put("address", address);
            obj.put("loanNo", loanNo);
            obj.put("loanType", loanType);
            obj.put("dateOfApproval", dateOfApproval);
            obj.put("term", term);
            obj.put("loanNo", loanNo);
            obj.put("emiAmount", emiAmount);
            obj.put("branchId", branchId);
            obj.put("shareHolderNo", shareHolderNo);
            obj.put("dateOfReceipt", receiptDate);
            obj.put("chequeBounce", chequeBounce);
            obj.put("amountInWords", amountInWords);
            obj.put("branchName", branchName);
            obj.put("branchCode", branchCode);
            obj.put("date", receiptDate);
            obj.put("nextDueDate", nextDueDate);
            
            
            mainobj.put("status", "success");
            mainobj.put("data", obj);

        }
        catch(Exception e)
        {
            e.printStackTrace();

            mainobj.put("status", "error");
            mainobj.put("message", e.getMessage());
        }

        json = mainobj.toJSONString();
    }


	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;
    }
}