From e3c3d86b7091d806af42e40475a28ea8afb5865c Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sat, 28 Mar 2009 22:59:36 +0000
Subject: package selector, split by package class, RT#5077

---
 httemplate/misc/cust-part_pkg.cgi | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 httemplate/misc/cust-part_pkg.cgi

(limited to 'httemplate/misc/cust-part_pkg.cgi')

diff --git a/httemplate/misc/cust-part_pkg.cgi b/httemplate/misc/cust-part_pkg.cgi
new file mode 100644
index 000000000..a249f033f
--- /dev/null
+++ b/httemplate/misc/cust-part_pkg.cgi
@@ -0,0 +1,29 @@
+<% 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 ),
+});
+
+my @return = map  { $_->pkgpart => $_->pkg_comment }
+             sort { $a->pkg_comment cmp $b->pkg_comment }
+             @part_pkg;
+
+</%init>
-- 
cgit v1.2.1