-
Notifications
You must be signed in to change notification settings - Fork 0
/
action.php~
129 lines (105 loc) · 4.28 KB
/
action.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
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
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title></title>
</head>
<body>
<?php
include('./connecti.php');
$cn = connect_i();
if(isset($_POST['submitLoc'])){
$idloc = $_POST['id_loc'];
$idloueur = $_POST['id_loueur'];
$idsup = $_POST['id_suppL'];
$dateloc = $_POST['date_loc'];
$magloc = $_POST['id_magL'];
$dur = $_POST['dur'];
if(empty($idloc) || empty($idloueur) || empty($idsup) || empty($dateloc) || empty($magloc) || empty($dur) ) {
echo "<p>Vous devez remplir les 5 champs. <a href='index.php'>Retour a la page d'accueil</a></p>";
}else{
$query = "INSERT INTO location(id_location, id_loueur,id_support,date_loc,mag_loc,duree)
VALUES ('".$idloc."', '".$idloueur."', '".$idsup."','".$dateloc."','".$magloc."',".$dur.")";
$res = $cn->query($query) or die(mysql_error());
$query2 = "DELETE FROM en_magasin where id_supp = '".$idsup."'";
$res2 = $cn->query($query2) or die(mysql_error());
$query3= "UPDATE support SET global_loc = global_loc + 1 WHERE id_supp ='".$idsup."'";
$res3 = $cn->query($query2) or die(mysql_error());
$queryA= "INSERT INTO exemplaire (id_exemp, id_support) VALUES (NULL,'".$idsup."')";
$resA = $cn->query($queryA) or die(mysql_error("Erreur query A"));
echo "<p>La location a ete enregistree</p>";
echo "<p><a href='index.php'>Retour a l'accueil</a></p>";
echo "<p><a href='tables.php'>Retour aux tables</a></p>";
}
}
if(isset($_POST['submitLocR'])){
$idsup='';
$ecart='';
$period='';
$idlocR = $_POST['id_idlocR'];
$dateR = $_POST['dateR'];
$idmagR = $_POST['id_magR'];
if(empty($idlocR) || empty($dateR) || empty($idmagR)){
echo "<p>Vous devez remplir les 3 champs. <a href='index.php'>Retour a la page d'accueil</a></p>";
}else{
$query = "UPDATE LOCATION SET mag_retour='".$idmagR."', date_retour='".$dateR."' WHERE id_location = '".$idlocR."'";
$res = $cn->query($query);
$query2 = "SELECT id_support FROM location WHERE id_location = '".$idlocR."'";
$res2 = $cn->query($query2);
$tab = null;
while($tab =mysqli_fetch_assoc($res2)){
$idsup = $tab['id_support'];
}
$query3 = "INSERT INTO en_magasin(id_supp,id_mag) VALUES ('".$idsup."', '".$idmagR."')";
$res3 = $cn->query($query3);
//Insertion du prix selon le type, et selon la date de retour et la duree
$query4 = "SELECT type_support FROM support where id_supp='".$idsup."' LIMIT 1";
$res4 = $cn->query($query4) or die("Erreur de selection du type de support");
while($tab4= mysqli_fetch_assoc($res4)){
$type = $tab4['type_support'];
}
$price=0;
if($type='DVD'){
$price=5;
}else if($type='VCD'){
$price=4;
}else if($type='Video Cassette'){
$price=3;
}
//Date retour
$query5 = "SELECT datediff(date_retour,date_loc) AS ecart, duree FROM location WHERE id_location='".$idlocR."' AND id_support='".$idsup."' LIMIT 1";
$res5 = $cn->query($query5) or die("Erreur de calcul de date_diff");
while($tab5= mysqli_fetch_assoc($res5)){
$ecart = $tab5['ecart'];
$period = $tab5['duree'];
}
if($ecart > $period) {
$plus = $ecart - $period;
$price = $price + (2 * $plus);
}
$query6= "UPDATE location SET prix= ".$price." WHERE id_location = '".$idlocR."'";
$res6 = $cn->query($query6) or die("Erreur de mise a jour du prix");
echo "<p>La Restitution c'est bien passee</p>";
echo "<p><a href='index.php'>Retour a l'accueil</a></p>";
echo "<p><a href='tables.php'>Retour aux tables</a></p>";
}
}
/*
$query = "UPDATE LOCATION SET mag_retour='".$idmagR."', date_retour='".$dateR."' WHERE id_location = '".$idlocR."'";
$res = $cn->query($query);
$query2 = "SELECT id_support FROM location WHERE id_location = '".$idlocR."'";
$res2 = $cn->query($query2);
$tab = null;
while($tab =mysqli_fetch_assoc($res2)){
$idsup = $tab['id_support'];
}
$query3 = "INSERT INTO en_magasin(id_supp,id_mag) VALUES ('".$idsup."', '".$idmagR."')";
$res3 = $cn->query($query3);
echo "<p>La Restitution c'est bien passee</p>";
echo "<p><a href='index.php'>Retour a l'accueil</a></p>";
echo "<p><a href='tables.php'>Retour aux tables</a></p>";
*/
?>
</body>
</html>