<?php
include('lib/config.php');
$qry= "SELECT form_no,enrollment_no From enrollment_report";
$res = $db->ExecuteQuery($qry);
//$count = 0;
while(list($form_no,$enrollment_no) = $res->FetchAsArray()){

  if ($enrollment_no == ""){
      $batch_no = $db->GetSingleRecord("SELECT s.batch_no FROM Students s INNER JOIN enrollment_report er ON s.form_no = er.form_no WHERE s.form_no = '".$form_no."'");
      $campus = $db->GetSingleRecord("SELECT s.campus FROM Students s INNER JOIN enrollment_report er ON s.form_no = er.form_no WHERE s.form_no = '".$form_no."'");
      $trade = $db->GetSingleRecord("SELECT s.trade FROM Students s INNER JOIN enrollment_report er ON s.form_no = er.form_no WHERE s.form_no = '".$form_no."'");
//     $form_no = $db->GetSingleRecord("SELECT s.form_no FROM Students s INNER JOIN enrollment_report er ON s.form_no = er.form_no WHERE er.enrollment_no = '".$enrollment_no."'");

    $chk_status = $db->GetSingleRecord("Select status from cron_log where where batch = '".$batch_no."' AND campus = '".$campus."' AND program = '".$trade."'");

    if(!$chk_status){
    $sql1 = "Select last_date from admission_setup where batch = '".$batch_no."' AND campus = '".$campus."' AND program = '".$trade."'";
//     echo $sql1;
     $res1	=$db->ExecuteQuery($sql1);
    list($last_date) = $res1->FetchAsArray();
    $arr = explode('-', $last_date);
    $newDate = $arr[2].'-'.$arr[0].'-'.$arr[1];
//       echo date("Y-m-d", strtotime($newDate)) < date('Y-m-d');
      if(date("Y-m-d", strtotime($newDate)) < date('Y-m-d')){
//         echo "Select COUNT(*) from Students where trade = '".$trade."' AND campus = '".$campus."' AND form_no NOT IN (SELECT form_no from enrollment_report where enrollment_no = '')<br>";
        $endloop = false;
        //while loop
          $student_trade_count = $db->GetSingleRecord("Select COUNT(*) from Students where trade = '".$trade."' AND campus = '".$campus."' AND form_no NOT IN (SELECT form_no from enrollment_report where enrollment_no = '')");
          $student_campus_count = $db->GetSingleRecord("Select COUNT(*) from Students where campus = '".$campus."' AND form_no NOT IN (SELECT form_no from enrollment_report where enrollment_no = '')");
          $institute_code = $db->GetSingleRecord("select code from institute_info where abbreviation = '".$campus."'");
          $programe_code = $db->GetSingleRecord("select code from add_setup where name = 'program' AND value = '".$trade."'");
        while(!$endloop){
         $student_trade_count++;
         $student_trade_count = sprintf("%04d", $student_trade_count);
         $student_campus_count++;
         $student_campus_count = sprintf("%05d", $student_campus_count);
         $enrollment_no = $institute_code."-".$programe_code."-".$student_trade_count."-".$student_campus_count;
        if($db->GetSingleRecord("select count(*) from enrollment_report where enrollment_no = '".$enrollment_no."'") < 1){
         $endloop = true;
         $db->ExecuteQuery("delete from enrollment_report where form_no = ".$form_no);
         $db->ExecuteQuery("Insert into enrollment_report(`form_no`, `enrollment_date`, `enrollment_no`) Values(".$form_no.",NOW(),'".$enrollment_no."')");
         echo $form_no." - ".$enrollment_no." updated ! <br>";
         if($db->GetSingleRecord("select count(*) from cron_log where campus = '".$campus."'AND batch = '".$batch_no."' AND program = '".$trade."'") > 0){
          $db->ExecuteQuery("delete from cron_log where campus = '".$campus."'AND batch = '".$batch_no."' AND program = '".$trade."'");
        }
          $db->ExecuteQuery("insert into cron_log(`status`,`batch`,`campus`,`program`) values('1','".$batch_no."','".$campus."','".$trade."')");
        }
       }//end while
      }
   }
  }
 }

//           $db->ExecuteQuery("insert into cron_log(`status`,`batch`,`campus`,`program`) values('1','".$batch_no."','".$campus."','".$trade."')");
?>