Custom Tables Plugin (Pro Version) extension for Joomla!

Enables additional functionality for Custom Tables component.

1. Content Plugins:
   

   • {customtablescatalog=...} Custom Tables Catalog - Returns a catalog results into any article or elsewhere.

   • {customtablesrecord=...} Custom Tables Record - Returns single Record by ID.

2. Additional Field Types:

   • Change Log: Logs all record modifications. User, Datetime, IP. You can return to the previous version of the record.

   • File Box: Provides Multiple File Upload functionality. It also tracks versions.

   • Image Gallery: Provides Multiple Image Upload functionality.

   • MD5 Hash: MD5 Hash calculated based on selected fields values.

   • Radio: Radio Buttons

   • Server Info: Server and execution environment variables.

3. Extended Twig Filters:
   

   • {{ 'hello world' | base64encode }} - Encodes the given string with base64.

   • {{ 'aGVsbG8gd29ybGQ=' | base64decode }} - Decodes a base64 encoded string.

   • {{ 'hello world' | md5 }} - Calculates the MD5 hash of string.

   • {{ 'hello world' | ucwords }} - Uppercase the first character of each word in a string.

   • {{ {a:1,b:2} | json_encode }} - Returns the JSON representation of a value.

   • {{ '{"a":1,"b":2}' | json_decode }} - Decodes a JSON string.

4. Additional Layout Tags:
   

   • {{ html.navigation }} - Navigation
     Navigation / Breadcrumbs. Returns a value of the filter used.

   • {{ html.orderby }} - Order By (Sort By) box
     Renders HTML Order By select box.

   • {{ html.limit }} - A select box to change the number of records per page
     Renders HTML Limit box to limit the number of records per page.

   • {{ html.captcha }} - Captcha
     Provides the use of a captcha plugin (if enabled).

   • {{ html.message }} - Alert Message
     Renders an alert message above the main content.

   • {{ html.recordlist }} - List of Records
     Comma separated list or record IDs. Example: 4,78,3,876

   • {{ html.importcsv }} - Import CSV
     Renders the 'Upload CSV file' button

   • {{ html.tablehead }} - HTML Table Head
     Renders 'thead' and 'th' HTML tags.

   • {{ record.count }} - Count
     Returns the number of records in selected table that match the filter.

   • {{ record.avg }} - Average
     Calculates the average value of all the records that match the filter.

   • {{ record.min }} - Minimum
     Returns the minimum of all the records that match the filter.

   • {{ record.max }} - Maximum
     Returns the maximum of all the records that match the filter.

   • {{ record.sum }} - Sum
     Summarizes values of a selected field of all the records that match the filter.

   • {{ record.joincount }} - Table Join - Count
     Counts records from a joined table (Table Join).

   • {{ record.joinavg }} - Table Join - Average
     Calculates the average value of all the records that match the filter.

   • {{ record.joinmin }} - Table Join - Minimum
     Finds the minimum value of all the records that match the filter.

   • {{ record.joinmax }} - Table Join - Maximum
     Finds the maximum value of all the records that match the filter.

   • {{ record.joinsum }} - Table Join - Sum
     Summarizes values of a selected field of all the records that match the filter.

   • {{ record.joinvalue }} - Table Join - Value
     Returns the value of selected field of all the records that match.

   • {{ record.jointable }} - Join Table - Table
     Returns the records from another table these that connected to current record and match the filter. Records will be formatted by selected layout.

   • {{ record.advancedjoin }} - Table Join
     Returns value of joined table field.

   • {{ record.missingfields }} - Returns a List of required fields that are missing.
     Returns a string List, separated by a Separator, of required fields (field names) that are missing or NULL.

   • {{ record.missingfieldslist }} - Returns an Array of required fields that are missing.
     Returns an Array of required fields (field names) that are missing or NULL.

   • {{ table.name }} - Table Name
     Returns the current table name.

   • {{ table.id }} - Table ID
     Returns current table ID.

   • {{ tables.getvalue }} - Get Value
     Read a record field value from selected table.

   • {{ tables.getrecord }} - Get Record
     Renders another table single record using selected layout.

   • {{ tables.getrecords }} - Get Records
     Renders another table records using selected layout.

   • {{ fields.list }} - List of field parameters
     Returns the list of fields. Example: country,city,phone

   • {{ fields.json }} - Field Json Array
     Returns the array of fields in JSON format

   • {{ user.id }} - Current User ID
     Returns Current User ID

   • {{ user.name }} - User Full Name
     Returns User full name.

   • {{ user.username }} - Username
     Returns Username.

   • {{ user.email }} - Email
     Returns User email address.

   • {{ user.lastvisitdate }} - Last Visit Date
     Returns User Last Visit Date.

   • {{ user.registerdate }} - Register Date
     Returns User Registration Date.

   • {{ user.usergroups }} - User Groups
     Returns an array of User Group names

   • {{ url.format }} - Output Format
     A link to download current page records in a specific format.

   • {{ url.itemid }} - Menu Itemid
     Joomla menu item Itemid

   • {{ url.getuint }} - Unsigned Integer
     Returns an unsigned int.

   • {{ url.getstringandencode }} - Base64 Encode
     Returns encoded value of query parameter.

   • {{ url.getstringanddecode }} - Base64 Decode
     Returns decoded value of query parameter.

   • {{ url.base64 }} - Base64 Encode URL
     Returns base64 encoded current URL.

   • {{ url.root }} - Website Root URI
     Returns the root URI for the request.

   • {{ url.set }} - Set query parameter
     Sets a URI query parameter value.

   • {{ url.server }} - Server
     Server and execution environment information

   • {{ document.setpagetitle }} - Set Page Title
     A command to set the Page Title.

   • {{ document.setheadtag }} - HTML Document Head Tag
     Places whatever provided to HTML document head tag.

   • {{ document.setmetakeywords }} - Set Meta Keywords
     A command to place a meta keywords into the head of the page.

   • {{ document.setmetadescription }} - Set Meta Description
     A command to place a meta description into the head of the page.

   • {{ document.layout }} - Extend Layout
     Includes the content of selected layout.

   • {{ document.languagepostfix }} - Language Postfix
     Current page Language Postfix.

   • {{ document.attachment }} - Email file attachment
     The link to a file that will be attached to an email. Works in Email Layout Type.

   • {{ document.sitename }} - Site Name
     Return the Site Name set in configuration.php file

5. Users may upload .zip files, if permitted by website administrator.