Admin Configuration

Overview

You can see default Admin module list here, that you have seen in Admin panel in Basic Overview. Default modules are created based on default tables.

It allows you to add new module and provides listing & view interface. You just need to configure it.

Columnwise Description

  1. Module Name : Shows module name.
  2. Template : It allows you to add different types of template view. Default is standard. (Describe it later).
  3. Settings:
    • Listing: It provides you listing interface.  (Describe it later).
    • Form: It provides you view (Add/Update form)interface. (Describe it later).
    • Module Name : It allows you to add your own Failure/Success messages. (Describe it later).
  4. Progress: It will show you process of configuration. It’s properly configured or not.
  5. FTP : If  you have added any remote server details and marked it as “default” server (from project management → Remote Server List ) , then you will get option to upload code of specific module directly on default remote server.
    If you don’t make any remote server as “default” server , then it will not show you this upload feature.
  6. Download : It will download specific module.
  7. Update : It will update specific module.
  8. Actions:
    1. Edit : It allows you to edit existing module
    2. Delete: It will delete specific module

Basic operations (buttons bar)

See below screen where you can see buttons for basic operations

  1. Add New
  2. Show All
  3. Utilities
    • Copy Module
    • PHP Functions
    • Aggregate Functions (Price)
    • Languages
    • JS Files
    • CSS Files
  4. Upload On FTP
  5. Download Code
  6. Update Code
  7. Login

1. Add Module

It will create new module using databases we have created. You can set your Module Heading , Module Name , Folder name(Based on Module heading , it will take input of Module Name & Folder Name automatically).

It provides a feature for Physical Delete (Yes/No).

  • Yes : It will delete record from database.
  • No : It will not delete record from database
  • Template : It allows you to set  template with different views.
  • Main Table : You can add Main table for module & you can define Alias of main table . You can relate table with other tables using Add Relation.
  • MultiLingual : If you want to add this module in Multilingual then you can do it.
  • Add to Menu : When you create module, it will be added to Menu (By default, it is selected) at Admin. Parent menu is “Home” by default. But  you can change it from dropdown. You can also change Menu Display Name as you want.
  • Module Help : you can add your any information about module.
  • Dashboard Page :  Associate module with dashboard by simply selecting a Dashboard Page from the dropdown. (more detailed in Dashboard Management section).
  • Dashboard Position : Left/Right. After creating dashboard, we can set position. (more detailed in Dashboard Management section).

1. Module Template : It provides you 7 types of different view that you can set in your Add/Update form (we will see more  “Add/Update form” in details later).

View types is shown in below screen:

  1. Standard
    • It’s Default view
    • 1 column view
  2. Split View
    • View is split into 2 parts

  3. Blocks View
    • you can see 3 blocks

  4. Custom View
    • It allows you to create Custom view of form
    • You can add  different blocks, you can add upto 3 columns in each block & also add the Tabs.

  5. Columns View
    • It provides 2 column view.

  6. Columns View
    • It provides 3 column view.

2. Module Relation Tables You can relate Main table with another  multiple Tables.

Note : If you have defined relation in database then here you can see relation by default.

Just select other table from dropdown and after adding relation, you will see below screen.

You can see “Relation Table name & its Primary key” connected with Main table. You can define Alias of relation table.

1. Join Type

It allows you to use different types of joins. Select whatever you want.

  1. Left
    • It returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.

  1. Right
    • It returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match.

  1. Normal (Inner Join)
    • It selects all rows from both tables as long as there is a match between the columns in both tables.

2. Relation type

You can also define “Relation type”.

  1. One-One
    • A row in first table can be related to only one row in a second table
    • A row in second table can be related to only one row in a first tabl
  1. One-Many
    • A row in first table can be related to one or more  row in a second table
    • A row in second table can be related to only one row in a first table
  1. Many-Many
    • A row in first table can be related to one or more  row in a second table
    • A row in second table can be related to one or more  row in a first table
  1. Many-One
    • A row in first table can be related to only one  row in a second table
    • A row in second table can be related to one or more row in a first table

3. Add (Checkbox)

It is applicable only for One-One relation type. When you select it, you can use all fields of relation table in your Add/Update form

4. Extra Condition

It is used for extra condition with Joins. It is applicable for where condition

Shown below is syntax for giving condition:

Single Condition : table_alias.eStatus = 'Active'

Multiple Conditions : table_alias.eStatus = 'Active' AND table_alias.dRegDate >= '2012-10-10'

Request Parameter : table_alias.eStatus = '{%REQUEST.status%}'

Server Parameter : table_alias.vIP = '{%SERVER.REMOTE_ADDR%}'

Example: REMOTE_ADDR, HTTP_HOST

Session Parameter : table_alias.eStatus = '{%SESSION.eStatus%}'

Example: iAdminId, vName, vUserName, vEmail, iGroupId, vGroupCode, vGroupName, eStatus

System Parameter : table_alias.vName = '{%SYSTEM.COMPANY_NAME%}'

Example: COMPANY_ADDRESS, COMPANY_NAME, COPYRIGHTED_TEXT, IMAGE_EXTENSION

After clicking on “Next” button, you will be redirected to LISTING CONFIGURATION PAGE that we will see  in “Admin Management Part-1 (Listing)” section.

Now , Continue with the Basic  Operations in button bar from Admin Module List Page.

2. Show All

It will show you all modules in listing

Utilities with its sub menu

3. Copy Module

It will allow you to copy any module from same/different projects.
Just select project & after selecting project , you will see all modules in “Modules Block” dropdown.

When you select any module , you can see which tables are used in that specific module.  You can see “Main table” & “Relational Tables”. If it has only “main table” then it will show you “there is no relation with other table”.

If tables are not exist in your database then it will copy module with its all related tables.

4. Aggregate Functions (Price)

It will show you additional price related listing. For example: Vat/Tax , Discount.
You can see Discount & VAT here with their values & type (Percent/Value).

Here ,  It allows you to add new price , Edit existing price details & delete specific record.

  1. Name :  Enter specific name.
  2. Type :  It will allow you to select different types.
    • Value
    • Percentage
    • PHP Function
      1. If you have done any calculation in  php function & you want to use return value then you can do it.

  3. Inc/Dec :  Do you want to increase/decrease value?  You can specify by selecting +/- sign.
  4. Value :  Set your value here.

5. Languages

If your project is multilingual , then only you can see  this “Languages” button.  It willshow you different languages of your multilingual project. It allows you to add new language too.

By default , English is “Primary” language and another 3 are “Secondary” languages. It allows you to set another language as “primary” language. It allows you to change its status (Active / Inactive). You can see language details in grid list.

6. PHP Functions

It will allow you to create your own PHP functions.
You can Add/Update/Delete  function. You can also change status of function (Active/Inactive).
It allows you to search function-wise. See default function list here.

Copy Function
It allows you to copy function from other projects if required.
Just select project  & it will show you all function list of selected project. Then select specific functions that you want to copy.

Add New Function

For Example : If you want to generate random token using input device id , see below screen.

7. JS Files

It will show you the list of JS files if you have used any with details (In which module it is used , JS file name , By which submit function it is called , Files is exist or not , Preview of code).

It allows you to add new JS file and delete existing JS file.

See below screen of JS Code Preview screen

8. CSS Files

It will show you the list of CSS files if you have used any with details (In which module it is used , CSS file  name , Files is exist or not , Preview of code).

It allows you to add new CSS file and delete existing CSS file.

See below screen of CSS Code Preview screen

9. Upload On FTP

If you have added any remote server details and marked it as "default" server (from project management → Remote Server List ) , then you will get option to upload code of all modules directly on default remote server.
If you don't make any remote server as "default" server , then it will not show you this upload feature.

10. Download Code

It will download all modules with latest configuration in zip file.

11. Update Code

It will update all modules with latest configuration & open admin panel by generated code in new window.

12. Login

It will redirect to Admin Panel login page.

Listing Configuration

Listing Fields

Here , below screen is default screen for listing configuration. You can configure Listing page easily  & use many features in it.  

There are so many different properties. Just Configure from here & you will see effect in Listing of this module in Admin Panel. We will go through it one by one.

Default Listing Properties

Primary Key : It shows Primary key of your main table (here its ‘userdetails’).

Status Field : It will add status field for changing Status of selected records in Listing page at Admin.
By default , it will automatically take Enum type field of your Main table. If you don’t have any enum field then it will show blank.

Here we have  eGender. (Change status Male/Female) .

Extra Condition

It is used for extra condition if you want to do for listing page. It is applicable for where condition only.

Syntax for condition

Single Condition : table_alias.eStatus = 'Active'
Multiple Conditions : table_alias.eStatus = 'Active' AND table_alias.dRegDate >= '2012-10-10'

Request Parameter : table_alias.eStatus = '{%REQUEST.status%}'
Server Parameter : table_alias.vIP = '{%SERVER.REMOTE_ADDR%}'
Example : REMOTE_ADDR, HTTP_HOST

Session Parameter : table_alias.eStatus = '{%SESSION.eStatus%}'
Example : iAdminId, vName, vUserName, vEmail, iGroupId, vGroupCode, vGroupName, eStatus

System Parameter : table_alias.vName = '{%SYSTEM.COMPANY_NAME%}'
Example : COMPANY_ADDRESS, COMPANY_NAME, COPYRIGHTED_TEXT, IMAGE_EXTENSION

Note : don't specify the below values as request parameters.
"file","iModuleId","parModule","parData", "filters","fields","sidx","sord", "export_type","page","rowlimit".

Group By Condition : The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.

Here , you can use  “Group By” by selecting field multiple fields from drop down.
You can see all fields of your table.It is same like mysql function “Group By”.

Add Record in Popup : It allows you to add new record in Popup in listing at Admin panel .
Admin panel:  When you click on “Add New” button, it will show you popup for adding new record.

Hide Add Button : It allows you to hide “add” button from top button bar in listing page.

Hide Delete Button : It allows you to hide “delete” button from top button bar in listing page.

Hide Status Button : If you don’t want to use Status button for changing status of selected records  then you can set it from here. We have discussed status button  in “Status field”. We have used “Gender” as status.

Hide Export Button : It allows you to hide “Export” button from top button bar in listing page.

Hide Advance Button : It allows you to hide “Search” button from top button bar in listing page.

Hide Columns Button : It allows you to hide “Columns” button from top button bar in listing page.

Hide Multi Select Checkbox : It allows you to hide “Multi Select Checkbox” in listing page.

Search Category

It provides 2 types of search.

  1. Simple
  2. Group

Simple

It will provide you simple search conditional-wise. If you want to search using specific condition, then it will be  useful. You can add multiple conditions.
It will show you all fields in dropdown & also provides different conditions that can be used.

For example : if you want to search for specific condition, like If  “Field name” equals “this  value” then find.

  1. → All/Any Just select it from dropdown as per your conditions
  2. (Plus sign) It will add new conditions in your search criteria
  3. (Minus sign) It will delete particular condition from your search criteria

Group

It is same like simple but it allows you to add multiple inner sub conditions

Grid Width

  1. Auto
    • It will take width automatically according your fields based on your screen width  in listing page .(You can’t see horizontal scrollbar here).
  2. Pixels
    • It will allow you to define width in pixels of  your fields in listing page.
    • Using your specified width , if grid width is beyond the screen then correspondly it will add horizontal scrollbar.
    • By dragging column, you can change column width at listing page.
    • we will see later where we have to define width.

Inline Add Records

It will allow you to add Inline multiple new record on the fly. You will see new 3 buttons next to button bar at listing page. It will allow you to add,save,delete multiple new record.

Custom Add/Update

It will allow you to add custom code through function if you want some custom add/update  form  or anything which is not supportable by Configure IT. Just define function name overthere.

How to create PHP Function ?

Go Admin Management -> PHP function (Discussed in Admin management part).

For Example :

By default, we use simple form but You can see “Group” Page at admin for assign role/permission which has multiple checkboxes for assigning role. For that we have created function & used it.

Edit Record in Popup : It will allow you to edit record in Popup at listing page.

Hide Search Toolbar : It will allow you to hide search toolbar from listing page.

Hide Paging : It will allow you to hide paging toolbar from listing page.

Hide Refresh : It will allow you to hide “Show All” (Refresh) button from button bar at listing page.

Disable Inline Edit : By default , Configure IT provides “Inline Edit” records feature for every field on listing page. When you check this property, it will be disabled.

Customize BG Color : It allows you to show data with  background color  or you want to do highlight some cell/row info  for specific condition  then you can do it with this property (color setting).

You can create multiple conditions & also multiple blocks.  

In condition block, you can use  following variables using different types of operands

  1. Variables (Table fields)
  2. Static value
  3. Request Parameters
  4. Session variable
  5. Function
  6. System defined variable
  7. Server defined  variables

Example :

Server :

Session : iAdminId, vName, vUserName, vEmail, iGroupId, vGroupCode, vGroupName, eStatus
System : COMPANY_ADDRESS, COMPANY_NAME, COPYRIGHTED_TEXT, IMAGE_EXTENSION

Color Code

  1. Variable
         Here , if you have set color picker to particular variable then you can use it in this section.
         How to set color picker to variable ?
         Add/Update form -> field setting -> set type color picker (describe it in later)
  2. Static
         When you select this code , you can see color box from where you can set color that you want.

Apply Color

  1. Row : Apply color for Row
  2. Cell :   Apply color for Cell

For example: If you want to highlight Row  if gender is Male/Female

Row-wise (Condition Configuration) : You need to just select variable (field name - Gender here) , Match with its value using Type & Operator ,Select static for  giving color code  & apply color in “Row”.

Admin panel effect

For example: If you want to highlight Cell  if gender is Male/Female

Cell-wise (Color Configuration)

Admin Panel effect

Show Left Panel Search
It will allow you to add “Left Panel Search”   for  multiple fields.
It will allow you to search gender-wise,status-wise,price-wise etc..

It will allow you to select multiple fields from dropdown.  (Table fields). It will add block below which contains Display name, Field Order, Data order , Data Set , Range

  1. Display Name : It will show you name of selected fields
  2. Field order : If you are using multiple fields for search then it will allow you to sort by field order.(Which type of search you want to show on top in left search panel)
  3. Data Order : It will allow you to show result in ASC/DESC order
  4. Data Set
    1. Existing
      • It will be applicable  only for that value which exists in records. According your  records, it will show in left search panel
      • For example :
      • If you have gender field  with Male & Female value. If your records have only  “Female” value , then it will show only female with no of records in left panel.
      • It will not show you “Male with 0 records”
    2. Reference
      • It will be applicable  for all values of field
      • For example :
      • If you have gender field  with Male & Female value. If your records have only  “Female” value , then it will show only female with no of records in left panel.
      • It will show you “Male with 0 records”
  5. Range : It is applicable only for integer value in which we can set Minimum and Maximum range.
    Just check the checkbox & you will see one block in which you can set ranges as per your wish.

Now shown below screen is how it looks in Admin

1 → You can Show/Hide left search panel
You can see search by Gender and Age with no of records.  We have used Data Set = Reference , So here , you can see “Female” with 0 records.
If you use  Data Set = Existing , then you can’t see “Female”.

Filter Settings
It will allow you to filter data. If you want to show specific conditionally data in listing then you can set.
If you want to use PHP function then you can define it here also.

Note :

  1. PHP Function will be considered as a high priority than Value.
  2. If date format is selected you can pass single date if the Operator is equal, not equal, greater, greater or equal, less, less or equal.
    Example : yyyy-mm-dd hh:mm:ss
    Other than that for date format you can pass like below format
    Example : yyyy-mm-dd hh:mm:ss to yyyy-mm-dd hh:mm:ss
  3. If you want to return values from the PHP function then it should be in below format.
    Example : array("India","Srilanka")

For example:  if you want to see data of age = 12

Printing Records
It allows you to print records.
It displays available table fields. You can also change printing  layout if required.
It also provides different Editor theme . If you want to preview your code then you can preview the code there.

If you want to do some custom code, then they provide syntax helper for

  1. Variable Help
  2. If-Else Condition
  3. Section & Foreach Loop
  4. Calling general function
  5. Key / Value Pair

For Example : If you want to enter the fields then specify the field with it's alias name in between "<%" and "%>" symbols with "$data" prefix.

Example : <%$data['admin_name']%>

If you want to display a label in different language then use Display label in specified field with following syntax.

Example : <%$this->lang->line('ADMIN_NAME')%>

Default Sorting : It allows you to add default sorting of your listing page. Select particular field from dropdown. You can do multiple sorting. It allows you to do sorting Asc/Desc. You can change order by drag & drop particular field also.

Admin panel :

Add to Bulk Email
It allows you to add this module in Bulk email list. If you add it to bulk email, then it will be added in bulk email section at admin part. From where you can send bulk email using specific email templates

Admin →  Resources →  Bulk email →  Module will be added in “Send to” dropdown.
For example
If You have “User” module and you want to send bulk email to all users of user module. Just select this checkbox & you will see this module in “Admin → Resources → Bulk email → Module will be added in ‘Send to’ dropdown”.

Track Navigation
It allows you to track your module record(Enable/Disable). We have discussed earlier about “Navigation log” at bottom left corner.

Grouping Records
It allows you to show your listing by group. When you select checkbox , it will show settings for Grouping (header , total , separation tag). Here , select group field (it’s Gender here).

Grouping Header : Set Grouping header ,  {0} (will be your value) , separation tag between grouping header & total.

Grouping Title : Set Grouping total for title of no of records , {1} (will be your value) , end separation tag.

Show Summary : It will allow you to Hide/Show summary

Show Column : The field which we have used for Grouping, it will not see in Listing. If you want to see in listing then just select it.

Group Order :
It will allow you to show listing Asc/Desc order
See below screen,how it looks in listing at Admin panel

Expand Grid Listing : It allows you to expand sub grid for a record  for showing extra information. You can see multiple records in expandable grid related to specific record. You need to set relation over there .

For example : We have Country module & we want to expand country with its Multiple State details

Configuration settings:

Select module that you want to relate with your current module. We have Country module,  so we have selected state module here. Then, just give foreign key relation.
Extra condition is applicable for “where” Condition. (Syntax we have defined earlier / Check help text).

Allow Editing
This is applicable only for generated admin panel not for engine.
It will allow you to edit records.

Print
This is applicable only for generated admin panel not for engine.
It will allow you to print records.

Admin preview

Here , you can expand your country grid listing by + sign. You will see state listing grid country-wise with  its own grid.  You can add,delete, change status , search states with pagination.

You can also do inline editing of State details. If you are trying to change unique field of state details & if it is already exist then it will not allow you to edit & show you validations for duplication. Here “State-Code” is unique field. The configuration set for State module will be reflected in the sub grid.

Expand Detail View
It allows you to expand grid for showing detailed  information for specific record. It is not for multiple records showing in grid. It’s only for single detailed information.
You need to set relation over there .

For example :
We have State module & we want to show its country details as its detail view

Configuration settings:

Select module that you want to relate with your current module. We have State module,  so we want to relate it to  Country module here. Then, just give foreign key relation.
Extra condition is applicable for “where” Condition. (Syntax we have defined earlier / Check help text).

HTML Layout
It will allow you to change HTML layout. When you click on “Details” link, it will show you page where you can change layout (we have seen it before in “Print” option).If you want to remove any field then you can remove it from html. It will reflect on Admin side.

Allow Editing
This is applicable only for generated admin panel not for engine.
It will allow you to edit records.

Print
This is applicable only for generated admin panel not for engine.
It will allow you to print records.
Admin preview

Here , you can expand your State grid listing. You will see state-wise country details.

You can do inline editing of country details. If you are trying to change unique field of country details & if it is already exist then it will not allow you to edit & show you validations for duplication. Here “Country -Code” is unique field.

Deletion Settings
If you want to relate deletion settings  with another module then you can do it easily using this property. If parent is deleted then child will be automatically deleted.

For example:
if you delete any category, then products related to this category should be automatically deleted.

Configuration settings

You can relate multiple modules to current modules.  Then, just give foreign key relation.
Extra condition is applicable for “Where “ Condition. (Syntax we have defined earlier / Check help text).
Now, when you delete category , it will delete all its products.
Here,  we will move to next part of Listing page.

Fields Display Types in “Display In”

1. Display In : At top position , you can show different color code. You can assign any field to this color code status. Just select field & click on that particular link for color code.

  1. All
    • If you want to show field in all section. (List , grid , print , query)
  2. Grid Only
    • If you want to show field in Grid section only.
  3. View Only
    • If you want to show field in View section only not in list, But if you want to view in detail view only.
  4. Print Only
    • If you want to show field in print section only not in list or  view.
  5. Query Only
    • If you want to use field in query parameters section  only.

Same thing, you can do it in another way.  From field setting (highlighted  “setting” icon in First name field in the following screenshot),  “Settings → Display In → Select type” . We will see other properties later.

Common Properties

2. Common Properties : If you have more than one fields which have common settings, then you can save settings of those fields at same time. There is no need to do one by one for every field. Just select fields & click on “Common Properties” link

For example : You have “first name” & “last name”. Both should have same settings, then you can use this option.

Here , you can see “Right Panel” where you can save settings for both fields at a time.  We will describe all properties in right panel later on.

Formatter Function

3. Formatter Function : If you want to format a field then follow below rules

  • Write formatter function's definition from Formatter Function link.
  • From Setting icon → Settings (right panel) → Check this ‘formatter required’ checkbox.
  • Provide function name of formatter into textbox.

Table Field Section

Now, we will move to table fields part of listing section

Select Table Fields
1. Main table , Alias , its fields
You can see Main Table & its table fields.  It will show you Table Alias besides of Table name.

2. Relational table , Alias , its fields
You can see Relational table & its table fields.  It will show you Table Alias besides of Table name.
For example :
     user_details (ud)  // Alias is ud
     login_details (ld) // Alias is ld

If you want to show field in listing page, then just click on “+” sign. It will be added in your listing page at right side. If you want to remove it from listing then click on “-” sign.
At right side, you can see field listing , it will show in your listing at Admin.

How to manage Custom Fields?

3. Custom Fields
If you want to add any static field or want to do any custom query then you can use this field
It will show you 2 field types

  1. Text
  2. Query
When you click on “Custom fields”, field will be added at right side. You can select field type over there.

Field Type  → Text

For example : If you want to show link “View Products” in category listing & it will redirect to its product module & show listing.

Just select “Custom Field” & it will be added in listing field. Now select field type  “Text”.
Now enter your Column title , Display in query (for this, it is static link label)

Click on setting icon of that field & it will show you right panel for extra settings.

Select “Edit Link”  & it will show you 2 options

  1. Same Module : If you don’t want to redirect  to another module & want to use current module only, then you can use this option. It will allow to edit that specific record only for same module.
  2. Custom - Link Settings : If you  want to redirect  to another module, then you can use this option.
    Click on “Link Setting” link & it will show you popup.

Module / Custom → Select type if its Module or Custom.

Module : If you want to another module then select it.

Custom : If you want to add any internal / external link then you can use it.

Custom Module Link →      Enter the Custom Link here.
Syntax Help
     For Example:
     External Link : http://www.google.com (OR) https://www.google.com
     Internal Link : you can also give internal link like dashboard link. You can enter url here.
IF "Settings" is Module Name, and want to send Some parameters then you may enter like this
     Project Module Link : Settings|Type|Appearance

You can pass parameters like :
Example 1 : http://www.google.com?extra parameters (a=1&b=2&c=.... etc)
Example 2 : http://www.google.com?a=@field_alias@
Example 3 : Modulename|extra parameters (Brand|nokia|Type|touch...... etc)
Check the drop-down beside to "Add Block"button for field names and their alias names

Module Name : Select module name on which you want to redirect.
Module Page :  On which page you want to redirect

  1. Listing
  2. Add
  3. Update

Open Page : How do  you want to open page ,

  1. In New Page
  2. In Same Page
  3. In Popup

Request Variable : Select if it is Custom / Variable

  • Variable
    • If you choose “Variable” then you will see all fields in next dropdown of current module & also of another module. Just select whatever you want for relation
  • Custom
    • Need to describe

Static / Variable : You need to select Variable type. It will show you different types of variables
           Static, Variable, Session, Request, Server, System
           According your selection , you need to set value in “Listing Field”

Apply Condition : If you want to add any condition then you can add condition here. You can add multiple conditions here  & define condition type too. (AND/OR)

It will allow you to set different types of operands

  • variables (Table fields)
  • Static value
  • Request Parameters
  • Session variable
  • Function
  • System defined variable
  • Server defined variables

If "Operand Type " is equal to "Request" then
  Example : status, project_name, category_name

If "Operand Type " is equal to "Session" then
  Example : iAdminId, vName, vUserName, vEmail, iGroupId, vGroupCode, vGroupName, eStatus

If "Operand Type " is equal to "Server" then
  Example : REMOTE_ADDR, HTTP_HOST

If "Operand Type " is equal to "System" then
  Example : COMPANY_NAME, COPYRIGHTED_TEXT, IMAGE_EXTENSION

If "Operand Type" is equal to "Function" then you should follow these instructions.
If your function is "General defined" function then it should be declared in following path

 application
   >libraries
     >general.php
file as like below
function phpFunctionName($dataArr=array(), $id='') {
// do your code
// return your modified "$value"
}

Admin Side View of configuration of Product listing (Field Type = Text):

When you click on “View Products” , it will redirect to product listing page & it will show products of specific category not all products. Shown below is product listing page

Field Type  → Query
For example : If you want to show “Count Of Products” on Category listing page then we can do it using query type.

Enter your query :
For example:
select count(*) from product where iCategoryid = c.iCategoryid

Admin side Listing view :

4.  Display Name

It will show you Column Title which you can see at Admin listing page.   If you want to modify it then you can do it.

5.  Display in Query

It will show you field name which will be used in all queries.  If you want to modify it then you can do it.

6.  Alias Name

It will show you alias name . If you want to modify it then you can do it.

7. Sorting
It will allow to use this specific field in sorting  at Admin listing page. If you uncheck the checkbox, it will remove sorting feature for this field.

8. Searching

It will allow to use this specific field in searching at Admin listing page. If you uncheck the checkbox, it will remove  searching feature for this field.

9. Width

It will allow to set width (in pixels) of specific field in Admin listing page. If you set width using dragging feature from listing page then width  value will be added in this field.

10. Alignment

It will allow to set alignment of specific field in Admin listing page.
Left , Center , Right

  1. Sort Fields (Drag field & set order)
    • You can set order of fields by drag & drop feature
  2. Setting
    • It will show you panel at right side from where we can manage extra setting field wise (See in more detail later)
  3. Delete
    • Delete specific field from listing

Setting Field Specific Properties

FIELD SPECIFIC SETTINGS

Display Table Fields

1. Display Name

It will show Column Title which will be displayed at listing page.

2. Display in Query

It will show field name which will be used in queries.
You can write "Mysql" pre-defined function as below.
      Example :
      1. CONCAT(tablename.vFirstName,tablename.vLastName)
      2. UPPER(tablename.vFirstName)
      3. LOWER(tablename.vFirstName)

3. SQL Function

You can specify "SQL Function" as below.
      For example,
      1. DATE_FORMAT( %q% , '%Y-%m-%d')
      NOTE : %q% will be replaced automatically by the value specified in Display In Query.

4. Alias Name

It will show Alias name here.

5. PHP Function

  • It will show you “PHP Defined” & “General Defined” function list (Functions will be coming in autocomplete).
  • Syntax Help

    If your function is "PHP defined" function then it will perform operation on fetched data.
    If your function is "System defined" function then you can see that function code in "Utiltity" →  "Function List" Section
    If your function is "General defined" function then it should be declared in following path
          application
          >libraries
          >general.php
    File as like below
          function phpFunctionName($value='',$id='',$dataArr=array()){
          // do your code
          // return your modified "$value"
    }

6. Date Format

It allows you to use different types of Date Format. It is applicable only for Date field.
You can specify “PHP Date Formats”.

For example:

  1. Y-m-d
  2. Y-m-d H:i:s
  3. F j, Y
  4. F j, Y ( h:i:s )

Settings & Value Properties

1. Default Sorting

It will allow you to set default sorting (ASC / DESC) for specific field.

2. Sorting

It will allow you to sort (ASC / DESC) for specific field.  You can Enable/Disable sorting at listing page. By default it’s Enabled.

3. Searching

It will allow you to search for specific field.  You can Enable/Disable searching at listing page.
By default it’s Enabled.

4. Width

It will allow you to set column width in pixels. If you set column width by dragging column at admin side , that value will save here.

5. Alignment

It will allow you to set alignment of column value here . It can be  Left , Center , Right.

6. Display In

It will allow you where you want to show specific field.
All , Grid Only , View Only , Print Only , Query Only (we have discussed earlier).

7. Edit Link

It will allow you to add  “edit link”  in listing page.

  • Same Module
    • It will add  “edit link”  in listing page for same module. If  you click on that link, it will allow you to edit records
  • Custom module
    • It will add  “Internal / External  link”  in listing page  OR add link to redirect to another module
    • We have discussed it earlier

8. Hide Column

It will allow you to hide specific column field in listing page.
It will also allow you to show/hide column if condition apply. You can add condition here on-click on “Hide Setting” link.

For example :  if you want to show Price column only if admin is logged in not for users. So you can check condition through session variable here.

9. Allow In-Line Editing

It will allow you to edit records in-line. By default is enabled.

10. Add to Left Panel search

It will be enabled only  if 'show left panel search' at the top is checked.
You can add specific field to  left panel search that we have discussed earlier.

11. Add to Bulk Email

It will allow you to select specific field for bulk email..  (We have discussed it earlier)
For example :  In user module , there are so many fields in module but do not want to use all fields. You just need Email field then you can select specific field from here.

12. Multilingual

It allows you to add specific field for MultiLingual. It’s not required to add all fields in for MultiLingual. So here, we can choose specific field.
If your project is Multilingual & your field is added in “Lang Table” , then you can see this field property in settings.

It will be enabled only if you have add your table fields in “Lang Table”. You can see button at the bottom of fields “Add To Lang Table”.  Then , it will be enabled in your field setting.

13. Grand Summary

It allows you to show grand summary/total.  When you check this , you will see  configuration box over there.

1 Grand Operations

It will show you different types of operations

  1. Count
  2. Sum
  3. Average
  4. Max
  5. Min

2 Grand Text

You can define Grand text label/ title  with its  format.
format : Label, Currency sign , {0} - means it will be your value ,

3. Extra calc

It will allow you to select extra Tax/Vat/Discount settings which you can see from Admin side (Settings →  Prices).

4. Final Text

Now you can set final text title with its format.
format : Label, Currency sign , {0} - means it will be your value ,

For example :

If you have  ‘products’  module  & if you want to show  total of price using vat then you can do it.

Admin Side view :

14. Group Summary

When you use “Grouping Records” property & display listing Group-wise.  If you want to add “Group summary” for grouping records then you can do it.

It allows you to show group summary.  When you check this , you will see  configuration box over there.

1. Group Operations

It will show you different types of operations

  1. Count
  2. Sum
  3. Average
  4. Max
  5. Min

2. Group Text

You can define Group text label/ title  with its  format.
format : Label, Separation , {0} - means it will be your value , end separation

For Example:

We have show user listing using  Grouping By Gender (Male/Female).

Now each user has age record. Now you want to show “Average age of Male  &  Average age of Female“ (Based on Group).

Configuration for “Grouping Records”

Group Summary configuration of “Age Field”

Now, we will see listing at Admin . It will show you Grouping Gender - Wise and also you can see average age for Male / Female.

15. Image / File

It will allow you to show image thumbnail in listing.
If are using any image/file &  want to show image thumbnail then you have to check this property otherwise it will show image name only.

Now, we want to show image thumbnail in listing. then select this field property.
you will see below screen

1. Inline

It will allow you to show image thumb or “view” link.
If you don’t check it then it will show you link “view” , Onclick of this you will see image in popup

2. File Server

It will allow you to select file server type . It has 3 options

  1. Local : It uses its own server
  2. Custom  : If you want to use other server
  3. Amazone : if you want to use amazon s3 bucket

3. Folder Name

Here , you have to set folder name which is used for images. This folder name must be same in “Add/update form” also that we will see later.

4. Folder (ID Wise)

You need to select unique field (Primary key) for differentiate image per category

5. Image Width

It will allow you to define image width

6. Image Height

It will allow you to define image height

See below screen in which we have done configuration to view thumbnail in category listing

Admin listing page :

16. Expand Row

It allows you to expand row for showing detail  information for Specific Column.
It is same as “Expand Grid View” & “Expand Detail View” feature that we have discussed earlier.

When you select this property , it will show you below screen

17. Format Required

If you want to format a field then follow below rules (We have discussed it earlier)

  1. Write formatter function's definition from Formatter Function link.
  2. From Setting icon → Settings (right panel) → Check this ‘formatter required’ checkbox.
  3. Provide function name of formatter into textbox.

Now, all properties are done. Just Configure it & Click on “Update & Next “  button.

It will redirect you in “Add/Update Form” Section that we will see brief in “Admin Configuration Part-2 (Add/Update Form)”.

Admin Configuration Part-2

Add/Update  Form Configuration

Here , It allows you to configure Add/Update form that you have seen in Admin Panel. It’s Default Screen for Add/Update form.

Two Part

  1. Module Level Settings
  2. Field Level Settings

MODULE  LEVEL SETTINGS

Primary Key

1. Primary Key

It shows you Primary Key of your Main table which you have used while creating module

X - Editable Form

2. X - Editable Form

It shows you only view format of Update form. It doesn’t show any controls in update form (Like textbox , dropdown etc..). You can edit records only onclick of records.

Below update form screen without selection  X-Editable Form property

After selection  X-Editable Form property, see below screen

Unique Field

3. Unique Field

It allows you to set  multiple “Unique Field” for specific module with   "AND" / "OR".
Unique field is used for preventing duplicate entries.

For example:

If you want to set unique field validation for more than one field.
Please check either "AND" or "OR" .

  • "AND" is used for all unique fields data matching in the table.
    • Eg: vUsername = 'demo' AND vEmail = 'demo@demo.com'  


  • "OR" is used for either of unique fields data matching in the table.

Switch To Field

4. Switch To Field

It allows you to switch to different records in update form. You don’t need to go listing page and select another record to update. You can manage it in update form.

You need to just select any field by which you can switch to different records. It allows you to select multiple fields also.

For Example :

For country module , there are lots of country records. If you want to update records, then see below

In Update form , shown below screen

If you select Multiple field in switch field then ,

See at Admin update form , you will see “Country field with country code”

Before Event

5. Before Event

It allows you to fire execute action event  using function before particular event (Add / Update / Both). Just need to define function name. Functions will be coming in autocomplete.
It gives 3 options for when you want to active this event.

  1. Both : For both add/Update action.
  2. Add : For Add action only.
  3. Update : For Update action only.

For Example :

Send mail notification before adding category with category name.

Create PHP Function for sending mail notification for category

Define this function name at before event  property

Now when you add category, this action will be executed & notification will be sent before adding category. You will get notification mail.

After Event

6: After Event

It allows you to execute any action event  using function After particular event(Add / Update / Both). Just need to define function name. Functions will be coming in autocomplete.
Same like “Before Event”. Difference is only that it will be executed after event.

It gives 3 options for when you want to active this event.

  1. Both : For  both add/Update action.
  2. Add : For  Add action only.
  3. Update : For  Update action only.

For Example :

Send mail notification after adding category with category name.

Create PHP Function for sending mail notification for category

Define this function name at after event  property

Now when you add category, this action will be executed & notification will be sent after category is added. You will get notification mail.

Delete Event

7. Delete Event

It allows you to execute any action event  using function on particular DELETE event.
Just need to define function name. Functions will be coming in autocomplete.

For Example :

Send notification mail if category is deleted with category name.

Create PHP Function for sending mail notification On Delete of category

Define function name on  delete event

Now when you delete category, this action will be executed & notification will be sent after category is deleted. You will get notification mail.

Detail View

8. Detail View

It allows you to add detailed view on top of the Add/Update Page. It is for showing single detailed view.
We have seen same feature for listing page. It’s same like that but only for Add/Update form.

For Example :

If you have “State” module & on its add/update form, you want to show its country details on top of the page. Then you can show using this property.

Select module that you want to relate with your current module.
Then, just give foreign key relation.
Extra condition is applicable for “where” Condition. (Syntax we have defined earlier / Check help text).

HTML Layout

It will allow you to change HTML layout. When you click on “Details” link, it will show you page where you can change layout (we have seen it before in “Print” option). If you want to remove any field then you can remove it from html. It will reflect on Admin side.

Allow Editing

This is applicable only for generated admin panel not for engine.
It will allow you to edit records.

Print

This is applicable only for generated admin panel not for engine.
It will allow you to print records.

Admin side view

Relation Modules

9. Relation Modules

It allows you to create relation between parent & child. It allows you to add multiple child module relations and show it in different ways.

  • Select modules for relation.
  • Define relation using Foreign key.
  • Give Extra condition (Applicable for where condition only).
  • Delete record → If parent is deleted then child is also deleted.
  • Add more → Shows “Add more” button for adding records.
  • Add Popup → Shows popup while adding record.
  • Display Tab → Shows relation module in different Tab in Add/Update form. If it is selected then layout options will be disabled.
  • Layout → 2 types of view (Applicable when Tab is disabled)
    • Block view
    • Table View
  • print → Allows you to print records (applicable for generated code).

For Example :

Category is parent module & you want to add child relation for product then you can do it easily with this. Also you can Add/ Update / Delete records.

3 Different View

  1. Tab View
  2. Block View
  3. Table View

Tab View

Block View

Here , you can see block view & you can see related products with CRUD operations.

Table  View

Add New Category & its Related New Products

Custom JS File (How to add JS file?)

10. Custom JS File (Add JS File)

It allows you to add your own custom Js files.

How to add js in Add/Update form ? Let us see

For Example

If you want to call js onclick of any button/link in Add/Update form , then you can do it.

You can show any button/link calling by function. Just take any custom field & call php function from setting.

Create PHP Function

Now , Add custom field and define PHP function name that we have defined

Now , Add JS & define function there which is called onclick of button/link

Now , Go to add/update form

Custom CSS File (How to add CSS File ?)

11. Custom CSS File (Add CSS File)

It allows you to add your own custom CSS files for Add/Update form.

FIELD LEVEL SETTINGS

You can see 3 different settings

  1. Copy Settings
  2. Common Settings
  3. Show Details

Copy Settings

1. Copy Settings

It allows you to copy field settings from another specific field. You can copy settings from specific field to multiple fields. Just select fields which you want to copy to.
It also allows you to select which settings you want to copy.

Common Settings

2. Common Settings

If you want to set common settings of multiple fields then you can apply settings at same time.No need to do one by one for each field.

Show Details

3. Show Details

It will show you  Table name & field name.

Field Recognition By Color Code

You can recognize field by color code if it is Hidden/Static/Relation/Custom/Module Field.

How to add Static field ?

Add New Static Field

It allows you to add static field in your Add/Update form.
If you want to show label in Add/Update form , then you can do it using this property.

For Example :

We want to show heading “CATEGORY DETAILS” on category Add/Update form.

After adding static field, just click on Update button. then you can see “setting icon” for static field.It allows you to change order sequence of static field.

  • In setting panel of static field , you can see different properties.
  • Show Input On : where you want to display this field on Add / Update form OR both.
  • Unique Name : show you unique name of static field & also allow to modify it.
  • HTML Content : enter your HTML content here.

After saving static field setting , you will see “Pink” color code that we have discussed earlier.

Admin Side View

How to add Custom field ?

Add Custom Field (Button)

It allows you to add new custom field. After adding , update settings and then you can see settings icon for custom field where you can apply your settings (we will discuss settings later).

FIELD SPECIFIC SETTINGS (SETTING PANEL)

In below screen , you can see Field Wise Settings, There are some General settings & middle portion is changed BASED on selected TYPE.

Now, we discuss “General Common Settings” first.  The settings which are changed based on TYPE that we will discuss later.

GENERAL COMMON SETTINGS

1. DB Field

It will show you Table name with Field name.

2. Unique Name

It will show you Unique Name of specific field. If you want to modify it then it allows to do.

3. Display Name

It allows you to change display name of field which will be shown in Add/Update form.

4. Type

It provides different field types. You can select it based on your field. It will show different settings based on selected type.
For example : Textbox , Textarea , Password , Radio buttons and more that we will discuss later in brief.

5. Validations

It provides different types of validations based on selected type. There is no need to add separate validations for field. Just select here & it will apply.  It allows you to select multiple validations for each field. If you want to set your own validation message then you can do it .

Different types of Validations:

Requires , Email , Number , Zip Code , IP Address , Min-Max Range , Min-Max Length , Date , Digits , URL , Alpha with space , Alpha Num with space , Alpha without space , Alpha Num without space , Date greater than , Date less than , Date equal to , Date greater equal , Date less equal etc.

For Example :

If you want to validate field for “Email” then just need to select validations for Required & Email.

6. PHP Functions

It provides you to add default PHP Functions OR  you can use your own custom functions here.  Functions will be coming in autocomplete.

It has 2 Function Return Type

  1. Value Only
    1. It will show value as input value of particular field.
    2. For Example : for description field , you want to add static description using function.We have created “add_default_desc” function and return value is “This is our new & latest category”.

      Admin side view:

  2. Whole Input
    1. It will take whole value as input not as input value. It will replace whole input with return value.
    2. For Example : for description field , you want to add static description using function.We have created “add_default_desc” function and return value is “This is our new & latest category”.

    Admin side view:

7. Show Input On

It allows you to show input field on Add / Update / Both or as Hidden field. If you want to make field Hidden then it allows you.

8. View Only (In Update)

It allows to make field “View Only” in Update form only. (Yes /No)
If you don’t want to edit specific field in Update form then you can do it.

For Example

While editing category details , you don’t want to allow update category name, then select ‘Yes’ for view only.

9. Default Value

It allows you define Default value for specific field based on Default Value Type you have selected.

For Example :

If you want to set current date for added-date field , then you can use “NOW()” as default value and type will be MySQL.

Admin side view :

It allows you to set Default Value using Different Default Value Type.  

  1. Text : considered as normal text
  2. MySQL : considered as Mysql pre-defined function or Mysql query
  3. Request : considered as Request  variables
  4. Server : considered as Server defined variables
  5. Session : considered as session variable
  6. System : considered as system defined variable

For Example :

Text : Active, No
Mysql : CURDATE(), NOW() or SELECT iAdminId FROM `admin` WHERE iAdminId = "{%REQUEST.admin_id%}" LIMIT 1
Server : REMOTE_ADDR, HTTP_HOST
Session : iAdminId, vName, vUserName, vEmail, iGroupId, vGroupCode, vGroupName, eStatus
System : COMPANY_ADDRESS, COMPANY_NAME, COPYRIGHTED_TEXT, IMAGE_EXTENSION

10. Enable Conditional Coding

You can Show/Hide specific fields based on condition. It allows you to add multiple fields for condition and also you can add multiple conditions.
Just check this property and add condition settings.

For example :

If you have enum field “Options” with image & video value, you want to show image field when image is selected and show video url when video is selected.

Admin Side View


11. Merge Fields Here

It allows you to merge one field with other fields. You can merge maximum 4 fields. It allows you to change size of fields and see preview how it looks.

For example :

If you want to merge firstname with lastname for User ,  then you can do it using this.

Admin side preview

12. MultiLingual Field : It allows you to add specific field in MultiLingual table for Add/Update form.

13. Attributes & Value : It allows to add extra html attribute with type. Attributes should be declared with respect to field property type For example : readonly , class , Inline CSS , Onchange , Onclick , id , title , tabindex

  1. Example-1 :
    Attribute: style
    Value : width:250px;margin:5px;

  2. Example-2 :
    Attribute: class
    Value : input-small

  3. For example :
    If you don’t want to allow change price for other user and make it readonly,

SETTINGS BASED ON TYPE

  1. Standard Fields
  2. Special Fields

SETTINGS BASED ON TYPE (Standard Fields)

1. Textbox

It will show you different settings based on “Textbox” type.
It allows you to set size, background color, Max Length , Encrypt Data.  (See below screen).

Input Text Case : Uppercase , Lowercase , UCFirst , UCWord.
Apply Input Prefix/Suffix : It allows you to add Prefix/Suffix.

For Example :
Prefix can be  Rs , $ etc.
Suffix can be  Kg , .00 etc.

Text Placeholder : allow to add default Placeholder  text in textbox.
Field Comments : allow to add Help Text (Tooltip).

2. Textarea It will show you different settings based on “Textarea” type.
It allows you to set size, background color, Max Length , Encrypt Data, Placeholder Text , Field Comments , Input Case , Max Count.

Input Length

  1. No limit
  2. Words
  3. Characters

3. Password It will show you different settings based on “Password” type.
It allows you to set password pattern , Re-type password in form , Encrypt password, Placeholder Text , Field Comments.

4. Radio Buttons

It will show you different settings based on “Radio buttons” type.
It allows you to add field comments , set formatting type.
Formatting type :  Horizontal/ Vertical / 2-columns / 3-columns / 4-columns

It provides Option List / Contents which allows you to select “Available Option List”  , “Available Table List” & “Custom PHP Function”.

  1. Available Option List
    • It shows you predefined option list with its default value.
    • For example
      • Gender (Male/Female)
      • Status (Active / Inactive)
      • Currency
      • Languages
      • Yes / No
      • Enum

  1. Available Table List
    1. It allows you to populate data from specific table based on its key
    2. For Example
      1. If you want to show “Category Name” as option list  from category table,

Admin Side Preview

Note : For “Parent - Child”  property → See “Dropdown” type  for more explanation.

  1. Custom PHP function
    • It allows you to populate data using Custom PHP function.
    • See “Dropdown” type for more explanation.

5. Checkboxes

It will show you different settings based on “Checkboxes” type.
You will see  same properties of “Radio button” that we have discussed.
It allows you to add field comments , set formatting type.

Formatting type :  Horizontal/ Vertical / 2-columns / 3-columns / 4-columns

It provides Option List / Contents which allows you to select “Available Option List”  , “Available Table List” & “Custom PHP Function”. (Same as Radio buttons).

Admin Side Preview

6. Dropdown

It will show you different settings based on “Dropdown” type.
It allows you to add field comments , set formatting type.
Formatting type :  Horizontal/ Vertical / 2-columns / 3-columns / 4-columns

It provides Option List / Contents which allows you to select “ Available Option List”  , “Available Table List” & “Custom PHP Function”.

Available Option List :

It shows you predefined option list with its default value.
For example : Gender (Male/Female) , Status (Active / Inactive)  , Currency , Languages , Yes / No, Enum

Custom PHP function

It allows you to populate data using Custom PHP function.
Just need to define your function name overthere. Functions will be coming in autocomplete

t provides other  properties: OPT Group , Parent source & extra properties  that we will discuss in  “Available Table List “  section of dropdown.

Syntax for function :

function dropdownFunctionName($value='',$mode='', $iId='',$dataArr=array()){
   // do your code
   // if your dropdown is normal then
   // return your array like
   array(
       array("Id" => "1", "Val" => "Option-1"),
       array("Id" => "2", "Val" => "Option-2")
   );
// if your dropdown is opt group type then
   // return your array like
  array(
       array("Id" => "1", "Val" => "Option-1","grpVal" => "Group-1"),
       array("Id" => "2", "Val" => "Option-1","grpVal" => "Group-1"),
       array("Id" => "3", "Val" => "Option-2","grpVal" => "Group-2"),
       array("Id" => "4", "Val" => "Option-2","grpVal" => "Group-2"),
   );

}

Available Table List

It allows you to populate data from specific table based on its key

For example: You want to show “Category” dropdown in product form. It allows you to show category name (Using extra condition  ‘Applicable for where’ , Set Order By selected field , Set order ASC/DESC , Set Placeholder text , Set Field Comments ).

If you have so many records in dropdown then it allows you to add “autocomplete search”.

We will discuss later below 3 properties

  1. OPT Group
  2. Parent - Child
  3. Parent - Source

Set Size

Add New Record Functionality : If you want to add new product in category which doesn’t exist in category module then there is no need to go category module & add category.
You can add new category in product module. So select category module and it will show you icon to add new record of category.
Add New Record in Popup :  It allows you to add new record in Popup / New tab.
Default Required :  Yes (Show default message ‘Please select …..’) , No (Show first record as default value).

Admin side preview

Now we discuss remaining 3 properties

  1. OPT Group
  2. Parent - Child
  3. Parent - Source
  1. OPT Group

    It allows you to show values in dropdown  based on selected field in OPT - Group.

    For Example :

    You want to show categories on the basis of its status (Active / Inactive)

    Admin Side preview

    Configuration settings

  2. Parent - Child

    It allows you to show Parent field with its child field in drop down.
    It allows you to show N-Level children with Parent in dropdown.

    For Example :

    You want to manage category & its sub categories within one category master table and you want to show categories and  its subcategories in dropdown , then you can do it.

    Configuration settings

    Admin side preview

  3. Parent - Source

    It allows you to show values based on its parent.

    For Example :
    You have country dropdown and you want to show states based on Country that you have selected. If you have selected India then you will see states of india only.

    Admin Side Preview


    Configuration settings

7. Multi-Select Dropdown

It will show you different settings based on “Multi-Select dropdown” type.
It allows you to add field comments , set formatting type.
Formatting type :  Horizontal/ Vertical / 2-columns / 3-columns / 4-columns

It provides Option List / Contents which allows you to select “Available Option List”  , “Available Table List” & “Custom PHP Function”. (We have discussed all properties in Dropdown section).

For example
If you want to show languages in multi-select dropdown

Admin Side Preview

8. Date

It will show you different settings based on “Date” type.
It allows you to set different date format , Enable /Disable date dropdown , set size , add field comments , set placeholder text .

Minimum Date & Maximum Date : Specify "Date" Min / Max limits as below.
Default Value, +0::+0::+0 represents today.
For example,

  1. +1::+1::+7 represents one year, one month and seven days from today.
  2. -1::1::7 represents last one year, one month and seven days from today.

9. Date and Time

It will show you different settings based on “Date and Time” type.
It allows you to set different date and time format , Enable /Disable date-time dropdown , set size , add field comments , set placeholder text , Maximum/Minimum date limit (as we have discussed above).

10. Time

It will show you different settings based on “Time” type.
It allows you to set different time format , Enable /Disable time dropdown , set size , add field comments , set placeholder text.

SETTINGS BASED ON TYPE (Special Fields)

1. File

It will show you different settings based on “File” type.
It allows you to upload any file like image, video etc.  You just need to define file type (extensions) overthere. It allows you to select file server (Local , Amazone , Custom).

It provides the feature of capturing image (through webcam) instead of uploading image. You can capture it and upload it.
You can specify maximum file size , Permitted file type (Extensions) , height , width.

Here , you have to specify folder name & it must be same with listing page that you have specified for the same.

2. Phone Number

It will show you different settings based on “Phone Number” type.
It allows you to set size, encrypt data and field comments.
Phone Number Format
       Example 1 : (999) 999-9999
       Example 2 : +40 999 999 999
       Example 3 : a*-999-a999

Note :
       a - Represents an alpha character (A-Z,a-z)
       9 - Represents a numeric character (0-9)
       * - Represents an alphanumeric character (A-Z,a-z,0-9)

3. Autocomplete

It will show you different settings based on “Autocomplete” type.
You can select table from table contents using key and value field.

For example :

if you enter country name & it will auto search it. You can set Hint text , Default text for searching , Result text , no of chars when auto search will start , allow to select multiple values.

Admin Side Preview

See configuration

4. Color Picker

It will show you different settings based on “Color Picker” type.
It allows you to add color using color picker. It allows you to set size , max length , allow color preview or not.
It is very useful when you want to set color at admin.

For example : If you want to set different BG color for each category OR  you want to use different color accordingly color has been set in category.

Admin side preview

Note : we have used “Customized BG color - color settings” in listing form but we have skipped “Color code = variable”. Now see below,

In color settings ,  we can use variable “color” that we have defined here and based on this color variable , BG color will be reflected at admin side.

For example :

We have set “Color” field in category module. Now , when status is Active/ Inactive, use BG color which is defined in each category.

Admin side preview

5. Rating Master

It will show you different settings based on “Rating Master” type.
It allows you to set Ratings in your form. You can set numbers of stars , size of stars , types of start (Bulb / Star) , allow half star rating or not , option for clear rating.

Admin side preview

6. Code / Markup Field

It will show you different settings based on “Code / Markup Field” type.
It is just syntax highlighter. It allows you to add CSS / HTML / Javascript / XML  code.

7. WYSIWYG

It will show you different settings based on “WYSIWYG” type.
It allows you to set size, height , add field comments , toolbar (Basic / Advanced) , resizing of toolbar.

For example :

You can use this type for description field etc.

Admin side preview

8. Google Maps

It will show you different settings based on “Google Maps” type.
It allows you to add Google Map and set Map height and size. You just need to map fields for Latitude and Longitude.

Admin Side Preview