X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Finventory_item.html;h=cd37e267bfc9ae8d902ee1661d6021993b0196b4;hb=d0221fabd4656b3a04251ca6168cc45f54d23574;hp=fc690b33b751de41e57b0771f0fa74b401de2a96;hpb=3ce7691203a7737406bf2d4442f7fd84b81f847e;p=freeside.git diff --git a/httemplate/search/inventory_item.html b/httemplate/search/inventory_item.html index fc690b33b..cd37e267b 100644 --- a/httemplate/search/inventory_item.html +++ b/httemplate/search/inventory_item.html @@ -1,54 +1,4 @@ -% -% -%my $classnum = $cgi->param('classnum'); -%$classnum =~ /^(\d+)$/ or eidiot "illegal classnum $classnum"; -%$classnum = $1; -% -%my $inventory_class = qsearchs( { -% 'table' => 'inventory_class', -% 'hashref' => { 'classnum' => $classnum }, -%} ); -% -%my $title = $inventory_class->classname. ' Inventory'; -% -%#little false laziness with SQL fragments in inventory_class.pm -%my $extra_sql = ''; -%if ( $cgi->param('avail') ) { -% $extra_sql = 'AND ( svcnum IS NULL OR svcnum = 0 )'; -% $title .= ' - Available'; -%} elsif ( $cgi->param('used') ) { -% $extra_sql = 'AND svcnum IS NOT NULL AND svcnum > 0'; -% $title .= ' - In use'; -%} -% -%my $count_query = -% "SELECT COUNT(*) FROM inventory_item WHERE classnum = $classnum $extra_sql"; -% -%my $link = sub { -% my $inventory_item = shift; -% if ( $inventory_item->svcnum ) { -% [ "${p}view/svc_acct.cgi?", 'svcnum' ]; -% } else { -% ''; -% } -%}; -%my $link_cust = sub { -% my $inventory_item = shift; -% if ( $inventory_item->custnum ) { -% [ "${p}view/cust_main.cgi?", 'custnum' ]; -% } else { -% ''; -% } -%}; -% -%my $addl_from = ' LEFT JOIN cust_svc USING ( svcnum ) '. -% ' LEFT JOIN part_svc USING ( svcpart ) '. -% ' LEFT JOIN cust_pkg USING ( pkgnum ) '. -% ' LEFT JOIN cust_main USING ( custnum ) '; -% -% <% include( 'elements/search.html', - 'title' => $title, #less lame to use Lingua:: something to pluralize @@ -97,13 +47,79 @@ \&FS::UI::Web::cust_fields, ], - + 'align' => 'rll'.FS::UI::Web::cust_aligns(), 'links' => [ '', '', $link, - ( map { $link_cust } FS::UI::Web::cust_header() ), + ( map { $_ ne 'Cust. Status' ? $link_cust : '' } + FS::UI::Web::cust_header() + ), ], + 'color' => [ + '', + '', + '', + FS::UI::Web::cust_colors(), + ], + 'style' => [ + '', + '', + '', + FS::UI::Web::cust_styles(), + ], ) %> +<%init> + +die "access denied" + unless $FS::CurrentUser::CurrentUser->access_right('Configuration'); + +my $classnum = $cgi->param('classnum'); +$classnum =~ /^(\d+)$/ or errorpage("illegal classnum $classnum"); +$classnum = $1; + +my $inventory_class = qsearchs( { + 'table' => 'inventory_class', + 'hashref' => { 'classnum' => $classnum }, +} ); + +my $title = $inventory_class->classname. ' Inventory'; + +#little false laziness with SQL fragments in inventory_class.pm +my $extra_sql = ''; +if ( $cgi->param('avail') ) { + $extra_sql = 'AND ( svcnum IS NULL OR svcnum = 0 )'; + $title .= ' - Available'; +} elsif ( $cgi->param('used') ) { + $extra_sql = 'AND svcnum IS NOT NULL AND svcnum > 0'; + $title .= ' - In use'; +} + +my $count_query = + "SELECT COUNT(*) FROM inventory_item WHERE classnum = $classnum $extra_sql"; + +my $link = sub { + my $inventory_item = shift; + if ( $inventory_item->svcnum ) { + [ "${p}view/svc_acct.cgi?", 'svcnum' ]; + } else { + ''; + } +}; +my $link_cust = sub { + my $inventory_item = shift; + if ( $inventory_item->custnum ) { + [ "${p}view/cust_main.cgi?", 'custnum' ]; + } else { + ''; + } +}; + +my $addl_from = ' LEFT JOIN cust_svc USING ( svcnum ) '. + ' LEFT JOIN part_svc USING ( svcpart ) '. + ' LEFT JOIN cust_pkg USING ( pkgnum ) '. + ' LEFT JOIN cust_main USING ( custnum ) '; + +