Creating and populating an array with a fixed width in JavaScript -

-

i've got input array in format:

[[timestamp, jobid, time completion],[..]]

the data sql db, grouped both timestamp, , jobid, array looks like:

[   [1, 30, 400],   [1, 31, 200],   [2, 29, 300],   ..   ]

i create new array 1 column every jobid, instead of 1 row every job id, is, single row per timestamp.

so, wrote code iterated through above array, , populated new array, simple enough, except, result array isn't fixed width, is, result looks like:

[   [1, 400, 200],   [2, 300]   ..   ]

which makes impossible me values [1] job id 30, can't have meaningful header row. is, data in format: 

timestamp, jobid29, jobid30, jobid31   [   [1, 0, 400, 200],   [2, 300, 0, 0],   ..   ]

i can't output map, unfortunately.

how can achieve this? know i'll haveto go through input once distinct jobids, , guess i'd map each jobid position, etc, i'm wondering if best way?

thank you.

my solution uses 2 arrays , 2 maps plenty of possibilities optimizations. here's rough sketch:

  1. sort array jobid. (let's call "joblist")

  2. keep "map" keyed on unique timestamps. ("timestampmap"). map should contain 1 entry each unique timestamp.

  3. keep array of unique timestamps , sort it. ("timelist")

  4. each item in "timestampmap" keeps map of jobs on timestamp value

  5. iterate on each value in timestamp list.

    within each iteration, iterate on each job in joblist. if job in corresponding timestamp map output job.completiontime

    otherwise, output zero.

there 2 possible optimizations code show below. 1. use input array "joblist" without having copy it. 2. combine map of maps 1 large map.

function jobsorter(a,b) {     return a.jobid - b.jobid; }  function numbersort(a,b) {     return - b; }   function buildsortedarray(yourarray) {      var index, j, item;     var joblist = []; // array of {jobid, timestamp, timecomp};     var timestampmap = {};     var timestamplist = [];     var key, jobkey;     var output = [];      // loop through every item in array     (index = 0; index < yourarray.length; index++) {         item = yourarray[index];                   // push each item "job list"         job = {jobid: item[1], timestamp: item[0], timecomp: item[2]};         joblist.push(job);          // use both map , list keep track of unique timestamps         key = "$timestamp$" + job.timestamp.tostring();          if (timestampmap[key] === undefined) {             timestampmap[key] = {};             timestampmap[key].jobmap = {};              timestamplist.push(job.timestamp); // keep timestamp array can sort on         }          // add job timestamp         jobkey = "$jobid$" + job.jobid.tostring();         timestampmap[key].jobmap[jobkey] = job;     }      // let's sorting     timestamplist.sort(numbersort); // timestamplist in ascending order     joblist.sort(jobsorter);        // joblist in ascending order       (index = 0; index < timestamplist.length; index++) {         item = [];          item.push(timestamplist[index]);         (j = 0; j < joblist.length; j++) {              key = "$timestamp$" + timestamplist[index].tostring();             jobkey = "$jobid$"  + joblist[j].tostring();              if (timestampmap[key].jobmap[jobkey]) {                 item.push(timestampmap[key].jobmap[jobkey].timecomp);             }             else {               item.push(0);             }         }          output.push(item);     }       return output; }

Comments

Post a Comment

Popular posts from this blog

c# - How to set Z index when using WPF DrawingContext? -

-
how set z-index drawing object when using drawingcontext.drawxxx() methods? the object drawn last have higher z index. can't change index of drawn objects. way draw in order. if using wpf (as placed tag), can use, example, canvas control. create shapes need like polyline obj = new polyline(); //... // ... set properties of obj and add them canvas uielementcollection: yourcanvasname.children.add(obj); //or yourcanvasname.children.insert(i, obj); first items of collection have higher z index. advantages in way: no need redraw on window changes, can anytime move objects , change order.
Read more

razor - Is this a bug in WebMatrix PageData? -

-
i think may have found bug in webmatrix's pagedata, not sure. concerns how pass data partial page calling page. in webmatrix documentation (tutorials, e.g. " 3 - creating consistent look ", , example code), pagedata recommended mechanism pass data between pages (e.g. content page layout page, or partial page). however have found not work other way, pass data partial page calling page. modifying or adding entries in pagedata in partial page, not seem calling page. cutting right down simplest possible example, in test page may have this: @{ pagedata["test"] = "initial entry"; } <p>before calling partial page, test value @pagedata["test"]</p> @renderpage("_testpartial.cshtml") <p>after returning calling page, test value @pagedata["test"]</p> and in _testpartial.cshtml page might have this: @{ pagedata["test"] = "modified entry"; } <p>in partial page...
Read more

android - layout with fragment and framelayout replaced by another fragment and framelayout -

-
edit: so after comments below, revisted , realized hanging me up. imagine client list , client details activity started : public class clientsmainactivity extends fragmentactivity { @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //studiotabopenhelper db; setcontentview(r.layout.main_client_activity); } } so works great, starts main_client_activity (defined in layout below, , call activity when button on main screen clicked): intent intent = new intent(getactivity(), clientsmainactivity.class); startactivity(intent); easy issue is, clientsmainactivity not call oncreateview or anything, sets layout layout defines fragment, , listfragment. fine cause not trying pass clientsmainactivity , if have hypothetical activity like: sessionmainsactivity called when click on session edit of client, not calling sessionsmainactivity same way (starts activity sets alayout), want layout set defines...
Read more