TERMINAL FM // admin

EDITOR
/home/u917864144/domains/humsafarholiday.com/public_html/admin/index.php
<?php
include 'header.php';
include 'page_load_header.php';

$record = mysqli_num_rows(mysqli_query($con, "SELECT * FROM packages"));
$pagi = ceil($record / $per_page);

$query = "SELECT * FROM packages ORDER BY id DESC Limit $s_id,$per_page";
$query_run = mysqli_query($con, $query);
?>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>

<script>
    $(document).ready(function() {
        $("#myInput").on("keyup", function() {
            var value = $(this).val().toLowerCase();
            $("#myTable tr").filter(function() {
                $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
            });
        });
    });
</script>


<!-- Search Modal -->
<div class="modal fade" id="searchModal" tabindex="-1" aria-labelledby="searchModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content bg-transparent">
            <div class="card mb-1">
                <div class="px-3 py-2 d-flex flex-row align-items-center" id="top-search">
                    <i class="ti ti-search fs-22"></i>
                    <input type="search" class="form-control border-0" id="search-modal-input" placeholder="Search for actions, people,">
                    <button type="button" class="btn p-0" data-bs-dismiss="modal" aria-label="Close">[esc]</button>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- ============================================================== -->
<!-- Start Page Content here -->
<!-- ============================================================== -->

<div class="page-content">

    <!-- Start Content-->
    <div class="page-container">

        <div class="page-title-head d-flex align-items-sm-center flex-sm-row flex-column gap-2">
            <div class="flex-grow-1">
                <h4 class="fs-18 fw-semibold mb-0">Products</h4>
            </div>

            <div class="text-end">
                <ol class="breadcrumb m-0 py-0">
                    <!-- <li class="breadcrumb-item"><a href="index.php?s_id=1">Dashboard</a></li> -->
                    <li class="breadcrumb-item active">Products</li>
                </ol>
            </div>
        </div>

        <div class="row">
            <div class="col-12">
                <div class="card">

                    <div class="card-header border-bottom border-light">
                        <div class="d-flex flex-wrap justify-content-between gap-2">
                            <div class="position-relative">
                                <input type="search" class="form-control ps-4 dt-input" id="myInput" placeholder="Search Company" title="Type in a name" aria-controls="sortTable">
                                <i class="ti ti-search position-absolute top-50 translate-middle-y ms-2"></i>
                            </div>

                            <div>
                                <a href="index_add.php" class="btn btn-primary"><i class="ti ti-plus me-1"></i>Add Products</a>
                            </div>
                        </div>
                    </div>

                    <div class="table-responsive">
                        <table class="table table-hover text-nowrap mb-0" id="sortTable">
                            <thead class="bg-light-subtle">
                                <tr>
                                    <th class="ps-3" style="width: 50px;">
                                        <input type="checkbox" class="form-check-input" id="customCheck1">
                                    </th>
                                    <th class="text-center" style="width: 120px;">Action</th>
                                    <th>ID</th>
                                    <th>Summer</th>
                                    <th>Monsoon</th>
                                    <th>Winter</th>
                                    <th>Home Id</th>
                                    <th>Product Name</th>
                                    <th>Cover Image</th>
                                    <th>Images</th>
                                    <th>Days</th>
                                    <th>Price</th>
                                    <th>Itinerary</th>
                                    <th>Inclusions</th>
                                    <th>Exclusions</th>
                                    <th>Category Name</th>
                                    <th>Domestic</th>
                                    <th>International</th>
                                    <th>Farmhouse</th>
                                    <th>Releted Name</th>
                                    <th>Video</th>
                                    <th>Offer Image</th>
                                    <th>Offer Text</th>
                                    <th>Special Id</th>
                                </tr>
                            </thead>
                            <tbody id="myTable">

                                <?php while ($row = mysqli_fetch_assoc($query_run)) { ?>

                                    <tr>
                                        <td class="ps-3">
                                            <input type="checkbox" class="form-check-input" id="customCheck2">
                                        </td>
                                        <td class="pe-3">
                                            <div class="hstack gap-1 justify-content-end">

                                                <!-- <a href="javascript:void(0);" class="btn btn-soft-primary btn-icon btn-sm rounded-circle"> 
                                                            <i class="ti ti-eye"></i>
                                                        </a> -->

                                                <a href="index_copy.php?id=<?php echo $row['id']; ?>" class="btn btn-soft-info btn-icon btn-sm rounded-circle">
                                                    <i class="ti ti-copy"></i>
                                                </a>

                                                <a href="index_edit.php?id=<?php echo $row['id']; ?>" class="btn btn-soft-success btn-icon btn-sm rounded-circle">
                                                    <i class="ti ti-edit fs-16"></i>
                                                </a>

                                                <a href="index_delete.php?id=<?php echo $row['id']; ?>" class="btn btn-soft-danger btn-icon btn-sm rounded-circle">
                                                    <i class="ti ti-trash"></i>
                                                </a>

                                            </div>
                                        </td>

                                        <td><?php echo $row['id']; ?></td>

                                        

                                        <td>
                                            <?php
                                            if ($row['summer_id'] == 2) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&summer_id=1" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&summer_id=2" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['monsoon_id'] == 2) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&monsoon_id=1" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&monsoon_id=2" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['winter_id'] == 2) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&winter_id=1" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&winter_id=2" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['home_id'] == 0) {
                                                echo "-";
                                            }
                                            if ($row['home_id'] == 1) {
                                                echo "Line 1";
                                            }
                                            if ($row['home_id'] == 2) {
                                                echo "Line 2";
                                            }
                                            if ($row['home_id'] == 3) {
                                                echo "Line 3";
                                            }
                                            if ($row['home_id'] == 4) {
                                                echo "Line 4";
                                            }
                                            if ($row['home_id'] == 5) {
                                                echo "Domestic";
                                            }
                                            if ($row['home_id'] == 6) {
                                                echo "International";
                                            }
                                            if ($row['home_id'] == 7) {
                                                echo "Honeymoon";
                                            }
                                            if ($row['home_id'] == 8) {
                                                echo "Cruise";
                                            }
                                            if ($row['home_id'] == 9) {
                                                echo "Bus Tour";
                                            }
                                            if ($row['home_id'] == 10) {
                                                echo "Car Rental Services";
                                            }
                                            if ($row['home_id'] == 11) {
                                                echo "Visa Services";
                                            }
                                            if ($row['home_id'] == 12) {
                                                echo "Farmhouse/Villa";
                                            }
                                            if ($row['home_id'] == 13) {
                                                echo "Honeymoon Special";
                                            }
                                            if ($row['home_id'] == 14) {
                                                echo "Customize";
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <div class="d-flex justify-content-start align-items-center gap-3">
                                                <?php echo $row['product_name']; ?>
                                            </div>
                                        </td>

                                        <td>
                                            <!-- <div class="avatar-md"> -->
                                            <img src="../image/product/<?php echo $row['cover_img']; ?>" alt="Product-1" width="70" class="img-fluid rounded-2">
                                            <!-- </div> -->
                                        </td>

                                        <td>
                                            <div class="d-flex justify-content-start align-items-center gap-3" style="width:10em; overflow:hidden;">
                                                <?php
                                                $image = explode("-,-", $row['image']);

                                                foreach ($image as $img) {
                                                ?>
                                                    <img src="<?php echo "../image/product/" . $img ?>" alt="img" width="70" class="img-fluid rounded-2">
                                                <?php } ?>
                                            </div>

                                        </td>

                                        <td><?php echo $row['trip_day']; ?></td>

                                        <td>₹ <?php echo $row['price']; ?>/-</td>

                                        <td>
                                            <div class="d-flex justify-content-start align-items-center gap-3" style="width:15em; overflow:hidden;">
                                                <?php echo $row['itinerary']; ?>
                                            </div>
                                        </td>

                                        <td>
                                            <div class="d-flex justify-content-start align-items-center gap-3" style="width:10em; overflow:hidden;">
                                                <?php echo $row['inclusions']; ?>
                                            </div>
                                        </td>

                                        <td>
                                            <div class="d-flex justify-content-start align-items-center gap-3" style="width:10em; overflow:hidden;">
                                                <?php echo $row['exclusions']; ?>
                                            </div>
                                        </td>



                                        <td>
                                            <?php
                                            if ($row['category_id'] == 0) {
                                                echo "-";
                                            }
                                            if ($row['category_id'] == 1) {
                                                echo "Domestic";
                                            }
                                            if ($row['category_id'] == 2) {
                                                echo "International";
                                            }
                                            if ($row['category_id'] == 3) {
                                                echo "Customize Packages";
                                            }
                                            if ($row['category_id'] == 4) {
                                                echo "Bus Tour";
                                            }
                                            if ($row['category_id'] == 5) {
                                                echo "Car Rental Services";
                                            }
                                            if ($row['category_id'] == 6) {
                                                echo "Visa Services";
                                            }
                                            if ($row['category_id'] == 7) {
                                                echo "Farmhouse / Villa Rental";
                                            }
                                            if ($row['category_id'] == 8) {
                                                echo "Membership Card";
                                            }
                                            if ($row['category_id'] == 9) {
                                                echo "Royal Caribbean";
                                            }
                                            if ($row['category_id'] == 10) {
                                                echo "Norway Cruises";
                                            }
                                            if ($row['category_id'] == 11) {
                                                echo "Honeymoon Special";
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['dom_id'] == 2) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&dom_id=1" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&dom_id=2" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['int_id'] == 2) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&int_id=1" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&int_id=2" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['farm_id'] == 2) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&farm_id=1" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&farm_id=2" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                        <td><?php echo $row['related_name']; ?></td>
                                        <td>
                                            <!-- <div class="avatar-md"> -->
                                            <video src="../image/video/<?php echo $row['video']; ?>" alt="Product-1" width="70" class="img-fluid rounded-2"></video>
                                            <!-- </div> -->
                                        </td>

                                        <td>
                                            <!-- <div class="avatar-md"> -->
                                            <img src="../image/offer_image/<?php echo $row['offer_img']; ?>" alt="Product-1" width="70" class="img-fluid rounded-2">
                                            <!-- </div> -->
                                        </td>

                                        <td>
                                            <div class="d-flex justify-content-start align-items-center gap-3">
                                                <?php echo $row['offer_text']; ?>
                                            </div>
                                        </td>

                                        <td>
                                            <?php
                                            if ($row['special_id'] == 1) {
                                                echo '<a href="status.php?id=' . $row['id'] . '&special_id=0" style=color:white;><div style=background-color:green;text-align:center;padding:6px;border-radius:5px; >Enable</div></a>';
                                            } else {
                                                echo '<a href="status.php?id=' . $row['id'] . '&special_id=1" style=color:white><div style=background-color:gray;text-align:center;padding:6px;border-radius:5px; >Disable</div></a>';
                                            }
                                            ?>
                                        </td>

                                    </tr>

                                <?php }  ?>

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

                    <?php include 'page_load_footer.php'; ?>

                </div>
            </div>
        </div>


        <!-- <script src="https://cdn.datatables.net/2.2.1/js/dataTables.js"></script>

        <script>
            new DataTable('#sortTable', {
                order: [
                    [3, 'desc']
                ]
            });
        </script> -->

        <?php
        include 'footer.php';
        ?>
Ln 1, Col 1
ONLINE
admin
31 items
09:49:12