X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fwebservice_log.pm;h=1dfabe6729c57d2a4bf74a1a1d8dba1c59eb0270;hp=7e320c23ec55be6f405eaf9d32499652b2c369c9;hb=9437bfc0dfccd408aa30e0c259031167a1991016;hpb=58c17d959b59b61da9a5b6b752bb8c295d61fc63 diff --git a/FS/FS/webservice_log.pm b/FS/FS/webservice_log.pm index 7e320c23e..1dfabe672 100644 --- a/FS/FS/webservice_log.pm +++ b/FS/FS/webservice_log.pm @@ -125,6 +125,40 @@ sub check { =back +=head1 CLASS METHODS + +=over 4 + +=item price_print + +Calculates cost of printing unbilled print jobs for this customer. + +=cut + +sub price_print { + my( $class, %opt ) = @_; + +# $opt{'beginning'} ||= 0; +# $opt{'ending'} ||= 4294967295; + + #false laziness w/ClientAPI/Freeside.pm + my $color = 1.10; + my $page = 0.10; + + $class->scalar_sql(" + SELECT SUM( $color + quantity * $page ) + FROM webservice_log + WHERE custnum = $opt{custnum} + AND method = 'print' + AND status IS NULL + "); +# AND _date >= $opt{beginning} +# AND _date < $opt{ending} + +} + +=back + =head1 BUGS =head1 SEE ALSO