Adding new user |
Find user |
Displaying customer - part a |
Displaying customer - part b |
Editing Customer - part a |
Editing Customer - part b |
At some point I will be releasing hte code to my customer management pages and also potentially my customer self-care pages. I intended on having it done many months ago but a number of things have come up and it looks to be another 6 months or more before the code is ready to release. It's written in PHP and uses MySQL for the databse. It also ties into the Postfix database to handle adding/editing/changing email addresses and FreeRadius to handle radius attributes - speed tiers, non-pays etc..
Here is the config file as it is right now - as an example of how I am writing the code. You'll see I'm documenting everything I can to allow others to modify it easily.. I really just intend for the code to be a base work for others to expand upon as I really don't have the time to support it.
<?php
/*
* config.inc.php BPS Account Management
* Copyright (C) 2008 Robert Haas
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
* Purpose: Configuration Variables
*/
/*
* Database Configuration
*/
/* Database Hostname */
$CONF['db_host'] = 'localhost';
/* Database name */
$CONF['db_database'] = 'custdb';
/* Username with Permisions to the customer database */
$CONF['db_username'] = 'user';
/* Password for Database user */
$CONF['db_password'] = 'password';
/*
* Logging
*/
/* Turn Logging On/Off (TRUE/FALSE) */
$CONF['logging'] = TRUE;
/* Log File */
$CONF['log_file'] = 'logs/messages.txt';
/*
* Footer URL
*/
/* Text to appears as the footer link */
$CONF['footer_text'] = 'BPS Networks';
/* Footer URL */
$CONF['footer_url'] = 'http://www.bpsnetworks.com';
/*
* Page Title
*/
$CONF['html_title'] = 'BPS Networks Account Management';
/*
* Google Maps API
*
* You need a Key from Google to use this feature
* see: http://code.google.com/apis/maps/signup.html
*
* MUST Be using PHP 5 and have the simplexml module installed
*/
/* Do we want use google maps? */
$CONF['use_google_maps'] = TRUE;
/*
* Google Maps server
*
* maps.google.com for US city's
* maps.google.ca for canadian
*/
$CONF['google_maps_server'] = 'maps.google.com';
/* Your Google Maps key */
$CONF['google_maps_key'] = 'KEY';
/*
* Email Domains
*
* The domains you offer to your customers
*
* key => description
*/
$CONF['email_domains'] = array(
'bpsnetworks.com' => 'bpsnetworks.com',
'berniemo.us' => 'berniemo.us'
);
/*
* Number of Email Accounts to ask for in the add user pages
* We Allow 3 for no charge.
*/
$CONF['num_email_accounts'] = 3;
/*
* Required number of valid email accounts
* We require at least a single email address
*/
$CONF['num_required_email_accounts'] = 1;
/*
* Connection Types Array
* Multi-Dimensional Array
* Format: 'key' => array( 'dropdown' => '<your_drop_down>', 'desc' => '<your_description>', 'div' => 'your_div_tag' ),
*
* 'key' - must be unique and a numeral - order doesn't matter but you *CAN NOT* skip numerbers:
* Ex: 0,1,2,3 - OK 3,0,2,1 - OK 0,2,3,4 - NOT OK -1 is a place holder and should not be removed
*
* The order below is the order they appear in the dropdown menu
*
* 'dropdown' - What you want to appear in the drop down list
*
* 'desc' - A short description, used when sending emails etc.
*
* 'div' - The html div tag to hide/show when the option is selected in the dropdown
*
*/
$CONF['connection_types'] = array(
'-1' => array( 'dropdown' => 'Select Connection', 'desc' => 'Place holder' ),
'0' => array( 'dropdown' => '768K Res. DSL ($34.95)', 'desc' => '768K Residential DSL' , 'div' => 'dsl' ),
'6' => array( 'dropdown' => '1.5M Res. DSL ($44.95)', 'desc' => '1.5M Residential DSL', 'div' => 'dsl' ),
'10' => array( 'dropdown' => '3M Res. DSL ($54.95)', 'desc' => '3M Residential DSL', 'div' => 'dsl' ),
'8' => array( 'dropdown' => '768K Bus. DSL ($34.95)', 'desc' => '768K Business DSL', 'div' => 'dsl' ),
'9' => array( 'dropdown' => '1.5M Bus. DSL ($44.95)', 'desc' => '1.5M Business DSL', 'div' => 'dsl' ),
'11' => array( 'dropdown' => '3M Bus. DSL ($54.95)', 'desc' => '3M Business DSL', 'div' => 'dsl' ),
'5' => array( 'dropdown' => '768K Wireless ($34.95)', 'desc'=> '768k Wireless', 'div' => 'wireless' ),
'7' => array( 'dropdown' => '1.5M Wireless ($59.95)', 'desc'=> '1.5M Wireless', 'div' => 'wireless' ),
'12' => array( 'dropdown' => '1M Wireless ($48.95)', 'desc'=> '1M Wireless', 'div' => 'wireless' ),
'1' => array( 'dropdown' => 'Dialup ($21.95)', 'desc'=> 'Dialup', 'div' => 'dialup' ),
'2' => array( 'dropdown' => 'Hosting', 'desc' => 'Hosting' ),
'3' => array( 'dropdown' => 'Comped' ),
'4' => array( 'dropdown' => 'Dedicated' ) );
/*
* Wireless Tower Array
* Format: key => description
* Key must be unique
* Description - what will appear in the dropdown lists, descriptions and emails
*/
$CONF['tower_data'] = array(
'brn24_ho' => 'Bernie 2.4 Horizontal Omni (bpsbernie)',
'brn24_hw' => 'Bernie 2.4 Horizontal West (bpsnets_hwbrn)',
'cmpbl24_ho' => 'Campbell 2.5 Horizontal Omni (bpsnetscmb)',
'mldn24_hne' => 'Malden 2.4 Horizontal NorthEast (bpsnets_hne)'
);
/*
* Radio Data Array
* Format: key => description
*/
$CONF['radio_data'] = array(
'hg24' => 'HighGain 2.4Ghz',
'cnpy9i' => 'Canopy 900Mhz Integrated',
'cnpy9c' => 'Canopy 900Mhz Connectorized',
'wip7o' => 'WaveIP 700Mhz OSU',
'wip7r' => 'WaveIP 700Mhz RSU'
);
/*
* Customer Flag/State Array
* Format: key => description
* Key must be unique!
*/
$CONF['customer_flags'] = array(
'0' => 'Active',
'1' => 'NON-Payment',
'2' => 'DISCONNECTED');
/*
* Misc Settings
*/
/* Default state for the dropdown menu */
$CONF['default_state'] = 'MO';
/*
* Things Below Here shouldn't Need to be Modified
*/
/*
* Array of States
*/
$CONF['states'] = array(
'AL' => array( 'dropdown' => 'Alabama' ),
'AK' => array( 'dropdown' => 'Alaska' ),
'AZ' => array( 'dropdown' => 'Arizona' ),
'AR' => array( 'dropdown' => 'Arkansas' ),
'CA' => array( 'dropdown' => 'California' ),
'CO' => array( 'dropdown' => 'Colorado' ),
'CT' => array( 'dropdown' => 'Connecticut' ),
'DE' => array( 'dropdown' => 'Delaware' ),
'DC' => array( 'dropdown' => 'District of Columbia' ),
'FL' => array( 'dropdown' => 'Florida' ),
'GA' => array( 'dropdown' => 'Georgia' ),
'HI' => array( 'dropdown' => 'Hawaii' ),
'ID' => array( 'dropdown' => 'Idaho' ),
'IL' => array( 'dropdown' => 'Illinois' ),
'IN' => array( 'dropdown' => 'Indiana' ),
'IA' => array( 'dropdown' => 'Iowa' ),
'KS' => array( 'dropdown' => 'Kansas' ),
'KY' => array( 'dropdown' => 'Kentucky' ),
'LA' => array( 'dropdown' => 'Louisiana' ),
'ME' => array( 'dropdown' => 'Maine' ),
'MD' => array( 'dropdown' => 'Maryland' ),
'MA' => array( 'dropdown' => 'Massachusetts' ),
'MI' => array( 'dropdown' => 'Michigan' ),
'MN' => array( 'dropdown' => 'Minnesota' ),
'MS' => array( 'dropdown' => 'Mississippi' ),
'MO' => array( 'dropdown' => 'Missouri' ),
'MT' => array( 'dropdown' => 'Montana' ),
'NE' => array( 'dropdown' => 'Nebraska' ),
'NV' => array( 'dropdown' => 'Nevada' ),
'NH' => array( 'dropdown' => 'New Hampshire' ),
'NJ' => array( 'dropdown' => 'New Jersey' ),
'NM' => array( 'dropdown' => 'New Mexico' ),
'NY' => array( 'dropdown' => 'New York' ),
'NC' => array( 'dropdown' => 'North Carolina' ),
'ND' => array( 'dropdown' => 'North Dakota' ),
'OH' => array( 'dropdown' => 'Ohio' ),
'OK' => array( 'dropdown' => 'Oklahoma' ),
'OR' => array( 'dropdown' => 'Oregon' ),
'PA' => array( 'dropdown' => 'Pennsylvania' ),
'RI' => array( 'dropdown' => 'Rhode Island' ),
'SC' => array( 'dropdown' => 'South Carolina' ),
'SD' => array( 'dropdown' => 'South Dakota' ),
'TN' => array( 'dropdown' => 'Tennessee' ),
'TX' => array( 'dropdown' => 'Texas' ),
'UT' => array( 'dropdown' => 'Utah' ),
'VT' => array( 'dropdown' => 'Vermont' ),
'VA' => array( 'dropdown' => 'Virginia' ),
'WA' => array( 'dropdown' => 'Washington' ),
'WV' => array( 'dropdown' => 'West Virginia' ),
'WI' => array( 'dropdown' => 'Wisconsin' ),
'WY' => array( 'dropdown' => 'Wyoming' )
);
?>
