<?php
require_once 'header.php';
require_once 'navbar.php';

if (!isset($_GET['type'])) {
    header("location:404");
}
if (isset($_POST['pass_bid'])) {
    $pass_bid = $_POST['pass_bid'];
    if ($pass_bid == 'none') {
        $sql = "UPDATE bookings SET bid_by='vendor',admin_bid_price='' WHERE id='" . $_GET['booking_id'] . "'";

    } else {
        $sql = "UPDATE bookings SET bid_by='admin',admin_bid_price='$pass_bid' WHERE id='" . $_GET['booking_id'] . "'";
    }

    $results = $conn->query($sql);
}


$type = test_input($_GET['type']);

if (isset($_GET['booking_id'])) {
    $sql = "SELECT * FROM bookings WHERE id='" . $_GET['booking_id'] . "'";
    $results = $conn->query($sql);
    if ($results->num_rows > 0) {
        while ($row_d = $results->fetch_assoc()) {
            //$table_data[]=$row;
            //print_r($row);
            $isbidded = $row_d['bid_by'];
            $bid_with = $row_d['admin_bid_price'];

        }
    }
    $sql = "SELECT * FROM bidding INNER JOIN vendor_profile ON bidding.vendor_id=vendor_profile.vendor_id  WHERE booking_id='" . $_GET['booking_id'] . "'";
} elseif ($_GET['type'] == 'vendor bid') {
    $sql = "SELECT * FROM  bookings WHERE status='vendor_pass' and bid_by='vendor' ORDER BY `id` DESC";
} elseif ($_GET['type'] == 'all bid') {
    //$sql="SELECT * FROM bidding INNER JOIN bookings ON bookings.id=bidding.booking_id WHERE Bookings.status='vendor_pass' Group BY bidding.booking_id";
    $sql = "SELECT * FROM  bookings WHERE status='vendor_pass' and bid_by='admin' ORDER BY `id` DESC";
}
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while ($row = $result->fetch_assoc()) {
        $table_data[] = $row;
        //print_r($row);
    }
}
//print_r($table_data);

$sql = "select alternate_contact as contact,full_name,vendor_id,company_name from vendor_profile where vendor_id not in(select vendor_id from vendor_profile where LTRIM(RTRIM(alternate_contact)) = '') order by contact";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while ($row = $result->fetch_assoc()) {
        $vendors[] = $row;
    }
}

?>
<style type="text/css">
    .actmk {
        display: block !important;
    }
</style>
<!-- Page content -->
<div class="container-fluid pt-8">
    <div class="page-header mt-0  p-3">
        <h3 class="mb-sm-0"><?= ucwords($type); ?> Bookings</h3>
        <ol class="breadcrumb mb-0">
            <li class="breadcrumb-item"><a href="#"><i class="fe fe-home"></i></a></li>
            <li class="breadcrumb-item active" aria-current="page"><?= ucwords($type); ?> Bookings</li>
        </ol>
    </div>
    <?php
    if (isset($success)) {
        ?>
        <div class="alert alert-success" id="success">Success! Your Request has been submited.</div>
        <?php
    } else if (isset($error)) {
        ?>
            <div class="alert alert-danger" id="success">Error! Your Request could not be submited.</div>
        <?php
    }
    ?>
    <div class="alert " id="msg" style="display:none"></div>
    <div class="card shadow">

        <div class="card-body">
            <?php

            if (isset($_GET['booking_id'])) { ?>

                <div class="dtail">
                    <?php if ($isbidded == 'vendor') { ?>
                        <input type="checkbox" name="add_bid" class="add_bid"
                            onclick="check_bid(<?= $_GET['booking_id']; ?>)"><label>Pass With Bid</label>
                        <div class="row">
                            <div class="col-sm-3"><label>Your Bid :</label> <b>No Bid Yet</b></div>
                            <div class="col-sm-2"><input type="text" name="bid_amt" placeholder="Enter Bid Amount"
                                    class="form-control bid_amt" style="display: none"></div> <button
                                class="btn btn-primary upd" style="display: none">Update</button>
                        </div>


                    <?php } else { ?>

                        <input type="checkbox" checked name="add_bid" class="add_bid"
                            onclick="check_bid(<?= $_GET['booking_id']; ?>)"><label>Pass With Bid</label><br>
                        <div class="row">
                            <div class="col-sm-2"><label>Your Bid :</label></div>
                            <div class="col-sm-2"><input style="margin-left: -47px;" type="text" name="bid_amt"
                                    placeholder="Enter Bid Amount" class="form-control bid_amt" value="<?= $bid_with; ?>"></div>
                            <button class="btn btn-primary upd" style="display: none">Update</button>
                        </div>

                    <?php }
            }


            if (isset($table_data)) {
                ?>
                    <div class="table-responsive">
                        <table id="example3" class="table table-striped table-bordered text-nowrap">
                            <thead class="">
                                <tr>
                                    <?php if (isset($_GET['booking_id'])) { ?>
                                        <th class="wd-15p">S.No</th>
                                        <th class="wd-15p">BookingId</th>
                                        <th class="wd-15p">Vendor_Id </th>
                                        <th class="wd-15p">Vendor_Name </th>
                                        <th class="wd-15p">Bided Amount</th>



                                        <th class="wd-10vp actmk">action</th>
                                    <?php } else { ?>

                                        <th class="wd-15p">S.No</th>
                                        <th class="wd-15p">BookingId</th>
                                        <th class="wd-15p">From </th>
                                        <th class="wd-15p">To</th>
                                        <th class="wd-15p">Pickup_date</th>
                                        <th class="wd-20p">pickup_time</th>
                                        <th class="wd-20p">Cab Type</th>
                                        <th class="wd-20p">Drop Date</th>
                                        <?php if ($_GET['type'] == 'all bid') { ?>
                                            <th class="wd-15p">Your Bid</th>
                                        <?php } ?>

                                        <th class="wd-10vp actmk">action</th>

                                    <?php } ?>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $x = 1;
                                foreach ($table_data as $hh) {
                                    if (isset($_GET['booking_id'])) { ?>
                                        <tr id="row<?= $hh['booking_id']; ?>">
                                            <td><?= $x; ?></td>
                                            <td>MTS<?= $hh['booking_id']; ?></td>
                                            <td><?= $hh['vendor_id'] ?></td>
                                            <td><?= $hh['full_name'] ?></td>
                                            <td><?= $hh['bidding_price']; ?></td>


                                            <td class="actmk"> <button
                                                    onclick="assing_bid(<?= $hh['id']; ?>,<?= $hh['vendor_id']; ?>,<?= $hh['booking_id']; ?>);"
                                                    class="btn btn-icon btn-pill btn-primary mt-1 mb-1"
                                                    type="button">Assign</button></td>
                                        </tr>
                                    <?php } else { ?>

                                        <tr id="row<?= $hh['booking_id']; ?>">
                                            <td><?= $x; ?></td>
                                            <td>MTS<?= $hh['id']; ?></td>
                                            <td><?= $hh['booking_from'] ?></td>
                                            <td><?= $hh['booking_to']; ?></td>
                                            <td><?= $hh['pickup_date']; ?></td>
                                            <td><?= date("h:i A", strtotime($hh['pickup_time'])); ?></td>
                                            <td><?= $hh['cab_type']; ?></td>
                                            <td>
                                                <?php
                                                if ($hh['drop_date'] == 0) {
                                                    echo "<b>N.A.</b>";
                                                } else {
                                                    echo $hh['drop_date'];
                                                }
                                                ?>
                                            </td>
                                            <?php if ($_GET['type'] == 'all bid') { ?>
                                                <td><?= $hh['admin_bid_price']; ?></td>
                                            <?php } ?>
                                            <td class="actmk"> <a href="list_bid?booking_id=<?= $hh['id']; ?>"> <button
                                                        class="btn btn-icon btn-pill btn-success" type="button">
                                                        Check Bid Table
                                                    </button></a></td>
                                        </tr>
                                        <?php
                                        $x++;
                                    }
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                    <?php
            } else {
                echo "<h2>No Bid Yet.</h2>";
            }
            ?>
            </div>
        </div>
    </div>

    <form method="post" id="pass_bid" style="display: none">
        <input type="hidden" name="pass_bid" class="pass_bid">
    </form>


    <!--Add Modal To Display-->
    <div class="modal fade" id="confirm" style="z-index:99999999">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="card-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <div class="alert alert-danger" id="error" style="display:none">Error! Your Request could not be
                        submited.</div>

                    <h4 style="text-align: left">Pass this ride to all vendors</h4>
                    <div class="col-md-6 float-right" id="alert"></div>
                </div>
                <form method="post" id="add_vendor">
                    <div class="modal-body" id="display-modal">

                        <!-- div when the admin pass the ride all vendor-->
                        <div class="row" id="pass" style="display:none">
                            <form method="post">
                                <div class="col-md-12">
                                    <label>Enter your commission :</label><input type="text" class="form-control"
                                        id="cccoo" name="commition" required>
                                    <input type="hidden" name="pass_id" id="pass_id" required>
                                </div>
                                <div class="col-md-12">
                                    <br>
                                    <button type="submit" name="request" id="pass_id" class="btn btn-primary"
                                        style="float:right">Add</button>
                                </div>
                            </form>
                        </div>

                        <!-- div when the admin select the custom vendor-->
                        <form method="post">
                            <div class="row" id="custom" style="display:none">

                                <div class="col-md-6">
                                    <label>Please Select Custom Vendor:</label>
                                    <input type="hidden" name="custom_id" style="float:right" id="custom_id" required>
                                    <select name="custom_vendor" class="form-control">
                                        <option value="0">Select Vendor</option>
                                        <?php
                                        foreach ($vendors as $vendor) {
                                            ?>
                                            <option value="<?= $vendor['vendor_id']; ?>">
                                                <?= $vendor['contact'] . " - " . $vendor['full_name']; ?></option>
                                            <?php
                                        }
                                        ?>
                                    </select>
                                </div>

                                <div class="col-md-6">
                                    <label>Please Enter your Commission:</label>
                                    <input type="number" class="form-control" id="commission" name="comission"
                                        value="0">
                                </div>
                                <div class="col-md-12">
                                    <br>
                                    <button type="submit" name="request" id="add" class="btn btn-primary"
                                        style="float:right">Add</button>
                                </div>

                            </div>
                        </form>
                    </div>
                </form>
            </div>
            <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
    </div>

    <!--Add Modal To Display-->
    <div class="modal fade" id="change" style="z-index:99999999">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="card-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <div class="alert alert-danger" id="error2" style="display:none">Error! Your Request could not be
                        submited.</div>

                    <h4 style="text-align: left">Asign Driver and Cab to this booking</h4>
                    <div class="col-md-6 float-right" id="alert"></div>
                </div>
                <form method="post">
                    <div class="modal-body">

                        <div class="row" id="custom">
                            <div class="col-md-6">
                                <select name="new_cab" id="cccabs" class="form-control">
                                    <option value="0">Select cab</option>

                                </select>
                            </div>

                            <input type="hidden" name="ccbooking_id" id="ccbooking_id">
                            <input type="hidden" name="ccvendor_id" id="ccvendor_id">
                            <div class="col-md-6">
                                <select name="new_driver" id="ccdriver" class="form-control">
                                    <option value="0">Select Driver</option>

                                </select>
                            </div>

                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="submit" name="request" id="add" class="btn btn-primary"
                            style="float:right">Asign</button>
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    </div>
                </form>
            </div>
            <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
    </div>

    <div class="modal fade" id="cancel_modal" style="z-index:99999999">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="card-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <div class="alert alert-danger" id="error2" style="display:none">Error! Your Request could not be
                        submited.</div>

                    <h4 style="text-align: left">Mention Reason For Cancellation</h4>
                    <div class="col-md-6 float-right" id="alert"></div>
                </div>
                <form method="post" id="cancel_modal_reason">
                    <div class="modal-body">

                        <div class="row" id="custom">
                            <div class="col-md-12">
                                <input type="text" class="form-control" id="reason_cancel">
                            </div>

                            <input type="hidden" id="cancel_reason_booking_id">
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="submit" class="btn btn-primary" style="float:right">Submit</button>
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    </div>
                </form>
            </div>
            <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
    </div>
    <?php
    require_once 'footer.php';
    require_once 'jslinks.php';
    ?>

    <!-- Adon JS -->
    <script src="assets/js/custom.js"></script>
    <script src="assets/js/datatable.js"></script>


    <script>
        var i;

        //function for pass the informatio between user and driver
        function passinfo(str) {
            var confir = confirm("Are you sure to pass information to this ride?");
            if (confir) {
                $.ajax({
                    type: "POST",
                    url: "ajax_passinfo.php",
                    data: {
                        'booking_id': str,
                    },
                    success: function (data) {
                        var x = JSON.parse(data);
                        if (x.msg == "ok") {
                            $(".dtr-bs-modal").modal('toggle');
                            $("#msg").addClass(" alert-success");
                            $("#msg").css('display', 'block');
                            $("#msg").text("Success! Ride information successfully passed");
                        }


                    }

                });
            }
        }

        //change driver and cab

        function change_driver(vendor, booking) {
            $("#ccbooking_id").val(booking);
            $("#ccvendor_id").val(vendor);
            $('#change').modal('show');

            $.ajax({
                type: "POST",
                url: "fetch_data.php",
                data: {
                    'booking_id': booking,
                    'vendor_id': vendor,
                },
                success: function (data) {

                    var obj = JSON.parse(data);
                    if (obj.cabmsg == 'ok') {
                        $.each(obj.cabs, function (key, value) {
                            $('#cccabs').append('<option value="' + value.id + '">' + value.cab_name + ',' + value.rc_no + '</option>');

                        });

                    }
                    else {
                        alert("Cab not found for this vendor");
                        $('#change').modal('hide');
                    }

                    if (obj.drivermsg == 'ok') {
                        $.each(obj.drivers, function (key, value) {
                            $('#ccdriver').append('<option value="' + value.id + '">' + value.driver_name + ',' + value.contact + '</option>');

                        });
                    }
                    else {
                        alert("Driver not found for this vendor");
                        $('#change').modal('hide');
                    }


                }

            });
        }


        //complate ride

        function complete(str) {
            var confir = confirm("Are you sure to complete to this ride?");
            if (confir) {
                $.ajax({
                    type: "POST",
                    url: "ajax_complete.php",
                    data: {
                        'booking_id': str,
                    },
                    success: function (data) {
                        var x = JSON.parse(data);
                        if (x.msg == "ok") {
                            location.reload();
                        }
                        else {
                            $(".dtr-bs-modal").modal('toggle');
                            $("#msg").addClass(" alert-danger");
                            $("#msg").show();
                        }


                    }

                });
            }
        }


        //function for click booking confirm

        function confirm_booking(str, ee) {
            var comm = "#com" + ee;
            var val = $(comm).html();
            if (str == 'pass') {
                $('#cccoo').val(val);
                $('#pass').show();
                $('#custom').hide();
                $('#confirm').modal('show');
                document.getElementById('pass_id').value = ee;

            }
            else if (str == 'custom') {
                $('#custom').show();
                $('#pass').hide();
                $('#confirm').modal('show');
                $('#commission').val(val);
                document.getElementById('custom_id').value = ee;
            }
        }


        //function for cancel the booking
        function cancel_booking(booking_id) {
            $("#cancel_reason_booking_id").val(booking_id);
        }

        $("#cancel_modal_reason").submit(function (e) {
            e.preventDefault();
            var confir = confirm("Are you sure to cancel this ride");
            if (confir) {
                $.ajax({
                    type: "POST",
                    url: "ajax_cancel_booking.php",
                    data: {
                        'cancel_id': $("#cancel_reason_booking_id").val(),
                        'reason_for_cancel': $("#reason_cancel").val()
                    },
                    success: function (data) {
                        $('#cancel_modal').modal('hide');
                        var x = JSON.parse(data);
                        if (x.msg == "ok") {
                            $(".dtr-bs-modal").modal('toggle');
                            $("#msg").addClass(" alert-success");
                            $("#msg").css('display', 'block');
                            $("#msg").text("Succes! Your booking has been cancelled");
                            $("#row" + booking_id).remove();
                        }
                        else {
                            $(".dtr-bs-modal").modal('toggle');
                            $("#msg").addClass(" alert-danger");
                            $("#msg").show();
                            $("#msg").text(x.msg);
                        }

                    }

                });
            }
        })


        // function assing_bid
        function assing_bid(id, vendor_id, booking_id) {
            var id = id;
            var vendor_id = vendor_id;
            var booking_id = booking_id;
            $.ajax({
                url: 'ajax_assing_bid',
                data: { id: id, vendor_id: vendor_id, booking_id: booking_id },
                method: 'post',
                success: function (data) {
                    console.log(data);
                    window.location = 'list_bid?type=All Bid';
                }
            })

        }

        //  function assing_bid end  

    </script>

    <script>
        function check_bid(ee) {
            $('.upd').show(200);
            if ($('.add_bid').is(":checked")) {
                $('.bid_amt').show(200);
            }
            else {
                $('.bid_amt').hide(200);
            }
        }

        $('.upd').click(function () {
            if ($('.add_bid').is(":checked")) {
                $('.pass_bid').val($('.bid_amt').val());
            }
            else {
                $('.pass_bid').val('none');
            }
            $('#pass_bid').submit();

        })
    </script>