function show_transaction($template) { global $db; global $TPL; global $projectID; $current_user =& singleton("current_user"); $transaction = new transaction(); if (isset($projectID) && $projectID) { $query = prepare("SELECT transaction.*\n FROM transaction\n WHERE transaction.projectID = %d\n ORDER BY transactionModifiedTime desc\n ", $projectID); $db->query($query); while ($db->next_record()) { $transaction = new transaction(); $transaction->read_db_record($db); $transaction->set_values("transaction_"); $tf = $transaction->get_foreign_object("tf"); $tf->set_values(); $tf->set_values("tf_"); $TPL["transaction_username"] = $db->f("username"); $TPL["transaction_amount"] = page::money($TPL["transaction_currenyTypeID"], $TPL["transaction_amount"], "%s%mo"); $TPL["transaction_type_link"] = $transaction->get_transaction_type_link() or $TPL["transaction_link"] = $transaction->get_value("transactionType"); include_template($template); } } }
$tf->set_id($tfID); $tf->select(); $options[$tfID] = $tf->get_value("tfName"); $TPL[$warningKey] = sprintf($warningValue, $tf->get_value("tfName")); } return $options; } $db = new db_alloc(); $transaction = new transaction(); $transaction->read_globals(); $transactionID = $_POST["transactionID"] or $transactionID = $_GET["transactionID"]; if ($transactionID && !$_GET["new"]) { $transaction->set_id($transactionID); $transaction->select(); } $invoice_item = $transaction->get_foreign_object("invoiceItem"); $invoice_item->set_values(); $invoice = $invoice_item->get_foreign_object("invoice"); if (!$invoice->get_id()) { $invoice = $transaction->get_foreign_object("invoice"); } $invoice->set_values(); if ($invoice->get_id()) { $TPL["invoice_link"] = "<a href=\"" . $TPL["url_alloc_invoice"] . "invoiceID=" . $invoice->get_id() . "\">#" . $invoice->get_value("invoiceNum"); $TPL["invoice_link"] .= " " . $invoice->get_value("invoiceDateFrom") . " to " . $invoice->get_value("invoiceDateTo") . "</a>"; } $expenseForm = $transaction->get_foreign_object("expenseForm"); if ($expenseForm->get_id()) { $TPL["expenseForm_link"] = "<a href=\"" . $TPL["url_alloc_expenseForm"] . "expenseFormID=" . $expenseForm->get_id() . "\">#" . $expenseForm->get_id() . "</a>"; } $timeSheet = $transaction->get_foreign_object("timeSheet");