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