$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(); } }