/**
* Load price from prices subtable
* @param mixed
* @param DataContainer
* @return mixed
*/
public function load($varValue, \DataContainer $dc)
{
$objPrice = \Database::getInstance()->query("SELECT t.id, p.id AS pid, p.tax_class, t.price FROM " . ProductPrice::getTable() . " p LEFT JOIN tl_iso_product_pricetier t ON p.id=t.pid AND t.min=1 WHERE p.pid={$dc->id} AND p.config_id=0 AND p.member_group=0 AND p.start='' AND p.stop=''");
if (!$objPrice->numRows) {
$objTax = TaxClass::findFallback();
return array('value' => '0.00', 'unit' => null === $objTax ? 0 : $objTax->id);
}
return array('value' => $objPrice->price, 'unit' => $objPrice->tax_class);
}
/**
* Load default values for the DCA
*/
public function initializeDCA()
{
// Set default tax class
$GLOBALS['TL_DCA']['tl_iso_product_price']['fields']['tax_class']['default'] = (int) \Isotope\Model\TaxClass::findFallback()->id;
}
