function show_report($_POST) { extract($_POST); if (!isset($employee) or strlen($employee) < 1) { return "Invalid use of module."; } db_connect(); $get_employee = "SELECT * FROM employees WHERE empnum = '{$employee}' LIMIT 1"; $run_employee = db_exec($get_employee) or errDie("Unable to get employees information."); if (pg_numrows($run_employee) < 1) { return "Invalid Employee Selected."; } else { $earr = pg_fetch_array($run_employee); //extract($earr); } $finstartdate = mkdate(getYearOfFinPrd(1) - 1, $PRDMON[1], 1); $finenddate = mkldate(getYearOfFinPrd(12) - 1, $PRDMON[12]); db_connect(); #get all leave for this employee $get_leave = "SELECT * FROM empleave WHERE empnum = '{$earr['empnum']}' AND startdate > '{$finstartdate}' AND enddate < '{$finenddate}'"; $run_leave = db_exec($get_leave) or errDie("Unable to get employee leave information."); if (pg_numrows($run_leave) < 1) { $listing = "Employee did not apply for leave during the previous financial year."; } else { $total_leave_days = 0; $listing = "\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Leave Start Date</th>\n\t\t\t\t\t<th>Leave End Date</th>\n\t\t\t\t\t<th>Approved By</th>\n\t\t\t\t\t<th>Working Days</th>\n\t\t\t\t\t<th>Non Working Days</th>\n\t\t\t\t\t<th>Leave Type</th>\n\t\t\t\t</tr>\n\t\t\t"; while ($larr = pg_fetch_array($run_leave)) { $total_leave_days = $total_leave_days + $larr['workingdays']; $listing .= "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>{$larr['startdate']}</td>\n\t\t\t\t\t\t<td>{$larr['enddate']}</td>\n\t\t\t\t\t\t<td>{$larr['approvedby']}</td>\n\t\t\t\t\t\t<td>{$larr['workingdays']}</td>\n\t\t\t\t\t\t<td>{$larr['nonworking']}</td>\n\t\t\t\t\t\t<td>{$larr['type']}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t"; } $total_cost = $earr['basic_sal_annum'] / (52 * 5) * $total_leave_days; } $display = "\n\t\t\t<h2>Calculate Value Of Employee Leave</h2>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t<input type='hidden' name='key' value='xls'>\n\t\t\t\t<input type='hidden' name='employee' value='{$employee}'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='2'>Details</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Employee:</td>\n\t\t\t\t\t<td>{$earr['fnames']} {$earr['sname']}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Amount Of Annual Leave Days:</td>\n\t\t\t\t\t<td>{$earr['stdlea']}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Total Days Leave Taken</td>\n\t\t\t\t\t<td>{$total_leave_days}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Total Cost Of Employee Leave</td>\n\t\t\t\t\t<td>" . CUR . " {$total_cost}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t{$listing}\n\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='4'><input type='submit' name='xls' value='Export to spreadsheet'></td>\n\t\t\t\t</tr>\n\t\t\t</form>\n\t\t\t</table>\n\t\t"; return $display; }
function get_period() { global $PRDMON; $finstartdate = mkdate(getYearOfFinPrd(1), $PRDMON[1], 1); $finenddate = mkldate(getYearOfFinPrd(12), $PRDMON[12]); db_connect(); #get vat period setting $get_set = "SELECT * FROM settings WHERE label = 'VAT Period' LIMIT 1"; $run_set = db_exec($get_set) or errDie("Unable to get vat period information."); if (pg_numrows($run_set) < 1) { return "\n\t\t\t<li class='err'>Please Set VAT Period Setting Before Continuing.</li>\n\t\t\t<p>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='../vat_period_setting.php'>Set VAT Period</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t</table>"; } else { $sarr = pg_fetch_array($run_set); $periodlength = $sarr['value']; $b = 1; $period_drop = "<select name='period'>"; for ($x = 1; $b < 12; $x = $x + $periodlength) { $b = $b + $periodlength; #make sure we dont cross the 12 period limit if ($b > 12) { #set period to the last $dob = $b - 12; $b = 12; #make sure we get the last month (the -1 makes us lose 1) // $PRDMON[$b] = $PRDMON[$b] +1; } else { $dob = $b; } $start = date("Y-m-d", mktime(0, 0, 0, $PRDMON[$x], 1, getYearOfFinPrd($x))); $end = date("Y-m-d", mktime(0, 0, 0, $PRDMON[$dob], 0, getYearOfFinPrd($b))); $period_drop .= "<option value='{$start}|{$end}'>{$start} - {$end}</option>"; } $period_drop .= "</select>"; } #generate the periods dropdown based on vat period setting. $display = "\n\t\t<h2>Select VAT Period For Report</h2>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<tr>\n\t\t\t\t<td><li class='err'>NOTE: Pre Generated Values Are The Cubit Recommened Values. </li></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td><li class='err'>However these values may be changed at will.</li></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Period</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$period_drop}</td>\n\t\t\t</tr>\n\t\t\t<tr><td></td></tr>\n\t\t\t<tr>\n\t\t\t\t<th>Name For Report</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='text' name='returnname' value='" . date("Y-m-d") . " Report'></td>\n\t\t\t</tr>\n\t\t\t<tr><td></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td align='right'><input type='submit' value='Next'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>"; return $display; }