Netto-Brutto-Preise im Admin

Code: Select all

public function getTaxClasses

Code: Select all

$sql = "SELECT *  FROM ". DB_PREFIX ."tax_class
                        LEFT JOIN ". DB_PREFIX ."tax_rate
                        USING ( tax_class_id )";
			$sql .= " ORDER BY title";

Code: Select all

$query = $this->db->query("SELECT * FROM ". DB_PREFIX ."tax_class
                                        LEFT JOIN ". DB_PREFIX ."tax_rate
                                        USING ( tax_class_id )"); 

Code: Select all

 $this->data['entry_price'] = $this->language->get('entry_price');

Code: Select all

 $this->data['entry_usp'] = $this->language->get('entry_usp');

Code: Select all

	$this->load->model('localisation/tax_class');
		$this->data['tax_classes'] = $this->model_localisation_tax_class->getTaxClasses();

Code: Select all

$this->data['tax_rate'] = $this->model_localisation_tax_class->getTaxRates(@$product_info['tax_class_id']);
    $this->data['gross_price'] = '';
    if(isset($product_info['price'])) $this->data['gross_price'] = number_format(@$product_info['price'] * (1 + ($this->data['tax_rate'][0]['rate']/100)), 2, '.', ',');

Code: Select all

 <tr>
        <td><?php echo $entry_sort_order; ?></td>
        <td><input type="text" name="sort_order" value="<?php echo $sort_order; ?>" size="1" /></td>
      </tr>
 

Code: Select all

   <tr>
        <td><?php echo $entry_tax_class; ?></td>
        <td><select name="tax_class_id" id="tax_class_id" onchange="calc()">
            <?php foreach ($tax_classes as $tax_class) { ?>
            <?php if ($tax_class['tax_class_id'] == $tax_class_id) { ?>
            <option value="<?php echo $tax_class['tax_class_id']; ?>" selected="selected"><?php echo $tax_class['rate']; ?></option>
            <?php } else { ?>
            <option value="<?php echo $tax_class['tax_class_id']; ?>"><?php echo $tax_class['rate']; ?></option>
            <?php } ?>
            <?php } ?>
          </select></td>
      </tr>
<script language="JavaScript">
<!--
 function calc() {
  var feld_a = parseFloat(document.getElementById("tax_class_id").options[document.getElementById("tax_class_id").selectedIndex].text);
  var feld_b = parseFloat(document.getElementById("brutto").value);
  var res =  feld_b / (1 + ( feld_a / 100));
  document.getElementById("netto").value = res.toFixed(4);
}
-->
</script>
      <tr>
        <td><?php echo $entry_usp;?></td>
        <td><input type="text" name="brutto" id="brutto" value="<?php echo $gross_price; ?>" onchange="calc()" />
      </tr>
      <tr>
       <tr>
        <td><?php echo $entry_price; ?></td>
        <td><input type="text" name="price" id="netto" value="<?php echo $price; ?>" readonly="readonly" /></td>
      </tr>
  

Code: Select all

$_['entry_usp']              = 'Verkaufspreis:';

Code: Select all

public function getTaxClasses

Code: Select all

$sql = "SELECT *  FROM ". DB_PREFIX ."tax_class
                        LEFT JOIN ". DB_PREFIX ."tax_rate
                        USING ( tax_class_id )";
			$sql .= " ORDER BY title";

Code: Select all

$query = $this->db->query("SELECT * FROM ". DB_PREFIX ."tax_class
                                        LEFT JOIN ". DB_PREFIX ."tax_rate
                                        USING ( tax_class_id )"); 

Code: Select all

 $this->data['entry_price'] = $this->language->get('entry_price');

Code: Select all

 $this->data['entry_usp'] = $this->language->get('entry_usp');

Code: Select all

	$this->load->model('localisation/tax_class');
		$this->data['tax_classes'] = $this->model_localisation_tax_class->getTaxClasses();

Code: Select all

$this->data['tax_rate'] = $this->model_localisation_tax_class->getTaxRates(@$product_info['tax_class_id']);
    $this->data['gross_price'] = '';
    if(isset($product_info['price'])) $this->data['gross_price'] = number_format(@$product_info['price'] * (1 + ($this->data['tax_rate'][0]['rate']/100)), 2, '.', ',');

Code: Select all

 <tr>
        <td><?php echo $entry_sort_order; ?></td>
        <td><input type="text" name="sort_order" value="<?php echo $sort_order; ?>" size="1" /></td>
      </tr>
 

Code: Select all

   <tr>
        <td><?php echo $entry_tax_class; ?></td>
        <td><select name="tax_class_id" id="tax_class_id" onchange="calc()">
            <?php foreach ($tax_classes as $tax_class) { ?>
            <?php if ($tax_class['tax_class_id'] == $tax_class_id) { ?>
            <option value="<?php echo $tax_class['tax_class_id']; ?>" selected="selected"><?php echo $tax_class['rate']; ?></option>
            <?php } else { ?>
            <option value="<?php echo $tax_class['tax_class_id']; ?>"><?php echo $tax_class['rate']; ?></option>
            <?php } ?>
            <?php } ?>
          </select></td>
      </tr>
<script language="JavaScript">
<!--
 function calc() {
  var feld_a = parseFloat(document.getElementById("tax_class_id").options[document.getElementById("tax_class_id").selectedIndex].text);
  var feld_b = parseFloat(document.getElementById("brutto").value);
  var res =  feld_b / (1 + ( feld_a / 100));
  document.getElementById("netto").value = res.toFixed(4);
}
-->
</script>
      <tr>
        <td><?php echo $entry_usp;?></td>
        <td><input type="text" name="brutto" id="brutto" value="<?php echo $gross_price; ?>" onchange="calc()" />
      </tr>
      <tr>
       <tr>
        <td><?php echo $entry_price; ?></td>
        <td><input type="text" name="price" id="netto" value="<?php echo $price; ?>" readonly="readonly" /></td>
      </tr>
  

Code: Select all

$_['entry_usp']              = 'Verkaufspreis:';

Code: Select all

cache/cache.tax_class.....