From cb3a2467f28049de15810f7ddf1b04632639e530 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Sven=20Sch=C3=B6ling?= <s.schoeling@linet-services.de>
Date: Tue, 11 Oct 2011 14:58:25 +0200
Subject: [PATCH] customer_picker

testpage ist zu Dokumentationszwecken noch dabei, aber nicht mehr durch action
erreichbar.
---
 SL/Controller/Customer.pm                     | 27 +++++++++++++
 SL/Form.pm                                    |  4 +-
 SL/Template/Plugin/L.pm                       | 34 ++++++++++++++++
 templates/webpages/ct/ajax_autocomplete2.html | 11 +++++
 templates/webpages/ct/testpage.html           | 40 +++++++++++++++++++
 5 files changed, 115 insertions(+), 1 deletion(-)
 create mode 100644 SL/Controller/Customer.pm
 create mode 100644 templates/webpages/ct/ajax_autocomplete2.html
 create mode 100644 templates/webpages/ct/testpage.html

diff --git a/SL/Controller/Customer.pm b/SL/Controller/Customer.pm
new file mode 100644
index 000000000..4358080fe
--- /dev/null
+++ b/SL/Controller/Customer.pm
@@ -0,0 +1,27 @@
+package SL::Controller::Customer;
+
+use strict;
+use parent qw(SL::Controller::Base);
+
+use SL::DB::Customer;
+
+# safety
+__PACKAGE__->run_before(sub { $::auth->assert('customer_vendor_edit') });
+
+sub action_ajax_autocomplete {
+  my ($self, %params) = @_;
+
+  my $limit  = $::form->{limit}  || 20;
+  my $type   = $::form->{type} || {};
+  my $query  = { ilike => "%$::form->{term}%" };
+  my @filter;
+  push @filter, ($::form->{column})
+    ? ($::form->{column} => $query)
+    : (or => [ customernumber => $query, name => $query ]);
+
+  $self->{customers} = SL::DB::Manager::Customer->get_all(query => [ @filter ], limit => $limit);
+  $self->{value} = $::form->{column} || 'name';
+
+  $self->render('ct/ajax_autocomplete2', { no_layout => 1 });
+}
+
diff --git a/SL/Form.pm b/SL/Form.pm
index a23bb4337..b21f94c71 100644
--- a/SL/Form.pm
+++ b/SL/Form.pm
@@ -701,7 +701,9 @@ sub header {
                 '<script type="text/javascript" src="js/jscalendar/calendar.js"></script>',
                 '<script type="text/javascript" src="js/jscalendar/lang/calendar-de.js"></script>',
                 '<script type="text/javascript" src="js/jscalendar/calendar-setup.js"></script>',
-                '<script type="text/javascript" src="js/part_selection.js"></script>';
+                '<script type="text/javascript" src="js/part_selection.js"></script>',
+                '<script type="text/javascript" src="js/jquery-ui.js"></script>',
+                '<style "type=text/css">@import url("css/ui-lightness/jquery-ui-1.8.12.custom.css")</style>';
   push @header, $self->{javascript} if $self->{javascript};
   push @header, map { $_->show_javascript } @{ $self->{AJAX} || [] };
   push @header, "<script type='text/javascript'>function fokus(){ document.$self->{fokus}.focus(); }</script>" if $self->{fokus};
diff --git a/SL/Template/Plugin/L.pm b/SL/Template/Plugin/L.pm
index 0ed2a8784..476b60a70 100644
--- a/SL/Template/Plugin/L.pm
+++ b/SL/Template/Plugin/L.pm
@@ -291,6 +291,40 @@ sub date_tag {
   ) : '');
 }
 
+sub customer_picker {
+  my ($self, $name, $value, %params) = @_;
+  my $name_e    = _H($name);
+
+  $self->hidden_tag($name, (ref $value && $value->can('id')) ? $value->id : '') .
+  $self->input_tag("$name_e\_name", (ref $value && $value->can('name')) ? $value->name : '', %params) .
+  $self->javascript(<<JS);
+function autocomplete_customer (selector, column) {
+  \$(function(){ \$(selector).autocomplete({
+    source: function(req, rsp) {
+      \$.ajax({
+        url: 'controller.pl?action=Customer/ajax_autocomplete',
+        dataType: "json",
+        data: {
+          column: column,
+          term: req.term,
+          current: function() { \$('#$name_e').val() },
+          obsolete: 0,
+        },
+        success: function (data){ rsp(data) }
+      });
+    },
+    limit: 20,
+    delay: 50,
+    select: function(event, ui) {
+      \$('#$name_e').val(ui.item.id);
+      \$('#$name_e\_name').val(ui.item.name);
+    },
+  })});
+}
+autocomplete_customer('#$name_e\_name');
+JS
+}
+
 sub javascript_tag {
   my $self = shift;
   my $code = '';
diff --git a/templates/webpages/ct/ajax_autocomplete2.html b/templates/webpages/ct/ajax_autocomplete2.html
new file mode 100644
index 000000000..f4a44e31f
--- /dev/null
+++ b/templates/webpages/ct/ajax_autocomplete2.html
@@ -0,0 +1,11 @@
+[%- USE HTML %][% USE JSON %][
+[%- FOREACH customer = SELF.customers %]
+ {
+   "value": [% customer.${SELF.value}.json %],
+   "label": [% customer.displayable_name.json %],
+   "id": [% customer.id.json %],
+   "customernumber": [% customer.customernumber.json %],
+   "name": [% customer.name.json %]
+  }[% ',' UNLESS loop.last %]
+[%- END %]
+]
diff --git a/templates/webpages/ct/testpage.html b/templates/webpages/ct/testpage.html
new file mode 100644
index 000000000..e8ba83857
--- /dev/null
+++ b/templates/webpages/ct/testpage.html
@@ -0,0 +1,40 @@
+[% USE L %]
+[% USE T8 %]
+[% USE LxERP %]
+[% L.javascript_tag('jquery-ui') %]
+<link rel="stylesheet" href="css/ui-lightness/jquery-ui-1.8.12.custom.css" type="text/css" />
+
+<p>Pick a customer</p>
+id: [% L.input_tag('customer_id', '') %]
+nr: [% L.input_tag('customer_customernumber', '') %]
+desc: [% L.input_tag('customer_name', '') %]
+
+<script type='text/javascript'>
+function autocomplete_customer (selector, column) {
+  $(function(){ $(selector).autocomplete({
+    source: function(req, rsp) {
+      $.ajax({
+        url: 'controller.pl?action=Customer/ajax_autocomplete',
+        dataType: "json",
+        data: {
+          column: column,
+          term: req.term,
+          current: function() { $('#customer_id').val() },
+          obsolete: 0,
+        },
+        success: function (data){ rsp(data) }
+      });
+    },
+    limit: 20,
+    delay: 50,
+    select: function(event, ui) {
+      $('#customer_id').val(ui.item.id);
+      $('#customer_customernumber').val(ui.item.customernumber);
+      $('#customer_name').val(ui.item.name);
+    },
+  })});
+}
+//autocomplete_customer('#customer_customernumber', 'customernumber');
+autocomplete_customer('#customer_name', '');
+</script>
+
-- 
2.20.1