$ https://outlook.office.com/mail/
$ http://localhost:8080/vox/admin/login/login.jsp

$ https://solidlogmanager.voxcore.co.za:5601/
Full.Name Pascal Case

$ https://xenon.soliditech.com/users/sign_in
Short Name
GitLab

$ https://docs.google.com/forms/d/1t3I7mQN8Nh8TE9Dl_Ik5DxvJDDbX0Q5516qtcrvKuuE/viewform?edit_requested=true

$ https://trello.com/b/yHzHF1Yo/vox-swat
Office username full

$ https://docs.google.com/spreadsheets/d/1GEDSOehjysiFJ027NsJ2fHr-T7HStHbkhBCxRxjiaXQ/edit#gid=1109698558
Leave Roaster 2023

$ sudo openfortivpn --config=/etc/openfortivpn/configvox
host = voxwavvpn.voxtelecom.co.za
port = 443
username = username without realm
password = password
trusted-cert = 55fbdab7f86ba794aeeca63aa2t7e55394f2d740e97b4k3c09a6293e9f142ba898
realm = vox

$ cd "C:\workspace\soliditechcore\JavaScript Source"
$ npm install
$ npm run-script build-dev-vox

com.atlantic.channelcommissions.ChannelCommissionCalculatorTest#testCalculateCommissions

public List getAllPaymentAccountsForCommissionUser(long commissionUserId)
{
 //return HibernateUtil.find("select pa.id from MasterAccount m, PaymentAccount pa where m.commissionUserId = ? and m.id = pa.masterAccountId and m.id=952116", commissionUserId);
 //return HibernateUtil.find("select pa.id from MasterAccount m, PaymentAccount pa where m.commissionUserId = ? and m.id = pa.masterAccountId and m.id=927301", commissionUserId);
 //return HibernateUtil.find("select pa.id from MasterAccount m, PaymentAccount pa where m.commissionUserId = ? and m.id = pa.masterAccountId and m.id=454839", commissionUserId);
 return HibernateUtil.find("select pa.id from MasterAccount m, PaymentAccount pa where m.commissionUserId = ? and m.id = pa.masterAccountId and m.id=952116", commissionUserId);
}

select ma.accountId, ma.customerName, ma.commissionUserId, ma.id, ma.commissionTierId, ma.commissionGradingId, ma.upfrontCommissions, ma.* from master_accounts ma where ma.id in (312683, 601055, 886674, 525658);

select p.productCode, c.contractNumber, p.channelCommissionsServiceGroupId, ma.commissionTierId, ma.commissionTaxTypeId, ma.commissionGradingId, ma.upfrontCommissions, ma.commissionUserId, ma.id, sa.username, sa.statusId, ccuc.* from contracts c join products p on c.productId = p.id
join channel_commission_upfront_control ccuc on ccuc.contractId = c.id
join service_accounts sa on c.serviceAccountId = sa.id
join master_accounts ma on sa.masterAccountId = ma.id
where p.productCode = 'FTTH-L2-OC-25/25' and ccuc.upfrontAmount = 250; #and ccuc.commissionUserId in (601055, 886674, 525658);

select p.productCode, c.contractNumber, p.channelCommissionsServiceGroupId, ma.commissionTierId, ma.commissionTaxTypeId, ma.commissionGradingId, ma.upfrontCommissions, ma.commissionUserId, ma.id, sa.username, sa.statusId, ccuc.* from contracts c join products p on c.productId = p.id
join channel_commission_upfront_control ccuc on ccuc.contractId = c.id
join service_accounts sa on c.serviceAccountId = sa.id
join master_accounts ma on sa.masterAccountId = ma.id
where p.productCode = 'FTTH-L2-OC-25/25' and ccuc.upfrontAmount != 250; #and ccuc.commissionUserId in (601055, 886674, 525658);

select p.productCode, c.contractNumber, p.channelCommissionsServiceGroupId, ma.commissionTierId, ma.commissionTaxTypeId, ma.commissionGradingId, ma.upfrontCommissions, ma.commissionUserId, ma.id, sa.username, sa.statusId, ccuc.* from contracts c join products p on c.productId = p.id
join channel_commission_upfront_control ccuc on ccuc.contractId = c.id
join service_accounts sa on c.serviceAccountId = sa.id
join master_accounts ma on sa.masterAccountId = ma.id
where p.productCode = 'FTTH-L2-OC-25/25' and ccuc.commissionUserId in (886674) order by ccuc.createDate desc;

select count(contractId), contractId from channel_commission_upfront_control ccuc group by contractId;

select * from channel_commission_cost_prices;
select * from channel_commission_cost_prices where accountId = '601055';
select * from channel_commission_run_results where masterAccountId = 601055;

select * from fn_ledger_tx;
select * from fn_ledger_account_period;
select * from fn_financial_tx;
select * from fn_financial_tx_line;
select * from fn_financial_year_period;
select * from channel_commissions_agent_tiers;
select * from channel_commissions_agent_tier_highs;
select * from channel_commissions_billing_rules;
select * from channel_commissions_monthly_recurring_charges;
select * from channel_commission_control;
select * from channel_commission_upfront_control;

select * from channel_commission_control where txLineId = 101212615;
select * from channel_commissions_monthly_recurring_charges where masterAccountId = 312683 and financialPeriodId = 121;
select * from fn_financial_tx where txNumber = 'IAB22217830';
select * from fn_financial_tx where txNumber = 'IAB22333964';

select * from fn_financial_tx objct, fn_ledger_tx tx, fn_ledger_account_period txp where objct.paymentAccountId = ? and tx.sourceTxId = objct.id and tx.ledgerAccountPeriodId = txp.id and txp.financialPeriodId = ? and objct.statusId > 3 and objct.statusId < 10;
select * from fn_financial_tx objct, fn_ledger_tx tx, fn_ledger_account_period txp where tx.sourceTxId = objct.id and tx.ledgerAccountPeriodId = txp.id and objct.statusId > 3 and objct.statusId < 10;
select * from fn_financial_tx objct, fn_ledger_tx tx, fn_ledger_account_period txp where tx.sourceTxId = objct.id and tx.ledgerAccountPeriodId = txp.id and objct.statusId > 3 and objct.statusId < 10;

select statusId from fn_financial_tx;

update fn_financial_tx set statusId = 4;
commit;

create table fn_ledger_account_period_bak as select * from fn_ledger_account_period;
delete from fn_ledger_account_period;
delete from fn_financial_year_period;
commit;