Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $stmt = $conn->prepare(SELECT A.TOTAL, A.Dia, Turno
- FROM
- (SELECT (COUNT(tarefa)/1020) * 100 AS TOTAL, DAY(IniciarTarefa) AS Dia, DATE(IniciarTarefa) AS DataInicio FROM raddb.Tarefa LEFT OUTER JOIN raddb.TipoTarefa
- ON raddb.TipoTarefa.Id = raddb.Tarefa.tarefa
- 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
- MONTH(FimTarefa) = EXTRACT(MONTH FROM CURDATE() - INTERVAL 0 MONTH)
- GROUP BY MONTH(FimTarefa), DAY(FimTarefa), DAY(IniciarTarefa), DATE(IniciarTarefa)) AS A LEFT OUTER JOIN raddb.sessoes ON DATE(data) = A.DataInicio
- WHERE Turno = 'M' ORDER BY A.TOTAL DESC LIMIT 5");
- $stmt->execute();
- $json = [];
- while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
- extract($row);
- $json[]= [(string)$Turno, (int)$TOTAL];
- }
- echo json_encode($json);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement