<% include( '/elements/header.html', 'Developer Documentation' ) %> <& /elements/menubar.html, 'Freeside Perl Modules' => $fsurl.'docs/library/FS.html', 'Complete Index' => $fsurl.'docs/library/index.html', &>

FS::access_user

NAME

FS::access_user - Object methods for access_user records

SYNOPSIS

  use FS::access_user;

  $record = new FS::access_user \%hash;
  $record = new FS::access_user { 'column' => 'value' };

  $error = $record->insert;

  $error = $new_record->replace($old_record);

  $error = $record->delete;

  $error = $record->check;

DESCRIPTION

An FS::access_user object represents an internal access user. FS::access_user inherits from FS::Record. The following fields are currently supported:

usernum - primary key
username -
_password -
last -
first -
disabled - empty or 'Y'

METHODS

new HASHREF

Creates a new internal access user. To add the user to the database, see "insert".

Note that this stores the hash reference, not a distinct copy of the hash it points to. You can ask the object for a copy with the hash method.

insert

Adds this record to the database. If there is an error, returns the error, otherwise returns false.

delete

Delete this record from the database.

replace OLD_RECORD

Replaces the OLD_RECORD with this one in the database. If there is an error, returns the error, otherwise returns false.

check

Checks all fields to make sure this is a valid internal access user. If there is an error, returns the error, otherwise returns false. Called by the insert and replace methods.

name

Returns a name string for this user: "Last, First".

user_cust_main

Returns the FS::cust_main object (see FS::cust_main), if any, for this user.

report_sales

Returns the FS::sales object (see FS::sales), if any, for this user.

access_usergroup

Returns links to the the groups this user is a part of, as FS::access_usergroup objects (see FS::access_usergroup).

num_agents

Returns the number of agents this user can view (via group membership).

agentnums

Returns a list of agentnums this user can view (via group membership).

agentnums_href

Returns a hashref of agentnums this user can view.

agentnums_sql [ HASHREF | OPTION => VALUE ... ]

Returns an sql fragement to select only agentnums this user can view.

Options are passed as a hashref or a list. Available options are:

null

The frament will also allow the selection of null agentnums.

null_right

The fragment will also allow the selection of null agentnums if the current user has the provided access right

table

Optional table name in which agentnum is being checked. Sometimes required to resolve 'column reference "agentnum" is ambiguous' errors.

column

Optional column name in which agentnum is being checked.

e.g: column => 'COALESCE ( cust_main.agentnum, prospect_main.agentnum )'

viewall_right

All agents will be viewable if the current user has the provided access right. Defaults to 'View customers of all agents'.

agentnum

Returns true if the user can view the specified agent.

Also accepts optional hashref cache, to avoid redundant database calls.

agents [ HASHREF | OPTION => VALUE ... ]

Returns the list of agents this user can view (via group membership), as FS::agent objects. Accepts the same options as the agentnums_sql method.

access_users [ HASHREF | OPTION => VALUE ... ]

Returns an array of FS::access_user objects, one for each non-disabled access_user in the system that shares an agent (via group membership) with the invoking object. Regardless of options and agents, will always at least return the invoking user and any users who have viewall_right.

Accepts the following options:

table

Only return users who appear in the usernum field of this table

disabled

Include disabled users if true (defaults to false)

viewall_right

All users will be returned if the current user has the provided access right, regardless of agents (other filters still apply.) Defaults to 'View customers of all agents'

access_users_hashref [ HASHREF | OPTION => VALUE ... ]

Accepts same options as "access_users". Returns a hashref of users, with keys of usernum and values of username.

access_right RIGHTNAME | LISTREF

Given a right name or a list reference of right names, returns true if this user has this right, or, for a list, one of the rights (currently via group membership, eventually also via user overrides).

refund_rights PAYBY

Accepts payment $payby (BILL,CASH,MCRD,MCHK,CARD,CHEK) and returns a list of the refund rights associated with that $payby.

Returns empty list if $payby wasn't recognized.

refund_access_right PAYBY

Returns true if user has "access_right" for any "refund_rights" for the specified payby.

default_customer_view

Returns the default customer view for this user, from the "default_customer_view" user preference, the "cust_main-default_view" config, or the hardcoded default, "basics" (formerly "jumbo" prior to 3.0).

spreadsheet_format [ OVERRIDE ]

Returns a hashref of this user's Excel spreadsheet download settings: 'extension' (xls or xlsx), 'class' (Spreadsheet::WriteExcel or Excel::Writer::XLSX), and 'mime_type'. If OVERRIDE is 'XLS' or 'XLSX', use that instead of the user's setting.

is_system_user

Returns true if this user has the name of a known system account. These users will not appear in the htpasswd file and can't have passwords set.

locale
get_page_pref PATH, NAME, TABLENUM

Returns the user's page preference named NAME for the page at PATH. If the page is a view or edit page or otherwise shows a single record at a time, it should use TABLENUM to tell which record the preference is for.

set_page_pref PATH, NAME, TABLENUM, VALUE

Sets the user's page preference named NAME for the page at PATH. Use TABLENUM as for get_page_pref.

get_pref NAME

Fetch the prefvalue column from FS::access_user_pref for prefname NAME

Returns undef when no value has been saved, or when record has expired

get_pref_row NAME

Fetch the row object from FS::access_user_pref for prefname NAME

returns undef when no row has been created

set_pref NAME, VALUE, [EXPIRATION_EPOCH]

Add or update user preference in FS::access_user_pref table

Passing an undefined VALUE will delete the user preference

Returns VALUE

delete_pref NAME

Delete user preference from FS::access_user_pref table

BUGS

SEE ALSO

FS::Record, schema.html from the base documentation.

POD ERRORS

Hey! The above document had some coding errors, which are explained below:

Around line 963:

You forgot a '=back' before '=head1'

<% include ('/elements/footer.html' ) %>