public function getItemsTransactionsByDateTime()
{
$operator = Base::instance()->get('PARAMS[operator]');
$date = Base::instance()->get('PARAMS[date]');
$time = Base::instance()->get('PARAMS[time]');
echo json_encode(ItemTransaction::getItemsTransactionsByDateTime($operator, $date, $time));
}
public function searchPendingReturns($tid)
{
$items = array();
$result1 = DB::getInstance()->search("transaction", ["transaction_id" => $tid]);
$result2 = DB::getInstance()->search("item_transaction", ["transaction_id" => $tid, "status" => 0]);
foreach ($result2 as $key => $value) {
$data1 = array("item_copy_id" => $value["item_copy_id"], "transaction_id" => $value["transaction_id"], "borrowed_quantity" => $value["borrowed_quantity"], "returned_date" => $value["returned_date"], "returned_quantity" => $value["returned_quantity"], "status" => $value["status"]);
$it = new ItemTransaction();
$it->create($data1);
$items[] = $it;
}
$data2 = array("id" => $result1[0]["transaction_id"], "purpose" => $result1[0]["transaction_description"], "borrow_comment" => $result1[0]["transaction_comment"], "return_comment" => $result1[0]["return_comment"], "member_id" => $result1[0]["member_id"], "borrowed_date" => $result1[0]["borrowed_date"], "expected_return_date" => $result1[0]["expected_return_date"]);
$t = new Transaction();
$t->create($data2);
$t->setItems($items);
return $t;
}
if (in_array("Laboratory Assistant", $member_role)) {
} else {
header('location:restricted_page.php');
}
if (isset($_SESSION["basket"]) && isset($_SESSION["items"])) {
$state = true;
DB::getInstance()->startTr();
$newTransaction = new Transaction();
$rdate = $_POST["expected_return_date"];
$member = $_SESSION["member_details"]["id"];
$data = array("id" => null, "purpose" => $_POST["purpose"], "borrow_comment" => $_POST["comments"], "return_comment" => null, "member_id" => $_SESSION["member_details"]["id"], "borrowed_date" => date("Y-m-d"), "expected_return_date" => $_POST["expected_return_date"]);
$newTransaction->create($data);
if ($newTransaction->add()) {
$transaction_id = DB::getInstance()->getLastId();
foreach ($_SESSION["basket"] as $key => $value) {
$newItemTransaction = new ItemTransaction();
$data = array("item_copy_id" => $value["item_copy_id"], "transaction_id" => $transaction_id, "borrowed_quantity" => $value["quantity"], "returned_date" => null, "returned_quantity" => null, "status" => 0);
$newItemTransaction->create($data);
if ($newItemTransaction->add()) {
$sql = "UPDATE item_copy SET item_copy_status=0 WHERE item_copy_id='" . $value["item_copy_id"] . "';";
if (!DB::getInstance()->directUpdate($sql)) {
$state = false;
break;
}
} else {
$state = false;
break;
}
}
} else {
$state = false;