httemplate/search/reg_code.html

   1 <%
   2
   3 my $agentnum = $cgi->param('agentnum');
   4 $agentnum =~ /^(\d+)$/ or eidiot "illegal agentnum $agentnum";
   5 $agentnum = $1;
   6 my $agent = qsearchs('agent', { 'agentnum' => $agentnum } );
   7
   8 my $count_query = "SELECT COUNT(*) FROM reg_code WHERE agentnum = $agentnum";
   9
  10 %><%= include( 'elements/search.html',
  11                  'title'       => 'Unused Registration Codes for '.
  12                                   $agent->agent,
  13                  'name'        => 'registration codes',
  14                  'query'       => {  'table'   => 'reg_code',
  15                                      'hashref' => { 'agentnum' => $agentnum, },
  16                                   },
  17                  'count_query' => $count_query,
  18                  #'redirect'    => $link,
  19                  'header'      => [ qw(Code Packages) ],
  20                  'fields'      => [
  21                    'code',
  22                    sub {
  23                      map {
  24                        qq!<A HREF="${p}edit/part_pkg.cgi?!. $_->pkgpart. '">'.
  25                        $_->pkg. ' - '. $_->comment.
  26                        '</A><BR>'
  27                      } $_[0]->part_pkg
  28                    },
  29                  ],
  30                  'links' => [
  31                    '',
  32                    #$plink,
  33                    '',
  34                  ],
  35       )
  36 %>