public static function get_list($_FORM = array())
{
$filter = productSale::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>";
if (is_array($filter) && count($filter)) {
$f = " WHERE " . implode(" AND ", $filter);
}
$f .= " ORDER BY IFNULL(productSaleDate,productSaleCreatedTime)";
$db = new db_alloc();
$query = prepare("SELECT productSale.*, project.projectName, client.clientName\n FROM productSale \n LEFT JOIN client ON productSale.clientID = client.clientID\n LEFT JOIN project ON productSale.projectID = project.projectID\n " . $f);
$db->query($query);
$statii = productSale::get_statii();
$people =& get_cached_table("person");
$rows = array();
while ($row = $db->next_record()) {
$productSale = new productSale();
$productSale->read_db_record($db);
$row["amounts"] = $productSale->get_amounts();
$row["statusLabel"] = $statii[$row["status"]];
$row["salespersonLabel"] = $people[$row["personID"]]["name"];
$row["creatorLabel"] = $people[$row["productSaleCreatedUser"]]["name"];
$row["productSaleLink"] = $productSale->get_link();
$rows[] = $row;
}
return (array) $rows;
}
