public function gmgt_sell_product($data) { global $wpdb; $table_sell = $wpdb->prefix . 'gmgt_store'; //-------usersmeta table data-------------- $storedata['member_id'] = $data['member_id']; $storedata['sell_date'] = $data['sell_date']; $storedata['product_id'] = $data['product_id']; $storedata['quentity'] = $data['quentity']; $storedata['sell_by'] = get_current_user_id(); if ($data['action'] == 'edit') { $sellid['id'] = $data['sell_id']; $result = $wpdb->update($table_sell, $storedata, $sellid); return $result; } else { $obj_product = new Gmgtproduct(); $product = $obj_product->get_single_product($data['product_id']); $quentity = $product->quentity; if ($quentity >= $data['quentity'] && $quentity > 0) { $result = $wpdb->insert($table_sell, $storedata); $remainig_quentiy = $quentity - $data['quentity']; $productdata['quentity'] = $remainig_quentiy; $productid['id'] = $data['product_id']; $table_product = $wpdb->prefix . 'gmgt_product'; $wpdb->update($table_product, $productdata, $productid); } else { $result = 'no_stock'; } return $result; } }
</table> </div> </div> <?php } if ($active_tab == 'addproduct') { $product_id = 0; if (isset($_REQUEST['product_id'])) { $product_id = $_REQUEST['product_id']; } $edit = 0; if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'edit') { $edit = 1; $result = $obj_product->get_single_product($product_id); } ?> <div class="panel-body"> <form name="product_form" action="" method="post" class="form-horizontal" id="product_form"> <?php $action = isset($_REQUEST['action']) ? $_REQUEST['action'] : 'insert'; ?> <input type="hidden" name="action" value="<?php echo $action; ?> "> <input type="hidden" name="product_id" value="<?php echo $product_id; ?>
?> </th> </tr> </tfoot> <tbody> <?php $storedata = $obj_store->get_all_selling(); if (!empty($storedata)) { foreach ($storedata as $retrieved_data) { ?> <tr><td class="productname"><a href="?dashboard=user&page=store&tab=sellproduct&action=edit&sell_id=<?php echo $retrieved_data->id; ?> "><?php $product = $obj_product->get_single_product($retrieved_data->product_id); echo $product->product_name; ?> </a></td> <td class="membername"><?php $userdata = get_userdata($retrieved_data->member_id); echo $userdata->display_name; ?> </td> <td class="productquentity"><?php echo $retrieved_data->quentity; ?> </td> <td class="action"> <a href="?dashboard=user&page=store&tab=sellproduct&action=edit&sell_id=<?php echo $retrieved_data->id;