$sth->execute($itemnumber);
my $data = $sth->fetchrow_hashref;
return unless $data;
+ $data->{issuedate_sql} = $data->{issuedate};
+ $data->{date_due_sql} = $data->{date_due};
$data->{issuedate} = dt_from_string($data->{issuedate}, 'sql');
$data->{issuedate}->truncate(to => 'minute');
$data->{date_due} = dt_from_string($data->{date_due}, 'sql');
var my_table = $("#requestspecific").dataTable($.extend(true, {}, dataTablesDefaults, {
'bPaginate': false,
"sDom": '<"top pager"ilf>t',
+ "aoColumnDefs": [
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
+ ]
}));
//Override fieldset styling for dataTables search box
[% IF itemdata_enumchron %]
<th>Vol no.</th>
[% END %]
- <th>Information</th>
+ <th class="title-string">Information</th>
</tr>
</thead>
<tbody>
</td>
[% END %]
<td>
- [% IF ( itemloo.onloan ) %]
- <span class="checkedout">Due [% itemloo.date_due %]</span>
+ [% IF ( itemloo.onloan ) %]
+ <span title="[% itemloo.date_due %]" class="checkedout">Due [% itemloo.date_due | $KohaDates as_due_date => 1 %]</span>
[% ELSE %]
- [% IF ( itemloo.transfertwhen ) %]
- In transit from [% itemloo.transfertfrom %],
- to [% itemloo.transfertto %], since [% itemloo.transfertwhen %]
- [% END %]
- [% END %]
+ <span title="0000-00-00">
+ [% IF ( itemloo.transfertwhen ) %]
+ In transit from [% itemloo.transfertfrom %],
+ to [% itemloo.transfertto %], since [% itemloo.transfertwhen %]
+ [% END %]
+ </span>
+ [% END %]
[% IF ( itemloo.message ) %]
Unavailable (lost or missing)
# change the background color
my $issues= GetItemIssue($itemnumber);
if ( $issues->{'date_due'} ) {
- $item->{date_due} = format_sqldatetime($issues->{date_due});
+ $item->{date_due} = $issues->{date_due_sql};
$item->{backgroundcolor} = 'onloan';
}