\BankstaMd

XLS Bank statements processing class

Synopsis

class BankstaMd {

• // constants
• const BANKSTA_TABLE = 'bankstamd';
• const URL_ME = '?module=bankstamd';
• const URL_BANKSTA_MGMT = '?module=bankstamd&banksta=true';
• const URL_BANKSTA_PROCESSING = '?module=bankstamd&banksta=true&showhash=';
• const URL_BANKSTA_DETAILED = '?module=bankstamd&banksta=true&showdetailed=';
• const URL_USERS_PROFILE = '?module=userprofile&username=';
• const BANKSTA_PATH = 'content/documents/bankstamd/';
• // members
• protected array $altCfg = ;
• protected array $allUsersData = ;
• protected array $bankstarecords = ;
• protected array $contracts = ;
• protected array $allowedExtensions = ;
• protected  $excelReader = '';
• protected bool $debug = false;
• protected integer $skipRecords = 2;
• protected integer $bsContractOff = 0;
• protected integer $bsRealnameOff = 1;
• protected integer $bsAddressOff = 2;
• protected integer $bsSumOff = 3;
• protected integer $bsDateOff = 4;
• protected integer $contractNumeric = 0;
• protected integer $bsPaymentId = 1;
• protected array $bankstafoundusers = ;
• // methods
• public void __construct()
• protected void loadAlter()
• protected void setOptions()
• protected void loadUserData()
• protected void initExcelReader()
• public string renderBankstaLoadForm()
• public array bankstaDoUpload()
• protected bool bankstaCheckHash()
• protected void bankstaCreateRow()
• public string bankstaPreprocessing()
• public void catchUploadRequest()
• public type renderBankstaList()
• public void bankstaRenderAjaxList()
• public string bankstaProcessingForm()
• public string bankstaGetDetailedRowInfo()
• protected void loadBankstaAll()
• public void bankstaSetContract()
• protected bool bankstaIsUnprocessed()
• public void bankstaSetProcessed()
• public void bankstaPushPayments()
}


Constants

Name	Value
BANKSTA_TABLE	'bankstamd'
URL_ME	'?module=bankstamd'
URL_BANKSTA_MGMT	'?module=bankstamd&banksta=true'
URL_BANKSTA_PROCESSING	'?module=bankstamd&banksta=true&showhash='
URL_BANKSTA_DETAILED	'?module=bankstamd&banksta=true&showdetailed='
URL_USERS_PROFILE	'?module=userprofile&username='
BANKSTA_PATH	'content/documents/bankstamd/'

Members

protected

• $allUsersData — array
  Contains available users data as login=>userdata
• $allowedExtensions — array
  List of allowed extensions
• $altCfg — array
  Contains system alter config as key=>value
• $bankstafoundusers — array
  Contains detected users as contract=>login
• $bankstarecords — array
  Temp array for previous bank statements
• $bsAddressOff
• $bsContractOff
• $bsDateOff
• $bsPaymentId — int
  Default payment ID to push banksta payments
• $bsRealnameOff
• $bsSumOff
• $contractNumeric
• $contracts — array
  Contains available contracts mappings as contract=>login
• $debug — bool
  Just debug flag
• $excelReader —
  Excel reader object placeholder
• $skipRecords

Methods

protected

• bankstaCheckHash() — checks is banksta hash unique?
• bankstaCreateRow() — Creates new banksta row in Database
• bankstaIsUnprocessed() — checks is banksta row ID unprocessed?
• initExcelReader() — Inits reader object and performs file parsing
• loadAlter() — Loads system alter config into protected prop
• loadBankstaAll() — loads all of banksta rows to further checks to private prop
• loadUserData() — Loads all available users data from database
• setOptions() — Sets some config based options

public

• __construct() — Creates new BankstaMd instance
• bankstaDoUpload() — Process of uploading of bank statement
• bankstaGetDetailedRowInfo() — returns detailed banksta row info
• bankstaPreprocessing() — 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
• bankstaSetContract() — cnahges banksta contract number for some existing row
• bankstaSetProcessed() — sets banksta row as processed
• catchUploadRequest() — Catches file upload form and performs basic banksta preprocessing
• renderBankstaList() — Renders bank statements list container
• renderBankstaLoadForm() — Returns bank statement upload form