X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Finventory_item.html;h=086c8e92d40c525a5ce7a4149621e50eaea037ba;hb=b6dbe0f12dbbe4ea5209367f905f937789b5b607;hp=fc690b33b751de41e57b0771f0fa74b401de2a96;hpb=3ce7691203a7737406bf2d4442f7fd84b81f847e;p=freeside.git diff --git a/httemplate/search/inventory_item.html b/httemplate/search/inventory_item.html index fc690b33b..086c8e92d 100644 --- a/httemplate/search/inventory_item.html +++ b/httemplate/search/inventory_item.html @@ -1,64 +1,21 @@ -% -% -%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 - 'name' => $inventory_class->classname. 's', + 'menubar' => [ 'View inventory classes' => + $p.'browse/inventory_class.html', + 'Upload '. PL($inventory_class->classname)=> + $p.'misc/inventory_item-import.html?'. + "classnum=$classnum" + ], + + 'name' => PL($inventory_class->classname), 'query' => { 'table' => 'inventory_item', - 'hashref' => { 'classnum' => $classnum }, + 'hashref' => {}, 'select' => join(', ', 'inventory_item.*', + 'part_svc.svcdb', 'cust_main.custnum', FS::UI::Web::cust_sql_fields(), ), @@ -68,11 +25,16 @@ 'count_query' => $count_query, + 'agent_virt' => 1, + 'agent_null' => 1, + 'agent_pos' => 2, + 'header' => [ '#', $inventory_class->classname, 'Service', FS::UI::Web::cust_header(), + '', # checkbox column ], 'fields' => [ @@ -95,15 +57,142 @@ }, \&FS::UI::Web::cust_fields, + $sub_checkbox, ], - + '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(), + ], + 'html_form' => + qq! +