{ "layouts":[ { "data":{ "includeFiles":[ ], "metadata":{ "amiCustomCss":[ ".dot_large {\n", " height: 150px;\n", " width: 150px;\n", " background-color:#ececee;\n", " border-radius: 50%;\n", " border-color: #1AC44C;\n", " text-align: center;\n", " display: inline-block;\n", " padding: 50px 0;\n", " font-weight: bold;\n", " color:#1AC44C;\n", "}\n", "\n", ".dot_medium {\n", " height: 120px;\n", " width: 120px;\n", " background-color:#ececee;\n", " border-radius: 50%;\n", " border-color: #D70211;\n", " display: inline-block;\n", " text-align: center;\n", " padding: 40px 0;\n", " font-weight: bold;\n", " color: #D70211;\n", "}\n", "\n", ".dot_small {\n", " height: 90px;\n", " width: 90px;\n", " background-color:#ececee;\n", " border-radius: 50%;\n", " border-color: #3E92CC;\n", " display: inline-block;\n", " text-align: center;\n", " padding: 25px 0;\n", " font-weight: bold;\n", " color: #3E92CC;\n", "}\n", "\n", "/* Rainbow text */\n", ".public_rainbow-text {\n", " display: inline-block;\n", " background-image: linear-gradient(45deg, red, orange, yellow, green, blue, indigo, violet);\n", " background-clip: text;\n", " -webkit-background-clip: text;\n", " color: transparent;\n", " position: absolute;\n", "}\n", "\n", "\n", ".public_rainbow-marquee {\n", " white-space: nowrap;\n", " overflow: hidden;\n", " box-sizing: border-box;\n", " width: 100%;\n", " height: 100%; /* Adjust height as needed */\n", " background-size: 400% 400%;\n", " animation: public_rainbow-background 5s ease infinite;\n", " position: relative;\n", " transform: rotate(-2deg); /* Rotating the container 15 degrees to the left */\n", "}\n", " \n", "/* Rainbow background animation */\n", "@keyframes public_rainbow-background {\n", " 0% {\n", " background-position: 0% 50%;\n", " }\n", " 50% {\n", " background-position: 100% 50%;\n", " }\n", " 100% {\n", " background-position: 0% 50%;\n", " }\n", "}\n", "\n", "/* Rainbow gradient for the background */\n", ".public_rainbow-marquee {\n", " background-image: linear-gradient(45deg, red, orange, yellow, green, blue, indigo, violet);\n", "}" ], "customPrefsImportMode":"reject", "dm":{ "dms":[ { "callbacks":{ "entries":[ { "amiscript":[ "{\n", " CREATE TABLE accounts AS EXECUTE SELECT * FROM `accounts` WHERE ${WHERE};\n", "}\n" ], "defaultDs":"finance", "hasDatamodel":true, "linkedVariables":[ ], "name":"onProcess", "schema":{ "tbl":[ { "cols":[ { "nm":"id", "tp":"String" }, { "nm":"name", "tp":"String" } ], "nm":"accounts", "oc":"ask" } ] } } ] }, "datasources":[ "finance" ], "lbl":"accounts", "lower":[ ], "queryMode":"startup", "test_input_type":"OPEN", "test_input_vars":"String WHERE=\"true\";" }, { "callbacks":{ "entries":[ { "amiscript":[ "{\n", " CREATE TABLE orders AS SELECT * FROM orders WHERE ${WHERE};\n", "}\n" ], "hasDatamodel":true, "inputDm":[ "orders" ], "linkedVariables":[ ], "name":"onProcess", "schema":{ "tbl":[ { "cols":[ { "nm":"orders_id", "tp":"String" }, { "nm":"qty", "tp":"Integer" }, { "nm":"price", "tp":"Float" }, { "nm":"account_id", "tp":"String" }, { "nm":"side", "tp":"String" }, { "nm":"symbol", "tp":"String" }, { "nm":"status", "tp":"String" }, { "nm":"timestamp", "tp":"Integer" }, { "nm":"accounts_id", "tp":"String" }, { "nm":"name", "tp":"String" } ], "nm":"orders", "oc":"apply" } ] } } ] }, "lbl":"order_details", "lower":[ "orders" ], "test_input_type":"OPEN", "test_input_vars":"String WHERE=\"true\";" }, { "callbacks":{ "entries":[ { "amiscript":[ "{\n", " CREATE TABLE orders AS EXECUTE SELECT * FROM `orders` INNER JOIN `accounts` ON `orders`.account_id=`accounts`.id WHERE ${WHERE};\n", "\n", "\n", " \n", "}\n", "\n" ], "defaultDs":"finance", "hasDatamodel":true, "linkedVariables":[ { "ari":"FIELD:Html1?div1", "varName":"div1" }, { "ari":"FIELD:Html1?div2", "varName":"div2" }, { "ari":"FIELD:Html1?div3", "varName":"div3" }, { "ari":"FIELD:Html1?div4", "varName":"div4" }, { "ari":"FIELD:ThreeLargestOrders?order_top1", "varName":"order_top1" }, { "ari":"FIELD:ThreeLargestOrders?order_top2", "varName":"order_top2" }, { "ari":"FIELD:ThreeLargestOrders?order_top3", "varName":"order_top3" }, { "ari":"FIELD:Html1?top1button", "varName":"top1button" }, { "ari":"FIELD:Html1?top2button", "varName":"top2button" }, { "ari":"FIELD:Html1?top3button", "varName":"top3button" } ], "name":"onProcess", "schema":{ "tbl":[ { "cols":[ { "nm":"orders_id", "tp":"String" }, { "nm":"qty", "tp":"Integer" }, { "nm":"price", "tp":"Float" }, { "nm":"account_id", "tp":"String" }, { "nm":"side", "tp":"String" }, { "nm":"symbol", "tp":"String" }, { "nm":"status", "tp":"String" }, { "nm":"timestamp", "tp":"Integer" }, { "nm":"accounts_id", "tp":"String" }, { "nm":"name", "tp":"String" } ], "nm":"orders", "oc":"apply" } ] } } ] }, "datasources":[ "finance" ], "lbl":"orders", "lower":[ ], "test_input_type":"OPEN", "test_input_vars":"String WHERE=\"true\";" } ], "lnk":[ { "awcs":[ { "fl":"FALSE", "fo":"", "j":") or (", "pf":"((", "sf":"))", "to":"", "tr":"TRUE", "vn":"WHERE", "wh":"account_id = \"${Source_id}\"" } ], "callbacks":{ }, "op":7, "relid":"accounts_to_orders", "sdmadn":"accounts", "sdmtb":"accounts", "spadn":"accounts", "tdmadn":"orders", "title":"Show orders", "tpadn":"orders" }, { "awcs":[ { "fl":"FALSE", "fo":"", "j":") or (", "pf":"((", "sf":"))", "to":"", "tr":"TRUE", "vn":"WHERE", "wh":"account_id == \"${Source_account_id}\" && symbol == \"${Source_symbol}\"" } ], "callbacks":{ }, "op":7, "relid":"orders_to_order_details", "sdmadn":"orders", "sdmtb":"orders", "spadn":"orders", "tdmadn":"order_details", "title":"Show orders", "tpadn":"order_details" } ] }, "fileVersion":3, "menubarPosition":"top", "rt":{ }, "stm":{ "styles":[ { "id":"TOM", "lb":"Tom", "pt":"DEFAULT", "vl":{ "chart":{ "bgCl":"#ffffff", "divCl":"#707070", "divThckH":1.0, "divThckV":1.0, "selBoxBrdCl":"#bffff4", "selBoxCl":"#eaebff", "seriesCls":[ "#000000", "#8f98d8", "#d199e5", "#f977a7", "#bffff4" ] }, "global":{ "bgCl":"#444444", "btnBdrCl":"#848589", "btnBgCl":"#444444", "btnIconCl":"#ffffff", "btnShdwCl":"#000000", "deskBgCl":"#f4f4f4", "fontCl":"#ffffff", "menuBgCl":"#ffffff", "menuBorderBtmRtCl":"#969ae0", "menuBorderTpLfCl":"#bfc3ff", "menuDisBgCl":"#ebebed", "menuDisFontCl":"#aeaeb2", "menuDivCl":"#bfc3ff", "menuFontCl":"#000000", "menuHoverBgCl":"#cbd8fc", "menuHoverFontCl":"#000000", "titleBarBdrCl":"#babcdb", "winBgCl":"#444444", "winClBtmRt":"#000000", "winClTpLf":"#ecdef9", "winFontCl":"#ffffff", "winFontFam":"Segoe UI" }, "panel":{ "bgCl":"#ffffff", "bold":false, "cellBdrCl":"#ffffff", "fontCl":"#000000", "fontFam":"Segoe UI", "graybarCl":"#e5e5e8", "headerDivHide":true, "headerFontCl":"#000000", "italic":false, "pdBtmPx":10.0, "pdLfPx":5.0, "pdRtPx":4.0, "pdShadowCl":"#c4c5d3", "pdShadowHzPx":-2.0, "pdShadowSzPx":6.0, "pdShadowVtPx":3.0, "pdTpPx":6.0, "scrollBarHideArrows":true, "scrollBarRadius":"Rounded", "scrollBdrCl":"#ffffff", "scrollGripCl":"#a6aae0", "scrollTrackCl":"#e8e8e8", "scrollWd":8.0, "searchHide":true, "selCl":"#d5d4dd", "titlePnlFontFm":"Segoe UI" }, "table":{ "actCl":"#b2bff7", "cellBdrCl":"#c4c4c4", "cellBtmPx":1.0, "cellPadHt":6.0, "columnFilterHide":true, "headerBgCl":"#afb1cc", "headerDivHide":true, "headerFontCl":"#000000", "headerFontSz":14.0, "headerHt":25.0, "rowHt":71.0, "selCl":"#c5cff9", "vtAlign":"center" }, "tabs":{ "fontSz":12.0, "padTp":1.0, "rt":false, "selCl":"#6b6c6d", "selTxtCl":"#ffffff", "tabBdrCl":"#6b6b6b", "tabHt":29.0, "tabSelBdrCl":"#5f64ad", "tabSelBdrSz":2.0, "unselCl":"#444444", "unselTxtCl":"#a0a0a0", "vt":false }, "treegrid":{ "actCl":"#b1bff7", "cellBdrCl":"#cacace", "cellBtmPx":1.0, "columnFilterHide":true, "headerBarHide":false, "headerBgCl":"#afb1cc", "headerDivHide":true, "headerFontCl":"#000000", "headerHt":24.0, "rowHt":30.0, "selCl":"#c4cff9" } } }, { "id":"LAYOUT_DEFAULT", "lb":"Layout Default", "pt":"NOVA_LIGHT", "vl":{ "table":{ "actCl":"#89b582", "columnFilterHide":false, "graybarCl":"#dbdbdb", "headerBgCl":"#afb1cc", "headerDivHide":true, "headerHt":25.0, "rowHt":30.0, "vtAlign":"center" }, "treegrid":{ "actCl":"#89b582", "headerBgCl":"#afb1cc", "headerHt":25.0, "vtAlign":"center" } } }, { "id":"CLAIRESTYLE", "lb":"ClaireStyle", "pt":"DARK1" } ] }, "titleBarHtml":"My Dashboard", "transientIdPrefix":"TRANSIENT_" }, "portletConfigs":[ { "portletBuilderId":"amidesktop", "portletConfig":{ "amiPanelId":"@DESKTOP", "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "windows":[ { "header":true, "heightDflt":1216, "hidden":false, "leftDflt":15, "portlet":"Tabs1", "pos":0, "stateDflt":"flt", "title":"Order Explorer", "topDflt":24, "widthDflt":1230, "zindexDflt":1 } ] } }, { "portletBuilderId":"div", "portletConfig":{ "amiPanelId":"Div1", "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "child1":"accounts", "child2":"Div2", "dir":"v", "locked":false, "offset":0.24634, "upid":"Div1" } }, { "portletBuilderId":"div", "portletConfig":{ "amiPanelId":"Div2", "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "child1":"orders", "child2":"order_details", "dir":"h", "locked":false, "offset":0.47392, "upid":"Div2" } }, { "portletBuilderId":"tab", "portletConfig":{ "amiPanelId":"Tabs1", "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "defaultTab":"accounts_orders_tab", "tabs":[ { "child":"Div1", "id":"accounts_orders_tab", "nf":"\"Accounts and Orders\"" }, { "child":"order_details1", "id":"order_details_chart_tab", "nf":"\"Order Details Chart\"" } ], "upid":"Tabs1" } }, { "portletBuilderId":"amistatictable", "portletConfig":{ "amiCols":[ { "ei":"", "eof":"", "fm":"name", "fw":false, "hs":"", "id":"name", "lnd":0, "location":0, "tl":"Name", "tp":"text", "width":104 }, { "ei":"", "eof":"", "fm":"id.substring(0, 8) + \"...\"", "fw":false, "hs":"", "id":"id", "lnd":0, "location":1, "tl":"Account Id", "tooltip":"", "tp":"text", "width":78 }, { "id":"D", "width":100 } ], "amiPanelId":"accounts", "amiStyle":{ "columnFilterHide":true, "pt":"LAYOUT_DEFAULT" }, "amiTitle":"accounts", "curtimeUpdateFrequency":1000, "dm":[ { "dmadn":"accounts", "dmtbid":[ "accounts" ] } ], "dynamicColumns":"false", "editDblClk":true, "editInplace":false, "editMenuTitle":"Edit Row(s)", "editMode":0, "editRerunDM":true, "filters":{ }, "pinCnt":0, "rollupEnabled":false, "scrollToBottomOnAppend":false, "showCommandMenu":true, "showLastRuntime":true, "titlePnl":{ "title":"accounts" }, "upid":"accounts", "varTypes":{ "id":"String", "name":"String" } } }, { "portletBuilderId":"amistatictable", "portletConfig":{ "amiCols":[ { "ei":"", "eof":"", "fm":"((Long)timestamp)*1000", "fw":false, "hs":"", "id":"timestamp", "lnd":0, "location":0, "pc":0, "sy":"\"left\"", "tl":"Timestamp", "tooltip":"", "tp":"datetime_sec", "width":122 }, { "fm":"symbol", "fw":false, "id":"symbol", "lnd":0, "location":1, "tl":"Symbol", "tp":"text", "width":53 }, { "fm":"side", "fw":false, "id":"side", "lnd":0, "location":2, "tl":"Side", "tp":"text", "width":40 }, { "ei":"", "eof":"", "fm":"qty", "fw":false, "hs":"", "id":"qty", "lnd":0, "location":3, "pc":0, "tl":"Quantity", "tooltip":"", "tp":"numeric", "width":58 }, { "fm":"price", "fw":false, "id":"price", "lnd":0, "location":4, "tl":"Price", "tp":"numeric", "width":56 }, { "fm":"status", "fw":false, "id":"status", "lnd":0, "location":5, "tl":"Status", "tp":"text", "width":59 }, { "ei":"", "eof":"", "fm":"orders_id", "fw":false, "hs":"", "id":"id", "lnd":0, "location":6, "tl":"Id", "tooltip":"", "tp":"text", "width":258 }, { "fm":"account_id", "fw":false, "id":"account_id", "lnd":0, "location":7, "tl":"Account Id", "tp":"text", "width":247 }, { "id":"D", "width":100 } ], "amiPanelId":"order_details", "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "amiTitle":"orders", "curtimeUpdateFrequency":1000, "dm":[ { "dmadn":"order_details", "dmtbid":[ "orders" ] } ], "dynamicColumns":"false", "editDblClk":true, "editInplace":false, "editMenuTitle":"Edit Row(s)", "editMode":0, "editRerunDM":true, "filters":{ }, "pinCnt":0, "rollupEnabled":false, "scrollToBottomOnAppend":false, "showCommandMenu":true, "showLastRuntime":false, "sorting":[ { "id":"qty", "order":"dsc" } ], "titlePnl":{ "title":"orders" }, "upid":"order_details", "varTypes":{ "account_id":"String", "id":"String", "orders_id":"String", "price":"Float", "qty":"Integer", "side":"String", "status":"String", "symbol":"String", "timestamp":"Integer" } } }, { "portletBuilderId":"amichartgrid", "portletConfig":{ "amiPanelId":"order_details1", "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "amiTitle":"orders", "axisBcnts":[ 1 ], "axisConfig":{ "B_0_0":{ "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "autoMajorValue":true, "autoMaxValue":true, "autoMinValue":true, "autoMinorValue":true, "axisId":3, "fontStyle":"", "format":null, "formatType":1, "isGroupOrdered":true, "orientation":"T", "reverse":false, "title":"Timestamp" }, "L_0_0":{ "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "autoMajorValue":true, "autoMaxValue":true, "autoMinValue":true, "autoMinorValue":true, "axisId":2, "fontStyle":"", "format":null, "formatType":5, "isGroupOrdered":true, "orientation":"R", "reverse":true, "title":"Price" } }, "axisLcnts":[ 1 ], "axisRcnts":[ 0 ], "axisTcnts":[ 0 ], "colsCount":1, "dm":[ { "dmadn":"order_details", "dmtbid":[ "orders" ] } ], "mdivs":[ { "mdivs":[ { "mdivs":[ { "p":-1, "w":1.0 } ], "p":70, "w":1.0 }, { "p":-1, "w":1.0 } ], "p":-1, "w":1.0 }, { "mdivs":[ { "mdivs":[ { "p":-1, "w":1.0 } ], "p":70, "w":1.0 }, { "mdivs":[ { "p":-1, "w":1.0 } ], "p":-1, "w":1.0 } ], "p":70, "w":1.0 } ], "plotConfig":{ "0_0":{ "bgColor":"#fafafa", "layers":[ { "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "dmTableName":"orders", "dmadn":"order_details", "id":0, "layers":[ { "editorType":"2dLine", "id":4, "lineColor":{ "type":"series", "value":"__series_num" }, "lineSize":"2", "mBorderColor":{ "type":"series", "value":"__series_num" }, "mBorderSize":"1", "mColor":{ "type":"series", "value":"__series_num" }, "mHeight":"4", "mShape":"\"circle\"", "mWidth":"4", "name":"symbol + \"(\" + name + \")\"", "orderBy":"timestamp", "seriesName":"Layer", "tooltip":"symbol + \"(\" + name + \")\"+\"
\"+\"X: \"+formatNumber(((Long)timestamp)*1000, \"#.000\", \"\")+\"
Y: \"+formatNumber(price, \"#.000\", \"\")", "xPos":"((Long)timestamp)*1000", "yPos":"price" } ], "name":"Layer", "opac":100, "type":"Chart", "xAxisId":3, "yAxisId":2 }, { "amiStyle":{ "pt":"LAYOUT_DEFAULT" }, "id":5, "name":"Legend", "opac":100, "ser":[ 4 ], "type":"Legend" } ], "plotId":1, "selBoxBorderColor":"#7f7f7f7f", "selBoxFillColor":"#40404007", "selColor":"#bacbfb6e" } }, "rowsCount":1, "titlePnl":{ "title":"orders" }, "upid":"order_details1" } }, { "portletBuilderId":"amitree", "portletConfig":{ "amiPanelId":"orders", "amiStyle":{ "columnFilterHide":true, "pt":"LAYOUT_DEFAULT", "searchHide":true }, "amiTitle":"orders", "customMenu":[ { "callbacks":{ "entries":[ { "amiscript":"order_details_chart_tab.showTab();", "linkedVariables":[ { "ari":"TAB_ENTRY:Tabs1?order_details_chart_tab", "varName":"order_details_chart_tab" } ], "name":"onSelected" } ] }, "display":"\"View Chart\"", "icon":"", "id":"foreground_orders_chart", "position":0, "status":"\"enabled\"" } ], "dm":[ { "dmadn":"orders", "dmtbid":[ "orders" ] } ], "filters":{ }, "formulas":[ { "b":"", "c":"", "d":"name", "f":"account_id", "id":"accountId", "l":false, "o":"", "pg":"", "rb":"", "rc":"", "rs":"", "s":"" }, { "d":"symbol", "f":"symbol", "id":"symbol", "l":false }, { "d":"side", "f":"side", "id":"side", "l":false } ], "hcols":[ ], "pins":2, "rn":null, "sm":1, "tcoln":"", "tcolw":200, "titlePnl":{ "title":"orders" }, "upid":"orders", "varTypes":{ "account_id":"String", "name":"String", "price":"Float", "qty":"Integer", "side":"String", "symbol":"String" }, "vcols":[ { "b":"", "c":"", "d":"count(1)", "h":"", "hs":"", "i":1, "id":"count", "n":"Order Count", "o":"", "pc":0, "s":"", "w":100, "y":"numeric" }, { "b":"", "c":"", "d":"sum(qty)", "h":"", "hs":"", "i":2, "id":"qty", "n":"Total Quantity", "o":"", "pc":0, "s":"", "w":100, "y":"numeric" }, { "b":"", "c":"", "d":"max(price)", "h":"", "hs":"", "i":3, "id":"price", "n":"Max Price", "o":"", "s":"", "w":100, "y":"numeric" }, { "d":"min(price)", "i":4, "id":"minPrice", "n":"Min Price", "w":100, "y":"text" } ] } } ] }, "location":"styling2_startpoint.ami", "type":"LOCAL" } ], "rootLayout":{ "location":"styling2_startpoint.ami", "type":"LOCAL" } }