|
Lines 113-140
if (!$loggedinuser) {
Link Here
|
| 113 |
# Showing search history |
113 |
# Showing search history |
| 114 |
} else { |
114 |
} else { |
| 115 |
|
115 |
|
| 116 |
my $date = C4::Dates->new(); |
116 |
my $date = C4::Dates->new(); |
| 117 |
my $dateformat = $date->DHTMLcalendar() . " %H:%i:%S"; # Current syspref date format + standard time format |
117 |
my $dateformat = $date->DHTMLcalendar() . " %H:%i:%S"; # Current syspref date format + standard time format |
| 118 |
|
118 |
|
| 119 |
# Getting the data with date format work done by mysql |
119 |
# Getting the data with date format work done by mysql |
| 120 |
my $query = "SELECT userid, sessionid, query_desc, query_cgi, total, DATE_FORMAT(time, \"$dateformat\") as time FROM search_history WHERE userid = ? AND sessionid = ?"; |
120 |
my $query = "SELECT userid, sessionid, query_desc, query_cgi, limit_desc, limit_cgi, total, DATE_FORMAT(time, \"$dateformat\") as time FROM search_history WHERE userid = ? AND sessionid = ?"; |
| 121 |
my $sth = $dbh->prepare($query); |
121 |
my $sth = $dbh->prepare($query); |
| 122 |
$sth->execute($loggedinuser, $cgi->cookie("CGISESSID")); |
122 |
$sth->execute( $loggedinuser, $cgi->cookie("CGISESSID") ); |
| 123 |
my $searches = $sth->fetchall_arrayref({}); |
123 |
my $searches = $sth->fetchall_arrayref( {} ); |
| 124 |
$template->param(recentSearches => $searches); |
124 |
$template->param( recentSearches => $searches ); |
| 125 |
|
125 |
|
| 126 |
# Getting searches from previous sessions |
126 |
# Getting searches from previous sessions |
| 127 |
$query = "SELECT COUNT(*) FROM search_history WHERE userid = ? AND sessionid != ?"; |
127 |
$query = "SELECT COUNT(*) FROM search_history WHERE userid = ? AND sessionid != ?"; |
| 128 |
$sth = $dbh->prepare($query); |
128 |
$sth = $dbh->prepare($query); |
| 129 |
$sth->execute($loggedinuser, $cgi->cookie("CGISESSID")); |
129 |
$sth->execute( $loggedinuser, $cgi->cookie("CGISESSID") ); |
| 130 |
|
130 |
|
| 131 |
# If at least one search from previous sessions has been performed |
131 |
# If at least one search from previous sessions has been performed |
| 132 |
if ($sth->fetchrow_array > 0) { |
132 |
if ( $sth->fetchrow_array > 0 ) { |
| 133 |
$query = "SELECT userid, sessionid, query_desc, query_cgi, total, DATE_FORMAT(time, \"$dateformat\") as time FROM search_history WHERE userid = ? AND sessionid != ?"; |
133 |
$query = "SELECT userid, sessionid, query_desc, query_cgi, limit_desc, limit_cgi, total, DATE_FORMAT(time, \"$dateformat\") as time FROM search_history WHERE userid = ? AND sessionid != ?"; |
| 134 |
$sth = $dbh->prepare($query); |
134 |
$sth = $dbh->prepare($query); |
| 135 |
$sth->execute($loggedinuser, $cgi->cookie("CGISESSID")); |
135 |
$sth->execute( $loggedinuser, $cgi->cookie("CGISESSID") ); |
| 136 |
my $previoussearches = $sth->fetchall_arrayref({}); |
136 |
my $previoussearches = $sth->fetchall_arrayref( {} ); |
| 137 |
$template->param(previousSearches => $previoussearches); |
137 |
$template->param( previousSearches => $previoussearches ); |
| 138 |
|
138 |
|
| 139 |
} |
139 |
} |
| 140 |
|
140 |
|