diff options
| author | ivan <ivan> | 2009-02-08 02:05:48 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-02-08 02:05:48 +0000 |
| commit | 24533a22a23e211888fcc36a5177c0def5c77de3 (patch) | |
| tree | 09887e29cf74dc4e50ab03e23514acc0d69e59b2 /httemplate/elements/select-part_pkg.html | |
| parent | 8b72ad2a4d67f46e4bda36179e992d82d069689f (diff) | |
further work on agents editing own packages: allow them to see (but not edit) global packages for their type, RT#1331
Diffstat (limited to 'httemplate/elements/select-part_pkg.html')
| -rw-r--r-- | httemplate/elements/select-part_pkg.html | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/httemplate/elements/select-part_pkg.html b/httemplate/elements/select-part_pkg.html index a1d5f40f2..cd6d24c28 100644 --- a/httemplate/elements/select-part_pkg.html +++ b/httemplate/elements/select-part_pkg.html @@ -17,6 +17,8 @@ Example: <% include( '/elements/select-table.html', 'table' => 'part_pkg', + 'agent_virt' => 1, + 'agent_null' => 1, 'name_col' => 'pkg', 'empty_label' => 'Select package', #should this be the default? 'label_callback' => sub { shift->pkg_comment }, @@ -31,4 +33,20 @@ my( %opt ) = @_; $opt{'records'} = delete $opt{'part_pkg'} if $opt{'part_pkg'}; +#false laziness w/browse/part_pkg.cgi +my $agentnums = join(',', $FS::CurrentUser::CurrentUser->agentnums); + +$opt{'extra_sql'} .= + " AND ( agentnum IS NOT NULL + OR 0 < ( SELECT COUNT(*) + FROM type_pkgs + LEFT JOIN agent_type USING ( typenum ) + LEFT JOIN agent AS typeagent USING ( typenum ) + WHERE type_pkgs.pkgpart = part_pkg.pkgpart + AND typeagent.agentnum IN ($agentnums) + ) + ) + "; +#eofalse + </%init> |