forked from r3klaw/income_plus
-
Notifications
You must be signed in to change notification settings - Fork 0
/
books_annual.php
executable file
·224 lines (186 loc) · 7.79 KB
/
books_annual.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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
<!DOCTYPE HTML>
<?PHP
require 'functions.php';
checkLogin();
$db_link = connect();
$lastyear = date("Y", time())-1;
$suc_int = 0;
$suc_div = 0;
/**
* DISTRIBUTE ANNUAL SAVINGS INTEREST
*/
if(isset($_POST['int_distribute'])){
//Sanitize user input
$int_rate = sanitize($db_link, $_POST['int_rate']);
$int_year = sanitize($db_link, $_POST['int_year']);
$timestamp = time();
//Calculate UNIX TIMESTAMP for first and last day of selected year
$int_year_beg = mktime(0, 0, 0, 1, 1, $int_year);
$int_year_end = mktime(0, 0, 0, 1, 0, ($int_year+1));
//Get all active customers in array
$query_cust = getCustAct($db_link);
$cust = array();
while($row_cust = mysqli_fetch_assoc($query_cust)){
$cust[] = $row_cust;
}
//Get all savings in array
$sql_sav = "SELECT * FROM savings WHERE cust_id IN (SELECT cust_id FROM customer WHERE cust_active = 1) AND sav_date < $int_year_end";
$query_sav = mysqli_query($db_link, $sql_sav);
checkSQL($db_link, $query_sav);
$savings = array();
while ($row_sav = mysqli_fetch_assoc($query_sav)){
$savings[] = $row_sav;
}
// Compute Savings Factor
$int_base = 0;
$int_fact = 0;
$int_total = 0;
foreach ($cust as $c){
foreach ($savings as $s){
if ($s['cust_id'] == $c['cust_id']){
if ($s['sav_date'] < $int_year_beg)
$int_base = $int_base + $s['sav_amount'];
else {
if ($s['sav_amount'] > 0)
$int_base = $int_base + $s['sav_amount'] * round((($int_year_end - $s['sav_date'])/86400)/365,2);
elseif ($s['sav_amount'] <= 0)
$int_base = $int_base + $s['sav_amount'] * (1 - round((($s['sav_date'] - $int_year_beg)/86400)/365,2));
}
}
}
// Calculate annual interest for current customer
$int_cust = round($int_base /100 * $int_rate,0);
// Insert interest in SAVINGS
if($int_cust > 0){
$sql_cust_int = "INSERT INTO savings (cust_id, sav_date, sav_amount, savtype_id, sav_created, user_id) VALUES ($c[cust_id], $int_year_end, $int_cust, 3, $timestamp, $_SESSION[log_id])";
$query_cust_int = mysqli_query($db_link, $sql_cust_int);
checkSQL($db_link, $query_cust_int);
// Update savings account balance
updateSavingsBalance($db_link, $c['cust_id']);
}
$int_total = $int_total + $int_cust;
$int_base = 0;
}
// Insert grand total distributed interest into expenses
$sql_int_exp = "INSERT INTO expenses (exptype_id, exp_amount, exp_date, exp_text, exp_created, user_id) VALUES (19, $int_total, $int_year_end, 'Distributed Interest for $int_year', $timestamp, $_SESSION[log_id])";
$query_int_exp = mysqli_query($db_link, $sql_int_exp);
checkSQL($db_link, $query_int_exp );
$suc_int = 1;
}
/**
* DISTRIBUTE ANNUAL DIVIDEND
*/
if(isset($_POST['div_distribute'])){
//Sanitize user input
$div_value = sanitize($db_link, $_POST['div_value']);
$div_type = sanitize($db_link, $_POST['div_type']);
$div_year = sanitize($db_link, $_POST['div_year']);
$timestamp = time();
//Calculate UNIX TIMESTAMP for first and last day of selected year
$div_year_beg = mktime(0, 0, 0, 1, 1, $div_year);
$div_year_end = mktime(0, 0, 0, 1, 0, ($div_year+1));
//Get all active customers in array
$query_cust = getCustAct($db_link);
$cust = array();
while($row_cust = mysqli_fetch_assoc($query_cust)){
$cust[] = $row_cust;
}
//Get all shares in array
$sql_sh = "SELECT * FROM shares WHERE cust_id IN (SELECT cust_id FROM customer WHERE cust_active = 1) AND share_date < $div_year_end";
$query_sh = mysqli_query($db_link, $sql_sh);
checkSQL($db_link, $query_sh);
$shares = array();
$share_count = 0;
while ($row_sh = mysqli_fetch_assoc($query_sh)){
$shares[] = $row_sh;
$share_count = $share_count + $row_sh['share_amount'];
}
//If entered dividend value is grand total, divide it amount by the number of eligble shares
if($div_type == 2) $div_value = ceil($div_value / $share_count);
// Compute Share Factor
$div_fact = 0;
$div_total = 0;
foreach ($cust as $c){
foreach ($shares as $s){
if ($s['cust_id'] == $c['cust_id']){
if ($s['share_date'] < $div_year_beg)
$div_fact = $div_fact + $s['share_amount'];
else {
if ($s['share_amount'] > 0)
$div_fact = $div_fact + $s['share_amount'] * round(ceil(($div_year_end - $s['share_date'])/86400)/365,2);
elseif ($s['share_amount'] <= 0)
$div_fact = $div_fact + $s['share_amount'] * (1 - round(ceil(($s['share_date'] - $div_year_beg)/86400)/365,2));
}
}
}
// Calculate dividend for current customer
$div_cust = round($div_fact * $div_value,0);
// Insert dividend in SAVINGS
if($div_cust > 0){
$sql_cust_div = "INSERT INTO savings (cust_id, sav_date, sav_amount, savtype_id, sav_created, user_id) VALUES ($c[cust_id], $div_year_end, $div_cust, 9, $timestamp, $_SESSION[log_id])";
$query_cust_div = mysqli_query($db_link, $sql_cust_div);
checkSQL($db_link, $query_cust_div);
// Update savings account balance
updateSavingsBalance($db_link, $c['cust_id']);
}
$div_total = $div_total + $div_cust;
$div_fact=0;
}
// Insert grand total distributed dividend into expenses
$sql_div_exp = "INSERT INTO expenses (exptype_id, exp_amount, exp_date, exp_text, exp_created, user_id) VALUES (18, $div_total, $div_year_end, 'Distributed Dividend for $div_year', $timestamp, $_SESSION[log_id])";
$query_div_exp = mysqli_query($db_link, $sql_div_exp);
checkSQL($db_link, $query_div_exp );
$suc_div = 1;
}
?>
<html>
<?PHP includeHead('Annual Accounts',1) ?>
<body>
<!-- MENU -->
<?PHP includeMenu(4); ?>
<div id="menu_main">
<a href="start.php">Back</a>
<a href="books_expense.php">Expenses</a>
<a href="books_income.php">Incomes</a>
<a href="books_annual.php" id="item_selected">Annual Accounts</a>
</div>
<div class="content_center" style="width:60%;">
<div class="content_left" style="width:50%;">
<p class="heading">Annual Share Dividend</p>
<form action="books_annual.php" method="post">
<input type="number" name="div_year" min="2000" max="<?PHP echo $lastyear; ?>" placeholder="Enter Year" value="<?PHP echo $lastyear; ?>" required="required" />
<br/><br/>
<select name="div_type">
<option value="1">Dividend per share</option>
<option value="2">Grand Total Dividend</option>
</select>
<br/><br/>
<input type="number" name="div_value" min=".1" step="any" placeholder="<?PHP echo $_SESSION['set_cur']; ?>" required="required" />
<br/><br/>
<input type="submit" name="div_distribute" value="Distribute Dividend" />
</form>
</div>
<div class="content_right" style="width:50%;">
<p class="heading">Annual Savings Interest</p>
<form action="books_annual.php" method="post">
<input type="number" name="int_year" min="2000" max="<?PHP echo $lastyear; ?>" placeholder="Enter Year" value="<?PHP echo $lastyear; ?>" required="required" />
<br/><br/>
<input type="number" name="int_rate" min=".1" step=".1" placeholder="Interest Rate (%)" required="required" />
<br/><br/>
<input type="submit" name="int_distribute" value="Distribute Interest" />
</form>
</div>
<div style="display:block; clear:both; visibility:hidden; line-height:0; height:0; margin-bottom:4em"></div>
<div class="ui-widget">
<div class="ui-state-highlight ui-corner-all" style="width:50%; border:none; background-color:#fa6900; margin:auto; padding: .7em;">
<p style="color:#ffffff;"><span class="ui-icon ui-icon-info" style="float: left; margin-right: .3em;"></span>
Both operations may take some time to complete.<br/><br/>Do not click anything until you see a confirmation message!</p>
</div>
</div>
</div>
</body>
</html>
<?PHP
if($suc_int == 1) showMessage('Interest has been distributed.\n\nYou may now leave this page.');
if($suc_div == 1) showMessage('Dividend has been distributed.\n\nYou may now leave this page.');
?>