__('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' => __('Use Prefix', 'acfict'),
'instructions' => __( 'Append table name with prefix', 'acfict' ),
'type' => 'true_false',
'name' => self::SETTINGS_USE_PREFIX,
'key' => self::SETTINGS_USE_PREFIX,
'prefix' => 'acf_field_group',
'value' => esc_attr(acf_maybe_get( $field_group, self::SETTINGS_USE_PREFIX, true )),
'ui' => 1,
'conditional_logic' => [
'field' => self::SETTINGS_ENABLED,
'operator' => '==',
'value' => '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->table_name(),
'required' => true,
'wrapper' => [
'class' => self::SETTINGS_TABLE_NAME.'_wrapper'
],
'conditional_logic' => [
'field' => self::SETTINGS_ENABLED,
'operator' => '==',
'value' => '1',
]
] );
?>
false,
self::SETTINGS_USE_PREFIX => true,
self::SETTINGS_TABLE_NAME => null
] as $key => $defaul_value)
{
$field[$key] = acf_maybe_get( $field_group, $key, $defaul_value );
}
return $field;
}
public function store_fields_in_custom_table( $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->is_supported($field)
) {
$column_name = acfict_sanitize_keyword($field['name']);
$values[$this->table_name($field[self::SETTINGS_TABLE_NAME], $field[self::SETTINGS_USE_PREFIX])][$column_name] = apply_filters(
'acfict_sanitize_'.$field['type'],
$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($table_name, $data ) )
{
$message = __('ACF: Fields in Custom Table error:', 'acfict').$wpdb->last_error;
acfict_admin_notice_add($message, 'error');
}
}
}
public function delete_fields_in_custom_table($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->table_name($field_group[self::SETTINGS_TABLE_NAME], $field_group[self::SETTINGS_USE_PREFIX]),
['post_id' => $post_id]
);
}
}
}
public function create_or_update_table( $field_group )
{
if ( !$field_group[self::SETTINGS_ENABLED]) {
return;
}
$columns = [];
$fields = acf_get_fields( $field_group );
foreach ( $fields as $field )
{
$column_type = apply_filters('acfict_column_type_'.$field['type'], $field);
if ( $column_type && is_a( $column_type, 'ACF_FICT_Type_Column') ) {
$columns[] = $column_type->get_definition();
}
}
$response = $this->do_create_or_alter_table(
$this->table_name( $field_group[self::SETTINGS_TABLE_NAME], $field_group[self::SETTINGS_USE_PREFIX] ),
$columns
);
if ( $response !== true ) {
$message = __('ACF: Fields in Custom Table error:', 'acfict').$response;
acfict_admin_notice_add($message, 'error');
}
}
private function do_create_or_alter_table( $table_name, $columns )
{
if (count($columns) === 0 ) {
return 'No supported fields';
}
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 .= '
';
acfict_admin_notice_add($notice, 'info');
}
return true;
}
public function load_field_from_custom_table( $value, $post_id, $field )
{
if (
!$this->is_supported( $field ) ||
!array_key_exists( self::SETTINGS_ENABLED, $field ) ||
( array_key_exists( self::SETTINGS_ENABLED, $field ) && !$field[self::SETTINGS_ENABLED] )
) {
return $value;
}
$table_name = $this->table_name( $field[self::SETTINGS_TABLE_NAME], $field[self::SETTINGS_USE_PREFIX] );
if ( $this->table_exists( $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 apply_filters('acfict_escape_'.$field['type'], $value, $field);
}
return $value;
}
public function validate_field_group( $field_group )
{
if ( array_key_exists( self::SETTINGS_TABLE_NAME, $field_group ) ) {
$field_group[self::SETTINGS_TABLE_NAME] = acfict_sanitize_keyword( $field_group[self::SETTINGS_TABLE_NAME] );
}
return $field_group;
}
private function table_name( $name = '', $use_prefix = true) {
global $wpdb;
$prefix = $use_prefix ? apply_filters('acfict_table_prefix', $wpdb->prefix.'acf_', $name) : '';
return $prefix.$name;
}
private function is_supported( $field ) {
return apply_filters('acfict_supports_'.$field['type'], false);
}
private function table_exists( $table_name )
{
global $wpdb;
$query = $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table_name ) );
return $wpdb->get_var( $query ) === $table_name;
}
public function display_admin_notices()
{
if ( false !== ($message = acfict_admin_notice_get()))
{
echo sprintf('',
$message['status'],
$message['message']
);
}
}
}
ACF_FICT::getInstance();
}