/
action.delete.php
121 lines (93 loc) · 3.03 KB
/
action.delete.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
<?php
if (!isset($gCms)) exit;
//debug_display($params, 'Parameters');
if (!$this->CheckPermission('Use Commandes'))
{
$params = array('message'=>Lang('needpermission'), 'active_tab' => 'commandesfournisseurs');
$this->Redirect($id, 'defaultadmin','', $params);
}
$error = 0;
$designation = '';
$commande_number = '';
if (isset($params['commande_number']) && $params['commande_number'] != '')
{
$commande_number = $params['commande_number'];
}
$record_id = '';
if (isset($params['record_id']) && $params['record_id'] != '')
{
$record_id = $params['record_id'];
}
$bdd = '';
if(isset($params['bdd']) && $params['bdd'] !='')
{
$bdd = $params['bdd'];
}
else
{
$error++;
}
if ($error==0)
{
switch($bdd)
{
case "cc_items" :
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_cc_items WHERE id = ?";
$dbresult = $db->Execute($query, array($record_id));
if(!$dbresult)
{
$designation.= $db->ErrorMsg();
}
else
{
//on envoie un message à l'utilisateur ?
$designation.="Résultat supprimé";
$this->SetMessage("$designation");
$this->Redirect($id,'defaultadmin',$returnid);
}
break;
case "cc" :
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_cc WHERE commande_number = ?";
$dbresult = $db->Execute($query, array($commande_number));
if(!$dbresult)
{
$designation.= $db->ErrorMsg();
}
else
{
$designation.= "Commande supprimée. ";
//on supprime aussi les items de cette commande
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_cc_items WHERE commande_number = ?";
$dbresult = $db->Execute($query, array($commande_number));
$designation.= "Articles de la commande supprimés ";
}
//$designation.="Résultat supprimé";
$this->SetMessage("$designation");
$this->RedirectToAdminTab('commandesclients');
break;
case "item" :
//Now remove the article
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_items WHERE id = ?";
$db->Execute($query, array($record_id));
$this->SetMessage('Article supprimé');
$this->RedirectToAdminTab('articles');
break;
case "cf" :
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_cf WHERE commande_number = ?";
$db->Execute($query, array($record_id));
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_cf_items WHERE id_CF = ?";
$db->Execute($query, array($record_id));
$designation = "Commande supprimée - articles en attente de commande";
$this->SetMessage("$designation");
$this->RedirectToAdminTab('commandesfournisseurs');
break;
case "stock" :
$query = "DELETE FROM ".cms_db_prefix()."module_commandes_stock WHERE id = ?";
$db->Execute($query, array($record_id));
$designation = "Stock modifié";
$this->SetMessage("$designation");
$this->RedirectToAdminTab('stock');
break;
}
}
?>