<style>
/* 
Max width before this PARTICULAR table gets nasty
This query will take effect for any screen smaller than 760px
and also iPads specifically.
*/
@media only screen and (max-width: 560px), (min-device-width: 568px) and (max-device-width: 1024px) {
/* Force table to not be like tables anymore */
table, thead, tbody, th, td, tr {
	display: block;
}
/* Hide table headers (but not display: none;, for accessibility) */
thead tr {
	position: absolute;
	top: -9999px;
	left: -9999px;
}
tr {
	border: 0px solid #ccc;
}
td {
	/* Behave  like a "row" */
	border: none;
	/*border-bottom: 1px solid #eee; */
	position: relative;
	padding-left: 50%;
}
td:before {
	/* Now like a table header */
	position: unset; /*absolute causing issues*/
	/* Top/left values mimic padding */
	top: 6px;
	left: 6px;
	width: 45%;
	padding-right: 10px;
	white-space: nowrap;
}
/*
Label the data
*/
td:nth-of-type(1):before {content: "S.No";}
td:nth-of-type(2):before {content: "Name";}
td:nth-of-type(3):before {content: "Category";}
td:nth-of-type(4):before {content: "Description";}
td:nth-of-type(5):before {content: "Actions";}
.table-checkable tr > td:first-child, .table-checkable tr > th:first-child {
  max-width: 20%;  
}
}
@media only screen and (max-width: 480px), (min-device-width: 300px) and (max-device-width: 480px) {
	.table-checkable tr > td:first-child, .table-checkable tr > th:first-child {
	  max-width: 100%;  
	}
	td:nth-of-type(1)::before {
	  content: "";
	}
}
</style>
<div class="page-content-wrapper">
                <div class="page-content">
                    <div class="page-bar">
                        <div class="page-title-breadcrumb">
                            <div class=" pull-left">
                                <div class="page-title">Manage Products</div>
                            </div>
                            <ol class="breadcrumb page-breadcrumb pull-right">
                                <li><i class="fa fa-home"></i>&nbsp;<a class="parent-item" href="index.php?page=home">Home</a>&nbsp;<i class="fa fa-angle-right"></i>
                                </li>
                                <li><a class="parent-item" href="">Products</a>&nbsp;<i class="fa fa-angle-right"></i></li><li class="active">Manage Products</li>
                            </ol>
                        </div>
                    </div>
                    
	 <div class="row">
                        <div class="col-md-12">
                            <div class="card card-topline-red">
                                <div class="card-head">
                                    <header>Manage Products</header>
                                    <div class="tools">
                                        <!--<a class="fa fa-repeat btn-color box-refresh" href="javascript:;"></a>-->
	                                    <a class="t-collapse btn-color fa fa-chevron-down" href="javascript:;"></a>
	                                    <a class="t-close btn-color fa fa-times" href="javascript:;"></a>
                                    </div>
                                </div>
                                
                                <div class="card-body ">
                                    <div class="row p-b-20">
                                        <div class="col-md-12 col-sm-12 col-12">
                                            <div class="btn-group">
                                                <button onclick="location.href = 'index.php?page=add_product';" id="addRow1" class="btn btn-info">
                                                    Add New <i class="fa fa-plus"></i>
                                                </button>
                                            </div>
                                        </div>                                        
                                    </div>
                                    <form name="form" id="form" action="" method="post">	
									<input type="text" name="searchvalue" id="searchvalue" placeholder="Name,Description.."  value="<?php if(isset($_POST['searchvalue'])) { echo $_POST['searchvalue']; }  ?>" />
									<select name="category" id="category" >
	                                                    	<option value="">--Select Category--</option>
											              <?php if(mysqli_num_rows($categoryRs)>0){
											              	while($categoryRec = mysqli_fetch_array($categoryRs)){ 
											              		//get sub categories
											              		$subRs = mysqli_query($con, "SELECT id, name FROM tbl_product_categories WHERE parent_id = '".$categoryRec['id']."' ORDER BY name");	?>
											              	<option value="<?php echo $categoryRec['id']; ?>" <?php if(isset($_POST['category']) && $_POST['category']==$categoryRec['id']) { echo 'selected="selected"'; } else if(isset($resEdit['cat_id']) && $resEdit['cat_id']==$categoryRec['id']){ echo 'selected="selected"'; } ?> ><?php echo $categoryRec['name']; ?></option>
											              	<?php if(mysqli_num_rows($subRs)>0){ 
											              		while($categorySubRec = mysqli_fetch_array($subRs)){ ?>
											              			<option value="<?php echo $categorySubRec['id']; ?>" <?php if(isset($_POST['category']) && $_POST['category']==$categorySubRec['id']) { echo 'selected="selected"'; } else if(isset($resEdit['cat_id']) && $resEdit['cat_id']==$categorySubRec['id']){ echo 'selected="selected"'; } ?> ><?php echo '--'.$categorySubRec['name']; ?></option>
											              	<?php } } ?>
											              <?php } } ?>
											            </select>
									<button class="btn" name="submit1">Search</button>&nbsp;
									<button class="btn" name="clear">Clear</button>						
									</form>
                                    <?php if(isset($_REQUEST['success'])){ ?><div class="alert alert-success"><?php echo urldecode($_REQUEST['success']); ?></div></div><?php } ?>
                                    <?php if(isset($execDetails) && mysqli_num_rows($execDetails)>0) { ?>
                                    <table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example4">
                                        <thead>
                                            <tr>                                                
                                                <th> S.No. </th>
                                                <th> Name </th> 
                                                <th> Category </th>    
                                                <th> Description </th>                                                                                        
                                                <th> Actions </th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        	<?php
                                        	if(isset($_GET['p']) && is_numeric($_GET['p']) && ($_GET['p'] > 1)) {
												$slNo = ($_GET['p']*50-49);
											} else {
												$slNo = 1;
											}
											while($resDetails = mysqli_fetch_array($execDetails)) {	?>
                                            <tr class="odd gradeX">                                                
                                                <td><?php echo $slNo; ?></td>
                                                <td><?php echo $resDetails['name']; ?></td> 
                                                <td><?php echo getProductCategory($resDetails['cat_id']); ?></td>
                                                <td><?php echo $resDetails['description']; ?></td>   
                                                <td class="valigntop">
                                                    <div class="btn-group">
                                                        <button class="btn btn-xs deepPink-bgcolor dropdown-toggle no-margin" type="button" data-toggle="dropdown" aria-expanded="false"> Actions
                                                            <i class="fa fa-angle-down"></i>
                                                        </button>
                                                        <ul class="dropdown-menu pull-left" role="menu">                                                       	                                                       
                                                            <li>
                                                                <a href="index.php?page=add_product&id=<?php echo $resDetails['id']; ?>">
                                                                    <i class="icon-user"></i> Edit Product </a>
                                                            </li>                                                             
                                                            <li>
                                                                <a  onclick="return confirm('Are you sure to delete this item?');" href="index.php?page=manage_product&action=delete&del_id=<?php echo $resDetails['id']; ?>&p=<?php echo $p;?>">
                                                                    <i class="icon-docs"></i> Delete </a>
                                                            </li>                                                           
                                                        </ul>
                                                    </div>
                                                </td>
                                            </tr>                                            
                                            <?php ++$slNo; } ?>                                            
                                        </tbody>
                                    </table>
                                    <div style="float: left; width: auto;"> <?php echo $pageNums; ?> </div>
                                    <?php } else { ?>
                                    	<div class="alert alert-danger">Sorry! No Results Found.</div>					        		
					        		<?php }	?> 
                                </div>
                            </div>
                        </div>
                    </div>
                    

</div>
</div>