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)); } }