function load_productSale_filter($_FORM) { $current_user =& singleton("current_user"); // display the list of project name. $db = new db_alloc(); if (!$_FORM['showAllProjects']) { $filter = "WHERE projectStatus = 'Current' "; } $query = prepare("SELECT projectID AS value, projectName AS label FROM project {$filter} ORDER by projectName"); $rtn["show_project_options"] = page::select_options($query, $_FORM["projectID"], 70); // display the list of user name. if (have_entity_perm("productSale", PERM_READ, $current_user, false)) { $rtn["show_userID_options"] = page::select_options(person::get_username_list(), $_FORM["personID"]); } else { $person = new person(); $person->set_id($current_user->get_id()); $person->select(); $person_array = array($current_user->get_id() => $person->get_name()); $rtn["show_userID_options"] = page::select_options($person_array, $_FORM["personID"]); } // display a list of status $status_array = productSale::get_statii(); unset($status_array["create"]); $rtn["show_status_options"] = page::select_options($status_array, $_FORM["status"]); // display the date from filter value $rtn["showAllProjects"] = $_FORM["showAllProjects"]; $options["clientStatus"] = array("Current"); $options["return"] = "dropdown_options"; $ops = client::get_list($options); $ops = array_kv($ops, "clientID", "clientName"); $rtn["clientOptions"] = page::select_options($ops, $_FORM["clientID"]); // Get $rtn["FORM"] = "FORM=" . urlencode(serialize($_FORM)); return $rtn; }
if ($_POST["delete_productSale"]) { $productSale->delete(); alloc_redirect($TPL["url_alloc_productSaleList"]); } } } } } } } if ($productSale->have_perm(PERM_APPROVE_PRODUCT_TRANSACTIONS)) { define("CAN_APPROVE_TRANSACTIONS", 1); } else { define("CAN_APPROVE_TRANSACTIONS", 0); } $statuses = productSale::get_statii(); $statuses[$TPL["status"]] = "<b>" . $statuses[$TPL["status"]] . "</b>"; $TPL["statusText"] = implode(" | ", $statuses); $TPL["productSaleID"] = $productSale->get_id(); $showCosts = $_POST["showCosts"] or $_showCosts = $_GET["showCosts"]; $productSale->set_values(); list($client_select, $client_link, $project_select, $project_link) = client::get_client_and_project_dropdowns_and_links($clientID, $projectID); $TPL["show_client_options"] = $client_link; $TPL["show_project_options"] = $project_link; $tf = new tf(); if ($productSale->get_value("tfID")) { $tf->set_id($productSale->get_value("tfID")); $tf->select(); $TPL["show_tf_options"] = $tf->get_link(); $tf_sel = $productSale->get_value("tfID"); }