function get_delivery_status($status, $order_info) { //,notice_sn|get_notice_info=$deal_order['notice_id']:{%DELIVERY_SN} $order_items = unserialize($order_info['deal_order_item']); foreach ($order_items as $k => $v) { $order_item_ids[] = $v['id']; } if (!$order_item_ids) { $order_item_ids = 0; } else { $order_item_ids = implode(",", $order_item_ids); } $rs = $GLOBALS['db']->getAll("select dn.notice_sn,dn.id from " . DB_PREFIX . "delivery_notice as dn where dn.order_item_id in (" . $order_item_ids . ") "); $result = ""; foreach ($rs as $row) { $result .= "" . get_notice_info($row['notice_sn'], $row['id']) . "<br />"; } return L("ORDER_DELIVERY_STATUS_" . $status) . "<br />" . $result; }
function get_delivery_status($status, $order_id) { //,notice_sn|get_notice_info=$deal_order['notice_id']:{%DELIVERY_SN} $order_item_ids = $GLOBALS['db']->getOne("select group_concat(id) from " . DB_PREFIX . "deal_order_item where order_id = " . intval($order_id)); if (!$order_item_ids) { $order_item_ids = 0; } $rs = $GLOBALS['db']->getAll("select dn.notice_sn,dn.id from " . DB_PREFIX . "delivery_notice as dn where dn.order_item_id in (" . $order_item_ids . ") "); $result = ""; foreach ($rs as $row) { $result .= " " . get_notice_info($row['notice_sn'], $row['id']) . "<br />"; } return L("ORDER_DELIVERY_STATUS_" . $status) . "<br />" . $result; }