/** * 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) { } }