/**
* set cleared state for exp entry
*
* @param integer $id -> ID of record
* @param boolean $cleared -> true if record is cleared, otherwise false
* @global array $kga kimai-global-array
* @author sl
*/
function export_expense_set_cleared($id, $cleared)
{
global $kga, $database;
$conn = $database->getConnectionHandler();
$table = $kga['server_prefix'] . "expenses";
$values['cleared'] = $cleared ? 1 : 0;
$filter['expenseID'] = MySQL::SQLValue($id, MySQL::SQLVALUE_NUMBER);
$query = MySQL::BuildSQLUpdate($table, $values, $filter);
if ($conn->Query($query)) {
return true;
} else {
return false;
}
}