/*package other_package;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collections;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.concurrent.TimeUnit;

import javax.faces.application.FacesMessage;
import javax.faces.context.FacesContext;

import report_package.DataBaseReportMethods;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.SavingAccountInfo;

public class MyTest4 
{
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	public static void main(String[] args) 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		Date startDate=new Date();
		Date endDate=new Date();
		startDate.setDate(1);
		
		Timestamp dtm1=new Timestamp(startDate.getTime());
		Timestamp dtm2=new Timestamp(endDate.getTime());
		dtm1.setHours(0);dtm1.setMinutes(0);dtm1.setSeconds(0);dtm1.setNanos(0);
		dtm2.setHours(0);dtm2.setMinutes(0);dtm2.setSeconds(0);dtm2.setNanos(0);
		
		ArrayList<SavingAccountInfo> list=DataBaseReportMethods.allPromotorsAccounts(conn);
		
		for(SavingAccountInfo aa: list)
		{
			double amount=0;
			double interestAmount=0;
			double finalAmount=0;double finalTotal=0;double accBalance=0;
			
			ArrayList<SavingAccountInfo> depositAmount=new ArrayList<>(),withdrwalAmount=new ArrayList<>(),finalList=new ArrayList<>();
			withdrwalAmount=returnCapitalBetweenDate(aa.getAccountNo(), dtm1,dtm2,conn);                  	
			depositAmount=addCapitalBetweenDate(aa.getAccountNo(),dtm1,dtm2,conn);
			
			SavingAccountInfo oo=new SavingAccountInfo();
			oo.setEntryDate(dtm1);
			oo.setAccountNo(aa.getAccountNo());
			oo.setStatus("deposit");
			oo.setFinalAmount(aa.getPaidAmount());
			finalList.add(oo);
		     
			
			
			finalList.addAll(depositAmount);
			finalList.addAll(withdrwalAmount);
			Collections.sort(finalList); 

			SavingAccountInfo ii=new SavingAccountInfo();
			ii.setEntryDate(dtm2);
			ii.setAccountNo(finalList.get(0).getAccountNo());
			ii.setStatus("deposit");
			ii.setFinalAmount(0);
			finalList.add(ii);
			
			
			for(int i=0;i<finalList.size();i++)
			{
				if(i!=0)
				{
					if(finalList.get(i-1).getStatus().equals("withdrwal"))
					{
						amount-=finalList.get(i-1).getFinalAmount();
					}
					else
					{
						amount+=finalList.get(i-1).getFinalAmount();
					}
					
					long day=getDifferenceDays(finalList.get(i-1).getEntryDate(), finalList.get(i).getEntryDate());
					for(long k=1;k<=day;k++)
					{
						interestAmount=(amount*1*aa.getInterest())/36500;
						if(intrType.equalsIgnoreCase("Daily Compound"))
						{
							amount=amount+interestAmount;
						}
						finalAmount+=interestAmount;
					}
					
					System.out.println(i+"...."+day+"...."+finalList.get(i-1).getEntryDate()+"...."+finalList.get(i-1).getStatus()+"...."+amount+"...."+finalAmount);
				}
			}
			System.out.println("ffffff"+finalAmount);
		}
	
		 try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static long getDifferenceDays(Date d1, Date d2) 
	{
		long diff = d2.getTime() - d1.getTime();
		return (TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
	}
	
	public static ArrayList<SavingAccountInfo> returnCapitalBetweenDate(String pId, Timestamp date1, Timestamp date2, Connection conn) 
	{
		 ArrayList<SavingAccountInfo> list=new ArrayList<>(); 
		 Statement stt=null;
		 ResultSet ss=null;
		 try
         {
			stt=conn.createStatement();
			String query="select *,sum(amount) as totalAmount from return_promotors_capital where chequeStatus='cleared' and promotor_id='"+pId+"' and income_date between '"+date1+"' and '"+date2+"' group by income_date";
			ss=st.executeQuery(selectQueWithBranch(query,branchId));
			 while(ss.next())
			 {
				SavingAccountInfo info=new SavingAccountInfo();
			    info.setAccountNo(ss.getString("promotor_id"));
			    info.setEntryDate(ss.getDate("income_date"));
			    info.setAmount(ss.getDouble("amount"));
			    info.setFinalAmount(ss.getDouble("totalAmount"));
			    info.setStatus("withdrwal");
		        list.add(info);
			 }
         }
         catch (Exception e) 
         {
        	 e.printStackTrace();
         }
		 finally
 			{
 			try {
 				if(stt!=null)
 				{
 					stt.close();
 				}
 				if(ss!=null)
 				{
 					ss.close();
 				}
 			} catch (Exception e2) {
 				// TODO: handle exception
 		
 			}
 		}

		 return list;
	}

	public static ArrayList<SavingAccountInfo> addCapitalBetweenDate(String pId, Timestamp date1, Timestamp date2, Connection conn) 
	{
		 ArrayList<SavingAccountInfo> list=new ArrayList<>(); 
		 Statement stt=null;ResultSet ss=null;
		 try
         {
			  stt=conn.createStatement();
			 String query="select *,sum(amount) as totalAmount from promotors_capital where chequeStatus='cleared' and (type='Deposit' or type='deposit') and promotor_id='"+pId+"' and income_date between '"+date1+"' and '"+date2+"' group by income_date";
			 System.out.println(query);
			 ss=st.executeQuery(selectQueWithBranch(query,branchId));
			 while(ss.next())
			 {
				SavingAccountInfo info=new SavingAccountInfo();
			    info.setAccountNo(ss.getString("promotor_id"));
			    info.setEntryDate(ss.getDate("income_date"));
			    info.setAmount(ss.getDouble("amount"));
			   	info.setFinalAmount(ss.getDouble("totalAmount"));
			    info.setStatus("deposit");
		        list.add(info);
			 }
         }
         catch (Exception e) 
         {
        	 e.printStackTrace();
         }finally
 		{
 			try {
 				if(stt!=null)
 				{
 					stt.close();
 				}
 				if(ss!=null)
 				{
 					ss.close();
 				}
 			} catch (Exception e2) {
 				// TODO: handle exception
 		
 			}
 		}
		 return list;
	}

}
*/