Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. $stmt = $conn->prepare(SELECT A.TOTAL, A.Dia, Turno
  2.  
  3. FROM
  4. (SELECT (COUNT(tarefa)/1020) * 100 AS TOTAL, DAY(IniciarTarefa) AS Dia, DATE(IniciarTarefa) AS DataInicio FROM raddb.Tarefa LEFT OUTER JOIN raddb.TipoTarefa
  5.  
  6. ON raddb.TipoTarefa.Id = raddb.Tarefa.tarefa
  7.  
  8. WHERE TipoTarefa IN ('2', '3') AND DATE_FORMAT(IniciarTarefa, '%H:%i:%S') >= '07:00:00' AND DATE_FORMAT(FimTarefa, '%H:%i:%S') <= '14:00:00' AND
  9. MONTH(FimTarefa) = EXTRACT(MONTH FROM CURDATE() - INTERVAL 0 MONTH)
  10.  
  11. GROUP BY MONTH(FimTarefa), DAY(FimTarefa), DAY(IniciarTarefa), DATE(IniciarTarefa)) AS A LEFT OUTER JOIN raddb.sessoes ON DATE(data) = A.DataInicio
  12.  
  13. WHERE Turno = 'M' ORDER BY A.TOTAL DESC LIMIT 5");
  14.  
  15. $stmt->execute();
  16. $json = [];
  17.  
  18. while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
  19. extract($row);
  20. $json[]= [(string)$Turno, (int)$TOTAL];
  21. }
  22. echo json_encode($json);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement