From: Christopher Burger Date: Thu, 4 Apr 2019 14:59:48 +0000 (-0400) Subject: RT# 75357 - Prospects can now be disabled X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=3ebf876779b2a89e81a767d3cdd6690a88bdd3de RT# 75357 - Prospects can now be disabled --- diff --git a/FS/FS/prospect_main.pm b/FS/FS/prospect_main.pm index c54c569c3..5d909a3ea 100644 --- a/FS/FS/prospect_main.pm +++ b/FS/FS/prospect_main.pm @@ -462,7 +462,7 @@ sub search { # here is the agent virtualization push @where, $FS::CurrentUser::CurrentUser->agentnums_sql; - my $extra_sql = scalar(@where) ? ' WHERE '. join(' AND ', @where) : ''; + my $extra_sql = scalar(@where) ? ' WHERE prospect_main.custnum IS NULL AND '. join(' AND ', @where) : ''; my $count_query = "SELECT COUNT(*) FROM prospect_main $extra_sql"; diff --git a/httemplate/edit/prospect_main.html b/httemplate/edit/prospect_main.html index 6adb471f7..b812dc303 100644 --- a/httemplate/edit/prospect_main.html +++ b/httemplate/edit/prospect_main.html @@ -3,6 +3,7 @@ 'table' => 'prospect_main', 'html_table_class'=> 'fsinnerbox', 'labels' => { 'prospectnum' => 'Prospect', + 'disabled' => 'Disabled', 'agentnum' => 'Agent', 'refnum' => 'Advertising source', 'company' => 'Company', @@ -16,6 +17,10 @@ 'options' => [ 'Residential', 'Commercial', ], 'onchange' => 'rescom_changed', }, + { 'field' => 'disabled', + 'type' => 'checkbox', + 'value' => 'Y', + }, { 'field' => 'agentnum', 'type' => 'select-agent', 'empty_label' => 'Select agent',