Table Name: prefix . $customTableName); ?>
| Changes: | ';
if (empty($change_list['added']) === false) {
echo '';
echo '| New columns: | ';
echo '' . Acfct_utils::get_span_tags_from_array($change_list['added']) . ' | ';
echo '
';
}
if (empty($change_list['updated']) === false) {
echo '';
echo '| Updated columns: | ';
echo '' . Acfct_utils::get_span_tags_from_array($change_list['updated']) . ' | ';
echo '
';
}
if (empty($change_list['deleted']) === false) {
echo '';
echo '| Deleted columns: | ';
echo '' . Acfct_utils::get_span_tags_from_array($change_list['deleted']) . ' | ';
echo '
';
}
}
?>
To apply these updates to your custom table, you need to run the update process on the Manage Tables screen.
">Go to Manage Tables
1) {
echo '
MySQL reserved keywords ' . Acfct_utils::get_span_tags_from_array($validate['invalid_columns']) . ' are not allowed as a column name
';
} else {
echo '
MySQL reserved keyword ' . Acfct_utils::get_span_tags_from_array($validate['invalid_columns']) . ' is not allowed as a column name
';
}
}
if (empty($validate['duplicate_columns']) === false) {
$duplicate_columns = "";
foreach ($validate['duplicate_columns'] as $column) {
$duplicate_columns .= "
$column";
}
echo '
Duplicate field names found: ' . wp_kses($duplicate_columns, ['span' => ['style'=>[], 'class'=>[]]]) . ' Please use unique name.
';
}
?>
is_table_data_fetched($acf_field_group_key)) {
return $GLOBALS[$key];
}
$acf_field_groups = Acfct_utils::get_acf_field_groups_meta($post_id);
foreach ($acf_field_groups as $field_group) {
$table_name = $field_group['table'];
$acf_post_id = $field_group['id'];
if ($this->is_table_data_fetched($field_group['key'])) {
continue;
}
$tableInstance = new Acfct_table_data(Acfct_utils::format_post_id($post_id), $table_name);
$tableInstance->fetchValues($acf_post_id);
$GLOBALS['acf_ct_loaded_' . $field_group['key']] = $tableInstance;
/**
* For non-local json mode, field parent is field_group id.
*/
$GLOBALS['acf_ct_loaded_' . $field_group['id']] = $tableInstance;
}
// if null then that means group is not present. ACF field group is not present in the DB.
return array_key_exists($key, $GLOBALS) ? $GLOBALS[$key] : null;
}
public function acf_ct_field_group_custom_table_settings()
{
add_meta_box('acf-field-group-custom-table-settings', ACF_CT_PLUGIN_NAME, function () {
include_once ACF_CUSTOM_TABLE_PATH . 'includes/views/acf-field-group-settings.php';
}, 'acf-field-group', 'normal');
}
/**
* Load custom js on acf setting page
*/
public function acf_ct_inject_custom_js()
{
?>
field_type
*/
$acf_ct_field_type_map[$field['ID']] = $field['type'];
/**
* List of types for which exclude column setting will not be shown
*/
$blacklisted_parent_types = array('flexible_content', 'repeater');
$blacklisted_field_types = array('group', 'message', 'accordion', 'tab');
/**
* Exclude column settings
*/
if (in_array($field['type'], $blacklisted_field_types) === false && in_array($parent_type, $blacklisted_parent_types) === false) {
acf_render_field_setting($field, array(
'label' => 'Exclude Column?',
'instructions' => 'The column will not be created in custom table and data will be saved in post meta',
'name' => 'acf_ct_exclude_column',
'type' => 'true_false',
'ui' => 1,
), true);
}
/**
* Read only settings
*/
$blacklisted_read_only_parent_types = array('flexible_content', 'repeater');
$blacklisted_read_only_field_types = array('group', 'message', 'accordion', 'tab', 'flexible_content',
'repeater', 'gallery', 'file', 'wysiwyg', 'radio',
'checkbox', 'button_group', 'link', 'relationship', 'taxonomy',
'date_time_picker', 'time_picker', 'color_picker', 'image', 'true_false');
if (in_array($field['type'], $blacklisted_read_only_field_types) === false && in_array($parent_type, $blacklisted_read_only_parent_types) === false) {
acf_render_field_setting($field, array(
'label' => 'Read Only',
'instructions' => 'Only Administrator can edit this field. Other role users can only view the field.',
'name' => 'acf_ct_read_only_field',
'type' => 'true_false',
'ui' => 1
), true);
}
}
/**
* Delete custom table row on post deleted
* @param $post_id
*/
public function delete_custom_table_row($post_id)
{
$custom_tables = Acfct_utils::get_custom_table_names_of_post($post_id);
if (empty($custom_tables) === true) {
return;
}
global $wpdb;
/**
* Delete row of custom table where post_id = $post_id
*/
foreach ($custom_tables as $custom_table) {
$delete_query = 'DELETE FROM ' . $custom_table . ' WHERE ' . ACF_CUSTOM_TABLE_POST_ID_COLUMN . ' = "' . $post_id . '"';
$wpdb->query($delete_query);
}
}
public function acf_ct_filter_pre_load_value($value, $post_id = false, $field = array())
{
$is_get_field_support_disabled = apply_filters('acf_ct/settings/disable_get_field_support', false);
if (is_admin() === true || $is_get_field_support_disabled === true) {
return null;
}
$selector = $field['name'];
$columns = $this->get_columns_map($post_id);
if (empty($columns) === true) {
return null;
}
/**
* Check whether column exists for selector
*/
$column_meta = array_filter($columns, function ($column) use ($selector) {
return $column['name'] === $selector;
});
/**
* return null if column not exists
*/
if (empty($column_meta)) {
return null;
}
/**
* Fetch data from db
*/
$table = current($column_meta)['table'];
$data = get_custom_table_fields($table, false, $post_id);
if (is_array($data) && array_key_exists($selector, $data)) {
return acf_ct_unserialize($data[$selector]);
}
return null;
}
public function acf_ct_filter_pre_update_value($check, $value, $post_id, $field)
{
$is_update_field_support_disabled = apply_filters('acf_ct/settings/disable_update_field_support', false);
if (
// if update field support is disabled
$is_update_field_support_disabled === true ||
// if current request is post update request
(is_admin() === true && $_SERVER['REQUEST_METHOD'] === 'POST' && $_REQUEST['action'] === 'editpost') ||
// if current request is ACF frontend form update request
($_SERVER['REQUEST_METHOD'] === 'POST' && $_REQUEST['_acf_screen'] === 'acf_form')
) {
return null;
}
$selector = $field['name'];
$columns = $this->get_columns_map($post_id);
if (empty($columns) === true) {
return null;
}
/**
* Check whether column exists for selector
*/
$column_meta = array_filter($columns, function ($column) use ($selector) {
return $column['name'] === $selector;
});
/**
* return null if column not exists
*/
if (empty($column_meta)) {
return null;
}
$table = current($column_meta)['table'];
return update_custom_table_field($table, [$selector => $value], $post_id);
}
/**
* Add column in field group table
*
* @param $columns
* @return mixed
*/
public function acf_ct_field_group_columns($columns)
{
$columns['acf-ct-table-name'] = __('Custom Table');
return $columns;
}
/**
* Render field group column data
*
* @param $column
* @param $post_id
*/
public function acf_ct_field_group_column_html($column, $post_id)
{
if ($column === 'acf-ct-table-name') {
$tableName = Acfct_utils::get_custom_table_name($post_id, true);
if (empty($tableName)) {
echo "-";
return;
}
$url = Acfct_utils::get_manage_table_page_url($post_id);
$status = Acf_ct_database_manager::get_acf_fields_change_list($post_id);
$label = false;
if (is_array($status)) {
if (array_key_exists('created', $status) && $status['created'] === true) {
$label = 'Create Table';
} else if (array_key_exists('should_update', $status) && $status['should_update'] === true) {
$label = 'Update Table';
}
}
echo '