=== CustomTables - Create, Read, Update, and Delete ===
Contributors: ivankomlev
Author URI: https://ct4.us
Donate link: https://www.patreon.com/joomlaboat
Tags: custom tables, custom database tables, database, catalog, forms
Requires at least: 6.0
Tested up to: 6.9.4
Stable tag: 1.7.4
Requires PHP: 7.4
License: GPLv2
License URI: https://www.gnu.org/licenses/gpl-2.0.html

The Custom Tables plugin allows you to create and manage custom database tables, display catalogs, forms, and tables using Twig templating language.

== Description ==

**Unlock Custom Data Structures and Dynamic Layouts with Custom Tables**

Take your WordPress site to the next level with Custom Tables, a powerful plugin that lets you create custom database tables, fields, and layouts. With its versatility and flexibility, you can build anything from catalogs to edit forms, detail pages, and more.

**Demo:** [Try Custom Tables in action](https://tastewp.org/plugins/customtables/) (right-click to open in a new tab)

**Key Features**:

Twig Template Language Support: Create dynamic layouts with ease using the modern Twig template language.
31 Field Types: Choose from Integer, Decimal, Text String, Date, Email, Color, Image, and more to create complex data structures.
Layout Editor: Simplify layout creation with the Auto-Create button, which generates a layout based on your table fields.
Secure and Sanitized: All tables are stored in MySQL, with queries and field values properly sanitized for added security.

= Introduction =

[youtube https://www.youtube.com/watch?v=Dq3jbk9JaJY]
[youtube https://www.youtube.com/watch?v=qehcUdr7vk0]

= More information =
Visit [ct4.us](https://ct4.us/) for more information, take a look at [wiki](https://github.com/joomlaboat/custom-tables/wiki).

== Screenshots ==

1. "Create Table" screen
2. "Add Fields" screen
3. "Add Custom Tables Block" screen
4. "Select Layout Type and Table" screen

== Frequently Asked Questions ==

= Do you have any questions? =

[Please contact us here with your query.](https://ct4.us/contact-us/)

== Changelog ==

= 1.7.4 =
- {{ html.search() }} tag improved - Inner Join filter added.

= 1.7.3 =
- {{ html.searchrange() }} tag added.
- Table Field Add and Updated method fixed.

= 1.7.2 =
- Added database query caching for frequently requested data (Languages, User Groups, User Details, Layout, Table Details, and Field Lists), significantly improving page load speed.

= 1.7.1 =
- {{ html.search() }} button icon fixed.
- {{ html.searchreset() }} button label and icon fixed.

= 1.7.0 =
- Import tables duplicate field records bug fixed.

= 1.6.9 =
- {{ tables.sqlselect() }} tag added.

= 1.6.8 =
- PHP 8.4 Warnings fixed.

= 1.6.7 =
- PHP 8.4 Compatibility Warnings fixed. CT Library Updated.

= 1.6.6 =
- CT and Twig Libraries Updated.

= 1.6.5 =
- CT Library Updated.

= 1.6.4 =
- Output bug fixed.

= 1.6.3 =
- Fixed update server URL.
- Added “Alias File Type” option to control output MIME type. If the alias ends with .json, .csv, etc., the appropriate Content-Type header will be sent.
- Added MIME Type selection field to the Layout editor for customizing content output formatting.


= 1.6.2 =
- {{ url.base64 }} tag added.
- Filebox Fixed
- Return To link fixed.
- Image field type: Image size variants fixed. Path to upload images - fixed.
- Edit draft field - fixed.

= 1.6.1 =
- Detailed page record loaded check added.
- Twig filters added: |trim, |lower, |upper, |int, |float

= 1.6.0 =
- JavaScript methods added: CTEditHelper.loadRecord() and CTEditHelper.loadRecordLayout() JavaScript methods added.

= 1.5.9 =
- Added "Show Published" filter in Layout Editor
- Improved hint text in Virtual Select boxes
- Required field (*) mark now works in all forms, including popups
- Date picker format check added
- Removed inline style from date search bar
- Creation Time field can now be set and edited
- CSV import skips empty records
- Fixed required field check in popup windows
- Added new JS API methods: add/save/publish/unpublish/refresh/copy/delete record
- Fixed double HTML encoding issue
- Fixed rare Table Join bug in catalog value edit
- Virtual Select for Table Join improved
- Tags {{ record.sum }}, {{ record.min }}, {{ record.max }} now return decimal values

= 1.5.8 =
- Fixed import issue when tables have different field prefixes.
- Fixed addForeignKey for user fields.
- Fixed removeForeignKey.
- {{ html.pagination }} added to Auto Layout Creator (WP) & default simple catalog layout.
- Search by exact date in datetime fields added.
- Date field search now applies global search filter.
- Fixed ordering by User Field in WP.
- Fixed current language detection in WP.
- Error message text improved for better clarity.
- Fixed domain validation bug in URL Field type.
- Fixed Lookup Table self-parent value selection issue.
- Fixed delete confirmation message (now correctly shows item name instead of ID).
- Prevented duplicate JS function declarations.
- Added a new virtual field option: Stored Decimal.

= 1.5.7 =
- Short Code: Error reporting improved.
- Virtual Field Type: Stored Decimal option added.
- Lookup Table self parent value selection bug fixed.
- Save Single value in the catalog bug fixed.
- URL Field type: Domain validation bug fixed.
- Get Return To URL fixed.

= 1.5.6 =
- Import tables from tables with different field prefix issue has been fixed.

= 1.5.5 =
- User Field type added.
- Order by User Field fixed.

= 1.5.4 =
- Error messaging improved.

= 1.5.3 =
- {{ html.pagination }} tag added.
- Pagination button style can be set in the Settings.

= 1.5.2 =
- Catalog Search bug fixed. CSV Import (Lookup Table fields) bug fixed. Error reporting improved.

= 1.5.1 =
- Multilingual Text field type added.

= 1.5.0 =
- Language Field type enabled.

= 1.4.9 =
- List of Fields: Search fixed.
- List of Layouts and Tables: Search fixed.
- CT Lib updated.
- Table / Edit - Advanced Tab description improved.
- Save / add fields from Third-part table fixed (WP).

= 1.4.8 =
- Rich Text Editor feature added.

= 1.4.7 =
- Toolbar Icon type can be set in the settings.

= 1.4.6 =
- {{ html.orderby }} Tag improved.
- List of Tables bug fixed.
- JS Toolbar bugs fixed.

= 1.4.5 =
- CT library updated. Classes renamed.

= 1.4.4 =
- Table scheme view added (pro version).

= 1.4.3 =
- Layout Editor: Default Publish status parameter added.
- Edit form redirects fixed.
- In catalog unpublish a refresh icons added.

= 1.4.2 =
- Permission parameters added to Layout Editor.

= 1.4.1 =
- Front-end search redirect fixed and CT library updated.

= 1.4.0 =
- Front-end redirects and notification messages added.

= 1.3.9 =
- Table settings: Primary Key Pattern added.
- Layout Editor: Params tab added
- Filter parameter added.
- Delete field permanently -  bug fixed.

= 1.3.8 =
- Filter parameter se in the menu item cannot be overwritten by the url query parameter.
- Date Picker field label added.
- Back-end: List of records search fixed.

= 1.3.7 =
- Added {{ document.config }} parameters support for WordPress
- Introduced {{ fieldname.required(v1,v2) }} tag with conditional output
- Implemented {{ fieldname.input }} tag with comprehensive field details
- Enhanced language prefix handling for WordPress compatibility
- Fixed Layout Tag button class for WordPress
- Resolved content loading issues by removing unnecessary slashes
- Added Parameters tab with filtering capability for Catalog View
- Enhanced Layout Auto Creator with proper JSON value formatting
- Implemented “Start with” and “End with” search options
- Hidden unnecessary “%” characters in search interface
- Added minimum search string length parameter
- Fixed Image field type preview functionality
- Enhanced Catalog Item delete JavaScript functionality
- Improved date field type with enhanced description and UNIX format conversion

= 1.3.6 =
- Added {{ document.config() }} tag
- Enabled Server field type for WordPress
- Improved Table Join description
- Added Google Map With Markers to Layout Auto Creator
- Added Edit form shortcode view (WordPress)
- Fixed Text Area field type description
- Resolved WordPress edit form issues

= 1.3.5 =
- Server Info field type added.

= 1.3.4 =
- Shortcode tag added. Example [customtables table="countries"]

= 1.3.3 =
- Image Gallery field type added.

= 1.3.2 =
- Listing IDs now stored as strings.
- Back-end: Record lists display processed values.
- Fixed Table Join field params config bug.
- Added Table Join List field type.
- Resolved table import issues.

= 1.3.1 =
- Custom field prefixes are set automatically for ol tables
- Custom Tables Library updated - code cleaned.

= 1.3.0 =
- Custom field prefix can be set.

= 1.2.9 =
- {{ url.getwhere('param') }} tag added.
- Added support for the 'Filter' parameter, now functional with Custom Tables Block.
- Implemented 'Group By' functionality for the {{ tables.getrecords() }} tag.
- Optimized CSS handling by merging styles across multiple blocks, ensuring only unique styles are retained.
- Updated Layout Editor: When 'Catalog Layout' is selected, the following layout types can now be chosen: Catalog, XML, CSV, or JSON.

= 1.2.8 =
Bags fixed. CT Lib updated.

= 1.2.7 =
Layout select box only contains layouts that have the same type as the selected above.
Tech-Support links added. Sub menu links fixed.
Full link Url to images fixed. On some websites trailing slash is needed.
Back-end forms improved. Cancel buttons added. Go back to Tables buttons added.
Record edit form layout improved - unnecessary elements deleted, such as legend and {{ html.goback() }}
Table Join field type added.

= 1.2.6 =
Block property panel: Layout selection depends on the Type.
Field names may include uppercase characters.

= 1.2.5 =
CSV file import feature added to the List of Records page.

= 1.2.4 =
The following field types have been added: User Group, User Groups, User Author (record author), File Link, Log, Auto-increment ID, Color, and Google Maps (GPS coordinates).

= 1.2.3 =
New field types added: File, Blob, Creation Time, Change Time, MD5, and Virtual.

= 1.2.2 =
Image field type added.

= 1.2.1 =
Date method bugs fixed.

= 1.2.0 =
Layout Auto Create feature added.

= 1.1.9 =
CT Library updated, and the main plugin file renamed - fixed activation bug.

= 1.1.8 =
Date Time Field type option added. DatePicker replaced with DateTimePicker for enhanced functionality.

= 1.1.7 =
Twig Library updated, CT Library updated.
Date Field type added.
CSS style class file loads properly. Field type property null check added.

= 1.1.6 =
{{ html.captcha() }} Twig Tag has been added.

= 1.1.5 =
First public WordPress plugin release.

== Upgrade Notice ==

= 1.1.5 =
* First public WordPress plugin release.

= 1.1.9 =
Main plugin file renamed - activation bug fixed.