\UkvSystem

UKV cable TV accounting implementation

Synopsis

class UkvSystem {

// constants
const URL_TARIFFS_MGMT = '?module=ukv&tariffs=true';
const URL_USERS_MGMT = '?module=ukv&users=true';
const URL_USERS_LIST = '?module=ukv&users=true&userslist=true';
const URL_USERS_PROFILE = '?module=ukv&users=true&showuser=';
const URL_USERS_LIFESTORY = '?module=ukv&users=true&lifestory=true&showuser=';
const URL_USERS_REGISTER = '?module=ukv&users=true&register=true';
const URL_USERS_AJAX_SOURCE = '?module=ukv&ajax=true';
const URL_INET_USER_PROFILE = '?module=userprofile&username=';
const URTL_USERS_ANIHILATION = '?module=ukv&users=true&deleteuser=';
const URL_BANKSTA_MGMT = '?module=ukv&banksta=true';
const URL_BANKSTA_PROCESSING = '?module=ukv&banksta=true&showhash=';
const URL_BANKSTA_DETAILED = '?module=ukv&banksta=true&showdetailed=';
const URL_REPORTS_LIST = '?module=ukv&reports=true&showreport=reportList';
const URL_REPORTS_MGMT = '?module=ukv&reports=true&showreport=';
const URL_PHOTOSTORAGE = '?module=photostorage&scope=UKVUSERPROFILE&mode=list&itemid=';
const REG_ACT = 1;
const REG_CASH = 0;
const BANKSTA_IN_CHARSET = 'cp866';
const BANKSTA_OUT_CHARSET = 'utf-8';
const BANKSTA_PATH = 'content/documents/ukv_banksta/';
const BANKSTA_CONTRACT = 'ABCOUNT';
const BANKSTA_ADDRESS = 'ADDR';
const BANKSTA_REALNAME = 'FIO';
const BANKSTA_SUMM = 'SUMM';
const BANKSTA_NOTES = 'NAME_PLAT';
const BANKSTA_TIME = 'PTIME';
const BANKSTA_DATE = 'PDATE';
const OT_BANKSTA_CONTRACT = 'ABCOUNTT';
const OT_BANKSTA_ADDRESS = 'ADDRT';
const OT_BANKSTA_REALNAME = 'FIOTDT';
const OT_BANKSTA_SUMM = 'SUMMT';
const OT_BANKSTA_NOTES = 'NAME_PLAT';
const OT_BANKSTA_TIME = 'PTIMETT';
const OT_BANKSTA_DATE = 'PDATETT';
const PB_BANKSTA_CONTRACT = 'N_DOGOV';
const PB_BANKSTA_ADDRESS = 'ADR_TEL';
const PB_BANKSTA_REALNAME = 'FIO_PLAT';
const PB_BANKSTA_SUMM = 'SUMMA';
const PB_BANKSTA_NOTES = 'N_DOKUM';
const PB_BANKSTA_TIME = 'NOPE';
const PB_BANKSTA_DATE = 'OPERDEN';
const COLOR_FEE = 'a90000';
const COLOR_PAYMENT = '005304';
const COLOR_CORRECTING = 'ff6600';
const COLOR_MOCK = '006699';
const EX_TARIFF_FIELDS_EMPTY = 'EMPTY_TARIFF_OPTS_RECEIVED';
const EX_USER_NOT_EXISTS = 'NO_EXISTING_UKV_USER';
const EX_USER_NOT_SET = 'NO_VALID_USERID_RECEIVED';
const EX_USER_NO_TARIFF_SET = 'NO_TARIFF_SET';
const EX_USER_NOT_ACTIVE = 'USER_NOT_ACTIVE';
const EX_BANKSTA_PREPROCESS_EMPTY = 'BANK_STATEMENT_INPUT_INVALID';

// members
protected array $tariffs = ;
protected array $users = ;
protected array $cities = ;
protected array $streets = ;
protected array $cashtypes = ;
protected array $month = ;
protected array $contracts = ;
protected array $bankstarecords = ;
protected array $bankstafoundusers = ;
protected array $allTagtypes = ;
protected array $allUserTags = ;
protected array $altCfg = ;
protected $messages = '';
protected $ubConfig = NULL;
protected integer $debtLimit = 2;

// methods
public void __construct()
protected void loadConfigs()
protected void loadTariffs()
protected void loadCities()
protected void loadStreets()
protected void loadCashtypes()
protected void loadMonth()
protected void loadDebtLimit()
protected void loadTagtypes()
protected void loadUsertags()
protected void initMessages()
public void tariffCreate()
protected bool tariffIsProtected()
public void tariffDelete()
public void tariffSave()
protected void tariffEditForm()
protected string tariffCreateForm()
public void renderTariffs()
public string panel()
protected void loadUsers()
protected void userSetCash()
public void logPayment()
public void userAddCash()
public bool isMoney()
protected void feeCharge()
protected void feeChargeLog()
protected void tariffsMoveAll()
public int feeChargeAll()
public string userManualPaymentsForm()
public string userGetFullAddress()
public string userGetRealName()
public string tariffGetName()
public string userDeletionForm()
public void userDelete()
public string userRegisterForm()
public int userCreate()
protected string userCableSealForm()
protected string userEditForm()
public string userLifeStoryForm()
protected bool checkContract()
public void userCableSealSave()
public void userSave()
protected void userPostRegSave()
protected string profileTagsEditForm()
protected void catchTagChangeRequest()
protected array getTagParams()
public array getTariffs()
public array getUsers()
public array getUserData()
protected string getTagBody()
protected string renderUserTags()
protected string renderPluginContainer()
public string userProfile()
protected string filterStringData()
public string renderUsers()
public void ajaxUsers()
protected string translatePaymentNote()
public string userPaymentsRender()
public void paymentDelete()
public string bankstaLoadForm()
protected bool bankstaCheckHash()
public array bankstaDoUpload()
protected void bankstaCreateRow()
public string bankstaPreprocessing()
public string bankstaPreprocessingTerminal()
public string bankstaPreprocessingPrivatDbf()
public string bankstaProcessingForm()
public string bankstaGetDetailedRowInfo()
protected void loadBankstaAll()
protected bool bankstaIsUnprocessed()
public void bankstaSetProcessed()
public void bankstaPushPayments()
public void bankstaRenderAjaxList()
public type bankstaRenderList()
public void bankstaSetContract()
protected string buildReportTask()
public void reportList()
protected void reportPrintable()
public void reportDebtAddr()
public void reportDebtStreets()
protected int userGetByContract()
public array getDebtors()
public void reportDebtors()
public void reportAntiDebtors()
public void reportTariffs()
protected string paymentsGetYearSumm()
protected string paymentsGetMonthSumm()
protected string paymentsGetMonthCount()
protected void paymentsShowGraph()
protected string paymentsShow()
public void reportTagcloud()
public void reportFinance()
public void reportSignup()
public void reportFees()
public void reportStreets()
protected string renderInetAssignStats()
public void reportComplexAssign()
public void reportShouldbeComplex()
public void reportShouldNotbeComplex()
public void reportIntegrity()
public void getUbMessagesInstance()

}

Constants

Name	Value
URL_TARIFFS_MGMT	'?module=ukv&tariffs=true'
URL_USERS_MGMT	'?module=ukv&users=true'
URL_USERS_LIST	'?module=ukv&users=true&userslist=true'
URL_USERS_PROFILE	'?module=ukv&users=true&showuser='
URL_USERS_LIFESTORY	'?module=ukv&users=true&lifestory=true&showuser='
URL_USERS_REGISTER	'?module=ukv&users=true&register=true'
URL_USERS_AJAX_SOURCE	'?module=ukv&ajax=true'
URL_INET_USER_PROFILE	'?module=userprofile&username='
URTL_USERS_ANIHILATION	'?module=ukv&users=true&deleteuser='
URL_BANKSTA_MGMT	'?module=ukv&banksta=true'
URL_BANKSTA_PROCESSING	'?module=ukv&banksta=true&showhash='
URL_BANKSTA_DETAILED	'?module=ukv&banksta=true&showdetailed='
URL_REPORTS_LIST	'?module=ukv&reports=true&showreport=reportList'
URL_REPORTS_MGMT	'?module=ukv&reports=true&showreport='
URL_PHOTOSTORAGE	'?module=photostorage&scope=UKVUSERPROFILE&mode=list&itemid='
REG_ACT	1
REG_CASH	0
BANKSTA_IN_CHARSET	'cp866'
BANKSTA_OUT_CHARSET	'utf-8'
BANKSTA_PATH	'content/documents/ukv_banksta/'
BANKSTA_CONTRACT	'ABCOUNT'
BANKSTA_ADDRESS	'ADDR'
BANKSTA_REALNAME	'FIO'
BANKSTA_SUMM	'SUMM'
BANKSTA_NOTES	'NAME_PLAT'
BANKSTA_TIME	'PTIME'
BANKSTA_DATE	'PDATE'
OT_BANKSTA_CONTRACT	'ABCOUNTT'
OT_BANKSTA_ADDRESS	'ADDRT'
OT_BANKSTA_REALNAME	'FIOTDT'
OT_BANKSTA_SUMM	'SUMMT'
OT_BANKSTA_NOTES	'NAME_PLAT'
OT_BANKSTA_TIME	'PTIMETT'
OT_BANKSTA_DATE	'PDATETT'
PB_BANKSTA_CONTRACT	'N_DOGOV'
PB_BANKSTA_ADDRESS	'ADR_TEL'
PB_BANKSTA_REALNAME	'FIO_PLAT'
PB_BANKSTA_SUMM	'SUMMA'
PB_BANKSTA_NOTES	'N_DOKUM'
PB_BANKSTA_TIME	'NOPE'
PB_BANKSTA_DATE	'OPERDEN'
COLOR_FEE	'a90000'
COLOR_PAYMENT	'005304'
COLOR_CORRECTING	'ff6600'
COLOR_MOCK	'006699'
EX_TARIFF_FIELDS_EMPTY	'EMPTY_TARIFF_OPTS_RECEIVED'
EX_USER_NOT_EXISTS	'NO_EXISTING_UKV_USER'
EX_USER_NOT_SET	'NO_VALID_USERID_RECEIVED'
EX_USER_NO_TARIFF_SET	'NO_TARIFF_SET'
EX_USER_NOT_ACTIVE	'USER_NOT_ACTIVE'
EX_BANKSTA_PREPROCESS_EMPTY	'BANK_STATEMENT_INPUT_INVALID'

Members

protected

$allTagtypes — array
Contains all available tagtypes as id=>data
$allUserTags — array
Contains all available user tags
$altCfg — array
System alter.ini config represented as key=>value
$bankstafoundusers — array
Some magic goes here
$bankstarecords — array
Preprocessed banksta records
$cashtypes — array
Available system cashtypes
$cities — array
Available cities from directory
$contracts — array
Currently assigned users contracts as contract=>userid
$debtLimit
$messages —
System message helper object placeholder

$month — array
Default month array with localized names

$streets — array
Available streets from directory

$tariffs — array
Available tariffs as id=>data

$ubConfig — null
UbillingConfig object placeholder

$users — array
Available users and therir data as id=>data

Methods

protected

bankstaCheckHash() — checks is banksta hash unique?
bankstaCreateRow() — Creates new banksta row in Database
bankstaIsUnprocessed() — checks is banksta row ID unprocessed?
buildReportTask() — returns report icon and link
catchTagChangeRequest() — Catches and performs if required tagg adding/deletion for some user
checkContract() — checks is user contract unique
feeCharge() — charges month fee for some user
feeChargeLog() — logs fee charge fact to database
filterStringData() — Filter for quotes etc
getTagBody() — Returns tag html preprocessed body
getTagParams() — Returns tagtype data
initMessages() — Inits message helper object for further usage
loadBankstaAll() — loads all of banksta rows to further checks to private prop
loadCashtypes() — load all existing cashtypes into private cashtypes prop
loadCities() — loads all existing cities into private cities prop
loadConfigs() — Loads needed system configs into private data property
loadDebtLimit() — loads current debt limit from global config
loadMonth() — loads current month data into private props
loadStreets() — loads all existing streets into private streets prop
loadTagtypes() — Loads all available tagstypes
loadTariffs() — loads all tariffs into private tariffs prop
loadUsers() — loads all users from database to private prop users
loadUsertags() — Loads all available usertags
paymentsGetMonthCount() — returns month payments count by some year and month
paymentsGetMonthSumm() — returns month payments summ by some year and month
paymentsGetYearSumm() — returns payments year summ by selected year
paymentsShow() — returns UKV payments by some query
paymentsShowGraph() — shows payments graph for some year
profileTagsEditForm() — Returns tags edit interface for some user
renderInetAssignStats() — Renders users stats with assigned internet account
renderPluginContainer() — Renders profile plugin container
renderUserTags() — Returns user applied tags as browsable html
reportPrintable() — shows printable report content
tariffCreateForm() — returns tariff creation form
tariffEditForm() — returns tariff edit form
tariffIsProtected() — check is tariff protected/used by some users
tariffsMoveAll() — Changes all users tariffs and reloads users data if required
translatePaymentNote() — translates payment note for catv users
userCableSealForm() — Returns cable seal edit form
userEditForm() — returns user edit form for some userid
userGetByContract() — Returns UKV user id by contract
userPostRegSave() — protected method using to save address data for newly registered user
userSetCash() — just sets user balance to specified value

public

__construct() — Creates new UKV instance
ajaxUsers() — Extracts ajax data for JQuery data tables
bankstaDoUpload() — process of uploading of bank statement
bankstaGetDetailedRowInfo() — returns detailed banksta row info
bankstaLoadForm() — returns bank statement upload form
bankstaPreprocessing() — new banksta store in database bankstaDoUpload() method and returns preprocessed bank statement hash for further usage
bankstaPreprocessingPrivatDbf() — new banksta store in database bankstaDoUpload() method and returns preprocessed bank statement hash for further usage
bankstaPreprocessingTerminal() — new banksta store in database bankstaDoUpload() method and returns preprocessed bank statement hash for further usage
bankstaProcessingForm() — returns banksta processing form for some hash
bankstaPushPayments() — push payments to some user accounts via bank statements
bankstaRenderAjaxList() — Renders bank statements list datatables json datasource
bankstaRenderList() — Renders bank statements list container
bankstaSetContract() — cnahges banksta contract number for some existing row
bankstaSetProcessed() — sets banksta row as processed
feeChargeAll() — charges fee for all users and controls per month validity
getDebtors() — Returns array of available debtors
getTariffs() — Returns array of available UKV tariffs
getUbMessagesInstance()
getUserData() — Returns array with all user data for a certain UKV userID
getUsers() — Returns array of available UKV users
isMoney() — checks is input number valid money format or not?
logPayment() — logs payment to database
panel() — returns module control panel
paymentDelete() — Deletes some existing payment from database
renderTariffs() — renders CaTV tariffs list with some controls
renderUsers() — renders full user list with some ajax data
reportAntiDebtors() — renders anti-debtors report
reportComplexAssign() — Renders complex users assign forms or something like that.
reportDebtAddr() — Renders debtors notifications by address selection
reportDebtStreets() — Renders debtors notifications by address selection
reportDebtors() — renders debtors report
reportFees() — renders fees report by selected month
reportFinance() — renders finance report
reportIntegrity() — Renders UKV users integrity report
reportList() — renders report list
reportShouldNotbeComplex() — Renders report that should not be complex users
reportShouldbeComplex() — Renders report that should be complex users
reportSignup() — renders users signup report
reportStreets() — renders streets report
reportTagcloud() — Renders tagcloud report
reportTariffs() — renders tariffs popularity report
tariffCreate() — creates new tariff into database
tariffDelete() — deletes some existing tariff from database
tariffGetName() — Returns existing tariff name by tariffid
tariffSave() — saves some tariff params into database
userAddCash() — External interface for private setCash method used in manual finance ops
userCableSealSave() — Saves new cable seal value into database
userCreate() — registers new users into database and returns new user ID
userDelete() — deletes some user from database
userDeletionForm() — user deletion form
userGetFullAddress() — returns user full address if this one exists
userGetRealName() — Returns real name field for some user
userLifeStoryForm() — returns user lifestory strict parsed from system log
userManualPaymentsForm() — public interface view for manual payments processing
userPaymentsRender() — renders all of user payments from database
userProfile() — returns some existing user profile
userRegisterForm() — Returns user registration form
userSave() — saves some user params into database