Google

Edit File: ordersall2_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'];
$event_id_new = $_POST['event_id3'];
//echo $event_id ;
$from = "order";
$to = "details";

$accQry = "select * from orders inner join event on orders.event_id = event.event_id where event.event_id = '$event_id_new'";
// $accQry3 = "select *  from orders left join order_items on orders.order_id = order_items.order_id where orders.event_id ='$event_id'";
//$accqry1= "select SUM(amount) from orders where event_id = '$event_id_new'";

//$result1 = mysql_query($accQry, $db1->conn)
if(!$result1 = $db1->db->query($accQry)){
                   die('There was an error running the query [' . $dbl->db->error . ']'); }

//$accqry1= "select SUM(amount) as amount  from orders where event_id = '$event_id_new'";
//if(!$result2 = $db1->db->query($accqry1)){
  //                 die('There was an error running the query [' . $dbl->db->error . ']'); }
//$order_count = $result2->fetch_assoc()
//$order_count1 = $order_count['amount'];

$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()->SetCellValue('I', 'Payment Mode');
 //$objPHPExcel->getActiveSheet()->SetCellValue('I', $order_count1;);

$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);