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 |
|