public static function getItemsTaxRecapitulation($oIdS = '')
{
$db = Factory::getDBO();
$wheres = array();
if ($oIdS != '') {
$wheres[] = 'a.order_id IN (' . $oIdS . ')';
}
$query = 'SELECT a.id, a.order_id, a.item_id, a.item_id_c, a.item_id_r, a.title, a.type, a.amount_netto, a.amount_tax, a.amount_brutto, a.amount_brutto_currency' . ' FROM #__phocacart_order_tax_recapitulation AS a';
if (!empty($wheres)) {
$query .= ' WHERE ' . implode(' AND ', $wheres);
}
$db->setQuery($query);
$items = $db->loadAssocList();
return $items;
}