use SL::Locale::String;
use Data::Dumper;
+use JSON;
+use Rose::DB::Object::Helpers qw(as_tree);
use Rose::Object::MakeMethods::Generic
(
scalar => [ qw(project linked_records) ],
- 'scalar --get_set_init' => [ qw(models customers project_types project_statuses) ],
+ 'scalar --get_set_init' => [ qw(models customers project_types project_statuses projects) ],
);
-__PACKAGE__->run_before('check_auth');
-__PACKAGE__->run_before('load_project', only => [ qw(edit update destroy) ]);
+__PACKAGE__->run_before('check_auth', except => [ qw(ajax_autocomplete) ]);
+__PACKAGE__->run_before('load_project', only => [ qw(edit update destroy) ]);
#
# actions
$self->redirect_to(action => 'search');
}
+sub action_ajax_autocomplete {
+ my ($self, %params) = @_;
+
+ $::form->{filter}{'all:substr:multi::ilike'} =~ s{[\(\)]+}{}g;
+
+ # if someone types something, and hits enter, assume he entered the full name.
+ # if something matches, treat that as sole match
+ # unfortunately get_models can't do more than one per package atm, so we d it
+ # the oldfashioned way.
+ if ($::form->{prefer_exact}) {
+ my $exact_matches;
+ if (1 == scalar @{ $exact_matches = SL::DB::Manager::Project->get_all(
+ query => [
+ obsolete => 0,
+ SL::DB::Manager::Project->type_filter($::form->{filter}{type}),
+ or => [
+ description => { ilike => $::form->{filter}{'all:substr:multi::ilike'} },
+ projectnumber => { ilike => $::form->{filter}{'all:substr:multi::ilike'} },
+ ]
+ ],
+ limit => 2,
+ ) }) {
+ $self->projects($exact_matches);
+ }
+ }
+
+ $::form->{sort_by} = 'customer_and_description';
+
+ my @hashes = map {
+ +{
+ value => $_->full_description(style => 'full'),
+ label => $_->full_description(style => 'full'),
+ id => $_->id,
+ projectnumber => $_->projectnumber,
+ description => $_->description,
+ cvars => { map { ($_->config->name => { value => $_->value_as_text, is_valid => $_->is_valid }) } @{ $_->cvars_by_config } },
+ }
+ } @{ $self->projects }; # neato: if exact match triggers we don't even need the init_projects
+
+ $self->render(\ SL::JSON::to_json(\@hashes), { layout => 0, type => 'json', process => 0 });
+}
+
+sub action_test_page {
+ $_[0]->render('project/test_page');
+}
+
#
# filters
#
sub init_project_statuses { SL::DB::Manager::ProjectStatus->get_all_sorted }
sub init_project_types { SL::DB::Manager::ProjectType->get_all_sorted }
+sub init_projects {
+ if ($::form->{no_paginate}) {
+ $_[0]->models->disable_plugin('paginated');
+ }
+
+ $_[0]->models->get;
+}
+
sub init_customers {
my ($self) = @_;
my @customer_id = $self->project && $self->project->customer_id ? (id => $self->project->customer_id) : ();
projectnumber => t8('Project Number'),
project_type => t8('Project Type'),
project_status => t8('Project Status'),
+ customer_and_description => 1,
},
with_objects => [ 'customer', 'project_status', 'project_type' ],
);
--- /dev/null
+namespace('kivi', function(k){
+ k.ProjectPicker = function($real, options) {
+ // short circuit in case someone double inits us
+ if ($real.data("project_picker"))
+ return $real.data("project_picker");
+
+ var KEY = {
+ ESCAPE: 27,
+ ENTER: 13,
+ TAB: 9,
+ LEFT: 37,
+ RIGHT: 39,
+ PAGE_UP: 33,
+ PAGE_DOWN: 34,
+ };
+ var CLASSES = {
+ PICKED: 'projectpicker-picked',
+ UNDEFINED: 'projectpicker-undefined',
+ }
+ var o = $.extend({
+ limit: 20,
+ delay: 50,
+ }, options);
+ var STATES = {
+ PICKED: CLASSES.PICKED,
+ UNDEFINED: CLASSES.UNDEFINED
+ }
+ var real_id = $real.attr('id');
+ var $dummy = $('#' + real_id + '_name');
+ var $customer_id = $('#' + real_id + '_customer_id');
+ var state = STATES.PICKED;
+ var last_real = $real.val();
+ var last_dummy = $dummy.val();
+ var timer;
+
+ function ajax_data(term) {
+ var data = {
+ 'filter.all:substr:multi::ilike': term,
+ 'filter.valid': 'valid',
+ no_paginate: $('#no_paginate').prop('checked') ? 1 : 0,
+ current: $real.val(),
+ };
+
+ if ($customer_id && $customer_id.val())
+ data['filter.customer_id'] = $customer_id.val().split(',');
+
+ return data;
+ }
+
+ function set_item (item) {
+ if (item.id) {
+ $real.val(item.id);
+ // autocomplete ui has name, use the value for ajax items, which contains displayable_name
+ $dummy.val(item.name ? item.name : item.value);
+ } else {
+ $real.val('');
+ $dummy.val('');
+ }
+ state = STATES.PICKED;
+ last_real = $real.val();
+ last_dummy = $dummy.val();
+ last_unverified_dummy = $dummy.val();
+
+ $real.trigger('change');
+ $real.trigger('set_item:ProjectPicker', item);
+
+ annotate_state();
+ }
+
+ function make_defined_state () {
+ if (state == STATES.PICKED) {
+ annotate_state();
+ return true
+ } else if (state == STATES.UNDEFINED && $dummy.val() == '')
+ set_item({})
+ else {
+ last_unverified_dummy = $dummy.val();
+ set_item({ id: last_real, name: last_dummy })
+ }
+ annotate_state();
+ }
+
+ function annotate_state () {
+ if (state == STATES.PICKED)
+ $dummy.removeClass(STATES.UNDEFINED).addClass(STATES.PICKED);
+ else if (state == STATES.UNDEFINED && $dummy.val() == '')
+ $dummy.removeClass(STATES.UNDEFINED).addClass(STATES.PICKED);
+ else {
+ last_unverified_dummy = $dummy.val();
+ $dummy.addClass(STATES.UNDEFINED).removeClass(STATES.PICKED);
+ }
+ }
+
+ function update_results () {
+ $.ajax({
+ url: 'controller.pl?action=Project/project_picker_result',
+ data: $.extend({
+ 'real_id': $real.val(),
+ }, ajax_data(function(){ var val = $('#project_picker_filter').val(); return val === undefined ? '' : val })),
+ success: function(data){ $('#project_picker_result').html(data) }
+ });
+ };
+
+ function result_timer (event) {
+ if (!$('no_paginate').prop('checked')) {
+ if (event.keyCode == KEY.PAGE_UP) {
+ $('#project_picker_result a.paginate-prev').click();
+ return;
+ }
+ if (event.keyCode == KEY.PAGE_DOWN) {
+ $('#project_picker_result a.paginate-next').click();
+ return;
+ }
+ }
+ window.clearTimeout(timer);
+ timer = window.setTimeout(update_results, 100);
+ }
+
+ $dummy.autocomplete({
+ source: function(req, rsp) {
+ $.ajax($.extend(o, {
+ url: 'controller.pl?action=Project/ajax_autocomplete',
+ dataType: "json",
+ data: ajax_data(req.term),
+ success: function (data){ rsp(data) }
+ }));
+ },
+ select: function(event, ui) {
+ set_item(ui.item);
+ },
+ });
+ /* In case users are impatient and want to skip ahead:
+ * Capture <enter> key events and check if it's a unique hit.
+ * If it is, go ahead and assume it was selected. If it wasn't don't do
+ * anything so that autocompletion kicks in. For <tab> don't prevent
+ * propagation. It would be nice to catch it, but javascript is too stupid
+ * to fire a tab event later on, so we'd have to reimplement the "find
+ * next active element in tabindex order and focus it".
+ */
+ /* note:
+ * event.which does not contain tab events in keypressed in firefox but will report 0
+ * chrome does not fire keypressed at all on tab or escape
+ */
+ $dummy.keydown(function(event){
+ if (event.which == KEY.ENTER || event.which == KEY.TAB) {
+ // if string is empty assume they want to delete
+ if ($dummy.val() == '') {
+ set_item({});
+ return true;
+ } else if (state == STATES.PICKED) {
+ return true;
+ }
+ if (event.which == KEY.TAB) event.preventDefault();
+ $.ajax({
+ url: 'controller.pl?action=Project/ajax_autocomplete',
+ dataType: "json",
+ data: $.extend( ajax_data($dummy.val()), { prefer_exact: 1 } ),
+ success: function (data) {
+ if (data.length == 1) {
+ set_item(data[0]);
+ if (event.which == KEY.ENTER)
+ $('#update_button').click();
+ } else {
+ }
+ annotate_state();
+ }
+ });
+ if (event.which == KEY.ENTER)
+ return false;
+ } else {
+ state = STATES.UNDEFINED;
+ }
+ });
+
+ $dummy.blur(function(){
+ window.clearTimeout(timer);
+ timer = window.setTimeout(annotate_state, 100);
+ });
+
+ // now add a picker div after the original input
+ var pcont = $('<span>').addClass('position-absolute');
+ var picker = $('<div>');
+ $dummy.after(pcont);
+ pcont.append(picker);
+
+ var pp = {
+ real: function() { return $real },
+ dummy: function() { return $dummy },
+ type: function() { return $type },
+ customer_id: function() { return $customer_id },
+ update_results: update_results,
+ result_timer: result_timer,
+ set_item: set_item,
+ reset: make_defined_state,
+ is_defined_state: function() { return state == STATES.PICKED },
+ init_results: function () {
+ $('div.project_picker_project').each(function(){
+ $(this).click(function(){
+ set_item({
+ id: $(this).children('input.project_picker_id').val(),
+ name: $(this).children('input.project_picker_description').val(),
+ });
+ $dummy.focus();
+ return true;
+ });
+ });
+ $('#project_selection').keydown(function(e){
+ if (e.which == KEY.ESCAPE) {
+ $dummy.focus();
+ }
+ });
+ }
+ }
+ $real.data('project_picker', pp);
+ return pp;
+ }
+});
+
+$(function(){
+ $('input.project_autocomplete').each(function(i,real){
+ kivi.ProjectPicker($(real));
+ })
+});