Quozl's Prepaid Accounting

Introduction

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

• implemented on a Debian GNU/Linux 3.0 (woody) server running Apache, PHP, and Samba,
• tightly integrated with the sac package,
• does not require a database package, uses PHP serialize() data storage only,
• no transaction erasure supported (reversing transactions must be added, in compliance with accounting principles),

Resources

• Debian package archive, add deb http://quozl.linux.org.au/packages ./ to your /etc/apt/sources.list file and then install the package with apt-get install ppa,
• mailing list for users and developers, see the first post for expectations; subscribe before posting, or your message will be lost,
• ppa-1.4.tar.gz (786Kb), sources, sac binaries for Intel and Alpha, along with Win32 listener process,
• ppa-1.3.tar.gz (776Kb), sources, sac binaries for Intel and Alpha, along with Win32 listener process,
• ppa-1.3-2003-03-21.gz, patch to 1.3 for use of host names under Samba versions without "utmp hostnames",
• sac-1.8b8-quozl.diff, patch to sac to provide year in output and to clip wtmp records by hostname,
• sac-1.8b8-quozl.tar.gz (50Kb), complete redistribution of sac with my patch applied, or see the upstream sources,
• prior version ppa-1.2.tar.gz (771Kb), sources, sac binaries for Intel and Alpha, along with Win32 listener process,
• prior version ppa-1.1.tar.gz (93Kb), sources, including a sac binary for i686 and alpha, but missing the Makefile.
• prior version ppa-1.0.tar.gz (97Kb), again missing the Makefile.

Installation

• install Samba

• configure smb.conf
  [global]
  
  
  # make the ppa server the primary domain controller for a domain
  preferred master = Yes
  domain master = Yes
  domain logons = Yes
  os level = 34
  
  # make the ppa server support utmp
  utmp directory = /var/run
  wtmp directory = /var/log
  utmp = Yes
  
  # provide time server
  time server = Yes
  
  # force use of a logon script
  logon script = access.bat
  
  
  [netlogon]
  
  comment = The domain logon service
  path = /export/samba/logon
  browseable = No
  

• create the logon script that sets the time and maps at least one file share
  # cat << EOF >> /export/samba/logon/access.bat
  net time \\server /set /yes
  net use p: \\server\public
  EOF

• configure clients to logon to the Windows NT domain provided by the Samba server

• test client logon by checking that the 'who' command on the Samba server shows the client logged in

• install PPA as per the INSTALL file

Changes for V1.4

• menus in text format rather than images,
• add packaging in Debian format,
• fix missing host names,
• add Debian and Red Hat specific install variables,
• register globals fix for later versions of PHP,
• add transaction report by item code.

Changes for V1.3

• add Samba and client installation hints to INSTALL,
• verify installation instructions for Debian GNU/Linux 3.0 (Woody),
• account transaction aggregation for reduced database size,
• fix script timeouts when many transactions exist,
• add item codes for transactions,
• fix export warnings for accounts with no transactions,
• add rounding to nearest 5c mark for usage transactions,
• fix rounding problem, 4.14 was being rendered as 4.13.

Changes for V1.2

• add per-client remote control program to direct users to account balance,
• add item codes to transactions so as to improve reporting by service type,
• implement export to comma separated value file,
• move site specific configuration out of program area,
• allow for administration functions from public workstations,
• prevent loop on some versions of PHP caused by readdir() return value.

Functional Specification

• maintains an account per customer, including
  • account name
  • current balance
  • history of transactions
• records transactions, such as
  • usage of a workstation or shell account for a period of time
  • payment at front desk
  • miscellanous usage of hire equipment or consumables
• displays transactions
  • to customer, via web page, on login
  • to administrator, on a per-customer basis
• rollover accounting period
  • summarise transactions from system accounting files
  • record new balances per account
• exports data
  • transactions or accounts
  • comma separated values (CSV) format for input to spreadsheets

Screen Shots

Administrator Status Screen
Thu May 3 13:38:02 EST 2001 Active Users User Workstation Login Balance rucksak ws0 15:28 99.46 cameron ws9 13:37 -135.75 ^ $Revision: 1.2 $ $Date: 2000/12/09 12:21:09 $

List of All Customers
Thu May 3 13:39:16 EST 2001 Users User Name Balance guest guest user 62.73 rucksack jo blow 99.46 cameron cameron -135.80 ^ $Revision: 1.2 $ $Date: 2000/12/09 12:21:14 $

View Specific Customer

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

Add Charge Transaction
Thu May 3 13:40:23 EST 2001 Login: cameron Date: Comment: Amount:   ^

Add Payment Transaction
Thu May 3 13:40:13 EST 2001 Login: cameron Date: Comment: Amount:   ^

Modify User Hourly Rate
Thu May 3 13:40:32 EST 2001 Login: cameron Rate:   ^

Page Change Log