Meals28 โ Variable Products (Final): WooCommerce must be active for this plugin to work.
'; } ); return; } m28_final_setup(); } function m28_final_setup() { if ( defined( 'M28_FINAL_LOADED' ) ) return; define( 'M28_FINAL_LOADED', true ); if ( ! defined( 'M28_FINAL_PRODUCT_IDS' ) ) { define( 'M28_FINAL_PRODUCT_IDS', array(91, 300, 306)); } if ( ! defined( 'M28_FINAL_VARIATION_MAP' ) ) define( 'M28_FINAL_VARIATION_MAP', serialize(array( 92 => 28, // Breakfast 3 days 93 => 3, // Breakfast 28 days 321 => 3, // Lunch 3 days 320 => 28, // Lunch 28 days 307 => 3, // Dinner 3 days 308 => 28 // Dinner 28 days )) ); if ( ! defined( 'M28_FINAL_NONCE' ) ) define( 'M28_FINAL_NONCE', 'm28_final_nonce' ); register_activation_hook( __FILE__, 'm28_final_activate' ); function m28_final_activate() { global $wpdb; $charset_collate = $wpdb->get_charset_collate(); $table1 = $wpdb->prefix . 'm28_orders_variable_items'; $table2 = $wpdb->prefix . 'm28_variable_item_dates'; $sql1 = "CREATE TABLE IF NOT EXISTS $table1 ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, order_id BIGINT UNSIGNED NOT NULL, order_item_id BIGINT UNSIGNED NOT NULL, product_id BIGINT UNSIGNED NOT NULL, variation_id BIGINT UNSIGNED DEFAULT NULL, purchase_date DATETIME NOT NULL, start_date DATE NOT NULL, purchased_days INT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY (user_id), KEY (order_id), KEY (order_item_id) ) $charset_collate;"; $sql2 = "CREATE TABLE IF NOT EXISTS $table2 ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, variable_item_id BIGINT UNSIGNED NOT NULL, delivery_date DATE NOT NULL, menu_key VARCHAR(191) DEFAULT NULL, status ENUM('pending','delivered','skipped') NOT NULL DEFAULT 'pending', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY (variable_item_id, delivery_date) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql1 ); dbDelta( $sql2 ); } // Helper: variation map function m28_final_get_variation_days_map() { $map = @unserialize( M28_FINAL_VARIATION_MAP ); if ( ! is_array( $map ) ) $map = array(); return $map; } // Order hooks add_action( 'woocommerce_order_status_processing', 'm28_final_create_schedule', 20 ); add_action( 'woocommerce_order_status_completed', 'm28_final_create_schedule', 20 ); // Helper: infer purchased days from order item function m28_final_get_purchased_days_from_item( WC_Order_Item_Product $item ) { // 1) Try old variation ID map as a fallback (if it happens to be correct) $variation_id = $item->get_variation_id(); $map = m28_final_get_variation_days_map(); if ( $variation_id && isset( $map[ $variation_id ] ) ) { return (int) $map[ $variation_id ]; } // 2) Try to read from item name, e.g. "Breakfast - 3 Days" or "Lunch - 28 Days @ 20% OFF" $label = strtolower( $item->get_name() ); if ( preg_match( '/(\d+)\s*day/', $label, $m ) ) { return (int) $m[1]; } // 3) Optionally, look into variation attributes text as backup $attrs = $item->get_formatted_meta_data( '' ); if ( ! empty( $attrs ) ) { $attr_text = strtolower( wc_implode_html_attributes( array_map( function( $meta ) { return $meta->display_value; }, $attrs ) ) ); if ( preg_match( '/(\d+)\s*day/', $attr_text, $m2 ) ) { return (int) $m2[1]; } } // If nothing matched, treat as non-package return 0; } function m28_final_create_schedule( $order_id ) { if ( ! $order_id ) return; $order = wc_get_order( $order_id ); if ( ! $order ) return; $user_id = $order->get_user_id() ?: 0; $order_date_obj = $order->get_date_created(); $order_date_str = $order_date_obj ? $order_date_obj->date_i18n( 'Y-m-d H:i:s' ) : current_time( 'mysql' ); $start_date = date_i18n( 'Y-m-d', strtotime( date_i18n( 'Y-m-d', strtotime( $order_date_str ) ) . ' +1 day' ) ); $days_map = m28_final_get_variation_days_map(); global $wpdb; $table_items = $wpdb->prefix . 'm28_orders_variable_items'; $table_dates = $wpdb->prefix . 'm28_variable_item_dates'; foreach ( $order->get_items() as $item_id => $item ) { if ( ! $item instanceof WC_Order_Item_Product ) { continue; } $product_id = $item->get_product_id(); // ๐ NEW: Detect days from item instead of hard-coded variation IDs $purchased_days = m28_final_get_purchased_days_from_item( $item ); // If this order line doesn't look like a days-based package, skip if ( $purchased_days <= 0 ) { continue; } // (Optional) If you still want to restrict to some product IDs, uncomment: // if ( ! in_array( $product_id, M28_FINAL_PRODUCT_IDS ) ) { // continue; // } // Avoid duplicate schedule for same order item $exists = $wpdb->get_var( $wpdb->prepare( "SELECT id FROM $table_items WHERE order_item_id = %d", $item_id ) ); if ( $exists ) { continue; } // Insert parent package row $wpdb->insert( $table_items, array( 'user_id' => $user_id, 'order_id' => $order_id, 'order_item_id' => $item_id, 'product_id' => $product_id, 'variation_id' => $item->get_variation_id(), 'purchase_date' => $order_date_str, 'start_date' => $start_date, 'purchased_days'=> $purchased_days, ), array( '%d','%d','%d','%d','%d','%s','%s','%d' ) ); $variable_item_id = $wpdb->insert_id; if ( ! $variable_item_id ) { continue; } // Create day-wise schedule for ( $i = 0; $i < $purchased_days; $i++ ) { $dd = date_i18n( 'Y-m-d', strtotime( $start_date . " +{$i} days" ) ); $status = ( strtotime( $dd ) < strtotime( date_i18n( 'Y-m-d' ) ) ) ? 'delivered' : 'pending'; $wpdb->insert( $table_dates, array( 'variable_item_id' => $variable_item_id, 'delivery_date' => $dd, 'menu_key' => $dd, 'status' => $status, ), array( '%d','%s','%s','%s' ) ); } } } // Account endpoint add_action( 'init', 'm28_final_add_endpoint' ); function m28_final_add_endpoint() { add_rewrite_endpoint( 'variable-products', EP_PAGES ); } add_filter( 'query_vars', 'm28_final_query_vars', 0 ); function m28_final_query_vars( $vars ) { $vars[] = 'variable-products'; return $vars; } add_filter( 'woocommerce_account_menu_items', 'm28_final_account_menu_items', 99 ); function m28_final_account_menu_items( $items ) { $new_items = array(); foreach ( $items as $key => $label ) { $new_items[ $key ] = $label; if ( $key === 'dashboard' ) $new_items['variable-products'] = 'Meals Package'; } if ( ! isset( $new_items['variable-products'] ) ) $new_items['variable-products'] = 'Variable Products'; return $new_items; } function m28_final_account_endpoint() { if ( ! is_user_logged_in() ) { echo 'Please log in to view your variable products.
'; return; } $user_id = get_current_user_id(); global $wpdb; $table_items = $wpdb->prefix . 'm28_orders_variable_items'; $table_dates = $wpdb->prefix . 'm28_variable_item_dates'; $items = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_items WHERE user_id = %d ORDER BY created_at DESC", $user_id ) ); echo 'You have not purchased any variable products yet.
'; return; } echo '| Product | Purchased On | Plan | Remaining Days | Manage |
|---|---|---|---|---|
| ' . $product_name . ' | ' . esc_html( date_i18n( get_option('date_format'), strtotime( $it->purchase_date ) ) ) . ' | ' . esc_html( $plan ) . ' | ' . intval( $remaining ) . ' | Manage |
Please log in.
'; return; } $user_id = get_current_user_id(); global $wpdb; $table_items = $wpdb->prefix . 'm28_orders_variable_items'; $table_dates = $wpdb->prefix . 'm28_variable_item_dates'; $item = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $table_items WHERE id = %d", $item_id ) ); if ( ! $item || intval( $item->user_id ) !== $user_id ) { echo 'Invalid item or permission denied
'; return; } $dates = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_dates WHERE variable_item_id = %d ORDER BY delivery_date ASC", $item_id ) ); echo 'Plan: ' . intval( $item->purchased_days ) . ' days โ Start: ' . esc_html( date_i18n( get_option("date_format"), strtotime( $item->start_date ) ) ) . '
'; echo 'No scheduled dates found.
'; } else { echo '| Date | Menu | Status | Action |
|---|---|---|---|
| ' . $date_display . ' | ' . $menu_html . ' | ' . $status_label . ' | ' . $action_html . ' |