index.php

<?php

//Set the session timeout for 2 seconds

$timeout = 3600;

//Set the maxlifetime of the session

ini_set( "session.gc_maxlifetime", $timeout );

//Set the cookie lifetime of the session

ini_set( "session.cookie_lifetime", $timeout );

  session_start();
  
$s_name = session_name();

$url1=$_SERVER['REQUEST_URI'];
    header("Refresh: 3700; URL=$url1");
//Check the session exists or not

if(isset( $_COOKIE[ $s_name ] )) {


    setcookie( $s_name, $_COOKIE[ $s_name ], time() + $timeout, '/' );

    // echo "Session is created for $s_name.<br/>";

}

else

    echo "Session is expired.<br/>";

  include ("./connection.php");
  include ("./holidays.php");



   $dateNewTodayforMonday = new DateTime();

                $dateNewTodayFormat  = $dateNewTodayforMonday->format('D'); 
                if ($dateNewTodayFormat == 'Mon') {
                  //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
                   $lastMonday = $dateNewTodayforMonday->format('Y-m-d');
                    
                     }
                     else if($dateNewTodayFormat == 'Sun'){
                       $dateNewTodayforMonday->modify('next monday');
                      //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
                       $lastMonday = $dateNewTodayforMonday->format('Y-m-d');
                 
                     }
                     else{
                      $dateNewTodayforMonday->modify('last monday');
                      // $startDATE =  $StartDateSelected->format('Y-m-d'); 
                      $lastMonday = $dateNewTodayforMonday->format('Y-m-d');
                 
                     }
                     $start = new DateTime($lastMonday);
                     $end = new DateTime();
                     $end->modify('+1 day');
                     // echo date('F j, Y');
                     $interval = $end->diff($start);
                     
                     // total days
                     $noOfLateFromLastMonday = $interval->days;
                     // echo $days;
                     // create an iterateable period of date (P1D equates to 1 day)
                     $period = new DatePeriod($start, new DateInterval('P1D'), $end);

                     foreach($period as $dt) {
                      $curr = $dt->format('D');
        
                      // substract if Saturday or Sunday
                      if ($curr == 'Sat' || $curr == 'Sun') {
                        $noOfLateFromLastMonday--;
                      }
        
                      // (optional) for the updated question
                      elseif (in_array($dt->format('Y-m-d'), $holidays)) {
                        $noOfLateFromLastMonday--;
                      }
                  }
                  if($noOfLateFromLastMonday >2){
                      $pointFive=0;
                  }

                  // echo $pointFive;
                  // echo "<br>";
                  // echo $noOfLateFromLastMonday;

  $holidays = array('2022-04-14', '2022-04-15', '2022-05-09','2022-08-17','2022-08-29','2022-10-31','2022-11-01','2022-11-30','2022-12-08','2022-12-23','2022-12-26','2022-12-27','2022-12-28','2022-12-29','2022-12-30','2023-01-01','2023-01-02','2023-01-03');
  $yearNow='2023';
  $end = new DateTime('2023-04-03');
$start = new DateTime($yearNow.'-04-01');
$end->modify('+1 day');
$interval = $end->diff($start);
// total days
$finalDiff = $interval->days;
$period = new DatePeriod($start, new DateInterval('P1D'), $end);
foreach($period as $dt) {
  $curr = $dt->format('D');

  // substract if Saturday or Sunday
  if ($curr == 'Sat' || $curr == 'Sun') {
    $finalDiff--;
  }

  // (optional) for the updated question
  else if (in_array($dt->format('Y-m-d'), $holidays)) {
    $finalDiff--;
  }
}
// echo $finalDiff;
//   $dateOfNow = new DateTime(date('Y-m-d'));
//   $MonthOfNow =  $dateOfNow->format('F');
//   $YearToUseForApril = "";
//   $YearToUseforMarch = "";
//   if($MonthOfNow=="January" || $MonthOfNow=="February" || $MonthOfNow=="March"){

//     $YearToUseforMarch =  $dateOfNow->format('Y');
//     $dateOfNow->modify('last year');
//     $YearToUseForApril =  $dateOfNow->format('Y');
//   }
//   else{
//     $YearToUseForApril =  $dateOfNow->format('Y');
// $dateOfNow->modify('next year');
// $YearToUseforMarch =  $dateOfNow->format('Y');


//   }

//   $April = new DateTime($YearToUseForApril.'-04-01');
//   $March = new DateTime($YearToUseforMarch.'-03-31');
//   $April =  $April->format('Y-m-d');
//   $March =  $March->format('Y-m-d');
// // echo "asf";
// // echo $April;
// // echo "<br>";
// // echo $March;
//   // $April = $fDateOfTheMonth = new DateTime('last April');
// $january = new DateTime('2010-01-01');
// $february = new DateTime('2010-02-01');
// $interval = $february->diff($january);

// // %a will output the total number of days.
// // echo $interval->format('%R %a total days')."\n";

// // // While %d will only output the number of days not already covered by the
// // // month.
// // echo $interval->format('%m month, %d days');


// $date = new DateTime('2022-08-18');
// $date->modify('next year');
// $nextYearSample =  $date->format('Y');
// // echo $nextYearSample;
// $date = new DateTime($nextYearSample.'-03-01');
// $nextYearMarch =  $date->format('Y-m-d');
// // echo $nextYearMarch;
// $end = new DateTime(date('Y-m-d'));
// $start = new DateTime($nextYearMarch);

// $end->modify('+1 day');
// $interval = $end->diff($start);
// echo "<br>";
// // echo $interval->days;
// $finalDiff =  $interval->format('%R%a')."\n";
// // echo $daysInterval;
// // $finalDiff = $interval->days;
// echo "<br>";

// echo $finalDiff ;
// echo "<br>";
// if($finalDiff<0){
//   $period = new DatePeriod($start, new DateInterval('P1D'), $end);

//   foreach($period as $dt) {
//       $curr = $dt->format('D');
  
//       if ($curr == 'Sat' || $curr == 'Sun') {
//         $finalDiff++;
//       }
  
//       elseif (in_array($dt->format('Y-m-d'), $holidays)) {
//         $finalDiff++;
//       }
//   }
// }
// else{
// $period = new DatePeriod($start, new DateInterval('P1D'), $end);

// foreach($period as $dt) {
//     $curr = $dt->format('D');

//     if ($curr == 'Sat' || $curr == 'Sun') {
//       $finalDiff--;
//     }

//     elseif (in_array($dt->format('Y-m-d'), $holidays)) {
//       $finalDiff--;
//     }
// }
// }echo $finalDiff;

// if($finalDiff <=-2){
//   echo '<span id = "doneORnot" >Unaccomplished</span>';
//     }
//     else if($finalDiff >=0){
//   echo '<span id = "doneORnot" >Pending</span>';
//     }
//     else if($finalDiff ==-1){
//       echo '<span></span><span id = "doneORnot" >!Pending</span>';
//         }


// echo 3-5;
  // $StartDateSelected = new DateTime('2022-07-28');
  // $startDATE =  $StartDateSelected->format('Y-m-d'); 
  // $startDAY=  $StartDateSelected->format('D'); 


  // if ($startDAY == 'Mon') {
  // $startDATE =  $StartDateSelected->format('Y-m-d'); 
   
  //   }
  //   else if($startDAY == 'Sun'){
  //     $StartDateSelected->modify('next monday');
  //     $startDATE =  $StartDateSelected->format('Y-m-d'); 

  //   }
  //   else{
  //    $StartDateSelected->modify('last monday');
  //    $startDATE =  $StartDateSelected->format('Y-m-d'); 

  //   }
  //   echo $startDATE;
//   $today = $_SESSION['today'];
//   date_default_timezone_set("Asia/Singapore");
// echo date('Y-m-d');

//   $timenowForSameId = date("h:i");       
//   $realDateForSameId =  new DateTime($today);
//    $curr = $realDateForSameId->format('Y-m-d');

//   $sameID=$timenowForSameId . $curr;
// echo $sameID;

  for($i=2; $i >= 0; $i--){
    echo "<script> console.log('ced:$i') </script>";
  }
  // echo $_SESSION['TaskID'];
// echo date("Y-m-d", strtotime("monday last week"));
// echo date("F", strtotime("previous month"));
// echo  $sundaylw =  date("Y-m-d", strtotime("sunday last week"));
// echo weekOfMonth($_SESSION['date_string']);
$start = new DateTime('2022-07-08');
$end = new DateTime('2022-07-18');
// otherwise the  end date is excluded (bug?)
$end->modify('+1 day');
// echo date('F j, Y');
$interval = $end->diff($start);

// total days
$days = $interval->days;
// echo $days;
// create an iterateable period of date (P1D equates to 1 day)
$period = new DatePeriod($start, new DateInterval('P1D'), $end);

// best stored as array, so you can add more than one
// $holidays = array('2022-07-15');
// $holidays = $holidaysArray;

foreach($period as $dt) {
    $curr = $dt->format('D');

    // substract if Saturday or Sunday
    if ($curr == 'Sat' || $curr == 'Sun') {
        $days--;
        // echo $days;
    }

    // (optional) for the updated question
    else if (in_array($dt->format('Y-m-d'), $holidays)) {
        $days--;
    }
}


 //echo $days-2; // return difference except weekends

  ?>

<!DOCTYPE html>
<html>
    <head>
    <meta charset="UTF-8">
    <!-- <meta name="viewport" contant="width=device-width, initial-scale=1.0"> -->
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" >
    <title>Main Page</title>
    <link rel="icon" type="image/x-icon" href="design_files/images/Task Monitoring Icon.ico">

     <link rel="stylesheet" href="font-awesome-4.7.0/css/font-awesome.min.css">
    <!-- MATERIAL DESIGN ICONIC FONT -->
    <link rel="stylesheet" href="design_files/fonts/material-design-iconic-font/css/material-design-iconic-font.min.css">
    <link rel="stylesheet" href="design_files/css/bootstrap.min.css">
    <link rel="stylesheet" href="bootstrap-5.1.3-dist/bootstrap-5.1.3-dist/css/bootstrap.min.css">
    <link rel="stylesheet" href="fontawesome-free-5.15.3-web/fontawesome-free-5.15.3-web/css/all.css">
       <link rel="stylesheet" href="design_files/css/MainPageStyle.css">
    <link rel="stylesheet" href="design_files/css/ListOfMembersStyle.css">

    <script type="text/javascript" src="./js/jquery.slim.min.js"></script>
    <script type="text/javascript" src="./design_files/css/bootstrap.min.js"></script>

    <script src="./node_modules/sweetalert2/dist/sweetalert2.all.min.js"></script>
<link rel="stylesheet" href="./node_modules/sweetalert2/dist/sweetalert2.min.css">

</head>
    <body style="background: #134E5E;  /* fallback for old browsers */
background: -webkit-linear-gradient(to right, #71B280, #134E5E);  /* Chrome 10-25, Safari 5.1-6 */
background: linear-gradient(to right, #71B280, #134E5E); /* W3C, IE 10+/ Edge, Firefox 16+, Chrome 26+, Opera 12+, Safari 7+ */
">

<?php

  date_default_timezone_set("Asia/Singapore");
  $db= $con;

  $query = "SELECT * FROM `holidays`;";
  $result = mysqli_query($con, $query);
  $holidaysArray = array();
  if(mysqli_num_rows($result)>0){
  while($row = mysqli_fetch_assoc($result)){
    $holidaysArray[]=$row;
  }
  }

  $from=date_create(date('Y-m-d'));
$to=date_create("2022-06-27");
$diff=date_diff($to,$from);
// print_r($diff);
// echo $diff->format('%R%a');

// $n1 = $diff->format('%R%a');
// $n2 = 3;
// echo "kasj";
// echo $n1 + $n2;
// if($n1>1){
//   echo "hello";
// }


$tableName="usertask";
    if(!isset( $_SESSION['connected'])){
    

      header("location: signin.php");
  
      // 
    }
    $timestamp = strtotime(date('Y-m-d'));
    //  echo date('l', $timestamp);

     $datess = 'April 26, 2022';
// echo date('Y-m-d', strtotime($datess));

$timenow = date("h:i a");  
    

echo("<script>console.log('Time Now: " .$timenow. "');</script>");

// $PassContainer ="";
$message = ''; 
$newFileName = '';
$varAlert = '';
// if (isset($_POST['uploadBtn']) && $_POST['uploadBtn'] == 'Upload')
// {
//   echo "<script> console.log('uploadddddd'); </script>";
//   echo "ajsdghasd";
// }
if (isset($_POST['uploadBtn']) && $_POST['uploadBtn'] == 'Upload')
{
  // echo "<script> console.log('uploadddddd'); </script>";
  // $IDCONTAINER = $_POST['idContainer'];
  if (isset($_FILES['uploadedFile']) && $_FILES['uploadedFile']['error'] === UPLOAD_ERR_OK){
    // get details of the uploaded file
    
    $fileTmpPath = $_FILES['uploadedFile']['tmp_name'];
    $fileName = $_FILES['uploadedFile']['name'];
    $fileSize = $_FILES['uploadedFile']['size'];
    $fileType = $_FILES['uploadedFile']['type'];
    $fileNameCmps = explode(".", $fileName);
    $fileExtension = strtolower(end($fileNameCmps));
 
    // sanitize file-name
  
  $newFileName = md5(time() . $fileName) . '.' . $fileExtension;
    echo("<script>console.log('FILE NAME: " .$GLOBALS["newFileName"]. "');</script>");
   
    // check if file has one of the following extensions
    $allowedfileExtensions = array('jpg', 'gif', 'png', 'zip', 'txt', 'xls', 'doc', 'pdf','xlsx', 'csv', 'docx');
 
    if (in_array($fileExtension, $allowedfileExtensions))
    {
      // directory in which the uploaded file will be moved
      $uploadFileDir = './uploaded_files/';
      $dest_path = $uploadFileDir . $newFileName;
      echo("<script>console.log('FILE LOCATION: " .$dest_path . "');</script>");
     
      $_SESSION['newFileLoc'] = $dest_path;
      
      if(move_uploaded_file($fileTmpPath, $dest_path)) 
      {
        $varAlert = "success";
        // $PassContainer = $IDCONTAINER;
        $message ='File is successfully uploaded.';
        $_SESSION['newFileLoc'] = $dest_path;
      }
      else
      {
        $message = 'There was some error moving the file to upload directory. Please make sure the upload directory is writable by web server.';
      }
    }
    else
    {
      $message = 'Upload failed. Allowed file types: ' . implode(',', $allowedfileExtensions);
    }
  }
  else
  {
    $message = 'There is some error in the file upload. Please check the following error.<br>';
    $message .= 'Error:' . $_FILES['uploadedFile']['error'];
  }
}
$dateToPass = "";
$date_string= date("Y-m-d");
$_SESSION['message'] = $message;
$today=date('Y-m-d');
$month = date("F");
$year = date("Y");
$dateForToday = new DateTime($date_string);
$weekNumber = $dateForToday->format("W");
$week = 'week '.$weekNumber;
$dateNow = date('Y-m-d');

$taskfocus = "false";
$todaySession = $_SESSION['today'];
$reasonSession = $_SESSION['reason'];

if(isset($_POST['submitdate'])){
  $datePicker = $_POST['datepicker'];

   $month = date('F', strtotime($datePicker));
   $year = date('Y', strtotime($datePicker));
   $today = date('Y-m-d', strtotime($datePicker));
  //  echo  $today;
   $_SESSION['today'] = $today;
$todaySession = $_SESSION['today'];
// echo  $todaySession;
   $_SESSION['month'] = $month ;
   $_SESSION['year'] = $year;
   $datePickerget = $datePicker;
   $date_string= date('Y-m-d', strtotime($datePickerget));
   $_SESSION['date_string'] = $date_string;
$week = 'week '.weekOfMonth($date_string);
 $dateToPass = date('Y-m-d', strtotime($datePicker));
 $taskfocus = "true";

   }

   
 



   if(isset($_POST['testing'])){
    echo "<script>
    $('#reasonModal').modal('show');
    </script>";
 }



 $newFileName = '';
    if(isset($_GET['Finish'])){

$reason = $_SESSION['reason'];
$action = $_SESSION['action'];
echo str_replace("'","\'",$action);
echo "There is an error. Please contact the developer. ";
// echo $_FILES['uploadedFile']['tmp_name']
      // if (!file_exists($_FILES['uploadedFile']['tmp_name']) || !is_uploaded_file($_FILES['uploadedFile']['tmp_name'])) {

        $date_string= date("Y-m-d");
        echo("<script>console.log('Week: " . weekOfMonth($date_string) . "');</script>");
        $taskID = $_GET['Finish'];
        echo("<script>console.log('USer Task Id: " .$taskID . "');</script>");


      
        // $sqlinsert = "INSERT INTO `finishedtask`(`userid`, `username`, `taskName`, `taskCategory`, `taskType`) VALUES ('$resultUserId1','$enteredUserName','$taskname','$taskCategory','$taskType');";
        $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
        $result = mysqli_query($con, $selectUserTask);
        
        while($userRow = mysqli_fetch_assoc($result)){
          $usertaskID = $userRow['usertaskID'];
          $taskType = $userRow['taskType'];
          $taskCategory = $userRow['taskCategory'];
          $taskName = $userRow['taskName'];
          $incharge = $userRow['username'];
          $department = $userRow['Department'];
          
        }

        $ended = false;
        $dateforToday = date('Y-m-d');
        $selectUserTask2 = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
        $result2 = mysqli_query($con, $selectUserTask2);

        while($userRow = mysqli_fetch_assoc($result2)){
          $dateTarget2 = $userRow['targetDate'];
        }
        if($dateforToday >= $dateTarget2){ 

          $ended = true;
        }
// echo $taskType;
        if($taskType == "weekly"){
          try{
          // echo "orayt";

          $mondaylw =  date("Y-m-d", strtotime("monday last week"));
          $sundaylw =  date("Y-m-d", strtotime("sunday last week"));
              //echo "merom";
          $meronBaSiyaLastWeek = "SELECT * FROM `finishedtask` WHERE `taskID` = '$taskID' AND `realDate` BETWEEN '$mondaylw' AND '$sundaylw';";
          // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
          $result = mysqli_query($con, $meronBaSiyaLastWeek);
          $meron = mysqli_num_rows($result);
          $IntervalDays = $_SESSION['noOfDaysLate'];
          echo "<script> console.log('$meron') </script>";//find2
          if($IntervalDays <=0 ){
            // echo "meron";
            if($_SESSION['newFileLoc'] ==""){
              $fileloc ="" ;
            }
            else{
              $fileloc = $_SESSION['newFileLoc'];
            }
              //echo "merom";
              
    
              $today = $_SESSION['today'];

              $dateNewToday = new DateTime($today);
                $weekNumberNew = $dateNewToday->format("W");
                $dateNewTodayFormat  = $dateNewToday->format('D'); 
                $lastMonday  = $dateNewToday->format('Y-m-d'); 

                $week = 'week '.$weekNumberNew;
              // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
              $from=date_create(date('Y-m-d'));
              $to=date_create(date('Y-m-d', strtotime($today)));
              $diff=date_diff($to,$from);
              // print_r($diff);
              // $finalDiff =  $diff->format('%R%a');
              $finalDiff = "0";
              $realDate = date('Y-m-d', strtotime($today));
    
    $myReason = $_SESSION['reason'];

    if ($dateNewTodayFormat == 'Mon') {
      //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
       $lastMonday = $dateNewToday->format('Y-m-d');
        
         }
         else if($dateNewTodayFormat == 'Sun'){
          //  $StartDateSelected->modify('next monday');
           $dateNewToday->modify('next monday');

          //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
           $lastMonday = $dateNewToday->format('Y-m-d');
     
         }
         else{
          // $StartDateSelected->modify('last monday');
          $dateNewToday->modify('last monday');

          // $startDATE =  $StartDateSelected->format('Y-m-d'); 
          $lastMonday = $dateNewToday->format('Y-m-d');
     
         }
         $dateSubmitted = date('Y-m-d');
        $timenowForSameId = date("h-i");       
        $realDateForSameId = $dateSubmitted;     
        $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $myReason;
        // $dateSubmitted = date('Y-m-d');


              $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `weekNumber` ,`lastMonday`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week', '$weekNumberNew', '$lastMonday','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1', false);";
             $insert1 =  mysqli_query($con, $sqlinsert);
             if($insert1){
              $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
              mysqli_query($con, $updateDateStarted);
              header("location:index.php");
              unset($_SESSION['newFileLoc']);
              $_SESSION['reason'] = "";
              $_SESSION['action'] = "";

              $_SESSION['noOfDaysLate']="";

             }
             
          }
          else if($IntervalDays >0) {//find3
          
            if($_SESSION['newFileLoc'] ==""){
              $fileloc ="" ;
            }
            else{
              $fileloc = $_SESSION['newFileLoc'];
            }

              $arrayWeekNumbers=array();
              $arrayMondays=array();
              $arrayNoOfDaysLate=array();


              $arrayMonth=array();
              $arrayYear=array();

              $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
              $result = mysqli_query($con, $selectUserTask);
    
              while($userRow = mysqli_fetch_assoc($result)){
                $dateStarted = $userRow['dateStarted'];
              }
    
              $date = new DateTime($dateStarted);
              // echo "Next monday is: ";
              $date->modify('next monday');
              // $date->format('Y-m-d');
              $startDate = $date->format('Y-m-d');
              $start = new DateTime($startDate);
              $end = new DateTime();
              // otherwise the  end date is excluded (bug?)
              $end->modify('+1 day');
              // echo date('F j, Y');
              $interval = $end->diff($start);
              
              // total days
              $days = $interval->days;
              // echo $days;
              // create an iterateable period of date (P1D equates to 1 day)
              $period = new DatePeriod($start, new DateInterval('P1D'), $end);
              
              // best stored as array, so you can add more than one
              // $holidays = array('2022-07-15');
              // $holidays = $holidaysArray;

              $weekNo ="";
              $NumberOfWeeksToDone = 0;
              foreach($period as $dt) {
                  $curr = $dt->format('W');
                  $currMonth = $dt->format('F');
                  $currYear = $dt->format('Y');
                  $monday = $dt->format('Y-m-d');

                  if($curr==$weekNo){
                    echo null;
                  }
                  else{
                    $NumberOfWeeksToDone = $NumberOfWeeksToDone +1;
                    array_push($arrayWeekNumbers,"$curr");
                    array_push($arrayMondays,"$monday");
                    array_push($arrayMonth,"$currMonth");
                    array_push($arrayYear,"$currYear");


                    // echo $curr;
                    echo "\n";
                    $weekNo = $curr;
                  }
              }


$arrlength = count($arrayWeekNumbers);

for($x = 0; $x <$arrlength; $x++) {
  // echo $cars[$x];
          
    //ito ang gayahan
              $today = $_SESSION['today'];
              $dateNewToday = new DateTime($today);
              $weekNumberNew = $dateNewToday->format("W");

              $mondayArray = $arrayMondays[$x];
              $dateNewTodayforMonday = new DateTime($mondayArray);

                $dateNewTodayFormat  = $dateNewTodayforMonday->format('D'); 
                $lastMonday  = $dateNewToday->format('Y-m-d'); 
                $weekNumberOrayt = $arrayWeekNumbers[$x];
                $week = 'week '.$arrayWeekNumbers[$x];
                $month = $arrayMonth[$x];
                  $year = $arrayYear[$x];
              // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
              $from=date_create(date('Y-m-d'));
              $to=date_create(date('Y-m-d', strtotime($today)));
              $diff=date_diff($to,$from);
              // print_r($diff);
              // $finalDiff =  $diff->format('%R%a');
              $finalDiff =$IntervalDays; //ibig sabihin late na
              $realDate = date('Y-m-d', strtotime($today));
    
    // $myReason = $_SESSION['reason'];

    $date = new DateTime($today);
    $dateSubmitted = date('Y-m-d');


         $timenowForSameId = date("hi");       
         $realDateForSameId = $dateSubmitted;
         $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $reason;


    $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
              mysqli_query($con, $updateDateStarted);

              $validationVariable = $arrlength-2;
              $validationVar2 = $arrlength-1;

              //find4
                  

              if ($dateNewTodayFormat == 'Mon') {
                //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
                 $lastMonday = $dateNewTodayforMonday->format('Y-m-d');
                  
                   }
                   else if($dateNewTodayFormat == 'Sun'){
                    //  $StartDateSelected->modify('next monday');
                     $dateNewTodayforMonday->modify('next monday');

                    //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
                     $lastMonday = $dateNewTodayforMonday->format('Y-m-d');
               
                   }
                   else{
                    // $StartDateSelected->modify('last monday');
                    $dateNewTodayforMonday->modify('last monday');

                    // $startDATE =  $StartDateSelected->format('Y-m-d'); 
                    $lastMonday = $dateNewTodayforMonday->format('Y-m-d');
               
                   }
              if($x<$validationVariable){
                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`,`sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `weekNumber` , `lastMonday`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week', '$weekNumberOrayt', '$lastMonday', '$fileloc', '$year', '$department', '$finalDiff', '$reason','$action', '$realDate' ,'0', true);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                // echo $_SESSION
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
              }
              else if($x==$validationVariable){
                $pointFive = 0.5;
     
                $dateNewTodayforMondays = new DateTime();

                $dateNewTodayFormats  = $dateNewTodayforMondays->format('D'); 
                if ($dateNewTodayFormats == 'Mon') {
                  //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
                   $lastMondays = $dateNewTodayforMondays->format('Y-m-d');
                    
                     }
                     else if($dateNewTodayFormats == 'Sun'){
                       $dateNewTodayforMondays->modify('next monday');
                      //  $startDATE =  $StartDateSelected->format('Y-m-d'); 
                       $lastMondays = $dateNewTodayforMondays->format('Y-m-d');
                 
                     }
                     else{
                      $dateNewTodayforMondays->modify('last monday');
                      // $startDATE =  $StartDateSelected->format('Y-m-d'); 
                      $lastMondays = $dateNewTodayforMondays->format('Y-m-d');
                 
                     }
                     $starts = new DateTime($lastMondays);
                     $ends = new DateTime();
                     $ends->modify('+1 day');
                     // echo date('F j, Y');
                     $intervals = $ends->diff($starts);
                     
                     // total days
                     $noOfLateFromLastMondays = $intervals->days;
                     // echo $days;
                     // create an iterateable period of date (P1D equates to 1 day)
                     $periods = new DatePeriod($starts, new DateInterval('P1D'), $ends);

                     foreach($periods as $dts) {
                      $currs = $dts->format('D');
        
                      // substract if Saturday or Sunday
                      if ($currs == 'Sat' || $currs == 'Sun') {
                        $noOfLateFromLastMondays--;
                      }
        
                      // (optional) for the updated question
                      elseif (in_array($dts->format('Y-m-d'), $holidays)) {
                        $noOfLateFromLastMondays--;
                      }
                  }
                  if($noOfLateFromLastMondays >2){
                      $pointFive=0;
                  }
                  else{
                    $pointFive=0.5;

                  }

                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`,`sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `weekNumber`, `lastMonday`,`attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week', '$weekNumberOrayt',  '$lastMonday', '$fileloc', '$year', '$department', '$finalDiff', '$reason','$action', '$realDate' ,'$pointFive', true);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
              }
              else if($x==$validationVar2){
                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`,`sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `weekNumber`, `lastMonday`,`attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week', '$weekNumberNew',  '$lastMonday','$fileloc', '$year', '$department', '$finalDiff', '$reason','$action', '$realDate' ,'1', true);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
              }
              
              // $finalDiff =$IntervalDays;
              $IntervalDays = $IntervalDays-5;
              if($IntervalDays <0){
                $IntervalDays = 0;
              }

              
}


    //           $fileloc ="" ;
    
    //           $today = $_SESSION['today'];
    //           $dateNewToday = new DateTime($today);
    //             $weekNumberNew = $dateNewToday->format("W");
    //             $week = 'week '.$weekNumberNew;
    //           // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
    //           $from=date_create(date('Y-m-d'));
    //           $to=date_create(date('Y-m-d', strtotime($today)));
    //           $diff=date_diff($to,$from);
    //           // print_r($diff);
    //           // $finalDiff =  $diff->format('%R%a');
    //           $finalDiff =$IntervalDays; //ibig sabihin late na
    //           $realDate = date('Y-m-d', strtotime($today));
    
    // $myReason = $_SESSION['reason'];
    // $date = new DateTime($today);

    // $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today' WHERE `usertaskID` = '$usertaskID';";
    //           mysqli_query($con, $updateDateStarted);
    //           $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `taskID`, `Date`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`) VALUES ('','$usertaskID',' $today', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason','$action', '$realDate' ,'0.5');";
    //           mysqli_query($con, $sqlinsert);
    //           header("location:index.php");
    //           unset($_SESSION['newFileLoc']);
    //           $_SESSION['reason'] = "";
    //           $_SESSION['noOfDaysLate']="";
    //           $_SESSION['action'] = "";
    
            
          }
        }
        catch (Exception $e){                    
          echo "Error found in finishing weekly task. Please contact your poging developer";
          echo "<br>";
          echo $e;
        }
        }
          
          
        // $today = date("F j, Y");
        // $month = date("F");
        // $year = date("Y");
        // $week = 'week '.weekOfMonth($date_string);
        else if ($taskType == "others"){
          try{
            $IntervalDays = $_SESSION['noOfDaysLate'];
            echo "<script> console.log('$meron') </script>";//find2
            // $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
            //     mysqli_query($con, $updateDateStarted);
            if($IntervalDays ==0 ){
              // echo "meron";
              if($_SESSION['newFileLoc'] ==""){
                $fileloc ="" ;
              }
              else{
                $fileloc = $_SESSION['newFileLoc'];
              }
                //echo "merom";
                
          
                $today = $_SESSION['today'];
                $dateSubmitted = date('Y-m-d');
          
                $dateNewToday = new DateTime($today);
                  $weekNumberNew = $dateNewToday->format("W");
                  $week = 'week '.$weekNumberNew;
                // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
                $from=date_create(date('Y-m-d'));
                $to=date_create(date('Y-m-d', strtotime($today)));
                $diff=date_diff($to,$from);
                // print_r($diff);
                // $finalDiff =  $diff->format('%R%a');
                $finalDiff = "0";
                $realDate = date('Y-m-d', strtotime($today));
          
          $myReason = $_SESSION['reason'];
          $startDateMonth = $dateNewToday->format('F');
          $fDateOfTheMonth = new DateTime('first day of '.$startDateMonth);
                                             
              $firstDateOfTheMonth =  $fDateOfTheMonth->format('Y-m-d');
              $timenowForSameId = date("hi");       
              $realDateForSameId = $dateSubmitted;     
              $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $myReason;
          
          $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='1' WHERE `usertaskID` = '$usertaskID';";
                mysqli_query($con, $updateDateStarted);
                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1', false);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['action'] = "";
          
                $_SESSION['noOfDaysLate']="";
          
              
            }
            else if($IntervalDays >0) {//find3
            
              if($_SESSION['newFileLoc'] ==""){
                $fileloc ="" ;
              }
              else{
                $fileloc = $_SESSION['newFileLoc'];
              }
          //ganito nalang, kapag late automatic dalwa ang malalagay, last year at ngayun
          // kasi siguro naman walang 2 years na late hahaha unless resign na diba
          
          
          
          $today = $_SESSION['today'];
          
          $dateNewToday = new DateTime($today);
          $weekNumberNew = $dateNewToday->format("W");
          $week = 'week '.$weekNumberNew;
          // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
          $from=date_create(date('Y-m-d'));
          $to=date_create(date('Y-m-d', strtotime($today)));
          $diff=date_diff($to,$from);
          // print_r($diff);
          // $finalDiff =  $diff->format('%R%a');
          $finalDiff = "0";
          $realDate = date('Y-m-d', strtotime($today));
          $dateSubmitted = date('Y-m-d');
          $myReason = $_SESSION['reason'];
          $startDateMonth = $dateNewToday->format('F');
          $fDateOfTheMonth = new DateTime('first day of '.$startDateMonth);
                                     
          $firstDateOfTheMonth =  $fDateOfTheMonth->format('Y-m-d');
          $timenowForSameId = date("hi");       
          $realDateForSameId = $dateSubmitted;     
          $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $myReason;
          
          // $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
          // mysqli_query($con, $updateDateStarted);
          // $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1', false);";
          // mysqli_query($con, $sqlinsert);
          // header("location:index.php");
          // unset($_SESSION['newFileLoc']);
          // $_SESSION['reason'] = "";
          // $_SESSION['action'] = "";
          
          // $_SESSION['noOfDaysLate']="";
          
          
          $dateOfTheDay = new DateTime();
          $dateOfTheDays = $dateOfTheDay->format('m-d');
          $yearNow = $dateOfTheDay->format('Y');
          
          
          $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
          $result = mysqli_query($con, $selectUserTask);
          
          while($userRow = mysqli_fetch_assoc($result)){
            $dateTarget = $userRow['targetDate'];
            $dateAdded = $userRow['dateAdded'];
          
          }
          // $today=" March 31, ".$yearNow;
          $today = $_SESSION['today'];
          
          // $today = date('Y-m-d');
          
          $realDate = date('Y-m-d', strtotime($dateTarget));
          
          $end = new DateTime(date('Y-m-d'));
          // $start = new DateTime($yearNow.'-04-01');
          $start = new DateTime($dateTarget);
          
          $end->modify('+1 day');
          $interval = $end->diff($start);
          // total days
          $finalDiff = $interval->days;
          $period = new DatePeriod($start, new DateInterval('P1D'), $end);
          foreach($period as $dt) {
            $curr = $dt->format('D');
          
            // substract if Saturday or Sunday
            if ($curr == 'Sat' || $curr == 'Sun') {
              $finalDiff--;
            }
          
            // (optional) for the updated question
            else if (in_array($dt->format('Y-m-d'), $holidays)) {
              $finalDiff--;
            }
          }
          
            
          if($finalDiff <=2){
          $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`,  `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '0.5', true);";
          mysqli_query($con, $sqlinsert);
          header("location:index.php");
          unset($_SESSION['newFileLoc']);
          $_SESSION['reason'] = "";
          $_SESSION['action'] = "";
          $_SESSION['noOfDaysLate']="";
          
          }
          else{
          $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`,  `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '0', true);";
          mysqli_query($con, $sqlinsert);
          header("location:index.php");
          unset($_SESSION['newFileLoc']);
          $_SESSION['reason'] = "";
          $_SESSION['action'] = "";
          $_SESSION['noOfDaysLate']="";
          }
          
          //if april 1 or 2, 0.5, else 0 na tas ang date na ilalagay mo para lang ma read yung year 2022 ay march 31 2022. for basis only. PEro lalagyan mo parin ng date submitted.
          
          
              
            }
          }
            catch (Exception $e){             
              echo "Error found in finishing annual task. Please contact your poging developer";
              echo "<br>";
              echo $e;
            }
        }
        else if($taskType == "daily"){
try{
          if($_SESSION['newFileLoc'] ==""){
            $fileloc ="" ;
          }
          else{
            $fileloc = $_SESSION['newFileLoc'];
          }
            $today = $_SESSION['today'];
            $dateNewToday = new DateTime($today);
                $weekNumberNew = $dateNewToday->format("W");
                $week = 'week '.$weekNumberNew;
              // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
            $from=date_create(date('Y-m-d'));
            $to=date_create(date('Y-m-d', strtotime($today)));
            $diff=date_diff($to,$from);
            // print_r($diff);
            // $finalDiff =  $diff->format('%R%a');
            $finalDiff =$_SESSION['noOfDaysLate'];
            $realDate = date('Y-m-d', strtotime($today));
  
  // $myReason = $_SESSION['reason'];
  
  if($finalDiff >=2){
    $isLate = true;
     
    $arrayNumberOfDaysPass=array();
    $arrayWeekNumbers=array();
    $arrayMonth=array();
    $arrayYear=array();
    $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
              $result = mysqli_query($con, $selectUserTask);
    
              while($userRow = mysqli_fetch_assoc($result)){
                $dateStarted = $userRow['dateStarted'];
              }
    
              $date = new DateTime($dateStarted);
              // echo "Next monday is: ";
              // $date->format('Y-m-d');
              $startDate = $date->format('Y-m-d');
              $start = new DateTime($startDate);
              // $start->modify('+1 day');
              $eme = $start->format('D');
                    if($eme == "Sat"){
                      $start->modify('-1 day');

                    }
                    else if( $eme =="Sun"){
                      $start->modify('-2 day');
                    }
              $start->modify('+1 day');
                    
              $end = new DateTime();
              // otherwise the  end date is excluded (bug?)
              //  $end->modify('+1 day');
              // echo date('F j, Y');
              $interval = $end->diff($start);
              
              // total days
              $days = $interval->days;
              // echo $days;
              // create an iterateable period of date (P1D equates to 1 day)
              $period = new DatePeriod($start, new DateInterval('P1D'), $end);
              
              // best stored as array, so you can add more than one
              // $holidays = array('2022-07-15');
              // $holidays = $holidaysArray;
              $weekNo ="";
              $NumberOfWeeksToDone = 0;
              foreach($period as $dt) {

                $currd = $dt->format('D');

// substract if Saturday or Sunday

                  $curr = $dt->format('W');
                  $date = $dt->format('Y-m-d');
                  $currMonth = $dt->format('F');
                  $currYear = $dt->format('Y');

              $day = $dt->format('D');
                              if($day =="Sat" || $day == "Sun"){
                                // echo "";
                             
                              }
                              else if (in_array($dt->format('Y-m-d'), $holidays)) {
                         
                                
                                }
                              else{
                                array_push($arrayNumberOfDaysPass,"$date");

         
                                // $NumberOfWeeksToDone = $NumberOfWeeksToDone +1;
                                array_push($arrayWeekNumbers,"$curr");
                                array_push($arrayMonth,"$currMonth");
                                array_push($arrayYear,"$currYear");
                              }
                 


         // echo $curr;
                    // echo "\n";
 
                  
              }


$arrlength = count($arrayNumberOfDaysPass);
$arrlengthBasis = count($arrayNumberOfDaysPass);

$selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
$result = mysqli_query($con, $selectUserTask);

while($userRow = mysqli_fetch_assoc($result)){
  $todayss = $userRow['dateStarted'];
}

// $from=date_create(date('Y-m-d'));
// $to=date_create(date('Y-m-d', strtotime($today)));
// $diff=date_diff($to,$from);
// // print_r($diff);
// $finalDiff =  $diff->format('%R%a');
// $finalDiff = $finalDiff-1;

$ends = new DateTime(date('Y-m-d'));
$starts = new DateTime(date('Y-m-d', strtotime($todayss)));
// otherwise the  end date is excluded (bug?)


$eme = $starts->format('D');
      if($eme == "Sat"){
        $starts->modify('-1 day');

      }
      else if( $eme =="Sun"){
        $starts->modify('-2 day');
      }
       $starts->modify('+1 day');
$end = new DateTime();
// $ends->modify('+1 day');

$intervals = $ends->diff($starts);

// total days
$finalDiffs = $intervals->days;

// create an iterateable period of date (P1D equates to 1 day)
$periods = new DatePeriod($starts, new DateInterval('P1D'), $ends);

// best stored as array, so you can add more than one
// $holidays = array('2012-09-07');
// $holidays = $holidaysArray;


foreach($periods as $dts) {
$currs = $dts->format('D');

// substract if Saturday or Sunday
if ($currs == 'Sat' || $currs == 'Sun') {
$finalDiffs--;

}

// (optional) for the updated question
else if (in_array($dts->format('Y-m-d'), $holidays)) {
$finalDiffs--;

}
}
echo " <script>console.log('1. $finalDiffs') </script>";
// $finalDiffs=$finalDiffs-2;
for($x = 0; $x <$arrlength; $x++) {
  // echo $cars[$x];


  echo " <script>console.log('VALUE NG X. $x') </script>";





          //  $fileloc ="" ;
    
              $today = $_SESSION['today'];
              $dateNewToday = new DateTime($today);
                $weekNumberNew = $dateNewToday->format("W");
                $week = 'week '.$arrayWeekNumbers[$x];
                $month = $arrayMonth[$x];
                  $year = $arrayYear[$x];
              // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
              $from=date_create(date('Y-m-d'));
              $to=date_create(date('Y-m-d', strtotime($today)));
              $diff=date_diff($to,$from);
              // print_r($diff);
              // $finalDiff =  $diff->format('%R%a');
              // $finalDiff =$IntervalDays; //ibig sabihin late na
              $realDate = date('Y-m-d', strtotime($today));
    
    // $myReason = $_SESSION['reason'];

    $date = new DateTime($today);


    $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
              mysqli_query($con, $updateDateStarted);

              $validationVariable = $arrlengthBasis-2;
              $validationVar2 = $arrlengthBasis-1;
              echo " <script>console.log('ITO ANG VALUE NG valid. $validationVariable') </script>";

              //find4

              $day1 = $arrayNumberOfDaysPass[$x];

              $dateToConvert = new DateTime($day1);
              $today = $dateToConvert->format('Y-m-d');
              $realDate = $dateToConvert->format('Y-m-d');
                         
              
              $timenowForSameId = date("hi");       
              $realDateForSameId =$dateSubmitted;     
              $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $reason;
                   
              $dateSubmitted = date('Y-m-d');

              if($x<$validationVariable){
              echo " <script>console.log('ITO ANG VALUE NG Xx. $x') </script>";
              echo " <script>console.log('ITO ANG VALUE NG valid. $validationVariable') </script>";


                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`,`taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiffs', '$reason','$action', '$realDate' ,'0', $isLate);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                // echo $_SESSION
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
                $finalDiffs--;
                
              }
              else if($x==$validationVariable){
echo " <script>console.log('2. $finalDiff') </script>";
echo " <script>console.log('ITO ANG VALUE NG y. $x') </script>";

                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`,`taskID`, `Date`,`DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiffs', '$reason','$action', '$realDate' ,'0.5', $isLate);";
                mysqli_query($con, $sqlinsert);
                // header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
                $finalDiffs--;

               
              }
              else if($x==$validationVar2){
echo " <script>console.log('3. $finalDiff') </script>";
echo " <script>console.log('ITO ANG VALUE NG z. $x') </script>";


                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`,`taskID`, `Date`,`DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiffs', '$reason','$action', '$realDate' ,'1', $isLate);";
                mysqli_query($con, $sqlinsert);
                // header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
                $finalDiffs--;

               
              }
                              



  }
  header("location:index.php");

}
  else{

    $isLate = true;
     
    $arrayNumberOfDaysPass=array();
    $arrayWeekNumbers=array();
    $arrayMonth=array();
    $arrayYear=array();
    $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
              $result = mysqli_query($con, $selectUserTask);
    
              while($userRow = mysqli_fetch_assoc($result)){
                $dateStarted = $userRow['dateStarted'];
              }
    
              $date = new DateTime($dateStarted);
              // echo "Next monday is: ";
              // $date->format('Y-m-d');
              $startDate = $date->format('Y-m-d');
              $start = new DateTime($startDate);
              // $start->modify('+1 day');
              $eme = $start->format('D');
                    if($eme == "Sat"){
                      $start->modify('-1 day');

                    }
                    else if( $eme =="Sun"){
                      $start->modify('-2 day');
                    }
              $start->modify('+1 day');
                    
              $end = new DateTime();
              // otherwise the  end date is excluded (bug?)
              //  $end->modify('+1 day');
              // echo date('F j, Y');
              $interval = $end->diff($start);
              
              // total days
              $days = $interval->days;
              // echo $days;
              // create an iterateable period of date (P1D equates to 1 day)
              $period = new DatePeriod($start, new DateInterval('P1D'), $end);
              
              // best stored as array, so you can add more than one
              // $holidays = array('2022-07-15');
              // $holidays = $holidaysArray;

              $weekNo ="";
              $NumberOfWeeksToDone = 0;
              foreach($period as $dt) {

                $currd = $dt->format('D');

// substract if Saturday or Sunday

                  $curr = $dt->format('W');
                  $date = $dt->format('Y-m-d');
                  $currMonth = $dt->format('F');
                  $currYear = $dt->format('Y');

              $day = $dt->format('D');
                              if($day =="Sat" || $day == "Sun"){
                                // echo "";
                             
                              }
                              else if (in_array($dt->format('Y-m-d'), $holidays)) {
                         
                                
                              }
                              else{
                                array_push($arrayNumberOfDaysPass,"$date");

         
                                // $NumberOfWeeksToDone = $NumberOfWeeksToDone +1;
                                array_push($arrayWeekNumbers,"$curr");
                                array_push($arrayMonth,"$currMonth");
                                array_push($arrayYear,"$currYear");
                              }
                 


         // echo $curr;
                    // echo "\n";
 
                  
              }


$arrlength = count($arrayNumberOfDaysPass);
$arrlengthBasis = count($arrayNumberOfDaysPass);

$selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
$result = mysqli_query($con, $selectUserTask);

while($userRow = mysqli_fetch_assoc($result)){
  $todayss = $userRow['dateStarted'];
}

// $from=date_create(date('Y-m-d'));
// $to=date_create(date('Y-m-d', strtotime($today)));
// $diff=date_diff($to,$from);
// // print_r($diff);
// $finalDiff =  $diff->format('%R%a');
// $finalDiff = $finalDiff-1;

$ends = new DateTime(date('Y-m-d'));
$starts = new DateTime(date('Y-m-d', strtotime($todayss)));
// otherwise the  end date is excluded (bug?)


$eme = $starts->format('D');
      if($eme == "Sat"){
        $starts->modify('-1 day');

      }
      else if( $eme =="Sun"){
        $starts->modify('-2 day');
      }
       $starts->modify('+1 day');
$end = new DateTime();
// $ends->modify('+1 day');

$intervals = $ends->diff($starts);

// total days
$finalDiffs = $intervals->days;

// create an iterateable period of date (P1D equates to 1 day)
$periods = new DatePeriod($starts, new DateInterval('P1D'), $ends);

// best stored as array, so you can add more than one
//$holidays = array('2012-09-07');
// $holidays = $holidaysArray;

foreach($periods as $dts) {
$currs = $dts->format('D');

// substract if Saturday or Sunday
if ($currs == 'Sat' || $currs == 'Sun') {
$finalDiffs--;

}

// (optional) for the updated question
else if (in_array($dts->format('Y-m-d'), $holidays)) {
$finalDiffs--;

}
}
echo " <script>console.log('1. $finalDiffs') </script>";
// $finalDiffs=$finalDiffs-2;
for($x = 0; $x <$arrlength; $x++) {
  // echo $cars[$x];


  echo " <script>console.log('VALUE NG X. $x') </script>";





          //  $fileloc ="" ;
    
              $today = $_SESSION['today'];
              $dateNewToday = new DateTime($today);
                $weekNumberNew = $dateNewToday->format("W");
                $week = 'week '.$arrayWeekNumbers[$x];
                $month = $arrayMonth[$x];
                  $year = $arrayYear[$x];
              // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
              $from=date_create(date('Y-m-d'));
              $to=date_create(date('Y-m-d', strtotime($today)));
              $diff=date_diff($to,$from);
              // print_r($diff);
              // $finalDiff =  $diff->format('%R%a');
              // $finalDiff =$IntervalDays; //ibig sabihin late na
              $realDate = date('Y-m-d', strtotime($today));
              $dateSubmitted = date('Y-m-d');
    
    // $myReason = $_SESSION['reason'];

    $date = new DateTime($today);

    $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
              mysqli_query($con, $updateDateStarted);

              $validationVariable = $arrlengthBasis-2;
              $validationVar2 = $arrlengthBasis-1;
              echo " <script>console.log('ITO ANG VALUE NG valid. $validationVariable') </script>";

              //find4

              $day1 = $arrayNumberOfDaysPass[$x];

              $dateToConvert = new DateTime($day1);
              $today = $dateToConvert->format('Y-m-d');
              $realDate = $dateToConvert->format('Y-m-d');
                  
              
              $timenowForSameId = date("hi");       
              $realDateForSameId = $dateSubmitted;     
              $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $reason;


              if($x<$validationVariable){
echo " <script>console.log('ITO ANG VALUE NG Xx. $x') </script>";
echo " <script>console.log('ITO ANG VALUE NG valid. $validationVariable') </script>";


                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`,`taskID`, `Date`,`DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiffs', '$reason','$action', '$realDate' ,'1', false);";
                mysqli_query($con, $sqlinsert);
                // header("location:index.php");
                unset($_SESSION['newFileLoc']);
                // echo $_SESSION
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
                $finalDiffs--;
                
              }
              else if($x==$validationVariable){
echo " <script>console.log('2. $finalDiff') </script>";
echo " <script>console.log('ITO ANG VALUE NG y. $x') </script>";

                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`,`taskID`, `Date`,`DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiffs', '$reason','$action', '$realDate' ,'0.5', true);";
                mysqli_query($con, $sqlinsert);
                // header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
                $finalDiffs--;

               
              }
              else if($x==$validationVar2){
echo " <script>console.log('3. $finalDiff') </script>";
echo " <script>console.log('ITO ANG VALUE NG z. $x') </script>";


                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`,`taskID`, `Date`,`DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiffs', '$reason','$action', '$realDate' ,'1', false);";
                mysqli_query($con, $sqlinsert);
                // header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
                $finalDiffs--;

               
              }
                              



  }
  header("location:index.php");


  }
  $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
            mysqli_query($con, $updateDateStarted);
            
            // $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `taskID`, `Date`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`) VALUES ('','$usertaskID',' $today', '$timenow','$taskName','$incharge','$taskType','$month','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1');";
            // mysqli_query($con, $sqlinsert);
          //  header("location:index.php");//comment

  
          
}

catch (Exception $e){             
  echo "Error found in finishing daily task. Please contact your poging developer";
  echo "<br>";
  echo $e;
}
        }

       else if($taskType == "monthly"){
try{

        $IntervalDays = $_SESSION['noOfDaysLate'];
        echo "<script> console.log('$meron') </script>";//find2
        if($IntervalDays ==0 ){
          // echo "meron";
          if($_SESSION['newFileLoc'] ==""){
            $fileloc ="" ;
          }
          else{
            $fileloc = $_SESSION['newFileLoc'];
          }
            //echo "merom";
            
  
            $today = $_SESSION['today'];

            $dateNewToday = new DateTime($today);
              $weekNumberNew = $dateNewToday->format("W");
              $week = 'week '.$weekNumberNew;
            // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
            $from=date_create(date('Y-m-d'));
            $to=date_create(date('Y-m-d', strtotime($today)));
            $diff=date_diff($to,$from);
            // print_r($diff);
            // $finalDiff =  $diff->format('%R%a');
            $finalDiff = "0";
            $realDate = date('Y-m-d', strtotime($today));
            $dateSubmitted = date('Y-m-d');
  $myReason = $_SESSION['reason'];
  $startDateMonth = $dateNewToday->format('F');
  $fDateOfTheMonth = new DateTime('first day of '.$startDateMonth);
                                         
          $firstDateOfTheMonth =  $fDateOfTheMonth->format('Y-m-d');
          $timenowForSameId = date("hi");       
          $realDateForSameId = $dateSubmitted;     
          $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $myReason;

  $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
            mysqli_query($con, $updateDateStarted);
            $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`,`DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1');";
            mysqli_query($con, $sqlinsert);
            header("location:index.php");
            unset($_SESSION['newFileLoc']);
            $_SESSION['reason'] = "";
            $_SESSION['action'] = "";

            $_SESSION['noOfDaysLate']="";
  
          
        }
        else if($IntervalDays >0) {//find3
        
          if($_SESSION['newFileLoc'] ==""){
            $fileloc ="" ;
          }
          else{
            $fileloc = $_SESSION['newFileLoc'];
          }

            $arrayWeekNumbers=array();
            $arrayMonth=array();
            $arrayFirstDate=array();
            
            $arrayYear=array();
            $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
              $result = mysqli_query($con, $selectUserTask);
    
              while($userRow = mysqli_fetch_assoc($result)){
                $dateStarted = $userRow['dateStarted'];
              }

              $date = new DateTime($dateStarted);
              $date->modify('next month');
              $monthOfDate =  $date->format('F');
              $year =  $date->format('Y');

              $fDateOfTheMonth = new DateTime('first day of '.$monthOfDate. $year);
              $FDateofThisMonth =  $fDateOfTheMonth->format('Y-m-d');

              $lDateOfTheMonth = new DateTime('last day of '.$monthOfDate. $year);
              $LDateofThisMonth =  $lDateOfTheMonth->format('Y-m-d');

              $start = new DateTime($FDateofThisMonth);
              $end = new DateTime();
              $end->modify('+1 day');

              $interval = $end->diff($start);
              
              $days = $interval->days;

              $period = new DatePeriod($start, new DateInterval('P1D'), $end);

              //$holidays = array('2022-07-15');
              // $holidays = $holidaysArray;

              $monthNo ="";
              $NumberOfWeeksToDone = 0;
              foreach($period as $dt) {

                 
                  $curr = $dt->format('F');
                  $currYear = $dt->format('Y');

                  $day =  $dt->format('Y-m-d');
                  $LDateOfTheMonth = new DateTime('last day of '.$curr);
                  $Lday =  $LDateOfTheMonth->format('Y-m-d');
                  $datesss = new DateTime($Lday);
  
                  $weeksss = $datesss->format("W");
                  // echo "Weeknumber: $week";
                  // echo "<br>";
                     

                  $fDateOfTheMonth = new DateTime('first day of '.$curr);
                  $firstDateOfTheMonthOrayt =  $fDateOfTheMonth->format('Y-m-d');
                  if($curr==$monthNo){
                    echo null;
                  }
                  else{
                    $NumberOfWeeksToDone = $NumberOfWeeksToDone +1;
                    array_push($arrayMonth,"$curr");
                    array_push($arrayYear,"$currYear");
                    array_push($arrayWeekNumbers,"$weeksss");
                    array_push($arrayFirstDate, "$firstDateOfTheMonthOrayt");
                    // echo $curr;
                    // echo "\n";
                    $monthNo = $curr;
                  }
              }
              $arrlength = count($arrayMonth);

              
for($x = 0; $x <$arrlength; $x++) {
  // echo $cars[$x];
       
    
              $today = $_SESSION['today'];
              $dateNewToday = new DateTime($today);
                $weekNumberNew = $dateNewToday->format("W");
                $week = 'week '.$arrayWeekNumbers[$x]; //baguhin, dapat ay present week
                $month = $arrayMonth[$x];
                  $year = $arrayYear[$x];
              // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
              $from=date_create(date('Y-m-d'));
              $to=date_create(date('Y-m-d', strtotime($today)));
              $diff=date_diff($to,$from);
              // print_r($diff);
              // $finalDiff =  $diff->format('%R%a');
              $finalDiff =$IntervalDays; //ibig sabihin late na
              $realDate = date('Y-m-d', strtotime($today));

              $firstdayorayt = $arrayFirstDate[$x];
    // $myReason = $_SESSION['reason'];

    $date = new DateTime($today);


   
    $datenextnext= new DateTime($firstdayorayt);

    $monthOfThis =  $datenextnext->format('F');
    $monthOfsubmittedDay =  $date->format('F');

if($monthOfThis == $monthOfsubmittedDay){
$finalDiff = 0;
}
else{
  $datenextnext->modify('next month');
  $monthOfDate =  $datenextnext->format('F');
  $year =  $datenextnext->format('Y');
  $fDateOfTheMonth = new DateTime('first day of '.$monthOfDate. $year);
  $FDateofThisMonth =  $fDateOfTheMonth->format('Y-m-d');

  $end = new DateTime(date('Y-m-d'));
  $start = new DateTime($FDateofThisMonth);
  $end->modify('+1 day');
  $interval = $end->diff($start);
  $finalDiff = $interval->days;
  $period = new DatePeriod($start, new DateInterval('P1D'), $end);
    //$holidays = array('2012-09-07');
    // $holidays = $holidaysArray;

    foreach($period as $dt) {
        $curr = $dt->format('D');
        if ($curr == 'Sat' || $curr == 'Sun') {
          $finalDiff--;
        }
        else if (in_array($dt->format('Y-m-d'), $holidays)) {
          $finalDiff--;
        }
    }
}
$dateSubmitted = date('Y-m-d');
    
        $timenowForSameId = date("hi");       
        $realDateForSameId = $dateSubmitted;     
        $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $reason;


    $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
              mysqli_query($con, $updateDateStarted);

              $validationVariable = $arrlength-2;
              $validationVar2 = $arrlength-1;

              //find4
                  

              if($x<$validationVariable){
                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`,`sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`,`firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstdayorayt','$week','$fileloc', '$year', '$department', '$finalDiff', '$reason','$action', '$realDate' ,'0', true);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                // echo $_SESSION
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
              }
              else if($x==$validationVariable){
                $pointFive = 0.5;
                if($finalDiff>2){
                  $pointFive = 0;
                }
                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`,`sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`,`firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstdayorayt','$week','$fileloc', '$year', '$department', '$finalDiff', '$reason','$action', '$realDate' ,'$pointFive', true);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
              }
              else if($x==$validationVar2){
                $week = 'week '.$weekNumberNew;
                $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`,`sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`,`firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`, `action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstdayorayt','$week','$fileloc', '$year', '$department', '$finalDiff', '$reason','$action', '$realDate' ,'1', true);";
                mysqli_query($con, $sqlinsert);
                header("location:index.php");
                unset($_SESSION['newFileLoc']);
                $_SESSION['reason'] = "";
                $_SESSION['noOfDaysLate']="";
                $_SESSION['action'] = "";
              }
              

}

          
        }
      }
        catch (Exception $e){             
          echo "Error found in finishing monthly task. Please contact your poging developer";
          echo "<br>";
          echo $e;
        }
       }

       
else if($taskType == "annual"){

try{
  $IntervalDays = $_SESSION['noOfDaysLate'];
  echo "<script> console.log('$meron') </script>";//find2
  // $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
  //     mysqli_query($con, $updateDateStarted);
  if($IntervalDays ==0 ){
    // echo "meron";
    if($_SESSION['newFileLoc'] ==""){
      $fileloc ="" ;
    }
    else{
      $fileloc = $_SESSION['newFileLoc'];
    }
      //echo "merom";
      

      $today = $_SESSION['today'];
      $dateSubmitted = date('Y-m-d');

      $dateNewToday = new DateTime($today);
        $weekNumberNew = $dateNewToday->format("W");
        $week = 'week '.$weekNumberNew;
      // $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
      $from=date_create(date('Y-m-d'));
      $to=date_create(date('Y-m-d', strtotime($today)));
      $diff=date_diff($to,$from);
      // print_r($diff);
      // $finalDiff =  $diff->format('%R%a');
      $finalDiff = "0";
      $realDate = date('Y-m-d', strtotime($today));

$myReason = $_SESSION['reason'];
$startDateMonth = $dateNewToday->format('F');
$fDateOfTheMonth = new DateTime('first day of '.$startDateMonth);
                                   
    $firstDateOfTheMonth =  $fDateOfTheMonth->format('Y-m-d');
    $timenowForSameId = date("hi");       
    $realDateForSameId = $dateSubmitted;     
    $sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $myReason;

$updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='1' WHERE `usertaskID` = '$usertaskID';";
      mysqli_query($con, $updateDateStarted);
      $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1', false);";
      mysqli_query($con, $sqlinsert);
      header("location:index.php");
      unset($_SESSION['newFileLoc']);
      $_SESSION['reason'] = "";
      $_SESSION['action'] = "";

      $_SESSION['noOfDaysLate']="";

    
  }
  else if($IntervalDays >0) {//find3
  
    if($_SESSION['newFileLoc'] ==""){
      $fileloc ="" ;
    }
    else{
      $fileloc = $_SESSION['newFileLoc'];
    }
//ganito nalang, kapag late automatic dalwa ang malalagay, last year at ngayun
// kasi siguro naman walang 2 years na late hahaha unless resign na diba



$today = $_SESSION['today'];

$dateNewToday = new DateTime($today);
$weekNumberNew = $dateNewToday->format("W");
$week = 'week '.$weekNumberNew;
// $week = 'week '.weekOfMonth(date('Y-m-d', strtotime($today)));
$from=date_create(date('Y-m-d'));
$to=date_create(date('Y-m-d', strtotime($today)));
$diff=date_diff($to,$from);
// print_r($diff);
// $finalDiff =  $diff->format('%R%a');
$finalDiff = "0";
$realDate = date('Y-m-d', strtotime($today));
$dateSubmitted = date('Y-m-d');
$myReason = $_SESSION['reason'];
$startDateMonth = $dateNewToday->format('F');
$fDateOfTheMonth = new DateTime('first day of '.$startDateMonth);
                           
$firstDateOfTheMonth =  $fDateOfTheMonth->format('Y-m-d');
$timenowForSameId = date("hi");       
$realDateForSameId = $dateSubmitted;     
$sameID=$usertaskID . $timenowForSameId . $realDateForSameId . $action . $myReason;

// $updateDateStarted = "UPDATE `usertask` SET `dateStarted`='$today', `ended`='$ended' WHERE `usertaskID` = '$usertaskID';";
// mysqli_query($con, $updateDateStarted);
// $sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`, `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today','$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '1', false);";
// mysqli_query($con, $sqlinsert);
// header("location:index.php");
// unset($_SESSION['newFileLoc']);
// $_SESSION['reason'] = "";
// $_SESSION['action'] = "";

// $_SESSION['noOfDaysLate']="";


$dateOfTheDay = new DateTime();
$dateOfTheDays = $dateOfTheDay->format('m-d');
$yearNow = $dateOfTheDay->format('Y');


$selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
$result = mysqli_query($con, $selectUserTask);

while($userRow = mysqli_fetch_assoc($result)){
  $dateTarget = $userRow['targetDate'];
  $dateAdded = $userRow['dateAdded'];

}
// $today=" March 31, ".$yearNow;
$today = $_SESSION['today'];

// $today = date('Y-m-d');

$realDate = date('Y-m-d', strtotime($dateTarget));

$end = new DateTime(date('Y-m-d'));
// $start = new DateTime($yearNow.'-04-01');
$start = new DateTime($dateTarget);

$end->modify('+1 day');
$interval = $end->diff($start);
// total days
$finalDiff = $interval->days;
$period = new DatePeriod($start, new DateInterval('P1D'), $end);
foreach($period as $dt) {
  $curr = $dt->format('D');

  // substract if Saturday or Sunday
  if ($curr == 'Sat' || $curr == 'Sun') {
    $finalDiff--;
  }

  // (optional) for the updated question
  else if (in_array($dt->format('Y-m-d'), $holidays)) {
    $finalDiff--;
  }
}

  
if($finalDiff <=2){
$sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`,  `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '0.5', true);";
mysqli_query($con, $sqlinsert);
header("location:index.php");
unset($_SESSION['newFileLoc']);
$_SESSION['reason'] = "";
$_SESSION['action'] = "";
$_SESSION['noOfDaysLate']="";

}
else{
$sqlinsert = "INSERT INTO `finishedtask`(`FinishedTaskID`, `sameID`, `taskID`, `Date`, `DateSubmitted`,  `timestamp`,`task_Name`, `in_charge`, `sched_Type`, `month`, `firstDateOfTheMonth`, `week`, `attachments`, `year`, `Department`,`noOfDaysLate`, `reason`,`action`, `realDate`, `score`, `isLate`) VALUES ('','$sameID','$usertaskID',' $today', '$dateSubmitted', '$timenow','$taskName','$incharge','$taskType','$month','$firstDateOfTheMonth','$week','$fileloc', '$year', '$department', '$finalDiff', '$myReason', '$action', '$realDate', '0', true);";
mysqli_query($con, $sqlinsert);
header("location:index.php");
unset($_SESSION['newFileLoc']);
$_SESSION['reason'] = "";
$_SESSION['action'] = "";
$_SESSION['noOfDaysLate']="";
}

//if april 1 or 2, 0.5, else 0 na tas ang date na ilalagay mo para lang ma read yung year 2022 ay march 31 2022. for basis only. PEro lalagyan mo parin ng date submitted.


    
  }
}
  catch (Exception $e){             
    echo "Error found in finishing annual task. Please contact your poging developer";
    echo "<br>";
    echo $e;
  }
 }

  
      }
    // }
  
    if(isset($_GET['Cancel'])){

      
      $FtaskID = $_GET['Cancel'];
      // $month = date("F");
      // $year = date("Y");
      $sqldelete = "DELETE FROM `finishedtask` WHERE FinishedTaskID = '$FtaskID'";
      mysqli_query($con, $sqldelete);
      $_SESSION['reason'] = "";
      $_SESSION['action'] = "";

      // header("location:index.php");


    }
    if(isset($_GET['Update'])){

      // echo $_GET['Update'];
      // echo "<script> console.log('sdhgfjsdghfjkasgfkg') </script>";
      $FtaskID = $_GET['Update'];
      // $month = date("F");
      // $year = date("Y");
      $myReason = $_SESSION['reason'];
      echo "<script> console.log('$myReason') </script>";
      $myAction = $_SESSION['action'];
      // $sqldelete = "UPDATE `finishedtask` SET `reason`='$myReason', `action`= '$myAction' WHERE `FinishedTaskID`='$FtaskID';";
      $sqldelete = "UPDATE `finishedtask` SET `reason`='$myReason', `action`= '$myAction' WHERE `sameID`='$FtaskID';";

      mysqli_query($con, $sqldelete);
      $_SESSION['reason'] = "";
      $_SESSION['action'] = "";
      header("location:index.php");

      // header("location:index.php");


    }

    if(isset($_GET['UpdateAction'])){

      // echo $_GET['UpdateAction'];
      echo "<script> console.log('sdhgfjsdghfjkasgfkg') </script>";
      $FtaskID = $_GET['UpdateAction'];
      // $month = date("F");
      // $year = date("Y");
      $myAction = $_SESSION['action'];
      $sqlUpdate = "UPDATE `finishedtask` SET `action`='$myAction' WHERE `sameID`='$FtaskID';";
      mysqli_query($con, $sqlUpdate);
      $_SESSION['reason'] = "";
      $_SESSION['action'] = "";
      header("location:index.php");

      // header("location:index.php");


    }
    if(isset($_POST['changePassword'])){
      $oldPass = $_POST['oldPass'];
      $newPass = $_POST['newPass'];
      $confirmPass = $_POST['confirmPass'];

    $username =  $_SESSION['username'];

      $selectPassword= "SELECT `userpass` FROM `users` WHERE username = '$username' LIMIT 1";
      $resultPassword = mysqli_query($con, $selectPassword);
      
      while($userRow = mysqli_fetch_assoc($resultPassword)){
        $userpass = $userRow['userpass'];
    }
      if($oldPass != $userpass){
        ?><script>
        Swal.fire({
      icon: 'error',
      title: 'Oops...',
      text: 'You have entered a wrong "Old Password!',
    //   footer: '<a href="">Why do I have this issue?</a>'
    })
     </script><?php 
      }
      else if($newPass != $confirmPass){
        ?><script>
        Swal.fire({
      icon: 'error',
      title: 'Oops...',
      text: 'New password does not match. Please try again.',
    //   footer: '<a href="">Why do I have this issue?</a>'
    })
     </script><?php 
      }
      else{
        $sqlPassUpdate = "UPDATE `users` SET `userpass`='$newPass',`conpass`='$newPass' WHERE  username = '$username';";
        mysqli_query($con, $sqlPassUpdate);
        ?><script>
        Swal.fire({
      icon: 'success',
      title: 'success',
      text: 'Password change successfully!',
    //   footer: '<a href="">Why do I have this issue?</a>'
    })
     </script><?php 
      }
    }

    
    // $_SESSION['username'] = $username;
    // echo "User: " .$_SESSION['username']. "."  ;
    // echo "<script>console.log('$_SESSION['username']')</script>";
    echo("<script>console.log('USER: " .$_SESSION['username'] . "');</script>");
    echo("<script>console.log('USER: " .$_SESSION['userlevel'] . "');</script>");
    // echo("<script>console.log('as,fjhaekjlh');</script>");
    // $today = date("F j, Y"); 
    // $date_string= date("Y-m-d");
    $username =  $_SESSION['username'];
    echo("<script>console.log('USER: " .$username . "');</script>");

    $columns= ['usertaskID', 'taskName','taskCategory','taskType'];
    $fetchData = fetch_data($db, $tableName, $columns, $username);


    function fetch_data($db, $tableName, $columns, $username){
      if(empty($db)){
       $msg= "Database connection error";
      }elseif (empty($columns) || !is_array($columns)) {
       $msg="columns Name must be defined in an indexed array";
      }elseif(empty($tableName)){
        $msg= "Table Name is empty";
     }else{
     $columnName = implode(", ", $columns);
     $query = "SELECT * FROM `usertask`  WHERE `username` = '$username' AND `ended` = false; ";
    //  SELECT * FROM `usertask` WHERE `username` = 'cjorozo';
     $result = $db->query($query);
     if($result== true){ 
      if ($result->num_rows > 0) {
         $row= mysqli_fetch_all($result, MYSQLI_ASSOC);
         $msg= $row;
      } else {
         $msg= "No Data Found"; 
      }
     }else{
       $msg= mysqli_error($db);
     }
     }
     return $msg;
     }

     function weekOfMonth($qDate) {
      $dt = strtotime($qDate);
      $day  = date('j',$dt);
      $month = date('m',$dt);
      $year = date('Y',$dt);
      $totalDays = date('t',$dt);
      $weekCnt = 1;
      $retWeek = 0;
      for($i=1;$i<=$totalDays;$i++) {
          $curDay = date("N", mktime(0,0,0,$month,$i,$year));
          if($curDay==7) {
              if($i==$day) {
                  $retWeek = $weekCnt+1;
              }
              $weekCnt++;
          } else {
              if($i==$day) {
                  $retWeek = $weekCnt;
              }
          }
      }
      return $retWeek;
  }
?>
      <div>
        <nav class="navbar navbar-expand-md navbar-dark bg-dark">
            <a class="navbar-brand" href="#"> <img src="design_files/images/GloryPhLogo.jpg" alt="..." height="40">&nbsp;Task Monitoring App</a>
            <button class="navbar-toggler" type="button" data-toggle="collapse"
             data-target="#navbarSupportedContent">
              <span class="navbar-toggler-icon"></span>
            </button>
            <?php

              if($_SESSION['userlevel'] == "Leader"){
               ?>
                    <div class="collapse navbar-collapse" id="navbarSupportedContent">
              <ul class="navbar-nav">
              <li class="nav-item">
                  <a class="nav-link" href="leader.php">Leader Side</a>
                </li>
                <li class="nav-item active">
                  <a class="nav-link" href="#">My Task</a>
                </li>
             
                <!-- <li class="nav-item">
                  <a class="nav-link" href="#">About</a>
                </li> -->
                
                
              </ul>
            </div>
               <?php

              }

             ?>
             
           
       
            <div class="collapse navbar-collapse" id="navbarSupportedContent">
 
              <ul class="navbar-nav ml-auto">
              <li class="nav-item">
                  <a class="nav-link" href="addTaskOfMyOwn.php">Add Task</a>
                </li>
              <li class="nav-item">
                  <a class="nav-link" href="ended.php">Ended Task</a>
                </li>
              <li class="nav-item">
                  <a class="nav-link" href="userDashBoard.php">Dash Board</a>
                </li>
                <li class="nav-item active">
                  <a class="nav-link" href="#">Home</a>
                </li>
                <!-- <li class="nav-item">
                  <a class="nav-link" href="#">About</a>
                </li> -->
                
                <li class="nav-item dropdown" >
                  <a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown">
                    Option
                  </a>
                  
                  <div class="dropdown-menu" aria-labelledby="navbarDropdown"  style="right: 0; left: auto;">
                  <a class="dropdown-item" id="btn-changePass" href="#" data-toggle='modal'
                      data-target='#changePassword'>Change Password</a>
                   <a class="dropdown-item" id="btn-logout" href="./logout.php">Logout</a>
                        <?php
                        if($_SESSION['admin'] == "TRUE"){?>

                    <!-- <a class="dropdown-item" id="btn-addAdmin" href="#" data-toggle='modal'
                      data-target='#modalAdmin'>Add Admin</a>
                    <a class="dropdown-item" id="btn-addAdmin" href="#" data-toggle='modal'
                      data-target='#modalRemoveAdmin'>Remove Admin</a>  -->
                   
                      <?php } ?>

                    
                   
                  </div>

                </li>
                
              </ul>
            </div>
          </nav>
        </div>
        <div class="modal fade" id="changePassword" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
          <div  class="modal-dialog modal-dialog-centered modal-lg" role="document">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="exampleModalLongTitle">Change Password</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close" >
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <div class="modal-body">
        <form action="index.php" method = "POST" style="width: 100%; padding: 0; border: 0;">
        <!-- <input type="text" id="containerOfTaskId" name="containerOfTaskId" style="display: none"> -->
        <div class="form-group row">
            <label for="staticEmail" class="col-sm-4 col-form-label">Enter old password</label>
            <div class="col-sm-8">
            <input type="password" class="form-control" id="oldPass" name="oldPass">
                    </div>
                    </div>
          <div class="form-group row">
            <label for="staticEmail" class="col-sm-4 col-form-label">Enter new password</label>
            <div class="col-sm-8">
            <input type="password" class="form-control" id="newPass" name="newPass">
             
            </div>
          </div>
          <div class="form-group row">
            <label for="staticEmail" class="col-sm-4 col-form-label">Confirm new password</label>
            <div class="col-sm-8">
            <input type="password" class="form-control" id="confirmPass" name="confirmPass">
             
            </div>
          </div>
          </div>



  <!-- document.getElementById('modalNumberofDays').value=parseInt(noOfdays) -->
  <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                <button type="submit" id="changePassword" name="changePassword" class="btn btn-info" >Update</button>
              
            
               </div>
                
        </form>
      </div>
              
            </div>
          </div>
        </div>
        <div class="alert alert-success" id = "successAlert" style="display: none"role="alert">
 <h3 id="successAlertWord"> </h3>
</div>

        <div class="modal fade" id="modalRemoveAdmin" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
          <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="exampleModalLongTitle">Remove Admin</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close" >
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <div class="modal-body">
                <form id="passwordform" style="width: 100%; padding: 10px; border: 0;" >
                  <div class="form-group">
                    <ul id="adminList">
                      <!-- <li>CEdrick</li>
                      <li>CEdrick</li>
                      <li>CEdrick</li> -->
  
                    </ul>
                  </div>
                  <div class="form-group">
                    <label  for="message-text" class="col-form-label">Enter email</label>
                      <input  type="text"class="form-control"   id="inputRemoveAdmin" >
                  </div>
                </form>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                <button type="button" onclick =" RemoveAdmin();" class="btn btn-primary" data-dismiss="modal">Remove</button>
            
               </div>
            </div>
          </div>
        </div>
        <div class="modal fade" id="modalAdmin" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
          <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="exampleModalLongTitle">Add Admin</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close" >
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <div class="modal-body">
                <form id="passwordform" style="width: 100%; padding: 10px; border: 0;" >
                  <div class="form-group">
                    <ul id="adminList2">
                      <!-- <li>CEdrick</li>
                      <li>CEdrick</li>
                      <li>CEdrick</li> -->
  
                    </ul>
                  </div>      
                  <div class="form-group">
                   
                    <label  for="message-text" class="col-form-label">Enter email</label>
                    <input  type="text"class="form-control"   id="inputAdmin" >
                  </div>
                </form>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                <button type="button" onclick =" addAdmin();" class="btn btn-primary" data-dismiss="modal">Add</button>
            
               </div>
            </div>
          </div>
        </div>
<form method="POST" action="index.php">
                        </form>
        <div class="parent" style= "max-height: 100%; height: 100%; padding:0px; ">
          <div class="wrapper" style= " max-height: 100%; height: 100% ;padding:0px; ">
         
          <div class="row"style= "margin-right: 0px; max-height: 100%; height: 100%; background-color: none; padding:0px; ">
          <div class="col-4">
            <h3 style=" margin: 20px; color: white;">  <i style="font-size: 30px; color: white;" class="fas fa-user"></i>  <?php echo $_SESSION['f_name'] ?> <?php echo $_SESSION['l_name'] ?>
             
            </h3>
          </div>
          <div class="col-4" style="padding-top: 20px; color: white">
          <!-- <h3  class="text-center"> <?php if( $_SESSION['userlevel'] == "PIC") echo 'Member' ?> </h3>   -->
          <h3 class="text-center"> <?php
          $dateOfTodayOrayt = $_SESSION['today'] ;
            $DateOrayt = new DateTime($dateOfTodayOrayt);
 
            $DateOrayt =  $DateOrayt->format('F j, Y');
           
          echo   $DateOrayt  ?> Week <?php $date = new DateTime($_SESSION['date_string']);
  $week = $date->format("W"); echo "$week"; ?></h3>

          </div>
          <div class="col-4">
            <h3 style=" margin: 20px; color: white" class="float-right"> <?php if( $_SESSION['userlevel'] == "PIC") echo 'Member' ?> </h3>
          </div>
         
          <div class="container p-30" id="TableListOfMembers"; style="position: relative; height: 100%;  padding-top: 0px; margin:0 auto; max-width: 90%;  background-color: none">
          
        <div class=" ms-1 shadow row" style="">
            <div class=" shadow col-md-12 main-datatable" style=""> 
                <div class="card_body"  style="">
                    <div class="row d-flex " style="">
                        <div class="col-sm-1 createSegment"> 
                         <h3>Task</h3> 
                        </div>

                        <div class="col-sm-4"  style="padding: 0; display: none">
                          <div class="form-group row d-flex justify-content-center" >
                          <form action="index.php" method = "POST" >
            <label for="colFormLabelLg" class="col-form-label-lg" style="margin-right: 20px">Date</label>
            <input type="date" id="datepicker" name="datepicker" data-value="[2020,0,1]" onchange="filterMonth();">
            <input type="submit" name="submitdate"  value = "Submit">
            </form>
           
        </div></div>

                        <div class="col-sm-6 add_flex">
                        <div class="col"  >
                        <fieldset class="row mb-3" style="margin-top: 25px;  font-size: 12pt; margin-bottom: 0px;">
                            <div class="form-check" style="padding-left: 10px">
                                   
                                    <div class="form-check form-check-inline" style="margin-left: 10px">
                                        <input class="form-check-input" type="checkbox" name="checkDone" id="checkDone" value="DONE" onclick="done();">
                                            <label class="form-check-label" for="checkPIC">
                                             Done
                                            </label>
                                    </div>
                                  
                             </div>
                        </fieldset>
                    </div>
                            <div class="form-group searchInput">
                                <!-- <select class="custom-select" id="inputGroupSelect01" onchange="getSelectValue();">
                                    <option  disabled selected hidden>Search by</option>
                                    
                                    <option value="2">Task Name</option>
                                    <option value="3">Type</option>
                                    <option value="3">Category</option>
                                    <option value="4">Status</option>
                                  </select> -->
                                <!-- <label for="email">Search:</label> -->
                                <input type="search" class="form-control" id="filterbox" placeholder=" " onkeyup="getSelectValueDaily();">
                            </div>
                        </div> 
                    </div>
                    <div class="overflow-x">
                      <div class="overflow-y" style="overflow-y: scroll; height:600px;"> 
                        <table class="table table-striped table-hover  " style="width:100%;" id="filtertable" class="table datacust-datatable Table ">
                            <thead  class="thead-dark">
                                <tr>
                                    <th style="min-width:1%;">No.</th>
                                    <th style="width:30%;" >Task Name</th>
                                    <th style="min-width:10%;" >Type</th>
                                    <th style="min-width:10%;" >Category</th>
                                    <th style="min-width:10%;">Status</th>
                                    <th style="min-width:20%;">Action</th>
                                </tr>
                            </thead>
                            <tbody id="TaskTable">
                            <?php
                                  if(is_array($fetchData)){      
                                  $sn=1;
                                  foreach($fetchData as $data){
                            ?>
                             <tr class="tableMain" style="height:50px; <?php
                              $dateforToday = date('Y-m-d');
                               $dateTarget = $data['targetDate']; 
                               $taskType1 = $data['taskType']; //Update for October 2022

                                if($dateforToday >= $dateTarget){ 
                                  if($taskType1=="others"){                 //Update for October 2022
                                    ?>    
                                    background-color: rgb(90 216 250);
                                    <?php 
                                  }
                                  else{                                 //Update for October 2022
                                  ?>
                                  background-color: #5afa84;
                                  <?php
                                  }
                                   } ?> " >
                                <td  style="width: 1%;"><?php echo $sn; ?></td>
                                <td style="width:30%;"><?php echo $data['taskName']??''; ?></td>
                                <td  style="width: 10%;"><?php echo $data['taskType']??''; ?></td>
                                <td  style="width: 10%;"><?php echo $data['taskCategory']??''; ?></td>
                              <!-- <td>
                                
                              <span class="mode mode_on">Done</span></td>
                              <td> -->
                              <td style="width: 10%;"> <?php
                                $taskID = $data['usertaskID'];
                                $taskType =  $data['taskType'];
                                $ended = $data['ended'];
                                if($ended){
                                  echo '<span id = "doneORnot" class="mode mode_off">Ended</span>';

                                }
                       else{
                      // echo("<script>console.log('emmeeeememem: " . $taskID. "');</script>");
                      // $month = date("F");
                      // $year = date("Y");
                      $weeknumberrr = weekOfMonth($_SESSION['date_string']);
                      // echo("<script>console.log('hahahah: " .$weeknumberrr. "');</script>");

                      if ($taskType == 'weekly'){
                        $sessionDateNow=$_SESSION['date_string'];
                        $date = new DateTime($sessionDateNow);
                        $weekMonth = $date->format("W");
                        // $weekMonth = weekOfMonth($_SESSION['date_string']);
                        $month1 = $_SESSION['month'];
                        $year1 = $_SESSION['year'];
                                    $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$month1' AND `year` = '$year1' AND `week` = 'week $weekMonth';";
                                    // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                    $result = mysqli_query($con, $selectUserTask);

                                    $numrows = mysqli_num_rows($result);

                                    $don = "0";
                                    while($userRow = mysqli_fetch_assoc($result)){
                                      $noOfDays = $userRow['noOfDaysLate'];
                                      $isLate = $userRow['isLate'];


                                  }


                                  //new code for weekly 
                                  $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
                                  $result = mysqli_query($con, $selectUserTask);
                        
                                  while($userRow = mysqli_fetch_assoc($result)){
                                    $dateStarted = $userRow['dateStarted'];
                                    $dateStartedAdded = $userRow['dateAdded'];
                                        
                                  }
                                  $dateStartedFromDataBase = date($dateStartedAdded);
                                  $dateForNow = date('Y-m-d');
                                  if($dateStartedFromDataBase >$dateForNow  ){
                                    echo '<span id = "doneORnot" class="mode mode_off">Upcoming</span>';

                                  }
                                  else{
                                  $date = new DateTime($dateStarted);
                                  // echo "Next monday is: ";
                                  $date->modify('next monday');
                                  // $date->format('Y-m-d');
                                  $DateEnd =  $date->format('Y-m-d');
                                  $end = new DateTime(date('Y-m-d'));
                                  $start = new DateTime($DateEnd);
                                // otherwise the  end date is excluded (bug?)
                                  $end->modify('+1 day');
                        
                                  $interval = $end->diff($start);
                        
                                  // total days
                                  $finalDiff = $interval->days;
                        // echo $finalDiff;
                                  // create an iterateable period of date (P1D equates to 1 day)
                                  $period = new DatePeriod($start, new DateInterval('P1D'), $end);
                        
                                  // best stored as array, so you can add more than one
                                  //$holidays = array('2012-09-07');
                                  // $holidays = $holidaysArray;
                        
                                  foreach($period as $dt) {
                                      $curr = $dt->format('D');
                        
                                      // substract if Saturday or Sunday
                                      if ($curr == 'Sat' || $curr == 'Sun') {
                                        $finalDiff--;
                                      }
                        
                                      // (optional) for the updated question
                                      elseif (in_array($dt->format('Y-m-d'), $holidays)) {
                                        $finalDiff--;
                                      }
                                  }
                        
                                  // $finalDiff=$finalDiff-1;
                        
                                  $mondaylw =  date("Y-m-d", strtotime("monday last week"));
                                  $sundaylw =  date("Y-m-d", strtotime("sunday last week"));
                                     
                                  $meronBaSiyaLastWeek = "SELECT * FROM `finishedtask` WHERE `taskID` = '$taskID' AND `realDate` BETWEEN '$mondaylw' AND '$sundaylw';";
                                  // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                  $result = mysqli_query($con, $meronBaSiyaLastWeek);
                                  $meron = mysqli_num_rows($result);
                                  // echo $finalDiff;
                                  $finalDiff = $finalDiff - 5;
                                  if ($numrows >= 1){
                                    if($isLate){
                                      echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
                                    }
                                    else{
                                      echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
                                    }
                                    $don = "1";
                                  //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
                                       }
                                       else{
                                  if($finalDiff >=2){
                                            echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
                                              }
                                              else if($finalDiff <= 0){
                                            echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
                                              }
                                              else if($finalDiff ==1){
                                                echo '<span class="⚠"></span><span id = "doneORnot" class="mode mode_done">Pending</span>';
                                                  }
                                  //end of new code for weekly
                                    // if ($numrows >= 1){
                                    //   if($isLate){
                                    //     echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
                                    //   }
                                    //    else {
                                    //     echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
                                    //   }
                                     
                                    //   $don = "1";
                                    //   // echo '<style type="text/css">#finished22 {pointer-events: none; <style>';
                                    //      }
                                         else{
                                          $mondaylw =  date("Y-m-d", strtotime("monday last week"));
                                          $sundaylw =  date("Y-m-d", strtotime("sunday last week"));
                                             
                                          $meronBaSiyaLastWeek = "SELECT * FROM `finishedtask` WHERE `taskID` = '$taskID' AND `realDate` BETWEEN '$mondaylw' AND '$sundaylw';";
                                          // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                          $result = mysqli_query($con, $meronBaSiyaLastWeek);
                                          $meron = mysqli_num_rows($result);
                                          if($meron >=1){
                                            echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
                                          }
                                          else{
                                            echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
                                          }
                                         }
                                        }
                                    }
                                  }
                                    else if($taskType == 'monthly'){
                                      $sessionDateNow=$_SESSION['date_string'];
                                      $date = new DateTime($sessionDateNow);
                                      $weekMonth = $date->format("W");
                                      // $weekMonth = weekOfMonth($_SESSION['date_string']);
                                    $month1 = $_SESSION['month'];
                                    $year1 = $_SESSION['year'];
                                      
                                    $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$month1' AND `year` = '$year1' ;";
                                    // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                    $result = mysqli_query($con, $selectUserTask);

                                    $numrows = mysqli_num_rows($result);
                                    $don = "0";
                                    while($userRow = mysqli_fetch_assoc($result)){
                                      $noOfDays = $userRow['noOfDaysLate'];
                                      $isLate = $userRow['isLate'];
                                    
                          
                                  }
                                  //new monthly code

                                  $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
                                  $result = mysqli_query($con, $selectUserTask);
                            
                                  while($userRow = mysqli_fetch_assoc($result)){
                                    $dateStarted = $userRow['dateStarted'];
                                    $dateStartedAdded = $userRow['dateAdded'];

                                  }
                                  $dateStartedFromDataBase = date($dateStartedAdded);
                                  $dateForNow = date('Y-m-d');
                                  if($dateStartedFromDataBase >$dateForNow  ){
                                    echo '<span id = "doneORnot" class="mode mode_off">Upcoming</span>';

                                  }
                                  else{
                                  $date = new DateTime($dateStarted);
                                  $datenow = new DateTime($dateStarted);
                            
                            
                                  $dateStarteds = new DateTime($dateStarted);
                                  $monthOfLastDate =  $dateStarteds->format('F');
                                      $yearOfLastDate =  $dateStarteds->format('Y');
                                
                                      $monthofThisMonth = new DateTime(date('Y-m-d'));
                                      $Month_Now = $monthofThisMonth->format('F');
                                      $yearOfThisMonth = new DateTime(date('Y-m-d'));
                                      $Year_Now = $yearOfThisMonth->format('Y');
                                
                            
                                      $nextMonth = $date->modify('next month');
                                      // $date->format('Y-m-d');
                                      $nextMonthHehe =  $nextMonth->format('F');
                                      $yearOfNextDate =  $date->format('Y');
                            // echo $nextMonthHehe;
                            
                                      if($nextMonthHehe == $Month_Now ){
                            
                            $finalDiff = "0";
                            $finalDiff2 = "2";
                            
                                      }
                                      else{
                                      // echo "Next monday is: ";
                                  // $date->modify('next monday');
                            
                            
                                  // echo "Next monday is: ";
                                  // $date->modify('next monday');
                            
                            
                                  // echo "Next monday is: ";
                                  $date->modify('next month');
                                  
                                  // $date->format('Y-m-d');
                                  $monthOfDate =  $date->format('F');
                                  $year =  $date->format('Y');
                            // echo $monthOfDate;
                            $fDateOfTheMonth = new DateTime('first day of '.$monthOfDate. $year);
                            $FDateofThisMonth =  $fDateOfTheMonth->format('Y-m-d');
                            
                                  // echo $FDateofThisMonth;
                            
                                  $lDateOfTheMonth = new DateTime('last day of '.$monthOfDate. $year);
                                  $LDateofThisMonth =  $lDateOfTheMonth->format('Y-m-d');
                                      // echo $FDateofThisMonth;
                            
                                  $end2 = new DateTime(date($LDateofThisMonth));
                                  $start2 = new DateTime($FDateofThisMonth);
                                // otherwise the  end date is excluded (bug?)
                                  $end2->modify('+1 day');
                            
                                  $interval2 = $end2->diff($start2);
                            
                                  // total days
                                  $finalDiff2 = $interval2->days;
                            
                                  // create an iterateable period of date (P1D equates to 1 day)
                                  $period2 = new DatePeriod($start2, new DateInterval('P1D'), $end2);
                            
                                  // best stored as array, so you can add more than one
                                  // $holidays2 = array('2012-09-07');
                                    $holidays2 = $holidaysArray;
                            
                                  foreach($period2 as $dt2) {
                                      $curr2 = $dt2->format('D');
                            
                                      // substract if Saturday or Sunday
                                      if ($curr2 == 'Sat' || $curr2 == 'Sun') {
                                        $finalDiff2--;
                                      }
                            
                                      // (optional) for the updated question
                                      elseif (in_array($dt2->format('Y-m-d'), $holidays)) {
                                        $finalDiff2--;
                                      }
                                  }
                                  $finalDiff3 = $finalDiff2;
                            
                            $finalDiff2 = $finalDiff2+2;
                            
                            
                            
                            
                                  // $date->format('Y-m-d');
                                  // $DateEnd =  $date->format('Y-m-d');
                                  $end = new DateTime(date('Y-m-d'));
                                  // $end = new DateTime('2022-06-30');
                            
                                  $start = new DateTime($FDateofThisMonth);
                            
                            
                            
                                  $from=date_create(date('Y-m-d'));
                                  $to=date_create($FDateofThisMonth);
                                  $diff=date_diff($to,$from);
                                  // print_r($diff);
                                  // echo $diff->format('%R%a');
                                  
                                  $Difference = $diff->format('%R%a');
                            
                                  // echo $n1 + $n2;
                            
                            
                            
                                  $eememe =  $end->format('Y-m-d');
                                    $DateEnd =  $start->format('Y-m-d');
                                // otherwise the  end date is excluded (bug?)
                                  $end->modify('+1 day');
                                 
                                  $interval = $end->diff($start);
                            
                                  // total days
                                  $finalDiff = $interval->days;
                            
                                  // create an iterateable period of date (P1D equates to 1 day)
                                  $period = new DatePeriod($start, new DateInterval('P1D'), $end);
                            
                                  // best stored as array, so you can add more than one
                                  //$holidays = array('2012-09-07');
                                    // $holidays = $holidaysArray;
                                  
                                  foreach($period as $dt) {
                                      $curr = $dt->format('D');
                            
                                      // substract if Saturday or Sunday
                                      if ($curr == 'Sat' || $curr == 'Sun') {
                                        $finalDiff--;
                                      }
                            
                                      // (optional) for the updated question
                                      elseif (in_array($dt->format('Y-m-d'), $holidays)) {
                                        $finalDiff--;
                                      }
                                  }
                                  $finalDifFinal = $finalDiff - $finalDiff3;
                            
                                      }
                                      if ($numrows >= 1){
                                        if($isLate){
                                          echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
                                        }
                                        else{
                                          echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
                                        }
                                        $don = "1";
                                      //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
                                           }
                                           else{
                                            if($finalDiff >=2){
                                              echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
                                                }
                                                else if($finalDiff <= 0){
                                              echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
                                                }
                                                else if($finalDiff ==1){
                                                  echo '<span class="⚠"></span><span id = "doneORnot" class="mode mode_done">Pending</span>';
                                                    }
                                           }
                            
                               
                                  //end of new monthly code
                                    // if ($numrows >= 1){
                                    //   if($isLate){
                                    //     echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
                                    //   }
                                    //   else{
                                    //     echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
                                    //   }
                                    //   $don = "1";
                                    // //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
                                    //      }
                                    //      else{
                                    //       $lastmonth =  date("F", strtotime("previous month"));
  
                                    //       $meronBaSiyaLastMonth = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$lastmonth' AND `year` = '$year1' ;";
                                    //       // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                    //       $resultm = mysqli_query($con, $meronBaSiyaLastMonth);
      
                                    //       $meronlastMonth = mysqli_num_rows($resultm);

                                    //       if($meronlastMonth >=1){
                                    //         echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
                                    //       }
                                    //       else if($meronlastMonth <=0){
                                    //     echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
                                    //       }
                                    //      }
                                    }
                                    }
                                    else if($taskType == 'daily'){
                                      $sessionDateNow=$_SESSION['date_string'];
                                      $date = new DateTime($sessionDateNow);
                                      $weekMonth = $date->format("W");
                                      // $weekMonth = weekOfMonth($_SESSION['date_string']);
                                      $today1 = $_SESSION['today'];
                                    $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `Date` = ' $today1';";
                                    // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                    $result = mysqli_query($con, $selectUserTask);

                                    $numrows = mysqli_num_rows($result);
                                    $don = "0";
                                    while($userRow = mysqli_fetch_assoc($result)){
                                      $isLate = $userRow['isLate'];
                                    
                          
                                  }
                                  

                                    if ($numrows >= 1){
                                      if($isLate){
                                        echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
                                      }
                                      else if(!$isLate){
                                        echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
                                      }
                                      else if(!$isLate){
                                        echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
                                      }
                                      $don = "1";
                                    //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
                                         }
                                         else{
                                          $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
                                          $result = mysqli_query($con, $selectUserTask);
                                          
                                          while($userRow = mysqli_fetch_assoc($result)){
                                            $today = $userRow['dateStarted'];
                                    $dateStartedAdded = $userRow['dateAdded'];

                                          }
                  $dateStartedFromDataBase = date($dateStartedAdded);
                                  $dateForNow = date('Y-m-d');
                                  if($dateStartedFromDataBase >$dateForNow  ){
                                    echo '<span id = "doneORnot" class="mode mode_off">Upcoming</span>';

                                  }
                                  else{
                                         
          $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
          $result = mysqli_query($con, $selectUserTask);
          
          while($userRow = mysqli_fetch_assoc($result)){
            $today = $userRow['dateStarted'];
          }
          $datesssss = new DateTime($today);
  
          $weekssss = $datesssss->format("D");
          if($weekssss == "Sat"){
            $datesssss->modify("-1 day");
  $today =  $datesssss->format('Y-m-d');

          }
          else if($weekssss == "Sun"){
            $datesssss->modify("-2 day");
            $today =  $datesssss->format('Y-m-d');

          }
          // $from=date_create(date('Y-m-d'));
          // $to=date_create(date('Y-m-d', strtotime($today)));
          // $diff=date_diff($to,$from);
          // // print_r($diff);
          // $finalDiff =  $diff->format('%R%a');
          // $finalDiff = $finalDiff-1;

          $end = new DateTime(date('Y-m-d'));
          $start = new DateTime(date('Y-m-d', strtotime($today)));
// otherwise the  end date is excluded (bug?)
// $end->modify('+1 day');

$interval = $end->diff($start);

// total days
$finalDiff = $interval->days;

// create an iterateable period of date (P1D equates to 1 day)
$period = new DatePeriod($start, new DateInterval('P1D'), $end);

// best stored as array, so you can add more than one
//$holidays = array('2012-09-07');

foreach($period as $dt) {
    $curr = $dt->format('D');

    // substract if Saturday or Sunday
    if ($curr == 'Sat' || $curr == 'Sun') {
      $finalDiff--;
    }

    // (optional) for the updated question
    elseif (in_array($dt->format('Y-m-d'), $holidays)) {
      $finalDiff--;
    }
}

$finalDiff=$finalDiff-1;
                                          if($finalDiff >=2){
                                            echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
                                              }
                                              else if($finalDiff <= 0){
                                            echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
                                              }
                                              else if($finalDiff ==1){
                                                echo '<span class="⚠"></span><span id = "doneORnot" class="mode mode_done">Pending</span>';
                                                  }
                                                }
                                                  // echo $finalDiff;
                                         }
                                    }


                                   
else if($taskType == 'annual'){
                                      

  $dateOfNow = new DateTime(date('Y-m-d'));
  $MonthOfNow =  $dateOfNow->format('F');
  $YearToUseForApril = "";
  $YearToUseforMarch = "";
  if($MonthOfNow=="January" || $MonthOfNow=="February" || $MonthOfNow=="March"){

    $YearToUseforMarch =  $dateOfNow->format('Y');
    $dateOfNow->modify('last year');
    $YearToUseForApril =  $dateOfNow->format('Y');
  }
  else{
    $YearToUseForApril =  $dateOfNow->format('Y');
$dateOfNow->modify('next year');
$YearToUseforMarch =  $dateOfNow->format('Y');

}


  $April = new DateTime($YearToUseForApril.'-04-01');
  $March = new DateTime($YearToUseforMarch.'-03-31');
  $April =  $April->format('Y-m-d');
  $March =  $March->format('Y-m-d');

  $selectUserTasks = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND  `realDate` BETWEEN '$April' AND '$March';";
  // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
  $result = mysqli_query($con, $selectUserTasks);

  $numrows = mysqli_num_rows($result);
  $don = "0";
  while($userRow = mysqli_fetch_assoc($result)){
    $noOfDays = $userRow['noOfDaysLate'];
    $isLate = $userRow['isLate'];
  

}
//new monthly code

$selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
$result = mysqli_query($con, $selectUserTask);

while($userRow = mysqli_fetch_assoc($result)){
  $dateStarted = $userRow['dateStarted'];
  $dateStartedAdded = $userRow['dateAdded'];

}
$dateStartedFromDataBase = date($dateStartedAdded);
$dateForNow = date('Y-m-d');
if($dateStartedFromDataBase >$dateForNow  ){
  echo '<span id = "doneORnot" class="mode mode_off">Upcoming</span>';

}
else{
$date = new DateTime($dateStarted);
$dateYear = new DateTime($dateStarted);

$selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
$result = mysqli_query($con, $selectUserTask);

while($userRow = mysqli_fetch_assoc($result)){
  $dateTarget = $userRow['targetDate'];
}

$dateYear->modify('next year');
$nextYearSample =  $dateYear->format('Y');

// $date = new DateTime($nextYearSample.'-04-01'); //pinalitan mo ito
$date = new DateTime($dateStartedAdded);


$nextYearApril =  $date->format('Y-m-d');

$dateYear->modify('next year');
$nextYearSample =  $dateYear->format('Y');

// $date = new DateTime($nextYearSample.'-03-31');
$date = new DateTime($dateTarget);                        //pinalitan mo ito
$nextYearMarch=  $date->format('Y-m-d');            

// $end = new DateTime(date('Y-m-d'));


// $start = new DateTime($nextYearMarch);


// $end->modify('+1 day');

// $interval = $end->diff($start);

// // total days
// $finalDiff = $interval->days;

$yearOfThisMonth = new DateTime(date('Y-m-d'));
$Year_Now = $yearOfThisMonth->format('Y');

// $nextYear = $date->modify('next year');
// $nextYearHehe =  $nextYear->format('Y');
// echo $nextYearHehe;

$dateToday = date('Y-m-d');
$dateToday=date('Y-m-d', strtotime($dateToday));
//echo $paymentDate; // echos today! 
$april = date('Y-m-d', strtotime($nextYearApril));
$march = date('Y-m-d', strtotime($nextYearMarch));
  
$april2 = date('Y-m-d', strtotime($nextYearApril));
$march2 = date('Y-m-d', strtotime($nextYearMarch));
// if (($dateToday >= $april) && ($dateToday <= $march)){
//   // echo "is between";
//   $finalDiff = "0";

// }

if(($dateToday >= $april2) && ($dateToday <= $march2)){
  $finalDiff = "0";

}
//https://stackoverflow.com/questions/19070116/php-check-if-date-between-two-dates
else{
  // $date->modify('next year');
  $year =  $date->format('Y');

// echo $year;
// echo "<br>";
$selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
$result = mysqli_query($con, $selectUserTask);

while($userRow = mysqli_fetch_assoc($result)){
  $dateTarget = $userRow['targetDate'];
}
// $date = new DateTime($year.'-04-01');
$date = new DateTime($dateTarget);

$nextYearApril =  $date->format('Y-m-d');

$end = new DateTime(date('Y-m-d'));


$start = new DateTime($nextYearApril);


$end->modify('+1 day');

$interval = $end->diff($start);

// total days
$finalDiff = $interval->days;

    $period = new DatePeriod($start, new DateInterval('P1D'), $end);
    foreach($period as $dt) {
        $curr = $dt->format('D');
    // echo $curr;
   

        if ($curr == 'Sat' || $curr == 'Sun') {
          $finalDiff--;
        }
    
        if (in_array($dt->format('Y-m-d'), $holidays)) {
          $finalDiff--;
        }
    }
// echo $finalDiff;
}

    if ($numrows >= 1){
      if($isLate){
        echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
      }
      else{
        echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
      }
      $don = "1";
    //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
         }
         else{
          if($finalDiff >=2){
            // echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
            echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
            
              }
              else if($finalDiff <= 0){
            echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
              }
              else if($finalDiff ==1){
                echo '<span class="⚠"></span><span id = "doneORnot" class="mode mode_done">Pending</span>';
                  }
         }


//end of new monthly code
  // if ($numrows >= 1){
  //   if($isLate){
  //     echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
  //   }
  //   else{
  //     echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
  //   }
  //   $don = "1";
  // //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
  //      }
  //      else{
  //       $lastmonth =  date("F", strtotime("previous month"));

  //       $meronBaSiyaLastMonth = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$lastmonth' AND `year` = '$year1' ;";
  //       // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
  //       $resultm = mysqli_query($con, $meronBaSiyaLastMonth);

  //       $meronlastMonth = mysqli_num_rows($resultm);

  //       if($meronlastMonth >=1){
  //         echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
  //       }
  //       else if($meronlastMonth <=0){
  //     echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
  //       }
  //      }
}
  }
  else if($taskType == 'others'){
                                      

    $dateOfNow = new DateTime(date('Y-m-d'));
    $MonthOfNow =  $dateOfNow->format('F');

  $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
  $result = mysqli_query($con, $selectUserTask);
  
  while($userRow = mysqli_fetch_assoc($result)){
    $dateStartedAdded = $userRow['dateAdded'];
    $targetDate = $userRow['targetDate'];
  
  }
  
    $dateStartedAdded = new DateTime($dateStartedAdded);
    $targetDate = new DateTime($targetDate);
    $dateStartedAdded =  $dateStartedAdded->format('Y-m-d');
    $targetDate =  $targetDate->format('Y-m-d');
  
    $selectUserTasks = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND  `realDate` BETWEEN '$dateStartedAdded' AND '$targetDate';";
    // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
    $result = mysqli_query($con, $selectUserTasks);
  
    $numrows = mysqli_num_rows($result);
    $don = "0";
    while($userRow = mysqli_fetch_assoc($result)){
      $noOfDays = $userRow['noOfDaysLate'];
      $isLate = $userRow['isLate'];
    
  
  }
  //new monthly code
  
  $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
  $result = mysqli_query($con, $selectUserTask);
  
  while($userRow = mysqli_fetch_assoc($result)){
    $dateStarted = $userRow['dateStarted'];
    $dateStartedAdded = $userRow['dateAdded'];
  
  }
  $dateStartedFromDataBase = date($dateStartedAdded);
  $dateForNow = date('Y-m-d');
  if($dateStartedFromDataBase >$dateForNow  ){
    echo '<span id = "doneORnot" class="mode mode_off">Upcoming</span>';
  
  }
  else{
  $date = new DateTime($dateStarted);
  $dateYear = new DateTime($dateStarted);
  
  $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
  $result = mysqli_query($con, $selectUserTask);
  
  while($userRow = mysqli_fetch_assoc($result)){
    $dateTarget = $userRow['targetDate'];
  }
  
  $dateYear->modify('next year');
  $nextYearSample =  $dateYear->format('Y');
  
  // $date = new DateTime($nextYearSample.'-04-01'); //pinalitan mo ito
  $date = new DateTime($dateStartedAdded);
  
  
  $nextYearApril =  $date->format('Y-m-d');
  
  $dateYear->modify('next year');
  $nextYearSample =  $dateYear->format('Y');
  
  // $date = new DateTime($nextYearSample.'-03-31');
  $date = new DateTime($dateTarget);                        //pinalitan mo ito
  $nextYearMarch=  $date->format('Y-m-d');            
  
  // $end = new DateTime(date('Y-m-d'));
  
  
  // $start = new DateTime($nextYearMarch);
  
  
  // $end->modify('+1 day');
  
  // $interval = $end->diff($start);
  
  // // total days
  // $finalDiff = $interval->days;
  
  $yearOfThisMonth = new DateTime(date('Y-m-d'));
  $Year_Now = $yearOfThisMonth->format('Y');
  
  // $nextYear = $date->modify('next year');
  // $nextYearHehe =  $nextYear->format('Y');
  // echo $nextYearHehe;
  
  $dateToday = date('Y-m-d');
  $dateToday=date('Y-m-d', strtotime($dateToday));
  //echo $paymentDate; // echos today! 
  $april = date('Y-m-d', strtotime($nextYearApril));
  $march = date('Y-m-d', strtotime($nextYearMarch));
    
  $april2 = date('Y-m-d', strtotime($nextYearApril));
  $march2 = date('Y-m-d', strtotime($nextYearMarch));
  // if (($dateToday >= $april) && ($dateToday <= $march)){
  //   // echo "is between";
  //   $finalDiff = "0";
  
  // }
  
  if(($dateToday >= $april2) && ($dateToday <= $march2)){
    $finalDiff = "0";
  
  }
  //https://stackoverflow.com/questions/19070116/php-check-if-date-between-two-dates
  else{
    // $date->modify('next year');
    $year =  $date->format('Y');
  
  // echo $year;
  // echo "<br>";
  $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
  $result = mysqli_query($con, $selectUserTask);
  
  while($userRow = mysqli_fetch_assoc($result)){
    $dateTarget = $userRow['targetDate'];
  }
  // $date = new DateTime($year.'-04-01');
  $date = new DateTime($dateTarget);
  
  $nextYearApril =  $date->format('Y-m-d');
  
  $end = new DateTime(date('Y-m-d'));
  
  
  $start = new DateTime($nextYearApril);
  
  
  $end->modify('+1 day');
  
  $interval = $end->diff($start);
  
  // total days
  $finalDiff = $interval->days;
  
      $period = new DatePeriod($start, new DateInterval('P1D'), $end);
      foreach($period as $dt) {
          $curr = $dt->format('D');
      // echo $curr;
     
  
          if ($curr == 'Sat' || $curr == 'Sun') {
            $finalDiff--;
          }
      
          if (in_array($dt->format('Y-m-d'), $holidays)) {
            $finalDiff--;
          }
      }
  // echo $finalDiff;
  }
  
      if ($numrows >= 1){
        if($isLate){
          echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
        }
        else{
          echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
        }
        $don = "1";
      //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
           }
           else{
            if($finalDiff >=2){
              // echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
              echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
              
                }
                else if($finalDiff <= 0){
              echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
                }
                else if($finalDiff ==1){
                  echo '<span class="⚠"></span><span id = "doneORnot" class="mode mode_done">Pending</span>';
                    }
           }
  
  
  //end of new monthly code
    // if ($numrows >= 1){
    //   if($isLate){
    //     echo '<span id = "doneORnot" class="mode mode_late">LATE</span>';
    //   }
    //   else{
    //     echo '<span id = "doneORnot" class="mode mode_on">DONE</span>';
    //   }
    //   $don = "1";
    // //  echo '<style type="text/css">#finished22 {pointer-events: none;}<style>';
    //      }
    //      else{
    //       $lastmonth =  date("F", strtotime("previous month"));
  
    //       $meronBaSiyaLastMonth = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$lastmonth' AND `year` = '$year1' ;";
    //       // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
    //       $resultm = mysqli_query($con, $meronBaSiyaLastMonth);
  
    //       $meronlastMonth = mysqli_num_rows($resultm);
  
    //       if($meronlastMonth >=1){
    //         echo '<span id = "doneORnot" class="mode mode_done">Pending</span>';
    //       }
    //       else if($meronlastMonth <=0){
    //     echo '<span id = "doneORnot" class="mode mode_near">Unaccomplished</span>';
    //       }
    //      }
  }
    }                             

 } ?> </td>
                                 <td style="width: 20%; ">
                                 <form method="POST" action="index.php" enctype="multipart/form-data" >
                                 <div class="modal fade" id="reasonModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                          <div class="modal-dialog" role="document">
                                            <div class="modal-content">
                                              <div class="modal-header">
                                                <h5 class="modal-title" id="exampleModalLabel">State your reason why are you late.</h5>
                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                  <span aria-hidden="true">&times;</span>
                                                </button>
                                              </div>
                                              <div class="modal-body">
                                           
                                           
                                             <div class="form-group" id="daysLateDiv">
                                                    <label for="message-text" class="col-form-label" >No. of days late</label>
                                                    <input class="form-control" name="daysLate" id="daysLate"></input>
                                                  </div>
                                                  <div class="form-group">
                                                    <label for="message-text" class="col-form-label" >Reason:</label>
                                                    <textarea class="form-control" name="reasonInput" id="getReason"></textarea>
                                                  </div>
                                                  <div class="form-group">
                                                    <label for="message-text" class="col-form-label">Action:</label>
                                                    <textarea class="form-control" name="ActionInputwithLate"  minlength="30" id="getAction"></textarea>
                                                  </div>
                                                  <div class="form-group">
                                                  <label for="message-text" class="col-form-label">Choose a file:</label>
                                                  
                     
                                       <input type="file" data-uploadId="<?php echo $data['usertaskID'] ?>" name="uploadedFile2" id="uploadedFile2" class="form-control" style="width: 180px; height: 30px; font-size: 10px; padding-top:0px" title=" Select ">
                                    <input  value="<?php  echo $data['taskName'];?>" style="display: none">
                                                                  
                                    </div>
                                                  <div class="modal-footer">
                                                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                                <button type="submit" name="reason" id="submitReasonAndAction" class="btn btn-primary">Save reason</button>
                                              </div>
                           
                                              </div>
                                            
                                            </div>
                                          </div>
                                        </div>
                                        <div class="modal fade" id="actionModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                          <div class="modal-dialog" role="document">
                                            <div class="modal-content">
                                              <div class="modal-header">
                                                <h5 class="modal-title" id="exampleModalLabel">State your action.</h5>
                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                  <span aria-hidden="true">&times;</span>
                                                </button>
                                              </div>
                                              <div class="modal-body">
                                             <div class="form-group">
                                             
                                                    <label for="message-text" class="col-form-label">Action:</label>
                                                    <textarea class="form-control"  name="actionInput" id="actionText"></textarea>
                                                  </div>
                                                  
                        <input type="text"name="idContainer" id="containerIdForFile" style="display: none">

                                                  <div class="form-group">
                                                  <label for="message-text" class="col-form-label">Choose a file:</label>
                                                  
                     
                                       <input type="file" data-uploadId="<?php echo $data['usertaskID'] ?>" name="uploadedFile" id="uploadedFile" class="form-control" style="width: 180px; height: 30px; font-size: 10px; padding-top:0px" title=" Select ">
                                    <input  value="<?php  echo $data['taskName'];?>" style="display: none">
                                                                  
                                    </div>
                                                  <div class="modal-footer">
                                                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                                <button type="submit" id="submitAction" name="action"class="btn btn-primary">Save action</button>
                                                <button style="display: none" type="submit" id="submitActions" name="testingaction"class="btn btn-primary" onclick="clickUpload()">test action</button>
                                                <input style="display: none" type="submit" id = "uploadsample" name="uploadBtn" value="Upload"class="btn btn-outline-success" style="font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto; display: block"  />
                                                <script>

                                        // // document.getElementById("uploadsample30").disabled = true;
                                    
                                        var uploadinput = document.getElementById('uploadedFile');

                                        // alert(fileId);
                                          // document.getElementById(fileInputId).removeAttribute("disabled");

                                        if(uploadinput.value == ''){
                                          document.getElementById('uploadsample').disabled = true;
                                        }else{
                                          document.getElementById('uploadsample').disabled = false;
                                        }

                                        $('input[type="file"]').change(function() {
                                          document.getElementById('uploadsample').disabled = false;

                                        });

                                        </script>
                                              </div>
                                            
                                              </div>
                                            
                                            </div>
                                          </div>
                                        </div>
                                        <div class="modal fade" id="reasonModalUpdate" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                          <div class="modal-dialog" role="document">
                                            <div class="modal-content">
                                              <div class="modal-header">
                                                <h5 class="modal-title" id="exampleModalLabel">Update your reason.</h5>
                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                  <span aria-hidden="true">&times;</span>
                                                </button>
                                              </div>
                                              <div class="modal-body">
                                           
                                           
                                            <input style="display: none" name="ForFinishedTaskName" id="ForFinishedTaskID"> 
                                                  <div class="form-group">
                                                    <label for="message-text" class="col-form-label">Reason:</label>
                                                    <textarea class="form-control" name="reasonInputUpdate" id="reasonUpdate1"></textarea>
                                                  </div>
                                                  <div class="form-group">
                                                    <label for="message-text" class="col-form-label">Action:</label>
                                                    <textarea class="form-control" name="actionInputUpdateLate" id="actionUpdate1"></textarea>
                                                  </div>
                                                  <div class="modal-footer">
                                                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                                <button type="submit" name="reasonUpdate" id="reasonAndActionUpdateOnly"class="btn btn-primary">Save reason</button>
                                              </div>
                           
                                              </div>
                                            
                                            </div>
                                          </div>
                                        </div>
                                        <div class="modal fade" id="actionModalUpdate" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                          <div class="modal-dialog" role="document">
                                            <div class="modal-content">
                                              <div class="modal-header">
                                                <h5 class="modal-title" id="exampleModalLabel">Update your action.</h5>
                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                  <span aria-hidden="true">&times;</span>
                                                </button>
                                              </div>
                                              <div class="modal-body">
                                           
                                           
                                              <input style="display: none" name="ForFinishedTaskNameForActionOnly" id="ForFinishedTaskIDActionOnly"> 
                                            
                                                  <div class="form-group">
                                                    <label for="message-text" class="col-form-label">Action:</label>
                                                    <textarea class="form-control" name="actionInputUpdate" id="actionUpdateText"></textarea>
                                                  </div>
                                                  
                                                  <div class="modal-footer">
                                                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                                <button type="submit" name="actionUpdate" id="submitUpdateAction" class="btn btn-primary">Save action</button>
                                              </div>
                           
                                              </div>
                                            
                                            </div>
                                          </div>
                                        </div>
                                        <?php
                                                              // echo $data['taskType'];
                                                     

                                                 
                                                      ?>
                                <div class="row">
                                
                                  
                                  <div class="col-9" style="padding-left: 0px">
                                      <!-- <a type="button" class="btn btn-outline-primary" style="font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" onclick="sendNotification();sendNotificationAgri()">  Finish</button> -->
                                      <!-- upload -->
                                     
                                  
                                      
                                      <!-- Finish -->
                                     <!-- <a onclick="checkIfLate(<?php echo $data['usertaskID'] ?>)" id= "checked<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Check</a> -->
                                     <?php $dateforToday = date('Y-m-d'); $dateTarget = $data['targetDate']; $dateStartedFromDataBase = $data['dateAdded']; 
                                     
                                    //  if($dateforToday > $dateTarget){ ?>
                                      <!-- <a  href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" class="btn btn-outline-secondary" style="pointer-events: none; font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a>
                                   <a class="btn btn-outline-secondary" href="#" style=" pointer-events: none; font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                      -->
                                        <?php 
                                        
                                        // }
                                         if($dateStartedFromDataBase >$dateforToday  ){
                                          ?> <a  href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" class="btn btn-outline-secondary" style="pointer-events: none; font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a>
                                          <a class="btn btn-outline-secondary" href="#" style=" pointer-events: none; font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            <?php
       
                                         }
                                         else if($ended){
                                          ?> <a  href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" class="btn btn-outline-secondary" style="pointer-events: none; font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a>
                                          <a class="btn btn-outline-secondary" href="#" style=" pointer-events: none; font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            <?php
       
                                         }
                           

                                   
                                        else{
                                     
                                          ?>
                                          
                                      

                                     <a href="index.php?Finish=<?php echo $data['usertaskID'] ?>" style="display: none" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a>
                                        <!-- <a href="index.php?Cancel=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'danger';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:30px; margin:0 auto;" >X</a> -->
                                        <a href="index.php?FinishSample=<?php echo $data['usertaskID']; $passUserTaskId = $data['usertaskID']; ?>" onclick="passAction('<?php echo $passUserTaskId; ?>')" id= "finishedsample<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a>
                                      
                                      <?php
                                       $taskID = $data['usertaskID'];
                                       $taskType =  $data['taskType'];       
                                       $noOfDays = "";
                                        if ($taskType == 'weekly'){
                                          
                                                         
                                    $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$month' AND `year` = '$year' AND `week` = 'week $weekMonth';";
                                    // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                    $result = mysqli_query($con, $selectUserTask);

                                    $numrows = mysqli_num_rows($result);

                                    // $don = "0";
                                    while($userRow = mysqli_fetch_assoc($result)){
                                      $fTaskId = $userRow['sameID'];
                                      $noOfDays = $userRow['noOfDaysLate'];
                                      $reason = $userRow['reason'];
                                      $action = $userRow['action'];
                                      $isLates = $userRow['isLate'];
                                      // echo $isLates;
                                  }
                            if($numrows>0){
                              if($isLates){
                                ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                   <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                   <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>"  data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                 

                                   

                                 <?php
                               }
                            else{

                            
                               // echo $noOfDays;
                               ?>
                                   <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                   <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                   <!-- <span class="mode mode_late"><a style = "color: white" href="#" data-location="<?php echo $fileloc?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'><?php echo $dateN ?></a></span> -->
                                   <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#"  data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                 
                                   <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->

                                
                                   <?php
                            }
                            }
                            else{
                              if($noOfDays>=3){
                                ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                   <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                   <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>"  data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                 

                                   

                                 <?php
                               }
                            else{

                            
                               // echo $noOfDays;
                               ?>
                                   <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                   <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                   <!-- <span class="mode mode_late"><a style = "color: white" href="#" data-location="<?php echo $fileloc?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'><?php echo $dateN ?></a></span> -->
                                   <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#"  data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                 
                                   <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->

                                
                                   <?php
                            }
                            }

                               ?>
                                      <!-- <a href="index.php?Cancel=<?php echo $fTaskId ?>" id= "cancel<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'danger';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:30px; margin:0 auto;" >X</a> -->
                                          <?php
                                        }


                                        else if ($taskType == 'monthly'){
                                                                      
                                    $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$month' AND `year` = '$year'";
                                    // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                    $result = mysqli_query($con, $selectUserTask);

                                    $numrows = mysqli_num_rows($result);

                                    // $don = "0";
                                    while($userRow = mysqli_fetch_assoc($result)){
                                      $fTaskId = $userRow['sameID'];
                                      $noOfDays = $userRow['noOfDaysLate'];
                                      $reason = $userRow['reason'];
                                      $action = $userRow['action'];
                                      $isLate = $userRow['isLate'];
                                  }
                                  if($numrows>0){
                                    if($isLate){
                                      ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                      <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                      <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                    
                                       <?php
                                     }
                                  else{
                                    //  echo $noOfDays;
                                    ?>
                                   <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                        <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                        <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                      
                                        
                                        <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                        <?php
                                  }
                                  }
                                  else{
                                    if($noOfDays>=3){
                                      ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                      <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                      <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                    
                                       <?php
                                     }
                                  else{
                                    //  echo $noOfDays;
                                    ?>
                                   <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                        <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                        <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                      
                                        
                                        <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                        <?php
                                  }
                                  }
                                  
                                ?>
                                      <!-- <a href="index.php?Cancel=<?php echo $fTaskId ?>" id= "cancel<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'danger';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:30px; margin:0 auto;" >X</a> -->
                                      <?php
                                        }
                                        else if ($taskType == 'annual'){

                                          $dateOfNow = new DateTime(date('Y-m-d'));
                                          $MonthOfNow =  $dateOfNow->format('F');
                                          $YearToUseForApril = "";
                                          $YearToUseforMarch = "";
                                          if($MonthOfNow=="January" || $MonthOfNow=="February" || $MonthOfNow=="March"){
                                        
                                            $YearToUseforMarch =  $dateOfNow->format('Y');
                                            $dateOfNow->modify('last year');
                                            $YearToUseForApril =  $dateOfNow->format('Y');
                                          }
                                          else{
                                            $YearToUseForApril =  $dateOfNow->format('Y');
                                        $dateOfNow->modify('next year');
                                        $YearToUseforMarch =  $dateOfNow->format('Y');
                                        
                                        
                                          }
                                        
                                          $April = new DateTime($YearToUseForApril.'-04-01');
                                          $March = new DateTime($YearToUseforMarch.'-03-31');
                                          $April =  $April->format('Y-m-d');
                                          $March =  $March->format('Y-m-d');
                                        
                                          $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND  `DateSubmitted` BETWEEN '$April' AND '$March';";
                                          // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                          $result = mysqli_query($con, $selectUserTask);
      
                                          $numrows = mysqli_num_rows($result);
      
                                          // $don = "0";
                                          while($userRow = mysqli_fetch_assoc($result)){
                                            $fTaskId = $userRow['sameID'];
                                            $noOfDays = $userRow['noOfDaysLate'];
                                            $reason = $userRow['reason'];
                                            $action = $userRow['action'];
                                            $isLate = $userRow['isLate'];
                                        }
                                        if($numrows>0){
                                          if($isLate){
                                            ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                            <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                          
                                             <?php
                                           }
                                        else{
                                          //  echo $noOfDays;
                                          ?>
                                         <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                              <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                              <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            
                                              
                                              <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                              <?php
                                        }
                                        }
                                        else{
                                          if($noOfDays>=3){
                                            ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                            <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                          
                                             <?php
                                           }
                                        else{
                                          //  echo $noOfDays;
                                          ?>
                                         <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                              <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                              <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            
                                              
                                              <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                              <?php
                                        }
                                        }
                                        
                                      ?>
                                            <!-- <a href="index.php?Cancel=<?php echo $fTaskId ?>" id= "cancel<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'danger';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:30px; margin:0 auto;" >X</a> -->
                                            <?php
                                              }


                                        else if ($taskType == 'daily'){
                                          $today = $_SESSION['today'];              
                                          $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `Date` = ' $today';";
                                          // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                          $result = mysqli_query($con, $selectUserTask);
      
                                          $numrows = mysqli_num_rows($result);
      
                                          // $don = "0";
                                          
                                            while($userRow = mysqli_fetch_assoc($result)){
                                              $fTaskId = $userRow['sameID'];
                                      $noOfDays = $userRow['noOfDaysLate'];
                                      $reason = $userRow['reason'];
                                      $action = $userRow['action'];
                                      $isLate = $userRow['isLate'];
                                          }
                                          if($numrows>0){
                                            if($isLate){
                                              ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                              <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                        <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" data-fid="<?php echo $fTaskId ?>" href="#"  data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            
                                               <?php
                                             }
                                             else{
                                          ?>
                                                    <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                        <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                        <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>"  data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                
                                          
                                              <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                              <?php
                                             }
                                          }
                                          else{
                                            if($noOfDays>=2){
                                              ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                              <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                        <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" data-fid="<?php echo $fTaskId ?>" href="#"  data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                            
                                               <?php
                                             }
                                             else{
                                          ?>
                                                    <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                        <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                        <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>"  data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                
                                          
                                              <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                              <?php
                                             }
                                          }
                                          // echo $noOfDays;
                                          
                                           ?>
                                            <!-- <a href="index.php?Cancel=<?php echo $fTaskId ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'danger';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:30px; margin:0 auto;" >X</a> -->
<?php
                                              }
                                              else if ($taskType == 'others'){
                                                $dateOfNow = new DateTime(date('Y-m-d'));
                                                $MonthOfNow =  $dateOfNow->format('F');
                                                $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
                                                $result = mysqli_query($con, $selectUserTask);
                                                
                                                while($userRow = mysqli_fetch_assoc($result)){
                                                  $dateStartedAdded = $userRow['dateAdded'];
                                                  $targetDate = $userRow['targetDate'];
                                                
                                                }
                                                
                                                  $dateStartedAdded = new DateTime($dateStartedAdded);
                                                  $targetDate = new DateTime($targetDate);
                                                  $dateStartedAdded =  $dateStartedAdded->format('Y-m-d');
                                                  $targetDate =  $targetDate->format('Y-m-d');
                                                
                                                  $selectUserTasks = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND  `realDate` BETWEEN '$dateStartedAdded' AND '$targetDate';";
                                                // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
                                                $result = mysqli_query($con, $selectUserTasks);
            
                                                $numrows = mysqli_num_rows($result);
            
                                                // $don = "0";
                                                while($userRow = mysqli_fetch_assoc($result)){
                                                  $fTaskId = $userRow['sameID'];
                                                  $noOfDays = $userRow['noOfDaysLate'];
                                                  $reason = $userRow['reason'];
                                                  $action = $userRow['action'];
                                                  $isLate = $userRow['isLate'];
                                              }
                                              if($numrows>0){
                                                if($isLate){
                                                  ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                  <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                                  <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                
                                                   <?php
                                                 }
                                              else{
                                                //  echo $noOfDays;
                                                ?>
                                               <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                    <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                                    <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                  
                                                    
                                                    <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                                    <?php
                                              }
                                              }
                                              else{
                                                if($noOfDays>=3){
                                                  ?> <a href="index.php?Update=<?php echo $fTaskId ?>" style="display: none" id= "updates<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                  <!-- <a href="index.php?UpdateModal=<?php echo $fTaskId ?>"  id= "update<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                                  <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#reasonModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                
                                                   <?php
                                                 }
                                              else{
                                                //  echo $noOfDays;
                                                ?>
                                               <a href="index.php?UpdateAction=<?php echo $fTaskId ?>" style="display: none" id= "updatesAction<?php echo $fTaskId ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                    <!-- <a href="index.php?UpdateModalAction=<?php echo $fTaskId ?>"  id= "updateAction<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a> -->
                                                    <a class="btn btn-outline-<?php if($don == "1"){ echo 'info';} else{ echo 'secondary';}?>" href="#" data-fid="<?php echo $fTaskId ?>" data-reason="<?php echo $reason?>" data-action="<?php echo $action?>"  data-toggle='modal' data-target='#actionModalUpdate'       style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Update</a>
                                                  
                                                    
                                                    <!-- <a href="index.php?FinishSample=<?php echo $data['usertaskID'] ?>" id= "finished<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'secondary';} else{ echo 'primary';}?>" style="<?php if($don == "1"){ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:60px; margin:0 auto;" >Finish</a> -->
                                                    <?php
                                              }
                                              }
                                              
                                            ?>
                                                  <!-- <a href="index.php?Cancel=<?php echo $fTaskId ?>" id= "cancel<?php echo $data['usertaskID'] ?>"class="btn btn-outline-<?php if($don == "1"){ echo 'danger';} else{ echo 'secondary';}?>" style="<?php if($don == "1"){ ?> pointer-events: auto; <?php } else{ ?> pointer-events: none; <?php } ?>font-size: 15px; padding: 3px; height: 25px;width:30px; margin:0 auto;" >X</a> -->
                                                  <?php
                                                    }
                                       ?>
                                     
                                     <?php
                                        } ?>
                                      
                                    </div>
                                    
                                </div>
                            
                                </form>
                              </td>

                                <!-- <td><?php echo $data['taskCategory']??''; ?></td> -->
                              
                             </tr>
                             <?php
                            $sn++;}}else{ ?>
                            <tr>
                              <td colspan="8">
                          <?php echo $fetchData; ?>
                        </td>
                            </tr>
                          <?php
    }
    if(isset($_GET['UpdateModal'])){
      $_SESSION['TaskID'] = $_GET['UpdateModal'];
      $taskID = $_SESSION['TaskID'];
      $getReason = "SELECT `reason`, `action` FROM `finishedtask` WHERE FinishedTaskID = '$taskID' LIMIT 1";
      $result = mysqli_query($con, $getReason);

      while($userRow = mysqli_fetch_assoc($result)){
        // $today = $userRow['dateStarted'];
        $reason = $userRow['reason'];
        $action = $userRow['action'];


      }

      echo "<script> 
      document.getElementById('reasonUpdate1').value='$reason';
      document.getElementById('actionUpdate1').value='$action';

      $('#reasonModalUpdate').modal('show');
      </script>";
    }

  
    if(isset($_GET['UpdateModalAction'])){
      $_SESSION['TaskID'] = $_GET['UpdateModalAction'];
      $taskID = $_SESSION['TaskID'];
      $getAction = "SELECT `action` FROM `finishedtask` WHERE FinishedTaskID = '$taskID' LIMIT 1";
      $result = mysqli_query($con, $getAction);

      while($userRow = mysqli_fetch_assoc($result)){
        // $today = $userRow['dateStarted'];
        $action = $userRow['action'];


      }
      echo "<script> 
      document.getElementById('actionUpdateText').value='$action';
      $('#actionModalUpdate').modal('show');
      </script>";
    }
    
    if(isset($_GET['FinishSample'])){
      $taskID = $_GET['FinishSample'];
      echo "<script> console.log('$taskID');</script>";
      $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
      $result = mysqli_query($con, $selectUserTask);
      
      while($userRow = mysqli_fetch_assoc($result)){
        // $today = $userRow['dateStarted'];
        $taskType = $userRow['taskType'];
      }
//       // $today = $_SESSION['today'];
//       $from=date_create(date('Y-m-d'));
//       $to=date_create(date('Y-m-d', strtotime($today)));
//       $diff=date_diff($to,$from);
//       // print_r($diff);
//       $reason =  $_SESSION['reason'];
//       $finalDiff =  $diff->format('%R%a');
//       if($finalDiff >=3 &&  $reason==""){
       
//     echo "<script> $('#reasonModal').modal('show');
// console.log($finalDiff);
//     document.getElementById('daysLate').value=$finalDiff;
//     </script>";
//     $_SESSION['noOfDaysLate']=$finalDiff;
//     $_SESSION['TaskID'] = $_GET['FinishSample'];
//       }
//       else{
//     $_SESSION['noOfDaysLate']=$finalDiff;
//         $_SESSION['TaskID'] = $_GET['FinishSample'];
//         $taskID = $_SESSION['TaskID'];
//         echo "<script>  
//           document.getElementById('finished$taskID').click();      

//           </script>";
//       }


// echo("<script>console.log('emmeeeememem: " . $taskID. "');</script>");
// $month = date("F");
// $year = date("Y");
$weeknumberrr = weekOfMonth($_SESSION['date_string']);
// echo("<script>console.log('hahahah: " .$weeknumberrr. "');</script>");

if ($taskType == 'weekly'){
//find
          $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
          $result = mysqli_query($con, $selectUserTask);

          while($userRow = mysqli_fetch_assoc($result)){
            $dateStarted = $userRow['dateStarted'];
          }

          $date = new DateTime($dateStarted);
          // echo "Next monday is: ";
          $date->modify('next monday');
          // $date->format('Y-m-d');
          $DateEnd =  $date->format('Y-m-d');
          $end = new DateTime(date('Y-m-d'));
          $start = new DateTime($DateEnd);
        // otherwise the  end date is excluded (bug?)
          $end->modify('+1 day');

          $interval = $end->diff($start);

          // total days
          $finalDiff = $interval->days;

          // create an iterateable period of date (P1D equates to 1 day)
          $period = new DatePeriod($start, new DateInterval('P1D'), $end);

          // best stored as array, so you can add more than one
          // $holidays = array('2012-09-07');
          // $holidays = $holidaysArray;
              
          foreach($period as $dt) {
              $curr = $dt->format('D');

              // substract if Saturday or Sunday
              if ($curr == 'Sat' || $curr == 'Sun') {
                $finalDiff--;
              }

              // (optional) for the updated question
              elseif (in_array($dt->format('Y-m-d'), $holidays)) {
                $finalDiff--;
              }
          }

          // $finalDiff=$finalDiff-1;

          $mondaylw =  date("Y-m-d", strtotime("monday last week"));
          $sundaylw =  date("Y-m-d", strtotime("sunday last week"));
             
          $meronBaSiyaLastWeek = "SELECT * FROM `finishedtask` WHERE `taskID` = '$taskID' AND `realDate` BETWEEN '$mondaylw' AND '$sundaylw';";
          // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
          $result = mysqli_query($con, $meronBaSiyaLastWeek);
          $meron = mysqli_num_rows($result);
          $finalDiff = $finalDiff - 5;
          if($finalDiff >0){
             // August 10, 2022 changes
           
            $_SESSION['noOfDaysLate']=$finalDiff;
            $_SESSION['TaskID'] = $_GET['FinishSample'];
            echo "<script> 
            // document.getElementById('daysLateDiv').style.display = 'none';
            $('#reasonModal').modal('show');
// console.log($finalDiff);
  document.getElementById('daysLate').value=$finalDiff;
  </script>";
          }
          else if($finalDiff <=0){
     $_SESSION['noOfDaysLate']='0';
         $_SESSION['TaskID'] = $_GET['FinishSample'];
         $taskID = $_SESSION['TaskID'];
         echo "<script>  
        $('#actionModal').modal('show');

           //document.getElementById('finished$taskID').click();   DITO AKO NATAPOS   
                   </script>";

          }
          
         
    }
    else if($taskType == 'monthly'){


 
      $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
      $result = mysqli_query($con, $selectUserTask);

      while($userRow = mysqli_fetch_assoc($result)){
        $dateStarted = $userRow['dateStarted'];
      }

      $date = new DateTime($dateStarted);
      $datenow = new DateTime($dateStarted);


      $dateStarteds = new DateTime($dateStarted);
      $monthOfLastDate =  $dateStarteds->format('F');
          $yearOfLastDate =  $dateStarteds->format('Y');
    
          $monthofThisMonth = new DateTime(date('Y-m-d'));
          $Month_Now = $monthofThisMonth->format('F');
          $yearOfThisMonth = new DateTime(date('Y-m-d'));
          $Year_Now = $yearOfThisMonth->format('Y');
    

          $nextMonth = $date->modify('next month');
          // $date->format('Y-m-d');
          $nextMonthHehe =  $nextMonth->format('F');
          $yearOfNextDate =  $date->format('Y');


          if($nextMonthHehe == $Month_Now ){

$finalDiff = "0";
$finalDiff2 = "2";

            
//       // $date->format('Y-m-d');
//       $monthOfDate =  $date->format('F');
//       $year =  $date->format('Y');

// $fDateOfTheMonth = new DateTime('first day of '.$monthOfDate. $year);
// $FDateofThisMonth =  $fDateOfTheMonth->format('Y-m-d');

//       // echo $FDateofThisMonth;

//       $lDateOfTheMonth = new DateTime('last day of '.$monthOfDate. $year);
//       $LDateofThisMonth =  $lDateOfTheMonth->format('Y-m-d');
//           // echo $FDateofThisMonth;

//       $end2 = new DateTime(date($LDateofThisMonth));
//       $start2 = new DateTime($FDateofThisMonth);
//     // otherwise the  end date is excluded (bug?)
//       $end2->modify('+1 day');

//       $interval2 = $end2->diff($start2);

//       // total days
//       $finalDiff2 = $interval2->days;

//       // create an iterateable period of date (P1D equates to 1 day)
//       $period2 = new DatePeriod($start2, new DateInterval('P1D'), $end2);

//       // best stored as array, so you can add more than one
//       $holidays2 = array('2012-09-07');

//       foreach($period2 as $dt2) {
//           $curr2 = $dt2->format('D');

//           // substract if Saturday or Sunday
//           if ($curr2 == 'Sat' || $curr2 == 'Sun') {
//             $finalDiff2--;
//           }

//           // (optional) for the updated question
//           elseif (in_array($dt2->format('Y-m-d'), $holidays2)) {
//             $finalDiff2--;
//           }
//       }
//       $finalDiff3 = $finalDiff2;
// $finalDiff2 = $finalDiff2+2;


//             // $date->format('Y-m-d');
//             $monthOfDate =  $date->format('F');
//             $year =  $date->format('Y');
     
      
      
//             // $date->format('Y-m-d');
//             // $DateEnd =  $date->format('Y-m-d');
//             $end = new DateTime(date('Y-m-d'));
//             $start = new DateTime($dateStarted);
      
      
//             // echo $n1 + $n2;
      
      
      
//             $eememe =  $end->format('Y-m-d');
//               $DateEnd =  $start->format('Y-m-d');
//           // otherwise the  end date is excluded (bug?)
//             $end->modify('+1 day');
           
//             $interval = $end->diff($start);
      
//             // total days
//             $finalDiff = $interval->days;
      
//             // create an iterateable period of date (P1D equates to 1 day)
//             $period = new DatePeriod($start, new DateInterval('P1D'), $end);
      
//             // best stored as array, so you can add more than one
//             $holidays = array('2012-09-07');
      
//             foreach($period as $dt) {
//                 $curr = $dt->format('D');
      
//                 // substract if Saturday or Sunday
//                 if ($curr == 'Sat' || $curr == 'Sun') {
//                   $finalDiff--;
//                 }
      
//                 // (optional) for the updated question
//                 elseif (in_array($dt->format('Y-m-d'), $holidays)) {
//                   $finalDiff--;
//                 }
//             }
//             $finalDiff = $finalDiff-2;
          }
          else{
          // echo "Next monday is: ";
      // $date->modify('next monday');


      // echo "Next monday is: ";
      // $date->modify('next monday');


      // echo "Next monday is: ";
      $date->modify('next month');
      // $date->format('Y-m-d');
      $monthOfDate =  $date->format('F');
      $year =  $date->format('Y');

$fDateOfTheMonth = new DateTime('first day of '.$monthOfDate. $year);
$FDateofThisMonth =  $fDateOfTheMonth->format('Y-m-d');

      // echo $FDateofThisMonth;

      $lDateOfTheMonth = new DateTime('last day of '.$monthOfDate. $year);
      $LDateofThisMonth =  $lDateOfTheMonth->format('Y-m-d');
          // echo $FDateofThisMonth;

      $end2 = new DateTime(date($LDateofThisMonth));
      $start2 = new DateTime($FDateofThisMonth);
    // otherwise the  end date is excluded (bug?)
      $end2->modify('+1 day');

      $interval2 = $end2->diff($start2);

      // total days
      $finalDiff2 = $interval2->days;

      // create an iterateable period of date (P1D equates to 1 day)
      $period2 = new DatePeriod($start2, new DateInterval('P1D'), $end2);

      // best stored as array, so you can add more than one
      // $holidays2 = array('2012-09-07');
      $holidays2 = $holidaysArray;
        
      foreach($period2 as $dt2) {
          $curr2 = $dt2->format('D');

          // substract if Saturday or Sunday
          if ($curr2 == 'Sat' || $curr2 == 'Sun') {
            $finalDiff2--;
          }

          // (optional) for the updated question
          elseif (in_array($dt2->format('Y-m-d'), $holidays2)) {
            $finalDiff2--;
          }
      }
      $finalDiff3 = $finalDiff2;

$finalDiff2 = $finalDiff2+2;




      // $date->format('Y-m-d');
      // $DateEnd =  $date->format('Y-m-d');
      $end = new DateTime(date('Y-m-d'));
      // $end = new DateTime('2022-06-30');

      $start = new DateTime($FDateofThisMonth);



      $from=date_create(date('Y-m-d'));
      $to=date_create($FDateofThisMonth);
      $diff=date_diff($to,$from);
      // print_r($diff);
      // echo $diff->format('%R%a');
      
      $Difference = $diff->format('%R%a');

      // echo $n1 + $n2;



      $eememe =  $end->format('Y-m-d');
        $DateEnd =  $start->format('Y-m-d');
    // otherwise the  end date is excluded (bug?)
      $end->modify('+1 day');
     
      $interval = $end->diff($start);

      // total days
      $finalDiff = $interval->days;

      // create an iterateable period of date (P1D equates to 1 day)
      $period = new DatePeriod($start, new DateInterval('P1D'), $end);

      // best stored as array, so you can add more than one
       //$holidays = array('2022-08-15');


      //  $holidays = $holidaysArray;
      //  print($holidaysArray[1]);
//        $myarray = array(1,2,3,4,5,6,7,7);
// // Print PHP array using echo and print() functions.
// echo $myarray[2];
// print($myarray[0]); 
//        echo "<script> 
  
//        console.log('$holidays');
// </script>";
      foreach($period as $dt) {
          $curr = $dt->format('D');

          // substract if Saturday or Sunday
          if ($curr == 'Sat' || $curr == 'Sun') {
            $finalDiff--;
          }

          // (optional) for the updated question
          else if (in_array($dt->format('Y-m-d'), $holidays)) {
            $finalDiff--;
          }
      }
      $finalDifFinal = $finalDiff - $finalDiff3;

          }




      // $finalDiff=$finalDiff-1;
      // $start =  $start->format('Y');
      $mondaylw =  date("Y-m-d", strtotime("monday last week"));
      $sundaylw =  date("Y-m-d", strtotime("sunday last week"));
         
      $meronBaSiyaLastWeek = "SELECT * FROM `finishedtask` WHERE `taskID` = '$taskID' AND `realDate` BETWEEN '$mondaylw' AND '$sundaylw';";
      // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
      $result = mysqli_query($con, $meronBaSiyaLastWeek);
      $meron = mysqli_num_rows($result);
      if($finalDiff >0){
        $_SESSION['noOfDaysLate']=$finalDiff;
        $_SESSION['TaskID'] = $_GET['FinishSample'];
        // echo $eememe;
        echo "<script> 
        // document.getElementById('daysLateDiv').style.display = 'none';
        console.log('$finalDiff');
        $('#reasonModal').modal('show');
console.log('$eememe');
document.getElementById('daysLate').value='$finalDiff';
</script>";
      }
      else if($finalDiff == 0){
 $_SESSION['noOfDaysLate']='0';
     $_SESSION['TaskID'] = $_GET['FinishSample'];
     $taskID = $_SESSION['TaskID'];

     echo "<script>  
// document.getElementById('actionText').value='$finalDiff';

    $('#actionModal').modal('show');


       //document.getElementById('finished$taskID').click();   DITO AKO NATAPOS   
               </script>";

      }
      
     // $year1 = $_SESSION['year'];
        //                 $lastmonth =  date("F", strtotime("previous month"));

        //                 $meronBaSiyaLastMonth = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND `month` = '$lastmonth' AND `year` = '$year1' ;";
        //                 // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
        //                 $resultm = mysqli_query($con, $meronBaSiyaLastMonth);

        //                 $meronlastMonth = mysqli_num_rows($resultm);

        //                 if($meronlastMonth >=1){
        //                   $_SESSION['noOfDaysLate']='0';
        //  $_SESSION['TaskID'] = $_GET['FinishSample'];
        //  $taskID = $_SESSION['TaskID'];
        //  echo "<script>  
        //  $('#actionModal').modal('show');
        //   //  document.getElementById('finished$taskID').click();    DITO AKO NATAPOS  
        //            </script>";

        //                 }
        //                 else if($meronlastMonth <=0){
        //                   $_SESSION['noOfDaysLate']= '4';
        //                   $_SESSION['TaskID'] = $_GET['FinishSample'];
        //                   echo "<script> 
        //                   document.getElementById('daysLateDiv').style.display = 'none';
        //                   $('#reasonModal').modal('show');
      
        //         </script>";

        //                 }
                       
    
    }
    else if($taskType == 'annual'){


 
      $dateOfNow = new DateTime(date('Y-m-d'));
      $MonthOfNow =  $dateOfNow->format('F');
      $YearToUseForApril = "";
      $YearToUseforMarch = "";
      if($MonthOfNow=="January" || $MonthOfNow=="February" || $MonthOfNow=="March"){
    
        $YearToUseforMarch =  $dateOfNow->format('Y');
        $dateOfNow->modify('last year');
        $YearToUseForApril =  $dateOfNow->format('Y');
      }
      else{
        $YearToUseForApril =  $dateOfNow->format('Y');
    $dateOfNow->modify('next year');
    $YearToUseforMarch =  $dateOfNow->format('Y');
    
    
      }
    
      $April = new DateTime($YearToUseForApril.'-04-01');
      $March = new DateTime($YearToUseforMarch.'-03-31');
      $April =  $April->format('Y-m-d');
      $March =  $March->format('Y-m-d');
    
      $selectUserTask = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND  `DateSubmitted` BETWEEN '$April' AND '$March';";
      // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
      $result = mysqli_query($con, $selectUserTask);
    
      $numrows = mysqli_num_rows($result);
      $don = "0";
      while($userRow = mysqli_fetch_assoc($result)){
        $noOfDays = $userRow['noOfDaysLate'];
        $isLate = $userRow['isLate'];
      
    
    }
    //new monthly code
    
    $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
    $result = mysqli_query($con, $selectUserTask);
    
    while($userRow = mysqli_fetch_assoc($result)){
      $dateStarted = $userRow['dateStarted'];
      $dateAdded = $userRow['dateAdded'];
      $targetDate = $userRow['targetDate'];


    }
    
    $date = new DateTime($dateStarted);
    $dateYear = new DateTime($dateStarted);
    $dateYear->modify('next year');
$nextYearSample =  $dateYear->format('Y');

// $date = new DateTime($nextYearSample.'-04-01');
$date = new DateTime($dateAdded);

$nextYearApril =  $date->format('Y-m-d');

$dateYear->modify('next year');
$nextYearSample =  $dateYear->format('Y');

$date = new DateTime($targetDate);
// $date = new DateTime($nextYearSample.'-03-31');
$nextYearMarch=  $date->format('Y-m-d');
    
$yearOfThisMonth = new DateTime(date('Y-m-d'));
$Year_Now = $yearOfThisMonth->format('Y');

// $nextYear = $date->modify('next year');
// $nextYearHehe =  $nextYear->format('Y');
// echo $nextYearHehe;

$dateToday = date('Y-m-d'); //ibalik sa Y-m-d
$dateToday=date('Y-m-d', strtotime($dateToday));
//echo $paymentDate; // echos today! 
$april = date('Y-m-d', strtotime($nextYearApril));
$march = date('Y-m-d', strtotime($nextYearMarch));
$april2 = date('Y-m-d', strtotime($dateAdded));
$march2 = date('Y-m-d', strtotime($targetDate));
if(($dateToday >= $april2) && ($dateToday <= $march2)){
  $finalDiff = "0";

}
// if (($dateToday >= $april) && ($dateToday <= $march)){
//   // echo "is between";
//   $finalDiff = "0";

// }
else{
  // $date->modify('next year');
  $year =  $date->format('Y');

// echo $year;
// echo "<br>";
// $date = new DateTime($year.'-04-01');

$date = new DateTime($targetDate);

$nextYearApril =  $date->format('Y-m-d');

$end = new DateTime(date('Y-m-d'));


$start = new DateTime($nextYearApril);

$start->modify('+1 day');

$end->modify('+1 day');

$interval = $end->diff($start);

// total days
$finalDiff = $interval->days;

    $period = new DatePeriod($start, new DateInterval('P1D'), $end);
    foreach($period as $dt) {
        $curr = $dt->format('D');
    // echo $curr;
   

        if ($curr == 'Sat' || $curr == 'Sun') {
          $finalDiff--;
        }
    
        if (in_array($dt->format('Y-m-d'), $holidays)) {
          $finalDiff--;
        }
    }
// echo $finalDiff;
}
      // echo $finalDiff;
  
    if($finalDiff >= 1){
      

      $_SESSION['noOfDaysLate']=$finalDiff;
      $_SESSION['TaskID'] = $_GET['FinishSample'];
      // echo $eememe;
      echo "<script> 
      // document.getElementById('daysLateDiv').style.display = 'none';
      console.log('$finalDiff');
      $('#reasonModal').modal('show');
      
document.getElementById('daysLate').value='$finalDiff';
</script>";
    }
    else if($finalDiff <= 0){
   

$_SESSION['noOfDaysLate']='0';
   $_SESSION['TaskID'] = $_GET['FinishSample'];
   $taskID = $_SESSION['TaskID'];

   echo "<script>  


  $('#actionModal').modal('show');


     //document.getElementById('finished$taskID').click();   DITO AKO NATAPOS   
             </script>";

    }
    
  
  }
    else if($taskType == 'daily'){

  
          $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
          $result = mysqli_query($con, $selectUserTask);
          
          while($userRow = mysqli_fetch_assoc($result)){
            $today = $userRow['dateStarted'];
          }
          $datesssss = new DateTime($today);
  
          $weekssss = $datesssss->format("D");
          if($weekssss == "Sat"){
            $datesssss->modify("-1 day");
  $today =  $datesssss->format('Y-m-d');

          }
          else if($weekssss == "Sun"){
            $datesssss->modify("-2 day");
            $today =  $datesssss->format('Y-m-d');

          }
          // $from=date_create(date('Y-m-d'));
          // $to=date_create(date('Y-m-d', strtotime($today)));
          // $diff=date_diff($to,$from);
          // // print_r($diff);
          // $finalDiff =  $diff->format('%R%a');
          // $finalDiff = $finalDiff-1;

          $end = new DateTime(date('Y-m-d'));
          $start = new DateTime(date('Y-m-d', strtotime($today)));
// otherwise the  end date is excluded (bug?)
// $end->modify('+1 day');

$interval = $end->diff($start);

// total days
$finalDiff = $interval->days;

// create an iterateable period of date (P1D equates to 1 day)
$period = new DatePeriod($start, new DateInterval('P1D'), $end);

// best stored as array, so you can add more than one
//$holidays = array('2012-09-07');

foreach($period as $dt) {
    $curr = $dt->format('D');

    // substract if Saturday or Sunday
    if ($curr == 'Sat' || $curr == 'Sun') {
      $finalDiff--;
    }

    // (optional) for the updated question
    elseif (in_array($dt->format('Y-m-d'), $holidays)) {
      $finalDiff--;
    }
}

$finalDiff=$finalDiff-1;
          if($finalDiff >=1 ){
            $_SESSION['noOfDaysLate']=$finalDiff;
         $_SESSION['TaskID'] = $_GET['FinishSample'];
         $taskID = $_SESSION['TaskID'];
            echo "<script> 
            $('#reasonModal').modal('show');
// console.log($finalDiff);
  document.getElementById('daysLate').value=$finalDiff;
  </script>";
              }
              else {
                $_SESSION['noOfDaysLate']=$finalDiff;
         $_SESSION['TaskID'] = $_GET['FinishSample'];
         $taskID = $_SESSION['TaskID'];
         echo "<script>  
         console.log('$taskID');
         $('#actionModal').modal('show');
         document.getElementById('containerIdForFile').value='$taskID';



          //  document.getElementById('finished$taskID').click();     DITO AKO NATAPOS 
                     </script>";
                  }
         
    }
    else if($taskType == 'others'){


 
      $dateOfNow = new DateTime(date('Y-m-d'));
      $MonthOfNow =  $dateOfNow->format('F');
      $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
      $result = mysqli_query($con, $selectUserTask);
      
      while($userRow = mysqli_fetch_assoc($result)){
        $dateStartedAdded = $userRow['dateAdded'];
        $targetDate = $userRow['targetDate'];
      
      }
      
        $dateStartedAdded = new DateTime($dateStartedAdded);
        $targetDate = new DateTime($targetDate);
        $dateStartedAdded =  $dateStartedAdded->format('Y-m-d');
        $targetDate =  $targetDate->format('Y-m-d');
      
        $selectUserTasks = "SELECT * FROM finishedtask WHERE taskID = '$taskID' AND  `realDate` BETWEEN '$dateStartedAdded' AND '$targetDate';";
      // SELECT week FROM `finishedtask` WHERE `taskID` = '23';
      $result = mysqli_query($con, $selectUserTasks);

    
      $numrows = mysqli_num_rows($result);
      $don = "0";
      while($userRow = mysqli_fetch_assoc($result)){
        $noOfDays = $userRow['noOfDaysLate'];
        $isLate = $userRow['isLate'];
      
    
    }
    //new monthly code
    
    $selectUserTask = "SELECT * FROM `usertask` WHERE usertaskID = '$taskID' LIMIT 1";
    $result = mysqli_query($con, $selectUserTask);
    
    while($userRow = mysqli_fetch_assoc($result)){
      $dateStarted = $userRow['dateStarted'];
      $dateAdded = $userRow['dateAdded'];
      $targetDate = $userRow['targetDate'];


    }
    
    $date = new DateTime($dateStarted);
    $dateYear = new DateTime($dateStarted);
    $dateYear->modify('next year');
$nextYearSample =  $dateYear->format('Y');

// $date = new DateTime($nextYearSample.'-04-01');
$date = new DateTime($dateAdded);

$nextYearApril =  $date->format('Y-m-d');

$dateYear->modify('next year');
$nextYearSample =  $dateYear->format('Y');

$date = new DateTime($targetDate);
// $date = new DateTime($nextYearSample.'-03-31');
$nextYearMarch=  $date->format('Y-m-d');
    
$yearOfThisMonth = new DateTime(date('Y-m-d'));
$Year_Now = $yearOfThisMonth->format('Y');

// $nextYear = $date->modify('next year');
// $nextYearHehe =  $nextYear->format('Y');
// echo $nextYearHehe;

$dateToday = date('Y-m-d'); //ibalik sa Y-m-d
$dateToday=date('Y-m-d', strtotime($dateToday));
//echo $paymentDate; // echos today! 
$april = date('Y-m-d', strtotime($nextYearApril));
$march = date('Y-m-d', strtotime($nextYearMarch));
$april2 = date('Y-m-d', strtotime($dateAdded));
$march2 = date('Y-m-d', strtotime($targetDate));
if(($dateToday >= $april2) && ($dateToday <= $march2)){
  $finalDiff = "0";

}
// if (($dateToday >= $april) && ($dateToday <= $march)){
//   // echo "is between";
//   $finalDiff = "0";

// }
else{
  // $date->modify('next year');
  $year =  $date->format('Y');

// echo $year;
// echo "<br>";
// $date = new DateTime($year.'-04-01');

$date = new DateTime($targetDate);

$nextYearApril =  $date->format('Y-m-d');

$end = new DateTime(date('Y-m-d'));


$start = new DateTime($nextYearApril);

$start->modify('+1 day');

$end->modify('+1 day');

$interval = $end->diff($start);

// total days
$finalDiff = $interval->days;

    $period = new DatePeriod($start, new DateInterval('P1D'), $end);
    foreach($period as $dt) {
        $curr = $dt->format('D');
    // echo $curr;
   

        if ($curr == 'Sat' || $curr == 'Sun') {
          $finalDiff--;
        }
    
        if (in_array($dt->format('Y-m-d'), $holidays)) {
          $finalDiff--;
        }
    }
// echo $finalDiff;
}
      // echo $finalDiff;
  
    if($finalDiff >= 1){
      

      $_SESSION['noOfDaysLate']=$finalDiff;
      $_SESSION['TaskID'] = $_GET['FinishSample'];
      // echo $eememe;
      echo "<script> 
      // document.getElementById('daysLateDiv').style.display = 'none';
      console.log('$finalDiff');
      $('#reasonModal').modal('show');
      
document.getElementById('daysLate').value='$finalDiff';
</script>";
    }
    else if($finalDiff <= 0){
   

$_SESSION['noOfDaysLate']='0';
   $_SESSION['TaskID'] = $_GET['FinishSample'];
   $taskID = $_SESSION['TaskID'];

   echo "<script>  


  $('#actionModal').modal('show');


     //document.getElementById('finished$taskID').click();   DITO AKO NATAPOS   
             </script>";

    }
    
  
     
}
    }
    

    
                                                   
    if(isset($_POST['reason'])){

         
//upload code **************************************
if (isset($_FILES['uploadedFile2']) && $_FILES['uploadedFile2']['error'] === UPLOAD_ERR_OK){
  // get details of the uploaded file
  
  $fileTmpPath = $_FILES['uploadedFile2']['tmp_name'];
  $fileName = $_FILES['uploadedFile2']['name'];
  $fileSize = $_FILES['uploadedFile2']['size'];
  $fileType = $_FILES['uploadedFile2']['type'];
  $fileNameCmps = explode(".", $fileName);
  $fileExtension = strtolower(end($fileNameCmps));

  // sanitize file-name

$newFileName = md5(time() . $fileName) . '.' . $fileExtension;
  echo("<script>console.log('FILE NAME: " .$GLOBALS["newFileName"]. "');</script>");
 
  // check if file has one of the following extensions
  $allowedfileExtensions = array('jpg', 'gif', 'png', 'zip', 'txt', 'xls', 'doc', 'pdf','xlsx', 'csv', 'docx');

  if (in_array($fileExtension, $allowedfileExtensions))
  {
    // directory in which the uploaded file will be moved
    $uploadFileDir = './uploaded_files/';
    $dest_path = $uploadFileDir . $newFileName;
    echo("<script>console.log('FILE LOCATION: " .$dest_path . "');</script>");
   
    $_SESSION['newFileLoc'] = $dest_path;
    
    if(move_uploaded_file($fileTmpPath, $dest_path)) 
    {
      $varAlert = "success";
      // $PassContainer = $IDCONTAINER;
      $message ='File is successfully uploaded.';
      $_SESSION['newFileLoc'] = $dest_path;
    }
    else
    {
      $message = 'There was some error moving the file to upload directory. Please make sure the upload directory is writable by web server.';
    }
  }
  else
  {
    $message = 'Upload failed. Allowed file types: ' . implode(',', $allowedfileExtensions);
  }
}
else
{
  $message = 'There is some error in the file upload. Please check the following error.<br>';
  $message .= 'Error:' . $_FILES['uploadedFile2']['error'];
}
//end of upload code **************************************




      $_SESSION['reason'] = $_POST['reasonInput'];
      $_SESSION['action'] = $_POST['ActionInputwithLate'];

      
      if($_SESSION['reason'] != "" || $_SESSION['action']!=""){
        $taskID = $_SESSION['TaskID'];
        echo $taskID;
          echo "<script> // document.getElementById('finishedsample$taskID').style.display='none';
          document.getElementById('finished$taskID').click();      

          </script>";
      }
      else{
        ?><script>
      Swal.fire({
    icon: 'error',
    title: 'Ooppss!',
    text: 'You have to complete the form',
  //   footer: '<a href="">Why do I have this issue?</a>'
  })
   </script><?php 
      }
    }

    if(isset($_POST['action'])){


      
//upload code **************************************
if (isset($_FILES['uploadedFile']) && $_FILES['uploadedFile']['error'] === UPLOAD_ERR_OK){
  // get details of the uploaded file
  
  $fileTmpPath = $_FILES['uploadedFile']['tmp_name'];
  $fileName = $_FILES['uploadedFile']['name'];
  $fileSize = $_FILES['uploadedFile']['size'];
  $fileType = $_FILES['uploadedFile']['type'];
  $fileNameCmps = explode(".", $fileName);
  $fileExtension = strtolower(end($fileNameCmps));

  // sanitize file-name

$newFileName = md5(time() . $fileName) . '.' . $fileExtension;
  echo("<script>console.log('FILE NAME: " .$GLOBALS["newFileName"]. "');</script>");
 
  // check if file has one of the following extensions
  $allowedfileExtensions = array('jpg', 'gif', 'png', 'zip', 'txt', 'xls', 'doc', 'pdf','xlsx', 'csv', 'docx');

  if (in_array($fileExtension, $allowedfileExtensions))
  {
    // directory in which the uploaded file will be moved
    $uploadFileDir = './uploaded_files/';
    $dest_path = $uploadFileDir . $newFileName;
    echo("<script>console.log('FILE LOCATION: " .$dest_path . "');</script>");
   
    $_SESSION['newFileLoc'] = $dest_path;
    
    if(move_uploaded_file($fileTmpPath, $dest_path)) 
    {
      $varAlert = "success";
      // $PassContainer = $IDCONTAINER;
      $message ='File is successfully uploaded.';
      $_SESSION['newFileLoc'] = $dest_path;
    }
    else
    {
      $message = 'There was some error moving the file to upload directory. Please make sure the upload directory is writable by web server.';
    }
  }
  else
  {
    $message = 'Upload failed. Allowed file types: ' . implode(',', $allowedfileExtensions);
  }
}
else
{
  $message = 'There is some error in the file upload. Please check the following error.<br>';
  $message .= 'Error:' . $_FILES['uploadedFile']['error'];
}
//end of upload code **************************************





      $_SESSION['action'] = addslashes($_POST['actionInput']);
      if($_SESSION['action'] != ""){
        $taskID = $_SESSION['TaskID'];
        echo $taskID;
          echo "<script> // document.getElementById('finishedsample$taskID').style.display='none';
          document.getElementById('uploadsample').click();      
          document.getElementById('finished$taskID').click();   


          </script>";
      }
      else{
        ?><script>
      Swal.fire({
    icon: 'error',
    title: 'Ooppss!',
    text: 'You have to complete the form',
  //   footer: '<a href="">Why do I have this issue?</a>'
  })
   </script><?php 
      }
    }

    if(isset($_POST['testingaction'])){
             
//upload code **************************************
if (isset($_FILES['uploadedFile']) && $_FILES['uploadedFile']['error'] === UPLOAD_ERR_OK){
  // get details of the uploaded file
  
  $fileTmpPath = $_FILES['uploadedFile']['tmp_name'];
  $fileName = $_FILES['uploadedFile']['name'];
  $fileSize = $_FILES['uploadedFile']['size'];
  $fileType = $_FILES['uploadedFile']['type'];
  $fileNameCmps = explode(".", $fileName);
  $fileExtension = strtolower(end($fileNameCmps));

  // sanitize file-name

$newFileName = md5(time() . $fileName) . '.' . $fileExtension;
  echo("<script>console.log('FILE NAME: " .$GLOBALS["newFileName"]. "');</script>");
 
  // check if file has one of the following extensions
  $allowedfileExtensions = array('jpg', 'gif', 'png', 'zip', 'txt', 'xls', 'doc', 'pdf','xlsx', 'csv', 'docx');

  if (in_array($fileExtension, $allowedfileExtensions))
  {
    // directory in which the uploaded file will be moved
    $uploadFileDir = './uploaded_files/';
    $dest_path = $uploadFileDir . $newFileName;
    echo("<script>console.log('FILE LOCATION: " .$dest_path . "');</script>");
   
    $_SESSION['newFileLoc'] = $dest_path;
    
    if(move_uploaded_file($fileTmpPath, $dest_path)) 
    {
      $varAlert = "success";
      // $PassContainer = $IDCONTAINER;
      $message ='File is successfully uploaded.';
      $_SESSION['newFileLoc'] = $dest_path;
    }
    else
    {
      $message = 'There was some error moving the file to upload directory. Please make sure the upload directory is writable by web server.';
    }
  }
  else
  {
    $message = 'Upload failed. Allowed file types: ' . implode(',', $allowedfileExtensions);
  }
}
else
{
  $message = 'There is some error in the file upload. Please check the following error.<br>';
  $message .= 'Error:' . $_FILES['uploadedFile']['error'];
}
//end of upload code **************************************


    }
    if(isset($_POST['reasonUpdate'])){
      $_SESSION['reason'] = $_POST['reasonInputUpdate'];
      $_SESSION['action'] = $_POST['actionInputUpdateLate'];
      $finishedTaskId = $_POST['ForFinishedTaskName'];
      if($_SESSION['reason'] != "" || $_SESSION['action'] != ""){
        $taskID = $finishedTaskId;
        // echo $_SESSION['reason'];
        // echo $taskID;

          echo "<script>  //document.getElementById('update$taskID').style.display='none';
          document.getElementById('updates$taskID').click();      

          </script>";
      }
      else{
        ?><script>
      Swal.fire({
    icon: 'error',
    title: 'Ooppss!',
    text: 'You have to complete the form',
  //   footer: '<a href="">Why do I have this issue?</a>'
  })
   </script><?php 
      }
    }
    
    if(isset($_POST['actionUpdate'])){
      $_SESSION['action'] = $_POST['actionInputUpdate'];
      $finishedTaskId = $_POST['ForFinishedTaskNameForActionOnly'];
      
      if($_SESSION['action'] != ""){
        $taskID = $finishedTaskId;
        echo $_SESSION['reason'];
        echo $taskID;
        echo "<script> console.log('$taskID') </script>";
          echo "<script>  //document.getElementById('updateAction$taskID').style.display='none';
          document.getElementById('updatesAction$taskID').click();      

          </script>";
      }
      else{
        ?><script>
      Swal.fire({
    icon: 'error',
    title: 'Ooppss!',
    text: 'You have to complete the form',
  //   footer: '<a href="">Why do I have this issue?</a>'
  })
   </script><?php 
      }
    }


    ?>

                              
                            </tbody>
                        </table>
                      </div>
                    </div>

                    <!-- <form method="POST" action="index.php" enctype="multipart/form-data">
    <div class="upload-wrapper">
      <span class="file-name">Choose a file...</span>
      <label for="file-upload">Browse<input type="file" id="file-upload" name="uploadedFile"></label>
    </div>
 
    <input type="submit" id = "uploadsample" name="uploadBtn" value="Upload" />
    
  </form> -->
                </div>
            </div>
        </div>
      </div>
    

      </div>
          </div> 
      
          <!-- <h1> </h1> -->
        
</div>
  
<script>
//Enter Event
//     var input = document.getElementById("reasonUpdate1");
//     var input2 = document.getElementById("actionUpdate1");

//     input.addEventListener("keypress", function(event) {
//   if (event.key === "Enter") {
//     event.preventDefault();
//     document.getElementById("reasonAndActionUpdateOnly").click();
//   }
// });
// input2.addEventListener("keypress", function(event) {
//   if (event.key === "Enter") {
//     event.preventDefault();
//     document.getElementById("reasonAndActionUpdateOnly").click();
//   }
// });

// var actionInput = document.getElementById("actionText");

// actionInput.addEventListener("keypress", function(event) {
//   if (event.key === "Enter") {
//     event.preventDefault();
//     document.getElementById("submitAction").click();
//   }
// });

// var reason1 = document.getElementById("getReason");
//     var action1 = document.getElementById("getAction");

//     reason1.addEventListener("keypress", function(event) {
//   if (event.key === "Enter") {
//     event.preventDefault();
//     document.getElementById("submitReasonAndAction").click();
//   }
// });
// action1.addEventListener("keypress", function(event) {
//   if (event.key === "Enter") {
//     event.preventDefault();
//     document.getElementById("submitReasonAndAction").click();
//   }
// });


// var actionUpdate = document.getElementById("actionUpdateText");

// actionUpdate.addEventListener("keypress", function(event) {
//   if (event.key === "Enter") {
//     event.preventDefault();
//     document.getElementById("submitUpdateAction").click();
//   }
// });

//End of Enter event

$('#actionModalUpdate').on('show.bs.modal', function (event) {
  var button = $(event.relatedTarget) ;// Button that triggered the modal
  var action = button.data('action');
 var finishedTaskID = button.data('fid');

  
  // Extract info from data-* attributes
  // If necessary, you could initiate an AJAX request here (and then do the updating in a callback).
  // Update the modal's content. We'll use jQuery here, but you could use a data binding library or other methods instead.
  var modal = $(this);
  // modal.find('.modal-title').text('New message to ' + recipient)
  // modal.find('.modal-body reasonUpdate1').val(recipient)
  document.getElementById("actionUpdateText").value = action;
  document.getElementById("ForFinishedTaskIDActionOnly").value = finishedTaskID;


  
})

$('#reasonModalUpdate').on('show.bs.modal', function (event) {
  var button = $(event.relatedTarget) ;// Button that triggered the modal
  var action = button.data('action');
  var reason = button.data('reason');
 var finishedTaskID = button.data('fid');
  

 

  
  // Extract info from data-* attributes
  // If necessary, you could initiate an AJAX request here (and then do the updating in a callback).
  // Update the modal's content. We'll use jQuery here, but you could use a data binding library or other methods instead.
  var modal = $(this);
  // modal.find('.modal-title').text('New message to ' + recipient)
  // modal.find('.modal-body reasonUpdate1').val(recipient)
  document.getElementById("actionUpdate1").value = action;
  document.getElementById("reasonUpdate1").value = reason;
  document.getElementById("ForFinishedTaskID").value = finishedTaskID;


})


var jsonData = <?php echo json_encode("$varAlert"); ?>;
console.log(jsonData);
// var jsonDataID = <?php// echo json_encode("$PassContainer"); ?>;

// if(jsonData == "success"){
//   // document.getElementById("successAlertWord").value=jsonDataID;
// successAlertWord.innerText = "Attachment for "+jsonDataID+" uploaded succesfully.";


//   document.getElementById("successAlert").style.display="block";
//   // var emerut = document.getElementById("successAlert").value;



// }

getSelectValueDaily();
function getSelectValueDaily() {
    let input = document.getElementById('filterbox').value
    input=input.toLowerCase();
    let x = document.getElementsByClassName('tableMain');
      
    for (i = 0; i < x.length; i++) { 
        if (!x[i].innerHTML.toLowerCase().includes(input)) {
            x[i].style.display="none";
        }
        else {
            x[i].style.display="table-row";                 
        }
    }
}




 function done(){
  var checkBox = document.getElementById("checkDone");
  if (checkBox.checked == true){
  let filterValue="DONE";
            var table = document.getElementById('TaskTable');
            let tr = table.querySelectorAll('tr');
            
            for(let index=0; index < tr.length;index++){
                let val = tr[index].getElementsByTagName('td')[4];
                if(val.innerHTML.indexOf(filterValue)> -1){
                    tr[index].style.display='';
        
                }
                else{
                    tr[index].style.display='none';
                }
            }
          }
          else{
            let filterValue="";
            var table = document.getElementById('TaskTable');
            let tr = table.querySelectorAll('tr');
            
            for(let index=0; index < tr.length;index++){
                let val = tr[index].getElementsByTagName('td')[4];
                if(val.innerHTML.indexOf(filterValue)> -1){
                    tr[index].style.display='';
        
                }
                else{
                    tr[index].style.display='none';
                }
            }

          }
 }

// document.getElementById("successAlert").style.display="block";

//  function getSelectValue()
// {
//     var e = document.getElementById("inputGroupSelect01");
  
//     var text=e.options[e.selectedIndex].text;//get the selected option text
//     if(text=='Task Name'){

//         let filterInput = document.getElementById('filterbox');
//         filterInput.addEventListener('keyup',function(){
//             let filterValue=document.getElementById('filterbox').value;
//             var table = document.getElementById('TaskTable');
//             let tr = table.querySelectorAll('tr');
            
//             for(let index=0; index < tr.length;index++){
//                 let val = tr[index].getElementsByTagName('td')[1];
//                 if(val.innerHTML.indexOf(filterValue)> -1){
//                     tr[index].style.display='';
        
//                 }
//                 else{
//                     tr[index].style.display='none';
//                 }
//             }
            
//         }
        
//         );
        
//     }
    
//     else if (text=='Type'){

//         let filterInput = document.getElementById('filterbox');
//         filterInput.addEventListener('keyup',function(){
//             let filterValue=document.getElementById('filterbox').value;
//             var table = document.getElementById('TaskTable');
//             let tr = table.querySelectorAll('tr');
            
//             for(let index=0; index < tr.length;index++){
//                 let val = tr[index].getElementsByTagName('td')[2];
//                 if(val.innerHTML.indexOf(filterValue)> -1){
//                     tr[index].style.display='';
        
//                 }
//                 else{
//                     tr[index].style.display='none';
//                 }
//             }
            
//         }
        
//         );
//     }
//     else if (text=='Category'){

// let filterInput = document.getElementById('filterbox');
// filterInput.addEventListener('keyup',function(){
//     let filterValue=document.getElementById('filterbox').value;
//     var table = document.getElementById('TaskTable');
//     let tr = table.querySelectorAll('tr');
    
//     for(let index=0; index < tr.length;index++){
//         let val = tr[index].getElementsByTagName('td')[3];
//         if(val.innerHTML.indexOf(filterValue)> -1){
//             tr[index].style.display='';

//         }
//         else{
//             tr[index].style.display='none';
//         }
//     }
    
// }

// );
// }
//     else if (text=='Status'){

// let filterInput = document.getElementById('filterbox');
// filterInput.addEventListener('keyup',function(){
//     let filterValue=document.getElementById('filterbox').value;
//     var table = document.getElementById('TaskTable');
//     let tr = table.querySelectorAll('tr');
    
//     for(let index=0; index < tr.length;index++){
//         let val = tr[index].getElementsByTagName('td')[4];
//         if(val.innerHTML.indexOf(filterValue)> -1){
//             tr[index].style.display='';

//         }
//         else{
//             tr[index].style.display='none';
//         }
//     }
    
// }

// );
// }
// }
// getSelectValue();


var dateNow = <?php echo json_encode("$today"); ?>;

// document.getElementById("datepicker").value = dateNow;

var jsonDataTask = <?php echo json_encode("$taskfocus"); ?>;
var dates = <?php echo json_encode("$dateToPass"); ?>;

if(jsonDataTask == "true"){
      document.getElementById("datepicker").value = dates;

    }
var sessionReason = <?php echo json_encode("$reasonSession");?>;

function checkIfLate(id){

    var date1= new Date();
    // var date2= new Date('July 1, 2022');
   
var dateSession = <?php echo json_encode("$todaySession"); ?>;
console.log(sessionReason);
    var date2= new Date(dateSession);

    var daysbetween= Math.abs(date2-date1);
    var noOfdays = daysbetween/(1000 * 3600 * 24)
    console.log(parseInt(noOfdays));
    console.log(date2);

    console.log(date1);
var noOfDaysLate = parseInt(noOfdays);
var reason = document.getElementById('reason-text').value;
    if(noOfDaysLate >= 3){
      $('#reasonModal').modal('show');
// document.getElementById('checked'+id).style.display='none';

    }
    }
    // hideCheck();
  function hideCheck(){
var reason = document.getElementById('reason-text').value;

    if(sessionReason !=""){
      document.getElementById('checked34').style.display='none';

    }


  }

function clickUpload(){
  document.getElementById('uploadsample').click();
}

        </script>
    </body>
</html>