<?php

include_once("include/main.inc.php");

$res_latest = mysqli_fetch_array($sql_latest);

$productdisplay = $res_latest['package_title'];

// $page_metatitle =  $productdisplay;

// $page_metadesc = $productdisplay;

// $page_metakey = $productdisplay;


// $page_metatitle=$res_latest['product_metatitle']!=''?$res_latest['product_metatitle']:$res_latest['package_title'];
// $page_metakey=$res_latest['	metakeyword']!=''?$res_latest['	metakeyword']:$res_latest['package_title'];
// $page_metadesc=$res_latest['product_metadesc']!=''?$res_latest['product_metadesc']:$res_latest['package_title'];



$package_ID=$res_latest['package_id'];
$page_metatitle=$res_latest['product_metatitle']!=''?$res_latest['product_metatitle']:$res_latest['package_title'];
$page_metakey=$res_latest['metakeyword']!=''?$res_latest['metakeyword']:$res_latest['package_title'];
$page_metadesc=$res_latest['product_metadesc']!=''?$res_latest['product_metadesc']:$res_latest['package_title'];



$package_image =  explode(',', $res_latest['package_image']);

$product_id = $res_latest['package_id'];

$productbig_img = $package_image[0];



$prodIds = explode(',', $res_latest['product_cat']);

$categoryIds = $prodIds[0];

$cat_s = "select catImage, catName, displayName, catDesc, catID, catDesc1,catBanner, keyword1, keyword2, keyword3, parentID from category_tbl where catID='$categoryIds'";

$cat_q = mysqli_query($GLOBALS['dbconn'], $cat_s);

$num = mysqli_num_rows($cat_q);

$cat_r = mysqli_fetch_array($cat_q);

$category_id = $cat_r['catID'];

$hover = 'category';

$catn = $cat_r['catName'];

$cat_sql = "select catImage, catName, displayName, catDesc, catID, catDesc1,catBanner, parentID from category_tbl where parentID='$category_id' and status='Y'";

$cat_qry = mysqli_query($GLOBALS['dbconn'], $cat_sql);

$cccnum = mysqli_num_rows($cat_qry);

$cat_sql1 = "select catName, displayName, catID, parentID,catImage,catDesc1,catBanner,keyword1,keyword2,keyword3 from category_tbl where catID='$category_id'";

$cat_qry1 = mysqli_query($GLOBALS['dbconn'], $cat_sql1);

$cat_res = mysqli_fetch_array($cat_qry1);

$pageTitles = $cat_res['catName'];

$disTitles = $cat_res['displayName'];

$parent = $cat_res['parentID'];

$cat_sql2 = "select catName, displayName, catID,catBanner, parentID from category_tbl where catID='$parent'";

$cat_qry2 = mysqli_query($GLOBALS['dbconn'], $cat_sql2);

$num2 = mysqli_num_rows($cat_qry2);

$cat_res2 = mysqli_fetch_array($cat_qry2);

$mparent = $cat_res2['parentID'];

if ($cat_res['alt'] != '') {
    $alttag1 = $cat_res['alt'] . ' ' . $admin_res['targetlocation'];
} else {
    if ($cat_res['catID'] == '5' && $cat_res['parentID'] == '5' ) {
        $alttag1 = $cat_res['alt'] . ' in ' . $admin_res['targetlocation'];
    } else {
        $alttag1 = $disTitles. ' From ' . $admin_res['targetlocation'];
    }
}
if ($res_latest['package_image'] != '') {
    $imglink1 = getImage($package_image[0], 450,450, $res_latest['package_url'], "/uploaded-files/package-images/");
} else {
    $imglink1 = getImage($package_image[0], 450,450, $res_latest['package_url'], "/uploaded-files/package-images/");
}

?>

<!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="utf-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1">

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

</head>



<body>

    <div class="webpulse-main-wrapper">

        <!-- Header-->

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







        <!-- Heading Banner-->

        <div class="heading_banner" style="background-image: url(<?=site_url;?>/designer/images/banner-trip.jpg)">

            <div class="container position-relative">

                <div class="row">

                    <div class="col-lg-12 text-center">

                        <h1 class="cat_title"> <strong><?=$productdisplay;?></strong></h1>

                    </div>

                </div>

            </div>

        </div>





        <!-- Breadcrumb-->

        <div class="inner_breadcrumb hidden-xs">

            <div class="container">

                <div class="row">

                    <div class="col-lg-12">

                        <ul class="breadcrumb">

                            <li><a href="<?=site_url;?>" title="Home">Home</a></li>

                            <li class="active"><?=$productdisplay;?></li>

                        </ul>

                    </div>

                </div>

            </div>

        </div>





        <div class="wps_right py-5 float-start w-100">

            <div class="container">



                <div class="right_side">



                    <div class="wps_right position-relative">

                        <div class="row">

                            <div class="col-lg-8">

                                <?= html_entity_decode($res_latest['package_desc']);?>

                                <?php



                                    $aminities_sql = mysqli_query($GLOBALS['dbconn'], "select answer, slno, question from amminities_tbl where category_id='$product_id' order by slno ASC");



                                    if(mysqli_num_rows($aminities_sql)>0){ 



                                    ?>

                                <div class="accordion mb-4" id="accordionExample">



                                    <?php $i = 1;

                                while ($faq_res = mysqli_fetch_array($aminities_sql)) { ?>

                                    <div class="accordion-item wow fadeInLeft animated" data-wow-delay=".<?=$i;?>s">

                                        <div class="accordion-header" id="heading_<?= $faq_res['slno']; ?>">

                                            <span class="accordion-button  <?= $i==1?'':'collapsed';?>" role="button"

                                                data-bs-toggle="collapse" data-bs-target="#faq_<?= $faq_res['slno']; ?>"

                                                aria-expanded="true" aria-controls="heading_<?= $faq_res['slno']; ?>">

                                                <?= str_ireplace('{companyName}', $admin_res['companyName'], $faq_res['question']); ?>

                                            </span>

                                        </div>

                                        <div id="faq_<?= $faq_res['slno']; ?>"

                                            class="accordion-collapse <?=$i=='1'?'show':'';?> collapse"

                                            aria-labelledby="heading_<?= $faq_res['slno']; ?>"

                                            data-bs-parent="#accordionExample">

                                            <div class="accordion-body">

                                                <?= str_ireplace('{companyName}', $admin_res['companyName'], $faq_res['answer']); ?>

                                            </div>

                                        </div>

                                    </div>

                                    <?php $i++; } ?>



                                </div>

                                <?php } ?>



                                <div class="clearfix"></div>

                                <?php if($res_latest['map']!=''){ ?>

                                <div class="w-100">

                                    <iframe class="contact_map" src="<?=$res_latest['map'];?>" height="300"

                                        style="border:0;" loading="lazy"

                                        referrerpolicy="no-referrer-when-downgrade"></iframe>



                                </div>

                                <?php } ?>

                                <!-- Products Listing -->

                                <?php if($res_latest['package_desc2']!=''){ ?>

                                <div class="point">

                                    <div class="title3">Your Trip Inclusions</div>

                                    <?= $res_latest['package_desc2'];?>



                                </div>

                                <?php } ?>

                                <?php if($res_latest['package_desc3']!=''){ ?>

                                <div class="point">

                                    <div class="title3">Your Trip Exclusions</div>

                                    <?=$res_latest['package_desc3'];?>



                                </div>

                                <?php } ?>

                            </div>

                            <div class="col-lg-4">

                                <div class="right-box">

                                    <div class="product_right_image1 mb-3">



                                        <div class="product_dimage mb-3">

                                            <div class="detail_image">

                                                <div id="carouselExampleIndicators" class="carousel slide">

                                                    <div class="carousel-indicators">

                                                        <button type="button"

                                                            data-bs-target="#carouselExampleIndicators"

                                                            data-bs-slide-to="0" class="active" aria-current="true"

                                                            aria-label="Slide 1"></button>

                                                        <button type="button"

                                                            data-bs-target="#carouselExampleIndicators"

                                                            data-bs-slide-to="1" aria-label="Slide 2"></button>



                                                    </div>



                                                    <div class="carousel-inner">

                                                        <div class="carousel-item active">

                                                            <a href="javascript:void()" data-bs-toggle="modal"

                                                                data-bs-target="#productID" onclick="$('.catID').val('<?php echo $res_latest['catID'];?>'); $('.catName').html('<?php echo $res_latest['catName'];?>'); $('.catImg').attr('src','<?=$imglink1;?>');  $('.catImg').attr('alt','<?=$productdisplay;?>'); $('.catImg').attr('title','<?=$productdisplay;?>');"

                                                                title="<?=$productdisplay;?>">

                                                                <img src="<?=getImage($package_image[0], 450,450, $res_latest['package_url'], "/uploaded-files/package-images/");?>"

                                                                    alt="<?=$productdisplay;?>"

                                                                    title="<?=$productdisplay;?>">



                                                            </a>

                                                        </div>

                                                        <div class="carousel-item">

                                                            <a href="javascript:void()" data-bs-toggle="modal"

                                                                data-bs-target="#productID"

                                                                title="<?= $alttag1;?>">

                                                                <img src="<?=getImage($package_image[0], 450,450, $res_latest['package_url'], "/uploaded-files/package-images/");?>"
                                                                

                                                                    alt="<?= $alttag1;?>"

                                                                    title="<?= $alttag1;?>">



                                                            </a>

                                                        </div>



                                                    </div>

                                                    <!-- <button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide="prev">

                                                                <span class="carousel-control-prev-icon" aria-hidden="true"></span>

                                                                <span class="visually-hidden">Previous</span>

                                                            </button>

                                                            <button class="carousel-control-next" type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide="next">

                                                                <span class="carousel-control-next-icon" aria-hidden="true"></span>

                                                                <span class="visually-hidden">Next</span>

                                                            </button> -->

                                                </div>

                                                <!-- <img src="<?=getImage($package_image[0], 450,450, $res_latest['package_url'], "/uploaded-files/package-images/");?>"

                                                        alt="<?=$productdisplay;?>" title="<?=$productdisplay;?>"> -->

                                            </div>

                                        </div>



                                    </div>

                                    <div class="tourform wow fadeInRight animated animated" data-wow-duration="1500ms"

                                        data-wow-delay="400ms">

                                        <div class="title3 text-white text-start fw-bold fs-4 mb-3">Tour Booking</div>



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

                                        <div class="clear"></div>

                                    </div>

                                </div>

                            </div>

                        </div>





                    </div>

                </div>



                <?php

          

                    $toursql1= mysqli_query($GLOBALS['dbconn'],"SELECT package_title,package_url,location,package_image,day,night,package_id from packages_tbl WHERE FIND_IN_SET('$category_id', product_cat)");

               if(mysqli_num_rows($toursql1)>0){ 

                    ?>

                <!-- Tour package  -->



                <div class="you_may mt-3">Similar Tours Packages</div>

                <div class="row mb-2 pb-3 g-3">

                    <?php while($tourres1=mysqli_fetch_assoc($toursql1)){  

     $pro_image =  explode(',', $tourres1['package_image']); ?>

                    <div class="col-lg-4 mb-0 mb-lg-3">

                        <div class="trip-card-layout-3" data-trip-id="137474">

                            <!-- slide image -->

                            <a href="<?=site_url;?>/<?=$tourres1['package_url'];?>-<?=$tourres1['package_id'];?>.htm"
                            title="<?=$tourres1['package_title'];?>"

                                class="img-block"> <img alt="<?=$tourres1['package_title'];?>"

                                    title="<?=$tourres1['package_title'];?>" class="focus-image loaded"

                                    src="<?= getImage($pro_image[0], 400, 400, $tourres1['package_url'] . $product_r['package_id'], '/uploaded-files/package-images/'); ?>">

                                    

                            </a>

                            <!-- slide box -->

                            <div class="box">

                                <div class="box-holder">

                                    <a href="<?=site_url;?>/<?=$tourres1['package_url'];?>-<?=$tourres1['package_id'];?>.htm"

                                        class="title4"

                                        title="<?=$tourres1['package_title'];?>"><?=$tourres1['package_title'];?></a>

                                    <ul class="location-list fw-bold">

                                        <?php if($tourres1['night']!='' && $tourres1['day']!=''){ ?>

                                        <li style=""><i><svg fill="currentColor" width="16px" height="16px"

                                                    viewBox="0 0 1024 1024" xmlns="http://www.w3.org/2000/svg">

                                                    <path

                                                        d="M266.815 537.708c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.77 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.775 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.77 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zM266.815 679.347c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.77 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.775 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.77 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zM266.815 820.988c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.77 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.775 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zm182.77 0c0 22.62-18.34 40.96-40.96 40.96s-40.96-18.34-40.96-40.96 18.34-40.96 40.96-40.96 40.96 18.34 40.96 40.96zM228.18 81.918v153.6c0 11.311 9.169 20.48 20.48 20.48s20.48-9.169 20.48-20.48v-153.6c0-11.311-9.169-20.48-20.48-20.48s-20.48 9.169-20.48 20.48zm528.09 0v153.6c0 11.311 9.169 20.48 20.48 20.48s20.48-9.169 20.48-20.48v-153.6c0-11.311-9.169-20.48-20.48-20.48s-20.48 9.169-20.48 20.48z" />

                                                    <path

                                                        d="M890.877 137.517c33.931 0 61.44 27.509 61.44 61.44v703.375c0 33.931-27.509 61.44-61.44 61.44h-757.76c-33.931 0-61.44-27.509-61.44-61.44V198.957c0-33.931 27.509-61.44 61.44-61.44h757.76zm-757.76 40.96c-11.309 0-20.48 9.171-20.48 20.48v703.375c0 11.309 9.171 20.48 20.48 20.48h757.76c11.309 0 20.48-9.171 20.48-20.48V198.957c0-11.309-9.171-20.48-20.48-20.48h-757.76z" />

                                                    <path

                                                        d="M575.03 338.288c0-33.93-27.51-61.44-61.44-61.44s-61.44 27.51-61.44 61.44c0 33.93 27.51 61.44 61.44 61.44s61.44-27.51 61.44-61.44zm40.96 0c0 56.551-45.849 102.4-102.4 102.4s-102.4-45.849-102.4-102.4c0-56.551 45.849-102.4 102.4-102.4s102.4 45.849 102.4 102.4z" />

                                                </svg></i><?=$tourres1['day'];?> D - <?=$tourres1['night'];?> N   </li>

                                        <?php } ?>

                                        <li style=""><i><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"

                                                    fill="currentColor" viewBox="0 0 16 16">

                                                    <path

                                                        d="M12.166 8.94c-.524 1.062-1.234 2.12-1.96 3.07A31.493 31.493 0 0 1 8 14.58a31.481 31.481 0 0 1-2.206-2.57c-.726-.95-1.436-2.008-1.96-3.07C3.304 7.867 3 6.862 3 6a5 5 0 0 1 10 0c0 .862-.305 1.867-.834 2.94zM8 16s6-5.686 6-10A6 6 0 0 0 2 6c0 4.314 6 10 6 10z">

                                                    </path>

                                                    <path

                                                        d="M8 8a2 2 0 1 1 0-4 2 2 0 0 1 0 4zm0 1a3 3 0 1 0 0-6 3 3 0 0 0 0 6z">

                                                    </path>

                                                </svg></i><?=$tourres1['location'];?></li>

                                    </ul>

                                    <div class="d-flex align-items-center justify-content-center"> <a title="whatapp"

                                            data-bs-toggle="modal" href="#whatsapp" class="btn green-btn btn-sm"> <i>

                                                <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20"

                                                    fill="currentColor" viewBox="0 0 16 16">

                                                    <path

                                                        d="M13.601 2.326A7.854 7.854 0 0 0 7.994 0C3.627 0 .068 3.558.064 7.926c0 1.399.366 2.76 1.057 3.965L0 16l4.204-1.102a7.933 7.933 0 0 0 3.79.965h.004c4.368 0 7.926-3.558 7.93-7.93A7.898 7.898 0 0 0 13.6 2.326zM7.994 14.521a6.573 6.573 0 0 1-3.356-.92l-.24-.144-2.494.654.666-2.433-.156-.251a6.56 6.56 0 0 1-1.007-3.505c0-3.626 2.957-6.584 6.591-6.584a6.56 6.56 0 0 1 4.66 1.931 6.557 6.557 0 0 1 1.928 4.66c-.004 3.639-2.961 6.592-6.592 6.592zm3.615-4.934c-.197-.099-1.17-.578-1.353-.646-.182-.065-.315-.099-.445.099-.133.197-.513.646-.627.775-.114.133-.232.148-.43.05-.197-.1-.836-.308-1.592-.985-.59-.525-.985-1.175-1.103-1.372-.114-.198-.011-.304.088-.403.087-.088.197-.232.296-.346.1-.114.133-.198.198-.33.065-.134.034-.248-.015-.347-.05-.099-.445-1.076-.612-1.47-.16-.389-.323-.335-.445-.34-.114-.007-.247-.007-.38-.007a.729.729 0 0 0-.529.247c-.182.198-.691.677-.691 1.654 0 .977.71 1.916.81 2.049.098.133 1.394 2.132 3.383 2.992.47.205.84.326 1.129.418.475.152.904.129 1.246.08.38-.058 1.171-.48 1.338-.943.164-.464.164-.86.114-.943-.049-.084-.182-.133-.38-.232z">

                                                    </path>

                                                </svg> </i> </a> <a href="tel:<?=$admin_res['mobile'];?>"

                                            class="btn red-btn" title="Call us"> <i><svg xmlns="http://www.w3.org/2000/svg"

                                                width="16" height="16" fill="currentColor" viewBox="0 0 16 16">

                                                <path

                                                    d="M3.654 1.328a.678.678 0 0 0-1.015-.063L1.605 2.3c-.483.484-.661 1.169-.45 1.77a17.568 17.568 0 0 0 4.168 6.608 17.569 17.569 0 0 0 6.608 4.168c.601.211 1.286.033 1.77-.45l1.034-1.034a.678.678 0 0 0-.063-1.015l-2.307-1.794a.678.678 0 0 0-.58-.122l-2.19.547a1.745 1.745 0 0 1-1.657-.459L5.482 8.062a1.745 1.745 0 0 1-.46-1.657l.548-2.19a.678.678 0 0 0-.122-.58L3.654 1.328zM1.884.511a1.745 1.745 0 0 1 2.612.163L6.29 2.98c.329.423.445.974.315 1.494l-.547 2.19a.678.678 0 0 0 .178.643l2.457 2.457a.678.678 0 0 0 .644.178l2.189-.547a1.745 1.745 0 0 1 1.494.315l2.306 1.794c.829.645.905 1.87.163 2.611l-1.034 1.034c-.74.74-1.846 1.065-2.877.702a18.634 18.634 0 0 1-7.01-4.42 18.634 18.634 0 0 1-4.42-7.009c-.362-1.03-.037-2.137.703-2.877L1.885.511z">

                                                </path>

                                            </svg> </i> </a> <a data-bs-toggle="modal" href="#myModal" title="Book Now"

                                            class="btn blue-btn btn-sm"> Book Now</a> </div>

                                </div>

                            </div>

                        </div>

                    </div>



                    <?php } ?>

                </div>

                <?php }  ?>





            </div>

        </div>



        <!-- Footer-->

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

    </div>

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

</body>



</html>