File: /var/www/grapossconnect/center-admin/products.php
<?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';
$GRP_PRODUCT_TYPES_TABLE = 'grp_product_types';
$GRP_SERIVCE_ORDER_DETAILS_TEMP = 'grp_service_order_details_temp';
$req = $_REQUEST['q'];
$temp_id = isset($_REQUEST["temp_id"]) ? $_REQUEST["temp_id"] : "";
if($temp_id!= ''){
$getProductQuery = "select id,temp_id, product_name, mrp, rate, total_products, total_rate, datetime from $GRP_SERIVCE_ORDER_DETAILS_TEMP where temp_id='$temp_id'";
$getProudctList = $wpdb->get_results($getProductQuery);
}
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;
$checkTypes = $wpdb->get_results("select id, type_name from $GRP_PRODUCT_TYPES_TABLE where ps_id='$psId' and status='1'");
?>
<div class="page-inner">
<div class="page-title-box"></div>
<div id="main-wrapper">
<div class="row">
<div class="page-title">
<h3>Product & Services</h3>
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="home">Product & Services</a></li>
<li class="active"><?php echo $getProDet->name; ?></li>
</ol>
</div>
</div>
</div>
<?php if($temp_id==''){ ?>
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="panel panel-white">
<div class="row">
<div class="col-sm-7">
<div class="stats-info">
<div class="panel-heading">
<h4 class="panel-title">Fill the below order form</h4>
</div>
<div class="panel-body">
<form class="form-horizontal" method="post" >
<div class="form-group">
<label for="inputEmail3" class="col-sm-2 control-label">Select Product</label>
<div class="col-sm-10">
<select class="form-control" id="product_onchange">
<option value="">-select-</option>
<?php foreach ($checkTypes as $ct) { ?>
<option id="txtDiscountCode" value="<?php echo $ct->id; ?>"><?php echo $ct->type_name; ?></option>
<?php } ?>
</select>
</div>
</div>
<div id="product_DataTable">
</div>
</form>
</div>
</div>
</div>
<div class="col-sm-5">
<div class="visitors-chart">
<div class="panel-heading">
<h4 class="panel-title"><?php echo $getProDet->name; ?></h4>
</div>
<div class="panel-body">
<?php echo $getProDet->desc; ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php } else { ?>
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="panel panel-white">
<div class="row">
<div class="col-sm-7">
<div class="stats-info">
<div class="panel-heading">
<h4 class="panel-title">Fill the below order form</h4>
</div>
<div class="panel-body">
<form class="form-horizontal" method="post" >
<table class="table">
<thead>
<tr>
<th>#</th>
<th>Product Name</th>
<th>MRP</th>
<th>Rate</th>
<th>Qty</th>
<!-- <th>Amount</th> -->
</tr>
</thead>
<tbody>
<?php
$a = 1;
foreach ($getProudctList as $list) {
?>
<tr>
<th scope="row"><?php echo $a; ?></th>
<td> <?php echo $list->product_name; ?></td>
<td> <?php echo $list->mrp; ?></td>
<td> <?php echo $list->rate; ?></td>
<td> <input type="text" name="totalProduct_<?php echo $a; ?>" class="form-control cust" id="c_name" placeholder="Qty" value="<?php echo $list->total_products; ?>">
<input type="hidden" name="totalProduct" value="<?php echo $a; ?>">
<input type="hidden" name="productID_<?php echo $a; ?>" value="<?php echo $list->id; ?>">
</td>
</tr>
<?php
$a++;
} ?>
</tbody>
</table>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10" style="margin-top:10px;">
<button type="submit" name="update" class="btn btn-success"> Update</button>
</div>
</div>
</form>
</div>
</div>
</div>
<div class="col-sm-5">
<div class="visitors-chart">
<div class="panel-heading">
<h4 class="panel-title"><?php echo $getProDet->name; ?></h4>
</div>
<div class="panel-body">
<?php echo $getProDet->desc; ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
}
if(isset($_REQUEST['update'])){
for ($i=1; $i <= $_REQUEST["totalProduct"]; $i++) {
$datetime = date('Y-m-d H:i:s', strtotime('+5 hour +30 minutes'));
$i;
$qty_in_carton = $_REQUEST["totalProduct_".$i];
$rate = $list->rate;
$productID = $_REQUEST["productID_".$i];
$carton_rate = $qty_in_carton * $rate;
$update = "UPDATE $GRP_SERIVCE_ORDER_DETAILS_TEMP SET total_products= '$qty_in_carton', total_rate= '$carton_rate', datetime= '$datetime' where temp_id='$temp_id' and id = '$productID'";
$wpdb->query($update);
?>
<script type="text/javascript">
var temp_id = '<?php echo $temp_id; ?>';
console.log(temp_id);
location.href = '/agent/product_details?q=asiraa&temp_id='+ temp_id;</script>
<?php
}}
if(isset($_REQUEST['submit'])){
for ($i=1; $i <= $_REQUEST["totalProduct"]; $i++) {
$temp_id = date('his');
$qty = "qty";
$datetime = date('Y-m-d H:i:s', strtotime('+5 hour +30 minutes'));
$rate = $_REQUEST["rate_".$i];
$mrp = $_REQUEST["mrp_".$i];
$product_name = $_REQUEST["product_name_".$i];
$qty_in_carton = $_REQUEST["totalProduct_".$i];
$carton_rate = $qty_in_carton * $rate;
$insertBookmark = "insert into $GRP_SERIVCE_ORDER_DETAILS_TEMP set temp_id='$temp_id', product_name= '$product_name', mrp= '$mrp', rate= '$rate', total_products= '$qty_in_carton', total_rate= '$carton_rate', datetime= '$datetime'";
$wpdb->query($insertBookmark);
?>
<script type="text/javascript">
var temp_id = '<?php echo $temp_id; ?>';
console.log(temp_id);
location.href = '/agent/product_details?q=asiraa&temp_id='+ temp_id;</script>
<?php
}}
?>
<script type="text/javascript">
$('#product_onchange').on('change', function() {
$.ajax({
url: "/agent/product_get_api.php",
type: "POST",
success: function(response) {
$('#product_DataTable').html(response);
}
});
});
function product(id, price) {
var totalProduct = $("input[type=text][name=totalProduct_"+id+"]").val();
if(totalProduct==''){
alert("Enter Product Quantity");
}
else {
var totalPrice = price * totalProduct;
$("#totalPrice_"+id).val(totalPrice);
}
}
</script>
<style>
.table {
font-size: 13px;
}
.cust {
width: 73px;
height: 30px;
border-radius: 4px;
}
</style>
</div><!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">bharatcbc.com</p>
</div>
</div><!-- Page Inner -->
<?php }
include_once('footer.php');
?>