Editing File: orders.php

<?include("iconnect.php")?>
<?
$pname="orders"; $pnamesub="";
$youarein1=""; $youarein1link="";
$youarein2=""; $youarein2link="";
$youarein3=""; $youarein3link="";
$youarein4=""; $youarein4link="";
$youarein5=""; $youarein5link="";
$youarein6=""; $youarein6link=""; 
$youarein7=""; $youarein7link="";
$youarein8=""; $youarein8link="";
$youareinname="Orders";
$mainheading="Orders";
$linkheading="Orders";
$subheading="";
$bodyheading="List of all Orders";
$mainheadingdesc="";
$addicon="No"; $pdficon="No"; $excelicon="No"; $modifyicon="Yes"; $modifytopicon="No"; $deleteicon="No";$priorityicon="No";
$linkname="orders";
$linknamepriority="priorityorders";
$linkquery1="";$linkquery2="";$linkquery3="";$linkquery4="";$linkquery5="";$linkquery6="";
$dropdown="Orders";
$dropdown1="orders";
$dropdown2=""; $dropdown3=""; $dropdown4=""; $dropdown4=""; $dropdown5=""; $dropdown6=""; $dropdown7="";
?>
<?include ("itophead.php")?> 
<?
$orders_tcount1=$obj->totalrecords_condition_nowhere('orders','*');
foreach($orders_tcount1 as $orders_row )
{
	$orders_tcount=$orders_row['count(*)'];
}
if($orders_tcount<>'0')	
{ 
?> 
<?include ("isubheading.php")?>  
<?include ("iaction.php")?> 
<div class="table-wrapper">
 <table id="datatable1" class="table display table-responsive nowrap">
  <thead>
   <tr>
    <th style="width:3%;">#</th>
    <th style="width:8%;">Order Code</th>
    <th style="width:8%;">Order Date</th>
    <th style="width:10%;">Items Ordered</th>
    <th style="width:15%;">Order Total  + Shipping (AED)</th>
    <th style="width:10%;">Guest / Member</th>
    <th style="width:15%;">Customer Name</th>
    <th style="width:15%;">Order Status</th>
    <th style="width:10%;">Payment Status</th>
    <th style="width:15%;">Actions</th>
   </tr>
  </thead>
  <tbody>
  
 <?
 $orders_orderby="ORDER BY ordercode desc";
 $orders_result=$obj->select_table_orderby("orderno",$orders_orderby);
 $count=0;
 foreach($orders_result as $orders_row){ 
  $count++;
  $ordercode = $orders_row["ordercode"];
  $customerno = $orders_row["customerno"];
  $orderdate = $orders_row["orderdate"];
  $orderdate=preg_split('[ ]',$orderdate); 
  $orderd= $orderdate[0];
  $ordert= $orderdate[1];
  $orderdatee = date("d-m-Y", strtotime($orderd));
  $orderstatus = $orders_row["orderstatus"];
  $orderamt = $orders_row["orderamt"];
  $deliverycharges = $orders_row["deliverycharges"];
  $memberno = $orders_row["memberno"];
  
  $despatchdate = $orders_row["despatchdate"];  
  $despatchdate = date("d-m-Y", strtotime($despatchdate));
  $deliverydate = $orders_row["deliverydate"];
  $deliverydate = date("d-m-Y", strtotime($deliverydate));
  
  $customer_where="customerno ='$customerno'";
  $customer_orderby="";
  $customer_result = $obj->select_all_values('customer', $customer_where, $customer_orderby);
  foreach($customer_result as $customer_row){
   $name=$customer_row["name"];
   $billingaddress=$customer_row["billingaddress"];
   $shippingaddress=$customer_row["shippingaddress"];
   $phone=$customer_row["phone"];
   $mobile=$customer_row["mobile"];	
   $email=$customer_row["email"];		
  }	  
 
  
 $orders_wherecondition = "ordercode =$ordercode";
 $orders_tcount1=$obj->totalrecords_condition('orders', '*', $orders_wherecondition);
 foreach($orders_tcount1 as $orders_row ){
  $orders_tcount=$orders_row['count(*)'];
 } 
  $toggleicon ="toggleicon".$count;
  $togglecontent ="togglecontent".$count;
  $toggleimg ="toggleimg".$count;
  
  
  $where="ordercode =$ordercode";
  $result_onlinepay = $obj->select_all_values('onlinepay', $where,'');
  foreach($result_onlinepay as $onlinepay_row){	
   $paymentmode= $onlinepay_row["paymentmode"];	
   $onlinepayno= $onlinepay_row["onlinepayno"];
   
  $onlinepg_wherecondition = "onlinepayno =$onlinepayno";
  $onlinepg_tcount1=$obj->totalrecords_condition('onlinepg', '*', $onlinepg_wherecondition);
  foreach($onlinepg_tcount1 as $onlinepg_row ){
   $onlinepg_tcount=$onlinepg_row['count(*)'];
  } 
  if($onlinepg_tcount<>0){
	 $onlinepgwhere="onlinepayno =$onlinepayno";
	 $result_onlinepg = $obj->select_all_values('onlinepg', $onlinepgwhere,'');
	 foreach($result_onlinepg as $onlinepg_row){	
	   $paystatus=$onlinepg_row["order_status"];
	 } 
  }
}  
?>
  <tr> 
    <td><?echo $count?></td>
    <td><?echo $ordercode?></td> 
    <td><?echo $orderdatee?></td>
    <td ><?echo $orders_tcount?></td>
    <td ><?echo number_format($orderamt, 2)?> + <?echo number_format($deliverycharges, 2)?></td>
    <td><?if ($memberno<>0){?>Member<? }else { ?>Guest<? } ?></td>
    <td>
    <span id="<?php echo $toggleicon?>"  data-toggle="collapse" data-target="#<?php echo $togglecontent?>"><i class="fa fa-plus tx-success tx-16-force" title="View Address" ></i></span>&nbsp&nbsp&nbsp
	<b><?echo $name?></b>	
  	 <div id="<?echo $togglecontent?>" class="collapse "><br>
		<p ><span  style="white-space: pre-wrap;"><b><u>Billing Address :</u></b><br><?echo $billingaddress?></span><br>
		<?if ($phone <>""){?><abbr title="Phone" style="border-bottom: 1px; line-height: 35px; "><i class="fa fa-phone " style="color:navy;"></i> </abbr> &nbsp; : &nbsp; <?echo $phone?><br><? } ?>
		<?if ($mobile <>""){?><abbr title="Mobile" style="border-bottom: 1px; line-height: 35px; "><i class="fa fa-mobile fa-lg" style="color:navy;"></i> </abbr> &nbsp; : &nbsp;  <?echo $mobile?><br><? } ?>
		<abbr title="Email" style="border-bottom: 1px; line-height: 35px;"><i class="fa fa-envelope"  style="color:navy;"></i> </abbr> &nbsp; : &nbsp;  <?echo $email?><br><br><span  style="white-space: pre-wrap;"><b><u>Shipping Address :</u></b><br><?echo $shippingaddress?></span></p>		
		</div>
     </td>		
    <? if($orderstatus == "Not Delivered") { ?>	
    <td><?echo $orderstatus?> &nbsp; &nbsp;  <a href="editorders.php?ordercode=<?echo $ordercode?>&pname=<?echo$pname?>&page=<?echo $fname?>"><i class="fas fa-edit" title="Modify Orders" ></i></a> <br><font color="#25292E">Order Date : <?echo $orderdatee?></font></td>	
    <? } else if($orderstatus == "Order Dispatched") { ?>	
   <td><?echo $orderstatus?> &nbsp; &nbsp;  <a href="editorders.php?ordercode=<?echo $ordercode?>&pname=<?echo$pname?>&page=<?echo $fname?>"><i class="fas fa-edit" title="Modify Orders" ></i></a> <br><font color="#25292E">Despatch Date : <?echo $despatchdate?></font></td>	
	<? } else { ?>		
    <td><?echo $orderstatus?> <br>Delivery Date : <?echo $deliverydate?></td>	
	<? } ?>		
    <td><?echo $paymentmode?> <br><? if($onlinepg_tcount<> 0) { ?>	<?echo $paystatus?><?}?></td>	
    <td class="table-action"><a title="View Orders" href="vieworders.php?ordercode=<?echo $ordercode?>&pname=<?echo$pname?>&page=<?echo $fname?>"><i class="fas fa-list-alt  tooltips"></i></a></td>
   </tr>
  <?}?>
   
  </tbody> 
 </table>
</div>	
<?}
else 
{ 
?>
<?include ("isubheadingempty.php")?>
<?include ("inodata.php")?>
<?}?>
<?include ("ibottom.php")?>

❌ Cancel