forked from GIPdA/libreBrigade
-
Notifications
You must be signed in to change notification settings - Fork 0
/
del_vehicule.php
90 lines (70 loc) · 2.77 KB
/
del_vehicule.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
<?php
# project: eBrigade
# homepage: https://ebrigade.app
# version: 5.3
# Copyright (C) 2004, 2021 Nicolas MARCHE (eBrigade Technologies)
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
include_once ("config.php");
check_all(19);
?>
<html>
<SCRIPT language=JavaScript>
function redirect() {
url="vehicule.php?order=TV_USAGE";
self.location.href=url;
}
</SCRIPT>
<?php
$id=$_SESSION['id'];
$V_ID=intval($_GET["V_ID"]);
// verifier les permissions de suppression: on a que le droit sur la section pere et ses descendants
$query="select TV_CODE,V_IMMATRICULATION,V_MODELE,S_ID from vehicule where V_ID=".$V_ID;
$result=mysqli_query($dbc,$query);
$row=mysqli_fetch_array($result);
$S_ID=$row["S_ID"];
$TV_CODE=$row["TV_CODE"];
$V_IMMATRICULATION=$row["V_IMMATRICULATION"];
$V_MODELE=$row["V_MODELE"];
$mysection=$_SESSION['SES_SECTION'];
$mysectionparent=get_section_parent("$mysection");
if (! is_children("$S_ID",$mysectionparent)) {
check_all(24);
}
//=====================================================================
// suppression fiche
//=====================================================================
if ( $V_ID > 0 ) {
insert_log('DELV', 0, $TV_CODE." - ".$V_MODELE." ".$V_IMMATRICULATION);
$query="delete from equipage where V_ID=".$V_ID ;
$result=mysqli_query($dbc,$query);
$query="delete from vehicule where V_ID=".$V_ID ;
$result=mysqli_query($dbc,$query);
$query="delete from evenement_vehicule where V_ID=".$V_ID ;
$result=mysqli_query($dbc,$query);
$query="delete from evenement_piquets_feu where V_ID=".$V_ID ;
$result=mysqli_query($dbc,$query);
$query="delete from log_history where LH_WHAT=".$V_ID."
and LT_CODE in (select LT_CODE from LOG_TYPE where LC_CODE='V')";
$result=mysqli_query($dbc,$query);
$query="update materiel set V_ID=null where V_ID=".$V_ID ;
$result=mysqli_query($dbc,$query);
$query="delete from document where V_ID=".$V_ID ;
$result=mysqli_query($dbc,$query);
$mypath=$filesdir."/files_vehicule/".$V_ID;
if(is_dir($mypath)) {
full_rmdir($mypath);
}
}
echo "<body onload=redirect()>";
?>