One Hat Cyber Team

Your IP : 216.73.216.240

Server IP : 162.240.106.28

Server : Linux server.ganesand.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64

Server Software : Apache

PHP Version : 7.1.33

Buat File | Buat Folder

Dir : ~/home/thoa/www/treasurer/excel/

Edit File: noniataexport.php

<?php
include '../config.php';
 error_reporting(0); 
require_once 'PHPExcel.php';

$year = mysql_real_escape_string($_POST['year']);	
		  $month = mysql_real_escape_string($_POST['month']);
$objPHPExcel = new PHPExcel();
$objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing();
$objDrawing->setPath('header.jpg');
$objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_RIGHT);
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader("&C&G");
$objPHPExcel->getActiveSheet()
    ->getStyle('A1:D1')
    ->getAlignment()
    ->setWrapText(true);
$objPHPExcel->getActiveSheet()
->getStyle('A1:D1')->applyFromArray(
    array(
        'fill' => array(
            'type' => PHPExcel_Style_Fill::FILL_SOLID,
            'color' => array('rgb' => 'FFFF00')
        ),
		'font'  => array(
        'bold'  => true,
        'color' => array('rgb' => '0000FF'),
    )
    )

);
   $style = array(
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
			'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER, 			  
        ),
		'font'  => array(
        'bold'  => true,
    ),		
		
    );

$objPHPExcel->getActiveSheet()->getStyle("A1:D2")->applyFromArray($style);
$objPHPExcel->setActiveSheetIndex(0)
    ->mergeCells('A1:D1');
$objPHPExcel->getActiveSheet()
    ->getCell('A1')
    ->setValue("\nTAMILNADU HAJ ORGANISERS ASSOCIATION\nCHENNAI- INDIA\nBILL FOR $month $year
");

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter		= new PHPExcel_Writer_Excel2007($objPHPExcel);

$sql = "SELECT * FROM noniatabill WHERE  NI_YR='$year' and NI_DATE like '%%%%-$month-%' ORDER BY NI_ID ASC";
$result1 = mysql_query($sql);

$row = 2; // 1-based index

$rowNumber = 2;

$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(66);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(4.71);

$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(8.71);

$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25.71);

$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(10.71);

$objPHPExcel->getActiveSheet()->getStyle('A1:D200')->getAlignment()->setWrapText(true); 
$objPHPExcel->getActiveSheet()->setCellValue('A'.$rowNumber, 'S.NO');

$objPHPExcel->getActiveSheet()->setCellValue('B'.$rowNumber, 'APP. NO');

$objPHPExcel->getActiveSheet()->setCellValue('C'.$rowNumber, 'GIVEN NAME');

$objPHPExcel->getActiveSheet()->setCellValue('D'.$rowNumber, 'Amount');

while($row = mysql_fetch_array($result1)) {

$row_data[]=$row;

$rowNumber = 3;
	$s=1;
$total = 0;
$total1 = 0;
$tot = 1;	
	    foreach($row_data as $data){

$objPHPExcel->getActiveSheet()->setCellValue('A'.$rowNumber, $s);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$rowNumber, $data['NI_NO']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$rowNumber, $data['NI_NAME']);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$rowNumber, $data['NI_GRAND']);

$total1 = $total1 + $data['NI_GRAND'];
$rowNumber++;
$s++;
}

}

$objPHPExcel->getActiveSheet()->setCellValue('A'.$rowNumber, $data['']);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$rowNumber, $data['']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$rowNumber, 'TOTAL');
$objPHPExcel->getActiveSheet()->setCellValue('D'.$rowNumber, $total1);

header('Content-Type: application/vnd.ms-excel');
/* header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); */
header('Content-Disposition: attachment;filename='.$year.'-Thoa-Monthwise'.'-'.$month.'.xls');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
ob_end_clean();
$objWriter->save('php://output');
exit;
?>