package json_package;

import java.io.IOException;
import java.io.Serializable;
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.DataBaseMethods;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import java.sql.Connection;
import java.sql.SQLException;

import main_package.DataBaseConnection;
import main_package.UserInfo;

@ManagedBean(name="regRequestApp")
@ViewScoped

public class RegRequestFromAppJsonBean implements Serializable
{
	String json;
	String memberPhotoPath, signPhotoPath, formPhotoPath, doc1Path, doc2Path, doc3Path, doc4Path, doc5Path, doc6Path, doc7Path, 
		   doc8Path,aadharFrontDoc9Path,aadharBackDoc10Path,aadharFrontDoc1Path,voterIdFrontDoc3Path,aadharBackDoc01Path,voterIdBackDoc03Path;
	DataBaseMethods obj=new DataBaseMethods();
	int branchId;
	
	public RegRequestFromAppJsonBean() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().getExternalContext().getRequestParameterMap();
		
		System.out.println(params);
		
		String regDate = params.get("reg_date");
		String name = params.get("name");
		String fatherName=params.get("father_name");
		String relation = params.get("relation");
		String dob = params.get("dob");
		String mobileNo=params.get("mobile_no");
		String address = params.get("address");
		String nomineeName = params.get("nominee_name");
		String nomineeRelation=params.get("nominee_relation");
		String memberShipFees=params.get("memberShipFees");
		
		String userId=params.get("userId");
		String gender = params.get("gender");
		String uniqueId=params.get("uniqueId");
		String voterId=params.get("voterId");
		String maritalStatus=params.get("maritalStatus");
		
		String memberPhoto = params.get("memberPhoto");
		String signPhoto=params.get("signPhoto");
		String formPhoto=params.get("formPhoto");
		String aadharFrontDoc1 = params.get("aadharFrontDoc1");
		String doc2=params.get("doc2");
		String voterIdFrontdoc3 = params.get("voterIdFrontdoc3");
		String doc4 = params.get("doc4");
		String doc5=params.get("doc5");
		String doc6 = params.get("doc6");
		String doc7 = params.get("doc7");
		String doc8=params.get("doc8");
		String aadharBackDoc01= params.get("aadharBackDoc01");
		String voterIdBackDoc03= params.get("voterIdBackDoc03");
        
		String panNo=params.get("panNo");
		String rationCardNo=params.get("rationCardNo");
		String center=params.get("center");
		String latitude=params.get("latitude");
		String longitude=params.get("longitude");
		String area=params.get("area");
		String business=params.get("business");
		String businessPlace=params.get("businessPlace");
		String caste=params.get("caste");
		String bankName=params.get("bankName");
		String bankAccountNo=params.get("bankAccountNo");
		String bankBranch=params.get("bankBranch");
		String bankIfsc=params.get("bankIfsc");
		
		String branchStr =params.get("branchId");
		System.out.println("branch in string is:"+branchStr);
		branchId = Integer.valueOf(branchStr);
		
		if(memberPhoto!=null && !memberPhoto.equalsIgnoreCase(""))
		{   
			memberPhotoPath="memberPhoto"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(memberPhoto, memberPhotoPath);
		}
		
		if(signPhoto!=null && !signPhoto.equalsIgnoreCase(""))
		{
			signPhotoPath="signPhoto"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(signPhoto, signPhotoPath);
		}
		
		if(formPhoto!=null && !formPhoto.equalsIgnoreCase(""))
		{
			formPhotoPath="formPhoto"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(formPhoto, formPhotoPath);
		}	
		
		if(aadharFrontDoc1!=null && !aadharFrontDoc1.equalsIgnoreCase(""))
		{
			aadharFrontDoc1Path="doc1"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(aadharFrontDoc1, aadharFrontDoc1Path);
		}
		
		if(doc2!=null && !doc2.equalsIgnoreCase(""))
		{
			doc2Path="doc2"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(doc2, doc2Path);
		}
		
		if(voterIdFrontdoc3!=null && !voterIdFrontdoc3.equalsIgnoreCase(""))
		{
			voterIdFrontDoc3Path="doc3"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(voterIdFrontdoc3, voterIdFrontDoc3Path);
		}
		
		if(doc4!=null && !doc4.equalsIgnoreCase(""))
		{
			doc4Path="doc4"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(doc4, doc4Path);
		}
		
		if(doc5!=null && !doc5.equalsIgnoreCase(""))
		{
			doc5Path="doc5"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(doc5, doc5Path);
		}
		
		if(doc6!=null && !doc6.equalsIgnoreCase(""))
		{
			doc6Path="doc6"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(doc6, doc6Path);
		}
		
		if(doc7!=null && !doc7.equalsIgnoreCase(""))
		{
			doc7Path="doc7"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(doc7, doc7Path);
		}
		
		if(doc8!=null && !doc8.equalsIgnoreCase(""))
		{
			doc8Path="doc8"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(doc8, doc8Path);
		}
		
		if(aadharBackDoc01!=null && !aadharBackDoc01.equalsIgnoreCase(""))
		{
			aadharBackDoc01Path="aadharFrontDoc9"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(aadharBackDoc01, aadharBackDoc01Path);
		}
		
		if(voterIdBackDoc03!=null && !voterIdBackDoc03.equalsIgnoreCase(""))
		{
			voterIdBackDoc03Path ="aadharBackDoc10"+mobileNo+".png";
			ConvertStringtoImage.convertStringtoImage(voterIdBackDoc03, voterIdBackDoc03Path);
		}
		
		DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
		Date regDateDt, dobDt;
		regDateDt=formatter.parse(regDate);
		dobDt=formatter.parse(dob);
		
		int i = new DataBaseMethods().regRequest(branchId,regDateDt, name, fatherName, relation, dobDt, mobileNo, address, nomineeName, nomineeRelation
				, memberPhotoPath, aadharFrontDoc1Path, 
				doc2Path,voterIdFrontDoc3Path, doc4Path, doc5Path, userId, gender, uniqueId, voterId,maritalStatus, signPhotoPath, formPhotoPath, doc6Path, doc7Path, doc8Path, 
				memberShipFees, panNo, rationCardNo,center, latitude, longitude, area, business, businessPlace, caste, bankName, bankAccountNo, bankBranch, bankIfsc,aadharBackDoc01Path,voterIdBackDoc03Path);
                
		System.out.println("iiiiiiiii"+i);
		JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();
			
			 JSONObject obj = new JSONObject();
			     
		    	 String status="";
		    	 if(i>=1)
		    	 {
		    		 status="Request Sent Successfully";
		    		 sendMessage(mobileNo);
		    	 }
		    	 else
		    	 {
		    		status="Something went wrong.";
		    	 }
		    	
		    	 obj.put("st",status);
		    	  
			     arr.add(obj); 
			      

		   // mainobj.put("track", arr);

	//	json=mainobj.toJSONString();
			     
			 	json=arr.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	

	private void sendMessage(String mobileNo) 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		String check=obj.checkStatusInMessageSettingTable("Pay Loan Emi By App");
		if(check.equals("active"))
		{
			UserInfo uu=obj.firmDetails(branchId);
			String typeMessage="Thank You for Submit Your Detail For Verification. "+uu.getName()+" Will Contact ASAP. ";
			obj.runMessageUrl(0,mobileNo, typeMessage, "System","pedning", 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;
	}
}