/** * Add Price */ protected function addPrice() { if ($this->post['type'] == "Onetime" && $this->post['termlength'] != 0) { throw new SWUserException("[TERMLENGTH_FOR_ONETIME_MUST_BE_ZERO]"); } if ($this->post['type'] == "Recurring" && $this->post['termlength'] == 0) { throw new SWUserException("[TERMLENGTH_FOR_RECURRING_MUST_NOT_BE_ZERO]"); } $priceDBO = new DomainServicePriceDBO(); $priceDBO->setTLD($this->get['dservice']->getTLD()); $priceDBO->setType($this->post['type']); $priceDBO->setTermLength($this->post['termlength']); $priceDBO->setPrice($this->post['price']); $priceDBO->setTaxable($this->post['taxable']); try { $this->get['dservice']->addPrice($priceDBO); add_DomainServicePriceDBO($priceDBO); $this->setMessage(array("type" => "[PRICE_ADDED]")); } catch (DuplicatePriceException $e) { update_DomainServicePriceDBO($priceDBO); $this->setMessage(array("type" => "[PRICE_UPDATED]")); } $this->reload("&sstab=pricing"); }
/** * Load multiple DomainServicePriceDBO's from database * * @param string $filter A WHERE clause * @param string $sortby Field name to sort results by * @param string $sortdir Direction to sort in (ASEC or DESC) * @param int $limit Limit the number of results * @param int $start Record number to start the results at * @return array Array of DomainServiceDBO's */ function load_array_DomainServicePriceDBO($filter = null, $sortby = null, $sortdir = null, $limit = null, $start = null) { $DB = DBConnection::getDBConnection(); // Build query $sql = $DB->build_select_sql("domainserviceprice", "*", $filter, $sortby, $sortdir, $limit, $start); // Run query if (!($result = @mysql_query($sql, $DB->handle()))) { // Query error throw new DBException(mysql_error($DB->handle())); } if (mysql_num_rows($result) == 0) { // No services found throw new DBNoRowsFoundException(); } // Build an array of DomainServicePriceDBOs from the result set $price_dbo_array = array(); while ($data = mysql_fetch_array($result)) { // Create and initialize a new DomainServiceDBO with the data from the DB $dbo = new DomainServicePriceDBO(); $dbo->load($data); // Add DomainServiceDBO to array $price_dbo_array[] = $dbo; } return $price_dbo_array; }
/** * Delete DomainServiceDBO from database * * @param DomainServiceDBO &$dbo DomainServiceDBO to delete * @return boolean True on success */ function delete_DomainServiceDBO(&$dbo) { $DB = DBConnection::getDBConnection(); // Verify that no purchases exist try { $tld = $dbo->getTLD(); load_array_DomainServicePurchaseDBO("tld = '" . $dbo->getTLD() . "'"); // Can not delete domain service if any purchases exist throw new DBException("[PURCHASES_EXIST]"); } catch (DBNoRowsFoundException $e) { } // Build SQL $sql = $DB->build_delete_sql("domainservice", "tld = " . $DB->quote_smart($dbo->getTLD())); // Run query if (!mysql_query($sql, $DB->handle())) { throw new DBException(mysql_error($DB->handle())); } // Delete all prices belonging to the deleted domain service. $domainPrices = new DomainServicePriceDBO(); $domainPrices->setTLD($tld); deleteAll_DomainServicePriceDBO($domainPrices); }