Last active
November 7, 2025 22:00
-
-
Save leonardo403/d5da5554e58187a6ba1baab5cbdabbf5 to your computer and use it in GitHub Desktop.
Testes
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| Tb_banco.nome AS nome_banco, | |
| Tb_convenio.verba, | |
| Tb_contrato.codigo AS codigo_contrato, | |
| Tb_contrato.data_inclusao, | |
| Tb_contrato.valor, | |
| Tb_contrato.prazo | |
| FROM | |
| Tb_contrato | |
| INNER JOIN Tb_convenio_servico ON Tb_contrato.convenio_servico = Tb_convenio_servico.codigo | |
| INNER JOIN Tb_convenio ON Tb_convenio_servico.convenio = Tb_convenio.codigo | |
| INNER JOIN Tb_banco ON Tb_convenio.banco = Tb_banco.codigo | |
| <?php | |
| $pdo = new PDO('mysql:host=localhost;dbname=SEUBANCO', 'usuario', 'senha'); | |
| $sql = " | |
| SELECT | |
| Tb_banco.nome AS nome_banco, | |
| Tb_convenio.verba, | |
| Tb_contrato.codigo AS codigo_contrato, | |
| Tb_contrato.data_inclusao, | |
| Tb_contrato.valor, | |
| Tb_contrato.prazo | |
| FROM | |
| Tb_contrato | |
| INNER JOIN Tb_convenio_servico ON Tb_contrato.convenio_servico = Tb_convenio_servico.codigo | |
| INNER JOIN Tb_convenio ON Tb_convenio_servico.convenio = Tb_convenio.codigo | |
| INNER JOIN Tb_banco ON Tb_convenio.banco = Tb_banco.codigo | |
| "; | |
| $stmt = $pdo->query($sql); | |
| echo "<table border='1'>"; | |
| echo "<tr> | |
| <th>Banco</th> | |
| <th>Verba</th> | |
| <th>Código do Contrato</th> | |
| <th>Data de Inclusão</th> | |
| <th>Valor</th> | |
| <th>Prazo</th> | |
| </tr>"; | |
| while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { | |
| echo "<tr> | |
| <td>{$row['nome_banco']}</td> | |
| <td>{$row['verba']}</td> | |
| <td>{$row['codigo_contrato']}</td> | |
| <td>{$row['data_inclusao']}</td> | |
| <td>{$row['valor']}</td> | |
| <td>{$row['prazo']}</td> | |
| </tr>"; | |
| } | |
| echo "</table>"; | |
| ?> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| b.nome AS nome_banco, | |
| c.verba, | |
| MIN(ct.data_inclusao) AS data_inclusao_mais_antiga, | |
| MAX(ct.data_inclusao) AS data_inclusao_mais_nova, | |
| SUM(ct.valor) AS soma_valor_contratos | |
| FROM | |
| Tb_contrato ct | |
| JOIN Tb_convenio_servico cs ON ct.convenio_servico = cs.codigo | |
| JOIN Tb_convenio c ON cs.convenio = c.codigo | |
| JOIN Tb_banco b ON c.banco = b.codigo | |
| GROUP BY | |
| b.nome, | |
| c.verba |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment