/** * 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) { } }
/** * Delete ProductDBO * * @param ProductDBO &$dbo ProductDBO to be deleted * @return boolean True on success */ function delete_ProductDBO(&$dbo) { $DB = DBConnection::getDBConnection(); try { load_array_ProductPurchaseDBO("productid=" . $dbo->getID()); // Can not delete product if any purchases exist throw new DBException("[PURCHASES_EXIST]"); } catch (DBNoRowsFoundException $e) { } // Build SQL $sql = $DB->build_delete_sql("product", "id = " . intval($dbo->getID())); // Run query if (!mysql_query($sql, $DB->handle())) { throw new DBException(mysql_error($DB->handle())); } }
/** * Get Product Purchases for this Account * * return array Array of ProductPurchaseDBO's for this account */ function getProducts() { try { return load_array_ProductPurchaseDBO("accountid=" . intval($this->getID())); } catch (DBNoRowsFoundException $e) { return array(); } }