<?php
include("../../../../wp-config.php");
global $wpdb;
$PSY_SLOT_AVAILABLE = $wpdb->prefix . PSY_SLOT_AVAILABLE;

$booked_date = $_REQUEST['book_date'];
$counselor = $_REQUEST['counselor'];
$type = $_REQUEST['type'];

/**if appointment by counselor */
if ($type == 'counselor') {


    $getSlots = $wpdb->get_results("SELECT id, time_dur, time_slot_hr, time_slot_min, pricing_for_slot FROM $PSY_SLOT_AVAILABLE where scheduled_date='$booked_date' and counselor_id='$counselor'");
?>

    <div class="data-show-box">

        <div class="section-description-content">
            <h2 style="font-size: 20px;"> Available Booking Slots on <?php echo date('d F, Y', strtotime($booked_date)) ?></h2>
        </div>
        <!-- 
    <ul class="important-link-ul">
        <?php foreach ($getSlots as $s) { ?>
            <li> <i class="fa fa-clock"></i> Time Duration : <?php echo $s->time_dur; ?> min. | <i class="fas fa-stopwatch"></i> Starting From : <?php echo $s->time_slot_hr . ':' . $s->time_slot_min ?> | Amount : ₹ <?php echo $s->pricing_for_slot; ?> |
                <form action="<?php echo ROOT_LINK . 'checkout' ?>" method="post">
                    <input type="hidden" name="ref_id" value="<?php echo $s->id; ?>">
                    <input type="hidden" name="txn_type" value="C">
                    <button type="submit" class="btn btn-primary">Book Now</button>
                </form>
            </li>
        <?php } ?>
    </ul> -->

        <div class="row m-0">
            <?php foreach ($getSlots as $s) {
                $min = $s->time_slot_min == 0 ? '00' : $s->time_slot_min;
            ?>
                <div class="col-md-4">
                    <div class="important-link-box">
                        <h2><i class="fa fa-clock"></i> Time Duration : <?php echo $s->time_dur; ?> min</h2>
                        <h4><i class="fas fa-stopwatch"></i> Starting From : <?php echo $s->time_slot_hr . ':' . $min ?></h4>

                        <p>Amount : ₹ <?php echo $s->pricing_for_slot; ?></p>

                        <form action="<?php echo ROOT_LINK . 'checkout' ?>" method="post">
                            <input type="hidden" name="ref_id" value="<?php echo $s->id; ?>">
                            <input type="hidden" name="txn_type" value="C">
                            <button type="submit" class="book-now-btn">Book Now</button>
                        </form>
                    </div>
                </div>
            <?php } ?>
        </div>

    </div>
<?php
} else if ($type == 'user') {
?>
    <div class="data-show-box">

        <div class="section-description-content">
            <h2 style="font-size: 20px;"> Book Slot on <?php echo date('d F, Y', strtotime($booked_date)) ?></h2>
        </div>
        <div class="row m-0">
            <div class="col-md-8">
                <div class="important-link-box">
                    <form method="post">
                        <input type="hidden" name="c_id" id="c_id" value="<?php echo $counselor; ?>">
                        <input type="hidden" name="s_booked_on" id="s_booked_on" value="<?php echo $booked_date; ?>">
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-4">
                                    <label for="timeAllow">Slot Time Duration :</label>
                                </div>
                                <div class="col-md-4">
                                    30 min <i class="fa fa-clock"></i>
                                    <input type="hidden" class="form-control" id="timeAllow" name="timeAllow" value="30">
                                </div>
                                <div class="col-md-4">
                                </div>
                            </div>
                        </div>
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-4">
                                    <label for="timeAllow">Amount :</label>
                                </div>
                                <div class="col-md-4">
                                    ₹ 500
                                </div>
                                <div class="col-md-4">
                                </div>
                            </div>
                        </div>
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-4">
                                    <label for="time_slot_hr">Start From</label>
                                </div>
                                <div class="col-md-4">
                                    <select class="form-control" id="time_slot_hr" name="time_slot_hr">
                                        <option value="0">Hour</option>
                                        <?php for ($h = 9; $h <= 18; $h++) {
                                            $ampm = $h > '11' ? 'pm' : 'am';
                                            $timeDigit = $h . ':00:00';
                                            $showTime = date('h a', strtotime($timeDigit));
                                        ?>
                                            <option value="<?php echo sprintf('%02d', $h); ?>"><?php echo $showTime; ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                                <div class="col-md-4">
                                    <select class="form-control" id="time_slot_min" name="time_slot_min">
                                        <option value="0">Min</option>
                                        <?php for ($m = 0; $m <= 59; $m++) { ?>
                                            <option value="<?php echo sprintf('%02d', $m); ?>"><?php echo sprintf('%02d', $m) . ' min'; ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                            </div>
                        </div>
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-4" id="ic" style="display:none;">
                                    <label for="end_time_dur"> Slot End On</label>
                                </div>
                                <div class="col-md-4" id="end_time" style="display:none;">
                                    End Slot Hour
                                </div>
                                <div class="col-md-4"></div>
                            </div>
                        </div>
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-4">
                                    <input type="button" id="book_slot" name="slot_book" Value="Book Slot" class="btn btn-primary">
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
<?php
}