forked from victorkagimu/KwaMoja
-
Notifications
You must be signed in to change notification settings - Fork 11
/
prlEditPayroll.php
330 lines (302 loc) · 13.2 KB
/
prlEditPayroll.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
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
<?php
/* $Revision: 1.0 $ */
$PageSecurity = 5;
include ('includes/session.php');
$Title = _('Payroll Records Maintenance');
include ('includes/header.php');
include ('includes/prlFunctions.php');
if (isset($_GET['PayrollID'])) {
$PayrollID = $_GET['PayrollID'];
} elseif (isset($_POST['PayrollID'])) {
$PayrollID = $_POST['PayrollID'];
} else {
unset($PayrollID);
}
if (isset($_POST['submit'])) {
//initialise no input errors assumed initially before we test
$InputError = 0;
// Checking if Employee ID is set
if ($PayrollID == "") {
$InputError = 1;
prnMsg(_('Payroll ID must not be empty.'), 'error');
}
if ($_POST['PayPeriodID'] == "") {
$InputError = 1;
prnMsg(_('PayPeriod ID must not be empty.'), 'error');
}
if (!is_date($_POST['StartDate'])) {
$InputError = 1;
prnMsg(_('The field must be a date in the format') . ' ' . $_SESSION['DefaultDateFormat'], 'error');
}
if (!is_date($_POST['EndDate'])) {
$InputError = 1;
prnMsg(_('The field must be a date in the format') . ' ' . $_SESSION['DefaultDateFormat'], 'error');
}
if ($_POST['submit'] != _('Update Payroll Period')) {
if (($_POST[FSMonth] == "") or ($_POST[FSYear] == "")) {
echo "<ul><li>FS Month is a Mandatory Field.</li></ul>";
$InputError = 1;
}
}
if ($InputError != 1) {
$SQL_StartDate = FormatDateForSQL($_POST['StartDate']);
$SQL_EndDate = FormatDateForSQL($_POST['EndDate']);
if (!isset($_POST['New'])) {
$SQL = "UPDATE prlpayrollperiod SET
payrolldesc='" . DB_escape_string($_POST['Description']) . "',
payperiodid='" . DB_escape_string($_POST['PayPeriodID']) . "',
startdate='" . $SQL_StartDate . "',
enddate='" . $SQL_EndDate . "',
fsmonth='" . $_POST['FSMonth'] . "',
fsyear='" . $_POST['FSYear'] . "',
deductsss='" . DB_escape_string($_POST['SSS']) . "',
deducthdmf='" . DB_escape_string($_POST['HDMF']) . "',
deductphilhealth='" . DB_escape_string($_POST['PhilHealth']) . "'
WHERE payrollid = '$PayrollID'";
$ErrMsg = _('The payroll record could not be updated because');
$DbgMsg = _('The SQL that was used to update the payroll failed was');
$Result = DB_query($SQL, $ErrMsg, $DbgMsg);
prnMsg(_('The payroll master record for') . ' ' . $PayrollID . ' ' . _('has been updated'), 'success');
} else { //its a new payroll
$SQL = "INSERT INTO prlpayrollperiod (
payrollid,
payrolldesc,
payperiodid,
startdate,
enddate,
fsmonth,
fsyear,
deductsss,
deducthdmf,
deductphilhealth,
payclosed)
VALUES ('$PayrollID',
'" . DB_escape_string($_POST['Description']) . "',
'" . DB_escape_string($_POST['PayPeriodID']) . "',
'" . $SQL_StartDate . "',
'" . $SQL_EndDate . "',
'" . $_POST['FSMonth'] . "',
'" . $_POST['FSYear'] . "',
'" . DB_escape_string($_POST['SSS']) . "',
'" . DB_escape_string($_POST['HDMF']) . "',
'" . DB_escape_string($_POST['PhilHealth']) . "',
'0'
)";
$ErrMsg = _('The payroll period') . ' ' . $_POST['Description'] . ' ' . _('could not be added because');
$DbgMsg = _('The SQL that was used to insert the payroll period but failed was');
$Result = DB_query($SQL, $ErrMsg, $DbgMsg);
prnMsg(_('A new payroll period for') . ' ' . $_POST['Description'] . ' ' . _('has been added to the database'), 'success');
unset($PayrollID);
unset($_POST['Description']);
unset($_POST['PayPeriodID']);
unset($SQL_StartDate);
unset($SQL_EndDate);
unset($_POST['FSMonth']);
unset($_POST['FSYear']);
unset($_POST['SSS']);
unset($_POST['HDMF']);
unset($_POST['PhilHealth']);
}
} else {
prnMsg(_('Validation failed') . _('no updates or deletes took place'), 'warn');
}
} elseif (isset($_POST['delete']) and $_POST['delete'] != '') {
//the link to delete a selected record was clicked instead of the submit button
$CancelDelete = 0;
$SQL = "SELECT counterindex,payrollid,employeeid,basicpay,absent,late,otpay,fsmonth,fsyear
FROM prlpayrolltrans
WHERE prlpayrolltrans.payrollid='" . $PayrollID . "'";
$PayDetails = DB_query($SQL);
if (DB_num_rows($PayDetails) > 0) {
$CancelDelete = 1;
exit("Payroll can not be deleted. Payroll records found...");
}
// PREVENT DELETES IF DEPENDENT RECORDS IN 'SuppTrans' , PurchOrders, SupplierContacts
if ($CancelDelete == 0) {
$SQL = "DELETE FROM prlpayrollperiod WHERE payrollid='$PayrollID'";
$Result = DB_query($SQL);
prnMsg(_('Payroll record for') . ' ' . $Description . ' ' . _('has been deleted'), 'success');
unset($PayrollID);
unset($_SESSION['PayrollID']);
} //end if Delete payroll
} //end of (isset($_POST['submit']))
if (!isset($PayrollID)) {
/*If the page was called without $PayrollID passed to page then assume a new payroll is to be entered*/
echo "<form method='post' ACTION='" . basename(__FILE__) . "?" . SID . "'>";
echo "<input type='hidden' name='New' value='Yes'>";
echo '<table>';
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Payroll ID') . ':</td><td><input type="text" name="PayrollID" size=11 maxlength=10></td>;
<td><align=right><b>Accept Alpha Numeric Character. No spaces in between..</b></td></tr>';
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Description') . ':</td><td><input type="text" name="Description" size=42 maxlength=40></td></tr>';
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Pay Period') . ":</td><td><select name='PayPeriodID'>";
DB_data_seek($Result, 0);
$SQL = 'SELECT payperiodid, payperioddesc FROM prlpayperiod';
$Result = DB_query($SQL);
while ($MyRow = DB_fetch_array($Result)) {
if ($_POST['PayPeriodID'] == $MyRow['payperiodid']) {
echo '<option selected="selected" value=' . $MyRow['payperiodid'] . '>' . $MyRow['payperioddesc'];
} else {
echo '<option value=' . $MyRow['payperiodid'] . '>' . $MyRow['payperioddesc'];
}
} //end while loop
$DateString = Date($_SESSION['DefaultDateFormat']);
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Start Date') . ' (' . $_SESSION['DefaultDateFormat'] . ':</td><td><input type="text" name="StartDate" value="', $DateString, '" size=12 maxlength=10></td></tr>';
echo '<tr><td width=200 height=20><div align="right"><b>' . _('End Date') . ' (' . $_SESSION['DefaultDateFormat'] . ':</td><td><input type="text" name="EndDate" value="', $DateString, '"size=12 maxlength=10></td></tr>';
?>
<tr>
<td width=200 height="20">
<div align="right"><b>FS Month :</b></div>
</td>
<td height="20">
<select name="FSMonth">
<option value="" SELECTED>Month</option>
<option value=01>January</option>
<option value=02>February</option>
<option value=03>March</option>
<option value=04>April</option>
<option value=05>May</option>
<option value=06>June</option>
<option value=07>July</option>
<option value=08>August</option>
<option value=09>September</option>
<option value=10>October</option>
<option value=11>November</option>
<option value=12>December</option>
</select>
<select name="FSYear">
<option value="" Selected>Year</option>
<?
for ($yy=2006;$yy<=2015;$yy++)
{
echo "<option value=$yy>$yy</option>\n";
}
?>
</select>
<? echo $star; ?>
</td>
</tr>
<?php
echo '</select></td></tr><tr><td width=200 height=20><div align="right"><b>' . _('Deduct SSS') . ":</td><td><select name='SSS'>";
echo '<option value=0>' . _('Yes');
echo '<option value=1>' . _('No');
echo '</select></td></tr>';
echo '</select></td></tr><tr><td width=200 height=20><div align="right"><b>' . _('Deduct HDMF') . ":</td><td><select name='HDMF'>";
echo '<option value=0>' . _('Yes');
echo '<option value=1>' . _('No');
echo '</select></td></tr><tr><td width=200 height=20><div align="right"><b>' . _('Deduct PhilHealt') . ":</td><td><select name='PhilHealth'>";
echo '<option value=0>' . _('Yes');
echo '<option value=1>' . _('No');
echo '</select></td></tr>';
echo '</select></td></tr></table><p><input type="submit" name="submit" value="' . _('Insert New Payroll') . '">';
echo '</form>';
} else {
echo "<form method='post' action='" . basename(__FILE__) . '?' . SID . "'>";
echo '<table>';
if (!isset($_POST['New'])) {
$SQL = "SELECT payrollid,
payrolldesc,
payperiodid,
startdate,
enddate,
fsmonth,
fsyear,
deductsss,
deducthdmf,
deductphilhealth,
payclosed
FROM prlpayrollperiod
WHERE payrollid = '$PayrollID'";
$Result = DB_query($SQL);
$MyRow = DB_fetch_array($Result);
$_POST['Description'] = $MyRow['payrolldesc'];
$_POST['PayPeriodID'] = $MyRow['payperiodid'];
$_POST['StartDate'] = ConvertSQLDate($MyRow['startdate']);
$_POST['EndDate'] = ConvertSQLDate($MyRow['enddate']);
$_POST['FSMonth'] = $MyRow['fsmonth'];
$_POST['FSYear'] = $MyRow['fsyear'];
$_POST['SSS'] = $MyRow['deductsss'];
$_POST['HDMF'] = $MyRow['deducthdmf'];
$_POST['PhilHealth'] = $MyRow['deductphilhealth'];
$_POST['Status'] = $MyRow['payclosed'];
echo "<input type=HIDDEN name='PayrollID' value='$PayrollID'>";
} else {
// its a new employee being added
echo "<input type=HIDDEN name='New' value='Yes'>";
echo '<tr><td>' . _('Payroll ID') . ':</td><td><input type="text" name="PayrollID" value="', $PayrollID, '" size=12 maxlength=10></td></tr>';
}
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Description') . ':</td><td><input type="text" name="Description" value="' . $_POST['Description'] . '" size=42 maxlength=40></td></tr>';
echo '</select></td></tr>';
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Pay Period') . ':</td><td><select name="PayPeriodID">';
DB_data_seek($Result, 0);
$SQL = 'SELECT payperiodid, payperioddesc FROM prlpayperiod';
$Result = DB_query($SQL);
while ($MyRow = DB_fetch_array($Result)) {
if ($MyRow['payperiodid'] == $_POST['PayPeriodID']) {
echo '<option selected="selected" value=';
} else {
echo '<option value=';
}
echo $MyRow['payperiodid'] . '>' . $MyRow['payperioddesc'];
} //end while loop
echo '<tr><td width=200 height=20><div align="right"><b>' . _('Start Date') . ':</td><td><input type="text" name="StartDate" value="' . $_POST['StartDate'] . '" size=22 maxlength=20></td></tr>';
echo '<tr><td width=200 height=20><div align="right"><b>' . _('End Date') . ':</td><td><input type="text" name="EndDate" value="' . $_POST['EndDate'] . '" size=22 maxlength=20></td></tr>';
$MosStr = GetMonthStr($_POST['FSMonth']);
$Mos = GetMonthStr($_POST['FSMonth']);
$FSY = $_POST['FSYear'];
echo '</select></td></tr>';
echo '<tr><td width=200 height="20"><div align="right"><b>' . _('FS Month') . ":</td><td><select name='FSMonth'>";
echo '<option selected="selected" value=$Mos>' . _($MosStr);
echo '<option value=1>' . _('January');
echo '<option value=2>' . _('February');
echo '<option value=3>' . _('March');
echo '<option value=4>' . _('April');
echo '<option value=5>' . _('May');
echo '<option value=6>' . _('June');
echo '<option value=7>' . _('July');
echo '<option value=8>' . _('August');
echo '<option value=9>' . _('September');
echo '<option value=10>' . _('October');
echo '<option value=11>' . _('November');
echo '<option value=12>' . _('December');
$FSY = $_POST['FSYear'];
echo '</select>';
echo "<select name='FSYear'>";
echo '<option selected="selected" value=$FSY>' . _($FSY);
for ($yy = 2006;$yy <= 2015;$yy++) {
echo "<option value=$yy>$yy</option>\n";
}
echo '</select></td></tr><tr><td width=200 height=20><div align="right"><b>' . _('Deduct SSS') . ":</td><td><select name='SSS'>";
if ($_POST['SSS'] == 0) {
echo '<option selected="selected" value=0>' . _('Yes');
echo '<option value=1>' . _('No');
} else {
echo '<option value=0>' . _('Yes');
echo '<option selected="selected" value=1>' . _('No');
}
echo '</select></td></tr><tr><td width=200 height=20><div align="right"><b>' . _('Deduct HDMF') . ":</td><td><select name='HDMF'>";
if ($_POST['HDMF'] == 0) {
echo '<option selected="selected" value=0>' . _('Yes');
echo '<option value=1>' . _('No');
} else {
echo '<option value=0>' . _('Yes');
echo '<option selected="selected" value=1>' . _('No');
}
echo '</select></td></tr><tr><td width=200 height=20><div align="right"><b>' . _('Deduct PhilHealt') . ":</td><td><select name='PhilHealth'>";
if ($_POST['PhilHealth'] == 0) {
echo '<option selected="selected" value=0>' . _('Yes');
echo '<option value=1>' . _('No');
} else {
echo '<option value=0>' . _('Yes');
echo '<option selected="selected" value=1>' . _('No');
}
if (isset($_POST['New'])) {
echo '</table><P><input type="submit" name="submit" value="' . _('Add These New Employee Details') . '"></form>';
} else {
//echo "</select></td></tr></table><p><input type="submit" name='submit' value='" . _('Update Payroll Period') . "'>";
echo '</table><P><input type="submit" name="submit" value="' . _('Update Payroll Period') . '">';
echo '<P><FONT COLOR=red><B>' . _('WARNING') . ': ' . _('There is no second warning if you hit the delete button below') . '. ' . _('However checks will be made to ensure there are no outstanding purchase orders or existing accounts payable transactions before the deletion is processed') . '<BR></FONT></B>';
echo '<input type="submit" name="delete" value="' . _('Delete Payroll') . '" onclick=\"return confirm("' . _('Are you sure you wish to delete this payroll period?') . '");\"></form>';
}
}
include ('includes/footer.php');
?>