Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F82635244
finished.php.wml
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Thu, Sep 12, 13:40
Size
5 KB
Mime Type
text/x-c
Expires
Sat, Sep 14, 13:40 (2 d)
Engine
blob
Format
Raw Data
Handle
20724691
Attached To
R3600 invenio-infoscience
finished.php.wml
View Options
## $Id$
## This file is part of the CERN Document Server Software (CDSware).
## Copyright (C) 2002 CERN.
##
## The CDSware is free software; you can redistribute it and/or
## modify it under the terms of the GNU General Public License as
## published by the Free Software Foundation; either version 2 of the
## License, or (at your option) any later version.
##
## The CDSware is distributed in the hope that it will be useful, but
## WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
## General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with CDSware; if not, write to the Free Software Foundation, Inc.,
## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
#include "configbis.wml"
<?
require("<LIBDIR>/php/cdsware/websubmit/commonPhpFunctions.php");
?>
#include "cdspage.wml" \
title="My Completed Submissions" \
navbar_name="main" \
navbar_select="finished" \
cdspageboxlefttopadd="<protect><?displayLoginMenu('submit');?></protect>"
<?
<protect>
## $Id$
## DO NOT EDIT THIS FILE! IT WAS AUTOMATICALLY GENERATED FROM CDSware WML SOURCES.
// database connection
connectDB(DOCS_DATABASE);
$formnb = 1;
?>
<BR>
<SMALL>
<STRONG class=headline>Notice:</STRONG><BR>
You will find here the list of all the actions you made through CDS WebSubmit and which were completed.
</SMALL>
<BR><BR>
<TABLE>
<TR>
<TD>
<?
// request order
// default value
$reqorder = "sbmSUBMISSIONS.md DESC, lactname";
// requested value
if ($order == "actiondown")
$reqorder = "lactname ASC, sbmSUBMISSIONS.md DESC";
elseif ($order == "actionup")
$reqorder = "lactname DESC, sbmSUBMISSIONS.md DESC";
elseif ($order == "refdown")
$reqorder = "reference ASC, sbmSUBMISSIONS.md DESC, lactname DESC";
elseif ($order == "refup")
$reqorder = "reference DESC, sbmSUBMISSIONS.md DESC, lactname DESC";
elseif ($order == "cddown")
$reqorder = "sbmSUBMISSIONS.cd DESC, lactname";
elseif ($order == "cdup")
$reqorder = "sbmSUBMISSIONS.cd ASC, lactname";
elseif ($order == "mddown")
$reqorder = "sbmSUBMISSIONS.md DESC, lactname";
elseif ($order == "mdup")
$reqorder = "sbmSUBMISSIONS.md ASC, lactname";
if (!AUTHENTICATION || $uid_email == "guest" || $uid_email == "")
print "<font color=red size=+1>You first have to login before using"
. " this feature. Use the left menu to log in.</font>";
else
{
$res = mysql_query("
SELECT sbmSUBMISSIONS.*
FROM sbmSUBMISSIONS,
sbmACTION
WHERE sactname=action and
email='$uid_email' and
status='finished' and
id!=''
ORDER BY doctype,$reqorder");
$currentdoctype = "";
$currentaction = "";
$num = 0;
print "<TABLE border=0>";
while ($row = mysql_fetch_array($res))
{
if ($currentdoctype != $row['doctype'])
{
$currentdoctype = $row['doctype'];
$currentaction = "";
$res2 = mysql_query("
SELECT ldocname
FROM sbmDOCTYPE
WHERE sdocname='$currentdoctype'");
$row2 = mysql_fetch_row($res2);
$ldocname = $row2[0];
print "<TR><TD colspan=5> </TD></TR>\n";
print "<TR><TD colspan=5 class=headerselected align=center>"
. "<b>$ldocname</b></td></tr>";
print "<tr><th class=headerselected>Action "
. "<a href=finished.php?order=actiondown>"
. "<img src=$IMAGES/smalldown.gif border=0></a> "
. "<a href=finished.php?order=actionup>"
. "<img src=$IMAGES/smallup.gif border=0></a></th>"
. "<th class=headerselected>id</th><th class=headerselected>"
. "reference "
. "<a href=finished.php?order=refdown>"
. "<img src=$IMAGES/smalldown.gif border=0></a> "
. "<a href=finished.php?order=refup>"
. "<img src=$IMAGES/smallup.gif border=0></a></th>"
. "<th class=headerselected>first access "
. "<a href=finished.php?order=cddown>"
. "<img src=$IMAGES/smalldown.gif border=0></a> "
. "<a href=finished.php?order=cdup>"
. "<img src=$IMAGES/smallup.gif border=0></a></th>"
. "<th class=headerselected>last access "
. "<a href=finished.php?order=mddown>"
. "<img src=$IMAGES/smalldown.gif border=0></a> "
. "<a href=finished.php?order=mdup>"
. "<img src=$IMAGES/smallup.gif border=0></a></th></tr>\n";
}
if ($currentaction != $row['action'])
{
$currentaction = $row['action'];
$res2 = mysql_query("
SELECT lactname
FROM sbmACTION
WHERE sactname='$currentaction'");
$row2 = mysql_fetch_row($res2);
$lactname = $row2[0];
}
else
$lactname = "\"";
$row['cd'] = str_replace(" "," ",$row['cd']);
$row['md'] = str_replace(" "," ",$row['md']);
if ($row['reference'] == "")
$row['reference'] = "<font color=red>not yet given</font>\n";
if ((int)($num/2) == $num/2)
print "<TR bgcolor=\"#e0e0e0\">\n";
else
print "<TR bgcolor=\"#eeeeee\">\n";
print "<td align=center><small>$lactname</small></td><td><small>"
. $row['id']."</small></td><td><small> ".$row['reference']
. "</small></td><td><small>".$row['cd']."</small></td><td><small>"
. $row['md']."</small></td></tr>";
$num++;
}
print "</table>";
}
?>
</TD>
</TR>
</TABLE>
</protect>
Event Timeline
Log In to Comment