function show_all_exp($template) { global $TPL; global $expenseForm; global $db; global $transaction_to_edit; if ($expenseForm->get_id()) { if ($_POST["transactionID"] && ($_POST["edit"] || is_object($transaction_to_edit) && $transaction_to_edit->get_id())) { // if edit is clicked OR if we've rejected changes made to something so are still editing it $query = prepare("SELECT * FROM transaction WHERE expenseFormID=%d AND transactionID<>%d ORDER BY transactionID DESC", $expenseForm->get_id(), $_POST["transactionID"]); } else { $query = prepare("SELECT * FROM transaction WHERE expenseFormID=%d ORDER BY transactionID DESC", $expenseForm->get_id()); } $db->query($query); while ($db->next_record()) { $transaction = new transaction(); $transaction->read_db_record($db); $transaction->set_values(); $transaction->get_value("quantity") and $TPL["amount"] = $transaction->get_value("amount") / $transaction->get_value("quantity"); $TPL["lineTotal"] = $TPL["amount"] * $transaction->get_value("quantity"); $tf = new tf(); $tf->set_id($transaction->get_value("fromTfID")); $tf->select(); $TPL["fromTfIDLink"] = $tf->get_link(); $tf = new tf(); $tf->set_id($transaction->get_value("tfID")); $tf->select(); $TPL["tfIDLink"] = $tf->get_link(); $projectID = $transaction->get_value("projectID"); if ($projectID) { $project = new project(); $project->set_id($transaction->get_value("projectID")); $project->select(); $TPL["projectName"] = $project->get_value("projectName"); } if ($transaction->get_value("fromTfID") == config::get_config_item("expenseFormTfID")) { $TPL['expense_class'] = "loud"; } else { $TPL['expense_class'] = ""; } include_template($template); } } }
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); } } }
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); } }
function show_transaction_listR($template_name) { global $timeSheet; global $TPL; $current_user =& singleton("current_user"); global $percent_array; $db = new db_alloc(); $db->query("SELECT * FROM transaction WHERE timeSheetID = %d", $timeSheet->get_id()); if ($db->next_record() || $timeSheet->get_value("status") == "invoiced" || $timeSheet->get_value("status") == "finished") { $db->query("SELECT * \n FROM tf \n WHERE tfActive = 1\n OR tfID = %d \n OR tfID = %d \n ORDER BY tfName", $db->f("tfID"), $db->f("fromTfID")); while ($db->row()) { $tf_array[$db->f("tfID")] = $db->f("tfName"); } $status_options = array("pending" => "Pending", "approved" => "Approved", "rejected" => "Rejected"); $transactionType_options = transaction::get_transactionTypes(); if ($timeSheet->have_perm(PERM_TIME_INVOICE_TIMESHEETS) && $timeSheet->get_value("status") == "invoiced") { $db->query("SELECT * FROM transaction WHERE timeSheetID = %d ORDER BY transactionID", $timeSheet->get_id()); while ($db->next_record()) { $transaction = new transaction(); $transaction->read_db_record($db); $transaction->set_tpl_values("transaction_"); $TPL["currency"] = page::money($transaction->get_value("currencyTypeID"), '', "%S"); $TPL["currency_code"] = page::money($transaction->get_value("currencyTypeID"), '', "%C"); $TPL["tf_options"] = page::select_options($tf_array, $TPL["transaction_tfID"]); $TPL["from_tf_options"] = page::select_options($tf_array, $TPL["transaction_fromTfID"]); $TPL["status_options"] = page::select_options($status_options, $transaction->get_value("status")); $TPL["transactionType_options"] = page::select_options($transactionType_options, $transaction->get_value("transactionType")); $TPL["percent_dropdown"] = page::select_options($percent_array, $empty); $TPL["transaction_buttons"] = ' <button type="submit" name="transaction_delete" value="1" class="delete_button">Delete<i class="icon-trash"></i></button> <button type="submit" name="transaction_save" value="1" class="save_button">Save<i class="icon-ok-sign"></i></button> '; if ($transaction->get_value("transactionType") == "invoice") { $TPL["transaction_transactionType"] = $transaction->get_transaction_type_link(); $TPL["transaction_fromTfID"] = tf::get_name($transaction->get_value("fromTfID")); $TPL["transaction_tfID"] = tf::get_name($transaction->get_value("tfID")); $TPL["currency_amount"] = page::money($transaction->get_value("currencyTypeID"), $transaction->get_value("amount"), "%S%mo %c"); include_template("templates/timeSheetTransactionListViewR.tpl"); } else { include_template($template_name); } } } else { // If you don't have perm INVOICE TIMESHEETS then only select // transactions which you have permissions to see. $query = prepare("SELECT * \n FROM transaction \n WHERE timeSheetID = %d\n ORDER BY transactionID", $timeSheet->get_id()); $db->query($query); while ($db->next_record()) { $transaction = new transaction(); $transaction->read_db_record($db); $transaction->set_tpl_values("transaction_"); unset($TPL["transaction_amount_pos"]); unset($TPL["transaction_amount_neg"]); $TPL["currency_amount"] = page::money($transaction->get_value("currencyTypeID"), $transaction->get_value("amount"), "%S%mo %c"); $TPL["transaction_fromTfID"] = tf::get_name($transaction->get_value("fromTfID")); $TPL["transaction_tfID"] = tf::get_name($transaction->get_value("tfID")); $TPL["transaction_transactionType"] = $transactionType_options[$transaction->get_value("transactionType")]; include_template("templates/timeSheetTransactionListViewR.tpl"); } } } }
$TPL["expenseForm_link"] = "<a href=\"" . $TPL["url_alloc_expenseForm"] . "expenseFormID=" . $expenseForm->get_id() . "\">#" . $expenseForm->get_id() . "</a>"; } $timeSheet = $transaction->get_foreign_object("timeSheet"); if ($timeSheet->get_id()) { $TPL["timeSheet_link"] = "<a href=\"" . $TPL["url_alloc_timeSheet"] . "timeSheetID=" . $timeSheet->get_id() . "\">#" . $timeSheet->get_id() . "</a>"; } $transaction->set_values(); if ($_POST["save"] || $_POST["saveAndNew"] || $_POST["saveGoTf"]) { /* if ($transaction->get_value("status") != "pending") { alloc_error("This transaction is no longer editable."); } */ $transaction->read_globals(); // Tweaked validation to allow reporting of multiple errors $transaction->get_value("amount") or alloc_error("You must enter a valid amount"); $transaction->get_value("transactionDate") or alloc_error("You must enter a date for the transaction"); $transaction->get_value("product") or alloc_error("You must enter a product"); $transaction->get_value("status") or alloc_error("You must set the status of the transaction"); $transaction->get_value("fromTfID") or alloc_error("You must select a Source Tagged Fund to take this transaction from"); $transaction->get_value("tfID") or alloc_error("You must select a Destination Tagged Fund to add this transaction against"); $transaction->get_value("transactionType") or alloc_error("You must set a transaction type"); $transaction->get_value("currencyTypeID") or alloc_error("You must set a transaction currency"); #$transaction->get_value("projectID") or alloc_error("You must select a project"); #$transaction->get_value("companyDetails") or alloc_error("You must enter the company details"); if (!count($TPL["message"])) { $transaction->set_value("amount", str_replace(array("\$", ","), "", $transaction->get_value("amount"))); if ($transaction->save()) { // need to check this again as transaction->save might have triggered an error $TPL["message_good"][] = "Transaction Saved"; if ($_POST["saveAndNew"]) {
echo "<br>Skipping because tf not active: " . $tf->get_value("tfName"); continue 2; } $tf = new tf(); $tf->set_id($transactionRepeat->get_value("fromTfID")); $tf->select(); if (!$tf->get_value("tfActive")) { echo "<br>Skipping because tf not active: " . $tf->get_value("tfName"); continue 2; } $amount = page::money_out($transactionRepeat->get_value("currencyTypeID"), $transactionRepeat->get_value("amount")); $transaction = new transaction(); $transaction->set_value("fromTfID", $transactionRepeat->get_value("fromTfID")); $transaction->set_value("tfID", $transactionRepeat->get_value("tfID")); $transaction->set_value("companyDetails", $transactionRepeat->get_value("companyDetails")); $transaction->set_value("amount", $amount); $transaction->set_value("currencyTypeID", $transactionRepeat->get_value("currencyTypeID")); $transaction->set_value("product", $transactionRepeat->get_value("product")); $transaction->set_value("transactionType", $transactionRepeat->get_value("transactionType")); $transaction->set_value("status", "pending"); $transaction->set_value("transactionRepeatID", $transactionRepeat->get_id()); $transaction->set_value("transactionDate", date("Y-m-d", $nextScheduled)); $transaction->save(); echo "\n<br>" . $transaction->get_value("transactionDate"); echo " " . $transactionRepeat->get_value("paymentBasis") . " \$" . $transaction->get_value("amount") . " for TF: " . tf::get_name($transaction->get_value("tfID")); echo " (transactionID: " . $transaction->get_id() . " transactionRepeatID:" . $transactionRepeat->get_id() . " name:" . $transactionRepeat->get_value("product") . ")"; $nextScheduled = timeWarp($nextScheduled, $timeBasisString); } } $TPL["main_alloc_title"] = "Execute Repeating Expenses - " . APPLICATION_NAME; include_template("templates/checkRepeatM.tpl");
function show_transaction_list($transactions = array(), $template) { global $TPL; global $tflist; foreach ($transactions as $row) { $transaction = new transaction(); $transaction->read_array($row); $transaction->set_values(); $TPL["display"] = ""; $m = new meta("currencyType"); $currencyOptions = $m->get_assoc_array("currencyTypeID", "currencyTypeID"); $TPL["currencyOptions"] = page::select_options($currencyOptions, $transaction->get_value("currencyTypeID")); $TPL["tfList_dropdown"] = page::select_options($tflist, $transaction->get_value("tfID")); $TPL["fromTfList_dropdown"] = page::select_options($tflist, $transaction->get_value("fromTfID")); $TPL["tfID_label"] = $tflist[$transaction->get_value("tfID")]; $TPL["fromTfID_label"] = $tflist[$transaction->get_value("fromTfID")]; if (CAN_APPROVE_TRANSACTIONS && $TPL["productSale_status"] == "admin") { $TPL["status"] = "<select name='status[]' class='txStatus'>"; $TPL["status"] .= page::select_options(transaction::get_transactionStatii(), $transaction->get_value("status")) . "</select>"; } $TPL["pc_productCostID"] = $row["pc_productCostID"]; $TPL["pc_amount"] = $row["pc_amount"]; $TPL["pc_isPercentage"] = $row["pc_isPercentage"]; $TPL["pc_currency"] = $row["pc_currency"]; $TPL["amountClass"] = $row["saleTransactionType"]; include_template($template); } }
function get_pending_repeat_transaction_list() { global $TPL; $transactionTypes = transaction::get_transactionTypes(); $q = "SELECT * FROM transaction \n LEFT JOIN transactionRepeat on transactionRepeat.transactionRepeatID = transaction.transactionRepeatID \n WHERE transaction.transactionRepeatID IS NOT NULL AND transaction.status = 'pending'"; $db = new db_alloc(); $db->query($q); while ($row = $db->row()) { $transaction = new transaction(); $transaction->read_db_record($db); $transaction->set_values(); $transactionRepeat = new transactionRepeat(); $transactionRepeat->read_db_record($db); $transactionRepeat->set_values(); $row["transactionType"] = $transactionTypes[$transaction->get_value("transactionType")]; $row["formTotal"] = $db->f("amount"); $row["transactionModifiedTime"] = $transaction->get_value("transactionModifiedTime"); $row["transactionCreatedTime"] = $transaction->get_value("transactionCreatedTime"); $row["transactionCreatedUser"] = person::get_fullname($transaction->get_value("transactionCreatedUser")); $rows[] = $row; } return (array) $rows; }
public static function get_list($_FORM) { $current_user =& singleton("current_user"); global $TPL; /* * This is the definitive method of getting a list of transactions that need a sophisticated level of filtering * */ $_FORM["tfIDs"] = transaction::reduce_tfs($_FORM); // Non-admin users must specify a valid TF if (!$current_user->have_role("admin") && !$_FORM["tfIDs"]) { return; } $filter = transaction::get_list_filter($_FORM); $debug = $_FORM["debug"]; $debug and print "\n<pre>_FORM: " . print_r($_FORM, 1) . "</pre>"; $debug and print "\n<pre>filter: " . print_r($filter, 1) . "</pre>"; $_FORM["return"] or $_FORM["return"] = "html"; $filter["prevBalance"] and $filter2[] = $filter["prevBalance"]; $filter["tfIDs"] and $filter2[] = $filter["tfIDs"]; $filter2 and $filter2[] = " (status = 'approved') "; unset($filter["prevBalance"]); if (is_array($filter2) && count($filter2)) { $filter2 = " WHERE " . implode(" AND ", $filter2); } if (is_array($filter) && count($filter)) { $filter = " WHERE " . implode(" AND ", $filter); } $_FORM["sortTransactions"] or $_FORM["sortTransactions"] = "transactionDate"; $order_by = "ORDER BY " . $_FORM["sortTransactions"]; // Determine opening balance if (is_array($_FORM['tfIDs']) && count($_FORM['tfIDs'])) { $q = prepare("SELECT SUM( IF(fromTfID IN (%s),-amount,amount) * pow(10,-currencyType.numberToBasic) * exchangeRate) AS balance\n FROM transaction \n LEFT JOIN currencyType ON currencyType.currencyTypeID = transaction.currencyTypeID\n " . $filter2, $_FORM['tfIDs']); $debug and print "\n<br>QUERY: " . $q; $db = new db_alloc(); $db->query($q); $db->row(); $_FORM["opening_balance"] = $db->f("balance"); $running_balance = $db->f("balance"); } $q = "SELECT *, \n (amount * pow(10,-currencyType.numberToBasic)) as amount1,\n (amount * pow(10,-currencyType.numberToBasic) * exchangeRate) as amount2,\n if(transactionModifiedTime,transactionModifiedTime,transactionCreatedTime) AS transactionSortDate,\n tf1.tfName as fromTfName,\n tf2.tfName as tfName\n FROM transaction \n LEFT JOIN currencyType ON currencyType.currencyTypeID = transaction.currencyTypeID\n LEFT JOIN tf tf1 ON transaction.fromTfID = tf1.tfID\n LEFT JOIN tf tf2 ON transaction.tfID = tf2.tfID\n " . $filter . " \n " . $order_by; $debug and print "\n<br>QUERY2: " . $q; $db = new db_alloc(); $db->query($q); $for_cyber = config::for_cyber(); while ($row = $db->next_record()) { #echo "<pre>".print_r($row,1)."</pre>"; $i++; $t = new transaction(); if (!$t->read_db_record($db)) { continue; } $print = true; // If the destination of this TF is not the current TfID, then invert the $amount $amount = $row["amount2"]; if (!in_array($row["tfID"], (array) $_FORM["tfIDs"])) { $amount = -$amount; $row["amount1"] = -$row["amount1"]; } $row["amount"] = $amount; $row["transactionURL"] = $t->get_url(); $row["transactionName"] = $t->get_name($_FORM); $row["transactionLink"] = $t->get_transaction_link($_FORM); $row["transactionTypeLink"] = $t->get_transaction_type_link() or $row["transactionTypeLink"] = $row["transactionType"]; $row["transactionSortDate"] = format_date("Y-m-d", $row["transactionSortDate"]); $row["fromTfIDLink"] = "<a href=\"" . $TPL["url_alloc_transactionList"] . "tfID=" . $row["fromTfID"] . "\">" . page::htmlentities($row["fromTfName"]) . "</a>"; $row["tfIDLink"] = "<a href=\"" . $TPL["url_alloc_transactionList"] . "tfID=" . $row["tfID"] . "\">" . page::htmlentities($row["tfName"]) . "</a>"; if ($t->get_value("status") == "approved") { $running_balance += $amount; $row["running_balance"] = page::money(config::get_config_item("currency"), $running_balance, "%m %c"); } if ($amount > 0) { $row["amount_positive"] = page::money($row["currencyTypeID"], $row["amount1"], "%m %c"); $total_amount_positive += $amount; } else { $row["amount_negative"] = page::money($row["currencyTypeID"], $row["amount1"], "%m %c"); $total_amount_negative += $amount; } // Cyber only hackery for ext ref field on product sales if ($for_cyber && $row["productSaleID"]) { $ps = new productSale(); $ps->set_id($row["productSaleID"]); if ($ps->select()) { $ps->get_value("extRef") and $row["product"] .= " (Ext ref: " . $ps->get_value("extRef") . ")"; } } $transactions[$row["transactionID"]] = $row; } $_FORM["total_amount_positive"] = page::money(config::get_config_item("currency"), $total_amount_positive, "%s%m %c"); $_FORM["total_amount_negative"] = page::money(config::get_config_item("currency"), $total_amount_negative, "%s%m %c"); $_FORM["running_balance"] = page::money(config::get_config_item("currency"), $running_balance, "%s%m %c"); return array("totals" => $_FORM, "rows" => (array) $transactions); }