Newer
Older
private $db;
private $art;
private $error = 0;
private $meldung;
private $array = array();
function __construct(){
global $datenbank;
$this->db = $datenbank;
}
public function set_art($art){
if($art == 'user'){ $this->art = B_US;}
if($art == 'admin'){ $this->art = B_AD;}
}
private function make_array($post){
foreach($post AS $key => $value){
if($key != '' && $key != 'run' && $value != ''){
$this->array[$this->db->escape($key)] = $this->db->escape($value);
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
}
}
}
private function select($id){
$aus = '
<select name="sichtbar" class="form-control">
<option value="0"'; if($id == 0){ $aus .= 'selected="selected';} $aus .= '>nicht sichtbar</option>
<option value="1"'; if($id == 1){ $aus .= 'selected="selected';} $aus .= '>User</option>
<option value="2"'; if($id == 2){ $aus .= 'selected="selected';} $aus .= '>Gäste/User</option>
</select>';
return $aus;
}
public function Liste(){
$aus = '
<ul class="list-group">
<li class="list-group-item">
<div class="row">
<div class="col-md-4">Name der Box</div>
<div class="col-md-4">Ordnungszahl</div>
<div class="col-md-4"></div>
</div>
</li>
';
foreach($this->db->get_results("SELECT * FROM ". PREFIX . $this->art ." ") AS $res){
$aus .= '
<li class="list-group-item">
<form method="post" action="">
<input type="hidden" name="id" value="'.$res->id.'">
<div class="row">
<div class="col"><input type="text" class="form-control" name="name" value="'.$res->name.'"></div>
<div class="col"><input type="number" class="form-control" name="ordnung" size="3" value="'.$res->ordnung.'"></div>';
if($this->art == 'box_user'){ $aus .= '<div class="col-md-3">'. $this->select($res->sichtbar) .'</div>';}
$aus .= '
<div class="col text-center">
<input type="submit" class="btn btn-success glyphicon glyphicon-ok-circle" name="run['.$this->art.'_box_aendern]" value="Ändern">
<input type="submit" class="btn btn-danger glyphicon glyphicon-remove-circle" name="run['.$this->art.'_box_loschen]" value="Löschen">
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
</div>
</div>
</form>
</li>
';
}
$aus .= '</ul>';
return $aus;
}
private function SaveDB(){
if($this->db->update(PREFIX . $this->art, $this->array, array("id" => $this->array['id'])) == true){
$this->meldung = BOX_EDIT_TRUE;
}else{
$this->error = 1;
$this->meldung = BOX_EDIT_FALSE;
}
}
public function Edit($post){
$this->make_array($post);
$this->SaveDB();
meldung($this->error,$this->meldung);
}
public function Save($post){
$this->make_array($post);
$this->AddDB();
meldung($this->error,$this->meldung);
}
public function Delete($post){
$this->make_array($post);
if(!isset($array['uid'])){ $array['uid'] = 0;}
$this->DeleteDB();
meldung($this->error,$this->meldung);
}
private function DeleteDB(){
if($this->db->delete(PREFIX . $this->art, array("id" => $this->array['id']),1) == true){
$this->meldung = BOX_DELETE_TRUE;
}else{
$this->error = 1;
$this->meldung = BOX_DELETE_FALSE;
}
}
private function AddDB(){
if($this->db->insert(PREFIX . $this->art, $this->array) == true){
$this->meldung = BOX_SAVE_TRUE;
}else{
$this->error = 1;
$this->meldung = BOX_SAVE_FALSE;
}
}
}