\d+)', [
'methods' => 'DELETE',
'permission_callback' => function () { return current_user_can('manage_options'); },
'callback' => function (WP_REST_Request $request) {
global $wpdb;
$id = (int) $request['id'];
$table_name = $wpdb->prefix . 'product_machine_truck_sizes';
$result = $wpdb->delete($table_name, ['id' => $id]);
if ($result === false) {
return new WP_REST_Response(['success' => false, 'data' => ['message' => 'Failed to delete truck size: ' . $wpdb->last_error]], 500);
}
if ($result === 0) {
return new WP_REST_Response(['success' => false, 'data' => ['message' => 'Truck size not found']], 404);
}
return new WP_REST_Response(['success' => true, 'data' => ['message' => 'Truck size deleted']], 200);
}
]);
// Debug endpoint to initialize truck sizes table
register_rest_route('product-machine/v1', '/truck-sizes-debug', [
'methods' => 'GET',
'permission_callback' => function () { return current_user_can('manage_options'); },
'callback' => function (WP_REST_Request $request) {
$conn = pm_get_external_db_connection();
if (!$conn) {
return new WP_REST_Response(['success' => false, 'data' => ['message' => 'Database connection failed']], 500);
}
// Check if table exists
$result = $conn->query("SHOW TABLES LIKE 'truck_sizes'");
$table_exists = $result && $result->num_rows > 0;
if (!$table_exists) {
// Create table
product_machine_create_truck_sizes_table();
$message = 'Table created and sample data populated';
} else {
// Check row count
$count_result = $conn->query("SELECT COUNT(*) as count FROM truck_sizes");
$row_count = $count_result ? $count_result->fetch_assoc()['count'] : 0;
if ($row_count == 0) {
product_machine_populate_sample_truck_sizes();
$message = 'Table exists but was empty - sample data populated';
} else {
$message = 'Table exists with ' . $row_count . ' rows';
}
}
$conn->close();
return new WP_REST_Response(['success' => true, 'data' => ['message' => $message, 'table_exists' => $table_exists]], 200);
}
]);
});
// Extra guard: dequeue problematic third-party script on our admin pages
add_action('admin_enqueue_scripts', function ($hook) {
$pm_pages = [
'toplevel_page_product-machine',
'product-machine_page_product-machine-brands',
'product-machine_page_product-machine-unpack-words',
'product-machine_page_product-machine-manage-products',
'product-machine_page_product-machine-truck-sizes'
];
if (!in_array($hook, $pm_pages)) { return; }
global $wp_scripts;
if (!$wp_scripts) { return; }
foreach ((array) $wp_scripts->queue as $handle) {
$reg = $wp_scripts->registered[$handle] ?? null;
if (!$reg) { continue; }
$src = (string) ($reg->src ?? '');
if (strpos($src, 'wf_common') !== false) {
wp_dequeue_script($handle);
wp_deregister_script($handle);
error_log('product-machine: dequeued script handle ' . $handle . ' (wf_common*.js) on ' . $hook);
}
}
}, 1000);
// Define the function if needed in `product-machine.php`
function product_machine_unpack_words_page()
{
if (!current_user_can('manage_options')) {
return;
}
include plugin_dir_path(__FILE__) . 'templates/product-machine-unpack-words.php';
}
// Function to get unpacking words from the database
function get_unpacking_words()
{
// Connect to the external database
$db = pm_get_external_db_connection();
if (!$db) {
return [];
}
$result = $db->query("SELECT * FROM product_machine_unpack_words");
if (!$result) {
$db->close();
return [];
}
$unpacking_words = [];
while ($row = $result->fetch_assoc()) {
$unpacking_words[] = $row;
}
$db->close();
return $unpacking_words;
}
add_action('init', 'register_brand_taxonomy');
function register_brand_taxonomy()
{
$attribute_slug = 'brand-name';
$attribute_label = 'Brand';
if (!taxonomy_exists($attribute_slug)) {
register_taxonomy(
$attribute_slug,
apply_filters('woocommerce_taxonomy_objects_' . $attribute_slug, ['product']),
apply_filters('woocommerce_taxonomy_args_' . $attribute_slug, [
'labels' => ['name' => $attribute_label],
'hierarchical' => true,
'show_ui' => false,
'query_var' => true,
'rewrite' => false,
])
);
}
}
// Register custom attribute taxonomies for 'wheel-diameter' and 'durometer'
add_action('init', 'register_custom_attributes_taxonomy');
function register_custom_attributes_taxonomy()
{
$attributes = [
['name' => 'wheel-diameter', 'label' => 'Wheel Diameter'],
['name' => 'durometer', 'label' => 'Durometer']
];
foreach ($attributes as $attribute) {
$attribute_taxonomy = wc_attribute_taxonomy_name($attribute['name']);
// Check if taxonomy is already registered
if (!taxonomy_exists($attribute_taxonomy)) {
register_taxonomy(
$attribute_taxonomy,
apply_filters('woocommerce_taxonomy_objects_' . $attribute_taxonomy, ['product']),
apply_filters('woocommerce_taxonomy_args_' . $attribute_taxonomy, [
'labels' => [
'name' => $attribute['label'],
],
'hierarchical' => true,
'show_ui' => false,
'query_var' => true,
'rewrite' => false,
])
);
}
}
}
// Function to get pebs_cat_margin from the database
function get_pebs_cat_margin($pebs_cat_code)
{
static $margin_cache = [];
if (array_key_exists($pebs_cat_code, $margin_cache)) {
return $margin_cache[$pebs_cat_code];
}
// First, try to read margin from the in-plugin Category Reference option
$cats = get_option('product_machine_category_ref', []);
if (is_array($cats) && !empty($cats)) {
foreach ($cats as $c) {
if (isset($c['code']) && strtoupper(trim($c['code'])) === strtoupper(trim($pebs_cat_code))) {
// Expect 'margin' as percent (e.g., 50 = 50%). Convert to multiplier.
$m = isset($c['margin']) ? floatval($c['margin']) : null;
if ($m !== null && $m !== '') {
$mult = 1.0 + ($m / 100.0);
$margin_cache[$pebs_cat_code] = $mult;
return $margin_cache[$pebs_cat_code];
}
}
}
}
// Fallback: connect to the external database (legacy source)
$db = pm_get_external_db_connection();
if (!$db) {
$margin_cache[$pebs_cat_code] = false;
return false;
}
// Prepare and execute the query
$stmt = $db->prepare("SELECT pebs_cat_margin FROM product_machine WHERE pebs_cat_code = ?");
$stmt->bind_param('s', $pebs_cat_code);
$stmt->execute();
$stmt->bind_result($pebs_cat_margin);
$stmt->fetch();
$stmt->close();
$db->close();
// Normalize legacy DB value: if it's a reasonable percent (1..100) treat as percent, if it's a multiplier (<1 or >1 with decimals) use as-is
if ($pebs_cat_margin === null || $pebs_cat_margin === '') {
$margin_cache[$pebs_cat_code] = false;
return false;
}
$val = floatval($pebs_cat_margin);
if ($val > 0 && $val <= 100 && intval($val) == $val) {
// integer percent like 50 -> 1.5
$mult = 1.0 + ($val / 100.0);
} elseif ($val > 0 && $val < 1.0) {
// already a multiplier like 0.5 (unlikely) — treat as multiplier
$mult = $val;
} elseif ($val > 1.0 && $val < 10.0) {
// could be multiplier like 1.5 or percent expressed as 150 (unlikely); assume multiplier
$mult = $val;
} else {
// Fallback: treat as false
$margin_cache[$pebs_cat_code] = false;
return false;
}
$margin_cache[$pebs_cat_code] = $mult;
return $margin_cache[$pebs_cat_code];
}
function map_raw_data_to_wc_csv_fields($product_data)
{
return [
'ID' => '',
'Type' => 'simple',
'SKU' => $product_data['SKU'] ?? '',
'Name' => $product_data['Name'] ?? '',
'Published' => $product_data['Published'] ?? '1',
'Is featured?' => $product_data['Is_featured'] ?? '0',
'Visibility in catalog' => $product_data['Visibility_in_catalog'] ?? 'visible',
'Short description' => $product_data['Short_description'] ?? '',
'Description' => $product_data['Description'] ?? '',
'Tax status' => $product_data['Tax_status'] ?? 'taxable',
'In stock?' => '1',
'Stock' => $product_data['Stock'] ?? '0',
'Regular price' => $product_data['Regular_price'] ?? '',
'Categories' => $product_data['Categories'] ?? '',
'Weight (lbs)' => $product_data['Weight_lbs'] ?? '',
'Width (in)' => $product_data['Width_in'] ?? '',
// Add other fields as required by WooCommerce...
];
}
// add_action('admin_enqueue_scripts', 'product_machine_admin_scripts');
function pm_test_db_connection()
{
$db = pm_get_external_db_connection();
if (!$db) {
echo 'Database connection error: ' . mysqli_connect_error();
} else {
echo 'Database connection successful!';
$db->close();
}
die(); // Stop further execution
}
function product_machine_import_data()
{
if (empty($_POST['raw-data'])) {
echo 'Please provide the raw data.
Warnings:
' . implode('
', array_map('esc_html', $pm_errors)) . '
Successfully imported ' . $success_count . ' products.
' . implode('
', $errors) . '
Product Machine