query("SELECT count(*) as marked FROM `tbl_order_shopper` where order_id='$line->id' and shopper_status=0");
$shopperoderstatusres=$obj->fetchNextObject($shopperoderstatus);
if($shopperoderstatusres->marked==0){
echo '
Done
';
} else {
echo '
Not done
';
}
?>
Order Id: id);?>
Order Type: usps_expected_delivery == '' && $line->order_type !== 'Suburb' && $line->order_type !== 'Wholesale') { echo "Local";
} elseif ($line->order_type == 'UPS' || $line->usps_expected_delivery !== '') {
echo "UPS";
?>
order_type;
}
?>
Status: order_status);?>
Order Date: order_date));?>
Amount: total_amount, 2);?>
Stores:
query("SELECT storename FROM stores as a left join tbl_order_itmes as b on a.storeid=b.storeid where b.order_id='$line->id; ?>'");
$strarr = '';
while ($storeres = $obj->fetchNextObject($sqlstore)) {
$strarr[] = $storeres->storename;
}
$storearray = array_values(array_unique($strarr));
echo $storeList = implode(',', $storearray);
?>
Section:
id . "' group by tbl_order_itmes.section";
$sectiondetail = $obj->query($section_qry);
while ($sectionDetailRslt = $obj->fetchNextObject($sectiondetail)) {
$section = $sectionDetailRslt->section;
$storeids = $sectionDetailRslt->storeids;
if ($section == 'grocery') {
$grocery_delivery_partner = "SELECT
GROUP_CONCAT(DISTINCT tbl_store_zip.grocery_delivery_partner) grocery FROM tbl_store_zip WHERE
tbl_store_zip.zip = '" . $line->ship_pincode . "' AND tbl_store_zip.storeid IN( $storeids) group by tbl_store_zip.zip";
$grocery_delivery_partnerRslt = $obj->query($grocery_delivery_partner);
$grocery_partner = $obj->fetchNextObject($grocery_delivery_partnerRslt);
echo "(". ucwords($section . " / " . $grocery_partner->grocery) . "),";
} else if ($section != 'grocery') {
$food_delivery_partner = "SELECT GROUP_CONCAT( DISTINCT tbl_store_zip.food_delivery_partner) food
FROM tbl_store_zip
WHERE tbl_store_zip.zip = '" . $line->ship_pincode . "' AND
tbl_store_zip.storeid IN( $storeids)
group by tbl_store_zip.zip";
$food_delivery_partnerRslt = $obj->query($food_delivery_partner);
$food_partner = $obj->fetchNextObject($food_delivery_partnerRslt);
echo "(". ucwords($section . " / " . $food_partner->food) . "),";
}
}
?>
Make Order