How do I retrieve data from database? (SAPUI5) -

-

the graph shown want achieve (i hard-coded values)

in database, status has 1 of 3 possible category values: pending, available , completed

this think logic is:

  • delivery request (count(reqid))
  • fulfilled (status= completed)
  • notfulfilled (status=pending + available)

enter image description here

i want retrieve values database , have. now, can display bar indicates delivery request. (however 2 lines not showing.)

enter image description here

the following section of code xml file:

    <mvc:view              controllername "sap.ui.urbanlogi.backoffice.controller.linechart"             xmlns = "sap.m"             xmlns:core = "sap.ui.core"             xmlns:form="sap.ui.layout.form"             xmlns:mvc = "sap.ui.core.mvc"             xmlns:l= "sap.ui.layout"             displayblock = "true" >              <app>                 <page title = "total delivery request">                          <panel id = "idlinechart"></panel>                     <list id='idlist' headertext="selected items" items="{/}">                         <standardlistitem title="status: {status}"                          description=" total number of delivery request: {reqid}" />                     </list>                 </page>             </app>         </mvc:view>

the following section of code controller:

       sap.ui.controller("sap.ui.urbanlogi.backoffice.controller.linechart", {             oninit: function () {                    this.opage = this.byid("idlinechart");                        var ojsonmodel = new sap.ui.model.json.jsonmodel("http://lssinh000.sin3.sap.corp:8000/sap_le/lionexpress/volunteer/services/request.xsjs");                  ojsonmodel.setdata("http://lssinh000.sin3.sap.corp:8000/sap_le/lionexpress/volunteer/services/request.xsjs", true);                 ojsonmodel.setdata("http://lssinh000.sin3.sap.corp:8000/sap_le/lionexpress/volunteer/services/request.xsjs", true);                  this.opage.setmodel(ojsonmodel);                  var dataset = new sap.viz.ui5.data.flatteneddataset({                     dimensions: [{                         axis: 1,                         name: 'date',                         value: "{startdate}"                     }],                     measures: [{                         group: 1,                         name: 'deliveryrequest',                         value: '{reqid}'                     }, {                         group: 2,                         name: 'fulfilled',                         value: '{status}'                     },{                         group: 2,                         name: 'notfulfill',                         value: '{status}'                     }],                     data: {                         path: "/status"                     }                 });                  var combination = new sap.viz.ui5.dualcombination({                     width: "100%",                     height: "400px",                     title: {                         visible: true,                         text: 'delivery request'                     },                     dataset: dataset                 });                     this.opage.addcontent(combination);                },                    onselect: function(oevent) {                     var aselections = oevent.getparameter("data");                     var omodel = this.getview().byid('idlist').getmodel();                     (var = 0; < aselections.length; i++) {                       this._selecteddata.push(aselections[i].data);                     };                     omodel.refresh();                   },                    ondeselect: function(oevent) {                     var aselections = oevent.getparameter("data");                     var omodel = this.getview().byid('idlist').getmodel();                     (var = 0; < aselections.length; i++) {                       (var j = 0; j < omodel.getdata().length; j++) {                         if (omodel.getdata()[j] === aselections[i].data) {                           omodel.getdata().splice(j, 1);                           break;                         }                       };                     };                     omodel.refresh();                  }          });

would appreciate if me out here because reason can't :( i'm still pretty new sapui5 , first program i'm building i'm facing lot of errors.


Comments

Post a Comment

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

-
i trying display records table named staffpresentee database using clause... i using visual studio 2010... the table design follows- .......fieldname..................datatype........allownull 1......staff_id (fk).............numeric(18,0)......yes 2.......date........................date.............no 3......present.....................char(1)..........yes note type of 2nd field date , not datetime... i want display records table have today's date int 'date' field... current query is- cmd = new sqlclient.sqlcommand("select * staffpresentee date=" & date.now.date, cn) dr = cmd.executereader for dr = cmd.executereader error "operand type clash: date incompatible int" i tried select * staffpresentee query without clause runs correctly. try putting date value in sigle quotes maybe. cmd = new sqlclient.sqlcommand("select * staffpresentee date='" & _
Read more

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that?
Read more

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -

-
here code im = cv2.imread('luffy.jpg') gray = cv2.cvtcolor(im,cv2.color_bgr2gray) ret,thresh = cv2.threshold(gray,127,255,0) contours,h = cv2.findcontours(thresh,cv2.retr_tree,cv2.chain_approx_simple) cnt in contours: moment = cv2.moments(cnt) c_y = moment['m10']/(moment['m00']+0.01) c_x = moment['m01']/(moment['m00']+0.01) centroid_color = im[c_x,c_y] centroid_color = np.array((centroid_color[0],centroid_color[1],centroid_color[2])) print type(centroid_color) cv2.fillpoly(im,cnt,centroid_color) i getting error on last line try , pass centroid_color color argument. <type 'numpy.ndarray'> , have been able pass data type cv2.fillpoly color in other instances, not sure why having problem here. fillpoly() expects iterable, i.e. put cnt in brackets. believe duplicate of https://stackoverflow.com/a/17582850/5818240 . moreover, centroid color variable contains strings. need convert them i
Read more