/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build the table
foreach ($this->prices as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "type" => $dbo->getType(), "termlength" => $dbo->getTermLength(), "price" => $dbo->getPrice(), "taxable" => $dbo->getTaxable());
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
global $conf;
parent::init($params);
// Build the table
$registry = ModuleRegistry::getModuleRegistry();
foreach ($registry->getAllModules() as $modulename => $module) {
// Put the row into the table
$this->data[] = array("name" => $modulename, "configpage" => $module->getConfigPage(), "type" => $module->getType(), "description" => $module->getDescription());
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
if (!isset($this->order) || null == ($domains = $this->existingDomainsFlag ? $this->order->getExistingDomains() : $this->order->getDomainItems())) {
// Nothing to do
return;
}
// Build the table
foreach ($domains as $dbo) {
// Put the row into the table
$this->data[] = array("orderitemid" => $dbo->getOrderItemID(), "domainname" => $dbo->getFullDomainName());
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
if (!isset($this->order)) {
// Nothing to do
return;
}
// Build the table
foreach ($this->order->getItems() as $dbo) {
// Put the row into the table
$this->data[] = array("orderitemid" => $dbo->getOrderItemID(), "description" => $dbo->getDescription(), "term" => $dbo->getTerm(), "setupfee" => $dbo->getOnetimePrice(), "price" => $dbo->getRecurringPrice());
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Load the Server Table
try {
// Build the table
$servers = load_array_ServerDBO($where);
foreach ($servers as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "hostname" => $dbo->getHostName(), "location" => $dbo->getLocation());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Load the Log Table
try {
// Build the table
$logs = load_array_LogDBO($where);
foreach ($logs as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "type" => $dbo->getType(), "text" => $dbo->getText(), "username" => $dbo->getUsername(), "ip" => $dbo->getRemoteIPString(), "date" => $dbo->getDate());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Load the User Table
try {
// Build the table
$users = load_array_UserDBO($where);
foreach ($users as $dbo) {
// Put the row into the table
$this->data[] = array("username" => $dbo->getUsername(), "type" => $dbo->getType(), "contactname" => $dbo->getContactName(), "email" => $dbo->getEmail());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Load the TaxRule Table
try {
// Build the table
$taxRules = load_array_TaxRuleDBO($where);
foreach ($taxRules as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "country" => $dbo->getCountry(), "allstates" => $dbo->getAllStates(), "state" => $dbo->getState(), "description" => $dbo->getDescription(), "rate" => $dbo->getRate());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an order filter
$where = isset($this->statusFilter) ? sprintf("status='%s'", $this->statusFilter) : null;
// Load the Order Table
try {
// Build the table
$orders = load_array_OrderDBO($where);
foreach ($orders as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "datecreated" => $dbo->getDateCreated(), "datecompleted" => $dbo->getDateCompleted(), "datefulfilled" => $dbo->getDateFulfilled(), "remoteip" => $dbo->getRemoteIP(), "remoteipstring" => $dbo->getRemoteIPString(), "businessname" => $dbo->getBusinessName(), "contactname" => $dbo->getContactName(), "contactemail" => $dbo->getContactEmail(), "status" => $dbo->getStatus(), "accountid" => $dbo->getAccountID(), "accounttype" => $dbo->getAccountType(), "accountname" => $dbo->getAccountName(), "total" => $dbo->getTotal());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an InvoiceItem filter
$where = isset($this->invoiceID) ? sprintf("invoiceid='%d'", $this->invoiceID) : null;
// Load the InvoiceItem Table
try {
// Build the table
$items = load_array_InvoiceItemDBO($where);
foreach ($items as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "text" => $dbo->getText(), "unitamount" => $dbo->getUnitAmount(), "quantity" => $dbo->getQuantity(), "amount" => $dbo->getAmount());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an DomainPurchase filter
$where = isset($this->accountID) ? sprintf("accountid='%d'", $this->accountID) : null;
// Load the DomainPurchase Table
try {
$purchases = load_array_DomainServicePurchaseDBO($where);
// Build the table
foreach ($purchases as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "fulldomainname" => $dbo->getFullDomainName(), "term" => $dbo->getTerm(), "date" => $dbo->getDate(), "expiredate" => $dbo->getExpireDate(), "nextbillingdate" => $dbo->getNextBillingDate());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build a where clause
$where = isset($this->serverID) ? sprintf("serverid='%d'", $this->serverID) : null;
// Load the IP Address pool
try {
// Build the table
$IPAddresses = load_array_IPAddressDBO($where);
foreach ($IPAddresses as $dbo) {
// Put the row into the table
$this->data[] = array("ipaddress" => $dbo->getIP(), "ipaddressstring" => $dbo->getIPString(), "server" => $dbo->getServerID(), "hostname" => $dbo->getHostName(), "isAvailable" => $dbo->isAvailable(), "accountname" => $dbo->getAccountName(), "service" => $dbo->getServiceTitle());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an note filter
$where = isset($this->accountID) ? sprintf("accountid='%d'", $this->accountID) : null;
// Load the Note Table
try {
// Build the table
$notes = load_array_NoteDBO($where);
foreach ($notes as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "username" => $dbo->getUsername(), "updated" => $dbo->getUpdated(), "text" => $dbo->getText());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an account filter
$where = isset($this->statusFilter) ? sprintf("status='%s'", $this->statusFilter) : null;
// Load the Account Table
try {
$accounts = load_array_AccountDBO($where);
// Build the table
foreach ($accounts as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "accountname" => $dbo->getAccountName(), "type" => $dbo->getType(), "status" => $dbo->getStatus(), "balance" => $dbo->getBalance(), "billingstatus" => $dbo->getBillingStatus(), "billingday" => $dbo->getBillingDay(), "businessname" => $dbo->getBusinessName(), "contactname" => $dbo->getContactName(), "contactemail" => $dbo->getContactEmail());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an ProductPurchase filter
$where = isset($this->accountID) ? sprintf("accountid='%d'", $this->accountID) : null;
// Load the ProductPurchase Table
try {
// Build the table
$purchases = load_array_ProductPurchaseDBO($where);
foreach ($purchases as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "productname" => $dbo->getProductName(), "note" => $dbo->getNote(), "date" => $dbo->getDate(), "term" => $dbo->getTerm(), "nextbillingdate" => $dbo->getNextBillingDate());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
if (!isset($this->order) || null == ($domains = $this->order->getDomainItems())) {
// Nothing to do
return;
}
// Build the table
foreach ($domains as $dbo) {
if ($dbo->hasContactInformation()) {
// Skip this domain
continue;
}
// Put the row into the table
$this->data[] = array("orderitemid" => $dbo->getOrderItemID(), "domainname" => $dbo->getFullDomainName());
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an HostingPurchase filter
$where = isset($this->accountID) ? sprintf("accountid='%d'", $this->accountID) : null;
$where = isset($this->serverID) ? sprintf("serverid='%d'", $this->serverID) : $where;
// Load the HostingPurchase Table
try {
// Build the table
$purchases = load_array_HostingServicePurchaseDBO($where);
foreach ($purchases as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "title" => $dbo->getTitle(), "term" => $dbo->getTerm(), "serverid" => $dbo->getServerID(), "hostname" => $dbo->getHostName(), "recurringprice" => $dbo->getRecurringPrice(), "onetimeprice" => $dbo->getOnetimePrice(), "date" => $dbo->getDate(), "accountname" => $dbo->getAccountName(), "nextbillingdate" => $dbo->getNextBillingDate(), "domainname" => $dbo->getDomainName());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Load the Domain Table
try {
$domains = load_array_DomainServicePurchaseDBO($where);
// Build the table
foreach ($domains as $dbo) {
if ($this->statusFlag == "active" && !$dbo->isExpired() || $this->statusFlag == "expired" && $dbo->isExpired()) {
// Skip
continue;
}
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "tld" => $dbo->getTLD(), "accountid" => $dbo->getAccountID(), "domainname" => $dbo->getDomainName(), "fulldomainname" => $dbo->getFullDomainName(), "accountname" => $dbo->getAccountName(), "date" => $dbo->getDate(), "term" => $dbo->getTerm(), "expiredate" => $dbo->getExpireDate());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an invoice filter
$where = isset($this->outstandingFilter) ? sprintf("outstanding='%s' ", $this->outstandingFilter) : null;
$where .= isset($this->accountID) ? sprintf("accountid='%d' ", $this->accountID) : null;
// If a prior-to invoice is given, just go with this clause:
$where = isset($this->priorToInvoice) ? sprintf("id <> %d AND accountid=%d AND outstanding='%s' AND `date` < '%s'", $this->priorToInvoice->getID(), $this->priorToInvoice->getAccountID(), "yes", $this->priorToInvoice->getPeriodBegin()) : $where;
// Load the Invoice Table
try {
// Build the table
$invoices = load_array_InvoiceDBO($where);
foreach ($invoices as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "accountid" => $dbo->getAccountID(), "accountname" => $dbo->getAccountName(), "date" => $dbo->getDate(), "periodbegin" => $dbo->getPeriodBegin(), "periodend" => $dbo->getPeriodEnd(), "note" => $dbo->getNote(), "terms" => $dbo->getTerms(), "outstanding" => $dbo->getOutstanding(), "total" => $dbo->getTotal(), "totalpayments", $dbo->getTotalPayments(), "balance" => $dbo->getBalance());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Load the DomainService Table
try {
$services = load_array_DomainServiceDBO();
// Build the table
foreach ($services as $dbo) {
// Format the pricing for this hosting service
$priceString = "";
$prices = array_merge($dbo->getPricing("Onetime"), $dbo->getPricing("Recurring"));
foreach ($prices as $priceDBO) {
$price = sprintf("%s%01.2f", $conf['locale']['currency_symbol'], $priceDBO->getPrice());
$priceString .= $priceDBO->getType() == "Onetime" ? sprintf("[ONETIME]: %s<br/>", $price) : sprintf("%d [MONTHS]: %s<br/>", $priceDBO->getTermLength(), $price);
}
// Put the row into the table
$this->data[] = array("tld" => $dbo->getTLD(), "description" => $dbo->getDescription(), "pricing" => $priceString, "module" => $dbo->getModuleName(), "public" => $dbo->getPublic());
}
} catch (DBNoRowsFoundException $e) {
}
}
/**
* Initialize the Table
*
* @param array $params Parameters from the {form_table} tag
*/
public function init($params)
{
parent::init($params);
// Build an Payment filter
$where = "";
if (isset($this->invoiceID)) {
$where = sprintf("invoiceid='%d'", $this->invoiceID);
}
if (isset($this->orderID)) {
$where = sprintf("orderid='%d'", $this->orderID);
}
// Load the Payment Table
try {
// Build the table
$items = load_array_PaymentDBO($where);
foreach ($items as $dbo) {
// Put the row into the table
$this->data[] = array("id" => $dbo->getID(), "date" => $dbo->getDate(), "amount" => $dbo->getAmount(), "type" => $dbo->getType(), "module" => $dbo->getModule(), "status" => $dbo->getStatus());
}
} catch (DBNoRowsFoundException $e) {
}
}
