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; } } ?>