Integrating donations_thermometer and uc_lto

Hi Matt,

I've been trying to integrate the donations_thermometer block ( http://drupal.org/project/donations_thermometer ) and uc_lto but I cant figure out how to assign one thermometer block to one LTO product as currently the thermometer block shows in the entire website. I inserted some code from the donations module and donations thermometer block into uc_order and managed to pass all the variables. However, I am finding difficult to put the right code to allocate one thermometer block to one LTO product.

I've done the following:

1.From donations module I took:

define ('DONATION_UPDATE_DONATIONS_THERMOMETER', 'donation_update_donations_thermometer');

And inserted it into uc_order module at the top.

2.Then I took:

donation_update_donation_thermometer_amount();

And inserted it into uc_order module at the end of function uc_order_log_changes:

function uc_order_log_changes($order_id, $changes) {
global $user;

if (count($changes) == 0) {
return FALSE;
}

foreach ($changes as $key => $value) {
if (is_array($value)) {
$items[] = t('@key changed from %old to %new.', array('@key' => $key, '%old' => $value['old'], '%new' => $value['new']));
}
elseif (is_string($value)) {
$items[] = $value;
}
}

db_query("INSERT INTO {uc_order_log} (order_id, uid, changes, created) VALUES (%d, %d, '%s', %d)",
$order_id, $user->uid, theme('item_list', $items), time());

donation_update_donation_thermometer_amount();

return TRUE;
}

3.Also I added at the end of uc_order module the following functions from donations module:

/**
* Return the total amount of the donations
*/

function donation_total() {
$sql = 'SELECT SUM(d.Amount) FROM {donations} d WHERE d.status=1';
$result = db_result(db_query($sql));
$result = check_plain(sprintf('%.2f',$result));
return $result;
}

/**
* If enabled update the donations_thermometer_amount
*/

function donation_update_donation_thermometer_amount() {
if (variable_get(DONATION_UPDATE_DONATIONS_THERMOMETER, 0) == 1) {
variable_set('donations_thermometer_amount', donation_total());
}
}

4. Then I changed database query:

function donation_total() {
$sql = 'SELECT SUM(d.Amount) FROM {donations} d WHERE d.status=1';
$result = db_result(db_query($sql));
$result = check_plain(sprintf('%.2f',$result));
return $result;
}

Into :

function donation_total() {
$sql = 'SELECT SUM(qty) FROM {uc_order_products} WHERE nid=%d';
$result = db_result(db_query($sql));
$result = check_plain(sprintf('%.2f',$result));
return $result;
}

I activated donations_thermometer and added a LTO to one product and after the checkout the thermometer shows the amount. However, the thermometer appears in all nodes and pages.

Any suggestions on how to allocate this donations_thermometer block to one LTO product, please? Or is there any other solution? Maybe working on the theme template? However, a block to publish the amount of products ordered during the offer time either as a thermometer, as text or other graphical format would be nicer.

Many thanks,

Andrew