\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