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("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, "\""))); } this.xt.load_template((XVar)(MVCFunctions.GetTemplateName((XVar)(this.shortTableName), (XVar)(MVCFunctions.Concat("master", this.masterPageType))))); 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 ActionResult detailspreview() { try { dynamic masterKeys = XVar.Array(), mastertable = null, mode = null, pageObject = null, query = null, recordsCounter = null, returnJSON = XVar.Array(), rowcount = null, sessionPrefix = null, var_params = XVar.Array(), whereClauses = XVar.Array(); ProjectSettings pSet; XTempl xt; dbo__ABCVotes_Variables.Apply(); MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); mode = XVar.Clone(MVCFunctions.postvalue(new XVar("mode"))); if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); xt = XVar.UnPackXTempl(new XTempl()); { TLayout t_layout = null; t_layout = new TLayout(new XVar("detailspreview"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["bare"] = XVar.Array(); t_layout.containers["dcount"] = XVar.Array(); t_layout.containers["dcount"].Add(new XVar("name", "detailspreviewheader", "block", "", "substyle", 1)); t_layout.containers["dcount"].Add(new XVar("name", "detailspreviewdetailsfount", "block", "", "substyle", 1)); t_layout.containers["dcount"].Add(new XVar("name", "detailspreviewdispfirst", "block", "display_first", "substyle", 1)); t_layout.skins["dcount"] = "empty"; t_layout.blocks["bare"].Add("dcount"); t_layout.containers["detailspreviewgrid"] = XVar.Array(); t_layout.containers["detailspreviewgrid"].Add(new XVar("name", "detailspreviewfields", "block", "details_data", "substyle", 1)); t_layout.skins["detailspreviewgrid"] = "grid"; t_layout.blocks["bare"].Add("detailspreviewgrid"); GlobalVars.page_layouts["dbo__ABCVotes_detailspreview"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } recordsCounter = new XVar(0); mastertable = XVar.Clone(MVCFunctions.postvalue(new XVar("mastertable"))); masterKeys = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("masterKeys"))))); sessionPrefix = new XVar("_detailsPreview"); if (mastertable != XVar.Pack("")) { dynamic i = null; XSession.Session[MVCFunctions.Concat(sessionPrefix, "_mastertable")] = mastertable; i = new XVar(1); if ((XVar)(MVCFunctions.is_array((XVar)(masterKeys))) && (XVar)(0 < MVCFunctions.count(masterKeys))) { while (XVar.Pack(masterKeys.KeyExists(MVCFunctions.Concat("masterkey", i)))) { XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey", i)] = masterKeys[MVCFunctions.Concat("masterkey", i)]; i++; } } if (XVar.Pack(XSession.Session.KeyExists(MVCFunctions.Concat(sessionPrefix, "_masterkey", i)))) { XSession.Session.Remove(MVCFunctions.Concat(sessionPrefix, "_masterkey", i)); } } else { mastertable = XVar.Clone(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_mastertable")]); } var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(1, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem("detailspreview", "pageType"); GlobalVars.pageObject = XVar.Clone(new DetailsPreview((XVar)(var_params))); pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), new XVar(Constants.PAGE_LIST))); whereClauses = XVar.Clone(XVar.Array()); if (mastertable == "dbo._ABCReports") { dynamic formattedValue = null; formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")]))); if (formattedValue == "null") { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null); } else { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null); } } if (mastertable == "ABC_Voting_Submitted") { dynamic formattedValue = null; formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")]))); if (formattedValue == "null") { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null); } else { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null); } } if (mastertable == "ABC_Voting_Recirculated") { dynamic formattedValue = null; formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")]))); if (formattedValue == "null") { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null); } else { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null); } } if (mastertable == "ABC_Voting_My_Voting") { dynamic formattedValue = null; formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")]))); if (formattedValue == "null") { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null); } else { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null); } } if (mastertable == "dbo.vwABCReportsVoteCount") { dynamic formattedValue = null; formattedValue = XVar.Clone(CommonFunctions.make_db_value(new XVar("record"), (XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_masterkey1")]))); if (formattedValue == "null") { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), " is null"), null); } else { whereClauses.InitAndSetArrayItem(MVCFunctions.Concat(GlobalVars.pageObject.getFieldSQLDecrypt(new XVar("record")), "=", formattedValue), null); } } whereClauses.InitAndSetArrayItem(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(GlobalVars.strTableName)), null); query = XVar.Clone(pSet.getSQLQuery()); GlobalVars.strSQL = XVar.Clone(query.buildSQL_default((XVar)(whereClauses))); rowcount = XVar.Clone(GlobalVars.pageObject.connection.getFetchedRowsNumber((XVar)(GlobalVars.strSQL))); GlobalVars.strSQL = MVCFunctions.Concat(GlobalVars.strSQL, GlobalVars.pageObject.getOrderByClause()); xt.assign(new XVar("row_count"), (XVar)(rowcount)); if (XVar.Pack(rowcount)) { dynamic b = null, data = XVar.Array(), display_count = null, format = null, keylink = null, qResult = null, row = XVar.Array(), rowinfo = XVar.Array(), rowinfo2 = XVar.Array(), value = null, var_class = null, viewContainer = null; xt.assign(new XVar("details_data"), new XVar(true)); display_count = new XVar(10); if (mode == "inline") { display_count *= 2; } if (display_count + 2 < rowcount) { xt.assign(new XVar("display_first"), new XVar(true)); xt.assign(new XVar("display_count"), (XVar)(display_count)); } else { display_count = XVar.Clone(rowcount); } rowinfo = XVar.Clone(XVar.Array()); viewContainer = XVar.Clone(new ViewControlsContainer((XVar)(pSet), new XVar(Constants.PAGE_LIST))); viewContainer.isDetailsPreview = new XVar(true); b = new XVar(true); qResult = XVar.Clone(GlobalVars.pageObject.connection.query((XVar)(GlobalVars.strSQL))); data = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc()))); while ((XVar)(data) && (XVar)(recordsCounter < display_count)) { recordsCounter++; row = XVar.Clone(XVar.Array()); keylink = new XVar(""); keylink = MVCFunctions.Concat(keylink, "&key1=", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.RawUrlEncode((XVar)(data["id"]))))); keylink = MVCFunctions.Concat(keylink, "&key2=", MVCFunctions.runner_htmlspecialchars((XVar)(MVCFunctions.RawUrlEncode((XVar)(data["record"]))))); viewContainer.recId = XVar.Clone(recordsCounter); value = XVar.Clone(viewContainer.showDBValue(new XVar("committee_member"), (XVar)(data), (XVar)(keylink))); row.InitAndSetArrayItem(value, "committee_member_value"); format = XVar.Clone(pSet.getViewFormat(new XVar("committee_member"))); var_class = new XVar("rnr-field-text"); if (format == Constants.FORMAT_FILE) { var_class = new XVar(" rnr-field-file"); } if (format == Constants.FORMAT_AUDIO) { var_class = new XVar(" rnr-field-audio"); } if (format == Constants.FORMAT_CHECKBOX) { var_class = new XVar(" rnr-field-checkbox"); } if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("committee_member")))))) { var_class = new XVar(" rnr-field-number"); } row.InitAndSetArrayItem(var_class, "committee_member_class"); viewContainer.recId = XVar.Clone(recordsCounter); value = XVar.Clone(viewContainer.showDBValue(new XVar("date_voted"), (XVar)(data), (XVar)(keylink))); row.InitAndSetArrayItem(value, "date_voted_value"); format = XVar.Clone(pSet.getViewFormat(new XVar("date_voted"))); var_class = new XVar("rnr-field-text"); if (format == Constants.FORMAT_FILE) { var_class = new XVar(" rnr-field-file"); } if (format == Constants.FORMAT_AUDIO) { var_class = new XVar(" rnr-field-audio"); } if (format == Constants.FORMAT_CHECKBOX) { var_class = new XVar(" rnr-field-checkbox"); } if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("date_voted")))))) { var_class = new XVar(" rnr-field-number"); } row.InitAndSetArrayItem(var_class, "date_voted_class"); viewContainer.recId = XVar.Clone(recordsCounter); value = XVar.Clone(viewContainer.showDBValue(new XVar("vote"), (XVar)(data), (XVar)(keylink))); row.InitAndSetArrayItem(value, "vote_value"); format = XVar.Clone(pSet.getViewFormat(new XVar("vote"))); var_class = new XVar("rnr-field-text"); if (format == Constants.FORMAT_FILE) { var_class = new XVar(" rnr-field-file"); } if (format == Constants.FORMAT_AUDIO) { var_class = new XVar(" rnr-field-audio"); } if (format == Constants.FORMAT_CHECKBOX) { var_class = new XVar(" rnr-field-checkbox"); } if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("vote")))))) { var_class = new XVar(" rnr-field-number"); } row.InitAndSetArrayItem(var_class, "vote_class"); viewContainer.recId = XVar.Clone(recordsCounter); value = XVar.Clone(viewContainer.showDBValue(new XVar("comment"), (XVar)(data), (XVar)(keylink))); row.InitAndSetArrayItem(value, "comment_value"); format = XVar.Clone(pSet.getViewFormat(new XVar("comment"))); var_class = new XVar("rnr-field-text"); if (format == Constants.FORMAT_FILE) { var_class = new XVar(" rnr-field-file"); } if (format == Constants.FORMAT_AUDIO) { var_class = new XVar(" rnr-field-audio"); } if (format == Constants.FORMAT_CHECKBOX) { var_class = new XVar(" rnr-field-checkbox"); } if ((XVar)(format == Constants.FORMAT_NUMBER) || (XVar)(CommonFunctions.IsNumberType((XVar)(pSet.getFieldType(new XVar("comment")))))) { var_class = new XVar(" rnr-field-number"); } row.InitAndSetArrayItem(var_class, "comment_class"); rowinfo.InitAndSetArrayItem(row, null); if (XVar.Pack(b)) { rowinfo2.InitAndSetArrayItem(row, null); b = new XVar(false); } data = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc()))); } xt.assign_loopsection(new XVar("details_row"), (XVar)(rowinfo)); xt.assign_loopsection(new XVar("details_row_header"), (XVar)(rowinfo2)); } returnJSON = XVar.Clone(new XVar("success", true)); xt.load_template((XVar)(MVCFunctions.GetTemplateName(new XVar("dbo__ABCVotes"), new XVar("detailspreview")))); returnJSON.InitAndSetArrayItem(xt.fetch_loaded(), "body"); if (mode != "inline") { dynamic layout = null; returnJSON.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("counter")), "counter"); layout = XVar.Clone(CommonFunctions.GetPageLayout((XVar)(MVCFunctions.GoodFieldName((XVar)(GlobalVars.strTableName))), new XVar("detailspreview"))); if (XVar.Pack(layout)) { foreach (KeyValuePair <XVar, dynamic> css in layout.getCSSFiles((XVar)(CommonFunctions.isRTL()), (XVar)((XVar)(CommonFunctions.mobileDeviceDetected()) && (XVar)(layout.version != Constants.BOOTSTRAP_LAYOUT))).GetEnumerator()) { returnJSON.InitAndSetArrayItem(css.Value, "CSSFiles", null); } } } MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }