Ele57885fddfgdfgfghgقفغفغفقhfg555434536

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

<?php

include 'db.php';

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

if(isset($_GET['cid1']))
   {

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

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

$insert = $db->query("update cust set approve='Your Product Delivered' where order_id=$cid1");
         
         
         
         
        $insert=$db->query("update customer_order SET approve='Your Product Delivered' where tr_id='$cid1'");
         
         
         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 = AAAA8gPD8DE:APA91bHQGZEPo-3fyqziu8wohguUwThblHoNpimvRG_gWzWPd59QT5iNsHuVFUZMMoxoNv9bkvuFSkTq5XIWHjx4ITeUAmStHOuSjGY9zhK2NIQt0dUhyIU7o3R3qU6Ga_SWF3wbCxOj',
		'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","lulusmart1234_2022","lulusmart1234_2022","lulusmart1234_2022") or die("Error connecting");

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

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

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

$name9 = $orderData[1];  
 $cnt = $orderData[2];       
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
     $message1 = "Your Product Delivered";
    
     
     
     
     $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);
     header("Location:Customermgtorderamntview4.php");
     
     
     
     
     
     
     
     
     
     
     
     
   
   
   
   
   
   
   
   
      
   }   
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
		);

$conn = mysqli_connect("localhost","lulusmart1234_2022","lulusmart1234_2022","lulusmart1234_2022") or die("Error connecting");

//$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='Customermgtorderamntview4.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>Order Approve 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>Order Reschedule Management</h1>
                  <small>Order Reschedule 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>Order Reschedule 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>No of Orders</th>
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                       <th>Customer Name</th>
                                       <th>Phone No</th>
                                       <th>Email</th>
                                       
                                        <th>Address</th>
                                       <th>Town</th>
                                       <th>Pincode</th>
                                       <th>Total Order Value</th>
                                      
                                       <th>Status</th>
                                       <th>Requirement</th>
                                       <th>Delivery Time</th>
                                       <th>Delivery Name</th>
                                        <th>Delivery</th>
                                        
                                         <th>Mobile View Delivery Charge</th>
                                        
                                        <th>Reject</th>

<th>Delivery Charge</th>

<th>view</th>
                                         <th>Print</th>
                                       
                                      
                                       
                                    </tr>
                                 </thead>
                                 <tbody>

<?php 
$ret=mysqli_query($db,"select * from cust where status='Credit' and approve='Your Product Approveamwt' and amntwt <> ''");
while($row=mysqli_fetch_array($ret))

{

$order_id =$row['order_id'];

$uid =$row['uid'];
   
   
   
   
   
   
   
   
   
   
   $name2 =$row['name2'];
   $nameamnt =$row['nameamnt'];
   $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];

$orderItemSqlamntwt = "SELECT id,name2 FROM p124 WHERE name3 ='$nameamnt'";
  
     
 $orderItemResultamntwt = $db->query($orderItemSqlamntwt);
 
 
 
 
 
$orderResultamntwt = $db->query($orderItemSqlamntwt);
$orderDataamntwt = $orderResultamntwt->fetch_array();

$qunt2= $orderDataamntwt[1];

?>
                                    <tr>
                                       <td><?php echo $row['dantime'];?></td>
                                       <td><?php echo $row['order_id'];?></td>
                                        <td><?php echo $qunt;?></td>
                                       <td><?php echo $row['name'];?></td>
                                        <td><?php echo $row['phonenumr'];?></td>
                                        
                                        
                                        <td><?php echo $row['email'];?></td>
                                       <td><?php echo $row['address'];?></td>
                                    
                                        <td><?php echo $row['town'];?></td>
                                         <td><?php echo $row['pincode'];?></td>
                                         
                                       <td><?php echo $row['cnt'];?></td>
                                      
                                       
                                       
                                       
                                        <td><?php echo $row['approve'];?></td>
                                        <td><?php echo $row['nameamwt'];?></td>
                                         <td><?php echo $row['amwt'];?></td>
                                         <td><?php echo $qunt2;?></td>

<td>
                                          <a type="button"  href="Customermgtorderamntwtview4.php?cid1=<?php echo $row['order_id'];?>&cid2=<?php echo $row['cnt'];?>" class="btn btn-success">Delivery</a>
                                       </td>
                                       
                                        <td>
                                          <a type="button"  href="salesorerviewamwt.php?cid=<?php echo $row['order_id'];?>&cid1=<?php echo $row['cnt'];?>">Mobile View</a>
                                       </td>
                                       
                                        <td>
                                          
                                        <a type="button" href="Customermgtorderamntwtview4.php?cid9=<?php echo $row['order_id'];?>" class="btn btn-danger">Reject</a>
                                        
                                       </td>
                                       
                                       <td>
                                          <a type="button"  href="salesorerview.php?cid=<?php echo $row['order_id'];?>&cid1=<?php echo $row['cnt'];?>">View</a>
                                       </td>
                                       
                                       <td>
                                          <a type="button"  href="Customermgtorderamntwtview5.php?cid=<?php echo $row['order_id'];?>&cid1=<?php echo $row['cnt'];?>">View</a>
                                       </td>
                                       
                                      
                                       
                                        <td>
                                          <a type="button"  href="Print_Order.php?cid=<?php echo $row['order_id'];?>" class="btn btn-success">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"
    } );
} );
      </script>

</html>