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
130
131
|
<?php
//
// Adding / editing an organisation
//
// $Id: $
//
class Admin_OrgEdit extends PgForm {
function __construct() {
$this->navsection = 'admin';
}
function SetupForm() {
if ('POST' != $_SERVER['REQUEST_METHOD']) {
if (isset($_GET['action']) && $_GET['action'] == 'delete') {
if (empty($_GET['id'])) {
throw new Exception('Id not specified');
}
$this->pg_query('DELETE FROM organisations WHERE id=' . intval($_GET['id']));
header('Location: orgs.php');
exit(0);
}
if (isset($_GET['action']) && $_GET['action'] == 'approve') {
if (empty($_GET['id'])) {
throw new Exception('Id not specified');
}
$this->pg_query('UPDATE organisations SET approved = true WHERE id=' . intval($_GET['id']));
header('Location: orgs.php');
exit(0);
}
$defaults = array('lastconfirmed'=>date('Y-m-d H:i'));
if (!empty($_GET['id'])) {
$rs = $this->pg_query(
"SELECT id,name,address,url,email,phone,orgtype,contact,NULLIF(approved,false) AS approved,lastconfirmed FROM organisations WHERE id=" . intval($_GET['id']));
if (pg_num_rows($rs)) {
$defaults = pg_fetch_array($rs, 0, PGSQL_ASSOC);
}
}
$this->form->setDefaults($defaults);
}
$txtf = array('size' => 52);
$txta = array('cols' => 40, 'rows'=>8);
$this->form->addElement('hidden','id');
$this->form->addElement('header',null,'Approval');
$this->form->addElement('checkbox','approved',null,'Is approved (<b>Always</b> verify all HTML content before approving!)');
$this->form->addElement('header',null,'Basic data');
$this->form->addElement('text','name','Name', $txtf);
$this->form->addElement('textarea','address','Address', $txta);
$this->form->addElement('text','url','URL',$txtf);
$this->form->addElement('text','email','Email', $txtf);
$this->form->addElement('text','phone','Phone', $txtf);
$this->form->addElement('select','orgtype','Organisation type',$this->fetch_orgtype_list());
$this->form->addElement('select','contact','Contact user ID (private)',$this->fetch_contact_list());
$this->form->addElement('text','lastconfirmed','Last confirmed', $txtf);
$this->form->applyFilter('__ALL__', 'trim');
$this->form->addRule('name','Name required','required',null,'client');
$this->form->addRule('url','URL required','required',null,'client');
$this->form->addRule('url','URL must be to a webpage','regex','/^https?:\/\//','client');
$this->form->addRule('contact','Contact user ID required','required',null,'client');
$this->form->addRule('lastconfirmed','Last confirmed required','required',null,'client');
}
function ProcessForm($f) {
global $_SETTINGS;
$id = $f['id'];
$f['approved'] = empty($f['approved'])?'f':'t';
unset($f['id']);
$eqns = $keys = $vals = array();
foreach ($f as $key => $val) {
if ($key == 'submit') continue;
$keys[] = $key;
if (empty($val) || $val=='') {
$vals[] = 'NULL';
$eqns[] = $key . ' = NULL';
} else {
$vals[] = "'" . pg_escape_string($val) . "'";
$eqns[] = $key . ' = \'' . pg_escape_string($val) . '\'';
}
}
if (empty($id)) {
$r = $this->pg_query("SELECT nextval('organisations_id_seq')");
list($id) = pg_fetch_row($r,0);
$this->pg_query('INSERT INTO organisations (id,' . implode(', ', $keys) . ") VALUES ({$id}," . implode(', ',$vals) . ')');
} else {
$r = $this->pg_query("SELECT approved FROM organisations WHERE id={$id}");
list($oldapproved) = pg_fetch_row($r,0);
$this->pg_query("UPDATE organisations SET " . implode(', ', $eqns) . " WHERE id={$id}");
if ($oldapproved=='f' && $f['approved']=='t') {
$mailtext = 'Edit: ' . $_SETTINGS['masterserver'] . '/admin/org-edit.php?id=' . $id;
mail($_SETTINGS['notifymail'], 'Organisation ' . $f['name'] . ' was approved by ' . $_SERVER['PHP_AUTH_USER'], $mailtext);
}
}
$this->redirect_relative = '/admin/orgs.php';
}
function RenderThanks() {
}
function fetch_contact_list() {
$rs = $this->pg_query('SELECT userid,CASE WHEN trim(fullname) = \'\' THEN userid ELSE coalesce(fullname,userid) END AS fullname FROM users ORDER BY fullname');
$c = array();
for ($i = 0; $i < pg_num_rows($rs); $i++) {
$row = pg_fetch_array($rs, $i, PGSQL_ASSOC);
$c[$row['userid']] = $row['fullname'];
}
return $c;
}
function fetch_orgtype_list() {
$c = array();
$c['c'] = 'Company';
$c['i'] = 'Individual';
$c['n'] = 'Not for profit';
$c['p'] = 'Open source project';
return $c;
}
}
?>
|
