-
Notifications
You must be signed in to change notification settings - Fork 0
/
relatorioCaixa.php
75 lines (67 loc) · 1.91 KB
/
relatorioCaixa.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
<?php
include 'conectar.php';
error_reporting(E_WARNING);
conectar();
if(!isset($_SESSION['permissao']))
session_start();
if($_SESSION['permissao'] <= 0 ){
echo "<div class='negada'>Permissão negada!</div>
<div class='negada'>É necessário efetuar login para acessar essa página... </div>
<div class='negada'><a href='index.php'>Logar</a></div>";
exit();
}
?>
<html>
<head>
<meta charset="UTF-8"/>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div id = 'titulo' class = 'titulo'>Caixa do Dia</div>
<?php
$data = date("m/d/Y");
$dt = $data;
$caixa = $_SESSION['cod'];
$sql = "select
c.nome,
s.descr,
h.dt,
h.hora,
s.valor,
h.caixa
from
horario h,
servico s,
cliente c
where
c.cpf=h.cliente and
s.cod=h.servico and
h.situacao='1' and
h.dt='$dt' and
h.caixa = '$caixa'";
$result = pg_query($sql);
$total=0;$k=0;
echo "<br><br><br>";
echo "<div class='tabela'>";
echo "<table border=1 class='table'>";
echo "<caption>Caixa:<b>$caixa</b> Data:<b>$dt</b></caption>";
echo "<tr><th width=50 align=center>No</td><th width=200 align=center>Cliente</td><th width=200 align=center>Serviço</td><th width=100 align=center>Valor</td></tr>";
$classe='background: #EEE';
while ($row = pg_fetch_assoc($result))
{
$nome = $row['nome'];
$descr = $row['descr'];
$valor = $row['valor'];
$total = $total + $valor;
$k++;
$valor=number_format($valor,2,',', '.');
if($classe=='background: #EEE') $classe = 'background: #FFF'; else $classe='background: #EEE';
echo "<tr style='$classe'><td width=50 align=center>$k</td><td width=200 >$nome</td><td width=200 >$descr</td><td width=100 align=right>$valor</td></tr>";
}
$total=number_format($total,2,',', '.');
echo "<tr> <td colspan=3></td><th align=right>$total</td></tr>";
echo "</table>";
echo '</div>';
?>
</body>
</html>