ka2

Okay, I should be thanking you.

Because I was recently also published the specifications of the filter hooks, it was a good experience to be able to introduce the mechanism of per that.

Thank you for your inquiry.

Yes, you can add the custom fields and customize the process at the time of updating data. I will introduce the sample code as an example below.

Sample table:

CREATE TABLE wp_products (
  ProductID bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product ID',
  ProductName varchar(200) NOT NULL,
  Quantity int(11) unsigned NOT NULL DEFAULT '0',
  created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Created Datetime',
  updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated Datetime',
  PRIMARY KEY (ProductID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

Sample Post:

[cdbt-edit table="wp_products"]

Filter hooks: (“functios.php” in theme)

function add_custom_field_wp_products( $elements_options, $shortcode_name, $table ){
  if ( is_null( get_post() ) && 'cdbt-entry' === $shortcode_name && 'wp_products' === $table ) {
    $elements_options[] = [
      'elementName' => 'ChangeQuantity',
      'elementLabel' => 'Addition/Subtraction',
      'elementType' => 'number',
      'isRequired' => false,
      'defaultValue' => 0,
      'placeholder' => 'Enter changing quantity',
      'addClass' => '',
      'selectableList' => '',
      'horizontalList' => false,
      'elementSize' => 2,
      'helperText' => '',
      'elementExtras' => []
    ];
    $element_order = [0,1,3,2];
    array_multisort( $element_order, $elements_options );
  }
  return $elements_options;
}
add_filter( 'cdbt_shortcode_custom_forms', 'add_custom_field_wp_products', 10, 3 );

function custom_update_wp_products( $data, $table_name, $data_field_format ){
  if ( ! is_admin() && 'wp_products' === $table_name && isset( $_POST['custom-database-tables']['ChangeQuantity'] ) ) {
    if ( intval( $_POST['custom-database-tables']['ChangeQuantity'] ) !== 0 ) {
      $data['Quantity'] += intval( $_POST['custom-database-tables']['ChangeQuantity'] );
    }
  }
  return $data;
}
add_filter( 'cdbt_before_update_data', 'custom_update_wp_products', 10, 3 );

By the above code, you can have the additional field for addition or subtraction and custom update process. I have uploaded the demo page of this sample, please try to see.

Please refer below full description for each filters (sorry in Japanese only).

https://ka2.org/cdbt/v2/filter-reference/cdbt_shortcode_custom_forms/
https://ka2.org/cdbt/v2/filter-reference/cdbt_before_update_data/

Thank you,

Thank you very much for reporting.

Please tell me the string of datetime format that you have changed.

Currently, I was knowing that there is a problem with the process of converting the datetime format, then I’m fixing that bug. At the same time I want to respond to be able to resolve your trouble.

Thank you,

Was examined, it seems there is a problem with the Chrome browser(version 49.x) side.

https://bugs.chromium.org/p/chromium/issues/detail?id=581925

Please update chrome browser (to version 50.0.x).

Sorry for my late reply.

You need to be careful about the uppercase/lowercase of alphabet of the column named as aliased. At the property values of the column definition, you must be the same of aliased the column name.

$_overwrite_sql = <<<SQL
SELECT count(id) AS BETS,
  Sum(IF(win_loss = 'win', 1, 0)) AS Wins,
  Sum(IF(win_loss = 'loss', 1, 0)) AS Looses,
  Sum(IF(win_loss = 'void', 1, 0)) AS Void
FROM %s;
SQL;
  $sql = sprintf( $_overwrite_sql, $table_name );

$columns[] = [
    'label' => 'BETS', // Actual displayed strings
    'property' => 'BETS', // Alias column name
    ...
  $columns[] = [
    'label' => 'Wins',
    'property' => 'Wins',
    ...

Please try again with reference to the above code.

Thank you,

Sorry, description of sample code was leaking.

if ( get_post()->ID === {Displayed Post ID} && 'cdbt-view' === $shortcode_name && 'bc_tips' === $table ) {

You should convert to post id of page that you put shortcode from the “{Displayed post ID}” in the above part of code. Or, at the “get_post()->ID === {Displayed Post ID} &&” please remove.

Thank you,

Thank you for your inquiry.

In the current plugin, the uploading of image files are supported only column of blob type. You will be able to upload common image file if the column type is the size of “mediumblob” or “longblob”.

For example, the SQL for adding a column of blob type to an existing table is as follows.

ALTER TABLE {YourTableName} ADD {NewColumnName} longblob comment 'Image File' AFTER {BeforeColumnName};

You can column added by submitting the above SQL at the “Modify Table” of the table management.

Note: the uploaded image file to blob type column will be stored directly as binary data in the table of database. Therefore future scaling taking into the storage size of the database must also be considered.

Thank you,