Server IP : 85.214.239.14 / Your IP : 3.145.80.247 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/3/root/var/www/wordpress/wp-content/plugins/bug-library/ |
Upload File : |
<?php /* Plugin Name: Bug Library Plugin URI: https://ylefebvre.github.io/wordpress-plugins/bug-library/ Description: Display bug manager on pages with a variety of options Version: 2.1.4 Author: Yannick Lefebvre Author URI: http://ylefebvre.github.io/ Text Domain: bug-library A plugin for the blogging MySQL/PHP-based WordPress. Copyright 2024 Yannick Lefebvre SVG Plugin icon by Free Preloaders (https://freeicons.io/life-style-and-business/eggbirth-cancel-bug-icon-5812) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. You can also view a copy of the HTML version of the GNU General Public License at http://www.gnu.org/copyleft/gpl.html I, Yannick Lefebvre, can be contacted via e-mail at ylefebvre@gmail.com */ global $wpdb; $pagehooktop = ""; $pagehookstylesheet = ""; $pagehookinstructions = ""; /*********************************** Bug Library Class *****************************************************************************/ class bug_library_plugin { //constructor of class, PHP4 compatible construction for backward compatibility function __construct() { $newoptions = get_option( 'BugLibraryGeneral', "" ); if ( $newoptions == "" ) { $this->bl_reset_gen_settings( 'return_and_set' ); } // Functions to be called when plugin is activated and deactivated register_activation_hook( __FILE__, array( $this, 'bl_install' ) ); register_deactivation_hook( __FILE__, array( $this, 'bl_uninstall' ) ); //add filter for WordPress 2.8 changed backend box system ! add_filter( 'screen_layout_columns', array( $this, 'on_screen_layout_columns' ), 10, 2 ); //register callback for admin menu setup add_action( 'admin_menu', array( $this, 'on_admin_menu' ) ); add_action( 'admin_init', array( $this, 'admin_init' ) ); //register the callback been used if options of page been submitted and needs to be processed add_action( 'admin_post_save_bug_library_general', array( $this, 'on_save_changes_general' ) ); add_action( 'admin_post_save_bug_library_stylesheet', array( $this, 'on_save_changes_stylesheet' ) ); // Add short codes add_shortcode( 'bug-library', array( $this, 'bug_library_func' ) ); // Function to print information in page header when plugin present add_action( 'wp_head', array( $this, 'bl_page_header' ) ); add_action( 'admin_enqueue_scripts', array( $this, 'bl_admin_header' ) ); add_action( 'init', array( $this, 'my_custom_taxonomies' ), 0 ); add_action( 'init', array( $this, 'create_bug_post_type' ) ); add_action( 'manage_posts_custom_column', array( $this, 'bugs_populate_columns' ) ); add_filter( 'manage_edit-bug-library-bugs_columns', array( $this, 'bugs_columns_list' ) ); add_filter( 'manage_edit-bug-library-types_columns', array( $this, 'bugs_types_custom_column_header' ), 10); add_filter( 'manage_bug-library-types_custom_column', array( $this, 'bugs_add_types_id' ), 10, 3 ); add_filter( 'manage_edit-bug-library-products_columns', array( $this, 'bugs_products_custom_column_header' ), 10); add_filter( 'manage_bug-library-products_custom_column', array( $this, 'bugs_add_products_id' ), 10, 3 ); add_filter( 'manage_edit-bug-library-status_columns', array( $this, 'bugs_status_custom_column_header' ), 10); add_filter( 'manage_bug-library-status_custom_column', array( $this, 'bugs_add_status_id' ), 10, 3 ); add_filter( 'manage_edit-bug-library-priority_columns', array( $this, 'bugs_priority_custom_column_header' ), 10); add_filter( 'manage_bug-library-priority_custom_column', array( $this, 'bugs_add_priority_id' ), 10, 3 ); add_action( 'restrict_manage_posts', array( $this, 'restrict_listings' ) ); add_filter( 'parse_query', array( $this, 'convert_ids_to_taxonomy_term_in_query' ) ); add_action( 'save_post', array( $this, 'add_bug_field' ), 10, 2 ); add_action( 'save_post', array( $this, 'save_quick_edit_data' ), 10, 2 ); add_action( 'delete_post', array( $this, 'delete_bug_field' ) ); add_filter( 'wp_insert_post_data', array( $this, 'filter_post_data' ), '99', 2 ); add_action( 'template_redirect', array( $this, 'bl_template_redirect' ) ); // Function to determine if Bug Library is used on a page before printing headers add_filter( 'the_posts', array( $this, 'conditionally_add_scripts_and_styles' ) ); // Add quick Edit boxes add_action( 'quick_edit_custom_box', array( $this, 'quick_edit_add' ), 10, 2); // Javascript to change 'defaults' add_action( 'admin_footer', array( $this, 'quick_edit_js' ) ); add_filter( 'post_row_actions', array( $this, 'quick_edit_link' ), 10, 2 ); // Load text domain for translation of admin pages and text strings load_plugin_textdomain( 'bug-library', false, dirname( plugin_basename( __FILE__ ) ) . '/languages' ); add_filter( 'template_include', array( $this, 'bl_template_include' ) ); } /************************** Bug Library Installation Function **************************/ function bl_install() { global $wpdb; $productexist = $wpdb->get_var( "select * from " . $wpdb->get_blog_prefix() . "term_taxonomy where taxonomy = 'bug-library-products'" ); if ( empty( $productexist ) ) { $wpdb->insert( $wpdb->get_blog_prefix() . 'terms', array( 'name' => 'Default Product', 'slug' => 'default-product', 'term_group' => 0 ) ); $producttermid = $wpdb->get_var( "select term_id from " . $wpdb->get_blog_prefix() . "terms where name = 'Default Product'" ); $wpdb->insert( $wpdb->get_blog_prefix() . 'term_taxonomy', array( 'term_id' => $producttermid, 'taxonomy' => 'bug-library-products', 'description' => '', 'parent' => 0, 'count' => 0 ) ); } $typeexist = $wpdb->get_var( "select * from " . $wpdb->get_blog_prefix() . "term_taxonomy where taxonomy = 'bug-library-types'" ); if ( empty( $typeexist ) ) { $wpdb->insert( $wpdb->get_blog_prefix() . 'terms', array( 'name' => 'Default Type', 'slug' => 'default-type', 'term_group' => 0 ) ); $typetermid = $wpdb->get_var( "select term_id from " . $wpdb->get_blog_prefix() . "terms where name = 'Default Type'" ); $wpdb->insert( $wpdb->get_blog_prefix() . 'term_taxonomy', array( 'term_id' => $typetermid, 'taxonomy' => 'bug-library-types', 'description' => '', 'parent' => 0, 'count' => 0 ) ); } $statusexist = $wpdb->get_var( "select * from " . $wpdb->get_blog_prefix() . "term_taxonomy where taxonomy = 'bug-library-status'" ); if ( empty( $statusexist ) ) { $wpdb->insert( $wpdb->get_blog_prefix() . 'terms', array( 'name' => 'Default Status', 'slug' => 'default-status', 'term_group' => 0 ) ); $statustermid = $wpdb->get_var( "select term_id from " . $wpdb->get_blog_prefix() . "terms where name = 'Default Status'" ); $wpdb->insert( $wpdb->get_blog_prefix() . 'term_taxonomy', array( 'term_id' => $statustermid, 'taxonomy' => 'bug-library-status', 'description' => '', 'parent' => 0, 'count' => 0 ) ); } $priorityexist = $wpdb->get_var( "select * from " . $wpdb->get_blog_prefix() . "term_taxonomy where taxonomy = 'bug-library-priority'" ); if ( empty( $priorityexist ) ) { $wpdb->insert( $wpdb->get_blog_prefix() . 'terms', array( 'name' => 'Default Priority', 'slug' => 'default-priority', 'term_group' => 0 ) ); $prioritytermid = $wpdb->get_var( "select term_id from " . $wpdb->get_blog_prefix() . "terms where name = 'Default Priority'" ); $wpdb->insert( $wpdb->get_blog_prefix() . 'term_taxonomy', array( 'term_id' => $prioritytermid, 'taxonomy' => 'bug-library-priority', 'description' => '', 'parent' => 0, 'count' => 0 ) ); } $bugs = $wpdb->get_results( "select * from " . $wpdb->get_blog_prefix() . "posts where post_type = 'bug-library-bugs'" ); if ( $bugs ) { foreach ( $bugs as $bug ) { $priorityterms = wp_get_post_terms( $bug->ID, 'bug-library-priority' ); if ( ! $priorityterms ) { wp_set_post_terms( $bug->ID, 'Default Priority', 'bug-library-priority' ); } } } } function admin_init() { add_meta_box( 'buglibrary_edit_bug_meta_box', __( 'Bug Details', 'bug-library' ), array( $this, 'bug_library_edit_bug_details' ), 'bug-library-bugs', 'normal', 'high' ); } function my_custom_taxonomies() { register_taxonomy( 'bug-library-products', // internal name = machine-readable taxonomy name 'bug-library-bugs', // object type = post, page, link, or custom post-type array( 'hierarchical' => false, 'label' => __( 'Products', 'bug-library'), // the human-readable taxonomy name 'query_var' => true, // enable taxonomy-specific querying 'rewrite' => array( 'slug' => 'products' ), // pretty permalinks for your taxonomy? 'add_new_item' => __( 'Add New Product', 'bug-library' ), 'new_item_name' => __( 'New Product Name', 'bug-library' ), 'public' => true, 'show_ui' => true, 'show_in_menu' => false, 'show_in_nav_menus' => false, 'show_tagcloud' => false, 'show_in_quick_edit' => false, 'show_admin_column' => false, 'meta_box_cb' => array( $this, 'bug_library_products_metabox') ) ); register_taxonomy( 'bug-library-status', // internal name = machine-readable taxonomy name 'bug-library-bugs', // object type = post, page, link, or custom post-type array( 'hierarchical' => false, 'label' => __( 'Bug Status', 'bug-library' ), // the human-readable taxonomy name 'query_var' => true, // enable taxonomy-specific querying 'rewrite' => array( 'slug' => 'status' ), // pretty permalinks for your taxonomy? 'add_new_item' => __( 'Add New Status', 'bug-library' ), 'new_item_name' => __( 'New Status', 'bug-library' ), 'show_ui' => true, 'show_tagcloud' => false, 'show_in_menu' => false, 'show_in_nav_menus' => false, 'show_in_quick_edit' => false ) ); register_taxonomy( 'bug-library-types', // internal name = machine-readable taxonomy name 'bug-library-bugs', // object type = post, page, link, or custom post-type array( 'hierarchical' => false, 'label' => __( 'Types', 'bug-library' ), // the human-readable taxonomy name 'query_var' => true, // enable taxonomy-specific querying 'rewrite' => array( 'slug' => 'types' ), // pretty permalinks for your taxonomy? 'add_new_item' => __( 'Add New Type', 'bug-library' ), 'new_item_name' => __( 'New Type', 'bug-library' ), 'show_ui' => true, 'show_in_menu' => false, 'show_in_nav_menus' => false, 'show_tagcloud' => false, 'show_in_quick_edit' => false ) ); register_taxonomy( 'bug-library-priority', // internal name = machine-readable taxonomy name 'bug-library-bugs', // object type = post, page, link, or custom post-type array( 'hierarchical' => false, 'label' => __( 'Priorities', 'bug-library' ), // the human-readable taxonomy name 'query_var' => true, // enable taxonomy-specific querying 'rewrite' => array( 'slug' => 'priority' ), // pretty permalinks for your taxonomy? 'add_new_item' => __( 'Add New Priority', 'bug-library' ), 'new_item_name' => __( 'New Priority', 'bug-library' ), 'show_ui' => true, 'show_in_menu' => false, 'show_in_nav_menus' => false, 'show_tagcloud' => false, 'show_in_quick_edit' => false ) ); } function validate_css( $css ) { require_once plugin_dir_path( __FILE__ ) . '/tools/class.csstidy.php'; $csstidy = new csstidy(); $csstidy->set_cfg( 'optimise_shorthands', 2 ); $csstidy->set_cfg( 'template', 'low' ); $csstidy->set_cfg( 'discard_invalid_properties', false ); $csstidy->set_cfg( 'remove_last_;', false ); $csstidy->set_cfg( 'preserve_css', true ); $csstidy->set_cfg( 'remove_bslash', true ); $csstidy->parse( $css ); return $csstidy->print->plain(); } function bl_template_include( $template_path ) { if ( get_post_type() == 'bug-library-bugs' && is_single() ) { // checks if the file exists in the theme first, // otherwise serve the file from the plugin if ( $theme_file = locate_template( array ( 'single-link_library_links.php' ) ) ) { $template_path = $theme_file; } else { $template_path = plugin_dir_path( __FILE__ ) . 'single-bug-library-bugs.php'; } } return $template_path; } function bugs_add_types_id( $content, $column_name, $term_id ){ $content = $term_id; return $content; } function bugs_types_custom_column_header( $columns ){ $columns = array_merge( array_slice( $columns, 0, 2 ), array( 'taxonomy_id' => __( 'Type ID', 'bug-library' ) ), array_slice( $columns, 2 ) ); return $columns; } function bugs_add_products_id( $content, $column_name, $term_id ){ $content = $term_id; return $content; } function bugs_products_custom_column_header( $columns ){ $columns = array_merge( array_slice( $columns, 0, 2 ), array( 'taxonomy_id' => __( 'Product ID', 'bug-library' ) ), array_slice( $columns, 2 ) ); return $columns; } function bugs_add_status_id( $content, $column_name, $term_id ){ $content = $term_id; return $content; } function bugs_status_custom_column_header( $columns ){ $columns = array_merge( array_slice( $columns, 0, 2 ), array( 'taxonomy_id' => __( 'Status ID', 'bug-library' ) ), array_slice( $columns, 2 ) ); return $columns; } function bugs_add_priority_id( $content, $column_name, $term_id ){ $content = $term_id; return $content; } function bugs_priority_custom_column_header( $columns ){ $columns = array_merge( array_slice( $columns, 0, 2 ), array( 'taxonomy_id' => __( 'Priority ID', 'bug-library' ) ), array_slice( $columns, 2 ) ); return $columns; } function bug_library_products_metabox() { ?> <p>Set using <strong>Bug Details</strong> dialog</p> <?php } function create_bug_post_type() { $genoptions = get_option( 'BugLibraryGeneral', '' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); if ( isset( $genoptions['permalinkpageid'] ) && $genoptions['permalinkpageid'] != - 1 ) { $page = get_post( intval( $genoptions['permalinkpageid'] ) ); $slug = sanitize_text_field( $page->post_name ); } else { $slug = 'bugs'; } $menu_icon = '<?xml version="1.0" encoding="UTF-8" standalone="no"?> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path fill="black" d="M511.988 288.9c-.478 17.43-15.217 31.1-32.653 31.1H424v16c0 21.864-4.882 42.584-13.6 61.145l60.228 60.228c12.496 12.497 12.496 32.758 0 45.255-12.498 12.497-32.759 12.496-45.256 0l-54.736-54.736C345.886 467.965 314.351 480 280 480V236c0-6.627-5.373-12-12-12h-24c-6.627 0-12 5.373-12 12v244c-34.351 0-65.886-12.035-90.636-32.108l-54.736 54.736c-12.498 12.497-32.759 12.496-45.256 0-12.496-12.497-12.496-32.758 0-45.255l60.228-60.228C92.882 378.584 88 357.864 88 336v-16H32.666C15.23 320 .491 306.33.013 288.9-.484 270.816 14.028 256 32 256h56v-58.745l-46.628-46.628c-12.496-12.497-12.496-32.758 0-45.255 12.498-12.497 32.758-12.497 45.256 0L141.255 160h229.489l54.627-54.627c12.498-12.497 32.758-12.497 45.256 0 12.496 12.497 12.496 32.758 0 45.255L424 197.255V256h56c17.972 0 32.484 14.816 31.988 32.9zM257 0c-61.856 0-112 50.144-112 112h224C369 50.144 318.856 0 257 0z"/></svg>'; register_post_type( 'bug-library-bugs', array( 'labels' => array( 'name' => __( 'Bugs', 'bug-library' ), 'singular_name' => __( 'Bug', 'bug-library' ), 'add_new' => __( 'Add New', 'bug-library' ), 'add_new_item' => __( 'Add New Bug', 'bug-library' ), 'edit' => __( 'Edit', 'bug-library' ), 'edit_item' => __( 'Edit Bug', 'bug-library' ), 'new_item' => __( 'New Bug', 'bug-library' ), 'view' => __( 'View Bug', 'bug-library' ), 'view_item' => __( 'View Bug', 'bug-library' ), 'search_items' => __( 'Search Bugs', 'bug-library' ), 'not_found' => __( 'No bugs found', 'bug-library' ), 'not_found_in_trash' => __( 'No bugs found in Trash', 'bug-library' ), 'parent' => __( 'Parent Bug', 'bug-library' ), ), 'public' => true, 'menu_position' => 20, 'supports' => array( 'title', 'editor', 'comments', 'thumbnail' ), 'taxonomies' => array( '' ), 'menu_icon' => 'data:image/svg+xml;base64,' . base64_encode( $menu_icon ), 'rewrite' => array( 'slug' => $slug ), 'exclude_from_search' => $genoptions['excludesitesearch'] ) ); } function bugs_columns_list( $columns ) { $columns["bug-library-view-ID"] = __( "ID", 'bug-library' ); $columns["bug-library-view-product"] = __( "Product", 'bug-library' ); $columns["bug-library-view-status"] = __( "Status", 'bug-library' ); $columns["bug-library-view-type"] = __( "Type", 'bug-library' ); $columns["bug-library-view-priority"] = __( "Priority", 'bug-library' ); $columns["bug-library-view-assignee"] = __( "Assignee", 'bug-library' ); unset( $columns['comments'] ); return $columns; } function bugs_populate_columns( $column ) { global $post; $products = wp_get_post_terms( $post->ID, "bug-library-products" ); $status = wp_get_post_terms( $post->ID, "bug-library-status" ); $types = wp_get_post_terms( $post->ID, "bug-library-types" ); $priorities = wp_get_post_terms( $post->ID, "bug-library-priority" ); $assigneduserid = get_post_meta( $post->ID, "bug-library-assignee", true ); if ( $assigneduserid != - 1 && $assigneduserid != '' ) { $assigneedata = get_userdata( $assigneduserid ); if ( $assigneedata ) { $firstname = get_user_meta( $assigneduserid, 'first_name', true ); $lastname = get_user_meta( $assigneduserid, 'last_name', true ); if ( $firstname == "" && $lastname == "" ) { $firstname = $assigneedata->user_login; } } else { $firstname = __( "Unassigned", 'bug-library' ); $lastname = ""; } } else { $firstname = __( "Unassigned", 'bug-library' ); $lastname = ""; } if ( "bug-library-view-ID" == $column && isset( $post->ID ) ) { echo esc_html( $post->ID ); } elseif ( "bug-library-view-title" == $column && isset( $post->post_title ) ) { echo esc_html( $post->post_title ); } elseif ( "bug-library-view-product" == $column && isset( $products ) && !empty( $products ) ) { echo esc_html( $products[0]->name ); } elseif ( "bug-library-view-status" == $column && isset( $status ) && !empty( $status ) ) { echo esc_html( $status[0]->name ); } elseif ( "bug-library-view-type" == $column && isset( $types ) && !empty( $types ) ) { echo esc_html( $types[0]->name ); } elseif ( "bug-library-view-priority" == $column && isset( $priorities ) && !empty( $priorities ) ) { echo esc_html( $priorities[0]->name ); } elseif ( "bug-library-view-assignee" == $column ) { echo esc_html( $firstname . " " . $lastname ); } } function restrict_listings() { global $typenow; global $wp_query; if ( $typenow == 'bug-library-bugs' ) { $taxonomy = 'bug-library-products'; $product_taxonomy = get_taxonomy( $taxonomy ); wp_dropdown_categories( array( 'show_option_all' => __( "Show All", 'bug-library' ) . ' ' . esc_html( $product_taxonomy->label ), 'taxonomy' => $taxonomy, 'name' => 'bug-library-products', 'orderby' => 'name', 'selected' => ( isset( $wp_query->query['bug-library-products'] ) ? esc_html( $wp_query->query['bug-library-products'] ) : '' ), 'hierarchical' => true, 'depth' => 3, 'show_count' => false, // Show # listings in parens 'hide_empty' => false, // Don't show businesses w/o listings ) ); $taxonomy = 'bug-library-types'; $product_taxonomy = get_taxonomy( $taxonomy ); wp_dropdown_categories( array( 'show_option_all' => __( "Show All", 'bug-library' ) . ' ' . esc_html( $product_taxonomy->label ), 'taxonomy' => $taxonomy, 'name' => 'bug-library-types', 'orderby' => 'name', 'selected' => ( isset( $wp_query->query['bug-library-types'] ) ? esc_html( $wp_query->query['bug-library-types'] ) : '' ), 'hierarchical' => true, 'depth' => 3, 'show_count' => false, // Show # listings in parens 'hide_empty' => false, // Don't show businesses w/o listings ) ); $taxonomy = 'bug-library-status'; $product_taxonomy = get_taxonomy( $taxonomy ); wp_dropdown_categories( array( 'show_option_all' => __( "Show All", 'bug-library' ) . ' ' . esc_html( $product_taxonomy->label ), 'taxonomy' => $taxonomy, 'name' => 'bug-library-status', 'orderby' => 'name', 'selected' => ( isset( $wp_query->query['bug-library-status'] ) ? esc_html( $wp_query->query['bug-library-status'] ) : '' ), 'hierarchical' => true, 'depth' => 3, 'show_count' => false, // Show # listings in parens 'hide_empty' => false, // Don't show businesses w/o listings ) ); $taxonomy = 'bug-library-priority'; $product_taxonomy = get_taxonomy( $taxonomy ); wp_dropdown_categories( array( 'show_option_all' => __( "Show All", 'bug-library' ) . ' ' . esc_html( $product_taxonomy->label ), 'taxonomy' => $taxonomy, 'name' => 'bug-library-priority', 'orderby' => 'name', 'selected' => ( isset ( $wp_query->query['bug-library-priority'] ) ? esc_html( $wp_query->query['bug-library-priority'] ) : '' ), 'hierarchical' => true, 'depth' => 3, 'show_count' => false, // Show # listings in parens 'hide_empty' => false, // Don't show businesses w/o listings ) ); } } function quick_edit_add($column_name, $post_type) { $genoptions = get_option( 'BugLibraryGeneral', "" ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); switch ( $column_name ) { case 'bug-library-view-product': ?> <fieldset class="inline-edit-col-right"> <div class="inline-edit-col"> <label><span class="title"><?php _e( 'Product', 'bug-library' ); ?></span></label> <input type="hidden" name="bug_library_product_noncename" id="bug_library_product_noncename" value="" /> <?php $terms = get_terms( array( 'taxonomy' => 'bug-library-products','hide_empty' => false ) ); ?> <select name='bug_library_products' id='bug_library_products'> <?php foreach ( $terms as $term ) { echo "<option class='bug-library-products-option' value='" . esc_html( $term->name ) . "'>" . esc_html( $term->name ) . "</option>\n"; } ?> </select> </div> <?php break; case 'bug-library-view-status': ?> <div class="inline-edit-col"> <label><span class="title"><?php _e( 'Status', 'bug-library' ); ?></span></label> <input type="hidden" name="bug_library_status_noncename" id="bug_library_status_noncename" value="" /> <?php $terms = get_terms( array( 'taxonomy' => 'bug-library-status','hide_empty' => false ) ); ?> <select name='bug_library_status' id='bug_library_status'> <?php foreach ($terms as $term) { echo "<option class='bug-library-status-option' value='" . esc_html( $term->name ) . "'>" . esc_html( $term->name ) . "</option>\n"; } ?> </select> </div> <?php break; case 'bug-library-view-type': ?> <div class="inline-edit-col"> <label><span class="title"><?php _e( 'Type', 'bug-library' ); ?></span></label> <input type="hidden" name="bug_library_type_noncename" id="bug_library_type_noncename" value="" /> <?php $terms = get_terms( array( 'taxonomy' => 'bug-library-types','hide_empty' => false ) ); ?> <select name='bug_library_types' id='bug_library_types'> <?php foreach ($terms as $term) { echo "<option class='bug-library-types-option' value='" . esc_html( $term->name ) . "'>" . esc_html( $term->name ) . "</option>\n"; } ?> </select> </div> <?php break; case 'bug-library-view-priority': ?> <div class="inline-edit-col"> <label><span class="title"><?php _e( 'Priority', 'bug-library' ); ?></span></label> <input type="hidden" name="bug_library_priority_noncename" id="bug_library_priority_noncename" value="" /> <?php $terms = get_terms( array( 'taxonomy' => 'bug-library-priority','hide_empty' => false ) ); ?> <select name='bug_library_priority' id='bug_library_priority'> <?php foreach ($terms as $term) { echo "<option class='bug-library-priority-option' value='" . esc_html( $term->name ) . "'>" . esc_html( $term->name ) . "</option>\n"; } ?> </select> </div> <?php break; case 'bug-library-view-assignee': ?> <div class="inline-edit-col"> <label><span class="title"><?php _e( 'Assignee', 'bug-library' ); ?></span></label> <input type="hidden" name="bug_library_assignee_noncename" id="bug_library_assignee_noncename" value="" /> <?php global $wp_roles; $role_names = $wp_roles->roles; $users = array(); foreach( $role_names as $role ) { $args = array( 'role' => $role['name'] ); $new_users = get_users( $args ); if ( !empty( $new_users ) ) { foreach ( $new_users as $new_user ) { $users[$new_user->data->ID] = $new_user->data->user_login; } } if ( $role['name'] == $genoptions['rolelevel'] ) { break; } } asort( $users ); if ( $users ) { echo "<select name='bug_library_assignee' id='bug_library_assignee' style='width: 400px'>"; echo "<option value='-1'>" . __( 'Assigned', 'bug-library' ) . "</option>"; foreach ( $users as $user_ID => $user ) { $firstname = get_user_meta( $user_ID, 'first_name', true ); $lastname = get_user_meta( $user_ID, 'last_name', true ); echo "<option value='" . intval( $user_ID ) . "'>"; if ( $firstname != '' || $lastname != '' ) { echo esc_html( $firstname . " " . $lastname ); } else { echo esc_html( $user ); } echo "</option>"; } echo "</select>"; } ?> </div> </fieldset> <?php break; } } function convert_ids_to_taxonomy_term_in_query( $query ) { global $pagenow; $qv = &$query->query_vars; if ( $pagenow == 'edit.php' && isset( $qv['bug-library-products'] ) && is_numeric( $qv['bug-library-products'] ) ) { $term = get_term_by( 'id', intval( $qv['bug-library-products'] ), 'bug-library-products' ); $qv['bug-library-products'] = sanitize_text_field( $term->slug ); } if ( $pagenow == 'edit.php' && isset( $qv['bug-library-types'] ) && is_numeric( $qv['bug-library-types'] ) ) { $term = get_term_by( 'id', intval( $qv['bug-library-types'] ), 'bug-library-types' ); $qv['bug-library-types'] = sanitize_text_field( $term->slug ); } if ( $pagenow == 'edit.php' && isset( $qv['bug-library-status'] ) && is_numeric( $qv['bug-library-status'] ) ) { $term = get_term_by( 'id', intval( $qv['bug-library-status'] ), 'bug-library-status' ); $qv['bug-library-status'] = sanitize_text_field( $term->slug ); } if ( $pagenow == 'edit.php' && isset( $qv['bug-library-priority'] ) && is_numeric( $qv['bug-library-priority'] ) ) { $term = get_term_by( 'id', intval( $qv['bug-library-priority'] ), 'bug-library-priority' ); $qv['bug-library-priority'] = sanitize_text_field( $term->slug ); } } function bug_library_edit_bug_details( $bug ) { $genoptions = get_option( 'BugLibraryGeneral', "" ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); global $wpdb; $products = wp_get_post_terms( $bug->ID, "bug-library-products" ); $statuses = wp_get_post_terms( $bug->ID, "bug-library-status" ); $types = wp_get_post_terms( $bug->ID, "bug-library-types" ); $priorities = wp_get_post_terms( $bug->ID, "bug-library-priority" ); $productversion = get_post_meta( $bug->ID, "bug-library-product-version", true ); $reportername = get_post_meta( $bug->ID, "bug-library-reporter-name", true ); $reporteremail = get_post_meta( $bug->ID, "bug-library-reporter-email", true ); $resolutiondate = get_post_meta( $bug->ID, "bug-library-resolution-date", true ); $resolutionversion = get_post_meta( $bug->ID, "bug-library-resolution-version", true ); $imagepath = get_post_meta( $bug->ID, "bug-library-image-path", true ); $assigneduserid = get_post_meta( $bug->ID, "bug-library-assignee", true ); echo "<table>\n"; echo "<tr><td>" . __( 'Assigned user', 'bug-library' ) . "</td><td>\n"; global $wp_roles; $role_names = $wp_roles->roles; $users = array(); foreach( $role_names as $role ) { $args = array( 'role' => $role['name'] ); $new_users = get_users( $args ); if ( !empty( $new_users ) ) { foreach ( $new_users as $new_user ) { $users[$new_user->data->ID] = $new_user->data->user_login; } } if ( $role['name'] == $genoptions['rolelevel'] ) { break; } } asort( $users ); if ( $users ) { echo "<select name='bug-library-assignee' style='width: 400px'>"; echo "<option value='-1'>" . __( 'Unassigned', 'bug-library' ) . "</option>"; foreach ( $users as $user_ID => $user ) { $firstname = get_user_meta( $user_ID, 'first_name', true ); $lastname = get_user_meta( $user_ID, 'last_name', true ); echo "<option value='" . intval( $user_ID ) . "' " . selected( $user_ID == $assigneduserid ) . ">"; if ( $firstname != '' || $lastname != '' ) { echo esc_html( $firstname . " " . $lastname ); } else { echo esc_html( $user ); } echo "</option>"; } echo "</select>"; } echo "</td></tr>\n"; echo "\t<tr>\n"; echo "\t\t<td style='width: 150px'>" . __( 'Product', 'bug-library' ) . "</td><td>"; $productterms = get_terms( 'bug-library-products', 'orderby=name&hide_empty=0' ); if ( $productterms ) { echo "<select name='bug-library-product' style='width: 400px'>"; foreach ( $productterms as $productterm ) { echo "<option value='" . intval( $productterm->term_id ) . "' " . selected( !empty( $products ) && $products[0]->term_id == $productterm->term_id ) . ">" . esc_html( $productterm->name ) . "</option>"; } echo "</select>"; } echo "\t\t</td>\t"; echo "\t</tr>\n"; echo "\t<tr>\n"; echo "\t\t<td>" . __( 'Status', 'bug-library' ) . "</td><td>\n"; $statusterms = get_terms( 'bug-library-status', 'orderby=name&hide_empty=0' ); if ( $statusterms ) { echo "<select name='bug-library-status' style='width: 400px'>\n"; foreach ( $statusterms as $statusterm ) { $selectedterm = false; if ( !empty( $statuses ) && !empty( $statuses[0]->term_id ) ) { if ( $statuses[0]->term_id == $statusterm->term_id ) { $selectedterm = true; } } elseif ( empty( $statuses[0]->term_id ) && !empty( $genoptions['defaultuserbugstatus'] ) ) { if ( $genoptions['defaultuserbugstatus'] == $statusterm->term_id ) { $selectedterm = true; } } echo "<option value='" . intval( $statusterm->term_id ) . "' " . selected( $selectedterm ) . ">" . esc_html( $statusterm->name ) . "</option>\n"; } echo "</select>\n"; } echo "</td>\n"; echo "</tr>\n"; echo "\t<tr>\n"; echo "\t\t<td>" . __( 'Type', 'bug-library' ) . "</td><td>\n"; $typesterms = get_terms( 'bug-library-types', 'orderby=name&hide_empty=0' ); if ( $typesterms ) { echo "<select name='bug-library-types' style='width: 400px'>\n"; foreach ( $typesterms as $typesterm ) { echo "<option value='" . intval( $typesterm->term_id ) . "' " . selected( !empty( $types ) && $types[0]->term_id == $typesterm->term_id ) . ">" . esc_html( $typesterm->name ) . "</option>\n"; } echo "</select>\n"; } echo "</td>\n"; echo "</tr>\n"; echo "\t<tr>\n"; echo "\t\t<td>" . __( 'Priority', 'bug-library' ) . "</td><td>\n"; $prioritiesterms = get_terms( 'bug-library-priority', 'orderby=name&hide_empty=0' ); if ( $prioritiesterms ) { echo "<select name='bug-library-priority' style='width: 400px'>\n"; foreach ( $prioritiesterms as $priorityterm ) { $selectedterm = false; if ( !empty( $priorities ) && $priorities[0]->term_id != '' ) { if ( $priorities[0]->term_id == $priorityterm->term_id ) { $selectedterm = true; } } elseif ( empty( $priorities[0]->term_id ) && isset( $genoptions['defaultuserbugpriority'] ) ) { if ( $genoptions['defaultuserbugpriority'] == $priorityterm->term_id ) { $selectedterm = true; } } echo "<option value='" . intval( $priorityterm->term_id ) . "' " . selected( $selectedterm ) . ">" . esc_html( $priorityterm->name ) . "</option>\n"; } echo "</select>\n"; } echo "</td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td>" . __( 'Version', 'bug-library' ) . "</td><td><input type='text' name='bug-library-product-version' "; if ( $productversion != '' ) { echo "value='" . esc_html( $productversion ) . "'"; } echo " /></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td>" . __( 'Reporter Name', 'bug-library' ) . "</td><td><input type='text' size='80' name='bug-library-reporter-name' "; if ( $reportername != '' ) { echo "value='" . esc_html( $reportername ) . "'"; } echo " /></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td>" . __( 'Reporter E-mail', 'bug-library' ) . "</td><td><input type='text' size='80' name='bug-library-reporter-email' "; if ( $reporteremail != '' ) { echo "value='" . esc_html( $reporteremail ) . "'"; } echo " /></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td>" . __( 'Resolution Date', 'bug-library' ) . "</td><td><input type='text' id='bug-library-resolution-date' name='bug-library-resolution-date' "; if ( $resolutiondate != '' ) { echo "value='" . esc_html( $resolutiondate ) . "'"; } echo " /></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td>" . __( 'Resolution Version', 'bug-library' ) . "</td><td><input type='text' name='bug-library-resolution-version' "; if ( $resolutionversion != '' ) { echo "value='" . esc_html( $resolutionversion ) . "'"; } echo " /></td>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "\t<td>" . __( 'Attached File', 'bug-library' ) . "</td><td>"; if ( $imagepath != '' ) { echo "<a href='" . esc_url( $imagepath ) . "'>" . __( 'File Attachment', 'bug-library' ) . "</a>"; } else { echo __( "No file attached to this bug", 'bug-library' ); } echo "</td></tr><tr><td></td><td>" . __( 'Attach new file', 'bug-library' ) . ": <input type='file' name='attachimage' id='attachimage' />"; echo "</td>\n"; echo "</tr>\n"; echo "</table>\t"; echo "<script type='text/javascript'>\n"; echo "\tjQuery(document).ready(function() {\n"; echo "\t\tjQuery('#bug-library-resolution-date').datepicker({minDate: '+0', dateFormat: 'mm-dd-yy', showOn: 'both', constrainInput: true, buttonImage: '" . plugins_url( '/icons/calendar.png', __FILE__ ) . "'}) });\n"; echo "jQuery( 'form#post' )\n"; echo "\t.attr( 'enctype', 'multipart/form-data' )\n"; echo "\t.attr( 'encoding', 'multipart/form-data' )\n"; echo ";\n"; echo "</script>\n"; } function add_bug_field( $ID = false, $post = false ) { $post = get_post( $ID ); if ( $post->post_type = 'bug-library-bugs' ) { if ( isset( $_POST['bug-library-product'] ) ) { $productterm = get_term_by( 'id', intval( $_POST['bug-library-product'] ), 'bug-library-products' ); if ( $productterm ) { wp_set_post_terms( $post->ID, sanitize_text_field( $productterm->name ), "bug-library-products" ); } } if ( isset( $_POST['bug-library-status'] ) ) { $statusterm = get_term_by( 'id', intval( $_POST['bug-library-status'] ), 'bug-library-status' ); if ( $statusterm ) { wp_set_post_terms( $post->ID, sanitize_text_field( $statusterm->name ), "bug-library-status" ); } } if ( isset( $_POST['bug-library-types'] ) ) { $typeterm = get_term_by( 'id', intval( $_POST['bug-library-types'] ), "bug-library-types" ); if ( $typeterm ) { wp_set_post_terms( $post->ID, sanitize_text_field( $typeterm->name ), "bug-library-types" ); } } if ( isset( $_POST['bug-library-priority'] ) ) { $priorityterm = get_term_by( 'id', intval( $_POST['bug-library-priority'] ), "bug-library-priority" ); if ( $priorityterm ) { wp_set_post_terms( $post->ID, sanitize_text_field( $priorityterm->name ), "bug-library-priority" ); } } if ( isset( $_POST['bug-library-product-version'] ) && $_POST['bug-library-product-version'] != '' ) { update_post_meta( $post->ID, "bug-library-product-version", sanitize_text_field( $_POST['bug-library-product-version'] ) ); } if ( isset( $_POST['bug-library-reporter-name'] ) && $_POST['bug-library-reporter-name'] != '' ) { update_post_meta( $post->ID, "bug-library-reporter-name", sanitize_text_field( $_POST['bug-library-reporter-name'] ) ); } if ( isset( $_POST['bug-library-reporter-email'] ) && $_POST['bug-library-reporter-email'] != '' ) { update_post_meta( $post->ID, "bug-library-reporter-email", sanitize_text_field( $_POST['bug-library-reporter-email'] ) ); } if ( isset( $_POST['bug-library-resolution-date'] ) && $_POST['bug-library-resolution-date'] != '' ) { update_post_meta( $post->ID, "bug-library-resolution-date", sanitize_text_field( $_POST['bug-library-resolution-date'] ) ); } if ( isset( $_POST['bug-library-resolution-version'] ) && $_POST['bug-library-resolution-version'] != '' ) { update_post_meta( $post->ID, "bug-library-resolution-version", sanitize_text_field( $_POST['bug-library-resolution-version'] ) ); } if ( isset( $_POST['bug_library_assignee'] ) && $_POST['bug_library_assignee'] != '' ) { update_post_meta( $post->ID, "bug-library-assignee", sanitize_text_field( $_POST['bug_library_assignee'] ) ); } $uploads = wp_upload_dir(); if ( array_key_exists( 'attachimage', $_FILES ) ) { $file_extension = pathinfo( $_FILES['attachimage']['name'], PATHINFO_EXTENSION ); $target_path = $uploads['basedir'] . "/bug-library/bugimage-" . $post->ID . '.' . $file_extension; $file_path = $uploads['baseurl'] . "/bug-library/bugimage-" . $post->ID . '.' . $file_extension; if ( in_array( $file_extension, array( 'bmp', 'txt', 'png', 'jpg', 'pdf', 'jpeg' ) ) ) { if ( move_uploaded_file( $_FILES['attachimage']['tmp_name'], $target_path ) ) { update_post_meta( $post->ID, "bug-library-image-path", esc_url( $file_path ) ); } } else { unlink( $_FILES['attachimage']['tmp_name'] ); } } } } function save_quick_edit_data( $ID = false, $post = false ) { // Criteria for not saving: Auto-saves, not post_type_characters, can't edit if ( ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE ) || ( isset( $_POST['post_type'] ) && 'bug-library-bugs' != $_POST['post_type'] ) || !current_user_can( 'edit_page', $ID ) ) { return $ID; } $post = get_post( $ID ); if ( isset( $_POST['bug_library_products'] ) && ( $post->post_type != 'revision' ) ) { $bug_library_product_term = sanitize_text_field($_POST['bug_library_products']); $term = term_exists( $bug_library_product_term, 'bug-library-products'); if ( $term !== 0 && $term !== null ) { wp_set_object_terms( $ID, $bug_library_product_term, 'bug-library-products' ); } } if ( isset( $_POST['bug_library_status'] ) && ( $post->post_type != 'revision' ) ) { $bug_library_status_term = sanitize_text_field($_POST['bug_library_status']); $term = term_exists( $bug_library_status_term, 'bug-library-status'); if ( $term !== 0 && $term !== null ) { wp_set_object_terms( $ID, $bug_library_status_term, 'bug-library-status' ); } } if ( isset( $_POST['bug_library_types'] ) && ( $post->post_type != 'revision' ) ) { $bug_library_types_term = sanitize_text_field($_POST['bug_library_types']); $term = term_exists( $bug_library_types_term, 'bug-library-types'); if ( $term !== 0 && $term !== null ) { wp_set_object_terms( $ID, $bug_library_types_term, 'bug-library-types' ); } } if ( isset( $_POST['bug_library_priority'] ) && ( $post->post_type != 'revision' ) ) { $bug_library_priority_term = sanitize_text_field($_POST['bug_library_priority']); $term = term_exists( $bug_library_priority_term, 'bug-library-priority'); if ( $term !== 0 && $term !== null ) { wp_set_object_terms( $ID, $bug_library_priority_term, 'bug-library-priority' ); } } if ( isset( $_POST['bug-library-assignee'] ) && $_POST['bug-library-assignee'] != '' ) { update_post_meta( $ID, "bug-library-assignee", sanitize_text_field( $_POST['bug-library-assignee'] ) ); } } function quick_edit_js() { global $current_screen; if ( ($current_screen->id !== 'edit-bug-library-bugs') || ($current_screen->post_type !== 'bug-library-bugs') ) return; ?> <script type="text/javascript"> <!-- function set_inline_bug_library_product( widgetSetProduct, widgetSetStatus, widgetSetTypes, widgetSetPriority, widgetSetAssignee ) { // revert Quick Edit menu so that it refreshes properly inlineEditPost.revert(); var widgetInputProduct = document.getElementById('bug_library_products'); var nonceInputProduct = document.getElementById('bug_library_product_noncename'); nonceInputProduct.value = widgetSetProduct[1]; // check option manually for (i = 0; i < widgetInputProduct.options.length; i++) { if (widgetInputProduct.options[i].value == widgetSetProduct[0]) { widgetInputProduct.options[i].setAttribute("selected", "selected"); } else { widgetInputProduct.options[i].removeAttribute("selected"); } } var widgetInputStatus = document.getElementById('bug_library_status'); var nonceInputStatus = document.getElementById('bug_library_status_noncename'); nonceInputStatus.value = widgetSetStatus[1]; // check option manually for (i = 0; i < widgetInputStatus.options.length; i++) { if (widgetInputStatus.options[i].value == widgetSetStatus[0]) { widgetInputStatus.options[i].setAttribute("selected", "selected"); } else { widgetInputStatus.options[i].removeAttribute("selected"); } } var widgetInputTypes = document.getElementById('bug_library_types'); var nonceInputTypes = document.getElementById('bug_library_type_noncename'); nonceInputTypes.value = widgetSetTypes[1]; // check option manually for (i = 0; i < widgetInputTypes.options.length; i++) { if (widgetInputTypes.options[i].value == widgetSetTypes[0]) { widgetInputTypes.options[i].setAttribute("selected", "selected"); } else { widgetInputTypes.options[i].removeAttribute("selected"); } } var widgetInputPriority = document.getElementById('bug_library_priority'); var nonceInputPriority = document.getElementById('bug_library_priority_noncename'); nonceInputPriority.value = widgetSetPriority[1]; // check option manually for (i = 0; i < widgetInputPriority.options.length; i++) { if (widgetInputPriority.options[i].value == widgetSetPriority[0]) { widgetInputPriority.options[i].setAttribute("selected", "selected"); } else { widgetInputPriority.options[i].removeAttribute("selected"); } } var widgetInputAssignee = document.getElementById('bug_library_assignee'); var nonceInputAssignee = document.getElementById('bug_library_assignee_noncename'); nonceInputAssignee.value = widgetSetAssignee[1]; // check option manually for (i = 0; i < widgetInputAssignee.options.length; i++) { if (widgetInputAssignee.options[i].index == widgetSetAssignee[0]) { widgetInputAssignee.options[i].setAttribute("selected", "selected"); } else { widgetInputAssignee.options[i].removeAttribute("selected"); } } } //--> </script> <?php } function quick_edit_link($actions, $post) { global $current_screen; $post_id = ''; if ( ( isset( $current_screen ) && $current_screen->id != 'edit-bug-library-bugs' && $current_screen->post_type != 'bug-library-bugs' ) || ( isset( $_POST['screen'] ) && $_POST['screen'] != 'edit-bug-library-bugs' ) ) return $actions; if ( !empty( $post->ID ) ) { $post_id = $post->ID; } elseif ( isset( $_POST['post_ID'] ) ) { $post_id = intval( $_POST['post_ID'] ); } if ( !empty( $post_id ) ) { $bug_library_product_nonce = wp_create_nonce( 'bug_library_' . $post_id ); $bug_library_products = wp_get_post_terms( $post_id, 'bug-library-products', array( 'fields' => 'all' ) ); $bug_library_status_nonce = wp_create_nonce( 'bug_library_' . $post_id ); $bug_library_status = wp_get_post_terms( $post_id, 'bug-library-status', array( 'fields' => 'all' ) ); $bug_library_types_nonce = wp_create_nonce( 'bug_library_' . $post_id ); $bug_library_types = wp_get_post_terms( $post_id, 'bug-library-types', array( 'fields' => 'all' ) ); $bug_library_priority_nonce = wp_create_nonce( 'bug_library_' . $post_id ); $bug_library_priority = wp_get_post_terms( $post_id, 'bug-library-priority', array( 'fields' => 'all' ) ); $bug_library_assignee_nonce = wp_create_nonce( 'bug_library_' . $post_id ); $bug_library_assignee = get_post_meta( $post_id, 'bug-library-assignee', true ); $bug_library_product_string = isset( $bug_library_products[0]->name ) ? $bug_library_products[0]->name : ''; $bug_library_status_string = isset( $bug_library_status[0]->name ) ? $bug_library_status[0]->name : ''; $bug_library_type_string = isset( $bug_library_types[0]->name ) ? $bug_library_types[0]->name : ''; $bug_priority_string = isset( $bug_library_priority[0]->name ) ? $bug_library_priority[0]->name : ''; $actions['inline hide-if-no-js'] = '<a href="#" class="editinline" title="'; $actions['inline hide-if-no-js'] .= esc_attr( __( 'Edit this item inline', 'bug-library' ) ) . '" '; $actions['inline hide-if-no-js'] .= " onclick=\"var productArray = new Array('" . esc_html( $bug_library_product_string ) . "', '" . esc_html( $bug_library_product_nonce ) . "');var statusArray = new Array('" . esc_html( $bug_library_status_string ) . "', '" . esc_html( $bug_library_status_nonce ) . "');var typesArray = new Array('" . esc_html( $bug_library_type_string ) . "', '" . esc_html( $bug_library_types_nonce ) . "');var priorityArray = new Array('" . esc_html( $bug_priority_string ) . "', '" . esc_html( $bug_library_priority_nonce ) . "');var assigneeArray = new Array('" . esc_html( $bug_library_assignee ) . "', '" . esc_html( $bug_library_assignee_nonce ) . "');set_inline_bug_library_product(productArray, statusArray, typesArray, priorityArray, assigneeArray)\">"; $actions['inline hide-if-no-js'] .= __( 'Quick Edit', 'bug-library'); $actions['inline hide-if-no-js'] .= '</a>'; } return $actions; } function delete_bug_field( $bug_id ) { delete_post_meta( $bug_id, "bug-library-product-version" ); delete_post_meta( $bug_id, "bug-library-reporter-name" ); delete_post_meta( $bug_id, "bug-library-reporter-email" ); delete_post_meta( $bug_id, "bug-library-resolution-date" ); delete_post_meta( $bug_id, "bug-library-resolution-version" ); } function filter_post_data( $post, $postarr ) { $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); if ( $post['post_type'] == 'bug-library-bugs' && $genoptions['closecommentsonclosure'] ) { if ( isset( $_POST['bug-library-status'] ) ) { $statusterm = get_term_by( 'id', intval( $_POST['bug-library-status'] ), 'bug-library-status' ); if ( $statusterm ) { if ( $statusterm->name == $genoptions['bugclosedstatus'] ) { $post['comment_status'] = 'closed'; } } } } return $post; } /************************** Bug Library Uninstall Function **************************/ function bl_uninstall() { $genoptions = get_option( 'BugLibraryGeneral' ); } // Function used to set initial settings or reset them on user request function bl_reset_gen_settings( $setoptions = 'return' ) { global $wpdb; $genoptions['moderatesubmissions'] = true; $genoptions['showcaptcha'] = true; $genoptions['requirelogin'] = false; $genoptions['entriesperpage'] = 10; $genoptions['allowattach'] = false; $genoptions['defaultuserbugstatus'] = __( 'Default Status', 'bug-library' ); $genoptions['defaultuserbugpriority'] = __( 'Default Priority', 'bug-library' ); $genoptions['newbugadminnotify'] = true; $genoptions['bugnotifytitle'] = __( 'New bug added to Wordpress Bug Library: %bugtitle%', 'bug-library' ); $genoptions['permalinkpageid'] = - 1; $genoptions['firstrowheaders'] = false; $genoptions['showpriority'] = false; $genoptions['showreporter'] = false; $genoptions['rolelevel'] = 'Administrator'; $genoptions['showassignee'] = false; $genoptions['editlevel'] = 'Administrator'; $genoptions['requirename'] = false; $genoptions['requireemail'] = false; $genoptions['hideproduct'] = false; $genoptions['hideversionnumber'] = false; $genoptions['hideissuetype'] = false; $genoptions['bugclosedstatus'] = __( 'Default Status', 'bug-library' ); $genoptions['closecommentsonclosure'] = false; $genoptions['excludesitesearch'] = false; $genoptions['productemptyoption'] = false; $genoptions['issueemptyoption'] = false; $genoptions['nextbugid'] = 1; $stylesheetlocation = plugins_url( 'stylesheet.css', __FILE__ ); $genoptions['fullstylesheet'] = wp_remote_fopen( $stylesheetlocation ); if ( 'return_and_set' == $setoptions ) { update_option( 'BugLibraryGeneral', $genoptions ); } return $genoptions; } //for WordPress 2.8 we have to tell, that we support 2 columns ! function on_screen_layout_columns( $columns, $screen ) { return $columns; } function remove_querystring_var( $url, $key ) { $keypos = strpos( $url, $key ); if ( $keypos ) { $ampersandpos = strpos( $url, '&', $keypos ); $newurl = substr( $url, 0, $keypos - 1 ); if ( $ampersandpos ) { $newurl .= substr( $url, $ampersandpos ); } } else { $newurl = $url; } return $newurl; } //extend the admin menu function on_admin_menu() { //add our own option page, you can also add it to different sections or use your own one global $wpdb, $pagehooktop, $pagehookstylesheet, $pagehookinstructions; $pagehooktop = add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Bug Library General Options', 'bug-library' ), __( 'General Options', 'bug-library' ) , 'manage_options', 'bug-library-general-options', array( $this, 'on_show_page' ) ); $pagehookstylesheet = add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Bug Library - Stylesheet Editor', 'bug-library' ), __( 'Stylesheet', 'bug-library' ), 'manage_options', 'bug-library-stylesheet', array( $this, 'on_show_page' ) ); $pagehookinstructions = add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Bug Library - Instructions', 'bug-library' ), __( 'Instructions', 'bug-library' ), 'manage_options', 'bug-library-instructions', array( $this, 'on_show_page' ) ); //register callback gets call prior your own page gets rendered add_action( 'load-' . $pagehooktop, array( $this, 'on_load_page' ) ); add_action( 'load-' . $pagehookstylesheet, array( $this, 'on_load_page' ) ); add_action( 'load-' . $pagehookinstructions, array( $this, 'on_load_page' ) ); add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Products', 'bug-library' ), __( 'Products', 'bug-library'), 'read', 'edit-tags.php?taxonomy=bug-library-products&post_type=bug-library-bugs'); add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Status', 'bug-library'), __( 'Status', 'bug-library'), 'read', 'edit-tags.php?taxonomy=bug-library-status&post_type=bug-library-bugs'); add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Types', 'bug-library'), __( 'Types', 'bug-library'), 'read', 'edit-tags.php?taxonomy=bug-library-types&post_type=bug-library-bugs'); add_submenu_page( 'edit.php?post_type=bug-library-bugs', __( 'Priority', 'bug-library'), __( 'Priority', 'bug-library'), 'read', 'edit-tags.php?taxonomy=bug-library-priority&post_type=bug-library-bugs'); } //will be executed if wordpress core detects this page has to be rendered function on_load_page() { global $pagehooktop, $pagehookstylesheet, $pagehookinstructions; wp_enqueue_script( 'tiptip', plugins_url( 'tiptip/jquery.tipTip.minified.js', __FILE__ ), array( 'jquery' ), "1.0rc3" ); wp_enqueue_style( 'tiptipstyle', plugins_url( 'tiptip/tipTip.css', __FILE__ ) ); wp_enqueue_script( 'postbox' ); //add several metaboxes now, all metaboxes registered during load page can be switched off/on at "Screen Options" automatically, nothing special to do therefore add_meta_box( 'buglibrary_general_meta_box', __( 'General Settings', 'bug-library' ), array( $this, 'general_meta_box' ), $pagehooktop, 'normal', 'high' ); add_meta_box( 'buglibrary_general_newissue_meta_box', __( 'User Submission Settings', 'bug-library' ), array( $this, 'general_meta_newissue_box' ), $pagehooktop, 'normal', 'high' ); add_meta_box( 'buglibrary_general_import_meta_box', __( 'Import / Export', 'bug-library' ), array( $this, 'general_importexport_meta_box' ), $pagehooktop, 'normal', 'high' ); add_meta_box( 'buglibrary_general_save_meta_box', __( 'Save', 'bug-library' ), array( $this, 'general_save_meta_box' ), $pagehooktop, 'normal', 'high' ); add_meta_box( 'buglibrary_stylesheet_meta_box', __( 'Stylesheet', 'bug-library' ), array( $this, 'stylesheet_meta_box' ), $pagehookstylesheet, 'normal', 'high' ); add_meta_box( 'buglibrary_instructions_meta_box', __( 'Instructions', 'bug-library' ), array( $this, 'instructions_meta_box' ), $pagehookinstructions, 'normal', 'high' ); } //executed to show the plugins complete admin page function on_show_page() { //we need the global screen column value to beable to have a sidebar in WordPress 2.8 global $screen_layout_columns; // Retrieve general options $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); // If general options don't exist, create them if ( $genoptions == false ) { $this->bl_reset_gen_settings(); } // Check for current page to set some page=specific variables if ( isset( $_GET['page'] ) && $_GET['page'] == 'bug-library-general-options' ) { if ( isset( $_GET['message'] ) && $_GET['message'] == '1' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'General Settings Saved', 'bug-library' ) . ".</strong></p></div>"; } elseif ( isset( $_GET['message'] ) && $_GET['message'] == '2' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'Please create a folder called uploads under your Wordpress /wp-content/ directory with write permissions to use this functionality.', 'bug-library' ) . ".</strong></p></div>"; } elseif ( isset( $_GET['message'] ) && $_GET['message'] == '3' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'Please make sure that the /wp-content/uploads/ directory has write permissions to use this functionality.', 'bug-library' ) . ".</strong></p></div>"; } elseif ( isset( $_GET['message'] ) && $_GET['message'] == '4' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'Invalid column count for bug on row', 'bug-library' ) . "</strong></p></div>"; } elseif ( isset( $_GET['message'] ) && $_GET['message'] == '9' ) { echo "<div id='message' class='updated fade'><p><strong>" . intval( $_GET['importrowscount'] ) . " " . __( 'row(s) found', 'bug-library' ) . ". " . intval( $_GET['successimportcount'] ) . " " . __( 'bugs(s) imported successfully', 'bugs-library' ) . ".</strong></p></div>"; } elseif ( isset( $_GET['message'] ) && $_GET['message'] == '10' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'Bugs(s) exported successfully', 'bugs-library' ) . ".</strong></p></div>"; } $formvalue = 'save_bug_library_general'; $pagetitle = __( "Bug Library General Settings", 'bug-library' ); } elseif ( $_GET['page'] == 'bug-library-stylesheet' ) { $formvalue = 'save_bug_library_stylesheet'; $pagetitle = __( "Bug Library Stylesheet Editor", 'bug-library' ); if ( isset( $_GET['message'] ) && $_GET['message'] == '1' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'Stylesheet updated', 'bug-library' ) . ".</strong></p></div>"; } elseif ( isset( $_GET['message'] ) && $_GET['message'] == '2' ) { echo "<div id='message' class='updated fade'><p><strong>" . __( 'Stylesheet reset to original state', 'bug-library' ) . ".</strong></p></div>"; } } elseif ( $_GET['page'] == 'bug-library-instructions' ) { $formvalue = 'save_bug_library_instructions'; $pagetitle = __( "Bug Library Usage Instructions", 'bug-library' ); } $data = array(); $data['genoptions'] = $genoptions; global $pagehooktop, $pagehookstylesheet, $pagehookinstructions; ?> <div id="bug-library-general" class="wrap"> <h2><?php echo esc_html( $pagetitle ); ?> <span style='padding-left: 50px'><a href="https://ylefebvre.github.io/wordpress-plugins/bug-library/" target="buglibrary"><img src="<?php echo plugins_url( '/icons/btn_donate_LG.gif', __FILE__ ); ?>" /></a></span> </h2> <form name='buglibrary' enctype="multipart/form-data" action="admin-post.php" method="post"> <input type="hidden" name="MAX_FILE_SIZE" value="100000" /> <?php wp_nonce_field( 'bug-library' ); ?> <?php wp_nonce_field( 'closedpostboxes', 'closedpostboxesnonce', false ); ?> <?php wp_nonce_field( 'meta-box-order', 'meta-box-order-nonce', false ); ?> <input type="hidden" name="action" value="<?php echo esc_html( $formvalue ); ?>" /> <div id="poststuff" class="metabox-holder"> <div id="post-body" class="has-sidebar"> <div id="post-body-content" class="has-sidebar-content"> <?php if ( $_GET['page'] == 'bug-library-general-options' ) { do_meta_boxes( $pagehooktop, 'normal', $data ); } elseif ( $_GET['page'] == 'bug-library-stylesheet' ) { do_meta_boxes( $pagehookstylesheet, 'normal', $data ); } elseif ( $_GET['page'] == 'bug-library-instructions' ) { do_meta_boxes( $pagehookinstructions, 'normal', $data ); } ?> </div> </div> <br class="clear" /> </div> </form> </div> <script type="text/javascript"> //<![CDATA[ jQuery(document).ready(function ($) { // close postboxes that should be closed jQuery('.if-js-closed').removeClass('if-js-closed').addClass('closed'); // postboxes setup postboxes.add_postbox_toggles('<?php if ($_GET['page'] == 'bug-library') {echo esc_html( $pagehooktop );} elseif ($_GET['page'] == 'bug-library-stylesheet') {echo esc_html( $pagehookstylesheet );} elseif ($_GET['page'] == 'bug-library-instructions') {echo esc_html( $pagehookinstructions );} ?>'); jQuery('.bltooltip').each(function () { jQuery(this).tipTip(); } ); }); //]]> </script> <?php } //executed if the post arrives initiated by pressing the submit button of form function on_save_changes_general() { //user permission check if ( ! current_user_can( 'manage_options' ) ) { wp_die( __( 'Not allowed', 'bug-library' ) ); } //cross check the given referer check_admin_referer( 'bug-library' ); $message = ''; $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); if ( isset( $_POST['importbugs'] ) ) { global $wpdb; $row = 1; $successfulimport = 0; $handle = fopen( $_FILES['bugsfile']['tmp_name'], "r" ); if ( $handle ) { $skiprow = 1; while ( ( $data = fgetcsv( $handle, 5000, "," ) ) !== false ) { $row += 1; if ( $skiprow == 1 && isset( $_POST['firstrowheaders'] ) && $row >= 2 ) { $skiprow = 0; } elseif ( ! isset( $_POST['firstrowheaders'] ) ) { $skiprow = 0; } if ( ! $skiprow ) { if ( count( $data ) == 13 ) { $new_bug_data = array( 'post_status' => sanitize_text_field( $data[9] ), 'post_type' => 'bug-library-bugs', 'post_author' => '', 'ping_status' => get_option( 'default_ping_status' ), 'post_parent' => 0, 'menu_order' => 0, 'to_ping' => '', 'pinged' => '', 'post_password' => '', 'guid' => '', 'post_content_filtered' => '', 'post_excerpt' => '', 'import_id' => 0, 'comment_status' => 'open', 'post_content' => sanitize_text_field( stripslashes( $data[5] ) ), 'post_date' => date_i18n( 'Y-m-d H:i:s', strtotime( $data[8] ) ), 'post_excerpt' => '', 'post_title' => sanitize_text_field( stripslashes( $data[4] ) ) ); $newbugid = wp_insert_post( $new_bug_data ); if ( $newbugid != - 1 ) { $successfulimport += 1; $message = '9'; if ( $data[1] != '' ) { wp_set_post_terms( $newbugid, sanitize_text_field( $data[1] ), "bug-library-products" ); } if ( $data[3] != '' ) { wp_set_post_terms( $newbugid, sanitize_text_field( $data[3] ), "bug-library-status" ); } if ( $data[0] != '' ) { wp_set_post_terms( $newbugid, sanitize_text_field( $data[0] ), "bug-library-types" ); } if ( $data[2] != '' ) { update_post_meta( $newbugid, "bug-library-product-version", sanitize_text_field( $data[2] ) ); } if ( $data[6] != '' ) { update_post_meta( $newbugid, "bug-library-reporter-name", sanitize_text_field( $data[6] ) ); } if ( $data[7] != '' ) { update_post_meta( $newbugid, "bug-library-reporter-email", sanitize_text_field( $data[7] ) ); } if ( $data[10] != '' ) { update_post_meta( $newbugid, "bug-library-resolution-date", sanitize_text_field( $data[10] ) ); } if ( $data[11] != '' ) { update_post_meta( $newbugid, "bug-library-resolution-version", sanitize_text_field( $data[11] ) ); } if ( $data[12] != '' ) { wp_set_post_terms( $newbugid, sanitize_text_field( $data[12] ), "bug-library-priority" ); } } } else { $messages[] = '4'; } } } } if ( isset( $_POST['firstrowheaders'] ) ) { $row -= 1; } $message = '9'; } elseif ( isset( $_POST['exportbugs'] ) ) { $upload_dir = wp_upload_dir(); if ( is_writable( $upload_dir['path'] ) ) { $myFile = $upload_dir['path'] . "/BugsExport.csv"; $fh = fopen( $myFile, 'w' ) or die( "can't open file" ); $bugs_query_args = array( 'post_type' => 'bug-library-bugs', 'posts_per_page' => -1, 'post_status' => array( 'publish', 'pending', 'draft', 'future', 'private' ) ); $bugs_to_export = new WP_Query( $bugs_query_args ); if ( $bugs_to_export->have_posts() ) { $bug_items = array(); while ( $bugs_to_export->have_posts() ) { $bug_object = array(); $bugs_to_export->the_post(); $products = wp_get_post_terms( get_the_ID(), 'bug-library-products' ); $statuses = wp_get_post_terms( get_the_ID(), 'bug-library-status' ); $types = wp_get_post_terms( get_the_ID(), 'bug-library-types' ); $priorities = wp_get_post_terms( get_the_ID(), 'bug-library-priority' ); $productversion = get_post_meta( get_the_ID(), 'bug-library-product-version', true ); $reportername = get_post_meta( get_the_ID(), 'bug-library-reporter-name', true ); $reporteremail = get_post_meta( get_the_ID(), 'bug-library-reporter-email', true ); $resolutiondate = get_post_meta( get_the_ID(), 'bug-library-resolution-date', true ); $resolutionversion = get_post_meta( get_the_ID(), 'bug-library-resolution-version', true ); $imagepath = get_post_meta( get_the_ID(), 'bug-library-image-path', true ); $assigneduserid = get_post_meta( get_the_ID(), 'bug-library-assignee', true ); $bug_object['ID'] = get_the_ID(); $bug_object['Title'] = get_the_title(); $bug_object['Description'] = get_the_content(); $bug_products_array = array(); $bug_products = ''; if ( !empty( $products ) ) { foreach ( $products as $bug_product ) { $bug_products_array[] = $bug_product->name; } if ( !empty( $bug_products_array ) ) { $bug_products = implode( ', ', $bug_products_array ); } } $bug_object['Bug Product'] = $bug_products; $bug_statuses_array = array(); $bug_statuses = ''; if ( !empty( $statuses ) ) { foreach ( $statuses as $bug_status ) { $bug_statuses_array[] = $bug_status->name; } if ( !empty( $bug_statuses_array ) ) { $bug_statuses = implode( ', ', $bug_statuses_array ); } } $bug_object['Bug Status'] = $bug_statuses; $bug_types_array = array(); $bug_types = ''; if ( !empty( $types ) ) { foreach ( $types as $bug_type ) { $bug_types_array[] = $bug_type->name; } if ( !empty( $bug_types_array ) ) { $bug_types = implode( ', ', $bug_types_array ); } } $bug_object['Bug Type'] = $bug_types; $bug_priorities_array = array(); $bug_priorities = ''; if ( !empty( $types ) ) { foreach ( $types as $bug_priority ) { $bug_priorities_array[] = $bug_priority->name; } if ( !empty( $bug_priorities_array ) ) { $bug_priorities = implode( ', ', $bug_priorities_array ); } } $bug_object['Bug Priority'] = $bug_priorities; $bug_object['Product Version'] = $productversion; $bug_object['Reporter Name'] = $reportername; $bug_object['Reporter E-mail'] = $reporteremail; $bug_object['Resolution Date'] = $resolutiondate; $bug_object['Resolution Version'] = $resolutionversion; $bug_items[] = $bug_object; } } wp_reset_postdata(); $bug_items = apply_filters( 'bug_library_export_all_links', $bug_items ); if ( $bug_items ) { $headerrow = array(); foreach ( $bug_items[0] as $key => $option ) { $headerrow[] = '"' . $key . '"'; } $headerdata = join( ',', $headerrow ) . "\n"; fwrite( $fh, $headerdata ); foreach ( $bug_items as $bug_item ) { $datarow = array(); foreach ( $bug_item as $key => $value ) { $datarow[] = $value; } fputcsv( $fh, $datarow, ',', '"' ); } fclose( $fh ); if ( file_exists( $myFile ) ) { header( 'Content-Description: File Transfer' ); header( 'Content-Type: application/octet-stream' ); header( 'Content-Disposition: attachment; filename=' . basename( $myFile ) ); header( 'Expires: 0' ); header( 'Cache-Control: must-revalidate' ); header( 'Pragma: public' ); header( 'Content-Length: ' . filesize( $myFile ) ); readfile( $myFile ); exit; } } } else { $message = '10'; } } else { $statusterm = get_term_by( 'id', intval( $_POST['bug-library-status'] ), 'bug-library-status' ); $genoptions['defaultuserbugstatus'] = $statusterm->name; $closedstatusterm = get_term_by( 'id', intval( $_POST['bug-library-closed-status'] ), 'bug-library-status' ); $genoptions['bugclosedstatus'] = $closedstatusterm->name; $priorityterm = get_term_by( 'id', intval( $_POST['bug-library-priority'] ), 'bug-library-priority' ); $genoptions['defaultuserbugpriority'] = $priorityterm->name; $productterm = get_term_by( 'id', intval( $_POST['bug-library-products'] ), 'bug-library-products' ); $genoptions['defaultuserproduct'] = $productterm->term_id; if ( ( ! isset( $genoptions['allowattach'] ) || false == $genoptions['allowattach'] ) && isset( $_POST['allowattach'] ) ) { $uploads = wp_upload_dir(); if ( ! file_exists( $uploads['basedir'] ) ) { $message = 2; $genoptions['allowattach'] = false; } elseif ( ! is_writable( $uploads['basedir'] ) ) { $message = 3; $genoptions['allowattach'] = false; } else { if ( ! file_exists( $uploads['basedir'] . '/bug-library' ) ) { mkdir( $uploads['basedir'] . '/bug-library' ); } $genoptions['allowattach'] = true; } } elseif ( ! isset( $_POST['allowattach'] ) ) { $genoptions['allowattach'] = false; } foreach ( array( 'entriesperpage', 'bugnotifytitle', 'permalinkpageid', 'rolelevel', 'editlevel' ) as $option_name ) { if ( isset( $_POST[ $option_name ] ) ) { $genoptions[ $option_name ] = sanitize_text_field( $_POST[ $option_name ] ); } } foreach ( array( 'moderatesubmissions', 'showcaptcha', 'requirelogin', 'newbugadminnotify', 'firstrowheaders', 'showpriority', 'showreporter', 'showassignee', 'requirename', 'requireemail', 'hideproduct', 'hideversionnumber', 'hideissuetype', 'closecommentsonclosure', 'excludesitesearch', 'productemptyoption', 'issueemptyoption' ) as $option_name ) { if ( isset( $_POST[ $option_name ] ) ) { $genoptions[ $option_name ] = true; } else { $genoptions[ $option_name ] = false; } } update_option( 'BugLibraryGeneral', $genoptions ); if ( $message == '' ) { $message = 1; } } global $wp_rewrite; $wp_rewrite->flush_rules(); //lets redirect the post request into get request (you may add additional params at the url, if you need to show save results wp_redirect( $this->remove_querystring_var( $_POST['_wp_http_referer'], 'message' ) . "&message=" . intval( $message ) . ( isset( $row ) && $row != 0 ? "&importrowscount=" . intval( $row ) : '' ) . ( $successfulimport != 0 ? "&successimportcount=" . intval( $successfulimport ) : "" ) ); } //executed if the post arrives initiated by pressing the submit button of form function on_save_changes_stylesheet() { //user permission check if ( ! current_user_can( 'manage_options' ) ) { wp_die( __( 'Not allowed', 'bug-library' ) ); } //cross check the given referer check_admin_referer( 'bug-library' ); $message = ''; global $wpdb; if ( isset( $_POST['submitstyle'] ) ) { $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); // Get back the optimized CSS Code $genoptions['fullstylesheet'] = $this->validate_css( sanitize_text_field( $_POST['fullstylesheet'] )); update_option( 'BugLibraryGeneral', $genoptions ); $message = 1; } elseif ( isset( $_POST['resetstyle'] ) ) { $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); $stylesheetlocation = plugin_dir_path( __FILE__ ) . 'stylesheet.css'; if ( file_exists( $stylesheetlocation ) ) { $genoptions['fullstylesheet'] = file_get_contents( $stylesheetlocation ); // Get back the optimized CSS Code $genoptions['fullstylesheet'] = $this->validate_css( $genoptions['fullstylesheet'] ); } update_option( 'BugLibraryGeneral', $genoptions ); $message = 2; } //lets redirect the post request into get request (you may add additional params at the url, if you need to show save results $cleanredirecturl = $this->remove_querystring_var( $_POST['_wp_http_referer'], 'message' ); if ( $message != '' ) { $cleanredirecturl .= "&message=" . intval( $message ); } wp_redirect( $cleanredirecturl ); } //executed if the post arrives initiated by pressing the submit button of form function on_save_changes_instructions() { //user permission check if ( ! current_user_can( 'manage_options' ) ) { wp_die( __( 'Not allowed', 'bug-library' ) ); } //cross check the given referer check_admin_referer( 'bug-library' ); wp_redirect( $this->remove_querystring_var( $_POST['_wp_http_referer'], 'message' ) . "&message=1" ); } function general_meta_box( $data ) { $genoptions = $data['genoptions']; ?> <table> <tr> <td style='vertical-align: top; padding-right: 10px;'> <table> <tr> <td style='width: 200px'><?php _e( 'Number of entries per page', 'bug-library' ); ?></td> <td> <input style="width:100%" type="text" name="entriesperpage" <?php echo "value='" . intval( $genoptions['entriesperpage'] ) . "'"; ?>/> </td> </tr> <tr> <td class='bltooltip' title='<?php _e( 'Must re-apply permalink rules for this option to take effect', 'bug-library' ); ?>'><?php _e( 'Parent page (for permalink structure)', 'bug-library' ); ?></td> <td class='bltooltip' title='<?php _e( 'Must re-apply permalink rules for this option to take effect', 'bug-library' ); ?>'> <?php $pages = get_pages( array( 'parent' => 0, 'sort_column' => 'post_title' ) ); if ( $pages ): ?> <select name='permalinkpageid' style='width: 200px'> <option value='-1'><?php _e( 'Default (bugs)', 'bug-library' ); ?></option> <?php foreach ( $pages as $page ): ?> <option value='<?php echo intval( $page->ID ); ?>' <?php selected( $page->ID == $genoptions['permalinkpageid'] ); ?>><?php echo esc_html( $page->post_title ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> </tr> <tr> <td><?php _e( 'Show bug priorities', 'bug-library' ); ?></td> <td> <input type="checkbox" id="showpriority" name="showpriority" <?php checked( $genoptions['showpriority'] ); ?>/></td> </tr> <tr> <td><?php _e( 'Show reporter name', 'bug-library' ); ?></td> <td> <input type="checkbox" id="showreporter" name="showreporter" <?php checked( $genoptions['showreporter'] ); ?>/></td> </tr> <tr> <td><?php _e( 'Show assigned user', 'bug-library' ); ?></td> <td> <input type="checkbox" id="showassignee" name="showassignee" <?php checked( $genoptions['showassignee'] ); ?>/></td> </tr> <tr> <td><?php _e( 'Minimum role for bug assignment', 'bug-library' ); ?></td> <td> <?php global $wp_roles; if ( $wp_roles ):?> <select name='rolelevel' style='width: 200px'> <?php $roles = $wp_roles->roles; foreach ( $roles as $role ): ?> <option value='<?php echo esc_html( $role['name'] ); ?>' <?php selected( $genoptions['rolelevel'] == $role['name'] ); ?>><?php echo esc_html( $role['name'] ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> </tr> <tr> <td><?php _e( 'Minimum role to get bug edit link', 'bug-library' ); ?></td> <td> <?php if ( $wp_roles ): ?> <select name='editlevel' style='width: 200px'> <?php $roles = $wp_roles->roles; foreach ( $roles as $role ): ?> <option value='<?php echo esc_html( $role['name'] ); ?>' <?php selected( $genoptions['editlevel'] == $role['name'] ); ?>><?php echo esc_html( $role['name'] ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> </tr> <tr> <td><?php _e( 'Exclude bugs from site search', 'bug-library' ); ?></td> <td><input type="checkbox" id="excludesitesearch" name="excludesitesearch" <?php checked( $genoptions['excludesitesearch'] ); ?>/></td> </tr> </table> </td> </tr> </table> <?php } function general_meta_newissue_box( $data ) { $genoptions = $data['genoptions']; ?> <table> <tr> <td style='width: 300px'><?php _e( 'Moderate new submissions', 'bug-library' ); ?></td> <td> <input type="checkbox" id="moderatesubmissions" name="moderatesubmissions" <?php checked( $genoptions['moderatesubmissions'] ); ?>/> </td> <td style='width: 40px'></td> <td style='width: 300px'><?php _e( 'Show Captcha in submission form', 'bug-library' ); ?></td> <td> <input type="checkbox" id="showcaptcha" name="showcaptcha" <?php checked( $genoptions['showcaptcha'] );; ?>/> </td> </tr> <tr> <td><?php _e( 'Allow file attachments', 'bug-library' ); ?></td> <td> <input type="checkbox" id="allowattach" name="allowattach" <?php checked( $genoptions['allowattach'] ); ?>/> </td> <td></td> <td><?php _e( 'Require login to submit new issues', 'bug-library' ); ?></td> <td> <input type="checkbox" id="requirelogin" name="requirelogin" <?php checked( $genoptions['requirelogin'] ); ?>/> </td> </tr> <tr> <td><?php _e( 'Require Reporter Name', 'bug-library' ); ?></td> <td> <input type="checkbox" id="requirename" name="requirename" <?php checked( $genoptions['requirename'] ); ?>/> </td> <td></td> <td><?php _e( 'Require Reporter E-mail', 'bug-library' ); ?></td> <td> <input type="checkbox" id="requireemail" name="requireemail" <?php checked( $genoptions['requireemail'] ); ?>/> </td> </tr> <tr> <td><?php _e( 'Hide product selection field', 'bug-library' ); ?></td> <td> <input type="checkbox" id="hideproduct" name="hideproduct" <?php checked( $genoptions['hideproduct'] ); ?>/> </td> <td></td> <td><?php _e( 'Hide version number field', 'bug-library' ); ?></td> <td> <input type="checkbox" id="hideversionnumber" name="hideversionnumber" <?php checked( $genoptions['hideversionnumber'] ); ?>/> </td> </tr> <tr> <td><?php _e( 'Hide issue type field', 'bug-library' ); ?></td> <td> <input type="checkbox" id="hideissuetype" name="hideissuetype" <?php checked( $genoptions['hideissuetype'] ); ?>/> </td> <td></td> <td></td> <td> </td> </tr> <tr> <td><?php _e( 'Add empty option to product list', 'bug-library' ); ?></td> <td> <input type="checkbox" id="productemptyoption" name="productemptyoption" <?php checked( $genoptions['productemptyoption'] ); ?>/> </td> <td></td> <td><?php _e( 'Add empty option to issue list', 'bug-library' ); ?></td> <td> <input type="checkbox" id="issueemptyoption" name="issueemptyoption" <?php checked( $genoptions['issueemptyoption'] ); ?>/> </td> </tr> <tr> <td><?php _e( 'Default user bug status', 'bug-library' ); ?></td> <td> <?php $statusterms = get_terms( 'bug-library-status', 'orderby=name&hide_empty=0' ); if ( $statusterms ): ?> <select name='bug-library-status' style='width: 200px'> <?php foreach ( $statusterms as $statusterm ): ?> <option value='<?php echo intval( $statusterm->term_id ); ?>' <?php selected( $statusterm->name == $genoptions['defaultuserbugstatus'] ); ?>><?php echo esc_html( $statusterm->name ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> <td></td> <td><?php _e( 'Default user bug priority', 'bug-library' ); ?></td> <td> <?php $priorityterms = get_terms( 'bug-library-priority', 'orderby=name&hide_empty=0' ); if ( $priorityterms ): ?> <select name='bug-library-priority' style='width: 200px'> <?php foreach ( $priorityterms as $priorityterm ): ?> <option value='<?php echo intval( $priorityterm->term_id ); ?>' <?php selected( isset( $genoptions['defaultuserbugpriority'] ) && $priorityterm->name == $genoptions['defaultuserbugpriority'] ); ?>><?php echo esc_html( $priorityterm->name ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> </tr> <tr> <td><?php _e( 'Default product', 'bug-library' ); ?></td> <td> <?php $productterms = get_terms( 'bug-library-products', 'orderby=name&hide_empty=0' ); if ( $productterms ): ?> <select name='bug-library-products' style='width: 200px'> <option value=""><?php _e( 'No default', 'bug-library' ); ?></option> <?php foreach ( $productterms as $productterm ): ?> <option value='<?php echo intval( $productterm->term_id ); ?>' <?php selected( isset( $genoptions['defaultuserproduct'] ) && $productterm->term_id == $genoptions['defaultuserproduct'] ); ?>><?php echo esc_html( $productterm->name ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> </tr> <tr> <td><?php _e( 'Closed bug status', 'bug-library' ); ?></td> <td> <?php $closedstatusterms = get_terms( 'bug-library-status', 'orderby=name&hide_empty=0' ); if ( $closedstatusterms ): ?> <select name='bug-library-closed-status' style='width: 200px'> <?php foreach ( $closedstatusterms as $closedstatusterm ): ?> <option value='<?php echo intval( $closedstatusterm->term_id ); ?>' <?php selected( $closedstatusterm->name == $genoptions['bugclosedstatus'] ); ?>><?php echo esc_html( $closedstatusterm->name ); ?></option> <?php endforeach; ?> </select> <?php endif; ?> </td> <td></td> <td><?php _e( 'Close comments on closed status', 'bug-library' ); ?></td> <td> <input type="checkbox" id="closecommentsonclosure" name="closecommentsonclosure" <?php checked( $genoptions['closecommentsonclosure'] ); ?>/> </td> </tr> <tr> <td><?php _e( 'Notify admin of new bugs', 'bug-library' ); ?></td> <td> <input type="checkbox" id="newbugadminnotify" name="newbugadminnotify" <?php checked( $genoptions['newbugadminnotify'] ); ?>/> </td> </tr> <tr> <td class='bltooltip' title='<?php _e( 'Set the title of new bug e-mail notifications. Use variable %bugtitle% to be replaced by the new bug title.', 'bug-library' ); ?>'><?php _e( 'New bug notification title', 'bug-library' ); ?></td> <td colspan='4' class='bltooltip' title='<?php _e( 'Set the title of new bug e-mail notifications. Use variable %bugtitle% to be replaced by the new bug title.', 'bug-library' ); ?>'> <input style="width:100%" type="text" size='80' name="bugnotifytitle" <?php echo "value='" . esc_html( $genoptions['bugnotifytitle'] ) . "'"; ?>/> </td> </tr> </table> <?php } function general_importexport_meta_box( $data ) { $genoptions = $data['genoptions']; ?> <table> <tr> <td><?php _e( 'First Row Contains Headers', 'bug-library' ); ?></td> <td> <input type="checkbox" id="firstrowheaders" name="firstrowheaders" <?php if ( $genoptions['firstrowheaders'] ) { echo ' checked="checked" '; } ?>/></td> </tr> <tr> <td class='bltooltip' title='<?php _e( 'Allows for bugs to be added in batch to the Wordpress bugs database. CSV file needs to follow template for column layout.', 'bug-library' ); ?>' style='width: 330px'><?php _e( 'CSV file to upload to import bugs', 'bug-library' ); ?> (<a href="<?php echo plugins_url( 'importtemplate.csv', __FILE__ ); ?>"><?php _e( 'file template', 'bug-library' ); ?></a>) </td> <td><input size="80" name="bugsfile" type="file" /></td> <td><input type="submit" name="importbugs" value="<?php _e( 'Import Bugs', 'link-library' ); ?>" /></td> </tr> <tr> <td><?php _e( 'Export all bugs to a CSV file', 'bug-library' ); ?></td> <td><input type="submit" name="exportbugs" value="<?php _e( 'Export Bugs', 'link-library' ); ?>" /></td> </tr> </table> <?php } function general_save_meta_box() { ?> <div class="submitbox"> <input type="submit" name="submit" class="button-primary" value="<?php _e( 'Save', 'bug-library' ); ?>" /> </div> <?php } function stylesheet_meta_box( $data ) { $genoptions = $data['genoptions']; ?> <textarea name='fullstylesheet' id='fullstylesheet' style='font-family:Courier' rows="30" cols="90"><?php echo stripslashes( sanitize_text_field( $genoptions['fullstylesheet'] ) ); ?></textarea> <div> <input type="submit" name="submitstyle" value="<?php _e( 'Submit', 'bug-library' ); ?>" /><input type="submit" name="resetstyle" value="<?php _e( 'Reset to default', 'bug-library' ); ?>" /> </div> <?php } function instructions_meta_box() { ?> <ol> <li><?php _e( 'To get a basic Bug Library list showing on one of your Wordpress pages, create a new page and type the following text: [bug-library]' ); ?></li> <li><?php _e( 'Configure the Bug Library General Options section for more control over the plugin functionality.' , 'bug-library' ); ?></li> <li><?php _e( 'Copy the file single-bug-library-bugs.php from the bug-library plugin directory to your theme directory to display all information related to your bugs. You might have to edit this file a bit and compare it to single.php to get the proper layout to show up on your web site.', 'bug-library' ); ?></li> </ol> <?php } /******************************************** Print style data to header *********************************************/ function bl_page_header() { $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); echo "<style id='BugLibraryStyle' type='text/css'>\n"; echo stripslashes( sanitize_text_field( $genoptions['fullstylesheet'] ) ); echo "</style>\n"; } function bl_admin_header() { wp_enqueue_style( 'datePickerstyle-css', plugins_url( 'css/ui-lightness/jquery-ui-1.8.4.custom.css', __FILE__ ) ); wp_enqueue_script( 'jquery-ui-datepicker' ); } function bl_highlight_phrase( $str, $phrase, $tag_open = '<strong>', $tag_close = '</strong>' ) { if ( $str == '' ) { return ''; } if ( $phrase != '' ) { return preg_replace( '/(' . preg_quote( $phrase, '/' ) . '(?![^<]*>))/i', $tag_open . "\\1" . $tag_close, $str ); } return $str; } function BugLibrary( $entriesperpage = 10, $moderatesubmissions = true, $bugcategorylist = '', $requirelogin = false, $permalinkpageid = - 1, $showpriority = false, $showreporter = false, $showassignee = false, $shortcodebugtypeid = '', $shortcodebugstatusid = '', $shortcodebugpriorityid = '' ) { global $wpdb; if ( isset( $_GET['bugid'] ) ) { $bugid = intval( $_GET['bugid'] ); $view = 'single'; } else { $bugid = - 1; $view = 'list'; if ( isset( $_GET['bugpage'] ) ) { $pagenumber = intval( $_GET['bugpage'] ); } else { $pagenumber = 1; } if ( isset( $_GET['bugcatid'] ) ) { $bugcatid = intval( $_GET['bugcatid'] ); } else { $bugcatid = - 1; } if ( isset( $_GET['bugtypeid'] ) ) { $bugtypeid = intval( $_GET['bugtypeid'] ); } elseif ( $shortcodebugtypeid != '' ) { $bugtypeid = intval( $shortcodebugtypeid ); } else { $bugtypeid = - 1; } if ( isset( $_GET['bugstatusid'] ) ) { $bugstatusid = intval( $_GET['bugstatusid'] ); } elseif ( $shortcodebugstatusid != '' ) { $bugstatusid = intval( $shortcodebugstatusid ); } else { $bugstatusid = - 1; } if ( isset( $_GET['bugpriorityid'] ) ) { $bugpriorityid = intval( $_GET['bugpriorityid'] ); } elseif ( $shortcodebugpriorityid != '' ) { $bugpriorityid = intval( $shortcodebugpriorityid ); } else { $bugpriorityid = - 1; } } $bugquery = "SELECT bugs.*, UNIX_TIMESTAMP(bugs.post_date) as bug_date_unix, pt.name as productname, pt.term_id as pid, st.name as statusname, "; $bugquery .= "st.term_id as sid, tt.name as typename, tt.term_id as tid, pt.slug as productslug, st.slug as statusslug, tt.slug as typeslug, tpr.name as priorityname "; $bugquery .= "FROM $wpdb->posts bugs LEFT JOIN " . $wpdb->get_blog_prefix() . "term_relationships trp "; $bugquery .= "ON bugs.ID = trp.object_id LEFT JOIN "; $bugquery .= $wpdb->get_blog_prefix() . "term_taxonomy ttp ON trp.term_taxonomy_id = ttp.term_taxonomy_id LEFT JOIN " . $wpdb->get_blog_prefix(); $bugquery .= "terms pt ON ttp.term_id = pt.term_id LEFT JOIN " . $wpdb->get_blog_prefix() . "term_relationships trs ON bugs.ID = trs.object_id "; $bugquery .= "LEFT JOIN " . $wpdb->get_blog_prefix() . "term_taxonomy tts ON trs.term_taxonomy_id = tts.term_taxonomy_id LEFT JOIN " . $wpdb->get_blog_prefix(); $bugquery .= "terms st ON tts.term_id = st.term_id LEFT JOIN " . $wpdb->get_blog_prefix() . "term_relationships trt ON bugs.ID = trt.object_id "; $bugquery .= "LEFT JOIN " . $wpdb->get_blog_prefix() . "term_taxonomy ttt ON trt.term_taxonomy_id = ttt.term_taxonomy_id LEFT JOIN " . $wpdb->get_blog_prefix(); $bugquery .= "terms tt ON ttt.term_id = tt.term_id LEFT JOIN " . $wpdb->get_blog_prefix() . "term_relationships trpr ON bugs.ID = trpr.object_id "; $bugquery .= "LEFT OUTER JOIN " . $wpdb->get_blog_prefix() . "term_taxonomy ttpr ON trpr.term_taxonomy_id = ttpr.term_taxonomy_id LEFT OUTER JOIN " . $wpdb->get_blog_prefix(); $bugquery .= "terms tpr ON ttpr.term_id = tpr.term_id "; $bugquery .= "WHERE bugs.post_type = 'bug-library-bugs' AND ttp.taxonomy = 'bug-library-products' "; $bugquery .= "AND tts.taxonomy = 'bug-library-status' AND ttt.taxonomy = 'bug-library-types' AND ttpr.taxonomy = 'bug-library-priority' "; $bugquery .= "AND bugs.post_status != 'trash' "; if ( $bugcategorylist != '' ) { $bugquery .= "AND pt.term_id in ('" . sanitize_text_field( $bugcategorylist ) . "') "; } if ( $view == 'single' ) { if ( $bugid != - 1 ) { $bugquery .= " and ID = " . intval( $bugid ); } } elseif ( $view == 'list' ) { if ( $bugstatusid != - 1 ) { $bugquery .= " and tts.term_id = " . intval( $bugstatusid ); } if ( $bugcatid != - 1 ) { $bugquery .= " and ttp.term_id = " . intval( $bugcatid ); } if ( $bugtypeid != - 1 ) { $bugquery .= " and ttt.term_id = " . intval( $bugtypeid ); } if ( $bugpriorityid != - 1 ) { $bugquery .= " and ttpr.term_id = " . intval( $bugpriorityid ); } } if ( $moderatesubmissions == true ) { $bugquery .= " and bugs.post_status = 'publish' "; } $bugquery .= " order by bugs.post_date DESC"; //echo $bugquery; $startingentry = ( $pagenumber - 1 ) * $entriesperpage; $quantity = $entriesperpage + 1; $countbugsquery = str_replace( 'bugs.*, UNIX_TIMESTAMP(bugs.post_date) as bug_date_unix, pt.name as productname, pt.term_id as pid, st.name as statusname, st.term_id as sid, tt.name as typename, tt.term_id as tid, pt.slug as productslug, st.slug as statusslug, tt.slug as typeslug', 'count(*)', $bugquery ); $bugscount = $wpdb->get_var( $countbugsquery ); if ( $view == 'list' ) { $bugquery .= " LIMIT " . intval( $startingentry ) . ", " . intval( $quantity ); } $bugs = $wpdb->get_results( $bugquery, ARRAY_A ); //print_r($bugs); if ( $entriesperpage == 0 && $entriesperpage == '' ) { $entriesperpage = 10; } if ( count( $bugs ) > $entriesperpage ) { array_pop( $bugs ); $nextpage = true; } else { $nextpage = false; } $preroundpages = $bugscount / $entriesperpage; $numberofpages = ceil( $preroundpages * 1 ) / 1; $output = "<div id='bug-library-list'>\n"; if ( $view == 'list' ) { // Filter List $output .= "<div id='bug-library-currentfilters'>" . __( 'Filtered by', 'bug-library' ) . ": "; if ( ( $bugcatid == - 1 ) && ( $bugtypeid == - 1 ) && ( $bugstatusid == - 1 ) && ( $bugpriorityid == - 1 ) ) { $output .= __( "None", 'bug-library' ); } if ( $bugcatid != - 1 ) { $products = get_term_by( 'id', intval( $bugcatid ), "bug-library-products", ARRAY_A ); $output .= __( 'Products', 'bug-library' ) . " (" . esc_html( $products['name'] ) . ")"; } if ( $bugtypeid != - 1 ) { if ( $bugcatid != - 1 ) { $output .= ", "; } $types = get_term_by( 'id', intval( $bugtypeid ), "bug-library-types", ARRAY_A ); $output .= __( 'Type', 'bug-library' ) . " (" . esc_html( $types['name'] ) . ")"; } if ( $bugstatusid != - 1 ) { if ( ( $bugcatid != - 1 ) || ( $bugtypeid != - 1 ) ) { $output .= ", "; } $statuses = get_term_by( 'id', intval( $bugstatusid ), "bug-library-status", ARRAY_A ); $output .= __( 'Status', 'bug-library' ) . " (" . esc_html( $statuses['name'] ) . ")"; } if ( $bugpriorityid != - 1 ) { if ( ( $bugcatid != - 1 ) || ( $bugtypeid != - 1 ) || ( $bugstatusid != - 1 ) ) { $output .= ", "; } $priorities = get_term_by( 'id', intval( $bugpriorityid ), "bug-library-priority", ARRAY_A ); $output .= __( 'Priority', 'bug-library' ) . " (" . esc_html( $priorities['name'] ) . ")"; } $output .= " <span id='bug-library-filterchange'>" . __( 'Change Filter', 'bug-library' ) . "</span>"; $cleanuri = $this->remove_querystring_var( $_SERVER['REQUEST_URI'], "bugid" ); $cleanuri = $this->remove_querystring_var( $cleanuri, "bugcatid" ); $cleanuri = $this->remove_querystring_var( $cleanuri, "bugstatusid" ); $cleanuri = $this->remove_querystring_var( $cleanuri, "bugtypeid" ); $cleanuri = $this->remove_querystring_var( $cleanuri, "bugpriorityid" ); if ( $permalinkpageid != - 1 ) { $parentpage = get_post( $permalinkpageid ); $parentslug = $parentpage->post_name; } else { $parentslug = 'bugs'; } $output .= " <a href='" . home_url() . "/" . esc_html( $parentslug ) . "'>" . __( 'Remove all filters', 'bug-library' ) . "</a>"; $output .= "</div>"; if ( $view == 'list' && ( $requirelogin == false || is_user_logged_in() ) ) { $output .= "<div id='bug-library-newissuebutton'><button id='submitnewissue'>" . __( 'Report new issue', 'bug-library' ) . "</button></div>"; } $output .= "<div id='bug-library-filters'>"; $output .= "<div id='bug-library-filter-product'>"; $output .= "<div id='bug-library-filter-producttitle'>" . __( 'Products', 'bug-library' ) . "</div>"; $output .= "<div id='bug-library-filter-productitems'>"; $products = get_terms( 'bug-library-products', 'orderby=name&hide_empty=0' ); if ( $products ) { $bugcaturi = $this->remove_querystring_var( $_SERVER['REQUEST_URI'], "bugcatid" ); if ( strpos( $bugcaturi, '?' ) === false ) { if ( strpos( $bugcaturi, '&' ) === false ) { $queryoperator = '?'; } elseif ( strpos( $bugcaturi, '&' ) !== false ) { $ampersandpos = strpos( $bugcaturi, '&' ); $bugcaturi = preg_replace( '/&/', '?', $bugcaturi, 1 ); $queryoperator = '&'; } } else { $queryoperator = '&'; } if ( $bugcatid == - 1 ) { $output .= "<span id='bug-library-filter-currentproduct'>" . __( 'All Products', 'bug-library' ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugcaturi ) . "'>" . __( 'All Products', 'bug-library' ) . "</a><br />"; } foreach ( $products as $product ) { $bugcategoryarray = explode( ",", $bugcategorylist ); if ( ( $bugcategorylist != '' && in_array( $product->term_id, $bugcategoryarray ) ) || $bugcategorylist == '' ) { if ( $product->term_id == $bugcatid ) { $output .= "<span id='bug-library-filter-currentproduct'>" . esc_html( $product->name ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugcaturi . $queryoperator . "bugcatid=" . intval( $product->term_id ) ) . "'>" . esc_html( $product->name ) . "</a><br />"; } } } } $output .= "</div></div>"; $output .= "<div id='bug-library-filter-types'>"; $output .= "<div id='bug-library-filter-typestitle'>" . __( 'Types', 'bug-library' ) . "</div>"; $output .= "<div id='bug-library-filter-typesitems'>"; $types = get_terms( 'bug-library-types', 'orderby=name&hide_empty=0' ); if ( $types ) { $bugtypeuri = $this->remove_querystring_var( $_SERVER['REQUEST_URI'], "bugtypeid" ); if ( strpos( $bugtypeuri, '?' ) === false ) { if ( strpos( $bugtypeuri, '&' ) === false ) { $queryoperator = '?'; } elseif ( strpos( $bugtypeuri, '&' ) !== false ) { $ampersandpos = strpos( $bugtypeuri, '&' ); $bugtypeuri = preg_replace( '/&/', '?', $bugtypeuri, 1 ); $queryoperator = '&'; } } else { $queryoperator = '&'; } if ( $bugtypeid == - 1 ) { $output .= "<span id='bug-library-filter-currentproduct'>" . __( 'All Types', 'bug-library' ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugtypeuri ) . "'>" . __( 'All Types', 'bug-library' ) . "</a><br />"; } foreach ( $types as $type ) { if ( $type->term_id == $bugtypeid ) { $output .= "<span id='bug-library-filter-currentproduct'>" . esc_html( $type->name ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugtypeuri . $queryoperator . "bugtypeid=" . intval( $type->term_id ) ) . "'>" . esc_html( $type->name ) . "</a><br />"; } } } $output .= "</div></div>"; $output .= "<div id='bug-library-filter-status'>"; $output .= "<div id='bug-library-filter-statustitle'>" . __( 'Status', 'bug-library' ) . "</div>"; $output .= "<div id='bug-library-filter-statusitems'>"; $statuses = get_terms( 'bug-library-status', 'orderby=name&hide_empty=0' ); if ( $statuses ) { $bugstatusuri = $this->remove_querystring_var( $_SERVER['REQUEST_URI'], "bugstatusid" ); if ( strpos( $bugstatusuri, '?' ) === false ) { if ( strpos( $bugstatusuri, '&' ) === false ) { $queryoperator = '?'; } elseif ( strpos( $bugstatusuri, '&' ) !== false ) { $ampersandpos = strpos( $bugstatusuri, '&' ); $bugstatusuri = preg_replace( '/&/', '?', $bugstatusuri, 1 ); $queryoperator = '&'; } } else { $queryoperator = '&'; } if ( $bugstatusid == - 1 ) { $output .= "<span id='bug-library-filter-currentstatus'>" . __( 'All Statuses', 'bug-library' ) . "</span><br />"; } else { $output .= "<a href='" . $bugstatusuri . "'>" . __( 'All Statuses', 'bug-library' ) . "</a><br />"; } foreach ( $statuses as $status ) { if ( $status->term_id == $bugstatusid ) { $output .= "<span id='bug-library-filter-currentproduct'>" . esc_html( $status->name ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugstatusuri . $queryoperator . "bugstatusid=" . intval( $status->term_id ) ) . "'>" . esc_html( $status->name ) . "</a><br />"; } } } $output .= "</div></div>"; $output .= "<div id='bug-library-filter-priorities'>"; $output .= "<div id='bug-library-filter-prioritiestitle'>" . __( 'Priorities', 'bug-library' ) . "</div>"; $output .= "<div id='bug-library-filter-prioritiesitems'>"; $priorities = get_terms( 'bug-library-priority', 'orderby=name&hide_empty=0' ); if ( $priorities ) { $bugpriorityuri = $this->remove_querystring_var( $_SERVER['REQUEST_URI'], "bugpriorityid" ); if ( strpos( $bugpriorityuri, '?' ) === false ) { if ( strpos( $bugpriorityuri, '&' ) === false ) { $queryoperator = '?'; } elseif ( strpos( $bugpriorityuri, '&' ) !== false ) { $ampersandpos = strpos( $bugpriorityuri, '&' ); $bugpriorityuri = preg_replace( '/&/', '?', $bugpriorityuri, 1 ); $queryoperator = '&'; } } else { $queryoperator = '&'; } if ( $bugpriorityid == - 1 ) { $output .= "<span id='bug-library-filter-currentpriorities'>" . __( 'All Priorities', 'bug-library' ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugpriorityuri ) . "'>" . __( 'All Priorities', 'bug-library' ) . "</a><br />"; } foreach ( $priorities as $priority ) { if ( $priority->term_id == $bugpriorityid ) { $output .= "<span id='bug-library-filter-currentproduct'>" . esc_html( $priority->name ) . "</span><br />"; } else { $output .= "<a href='" . esc_url( $bugpriorityuri . $queryoperator . "bugpriorityid=" . intval( $priority->term_id ) ) . "'>" . esc_html( $priority->name ) . "</a><br />"; } } } $output .= "</div></div>"; $output .= "</div>"; } if ( $bugs ) { $output .= "<div id='bug-library-item-table'>"; $counter = 1; foreach ( $bugs as $bug ) { $productversion = get_post_meta( $bug['ID'], "bug-library-product-version", true ); $reportername = get_post_meta( $bug['ID'], "bug-library-reporter-name", true ); if( !empty( $reportername ) ) { $user_data = get_user_by( 'login', $reportername ); if ( false === $user_data ) { $cleanreportername = $reportername; } else { $cleanreportername = $user_data->display_name; } } else { $cleanreportername = ''; } $reporteremail = get_post_meta( $bug['ID'], "bug-library-reporter-email", true ); $resolutiondate = get_post_meta( $bug['ID'], "bug-library-resolution-date", true ); $resolutionversion = get_post_meta( $bug['ID'], "bug-library-resolution-version", true ); $assigneduserid = get_post_meta( $bug['ID'], "bug-library-assignee", true ); $dateformat = get_option( "date_format" ); $output .= "<table>\n"; $output .= "<tr id='" . ( $counter % 2 == 1 ? 'odd' : 'even' ) . "'><td id='bug-library-type'><div id='bug-library-type-" . esc_html( $bug['typeslug'] ); $output .= "'>" . esc_html( $bug['typename'] ) . "</div></td><td id='bug-library-title'><a href='" . get_permalink( $bug['ID'] ) . "'>" . esc_html( $bug['post_title'] ) . "</a></td>"; $output .= "</tr>"; $output .= "<tr id='" . ( $counter % 2 == 1 ? 'odd' : 'even' ) . "'><td id='bug-library-data' colspan='2'>ID: <a href='" . get_permalink( $bug['ID'] ) . "'>"; $output .= intval( $bug['ID'] ) . "</a> " . __( 'Product', 'bug-library' ) . ": " . esc_html( $bug['productname'] ); $output .= " Version: " . ( $productversion != '' ? esc_html( $productversion ) : 'N/A' ); $output .= " " . __( 'Report Date', 'bug-library' ) . ": " . date_i18n( $dateformat, $bug['bug_date_unix'] ) . "</td></tr>"; $output .= "<tr id='" . ( $counter % 2 == 1 ? 'odd' : 'even' ) . "'><td id='bug-library-data2' colspan='2'>" . __( 'Status', 'bug-library' ) . ": " . esc_html( $bug['statusname'] ); if ( $showpriority ) { $output .= " " . __( 'Priority', 'bug-library' ) . ": " . esc_html( $bug['priorityname'] ); } if ( $showreporter ) { $output .= " " . __( 'Reporter', 'bug-library' ) . ": " . esc_html( $cleanreportername ); } $output .= "</td></tr>"; if ( $showassignee && $assigneduserid != - 1 && $assigneduserid != '' ) { $output .= "<tr id='" . ( $counter % 2 == 1 ? 'odd' : 'even' ) . "'><td id='bug-library-data' colspan='2'>\n"; $firstname = get_user_meta( $bug['ID'], 'first_name', true ); $lastname = get_user_meta( $bug['ID'], 'last_name', true ); $assigneedata = get_userdata( $assigneduserid ); $output .= __( "Assigned to", 'bug-library' ) . ": "; if ( $firstname != '' || $lastname != '' ) { $output .= esc_html( $firstname . " " . $lastname ); } else { $output .= esc_html( $assigneedata->user_login ); } $output .= "</td></tr>\n"; } $counter ++; $output .= "</table>\n"; } $previouspagenumber = $pagenumber - 1; $nextpagenumber = $pagenumber + 1; $dotbelow = false; $dotabove = false; $currentpageuri = $this->remove_querystring_var( $_SERVER['REQUEST_URI'], "bugpage" ); $currentpageuri = $this->remove_querystring_var( $currentpageuri, "page_id" ); if ( strpos( $currentpageuri, '?' ) === false ) { if ( strpos( $currentpageuri, '&' ) === false ) { $queryoperator = '?'; } elseif ( strpos( $currentpageuri, '&' ) !== false ) { $ampersandpos = strpos( $currentpageuri, '&' ); $currentpageuri = preg_replace( '/&/', '?', $currentpageuri, 1 ); $currentpageuri = '&'; } } else { $queryoperator = '&'; } if ( $numberofpages > 1 && $view == 'list' ) { $output .= "<div class='bug-library-pageselector'>"; if ( $pagenumber != 1 ) { $output .= "<span class='bug-library-previousnextactive'>"; $output .= "<a href='" . esc_url( $currentpageuri . $queryoperator . "page_id=" . get_the_ID() . "&bugpage=" . intval( $previouspagenumber ) ) . "'>" . __( 'Previous', 'bug-library' ) . "</a>"; $output .= "</span>"; } else { $output .= "<span class='bug-library-previousnextinactive'>" . __( 'Previous', 'bug-library' ) . "</span>"; } for ( $counter = 1; $counter <= $numberofpages; $counter ++ ) { if ( $counter <= 2 || $counter >= $numberofpages - 1 || ( $counter <= $pagenumber + 2 && $counter >= $pagenumber - 2 ) ) { if ( $counter != $pagenumber ) { $output .= "<span class='bug-library-unselectedpage'>"; } else { $output .= "<span class='bug-library-selectedpage'>"; } $output .= "<a href='" . esc_url( $currentpageuri . $queryoperator . "page_id=" . get_the_ID() . "&bugpage=" . intval( $counter ) ) . "'>" . intval( $counter ) . "</a>"; $output .= "</a></span>"; } if ( $counter >= 2 && $counter < $pagenumber - 2 && $dotbelow == false ) { $output .= "..."; $dotbelow = true; } if ( $counter > $pagenumber + 2 && $counter < $numberofpages - 1 && $dotabove == false ) { $output .= "..."; $dotabove = true; } } if ( $pagenumber != $numberofpages ) { $output .= "<span class='bug-library-previousnextactive'>"; $output .= "<a href='" . esc_url( $currentpageuri . $queryoperator . "page_id=" . get_the_ID() . "&bugpage=" . intval( $nextpagenumber ) ) . "'>" . __( 'Next', 'bug-library' ) . "</a>"; $output .= "</span>"; } else { $output .= "<span class='bug-library-previousnextinactive'>" . __( 'Next', 'bug-library' ) . "</span>"; } $output .= "</div>"; } $output .= "</div>"; } else { $output .= "<div id='bug-library-item-table'>"; $output .= __( "There are 0 bugs to view based on the currently selected filters.", 'bug-library' ); $output .= "</div>"; } $output .= "</div>"; $output .= "<script type='text/javascript'>"; $output .= "/* <![CDATA[ */"; $output .= "jQuery(document).ready(function() {"; $output .= "\tjQuery('#bug-library-filterchange').click(function() { jQuery('#bug-library-filters').slideToggle('slow'); });"; $queryarray = array( 'bug_library_popup_content' => 'true' ); if ( $bugcatid != - 1 ) { $queryarray['bugcatid'] = intval( $bugcatid ); } $target_address = add_query_arg( $queryarray, home_url() ); $output .= "\tjQuery('#submitnewissue').colorbox({href:'" . esc_url( $target_address ) . "', opacity: 0.3, iframe:true, width:'580px', height:'720px'});"; $output .= "});"; $output .= "/* ]]> */"; $output .= "</script>"; return $output; } /********************************************** Function to Process [bug-library] shortcode *********************************************/ function bug_library_func( $atts ) { extract( shortcode_atts( array( 'bugcategorylist' => '', 'bugtypeid' => '', 'bugstatusid' => '', 'bugpriorityid' => '' ), $atts ) ); $genoptions = get_option( 'BugLibraryGeneral' ); $genoptions = wp_parse_args( $genoptions, $this->bl_reset_gen_settings( 'return' ) ); return $this->BugLibrary( $genoptions['entriesperpage'], $genoptions['moderatesubmissions'], sanitize_text_field( $bugcategorylist ), $genoptions['requirelogin'], $genoptions['permalinkpageid'], $genoptions['showpriority'], $genoptions['showreporter'], $genoptions['showassignee'], sanitize_text_field( $bugtypeid ), sanitize_text_field( $bugstatusid ), sanitize_text_field( $bugpriorityid ) ); } function conditionally_add_scripts_and_styles( $posts ) { if ( empty( $posts ) ) { return $posts; } $load_jquery = false; $load_fancybox = false; $load_style = false; if ( is_admin() ) { $load_jquery = false; $load_fancybox = false; $load_style = false; } else { foreach ( $posts as $post ) { $buglibrarypos = stripos( $post->post_content, 'bug-library' ); if ( $buglibrarypos !== false ) { $load_jquery = true; $load_fancybox = true; $load_style = true; } } } global $blstylesheet; if ( $load_style ) { global $blstylesheet; $blstylesheet = true; } else { global $blstylesheet; $blstylesheet = false; } if ( $load_jquery ) { wp_enqueue_script( 'jquery' ); } if ( $load_fancybox ) { wp_enqueue_script( 'colorbox', plugins_url( 'colorbox/jquery.colorbox-min.js', __FILE__ ), array( 'jquery' ), "1.3.9" ); wp_enqueue_style( 'colorboxstyle', plugins_url( 'colorbox/colorbox.css', __FILE__ ) ); } return $posts; } function bl_template_redirect( $template ) { if ( !empty( $_GET['bug_library_popup_content'] ) ) { require_once plugin_dir_path( __FILE__ ) . 'submitnewissue.php'; exit; } else { return $template; } } } $my_bug_library_plugin = new bug_library_plugin(); ?>