Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php

include 'db.php';

$name = date("d-m-Y");

?>
    <?php
    include 'db.php';
    
 if(isset($_GET['cid1']))
   {

$cid=intval($_GET['cid1']);

mysqli_query($db,"delete from p12 where id='$cid1'");

header("Location:Customer_mgtview.php");
   }  
    if(isset($_GET['cid7']))
   {

$cidamnt=intval($_GET['cid7']);
   $str=$db->query("update cust SET approve='Your Product Approve' where order_id='$cidamnt'");
   
	$str2=$db->query("update customer_order SET approve='Your Product Approve' where tr_id='$cidamnt'");
	
	
	
	
	
	
	
	
	
	
	 function send_notification ($tokens, $message, $message1)
{

$msg = array
	(
		'body' 	=> "$message",
		'title'		=> "$message1",
		'sound' => 'sample.mp3',
	     	'android_channel_id' => '9192',

);
	
	$fields = array
	(
		'registration_ids' 	=> $tokens,
		'notification'			=> $msg
		);

$headers = array(
	'Authorization:key = AAAATGtkcv8:APA91bHXGG3c2lyxtH1dPDL4vwcQUCp9_Z4F_oru3kKh90cor2irJ-aqbiX-klUxxbD0Exh3fsMDyOmQdT8PtINyTRnViNT9gTW7vM-cAMlxSOYF4w-_mg09zdoIDmUMem8_4-AAGiaN',
		'Content-Type: application/json'
		);

$ch = curl_init();
	curl_setopt($ch, CURLOPT_URL, 'https://fcm.googleapis.com/fcm/send');
	curl_setopt($ch, CURLOPT_POST, true);
	curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
	curl_setopt ($ch, CURLOPT_SSL_VERIFYHOST, 0);  
	curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
	curl_setopt($ch,CURLOPT_IPRESOLVE,CURL_IPRESOLVE_V4);
	curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($fields));
	$result = curl_exec($ch);           
	if ($result === FALSE) {
		die('Curl failed: ' . curl_error($ch));
	}
	curl_close($ch);
	return $result;
}
	
	
	
	
$conn = mysqli_connect("localhost","skoolzone_buy-needs-2021","skoolzone_buy-needs-2021","skoolzone_buy-needs-2021") or die("Error connecting");

//$message = "The  ".$name. " Mark has been uploaded successfully.";

$orderItemSql = "SELECT id,phonenumr,cnt FROM cust WHERE order_id='$cidamnt'";
     
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);
$orderData = $orderResult->fetch_array();

$name9 = $orderData[1];  
 $cnt = $orderData[2];       
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
     $message1 = "Your Order is Accepted";
    
     
     
     
     $message="Total:  ".$cnt. "";

//$values=implode(",",$_POST["mob"]);
$sql = "SELECT * FROM devices where email='$name9'";

$result = mysqli_query($conn,$sql);
	
	$tokens = array();

if(mysqli_num_rows($result) > 0 ){

while ($row = mysqli_fetch_assoc($result)) {
			$tokens[] = $row["Token"];
		}
	}
	mysqli_close($conn);
//Checking post request

$message_status = send_notification($tokens,$message,$message1);
	$result = json_decode($message_status);

echo "<script>document.location='Customermgtorderview2.php'</script>";	
}
if(isset($_GET['cid9']))
   {

$cidawnt=intval($_GET['cid9']);   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   $str=$db->query("update cust SET approve='Your Product Reject' where order_id='$cidawnt'");

$str=$db->query("update customer_order SET approve='Your Product Reject' where tr_id='$cidawnt'");
             
             
             
             
             
             
             
             
             
             
             
             
             
           function send_notification ($tokens, $message, $message1)
{

$msg = array
	(
		'body' 	=> "$message",
		'title'		=> "$message1",
	
	'sound' => 'sample.mp3',
	
	
	     	'android_channel_id' => '9192',
		);
	
	$fields = array
	(
		'registration_ids' 	=> $tokens,
		'notification'			=> $msg
		);

//$message = "The  ".$name. " Mark has been uploaded successfully.";

$orderItemSql = "SELECT id,phonenumr,cnt FROM cust WHERE order_id='$cidawnt'";
     
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);
$orderData = $orderResult->fetch_array();

$name9 = $orderData[1];  
 $cnt = $orderData[2];       
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
     $message1 = "Your Order is Rejected";
    
     
     
     
     $message="Total:  ".$cnt. "";

//$values=implode(",",$_POST["mob"]);
$sql = "SELECT * FROM devices where email='$name9'";

$result = mysqli_query($conn,$sql);
	
	$tokens = array();

if(mysqli_num_rows($result) > 0 ){

while ($row = mysqli_fetch_assoc($result)) {
			$tokens[] = $row["Token"];
		}
	}
	mysqli_close($conn);
//Checking post request

$message_status = send_notification($tokens,$message,$message1);
	$result = json_decode($message_status);  
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
      echo "<script>document.location='Customermgtorderfileview4.php'</script>";	
}
   ?>
  
 
<!DOCTYPE html>
<html lang="en">
   

<head>
      <meta charset="utf-8">
      <meta http-equiv="X-UA-Compatible" content="IE=edge">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <title>Cancelled Order Management</title>
      
      <link rel="shortcut icon" href="assets/dist/img/ico/favicon.png" type="image/x-icon">
      
      
      <link href="assets/plugins/jquery-ui-1.12.1/jquery-ui.min.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
      
      
      
      <link href="assets/plugins/lobipanel/lobipanel.min.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/plugins/pace/flash.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/pe-icon-7-stroke/css/pe-icon-7-stroke.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/themify-icons/themify-icons.css" rel="stylesheet" type="text/css"/>
      
      <link href="assets/plugins/datatables/dataTables.min.css" rel="stylesheet" type="text/css"/>
      
      
      
      <link href="assets/dist/css/stylecrm.css" rel="stylesheet" type="text/css"/>

</head>
   <body class="hold-transition sidebar-mini">

<?php include('include/header.php'); ?>

<div class="content-wrapper">
            
            <section class="content-header">
               <div class="header-icon">
                  <i class="fa fa-users"></i>
               </div>
               <div class="header-title">
                  <h1>Cancelled Order Management</h1>
                  <small>Cancelled Order List</small>
               </div>
            </section>
            
            <section class="content">
               <div class="row">
                  <div class="col-sm-12">
                     <div class="panel panel-bd lobidrag">
                        <div class="panel-heading">
                           <div class="btn-group" id="buttonexport">
                              <a href="#">
                                 <h4>Cancelled Order Management</h4>
                              </a>
                           </div>
                        </div>
                        <div class="panel-body">
                       
   
                           <div class="table-responsive">
                              <table id="example" class="display" style="width:100%" border="1">
                                 <thead >
                                    <tr class="info">
                                        <th>Date</th>
                                        
                                       <th>Order No</th>
                                       
                                       
                                       
                                       <th>Customer Name</th>
                                       
                                       
                                       
                                      <th>Total</th>
                                      
                                      <th>Payment</th>
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                        
                                         
                                          
                                        
                                        <th>View</th>
                                        
                                        <th>Invoice</th>
                                        
                                        <th>Order Copy</th>
                                        
                                        <th>Delivery Label</th>

</tr>
                                 </thead>
                                 <tbody>

<?php 
$ret=mysqli_query($db,"select * from cust where status='Success' and approve='Your Product Reject' order by order_id desc");
while($row=mysqli_fetch_array($ret))

{

$order_id =$row['order_id'];

$uid =$row['uid'];
   
   
   
   
   
   
   
   
   
   
   $name2 =$row['name2'];
   $orderItemSql = "SELECT id,count(order_id) FROM cust WHERE order_id <= $order_id and uid = '$uid' and approve <> '' and approve <> 'Your Product remove' and approve <> 'Your Product Reject'";
  
     
 $orderItemResult = $db->query($orderItemSql);
 
 
 
 
 
$orderResult = $db->query($orderItemSql);
$orderData = $orderResult->fetch_array();

$qunt= $orderData[1];

?>
                                    <tr>
                                       <td><?php echo $row['dantime'];?></td>
                                       
                                       <td><?php echo $row['order_id'];?></td>
                                    
                                       
                                       
                                       
                                        
                                        <td><?php echo $row['name'];?><br><?php echo $row['phonenumr'];?><br><?php echo $row['email'];?></td>
                                        
                                        
                                        
                                        
                                         
                                       
                                       
                                       <td><?php echo $row['cnt'];?></td>
                                       
                                      
                                       
                                       
                                        <td><?php if($row['payment']=="cashpay"){?>COD <?php } else {?>Online Payment<?php } ?></td>

<?php if($row['payment']=="cashpay"){?>
                                          
                                          <td> <a type="button"  href="Customermgtorderview5.php?cid=<?php echo $row['order_id'];?>&cid1=<?php echo $row['cnt'];?>"><span class="label-success label label-default pull-left">View</span></a></td>
                                          
                                        <?php } else {?>  
                                        
                                          <td> <a type="button"  href="Customermgtorderapproveview5.php?cid=<?php echo $row['order_id'];?>&cid1=<?php echo $row['cnt'];?>"><span class="label-success label label-default pull-left">View</span></a></td>
                                          
                                          <?php } ?>
                                          
                                          
                                          <td>
                                          <a type="button"  href="invoice-bill.php?cid=<?php echo $row['order_id'];?>" class="label-success label label-default pull-left">Print</a>
                                       </td>
                                       
                                       
                                     <td>
                                          <a type="button"  href="print.php?cid=<?php echo $row['order_id'];?>" class="label-success label label-default pull-left">Print</a>
                                       </td>
                                       
                                        
                                       
                                       
                                       
                                       
                                       <td><a class="label-success label label-default pull-left" href="delivery-print.php?cid=<?php echo $row['order_id'];?>">Print</a></td>
                                       
                                       
                                    </tr>

<?php } ?> 
                                    
                                 </tbody>
                              </table>
                           </div>
                        </div>
                     </div>
                  </div>
               </div>
               
               <div class="modal fade" id="customer1" tabindex="-1" role="dialog" aria-hidden="true">
                  <div class="modal-dialog">
                     <div class="modal-content">
                        <div class="modal-header modal-header-primary">
                           <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                           <h3><i class="fa fa-user m-r-5"></i> Update Enquiry</h3>
                        </div>
                        <div class="modal-body">
                           <div class="row">
                              <div class="col-md-12">
                                 <form class="form-horizontal">
                                    <fieldset>
                                       
                                       <div class="col-md-4 form-group">
                                          <label class="control-label">Name of the Student:</label>
                                          <input type="text" placeholder="Name of the Student" class="form-control">
                                       </div>
                                       
                                       <div class="col-md-4 form-group">
                                          <label class="control-label">Name of the Parent:</label>
                                          <input type="text" placeholder="Name of the Parent" class="form-control">
                                       </div>
                                       
                                       <div class="col-md-4 form-group">
                                          <label class="control-label">Course/Class</label>
                                          <input type="text" placeholder="Course/Class" class="form-control">
                                       </div>
                                       <div class="col-md-6 form-group">
                                          <label class="control-label">Date of Enqiry</label><br>
                                          <input type="date" placeholder="Date of Enqiry" class="form-control">
                                       </div>
                                       <div class="col-md-6 form-group">
                                          <label class="control-label">Expected Date of Joining</label>
                                          <input type="text" placeholder="Expected Date of Joining" class="form-control">
                                       </div>
                                        <div class="col-md-6 form-group">
                                          <label class="control-label">How do you know about Our School</label>
                                          <input type="text" placeholder="How do you know about Our School" class="form-control">
                                       </div>
                                        <div class="col-md-6 form-group">
                                          <label class="control-label">Incharge Staff</label>
                                          <input type="text" placeholder="Incharge Staff" class="form-control">
                                       </div>

<div class="col-md-6 form-group">
                                          <label class="control-label">Staff Code</label>
                                          <input type="text" placeholder="Staff Code" class="form-control">
                                       </div>
                                       <div class="col-md-12 form-group user-form-group">
                                          <div class="pull-right">
                                             <button type="button" class="btn btn-danger btn-sm">Cancel</button>
                                             <button type="submit" class="btn btn-add btn-sm">Save</button>
                                          </div>
                                       </div>
                                    </fieldset>
                                 </form>
                              </div>
                           </div>
                        </div>
                        <div class="modal-footer">
                           <button type="button" class="btn btn-danger pull-left" data-dismiss="modal">Close</button>
                        </div>
                     </div>
                     
                  </div>
                  
               </div>
               
                   
               
               <div class="modal fade" id="customer2" tabindex="-1" role="dialog" aria-hidden="true">
                  <div class="modal-dialog">
                     <div class="modal-content">
                        <div class="modal-header modal-header-primary">
                           <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                           <h3><i class="fa fa-user m-r-5"></i> Delete Customer</h3>
                        </div>
                        <div class="modal-body">
                           <div class="row">
                              <div class="col-md-12">
                                 <form class="form-horizontal">
                                    <fieldset>
                                       <div class="col-md-12 form-group user-form-group">
                                          <label class="control-label">Delete Customer</label>
                                          <div class="pull-right">
                                             <button type="button" class="btn btn-danger btn-sm">NO</button>
                                             <button type="submit" class="btn btn-add btn-sm">YES</button>
                                          </div>
                                       </div>
                                    </fieldset>
                                 </form>
                              </div>
                           </div>
                        </div>
                        <div class="modal-footer">
                           <button type="button" class="btn btn-danger pull-left" data-dismiss="modal">Close</button>
                        </div>
                     </div>
                     
                  </div>
                  
               </div>
               
            </section>
            
         </div>

<?php include('include/footer.php'); ?>
      </div>
        
      
      
      <script type="text/javascript">
         $(document).ready(function() {
    $('#example').DataTable( {
       // "pagingType": "full_numbers"
       order: [[1, 'desc']],
        lengthMenu: [ [10, 25, 50, 100], [10, 25, 50, "100"] ],
       pageLength: 100
    } );
} );

</script>

</html>