com.aoindustries.aoserv.client.billing.MonthlyChargeTable Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of aoserv-client Show documentation
Show all versions of aoserv-client Show documentation
Java client for the AOServ Platform.
/*
* aoserv-client - Java client for the AOServ Platform.
* Copyright (C) 2001-2013, 2016, 2017, 2018, 2019 AO Industries, Inc.
* [email protected]
* 7262 Bull Pen Cir
* Mobile, AL 36695
*
* This file is part of aoserv-client.
*
* aoserv-client is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* aoserv-client is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with aoserv-client. If not, see {
MonthlyChargeTable(AOServConnector connector) {
super(connector, MonthlyCharge.class);
}
private static final OrderBy[] defaultOrderBy = {
// new OrderBy(MonthlyCharge.COLUMN_ACCOUNTING_name, ASCENDING),
new OrderBy(MonthlyCharge.COLUMN_PACKAGE_name, ASCENDING),
new OrderBy(MonthlyCharge.COLUMN_TYPE_name, ASCENDING),
new OrderBy(MonthlyCharge.COLUMN_CREATED_name, ASCENDING)
};
@Override
protected OrderBy[] getDefaultOrderBy() {
return defaultOrderBy;
}
@Override
public MonthlyCharge get(int pkey) throws SQLException, IOException {
return getUniqueRow(MonthlyCharge.COLUMN_PKEY, pkey);
}
private static void addCount(Map map, K key, int count) {
map.put(key, NullMath.add(map.get(key), count));
}
/**
* Gets the list of all monthly_charges in the database. In addition
* to the monthly charges in the database, the package charges, additional email users,
* additional ip addresses, and additional shell users are added to the billing.
*
* @param sourceAccount the optional source account to filter by
* @param billingAccount the optional billing account to filter by
*
* @return the MonthlyCharge objects.
*/
private List getModifiableMonthlyCharges(Administrator administrator, Account sourceAccount, Account billingAccount) throws IOException, SQLException {
// Add the entries in the monthly_charges table that apply to this business
List charges;
{
List cached=super.getRows();
int len=cached.size();
charges=new ArrayList<>(len);
for(int c=0;c emailsPerPackage = new HashMap<>();
Map usersPerPackage = new HashMap<>();
{
for(UserServer lsa : connector.getLinux().getUserServer().getRows()) {
com.aoindustries.aoserv.client.linux.User.Name username=lsa.getLinuxAccount_username_id();
if(!username.equals(com.aoindustries.aoserv.client.linux.User.MAIL)) {
Map map;
com.aoindustries.aoserv.client.linux.User la=lsa.getLinuxAccount();
if(la.getType().getName().equals(UserType.EMAIL)) map=emailsPerPackage;
else map=usersPerPackage;
addCount(map, la.getUsername().getPackage(), 1);
}
}
}
Map javavmsPerPackage=new HashMap<>();
{
// HttpdSharedTomcats
for(SharedTomcat hst : connector.getWeb_tomcat().getSharedTomcat().getRows()) {
if(!hst.isDisabled()) {
addCount(javavmsPerPackage, hst.getLinuxServerGroup().getLinuxGroup().getPackage(), 1);
}
}
// HttpdJBossSites
for(com.aoindustries.aoserv.client.web.jboss.Site hjs : connector.getWeb_jboss().getSite().getRows()) {
com.aoindustries.aoserv.client.web.tomcat.Site hts=hjs.getHttpdTomcatSite();
Site hs=hts.getHttpdSite();
if(!hs.isDisabled()) {
addCount(javavmsPerPackage, hs.getPackage(), 1);
}
}
// HttpdTomcatStdSites
for(PrivateTomcatSite htss : connector.getWeb_tomcat().getPrivateTomcatSite().getRows()) {
com.aoindustries.aoserv.client.web.tomcat.Site hts=htss.getHttpdTomcatSite();
Site hs=hts.getHttpdSite();
if(!hs.isDisabled()) {
addCount(javavmsPerPackage, hs.getPackage(), 1);
}
}
}
for(Package pack : sourceAccount == null ? connector.getBilling().getPackage().getRows() : sourceAccount.getPackages()) {
Account packAccount = pack.getAccount();
// Only bill when active
boolean active = packAccount.getCanceled() == null;
Account packBillingAccount = packAccount.getBillingAccount();
if(
billingAccount == null
|| billingAccount.equals(packBillingAccount)
) {
// Add the package billing to the top level business account
PackageDefinition packageDefinition=pack.getPackageDefinition();
Money rate = packageDefinition.getMonthlyRate();
// We're now including entries for zero-billed packages, too.
// This will trigger the sending of zero-balance invoices, which will remind people they're getting something for free.
//if(rate.getUnscaledValue() != 0) {
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
pack.getPackageDefinition().getMonthlyRateTransactionType(),
null,
1000,
rate,
administrator,
active
)
);
//}
// TODO: Add aoserv_daemon
// TODO: Add aoserv_master
// TODO: Add bandwidth
// TODO: Add consulting
// TODO: Add disk
// TODO: Add failover
// TODO: Add hardware_*
// Add the httpd_servers
{
PackageDefinitionLimit limit=packageDefinition.getLimit(httpdResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
List hss=pack.getHttpdServers();
if(!hss.isEmpty()) {
if(limit==null) throw new SQLException("HttpdServers exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(hss.size()>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional HttpdServers exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional HttpdServers exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional HTTP Servers ("+limit.getSoftLimit()+" included with package, have "+hss.size()+")",
(hss.size()-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
// Add the ip addresses
{
PackageDefinitionLimit limit=packageDefinition.getLimit(ipResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
List ips=pack.getIPAddresses();
if(!ips.isEmpty()) {
if(limit==null) throw new SQLException("IPAddresses exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(ips.size()>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional IPAddresses exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional IPAddresses exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional IP Addresses ("+limit.getSoftLimit()+" included with package, have "+ips.size()+")",
(ips.size()-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
// Add javavm
{
PackageDefinitionLimit limit=packageDefinition.getLimit(javavmResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
Integer I=javavmsPerPackage.get(pack);
if(I!=null) {
int javavmCount=I;
if(javavmCount>0) {
if(limit==null) throw new SQLException("Java virtual machines exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(javavmCount>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional Java virtual machines exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional Java virtual machines exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional Java Virtual Machines ("+limit.getSoftLimit()+" included with package, have "+javavmCount+")",
(javavmCount-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
}
// Add the mysql_replications
{
PackageDefinitionLimit limit=packageDefinition.getLimit(mysqlReplicationResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
List fmrs = pack.getFailoverMySQLReplications();
if(!fmrs.isEmpty()) {
if(limit==null) throw new SQLException("FailoverMySQLReplications exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(fmrs.size()>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional FailoverMySQLReplications exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional FailoverMySQLReplications exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional MySQL Replications ("+limit.getSoftLimit()+" included with package, have "+fmrs.size()+")",
(fmrs.size()-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
// Add Email accounts
{
PackageDefinitionLimit limit=packageDefinition.getLimit(emailResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
Integer I=emailsPerPackage.get(pack);
if(I!=null) {
int emailCount=I;
if(emailCount>0) {
if(limit==null) throw new SQLException("Email inboxes exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(emailCount>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional Email inboxes exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional Email inboxes exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional Email Inboxes ("+limit.getSoftLimit()+" included with package, have "+emailCount+")",
(emailCount-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
}
// TODO: Add rack
// Add sites
{
PackageDefinitionLimit limit=packageDefinition.getLimit(siteResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
List hss=pack.getHttpdSites();
if(!hss.isEmpty()) {
if(limit==null) throw new SQLException("HttpdSites exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(hss.size()>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional HttpdSites exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional HttpdSites exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional Web Sites ("+limit.getSoftLimit()+" included with package, have "+hss.size()+")",
(hss.size()-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
// TODO: Add sysadmin
// Add user accounts
{
PackageDefinitionLimit limit=packageDefinition.getLimit(userResource);
if(limit==null || limit.getSoftLimit()!=PackageDefinitionLimit.UNLIMITED) {
Integer I=usersPerPackage.get(pack);
if(I!=null) {
int userCount=I;
if(userCount>0) {
if(limit==null) throw new SQLException("Shell accounts exist, but no limit defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
if(userCount>limit.getSoftLimit()) {
Money addRate = limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional Shell accounts exist, but no additional rate defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional Shell accounts exist, but no additional TransactionType defined for Package="+pack.getPkey()+", PackageDefinition="+packageDefinition.getPkey());
charges.add(
new MonthlyCharge(
this,
packBillingAccount,
pack,
addType,
"Additional Shell Accounts ("+limit.getSoftLimit()+" included with package, have "+userCount+")",
(userCount-limit.getSoftLimit())*1000,
addRate,
administrator,
active
)
);
}
}
}
}
}
}
}
// Sort values
sortIfNeeded(charges);
// return
return charges;
}
/**
* Gets the list of all monthly_charges in the database. In addition
* to the monthly charges in the database, the package charges, additional email users,
* additional ip addresses, and additional shell users are added to the billing.
*
* @return the MonthlyCharge objects.
*/
public List getMonthlyCharges(Administrator administrator, Account sourceAccount, Account billingAccount) throws IOException, SQLException {
return Collections.unmodifiableList(getModifiableMonthlyCharges(administrator, sourceAccount, billingAccount));
}
public List getMonthlyCharges(Account sourceAccount, Account billingAccount) throws SQLException, IOException {
return getMonthlyCharges(connector.getCurrentAdministrator(), sourceAccount, billingAccount);
}
@Override
public List getRows() throws SQLException, IOException {
return getMonthlyCharges(connector.getCurrentAdministrator(), null, null);
}
@Override
public List getRowsCopy() throws IOException, SQLException {
return getModifiableMonthlyCharges(connector.getCurrentAdministrator(), null, null);
}
@Override
public Table.TableID getTableID() {
return Table.TableID.MONTHLY_CHARGES;
}
@Override
public List getIndexedRows(int col, Object value) {
throw new UnsupportedOperationException("Indexed rows are not supported on MonthlyChargeTable");
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy