One Hat Cyber Team

Your IP: 216.73.217.37
Server IP: 15.235.14.176
Server: Linux server2.ihostph.com 4.18.0-553.30.1.el8_10.x86_64 #1 SMP Tue Nov 26 02:30:26 EST 2024 x86_64
Server Software: Apache
PHP Version: 8.1.34
Buat File | Buat Folder
Dir : ~/home/gracious/verification.graciousphils.com/
View File Name : print.php

<?php
include 'connection.php';
if(isset($_POST['btnPrint1'])){
	$startdate = $_POST['fromDate'];
	$enddate = $_POST['toDate'];
	$query = "select * from tblrequests where dateRequested >= :startdate and dateRequested < :enddate ORDER BY dateRequested DESC";
	$st = $pdo->prepare($query);
	$st->bindParam(':startdate', $startdate);
	$st->bindParam(':enddate', $enddate);
	 $st->execute();
	 if($st->rowCount() > 0){
	 	$delimiter = ",";
		$filename = "verification-data_" . date('Y-m-d') . ".csv";

		$f = fopen('php://memory', 'w');

		$fields = array('Request ID','Client Type','Client Number','Sales Office','Pension Provider','Pension Account Number','Pension Type','Member Name','Member Birthday','Pensioner Name','Pensioner Birthday','Address','Investigation Type','Contact Number','Social Media Account','Bank Name','Bank Account Number','Pension Amount','Remarks','Date Requested','Requested By','V1 Result','V1 Remarks','V1 Time','V1 Batch','V1 Date','V1 By','V2 Result','V2 Remarks','V2 Bank Name','V2 Bank Account Number','V2 Pension Amount','V2 SSS Verifier','V2 Date','V2 By','V3 Result','V3 Remarks','V3 No Reply Lending','V3 Date','V3 By','V4 Result','V4 Remarks','V4 Batman','V4 Visit Date','V4 Date','V4 By','Posted Date','Posted By','Status');
		fputcsv($f, $fields, $delimiter);

		while ($data = $st->fetch()) {
			$lineData = array($data['request_id'], $data['clientType'], $data['clientNumber'], $data['salesOffice'],  $data['pensionProvider'], $data['pensionAccountNumber'], $data['pensionType'], $data['memberName'], $data['memberBirthday'], $data['pensionerName'], $data['pensionerBirthday'], $data['address'], $data['investigationType'], $data['contactNumber'], $data['smAccount'], $data['bankName'], $data['bankAccountNumber'], $data['pensionAmount'], $data['remarks'], $data['dateRequested'], $data['requestedBy'], $data['v1Result'], $data['v1Remarks'], $data['v1Time'], $data['v1Batch'], $data['v1Date'], $data['v1By'], $data['v2Result'], $data['v2Remarks'], $data['v2BankName'], $data['v2BankAccountNumber'], $data['v2PensionAmount'], $data['v2SSSVerifier'], $data['v2Date'], $data['v2By'], $data['v3Result'], $data['v3Remarks'], $data['v3NoReply'], $data['v3Date'], $data['v3By'], $data['v4Result'], $data['v4Remarks'], $data['v4Batman'], $data['v4VisitDate'], $data['v4Date'], $data['v4By'], $data['postedDate'], $data['postedBy'], $data['status']);
			fputcsv($f, $lineData, $delimiter);
		}

		fseek($f, 0);

		header('Content-Type: text/csv');
		header('Content-Disposition: attachment; filename="' . $filename . '";');

		fpassthru($f);
	 }
	 exit;
}

if(isset($_POST['btnPrint2'])){
	$startdate = $_POST['fromDate'];
	$enddate = $_POST['toDate'];
	$query = "select * from tblrequests where dateRequested >= :startdate and dateRequested < :enddate ORDER BY dateRequested DESC";
	$st = $pdo->prepare($query);
	$st->bindParam(':startdate', $startdate);
	$st->bindParam(':enddate', $enddate);
	 $st->execute();
	 if($st->rowCount() > 0){
	 	$delimiter = ",";
		$filename = "verification-data-for-SM_" . date('Y-m-d') . ".csv";

		$f = fopen('php://memory', 'w');

		$fields = array('DATE','NAME','PT','SO','LC','STATUS','TYPE OF LOAN','ID#','REMARKS');
		fputcsv($f, $fields, $delimiter);

		while ($data = $st->fetch()) {
			$lineData = array($data['dateRequested'], $data['pensionerName'], $data['pensionType'], $data['salesOffice'], " ", " ", $data['clientType'], $data['clientNumber']);
			fputcsv($f, $lineData, $delimiter);
		}

		fseek($f, 0);

		header('Content-Type: text/csv');
		header('Content-Disposition: attachment; filename="' . $filename . '";');

		fpassthru($f);
	 }
	 exit;
}
?>