blob: dcd033ff24a75f769cce6f50c7ea1c7346f1e77f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<% objToJson( \@return ) %>
<%init>
my( $custnum, $classnum ) = $cgi->param('arg');
#XXX i guess i should be agent-virtualized. cause "packages a customer can
#order" is such a huge deal
my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } );
my %hash = ( 'disabled' => '' );
if ( $classnum > 0 ) {
$hash{'classnum'} = $classnum;
} elsif ( $classnum eq '' || $classnum == 0 ) {
$hash{'classnum'} = '';
} #else -1, all classes, so don't set classnum
my @part_pkg = qsearch({
'table' => 'part_pkg',
'hashref' => \%hash,
'extra_sql' =>
' AND '. $FS::CurrentUser::CurrentUser->agentnums_sql( 'null'=>1 ).
' AND '. FS::part_pkg->agent_pkgs_sql( $cust_main->agent ),
'order_by' => 'ORDER BY pkg',
});
my @return = map { warn $_->can_start_date;
( $_->pkgpart,
$_->pkg_comment,
$_->can_discount,
$_->can_start_date,
);
}
#sort { $a->pkg_comment cmp $b->pkg_comment }
@part_pkg;
</%init>
|