$sth->execute(@query_params);
my @results;
while (my $data = $sth->fetchrow_hashref) {
- $data->{orderdate} = format_date($data->{orderdate});
- $data->{claimed_date} = format_date($data->{claimed_date});
push @results, $data;
}
return @results;
nullcode => $p->{invoicenumber} eq 'NULL',
emptycode => $p->{invoicenumber} eq q{},
raw_datereceived => $p->{shipmentdate},
- datereceived => format_date( $p->{shipmentdate} ),
+ datereceived => $p->{shipmentdate},
bibcount => $p->{receivedbiblios} || 0,
reccount => $p->{receiveditems} || 0,
itemcount => $p->{itemsexpected} || 0,
<script type="text/javascript" src="[% themelang %]/js/cataloging.js"></script>
<script type="text/JavaScript">
//<![CDATA[
- [% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
- [% END %]
$(document).ready(function() {
- var srlt = $("#files").dataTable($.extend(true, {}, dataTablesDefaults, {
- "aoColumns": [
- null,null,null,{ "sType": "title-string" },null,null
- ],
+ $("#files,#recordst").dataTable($.extend(true, {}, dataTablesDefaults, {
"aoColumnDefs": [
- { "aTargets": [ 5 ], "bSortable": false, "bSearchable": false },
+ { "bSortable": false, "bSearchable": false, 'aTargets': [ 'NoSort' ] },
+ { "sType": "anti-the", "aTargets" : [ "anti-the" ] },
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
],
"sPaginationType": "four_button",
"aaSorting": []
</h1>
<div>
<form action="[% scriptname %]" method="post" name="import_biblios">
- <table>
+ <table id="recordst">
+ <thead>
<tr>
- <th>Citation</th>
+ <th class="anti-the">Citation</th>
<th>Match?</th>
<th>Order</th>
</tr>
+ </thead>
+ <tbody>
[% FOREACH biblio_lis IN biblio_list %]
<tr>
<td>
</tr>
[% END %]
[% END %]
+ </tbody>
</table>
</form>
</div>
<th>File name</th>
<th>Comments</th>
<th>Status</th>
- <th>Staged</th>
+ <th class="title-string">Staged</th>
<th># Bibs</th>
- <th> </th>
+ <th class="NoSort"> </th>
</tr>
</thead>
<tbody>
[% INCLUDE 'datatables.inc' %]
<script type="text/javascript">
//<![CDATA[
-[% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
-[% END %]
$(document).ready(function() {
- var histsearcht = $("#histsearcht").dataTable($.extend(true, {}, dataTablesDefaults, {
+ $("#histsearcht").dataTable($.extend(true, {}, dataTablesDefaults, {
+ "aoColumnDefs": [
+ { "sType": "anti-the", "aTargets" : [ "anti-the" ] },
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
+ ],
"sPaginationType": "four_button"
} ) );
});
<th>Basket</th>
<th>Basket group</th>
<th>Invoice number</th>
- <th>Summary</th>
+ <th class="anti-the">Summary</th>
<th>Vendor</th>
- <th>Placed on</th>
- <th>Received on</th>
+ <th class="title-string">Placed on</th>
+ <th class="title-string">Received on</th>
<th>Quantity received</th>
<th>Pending order</th>
<th>Unit cost</th>
<br />[% order.author %] <br /> [% order.isbn %]
</td>
<td><a href="/cgi-bin/koha/acqui/supplier.pl?booksellerid=[% order.id %]">[% order.name %]</a></td>
- <td>[% order.creationdate | $KohaDates %]</td>
+ <td><span title="[% order.creationdate %]">[% order.creationdate | $KohaDates %]</span></td>
<td>
[% IF order.datereceived %]
- [% order.datereceived | $KohaDates %]
+ <span title="[% order.datereceived %]">[% order.datereceived | $KohaDates %]</span>
+ [% ELSE %]
+ <span title="0000-00-00"></span>
[% END %]
</td>
<td>[% order.quantityreceived %]</td>
[% INCLUDE 'calendar.inc' %]
<script type="text/javascript">
//<![CDATA[
-[% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
-[% END %]
var late_orderst;
function check_uncheck() {
late_orderst = $("#late_orders").dataTable($.extend(true, {}, dataTablesDefaults, {
"aoColumnDefs": [
{ "aTargets": [ 0 ], "bSortable": false, "bSearchable": false },
+ { "sType": "anti-the", "aTargets" : [ "anti-the" ] },
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
],
"sPaginationType": "four_button",
"bAutoWidth": false,
[% ELSE %]
<th></th>
[% END %]
- <th>Order date</th>
- <th>Estimated delivery date</th>
+ <th class="title-string">Order date</th>
+ <th class="title-string">Estimated delivery date</th>
<th>Vendor</th>
- <th>Information</th>
+ <th class="anti-the">Information</th>
<th>Total cost</th>
<th>Basket</th>
<th>Basket group</th>
<th>Library</th>
<th>Fund</th>
<th>Claims count</th>
- <th>Claimed date</th>
+ <th class="title-string">Claimed date</th>
</tr>
</thead>
<tbody>
<input type="checkbox" value="[% lateorder.ordernumber %]" data-booksellerid="[% lateorder.supplierid %]" name="ordernumber">
</td>
<td>
- [% lateorder.orderdate %]
- ([% lateorder.latesince %] days)
+ <span title="[% lateorder.orderdate %]">[% lateorder.orderdate | $KohaDates %] ([% lateorder.latesince %] days)</span>
</td>
<td>
[% IF ( lateorder.estimateddeliverydate ) %]
- [% lateorder.estimateddeliverydate | $KohaDates %]
+ <span title="[% lateorder.estimateddeliverydate %]">[% lateorder.estimateddeliverydate | $KohaDates %]</span>
+ [% ELSE %]
+ <span title="0000-00-00"></span>
[% END %]
</td>
<td>
<td>[% lateorder.budget %]
</td>
<td>[% lateorder.claims_count %]</td>
- <td>[% lateorder.claimed_date %]</td>
+ <td>
+ [% IF ( lateorder.claimed_date ) %]
+ <span title="[% lateorder.claimed_date %]">[% lateorder.claimed_date | $KohaDates %]</span>
+ [% ELSE %]
+ <span title="0000-00-00"></span>
+ [% END %]
+ </td>
</tr>
[% END %]
</tbody>
<li><label for="booksellerid">Vendor:</label>
<select id="booksellerid" size="1" tabindex="" name="booksellerid">
- <option value=""/>
+ <option value=""></option>
[% FOREACH SUPPLIER_LOO IN SUPPLIER_LOOP %]
[% IF ( SUPPLIER_LOO.selected ) %]<option value="[% SUPPLIER_LOO.id %]" selected="selected">[% SUPPLIER_LOO.name %]</option>
[% ELSE %]<option value="[% SUPPLIER_LOO.id %]">[% SUPPLIER_LOO.name %]</option>[% END %]
}
}
- [% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
- [% END %]
$(document).ready(function() {
$("#srlt").dataTable($.extend(true, {}, dataTablesDefaults, {
"aoColumnDefs": [
- [% IF (dateformat == 'metric') %]
- { "aTargets": [ -2 ], "sType": "uk_date" },
- [% END %]
- ],
+ { "bSortable": false, "bSearchable": false, 'aTargets': [ 'NoSort' ] },
+ { "sType": "anti-the", "aTargets" : [ "anti-the" ] },
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
+ ]
} ) )
$("#show_only_renewed").click(function(){
<thead>
<tr>
<th>ISSN</th>
- <th>Title</th>
+ <th class="anti-the">Title</th>
<th> Notes </th>
<th>Library</th>
<th>Call number</th>
- <th>Expiration date</th>
- <th></th>
+ <th class="title-string">Expiration date</th>
+ <th class="NoSort"></th>
</tr>
</thead>
<tbody>
[% IF (sub.callnumber) %][% sub.callnumber %][% END %]
</td>
<td>
- [% IF (sub.enddate) %][% sub.enddate | $KohaDates %][% END %]
+ [% IF (sub.enddate) %]
+ <span title="[% sub.enddate %]">[% sub.enddate | $KohaDates %]</span>
+ [% ELSE %]
+ <span title="0000-00-00"></span>
+ [% END %]
</td>
<td>
[% IF (sub.alreadyOnOrder) %]
[% INCLUDE 'datatables.inc' %]
<script type="text/javascript">
//<![CDATA[
-[% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
-[% END %]
$(document).ready(function() {
- var spent = $("#spent").dataTable($.extend(true, {}, dataTablesDefaults, {
+ $("#spent").dataTable($.extend(true, {}, dataTablesDefaults, {
+ "aoColumnDefs": [
+ { "sType": "anti-the", "aTargets" : [ "anti-the" ] },
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
+ ],
"sPaginationType": "four_button"
} ) );
});
<h1>Fund: [% fund_code %]</h1>
<h2>Ordered</h2>
-<table cellspacing="0" cellpadding="0" border="0" id="spent" class="collapse">
+<table id="spent">
<thead>
<tr>
- <th> Title </th>
+ <th class="anti-the"> Title </th>
<th> Order </th>
<th> Vendor </th>
- <th> Itemtype </th>
+ <th> Item type </th>
<th> Left on order </th>
<th> Estimated cost per unit </th>
- <th> Date ordered </th>
+ <th class="title-string"> Date ordered </th>
<th> Subtotal </th>
</tr>
</thead>
<td class="cell">
[% order.left %]
</td>
- <td class="cell" align="right">
+ <td class="data cell">
[% order.ecost %]
</td>
- <td class="cell" align="right">
- [% order.entrydate | $KohaDates %]
+ <td class="cell">
+ <span title="[% order.entrydate %]">[% order.entrydate | $KohaDates %]</span>
</td>
- <td class="cell" align="right">
+ <td class="data cell">
[% order.subtotal %]
</td>
</tr>
<td> </td>
<td> </td>
<td> </td>
- <td align="right">
+ <td class="data">
[% total %]
</td>
</tr>
<script type="text/javascript">
//<![CDATA[
$(document).ready(function() {
-[% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
-[% END %]
var parcelst = $("#parcelst").dataTable($.extend(true, {}, dataTablesDefaults, {
+ "aoColumnDefs": [
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
+ ],
"sPaginationType": "four_button"
} ) );
<thead>
<tr>
<th>Line</th>
- <th>Date received</th>
+ <th class="title-string">Date received</th>
<th>Invoice number</th>
<th>Item count</th>
<th>Biblio count</th>
[% searchresult.number %]
</td>
<td>
- [% searchresult.datereceived %]
+ <span title="[% searchresult.datereceived %]">[% searchresult.datereceived | $KohaDates %]</span>
</td>
<td>
[% IF ( searchresult.code ) %]
<script type="text/javascript">
//<![CDATA[
$(document).ready(function() {
- [% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
- [% END %]
- var spent = $("#spent").dataTable($.extend(true, {}, dataTablesDefaults, {
+ $("#spent").dataTable($.extend(true, {}, dataTablesDefaults, {
+ "aoColumnDefs": [
+ { "sType": "anti-the", "aTargets" : [ "anti-the" ] },
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
+ ],
"sPaginationType": "four_button"
} ) );
});
<h2>Spent</h2>
-<table cellspacing="0" cellpadding="0" border="0" id="spent" class="collapse">
+<table id="spent">
<thead>
<tr>
- <th> Title </th>
+ <th class="anti-the"> Title </th>
<th> Order </th>
<th> Vendor </th>
<th> Invoice </th>
- <th> Itemtype </th>
+ <th> Item type </th>
<th> Received </th>
<th> Unit price </th>
- <th> Date ordered </th>
- <th> Date received </th>
+ <th class="title-string"> Date ordered </th>
+ <th class="title-string"> Date received </th>
<th> Subtotal </th>
</tr>
</thead>
<td class="cell">
[% order.quantityreceived %]
</td>
- <td class="cell" align="right">
+ <td class="cell">
[% order.unitprice %]
</td>
- <td class="cell" align="right">
- [% order.entrydate | $KohaDates %]
+ <td class="cell">
+ <span title="[% order.entrydate %]">[% order.entrydate | $KohaDates %]</span>
</td>
- <td class="cell" align="right">
- [% order.datereceived | $KohaDates %]
+ <td class="cell">
+ <span title="[% order.datereceived %]">[% order.datereceived | $KohaDates %]</span>
</td>
- <td class="cell" align="right">
+ <td class="data cell">
[% order.rowtotal %]
</td>
</tr>
[% IF shipmentcosts.size %]
<tr valign="top">
<td colspan="9"> Sub total </td>
- <td align="right"> [% subtotal %] </td>
+ <td class="data"> [% subtotal %] </td>
</tr>
[% FOREACH shipmentcost IN shipmentcosts %]
<tr>
<td></td>
<td colspan="8">Shipping cost for invoice [% shipmentcost.invoicenumber %]</td>
- <td class="total">[% shipmentcost.shipmentcost %]</td>
+ <td class="data total">[% shipmentcost.shipmentcost %]</td>
</tr>
[% END %]
[% END %]
<tr>
<td colspan="9">TOTAL</td>
- <td class="total">[% total %]</td>
+ <td class="data total">[% total %]</td>
</tr>
</tfoot>
</table>
}
$(document).ready(function() {
- [% IF (dateformat == 'metric') %]
- dt_add_type_uk_date();
- [% END %]
var contractst = $("#contractst").dataTable($.extend(true, {}, dataTablesDefaults, {
"aoColumnDefs": [
{ "aTargets": [ -1, -2 ], "bSortable": false, "bSearchable": false },
- [% IF (dateformat == 'metric') %]
- { "aTargets": [ 2, 3 ], "sType": "uk_date" },
- [% END %]
+ { "sType": "title-string", "aTargets" : [ "title-string" ] }
],
- 'sDom': 't',
- 'bPaginate': false,
- 'bFilter': false,
- 'bInfo': false,
+ 'sDom': 't'
} ) );
});
//]]>
<tr>
<th scope="col">Name</th>
<th scope="col">Description</th>
- <th scope="col">Start date</th>
- <th scope="col">End date</th>
+ <th scope="col" class="title-string">Start date</th>
+ <th scope="col" class="title-string">End date</th>
<th scope="col"> </th>
<th scope="col"> </th>
</tr>
<a href="/cgi-bin/koha/admin/aqcontract.pl?op=add_form&contractnumber=[% contract.contractnumber %]&booksellerid=[% contract.booksellerid %]">[% contract.contractname %]</a>
</td>
<td>[% contract.contractdescription %]</td>
- <td>[% contract.contractstartdate | $KohaDates %]</td>
- <td>[% contract.contractenddate | $KohaDates %]</td>
+ <td><span title="[% contract.contractstartdate %]">[% contract.contractstartdate | $KohaDates %]</span></td>
+ <td><span title="[% contract.contractenddate %]">[% contract.contractenddate | $KohaDates %]</span></td>
<td><a href="/cgi-bin/koha/admin/aqcontract.pl?op=add_form&contractnumber=[% contract.contractnumber %]&booksellerid=[% contract.booksellerid %]">Edit</a></td>
<td><a href="/cgi-bin/koha/admin/aqcontract.pl?op=delete_confirm&contractnumber=[% contract.contractnumber %]&booksellerid=[% contract.booksellerid %]">Delete</a></td>
</tr>