<div dir="ltr">No, xq lo que necesito es saber la cantidad de tiempo trabajado mas alla de las acciones (si fueron 1 por minuto o 3 por minuto)...<div style>Les cuento q en G+ me están pasando una query enorme que tendré que probar... <a href="https://plus.google.com/u/0/111248427612525054266/posts/6WEozoy1RZm">https://plus.google.com/u/0/111248427612525054266/posts/6WEozoy1RZm</a></div>
<div style><br></div><div style>Gracias desde ya a toda la ayuda! :D</div><div style><br></div><div style><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/3/25 Carlos M. Martinez <span dir="ltr"><<a href="mailto:carlosmarcelomartinez@gmail.com" target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Y no te sirve mas otras metrica? Estilo "cantidad de acciones / hora
/ operador". Tal como describis tu problema tiene mucho mas sentido
esto que tratar de forzar una duración a algo que vos queres modelar
como instantáneo.<div><div class="h5"><br>
<br>
<br>
<div>On 3/25/13 4:54 PM, Gustavo Azambuja
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Si, para al final conseguir la cantidad de minutos
trabajados durante el día de cada operador y en definitiva, de
la suma de todos los operadores (me interesa la relación:
minutos/día totales).
<div>El tema es que como dije antes, las acciones son
instantáneas, y muchas veces un usuario tiene 2 o 3 por
minuto... (t + 30 seg...) pero esto no me daría un resultado
real ya que algunos usuarios sería cada 15 segundos y otros
cada 50... la suma sería muy diferente...</div>
<div><br>
</div>
<div>Por lo que veo, lo que tengo que hacer es calcular las
diferencias entre cada intervalo y si son menores a 5 minutos,
sumarlas.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div class="gmail_extra">
<br>
<div class="gmail_quote">2013/3/25 Nicolás Sanguinetti <span dir="ltr"><<a href="mailto:contacto@nicolassanguinetti.info" target="_blank">contacto@nicolassanguinetti.info</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Si entiendo bien, entonces, lo que querés
es la unión de todos los intervalos [t, t + 5 minutos].
O sea, vos tenés que el usuario hizo acciones en:
<div>
<br>
</div>
<div>t1 = 10:00</div>
<div>t2 = 10:02</div>
<div>t3 = 10:06</div>
<div>t4 = 10:15</div>
<div><br>
</div>
<div>Lo que querés es llevar eso a que trabajó en [10:00
.. 10:05], [10:02 .. 10:07], [10:06 .. 10:11] y [10:15
.. 10:20]. Y la unión de todos esos intervalos es
[10:00 .. 10:11], [10:15 .. 10:20].</div>
<div><br>
</div>
<div>Eso es lo que querés?</div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25 Chicken Urine <span dir="ltr"><<a href="mailto:chickenurine@gmail.com" target="_blank">chickenurine@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default" style="font-family:'courier new',monospace">Podés
sacar el máximo y mínimo para un usuario y
saber el tiempo total. Luego a eso le
descontás el tiempo NO trabajado, que serían
las tareas de más de 5 minutos o lo que sea.</div>
<div class="gmail_default" style="font-family:'courier new',monospace">La
verdad que así como está no se me ocurre
como poder sacar un valor aproximado sin,
como bien dijo Carlos, darle una duración
promedio a las tareas.</div>
</div>
<div>
<div>
<div class="gmail_extra"><br clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El <a href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a> tiene su
lugar.</span></div>
</div>
<br>
<br>
<div class="gmail_quote">2013/3/25 Gustavo
Azambuja <span dir="ltr"><<a href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Si, entiendo. El tema
es que no puedo cambiar la
estructura que está... pero me diste
algo para pensar con lo de
t0+5min... creo que por ahí lo
soluciono.
<div>Gracias!</div>
</div>
<div>
<div>
<div class="gmail_extra">
<br>
<br>
<div class="gmail_quote">2013/3/25
Carlos M. Martinez <span dir="ltr"><<a href="mailto:carlosmarcelomartinez@gmail.com" target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> El tema es
que medir duración de algo
es como que lógicamente
incompatible con la
hipótesis de que las
acciones son instantáneas
(es decir de duración 0,
por lo cual la sumatoria
siempre seria 0)<br>
<br>
Para calcular la cantidad
de minutos ocupados en
eso, se me ocurren algunas
cosas:<br>
<br>
- asumir una duracion por
tarea, es decir, si aprete
enter en t0, la tarea duro
hasta t0+5min<br>
- agregar una columna de
'fin' de la accion,
tratando de medir cuando
ese fin ocurre, creo que
esto es lo mas razonable,
ya que en realidad nada es
instantáneo<br>
- asumir que la duracion
de la tarea es entre
enters sucesivos del mismo
usuario, asumiendo que
trabajan siempre, lo cual
te deja abierta la
duracion del ultimo
'enter' del dia<br>
<br>
- Y finalmente, pensar si
en el caso de que
realmente las acciones
sean logicamente
instantaneas, si la
metrica 'minutos
trabajados' tiene sentido,
si no hace falta una
metrica que sea 'cantidad
de enters por unidad de
tiempo', o algo parecido.<br>
<br>
Creo que como dice
Chicken, falta algo en el
modelado de tu realidad.<br>
<br>
s2<span><font color="#888888"><br>
<br>
~C.</font></span>
<div>
<div><br>
<br>
<div>On 3/25/13 11:45
AM, Gustavo Azambuja
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Carlos,
gracias por
responder... es
que no son
"tareas" mas bien
son "acciones"...
<div>Imaginen que
tienen una tabla
donde los
funcionarios que
tienen cada
ENTER que apreto
un
usuario/funcionario,
y en la columna
date, lo que
aparece es la
hora en que
apreto ENTER...</div>
<div><br>
</div>
<div><br>
</div>
<div>
<pre style="white-space:pre-wrap;max-height:600px;width:auto;background-color:rgb(238,238,238);margin-bottom:10px;padding:5px;vertical-align:baseline;line-height:18px;font-size:14px;overflow:auto;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;margin-top:0px;border:0px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">id</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">user</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> action</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> date
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">01</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">03</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">12</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">4</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">20</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">5</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><font color="#800000">24
...
</font><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#800000">10</font></span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> user3</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> a1</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">10</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">02</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">35
...
<span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#800000">16</font></span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> user3</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> a1</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">10</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">04</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">01</span>
</span><font color="#800000">
</font></span></code></pre>
</div>
<div><br>
</div>
<div>El usuario
user1: apreto
solo una vez
ENTER: 10h 00m
01s; el user2,
:03s, :12s, y
:24s</div>
<div>Ahora, por
ejemplo el
user3, esta
"apretando
ENTER" cada
algunos cuantos
segundos, y
luego del id=16
no aparece
mas... podría
decir entonces
que el user3
trabajó desde
10:00 hasta las
10:04 (4 minutos
trabajados)</div>
<div><br>
</div>
<div>el tema es
como consigo
llegar a esa
conclusion
usando PHP y
MySQL...</div>
<div><br>
</div>
<div>Como dije
antes, asumo que
el usuario ya no
está trabajando
si pasan mas de
5 minutos sin
"acciones"
realizadas.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25
Carlos M.
Martinez <span dir="ltr"><<a href="mailto:carlosmarcelomartinez@gmail.com" target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Pero como
definis la
'duracion' de
cada tarea ?
el intervalo
entre dos
entradas ? <br>
<div>
<div> <br>
<div>On
3/25/13 10:50
AM, Gustavo
Azambuja
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">No,
la tarea es
"instantanea"...
digamos, para
entender, que
cada registro
es una
pulsación de
ENTER en el
teclado del
usuario...
sabiendo eso,
y que jamas
pasan 5
minutos sin
dar ENTER a
menos que no
estén
trabajando...
como consigo
saber los
"minutos
trabajados por
operador" (o
la suma de
todos los
operadores)?
<div> <br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25
Chicken Urine
<span dir="ltr"><<a href="mailto:chickenurine@gmail.com" target="_blank">chickenurine@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default">Ok,
entonces el
date ese es la
hora de inicio
de la tarea,
por lo que
supongo que la
duración de
una tarea es
el tiempo
entre 2
registros?</div>
</div>
<div class="gmail_extra">
<div><br clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El
<a href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a>
tiene su
lugar.</span></div>
</div>
<br>
<br>
</div>
<div>
<div>
<div class="gmail_quote">2013/3/25
Gustavo
Azambuja <span dir="ltr"><<a href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p dir="ltr">La
columna date
tiene el
datetime del
evento (q
ejecutó una
acción) </p>
<p dir="ltr">En
definitiva
tengo una
lista de
eventos de
diferentes
usuarios y
necesito
calcular los
"minutos
trabajados
totales) </p>
<p dir="ltr">Para
el cálculo
asumo que si
el usuario no
ejecuta
eventos en 5
minutos no
está
trabajando. </p>
<p dir="ltr">Uso
MySQL, y
podría
completar el
cálculo con
php. </p>
<div class="gmail_quote">El
mar 25, 2013
8:20 a.m.,
"Chicken
Urine" <<a href="mailto:chickenurine@gmail.com" target="_blank">chickenurine@gmail.com</a>>
escribió:
<div>
<div><br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default">Gustavo,
no me queda
muy claro el
ejemplo. La
columna date
guarda un
resultado de
HH:MM:ss que
llevó un tarea
particular? O
es la hora de
comienzo/fin?</div>
<div class="gmail_default">Que
rdbms estás
utilizando? Ya
que hay
funciones
específicas en
cada motor
para el manejo
de tipo de
datos date.</div>
</div>
<div class="gmail_extra">
<br clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El
<a href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a>
tiene su
lugar.</span></div>
</div>
<br>
<br>
<div class="gmail_quote">2013/3/24
Gustavo
Azambuja <span dir="ltr"><<a href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>Alguien
me puede
ayudar con
esta query?</div>
<div><br>
</div>
<div>básicamente,
necesito
conseguir en
base a una
tabla que
tiene acciones
realizadas por
mis usuarios
(funcionarios)
durante cada
minuto. Ahora,
necesito en
base a esa
tabla saber
los "minutos
trabajados"</div>
<div><br>
</div>
<a href="http://stackoverflow.com/questions/15606675/minutes-work-by-users-how-to-make-this-query" target="_blank">http://stackoverflow.com/questions/15606675/minutes-work-by-users-how-to-make-this-query</a><br clear="all">
<div><br>
</div>
<div>
<pre style="max-height:600px;width:auto;background-color:rgb(238,238,238);margin-bottom:10px;padding:5px;vertical-align:baseline;line-height:18px;font-size:14px;overflow:auto;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;margin-top:0px;border:0px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">id</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">user</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> action</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> date
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">01</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">03</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">12</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">4</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">20</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">5</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">24</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">....</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">...</span></code></pre>
<p> Por
ejemplo:</p>
<ol>
<li style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo solo un
funcionario
trabajando las
24h, tendré:
24h*60m = 1440
minutos
trabajados en
el día.</li>
<li style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo 2
funcionarios
durante todo
el día (24h)
tendré: 2880
minutos
trabajados
hoy...</li>
<li style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo los
mismos dos
funcionarios,
pero
trabajando 12h
cada uno,
vuelvo a tener
los 1440
m/día.</li>
</ol>
<div><font color="#000000" face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span style="font-size:14px;line-height:18px">Alguna idea de como podría armar
una query que
me de ésto? o
como mucho con
algo de PHP
ademas de la
query.</span></font></div>
</div>
<div><font color="#000000" face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span style="font-size:14px;line-height:18px"><br>
</span></font></div>
<div><font color="#000000" face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span style="font-size:14px;line-height:18px">Gracias!</span></font></div>
<span><font color="#888888">
<div><br>
</div>
<div><br>
</div>
-- <br>
<font face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier
new',
monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><br>
</span></font></div>
</font></span></div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier
new',
monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Uylug-programming mailing list
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet
ms', sans-serif">Gustavo
Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier
new',
monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font face="'courier
new',
monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms',
sans-serif">Gustavo Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div>
<br>
<font face="'courier new',
monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier new',
monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier new',
monospace"><span style="font-size:x-small"><b><a href="tel:091%20300%20333" value="+59891300333" target="_blank">091 300
333</a></b>
(Montevideo - Mobile)</span></font><font face="'courier new',
monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing list<br>
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms', sans-serif">Gustavo Azambuja<br>
</font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a>
<div>
<br>
<font face="'courier new', monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier new', monospace"><span style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font face="'courier new', monospace"><span style="font-size:x-small"><b>091 300 333</b> (Montevideo
- Mobile)</span></font><font face="'courier new',
monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Uylug-programming mailing list
<a href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a>
<a href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a>
</pre>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><font face="'trebuchet ms', sans-serif">Gustavo Azambuja<br></font><a href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a><div>
<a href="http://gazambuja.com" target="_blank"></a><br><font face="'courier new', monospace"><span style="font-size:x-small">Uruguay:</span></font><font face="'courier new', monospace"><span style="white-space:pre"><span style="font-size:x-small"> </span></span></font><font face="'courier new', monospace"><span style="font-size:x-small"><b>091 300 333</b> (Montevideo - Mobile)</span></font><font face="'courier new', monospace"><span style="font-size:x-small"><br>
</span></font></div>
</div>