<?php
include_once('header.php');
$GRP_PRODUCTS = 'grp_product';
$GRP_PRODUCT_CATEGORY = 'grp_product_category';
?>
<style>
    .agent-service-form {
        margin: 0;
        padding: 10px 0 0;
    }

    .agent-service-form input {
        padding: 8px 10px;
        margin: 0;
        width: 46%;
        outline: none;
        border-radius: 4px 0 0 4px;
    }

    .agent-service-form .fa-shopping-cart {
        background: #018de5;
        color: #fff;
        padding: 11px 14px;
        border-radius: 0 4px 4px 0;
        cursor: pointer;
        position: absolute;
        right: 15px;
    }

    .home-clickhere {
        text-align: center;
        margin-bottom: 0;
    }

    .home-clickhere .btn-primary {
        padding: 4px 20px;
    }

    #new_products {
        /* padding: 20px 10px; */
        /* margin-top: 10px; */
        /* height: 510px; */
        /* overflow-y: scroll; */
    }

    .product-service-section {
        padding: 3em 0;
        background: #fff;
        margin-top: 10px;
    }

    .product-service-section .product-service-box {
        background: #bfe2f8;
        border-radius: 4px;
        cursor: pointer;
        transition: all .25s ease-in-out;
        margin-bottom: 20px;
    }

    .product-service-section .product-service-box:hover {
        box-shadow: 0 0 10px 0px #7b7b7b;
    }

    @media only screen and (max-width: 600px) {
        .agent-service-form input {
            width: 100%;
        }
    }
</style>

<div class="page-inner">
    <div id="main-wrapper">
        <div class="page-title">
			<div class="page-breadcrumb">
				<ol class="breadcrumb">
					<li><a href="home">Home</a></li>
					<li class="active">Product &amp; Services</li>
				</ol>
			</div>
			<h3>Product &amp; Services</h3>
		</div>

        <section class="product-service-section">
            <div class="row m-0">
                <div id="new_products" class="col-md-12 col-sm-12 col-xs-12">
                    <?php
                    $getServices = $wpdb->get_results("SELECT p.product_id, p.category_id, p.product_name, p.logo, p.display_order, pc.category_name FROM $GRP_PRODUCTS AS p LEFT JOIN $GRP_PRODUCT_CATEGORY AS pc ON p.category_id=pc.category_id WHERE p.status='A'");
                    if (sizeof($getServices) > 0) {
                        foreach ($getServices as $serv) {
                    ?>
                            <div class="col-md-3 col-sm-3 col-xs-12 search_title">
                                <div class="point panel-mn-show product-service-box" style="visibility: visible; opacity: 1; display: block; transform: translateY(0px);">
                                    <div class="panel-body p-body h-auto">
                                        <div class="product-thumb"><img src="assets/images/product-images/<?php echo $serv->logo; ?>"></div>
                                        <div class="product-details p-title-box">
                                            <h4 class="f-size-15">
                                                <a class="service_name" href="#" target="_blank"> <?php echo $serv->product_name; ?> </a>
                                            </h4>
                                            <p class="service_name category"><?php echo $serv->category_name; ?></p>
                                        </div>
                                        <h4 class="home-clickhere">
                                            <a class="btn btn-primary btn-sm" href="shine-registration" target="_blank">Click Here</a>
                                        </h4>
                                    </div>
                                </div>
                            </div>
                    <?php
                        }
                        } else {
                    ?>
                        <div class="col-md-3 col-sm-3 col-xs-12 search_title">
                            No services found
                        </div>
                    <?php } ?>
                </div>
            </div>
        </section>
    </div>
    <div class="page-footer">
        <p class="no-s">grapossconnect.com</p>
    </div>
</div>
<?php
include_once('footer.php');
?>