ct4.us

For Joomla #

This plugin activates the functionality of Custom Tables Pro and includes additional features such as a plugin to insert Custom Tables Catalog records into any article or location where Content Plugins are enabled.

Enable “Allow Content Plugins” in the menu item parameters to use this functionality.

Custom Tables Catalog #

{customtablescatalog=Table Name,|Page Layout Name|,|Item Layout Name|,|Publish State|,|Filter|,|Sort by Field|,|Force Itemid|,|Limit|}

• Table Name – Existing Custom Tables table.
• Page Layout Name (Optional): Simple Catalog or Catalog Page layout to generate a catalog page.
• Item Layout Name (Optional): Catalog Item layout used with Catalog Page only.
• Publish State (Optional): Filter to show published or unpublished records or both (Options: showpublished, showunpublished, any)
• Filter (Optional): ‘Where clause’ to extract specific records fulfilling a condition, and a limit clause for the number of records.
• Sort by Field (Optional): Field name to sort by.
• Force Itemid (Optional): Used to set parameters for edit form or apply permissions.
• Limit (Optional): Limit the number of records.

Examples #

Insert records from products table using default layout:

{customtablescatalog=products} 

Insert records from products table as described in List of Product layout, records must be published and the price more than 0, also sort records by name field:

{customtablescatalog=products,ListOfProduct,,published,price>0,name} 

Insert records from products table using default layout and sort records by price field in descending order:

{customtablescatalog=products,,,,,price desc} 

Twig #

When you are calling the plugin from the inside of a layout, you can use Twig tags inside the parameter but enclose them with quotes.

Insert published records from countries table using default layout where code field = ‘pa’, and limit the output to 5 records:

{customtablescatalog=countries,,,published,"code={{ 'p' ~ 'a'}}",,,5}

Custom Tables Record #

{customtablesrecord=Table Name,Field Name or Layout,Record ID or Filter}

• Table Name: Existing Custom Tables table;
• Field Name: Field Name or Layout like this “layout:layoutname”;
• Record ID or Filter: 1,2,3 or a condition like “price>1”.

Examples #

Insert a name of the country from the record with Id = 1:

{customtablesrecord=countries,name,1}

Insert a record from “purchases” table generated using “purchaseDetails” layout and where “user” = current user id:

{customtablesrecord=purchases,"layout:purchaseDetails","user={{user.id}}"}

Insert a name of the country from the record where “code” field = “US”:

{customtablesrecord=countries,name,code=US}

Tabs #

{tab:Lorem}
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque ac nulla sit amet neque vestibulum ullamcorper. Integer tincidunt arcu nec velit pharetra, ac consequat metus molestie.

{tab:Curabitur}
Curabitur at libero in eros sollicitudin accumsan. Suspendisse potenti. Aenean vel libero quis turpis scelerisque auctor non eget lacus. Quisque feugiat, felis sed fermentum tincidunt, mauris elit aliquet magna.
{/tabs}

Custom PHP #

Enables Custom PHP file execution on Add and Save record events.

More Here: Custom PHP Event Handler for Custom Tables in Joomla