일주일마다 다른 값 저장방법 채택완료

</p>

<p> </p>

<p>  $result71 = mysqli_query($conn, "SELECT in1, in2, in3, in4  FROM very_work_list2 WHERE work_id='$zzzz'");

$row = mysqli_fetch_array($result71);

$data71 = $row[0];

$data72 = $row[1];

$data73 = $row[2];    

$data74 = $row[3];    </p>

<p> </p>

<p> $today1 = date('w');

    $nextMonday = strtotime('next monday');

        

function is_holiday($today1) {

    $holiday_codes = array(

        '공공포털 코드' => '공공포털 코드'

    );</p>

<p>    $day_of_week = date('w', strtotime($today1)); 

    $date_str = date('Ymd', strtotime($today1));</p>

<p>    if (in_array($date_str, array_keys($holiday_codes))) {

        return true;

    } elseif ($day_of_week == 0 || $day_of_week == 6) { 

        return true;

    } else {

        return false;

    }

}

        </p>

<p>    if ($today1 >= 1 && $today1 <= 5) {  //월~금</p>

<p>

     $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total, dddd)

                   SELECT '$data61', work_name, work_group, ('$today $data71') , '', '$time', '$ip', '$zzzz', '0' 

                   FROM very_work_list2

                   WHERE work_id = '$zzzz'";

   

   } elseif ($today1 == 6 || $today1 == 0 || is_holiday($today1)) { // 토 ~ 일, 공휴일

        $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total, dddd)

                   SELECT '$data61', work_name, work_group, ('$today $data74') , '', '$time', '$ip', '$zzzz', '0' 

                   FROM very_work_list2

                   WHERE work_id = '$zzzz'";



    }</p>

<p>    if (time() >= $nextMonday && time() < $nextFriday) { // 다음주 월 ~ 금

      $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total, dddd)

                   SELECT '$data61', work_name, work_group, ('$today $data72') , '', '$time', '$ip', '$zzzz', '0' 

                   FROM very_work_list2

                   WHERE work_id = '$zzzz'";

  

    } elseif (time() >= $nextMonday) { // 다음주 토 ~ 일, 공휴일

        $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total, dddd)

                   SELECT '$data61', work_name, work_group, ('$today $data74') , '', '$time', '$ip', '$zzzz', '0' 

                   FROM work_id = '$zzzz'";



    }

      if (time() >= $nextMonday && time() < $nextFriday) { // 다음주 월 ~ 금

      $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total, dddd)

                   SELECT '$data61', work_name, work_group, ('$today $data73') , '', '$time', '$ip', '$zzzz', '0' 

                   FROM very_work_list2

                   WHERE work_id = '$zzzz'";

    

    } elseif (time() >= $nextMonday) { // 다음주 토 ~ 일, 공휴일

        $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total, dddd)

                   SELECT '$data61', work_name, work_group, ('$today $data74') , '', '$time', '$ip', '$zzzz', '0' 

                   FROM very_work_list2

                   WHERE work_id = '$zzzz'";

  

    }    </p>

<p> </p>

<p>