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
|
<?php
//
// List of surveys
//
// $Id: surveys.php,v 1.4 2007-03-12 14:51:43 mha Exp $
//
class Admin_Surveys extends Admin_BasePage {
function __construct() {
$this->content_template = 'admin/surveys.html';
}
function Render() {
global $_SETTINGS;
global $_LANGUAGES;
if (isset($_GET['action']) && $_GET['action'] == 'delete') {
$this->pg_query_params("DELETE FROM surveys WHERE id=$1", array($_GET['id']));
header('Location: /admin/surveys.php');
exit(0);
}
$rs = $this->pg_query(
"SELECT s.id, s.respondants, s.current, q.question, q.language,\n" .
" EXTRACT(EPOCH FROM q.modified) AS modified\n" .
"FROM surveys s, survey_questions q\n" .
"WHERE s.id = q.surveyid\n" .
"ORDER BY s.id DESC"
);
$surveys = array();
$surveyLangs = array();
$surveyId = -1;
for ($i = 0, $rows = pg_num_rows($rs); $i < $rows; $i++) {
$ary = pg_fetch_array($rs, $i, PGSQL_ASSOC);
if ($surveyId != $ary['id']) {
$surveys[] = array(
'id' => $ary['id'],
'respondents' => $ary['respondants'],
'current' => $ary['current']
);
}
$surveyId = $ary['id'];
if ($ary['language'] == $_SETTINGS['defaultlanguage']) {
$surveys[count($surveys) - 1]['question'] = $ary['question'];
}
$surveyLangs[$surveyId][$ary['language']] = $ary['modified'];
}
foreach ($surveys as $item) {
$langs = $surveyLangs[$item['id']];
foreach ($_LANGUAGES as $handler => $name) {
if ($handler != $_SETTINGS['defaultlanguage']) {
$this->tpl->setVariable(array(
'lang_name' => $name,
'lang_handler' => $handler,
'lang_exists' => !empty($surveyLangs[$item['id']][$handler])? 't': 'f',
'lang_up2date' => (empty($langs[$handler]) || $langs[$handler] >= $langs[$_SETTINGS['defaultlanguage']])? 't': 'f'
));
$this->tpl->parse('surveys_translations_loop');
}
}
$this->tpl->setVariable($item);
$this->tpl->parse('surveys_loop');
}
}
}
?>
|
