getAdminNotice())) { echo sprintf('

%s

', $message['status'], $message['message'] ); } }); add_filter( 'acf/load_field', [$this, 'addSettingsData'] ); add_filter( 'acf/load_value', [$this, 'loadFieldFromCustomTable'], 11, 3 ); add_filter( "acf/validate_field_group", [$this, 'validateFieldGroup'] ); load_plugin_textdomain( 'acfict', false, dirname( plugin_basename( ACF_FICT_PLUGIN_FILE ) ) . '/languages' ); } public function registerMetaBox() { add_meta_box('acf-field-acfict', 'ACF: Fields in Custom Table', [$this, 'renderMetaBox'], 'acf-field-group', 'normal'); } public function renderMetaBox( ) { global $field_group; acf_render_field_wrap( [ 'label' => __('Enabled', 'acfict'), 'instructions' => __( 'Enable Store fields in custom table for this field group?', 'acfict' ), 'type' => 'true_false', 'name' => self::SETTINGS_ENABLED, 'key' => self::SETTINGS_ENABLED, 'prefix' => 'acf_field_group', 'value' => esc_attr(acf_maybe_get( $field_group, self::SETTINGS_ENABLED, false )), 'ui' => 1, ] ); acf_render_field_wrap( [ 'label' => _( 'Custom table name', 'acfict' ), 'instructions' => __( 'Define the custom table name. Make sure it doesn\'t conflict with others tables names.', 'acfict' ), 'type' => 'text', 'name' => self::SETTINGS_TABLE_NAME, 'prefix' => 'acf_field_group', 'value' => esc_attr(acf_maybe_get( $field_group, self::SETTINGS_TABLE_NAME, false )), 'prepend' => $this->getTableName(), 'required' => true, 'conditional_logic' => [ 'field' => self::SETTINGS_ENABLED, 'operator' => '==', 'value' => '1', ] ] ); ?> false, self::SETTINGS_TABLE_NAME => null ] as $key => $defaul_value) { $field[$key] = acf_maybe_get( $field_group, $key, $defaul_value ); } return $field; } public function storeFieldsInCustomTable( $post_id ) { global $wpdb; $values = []; foreach ( $_POST['acf'] as $key => $value ) { $field = get_field_object( sanitize_key( $key ) ); if ( $field[self::SETTINGS_ENABLED] && $field['name'] && $this->isFieldSupported($field) ) { $values[$field[self::SETTINGS_TABLE_NAME]][$this->sanitizeColumnName($field['name'])] = $this->sanitizeInput($value, $field); } } foreach ( $values as $table_name => $data) { $data['post_id'] = $post_id; $wpdb->suppress_errors = true; $wpdb->show_errors = false; if ( false === $wpdb->replace($this->getTableName($table_name), $data ) ) { $message = __('ACF: Fields in Custom Table error:', 'acfict').$wpdb->last_error; $this->addAdminNotice($message, 'error'); } } } public function deleteFieldsInCustomTable($post_id) { global $wpdb; foreach ( acf_get_field_groups( ['post_id' => $post_id] ) as $field_group ) { if ( array_key_exists(self::SETTINGS_TABLE_NAME, $field_group) && $field_group[self::SETTINGS_TABLE_NAME] ) { $wpdb->delete( $this->getTableName($field_group[self::SETTINGS_TABLE_NAME]), ['post_id' => $post_id] ); } } } #@todo: Restrict to only page, post and custom_post_type public function createOrUpdateTable( $field_group ) { if ( !$field_group[self::SETTINGS_ENABLED]) { return; } $columns = []; $fields = acf_get_fields( $field_group ); foreach ( $fields as $field ) { if ( false !== ( $column = $this->getColumnDefinition( $field ) ) ) { $columns[$this->sanitizeColumnName($field['name'])] = $column; } } $response = $this->doCreateOrAlterTable( $this->getTableName( $field_group[self::SETTINGS_TABLE_NAME] ), $columns ); if ( $response !== true ) { $message = __('ACF: Fields in Custom Table error:', 'acfict').$response; $this->addAdminNotice($message, 'error'); } } public function loadFieldFromCustomTable( $value, $post_id, $field ) { $table_name = $this->getTableName( $field[self::SETTINGS_TABLE_NAME] ); if ( array_key_exists(self::SETTINGS_ENABLED, $field) && $field[self::SETTINGS_ENABLED] && $this->tableExists( $table_name ) && $this->isFieldSupported($field) ) { global $wpdb; $column_name = sanitize_key($field['name']); $value = $wpdb->get_var( $wpdb->prepare( "SELECT $column_name FROM $table_name WHERE post_id = %d", $post_id )); return $this->escapeField( $value, $field ); } return $value; } public function validateFieldGroup( $field_group ) { if ( array_key_exists( self::SETTINGS_TABLE_NAME, $field_group ) ) { $field_group[self::SETTINGS_TABLE_NAME] = $this->sanitizeTableName( $field_group[self::SETTINGS_TABLE_NAME] ); } return $field_group; } private function doCreateOrAlterTable($table_name, $columns) { global $wpdb; $wpdb->suppress_errors = true; $wpdb->show_errors = false; $sql = "CREATE TABLE $table_name ( post_id bigint(20) unsigned NOT NULL, ".join(",\n\t", $columns).(count($columns) > 0 ? ',' : '')." PRIMARY KEY (post_id) ) ENGINE=InnoDB {$wpdb->get_charset_collate()};"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); $response = dbDelta( $sql ); if ( $wpdb->last_error ) { return $wpdb->last_error; } if ( count($response) > 0 ) { $notice = __('ACF: Fields in Custom Table: Database Changes', 'acfict'); $notice .= ''; $notice .= ''; foreach( $response as $column => $text) { $notice .= sprintf('', $column, $text); } $notice .= '
'.__('Column Name', 'acfict').''.__('Modification', 'acfict').'
%s%s
'; $this->addAdminNotice($notice, 'info'); } return true; } private function escapeField ( $value, $field) { switch ( $field['type'] ) { case 'select': case 'checkbox': $object = json_decode($value); $value = $object ? $object : $value; break; default: $value = $value; } return $value; } private function sanitizeInput( $value, $field ) { $sanitized_value = null; switch ( $field['type'] ) { case 'text': case 'email': case 'url': case 'password': case 'color_picker': case 'date_picker': case 'date_time_picker': case 'time_picker': case 'radio': case 'button_group': $sanitized_value = sanitize_text_field( $value ); break; case 'select': case 'checkbox': if ( is_array($value) ) { $sanitized_value = json_encode(array_map( function($item) { return sanitize_text_field($item); }, $value)); } else { $sanitized_value = sanitize_text_field( $value ); } break; case 'oembed': $sanitized_value = esc_url_raw($value); break; case 'wysiwyg': $sanitized_value = wp_kses_post( $value ); break; case 'textarea': $sanitized_value = sanitize_textarea_field( $value ); break; case 'range': case 'number': $sanitized_value = filter_var( $value, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); break; case 'image': case 'file': case 'true_false': $sanitized_value = filter_var( $value, FILTER_SANITIZE_NUMBER_INT ); break; default: $sanitized_value = ''; } return $sanitized_value; } private function sanitizeTableName($value) { return str_replace( '-','_', sanitize_key( $value ) ); } private function sanitizeColumnName($value) { return $this->sanitizeTableName($value); } private function getColumnDefinition( $field ) { $column_type = ''; switch ( $field['type'] ) { case 'text': case 'email': case 'url': case 'password': case 'radio': case 'button_group': $column_type = 'varchar(255)'; break; case 'select': case 'checkbox': $column_type = 'varchar(255)'; break; case 'file': case 'image': $column_type = 'bigint(20) unsigned'; break; case 'color_picker': $column_type = 'varchar(7)'; break; case 'range': case 'number': $column_type = 'float'; break; case 'oembed': case 'wysiwyg': case 'textarea': $column_type = 'longtext'; break; case 'date_picker': $column_type = 'date'; break; case 'date_time_picker': $column_type = 'datetime'; break; case 'time_picker': $column_type = 'time'; break; case 'true_false': $column_type = 'tinyint(1)'; break; default: $column_type = false; } $column_definition = $column_type ? sprintf('%s %s %s', $field['name'], $column_type, ($field['required'] ? 'NOT NULL' : 'NULL') ) : false ; return $column_definition; } private function getTableName($name = '') { global $wpdb; return sprintf('%s%s%s', $wpdb->prefix, 'acf_', $name); } private function isFieldSupported($field) { return $this->getColumnDefinition($field) !== false; } private function tableExists($table_name) { global $wpdb; $query = $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table_name ) ); return $wpdb->get_var( $query ) === $table_name; } private function addAdminNotice($message, $status) { set_transient('acfict_notice_' . get_current_user_id(), [ 'message' => $message, 'status' => $status ], 30); } private function getAdminNotice() { $key = 'acfict_notice_' . get_current_user_id(); $transient = get_transient( $key ); if ( $transient ) { delete_transient( $key ); } return $transient; } } ACF_FICT::getInstance(); }