$orders="active";
$caller1="open";
$dis="active";
require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
session_start();
?>
S.no |
Orderid |
Date and Time |
Name |
State |
Mobile No |
Order Status |
Invoice No |
View |
query($Query);
$nsssss=mysql_num_rows($namesss);
$manssss='0';
while ($rowsss = mysql_fetch_array($namesss)) {
$userid =$rowsss['userid'];
$orderid=$rowsss['orderid'];
$orderstatus =$rowsss['orderstatus'];
$Query = "SELECT * from `shop_user` where user_id='$userid' ";
$name=$DB->query($Query);
$no=mysql_num_rows($name);
$row = mysql_fetch_array($name);
$new_status=$row['new_status'];
$Query_oo = "SELECT * from `tbl_order` where orderid='$orderid' ";
$name_oo=$DB->query($Query_oo);
$no_oo=mysql_num_rows($name_oo);
if($no_oo>0)
{
if($new_status==1)
{
if($orderstatus==0)
{
$par_status="Placed";
}
if($orderstatus==1)
{
$par_status="Confirmed";
}
if($orderstatus==2)
{
$par_status="Dispatched";
}
if($orderstatus==3)
{
$par_status="Delivered";
}
//sprintf("%02d", $to_hour);
?>
echo $nsssss;?> |
echo $rowsss['refid'];?> |
echo $rowsss['order_date_time'];?> |
echo $row['name'];?> |
echo $rowsss['state'];?> |
echo $row['phone'];?> |
echo $par_status;?>
|
echo $rowsss['type'];?>
|
View
|
$nsssss=$nsssss-1;
}
}
}
?>