From ec64e0807f2e684bc70c1b8652bc07eaea70fd12 Mon Sep 17 00:00:00 2001
From: Tomas Cohen Arazi <tomascohen@theke.io>
Date: Tue, 10 Mar 2020 16:03:50 -0300
Subject: [PATCH] Bug 20212: Use API to render orders datatable

---
 .../prog/en/modules/acqui/parcel.tt           | 381 +++++++++++++++---
 1 file changed, 327 insertions(+), 54 deletions(-)

diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/parcel.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/parcel.tt
index 414844397c..531100cf8c 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/parcel.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/parcel.tt
@@ -34,16 +34,16 @@
         <div class="col-sm-10 col-sm-push-2">
             <main>
 
-	[% IF ( receive_error ) %]
-	<div class="dialog alert">
-	<h3>Error adding items:</h3>
-	<ul>
-	[% FOREACH error_loo IN error_loop %]
-		<li>[% error_loo.error_param | html %][% IF ( error_loo.error_duplicate_barcode ) %]Duplicate Barcode[% END %] <!-- todo: other error conditions come here. --></li>
-	[% END %]
-	</ul>
-	</div>
-	[% END %]
+    [% IF ( receive_error ) %]
+    <div class="dialog alert">
+    <h3>Error adding items:</h3>
+    <ul>
+    [% FOREACH error_loo IN error_loop %]
+        <li>[% error_loo.error_param | html %][% IF ( error_loo.error_duplicate_barcode ) %]Duplicate Barcode[% END %] <!-- todo: other error conditions come here. --></li>
+    [% END %]
+    </ul>
+    </div>
+    [% END %]
     <h1>
         [% IF datereceived %]
             Receipt summary for <i>[% name | html %]</i> [% IF ( invoice ) %] <i> [ [% invoice | html %] ] </i>[% END %] on <i>[% datereceived | $KohaDates %]</i>
@@ -55,12 +55,12 @@
     [% IF ( success_delorder ) %]
     <div class="dialog message">The order has been successfully canceled.</div>
     [% ELSE %]
-	[% IF ( error_delitem ) %]
-	    <div class="dialog alert">The order has been canceled, although one or more items could not have been deleted.</div>
-	[% END %]
-	[% IF ( error_delbiblio ) %]
-	    <div class="dialog alert">The order has been canceled, although the record has not been deleted.</div>
-	[% END %]
+    [% IF ( error_delitem ) %]
+        <div class="dialog alert">The order has been canceled, although one or more items could not have been deleted.</div>
+    [% END %]
+    [% IF ( error_delbiblio ) %]
+        <div class="dialog alert">The order has been canceled, although the record has not been deleted.</div>
+    [% END %]
     [% END %]
 
     [% IF (error_cancelling_receipt) %]
@@ -87,6 +87,26 @@
         </div>
     [% END %]
 
+<h3>Pending orders (api)</h3>
+<table id="pending_orders" class="table table-bordered table-striped">
+    <thead>
+        <tr>
+            <th>Basket</th>
+            <th>Basket group</th>
+            <th>Order line</th>
+            <th>Summary</th>
+            <th>More</th>
+            <th>Replacement price</th>
+            <th>Quantity</th>
+            <th>Unit cost</th>
+            <th>Order cost</th>
+            <th>Fund</th>
+            <th>&nbsp;</th>
+            <th>&nbsp;</th>
+        </tr>
+    </thead>
+</table>
+
 [% UNLESS no_orders_to_display %]
 <div id="acqui_receive_summary">
 <p><strong>Invoice number:</strong> [% invoice | html %] <strong>Received by:</strong> [% logged_in_user.userid | html %] <strong>On:</strong> [% datereceived | $KohaDates %]</p>
@@ -175,32 +195,32 @@
                 <td>[% loop_order.ecost | $Price %]</td>
                 <td>[% loop_order.total | $Price %]</td>
                 <td>[% loop_order.budget_name | html %]</td>
-				<td>
+                <td>
                               <a href="orderreceive.pl?ordernumber=[% loop_order.ordernumber | uri %]&amp;invoiceid=[% invoiceid | uri %]">Receive</a>
                     <br />
                     <a href="#" onclick="transfer_order_popup([% loop_order.ordernumber | html %]); return false;">Transfer</a>
-				</td>
-				<td>
-                        [% IF ( loop_order.left_holds_on_order ) %]
+                </td>
+                <td>
+                        [% IF ( loop_order.left_holds_on_order ) %] [%# DONE %]
                         <span class="button" title="Can't cancel order, ([% loop_order.holds_on_order | html %]) holds are linked with this order. Cancel holds first">Can't cancel order</span><br>
-                        [% ELSE %]
+                        [% ELSE %] [%# DONE %]
                         <a href="/cgi-bin/koha/acqui/cancelorder.pl?ordernumber=[% loop_order.ordernumber | uri %]&biblionumber=[% loop_order.biblionumber | uri %]&referrer=[% "/cgi-bin/koha/acqui/parcel.pl?invoiceid=$invoiceid" | uri %]">Cancel order</a><br />
-                        [% END %]
-                        [% IF ( loop_order.can_del_bib ) %]
+                        [% END %] [%# DONE %]
+                        [% IF ( loop_order.can_del_bib ) %] [%# DONE %]
                         <a href="/cgi-bin/koha/acqui/cancelorder.pl?ordernumber=[% loop_order.ordernumber | uri %]&biblionumber=[% loop_order.biblionumber | uri %]&del_biblio=1&referrer=[% "/cgi-bin/koha/acqui/parcel.pl?invoiceid=$invoiceid" | uri %]">Cancel order and catalog record</a><br />
-                        [% ELSE %]
+                        [% ELSE %] [%# DONE %]
                         <span class="button" title="Can't delete catalog record, see constraints below">Can't cancel order and delete catalog record</span><br>
                         [% END %]
-                        [% IF ( loop_order.left_item ) %]
+                        [% IF ( loop_order.left_item ) %] [%# DONE %]
                         <b title="Can't delete catalog record, because of [% loop_order.items | html %] existing item(s)" >[% loop_order.items | html %] item(s) left</b><br>
                         [% END %]
-                        [% IF ( loop_order.left_biblio ) %]
+                        [% IF ( loop_order.left_biblio ) %]  [%# DONE %]
                         <b title="Can't delete catalog record, delete other orders linked to it first">[% loop_order.biblios | html %] order(s) left</b><br>
                         [% END %]
-                        [% IF ( loop_order.left_subscription ) %]
+                        [% IF ( loop_order.left_subscription ) %] [%# DONE %]
                         <b title="Can't delete catalog record, delete subscriptions first">[% loop_order.subscriptions | html %] subscription(s) left</b><br>
                         [% END %]
-                        [% IF ( loop_order.left_holds ) %]
+                        [% IF ( loop_order.left_holds ) %] [%# DONE %]
                         <b title="Can't delete catalog record or order, cancel holds first">[% loop_order.holds | html %] hold(s) left</b>
                         [% END %]
                     </td>
@@ -365,12 +385,12 @@
                     [% END %]
                 </td>
             </tr>
-	    [% END %]
-	</tbody>
+        [% END %]
+    </tbody>
     </table>
     </form>
 
-	[% ELSE %]There are no received orders.[% END %]
+    [% ELSE %]There are no received orders.[% END %]
 </div>
 
 <div id="dataPreview" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="dataPreviewLabel" aria-hidden="true">
@@ -533,20 +553,273 @@
             }));
           }
 
-          // Keep filters from finishreceive.pl to parcel.pl
-          $.cookie("filter_parcel_summary", $("#summaryfilter").val());
-          $.cookie("filter_parcel_basketname", $("#basketfilter").val());
-          $.cookie("filter_parcel_orderno", $("#orderfilter").val());
-          $.cookie("filter_parcel_basketgroupname", $("#basketgroupnamefilter").val());
-          $.cookie("filter_parcel_ean", $("#eanfilter").val());
 
-          $("#filterform").on('submit', function(){
+            var pending_orders_url = "/api/v1/acquisitions/orders?status=ordered";
+            var pending_orders_table = $("#pending_orders").api({
+                "ajax": {
+                    "url": pending_orders_url
+                },
+                "embed": [
+                    "basket.basket_group",
+                    "biblio.active_orders+count",
+                    "biblio.holds+count",
+                    "biblio.items+count",
+                    "biblio.suggestions.suggester",
+                    "fund",
+                    "current_item_level_holds+count",
+                    "items"
+                ],
+                'dom': 'C<"top pager"ilpfB><"#filter_c">tr<"bottom pager"ip>',
+                "columns": [
+                    { "data": "basket_id",
+                      "orderable": true,
+                      "render": function(data, type, row, meta) {
+                        if (type != 'display') return data;
+                        return "<a href=\"/cgi-bin/koha/acqui/basket.pl?basketno=" + data + "\">" + row.basket.name + " (" + data + ")</a>";
+                    }
+                    },
+                    { "data": function(row, type, val, meta) {
+                        if ( type != 'display' ) return row.basket.basket_group_id;
+                        if ( row.basket.basket_group_id == null ) {
+                            return _("No basket group");
+                        }
+                        else {
+                            return "<a href=\"/cgi-bin/koha/acqui/basketgroup.pl?op=add&amp;booksellerid="
+                                    + row.basket.vendor_id + "&amp;basketgroupid="
+                                    + row.basket.basket_group_id + "\">"
+                                    + row.basket.basket_group.name + " (" + row.basket.basket_group_id + ")</a>";
+                        }
+                      },
+                      "orderable": false // FIXME
+                    },
+                    { "data": "order_id",
+                      "render": function(data, type, row, meta) {
+                        if (type != 'display') return data;
+                        return "<a href=\"neworderempty.pl?ordernumber="+data+"&amp;booksellerid="+row.basket.vendor_id+"\">"+data+"</a>";
+                      }
+                    },
+                    { "data": function(row, type, val, meta) {
+                        var result = "<p><a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber="+row.biblio_id+"\">"+row.biblio.title+"</a>";
+                        if ( row.biblio.author != null )
+                            result += _(" by ") + row.biblio.author;
+                        if ( row.biblio.isbn != null )
+                            result += " &ndash; " + row.biblio.isbn;
+                        if ( row.biblio.publisher != null ) {
+                            result += "<br/>" + _("Publisher: ") + row.biblio.publisher;
+                            if ( row.biblio.publication_year != null ) {
+                                result += ", " + row.biblio.publication_year;
+                            }
+                            else if ( row.biblio.copyright_date != null ) {
+                                result += row.biblio.copyright_date;
+                            }
+                        }
+                        var suggestions = row.biblio.suggestions;
+                        if ( suggestions != null && suggestions.length > 0 ) {
+                            var suggestion = suggestions[0];
+                            if ( suggestion.suggester != null ) {
+                                var suggester = suggestion.suggester;
+                                var suggested_by = [];
+                                if ( suggester.surname != null ) {
+                                    suggested_by.push(suggester.surname);
+                                }
+                                if ( suggester.firstname != null ) {
+                                    suggested_by.push(suggester.firstname);
+                                }
+
+                                    result += "<br/>" + _("Suggested by: ") +
+                                                '<a href="/cgi-bin/koha/suggestion/suggestion.pl?suggestionid='
+                                                    + suggestion.suggestionid
+                                                    + '&amp;op=show">'
+                                                    + suggested_by.join(", ")
+                                                    + " (#" + suggestions[0].suggestionid + ")</a>";
+                            }
+                        }
+                        result += '</p>';
+
+                        var internal_note = row.internal_note;
+                        if ( internal_note != '' ) {
+                            result += '<p class="ordernote"><strong>'
+                                        + _("Internal note: ")
+                                        + '</strong>' + internal_note
+                                        + ' [<a href="/cgi-bin/koha/acqui/modordernotes.pl?ordernumber='
+                                        + row.order_id + '&amp;referrer=/cgi-bin/koha/acqui/parcel.pl%3Finvoiceid=[% invoiceid | uri %]'
+                                        + '&type=internal">' + _("Change internal note") + '</a>]</p>';
+                        }
+                        else {
+                            result += ' [<a href="/cgi-bin/koha/acqui/modordernotes.pl?ordernumber='
+                                        + row.order_id + '&amp;referrer=/cgi-bin/koha/acqui/parcel.pl%3Finvoiceid=[% invoiceid | uri %]'
+                                        + '&type=internal">' + _("Add internal note") + '</a>]';
+                        }
+
+                        var vendor_note = row.vendor_note;
+                        if ( vendor_note != '' ) {
+                            result += '<p class="ordernote"><strong>'
+                                        + _("Vendor note: ")
+                                        + '</strong>' + vendor_note + '</p>';
+                        }
+                        else {
+                            result += ' [<a href="/cgi-bin/koha/acqui/modordernotes.pl?ordernumber='
+                                        + row.order_id + '&amp;referrer=/cgi-bin/koha/acqui/parcel.pl%3Finvoiceid=[% invoiceid | uri %]'
+                                        + '&type=vendor">' + _("Add vendor note") + '</a>]';
+                        }
+
+                        return result;
+                      },
+                      "orderable": false // FIXME
+                    },
+                    { "data": function( row, type, val, meta) {
+                            var result = '<a href="/cgi-bin/koha/acqui/showorder.pl?ordernumber=' + row.order_id + '" class="previewData">' + _("Order") + '</a><br>'
+                                + '<a href="/cgi-bin/koha/catalogue/showmarc.pl?id=' + row.biblio_id + '" class="previewData">' + _("MARC") + '</a><br>'
+                                + '<a href="/cgi-bin/koha/catalogue/showmarc.pl?viewas=card&amp;id=' + row.biblio_id + '" class="previewData">' + _("Card") + '</a>';
+                            return result;
+                      },
+                      "orderable": false
+                    },
+                    { "data": "replacement_price",
+                      "render": function(data, type, val, meta) {
+                        if (type != 'display') return data;
+                        return data.format_price();
+                      }
+                    },
+                    { "data": "quantity",
+                      "orderable": true
+                    },
+                    { "data": "ecost",
+                      "render": function(data, type, val, meta) {
+                        if (type != 'display') return data;
+                        return data.format_price();
+                      },
+                      "orderable": true
+                    },
+                    { "data": function ( row, type, val, meta ) {
+                            return (row.quantity * row.ecost).format_price();
+                      },
+                      "orderable": false // FIXME: How can we do it in DBIC?
+                    },
+                    { "data": "fund_id",
+                      "render": function(data, type, row, meta) {
+                        if (type != 'display') return data;
+                        return row.fund.name;
+                      }
+                    },
+                    { "data": function( row, type, val, meta ) {
+                        return '<a href="orderreceive.pl?ordernumber='
+                                + row.order_id + '&amp;invoiceid=[% invoiceid | uri %]' + '">'
+                                + _("Receive") + '</a><br/>'
+                                + '<a href="#" onclick="transfer_order_popup(' + row.order_id + '); return false;">'
+                                + _("Transfer") + '</a>';
+                      },
+                      "orderable": false
+                    },
+                    { "data": function( row, type, val, meta ) {
+                            var result = "";
+
+                            if ( row.current_holds_count > 0 ) {
+                                result += '<span class="button" title="'
+                                        + _("Can't cancel order, (%s) holds are linked with this order. Cancel holds first").format( row.holds_count ) + '">'
+                                        + _("Can't cancel order") + '</span><br/>';
+                            }
+                            else {
+                                result += '<a href="/cgi-bin/koha/acqui/cancelorder.pl?ordernumber='
+                                            + row.order_id
+                                            + '&biblionumber=' + row.biblio_id
+                                            + '&referrer=/cgi-bin/koha/acqui/parcel.pl?invoiceid=[% invoiceid | uri %]">'
+                                            + _("Cancel order") + '</a><br/>';
+                            }
+
+                            if ( row.items.length > 0 ||
+                                row.biblio.active_orders_count > 1 ||
+                                row.biblio.subscriptions_count > 0 ||
+                                row.bibio.holds_count > 0 ) { // biblio can be deleted
+                                result += '<span class="button" title="'
+                                        + _("Can't delete catalog record, see constraints below") + '">'
+                                        + _("Can't cancel order and delete catalog record") + '</span><br>';
+                            }
+                            else {
+                                result += '<a href="/cgi-bin/koha/acqui/cancelorder.pl?ordernumber='
+                                        + row.order_id + '&biblionumber=' + row.biblio_id
+                                        + '&del_biblio=1&referrer="/cgi-bin/koha/acqui/parcel.pl?invoiceid=[$ invoiceid | uri ]">'
+                                        + _("Cancel order and catalog record") + '</a><br/>';
+                            }
+
+                            if ( row.biblio.items_count - row.items.length > 0 ) {
+                                result += '<b title="'
+                                        + _("Can't delete catalog record, because of %s existing item(s)").format(row.items.length)
+                                        +'">' + (row.biblio.items_count - row.items.length) + _(" item(s) left") + '</b><br/>';
+                            }
+
+                            if ( row.biblio.active_orders_count > 1 ) {
+                                result += '<b title="'
+                                        + _("Can't delete catalog record, delete other orders linked to it first") + '">'
+                                        + (row.biblio.active_orders_count - 1) + _(" order(s) left") + '</b><br/>';
+                            }
+
+                            if ( row.biblio.subscriptions_count > 0 ) {
+                                result += '<b title="' + _("Can't delete catalog record, delete subscriptions first") + '">'
+                                        + _("%s subscription(s) left").format(row.biblio.subscriptions_count)
+                                        + '</b><br>';
+                            }
+
+                            if ( row.biblio.holds_count > 0 ) {
+                                result += '<b title="' + _("Can't delete catalog record or order, cancel holds first") + '">'
+                                        + _("%s hold(s) left").format(row.bibio.holds_count) + '</b>';
+                            }
+
+                            return result;
+                      },
+                      "orderable": false
+                    }
+                ]
+            });
+
+            $("#filterform").on("submit", function(e) {
+                e.preventDefault();
+                // Update the datatable URL
+                var summary      = $("#summaryfilter").val();
+                var basket_name  = $("#basketfilter").val();
+                var basket_group = $("#basketgroupnamefilter").val();
+                var order_id     = $("#orderfilter").val();
+
+                var q = {};
+
+                if (order_id != "") {
+                    q['order_id'] = order_id;
+                }
+                if (basket_name != "") { // C4::Acquisition::SearchOrders behaviour
+                    q['basket.name'] = { "like": '%'+basket_name+'%' };
+                }
+                if (basket_group != "") { // C4::Acquisition::SearchOrders behaviour
+                    q['basket.basket_group.name'] = { "like": '%'+basket_group+'%' };
+                }
+                if (summary != "") { // C4::Acquisition::SearchOrders behaviour
+                    q["-or"] = [{"biblio.title":  { "like": '%'+summary+'%' } },
+                                {"biblio.author": { "like": '%'+summary+'%' } },
+                                {"biblio.isbn":   { "like": '%'+summary+'%' } } ];
+                }
+
+                if ( !jQuery.isEmptyObject(q) ) {
+                    pending_orders_table.api().ajax.url( pending_orders_url + '&q=' + encodeURI(JSON.stringify(q)) );
+                }
+                else {
+                    pending_orders_table.api().ajax.url( pending_orders_url );
+                }
+                pending_orders_table.api().ajax.reload( null, false );
+            });
+
+            // Keep filters from finishreceive.pl to parcel.pl
             $.cookie("filter_parcel_summary", $("#summaryfilter").val());
             $.cookie("filter_parcel_basketname", $("#basketfilter").val());
             $.cookie("filter_parcel_orderno", $("#orderfilter").val());
             $.cookie("filter_parcel_basketgroupname", $("#basketgroupnamefilter").val());
             $.cookie("filter_parcel_ean", $("#eanfilter").val());
-          });
+
+            $("#filterform").on('submit', function(){
+                $.cookie("filter_parcel_summary", $("#summaryfilter").val());
+                $.cookie("filter_parcel_basketname", $("#basketfilter").val());
+                $.cookie("filter_parcel_orderno", $("#orderfilter").val());
+                $.cookie("filter_parcel_basketgroupname", $("#basketgroupnamefilter").val());
+                $.cookie("filter_parcel_ean", $("#eanfilter").val());
+            });
 
             $(".previewData").on("click", function(e){
                 e.preventDefault();
@@ -556,28 +829,28 @@
                 $("#dataPreview .modal-body").load(page + " div");
                 $('#dataPreview').modal({show:true});
             });
+
             $("#dataPreview").on("hidden.bs.modal", function(){
                 $("#dataPreviewLabel").html("");
                 $("#dataPreview .modal-body").html("<div id=\"loading\"><img src=\"[% interface | html %]/[% theme | html %]/img/spinner-small.gif\" alt=\"\" /> "+_("Loading")+"</div>");
             });
+        });
+
+        // Case-insensitive version of jquery's contains function
+        jQuery.extend(jQuery.expr[':'], {
+            icontains : "jQuery(a).text().toUpperCase().indexOf(m[3].toUpperCase())>=0"
+        });
 
+        // Contains exactly function
+        jQuery.extend(jQuery.expr[':'], {
+            containsExactly: "$(a).text() == m[3]"
         });
 
-         // Case-insensitive version of jquery's contains function
-         jQuery.extend(jQuery.expr[':'], {
-	    icontains : "jQuery(a).text().toUpperCase().indexOf(m[3].toUpperCase())>=0"
-         });
-
-         // Contains exactly function
-         jQuery.extend(jQuery.expr[':'], {
-              containsExactly: "$(a).text() == m[3]"
-         });
-
-         function transfer_order_popup(ordernumber) {
-            var url = "/cgi-bin/koha/acqui/transferorder.pl?"
-                + "ordernumber=" + ordernumber
-                window.open(url, 'TransferOrder');
-         }
+        function transfer_order_popup(ordernumber) {
+        var url = "/cgi-bin/koha/acqui/transferorder.pl?"
+            + "ordernumber=" + ordernumber
+            window.open(url, 'TransferOrder');
+        }
     </script>
 [% END %]
 
-- 
2.25.1