Google

Edit File: ordersall_xlsx.php

<?php

include 'reader.php';

include 'session.php';

//$dbl = new ConDB();
$sessionQuery = "select username from admin_pass";

//$sessionResult = mysql_query($accQry, $db1->conn);

if(!$sessionResult = $db1->db->query($sessionQuery)){
 die('There was an error running the query [' . $db1->db->error . ']');
}
$row = $sessionResult->fetch_assoc();

//$row = mysql_fetch_assoc($sessionResult);
//if ($row['session'] == $_SESSION["keys"]) {
//} else {
//$row = $sessionResult->fetch_assoc();
if ($row['username'] == $_SESSION["keys"]) {
} else {

// header("Location: login.php");
}

<?php 
ini_set('display_errors', 1);

ini_set('display_startup_errors', 1);

error_reporting(E_ALL);

//require 'Models/ConDB.php';

include 'Classes/PHPExcel.php';
include 'Classes/PHPExcel/Writer/Excel2007.php';
//$db1 = new ConDB();

//$db1->db->query($time);
//$qry = $_POST['query'];
//$from = $_POST['from'];
//$to = $_POST['to'];
//$collqry = $_POST['collqry'];
$from = "order";
$to = "details";

$accQry = "select * from orders left join event on orders.event_id = event.event_id";
//$result1 = mysql_query($accQry, $db1->conn) or die(mysql_error()); 
if(!$result1 = $db1->db->query($accQry)){
                   die('There was an error running the query [' . $dbl->db->error . ']'); }

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getStyle("B2:P2")->getFont()->setBold(true);
$rowCount = 2;

$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, 'Sl No');
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, 'Event Name');
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, 'Order No');
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, 'stall no');

$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, 'amount');
$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, 'Paid');
$objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount, 'Payment Mode');
$rowCount++;
$i = 1;

while ($row = $result1->fetch_assoc()) {
      //  $dtime = date_format(date_create($row['created_dt']), "d M Y g:i a");
      //  $mtime = date_format(date_create($row['merchant_served_at']), "d M Y g:i a");
       // if($row['merchant_served_at'] != NULL){$mt = $mtime;}else{ $mt = "-";}

// if($row['code'] != ''){$code = $row['code'];}else{ $code = "N.A"; }
       // if($row['discount'] > 0){$dis = $row['discount'];}else{ $dis = "N.A"; }

$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $i);
        $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, $row['event_name']);
        $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, $row['order_id']);
        $objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $row['table_no']);
	    $objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, $row['amount']);
        $objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, $row['paid']);
        $objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount, $row['payment_mode']);
       
        $i++;
        $rowCount++;
}

$objPHPExcel->getActiveSheet()->getStyle("B2:Q".$rowCount)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->setTitle("Order Details");
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);

$name = "orders_all " . $from . " to " . $to . ".xlsx";

$name = str_replace(' ','_',$name);
// Write the Excel file to filename some_excel_file.xlsx in the current directory

//$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save($name);

echo json_encode($name);