-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathreport_output.php
executable file
·176 lines (158 loc) · 8 KB
/
report_output.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
<?php
require_once('db.php');
require_once('report_header.php');
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// define function for repeating citation printing
function print_citations($query) {
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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_body">
<h4>Overview</h4>
<hr>
<div id="overview_text_output" 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>"; //closes color 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>
<p>We are currently not archiving these, but perhaps that might change.<p>
<?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');
?>