public virtual XVar prepareWordOrExcelTemplate(dynamic _param_contents) { #region pass-by-value parameters dynamic contents = XVar.Clone(_param_contents); #endregion dynamic pos1 = null; pos1 = new XVar(0); while (!XVar.Equals(XVar.Pack(pos1), XVar.Pack(false))) { pos1 = XVar.Clone(MVCFunctions.stripos((XVar)(contents), new XVar("<link "), (XVar)(pos1))); if (!XVar.Equals(XVar.Pack(pos1), XVar.Pack(false))) { dynamic pos2 = null; pos2 = XVar.Clone(MVCFunctions.strpos((XVar)(contents), new XVar(">"), (XVar)(pos1))); if (!(XVar)(pos2) == false) { contents = XVar.Clone(MVCFunctions.Concat(MVCFunctions.substr((XVar)(contents), new XVar(0), (XVar)(pos1)), MVCFunctions.substr((XVar)(contents), (XVar)(pos2 + 1)))); } } } contents = XVar.Clone(MVCFunctions.str_ireplace((XVar)(MVCFunctions.Concat("<img src=\"/", MVCFunctions.GetRootPathForResources(new XVar("images/spacer.gif")), "\">")), new XVar(""), (XVar)(contents))); contents = XVar.Clone(MVCFunctions.str_ireplace((XVar)(MVCFunctions.Concat("<img src=\"/", MVCFunctions.GetRootPathForResources(new XVar("images/spacer.gif")), "\"/>")), new XVar(""), (XVar)(contents))); contents = XVar.Clone(MVCFunctions.str_ireplace(new XVar("<img src=\"@webRootPath/images/spacer.gif\" />"), new XVar(""), (XVar)(contents))); return(contents); }
protected virtual XVar getFirstSearchWordData(dynamic _param_searchWords, dynamic _param_notContentPositions, dynamic _param_value) { #region pass-by-value parameters dynamic searchWords = XVar.Clone(_param_searchWords); dynamic notContentPositions = XVar.Clone(_param_notContentPositions); dynamic value = XVar.Clone(_param_value); #endregion dynamic firstPos = null, firstSearchWord = null, hasTags = null, tagPattern = null; hasTags = new XVar(false); firstSearchWord = new XVar(""); firstPos = XVar.Clone(MVCFunctions.strlen((XVar)(value))); tagPattern = XVar.Clone(MVCFunctions.Concat("/(<[^=>]+\\s*(?:(?:[^=>]+=\\s*'[^']+'\\s*)|", "(?:[^=>]+=\\s*\"[^\"]+\"\\s*)", ")*>)/iU")); foreach (KeyValuePair <XVar, dynamic> searchWord in searchWords.GetEnumerator()) { dynamic matches = null, pos = null; pos = XVar.Clone(MVCFunctions.strpos((XVar)(value), (XVar)(searchWord.Value))); hasTags = new XVar(true); if (XVar.Pack(!(XVar)(MVCFunctions.preg_match((XVar)(tagPattern), (XVar)(searchWord.Value), (XVar)(matches))))) { while ((XVar)(notInContent((XVar)(pos), (XVar)(notContentPositions))) && (XVar)(!XVar.Equals(XVar.Pack(pos), XVar.Pack(false)))) { pos = XVar.Clone(MVCFunctions.strpos((XVar)(value), (XVar)(searchWord.Value), (XVar)(pos + 1))); } hasTags = new XVar(false); } if ((XVar)(!XVar.Equals(XVar.Pack(pos), XVar.Pack(false))) && (XVar)(pos < firstPos)) { firstPos = XVar.Clone(pos); firstSearchWord = XVar.Clone(searchWord.Value); } } return(new XVar("position", (XVar.Pack(firstPos != MVCFunctions.strlen((XVar)(value))) ? XVar.Pack(firstPos) : XVar.Pack(false)), "searchWord", firstSearchWord, "hasTags", hasTags)); }
protected override XVar getPageFields() { if (XVar.Equals(XVar.Pack(this.updSelectedFields), XVar.Pack(null))) { dynamic denyDuplicateFields = XVar.Array(), updateFields = XVar.Array(); this.updSelectedFields = XVar.Clone(MVCFunctions.array_diff((XVar)(this.pSet.getUpdateSelectedFields()), (XVar)(this.pSet.getTableKeys()))); denyDuplicateFields = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> f in this.updSelectedFields.GetEnumerator()) { if (XVar.Pack(!(XVar)(this.pSet.allowDuplicateValues((XVar)(f.Value))))) { denyDuplicateFields.InitAndSetArrayItem(f.Value, null); } } this.updSelectedFields = XVar.Clone(MVCFunctions.array_diff((XVar)(this.updSelectedFields), (XVar)(denyDuplicateFields))); updateFields = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> f in this.updSelectedFields.GetEnumerator()) { dynamic editFormat = null; editFormat = XVar.Clone(this.pSet.getEditFormat((XVar)(f.Value))); if (editFormat != Constants.EDIT_FORMAT_FILE) { updateFields.InitAndSetArrayItem(f.Value, null); } } this.updSelectedFields = XVar.Clone(updateFields); } return(this.updSelectedFields); }
public override XVar SecuritySQL(dynamic _param_strAction, dynamic _param_table = null) { #region default values if (_param_table as Object == null) { _param_table = new XVar(""); } #endregion #region pass-by-value parameters dynamic strAction = XVar.Clone(_param_strAction); dynamic table = XVar.Clone(_param_table); #endregion dynamic strPerm = null; if (XVar.Pack(!(XVar)(MVCFunctions.strlen((XVar)(table))))) { table = XVar.Clone(GlobalVars.strTableName); } strPerm = XVar.Clone(CommonFunctions.GetUserPermissions((XVar)(table))); if (XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(strPerm), new XVar("S"))), XVar.Pack(false))) { strPerm = MVCFunctions.Concat(strPerm, "S"); } return(CommonFunctions.SecuritySQL((XVar)(strAction), (XVar)(table), (XVar)(strPerm))); }
public virtual XVar MakeDBValue(dynamic _param_field, dynamic _param_value, dynamic _param_controltype = null, dynamic _param_phpEncryptionOnly = null) { #region default values if (_param_controltype as Object == null) { _param_controltype = new XVar(""); } if (_param_phpEncryptionOnly as Object == null) { _param_phpEncryptionOnly = new XVar(false); } #endregion #region pass-by-value parameters dynamic field = XVar.Clone(_param_field); dynamic value = XVar.Clone(_param_value); dynamic controltype = XVar.Clone(_param_controltype); dynamic phpEncryptionOnly = XVar.Clone(_param_phpEncryptionOnly); #endregion dynamic ret = null; ret = XVar.Clone(CommonFunctions.prepare_for_db((XVar)(field), (XVar)(value), (XVar)(controltype), new XVar(""), (XVar)(this.strTableName))); if (XVar.Equals(XVar.Pack(ret), XVar.Pack(false))) { return(ret); } ret = XVar.Clone(CommonFunctions.add_db_quotes((XVar)(field), (XVar)(EncryptField((XVar)(field), (XVar)(ret))), (XVar)(this.strTableName))); if (XVar.Pack(phpEncryptionOnly)) { return(ret); } return(EncryptValueByDB((XVar)(field), (XVar)(ret))); }
public override XVar SQLWhere(dynamic _param_SearchFor, dynamic _param_strSearchOption, dynamic _param_SearchFor2, dynamic _param_etype, dynamic _param_isSuggest) { #region pass-by-value parameters dynamic SearchFor = XVar.Clone(_param_SearchFor); dynamic strSearchOption = XVar.Clone(_param_strSearchOption); dynamic SearchFor2 = XVar.Clone(_param_SearchFor2); dynamic etype = XVar.Clone(_param_etype); dynamic isSuggest = XVar.Clone(_param_isSuggest); #endregion dynamic baseResult = null, gstrField = null; baseResult = XVar.Clone(baseSQLWhere((XVar)(strSearchOption))); if (XVar.Equals(XVar.Pack(baseResult), XVar.Pack(false))) { return(""); } if (baseResult != XVar.Pack("")) { return(baseResult); } if (XVar.Pack(CommonFunctions.IsCharType((XVar)(this.var_type)))) { gstrField = XVar.Clone(getFieldSQLDecrypt()); if ((XVar)((XVar)(!(XVar)(this.btexttype)) && (XVar)(!(XVar)(this.pageObject.cipherer.isFieldPHPEncrypted((XVar)(this.field))))) && (XVar)(this.pageObject.pSetEdit.getNCSearch())) { gstrField = XVar.Clone(this.connection.upper((XVar)(gstrField))); } } else { if ((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with")) { gstrField = XVar.Clone(this.connection.field2char((XVar)(getFieldSQLDecrypt()), (XVar)(this.var_type))); } else { gstrField = XVar.Clone(getFieldSQLDecrypt()); } } if ((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with")) { SearchFor = XVar.Clone(this.connection.escapeLIKEpattern((XVar)(SearchFor))); } if (strSearchOption == "Contains") { SearchFor = XVar.Clone(MVCFunctions.Concat("%", SearchFor, "%")); } else { if (strSearchOption == "Starts with") { SearchFor = XVar.Clone(MVCFunctions.Concat(SearchFor, "%")); } } if ((XVar)((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with")) || (XVar)(strSearchOption == "Equals")) { return(buildWhere((XVar)(gstrField), (XVar)(SearchFor), (XVar)(strSearchOption == "Equals"))); } return(""); }
public virtual XVar updateTablePermissions(dynamic _param_table, dynamic _param_group, dynamic _param_mask) { #region pass-by-value parameters dynamic table = XVar.Clone(_param_table); dynamic group = XVar.Clone(_param_group); dynamic mask = XVar.Clone(_param_mask); #endregion dynamic accessMaskWFieldName = null, data = XVar.Array(), groupWhere = null, groupisWFieldName = null, rightWTableName = null, sql = null, tableNameWFieldName = null; rightWTableName = XVar.Clone(this.connection.addTableWrappers(new XVar("ugrights"))); accessMaskWFieldName = XVar.Clone(this.connection.addFieldWrappers(new XVar(""))); groupisWFieldName = XVar.Clone(this.connection.addFieldWrappers(new XVar(""))); tableNameWFieldName = XVar.Clone(this.connection.addFieldWrappers(new XVar(""))); groupWhere = XVar.Clone(MVCFunctions.Concat(groupisWFieldName, "=", group, " and ", tableNameWFieldName, "=", this.connection.prepareString((XVar)(table)))); sql = XVar.Clone(MVCFunctions.Concat("select ", accessMaskWFieldName, " from ", rightWTableName, "where", groupWhere)); data = XVar.Clone(this.connection.query((XVar)(sql)).fetchNumeric()); if (XVar.Pack(data)) { dynamic correctedMask = null, pageMask = null, savedMask = null; savedMask = XVar.Clone(data[0]); pageMask = XVar.Clone(this.pageMasks[table]); correctedMask = new XVar(""); foreach (KeyValuePair <XVar, dynamic> t in this.permissionNames.GetEnumerator()) { if (!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(pageMask), (XVar)(t.Key))), XVar.Pack(false))) { if (!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(mask), (XVar)(t.Key))), XVar.Pack(false))) { correctedMask = MVCFunctions.Concat(correctedMask, t.Key); } } else { if (!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(savedMask), (XVar)(t.Key))), XVar.Pack(false))) { correctedMask = MVCFunctions.Concat(correctedMask, t.Key); } } } mask = XVar.Clone(correctedMask); if (XVar.Pack(MVCFunctions.strlen((XVar)(mask)))) { sql = XVar.Clone(MVCFunctions.Concat("update ", rightWTableName, " set ", accessMaskWFieldName, "='", mask, "',", tableNameWFieldName, "=", this.connection.prepareString((XVar)(table)), " where ", groupWhere)); } else { sql = XVar.Clone(MVCFunctions.Concat("delete from ", rightWTableName, " where ", groupWhere)); } } else { if (XVar.Pack(!(XVar)(MVCFunctions.strlen((XVar)(mask))))) { return(null); } sql = XVar.Clone(MVCFunctions.Concat("insert into ", rightWTableName, " (", groupisWFieldName, ", ", tableNameWFieldName, ", ", accessMaskWFieldName, ")", " values (", group, ", ", this.connection.prepareString((XVar)(table)), ", '", mask, "')")); } this.connection.exec((XVar)(sql)); return(null); }
public override XVar getPdfValue(dynamic data, dynamic _param_keylink = null) { #region default values if (_param_keylink as Object == null) { _param_keylink = new XVar(""); } #endregion #region pass-by-value parameters dynamic keylink = XVar.Clone(_param_keylink); #endregion dynamic imageType = null, width = null; if (XVar.Pack(!(XVar)(data[this.field]))) { return("\"\""); } width = XVar.Clone(this.container.pSet.getImageWidth((XVar)(this.field))); if (XVar.Pack(!(XVar)(width))) { width = new XVar(100); if (XVar.Equals(XVar.Pack(this.container.pageType), XVar.Pack(Constants.PAGE_VIEW))) { width = new XVar(300); } } imageType = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(data[this.field]))); if ((XVar)(imageType == "image/jpeg") || (XVar)(imageType == "image/png")) { return(MVCFunctions.Concat("{ \r\n\t\t\t\timage: \"", CommonFunctions.jsreplace((XVar)(MVCFunctions.Concat("data:", imageType, ";base64,", MVCFunctions.base64_encode((XVar)(data[this.field]))))), "\",\r\n\t\t\t\twidth: ", width, ", \r\n\t\t\t\theight: ", this.container.pSet.getImageHeight((XVar)(this.field)), " \r\n\t\t\t}")); } return("\"\""); }
public virtual XVar getSortBySettings() { dynamic sortSettings = XVar.Array(); if (!XVar.Equals(XVar.Pack(this._cachedSortBySettings), XVar.Pack(null))) { return(this._cachedSortBySettings); } sortSettings = XVar.Clone(this.pSet.getSortControlSettingsJSONString()); sortSettings = XVar.Clone(MVCFunctions.my_json_decode((XVar)(sortSettings))); if ((XVar)(!(XVar)(sortSettings)) || (XVar)(!(XVar)(MVCFunctions.count(sortSettings)))) { sortSettings = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> fName in this.pSet.getListFields().GetEnumerator()) { if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(this.pSet.getFieldType((XVar)(fName.Value)))))) { continue; } sortSettings.InitAndSetArrayItem(new XVar("label", "", "fields", new XVar(0, new XVar("field", fName.Value, "desc", false, "labelOnly", true))), null); } } this._cachedSortBySettings = XVar.Clone(sortSettings); return(sortSettings); }
protected override XVar getSubsetSQLComponents() { dynamic selectedRecords = XVar.Array(), sql = XVar.Array(); sql = XVar.Clone(XVar.Array()); selectedRecords = XVar.Clone(getSelectedRecords()); if (!XVar.Equals(XVar.Pack(selectedRecords), XVar.Pack(null))) { dynamic selectedWhereParts = XVar.Array(); sql.InitAndSetArrayItem(this.gQuery.getSqlComponents(), "sqlParts"); selectedWhereParts = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> keys in selectedRecords.GetEnumerator()) { selectedWhereParts.InitAndSetArrayItem(CommonFunctions.KeyWhere((XVar)(keys.Value)), null); } sql.InitAndSetArrayItem(MVCFunctions.implode(new XVar(" or "), (XVar)(selectedWhereParts)), "mandatoryWhere", null); if (0 == MVCFunctions.count(selectedRecords)) { sql.InitAndSetArrayItem("1=0", "mandatoryWhere", null); } } else { sql = XVar.Clone(base.getSubsetSQLComponents()); } if (this.connection.dbType == Constants.nDATABASE_DB2) { sql["sqlParts"]["head"] = MVCFunctions.Concat(sql["sqlParts"]["head"], ", ROW_NUMBER() over () as DB2_ROW_NUMBER "); } sql.InitAndSetArrayItem(SecuritySQL(new XVar("Export"), (XVar)(this.tName)), "mandatoryWhere", null); return(sql); }
public virtual XVar setRecordId(dynamic _param_recId) { #region pass-by-value parameters dynamic recId = XVar.Clone(_param_recId); #endregion foreach (KeyValuePair <XVar, dynamic> dummy in this.cells.GetEnumerator()) { dynamic cMapRef = XVar.Array(); cMapRef = this.cells[dummy.Key]; if ((XVar)(!(XVar)(cMapRef["hiddenRecords"])) || (XVar)(cMapRef["hidable"])) { continue; } foreach (KeyValuePair <XVar, dynamic> rec in cMapRef["hiddenRecords"].GetEnumerator()) { if (XVar.Equals(XVar.Pack(rec.Value), XVar.Pack(recId))) { cMapRef.InitAndSetArrayItem(true, "hidable"); break; } } } return(null); }
public virtual XVar refineOpenFilters(dynamic _param_openFilters) { #region pass-by-value parameters dynamic openFilters = XVar.Clone(_param_openFilters); #endregion dynamic openFiltersRefined = XVar.Array(); openFiltersRefined = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> panelFiled in this.panelSearchFields.GetEnumerator()) { dynamic key = null; key = XVar.Clone(MVCFunctions.array_search((XVar)(panelFiled.Value), (XVar)(openFilters))); if (!XVar.Equals(XVar.Pack(key), XVar.Pack(false))) { MVCFunctions.array_splice((XVar)(openFilters), (XVar)(key), new XVar(1)); } } foreach (KeyValuePair <XVar, dynamic> field in openFilters.GetEnumerator()) { if (XVar.Pack(MVCFunctions.in_array((XVar)(field.Value), (XVar)(this.allSearchFields)))) { openFiltersRefined.InitAndSetArrayItem(field.Value, null); } } return(openFiltersRefined); }
public override XVar showDBValue(dynamic data, dynamic _param_keylink) { #region pass-by-value parameters dynamic keylink = XVar.Clone(_param_keylink); #endregion dynamic imgSrc = null, result = null, trueCondition = null; result = new XVar("<img src=\""); imgSrc = new XVar("images/check_"); if (getHostPageDbType() == Constants.nDATABASE_PostgreSQL) { trueCondition = XVar.Clone((XVar)(XVar.Equals(XVar.Pack(data[this.field]), XVar.Pack("t"))) || (XVar)((XVar)(data[this.field] != 0) && (XVar)(data[this.field] != ""))); } else { trueCondition = XVar.Clone((XVar)(data[this.field] != 0) && (XVar)(data[this.field] != "")); } imgSrc = MVCFunctions.Concat(imgSrc, (XVar.Pack(trueCondition) ? XVar.Pack("yes") : XVar.Pack("no"))); result = MVCFunctions.Concat(result, MVCFunctions.GetRootPathForResources((XVar)(MVCFunctions.Concat(imgSrc, ".gif"))), "\" border=0"); if (XVar.Pack(CommonFunctions.isEnableSection508())) { result = MVCFunctions.Concat(result, " alt=\" \""); } result = MVCFunctions.Concat(result, ">"); return(result); }
public virtual XVar findHiddenRecords(dynamic _param_allItems, dynamic _param_hiddenItems) { #region pass-by-value parameters dynamic allItems = XVar.Clone(_param_allItems); dynamic hiddenItems = XVar.Clone(_param_hiddenItems); #endregion dynamic result = null; result = new XVar(null); foreach (KeyValuePair <XVar, dynamic> dummy in allItems.GetEnumerator()) { if (XVar.Pack(!(XVar)(hiddenItems[dummy.Key]))) { return(XVar.Array()); } if (XVar.Equals(XVar.Pack(result), XVar.Pack(null))) { result = XVar.Clone(hiddenItems[dummy.Key]); } else { result = XVar.Clone(MVCFunctions.array_intersect((XVar)(result), (XVar)(hiddenItems[dummy.Key]))); } if (MVCFunctions.count(result) == 0) { break; } } return(result); }
public override XVar SQLWhere(dynamic _param_SearchFor, dynamic _param_strSearchOption, dynamic _param_SearchFor2, dynamic _param_etype, dynamic _param_isSuggest) { #region pass-by-value parameters dynamic SearchFor = XVar.Clone(_param_SearchFor); dynamic strSearchOption = XVar.Clone(_param_strSearchOption); dynamic SearchFor2 = XVar.Clone(_param_SearchFor2); dynamic etype = XVar.Clone(_param_etype); dynamic isSuggest = XVar.Clone(_param_isSuggest); #endregion dynamic bNeedQuotes = null, baseResult = null, fullFieldName = null; baseResult = XVar.Clone(baseSQLWhere((XVar)(strSearchOption))); if (XVar.Equals(XVar.Pack(baseResult), XVar.Pack(false))) { return(""); } if (baseResult != XVar.Pack("")) { return(baseResult); } if ((XVar)(SearchFor == "none") || (XVar)((XVar)(SearchFor != "on") && (XVar)(SearchFor != "off"))) { return(""); } fullFieldName = XVar.Clone(getFieldSQLDecrypt()); bNeedQuotes = XVar.Clone(CommonFunctions.NeedQuotes((XVar)(this.var_type))); return(constructFieldWhere((XVar)(fullFieldName), (XVar)(bNeedQuotes), (XVar)(SearchFor == "on"), (XVar)(this.var_type), (XVar)(this.connection.dbType))); }
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", "")); }
protected virtual XVar getCommonWhere() { dynamic addWhere = null, typeWhere = null, wheres = XVar.Array(); wheres = XVar.Clone(XVar.Array()); if (XVar.Pack(this.userID)) { wheres.InitAndSetArrayItem(MVCFunctions.Concat(this.dbUserNameFieldName, "=", this.connection.prepareString((XVar)(this.userID))), null); } if (XVar.Pack(this.cookie)) { wheres.InitAndSetArrayItem(MVCFunctions.Concat(this.dbCookieFieldName, "=", this.connection.prepareString((XVar)(this.cookie))), null); } if (XVar.Pack(!(XVar)(MVCFunctions.count(wheres)))) { return("1=0"); } typeWhere = new XVar("1=1"); if (!XVar.Equals(XVar.Pack(this.var_type), XVar.Pack(Constants.SSEARCH_PARAMS_TYPE))) { typeWhere = XVar.Clone(MVCFunctions.Concat(this.dbTypeFieldName, "=", this.var_type)); } addWhere = XVar.Clone(CommonFunctions.whereAdd((XVar)(typeWhere), (XVar)(MVCFunctions.implode(new XVar(" OR "), (XVar)(wheres))))); return(CommonFunctions.whereAdd((XVar)(MVCFunctions.Concat(this.dbTableNameFieldName, "=", this.connection.prepareString((XVar)(this.tableNameId)))), (XVar)(addWhere))); }
public override XVar afterSuccessfulSave() { if (0 < MVCFunctions.count(XSession.Session[MVCFunctions.Concat("mupload_", this.formStamp)])) { foreach (KeyValuePair <XVar, dynamic> fileArray in XSession.Session[MVCFunctions.Concat("mupload_", this.formStamp)].GetEnumerator()) { if (XVar.Equals(XVar.Pack(fileArray.Value["deleted"]), XVar.Pack(true))) { dynamic file_path = null; file_path = XVar.Clone(fileArray.Value["file"]["name"]); if (XVar.Pack(MVCFunctions.file_exists(file_path))) { MVCFunctions.unlink((XVar)(file_path)); } if (fileArray.Value["file"]["thumbnail"] != "") { file_path = XVar.Clone(fileArray.Value["file"]["thumbnail"]); if (XVar.Pack(MVCFunctions.file_exists(file_path))) { MVCFunctions.unlink((XVar)(file_path)); } } } } } XSession.Session.Remove(MVCFunctions.Concat("mupload_", this.formStamp)); return(null); }
protected virtual XVar openQuery() { dynamic listarray = null; prepareCustomListQueryLegacySorting(); calcPageSizeAndNumber(); listarray = new XVar(false); if (XVar.Pack(this.eventsObject.exists(new XVar("ListQuery")))) { listarray = XVar.Clone(this.eventsObject.ListQuery((XVar)(this.searchClauseObj), (XVar)(this.customFieldForSort), (XVar)(this.customHowFieldSort), (XVar)(this.masterTable), (XVar)(this.masterKeys), (XVar)(this.selection), (XVar)(this.queryPageSize), (XVar)(this.queryPageNo), this)); } if (!XVar.Equals(XVar.Pack(listarray), XVar.Pack(false))) { this.recordset = XVar.Clone(listarray); } else { if (XVar.Pack(this.allPagesMode)) { this.recordset = XVar.Clone(this.connection.query((XVar)(this.querySQL))); } else { this.recordset = XVar.Clone(this.connection.queryPage((XVar)(this.querySQL), (XVar)(this.queryPageNo), (XVar)(this.queryPageSize), (XVar)(this.totalRowCount))); } } return(null); }
public SearchPage(dynamic var_params) : base((XVar)var_params) { if (skipSearchPageCtor) { skipSearchPageCtor = false; return; } 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, "below-grid")); this.bodyForms = XVar.Clone(new XVar(0, "grid")); } else { this.formBricks.InitAndSetArrayItem("searchheader", "header"); this.formBricks.InitAndSetArrayItem("searchbuttons", "footer"); } if (XVar.Pack(MVCFunctions.count(this.extraPageParams))) { this.jsSettings.InitAndSetArrayItem(this.extraPageParams, "tableSettings", this.tName, "extraSearchPageParams"); } this.jsSettings.InitAndSetArrayItem(this.pSet.getAdvSearchFields(), "tableSettings", this.tName, "searchPageFields"); }
public virtual XVar getFilterExtraControls(dynamic _param_dExtraCtrls = null) { #region default values if (_param_dExtraCtrls as Object == null) { _param_dExtraCtrls = new XVar(); } #endregion #region pass-by-value parameters dynamic dExtraCtrls = XVar.Clone(_param_dExtraCtrls); #endregion dynamic selectAllAttrs = null; selectAllAttrs = new XVar(""); if ((XVar)(!(XVar)(this.filtered)) && (XVar)(!XVar.Equals(XVar.Pack(this.multiSelect), XVar.Pack(Constants.FM_NONE)))) { selectAllAttrs = new XVar("checked=\"checked\""); } if (this.multiSelect == Constants.FM_ON_DEMAND) { selectAllAttrs = MVCFunctions.Concat(selectAllAttrs, " style=\"display: none;\""); } return(new XVar("clearLink", this.filtered, "selectAllAttrs", selectAllAttrs, "numberOfExtraItemsToShow", getNumberOfExtraItemsToShow())); }
protected virtual XVar getControlMap(dynamic _param_fName, dynamic _param_format, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_hidden, dynamic _param_value) { #region pass-by-value parameters dynamic fName = XVar.Clone(_param_fName); dynamic format = XVar.Clone(_param_format); dynamic recId = XVar.Clone(_param_recId); dynamic fieldNum = XVar.Clone(_param_fieldNum); dynamic hidden = XVar.Clone(_param_hidden); dynamic value = XVar.Clone(_param_value); #endregion dynamic ctrlsMap = XVar.Array(), preload = null; ctrlsMap = XVar.Clone(new XVar("controls", XVar.Array())); ctrlsMap.InitAndSetArrayItem(fName, "controls", "fieldName"); ctrlsMap.InitAndSetArrayItem(Constants.MODE_SEARCH, "controls", "mode"); ctrlsMap.InitAndSetArrayItem(format, "controls", "editFormat"); ctrlsMap.InitAndSetArrayItem(recId, "controls", "id"); ctrlsMap.InitAndSetArrayItem(fieldNum, "controls", "ctrlInd"); ctrlsMap.InitAndSetArrayItem(hidden, "controls", "hidden"); ctrlsMap.InitAndSetArrayItem(this.tName, "controls", "table"); preload = XVar.Clone(this.pageObj.fillPreload((XVar)(fName), (XVar)(new XVar(0, fName)), (XVar)(new XVar(fName, value)), (XVar)(this.controlsContainer))); if (!XVar.Equals(XVar.Pack(preload), XVar.Pack(false))) { ctrlsMap.InitAndSetArrayItem(preload, "controls", "preloadData"); } return(ctrlsMap); }
public virtual XVar display_loaded(dynamic _param_filtertag = null) { #region default values if (_param_filtertag as Object == null) { _param_filtertag = new XVar(""); } #endregion #region pass-by-value parameters dynamic filtertag = XVar.Clone(_param_filtertag); #endregion dynamic str = null; str = XVar.Clone(this.template); if (XVar.Pack(filtertag)) { dynamic pos1 = null, pos2 = null; if ((XVar)(!(XVar)(this.xt_vars.KeyExists(filtertag))) || (XVar)(XVar.Equals(XVar.Pack(this.xt_vars[filtertag]), XVar.Pack(false)))) { return(null); } pos1 = XVar.Clone(MVCFunctions.strpos((XVar)(this.template), (XVar)(MVCFunctions.Concat("{BEGIN ", filtertag, "}")))); pos2 = XVar.Clone(MVCFunctions.strpos((XVar)(this.template), (XVar)(MVCFunctions.Concat("{END ", filtertag, "}")))); if ((XVar)(XVar.Equals(XVar.Pack(pos1), XVar.Pack(false))) || (XVar)(XVar.Equals(XVar.Pack(pos2), XVar.Pack(false)))) { return(null); } pos2 += MVCFunctions.strlen((XVar)(MVCFunctions.Concat("{END ", filtertag, "}"))); str = XVar.Clone(MVCFunctions.substr((XVar)(this.template), (XVar)(pos1), (XVar)(pos2 - pos1))); } Testing(); CommonFunctions.xt_process_template(this, (XVar)(str)); return(null); }
protected virtual XVar getLoggedInRedirectUrl() { if (XVar.Pack(this.myurl)) { return(MVCFunctions.Concat(this.myurl, (XVar.Pack(!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(this.myurl), new XVar("?"))), XVar.Pack(false))) ? XVar.Pack("&a=login") : XVar.Pack("?a=login")))); } return(MVCFunctions.GetTableLink(new XVar("menu"))); }
public virtual XVar create_scaled_image(dynamic _param_file_path, dynamic _param_uploadDir, dynamic _param_new_file_name, dynamic _param_options, dynamic file, dynamic _param_isThumbnail, dynamic _param_uploadDirRelative, dynamic _param_uploadedFile) { #region pass-by-value parameters dynamic file_path = XVar.Clone(_param_file_path); dynamic uploadDir = XVar.Clone(_param_uploadDir); dynamic new_file_name = XVar.Clone(_param_new_file_name); dynamic options = XVar.Clone(_param_options); dynamic isThumbnail = XVar.Clone(_param_isThumbnail); dynamic uploadDirRelative = XVar.Clone(_param_uploadDirRelative); dynamic uploadedFile = XVar.Clone(_param_uploadedFile); #endregion dynamic img_height = null, img_size = XVar.Array(), img_width = null, new_file_path = null, new_height = null, new_width = null, scale = null, success = null; img_size = XVar.Clone(MVCFunctions.runner_getimagesize((XVar)(file_path), (XVar)(uploadedFile))); img_width = XVar.Clone(img_size[0]); img_height = XVar.Clone(img_size[1]); new_file_path = XVar.Clone(MVCFunctions.Concat(uploadDir, new_file_name)); if ((XVar)(!(XVar)(img_width)) || (XVar)(!(XVar)(img_height))) { MVCFunctions.unlink((XVar)(new_file_path)); return(false); } scale = XVar.Clone(MVCFunctions.min((XVar)(options["max_width"] / img_width), (XVar)(options["max_height"] / img_height))); if (1 <= scale) { if (!XVar.Equals(XVar.Pack(file_path), XVar.Pack(new_file_path))) { dynamic result = null; result = XVar.Clone(MVCFunctions.copy((XVar)(file_path), (XVar)(new_file_path))); if ((XVar)(result) && (XVar)(isThumbnail)) { file.InitAndSetArrayItem(MVCFunctions.Concat(uploadDirRelative, new_file_name), "thumbnail"); file.InitAndSetArrayItem(MVCFunctions.filesize((XVar)(file_path)), "thumbnail_size"); file.InitAndSetArrayItem(file["type"], "thumbnail_type"); } return(result); } return(false); } new_width = XVar.Clone(img_width * scale); new_height = XVar.Clone(img_height * scale); success = XVar.Clone(MVCFunctions.imageCreateThumb((XVar)(new_width), (XVar)(new_height), (XVar)(img_width), (XVar)(img_height), (XVar)(file_path), (XVar)(options), (XVar)(new_file_path), (XVar)(uploadedFile))); if (XVar.Pack(success)) { if (XVar.Pack(isThumbnail)) { file.InitAndSetArrayItem(MVCFunctions.Concat(uploadDirRelative, new_file_name), "thumbnail"); file.InitAndSetArrayItem(MVCFunctions.filesize((XVar)(new_file_path)), "thumbnail_size"); file.InitAndSetArrayItem(file["type"], "thumbnail_type"); } else { file.InitAndSetArrayItem(new_file_name, "name"); file.InitAndSetArrayItem(MVCFunctions.filesize((XVar)(new_file_path)), "size"); } } return(success); }
public virtual XVar showPageAjax() { dynamic proceedLink = null, returnJSON = XVar.Array(); returnJSON = XVar.Clone(XVar.Array()); proceedLink = XVar.Clone(getProceedLink()); if ((XVar)((XVar)((XVar)((XVar)((XVar)(!(XVar)(this.numRowsFromSQL)) && (XVar)(!(XVar)(addAvailable()))) && (XVar)(!(XVar)(inlineAddAvailable()))) && (XVar)(!(XVar)(this.recordsDeleted))) && (XVar)(proceedLink == XVar.Pack(""))) && (XVar)(getGridTabsCount() == 0)) { returnJSON.InitAndSetArrayItem(false, "success"); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(null); } addControlsJSAndCSS(); fillSetCntrlMaps(); returnJSON.InitAndSetArrayItem(GlobalVars.pagesData, "pagesData"); returnJSON.InitAndSetArrayItem(this.controlsHTMLMap, "controlsMap"); returnJSON.InitAndSetArrayItem(this.viewControlsHTMLMap, "viewControlsMap"); returnJSON.InitAndSetArrayItem(this.jsSettings, "settings"); this.xt.assign(new XVar("header"), new XVar(false)); this.xt.assign(new XVar("footer"), new XVar(false)); if (XVar.Equals(XVar.Pack(getLayoutVersion()), XVar.Pack(Constants.PD_BS_LAYOUT))) { returnJSON.InitAndSetArrayItem(MVCFunctions.Concat(proceedLink, this.xt.fetch_loaded(new XVar("above-grid_block"))), "headerCont"); } else { returnJSON.InitAndSetArrayItem(MVCFunctions.Concat(proceedLink, getHeaderControlsBlocks()), "headerCont"); } if (XVar.Pack(this.formBricks["footer"])) { if (XVar.Equals(XVar.Pack(getLayoutVersion()), XVar.Pack(Constants.PD_BS_LAYOUT))) { returnJSON.InitAndSetArrayItem(this.xt.fetch_loaded(new XVar("below-grid_block")), "footerCont"); } else { returnJSON.InitAndSetArrayItem(fetchBlocksList((XVar)(this.formBricks["footer"]), new XVar(true)), "footerCont"); } } assignFormFooterAndHeaderBricks(new XVar(false)); this.xt.prepareContainers(); if (XVar.Equals(XVar.Pack(getLayoutVersion()), XVar.Pack(Constants.PD_BS_LAYOUT))) { returnJSON.InitAndSetArrayItem(this.xt.fetch_loaded(new XVar("grid_block")), "html"); } else { returnJSON.InitAndSetArrayItem(this.xt.fetch_loaded(new XVar("body")), "html"); } returnJSON.InitAndSetArrayItem(this.flyId, "idStartFrom"); returnJSON.InitAndSetArrayItem(true, "success"); returnJSON.InitAndSetArrayItem(grabAllJsFiles(), "additionalJS"); returnJSON.InitAndSetArrayItem(grabAllCSSFiles(), "CSSFiles"); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(null); }
public virtual XVar isStopSymbol(dynamic _param_smb) { #region pass-by-value parameters dynamic smb = XVar.Clone(_param_smb); #endregion return(!XVar.Equals(XVar.Pack(MVCFunctions.strpos(new XVar(" .,;:\"'?!|\\/=(){}[]*-+\n\r"), (XVar)(smb))), XVar.Pack(false))); return(null); }
public static XVar cutprefix(XVar table) { XVar pos = MVCFunctions.strpos(table, "."); if (pos.Equals(false)) { return(table); } return(MVCFunctions.substr(table, pos + 1)); }
public virtual XVar buildControl(dynamic _param_value, dynamic _param_mode, dynamic _param_fieldNum, dynamic _param_validate, dynamic _param_additionalCtrlParams, dynamic _param_data) { #region pass-by-value parameters dynamic value = XVar.Clone(_param_value); dynamic mode = XVar.Clone(_param_mode); dynamic fieldNum = XVar.Clone(_param_fieldNum); dynamic validate = XVar.Clone(_param_validate); dynamic additionalCtrlParams = XVar.Clone(_param_additionalCtrlParams); dynamic data = XVar.Clone(_param_data); #endregion dynamic additionalClass = null, arrKeys = XVar.Array(), isHidden = null, j = null; this.searchPanelControl = XVar.Clone(isSearchPanelControl((XVar)(mode), (XVar)(additionalCtrlParams))); this.inputStyle = XVar.Clone(getInputStyle((XVar)(mode))); if (XVar.Pack(fieldNum)) { this.cfield = XVar.Clone(MVCFunctions.Concat("value", fieldNum, "_", this.goodFieldName, "_", this.id)); this.ctype = XVar.Clone(MVCFunctions.Concat("type", fieldNum, "_", this.goodFieldName, "_", this.id)); } this.iquery = XVar.Clone(MVCFunctions.Concat("field=", MVCFunctions.RawUrlEncode((XVar)(this.field)))); arrKeys = XVar.Clone(this.pageObject.pSetEdit.getTableKeys()); j = new XVar(0); for (; j < MVCFunctions.count(arrKeys); j++) { this.keylink = MVCFunctions.Concat(this.keylink, "&key", j + 1, "=", MVCFunctions.RawUrlEncode((XVar)(data[arrKeys[j]]))); } this.iquery = MVCFunctions.Concat(this.iquery, this.keylink); isHidden = XVar.Clone((XVar)(additionalCtrlParams.KeyExists("hidden")) && (XVar)(additionalCtrlParams["hidden"])); additionalClass = new XVar(""); if (XVar.Pack(this.pageObject.isBootstrap())) { if (XVar.Pack(this.pageObject.isPD())) { additionalClass = MVCFunctions.Concat(additionalClass, "bs-ctrlspan "); } else { additionalClass = MVCFunctions.Concat(additionalClass, "bs-ctrlspan rnr-nowrap "); } if (this.format == Constants.EDIT_FORMAT_READONLY) { additionalClass = MVCFunctions.Concat(additionalClass, "form-control-static "); } if ((XVar)(MVCFunctions.count(validate["basicValidate"])) && (XVar)(!XVar.Equals(XVar.Pack(MVCFunctions.array_search(new XVar("IsRequired"), (XVar)(validate["basicValidate"]))), XVar.Pack(false)))) { additionalClass = MVCFunctions.Concat(additionalClass, "bs-inlinerequired"); } } else { additionalClass = MVCFunctions.Concat(additionalClass, "rnr-nowrap "); } MVCFunctions.Echo(MVCFunctions.Concat("<span id=\"edit", this.id, "_", this.goodFieldName, "_", fieldNum, "\" class=\"", additionalClass, "\"", (XVar.Pack(isHidden) ? XVar.Pack(" style=\"display:none\"") : XVar.Pack("")), ">")); return(null); }
public virtual XVar addDateQuotes(dynamic _param_val) { #region pass-by-value parameters dynamic val = XVar.Clone(_param_val); #endregion if ((XVar)(val == XVar.Pack("")) || (XVar)(XVar.Equals(XVar.Pack(val), XVar.Pack(null)))) { return("null"); } return(MVCFunctions.Concat("'", addSlashes((XVar)(val)), "'")); }