public function retrieveOrdersItemsDetail($order_type, $orders_items_id)
{
$result = array();
$query = '';
if ($order_type == self::ORDER_TYPE_SP) {
$query = $this->queryOrdersItemsDetailSP($orders_items_id);
} elseif ($order_type == self::ORDER_TYPE_JG) {
$query = $this->queryOrdersItemsDetailJG($orders_items_id);
} elseif ($order_type == self::ORDER_TYPE_DP) {
$query = $this->queryOrdersItemsDetailDP($orders_items_id);
}
//die($query);
if ($query != '') {
$res = tep_db_query($query);
if (tep_db_num_rows($res) > 0) {
$result = tep_db_fetch_array($res);
if ($order_type == self::ORDER_TYPE_DP) {
use_class('depot_orders');
$class_do = new depot_orders();
$temp_result = $class_do->translateOrdersForSP(array(0 => $result));
$result = array_merge($result, $temp_result[$result['depot_orders_id']]);
}
}
}
return $result;
}