Google

Edit File: event_orders.php

<?php include 'session.php';
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");
}

?>
<?php
$order_id = $_GET['order_id'];
$event_id = $_GET['event_id'];
$eventqry = "select * from event where event_id = '$event_id'";
 if(!$resultqry = $db1->db->query($eventqry)){
               die('There was an error running the query [' . $db->db->error . ']');
                                                                        }
  $ro = $resultqry->fetch_assoc();
  $event_name = $ro['event_name'];
  $event_id = $ro['event_id'];

$orderqry = "select * from orders where order_id = '$order_id'";
  if(!$resultqry1 = $db1->db->query($orderqry)){
               die('There was an error running the query [' . $db->db->error . ']');
                                                                        }
 $row_order = $resultqry1->fetch_assoc();
 $hall_no = $row_order['hall_number'];
 $table_no = $row_order['table_no'];
 $name =  $row_order['name'];
 $email = $row_order['email'];
 $phone = $row_order['phone'];

$service_charge = $row_order['service_charge'];
 $amount = $row_order['amount'] - $row_order['service_charge'];
 $total_amount = $amount + $row_order['service_charge'];
// echo $total_amount ;
 $place_at = $row_order['created_dt'];
 $user_served_at = $row['user_served_at'];
 $merchant_assigned = $row['merchant_assigned_at'];
 $merchant = $row['merchant_served_at'];

<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>Event Order Details</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">
            #events_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" style="background-color:white";>
					
							<br>				
                                                    
					     <h4> Order Id:  <?php echo $order_id ; ?> </h4>
                                           
                                            <p><b>Hall No : </b><?php echo $hall_no  ;?> </p>
                                            <p><b>Stall No : </b><?php echo $table_no ; ?></p>
                                            <p><b>Name : </b><?php echo $name ; ?> </p>
                                            <p><b>Email : </b><?php echo $email ; ?> </p>
                                            <p><b>Phone :</b><?php echo $phone  ; ?> </p>
                                            <p><b> Amount :</b> <?php echo $amount ; ?> &nbsp;&nbsp;&nbsp;  <b> Service Charge :</b> <?php echo $service_charge ; ?> &nbsp;&nbsp;&nbsp; <b>Total Amount : </b><?php echo $total_amount ; ?>  </p>

<p><b>Placed At :</b><?php echo $place_at ; ?> &nbsp;&nbsp;&nbsp; <b>Merchant Assigned At :</b><?php echo $merchant_assigned ; ?> &nbsp;&nbsp;&nbsp; <b>Merchant Closed  At :</b><?php echo $merchant_served_at; ?>  </p>

</div>

<div id="myModal1" 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">&times;</button>
                            <h3 id="myModalLabel"></h3>
                        </div>
                        <div class="form-group col-sm-10 col-sm-offset-2" align="center">
			   <form  action="" method ="post">
	 <div class="form-group" id ="form1">
      <label class="control-label" for="name">Event Id:</label>
      <input type="text" class="form-control" id="event_id" placeholder="Id" name="event_nameid" >
    </div>		   
    <div class="form-group" id ="form1">
      <label class="control-label" for="name">Event Name:</label>
      <input type="text" class="form-control" id="name_id" placeholder="Name" name="event_name" >
    </div>
  
    
   <br>
  
    <button type="submit" name="event_edit" class="btn btn-default col-sm-12" style="width:50%;">Submit</button>
	<br><br><br><br><br><br>
	
	
  </form>
  </div>
   </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>Order Id</th>
                                                                                      <th>Item Id </th>
                                                                                      <th>Item Name</th>
                                                                                       <th>Quantity</th>
                                                                                      <th>Price </th>
                                                                                     <th>Total</th>      
										
										
									
										
							            </tr>
									</thead>
									<tbody>

<?php
								    $accQry3 = "select * from orders left join order_items on orders.order_id = order_items.order_id where orders.order_id ='$order_id'";
								//	$result1 = mysql_query($accQry, $db1->conn) ;
                                                    if(!$result3 = $db1->db->query($accQry3)){
                                                                  die('There was an error running the query [' . $db->db->error . ']');
                                                                        }
									$i = 1;
								     while ($row = $result3->fetch_assoc()) {

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

$('#myModal .modal-body p').html("Desea eliminar al usuario " + '<b>' + tit +'</b>' + ' ?');
var id = $(this).data('id'),
removeBtn = $(this).find('.danger');
})

$('.confirm-delete').on('click', function(e) {
e.preventDefault();

var id = $(this).data('id');
$('#myModal').data('id', id).modal('show');

});

function myFunction(event_id,event_name)
 {
	  	  
	   	document.getElementById("event_id").value=event_id;
	      document.getElementById("name_id").value=event_name;
	      
	      $('#myModal1').modal('show');
	    // document.getElementById("merchant_id").style.display="none";
	     // document.getElementById("form2").style.display="none";
	      
   }

function getXlsx(){

var event_id2 = "<?php echo $event_id ; ?>";

//console.log(collqry);
     $.ajax({
        type:"POST",
        url:"ordersall2_xlsx.php",
        data:{event_id3:event_id2},
        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(){}
    });
}

</script>
</body>