package json_package;

import group_head_package.DataBaseIncomeExpense;

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.Date;
import java.util.Map;

import javax.faces.application.FacesMessage;
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 org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="bulkPayDepositEmiJson")
@ViewScoped
public class BulkPayDepositEmiJsonBean implements Serializable
{
	String json;
	Date startDate;
	int branchId;
	DataBaseMethods obj=new DataBaseMethods();
	
	public BulkPayDepositEmiJsonBean() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
	
        
		String branchStr = params.get("branchId");
		branchId = Integer.valueOf(branchStr);
		String employee = params.get("userid");
		String searchType=params.get("searchType");
		String sDate=params.get("startDate");
		String rdAmountBulk=params.get("rdAmountBulk");
		String rdNoBulk=params.get("rdNoBulk");
		String savingAmount="0"; //params.get("savingAmount");
		String penaltyAmount="0"; //params.get("penaltyAmount");
		String payMode="Cash"; //params.get("payMode");
		String transactionId=""; //params.get("transactionId");
		String response=""; //params.get("response");
		

		String loginStatus=obj.checkLoginIdStatus(employee);
		
		String rdArrAmount[]=rdAmountBulk.split(",");
		String rdNoArrBulk[]=rdNoBulk.split(",");
		
		int i=0;
		for(int j=0;j<rdNoArrBulk.length;j++)
		{
			if(Double.parseDouble(rdArrAmount[j])>0)
			{
				DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
				if(sDate!=null && !sDate.equals(""))
				{
					startDate = (Date)formatter.parse(sDate);
				}
				
				String rdAmount="",rdNo="";
				if(rdArrAmount[j]!=null)
				{
					rdAmount=rdArrAmount[j];
				}
				if(rdNoArrBulk[j]!=null)
				{
					rdNo=rdNoArrBulk[j];
				}
				
				Date dt=new Date();
				if(loginStatus.equalsIgnoreCase("active"))
				{
					if(dt.after(startDate))
					{
						if(rdAmount!=null && !rdAmount.trim().equalsIgnoreCase("") && !rdAmount.equalsIgnoreCase("0") && !rdNo.equalsIgnoreCase(""))
						{
							i = new DatabaseMethods1().paymentRequest(branchId,employee, startDate, searchType, rdNo, rdAmount, payMode, "NA", transactionId, response,"");
							if(i>=1)
							{
								 sendMessage(employee, rdNo, rdAmount, payMode, savingAmount, penaltyAmount);
							}
						}
					}
					else
					{
						i=-97;
					}
				}
				else
				{
					i=-99;
				}
			}
		}
		
		
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();
			
			 JSONObject obj = new JSONObject();
					
		    	 String status="";
		    	 if(i>=1)
		    	 {
		    		 status="Payment Request Sent Successfully";
		    		
		    		 
		    		 /*// Msg Code Written Here
		    		 if(response!=null && response.equalsIgnoreCase("success"))
		    		 {
		    			 String typeMessage="Dear Sir, A Request of Payment Amount "+amount+"/- Receive From Payment Gateway. Please Capture This Payment from Payment Gateway. Thanks...";
		    			 Connection conn=DataBaseConnection.JAVAConnection();
		    				String contactNo=new DataBaseMethods().contactNoForSchedularMsg(conn);
		    			 new DataBaseMethods().runMessageUrl(contactNo, typeMessage, "System", conn);
		    			 
		    			 try {
							conn.close();
						} catch (SQLException e) {
							// TODO Auto-generated catch block
							e.printStackTrace();
						}
		    		 }
		    		 
		    		 if(Double.parseDouble(penaltyAmount)>0)
		    		 {
		    			 addPenalty(employee, loanNo, penaltyAmount, loanType);
		    		 }*/
		    	 }
		    	 else if(i==-99)
		    	 {
		    		 status="Your User ID Has been Blocked By Admin. ";
		    	 }
		    	 else if(i==-98)
		    	 {
		    		 status="Back Date Entry Not Allowed by Mobile App. Please Contact to Your Admin. ";
		    	 }
		    	 else if(i==-97)
		    	 {
		    		 status="Next Date Entry Not Allowed. Please Contact to Your Admin. ";
		    	 }
		    	 else
		    	 {
		    		status="Something went wrong.";
		    	 }
		    	
		    	 obj.put("st",status);
		    	  
			     arr.add(obj); 
			      

		    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	
	/*// Penalty Entry no need to Approve on Admin Panel so that's why entry status is active.
	private void addPenalty(String employee, String lno, String penaltyAmount, String loanType) 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		String loanLabel=obj.loanLabelByLoanValue(loanType);
		String paymentMode="Cash";
		String voucherNo=obj.generateVoucherNo("income_table",conn);
		int i=new DataBaseIncomeExpense().addIncome(startDate,"Other_Cr",paymentMode,penaltyAmount,"","",
				"",null,"Receive Loan Penalty","Receive Penalty",0,"N/A",
				"0",0,lno,loanLabel, voucherNo,"",0,"active"); 
		if(i>0)
		{
			if(paymentMode.equalsIgnoreCase("Cash"))
			{
				obj.decreaseSharedCompanyAmount(Double.parseDouble(penaltyAmount));/// Increase amount due to Penalty Amount
			}
		}
	}*/


	private void sendMessage(String employee, String lno, String amount, String payMode, String savingAmount, String penaltyAmount) 
	{
		double totalAmount=Double.parseDouble(savingAmount)+Double.parseDouble(amount)+Double.parseDouble(penaltyAmount);
		Connection conn=DataBaseConnection.JAVAConnection();
		String check=obj.checkStatusInMessageSettingTable("Pay Deposit Emi By App");
		if(check.equals("active"))
		{
			String shno=obj.shareHolderNoByRdFdNo(lno);
			String typeMessage="Dear "+lno+" - "+obj.firstApplicantNameBySHNo(shno, conn)+", Rs. "+totalAmount+" Submit Sucessfully By "+payMode;
			obj.runMessageUrl(branchId,obj.applicantContactNoByShareHolderNo(shno, conn), typeMessage, "admin","1207161822711123650", conn);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Message For This Module is not Active. Please Go to In Master Setting Module and Active Message For This Module."));
		}
		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;
	}
	
}
