sql - mysql 5.5.50 Calculate one day multiple events to one -


i have problem thinking , must ask help. create working time tracking system , can manage other things code, cannot figure out how can calculate following data.

fist, have couple tables , 1 store 4 things.

index | | timestamp           | 1     | 1   | 2016-09-21 08:00:00 | work 2     | 2   | 2016-09-21 08:01:00 | work 3     | 1   | 2016-09-21 10:00:00 | bin 4     | 2   | 2016-09-21 10:00:00 | bin 5     | 1   | 2016-09-21 10:15:00 | bout 6     | 2   | 2016-09-21 10:17:00 | bout 7     | 2   | 2016-09-21 13:00:00 | bin 8     | 1   | 2016-09-21 13:00:00 | bin 9     | 1   | 2016-09-21 13:30:00 | bout 10    | 2   | 2016-09-21 13:30:00 | bout 11    | 2   | 2016-09-21 15:58:00 | home 12    | 1   | 2016-09-21 16:05:00 | home

i can nicely calculate times between work , home , got right value right person.

but i'm stuck break times.

i need calculate possible breaks per person , way total time spend breaks per person.

so need following answer when ask person 1 info:

who | time     | breaktime | working time 1   | 08:05:00 | 00:45:00  | 07:20:00

or maybe persons can came same page when ask specific day...

who | time     | breaktime | working time 1   | 08:05:00 | 00:45:00  | 07:20:00 2   | 07:57:00 | 00:47:00  | 07:10:00

there pairs events. work -> home , bin -> bout. , yes, there more persons , more brake times per person.

that might bad presentation, sorry (noob). hope give information can help. ask if there ask.

that code use when solve 1 day total time @ working place.

select timediff(   (select timestamp `stamps` (who '1' ,  date (timestamp) '2016-09-21' , 'home')), (select timestamp `stamps` (who '1' ,  date (timestamp) '2016-09-21' , 'work')) )

but cannot use multiple events.

that found. maybe not nice, works =).

$break = mysqli_query($conn,"select what, timestamp stamps (who '$id' ,  date (timestamp) '$day' , 'b%') order timestamp");  while($row = mysqli_fetch_array($break))  {   if ( $row['what'] == "bin" )    $start = strtotime( $row['timestamp'] );   else { $stop = strtotime( $row['timestamp'] );    $hours += ( $stop - $start );    }  } $btime = gmdate('h:i:s', floor($hours));

$btime gives 00:00:00 style result.


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more