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( 'acffict', false, dirname( plugin_basename( ACF_FICT_PLUGIN_FILE ) ) . '/languages' );
}
public function registerMetaBox() {
add_meta_box('acf-field-acffict', 'ACF: Fields in Custom Table', [$this, 'renderMetaBox'], 'acf-field-group', 'normal');
}
public function renderMetaBox( )
{
global $field_group;
acf_render_field_wrap( [
'label' => __('Enabled', 'acffict'),
'instructions' => __( 'Enable Store fields in custom table for this field group?', 'acffict' ),
'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', 'acffict' ),
'instructions' => __( 'Define the custom table name. Make sure it doesn\'t conflict with others tables names.', 'acffict' ),
'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:', 'acffict').$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:', 'acffict').$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 )
)
{
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 $value;
}
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;
$query = $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table_name ) );
if ( $wpdb->get_var( $query ) === $table_name )
{
$results = $wpdb->get_results('SHOW COLUMNS FROM '.$table_name);
$missing_columns = array_diff(
array_keys($columns),
array_column($results, 'Field')
);
foreach ($missing_columns as $column_key)
{
if ( array_key_exists($column_key, $columns)) {
$wpdb->query("ALTER TABLE ".$table_name." ADD ".$columns[$column_key]." COMMENT 'Added at ".date('Y-m-d H:i:s')."' ");
if ( $wpdb->last_error ) {
return $wpdb->last_error;
}
}
}
$results = $wpdb->get_results('SHOW COLUMNS FROM '.$table_name);
$missing_columns = array_diff(
array_keys($columns),
array_column($results, 'Field')
);
return count($missing_columns) == 0 ? true : __('Unable to alter table', 'acffict');
} else
{
$create_ddl = "CREATE TABLE IF NOT EXISTS $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()};";
$wpdb->query( $create_ddl );
if ( $wpdb->last_error ) {
return $wpdb->last_error;
}
if ( $wpdb->get_var( $query ) === $table_name ) {
return true;
}
return false;
}
}
private function sanitizeInput( $value, $field )
{
$sanitized_value = null;
switch ( $field['type'] )
{
case 'text':
case 'image':
case 'email':
case 'url':
case 'password':
case 'select':
case 'color_picker':
case 'date_picker':
$sanitized_value = sanitize_text_field( $value );
break;
case 'wysiwyg':
$sanitized_value = wp_kses_post( $value );
break;
case 'textarea':
$sanitized_value = sanitize_textarea_field( $value );
break;
case 'true_false':
case 'number':
$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 'image':
case 'email':
case 'url':
case 'password':
case 'select':
$column_type = 'VARCHAR(255)';
break;
case 'color_picker':
$column_type = 'VARCHAR(7)';
break;
case 'number':
$column_type = 'NUMERIC';
break;
case 'wysiwyg':
case 'textarea':
$column_type = 'LONGTEXT';
break;
case 'date_picker':
$column_type = 'DATE';
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('acffict_notice_' . get_current_user_id(), [
'message' => $message,
'status' => $status
], 30);
}
private function getAdminNotice() {
$key = 'acffict_notice_' . get_current_user_id();
$transient = get_transient( $key );
if ( $transient ) {
delete_transient( $key );
}
return $transient;
}
}
ACF_FICT::getInstance();
}