com.aoindustries.aoserv.client.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 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
OrderBy[] getDefaultOrderBy() {
return defaultOrderBy;
}
@Override
public MonthlyCharge get(int pkey) throws SQLException, IOException {
return getUniqueRow(MonthlyCharge.COLUMN_PKEY, pkey);
}
/**
* 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.
*/
List getMonthlyCharges(BusinessAdministrator business_administrator, Business bu) 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(LinuxServerAccount lsa : connector.getLinuxServerAccounts().getRows()) {
String username=lsa.username;
if(!username.equals(LinuxAccount.MAIL)) {
Map map;
LinuxAccount la=lsa.getLinuxAccount();
if(la.getType().getName().equals(LinuxAccountType.EMAIL)) map=emailsPerPackage;
else map=usersPerPackage;
Package pack=la.getUsername().getPackage();
Integer I=map.get(pack);
if(I==null) map.put(pack, I=1);
else map.put(pack, I=I+1);
}
}
}
Map javavmsPerPackage=new HashMap<>();
{
// HttpdSharedTomcats
for(HttpdSharedTomcat hst : connector.getHttpdSharedTomcats().getRows()) {
LinuxServerGroup lsg=hst.getLinuxServerGroup();
LinuxGroup lg=lsg.getLinuxGroup();
Package pack=lg.getPackage();
Integer I=javavmsPerPackage.get(pack);
if(I==null) javavmsPerPackage.put(pack, I=1);
else javavmsPerPackage.put(pack, I=I+1);
}
// HttpdJBossSites
for(HttpdJBossSite hjs : connector.getHttpdJBossSites().getRows()) {
HttpdTomcatSite hts=hjs.getHttpdTomcatSite();
HttpdSite hs=hts.getHttpdSite();
Package pack=hs.getPackage();
Integer I=javavmsPerPackage.get(pack);
if(I==null) javavmsPerPackage.put(pack, I=1);
else javavmsPerPackage.put(pack, I=I+1);
}
// HttpdTomcatStdSites
for(HttpdTomcatStdSite htss : connector.getHttpdTomcatStdSites().getRows()) {
HttpdTomcatSite hts=htss.getHttpdTomcatSite();
HttpdSite hs=hts.getHttpdSite();
Package pack=hs.getPackage();
Integer I=javavmsPerPackage.get(pack);
if(I==null) javavmsPerPackage.put(pack, I=1);
else javavmsPerPackage.put(pack, I=I+1);
}
}
for(Package pack : connector.getPackages().getRows()) {
Business business=pack.getBusiness();
// Only bill when active
if(business.getCanceled()==null) {
Business acctBusiness=business.getAccountingBusiness();
if(
bu==null
|| bu.equals(acctBusiness)
) {
// Add the package billing to the top level business account
PackageDefinition packageDefinition=pack.getPackageDefinition();
BigDecimal rate = packageDefinition.getMonthlyRate();
if(rate.compareTo(BigDecimal.ZERO)!=0) {
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
pack.getPackageDefinition().getMonthlyRateTransactionType(),
null,
1000,
rate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(hss.size()>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional HttpdServers exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional HttpdServers exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional HTTP Servers ("+limit.getSoftLimit()+" included with package, have "+hss.size()+")",
(hss.size()-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(ips.size()>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional IPAddresses exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional IPAddresses exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional IP Addresses ("+limit.getSoftLimit()+" included with package, have "+ips.size()+")",
(ips.size()-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(javavmCount>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional Java virtual machines exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional Java virtual machines exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional Java Virtual Machines ("+limit.getSoftLimit()+" included with package, have "+javavmCount+")",
(javavmCount-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(fmrs.size()>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional FailoverMySQLReplications exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional FailoverMySQLReplications exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional MySQL Replications ("+limit.getSoftLimit()+" included with package, have "+fmrs.size()+")",
(fmrs.size()-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(emailCount>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional Email inboxes exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional Email inboxes exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional Email Inboxes ("+limit.getSoftLimit()+" included with package, have "+emailCount+")",
(emailCount-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(hss.size()>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional HttpdSites exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional HttpdSites exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional Web Sites ("+limit.getSoftLimit()+" included with package, have "+hss.size()+")",
(hss.size()-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
// 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.pkey+", PackageDefinition="+packageDefinition.pkey);
if(userCount>limit.getSoftLimit()) {
BigDecimal addRate=limit.getAdditionalRate();
if(addRate==null) throw new SQLException("Additional Shell accounts exist, but no additional rate defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
TransactionType addType=limit.getAdditionalTransactionType();
if(addType==null) throw new SQLException("Additional Shell accounts exist, but no additional TransactionType defined for Package="+pack.pkey+", PackageDefinition="+packageDefinition.pkey);
charges.add(
new MonthlyCharge(
this,
acctBusiness,
pack,
addType,
"Additional Shell Accounts ("+limit.getSoftLimit()+" included with package, have "+userCount+")",
(userCount-limit.getSoftLimit())*1000,
addRate.multiply(BigDecimal.valueOf(100)).intValueExact(),
business_administrator
)
);
}
}
}
}
}
}
}
}
// Sort values
sortIfNeeded(charges);
// Convert and return
return Collections.unmodifiableList(charges);
}
List getMonthlyCharges(Business bu) throws SQLException, IOException {
return getMonthlyCharges(connector.getThisBusinessAdministrator(), bu);
}
@Override
public List getRows() throws SQLException, IOException {
return getMonthlyCharges(connector.getThisBusinessAdministrator(), null);
}
@Override
public SchemaTable.TableID getTableID() {
return SchemaTable.TableID.MONTHLY_CHARGES;
}
@Override
final public List getIndexedRows(int col, Object value) {
throw new UnsupportedOperationException("Indexed rows are not supported on MonthlyChargeTable");
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy