\ExtContras

- Вы делоете платежов? - Нет, просто показываю.

- Кросивое...

Synopsis

class ExtContras {

// constants
const URL_ME = '?module=extcontras';
const URL_EXTCONTRAS = 'extcontraslist';
const URL_EXTCONTRAS_COLORS = 'extcontrascolors';
const URL_DICTPROFILES = 'dictprofiles';
const URL_DICTCONTRACTS = 'dictcontracts';
const URL_DICTADDRESS = 'dictaddress';
const URL_DICTPERIODS = 'dictperiods';
const URL_FINOPERATIONS = 'finoperations';
const URL_INVOICES = 'invoices';
const URL_MISSEDPAYMENTS = 'misspayms';
const TABLE_EXTCONTRAS = 'extcontras';
const TABLE_EXTCONTRASEXTEN = 'extcontrasexten';
const TABLE_ECPROFILES = 'extcontras_profiles';
const TABLE_ECCONTRACTS = 'extcontras_contracts';
const TABLE_ECADDRESS = 'extcontras_address';
const TABLE_ECPERIODS = 'extcontras_periods';
const TABLE_ECMONEY = 'extcontras_money';
const TABLE_ECMONEYEXTEN = 'extcontras_moneyexten';
const TABLE_ECINVOICES = 'extcontras_invoices';
const TABLE_ECMISSPAYMENTS = 'extcontras_missed_payms';
const DBFLD_COMMON_ID = 'id';
const CTRL_PROFILE_NAME = 'profname';
const CTRL_PROFILE_EDRPO = 'profedrpo';
const CTRL_PROFILE_CONTACT = 'profcontact';
const CTRL_PROFILE_MAIL = 'profmail';
const DBFLD_PROFILE_NAME = 'name';
const DBFLD_PROFILE_EDRPO = 'edrpo';
const DBFLD_PROFILE_CONTACT = 'contact';
const DBFLD_PROFILE_MAIL = 'email';
const CTRL_CTRCT_CONTRACT = 'ctrctcontract';
const CTRL_CTRCT_DTSTART = 'ctrctdtstart';
const CTRL_CTRCT_DTEND = 'ctrctdtend';
const CTRL_CTRCT_SUBJECT = 'ctrctsubject';
const CTRL_CTRCT_AUTOPRLNG = 'ctrctautoprolong';
const CTRL_CTRCT_FULLSUM = 'ctrctfullsum';
const CTRL_CTRCT_NOTES = 'ctrctnotes';
const DBFLD_CTRCT_CONTRACT = 'contract';
const DBFLD_CTRCT_DTSTART = 'date_start';
const DBFLD_CTRCT_DTEND = 'date_end';
const DBFLD_CTRCT_SUBJECT = 'subject';
const DBFLD_CTRCT_AUTOPRLNG = 'autoprolong';
const DBFLD_CTRCT_FULLSUM = 'full_sum';
const DBFLD_CTRCT_NOTES = 'notes';
const CTRL_ADDRESS_ADDR = 'addraddress';
const CTRL_ADDRESS_SUM = 'addrsumm';
const CTRL_ADDRESS_CTNOTES = 'addrctrctnotes';
const CTRL_ADDRESS_NOTES = 'addrnotes';
const DBFLD_ADDRESS_ADDR = 'address';
const DBFLD_ADDRESS_SUM = 'summ';
const DBFLD_ADDRESS_CTNOTES = 'contract_notes';
const DBFLD_ADDRESS_NOTES = 'notes';
const CTRL_PERIOD_NAME = 'prdname';
const DBFLD_PERIOD_NAME = 'period_name';
const CTRL_MONEY_PROFILEID = 'moneyprofileid';
const CTRL_MONEY_CNTRCTID = 'moneycontractid';
const CTRL_MONEY_ADDRESSID = 'moneyaddressid';
const CTRL_MONEY_ACCRUALID = 'moneyaccrualid';
const CTRL_MONEY_INVOICEID = 'moneyinvoiceid';
const CTRL_MONEY_PURPOSE = 'moneypurpose';
const CTRL_MONEY_SUMACCRUAL = 'moneysummaccrual';
const CTRL_MONEY_SUMPAYMENT = 'moneysummpayment';
const CTRL_MONEY_INOUT = 'moneyinout';
const CTRL_MONEY_PAYNOTES = 'moneypaynotes';
const DBFLD_MONEY_PROFILEID = 'profile_id';
const DBFLD_MONEY_CNTRCTID = 'contract_id';
const DBFLD_MONEY_ADDRESSID = 'address_id';
const DBFLD_MONEY_ACCRUALID = 'accrual_id';
const DBFLD_MONEY_INVOICEID = 'invoice_id';
const DBFLD_MONEY_PURPOSE = 'purpose';
const DBFLD_MONEY_DATE = 'date';
const DBFLD_MONEY_DATE_EDIT = 'date_edit';
const DBFLD_MONEY_SMACCRUAL = 'summ_accrual';
const DBFLD_MONEY_SMPAYMENT = 'summ_payment';
const DBFLD_MONEY_DATE_PAYMENT = 'date_payment';
const DBFLD_MONEY_INCOMING = 'incoming';
const DBFLD_MONEY_OUTGOING = 'outgoing';
const DBFLD_MONEY_PAYNOTES = 'paynotes';
const CTRL_INVOICES_CONTRASID = 'invocontrasrecid';
const CTRL_INVOICES_INTERNAL_NUM = 'invointernalnum';
const CTRL_INVOICES_INVOICE_NUM = 'invoicenum';
const CTRL_INVOICES_DATE = 'invodate';
const CTRL_INVOICES_SUM = 'invosumm';
const CTRL_INVOICES_SUM_VAT = 'invosummvat';
const CTRL_INVOICES_NOTES = 'invonotes';
const CTRL_INVOICES_IN_OUT = 'invoinout';
const DBFLD_INVOICES_CONTRASID = 'contras_rec_id';
const DBFLD_INVOICES_INTERNAL_NUM = 'internal_number';
const DBFLD_INVOICES_INVOICE_NUM = 'invoice_number';
const DBFLD_INVOICES_DATE = 'date';
const DBFLD_INVOICES_SUM = 'summ';
const DBFLD_INVOICES_SUM_VAT = 'summ_vat';
const DBFLD_INVOICES_NOTES = 'notes';
const DBFLD_INVOICES_INCOMING = 'incoming';
const DBFLD_INVOICES_OUTGOING = 'outgoing';
const CTRL_EXTCONTRAS_PROFILE_ID = 'extcontraprofileid';
const CTRL_EXTCONTRAS_CONTRACT_ID = 'extcontracontractid';
const CTRL_EXTCONTRAS_ADDRESS_ID = 'extcontraaddressid';
const CTRL_EXTCONTRAS_PERIOD_ID = 'extcontraperiodid';
const CTRL_EXTCONTRAS_PAYDAY = 'extcontrapayday';
const DBFLD_EXTCONTRAS_PROFILE_ID = 'contras_id';
const DBFLD_EXTCONTRAS_CONTRACT_ID = 'contract_id';
const DBFLD_EXTCONTRAS_ADDRESS_ID = 'address_id';
const DBFLD_EXTCONTRAS_PERIOD_ID = 'period_id';
const DBFLD_EXTCONTRAS_MISSPAYM_ID = 'missed_paym_id';
const DBFLD_EXTCONTRAS_PAYDAY = 'payday';
const DBFLD_EXTCONTRAS_DATECREATE = 'date_create';
const CTRL_ECCOLOR_PAYEDTHISMONTH_BKGND = 'EC_PAYEDTHISMONTH_BKGND';
const CTRL_ECCOLOR_PAYEDTHISMONTH_FRGND = 'EC_PAYEDTHISMONTH_FRGND';
const CTRL_ECCOLOR_FIVEDAYSTILLPAY_BKGND = 'EC_FIVEDAYSTILLPAY_BKGND';
const CTRL_ECCOLOR_FIVEDAYSTILLPAY_FRGND = 'EC_FIVEDAYSTILLPAY_FRGND';
const CTRL_ECCOLOR_PAYMENTEXPIRED_BKGND = 'EC_PAYMENTEXPIRED_BKGND';
const CTRL_ECCOLOR_PAYMENTEXPIRED_FRGND = 'EC_PAYMENTEXPIRED_FRGND';
const DBFLD_MISSPAYMS_CONTRASID = 'contras_rec_id';
const DBFLD_MISSPAYMS_PROFILEID = 'profile_id';
const DBFLD_MISSPAYMS_CONTRACTID = 'contract_id';
const DBFLD_MISSPAYMS_ADDRESSID = 'address_id';
const DBFLD_MISSPAYMS_PERIOD_ID = 'period_id';
const DBFLD_MISSPAYMS_PAYDAY = 'payday';
const DBFLD_MISSPAYMS_DATE_PAYMENT = 'date_payment';
const DBFLD_MISSPAYMS_DATE_EXPIRED = 'date_expired';
const DBFLD_MISSPAYMS_DATE_PAYED = 'date_payed';
const DBFLD_MISSPAYMS_SUMPAYMENT = 'summ_payment';
const ROUTE_ACTION_CREATE = 'doCreate';
const ROUTE_ACTION_PREFILL = 'doPrefill';
const ROUTE_ACTION_EDIT = 'doEdit';
const ROUTE_ACTION_CLONE = 'doClone';
const ROUTE_ACTION_DELETE = 'doRemove';
const ROUTE_EDIT_REC_ID = 'editRecID';
const ROUTE_DELETE_REC_ID = 'deleteRecID';
const ROUTE_CONTRAS_ACTS = 'contrasacts';
const ROUTE_CONTRAS_JSON = 'contraslistjson';
const ROUTE_PROFILE_ACTS = 'profileacts';
const ROUTE_PROFILE_JSON = 'profilelistjson';
const ROUTE_CONTRACT_ACTS = 'contractacts';
const ROUTE_CONTRACT_JSON = 'contractlistjson';
const ROUTE_ADDRESS_ACTS = 'addressacts';
const ROUTE_ADDRESS_JSON = 'addresslistjson';
const ROUTE_PERIOD_ACTS = 'periodacts';
const ROUTE_PERIOD_JSON = 'periodlistjson';
const ROUTE_FINOPS_ACTS = 'finopsacts';
const ROUTE_FINOPS_JSON = 'finopslistjson';
const ROUTE_FINOPS_DETAILS_CNTRCTS = 'finopsdetailscontracts';
const ROUTE_FINOPS_DETAILS_ADDRESS = 'finopsdetailsaddress';
const ROUTE_INVOICES_ACTS = 'invoicesacts';
const ROUTE_INVOICES_JSON = 'invoiceslistjson';
const ROUTE_MISSPAYMS_ACTS = 'misspaymslistjson';
const ROUTE_MISSPAYMS_JSON = 'misspaymslistjson';
const ROUTE_FORCECACHE_UPD = 'extcontrasforcecacheupdate';
const ROUTE_2LVL_CNTRCTS_DETAIL = 'contras2lvlcntrctsdetails';
const ROUTE_2LVL_CNTRCTS_JSON = 'contras2lvlcntrctsjson';
const ROUTE_3LVL_ADDR_JSON = 'contras3lvladdrsjson';
const MISC_FILESTORAGE_SCOPE = 'EXCONTRAS';
const MISC_CLASS_MWID_CTRL = '__FormModalWindowID';
const MISC_CLASS_SUBMITFORM = '__FormSubmit';
const MISC_CLASS_SUBMITFORM_MODAL = '__FormSubmitModal';
const MISC_CLASS_EMPTYVALCHECK = '__EmptyCheckControl';
const MISC_CLASS_EMPTYVALCHECK_MODAL = '__EmptyCheckControlModal';
const MISC_CLASS_DPICKER_MODAL_INIT = '__DatePickerModalInit';
const MISC_JS_DEL_FUNC_NAME = 'deleteRec';
const MISC_ERRFORM_ID_PARAM = 'errfrmid';
const MISC_MARKROW_URL = 'markrowid';
const MISC_WEBFILTER_DATE_START = 'datefilterstart';
const MISC_WEBFILTER_DATE_END = 'datefilterend';
const MISC_WEBFILTER_PAYDAY = 'paydayfilter';
const MISC_WEBFILTER_MISSPAYMS = 'misspaysfilter';
const MISC_PREFILL_DATA = 'prefilldata';
const MISC_WEBSEL_PROFILES = 'WebSelECProfiles_';
const MISC_WEBSEL_CONTRACTS = 'WebSelECContracts_';
const MISC_WEBSEL_ADDRESS = 'WebSelECAddress_';
const MISC_WEBSEL_FILTDATA_CONTRACTS = 'WebSelContractFilterData_';
const MISC_WEBSEL_FILTDATA_ADDRESS = 'WebSelAddressFilterData_';
const MISC_WEBSEL_DBVAL_PROFILE_ID = 'ModalDBValProfile_';
const MISC_WEBSEL_DBVAL_CONTRACTS_ID = 'ModalDBValContract_';
const MISC_WEBSEL_DBVAL_ADDRESS_ID = 'ModalDBValAddress_';
const MISC_MISSED_PAYMENT_PROCESSING = 'misspaymprocessing';
const MISC_MISSED_PAYMENT_ID = 'missedpaymentid';
const MISC_FORMS_CAPTS_PROFILE_DICT = 'counterparty profile';
const MISC_FORMS_CAPTS_CNTRCTS_DICT = 'counterparty contract';
const MISC_FORMS_CAPTS_ADDRESS_DICT = 'contract address';
const MISC_FORMS_CAPTS_PERIODS_DICT = 'period';
const MISC_FORMS_CAPTS_INVOICES_LIST = 'invoice';
const MISC_FORMS_CAPTS_FINOPS_LIST = 'financial operation';
const MISC_FORMS_CAPTS_EXTCONTRAS = 'counterparty record';

// members
protected $dbExtContras = NULL;
protected $dbExtContrasExten = NULL;
protected $dbECProfiles = NULL;
protected $dbECContracts = NULL;
protected $dbECAddress = NULL;
protected $dbECPeriods = NULL;
protected $dbECMoney = NULL;
protected $dbECMoneyExten = NULL;
protected $dbECInvoices = NULL;
protected $dbECMissedPayms = NULL;
protected array $dbEntitiesAll = ;
protected array $dataEntitiesAll = ;
protected array $dbExtContrasStruct = ;
protected array $dbECProfilesStruct = ;
protected array $dbECContractsStruct = ;
protected array $dbECAddressStruct = ;
protected array $dbECPeriodsStruct = ;
protected array $dbECMoneyStruct = ;
protected array $dbECInvoicesStruct = ;
protected array $dbECMissedPaymsStruct = ;
protected array $allExtContras = ;
protected array $allExtContrasExten = ;
protected array $allECProfiles = ;
protected array $allECContracts = ;
protected array $allECAddresses = ;
protected array $allECPeriods = ;
protected array $allECMoney = ;
protected array $allECMoneyExten = ;
protected array $allECInvoices = ;
protected array $allECMissedPayms = ;
protected array $selectfiltECContractsAll = ;
protected array $selectfiltECAddressAll = ;
protected $ubConfig = NULL;
protected $ubCache = NULL;
protected $messages = NULL;
protected $fileStorage = NULL;
protected bool $fileStorageEnabled = false;
protected integer $ecEditablePreiod = 60;
protected integer $ecInvoicesON = 1;
protected integer $ecFullCtrctOverdueNoAddrOnly = 1;
protected integer $cacheLifeTime = 1800;
protected bool $ecReadOnlyAccess = false;
protected string $submitBtnDisabled = '';
protected string $supFrmFldMark = '';
protected string $payedThisMonthBKGND = '';
protected string $payedThisMonthFRGND = '';
protected string $fiveDaysTillPayBKGND = '';
protected string $fiveDaysTillPayFRGND = '';
protected string $paymentExpiredBKGND = '';
protected string $paymentExpiredFRGND = '';
public string $currencyStr = '';

// methods
public void __construct()
protected void loadOptions()
protected void initDBEntities()
public object|null getDBEntity()
public mixed|null getDataEntity()
protected void loadDBTableStructs()
public mixed loadDataFromTableCached()
protected void loadExtContrasExtenData()
public void loadFinopsExtenData()
protected void loadWebSelFilterData()
protected void loadAllData()
public void refreshCacheForced()
public array createCheckUniquenessArray()
public void setTableGridColorOpts()
public void getTableGridColorOpts()
public string checkCurMonthPaymExists()
public mixed checkContractHasAddresses()
protected string getStdJQDTWithJSForCRUDs()
protected string getStdJQDTActions()
protected string getDatePickerModalInitJS()
public mixed processCRUDs()
public string renderMainControls()
public string renderWebSelector()
public string renderWebMsg()
protected void recordCreateEdit()
protected void recordDelete()
public string profileWebForm()
public string profileRenderJQDT()
public void profileRenderListJSON()
public string contractWebForm()
public string contractRenderJQDT()
public void contractRenderListJSON()
public string addressWebForm()
public string addressRenderJQDT()
public void addressRenderListJSON()
public void periodWebForm()
public string periodRenderJQDT()
public void periodRenderListJSON()
public string invoiceFilterWebForm()
public string invoiceWebForm()
public string invoiceRenderJQDT()
public void invoiceRenderListJSON()
public string extcontrasFilterWebForm()
public string extcontrasFilterWebFormInline()
public string extcontrasWebForm()
public string extcontrasRenderMainJQDT()
public void extcontrasRenderListJSON()
public string ecRender2ndLvlContractsJQDT()
public void ecRender2ndLvlContractsListJSON()
public string ecRender2ndLvlAddressJQDT()
public void ecRender2ndLvlAddressListJSON()
protected void createMissedPayment()
public void updateMissedPaymentPayedDate()
public int|string getContraPayday()
public mixed|string getMissedPaymentPayDay()
public string extcontrasColorSettings()
public string finopsFilterWebForm()
public string finopsWebForm()
public string finopsRenderJQDT()
public void finopsRenderListJSON()
public string missedPaymsFilterWebForm()
public string missedPaymsRenderJQDT()
public void missedPaymsRenderListJSON()

}

Tasks

Line	Task
1217	check uniqueness of extrcontras recs by profile_id + contract_id + addr_id

Constants

Name	Value
URL_ME	'?module=extcontras'
URL_EXTCONTRAS	'extcontraslist'
URL_EXTCONTRAS_COLORS	'extcontrascolors'
URL_DICTPROFILES	'dictprofiles'
URL_DICTCONTRACTS	'dictcontracts'
URL_DICTADDRESS	'dictaddress'
URL_DICTPERIODS	'dictperiods'
URL_FINOPERATIONS	'finoperations'
URL_INVOICES	'invoices'
URL_MISSEDPAYMENTS	'misspayms'
TABLE_EXTCONTRAS	'extcontras'
TABLE_EXTCONTRASEXTEN	'extcontrasexten'
TABLE_ECPROFILES	'extcontras_profiles'
TABLE_ECCONTRACTS	'extcontras_contracts'
TABLE_ECADDRESS	'extcontras_address'
TABLE_ECPERIODS	'extcontras_periods'
TABLE_ECMONEY	'extcontras_money'
TABLE_ECMONEYEXTEN	'extcontras_moneyexten'
TABLE_ECINVOICES	'extcontras_invoices'
TABLE_ECMISSPAYMENTS	'extcontras_missed_payms'
DBFLD_COMMON_ID	'id'
CTRL_PROFILE_NAME	'profname'
CTRL_PROFILE_EDRPO	'profedrpo'
CTRL_PROFILE_CONTACT	'profcontact'
CTRL_PROFILE_MAIL	'profmail'
DBFLD_PROFILE_NAME	'name'
DBFLD_PROFILE_EDRPO	'edrpo'
DBFLD_PROFILE_CONTACT	'contact'
DBFLD_PROFILE_MAIL	'email'
CTRL_CTRCT_CONTRACT	'ctrctcontract'
CTRL_CTRCT_DTSTART	'ctrctdtstart'
CTRL_CTRCT_DTEND	'ctrctdtend'
CTRL_CTRCT_SUBJECT	'ctrctsubject'
CTRL_CTRCT_AUTOPRLNG	'ctrctautoprolong'
CTRL_CTRCT_FULLSUM	'ctrctfullsum'
CTRL_CTRCT_NOTES	'ctrctnotes'
DBFLD_CTRCT_CONTRACT	'contract'
DBFLD_CTRCT_DTSTART	'date_start'
DBFLD_CTRCT_DTEND	'date_end'
DBFLD_CTRCT_SUBJECT	'subject'
DBFLD_CTRCT_AUTOPRLNG	'autoprolong'
DBFLD_CTRCT_FULLSUM	'full_sum'
DBFLD_CTRCT_NOTES	'notes'
CTRL_ADDRESS_ADDR	'addraddress'
CTRL_ADDRESS_SUM	'addrsumm'
CTRL_ADDRESS_CTNOTES	'addrctrctnotes'
CTRL_ADDRESS_NOTES	'addrnotes'
DBFLD_ADDRESS_ADDR	'address'
DBFLD_ADDRESS_SUM	'summ'
DBFLD_ADDRESS_CTNOTES	'contract_notes'
DBFLD_ADDRESS_NOTES	'notes'
CTRL_PERIOD_NAME	'prdname'
DBFLD_PERIOD_NAME	'period_name'
CTRL_MONEY_PROFILEID	'moneyprofileid'
CTRL_MONEY_CNTRCTID	'moneycontractid'
CTRL_MONEY_ADDRESSID	'moneyaddressid'
CTRL_MONEY_ACCRUALID	'moneyaccrualid'
CTRL_MONEY_INVOICEID	'moneyinvoiceid'
CTRL_MONEY_PURPOSE	'moneypurpose'
CTRL_MONEY_SUMACCRUAL	'moneysummaccrual'
CTRL_MONEY_SUMPAYMENT	'moneysummpayment'
CTRL_MONEY_INOUT	'moneyinout'
CTRL_MONEY_PAYNOTES	'moneypaynotes'
DBFLD_MONEY_PROFILEID	'profile_id'
DBFLD_MONEY_CNTRCTID	'contract_id'
DBFLD_MONEY_ADDRESSID	'address_id'
DBFLD_MONEY_ACCRUALID	'accrual_id'
DBFLD_MONEY_INVOICEID	'invoice_id'
DBFLD_MONEY_PURPOSE	'purpose'
DBFLD_MONEY_DATE	'date'
DBFLD_MONEY_DATE_EDIT	'date_edit'
DBFLD_MONEY_SMACCRUAL	'summ_accrual'
DBFLD_MONEY_SMPAYMENT	'summ_payment'
DBFLD_MONEY_DATE_PAYMENT	'date_payment'
DBFLD_MONEY_INCOMING	'incoming'
DBFLD_MONEY_OUTGOING	'outgoing'
DBFLD_MONEY_PAYNOTES	'paynotes'
CTRL_INVOICES_CONTRASID	'invocontrasrecid'
CTRL_INVOICES_INTERNAL_NUM	'invointernalnum'
CTRL_INVOICES_INVOICE_NUM	'invoicenum'
CTRL_INVOICES_DATE	'invodate'
CTRL_INVOICES_SUM	'invosumm'
CTRL_INVOICES_SUM_VAT	'invosummvat'
CTRL_INVOICES_NOTES	'invonotes'
CTRL_INVOICES_IN_OUT	'invoinout'
DBFLD_INVOICES_CONTRASID	'contras_rec_id'
DBFLD_INVOICES_INTERNAL_NUM	'internal_number'
DBFLD_INVOICES_INVOICE_NUM	'invoice_number'
DBFLD_INVOICES_DATE	'date'
DBFLD_INVOICES_SUM	'summ'
DBFLD_INVOICES_SUM_VAT	'summ_vat'
DBFLD_INVOICES_NOTES	'notes'
DBFLD_INVOICES_INCOMING	'incoming'
DBFLD_INVOICES_OUTGOING	'outgoing'
CTRL_EXTCONTRAS_PROFILE_ID	'extcontraprofileid'
CTRL_EXTCONTRAS_CONTRACT_ID	'extcontracontractid'
CTRL_EXTCONTRAS_ADDRESS_ID	'extcontraaddressid'
CTRL_EXTCONTRAS_PERIOD_ID	'extcontraperiodid'
CTRL_EXTCONTRAS_PAYDAY	'extcontrapayday'
DBFLD_EXTCONTRAS_PROFILE_ID	'contras_id'
DBFLD_EXTCONTRAS_CONTRACT_ID	'contract_id'
DBFLD_EXTCONTRAS_ADDRESS_ID	'address_id'
DBFLD_EXTCONTRAS_PERIOD_ID	'period_id'
DBFLD_EXTCONTRAS_MISSPAYM_ID	'missed_paym_id'
DBFLD_EXTCONTRAS_PAYDAY	'payday'
DBFLD_EXTCONTRAS_DATECREATE	'date_create'
CTRL_ECCOLOR_PAYEDTHISMONTH_BKGND	'EC_PAYEDTHISMONTH_BKGND'
CTRL_ECCOLOR_PAYEDTHISMONTH_FRGND	'EC_PAYEDTHISMONTH_FRGND'
CTRL_ECCOLOR_FIVEDAYSTILLPAY_BKGND	'EC_FIVEDAYSTILLPAY_BKGND'
CTRL_ECCOLOR_FIVEDAYSTILLPAY_FRGND	'EC_FIVEDAYSTILLPAY_FRGND'
CTRL_ECCOLOR_PAYMENTEXPIRED_BKGND	'EC_PAYMENTEXPIRED_BKGND'
CTRL_ECCOLOR_PAYMENTEXPIRED_FRGND	'EC_PAYMENTEXPIRED_FRGND'
DBFLD_MISSPAYMS_CONTRASID	'contras_rec_id'
DBFLD_MISSPAYMS_PROFILEID	'profile_id'
DBFLD_MISSPAYMS_CONTRACTID	'contract_id'
DBFLD_MISSPAYMS_ADDRESSID	'address_id'
DBFLD_MISSPAYMS_PERIOD_ID	'period_id'
DBFLD_MISSPAYMS_PAYDAY	'payday'
DBFLD_MISSPAYMS_DATE_PAYMENT	'date_payment'
DBFLD_MISSPAYMS_DATE_EXPIRED	'date_expired'
DBFLD_MISSPAYMS_DATE_PAYED	'date_payed'
DBFLD_MISSPAYMS_SUMPAYMENT	'summ_payment'
ROUTE_ACTION_CREATE	'doCreate'
ROUTE_ACTION_PREFILL	'doPrefill'
ROUTE_ACTION_EDIT	'doEdit'
ROUTE_ACTION_CLONE	'doClone'
ROUTE_ACTION_DELETE	'doRemove'
ROUTE_EDIT_REC_ID	'editRecID'
ROUTE_DELETE_REC_ID	'deleteRecID'
ROUTE_CONTRAS_ACTS	'contrasacts'
ROUTE_CONTRAS_JSON	'contraslistjson'
ROUTE_PROFILE_ACTS	'profileacts'
ROUTE_PROFILE_JSON	'profilelistjson'
ROUTE_CONTRACT_ACTS	'contractacts'
ROUTE_CONTRACT_JSON	'contractlistjson'
ROUTE_ADDRESS_ACTS	'addressacts'
ROUTE_ADDRESS_JSON	'addresslistjson'
ROUTE_PERIOD_ACTS	'periodacts'
ROUTE_PERIOD_JSON	'periodlistjson'
ROUTE_FINOPS_ACTS	'finopsacts'
ROUTE_FINOPS_JSON	'finopslistjson'
ROUTE_FINOPS_DETAILS_CNTRCTS	'finopsdetailscontracts'
ROUTE_FINOPS_DETAILS_ADDRESS	'finopsdetailsaddress'
ROUTE_INVOICES_ACTS	'invoicesacts'
ROUTE_INVOICES_JSON	'invoiceslistjson'
ROUTE_MISSPAYMS_ACTS	'misspaymslistjson'
ROUTE_MISSPAYMS_JSON	'misspaymslistjson'
ROUTE_FORCECACHE_UPD	'extcontrasforcecacheupdate'
ROUTE_2LVL_CNTRCTS_DETAIL	'contras2lvlcntrctsdetails'
ROUTE_2LVL_CNTRCTS_JSON	'contras2lvlcntrctsjson'
ROUTE_3LVL_ADDR_JSON	'contras3lvladdrsjson'
MISC_FILESTORAGE_SCOPE	'EXCONTRAS'
MISC_CLASS_MWID_CTRL	'__FormModalWindowID'
MISC_CLASS_SUBMITFORM	'__FormSubmit'
MISC_CLASS_SUBMITFORM_MODAL	'__FormSubmitModal'
MISC_CLASS_EMPTYVALCHECK	'__EmptyCheckControl'
MISC_CLASS_EMPTYVALCHECK_MODAL	'__EmptyCheckControlModal'
MISC_CLASS_DPICKER_MODAL_INIT	'__DatePickerModalInit'
MISC_JS_DEL_FUNC_NAME	'deleteRec'
MISC_ERRFORM_ID_PARAM	'errfrmid'
MISC_MARKROW_URL	'markrowid'
MISC_WEBFILTER_DATE_START	'datefilterstart'
MISC_WEBFILTER_DATE_END	'datefilterend'
MISC_WEBFILTER_PAYDAY	'paydayfilter'
MISC_WEBFILTER_MISSPAYMS	'misspaysfilter'
MISC_PREFILL_DATA	'prefilldata'
MISC_WEBSEL_PROFILES	'WebSelECProfiles_'
MISC_WEBSEL_CONTRACTS	'WebSelECContracts_'
MISC_WEBSEL_ADDRESS	'WebSelECAddress_'
MISC_WEBSEL_FILTDATA_CONTRACTS	'WebSelContractFilterData_'
MISC_WEBSEL_FILTDATA_ADDRESS	'WebSelAddressFilterData_'
MISC_WEBSEL_DBVAL_PROFILE_ID	'ModalDBValProfile_'
MISC_WEBSEL_DBVAL_CONTRACTS_ID	'ModalDBValContract_'
MISC_WEBSEL_DBVAL_ADDRESS_ID	'ModalDBValAddress_'
MISC_MISSED_PAYMENT_PROCESSING	'misspaymprocessing'
MISC_MISSED_PAYMENT_ID	'missedpaymentid'
MISC_FORMS_CAPTS_PROFILE_DICT	'counterparty profile'
MISC_FORMS_CAPTS_CNTRCTS_DICT	'counterparty contract'
MISC_FORMS_CAPTS_ADDRESS_DICT	'contract address'
MISC_FORMS_CAPTS_PERIODS_DICT	'period'
MISC_FORMS_CAPTS_INVOICES_LIST	'invoice'
MISC_FORMS_CAPTS_FINOPS_LIST	'financial operation'
MISC_FORMS_CAPTS_EXTCONTRAS	'counterparty record'

Members

protected

$allECAddresses — array
Contains all extcontras addresses records from DB ecaddressid => ecaddressdata
$allECContracts — array
Contains all extcontras contracts records from DB eccontractid => eccontractdata
$allECInvoices — array
Contains all extcontras invoices records from DB ecinvoiceid => ecinvoicedata
$allECMissedPayms — array
Contains all extcontras overdue payments records from DB ecmisspaymid => ecmisspaymdata
$allECMoney — array
Contains all extcontras money records from DB ecmoneyid => ecmoneydata
$allECMoneyExten — array
Contains all extcontras money records from DB as ececmoneyid => ecmoneydata + data JOINed from `extcontras` table
$allECPeriods — array
Contains all extcontras periods records from DB ecperiodid => ecperioddata
$allECProfiles — array
Contains all extcontras profiles records from DB ecprofileid => ecprofiledata
$allExtContras — array
Contains all extcontras records from DB as ecid => ecdata
$allExtContrasExten — array
Contains all extcontras records from DB as ecid => ecdata + data JOINed from related tables
$cacheLifeTime — int
Placeholder for EXTCONTRAS_CACHE_LIFETIME from alter.ini
$dataEntitiesAll — array
Contains all data entities objects in array($tableName => $dataEntity)
$dbECAddress —
Database abstraction layer with for `extcontras_address` table

$dbECAddressStruct — array
Placeholder for $dbECAddress DB table field structure

$dbECContracts —
Database abstraction layer with for `extcontras_contracts` table

$dbECContractsStruct — array
Placeholder for $dbECContracts DB table field structure

$dbECInvoices —
Database abstraction layer with for `extcontras_invoices` table

$dbECInvoicesStruct — array
Placeholder for $dbECInvoices DB table field structure

$dbECMissedPayms —
Database abstraction layer with for `extcontras_missed_payms` table

$dbECMissedPaymsStruct — array
Placeholder for $dbECMissedPayms DB table field structure

$dbECMoney —
Database abstraction layer with for `extcontras_money` table

$dbECMoneyExten —
Database abstraction layer with for `money` table + data JOINed from `extcontras` table

$dbECMoneyStruct — array
Placeholder for $dbECExtMoney DB table field structure

$dbECPeriods —
Database abstraction layer with for `extcontras_periods` table

$dbECPeriodsStruct — array
Placeholder for $dbECPeriods DB table field structure

$dbECProfiles —
Database abstraction layer with for `extcontras_profiles` table

$dbECProfilesStruct — array
Placeholder for $dbECProfiles DB table field structure

$dbEntitiesAll — array
Contains all DB entities objects in array($tableName => $dbEntity)

$dbExtContras —
Database abstraction layer with for `extcontras` table

$dbExtContrasExten —
Database abstraction layer with for `extcontras` table + data JOINed from related tables

$dbExtContrasStruct — array
Placeholder for $dbExtContras DB table field structure

$ecEditablePreiod — int
Placeholder for EXTCONTRAS_EDIT_ALLOWED_DAYS alter.ini option

$ecFullCtrctOverdueNoAddrOnly — int
Placeholder for EXTCONTRAS_OVERDUE_CONTRACT_NO_ADDR alter.ini option

$ecInvoicesON — int
Placeholder for EXTCONTRAS_INVOICE_ON alter.ini option

$ecReadOnlyAccess — bool
Placeholder for cfr('EXTCONTRASRO')
$fileStorage —
System files storage placeholder

$fileStorageEnabled — bool
Placeholder for FILESTORAGE_ENABLED alter.ini option
$fiveDaysTillPayBKGND — string
Background color for records which need to be payed during next 5 days
$fiveDaysTillPayFRGND — string
Foreground color for records which need to be payed during next 5 days
$messages —
System message helper object placeholder

$payedThisMonthBKGND — string
Background color for records which have payments in current month

$payedThisMonthFRGND — string
Foreground color for records which have payments in current month

$paymentExpiredBKGND — string
Background color for records which payday has passed already

$paymentExpiredFRGND — string
Foreground color for records which payday has passed already

$selectfiltECAddressAll — array
Contains selector control filtering array for an address dropdown selector

$selectfiltECContractsAll — array
Contains selector control filtering array for a contracts dropdown selector

$submitBtnDisabled — string
Contains HTML attribute to disable from's submit buttons on read only access

$supFrmFldMark — string
Placeholder for mandatory fields SUP mark

$ubCache — null
UbillingCache instance placeholder

$ubConfig — null
System config object placeholder

public

$currencyStr — string
Placeholder for TEMPLATE_CURRENCY alter.ini option

Methods

protected

createMissedPayment() — Creates a missed payment record from params
getDatePickerModalInitJS() — Simply returns JS snippet for datepicker init on dynamic modal forms
getStdJQDTActions() — Returns typical JQDT "actions" controls, like "Delete", "Edit", "Clone"
getStdJQDTWithJSForCRUDs() — Returns typical JQDT with or without JS code for interacting with modals and dynamic modals
initDBEntities() — Inits DB NyanORM objects
loadAllData() — Unified data loader
loadDBTableStructs() — Loads DB tables fields structures to a class properties
loadExtContrasExtenData() — Loads extended external counterparties data
loadOptions() — Loads alter.ini options
loadWebSelFilterData() — Retrieves data for contracts web selector control filtering
recordCreateEdit() — Cumulative method for creating and editing some DB records
recordDelete()

public

__construct()
addressRenderJQDT() — Renders JQDT for address dictionary
addressRenderListJSON() — Renders JSON for address's dictionary JQDT
addressWebForm() — Returns a address-editor web form
checkContractHasAddresses() — Returns array of addresses assigned to a certain combination of $profileID + $contractID
checkCurMonthPaymExists() — Searches for any occurrences of current month payments for a certain counterparty ID
contractRenderJQDT() — Renders JQDT for contracts dictionary
contractRenderListJSON() — Renders JSON for contract's dictionary JQDT
contractWebForm() — Returns a contract-editor web form
createCheckUniquenessArray() — Returns prepared filtering array for NyanORM checkRecExists() method
ecRender2ndLvlAddressJQDT() — Renders third-level contract-address JQDT for external counterparty list
ecRender2ndLvlAddressListJSON() — Renders JSON for external counterparty contract-address JQDT
ecRender2ndLvlContractsJQDT() — Renders second-level contract-address JQDT for external counterparty list
ecRender2ndLvlContractsListJSON() — Renders JSON for external counterparty contract-address JQDT
extcontrasColorSettings() — Renders counterparties table coloring settings form
extcontrasFilterWebForm() — Returns a filter web form for extcontras main form
extcontrasFilterWebFormInline() — Returns a filter web form for extcontras main form
extcontrasRenderListJSON() — Renders JSON for external counterparty JQDT
extcontrasRenderMainJQDT() — Renders main top-level JQDT for external counterparty list
extcontrasWebForm() — Returns a external counterparty editor web form
finopsFilterWebForm() — Returns a filter web form for invoices main form
finopsRenderJQDT() — Renders JQDT for external counterparty finance operations list
finopsRenderListJSON() — Renders JSON for finance operations JQDT
finopsWebForm() — Returns a financial operations editor web form
getContraPayday() — Returns payday of the contragent by profile ID + contract ID [+ address ID]
getDBEntity() — Returns DB entity object by table name
getDataEntity() — Returns data entity object by table name
getMissedPaymentPayDay() — Returns payday of the missed payment by its ID
getTableGridColorOpts() — Loads counterparties list coloring to class properties
invoiceFilterWebForm() — Returns a filter web form for invoices main form
invoiceRenderJQDT() — Renders JQDT for invoices list
invoiceRenderListJSON() — Renders JSON for invoices JQDT
invoiceWebForm() — Returns an invoice-editor web form
loadDataFromTableCached() — Loads data from a DB table or UB cache
loadFinopsExtenData() — Loads extended external finops data
missedPaymsFilterWebForm() — Returns expired payments filter webform
missedPaymsRenderJQDT() — Renders JQDT for overdue payments list
missedPaymsRenderListJSON() — Renders JSON for overdue payments JQDT
periodRenderJQDT() — Renders JQDT for period dictionary
periodRenderListJSON() — Renders JSON for period's dictionary JQDT
periodWebForm()
processCRUDs() — Ash oghum durbatulûk, ash oghum gimbatul, Ash oghum thrakatulûk, agh burzum-ishi krimpatul.
profileRenderJQDT() — Renders JQDT for profiles dictionary
profileRenderListJSON() — Renders JSON for profile's dictionary JQDT
profileWebForm() — Returns a profile-editor web form
refreshCacheForced() — Forcibly updates cached data
renderMainControls() — Renders main module controls
renderWebMsg() — Returns modal window with some message and pre-defined DOM ID
renderWebSelector() — Returns dropdown selector control
setTableGridColorOpts() — Saves counterparties list coloring to ubStorage
updateMissedPaymentPayedDate() — Updates a missed payment record paid date field