public static XVar ExportToExcel(dynamic _param_rs, dynamic _param_nPageSize, dynamic _param_eventObj, dynamic _param_cipherer, dynamic _param_pageObj) { #region pass-by-value parameters dynamic rs = XVar.Clone(_param_rs); dynamic nPageSize = XVar.Clone(_param_nPageSize); dynamic eventObj = XVar.Clone(_param_eventObj); dynamic cipherer = XVar.Clone(_param_cipherer); dynamic pageObj = XVar.Clone(_param_pageObj); #endregion dynamic arrColumnWidth = XVar.Array(), arrFields = XVar.Array(), arrLabel = XVar.Array(), arrTmpTotal = XVar.Array(), arrTotal = XVar.Array(), arrTotalMessage = XVar.Array(), eventRes = null, iNumberOfRows = null, objPHPExcel = null, row = XVar.Array(), totals = XVar.Array(), totalsFields = XVar.Array(), values = XVar.Array(); if (XVar.Pack(eventObj.exists(new XVar("ListFetchArray")))) { row = XVar.Clone(eventObj.ListFetchArray((XVar)(rs), (XVar)(pageObj))); } else { row = XVar.Clone(cipherer.DecryptFetchedArray((XVar)(pageObj.connection.fetch_array((XVar)(rs))))); } totals = XVar.Clone(XVar.Array()); arrLabel = XVar.Clone(XVar.Array()); arrTotal = XVar.Clone(XVar.Array()); arrFields = XVar.Clone(XVar.Array()); arrColumnWidth = XVar.Clone(XVar.Array()); arrTotalMessage = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> field in pageObj.selectedFields.GetEnumerator()) { if (XVar.Pack(pageObj.pSet.appearOnExportPage((XVar)(field.Value)))) { arrFields.InitAndSetArrayItem(field.Value, null); } } arrTmpTotal = XVar.Clone(pageObj.pSet.getTotalsFields()); pageObj.viewControls.setForExportVar(new XVar("excel")); foreach (KeyValuePair <XVar, dynamic> field in arrFields.GetEnumerator()) { arrLabel.InitAndSetArrayItem(CommonFunctions.GetFieldLabel((XVar)(MVCFunctions.GoodFieldName((XVar)(pageObj.tName))), (XVar)(MVCFunctions.GoodFieldName((XVar)(field.Value)))), field.Value); arrColumnWidth.InitAndSetArrayItem(10, field.Value); totals.InitAndSetArrayItem(new XVar("value", 0, "numRows", 0), field.Value); foreach (KeyValuePair <XVar, dynamic> tvalue in arrTmpTotal.GetEnumerator()) { if (tvalue.Value["fName"] == field.Value) { totalsFields.InitAndSetArrayItem(new XVar("fName", field.Value, "totalsType", tvalue.Value["totalsType"], "viewFormat", pageObj.pSet.getViewFormat((XVar)(field.Value))), null); } } } iNumberOfRows = new XVar(0); objPHPExcel = XVar.Clone(ExportFunctions.ExportExcelInit((XVar)(arrLabel), (XVar)(arrColumnWidth))); while ((XVar)((XVar)(!(XVar)(nPageSize)) || (XVar)(iNumberOfRows < nPageSize)) && (XVar)(row)) { CommonFunctions.countTotals((XVar)(totals), (XVar)(totalsFields), (XVar)(row)); values = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> field in arrFields.GetEnumerator()) { if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(pageObj.pSet.getFieldType((XVar)(field.Value)))))) { values.InitAndSetArrayItem(row[field.Value], field.Value); } else { values.InitAndSetArrayItem(pageObj.getFormattedFieldValue((XVar)(field.Value), (XVar)(row)), field.Value); } } eventRes = new XVar(true); if (XVar.Pack(eventObj.exists(new XVar("BeforeOut")))) { eventRes = XVar.Clone(eventObj.BeforeOut((XVar)(row), (XVar)(values), (XVar)(pageObj))); } if (XVar.Pack(eventRes)) { dynamic arrData = XVar.Array(), arrDataType = XVar.Array(), i = null; arrData = XVar.Clone(XVar.Array()); arrDataType = XVar.Clone(XVar.Array()); iNumberOfRows++; i = new XVar(0); foreach (KeyValuePair <XVar, dynamic> field in arrFields.GetEnumerator()) { dynamic vFormat = null; vFormat = XVar.Clone(pageObj.pSet.getViewFormat((XVar)(field.Value))); if (XVar.Pack(CommonFunctions.IsBinaryType((XVar)(pageObj.pSet.getFieldType((XVar)(field.Value)))))) { arrDataType.InitAndSetArrayItem("binary", field.Value); } else { if ((XVar)((XVar)(vFormat == Constants.FORMAT_DATE_SHORT) || (XVar)(vFormat == Constants.FORMAT_DATE_LONG)) || (XVar)(vFormat == Constants.FORMAT_DATE_TIME)) { arrDataType.InitAndSetArrayItem("date", field.Value); } else { if (vFormat == Constants.FORMAT_FILE_IMAGE) { arrDataType.InitAndSetArrayItem("file", field.Value); } else { arrDataType.InitAndSetArrayItem("", field.Value); } } } arrData.InitAndSetArrayItem(values[field.Value], field.Value); } ExportFunctions.ExportExcelRecord((XVar)(arrData), (XVar)(arrDataType), (XVar)(iNumberOfRows), (XVar)(objPHPExcel), (XVar)(pageObj)); } if (XVar.Pack(eventObj.exists(new XVar("ListFetchArray")))) { row = XVar.Clone(eventObj.ListFetchArray((XVar)(rs), (XVar)(pageObj))); } else { row = XVar.Clone(cipherer.DecryptFetchedArray((XVar)(pageObj.connection.fetch_array((XVar)(rs))))); } } if (XVar.Pack(MVCFunctions.count(arrTmpTotal))) { foreach (KeyValuePair <XVar, dynamic> fName in arrFields.GetEnumerator()) { dynamic total = null, totalMess = null, value = XVar.Array(); value = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> tvalue in arrTmpTotal.GetEnumerator()) { if (tvalue.Value["fName"] == fName.Value) { value = XVar.Clone(tvalue.Value); } } total = new XVar(""); totalMess = new XVar(""); if (XVar.Pack(value["totalsType"])) { if (value["totalsType"] == "COUNT") { totalMess = XVar.Clone(MVCFunctions.Concat("Count", ": ")); } else { if (value["totalsType"] == "TOTAL") { totalMess = XVar.Clone(MVCFunctions.Concat("Total", ": ")); } else { if (value["totalsType"] == "AVERAGE") { totalMess = XVar.Clone(MVCFunctions.Concat("Average", ": ")); } } } total = XVar.Clone(CommonFunctions.GetTotals((XVar)(fName.Value), (XVar)(totals[fName.Value]["value"]), (XVar)(value["totalsType"]), (XVar)(totals[fName.Value]["numRows"]), (XVar)(value["viewFormat"]), new XVar("export"), (XVar)(pageObj.pSet))); } arrTotal.InitAndSetArrayItem(total, fName.Value); arrTotalMessage.InitAndSetArrayItem(totalMess, fName.Value); } } ExportFunctions.ExportExcelTotals((XVar)(arrTotal), (XVar)(arrTotalMessage), (XVar)(++(iNumberOfRows)), (XVar)(objPHPExcel)); ExportFunctions.ExportExcelSave((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(pageObj.tName)), ".xlsx")), new XVar("Excel2007"), (XVar)(objPHPExcel)); return(null); }
public override XVar commonAssign() { dynamic i = null, permis = null; base.commonAssign(); this.xt.assign(new XVar("left_block"), new XVar(false)); if ((XVar)((XVar)(this.masterPageType == Constants.PAGE_ADD) || (XVar)(this.masterPageType == Constants.PAGE_VIEW)) || (XVar)(this.mode == Constants.LIST_DASHDETAILS)) { this.xt.assign(new XVar("selectall_link"), new XVar(false)); this.xt.assign(new XVar("checkbox_column"), new XVar(false)); this.xt.assign(new XVar("checkbox_header"), new XVar(false)); this.xt.assign(new XVar("editselected_link"), new XVar(false)); this.xt.assign(new XVar("delete_link"), new XVar(false)); this.xt.assign(new XVar("saveall_link"), new XVar(false)); this.xt.assign(new XVar("withSelectedClass"), new XVar("rnr-hiddenelem")); if (this.masterPageType == Constants.PAGE_VIEW) { this.xt.assign(new XVar("record_controls_block"), new XVar(false)); } } else { selectAllLinkAttrs(); if (XVar.Pack(!(XVar)(mobileTemplateMode()))) { checkboxColumnAttrs(); } editSelectedLinkAttrs(); saveAllLinkAttrs(); deleteSelectedLink(); if (this.masterPageType != Constants.PAGE_EDIT) { dynamic searchPermis = null; searchPermis = XVar.Clone(this.permis[this.tName]["search"]); this.xt.assign(new XVar("record_controls_block"), (XVar)((XVar)((XVar)(this.permis[this.tName]["edit"]) && (XVar)(this.pSet.hasInlineEdit())) || (XVar)((XVar)(this.permis[this.tName]["delete"]) && (XVar)(this.pSet.hasDelete())))); this.xt.assign(new XVar("details_block"), (XVar)((XVar)(searchPermis) && (XVar)(this.rowsFound))); this.xt.assign(new XVar("details_attrs"), (XVar)(MVCFunctions.Concat("id=\"detFound", this.id, "\" name=\"detFound", this.id, "\""))); this.xt.assign(new XVar("pages_block"), (XVar)((XVar)(searchPermis) && (XVar)(this.rowsFound))); } } this.xt.assign(new XVar("withSelected"), (XVar)((XVar)((XVar)(this.permis[this.tName]["export"]) || (XVar)(this.permis[this.tName]["edit"])) || (XVar)(this.permis[this.tName]["delete"]))); if (this.numRowsFromSQL == 0) { this.xt.displayBrickHidden(new XVar("recordcontrol")); } if (this.masterPageType != Constants.PAGE_VIEW) { this.xt.assign(new XVar("inlineedit_column"), (XVar)((XVar)(inlineEditAvailable()) && (XVar)(this.permis[this.tName]["edit"]))); assignListIconsColumn(); cancelAllLinkAttrs(); } i = new XVar(0); for (; i < MVCFunctions.count(this.allDetailsTablesArr); i++) { permis = XVar.Clone((XVar)((XVar)(this.isGroupSecurity) && (XVar)((XVar)(this.permis[this.allDetailsTablesArr[i]["dDataSourceTable"]]["add"]) || (XVar)(this.permis[this.allDetailsTablesArr[i]["dDataSourceTable"]]["search"]))) || (XVar)(!(XVar)(this.isGroupSecurity))); if (XVar.Pack(permis)) { this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(this.tName)), "_dtable_column")), (XVar)(permis)); break; } } return(null); }
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 XVar searchsuggest() { try { dynamic _connection = null, allSearchFields = XVar.Array(), controls = null, detailKeys = XVar.Array(), numberOfSuggests = null, query = null, result = XVar.Array(), returnJSON = XVar.Array(), searchClauseObj = null, searchField = null, searchFor = null, searchOpt = null, table = null, var_response = XVar.Array(), 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()); } _connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName))); var_response = XVar.Clone(XVar.Array()); 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))); pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), new XVar(Constants.PAGE_SEARCH))); query = XVar.Clone(pSet.getSQLQuery()); if (searchField == XVar.Pack("")) { allSearchFields = XVar.Clone(pSet.getGoogleLikeFields()); } else { allSearchFields = XVar.Clone(pSet.getAllSearchFields()); } detailKeys = XVar.Clone(XVar.Array()); whereClauses = XVar.Clone(XVar.Array()); whereClauses.InitAndSetArrayItem(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(GlobalVars.strTableName)), null); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); controls = XVar.Clone(new EditControlsContainer(new XVar(null), (XVar)(pSet), new XVar(Constants.PAGE_LIST), (XVar)(GlobalVars.cipherer))); 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(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> f in allSearchFields.GetEnumerator()) { dynamic clausesData = XVar.Array(), distinct = null, fType = null, fieldControl = null, having = null, isAggregateField = null, qResult = null, row = XVar.Array(), sql = XVar.Array(), subQuery = null, val = null, where = null; fType = XVar.Clone(pSet.getFieldType((XVar)(f.Value))); if ((XVar)((XVar)((XVar)(!(XVar)(CommonFunctions.IsCharType((XVar)(fType)))) && (XVar)(!(XVar)(CommonFunctions.IsNumberType((XVar)(fType))))) && (XVar)(!(XVar)(CommonFunctions.IsGuid((XVar)(fType))))) || (XVar)(MVCFunctions.in_array((XVar)(f.Value), (XVar)(detailKeys)))) { continue; } if ((XVar)(_connection.dbType == Constants.nDATABASE_Oracle) && (XVar)(CommonFunctions.IsTextType((XVar)(fType)))) { continue; } if ((XVar)((XVar)(searchField != XVar.Pack("")) && (XVar)(searchField != MVCFunctions.GoodFieldName((XVar)(f.Value)))) || (XVar)(!(XVar)(pSet.checkFieldPermissions((XVar)(f.Value))))) { continue; } fieldControl = XVar.Clone(controls.getControl((XVar)(f.Value))); isAggregateField = XVar.Clone(pSet.isAggregateField((XVar)(f.Value))); where = XVar.Clone(fieldControl.getSuggestWhere((XVar)(searchOpt), (XVar)(searchFor), (XVar)(isAggregateField))); having = XVar.Clone(fieldControl.getSuggestHaving((XVar)(searchOpt), (XVar)(searchFor), (XVar)(isAggregateField))); if ((XVar)(!(XVar)(MVCFunctions.strlen((XVar)(where)))) && (XVar)(!(XVar)(MVCFunctions.strlen((XVar)(having))))) { continue; } distinct = new XVar("DISTINCT"); if ((XVar)(_connection.dbType == Constants.nDATABASE_MSSQLServer) || (XVar)(_connection.dbType == Constants.nDATABASE_Access)) { if (XVar.Pack(CommonFunctions.IsTextType((XVar)(fType)))) { distinct = new XVar(""); } } sql = XVar.Clone(query.getSqlComponents()); clausesData = XVar.Clone(fieldControl.getSelectColumnsAndJoinFromPart((XVar)(searchFor), (XVar)(searchOpt), new XVar(true))); if (0 == MVCFunctions.strlen((XVar)(clausesData["joinFromPart"]))) { subQuery = XVar.Clone(SQLQuery.buildSQL((XVar)(sql), (XVar)(whereClauses), (XVar)(XVar.Array()), (XVar)(new XVar(0, where)), (XVar)(new XVar(0, having)))); GlobalVars.strSQL = XVar.Clone(MVCFunctions.Concat("SELECT ", distinct, " st.", _connection.addFieldWrappers((XVar)(f.Value)), " from (", subQuery, ") st")); } else { sql["from"] = MVCFunctions.Concat(sql["from"], clausesData["joinFromPart"]); sql.InitAndSetArrayItem(MVCFunctions.Concat("SELECT ", distinct, " ", clausesData["selectColumns"], " as ", _connection.addFieldWrappers(new XVar("_srchfld_"))), "head"); subQuery = XVar.Clone(SQLQuery.buildSQL((XVar)(sql), (XVar)(whereClauses), (XVar)(XVar.Array()), (XVar)(new XVar(0, where)), (XVar)(new XVar(0, having)))); GlobalVars.strSQL = XVar.Clone(MVCFunctions.Concat("SELECT ", _connection.addFieldWrappers(new XVar("_srchfld_")), " from (", subQuery, ") st")); } qResult = XVar.Clone(_connection.queryPage((XVar)(GlobalVars.strSQL), new XVar(1), (XVar)(numberOfSuggests), new XVar(true))); while ((XVar)(row = XVar.Clone(qResult.fetchNumeric())) && (XVar)(MVCFunctions.count(var_response) < numberOfSuggests)) { val = XVar.Clone(GlobalVars.cipherer.DecryptField((XVar)(f.Value), (XVar)(row[0]))); if (XVar.Pack(CommonFunctions.IsGuid((XVar)(fType)))) { val = XVar.Clone(MVCFunctions.substr((XVar)(val), new XVar(1), new XVar(-1))); } fieldControl.suggestValue((XVar)(MVCFunctions.Concat("_", val)), (XVar)(searchFor), (XVar)(var_response), (XVar)(row)); } } _connection.close(); MVCFunctions.ksort(ref var_response, new XVar(Constants.SORT_STRING)); foreach (KeyValuePair <XVar, dynamic> realValue in var_response.GetEnumerator()) { dynamic pos = null, strRealValue = null, strValue = null; if (numberOfSuggests < MVCFunctions.count(result)) { break; } strValue = XVar.Clone((XVar.Pack(realValue.Key[0] == "_") ? XVar.Pack(MVCFunctions.substr((XVar)(realValue.Key), new XVar(1))) : XVar.Pack(realValue.Key))); strRealValue = XVar.Clone((XVar.Pack(realValue.Value[0] == "_") ? XVar.Pack(MVCFunctions.substr((XVar)(realValue.Value), new XVar(1))) : XVar.Pack(realValue.Value))); pos = XVar.Clone(CommonFunctions.my_stripos((XVar)(strValue), (XVar)(searchFor), new XVar(0))); if (XVar.Equals(XVar.Pack(pos), XVar.Pack(false))) { result.InitAndSetArrayItem(new XVar("value", MVCFunctions.runner_htmlspecialchars((XVar)(strValue)), "realValue", strRealValue), null); } else { dynamic highlightedValue = null; highlightedValue = XVar.Clone(MVCFunctions.Concat(MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.substr((XVar)(strValue), new XVar(0), (XVar)(pos)))), "<b>", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.substr((XVar)(strValue), (XVar)(pos), (XVar)(MVCFunctions.strlen((XVar)(searchFor)))))), "</b>", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.substr((XVar)(strValue), (XVar)(pos + MVCFunctions.strlen((XVar)(searchFor)))))))); result.InitAndSetArrayItem(new XVar("value", highlightedValue, "realValue", strRealValue), null); } } 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 override XVar showDBValue(dynamic data, dynamic _param_keylink) { #region pass-by-value parameters dynamic keylink = XVar.Clone(_param_keylink); #endregion dynamic fieldIsUrl = null, fileName = null, value = null; value = new XVar(""); fieldIsUrl = XVar.Clone(this.container.pSet.isVideoUrlField((XVar)(this.field))); fileName = XVar.Clone(data[this.field]); if (XVar.Pack(MVCFunctions.strlen((XVar)(fileName)))) { dynamic counter = null, filesArray = XVar.Array(), pageType = null, printOrExportPage = null; if (XVar.Pack(!(XVar)(fieldIsUrl))) { this.upload_handler.tkeys = XVar.Clone(keylink); filesArray = XVar.Clone(getFilesArray((XVar)(fileName))); } else { filesArray = XVar.Clone(new XVar(0, fileName)); } pageType = XVar.Clone(this.container.pageType); printOrExportPage = XVar.Clone((XVar)((XVar)(pageType == Constants.PAGE_EXPORT) || (XVar)(pageType == Constants.PAGE_PRINT)) || (XVar)(this.container.forExport != "")); counter = new XVar(0); foreach (KeyValuePair <XVar, dynamic> file in filesArray.GetEnumerator()) { dynamic href = null, vHeight = null, vWidth = null, var_type = null, videoId = null; if (XVar.Pack(printOrExportPage)) { if (value != XVar.Pack("")) { value = MVCFunctions.Concat(value, ", "); } if (XVar.Pack(fieldIsUrl)) { value = MVCFunctions.Concat(value, fileName); } else { value = MVCFunctions.Concat(value, file.Value["usrName"]); } continue; } if (XVar.Pack(!(XVar)(fieldIsUrl))) { if (XVar.Pack(!(XVar)(MVCFunctions.file_exists((XVar)(MVCFunctions.getabspath((XVar)(file.Value["name"]))))))) { continue; } } videoId = XVar.Clone(MVCFunctions.Concat("video_", MVCFunctions.GoodFieldName((XVar)(MVCFunctions.runner_htmlspecialchars((XVar)(this.field)))), "_")); videoId = MVCFunctions.Concat(videoId, getContainer().id, "_"); if ((XVar)(pageType != Constants.PAGE_ADD) && (XVar)(pageType != Constants.PAGE_EDIT)) { videoId = MVCFunctions.Concat(videoId, getContainer().recId); } else { videoId = MVCFunctions.Concat(videoId, MVCFunctions.postvalue(new XVar("id"))); } videoId = MVCFunctions.Concat(videoId, "_", counter++); if (XVar.Pack(fieldIsUrl)) { href = XVar.Clone(fileName); if (fileName != XVar.Pack("")) { dynamic ext = null, pos = null; pos = XVar.Clone(MVCFunctions.strrpos((XVar)(fileName), new XVar("."))); ext = XVar.Clone(MVCFunctions.substr((XVar)(fileName), (XVar)(pos))); var_type = XVar.Clone(CommonFunctions.getContentTypeByExtension((XVar)(ext))); if (var_type == "application/octet-stream") { var_type = new XVar("video/flv"); } } } else { dynamic userFile = XVar.Array(); userFile = XVar.Clone(this.upload_handler.buildUserFile((XVar)(file.Value))); href = XVar.Clone(userFile["url"]); if (XVar.Pack(!(XVar)(getContainer().pSet.isRewindEnabled((XVar)(this.field))))) { href = MVCFunctions.Concat(href, (XVar.Pack(XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(href), new XVar("?"))), XVar.Pack(false))) ? XVar.Pack("?") : XVar.Pack("&")), "norange=1"); } if (file.Value["type"] == "application/octet-stream") { var_type = new XVar("video/flv"); } else { var_type = XVar.Clone(file.Value["type"]); } } if (!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(var_type), new XVar("video"))), XVar.Pack(0))) { continue; } if (XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(href), new XVar("rndVal="))), XVar.Pack(false))) { href = MVCFunctions.Concat(href, (XVar.Pack(XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(href), new XVar("?"))), XVar.Pack(false))) ? XVar.Pack("?") : XVar.Pack("&")), "rndVal=", MVCFunctions.rand(new XVar(0), new XVar(99999999))); } else { dynamic endPos = null, startPos = null; startPos = XVar.Clone(MVCFunctions.strpos((XVar)(href), new XVar("rndVal=")) + 7); endPos = XVar.Clone(MVCFunctions.strpos((XVar)(href), new XVar("&"), (XVar)(startPos))); href = XVar.Clone(MVCFunctions.Concat(MVCFunctions.substr((XVar)(href), new XVar(0), (XVar)(startPos)), MVCFunctions.rand(new XVar(0), new XVar(99999999)), (XVar.Pack(endPos != -1) ? XVar.Pack(MVCFunctions.substr((XVar)(href), (XVar)(endPos))) : XVar.Pack("")))); } vWidth = XVar.Clone(getContainer().pSet.getVideoWidth((XVar)(this.field))); vHeight = XVar.Clone(getContainer().pSet.getVideoHeight((XVar)(this.field))); if (vWidth == XVar.Pack(0)) { vWidth = new XVar(300); } if (vHeight == XVar.Pack(0)) { vHeight = new XVar(200); } value = MVCFunctions.Concat(value, "<div style=\"width:", vWidth, "px; height:", vHeight, "px;\">\r\n\t\t\t\t\t<video class=\"projekktor\" width=\"", vWidth, "\" height=\"", vHeight, "\" id=\"", videoId, "\" type=\"", var_type, "\" src=\"", href, "\">\r\n\t\t\t\t\t</video></div>"); if (this.pageObject != null) { this.pageObject.controlsMap.InitAndSetArrayItem(videoId, "video", null); } } } return(value); }
protected virtual XVar prepareFields() { foreach (KeyValuePair <XVar, dynamic> field in this.pSet.getAdvSearchFields().GetEnumerator()) { dynamic ctrlBlockArr = XVar.Array(), ctrlInd = null, firstFieldParams = XVar.Array(), gfield = null, isFieldNeedSecCtrl = null, lookupTable = null, srchFields = XVar.Array(), srchTypeFull = null; gfield = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(field.Value))); lookupTable = XVar.Clone(this.pSet.getLookupTable((XVar)(field.Value))); if (XVar.Pack(lookupTable)) { this.settingsMap.InitAndSetArrayItem(CommonFunctions.GetTableURL((XVar)(lookupTable)), "globalSettings", "shortTNames", lookupTable); } fillFieldToolTips((XVar)(field.Value)); srchFields = XVar.Clone(this.searchClauseObj.getSearchCtrlParams((XVar)(field.Value))); firstFieldParams = XVar.Clone(XVar.Array()); if (XVar.Pack(MVCFunctions.count(srchFields))) { firstFieldParams = XVar.Clone(srchFields[0]); } else { firstFieldParams.InitAndSetArrayItem(field.Value, "fName"); firstFieldParams.InitAndSetArrayItem("", "eType"); firstFieldParams.InitAndSetArrayItem(this.pSet.getDefaultValue((XVar)(field.Value)), "value1"); firstFieldParams.InitAndSetArrayItem("", "value2"); firstFieldParams.InitAndSetArrayItem(false, "not"); firstFieldParams.InitAndSetArrayItem(this.pSet.getDefaultSearchOption((XVar)(field.Value)), "opt"); firstFieldParams.InitAndSetArrayItem(false, "not"); if (MVCFunctions.substr((XVar)(firstFieldParams["opt"]), new XVar(0), new XVar(4)) == "NOT ") { firstFieldParams.InitAndSetArrayItem(MVCFunctions.substr((XVar)(firstFieldParams["opt"]), new XVar(4)), "opt"); firstFieldParams.InitAndSetArrayItem(true, "not"); } } ctrlBlockArr = XVar.Clone(this.searchControlBuilder.buildSearchCtrlBlockArr((XVar)(this.id), (XVar)(firstFieldParams["fName"]), new XVar(0), (XVar)(firstFieldParams["opt"]), (XVar)(firstFieldParams["not"]), new XVar(false), (XVar)(firstFieldParams["value1"]), (XVar)(firstFieldParams["value2"]))); if (firstFieldParams["opt"] == "") { firstFieldParams.InitAndSetArrayItem(this.pSet.getDefaultSearchOption((XVar)(firstFieldParams["fName"])), "opt"); } srchTypeFull = XVar.Clone(this.searchControlBuilder.getCtrlSearchType((XVar)(firstFieldParams["fName"]), (XVar)(this.id), new XVar(0), (XVar)(firstFieldParams["opt"]), (XVar)(firstFieldParams["not"]), new XVar(true), new XVar(true))); if (XVar.Pack(this.is508)) { this.xt.assign_section((XVar)(MVCFunctions.Concat(gfield, "_label")), (XVar)(MVCFunctions.Concat("<label for=\"", getInputElementId((XVar)(field.Value), (XVar)(this.pSet)), "\">")), new XVar("</label>")); } else { this.xt.assign((XVar)(MVCFunctions.Concat(gfield, "_label")), new XVar(true)); } if (getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { dynamic firstElementId = null; firstElementId = XVar.Clone(getControl((XVar)(field.Value), (XVar)(this.id)).getFirstElementId()); if (XVar.Pack(firstElementId)) { this.xt.assign((XVar)(MVCFunctions.Concat("labelfor_", gfield)), (XVar)(firstElementId)); } } this.xt.assign((XVar)(MVCFunctions.Concat(gfield, "_fieldblock")), new XVar(true)); this.xt.assignbyref((XVar)(MVCFunctions.Concat(gfield, "_editcontrol")), (XVar)(ctrlBlockArr["searchcontrol"])); this.xt.assign((XVar)(MVCFunctions.Concat(gfield, "_notbox")), (XVar)(ctrlBlockArr["notbox"])); this.xt.assignbyref((XVar)(MVCFunctions.Concat(gfield, "_editcontrol1")), (XVar)(ctrlBlockArr["searchcontrol1"])); this.xt.assign((XVar)(MVCFunctions.Concat("searchtype_", gfield)), (XVar)(ctrlBlockArr["searchtype"])); this.xt.assign((XVar)(MVCFunctions.Concat("searchtypefull_", gfield)), (XVar)(srchTypeFull)); isFieldNeedSecCtrl = XVar.Clone(this.searchControlBuilder.isNeedSecondCtrl((XVar)(field.Value))); ctrlInd = new XVar(0); if (XVar.Pack(isFieldNeedSecCtrl)) { this.controlsMap.InitAndSetArrayItem(new XVar("fName", field.Value, "recId", this.id, "ctrlsMap", new XVar(0, ctrlInd, 1, ctrlInd + 1)), "search", "searchBlocks", null); ctrlInd += 2; } else { this.controlsMap.InitAndSetArrayItem(new XVar("fName", field.Value, "recId", this.id, "ctrlsMap", new XVar(0, ctrlInd)), "search", "searchBlocks", null); ctrlInd++; } } return(null); }
public virtual XVar displaySearchControl() { dynamic ctrlBlockArr = XVar.Array(), defaultValue = null, resArr = XVar.Array(); this.searchControlBuilder = XVar.Clone(new PanelSearchControl((XVar)(this.searchControllerId), (XVar)(this.tName), (XVar)(this.searchClauseObj), this)); defaultValue = XVar.Clone(this.pSet.getDefaultValue((XVar)(this.ctrlField))); ctrlBlockArr = XVar.Clone(this.searchControlBuilder.buildSearchCtrlBlockArr((XVar)(this.id), (XVar)(this.ctrlField), new XVar(0), new XVar(""), new XVar(false), new XVar(true), (XVar)(defaultValue), new XVar(""))); resArr = XVar.Clone(XVar.Array()); resArr.InitAndSetArrayItem(MVCFunctions.trim((XVar)(this.xt.call_func((XVar)(ctrlBlockArr["searchcontrol"])))), "control1"); resArr.InitAndSetArrayItem(MVCFunctions.trim((XVar)(this.xt.call_func((XVar)(ctrlBlockArr["searchcontrol1"])))), "control2"); resArr.InitAndSetArrayItem(MVCFunctions.trim((XVar)(ctrlBlockArr["searchtype"])), "comboHtml"); resArr.InitAndSetArrayItem(MVCFunctions.trim((XVar)(ctrlBlockArr["delCtrlButt"])), "delButt"); resArr.InitAndSetArrayItem(MVCFunctions.trim((XVar)(this.searchControlBuilder.getDelButtonId((XVar)(this.ctrlField), (XVar)(this.id)))), "delButtId"); resArr.InitAndSetArrayItem(MVCFunctions.trim((XVar)(this.id)), "divInd"); resArr.InitAndSetArrayItem(CommonFunctions.GetFieldLabel((XVar)(MVCFunctions.GoodFieldName((XVar)(this.tName))), (XVar)(MVCFunctions.GoodFieldName((XVar)(this.ctrlField)))), "fLabel"); resArr.InitAndSetArrayItem(this.controlsMap["controls"], "ctrlMap"); if (this.needSettings == "true") { fillSettings(); resArr.InitAndSetArrayItem(this.jsSettings, "settings"); } MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(resArr))); MVCFunctions.ob_flush(); HttpContext.Current.Response.End(); throw new RunnerInlineOutputException(); return(null); }
public virtual XVar preparePage() { dynamic fields = XVar.Array(), i = null, keylink = null, pageTypeTitle = null, tKeys = XVar.Array(); if ((XVar)(!(XVar)(this.masterRecordData)) || (XVar)(!(XVar)(MVCFunctions.count(this.masterRecordData)))) { return(null); } pageTypeTitle = XVar.Clone(this.pageType); if (this.masterPageType == "report") { pageTypeTitle = new XVar("masterprint"); } this.xt.assign(new XVar("pagetitlelabel"), (XVar)(getPageTitle((XVar)(pageTypeTitle), (XVar)(MVCFunctions.GoodFieldName((XVar)(this.tName))), (XVar)(this.masterRecordData)))); tKeys = XVar.Clone(this.pSet.getTableKeys()); keylink = new XVar(""); i = new XVar(0); for (; i < MVCFunctions.count(tKeys); i++) { keylink = MVCFunctions.Concat(keylink, "&key", i + 1, "=", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.RawUrlEncode((XVar)(this.masterRecordData[tKeys[i]]))))); } fields = XVar.Clone(this.pSet.getPageFields()); fields = XVar.Clone(MVCFunctions.array_merge((XVar)(fields), (XVar)(tKeys))); foreach (KeyValuePair <XVar, dynamic> f in fields.GetEnumerator()) { dynamic fieldClassStr = null, value = null; this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_fieldheader")), new XVar(true)); fieldClassStr = XVar.Clone(fieldClass((XVar)(f.Value))); value = XVar.Clone(showDBValue((XVar)(f.Value), (XVar)(this.masterRecordData), (XVar)(keylink))); if (XVar.Pack(pdfJsonMode())) { this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_pdfvalue")), (XVar)(value)); } else { dynamic wrappedValue = null; wrappedValue = XVar.Clone(MVCFunctions.Concat("<span class='", fieldClassStr, "'>", value, "</span>")); this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_mastervalue")), (XVar)(wrappedValue)); this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_value")), (XVar)(wrappedValue)); } this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_class")), (XVar)(fieldClassStr)); this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_fieldcolumn")), new XVar(true)); this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_fieldheadercolumn")), new XVar(true)); } this.xt.assign(new XVar("grid_header"), new XVar(true)); this.xt.assign(new XVar("grid_row"), new XVar(true)); this.xt.assign(new XVar("grid_record"), new XVar(true)); this.xt.assign(new XVar("grid_vrecord"), new XVar(true)); if (XVar.Pack(this.pageLayout)) { this.xt.assign(new XVar("pageattrs"), (XVar)(MVCFunctions.Concat("class=\"", this.pageLayout.style, " page-", this.pageLayout.name, "\""))); } if (XVar.Pack(!(XVar)(pdfJsonMode()))) { this.xt.load_template((XVar)(MVCFunctions.GetTemplateName((XVar)(this.shortTableName), (XVar)(this.pageType)))); } return(null); }
public XVar lookupsuggest() { try { dynamic LookupSQL = null, LookupSQLTable = null, LookupType = null, contextParams = XVar.Array(), data = XVar.Array(), displayFieldIndex = null, displayFieldName = null, displayedValue = null, field = null, isExistParent = null, likeConditionField = null, likeField = null, likeWheres = XVar.Array(), linkAndDisplaySame = null, linkFieldIndex = null, linkFieldName = null, lookupCipherer = null, lookupConnection = null, lookupField = null, lookupIndices = XVar.Array(), lookupOrderBy = null, lookupPSet = null, lookupQueryObj = null, lookupTable = null, lwDisplayField = null, masterTable = null, multiselect = null, pageType = null, parentCtrlsData = XVar.Array(), qResult = null, respObj = null, searchByLinkField = null, strLookupWhere = null, strUniqueOrderBy = null, table = null, value = null, values = XVar.Array(), var_response = XVar.Array(), viewContainer = null; MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); 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); pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType"))); GlobalVars.strTableName = XVar.Clone(CommonFunctions.GetTableByShort((XVar)(table))); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); GlobalVars.gSettings = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType), (XVar)(MVCFunctions.postvalue(new XVar("page"))))); field = XVar.Clone(MVCFunctions.postvalue(new XVar("searchField"))); if (GlobalVars.gSettings.getEntityType() == Constants.titDASHBOARD) { dynamic dashFields = XVar.Array(); dashFields = XVar.Clone(GlobalVars.gSettings.getDashboardSearchFields()); table = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(dashFields[field][0]["table"]))); GlobalVars.strTableName = XVar.Clone(CommonFunctions.GetTableByShort((XVar)(table))); field = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(dashFields[field][0]["field"]))); 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); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); GlobalVars.gSettings = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType))); } masterTable = XVar.Clone(MVCFunctions.postvalue(new XVar("masterTable"))); if ((XVar)(masterTable != XVar.Pack("")) && (XVar)(XSession.Session.KeyExists(MVCFunctions.Concat(masterTable, "_masterRecordData")))) { contextParams.InitAndSetArrayItem(XSession.Session[MVCFunctions.Concat(masterTable, "_masterRecordData")], "masterData"); } contextParams.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("data")))), "data"); RunnerContext.push((XVar)(new RunnerContextItem((XVar)(pageType), (XVar)(contextParams)))); if (GlobalVars.strTableName != "dbo.EMPLEADO") { if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } } else { dynamic checkResult = null, registerFields = null; checkResult = new XVar(true); registerFields = XVar.Clone((XVar.Pack(pageType == "register") ? XVar.Pack(GlobalVars.gSettings.getPageFields()) : XVar.Pack(XVar.Array()))); if (!XVar.Equals(XVar.Pack(MVCFunctions.array_search((XVar)(field), (XVar)(registerFields))), XVar.Pack(false))) { checkResult = new XVar(false); } if (XVar.Pack(checkResult)) { if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } } } isExistParent = XVar.Clone(MVCFunctions.postvalue(new XVar("isExistParent"))); searchByLinkField = XVar.Clone(MVCFunctions.postvalue(new XVar("searchByLinkField"))); parentCtrlsData = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData"))))); value = XVar.Clone(MVCFunctions.postvalue(new XVar("searchFor"))); values = XVar.Clone((XVar.Pack(MVCFunctions.postvalue(new XVar("multiselection"))) ? XVar.Pack(CommonFunctions.splitvalues((XVar)(value))) : XVar.Pack(new XVar(0, value)))); lookupField = new XVar(""); foreach (KeyValuePair <XVar, dynamic> f in GlobalVars.gSettings.getFieldsList().GetEnumerator()) { if ((XVar)(MVCFunctions.GoodFieldName((XVar)(f.Value)) == field) && (XVar)(GlobalVars.gSettings.getEditFormat((XVar)(f.Value)) == Constants.EDIT_FORMAT_LOOKUP_WIZARD)) { LookupType = XVar.Clone(GlobalVars.gSettings.getLookupType((XVar)(f.Value))); if ((XVar)(LookupType == Constants.LT_LOOKUPTABLE) || (XVar)(LookupType == Constants.LT_QUERY)) { lookupField = XVar.Clone(f.Value); break; } } } if (XVar.Pack(!(XVar)(lookupField))) { respObj = XVar.Clone(new XVar("success", false, "data", XVar.Array())); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } lookupTable = XVar.Clone(GlobalVars.gSettings.getLookupTable((XVar)(lookupField))); linkFieldName = XVar.Clone(GlobalVars.gSettings.getLinkField((XVar)(lookupField))); displayFieldName = XVar.Clone(GlobalVars.gSettings.getDisplayField((XVar)(lookupField))); linkAndDisplaySame = XVar.Clone(displayFieldName == linkFieldName); if (LookupType == Constants.LT_QUERY) { lookupConnection = XVar.Clone(GlobalVars.cman.byTable((XVar)(lookupTable))); } else { dynamic connId = null; connId = XVar.Clone(GlobalVars.gSettings.getNotProjectLookupTableConnId((XVar)(lookupField))); lookupConnection = XVar.Clone((XVar.Pack(MVCFunctions.strlen((XVar)(connId))) ? XVar.Pack(GlobalVars.cman.byId((XVar)(connId))) : XVar.Pack(GlobalVars.cman.getDefault()))); } lookupOrderBy = XVar.Clone(GlobalVars.gSettings.getLookupOrderBy((XVar)(lookupField))); if (lookupConnection.dbType == Constants.nDATABASE_MSSQLServer) { strUniqueOrderBy = XVar.Clone(lookupOrderBy); } if (LookupType == Constants.LT_QUERY) { lookupPSet = XVar.Clone(new ProjectSettings((XVar)(lookupTable), (XVar)(pageType))); lookupCipherer = XVar.Clone(new RunnerCipherer((XVar)(lookupTable))); lookupQueryObj = XVar.Clone(lookupPSet.getSQLQuery()); if (XVar.Pack(GlobalVars.gSettings.getCustomDisplay((XVar)(lookupField)))) { lookupQueryObj.AddCustomExpression((XVar)(displayFieldName), (XVar)(lookupPSet), (XVar)(GlobalVars.strTableName), (XVar)(lookupField)); } lookupQueryObj.ReplaceFieldsWithDummies((XVar)(lookupPSet.getBinaryFieldsIndices())); } else { dynamic lwLinkField = null; LookupSQLTable = new XVar("SELECT "); lwLinkField = XVar.Clone(lookupConnection.addFieldWrappers((XVar)(GlobalVars.gSettings.getLinkField((XVar)(lookupField))))); if (XVar.Pack(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) { LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, "DISTINCT "); } LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, GlobalVars.cipherer.GetLookupFieldName((XVar)(lwLinkField), (XVar)(lookupField), new XVar(null), new XVar(true))); if (lookupConnection.dbType == Constants.nDATABASE_MSSQLServer) { if ((XVar)(strUniqueOrderBy) && (XVar)(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) { LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, ",", lookupConnection.addFieldWrappers((XVar)(strUniqueOrderBy))); } } lwDisplayField = XVar.Clone(RunnerPage.sqlFormattedDisplayField((XVar)(lookupField), (XVar)(lookupConnection), (XVar)(GlobalVars.gSettings))); if (XVar.Pack(!(XVar)(linkAndDisplaySame))) { LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, ",", (XVar.Pack(lwDisplayField == lwLinkField) ? XVar.Pack(GlobalVars.cipherer.GetFieldName((XVar)(lwDisplayField), (XVar)(lookupField), new XVar(true))) : XVar.Pack(lwDisplayField))); } LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, " FROM ", lookupConnection.addTableWrappers((XVar)(lookupTable)), " "); } strLookupWhere = XVar.Clone(CommonFunctions.prepareLookupWhere((XVar)(lookupField), (XVar)(GlobalVars.gSettings))); if (LookupType == Constants.LT_QUERY) { dynamic secOpt = null; secOpt = XVar.Clone(lookupPSet.getAdvancedSecurityType()); if (secOpt == Constants.ADVSECURITY_VIEW_OWN) { strLookupWhere = XVar.Clone(CommonFunctions.whereAdd((XVar)(strLookupWhere), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(lookupTable))))); } } if (XVar.Pack(strLookupWhere)) { strLookupWhere = XVar.Clone(MVCFunctions.Concat(" (", strLookupWhere, ") AND ")); } if (LookupType == Constants.LT_QUERY) { if (XVar.Pack(GlobalVars.gSettings.getCustomDisplay((XVar)(lookupField)))) { likeField = XVar.Clone((XVar.Pack(searchByLinkField) ? XVar.Pack(linkFieldName) : XVar.Pack(displayFieldName))); } else { likeField = XVar.Clone(RunnerPage._getFieldSQLDecrypt((XVar)((XVar.Pack(searchByLinkField) ? XVar.Pack(linkFieldName) : XVar.Pack(displayFieldName))), (XVar)(lookupConnection), (XVar)(lookupPSet), (XVar)(GlobalVars.cipherer))); } } else { likeField = XVar.Clone(GlobalVars.cipherer.GetFieldName((XVar)(lwDisplayField), (XVar)(lookupField))); } if (XVar.Pack(searchByLinkField)) { likeConditionField = XVar.Clone((XVar.Pack(LookupType == Constants.LT_QUERY) ? XVar.Pack(linkFieldName) : XVar.Pack(lookupField))); } else { likeConditionField = XVar.Clone((XVar.Pack(LookupType == Constants.LT_QUERY) ? XVar.Pack(displayFieldName) : XVar.Pack(lookupField))); } likeWheres = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> fieldValue in values.GetEnumerator()) { if (fieldValue.Value == XVar.Pack("")) { continue; } if (LookupType == Constants.LT_QUERY) { likeWheres.InitAndSetArrayItem(MVCFunctions.Concat(likeField, lookupCipherer.GetLikeClause((XVar)(likeConditionField), (XVar)(fieldValue.Value))), null); } else { likeWheres.InitAndSetArrayItem(MVCFunctions.Concat(likeField, GlobalVars.cipherer.GetLikeClause((XVar)(likeConditionField), (XVar)(fieldValue.Value))), null); } } if (XVar.Pack(!(XVar)(MVCFunctions.count(likeWheres)))) { likeWheres.InitAndSetArrayItem("1=0", null); } strLookupWhere = MVCFunctions.Concat(strLookupWhere, MVCFunctions.implode(new XVar(" OR "), (XVar)(likeWheres))); if ((XVar)(isExistParent) && (XVar)(GlobalVars.gSettings.useCategory((XVar)(lookupField)))) { dynamic parentWhereParts = XVar.Array(); parentWhereParts = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> cData in GlobalVars.gSettings.getParentFieldsData((XVar)(lookupField)).GetEnumerator()) { dynamic arLookupWhere = XVar.Array(), category = null, lookupCategory = XVar.Array(); arLookupWhere = XVar.Clone(XVar.Array()); category = XVar.Clone(parentCtrlsData[cData.Value["main"]]); lookupCategory = XVar.Clone((XVar.Pack(category == XVar.Pack("")) ? XVar.Pack(XVar.Array()) : XVar.Pack(CommonFunctions.splitvalues((XVar)(category))))); foreach (KeyValuePair <XVar, dynamic> arLookupCategory in lookupCategory.GetEnumerator()) { dynamic catField = null, cvalue = null; cvalue = XVar.Clone(CommonFunctions.make_db_value((XVar)(cData.Value["main"]), (XVar)(arLookupCategory.Value))); if (XVar.Pack(lookupPSet)) { catField = XVar.Clone(RunnerPage._getFieldSQLDecrypt((XVar)(cData.Value["lookup"]), (XVar)(lookupConnection), (XVar)(lookupPSet), (XVar)(GlobalVars.cipherer))); } else { catField = XVar.Clone(lookupConnection.addFieldWrappers((XVar)(cData.Value["lookup"]))); } arLookupWhere.InitAndSetArrayItem(MVCFunctions.Concat(catField, "=", cvalue), null); } if (XVar.Pack(MVCFunctions.count(arLookupWhere))) { parentWhereParts.InitAndSetArrayItem(MVCFunctions.Concat("(", MVCFunctions.implode(new XVar(" OR "), (XVar)(arLookupWhere)), ")"), null); } } if (MVCFunctions.count(parentWhereParts) == MVCFunctions.count(GlobalVars.gSettings.getParentFieldsData((XVar)(lookupField)))) { strLookupWhere = XVar.Clone(CommonFunctions.whereAdd((XVar)(strLookupWhere), (XVar)(MVCFunctions.Concat("(", MVCFunctions.implode(new XVar(" AND "), (XVar)(parentWhereParts)), ")")))); } else { respObj = XVar.Clone(new XVar("success", false, "data", XVar.Array())); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } } if (XVar.Pack(MVCFunctions.strlen((XVar)(lookupOrderBy)))) { lookupOrderBy = XVar.Clone(lookupConnection.addFieldWrappers((XVar)(lookupOrderBy))); if (XVar.Pack(GlobalVars.gSettings.isLookupDesc((XVar)(lookupField)))) { lookupOrderBy = MVCFunctions.Concat(lookupOrderBy, " DESC"); } } if (LookupType == Constants.LT_QUERY) { LookupSQL = XVar.Clone(lookupQueryObj.buildSQL_default((XVar)(strLookupWhere))); if (XVar.Pack(MVCFunctions.strlen((XVar)(lookupOrderBy)))) { LookupSQL = MVCFunctions.Concat(LookupSQL, " ORDER BY ", lookupOrderBy); } else { LookupSQL = MVCFunctions.Concat(LookupSQL, lookupQueryObj.OrderByToSql()); } } else { LookupSQL = XVar.Clone(MVCFunctions.Concat(LookupSQLTable, " where ", strLookupWhere)); if ((XVar)(!(XVar)(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) || (XVar)(Constants.nDATABASE_Access != lookupConnection.dbType)) { if (XVar.Pack(lookupOrderBy)) { LookupSQL = MVCFunctions.Concat(LookupSQL, " ORDER BY ", lookupOrderBy); } } } lookupIndices = XVar.Clone(CommonFunctions.GetLookupFieldsIndexes((XVar)(GlobalVars.gSettings), (XVar)(lookupField))); linkFieldIndex = XVar.Clone(lookupIndices["linkFieldIndex"]); displayFieldIndex = XVar.Clone(lookupIndices["displayFieldIndex"]); viewContainer = XVar.Clone(new ViewControlsContainer((XVar)(GlobalVars.gSettings), new XVar(Constants.PAGE_LIST), new XVar(null))); var_response = XVar.Clone(XVar.Array()); qResult = XVar.Clone(lookupConnection.query((XVar)(LookupSQL))); multiselect = XVar.Clone(GlobalVars.gSettings.multiSelect((XVar)(lookupField))); while (XVar.Pack(data = XVar.Clone(qResult.fetchNumeric()))) { if ((XVar)(LookupType == Constants.LT_QUERY) && (XVar)(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) { dynamic uniqueArray = XVar.Array(); if (XVar.Pack(!(XVar)(uniqueArray as object != null))) { uniqueArray = XVar.Clone(XVar.Array()); } if (XVar.Pack(MVCFunctions.in_array((XVar)(data[displayFieldIndex]), (XVar)(uniqueArray)))) { continue; } uniqueArray.InitAndSetArrayItem(data[displayFieldIndex], null); } data.InitAndSetArrayItem(GlobalVars.cipherer.DecryptField((XVar)(lookupField), (XVar)(data[linkFieldIndex])), linkFieldIndex); if (LookupType == Constants.LT_QUERY) { data.InitAndSetArrayItem(GlobalVars.cipherer.DecryptField((XVar)(displayFieldName), (XVar)(data[displayFieldIndex])), displayFieldIndex); } displayedValue = XVar.Clone(data[displayFieldIndex]); if (XVar.Pack(MVCFunctions.in_array((XVar)(GlobalVars.gSettings.getViewFormat((XVar)(lookupField))), (XVar)(new XVar(0, Constants.FORMAT_DATE_SHORT, 1, Constants.FORMAT_DATE_LONG, 2, Constants.FORMAT_DATE_TIME))))) { dynamic ctrlData = XVar.Array(); ctrlData = XVar.Clone(XVar.Array()); ctrlData.InitAndSetArrayItem(data[linkFieldIndex], lookupField); displayedValue = XVar.Clone(viewContainer.getControl((XVar)(lookupField)).getTextValue((XVar)(ctrlData))); } var_response.InitAndSetArrayItem(data[linkFieldIndex], null); var_response.InitAndSetArrayItem(displayedValue, null); } respObj = XVar.Clone(new XVar("success", true, "data", MVCFunctions.array_slice((XVar)(var_response), new XVar(0), new XVar(40)))); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public override 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 alt = null, classString = null, controlWidth = null, dateEditType = null, dayStyle = null, dp = null, fmt = null, hasImgCal = null, initDayOpt = null, initMonthOpt = null, initYearOpt = null, monthStyle = null, ovalue = null, ovalue1 = null, ret = null, retday = null, retmonth = null, retyear = null, setHiddenElem = null, showTime = null, space = null, time = XVar.Array(), tvalue = null, yearStyle = null; ProjectSettings pSet; base.buildControl((XVar)(value), (XVar)(mode), (XVar)(fieldNum), (XVar)(validate), (XVar)(additionalCtrlParams), (XVar)(data)); if (XVar.Pack(fieldNum)) { this.cfield = XVar.Clone(MVCFunctions.Concat("value", fieldNum, "_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id)); } pSet = XVar.UnPackProjectSettings(getProjectSettings()); dateEditType = XVar.Clone(getDateEditType((XVar)(pSet))); MVCFunctions.Echo(MVCFunctions.Concat("<input id=\"", this.ctype, "\" type=\"hidden\" name=\"", this.ctype, "\" value=\"date", dateEditType, "\">")); tvalue = XVar.Clone(value); time = XVar.Clone(CommonFunctions.db2time((XVar)(tvalue))); if (XVar.Pack(!(XVar)(MVCFunctions.count(time)))) { time = XVar.Clone(new XVar(0, 0, 1, 0, 2, 0, 3, 0, 4, 0, 5, 0)); } classString = new XVar(""); if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { classString = new XVar(" form-control"); } dp = new XVar(0); hasImgCal = new XVar(true); showTime = XVar.Clone(pSet.dateEditShowTime((XVar)(this.field))); switch (((XVar)dateEditType).ToInt()) { case Constants.EDIT_DATE_SIMPLE_INLINE: case Constants.EDIT_DATE_SIMPLE_DP: if (dateEditType == Constants.EDIT_DATE_SIMPLE_INLINE) { hasImgCal = new XVar(false); } ovalue = XVar.Clone(value); if (GlobalVars.locale_info["LOCALE_IDATE"] == 1) { fmt = XVar.Clone(MVCFunctions.Concat("dd", GlobalVars.locale_info["LOCALE_SDATE"], "MM", GlobalVars.locale_info["LOCALE_SDATE"], "yyyy")); } else { if (GlobalVars.locale_info["LOCALE_IDATE"] == 0) { fmt = XVar.Clone(MVCFunctions.Concat("MM", GlobalVars.locale_info["LOCALE_SDATE"], "dd", GlobalVars.locale_info["LOCALE_SDATE"], "yyyy")); } else { fmt = XVar.Clone(MVCFunctions.Concat("yyyy", GlobalVars.locale_info["LOCALE_SDATE"], "MM", GlobalVars.locale_info["LOCALE_SDATE"], "dd")); } } if ((XVar)((XVar)((XVar)(showTime) || (XVar)(time[3])) || (XVar)(time[4])) || (XVar)(time[5])) { dynamic timeAttrs = null; timeAttrs = XVar.Clone(this.pageObject.pSetEdit.getFormatTimeAttrs((XVar)(this.field))); fmt = MVCFunctions.Concat(fmt, " ", GlobalVars.locale_info["LOCALE_STIMEFORMAT"]); } if (XVar.Pack(time[0])) { ovalue = XVar.Clone(CommonFunctions.format_datetime_custom((XVar)(time), (XVar)(fmt))); } ovalue1 = XVar.Clone(MVCFunctions.Concat(time[2], "-", time[1], "-", time[0])); if ((XVar)((XVar)((XVar)(showTime) || (XVar)(time[3])) || (XVar)(time[4])) || (XVar)(time[5])) { ovalue1 = MVCFunctions.Concat(ovalue1, " ", time[3], ":", time[4], ":", time[5]); } ret = XVar.Clone(MVCFunctions.Concat("<input ", getPlaceholderAttr(), " id=\"", this.cfield, "\" ", this.inputStyle, " class=\"", classString, "\" type=\"Text\" name=\"", this.cfield, "\" value=\"", ovalue, "\">")); ret = MVCFunctions.Concat(ret, "<input id=\"ts", this.cfield, "\" type=\"Hidden\" name=\"ts", this.cfield, "\" value=\"", ovalue1, "\">"); if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { ret = MVCFunctions.Concat(ret, "<span class=\"input-group-addon\" id=\"imgCal_", this.cfield, "\"><span class=\"glyphicon glyphicon-calendar\"></span></span>"); } else { if (XVar.Pack(hasImgCal)) { ret = MVCFunctions.Concat(ret, "<a href=\"#\" id=\"imgCal_", this.cfield, "\" data-icon=\"calendar\" title=\"Click Here to Pick up the date\"></a>"); } } if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { if (XVar.Pack(CommonFunctions.isRTL())) { ret = MVCFunctions.Concat(ret, "<span></span>"); } ret = XVar.Clone(MVCFunctions.Concat("<div class=\"input-group date\">", ret, "</div>")); } MVCFunctions.Echo(ret); break; case Constants.EDIT_DATE_DD_INLINE: case Constants.EDIT_DATE_DD_DP: case Constants.EDIT_DATE_DD: if ((dateEditType == Constants.EDIT_DATE_DD_INLINE) || (dateEditType == Constants.EDIT_DATE_DD_DP)) { dp = new XVar(1); } controlWidth = XVar.Clone(pSet.getControlWidth((XVar)(this.field))); if (XVar.Pack(0) < controlWidth) { dynamic dayWidth = null, mothWidth = null, yearWidth = null; controlWidth -= 10; yearWidth = XVar.Clone((XVar)Math.Floor((double)(controlWidth * 0.300000))); yearStyle = XVar.Clone(MVCFunctions.Concat("style=\"min-width: ", yearWidth, "px;margin-right:5px;\" ")); dayWidth = XVar.Clone((XVar)Math.Floor((double)(controlWidth * 0.200000))); dayStyle = XVar.Clone(MVCFunctions.Concat("style=\"min-width: ", dayWidth, "px; margin-right:5px;\" ")); mothWidth = XVar.Clone((controlWidth - yearWidth) - dayWidth); monthStyle = XVar.Clone(MVCFunctions.Concat("style=\"min-width: ", mothWidth, "px; margin-right:5px;\" ")); } else { dayStyle = new XVar(""); monthStyle = new XVar(""); yearStyle = new XVar(""); } alt = XVar.Clone(MVCFunctions.Concat("alt=\"", this.strLabel, "\" ")); initMonthOpt = new XVar("<option> </option>"); if (XVar.Pack(time[1])) { dynamic months = XVar.Array(); months = XVar.Clone(CommonFunctions.getMountNames()); initMonthOpt = XVar.Clone(MVCFunctions.Concat("<option>", months[time[1]], "</option>")); } initMonthOpt = MVCFunctions.Concat(initMonthOpt, "<option>", maxLengthMonth(), "</option>"); initDayOpt = XVar.Clone(MVCFunctions.Concat("<option>", (XVar.Pack(time[2]) ? XVar.Pack(time[2]) : XVar.Pack(" ")), " </option><option>22</option>")); initYearOpt = XVar.Clone(MVCFunctions.Concat("<option>", (XVar.Pack(time[0]) ? XVar.Pack(time[0]) : XVar.Pack(" ")), "</option><option>2000</option>")); retday = XVar.Clone(MVCFunctions.Concat("<select class=\"", classString, "\" id=\"day", this.cfield, "\" ", dayStyle, alt, "name=\"day", this.cfield, "\" >", initDayOpt, "</select>")); retmonth = XVar.Clone(MVCFunctions.Concat("<select class=\"", classString, "\" id=\"month", this.cfield, "\" ", monthStyle, alt, "name=\"month", this.cfield, "\" >", initMonthOpt, "</option></select>")); retyear = XVar.Clone(MVCFunctions.Concat("<select class=\"", classString, "\" id=\"year", this.cfield, "\" ", yearStyle, alt, "name=\"year", this.cfield, "\" >", initYearOpt, "</select>")); space = XVar.Clone((XVar.Pack(XVar.Pack(0) < controlWidth) ? XVar.Pack("") : XVar.Pack(" "))); if (GlobalVars.locale_info["LOCALE_ILONGDATE"] == 1) { ret = XVar.Clone(MVCFunctions.Concat(retday, space, retmonth, space, retyear)); } else { if (GlobalVars.locale_info["LOCALE_ILONGDATE"] == 0) { ret = XVar.Clone(MVCFunctions.Concat(retmonth, space, retday, space, retyear)); } else { ret = XVar.Clone(MVCFunctions.Concat(retyear, space, retmonth, space, retday)); } } setHiddenElem = new XVar("type=hidden"); if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { setHiddenElem = XVar.Clone(MVCFunctions.Concat("class=\"", classString, " hiddenPickerElement\"")); } if ((XVar)((XVar)(time[0]) && (XVar)(time[1])) && (XVar)(time[2])) { ret = MVCFunctions.Concat(ret, "<input id=\"", this.cfield, "\" ", setHiddenElem, " name=\"", this.cfield, "\" value=\"", time[0], "-", time[1], "-", time[2], "\">"); } else { ret = MVCFunctions.Concat(ret, "<input id=\"", this.cfield, "\" ", setHiddenElem, " name=\"", this.cfield, "\" value=\"\">"); } if (XVar.Pack(dp)) { if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { ret = MVCFunctions.Concat(ret, "<button class=\"btn btn-default\" id=\"imgCal_", this.cfield, "\" aria-hidden=true><span class=\"glyphicon glyphicon-calendar\" ></span></button>"); } else { ret = MVCFunctions.Concat(ret, "<a href=\"#\" id=\"imgCal_", this.cfield, "\" data-icon=\"calendar\" title=\"Click Here to Pick up the date\"></a>"); ret = MVCFunctions.Concat(ret, "<input id=\"ts", this.cfield, "\" type=hidden name=\"ts", this.cfield, "\" value=\"", time[2], "-", time[1], "-", time[0], "\">"); } } if (this.pageObject.getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT) { ret = XVar.Clone(MVCFunctions.Concat("<span class=\"bs-date-control form-inline\">", ret, "</span>")); } MVCFunctions.Echo(ret); break; default: ovalue = XVar.Clone(value); if (XVar.Pack(time[0])) { if ((XVar)((XVar)((XVar)(showTime) || (XVar)(time[3])) || (XVar)(time[4])) || (XVar)(time[5])) { ovalue = XVar.Clone(CommonFunctions.str_format_datetime((XVar)(time))); } else { ovalue = XVar.Clone(CommonFunctions.format_shortdate((XVar)(time))); } } MVCFunctions.Echo(MVCFunctions.Concat("<input ", getPlaceholderAttr(), " id=\"", this.cfield, "\" type=text class=\"", classString, "\" name=\"", this.cfield, "\" ", this.inputStyle, " value=\"", MVCFunctions.runner_htmlspecialchars((XVar)(ovalue)), "\">")); break; } buildControlEnd((XVar)(validate), (XVar)(mode)); return(null); }
public virtual XVar simpleSearchFieldCombo(dynamic _param_fNamesArr, dynamic _param_selOpt) { #region pass-by-value parameters dynamic fNamesArr = XVar.Clone(_param_fNamesArr); dynamic selOpt = XVar.Clone(_param_selOpt); #endregion dynamic options = null; options = new XVar(""); if (MVCFunctions.count(this.pSet.getGoogleLikeFields()) != 0) { options = XVar.Clone(MVCFunctions.Concat("<option value=\"\" >", "Any field", "</option>")); } foreach (KeyValuePair <XVar, dynamic> fName in fNamesArr.GetEnumerator()) { dynamic fLabel = null; fLabel = XVar.Clone(CommonFunctions.GetFieldLabel((XVar)(MVCFunctions.GoodFieldName((XVar)(this.tName))), (XVar)(MVCFunctions.GoodFieldName((XVar)(fName.Value))))); options = MVCFunctions.Concat(options, "<option value=\"", fName.Value, "\" ", (XVar.Pack(selOpt == fName.Value) ? XVar.Pack("selected") : XVar.Pack("")), ">", fLabel, "</option>"); } return(options); }
protected virtual XVar getPlaceholderAttr() { if ((XVar)(!(XVar)(this.searchPanelControl)) && (XVar)(this.container.pageType != Constants.PAGE_SEARCH)) { return(MVCFunctions.Concat(" placeholder=\"", CommonFunctions.GetFieldPlaceHolder((XVar)(MVCFunctions.GoodFieldName((XVar)(this.pageObject.tName))), (XVar)(MVCFunctions.GoodFieldName((XVar)(this.field)))), "\"")); } return(""); }
public virtual XVar buildSearchCtrlBlockArr(dynamic _param_recId, dynamic _param_fName, dynamic _param_ctrlInd, dynamic _param_opt, dynamic _param_not, dynamic _param_isChached, dynamic _param_val1, dynamic _param_val2, dynamic _param_panelField = null, dynamic _param_flexible = null, dynamic _param_immutable = null, dynamic _param_both = null) { #region default values if (_param_panelField as Object == null) { _param_panelField = new XVar(false); } if (_param_flexible as Object == null) { _param_flexible = new XVar(true); } if (_param_immutable as Object == null) { _param_immutable = new XVar(false); } if (_param_both as Object == null) { _param_both = new XVar(false); } #endregion #region pass-by-value parameters dynamic recId = XVar.Clone(_param_recId); dynamic fName = XVar.Clone(_param_fName); dynamic ctrlInd = XVar.Clone(_param_ctrlInd); dynamic opt = XVar.Clone(_param_opt); dynamic var_not = XVar.Clone(_param_not); dynamic isChached = XVar.Clone(_param_isChached); dynamic val1 = XVar.Clone(_param_val1); dynamic val2 = XVar.Clone(_param_val2); dynamic panelField = XVar.Clone(_param_panelField); dynamic flexible = XVar.Clone(_param_flexible); dynamic immutable = XVar.Clone(_param_immutable); dynamic both = XVar.Clone(_param_both); #endregion dynamic filterRowAttrs = null, filterRowId = null, postfix = null, renderHidden = null, srchCtrlBlock = XVar.Array(); srchCtrlBlock = XVar.Clone(XVar.Array()); postfix = new XVar(""); if (XVar.Pack(panelField)) { postfix = XVar.Clone(MVCFunctions.Concat("_", MVCFunctions.GoodFieldName((XVar)(fName)))); } if (opt == XVar.Pack("")) { opt = XVar.Clone(this.pSet.getDefaultSearchOption((XVar)(fName))); } renderHidden = XVar.Clone((XVar)(MVCFunctions.strtolower((XVar)(opt)) == "empty") || (XVar)(MVCFunctions.strtolower((XVar)(opt)) == "not empty")); srchCtrlBlock.InitAndSetArrayItem(getCtrlParamsArr((XVar)(fName), (XVar)(recId), (XVar)(ctrlInd), (XVar)(val1), (XVar)(opt), (XVar)(renderHidden), (XVar)(isChached)), MVCFunctions.Concat("searchcontrol", postfix)); renderHidden = XVar.Clone((XVar)(MVCFunctions.strtolower((XVar)(opt)) != "between") && (XVar)(MVCFunctions.strtolower((XVar)(opt)) != "not between")); if ((XVar)(flexible) || (XVar)(!(XVar)(renderHidden))) { srchCtrlBlock.InitAndSetArrayItem(getSecCtrlParamsArr((XVar)(fName), (XVar)(recId), (XVar)(ctrlInd), (XVar)(val2), (XVar)(opt), (XVar)(renderHidden), (XVar)(isChached)), MVCFunctions.Concat("searchcontrol1", postfix)); } if (XVar.Pack(!(XVar)(immutable))) { srchCtrlBlock.InitAndSetArrayItem(getDelButtonHtml((XVar)(fName), (XVar)(recId)), "delCtrlButt"); } filterRowId = XVar.Clone(getFilterRowId((XVar)(recId), (XVar)(fName))); filterRowAttrs = XVar.Clone(MVCFunctions.Concat("id=\"", filterRowId, "\" ")); if (XVar.Pack(isChached)) { filterRowAttrs = MVCFunctions.Concat(filterRowAttrs, this.dispNoneStyle); } srchCtrlBlock.InitAndSetArrayItem(filterRowAttrs, MVCFunctions.Concat("filterRow_attrs", postfix)); if (XVar.Pack(immutable)) { srchCtrlBlock.InitAndSetArrayItem("rnr-basic-search-field", MVCFunctions.Concat("filterRow_class", postfix)); } srchCtrlBlock.InitAndSetArrayItem(fName, "fName"); srchCtrlBlock.InitAndSetArrayItem(getCtrlSearchType((XVar)(fName), (XVar)(recId), (XVar)(ctrlInd), (XVar)(opt), (XVar)(var_not), (XVar)(flexible), (XVar)(both)), MVCFunctions.Concat("searchtype", postfix)); srchCtrlBlock.InitAndSetArrayItem(getNotBox((XVar)(fName), (XVar)(recId), (XVar)(var_not)), "notbox"); srchCtrlBlock.InitAndSetArrayItem(CommonFunctions.GetFieldLabel((XVar)(MVCFunctions.GoodFieldName((XVar)(this.tName))), (XVar)(MVCFunctions.GoodFieldName((XVar)(fName)))), MVCFunctions.Concat("fLabel", postfix)); return(srchCtrlBlock); }
public virtual XVar getDelButtonHtml(dynamic _param_fName, dynamic _param_recId) { #region pass-by-value parameters dynamic fName = XVar.Clone(_param_fName); dynamic recId = XVar.Clone(_param_recId); #endregion dynamic html = null, iconAttr = null, text = null; text = new XVar(""); iconAttr = new XVar("data-icon=\"remove\""); if (XVar.Pack(this.pageObj.isBootstrap())) { text = new XVar("<span class=\"glyphicon glyphicon-remove\"></span>"); iconAttr = new XVar(""); } html = XVar.Clone(MVCFunctions.Concat("<a id = \"", getDelButtonId((XVar)(fName), (XVar)(recId)), "\" ctrlId=\"", recId, "\" fName=\"", MVCFunctions.GoodFieldName((XVar)(fName)), "\" class=\"searchPanelButton searchpanel-options\" ", iconAttr, " href=\"#\" title=\"", "Borrar control", "\">", text, "</a>")); return(html); }
public virtual XVar preparePage() { dynamic fields = XVar.Array(), i = null, keylink = null, tKeys = XVar.Array(); if ((XVar)(!(XVar)(this.masterRecordData)) || (XVar)(!(XVar)(MVCFunctions.count(this.masterRecordData)))) { return(null); } this.xt.assign(new XVar("chart_block"), new XVar(true)); assignChartElement(); this.xt.assign(new XVar("pagetitlelabel"), (XVar)(getPageTitle((XVar)(this.pageType), (XVar)(MVCFunctions.GoodFieldName((XVar)(this.tName))), (XVar)(this.masterRecordData)))); tKeys = XVar.Clone(this.pSet.getTableKeys()); keylink = new XVar(""); i = new XVar(0); for (; i < MVCFunctions.count(tKeys); i++) { keylink = MVCFunctions.Concat(keylink, "&key", i + 1, "=", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.RawUrlEncode((XVar)(this.masterRecordData[tKeys[i]]))))); } fields = XVar.Clone(this.pSet.getMasterListFields()); fields = XVar.Clone(MVCFunctions.array_merge((XVar)(fields), (XVar)(tKeys))); foreach (KeyValuePair <XVar, dynamic> f in fields.GetEnumerator()) { dynamic fieldClassStr = null; fieldClassStr = XVar.Clone(fieldClass((XVar)(f.Value))); this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_mastervalue")), (XVar)(MVCFunctions.Concat("<span class='", fieldClassStr, "'>", showDBValue((XVar)(f.Value), (XVar)(this.masterRecordData), (XVar)(keylink)), "</span>"))); this.xt.assign((XVar)(MVCFunctions.Concat(MVCFunctions.GoodFieldName((XVar)(f.Value)), "_class")), (XVar)(fieldClassStr)); } if (XVar.Pack(this.pageLayout)) { this.xt.assign(new XVar("pageattrs"), (XVar)(MVCFunctions.Concat("class=\"", this.pageLayout.style, " page-", this.pageLayout.name, "\""))); } if (XVar.Pack(this.pageLayout)) { this.xt.assign(new XVar("pageattrs"), (XVar)(MVCFunctions.Concat("class=\"", this.pageLayout.style, " page-", this.pageLayout.name, "\""))); } this.xt.load_template((XVar)(MVCFunctions.GetTemplateName((XVar)(this.shortTableName), new XVar("masterchart")))); return(null); }
public override 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 disp = null, strfilename = null, strtype = null; base.buildControl((XVar)(value), (XVar)(mode), (XVar)(fieldNum), (XVar)(validate), (XVar)(additionalCtrlParams), (XVar)(data)); disp = new XVar(""); strfilename = new XVar(""); if ((XVar)(mode == Constants.MODE_EDIT) || (XVar)(mode == Constants.MODE_INLINE_EDIT)) { dynamic filename = null, itype = null; value = XVar.Clone(this.connection.stripSlashesBinary((XVar)(value))); itype = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(value))); if (XVar.Pack(itype)) { if (XVar.Pack(this.pageObject.pSetEdit.showThumbnail((XVar)(this.field)))) { disp = new XVar("<a target=_blank"); disp = MVCFunctions.Concat(disp, " href=\"", MVCFunctions.GetTableLink(new XVar("imager"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&", this.iquery, "&rndVal=", MVCFunctions.rand(new XVar(0), new XVar(32768))))), "\" class='zoombox'>"); disp = MVCFunctions.Concat(disp, "<img id=\"image_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id, "\" name=\"", this.cfield, "\" border=0"); if (XVar.Pack(this.is508)) { disp = MVCFunctions.Concat(disp, " alt=\"Image from DB\""); } disp = MVCFunctions.Concat(disp, " src=\"", MVCFunctions.GetTableLink(new XVar("imager"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&field=", MVCFunctions.RawUrlEncode((XVar)(this.pageObject.pSetEdit.getStrThumbnail((XVar)(this.field)))), "&alt=", MVCFunctions.RawUrlEncode((XVar)(this.field)), this.keylink, "&rndVal=", MVCFunctions.rand(new XVar(0), new XVar(32768))))), "\">"); disp = MVCFunctions.Concat(disp, "</a>"); } else { disp = XVar.Clone(MVCFunctions.Concat("<img id=\"image_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id, "\" name=\"", this.cfield, "\"")); if (XVar.Pack(this.is508)) { disp = MVCFunctions.Concat(disp, " alt=\"Image from DB\""); } disp = MVCFunctions.Concat(disp, " border=0 src=\"", MVCFunctions.GetTableLink(new XVar("imager"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&", this.iquery, "&src=1&rndVal=", MVCFunctions.rand(new XVar(0), new XVar(32768))))), "\">"); } } else { if (XVar.Pack(MVCFunctions.strlen((XVar)(value)))) { disp = XVar.Clone(MVCFunctions.Concat("<img id=\"image_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id, "\" name=\"", this.cfield, "\" border=0 ")); if (XVar.Pack(this.is508)) { disp = MVCFunctions.Concat(disp, " alt=\"file\""); } disp = MVCFunctions.Concat(disp, " src=\"", MVCFunctions.GetRootPathForResources(new XVar("images/file.gif")), "\">"); } } if ((XVar)((XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE) && (XVar)(!(XVar)(itype))) && (XVar)(MVCFunctions.strlen((XVar)(value)))) { if (XVar.Pack(!(XVar)(filename = XVar.Clone(data[this.pageObject.pSetEdit.getFilenameField((XVar)(this.field))])))) { filename = new XVar("file.bin"); } disp = XVar.Clone(MVCFunctions.Concat("<a href=\"", MVCFunctions.GetTableLink(new XVar("getfile"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&filename=", MVCFunctions.runner_htmlspecialchars((XVar)(filename)), "&pagename=", MVCFunctions.runner_htmlspecialchars((XVar)(this.pageObject.pSetEdit.pageName())), "&", this.iquery))), "\".>", disp, "</a>")); } if ((XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE) && (XVar)(this.pageObject.pSetEdit.getFilenameField((XVar)(this.field)))) { if (XVar.Pack(!(XVar)(filename = XVar.Clone(data[this.pageObject.pSetEdit.getFilenameField((XVar)(this.field))])))) { filename = new XVar(""); } if (mode == Constants.MODE_INLINE_EDIT) { strfilename = XVar.Clone(MVCFunctions.Concat("<br><label for=\"filename_", this.cfieldname, "\">", "Nombre de archivo", "</label> <input type=\"text\" ", this.inputStyle, " id=\"filename_", this.cfieldname, "\" name=\"filename_", this.cfieldname, "\" size=\"20\" maxlength=\"50\" value=\"", MVCFunctions.runner_htmlspecialchars((XVar)(filename)), "\">")); } else { strfilename = XVar.Clone(MVCFunctions.Concat("<br><label for=\"filename_", this.cfieldname, "\">", "Nombre de archivo", "</label> <input type=\"text\" ", this.inputStyle, " id=\"filename_", this.cfieldname, "\" name=\"filename_", this.cfieldname, "\" size=\"20\" maxlength=\"50\" value=\"", MVCFunctions.runner_htmlspecialchars((XVar)(filename)), "\">")); } } if (XVar.Pack(MVCFunctions.strlen((XVar)(value)))) { strtype = XVar.Clone(MVCFunctions.Concat("<br><input id=\"", this.ctype, "_keep\" type=\"Radio\" name=\"", this.ctype, "\" value=\"file0\" checked class=\"rnr-uploadtype\">", "Guardar")); if ((XVar)(MVCFunctions.strlen((XVar)(value))) && (XVar)(!(XVar)(this.pageObject.pSetEdit.isRequired((XVar)(this.field))))) { strtype = MVCFunctions.Concat(strtype, "<input id=\"", this.ctype, "_delete\" type=\"Radio\" name=\"", this.ctype, "\" value=\"file1\" class=\"rnr-uploadtype\">", "Borrar artÃculos seleccionados"); } strtype = MVCFunctions.Concat(strtype, "<input id=\"", this.ctype, "_update\" type=\"Radio\" name=\"", this.ctype, "\" value=\"file2\" class=\"rnr-uploadtype\">", "Actualizar"); } else { strtype = XVar.Clone(MVCFunctions.Concat("<input id=\"", this.ctype, "_update\" type=\"hidden\" name=\"", this.ctype, "\" value=\"file2\" class=\"rnr-uploadtype\">")); } } else { strtype = XVar.Clone(MVCFunctions.Concat("<input id=\"", this.ctype, "\" type=\"hidden\" name=\"", this.ctype, "\" value=\"file2\">")); if ((XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE) && (XVar)(this.pageObject.pSetEdit.getFilenameField((XVar)(this.field)))) { strfilename = XVar.Clone(MVCFunctions.Concat("<br><label for=\"filename_", this.cfieldname, "\">", "Nombre de archivo", "</label> <input type=\"text\" ", this.inputStyle, " id=\"filename_", this.cfieldname, "\" name=\"filename_", this.cfieldname, "\" size=\"20\" maxlength=\"50\">")); } } if ((XVar)(mode == Constants.MODE_INLINE_EDIT) && (XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE)) { disp = new XVar(""); } MVCFunctions.Echo(MVCFunctions.Concat(disp, strtype)); if ((XVar)((XVar)(mode == Constants.MODE_EDIT) || (XVar)(mode == Constants.MODE_INLINE_EDIT)) && (XVar)(MVCFunctions.strlen((XVar)(value)))) { MVCFunctions.Echo("<br>"); } MVCFunctions.Echo(MVCFunctions.Concat("<input type=\"File\" ", this.inputStyle, " id=\"", this.cfield, "\" ", (XVar.Pack((XVar)((XVar)(mode == Constants.MODE_INLINE_EDIT) || (XVar)(mode == Constants.MODE_INLINE_ADD)) && (XVar)(this.is508)) ? XVar.Pack(MVCFunctions.Concat("alt=\"", this.strLabel, "\" ")) : XVar.Pack("")), " name=\"", this.cfield, "\" >", strfilename)); MVCFunctions.Echo(MVCFunctions.Concat("<input type=\"Hidden\" id=\"notempty_", this.cfieldname, "\" value=\"", (XVar.Pack(MVCFunctions.strlen((XVar)(value))) ? XVar.Pack(1) : XVar.Pack(0)), "\">")); buildControlEnd((XVar)(validate), (XVar)(mode)); return(null); }