public static function get_list($_FORM)
{
/*
* This is the definitive method of getting a list of timeSheetItems that need a sophisticated level of filtering
*
*/
global $TPL;
$filter = timeSheetItem::get_list_filter($_FORM);
$debug = $_FORM["debug"];
$debug and print "<pre>_FORM: " . print_r($_FORM, 1) . "</pre>";
$debug and print "<pre>filter: " . print_r($filter, 1) . "</pre>";
$_FORM["return"] or $_FORM["return"] = "html";
if (is_array($filter) && count($filter)) {
$filter = " WHERE " . implode(" AND ", $filter);
}
$q = "SELECT * FROM timeSheetItem\n LEFT JOIN timeSheet ON timeSheet.timeSheetID = timeSheetItem.timeSheetID\n " . $filter . "\n ORDER BY timeSheet.timeSheetID,dateTimeSheetItem asc";
$debug and print "Query: " . $q;
$db = new db_alloc();
$db->query($q);
while ($row = $db->next_record()) {
$print = true;
$t = new timeSheet();
$t->read_db_record($db);
$tsi = new timeSheetItem();
$tsi->read_db_record($db);
$tsi->currency = $t->get_value("currencyTypeID");
$row["secondsBilled"] = $row["hoursBilled"] = $row["timeLimit"] = $row["limitWarning"] = "";
# set these for the CLI
if ($tsi->get_value("taskID")) {
$task = $tsi->get_foreign_object('task');
$row["secondsBilled"] = $task->get_time_billed();
$row["hoursBilled"] = sprintf("%0.2f", $row["secondsBilled"] / 60 / 60);
$task->get_value('timeLimit') && $row["hoursBilled"] > $task->get_value('timeLimit') and $row["limitWarning"] = 'Exceeds Limit!';
$row["timeLimit"] = $task->get_value("timeLimit");
}
$row["rate"] = $tsi->get_value("rate", DST_HTML_DISPLAY);
$row["worth"] = page::money($tsi->currency, $row["rate"] * $tsi->get_value("multiplier") * $tsi->get_value("timeSheetItemDuration"), "%m");
$rows[$row["timeSheetItemID"]] = $row;
}
if ($print && $_FORM["return"] == "array") {
return $rows;
}
}
