\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