public RunnerCipherer(dynamic _param_strTableName, dynamic _param_pSet_packed = null)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region default values
if (_param_pSet as Object == null)
{
_param_pSet = null;
}
#endregion
#region pass-by-value parameters
dynamic strTableName = XVar.Clone(_param_strTableName);
ProjectSettings pSet = XVar.Clone(_param_pSet);
#endregion
this.strTableName = XVar.Clone(strTableName);
setConnection();
this.key = XVar.Clone(this.connection._encryptInfo["key"]);
this.alg = XVar.Clone(this.connection._encryptInfo["alg"]);
this.mode = XVar.Clone(this.connection._encryptInfo["mode"]);
if (pSet != null)
{
this.pSet = XVar.UnPackProjectSettings(pSet);
}
else
{
this.pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(strTableName)));
}
}
public OrderClause(dynamic _param__pSet, dynamic _param__cipherer, dynamic _param__sessionPrefix, dynamic _param__connection, dynamic _param_needReadRequest = null)
{
#region default values
if (_param_needReadRequest as Object == null)
{
_param_needReadRequest = new XVar(false);
}
#endregion
#region pass-by-value parameters
dynamic _pSet = XVar.Clone(_param__pSet);
dynamic _cipherer = XVar.Clone(_param__cipherer);
dynamic _sessionPrefix = XVar.Clone(_param__sessionPrefix);
dynamic _connection = XVar.Clone(_param__connection);
dynamic needReadRequest = XVar.Clone(_param_needReadRequest);
#endregion
this.pSet = XVar.UnPackProjectSettings(_pSet);
this.cipherer = XVar.Clone(_cipherer);
this.sessionPrefix = XVar.Clone(_sessionPrefix);
this.connection = XVar.Clone(_connection);
if (XVar.Pack(needReadRequest))
{
readRequest();
}
}
public static XVar readSelectedRecordsFromRequest(dynamic _param_table)
{
#region pass-by-value parameters
dynamic table = XVar.Clone(_param_table);
#endregion
dynamic keyFields = XVar.Array(), selected_recs = XVar.Array();
ProjectSettings pSet;
if (XVar.Pack(!(XVar)(MVCFunctions.postvalue("selection"))))
{
return(XVar.Array());
}
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(table)));
keyFields = XVar.Clone(pSet.getTableKeys());
selected_recs = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> keyblock in MVCFunctions.EnumeratePOST("selection"))
{
dynamic arr = XVar.Array(), keys = XVar.Array();
arr = XVar.Clone(MVCFunctions.explode(new XVar("&"), (XVar)(keyblock.Value)));
if (MVCFunctions.count(arr) < MVCFunctions.count(keyFields))
{
continue;
}
keys = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> value in arr.GetEnumerator())
{
keys.InitAndSetArrayItem(MVCFunctions.urldecode((XVar)(value.Value)), keyFields[value.Key]);
}
selected_recs.InitAndSetArrayItem(keys, null);
}
return(selected_recs);
}
public FilterControl(dynamic _param_fName, dynamic _param_pageObj, dynamic _param_id, dynamic _param_viewControls)
{
#region pass-by-value parameters
dynamic fName = XVar.Clone(_param_fName);
dynamic pageObj = XVar.Clone(_param_pageObj);
dynamic id = XVar.Clone(_param_id);
dynamic viewControls = XVar.Clone(_param_viewControls);
#endregion
this.id = XVar.Clone(id);
this.fName = XVar.Clone(fName);
this.gfName = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(this.fName)));
this.tName = XVar.Clone(pageObj.tName);
this.connection = XVar.Clone(pageObj.connection);
this.pSet = XVar.UnPackProjectSettings(pageObj.pSet);
this.cipherer = XVar.Clone(pageObj.cipherer);
this.totalsOptions = XVar.Clone(new XVar(Constants.FT_COUNT, "COUNT", Constants.FT_MIN, "MIN", Constants.FT_MAX, "MAX"));
this.totals = XVar.Clone(this.pSet.getFilterFieldTotal((XVar)(fName)));
this.totalsfName = XVar.Clone(this.pSet.getFilterTotalsField((XVar)(fName)));
if ((XVar)(!(XVar)(this.totalsfName)) || (XVar)(this.totals == Constants.FT_COUNT))
{
this.totalsfName = XVar.Clone(this.fName);
}
this.useTotals = XVar.Clone(this.totals != Constants.FT_NONE);
this.multiSelect = XVar.Clone(this.pSet.getFilterFiledMultiSelect((XVar)(fName)));
this.whereComponents = XVar.Clone(getFullWhereComponent((XVar)(pageObj)));
this.filteredFields = XVar.Clone(pageObj.searchClauseObj.filteredFields);
this.fieldType = XVar.Clone(this.pSet.getFieldType((XVar)(this.fName)));
if (XVar.Pack(MVCFunctions.count(this.filteredFields[this.fName])))
{
this.filtered = new XVar(true);
}
assignViewControls((XVar)(viewControls));
this.showCollapsed = XVar.Clone(this.pSet.showCollapsed((XVar)(this.fName)));
}
public LoginPage(dynamic var_params)
: base((XVar)var_params)
{
if (skipLoginPageCtor)
{
skipLoginPageCtor = false;
return;
}
this.pSetEdit = XVar.UnPackProjectSettings(this.pSet);
this.pSetSearch = XVar.Clone(new ProjectSettings((XVar)(this.tName), new XVar(Constants.PAGE_SEARCH)));
this.auditObj = XVar.Clone(CommonFunctions.GetAuditObject());
if (XVar.Equals(XVar.Pack(getLayoutVersion()), XVar.Pack(Constants.PD_BS_LAYOUT)))
{
this.headerForms = XVar.Clone(new XVar(0, "top"));
this.footerForms = XVar.Clone(new XVar(0, "footer"));
this.bodyForms = XVar.Clone(new XVar(0, "above-grid", 1, "grid", 2, "superbottom"));
}
else
{
this.formBricks.InitAndSetArrayItem("loginheader", "header");
this.formBricks.InitAndSetArrayItem(new XVar(0, "loginbuttons", 1, "facebookbutton"), "footer");
assignFormFooterAndHeaderBricks(new XVar(true));
}
initMyURL();
initCredentials();
this.body = XVar.Clone(new XVar("begin", "", "end", ""));
}
public ViewControlsContainer(dynamic _param_pSet_packed, dynamic _param_pageType, dynamic _param_pageObject = null)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region default values
if (_param_pageObject as Object == null)
{
_param_pageObject = new XVar();
}
#endregion
#region pass-by-value parameters
ProjectSettings pSet = XVar.Clone(_param_pSet);
dynamic pageType = XVar.Clone(_param_pageType);
dynamic pageObject = XVar.Clone(_param_pageObject);
#endregion
this.pSet = XVar.UnPackProjectSettings(pSet);
this.pageType = XVar.Clone(pageType);
this.pageObject = XVar.Clone(pageObject);
this.tName = XVar.Clone(pSet.getTableName());
if (XVar.Pack(pageObject))
{
this.pSet.setPageMode((XVar)(pageObject.mode));
}
this.searchHighlight = XVar.Clone(highlightSearchResults());
}
public virtual XVar process()
{
setReferer();
if (XVar.Pack(GlobalVars.globalEvents.exists(new XVar("BeforeProcessChangePwd"))))
{
GlobalVars.globalEvents.BeforeProcessChangePwd(this);
}
if (this.action == "Change")
{
this.changedSuccess = XVar.Clone(changePassword());
}
if (XVar.Pack(!(XVar)(this.changedSuccess)))
{
prepareEditControls();
}
else
{
this.pageName = XVar.Clone(this.pSet.getDefaultPage((XVar)(successPageType())));
this.pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(this.tName), (XVar)(successPageType()), (XVar)(this.pageName), (XVar)(this.pageTable)));
this.pageData.InitAndSetArrayItem(MVCFunctions.array_merge((XVar)(this.pageData["buttons"]), (XVar)(this.pSet.buttons())), "buttons");
foreach (KeyValuePair <XVar, dynamic> b in this.pSet.buttons().GetEnumerator())
{
AddJSFile((XVar)(MVCFunctions.Concat("include/button_", b.Value, ".js")));
}
}
addCommonJs();
fillSetCntrlMaps();
addButtonHandlers();
doCommonAssignments();
showPage();
return(null);
}
public ListPage_Simple(dynamic var_params)
: base((XVar)var_params)
{
if (skipListPage_SimpleCtor)
{
skipListPage_SimpleCtor = false;
return;
}
this.pSetEdit = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(this.tName), new XVar(Constants.PAGE_SEARCH)));
}
protected virtual XVar checkIfLookupValueIsToProcess()
{
ProjectSettings pSet;
pSet = XVar.UnPackProjectSettings(this.container.pSet);
if ((XVar)((XVar)((XVar)(pSet.getLookupType((XVar)(this.field)) == Constants.LT_LOOKUPTABLE) || (XVar)(pSet.getLookupType((XVar)(this.field)) == Constants.LT_QUERY)) && (XVar)(pSet.getLinkField((XVar)(this.field)) == pSet.getDisplayField((XVar)(this.field)))) && (XVar)(pSet.multiSelect((XVar)(this.field))))
{
return(true);
}
return(false);
}
public static XVar getIntervalFilterWhere(dynamic _param_fName, dynamic _param_intervalData, dynamic _param_pSet_packed, dynamic _param_cipherer, dynamic _param_tableName, dynamic _param_connection, dynamic _param_sqlFieldName = null)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region default values
if (_param_sqlFieldName as Object == null)
{
_param_sqlFieldName = new XVar("");
}
#endregion
#region pass-by-value parameters
dynamic fName = XVar.Clone(_param_fName);
dynamic intervalData = XVar.Clone(_param_intervalData);
ProjectSettings pSet = XVar.Clone(_param_pSet);
dynamic cipherer = XVar.Clone(_param_cipherer);
dynamic tableName = XVar.Clone(_param_tableName);
dynamic connection = XVar.Clone(_param_connection);
dynamic sqlFieldName = XVar.Clone(_param_sqlFieldName);
#endregion
if (sqlFieldName == XVar.Pack(""))
{
sqlFieldName = XVar.Clone(RunnerPage._getFieldSQL((XVar)(fName), (XVar)(connection), (XVar)(pSet)));
}
if (XVar.Pack(intervalData["remainder"]))
{
dynamic conditions = XVar.Array(), index = null, intervalsData = XVar.Array();
index = XVar.Clone(intervalData["index"]);
intervalsData = XVar.Clone(pSet.getFilterIntervals((XVar)(fName)));
conditions = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> _intervalData in intervalsData.GetEnumerator())
{
if (XVar.Pack(_intervalData.Value["noLimits"]))
{
return("1=0");
}
if (_intervalData.Value["index"] == index)
{
continue;
}
conditions.InitAndSetArrayItem(getLimitsConditions((XVar)(fName), (XVar)(sqlFieldName), (XVar)(_intervalData.Value), (XVar)(cipherer), (XVar)(tableName), (XVar)(connection), new XVar(true)), null);
}
return(MVCFunctions.implode(new XVar(" AND "), (XVar)(conditions)));
}
if (XVar.Pack(intervalData["noLimits"]))
{
return(MVCFunctions.Concat(sqlFieldName, " is not NULL AND ", sqlFieldName, " <> '' "));
}
return(getLimitsConditions((XVar)(fName), (XVar)(sqlFieldName), (XVar)(intervalData), (XVar)(cipherer), (XVar)(tableName), (XVar)(connection)));
}
protected virtual XVar getLookupParams()
{
dynamic lookupParams = XVar.Array();
lookupParams = XVar.Clone(XVar.Array());
if (XVar.Pack(this.isFieldLookup))
{
ProjectSettings pSet;
pSet = XVar.UnPackProjectSettings(this.container.pSet);
lookupParams.InitAndSetArrayItem(pSet.multiSelect((XVar)(this.field)), "multiselect");
lookupParams.InitAndSetArrayItem(this.needLookupValueProcessing, "needLookupProcessing");
lookupParams.InitAndSetArrayItem(this.container.linkFieldValues[this.field], "linkFieldValue");
lookupParams.InitAndSetArrayItem(this.container.originlinkValues[this.field], "originLinkValue");
}
return(lookupParams);
}
public SearchControl(dynamic _param_id, dynamic _param_tName, dynamic searchClauseObj, dynamic pageObj)
{
#region pass-by-value parameters
dynamic id = XVar.Clone(_param_id);
dynamic tName = XVar.Clone(_param_tName);
#endregion
this.tName = XVar.Clone(tName);
this.searchClauseObj = XVar.Clone(searchClauseObj);
this.getSrchPanelAttrs = XVar.Clone(this.searchClauseObj.getSrchPanelAttrs());
this.globSrchParams = XVar.Clone(this.searchClauseObj.getSearchGlobalParams());
this.id = XVar.Clone(id);
this.pageObj = pageObj;
this.pSet = XVar.UnPackProjectSettings((XVar.Pack(this.pageObj.pageType != Constants.PAGE_SEARCH) ? XVar.Pack(new ProjectSettings((XVar)(tName), new XVar(Constants.PAGE_SEARCH))) : XVar.Pack(this.pageObj.pSetSearch)));
this.controlsContainer = XVar.Clone(new EditControlsContainer((XVar)(this.pageObj), (XVar)(this.pSet), new XVar(Constants.PAGE_SEARCH), (XVar)(this.pageObj.cipherer)));
}
public static XVar Format(dynamic _param_data, dynamic _param_field, dynamic _param_table)
{
#region pass-by-value parameters
dynamic data = XVar.Clone(_param_data);
dynamic field = XVar.Clone(_param_field);
dynamic table = XVar.Clone(_param_table);
#endregion
dynamic viewControls = null;
ProjectSettings pSet;
if (XVar.Pack(!(XVar)(table)))
{
table = XVar.Clone(GlobalVars.strTableName);
}
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(table)));
viewControls = XVar.Clone(new ViewControlsContainer((XVar)(pSet), new XVar(Constants.PAGE_VIEW)));
return(viewControls.getControl((XVar)(field)).getTextValue((XVar)(data)));
}
public virtual XVar getDateEditType(dynamic _param_pSet_packed = null)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region default values
if (_param_pSet as Object == null)
{
_param_pSet = null;
}
#endregion
#region pass-by-value parameters
ProjectSettings pSet = XVar.Clone(_param_pSet);
#endregion
dynamic dateEditType = null;
if (XVar.Pack(!(XVar)(pSet)))
{
pSet = XVar.UnPackProjectSettings(getProjectSettings());
}
dateEditType = XVar.Clone(pSet.getDateEditType((XVar)(this.field)));
if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT)
{
if ((XVar)((XVar)((XVar)(this.pageObject.pageType == Constants.PAGE_LIST) || (XVar)(this.pageObject.pageType == Constants.PAGE_CHART)) || (XVar)(this.pageObject.pageType == Constants.PAGE_REPORT)) || (XVar)((XVar)(this.pageObject.pageType == Constants.PAGE_SEARCH) && (XVar)(this.pageObject.mode == Constants.SEARCH_LOAD_CONTROL)))
{
if (dateEditType == Constants.EDIT_DATE_DD)
{
return(Constants.EDIT_DATE_SIMPLE);
}
if (dateEditType == Constants.EDIT_DATE_DD_DP)
{
return(Constants.EDIT_DATE_SIMPLE_DP);
}
if (dateEditType == Constants.EDIT_DATE_DD_INLINE)
{
return(Constants.EDIT_DATE_SIMPLE_INLINE);
}
}
}
return(dateEditType);
}
public LoginPage(dynamic var_params)
: base((XVar)var_params)
{
if (skipLoginPageCtor)
{
skipLoginPageCtor = false;
return;
}
this.pSet = XVar.UnPackProjectSettings(new ProjectSettings(new XVar("dbo._ABCSecurity"), (XVar)(this.pageType)));
this.pSetEdit = XVar.UnPackProjectSettings(this.pSet);
this.pSetSearch = XVar.Clone(new ProjectSettings((XVar)(this.tName), new XVar(Constants.PAGE_SEARCH)));
this.auditObj = XVar.Clone(CommonFunctions.GetAuditObject());
this.formBricks.InitAndSetArrayItem("loginheader", "header");
this.formBricks.InitAndSetArrayItem(new XVar(0, "loginbuttons", 1, "facebookbutton"), "footer");
assignFormFooterAndHeaderBricks(new XVar(true));
initMyURL();
initCredentials();
this.body = XVar.Clone(new XVar("begin", "", "end", ""));
}
protected override XVar fillTableSettings(dynamic _param_table = null, dynamic _param_pSet_packed = null)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region default values
if (_param_table as Object == null)
{
_param_table = new XVar("");
}
if (_param_pSet as Object == null)
{
_param_pSet = null;
}
#endregion
#region pass-by-value parameters
dynamic table = XVar.Clone(_param_table);
ProjectSettings pSet = XVar.Clone(_param_pSet);
#endregion
base.fillTableSettings((XVar)(table), (XVar)(pSet));
if (XVar.Pack(addAvailable()))
{
this.jsSettings.InitAndSetArrayItem(true, "tableSettings", this.tName, "showAddInPopup");
}
if ((XVar)(editAvailable()) || (XVar)(updateSelectedAvailable()))
{
this.jsSettings.InitAndSetArrayItem(true, "tableSettings", this.tName, "showEditInPopup");
}
if (XVar.Pack(viewAvailable()))
{
this.jsSettings.InitAndSetArrayItem(true, "tableSettings", this.tName, "showViewInPopup");
}
if (XVar.Pack(inlineEditAvailable()))
{
this.jsSettings.InitAndSetArrayItem(true, "tableSettings", this.tName, "inlineEditAvailable");
}
return(null);
}
public EditControlsContainer(dynamic _param_pageObject, dynamic _param_pSetEdit_packed, dynamic _param_pageType, dynamic _param_cipherer = null)
{
#region packeted values
ProjectSettings _param_pSetEdit = XVar.UnPackProjectSettings(_param_pSetEdit_packed);
#endregion
#region default values
if (_param_cipherer as Object == null)
{
_param_cipherer = new XVar("");
}
#endregion
#region pass-by-value parameters
dynamic pageObject = XVar.Clone(_param_pageObject);
ProjectSettings pSetEdit = XVar.Clone(_param_pSetEdit);
dynamic pageType = XVar.Clone(_param_pageType);
dynamic cipherer = XVar.Clone(_param_cipherer);
#endregion
if (pageObject != null)
{
this.pageObject = XVar.Clone(pageObject);
this.pageAddLikeInline = XVar.Clone((XVar)(pageObject.pageType == Constants.PAGE_ADD) && (XVar)(pageObject.mode == Constants.ADD_INLINE));
this.pageEditLikeInline = XVar.Clone((XVar)(pageObject.pageType == Constants.PAGE_EDIT) && (XVar)(pageObject.mode == Constants.EDIT_INLINE));
this.tName = XVar.Clone(pageObject.tName);
}
else
{
this.tName = XVar.Clone(pSetEdit._table);
this.cipherer = XVar.Clone(cipherer);
}
fillControlClassNames();
setEditControlsConnection();
this.pSetEdit = XVar.UnPackProjectSettings(pSetEdit);
this.pageType = XVar.Clone(pageType);
this.searchPanelActivated = new XVar(true);
}
public SearchPanel(dynamic var_params)
{
CommonFunctions.RunnerApply(this, (XVar)(var_params));
this.searchClauseObj = this.pageObj.searchClauseObj;
this.id = XVar.Clone(this.pageObj.id);
this.pSet = XVar.UnPackProjectSettings(this.pageObj.pSetSearch);
this.tName = XVar.Clone(this.pageObj.searchTableName);
this.xt = XVar.UnPackXTempl(this.pageObj.xt);
this.panelState = XVar.Clone(this.searchClauseObj.getSrchPanelAttrs());
this.isUseAjaxSuggest = XVar.Clone(this.pSet.isUseAjaxSuggest());
if (XVar.Pack(this.pageObj.mobileTemplateMode()))
{
this.isUseAjaxSuggest = new XVar(false);
}
this.searchControlBuilder = XVar.Clone(new PanelSearchControl((XVar)(this.id), (XVar)(this.tName), (XVar)(this.searchClauseObj), (XVar)(this.pageObj)));
if (XVar.Pack(!(XVar)(var_params.KeyExists("panelSearchFields"))))
{
this.panelSearchFields = XVar.Clone(this.pSet.getPanelSearchFields());
}
if (XVar.Pack(!(XVar)(var_params.KeyExists("allSearchFields"))))
{
this.allSearchFields = XVar.Clone(this.pSet.getAllSearchFields());
}
}
public virtual XVar LogEdit(dynamic _param_str_table, dynamic _param_newvalues, dynamic _param_oldvalues, dynamic _param_keys)
{
#region pass-by-value parameters
dynamic str_table = XVar.Clone(_param_str_table);
dynamic newvalues = XVar.Clone(_param_newvalues);
dynamic oldvalues = XVar.Clone(_param_oldvalues);
dynamic keys = XVar.Clone(_param_keys);
#endregion
dynamic retval = null, table = null;
ProjectSettings pSet;
retval = new XVar(true);
table = XVar.Clone(str_table);
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(str_table)));
if (XVar.Pack(GlobalVars.globalEvents.exists(new XVar("OnAuditLog"))))
{
retval = XVar.Clone(GlobalVars.globalEvents.OnAuditLog((XVar)(this.strEdit), (XVar)(this.var_params), (XVar)(table), (XVar)(keys), (XVar)(newvalues), (XVar)(oldvalues)));
}
if (XVar.Pack(retval))
{
dynamic key = null, putsValue = null, str = null, str_add = null;
if (0 < MVCFunctions.count(keys))
{
key = new XVar("");
foreach (KeyValuePair <XVar, dynamic> val in keys.GetEnumerator())
{
if (key != XVar.Pack(""))
{
key = MVCFunctions.Concat(key, ",");
}
key = MVCFunctions.Concat(key, val.Value);
}
}
str = XVar.Clone(MVCFunctions.Concat(CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(MVCFunctions.now()))), new XVar("MMM dd,yyyy")), MVCFunctions.chr(new XVar(9)), CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(MVCFunctions.now()))), new XVar("HH:mm:ss")), MVCFunctions.chr(new XVar(9)), this.var_params[0], MVCFunctions.chr(new XVar(9)), this.var_params[1], MVCFunctions.chr(new XVar(9)), table, MVCFunctions.chr(new XVar(9)), this.strEdit, MVCFunctions.chr(new XVar(9)), key));
putsValue = new XVar(true);
str_add = new XVar("");
if (XVar.Pack(logValueEnable((XVar)(str_table))))
{
foreach (KeyValuePair <XVar, dynamic> val in newvalues.GetEnumerator())
{
dynamic newvalue = null, oldvalue = null, var_type = null;
var_type = XVar.Clone(pSet.getFieldType((XVar)(val.Key)));
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(var_type))))
{
continue;
}
if (XVar.Pack(CommonFunctions.IsDateFieldType((XVar)(var_type))))
{
newvalue = XVar.Clone(CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(newvalues[val.Key]))), new XVar("yyyy-MM-dd HH:mm:ss")));
oldvalue = XVar.Clone(CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(oldvalues[val.Key]))), new XVar("yyyy-MM-dd HH:mm:ss")));
}
else
{
newvalue = XVar.Clone(newvalues[val.Key]);
oldvalue = XVar.Clone(oldvalues[val.Key]);
}
if (newvalue != oldvalue)
{
dynamic v1 = null, v2 = null;
v1 = new XVar("");
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(var_type))))
{
v1 = new XVar("<binary value>");
}
else
{
v1 = XVar.Clone(MVCFunctions.str_replace((XVar)(new XVar(0, "\r\n", 1, "\n", 2, "\t")), new XVar(" "), (XVar)(oldvalue)));
if (this.maxFieldLength < MVCFunctions.strlen((XVar)(v1)))
{
v1 = XVar.Clone(MVCFunctions.runner_substr((XVar)(v1), new XVar(0), (XVar)(this.maxFieldLength)));
}
}
v2 = new XVar("");
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(var_type))))
{
v2 = new XVar("<binary value>");
}
else
{
v2 = XVar.Clone(MVCFunctions.str_replace((XVar)(new XVar(0, "\r\n", 1, "\n", 2, "\t")), new XVar(" "), (XVar)(newvalue)));
if (this.maxFieldLength < MVCFunctions.strlen((XVar)(v2)))
{
v2 = XVar.Clone(MVCFunctions.runner_substr((XVar)(v2), new XVar(0), (XVar)(this.maxFieldLength)));
}
}
str_add = MVCFunctions.Concat(str_add, str, MVCFunctions.chr(new XVar(9)), val.Key, MVCFunctions.chr(new XVar(9)), v1, MVCFunctions.chr(new XVar(9)), v2, "\r\n");
}
}
}
else
{
str_add = MVCFunctions.Concat(str_add, str, "\r\n");
}
writeToLogFile((XVar)(str_add));
}
return(retval);
}
public override XVar addFieldsSettings(dynamic _param_arrFields, dynamic _param_pSet_packed, dynamic _param_pageBased, dynamic _param_pageType)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region pass-by-value parameters
dynamic arrFields = XVar.Clone(_param_arrFields);
ProjectSettings pSet = XVar.Clone(_param_pSet);
dynamic pageBased = XVar.Clone(_param_pageBased);
dynamic pageType = XVar.Clone(_param_pageType);
#endregion
dynamic dashSearchFields = XVar.Array(), tableSettingsFilled = XVar.Array();
dashSearchFields = XVar.Clone(this.pSet.getDashboardSearchFields());
tableSettingsFilled = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> fieldName in arrFields.GetEnumerator())
{
dynamic lookupTableName = null, tableFieldName = null, tableName = null;
tableName = XVar.Clone(dashSearchFields[fieldName.Value][0]["table"]);
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(tableName), (XVar)(pageType)));
tableFieldName = XVar.Clone(dashSearchFields[fieldName.Value][0]["field"]);
if (XVar.Pack(!(XVar)(tableSettingsFilled[tableName])))
{
fillTableSettings((XVar)(tableName), (XVar)(pSet));
tableSettingsFilled.InitAndSetArrayItem(true, tableName);
}
if (XVar.Pack(!(XVar)(this.jsSettings["tableSettings"][this.tName]["fieldSettings"].KeyExists(fieldName.Value))))
{
this.jsSettings.InitAndSetArrayItem(XVar.Array(), "tableSettings", this.tName, "fieldSettings", fieldName.Value);
}
if (XVar.Pack(!(XVar)(this.jsSettings["tableSettings"][this.tName]["fieldSettings"][fieldName.Value].KeyExists(pageType))))
{
this.jsSettings.InitAndSetArrayItem(XVar.Array(), "tableSettings", this.tName, "fieldSettings", fieldName.Value, pageType);
}
foreach (KeyValuePair <XVar, dynamic> val in this.settingsMap["fieldSettings"].GetEnumerator())
{
dynamic fData = XVar.Array(), isDefault = null;
fData = XVar.Clone(pSet.getFieldData((XVar)(tableFieldName), (XVar)(val.Key)));
if (val.Key == "validateAs")
{
if ((XVar)((XVar)(pageType == Constants.PAGE_ADD) || (XVar)(pageType == Constants.PAGE_EDIT)) || (XVar)(pageType == Constants.PAGE_REGISTER))
{
fillValidation((XVar)(fData), (XVar)(val.Value), (XVar)(this.jsSettings["tableSettings"][this.tName]["fieldSettings"][fieldName.Value][pageType]));
}
continue;
}
if (val.Key == "RTEType")
{
fData = XVar.Clone(pSet.getRTEType((XVar)(tableFieldName)));
if (fData == "RTECK")
{
this.isUseCK = new XVar(true);
this.jsSettings.InitAndSetArrayItem(pSet.getNCols((XVar)(tableFieldName)), "tableSettings", this.tName, "fieldSettings", fieldName.Value, pageType, "nWidth");
this.jsSettings.InitAndSetArrayItem(pSet.getNRows((XVar)(tableFieldName)), "tableSettings", this.tName, "fieldSettings", fieldName.Value, pageType, "nHeight");
}
}
else
{
if (val.Key == "autoCompleteFields")
{
fData = XVar.Clone(pSet.getAutoCompleteFields((XVar)(tableFieldName)));
}
else
{
if (val.Key == "parentFields")
{
fData = XVar.Clone(pSet.getLookupParentFNames((XVar)(tableFieldName)));
foreach (KeyValuePair <XVar, dynamic> parentField in fData.GetEnumerator())
{
fData.InitAndSetArrayItem(locateDashFieldByOriginal((XVar)(tableName), (XVar)(parentField.Value)), parentField.Key);
}
}
}
}
isDefault = new XVar(false);
if (XVar.Pack(MVCFunctions.is_array((XVar)(fData))))
{
isDefault = XVar.Clone(!(XVar)(MVCFunctions.count(fData)));
}
else
{
if (XVar.Pack(!(XVar)(MVCFunctions.is_array((XVar)(val.Value["default"])))))
{
isDefault = XVar.Clone(XVar.Equals(XVar.Pack(fData), XVar.Pack(val.Value["default"])));
}
}
if (XVar.Pack(!(XVar)(isDefault)))
{
this.jsSettings.InitAndSetArrayItem(fData, "tableSettings", this.tName, "fieldSettings", fieldName.Value, pageType, val.Value["jsName"]);
}
}
this.jsSettings.InitAndSetArrayItem(tableName, "tableSettings", this.tName, "fieldSettings", fieldName.Value, pageType, "originalTable");
this.jsSettings.InitAndSetArrayItem(tableFieldName, "tableSettings", this.tName, "fieldSettings", fieldName.Value, pageType, "originalField");
this.jsSettings.InitAndSetArrayItem(this.isUseCK, "tableSettings", this.tName, "isUseCK");
if ((XVar)(MVCFunctions.count(this.googleMapCfg) != 0) && (XVar)(this.googleMapCfg["isUseGoogleMap"]))
{
this.jsSettings.InitAndSetArrayItem(true, "tableSettings", this.tName, "isUseGoogleMap");
this.jsSettings.InitAndSetArrayItem(this.googleMapCfg, "tableSettings", this.tName, "googleMapCfg");
}
lookupTableName = XVar.Clone(pSet.getLookupTable((XVar)(tableFieldName)));
if (XVar.Pack(lookupTableName))
{
this.jsSettings.InitAndSetArrayItem(CommonFunctions.GetTableURL((XVar)(lookupTableName)), "global", "shortTNames", lookupTableName);
}
if (pSet.getEditFormat((XVar)(tableFieldName)) == "Time")
{
fillTimePickSettings((XVar)(tableFieldName), new XVar(""), (XVar)(pSet), (XVar)(pageType));
}
}
return(null);
}
public ViewLookupWizardField(dynamic _param_field, dynamic _param_container, dynamic _param_pageObject)
: base((XVar)_param_field, (XVar)_param_container, (XVar)_param_pageObject)
{
if (skipViewLookupWizardFieldCtor)
{
skipViewLookupWizardFieldCtor = false;
return;
}
#region pass-by-value parameters
dynamic field = XVar.Clone(_param_field);
dynamic container = XVar.Clone(_param_container);
dynamic pageObject = XVar.Clone(_param_pageObject);
#endregion
this.lookupPSet = new XVar(null);
this.cipherer = new XVar(null);
this.lookupQueryObj = new XVar(null);
this.displayFieldIndex = new XVar(0);
this.linkFieldIndex = new XVar(1);
this.LookupSQL = new XVar("");
if (this.container.pSet.getEditFormat((XVar)(field)) != Constants.EDIT_FORMAT_LOOKUP_WIZARD)
{
this.pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(this.container.pSet._table)));
this.pSet.setPageType((XVar)(this.container.pageType));
this.pSet.setPageType((XVar)(this.container.pSet.getPageTypeByFieldEditFormat((XVar)(field), new XVar(Constants.EDIT_FORMAT_LOOKUP_WIZARD))));
}
else
{
this.pSet = XVar.UnPackProjectSettings(this.container.pSet);
}
this.nLookupType = XVar.Clone(this.pSet.getLookupType((XVar)(this.field)));
this.lookupTable = XVar.Clone(this.pSet.getLookupTable((XVar)(this.field)));
setLookupConnection();
this.displayFieldName = XVar.Clone(this.pSet.getDisplayField((XVar)(this.field)));
this.linkFieldName = XVar.Clone(this.pSet.getLinkField((XVar)(this.field)));
this.linkAndDisplaySame = XVar.Clone(this.displayFieldName == this.linkFieldName);
if (this.nLookupType == Constants.LT_QUERY)
{
dynamic lookupIndexes = XVar.Array();
this.lookupPSet = XVar.Clone(new ProjectSettings((XVar)(this.lookupTable), (XVar)(this.container.pageType)));
this.cipherer = XVar.Clone(new RunnerCipherer((XVar)(this.lookupTable)));
this.lookupQueryObj = XVar.Clone(this.lookupPSet.getSQLQuery().CloneObject());
if (XVar.Pack(this.pSet.getCustomDisplay((XVar)(this.field))))
{
this.lookupQueryObj.AddCustomExpression((XVar)(this.displayFieldName), (XVar)(this.lookupPSet), (XVar)(this.pSet._table), (XVar)(this.field));
}
this.lookupQueryObj.ReplaceFieldsWithDummies((XVar)(this.lookupPSet.getBinaryFieldsIndices()));
lookupIndexes = XVar.Clone(CommonFunctions.GetLookupFieldsIndexes((XVar)(this.pSet), (XVar)(this.field)));
this.displayFieldIndex = XVar.Clone(lookupIndexes["displayFieldIndex"]);
this.linkFieldIndex = XVar.Clone(lookupIndexes["linkFieldIndex"]);
}
else
{
this.cipherer = XVar.Clone(new RunnerCipherer((XVar)(this.pSet._table)));
this.LookupSQL = new XVar("SELECT ");
this.LookupSQL = MVCFunctions.Concat(this.LookupSQL, RunnerPage.sqlFormattedDisplayField((XVar)(this.field), (XVar)(this.lookupConnection), (XVar)(this.pSet)));
this.LookupSQL = MVCFunctions.Concat(this.LookupSQL, ", ", this.lookupConnection.addFieldWrappers((XVar)(this.pSet.getLinkField((XVar)(this.field)))));
this.LookupSQL = MVCFunctions.Concat(this.LookupSQL, " FROM ", this.lookupConnection.addTableWrappers((XVar)(this.lookupTable)), " WHERE ");
}
this.localControlsContainer = XVar.Clone(new ViewControlsContainer((XVar)(this.pSet), (XVar)(this.container.pageType), (XVar)(pageObject)));
this.localControlsContainer.isLocal = new XVar(true);
}
public static XVar getTimeSliderWhere(dynamic _param_fName, dynamic _param_pSet_packed, dynamic _param_cipherer, dynamic _param_table, dynamic _param_SearchFor, dynamic _param_SearchFor2, dynamic _param_strSearchOption, dynamic _param_fullFieldName)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region pass-by-value parameters
dynamic fName = XVar.Clone(_param_fName);
ProjectSettings pSet = XVar.Clone(_param_pSet);
dynamic cipherer = XVar.Clone(_param_cipherer);
dynamic table = XVar.Clone(_param_table);
dynamic SearchFor = XVar.Clone(_param_SearchFor);
dynamic SearchFor2 = XVar.Clone(_param_SearchFor2);
dynamic strSearchOption = XVar.Clone(_param_strSearchOption);
dynamic fullFieldName = XVar.Clone(_param_fullFieldName);
#endregion
dynamic cleanvalue2 = null, firstDelimPos = null, hours = null, lastDelimPos = null, minutes = null, seconds = null, stepType = null, timeArr = XVar.Array(), value1 = null, value2 = null;
firstDelimPos = XVar.Clone(MVCFunctions.strpos((XVar)(SearchFor), new XVar(":")));
lastDelimPos = XVar.Clone(MVCFunctions.strrpos((XVar)(SearchFor), new XVar(":")));
if ((XVar)(XVar.Equals(XVar.Pack(firstDelimPos), XVar.Pack(false))) || (XVar)(firstDelimPos == lastDelimPos))
{
return("");
}
stepType = XVar.Clone(pSet.getFilterStepType((XVar)(fName)));
value1 = XVar.Clone(cipherer.MakeDBValue((XVar)(fName), (XVar)(SearchFor), new XVar(""), new XVar(true)));
switch (((XVar)strSearchOption).ToString())
{
case "slider":
firstDelimPos = XVar.Clone(MVCFunctions.strpos((XVar)(SearchFor2), new XVar(":")));
lastDelimPos = XVar.Clone(MVCFunctions.strrpos((XVar)(SearchFor2), new XVar(":")));
if ((XVar)(XVar.Equals(XVar.Pack(firstDelimPos), XVar.Pack(false))) || (XVar)(firstDelimPos == lastDelimPos))
{
return("");
}
cleanvalue2 = XVar.Clone(CommonFunctions.prepare_for_db((XVar)(fName), (XVar)(SearchFor2), new XVar("")));
timeArr = XVar.Clone(CommonFunctions.parsenumbers((XVar)(cleanvalue2)));
if (stepType == Constants.FSST_SECONDS)
{
timeArr = XVar.Clone(CommonFunctions.addSecondsToTime((XVar)(timeArr), new XVar(1)));
}
else
{
timeArr = XVar.Clone(CommonFunctions.addMinutesToTime((XVar)(timeArr), new XVar(1)));
}
hours = XVar.Clone((XVar.Pack(timeArr[0] < 10) ? XVar.Pack(MVCFunctions.Concat("0", timeArr[0])) : XVar.Pack(timeArr[0])));
minutes = XVar.Clone((XVar.Pack(timeArr[1] < 10) ? XVar.Pack(MVCFunctions.Concat("0", timeArr[1])) : XVar.Pack(timeArr[1])));
seconds = XVar.Clone((XVar.Pack(timeArr[2] < 10) ? XVar.Pack(MVCFunctions.Concat("0", timeArr[2])) : XVar.Pack(timeArr[2])));
value2 = XVar.Clone(MVCFunctions.Concat(hours, ":", minutes, ":", seconds));
value2 = XVar.Clone(CommonFunctions.add_db_quotes((XVar)(fName), (XVar)(value2), (XVar)(table)));
return(MVCFunctions.Concat(fullFieldName, ">=", value1, " and ", fullFieldName, "<", value2));
case "moreequal":
return(MVCFunctions.Concat(fullFieldName, ">=", value1));
case "lessequal":
return(MVCFunctions.Concat(fullFieldName, "<=", value1));
default:
return("");
}
return(null);
}
public XVar rte()
{
try
{
dynamic _connection = null, cfield = null, data = XVar.Array(), field = null, id = null, nHeight = null, nWidth = null, onsubmit = null, ptype = null, table = null;
ProjectSettings pSet;
table = XVar.Clone(MVCFunctions.postvalue(new XVar("table")));
if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table)))))
{
MVCFunctions.Echo(new XVar(0));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""),
"_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null);
if ((XVar)((XVar)(!(XVar)(CommonFunctions.isLogged())) || (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) && (XVar)(MVCFunctions.postvalue("action") != "add"))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
ptype = XVar.Clone(MVCFunctions.postvalue(new XVar("ptype")));
field = XVar.Clone(MVCFunctions.postvalue(new XVar("field")));
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(ptype)));
if ((XVar)(!(XVar)(pSet.checkFieldPermissions((XVar)(field)))) && (XVar)(MVCFunctions.postvalue("action") != "add"))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
_connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName)));
data = new XVar(false);
if (MVCFunctions.postvalue("action") != "add")
{
dynamic keys = XVar.Array(), keysArr = XVar.Array(), qResult = null, sql = null, where = null;
keysArr = XVar.Clone(pSet.getTableKeys());
keys = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> k in keysArr.GetEnumerator())
{
keys.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("key", k.Key + 1))), k.Value);
}
where = XVar.Clone(CommonFunctions.KeyWhere((XVar)(keys)));
if (pSet.getAdvancedSecurityType() == Constants.ADVSECURITY_VIEW_OWN)
{
where = XVar.Clone(CommonFunctions.whereAdd((XVar)(where), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(GlobalVars.strTableName)))));
}
sql = XVar.Clone(GlobalVars.gQuery.gSQLWhere((XVar)(where)));
qResult = XVar.Clone(_connection.query((XVar)(sql)));
if (XVar.Pack(!(XVar)(qResult)))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
data = XVar.Clone(qResult.fetchAssoc());
}
else
{
data = XVar.Clone(XVar.Array());
data.InitAndSetArrayItem(XSession.Session[MVCFunctions.Concat(GlobalVars.strTableName, "_", field, "_rte")], field);
}
nWidth = XVar.Clone(pSet.getNCols((XVar)(field)));
nHeight = XVar.Clone(pSet.getNRows((XVar)(field)));
id = XVar.Clone(MVCFunctions.postvalue(new XVar("id")));
cfield = XVar.Clone(MVCFunctions.Concat("value_", MVCFunctions.GoodFieldName((XVar)(field)), "_", (XVar.Pack(!XVar.Equals(XVar.Pack(id), XVar.Pack(""))) ? XVar.Pack(id) : XVar.Pack("1"))));
if (MVCFunctions.postvalue("browser") == "ie")
{
onsubmit = new XVar("onsubmit=\"updateRTEs();\"");
}
else
{
onsubmit = XVar.Clone(MVCFunctions.Concat("onsubmit=\"updateRTEs();return this.elements['", cfield, "'].value;\""));
}
MVCFunctions.Echo(MVCFunctions.Concat("<html><body style=\"margin:0;\"><form name=\"rteform\" ", onsubmit, ">"));
MVCFunctions.Echo(MVCFunctions.Concat("<script type=\"text/javascript\" src=\"", MVCFunctions.GetRootPathForResources(new XVar("include/rte/richtext.js")), "\"></script>\r\n"));
MVCFunctions.Echo("<script language=\"JavaScript\" type=\"text/javascript\">");
MVCFunctions.Echo("initRTE('include/rte/images/', 'include/rte/', '');\r\n");
MVCFunctions.Echo(MVCFunctions.Concat("{var rte = new richTextEditor('", cfield, "');"));
MVCFunctions.Echo(MVCFunctions.Concat("rte.width= ", nWidth, ";"));
MVCFunctions.Echo(MVCFunctions.Concat("rte.height= ", nHeight, ";"));
MVCFunctions.Echo("rte.html = '");
if ((XVar)(data) && (XVar)(data[field] != null))
{
MVCFunctions.Echo(CommonFunctions.jsreplace((XVar)(data[field])));
}
MVCFunctions.Echo("';");
MVCFunctions.Echo("rte.build();}");
MVCFunctions.Echo("</script>");
MVCFunctions.Echo("</form></body></html>");
return(MVCFunctions.GetBuferContentAndClearBufer());
}
catch (RunnerRedirectException ex)
{ return(Redirect(ex.Message)); }
}
public XVar searchsuggest()
{
try
{
dynamic _connection = null, allSearchFields = null, dashSearchFields = XVar.Array(), dashSettings = null, detailKeys = XVar.Array(), forDashboardSimpleSearch = null, numberOfSuggests = null, pSetList = null, pageType = null, result = XVar.Array(), returnJSON = XVar.Array(), searchClauseObj = null, searchField = null, searchFor = null, searchOpt = null, table = null, whereClauses = XVar.Array();
ProjectSettings pSet;
CommonFunctions.add_nocache_headers();
table = XVar.Clone(MVCFunctions.postvalue(new XVar("table")));
GlobalVars.strTableName = XVar.Clone(CommonFunctions.GetTableByShort((XVar)(table)));
if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table)))))
{
MVCFunctions.Echo(new XVar(0));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""),
"_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null);
if (XVar.Pack(!(XVar)(CommonFunctions.isLogged())))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search")))))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
searchFor = XVar.Clone(MVCFunctions.trim((XVar)(MVCFunctions.postvalue(new XVar("searchFor")))));
if (searchFor == XVar.Pack(""))
{
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(new XVar("success", true, "result", ""))));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
searchOpt = XVar.Clone((XVar.Pack(MVCFunctions.postvalue(new XVar("start"))) ? XVar.Pack("Starts with") : XVar.Pack("Contains")));
searchField = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(MVCFunctions.postvalue(new XVar("searchField")))));
numberOfSuggests = XVar.Clone(CommonFunctions.GetGlobalData(new XVar("searchSuggestsNumber"), new XVar(10)));
whereClauses = XVar.Clone(XVar.Array());
pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType")));
if (XVar.Pack(!(XVar)(pageType)))
{
pageType = new XVar(Constants.PAGE_LIST);
}
forDashboardSimpleSearch = XVar.Clone((XVar)(!(XVar)(searchField)) && (XVar)(pageType == Constants.PAGE_DASHBOARD));
if (XVar.Pack(forDashboardSimpleSearch))
{
dynamic dashGoogleLikeFields = XVar.Array(), sfdata = XVar.Array();
dashSettings = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), new XVar(Constants.PAGE_DASHBOARD)));
dashGoogleLikeFields = XVar.Clone(dashSettings.getGoogleLikeFields());
dashSearchFields = XVar.Clone(dashSettings.getDashboardSearchFields());
sfdata = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> g in dashGoogleLikeFields.GetEnumerator())
{
foreach (KeyValuePair <XVar, dynamic> data in dashSearchFields[g.Value].GetEnumerator())
{
sfdata.InitAndSetArrayItem(data.Value["field"], data.Value["table"], null);
}
}
foreach (KeyValuePair <XVar, dynamic> fields in sfdata.GetEnumerator())
{
dynamic _result = XVar.Array();
if (numberOfSuggests <= MVCFunctions.count(result))
{
break;
}
if (XVar.Pack(!(XVar)(MVCFunctions.count(result))))
{
result = XVar.Clone(XVar.Array());
}
_result = XVar.Clone(CommonFunctions.getListOfSuggests((XVar)(fields.Value), (XVar)(fields.Key), (XVar)(whereClauses), (XVar)(numberOfSuggests - MVCFunctions.count(result)), (XVar)(searchOpt), (XVar)(searchFor)));
foreach (KeyValuePair <XVar, dynamic> _data in _result.GetEnumerator())
{
dynamic found = null;
found = new XVar(false);
foreach (KeyValuePair <XVar, dynamic> data in result.GetEnumerator())
{
if (data.Value["realValue"] == _data.Value["realValue"])
{
found = new XVar(true);
break;
}
}
if (XVar.Pack(!(XVar)(found)))
{
result.InitAndSetArrayItem(_data.Value, null);
}
}
}
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(new XVar("success", true, "result", result))));
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (pageType == Constants.PAGE_DASHBOARD)
{
dynamic sfData = XVar.Array();
dashSettings = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), new XVar(Constants.PAGE_DASHBOARD)));
dashSearchFields = XVar.Clone(dashSettings.getDashboardSearchFields());
sfData = XVar.Clone(dashSearchFields[searchField][0]);
searchField = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(sfData["field"])));
table = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(sfData["table"])));
if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table)))))
{
MVCFunctions.Echo(new XVar(0));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
GlobalVars.strTableName = XVar.Clone(CommonFunctions.GetTableByShort((XVar)(table)));
Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""),
"_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null);
foreach (KeyValuePair <XVar, dynamic> elem in dashSettings.getDashboardElements().GetEnumerator())
{
if (elem.Value["table"] == GlobalVars.strTableName)
{
pageType = new XVar(Constants.PAGE_LIST);
if (elem.Value["type"] == Constants.DASHBOARD_CHART)
{
pageType = new XVar(Constants.PAGE_CHART);
}
else
{
if (elem.Value["type"] == Constants.DASHBOARD_REPORT)
{
pageType = new XVar(Constants.PAGE_REPORT);
}
}
break;
}
}
}
pSetList = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType)));
if (searchField == XVar.Pack(""))
{
allSearchFields = XVar.Clone(pSetList.getGoogleLikeFields());
}
else
{
allSearchFields = XVar.Clone(pSetList.getAllSearchFields());
}
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), new XVar(Constants.PAGE_SEARCH)));
GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName)));
_connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName)));
detailKeys = XVar.Clone(XVar.Array());
if (XSession.Session[MVCFunctions.Concat(GlobalVars.strTableName, "_mastertable")] != "")
{
dynamic i = null, j = null, masterTablesInfoArr = XVar.Array(), masterWhere = null, mastervalue = null;
masterWhere = new XVar("");
masterTablesInfoArr = XVar.Clone(pSet.getMasterTablesArr((XVar)(GlobalVars.strTableName)));
i = new XVar(0);
for (; i < MVCFunctions.count(masterTablesInfoArr); i++)
{
if (XSession.Session[MVCFunctions.Concat(GlobalVars.strTableName, "_mastertable")] != masterTablesInfoArr[i]["mDataSourceTable"])
{
continue;
}
detailKeys = XVar.Clone(masterTablesInfoArr[i]["detailKeys"]);
j = new XVar(0);
for (; j < MVCFunctions.count(detailKeys); j++)
{
mastervalue = XVar.Clone(GlobalVars.cipherer.MakeDBValue((XVar)(detailKeys[j]), (XVar)(XSession.Session[MVCFunctions.Concat(GlobalVars.strTableName, "_masterkey", j + 1)]), new XVar(""), new XVar(true)));
if (mastervalue == "null")
{
masterWhere = MVCFunctions.Concat(masterWhere, RunnerPage._getFieldSQL((XVar)(detailKeys[j]), (XVar)(_connection), (XVar)(pSet)), " is NULL ");
}
else
{
masterWhere = MVCFunctions.Concat(masterWhere, RunnerPage._getFieldSQLDecrypt((XVar)(detailKeys[j]), (XVar)(_connection), (XVar)(pSet), (XVar)(GlobalVars.cipherer)), "=", mastervalue);
}
}
break;
}
whereClauses.InitAndSetArrayItem(masterWhere, null);
}
searchClauseObj = XVar.Clone(SearchClause.getSearchObject((XVar)(GlobalVars.strTableName), new XVar(""), (XVar)(GlobalVars.strTableName), (XVar)(GlobalVars.cipherer)));
searchClauseObj.processFiltersWhere((XVar)(_connection));
foreach (KeyValuePair <XVar, dynamic> filteredField in searchClauseObj.filteredFields.GetEnumerator())
{
whereClauses.InitAndSetArrayItem(filteredField.Value["where"], null);
}
result = XVar.Clone(CommonFunctions.getListOfSuggests((XVar)(allSearchFields), (XVar)(GlobalVars.strTableName), (XVar)(whereClauses), (XVar)(numberOfSuggests), (XVar)(searchOpt), (XVar)(searchFor), (XVar)(searchField), (XVar)(detailKeys)));
returnJSON = XVar.Clone(XVar.Array());
returnJSON.InitAndSetArrayItem(true, "success");
returnJSON.InitAndSetArrayItem(result, "result");
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON)));
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
catch (RunnerRedirectException ex)
{ return(Redirect(ex.Message)); }
}
public ActionResult detailspreview()
{
try
{
dynamic masterKeys = XVar.Array(), mastertable = null, mode = null, pageObject = null, query = null, recordsCounter = null, returnJSON = XVar.Array(), rowcount = null, sessionPrefix = null, var_params = XVar.Array(), whereClauses = XVar.Array();
ProjectSettings pSet;
XTempl xt;
dbo__ABCVotes_Variables.Apply();
MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT");
mode = XVar.Clone(MVCFunctions.postvalue(new XVar("mode")));
if (XVar.Pack(!(XVar)(CommonFunctions.isLogged())))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search")))))
{
return(MVCFunctions.GetBuferContentAndClearBufer());
}
GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName)));
xt = XVar.UnPackXTempl(new XTempl());
{
TLayout t_layout = null;
t_layout = new TLayout(new XVar("detailspreview"), new XVar("AvenueAvenue"), new XVar("MobileAvenue"));
t_layout.version = 2;
t_layout.blocks["bare"] = XVar.Array();
t_layout.containers["dcount"] = XVar.Array();
t_layout.containers["dcount"].Add(new XVar("name", "detailspreviewheader", "block", "", "substyle", 1));
t_layout.containers["dcount"].Add(new XVar("name", "detailspreviewdetailsfount", "block", "", "substyle", 1));
t_layout.containers["dcount"].Add(new XVar("name", "detailspreviewdispfirst", "block", "display_first", "substyle", 1));
t_layout.skins["dcount"] = "empty";
t_layout.blocks["bare"].Add("dcount");
t_layout.containers["detailspreviewgrid"] = XVar.Array();
t_layout.containers["detailspreviewgrid"].Add(new XVar("name", "detailspreviewfields", "block", "details_data", "substyle", 1));
t_layout.skins["detailspreviewgrid"] = "grid";
t_layout.blocks["bare"].Add("detailspreviewgrid");
GlobalVars.page_layouts["dbo__ABCVotes_detailspreview"] = t_layout;
t_layout.skinsparams = XVar.Array();
t_layout.skinsparams["empty"] = XVar.Array();
t_layout.skinsparams["empty"]["button"] = "button2";
t_layout.skinsparams["menu"] = XVar.Array();
t_layout.skinsparams["menu"]["button"] = "button1";
t_layout.skinsparams["hmenu"] = XVar.Array();
t_layout.skinsparams["hmenu"]["button"] = "button1";
t_layout.skinsparams["undermenu"] = XVar.Array();
t_layout.skinsparams["undermenu"]["button"] = "button1";
t_layout.skinsparams["fields"] = XVar.Array();
t_layout.skinsparams["fields"]["button"] = "button1";
t_layout.skinsparams["form"] = XVar.Array();
t_layout.skinsparams["form"]["button"] = "button1";
t_layout.skinsparams["1"] = XVar.Array();
t_layout.skinsparams["1"]["button"] = "button1";
t_layout.skinsparams["2"] = XVar.Array();
t_layout.skinsparams["2"]["button"] = "button1";
t_layout.skinsparams["3"] = XVar.Array();
t_layout.skinsparams["3"]["button"] = "button1";
}
recordsCounter = new XVar(0);
mastertable = XVar.Clone(MVCFunctions.postvalue(new XVar("mastertable")));
masterKeys = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("masterKeys")))));
sessionPrefix = new XVar("_detailsPreview");
if (mastertable != XVar.Pack(""))
{
dynamic i = null;
XSession.Session[MVCFunctions.Concat(sessionPrefix, "_mastertable")] = mastertable;
i = new XVar(1);
if ((XVar)(MVCFunctions.is_array((XVar)(masterKeys))) && (XVar)(0 < MVCFunctions.count(masterKeys)))
{
while (XVar.Pack(masterKeys.KeyExists(MVCFunctions.Concat("masterkey", i))))
{
XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey", i)] = masterKeys[MVCFunctions.Concat("masterkey", i)];
i++;
}
}
if (XVar.Pack(XSession.Session.KeyExists(MVCFunctions.Concat(sessionPrefix, "_masterkey", i))))
{
XSession.Session.Remove(MVCFunctions.Concat(sessionPrefix, "_masterkey", i));
}
}
else
{
mastertable = XVar.Clone(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_mastertable")]);
}
var_params = XVar.Clone(XVar.Array());
var_params.InitAndSetArrayItem(1, "id");
var_params.InitAndSetArrayItem(xt, "xt");
var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName");
var_params.InitAndSetArrayItem("detailspreview", "pageType");
GlobalVars.pageObject = XVar.Clone(new DetailsPreview((XVar)(var_params)));
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), new XVar(Constants.PAGE_LIST)));
whereClauses = XVar.Clone(XVar.Array());
if (mastertable == "dbo._ABCReports")
{
dynamic formattedValue = null;
formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")])));
if (formattedValue == "null")
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null);
}
else
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null);
}
}
if (mastertable == "ABC_Voting_Submitted")
{
dynamic formattedValue = null;
formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")])));
if (formattedValue == "null")
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null);
}
else
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null);
}
}
if (mastertable == "ABC_Voting_Recirculated")
{
dynamic formattedValue = null;
formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")])));
if (formattedValue == "null")
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null);
}
else
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null);
}
}
if (mastertable == "ABC_Voting_My_Voting")
{
dynamic formattedValue = null;
formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")])));
if (formattedValue == "null")
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null);
}
else
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null);
}
}
if (mastertable == "dbo.vwABCReportsVoteCount")
{
dynamic formattedValue = null;
formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")])));
if (formattedValue == "null")
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null);
}
else
{
whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null);
}
}
whereClauses.InitAndSetArrayItem(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(GlobalVars.strTableName)), null);
query = XVar.Clone(pSet.getSQLQuery());
GlobalVars.strSQL = XVar.Clone(query.buildSQL_default((XVar)(whereClauses)));
rowcount = XVar.Clone(GlobalVars.pageObject.connection.getFetchedRowsNumber((XVar)(GlobalVars.strSQL)));
GlobalVars.strSQL = MVCFunctions.Concat(GlobalVars.strSQL, GlobalVars.pageObject.getOrderByClause());
xt.assign(new XVar("row_count"), (XVar)(rowcount));
if (XVar.Pack(rowcount))
{
dynamic b = null, data = XVar.Array(), display_count = null, format = null, keylink = null, qResult = null, row = XVar.Array(), rowinfo = XVar.Array(), rowinfo2 = XVar.Array(), value = null, var_class = null, viewContainer = null;
xt.assign(new XVar("details_data"), new XVar(true));
display_count = new XVar(10);
if (mode == "inline")
{
display_count *= 2;
}
if (display_count + 2 < rowcount)
{
xt.assign(new XVar("display_first"), new XVar(true));
xt.assign(new XVar("display_count"), (XVar)(display_count));
}
else
{
display_count = XVar.Clone(rowcount);
}
rowinfo = XVar.Clone(XVar.Array());
viewContainer = XVar.Clone(new ViewControlsContainer((XVar)(pSet), new XVar(Constants.PAGE_LIST)));
viewContainer.isDetailsPreview = new XVar(true);
b = new XVar(true);
qResult = XVar.Clone(GlobalVars.pageObject.connection.query((XVar)(GlobalVars.strSQL)));
data = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc())));
while ((XVar)(data) && (XVar)(recordsCounter < display_count))
{
recordsCounter++;
row = XVar.Clone(XVar.Array());
keylink = new XVar("");
keylink = MVCFunctions.Concat(keylink, "&key1=", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.RawUrlEncode((XVar)(data["id"])))));
keylink = MVCFunctions.Concat(keylink, "&key2=", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.RawUrlEncode((XVar)(data["record"])))));
viewContainer.recId = XVar.Clone(recordsCounter);
value = XVar.Clone(viewContainer.showDBValue(new XVar("committee_member"), (XVar)(data), (XVar)(keylink)));
row.InitAndSetArrayItem(value, "committee_member_value");
format = XVar.Clone(pSet.getViewFormat(new XVar("committee_member")));
var_class = new XVar("rnr-field-text");
if (format == Constants.FORMAT_FILE)
{
var_class = new XVar(" rnr-field-file");
}
if (format == Constants.FORMAT_AUDIO)
{
var_class = new XVar(" rnr-field-audio");
}
if (format == Constants.FORMAT_CHECKBOX)
{
var_class = new XVar(" rnr-field-checkbox");
}
if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("committee_member"))))))
{
var_class = new XVar(" rnr-field-number");
}
row.InitAndSetArrayItem(var_class, "committee_member_class");
viewContainer.recId = XVar.Clone(recordsCounter);
value = XVar.Clone(viewContainer.showDBValue(new XVar("date_voted"), (XVar)(data), (XVar)(keylink)));
row.InitAndSetArrayItem(value, "date_voted_value");
format = XVar.Clone(pSet.getViewFormat(new XVar("date_voted")));
var_class = new XVar("rnr-field-text");
if (format == Constants.FORMAT_FILE)
{
var_class = new XVar(" rnr-field-file");
}
if (format == Constants.FORMAT_AUDIO)
{
var_class = new XVar(" rnr-field-audio");
}
if (format == Constants.FORMAT_CHECKBOX)
{
var_class = new XVar(" rnr-field-checkbox");
}
if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("date_voted"))))))
{
var_class = new XVar(" rnr-field-number");
}
row.InitAndSetArrayItem(var_class, "date_voted_class");
viewContainer.recId = XVar.Clone(recordsCounter);
value = XVar.Clone(viewContainer.showDBValue(new XVar("vote"), (XVar)(data), (XVar)(keylink)));
row.InitAndSetArrayItem(value, "vote_value");
format = XVar.Clone(pSet.getViewFormat(new XVar("vote")));
var_class = new XVar("rnr-field-text");
if (format == Constants.FORMAT_FILE)
{
var_class = new XVar(" rnr-field-file");
}
if (format == Constants.FORMAT_AUDIO)
{
var_class = new XVar(" rnr-field-audio");
}
if (format == Constants.FORMAT_CHECKBOX)
{
var_class = new XVar(" rnr-field-checkbox");
}
if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("vote"))))))
{
var_class = new XVar(" rnr-field-number");
}
row.InitAndSetArrayItem(var_class, "vote_class");
viewContainer.recId = XVar.Clone(recordsCounter);
value = XVar.Clone(viewContainer.showDBValue(new XVar("comment"), (XVar)(data), (XVar)(keylink)));
row.InitAndSetArrayItem(value, "comment_value");
format = XVar.Clone(pSet.getViewFormat(new XVar("comment")));
var_class = new XVar("rnr-field-text");
if (format == Constants.FORMAT_FILE)
{
var_class = new XVar(" rnr-field-file");
}
if (format == Constants.FORMAT_AUDIO)
{
var_class = new XVar(" rnr-field-audio");
}
if (format == Constants.FORMAT_CHECKBOX)
{
var_class = new XVar(" rnr-field-checkbox");
}
if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("comment"))))))
{
var_class = new XVar(" rnr-field-number");
}
row.InitAndSetArrayItem(var_class, "comment_class");
rowinfo.InitAndSetArrayItem(row, null);
if (XVar.Pack(b))
{
rowinfo2.InitAndSetArrayItem(row, null);
b = new XVar(false);
}
data = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc())));
}
xt.assign_loopsection(new XVar("details_row"), (XVar)(rowinfo));
xt.assign_loopsection(new XVar("details_row_header"), (XVar)(rowinfo2));
}
returnJSON = XVar.Clone(new XVar("success", true));
xt.load_template((XVar)(MVCFunctions.GetTemplateName(new XVar("dbo__ABCVotes"), new XVar("detailspreview"))));
returnJSON.InitAndSetArrayItem(xt.fetch_loaded(), "body");
if (mode != "inline")
{
dynamic layout = null;
returnJSON.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("counter")), "counter");
layout = XVar.Clone(CommonFunctions.GetPageLayout((XVar)(MVCFunctions.GoodFieldName((XVar)(GlobalVars.strTableName))), new XVar("detailspreview")));
if (XVar.Pack(layout))
{
foreach (KeyValuePair <XVar, dynamic> css in layout.getCSSFiles((XVar)(CommonFunctions.isRTL()), (XVar)((XVar)(CommonFunctions.mobileDeviceDetected()) && (XVar)(layout.version != Constants.BOOTSTRAP_LAYOUT))).GetEnumerator())
{
returnJSON.InitAndSetArrayItem(css.Value, "CSSFiles", null);
}
}
}
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON)));
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
catch (RunnerRedirectException ex)
{ return(Redirect(ex.Message)); }
}
public virtual XVar LogAdd(dynamic _param_str_table, dynamic _param_values, dynamic _param_keys)
{
#region pass-by-value parameters
dynamic str_table = XVar.Clone(_param_str_table);
dynamic values = XVar.Clone(_param_values);
dynamic keys = XVar.Clone(_param_keys);
#endregion
dynamic arr = null, retval = null, table = null;
ProjectSettings pSet;
retval = new XVar(true);
table = XVar.Clone(str_table);
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(str_table)));
arr = XVar.Clone(XVar.Array());
if (XVar.Pack(GlobalVars.globalEvents.exists(new XVar("OnAuditLog"))))
{
retval = XVar.Clone(GlobalVars.globalEvents.OnAuditLog((XVar)(this.strAdd), (XVar)(this.var_params), (XVar)(table), (XVar)(keys), (XVar)(values), (XVar)(arr)));
}
if (XVar.Pack(retval))
{
dynamic str = null, strFields = null;
str = new XVar("");
if (0 < MVCFunctions.count(keys))
{
str = MVCFunctions.Concat(str, this.strKeysHeader, "\r\n");
foreach (KeyValuePair <XVar, dynamic> val in keys.GetEnumerator())
{
str = MVCFunctions.Concat(str, val.Key, " : ", val.Value, "\r\n");
}
}
strFields = new XVar("");
if (XVar.Pack(logValueEnable((XVar)(str_table))))
{
foreach (KeyValuePair <XVar, dynamic> val in values.GetEnumerator())
{
if ((XVar)(val.Value != XVar.Pack("")) && (XVar)(!(XVar)(keys.KeyExists(val.Key))))
{
dynamic v = null;
strFields = MVCFunctions.Concat(strFields, val.Key, " [new]: ");
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(pSet.getFieldType((XVar)(val.Key))))))
{
v = new XVar("<binary value>");
}
else
{
v = XVar.Clone(MVCFunctions.str_replace((XVar)(new XVar(0, "\r\n", 1, "\n", 2, "\t")), new XVar(" "), (XVar)(val.Value)));
if (this.maxFieldLength < MVCFunctions.strlen((XVar)(v)))
{
v = XVar.Clone(MVCFunctions.runner_substr((XVar)(val.Value), new XVar(0), (XVar)(this.maxFieldLength)));
}
}
strFields = MVCFunctions.Concat(strFields, v, "\r\n");
}
}
}
if (strFields != XVar.Pack(""))
{
str = MVCFunctions.Concat(str, this.strFieldsHeader, "\r\n", strFields);
}
insert((XVar)(MVCFunctions.now()), (XVar)(this.var_params[0]), (XVar)(this.var_params[1]), (XVar)(str_table), (XVar)(this.strAdd), (XVar)(str));
}
return(retval);
}
public virtual XVar LogDelete(dynamic _param_str_table, dynamic _param_values, dynamic _param_keys)
{
#region pass-by-value parameters
dynamic str_table = XVar.Clone(_param_str_table);
dynamic values = XVar.Clone(_param_values);
dynamic keys = XVar.Clone(_param_keys);
#endregion
dynamic arr = null, retval = null, table = null;
ProjectSettings pSet;
retval = new XVar(true);
table = XVar.Clone(str_table);
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(str_table)));
arr = XVar.Clone(XVar.Array());
if (XVar.Pack(GlobalVars.globalEvents.exists(new XVar("OnAuditLog"))))
{
retval = XVar.Clone(GlobalVars.globalEvents.OnAuditLog((XVar)(this.strDelete), (XVar)(this.var_params), (XVar)(table), (XVar)(keys), (XVar)(values), (XVar)(arr)));
}
if (XVar.Pack(retval))
{
dynamic key = null, str = null, str_add = null;
if (0 < MVCFunctions.count(keys))
{
key = new XVar("");
foreach (KeyValuePair <XVar, dynamic> val in keys.GetEnumerator())
{
if (key != XVar.Pack(""))
{
key = MVCFunctions.Concat(key, ",");
}
key = MVCFunctions.Concat(key, val.Value);
}
}
str = XVar.Clone(MVCFunctions.Concat(CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(MVCFunctions.now()))), new XVar("MMM dd,yyyy")), MVCFunctions.chr(new XVar(9)), CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(MVCFunctions.now()))), new XVar("HH:mm:ss")), MVCFunctions.chr(new XVar(9)), this.var_params[0], MVCFunctions.chr(new XVar(9)), this.var_params[1], MVCFunctions.chr(new XVar(9)), table, MVCFunctions.chr(new XVar(9)), this.strDelete, MVCFunctions.chr(new XVar(9)), key));
str_add = new XVar("");
if (XVar.Pack(logValueEnable((XVar)(str_table))))
{
foreach (KeyValuePair <XVar, dynamic> val in values.GetEnumerator())
{
dynamic v = null;
v = new XVar("");
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(pSet.getFieldType((XVar)(val.Key))))))
{
v = new XVar("<binary value>");
}
else
{
v = XVar.Clone(MVCFunctions.str_replace((XVar)(new XVar(0, "\r\n", 1, "\n", 2, "\t")), new XVar(" "), (XVar)(val.Value)));
if (this.maxFieldLength < MVCFunctions.strlen((XVar)(v)))
{
v = XVar.Clone(MVCFunctions.runner_substr((XVar)(v), new XVar(0), (XVar)(this.maxFieldLength)));
}
}
str_add = MVCFunctions.Concat(str_add, str, MVCFunctions.chr(new XVar(9)), val.Key, MVCFunctions.chr(new XVar(9)), v, "\r\n");
}
}
else
{
str_add = XVar.Clone(MVCFunctions.Concat(str, "\r\n"));
}
writeToLogFile((XVar)(str_add));
}
return(retval);
}
public virtual XVar getOrderFields()
{
dynamic columns = XVar.Array(), ret = XVar.Array(), saved = XVar.Array();
ProjectSettings pSet;
if (!XVar.Equals(XVar.Pack(this._cachedFields), XVar.Pack(null)))
{
return(this._cachedFields);
}
ret = XVar.Clone(XVar.Array());
columns = XVar.Clone(XVar.Array());
pSet = XVar.UnPackProjectSettings(this.pSet);
saved = XVar.Clone(XSession.Session[MVCFunctions.Concat(this.sessionPrefix, "_orderby")]);
if (0 != MVCFunctions.strlen((XVar)(saved["orderby"])))
{
dynamic fields = XVar.Array();
fields = XVar.Clone(MVCFunctions.explode(new XVar(";"), (XVar)(saved["orderby"])));
foreach (KeyValuePair <XVar, dynamic> f in fields.GetEnumerator())
{
dynamic dir = null, fieldName = null, goodField = null, index = null;
dir = XVar.Clone(MVCFunctions.substr((XVar)(f.Value), new XVar(0), new XVar(1)));
if ((XVar)(dir != "a") && (XVar)(dir != "d"))
{
continue;
}
goodField = XVar.Clone(MVCFunctions.substr((XVar)(f.Value), new XVar(1)));
fieldName = XVar.Clone(pSet.getFieldByGoodFieldName((XVar)(goodField)));
index = XVar.Clone(pSet.getFieldIndex((XVar)(fieldName)) + 1);
if (XVar.Pack(!(XVar)(index)))
{
continue;
}
ret.InitAndSetArrayItem(new XVar("column", fieldName, "index", index, "expr", RunnerPage._getFieldSQLDecrypt((XVar)(fieldName), (XVar)(this.connection), (XVar)(this.pSet), (XVar)(this.cipherer)), "dir", (XVar.Pack(dir == "a") ? XVar.Pack("ASC") : XVar.Pack("DESC"))), null);
columns.InitAndSetArrayItem(true, fieldName);
}
}
else
{
if (0 != MVCFunctions.strlen((XVar)(saved["sortby"])))
{
dynamic sortbySettings = XVar.Array(), var_option = XVar.Array();
sortbySettings = getSortBySettings();
var_option = XVar.Clone(sortbySettings[saved["sortby"] - 1]);
if (XVar.Pack(var_option))
{
foreach (KeyValuePair <XVar, dynamic> f in var_option["fields"].GetEnumerator())
{
ret.InitAndSetArrayItem(new XVar("column", f.Value["field"], "index", pSet.getFieldIndex((XVar)(f.Value["field"])) + 1, "expr", RunnerPage._getFieldSQLDecrypt((XVar)(f.Value["field"]), (XVar)(this.connection), (XVar)(this.pSet), (XVar)(this.cipherer)), "dir", (XVar.Pack(f.Value["desc"]) ? XVar.Pack("DESC") : XVar.Pack("ASC"))), null);
columns.InitAndSetArrayItem(true, f.Value);
}
}
}
else
{
dynamic orderInfo = XVar.Array();
orderInfo = XVar.Clone(pSet.getOrderIndexes());
foreach (KeyValuePair <XVar, dynamic> o in orderInfo.GetEnumerator())
{
dynamic field = null;
field = XVar.Clone(pSet.GetFieldByIndex((XVar)(o.Value[0])));
ret.InitAndSetArrayItem(new XVar("column", field, "index", o.Value[0], "expr", o.Value[2], "dir", o.Value[1]), null);
columns.InitAndSetArrayItem(true, field);
}
}
}
foreach (KeyValuePair <XVar, dynamic> k in pSet.getTableKeys().GetEnumerator())
{
if (XVar.Pack(columns.KeyExists(k.Value)))
{
continue;
}
ret.InitAndSetArrayItem(new XVar("column", k.Value, "index", pSet.getFieldIndex((XVar)(k.Value)) + 1, "expr", RunnerPage._getFieldSQLDecrypt((XVar)(k.Value), (XVar)(this.connection), (XVar)(this.pSet), (XVar)(this.cipherer)), "dir", "ASC", "hidden", true), null);
}
this._cachedFields = XVar.Clone(ret);
return(ret);
}
public virtual XVar LogEdit(dynamic _param_str_table, dynamic _param_newvalues, dynamic _param_oldvalues, dynamic _param_keys)
{
#region pass-by-value parameters
dynamic str_table = XVar.Clone(_param_str_table);
dynamic newvalues = XVar.Clone(_param_newvalues);
dynamic oldvalues = XVar.Clone(_param_oldvalues);
dynamic keys = XVar.Clone(_param_keys);
#endregion
dynamic retval = null, table = null;
ProjectSettings pSet;
retval = new XVar(true);
table = XVar.Clone(str_table);
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(str_table)));
if (XVar.Pack(GlobalVars.globalEvents.exists(new XVar("OnAuditLog"))))
{
retval = XVar.Clone(GlobalVars.globalEvents.OnAuditLog((XVar)(this.strEdit), (XVar)(this.var_params), (XVar)(table), (XVar)(keys), (XVar)(newvalues), (XVar)(oldvalues)));
}
if (XVar.Pack(retval))
{
dynamic str = null, strFields = null;
str = new XVar("");
if (0 < MVCFunctions.count(keys))
{
str = MVCFunctions.Concat(str, this.strKeysHeader, "\r\n");
foreach (KeyValuePair <XVar, dynamic> val in newvalues.GetEnumerator())
{
if (XVar.Pack(keys.KeyExists(val.Key)))
{
if (val.Value != oldvalues[val.Key])
{
str = MVCFunctions.Concat(str, val.Key, " [old]: ", oldvalues[val.Key], "\r\n");
str = MVCFunctions.Concat(str, val.Key, " [new]: ", val.Value, "\r\n");
}
else
{
str = MVCFunctions.Concat(str, val.Key, " : ", val.Value, "\r\n");
}
}
}
}
strFields = new XVar("");
if (XVar.Pack(logValueEnable((XVar)(str_table))))
{
dynamic v = null;
v = new XVar("");
foreach (KeyValuePair <XVar, dynamic> val in newvalues.GetEnumerator())
{
dynamic newvalue = null, oldvalue = null, var_type = null;
var_type = XVar.Clone(pSet.getFieldType((XVar)(val.Key)));
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(var_type))))
{
continue;
}
if (XVar.Pack(CommonFunctions.IsDateFieldType((XVar)(var_type))))
{
newvalue = XVar.Clone(CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(newvalues[val.Key]))), new XVar("yyyy-MM-dd HH:mm:ss")));
oldvalue = XVar.Clone(CommonFunctions.format_datetime_custom((XVar)(CommonFunctions.db2time((XVar)(oldvalues[val.Key]))), new XVar("yyyy-MM-dd HH:mm:ss")));
}
else
{
newvalue = XVar.Clone(newvalues[val.Key]);
oldvalue = XVar.Clone(oldvalues[val.Key]);
}
if ((XVar)(newvalue != oldvalue) && (XVar)(!(XVar)(keys.KeyExists(val.Key))))
{
strFields = MVCFunctions.Concat(strFields, val.Key, " [old]: ");
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(var_type))))
{
v = new XVar("<binary value>");
}
else
{
v = XVar.Clone(MVCFunctions.str_replace((XVar)(new XVar(0, "\r\n", 1, "\n", 2, "\t")), new XVar(" "), (XVar)(oldvalue)));
if (this.maxFieldLength < MVCFunctions.strlen((XVar)(v)))
{
v = XVar.Clone(MVCFunctions.runner_substr((XVar)(v), new XVar(0), (XVar)(this.maxFieldLength)));
}
}
strFields = MVCFunctions.Concat(strFields, v, "\r\n");
strFields = MVCFunctions.Concat(strFields, val.Key, " [new]: ");
if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(var_type))))
{
v = new XVar("<binary value>");
}
else
{
v = XVar.Clone(MVCFunctions.str_replace((XVar)(new XVar(0, "\r\n", 1, "\n", 2, "\t")), new XVar(" "), (XVar)(newvalue)));
if (this.maxFieldLength < MVCFunctions.strlen((XVar)(v)))
{
v = XVar.Clone(MVCFunctions.runner_substr((XVar)(v), new XVar(0), (XVar)(this.maxFieldLength)));
}
}
strFields = MVCFunctions.Concat(strFields, v, "\r\n");
}
}
v = new XVar("");
}
if (strFields != XVar.Pack(""))
{
str = MVCFunctions.Concat(str, this.strFieldsHeader, "\r\n", strFields);
}
insert((XVar)(MVCFunctions.now()), (XVar)(this.var_params[0]), (XVar)(this.var_params[1]), (XVar)(str_table), (XVar)(this.strEdit), (XVar)(str));
}
return(retval);
}
public XVar fulltext()
{
try
{
dynamic _connection = null, cViewControl = null, container = null, data = XVar.Array(), field = null, fieldValue = null, htmlEncodedValue = null, keys = XVar.Array(), keysArr = XVar.Array(), lookup = null, lookupInRegisterPage = null, mainField = null, mainTable = null, mode = null, pageName = null, pageType = null, qResult = null, returnJSON = null, searchClauseObj = null, sessionPrefix = null, sql = null, table = null, where = null;
ProjectSettings pSet;
mode = XVar.Clone(MVCFunctions.postvalue(new XVar("mode")));
table = XVar.Clone(MVCFunctions.postvalue(new XVar("table")));
field = XVar.Clone(MVCFunctions.postvalue(new XVar("field")));
pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pagetype")));
pageName = XVar.Clone(MVCFunctions.postvalue(new XVar("page")));
mainTable = XVar.Clone(MVCFunctions.postvalue(new XVar("maintable")));
mainField = XVar.Clone(MVCFunctions.postvalue(new XVar("mainfield")));
lookup = new XVar(false);
if ((XVar)(mainTable) && (XVar)(mainField))
{
lookup = new XVar(true);
}
if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table)))))
{
MVCFunctions.Echo(new XVar(0));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""),
"_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null);
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(CommonFunctions.GetTableByShort((XVar)(table))), (XVar)(pageType), (XVar)(pageName)));
GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(CommonFunctions.GetTableByShort((XVar)(table))), (XVar)(pSet)));
_connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName)));
lookupInRegisterPage = new XVar(false);
if (XVar.Pack(!(XVar)(MVCFunctions.in_array((XVar)(field), (XVar)(pSet.getListFields())))))
{
lookupInRegisterPage = new XVar(false);
}
if ((XVar)((XVar)(!(XVar)(CommonFunctions.isLogged())) || (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) && (XVar)(!(XVar)(lookupInRegisterPage)))
{
returnJSON = XVar.Clone(new XVar("success", false, "error", ""));
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON)));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(!(XVar)(pSet.checkFieldPermissions((XVar)(field)))))
{
returnJSON = XVar.Clone(new XVar("success", false, "error", "Error: You have not permission for read this text"));
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON)));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(!(XVar)(GlobalVars.gQuery.HasGroupBy())))
{
GlobalVars.gQuery.RemoveAllFieldsExcept((XVar)(pSet.getFieldIndex((XVar)(field))));
}
keysArr = XVar.Clone(pSet.getTableKeys());
keys = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> k in keysArr.GetEnumerator())
{
keys.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("key", k.Key + 1))), k.Value);
}
where = XVar.Clone(CommonFunctions.KeyWhere((XVar)(keys)));
if (pSet.getAdvancedSecurityType() == Constants.ADVSECURITY_VIEW_OWN)
{
where = XVar.Clone(CommonFunctions.whereAdd((XVar)(where), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(GlobalVars.strTableName)))));
}
sql = XVar.Clone(GlobalVars.gQuery.gSQLWhere((XVar)(where)));
qResult = XVar.Clone(_connection.query((XVar)(sql)));
if ((XVar)(!(XVar)(qResult)) || (XVar)(!(XVar)(data = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc()))))))
{
returnJSON = XVar.Clone(new XVar("success", false, "error", "Error: Wrong SQL query"));
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON)));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
fieldValue = XVar.Clone(data[field]);
sessionPrefix = XVar.Clone(pSet.getOriginalTableName());
if (mode == Constants.LIST_DASHBOARD)
{
sessionPrefix = XVar.Clone(MVCFunctions.Concat("Dashboard_", pSet.getOriginalTableName()));
}
if (XVar.Pack(lookup))
{
sessionPrefix = XVar.Clone(MVCFunctions.Concat(pSet.getOriginalTableName(), "_lookup_", mainTable, "_", mainField));
}
searchClauseObj = XVar.Clone(SearchClause.UnserializeObject((XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_advsearch")])));
container = XVar.Clone(new ViewControlsContainer((XVar)(pSet), new XVar(Constants.PAGE_LIST), new XVar(null)));
cViewControl = XVar.Clone(container.getControl((XVar)(field)));
if ((XVar)(cViewControl.localControlsContainer) && (XVar)(!(XVar)(cViewControl.linkAndDisplaySame)))
{
cViewControl.localControlsContainer.fullText = new XVar(true);
}
else
{
cViewControl.container.fullText = new XVar(true);
}
if (XVar.Pack(searchClauseObj))
{
dynamic useViewControl = null;
if ((XVar)(searchClauseObj.bIsUsedSrch) || (XVar)(useViewControl))
{
cViewControl.searchClauseObj = XVar.Clone(searchClauseObj);
cViewControl.searchHighlight = new XVar(true);
}
}
htmlEncodedValue = XVar.Clone(cViewControl.showDBValue((XVar)(data), new XVar("")));
returnJSON = XVar.Clone(new XVar("success", true, "textCont", htmlEncodedValue));
MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON)));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
catch (RunnerRedirectException ex)
{ return(Redirect(ex.Message)); }
}
