function show_transaction_list($template) { global $TPL; global $tflist; global $transactionGroupID; $q = prepare("SELECT *, amount * pow(10,-currencyType.numberToBasic) as amount\n FROM transaction\n LEFT JOIN currencyType on transaction.currencyTypeID = currencyType.currencyTypeID\n WHERE transactionGroupID = %d\n ORDER BY transactionID\n ", $transactionGroupID); $db = new db_alloc(); $db->query($q); while ($row = $db->row()) { $transaction = new transaction(); $transaction->read_array($row); $transaction->set_values(); $tflist = add_inactive_tf($transaction->get_value("tfID"), $tflist); $tflist = add_inactive_tf($transaction->get_value("fromTfID"), $tflist); $TPL["display"] = ""; $TPL["tfList_dropdown"] = page::select_options($tflist, $transaction->get_value("tfID"), 500); $TPL["fromTfList_dropdown"] = page::select_options($tflist, $transaction->get_value("fromTfID"), 500); $TPL["transactionType_dropdown"] = page::select_options(transaction::get_transactionTypes(), $transaction->get_value("transactionType")); $TPL["status_dropdown"] = page::select_options(transaction::get_transactionStatii(), $transaction->get_value("status")); $TPL["link"] = $transaction->get_link("transactionID"); include_template($template); } }