/
item_issue_panel3_control.php
117 lines (80 loc) · 2.32 KB
/
item_issue_panel3_control.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php
require_once 'core/init.php';
$member_role=$_SESSION['roles'];
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;
}
if(strtotime($rdate)>=strtotime(date("m/d/Y")))
$state2=true;
else
$state2=false;
if($state && $state2){
DB::getInstance()->commitTr();
$_SESSION["temp_basket"]=$_SESSION["basket"];
unset($_SESSION["basket"]);
unset($_SESSION["items"]);
echo "<div style='text-align:center';>";
echo "<img src='img/icons/success-icon.png' hight='200' width='200'>";
echo "<h2>Transaction Successful !</h2>";
echo "<a href='generate_slip.php?rdate=$rdate&member=$member' target='_blank'><h4>Print Transaction Slip</h4></a>";
echo "</div>";
}
else{
DB::getInstance()->rollBackTr();
echo "<div style='text-align:center';>";
echo "<img src='img/icons/error-icon.png' hight='200' width='200'>";
echo "<h2>Transaction Unsuccesssul !</h2>";
echo "<a href='item_issue_panel2.php'><h4><< Back to item transaction</h4></a>";
echo "</div>";
}
}
else{
echo "error";
}
?>