1. System Functions (Common utility functions)

USAGE: <FunctionName>

Function Name Description
ew_IsNotEmpty(val) (v9+) Return if value is not empty
Parms
 val - value
ew_IsEmpty(val) (v9+) Return if value is empty
Parms
 val - value
ew_InArray(val, ar) (v9+) Return if value is in array
Parms
 val - value
 ar - array
ew_FormObj(ctlid) (v9+) Return form object name
Parms
 ctlid - control id
ew_GetLanguageFields(tbl, fld, name) (v9+) Return field array for multi-language
Parms
 tbl - table object
 fld - field object
 name - field property name
ew_SelectFieldName(arflds, idx) (v9+) Return SELECT field from language field array
Parms
 arflds - field array
 idx - language index
ew_AddSelectField(ar, tbl, arflds, cnt, alias) (v9+) Add SELECT fields to field array
Parms
 ar - field array
 tbl - table object
 arflds - language field array
 cnt - language count
 alias - field alias
ew_SelectFields(ar, idx, sep) (v9+) Return SELECT field list from language field array
Parms
 ar - field array
 idx - language index
 sep - field separator
ew_SqlSelect(sSelectLimit, sDistinct, sSelect, sFrom) (v9+) Return SQL SELECT statement
Parms
 sSelectLimit - SELECT LIMIT part
 sDistinct - use SELECT DISTINCT
 sSelect - SELECT part
 sFrom - FROM part
ew_CustomScriptRowCnt() (v9+) Return custom template script id
ew_CustomScriptRowStartVar() (v9+) Return custom template row start variable
ew_CustomScriptRowVar() (v9+) Return custom template row variable
ew_CustomScriptVar() (v9+) Return custom template control variable
ew_CustomScriptId(name, type ,idx) (v9+) Return custom template script id
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
ew_CustomScriptTag(name, type, idx) (v9+) Return custom template script tag
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
ew_GetJsScript(html) (v9+) Return JavaScript from HTML
Parms
 html - source HTML
ew_RemoveJsScript(html) (v9+) Remove JavaScript from HTML
Parms
 html - source HTML
ew_Like(pat) (v9+) Return SQL LIKE pattern
Parms
 pat - source field pattern
ew_CastFieldForLike(fld, type) (v9+) Return SQL that cast non-string field for LIKE statement
Parms
 fld - field SQL
 type - field type
ew_ContainText(str, find) Return if source string contains find string
Parms
 str - source string
 find - find string
ew_HasTagValue(fld, val) (v8.0+) Return if field contains tag value
Parms
 fld - field object
 val - tag value
ew_FldTagValues(fld) (v8.0+) Return field tag values
Parms
 fld - field object
ew_SplitTagValues(str) Split tag values to array
Parms
 str - field tag values
ew_IsBinaryField(fld) Return if field is binary field
Parms
 fld - field object
ew_ImageViewUrl(tblvar, fld, bQuoted) Return image view url
Parms
 tblvar - table variable
 fld - field object
 bQuoted - return as quoted string
ew_CssInherit(val) Return "inherit" if no value. Otherwise return original value.
Parms
 val - Css Value
ew_RowCntVar(v) (v7.0+) Return row object name (using RowCnt)
Parms
 v - object name
ew_RowCntVarQuoted(v) (v7.0+) Return row object name (using RowCnt with quote)
Parms
 v - object name
ew_RowVar(v) Return row object name
Parms
 v - object name
ew_RowVarQuoted(v) Return row object name (with quote)
Parms
 v - object name
ew_AddSquareBrackets(varname, fld) Add square brackets to variable
Parms
 varname - variable name
 fld - field object
ew_PageObj() Return page object name
ew_GetPageObjByCtrlId(ctlid) (v8.0+) Return page object name based on control id
Parms
 ctlid - control id
ew_GetCtrlById(id) (v8.0+) Return control object based on control id
Parms
 ctlid - control id
ew_Val(v) (v7.0+) Return PHP TRUE/FALSE value
Parms
 v - boolean value
ew_JsVal(v) (v7.0+) Return JavaScript true/false value
Parms
 v - boolean value
ew_BtnCaption(name) Return button caption name
Parms
 name - original caption name
ew_SecurityCheck(sId, bSecurity, bAnonymous, bUserlevel) Return Security Checking codes
Parms
 sId - control id
 bSecurity - security is enabled
 sAnonymous - page is anonymous
 bUserLevel - user level is enabled
ew_PhpCode(php, typ) Return codes in PHP tags (i.e. <?php ... ?>)
Parms
 php - original PHP codes
 typ - return codes in PHP tags if = 0
ew_RandomKey() Return random key
ew_FolderPath(id) Return folder path based on control id
Parms
 id - control id
ew_GetFileNameByCtrlID(id) Return file name based on control id
Parms
 id - control id
ew_RelFolder(f) Return relative folder to current output folder
Parms
 f - folder path
ew_RelPath(f1, f2) Return relative folder of f1 to f2
Parms
 f1 - folder path 1
 f2 - folder path 2
ew_EscapeString(sSrc, sEsc) Return escaped string
Parms
 sSrc - source string
 sEsc - escape type (double quote for VB, back slash for js)
ew_DoubleQuote(str, cnt) Return string with correct number of double quotes
Parms
 str - source string
 cnt - number of double quotes (0,1)
ew_Quote(str) Escape double quote in string
Parms
 str - source string
SQuote(str) Escape single quote in string
Parms
 str - source string
ew_UnformatName(name) Unformat "=" and "," in name
Parms
 name - name to be unformatted
ew_HtmlValue(str) Return value for proper display in html
Parms
 str - source string
ew_JsEncode(val) Encode value properly for js
Parms
 val - source value
ew_HtmlEncode(str) Encode value properly for html
Parms
 str - source string
ew_PhpValue(str) Encode value properly for PHP
Parms
 str - source string
ew_GetFieldType(ftype) Return FIELD type based on ADO field type
Parms
 ftype - ADO Field Type
Output
 1 - Numeric
 2 - Date
 3 - String
 4 - Boolean
 5 - GUID
 6 - Others
 7 - Time
ew_SetDefaultValue(ftype, defvalue) Return default value
Parms
 ftype - ADO Field Type
 defvalue - default value
ew_BoolFieldTagValues(ftype, tagvalues) Return tag values for Boolean field
Parms
 ftype - ADO Field Type
 tagvalues - original tag values
ew_SQLPart(sSQL, sId) Return part of the SQL
Parms
 sSQL - original SQL
 sId - token for different part of SQL
(SELECT,FROM,WHERE,GROUP BY,HAVING,ORDER BY,LIMIT)
ew_RecPerPageList(sList, iRec) Return record per page list (comma separated)
Parms
 sList - original record per page list
 iRec - default record per page
ew_GetEditDateFormat(dateformat) (v9+) Return edit date format
Parms
 dateformat - original date format
ew_IsFldVirtualLookup(fld) (v7.0+) Return if field is a virtual lookup field
Parms
 fld - field object
ew_IsFldForceSelect(fld) (v8.0+) Return if field is force select (auto suggest)
Parms
 fld - field object
ew_VirtualLookupFldSql(fld, idx) (v9+) Return the SQL for the virtual lookup field
Parms
 fld - field object
 idx - language index
ew_VirtualLookupFldName(fld) (v7.0+) Return the field name for the virtual lookup field
Parms
 fld - field object
ew_QuotedName(name) (v7.0+) Return the properly quoted sql name
Parms
 name - table/field name
ew_SqlConcatName(name1, name2, fld, idx) (v9+) Return the concat sql name
Parms
 name1 - field name 1
 name2 - field name 2
 fld - field object
 idx - language index
ew_FieldSqlName(fld) (v7.0+) Return the sql name for the field
Parms
 fld - field object
ew_VirtualTableInCustomView(CustomSQL, TblName) (v9+) Return if virtual table is in the custom view
Parms
 CustomSQL - custom view SQL
 TblName - table name

 

2. System Functions (Overridable)

USAGE: SYSTEMFUNCTIONS.<FunctionName>

Function Name Description
CharSet() Return <meta> tag for charset specified
FavIcon() (v7.0+) Return <link> tags for favicon specified
CSSFile() Return <link> tag for css file specified
GetScript(ScriptType, CodeType, ScriptName) Return server/client scripts
Parms
 ScriptType - script type (Server / Client)
 CodeType - code type (Global / Table / Other)
 ScriptName - script name
GetTemplateScript(Type,Name) (v9+) Return source custom template
Parms
 Type - template type (Table / Other)
 Name - template name
GetServerScript(CodeType, ScriptName) Return server scripts
GetClientScript(CodeType, ScriptName) Return client scripts
ScriptExist(ScriptType, CodeType, ScriptName) Return if script exists
Parms
 ScriptType - script type (Server / Client)
 CodeType - code type (Global / Table / Other)
 ScriptName - script name
ServerScriptExist(CodeType, ScriptName) Return if server script exists
ClientScriptExist(CodeType, ScriptName) Return if client script exists
CustomTemplateExist() (v9+) Return if custom template exists
CustomMultiPageTemplateExist() (v9+) Return if multi-page custom template Exists
CustomListOptions() (v9+) Return custom template list option type (block/blocknotd/single)
CustomTemplateSearchExist() (v9+) Return if list page custom search template exists
GetCustomTemplate() (v9+) Return translated custom template
GetCustomTemplatePage(pageid) (v9+) Return translated custom template for page (multi-page layout)
Parms
 pageid - page id (1/2/3/...)
ParseTemplate(template,id) (v9+) Return translated template
Parms
 template - source template
 id - template id
GetCustomTemplateSearch() (v9+) Return translated list page custom search template
RenderCustomTemplate() (v9+) Return rendering codes for custom template
RenderCustomTemplateSearch() (v9+) Return rendering codes for list page custom search template
GetCustomViewTemplate(fld) (v9+) Return custom view template for field
Parms
 fld - field object
ScriptTimeout() Return PHP script timeout codes
IsBoolFld() Return if field is boolean
PhpCgiPath() Return PHP CGI path
PhpDirective() Return PHP directives
NoCache() Return PHP No Cache codes
IncludeFile(fn, parm) Return PHP include file statement
Parms
 fn - file control id
 parm - extra parameter
Security() Return PHP security checking codes
ScriptInsert() Return PHP codes for inserting a record
ScriptUpdate() Return PHP codes for updating a record
Script(ctlid) Return PHP codes for inserting/updating a record
Parms
 ctlid - "insert" / "update"
ScriptUpdateFile() Return PHP codes for file upload to folder
ScriptUpdateSpecial() Return PHP codes for updating detail key/parent/user id field
ScriptCommon() Return PHP codes for rendering field (common)
ScriptViewRefer() Return PHP codes for rendering field for VIEW (HREF)
ScriptEditRefer() Return PHP codes for rendering field for EDIT (HREF)
ScriptView() Return PHP codes for rendering field for VIEW
ScriptViewCall(cv, vv) Return PHP codes for rendering field for VIEW
Parms
 cv - current value
 vv - view value
ScriptViewNo(cv, vv) Return PHP codes for rendering field for VIEW (AutoNumber field)
ScriptViewText(cv, vv) Return PHP codes for rendering field for VIEW (TEXT field)
ScriptViewHighlightSearch(cv, vv) Return PHP codes for rendering field for search highlight
ScriptViewFormat(fld,parm) (v9+) Return PHP codes to format field for VIEW
Parms
 fld - field object
 parm - field to be formatted
ScriptViewPassword(cv, vv) Return PHP codes for rendering field for VIEW (PASSWORD field)
ScriptViewRadio(cv, vv) Return PHP codes for rendering field for VIEW (RADIO field)
ScriptViewTable(cv, vv) Return PHP codes for rendering field for VIEW (Link to Table field)
ScriptViewValues(cv, vv) Return PHP codes for rendering field for VIEW (Lookup Value field)
ScriptViewCheckbox(cv, vv) Return PHP codes for rendering field for VIEW (CHECKBOX field)
ScriptViewSelect(cv, vv) Return PHP codes for rendering field for VIEW (SELECT field)
ScriptViewTextarea(cv, vv) Return PHP codes for rendering field for VIEW (TEXTAREA field)
ScriptViewHidden(cv, vv) Return PHP codes for rendering field for VIEW (HIDDEN field)
ScriptViewFile(cv, vv) Return PHP codes for rendering field for VIEW (FILE field)
ScriptViewHref(cv, vv) Return PHP codes for rendering field for VIEW (HREF field)
ScriptViewVirtual(wrk) Return PHP codes for rendering virtual lookup field
Parms
 wrk - original rendering codes
ScriptAdd() Return PHP codes for rendering field for ADD
ScriptEdit() Return PHP codes for rendering field for EDIT
ScriptEditCall(cv, ev, ctlid) Return PHP codes for rendering field for ADD/EDIT/SEARCH
Parms
 cv - current value
 ev - edit value
 ctlid - control id
ScriptEditFormat(ctl) (v9+) Return PHP codes to format field for EDIT
Parms
 ctl - control
ScriptSearch() Return PHP codes for rendering field for SEARCH (Search Field 1)
ScriptSearch2() Return PHP codes for rendering field for SEARCH (Search Field 2)
ScriptEditDefaultValue() Return PHP codes for rendering field for Default Value
ScriptEditNo(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (AutoNumber field)
ScriptEditText(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (TEXT field)
ScriptEditPassword(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (PASSWORD field)
ScriptEditRadio(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (RADIO field)
ScriptEditTable(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (Link to Table field)
ScriptEditUserID(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (User ID field)
ScriptEditValues(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (Lookup Value field)
ScriptEditCheckbox(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (CHECKBOX field)
ScriptEditSelect(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (SELECT field)
ScriptEditTextarea(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (TEXTAREA field)
ScriptEditHidden(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (HIDDEN field)
ScriptEditFile(cv, ev, ctlid) Return PHP codes for rendering field for EDIT (FILE field)
ScriptAggregate() Return PHP codes for rendering field for Aggregation
FieldCaption() Return field caption
FieldSearchCaption() Return field caption for search (list page)
FieldList() Return field control for LIST
FieldAggregate() Return field control for AGGREGATE
FieldView() Return field control for VIEW
FieldViewCall(cv, vv) Return field control for VIEW
Parms
 cv - current value
 vv - view value
FieldViewCheckbox(cv, vv) Return field control for VIEW (CHECKBOX field)
FieldViewFile(cv, vv) Return field control for VIEW (FILE field)
FieldViewFileConfirm(cv, vv) Return field control for VIEW (FILE field confirm page)
FieldViewText(cv, vv) Return field control for VIEW (TEXT field)
FieldViewHref(ctl) Return field control for VIEW (HREF field)
Parms
 ctl - control to be HREF
FieldUpdate() Return field control for UPDATE
FieldEdit() Return field control for EDIT
FieldEditPrimaryKey() Return field control for EDIT (Primary Key field)
FieldEditDetailKey() Return field control for EDIT (Detail Key field)
FieldAdd() Return field control for ADD
FieldSearch() Return field control for SEARCH (Search field 1)
FieldSearch2() Return field control for SEARCH (Search field 2)
FieldEditCall(ctl, cv, ev, ctlid) Return field control for EDIT
Parms
 ctl - control
 cv - current value
 ev - edit value
 ctlid - control id
FieldEditNo(ctl, cv, ev, ctlid) Return field control for EDIT (AutoNumber field)
FieldEditHidden(ctl, cv, ev, ctlid) Return field control for EDIT (HIDDEN field)
FieldEditRadio(ctl, cv, ev, ctlid) Return field control for EDIT (RADIO field)
FieldEditCheckbox(ctl, cv, ev, ctlid) Return field control for EDIT (CHECKBOX field)
FieldEditPassword(ctl, cv, ev, ctlid) Return field control for EDIT (PASSWORD field)
FieldEditSelect(ctl, cv, ev, ctlid) Return field control for EDIT (SELECT field)
FieldEditDynamicSelect(ctl, cv, ev, ctlid) Return field control for EDIT (Dynamic SELECT field)
FieldEditAjaxSelect(ctl, cv, ev, ctlid) Return field control for EDIT (Ajax SELECT field)
FieldEditAutofill(ctl, cv, ev, ctlid) Return field control for EDIT (Auto Fill field)
FieldEditFile(ctl, cv, ev, ctlid) Return field control for EDIT (FILE field)
FieldEditText(ctl, cv, ev, ctlid) Return field control for EDIT (TEXT field)
FieldEditTextarea(ctl, cv, ev, ctlid) Return field control for EDIT (TEXTAREA field)
FieldOperator() Return field control for search operator 1
FieldOperator2() Return field control for search operator 2
FieldOperatorCall(ctl, val, opr) Return field control for search operator
Parms
 ctl - control
 val - search value
 opr - operator
FieldSearchCondition() Return field control for search condition (BETWEEN or 2nd Opr enabled)
OrderByFieldSources() Return ORDER BY field sources (comma separated)
JsReqValidator() Return JS validator for required field
JsReqErrMsg() Return JS error message for required field
JsReqDefaultMsg() Return default JS error message for required field
JsValidator() Return JS validator
JsFileTypeValidator() Return JS validator for file type
JsErrMsg() Return JS error message
JsDefaultMsg() Return default JS error message
PhpReqValidator() Return PHP validator for required field
PhpReqErrMsg() Return PHP error message for required field
PhpReqDefaultMsg() Return default PHP error message for required field
PhpSearchValidator() Return PHP validator for search field
PhpValidator() Return PHP validator
PhpFileValidator() Return PHP validator for file type
PhpValidatorCommon(fld, msg) Return PHP validator
Parms
 fld - field
 msg - message
PhpErrMsg() Return PHP error message
PhpDefaultMsg() Return default PHP error message
IsAggregate() Return if aggregate is enabled
HasFileField() Return if any file fields exist
IsMultiPage() Return if multi-page is enabled
IsAutofillMasterField(ctlid) Return if field is auto fill master field
Parms
 ctlid - control id
IsFileRelatedField(fldname) Return if field is file related field
Parms
 fldname - field name
LookupSql(bDistinct, arFields, sFilter, sRunTimeFilterVar, bAddUserIDFilter, sSelectLimit) Return codes for lookup SQL
Parms
 bDinstinct - use DISTINCT
 arFields - field array
 sFilter - filter SQL
 sRunTimeFilterVar - run time filter variable
 bAddUserIDFilter - add user id filter
 sSelectLimit - SELECT LIMIT
SelectionList(ctlid) Return selection list in JSON
Parms
 ctlid - control id
ConnectionString() Return database connection string

 
 ©2002-2012 e.World Technology Ltd. All rights reserved.