projekt kivitendo

                (SELECT i.warehouse_id, p.warehouse_id

                 FROM inventory i, parts p

                 OR    p.bin_id = b.id

    $filter .= qq| AND (inventory_accno_id is not NULL or assembly=TRUE)|;

    qq|SELECT id, partnumber, description, ean, | .

    qq|       warehouse_id, bin_id | .

    warehouse_id                        => { type => 'integer' },

    bin_id                              => { type => 'integer' },

  foreign_keys => [

    bin => {

      class       => 'SL::DB::Bin',

      key_columns => { bin_id => 'id' },

    },

    warehouse => {

      class       => 'SL::DB::Warehouse',

      key_columns => { warehouse_id => 'id' },

    },

  ],

    warehouse_id       => { type => 'integer' },

    bin_id             => { type => 'integer' },

    bin => {

      class       => 'SL::DB::Bin',

      key_columns => { bin_id => 'id' },

    },

    warehouse => {

      class       => 'SL::DB::Warehouse',

      key_columns => { warehouse_id => 'id' },

    },

         doi.sellprice, doi.parts_id AS id, doi.unit, doi.discount, p.notes AS partnotes,

         warehouse_id = ?,

         bin_id = ?,

             conv_i($form->{warehouse_id}),

             conv_i($form->{bin_id}),

              p.onhand, p.rop,

#   l_partnumber l_description l_listprice l_sellprice l_lastcost l_priceupdate l_weight l_unit l_rop l_image l_drawing l_microfiche l_partsgroup

  my @simple_l_switches    = (@all_columns, qw(notes listprice sellprice lastcost priceupdate weight unit rop image));

  my @sort_cols    = (@simple_filters, qw(id priceupdate onhand invnumber ordnumber quonumber name serialnumber soldtotal deliverydate));

           p.unit, p.notes,

    # when a purchase invoice is opened from the report of purchase invoices

        p.partnumber, p.inventory_accno_id AS part_inventory_accno_id,  pr.projectnumber, pg.partsgroup

         p.unit, p.assembly, p.onhand, p.formel,

           p.partnumber, p.assembly, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,

         p.unit, p.assembly, p.onhand,

sub get_default_warehouse_id {

  my ($self) = @_;

  return ($self->{data}->{warehouse_id});

}

sub get_default_bin_id {

  my ($self) = @_;

  return ($self->{data}->{bin_id});

}

=item C<get_default_warehouse_id>

Returns the default warehouse_id

=item C<get_default_bin_id>

Returns the default bin_id

           o.sellprice, o.parts_id AS id, o.unit, o.discount, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id,

                   'vendors'       => 'ALL_VENDORS',

                   'warehouses'    => { 'key'    => 'WAREHOUSES',

                                        'bins'   => 'BINS', });

  # leerer wert für Lager und Lagerplatz korrekt einstellt

  # ID 0 sollte in Ordnung sein, da der Zähler sowieso höher ist

  my $no_default_bin_entry = { 'id' => '0', description => '--', 'BINS' => [ { id => '0', description => ''} ] };

  push @ { $form->{WAREHOUSES} }, $no_default_bin_entry;

  if (my $max = scalar @{ $form->{WAREHOUSES} }) {

    my $default_warehouse_id = $::instance_conf->get_default_warehouse_id;

    my $default_bin_id       = $::instance_conf->get_default_bin_id;

    $form->{warehouse_id} ||= $default_warehouse_id || $form->{WAREHOUSES}->[$max -1]->{id};

    $form->{bin_id}       ||= $default_bin_id       ||  $form->{WAREHOUSES}->[$max -1]->{BINS}->[0]->{id};

  }

  # undef warehouse_id if the empty value is selected

  if ( ($form->{warehouse_id} == 0) && ($form->{bin_id} == 0) ) {

    undef $form->{warehouse_id};

    undef $form->{bin_id};

  }

  '<b> I DO CARE!</b> Please check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue' => '<b>ICH KÜMMER MICH</b> Bitte haken Sie Lager und Lagerplätze erzeugen an (Automatisches Zuweisen der Lagerplätze) und vergeben einen Namen für dieses Lager (Lagerplätze werden automatisch übernommen). Danach auf weiter.',

  '<b> I DO CARE!</b> Please click back and cancel the update and come back after there has been at least one warehouse defined with bin(s).:' => '<b>ICH KÜMMER MICH</b> Brechen Sie das Update ab und legen selber mindestens ein Lager mit Lagerplätzen unter dem Menü System / Lager an.',

  '<b> I DO NOT CARE</b> Please click continue and the following data (see list) will be deleted:' => '<b>IST MIR EGAL</b> Mit einem Klick auf Weiter (rot) werden keine Daten übernommen, bzw. migriert und die folgende Information in der untenstehenden Liste wird gelöscht.',

  '<b>Automatically create new bins</b> in the following new warehouse ' => '<b>Automatisches Zuweisen der Lagerplätze</b> im folgenden neuem Lager:',

  '<b>Automatically create new bins</b> in the following warehouse if not selected in the list above' => '<b>Automatisches Zuweisen der Lagerplätze</b> im folgenden Lager, falls keine andere Zuweisung oben ausgewählt ist. ',

  '<b>Default Bins Migration !READ CAREFULLY!</b>' => 'Standardlagerplatz Migraition !AUFMERKSAM LESEN!',

  'AUTOMATICALLY MATCH BINS'    => 'LAGERPLÄTZE AUTOMATISCH ZUWEISEN',

  'Change default bin for this parts' => 'Standardlagerplatz für diese Waren ändern',

  'Default Bin'                 => 'Standard-Lagerplatz',

  'Default Warehouse'           => 'Standard-Lager',

  'If your old bins match exactly Bins in the Warehouse CLICK on <b>AUTOMATICALLY MATCH BINS</b>.' => 'Falls die alte Lagerplatz-Beschreibung in Stammdaten genau mit einem Lagerplatz in einem vorhandenem Lager übereinstimmt, KLICK auf <b>LAGERPLÄTZE AUTOMATISCH ZUORDNEN</b>',

  'Master Data Bin Text Deleted' => 'Gelöschte Stammdaten Freitext-Lagerplätze',

  'Otherwise you can simply check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue' => 'Andernfalls einfach Lager und Lagerplätze erschaffen anhaken und einen Namen für das Lager vergeben (Lagerplätze werden dann automatisch hinzugefügt) danach auf weiter',

  'The Bins in Inventory were only a information text field.' => 'Die Lagerplätze unter Stammdaten/Waren, sind nur ein informatives Textfeld.',

  'The Bins in master data were only a information text field.' => 'Die Lagerplätze unter Stammdaten/Waren, sind nur ein informatives Textfeld.',

  'There are Bins defined in your Inventory.' => 'Unter Stammdaten/Waren sind Lagerplätze defininert',

  'There are Bins defined in your master data.' => 'Unter Stammdaten/Waren sind Lagerplätze defininert',

  'This has been changed in this version, therefore please change the "old" bins to some real warehouse bins.' => 'Das wurde in dieser Version umgestellt, bitte ändern Sie die Freitext-Lagerplätze auf wirkliche Lagerplätze.',

  'This has been changed in this version.' => 'Ab dieser Version ist dies nicht mehr so.',

  'This is the default bin for parts' => 'Standard-Lagerplatz für Stammdaten/Waren',

  'Three Options:'              => 'Drei Optionen:',

  'Unfortunately you have no warehouse defined.' => 'Leider, gibt es kein Lager in diesem Mandanten.',

-- @tag: add_warehouse_defaults

-- @description: Standardlager und Lagerplatz in der Tabelle defaults. Sowie als ID-Verknüpfung in parts

-- @depends: release_3_0_0

-- @charset: utf-8

ALTER TABLE defaults ADD COLUMN warehouse_id integer references warehouse(id);

ALTER TABLE defaults add column bin_id integer references bin(id);

ALTER TABLE parts ADD COLUMN warehouse_id integer references warehouse(id);

ALTER TABLE parts add column bin_id integer references bin(id);

# @tag: default_bin_parts

# @description: Freitext Feld Lagerplatz nach Lager und Lagerplatz migrieren

# @depends: release_3_0_0 add_warehouse_defaults

package SL::DBUpgrade2::default_bin_parts;

use strict;

use utf8;

use Data::Dumper;

use SL::DBUtils;

use parent qw(SL::DBUpgrade2::Base);

sub run {

  my ($self) = @_;

  $::form->get_lists('warehouses' => { 'key'    => 'WAREHOUSES',

                                     'bins'   => 'BINS', });

  if (scalar @{ $::form->{WAREHOUSES} }) {

    $::form->{warehouse_id} ||= $::form->{WAREHOUSES}->[0]->{id};

    $::form->{bin_id}       ||= $::form->{WAREHOUSES}->[0]->{BINS}->[0]->{id};

  } else {

    $::form->{NO_WAREHOUSE} = 1;

  }

    $::form->{warehouse_id} = 0;    # 0 ist die ID für leere Option

  if ( $::form->{'continued'} ) {

    my $CREATE_BINS      = 0;

    my $CREATE_WAREHOUSE = 0;

    if (!defined($::form->{NO_WAREHOUSE}) && defined($::form->{create_new_bins}) && $::form->{warehouse_id_default}) {

      $CREATE_BINS = 1;

    }

    if (defined($::form->{NO_WAREHOUSE}) && defined($::form->{create_new_bins}) && $::form->{new_warehouse}) {

      $CREATE_WAREHOUSE = 1;

      $CREATE_BINS      = 1;

    }

    # Lager anlegen

    my $insert_warehouse_query = qq|INSERT into warehouse (description, invalid, sortkey) VALUES (?, 'false', 1) |;

    my $prepared_insert_warehouse_query   = $self->dbh->prepare($insert_warehouse_query)   || $self->db_error($insert_warehouse_query);

    # Lagerplatz anlegen

    my $insert_bin_query = qq|INSERT into bin (description, warehouse_id) VALUES (?, ?) |;

    my $prepared_insert_bin_query   = $self->dbh->prepare($insert_bin_query)   || $self->db_error($insert_bin_query);

    # Lagerplatz aus Liste zuweisen

    my $update_query = qq|UPDATE parts SET warehouse_id = ?, bin_id = ? WHERE id = ?|;

    my $prepared_update_query   = $self->dbh->prepare($update_query)   || $self->db_error($update_query);

    # gerade angelegten Lagerplatz zuweisen

    my $update_new_bin_query = qq|UPDATE parts SET warehouse_id = (SELECT warehouse_id from bin where description = ?),

                                           bin_id       = (SELECT id from bin where description       = ?)

                                           WHERE id = ?|;

    my $prepared_update_new_bin_query   = $self->dbh->prepare($update_new_bin_query)   || $self->db_error($update_new_bin_query);

    # kein lager vorhanden, aber wir legen ein neues an.

    if ($CREATE_WAREHOUSE && $CREATE_BINS) {

      $prepared_insert_warehouse_query->execute($::form->{new_warehouse}) || $self->db_error($insert_warehouse_query);

      $prepared_insert_warehouse_query->finish();

      my $query = qq|SELECT id FROM warehouse LIMIT 1;|;

      my $sth = $self->dbh->prepare($query);

      $sth->execute || $::form->dberror($query);

      $::form->{warehouse_id_default} = $sth->fetchrow_array();

    }

    foreach my $i (1 .. $::form->{rowcount}) {

      # Best Case: Lagerplatz aus Liste gewählt

      if ($::form->{"bin_id_$i"}) {

        $prepared_update_query->execute($::form->{"warehouse_id_$i"}, $::form->{"bin_id_$i"}, $::form->{"partid_$i"}) || $self->db_error($update_query);

      } elsif ($CREATE_BINS) {

        # Lager vorhanden, bzw. vorher erstellt.  alte bins automatisch hinzufügen und zum Standardlagerplatz verdrahten

        $prepared_insert_bin_query->execute($::form->{"bin_$i"}, $::form->{warehouse_id_default}) || $self->db_error($insert_bin_query);

        $prepared_update_new_bin_query->execute($::form->{"bin_$i"}, $::form->{"bin_$i"}, $::form->{"partid_$i"}) || $self->db_error($update_new_bin_query);

      }

    }

    $prepared_insert_bin_query->finish();

    $prepared_update_new_bin_query->finish();

    $prepared_update_query->finish();

    $::form->{FINISH} = 1;

    # das alte textfeld entfernen

    #my $query = qq|ALTER TABLE parts drop COLUMN bin|;

    #$self->db_query($query);

    #return 1;

  }

  my $query = qq|SELECT id, partnumber, description, bin

                   FROM parts pa

                   WHERE '' <> NULLIF ( bin, '')

                   ORDER BY partnumber;|;

  my $sth = $self->dbh->prepare($query);

  $sth->execute || $::form->dberror($query);

  $::form->{PARTS} = [ selectall_hashref_query($::form, $self->dbh, $query) ];

  if ( (scalar @{ $::form->{PARTS} } > 0 ) && !$::form->{NO_WAREHOUSE} && !$::form->{FINISH} )  {

    &print_error_message;

    return 2;

  } elsif ( (scalar @{ $::form->{PARTS} } > 0 ) && $::form->{NO_WAREHOUSE} && !$::form->{FINISH} ) {

    &print_error_message_no_warehouse;

    return 2;

  }

  # das alte textfeld entfernen

  # hier nochmal, da oben schon ein return 1 gesetzt ist

  my $query = qq|ALTER TABLE parts drop COLUMN bin|;

  $self->db_query($query);

  return 1;

}

sub print_error_message {

  print $::form->parse_html_template("dbupgrade/default_bin_parts");

}

sub print_error_message_no_warehouse {

  print $::form->parse_html_template("dbupgrade/default_bin_parts_no_warehouse");

}

1;

[%- USE T8 %]

[%- USE HTML %]

[%- USE LxERP %]

[%- USE JavaScript %]

 <script type="text/javascript" src="js/common.js"></script>

 <script type="text/javascript" src="js/parts_language_selection.js"></script>

 <script type="text/javascript">

  <!--

     warehouses = new Array();

     [%- USE WAREHOUSES_it = Iterator(WAREHOUSES) %][%- FOREACH warehouse = WAREHOUSES_it %]

      warehouses[[% WAREHOUSES_it.count - 1 %]] = new Array();

      warehouses[[% WAREHOUSES_it.count - 1 %]]['id'] = [% warehouse.id %];

      warehouses[[% WAREHOUSES_it.count - 1 %]]['bins'] = new Array();

      [% USE BINS_it = Iterator(warehouse.BINS) %][% FOREACH bin = BINS_it %]

      warehouses[[% WAREHOUSES_it.count - 1%]]['bins'][[% BINS_it.count - 1 %]] = new Array();

      warehouses[[% WAREHOUSES_it.count - 1%]]['bins'][[% BINS_it.count - 1 %]]['description'] = "[% JavaScript.escape(bin.description) %]";

      warehouses[[% WAREHOUSES_it.count - 1%]]['bins'][[% BINS_it.count - 1 %]]['id'] = [% bin.id %];

      [% END %]

      [% END %]

      //var rowcount = [% rowcount %];

      //var rowcount = 3; //[% rowcount %];

      function warehouse_selected(warehouse_id, bin_id, loop) {

        var control = document.getElementById("bin_id_" + loop);

        for (var i = control.options.length - 1; i >= 0; i--) {

          control.options[i] = null;

        }

        var warehouse_index = 0;

        for (i = 0; i < warehouses.length; i++)

          if (warehouses[i]['id'] == warehouse_id) {

            warehouse_index = i;

            break;

          }

        var warehouse = warehouses[warehouse_index];

        var bin_index = 0;

        for (i = 0; i < warehouse['bins'].length; i++)

          if (warehouse['bins'][i]['id'] == bin_id) {

            bin_index = i;

            break;

          }

        for (i = 0; i < warehouse['bins'].length; i++) {

          control.options[i] = new Option(warehouse['bins'][i]['description'], warehouse['bins'][i]['id']);

        }

        control.options[bin_index].selected = true;

      }

      function bin_match(rowcount) {

        for (i = 1; i < rowcount + 1; i++) {              // über alle parts_id

          var lagerplatz = document.getElementById("bin_" + i).value;

          var control = document.getElementById("bin_id_" + i);

          var bin_index = 0;

          //alert(lagerplatz);

          for (j = 0; j < warehouses.length; j++) {       // über alle lager

            var warehouse = warehouses[j];

            for (k = 0; k < warehouse['bins'].length; k++) {       // über alle lagerplätze

              if (lagerplatz == warehouse['bins'][k]['description']) {

                //alert('ware ' + warehouse['bins'][k]['description']);

                var lager = document.getElementById("warehouse_id_" + i);

                lager.selectedIndex = j;

                bin_index = k;

                break;

                /*var lagerplatz = document.getElementById("bin_id_" + i);

                alert('lagerplatz ' + lagerplatz.value);

                lagerplatz.selectedIndex = k; */

              }

            }

          }

        }

        for (i = 0; i < warehouse['bins'].length; i++) {

                control.options[i] = new Option(warehouse['bins'][i]['description'], warehouse['bins'][i]['id']);

              }

              control.options[bin_index].selected = true;

      }

      $(function() {

        warehouse_selected([% warehouse_id %], [% bin_id %]);

      })

    -->

 </script>

<div class="listtop">[% '<b>Default Bins Migration !READ CAREFULLY!</b>' | $T8 %]</div>

<form name="Form" method="post" action="login.pl">

<input type="hidden" name="action" value="login">

<input type="hidden" name="continued" value="1">

<p>[% 'There are Bins defined in your Inventory.' | $T8 %]</p>

<p>[% 'The Bins in Inventory were only a information text field.' | $T8 %]</p>

<p>[% 'This has been changed in this version, therefore please change the "old" bins to some real warehouse bins.' | $T8 %]</p>

<p>[% 'If your old bins match exactly Bins in the Warehouse CLICK on <b>AUTOMATICALLY MATCH BINS</b>.' | $T8 %]</p>

<p>[% 'Otherwise you can simply check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue'  | $T8 %]</p>

<p>[% 'Please change the partnumber of the following parts and run the update again:' | $T8 %]</p>

<table>

  <tr>

    <th class="listheading">[% 'Partnumber' | $T8 %]</th>

    <th class="listheading">[% 'Description' | $T8 %]</th>

    <th class="listheading">[% 'Bin' | $T8 %]</th>

    <th class="listheading">[% 'Default Warehouse' | $T8 %]</th>

    <th class="listheading">[% 'Default Bin' | $T8 %]</th>

  </tr>

  [% SET row_odd = '1' %][% FOREACH row = PARTS %]

  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">

   <td align="left"> [% HTML.escape(row.partnumber) %]</a></td>

    <td align="left"> [% HTML.escape(row.description) %]</a></td>

    <td align="right">[% HTML.escape(row.bin) %]

    <input type="hidden" id="bin_[% loop.count %]" name="bin_[% loop.count %]" value="[% HTML.escape(row.bin) %]">

    </td>

    <td>

    <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>

     <select id="warehouse_id_[% loop.count %]" name="warehouse_id_[% loop.count %]" onchange="warehouse_selected(warehouses[this.selectedIndex]['id'], 0, [% loop.count %])">

             [%- FOREACH warehouse = WAREHOUSES %]

               <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id  == warehouse.id %] selected[% END %]>[% warehouse.description %]</option>

             [%- END %]

                <option value=""  [% IF warehouse_id  == 0 %] selected[% END %] ></option>

     </select>

    </td>

    <td><select id="bin_id_[% loop.count %]" name="bin_id_[% loop.count %]"></select></td>

  </tr>

  [% SET rowcount = loop.count %]

  [% END %]

  <input type="hidden" name="rowcount" value="[% rowcount %]">

  <tr><td colspan="5"><hr/></td></tr>

  <tr><td colspan="5">

         <input type="checkbox" name="create_new_bins"> [% '<b>Automatically create new bins</b> in the following warehouse if not selected in the list above' | $T8 %]

          <select id="warehouse_id_default" name="warehouse_id_default">

             [%- FOREACH warehouse = WAREHOUSES %]

               <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id  == warehouse.id %] selected[% END %]>[% warehouse.description %]</option>

             [%- END %]

                <option value=""  [% IF warehouse_id  == 0 %] selected[% END %] ></option>

         </select>

      </td>

  </tr>

  <tr><td colspan="5"><hr/></td></tr>

 <tr><td><input type="button" class="submit" onclick="history.back()" value="[% 'Back' | $T8 %]"> </td><td colspan="3" align="center"><b><input style="background-color:#FFEE66" type="button" value="[% 'AUTOMATICALLY MATCH BINS' | $T8 %]"  onclick="bin_match([% rowcount %])"></b> </td><td><input type="submit" value="[% 'Continue' | $T8 %]"></td></tr>

</table>

</form>

[%- USE T8 %]

[%- USE HTML %]

[%- USE LxERP %]

<div class="listtop">[% '<b>Default Bins Migration !READ CAREFULLY!</b>' | $T8 %]</div>

<form name="Form" method="post" action="login.pl">

<input type="hidden" name="action" value="login">

<input type="hidden" name="continued" value="1">

<p>[% 'There are Bins defined in your master data.' | $T8 %]</p>

<p>[% 'The Bins in master data were only a information text field.' | $T8 %]</p>

<p>[% 'This has been changed in this version.' | $T8 %]</p>

<p>[% 'Unfortunately you have no warehouse defined.' | $T8 %]</p>

<p>[% 'Three Options:' | $T8 %]</p>

<p>[% '<b> I DO NOT CARE</b> Please click continue and the following data (see list) will be deleted:' | $T8 %]</p>

<p>[% '<b> I DO CARE!</b> Please click back and cancel the update and come back after there has been at least one warehouse defined with bin(s).:' | $T8 %]</p>

<p>[% '<b> I DO CARE!</b> Please check create warehouse and bins and define a name for the warehouse (Bins will be created automatically) and then continue'  | $T8 %]</p>

<table>

  <tr>

    <th class="listheading">[% 'Partnumber' | $T8 %]</th>

    <th class="listheading">[% 'Description' | $T8 %]</th>

    <th class="listheading">[% 'Master Data Bin Text Deleted' | $T8 %]</th>

  </tr>

  [% SET row_odd = '1' %][% FOREACH row = PARTS %]

  <tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]">

   <td align="left"> [% HTML.escape(row.partnumber) %]</a></td>

    <td align="left"> [% HTML.escape(row.description) %]</a></td>

    <td align="right">[% HTML.escape(row.bin) %]

    <input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'>

    <input type="hidden" id="bin_[% loop.count %]" name="bin_[% loop.count %]" value="[% HTML.escape(row.bin) %]">

   </tr>

  [% SET rowcount = loop.count %]

  [% END %]

  <input type="hidden" name="rowcount" value="[% rowcount %]">

<tr><td colspan="5"><hr/></td></tr>

<tr><td colspan="5"><input type="checkbox" name="create_new_bins"> [% '<b>Automatically create new bins</b> in the following new warehouse ' | $T8 %] <input type="text" name="new_warehouse"></td></tr>

<tr><td colspan="5"><hr/></td></tr>

<tr><td><input type="button" class="submit" onclick="history.back()" value="[% 'Back' | $T8 %]"> </td><td colspan="3" align="center"><td><input style="background-color:#FA1400" type="submit" value="[% 'Continue' | $T8 %]"></td></tr>

</table>

</form>

[[%- USE T8 %]

[% PROCESS 'common/select_warehouse_bin.html' %]

           <th align="right" nowrap="true">[% 'Default Warehouse' | $T8 %] [% HTML.escape(bin_id) %]</th>

           <td>

            <select name="warehouse_id" onchange="warehouse_selected(warehouses[this.selectedIndex]['id'], 0)">

             [%- FOREACH warehouse = WAREHOUSES %]

               <option value="[% HTML.escape(warehouse.id) %]"[% IF warehouse_id == warehouse.id %] selected[% END %]>[% warehouse.description %]</option>

             [%- END %]

            </select>

          </td>

          </tr>

          <tr>

           <th align="right" nowrap="true">[% 'Default Bin' | $T8 %]</th>

           <td><select id="bin_id" name="bin_id"></select></td>