<?php
include_once('header.php');
$GRP_MERCHANTS_TABLE = 'grp_merchants';
$GRP_PRODUCT_SERVICES_TABLE = 'grp_product_services';
$GRP_PRODUCT_SERVICES_CATEGORY_TABLE = 'grp_product_services_category';
$req = $_REQUEST['q'];
if($req!=''){
	
	$getProProQuery = "select ps.ps_id, ps.name, ps.logo, ps.desc, ps.slug, ps.custom_css, c.category_name, m.merchant_name from $GRP_PRODUCT_SERVICES_TABLE as ps LEFT JOIN $GRP_PRODUCT_SERVICES_CATEGORY_TABLE as c ON c.category_id=ps.category_id LEFT JOIN $GRP_MERCHANTS_TABLE as m ON m.merchant_id=ps.merchant_id where ps.slug='$req'";
	$getProDet = $wpdb->get_row($getProProQuery);
	$psId = $getProDet->ps_id;

?>

<div class="page-inner">
<script src="../assets/plugins/jquery/jquery-2.1.3.min.js"></script>
<script src="../assets/plugins/jquery-ui/jquery-ui.min.js"></script>

<link href="../assets/plugins/datatables/css/jquery.datatables.min.css" rel="stylesheet" type="text/css"/>
<script src="../assets/plugins/datatables/js/jquery.dataTables.min.js"></script>

<link href="../assets/plugins/datatables/css/responsive.dataTables.min.css" rel="stylesheet" type="text/css"/>
<script src="../assets/plugins/datatables/js/dataTables.responsive.min.js"></script>


<script>
    jQuery.noConflict();
    jQuery(function($) {
        $('#example').dataTable({
            "bPaginate": true,
			"responsive": true,
            bFilter: true,
            "iDisplayLength": 10,
			
        });
     
    });
</script>
    <div id="main-wrapper">
        <div class="row">
            <div class="page-title">
                <h3>Request List</h3>
				
                <div class="page-breadcrumb">
                    <ol class="breadcrumb">
                        <li><a href="home">Request</a></li>
                        <li class="active"><?php echo $getProDet->name; ?></li>
                    </ol>
                </div>
            </div>
        </div>
		<div class="row">
            <div class="col-md-12">
                <div class="panel panel-white">
                                <div class="panel-heading clearfix">
                                    <h4 class="panel-title"><?php echo $getProDet->name; ?> Request List</h4>
                                </div>
                                <div class="panel-body">
                                   <div class="table-responsive">
                                    <table id="example" class="display table" style="width: 100%; cellspacing: 0;">
                                        <thead>
                                            <tr>
                                                <th>#S.No.</th>
                                                <th>Type</th>
                                                <th>Name</th>
                                                <th>Email</th>
                                                <th>Mobile</th>
                                                <th>Pincode</th>
												<th>City</th>
												<th>Agent</th>
												<th>Date</th>
                                            </tr>
                                        </thead>
                                        
                                        <tbody>
                                            <tr>
                                                <td>1</td>
                                                <td>Life Insurance</td>
                                                <td>Testing A</td>
                                                <td>testing.a@gmail.com</td>
                                                <td>7777777777</td>
                                                <td>110049</td>
												<td>South Delhi</td>
												<td>GRPS-000001</td>
                                                <td>05-Dec-2019</td>
                                            </tr>
                                            <tr>
                                                <td>2</td>
                                                <td>Medical Insurance</td>
                                                <td>Testing B</td>
                                                <td>testing.b@gmail.com</td>
                                                <td>8888888888</td>
                                                <td>110050</td>
												<td>South Delhi</td>
												<td>GRPS-000001</td>
                                                <td>05-Dec-2019</td>
                                            </tr>
                                        </tbody>
                                       </table>  
                                    </div>
                                </div>
                            </div>
            </div>
        </div>

<style>
.table {
    font-size: 13px;
}
.cust{
	width: 73px;
    height: 30px;
    border-radius: 4px;
}
.dataTables_length select{
	width:auto !important;
}
table.dataTable.dtr-inline.collapsed>tbody>tr[role="row"]>td:first-child, table.dataTable.dtr-inline.collapsed>tbody>tr[role="row"]>th:first-child{
    padding-left: 25px !important; 
}
</style>		
    </div><!-- Main Wrapper -->
    <div class="page-footer">
        <p class="no-s">bharatcbc.com</p>
    </div>
</div><!-- Page Inner -->

<?php }

include_once('footer.php');
?>