summaryrefslogtreecommitdiff
path: root/httemplate/search
diff options
context:
space:
mode:
authorjeff <jeff>2002-02-22 23:18:34 +0000
committerjeff <jeff>2002-02-22 23:18:34 +0000
commitb50b2e5f94774268c271484f9c07bfe316f95527 (patch)
tree2dec4f5a1b4ed14bc2ae663acd6691e24c1cda9b /httemplate/search
parentf96fd39dcc9c2563f8ba2976f7b9d23c0b3fcc29 (diff)
add some reporting features
Diffstat (limited to 'httemplate/search')
-rwxr-xr-xhttemplate/search/report_cc.cgi94
-rwxr-xr-xhttemplate/search/report_cc.html23
-rwxr-xr-xhttemplate/search/report_credit.cgi97
-rwxr-xr-xhttemplate/search/report_credit.html23
-rwxr-xr-xhttemplate/search/report_receivables.cgi26
-rwxr-xr-xhttemplate/search/report_tax.cgi94
-rwxr-xr-xhttemplate/search/report_tax.html23
7 files changed, 380 insertions, 0 deletions
diff --git a/httemplate/search/report_cc.cgi b/httemplate/search/report_cc.cgi
new file mode 100755
index 000000000..908ad35cd
--- /dev/null
+++ b/httemplate/search/report_cc.cgi
@@ -0,0 +1,94 @@
+<%
+#!/usr/bin/perl -Tw
+#
+# $Id: report_cc.cgi,v 1.1 2002-02-22 23:18:33 jeff Exp $
+#
+# Usage: post form to:
+# http://server.name/path/svc_domain.cgi
+#
+# ivan@voicenet.com 96-mar-5
+#
+# need to look at table in results to make it more readable
+#
+# ivan@voicenet.com
+#
+# rewrite ivan@sisd.com 98-mar-15
+#
+# Changes to allow page to work at a relative position in server
+# bmccane@maxbaud.net 98-apr-3
+#
+# $Log: report_cc.cgi,v $
+# Revision 1.1 2002-02-22 23:18:33 jeff
+# add some reporting features
+#
+# Revision 1.1 2002/02/05 15:22:00 jeff
+# preserving state prior to 1.4.0pre7 upgrade
+#
+# Revision 1.2 2000/09/20 19:25:19 jeff
+# local modifications
+#
+# Revision 1.1.1.1 2000/09/18 06:26:58 jeff
+# Import of Freeside 1.2.3
+#
+# Revision 1.10 1999/07/20 06:03:36 ivan
+# s/CGI::Request/CGI/; (how'd i miss that before?)
+#
+# Revision 1.9 1999/04/09 04:22:34 ivan
+# also table()
+#
+# Revision 1.8 1999/04/09 03:52:55 ivan
+# explicit & for table/itable/ntable
+#
+# Revision 1.7 1999/02/28 00:03:56 ivan
+# removed misleading comments
+#
+# Revision 1.6 1999/02/09 09:22:58 ivan
+# visual and bugfixes
+#
+# Revision 1.5 1999/01/19 05:14:16 ivan
+# for mod_perl: no more top-level my() variables; use vars instead
+# also the last s/create/new/;
+#
+# Revision 1.4 1999/01/18 09:41:40 ivan
+# all $cgi->header calls now include ( '-expires' => 'now' ) for mod_perl
+# (good idea anyway)
+#
+# Revision 1.3 1998/12/17 09:41:11 ivan
+# s/CGI::(Base|Request)/CGI.pm/;
+#
+
+use strict;
+use vars qw( $conf $cgi $beginning $ending );
+use CGI;
+use CGI::Carp qw(fatalsToBrowser);
+use FS::UID qw(cgisuidsetup);
+use FS::CGI qw(popurl idiot header table);
+use FS::Record qw(qsearch qsearchs);
+use FS::Conf;
+
+$cgi = new CGI;
+&cgisuidsetup($cgi);
+
+$conf = new FS::Conf;
+
+$cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/;
+$beginning = $1;
+
+$cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/;
+$ending = $1;
+
+ print $cgi->header( '-expires' => '-2m' ),
+ header('Credit Card Recipt Report Results');
+
+ open (REPORT, "/usr/bin/freeside-cc-receipts-report -v -s $beginning -d $ending freeside |");
+
+ print '<PRE>';
+ while(<REPORT>) {
+ print $_;
+ }
+ print '</PRE>';
+
+ print '</BODY></HTML>';
+
+%>
+
diff --git a/httemplate/search/report_cc.html b/httemplate/search/report_cc.html
new file mode 100755
index 000000000..a028a87df
--- /dev/null
+++ b/httemplate/search/report_cc.html
@@ -0,0 +1,23 @@
+<HTML>
+ <HEAD>
+ <TITLE>Credit Card Receipt Report Criteria</TITLE>
+ </HEAD>
+ <BODY>
+ <CENTER>
+ <H1>Credit Card Receipt Report Criteria</H1>
+ </CENTER>
+ <HR>
+ <FORM ACTION="report_cc.cgi" METHOD="post">
+ Return <B>credit card receipt report</B> for period:
+ from <INPUT TYPE="text" NAME="beginning">
+ to <INPUT TYPE="text" NAME="ending">
+
+ <P><INPUT TYPE="submit" VALUE="Get Report">
+
+ </FORM>
+
+ <HR>
+
+ </BODY>
+</HTML>
+
diff --git a/httemplate/search/report_credit.cgi b/httemplate/search/report_credit.cgi
new file mode 100755
index 000000000..8535e29cc
--- /dev/null
+++ b/httemplate/search/report_credit.cgi
@@ -0,0 +1,97 @@
+<%
+#!/usr/bin/perl -Tw
+#
+# $Id: report_credit.cgi,v 1.1 2002-02-22 23:18:33 jeff Exp $
+#
+# Usage: post form to:
+# http://server.name/path/svc_domain.cgi
+#
+# ivan@voicenet.com 96-mar-5
+#
+# need to look at table in results to make it more readable
+#
+# ivan@voicenet.com
+#
+# rewrite ivan@sisd.com 98-mar-15
+#
+# Changes to allow page to work at a relative position in server
+# bmccane@maxbaud.net 98-apr-3
+#
+# $Log: report_credit.cgi,v $
+# Revision 1.1 2002-02-22 23:18:33 jeff
+# add some reporting features
+#
+# Revision 1.2 2002/02/19 14:24:53 jeff
+# might be functional now
+#
+# Revision 1.1 2002/02/05 15:22:00 jeff
+# preserving state prior to 1.4.0pre7 upgrade
+#
+# Revision 1.2 2000/09/20 19:25:19 jeff
+# local modifications
+#
+# Revision 1.1.1.1 2000/09/18 06:26:58 jeff
+# Import of Freeside 1.2.3
+#
+# Revision 1.10 1999/07/20 06:03:36 ivan
+# s/CGI::Request/CGI/; (how'd i miss that before?)
+#
+# Revision 1.9 1999/04/09 04:22:34 ivan
+# also table()
+#
+# Revision 1.8 1999/04/09 03:52:55 ivan
+# explicit & for table/itable/ntable
+#
+# Revision 1.7 1999/02/28 00:03:56 ivan
+# removed misleading comments
+#
+# Revision 1.6 1999/02/09 09:22:58 ivan
+# visual and bugfixes
+#
+# Revision 1.5 1999/01/19 05:14:16 ivan
+# for mod_perl: no more top-level my() variables; use vars instead
+# also the last s/create/new/;
+#
+# Revision 1.4 1999/01/18 09:41:40 ivan
+# all $cgi->header calls now include ( '-expires' => 'now' ) for mod_perl
+# (good idea anyway)
+#
+# Revision 1.3 1998/12/17 09:41:11 ivan
+# s/CGI::(Base|Request)/CGI.pm/;
+#
+
+use strict;
+use vars qw( $conf $cgi $beginning $ending );
+use CGI;
+use CGI::Carp qw(fatalsToBrowser);
+use FS::UID qw(cgisuidsetup);
+use FS::CGI qw(popurl idiot header table);
+use FS::Record qw(qsearch qsearchs);
+use FS::Conf;
+
+$cgi = new CGI;
+&cgisuidsetup($cgi);
+
+$conf = new FS::Conf;
+
+$cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/;
+$beginning = $1;
+
+$cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/;
+$ending = $1;
+
+ print $cgi->header( '-expires' => '-2m' ),
+ header('In House Credit Report Results');
+
+ open (REPORT, "/usr/bin/freeside-credit-report -v -s $beginning -d $ending freeside |");
+
+ print '<PRE>';
+ while(<REPORT>) {
+ print $_;
+ }
+ print '</PRE>';
+
+ print '</BODY></HTML>';
+
+%>
+
diff --git a/httemplate/search/report_credit.html b/httemplate/search/report_credit.html
new file mode 100755
index 000000000..bda08e31d
--- /dev/null
+++ b/httemplate/search/report_credit.html
@@ -0,0 +1,23 @@
+<HTML>
+ <HEAD>
+ <TITLE>In House Credit Report Criteria</TITLE>
+ </HEAD>
+ <BODY>
+ <CENTER>
+ <H1>In House Credit Report Criteria</H1>
+ </CENTER>
+ <HR>
+ <FORM ACTION="report_credit.cgi" METHOD="post">
+ Return <B>in house credit report</B> for period:
+ from <INPUT TYPE="text" NAME="beginning">
+ to <INPUT TYPE="text" NAME="ending">
+
+ <P><INPUT TYPE="submit" VALUE="Get Report">
+
+ </FORM>
+
+ <HR>
+
+ </BODY>
+</HTML>
+
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
new file mode 100755
index 000000000..7113ad5a7
--- /dev/null
+++ b/httemplate/search/report_receivables.cgi
@@ -0,0 +1,26 @@
+<%
+
+use strict;
+use vars qw( $cgi );
+use CGI;
+use CGI::Carp qw(fatalsToBrowser);
+use FS::UID qw(cgisuidsetup);
+
+$cgi = new CGI;
+&cgisuidsetup($cgi);
+
+print $cgi->header( '-expires' => '-2m' ),
+ header('Current Receivables Report Results');
+
+open (REPORT, "/usr/bin/freeside-receivables-report -v freeside |");
+
+print '<PRE>';
+while(<REPORT>) {
+ print $_;
+}
+print '</PRE>';
+
+print '</BODY></HTML>';
+
+%>
+
diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi
new file mode 100755
index 000000000..8062479b5
--- /dev/null
+++ b/httemplate/search/report_tax.cgi
@@ -0,0 +1,94 @@
+<%
+#!/usr/bin/perl -Tw
+#
+# $Id: report_tax.cgi,v 1.1 2002-02-22 23:18:34 jeff Exp $
+#
+# Usage: post form to:
+# http://server.name/path/svc_domain.cgi
+#
+# ivan@voicenet.com 96-mar-5
+#
+# need to look at table in results to make it more readable
+#
+# ivan@voicenet.com
+#
+# rewrite ivan@sisd.com 98-mar-15
+#
+# Changes to allow page to work at a relative position in server
+# bmccane@maxbaud.net 98-apr-3
+#
+# $Log: report_tax.cgi,v $
+# Revision 1.1 2002-02-22 23:18:34 jeff
+# add some reporting features
+#
+# Revision 1.1 2002/02/05 15:22:00 jeff
+# preserving state prior to 1.4.0pre7 upgrade
+#
+# Revision 1.2 2000/09/20 19:25:19 jeff
+# local modifications
+#
+# Revision 1.1.1.1 2000/09/18 06:26:58 jeff
+# Import of Freeside 1.2.3
+#
+# Revision 1.10 1999/07/20 06:03:36 ivan
+# s/CGI::Request/CGI/; (how'd i miss that before?)
+#
+# Revision 1.9 1999/04/09 04:22:34 ivan
+# also table()
+#
+# Revision 1.8 1999/04/09 03:52:55 ivan
+# explicit & for table/itable/ntable
+#
+# Revision 1.7 1999/02/28 00:03:56 ivan
+# removed misleading comments
+#
+# Revision 1.6 1999/02/09 09:22:58 ivan
+# visual and bugfixes
+#
+# Revision 1.5 1999/01/19 05:14:16 ivan
+# for mod_perl: no more top-level my() variables; use vars instead
+# also the last s/create/new/;
+#
+# Revision 1.4 1999/01/18 09:41:40 ivan
+# all $cgi->header calls now include ( '-expires' => 'now' ) for mod_perl
+# (good idea anyway)
+#
+# Revision 1.3 1998/12/17 09:41:11 ivan
+# s/CGI::(Base|Request)/CGI.pm/;
+#
+
+use strict;
+use vars qw( $conf $cgi $beginning $ending );
+use CGI;
+use CGI::Carp qw(fatalsToBrowser);
+use FS::UID qw(cgisuidsetup);
+use FS::CGI qw(popurl idiot header table);
+use FS::Record qw(qsearch qsearchs);
+use FS::Conf;
+
+$cgi = new CGI;
+&cgisuidsetup($cgi);
+
+$conf = new FS::Conf;
+
+$cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/;
+$beginning = $1;
+
+$cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/;
+$ending = $1;
+
+ print $cgi->header( '-expires' => '-2m' ),
+ header('Tax Report Results');
+
+ open (REPORT, "/usr/bin/freeside-tax-report -v -s $beginning -d $ending freeside |");
+
+ print '<PRE>';
+ while(<REPORT>) {
+ print $_;
+ }
+ print '</PRE>';
+
+ print '</BODY></HTML>';
+
+%>
+
diff --git a/httemplate/search/report_tax.html b/httemplate/search/report_tax.html
new file mode 100755
index 000000000..a7beb2471
--- /dev/null
+++ b/httemplate/search/report_tax.html
@@ -0,0 +1,23 @@
+<HTML>
+ <HEAD>
+ <TITLE>Tax Report Criteria</TITLE>
+ </HEAD>
+ <BODY>
+ <CENTER>
+ <H1>Tax Report Criteria</H1>
+ </CENTER>
+ <HR>
+ <FORM ACTION="report_tax.cgi" METHOD="post">
+ Return <B>tax report</B> for period:
+ from <INPUT TYPE="text" NAME="beginning">
+ to <INPUT TYPE="text" NAME="ending">
+
+ <P><INPUT TYPE="submit" VALUE="Get Report">
+
+ </FORM>
+
+ <HR>
+
+ </BODY>
+</HTML>
+