1 pièce(s) jointe(s)
Un de mes foreach est ignoré
Bonjour
Aidez-moi svp !
Je ne comprend pas, un de mes foreach n'est pas pris en compte dans les resultats, je ne comprends pourquoi !
Voici l'affichage :
Pièce jointe 368228
Voici l'ensemble du code :
Code:
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
125
126
127
128
129
130
131
132
133
| <?phprequire_once 'connexion.php';
$resFC1=$base->prepare("SELECT * FROM infosfacture WHERE id= ?");
$resFC1->bindValue(1, $id, PDO::PARAM_INT);
$resFC1->execute(array($_GET['id']));
$resFC=$base->prepare("SELECT infosfacture.num, infosfacture.client, infosfacture.datefacture, infosfacture.facturede, infosfacture.conditions, facturation.designation, facturation.quantite, facturation.prixht, facturation.taxe
FROM infosfacture
INNER JOIN facturation
ON infosfacture.id=? AND facturation.fk_facturation_id=infosfacture.id");
$resFC->bindValue(1, $id, PDO::PARAM_INT);
$resFC->execute(array($_GET['id']));
//$resultat= $resFC->fetchAll();
//var_dump($resultat);
?>
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width"/>
<title>Afficher une Facture</title>
<link rel="stylesheet" href="style.css" media="all" />
<link rel="icon" type="image/png" href="favicon.png" />
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.0.9/css/all.css" integrity="sha384-5SOiIsAziJl6AWe0HWRKTXlfcSHKmYV4RBF18PPJ173Kzn7jzMyFuTtk8JA7QQG1" crossorigin="anonymous">
</head>
<body>
<br/>
<?php require_once('includes/menu.php') ?>
<br/><br/>
<?php foreach ($resFC1 as $uneFacture1): ?>
<header class="clearfix">
<div id="logo">
<img src="logo.png">
</div>
<div id="company">
<div class="to"><h2>De:</h2> <?php echo $uneFacture1['facturede'] ?></div>
</div>
</header>
<main>
<div id="details" class="clearfix">
<div id="client">
<div class="to"><h2>Facture à:</h2> <?= $uneFacture1['client'] ?></div>
</div>
<div id="invoice">
<h1>FACTURE N° <?= $uneFacture1['num'] ?></h1>
<div class="date">Date: <?= $uneFacture1['datefacture'] ?></div>
</div>
</div>
<?php $identifiant = $uneFacture1['id']; ?>
<?php endforeach; ?>
<table border="0" cellspacing="0" cellpadding="0">
<thead>
<tr>
<th class="desc">DESIGNATION</th>
<th class="qty">QUANTITÉ</th>
<th class="unit">PRIX HT</th>
<th class="unit">TAXE</th>
<th class="total">TOTAL HT</th>
</tr>
</thead>
<tbody>
<?php $sommeht = 0;?>
<?php foreach ($resFC as $uneFacture):
//$prixtotalht=$req['prixht'] * $req['quantite'];
?>
<tr>
<td class="desc"><?= $uneFacture['designation'] ?></td>
<td class="qty"><?= $uneFacture['quantite'] ?></td>
<td class="unit"><?= $uneFacture['prixht'] ?></td>
<td class="unit"><?= $uneFacture['taxe'] ?></td>
<td class="total"><?= $uneFacture['prixht'] * $uneFacture['quantite'] ?></td>
</tr>
<?php $sommeht += $uneFacture['prixht'] * $uneFacture['quantite']; ?>
<?php endforeach; ?>
</tbody>
<tfoot>
<tr>
<td colspan="4">TOTAL HT</td>
<td><?= $sommeht; ?></td>
</tr>
<?php $sommetaxe = 0;?>
<?php foreach ($resFC as $uneFacture):
$prixtotalht=$uneFacture['prixht'] * $uneFacture['quantite'];
$valeurtaxe= $uneFacture['taxe']/100;
$prixtaxe=$prixtotalht * $valeurtaxe;
?>
<tr>
<td colspan="4">TAXE à <?= $uneFacture['taxe'] ?> % </td>
<td><?= $uneFacture['prixht'] * $uneFacture['quantite'] ?></td>
</tr>
<?php $sommetaxe += $prixtotalht ; ?>
<?php endforeach; ?>
<tr>
<td colspan="4">TOTAL TTC</td>
<td><?= $sommeht + $sommetaxe ; ?></td>
</tr>
</tfoot>
</table>
<div id="notices">
<div><h2>Conditions et moyens de paiement:</h2></div>
<div class="notice"> <?php echo $uneFacture['conditions'] ?> </div>
</div><br/>
<?= '<center>
<a href=" imprimerpdf.php?num='.$uneFacture['num'].'" target="_blank">
<figure>
<img src="printer.png" title="Imprimer votre facture" width="50px">
<figcaption>Imprimer votre facture</figcaption>
</figure>
</a>
</center>' ?>
<br/>
</main>
<?php require_once('includes/footer.php') ?>
</body>
</html> |
Voici la partie du code qui est ignoré :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
| <?php foreach ($resFC as $uneFacture):
$prixtotalht=$uneFacture['prixht'] * $uneFacture['quantite'];
$valeurtaxe= $uneFacture['taxe']/100;
$prixtaxe=$prixtotalht * $valeurtaxe;
?>
<tr>
<td colspan="4">TAXE à <?= $uneFacture['taxe'] ?> % </td>
<td><?= $uneFacture['prixht'] * $uneFacture['quantite'] ?></td>
</tr>
<?php $sommetaxe += $prixtotalht ; ?>
<?php endforeach; ?> |
