$db->query($query);
// Take care of the transaction line items on an invoiced timesheet created by admin
} else {
if (($_POST["transaction_save"] || $_POST["transaction_delete"]) && $timeSheet->have_perm(PERM_TIME_INVOICE_TIMESHEETS)) {
$transaction = new transaction();
$transaction->read_globals();
$transaction->read_globals("transaction_");
if ($_POST["transaction_save"]) {
if (is_numeric($_POST["percent_dropdown"])) {
$transaction->set_value("amount", $_POST["percent_dropdown"]);
}
$transaction->set_value("currencyTypeID", $timeSheet->get_value("currencyTypeID"));
$transaction->save();
} else {
if ($_POST["transaction_delete"]) {
$transaction->delete();
}
}
}
}
// display the approved by admin and managers name and date
$person = new person();
if ($timeSheet->get_value("approvedByManagerPersonID")) {
$person_approvedByManager = new person();
$person_approvedByManager->set_id($timeSheet->get_value("approvedByManagerPersonID"));
$person_approvedByManager->select();
$TPL["timeSheet_approvedByManagerPersonID_username"] = $person_approvedByManager->get_name();
$TPL["timeSheet_approvedByManagerPersonID"] = $timeSheet->get_value("approvedByManagerPersonID");
}
if ($timeSheet->get_value("approvedByAdminPersonID")) {
$person_approvedByAdmin = new person();
function delete_transactions()
{
$q = prepare("SELECT * FROM transaction WHERE productSaleItemID = %d", $this->get_id());
$db = new db_alloc();
$db->query($q);
while ($db->row()) {
$transaction = new transaction();
$transaction->read_db_record($db);
$transaction->delete();
}
}
