/** * Automatic Set all Product Categories as Compare Categories * */ public function automatic_add_compare_categories() { $terms = get_terms("product_cat", array('hide_empty' => 0)); if (count($terms) > 0) { foreach ($terms as $category_product) { $check_existed = WC_Compare_Categories_Data::get_count("category_name='" . trim(addslashes($category_product->name)) . "'"); if ($check_existed < 1) { WC_Compare_Categories_Data::insert_row(array('category_name' => trim(addslashes($category_product->name)))); } } } }
public static function init_categories_actions() { global $wpdb; $cat_msg = ''; if (isset($_REQUEST['bt_save_cat'])) { $category_name = trim(strip_tags(addslashes($_REQUEST['category_name']))); if (isset($_REQUEST['category_id']) && $_REQUEST['category_id'] > 0) { $old_data = WC_Compare_Categories_Data::get_row($_REQUEST['category_id']); $count_category_name = WC_Compare_Categories_Data::get_count("category_name = '" . $category_name . "' AND id != '" . $_REQUEST['category_id'] . "'"); if ($category_name != '' && $count_category_name == 0) { $result = WC_Compare_Categories_Data::update_row($_REQUEST); $wpdb->query('UPDATE ' . $wpdb->prefix . 'postmeta SET meta_value="' . $category_name . '" WHERE meta_value="' . $old_data->category_name . '" AND meta_key="_wpsc_compare_category_name" '); $cat_msg = '<div class="updated below-h2" id="result_msg"><p>' . __('Compare Category Successfully edited', 'woo_cp') . '.</p></div>'; } else { $cat_msg = '<div class="error below-h2" id="result_msg"><p>' . __('Nothing edited! You already have a Compare Category with that name. Use unique names to edit each Compare Category.', 'woo_cp') . '</p></div>'; } } else { $count_category_name = WC_Compare_Categories_Data::get_count("category_name = '" . $category_name . "'"); if ($category_name != '' && $count_category_name == 0) { $category_id = WC_Compare_Categories_Data::insert_row($_REQUEST); if ($category_id > 0) { $cat_msg = '<div class="updated below-h2" id="result_msg"><p>' . __('Compare Category Successfully created', 'woo_cp') . '.</p></div>'; } else { $cat_msg = '<div class="error below-h2" id="result_msg"><p>' . __('Compare Category Error created', 'woo_cp') . '.</p></div>'; } } else { $cat_msg = '<div class="error below-h2" id="result_msg"><p>' . __('Nothing created! You already have a Compare Category with that name. Use unique names to create each Compare Category.', 'woo_cp') . '</p></div>'; } } } if (isset($_REQUEST['act']) && $_REQUEST['act'] == 'cat-delete') { $category_id = trim($_REQUEST['category_id']); WC_Compare_Categories_Data::delete_row($category_id); WC_Compare_Categories_Fields_Data::delete_row("cat_id='" . $category_id . "'"); $cat_msg = '<div class="updated below-h2" id="result_msg"><p>' . __('Compare Category deleted', 'woo_cp') . '.</p></div>'; } return $cat_msg; }
public static function auto_create_compare_category($term_id) { $term = get_term($term_id, 'product_cat'); $check_existed = WC_Compare_Categories_Data::get_count("category_name='" . trim($term->name) . "'"); if ($check_existed < 1) { WC_Compare_Categories_Data::insert_row(array('category_name' => trim(addslashes($term->name)))); } }