Booking/Availability Calendar Help

[Andy2024]

I'm Trying to create a booking/availability calendar that shows a full 12 months bookings/availability.

I have come up with the following so far

 

        $publicHolidays = array(date('j-n-Y', strtotime('1st January 2025')),
                                date('j-n-Y', strtotime('18th April 2025')),
                                date('j-n-Y', strtotime('21st April 2025')),
                                date('j-n-Y', strtotime('5th May 2025')),
                                date('j-n-Y', strtotime('26th May 2025')),
                                date('j-n-Y', strtotime('25th August 2025')),
                                date('j-n-Y', strtotime('25th December 2025')),
                                date('j-n-Y', strtotime('26th December 2025')));
          
        $bookings = array(array('Check-In'    => '1-1-2025',
                                'Check-Out'   => '7-1-2025'),
                          array('Check-In'    => '3-2-2025',
                                'Check-Out'   => '13-2-2025'),
                          array('Check-In'    => '2-3-2025',
                                'Check-Out'   => '25-3-2025'),
                          array('Check-In'    => '2-4-2025',
                                'Check-Out'   => '21-4-2025'),
                          array('Check-In'    => '6-6-2025',
                                'Check-Out'   => '9-6-2025'),
                          array('Check-In'    => '2-9-2025',
                                'Check-Out'   => '5-9-2025'),
                          array('Check-In'    => '3-11-2025',
                                'Check-Out'   => '30-11-2025'));
        foreach($bookings as $row) {
          $res[] = Cal::bookedArray($row['Check-In'],$row['Check-Out']);
        }
        
        $booked = Cal::bookedArray('1-4-2025','7-4-2025');
          
        $month = '1';
        $year = date('Y');
        for($m=$month;$m<13;$m++) {
        $timestamp = mktime(0, 0, 0, $m, 1, $year);
        $daysInMonth = date("t", $timestamp);
        $firstDay = date("N", $timestamp);
        
        if($m == date('m')) { $featured =' featured'; } else { $featured=''; }
        
        ?>
        <div class="col-xl-4 col-lg-6" data-aos="fade-up" data-aos-delay="100">
            <div class="pricing-item p-0<?php echo $featured;?>">
              <h3 class="mb-0 pt-5"><?php echo date('F', mktime(0,0,0,$m)); ?></h3>
              <table class="table table-bordered m-0">
                <tr>
                  <th>Mon</th>
                  <th>Tue</th>
                  <th>Wed</th>
                  <th>Thu</th>
                  <th>Fri</th>
                  <th>Sat</th>
                  <th>Sun</th>
                </tr>
                <?php
                $dayCount = 1;
                ?>
                <tr>
                <?php

                for ($i = 1; $i <= 7; $i++) {
                    
                    $date = "$dayCount-$m-$year";
                    if ($i < $firstDay) {
                        echo "<td></td>";
                    } else {
                        $date = "$dayCount-$m-$year";
                        if(date('l', strtotime($date)) == 'Saturday' && !in_array($date, $booked)) { 
                          $cellBg="class='table-info'"; 
                        } 
                        elseif(date('l', strtotime($date)) == 'Sunday' && !in_array($date, $booked)) {
                          $cellBg="class='table-info'"; 
                        }
                        elseif(in_array($date, $publicHolidays) && !in_array($date, $booked)) {
                          $cellBg="class='table-warning'"; 
                        } 
                        else {
                          $cellBg="class='table-light'"; 
                        }
                      
                        foreach($res as $key => $val) {
                          /*
                          $firstday = reset($val);
                          $lastday = end($val);
                          if($date = $firstday) {
                            $cellBg="class='table-primary'";
                          }
                          
                          elseif(in_array($date, array_splice($val,1,-1))) {
                            $cellBg="class='table-danger'"; 
                          }
                          
                          elseif($date = $lastday) {
                            $cellBg="class='table-primary'";
                          }
                          */
                          
                          if(in_array($date, array_splice($val,1,-1))) {
                            $cellBg="class='table-danger'"; 
                          }
                        }
                      
                        echo "<td $cellBg>$dayCount</td>";
                        $dayCount++;
                    }
                }
                echo "</tr>";
          
                while ($dayCount <= $daysInMonth) {
                    echo "<tr>";
                    for ($i = 1; $i <= 7 && $dayCount <= $daysInMonth; $i++) {
                        $date = "$dayCount-$m-$year";
                        if(date('l', strtotime($date)) == 'Saturday' && !in_array($date, $booked)) { 
                          $cellBg="class='table-info'"; 
                        }
                        elseif(date('l', strtotime($date)) == 'Sunday' && !in_array($date, $booked)) {
                          $cellBg="class='table-info'"; 
                        } 
                        elseif(in_array($date, $publicHolidays) && !in_array($date, $booked)) {
                          $cellBg="class='table-warning'"; 
                        } 
                        else {
                          $cellBg="class='table-light'"; 
                        }
                      
                        foreach($res as $key => $val) {
                          /*
                          $firstday = reset($val);
                          $lastday = end($val);
                          if($date = $firstday) {
                            $cellBg="class='table-primary'";
                          }
                          
                          elseif(in_array($date, array_splice($val,1,-1))) {
                            $cellBg="class='table-danger'"; 
                          }
                          
                          elseif($date = $lastday) {
                            $cellBg="class='table-primary'";
                          }
                          */
                          
                          if(in_array($date, array_splice($val,1,-1))) {
                            $cellBg="class='table-danger'"; 
                          }
                          
                        }
                      
                        echo "<td $cellBg>$dayCount</td>";
                        $dayCount++;
                    }
                ?>
                </tr>
                <?php
                }
                ?>
              </table>
          </div>
        </div>
        <?php
        }
        

Its reading the arrays, drawing the calendar and colorizing the weekends, public holidays and bookings. What i need is to change the check-in and check-out date color to reflect what they are. I've commented out what ive been trying but it isnt working.

 

here is the bookedarray function if anyone needs it

    public static function bookedArray($strDateFrom,$strDateTo)
    {

      $aryRange = [];

      $iDateFrom = strtotime($strDateFrom);
      $iDateTo = strtotime($strDateTo);

      if ($iDateTo >= $iDateFrom) {
          array_push($aryRange, date('j-n-Y', $iDateFrom)); // first entry
          while ($iDateFrom<$iDateTo) {
              $iDateFrom += 86400; // add 24 hours
              array_push($aryRange, date('j-n-Y', $iDateFrom));
          }
      }
      return $aryRange;

    }

Any help would be much appreciated or even a pointer as to were I could find a solution

 

Thanks in advance