Skip to content
Acorn 3
Project Updates
Discussion
Acorn 3
Users
Stores
Products
Customers
Transactions
Reporting
Settings
Dashboard
Data Import/ Migration
More
Transactions

icon picker
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 (
CtrlP
) instead.