/
submitInput.php
152 lines (139 loc) · 5.79 KB
/
submitInput.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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
include ('database.php');
session_start();
if(isset($_POST['add_button'])) {
$clid=$_GET['client'];
$cid=$_GET['case'];
$userid=$_SESSION['id'];
$turndate=$_POST['turndate'];
$classtype=$_POST['class'];
$check = (isset($_POST['check']) ? $_POST['check'] : "");
$principal=$_POST['principal'];
$interest=$_POST['interest'];
$penalty=$_POST['penalty'];
$userid=$_SESSION['id'];
$sql1='SELECT * FROM clients, cases, expected WHERE clients.client_id like "'.$_GET['client'].'" AND cases.case_id like "'.$_GET['case'].'" AND clients.client_id=cases.client_id AND expected.case_id=cases.case_id AND expected.status="Unpaid" AND cases.status="Active"';
$result1 = $conn->query($sql1);
$turnamt=$principal+$interest+$penalty;
$p=$principal;
$i=$interest;
$tamt=$turnamt;//used in checking which records can be considered as paid
if (mysqli_num_rows($result1) > 0) {
while($row = mysqli_fetch_assoc($result1)) {
$atb = $row['actual_total_balance'];
$apb = $row['actual_principal_balance'];
$aib = $row['actual_interest_balance'];
}
}
$apb -= $principal;
$aib -= $interest;
$atb = $apb+$aib;
$Ymd = explode("/", $turndate);
$m = $Ymd[0];
$d = $Ymd[1];
$Y = $Ymd[2];
$turndate = date("Y-m-d", mktime(0, 0, 0, $m, $d, $Y));
if(!$result1){
echo $conn->error;
}
else{
$sql2="SELECT expected_id, case_id, principal_due, interest_due, total_due, status, remaining_principal_due, remaining_interest_due FROM expected WHERE case_id='".$cid."'";
$result2 = $conn->query($sql2);
if (mysqli_num_rows($result2) > 0) {
while($row = mysqli_fetch_assoc($result2)) {
if($p == 0 && $i == 0){
break;
}
$isPrincipalPaid=false;
$isInterestPaid=false;
$paid = $row['status'];
$principal_due = $row['principal_due'];
$interest_due = $row['interest_due'];
$total_due = $row['total_due'];
$eid = $row['expected_id'];
$rpd = $row['remaining_principal_due'];
$rid = $row['remaining_interest_due'];
//$rtd = $rpd + $rid;
if($p >= $rpd){
$p -= $rpd;
$rpd = 0;
$sqlA = "UPDATE expected SET remaining_principal_due = '$rpd' WHERE case_id = '".$cid."' AND expected_id = '".$eid."'";
$resultA = $conn->query($sqlA);
if(!$resultA){
echo $conn->error;
}
$isPrincipalPaid = true;
}
else{
$rpd -= $p;
$p = 0;
$sqlB = "UPDATE expected SET remaining_principal_due = '$rpd' WHERE case_id = '".$cid."' AND expected_id = '".$eid."'";
$resultB = $conn->query($sqlB);
if(!$resultB){
echo $conn->error;
}
}
if($i >= $rid){
$i -= $rid;
$rid = 0;
$sqlC = "UPDATE expected SET remaining_interest_due = '$rid' WHERE case_id = '".$cid."' AND expected_id = '".$eid."'";
$resultC = $conn->query($sqlC);
if(!$resultC){
echo $conn->error;
}
$isInterestPaid = true;
}
else{
$rid -= $i;
$i = 0;
$sqlD = "UPDATE expected SET remaining_interest_due = '$rid' WHERE case_id = ''".$cid."' AND expected_id = '".$eid."'";
$resultD = $conn->query($sqlD);
if(!$resultD){
echo $conn->error;
}
}
if($isPrincipalPaid && $isInterestPaid){
$paid = "Paid";
$sql3 = "UPDATE expected SET status = '$paid' WHERE case_id = '".$cid."' AND expected_id = '".$eid."'";
$result3 = $conn->query($sql3);
if(!$result3){
echo $conn->error;
}
$finaleid = $eid;
}
else
{
$finaleid = $eid;
}
}
}
$sql4 = "INSERT INTO payment(client_id,case_id,account_id,expected_id,turn_date,type_of_payment,check_number,turn_amount,principal_paid,
interest_paid,penalty,actual_principal,actual_interest,actual_total,status)
VALUES ('$clid','$cid','$userid','$finaleid','$turndate','$classtype','$check','$turnamt','$principal','$interest','$penalty', '$apb', '$aib', '$atb', 'ON TIME')";
//madami kulang
$result4 = $conn->query($sql4);
$sql5 = "UPDATE cases SET actual_total_balance = '".$atb."', actual_principal_balance = '".$apb."', actual_interest_balance = '".$aib."' WHERE case_id = '".$cid."' AND status='Active'";//updates status
$result5 = $conn->query($sql5);
$sql6 = "SELECT actual_total_balance FROM cases WHERE case_id='$cid' AND client_id='$clid' AND status='Active'";
$result6 = $conn->query($sql6);
if (mysqli_num_rows($result6) > 0) {
while($rowG = mysqli_fetch_assoc($result6)) {
if($rowG['actual_total_balance'] <= 0){
$sql7 = "UPDATE cases SET status='Closed' WHERE case_id='$cid' AND client_id='$clid' AND status='Active'";
$result7 = $conn->query($sql7);
}
}
}
}
if(!$result4||!$result5){
echo $conn->error;
}
else{
//echo $dom;
echo('<meta http-equiv="refresh" content="0;URL=view_single.php?client='.$clid.'"/>');
}
}
else{
echo "fuq";
}
?>