Product Management

The pasted code is the Product menu code, add a logging history code based on the Inventory History so the adding, editing/updating and deleting of product will be recorded or seen in the Inventory History. The Product menu code: prefix . 'products'; $category_table_name = 'categories'; // Adjust if you use prefixes: $wpdb->prefix . 'categories'; // Ensure upload directory exists $upload_dir_info = wp_upload_dir(); $upload_dir = $upload_dir_info['basedir'] . '/product_images/'; $upload_url = $upload_dir_info['baseurl'] . '/product_images/'; // Base URL for displaying images if (!file_exists($upload_dir)) { wp_mkdir_p($upload_dir); // Use wp_mkdir_p for recursive creation } $editing_product = null; // Initialize editing product variable $message = ''; // For success/error messages $message_type = ''; // 'success' or 'error' // --- Handle Delete Product Action --- if (isset($_GET['action']) && $_GET['action'] === 'delete_product' && isset($_GET['id']) && isset($_GET['_wpnonce']) && wp_verify_nonce($_GET['_wpnonce'], 'delete_product_' . absint($_GET['id']))) { $product_id_to_delete = absint($_GET['id']); if ($product_id_to_delete) { // Optional: Delete image file first $image_url_to_delete = $wpdb->get_var($wpdb->prepare("SELECT image_url FROM $product_table_name WHERE id = %d", $product_id_to_delete)); if ($image_url_to_delete) { $image_path = str_replace($upload_url, $upload_dir, $image_url_to_delete); if (file_exists($image_path)) { @unlink($image_path); } } // Delete product record $deleted = $wpdb->delete( $product_table_name, array('id' => $product_id_to_delete), array('%d') ); if ($deleted) { $message = 'Product deleted successfully!'; $message_type = 'success'; // Redirect after delete to clear URL parameters wp_redirect(remove_query_arg(array('action', 'id', '_wpnonce'))); exit; } else { $message = 'Error deleting product.'; $message_type = 'error'; } } } // --- Handle Edit Product Action (Prepare form) --- if (isset($_GET['action']) && $_GET['action'] === 'edit_product' && isset($_GET['id'])) { $product_id_to_edit = absint($_GET['id']); if ($product_id_to_edit) { $editing_product = $wpdb->get_row( // Make sure to select the 'unit' column if it exists $wpdb->prepare("SELECT * FROM $product_table_name WHERE id = %d", $product_id_to_edit), ARRAY_A ); if (!$editing_product) { $message = 'Product not found for editing.'; $message_type = 'error'; } } } // --- Handle Add/Update Product Form Submission --- // Use a nonce for security if (isset($_POST['save_product']) && isset($_POST['_wpnonce_product_form']) && wp_verify_nonce($_POST['_wpnonce_product_form'], 'save_product_action')) { // Sanitize and validate input data $product_name = isset($_POST['product_name']) ? sanitize_text_field($_POST['product_name']) : ''; $product_category = isset($_POST['product_category']) ? sanitize_text_field($_POST['product_category']) : ''; $unit = isset($_POST['unit']) ? sanitize_text_field($_POST['unit']) : ''; // Changed from volume_unit $buying_price = isset($_POST['buying_price']) ? preg_replace('/[^0-9.]/', '', $_POST['buying_price']) : '0'; // Allow only numbers and dot $selling_price = isset($_POST['selling_price']) ? preg_replace('/[^0-9.]/', '', $_POST['selling_price']) : '0'; // Allow only numbers and dot $quantity_submitted = isset($_POST['quantity_input']) ? absint($_POST['quantity_input']) : 0; // Use new name 'quantity_input' $edit_product_id = isset($_POST['edit_product_id']) ? absint($_POST['edit_product_id']) : 0; $product_image_url = isset($_POST['old_image_url']) ? esc_url_raw($_POST['old_image_url']) : ''; // Keep old image if not new upload // --- Image Upload Handling --- if (isset($_FILES['product_image']) && $_FILES['product_image']['error'] === UPLOAD_ERR_OK) { $file = $_FILES['product_image']; // Use WordPress functions for handling uploads securely if (!function_exists('wp_handle_upload')) { require_once(ABSPATH . 'wp-admin/includes/file.php'); } $upload_overrides = array('test_form' => false); // Important for security // Specify target directory within uploads $movefile = wp_handle_upload($file, $upload_overrides, current_time('mysql')); if ($movefile && !isset($movefile['error'])) { // Success! $movefile contains 'url', 'file' (path), 'type' $product_image_url = $movefile['url']; // Optional: Delete old image if updating and upload is successful if ($edit_product_id && isset($_POST['old_image_url']) && $_POST['old_image_url'] !== $product_image_url) { $old_image_path = str_replace($upload_url, $upload_dir, esc_url_raw($_POST['old_image_url'])); if (file_exists($old_image_path)) { @unlink($old_image_path); } } } else { // $movefile['error'] contains the error message $message = 'Image upload error: ' . esc_html($movefile['error']); $message_type = 'error'; } } elseif (isset($_FILES['product_image']) && $_FILES['product_image']['error'] !== UPLOAD_ERR_NO_FILE) { // Handle other upload errors $message = 'Image upload error code: ' . $_FILES['product_image']['error']; $message_type = 'error'; } // --- End Image Upload Handling --- // Proceed only if no upload error occurred or no file was uploaded if ($message_type !== 'error') { // Added check for unit (optional, depends if it's required) if (!empty($product_name) && !empty($product_category) && is_numeric($buying_price) && is_numeric($selling_price)) { $product_data = array( 'image_url' => $product_image_url, 'name' => $product_name, 'category' => $product_category, 'unit' => $unit, // Changed from volume_unit 'buying_price' => (float)$buying_price, // Store as float 'selling_price' => (float)$selling_price, // Store as float // 'in_stock' will be handled below based on add/edit 'updated_at' => current_time('mysql') // Always update 'updated_at' ); // Base format array (excluding in_stock and created_at for now) $data_format = array('%s', '%s', '%s', '%s', '%f', '%f', '%s'); // image_url, name, category, unit, buying_price, selling_price, updated_at if ($edit_product_id) { // --- UPDATE existing product --- // Fetch current stock $current_stock = $wpdb->get_var( $wpdb->prepare("SELECT in_stock FROM $product_table_name WHERE id = %d", $edit_product_id) ); if ($current_stock === null) { $message = 'Error: Could not find product to update stock.'; $message_type = 'error'; } else { // Calculate new stock: Add submitted quantity to current stock $new_stock_value = absint($current_stock) + $quantity_submitted; $product_data['in_stock'] = $new_stock_value; $data_format[] = '%d'; // Add format for in_stock $updated = $wpdb->update( $product_table_name, $product_data, array('id' => $edit_product_id), // WHERE clause $data_format, // Format for values being updated array('%d') // Format for WHERE clause ); if ($updated !== false) { $message = 'Product updated successfully!'; $message_type = 'success'; // Clear editing state after successful update $editing_product = null; // Optional: Redirect to clear form and prevent resubmission // wp_redirect(remove_query_arg(array('action', 'id'))); exit; } else { $message = 'Error updating product. ' . $wpdb->last_error; $message_type = 'error'; } } } else { // --- INSERT new product --- $product_data['in_stock'] = $quantity_submitted; // Initial stock is the submitted quantity $product_data['created_at'] = current_time('mysql'); $data_format[] = '%d'; // Add format for in_stock $data_format[] = '%s'; // Add format for created_at $inserted = $wpdb->insert( $product_table_name, $product_data, $data_format ); if ($inserted) { $message = 'Product added successfully!'; $message_type = 'success'; // Optional: Redirect or clear form fields } else { $message = 'Error adding product. ' . $wpdb->last_error; $message_type = 'error'; } } } else { $message = 'Please fill in all required fields with valid data.'; $message_type = 'error'; } } // End check for upload error } elseif (isset($_POST['save_product'])) { // Nonce check failed $message = 'Security check failed. Please try again.'; $message_type = 'error'; } // --- Fetch Products and Categories for Display --- // Base SQL query $sql = "SELECT id, image_url, name, category, unit, in_stock, buying_price, selling_price, created_at, updated_at FROM $product_table_name"; $where = ''; // Get the search term from the URL query parameter $search_term = isset($_GET['product_search']) ? sanitize_text_field(wp_unslash($_GET['product_search'])) : ''; // Add search condition if search term is present if (!empty($search_term)) { // Prepare the search term for a LIKE query $search_like = '%' . $wpdb->esc_like($search_term) . '%'; $where = $wpdb->prepare( " WHERE name LIKE %s OR category LIKE %s OR unit LIKE %s", $search_like, $search_like, $search_like ); } $order_by = " ORDER BY name ASC"; // Combine the SQL parts $products_sql = $sql . $where . $order_by; // Execute the query $products = $wpdb->get_results($products_sql, ARRAY_A); $categories = $wpdb->get_results("SELECT name FROM $category_table_name ORDER BY name ASC", ARRAY_A); ?> Product Management

Product Name: Category: Unit: Product Image:

Current image shown. Upload a new file to replace it. Buying Price: Selling Price: Current Stock: . Enter amount to add.

Cancel Edit

Product List

'edit_product', 'id' => $product['id']], get_permalink()); $delete_url = add_query_arg([ 'action' => 'delete_product', 'id' => $product['id'], '_wpnonce' => wp_create_nonce('delete_product_' . $product['id']) ], get_permalink()); ?>

No.	Image	Product Name	Category	Unit	In-Stock	Buying Price	Selling Price	Date Created	Date Updated	Action

	No Image									Edit Delete