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