-
Notifications
You must be signed in to change notification settings - Fork 0
/
report.php
executable file
·184 lines (170 loc) · 8.34 KB
/
report.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
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
<?php
require_once('db.php');
require_once('header.php');
if (!empty($_REQUEST['author_id'])) {
$author_id = $_REQUEST['author_id'];
///////////////////////////////////////////////////////////////////////
$query = "SELECT name FROM person WHERE id = '$author_id'";
$result = $selfarchive_dbconnect->query($query) or die($selfarchive_dbconnect->error.__LINE__);
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$author_name = $row['name'];
}
}
else {
echo 'No Results Found.';
}
///////////////////////////////////////////////////////////////////////
?>
<div id="page_content">
<div id="report_tools" class="row">
<h4>Report Tools</h4>
<button id="generate_report" class="btn btn-small" onclick="window.location='generate_report.php?author_id=<?php echo $author_id; ?>'">Generate Report</button>
<img id="generate_loading" src="loader.gif" />
<script type="text/javascript">
$('#generate_report').click( function() {
$('#generate_loading').fadeIn();
});
</script>
<button class="btn btn-small disabled" >Merge Journal Titles (soon)</button>
</div>
<div id="report_body">
<h4>Overview</h4><a id="show_overview" href="#" onclick="return false">[click to expand]</a>
<script type="text/javascript">
//expands overview text
$('#show_overview').click(function () {
$('#overview_text').slideDown(750);
$('#show_overview').hide();
});
</script>
<hr>
<div id="overview_text" class="report_copy">
<p>Journal publishers have different policies regarding author archiving in institutional repositories like Digital Commons@WSU. This document details the versions of your publications that can be archived Digital Commons@WSU. For example, one publisher may allow their final PDF to be deposited, while others specify the final submission manuscript (referred to as the post-print) may only be deposited.</p>
<p>Books and book chapters require contacting publishers directly. After we determine who to contact, we will pursue permissions for these materials by contacting publishers on your behalf and asking for permission to deposit to Digital Commons.</p>
<p>Conference papers and presentation are all eligible to be archived. Please let me know if you'd like to make any of those deposited to Digital Commons.</p>
<h5>Next Steps</h5>
<p>The following lists (next page) organize your publications according to the version permissible for depositing to DigitalCommons@WSU. A few notes:</p>
<ul style="list-style-type:circle;">
<li>Permissions checks were only conducted for journal articles. We will have to directly contact publishers to get permissions for book chapters.</li>
</br>
<li>PDF's are separated into two lists based on what is electronically available to me. For publications you do not have PDF copies of, please indicate, we can scan if you have a print copy available.</li>
</br>
<li>Where publisher information is unknown for a journal article, we will submit a permissions letter – a basic template of this letter is attached at the end of this document. Please confirm that you would like us to pursue this on your behalf.</li>
</ul>
</div>
<h4>Publications</h4>
<hr>
<div id="publications_text" class="report_copy">
<div id="pub_citations" class="citations">
<h5>Publisher's PDF</h5>
<p>We will obtain the PDF and deposit immediately.</p>
<?php
/////////Publisher /////////////////////////////////////////////////////
$query = "SELECT id, citation, jtitle, issn FROM citations WHERE (person_id = '$author_id' AND report_choice = 'publisher')";
$result = $selfarchive_dbconnect->query($query) or die($selfarchive_dbconnect->error.__LINE__);
if($result->num_rows > 0) {
$i = 0;
while($row = $result->fetch_assoc()) {
if($i%2 == 0) {
echo "<div class='cite_dark'>";
}
else {
echo "<div class='cite_light'>";
}
echo "<div class='cite_text_box' id='{$row['id']}'>";
echo $row['citation'];
echo "</div>";
echo "<div class='cite_edit small'><ul class='inline-list'><li><a href='http://www.sherpa.ac.uk/romeo/search.php?issn={$row['issn']}'><em>{$row['jtitle']}:</em></a></li>";
echo "<li><a class='green' href='#' onclick='editCitation($author_id,{$row['id']});'>edit</a></li>";
echo "<li><a class='red' href='delete.php?citation_num={$row['id']}&author_id=$author_id'>delete</a></li>";
echo "</ul></div>";
echo "</div>";
// move the counter
$i++;
}
}
else {
echo 'No Results Found.';
}
///////////////////////////////////////////////////////////////////////
?>
</div>
<div id="post_ctations" class="citations">
<h5>Post-Print/Final Submission Manuscript</h5>
<p>Please send us the final submission manuscript for each, we will re-format and deposit this file. We can also provide digitization services for post-print documents, or in some cases, create a document for self-archiving from the published version.<p>
<?php
/////////PostPrint /////////////////////////////////////////////////////
$query = "SELECT id, citation, jtitle, issn FROM citations WHERE (person_id = '$author_id' AND report_choice = 'postprint')";
$result = $selfarchive_dbconnect->query($query) or die($selfarchive_dbconnect->error.__LINE__);
if($result->num_rows > 0) {
$i = 0;
while($row = $result->fetch_assoc()) {
if($i%2 == 0) {
echo "<div class='cite_dark'>";
}
else {
echo "<div class='cite_light'>";
}
echo "<div class='cite_text_box' id='{$row['id']}'>";
echo $row['citation'];
echo "</div>";
echo "<div class='cite_edit small'><ul class='inline-list'><li><a href='http://www.sherpa.ac.uk/romeo/search.php?issn={$row['issn']}'><em>{$row['jtitle']}:</em></a></li>";
echo "<li><a class='green' href='#' onclick='editCitation($author_id,{$row['id']});'>edit</a></li>";
echo "<li><a class='red' href='delete.php?citation_num={$row['id']}&author_id=$author_id'>delete</a></li>";
echo "</ul></div>";
echo "</div>";
// move the counter
$i++;
}
}
else {
echo 'No Results Found.';
}
///////////////////////////////////////////////////////////////////////
?>
</div>
<div id="pre_citations" class="citations">
<h5>Pre-Prints</h5>
<?php
/////////PrePrint /////////////////////////////////////////////////////
$query = "SELECT id, citation, jtitle, issn FROM citations WHERE (person_id = '$author_id' AND report_choice = 'preprint')";
$result = $selfarchive_dbconnect->query($query) or die($selfarchive_dbconnect->error.__LINE__);
if($result->num_rows > 0) {
$i = 0;
while($row = $result->fetch_assoc()) {
if($i%2 == 0) {
echo "<div class='cite_dark'>";
}
else {
echo "<div class='cite_light'>";
}
echo "<div class='cite_text_box' id='{$row['id']}'>";
echo $row['citation'];
echo "</div>";
echo "<div class='cite_edit small'><ul class='inline-list'><li><a href='http://www.sherpa.ac.uk/romeo/search.php?issn={$row['issn']}'><em>{$row['jtitle']}:</em></a></li>";
echo "<li><a class='green' href='#' onclick='editCitation($author_id,{$row['id']});'>edit</a></li>";
echo "<li><a class='red' href='delete.php?citation_num={$row['id']}&author_id=$author_id'>delete</a></li>";
echo "</ul></div>";
echo "</div>";
// move the counter
$i++;
}
}
else {
echo 'No Results Found.';
}
///////////////////////////////////////////////////////////////////////
?>
</div>
</div> <!--closes publications -->
</div>
</div>
<?php }
else { ?>
<div id="page_content">
<p>Not sure who we are working with, <a href='index.php'>return to author / project selection</a>.</p>
</div>
<?php }
//footer
require_once('footer.php');
?>