/
submitCase.php
executable file
·89 lines (76 loc) · 2.54 KB
/
submitCase.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
<?php
include ('database.php');
session_start();
if(isset($_POST['add_button'])) {
$id1=$_GET['value'];
$status=$_POST['status'];
$loan=$_POST['loan'];
$dor=$_POST['dor'];
$weeks=$_POST['weeks'];
$rate=$_POST['rate'];
$notes=$_POST['notes'];
$r = $rate*0.01;
$daye = 7;
$days = $weeks*7;//convert to days
$Ymd = explode ("/", $dor);
$m = $Ymd[0];
$d = $Ymd[1];
$Y = $Ymd[2];
$dor = date("Y-m-d", mktime(0, 0, 0, $m, $d, $Y));//computes for date of release
$dom = date("Y-m-d", mktime(0, 0, 0, $m, $d+$days, $Y));//computes for date of maturity
$idue = $loan*$r;
$pdue = $loan/$weeks;
$tdue = $idue+$pdue;
$epb = $loan-$pdue;
//next few: $epb=$epb-$pdue
$eib = ($idue*$weeks)-$idue;
//next few: $eid=$eib-$idue
$etb = $epb+$eib;
$apb = $loan;
//next: $apb = $apb - principal from the input
$aib = $loan*$r*$weeks;
$atb = $apb+$aib;
$sql="INSERT INTO cases(client_id,loan_amount,actual_total_balance,date_of_release,date_of_maturity,payment_period,weekly_interest_rate,notes,status,actual_principal_balance,actual_interest_balance)
VALUES ('$id1','$loan','$atb','$dor','$dom','$weeks','$rate','$notes','$status','$apb','$aib')";
$result = $conn->query($sql);
if(!$result){
echo $conn->error;
}
else{
//pano query to get case id
//WHILE LOOP: like equate i to $ weeks then while i != 0 sya mangyayari, per each $i --
$i=1;
$doe = $dor;
while($i<=$weeks){
$doe = date("Y-m-d", mktime(0, 0, 0, $m, $d+7, $Y));//computes for first expected due date
$Ymd = explode ("-", $doe);
$Y = $Ymd[0];
$m = $Ymd[1];
$d = $Ymd[2];
$sql2="SELECT case_id FROM cases WHERE cases.client_id='$id1' AND date_of_release='$dor'";
$result2 = mysqli_query($conn, $sql2);
if (mysqli_num_rows($result2) > 0)
{
while($row = mysqli_fetch_assoc($result2))
{
$forcase=$row['case_id'];
$sql3 = "INSERT INTO expected(client_id,case_id,expected_due_date,expected_principal_balance,expected_interest_balance,expected_total_balance,principal_due,interest_due,total_due,remaining_principal_due,remaining_interest_due,status) VALUES('$id1','$forcase','$doe','$epb','$eib','$etb','$pdue','$idue','$tdue','$pdue','$idue','Unpaid')";
$result3 = $conn->query($sql3);
$tdue = $idue+$pdue;
$epb=$epb-$pdue;
$eib=$eib-$idue;
$etb=$epb+$eib;
$i++;
}
}
else{
echo $conn->error;
}
echo('<meta http-equiv="refresh" content="0;URL=view_Single.php?client='.$id1.'"/>');
}
}
}
else{
echo $conn->error;
}
?>