From d453a487d95258e1f11f134fc5864f7e6458a6ef Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 12 Apr 2006 12:36:39 +0000 Subject: zip code report --- httemplate/index.html | 65 ++++++++------------------------------------------- 1 file changed, 10 insertions(+), 55 deletions(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index b8f300d2d..89fe7fcae 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,55 +1,8 @@ - <% my $conf = new FS::Conf; %> - - - - Freeside Main Menu - - - - - - - - - - - - -
- freeside - - <%= $conf->config('company_name') %> Billing - Logged in as <%= getotaker %> -
- - - - - <% if ( $conf->config('ticket_system') eq 'RT_Internal' ) { %> - <% eval "use RT;"; %> - - - <% } %> - - -
- - Freeside v<%= $FS::VERSION %>
- Documentation
- - 		- - RT v<%= $RT::VERSION %>
- Documentation
- -
- -
+<%= include('/elements/header.html', 'Freeside Main Menu' ) %>
- [ Sales / Customer service ] <% if ( $conf->config('ticket_system') ) { %> [ Support / Ticketing ] @@ -57,7 +10,7 @@ [ Bookkeeping / Collections ] [ Reports ] [ Sysadmin ] - +
Sales / Customer service

New Customer @@ -88,7 +41,7 @@ [ Bookkeeping / Collections ] [ Reports ] [ Sysadmin ] - +
Support/Ticketing
<% if ( $conf->config('ticket_system') eq 'RT_Internal' ) { %> @@ -117,7 +70,7 @@ [ Bookkeeping / Collections ] [ Reports ] [ Sysadmin ] - +
+ % foreach my $custnum ( @custnums ) { % my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } ); % next unless $cust_main; - -% + % if ( $bgcolor eq $bgcolor1 ) { % $bgcolor = $bgcolor2; % } else { @@ -50,10 +47,8 @@ % % } -
Bookkeeping / Collections

Quick payment entry @@ -165,7 +118,7 @@ [ Bookkeeping / Collections ] [ Reports ] [ Sysadmin ] - +
+% foreach my $custnum ( @custnums ) { +% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } ); +% next unless $cust_main; - <% foreach my $custnum ( @custnums ) { %> - <% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } ); %> - <% next unless $cust_main; %> - + +% +% if ( $bgcolor eq $bgcolor1 ) { +% $bgcolor = $bgcolor2; +% } else { +% $bgcolor = $bgcolor1; +% } +% +% } - <% - if ( $bgcolor eq $bgcolor1 ) { - $bgcolor = $bgcolor2; - } else { - $bgcolor = $bgcolor1; - } - %> - - <% } %>
Reports

@@ -190,6 +143,7 @@ + Zip code distribution

SQL query: SELECT

@@ -208,7 +162,7 @@ [ Bookkeeping / Collections ] [ Reports ] [ Sysadmin ] - +
-- cgit v1.2.1 From f29c752d6f9e813c10295b334eefb924216e34cf Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 2 May 2006 11:59:31 +0000 Subject: add a "pre-report" page to this report/graph as requested by lewis/wtxs, also add 12mo total option --- httemplate/index.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index 6cd667d8a..4704ebe33 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -97,7 +97,7 @@ Payment report (by type and/or date range)

Credit report (by employee and/or date range) -

Sales, Credits and Receipts Summary +

Sales, Credits and Receipts Summary

Accounts Receivable Aging Summary

Prepaid Income (Unearned Revenue) Report

Sales Tax Liability Report -- cgit v1.2.1 From 0e2bb254c0e5018b6b2a7766962319cd4137683f Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 2 May 2006 15:03:00 +0000 Subject: add an agent pre-selection page to receivables report --- httemplate/index.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index 4704ebe33..1a9293ecd 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -98,7 +98,7 @@ Payment report (by type and/or date range)

Credit report (by employee and/or date range)

Sales, Credits and Receipts Summary -

Accounts Receivable Aging Summary +

Accounts Receivable Aging Summary

Prepaid Income (Unearned Revenue) Report

Sales Tax Liability Report

-- cgit v1.2.1 From 896ef9b1a5302dc2d96d351702be94184825cc91 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 8 May 2006 10:01:54 +0000 Subject: sales report per agent and package class looks good --- httemplate/index.html | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index 1a9293ecd..c8a46d08f 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -95,9 +95,10 @@
  • All invoice events for a date range
  • Invoice event errors for a date range (failed credit cards, processor or printer problems, etc.) - Payment report (by type and/or date range) + Sales, Credits and Receipts Summary +

    Sales report (by agent, package class and/or date range)

    Credit report (by employee and/or date range) -

    Sales, Credits and Receipts Summary +

    Payment report (by type and/or date range)

    Accounts Receivable Aging Summary

    Prepaid Income (Unearned Revenue) Report

    Sales Tax Liability Report -- cgit v1.2.1 From 2c757d7db4cb6a7b9655de13206fcc84fb7ce61f Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 14 May 2006 16:47:31 +0000 Subject: first part of ACL and re-skinning work and some other small stuff --- httemplate/index.html | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index c8a46d08f..33083f6e5 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -168,7 +168,7 @@
    • + + + + <% foreach my $custnum ( @custnums ) { %> + <% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } ); %> + <% next unless $cust_main; %> + + + + + + <% + if ( $bgcolor eq $bgcolor1 ) { + $bgcolor = $bgcolor2; + } else { + $bgcolor = $bgcolor1; + } + %> + + <% } %> + +
    Sysadmin

    @@ -289,5 +243,6 @@















































    - - + +<%= include('/elements/footer.html') %> + -- cgit v1.2.1 From 1e0dbd55775c7d9eba7db3d17a6173d03e3c2d0a Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 21 Apr 2006 12:45:29 +0000 Subject: s(browse/queue.cgi)(search/queue.html) --- httemplate/index.html | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index 89fe7fcae..a1c3caf39 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -170,7 +170,7 @@ session server - View pending job queue + View pending job queue
    Batch import customers from CSV file
    Batch import charges from CSV file
    Download database dump @@ -186,6 +186,9 @@ - One or more services are grouped together into a package and given pricing information. Customers purchase packages, not services. +
  • View/Edit package classes + - Package classes define groups of packages, for reporting and + convenience purposes. Resellers
      -- cgit v1.2.1 From 1a033848671cad2cbe7687b37fc718b3b2a68b83 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 22 Apr 2006 00:58:40 +0000 Subject: start of package class web UI (add/edit package classes, package class selection in package def edit) --- httemplate/index.html | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index a1c3caf39..6cd667d8a 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -186,7 +186,7 @@ - One or more services are grouped together into a package and given pricing information. Customers purchase packages, not services. -
    • View/Edit package classes +
    • View/Edit package classes - Package classes define groups of packages, for reporting and convenience purposes.
    @@ -234,6 +234,8 @@ - Locally defined fields
  • View/Edit message catalog - Change error messages and other customizable labels. +
  • View/Edit inventory classes and inventory + - Setup inventory classes and stock inventory.

    • View pending job queue @@ -177,7 +177,15 @@
    Download database dump


    Configuration -

    Provisioning, services and packages +

    + Employees + + Provisioning, services and packages
    Customers I recently added or modified
    <%= $custnum %>: <%= $cust_main->name %>
    + +<% } %> <%= include('/elements/footer.html') %> -- cgit v1.2.1 From 3ce7691203a7737406bf2d4442f7fd84b81f847e Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 23 Aug 2006 22:25:39 +0000 Subject: Will things ever be the same again? It's the final masonize --- httemplate/index.html | 88 +++++++++++++++++++++++++-------------------------- 1 file changed, 44 insertions(+), 44 deletions(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index 1a92b45f6..57d85a9fb 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,59 +1,59 @@ -<% my $conf = new FS::Conf; %> -<%= include('/elements/header.html', 'Billing Main' ) %> +% my $conf = new FS::Conf; + +<% include('/elements/header.html', 'Billing Main' ) %> +% +% +% my $sth = dbh->prepare( +% #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) +% "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) +% WHERE ( history_action = 'insert' OR history_action = 'replace_new' ) +% AND history_user = ? +% ORDER BY history_date desc" # LIMIT 10 +% ) or die dbh->errstr; +% +% $sth->execute( getotaker() ) or die $sth->errstr; +% +% my %saw = (); +% my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref }; +% +% @custnums = splice(@custnums, 0, 10); +% +% if ( @custnums ) { +% +% + + + <% include('/elements/table-grid.html') %> +% my $bgcolor1 = '#eeeeee'; +% my $bgcolor2 = '#ffffff'; +% my $bgcolor; +% -<% - - my $sth = dbh->prepare( - #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) - "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) - WHERE ( history_action = 'insert' OR history_action = 'replace_new' ) - AND history_user = ? - ORDER BY history_date desc" # LIMIT 10 - ) or die dbh->errstr; - - $sth->execute( getotaker() ) or die $sth->errstr; - - my %saw = (); - my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref }; - - @custnums = splice(@custnums, 0, 10); - - if ( @custnums ) { - -%> - - <%= include('/elements/table-grid.html') %> - - <% my $bgcolor1 = '#eeeeee'; - my $bgcolor2 = '#ffffff'; - my $bgcolor; - %>
    Customers I recently added or modified
    <%= $custnum %>: <%= $cust_main->name %><% $custnum %>: <% $cust_main->name %>
    +% } -<% } %> -<%= include('/elements/footer.html') %> +<% include('/elements/footer.html') %> -- cgit v1.2.1 From 1ec49b28c30c84962670d80d1c143e65b5b9370a Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 15 Dec 2006 12:43:44 +0000 Subject: add a quick start at a "dashboard" customer list, mostly for internal use for starters --- httemplate/index.html | 21 ++++++++------------- 1 file changed, 8 insertions(+), 13 deletions(-) (limited to 'httemplate/index.html') diff --git a/httemplate/index.html b/httemplate/index.html index 57d85a9fb..60ab26f86 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,8 +1,9 @@ % my $conf = new FS::Conf; <% include('/elements/header.html', 'Billing Main' ) %> -% -% + +<% include('/elements/dashboard-toplist.html') %> + % my $sth = dbh->prepare( % #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) % "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum ) @@ -19,29 +20,25 @@ % @custnums = splice(@custnums, 0, 10); % % if ( @custnums ) { -% -% - <% include('/elements/table-grid.html') %> + % my $bgcolor1 = '#eeeeee'; % my $bgcolor2 = '#ffffff'; -% my $bgcolor; -% - +% my $bgcolor = $bgcolor2;
    Customers I recently added or modified
    <% $custnum %>: <% $cust_main->name %>
    -% } +% } <% include('/elements/footer.html') %> - -- cgit v1.2.1