<?php
include "management/php/functions.php";
$menu = "product";

$keyword = input_test($_GET['keyword']);

$sqlblog0 = $connect->query("SELECT * FROM `tbl_blog` WHERE `delete_flag`=0");

$sqldesc = $connect->query("SELECT * FROM `tbl_product` WHERE `delete_flag` =3");
$sqldesc = $sqldesc->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>  
    <title>ساماران pvc | محصولات | تولید کننده چسب وکیوم و روکش pvc</title>
    <meta name="description" content="<?php echo $sqldesc['description2']; ?> ">
    <meta property="og:title" content="ساماران pvc | محصولات | تولید کننده چسب وکیوم و روکش pvc" />
    <meta property="og:description" content="<?php echo $sqldesc['description2'];?>" />
    <meta name="robots" content="noindex" />
    <?php include('head.php');?>
</head>

<body id="bg">
    <div id="loading-area"></div>
    <div class="page-wraper">
        <!-- header -->
        <?php include'alert.php'; ?>
        <header class="site-header header mo-left header-style-1">
            <?php include('menu.php'); ?>
        </header>
        <!-- header END -->
        <!-- Content -->
        <div class="page-content">
            <!-- inner page banner -->
            <div class="dez-bnr-inr overlay-black-middle" style="background-image:url(images/product/Untitled-21.jpg);">
                <div class="container">
                    <div class="dez-bnr-inr-entry">
                        <h1 class="text-white">نتایج جستجو برای "<?php echo $keyword; ?>"</h1>
                    </div>
                </div>
            </div>
            <!-- inner page banner END -->
            <!-- Breadcrumb row -->
            <div class="breadcrumb-row">
                <div class="container">
                    <ul class="list-inline">
                        <li><a href="index.php">صفحه اصلی</a></li>
                        <li><?php echo $keyword; ?></li>
                    </ul>
                </div>
            </div>
            <!-- Breadcrumb row END -->
            <!-- contact area -->
            <div class="content-inner section-full bg-white">
                <!-- Product -->
                <div class="container">

                    <div class="row">
                        <div class="col-lg-3 col-md-5 col-sm-12 blog-sidebar">
                            <aside class="side-bar">
                                <div class="widget">
                                    <h4 class="widget-title">جستجوی فعلی</h4>
                                    <div class="search-bx">
                                        <form action="<?php echo $baseUrl; ?>searchproduct.php" role="search" method="get">
                                            <div class="input-group">
                                                <input name="keyword" type="text" class="form-control" placeholder="<?php echo $keyword ?>">
                                                <span class="input-group-btn">
                                                    <button type="submit" class="site-button"><i class="fa fa-search"></i></button>
                                                </span>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                                <div class="widget recent-posts-entry">
                                    <h4 class="widget-title">مقالات پر بازدید</h4>
                                    <div class="widget-post-bx">
                                        <?php while ($sqlblog2 = $sqlblog0->fetch(PDO::FETCH_ASSOC)) { ?>
                                            <div class="widget-post clearfix">
                                                <div class="dez-post-media"> <img src="<?php echo $sqlblog2['image']; ?>" width="200" height="143" alt="<?php echo $sqlblog2['title']; ?>"> </div>
                                                <div class="dez-post-info">
                                                    <div class="dez-post-header">
                                                        <h6 class="post-title"><a href="<?php echo $baseUrl; ?>single/<?php echo $sqlblog2['id'].'/'.$sqlblog2['title']; ?>"><?php echo $sqlblog2['title']; ?></a></h6>
                                                    </div>
                                                    <div class="dez-post-meta">
                                                        <ul>
                                                            <li class="post-author">توسط ادمین</li>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </div>
                                        <?PHP } ?>
                                    </div>
                                </div>
                                <div class="widget widget_services">
                                    <h4 class="widget-title">دسته بندی محصولات</h4>
                                    <ul>
                                        <?php
                                        $sqlgroup = $connect->query("SELECT * FROM `tbl_product_group` WHERE `delete_flag`=0");
                                        while ($sqlgroup1 = $sqlgroup->fetch(PDO::FETCH_ASSOC)) { ?>
                                            <li><a href="<?php echo $baseUrl; ?>shop-group/<?php echo $sqlgroup1['id']."/".$sqlgroup1['title']; ?>"><?php echo $sqlgroup1['title']; ?></a></li>
                                        <?php } ?>
                                    </ul>
                                </div>
                            </aside>
                        </div>
                        <div class="col-lg-9 col-md-7 col-sm-12">
                            <div class="text-center m-b30">
                                <h2 class="m-t0">نتایج جستجو</h2>
                                <div class="dez-separator-outer ">
                                    <div class="dez-separator bg-primary style-skew"></div>
                                </div>
                            </div>
                            <div class="row" id="masonry">
                                <?php 
                                if (!empty($keyword) || $keyword!="") {
                                    $sqlproduct = "SELECT * FROM `tbl_product` WHERE `title` like '%" . $keyword . "' OR `title` like '%" . $keyword . "%' OR `title` like '%" . $keyword . "%' AND `delete_flag`=0 order by `id` desc";
                                    $sqlproduct = $connect->prepare($sqlproduct);
                                    $sqlproduct->execute();
                                    if($sqlproduct -> rowCount() > 0){
                                        while ($sqlproduct1 = $sqlproduct->fetch(PDO::FETCH_ASSOC)) {
                                ?>
                                    <div class="col-md-6 col-lg-4 col-sm-12 m-b30 product-item card-container">
                                        <div class="dez-box ">
                                            <div class="dez-thum-bx  dez-img-effect "> <img src="<?php echo $baseUrl.$sqlproduct1['image'] ?>" alt="<?php echo $sqlproduct1['title'] ?>">
                                                <div class="overlay-bx">
                                                    <div class="overlay-icon">
                                                        <a href="<?php echo $baseUrl; ?>product/<?php echo $sqlproduct1['id'].'/'.$sqlproduct1['title']; ?>"> <i class=""> اطلاعات بیشتر</i> </a>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="dez-info p-a20 text-center">
                                                <h3 class="dez-title m-t0 text-uppercase"><a href="<?php echo $baseUrl; ?>product/<?php echo $sqlproduct1['id'].'/'.$sqlproduct1['title'] ?>"><?php echo $sqlproduct1['title'] ?></a></h3>
                                                <p style="font-size: 18px;line-height: 22px;font-weight: 600;color: black;" class="widget-title">
                                                    <?php
                                                    $isOff1 = $sqlproduct1['price'];
                                                    $isOff2 = $sqlproduct1['off_price'];
                                                    if ($isOff1 == 0 || $isOff1 == "") {
                                                        echo '<del class="m-r10"></del><br> برای قیمت تماس بگیرید ';
                                                    } else {
                                                        if ($isOff1 == $isOff2) {
                                                            echo '<del class="m-r10"></del><br>' . number_format($sqlproduct1['price']) . ' تومان ';
                                                        } else {
                                                            echo '<del class="m-r10">' . number_format($sqlproduct1['price']) . ' تومان </del><br>' . number_format($sqlproduct1['off_price']) . ' تومان ';
                                                        }
                                                    }
                                                    ?>
                                                </p>
                                                <div class="m-t20 dez-btn">
                                                    <a href="<?php echo $baseUrl; ?>product/<?php echo $sqlproduct1['id'].'/'.$sqlproduct1['title']; ?>" class="site-button">اطلاعات بیشتر</a>
                                                </div>
                                            </div>
                                            <?php
                                            $off = $sqlproduct1['off'];
                                            if ($off != 0) {
                                                echo '<div class="sale"><span class="site-button button-sm primary">' . $sqlproduct1['off'] . '% تخفیف </span></div>';
                                            }
                                            ?>
                                        </div>
                                    </div>
                                <?php 
                                        } 
                                    }else{
                                ?>
                                        <div class="searchfail">
                                            <a href="<?php echo $baseUrl; ?>shop/فروشگاه">
                                                نتیجه ای یافت نشد بازگشت به صفحه محصولات .
                                            </a>
                                        </div>
                                <?php
                                    }
                                }else{
                                ?>
                                <div class="searchfail">
                                    <a href="<?php echo $baseUrl; ?>shop/فروشگاه">
                                        نتیجه ای یافت نشد بازگشت به صفحه محصولات .
                                    </a>
                                </div>
                                <?php
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                    <div class="row m-t30 product-service">
                        <div class="col-md-6 col-lg-4 m-b30">
                            <div class="icon-bx-wraper bx-style-1 p-a20 left bg-primary clearfix text-white">
                                <div class="icon-bx-md  bg-white text-primary"> <a href="#" class="icon-cell "><i class="fa fa-plane"></i></a> </div>
                                <div class="icon-content">
                                    <h3 class="dez-tilte text-uppercase m-b5">ارسال رایگان</h3>
                                    <p>لورم ایپسوم متن ساختگی با تولید سادگی نامفهوم از صنعت چاپ</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6 col-lg-4 m-b30">
                            <div class="icon-bx-wraper bx-style-1 p-a20 left clearfix bg-primary text-white">
                                <div class="icon-bx-md  bg-white text-primary"> <a href="#" class="icon-cell "><i class="fa fa-briefcase"></i></a> </div>
                                <div class="icon-content">
                                    <h3 class="dez-tilte text-uppercase m-b5">قیمت کارخانه ای</h3>
                                    <p>لورم ایپسوم متن ساختگی با تولید سادگی نامفهوم از صنعت چاپ</p>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6 col-lg-4 m-b30">
                            <div class="icon-bx-wraper bx-style-1 p-a20 left bg-primary clearfix text-white">
                                <div class="icon-bx-md  bg-white text-primary"> <a href="#" class="icon-cell "><i class="fa fa-cogs"></i></a> </div>
                                <div class="icon-content">
                                    <h3 class="dez-tilte text-uppercase m-b5">خرید امن</h3>
                                    <p>لورم ایپسوم متن ساختگی با تولید سادگی نامفهوم از صنعت چاپ</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Product END -->
            </div>
            <!-- contact area  END -->
        </div>
        <!-- Content END-->
        <!-- Footer -->
        <footer class="site-footer ">
            <?php include('footer.php'); ?>
        </footer>
        <!-- Footer END-->
        <button class="scroltop fa fa-arrow-up"></button>
    </div>
    <!-- JavaScript  files ========================================= -->
    <script src="<?php echo $baseUrl; ?>js/jquery.min.js"></script>
    <!-- JQUERY.MIN JS -->
    <script src="<?php echo $baseUrl; ?>plugins/bootstrap/js/popper.min.js"></script>
    <!-- BOOTSTRAP.MIN JS -->
    <script src="<?php echo $baseUrl; ?>plugins/bootstrap/js/bootstrap.min.js"></script>
    <!-- BOOTSTRAP.MIN JS -->
    <script src="<?php echo $baseUrl; ?>plugins/bootstrap-select/bootstrap-select.min.js"></script>
    <!-- FORM JS -->
    <script src="<?php echo $baseUrl; ?>plugins/bootstrap-touchspin/jquery.bootstrap-touchspin.js"></script>
    <!-- FORM JS -->
    <script src="<?php echo $baseUrl; ?>plugins/magnific-popup/magnific-popup.js"></script>
    <!-- MAGNIFIC POPUP JS -->
    <script src="<?php echo $baseUrl; ?>plugins/counter/waypoints-min.js"></script>
    <!-- WAYPOINTS JS -->
    <script src="<?php echo $baseUrl; ?>plugins/counter/counterup.min.js"></script>
    <!-- COUNTERUP JS -->
    <script src="<?php echo $baseUrl; ?>plugins/imagesloaded/imagesloaded.js"></script>
    <!-- IMAGESLOADED -->
    <script src="<?php echo $baseUrl; ?>plugins/masonry/masonry-3.1.4.js"></script>
    <!-- MASONRY -->
    <script src="<?php echo $baseUrl; ?>plugins/masonry/masonry.filter.js"></script>
    <!-- MASONRY -->
    <script src="<?php echo $baseUrl; ?>plugins/owl-carousel/owl.carousel.js"></script>
    <!-- OWL SLIDER -->
    <script src="<?php echo $baseUrl; ?>js/custom.min.js"></script>
    <!-- CUSTOM FUCTIONS  -->
    <script src="<?php echo $baseUrl; ?>js/dz.carousel.min.js"></script>
    <!-- SORTCODE FUCTIONS  -->
    <script src="<?php echo $baseUrl; ?>js/dz.ajax.js"></script>
    <!-- CONTACT JS  -->


</body>

</html>