-
Notifications
You must be signed in to change notification settings - Fork 0
/
relatorio5_pdf.php
248 lines (116 loc) · 4.24 KB
/
relatorio5_pdf.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
require("pdml.php");
include("classes.php");
$arquivo = "os_".$data.".pdf";
$PDML_FileName = $arquivo;
$dataini2 = explode("/",$dataini);
$dataini = $dataini2[2]."-".$dataini2[1]."-".$dataini2[0];
$datafim2 = explode("/",$datafim);
$datafim = $datafim2[2]."-".$datafim2[1]."-".$datafim2[0];
function converterHora($total_segundos)
{
$hora = sprintf("%02s",floor($total_segundos / (60*60)));
$total_segundos = ($total_segundos % (60*60));
$minuto = sprintf("%02s",floor ($total_segundos / 60 ));
$total_segundos = ($total_segundos % 60);
$hora_minuto = $hora.":".$minuto;
return $hora_minuto;
}
function converterTempo($tempo)
{
$aux = explode(":",$tempo);
$tempo = $aux[0]*3600+$aux[1]*60;
return $tempo;
}
?>
<html>
<head>
<title>Ordem de Serviço</title>
</head>
<pdml>
<body>
<font size='20'>
<cell width='50' align='left'><img src="logo.jpg" height="40" width="40" /></cell><cell height='40'>Orbital Soluções</cell><br height='2cm' />
</font>
<b>
<font size='14'>
<cell height='20' width='500'>Empresa: <?php echo $empresa?></cell><br height='1.5cm' />
</font>
<font size='10'>
<cell width='70' border='1' height='20' align='center' fillcolor='#cccccc'>DATA</cell>
<cell width='120' border='1' height='20' align='center' fillcolor='#cccccc'>ANALISTA</cell>
<cell width='90' border='1' height='20' align='center' fillcolor='#cccccc'>ENTRADA</cell>
<cell width='90' border='1' height='20' align='center' fillcolor='#cccccc'>SAIDA</cell>
<cell width='90' border='1' height='20' align='center' fillcolor='#cccccc'>DESCONTO</cell>
<cell width='90' border='1' height='20' align='center' fillcolor='#cccccc'>HORAS</cell>
</b>
<br height='20'>
<?php
$totalg = 0;
$analistas = array();
//conexao com o banco de dados
$conexaoMYSQL = new conexaoMYSQL;
$conexaoMYSQL->conexaoMYSQL();
$sql = "SELECT DISTINCT(analista) FROM os WHERE empresa='$empresa' AND data BETWEEN '$dataini' AND '$datafim' AND EXCLUIR='' ORDER BY data";
$query = $conexaoMYSQL->query($sql);
if($query)
{
while($row = mysql_fetch_array($query))
{
array_push($analistas,$row['analista']);
}
}
for($i=0;$i<=count($analistas)-1;$i++)
{
$total = 0;
$sql = "SELECT * FROM os WHERE empresa='$empresa' AND analista='$analistas[$i]' AND data BETWEEN '$dataini' AND '$datafim' AND modulo='VIRADA' AND EXCLUIR='' ORDER BY data";
$query = $conexaoMYSQL->query($sql);
if($query)
{
while($row = mysql_fetch_assoc($query))
{
$analista = $row['analista'];
$responsavel = $row['responsavel'];
$empresa = $row['empresa'];
$data = substr($row['data'],8,2)."/".substr($row['data'],5,2)."/".substr($row['data'],0,4);
$entrada = $row['entrada'];
$saida = $row['saida'];
$desconto = $row['desconto'];
$descricao = $row['descricao'];
$horasent = strtotime($entrada);
$horassai = strtotime($saida);
if($horassai<=$horasent)
$horassai += (24*3600);
$horasa = $horassai-$horasent;
if(isset($desconto))
{
$descontar = converterTempo($desconto);
$horasa = $horasa-$descontar;
}
$horas = converterHora($horasa);
$totalg += $horasa;
$total += $horasa;
?>
<cell width='70' border='1' height='20'><?php echo $data?></cell>
<cell width='120' border='1' height='20'><?php echo $analista?></cell>
<cell width='90' border='1' height='20'><?php echo $entrada?></cell>
<cell width='90' border='1' height='20'><?php echo $saida?></cell>
<cell width='90' border='1' height='20'><?php echo $desconto?></cell>
<cell width='90' border='1' height='20'><?php echo $horas?></cell>
<br height='20'>
<multicell width='550' inter='20' border=1><?php echo $descricao?></multicell>
<?
}
}
?>
<cell width='460' border='1' height='20'>TOTAL DE HORAS</cell>
<cell width='90' border='1' height='20'><?php echo converterHora($total)?></cell>
<br height='20'>
<?php
}
?>
<cell width='460' border='1' height='20'>TOTAL GERAL DE HORAS</cell>
<cell width='90' border='1' height='20'><?php echo converterHora($totalg)?></cell>
</body>
</pdml>
</html>