Subversion Repositories SmartDukaan

<div class="col-lg-12">
    <table id="warehouseBrandItemStock" class="table table-striped table-advance table-hover">
        <thead>
        <tr>
            <th>W/H Name</th>
            <th>Item</th>
            <th>Unit Price</th>
            <th>Stock Qty</th>
            <th>Stock Value</th>
            <th>Pending Indent</th>
            <th>Tertiary</th>
            <th>&lt;10</th>
            <th><15</th>
            <th><20</th>
            <th>&gt;20</th>

        </tr>
        </thead>
        <tbody>
            #foreach($key in $warehouseWiseItemStock)
            <tr>
                <td>$key.getWarehouseName()</td>
                <td
                    #if($key.getD15to20() > 0 || $key.getD20to30() > 0 || $key.getDgt30() > 0))
                    style="color:red"
                    #elseif($key.getD10to15() > 0)
                    style="color:lightsalmon"
                    #end
                >$key.getBrand() $key.getModelName() $key.getModelNumber() $key.getColor()</td>
                <td>$key.getUnitPrice()</td>
                <td>$key.getStockQty()</td>
                <td class="currency">$key.getStockValue()</td>
                <td class="pendingIndent" data-itemid="$key.getItemId()" data-warehouseid="$key.getWarehouseId()"
                    data-toggle="modal" data-target="#pendingIndentItem">$key.getPendingIndent()</td>
                <td>$key.getTertiary()</td>
                <td>$key.getDlt10()</td>
                <td>$key.getD10to15()</td>
                <td>$key.getD15to20()</td>
                <td>$key.getDgt20()</td>
            </tr>
            #end

        </tbody>
    </table>
</div>

<div id="pendingIndentItem" class="modal" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">

        </div>
    </div>
</div>

<script type="text/javascript">
    $(document).ready(function () {

        $('#warehouseBrandItemStock thead tr').clone(true).appendTo('#warehouseBrandItemStock thead');
        $('#warehouseBrandItemStock thead tr:eq(1) th').each(function (i) {
            var title = $(this).text();
            $(this).html('<input type="text" style = "width:60%;" placeholder="Search ' + title + '" />');

            $('input', this).on('keyup change', function () {
                if (table.column(i).search() !== this.value) {
                    table
                            .column(i)
                            .search(this.value)
                            .draw();
                }
            });
        })

        // Totals row appended at the bottom of thead — sits directly above the tbody data
        // and stays visible thanks to fixedHeader. Refilled on every draw via drawCallback,
        // so it reflects the current search/filter state.
        var whbTotalsRow = '<tr class="whbTotalsRow" style="background:#eef;font-weight:700;">';
        for (var c = 0; c < 11; c++) {
            whbTotalsRow += '<th class="whbTotalCell" data-col-idx="' + c + '"></th>';
        }
        whbTotalsRow += '</tr>';
        $('#warehouseBrandItemStock thead').append(whbTotalsRow);

        // Numeric columns to sum across all filtered rows.
        var whbSumCols = [2, 3, 4, 5, 6, 7, 8, 9, 10];

        var table = $('#warehouseBrandItemStock').DataTable({
            orderCellsTop: true,
            fixedHeader: true,
            drawCallback: function () {
                var api = this.api();
                var whbTotalCells = jQuery('#warehouseBrandItemStock .whbTotalCell');
                whbTotalCells.text('');
                whbTotalCells.filter('[data-col-idx="0"]').text('Totals');
                whbSumCols.forEach(function (idx) {
                    var sum = api.column(idx, {search: 'applied'}).data()
                            .reduce(function (a, b) {
                                var s = (b == null ? '' : String(b)).replace(/[,\s]/g, '');
                                var n = parseFloat(s);
                                return a + (isNaN(n) ? 0 : n);
                            }, 0);
                    whbTotalCells.filter('[data-col-idx="' + idx + '"]').text(
                            sum.toLocaleString('en-IN', {maximumFractionDigits: 0})
                    );
                });
            }
        });
    });


</script>

<script type="text/javascript">

    $('#warehouseBrandItemStock').on('click', '.pendingIndent', function () {
        var itemId = $(this).data('itemid');
        var warehouseId = $(this).data('warehouseid');


        doGetAjaxRequestHandler(context + "/getPartnerPendingIndentItem?itemId="
                + itemId + "&warehouseId=" + warehouseId, function (response) {

            $('#pendingIndentItem .modal-content').html(response);

        });
    });
</script>