templates/webpages/wh/report_filter.html

   1 [%- USE T8 %]
   2 [%- USE L %]
   3 [%- USE P %]
   4 [%- USE LxERP %]
   5 [%- USE HTML %][%- USE JavaScript %]
   6 <h1>[% 'Report about warehouse contents' | $T8 %]</h1>
   7
   8  <script type="text/javascript">
   9    <!--
  10       warehouses = new Array();
  11       warehouses[0] = new Array();
  12       warehouses[0]['id'] = "0";
  13       warehouses[0]['bins'] = new Array();
  14       warehouses[0]['bins'][0] = new Array();
  15       warehouses[0]['bins'][0]['description'] = "---";
  16       warehouses[0]['bins'][0]['id'] = "";
  17       [%- USE WAREHOUSES_it = Iterator(WAREHOUSES) %][%- FOREACH warehouse = WAREHOUSES_it %]
  18       warehouses[[% WAREHOUSES_it.count %]] = new Array();
  19       warehouses[[% WAREHOUSES_it.count %]]['id'] = [% warehouse.id %];
  20       warehouses[[% WAREHOUSES_it.count %]]['bins'] = new Array();
  21       warehouses[[% WAREHOUSES_it.count %]]['bins'][0] = new Array();
  22       warehouses[[% WAREHOUSES_it.count %]]['bins'][0]['description'] = "---";
  23       warehouses[[% WAREHOUSES_it.count %]]['bins'][0]['id'] = "";
  24       [% USE BINS_it = Iterator(warehouse.BINS) %][% FOREACH bin = BINS_it %]
  25       warehouses[[% WAREHOUSES_it.count %]]['bins'][[% BINS_it.count %]] = new Array();
  26       warehouses[[% WAREHOUSES_it.count %]]['bins'][[% BINS_it.count %]]['description'] = "[% JavaScript.escape(bin.description) %]";
  27       warehouses[[% WAREHOUSES_it.count %]]['bins'][[% BINS_it.count %]]['id'] = [% bin.id %];
  28       [% END %]
  29       [% END %]
  30
  31       function warehouse_selected(warehouse_id, bin_id) {
  32         var control = document.getElementById("bin_id");
  33
  34         for (var i = control.options.length - 1; i >= 0; i--) {
  35           control.options[i] = null;
  36         }
  37
  38         var warehouse_index = 0;
  39
  40         for (i = 0; i < warehouses.length; i++)
  41           if (warehouses[i]['id'] == warehouse_id) {
  42             warehouse_index = i;
  43             break;
  44           }
  45
  46         var warehouse = warehouses[warehouse_index];
  47         var bin_index = 0;
  48
  49         for (i = 0; i < warehouse['bins'].length; i++)
  50           if (warehouse['bins'][i]['id'] == bin_id) {
  51             bin_index = i;
  52             break;
  53           }
  54
  55         for (i = 0; i < warehouse['bins'].length; i++) {
  56           control.options[i] = new Option(warehouse['bins'][i]['description'], warehouse['bins'][i]['id']);
  57         }
  58
  59
  60         control.options[bin_index].selected = true;
  61       }
  62
  63       $(function () {
  64         warehouse_selected(0, 0);
  65         document.Form.partnumber.focus();
  66       });
  67      -->
  68  </script>
  69
  70  <form method="post" name="Form" action="wh.pl" id="form">
  71
  72   <input type="hidden" name="nextsub" value="generate_report">
  73
  74    <table>
  75     <tr>
  76      <th class="listheading" align="left" valign="top" colspan="6" nowrap>[% 'Filter' | $T8 %]</th>
  77     </tr>
  78
  79     <tr>
  80      <td>
  81       <table>
  82        <tr>
  83         <th align="right" nowrap>[% 'Warehouse' | $T8 %]:</th>
  84         <td>
  85          <select name="warehouse_id" id="warehouse_id" onchange="warehouse_selected(warehouses[this.selectedIndex]['id'], 0)">
  86           <option value="">---</option>
  87           [%- FOREACH warehouse = WAREHOUSES %]
  88           <option value="[% HTML.escape(warehouse.id) %]">[% warehouse.description %]</option>
  89           [%- END %]
  90          </select>
  91         </td>
  92        </tr>
  93        <tr>
  94         <th align="right" nowrap>[% 'Bin' | $T8 %]:</th>
  95         <td><select name="bin_id" id="bin_id"></select></td>
  96        </tr>
  97        <tr>
  98         <th align="right" nowrap>[% 'Part Number' | $T8 %]:</th>
  99         <td><input name="partnumber" size=20 value="[% partnumber %]"></td>
 100        </tr>
 101        <tr>
 102         <th align="right" nowrap>[% 'Parts Classification' | $T8 %]:</th>
 103         <td>[% P.part.select_classification('classification_id') %]</td>
 104        </tr>
 105        <tr>
 106         <th align="right" nowrap>[% 'Part Description' | $T8 %]:</th>
 107         <td><input name="description" size=40></td>
 108        </tr>
 109        <tr>
 110         <th align="right" nowrap>[% 'Charge Number' | $T8 %]:</th>
 111         <td><input name="chargenumber" size=40></td>
 112        </tr>
 113        [% IF INSTANCE_CONF.get_show_bestbefore %]
 114        <tr>
 115         <th align="right" nowrap>[% 'Best Before' | $T8 %]:</th>
 116         <td>
 117           [% L.date_tag('bestbefore') %]
 118         </td>
 119        </tr>
 120        [% END %]
 121        <tr>
 122         <th align="right" nowrap>[% 'Qty in stock' | $T8 %]:</th>
 123         <td>
 124          <select name="qty_op">
 125           <option value="dontcare">---</option>
 126           <option value="atleast">[% 'At least' | $T8 %]</option>
 127           <option value="atmost">[% 'At most' | $T8 %]</option>
 128           <option value="exact">[% 'Exact' | $T8 %]</option>
 129          </select>
 130          <input name="qty">
 131          <select name="qty_unit">
 132           [%- FOREACH unit = UNITS %]<option>[% unit.name %]</option>[% END %]
 133          </select>
 134         </td>
 135        </tr>
 136        <tr>
 137         <th align="right" nowrap>[% 'Stock Qty for Date' | $T8 %]:</th>
 138         <td>[% L.date_tag('date') %]</td>
 139        </tr>
 140         <tr>
 141         <th align="right">
 142           [% "basis for stock value" | $T8 %]:
 143         </th>
 144         <td align="left">
 145          [% L.radio_button_tag("stock_value_basis", value='purchase_price', checked=1, label=LxERP.t8('Purchase price')) %]
 146          [% L.radio_button_tag("stock_value_basis", value='list_price',     checked=0, label=LxERP.t8('List Price')) %]
 147         </td>
 148        </tr>
 149        <tr>
 150         <th align="right">
 151           [% "List all rows" | $T8 %]:
 152         </th>
 153         <td align="left">
 154          [% L.yes_no_tag("allrows", 1) %]
 155         </td>
 156        </tr>
 157        <tr>
 158         <th align="right">
 159           [% "Results per page" | $T8 %]:
 160         </th>
 161         <td align="left">
 162          [% L.input_number_tag("per_page", 20, size=4) %]
 163         </td>
 164        </tr>
 165       </table>
 166      </td>
 167     </tr>
 168
 169     <tr height="5"><td>&nbsp;</td></tr>
 170
 171     <tr>
 172      <th class="listheading" align="left" valign="top" colspan="6" nowrap>[% 'Include in Report' | $T8 %]</th>
 173     </tr>
 174
 175     <tr>
 176      <td>
 177       <input name="l_partdescription" type="hidden" value="Y">
 178       <input name="l_qty" type="hidden" value="Y">
 179
 180       <table>
 181        <tr>
 182         <td align="right"><input name="l_warehousedescription" id="l_warehousedescription" class="checkbox" type="checkbox" value="Y" checked></td>
 183         <td nowrap><label for="l_warehousedescription">[% 'Warehouse' | $T8 %]</label></td>
 184         <td align="right"><input name="l_bindescription" id="l_bindescription" class="checkbox" type="checkbox" value="Y" checked></td>
 185         <td nowrap><label for="l_bindescription">[% 'Bin' | $T8 %]</label></td>
 186        </tr>
 187
 188        <tr>
 189         <td align="right"><input name="l_partnumber" id="l_partnumber" class="checkbox" type="checkbox" value="Y" checked></td>
 190         <td nowrap><label for="l_partnumber">[% 'Part Number' | $T8 %]</label></td>
 191         <td align="right"><input name="l_chargenumber" id="l_chargenumber" class="checkbox" type="checkbox" value="Y" checked></td>
 192         <td nowrap><label for="l_chargenumber">[% 'Charge Number' | $T8 %]</label></td>
 193         [% IF INSTANCE_CONF.get_show_bestbefore %]
 194         <td align="right"><input name="l_bestbefore" id="l_bestbefore" class="checkbox" type="checkbox" value="Y" checked></td>
 195         <td nowrap><label for="l_bestbefore">[% 'Best Before' | $T8 %]</label></td>
 196         [% END %]
 197        </tr>
 198
 199        <tr><td colspan="6"><hr noshade height="1"></td></tr>
 200
 201        <tr>
 202         <td align="right"><input name="subtotal" id="subtotal" class="checkbox" type="checkbox" value="Y"></td>
 203         <td nowrap><label for="subtotal">[% 'Subtotal' | $T8 %]</label></td>
 204         <td align="right"><input name="include_empty_bins" id="include_empty_bins" class="checkbox" type="checkbox" value="Y"></td>
 205         <td nowrap><label for="include_empty_bins">[% 'Include empty bins' | $T8 %]</label></td>
 206         <td align="right"><input name="include_invalid_warehouses" id="include_invalid_warehouses" class="checkbox" type="checkbox" value="Y"></td>
 207         <td nowrap><label for="include_invalid_warehouses">[% 'Include invalid warehouses ' | $T8 %]</label></td>
 208        </tr>
 209
 210        <tr>
 211         <td align="right"><input name="l_stock_value" id="l_stock_value" class="checkbox" type="checkbox" value="Y"></td>
 212         <td nowrap><label for="l_stock_value">[% 'Stock value' | $T8 %]</label></td>
 213         <td align="right"><input name="l_purchase_price" id="l_purchase_price" class="checkbox" type="checkbox" value="Y"></td>
 214         <td nowrap><label for="l_purchase_price">[% 'Purchase price' | $T8 %]</label></td>
 215         <td align="right"><input name="l_list_price" id="l_list_price" class="checkbox" type="checkbox" value="Y"></td>
 216         <td nowrap><label for="l_list_price">[% 'List Price' | $T8 %]</label></td>
 217        </tr>
 218        [% IF INCLUDABLE_CVAR_CONFIGS %]
 219          <tr><td colspan="6"><hr noshade height="1"></td></tr>
 220          [% FOREACH cvar_cfg = INCLUDABLE_CVAR_CONFIGS %]
 221          <tr>
 222           <td colspan="2" align="left">
 223            [% name__ = cvar_cfg.name;
 224             L.checkbox_tag("l_cvar_" _ name__, value="1", checked=(cvar_cfg.included_by_default ? 1 : ''), label=cvar_cfg.description) %]
 225           </td>
 226          </tr>
 227          [% END %]
 228        [% END %]
 229       </table>
 230      </td>
 231     </tr>
 232    </table>
 233  </form>