getAdminNotice()))
{
echo sprintf('
',
$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 .= '| '.__('Column Name', 'acfict').' | '.__('Modification', 'acfict').' |
';
foreach( $response as $column => $text) {
$notice .= sprintf('| %s | %s |
', $column, $text);
}
$notice .= '
';
$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();
}