MAINHACK

Viewing / Editing File: dashboard.php

<?php include 'header.php';
//include_once 'function_payout.php';
?>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">Dashboard</h4>
					
					</div>
			
					<div class="row">
						<div class="col-sm-6 col-md-3">
							<div class="card card-stats card-primary card-round">
								<div class="card-body ">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-3"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
												<p class="card-category">Today's Order</p>
												<h4 class="card-title">
					<?php $sq="select * from place_order where date='NOW()' group by order_id order by id desc ";
                     // echo $sq;
                        $r=$con->prepare($sq);
                        $r->execute();
                        echo $r->rowCount();
                            ?>
												</h4>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="col-sm-6 col-md-3">
							<div class="card card-stats card-info card-round">
								<div class="card-body">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-6"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
												<p class="card-category">My Orders</p>
												<h4 class="card-title">
					<?php $sq="select * from place_order group by order_id order by id desc ";
                     // echo $sq;
                        $r=$con->prepare($sq);
                        $r->execute();
                        echo $r->rowCount();
                            ?></h4>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="col-sm-6 col-md-3">
							<div class="card card-stats card-success card-round">
								<div class="card-body ">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-graph"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
												<p class="card-category">Menus</p>
												<h4 class="card-title">
					<?php $sq1="select count(*) as c from menu_items order by id desc ";
                     // echo $sq1;
                        $r1=$con->prepare($sq1);
                        $r1->execute();
                        $row1 = $r1->fetch(PDO::FETCH_ASSOC);
                        echo $row1['c'];
                            ?>								    
												</h4>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						<div class="col-sm-6 col-md-3">
							<div class="card card-stats card-secondary card-round">
								<div class="card-body ">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-success"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
												<p class="card-category">Revenue</p>
												<h4 class="card-title">
					<?php $sq2="select sum(total) as t from place_order order by id desc ";
                     // echo $sq;
                        $r2=$con->prepare($sq2);
                        $r2->execute();
                        $row2 = $r2->fetch(PDO::FETCH_ASSOC);
                        echo $row2['t'];        
                        ?> 
                            </h4>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
						<div class="row">
						<div class="col-sm-6 col-md-3">
							<div class="card card-stats card-danger card-round">
								<div class="card-body ">
									<div class="row">
										<div class="col-5">
											<div class="icon-big text-center">
												<i class="flaticon-interface-3"></i>
											</div>
										</div>
										<div class="col-7 col-stats">
											<div class="numbers">
												<p class="card-category">Comission</p>
												<h4 class="card-title">
				<?php $sq3="select sum(commission_amt) as com from sajh_comission order by id desc ";
                     // echo $sq;
                        $r3=$con->prepare($sq3);
                        $r3->execute();
                        $row3 = $r3->fetch(PDO::FETCH_ASSOC);
                        echo $row3['com'];        
                        ?> 
												</h4>
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
				<div class="row">
				    						<h4 class="page-title">Recent Orders</h4>

<div class="col-md-12">
							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					
							<table id="basic-datatables" class="display table table-striped table-hover">
							<thead>
                            <tr>  
                              <th>Sl</th>
                                <th>Order Time</th>
                                <th>Order No</th>
                                <th>Customer Name/Phone/Address</th>
                                <th>Maker/Name/Phone/Address</th>
                                <th>Amount</th>  
                                <th>Payment Mode</th> 
                                <th>Payment Status</th> 
                                <th>Delivery<br>Status</th> 
                            <th>Assign Now</th> 
                            <th>Show/Delete</th>
								</tr>
							</thead>
							   <tbody>

<?php

$count=1;

$date1=date("Y-m-d")." 00:00:00";
$date2=date("Y-m-d")." 23:59:59";

//$sq="select * from place_order where date between '$date1' and '$date2' and status!='paid'  group by order_id order by id desc ";
$sq="select * from place_order where date between '$date1' and '$date2' group by order_id order by id desc ";
$r=$con->prepare($sq);
$r->execute();
while($row = $r->fetch(PDO::FETCH_ASSOC)){
	//$status=$row['status'];
$pro_id=$row['order_id'];
$paym=$row['pay_status'];
$txid=empty($row['txid'])?"---":$row['txid'];

$sq1=$show->readwithdata('food_maker','maker_id',$row['maker_id']);
while($row1=$sq1->fetch(PDO::FETCH_ASSOC)){
$com_name=$row1['title'];
$maker_name=$row1['name'];
$mphone=$row1['phone'];
	    
	}
echo "	<tr>
								  <td>$count</td>
								  <td>".date('d-m-Y h:i A',strtotime($row['date']))."</td>
								  <td>".$row['order_id']."</td>
								  <td>".$row['client_name']."<br>".$row['email']."<br>".$row['phone']."<br>
								   <a href='map_client.php?add=".$row['address']."' target='_blank'>Show on Map</a>
                                    </td>
								  <td>".$com_name."<br>".$maker_name."<br>".$mphone."<br>
								  <a href='map_client.php?add=".$maker_address."' target='_blank'>Show on Map</a>
								  </td>
								  	<td>".$row['amount']."</td>

<td>".$paym."</td>
								    <td>".$txid."</td>
									";
									?>
								<td>
                                         <script>
                                function status(Value){
									//alert(Value);
								var st="#status"+Value;
                                var id_txt="#id"+Value;
                                
								var status=$(st).val();
                                var id=$(id_txt).val();	
								var table='place_order';
                               
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "order_status="+status+"&id="+id+"&table="+table,
                                async: false,
                                global: false,
								 beforeSend: function(){
								/* Show image container */
								$("#loader").show();
							   },
                                success: function(result)
                                { 
								  $( "#basic-datatables" ).load( "all_bill.php #basic-datatables" );
                                //window.location.reload();

//table.ajax.reload();

}
								
                                });
                                }
                                </script>			   
						   
						     	<?php 
						     	$interests = array('NOT DELIVERED','DELIVERED'); 
?>
						<select name="status" onchange="status(<?=$count;?>)"   id="status<?=$count;?>">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['order_status']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>	  
<input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
                         
						 
<div id='loader' style='display: none;'>
  <img src='loader.gif' width='32px' height='32px'>
</div>                          
                                </td>

<td>
                                         <script>
                                function assign(Value){
									//alert(Value);
								var as="#assign"+Value;
                                var id_txt="#id"+Value;
                                
								var assign=$(as).val();
                                var id=$(id_txt).val();	
								var table='place_order';
                               //alert(id);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "assign="+assign+"&id="+id+"&table="+table,
                                async: false,
                                global: false,
								 beforeSend: function(){
								/* Show image container */
								$("#loader").show();
							   },
                                success: function(result)
                                { 
								  $( "#basic-datatables" ).load( "assign_now.php #basic-datatables" );
                                //window.location.reload();

//table.ajax.reload();

}
								
                                });
                                }
                                </script>			   
						   
                            <select  onchange="assign(<?=$count;?>)"   id="assign<?=$count;?>"  name="assign" class="form-control" >
                            <option value="">Assign Now</option>
                            <?php  
                            $table1='delivery_agent';
                            $stmt1=$show->readAll($table1);
                            $num1=$stmt1->rowCount();
                            if($num1>0){
                            while($row1=$stmt1->fetch(PDO::FETCH_ASSOC)){
                            
                            echo "<option value='".$row1['agent_id'].":".$row1['name'].":".$row1['phone']."'";if($row1['agent_id']==$row['agent_id']) echo "selected"; echo">".$row1['name']."|".$row1['delivery_upto']."</option>";	}
                            
                            }
                            
                            ?>
                            </select>	 

<div id='loader' style='display: none;'>
  <img src='loader.gif' width='32px' height='32px'>
</div>
  </td>
	
									<?php
									echo"
								   <td><a href='bill_final.php?uid=".base64_encode($row['user_id'])."&bid=".base64_encode($pro_id)."' target='_blank'class='btn btn-secondary btn-xs'>Show Bill</a>
								  <a href='#' class='btn btn-danger btn-xs' onclick='return send();'>Delete</a>
								 </td>
								</tr>";

++$count;
								}

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

</div>

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

<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: dashboard.php

Server Info

System Features

User Info