forked from victorkagimu/KwaMoja
-
Notifications
You must be signed in to change notification settings - Fork 11
/
prlRepTax.php
152 lines (134 loc) · 5.35 KB
/
prlRepTax.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
/* $Revision: 1.0 $ */
$PageSecurity = 2;
if (isset($_POST['PrintPDF']) and isset($_POST['FSMonth']) and $_POST['FSMonth'] >= 0 and isset($_POST['FSYear']) and $_POST['FSYear'] >= 0) {
include ('config.php');
include ('includes/PDFStarter.php');
include ('includes/ConnectDB.php');
include ('includes/DateFunctions.php');
include ('includes/prlFunctions.php');
$FontSize = 12;
$PDF->addinfo('Title', _('Tax Return'));
$PDF->addinfo('Subject', _('Tax Return'));
$PageNumber = 0;
$line_height = 12;
if ($_POST['FSMonth'] == 0) {
$Title = _('Monthly Tax Return Listing') . ' - ' . _('Problem Report');
include ('includes/header.php');
prnMsg(_('Month not selected'), 'error');
echo "<BR><A HREF='" . $RootPath . "/index.php?" . SID . "'>" . _('Back to the menu') . '</A>';
include ('includes/footer.php');
exit;
}
if ($_POST['FSYear'] == 0) {
$Title = _('Monthly Tax Return Listing') . ' - ' . _('Problem Report');
include ('includes/header.php');
prnMsg(_('Year not selected'), 'error');
echo "<BR><A HREF='" . $RootPath . "/index.php?" . SID . "'>" . _('Back to the menu') . '</A>';
include ('includes/footer.php');
exit;
}
$TaxMonth = $_POST['FSMonth'];
$TaxYear = $_POST['FSYear'];
$TaxMonthStr = GetMonthStr($TaxMonth);
$PageNumber = 0;
$FontSize = 10;
$line_height = 12;
$FullName = '';
$TIN = '';
$TaxStatus = 0;
$TaxTotal = 0;
include ('includes/PDFTaxPageHeader.php');
$SQL = "SELECT employeeid,taxactnumber,taxstatusid
FROM prlemployeemaster
WHERE prlemployeemaster.taxstatusid <>''";
$TaxDetails = DB_query($SQL);
if (DB_num_rows($TaxDetails) > 0) {
while ($taxrow = DB_fetch_array($TaxDetails)) {
$EmpID = $taxrow['employeeid'];
$FullName = GetName($EmpID);
$TaxNumber = GetEmpRow($EmpID, 23);
$TaxID = GetEmpRow($EmpID, 35);
$SQL = "SELECT sum(tax) AS Tax
FROM prlpayrolltrans
WHERE prlpayrolltrans.employeeid='" . $taxrow['employeeid'] . "'
AND prlpayrolltrans.fsmonth='" . $TaxMonth . "'
AND prlpayrolltrans.fsyear='" . $TaxYear . "'";
$TaxMonthly = DB_query($SQL);
if (DB_num_rows($TaxMonthly) > 0) {
//although it is assume that hdmf deduction once only every month but who knows
while ($taxmonthlyrow = DB_fetch_array($TaxMonthly)) {
$TaxEE = $taxmonthlyrow['Tax'];
//$YPos -= (2 * $line_height); //double spacing
if ($TaxEE > 0) {
$GTTaxEE+= $TaxEE;
$FontSize = 8;
$PDF->selectFont('./fonts/Helvetica.afm');
$LeftOvers = $PDF->addTextWrap($Left_Margin, $YPos, 150, $FontSize, $FullName);
$LeftOvers = $PDF->addTextWrap($Left_Margin + 200, $YPos, 50, $FontSize, $TaxNumber, 'right');
$LeftOvers = $PDF->addTextWrap($Left_Margin + 290, $YPos, 50, $FontSize, $TaxID, 'right');
$LeftOvers = $PDF->addTextWrap($Left_Margin + 410, $YPos, 50, $FontSize, number_format($TaxEE, 2), 'right');
$YPos-= $line_height;
if ($YPos < ($Bottom_Margin)) {
include ('includes/PDFTaxPremiumPageHeader.php');
}
}
}
}
}
}
$LeftOvers = $PDF->line($Page_Width - $Right_Margin, $YPos, $Left_Margin, $YPos);
$YPos-= (2 * $line_height);
$LeftOvers = $PDF->addTextWrap($Left_Margin, $YPos, 150, $FontSize, 'Grand Total');
$LeftOvers = $PDF->addTextWrap($Left_Margin + 410, $YPos, 50, $FontSize, number_format($GTTaxEE, 2), 'right');
$LeftOvers = $PDF->line($Page_Width - $Right_Margin, $YPos, $Left_Margin, $YPos);
$buf = $PDF->output();
$len = strlen($buf);
header('Content-type: application/pdf');
header("Content-Length: $len");
header('Content-Disposition: inline; filename=TAXListing.pdf');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
$PDF->stream();
} elseif (isset($_POST['ShowPR'])) {
include ('includes/session.php');
$Title = _('Tax Monthly Return Listing');
include ('includes/header.php');
echo 'Use PrintPDF instead';
echo "<BR><A HREF='" . $RootPath . "/index.php?" . SID . "'>" . _('Back to the menu') . '</A>';
include ('includes/footer.php');
exit;
} else { /*The option to print PDF was not hit */
include ('includes/session.php');
$Title = _('Tax Monthly Return Listing');
include ('includes/header.php');
echo "<form method='post' action='" . basename(__FILE__) . '?' . SID . "'>";
echo '<table>';
echo '</select></td></tr>';
echo '<tr><td><align="centert"><b>' . _('FS Month') . ":<select name='FSMonth'>";
echo '<option selected="selected" value=0>' . _('Select One');
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');
echo '</select>';
echo '<select name="FSYear">';
echo '<option selected="selected" value=0>' . _('Select One');
for ($yy = 2006;$yy <= 2015;$yy++) {
echo "<option value=$yy>$yy</option>\n";
}
echo '</select></td></tr>';
echo '</table><P><input type="submit" name="ShowPR" value="' . _('Show SSS Premium') . '">';
echo '<P><input type="submit" name="PrintPDF" value="' . _('PrintPDF') . '">';
include ('includes/footer.php');;
} /*end of else not PrintPDF */
?>