Google

Edit File: orders.php

<?php include 'session.php';
//error_reporting(E_ALL);
ini_set("display_errors", 0);
?>
<!DOCTYPE html>
<?php

include 'reader.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");
}

<html lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Orders</title>
	<link type="text/css" href="css/bootstrap.min.css" rel="stylesheet">
	<link type="text/css" href="css/bootstrap-responsive.min.css" rel="stylesheet">
	<link type="text/css" href="css/theme.css" rel="stylesheet">
	<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">
	<link type="text/css" href='http://fonts.googleapis.com/css?family=Open+Sans:400italic,600italic,400,600' rel='stylesheet'>
        <link type="text/css" href="css/admin_menu_edit.css" rel="stylesheet">
	<link type="text/css" href="css/switch.css" rel="stylesheet">
        <style type="text/css">
            #orders_id{
                color:#fff;
            }a:focus,a:hover{
	    	color:black;
		text-decoration:none; 
	   }
	   .dropdown-menu>li{ float:none; }
       
	 </style>
</head>
<body>

<div class="navbar navbar-fixed-top">
		<div class="navbar-inner">
			<div class="container" style="min-height: 50px;">
				
                            <a class="brand" href="merchant.php">
			  	Pinnacle
			  	</a>

<ul style="list-style-type: none;text-decoration:none;color:black;float:right;padding-top:10px;">
        <li class="dropdown" style="padding-top:10px;">
          <a class="dropdown-toggle" role="button" data-toggle="dropdown" href="#" style="color:black;">
            <b><?php echo $login_session; ?></b><span class="caret"></span></a>
          <ul id="g-account-menu" class="dropdown-menu" role="menu">
            <li><a href="logout.php">Logout</a></li>
          </ul>
        </li>
      </ul>

</div>
		</div>
	</div>

<?php include ('menu.php'); ?>

</div>
                        </div><br />
                                <div class="row">
				<div>
					<div class="content">

<div class="module">
							<div class="module-head">
							<?php
							 $sql = "SELECT event_name from event where `event_id` = '".$_GET['event_id']."' limit 1";
							 $res = $db1->db->query($sql)->fetch_assoc();
							?>
                                 <h3>Orders : <?=$res['event_name'];?></h3>
                                
                                  
							</div>

<div id="myModal3" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
                            <h3 id="myModalLabel">Download</h3>
                        </div>
                        <div class="modal-body" id="linkhere"></div>
                        <div class="modal-footer">
                            <button class="btn" data-dismiss="modal" aria-hidden="true">Close</button>
                        </div>
   </div> 
   
   
   <div class="module-body table">
								<table cellpadding="0" cellspacing="0" border="0" class="datatable-1 table table-bordered table-striped	 display" width="100%">
									<thead>
										<tr> 
										    <th>Sl No:</th>
										  
										    <th>Event Name</th>
											<th>Order Id</th>
                                                                                        <th>Hall No</th>
											<th>Stall No</th>
											<th>Amount</th>
											<th>Paid</th>
											<th>Payment Mode</th>
                                                                                        <th>Merchant Served At</th>
										
											<th>State</th>
											<th>Created Date</th>
											<th>Order Details</th>
										   </tr>
									</thead>
									<tbody>

<?php
              //  if($from == ''){
              //  $fm = $wk;
              //  $tm = $today;
              //  $acQry = "select * from orders left join event on orders.event_id = event.event_id where orders.created_dt between '$wk' and '$today'  ";
             
             
               
            
             
               
          $accQry = "select e.event_name, o.order_id,o.state, o.hall_number,o.table_no,o.amount,o.paid,o.payment_mode,o.merchant_served_at,o.created_dt 
          from orders o inner join event e on o.event_id = e.event_id AND o.`event_id` = ".$_GET['event_id']." ORDER BY o.created_dt DESC ";
						   // $result1 = mysql_query($accQry, $db1->conn) ;
                                                     if(!$result1 = $db1->db->query($accQry)){
                   die('There was an error running the query [' . $dbl->db->error . ']'); }
									$i = 1;
								        while ($row = $result1->fetch_assoc()) {
							                ?>

<tr id="doc_rows"  >
										    <td class="center"><?Php echo $i  ?>
                                                           
 
											  <td class="center"><?Php if($row['event_name'] != NULL){echo $row['event_name'];}else{echo "-";} ?></td>
											  <td class="center"><?Php if($row['order_id'] != NULL){echo $row['order_id'];}else{echo "-";} ?></td>
                                              <td class="center"><?Php if($row['hall_number'] != NULL){echo $row['hall_number'];}else{echo "-";} ?></td>
 									        <td class="center"><?Php if($row['table_no'] != NULL){echo $row['table_no'];}else{echo "-";} ?></td> 
									        <td class="center"><?Php if($row['amount'] != NULL){echo $row['amount'];}else{echo "-";} ?></td>
											<td class="center"><?Php if($row['paid'] != NULL){echo $row['paid'];}else{echo "-";} ?></td>
										   <td class="center"><?Php if($row['payment_mode'] != NULL){echo $row['payment_mode'];}else{echo "-";} ?></td>
										   <td class="center"><?Php if($row['merchant_served_at'] != NULL){echo $row['merchant_served_at'];}else{echo "-";} ?></td>
										   <td class="center"><?Php if($row['state'] != NULL){echo ($row['state']==2) ? 'Close' : 'Open';}else{echo "Open";} ?></td>
										   <td class="center"><?Php if($row['created_dt'] != NULL){echo $row['created_dt'];}else{echo "-";} ?></td>
								          <td class="center"><button id="button_id" style="color:white;background-color:#fcc87b;"  onclick="window.location='per_event_order_menu.php?order_id=<?php echo $row['order_id']?> '" >Order Details</button></td>
											 
										</tr>
									 <?php
								                $i++;
									            }
								            ?>

</tbody>
   
   
   
   
   
   
   
							 
							 
							 
							 
								</table>
							</div>
						</div>

$('#example').DataTable({
 stateSave:true

} );

function change(){
                document.getElementById("custom").submit();
            }

$( function() {
    $( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd' });
  } );
function switcher(){

window.location.href = 'users.php';
            }
function active(){
    document.getElementById("active").submit();
}
function deleteClicked(id)
{
        console.log(id);
    $('#myModal').data('id', id).modal('show');
	
}

function getXlsx(){
    
   
    
    
//console.log(collqry);
     $.ajax({
       // type:"POST",
        url:"ordersall_xlsx.php",
       // data:{from:from,to:to,query:qry, collqry:collqry},
        success:function(result){
           console.log(result);
            
               var len = result.length;
                var filename = result.slice(1,(len-1));
                console.log("filename = " + filename);
               $("#myModal3").modal('show');

$("#linkhere").html("<p><a href="+filename+">Download the Excel sheet here</a></p>");
            },
       error:function(){}
    });
}

$( function() {
    var from = $( "#from" )
        .datepicker({
          changeMonth: true,
          numberOfMonths: 1,
          dateFormat: 'yy-mm-dd',
        })
        .on( "change", function() {
          to.datepicker( "option", "minDate", getDate( this ) );
        }),
      to = $( "#to" ).datepicker({
        changeMonth: true,
        numberOfMonths: 1,
        dateFormat: 'yy-mm-dd',
      })
      .on( "change", function() {
        from.datepicker( "option", "maxDate", getDate( this ) );
      });

function getDate( element ) {
      var date;
      try {
        date = element.value;
      } catch( error ) {
  date = null;
      }

return date;
    }
  } );
        </script>
</body>