} else { $loan->set_value("personID", $current_user->get_id()); } $loan->set_value("dateBorrowed", $today); $loan->set_value("dateReturned", "0000-00-00"); $loan->save(); alloc_redirect($TPL["url_alloc_loanAndReturn"]); } } if ($_POST["returnItem"]) { $dbTemp = new db_alloc(); $dbTemp->query("select * from loan where itemID=%d and dateReturned='0000-00-00'", $itemID); $db = new db_alloc(); $db->query("select * from loan where loan.itemID=%d and dateBorrowed>dateReturned", $itemID); $db->next_record(); $loan->set_id($db->f("loanID")); if ($loan->select()) { $loan->set_value("dateReturned", $today); $loan->set_value("itemID", $itemID); // check to see if admin/manager returning someone elses item, and sent email if ($loan->get_value("personID") != $current_user->get_id()) { if ($current_user->have_role("admin") || $current_user->have_role("manage")) { $person = new person(); $person->set_id($loan->get_value("personID")); $person->select(); $loan->save(); } } else { $loan->save(); } }