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