-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdo_upload.php
94 lines (94 loc) · 3.76 KB
/
do_upload.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
<?php
session_start();
function TauxEchange($Montant, $MontantTotal, $Devise)
{
if($Devise == "$"){
$MontantTotal = $MontantTotal + ($Montant*1.05733);
}else if ($Devise == "£"){
$MontantTotal = $MontantTotal + ($Montant*0.840728);
} else {
$MontantTotal = $MontantTotal + $Montant;
}
return $MontantTotal;
}
function NameDevise($Devise)
{
if($Devise == "$"){
$DeviseName = 'USD';
}else if ($Devise == "£"){
$DeviseName = 'GBP';
} else {
$DeviseName = 'EUR';
}
return $DeviseName;
}
if(isset($_FILES['userfile']))
{
$nbVir = 0;
$nbPre = 0;
$MontantPre = 0;
$MontantVir = 0;
$NulLot = time();
include 'connexion.php';
var_dump($_FILES);
echo 'Il y a un fichier ' . $_FILES['userfile']['tmp_name'];
$row = 1;
if (($handle = fopen($_FILES['userfile']['tmp_name'], "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
echo "<p> $num fields in line $row: <br /></p>\n";
$row++;
for ($c=0; $c < $num; $c++) {
echo $data[$c] . "<br />\n";
}
if($data[0]=="PRE"){
echo "Prélévement";
echo "</br>";
$Requête = "INSERT INTO `operations`(`montant`, `IdUser`, `Devise`, `Type`, `CptOrigine`, `CptDest`, `NumLot`) VALUES (:Montant,:IdUser,:Devise,:Type,:CptOrigine,:CptDest,:NumLot)";
echo $Requête;
echo "</br>";
$Requete_preparee = $bdd->prepare ($Requête);
$Requete_preparee->bindValue(':Montant', $data[1], PDO::PARAM_STR);
$Requete_preparee->bindValue(':IdUser', $_SESSION['IdUser'], PDO::PARAM_STR);
$Requete_preparee->bindValue(':Type', 'PRE', PDO::PARAM_STR);
$Requete_preparee->bindValue(':Devise', NameDevise($data[2]), PDO::PARAM_STR);
$Requete_preparee->bindValue(':CptOrigine', $data[3], PDO::PARAM_STR);
$Requete_preparee->bindValue(':CptDest', $data[4], PDO::PARAM_STR);
$Requete_preparee->bindValue(':NumLot', $NulLot, PDO::PARAM_STR);
print_r($Requete_preparee);
echo "</br>";
$Resultat = $Requete_preparee->execute();
echo $Resultat;
echo "</br>";
$nbPre++;
$MontantPre = TauxEchange($data[1], $MontantPre, $data[2]);
} else {
echo "Virement";
echo "</br>";
$Requête = "INSERT INTO `operations`(`montant`, `IdUser`, `Devise`, `Type`, `CptOrigine`, `CptDest`, `NumLot`) VALUES (:Montant,:IdUser,:Devise,:Type,:CptOrigine,:CptDest,:NumLot)";
echo $Requête;
echo "</br>";
$Requete_preparee = $bdd->prepare ($Requête);
$Requete_preparee->bindValue(':Montant', $data[1], PDO::PARAM_STR);
$Requete_preparee->bindValue(':IdUser', $_SESSION['IdUser'], PDO::PARAM_STR);
$Requete_preparee->bindValue(':Type', 'VIR', PDO::PARAM_STR);
$Requete_preparee->bindValue(':Devise', NameDevise($data[2]), PDO::PARAM_STR);
$Requete_preparee->bindValue(':CptOrigine', $data[3], PDO::PARAM_STR);
$Requete_preparee->bindValue(':CptDest', $data[4], PDO::PARAM_STR);
$Requete_preparee->bindValue(':NumLot', $NulLot, PDO::PARAM_STR);
print_r($Requete_preparee);
echo "</br>";
$Resultat = $Requete_preparee->execute();
echo $Resultat;
echo "</br>";
$nbVir++;
$MontantVir = TauxEchange($data[1], $MontantVir, $data[2]);
}
}
fclose($handle);
}
header('Location: resultat.php?nbPre='.$nbPre.'&nbVir='.$nbVir.'&MontantPre='.$MontantPre.'&MontantVir='.$MontantVir);
} else {
echo 'Il n\'y a pas de fichier';
}
?>