-
Notifications
You must be signed in to change notification settings - Fork 0
/
calculate.php
93 lines (84 loc) · 4.25 KB
/
calculate.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
<?php
echo "zip : " . $_REQUEST['zipCode'] . "<br>";
echo "Loan Amount : " . $_REQUEST['loanAmount'] . "<br>";
echo "Property type : " . $_REQUEST['properyType'] . "<br>" ;
echo "Lock Days : " . $_REQUEST['lockDays'] . "<br>" ;
echo "Rate Margin : " . $_REQUEST['margin'] . "<br>" ;
$margin = $_REQUEST['margin'];
echo "<h3>Is confirming loan or not</h3>";
require 'testQuery.php';
$myQuery = new QueryDB();
$upperLimit = $myQuery->getConfirming($_REQUEST['zipCode'], $_REQUEST['properyType'], $_REQUEST['loanAmount']);
echo $upperLimit;
echo "<h3>Find SRP</h3>";
if (isset($_REQUEST['fixed30'])) {
echo "30 years Fixed " ;
echo "<br> - BBT <br>";
$loanType = ($_REQUEST['loanAmount'] > $upperLimit) ? 13:1 ;
$myQuery = new QueryDB();
$myQuery->getGroupedSRPByZip($_REQUEST['zipCode'],$loanType,$_REQUEST['loanAmount'], $upperLimit,1);
echo "<br> - BOKF <br>";
$myQuery = new QueryDB();
$myQuery->getGroupedSRPByZip($_REQUEST['zipCode'],$loanType,$_REQUEST['loanAmount'],$upperLimit,2);
};
if (isset($_REQUEST['fixed15'])) {
echo "15 years Fixed <br>" ;
echo "<br> - BBT <br>";
$loanType = ($_REQUEST['loanAmount'] > $upperLimit) ? 15:3 ;
$myQuery = new QueryDB();
$myQuery->getGroupedSRPByZip($_REQUEST['zipCode'],$loanType,$_REQUEST['loanAmount'], $upperLimit,1);
echo "<br> - BOKF <br>";
$myQuery = new QueryDB();
$myQuery->getGroupedSRPByZip($_REQUEST['zipCode'],$loanType,$_REQUEST['loanAmount'],$upperLimit,2);
};
if (isset($_REQUEST['fixed10'])) {
echo "10 years Fixed <br>" ;
echo "<br> - BBT <br>";
$loanType = ($_REQUEST['loanAmount'] > $upperLimit) ? 16:4 ;
$myQuery = new QueryDB();
$myQuery->getGroupedSRPByZip($_REQUEST['zipCode'],$loanType,$_REQUEST['loanAmount'], $upperLimit,1);
echo "<br> - BOKF <br>";
$myQuery = new QueryDB();
$myQuery->getGroupedSRPByZip($_REQUEST['zipCode'],$loanType,$_REQUEST['loanAmount'],$upperLimit,2);
};
if (isset($_REQUEST['arm31'])) {echo "3-1 ARM <br>" ; };
if (isset($_REQUEST['arm51'])) {echo "5-1 ARM <br>" ; };
if (isset($_REQUEST['arm71'])) {echo "7-1 ARM <br>" ; };
echo "<h3>Find rate</h3>";
if (isset($_REQUEST['fixed30'])) {
echo "30 years Fixed <br>" ;
echo "<br> - BBT <br>";
$loanType = ($_REQUEST['loanAmount'] > $upperLimit) ? 13:1 ;
$myQuery = new QueryDB();
$myQuery->getRate(1, $loanType, $_REQUEST['lockDays'],$_REQUEST['zipCode'], $_REQUEST['loanAmount'],$_REQUEST['properyType'],$margin);
echo "<br> - BOKF <br>";
$myQuery = new QueryDB();
$myQuery->getRate(2, $loanType ,$_REQUEST['lockDays'],$_REQUEST['zipCode'], $_REQUEST['loanAmount'],$_REQUEST['properyType'],$margin);
};
if (isset($_REQUEST['fixed15'])) {
echo "15 years Fixed <br>" ;
echo "<br> - BBT <br>";
$loanType = ($_REQUEST['loanAmount'] > $upperLimit) ? 15:3 ;
$myQuery = new QueryDB();
$myQuery->getRate(1,$loanType,$_REQUEST['lockDays'],$_REQUEST['zipCode'], $_REQUEST['loanAmount'],$_REQUEST['properyType'],$margin);
echo "<br> - BOKF <br>";
$myQuery = new QueryDB();
$myQuery->getRate(2,$loanType,$_REQUEST['lockDays'],$_REQUEST['zipCode'], $_REQUEST['loanAmount'],$_REQUEST['properyType'],$margin);
};
if (isset($_REQUEST['fixed10'])) {
echo "10 years Fixed <br>" ;
echo "<br> - BBT <br>";
$loanType = ($_REQUEST['loanAmount'] > $upperLimit) ? 16:4 ;
$myQuery = new QueryDB();
$myQuery->getRate(1,$loanType,$_REQUEST['lockDays'],$_REQUEST['zipCode'], $_REQUEST['loanAmount'],$_REQUEST['properyType'],$margin);
echo "<br> - BOKF <br>";
$myQuery = new QueryDB();
$myQuery->getRate(2,$loanType,$_REQUEST['lockDays'],$_REQUEST['zipCode'], $_REQUEST['loanAmount'],$_REQUEST['properyType'],$margin);
};
if (isset($_REQUEST['arm31'])) {echo "3-1 ARM <br>" ; };
if (isset($_REQUEST['arm51'])) {echo "5-1 ARM <br>" ; };
if (isset($_REQUEST['arm71'])) {echo "7-1 ARM <br>" ; };
echo "<h3>List of Fees</h3>";
$myQuery = new QueryDB();
$myQuery->getFees();
?>