forked from mkucej/i-librarian
/
rename_journal.php
154 lines (125 loc) · 6.51 KB
/
rename_journal.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
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
<?php
include_once 'data.php';
if (isset($_SESSION['auth']) && isset($_SESSION['permissions']) && ($_SESSION['permissions'] == 'A' || $_SESSION['permissions'] == 'U')) {
include_once 'functions.php';
database_connect(IL_DATABASE_PATH, 'library');
if (!empty($_GET['details'])) {
$dbHandle->sqliteCreateFunction('levenshtein', 'sqlite_levenshtein', 2);
if (!empty($_GET['journal'])) {
$journal_query = $dbHandle->quote($_GET['journal']);
$result = $dbHandle->query("SELECT journal,count(*) FROM library WHERE levenshtein(upper(journal), upper($journal_query)) < 4 GROUP BY journal");
print '<b>Possible variants:</b>';
while ($jour = $result->fetch(PDO::FETCH_ASSOC)) {
if (!empty($jour['journal'])) {
print '<br><button class="rename-journal-button" style="margin:1px"><i class="fa fa-pencil"></i></button> ';
print '<span>' . htmlspecialchars($jour['journal']) . '</span> (' . $jour['count(*)'] . ')';
}
}
$result = null;
$result = $dbHandle->query("SELECT secondary_title,count(*) FROM library WHERE journal=$journal_query GROUP BY secondary_title");
print '<br><b>Associated secondary titles:</b>';
while ($jour = $result->fetch(PDO::FETCH_ASSOC)) {
if (!empty($jour['secondary_title'])) {
print '<br><button class="rename-secondary-title-button" style="margin:1px"><i class="fa fa-pencil"></i></button> ';
print '<span>' . htmlspecialchars($jour['secondary_title']) . '</span> (' . $jour['count(*)'] . ')';
}
}
}
if (!empty($_GET['secondary_title'])) {
$journal_query = $dbHandle->quote($_GET['secondary_title']);
$result = $dbHandle->query("SELECT secondary_title,count(*) FROM library WHERE levenshtein(upper(secondary_title), upper($journal_query)) < 4 GROUP BY secondary_title");
print '<b>Possible variants:</b>';
while ($jour = $result->fetch(PDO::FETCH_ASSOC)) {
if (!empty($jour['secondary_title'])) {
print '<br><button class="rename-secondary-title-button" style="margin:1px"><i class="fa fa-pencil"></i></button> ';
print '<span>' . htmlspecialchars($jour['secondary_title']) . '</span> (' . $jour['count(*)'] . ')';
}
}
$result = null;
$result = $dbHandle->query("SELECT journal,count(*) FROM library WHERE secondary_title=$journal_query GROUP BY journal");
print '<br><b>Associated journal abbreviations:</b>';
while ($jour = $result->fetch(PDO::FETCH_ASSOC)) {
if (!empty($jour['journal'])) {
print '<br><button class="rename-journal-button" style="margin:1px"><i class="fa fa-pencil"></i></button> ';
print '<span>' . htmlspecialchars($jour['journal']) . '</span> (' . $jour['count(*)'] . ')';
}
}
}
die();
}
if (!empty($_GET['change_journal'])) {
if (!empty($_GET['new_journal']) && !empty($_GET['old_journal'])) {
if (!empty($_GET['parent_secondary_title'])) {
$parent_query = $dbHandle->quote($_GET['parent_secondary_title']);
$parent_query = 'secondary_title=' . $parent_query;
} elseif (!empty($_GET['parent_journal'])) {
$parent_query = $dbHandle->quote($_GET['parent_journal']);
$parent_query = 'journal=' . $parent_query;
}
$old_journal_query = $dbHandle->quote($_GET['old_journal']);
$new_journal_query = $dbHandle->quote($_GET['new_journal']);
$dbHandle->exec("UPDATE library SET journal=" . $new_journal_query
. " WHERE journal=" . $old_journal_query . " AND " . $parent_query);
}
if (!empty($_GET['new_secondary_title']) && !empty($_GET['old_secondary_title'])) {
if (!empty($_GET['parent_secondary_title'])) {
$parent_query = $dbHandle->quote($_GET['parent_secondary_title']);
$parent_query = 'secondary_title=' . $parent_query;
} elseif (!empty($_GET['parent_journal'])) {
$parent_query = $dbHandle->quote($_GET['parent_journal']);
$parent_query = 'journal=' . $parent_query;
}
$old_secondary_title_query = $dbHandle->quote($_GET['old_secondary_title']);
$new_secondary_title_query = $dbHandle->quote($_GET['new_secondary_title']);
$dbHandle->exec("UPDATE library SET secondary_title=" . $new_secondary_title_query
. " WHERE secondary_title=" . $old_secondary_title_query . " AND " . $parent_query);
}
die();
}
$result = $dbHandle->query("SELECT DISTINCT journal,secondary_title FROM library");
$dbHandle = null;
$journal = array();
$secondary_title = array();
$result->bindColumn(1, $jour);
$result->bindColumn(2, $sec);
while ($result->fetch(PDO::FETCH_BOUND)) {
if (!empty($jour))
$journal[] = $jour;
if (!empty($sec))
$secondary_title[] = $sec;
}
$journal = array_unique($journal);
natcasesort($journal);
$secondary_title = array_unique($secondary_title);
natcasesort($secondary_title);
?>
<form action="rename_journal.php" method="GET" id="rename-journal-form">
<table style="width:100%">
<tr>
<td class="details alternating_row"><b>Consolidate journal names. Click on a journal name to see options.</b></td>
</tr>
</table>
<div id="edit-journal-list" style="width:48%;float:left;padding:4px">
<b>Journal abbreviations:</b>
<?php
while (list($key, $value) = each($journal)) {
print PHP_EOL . '<div class="journal-name">' . htmlspecialchars($value) . '</div>';
}
reset($journal);
?>
</div>
<div id="edit-secondary-title-list" style="width:48%;float:left;padding:4px">
<b>Secondary titles (full journal names):</b>
<?php
while (list($key, $value) = each($secondary_title)) {
print PHP_EOL . '<div class="journal-name">' . htmlspecialchars($value) . '</div>';
}
reset($secondary_title);
?>
</div>
</form>
<?php
} else {
print 'Super User or User permissions required.';
}
?>