0){
$my_best = mysqli_fetch_assoc($search_q1);
if($my_best['company_name'] == 'Energy Foods' && $my_best['varstatus']!='Cash'){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
echo "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'";
$sel_user = mysqli_query($conn, "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'");
$check_rows = mysqli_num_rows($sel_user);
if($check_rows > 0){
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
$name = $sel_users['name'];
$country = $sel_users['country'];
$state = $sel_users['state'];
$phone = $sel_users['phone'];
}else{
$name = $search['dif_name'];
$country = $search['contry'];
$state = $search['state'];
$phone = $search['dif_phone'];
}
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="90")
{
$status="Deleted";
$link = ''.$search_id.'';
}else{
$status = 'Unknown';
$link = $search_id;
}
$tr.='
'.$link.' | '.$name.' | '.$country.
' | '.$state.' | '.$phone.' | '.$search['order_date_time'].' | '.$status.' |
';
}
echo $tr;
}elseif($my_best['company_name'] == 'Energy Foods' && $my_best['varstatus']=='Cash'){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
echo "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'";
$sel_user = mysqli_query($conn, "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'");
$check_rows = mysqli_num_rows($sel_user);
if($check_rows > 0){
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
$name = $sel_users['name'];
$country = $sel_users['country'];
$state = $sel_users['state'];
$phone = $sel_users['phone'];
}else{
$name = $search['dif_name'];
$country = $search['contry'];
$state = $search['state'];
$phone = $search['dif_phone'];
}
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="90")
{
$status="Deleted";
$link = ''.$search_id.'';
}else{
$status = 'Unknown';
$link = $search_id;
}
$tr.=''.$link.' | '.$name.' | '.$country.
' | '.$state.' | '.$phone.' | '.$search['order_date_time'].' | '.$status.' |
';
}
echo $tr;
}elseif($my_best['company_name'] == 'Anbu Phaarmaa' && $my_best['varstatus']!='Cash'){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
echo "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'";
$sel_user = mysqli_query($conn, "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'");
$check_rows = mysqli_num_rows($sel_user);
if($check_rows > 0){
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
$name = $sel_users['name'];
$country = $sel_users['country'];
$state = $sel_users['state'];
$phone = $sel_users['phone'];
}else{
$name = $search['dif_name'];
$country = $search['contry'];
$state = $search['state'];
$phone = $search['dif_phone'];
}
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="90")
{
$status="Deleted";
$link = ''.$search_id.'';
}else{
$status = 'Unknown';
$link = $search_id;
}
$tr.=''.$link.' | '.$name.' | '.$country.
' | '.$state.' | '.$phone.' | '.$search['order_date_time'].' | '.$status.' |
';
}
echo $tr;
}elseif($my_best['company_name'] == 'Anbu Phaarmaa' && $my_best['varstatus']=='Cash'){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
echo "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'";
$sel_user = mysqli_query($conn, "select * from shop_user where user_id='$search[userid]' || phone='$search[dif_phone]'");
$check_rows = mysqli_num_rows($sel_user);
if($check_rows > 0){
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
$name = $sel_users['name'];
$country = $sel_users['country'];
$state = $sel_users['state'];
$phone = $sel_users['phone'];
}else{
$name = $search['dif_name'];
$country = $search['contry'];
$state = $search['state'];
$phone = $search['dif_phone'];
}
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="90")
{
$status="Deleted";
$link = ''.$search_id.'';
}else{
$status = 'Unknown';
$link = $search_id;
}
$tr.=''.$link.' | '.$name.' | '.$country.
' | '.$state.' | '.$phone.' | '.$search['order_date_time'].' | '.$status.' |
';
}
echo $tr;
}
}else{
echo 2;
}
}else{
$search_q = mysqli_query($conn, "SELECT * FROM tbl_confirmorder tb INNER JOIN shop_user su ON tb.userid = su.user_id WHERE su.phone like '%$search_id%' and tb.orderstatus!=10
union SELECT * FROM tbl_confirmorder tb INNER JOIN shop_user su ON tb.dif_phone = su.phone WHERE tb.dif_phone like '%$search_id%' and tb.orderstatus!=10
union SELECT * FROM tbl_confirmorder tb inner join shop_user su where tb.dif_phone like '%$search_id%' group by orid");
$search_rows = mysqli_num_rows($search_q);
if($search_rows > 0){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
//echo "select * from shop_user where user_id='$search[userid]' || phone='$search[phone]'".';
';
$sel_user = mysqli_query($conn, "select * from shop_user where phone='$search_id'");
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
if($search['company_name'] == 'Energy Foods' && $search['varstatus']!='Cash'){
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search['refid'].'';
}else{
$status = 'Unknown';
$link = $search['refid'];
}
}elseif($search['company_name'] == 'Energy Foods' && $search['varstatus']=='Cash'){
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search['refid'].'';
}else{
$status = 'Unknown';
$link = $search['refid'];
}
}elseif($search['company_name'] == 'Anbu Phaarmaa' && $search['varstatus']!='Cash'){
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search['refid'].'';
}else{
$status = 'Unknown';
$link = $search['refid'];
}
}elseif($search['company_name'] == 'Anbu Phaarmaa' && $search['varstatus']=='Cash'){
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search['refid'].'';
}else{
$status = 'Unknown';
$link = $search['refid'];
}
}
$tr.=''.$link.' | '.$sel_users['name'].' | '.$search['contry'].
' | '.$search['state'].' | '.$sel_users['phone'].' | '.$search['order_date_time'].' | '.$status.' |
';
}
echo $tr;
}else{
echo 2;
}
}
?>