xml - SAPUI5 Table total row at bottom -

-


xml - SAPUI5 Table total row at bottom -

i using sap.ui.table display columns of data. there 12 rows of info - info loaded ajax phone call database. total row @ bottom of columns. can't find examples show totals columns.

here little snippet of table in xml view.

<table:table id="comprecs" visiblerowcount="12" visible="true" rows="{ path:'/yearinfo/' }" navigationmode="paginator"> <table:toolbar> <toolbar> <label id="rectext" text="comparing " ></label> <input id="startyear" width="15%" value="{/startyear}"/> <label id="seltext" text=" "></label> <input id="endyear" width="15%" value="{/endyear}"/> <button text="compare years" press="findrecs"/> </toolbar> </table:toolbar> <table:columns> <table:column > <label text="month" /> <table:template> <text text="{path: 'monthecc',formatter: 'controllers.formatter.month'}"></text> </table:template> </table:column> <table:column > <label text="classified products/components" /> <table:template> <text text="{classproductsa} ({classproductsb})"></text> </table:template> </table:column> <table:column > <label text="classified business partners" /> <table:template> <text text="{classpartnersa} ({classpartnersb})"></text> </table:template> </table:column> </table:columns> </table:table>

what have total @ bottom columns such classified products , partners....these columns showing 2 values - 1 current year, , 1 previous year ('classproductsa' = year 1, 'classproductsb' = year 2).

so should similar to:

month classified products classified partners jan 3 (5) 4 (7) feb 4 (3) 5 (1) totals: 7 (8) 9 (8)

i haven't found examples can try.

edit: sample data:

{"yearinfo": [{"monthecc":"1","classproductsa":"17","classproductsb":"140","classpartnersa":"1161","classpartnersb":"1116"}, {"monthecc":"2","classproductsa":"37","classproductsb":"66","classpartnersa":"1389","classpartnersb":"1112"}, {"monthecc":"3","classproductsa":"60","classproductsb":"66","classpartnersa":"2111","classpartnersb":"1905"}]

shows 3 'months' of info match xml columns above. want:

month classified products classified partners jan 17 (140) 1161 (1116) feb 37 (66) 66 (1389) march 60 (66) 2111 (1905) totals: 114 (272) 3338 (4410)

did seek writing footer table? breadcrumb illustration of table in ui5 explored project has code. have write footer aggregation. write count , have specify elements require parts , set formatter results. data, classproductsa total in label. here code in js. (too bad xml sure work same way)

var totallabel = new sap.m.label({ 'text': {path:'/yearinfo', formatter:function(fullarray){ var classproductsatotal = 0; $.each(fullarray ,function(singleelement){ classproductsatotal = classproductsatotal+singleelement.classproductsa; }); //end of $each. homecoming classproductsatotal; }});

the formatter function have for. path set /yearinfo mean give total array input formatter function .once there,you can loop total.

xml sapui5 totals

Comments

Post a Comment

Popular posts from this blog

Using Android Volley to post an array to PHP -

-
Using Android Volley to post an array to PHP - this how post values volley: @override protected map<string, string> getparams() { jsonobject jsonobjectmembers=new jsonobject(); (int i=0; i<arr_added_userids.size(); i++) { seek { jsonobjectmembers.put("params_"+i,arr_added_userids.get(i)); } grab (jsonexception e) { e.printstacktrace(); } } map<string, string> params = new hashmap<string, string>(); params.put("host", session_userid); params.put("params",jsonobjectmembers.tostring()); homecoming params; } this tried: foreach($_post['params'] $key => $value) { seek { $stmt = $conn->prepare("insert crewmembers (crewid, member) values (:crewid, :member)"); $query_params = array( ':crewid' => $crewid, ':member' => $value ); ...
Read more

python - How to add an model instance to a django queryset? -

-
python - How to add an model instance to a django queryset? - it seems django queryset behaves somehow python list. but doesn't back upwards list's .append() method know. what want like: from my_django_app.models import mymodel queryset = mymodel.objects.none() queryset.append(mymodel.objects.first()) ## no list's .append() method! is there way add together model instance existing queryset? no. queryset representation of query - hence name - not arbitrary collection of instances. if need actual queryset rather list, seek accumulating ids of objects need , getting objects via __in query: list_of_ids = [] list_of_ids.append(my_id) ... queryset = mymodel.objects.filter(id__in=list_of_ids) this isn't efficient, though. python django
Read more

angularjs - No 'Access-Control-Allow-Origin' error from local domain to public API -

-
angularjs - No 'Access-Control-Allow-Origin' error from local domain to public API - i'm trying create app retrieve stock name, asking , purchase cost yahoo finance api, using restangular. i'm having problem accessing public api in local application i'm creating when request. url parameters i'm sending: http://finance.yahoo.com/d/quotes.csv?s=msft+ge&f=nab using postman, request returns array contains stock name, asking cost , purchase cost of stock. doing request in postman returns desired info without errors. when request in local, next error: xmlhttprequest cannot load http://finance.yahoo.com/d/quotes.csv?s=msft+ge&f=nab. no 'access-control-allow-origin' header nowadays on requested resource. origin 'http://localhost' hence not allowed access. the html code follows: <html ng-app="app"> <head> <title>restangular</title> <script src="https://ajax.googleapis.com/ajax/li...
Read more