wpda_cached_columns ) ) { return $this->wpda_cached_columns; } $columns = parent::get_columns(); // Remove data source column. unset($columns['pub_data_source']); // Add data source column after schema name. $columns = WPDA::array_insert_after( $columns, 'pub_schema_name', array( 'pub_data_source' => __( 'Data Source', 'wp-data-access' ), ) ); return $columns; } /** * Overwrite method column_default * * Column pub_responsive should return 'Flat' or 'Responsive'. */ public function column_default( $item, $column_name ) { if ( 'pub_id' === $column_name ) { // Validate schema, table and column names $warning = WPDA::validate_names( $item['pub_schema_name'], $item['pub_table_name'] ); if ( '' !== $warning ) { return $item['pub_id'] . $warning . substr( parent::column_default( $item, $column_name ), strlen( $item['pub_id'] ) ); } } if ( 'pub_schema_name' === $column_name ) { if ( 'CPT' === $item['pub_data_source'] ) { return ''; } global $wpdb; if ( $wpdb->dbname === $item[$column_name] ) { return "WordPress database ({$item[$column_name]})"; } } if ( 'pub_data_source' === $column_name ) { switch ( $item[$column_name] ) { case 'Query': // Show SQL query. return '

' . 'Custom query ' . '' . '

'; case 'CPT': // Show CPT query. return 'Custom post type: ' . $this->render_column_content( $item, 'pub_cpt' ); default: // Show database table. return $this->render_column_content( $item, 'pub_table_name' ); } } if ( 'pub_table_name' === $column_name ) { if ( 'Query' === $item['pub_data_source'] ) { return ''; } } if ( 'pub_responsive' === $column_name ) { if ( 'Yes' === $item[$column_name] ) { return 'Responsive'; } else { return 'Flat'; } } if ( 'pub_table_options_searching' === $column_name || 'pub_table_options_ordering' === $column_name || 'pub_table_options_paging' === $column_name || 'pub_table_options_serverside' === $column_name ) { if ( 'on' === $item[$column_name] ) { return 'Yes'; } else { return 'No'; } } return parent::column_default( $item, $column_name ); } /** * Overwrites method column_default_add_action * * Add a link to show the shortcode of a data table. * * @param array $item * @param string $column_name * @param array $actions */ public function column_default_add_action( $item, $column_name, &$actions ) { parent::column_default_add_action( $item, $column_name, $actions ); // Add copy data table to actions $wp_nonce_action = "wpda-copy-{$this->table_name}"; $wp_nonce = wp_create_nonce( $wp_nonce_action ); $form_id = '_' . (self::$list_number - 1); $esc_attr = 'esc_attr'; $input_fields = $this->get_key_input_fields( $item ); $page_field = $this->page_number_item; $copy_form = << \t\t\t\t\t{$input_fields} \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t{$page_field} \t\t\t\t EOT; ?> %s ', __( 'Copy: new table name = old table name_ + n', 'wp-data-access' ), $copy_warning, "copy_form{$form_id}", __( 'Copy', 'wp-data-access' ) ); // Show Data Table shortcode directly from Data Tables main page $shortcode_enabled = 'on' === WPDA::get_option( WPDA::OPTION_PLUGIN_WPDATAACCESS_POST ) && 'on' === WPDA::get_option( WPDA::OPTION_PLUGIN_WPDATAACCESS_PAGE ); ?> %s ', __( 'Get shortcode', 'wp-data-access' ), esc_attr( $item['pub_id'] ), __( 'Shortcode', 'wp-data-access' ) ); $actions['test'] = sprintf( ' ', __( 'Test', 'wp-data-access' ), esc_attr( wp_create_nonce( "wpda-publication-{$item['pub_id']}" ) ), esc_attr( $item['pub_id'] ), __( 'Test', 'wp-data-access' ) ); } public function process_bulk_action() { if ( 'copy' === $this->current_action() ) { $wp_nonce_action = "wpda-copy-{$this->table_name}"; $wp_nonce = ( isset( $_REQUEST['_wpnonce'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['_wpnonce'] ) ) : '' ); // input var okay. if ( !wp_verify_nonce( $wp_nonce, $wp_nonce_action ) ) { die( __( 'ERROR: Not authorized', 'wp-data-access' ) ); } if ( isset( $_REQUEST['pub_id'] ) ) { $pub_id = sanitize_text_field( wp_unslash( $_REQUEST['pub_id'] ) ); // input var okay. } $unique_pu_name = $this->get_unique_pub_name( $pub_id ); global $wpdb; $pub_raw = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM `%1s` WHERE pub_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders array(WPDA::remove_backticks( $this->table_name ), $pub_id) ), 'ARRAY_A' ); if ( $wpdb->num_rows > 0 ) { $pub_raw[0]['pub_name'] = $unique_pu_name; unset($pub_raw[0]['pub_id']); $rows_inserted = $wpdb->insert( $this->table_name, $pub_raw[0] ); switch ( $rows_inserted ) { case 0: $msg = new WPDA_Message_Box(array( 'message_text' => __( 'Could not copy data table [source not found]', 'wp-data-access' ), 'message_type' => 'error', 'message_is_dismissible' => false, )); $msg->box(); break; case 1: $msg = new WPDA_Message_Box(array( 'message_text' => __( 'Data table copied', 'wp-data-access' ), )); $msg->box(); break; default: $msg = new WPDA_Message_Box(array( 'message_text' => __( 'Could not copy data table [too many rows]', 'wp-data-access' ), 'message_type' => 'error', 'message_is_dismissible' => false, )); $msg->box(); } } } else { parent::process_bulk_action(); } } protected function get_unique_pub_name( $pub_id ) { global $wpdb; $db_pub_name = $wpdb->get_results( $wpdb->prepare( 'select pub_name from `%1s` where pub_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders array(WPDA::remove_backticks( WPDA_Publisher_Model::get_base_table_name() ), $pub_id) ), 'ARRAY_A' ); if ( $wpdb->num_rows !== 1 ) { wp_die( __( 'ERROR: Data table not found', 'wp-data-access' ) ); } $i = 2; $pub_name = $db_pub_name[0]['pub_name']; $unique_pub_name = "{$pub_name}_{$i}"; $wpdb->get_results( $wpdb->prepare( "select 'x' from `%1s` where pub_name = %s", // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders array(WPDA::remove_backticks( WPDA_Publisher_Model::get_base_table_name() ), $unique_pub_name) ) ); while ( $wpdb->num_rows > 0 ) { // Search until a free options set is found $i++; $unique_pub_name = "{$pub_name}_{$i}"; $wpdb->get_results( $wpdb->prepare( "select 'x' from `%1s` where pub_name = %s", // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders array(WPDA::remove_backticks( WPDA_Publisher_Model::get_base_table_name() ), $unique_pub_name) ) ); } return $unique_pub_name; } public static function column_headers_labels() { return array( 'pub_id' => __( 'ID', 'wp-data-access' ), 'pub_name' => __( 'Name', 'wp-data-access' ), 'pub_schema_name' => __( 'Database', 'wp-data-access' ), 'pub_data_source' => __( 'Data Source', 'wp-data-access' ), 'pub_table_name' => __( 'Table/View Name', 'wp-data-access' ), 'pub_column_names' => __( 'Column Names', 'wp-data-access' ), 'pub_format' => __( 'Format', 'wp-data-access' ), 'pub_query' => __( 'Query', 'wp-data-access' ), 'pub_sort_icons' => __( 'Sort Icons', 'wp-data-access' ), 'pub_styles' => __( 'Styling', 'wp-data-access' ), 'pub_style_premium' => __( 'Enable Premium Styling', 'wp-data-access' ), 'pub_style_user' => __( 'Custom Style', 'wp-data-access' ), 'pub_style_color' => __( 'Style Color', 'wp-data-access' ), 'pub_style_space' => __( 'Style Spacing', 'wp-data-access' ), 'pub_style_corner' => __( 'Style Corner', 'wp-data-access' ), 'pub_style_modal_width' => __( 'Modal Width', 'wp-data-access' ), 'pub_responsive' => __( 'Output', 'wp-data-access' ), 'pub_table_options_searching' => __( 'Searching?', 'wp-data-access' ), 'pub_table_options_ordering' => __( 'Ordering?', 'wp-data-access' ), 'pub_table_options_paging' => __( 'Paging?', 'wp-data-access' ), 'pub_table_options_serverside' => __( 'Server Side Processing?', 'wp-data-access' ), 'pub_table_options_nl2br' => __( 'NL > BR', 'wp-data-access' ), 'pub_table_options_advanced' => __( 'Advanced Options', 'wp-data-access' ), 'pub_default_where' => __( 'Default Where', 'wp-data-access' ), 'pub_default_orderby' => __( 'Default Order By', 'wp-data-access' ), 'pub_responsive_popup_title' => __( 'Popup Title', 'wp-data-access' ), 'pub_responsive_cols' => __( 'Responsive Cols', 'wp-data-access' ), 'pub_responsive_type' => __( 'Responsive Type', 'wp-data-access' ), 'pub_responsive_modal_hyperlinks' => __( 'Modal Hyperlinks', 'wp-data-access' ), 'pub_responsive_icon' => __( 'Responsive Icon?', 'wp-data-access' ), 'pub_flat_scrollx' => __( 'Horizontal Scrollbar', 'wp-data-access' ), 'pub_extentions' => __( 'Extensions', 'wp-data-access' ), 'pub_cpt' => __( 'Custom post type', 'wp-data-access' ), 'pub_cpt_fields' => __( 'Custom fields', 'wp-data-access' ), 'pub_cpt_query' => __( 'CPT query', 'wp-data-access' ), 'pub_cpt_format' => __( 'Field labels', 'wp-data-access' ), ); } // Overwrite method public function show() { parent::show(); WPDA::shortcode_popup(); ?>