JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Acorn 3
Project Updates / Testing
Discussion
Acorn 3
Users
Stores
Products
Customers
Transactions
Reporting
Settings
Acorn 3
Data Import/ Migration
More
Transactions
Gold Purchase
public function getInterestRate($loan, $store_id) {
$sql = "SELECT interest_rate
FROM gold_interest_bands
WHERE value_from <= ?
AND value_to >= ?
AND store_id = ?";
$params = array("ddi",$loan,$loan,$store_id);
$res = $this->db->cleanQueryArr($sql,$params);
if($this->db->getLastnumrows() > 0) {
return $res[0]['interest_rate'];
} else {
return false;
}
}
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.