package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.List;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.BankInfo;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.HeaderBean;
import main_package.UserInfo;

import org.primefaces.context.RequestContext;

import group_head_package.DataBaseIncomeExpense;

@ManagedBean(name="cashBookDoubleColumn")
@ViewScoped

public class CashBookDoubleColumnBean implements Serializable
{   
	Date startDate=new Date(),endDate=new Date();
	double totalCashIn, totalBankIn, totalCredit, totalCashOut, totalBankOut, totalDebit;
	ArrayList<UserInfo> inList = new ArrayList<>(),outList = new ArrayList<>();
	ArrayList<UserInfo>finalList = new ArrayList<>();
	ArrayList<SelectItem> bankList = new ArrayList<>();
	boolean show;
	String totalCrStr,totalDrStr, loanSearch;
	DataBaseMethods db=new DataBaseMethods();
	DecimalFormat df=new DecimalFormat("##.##");
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();
    
	boolean disAll, showBank;
	String userType, bank = "all", cc, type;
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	
	
	
	public CashBookDoubleColumnBean()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		bankList=new DataBaseIncomeExpense().allBankList(con);
		
        cc=(String) ss.getAttribute("companyName");
        type = (String) ss.getAttribute("type");
        System.out.println("noob: " + cc + " type : " + type);
		userType= (String) ss.getAttribute("type");
		
	    disAll= dbmh.disAllByCompanyNameUserType(userType,cc);
		System.out.println("cc : " + cc);
	    if ("GKFC MICROSERVICES FOUNDATION".equalsIgnoreCase(cc)) 
	    {
	    	showBank = true;
		}
	    else 
	    {
	    	showBank = false;
		}
	    
		try
		{
			con.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
	
	
	public void generateCashBook() throws ParseException 
	{
		totalCashIn = 0;
		totalBankIn = 0;
		totalCredit = 0;
		totalCashOut = 0;
		totalBankOut = 0;
		totalDebit = 0;

		
		if(branchId != 0)
		{
			DataBaseReportMethods dbmr= new DataBaseReportMethods();
			HeaderBean hh=new HeaderBean();
			inList = new ArrayList<>();
			outList = new ArrayList<>();
			Connection conn=DataBaseConnection.JAVAConnection();
			ArrayList<BankInfo> bankList=db.allBankListOfCompany(conn);
			String ssDbDate="2010-04-01";   // Change due to Financial Year
			
			if(startDate.equals(endDate) || startDate.before(endDate))
			{
				
				List<Date> dates = new ArrayList<Date>();
			    Calendar calendar = new GregorianCalendar();
			    calendar.setTime(startDate);

			    while (calendar.getTime().before(endDate) || calendar.getTime().equals(endDate))
			    {
			        Date result = calendar.getTime();
			        dates.add(result);// Optional (Only to check list of dates, not used anywhere. Don't be confuse by this)
			     
			        String sDate=new SimpleDateFormat("yyyy-MM-dd").format(result);	
			        String entryDateStr=new SimpleDateFormat("dd-MMM-yyyy").format(result);
				       
				        double totalCashIn=new DataBaseMethods().closingCashInBalance(branchId,sDate,conn, "tb");
				    	//trasnCr=dbmr.cashTransferBtDate(branchId, sDate,"Cr",conn);
				    	//totalCashIn=totalCashIn+trasnCr;
			 			double totalCashOut=new DataBaseMethods().closingCashOutBalance(branchId,sDate,conn, "tb");
			 			
			 			double temp=dbmr.companyIssueShareCapitalForCashBook(branchId,ssDbDate,"cash",conn, sDate);
			 			
			 			temp+=dbmr.shareAmountOpeningBalanceFromOtherShareInfo(branchId,sDate, ssDbDate, "cash",conn);
			 			
			 			
			 			double opCash=totalCashIn-totalCashOut;
			 			
			 			opCash+=temp;
			 			
			 			double totalBankIn = 0,totalBankOut=0;
			 			
			 			if (bank.equalsIgnoreCase("All")) 
			 			{
			 				for(BankInfo bb: bankList)
				 			{
				 				totalBankIn+=new DataBaseMethods().closingBalanceOfBankIn(branchId,bb.getId(), sDate,conn,"tb");
				 				System.out.println("totalBankIn"+totalBankIn);
				 				totalBankOut+=new DataBaseMethods().closingBalanceOfBankOut(branchId,bb.getId(), sDate,conn,"tb");
				 				System.out.println("totalBankout"+totalBankOut);
				 			}
						}
			 			else 
			 			{
			 				totalBankIn+=new DataBaseMethods().closingBalanceOfBankIn(branchId, bank, sDate,conn,"tb");
			 				System.out.println("totalBankIn"+totalBankIn);
			 				totalBankOut+=new DataBaseMethods().closingBalanceOfBankOut(branchId, bank, sDate,conn,"tb");
			 				System.out.println("totalBankout"+totalBankOut);
						}
			 			
			 			System.out.println(totalBankIn+"======="+totalBankOut);
			 			double opBank=totalBankIn-totalBankOut;
			 			System.out.println("opening bank balnc is:"+opBank);
//			 			3.5401984E7=======3.5105023E7
//			 			3.5421184E7=======3.5185023E7		
			 			double tempBank=dbmr.companyIssueShareCapitalForCashBook(branchId,ssDbDate,"bank",conn, sDate);
			 			tempBank+=dbmr.shareAmountOpeningBalanceFromOtherShareInfo(branchId,sDate, ssDbDate, "bank",conn);
			 			
			 			opBank+=tempBank;
			 			opBank=Double.parseDouble(new DecimalFormat("##.##").format(opBank));
		 			
						UserInfo tt=new UserInfo();
						tt.setStatus("Opening Balance");
						tt.setEntryDate(result);
						tt.setEntryDateStr(entryDateStr);
						tt.setCashInAmount(opCash);
						tt.setBankInAmount(opBank);
						tt.setTotalAmount(opBank+opCash);
						inList.add(tt);
	    				
	    				UserInfo tt1 = new UserInfo();
	    				
	    				double shareAmount =dbmr.shareAmountBetweenDatesForCashBook(branchId,sDate,sDate, "Cash");
	    				shareAmount+=dbmr.shareExtraAmountBetweenDatesForCashBook(branchId,sDate,sDate, "Cash");  // for share info table : Add more share
	    				tt1.setStatus("Share Account");
	    				tt1.setCashInAmount(shareAmount);
	    				double shareAmountbank = dbmr.shareAmountBetweenDatesForCashBook(branchId,sDate,sDate, "Bank");
	    				shareAmountbank += dbmr.shareExtraAmountBetweenDatesForCashBook(branchId,sDate,sDate, "Bank");
	    				tt1.setBankInAmount(shareAmountbank);
	    				tt1.setTotalAmount(tt1.getCashInAmount()+tt1.getBankInAmount());
	    				
	    				if(tt1.getTotalAmount()>0)
	    				{
	    					inList.add(tt1);
	        			}
	    				
	    				if("both".equals(loanSearch))
	    				{
	    					UserInfo uu1=new UserInfo();
	        				uu1.setStatus("Loan EMI Amount");
	        				uu1.setEntryDate(result);
	        				uu1.setCashInAmount(dbmr.dailyEmiCollectionBetweenDate(branchId,result, result, "cash", "", conn, ""));
	        				uu1.setBankInAmount(dbmr.dailyEmiCollectionBetweenDate(branchId,result, result, "bank", "", conn, bank));
	        				uu1.setTotalAmount(uu1.getCashInAmount()+uu1.getBankInAmount());
	        				if(uu1.getTotalAmount()>0)
	        				{
	        					inList.add(uu1);
	            			}
	    				}
	    				else
	    				{
	    					UserInfo uu1=new UserInfo();
	        				uu1.setStatus("Loan Principal");
	        				uu1.setEntryDate(result);
	        				uu1.setCashInAmount(dbmr.dailyEmiCollectionBetweenDate(branchId,result, result, "cash", "Principal", conn, ""));
	        				uu1.setBankInAmount(dbmr.dailyEmiCollectionBetweenDate(branchId,result, result, "bank", "Principal", conn, bank));
	        				uu1.setTotalAmount(uu1.getCashInAmount()+uu1.getBankInAmount());
	        				if(uu1.getTotalAmount()>0)
	        				{
	        					inList.add(uu1);
	            			}
	        				
	        				UserInfo uu9=new UserInfo();
	        				uu9.setStatus("Interest On Loan");
	        				uu9.setEntryDate(result);
	        				uu9.setCashInAmount(dbmr.dailyEmiCollectionBetweenDate(branchId,result, result, "cash", "Interest", conn, ""));
	        				uu9.setBankInAmount(dbmr.dailyEmiCollectionBetweenDate(branchId,result, result, "bank", "Interest", conn, bank));
	        				uu9.setTotalAmount(uu9.getCashInAmount()+uu9.getBankInAmount());
	        				if(uu9.getTotalAmount()>0)
	        				{
	        					inList.add(uu9);
	            			}
	    				}	    				
	    			
	    				UserInfo uu22=new UserInfo();
	    				uu22.setStatus("Deposit Application Fee");
	    				uu22.setCashInAmount(dbmr.appFeeForBetweenDateForCashBook(branchId,sDate, sDate, conn));
	    				uu22.setBankInAmount(0);
	    				uu22.setTotalAmount(uu22.getCashInAmount()+uu22.getBankInAmount());
	    				if(uu22.getTotalAmount()>0)
	    				{
	    					inList.add(uu22);
	        			}
	    				
	    				UserInfo uu23=new UserInfo();
	    				uu23.setStatus("OD Laon Return Amount");
	    				uu23.setCashInAmount(dbmr.odLoanReturnAmountForCashBook(branchId,sDate,"cash", sDate, conn, ""));
	    				uu23.setBankInAmount(dbmr.odLoanReturnAmountForCashBook(branchId,sDate,"bank", sDate, conn, bank));
	    				uu23.setTotalAmount(uu23.getCashInAmount()+uu23.getBankInAmount());
	    				if(uu23.getTotalAmount()>0)
	    				{
	    					inList.add(uu23);
	        			}
	    				
	    				UserInfo uu231=new UserInfo();
	    				uu231.setStatus("Cash Transfer");
	    				uu231.setCashInAmount(new DataBaseMethods().calculateCashTransferCr(branchId,sDate,conn));
	    				uu231.setBankInAmount(0.00);
	    				uu231.setTotalAmount(uu231.getCashInAmount()+uu231.getBankInAmount());
	    				if(uu231.getTotalAmount()>0)
	    				{
	    					inList.add(uu231);
	        			}
	    				
	    				
	    				UserInfo uu2=new UserInfo();
	    				uu2.setStatus("DD");
	    				uu2.setCashInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "cash", "DD",conn, ""));
	    				uu2.setBankInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "bank", "DD",conn, bank));
	    				uu2.setTotalAmount(uu2.getCashInAmount()+uu2.getBankInAmount());
	    				if(uu2.getTotalAmount()>0)
	    				{
	    					inList.add(uu2);
	        			}
	    				
	    				UserInfo uu3=new UserInfo();
	    				uu3.setStatus("RD");
	    				uu3.setCashInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "cash", "RD",conn, ""));
	    				uu3.setBankInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "bank", "RD",conn, bank));
	    				uu3.setTotalAmount(uu3.getCashInAmount()+uu3.getBankInAmount());
	    				if(uu3.getTotalAmount()>0)
	    				{
	    					inList.add(uu3);
	        			}
	    				
	    				
	    				UserInfo uu4=new UserInfo();
	    				uu4.setStatus("FD");
	    				uu4.setCashInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "cash", "FD",conn, ""));
	    				uu4.setBankInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "bank", "FD",conn, bank));
	    				uu4.setTotalAmount(uu4.getCashInAmount()+uu4.getBankInAmount());
	    				if(uu4.getTotalAmount()>0)
	    				{
	    					inList.add(uu4);
	        			}
	    				
	    				UserInfo uu41=new UserInfo();
	    				uu41.setStatus("MIS");
	    				uu41.setCashInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "cash", "MIS",conn, ""));
	    				uu41.setBankInAmount(dbmr.dailyRdFdCollectionBetweenDate(branchId,result, result, "bank", "MIS",conn, 
	    																		 bank));
	    				uu41.setTotalAmount(uu41.getCashInAmount()+uu41.getBankInAmount());
	    				if(uu41.getTotalAmount()>0)
	    				{
	    					inList.add(uu41);
	        			}
	    				
	    				
	    				UserInfo uu5=new UserInfo();
	    				uu5.setStatus("Saving Deposit By Cash");
	    				uu5.setCashInAmount(dbmr.savingDepositAmountBetweenDatesForCashBook(branchId,sDate, sDate, "Cash", ""));
	    				uu5.setBankInAmount(dbmr.savingDepositAmountBetweenDatesForCashBook(branchId,sDate, sDate, "bank", bank));
	    				uu5.setTotalAmount(uu5.getCashInAmount()+uu5.getBankInAmount());
	    				if(uu5.getTotalAmount()>0)
	    				{
	    					inList.add(uu5);
	        			}
	    				
	    				
	    				/*UserInfo uu6=new UserInfo();
	    				uu6.setStatus("Saving Deposit By Transfer");
	    				uu6.setCashInAmount(dbmr.savingDepositAmountBetweenDatesForCashBook(sDate, sDate, "Transfer"));
	    				uu6.setBankInAmount(0);
	    				uu6.setTotalAmount(uu6.getCashInAmount()+uu6.getBankInAmount());
	    				if(uu6.getTotalAmount()>0)
	    				{
	    					inList.add(uu6);
	        			}*/
	    				
	    				UserInfo uu10=new UserInfo();
	                    uu10.setStatus("Cash Withdrawl From Bank");
	                    uu10.setCashInAmount(dbmr.cashTransferForCashBook(branchId,result, result, "cash",conn, ""));
	                    uu10.setBankInAmount(dbmr.cashTransferForCashBook(branchId,result, result, "bank",conn, bank));
	                    uu10.setTotalAmount(uu10.getCashInAmount()+uu10.getBankInAmount());
	                    if(uu10.getTotalAmount()>0)
	                    {
	                        inList.add(uu10);
	                    }
	                    
	                	UserInfo uu12=new UserInfo();
	                    uu12.setStatus("Instant Borrow");
	                    uu12.setCashInAmount(dbmr.instantBorrowAndReturnBorrowAmountBetweenDateForCashBook(branchId,result, result,
	                    																				   "credit" ,"cash",conn, 
	                    																				   ""));
	                    uu12.setBankInAmount(dbmr.instantBorrowAndReturnBorrowAmountBetweenDateForCashBook(branchId,result, result,
	                    																				   "credit" ,"bank",conn, 
	                    																				   bank));
	                    uu12.setTotalAmount(uu12.getCashInAmount()+uu12.getBankInAmount());
	                    if(uu12.getTotalAmount()>0)
	                    {
	                        inList.add(uu12);
	                    }
	                    
	                	UserInfo uu13=new UserInfo();
	                    uu13.setStatus("Return Instant Loan");
	                    uu13.setCashInAmount(dbmr.instantLoanAndReturnInstantLoanAmountBetweenDateForCashBook(branchId,result, result,"debit" ,"cash",conn));
	                    uu13.setBankInAmount(dbmr.instantLoanAndReturnInstantLoanAmountBetweenDateForCashBook(branchId,result, result,"debit" ,"bank",conn));
	                    uu13.setTotalAmount(uu13.getCashInAmount()+uu13.getBankInAmount());
	                    if(uu13.getTotalAmount()>0)
	                    {
	                        inList.add(uu13);
	                    }
	                    
	                    UserInfo uu14=new UserInfo();
	                    uu14.setStatus("Promotor Capital");
	                    uu14.setCashInAmount(db.promotorAmountForCashBook(result, result,"cash",branchId,conn, ""));
	                    uu14.setBankInAmount(db.promotorAmountForCashBook(result, result,"bank",branchId,conn, bank));
	                    uu14.setTotalAmount(uu14.getCashInAmount()+uu14.getBankInAmount());
	                    if(uu14.getTotalAmount()>0)
	                    {
	                        inList.add(uu14);
	                    }
	                    
	                    UserInfo uu15=new UserInfo();
	                    uu15.setStatus1("FDR: ");
	                    uu15.setCashInAmount(dbmr.allFdIncomeForCashBook(branchId,result, result,"cash",conn, ""));
	                    uu15.setBankInAmount(dbmr.allFdIncomeForCashBook(branchId,result, result,"bank",conn, "All"));
	                    uu15.setTotalAmount(uu15.getCashInAmount()+uu15.getBankInAmount());
	                    if(uu15.getTotalAmount() > 0)
	                    {
	                    	inList.add(uu15);
	                    }
	                    
	                    UserInfo uu16=new UserInfo();
	                    uu16.setStatus("Bank Transfer");
	                    uu16.setCashInAmount(0);
	                    uu16.setBankInAmount(dbmt.bankTransferForCashBook(branchId,result, result, "in",conn, bank));
	                    uu16.setTotalAmount(uu16.getCashInAmount()+uu16.getBankInAmount());
	                    if(uu16.getTotalAmount() > 0)
	                    {
	                        inList.add(uu16);
	                    }
	                    
	    				inList = dbmr.tempIncomeListForCashBook(branchId,sDate, sDate, inList,conn, bank);
	    				
	    				// Out Method Start
	    				
	    				/*UserInfo out3=new UserInfo();
	    				out3.setSno(3);
	    				out3.setStatus("RD Maturity");
	    				out3.setCashOutAmount(dbmr.depositMaturityBetweenDate(result, result, "cash", "RD"));
	    				out3.setBankOutAmount(dbmr.depositMaturityBetweenDate(result, result, "bank", "RD"));
	    				out3.setAmountOut(out3.getCashInAmount()+out3.getBankInAmount());
	    				inList.add(out3);
	    				
	    				UserInfo out4=new UserInfo();
	    				out4.setSno(4);
	    				out4.setStatus("FD Maturity");
	    				out4.setCashOutAmount(dbmr.depositMaturityBetweenDate(result, result, "cash", "FD"));
	    				out4.setBankOutAmount(dbmr.depositMaturityBetweenDate(result, result, "bank", "FD"));
	    				out4.setAmountOut(out4.getCashInAmount()+out4.getBankInAmount());
	    				inList.add(out4);
	    				*/
		    			
	    				outList=dbmr.tempExpenseAndAssetsListForCashBook(branchId,sDate, sDate, inList,conn, bank);
	    				
	    				
	    				UserInfo out1=new UserInfo();
	    				//out1.setEntryDateStr(entryDateStr);
	    				out1.setStatus1("Loan Disburse");
	    				out1.setCashOutAmount(dbmr.disburseLoanBetweenDate(branchId,result, result, "cash", ""));
	    				out1.setBankOutAmount(dbmr.disburseLoanBetweenDate(branchId,result, result, "bank", bank));
	    				out1.setAmountOut(out1.getCashOutAmount()+out1.getBankOutAmount());
	    				outList.add(out1);
	    				
	    				UserInfo out2=new UserInfo();
	    				out2.setStatus1("Maturity of Deposit's");
	    				out2.setCashOutAmount(dbmr.depositMaturityBetweenDate(branchId,result, result, "cash", ""));  // Method Pending 
	    				out2.setBankOutAmount(dbmr.depositMaturityBetweenDate(branchId,result, result, "bank", bank));
	    				out2.setAmountOut(out2.getCashOutAmount()+out2.getBankOutAmount());
	    				if(out2.getAmountOut()>0)
	    				{
	    					outList.add(out2);
	        			}
	    				
	    				UserInfo out3=new UserInfo();
	    				out3.setStatus1("Saving Withdraw");
	    				out3.setCashOutAmount(dbmr.savingWithdrawlAmountBetweenDatesForCashBook(branchId,sDate, sDate, "cash", ""));  // Method Pending 
	    				out3.setBankOutAmount(dbmr.savingWithdrawlAmountBetweenDatesForCashBook(branchId,sDate, sDate, "bank", bank));
	    				out3.setAmountOut(out3.getCashOutAmount()+out3.getBankOutAmount());
	    				if(out3.getAmountOut()>0)
	    				{
	    					outList.add(out3);
	        			}
	    				
	    				UserInfo out11=new UserInfo();
	                    //out1.setEntryDateStr(entryDateStr);
	                    out11.setStatus1("Cash Deposit To bank");
	                    out11.setCashOutAmount(dbmr.cashTransferForCashBook(branchId,result, result, "bank",conn, bank));
	                    out11.setBankOutAmount(dbmr.cashTransferForCashBook(branchId,result, result, "cash",conn, ""));
	                    out11.setAmountOut(out11.getCashOutAmount()+out11.getBankOutAmount());
	                    if(out11.getAmountOut() > 0)
	                    {
	                        outList.add(out11);
	                    }
	                    
	                    
	                	
                		UserInfo out12=new UserInfo();
	                    //out1.setEntryDateStr(entryDateStr);
	                    out12.setStatus1("Employee Salary Payout");
	                    out12.setCashOutAmount(dbmr.employeeSalaryPayoutForCashBook(branchId,result, result, "cash",conn, ""));
	                    out12.setBankOutAmount(dbmr.employeeSalaryPayoutForCashBook(branchId,result, result, "bank",conn, bank));
	                    out12.setAmountOut(out12.getCashOutAmount()+out12.getBankOutAmount());
		                
	                    if ("SUDERSHANA FINANCE".equalsIgnoreCase(cc))
	                	{
	                    	if ("masteradmin".equalsIgnoreCase(type))
	                    	{
		                    	if(out12.getAmountOut() > 0)
			                    {
			                        outList.add(out12);
			                    }
	                    	}
						}
	                    else
	                    {
	                    	if(out12.getAmountOut() > 0)
		                    {
		                        outList.add(out12);
		                    }
	                    }
	                    
	                    UserInfo oo12=new UserInfo();
	                    oo12.setStatus1("Return Instant Borrow");
	                    oo12.setCashOutAmount(dbmr.instantBorrowAndReturnBorrowAmountBetweenDateForCashBook(branchId,result, result,"debit" ,"cash",conn, ""));
	                    oo12.setBankOutAmount(dbmr.instantBorrowAndReturnBorrowAmountBetweenDateForCashBook(branchId,result, result,"debit" ,"bank",conn, bank));
	                    oo12.setAmountOut(oo12.getCashOutAmount()+oo12.getBankOutAmount());
	                    if(oo12.getAmountOut()>0)
	                    {
	                        outList.add(oo12);
	                    }
	                    
	                	UserInfo oo13=new UserInfo();
	                    oo13.setStatus1("Instant Loan");
	                    oo13.setCashOutAmount(dbmr.instantLoanAndReturnInstantLoanAmountBetweenDateForCashBook(branchId,result, result,"credit" ,"cash",conn));
	                    oo13.setBankOutAmount(dbmr.instantLoanAndReturnInstantLoanAmountBetweenDateForCashBook(branchId,result, result,"credit" ,"bank",conn));
	                    oo13.setAmountOut(oo13.getCashOutAmount()+oo13.getBankOutAmount());
	                    if(oo13.getAmountOut()>0)
	                    {
	                        outList.add(oo13);
	                    }
	                    
	                    UserInfo out31=new UserInfo();
	    				out31.setStatus1("Cash Transfer");
	    				out31.setCashOutAmount(new DataBaseMethods().calculateCashTransferDr(branchId,sDate,conn));  // Method Pending 
	    				out31.setBankOutAmount(0.0);
	    				out31.setAmountOut(out31.getCashOutAmount()+out31.getBankOutAmount());
	    				if(out31.getAmountOut()>0)
	    				{
	    					outList.add(out31);
	        			}
	    				
	                    UserInfo oo14=new UserInfo();
	                    oo14.setStatus1("Return Promotor Capital");
	                    oo14.setCashOutAmount(db.returnPromotorAmountForCashBook(result, result,"cash",branchId,conn, ""));
	                    oo14.setBankOutAmount(db.returnPromotorAmountForCashBook(result, result,"bank",branchId,conn, bank));
	                    oo14.setAmountOut(oo14.getCashOutAmount()+oo14.getBankOutAmount());
	                    if(oo14.getAmountOut()>0)
	                    {
	                        outList.add(oo14);
	                    }
	                    
	                    UserInfo oo15=new UserInfo();
	                    oo15.setStatus1("FDR: ");
	                    oo15.setCashOutAmount(dbmr.allFdExpenseForCashBook(branchId,result, result,"cash",conn, ""));
	                    oo15.setBankOutAmount(dbmr.allFdExpenseForCashBook(branchId,result, result,"bank",conn, bank));
	                    oo15.setAmountOut(oo15.getCashOutAmount()+oo15.getBankOutAmount());
	                    if(oo15.getAmountOut()>0)
	                    {
	                        outList.add(oo15);
	                    }
	                    
	                    UserInfo out16=new UserInfo();
	                    //out1.setEntryDateStr(entryDateStr);
	                    out16.setStatus1("Bank Transfer");
	                    out16.setCashOutAmount(0);
	                    out16.setBankOutAmount(dbmt.bankTransferForCashBook(branchId,result, result, "out",conn,  bank));
	                    out16.setAmountOut(out16.getCashOutAmount()+out16.getBankOutAmount());
	                    if(out16.getAmountOut() > 0)
	                    {
	                        outList.add(out16);
	                    }
	                    
	    				//For Closing Balance
	    				
	    				double cashIn=0, bankIn=0, cashOut=0, bankOut=0, cashBal=0, bankBal=0;
	    				for(UserInfo ff: inList)
	    				{
	    					cashIn+=ff.getCashInAmount();
	    					bankIn+=ff.getBankInAmount();
	    				}
	    				
	    				for(UserInfo ff: outList)
	    				{
	    					cashOut+=ff.getCashOutAmount();
	    					bankOut+=ff.getBankOutAmount();
	    				}
	    				
	    				cashBal=cashIn-cashOut;
	    				bankBal=bankIn-bankOut;
	    				
	    				//System.out.println(opCash+"============"+cashBal+"==========="+bankBal);
	    			    
	    				UserInfo out4=new UserInfo();
	    				
	    				out4.setStatus1("Closing Balance");
	    				out4.setCashOutAmount(cashBal);  // Method Pending 
	    				out4.setBankOutAmount(bankBal);
	    				out4.setAmountOut(out4.getCashOutAmount()+out4.getBankOutAmount());
	    				
	    				outList.add(out4);	    				
			            
	    				
			        calendar.add(Calendar.DATE, 1);
			    }
			    

				for(UserInfo uu: inList)
				{
					
					if(uu.getStatus()==null)
					{
						uu.setStatus("-----------------");
					}
					uu.setCashInAmount(Double.parseDouble(df.format(uu.getCashInAmount())));
					uu.setBankInAmount(Double.parseDouble(df.format(uu.getBankInAmount())));
					uu.setTotalAmount(Double.parseDouble(df.format(uu.getTotalAmount())));
					totalCashIn+=uu.getCashInAmount();
					totalBankIn+=uu.getBankInAmount();
					totalCredit+=uu.getTotalAmount();
				}
				
				int i=1;
				for(UserInfo uu: outList)
				{
					if(uu.getStatus1()==null)
					{
					
						uu.setStatus1("-----------------");
					}
					uu.setCashOutAmount(Double.parseDouble(df.format(uu.getCashOutAmount())));
					uu.setBankOutAmount(Double.parseDouble(df.format(uu.getBankOutAmount())));
					uu.setAmountOut(Double.parseDouble(df.format(uu.getAmountOut())));
				}
				
				
				
				/*for(UserInfo uu: inList)
				{
					totalCashOut+=uu.getCashInAmount();
					totalBankOut+=uu.getBankInAmount();
					totalDebit+=uu.getTotalAmount();
				}*/
				
				totalCashIn=Double.parseDouble(df.format(totalCashIn));
				totalBankIn=Double.parseDouble(df.format(totalBankIn));
				totalCredit=Double.parseDouble(df.format(totalCredit));
				//totalCashOut=Double.parseDouble(df.format(totalCashOut));
				//totalBankOut=Double.parseDouble(df.format(totalBankOut));
				//totalDebit=Double.parseDouble(df.format(totalDebit));
			    
			   /* if(dates.size()>0)
			    {
			    		show=true;
			    		for(Date dd : dates)
			    		{
			    			System.out.println(new SimpleDateFormat("yyyy-MM-dd").format(dd));
			    			
			    		}
			    }*/
			    
				
				
			}
			else
			{
				show=false;
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select End Date Properly."));
			}
		}
    	else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
		
	}

	
public void printCashbook()
{
	HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
	ss.setAttribute("finalCashBookDouble", inList);
	ss.setAttribute("finalCashBookDouble1", outList);
	RequestContext.getCurrentInstance().execute("window.open('printCashBookDouble.xhtml')");
	
	
}


	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public ArrayList<UserInfo> getInList() {
		return inList;
	}

	public void setInList(ArrayList<UserInfo> inList) {
		this.inList = inList;
	}

	public ArrayList<UserInfo> getOutList() {
		return outList;
	}

	public void setOutList(ArrayList<UserInfo> outList) {
		this.outList = outList;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public String getTotalCrStr() {
		return totalCrStr;
	}

	public void setTotalCrStr(String totalCrStr) {
		this.totalCrStr = totalCrStr;
	}

	public String getTotalDrStr() {
		return totalDrStr;
	}

	public void setTotalDrStr(String totalDrStr) {
		this.totalDrStr = totalDrStr;
	}

	public double getTotalCashIn() {
		return totalCashIn;
	}

	public void setTotalCashIn(double totalCashIn) {
		this.totalCashIn = totalCashIn;
	}

	public double getTotalBankIn() {
		return totalBankIn;
	}

	public void setTotalBankIn(double totalBankIn) {
		this.totalBankIn = totalBankIn;
	}

	public double getTotalCredit() {
		return totalCredit;
	}

	public void setTotalCredit(double totalCredit) {
		this.totalCredit = totalCredit;
	}

	public double getTotalCashOut() {
		return totalCashOut;
	}

	public void setTotalCashOut(double totalCashOut) {
		this.totalCashOut = totalCashOut;
	}

	public double getTotalBankOut() {
		return totalBankOut;
	}

	public void setTotalBankOut(double totalBankOut) {
		this.totalBankOut = totalBankOut;
	}

	public double getTotalDebit() {
		return totalDebit;
	}

	public void setTotalDebit(double totalDebit) {
		this.totalDebit = totalDebit;
	}


	public String getLoanSearch() {
		return loanSearch;
	}


	public void setLoanSearch(String loanSearch) {
		this.loanSearch = loanSearch;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public boolean isDisAll() {
		return disAll;
	}

	public void setDisAll(boolean disAll) {
		this.disAll = disAll;
	}

	public String getUserType() {
		return userType;
	}

	public void setUserType(String userType) {
		this.userType = userType;
	}


	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}


	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}


	public String getBank() {
		return bank;
	}


	public void setBank(String bank) {
		this.bank = bank;
	}


	public boolean isShowBank() {
		return showBank;
	}


	public void setShowBank(boolean showBank) {
		this.showBank = showBank;
	}


	public String getCc() {
		return cc;
	}


	public void setCc(String cc) {
		this.cc = cc;
	}


	public String getType() {
		return type;
	}


	public void setType(String type) {
		this.type = type;
	}
}
