| Server IP : 199.250.214.225 / Your IP : 3.15.195.18 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/consolidated/nicnpayroll/ |
Upload File : |
<?php
require_once('business logic/classes/users.php');
require_once('business logic/classes/operations.php');
//
$user = new User();
$oper =new Operations();
//
$uid = $_SESSION['uid'];
$access = $_SESSION['acc'];
//
if (!$user->get_session())
{
header("location:index.php?you are not login");
}
//
if (isset($_GET['q']) and $_GET['q'] == 'logout')
{
$user->user_logout();
header("location:index.php? you are log out");
}
if (isset ($_SESSION['current_state']) and isset($_SESSION['tax']) and isset($_SESSION['mon']) and isset($_SESSION['yr']))
{
$taxt = mysql_real_escape_string($_SESSION['tax']);//$_SESSION['schqc']..$_SESSION['mqc']...$_SESSION['yqc']
$mth = mysql_real_escape_string($_SESSION['mon']);
$yr = mysql_real_escape_string($_SESSION['yr']);
$current_state = mysql_real_escape_string($_SESSION['current_state']);
}
header('Content-Type: text/csv; charset=utf-8');
$filename = $dv.$mth.$yr.$taxt.'.csv';
header('Content-Disposition: attachment; filename='.$filename);
$output = fopen('php://output', 'w');
fputcsv($output, array('File Number', 'Name', 'Tax'));
$query="SELECT PY.fileNo, concat(PER.surname,' ',PER.first_name,' ',PER.othernames), PY.tax
FROM tblper AS PER, tbl_conpayment AS PY WHERE (PER.fileNo = PY.fileNo)and PER.current_state = '$current_state' and PY.month = '$mth' and
PY.year = '$yr' group by PER.fileNo ASC";
$rs = mysql_query($query);
while ($row = mysql_fetch_assoc($rs))
fputcsv($output, $row);
?>