Quozl's Prepaid Accounting

| quozl@us.netrek.org | up |

Introduction

This prepaid accounting system was written for the Gilgandra Community Technology Centre in January 2001, and is used by the staff and the customers of the centre to track login time spent on a set of legacy Microsoft Windows workstations.

It uses the Linux system accounting files (/var/wtmp) to generate usage transactions, stored in a plain text database. Based on PHP, the system also provides up to the minute account balances and accepts payments and charges.

Changes to the utility sac that summarises wtmp records were required to clip the data by host name, so that multiple SMB connections from the clients were merged into one accounting transaction.


Features


Resources


Installation


Changes for V1.4


Changes for V1.3


Changes for V1.2


Functional Specification


Screen Shots

These screen shots are an inclusion of the HTML documents generated by the software. This is how they should look in your browser.

Administrator Status Screen

Gilgandra Community Technology Centre
Usage Accounting gic-menu.jpg
Thu May 3 13:38:02 EST 2001

Active Users
UserWorkstationLoginBalance
rucksakws015:2899.46
cameronws913:37-135.75

menu
^
menu

$Revision: 1.2 $ $Date: 2000/12/09 12:21:09 $


List of All Customers

Gilgandra Community Technology Centre
Usage Accounting gic-list.jpg
Thu May 3 13:39:16 EST 2001

Users
UserNameBalance
guestguest user62.73
rucksackjo blow99.46
cameroncameron-135.80

menumenu
^

$Revision: 1.2 $ $Date: 2000/12/09 12:21:14 $


View Specific Customer

Gilgandra Community Technology Centre
Usage Accounting gic-view.jpg
Thu May 3 13:39:38 EST 2001

Account for user cameron
Date & TimeCommentAmountBalance
2001-05-03 13:39:38On ws9 from 13:37:20 at 3.00/hr for 0.04 hours-0.12-135.84
2001-05-03 08:51:12On ws8 from 08:40:33 at 3.00/hr for 0.18 hours-0.54-135.72
2001-05-02 16:58:22On ws8 from 16:56:58 at 3.00/hr for 0.02 hours-0.06-135.18
2001-05-02 16:33:13On ws6 from 16:20:01 at 3.00/hr for 0.22 hours-0.66-135.12
2001-05-02 15:11:42On ws8 from 14:39:27 at 3.00/hr for 0.54 hours-1.62-134.46
2001-05-02 14:38:13On ws4 from 14:37:27 at 3.00/hr for 0.01 hours-0.03-132.84
2001-05-02 14:34:02On ws8 from 14:33:00 at 3.00/hr for 0.02 hours-0.06-132.81
2001-04-24 16:14:47On ws3 from 11:24:23 at 3.00/hr for 4.84 hours-14.52-132.75
2001-04-20 16:31:15On ws8 from 15:00:47 at 3.00/hr for 1.51 hours-4.53-118.23
2001-04-20 11:11:40On ws8 from 09:12:20 at 3.00/hr for 1.99 hours-5.97-113.70
2001-04-19 16:01:11On ws8 from 15:26:01 at 3.00/hr for 0.59 hours-1.77-107.73
2001-04-11 15:25:00On ws8 from 15:13:47 at 3.00/hr for 0.19 hours-0.57-105.96
2001-04-11 10:30:12On ws4 from 10:23:19 at 3.00/hr for 0.12 hours-0.36-105.39
2001-04-06 16:22:22On ws8 from 16:19:00 at 3.00/hr for 0.06 hours-0.18-105.03
2001-04-06 13:16:22On ws8 from 12:50:21 at 3.00/hr for 0.43 hours-1.29-104.85
2001-04-04 10:05:31On ws8 from 09:59:37 at 3.00/hr for 0.10 hours-0.30-103.56
2001-04-03 16:34:27On ws8 from 16:32:58 at 3.00/hr for 0.03 hours-0.09-103.26
2001-03-29 18:32:18On ws8 from 12:10:25 at 3.00/hr for 6.37 hours-19.11-103.17
2001-03-29 11:57:37On ws8 from 09:10:12 at 3.00/hr for 2.79 hours-8.37-84.06
2001-03-28 22:57:51On ws8 from 22:30:41 at 3.00/hr for 0.45 hours-1.35-75.69

menumenumenu
^
menumenumenu

$Revision: 1.5 $ $Date: 2000/12/09 12:21:18 $


Add Charge Transaction

Gilgandra Community Technology Centre
Usage Accounting gic-charge.jpg
Thu May 3 13:40:23 EST 2001
Login: cameron
Date:
Comment:
Amount:
 
menumenumenumenumenu
^
menu


Add Payment Transaction

Gilgandra Community Technology Centre
Usage Accounting gic-payment.jpg
Thu May 3 13:40:13 EST 2001
Login: cameron
Date:
Comment:
Amount:
 
menumenumenumenu
^
menumenu


Modify User Hourly Rate

Gilgandra Community Technology Centre
Usage Accounting gic-modify.jpg
Thu May 3 13:40:32 EST 2001
Login: cameron
Rate:
 
menumenumenumenumenumenu
^



Page Change Log

DateChange
2004-06-21Release version 1.4
2003-03-05Release version 1.3
2002-12-24Add mailing list
2002-11-26Add INSTALL file
2002-11-21Add sac sources and upstream pointer, thanks to Gonero for letting me know
2002-03-08Add client install instructions
2001-09-18Release version 1.2
2001-08-07Include missing Makefile, thanks to Enzo for noticing
2001-06-22Release version 1.1
2001-05-03Add more documentation and do Freshmeat announcement of release

| quozl@us.netrek.org | up |