package trigger_package;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRaviK;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

public class ptpSchedularJob implements Job {

    public void execute(JobExecutionContext context)
            throws JobExecutionException {
    	DataBaseMethods db = new DataBaseMethods();
       // System.out.println("========== PTP SCHEDULER START ==========");

        Connection conn = null;

        try {

            conn = DataBaseConnection.JAVAConnection();

            List<Integer> branchList = new ArrayList<Integer>();

            DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();

            // Get all branches
            branchList = new DataBaseMethods().branchListAll(conn);
            
            for (int i = 0; i < branchList.size(); i++) {
                int branchId = branchList.get(i);

				//System.out.println("PTP Scheduler Running For Branch = " + branchId);
				int result = dbrk.updateBrokenPtp(branchId, conn);

				//System.out.println("Broken PTP Count For Branch " + branchId + " = " + result);
				
            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }

      //  System.out.println("========== PTP SCHEDULER END ==========");
    }
}