FS/FS/part_event/Condition/postal.pm

   1 package FS::part_event::Condition::postal;
   2 use base qw( FS::part_event::Condition );
   3 use strict;
   4
   5 sub description {
   6   'Customer receives a postal mail invoice';
   7 }
   8
   9 sub condition {
  10   my( $self, $object ) = @_;
  11   my $cust_main = $self->cust_main($object);
  12
  13   scalar( grep { $_ eq 'POST' } $cust_main->invoicing_list );
  14 }
  15
  16 sub condition_sql {
  17   my( $self, $table ) = @_;
  18
  19   " EXISTS( SELECT 1 FROM cust_main_invoice
  20               WHERE cust_main_invoice.custnum = cust_main.custnum
  21                 AND cust_main_invoice.dest    = 'POST'
  22           )
  23   ";
  24 }
  25
  26 1;