From 6991d4986df7fb3a6c7c49b5ae1b3713e87a16c4 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 29 Jan 2002 16:33:16 +0000 Subject: - web interface for hourly account charges! (FS::cust_pkg, FS::cust_svc and FS::svc_acct seconds_since methods) - Makefile target to regenerate HTML manpages on install - FS.pm doc update - $FS::Record::Debug now dumps all SQL - new FS::cust_main methods: ->cancel, ->invoicing_list_addpost - start of a billing event web interface - cust_pay::upgrade_replace doesn't error out if history includes overapplied payments --- httemplate/docs/man/FS/Record.html | 56 +++++++++++++++++++++++++++----------- 1 file changed, 40 insertions(+), 16 deletions(-) (limited to 'httemplate/docs/man/FS/Record.html') diff --git a/httemplate/docs/man/FS/Record.html b/httemplate/docs/man/FS/Record.html index 09304083f..108a84ad7 100644 --- a/httemplate/docs/man/FS/Record.html +++ b/httemplate/docs/man/FS/Record.html @@ -17,7 +17,6 @@
  • CONSTRUCTORS
  • METHODS
  • SUBROUTINES
  • -
  • VERSION
  • BUGS
  • SEE ALSO
  • @@ -68,16 +67,17 @@
         $value = $record->unique('column');
    -    $value = $record->ut_float('column');
    -    $value = $record->ut_number('column');
    -    $value = $record->ut_numbern('column');
    -    $value = $record->ut_money('column');
    -    $value = $record->ut_text('column');
    -    $value = $record->ut_textn('column');
    -    $value = $record->ut_alpha('column');
    -    $value = $record->ut_alphan('column');
    -    $value = $record->ut_phonen('column');
    -    $value = $record->ut_anythingn('column');
    + $error = $record->ut_float('column'); + $error = $record->ut_number('column'); + $error = $record->ut_numbern('column'); + $error = $record->ut_money('column'); + $error = $record->ut_text('column'); + $error = $record->ut_textn('column'); + $error = $record->ut_alpha('column'); + $error = $record->ut_alphan('column'); + $error = $record->ut_phonen('column'); + $error = $record->ut_anything('column'); + $error = $record->ut_name('column');
         $dbdef = reload_dbdef;
         $dbdef = reload_dbdef "/non/standard/filename";
    @@ -125,6 +125,14 @@ objects.
     #regular FS::TABLE methods
     #on it.

    +
    jsearch TABLE, HASHREF, SELECT, EXTRA_SQL, PRIMARY_TABLE, PRIMARY_KEY
    +
    +Experimental JOINed search method. Using this method, you can execute a +single SELECT spanning multiple tables, and cache the results for subsequent +method calls. Interface will almost definately change in an incompatible +fashion. +

    Arguments:

    +

    qsearchs TABLE, HASHREF
    Same as qsearch, except that if more than one record matches, it carps but @@ -266,10 +274,29 @@ Check/untaint ip addresses. IPv4 only for now. May be null.
    Check/untaint host and domain names.

    +
    ut_name COLUMN
    +
    +Check/untaint proper names; allows alphanumerics, spaces and the following +punctuation: , . - ' +

    May not be null.

    +

    +
    ut_zip COLUMN
    +
    +Check/untaint zip codes. +

    +
    ut_country COLUMN
    +
    +Check/untaint country codes. Country names are changed to codes, if possible - +see the Locale::Country manpage. +

    ut_anything COLUMN
    Untaints arbitrary data. Be careful.

    +
    ut_enum COLUMN CHOICES_ARRAYREF
    +
    +Check/untaint a column, supplying all possible choices, like the ``enum'' type. +

    fields [ TABLE ]
    This can be used as both a subroutine and a method call. It returns a list @@ -303,10 +330,6 @@ This is depriciated. Don't use it.


    -

    VERSION

    -

    $Id: Record.html,v 1.1 2001-07-30 07:36:03 ivan Exp $

    -

    -


    BUGS

    This module should probably be renamed, since much of the functionality is of general use. It is not completely unlike Adapter::DBI (see below).

    @@ -323,7 +346,7 @@ true maps to the database (and WHERE clauses) would also help.

    A fallback check method should be provided which uses the dbdef.

    The ut_money method assumes money has two decimal digits.

    The Pg money kludge in the new method only strips `$'.

    -

    The ut_phonen method assumes US-style phone numbers.

    +

    The ut_phonen method only checks US-style phone numbers.

    The _quote function should probably use ut_float instead of a regex.

    All the subroutines probably should be methods, here or elsewhere.

    Probably should borrow/use some dbdef methods where appropriate (like sub @@ -331,6 +354,7 @@ fields)

    As of 1.14, DBI fetchall_hashref( {} ) doesn't set fetchrow_hashref NAME_lc, or allow it to be set. Working around it is ugly any way around - DBI should be fixed. (only affects RDBMS which return uppercase column names)

    +

    ut_zip should take an optional country like ut_phone.


    SEE ALSO

    -- cgit v1.2.1