function show_productCost_new($template, $percent = false)
{
global $TPL;
$t = new meta("currencyType");
$currency_array = $t->get_assoc_array("currencyTypeID", "currencyTypeID");
$productCost = new productCost();
$productCost->set_values();
// wipe clean
$TPL["currencyOptions"] = page::select_options($currency_array, $productCost->get_value("currencyTypeID"));
$TPL["taxOptions"] = page::select_options(array("" => "Exempt", 1 => "Included", 0 => "Excluded"), "1");
$TPL["display"] = "display:none";
include_template($template);
}
get_cached_table("config", true);
// flush cache
if (has("finance")) {
$tf = new tf();
$options = $tf->get_assoc_array("tfID", "tfName");
}
$TPL["mainTfOptions"] = page::select_options($options, config::get_config_item("mainTfID"));
$TPL["outTfOptions"] = page::select_options($options, config::get_config_item("outTfID"));
$TPL["inTfOptions"] = page::select_options($options, config::get_config_item("inTfID"));
$TPL["taxTfOptions"] = page::select_options($options, config::get_config_item("taxTfID"));
$TPL["expenseFormTfOptions"] = page::select_options($options, config::get_config_item("expenseFormTfID"));
$tabops = array("home" => "Home", "client" => "Clients", "project" => "Projects", "task" => "Tasks", "time" => "Time", "invoice" => "Invoices", "sale" => "Sales", "person" => "People", "wiki" => "Wiki", "inbox" => "Inbox", "tools" => "Tools");
$selected_tabops = config::get_config_item("allocTabs") or $selected_tabops = array_keys($tabops);
$TPL["allocTabsOptions"] = page::select_options($tabops, $selected_tabops);
$m = new meta("currencyType");
$currencyOptions = $m->get_assoc_array("currencyTypeID", "currencyTypeName");
$TPL["currencyOptions"] = page::select_options($currencyOptions, config::get_config_item("currency"));
$db = new db_alloc();
$display = array("", "username", ", ", "emailAddress");
$person = new person();
$people =& get_cached_table("person");
foreach ($people as $p) {
$peeps[$p["personID"]] = $p["name"];
}
// get the default time sheet manager/admin options
$TPL["defaultTimeSheetManagerListText"] = get_person_list(config::get_config_item("defaultTimeSheetManagerList"));
$TPL["defaultTimeSheetAdminListText"] = get_person_list(config::get_config_item("defaultTimeSheetAdminList"));
$days = array("Sun" => "Sun", "Mon" => "Mon", "Tue" => "Tue", "Wed" => "Wed", "Thu" => "Thu", "Fri" => "Fri", "Sat" => "Sat");
$TPL["calendarFirstDayOptions"] = page::select_options($days, config::get_config_item("calendarFirstDay"));
$TPL["timeSheetPrintOptions"] = page::select_options($TPL["timeSheetPrintOptions"], $TPL["timeSheetPrint"]);
$commentTemplate = new commentTemplate();
alloc_error("No permissions to generate TF list");
}
}
//special case for disabled TF. Include it in the list, but also add a warning message.
$tf = new tf();
$tf->set_id($transactionRepeat->get_value("tfID"));
if ($tf->select() && !$tf->get_value("tfActive")) {
$TPL["message_help"][] = "This expense is allocated to an inactive TF. It will not create transactions.";
}
$tf = new tf();
$tf->set_id($transactionRepeat->get_value("fromTfID"));
if ($tf->select() && !$tf->get_value("tfActive")) {
$TPL["message_help"][] = "This expense is sourced from an inactive TF. It will not create transactions.";
}
$m = new meta("currencyType");
$currencyOps = $m->get_assoc_array("currencyTypeID", "currencyTypeID");
$TPL["currencyTypeOptions"] = page::select_options($currencyOps, $transactionRepeat->get_value("currencyTypeID"));
$TPL["tfOptions"] = page::select_options($q, $transactionRepeat->get_value("tfID"));
$TPL["fromTfOptions"] = page::select_options($q, $transactionRepeat->get_value("fromTfID"));
$TPL["basisOptions"] = page::select_options(array("weekly" => "weekly", "fortnightly" => "fortnightly", "monthly" => "monthly", "quarterly" => "quarterly", "yearly" => "yearly"), $transactionRepeat->get_value("paymentBasis"));
$TPL["transactionTypeOptions"] = page::select_options(transaction::get_transactionTypes(), $transactionRepeat->get_value("transactionType"));
if (is_object($transactionRepeat) && $transactionRepeat->get_id() && $current_user->have_role("admin")) {
$TPL["adminButtons"] .= '
<select name="changeTransactionStatus"><option value="">Transaction Status<option value="approved">Approve<option value="rejected">Reject<option value="pending">Pending</select>
';
}
if (is_object($transactionRepeat) && $transactionRepeat->get_id() && $transactionRepeat->get_value("status") == "pending") {
$TPL["message_help"][] = "This Repeating Expense will only create Transactions once its status is Approved.";
} else {
if (!$transactionRepeat->get_id()) {
$TPL["message_help"][] = "Complete all the details and click the Save button to create an automatically Repeating Expense";
return;
} else {
if ($_POST["delete"]) {
$client->read_globals();
$client->delete();
alloc_redirect($TPL["url_alloc_clientList"]);
} else {
$client->set_id($clientID);
$client->select();
}
$client->set_values("client_");
}
}
}
$m = new meta("clientStatus");
$clientStatus_array = $m->get_assoc_array("clientStatusID", "clientStatusID");
$TPL["clientStatusOptions"] = page::select_options($clientStatus_array, $client->get_value("clientStatus"));
$clientCategories = config::get_config_item("clientCategories") or $clientCategories = array();
foreach ($clientCategories as $k => $v) {
$cc[$v["value"]] = $v["label"];
}
$TPL["clientCategoryOptions"] = page::select_options($cc, $client->get_value("clientCategory"));
$client->get_value("clientCategory") and $TPL["client_clientCategoryLabel"] = $cc[$client->get_value("clientCategory")];
// client contacts
if ($_POST["clientContact_save"] || $_POST["clientContact_delete"]) {
$clientContact = new clientContact();
$clientContact->read_globals();
if ($_POST["clientContact_save"]) {
#$clientContact->set_value('clientID', $_POST["clientID"]);
$clientContact->save();
}
function load_task_filter($_FORM)
{
$current_user =& singleton("current_user");
$db = new db_alloc();
// Load up the forms action url
$rtn["url_form_action"] = $_FORM["url_form_action"];
$rtn["hide_field_options"] = $_FORM["hide_field_options"];
//time Load up the filter bits
has("project") and $rtn["projectOptions"] = project::get_list_dropdown($_FORM["projectType"], $_FORM["projectID"]);
$_FORM["projectType"] and $rtn["projectType_checked"][$_FORM["projectType"]] = " checked";
$ops = array("0" => "Nobody");
$rtn["personOptions"] = page::select_options($ops + person::get_username_list($_FORM["personID"]), $_FORM["personID"]);
$rtn["managerPersonOptions"] = page::select_options($ops + person::get_username_list($_FORM["managerID"]), $_FORM["managerID"]);
$rtn["creatorPersonOptions"] = page::select_options(person::get_username_list($_FORM["creatorID"]), $_FORM["creatorID"]);
$rtn["all_tags"] = task::get_tags(true);
$rtn["tags"] = $_FORM["tags"];
$taskType = new meta("taskType");
$taskType_array = $taskType->get_assoc_array("taskTypeID", "taskTypeID");
$rtn["taskTypeOptions"] = page::select_options($taskType_array, $_FORM["taskTypeID"]);
$_FORM["taskView"] and $rtn["taskView_checked_" . $_FORM["taskView"]] = " checked";
$taskStatii = task::get_task_statii_array();
$rtn["taskStatusOptions"] = page::select_options($taskStatii, $_FORM["taskStatus"]);
$_FORM["showDescription"] and $rtn["showDescription_checked"] = " checked";
$_FORM["showDates"] and $rtn["showDates_checked"] = " checked";
$_FORM["showCreator"] and $rtn["showCreator_checked"] = " checked";
$_FORM["showAssigned"] and $rtn["showAssigned_checked"] = " checked";
$_FORM["showTimes"] and $rtn["showTimes_checked"] = " checked";
$_FORM["showPercent"] and $rtn["showPercent_checked"] = " checked";
$_FORM["showPriority"] and $rtn["showPriority_checked"] = " checked";
$_FORM["showTaskID"] and $rtn["showTaskID_checked"] = " checked";
$_FORM["showManager"] and $rtn["showManager_checked"] = " checked";
$_FORM["showProject"] and $rtn["showProject_checked"] = " checked";
$_FORM["showTags"] and $rtn["showTags_checked"] = " checked";
$_FORM["showParentID"] and $rtn["showParentID_checked"] = " checked";
$arrow = " -->";
$taskDateOps = array("" => "", "new" => "New Tasks", "due_today" => "Due Today", "overdue" => "Overdue", "d_created" => "Date Created" . $arrow, "d_assigned" => "Date Assigned" . $arrow, "d_targetStart" => "Estimated Start" . $arrow, "d_targetCompletion" => "Estimated Completion" . $arrow, "d_actualStart" => "Date Started" . $arrow, "d_actualCompletion" => "Date Completed" . $arrow);
$rtn["taskDateOptions"] = page::select_options($taskDateOps, $_FORM["taskDate"], 45, false);
if (!in_array($_FORM["taskDate"], array("new", "due_today", "overdue"))) {
$rtn["dateOne"] = $_FORM["dateOne"];
$rtn["dateTwo"] = $_FORM["dateTwo"];
}
$task_num_ops = array("" => "All results", 1 => "1 result", 2 => "2 results", 3 => "3 results", 4 => "4 results", 5 => "5 results", 10 => "10 results", 15 => "15 results", 20 => "20 results", 30 => "30 results", 40 => "40 results", 50 => "50 results", 100 => "100 results", 150 => "150 results", 200 => "200 results", 300 => "300 results", 400 => "400 results", 500 => "500 results", 1000 => "1000 results", 2000 => "2000 results", 3000 => "3000 results", 4000 => "4000 results", 5000 => "5000 results", 10000 => "10000 results");
$rtn["limitOptions"] = page::select_options($task_num_ops, $_FORM["limit"]);
// unset vars that aren't necessary
foreach ((array) $_FORM as $k => $v) {
if (!$v) {
unset($_FORM[$k]);
}
}
// Get
$rtn["FORM"] = "FORM=" . urlencode(serialize($_FORM));
return $rtn;
}
function get_project_type_array()
{
// optimization
static $rows;
if (!$rows) {
$m = new meta("projectType");
$rows = $m->get_assoc_array("projectTypeID", "projectTypeID");
}
return $rows;
}
$tf->set_id($TPL["project_cost_centre_tfID"]);
$tf->select();
$TPL["cost_centre_tfID_label"] = $tf->get_link();
}
$query = prepare("SELECT roleName,roleID FROM role WHERE roleLevel = 'project' ORDER BY roleSequence");
$db->query($query);
#$project_person_role_array[] = "";
while ($db->next_record()) {
$project_person_role_array[$db->f("roleID")] = $db->f("roleName");
}
$email_type_array = array("None" => "None", "Assigned Tasks" => "Assigned Tasks", "All Tasks" => "All Tasks");
$t = new meta("currencyType");
$currency_array = $t->get_assoc_array("currencyTypeID", "currencyTypeID");
$projectType_array = project::get_project_type_array();
$m = new meta("projectStatus");
$projectStatus_array = $m->get_assoc_array("projectStatusID", "projectStatusID");
$timeUnit = new timeUnit();
$rate_type_array = $timeUnit->get_assoc_array("timeUnitID", "timeUnitLabelB");
$TPL["project_projectType"] = $projectType_array[$TPL["project_projectType"]];
$TPL["projectType_options"] = page::select_options($projectType_array, $TPL["project_projectType"]);
$TPL["projectStatus_options"] = page::select_options($projectStatus_array, $TPL["project_projectStatus"]);
$TPL["project_projectPriority"] or $TPL["project_projectPriority"] = 3;
$projectPriorities = config::get_config_item("projectPriorities") or $projectPriorities = array();
$tp = array();
foreach ($projectPriorities as $key => $arr) {
$tp[$key] = $arr["label"];
}
$TPL["projectPriority_options"] = page::select_options($tp, $TPL["project_projectPriority"]);
$TPL["project_projectPriority"] and $TPL["priorityLabel"] = " <div style=\"display:inline; color:" . $projectPriorities[$TPL["project_projectPriority"]]["colour"] . "\">[" . $tp[$TPL["project_projectPriority"]] . "]</div>";
$TPL["defaultTimeSheetRate"] = $project->get_value("defaultTimeSheetRate");
$TPL["defaultTimeSheetUnit_options"] = page::select_options($rate_type_array, $project->get_value("defaultTimeSheetRateUnitID"));
}
if ($_POST["saveGoTf"]) {
alloc_redirect($TPL["url_alloc_transactionList"] . "tfID=" . $transaction->get_value("tfID"));
}
alloc_redirect($TPL["url_alloc_transaction"] . "transactionID=" . $transaction->get_id());
}
}
} else {
if ($_POST["delete"]) {
$transaction->delete();
alloc_redirect($TPL["url_alloc_transactionList"] . "tfID=" . $transaction->get_value("tfID"));
}
}
$transaction->set_tpl_values();
$t = new meta("currencyType");
$currency_array = $t->get_assoc_array("currencyTypeID", "currencyTypeID");
$TPL["currencyOptions"] = page::select_options($currency_array, $transaction->get_value("currencyTypeID"));
$TPL["product"] = page::htmlentities($transaction->get_value("product"));
$TPL["statusOptions"] = page::select_options(array("pending" => "Pending", "rejected" => "Rejected", "approved" => "Approved"), $transaction->get_value("status"));
$transactionTypes = transaction::get_transactionTypes();
$TPL["transactionTypeOptions"] = page::select_options($transactionTypes, $transaction->get_value("transactionType"));
is_object($transaction) and $TPL["transactionTypeLink"] = $transaction->get_transaction_type_link();
$db = new db_alloc();
$tf = new tf();
$options = $tf->get_assoc_array("tfID", "tfName");
// Special cases for the current tfID and fromTfID
$options = add_tf($transaction->get_value("tfID"), $options, "tfIDWarning", " (warning: the TF <b>%s</b> is currently inactive)");
$options = add_tf($transaction->get_value("fromTfID"), $options, "fromTfIDWarning", " (warning: the TF <b>%s</b> is currently inactive)");
$TPL["tfIDOptions"] = page::select_options($options, $transaction->get_value("tfID"));
$TPL["fromTfIDOptions"] = page::select_options($options, $transaction->get_value("fromTfID"));
$q = "SELECT projectID as value, projectName as label FROM project WHERE projectStatus = 'Current' ORDER BY projectName";
function load_client_filter($_FORM)
{
global $TPL;
$db = new db_alloc();
// Load up the forms action url
$rtn["url_form_action"] = $_FORM["url_form_action"];
$m = new meta("clientStatus");
$clientStatus_array = $m->get_assoc_array("clientStatusID", "clientStatusID");
$rtn["clientStatusOptions"] = page::select_options($clientStatus_array, $_FORM["clientStatus"]);
$rtn["clientName"] = $_FORM["clientName"];
$rtn["contactName"] = $_FORM["contactName"];
$letters = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "ALL");
foreach ($letters as $letter) {
if ($_FORM["clientLetter"] == $letter) {
$rtn["alphabet_filter"] .= " " . $letter;
} else {
$rtn["alphabet_filter"] .= " <a href=\"" . $TPL["url_alloc_clientList"] . "clientLetter=" . $letter . "&clientStatus=Current&applyFilter=1\">" . $letter . "</a>";
}
}
$clientCategory = $_FORM["clientCategory"];
$clientCategories = config::get_config_item("clientCategories") or $clientCategories = array();
foreach ($clientCategories as $k => $v) {
$cc[$v["value"]] = $v["label"];
}
$rtn["clientCategoryOptions"] = page::select_options($cc, $clientCategory);
// Get
$rtn["FORM"] = "FORM=" . urlencode(serialize($_FORM));
return $rtn;
}
$item->set_value("itemType", $_POST["update_itemType"]);
$item->save();
}
if ($_POST["remove_items"]) {
for ($i = 0; $i < count($_POST["itemID"]); $i++) {
$item = new item();
$item->set_id($_POST["itemID"][$i]);
$item->select();
$item->delete();
}
}
//so that the user can edit the item later
$TPL["personID"] = $current_user->get_id();
// item types
$itemType = new meta("itemType");
$TPL["itemTypes"] = page::select_options($itemType->get_assoc_array("itemTypeID", "itemTypeID"), $item->get_value("itemType"));
// setup item list (for removals)
$item_list = array();
$db = new db_alloc();
$db->query("SELECT * FROM item ORDER BY itemName");
while ($db->next_record()) {
$item = new item();
$item->read_db_record($db);
$item_list[$item->get_id()] = $item->get_value('itemName');
}
$TPL["item_list"] = page::select_options($item_list, "");
if ($_POST["edit_items"]) {
$item = new item();
$item->set_id($_POST["itemID"][0]);
$item->select();
if (count($_POST["itemID"]) < 1) {
function show_transaction_new($template)
{
global $TPL;
global $tflist;
$transaction = new transaction();
$transaction->set_values();
// wipe clean
$TPL["display"] = "display:none";
$m = new meta("currencyType");
$currencyOptions = $m->get_assoc_array("currencyTypeID", "currencyTypeID");
$TPL["currencyOptions"] = page::select_options($currencyOptions);
$TPL["tfList_dropdown"] = page::select_options($tflist);
$TPL["fromTfList_dropdown"] = page::select_options($tflist);
if (CAN_APPROVE_TRANSACTIONS && $TPL["productSale_status"] == "admin") {
$TPL["status"] = "<select name='status[]' class='txStatus'>";
$TPL["status"] .= page::select_options(transaction::get_transactionStatii()) . "</select>";
}
$TPL["pc_productCostID"] = '';
$TPL["pc_amount"] = '';
$TPL["pc_isPercentage"] = '';
$TPL["pc_currency"] = '';
$TPL["amountClass"] = '';
include_template($template);
}
