ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 52.14.59.25 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/ |
Upload File : |
<?php // //require_once('business login/classes/.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:myown_mainpage.php?you are not login"); } // if (isset($_GET['q']) and $_GET['q'] == 'logout') { $user->user_logout(); header("location:myown_mainpage.php? you are log out"); } if (isset($_SESSION['mqc']) and isset($_SESSION['yqc'])) { //$bkname = mysql_real_escape_string($_SESSION['schqc']);//$_SESSION['schqc']..$_SESSION['mqc']...$_SESSION['yqc'] $mth = mysql_real_escape_string($_SESSION['mqc']); $yr = mysql_real_escape_string($_SESSION['yqc']); $retype = mysql_real_escape_string($_SESSION['rtype']); } if($retype == 'totalEmolu') { $name = 'Total_Emolument'; } elseif($retype == 'gross_pay') { $name = 'Gross_Pay'; } elseif($retype == 'total_deduction') { $name = 'Total_Deduction'; } header('Content-Type: text/csv; charset=utf-8'); $filename = 'consolidated'.$name.' '.$mth.$yr.'.csv'; header('Content-Disposition: attachment; filename='.$filename); $output = fopen('php://output', 'w'); fputcsv($output, array('File Number', 'Name', 'Account No.', 'Amount', 'Bank', 'Sort Code', 'Purpose of payment')); $query="SELECT PY.fileNo, concat(PER.surname,' ',PER.first_name,' ', PER.othernames), concat('\'', PER.accNo), $retype, BK.bank, concat('\'', BK.sort_code), '$mth $yr Staff Salary' FROM tblper AS PER, tbl_conpayment AS PY, tbl_conbank AS BK WHERE (PER.fileNo = PY.fileno) and (PER.bank = BK.bank ) and (PY.month = '$mth' and PY.year= '$yr') order by PER.bank, PER.bankGroup"; $rs = mysql_query($query); $rs = mysql_query($query); while ($row = mysql_fetch_assoc($rs)) fputcsv($output, $row); ?>