function get_amount_other()
{
$db = new db_alloc();
// Don't need to do numberToBasic conversion here
$q = prepare("SELECT fromTfID, tfID,\n (amount * exchangeRate) as amount\n FROM transaction \n LEFT JOIN currencyType ON currencyType.currencyTypeID = transaction.currencyTypeID\n WHERE fromTfID != %d\n AND tfID != %d\n AND tfID != %d\n AND productSaleID = %d\n AND productSaleItemID = %d\n AND status != 'rejected'\n AND productCostID IS NULL\n ", config::get_config_item("inTfID"), config::get_config_item("outTfID"), config::get_config_item("taxTfID"), $this->get_value("productSaleID"), $this->get_id());
$db->query($q);
$rows = array();
while ($row = $db->row()) {
$rows[] = $row;
}
return transaction::get_actual_amount_used($rows);
}
function show_transaction_list($template_name)
{
global $timeSheet;
global $TPL;
$db = new db_alloc();
$amount_so_far = $timeSheet->get_amount_so_far(true);
$total_incoming = $timeSheet->pay_info["total_customerBilledDollars"];
$db->query("SELECT * FROM transaction WHERE timeSheetID = %d AND fromTfID != %d\n ", $timeSheet->get_id(), config::get_config_item("inTfID"));
while ($row = $db->row()) {
$has_transactions = true;
$rows[] = $row;
}
$total_allocated = transaction::get_actual_amount_used($rows);
$TPL["total_allocated"] = page::money($timeSheet->get_value("currencyTypeID"), $total_allocated, "%s%mo %c");
$TPL["total_dollars"] = page::money($timeSheet->get_value("currencyTypeID"), $timeSheet->pay_info["total_dollars_not_null"], "%s%m %c");
// used in js preload_field()
$TPL["total_remaining"] = page::money($timeSheet->get_value("currencyTypeID"), $total_incoming - $amount_so_far, "%m");
if ($has_transactions || $timeSheet->get_value("status") == "invoiced" || $timeSheet->get_value("status") == "finished") {
if ($timeSheet->have_perm(PERM_TIME_INVOICE_TIMESHEETS) && $timeSheet->get_value("status") == "invoiced") {
$p_button = "<input style=\"padding:1px 4px\" type=\"submit\" name=\"p_button\" value=\"P\" title=\"Mark transactions pending\"> ";
$a_button = "<input style=\"padding:1px 4px\" type=\"submit\" name=\"a_button\" value=\"A\" title=\"Mark transactions approved\"> ";
$r_button = "<input style=\"padding:1px 4px\" type=\"submit\" name=\"r_button\" value=\"R\" title=\"Mark transactions rejected\"> ";
$session = "<input type=\"hidden\" name=\"sessID\" value=\"" . $TPL["sessID"] . "\">";
$TPL["p_a_r_buttons"] = "<form action=\"" . $TPL["url_alloc_timeSheet"] . "timeSheetID=" . $timeSheet->get_id() . "\" method=\"post\">" . $p_button . $a_button . $r_button . $session . "</form>";
$TPL["create_transaction_buttons"] = "<tr><td colspan=\"8\" align=\"center\" style=\"padding:10px;\">";
$TPL["create_transaction_buttons"] .= "<form action=\"" . $TPL["url_alloc_timeSheet"] . "timeSheetID=" . $timeSheet->get_id() . "\" method=\"post\">";
$TPL["create_transaction_buttons"] .= '
<button type="submit" name="create_transactions_default" value="1" class="save_button">Create Default Transactions<i class="icon-cogs"></i></button>
';
$TPL["create_transaction_buttons"] .= '
<button type="submit" name="delete_all_transactions" value="1" class="delete_button">Delete Transactions<i class="icon-trash"></i></button>
';
$TPL["create_transaction_buttons"] .= "<input type=\"hidden\" name=\"sessID\" value=\"" . $TPL["sessID"] . "\"></form></tr></tr>";
}
include_template($template_name);
}
}
